F3411GetNextMessageRow

F3411 Get Next Message Row

Major Business Rule

Object Name: B3401180

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose

This business function will retrieve all the MPS/MRP/DRP Message rows from the F3411 table for a
given index/key number combination. This business function will provide records by either full or partial
key. Typically, this Business Function would be called once to get the first row. Then, it would be
called again (different mode) within a loop in the calling application to get the next record in the
table based on the key passed.

1.2Setup Notes and Prerequisites

• The user passes to the business function the number of key fields within the index that will be
used, and key values (full or partial):

'b7Keys = Number of keys in the index that should be used to retrieve the F3411 MPS/MRP/DRP
Message row information.

'a81 = UKID
'a82 = ITM, MCU, HCLD, MSGT, RRQJ
'a83 = DOCO, DCTO, KCOO
'a84 = MCU, ITM , MMCU, DRQJ
'a85 = ITM, MCU, DRQJ
'a86 = ITM, MMCU, HCLD, MSGT, RRQJ
'a87 = MMCU, ITM, DRQJ

Note: The Business Function will reference the index parameter to determine which key to use to read
the MPS/MRP/DRP Message table.

1.3Special Logic
Once F3411 processing is complete, two calls to FreeUserAndHrequest (Description: Memory, Free User
And Hrequest) in C4102A1 must be made by the user to close the F3411 table and free the pointer storage
location for both the hRequests. Pass in only the hRequest to this BsFn.None.

2.Technical Specifications
1. If the Input hRequest_1 is equal to 0 then perform an Opentable to get the request handle on
F3411. Store the request handle.

2. If the Input hRequest_1 is NOT equal to 0, retrieve the request handle stored in the first call.

3. If this is the first time the BsFn is called, perform a SelectKeyed operation to set the request's
file pointer to the same record.

4. Fetch a record using the record handle. If a record is found then return the field values of the
record.

Returns:
If record is found using the first request, Error Code = '0'
If record is not found using the first request, return "0002" in Error Message ID. (Record Not
Found) and set the Error Code to '2'
If Open tables failed, Error Code = '1'.
If any other errors occur, return '3143' to the error message.

^

Data Structure

D3401180 - F3411 Get Next Message Row

Data Item Data Structure DescriptionI/ORequiredNotes
GENLNG      hRequestF3411                  I/O      Required for all calls.
ITM            Short Item Number                  I/OY      Required if part of the index
MCU            Business Unit                  I/OY      Required if part of the index
HCLD            Hold Code                        I/OY      Required if part of the index
MSGT            Message Type                  I/OY      Required if part of the index
MSGA            Cleared (Y/N)                  OY      Returned to application
DRQJ            Requested Date                  OY      Returned to application
DOCO            Order Number                  OY      Returned to application
INT01            Keys                              IY      Required on first call only
ERRC            Error Code                        O      '0' - No errors
                                                                        '1' - Open table failed
                                                                        '2' - EOF
EV01            Suppress Error Message            IY      '1' to suppress errors.
DTAI            Error Message ID                  O
INT01            Index                         IY      '2' - Access by (ITM, MCU,
HCLD,
                                                                        MSGT, RRQJ)
RRQJ            Date Recommended Complete      I/OY      Required if part of the index
UKID            Unique ID                        I/OY      Required if part of the index
DCTO            Order Type                        I/OY      Required if part of the index
KCOO            Order No. Key Company            I/OY      Required if part of the index
MMCU            Branch/Plant                  I/OY      Required if part of the index

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
idhRequestF3411	GENLNG	ID	NONE	NONE
General purpose ID variable.
mnShortItemNumber	ITM	MATH_NUMERIC	NONE	NONE
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
szBusinessUnit	MCU	char	NONE	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
cHoldCode	HCLD	char	NONE	NONE
A code that is used in Distribution Requirements Planning/Master Production Schedule/Material Requirements Planning and capacity message files to indicate how the message is created and whether or not the message is on hold. Valid codes are: A System generated. M Manually entered. Not deleted by the sytem when replanning. Z A held message. Not deleted by the system when replanning.
cMessageType	MSGT	char	NONE	NONE
A code that distinguishes different messages generated in the Distribution Requirements Planning/Master Production Schedule/Material Requirements Planning system. Valid codes are: A Warning messages (user controlled) B Order and expedite C Cancel D Defer E Expedite F Frozen order (user controlled) G Increase order quantity to (user controlled) H Decrease rate quantity to I Increase rate quantity to L Decrease order quantity to (user controlled) M Manual reminder N Create rate O Order P Firm order S FPO adjustment suggestion T Past due order
cCleared	MSGA	char	NONE	NONE
A code to indicate which messages should be displayed. A Y code will display all messages, including those that have been cleared or processed, but not those already deleted. Any value other than Y will display current messages only.
jdRequestedDate	DRQJ	JDEDATE	NONE	NONE
The date that an item is scheduled to arrive or that an action is scheduled for completion.
mnOrderNumber	DOCO	MATH_NUMERIC	NONE	NONE
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.
nIndex	INT01	integer	NONE	NONE
Number of Days in Future to Query for Responses Due.
jdDateRecommendedComplet	RRQJ	JDEDATE	NONE	NONE
The completion date planned for this order.
nKeys	INT01	integer	NONE	NONE
Number of Days in Future to Query for Responses Due.
cErrorCode	ERRC	char	NONE	NONE
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
cSuppressErrorMessage	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	NONE	NONE
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.
mnUniqueKeyID	UKID	MATH_NUMERIC	NONE	NONE
This field is a unique number used to identify a record in a file.
szOrderType	DCTO	char	NONE	NONE
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
szOrderNumberKeyCompany	KCOO	char	NONE	NONE
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.
szBranchPlant	MMCU	char	NONE	NONE
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.

Related Functions

None

Related Tables

F3411 MPS/MRP/DRP Message File