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_SE_GEN_001 dependencies on FND_FILE

Line 93: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

89: FETCH c_fund_dtls INTO l_fund_id;
90: CLOSE c_fund_dtls;
91:
92: /* Print the Parameters Passed */
93: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
94: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------
95: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
96: IF l_awd_alternate_code IS NOT NULL THEN
97: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_year,30) || ' : '|| l_awd_alternate_code);

Line 94: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------

90: CLOSE c_fund_dtls;
91:
92: /* Print the Parameters Passed */
93: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
94: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------
95: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
96: IF l_awd_alternate_code IS NOT NULL THEN
97: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_year,30) || ' : '|| l_awd_alternate_code);
98: END IF;

Line 95: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

91:
92: /* Print the Parameters Passed */
93: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
94: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------
95: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
96: IF l_awd_alternate_code IS NOT NULL THEN
97: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_year,30) || ' : '|| l_awd_alternate_code);
98: END IF;
99: IF l_fund_id IS NOT NULL THEN

Line 97: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_year,30) || ' : '|| l_awd_alternate_code);

93: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
94: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------
95: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
96: IF l_awd_alternate_code IS NOT NULL THEN
97: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_year,30) || ' : '|| l_awd_alternate_code);
98: END IF;
99: IF l_fund_id IS NOT NULL THEN
100: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_fund_code,30) || ' : '|| l_fund_id);
101: END IF;

Line 100: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_fund_code,30) || ' : '|| l_fund_id);

96: IF l_awd_alternate_code IS NOT NULL THEN
97: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_year,30) || ' : '|| l_awd_alternate_code);
98: END IF;
99: IF l_fund_id IS NOT NULL THEN
100: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_fund_code,30) || ' : '|| l_fund_id);
101: END IF;
102: IF l_base_id IS NOT NULL THEN
103: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_person_number,30) || ' : '|| l_base_id);
104: END IF;

Line 103: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_person_number,30) || ' : '|| l_base_id);

99: IF l_fund_id IS NOT NULL THEN
100: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_fund_code,30) || ' : '|| l_fund_id);
101: END IF;
102: IF l_base_id IS NOT NULL THEN
103: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_person_number,30) || ' : '|| l_base_id);
104: END IF;
105: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
107: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 105: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

101: END IF;
102: IF l_base_id IS NOT NULL THEN
103: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_person_number,30) || ' : '|| l_base_id);
104: END IF;
105: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
107: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
108: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
109:

Line 106: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');

102: IF l_base_id IS NOT NULL THEN
103: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_person_number,30) || ' : '|| l_base_id);
104: END IF;
105: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
107: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
108: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
109:
110: END display_auth_params;

Line 107: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

103: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_person_number,30) || ' : '|| l_base_id);
104: END IF;
105: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
107: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
108: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
109:
110: END display_auth_params;
111:

Line 108: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

104: END IF;
105: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
107: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
108: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
109:
110: END display_auth_params;
111:
112:

Line 157: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

153: END IF;
154: END LOOP;
155: CLOSE c_get_parameters;
156:
157: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
158: IF p_person_number IS NOT NULL THEN
159: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_person_number,30) || ' : '||p_person_number);
160: END IF;
161:

Line 159: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_person_number,30) || ' : '||p_person_number);

155: CLOSE c_get_parameters;
156:
157: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
158: IF p_person_number IS NOT NULL THEN
159: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_person_number,30) || ' : '||p_person_number);
160: END IF;
161:
162: IF p_fund_code IS NOT NULL THEN
163: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_fund_code,30) || ' : '||p_fund_code);

Line 163: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_fund_code,30) || ' : '||p_fund_code);

159: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_person_number,30) || ' : '||p_person_number);
160: END IF;
161:
162: IF p_fund_code IS NOT NULL THEN
163: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_fund_code,30) || ' : '||p_fund_code);
164: END IF;
165:
166: IF p_award_id IS NOT NULL THEN
167: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_id,30) || ' : '||p_award_id);

Line 167: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_id,30) || ' : '||p_award_id);

163: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_fund_code,30) || ' : '||p_fund_code);
164: END IF;
165:
166: IF p_award_id IS NOT NULL THEN
167: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_id,30) || ' : '||p_award_id);
168: END IF;
169:
170: END display_auth_process_log;
171:

Line 225: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

