CancelDeleteConfiguredWorkOrders

Cancel Delete Configured Work Orders

Minor Business Rule

Object Name: N3201800

Parent DLL: CMFG

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose
The Business Function will perform deletion of F4801 record(s) and call supportive function to delete record(s) in F3201 as well as cleanup of F4211
and F4801 to make sure a deleted Work Order Number is not referenced. If deletion fails, B3201470 cache is loaded (mode 2 only) with a negative
ConfigurationID and no deletion nor cleanup is performed.

1.2Setup Notes and Prerequisites
The job number needs to be provided.

1.3Special Logic
None

2.Technical Specifications

2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes JOBSJob NumberIRCache Job Number CFGIDmnConfigurationIDNumberIR EV01cModeIR1
one WO was deleted perform cleanup of  F4211 and F4801;  2 all Wos were deleted, perform cleanup of F4211 SYszSystemCodeIRExpecting
48 ACTNcActionCodeIRD for deletion, C for cancel DOCOmnDocumentNumberIO/R*Required for mode 1 only DCTOszDocumentTypeIO/R*Required for mode 1
only KCOOszCompanyKeyIO SFXOszSOOrderSuffixIO LNIDmnLineNumberIO/R*Required for mode 1
only SUPPScSuppressErrorMessageIO DTAIszErrorMessageIDOO

2.2Related Tables
Table Table Description F4801

2.3Related Business Functions
Source NameFunction Name B3201470CacheProcessConfigurationID N3201870DeleteF3201Records B3201880CleanupCfgRelatedOrders X4801

2.4Processing
If cActionCode == D
   Call F4801BeginDocument
End If
If cMode   == 1
   If cActionCode == C
      Call N3104330 to update status code in F4801
   Else
      Call N3201670 to load B3201470 cache from F3201
      Call F4801EditLine
       If Error GT Zero
          Load BF Error Message
       Else
          Call F4801EndDocument in Interactive Mode
          Call B3201880 to cleanup F4211 and F4801 tables
          Call N3201870 to delete F3201 records
          Kill B3201470 Cache
       End If
   End If
Else
   Call N3201670 to load B3201470 cache from F3201
    While NO Error
       Read B3201470 record
       If No Error
          If cActionCode == C
             Call N3104330 to update status code in F4801
          Else
             Call F4801EditLine
             If Error GT Zero
                Save record in B3201470 using Negative CFGID
                Load BF Error Message
             End If
          End If
       End If
    End While Loop
    If cActionCode == D
       If BF Error Message LT OR EQ BLANK
          If cMode != 1
             Call F4801EndDoc in Batch Mode
             Call B3201880 to cleanup F4211 and F4801 tables
             Call N3201870 to delete F3201 records
             Call B3201470 to delete records for Positive CFGID
          End If
       End If
    Else
   Kill b3201470 Cache
End If
End If

3.2 Where Used: APPs/UBEs/NERs/BSFNs

Application/Business FunctionApplication/BF Name P3201

Data Structure

D3201800 - Cancel Delete Configured Work Orders

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnJobnumberA JOBS MATH_NUMERIC REQ INPUT

The job number (work station ID) which executed the particular job.

cActionCode ACTN char REQ INPUT

A code that specifies the action that is performed. Valid values are: A Add C Change

cSuppressErrorMessages SUPP char OPT INPUT

This field allows you to control the printing of the exception report. Valid values are:    Blank Print all records    1       Print warnings and errors
2       Print errors only    3       Do not print the report

szErrorMessageID DTAI char OPT OUTPUT

A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

mnConfigurationIDNumber CFGID MATH_NUMERIC REQ INPUT

An identifier that represents a unique configuration. It is generated by a next number value and is the key to the configuration tables.

szProductCode SY char REQ INPUT

A user defined code (98/SY) that identifies a system. Valid values include: 01 Address Book 03B Accounts Receivable 04 Accounts
Payable 09 General Accounting 11 Multicurrency

szStatusCodeWo SRST char OPT INPUT

A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from
90 through 99  triggers the system to automatically update the completion date.

mnDocumentNumber DOCO MATH_NUMERIC OPT INPUT

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

szDocumentType DCTO char OPT INPUT

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

szCompanyKey KCOO char OPT INPUT

A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document.

mnLineNumber LNID MATH_NUMERIC OPT INPUT

A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
this number,but in some cases you can override it.

szOrderSuffix SFXO char OPT INPUT

In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
multiple transactions for an original order. For purchase orders, the code is always 000. For sales orders with multiple partial receipts against an
order, the first receiver used to record receipt has a suffix of 000, the next has a suffix of 001, the next 002, and so on.

cMode EV01 char REQ INPUT

An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnJobnumberA	JOBS	MATH_NUMERIC	REQ	INPUT
The job number (work station ID) which executed the particular job.
cActionCode	ACTN	char	REQ	INPUT
A code that specifies the action that is performed. Valid values are: A Add C Change
cSuppressErrorMessages	SUPP	char	OPT	INPUT
This field allows you to control the printing of the exception report. Valid values are: Blank Print all records 1 Print warnings and errors 2 Print errors only 3 Do not print the report
szErrorMessageID	DTAI	char	OPT	OUTPUT
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
mnConfigurationIDNumber	CFGID	MATH_NUMERIC	REQ	INPUT
An identifier that represents a unique configuration. It is generated by a next number value and is the key to the configuration tables.
szProductCode	SY	char	REQ	INPUT
A user defined code (98/SY) that identifies a system. Valid values include: 01 Address Book 03B Accounts Receivable 04 Accounts Payable 09 General Accounting 11 Multicurrency
szStatusCodeWo	SRST	char	OPT	INPUT
A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from 90 through 99 triggers the system to automatically update the completion date.
mnDocumentNumber	DOCO	MATH_NUMERIC	OPT	INPUT
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.
szDocumentType	DCTO	char	OPT	INPUT
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
szCompanyKey	KCOO	char	OPT	INPUT
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to assign a next number. In this case, you probably would not use the order company to locate the document.
mnLineNumber	LNID	MATH_NUMERIC	OPT	INPUT
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns this number,but in some cases you can override it.
szOrderSuffix	SFXO	char	OPT	INPUT
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies multiple transactions for an original order. For purchase orders, the code is always 000. For sales orders with multiple partial receipts against an order, the first receiver used to record receipt has a suffix of 000, the next has a suffix of 001, the next 002, and so on.
cMode	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.