[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);
295: EXCEPTION
296: WHEN OTHERS THEN
297: /* Bug 4773978: Removed the code to get currency conversion rate using currency conversion date
298: defined in PO, if currency conversion rate is not defined for the receipt date.
299: We have to error out the transaction in PO_INTERFACE_ERRORS table for the POs created
300: with invoice match set to 'Receipts', if currency conversion rate is not defined for
301: the receipt date. */
302: v_rate := fnd_api.g_miss_num;
303: /* Bug 4773978 end */
417:
418: --Bug 5230922. Changed the where clause. Previously it was matching
419: --po.interface_transaction_id = rcv_trx.interface_transaction_id
420: --that was wrong because rcv_trx.interface_transaction_id would be
421: --stored as interface_line_id in the table po_interface_errors
422: SELECT column_name, error_message_name
423: INTO x_column_name, x_message_name
424: FROM po_interface_errors po
425: WHERE po.interface_line_id = rcv_trx.interface_transaction_id; --Bug 5230922
420: --that was wrong because rcv_trx.interface_transaction_id would be
421: --stored as interface_line_id in the table po_interface_errors
422: SELECT column_name, error_message_name
423: INTO x_column_name, x_message_name
424: FROM po_interface_errors po
425: WHERE po.interface_line_id = rcv_trx.interface_transaction_id; --Bug 5230922
426:
427: /* Get the translated message for the
428: ** column that failed validation
526:
527: /* Fix for Bug 5498095
528: If the item is not express allowed in the destination organization
529: for an inventory destination receipt then an error message will be
530: inserted into po_interface errors.
531: */
532:
533: /* Bug: 5855096
534: We neeed to by pass the validation for allow_express_delivery flag
565:
566: /* Fix for bug 2706571
567: If the item is not stock enabled in the destination organization
568: for an inventory destination receipt then an error message will be
569: inserted into po_interface errors.
570: */
571:
572: if ( (rcv_trx.destination_type_code = 'INVENTORY' or
573: (rcv_trx.source_document_code = 'RMA' and
1813:
1814: ===========================================================================*/
1815:
1816: /*
1817: ** Insert into PO_INTERFACE_ERRORS table
1818: */
1819:
1820: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,
1821: X_column_name IN VARCHAR2,
1827:
1828: X_progress := '050';
1829:
1830: /* Bug 4773978: Added the following code for logging error messages
1831: in PO_INTERFACE_ERRORS table and removed the Insert
1832: statements to insert into PO_INTERFACE_ERRORS
1833: table, as the fields error_message, interface_line_id
1834: and interface_header_id are not populated. */
1835: RCV_ERROR_PKG.set_error_message(X_err_message);
1828: X_progress := '050';
1829:
1830: /* Bug 4773978: Added the following code for logging error messages
1831: in PO_INTERFACE_ERRORS table and removed the Insert
1832: statements to insert into PO_INTERFACE_ERRORS
1833: table, as the fields error_message, interface_line_id
1834: and interface_header_id are not populated. */
1835: RCV_ERROR_PKG.set_error_message(X_err_message);
1836: RCV_ERROR_PKG.log_interface_error(X_column_name,FALSE);