DBA Data[Home] [Help]

APPS.IGS_EN_GEN_016 dependencies on FND_FILE

Line 260: Fnd_File.PUT_LINE(Fnd_File.LOG,l_mesg_txt);

256: ELSE
257: l_mesg_txt:=l_mesg_name;
258: END IF; --30 character message name
259:
260: Fnd_File.PUT_LINE(Fnd_File.LOG,l_mesg_txt);
261: l_mesg_name := NULL;
262: ELSE
263: l_mesg_name := l_mesg_name||SUBSTR(l_messages,i,1);
264: END IF;

Line 299: Fnd_File.PUT_LINE(Fnd_File.LOG,l_regid_person_dtls);

295: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME','LOAD CAL ');
296: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_load_cal_type||'*'||p_load_seq_number) ;
297:
298: l_regid_person_dtls := l_regid_person_dtls || fnd_message.get;
299: Fnd_File.PUT_LINE(Fnd_File.LOG,l_regid_person_dtls);
300:
301: END log_regid_person_dtls;
302:
303: --

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

619: l_get_load_cal_inst_rec.cal_type,l_get_load_cal_inst_rec.sequence_number);
620: fnd_message.set_name('IGS','IGS_EN_UPD_FUT_TRANS');
621: fnd_message.set_token('COURSE_CD',l_prgm_dtls_rec.course_cd);
622: fnd_message.set_token('UNIT_CD',l_unitcd_and_uooid_str);
623: fnd_file.put_line(fnd_file.log, fnd_message.get);
624: END IF ; -- end of igs_en_spa_terms_api.get_spat_primary_prg
625: --end of code added by ckasu as apart of bug#4095276
626:
627: l_message_name:=NULL;

Line 964: Fnd_File.PUT_LINE(Fnd_File.LOG,'=============================================================================');

960: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_DESC');
961: l_batch_desc_label := fnd_message.get;
962: --
963: -- log the Batch details into log file
964: Fnd_File.PUT_LINE(Fnd_File.LOG,'=============================================================================');
965: Fnd_File.PUT_LINE(Fnd_File.LOG,l_batch_id_label||' : '||RPAD(p_batch_id,20,' ')||l_batch_desc_label||' : '||l_batch_desc);
966: Fnd_File.PUT_LINE(Fnd_File.LOG,'=============================================================================');
967:
968: OPEN get_int_cnt ;

Line 965: Fnd_File.PUT_LINE(Fnd_File.LOG,l_batch_id_label||' : '||RPAD(p_batch_id,20,' ')||l_batch_desc_label||' : '||l_batch_desc);

961: l_batch_desc_label := fnd_message.get;
962: --
963: -- log the Batch details into log file
964: Fnd_File.PUT_LINE(Fnd_File.LOG,'=============================================================================');
965: Fnd_File.PUT_LINE(Fnd_File.LOG,l_batch_id_label||' : '||RPAD(p_batch_id,20,' ')||l_batch_desc_label||' : '||l_batch_desc);
966: Fnd_File.PUT_LINE(Fnd_File.LOG,'=============================================================================');
967:
968: OPEN get_int_cnt ;
969: FETCH get_int_cnt INTO l_later_cnt;

Line 966: Fnd_File.PUT_LINE(Fnd_File.LOG,'=============================================================================');

962: --
963: -- log the Batch details into log file
964: Fnd_File.PUT_LINE(Fnd_File.LOG,'=============================================================================');
965: Fnd_File.PUT_LINE(Fnd_File.LOG,l_batch_id_label||' : '||RPAD(p_batch_id,20,' ')||l_batch_desc_label||' : '||l_batch_desc);
966: Fnd_File.PUT_LINE(Fnd_File.LOG,'=============================================================================');
967:
968: OPEN get_int_cnt ;
969: FETCH get_int_cnt INTO l_later_cnt;
970: CLOSE get_int_cnt ;

Line 974: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get);

970: CLOSE get_int_cnt ;
971:
972: IF l_int_cnt = 0 THEN
973: Fnd_Message.SET_NAME ('IGS','IGS_EN_NO_DATA_IMP');
974: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get);
975: RETURN;
976: ELSIF l_later_cnt = l_int_cnt THEN
977: Fnd_Message.SET_NAME ('IGS','IGS_EN_NO_DATA_IMP');
978: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get);

Line 978: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get);

974: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get);
975: RETURN;
976: ELSIF l_later_cnt = l_int_cnt THEN
977: Fnd_Message.SET_NAME ('IGS','IGS_EN_NO_DATA_IMP');
978: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get);
979: END IF ;
980:
981: --
982: -- Get all the records in Interface table where 'errors' column has value.

Line 1001: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.registration_id);

