DBA Data[Home] [Help]

APPS.IGF_AP_LI_AWARDS_PKG dependencies on FND_FILE

Line 150: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

146:
147: l_chk_profile := igf_ap_gen.check_profile;
148: IF l_chk_profile = 'N' THEN
149: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
150: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
151: RETURN;
152: END IF;
153:
154: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');

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

168: CLOSE c_get_alternate_code;
169:
170: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
171: fnd_message.set_name('IGS','IGS_DA_JOB');
172: fnd_file.put_line(fnd_file.log,fnd_message.get);
173: fnd_file.put_line(fnd_file.log,l_batch_id || ' : ' || p_batch_id || ' - ' || l_batch_desc);
174: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || l_get_alternate_code.alternate_code);
175: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
176: fnd_file.put_line(fnd_file.log,fnd_message.get || ' : ' || l_yes_no);

Line 173: fnd_file.put_line(fnd_file.log,l_batch_id || ' : ' || p_batch_id || ' - ' || l_batch_desc);

169:
170: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
171: fnd_message.set_name('IGS','IGS_DA_JOB');
172: fnd_file.put_line(fnd_file.log,fnd_message.get);
173: fnd_file.put_line(fnd_file.log,l_batch_id || ' : ' || p_batch_id || ' - ' || l_batch_desc);
174: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || l_get_alternate_code.alternate_code);
175: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
176: fnd_file.put_line(fnd_file.log,fnd_message.get || ' : ' || l_yes_no);
177: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');

Line 174: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || l_get_alternate_code.alternate_code);

170: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
171: fnd_message.set_name('IGS','IGS_DA_JOB');
172: fnd_file.put_line(fnd_file.log,fnd_message.get);
173: fnd_file.put_line(fnd_file.log,l_batch_id || ' : ' || p_batch_id || ' - ' || l_batch_desc);
174: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || l_get_alternate_code.alternate_code);
175: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
176: fnd_file.put_line(fnd_file.log,fnd_message.get || ' : ' || l_yes_no);
177: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
178:

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

172: fnd_file.put_line(fnd_file.log,fnd_message.get);
173: fnd_file.put_line(fnd_file.log,l_batch_id || ' : ' || p_batch_id || ' - ' || l_batch_desc);
174: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || l_get_alternate_code.alternate_code);
175: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
176: fnd_file.put_line(fnd_file.log,fnd_message.get || ' : ' || l_yes_no);
177: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
178:
179: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'AWG');
180: IF l_chk_batch = 'N' THEN

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

173: fnd_file.put_line(fnd_file.log,l_batch_id || ' : ' || p_batch_id || ' - ' || l_batch_desc);
174: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || l_get_alternate_code.alternate_code);
175: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
176: fnd_file.put_line(fnd_file.log,fnd_message.get || ' : ' || l_yes_no);
177: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
178:
179: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'AWG');
180: IF l_chk_batch = 'N' THEN
181: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');

Line 182: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

178:
179: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'AWG');
180: IF l_chk_batch = 'N' THEN
181: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
182: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
183: RETURN;
184: END IF;
185:
186: OPEN c_award_det(l_cal_type,l_seq_number);

Line 193: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

189:
190: IF l_award_det.award_year_status_code NOT IN('LA','LE') THEN
191: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
192: fnd_message.set_token('AWARD_STATUS',l_award_det.award_year_status_code);
193: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
194: RETURN;
195: END IF;
196:
197: -- NOW ONLY PERSON LEVEL MESSGAES WILL BE LOGGED

Line 467: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

463: END LOOP;
464:
465: IF l_success_record_cnt = 0 AND l_error_record_cnt = 0 THEN
466: fnd_message.set_name('IGS','IGS_FI_NO_RECORD_AVAILABLE');
467: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
468: RETURN;
469: END IF;
470:
471: -- CALL THE PRINT LOG PROCESS

Line 475: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);

471: -- CALL THE PRINT LOG PROCESS
472: print_log_process(l_person_number,l_error);
473: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
474: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
475: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
476: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
477: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
478: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
479: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);

Line 477: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);

473: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
474: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
475: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
476: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
477: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
478: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
479: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
480:
481: EXCEPTION

Line 479: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);

475: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
476: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
477: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
478: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
479: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
480:
481: EXCEPTION
482: WHEN others THEN
483: --CALL TO THE COMMON LOGGING FRAMEWORK FOR DEBUG MESSAGES

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

511: BEGIN
512:
513: FOR i IN 1..l_count LOOP
514: IF l_old_person <> g_log_tab(i).person_number THEN
515: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
516: fnd_file.put_line(fnd_file.log,p_person_number || ' : ' || g_log_tab(i).person_number);
517: END IF;
518: IF g_log_tab(i).message_text IS NOT NULL AND g_log_tab(i).message_text <> ' ' THEN
519: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);

Line 516: fnd_file.put_line(fnd_file.log,p_person_number || ' : ' || g_log_tab(i).person_number);

512:
513: FOR i IN 1..l_count LOOP
514: IF l_old_person <> g_log_tab(i).person_number THEN
515: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
516: fnd_file.put_line(fnd_file.log,p_person_number || ' : ' || g_log_tab(i).person_number);
517: END IF;
518: IF g_log_tab(i).message_text IS NOT NULL AND g_log_tab(i).message_text <> ' ' THEN
519: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
520: END IF;

Line 519: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);

515: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
516: fnd_file.put_line(fnd_file.log,p_person_number || ' : ' || g_log_tab(i).person_number);
517: END IF;
518: IF g_log_tab(i).message_text IS NOT NULL AND g_log_tab(i).message_text <> ' ' THEN
519: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
520: END IF;
521: l_old_person := g_log_tab(i).person_number;
522: END LOOP;
523: