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_SL_DL_GEN_XML dependencies on FND_MESSAGE

Line 74: fnd_message.set_name('IGF','IGF_SL_DL_PRINT_DOC_FAIL');

70: OPEN cur_doc_dtls(p_document_id_txt);
71: FETCH cur_doc_dtls INTO p_rowid,lv_document_id_txt, lc_xmldoc;
72: IF cur_doc_dtls%NOTFOUND THEN
73: CLOSE cur_doc_dtls;
74: fnd_message.set_name('IGF','IGF_SL_DL_PRINT_DOC_FAIL');
75: fnd_file.put_line(fnd_file.log, fnd_message.get);
76: RETURN;
77: ELSIF cur_doc_dtls%FOUND THEN
78: CLOSE cur_doc_dtls;

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

71: FETCH cur_doc_dtls INTO p_rowid,lv_document_id_txt, lc_xmldoc;
72: IF cur_doc_dtls%NOTFOUND THEN
73: CLOSE cur_doc_dtls;
74: fnd_message.set_name('IGF','IGF_SL_DL_PRINT_DOC_FAIL');
75: fnd_file.put_line(fnd_file.log, fnd_message.get);
76: RETURN;
77: ELSIF cur_doc_dtls%FOUND THEN
78: CLOSE cur_doc_dtls;
79: OPEN cur_doc_dtls(p_document_id_txt);

Line 114: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

110: WHEN OTHERS THEN
111: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
112: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.exception','Exception:'||SQLERRM);
113: END IF;
114: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
115: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.EDIT_CLOB');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END edit_clob;

Line 115: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.EDIT_CLOB');

111: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
112: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.exception','Exception:'||SQLERRM);
113: END IF;
114: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
115: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.EDIT_CLOB');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END edit_clob;
119:

Line 222: fnd_message.set_name('IGF','IGF_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_sl_dl_gen_xml.update_status.exception','Exception:'||SQLERRM);
221: END IF;
222: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.UPDATE_STATUS');
224: igs_ge_msg_stack.add;
225: app_exception.raise_exception;
226: END update_status;

Line 223: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.UPDATE_STATUS');

219: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
220: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.update_status.exception','Exception:'||SQLERRM);
221: END IF;
222: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.UPDATE_STATUS');
224: igs_ge_msg_stack.add;
225: app_exception.raise_exception;
226: END update_status;
227:

Line 271: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

267: WHEN OTHERS THEN
268: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
269: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.exception','Exception:'||SQLERRM);
270: END IF;
271: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
272: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.PRINT_OUT_XML');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: END print_out_xml;

Line 272: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.PRINT_OUT_XML');

268: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
269: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.exception','Exception:'||SQLERRM);
270: END IF;
271: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
272: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.PRINT_OUT_XML');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: END print_out_xml;
276:

Line 478: fnd_message.set_name('IGF','IGF_SL_COD_99_KEYS');

474: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key = ' || ln_loan_key);
475: END IF;
476:
477: IF ln_loan_key > 99 THEN
478: fnd_message.set_name('IGF','IGF_SL_COD_99_KEYS');
479: fnd_message.set_token('LOAN_NUMBER',p_loan_rec.loan_number);
480: fnd_file.put_line(fnd_file.log, fnd_message.get);
481: RETURN;
482: END IF;

Line 479: fnd_message.set_token('LOAN_NUMBER',p_loan_rec.loan_number);

475: END IF;
476:
477: IF ln_loan_key > 99 THEN
478: fnd_message.set_name('IGF','IGF_SL_COD_99_KEYS');
479: fnd_message.set_token('LOAN_NUMBER',p_loan_rec.loan_number);
480: fnd_file.put_line(fnd_file.log, fnd_message.get);
481: RETURN;
482: END IF;
483:

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

476:
477: IF ln_loan_key > 99 THEN
478: fnd_message.set_name('IGF','IGF_SL_COD_99_KEYS');
479: fnd_message.set_token('LOAN_NUMBER',p_loan_rec.loan_number);
480: fnd_file.put_line(fnd_file.log, fnd_message.get);
481: RETURN;
482: END IF;
483:
484: lv_rowid := NULL;

Line 774: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

770: WHEN OTHERS THEN
771: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
772: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.exception','Exception:'||SQLERRM);
773: END IF;
774: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
775: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.LOG_PARAMETERS');
776: app_exception.raise_exception;
777:
778: END insert_lor_loc;

Line 775: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.LOG_PARAMETERS');

771: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
772: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.exception','Exception:'||SQLERRM);
773: END IF;
774: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
775: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.LOG_PARAMETERS');
776: app_exception.raise_exception;
777:
778: END insert_lor_loc;
779:

Line 859: fnd_message.set_name('IGF',l_msg_name);

855: -- the set up is fine otherwise show the corresponding error message in the log.
856: IF l_msg_name IS NOT NULL THEN
857: --Error has occured
858: IF l_aid = 0 THEN
859: fnd_message.set_name('IGF',l_msg_name);
860: fnd_file.put_line(fnd_file.log,fnd_message.get);
861: RETURN;
862: ELSIF l_aid < 0 THEN
863: fnd_message.set_name('IGF',l_msg_name);

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

856: IF l_msg_name IS NOT NULL THEN
857: --Error has occured
858: IF l_aid = 0 THEN
859: fnd_message.set_name('IGF',l_msg_name);
860: fnd_file.put_line(fnd_file.log,fnd_message.get);
861: RETURN;
862: ELSIF l_aid < 0 THEN
863: fnd_message.set_name('IGF',l_msg_name);
864: fnd_message.set_token('FUND_CODE',p_loan_rec.fed_fund_code);

Line 863: fnd_message.set_name('IGF',l_msg_name);

859: fnd_message.set_name('IGF',l_msg_name);
860: fnd_file.put_line(fnd_file.log,fnd_message.get);
861: RETURN;
862: ELSIF l_aid < 0 THEN
863: fnd_message.set_name('IGF',l_msg_name);
864: fnd_message.set_token('FUND_CODE',p_loan_rec.fed_fund_code);
865: fnd_file.put_line(fnd_file.log,fnd_message.get);
866: END IF ;
867: END IF;

Line 864: fnd_message.set_token('FUND_CODE',p_loan_rec.fed_fund_code);

