eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on FND_FILE

Line 46: -- fnd_file.put_line(fnd_file.log, m);

42: g_debug_seq := g_debug_seq + 1;
43: --INSERT INTO RAN_DEBUG values (g_debug_seq,m);
44: /* IF g_enable_debug_logging = 'Y' THEN
45: g_debug_seq := g_debug_seq + 1;
46: -- fnd_file.put_line(fnd_file.log, m);
47: -- INSERT INTO RAN_DEBUG values (g_debug_seq,m);
48:
49: END IF; */
50: END log_debug_message;

Line 151: fnd_file.put_line(fnd_file.log,fnd_message.get);

147:
148: IF LOWER(l_chk_email) <> LOWER(g_cur_data.r_s_email_address) THEN
149: fnd_message.set_name('IGF','IGF_AP_PROF_EMAIL_NTFND');
150: fnd_message.set_token('EMAIL_ID',g_cur_data.r_s_email_address);
151: fnd_file.put_line(fnd_file.log,fnd_message.get);
152: END IF;
153:
154: END IF;
155: END IF;

Line 163: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

159: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_person_info.exception','The exception is : ' || SQLERRM );
160: END IF;
161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
162: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_info');
163: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: END update_person_info;
167:

Line 225: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

221: END IF;
222: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_email_address');
224: igs_ge_msg_stack.add;
225: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
226: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_email_address' || SQLERRM);
227: END create_email_address;
228:
229: PROCEDURE make_profile_inactive( cp_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

Line 591: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

587: END IF;
588: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
589: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );
590: igs_ge_msg_stack.add;
591: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
592: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' || SQLERRM);
593: app_exception.raise_exception;
594: END make_profile_inactive;
595:

Line 855: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

851: END IF;
852: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
853: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );
854: igs_ge_msg_stack.add;
855: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
856: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score 1' || SQLERRM);
857: app_exception.raise_exception;
858: END calculate_match_score;
859:

Line 1101: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1097:
1098:
1099: IF pn_base_id IS NULL THEN
1100: FND_MESSAGE.SET_NAME ('IGF', 'IGF_AP_ERR_FA_REC');
1101: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1102: FND_FILE.PUT_LINE(fnd_file.log,sqlerrm);
1103: END IF;
1104: END LOOP;
1105: EXCEPTION

Line 1102: FND_FILE.PUT_LINE(fnd_file.log,sqlerrm);

1098:
1099: IF pn_base_id IS NULL THEN
1100: FND_MESSAGE.SET_NAME ('IGF', 'IGF_AP_ERR_FA_REC');
1101: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1102: FND_FILE.PUT_LINE(fnd_file.log,sqlerrm);
1103: END IF;
1104: END LOOP;
1105: EXCEPTION
1106: WHEN OTHERS THEN

Line 1113: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

1109: END IF;
1110: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1111: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_MATCHING_PROCESS_PKG.CREATE_FA_BASE_REC:');
1112: IGS_GE_MSG_STACK.ADD;
1113: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1114: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.CREATE_FA_BASE_REC' || SQLERRM);
1115: app_exception.raise_exception;
1116: END create_fa_base_record;
1117:

Line 1552: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

1548: END IF;
1549: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1550: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data');
1551: IGS_GE_MSG_STACK.ADD;
1552: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1553: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data'||SQLERRM);
1554: app_exception.raise_exception;
1555: END create_fnar_data;
1556:

Line 1606: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);

1602: IF p_called_from = 'FORM' THEN
1603: pv_mesg_data := fnd_message.get;
1604: RETURN;
1605: ELSE
1606: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);
1607: log_debug_message(fnd_message.get);
1608: app_exception.raise_exception;
1609: END IF;
1610: END IF;

Line 1678: fnd_file.put_line(fnd_file.log, fnd_message.get);

1674: WHEN OTHERS THEN
1675: IF p_called_from = 'FORM' THEN
1676: pv_mesg_data := fnd_message.get;
1677: ELSE
1678: fnd_file.put_line(fnd_file.log, fnd_message.get);
1679: END IF;
1680: RAISE SKIP_PERSON;
1681: END;
1682: /* -- following code is commentned as these values are not set by SWS code

Line 1688: fnd_file.put_line(fnd_file.log, lv_msg_data);

1684: g_bad_rec := nvl(g_bad_rec,0) + 1;
1685: IF p_called_from = 'FORM' THEN
1686: pv_mesg_data := lv_msg_data;
1687: ELSE
1688: fnd_file.put_line(fnd_file.log, lv_msg_data);
1689: END IF;
1690: END IF;
1691:
1692: fnd_file.put_line(fnd_file.log ,igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','STATUS') || ':' || lv_return_status);

Line 1692: fnd_file.put_line(fnd_file.log ,igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','STATUS') || ':' || lv_return_status);

1688: fnd_file.put_line(fnd_file.log, lv_msg_data);
1689: END IF;
1690: END IF;
1691:
1692: fnd_file.put_line(fnd_file.log ,igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','STATUS') || ':' || lv_return_status);
1693: pv_mesg_data := lv_msg_data;
1694: */
1695: END LOOP;
1696:

Line 1715: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

1711: END IF ;
1712: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1713: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_record');
1714: IGS_GE_MSG_STACK.ADD;
1715: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1716: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_record'||SQLERRM);
1717: app_exception.raise_exception;
1718:
1719: END create_person_record;

Line 1795: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);

1791: END LOOP;
1792:
1793: IF lv_return_status = 'S' THEN
1794: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_PER_ADD');
1795: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);
1796: -- bug 5348743
1797: ELSIF lv_return_status ='W' THEN
1798: FND_FILE.PUT_LINE(fnd_file.log, lv_msg_data);
1799: ELSE

Line 1798: FND_FILE.PUT_LINE(fnd_file.log, lv_msg_data);

1794: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_PER_ADD');
1795: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);
1796: -- bug 5348743
1797: ELSIF lv_return_status ='W' THEN
1798: FND_FILE.PUT_LINE(fnd_file.log, lv_msg_data);
1799: ELSE
1800: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CRT_ADDR_FAILED');
1801: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);
1802: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'Status:'||lv_return_status);

Line 1801: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);

1797: ELSIF lv_return_status ='W' THEN
1798: FND_FILE.PUT_LINE(fnd_file.log, lv_msg_data);
1799: ELSE
1800: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CRT_ADDR_FAILED');
1801: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);
1802: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'Status:'||lv_return_status);
1803: END IF;
1804:
1805: EXCEPTION

Line 1802: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'Status:'||lv_return_status);

1798: FND_FILE.PUT_LINE(fnd_file.log, lv_msg_data);
1799: ELSE
1800: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CRT_ADDR_FAILED');
1801: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);
1802: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'Status:'||lv_return_status);
1803: END IF;
1804:
1805: EXCEPTION
1806: WHEN others THEN

Line 1810: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'Status:'||lv_return_status);

1806: WHEN others THEN
1807: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1808: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_person_addr_record.exception','The exception is : ' || SQLERRM );
1809: END IF;
1810: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'Status:'||lv_return_status);
1811: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1812: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record');
1813: IGS_GE_MSG_STACK.ADD;
1814: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

Line 1814: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

1810: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'Status:'||lv_return_status);
1811: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1812: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record');
1813: IGS_GE_MSG_STACK.ADD;
1814: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1815: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record'|| SQLERRM);
1816: END create_person_addr_record;
1817:
1818: PROCEDURE process_todo_items(p_base_id NUMBER)

Line 1949: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

1945: END IF;
1946:
1947: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
1948: igs_ge_msg_stack.add;
1949: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1950: igs_ge_msg_stack.add;
1951: app_exception.raise_exception;
1952: END process_todo_items;
1953:

Line 2329: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

2325: END IF;
2326: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2327: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched:');
2328: IGS_GE_MSG_STACK.ADD;
2329: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2330: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched:'||SQLERRM);
2331: app_exception.raise_exception;
2332: END create_profile_matched;
2333:

Line 2379: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

2375: END IF;
2376: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2377: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:');
2378: IGS_GE_MSG_STACK.ADD;
2379: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2380: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:'||SQLERRM);
2381: app_exception.raise_exception;
2382: END is_fa_base_record_present;
2383:

Line 3139: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

3135: END IF;
3136: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3137: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_css_interface:');
3138: IGS_GE_MSG_STACK.ADD;
3139: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3140: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.update_css_interface:'||SQLERRM);
3141: app_exception.raise_exception;
3142: END update_css_interface;
3143:

Line 3192: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

3188: OPEN cur_adm_cal_conf;
3189: FETCH cur_adm_cal_conf INTO l_inq_cal_type;
3190: IF cur_adm_cal_conf%NOTFOUND THEN
3191: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_DEF_ADM_CAL');
3192: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3193: RETURN; -- bcoz we still process the student even if adm enquiry failed
3194: END IF;
3195: CLOSE cur_adm_cal_conf;
3196:

Line 3209: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

3205:
3206: IF l_message IS NOT NULL THEN
3207: FND_MESSAGE.Set_Name('IGS', 'IGS_AD_INQ_ADMCAL_SEQ_NOTDFN');
3208: FND_MESSAGE.Set_Token('CAL_TYPE', l_inq_cal_type);
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

Line 3285: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

3281: USING p_person_id, l_acad_cal_type, l_acad_seq, l_inq_cal_type, l_adm_seq,
3282: g_adm_source_type, OUT lv_return_status, OUT lv_msg_data, OUT lv_msg_count;
3283: ELSE
3284: FND_MESSAGE.Set_Name('IGS', 'IGS_AD_INQ_NOT_CRT');
3285: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3286: END IF; -- IGS Recruiting User
3287:
3288: IF lv_return_status IN ('E','U') THEN
3289: FOR i IN 1..lv_msg_count LOOP

Line 3290: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_msg_pub.get(p_encoded => fnd_api.g_false));

3286: END IF; -- IGS Recruiting User
3287:
3288: IF lv_return_status IN ('E','U') THEN
3289: FOR i IN 1..lv_msg_count LOOP
3290: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_msg_pub.get(p_encoded => fnd_api.g_false));
3291: END LOOP;
3292: RETURN; -- since error no need to proceed further
3293: ELSE
3294: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_ADM_REC');

Line 3295: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);

3291: END LOOP;
3292: RETURN; -- since error no need to proceed further
3293: ELSE
3294: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_ADM_REC');
3295: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);
3296: END IF;
3297:
3298: END IF;
3299:

Line 3327: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

3323: );
3324: ELSE
3325: CLOSE cur_person_type;
3326: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_PERSON_TYPE');
3327: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3328: END IF;
3329: EXCEPTION
3330: WHEN OTHERS THEN
3331: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 3343: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

3339: END IF;
3340: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
3341: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_MATCH_PROFILE_PK.create_admission_rec');
3342: igs_ge_msg_stack.add;
3343: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3344: log_debug_message('IGF_AP_MATCH_PROFILE_PK.create_admission_rec'|| SQLERRM);
3345: END create_admission_rec;
3346:
3347:

Line 3400: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

3396: END IF;
3397: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3398: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_match:');
3399: IGS_GE_MSG_STACK.ADD;
3400: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3401: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.update_person_match:'|| SQLERRM);
3402: app_exception.raise_exception;
3403: END update_person_match;
3404:

Line 3560: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

3556: END IF;
3557: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3558: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:');
3559: IGS_GE_MSG_STACK.ADD;
3560: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3561: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:'||SQLERRM );
3562: app_exception.raise_exception;
3563: END update_fa_base_rec ;
3564:

Line 3663: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);

3659: g_matched_rec := g_matched_rec + 1 ;
3660: -- To update the fields profile_status ,profile_status_datae ,profile_fc
3661: update_fa_base_rec(p_base_id => lv_base_id );
3662: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_FORCE_ADD');
3663: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);
3664:
3665: ELSE
3666: --Opening the cursor to update the record_status field to UNMATCHED
3667: FOR person_data IN cur_person_match(p_apm_id) LOOP

Line 3715: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

3711: pv_match_code => g_match_code
3712: );
3713: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_REC_STATUS');
3714: FND_MESSAGE.SET_TOKEN('STATUS','UNMATCHED');
3715: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
3716: END IF;
3717: EXCEPTION
3718: WHEN SKIP_PERSON THEN
3719: RAISE SKIP_PERSON;

Line 3729: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

3725: END IF;
3726: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3727: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec');
3728: IGS_GE_MSG_STACK.ADD;
3729: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3730: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec'|| SQLERRM);
3731: app_exception.raise_exception;
3732: END unmatched_rec ;
3733:

Line 3781: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

3777: g_total_rvw := g_total_rvw +1;
3778:
3779: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_REC_STATUS');
3780: FND_MESSAGE.SET_TOKEN('STATUS','REVIEW');
3781: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
3782:
3783: EXCEPTION
3784: WHEN others THEN
3785: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 3791: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

