DBA Data[Home] [Help]

APPS.POR_RCV_ORD_SV dependencies on FND_GLOBAL

Line 592: x_user_id := fnd_global.user_id;

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

Line 883: x_user_id := fnd_global.user_id;

879: -- l_receipt_source_code varchar2(100) := 'VENDOR';
880: -- x_shipment_line_id number :=0; -- to delete
881:
882: begin
883: x_user_id := fnd_global.user_id;
884:
885: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE x_source_type_code:' || x_source_type_code);
886:
887: if (x_source_type_code = 'ASN') then

Line 1421: X_created_by := fnd_global.user_id;

1417: X_vendor_site_id rcv_transactions_interface.vendor_site_id%type;
1418:
1419: begin
1420:
1421: X_created_by := fnd_global.user_id;
1422: x_last_update_login := fnd_global.user_id;
1423:
1424: BEGIN
1425: SELECT HR.PERSON_ID

Line 1422: x_last_update_login := fnd_global.user_id;

1418:
1419: begin
1420:
1421: X_created_by := fnd_global.user_id;
1422: x_last_update_login := fnd_global.user_id;
1423:
1424: BEGIN
1425: SELECT HR.PERSON_ID
1426: INTO x_employee_id

Line 1692: x_user_id := fnd_global.user_id;

1688:
1689: x_progress := '001 calling txn_processor for group=' || to_char(X_group_id);
1690: asn_debug.put_line(x_progress);
1691:
1692: x_user_id := fnd_global.user_id;
1693: x_resp_id := fnd_global.resp_id;
1694: x_appl_id := fnd_global.resp_appl_id;
1695:
1696: fnd_global.APPS_INITIALIZE (X_user_id, X_resp_id, x_appl_id);

Line 1693: x_resp_id := fnd_global.resp_id;

1689: x_progress := '001 calling txn_processor for group=' || to_char(X_group_id);
1690: asn_debug.put_line(x_progress);
1691:
1692: x_user_id := fnd_global.user_id;
1693: x_resp_id := fnd_global.resp_id;
1694: x_appl_id := fnd_global.resp_appl_id;
1695:
1696: fnd_global.APPS_INITIALIZE (X_user_id, X_resp_id, x_appl_id);
1697:

Line 1694: x_appl_id := fnd_global.resp_appl_id;

1690: asn_debug.put_line(x_progress);
1691:
1692: x_user_id := fnd_global.user_id;
1693: x_resp_id := fnd_global.resp_id;
1694: x_appl_id := fnd_global.resp_appl_id;
1695:
1696: fnd_global.APPS_INITIALIZE (X_user_id, X_resp_id, x_appl_id);
1697:
1698: -- Code for setting the org context same as the org id from PO

Line 1696: fnd_global.APPS_INITIALIZE (X_user_id, X_resp_id, x_appl_id);

1692: x_user_id := fnd_global.user_id;
1693: x_resp_id := fnd_global.resp_id;
1694: x_appl_id := fnd_global.resp_appl_id;
1695:
1696: fnd_global.APPS_INITIALIZE (X_user_id, X_resp_id, x_appl_id);
1697:
1698: -- Code for setting the org context same as the org id from PO
1699: asn_debug.put_line('call_txn_processor x_group_id:' || x_group_id);
1700:

Line 1788: IF (r_val2 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val2; END IF;

1784: r_val16, r_val17, r_val18, r_val19, r_val20
1785: );
1786: x_output_message := r_val1;
1787:
1788: IF (r_val2 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val2; END IF;
1789: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1790: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1791: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1792: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;

Line 1789: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;

1785: );
1786: x_output_message := r_val1;
1787:
1788: IF (r_val2 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val2; END IF;
1789: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1790: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1791: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1792: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1793: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;

Line 1790: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;

1786: x_output_message := r_val1;
1787:
1788: IF (r_val2 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val2; END IF;
1789: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1790: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1791: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1792: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1793: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1794: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;

Line 1791: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;

1787:
1788: IF (r_val2 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val2; END IF;
1789: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1790: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1791: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1792: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1793: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1794: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1795: IF (r_val9 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val9; END IF;

Line 1792: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;

1788: IF (r_val2 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val2; END IF;
1789: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1790: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1791: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1792: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1793: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1794: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1795: 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_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;

Line 1793: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;

1789: IF (r_val3 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val3; END IF;
1790: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1791: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1792: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1793: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1794: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1795: 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_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1797: IF (r_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;

Line 1794: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;

1790: IF (r_val4 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val4; END IF;
1791: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1792: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1793: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1794: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1795: 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_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1797: 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_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;

Line 1795: IF (r_val9 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val9; END IF;

1791: IF (r_val5 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val5; END IF;
1792: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1793: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1794: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1795: 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_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1797: 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_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1799: IF (r_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;

Line 1796: IF (r_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;

1792: IF (r_val6 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val6; END IF;
1793: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1794: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1795: 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_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1797: 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_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1799: 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_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;

Line 1797: IF (r_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;

1793: IF (r_val7 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val7; END IF;
1794: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1795: 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_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1797: 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_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1799: 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_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1801: IF (r_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;

Line 1798: IF (r_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;

1794: IF (r_val8 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val8; END IF;
1795: 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_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1797: 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_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1799: 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_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1801: 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_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;

Line 1799: IF (r_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;

1795: 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_val10 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val10; END IF;
1797: 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_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1799: 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_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1801: 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_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1803: IF (r_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;

Line 1800: IF (r_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;

1796: 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_val11 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val11; END IF;
1798: 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_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;
1800: 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_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1802: 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_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1804: IF (r_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;

Line 1801: IF (r_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;

1797: 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_val12 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val12; END IF;
1799: 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_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1801: 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_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1803: 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_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1805: IF (r_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;

Line 1802: IF (r_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;

1798: 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_val13 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val13; END IF;
1800: 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_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1802: 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_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1804: 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_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;
1806: IF (r_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;

Line 1803: IF (r_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;

1799: 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_val14 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val14; END IF;
1801: 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_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1803: 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_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1805: 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_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;
1807:

Line 1804: IF (r_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;

1800: 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_val15 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val15; END IF;
1802: 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_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1804: 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_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;
1806: IF (r_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;
1807:
1808: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');

Line 1805: IF (r_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;

1801: 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_val16 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val16; END IF;
1803: 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_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1805: 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_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;
1807:
1808: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');
1809: asn_debug.put_line('return 3 or error, msg=' || x_output_message);

Line 1806: IF (r_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;

1802: 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_val17 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val17; END IF;
1804: 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_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;
1806: IF (r_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;
1807:
1808: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');
1809: asn_debug.put_line('return 3 or error, msg=' || x_output_message);
1810: /* for this error case, we change the rc