APPS.IGS_AD_IMP_008 dependencies on FND_PROFILE

Line 242: l_generate_party_number := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');

238: CLOSE Rel_person_exists_cur;
239: IF l_rel_person_exists <> 'Y' or l_rel_person_exists IS NULL THEN
240: -- To check profile value HZ_GENERATE_PARTY_NUMBER, and depending on it,
241: -- if or not to pass the person_number is decided.(Tray, Bug#1849225,02-07-2001)
242: l_generate_party_number := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
243: IF (l_generate_party_number = 'N') THEN
244: IF (P_Relations_Rec.person_number IS NULL) THEN
245: UPDATE igs_ad_relations_int_all
246: SET STATUS = '3',ERROR_CODE = 'E204'

Line 2469: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'*') = 'GB'

2465: l_Error_Code := 'E008';
2466: l_status := '3';
2467:
2468: --For UK Degree Earned and Degree Attempted should be null
2469: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'*') = 'GB'
2470: AND (Relacad_Rec.degree_attempted IS NOT NULL
2471: OR Relacad_Rec.degree_earned IS NOT NULL
2472: OR Relacad_Rec.program_code IS NOT NULL) THEN
2473:

Line 5334: OPEN c_state('STATE',p_biodemo_rec.pei_information1, FND_PROFILE.VALUE('OSS_COUNTRY_CODE'));

5330: END IF;
5331:
5332: -- validate for state
5333: ELSIF p_biodemo_rec.information_type = 'PE_STAT_RES_STATE' THEN
5334: OPEN c_state('STATE',p_biodemo_rec.pei_information1, FND_PROFILE.VALUE('OSS_COUNTRY_CODE'));
5335: FETCH c_state INTO state_rec;
5336: -- CLOSE c_state;
5337: IF c_state%NOTFOUND THEN
5338: l_error := 'E106';