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 1127: MO_GLOBAL.get_current_org_id,

1123: MATCHING_BASIS,
1124: COUNTRY_OF_ORIGIN_CODE)
1125: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1126: X_group_id,
1127: MO_GLOBAL.get_current_org_id,
1128: SYSDATE,
1129: X_user_id,
1130: X_user_id,
1131: SYSDATE,

Line 1246: x_user_org_id := MO_GLOBAL.get_current_org_id;

1242: x_user_org_id NUMBER;
1243: x_txn_org_id NUMBER;
1244: begin
1245:
1246: x_user_org_id := MO_GLOBAL.get_current_org_id;
1247:
1248: begin
1249: select org_id
1250: into x_txn_org_id

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

1252: where rti.group_id = x_group_id and rownum = 1;
1253:
1254: asn_debug.put_line('process_transactions x_txn_org_id:' || x_txn_org_id);
1255:
1256: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
1257: mo_global.set_policy_context(p_access_mode => 'S',
1258: p_org_id => x_txn_org_id);
1259: end if;
1260: exception

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

1253:
1254: asn_debug.put_line('process_transactions x_txn_org_id:' || x_txn_org_id);
1255:
1256: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
1257: mo_global.set_policy_context(p_access_mode => 'S',
1258: p_org_id => x_txn_org_id);
1259: end if;
1260: exception
1261: WHEN OTHERS THEN

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

1301: else
1302: X_return_code_number := 98;
1303: end if;
1304:
1305: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1306: mo_global.set_policy_context(p_access_mode => 'S',
1307: p_org_id => x_user_org_id);
1308: end if;
1309:

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

1302: X_return_code_number := 98;
1303: end if;
1304:
1305: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1306: mo_global.set_policy_context(p_access_mode => 'S',
1307: p_org_id => x_user_org_id);
1308: end if;
1309:
1310: return X_return_code_number;

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

1310: return X_return_code_number;
1311:
1312: exception
1313: when others THEN -- there's a problem with val_express_transactions
1314: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1315: mo_global.set_policy_context(p_access_mode => 'S',
1316: p_org_id => x_user_org_id);
1317: end if;
1318: if (x_caller = 'WP4' OR x_caller ='WP4_CONFIRM') then

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

1311:
1312: exception
1313: when others THEN -- there's a problem with val_express_transactions
1314: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1315: mo_global.set_policy_context(p_access_mode => 'S',
1316: p_org_id => x_user_org_id);
1317: end if;
1318: if (x_caller = 'WP4' OR x_caller ='WP4_CONFIRM') then
1319: x_message := fnd_message.get;

Line 1709: x_user_org_id := MO_GLOBAL.get_current_org_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:
1709: x_user_org_id := MO_GLOBAL.get_current_org_id;
1710:
1711: begin
1712: select org_id
1713: into x_txn_org_id

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

1713: into x_txn_org_id
1714: from rcv_transactions_interface rti
1715: where rti.group_id = x_group_id and rownum = 1;
1716:
1717: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
1718: mo_global.set_policy_context(p_access_mode => 'S',
1719: p_org_id => x_txn_org_id);
1720: end if;
1721: exception

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

1714: from rcv_transactions_interface rti
1715: where rti.group_id = x_group_id and rownum = 1;
1716:
1717: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
1718: mo_global.set_policy_context(p_access_mode => 'S',
1719: p_org_id => x_txn_org_id);
1720: end if;
1721: exception
1722: WHEN OTHERS THEN

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

1908: PO_REQS_CONTROL_SV.commit_changes;
1909:
1910: EXCEPTION
1911: WHEN OTHERS THEN
1912: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1913: mo_global.set_policy_context(p_access_mode => 'S',
1914: p_org_id => x_user_org_id);
1915: end if;
1916: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512), 'ICX');

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

1909:
1910: EXCEPTION
1911: WHEN OTHERS THEN
1912: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1913: mo_global.set_policy_context(p_access_mode => 'S',
1914: p_org_id => x_user_org_id);
1915: end if;
1916: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512), 'ICX');
1917: return 95;

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

1917: return 95;
1918: END;
1919:
1920: END if;
1921: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1922: mo_global.set_policy_context(p_access_mode => 'S',
1923: p_org_id => x_user_org_id);
1924: end if;
1925:

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

1918: END;
1919:
1920: END if;
1921: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1922: mo_global.set_policy_context(p_access_mode => 'S',
1923: p_org_id => x_user_org_id);
1924: end if;
1925:
1926: return rc;

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

1926: return rc;
1927:
1928: EXCEPTION
1929: when others then
1930: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1931: mo_global.set_policy_context(p_access_mode => 'S',
1932: p_org_id => x_user_org_id);
1933: end if;
1934: x_progress := 'call txn processor exception' || substr(SQLERRM,12,512);

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

1927:
1928: EXCEPTION
1929: when others then
1930: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1931: mo_global.set_policy_context(p_access_mode => 'S',
1932: p_org_id => x_user_org_id);
1933: end if;
1934: x_progress := 'call txn processor exception' || substr(SQLERRM,12,512);
1935: asn_debug.put_line(x_progress);