221: END LOOP;
222: CLOSE c_get_parameters;
223:
224: -- Print the Parameters Passed
225: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
226: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------
227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
228: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_batch_id,30) || ' : '|| p_batch_id);
229: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_auth_id,30) || ' : '|| p_auth_id);

Line 226: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------

222: CLOSE c_get_parameters;
223:
224: -- Print the Parameters Passed
225: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
226: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------
227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
228: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_batch_id,30) || ' : '|| p_batch_id);
229: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_auth_id,30) || ' : '|| p_auth_id);
230: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_validation_lvl,30) || ' : '|| p_validation_lvl);

Line 227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

223:
224: -- Print the Parameters Passed
225: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
226: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------
227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
228: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_batch_id,30) || ' : '|| p_batch_id);
229: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_auth_id,30) || ' : '|| p_auth_id);
230: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_validation_lvl,30) || ' : '|| p_validation_lvl);
231: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 228: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_batch_id,30) || ' : '|| p_batch_id);

224: -- Print the Parameters Passed
225: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
226: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------
227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
228: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_batch_id,30) || ' : '|| p_batch_id);
229: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_auth_id,30) || ' : '|| p_auth_id);
230: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_validation_lvl,30) || ' : '|| p_validation_lvl);
231: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
232: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');

Line 229: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_auth_id,30) || ' : '|| p_auth_id);

225: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
226: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------
227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
228: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_batch_id,30) || ' : '|| p_batch_id);
229: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_auth_id,30) || ' : '|| p_auth_id);
230: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_validation_lvl,30) || ' : '|| p_validation_lvl);
231: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
232: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 230: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_validation_lvl,30) || ' : '|| p_validation_lvl);

226: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass); --------------Parameters Passed--------------
227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
228: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_batch_id,30) || ' : '|| p_batch_id);
229: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_auth_id,30) || ' : '|| p_auth_id);
230: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_validation_lvl,30) || ' : '|| p_validation_lvl);
231: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
232: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
234: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 231: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
228: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_batch_id,30) || ' : '|| p_batch_id);
229: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_auth_id,30) || ' : '|| p_auth_id);
230: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_validation_lvl,30) || ' : '|| p_validation_lvl);
231: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
232: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
234: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
235:

Line 232: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');

228: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_batch_id,30) || ' : '|| p_batch_id);
229: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_auth_id,30) || ' : '|| p_auth_id);
230: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_validation_lvl,30) || ' : '|| p_validation_lvl);
231: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
232: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
234: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
235:
236: END display_payroll_params;

Line 233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

229: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_auth_id,30) || ' : '|| p_auth_id);
230: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_validation_lvl,30) || ' : '|| p_validation_lvl);
231: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
232: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
234: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
235:
236: END display_payroll_params;
237:

Line 234: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

230: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_validation_lvl,30) || ' : '|| p_validation_lvl);
231: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
232: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
234: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
235:
236: END display_payroll_params;
237:
238:

Line 514: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Parameter Error');
511: END IF;
512:
513: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PARAM_ERR');
514: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
515: IGS_GE_MSG_STACK.ADD;
516: APP_EXCEPTION.RAISE_EXCEPTION;
517: END IF;
518:

Line 719: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

715: END IF;
716:
717: EXCEPTION -- for auth creation
718: WHEN next_record THEN
719: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
720: ROLLBACK TO se_payment;
721: END ; -- for auth generation
722:
723: IF p_call IN ('JOB','SE003') THEN

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

725: If called from AW016, COMMIT should not be issued.
726: */
727: COMMIT; --Committing the Transaction
728: fnd_message.set_name('IGF','IGF_SE_REQUERY_AUTH');
729: fnd_file.put_line(fnd_file.log,fnd_message.get);
730: END IF;
731:
732: EXCEPTION -- for main block
733: WHEN no_data_found THEN

Line 765: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

761: IGS_GE_MSG_STACK.ADD;
762:
763: -- Bug #3536039. Raise exception IGFSEGEN001
764: IF p_call = 'LEGACY' THEN -- throw exception
765: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
766: RAISE IGFSEGEN001;
767: END IF;
768:
769: IF p_call = 'JOB' THEN -- continue for next student dont stop

Line 770: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

766: RAISE IGFSEGEN001;
767: END IF;
768:
769: IF p_call = 'JOB' THEN -- continue for next student dont stop
770: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
771: ELSE -- this means its called from FORM
772: APP_EXCEPTION.RAISE_EXCEPTION;
773: END IF;
774:

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