3787: END IF;
3788: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3789: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec');
3790: IGS_GE_MSG_STACK.ADD;
3791: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3792: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec'|| SQLERRM);
3793: app_exception.raise_exception;
3794: END rvw_fa_rec ;
3795:

Line 3851: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);

3847: pn_person_id => p_person_id ,
3848: pn_base_id => lv_base_id
3849: );
3850: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_FA_BASE_CREATED');
3851: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);
3852: END IF;
3853: -- Cursor for updating the active_profile of all the old profile records of the student to 'N'
3854: make_profile_inactive(lv_base_id);
3855: g_active_profile := 'Y';

Line 3911: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

3907: END IF;
3908: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3909: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec');
3910: IGS_GE_MSG_STACK.ADD;
3911: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3912: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec'|| SQLERRM);
3913: app_exception.raise_exception;
3914: END auto_fa_rec ;
3915:

Line 4164: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);

4160: END IF;
4161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4162: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.perform_record_matching');
4163: igs_ge_msg_stack.add;
4164: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
4165: log_debug_message('igf_ap_profile_matching_pkg.perform_record_matching'|| SQLERRM);
4166: app_exception.raise_exception;
4167: END perform_record_matching ;
4168:

Line 4225: fnd_file.put_line(fnd_file.log, fnd_message.get);

4221: p_seq_num => g_ci_sequence_number
4222: );
4223:
4224: fnd_message.set_name('IGF','IGF_AP_ISIR_AUTO_FA');
4225: fnd_file.put_line(fnd_file.log, fnd_message.get);
4226:
4227: ELSIF ln_match_score >= g_setup_score.min_score_rvw_fa THEN
4228: -- record status to be updated to review
4229: rvw_fa_rec(p_apm_id => ln_apm_id);

Line 4247: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get||' '||SQLERRM);

4243: END IF;
4244: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4245: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.process_unidentified_isir_rec');
4246: igs_ge_msg_stack.add;
4247: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get||' '||SQLERRM);
4248: log_debug_message('igf_ap_profile_matching_pkg.process_unidentified_isir_rec'|| SQLERRM);
4249: app_exception.raise_exception;
4250: END process_unidentified_isir_rec;
4251:

Line 4297: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);

4293: IF g_rec_type = 'D' THEN
4294:
4295: -- print the message that the record already exists....
4296: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROF_EXISTS');
4297: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);
4298: g_duplicate_rec := g_duplicate_rec + 1;
4299: ELSIF g_rec_type = 'O' THEN
4300:
4301: g_active_profile :='N';

Line 4380: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get||' '||SQLERRM);

4376: END IF;
4377: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4378: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.process_old_new_dup_records');
4379: IGS_GE_MSG_STACK.ADD;
4380: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get||' '||SQLERRM);
4381: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.process_old_new_dup_records'|| SQLERRM);
4382: app_exception.raise_exception;
4383: END process_old_new_dup_records ;
4384:

Line 4502: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

4498:
4499: OPEN cur_alt_code(l_cal_type,l_seq_number);
4500: FETCH cur_alt_code INTO alt_code_rec;
4501:
4502: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4503: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROC_AWD');
4504: FND_MESSAGE.SET_TOKEN('AWD_YR',alt_code_rec.alternate_code);
4505: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
4506:

Line 4505: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

4501:
4502: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4503: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROC_AWD');
4504: FND_MESSAGE.SET_TOKEN('AWD_YR',alt_code_rec.alternate_code);
4505: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
4506:
4507: OPEN c_profile(l_cal_type,l_seq_number) ;
4508: FETCH c_profile INTO l_profile;
4509:

Line 4535: fnd_file.put_line(fnd_file.log,fnd_message.get);

4531:
4532: IF cur_setup_score%NOTFOUND THEN
4533: CLOSE cur_setup_score ;
4534: fnd_message.set_name('IGF','IGF_AP_SETUP_SCORE_NOT_FOUND');
4535: fnd_file.put_line(fnd_file.log,fnd_message.get);
4536: RAISE INVALID_PARAMETER;
4537: END IF;
4538: CLOSE cur_setup_score ;
4539:

Line 4553: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

4549:
4550: -- Copying the parameter values to the gobal variable.
4551: IF LTRIM(RTRIM(p_create_inquiry)) = 'Y' AND LTRIM(RTRIM(p_adm_source_type)) IS NULL THEN
4552: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_SOURCE_TYPE_REQ');
4553: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
4554: RAISE INVALID_PARAMETER;
4555: END IF;
4556:
4557:

Line 4583: FND_FILE.PUT_LINE(fnd_file.log,' ');

4579: EXIT WHEN cur_css_interface%NOTFOUND;
4580: BEGIN
4581:
4582: SAVEPOINT IGFAP16_MAIN_SP1;
4583: FND_FILE.PUT_LINE(fnd_file.log,' ');
4584: FND_FILE.PUT_LINE(fnd_file.log,RPAD('*',50,'*'));
4585: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_STUD_SSN_DTL');
4586: FND_MESSAGE.SET_TOKEN('NAME',g_cur_data.first_name||' '||g_cur_data.last_name );
4587: FND_MESSAGE.SET_TOKEN('SSN',g_cur_data.social_security_number );

Line 4584: FND_FILE.PUT_LINE(fnd_file.log,RPAD('',50,''));

4580: BEGIN
4581:
4582: SAVEPOINT IGFAP16_MAIN_SP1;
4583: FND_FILE.PUT_LINE(fnd_file.log,' ');
4584: FND_FILE.PUT_LINE(fnd_file.log,RPAD('*',50,'*'));
4585: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_STUD_SSN_DTL');
4586: FND_MESSAGE.SET_TOKEN('NAME',g_cur_data.first_name||' '||g_cur_data.last_name );
4587: FND_MESSAGE.SET_TOKEN('SSN',g_cur_data.social_security_number );
4588: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 4588: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

4584: FND_FILE.PUT_LINE(fnd_file.log,RPAD('*',50,'*'));
4585: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_STUD_SSN_DTL');
4586: FND_MESSAGE.SET_TOKEN('NAME',g_cur_data.first_name||' '||g_cur_data.last_name );
4587: FND_MESSAGE.SET_TOKEN('SSN',g_cur_data.social_security_number );
4588: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
4589:
4590: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_STUD_PROF_DTL');
4591: FND_MESSAGE.SET_TOKEN('CNUM',g_cur_data.css_id_number);
4592: FND_MESSAGE.SET_TOKEN('SRTYPE',g_cur_data.STU_RECORD_TYPE);

Line 4593: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

4589:
4590: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_STUD_PROF_DTL');
4591: FND_MESSAGE.SET_TOKEN('CNUM',g_cur_data.css_id_number);
4592: FND_MESSAGE.SET_TOKEN('SRTYPE',g_cur_data.STU_RECORD_TYPE);
4593: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
4594:
4595:
4596: OPEN cur_css_id_number(l_profile_year,g_cur_data.css_id_number);
4597: FETCH cur_css_id_number INTO rec_css_id_number;

Line 4652: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);

4648: EXCEPTION
4649: WHEN SKIP_PERSON THEN
4650: ROLLBACK TO IGFAP16_MAIN_SP1;
4651: FND_MESSAGE.SET_NAME('IGF','IGF_SL_SKIPPING');
4652: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);
4653:
4654: WHEN INVALID_PROFILE_ERROR THEN
4655: ROLLBACK TO IGFAP16_MAIN_SP1;
4656: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 4660: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);

4656: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4657: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.main.exception','The exception is :The profile option "HZ: Generate Party Number" is set to No.');
4658: END IF;
4659: fnd_message.set_name ('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');
4660: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);
4661: WHEN OTHERS THEN
4662: ROLLBACK TO IGFAP16_MAIN_SP1; -- already error message is printed
4663: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4664: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.main.exception','The exception in main inner begin others, for skipping student');

Line 4673: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.')||TO_CHAR(g_total_processed));

4669:
4670: retcode := 0;
4671: FND_MESSAGE.SET_NAME('IGF','IGF_AP_TOTAL_RECS');
4672: FND_MESSAGE.SET_TOKEN('COUNT','');
4673: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.')||TO_CHAR(g_total_processed));
4674:
4675: FND_MESSAGE.SET_NAME('IGF','IGF_AP_MATCHED_RECS');
4676: FND_MESSAGE.SET_TOKEN('COUNT','');
4677: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_matched_rec));

Line 4677: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_matched_rec));

4673: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.')||TO_CHAR(g_total_processed));
4674:
4675: FND_MESSAGE.SET_NAME('IGF','IGF_AP_MATCHED_RECS');
4676: FND_MESSAGE.SET_TOKEN('COUNT','');
4677: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_matched_rec));
4678:
4679: FND_MESSAGE.SET_NAME('IGF','IGF_AP_UNMATCHED_RECS');
4680: FND_MESSAGE.SET_TOKEN('COUNT','');
4681: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_unmatched_rec));

