DBA Data[Home] [Help]

APPS.IGF_AP_MK_ISIR_ACT_PKG dependencies on FND_FILE

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

937: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
938: l_chk_profile := igf_ap_gen.check_profile;
939: IF l_chk_profile = 'N' THEN
940: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
941: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
942: RETURN;
943: END IF;
944:
945: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'ISIR');

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

1134: print_log_process(l_get_alternate_code.alternate_code,p_batch_id,p_del_ind);
1135:
1136: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
1137: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1138: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1139: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1140: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1141: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1142: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);

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

1136: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
1137: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1138: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1139: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1140: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1141: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1142: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
1143: EXCEPTION
1144: WHEN others THEN

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

1138: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1139: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1140: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1141: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1142: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
1143: EXCEPTION
1144: WHEN others THEN
1145: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1146: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_mk_isir_act_pkg.lg_make_active_isir.exception','Unhandled Exception: '||SQLERRM);

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

1706: l_batch_desc := l_get_batch_desc.batch_desc ;
1707:
1708: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
1709: fnd_message.set_name('IGS','IGS_DA_JOB');
1710: fnd_file.put_line(fnd_file.log,fnd_message.get);
1711: fnd_file.put_line(fnd_file.log,l_batch_id || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1712: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || p_alternate_code);
1713: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1714: fnd_file.put_line(fnd_file.log,fnd_message.get || ' : ' || l_yes_no);

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

1707:
1708: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
1709: fnd_message.set_name('IGS','IGS_DA_JOB');
1710: fnd_file.put_line(fnd_file.log,fnd_message.get);
1711: fnd_file.put_line(fnd_file.log,l_batch_id || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1712: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || p_alternate_code);
1713: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1714: fnd_file.put_line(fnd_file.log,fnd_message.get || ' : ' || l_yes_no);
1715: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');

Line 1712: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || p_alternate_code);

1708: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
1709: fnd_message.set_name('IGS','IGS_DA_JOB');
1710: fnd_file.put_line(fnd_file.log,fnd_message.get);
1711: fnd_file.put_line(fnd_file.log,l_batch_id || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1712: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || p_alternate_code);
1713: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1714: fnd_file.put_line(fnd_file.log,fnd_message.get || ' : ' || l_yes_no);
1715: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
1716:

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

1710: fnd_file.put_line(fnd_file.log,fnd_message.get);
1711: fnd_file.put_line(fnd_file.log,l_batch_id || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1712: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || p_alternate_code);
1713: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1714: fnd_file.put_line(fnd_file.log,fnd_message.get || ' : ' || l_yes_no);
1715: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
1716:
1717: FOR i IN 1..l_count LOOP
1718: IF g_log_tab(i).person_number IS NOT NULL THEN

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

1711: fnd_file.put_line(fnd_file.log,l_batch_id || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1712: fnd_file.put_line(fnd_file.log,l_award_yr || ' : ' || p_alternate_code);
1713: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1714: fnd_file.put_line(fnd_file.log,fnd_message.get || ' : ' || l_yes_no);
1715: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
1716:
1717: FOR i IN 1..l_count LOOP
1718: IF g_log_tab(i).person_number IS NOT NULL THEN
1719: IF l_old_person <> g_log_tab(i).person_number THEN

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

1716:
1717: FOR i IN 1..l_count LOOP
1718: IF g_log_tab(i).person_number IS NOT NULL THEN
1719: IF l_old_person <> g_log_tab(i).person_number THEN
1720: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
1721: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);
1722: END IF;
1723: l_old_person := g_log_tab(i).person_number;
1724: END IF;

Line 1721: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);

1717: FOR i IN 1..l_count LOOP
1718: IF g_log_tab(i).person_number IS NOT NULL THEN
1719: IF l_old_person <> g_log_tab(i).person_number THEN
1720: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
1721: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);
1722: END IF;
1723: l_old_person := g_log_tab(i).person_number;
1724: END IF;
1725: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);

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

1721: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);
1722: END IF;
1723: l_old_person := g_log_tab(i).person_number;
1724: END IF;
1725: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
1726: END LOOP;
1727:
1728: END print_log_process;
1729: