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_UC_PROC_REFERENCE_DATA dependencies on FND_MESSAGE

Line 51: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

47: -- initialize variables
48: g_success_rec_cnt := 0;
49: g_error_rec_cnt := 0;
50:
51: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
52: fnd_message.set_token('VIEW', 'REFERENCE CODES ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
53: fnd_file.put_line(fnd_file.log, fnd_message.get);
54:
55: -- Get all the reocords from interface table with status = 'N'

Line 52: fnd_message.set_token('VIEW', 'REFERENCE CODES ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

48: g_success_rec_cnt := 0;
49: g_error_rec_cnt := 0;
50:
51: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
52: fnd_message.set_token('VIEW', 'REFERENCE CODES ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
53: fnd_file.put_line(fnd_file.log, fnd_message.get);
54:
55: -- Get all the reocords from interface table with status = 'N'
56: FOR new_crfcode_rec IN int_crfcode_cur

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

49: g_error_rec_cnt := 0;
50:
51: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
52: fnd_message.set_token('VIEW', 'REFERENCE CODES ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
53: fnd_file.put_line(fnd_file.log, fnd_message.get);
54:
55: -- Get all the reocords from interface table with status = 'N'
56: FOR new_crfcode_rec IN int_crfcode_cur
57: LOOP

Line 66: fnd_message.set_name('IGS','IGS_UC_PROC_REFCODE_REC');

62: g_error_code := NULL;
63: l_valid_type := NULL;
64:
65: -- log record level processing message
66: fnd_message.set_name('IGS','IGS_UC_PROC_REFCODE_REC');
67: fnd_message.set_token('CODE', new_crfcode_rec.code);
68: fnd_message.set_token('TYPE', new_crfcode_rec.code_type);
69: fnd_file.put_line(fnd_file.log, fnd_message.get);
70:

Line 67: fnd_message.set_token('CODE', new_crfcode_rec.code);

63: l_valid_type := NULL;
64:
65: -- log record level processing message
66: fnd_message.set_name('IGS','IGS_UC_PROC_REFCODE_REC');
67: fnd_message.set_token('CODE', new_crfcode_rec.code);
68: fnd_message.set_token('TYPE', new_crfcode_rec.code_type);
69: fnd_file.put_line(fnd_file.log, fnd_message.get);
70:
71:

Line 68: fnd_message.set_token('TYPE', new_crfcode_rec.code_type);

64:
65: -- log record level processing message
66: fnd_message.set_name('IGS','IGS_UC_PROC_REFCODE_REC');
67: fnd_message.set_token('CODE', new_crfcode_rec.code);
68: fnd_message.set_token('TYPE', new_crfcode_rec.code_type);
69: fnd_file.put_line(fnd_file.log, fnd_message.get);
70:
71:
72: -- validate mandatory fields have values.

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

65: -- log record level processing message
66: fnd_message.set_name('IGS','IGS_UC_PROC_REFCODE_REC');
67: fnd_message.set_token('CODE', new_crfcode_rec.code);
68: fnd_message.set_token('TYPE', new_crfcode_rec.code_type);
69: fnd_file.put_line(fnd_file.log, fnd_message.get);
70:
71:
72: -- validate mandatory fields have values.
73: IF new_crfcode_rec.code_type IS NULL OR new_crfcode_rec.code IS NULL THEN

Line 194: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

190: EXCEPTION
191: -- Process should continue with processing of other view data
192: WHEN OTHERS THEN
193: ROLLBACK;
194: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
195: fnd_message.set_token('VIEW', 'REF CODES'||' - '||SQLERRM);
196: fnd_file.put_line(fnd_file.log, fnd_message.get);
197: END process_cvrefcodes;
198:

Line 195: fnd_message.set_token('VIEW', 'REF CODES'||' - '||SQLERRM);

191: -- Process should continue with processing of other view data
192: WHEN OTHERS THEN
193: ROLLBACK;
194: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
195: fnd_message.set_token('VIEW', 'REF CODES'||' - '||SQLERRM);
196: fnd_file.put_line(fnd_file.log, fnd_message.get);
197: END process_cvrefcodes;
198:
199:

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

192: WHEN OTHERS THEN
193: ROLLBACK;
194: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
195: fnd_message.set_token('VIEW', 'REF CODES'||' - '||SQLERRM);
196: fnd_file.put_line(fnd_file.log, fnd_message.get);
197: END process_cvrefcodes;
198:
199:
200:

Line 238: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

234: -- initialize variables
235: g_success_rec_cnt := 0;
236: g_error_rec_cnt := 0;
237:
238: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
239: fnd_message.set_token('VIEW', 'CVREFAWARDBODY ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
240: fnd_file.put_line(fnd_file.log, fnd_message.get);
241:
242: -- Get all the reocords from interface table with status = 'N'

Line 239: fnd_message.set_token('VIEW', 'CVREFAWARDBODY ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

235: g_success_rec_cnt := 0;
236: g_error_rec_cnt := 0;
237:
238: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
239: fnd_message.set_token('VIEW', 'CVREFAWARDBODY ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
240: fnd_file.put_line(fnd_file.log, fnd_message.get);
241:
242: -- Get all the reocords from interface table with status = 'N'
243: FOR new_awdbdy_rec IN int_awdbdy_cur LOOP

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

236: g_error_rec_cnt := 0;
237:
238: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
239: fnd_message.set_token('VIEW', 'CVREFAWARDBODY ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
240: fnd_file.put_line(fnd_file.log, fnd_message.get);
241:
242: -- Get all the reocords from interface table with status = 'N'
243: FOR new_awdbdy_rec IN int_awdbdy_cur LOOP
244:

Line 251: fnd_message.set_name('IGS','IGS_UC_PROC_REFAWD_REC');

247: l_rowid := NULL;
248: g_error_code := NULL;
249:
250: -- log record level processing message
251: fnd_message.set_name('IGS','IGS_UC_PROC_REFAWD_REC');
252: fnd_message.set_token('YEAR', new_awdbdy_rec.year);
253: fnd_message.set_token('SITTING', new_awdbdy_rec.sitting);
254: fnd_message.set_token('AWDBDY', new_awdbdy_rec.awardingbody);
255: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 252: fnd_message.set_token('YEAR', new_awdbdy_rec.year);

248: g_error_code := NULL;
249:
250: -- log record level processing message
251: fnd_message.set_name('IGS','IGS_UC_PROC_REFAWD_REC');
252: fnd_message.set_token('YEAR', new_awdbdy_rec.year);
253: fnd_message.set_token('SITTING', new_awdbdy_rec.sitting);
254: fnd_message.set_token('AWDBDY', new_awdbdy_rec.awardingbody);
255: fnd_file.put_line(fnd_file.log, fnd_message.get);
256:

Line 253: fnd_message.set_token('SITTING', new_awdbdy_rec.sitting);

249:
250: -- log record level processing message
251: fnd_message.set_name('IGS','IGS_UC_PROC_REFAWD_REC');
252: fnd_message.set_token('YEAR', new_awdbdy_rec.year);
253: fnd_message.set_token('SITTING', new_awdbdy_rec.sitting);
254: fnd_message.set_token('AWDBDY', new_awdbdy_rec.awardingbody);
255: fnd_file.put_line(fnd_file.log, fnd_message.get);
256:
257:

Line 254: fnd_message.set_token('AWDBDY', new_awdbdy_rec.awardingbody);

250: -- log record level processing message
251: fnd_message.set_name('IGS','IGS_UC_PROC_REFAWD_REC');
252: fnd_message.set_token('YEAR', new_awdbdy_rec.year);
253: fnd_message.set_token('SITTING', new_awdbdy_rec.sitting);
254: fnd_message.set_token('AWDBDY', new_awdbdy_rec.awardingbody);
255: fnd_file.put_line(fnd_file.log, fnd_message.get);
256:
257:
258: -- validate mandatory fields have values.

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

251: fnd_message.set_name('IGS','IGS_UC_PROC_REFAWD_REC');
252: fnd_message.set_token('YEAR', new_awdbdy_rec.year);
253: fnd_message.set_token('SITTING', new_awdbdy_rec.sitting);
254: fnd_message.set_token('AWDBDY', new_awdbdy_rec.awardingbody);
255: fnd_file.put_line(fnd_file.log, fnd_message.get);
256:
257:
258: -- validate mandatory fields have values.
259: IF new_awdbdy_rec.year IS NULL OR new_awdbdy_rec.sitting IS NULL OR new_awdbdy_rec.awardingbody IS NULL THEN

Line 363: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

359: EXCEPTION
360: -- Process should continue with processing of other view data
361: WHEN OTHERS THEN
362: ROLLBACK;
363: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
364: fnd_message.set_token('VIEW', 'CVREFAWARDBODY'||' - '||SQLERRM);
365: fnd_file.put_line(fnd_file.log, fnd_message.get);
366: END process_cvrefawardbody;
367:

Line 364: fnd_message.set_token('VIEW', 'CVREFAWARDBODY'||' - '||SQLERRM);

360: -- Process should continue with processing of other view data
361: WHEN OTHERS THEN
362: ROLLBACK;
363: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
364: fnd_message.set_token('VIEW', 'CVREFAWARDBODY'||' - '||SQLERRM);
365: fnd_file.put_line(fnd_file.log, fnd_message.get);
366: END process_cvrefawardbody;
367:
368:

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

361: WHEN OTHERS THEN
362: ROLLBACK;
363: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
364: fnd_message.set_token('VIEW', 'CVREFAWARDBODY'||' - '||SQLERRM);
365: fnd_file.put_line(fnd_file.log, fnd_message.get);
366: END process_cvrefawardbody;
367:
368:
369:

Line 401: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

397: -- initialize variables
398: g_success_rec_cnt := 0;
399: g_error_rec_cnt := 0;
400:
401: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
402: fnd_message.set_token('VIEW', 'CVREFAPR ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
403: fnd_file.put_line(fnd_file.log, fnd_message.get);
404:
405: -- Get all the reocords from interface table with status = 'N'

Line 402: fnd_message.set_token('VIEW', 'CVREFAPR ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

398: g_success_rec_cnt := 0;
399: g_error_rec_cnt := 0;
400:
401: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
402: fnd_message.set_token('VIEW', 'CVREFAPR ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
403: fnd_file.put_line(fnd_file.log, fnd_message.get);
404:
405: -- Get all the reocords from interface table with status = 'N'
406: FOR new_refapr_rec IN int_refapr_cur LOOP

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

399: g_error_rec_cnt := 0;
400:
401: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
402: fnd_message.set_token('VIEW', 'CVREFAPR ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
403: fnd_file.put_line(fnd_file.log, fnd_message.get);
404:
405: -- Get all the reocords from interface table with status = 'N'
406: FOR new_refapr_rec IN int_refapr_cur LOOP
407:

Line 415: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');

411: l_rowid := NULL;
412: g_error_code := NULL;
413:
414: -- log record level processing message
415: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
416: fnd_message.set_token('KEY', 'DOM');
417: fnd_message.set_token('VALUE', new_refapr_rec.dom);
418: fnd_file.put_line(fnd_file.log, fnd_message.get);
419:

Line 416: fnd_message.set_token('KEY', 'DOM');

412: g_error_code := NULL;
413:
414: -- log record level processing message
415: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
416: fnd_message.set_token('KEY', 'DOM');
417: fnd_message.set_token('VALUE', new_refapr_rec.dom);
418: fnd_file.put_line(fnd_file.log, fnd_message.get);
419:
420:

Line 417: fnd_message.set_token('VALUE', new_refapr_rec.dom);

413:
414: -- log record level processing message
415: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
416: fnd_message.set_token('KEY', 'DOM');
417: fnd_message.set_token('VALUE', new_refapr_rec.dom);
418: fnd_file.put_line(fnd_file.log, fnd_message.get);
419:
420:
421: -- validate mandatory fields have values.

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

414: -- log record level processing message
415: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
416: fnd_message.set_token('KEY', 'DOM');
417: fnd_message.set_token('VALUE', new_refapr_rec.dom);
418: fnd_file.put_line(fnd_file.log, fnd_message.get);
419:
420:
421: -- validate mandatory fields have values.
422: IF new_refapr_rec.dom IS NULL THEN

Line 520: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

516: EXCEPTION
517: -- Process should continue with processing of other view data
518: WHEN OTHERS THEN
519: ROLLBACK;
520: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
521: fnd_message.set_token('VIEW', 'CVREFAPR'||' - '||SQLERRM);
522: fnd_file.put_line(fnd_file.log, fnd_message.get);
523: END process_cvrefapr;
524:

Line 521: fnd_message.set_token('VIEW', 'CVREFAPR'||' - '||SQLERRM);

517: -- Process should continue with processing of other view data
518: WHEN OTHERS THEN
519: ROLLBACK;
520: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
521: fnd_message.set_token('VIEW', 'CVREFAPR'||' - '||SQLERRM);
522: fnd_file.put_line(fnd_file.log, fnd_message.get);
523: END process_cvrefapr;
524:
525:

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

518: WHEN OTHERS THEN
519: ROLLBACK;
520: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
521: fnd_message.set_token('VIEW', 'CVREFAPR'||' - '||SQLERRM);
522: fnd_file.put_line(fnd_file.log, fnd_message.get);
523: END process_cvrefapr;
524:
525:
526: PROCEDURE process_cvrefkeyword IS

Line 555: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

551: -- initialize variables
552: g_success_rec_cnt := 0;
553: g_error_rec_cnt := 0;
554:
555: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
556: fnd_message.set_token('VIEW', 'CVREFKEYWORD ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
557: fnd_file.put_line(fnd_file.log, fnd_message.get);
558:
559: -- Get all the reocords from interface table with status = 'N'

Line 556: fnd_message.set_token('VIEW', 'CVREFKEYWORD ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

552: g_success_rec_cnt := 0;
553: g_error_rec_cnt := 0;
554:
555: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
556: fnd_message.set_token('VIEW', 'CVREFKEYWORD ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
557: fnd_file.put_line(fnd_file.log, fnd_message.get);
558:
559: -- Get all the reocords from interface table with status = 'N'
560: FOR new_refkwd_rec IN int_refkwd_cur LOOP

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

553: g_error_rec_cnt := 0;
554:
555: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
556: fnd_message.set_token('VIEW', 'CVREFKEYWORD ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
557: fnd_file.put_line(fnd_file.log, fnd_message.get);
558:
559: -- Get all the reocords from interface table with status = 'N'
560: FOR new_refkwd_rec IN int_refkwd_cur LOOP
561:

Line 568: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');

564: l_rowid := NULL;
565: g_error_code := NULL;
566:
567: -- log record level processing message
568: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
569: fnd_message.set_token('KEY', 'KEYWORD');
570: fnd_message.set_token('VALUE', new_refkwd_rec.keyword);
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572:

Line 569: fnd_message.set_token('KEY', 'KEYWORD');

565: g_error_code := NULL;
566:
567: -- log record level processing message
568: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
569: fnd_message.set_token('KEY', 'KEYWORD');
570: fnd_message.set_token('VALUE', new_refkwd_rec.keyword);
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572:
573:

Line 570: fnd_message.set_token('VALUE', new_refkwd_rec.keyword);

566:
567: -- log record level processing message
568: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
569: fnd_message.set_token('KEY', 'KEYWORD');
570: fnd_message.set_token('VALUE', new_refkwd_rec.keyword);
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572:
573:
574: -- validate mandatory fields have values.

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

567: -- log record level processing message
568: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
569: fnd_message.set_token('KEY', 'KEYWORD');
570: fnd_message.set_token('VALUE', new_refkwd_rec.keyword);
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572:
573:
574: -- validate mandatory fields have values.
575: IF new_refkwd_rec.keyword IS NULL THEN

Line 668: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

664: EXCEPTION
665: -- Process should continue with processing of other view data
666: WHEN OTHERS THEN
667: ROLLBACK;
668: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
669: fnd_message.set_token('VIEW', 'CVREFKEYWORD'||' - '||SQLERRM);
670: fnd_file.put_line(fnd_file.log, fnd_message.get);
671: END process_cvrefkeyword;
672:

Line 669: fnd_message.set_token('VIEW', 'CVREFKEYWORD'||' - '||SQLERRM);

665: -- Process should continue with processing of other view data
666: WHEN OTHERS THEN
667: ROLLBACK;
668: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
669: fnd_message.set_token('VIEW', 'CVREFKEYWORD'||' - '||SQLERRM);
670: fnd_file.put_line(fnd_file.log, fnd_message.get);
671: END process_cvrefkeyword;
672:
673:

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

666: WHEN OTHERS THEN
667: ROLLBACK;
668: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
669: fnd_message.set_token('VIEW', 'CVREFKEYWORD'||' - '||SQLERRM);
670: fnd_file.put_line(fnd_file.log, fnd_message.get);
671: END process_cvrefkeyword;
672:
673:
674: PROCEDURE process_cvrefpocc IS

Line 711: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

707: -- initialize variables
708: g_success_rec_cnt := 0;
709: g_error_rec_cnt := 0;
710:
711: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
712: fnd_message.set_token('VIEW', 'CVREFPOCC ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
713: fnd_file.put_line(fnd_file.log, fnd_message.get);
714:
715: -- Get all the reocords from interface table with status = 'N'

Line 712: fnd_message.set_token('VIEW', 'CVREFPOCC ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

708: g_success_rec_cnt := 0;
709: g_error_rec_cnt := 0;
710:
711: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
712: fnd_message.set_token('VIEW', 'CVREFPOCC ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
713: fnd_file.put_line(fnd_file.log, fnd_message.get);
714:
715: -- Get all the reocords from interface table with status = 'N'
716: FOR new_refpocc_rec IN int_refpocc_cur LOOP

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

709: g_error_rec_cnt := 0;
710:
711: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
712: fnd_message.set_token('VIEW', 'CVREFPOCC ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
713: fnd_file.put_line(fnd_file.log, fnd_message.get);
714:
715: -- Get all the reocords from interface table with status = 'N'
716: FOR new_refpocc_rec IN int_refpocc_cur LOOP
717:

Line 725: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');

721: l_rowid := NULL;
722: g_error_code := NULL;
723:
724: -- log record level processing message
725: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
726: fnd_message.set_token('KEY', 'POCC');
727: fnd_message.set_token('VALUE', new_refpocc_rec.pocc);
728: fnd_file.put_line(fnd_file.log, fnd_message.get);
729:

Line 726: fnd_message.set_token('KEY', 'POCC');

722: g_error_code := NULL;
723:
724: -- log record level processing message
725: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
726: fnd_message.set_token('KEY', 'POCC');
727: fnd_message.set_token('VALUE', new_refpocc_rec.pocc);
728: fnd_file.put_line(fnd_file.log, fnd_message.get);
729:
730:

Line 727: fnd_message.set_token('VALUE', new_refpocc_rec.pocc);

723:
724: -- log record level processing message
725: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
726: fnd_message.set_token('KEY', 'POCC');
727: fnd_message.set_token('VALUE', new_refpocc_rec.pocc);
728: fnd_file.put_line(fnd_file.log, fnd_message.get);
729:
730:
731: -- validate mandatory fields have values.

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

724: -- log record level processing message
725: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
726: fnd_message.set_token('KEY', 'POCC');
727: fnd_message.set_token('VALUE', new_refpocc_rec.pocc);
728: fnd_file.put_line(fnd_file.log, fnd_message.get);
729:
730:
731: -- validate mandatory fields have values.
732: IF new_refpocc_rec.pocc IS NULL THEN

Line 838: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

834:
835: EXCEPTION
836: WHEN OTHERS THEN
837: ROLLBACK;
838: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
839: fnd_message.set_token('VIEW', 'CVREFPOCC'||' - '||SQLERRM);
840: fnd_file.put_line(fnd_file.log, fnd_message.get);
841: END process_cvrefpocc;
842:

Line 839: fnd_message.set_token('VIEW', 'CVREFPOCC'||' - '||SQLERRM);

835: EXCEPTION
836: WHEN OTHERS THEN
837: ROLLBACK;
838: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
839: fnd_message.set_token('VIEW', 'CVREFPOCC'||' - '||SQLERRM);
840: fnd_file.put_line(fnd_file.log, fnd_message.get);
841: END process_cvrefpocc;
842:
843:

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

836: WHEN OTHERS THEN
837: ROLLBACK;
838: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
839: fnd_message.set_token('VIEW', 'CVREFPOCC'||' - '||SQLERRM);
840: fnd_file.put_line(fnd_file.log, fnd_message.get);
841: END process_cvrefpocc;
842:
843:
844:

Line 939: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

935: -- initialize variables
936: g_success_rec_cnt := 0;
937: g_error_rec_cnt := 0;
938:
939: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
940: fnd_message.set_token('VIEW', 'CVREFOFFERABBREV ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
941: fnd_file.put_line(fnd_file.log, fnd_message.get);
942:
943: -- Get all the reocords from interface table with status = 'N'

Line 940: fnd_message.set_token('VIEW', 'CVREFOFFERABBREV ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

936: g_success_rec_cnt := 0;
937: g_error_rec_cnt := 0;
938:
939: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
940: fnd_message.set_token('VIEW', 'CVREFOFFERABBREV ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
941: fnd_file.put_line(fnd_file.log, fnd_message.get);
942:
943: -- Get all the reocords from interface table with status = 'N'
944: FOR new_refoffab_rec IN int_refoffab_cur LOOP

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

937: g_error_rec_cnt := 0;
938:
939: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
940: fnd_message.set_token('VIEW', 'CVREFOFFERABBREV ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
941: fnd_file.put_line(fnd_file.log, fnd_message.get);
942:
943: -- Get all the reocords from interface table with status = 'N'
944: FOR new_refoffab_rec IN int_refoffab_cur LOOP
945:

Line 954: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');

950: g_error_code := NULL;
951: old_refoffab_rec := NULL;
952:
953: -- log record level processing message
954: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
955: fnd_message.set_token('KEY', 'Abbreviation Code');
956: fnd_message.set_token('VALUE', new_refoffab_rec.abbrevcode);
957: fnd_file.put_line(fnd_file.log, fnd_message.get);
958:

Line 955: fnd_message.set_token('KEY', 'Abbreviation Code');

951: old_refoffab_rec := NULL;
952:
953: -- log record level processing message
954: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
955: fnd_message.set_token('KEY', 'Abbreviation Code');
956: fnd_message.set_token('VALUE', new_refoffab_rec.abbrevcode);
957: fnd_file.put_line(fnd_file.log, fnd_message.get);
958:
959:

Line 956: fnd_message.set_token('VALUE', new_refoffab_rec.abbrevcode);

952:
953: -- log record level processing message
954: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
955: fnd_message.set_token('KEY', 'Abbreviation Code');
956: fnd_message.set_token('VALUE', new_refoffab_rec.abbrevcode);
957: fnd_file.put_line(fnd_file.log, fnd_message.get);
958:
959:
960: -- validate mandatory fields have values.

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

953: -- log record level processing message
954: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
955: fnd_message.set_token('KEY', 'Abbreviation Code');
956: fnd_message.set_token('VALUE', new_refoffab_rec.abbrevcode);
957: fnd_file.put_line(fnd_file.log, fnd_message.get);
958:
959:
960: -- validate mandatory fields have values.
961: IF new_refoffab_rec.abbrevcode IS NULL OR new_refoffab_rec.letterformat IS NULL THEN

Line 1074: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

1070:
1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: ROLLBACK;
1074: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1075: fnd_message.set_token('VIEW', 'CVREFOFFERABBREV'||' - '||SQLERRM);
1076: fnd_file.put_line(fnd_file.log, fnd_message.get);
1077: END process_cvrefofferabbrev;
1078:

Line 1075: fnd_message.set_token('VIEW', 'CVREFOFFERABBREV'||' - '||SQLERRM);

1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: ROLLBACK;
1074: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1075: fnd_message.set_token('VIEW', 'CVREFOFFERABBREV'||' - '||SQLERRM);
1076: fnd_file.put_line(fnd_file.log, fnd_message.get);
1077: END process_cvrefofferabbrev;
1078:
1079:

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

1072: WHEN OTHERS THEN
1073: ROLLBACK;
1074: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1075: fnd_message.set_token('VIEW', 'CVREFOFFERABBREV'||' - '||SQLERRM);
1076: fnd_file.put_line(fnd_file.log, fnd_message.get);
1077: END process_cvrefofferabbrev;
1078:
1079:
1080:

Line 1114: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

1110: -- initialize variables
1111: g_success_rec_cnt := 0;
1112: g_error_rec_cnt := 0;
1113:
1114: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1115: fnd_message.set_token('VIEW', 'CVREFSUBJ ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1116: fnd_file.put_line(fnd_file.log, fnd_message.get);
1117:
1118: -- Get all the reocords from interface table with status = 'N'

Line 1115: fnd_message.set_token('VIEW', 'CVREFSUBJ ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1111: g_success_rec_cnt := 0;
1112: g_error_rec_cnt := 0;
1113:
1114: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1115: fnd_message.set_token('VIEW', 'CVREFSUBJ ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1116: fnd_file.put_line(fnd_file.log, fnd_message.get);
1117:
1118: -- Get all the reocords from interface table with status = 'N'
1119: FOR new_refsubj_rec IN int_refsubj_cur LOOP

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

1112: g_error_rec_cnt := 0;
1113:
1114: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1115: fnd_message.set_token('VIEW', 'CVREFSUBJ ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1116: fnd_file.put_line(fnd_file.log, fnd_message.get);
1117:
1118: -- Get all the reocords from interface table with status = 'N'
1119: FOR new_refsubj_rec IN int_refsubj_cur LOOP
1120:

Line 1128: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');

1124: l_rowid := NULL;
1125: g_error_code := NULL;
1126:
1127: -- log record level processing message
1128: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1129: fnd_message.set_token('KEY', 'SUBJECT ');
1130: fnd_message.set_token('VALUE', new_refsubj_rec.subjcode);
1131: fnd_file.put_line(fnd_file.log, fnd_message.get);
1132:

Line 1129: fnd_message.set_token('KEY', 'SUBJECT ');

1125: g_error_code := NULL;
1126:
1127: -- log record level processing message
1128: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1129: fnd_message.set_token('KEY', 'SUBJECT ');
1130: fnd_message.set_token('VALUE', new_refsubj_rec.subjcode);
1131: fnd_file.put_line(fnd_file.log, fnd_message.get);
1132:
1133:

Line 1130: fnd_message.set_token('VALUE', new_refsubj_rec.subjcode);

1126:
1127: -- log record level processing message
1128: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1129: fnd_message.set_token('KEY', 'SUBJECT ');
1130: fnd_message.set_token('VALUE', new_refsubj_rec.subjcode);
1131: fnd_file.put_line(fnd_file.log, fnd_message.get);
1132:
1133:
1134: -- validate mandatory fields have values.

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

1127: -- log record level processing message
1128: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1129: fnd_message.set_token('KEY', 'SUBJECT ');
1130: fnd_message.set_token('VALUE', new_refsubj_rec.subjcode);
1131: fnd_file.put_line(fnd_file.log, fnd_message.get);
1132:
1133:
1134: -- validate mandatory fields have values.
1135: IF new_refsubj_rec.subjcode IS NULL OR new_refsubj_rec.SUBJTEXT IS NULL THEN

Line 1233: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: ROLLBACK;
1233: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1234: fnd_message.set_token('VIEW', 'CVREFSUBJ'||' - '||SQLERRM);
1235: fnd_file.put_line(fnd_file.log, fnd_message.get);
1236: END process_cvrefsubj;
1237:

Line 1234: fnd_message.set_token('VIEW', 'CVREFSUBJ'||' - '||SQLERRM);

1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: ROLLBACK;
1233: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1234: fnd_message.set_token('VIEW', 'CVREFSUBJ'||' - '||SQLERRM);
1235: fnd_file.put_line(fnd_file.log, fnd_message.get);
1236: END process_cvrefsubj;
1237:
1238:

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

1231: WHEN OTHERS THEN
1232: ROLLBACK;
1233: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1234: fnd_message.set_token('VIEW', 'CVREFSUBJ'||' - '||SQLERRM);
1235: fnd_file.put_line(fnd_file.log, fnd_message.get);
1236: END process_cvrefsubj;
1237:
1238:
1239:

Line 1276: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

1272: -- initialize variables
1273: g_success_rec_cnt := 0;
1274: g_error_rec_cnt := 0;
1275:
1276: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1277: fnd_message.set_token('VIEW', 'CVREFTARIFF ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1278: fnd_file.put_line(fnd_file.log, fnd_message.get);
1279:
1280: -- Get all the reocords from interface table with status = 'N'

Line 1277: fnd_message.set_token('VIEW', 'CVREFTARIFF ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1273: g_success_rec_cnt := 0;
1274: g_error_rec_cnt := 0;
1275:
1276: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1277: fnd_message.set_token('VIEW', 'CVREFTARIFF ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1278: fnd_file.put_line(fnd_file.log, fnd_message.get);
1279:
1280: -- Get all the reocords from interface table with status = 'N'
1281: FOR new_reftariff_rec IN int_reftariff_cur LOOP

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

1274: g_error_rec_cnt := 0;
1275:
1276: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1277: fnd_message.set_token('VIEW', 'CVREFTARIFF ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1278: fnd_file.put_line(fnd_file.log, fnd_message.get);
1279:
1280: -- Get all the reocords from interface table with status = 'N'
1281: FOR new_reftariff_rec IN int_reftariff_cur LOOP
1282:

Line 1289: fnd_message.set_name('IGS','IGS_UC_PROC_REFTARIFF_REC');

1285: g_error_code := NULL;
1286: old_tariff_rec := NULL;
1287:
1288: -- log record level processing message
1289: fnd_message.set_name('IGS','IGS_UC_PROC_REFTARIFF_REC');
1290: fnd_message.set_token('EXAMLVL' , new_reftariff_rec.examlevel);
1291: fnd_message.set_token('EXAMGRADE', new_reftariff_rec.examgrade);
1292: fnd_file.put_line(fnd_file.log, fnd_message.get);
1293:

Line 1290: fnd_message.set_token('EXAMLVL' , new_reftariff_rec.examlevel);

1286: old_tariff_rec := NULL;
1287:
1288: -- log record level processing message
1289: fnd_message.set_name('IGS','IGS_UC_PROC_REFTARIFF_REC');
1290: fnd_message.set_token('EXAMLVL' , new_reftariff_rec.examlevel);
1291: fnd_message.set_token('EXAMGRADE', new_reftariff_rec.examgrade);
1292: fnd_file.put_line(fnd_file.log, fnd_message.get);
1293:
1294: -- validate mandatory fields have values.

Line 1291: fnd_message.set_token('EXAMGRADE', new_reftariff_rec.examgrade);

1287:
1288: -- log record level processing message
1289: fnd_message.set_name('IGS','IGS_UC_PROC_REFTARIFF_REC');
1290: fnd_message.set_token('EXAMLVL' , new_reftariff_rec.examlevel);
1291: fnd_message.set_token('EXAMGRADE', new_reftariff_rec.examgrade);
1292: fnd_file.put_line(fnd_file.log, fnd_message.get);
1293:
1294: -- validate mandatory fields have values.
1295: IF new_reftariff_rec.examlevel IS NULL OR new_reftariff_rec.examgrade IS NULL OR new_reftariff_rec.tariffscore IS NULL THEN

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

1288: -- log record level processing message
1289: fnd_message.set_name('IGS','IGS_UC_PROC_REFTARIFF_REC');
1290: fnd_message.set_token('EXAMLVL' , new_reftariff_rec.examlevel);
1291: fnd_message.set_token('EXAMGRADE', new_reftariff_rec.examgrade);
1292: fnd_file.put_line(fnd_file.log, fnd_message.get);
1293:
1294: -- validate mandatory fields have values.
1295: IF new_reftariff_rec.examlevel IS NULL OR new_reftariff_rec.examgrade IS NULL OR new_reftariff_rec.tariffscore IS NULL THEN
1296: g_error_code := '1037';

Line 1393: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

1389:
1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: ROLLBACK;
1393: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1394: fnd_message.set_token('VIEW', 'CVREFTARIFF'||' - '||SQLERRM);
1395: fnd_file.put_line(fnd_file.log, fnd_message.get);
1396:
1397: END process_cvreftariff;

Line 1394: fnd_message.set_token('VIEW', 'CVREFTARIFF'||' - '||SQLERRM);

1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: ROLLBACK;
1393: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1394: fnd_message.set_token('VIEW', 'CVREFTARIFF'||' - '||SQLERRM);
1395: fnd_file.put_line(fnd_file.log, fnd_message.get);
1396:
1397: END process_cvreftariff;
1398:

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

1391: WHEN OTHERS THEN
1392: ROLLBACK;
1393: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1394: fnd_message.set_token('VIEW', 'CVREFTARIFF'||' - '||SQLERRM);
1395: fnd_file.put_line(fnd_file.log, fnd_message.get);
1396:
1397: END process_cvreftariff;
1398:
1399:

Line 1442: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

1438: -- initialize variables
1439: g_success_rec_cnt := 0;
1440: g_error_rec_cnt := 0;
1441:
1442: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1443: fnd_message.set_token('VIEW', 'CVJOINTADMISSIONS ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1444: fnd_file.put_line(fnd_file.log, fnd_message.get);
1445:
1446: -- Get all the reocords from interface table with status = 'N'

Line 1443: fnd_message.set_token('VIEW', 'CVJOINTADMISSIONS ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1439: g_success_rec_cnt := 0;
1440: g_error_rec_cnt := 0;
1441:
1442: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1443: fnd_message.set_token('VIEW', 'CVJOINTADMISSIONS ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1444: fnd_file.put_line(fnd_file.log, fnd_message.get);
1445:
1446: -- Get all the reocords from interface table with status = 'N'
1447: FOR new_cjntadm_rec IN int_cjntadm_cur LOOP

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

1440: g_error_rec_cnt := 0;
1441:
1442: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1443: fnd_message.set_token('VIEW', 'CVJOINTADMISSIONS ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1444: fnd_file.put_line(fnd_file.log, fnd_message.get);
1445:
1446: -- Get all the reocords from interface table with status = 'N'
1447: FOR new_cjntadm_rec IN int_cjntadm_cur LOOP
1448:

Line 1455: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');

1451: l_rowid := NULL;
1452: g_error_code := NULL;
1453:
1454: -- log record level processing message
1455: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1456: fnd_message.set_token('KEY' , 'CHILDINST ');
1457: fnd_message.set_token('VALUE', new_cjntadm_rec.childinst);
1458: fnd_file.put_line(fnd_file.log, fnd_message.get);
1459:

Line 1456: fnd_message.set_token('KEY' , 'CHILDINST ');

1452: g_error_code := NULL;
1453:
1454: -- log record level processing message
1455: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1456: fnd_message.set_token('KEY' , 'CHILDINST ');
1457: fnd_message.set_token('VALUE', new_cjntadm_rec.childinst);
1458: fnd_file.put_line(fnd_file.log, fnd_message.get);
1459:
1460:

Line 1457: fnd_message.set_token('VALUE', new_cjntadm_rec.childinst);

1453:
1454: -- log record level processing message
1455: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1456: fnd_message.set_token('KEY' , 'CHILDINST ');
1457: fnd_message.set_token('VALUE', new_cjntadm_rec.childinst);
1458: fnd_file.put_line(fnd_file.log, fnd_message.get);
1459:
1460:
1461: -- validate mandatory fields have values.

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

1454: -- log record level processing message
1455: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1456: fnd_message.set_token('KEY' , 'CHILDINST ');
1457: fnd_message.set_token('VALUE', new_cjntadm_rec.childinst);
1458: fnd_file.put_line(fnd_file.log, fnd_message.get);
1459:
1460:
1461: -- validate mandatory fields have values.
1462: IF new_cjntadm_rec.childinst IS NULL OR new_cjntadm_rec.parentinst1 IS NULL THEN

Line 1645: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

1641:
1642: EXCEPTION
1643: WHEN OTHERS THEN
1644: ROLLBACK;
1645: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1646: fnd_message.set_token('VIEW', 'CVJOINTADMISSIONS'||' - '||SQLERRM);
1647: fnd_file.put_line(fnd_file.log, fnd_message.get);
1648: END process_cvjointadmissions;
1649:

Line 1646: fnd_message.set_token('VIEW', 'CVJOINTADMISSIONS'||' - '||SQLERRM);

1642: EXCEPTION
1643: WHEN OTHERS THEN
1644: ROLLBACK;
1645: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1646: fnd_message.set_token('VIEW', 'CVJOINTADMISSIONS'||' - '||SQLERRM);
1647: fnd_file.put_line(fnd_file.log, fnd_message.get);
1648: END process_cvjointadmissions;
1649:
1650:

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

1643: WHEN OTHERS THEN
1644: ROLLBACK;
1645: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1646: fnd_message.set_token('VIEW', 'CVJOINTADMISSIONS'||' - '||SQLERRM);
1647: fnd_file.put_line(fnd_file.log, fnd_message.get);
1648: END process_cvjointadmissions;
1649:
1650:
1651: PROCEDURE process_cvrefcountry IS

Line 1682: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

1678: -- initialize variables
1679: g_success_rec_cnt := 0;
1680: g_error_rec_cnt := 0;
1681:
1682: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1683: fnd_message.set_token('VIEW', 'CVREFCOUNTRY ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1684: fnd_file.put_line(fnd_file.log, fnd_message.get);
1685:
1686: -- Get all the reocords from interface table with status = 'N'

Line 1683: fnd_message.set_token('VIEW', 'CVREFCOUNTRY ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1679: g_success_rec_cnt := 0;
1680: g_error_rec_cnt := 0;
1681:
1682: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1683: fnd_message.set_token('VIEW', 'CVREFCOUNTRY ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1684: fnd_file.put_line(fnd_file.log, fnd_message.get);
1685:
1686: -- Get all the reocords from interface table with status = 'N'
1687: FOR new_country_rec IN int_country_cur LOOP

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

1680: g_error_rec_cnt := 0;
1681:
1682: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1683: fnd_message.set_token('VIEW', 'CVREFCOUNTRY ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1684: fnd_file.put_line(fnd_file.log, fnd_message.get);
1685:
1686: -- Get all the reocords from interface table with status = 'N'
1687: FOR new_country_rec IN int_country_cur LOOP
1688:

Line 1695: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');

1691: l_rowid := NULL;
1692: g_error_code := NULL;
1693:
1694: -- log record level processing message
1695: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1696: fnd_message.set_token('KEY' , 'COUNTRY CODE');
1697: fnd_message.set_token('VALUE', new_country_rec.countrycode);
1698: fnd_file.put_line(fnd_file.log, fnd_message.get);
1699:

Line 1696: fnd_message.set_token('KEY' , 'COUNTRY CODE');

1692: g_error_code := NULL;
1693:
1694: -- log record level processing message
1695: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1696: fnd_message.set_token('KEY' , 'COUNTRY CODE');
1697: fnd_message.set_token('VALUE', new_country_rec.countrycode);
1698: fnd_file.put_line(fnd_file.log, fnd_message.get);
1699:
1700:

Line 1697: fnd_message.set_token('VALUE', new_country_rec.countrycode);

1693:
1694: -- log record level processing message
1695: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1696: fnd_message.set_token('KEY' , 'COUNTRY CODE');
1697: fnd_message.set_token('VALUE', new_country_rec.countrycode);
1698: fnd_file.put_line(fnd_file.log, fnd_message.get);
1699:
1700:
1701: -- validate mandatory fields have values.

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

1694: -- log record level processing message
1695: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1696: fnd_message.set_token('KEY' , 'COUNTRY CODE');
1697: fnd_message.set_token('VALUE', new_country_rec.countrycode);
1698: fnd_file.put_line(fnd_file.log, fnd_message.get);
1699:
1700:
1701: -- validate mandatory fields have values.
1702: IF new_country_rec.countrycode IS NULL THEN

Line 1799: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

1795:
1796: EXCEPTION
1797: WHEN OTHERS THEN
1798: ROLLBACK;
1799: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1800: fnd_message.set_token('VIEW', 'CVREFPRECOUNTRY'||' - '||SQLERRM);
1801: fnd_file.put_line(fnd_file.log, fnd_message.get);
1802: END process_cvrefcountry;
1803:

Line 1800: fnd_message.set_token('VIEW', 'CVREFPRECOUNTRY'||' - '||SQLERRM);

1796: EXCEPTION
1797: WHEN OTHERS THEN
1798: ROLLBACK;
1799: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1800: fnd_message.set_token('VIEW', 'CVREFPRECOUNTRY'||' - '||SQLERRM);
1801: fnd_file.put_line(fnd_file.log, fnd_message.get);
1802: END process_cvrefcountry;
1803:
1804:

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

1797: WHEN OTHERS THEN
1798: ROLLBACK;
1799: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1800: fnd_message.set_token('VIEW', 'CVREFPRECOUNTRY'||' - '||SQLERRM);
1801: fnd_file.put_line(fnd_file.log, fnd_message.get);
1802: END process_cvrefcountry;
1803:
1804:
1805: