DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on MO_GLOBAL

Line 4742: IF l_org_context <> mo_global.get_access_mode THEN

4738: x_return_status := FND_API.G_RET_STS_ERROR;
4739: END IF;
4740:
4741: --set access mode back to original value
4742: IF l_org_context <> mo_global.get_access_mode THEN
4743: MO_GLOBAL.set_policy_context(l_org_context,l_def_org_id);
4744: END IF;
4745:
4746: -- End of API body.

Line 4743: MO_GLOBAL.set_policy_context(l_org_context,l_def_org_id);

4739: END IF;
4740:
4741: --set access mode back to original value
4742: IF l_org_context <> mo_global.get_access_mode THEN
4743: MO_GLOBAL.set_policy_context(l_org_context,l_def_org_id);
4744: END IF;
4745:
4746: -- End of API body.
4747:

Line 7958: -- strategy is that if calling application id is not AP then we will not call MO_GLOBAL.INIT

7954: -- modules set the context and call this API with the right ORG_ID.
7955:
7956: -- Bug 6812010 :Due to 5055120, Payables' own supplier site import program fails
7957: -- because MO initialization is not happening.To fix 6812010 and keep 5055120 intact,
7958: -- strategy is that if calling application id is not AP then we will not call MO_GLOBAL.INIT
7959: -- since it is calling module's responsibility to perform MO initialization.
7960: -- Bug 6930102
7961: If (l_program_application_id = 200 OR l_program_application_id = -1)then
7962: MO_GLOBAL.INIT ('SQLAP');

Line 7962: MO_GLOBAL.INIT ('SQLAP');

7958: -- strategy is that if calling application id is not AP then we will not call MO_GLOBAL.INIT
7959: -- since it is calling module's responsibility to perform MO initialization.
7960: -- Bug 6930102
7961: If (l_program_application_id = 200 OR l_program_application_id = -1)then
7962: MO_GLOBAL.INIT ('SQLAP');
7963: end if;
7964:
7965: -- Initialize API return status to success
7966: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8047: MO_GLOBAL.validate_orgid_pub_api(l_def_org_id,

8043: -- Bug 5055120
8044: -- Added validation of org_id
8045: BEGIN
8046:
8047: MO_GLOBAL.validate_orgid_pub_api(l_def_org_id,
8048: 'N',
8049: x_return_status);
8050: EXCEPTION
8051: WHEN OTHERS

Line 8077: l_api_name,'Error after MO_GLOBAL.validate_orgid_pub_api Parameters: '

8073: -- Bug 5491139 hkaniven end --
8074: -- Bug 8438716 Start
8075: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8076: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
8077: l_api_name,'Error after MO_GLOBAL.validate_orgid_pub_api Parameters: '
8078: ||' Vendor_Site_Interface_Id: '||p_vendor_site_rec.vendor_site_interface_id
8079: ||' ,Vendor_Site_Code: '||p_vendor_site_rec.vendor_site_code);
8080: END IF;
8081: -- Bug 8438716 End

Line 8088: l_org_context := mo_global.get_access_mode;

8084: RAISE ORG_ID_EXCEPTION; -- BUG 6739544
8085: END;
8086:
8087:
8088: l_org_context := mo_global.get_access_mode;
8089:
8090: IF nvl(l_org_context, 'K') <> 'S' THEN
8091: MO_GLOBAL.set_policy_context('S',l_def_org_id);
8092: END IF;

Line 8091: MO_GLOBAL.set_policy_context('S',l_def_org_id);

8087:
8088: l_org_context := mo_global.get_access_mode;
8089:
8090: IF nvl(l_org_context, 'K') <> 'S' THEN
8091: MO_GLOBAL.set_policy_context('S',l_def_org_id);
8092: END IF;
8093:
8094: SELECT nvl(multi_org_flag,'N')
8095: INTO l_multi_org_flag

Line 9125: IF l_org_context <> MO_Global.Get_Access_Mode THEN

9121: END IF;
9122: END IF;
9123:
9124: /* Bug 5310356 */
9125: IF l_org_context <> MO_Global.Get_Access_Mode THEN
9126: MO_GLOBAL.Set_Policy_Context(l_org_context, l_def_org_id);
9127: END IF;
9128:
9129: -- End of API body.

Line 9126: MO_GLOBAL.Set_Policy_Context(l_org_context, l_def_org_id);

9122: END IF;
9123:
9124: /* Bug 5310356 */
9125: IF l_org_context <> MO_Global.Get_Access_Mode THEN
9126: MO_GLOBAL.Set_Policy_Context(l_org_context, l_def_org_id);
9127: END IF;
9128:
9129: -- End of API body.
9130:

Line 9260: -- strategy is that if calling application id is not AP then we will not call MO_GLOBAL.INIT

9256: -- modules set the context and call this API with the right ORG_ID.
9257:
9258: -- Bug 6812010 :Due to 5055120, Payables' own supplier site import program fails
9259: -- because MO initialization is not happening.To fix 6812010 and keep 5055120 intact,
9260: -- strategy is that if calling application id is not AP then we will not call MO_GLOBAL.INIT
9261: -- since it is calling module's responsibility to perform MO initialization.
9262:
9263: -- Bug 6930102
9264: If (l_program_application_id = 200 OR l_program_application_id = -1)then

Line 9265: MO_GLOBAL.INIT ('SQLAP');

9261: -- since it is calling module's responsibility to perform MO initialization.
9262:
9263: -- Bug 6930102
9264: If (l_program_application_id = 200 OR l_program_application_id = -1)then
9265: MO_GLOBAL.INIT ('SQLAP');
9266: end if;
9267:
9268: --get org_id from existing record
9269: SELECT org_id

Line 9274: l_org_context := mo_global.get_access_mode;

9270: INTO l_org_id
9271: FROM po_vendor_sites_all pvs
9272: WHERE pvs.vendor_site_id = p_vendor_site_id;
9273:
9274: l_org_context := mo_global.get_access_mode;
9275:
9276: IF nvl(l_org_context, 'K') <> 'S' THEN
9277: MO_GLOBAL.set_policy_context('S',l_org_id);
9278: END IF;

Line 9277: MO_GLOBAL.set_policy_context('S',l_org_id);

9273:
9274: l_org_context := mo_global.get_access_mode;
9275:
9276: IF nvl(l_org_context, 'K') <> 'S' THEN
9277: MO_GLOBAL.set_policy_context('S',l_org_id);
9278: END IF;
9279:
9280: l_vendor_site_rec := p_vendor_site_rec;
9281:

Line 9871: IF l_org_context <> mo_global.get_access_mode THEN

9867: x_return_status := FND_API.G_RET_STS_ERROR;
9868: END IF;
9869:
9870: --set access mode back to original value
9871: IF l_org_context <> mo_global.get_access_mode THEN
9872: MO_GLOBAL.set_policy_context(l_org_context,l_def_org_id);
9873: END IF;
9874:
9875: -- End of API body.

Line 9872: MO_GLOBAL.set_policy_context(l_org_context,l_def_org_id);

9868: END IF;
9869:
9870: --set access mode back to original value
9871: IF l_org_context <> mo_global.get_access_mode THEN
9872: MO_GLOBAL.set_policy_context(l_org_context,l_def_org_id);
9873: END IF;
9874:
9875: -- End of API body.
9876:

Line 9978: MO_GLOBAL.INIT ('SQLAP');

9974:
9975: l_tolerance_type := 'QUANTITY';
9976: --Bug 7476500 start
9977: If (l_program_application_id = 200 OR l_program_application_id = -1)then
9978: MO_GLOBAL.INIT ('SQLAP');
9979: end if;
9980:
9981: l_org_context := mo_global.get_access_mode;
9982: IF nvl(l_org_context, 'K') <> 'S' THEN

Line 9981: l_org_context := mo_global.get_access_mode;

9977: If (l_program_application_id = 200 OR l_program_application_id = -1)then
9978: MO_GLOBAL.INIT ('SQLAP');
9979: end if;
9980:
9981: l_org_context := mo_global.get_access_mode;
9982: IF nvl(l_org_context, 'K') <> 'S' THEN
9983: MO_GLOBAL.set_policy_context('S',p_vendor_site_rec.org_id);
9984: END IF;
9985: --Bug 7476500 End

Line 9983: MO_GLOBAL.set_policy_context('S',p_vendor_site_rec.org_id);

9979: end if;
9980:
9981: l_org_context := mo_global.get_access_mode;
9982: IF nvl(l_org_context, 'K') <> 'S' THEN
9983: MO_GLOBAL.set_policy_context('S',p_vendor_site_rec.org_id);
9984: END IF;
9985: --Bug 7476500 End
9986: -- Standard Start of API savepoint
9987: SAVEPOINT Validate_Vendor_Site_PUB;

Line 16613: AND mo_global.check_access(org_id)= 'Y' --bug13989575