860: fnd_file.put_line(fnd_file.log,fnd_message.get);
861: RETURN;
862: ELSIF l_aid < 0 THEN
863: fnd_message.set_name('IGF',l_msg_name);
864: fnd_message.set_token('FUND_CODE',p_loan_rec.fed_fund_code);
865: fnd_file.put_line(fnd_file.log,fnd_message.get);
866: END IF ;
867: END IF;
868: END IF;

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

861: RETURN;
862: ELSIF l_aid < 0 THEN
863: fnd_message.set_name('IGF',l_msg_name);
864: fnd_message.set_token('FUND_CODE',p_loan_rec.fed_fund_code);
865: fnd_file.put_line(fnd_file.log,fnd_message.get);
866: END IF ;
867: END IF;
868: END IF;
869:

Line 903: fnd_message.set_name('IGF','IGF_SL_DOB_MISMATCH');

899:
900: --akomurav
901: IF isir_info_rec.date_of_birth <> student_dtl_rec.p_date_of_birth THEN
902:
903: fnd_message.set_name('IGF','IGF_SL_DOB_MISMATCH');
904: fnd_message.set_token('P_DOB',to_char(student_dtl_rec.p_date_of_birth));
905: fnd_message.set_token('ISIR_DOB',to_char(isir_info_rec.date_of_birth));
906: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
907: student_dtl_rec.p_date_of_birth := isir_info_rec.date_of_birth;

Line 904: fnd_message.set_token('P_DOB',to_char(student_dtl_rec.p_date_of_birth));

900: --akomurav
901: IF isir_info_rec.date_of_birth <> student_dtl_rec.p_date_of_birth THEN
902:
903: fnd_message.set_name('IGF','IGF_SL_DOB_MISMATCH');
904: fnd_message.set_token('P_DOB',to_char(student_dtl_rec.p_date_of_birth));
905: fnd_message.set_token('ISIR_DOB',to_char(isir_info_rec.date_of_birth));
906: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
907: student_dtl_rec.p_date_of_birth := isir_info_rec.date_of_birth;
908:

Line 905: fnd_message.set_token('ISIR_DOB',to_char(isir_info_rec.date_of_birth));

901: IF isir_info_rec.date_of_birth <> student_dtl_rec.p_date_of_birth THEN
902:
903: fnd_message.set_name('IGF','IGF_SL_DOB_MISMATCH');
904: fnd_message.set_token('P_DOB',to_char(student_dtl_rec.p_date_of_birth));
905: fnd_message.set_token('ISIR_DOB',to_char(isir_info_rec.date_of_birth));
906: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
907: student_dtl_rec.p_date_of_birth := isir_info_rec.date_of_birth;
908:
909: END IF;

Line 906: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);

902:
903: fnd_message.set_name('IGF','IGF_SL_DOB_MISMATCH');
904: fnd_message.set_token('P_DOB',to_char(student_dtl_rec.p_date_of_birth));
905: fnd_message.set_token('ISIR_DOB',to_char(isir_info_rec.date_of_birth));
906: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
907: student_dtl_rec.p_date_of_birth := isir_info_rec.date_of_birth;
908:
909: END IF;
910:

Line 913: fnd_message.set_name('IGF','IGF_SL_SSN_MISMATCH');

909: END IF;
910:
911: IF isir_info_rec.current_ssn <> student_dtl_rec.p_ssn THEN
912:
913: fnd_message.set_name('IGF','IGF_SL_SSN_MISMATCH');
914: fnd_message.set_token('P_SSN',student_dtl_rec.p_ssn);
915: fnd_message.set_token('ISIR_SSN',isir_info_rec.current_ssn);
916: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
917: student_dtl_rec.p_ssn := isir_info_rec.current_ssn;

Line 914: fnd_message.set_token('P_SSN',student_dtl_rec.p_ssn);

910:
911: IF isir_info_rec.current_ssn <> student_dtl_rec.p_ssn THEN
912:
913: fnd_message.set_name('IGF','IGF_SL_SSN_MISMATCH');
914: fnd_message.set_token('P_SSN',student_dtl_rec.p_ssn);
915: fnd_message.set_token('ISIR_SSN',isir_info_rec.current_ssn);
916: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
917: student_dtl_rec.p_ssn := isir_info_rec.current_ssn;
918:

Line 915: fnd_message.set_token('ISIR_SSN',isir_info_rec.current_ssn);

911: IF isir_info_rec.current_ssn <> student_dtl_rec.p_ssn THEN
912:
913: fnd_message.set_name('IGF','IGF_SL_SSN_MISMATCH');
914: fnd_message.set_token('P_SSN',student_dtl_rec.p_ssn);
915: fnd_message.set_token('ISIR_SSN',isir_info_rec.current_ssn);
916: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
917: student_dtl_rec.p_ssn := isir_info_rec.current_ssn;
918:
919: END IF;

Line 916: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);

912:
913: fnd_message.set_name('IGF','IGF_SL_SSN_MISMATCH');
914: fnd_message.set_token('P_SSN',student_dtl_rec.p_ssn);
915: fnd_message.set_token('ISIR_SSN',isir_info_rec.current_ssn);
916: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
917: student_dtl_rec.p_ssn := isir_info_rec.current_ssn;
918:
919: END IF;
920:

Line 923: fnd_message.set_name('IGF','IGF_SL_NAME_MISMATCH');

919: END IF;
920:
921: IF isir_info_rec.last_name <> UPPER(student_dtl_rec.p_last_name) THEN
922:
923: fnd_message.set_name('IGF','IGF_SL_NAME_MISMATCH');
924: fnd_message.set_token('P_LAST_NAME',UPPER(student_dtl_rec.p_last_name));
925: fnd_message.set_token('ISIR_NAME',UPPER(isir_info_rec.last_name));
926: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
927: student_dtl_rec.p_last_name := UPPER(isir_info_rec.last_name);

Line 924: fnd_message.set_token('P_LAST_NAME',UPPER(student_dtl_rec.p_last_name));

920:
921: IF isir_info_rec.last_name <> UPPER(student_dtl_rec.p_last_name) THEN
922:
923: fnd_message.set_name('IGF','IGF_SL_NAME_MISMATCH');
924: fnd_message.set_token('P_LAST_NAME',UPPER(student_dtl_rec.p_last_name));
925: fnd_message.set_token('ISIR_NAME',UPPER(isir_info_rec.last_name));
926: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
927: student_dtl_rec.p_last_name := UPPER(isir_info_rec.last_name);
928:

