APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on FND_MESSAGE

Line 149: fnd_message.set_name('IGF','IGF_AP_PROF_EMAIL_NTFND');

145:
146: ELSE
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:

Line 150: fnd_message.set_token('EMAIL_ID',g_cur_data.r_s_email_address);

146: ELSE
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;

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 161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

157: WHEN others THEN
158: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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;

Line 162: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_info');

158: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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;

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 222: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

218: WHEN others THEN
219: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
220: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_email_address.exception','The exception is : ' || 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);

Line 223: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_email_address');

219: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
220: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_email_address.exception','The exception is : ' || 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;

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 588: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

584: WHEN others THEN
585: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
586: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.make_profile_inactive.exception','The exception is : ' || 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);

Line 589: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );

585: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
586: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.make_profile_inactive.exception','The exception is : ' || 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;

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 852: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

848: WHEN others THEN
849: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
850: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.calculate_match_score.exception','The exception is : ' || 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);

Line 853: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );

849: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
850: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.calculate_match_score.exception','The exception is : ' || 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;

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 1100: FND_MESSAGE.SET_NAME ('IGF', 'IGF_AP_ERR_FA_REC');

1096:
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;

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 1110: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1106: WHEN OTHERS THEN
1107: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1108: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fa_base_record.exception','The exception is : ' || 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);

Line 1111: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_MATCHING_PROCESS_PKG.CREATE_FA_BASE_REC:');

1107: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1108: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fa_base_record.exception','The exception is : ' || 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;

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 1549: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1545: WHEN others THEN
1546: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1547: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fnar_data.exception','The exception is : ' || 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);

Line 1550: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data');

1546: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1547: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fnar_data.exception','The exception is : ' || 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;

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 1575: || to assign the fnd_message.get to the pv_mesg_data.

1571: || Who When What
1572: || skpandey 21-SEP-2005 Bug: 3663505
1573: || Description: Added ATTRIBUTES 21 TO 24 TO STORE ADDITIONAL INFORMATION
1574: || bkkumar 08-Dec-2003 Bug# 3030541 changed the exception block
1575: || to assign the fnd_message.get to the pv_mesg_data.
1576: || masehgal 16-Apr-2002 # 2320076 Made changes in the log file to include student details.
1577: || bkkumar 11-Aug-2003 Bug# 3084964 Added the check for the
1578: || HZ_GENERATE_PARTY_NUMBER profile value
1579: || and removed the hard coded strings.

Line 1601: fnd_message.set_name ('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');

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');
1602: IF p_called_from = 'FORM' THEN
1603: pv_mesg_data := fnd_message.get;
1604: RETURN;
1605: ELSE

Line 1603: pv_mesg_data := fnd_message.get;

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');
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);

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 1607: log_debug_message(fnd_message.get);

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;
1611:

Line 1676: pv_mesg_data := fnd_message.get;

1672: );
1673: EXCEPTION
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;

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 1708: pv_mesg_data := fnd_message.get;

1704: IF pn_person_id IS NULL THEN
1705: g_bad_rec := nvl(g_bad_rec,0) + 1;
1706: END IF;
1707: IF fnd_msg_pub.count_msg = 1 THEN
1708: pv_mesg_data := fnd_message.get;
1709: ELSIF fnd_msg_pub.count_msg > 1 THEN
1710: pv_mesg_data := SQLERRM;
1711: END IF ;
1712: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 1712: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1708: pv_mesg_data := fnd_message.get;
1709: ELSIF fnd_msg_pub.count_msg > 1 THEN
1710: pv_mesg_data := 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);

Line 1713: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_record');

1709: ELSIF fnd_msg_pub.count_msg > 1 THEN
1710: pv_mesg_data := 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;

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 1794: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_PER_ADD');

1790: );
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);

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 1800: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CRT_ADDR_FAILED');

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);
1803: END IF;
1804:

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 1811: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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);
1815: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record'|| SQLERRM);

Line 1812: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record');

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);
1815: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record'|| SQLERRM);
1816: END create_person_addr_record;

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 1947: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');

1943: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1944: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.exception','The exception is : ' || 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;

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 2326: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2322: WHEN others THEN
2323: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2324: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_profile_matched.exception','The exception is : ' || 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);

Line 2327: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched:');

2323: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2324: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_profile_matched.exception','The exception is : ' || 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;

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 2376: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2372: WHEN others THEN
2373: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2374: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.is_fa_base_record_present.exception','The exception is : ' || 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);

Line 2377: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:');

2373: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2374: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.is_fa_base_record_present.exception','The exception is : ' || 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;

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 3136: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

3132: WHEN others THEN
3133: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3134: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_css_interface.exception','The exception is : ' || 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);

Line 3137: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_css_interface:');

3133: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3134: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_css_interface.exception','The exception is : ' || 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;

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 3191: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_DEF_ADM_CAL');

3187:
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;

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 3207: FND_MESSAGE.Set_Name('IGS', 'IGS_AD_INQ_ADMCAL_SEQ_NOTDFN');

3203: p_message => l_message
3204: );
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;

Line 3208: FND_MESSAGE.Set_Token('CAL_TYPE', l_inq_cal_type);

3204: );
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:

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 3284: FND_MESSAGE.Set_Name('IGS', 'IGS_AD_INQ_NOT_CRT');

3280: EXECUTE IMMEDIATE l_igr_sql_stmt
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

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 3294: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_ADM_REC');

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');
3295: FND_FILE.PUT_LINE(fnd_file.log, fnd_message.get);
3296: END IF;
3297:
3298: END IF;

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 3326: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_PERSON_TYPE');

3322: X_ORG_ID => igs_ge_gen_003.get_org_id
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

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 3340: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

3336: END IF;
3337: IF cur_person_type%ISOPEN THEN
3338: CLOSE cur_person_type;
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);

Line 3341: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_MATCH_PROFILE_PK.create_admission_rec');

3337: IF cur_person_type%ISOPEN THEN
3338: CLOSE cur_person_type;
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;

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 3397: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

3393: WHEN others THEN
3394: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3395: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_person_match.exception','The exception is : ' || 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);

Line 3398: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_match:');

3394: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3395: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_person_match.exception','The exception is : ' || 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;

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 3557: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

3553: WHEN OTHERS THEN
3554: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3555: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_fa_base_rec.exception','The exception is : ' || 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 );

Line 3558: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:');

3554: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3555: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_fa_base_rec.exception','The exception is : ' || 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;

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 3662: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_FORCE_ADD');

3658: );
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

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 3713: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_REC_STATUS');

3709: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,
3710: pv_record_status => 'UNMATCHED',
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

Line 3714: FND_MESSAGE.SET_TOKEN('STATUS','UNMATCHED');

3710: pv_record_status => 'UNMATCHED',
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

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 3726: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

3722: WHEN others THEN
3723: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3724: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.unmatched_rec.exception','The exception is : ' || 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);

Line 3727: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec');

3723: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3724: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.unmatched_rec.exception','The exception is : ' || 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;

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 3779: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_REC_STATUS');

3775: pv_match_code => g_match_code
3776: );
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

Line 3780: FND_MESSAGE.SET_TOKEN('STATUS','REVIEW');

3776: );
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

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 3788: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

3784: WHEN others THEN
3785: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3786: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.rvw_fa_rec.exception','The exception is : ' || 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);

Line 3789: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec');

3785: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3786: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.rvw_fa_rec.exception','The exception is : ' || 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;

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 3850: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_FA_BASE_CREATED');

3846: IGF_AP_PROFILE_MATCHING_PKG.create_fa_base_record(pn_css_id => g_cur_data.css_id,
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);

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 3908: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

3904: WHEN others THEN
3905: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3906: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.exception','The exception is : ' || 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);

Line 3909: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec');

3905: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3906: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.exception','The exception is : ' || 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;

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 4161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

4157: WHEN others THEN
4158: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4159: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.perform_record_matching.exception','The exception is : ' || 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);

Line 4162: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.perform_record_matching');

4158: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4159: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.perform_record_matching.exception','The exception is : ' || 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;

Line 4224: fnd_message.set_name('IGF','IGF_AP_ISIR_AUTO_FA');

4220: p_cal_type => g_ci_cal_type,
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

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 4244: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

4240: WHEN OTHERS THEN
4241: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4242: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.exception','The exception is : ' || 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);

Line 4245: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.process_unidentified_isir_rec');

4241: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4242: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.exception','The exception is : ' || 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;

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 4296: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROF_EXISTS');

4292: l_person_id := NULL;
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:

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 4377: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

4373: WHEN others THEN
4374: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4375: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.exception','The exception is : ' || 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);

Line 4378: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.process_old_new_dup_records');

4374: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4375: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.exception','The exception is : ' || 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;

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 4503: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROC_AWD');

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:
4507: OPEN c_profile(l_cal_type,l_seq_number) ;

Line 4504: FND_MESSAGE.SET_TOKEN('AWD_YR',alt_code_rec.alternate_code);

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:
4507: OPEN c_profile(l_cal_type,l_seq_number) ;
4508: FETCH c_profile INTO l_profile;

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 4520: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');

4516: FETCH cur_school_cd INTO l_valid_found;
4517:
4518: IF cur_school_cd%NOTFOUND THEN
4519: CLOSE cur_school_cd;
4520: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
4521: fnd_message.set_token('PARAM_TYPE', 'SCHOOL CODE');
4522: igs_ge_msg_stack.add;
4523: RAISE INVALID_PARAMETER;
4524: END IF ;

Line 4521: fnd_message.set_token('PARAM_TYPE', 'SCHOOL CODE');

4517:
4518: IF cur_school_cd%NOTFOUND THEN
4519: CLOSE cur_school_cd;
4520: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
4521: fnd_message.set_token('PARAM_TYPE', 'SCHOOL CODE');
4522: igs_ge_msg_stack.add;
4523: RAISE INVALID_PARAMETER;
4524: END IF ;
4525: CLOSE cur_school_cd;

Line 4534: fnd_message.set_name('IGF','IGF_AP_SETUP_SCORE_NOT_FOUND');

4530: FETCH cur_setup_score INTO g_setup_score;
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 ;

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 4545: FND_MESSAGE.SET_NAME('IGF','IGF_AP_BATCH_YEAR_NOT_FOUND');

4541: OPEN cur_batch_aw_map(TO_NUMBER(l_profile_year)) ;
4542: FETCH cur_batch_aw_map INTO g_ci_cal_type,g_ci_sequence_number ;
4543: IF cur_batch_aw_map%NOTFOUND THEN
4544: CLOSE cur_batch_aw_map ;
4545: FND_MESSAGE.SET_NAME('IGF','IGF_AP_BATCH_YEAR_NOT_FOUND');
4546: IGS_GE_MSG_STACK.ADD;
4547: RAISE INVALID_PARAMETER;
4548: END IF ;
4549:

Line 4552: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_SOURCE_TYPE_REQ');

4548: END IF ;
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:

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 4585: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_STUD_SSN_DTL');

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);
4589:

Line 4586: FND_MESSAGE.SET_TOKEN('NAME',g_cur_data.first_name||' '||g_cur_data.last_name );

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);
4589:
4590: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_STUD_PROF_DTL');

Line 4587: FND_MESSAGE.SET_TOKEN('SSN',g_cur_data.social_security_number );

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);
4589:
4590: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_STUD_PROF_DTL');
4591: FND_MESSAGE.SET_TOKEN('CNUM',g_cur_data.css_id_number);

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 4590: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_STUD_PROF_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);
4593: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
4594:

Line 4591: FND_MESSAGE.SET_TOKEN('CNUM',g_cur_data.css_id_number);

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);
4593: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
4594:
4595:

Line 4592: FND_MESSAGE.SET_TOKEN('SRTYPE',g_cur_data.STU_RECORD_TYPE);

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);
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);

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 4651: FND_MESSAGE.SET_NAME('IGF','IGF_SL_SKIPPING');

4647: COMMIT;
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;

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 4659: fnd_message.set_name ('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');

4655: ROLLBACK TO IGFAP16_MAIN_SP1;
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

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 4671: FND_MESSAGE.SET_NAME('IGF','IGF_AP_TOTAL_RECS');

4667: END;
4668: END LOOP;
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');

Line 4672: FND_MESSAGE.SET_TOKEN('COUNT','');

4668: END LOOP;
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','');

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 4675: FND_MESSAGE.SET_NAME('IGF','IGF_AP_MATCHED_RECS');

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));
4678:
4679: FND_MESSAGE.SET_NAME('IGF','IGF_AP_UNMATCHED_RECS');

