APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on FND_PROFILE

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

2963: CLOSE l_customer_number_csr;
2964: END IF;
2965:
2966: -- if the party number generation profile is yes or null, pass the party number to the api
2967: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') <> 'N' THEN
2968: l_party_number := NULL;
2969: ELSE
2970: OPEN l_party_number_csr;
2971: FETCH l_party_number_csr into l_party_number;

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

3540: ELSE
3541: CLOSE l_po_loc_association_csr;
3542:
3543: -- If the party site number generation profile is yes or null, pass the party site number to the api
3544: IF fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER') <> 'N' THEN
3545: s_party_site_number := NULL;
3546: ELSE
3547: OPEN l_party_site_number_csr;
3548: FETCH l_party_site_number_csr into s_party_site_number;

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

4075: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_ID_REQD');
4076: FND_MSG_PUB.ADD;
4077: RAISE EXCP_USER_DEFINED;
4078: END IF;
4079: IF fnd_profile.value('CSP_INTRANSIT_LOCATION_USED') = 'Y' THEN
4080: -- If address fields are not null, create a new inventory location. Otherwise, return error.
4081: IF p_country IS NOT NULL THEN
4082: if p_style= 'US' THEN
4083: l_town_or_city := initcap(p_town_or_city);