Line 925: fnd_message.set_token('ISIR_NAME',UPPER(isir_info_rec.last_name));

921: IF isir_info_rec.last_name <> UPPER(student_dtl_rec.p_last_name) THEN
922:
923: fnd_message.set_name('IGF','IGF_SL_NAME_MISMATCH');
924: fnd_message.set_token('P_LAST_NAME',UPPER(student_dtl_rec.p_last_name));
925: fnd_message.set_token('ISIR_NAME',UPPER(isir_info_rec.last_name));
926: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
927: student_dtl_rec.p_last_name := UPPER(isir_info_rec.last_name);
928:
929:

Line 926: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);

922:
923: fnd_message.set_name('IGF','IGF_SL_NAME_MISMATCH');
924: fnd_message.set_token('P_LAST_NAME',UPPER(student_dtl_rec.p_last_name));
925: fnd_message.set_token('ISIR_NAME',UPPER(isir_info_rec.last_name));
926: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get);
927: student_dtl_rec.p_last_name := UPPER(isir_info_rec.last_name);
928:
929:
930:

Line 954: fnd_message.set_name('IGF','IGF_SL_DL_XML_INSERT_EXC');

950: WHEN OTHERS THEN
951: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
952: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.process_loan.exception','Exception:'||SQLERRM);
953: END IF;
954: fnd_message.set_name('IGF','IGF_SL_DL_XML_INSERT_EXC');
955: fnd_message.set_token('LOAN_NUMBER',p_loan_rec.loan_number);
956: fnd_file.put_line(fnd_file.log,fnd_message.get);
957: fnd_file.put_line(fnd_file.log,SQLERRM);
958: IF lb_spoint_est THEN

Line 955: fnd_message.set_token('LOAN_NUMBER',p_loan_rec.loan_number);

951: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
952: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.process_loan.exception','Exception:'||SQLERRM);
953: END IF;
954: fnd_message.set_name('IGF','IGF_SL_DL_XML_INSERT_EXC');
955: fnd_message.set_token('LOAN_NUMBER',p_loan_rec.loan_number);
956: fnd_file.put_line(fnd_file.log,fnd_message.get);
957: fnd_file.put_line(fnd_file.log,SQLERRM);
958: IF lb_spoint_est THEN
959: lb_spoint_est := FALSE;

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

952: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.process_loan.exception','Exception:'||SQLERRM);
953: END IF;
954: fnd_message.set_name('IGF','IGF_SL_DL_XML_INSERT_EXC');
955: fnd_message.set_token('LOAN_NUMBER',p_loan_rec.loan_number);
956: fnd_file.put_line(fnd_file.log,fnd_message.get);
957: fnd_file.put_line(fnd_file.log,SQLERRM);
958: IF lb_spoint_est THEN
959: lb_spoint_est := FALSE;
960: ROLLBACK TO IGFSL25B_PROCESS_LOAN;

Line 1013: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1009: END IF;
1010:
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1014: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.PER_IN_FA');
1015: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1016: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.per_in_fa.exception','Exception:'||SQLERRM);
1017: END IF;

Line 1014: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.PER_IN_FA');

1010:
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1014: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.PER_IN_FA');
1015: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1016: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.per_in_fa.exception','Exception:'||SQLERRM);
1017: END IF;
1018: igs_ge_msg_stack.add;

Line 1092: fnd_message.set_name('IGF','IGF_SL_COD_RAISE_EVENT');

1088: p_event_key => l_event_key,
1089: p_parameters => l_parameter_list);
1090:
1091:
1092: fnd_message.set_name('IGF','IGF_SL_COD_RAISE_EVENT');
1093: fnd_message.set_token('EVENT_KEY_VALUE',l_event_key);
1094: fnd_file.new_line(fnd_file.log,1);
1095: fnd_file.put_line(fnd_file.log,fnd_message.get);
1096: fnd_file.new_line(fnd_file.log,1);

Line 1093: fnd_message.set_token('EVENT_KEY_VALUE',l_event_key);

1089: p_parameters => l_parameter_list);
1090:
1091:
1092: fnd_message.set_name('IGF','IGF_SL_COD_RAISE_EVENT');
1093: fnd_message.set_token('EVENT_KEY_VALUE',l_event_key);
1094: fnd_file.new_line(fnd_file.log,1);
1095: fnd_file.put_line(fnd_file.log,fnd_message.get);
1096: fnd_file.new_line(fnd_file.log,1);
1097:

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

1091:
1092: fnd_message.set_name('IGF','IGF_SL_COD_RAISE_EVENT');
1093: fnd_message.set_token('EVENT_KEY_VALUE',l_event_key);
1094: fnd_file.new_line(fnd_file.log,1);
1095: fnd_file.put_line(fnd_file.log,fnd_message.get);
1096: fnd_file.new_line(fnd_file.log,1);
1097:
1098: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','raised event ');

Line 1107: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1103: WHEN OTHERS THEN
1104: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1105: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.exception','Exception:'||SQLERRM);
1106: END IF;
1107: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1108: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.SUBMIT_XML_EVENT');
1109: igs_ge_msg_stack.add;
1110: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.debug','sqlerrm ' || SQLERRM);

Line 1108: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.SUBMIT_XML_EVENT');

1104: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1105: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.exception','Exception:'||SQLERRM);
1106: END IF;
1107: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1108: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.SUBMIT_XML_EVENT');
1109: igs_ge_msg_stack.add;
1110: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.debug','sqlerrm ' || SQLERRM);
1112: END IF;

Line 1306: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1302: WHEN OTHERS THEN
1303: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1304: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.exception','Exception:'||SQLERRM);
1305: END IF;
1306: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1307: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.LOG_PARAMETERS');
1308: igs_ge_msg_stack.add;
1309: app_exception.raise_exception;
1310:

Line 1307: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.LOG_PARAMETERS');

1303: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1304: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.exception','Exception:'||SQLERRM);
1305: END IF;
1306: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1307: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.LOG_PARAMETERS');
1308: igs_ge_msg_stack.add;
1309: app_exception.raise_exception;
1310:
1311: END log_parameters;

Line 1517: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');

