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_FILE

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 248: fnd_file.put(fnd_file.output,lv_myclob_text);

244: END IF;
245:
246: WHILE (ln_len > 0) LOOP
247: lv_myclob_text := DBMS_LOB.SUBSTR (p_xml_clob, ln_amount, ln_offset);
248: fnd_file.put(fnd_file.output,lv_myclob_text);
249: ln_amount := LENGTH(lv_myclob_text); -- this will handle any Character Set. But to be optimistic ln_amount is initialized to 1023 instead of 32767. Bug 4323926
250: IF ln_amount = 0 THEN
251: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
252: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount is Zero after DBMS_LOB.SUBSTR, ln_len = ' || ln_len);

Line 264: fnd_file.new_line(fnd_file.output,1);

260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_offset ' || ln_offset);
261: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_amount ' || ln_amount);
262: END IF;
263: END LOOP;
264: fnd_file.new_line(fnd_file.output,1);
265:
266: EXCEPTION
267: WHEN OTHERS THEN
268: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

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 835: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER')||' : '||p_loan_rec.loan_number);

831: p_acad_begin,p_acad_end,p_s_phone,p_p_phone);
832:
833: IF lb_valid_loan THEN
834:
835: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER')||' : '||p_loan_rec.loan_number);
836: fnd_file.new_line(fnd_file.log,1);
837: -- Check for Loan Amount
838: IF p_loan_rec.fed_fund_code IN ('DLS','DLU') THEN
839: l_aid := 0;

Line 836: fnd_file.new_line(fnd_file.log,1);

832:
833: IF lb_valid_loan THEN
834:
835: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER')||' : '||p_loan_rec.loan_number);
836: fnd_file.new_line(fnd_file.log,1);
837: -- Check for Loan Amount
838: IF p_loan_rec.fed_fund_code IN ('DLS','DLU') THEN
839: l_aid := 0;
840: l_msg_name := NULL;

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 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 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 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 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 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 957: fnd_file.put_line(fnd_file.log,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;
961: END IF;

Line 1094: fnd_file.new_line(fnd_file.log,1);

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:
1098: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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 1096: fnd_file.new_line(fnd_file.log,1);

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 ');
1100: END IF;

Line 1284: fnd_file.new_line(fnd_file.log,1);

1280: END IF;
1281: END LOOP;
1282: CLOSE c_get_parameters;
1283:
1284: fnd_file.new_line(fnd_file.log,1);
1285: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------
1286: fnd_file.new_line(fnd_file.log,1);
1287:
1288: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));

Line 1285: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------

1281: END LOOP;
1282: CLOSE c_get_parameters;
1283:
1284: fnd_file.new_line(fnd_file.log,1);
1285: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------
1286: fnd_file.new_line(fnd_file.log,1);
1287:
1288: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
1289: fnd_file.put_line(fnd_file.log, RPAD(lv_source_entity_id,40) || ' : '|| p_source_id);

Line 1286: fnd_file.new_line(fnd_file.log,1);

1282: CLOSE c_get_parameters;
1283:
1284: fnd_file.new_line(fnd_file.log,1);
1285: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------
1286: fnd_file.new_line(fnd_file.log,1);
1287:
1288: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
1289: fnd_file.put_line(fnd_file.log, RPAD(lv_source_entity_id,40) || ' : '|| p_source_id);
1290: fnd_file.put_line(fnd_file.log, RPAD(lv_report_entity_id,40) || ' : '|| p_report_id);

Line 1288: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));

1284: fnd_file.new_line(fnd_file.log,1);
1285: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------
1286: fnd_file.new_line(fnd_file.log,1);
1287:
1288: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
1289: fnd_file.put_line(fnd_file.log, RPAD(lv_source_entity_id,40) || ' : '|| p_source_id);
1290: fnd_file.put_line(fnd_file.log, RPAD(lv_report_entity_id,40) || ' : '|| p_report_id);
1291: fnd_file.put_line(fnd_file.log, RPAD(lv_attend_entity_id,40) || ' : '|| p_attend_id);
1292: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_type,40) || ' : '|| get_fund_desc(p_fund_id));

Line 1289: fnd_file.put_line(fnd_file.log, RPAD(lv_source_entity_id,40) || ' : '|| p_source_id);

