DBA Data[Home] [Help]

APPS.IGF_AP_MK_PROF_ACT_PKG dependencies on FND_FILE

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

507: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
508: l_chk_profile := igf_ap_gen.check_profile;
509: IF l_chk_profile = 'N' THEN
510: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
511: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
512: RETURN;
513: END IF;
514:
515: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'PROFILE');

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

1022: print_log_process(l_get_alternate_code.alternate_code,p_batch_id,p_del_ind);
1023:
1024: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
1025: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1026: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1027: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1028: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1029: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1030: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);

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

1024: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
1025: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1026: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1027: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1028: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1029: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1030: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
1031: EXCEPTION
1032: WHEN others THEN

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

1026: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1027: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1028: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1029: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1030: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
1031: EXCEPTION
1032: WHEN others THEN
1033: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1034: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_mk_prof_act_pkg.lg_make_active_profile.exception','Unhandled exception error:'||SQLERRM);

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

1130: l_batch_desc := l_get_batch_desc.batch_desc ;
1131:
1132: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
1133: fnd_message.set_name('IGS','IGS_DA_JOB');
1134: fnd_file.put_line(fnd_file.log,fnd_message.get);
1135: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1136: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);
1137: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1138: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,50) || ' : ' || l_yes_no);

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

1131:
1132: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
1133: fnd_message.set_name('IGS','IGS_DA_JOB');
1134: fnd_file.put_line(fnd_file.log,fnd_message.get);
1135: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1136: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);
1137: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1138: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,50) || ' : ' || l_yes_no);
1139: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');

Line 1136: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);

1132: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
1133: fnd_message.set_name('IGS','IGS_DA_JOB');
1134: fnd_file.put_line(fnd_file.log,fnd_message.get);
1135: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1136: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);
1137: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1138: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,50) || ' : ' || l_yes_no);
1139: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
1140:

Line 1138: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,50) || ' : ' || l_yes_no);

1134: fnd_file.put_line(fnd_file.log,fnd_message.get);
1135: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1136: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);
1137: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1138: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,50) || ' : ' || l_yes_no);
1139: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
1140:
1141: FOR i IN 1..l_count LOOP
1142: IF g_log_tab(i).person_number IS NOT NULL THEN

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

1135: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1136: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);
1137: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1138: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,50) || ' : ' || l_yes_no);
1139: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
1140:
1141: FOR i IN 1..l_count LOOP
1142: IF g_log_tab(i).person_number IS NOT NULL THEN
1143: IF l_old_person <> g_log_tab(i).person_number THEN

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

1140:
1141: FOR i IN 1..l_count LOOP
1142: IF g_log_tab(i).person_number IS NOT NULL THEN
1143: IF l_old_person <> g_log_tab(i).person_number THEN
1144: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
1145: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);
1146: END IF;
1147: l_old_person := g_log_tab(i).person_number;
1148: END IF;

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

1141: FOR i IN 1..l_count LOOP
1142: IF g_log_tab(i).person_number IS NOT NULL THEN
1143: IF l_old_person <> g_log_tab(i).person_number THEN
1144: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
1145: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);
1146: END IF;
1147: l_old_person := g_log_tab(i).person_number;
1148: END IF;
1149: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);

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

1145: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);
1146: END IF;
1147: l_old_person := g_log_tab(i).person_number;
1148: END IF;
1149: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
1150: END LOOP;
1151:
1152: END print_log_process;
1153: