DBA Data[Home] [Help]

APPS.POR_RCV_ORD_SV dependencies on MO_GLOBAL

Line 89: x_user_org_id := MO_GLOBAL.get_current_org_id;

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);

Line 108: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then

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

Line 109: mo_global.set_policy_context(p_access_mode => 'S',

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

Line 338: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) 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);

Line 340: mo_global.set_policy_context(p_access_mode => 'S',

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);

Line 359: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then

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:

Line 360: mo_global.set_policy_context(p_access_mode => 'S',

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');

Line 427: x_user_org_id := MO_GLOBAL.get_current_org_id;

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);

Line 532: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then

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:

Line 533: mo_global.set_policy_context(p_access_mode => 'S',

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;

Line 551: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then

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:

Line 552: mo_global.set_policy_context(p_access_mode => 'S',

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');

Line 708: MO_GLOBAL.get_current_org_id,

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,

Line 1121: MO_GLOBAL.get_current_org_id,

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,

Line 1239: x_user_org_id := MO_GLOBAL.get_current_org_id;

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

Line 1249: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then

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

Line 1250: mo_global.set_policy_context(p_access_mode => 'S',

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

Line 1298: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) 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:

Line 1299: mo_global.set_policy_context(p_access_mode => 'S',

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;

Line 1307: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then

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

Line 1308: mo_global.set_policy_context(p_access_mode => 'S',

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;

Line 1701: x_user_org_id := MO_GLOBAL.get_current_org_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:
1701: x_user_org_id := MO_GLOBAL.get_current_org_id;
1702:
1703: begin
1704: select org_id
1705: into x_txn_org_id

Line 1709: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then

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

Line 1710: mo_global.set_policy_context(p_access_mode => 'S',

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

Line 1899: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) 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');

Line 1900: mo_global.set_policy_context(p_access_mode => 'S',

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;

Line 1908: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then

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:

Line 1909: mo_global.set_policy_context(p_access_mode => 'S',

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;

Line 1917: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then

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);

Line 1918: mo_global.set_policy_context(p_access_mode => 'S',

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);