1513: END IF;
1514:
1515: -- 2. Validate parameters
1516: IF p_award_year IS NULL OR lv_cal_type IS NULL OR ln_seq_number IS NULL THEN
1517: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
1518: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'));
1519: fnd_file.put_line(fnd_file.log, fnd_message.get);
1520: fnd_file.new_line(fnd_file.log, 1);
1521: RETURN;

Line 1518: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'));

1514:
1515: -- 2. Validate parameters
1516: IF p_award_year IS NULL OR lv_cal_type IS NULL OR ln_seq_number IS NULL THEN
1517: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
1518: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'));
1519: fnd_file.put_line(fnd_file.log, fnd_message.get);
1520: fnd_file.new_line(fnd_file.log, 1);
1521: RETURN;
1522: END IF;

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

1515: -- 2. Validate parameters
1516: IF p_award_year IS NULL OR lv_cal_type IS NULL OR ln_seq_number IS NULL THEN
1517: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
1518: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'));
1519: fnd_file.put_line(fnd_file.log, fnd_message.get);
1520: fnd_file.new_line(fnd_file.log, 1);
1521: RETURN;
1522: END IF;
1523:

Line 1529: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');

1525: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award year is not null');
1526: END IF;
1527:
1528: IF TRIM(p_source_id) IS NULL THEN
1529: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
1530: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SOURCE_ENTITY_ID'));
1531: fnd_file.put_line(fnd_file.log, fnd_message.get);
1532: fnd_file.new_line(fnd_file.log, 1);
1533: RETURN;

Line 1530: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SOURCE_ENTITY_ID'));

1526: END IF;
1527:
1528: IF TRIM(p_source_id) IS NULL THEN
1529: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
1530: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SOURCE_ENTITY_ID'));
1531: fnd_file.put_line(fnd_file.log, fnd_message.get);
1532: fnd_file.new_line(fnd_file.log, 1);
1533: RETURN;
1534: END IF;

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

1527:
1528: IF TRIM(p_source_id) IS NULL THEN
1529: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
1530: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SOURCE_ENTITY_ID'));
1531: fnd_file.put_line(fnd_file.log, fnd_message.get);
1532: fnd_file.new_line(fnd_file.log, 1);
1533: RETURN;
1534: END IF;
1535:

Line 1538: fnd_message.set_name('IGF','IGF_SL_COD_INVL_SOURCE_ID');

1534: END IF;
1535:
1536: IF LENGTH(TRIM(p_source_id)) > 8 OR TRIM(p_source_id) > 99999999
1537: OR NOT igf_sl_dl_validation.validate_id(p_source_id) THEN
1538: fnd_message.set_name('IGF','IGF_SL_COD_INVL_SOURCE_ID');
1539: fnd_file.put_line(fnd_file.log, fnd_message.get);
1540: fnd_file.new_line(fnd_file.log, 1);
1541: RETURN;
1542: END IF;

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

1535:
1536: IF LENGTH(TRIM(p_source_id)) > 8 OR TRIM(p_source_id) > 99999999
1537: OR NOT igf_sl_dl_validation.validate_id(p_source_id) THEN
1538: fnd_message.set_name('IGF','IGF_SL_COD_INVL_SOURCE_ID');
1539: fnd_file.put_line(fnd_file.log, fnd_message.get);
1540: fnd_file.new_line(fnd_file.log, 1);
1541: RETURN;
1542: END IF;
1543:

Line 1549: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');

1545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','source id is not null');
1546: END IF;
1547:
1548: IF p_pgroup_id IS NOT NULL AND p_base_id IS NOT NULL THEN
1549: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
1550: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
1551: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
1552: fnd_file.put_line(fnd_file.log, fnd_message.get);
1553: fnd_file.new_line(fnd_file.log, 1);

Line 1550: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));

1546: END IF;
1547:
1548: IF p_pgroup_id IS NOT NULL AND p_base_id IS NOT NULL THEN
1549: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
1550: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
1551: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
1552: fnd_file.put_line(fnd_file.log, fnd_message.get);
1553: fnd_file.new_line(fnd_file.log, 1);
1554: RETURN;

Line 1551: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));

1547:
1548: IF p_pgroup_id IS NOT NULL AND p_base_id IS NOT NULL THEN
1549: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
1550: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
1551: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
1552: fnd_file.put_line(fnd_file.log, fnd_message.get);
1553: fnd_file.new_line(fnd_file.log, 1);
1554: RETURN;
1555: END IF;

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

1548: IF p_pgroup_id IS NOT NULL AND p_base_id IS NOT NULL THEN
1549: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
1550: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
1551: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
1552: fnd_file.put_line(fnd_file.log, fnd_message.get);
1553: fnd_file.new_line(fnd_file.log, 1);
1554: RETURN;
1555: END IF;
1556:

Line 1562: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');

1558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','base id and pgroup id check');
1559: END IF;
1560:
1561: IF p_pgroup_id IS NOT NULL AND p_loan_id IS NOT NULL THEN
1562: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
1563: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
1564: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
1565: fnd_file.put_line(fnd_file.log, fnd_message.get);
1566: fnd_file.new_line(fnd_file.log, 1);

Line 1563: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));

1559: END IF;
1560:
1561: IF p_pgroup_id IS NOT NULL AND p_loan_id IS NOT NULL THEN
1562: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
1563: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
1564: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
1565: fnd_file.put_line(fnd_file.log, fnd_message.get);
1566: fnd_file.new_line(fnd_file.log, 1);
1567: RETURN;

Line 1564: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));

1560:
1561: IF p_pgroup_id IS NOT NULL AND p_loan_id IS NOT NULL THEN
1562: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
1563: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
1564: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
1565: fnd_file.put_line(fnd_file.log, fnd_message.get);
1566: fnd_file.new_line(fnd_file.log, 1);
1567: RETURN;
1568: END IF;

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

1561: IF p_pgroup_id IS NOT NULL AND p_loan_id IS NOT NULL THEN
1562: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
1563: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
1564: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
1565: fnd_file.put_line(fnd_file.log, fnd_message.get);
1566: fnd_file.new_line(fnd_file.log, 1);
1567: RETURN;
1568: END IF;
1569:

Line 1575: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATD_PARAM');

1571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','loan id and pgroup id check');
1572: END IF;
1573:
1574: IF p_attend_id IS NOT NULL AND p_report_id IS NULL THEN
1575: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATD_PARAM');
1576: fnd_file.put_line(fnd_file.log, fnd_message.get);
1577: fnd_file.new_line(fnd_file.log, 1);
1578: RETURN;
1579: END IF;

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

1572: END IF;
1573:
1574: IF p_attend_id IS NOT NULL AND p_report_id IS NULL THEN
1575: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATD_PARAM');
1576: fnd_file.put_line(fnd_file.log, fnd_message.get);
1577: fnd_file.new_line(fnd_file.log, 1);
1578: RETURN;
1579: END IF;
1580:

Line 1593: fnd_message.set_name('IGF','IGF_SL_COD_INV_AWD_YR');

1589: IF award_year_rec.sys_award_year IS NULL OR
1590: award_year_rec.dl_participant_code IS NULL OR
1591: award_year_rec.award_year_status_code IS NULL
1592: THEN
1593: fnd_message.set_name('IGF','IGF_SL_COD_INV_AWD_YR');
1594: fnd_file.put_line(fnd_file.log, fnd_message.get);
1595: fnd_file.new_line(fnd_file.log, 1);
1596: RETURN;
1597: END IF;

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

1590: award_year_rec.dl_participant_code IS NULL OR
1591: award_year_rec.award_year_status_code IS NULL
1592: THEN
1593: fnd_message.set_name('IGF','IGF_SL_COD_INV_AWD_YR');
1594: fnd_file.put_line(fnd_file.log, fnd_message.get);
1595: fnd_file.new_line(fnd_file.log, 1);
1596: RETURN;
1597: END IF;
1598:

Line 1607: fnd_message.set_name('IGF','IGF_SL_COD_AWDYR_OPEN');

1603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award year status code ' || award_year_rec.award_year_status_code);
1604: END IF;
1605:
1606: IF award_year_rec.award_year_status_code <> 'O' THEN
1607: fnd_message.set_name('IGF','IGF_SL_COD_AWDYR_OPEN');
1608: fnd_file.put_line(fnd_file.log, fnd_message.get);
1609: fnd_file.new_line(fnd_file.log, 1);
1610: RETURN;
1611: END IF;

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

1604: END IF;
1605:
1606: IF award_year_rec.award_year_status_code <> 'O' THEN
1607: fnd_message.set_name('IGF','IGF_SL_COD_AWDYR_OPEN');
1608: fnd_file.put_line(fnd_file.log, fnd_message.get);
1609: fnd_file.new_line(fnd_file.log, 1);
1610: RETURN;
1611: END IF;
1612:

Line 1614: fnd_message.set_name('IGF','IGF_SL_COD_AWDYR_FULL');

1610: RETURN;
1611: END IF;
1612:
1613: IF award_year_rec.dl_participant_code <> 'FULL_PARTICIPANT' THEN
1614: fnd_message.set_name('IGF','IGF_SL_COD_AWDYR_FULL');
1615: fnd_file.put_line(fnd_file.log, fnd_message.get);
1616: fnd_file.new_line(fnd_file.log, 1);
1617: RETURN;
1618: END IF;

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

1611: END IF;
1612:
1613: IF award_year_rec.dl_participant_code <> 'FULL_PARTICIPANT' THEN
1614: fnd_message.set_name('IGF','IGF_SL_COD_AWDYR_FULL');
1615: fnd_file.put_line(fnd_file.log, fnd_message.get);
1616: fnd_file.new_line(fnd_file.log, 1);
1617: RETURN;
1618: END IF;
1619:

Line 1621: fnd_message.set_name('IGF','IGF_SL_COD_XML_SUPPORT');

1617: RETURN;
1618: END IF;
1619:
1620: IF award_year_rec.sys_award_year < '0405' THEN
1621: fnd_message.set_name('IGF','IGF_SL_COD_XML_SUPPORT');
1622: fnd_file.put_line(fnd_file.log, fnd_message.get);
1623: fnd_file.new_line(fnd_file.log, 1);
1624: RETURN;
1625: END IF;

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

1618: END IF;
1619:
1620: IF award_year_rec.sys_award_year < '0405' THEN
1621: fnd_message.set_name('IGF','IGF_SL_COD_XML_SUPPORT');
1622: fnd_file.put_line(fnd_file.log, fnd_message.get);
1623: fnd_file.new_line(fnd_file.log, 1);
1624: RETURN;
1625: END IF;
1626:

Line 1632: fnd_message.set_name('IGF','IGF_SL_COD_INV_SRC_ID');

1628: FETCH cur_source_id INTO source_id_rec;
1629: CLOSE cur_source_id;
1630:
1631: IF source_id_rec.rep_entity_id_txt IS NULL THEN
1632: fnd_message.set_name('IGF','IGF_SL_COD_INV_SRC_ID');
1633: fnd_file.put_line(fnd_file.log, fnd_message.get);
1634: fnd_file.new_line(fnd_file.log, 1);
1635: RETURN;
1636: END IF;

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

1629: CLOSE cur_source_id;
1630:
1631: IF source_id_rec.rep_entity_id_txt IS NULL THEN
1632: fnd_message.set_name('IGF','IGF_SL_COD_INV_SRC_ID');
1633: fnd_file.put_line(fnd_file.log, fnd_message.get);
1634: fnd_file.new_line(fnd_file.log, 1);
1635: RETURN;
1636: END IF;
1637:

Line 1645: fnd_message.set_name('IGF','IGF_SL_COD_INV_REP_ID');

1641: FETCH cur_report_id INTO report_id_rec;
1642: CLOSE cur_report_id;
1643:
1644: IF report_id_rec.loan_id IS NULL THEN
1645: fnd_message.set_name('IGF','IGF_SL_COD_INV_REP_ID');
1646: fnd_message.set_token('REPORTING_ID',p_report_id);
1647: fnd_file.put_line(fnd_file.log, fnd_message.get);
1648: fnd_file.new_line(fnd_file.log, 1);
1649: RETURN;

Line 1646: fnd_message.set_token('REPORTING_ID',p_report_id);

1642: CLOSE cur_report_id;
1643:
1644: IF report_id_rec.loan_id IS NULL THEN
1645: fnd_message.set_name('IGF','IGF_SL_COD_INV_REP_ID');
1646: fnd_message.set_token('REPORTING_ID',p_report_id);
1647: fnd_file.put_line(fnd_file.log, fnd_message.get);
1648: fnd_file.new_line(fnd_file.log, 1);
1649: RETURN;
1650: END IF;

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

