588: x_progress varchar2(240);
589: l_shipped_date DATE;
590:
591: begin
592: x_user_id := fnd_global.user_id;
593:
594: begin
595: SELECT HR.PERSON_ID
596: INTO x_employee_id
880: -- l_receipt_source_code varchar2(100) := 'VENDOR';
881: -- x_shipment_line_id number :=0; -- to delete
882:
883: begin
884: x_user_id := fnd_global.user_id;
885:
886: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE x_source_type_code:' || x_source_type_code);
887:
888: if (x_source_type_code = 'ASN') then
1424: X_vendor_site_id rcv_transactions_interface.vendor_site_id%type;
1425:
1426: begin
1427:
1428: X_created_by := fnd_global.user_id;
1429: x_last_update_login := fnd_global.user_id;
1430:
1431: BEGIN
1432: SELECT HR.PERSON_ID
1425:
1426: begin
1427:
1428: X_created_by := fnd_global.user_id;
1429: x_last_update_login := fnd_global.user_id;
1430:
1431: BEGIN
1432: SELECT HR.PERSON_ID
1433: INTO x_employee_id
1696:
1697: x_progress := '001 calling txn_processor for group=' || to_char(X_group_id);
1698: asn_debug.put_line(x_progress);
1699:
1700: x_user_id := fnd_global.user_id;
1701: x_resp_id := fnd_global.resp_id;
1702: x_appl_id := fnd_global.resp_appl_id;
1703:
1704: fnd_global.APPS_INITIALIZE (X_user_id, X_resp_id, x_appl_id);
1697: x_progress := '001 calling txn_processor for group=' || to_char(X_group_id);
1698: asn_debug.put_line(x_progress);
1699:
1700: x_user_id := fnd_global.user_id;
1701: x_resp_id := fnd_global.resp_id;
1702: x_appl_id := fnd_global.resp_appl_id;
1703:
1704: fnd_global.APPS_INITIALIZE (X_user_id, X_resp_id, x_appl_id);
1705:
1698: asn_debug.put_line(x_progress);
1699:
1700: x_user_id := fnd_global.user_id;
1701: x_resp_id := fnd_global.resp_id;
1702: x_appl_id := fnd_global.resp_appl_id;
1703:
1704: fnd_global.APPS_INITIALIZE (X_user_id, X_resp_id, x_appl_id);
1705:
1706: -- Code for setting the org context same as the org id from PO
1700: x_user_id := fnd_global.user_id;
1701: x_resp_id := fnd_global.resp_id;
1702: x_appl_id := fnd_global.resp_appl_id;
1703:
1704: fnd_global.APPS_INITIALIZE (X_user_id, X_resp_id, x_appl_id);
1705:
1706: -- Code for setting the org context same as the org id from PO
1707: asn_debug.put_line('call_txn_processor x_group_id:' || x_group_id);
1708:
1792: r_val16, r_val17, r_val18, r_val19, r_val20
1793: );
1794: x_output_message := r_val1;
1795:
1796: IF (r_val2 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val2; END IF;
1797: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1798: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1799: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1800: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1793: );
1794: x_output_message := r_val1;
1795:
1796: IF (r_val2 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val2; END IF;
1797: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1798: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1799: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1800: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1801: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1794: x_output_message := r_val1;
1795:
1796: IF (r_val2 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val2; END IF;
1797: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1798: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1799: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1800: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1801: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1802: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1795:
1796: IF (r_val2 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val2; END IF;
1797: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1798: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1799: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1800: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1801: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1802: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1803: IF (r_val9 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val9; END IF;
1796: IF (r_val2 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val2; END IF;
1797: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1798: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1799: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1800: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1801: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1802: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1803: IF (r_val9 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val9; END IF;
1804: IF (r_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1797: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1798: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1799: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1800: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1801: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1802: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1803: IF (r_val9 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val9; END IF;
1804: IF (r_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1805: IF (r_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;
1798: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1799: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1800: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1801: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1802: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1803: IF (r_val9 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val9; END IF;
1804: IF (r_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1805: IF (r_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;
1806: IF (r_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1799: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1800: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1801: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1802: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1803: IF (r_val9 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val9; END IF;
1804: IF (r_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1805: IF (r_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;
1806: IF (r_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1807: IF (r_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;
1800: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1801: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1802: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1803: IF (r_val9 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val9; END IF;
1804: IF (r_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1805: IF (r_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;
1806: IF (r_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1807: IF (r_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;
1808: IF (r_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1801: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1802: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1803: IF (r_val9 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val9; END IF;
1804: IF (r_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1805: IF (r_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;
1806: IF (r_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1807: IF (r_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;
1808: IF (r_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1809: IF (r_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1802: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1803: IF (r_val9 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val9; END IF;
1804: IF (r_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1805: IF (r_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;
1806: IF (r_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1807: IF (r_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;
1808: IF (r_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1809: IF (r_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1810: IF (r_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1803: IF (r_val9 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val9; END IF;
1804: IF (r_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1805: IF (r_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;
1806: IF (r_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1807: IF (r_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;
1808: IF (r_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1809: IF (r_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1810: IF (r_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1811: IF (r_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1804: IF (r_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1805: IF (r_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;
1806: IF (r_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1807: IF (r_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;
1808: IF (r_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1809: IF (r_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1810: IF (r_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1811: IF (r_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1812: IF (r_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1805: IF (r_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;
1806: IF (r_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1807: IF (r_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;
1808: IF (r_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1809: IF (r_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1810: IF (r_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1811: IF (r_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1812: IF (r_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1813: IF (r_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;
1806: IF (r_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1807: IF (r_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;
1808: IF (r_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1809: IF (r_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1810: IF (r_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1811: IF (r_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1812: IF (r_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1813: IF (r_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;
1814: IF (r_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;
1807: IF (r_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;
1808: IF (r_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1809: IF (r_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1810: IF (r_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1811: IF (r_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1812: IF (r_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1813: IF (r_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;
1814: IF (r_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;
1815:
1808: IF (r_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1809: IF (r_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1810: IF (r_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1811: IF (r_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1812: IF (r_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1813: IF (r_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;
1814: IF (r_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;
1815:
1816: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');
1809: IF (r_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1810: IF (r_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1811: IF (r_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1812: IF (r_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1813: IF (r_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;
1814: IF (r_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;
1815:
1816: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');
1817: asn_debug.put_line('return 3 or error, msg=' || x_output_message);
1810: IF (r_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1811: IF (r_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1812: IF (r_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1813: IF (r_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;
1814: IF (r_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;
1815:
1816: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');
1817: asn_debug.put_line('return 3 or error, msg=' || x_output_message);
1818: /* for this error case, we change the rc