APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on FND_PROFILE

Line 1753: fnd_profile.get('IGF_AP_SSN_REQ_FOR_BASE_REC',lv_profile_value);

1749:
1750: -- call TBH to insert a new rec
1751: --check if the ssn no is available or not
1752:
1753: fnd_profile.get('IGF_AP_SSN_REQ_FOR_BASE_REC',lv_profile_value);
1754:
1755: IF(lv_profile_value = 'Y') THEN
1756: OPEN ssn_cur(pn_person_id) ;
1757: FETCH ssn_cur INTO rec_ssn_cur;

Line 3143: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN

3139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Before Inserting into igr_inquiry');
3141: END IF;
3142:
3143: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN
3144:
3145: l_igr_sql_stmt := '
3146: DECLARE
3147: l_enquiry_status VARCHAR2(30) := ''OSS_REGISTERED'';

Line 3591: IF FND_PROFILE.VALUE('IGF_AP_DEF_ADDR_USAGE') IS NULL THEN

3587: -- Bug 2906227 Here we need to default the address usage to 'HOME' and since this is the first time the person is
3588: -- getting created the address will be automatically defaulted to 'PRIMARY'
3589: -- CHECK THE PROFILE OPTION TO GET THE VALUE OF RESIDES AT COLUMN
3590:
3591: IF FND_PROFILE.VALUE('IGF_AP_DEF_ADDR_USAGE') IS NULL THEN
3592: l_party_site_use := 'HOME';
3593: ELSE
3594: l_party_site_use := FND_PROFILE.VALUE('IGF_AP_DEF_ADDR_USAGE');
3595: END IF;

Line 3594: l_party_site_use := FND_PROFILE.VALUE('IGF_AP_DEF_ADDR_USAGE');

3590:
3591: IF FND_PROFILE.VALUE('IGF_AP_DEF_ADDR_USAGE') IS NULL THEN
3592: l_party_site_use := 'HOME';
3593: ELSE
3594: l_party_site_use := FND_PROFILE.VALUE('IGF_AP_DEF_ADDR_USAGE');
3595: END IF;
3596:
3597: igs_pe_party_site_use_pkg.hz_party_site_uses_ak (
3598: p_action => 'INSERT',

Line 7483: g_gen_party_profile_val := FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER'); -- get the profile value and store in global variable

7479: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7480: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Beginning Processing');
7481: END IF;
7482:
7483: g_gen_party_profile_val := FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER'); -- get the profile value and store in global variable
7484:
7485: -- print input parameters
7486: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
7487: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');

Line 8458: fnd_profile.get('IGF_AP_SSN_REQ_FOR_BASE_REC',lv_profile_value);

8454: RETURN;
8455: END IF;
8456:
8457:
8458: fnd_profile.get('IGF_AP_SSN_REQ_FOR_BASE_REC',lv_profile_value);
8459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','lv_profile_value:'||NVL(lv_profile_value,'N'));
8461: END IF;
8462: IF NVL(lv_profile_value,'N') = 'Y' THEN

Line 8609: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN

8605: g_ci_sequence_number := person_match_rec.ci_sequence_number;
8606: g_del_success_int_rec := 'N';
8607:
8608: -- Check if HZ gen party profile is set to YES as a new person is to be created. If set to No. return with error message
8609: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
8610: p_return_status := 'E'; -- indicate error
8611:
8612: fnd_message.set_name('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');
8613: p_message_out := fnd_message.get;