[Home] [Help]
54: done BOOLEAN := FALSE;
55: transaction_ok BOOLEAN := FALSE;
56: x_first_error BOOLEAN := TRUE;
57: X_progress VARCHAR2(4) := '000';
58: x_column_name po_interface_errors.column_name%type;
59: x_message_text fnd_new_messages.message_text%type;
60: x_message_name varchar2(30);
61: X_txn_from_web BOOLEAN := FALSE;
62: X_txn_from_wf BOOLEAN := FALSE;
134: X_progress := '030';
135:
136: -- po_line_locations_sv.lock_row (line_location_id);
137: /* Bug 4773978: Added the following code for logging error messages
138: in PO_INTERFACE_ERRORS table. */
139: RCV_ERROR_PKG.initialize(rcv_trx.transaction_type,
140: rcv_trx.group_id,
141: rcv_trx.header_interface_id,
142: rcv_trx.interface_transaction_id);
305: EXCEPTION
306: WHEN OTHERS THEN
307: /* Bug 4773978: Removed the code to get currency conversion rate using currency conversion date
308: defined in PO, if currency conversion rate is not defined for the receipt date.
309: We have to error out the transaction in PO_INTERFACE_ERRORS table for the POs created
310: with invoice match set to 'Receipts', if currency conversion rate is not defined for
311: the receipt date. */
312: v_rate := fnd_api.g_miss_num;
313: /* Bug 4773978 end */
427:
428: --Bug 5230922. Changed the where clause. Previously it was matching
429: --po.interface_transaction_id = rcv_trx.interface_transaction_id
430: --that was wrong because rcv_trx.interface_transaction_id would be
431: --stored as interface_line_id in the table po_interface_errors
432: SELECT column_name, error_message_name
433: INTO x_column_name, x_message_name
434: FROM po_interface_errors po
435: WHERE po.interface_line_id = rcv_trx.interface_transaction_id; --Bug 5230922
430: --that was wrong because rcv_trx.interface_transaction_id would be
431: --stored as interface_line_id in the table po_interface_errors
432: SELECT column_name, error_message_name
433: INTO x_column_name, x_message_name
434: FROM po_interface_errors po
435: WHERE po.interface_line_id = rcv_trx.interface_transaction_id; --Bug 5230922
436:
437: /* Get the translated message for the
438: ** column that failed validation
537:
538: /* Fix for Bug 5498095
539: If the item is not express allowed in the destination organization
540: for an inventory destination receipt then an error message will be
541: inserted into po_interface errors.
542: */
543:
544: /* Bug: 5855096
545: We neeed to by pass the validation for allow_express_delivery flag
576:
577: /* Fix for bug 2706571
578: If the item is not stock enabled in the destination organization
579: for an inventory destination receipt then an error message will be
580: inserted into po_interface errors.
581: */
582:
583: if ( (rcv_trx.destination_type_code = 'INVENTORY' or
584: (rcv_trx.source_document_code = 'RMA' and
1955:
1956: ===========================================================================*/
1957:
1958: /*
1959: ** Insert into PO_INTERFACE_ERRORS table
1960: */
1961:
1962: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,
1963: X_column_name IN VARCHAR2,
1969:
1970: X_progress := '050';
1971:
1972: /* Bug 4773978: Added the following code for logging error messages
1973: in PO_INTERFACE_ERRORS table and removed the Insert
1974: statements to insert into PO_INTERFACE_ERRORS
1975: table, as the fields error_message, interface_line_id
1976: and interface_header_id are not populated. */
1977: RCV_ERROR_PKG.set_error_message(X_err_message);
1970: X_progress := '050';
1971:
1972: /* Bug 4773978: Added the following code for logging error messages
1973: in PO_INTERFACE_ERRORS table and removed the Insert
1974: statements to insert into PO_INTERFACE_ERRORS
1975: table, as the fields error_message, interface_line_id
1976: and interface_header_id are not populated. */
1977: RCV_ERROR_PKG.set_error_message(X_err_message);
1978: RCV_ERROR_PKG.log_interface_error(X_column_name,FALSE);