772: APP_EXCEPTION.RAISE_EXCEPTION;
773: END IF;
774:
775: WHEN OTHERS THEN
776: fnd_file.put_line(fnd_file.log,SQLERRM);
777: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
778: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth' || SQLERRM);
779: IGS_GE_MSG_STACK.ADD;
780:

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

912: IF l_amounts.accepted_amt = l_amounts.accepted_amnt THEN
913: --no need to recreate authorization
914: --log a message
915: fnd_message.set_name('IGF','IGF_SE_AUTH_GENERATED');
916: fnd_file.put_line(fnd_file.log,fnd_message.get);
917: ELSE
918: igf_se_gen_001.send_work_auth(
919: auth_rec.base_id,
920: auth_rec.person_id,

Line 951: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

947: END IF;
948:
949: IF lb_rec_found = FALSE THEN
950: FND_MESSAGE.SET_NAME('IGF','IGF_SE_WRK_ATUH_NO_MATCH');
951: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
952: END IF;
953: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
954:
955: EXCEPTION

Line 953: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

949: IF lb_rec_found = FALSE THEN
950: FND_MESSAGE.SET_NAME('IGF','IGF_SE_WRK_ATUH_NO_MATCH');
951: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
952: END IF;
953: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
954:
955: EXCEPTION
956: WHEN OTHERS THEN
957: ROLLBACK;

Line 1077: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1076: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload:igf_se_payment_int.update');
1077: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1078: IGS_GE_MSG_STACK.ADD;
1079: -- app_exception.raise_exception;
1080:
1081: END update_record;

Line 1101: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1097:
1098: -- batch_id is mandatory parameter.
1099: IF l_batch_id IS NULL THEN
1100: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PARAM_ERR');
1101: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1102: IGS_GE_MSG_STACK.ADD;
1103: APP_EXCEPTION.RAISE_EXCEPTION;
1104: END IF;
1105:

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

1131: x_source => l_source
1132: );
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: fnd_file.put_line(fnd_file.log,fnd_message.get);
1136: ROLLBACK TO se_adjust;
1137: l_error_cd := 'SE005';
1138: update_record(payment_rec,l_error_cd);
1139: RAISE SKIP_RECORD;

Line 1160: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1156: IF cur_pymt_int_rec.status = 'DONE' THEN
1157: FND_MESSAGE.SET_NAME('IGF','IGF_SE_SUCCESS');
1158: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);
1159: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1161:
1162: ELSIF cur_pymt_int_rec.status = 'ERROR' THEN
1163: OPEN c_get_se_errors( cur_pymt_int_rec.error_code);
1164: FETCH c_get_se_errors INTO l_error_meaming;

Line 1171: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1167: FND_MESSAGE.SET_NAME('IGF','IGF_SE_NOT_SUCCESS');
1168: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);
1169: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);
1170: FND_MESSAGE.SET_TOKEN('ERROR',l_error_meaming);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1172:
1173: END IF;
1174: END LOOP;
1175:

Line 1184: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1183: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload: delete record');
1184: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1185: IGS_GE_MSG_STACK.ADD;
1186: END;
1187:
1188: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 1188: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1184: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1185: IGS_GE_MSG_STACK.ADD;
1186: END;
1187:
1188: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1189:
1190: IF l_rec_count = 0 THEN
1191: -- There are no Records to process
1192: FND_MESSAGE.SET_NAME('IGS','IGS_UC_HE_NO_DATA');

Line 1193: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1189:
1190: IF l_rec_count = 0 THEN
1191: -- There are no Records to process
1192: FND_MESSAGE.SET_NAME('IGS','IGS_UC_HE_NO_DATA');
1193: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1194:
1195: ELSE
1196: -- Total Records Processed : RCOUNT
1197: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');

Line 1199: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1195: ELSE
1196: -- Total Records Processed : RCOUNT
1197: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');
1198: FND_MESSAGE.SET_TOKEN('RCOUNT',l_rec_count);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1200:
1201: END IF;
1202: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1203:

Line 1202: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1198: FND_MESSAGE.SET_TOKEN('RCOUNT',l_rec_count);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1200:
1201: END IF;
1202: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1203:
1204: EXCEPTION -- main exception handling
1205: WHEN OTHERS THEN
1206: ROLLBACK ;