APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on FND_PROFILE

Line 3522: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') <> 'N' THEN

3518: CLOSE l_customer_number_csr;
3519: END IF;
3520:
3521: -- if the party number generation profile is yes or null, pass the party number to the api
3522: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') <> 'N' THEN
3523: l_party_number := NULL;
3524: ELSE
3525: OPEN l_party_number_csr;
3526: FETCH l_party_number_csr into l_party_number;

Line 4116: IF fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER') <> 'N' THEN

4112: ELSE
4113: CLOSE l_po_loc_association_csr;
4114:
4115: -- If the party site number generation profile is yes or null, pass the party site number to the api
4116: IF fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER') <> 'N' THEN
4117: s_party_site_number := NULL;
4118: ELSE
4119: OPEN l_party_site_number_csr;
4120: FETCH l_party_site_number_csr into s_party_site_number;

Line 4683: IF fnd_profile.value('CSP_INTRANSIT_LOCATION_USED') = 'Y' THEN

4679: 'In CSP_SITE_USE_ID_REQD error');
4680: end if;
4681: RAISE EXCP_USER_DEFINED;
4682: END IF;
4683: IF fnd_profile.value('CSP_INTRANSIT_LOCATION_USED') = 'Y' THEN
4684: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4685: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4686: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4687: 'In CSP_INTRANSIT_LOCATION_USED condition');