1643:
1644: IF report_id_rec.loan_id IS NULL THEN
1645: fnd_message.set_name('IGF','IGF_SL_COD_INV_REP_ID');
1646: fnd_message.set_token('REPORTING_ID',p_report_id);
1647: fnd_file.put_line(fnd_file.log, fnd_message.get);
1648: fnd_file.new_line(fnd_file.log, 1);
1649: RETURN;
1650: END IF;
1651:

Line 1658: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATD_ID');

1654: FETCH cur_attend_id INTO attend_id_rec;
1655: CLOSE cur_attend_id;
1656:
1657: IF attend_id_rec.loan_id IS NULL THEN
1658: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATD_ID');
1659: fnd_message.set_token('REPORTING_ID',p_report_id);
1660: fnd_message.set_token('ATTENDING_ID',p_attend_id);
1661: fnd_file.put_line(fnd_file.log, fnd_message.get);
1662: fnd_file.new_line(fnd_file.log, 1);

Line 1659: fnd_message.set_token('REPORTING_ID',p_report_id);

1655: CLOSE cur_attend_id;
1656:
1657: IF attend_id_rec.loan_id IS NULL THEN
1658: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATD_ID');
1659: fnd_message.set_token('REPORTING_ID',p_report_id);
1660: fnd_message.set_token('ATTENDING_ID',p_attend_id);
1661: fnd_file.put_line(fnd_file.log, fnd_message.get);
1662: fnd_file.new_line(fnd_file.log, 1);
1663: RETURN;

Line 1660: fnd_message.set_token('ATTENDING_ID',p_attend_id);

1656:
1657: IF attend_id_rec.loan_id IS NULL THEN
1658: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATD_ID');
1659: fnd_message.set_token('REPORTING_ID',p_report_id);
1660: fnd_message.set_token('ATTENDING_ID',p_attend_id);
1661: fnd_file.put_line(fnd_file.log, fnd_message.get);
1662: fnd_file.new_line(fnd_file.log, 1);
1663: RETURN;
1664: END IF;

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

1657: IF attend_id_rec.loan_id IS NULL THEN
1658: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATD_ID');
1659: fnd_message.set_token('REPORTING_ID',p_report_id);
1660: fnd_message.set_token('ATTENDING_ID',p_attend_id);
1661: fnd_file.put_line(fnd_file.log, fnd_message.get);
1662: fnd_file.new_line(fnd_file.log, 1);
1663: RETURN;
1664: END IF;
1665: END IF;

Line 1673: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');

1669: IF p_base_id IS NOT NULL AND
1670: ( igf_gr_gen.get_per_num(p_base_id) IS NULL OR
1671: NOT check_fa_rec(p_base_id, lv_cal_type, ln_seq_number))
1672: THEN
1673: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');
1674: fnd_file.put_line(fnd_file.log, fnd_message.get);
1675: fnd_file.new_line(fnd_file.log, 1);
1676: RETURN;
1677: END IF;

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

1670: ( igf_gr_gen.get_per_num(p_base_id) IS NULL OR
1671: NOT check_fa_rec(p_base_id, lv_cal_type, ln_seq_number))
1672: THEN
1673: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');
1674: fnd_file.put_line(fnd_file.log, fnd_message.get);
1675: fnd_file.new_line(fnd_file.log, 1);
1676: RETURN;
1677: END IF;
1678:

Line 1684: fnd_message.set_name('IGF','IGF_SL_COD_NO_ORIG_REC');

1680: OPEN cur_chk_loan(p_base_id);
1681: FETCH cur_chk_loan INTO chk_loan_rec;
1682: CLOSE cur_chk_loan;
1683: IF chk_loan_rec.loan_id IS NULL THEN
1684: fnd_message.set_name('IGF','IGF_SL_COD_NO_ORIG_REC');
1685: fnd_message.set_token('PERSON_NUMBER', igf_gr_gen.get_per_num(p_base_id));
1686: fnd_file.put_line(fnd_file.log, fnd_message.get);
1687: fnd_file.new_line(fnd_file.log, 1);
1688: RETURN;

Line 1685: fnd_message.set_token('PERSON_NUMBER', igf_gr_gen.get_per_num(p_base_id));

1681: FETCH cur_chk_loan INTO chk_loan_rec;
1682: CLOSE cur_chk_loan;
1683: IF chk_loan_rec.loan_id IS NULL THEN
1684: fnd_message.set_name('IGF','IGF_SL_COD_NO_ORIG_REC');
1685: fnd_message.set_token('PERSON_NUMBER', igf_gr_gen.get_per_num(p_base_id));
1686: fnd_file.put_line(fnd_file.log, fnd_message.get);
1687: fnd_file.new_line(fnd_file.log, 1);
1688: RETURN;
1689: END IF;

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

1682: CLOSE cur_chk_loan;
1683: IF chk_loan_rec.loan_id IS NULL THEN
1684: fnd_message.set_name('IGF','IGF_SL_COD_NO_ORIG_REC');
1685: fnd_message.set_token('PERSON_NUMBER', igf_gr_gen.get_per_num(p_base_id));
1686: fnd_file.put_line(fnd_file.log, fnd_message.get);
1687: fnd_file.new_line(fnd_file.log, 1);
1688: RETURN;
1689: END IF;
1690: END IF;

Line 1697: fnd_message.set_name('IGF','IGF_SL_COD_PERSID_GRP_INV');

1693: OPEN cur_chk_pidgroup (p_pgroup_id);
1694: FETCH cur_chk_pidgroup INTO chk_pidgroup_rec;
1695: CLOSE cur_chk_pidgroup;
1696: IF chk_pidgroup_rec.group_id IS NULL THEN
1697: fnd_message.set_name('IGF','IGF_SL_COD_PERSID_GRP_INV');
1698: fnd_file.put_line(fnd_file.log, fnd_message.get);
1699: fnd_file.new_line(fnd_file.log, 1);
1700: RETURN;
1701: END IF;

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

1694: FETCH cur_chk_pidgroup INTO chk_pidgroup_rec;
1695: CLOSE cur_chk_pidgroup;
1696: IF chk_pidgroup_rec.group_id IS NULL THEN
1697: fnd_message.set_name('IGF','IGF_SL_COD_PERSID_GRP_INV');
1698: fnd_file.put_line(fnd_file.log, fnd_message.get);
1699: fnd_file.new_line(fnd_file.log, 1);
1700: RETURN;
1701: END IF;
1702: END IF;