1285: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------
1286: fnd_file.new_line(fnd_file.log,1);
1287:
1288: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
1289: fnd_file.put_line(fnd_file.log, RPAD(lv_source_entity_id,40) || ' : '|| p_source_id);
1290: fnd_file.put_line(fnd_file.log, RPAD(lv_report_entity_id,40) || ' : '|| p_report_id);
1291: fnd_file.put_line(fnd_file.log, RPAD(lv_attend_entity_id,40) || ' : '|| p_attend_id);
1292: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_type,40) || ' : '|| get_fund_desc(p_fund_id));
1293: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));

Line 1290: fnd_file.put_line(fnd_file.log, RPAD(lv_report_entity_id,40) || ' : '|| p_report_id);

1286: fnd_file.new_line(fnd_file.log,1);
1287:
1288: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
1289: fnd_file.put_line(fnd_file.log, RPAD(lv_source_entity_id,40) || ' : '|| p_source_id);
1290: fnd_file.put_line(fnd_file.log, RPAD(lv_report_entity_id,40) || ' : '|| p_report_id);
1291: fnd_file.put_line(fnd_file.log, RPAD(lv_attend_entity_id,40) || ' : '|| p_attend_id);
1292: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_type,40) || ' : '|| get_fund_desc(p_fund_id));
1293: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));
1294: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_number,40) || ' : '|| get_loan_number(p_loan_id));

Line 1291: fnd_file.put_line(fnd_file.log, RPAD(lv_attend_entity_id,40) || ' : '|| p_attend_id);

1287:
1288: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
1289: fnd_file.put_line(fnd_file.log, RPAD(lv_source_entity_id,40) || ' : '|| p_source_id);
1290: fnd_file.put_line(fnd_file.log, RPAD(lv_report_entity_id,40) || ' : '|| p_report_id);
1291: fnd_file.put_line(fnd_file.log, RPAD(lv_attend_entity_id,40) || ' : '|| p_attend_id);
1292: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_type,40) || ' : '|| get_fund_desc(p_fund_id));
1293: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));
1294: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_number,40) || ' : '|| get_loan_number(p_loan_id));
1295: fnd_file.put_line(fnd_file.log, RPAD(lv_person_id_group,40) || ' : '|| get_grp_name(p_pgroup_id));

Line 1292: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_type,40) || ' : '|| get_fund_desc(p_fund_id));

1288: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
1289: fnd_file.put_line(fnd_file.log, RPAD(lv_source_entity_id,40) || ' : '|| p_source_id);
1290: fnd_file.put_line(fnd_file.log, RPAD(lv_report_entity_id,40) || ' : '|| p_report_id);
1291: fnd_file.put_line(fnd_file.log, RPAD(lv_attend_entity_id,40) || ' : '|| p_attend_id);
1292: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_type,40) || ' : '|| get_fund_desc(p_fund_id));
1293: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));
1294: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_number,40) || ' : '|| get_loan_number(p_loan_id));
1295: fnd_file.put_line(fnd_file.log, RPAD(lv_person_id_group,40) || ' : '|| get_grp_name(p_pgroup_id));
1296:

Line 1293: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));

1289: fnd_file.put_line(fnd_file.log, RPAD(lv_source_entity_id,40) || ' : '|| p_source_id);
1290: fnd_file.put_line(fnd_file.log, RPAD(lv_report_entity_id,40) || ' : '|| p_report_id);
1291: fnd_file.put_line(fnd_file.log, RPAD(lv_attend_entity_id,40) || ' : '|| p_attend_id);
1292: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_type,40) || ' : '|| get_fund_desc(p_fund_id));
1293: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));
1294: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_number,40) || ' : '|| get_loan_number(p_loan_id));
1295: fnd_file.put_line(fnd_file.log, RPAD(lv_person_id_group,40) || ' : '|| get_grp_name(p_pgroup_id));
1296:
1297: fnd_file.new_line(fnd_file.log,1);

Line 1294: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_number,40) || ' : '|| get_loan_number(p_loan_id));

1290: fnd_file.put_line(fnd_file.log, RPAD(lv_report_entity_id,40) || ' : '|| p_report_id);
1291: fnd_file.put_line(fnd_file.log, RPAD(lv_attend_entity_id,40) || ' : '|| p_attend_id);
1292: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_type,40) || ' : '|| get_fund_desc(p_fund_id));
1293: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));
1294: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_number,40) || ' : '|| get_loan_number(p_loan_id));
1295: fnd_file.put_line(fnd_file.log, RPAD(lv_person_id_group,40) || ' : '|| get_grp_name(p_pgroup_id));
1296:
1297: fnd_file.new_line(fnd_file.log,1);
1298: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');

Line 1295: fnd_file.put_line(fnd_file.log, RPAD(lv_person_id_group,40) || ' : '|| get_grp_name(p_pgroup_id));

1291: fnd_file.put_line(fnd_file.log, RPAD(lv_attend_entity_id,40) || ' : '|| p_attend_id);
1292: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_type,40) || ' : '|| get_fund_desc(p_fund_id));
1293: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));
1294: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_number,40) || ' : '|| get_loan_number(p_loan_id));
1295: fnd_file.put_line(fnd_file.log, RPAD(lv_person_id_group,40) || ' : '|| get_grp_name(p_pgroup_id));
1296:
1297: fnd_file.new_line(fnd_file.log,1);
1298: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
1299: fnd_file.new_line(fnd_file.log,1);

Line 1297: fnd_file.new_line(fnd_file.log,1);

1293: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));
1294: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_number,40) || ' : '|| get_loan_number(p_loan_id));
1295: fnd_file.put_line(fnd_file.log, RPAD(lv_person_id_group,40) || ' : '|| get_grp_name(p_pgroup_id));
1296:
1297: fnd_file.new_line(fnd_file.log,1);
1298: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
1299: fnd_file.new_line(fnd_file.log,1);
1300:
1301: EXCEPTION

Line 1298: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');

1294: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_number,40) || ' : '|| get_loan_number(p_loan_id));
1295: fnd_file.put_line(fnd_file.log, RPAD(lv_person_id_group,40) || ' : '|| get_grp_name(p_pgroup_id));
1296:
1297: fnd_file.new_line(fnd_file.log,1);
1298: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
1299: fnd_file.new_line(fnd_file.log,1);
1300:
1301: EXCEPTION
1302: WHEN OTHERS THEN

Line 1299: fnd_file.new_line(fnd_file.log,1);

1295: fnd_file.put_line(fnd_file.log, RPAD(lv_person_id_group,40) || ' : '|| get_grp_name(p_pgroup_id));
1296:
1297: fnd_file.new_line(fnd_file.log,1);
1298: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
1299: fnd_file.new_line(fnd_file.log,1);
1300:
1301: EXCEPTION
1302: WHEN OTHERS THEN
1303: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

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 1520: fnd_file.new_line(fnd_file.log, 1);

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:
1524: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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 1532: fnd_file.new_line(fnd_file.log, 1);

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:
1536: IF LENGTH(TRIM(p_source_id)) > 8 OR TRIM(p_source_id) > 99999999

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 1540: fnd_file.new_line(fnd_file.log, 1);

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:
1544: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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 1553: fnd_file.new_line(fnd_file.log, 1);

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:
1557: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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 1566: fnd_file.new_line(fnd_file.log, 1);

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:
1570: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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 1577: fnd_file.new_line(fnd_file.log, 1);

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:
1581: OPEN cur_award_year(lv_cal_type,ln_seq_number);

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 1595: fnd_file.new_line(fnd_file.log, 1);

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:
1599: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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 1609: fnd_file.new_line(fnd_file.log, 1);

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:
1613: IF award_year_rec.dl_participant_code <> 'FULL_PARTICIPANT' THEN

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 1616: fnd_file.new_line(fnd_file.log, 1);

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:
1620: IF award_year_rec.sys_award_year < '0405' THEN

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 1623: fnd_file.new_line(fnd_file.log, 1);

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:
1627: OPEN cur_source_id(p_source_id,lv_cal_type,ln_seq_number);

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 1634: fnd_file.new_line(fnd_file.log, 1);

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:
1638: IF p_report_id IS NOT NULL THEN

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 1648: fnd_file.new_line(fnd_file.log, 1);

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:
1652: IF p_attend_id IS NOT NULL THEN

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 1662: fnd_file.new_line(fnd_file.log, 1);

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

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 1675: fnd_file.new_line(fnd_file.log, 1);

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:
1679: IF p_base_id IS NOT NULL THEN

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 1687: fnd_file.new_line(fnd_file.log, 1);

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

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 1699: fnd_file.new_line(fnd_file.log, 1);

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

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 1731: fnd_file.new_line(fnd_file.log, 1);

1727: lb_record_exist := TRUE;
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;

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 1734: fnd_file.new_line(fnd_file.log, 1);

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

