APPS.IGS_AD_IMP_002 dependencies on FND_PROFILE

Line 337: l_generate_party_number := fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER');

333: RETURN;
334: END IF;
335:
336:
337: l_generate_party_number := fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER');
338: IF (l_generate_party_number = 'N') THEN
339: IF (p_person_rec.person_number IS NULL) THEN
340: UPDATE IGS_AD_INTERFACE_all
341: SET STATUS = '3' ,

Line 1839: OPEN region_cd_cur('STATE',p_api_rec.region_cd,FND_PROFILE.VALUE('OSS_COUNTRY_CODE'));

1835: IF p_api_rec.region_cd IS NULL THEN
1836: p_error_code:='E574';
1837: RAISE NO_DATA_FOUND;
1838: ELSE
1839: OPEN region_cd_cur('STATE',p_api_rec.region_cd,FND_PROFILE.VALUE('OSS_COUNTRY_CODE'));
1840: FETCH region_cd_cur INTO l_exists;
1841: IF region_cd_cur%NOTFOUND THEN
1842: CLOSE region_cd_cur;
1843: p_error_code:='E575';