DBA Data[Home] [Help]

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on FND_PROFILE

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

962: FOR cur_css_interface_rec IN cur_css_interface( pn_css_id)
963: LOOP
964:
965: -- check if the ssn no is available or not
966: fnd_profile.get('IGF_AP_SSN_REQ_FOR_BASE_REC',lv_profile_value);
967:
968: IF(lv_profile_value = 'Y') THEN
969: OPEN ssn_cur(pn_person_id) ;
970: FETCH ssn_cur INTO rec_ssn_cur;

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

1593: errbuf VARCHAR2(300);
1594: l_object_version_number NUMBER;
1595: BEGIN
1596:
1597: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
1598: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1599: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_person_record','Profile value for HZ_GENERATE_PARTY_NUMBER is set to N' );
1600: END IF;
1601: fnd_message.set_name ('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');

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

3209: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3210: RETURN; -- bcoz we still process the student even if adm enquiry failed
3211: END IF;
3212:
3213: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN
3214:
3215: l_igr_sql_stmt := '
3216: DECLARE
3217: x_rowid varchar2(50);

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

3588: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
3589:
3590: BEGIN
3591: -- here the profile check needs to be added
3592: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
3593: RAISE INVALID_PROFILE_ERROR;
3594: END IF;
3595:
3596: