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_MESSAGE

Line 230: fnd_message.get_string('IGS',

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:
234: g_v_test_run_val := igs_fi_gen_gl.get_lkp_meaning('YES_NO',

Line 256: fnd_message.set_name('IGS',

252:
253: -- If Manage Accounts is NULL or is OTHER then error has to be raised
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;

Line 259: fnd_message.get);

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:
263: l_v_message_name := null;

Line 269: fnd_message.set_name('IGS',

265: p_v_curr_desc => l_v_curr_desc,
266: p_v_message_name => l_v_message_text);
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;

Line 272: fnd_message.get);

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
276: OPEN cur_lockbox(p_v_lockbox_name,

Line 281: fnd_message.set_name('IGS',

277: 'N');
278: FETCH cur_lockbox INTO g_v_gl_date_source;
279: IF cur_lockbox%NOTFOUND THEN
280: l_b_val_parm := FALSE;
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,

Line 283: fnd_message.set_token('LOCKBOX_NAME',

279: IF cur_lockbox%NOTFOUND THEN
280: l_b_val_parm := FALSE;
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;

Line 286: fnd_message.get);

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:
290: -- If the gl date source is user supplied and gl_date is not passed as input

Line 295: fnd_message.set_name('IGS',

291: -- then error needs to be raised.
292: IF g_v_gl_date_source = g_v_user_supp_dt THEN
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

Line 298: fnd_message.get);

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
302: igs_fi_gen_gl.get_period_status_for_date(p_d_date => p_d_gl_date,

Line 307: fnd_message.set_name('IGS',

303: p_v_closing_status => l_v_closing_status,
304: p_v_message_name => l_v_message_name);
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

Line 310: fnd_message.get);

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',
314: 'IGS_FI_INVALID_GL_DATE');

Line 313: fnd_message.set_name('IGS',

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',
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,

Line 315: fnd_message.set_token('GL_DATE',

311: ELSE
312: IF l_v_closing_status NOT IN ('O','F') THEN
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;

Line 318: fnd_message.get);

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;
322: END IF;

Line 328: fnd_message.set_name('IGS',

324:
325: -- Log message to the user that the GL Date has been disregarded because the
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;

Line 331: fnd_message.get);

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:
335: -- validate for Test Run

Line 338: fnd_message.set_name('IGS',

334:
335: -- validate for Test Run
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;

Line 341: fnd_message.get);

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,
345: g_v_line_sep);

Line 570: fnd_message.set_name('IGS','IGS_FI_INVALID_RECORD_ID');

566:
567: -- If the record type meaning is NOVALUE, then there is an error and the set of Interface records should be marked as
568: -- Error
569: IF l_v_rec_type_meaning = g_v_noval THEN
570: fnd_message.set_name('IGS','IGS_FI_INVALID_RECORD_ID');
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);

Line 571: fnd_message.set_token('RECORD_IDENTIFIER',

567: -- If the record type meaning is NOVALUE, then there is an error and the set of Interface records should be marked as
568: -- Error
569: IF l_v_rec_type_meaning = g_v_noval THEN
570: fnd_message.set_name('IGS','IGS_FI_INVALID_RECORD_ID');
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,

Line 573: fnd_message.set_token('LOCKBOX_NAME',

569: IF l_v_rec_type_meaning = g_v_noval THEN
570: fnd_message.set_name('IGS','IGS_FI_INVALID_RECORD_ID');
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;

Line 576: fnd_message.get);

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:
580: -- Check if Batch Headers exist. Will be used in the next step. This has been kept to improve the

Line 606: fnd_message.set_name('IGS','IGS_FI_INVALID_RECORD_ID');

602:
603: -- If the record type meaning is NOVALUE, then there is an error and the set of Interface records should be marked as
604: -- Error
605: IF l_v_rec_type_meaning = g_v_noval THEN
606: fnd_message.set_name('IGS','IGS_FI_INVALID_RECORD_ID');
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);