997: FETCH cur_alt_pers_id INTO l_alt_pers_id;
998: CLOSE cur_alt_pers_id;
999:
1000: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_REG');
1001: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.registration_id);
1002: Fnd_Message.SET_NAME ('IGS','IGS_PR_PERSON_ID');
1003: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.person_number);
1004: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_NAME');
1005: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||l_full_name);

Line 1003: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.person_number);

999:
1000: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_REG');
1001: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.registration_id);
1002: Fnd_Message.SET_NAME ('IGS','IGS_PR_PERSON_ID');
1003: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.person_number);
1004: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_NAME');
1005: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||l_full_name);
1006: Fnd_File.PUT_LINE(Fnd_File.LOG,l_pref_per_type||' : '||l_alt_pers_id);
1007: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_PGM');

Line 1005: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||l_full_name);

1001: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.registration_id);
1002: Fnd_Message.SET_NAME ('IGS','IGS_PR_PERSON_ID');
1003: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.person_number);
1004: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_NAME');
1005: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||l_full_name);
1006: Fnd_File.PUT_LINE(Fnd_File.LOG,l_pref_per_type||' : '||l_alt_pers_id);
1007: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_PGM');
1008: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.course_cd);
1009: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_ACAD');

Line 1006: Fnd_File.PUT_LINE(Fnd_File.LOG,l_pref_per_type||' : '||l_alt_pers_id);

1002: Fnd_Message.SET_NAME ('IGS','IGS_PR_PERSON_ID');
1003: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.person_number);
1004: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_NAME');
1005: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||l_full_name);
1006: Fnd_File.PUT_LINE(Fnd_File.LOG,l_pref_per_type||' : '||l_alt_pers_id);
1007: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_PGM');
1008: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.course_cd);
1009: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_ACAD');
1010: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.alternate_code);

Line 1008: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.course_cd);

1004: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_NAME');
1005: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||l_full_name);
1006: Fnd_File.PUT_LINE(Fnd_File.LOG,l_pref_per_type||' : '||l_alt_pers_id);
1007: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_PGM');
1008: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.course_cd);
1009: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_ACAD');
1010: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.alternate_code);
1011: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_ERR');
1012: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.errors);

Line 1010: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.alternate_code);

1006: Fnd_File.PUT_LINE(Fnd_File.LOG,l_pref_per_type||' : '||l_alt_pers_id);
1007: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_PGM');
1008: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.course_cd);
1009: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_ACAD');
1010: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.alternate_code);
1011: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_ERR');
1012: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.errors);
1013:
1014: Fnd_File.PUT_LINE(Fnd_File.LOG,'-----------------------------------------------------------------------------');

Line 1012: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.errors);

1008: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.course_cd);
1009: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_ACAD');
1010: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.alternate_code);
1011: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_ERR');
1012: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.errors);
1013:
1014: Fnd_File.PUT_LINE(Fnd_File.LOG,'-----------------------------------------------------------------------------');
1015:
1016: END LOOP;

Line 1014: Fnd_File.PUT_LINE(Fnd_File.LOG,'-----------------------------------------------------------------------------');

1010: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.alternate_code);
1011: Fnd_Message.SET_NAME ('IGS','IGS_EN_REG_LOG_ERR');
1012: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get||' : '||cur_enr_reg_err_rec.errors);
1013:
1014: Fnd_File.PUT_LINE(Fnd_File.LOG,'-----------------------------------------------------------------------------');
1015:
1016: END LOOP;
1017:
1018: --

Line 1025: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get);

1021: -- Data imported into OSS tables and records in Interface Table deleted.
1022: --
1023: IF l_error_rec = 'N' THEN
1024: Fnd_Message.Set_name('IGS','IGS_EN_REG_UPD_SUCCESS');
1025: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get);
1026: Fnd_File.PUT_LINE(Fnd_File.LOG,'-----------------------------------------------------------------------------');
1027: END IF;
1028:
1029: EXCEPTION

Line 1026: Fnd_File.PUT_LINE(Fnd_File.LOG,'-----------------------------------------------------------------------------');

1022: --
1023: IF l_error_rec = 'N' THEN
1024: Fnd_Message.Set_name('IGS','IGS_EN_REG_UPD_SUCCESS');
1025: Fnd_File.PUT_LINE(Fnd_File.LOG,fnd_message.get);
1026: Fnd_File.PUT_LINE(Fnd_File.LOG,'-----------------------------------------------------------------------------');
1027: END IF;
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN

Line 1032: Fnd_File.PUT_LINE(Fnd_File.LOG,SQLERRM);

1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: retcode:=2;
1032: Fnd_File.PUT_LINE(Fnd_File.LOG,SQLERRM);
1033: ERRBUF := Fnd_Message.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1034: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1035:
1036: END enrp_batch_reg_upd;