Line 1717: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');

1713:
1714: lb_record_exist := FALSE;
1715:
1716: IF p_base_id IS NOT NULL THEN
1717: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1718: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
1719: fnd_file.put_line(fnd_file.log, fnd_message.get);
1720: FOR rec IN cur_pick_loans (lv_cal_type,ln_seq_number,
1721: p_base_id,p_report_id,p_attend_id,

Line 1718: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));

1714: lb_record_exist := FALSE;
1715:
1716: IF p_base_id IS NOT NULL THEN
1717: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1718: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
1719: fnd_file.put_line(fnd_file.log, fnd_message.get);
1720: FOR rec IN cur_pick_loans (lv_cal_type,ln_seq_number,
1721: p_base_id,p_report_id,p_attend_id,
1722: p_fund_id,p_loan_id)

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

1715:
1716: IF p_base_id IS NOT NULL THEN
1717: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1718: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
1719: fnd_file.put_line(fnd_file.log, fnd_message.get);
1720: FOR rec IN cur_pick_loans (lv_cal_type,ln_seq_number,
1721: p_base_id,p_report_id,p_attend_id,
1722: p_fund_id,p_loan_id)
1723: LOOP

Line 1732: fnd_message.set_name('IGF','IGF_SL_NO_LOR_XML_REC');

1728: END IF;
1729: END LOOP;
1730: IF NOT lb_record_exist THEN
1731: fnd_file.new_line(fnd_file.log, 1);
1732: fnd_message.set_name('IGF','IGF_SL_NO_LOR_XML_REC');
1733: fnd_file.put_line(fnd_file.log, fnd_message.get);
1734: fnd_file.new_line(fnd_file.log, 1);
1735: RETURN;
1736: END IF;

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

1729: END LOOP;
1730: IF NOT lb_record_exist THEN
1731: fnd_file.new_line(fnd_file.log, 1);
1732: fnd_message.set_name('IGF','IGF_SL_NO_LOR_XML_REC');
1733: fnd_file.put_line(fnd_file.log, fnd_message.get);
1734: fnd_file.new_line(fnd_file.log, 1);
1735: RETURN;
1736: END IF;
1737: END IF;

Line 1740: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');

1736: END IF;
1737: END IF;
1738:
1739: IF p_pgroup_id IS NOT NULL THEN
1740: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
1741: fnd_message.set_token('P_PER_GRP',get_grp_name(p_pgroup_id));
1742: fnd_file.new_line(fnd_file.log, 1);
1743: fnd_file.put_line(fnd_file.log, fnd_message.get);
1744:

Line 1741: fnd_message.set_token('P_PER_GRP',get_grp_name(p_pgroup_id));

1737: END IF;
1738:
1739: IF p_pgroup_id IS NOT NULL THEN
1740: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
1741: fnd_message.set_token('P_PER_GRP',get_grp_name(p_pgroup_id));
1742: fnd_file.new_line(fnd_file.log, 1);
1743: fnd_file.put_line(fnd_file.log, fnd_message.get);
1744:
1745: --Bug #5021084

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

1739: IF p_pgroup_id IS NOT NULL THEN
1740: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
1741: fnd_message.set_token('P_PER_GRP',get_grp_name(p_pgroup_id));
1742: fnd_file.new_line(fnd_file.log, 1);
1743: fnd_file.put_line(fnd_file.log, fnd_message.get);
1744:
1745: --Bug #5021084
1746: l_list := igf_ap_ss_pkg.get_pid(p_pgroup_id,lv_status,lv_group_type);
1747:

Line 1763: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');

1759: END IF;
1760:
1761: IF cur_per_grp%NOTFOUND THEN
1762: CLOSE cur_per_grp;
1763: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1764: fnd_file.put_line(fnd_file.log,fnd_message.get);
1765: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','No persons in group '||p_pgroup_id);
1767: END IF;

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

1760:
1761: IF cur_per_grp%NOTFOUND THEN
1762: CLOSE cur_per_grp;
1763: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1764: fnd_file.put_line(fnd_file.log,fnd_message.get);
1765: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','No persons in group '||p_pgroup_id);
1767: END IF;
1768: ELSE

Line 1777: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');

1773: lv_person_number := NULL;
1774: lv_person_number := per_in_fa (l_person_id,lv_cal_type,ln_seq_number,ln_base_id);
1775: IF lv_person_number IS NOT NULL THEN
1776: IF ln_base_id IS NOT NULL THEN
1777: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1778: fnd_message.set_token('STDNT',lv_person_number);
1779: fnd_file.put_line(fnd_file.log, fnd_message.get);
1780: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1781: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG base id ' || ln_base_id);

Line 1778: fnd_message.set_token('STDNT',lv_person_number);

1774: lv_person_number := per_in_fa (l_person_id,lv_cal_type,ln_seq_number,ln_base_id);
1775: IF lv_person_number IS NOT NULL THEN
1776: IF ln_base_id IS NOT NULL THEN
1777: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1778: fnd_message.set_token('STDNT',lv_person_number);
1779: fnd_file.put_line(fnd_file.log, fnd_message.get);
1780: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1781: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG base id ' || ln_base_id);
1782: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG lv_person_number ' || lv_person_number);

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

1775: IF lv_person_number IS NOT NULL THEN
1776: IF ln_base_id IS NOT NULL THEN
1777: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1778: fnd_message.set_token('STDNT',lv_person_number);
1779: fnd_file.put_line(fnd_file.log, fnd_message.get);
1780: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1781: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG base id ' || ln_base_id);
1782: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG lv_person_number ' || lv_person_number);
1783: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG l_person_id ' || l_person_id);

Line 1799: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');

1795: lb_record_exist := TRUE;
1796: END IF;
1797: END LOOP;
1798: ELSE -- log a message and skip this person, base id not found
1799: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
1800: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
1801: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(lv_cal_type,ln_seq_number));
1802: fnd_file.put_line(fnd_file.log,fnd_message.get);
1803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1800: fnd_message.set_token('PERSON_NUMBER',lv_person_number);

