DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on MO_GLOBAL

Line 510: l_org_id := mo_global.get_current_org_id;

506: fnd_profile.get('RESP_ID',orig_resp_id);
507: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
508:
509: BEGIN
510: l_org_id := mo_global.get_current_org_id;
511:
512: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
514: 'l_org_id = ' || l_org_id);

Line 519: l_org_id := mo_global.get_current_org_id;

515: end if;
516:
517: if l_org_id is null then
518: po_moac_utils_pvt.INITIALIZE;
519: l_org_id := mo_global.get_current_org_id;
520: end if;
521:
522: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
523: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 608: mo_global.set_policy_context('S',l_source_operating_unit);

604: IF new_resp_id is not null and
605: new_user_id is not null and
606: new_resp_appl_id is not null THEN
607: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
608: mo_global.set_policy_context('S',l_source_operating_unit);
609: ELSE
610: --dbms_application_info.set_client_info(l_source_operating_unit);
611: mo_global.set_policy_context('S',l_source_operating_unit);
612: END IF;

Line 611: mo_global.set_policy_context('S',l_source_operating_unit);

607: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
608: mo_global.set_policy_context('S',l_source_operating_unit);
609: ELSE
610: --dbms_application_info.set_client_info(l_source_operating_unit);
611: mo_global.set_policy_context('S',l_source_operating_unit);
612: END IF;
613: END If;
614:
615: oe_header_util.Query_Row(

Line 692: mo_global.set_policy_context('S',l_source_operating_unit);

688: IF new_resp_id is not null and
689: new_user_id is not null and
690: new_resp_appl_id is not null THEN
691: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
692: mo_global.set_policy_context('S',l_source_operating_unit);
693: ELSE
694: --dbms_application_info.set_client_info(l_source_operating_unit);
695: mo_global.set_policy_context('S',l_source_operating_unit);
696: END IF;

Line 695: mo_global.set_policy_context('S',l_source_operating_unit);

691: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
692: mo_global.set_policy_context('S',l_source_operating_unit);
693: ELSE
694: --dbms_application_info.set_client_info(l_source_operating_unit);
695: mo_global.set_policy_context('S',l_source_operating_unit);
696: END IF;
697: END If;
698:
699: l_oe_line_old_tbl(i) := oe_line_util.Query_Row(l_line_tbl(i).order_line_id);

Line 816: mo_global.set_policy_context('S',l_org_id);

812: end if;
813:
814: IF (l_source_operating_unit <> l_org_id) THEN
815: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);
816: mo_global.set_policy_context('S',l_org_id);
817: END If;
818:
819: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
820: x_return_status := l_return_status;

Line 883: mo_global.set_policy_context('S',l_source_operating_unit);

879: new_resp_appl_id is not null THEN
880: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
881: ELSE
882: --dbms_application_info.set_client_info(l_source_operating_unit);
883: mo_global.set_policy_context('S',l_source_operating_unit);
884: END IF;
885: END If;
886:
887: oe_header_util.Query_Row(

Line 975: mo_global.set_policy_context('S',l_org_id);

971: end if;
972:
973: IF (l_source_operating_unit <> l_org_id) THEN
974: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);
975: mo_global.set_policy_context('S',l_org_id);
976: END If;
977:
978: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
979: x_return_status := l_return_status;

Line 1662: l_org_id := mo_global.get_current_org_id;

1658: /*SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
1659: INTO l_org_id
1660: FROM dual;*/
1661:
1662: l_org_id := mo_global.get_current_org_id;
1663: l_first_org_id := l_org_id;
1664:
1665: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1666: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3855: mo_global.set_policy_context('S', l_source_operating_unit);

3851: IF new_resp_id is not null and
3852: new_user_id is not null and
3853: new_resp_appl_id is not null THEN
3854: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
3855: mo_global.set_policy_context('S', l_source_operating_unit);
3856: /* fnd_profile.get('ORG_ID',new_org_id); --Operating Unit for the new context.
3857: IF l_source_operating_unit <> new_org_id THEN
3858: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_NOT_MATCH'); --to be seeded.
3859: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);

Line 3866: mo_global.set_policy_context('S', l_source_operating_unit);

3862: END IF;
3863: */
3864: ELSE
3865: --dbms_application_info.set_client_info(l_source_operating_unit);
3866: mo_global.set_policy_context('S', l_source_operating_unit);
3867: END IF;
3868: END If;
3869:
3870: -- CONTROL RECORD

Line 4152: mo_global.set_org_context(l_first_org_id,null,'CSF');

4148: --IF (l_source_operating_unit <> l_org_id) THEN
4149: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);
4150:
4151: if l_first_org_id is not null then
4152: mo_global.set_org_context(l_first_org_id,null,'CSF');
4153: end if;
4154: --END If;
4155:
4156: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4427: l_org_id := mo_global.get_current_org_id;

4423:
4424: -- operating unit
4425: -- changed for bug 11847583
4426: BEGIN
4427: l_org_id := mo_global.get_current_org_id;
4428:
4429: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',
4431: 'Original l_org_id from context = ' || l_org_id);

Line 4780: l_org_org_id := mo_global.get_current_org_id;

4776: 'p_oe_header_id = ' || p_oe_header_id);
4777: end if;
4778:
4779: select org_id into l_org_id from oe_order_headers_all where header_id = p_oe_header_id;
4780: l_org_org_id := mo_global.get_current_org_id;
4781:
4782: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4783: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4784: 'l_org_id = ' || l_org_id);

Line 4791: l_org_org_id := mo_global.get_current_org_id;

4787: end if;
4788:
4789: if l_org_org_id is null then
4790: po_moac_utils_pvt.INITIALIZE;
4791: l_org_org_id := mo_global.get_current_org_id;
4792: end if;
4793:
4794: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 4936: l_org_org_id := mo_global.get_current_org_id;

4932: || ', p_ship_method = ' || p_ship_method);
4933: end if;
4934:
4935: select org_id into l_org_id from oe_order_lines_all where line_id = p_oe_line_id;
4936: l_org_org_id := mo_global.get_current_org_id;
4937:
4938: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4939: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4940: 'l_org_id = ' || l_org_id);

Line 4947: l_org_org_id := mo_global.get_current_org_id;

4943: end if;
4944:
4945: if l_org_org_id is null then
4946: po_moac_utils_pvt.INITIALIZE;
4947: l_org_org_id := mo_global.get_current_org_id;
4948: end if;
4949:
4950: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4951: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,