APPS.POR_RCV_ORD_SV dependencies on POR_RCV_ORD_SV

Line 1: package body POR_RCV_ORD_SV as

1: package body POR_RCV_ORD_SV as
2: /* $Header: PORRCVOB.pls 120.11 2011/01/12 02:46:16 chihchan ship $ */
3:
4: /*************************************************************
5: ** Public Function :

Line 886: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE x_source_type_code:' || x_source_type_code);

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
889: select shipment_header_id
890: into l_rcv_shipment_header_id

Line 895: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE l_rcv_shipment_header_id:' || l_rcv_shipment_header_id);

891: from rcv_shipment_lines
892: where shipment_line_id = X_rcv_shipment_line_id;
893: end if;
894:
895: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE l_rcv_shipment_header_id:' || l_rcv_shipment_header_id);
896:
897: begin
898: SELECT HR.PERSON_ID
899: INTO x_employee_id

Line 910: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE x_employee_id :' || x_employee_id );

906: WHEN others THEN
907: x_employee_id := 0;
908: END;
909:
910: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE x_employee_id :' || x_employee_id );
911:
912: SELECT POL.MATCHING_BASIS, POL.JOB_ID
913: INTO X_MATCHING_BASIS, X_JOB_ID
914: FROM PO_LINES_ALL POL, PO_DISTRIBUTIONS_ALL POD

Line 918: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE X_MATCHING_BASIS' || X_MATCHING_BASIS);

914: FROM PO_LINES_ALL POL, PO_DISTRIBUTIONS_ALL POD
915: WHERE POL.PO_LINE_ID = POD.PO_LINE_ID
916: AND POD.PO_DISTRIBUTION_ID = X_PO_DISTRIBUTION_ID;
917:
918: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE X_MATCHING_BASIS' || X_MATCHING_BASIS);
919:
920: If nvl(x_matching_basis, 'QUANTITY') = 'QUANTITY' then
921:
922: IF (x_item_id IS NULL) THEN

Line 951: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE X_receipt_qty' || X_receipt_qty || ' X_receipt_amt ' || X_receipt_amt);

947: X_receipt_amt := X_receipt_qty;
948: X_qty := null;
949: end if;
950:
951: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE X_receipt_qty' || X_receipt_qty || ' X_receipt_amt ' || X_receipt_amt);
952:
953: /* Insert the rows that were checked into RCV_TRANSACTIONS_INTERFACE */
954:
955: SELECT POD.DESTINATION_TYPE_CODE,

Line 1052: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE Inserting values in RCV_TRANSACTIONS_INTERFACE');

1048: POH.PO_HEADER_ID = x_po_header_id and
1049: POLL.LINE_LOCATION_ID = x_line_location_id and
1050: POD.PO_DISTRIBUTION_ID = X_po_distribution_id;
1051:
1052: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE Inserting values in RCV_TRANSACTIONS_INTERFACE');
1053:
1054: INSERT INTO RCV_TRANSACTIONS_INTERFACE (
1055: INTERFACE_TRANSACTION_ID,
1056: GROUP_ID,

Line 1743: if (por_rcv_ord_SV.check_group_id(X_group_id)) then

1739: x_progress := '003online call return=' || to_char(rc) || '; outcome='|| outcome;
1740: asn_debug.put_line(x_progress);
1741:
1742: if rc = 1 then
1743: if (por_rcv_ord_SV.check_group_id(X_group_id)) then
1744: fnd_message.set_name('FND', 'TM-TIMEOUT');
1745: x_str := fnd_message.get;
1746: fnd_message.clear;
1747:

Line 1766: IF (por_rcv_ord_SV.check_group_id(X_group_id)) THEN

1762: end if;
1763: end if;
1764: delete_rows := TRUE;
1765: elsif rc = 2 then
1766: IF (por_rcv_ord_SV.check_group_id(X_group_id)) THEN
1767:
1768:
1769: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
1770: x_str := fnd_message.get;

Line 1786: IF (por_rcv_ord_SV.check_group_id(X_group_id)) THEN

1782: end if;
1783: delete_rows := TRUE;
1784: elsif (rc = 3 or (outcome IN ('WARNING', 'ERROR'))) then
1785: asn_debug.put_line('return 3 from txn processor, or outcome='|| outcome);
1786: IF (por_rcv_ord_SV.check_group_id(X_group_id)) THEN
1787:
1788:
1789: rc1 := fnd_transaction.get_values (r_val1, r_val2, r_val3, r_val4, r_val5,
1790: r_val6, r_val7, r_val8, r_val9, r_val10,

Line 1842: por_rcv_ord_SV.cancel_pending_notifs(x_group_id);

1838: if (x_caller = 'WP4') then
1839: /** Since we have received over the web, we need to clean up any open
1840: notifications for the rows that belong to this group_id **/
1841:
1842: por_rcv_ord_SV.cancel_pending_notifs(x_group_id);
1843:
1844: end if;
1845: x_progress := '004, return 0 from txn processor';
1846: asn_debug.put_line(x_progress);

Line 1999: if (por_rcv_ord_SV.notif_is_active(wf_item_type,wf_item_key)) then

1995: fetch c1 into wf_item_key ;
1996: exit when c1%notfound;
1997:
1998:
1999: if (por_rcv_ord_SV.notif_is_active(wf_item_type,wf_item_key)) then
2000: WF_Engine.AbortProcess(wf_item_type,wf_item_key);
2001: end if;
2002:
2003: end loop;

Line 2018: x_progress := 'POR_RCV_ORD_SV.is_active-001';

2014: x_caller varchar2(3) := 'WP4';
2015:
2016:
2017: BEGIN
2018: x_progress := 'POR_RCV_ORD_SV.is_active-001';
2019:
2020: --Bug 4999072 Changed the query to reduce the memory usage
2021: SELECT WIAS.ACTIVITY_STATUS
2022: INTO x_act_status