1796: END IF;
1797: END LOOP;
1798: ELSE -- log a message and skip this person, base id not found
1799: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
1800: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
1801: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(lv_cal_type,ln_seq_number));
1802: fnd_file.put_line(fnd_file.log,fnd_message.get);
1803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');

Line 1801: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(lv_cal_type,ln_seq_number));

1797: END LOOP;
1798: ELSE -- log a message and skip this person, base id not found
1799: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
1800: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
1801: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(lv_cal_type,ln_seq_number));
1802: fnd_file.put_line(fnd_file.log,fnd_message.get);
1803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
1805: END IF;

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

1798: ELSE -- log a message and skip this person, base id not found
1799: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
1800: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
1801: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(lv_cal_type,ln_seq_number));
1802: fnd_file.put_line(fnd_file.log,fnd_message.get);
1803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
1805: END IF;
1806: END IF; -- base id not found

Line 1808: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');

1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
1805: END IF;
1806: END IF; -- base id not found
1807: ELSE
1808: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
1809: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);
1810: END IF; -- person number not null
1811:
1812: FETCH cur_per_grp INTO l_person_id;

Line 1809: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);

1805: END IF;
1806: END IF; -- base id not found
1807: ELSE
1808: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
1809: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);
1810: END IF; -- person number not null
1811:
1812: FETCH cur_per_grp INTO l_person_id;
1813: EXIT WHEN cur_per_grp%NOTFOUND;

Line 1817: fnd_message.set_name('IGF','IGF_SL_NO_LOR_XML_REC');

1813: EXIT WHEN cur_per_grp%NOTFOUND;
1814: END LOOP;
1815: IF NOT lb_record_exist THEN
1816: fnd_file.new_line(fnd_file.log, 1);
1817: fnd_message.set_name('IGF','IGF_SL_NO_LOR_XML_REC');
1818: fnd_file.put_line(fnd_file.log, fnd_message.get);
1819: fnd_file.new_line(fnd_file.log, 1);
1820: CLOSE cur_per_grp;
1821: RETURN;

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

1814: END LOOP;
1815: IF NOT lb_record_exist THEN
1816: fnd_file.new_line(fnd_file.log, 1);
1817: fnd_message.set_name('IGF','IGF_SL_NO_LOR_XML_REC');
1818: fnd_file.put_line(fnd_file.log, fnd_message.get);
1819: fnd_file.new_line(fnd_file.log, 1);
1820: CLOSE cur_per_grp;
1821: RETURN;
1822: END IF;

Line 1847: fnd_message.set_name('IGF','IGF_SL_NO_LOR_XML_REC');

1843: END IF;
1844: END LOOP;
1845: IF NOT lb_record_exist THEN
1846: fnd_file.new_line(fnd_file.log, 1);
1847: fnd_message.set_name('IGF','IGF_SL_NO_LOR_XML_REC');
1848: fnd_file.put_line(fnd_file.log, fnd_message.get);
1849: fnd_file.new_line(fnd_file.log, 1);
1850: RETURN;
1851: END IF;

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

1844: END LOOP;
1845: IF NOT lb_record_exist THEN
1846: fnd_file.new_line(fnd_file.log, 1);
1847: fnd_message.set_name('IGF','IGF_SL_NO_LOR_XML_REC');
1848: fnd_file.put_line(fnd_file.log, fnd_message.get);
1849: fnd_file.new_line(fnd_file.log, 1);
1850: RETURN;
1851: END IF;
1852: END IF;

Line 1867: fnd_message.set_name('IGF','IGF_SL_COD_NO_DL_REC');

1863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' gv_document_id_txt ' || gv_document_id_txt);
1864: END IF;
1865:
1866: IF cod_dtls_rec.document_id_txt IS NULL THEN
1867: fnd_message.set_name('IGF','IGF_SL_COD_NO_DL_REC');
1868: fnd_file.new_line(fnd_file.log, 1);
1869: fnd_file.put_line(fnd_file.log,fnd_message.get);
1870: fnd_file.new_line(fnd_file.log, 1);
1871: RETURN;

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

1865:
1866: IF cod_dtls_rec.document_id_txt IS NULL THEN
1867: fnd_message.set_name('IGF','IGF_SL_COD_NO_DL_REC');
1868: fnd_file.new_line(fnd_file.log, 1);
1869: fnd_file.put_line(fnd_file.log,fnd_message.get);
1870: fnd_file.new_line(fnd_file.log, 1);
1871: RETURN;
1872: ELSE
1873: SELECT COUNT(*) INTO ln_top FROM igf_sl_cod_top_v WHERE document_id_txt = gv_document_id_txt;

Line 1890: fnd_message.set_name('IGF','IGF_SL_COD_NO_DL_REC');

1886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_st ' ||ln_st );
1887: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_db ' ||ln_db );
1888: END IF;
1889: IF ln_top = 0 OR ln_sm = 0 OR ln_rs = 0 OR ln_rp = 0 OR ln_as = 0 OR ln_st = 0 THEN
1890: fnd_message.set_name('IGF','IGF_SL_COD_NO_DL_REC');
1891: fnd_file.put_line(fnd_file.log,fnd_message.get);
1892: RETURN;
1893: ELSE
1894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

1887: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_db ' ||ln_db );
1888: END IF;
1889: IF ln_top = 0 OR ln_sm = 0 OR ln_rs = 0 OR ln_rp = 0 OR ln_as = 0 OR ln_st = 0 THEN
1890: fnd_message.set_name('IGF','IGF_SL_COD_NO_DL_REC');
1891: fnd_file.put_line(fnd_file.log,fnd_message.get);
1892: RETURN;
1893: ELSE
1894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' before submit event ');

Line 1909: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1905: EXCEPTION
1906: WHEN OTHERS THEN
1907: ROLLBACK;
1908: retcode := 2;
1909: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1910: fnd_file.put_line(fnd_file.log,SQLERRM);
1911: igs_ge_msg_stack.conc_exception_hndl;
1912: END main;
1913: /* -----------------------------------------------------------------------------------

Line 2013: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');

2009: EXCEPTION
2010: WHEN OTHERS THEN
2011: ROLLBACK;
2012: retcode := 2;
2013: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2014: fnd_file.put_line(fnd_file.log,SQLERRM);
2015: igs_ge_msg_stack.conc_exception_hndl;
2016: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2017: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','sqlerrm ' || SQLERRM);