85: if (x_po_header_id is null) then
86: return 1;
87: end if;
88:
89: x_user_org_id := MO_GLOBAL.get_current_org_id;
90:
91: for i in 1..x_po_header_id.count loop
92: l_lineLocationId := x_line_location_id(i);
93: l_qty := x_receipt_qty(i);
104: into x_txn_org_id
105: from po_line_locations_all poll
106: where line_location_id = l_lineLocationId;
107:
108: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
109: mo_global.set_policy_context(p_access_mode => 'S',
110: p_org_id => x_txn_org_id);
111: end if;
112: exception
105: from po_line_locations_all poll
106: where line_location_id = l_lineLocationId;
107:
108: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
109: mo_global.set_policy_context(p_access_mode => 'S',
110: p_org_id => x_txn_org_id);
111: end if;
112: exception
113: WHEN OTHERS THEN
334: x_progress := 'groupPoTransaction 030 returning successfully';
335:
336: asn_debug.put_line(x_progress);
337: asn_debug.put_line('1 x_txn_org_id:' || x_txn_org_id || 'x_user_org_id:' || x_user_org_id);
338: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
339: asn_debug.put_line('3 x_txn_org_id:' || x_txn_org_id || 'x_user_org_id:' || x_user_org_id);
340: mo_global.set_policy_context(p_access_mode => 'S',
341: p_org_id => x_user_org_id);
342: asn_debug.put_line('5 x_txn_org_id:' || x_txn_org_id || 'x_user_org_id:' || x_user_org_id);
336: asn_debug.put_line(x_progress);
337: asn_debug.put_line('1 x_txn_org_id:' || x_txn_org_id || 'x_user_org_id:' || x_user_org_id);
338: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
339: asn_debug.put_line('3 x_txn_org_id:' || x_txn_org_id || 'x_user_org_id:' || x_user_org_id);
340: mo_global.set_policy_context(p_access_mode => 'S',
341: p_org_id => x_user_org_id);
342: asn_debug.put_line('5 x_txn_org_id:' || x_txn_org_id || 'x_user_org_id:' || x_user_org_id);
343: end if;
344: asn_debug.put_line('7 x_txn_org_id:' || x_txn_org_id || 'x_user_org_id:' || x_user_org_id);
355: where group_id = X_group_id;
356:
357: PO_REQS_CONTROL_SV.commit_changes;
358:
359: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
360: mo_global.set_policy_context(p_access_mode => 'S',
361: p_org_id => x_user_org_id);
362: end if;
363:
356:
357: PO_REQS_CONTROL_SV.commit_changes;
358:
359: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
360: mo_global.set_policy_context(p_access_mode => 'S',
361: p_org_id => x_user_org_id);
362: end if;
363:
364: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');
423: if(x_req_line_id is null) then
424: return 1;
425: end if;
426:
427: x_user_org_id := MO_GLOBAL.get_current_org_id;
428:
429: for i in 1..x_req_line_id.count loop
430:
431: l_reqLineId := x_req_line_id(i);
528: end loop;
529: close rcv_header;
530: end loop;
531:
532: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
533: mo_global.set_policy_context(p_access_mode => 'S',
534: p_org_id => x_user_org_id);
535: end if;
536:
529: close rcv_header;
530: end loop;
531:
532: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
533: mo_global.set_policy_context(p_access_mode => 'S',
534: p_org_id => x_user_org_id);
535: end if;
536:
537: return 0;
547: where group_id = X_group_id;
548:
549: PO_REQS_CONTROL_SV.commit_changes;
550:
551: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
552: mo_global.set_policy_context(p_access_mode => 'S',
553: p_org_id => x_user_org_id);
554: end if;
555:
548:
549: PO_REQS_CONTROL_SV.commit_changes;
550:
551: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
552: mo_global.set_policy_context(p_access_mode => 'S',
553: p_org_id => x_user_org_id);
554: end if;
555:
556: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');
704: WAYBILL_AIRBILL_NUM,
705: USSGL_TRANSACTION_CODE )
706: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
707: X_group_id,
708: MO_GLOBAL.get_current_org_id,
709: SYSDATE,
710: X_user_id,
711: X_user_id,
712: SYSDATE,
1117: JOB_ID,
1118: MATCHING_BASIS)
1119: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1120: X_group_id,
1121: MO_GLOBAL.get_current_org_id,
1122: SYSDATE,
1123: X_user_id,
1124: X_user_id,
1125: SYSDATE,
1235: x_user_org_id NUMBER;
1236: x_txn_org_id NUMBER;
1237: begin
1238:
1239: x_user_org_id := MO_GLOBAL.get_current_org_id;
1240:
1241: begin
1242: select org_id
1243: into x_txn_org_id
1245: where rti.group_id = x_group_id and rownum = 1;
1246:
1247: asn_debug.put_line('process_transactions x_txn_org_id:' || x_txn_org_id);
1248:
1249: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
1250: mo_global.set_policy_context(p_access_mode => 'S',
1251: p_org_id => x_txn_org_id);
1252: end if;
1253: exception
1246:
1247: asn_debug.put_line('process_transactions x_txn_org_id:' || x_txn_org_id);
1248:
1249: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
1250: mo_global.set_policy_context(p_access_mode => 'S',
1251: p_org_id => x_txn_org_id);
1252: end if;
1253: exception
1254: WHEN OTHERS THEN
1294: else
1295: X_return_code_number := 98;
1296: end if;
1297:
1298: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1299: mo_global.set_policy_context(p_access_mode => 'S',
1300: p_org_id => x_user_org_id);
1301: end if;
1302:
1295: X_return_code_number := 98;
1296: end if;
1297:
1298: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1299: mo_global.set_policy_context(p_access_mode => 'S',
1300: p_org_id => x_user_org_id);
1301: end if;
1302:
1303: return X_return_code_number;
1303: return X_return_code_number;
1304:
1305: exception
1306: when others THEN -- there's a problem with val_express_transactions
1307: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1308: mo_global.set_policy_context(p_access_mode => 'S',
1309: p_org_id => x_user_org_id);
1310: end if;
1311: if (x_caller = 'WP4' OR x_caller ='WP4_CONFIRM') then
1304:
1305: exception
1306: when others THEN -- there's a problem with val_express_transactions
1307: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1308: mo_global.set_policy_context(p_access_mode => 'S',
1309: p_org_id => x_user_org_id);
1310: end if;
1311: if (x_caller = 'WP4' OR x_caller ='WP4_CONFIRM') then
1312: x_message := fnd_message.get;
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:
1701: x_user_org_id := MO_GLOBAL.get_current_org_id;
1702:
1703: begin
1704: select org_id
1705: into x_txn_org_id
1705: into x_txn_org_id
1706: from rcv_transactions_interface rti
1707: where rti.group_id = x_group_id and rownum = 1;
1708:
1709: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
1710: mo_global.set_policy_context(p_access_mode => 'S',
1711: p_org_id => x_txn_org_id);
1712: end if;
1713: exception
1706: from rcv_transactions_interface rti
1707: where rti.group_id = x_group_id and rownum = 1;
1708:
1709: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
1710: mo_global.set_policy_context(p_access_mode => 'S',
1711: p_org_id => x_txn_org_id);
1712: end if;
1713: exception
1714: WHEN OTHERS THEN
1895: PO_REQS_CONTROL_SV.commit_changes;
1896:
1897: EXCEPTION
1898: WHEN OTHERS THEN
1899: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1900: mo_global.set_policy_context(p_access_mode => 'S',
1901: p_org_id => x_user_org_id);
1902: end if;
1903: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512), 'ICX');
1896:
1897: EXCEPTION
1898: WHEN OTHERS THEN
1899: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1900: mo_global.set_policy_context(p_access_mode => 'S',
1901: p_org_id => x_user_org_id);
1902: end if;
1903: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512), 'ICX');
1904: return 95;
1904: return 95;
1905: END;
1906:
1907: END if;
1908: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1909: mo_global.set_policy_context(p_access_mode => 'S',
1910: p_org_id => x_user_org_id);
1911: end if;
1912:
1905: END;
1906:
1907: END if;
1908: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1909: mo_global.set_policy_context(p_access_mode => 'S',
1910: p_org_id => x_user_org_id);
1911: end if;
1912:
1913: return rc;
1913: return rc;
1914:
1915: EXCEPTION
1916: when others then
1917: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1918: mo_global.set_policy_context(p_access_mode => 'S',
1919: p_org_id => x_user_org_id);
1920: end if;
1921: x_progress := 'call txn processor exception' || substr(SQLERRM,12,512);
1914:
1915: EXCEPTION
1916: when others then
1917: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1918: mo_global.set_policy_context(p_access_mode => 'S',
1919: p_org_id => x_user_org_id);
1920: end if;
1921: x_progress := 'call txn processor exception' || substr(SQLERRM,12,512);
1922: asn_debug.put_line(x_progress);