Line 4676: FND_MESSAGE.SET_TOKEN('COUNT','');

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));
4678:
4679: FND_MESSAGE.SET_NAME('IGF','IGF_AP_UNMATCHED_RECS');
4680: FND_MESSAGE.SET_TOKEN('COUNT','');

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 4679: FND_MESSAGE.SET_NAME('IGF','IGF_AP_UNMATCHED_RECS');

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));
4682:
4683: FND_MESSAGE.SET_NAME('IGF','IGF_AP_DUP_RECS');

Line 4680: FND_MESSAGE.SET_TOKEN('COUNT','');

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));
4682:
4683: FND_MESSAGE.SET_NAME('IGF','IGF_AP_DUP_RECS');
4684: FND_MESSAGE.SET_TOKEN('COUNT','');

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 4683: FND_MESSAGE.SET_NAME('IGF','IGF_AP_DUP_RECS');

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));
4686:
4687: FND_MESSAGE.SET_NAME('IGF','IGF_AP_BAD_RECS');

Line 4684: FND_MESSAGE.SET_TOKEN('COUNT','');

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));
4686:
4687: FND_MESSAGE.SET_NAME('IGF','IGF_AP_BAD_RECS');
4688: FND_MESSAGE.SET_TOKEN('COUNT','');

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 4687: FND_MESSAGE.SET_NAME('IGF','IGF_AP_BAD_RECS');

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));
4690:
4691: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NEW_PER_RECS');

Line 4688: FND_MESSAGE.SET_TOKEN('COUNT','');

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));
4690:
4691: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NEW_PER_RECS');
4692: FND_MESSAGE.SET_TOKEN('COUNT','');

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 4691: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NEW_PER_RECS');

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));
4694:
4695: FND_MESSAGE.SET_NAME('IGF','IGF_AP_RVW_RECS');

Line 4692: FND_MESSAGE.SET_TOKEN('COUNT','');

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));
4694:
4695: FND_MESSAGE.SET_NAME('IGF','IGF_AP_RVW_RECS');
4696: FND_MESSAGE.SET_TOKEN('COUNT','');

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 4695: FND_MESSAGE.SET_NAME('IGF','IGF_AP_RVW_RECS');

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));
4698:
4699: IF cur_css_interface%ISOPEN THEN

Line 4696: FND_MESSAGE.SET_TOKEN('COUNT','');

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));
4698:
4699: IF cur_css_interface%ISOPEN THEN
4700: CLOSE cur_css_interface;

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 4739: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

4735: IF cur_batch_aw_map%ISOPEN THEN
4736: CLOSE cur_batch_aw_map;
4737: END IF;
4738:
4739: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4740: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.main');
4741: IGS_GE_MSG_STACK.ADD;
4742: retcode := 2;
4743: errbuf:= FND_MESSAGE.GET;

Line 4740: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.main');

4736: CLOSE cur_batch_aw_map;
4737: END IF;
4738:
4739: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4740: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.main');
4741: IGS_GE_MSG_STACK.ADD;
4742: retcode := 2;
4743: errbuf:= FND_MESSAGE.GET;
4744: rollback;

Line 4743: errbuf:= FND_MESSAGE.GET;

4739: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4740: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.main');
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:

Line 4891: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

4887: WHEN others THEN
4888: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4889: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.ss_wrap_refresh_matches.exception','The exception is : ' || 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);

Line 4892: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_refresh_matches');

4888: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4889: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.ss_wrap_refresh_matches.exception','The exception is : ' || 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;

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 5099: fnd_message.set_name('IGF','IGF_AP_PROFILE_EXISTS');

5095: OPEN cur_check_duplicate_profile(g_cur_data.css_id_number, g_cur_data.stu_record_type, g_cur_data.academic_year);
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';

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 5104: fnd_message.set_name('IGF','IGF_AP_PROFILE_UPLOADED');

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');
5105: x_msg_data := fnd_message.get;
5106: x_return_status := 'S';
5107: END IF;
5108:

Line 5105: x_msg_data := 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');
5105: x_msg_data := fnd_message.get;
5106: x_return_status := 'S';
5107: END IF;
5108:
5109: -- Process new or duplicate record

Line 5116: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

5112: EXCEPTION WHEN OTHERS THEN
5113: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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';

Line 5117: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.ss_upload_profile');

5113: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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;

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: