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.IGS_FI_PRC_LOCKBOX dependencies on FND_FILE

Line 96: fnd_file.put_line(fnd_file.log,

92: Change History
93: Who When What
94: ***************************************************************** */
95: BEGIN
96: fnd_file.put_line(fnd_file.log,
97: p_v_label||' : '||p_v_value);
98: END log_line;
99:
100: PROCEDURE initialize AS

Line 187: fnd_file.new_line(fnd_file.log);

183: -- g_b_log_head is a global boolean variable used if the
184: -- Lockbox Name, BatchName, Item Number and status have to be logged
185: -- for type 2 validations
186: IF NOT g_b_log_head THEN
187: fnd_file.new_line(fnd_file.log);
188: log_line(g_v_label_lb_name,
189: p_v_lockbox_name);
190: log_line(g_v_label_batch,
191: p_v_batch_name);

Line 227: fnd_file.put_line(fnd_file.log,

223: l_v_curr_desc fnd_currencies.description%TYPE;
224: l_v_message_text VARCHAR2(2000);
225: BEGIN
226: l_b_val_parm := TRUE;
227: fnd_file.put_line(fnd_file.log,
228: g_v_line_sep);
229: fnd_file.put_line(fnd_file.log,
230: fnd_message.get_string('IGS',
231: 'IGS_FI_ANC_LOG_PARM'));

Line 229: fnd_file.put_line(fnd_file.log,

225: BEGIN
226: l_b_val_parm := TRUE;
227: fnd_file.put_line(fnd_file.log,
228: g_v_line_sep);
229: fnd_file.put_line(fnd_file.log,
230: fnd_message.get_string('IGS',
231: 'IGS_FI_ANC_LOG_PARM'));
232: fnd_file.new_line(fnd_file.log);
233:

Line 232: fnd_file.new_line(fnd_file.log);

228: g_v_line_sep);
229: fnd_file.put_line(fnd_file.log,
230: fnd_message.get_string('IGS',
231: 'IGS_FI_ANC_LOG_PARM'));
232: fnd_file.new_line(fnd_file.log);
233:
234: g_v_test_run_val := igs_fi_gen_gl.get_lkp_meaning('YES_NO',
235: p_v_test_run);
236:

Line 245: fnd_file.new_line(fnd_file.log);

241: p_d_gl_date);
242: log_line(g_v_label_test_run,
243: NVL(g_v_test_run_val,p_v_test_run));
244:
245: fnd_file.new_line(fnd_file.log);
246: fnd_file.put_line(fnd_file.log,
247: g_v_line_sep);
248:
249: -- Check for Manage Account

Line 246: fnd_file.put_line(fnd_file.log,

242: log_line(g_v_label_test_run,
243: NVL(g_v_test_run_val,p_v_test_run));
244:
245: fnd_file.new_line(fnd_file.log);
246: fnd_file.put_line(fnd_file.log,
247: g_v_line_sep);
248:
249: -- Check for Manage Account
250: igs_fi_com_rec_interface.chk_manage_account(p_v_manage_acc => l_v_manage_acc,

Line 258: fnd_file.put_line(fnd_file.log,

254: IF ((l_v_manage_acc IS NULL) OR (l_v_manage_acc = 'OTHER')) THEN
255: l_b_val_parm := FALSE;
256: fnd_message.set_name('IGS',
257: l_v_message_name);
258: fnd_file.put_line(fnd_file.log,
259: fnd_message.get);
260: RETURN l_b_val_parm;
261: END IF;
262:

Line 271: fnd_file.put_line(fnd_file.log,

267: IF l_v_message_text IS NOT NULL THEN
268: l_b_val_parm := FALSE;
269: fnd_message.set_name('IGS',
270: l_v_message_name);
271: fnd_file.put_line(fnd_file.log,
272: fnd_message.get);
273: END IF;
274:
275: -- Validate if the Lockbox Name is valid

Line 285: fnd_file.put_line(fnd_file.log,

281: fnd_message.set_name('IGS',
282: 'IGS_FI_CAPI_INVALID_LOCKBOX');
283: fnd_message.set_token('LOCKBOX_NAME',
284: p_v_lockbox_name);
285: fnd_file.put_line(fnd_file.log,
286: fnd_message.get);
287: END IF;
288: CLOSE cur_lockbox;
289:

Line 297: fnd_file.put_line(fnd_file.log,

293: IF p_d_gl_date IS NULL THEN
294: l_b_val_parm := FALSE;
295: fnd_message.set_name('IGS',
296: 'IGS_FI_GL_DATE_REQD');
297: fnd_file.put_line(fnd_file.log,
298: fnd_message.get);
299: ELSE
300:
301: -- If the GL Date is passed then, check if the GL Date is in an open/future period

Line 309: fnd_file.put_line(fnd_file.log,

305: IF l_v_message_name IS NOT NULL THEN
306: l_b_val_parm := FALSE;
307: fnd_message.set_name('IGS',
308: l_v_message_name);
309: fnd_file.put_line(fnd_file.log,
310: fnd_message.get);
311: ELSE
312: IF l_v_closing_status NOT IN ('O','F') THEN
313: fnd_message.set_name('IGS',

Line 317: fnd_file.put_line(fnd_file.log,

313: fnd_message.set_name('IGS',
314: 'IGS_FI_INVALID_GL_DATE');
315: fnd_message.set_token('GL_DATE',
316: p_d_gl_date);
317: fnd_file.put_line(fnd_file.log,
318: fnd_message.get);
319: l_b_val_parm := FALSE;
320: END IF;
321: END IF;

Line 330: fnd_file.put_line(fnd_file.log,

326: -- gl date source for the lockbox is not user supplied
327: IF p_d_gl_date IS NOT NULL THEN
328: fnd_message.set_name('IGS',
329: 'IGS_FI_GL_DATE_DISRGD');
330: fnd_file.put_line(fnd_file.log,
331: fnd_message.get);
332: END IF;
333: END IF;
334:

Line 340: fnd_file.put_line(fnd_file.log,

336: IF p_v_test_run NOT IN ('Y','N') THEN
337: l_b_val_parm := FALSE;
338: fnd_message.set_name('IGS',
339: 'IGS_GE_INVALID_VALUE');
340: fnd_file.put_line(fnd_file.log,
341: fnd_message.get);
342: END IF;
343:
344: fnd_file.put_line(fnd_file.log,

Line 344: fnd_file.put_line(fnd_file.log,

340: fnd_file.put_line(fnd_file.log,
341: fnd_message.get);
342: END IF;
343:
344: fnd_file.put_line(fnd_file.log,
345: g_v_line_sep);
346: RETURN l_b_val_parm;
347: END validate_parameters;
348:

Line 490: fnd_file.put_line(fnd_file.log,

486:
487: l_n_cntr1 := l_n_cntr1+1;
488:
489: IF l_n_cntr1 = 1 THEN
490: fnd_file.put_line(fnd_file.log,
491: g_v_line_sep);
492: fnd_file.put_line(fnd_file.log,
493: g_v_label_type1);
494: fnd_file.put_line(fnd_file.log,

Line 492: fnd_file.put_line(fnd_file.log,

488:
489: IF l_n_cntr1 = 1 THEN
490: fnd_file.put_line(fnd_file.log,
491: g_v_line_sep);
492: fnd_file.put_line(fnd_file.log,
493: g_v_label_type1);
494: fnd_file.put_line(fnd_file.log,
495: g_v_line_sep);
496: fnd_file.new_line(fnd_file.log);

Line 494: fnd_file.put_line(fnd_file.log,

490: fnd_file.put_line(fnd_file.log,
491: g_v_line_sep);
492: fnd_file.put_line(fnd_file.log,
493: g_v_label_type1);
494: fnd_file.put_line(fnd_file.log,
495: g_v_line_sep);
496: fnd_file.new_line(fnd_file.log);
497: END IF;
498:

Line 496: fnd_file.new_line(fnd_file.log);

492: fnd_file.put_line(fnd_file.log,
493: g_v_label_type1);
494: fnd_file.put_line(fnd_file.log,
495: g_v_line_sep);
496: fnd_file.new_line(fnd_file.log);
497: END IF;
498:
499: g_lb_int_tab(l_rec_lb_ints.lockbox_interface_id).row_id := l_rec_lb_ints.row_id;
500: g_lb_int_tab(l_rec_lb_ints.lockbox_interface_id).lockbox_interface_id := l_rec_lb_ints.lockbox_interface_id;

Line 575: fnd_file.put_line(fnd_file.log,

571: fnd_message.set_token('RECORD_IDENTIFIER',
572: l_rec_lb_ints.record_identifier_cd);
573: fnd_message.set_token('LOCKBOX_NAME',
574: p_v_lockbox_name);
575: fnd_file.put_line(fnd_file.log,
576: fnd_message.get);
577: l_b_upd_err := TRUE;
578: END IF;
579:

Line 611: fnd_file.put_line(fnd_file.log,

607: fnd_message.set_token('RECORD_IDENTIFIER',
608: l_rec_lb_ints.record_identifier_cd);
609: fnd_message.set_token('LOCKBOX_NAME',
610: p_v_lockbox_name);
611: fnd_file.put_line(fnd_file.log,
612: fnd_message.get);
613: l_b_upd_err := TRUE;
614: END IF;
615:

Line 803: fnd_file.put_line(fnd_file.log,

799: (l_t_th_tab(l_n_cntr).transmission_record_count <> l_n_rc_cntr)) THEN
800: l_v_val_status := 'E';
801: fnd_message.set_name('IGS',
802: 'IGS_FI_TH_COUNT_MISMATCH');
803: fnd_file.put_line(fnd_file.log,
804: fnd_message.get);
805: END IF;
806:
807: -- If the Transmission Amount is not null and the transmission amount is not equal to the

Line 814: fnd_file.put_line(fnd_file.log,

810: (l_t_th_tab(l_n_cntr).transmission_amt <> l_n_receipt_amount)) THEN
811: l_v_val_status := 'E';
812: fnd_message.set_name('IGS',
813: 'IGS_FI_TH_AMOUNT_MISMATCH');
814: fnd_file.put_line(fnd_file.log,
815: fnd_message.get);
816: END IF;
817: END IF;
818: END LOOP;

Line 841: fnd_file.put_line(fnd_file.log,

837: IF l_t_lh_tab(l_n_cntr).lockbox_batch_count <> l_n_bh_cntr THEN
838: l_v_val_status := 'E';
839: fnd_message.set_name('IGS',
840: 'IGS_FI_LH_COUNT_MISMATCH');
841: fnd_file.put_line(fnd_file.log,
842: fnd_message.get);
843: END IF;
844: ELSE
845:

Line 880: fnd_file.put_line(fnd_file.log,

876: -- If the receipt record does not have a batch, then log the error message.
877: l_v_val_status := 'E';
878: fnd_message.set_name('IGS',
879: 'IGS_FI_LH_BATCH_MISSING');
880: fnd_file.put_line(fnd_file.log,
881: fnd_message.get);
882: END IF;
883: END IF;
884: END LOOP;

Line 889: fnd_file.put_line(fnd_file.log,

885: ELSE
886: l_v_val_status := 'E';
887: fnd_message.set_name('IGS',
888: 'IGS_FI_LH_COUNT_MISMATCH');
889: fnd_file.put_line(fnd_file.log,
890: fnd_message.get);
891: END IF;
892:
893: -- If the distinct batch count PL/SQL table has some records and the count does not match the Lockbox Batch Count,

Line 900: fnd_file.put_line(fnd_file.log,

896: (l_t_distinct_batch.COUNT > 0)) THEN
897: l_v_val_status := 'E';
898: fnd_message.set_name('IGS',
899: 'IGS_FI_LH_COUNT_MISMATCH');
900: fnd_file.put_line(fnd_file.log,
901: fnd_message.get);
902: END IF;
903: l_t_distinct_batch.DELETE;
904: END IF;

Line 914: fnd_file.put_line(fnd_file.log,

910: (l_t_lh_tab(l_n_cntr).lockbox_amt <> l_n_receipt_amount)) THEN
911: l_v_val_status := 'E';
912: fnd_message.set_name('IGS',
913: 'IGS_FI_LH_AMOUNT_MISMATCH');
914: fnd_file.put_line(fnd_file.log,
915: fnd_message.get);
916: END IF;
917:
918: -- If the Lockbox Record Count is not equal to the receipt count, then log this as

Line 925: fnd_file.put_line(fnd_file.log,

921: (l_t_lh_tab(l_n_cntr).lockbox_record_count <> l_n_rc_cntr)) THEN
922: l_v_val_status := 'E';
923: fnd_message.set_name('IGS',
924: 'IGS_FI_LH_RECCOUNT_MISMATCH');
925: fnd_file.put_line(fnd_file.log,
926: fnd_message.get);
927: END IF;
928: END IF;
929: END LOOP;

Line 952: fnd_file.put_line(fnd_file.log,

948: (l_t_bh_tab(l_n_cntr1).lockbox_interface_id <> l_t_bh_tab(l_n_cntr).lockbox_interface_id)) THEN
949: l_v_val_status := 'E';
950: fnd_message.set_name('IGS',
951: 'IGS_FI_DUP_BATCHES');
952: fnd_file.put_line(fnd_file.log,
953: fnd_message.get);
954: l_b_dup_batches := TRUE;
955: EXIT;
956: END IF;

Line 998: fnd_file.put_line(fnd_file.log,

994: fnd_message.set_name('IGS',
995: 'IGS_FI_BH_COUNT_MISMATCH');
996: fnd_message.set_token('BATCH_NAME',
997: l_t_bh_tab(l_n_cntr).batch_name);
998: fnd_file.put_line(fnd_file.log,
999: fnd_message.get);
1000: END IF;
1001: ELSE
1002:

Line 1010: fnd_file.put_line(fnd_file.log,

1006: fnd_message.set_name('IGS',
1007: 'IGS_FI_NO_REC_IN_BATCH');
1008: fnd_message.set_token('BATCH_NAME',
1009: l_t_bh_tab(l_n_cntr).batch_name);
1010: fnd_file.put_line(fnd_file.log,
1011: fnd_message.get);
1012: END IF;
1013:
1014: -- If the batch amount is not equal to the batch amount of the batch header record then

Line 1023: fnd_file.put_line(fnd_file.log,

1019: fnd_message.set_name('IGS',
1020: 'IGS_FI_BH_AMOUNT_MISMATCH');
1021: fnd_message.set_token('BATCH_NAME',
1022: l_t_bh_tab(l_n_cntr).batch_name);
1023: fnd_file.put_line(fnd_file.log,
1024: fnd_message.get);
1025: END IF;
1026:
1027: l_n_batch_count := 0;

Line 1064: fnd_file.put_line(fnd_file.log,

1060: IF NOT l_b_rec_batch THEN
1061: l_v_val_status := 'E';
1062: fnd_message.set_name('IGS',
1063: 'IGS_FI_NO_REC_BATCH_LINK');
1064: fnd_file.put_line(fnd_file.log,
1065: fnd_message.get);
1066: END IF;
1067: END IF;
1068:

Line 1075: fnd_file.put_line(fnd_file.log,

1071: IF l_t_rc_tab(l_n_cntr).item_number IS NULL THEN
1072: l_v_val_status := 'E';
1073: fnd_message.set_name('IGS',
1074: 'IGS_FI_REC_ITEMS_MISSING');
1075: fnd_file.put_line(fnd_file.log,
1076: fnd_message.get);
1077: END IF;
1078:
1079: -- If the receipt amount is less than 0 or the receipt amount is null, then log this in the log file

Line 1090: fnd_file.put_line(fnd_file.log,

1086: fnd_message.set_token('BATCH_NAME',
1087: l_t_rc_tab(l_n_cntr).batch_name);
1088: fnd_message.set_token('LOCKBOX_NAME',
1089: l_t_rc_tab(l_n_cntr).lockbox_name);
1090: fnd_file.put_line(fnd_file.log,
1091: fnd_message.get);
1092: END IF;
1093:
1094: -- If the party number in the receipt record is null, then log this as an error in the log file

Line 1105: fnd_file.put_line(fnd_file.log,

1101: fnd_message.set_token('BATCH_NAME',
1102: l_t_rc_tab(l_n_cntr).batch_name);
1103: fnd_message.set_token('LOCKBOX_NAME',
1104: l_t_rc_tab(l_n_cntr).lockbox_name);
1105: fnd_file.put_line(fnd_file.log,
1106: fnd_message.get);
1107: END IF;
1108:
1109: -- The following logic determines if the item number as mentioned in the receipt record is unique across

Line 1145: fnd_file.put_line(fnd_file.log,

1141: IF l_b_batch_unq THEN
1142: l_v_val_status := 'E';
1143: fnd_message.set_name('IGS',
1144: 'IGS_FI_DUP_ITEM_NUMBER');
1145: fnd_file.put_line(fnd_file.log,
1146: fnd_message.get);
1147: END IF;
1148:
1149: -- If any of the combination pairs of the Charge Code(1-8) and Applied Amount(1-8)

Line 1219: fnd_file.put_line(fnd_file.log,

1215: fnd_message.set_token('BATCH_NAME',
1216: l_t_rc_tab(l_n_cntr).batch_name);
1217: fnd_message.set_token('LOCKBOX_NAME',
1218: l_t_rc_tab(l_n_cntr).lockbox_name);
1219: fnd_file.put_line(fnd_file.log,
1220: fnd_message.get);
1221: END IF;
1222:
1223: -- The following logic checks for the negative amount for the Charge Amount

Line 1237: fnd_file.put_line(fnd_file.log,

1233: fnd_message.set_token('LOCKBOX_NAME',
1234: l_t_rc_tab(l_n_cntr).lockbox_name);
1235: fnd_message.set_token('CHARGE_CODE',
1236: l_t_rc_tab(l_n_cntr).charge_cd1);
1237: fnd_file.put_line(fnd_file.log,
1238: fnd_message.get);
1239: END IF;
1240:
1241: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt2,0) < 0 THEN

Line 1253: fnd_file.put_line(fnd_file.log,

1249: fnd_message.set_token('LOCKBOX_NAME',
1250: l_t_rc_tab(l_n_cntr).lockbox_name);
1251: fnd_message.set_token('CHARGE_CODE',
1252: l_t_rc_tab(l_n_cntr).charge_cd2);
1253: fnd_file.put_line(fnd_file.log,
1254: fnd_message.get);
1255: END IF;
1256:
1257: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt3,0) < 0 THEN

Line 1269: fnd_file.put_line(fnd_file.log,

1265: fnd_message.set_token('LOCKBOX_NAME',
1266: l_t_rc_tab(l_n_cntr).lockbox_name);
1267: fnd_message.set_token('CHARGE_CODE',
1268: l_t_rc_tab(l_n_cntr).charge_cd3);
1269: fnd_file.put_line(fnd_file.log,
1270: fnd_message.get);
1271: END IF;
1272:
1273: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt4,0) < 0 THEN

Line 1285: fnd_file.put_line(fnd_file.log,

1281: fnd_message.set_token('LOCKBOX_NAME',
1282: l_t_rc_tab(l_n_cntr).lockbox_name);
1283: fnd_message.set_token('CHARGE_CODE',
1284: l_t_rc_tab(l_n_cntr).charge_cd4);
1285: fnd_file.put_line(fnd_file.log,
1286: fnd_message.get);
1287: END IF;
1288:
1289: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt5,0) < 0 THEN

Line 1301: fnd_file.put_line(fnd_file.log,

1297: fnd_message.set_token('LOCKBOX_NAME',
1298: l_t_rc_tab(l_n_cntr).lockbox_name);
1299: fnd_message.set_token('CHARGE_CODE',
1300: l_t_rc_tab(l_n_cntr).charge_cd5);
1301: fnd_file.put_line(fnd_file.log,
1302: fnd_message.get);
1303: END IF;
1304:
1305: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt6,0) < 0 THEN

Line 1317: fnd_file.put_line(fnd_file.log,

1313: fnd_message.set_token('LOCKBOX_NAME',
1314: l_t_rc_tab(l_n_cntr).lockbox_name);
1315: fnd_message.set_token('CHARGE_CODE',
1316: l_t_rc_tab(l_n_cntr).charge_cd6);
1317: fnd_file.put_line(fnd_file.log,
1318: fnd_message.get);
1319: END IF;
1320:
1321: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt7,0) < 0 THEN

Line 1333: fnd_file.put_line(fnd_file.log,

1329: fnd_message.set_token('LOCKBOX_NAME',
1330: l_t_rc_tab(l_n_cntr).lockbox_name);
1331: fnd_message.set_token('CHARGE_CODE',
1332: l_t_rc_tab(l_n_cntr).charge_cd7);
1333: fnd_file.put_line(fnd_file.log,
1334: fnd_message.get);
1335: END IF;
1336:
1337: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt8,0) < 0 THEN

Line 1349: fnd_file.put_line(fnd_file.log,

1345: fnd_message.set_token('LOCKBOX_NAME',
1346: l_t_rc_tab(l_n_cntr).lockbox_name);
1347: fnd_message.set_token('CHARGE_CODE',
1348: l_t_rc_tab(l_n_cntr).charge_cd8);
1349: fnd_file.put_line(fnd_file.log,
1350: fnd_message.get);
1351: END IF;
1352:
1353: -- Sum up the Applied Amount (1-8) of the receipt record

Line 1412: fnd_file.put_line(fnd_file.log,

1408: fnd_message.set_token('BATCH_NAME',
1409: l_t_rc_tab(l_n_cntr).batch_name);
1410: fnd_message.set_token('LOCKBOX_NAME',
1411: l_t_rc_tab(l_n_cntr).lockbox_name);
1412: fnd_file.put_line(fnd_file.log,
1413: fnd_message.get);
1414: END IF;
1415: END IF;
1416: END LOOP;

Line 1430: fnd_file.put_line(fnd_file.log,

1426: IF l_t_ro_tab(l_n_cntr).item_number IS NULL THEN
1427: l_v_val_status := 'E';
1428: fnd_message.set_name('IGS',
1429: 'IGS_FI_REC_ITEMS_MISSING');
1430: fnd_file.put_line(fnd_file.log,
1431: fnd_message.get);
1432: END IF;
1433:
1434: -- The following logic checks for the negative amount for the Charge Amount

Line 1448: fnd_file.put_line(fnd_file.log,

1444: fnd_message.set_token('LOCKBOX_NAME',
1445: l_t_ro_tab(l_n_cntr).lockbox_name);
1446: fnd_message.set_token('CHARGE_CODE',
1447: l_t_ro_tab(l_n_cntr).charge_cd1);
1448: fnd_file.put_line(fnd_file.log,
1449: fnd_message.get);
1450: END IF;
1451:
1452: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt2,0) < 0 THEN

Line 1464: fnd_file.put_line(fnd_file.log,

1460: fnd_message.set_token('LOCKBOX_NAME',
1461: l_t_ro_tab(l_n_cntr).lockbox_name);
1462: fnd_message.set_token('CHARGE_CODE',
1463: l_t_ro_tab(l_n_cntr).charge_cd2);
1464: fnd_file.put_line(fnd_file.log,
1465: fnd_message.get);
1466: END IF;
1467:
1468: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt3,0) < 0 THEN

Line 1480: fnd_file.put_line(fnd_file.log,

1476: fnd_message.set_token('LOCKBOX_NAME',
1477: l_t_ro_tab(l_n_cntr).lockbox_name);
1478: fnd_message.set_token('CHARGE_CODE',
1479: l_t_ro_tab(l_n_cntr).charge_cd3);
1480: fnd_file.put_line(fnd_file.log,
1481: fnd_message.get);
1482: END IF;
1483:
1484: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt4,0) < 0 THEN

Line 1496: fnd_file.put_line(fnd_file.log,

1492: fnd_message.set_token('LOCKBOX_NAME',
1493: l_t_ro_tab(l_n_cntr).lockbox_name);
1494: fnd_message.set_token('CHARGE_CODE',
1495: l_t_ro_tab(l_n_cntr).charge_cd4);
1496: fnd_file.put_line(fnd_file.log,
1497: fnd_message.get);
1498: END IF;
1499:
1500: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt5,0) < 0 THEN

Line 1512: fnd_file.put_line(fnd_file.log,

1508: fnd_message.set_token('LOCKBOX_NAME',
1509: l_t_ro_tab(l_n_cntr).lockbox_name);
1510: fnd_message.set_token('CHARGE_CODE',
1511: l_t_ro_tab(l_n_cntr).charge_cd5);
1512: fnd_file.put_line(fnd_file.log,
1513: fnd_message.get);
1514: END IF;
1515:
1516: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt6,0) < 0 THEN

Line 1528: fnd_file.put_line(fnd_file.log,

1524: fnd_message.set_token('LOCKBOX_NAME',
1525: l_t_ro_tab(l_n_cntr).lockbox_name);
1526: fnd_message.set_token('CHARGE_CODE',
1527: l_t_ro_tab(l_n_cntr).charge_cd6);
1528: fnd_file.put_line(fnd_file.log,
1529: fnd_message.get);
1530: END IF;
1531:
1532: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt7,0) < 0 THEN

Line 1544: fnd_file.put_line(fnd_file.log,

1540: fnd_message.set_token('LOCKBOX_NAME',
1541: l_t_ro_tab(l_n_cntr).lockbox_name);
1542: fnd_message.set_token('CHARGE_CODE',
1543: l_t_ro_tab(l_n_cntr).charge_cd7);
1544: fnd_file.put_line(fnd_file.log,
1545: fnd_message.get);
1546: END IF;
1547:
1548: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt8,0) < 0 THEN

Line 1560: fnd_file.put_line(fnd_file.log,

1556: fnd_message.set_token('LOCKBOX_NAME',
1557: l_t_ro_tab(l_n_cntr).lockbox_name);
1558: fnd_message.set_token('CHARGE_CODE',
1559: l_t_ro_tab(l_n_cntr).charge_cd8);
1560: fnd_file.put_line(fnd_file.log,
1561: fnd_message.get);
1562: END IF;
1563:
1564: l_n_cntr1 := 0;

Line 1625: fnd_file.put_line(fnd_file.log,

1621: fnd_message.set_token('BATCH_NAME',
1622: l_t_ro_tab(l_n_cntr).batch_name);
1623: fnd_message.set_token('LOCKBOX_NAME',
1624: l_t_ro_tab(l_n_cntr).lockbox_name);
1625: fnd_file.put_line(fnd_file.log,
1626: fnd_message.get);
1627: END IF;
1628:
1629: l_b_ro_chg_appl := TRUE;

Line 1701: fnd_file.put_line(fnd_file.log,

1697: fnd_message.set_token('BATCH_NAME',
1698: l_t_ro_tab(l_n_cntr).batch_name);
1699: fnd_message.set_token('LOCKBOX_NAME',
1700: l_t_ro_tab(l_n_cntr).lockbox_name);
1701: fnd_file.put_line(fnd_file.log,
1702: fnd_message.get);
1703: END IF;
1704:
1705: -- If none of the charge code(1-8) and applied amount(1-8) is provided

Line 1732: fnd_file.put_line(fnd_file.log,

1728: fnd_message.set_token('BATCH_NAME',
1729: l_t_ro_tab(l_n_cntr).batch_name);
1730: fnd_message.set_token('LOCKBOX_NAME',
1731: l_t_ro_tab(l_n_cntr).lockbox_name);
1732: fnd_file.put_line(fnd_file.log,
1733: fnd_message.get);
1734: END IF;
1735: END IF;
1736: END LOOP;

Line 1738: fnd_file.new_line(fnd_file.log);

1734: END IF;
1735: END IF;
1736: END LOOP;
1737: END IF;
1738: fnd_file.new_line(fnd_file.log);
1739:
1740: fnd_file.put_line(fnd_file.log,
1741: g_v_line_sep);
1742: return l_v_val_status;

Line 1740: fnd_file.put_line(fnd_file.log,

1736: END LOOP;
1737: END IF;
1738: fnd_file.new_line(fnd_file.log);
1739:
1740: fnd_file.put_line(fnd_file.log,
1741: g_v_line_sep);
1742: return l_v_val_status;
1743: END validate_type1;
1744:

Line 2453: fnd_file.put_line(fnd_file.log,

2449:
2450: BEGIN
2451:
2452: -- Log the message for the Type 2 validation errors.
2453: fnd_file.put_line(fnd_file.log,
2454: g_v_line_sep);
2455: fnd_file.put_line(fnd_file.log,
2456: g_v_label_type2);
2457: fnd_message.set_name('IGS',

Line 2455: fnd_file.put_line(fnd_file.log,

2451:
2452: -- Log the message for the Type 2 validation errors.
2453: fnd_file.put_line(fnd_file.log,
2454: g_v_line_sep);
2455: fnd_file.put_line(fnd_file.log,
2456: g_v_label_type2);
2457: fnd_message.set_name('IGS',
2458: 'IGS_FI_REC_IMP_ERRS');
2459: fnd_file.put_line(fnd_file.log,

Line 2459: fnd_file.put_line(fnd_file.log,

2455: fnd_file.put_line(fnd_file.log,
2456: g_v_label_type2);
2457: fnd_message.set_name('IGS',
2458: 'IGS_FI_REC_IMP_ERRS');
2459: fnd_file.put_line(fnd_file.log,
2460: fnd_message.get);
2461: fnd_file.put_line(fnd_file.log,
2462: g_v_line_sep);
2463:

Line 2461: fnd_file.put_line(fnd_file.log,

2457: fnd_message.set_name('IGS',
2458: 'IGS_FI_REC_IMP_ERRS');
2459: fnd_file.put_line(fnd_file.log,
2460: fnd_message.get);
2461: fnd_file.put_line(fnd_file.log,
2462: g_v_line_sep);
2463:
2464: -- Divide the PL/SQL table into Receipt and Receipt Overflow records.
2465: IF p_t_lb_rec_tab.COUNT > 0 THEN

Line 2547: fnd_file.put_line(fnd_file.log,

2543: fnd_message.set_name('IGS',
2544: 'IGS_FI_INV_PARTY_NUMBER');
2545: fnd_message.set_token('PARTY_NUMBER',
2546: l_t_rc_tab(l_n_cntr).party_number);
2547: fnd_file.put_line(fnd_file.log,
2548: fnd_message.get);
2549: END IF;
2550: CLOSE cur_party;
2551:

Line 2570: fnd_file.put_line(fnd_file.log,

2566: fnd_message.set_name('IGS',
2567: 'IGS_FI_NO_DEF_CR_TYPE');
2568: fnd_message.set_token('LOCKBOX_NAME',
2569: l_t_rc_tab(l_n_cntr).lockbox_name);
2570: fnd_file.put_line(fnd_file.log,
2571: fnd_message.get);
2572: END IF;
2573: ELSE
2574:

Line 2591: fnd_file.put_line(fnd_file.log,

2587: fnd_message.set_name('IGS',
2588: 'IGS_FI_NO_CR_TYPE_MAP');
2589: fnd_message.set_token('CREDIT_TYPE_BANK_CODE',
2590: l_t_rc_tab(l_n_cntr).credit_type_cd);
2591: fnd_file.put_line(fnd_file.log,
2592: fnd_message.get);
2593: END IF;
2594: CLOSE cur_lb_crt_map;
2595: END IF;

Line 2615: fnd_file.put_line(fnd_file.log,

2611: fnd_message.set_name('IGS',
2612: 'IGS_FI_CAPI_CR_TYPE_INVALID');
2613: fnd_message.set_token('CR_TYPE',
2614: get_credit_type_name(l_t_rc_tab(l_n_cntr).mapped_credit_type_id));
2615: fnd_file.put_line(fnd_file.log,
2616: fnd_message.get);
2617: END IF;
2618:
2619: -- If the Credit Class is Enrollment Deposit or Other Deposit, then check if the Charge Code and Charge Amount

Line 2651: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

2647: fnd_message.set_name('IGS',
2648: 'IGS_FI_DEP_NO_OVFLOW');
2649: fnd_message.set_token('CREDIT_CLASS',
2650: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_CREDIT_CLASS', l_v_credit_class));
2651: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
2652: END IF;
2653:
2654: -- Also check if there are any overflow records for the receipt in case of Enrollment Deposit or Other Deposit
2655: -- If there are any overflow records then it is a type 2 error.

Line 2677: fnd_file.put_line(fnd_file.log,

2673: fnd_message.set_name('IGS',
2674: 'IGS_FI_DEP_NO_OVFLOW');
2675: fnd_message.set_token('CREDIT_CLASS',
2676: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_CREDIT_CLASS', l_v_credit_class));
2677: fnd_file.put_line(fnd_file.log,
2678: fnd_message.get);
2679: END IF;
2680: END IF;
2681:

Line 2698: fnd_file.put_line(fnd_file.log,

2694: fnd_message.set_name('IGS',
2695: 'IGS_FI_PARTY_STUDENT');
2696: fnd_message.set_token('PARTY_NUMBER',
2697: l_t_rc_tab(l_n_cntr).party_number);
2698: fnd_file.put_line(fnd_file.log,
2699: fnd_message.get);
2700: ELSIF l_v_credit_class = g_v_oth_deposit THEN
2701: fnd_message.set_name('IGS',
2702: 'IGS_FI_PARTY_PERSON');

Line 2705: fnd_file.put_line(fnd_file.log,

2701: fnd_message.set_name('IGS',
2702: 'IGS_FI_PARTY_PERSON');
2703: fnd_message.set_token('PARTY_NUMBER',
2704: l_t_rc_tab(l_n_cntr).party_number);
2705: fnd_file.put_line(fnd_file.log,
2706: fnd_message.get);
2707: END IF;
2708: END IF;
2709: l_b_ret_stat := null;

Line 2729: fnd_file.put_line(fnd_file.log,

2725: fnd_message.set_token('PAY_CR_TYPE',
2726: get_credit_type_name(l_n_pay_cr_type_id));
2727: fnd_message.set_token('DEP_CR_TYPE',
2728: get_credit_type_name(l_t_rc_tab(l_n_cntr).mapped_credit_type_id));
2729: fnd_file.put_line(fnd_file.log,
2730: fnd_message.get);
2731: END IF;
2732:
2733: -- If the credit class is ENRDEPOSIT, then validate if the Admission Application Id is valid. If not, log the error in the

Line 2748: fnd_file.put_line(fnd_file.log,

2744: fnd_message.set_token('ADMISSION_APPLICATION_ID',
2745: l_t_rc_tab(l_n_cntr).adm_application_id);
2746: fnd_message.set_token('PARTY_NUMBER',
2747: l_t_rc_tab(l_n_cntr).party_number);
2748: fnd_file.put_line(fnd_file.log,
2749: fnd_message.get);
2750: ELSE
2751: l_t_rc_tab(l_n_cntr).source_transaction_type := g_v_adm;
2752: END IF;

Line 2769: fnd_file.put_line(fnd_file.log,

2765: l_t_rc_tab(l_n_cntr).batch_name,
2766: l_t_rc_tab(l_n_cntr).item_number);
2767: fnd_message.set_name('IGS',
2768: 'IGS_FI_GL_DATE_MISSING');
2769: fnd_file.put_line(fnd_file.log,
2770: fnd_message.get);
2771: ELSE
2772:
2773: -- Else, validate if the deposit date is in an Open or Future Period or is in a valid accounting period.

Line 2785: fnd_file.put_line(fnd_file.log,

2781: l_t_rc_tab(l_n_cntr).batch_name,
2782: l_t_rc_tab(l_n_cntr).item_number);
2783: fnd_message.set_name('IGS',
2784: l_v_message_name);
2785: fnd_file.put_line(fnd_file.log,
2786: fnd_message.get);
2787: ELSIF l_v_closing_status NOT IN ('O','F') THEN
2788: l_b_val_err := TRUE;
2789: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,

Line 2796: fnd_file.put_line(fnd_file.log,

2792: fnd_message.set_name('IGS',
2793: 'IGS_FI_INVALID_GL_DATE');
2794: fnd_message.set_token('GL_DATE',
2795: l_t_rc_tab(l_n_cntr).gl_date);
2796: fnd_file.put_line(fnd_file.log,
2797: fnd_message.get);
2798: END IF;
2799: END IF;
2800: ELSIF g_v_gl_date_source = g_v_imp_date THEN

Line 2829: fnd_file.put_line(fnd_file.log,

2825: fnd_message.set_name('IGS',
2826: 'IGS_FI_NO_FCI_MAP');
2827: fnd_message.set_token('FEE_CAL_INSTANCE_CODE',
2828: l_t_rc_tab(l_n_cntr).fee_cal_instance_cd);
2829: fnd_file.put_line(fnd_file.log,
2830: fnd_message.get);
2831: END IF;
2832: CLOSE cur_fcmap;
2833:

Line 2848: fnd_file.put_line(fnd_file.log,

2844: fnd_message.set_name('IGS',
2845: 'IGS_FI_FCI_INVALID');
2846: fnd_message.set_token('FEE_CAL_INSTANCE_CODE',
2847: l_t_rc_tab(l_n_cntr).fee_cal_instance_cd);
2848: fnd_file.put_line(fnd_file.log,
2849: fnd_message.get);
2850: END IF;
2851:
2852: -- Check if the Mapped Fee Calendar Instance has a valid Load Calendar Instance

Line 2870: fnd_file.put_line(fnd_file.log,

2866: l_t_rc_tab(l_n_cntr).batch_name,
2867: l_t_rc_tab(l_n_cntr).item_number);
2868: fnd_message.set_name('IGS',
2869: l_v_message_name);
2870: fnd_file.put_line(fnd_file.log,
2871: fnd_message.get);
2872: END IF;
2873: END IF;
2874: END IF;

Line 2889: fnd_file.put_line(fnd_file.log,

2885: l_t_rc_tab(l_n_cntr).batch_name,
2886: l_t_rc_tab(l_n_cntr).item_number);
2887: fnd_message.set_name('IGS',
2888: l_v_message_name);
2889: fnd_file.put_line(fnd_file.log,
2890: fnd_message.get);
2891: END IF;
2892:
2893: -- Validate the DFF

Line 2922: fnd_file.put_line(fnd_file.log,

2918: l_t_rc_tab(l_n_cntr).batch_name,
2919: l_t_rc_tab(l_n_cntr).item_number);
2920: fnd_message.set_name('IGS',
2921: 'IGS_AD_INVALID_DESC_FLEX');
2922: fnd_file.put_line(fnd_file.log,
2923: fnd_message.get);
2924: END IF;
2925:
2926: -- If any of the Charge Codes is not null, then validate if the charge number can be applied and is a valid charge

Line 2944: fnd_file.put_line(fnd_file.log,

2940: l_b_val_err := TRUE;
2941: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2942: l_t_rc_tab(l_n_cntr).batch_name,
2943: l_t_rc_tab(l_n_cntr).item_number);
2944: fnd_file.put_line(fnd_file.log,
2945: l_v_message_text);
2946: ELSE
2947: l_t_rc_tab(l_n_cntr).target_invoice_id1 := l_n_invoice_id;
2948: l_t_rc_tab(l_n_cntr).eligible_to_apply_yn := 'Y';

Line 2968: fnd_file.put_line(fnd_file.log,

2964: l_b_val_err := TRUE;
2965: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2966: l_t_rc_tab(l_n_cntr).batch_name,
2967: l_t_rc_tab(l_n_cntr).item_number);
2968: fnd_file.put_line(fnd_file.log,
2969: l_v_message_text);
2970: ELSE
2971: l_t_rc_tab(l_n_cntr).target_invoice_id2 := l_n_invoice_id;
2972: l_t_rc_tab(l_n_cntr).eligible_to_apply_yn := 'Y';

Line 2992: fnd_file.put_line(fnd_file.log,

2988: l_b_val_err := TRUE;
2989: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2990: l_t_rc_tab(l_n_cntr).batch_name,
2991: l_t_rc_tab(l_n_cntr).item_number);
2992: fnd_file.put_line(fnd_file.log,
2993: l_v_message_text);
2994: ELSE
2995: l_t_rc_tab(l_n_cntr).target_invoice_id3 := l_n_invoice_id;
2996: l_t_rc_tab(l_n_cntr).eligible_to_apply_yn := 'Y';

Line 3016: fnd_file.put_line(fnd_file.log,

3012: l_b_val_err := TRUE;
3013: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3014: l_t_rc_tab(l_n_cntr).batch_name,
3015: l_t_rc_tab(l_n_cntr).item_number);
3016: fnd_file.put_line(fnd_file.log,
3017: l_v_message_text);
3018: ELSE
3019: l_t_rc_tab(l_n_cntr).target_invoice_id4 := l_n_invoice_id;
3020: l_t_rc_tab(l_n_cntr).eligible_to_apply_yn := 'Y';

Line 3040: fnd_file.put_line(fnd_file.log,

3036: l_b_val_err := TRUE;
3037: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3038: l_t_rc_tab(l_n_cntr).batch_name,
3039: l_t_rc_tab(l_n_cntr).item_number);
3040: fnd_file.put_line(fnd_file.log,
3041: l_v_message_text);
3042: ELSE
3043: l_t_rc_tab(l_n_cntr).target_invoice_id5 := l_n_invoice_id;
3044: l_t_rc_tab(l_n_cntr).eligible_to_apply_yn := 'Y';

Line 3064: fnd_file.put_line(fnd_file.log,

3060: l_b_val_err := TRUE;
3061: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3062: l_t_rc_tab(l_n_cntr).batch_name,
3063: l_t_rc_tab(l_n_cntr).item_number);
3064: fnd_file.put_line(fnd_file.log,
3065: l_v_message_text);
3066: ELSE
3067: l_t_rc_tab(l_n_cntr).target_invoice_id6 := l_n_invoice_id;
3068: l_t_rc_tab(l_n_cntr).eligible_to_apply_yn := 'Y';

Line 3088: fnd_file.put_line(fnd_file.log,

3084: l_b_val_err := TRUE;
3085: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3086: l_t_rc_tab(l_n_cntr).batch_name,
3087: l_t_rc_tab(l_n_cntr).item_number);
3088: fnd_file.put_line(fnd_file.log,
3089: l_v_message_text);
3090: ELSE
3091: l_t_rc_tab(l_n_cntr).target_invoice_id1 := l_n_invoice_id;
3092: l_t_rc_tab(l_n_cntr).eligible_to_apply_yn := 'Y';

Line 3112: fnd_file.put_line(fnd_file.log,

3108: l_b_val_err := TRUE;
3109: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3110: l_t_rc_tab(l_n_cntr).batch_name,
3111: l_t_rc_tab(l_n_cntr).item_number);
3112: fnd_file.put_line(fnd_file.log,
3113: l_v_message_text);
3114: ELSE
3115: l_t_rc_tab(l_n_cntr).target_invoice_id8 := l_n_invoice_id;
3116: l_t_rc_tab(l_n_cntr).eligible_to_apply_yn := 'Y';

Line 3144: fnd_file.put_line(fnd_file.log,

3140: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3141: l_t_rc_tab(l_n_cntr).batch_name,
3142: l_t_rc_tab(l_n_cntr).item_number);
3143: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;
3144: fnd_file.put_line(fnd_file.log,
3145: l_v_message_text);
3146: ELSE
3147: IF l_b_val_err THEN
3148: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;

Line 3173: fnd_file.put_line(fnd_file.log,

3169: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3170: l_t_rc_tab(l_n_cntr).batch_name,
3171: l_t_rc_tab(l_n_cntr).item_number);
3172: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;
3173: fnd_file.put_line(fnd_file.log,
3174: l_v_message_text);
3175: ELSE
3176: IF l_b_val_err THEN
3177: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;

Line 3202: fnd_file.put_line(fnd_file.log,

3198: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3199: l_t_rc_tab(l_n_cntr).batch_name,
3200: l_t_rc_tab(l_n_cntr).item_number);
3201: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;
3202: fnd_file.put_line(fnd_file.log,
3203: l_v_message_text);
3204: ELSE
3205: IF l_b_val_err THEN
3206: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;

Line 3231: fnd_file.put_line(fnd_file.log,

3227: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3228: l_t_rc_tab(l_n_cntr).batch_name,
3229: l_t_rc_tab(l_n_cntr).item_number);
3230: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;
3231: fnd_file.put_line(fnd_file.log,
3232: l_v_message_text);
3233: ELSE
3234: IF l_b_val_err THEN
3235: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;

Line 3259: fnd_file.put_line(fnd_file.log,

3255: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3256: l_t_rc_tab(l_n_cntr).batch_name,
3257: l_t_rc_tab(l_n_cntr).item_number);
3258: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;
3259: fnd_file.put_line(fnd_file.log,
3260: l_v_message_text);
3261: ELSE
3262: IF l_b_val_err THEN
3263: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;

Line 3288: fnd_file.put_line(fnd_file.log,

3284: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3285: l_t_rc_tab(l_n_cntr).batch_name,
3286: l_t_rc_tab(l_n_cntr).item_number);
3287: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;
3288: fnd_file.put_line(fnd_file.log,
3289: l_v_message_text);
3290: ELSE
3291: IF l_b_val_err THEN
3292: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;

Line 3317: fnd_file.put_line(fnd_file.log,

3313: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3314: l_t_rc_tab(l_n_cntr).batch_name,
3315: l_t_rc_tab(l_n_cntr).item_number);
3316: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;
3317: fnd_file.put_line(fnd_file.log,
3318: l_v_message_text);
3319: ELSE
3320: IF l_b_val_err THEN
3321: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;

Line 3346: fnd_file.put_line(fnd_file.log,

3342: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3343: l_t_rc_tab(l_n_cntr).batch_name,
3344: l_t_rc_tab(l_n_cntr).item_number);
3345: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;
3346: fnd_file.put_line(fnd_file.log,
3347: l_v_message_text);
3348: ELSE
3349: IF l_b_val_err THEN
3350: l_t_ro_tab(l_n_cntr1).record_status := g_v_error;

Line 3430: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

3426: l_t_rc_tab(l_n_cntr).record_status := g_v_error;
3427:
3428: fnd_message.set_name( 'IGS', 'IGS_FI_PP_NO_DEF_CRT' );
3429: fnd_message.set_token( 'LOCKBOX_NAME', l_t_rc_tab(l_n_cntr).lockbox_name );
3430: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3431: ELSE
3432: -- If Default Credit Type is present then proceed with credit creation.
3433: l_n_cr_type_id_api := l_n_dflt_cr_type_id;
3434: l_t_rc_tab(l_n_cntr).mapped_credit_type_id := l_n_dflt_cr_type_id;

Line 3465: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

3461: l_t_rc_tab(l_n_cntr).record_status := g_v_error;
3462:
3463: fnd_message.set_name( 'IGS', 'IGS_FI_PP_NO_DEF_CRT' );
3464: fnd_message.set_token( 'LOCKBOX_NAME', l_t_rc_tab(l_n_cntr).lockbox_name );
3465: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3466: ELSE
3467: -- If Default Credit Type is present then proceed with credit creation for the difference amount.
3468: l_n_cr_type_id_api := l_n_dflt_cr_type_id;
3469: l_n_amount_api := l_n_diff_amount;

Line 3489: fnd_file.put_line(fnd_file.LOG, l_v_message_text);

3485: l_t_rc_tab(l_n_cntr).batch_name,
3486: l_t_rc_tab(l_n_cntr).item_number);
3487: l_t_rc_tab(l_n_cntr).record_status := g_v_error;
3488:
3489: fnd_file.put_line(fnd_file.LOG, l_v_message_text);
3490: ELSE
3491: -- Even when status = 'S', there might be a message if holds release failed.
3492: l_b_val_err := FALSE;
3493: l_n_credit_id := NULL;

Line 3521: fnd_file.put_line(fnd_file.log,

3517: l_t_rc_tab(l_n_cntr).batch_name,
3518: l_t_rc_tab(l_n_cntr).item_number);
3519: l_t_rc_tab(l_n_cntr).record_status := g_v_error;
3520:
3521: fnd_file.put_line(fnd_file.log,
3522: l_v_message_text);
3523: ELSE
3524: -- Even when status = 'S', there might be a message if holds release failed.
3525: l_b_val_err := FALSE;

Line 3565: fnd_file.put_line(fnd_file.log,

3561: l_b_val_err := TRUE;
3562: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3563: l_t_rc_tab(l_n_cntr).batch_name,
3564: l_t_rc_tab(l_n_cntr).item_number);
3565: fnd_file.put_line(fnd_file.log,
3566: l_v_message_text);
3567: ELSE
3568: l_t_rc_tab(l_n_cntr).act_applied_amt1 := l_n_act_amnt_applied;
3569: END IF;

Line 3588: fnd_file.put_line(fnd_file.log,

3584: l_b_val_err := TRUE;
3585: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3586: l_t_rc_tab(l_n_cntr).batch_name,
3587: l_t_rc_tab(l_n_cntr).item_number);
3588: fnd_file.put_line(fnd_file.log,
3589: l_v_message_text);
3590: ELSE
3591: l_t_rc_tab(l_n_cntr).act_applied_amt2 := l_n_act_amnt_applied;
3592: END IF;

Line 3612: fnd_file.put_line(fnd_file.log,

3608: l_b_val_err := TRUE;
3609: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3610: l_t_rc_tab(l_n_cntr).batch_name,
3611: l_t_rc_tab(l_n_cntr).item_number);
3612: fnd_file.put_line(fnd_file.log,
3613: l_v_message_text);
3614: ELSE
3615: l_t_rc_tab(l_n_cntr).act_applied_amt3 := l_n_act_amnt_applied;
3616: END IF;

Line 3635: fnd_file.put_line(fnd_file.log,

3631: l_b_val_err := TRUE;
3632: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3633: l_t_rc_tab(l_n_cntr).batch_name,
3634: l_t_rc_tab(l_n_cntr).item_number);
3635: fnd_file.put_line(fnd_file.log,
3636: l_v_message_text);
3637: ELSE
3638: l_t_rc_tab(l_n_cntr).act_applied_amt4 := l_n_act_amnt_applied;
3639: END IF;

Line 3658: fnd_file.put_line(fnd_file.log,

3654: l_b_val_err := TRUE;
3655: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3656: l_t_rc_tab(l_n_cntr).batch_name,
3657: l_t_rc_tab(l_n_cntr).item_number);
3658: fnd_file.put_line(fnd_file.log,
3659: l_v_message_text);
3660: ELSE
3661: l_t_rc_tab(l_n_cntr).act_applied_amt5 := l_n_act_amnt_applied;
3662: END IF;

Line 3681: fnd_file.put_line(fnd_file.log,

3677: l_b_val_err := TRUE;
3678: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3679: l_t_rc_tab(l_n_cntr).batch_name,
3680: l_t_rc_tab(l_n_cntr).item_number);
3681: fnd_file.put_line(fnd_file.log,
3682: l_v_message_text);
3683: ELSE
3684: l_t_rc_tab(l_n_cntr).act_applied_amt6 := l_n_act_amnt_applied;
3685: END IF;

Line 3704: fnd_file.put_line(fnd_file.log,

3700: l_b_val_err := TRUE;
3701: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3702: l_t_rc_tab(l_n_cntr).batch_name,
3703: l_t_rc_tab(l_n_cntr).item_number);
3704: fnd_file.put_line(fnd_file.log,
3705: l_v_message_text);
3706: ELSE
3707: l_t_rc_tab(l_n_cntr).act_applied_amt7 := l_n_act_amnt_applied;
3708: END IF;

Line 3727: fnd_file.put_line(fnd_file.log,

3723: l_b_val_err := TRUE;
3724: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3725: l_t_rc_tab(l_n_cntr).batch_name,
3726: l_t_rc_tab(l_n_cntr).item_number);
3727: fnd_file.put_line(fnd_file.log,
3728: l_v_message_text);
3729: ELSE
3730: l_t_rc_tab(l_n_cntr).act_applied_amt8 := l_n_act_amnt_applied;
3731: END IF;

Line 3757: fnd_file.put_line(fnd_file.log,

3753: l_b_val_err := TRUE;
3754: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3755: l_t_rc_tab(l_n_cntr).batch_name,
3756: l_t_rc_tab(l_n_cntr).item_number);
3757: fnd_file.put_line(fnd_file.log,
3758: l_v_message_text);
3759: ELSE
3760: l_t_ro_tab(l_n_cntr1).act_applied_amt1 := l_n_act_amnt_applied;
3761: END IF;

Line 3781: fnd_file.put_line(fnd_file.log,

3777: l_b_val_err := TRUE;
3778: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3779: l_t_rc_tab(l_n_cntr).batch_name,
3780: l_t_rc_tab(l_n_cntr).item_number);
3781: fnd_file.put_line(fnd_file.log,
3782: l_v_message_text);
3783: ELSE
3784: l_t_ro_tab(l_n_cntr1).act_applied_amt2 := l_n_act_amnt_applied;
3785: END IF;

Line 3805: fnd_file.put_line(fnd_file.log,

3801: l_b_val_err := TRUE;
3802: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3803: l_t_rc_tab(l_n_cntr).batch_name,
3804: l_t_rc_tab(l_n_cntr).item_number);
3805: fnd_file.put_line(fnd_file.log,
3806: l_v_message_text);
3807: ELSE
3808: l_t_ro_tab(l_n_cntr1).act_applied_amt3 := l_n_act_amnt_applied;
3809: END IF;

Line 3829: fnd_file.put_line(fnd_file.log,

3825: l_b_val_err := TRUE;
3826: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3827: l_t_rc_tab(l_n_cntr).batch_name,
3828: l_t_rc_tab(l_n_cntr).item_number);
3829: fnd_file.put_line(fnd_file.log,
3830: l_v_message_text);
3831: ELSE
3832: l_t_ro_tab(l_n_cntr1).act_applied_amt4 := l_n_act_amnt_applied;
3833: END IF;

Line 3853: fnd_file.put_line(fnd_file.log,

3849: l_b_val_err := TRUE;
3850: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3851: l_t_rc_tab(l_n_cntr).batch_name,
3852: l_t_rc_tab(l_n_cntr).item_number);
3853: fnd_file.put_line(fnd_file.log,
3854: l_v_message_text);
3855: ELSE
3856: l_t_ro_tab(l_n_cntr1).act_applied_amt5 := l_n_act_amnt_applied;
3857: END IF;

Line 3877: fnd_file.put_line(fnd_file.log,

3873: l_b_val_err := TRUE;
3874: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3875: l_t_rc_tab(l_n_cntr).batch_name,
3876: l_t_rc_tab(l_n_cntr).item_number);
3877: fnd_file.put_line(fnd_file.log,
3878: l_v_message_text);
3879: ELSE
3880: l_t_ro_tab(l_n_cntr1).act_applied_amt6 := l_n_act_amnt_applied;
3881: END IF;

Line 3900: fnd_file.put_line(fnd_file.log,

3896: l_b_val_err := TRUE;
3897: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3898: l_t_rc_tab(l_n_cntr).batch_name,
3899: l_t_rc_tab(l_n_cntr).item_number);
3900: fnd_file.put_line(fnd_file.log,
3901: l_v_message_text);
3902: ELSE
3903: l_t_ro_tab(l_n_cntr1).act_applied_amt7 := l_n_act_amnt_applied;
3904: END IF;

Line 3923: fnd_file.put_line(fnd_file.log,

3919: l_b_val_err := TRUE;
3920: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
3921: l_t_rc_tab(l_n_cntr).batch_name,
3922: l_t_rc_tab(l_n_cntr).item_number);
3923: fnd_file.put_line(fnd_file.log,
3924: l_v_message_text);
3925: ELSE
3926: l_t_ro_tab(l_n_cntr1).act_applied_amt8 := l_n_act_amnt_applied;
3927: END IF;

Line 3984: fnd_file.put_line(fnd_file.log,

3980: END LOOP;
3981: END IF;
3982:
3983: IF l_t_rc_tab.COUNT = 0 THEN
3984: fnd_file.put_line(fnd_file.log,
3985: g_v_line_sep);
3986: END IF;
3987:
3988:

Line 3996: fnd_file.new_line(fnd_file.log);

3992: l_b_rec_succ := FALSE;
3993: IF l_t_rc_tab.COUNT > 0 THEN
3994: -- All erraneous records are deleted from PL/SQL table above, so l_t_rc_tab contains all success records.
3995: l_b_rec_succ := TRUE;
3996: fnd_file.new_line(fnd_file.log);
3997: fnd_file.put_line(fnd_file.log,
3998: g_v_line_sep);
3999: fnd_message.set_name('IGS',
4000: 'IGS_FI_REC_IMP_SUCC');

Line 3997: fnd_file.put_line(fnd_file.log,

3993: IF l_t_rc_tab.COUNT > 0 THEN
3994: -- All erraneous records are deleted from PL/SQL table above, so l_t_rc_tab contains all success records.
3995: l_b_rec_succ := TRUE;
3996: fnd_file.new_line(fnd_file.log);
3997: fnd_file.put_line(fnd_file.log,
3998: g_v_line_sep);
3999: fnd_message.set_name('IGS',
4000: 'IGS_FI_REC_IMP_SUCC');
4001: fnd_file.put_line(fnd_file.log,

Line 4001: fnd_file.put_line(fnd_file.log,

3997: fnd_file.put_line(fnd_file.log,
3998: g_v_line_sep);
3999: fnd_message.set_name('IGS',
4000: 'IGS_FI_REC_IMP_SUCC');
4001: fnd_file.put_line(fnd_file.log,
4002: fnd_message.get);
4003: fnd_file.put_line(fnd_file.log,
4004: g_v_line_sep);
4005: l_n_rec_cntr := 0;

Line 4003: fnd_file.put_line(fnd_file.log,

3999: fnd_message.set_name('IGS',
4000: 'IGS_FI_REC_IMP_SUCC');
4001: fnd_file.put_line(fnd_file.log,
4002: fnd_message.get);
4003: fnd_file.put_line(fnd_file.log,
4004: g_v_line_sep);
4005: l_n_rec_cntr := 0;
4006: FOR l_n_cntr IN l_t_rc_tab.FIRST..l_t_rc_tab.LAST LOOP
4007: IF l_t_rc_tab.EXISTS(l_n_cntr) THEN

Line 4041: fnd_file.new_line(fnd_file.log);

4037: log_line(g_v_label_gl_date,
4038: l_t_rc_tab(l_n_cntr).gl_date);
4039: log_line(g_v_label_adm_appl_num,
4040: l_t_rc_tab(l_n_cntr).adm_application_id);
4041: fnd_file.new_line(fnd_file.log);
4042:
4043: IF l_t_rc_tab(l_n_cntr).charge_cd1 IS NOT NULL THEN
4044: log_line(g_v_label_charge_code,
4045: l_t_rc_tab(l_n_cntr).charge_cd1);

Line 4050: fnd_file.new_line(fnd_file.log);

4046: log_line(g_v_label_bank_app_amt,
4047: l_t_rc_tab(l_n_cntr).applied_amt1);
4048: log_line(g_v_label_act_app_amt,
4049: l_t_rc_tab(l_n_cntr).act_applied_amt1);
4050: fnd_file.new_line(fnd_file.log);
4051: END IF;
4052:
4053: IF l_t_rc_tab(l_n_cntr).charge_cd2 IS NOT NULL THEN
4054: log_line(g_v_label_charge_code,

Line 4060: fnd_file.new_line(fnd_file.log);

4056: log_line(g_v_label_bank_app_amt,
4057: l_t_rc_tab(l_n_cntr).applied_amt2);
4058: log_line(g_v_label_act_app_amt,
4059: l_t_rc_tab(l_n_cntr).act_applied_amt2);
4060: fnd_file.new_line(fnd_file.log);
4061: END IF;
4062:
4063: IF l_t_rc_tab(l_n_cntr).charge_cd3 IS NOT NULL THEN
4064: log_line(g_v_label_charge_code,

Line 4070: fnd_file.new_line(fnd_file.log);

4066: log_line(g_v_label_bank_app_amt,
4067: l_t_rc_tab(l_n_cntr).applied_amt3);
4068: log_line(g_v_label_act_app_amt,
4069: l_t_rc_tab(l_n_cntr).act_applied_amt3);
4070: fnd_file.new_line(fnd_file.log);
4071: END IF;
4072:
4073: IF l_t_rc_tab(l_n_cntr).charge_cd4 IS NOT NULL THEN
4074: log_line(g_v_label_charge_code,

Line 4080: fnd_file.new_line(fnd_file.log);

4076: log_line(g_v_label_bank_app_amt,
4077: l_t_rc_tab(l_n_cntr).applied_amt4);
4078: log_line(g_v_label_act_app_amt,
4079: l_t_rc_tab(l_n_cntr).act_applied_amt4);
4080: fnd_file.new_line(fnd_file.log);
4081: END IF;
4082:
4083: IF l_t_rc_tab(l_n_cntr).charge_cd5 IS NOT NULL THEN
4084: log_line(g_v_label_charge_code,

Line 4090: fnd_file.new_line(fnd_file.log);

4086: log_line(g_v_label_bank_app_amt,
4087: l_t_rc_tab(l_n_cntr).applied_amt5);
4088: log_line(g_v_label_act_app_amt,
4089: l_t_rc_tab(l_n_cntr).act_applied_amt5);
4090: fnd_file.new_line(fnd_file.log);
4091: END IF;
4092:
4093: IF l_t_rc_tab(l_n_cntr).charge_cd6 IS NOT NULL THEN
4094: log_line(g_v_label_charge_code,

Line 4100: fnd_file.new_line(fnd_file.log);

4096: log_line(g_v_label_bank_app_amt,
4097: l_t_rc_tab(l_n_cntr).applied_amt6);
4098: log_line(g_v_label_act_app_amt,
4099: l_t_rc_tab(l_n_cntr).act_applied_amt6);
4100: fnd_file.new_line(fnd_file.log);
4101: END IF;
4102:
4103: IF l_t_rc_tab(l_n_cntr).charge_cd7 IS NOT NULL THEN
4104: log_line(g_v_label_charge_code,

Line 4110: fnd_file.new_line(fnd_file.log);

4106: log_line(g_v_label_bank_app_amt,
4107: l_t_rc_tab(l_n_cntr).applied_amt7);
4108: log_line(g_v_label_act_app_amt,
4109: l_t_rc_tab(l_n_cntr).act_applied_amt7);
4110: fnd_file.new_line(fnd_file.log);
4111: END IF;
4112:
4113: IF l_t_rc_tab(l_n_cntr).charge_cd8 IS NOT NULL THEN
4114: log_line(g_v_label_charge_code,

Line 4120: fnd_file.new_line(fnd_file.log);

4116: log_line(g_v_label_bank_app_amt,
4117: l_t_rc_tab(l_n_cntr).applied_amt8);
4118: log_line(g_v_label_act_app_amt,
4119: l_t_rc_tab(l_n_cntr).act_applied_amt8);
4120: fnd_file.new_line(fnd_file.log);
4121: END IF;
4122:
4123: l_n_cntr1 := 0;
4124: IF l_t_ro_tab.COUNT > 0 THEN

Line 4135: fnd_file.new_line(fnd_file.log);

4131: log_line(g_v_label_bank_app_amt,
4132: l_t_ro_tab(l_n_cntr1).applied_amt1);
4133: log_line(g_v_label_act_app_amt,
4134: l_t_ro_tab(l_n_cntr1).act_applied_amt1);
4135: fnd_file.new_line(fnd_file.log);
4136: END IF;
4137:
4138: IF l_t_ro_tab(l_n_cntr1).charge_cd2 IS NOT NULL THEN
4139: log_line(g_v_label_charge_code,

Line 4145: fnd_file.new_line(fnd_file.log);

4141: log_line(g_v_label_bank_app_amt,
4142: l_t_ro_tab(l_n_cntr1).applied_amt2);
4143: log_line(g_v_label_act_app_amt,
4144: l_t_ro_tab(l_n_cntr1).act_applied_amt2);
4145: fnd_file.new_line(fnd_file.log);
4146: END IF;
4147:
4148: IF l_t_ro_tab(l_n_cntr1).charge_cd3 IS NOT NULL THEN
4149: log_line(g_v_label_charge_code,

Line 4155: fnd_file.new_line(fnd_file.log);

4151: log_line(g_v_label_bank_app_amt,
4152: l_t_ro_tab(l_n_cntr1).applied_amt3);
4153: log_line(g_v_label_act_app_amt,
4154: l_t_ro_tab(l_n_cntr1).act_applied_amt3);
4155: fnd_file.new_line(fnd_file.log);
4156: END IF;
4157:
4158: IF l_t_ro_tab(l_n_cntr1).charge_cd4 IS NOT NULL THEN
4159: log_line(g_v_label_charge_code,

Line 4165: fnd_file.new_line(fnd_file.log);

4161: log_line(g_v_label_bank_app_amt,
4162: l_t_ro_tab(l_n_cntr1).applied_amt4);
4163: log_line(g_v_label_act_app_amt,
4164: l_t_ro_tab(l_n_cntr1).act_applied_amt4);
4165: fnd_file.new_line(fnd_file.log);
4166: END IF;
4167:
4168: IF l_t_ro_tab(l_n_cntr1).charge_cd5 IS NOT NULL THEN
4169: log_line(g_v_label_charge_code,

Line 4175: fnd_file.new_line(fnd_file.log);

4171: log_line(g_v_label_bank_app_amt,
4172: l_t_ro_tab(l_n_cntr1).applied_amt5);
4173: log_line(g_v_label_act_app_amt,
4174: l_t_ro_tab(l_n_cntr1).act_applied_amt5);
4175: fnd_file.new_line(fnd_file.log);
4176: END IF;
4177:
4178: IF l_t_ro_tab(l_n_cntr1).charge_cd6 IS NOT NULL THEN
4179: log_line(g_v_label_charge_code,

Line 4185: fnd_file.new_line(fnd_file.log);

4181: log_line(g_v_label_bank_app_amt,
4182: l_t_ro_tab(l_n_cntr1).applied_amt6);
4183: log_line(g_v_label_act_app_amt,
4184: l_t_ro_tab(l_n_cntr1).act_applied_amt6);
4185: fnd_file.new_line(fnd_file.log);
4186: END IF;
4187:
4188: IF l_t_ro_tab(l_n_cntr1).charge_cd7 IS NOT NULL THEN
4189: log_line(g_v_label_charge_code,

Line 4195: fnd_file.new_line(fnd_file.log);

4191: log_line(g_v_label_bank_app_amt,
4192: l_t_ro_tab(l_n_cntr1).applied_amt7);
4193: log_line(g_v_label_act_app_amt,
4194: l_t_ro_tab(l_n_cntr1).act_applied_amt7);
4195: fnd_file.new_line(fnd_file.log);
4196: END IF;
4197:
4198: IF l_t_ro_tab(l_n_cntr1).charge_cd8 IS NOT NULL THEN
4199: log_line(g_v_label_charge_code,

Line 4205: fnd_file.new_line(fnd_file.log);

4201: log_line(g_v_label_bank_app_amt,
4202: l_t_ro_tab(l_n_cntr1).applied_amt8);
4203: log_line(g_v_label_act_app_amt,
4204: l_t_ro_tab(l_n_cntr1).act_applied_amt8);
4205: fnd_file.new_line(fnd_file.log);
4206: END IF;
4207: END IF; -- End if for l_t_ro_tab(l_n_cntr1).receipt_number = l_n_cntr
4208: END IF; -- End if for l_t_ro_tab.EXISTS(l_n_cntr1)
4209: END LOOP;

Line 4215: fnd_file.put_line(fnd_file.log,g_v_holds_message);

4211:
4212: -- If holds could not be released after credit creation,
4213: -- display message conveying the same.
4214: IF l_t_rc_tab(l_n_cntr).holds_released_yn = 'N' THEN
4215: fnd_file.put_line(fnd_file.log,g_v_holds_message);
4216: fnd_file.new_line(fnd_file.log);
4217: END IF;
4218:
4219: END IF; -- End if for l_t_rc_tab(l_n_cntr).record_status = g_v_success

Line 4216: fnd_file.new_line(fnd_file.log);

4212: -- If holds could not be released after credit creation,
4213: -- display message conveying the same.
4214: IF l_t_rc_tab(l_n_cntr).holds_released_yn = 'N' THEN
4215: fnd_file.put_line(fnd_file.log,g_v_holds_message);
4216: fnd_file.new_line(fnd_file.log);
4217: END IF;
4218:
4219: END IF; -- End if for l_t_rc_tab(l_n_cntr).record_status = g_v_success
4220:

Line 4232: fnd_file.new_line(fnd_file.log,2);

4228: END LOOP;
4229: END IF;
4230:
4231: -- Log the final summary of transactions
4232: fnd_file.new_line(fnd_file.log,2);
4233: log_line(g_v_label_num_rec,
4234: NVL(l_n_rec_cntr,0));
4235: log_line(g_v_label_cur_rec,
4236: NVL(l_n_rec_amnt_prc,0));

Line 4237: fnd_file.put_line(fnd_file.log,

4233: log_line(g_v_label_num_rec,
4234: NVL(l_n_rec_cntr,0));
4235: log_line(g_v_label_cur_rec,
4236: NVL(l_n_rec_amnt_prc,0));
4237: fnd_file.put_line(fnd_file.log,
4238: g_v_line_sep);
4239:
4240: l_n_rec_cntr := 0;
4241: l_n_rec_amnt_prc := 0;

Line 4492: fnd_file.put_line(fnd_file.log,

4488: -- If records exist then log the message than the Records have been rolled back
4489: IF g_b_rec_exists THEN
4490: fnd_message.set_name('IGS',
4491: 'IGS_FI_PRC_TEST_RUN');
4492: fnd_file.put_line(fnd_file.log,
4493: fnd_message.get);
4494: ELSE
4495:
4496: -- Else log no data found

Line 4499: fnd_file.put_line(fnd_file.log,

4495:
4496: -- Else log no data found
4497: fnd_message.set_name('IGS',
4498: 'IGS_GE_NO_DATA_FOUND');
4499: fnd_file.put_line(fnd_file.log,
4500: fnd_message.get);
4501: END IF;
4502: ELSE
4503:

Line 4511: fnd_file.put_line(fnd_file.log,

4507: ELSE
4508: -- Elsif records do not exist, then log no data found
4509: fnd_message.set_name('IGS',
4510: 'IGS_GE_NO_DATA_FOUND');
4511: fnd_file.put_line(fnd_file.log,
4512: fnd_message.get);
4513: END IF;
4514: END IF;
4515:

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

4522: WHEN e_resource_busy THEN
4523: ROLLBACK TO SP_LOCKBOX_MAIN;
4524: retcode := 2;
4525: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');
4526: fnd_file.put_line(fnd_file.log,fnd_message.get());
4527: fnd_file.new_line(fnd_file.log);
4528: WHEN OTHERS THEN
4529: -- Handling the When Others Condition
4530: retcode := 2;

Line 4527: fnd_file.new_line(fnd_file.log);

4523: ROLLBACK TO SP_LOCKBOX_MAIN;
4524: retcode := 2;
4525: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');
4526: fnd_file.put_line(fnd_file.log,fnd_message.get());
4527: fnd_file.new_line(fnd_file.log);
4528: WHEN OTHERS THEN
4529: -- Handling the When Others Condition
4530: retcode := 2;
4531: ROLLBACK TO SP_LOCKBOX_MAIN;

Line 4534: fnd_file.put_line(fnd_file.log,

4530: retcode := 2;
4531: ROLLBACK TO SP_LOCKBOX_MAIN;
4532: fnd_message.set_name('IGS',
4533: 'IGS_GE_UNHANDLED_EXCEPTION');
4534: fnd_file.put_line(fnd_file.log,
4535: fnd_message.get||' - '||sqlerrm);
4536: END import_interface_lockbox;
4537:
4538: PROCEDURE import_error_lockbox( errbuf OUT NOCOPY VARCHAR2,

Line 4597: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

4593: -- If Test Run is Y, log generic message saying that all transactions are rolled back
4594: IF( p_v_test_run = 'Y' ) THEN
4595: ROLLBACK TO SP_LOCKBOX_ERROR;
4596: fnd_message.set_name('IGS', 'IGS_FI_PRC_TEST_RUN');
4597: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
4598: ELSE
4599: -- If Test Run is N, commit.
4600: COMMIT;
4601: END IF;

Line 4605: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

4601: END IF;
4602: ELSE
4603: -- If no records found for processing log the message saying so.
4604: fnd_message.set_name('IGS', 'IGS_GE_NO_DATA_FOUND');
4605: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
4606: END IF;
4607:
4608: l_t_err_rec_tab.DELETE;
4609:

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

4612: WHEN e_resource_busy THEN
4613: ROLLBACK TO SP_LOCKBOX_ERROR;
4614: retcode := 2;
4615: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');
4616: fnd_file.put_line(fnd_file.log,fnd_message.get());
4617: fnd_file.new_line(fnd_file.log);
4618:
4619: -- Handle Other Exceptions
4620: WHEN OTHERS THEN

Line 4617: fnd_file.new_line(fnd_file.log);

4613: ROLLBACK TO SP_LOCKBOX_ERROR;
4614: retcode := 2;
4615: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');
4616: fnd_file.put_line(fnd_file.log,fnd_message.get());
4617: fnd_file.new_line(fnd_file.log);
4618:
4619: -- Handle Other Exceptions
4620: WHEN OTHERS THEN
4621: retcode := 2;

Line 4624: fnd_file.put_line(fnd_file.LOG, fnd_message.get || ' - ' || SQLERRM);

4620: WHEN OTHERS THEN
4621: retcode := 2;
4622: ROLLBACK TO SP_LOCKBOX_ERROR;
4623: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
4624: fnd_file.put_line(fnd_file.LOG, fnd_message.get || ' - ' || SQLERRM);
4625: END import_error_lockbox;
4626: END igs_fi_prc_lockbox;