Line 607: fnd_message.set_token('RECORD_IDENTIFIER',

603: -- If the record type meaning is NOVALUE, then there is an error and the set of Interface records should be marked as
604: -- Error
605: IF l_v_rec_type_meaning = g_v_noval THEN
606: fnd_message.set_name('IGS','IGS_FI_INVALID_RECORD_ID');
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,

Line 609: fnd_message.set_token('LOCKBOX_NAME',

605: IF l_v_rec_type_meaning = g_v_noval THEN
606: fnd_message.set_name('IGS','IGS_FI_INVALID_RECORD_ID');
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;

Line 612: fnd_message.get);

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:
616: -- If the record type meaning is either Receipt/Receipt Overflow/Novalue, then add the record to the

Line 801: fnd_message.set_name('IGS',

797: -- Log the error in the log file. This is a type 1 validation error.
798: IF ((l_t_th_tab(l_n_cntr).transmission_record_count IS NOT NULL) AND
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;

Line 804: fnd_message.get);

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
808: -- receipt amount, then this error message is logged in the log file.

Line 812: fnd_message.set_name('IGS',

808: -- receipt amount, then this error message is logged in the log file.
809: IF ((l_t_th_tab(l_n_cntr).transmission_amt IS NOT NULL) AND
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;

Line 815: fnd_message.get);

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;
819: END IF;

Line 839: fnd_message.set_name('IGS',

835: -- equal to the lockbox batch count.
836: IF l_n_bh_cntr > 0 THEN
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;

Line 842: fnd_message.get);

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:
846: -- If there are no batch headers, then if there are any records in the receipts

Line 878: fnd_message.set_name('IGS',

874: ELSE
875:
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;

Line 881: fnd_message.get);

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;
885: ELSE

Line 887: fnd_message.set_name('IGS',

883: END IF;
884: END LOOP;
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;

Line 890: fnd_message.get);

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,
894: -- then it is an error condition

Line 898: fnd_message.set_name('IGS',

894: -- then it is an error condition
895: IF ((l_t_distinct_batch.COUNT <> l_t_lh_tab(l_n_cntr).lockbox_batch_count) AND
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;

Line 901: fnd_message.get);

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;
905: END IF;

Line 912: fnd_message.set_name('IGS',

908: -- log this as error message
909: IF ((l_t_lh_tab(l_n_cntr).lockbox_amt IS NOT NULL) AND
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;

Line 915: fnd_message.get);

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
919: -- error in the log file

Line 923: fnd_message.set_name('IGS',

919: -- error in the log file
920: IF ((l_t_lh_tab(l_n_cntr).lockbox_record_count IS NOT NULL) AND
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;

Line 926: fnd_message.get);

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;
930: END IF;

Line 950: fnd_message.set_name('IGS',

946: IF ((l_t_bh_tab(l_n_cntr1).batch_name IS NOT NULL) AND
947: (l_t_bh_tab(l_n_cntr1).batch_name = l_t_bh_tab(l_n_cntr).batch_name) AND
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;

Line 953: fnd_message.get);

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;
957: END LOOP;

Line 994: fnd_message.set_name('IGS',

990: IF l_n_batch_count > 0 THEN
991: IF ((l_n_batch_count <> l_t_bh_tab(l_n_cntr).batch_record_count) AND
992: (l_t_bh_tab(l_n_cntr).batch_record_count IS NOT NULL)) THEN
993: l_v_val_status := 'E';
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,

Line 996: fnd_message.set_token('BATCH_NAME',

992: (l_t_bh_tab(l_n_cntr).batch_record_count IS NOT NULL)) THEN
993: l_v_val_status := 'E';
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;

Line 999: fnd_message.get);

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:
1003: -- If there are no records in the receipts PL/SQL table for the batch name

Line 1006: fnd_message.set_name('IGS',

1002:
1003: -- If there are no records in the receipts PL/SQL table for the batch name
1004: -- then this is an error condition and log this in the log file
1005: l_v_val_status := 'E';
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,

Line 1008: fnd_message.set_token('BATCH_NAME',

1004: -- then this is an error condition and log this in the log file
1005: l_v_val_status := 'E';
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;

Line 1011: fnd_message.get);

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
1015: -- log this in the log file

Line 1019: fnd_message.set_name('IGS',

1015: -- log this in the log file
1016: IF ((l_n_batch_amount <> l_t_bh_tab(l_n_cntr).batch_amt) AND
1017: (l_t_bh_tab(l_n_cntr).batch_amt IS NOT NULL)) THEN
1018: l_v_val_status := 'E';
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,

Line 1021: fnd_message.set_token('BATCH_NAME',

1017: (l_t_bh_tab(l_n_cntr).batch_amt IS NOT NULL)) THEN
1018: l_v_val_status := 'E';
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;

Line 1024: fnd_message.get);

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;
1028: l_n_batch_amount := 0;

Line 1062: fnd_message.set_name('IGS',

1058:
1059: -- If the batch header record match does not happen then log the message in the log file.
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;

Line 1065: fnd_message.get);

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:
1069: -- If the item number of the receipt record is null, then this has to be logged in the log file

Line 1073: fnd_message.set_name('IGS',

1069: -- If the item number of the receipt record is null, then this has to be logged in the log file
1070: -- as error
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;

Line 1076: fnd_message.get);

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
1080: IF ((l_t_rc_tab(l_n_cntr).receipt_amt <0) OR (l_t_rc_tab(l_n_cntr).receipt_amt IS NULL)) THEN

Line 1082: fnd_message.set_name('IGS',

1078:
1079: -- If the receipt amount is less than 0 or the receipt amount is null, then log this in the log file
1080: IF ((l_t_rc_tab(l_n_cntr).receipt_amt <0) OR (l_t_rc_tab(l_n_cntr).receipt_amt IS NULL)) THEN
1081: l_v_val_status := 'E';
1082: fnd_message.set_name('IGS',
1083: 'IGS_FI_REC_AMT_NOT_VALID');
1084: fnd_message.set_token('ITEM_NUMBER',
1085: l_t_rc_tab(l_n_cntr).item_number);
1086: fnd_message.set_token('BATCH_NAME',

Line 1084: fnd_message.set_token('ITEM_NUMBER',

1080: IF ((l_t_rc_tab(l_n_cntr).receipt_amt <0) OR (l_t_rc_tab(l_n_cntr).receipt_amt IS NULL)) THEN
1081: l_v_val_status := 'E';
1082: fnd_message.set_name('IGS',
1083: 'IGS_FI_REC_AMT_NOT_VALID');
1084: fnd_message.set_token('ITEM_NUMBER',
1085: l_t_rc_tab(l_n_cntr).item_number);
1086: fnd_message.set_token('BATCH_NAME',
1087: l_t_rc_tab(l_n_cntr).batch_name);
1088: fnd_message.set_token('LOCKBOX_NAME',

Line 1086: fnd_message.set_token('BATCH_NAME',

1082: fnd_message.set_name('IGS',
1083: 'IGS_FI_REC_AMT_NOT_VALID');
1084: fnd_message.set_token('ITEM_NUMBER',
1085: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 1088: fnd_message.set_token('LOCKBOX_NAME',

1084: fnd_message.set_token('ITEM_NUMBER',
1085: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 1091: fnd_message.get);

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
1095: IF l_t_rc_tab(l_n_cntr).party_number IS NULL THEN

Line 1097: fnd_message.set_name('IGS',

1093:
1094: -- If the party number in the receipt record is null, then log this as an error in the log file
1095: IF l_t_rc_tab(l_n_cntr).party_number IS NULL THEN
1096: l_v_val_status := 'E';
1097: fnd_message.set_name('IGS',
1098: 'IGS_FI_REC_PARTY_MISSING');
1099: fnd_message.set_token('ITEM_NUMBER',
1100: l_t_rc_tab(l_n_cntr).item_number);
1101: fnd_message.set_token('BATCH_NAME',

Line 1099: fnd_message.set_token('ITEM_NUMBER',

1095: IF l_t_rc_tab(l_n_cntr).party_number IS NULL THEN
1096: l_v_val_status := 'E';
1097: fnd_message.set_name('IGS',
1098: 'IGS_FI_REC_PARTY_MISSING');
1099: fnd_message.set_token('ITEM_NUMBER',
1100: l_t_rc_tab(l_n_cntr).item_number);
1101: fnd_message.set_token('BATCH_NAME',
1102: l_t_rc_tab(l_n_cntr).batch_name);
1103: fnd_message.set_token('LOCKBOX_NAME',

Line 1101: fnd_message.set_token('BATCH_NAME',

1097: fnd_message.set_name('IGS',
1098: 'IGS_FI_REC_PARTY_MISSING');
1099: fnd_message.set_token('ITEM_NUMBER',
1100: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 1103: fnd_message.set_token('LOCKBOX_NAME',

1099: fnd_message.set_token('ITEM_NUMBER',
1100: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 1106: fnd_message.get);

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
1110: -- the receipts records at the batch level(if batch name is provided) or at the lockbox level.

Line 1143: fnd_message.set_name('IGS',

1139: END IF;
1140:
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;

Line 1146: fnd_message.get);

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)
1150: -- has the charge code provided but the corresponding applied amount not provided

Line 1211: fnd_message.set_name('IGS',

1207: END IF;
1208:
1209: IF NOT l_b_chg_amt_match THEN
1210: l_v_val_status := 'E';
1211: fnd_message.set_name('IGS',
1212: 'IGS_FI_REC_CHG_APPL_MISSING');
1213: fnd_message.set_token('ITEM_NUMBER',
1214: l_t_rc_tab(l_n_cntr).item_number);
1215: fnd_message.set_token('BATCH_NAME',

Line 1213: fnd_message.set_token('ITEM_NUMBER',

1209: IF NOT l_b_chg_amt_match THEN
1210: l_v_val_status := 'E';
1211: fnd_message.set_name('IGS',
1212: 'IGS_FI_REC_CHG_APPL_MISSING');
1213: fnd_message.set_token('ITEM_NUMBER',
1214: l_t_rc_tab(l_n_cntr).item_number);
1215: fnd_message.set_token('BATCH_NAME',
1216: l_t_rc_tab(l_n_cntr).batch_name);
1217: fnd_message.set_token('LOCKBOX_NAME',

Line 1215: fnd_message.set_token('BATCH_NAME',

1211: fnd_message.set_name('IGS',
1212: 'IGS_FI_REC_CHG_APPL_MISSING');
1213: fnd_message.set_token('ITEM_NUMBER',
1214: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 1217: fnd_message.set_token('LOCKBOX_NAME',

1213: fnd_message.set_token('ITEM_NUMBER',
1214: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 1220: fnd_message.get);

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
1224: -- for the receipt record

Line 1227: fnd_message.set_name('IGS',

1223: -- The following logic checks for the negative amount for the Charge Amount
1224: -- for the receipt record
1225: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt1,0) < 0 THEN
1226: l_v_val_status := 'E';
1227: fnd_message.set_name('IGS',
1228: 'IGS_FI_CHG_AMT_NEG');
1229: fnd_message.set_token('ITEM_NUMBER',
1230: l_t_rc_tab(l_n_cntr).item_number);
1231: fnd_message.set_token('BATCH_NAME',

Line 1229: fnd_message.set_token('ITEM_NUMBER',

1225: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt1,0) < 0 THEN
1226: l_v_val_status := 'E';
1227: fnd_message.set_name('IGS',
1228: 'IGS_FI_CHG_AMT_NEG');
1229: fnd_message.set_token('ITEM_NUMBER',
1230: l_t_rc_tab(l_n_cntr).item_number);
1231: fnd_message.set_token('BATCH_NAME',
1232: l_t_rc_tab(l_n_cntr).batch_name);
1233: fnd_message.set_token('LOCKBOX_NAME',

Line 1231: fnd_message.set_token('BATCH_NAME',

1227: fnd_message.set_name('IGS',
1228: 'IGS_FI_CHG_AMT_NEG');
1229: fnd_message.set_token('ITEM_NUMBER',
1230: l_t_rc_tab(l_n_cntr).item_number);
1231: fnd_message.set_token('BATCH_NAME',
1232: l_t_rc_tab(l_n_cntr).batch_name);
1233: fnd_message.set_token('LOCKBOX_NAME',
1234: l_t_rc_tab(l_n_cntr).lockbox_name);
1235: fnd_message.set_token('CHARGE_CODE',

Line 1233: fnd_message.set_token('LOCKBOX_NAME',

1229: fnd_message.set_token('ITEM_NUMBER',
1230: l_t_rc_tab(l_n_cntr).item_number);
1231: fnd_message.set_token('BATCH_NAME',
1232: l_t_rc_tab(l_n_cntr).batch_name);
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,

Line 1235: fnd_message.set_token('CHARGE_CODE',

1231: fnd_message.set_token('BATCH_NAME',
1232: l_t_rc_tab(l_n_cntr).batch_name);
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;

Line 1238: fnd_message.get);

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
1242: l_v_val_status := 'E';

Line 1243: fnd_message.set_name('IGS',

1239: END IF;
1240:
1241: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt2,0) < 0 THEN
1242: l_v_val_status := 'E';
1243: fnd_message.set_name('IGS',
1244: 'IGS_FI_CHG_AMT_NEG');
1245: fnd_message.set_token('ITEM_NUMBER',
1246: l_t_rc_tab(l_n_cntr).item_number);
1247: fnd_message.set_token('BATCH_NAME',

Line 1245: fnd_message.set_token('ITEM_NUMBER',

1241: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt2,0) < 0 THEN
1242: l_v_val_status := 'E';
1243: fnd_message.set_name('IGS',
1244: 'IGS_FI_CHG_AMT_NEG');
1245: fnd_message.set_token('ITEM_NUMBER',
1246: l_t_rc_tab(l_n_cntr).item_number);
1247: fnd_message.set_token('BATCH_NAME',
1248: l_t_rc_tab(l_n_cntr).batch_name);
1249: fnd_message.set_token('LOCKBOX_NAME',

Line 1247: fnd_message.set_token('BATCH_NAME',

1243: fnd_message.set_name('IGS',
1244: 'IGS_FI_CHG_AMT_NEG');
1245: fnd_message.set_token('ITEM_NUMBER',
1246: l_t_rc_tab(l_n_cntr).item_number);
1247: fnd_message.set_token('BATCH_NAME',
1248: l_t_rc_tab(l_n_cntr).batch_name);
1249: fnd_message.set_token('LOCKBOX_NAME',
1250: l_t_rc_tab(l_n_cntr).lockbox_name);
1251: fnd_message.set_token('CHARGE_CODE',

Line 1249: fnd_message.set_token('LOCKBOX_NAME',

1245: fnd_message.set_token('ITEM_NUMBER',
1246: l_t_rc_tab(l_n_cntr).item_number);
1247: fnd_message.set_token('BATCH_NAME',
1248: l_t_rc_tab(l_n_cntr).batch_name);
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,

Line 1251: fnd_message.set_token('CHARGE_CODE',

1247: fnd_message.set_token('BATCH_NAME',
1248: l_t_rc_tab(l_n_cntr).batch_name);
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;

Line 1254: fnd_message.get);

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
1258: l_v_val_status := 'E';

Line 1259: fnd_message.set_name('IGS',

1255: END IF;
1256:
1257: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt3,0) < 0 THEN
1258: l_v_val_status := 'E';
1259: fnd_message.set_name('IGS',
1260: 'IGS_FI_CHG_AMT_NEG');
1261: fnd_message.set_token('ITEM_NUMBER',
1262: l_t_rc_tab(l_n_cntr).item_number);
1263: fnd_message.set_token('BATCH_NAME',

Line 1261: fnd_message.set_token('ITEM_NUMBER',

1257: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt3,0) < 0 THEN
1258: l_v_val_status := 'E';
1259: fnd_message.set_name('IGS',
1260: 'IGS_FI_CHG_AMT_NEG');
1261: fnd_message.set_token('ITEM_NUMBER',
1262: l_t_rc_tab(l_n_cntr).item_number);
1263: fnd_message.set_token('BATCH_NAME',
1264: l_t_rc_tab(l_n_cntr).batch_name);
1265: fnd_message.set_token('LOCKBOX_NAME',

Line 1263: fnd_message.set_token('BATCH_NAME',

1259: fnd_message.set_name('IGS',
1260: 'IGS_FI_CHG_AMT_NEG');
1261: fnd_message.set_token('ITEM_NUMBER',
1262: l_t_rc_tab(l_n_cntr).item_number);
1263: fnd_message.set_token('BATCH_NAME',
1264: l_t_rc_tab(l_n_cntr).batch_name);
1265: fnd_message.set_token('LOCKBOX_NAME',
1266: l_t_rc_tab(l_n_cntr).lockbox_name);
1267: fnd_message.set_token('CHARGE_CODE',

Line 1265: fnd_message.set_token('LOCKBOX_NAME',

1261: fnd_message.set_token('ITEM_NUMBER',
1262: l_t_rc_tab(l_n_cntr).item_number);
1263: fnd_message.set_token('BATCH_NAME',
1264: l_t_rc_tab(l_n_cntr).batch_name);
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,

Line 1267: fnd_message.set_token('CHARGE_CODE',

1263: fnd_message.set_token('BATCH_NAME',
1264: l_t_rc_tab(l_n_cntr).batch_name);
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;

Line 1270: fnd_message.get);

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
1274: l_v_val_status := 'E';

Line 1275: fnd_message.set_name('IGS',

1271: END IF;
1272:
1273: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt4,0) < 0 THEN
1274: l_v_val_status := 'E';
1275: fnd_message.set_name('IGS',
1276: 'IGS_FI_CHG_AMT_NEG');
1277: fnd_message.set_token('ITEM_NUMBER',
1278: l_t_rc_tab(l_n_cntr).item_number);
1279: fnd_message.set_token('BATCH_NAME',

Line 1277: fnd_message.set_token('ITEM_NUMBER',

1273: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt4,0) < 0 THEN
1274: l_v_val_status := 'E';
1275: fnd_message.set_name('IGS',
1276: 'IGS_FI_CHG_AMT_NEG');
1277: fnd_message.set_token('ITEM_NUMBER',
1278: l_t_rc_tab(l_n_cntr).item_number);
1279: fnd_message.set_token('BATCH_NAME',
1280: l_t_rc_tab(l_n_cntr).batch_name);
1281: fnd_message.set_token('LOCKBOX_NAME',

Line 1279: fnd_message.set_token('BATCH_NAME',

1275: fnd_message.set_name('IGS',
1276: 'IGS_FI_CHG_AMT_NEG');
1277: fnd_message.set_token('ITEM_NUMBER',
1278: l_t_rc_tab(l_n_cntr).item_number);
1279: fnd_message.set_token('BATCH_NAME',
1280: l_t_rc_tab(l_n_cntr).batch_name);
1281: fnd_message.set_token('LOCKBOX_NAME',
1282: l_t_rc_tab(l_n_cntr).lockbox_name);
1283: fnd_message.set_token('CHARGE_CODE',

Line 1281: fnd_message.set_token('LOCKBOX_NAME',

1277: fnd_message.set_token('ITEM_NUMBER',
1278: l_t_rc_tab(l_n_cntr).item_number);
1279: fnd_message.set_token('BATCH_NAME',
1280: l_t_rc_tab(l_n_cntr).batch_name);
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,

Line 1283: fnd_message.set_token('CHARGE_CODE',

1279: fnd_message.set_token('BATCH_NAME',
1280: l_t_rc_tab(l_n_cntr).batch_name);
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;

Line 1286: fnd_message.get);

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
1290: l_v_val_status := 'E';

Line 1291: fnd_message.set_name('IGS',

1287: END IF;
1288:
1289: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt5,0) < 0 THEN
1290: l_v_val_status := 'E';
1291: fnd_message.set_name('IGS',
1292: 'IGS_FI_CHG_AMT_NEG');
1293: fnd_message.set_token('ITEM_NUMBER',
1294: l_t_rc_tab(l_n_cntr).item_number);
1295: fnd_message.set_token('BATCH_NAME',

Line 1293: fnd_message.set_token('ITEM_NUMBER',

1289: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt5,0) < 0 THEN
1290: l_v_val_status := 'E';
1291: fnd_message.set_name('IGS',
1292: 'IGS_FI_CHG_AMT_NEG');
1293: fnd_message.set_token('ITEM_NUMBER',
1294: l_t_rc_tab(l_n_cntr).item_number);
1295: fnd_message.set_token('BATCH_NAME',
1296: l_t_rc_tab(l_n_cntr).batch_name);
1297: fnd_message.set_token('LOCKBOX_NAME',

Line 1295: fnd_message.set_token('BATCH_NAME',

1291: fnd_message.set_name('IGS',
1292: 'IGS_FI_CHG_AMT_NEG');
1293: fnd_message.set_token('ITEM_NUMBER',
1294: l_t_rc_tab(l_n_cntr).item_number);
1295: fnd_message.set_token('BATCH_NAME',
1296: l_t_rc_tab(l_n_cntr).batch_name);
1297: fnd_message.set_token('LOCKBOX_NAME',
1298: l_t_rc_tab(l_n_cntr).lockbox_name);
1299: fnd_message.set_token('CHARGE_CODE',

Line 1297: fnd_message.set_token('LOCKBOX_NAME',

1293: fnd_message.set_token('ITEM_NUMBER',
1294: l_t_rc_tab(l_n_cntr).item_number);
1295: fnd_message.set_token('BATCH_NAME',
1296: l_t_rc_tab(l_n_cntr).batch_name);
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,

Line 1299: fnd_message.set_token('CHARGE_CODE',

1295: fnd_message.set_token('BATCH_NAME',
1296: l_t_rc_tab(l_n_cntr).batch_name);
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;

Line 1302: fnd_message.get);

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
1306: l_v_val_status := 'E';

Line 1307: fnd_message.set_name('IGS',

1303: END IF;
1304:
1305: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt6,0) < 0 THEN
1306: l_v_val_status := 'E';
1307: fnd_message.set_name('IGS',
1308: 'IGS_FI_CHG_AMT_NEG');
1309: fnd_message.set_token('ITEM_NUMBER',
1310: l_t_rc_tab(l_n_cntr).item_number);
1311: fnd_message.set_token('BATCH_NAME',

Line 1309: fnd_message.set_token('ITEM_NUMBER',

1305: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt6,0) < 0 THEN
1306: l_v_val_status := 'E';
1307: fnd_message.set_name('IGS',
1308: 'IGS_FI_CHG_AMT_NEG');
1309: fnd_message.set_token('ITEM_NUMBER',
1310: l_t_rc_tab(l_n_cntr).item_number);
1311: fnd_message.set_token('BATCH_NAME',
1312: l_t_rc_tab(l_n_cntr).batch_name);
1313: fnd_message.set_token('LOCKBOX_NAME',

Line 1311: fnd_message.set_token('BATCH_NAME',

1307: fnd_message.set_name('IGS',
1308: 'IGS_FI_CHG_AMT_NEG');
1309: fnd_message.set_token('ITEM_NUMBER',
1310: l_t_rc_tab(l_n_cntr).item_number);
1311: fnd_message.set_token('BATCH_NAME',
1312: l_t_rc_tab(l_n_cntr).batch_name);
1313: fnd_message.set_token('LOCKBOX_NAME',
1314: l_t_rc_tab(l_n_cntr).lockbox_name);
1315: fnd_message.set_token('CHARGE_CODE',

Line 1313: fnd_message.set_token('LOCKBOX_NAME',

1309: fnd_message.set_token('ITEM_NUMBER',
1310: l_t_rc_tab(l_n_cntr).item_number);
1311: fnd_message.set_token('BATCH_NAME',
1312: l_t_rc_tab(l_n_cntr).batch_name);
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,

Line 1315: fnd_message.set_token('CHARGE_CODE',

1311: fnd_message.set_token('BATCH_NAME',
1312: l_t_rc_tab(l_n_cntr).batch_name);
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;

Line 1318: fnd_message.get);

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
1322: l_v_val_status := 'E';

Line 1323: fnd_message.set_name('IGS',

1319: END IF;
1320:
1321: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt7,0) < 0 THEN
1322: l_v_val_status := 'E';
1323: fnd_message.set_name('IGS',
1324: 'IGS_FI_CHG_AMT_NEG');
1325: fnd_message.set_token('ITEM_NUMBER',
1326: l_t_rc_tab(l_n_cntr).item_number);
1327: fnd_message.set_token('BATCH_NAME',

Line 1325: fnd_message.set_token('ITEM_NUMBER',

1321: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt7,0) < 0 THEN
1322: l_v_val_status := 'E';
1323: fnd_message.set_name('IGS',
1324: 'IGS_FI_CHG_AMT_NEG');
1325: fnd_message.set_token('ITEM_NUMBER',
1326: l_t_rc_tab(l_n_cntr).item_number);
1327: fnd_message.set_token('BATCH_NAME',
1328: l_t_rc_tab(l_n_cntr).batch_name);
1329: fnd_message.set_token('LOCKBOX_NAME',

Line 1327: fnd_message.set_token('BATCH_NAME',

1323: fnd_message.set_name('IGS',
1324: 'IGS_FI_CHG_AMT_NEG');
1325: fnd_message.set_token('ITEM_NUMBER',
1326: l_t_rc_tab(l_n_cntr).item_number);
1327: fnd_message.set_token('BATCH_NAME',
1328: l_t_rc_tab(l_n_cntr).batch_name);
1329: fnd_message.set_token('LOCKBOX_NAME',
1330: l_t_rc_tab(l_n_cntr).lockbox_name);
1331: fnd_message.set_token('CHARGE_CODE',

Line 1329: fnd_message.set_token('LOCKBOX_NAME',

1325: fnd_message.set_token('ITEM_NUMBER',
1326: l_t_rc_tab(l_n_cntr).item_number);
1327: fnd_message.set_token('BATCH_NAME',
1328: l_t_rc_tab(l_n_cntr).batch_name);
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,

Line 1331: fnd_message.set_token('CHARGE_CODE',

1327: fnd_message.set_token('BATCH_NAME',
1328: l_t_rc_tab(l_n_cntr).batch_name);
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;

Line 1334: fnd_message.get);

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
1338: l_v_val_status := 'E';

Line 1339: fnd_message.set_name('IGS',

1335: END IF;
1336:
1337: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt8,0) < 0 THEN
1338: l_v_val_status := 'E';
1339: fnd_message.set_name('IGS',
1340: 'IGS_FI_CHG_AMT_NEG');
1341: fnd_message.set_token('ITEM_NUMBER',
1342: l_t_rc_tab(l_n_cntr).item_number);
1343: fnd_message.set_token('BATCH_NAME',

Line 1341: fnd_message.set_token('ITEM_NUMBER',

1337: IF NVL(l_t_rc_tab(l_n_cntr).applied_amt8,0) < 0 THEN
1338: l_v_val_status := 'E';
1339: fnd_message.set_name('IGS',
1340: 'IGS_FI_CHG_AMT_NEG');
1341: fnd_message.set_token('ITEM_NUMBER',
1342: l_t_rc_tab(l_n_cntr).item_number);
1343: fnd_message.set_token('BATCH_NAME',
1344: l_t_rc_tab(l_n_cntr).batch_name);
1345: fnd_message.set_token('LOCKBOX_NAME',

Line 1343: fnd_message.set_token('BATCH_NAME',

1339: fnd_message.set_name('IGS',
1340: 'IGS_FI_CHG_AMT_NEG');
1341: fnd_message.set_token('ITEM_NUMBER',
1342: l_t_rc_tab(l_n_cntr).item_number);
1343: fnd_message.set_token('BATCH_NAME',
1344: l_t_rc_tab(l_n_cntr).batch_name);
1345: fnd_message.set_token('LOCKBOX_NAME',
1346: l_t_rc_tab(l_n_cntr).lockbox_name);
1347: fnd_message.set_token('CHARGE_CODE',

Line 1345: fnd_message.set_token('LOCKBOX_NAME',

1341: fnd_message.set_token('ITEM_NUMBER',
1342: l_t_rc_tab(l_n_cntr).item_number);
1343: fnd_message.set_token('BATCH_NAME',
1344: l_t_rc_tab(l_n_cntr).batch_name);
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,

Line 1347: fnd_message.set_token('CHARGE_CODE',

1343: fnd_message.set_token('BATCH_NAME',
1344: l_t_rc_tab(l_n_cntr).batch_name);
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;

Line 1350: fnd_message.get);

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
1354: l_n_amt_appl := NVL(l_t_rc_tab(l_n_cntr).applied_amt1,0) +

Line 1404: fnd_message.set_name('IGS',

1400:
1401: -- If the amount to be applied is greater than the receipt amount then log the error in the log file
1402: IF l_n_amt_appl > NVL(l_t_rc_tab(l_n_cntr).receipt_amt,0) THEN
1403: l_v_val_status := 'E';
1404: fnd_message.set_name('IGS',
1405: 'IGS_FI_DESG_AMNT_MISMATCH');
1406: fnd_message.set_token('ITEM_NUMBER',
1407: l_t_rc_tab(l_n_cntr).item_number);
1408: fnd_message.set_token('BATCH_NAME',

Line 1406: fnd_message.set_token('ITEM_NUMBER',

1402: IF l_n_amt_appl > NVL(l_t_rc_tab(l_n_cntr).receipt_amt,0) THEN
1403: l_v_val_status := 'E';
1404: fnd_message.set_name('IGS',
1405: 'IGS_FI_DESG_AMNT_MISMATCH');
1406: fnd_message.set_token('ITEM_NUMBER',
1407: l_t_rc_tab(l_n_cntr).item_number);
1408: fnd_message.set_token('BATCH_NAME',
1409: l_t_rc_tab(l_n_cntr).batch_name);
1410: fnd_message.set_token('LOCKBOX_NAME',

Line 1408: fnd_message.set_token('BATCH_NAME',

1404: fnd_message.set_name('IGS',
1405: 'IGS_FI_DESG_AMNT_MISMATCH');
1406: fnd_message.set_token('ITEM_NUMBER',
1407: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 1410: fnd_message.set_token('LOCKBOX_NAME',

1406: fnd_message.set_token('ITEM_NUMBER',
1407: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 1413: fnd_message.get);

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;
1417: END IF;

Line 1428: fnd_message.set_name('IGS',

1424:
1425: -- If the item number is not null, then log the error message in the log file
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;

Line 1431: fnd_message.get);

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
1435: -- for the receipt overflow record

Line 1438: fnd_message.set_name('IGS',

1434: -- The following logic checks for the negative amount for the Charge Amount
1435: -- for the receipt overflow record
1436: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt1,0) < 0 THEN
1437: l_v_val_status := 'E';
1438: fnd_message.set_name('IGS',
1439: 'IGS_FI_CHG_AMT_NEG');
1440: fnd_message.set_token('ITEM_NUMBER',
1441: l_t_ro_tab(l_n_cntr).item_number);
1442: fnd_message.set_token('BATCH_NAME',

Line 1440: fnd_message.set_token('ITEM_NUMBER',

1436: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt1,0) < 0 THEN
1437: l_v_val_status := 'E';
1438: fnd_message.set_name('IGS',
1439: 'IGS_FI_CHG_AMT_NEG');
1440: fnd_message.set_token('ITEM_NUMBER',
1441: l_t_ro_tab(l_n_cntr).item_number);
1442: fnd_message.set_token('BATCH_NAME',
1443: l_t_ro_tab(l_n_cntr).batch_name);
1444: fnd_message.set_token('LOCKBOX_NAME',

Line 1442: fnd_message.set_token('BATCH_NAME',

1438: fnd_message.set_name('IGS',
1439: 'IGS_FI_CHG_AMT_NEG');
1440: fnd_message.set_token('ITEM_NUMBER',
1441: l_t_ro_tab(l_n_cntr).item_number);
1442: fnd_message.set_token('BATCH_NAME',
1443: l_t_ro_tab(l_n_cntr).batch_name);
1444: fnd_message.set_token('LOCKBOX_NAME',
1445: l_t_ro_tab(l_n_cntr).lockbox_name);
1446: fnd_message.set_token('CHARGE_CODE',

Line 1444: fnd_message.set_token('LOCKBOX_NAME',

1440: fnd_message.set_token('ITEM_NUMBER',
1441: l_t_ro_tab(l_n_cntr).item_number);
1442: fnd_message.set_token('BATCH_NAME',
1443: l_t_ro_tab(l_n_cntr).batch_name);
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,

Line 1446: fnd_message.set_token('CHARGE_CODE',

1442: fnd_message.set_token('BATCH_NAME',
1443: l_t_ro_tab(l_n_cntr).batch_name);
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;

Line 1449: fnd_message.get);

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
1453: l_v_val_status := 'E';

Line 1454: fnd_message.set_name('IGS',

1450: END IF;
1451:
1452: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt2,0) < 0 THEN
1453: l_v_val_status := 'E';
1454: fnd_message.set_name('IGS',
1455: 'IGS_FI_CHG_AMT_NEG');
1456: fnd_message.set_token('ITEM_NUMBER',
1457: l_t_ro_tab(l_n_cntr).item_number);
1458: fnd_message.set_token('BATCH_NAME',

Line 1456: fnd_message.set_token('ITEM_NUMBER',

1452: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt2,0) < 0 THEN
1453: l_v_val_status := 'E';
1454: fnd_message.set_name('IGS',
1455: 'IGS_FI_CHG_AMT_NEG');
1456: fnd_message.set_token('ITEM_NUMBER',
1457: l_t_ro_tab(l_n_cntr).item_number);
1458: fnd_message.set_token('BATCH_NAME',
1459: l_t_ro_tab(l_n_cntr).batch_name);
1460: fnd_message.set_token('LOCKBOX_NAME',

Line 1458: fnd_message.set_token('BATCH_NAME',

1454: fnd_message.set_name('IGS',
1455: 'IGS_FI_CHG_AMT_NEG');
1456: fnd_message.set_token('ITEM_NUMBER',
1457: l_t_ro_tab(l_n_cntr).item_number);
1458: fnd_message.set_token('BATCH_NAME',
1459: l_t_ro_tab(l_n_cntr).batch_name);
1460: fnd_message.set_token('LOCKBOX_NAME',
1461: l_t_ro_tab(l_n_cntr).lockbox_name);
1462: fnd_message.set_token('CHARGE_CODE',

Line 1460: fnd_message.set_token('LOCKBOX_NAME',

1456: fnd_message.set_token('ITEM_NUMBER',
1457: l_t_ro_tab(l_n_cntr).item_number);
1458: fnd_message.set_token('BATCH_NAME',
1459: l_t_ro_tab(l_n_cntr).batch_name);
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,

Line 1462: fnd_message.set_token('CHARGE_CODE',

1458: fnd_message.set_token('BATCH_NAME',
1459: l_t_ro_tab(l_n_cntr).batch_name);
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;

Line 1465: fnd_message.get);

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
1469: l_v_val_status := 'E';

Line 1470: fnd_message.set_name('IGS',

1466: END IF;
1467:
1468: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt3,0) < 0 THEN
1469: l_v_val_status := 'E';
1470: fnd_message.set_name('IGS',
1471: 'IGS_FI_CHG_AMT_NEG');
1472: fnd_message.set_token('ITEM_NUMBER',
1473: l_t_ro_tab(l_n_cntr).item_number);
1474: fnd_message.set_token('BATCH_NAME',

Line 1472: fnd_message.set_token('ITEM_NUMBER',

1468: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt3,0) < 0 THEN
1469: l_v_val_status := 'E';
1470: fnd_message.set_name('IGS',
1471: 'IGS_FI_CHG_AMT_NEG');
1472: fnd_message.set_token('ITEM_NUMBER',
1473: l_t_ro_tab(l_n_cntr).item_number);
1474: fnd_message.set_token('BATCH_NAME',
1475: l_t_ro_tab(l_n_cntr).batch_name);
1476: fnd_message.set_token('LOCKBOX_NAME',

Line 1474: fnd_message.set_token('BATCH_NAME',

1470: fnd_message.set_name('IGS',
1471: 'IGS_FI_CHG_AMT_NEG');
1472: fnd_message.set_token('ITEM_NUMBER',
1473: l_t_ro_tab(l_n_cntr).item_number);
1474: fnd_message.set_token('BATCH_NAME',
1475: l_t_ro_tab(l_n_cntr).batch_name);
1476: fnd_message.set_token('LOCKBOX_NAME',
1477: l_t_ro_tab(l_n_cntr).lockbox_name);
1478: fnd_message.set_token('CHARGE_CODE',

Line 1476: fnd_message.set_token('LOCKBOX_NAME',

1472: fnd_message.set_token('ITEM_NUMBER',
1473: l_t_ro_tab(l_n_cntr).item_number);
1474: fnd_message.set_token('BATCH_NAME',
1475: l_t_ro_tab(l_n_cntr).batch_name);
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,

Line 1478: fnd_message.set_token('CHARGE_CODE',

1474: fnd_message.set_token('BATCH_NAME',
1475: l_t_ro_tab(l_n_cntr).batch_name);
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;

Line 1481: fnd_message.get);

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
1485: l_v_val_status := 'E';

Line 1486: fnd_message.set_name('IGS',

1482: END IF;
1483:
1484: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt4,0) < 0 THEN
1485: l_v_val_status := 'E';
1486: fnd_message.set_name('IGS',
1487: 'IGS_FI_CHG_AMT_NEG');
1488: fnd_message.set_token('ITEM_NUMBER',
1489: l_t_ro_tab(l_n_cntr).item_number);
1490: fnd_message.set_token('BATCH_NAME',

Line 1488: fnd_message.set_token('ITEM_NUMBER',

1484: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt4,0) < 0 THEN
1485: l_v_val_status := 'E';
1486: fnd_message.set_name('IGS',
1487: 'IGS_FI_CHG_AMT_NEG');
1488: fnd_message.set_token('ITEM_NUMBER',
1489: l_t_ro_tab(l_n_cntr).item_number);
1490: fnd_message.set_token('BATCH_NAME',
1491: l_t_ro_tab(l_n_cntr).batch_name);
1492: fnd_message.set_token('LOCKBOX_NAME',

Line 1490: fnd_message.set_token('BATCH_NAME',

1486: fnd_message.set_name('IGS',
1487: 'IGS_FI_CHG_AMT_NEG');
1488: fnd_message.set_token('ITEM_NUMBER',
1489: l_t_ro_tab(l_n_cntr).item_number);
1490: fnd_message.set_token('BATCH_NAME',
1491: l_t_ro_tab(l_n_cntr).batch_name);
1492: fnd_message.set_token('LOCKBOX_NAME',
1493: l_t_ro_tab(l_n_cntr).lockbox_name);
1494: fnd_message.set_token('CHARGE_CODE',

Line 1492: fnd_message.set_token('LOCKBOX_NAME',

1488: fnd_message.set_token('ITEM_NUMBER',
1489: l_t_ro_tab(l_n_cntr).item_number);
1490: fnd_message.set_token('BATCH_NAME',
1491: l_t_ro_tab(l_n_cntr).batch_name);
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,

Line 1494: fnd_message.set_token('CHARGE_CODE',

1490: fnd_message.set_token('BATCH_NAME',
1491: l_t_ro_tab(l_n_cntr).batch_name);
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;

Line 1497: fnd_message.get);

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
1501: l_v_val_status := 'E';

Line 1502: fnd_message.set_name('IGS',

1498: END IF;
1499:
1500: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt5,0) < 0 THEN
1501: l_v_val_status := 'E';
1502: fnd_message.set_name('IGS',
1503: 'IGS_FI_CHG_AMT_NEG');
1504: fnd_message.set_token('ITEM_NUMBER',
1505: l_t_ro_tab(l_n_cntr).item_number);
1506: fnd_message.set_token('BATCH_NAME',

Line 1504: fnd_message.set_token('ITEM_NUMBER',

1500: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt5,0) < 0 THEN
1501: l_v_val_status := 'E';
1502: fnd_message.set_name('IGS',
1503: 'IGS_FI_CHG_AMT_NEG');
1504: fnd_message.set_token('ITEM_NUMBER',
1505: l_t_ro_tab(l_n_cntr).item_number);
1506: fnd_message.set_token('BATCH_NAME',
1507: l_t_ro_tab(l_n_cntr).batch_name);
1508: fnd_message.set_token('LOCKBOX_NAME',

Line 1506: fnd_message.set_token('BATCH_NAME',

1502: fnd_message.set_name('IGS',
1503: 'IGS_FI_CHG_AMT_NEG');
1504: fnd_message.set_token('ITEM_NUMBER',
1505: l_t_ro_tab(l_n_cntr).item_number);
1506: fnd_message.set_token('BATCH_NAME',
1507: l_t_ro_tab(l_n_cntr).batch_name);
1508: fnd_message.set_token('LOCKBOX_NAME',
1509: l_t_ro_tab(l_n_cntr).lockbox_name);
1510: fnd_message.set_token('CHARGE_CODE',

Line 1508: fnd_message.set_token('LOCKBOX_NAME',

1504: fnd_message.set_token('ITEM_NUMBER',
1505: l_t_ro_tab(l_n_cntr).item_number);
1506: fnd_message.set_token('BATCH_NAME',
1507: l_t_ro_tab(l_n_cntr).batch_name);
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,

Line 1510: fnd_message.set_token('CHARGE_CODE',

1506: fnd_message.set_token('BATCH_NAME',
1507: l_t_ro_tab(l_n_cntr).batch_name);
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;

Line 1513: fnd_message.get);

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
1517: l_v_val_status := 'E';

Line 1518: fnd_message.set_name('IGS',

1514: END IF;
1515:
1516: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt6,0) < 0 THEN
1517: l_v_val_status := 'E';
1518: fnd_message.set_name('IGS',
1519: 'IGS_FI_CHG_AMT_NEG');
1520: fnd_message.set_token('ITEM_NUMBER',
1521: l_t_ro_tab(l_n_cntr).item_number);
1522: fnd_message.set_token('BATCH_NAME',

Line 1520: fnd_message.set_token('ITEM_NUMBER',

1516: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt6,0) < 0 THEN
1517: l_v_val_status := 'E';
1518: fnd_message.set_name('IGS',
1519: 'IGS_FI_CHG_AMT_NEG');
1520: fnd_message.set_token('ITEM_NUMBER',
1521: l_t_ro_tab(l_n_cntr).item_number);
1522: fnd_message.set_token('BATCH_NAME',
1523: l_t_ro_tab(l_n_cntr).batch_name);
1524: fnd_message.set_token('LOCKBOX_NAME',

Line 1522: fnd_message.set_token('BATCH_NAME',

1518: fnd_message.set_name('IGS',
1519: 'IGS_FI_CHG_AMT_NEG');
1520: fnd_message.set_token('ITEM_NUMBER',
1521: l_t_ro_tab(l_n_cntr).item_number);
1522: fnd_message.set_token('BATCH_NAME',
1523: l_t_ro_tab(l_n_cntr).batch_name);
1524: fnd_message.set_token('LOCKBOX_NAME',
1525: l_t_ro_tab(l_n_cntr).lockbox_name);
1526: fnd_message.set_token('CHARGE_CODE',

Line 1524: fnd_message.set_token('LOCKBOX_NAME',

1520: fnd_message.set_token('ITEM_NUMBER',
1521: l_t_ro_tab(l_n_cntr).item_number);
1522: fnd_message.set_token('BATCH_NAME',
1523: l_t_ro_tab(l_n_cntr).batch_name);
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,

Line 1526: fnd_message.set_token('CHARGE_CODE',

1522: fnd_message.set_token('BATCH_NAME',
1523: l_t_ro_tab(l_n_cntr).batch_name);
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;

Line 1529: fnd_message.get);

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
1533: l_v_val_status := 'E';

Line 1534: fnd_message.set_name('IGS',

1530: END IF;
1531:
1532: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt7,0) < 0 THEN
1533: l_v_val_status := 'E';
1534: fnd_message.set_name('IGS',
1535: 'IGS_FI_CHG_AMT_NEG');
1536: fnd_message.set_token('ITEM_NUMBER',
1537: l_t_ro_tab(l_n_cntr).item_number);
1538: fnd_message.set_token('BATCH_NAME',

Line 1536: fnd_message.set_token('ITEM_NUMBER',

1532: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt7,0) < 0 THEN
1533: l_v_val_status := 'E';
1534: fnd_message.set_name('IGS',
1535: 'IGS_FI_CHG_AMT_NEG');
1536: fnd_message.set_token('ITEM_NUMBER',
1537: l_t_ro_tab(l_n_cntr).item_number);
1538: fnd_message.set_token('BATCH_NAME',
1539: l_t_ro_tab(l_n_cntr).batch_name);
1540: fnd_message.set_token('LOCKBOX_NAME',

Line 1538: fnd_message.set_token('BATCH_NAME',

1534: fnd_message.set_name('IGS',
1535: 'IGS_FI_CHG_AMT_NEG');
1536: fnd_message.set_token('ITEM_NUMBER',
1537: l_t_ro_tab(l_n_cntr).item_number);
1538: fnd_message.set_token('BATCH_NAME',
1539: l_t_ro_tab(l_n_cntr).batch_name);
1540: fnd_message.set_token('LOCKBOX_NAME',
1541: l_t_ro_tab(l_n_cntr).lockbox_name);
1542: fnd_message.set_token('CHARGE_CODE',

Line 1540: fnd_message.set_token('LOCKBOX_NAME',

1536: fnd_message.set_token('ITEM_NUMBER',
1537: l_t_ro_tab(l_n_cntr).item_number);
1538: fnd_message.set_token('BATCH_NAME',
1539: l_t_ro_tab(l_n_cntr).batch_name);
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,

Line 1542: fnd_message.set_token('CHARGE_CODE',

1538: fnd_message.set_token('BATCH_NAME',
1539: l_t_ro_tab(l_n_cntr).batch_name);
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;

Line 1545: fnd_message.get);

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
1549: l_v_val_status := 'E';

Line 1550: fnd_message.set_name('IGS',

1546: END IF;
1547:
1548: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt8,0) < 0 THEN
1549: l_v_val_status := 'E';
1550: fnd_message.set_name('IGS',
1551: 'IGS_FI_CHG_AMT_NEG');
1552: fnd_message.set_token('ITEM_NUMBER',
1553: l_t_ro_tab(l_n_cntr).item_number);
1554: fnd_message.set_token('BATCH_NAME',

Line 1552: fnd_message.set_token('ITEM_NUMBER',

1548: IF NVL(l_t_ro_tab(l_n_cntr).applied_amt8,0) < 0 THEN
1549: l_v_val_status := 'E';
1550: fnd_message.set_name('IGS',
1551: 'IGS_FI_CHG_AMT_NEG');
1552: fnd_message.set_token('ITEM_NUMBER',
1553: l_t_ro_tab(l_n_cntr).item_number);
1554: fnd_message.set_token('BATCH_NAME',
1555: l_t_ro_tab(l_n_cntr).batch_name);
1556: fnd_message.set_token('LOCKBOX_NAME',

Line 1554: fnd_message.set_token('BATCH_NAME',

1550: fnd_message.set_name('IGS',
1551: 'IGS_FI_CHG_AMT_NEG');
1552: fnd_message.set_token('ITEM_NUMBER',
1553: l_t_ro_tab(l_n_cntr).item_number);
1554: fnd_message.set_token('BATCH_NAME',
1555: l_t_ro_tab(l_n_cntr).batch_name);
1556: fnd_message.set_token('LOCKBOX_NAME',
1557: l_t_ro_tab(l_n_cntr).lockbox_name);
1558: fnd_message.set_token('CHARGE_CODE',

Line 1556: fnd_message.set_token('LOCKBOX_NAME',

1552: fnd_message.set_token('ITEM_NUMBER',
1553: l_t_ro_tab(l_n_cntr).item_number);
1554: fnd_message.set_token('BATCH_NAME',
1555: l_t_ro_tab(l_n_cntr).batch_name);
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,

Line 1558: fnd_message.set_token('CHARGE_CODE',

1554: fnd_message.set_token('BATCH_NAME',
1555: l_t_ro_tab(l_n_cntr).batch_name);
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;

Line 1561: fnd_message.get);

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;
1565: l_b_rc_ro_match := FALSE;

Line 1617: fnd_message.set_name('IGS',

1613: END IF;
1614:
1615: IF NOT l_b_rc_ro_match THEN
1616: l_v_val_status := 'E';
1617: fnd_message.set_name('IGS',
1618: 'IGS_FI_NO_OVFL_REC_LINK');
1619: fnd_message.set_token('ITEM_NUMBER',
1620: l_t_ro_tab(l_n_cntr).item_number);
1621: fnd_message.set_token('BATCH_NAME',

Line 1619: fnd_message.set_token('ITEM_NUMBER',

1615: IF NOT l_b_rc_ro_match THEN
1616: l_v_val_status := 'E';
1617: fnd_message.set_name('IGS',
1618: 'IGS_FI_NO_OVFL_REC_LINK');
1619: fnd_message.set_token('ITEM_NUMBER',
1620: l_t_ro_tab(l_n_cntr).item_number);
1621: fnd_message.set_token('BATCH_NAME',
1622: l_t_ro_tab(l_n_cntr).batch_name);
1623: fnd_message.set_token('LOCKBOX_NAME',

Line 1621: fnd_message.set_token('BATCH_NAME',

1617: fnd_message.set_name('IGS',
1618: 'IGS_FI_NO_OVFL_REC_LINK');
1619: fnd_message.set_token('ITEM_NUMBER',
1620: l_t_ro_tab(l_n_cntr).item_number);
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,

Line 1623: fnd_message.set_token('LOCKBOX_NAME',

1619: fnd_message.set_token('ITEM_NUMBER',
1620: l_t_ro_tab(l_n_cntr).item_number);
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;

Line 1626: fnd_message.get);

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;
1630:

Line 1693: fnd_message.set_name('IGS',

1689: END IF;
1690:
1691: IF NOT l_b_ro_chg_appl THEN
1692: l_v_val_status := 'E';
1693: fnd_message.set_name('IGS',
1694: 'IGS_FI_OVFL_REC_NO_CHG_APPL');
1695: fnd_message.set_token('ITEM_NUMBER',
1696: l_t_ro_tab(l_n_cntr).item_number);
1697: fnd_message.set_token('BATCH_NAME',

Line 1695: fnd_message.set_token('ITEM_NUMBER',

1691: IF NOT l_b_ro_chg_appl THEN
1692: l_v_val_status := 'E';
1693: fnd_message.set_name('IGS',
1694: 'IGS_FI_OVFL_REC_NO_CHG_APPL');
1695: fnd_message.set_token('ITEM_NUMBER',
1696: l_t_ro_tab(l_n_cntr).item_number);
1697: fnd_message.set_token('BATCH_NAME',
1698: l_t_ro_tab(l_n_cntr).batch_name);
1699: fnd_message.set_token('LOCKBOX_NAME',

Line 1697: fnd_message.set_token('BATCH_NAME',

1693: fnd_message.set_name('IGS',
1694: 'IGS_FI_OVFL_REC_NO_CHG_APPL');
1695: fnd_message.set_token('ITEM_NUMBER',
1696: l_t_ro_tab(l_n_cntr).item_number);
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,

Line 1699: fnd_message.set_token('LOCKBOX_NAME',

1695: fnd_message.set_token('ITEM_NUMBER',
1696: l_t_ro_tab(l_n_cntr).item_number);
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;

Line 1702: fnd_message.get);

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
1706: -- then this is an error .

Line 1724: fnd_message.set_name('IGS',

1720: (l_t_ro_tab(l_n_cntr).applied_amt7 IS NULL)) AND
1721: ((l_t_ro_tab(l_n_cntr).charge_cd8 IS NULL) AND
1722: (l_t_ro_tab(l_n_cntr).applied_amt8 IS NULL)) THEN
1723: l_v_val_status := 'E';
1724: fnd_message.set_name('IGS',
1725: 'IGS_FI_OVFL_REC_NO_CHG_APPL');
1726: fnd_message.set_token('ITEM_NUMBER',
1727: l_t_ro_tab(l_n_cntr).item_number);
1728: fnd_message.set_token('BATCH_NAME',

Line 1726: fnd_message.set_token('ITEM_NUMBER',

1722: (l_t_ro_tab(l_n_cntr).applied_amt8 IS NULL)) THEN
1723: l_v_val_status := 'E';
1724: fnd_message.set_name('IGS',
1725: 'IGS_FI_OVFL_REC_NO_CHG_APPL');
1726: fnd_message.set_token('ITEM_NUMBER',
1727: l_t_ro_tab(l_n_cntr).item_number);
1728: fnd_message.set_token('BATCH_NAME',
1729: l_t_ro_tab(l_n_cntr).batch_name);
1730: fnd_message.set_token('LOCKBOX_NAME',

Line 1728: fnd_message.set_token('BATCH_NAME',

1724: fnd_message.set_name('IGS',
1725: 'IGS_FI_OVFL_REC_NO_CHG_APPL');
1726: fnd_message.set_token('ITEM_NUMBER',
1727: l_t_ro_tab(l_n_cntr).item_number);
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,

Line 1730: fnd_message.set_token('LOCKBOX_NAME',

1726: fnd_message.set_token('ITEM_NUMBER',
1727: l_t_ro_tab(l_n_cntr).item_number);
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;

Line 1733: fnd_message.get);

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;
1737: END IF;

Line 1952: fnd_message.set_name('IGS',

1948: IF cur_inv%NOTFOUND THEN
1949: CLOSE cur_inv;
1950: p_n_invoice_id := null;
1951: p_v_fee_type := null;
1952: fnd_message.set_name('IGS',
1953: 'IGS_FI_INV_CHG_CODE');
1954: fnd_message.set_token('CHARGE_NUMBER',
1955: p_v_charge_code);
1956: fnd_message.set_token('PARTY_NUMBER',

Line 1954: fnd_message.set_token('CHARGE_NUMBER',

1950: p_n_invoice_id := null;
1951: p_v_fee_type := null;
1952: fnd_message.set_name('IGS',
1953: 'IGS_FI_INV_CHG_CODE');
1954: fnd_message.set_token('CHARGE_NUMBER',
1955: p_v_charge_code);
1956: fnd_message.set_token('PARTY_NUMBER',
1957: p_v_party_number);
1958: p_v_message_name := fnd_message.get;

Line 1956: fnd_message.set_token('PARTY_NUMBER',

1952: fnd_message.set_name('IGS',
1953: 'IGS_FI_INV_CHG_CODE');
1954: fnd_message.set_token('CHARGE_NUMBER',
1955: p_v_charge_code);
1956: fnd_message.set_token('PARTY_NUMBER',
1957: p_v_party_number);
1958: p_v_message_name := fnd_message.get;
1959: RETURN;
1960: END IF;

Line 1958: p_v_message_name := fnd_message.get;

1954: fnd_message.set_token('CHARGE_NUMBER',
1955: p_v_charge_code);
1956: fnd_message.set_token('PARTY_NUMBER',
1957: p_v_party_number);
1958: p_v_message_name := fnd_message.get;
1959: RETURN;
1960: END IF;
1961: CLOSE cur_inv;
1962:

Line 1969: fnd_message.set_name('IGS',

1965: FETCH cur_ft INTO l_v_designated_pay_flag;
1966: CLOSE cur_ft;
1967:
1968: IF NVL(l_v_designated_pay_flag,'N') = 'N' THEN
1969: fnd_message.set_name('IGS',
1970: 'IGS_FI_CHG_FT_NOT_DESG');
1971: fnd_message.set_token('CHARGE_NUMBER',
1972: p_v_charge_code);
1973: fnd_message.set_token('FEE_TYPE',

Line 1971: fnd_message.set_token('CHARGE_NUMBER',

1967:
1968: IF NVL(l_v_designated_pay_flag,'N') = 'N' THEN
1969: fnd_message.set_name('IGS',
1970: 'IGS_FI_CHG_FT_NOT_DESG');
1971: fnd_message.set_token('CHARGE_NUMBER',
1972: p_v_charge_code);
1973: fnd_message.set_token('FEE_TYPE',
1974: l_v_fee_type);
1975: p_v_message_name := fnd_message.get;

Line 1973: fnd_message.set_token('FEE_TYPE',

1969: fnd_message.set_name('IGS',
1970: 'IGS_FI_CHG_FT_NOT_DESG');
1971: fnd_message.set_token('CHARGE_NUMBER',
1972: p_v_charge_code);
1973: fnd_message.set_token('FEE_TYPE',
1974: l_v_fee_type);
1975: p_v_message_name := fnd_message.get;
1976: END IF;
1977:

Line 1975: p_v_message_name := fnd_message.get;

1971: fnd_message.set_token('CHARGE_NUMBER',
1972: p_v_charge_code);
1973: fnd_message.set_token('FEE_TYPE',
1974: l_v_fee_type);
1975: p_v_message_name := fnd_message.get;
1976: END IF;
1977:
1978: p_n_invoice_id := l_n_inv_id;
1979: p_v_fee_type := l_v_fee_type;

Line 2027: fnd_message.set_name('IGS',

2023: -- If the Invoice Amount Due is less than or equal to 0, then log this in the log file
2024: IF l_n_inv_amt_due <= 0 THEN
2025: p_n_act_amnt_applied := null;
2026: p_n_application_id := null;
2027: fnd_message.set_name('IGS',
2028: 'IGS_FI_INV_AMT_DUE_NIL');
2029: fnd_message.set_token('CHARGE_NUMBER',
2030: p_v_charge_code);
2031: p_v_err_message := fnd_message.get;

Line 2029: fnd_message.set_token('CHARGE_NUMBER',

2025: p_n_act_amnt_applied := null;
2026: p_n_application_id := null;
2027: fnd_message.set_name('IGS',
2028: 'IGS_FI_INV_AMT_DUE_NIL');
2029: fnd_message.set_token('CHARGE_NUMBER',
2030: p_v_charge_code);
2031: p_v_err_message := fnd_message.get;
2032: RETURN;
2033: ELSE

Line 2031: p_v_err_message := fnd_message.get;

2027: fnd_message.set_name('IGS',
2028: 'IGS_FI_INV_AMT_DUE_NIL');
2029: fnd_message.set_token('CHARGE_NUMBER',
2030: p_v_charge_code);
2031: p_v_err_message := fnd_message.get;
2032: RETURN;
2033: ELSE
2034:
2035: -- Else identify if the amount applied is greater than the Invoice Amount Due.

Line 2070: p_v_err_message := fnd_message.get_string('IGS',

2066: p_v_err_message := null;
2067: ELSE
2068: p_n_act_amnt_applied := null;
2069: p_n_application_id := null;
2070: p_v_err_message := fnd_message.get_string('IGS',
2071: l_v_err_msg);
2072: END IF;
2073: END invoke_target_appl;
2074:

Line 2343: fnd_message.set_encoded(l_v_msg_txt);

2339: -- Show the message on the stack in such a case
2340: IF l_n_msg_count <> 0 THEN
2341: FOR l_n_cntr IN 1..l_n_msg_count LOOP
2342: l_v_msg_txt := fnd_msg_pub.get(p_msg_index => l_n_cntr, p_encoded => 'T');
2343: fnd_message.set_encoded(l_v_msg_txt);
2344: p_v_message_text := p_v_message_text||fnd_message.get;
2345: END LOOP;
2346: END IF;
2347: ELSE

Line 2344: p_v_message_text := p_v_message_text||fnd_message.get;

2340: IF l_n_msg_count <> 0 THEN
2341: FOR l_n_cntr IN 1..l_n_msg_count LOOP
2342: l_v_msg_txt := fnd_msg_pub.get(p_msg_index => l_n_cntr, p_encoded => 'T');
2343: fnd_message.set_encoded(l_v_msg_txt);
2344: p_v_message_text := p_v_message_text||fnd_message.get;
2345: END LOOP;
2346: END IF;
2347: ELSE
2348: -- If the credits API returns an error, then pass the error message out

Line 2352: fnd_message.set_encoded(l_v_msg_data);

2348: -- If the credits API returns an error, then pass the error message out
2349: p_n_credit_id := null;
2350: p_v_status := l_v_status;
2351: IF l_n_msg_count = 1 THEN
2352: fnd_message.set_encoded(l_v_msg_data);
2353: p_v_message_text := fnd_message.get;
2354: ELSE
2355: FOR l_n_cntr IN 1..l_n_msg_count LOOP
2356: l_v_msg_txt := fnd_msg_pub.get(p_msg_index => l_n_cntr, p_encoded => 'T');

Line 2353: p_v_message_text := fnd_message.get;

2349: p_n_credit_id := null;
2350: p_v_status := l_v_status;
2351: IF l_n_msg_count = 1 THEN
2352: fnd_message.set_encoded(l_v_msg_data);
2353: p_v_message_text := fnd_message.get;
2354: ELSE
2355: FOR l_n_cntr IN 1..l_n_msg_count LOOP
2356: l_v_msg_txt := fnd_msg_pub.get(p_msg_index => l_n_cntr, p_encoded => 'T');
2357: fnd_message.set_encoded(l_v_msg_txt);

Line 2357: fnd_message.set_encoded(l_v_msg_txt);

2353: p_v_message_text := fnd_message.get;
2354: ELSE
2355: FOR l_n_cntr IN 1..l_n_msg_count LOOP
2356: l_v_msg_txt := fnd_msg_pub.get(p_msg_index => l_n_cntr, p_encoded => 'T');
2357: fnd_message.set_encoded(l_v_msg_txt);
2358: p_v_message_text := p_v_message_text||fnd_message.get;
2359: END LOOP;
2360: END IF;
2361: END IF;

Line 2358: p_v_message_text := p_v_message_text||fnd_message.get;

2354: ELSE
2355: FOR l_n_cntr IN 1..l_n_msg_count LOOP
2356: l_v_msg_txt := fnd_msg_pub.get(p_msg_index => l_n_cntr, p_encoded => 'T');
2357: fnd_message.set_encoded(l_v_msg_txt);
2358: p_v_message_text := p_v_message_text||fnd_message.get;
2359: END LOOP;
2360: END IF;
2361: END IF;
2362: END invoke_credits_api_pvt;

Line 2457: fnd_message.set_name('IGS',

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,
2460: fnd_message.get);
2461: fnd_file.put_line(fnd_file.log,

Line 2460: fnd_message.get);

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:
2464: -- Divide the PL/SQL table into Receipt and Receipt Overflow records.

Line 2543: fnd_message.set_name('IGS',

2539: l_b_val_err := TRUE;
2540: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2541: l_t_rc_tab(l_n_cntr).batch_name,
2542: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 2545: fnd_message.set_token('PARTY_NUMBER',

2541: l_t_rc_tab(l_n_cntr).batch_name,
2542: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 2548: fnd_message.get);

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:
2552: -- Validate if the Credit Type is valid credit type

Line 2566: fnd_message.set_name('IGS',

2562: l_b_val_err := TRUE;
2563: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2564: l_t_rc_tab(l_n_cntr).batch_name,
2565: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 2568: fnd_message.set_token('LOCKBOX_NAME',

2564: l_t_rc_tab(l_n_cntr).batch_name,
2565: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 2571: fnd_message.get);

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:
2575: -- For the Credit type code, get the mapped credit type id from the credit type

Line 2587: fnd_message.set_name('IGS',

2583: l_b_val_err := TRUE;
2584: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2585: l_t_rc_tab(l_n_cntr).batch_name,
2586: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 2589: fnd_message.set_token('CREDIT_TYPE_BANK_CODE',

2585: l_t_rc_tab(l_n_cntr).batch_name,
2586: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 2592: fnd_message.get);

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;
2596:

Line 2611: fnd_message.set_name('IGS',

2607: l_b_val_err := TRUE;
2608: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2609: l_t_rc_tab(l_n_cntr).batch_name,
2610: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 2613: fnd_message.set_token('CR_TYPE',

2609: l_t_rc_tab(l_n_cntr).batch_name,
2610: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 2616: fnd_message.get);

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
2620: -- are provided. If they are provided then it is an error.

Line 2647: fnd_message.set_name('IGS',

2643: l_b_val_err := TRUE;
2644: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2645: l_t_rc_tab(l_n_cntr).batch_name,
2646: l_t_rc_tab(l_n_cntr).item_number);
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);

Line 2649: fnd_message.set_token('CREDIT_CLASS',

2645: l_t_rc_tab(l_n_cntr).batch_name,
2646: l_t_rc_tab(l_n_cntr).item_number);
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:

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 2673: fnd_message.set_name('IGS',

2669: l_b_val_err := TRUE;
2670: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2671: l_t_rc_tab(l_n_cntr).batch_name,
2672: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 2675: fnd_message.set_token('CREDIT_CLASS',

2671: l_t_rc_tab(l_n_cntr).batch_name,
2672: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 2678: fnd_message.get);

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:
2682: IF l_v_credit_class IN (g_v_enr_deposit,

Line 2694: fnd_message.set_name('IGS',

2690: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2691: l_t_rc_tab(l_n_cntr).batch_name,
2692: l_t_rc_tab(l_n_cntr).item_number);
2693: IF l_v_credit_class = g_v_enr_deposit THEN
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,

Line 2696: fnd_message.set_token('PARTY_NUMBER',

2692: l_t_rc_tab(l_n_cntr).item_number);
2693: IF l_v_credit_class = g_v_enr_deposit THEN
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

Line 2699: fnd_message.get);

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');
2703: fnd_message.set_token('PARTY_NUMBER',

Line 2701: fnd_message.set_name('IGS',

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');
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,

Line 2703: fnd_message.set_token('PARTY_NUMBER',

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');
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;

Line 2706: fnd_message.get);

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;
2710: l_n_pay_cr_type_id := null;

Line 2723: fnd_message.set_name('IGS',

2719: l_b_val_err := TRUE;
2720: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2721: l_t_rc_tab(l_n_cntr).batch_name,
2722: l_t_rc_tab(l_n_cntr).item_number);
2723: fnd_message.set_name('IGS',
2724: 'IGS_FI_PCT_DCT_INVALID');
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',

Line 2725: fnd_message.set_token('PAY_CR_TYPE',

2721: l_t_rc_tab(l_n_cntr).batch_name,
2722: l_t_rc_tab(l_n_cntr).item_number);
2723: fnd_message.set_name('IGS',
2724: 'IGS_FI_PCT_DCT_INVALID');
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,

Line 2727: fnd_message.set_token('DEP_CR_TYPE',

2723: fnd_message.set_name('IGS',
2724: 'IGS_FI_PCT_DCT_INVALID');
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;

Line 2730: fnd_message.get);

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
2734: -- log file.

Line 2742: fnd_message.set_name('IGS',

2738: l_b_val_err := TRUE;
2739: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2740: l_t_rc_tab(l_n_cntr).batch_name,
2741: l_t_rc_tab(l_n_cntr).item_number);
2742: fnd_message.set_name('IGS',
2743: 'IGS_FI_INV_ADM_APPL_ID');
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',

Line 2744: fnd_message.set_token('ADMISSION_APPLICATION_ID',

2740: l_t_rc_tab(l_n_cntr).batch_name,
2741: l_t_rc_tab(l_n_cntr).item_number);
2742: fnd_message.set_name('IGS',
2743: 'IGS_FI_INV_ADM_APPL_ID');
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,

Line 2746: fnd_message.set_token('PARTY_NUMBER',

2742: fnd_message.set_name('IGS',
2743: 'IGS_FI_INV_ADM_APPL_ID');
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

Line 2749: fnd_message.get);

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;
2753: END IF;

Line 2767: fnd_message.set_name('IGS',

2763: l_b_val_err := TRUE;
2764: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
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

Line 2770: fnd_message.get);

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.
2774: l_t_rc_tab(l_n_cntr).gl_date := trunc(l_t_rc_tab(l_n_cntr).deposit_date);

Line 2783: fnd_message.set_name('IGS',

2779: l_b_val_err := TRUE;
2780: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
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

Line 2786: fnd_message.get);

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,
2790: l_t_rc_tab(l_n_cntr).batch_name,

Line 2792: fnd_message.set_name('IGS',

2788: l_b_val_err := TRUE;
2789: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2790: l_t_rc_tab(l_n_cntr).batch_name,
2791: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 2794: fnd_message.set_token('GL_DATE',

2790: l_t_rc_tab(l_n_cntr).batch_name,
2791: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 2797: fnd_message.get);

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
2801:

Line 2825: fnd_message.set_name('IGS',

2821: l_b_val_err := TRUE;
2822: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2823: l_t_rc_tab(l_n_cntr).batch_name,
2824: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 2827: fnd_message.set_token('FEE_CAL_INSTANCE_CODE',

2823: l_t_rc_tab(l_n_cntr).batch_name,
2824: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 2830: fnd_message.get);

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:
2834: -- If the Mapped Fee Cal Type can be derived, then check if it is a valid Fee calendar.

Line 2844: fnd_message.set_name('IGS',

2840: l_b_val_err := TRUE;
2841: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2842: l_t_rc_tab(l_n_cntr).batch_name,
2843: l_t_rc_tab(l_n_cntr).item_number);
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,

Line 2846: fnd_message.set_token('FEE_CAL_INSTANCE_CODE',

2842: l_t_rc_tab(l_n_cntr).batch_name,
2843: l_t_rc_tab(l_n_cntr).item_number);
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;

Line 2849: fnd_message.get);

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
2853: l_v_ld_cal_type := null;

Line 2868: fnd_message.set_name('IGS',

2864: l_b_val_err := TRUE;
2865: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
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;

Line 2871: fnd_message.get);

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;
2875:

Line 2887: fnd_message.set_name('IGS',

2883: l_b_val_err := TRUE;
2884: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
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;

Line 2890: fnd_message.get);

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
2894: IF NOT igs_fi_crdapi_util.validate_desc_flex(p_v_attribute_category => l_t_rc_tab(l_n_cntr).attribute_category,

Line 2920: fnd_message.set_name('IGS',

2916: l_b_val_err := TRUE;
2917: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
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;

Line 2923: fnd_message.get);

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
2927: -- If not then it is an error message.

Line 3428: fnd_message.set_name( 'IGS', 'IGS_FI_PP_NO_DEF_CRT' );

3424: l_t_rc_tab(l_n_cntr).batch_name,
3425: l_t_rc_tab(l_n_cntr).item_number);
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.

Line 3429: fnd_message.set_token( 'LOCKBOX_NAME', l_t_rc_tab(l_n_cntr).lockbox_name );

3425: l_t_rc_tab(l_n_cntr).item_number);
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;

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 3463: fnd_message.set_name( 'IGS', 'IGS_FI_PP_NO_DEF_CRT' );

3459: l_t_rc_tab(l_n_cntr).batch_name,
3460: l_t_rc_tab(l_n_cntr).item_number);
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.

Line 3464: fnd_message.set_token( 'LOCKBOX_NAME', l_t_rc_tab(l_n_cntr).lockbox_name );

3460: l_t_rc_tab(l_n_cntr).item_number);
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;

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 3999: fnd_message.set_name('IGS',

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,
4002: fnd_message.get);
4003: fnd_file.put_line(fnd_file.log,

Line 4002: fnd_message.get);

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;
4006: FOR l_n_cntr IN l_t_rc_tab.FIRST..l_t_rc_tab.LAST LOOP

Line 4490: fnd_message.set_name('IGS',

4486: ROLLBACK TO SP_LOCKBOX_MAIN;
4487:
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

Line 4493: fnd_message.get);

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
4497: fnd_message.set_name('IGS',

Line 4497: fnd_message.set_name('IGS',

4493: fnd_message.get);
4494: ELSE
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;

Line 4500: fnd_message.get);

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:
4504: -- If the test run is No and records exist, then commit

Line 4509: fnd_message.set_name('IGS',

4505: IF g_b_rec_exists THEN
4506: COMMIT;
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;

Line 4512: fnd_message.get);

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:
4516: -- Clear the global PL/SQL tables

Line 4525: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');

4521: -- Handle the Locking exception
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

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 4532: fnd_message.set_name('IGS',

4528: WHEN OTHERS THEN
4529: -- Handling the When Others Condition
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;

Line 4535: fnd_message.get||' - '||sqlerrm);

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,
4539: retcode OUT NOCOPY NUMBER,

Line 4596: fnd_message.set_name('IGS', 'IGS_FI_PRC_TEST_RUN');

4592: IF( l_n_record_count > 0 ) THEN
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;

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 4604: fnd_message.set_name('IGS', 'IGS_GE_NO_DATA_FOUND');

4600: COMMIT;
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;

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 4615: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');

4611: -- Handle the Locking exception
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

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 4623: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

4619: -- Handle Other Exceptions
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;

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;