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

Line 466: fnd_file.put_line(fnd_file.log,'For importing self service inquiry records:');

462: OPEN batch_id_cur;
463: FETCH batch_id_cur into l_batch_id;
464: CLOSE batch_id_cur;
465: l_batch_Desc := 'Self Service Inquiry import batch ' || IGS_GE_NUMBER.TO_CANN(l_batch_id);
466: fnd_file.put_line(fnd_file.log,'For importing self service inquiry records:');
467: fnd_file.put_line(fnd_file.log,'Batch Id : '||IGS_GE_NUMBER.TO_CANN(l_batch_id));
468: fnd_file.put_line(fnd_file.log,'Batch description : '||l_batch_desc);
469: BEGIN
470: INSERT INTO IGS_AD_IMP_BATCH_DET

Line 467: fnd_file.put_line(fnd_file.log,'Batch Id : '||IGS_GE_NUMBER.TO_CANN(l_batch_id));

463: FETCH batch_id_cur into l_batch_id;
464: CLOSE batch_id_cur;
465: l_batch_Desc := 'Self Service Inquiry import batch ' || IGS_GE_NUMBER.TO_CANN(l_batch_id);
466: fnd_file.put_line(fnd_file.log,'For importing self service inquiry records:');
467: fnd_file.put_line(fnd_file.log,'Batch Id : '||IGS_GE_NUMBER.TO_CANN(l_batch_id));
468: fnd_file.put_line(fnd_file.log,'Batch description : '||l_batch_desc);
469: BEGIN
470: INSERT INTO IGS_AD_IMP_BATCH_DET
471: ( batch_id,

Line 468: fnd_file.put_line(fnd_file.log,'Batch description : '||l_batch_desc);

464: CLOSE batch_id_cur;
465: l_batch_Desc := 'Self Service Inquiry import batch ' || IGS_GE_NUMBER.TO_CANN(l_batch_id);
466: fnd_file.put_line(fnd_file.log,'For importing self service inquiry records:');
467: fnd_file.put_line(fnd_file.log,'Batch Id : '||IGS_GE_NUMBER.TO_CANN(l_batch_id));
468: fnd_file.put_line(fnd_file.log,'Batch description : '||l_batch_desc);
469: BEGIN
470: INSERT INTO IGS_AD_IMP_BATCH_DET
471: ( batch_id,
472: batch_Desc,

Line 497: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_IMP_BATCH_DET failed '||SQLERRM);

493: fnd_global.conc_program_id,
494: sysdate);
495: EXCEPTION WHEN OTHERS THEN
496: l_status:=0;
497: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_IMP_BATCH_DET failed '||SQLERRM);
498: RAISE;
499: END;
500: END IF; --End of Batch ID null check
501:

Line 636: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_INTERFACE_ALL failed '||SQLERRM);

632: null
633: );
634: EXCEPTION WHEN OTHERS THEN
635: l_status:=0;
636: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_INTERFACE_ALL failed '||SQLERRM);
637: RAISE;
638: END;
639:
640: BEGIN

Line 732: fnd_file.put_line(fnd_file.log,'Insert on igs_ad_stat_int failed '||SQLERRM);

728: null
729: );
730: EXCEPTION WHEN OTHERS THEN
731: l_status:=0;
732: fnd_file.put_line(fnd_file.log,'Insert on igs_ad_stat_int failed '||SQLERRM);
733: RAISE;
734: END;
735:
736: ELSE /* l_status = 0 ie Validation failed*/

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

737: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
738: fnd_message.set_token('TABLE_NAME','igs_ad_interface_all');
739: fnd_message.set_token('COL_NAMES',l_tokenstr);
740: fnd_message.set_token('ID',inq_rec.inq_person_id);
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: RAISE null_validation_fails;
743: END IF;
744:
745: /* If atleast one of citizenship1_id and citizenship2_id is not null then Insert */

Line 797: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_CITIZEN_INT failed '||SQLERRM);

793: fnd_global.conc_request_id
794: );
795: EXCEPTION WHEN OTHERS THEN
796: l_status:=0;
797: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_CITIZEN_INT failed '||SQLERRM);
798: RAISE;
799: END;
800:
801:

Line 855: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_CITIZEN_INT failed '||SQLERRM);

851: fnd_global.conc_request_id
852: );
853: EXCEPTION WHEN OTHERS THEN
854: l_status:=0;
855: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_CITIZEN_INT failed '||SQLERRM);
856: RAISE;
857: END;
858:
859:

Line 987: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_APPL_INT failed '||SQLERRM);

983: inq_rec.source_promotion_id
984: );
985: EXCEPTION WHEN OTHERS THEN
986: l_status:=0;
987: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_APPL_INT failed '||SQLERRM);
988: RAISE;
989: END;
990: ELSE /* l_status = 0 i.e Validation failed*/
991: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

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

991: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
992: fnd_message.set_token('TABLE_NAME','igr_i_appl_int');
993: fnd_message.set_token('COL_NAMES',l_tokenstr);
994: fnd_message.set_token('ID',inq_rec.inq_person_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996: RAISE null_validation_fails;
997: END IF;
998:
999: /* if all the validations are successful so far update the Status of

Line 1067: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_CONTACTS_INT failed '||SQLERRM);

1063: inq_per_contacts_rec.phone_number
1064: );
1065: EXCEPTION WHEN OTHERS THEN
1066: l_status:=0;
1067: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_CONTACTS_INT failed '||SQLERRM);
1068: RAISE;
1069: END;
1070:
1071: END IF;

Line 1131: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_CONTACTS_INT failed '||SQLERRM);

1127: NULL
1128: );
1129: EXCEPTION WHEN OTHERS THEN
1130: l_status:=0;
1131: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_CONTACTS_INT failed '||SQLERRM);
1132: RAISE;
1133: END;
1134:
1135: END IF; -- kamohan Bug 2378114 End of Fix

Line 1225: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ADDR_INT failed '||SQLERRM);

1221: sysdate
1222: );
1223: EXCEPTION WHEN OTHERS THEN
1224: l_status:=0;
1225: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ADDR_INT failed '||SQLERRM);
1226: RAISE;
1227: END;
1228:
1229: ELSE /* l_status = 0 i.e Validation failed*/

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

1230: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1231: fnd_message.set_token('TABLE_NAME','igs_ad_addr_int');
1232: fnd_message.set_token('COL_NAMES',l_tokenstr);
1233: fnd_message.set_token('ID',inq_rec.inq_person_id);
1234: fnd_file.put_line(fnd_file.log,fnd_message.get);
1235: RAISE null_validation_fails;
1236: END IF;
1237:
1238: validate_addrusage_int(inq_per_addr_rec, l_status,l_tokenstr);

Line 1283: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ADDRUSAGE_INT failed '||SQLERRM);

1279: null
1280: );
1281: EXCEPTION WHEN OTHERS THEN
1282: l_status:=0;
1283: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ADDRUSAGE_INT failed '||SQLERRM);
1284: RAISE;
1285: END;
1286:
1287: UPDATE igr_is_address SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

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

1289: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1290: fnd_message.set_token('TABLE_NAME','igs_ad_addrusage_int');
1291: fnd_message.set_token('COL_NAMES',l_tokenstr);
1292: fnd_message.set_token('ID',inq_rec.inq_person_id);
1293: fnd_file.put_line(fnd_file.log,fnd_message.get);
1294: RAISE null_validation_fails;
1295: END IF;
1296: END LOOP;
1297:

Line 1423: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ACADHIS_INT failed '||SQLERRM);

1419: inq_per_acad_rec.selfrep_classsize
1420: );
1421: EXCEPTION WHEN OTHERS THEN
1422: l_status:=0;
1423: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ACADHIS_INT failed '||SQLERRM);
1424: RAISE;
1425: END;
1426:
1427: UPDATE igr_is_acad SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

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

1429: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1430: fnd_message.set_token('TABLE_NAME','igs_ad_acadhis_int');
1431: fnd_message.set_token('COL_NAMES',l_tokenstr);
1432: fnd_message.set_token('ID',inq_rec.inq_person_id);
1433: fnd_file.put_line(fnd_file.log,fnd_message.get);
1434: RAISE null_validation_fails;
1435: END IF;
1436: END LOOP;
1437:

Line 1518: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_EXCURR_INT failed '||SQLERRM);

1514: null
1515: );
1516: EXCEPTION WHEN OTHERS THEN
1517: l_status:=0;
1518: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_EXCURR_INT failed '||SQLERRM);
1519: RAISE;
1520: END;
1521:
1522: UPDATE igr_is_extracurr SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

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

1524: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1525: fnd_message.set_token('TABLE_NAME','igs_ad_excurr_int');
1526: fnd_message.set_token('COL_NAMES',l_tokenstr);
1527: fnd_message.set_token('ID',inq_rec.inq_person_id);
1528: fnd_file.put_line(fnd_file.log,fnd_message.get);
1529: RAISE null_validation_fails;
1530: END IF;
1531: END LOOP;
1532:

Line 1591: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_TEST_INT failed '||SQLERRM);

1587: sysdate
1588: );
1589: EXCEPTION WHEN OTHERS THEN
1590: l_status:=0;
1591: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_TEST_INT failed '||SQLERRM);
1592: RAISE;
1593: END;
1594:
1595: UPDATE igr_is_test SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

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

1597: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1598: fnd_message.set_token('TABLE_NAME','igs_ad_test_int');
1599: fnd_message.set_token('COL_NAMES',l_tokenstr);
1600: fnd_message.set_token('ID',inq_rec.inq_person_id);
1601: fnd_file.put_line(fnd_file.log,fnd_message.get);
1602: RAISE null_validation_fails;
1603: END IF;
1604: /*For each of the record from main cursor process the records in this cursor */
1605: FOR inq_per_testseg_rec IN INQ_PER_TESTSEG_CUR(inq_per_test_rec.inq_test_id) LOOP

Line 1667: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_TEST_SEGS_INT failed '||SQLERRM);

1663: inq_per_testseg_rec.test_score
1664: );
1665: EXCEPTION WHEN OTHERS THEN
1666: l_status:=0;
1667: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_TEST_SEGS_INT failed '||SQLERRM);
1668: RAISE;
1669: END;
1670:
1671: /* After Successful Insertion Update the corresponding Self Service table with STATUS as 'T' */

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

1674: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1675: fnd_message.set_token('TABLE_NAME','igs_ad_test_segs_int');
1676: fnd_message.set_token('COL_NAMES',l_tokenstr);
1677: fnd_message.set_token('ID',inq_per_test_rec.inq_test_id);
1678: fnd_file.put_line(fnd_file.log,fnd_message.get);
1679: RAISE null_validation_fails;
1680: END IF;
1681: END LOOP; /* inner FOR LOOP is closed here */
1682: END LOOP; /* Outer FOR LOOP is closed here */

Line 1726: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_PKG_INT failed '||SQLERRM);

1722: sysdate
1723: );
1724: EXCEPTION WHEN OTHERS THEN
1725: l_status:=0;
1726: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_PKG_INT failed '||SQLERRM);
1727: RAISE;
1728: END;
1729:
1730: UPDATE igr_is_info_req SET status = 'T' WHERE inq_inq_id = inq_rec.inq_inq_id;

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

1732: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1733: fnd_message.set_token('TABLE_NAME','igs_ad_inq_pkg_int');
1734: fnd_message.set_token('COL_NAMES',l_tokenstr);
1735: fnd_message.set_token('ID',inq_rec.inq_person_id);
1736: fnd_file.put_line(fnd_file.log,fnd_message.get);
1737: RAISE null_validation_fails;
1738: END IF;
1739: END LOOP;
1740:

Line 1786: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_LINES_INT failed '||SQLERRM);

1782: sysdate
1783: );
1784: EXCEPTION WHEN OTHERS THEN
1785: l_status:=0;
1786: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_LINES_INT failed '||SQLERRM);
1787: RAISE;
1788: END;
1789:
1790: UPDATE igr_is_i_lines SET status = 'T' WHERE inq_inq_id = inq_rec.inq_inq_id;

Line 1839: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_RACE_INT failed '||SQLERRM);

1835: null
1836: );
1837: EXCEPTION WHEN OTHERS THEN
1838: l_status:=0;
1839: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_RACE_INT failed '||SQLERRM);
1840: RAISE;
1841: END;
1842:
1843: UPDATE igr_is_race SET status = 'T' WHERE person_id = inq_rec.inq_person_id;

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

1845: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1846: fnd_message.set_token('TABLE_NAME','igs_pe_race_int');
1847: fnd_message.set_token('COL_NAMES',l_tokenstr);
1848: fnd_message.set_token('ID',inq_rec.inq_person_id);
1849: fnd_file.put_line(fnd_file.log,fnd_message.get);
1850: RAISE null_validation_fails;
1851: ELSE /* l_status = 0 i.e Validation failed due to null check */
1852:
1853: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

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

1853: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1854: fnd_message.set_token('TABLE_NAME','igs_pe_race_int');
1855: fnd_message.set_token('COL_NAMES',l_tokenstr);
1856: fnd_message.set_token('ID',inq_rec.inq_person_id);
1857: fnd_file.put_line(fnd_file.log,fnd_message.get);
1858:
1859: RAISE null_validation_fails;
1860: END IF;
1861: END LOOP;

Line 1883: fnd_file.put_line(fnd_file.log,'No Self Service Inquiries are available for import.');

1879: END; -- for inner BEGIN
1880: END LOOP; /* The outermost LOOP ends here */
1881:
1882: IF l_batch_id IS NULL THEN
1883: fnd_file.put_line(fnd_file.log,'No Self Service Inquiries are available for import.');
1884: END IF;
1885:
1886: /* If the Start Date is Greater than End date then Display corresponding message */
1887: ELSE

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

1893: WHEN date_validation_fails THEN
1894: retcode:=2;
1895: fnd_message.set_name('IGS','IGS_AD_STDATE_GT_ENDDATE_FAIL');
1896: igs_ge_msg_stack.add;
1897: fnd_file.put_line(fnd_file.log,fnd_message.get);
1898:
1899: WHEN OTHERS THEN
1900: ROLLBACK;
1901: retcode:=2;