16609: AND (org_id IS NOT NULL OR operating_unit_name IS NOT NULL)
16610: AND vendor_id IS NOT NULL
16611: AND org_id = nvl(p_org_id, org_id) --bug13801271
16612: --AND org_id IN (SELECT fsp.org_id FROM financials_system_parameters fsp) --bug13801271
16613: AND mo_global.check_access(org_id)= 'Y' --bug13989575
16614: ;
16615:
16616: site_int_rec site_int_cur%ROWTYPE;
16617: site_rec r_vendor_site_rec_type;

Line 16684: AND mo_global.check_access(org_id)= 'Y' --bug13989575

16680: FROM fnd_concurrent_requests fcr
16681: WHERE fcr.request_id = api.import_request_id
16682: AND fcr.phase_code = 'C' )
16683: AND org_id = nvl(p_org_id, org_id) --bug13989575
16684: AND mo_global.check_access(org_id)= 'Y' --bug13989575
16685: ;
16686:
16687: -- udhenuko Bug 6823885 End
16688: --bug 5584046

Line 16702: AND mo_global.check_access(org_id)= 'Y' --bug13989575

16698: ((p_what_to_import = 'ALL' AND nvl(status,'NEW') in ('NEW', 'REJECTED')) OR
16699: (p_what_to_import = 'NEW' AND nvl(status,'NEW') = 'NEW') OR
16700: (p_what_to_import = 'REJECTED' AND nvl(status,'NEW') = 'REJECTED'))
16701: AND org_id = nvl(p_org_id, org_id) --bug13989575
16702: AND mo_global.check_access(org_id)= 'Y' --bug13989575
16703: ;
16704:
16705: UPDATE Ap_Supplier_Sites_Int
16706: SET status = 'REJECTED',

Line 16711: AND mo_global.check_access(org_id)= 'Y' --bug13989575

16707: import_request_id = l_request_id
16708: WHERE (operating_unit_name IS NULL AND org_id IS NULL) OR
16709: vendor_id IS NULL
16710: AND org_id = nvl(p_org_id, org_id) --bug13989575
16711: AND mo_global.check_access(org_id)= 'Y' --bug13989575
16712: ;
16713:
16714: --bug 5584046
16715: INSERT INTO Ap_Supplier_Int_Rejections

Line 16731: AND mo_global.check_access(org_id)= 'Y' --bug13989575

16727: WHERE STATUS='REJECTED'
16728: AND import_request_id=l_request_id
16729: AND (operating_unit_name IS NULL and org_id IS NULL)
16730: AND org_id = nvl(p_org_id, org_id) --bug13989575
16731: AND mo_global.check_access(org_id)= 'Y' --bug13989575
16732: UNION
16733: select 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_VENDOR_ID_NULL',
16734: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
16735: from Ap_Supplier_Sites_Int

Line 16740: AND mo_global.check_access(org_id)= 'Y' --bug13989575

16736: where status='REJECTED'
16737: AND import_request_id=l_request_id
16738: AND vendor_id IS NULL
16739: AND org_id = nvl(p_org_id, org_id) --bug13989575
16740: AND mo_global.check_access(org_id)= 'Y' --bug13989575
16741: ;
16742: --bug 5584046
16743: COMMIT;
16744:

Line 17020: AND mo_global.check_access(org_id)= 'Y' --bug13989575

17016: SET status = 'PROCESSED'
17017: WHERE vendor_site_interface_id =
17018: site_rec.vendor_site_interface_id
17019: AND org_id = nvl(p_org_id, org_id) --bug13989575
17020: AND mo_global.check_access(org_id)= 'Y' --bug13989575
17021: ;
17022:
17023: UPDATE AP_Sup_Site_Contact_Int
17024: SET vendor_site_id = l_vendor_site_id

Line 17217: AND mo_global.check_access(org_id)= 'Y' --bug13989575

17213: UPDATE Ap_Supplier_Sites_Int
17214: SET status = 'REJECTED'
17215: WHERE vendor_site_interface_id = site_rec.vendor_site_interface_id
17216: AND org_id = nvl(p_org_id, org_id) --bug13989575
17217: AND mo_global.check_access(org_id)= 'Y' --bug13989575
17218: ;
17219:
17220:
17221: UPDATE iby_temp_ext_bank_accts

Line 17461: AND mo_global.check_access(org_id)= 'Y' --bug13989575

17457: SET status = 'REJECTED'
17458: WHERE vendor_site_interface_id =
17459: site_rec.vendor_site_interface_id
17460: AND org_id = nvl(p_org_id, org_id) --bug13989575
17461: AND mo_global.check_access(org_id)= 'Y' --bug13989575
17462: ;
17463:
17464: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
17465: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,