Line 1742: fnd_file.new_line(fnd_file.log, 1);

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
1746: l_list := igf_ap_ss_pkg.get_pid(p_pgroup_id,lv_status,lv_group_type);

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 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 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 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 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 1816: fnd_file.new_line(fnd_file.log, 1);

1812: FETCH cur_per_grp INTO l_person_id;
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;

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 1819: fnd_file.new_line(fnd_file.log, 1);

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;
1823: CLOSE cur_per_grp;

Line 1846: fnd_file.new_line(fnd_file.log, 1);

1842: lb_record_exist := TRUE;
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;

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 1849: fnd_file.new_line(fnd_file.log, 1);

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

Line 1868: fnd_file.new_line(fnd_file.log, 1);

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

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 1870: fnd_file.new_line(fnd_file.log, 1);

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;
1874: SELECT COUNT(*) INTO ln_sm FROM igf_sl_rep_smry_v WHERE document_id_txt = gv_document_id_txt;

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 1910: fnd_file.put_line(fnd_file.log,SQLERRM);

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: /* -----------------------------------------------------------------------------------
1914: Know limitations, enhancements or remarks

Line 1971: fnd_file.new_line(fnd_file.log,1);

1967: END IF;
1968: END LOOP;
1969: CLOSE c_get_parameters;
1970:
1971: fnd_file.new_line(fnd_file.log,1);
1972: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------
1973: fnd_file.new_line(fnd_file.log,1);
1974:
1975: fnd_file.put_line(fnd_file.log, RPAD(lv_document_id_txt,40) || ' : '|| p_document_id_txt);

Line 1972: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------

1968: END LOOP;
1969: CLOSE c_get_parameters;
1970:
1971: fnd_file.new_line(fnd_file.log,1);
1972: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------
1973: fnd_file.new_line(fnd_file.log,1);
1974:
1975: fnd_file.put_line(fnd_file.log, RPAD(lv_document_id_txt,40) || ' : '|| p_document_id_txt);
1976:

Line 1973: fnd_file.new_line(fnd_file.log,1);

1969: CLOSE c_get_parameters;
1970:
1971: fnd_file.new_line(fnd_file.log,1);
1972: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------
1973: fnd_file.new_line(fnd_file.log,1);
1974:
1975: fnd_file.put_line(fnd_file.log, RPAD(lv_document_id_txt,40) || ' : '|| p_document_id_txt);
1976:
1977: fnd_file.new_line(fnd_file.log,1);

Line 1975: fnd_file.put_line(fnd_file.log, RPAD(lv_document_id_txt,40) || ' : '|| p_document_id_txt);

1971: fnd_file.new_line(fnd_file.log,1);
1972: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------
1973: fnd_file.new_line(fnd_file.log,1);
1974:
1975: fnd_file.put_line(fnd_file.log, RPAD(lv_document_id_txt,40) || ' : '|| p_document_id_txt);
1976:
1977: fnd_file.new_line(fnd_file.log,1);
1978: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
1979: fnd_file.new_line(fnd_file.log,1);

Line 1977: fnd_file.new_line(fnd_file.log,1);

1973: fnd_file.new_line(fnd_file.log,1);
1974:
1975: fnd_file.put_line(fnd_file.log, RPAD(lv_document_id_txt,40) || ' : '|| p_document_id_txt);
1976:
1977: fnd_file.new_line(fnd_file.log,1);
1978: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
1979: fnd_file.new_line(fnd_file.log,1);
1980:
1981: edit_clob(p_document_id_txt,lc_newxmldoc,lv_rowid);

Line 1978: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');

1974:
1975: fnd_file.put_line(fnd_file.log, RPAD(lv_document_id_txt,40) || ' : '|| p_document_id_txt);
1976:
1977: fnd_file.new_line(fnd_file.log,1);
1978: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
1979: fnd_file.new_line(fnd_file.log,1);
1980:
1981: edit_clob(p_document_id_txt,lc_newxmldoc,lv_rowid);
1982: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1979: fnd_file.new_line(fnd_file.log,1);

1975: fnd_file.put_line(fnd_file.log, RPAD(lv_document_id_txt,40) || ' : '|| p_document_id_txt);
1976:
1977: fnd_file.new_line(fnd_file.log,1);
1978: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
1979: fnd_file.new_line(fnd_file.log,1);
1980:
1981: edit_clob(p_document_id_txt,lc_newxmldoc,lv_rowid);
1982: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1983: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','After edit CLOB ');

Line 2014: fnd_file.put_line(fnd_file.log,SQLERRM);

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