Line 4681: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_unmatched_rec));

4677: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_matched_rec));
4678:
4679: FND_MESSAGE.SET_NAME('IGF','IGF_AP_UNMATCHED_RECS');
4680: FND_MESSAGE.SET_TOKEN('COUNT','');
4681: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_unmatched_rec));
4682:
4683: FND_MESSAGE.SET_NAME('IGF','IGF_AP_DUP_RECS');
4684: FND_MESSAGE.SET_TOKEN('COUNT','');
4685: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_duplicate_rec));

Line 4685: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_duplicate_rec));

4681: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_unmatched_rec));
4682:
4683: FND_MESSAGE.SET_NAME('IGF','IGF_AP_DUP_RECS');
4684: FND_MESSAGE.SET_TOKEN('COUNT','');
4685: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_duplicate_rec));
4686:
4687: FND_MESSAGE.SET_NAME('IGF','IGF_AP_BAD_RECS');
4688: FND_MESSAGE.SET_TOKEN('COUNT','');
4689: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_bad_rec));

Line 4689: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_bad_rec));

4685: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_duplicate_rec));
4686:
4687: FND_MESSAGE.SET_NAME('IGF','IGF_AP_BAD_RECS');
4688: FND_MESSAGE.SET_TOKEN('COUNT','');
4689: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_bad_rec));
4690:
4691: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NEW_PER_RECS');
4692: FND_MESSAGE.SET_TOKEN('COUNT','');
4693: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_unmatched_added));

Line 4693: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_unmatched_added));

4689: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_bad_rec));
4690:
4691: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NEW_PER_RECS');
4692: FND_MESSAGE.SET_TOKEN('COUNT','');
4693: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_unmatched_added));
4694:
4695: FND_MESSAGE.SET_NAME('IGF','IGF_AP_RVW_RECS');
4696: FND_MESSAGE.SET_TOKEN('COUNT','');
4697: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_total_rvw));

Line 4697: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_total_rvw));

4693: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_unmatched_added));
4694:
4695: FND_MESSAGE.SET_NAME('IGF','IGF_AP_RVW_RECS');
4696: FND_MESSAGE.SET_TOKEN('COUNT','');
4697: FND_FILE.PUT_LINE(fnd_file.output,RPAD(FND_MESSAGE.GET,50,'.') || TO_CHAR(g_total_rvw));
4698:
4699: IF cur_css_interface%ISOPEN THEN
4700: CLOSE cur_css_interface;
4701: END IF;

Line 4745: FND_FILE.PUT_LINE(fnd_file.log,errbuf);

4741: IGS_GE_MSG_STACK.ADD;
4742: retcode := 2;
4743: errbuf:= FND_MESSAGE.GET;
4744: rollback;
4745: FND_FILE.PUT_LINE(fnd_file.log,errbuf);
4746: igs_ge_msg_stack.conc_exception_hndl;
4747:
4748: END main;
4749:

Line 4894: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

4890: END IF;
4891: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4892: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_refresh_matches');
4893: IGS_GE_MSG_STACK.ADD;
4894: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
4895: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_refresh_matches'||SQLERRM);
4896: -- app_exception.raise_exception;
4897: END ss_wrap_refresh_matches;
4898:

Line 5100: fnd_file.put_line(fnd_file.log, fnd_message.get);

5096: FETCH cur_check_duplicate_profile INTO rec_check_duplicate_profile;
5097: IF (cur_check_duplicate_profile%FOUND) THEN
5098: g_rec_type := 'D';
5099: fnd_message.set_name('IGF','IGF_AP_PROFILE_EXISTS');
5100: fnd_file.put_line(fnd_file.log, fnd_message.get);
5101: x_return_status := 'S';
5102: ELSE
5103: g_rec_type := 'N';
5104: fnd_message.set_name('IGF','IGF_AP_PROFILE_UPLOADED');

Line 5118: fnd_file.put_line(fnd_file.log,fnd_message.get);

5114: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.ss_upload_profile.exception','The exception is : ' || SQLERRM );
5115: END IF;
5116: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5117: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.ss_upload_profile');
5118: fnd_file.put_line(fnd_file.log,fnd_message.get);
5119: igs_ge_msg_stack.add;
5120: x_return_status := 'E';
5121: END ss_wrap_upload_Profile;
5122: