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_OR_INST_IMP_003_PKG dependencies on FND_LOG

Line 38: logging mechanism using FND_LOG package

34: FND_MESSAGE.PARSE_ENCODED
35: c) Removed the check for 'IGS_AD_EVAL_XST_NO_PROSPCT'
36: d) Error code 'E162' is replaced with 'E049'
37: c) FND_FILE.PUT_LINE method calls replaced with
38: logging mechanism using FND_LOG package
39: gmaheswa 27-Jan-2006 Bug:4938278 : process_institution_address: Raise Address Change event at after processing address data of all persons.
40: gmaheswa 22-Jun-06 Bug 5189180: in process_institution_address, if igs_pe_person_addr_pkg.insert_row returns return_status as 'W' then set erro code E022.
41: ***************************************************************/
42:

Line 122: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

118: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
119: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
120: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_notes_rec.interface_inst_notes_id);
121: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
122: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
123: 'igs.plsql.igs_or_inst_imp_003.process_institution_notes.' || p_err_cd,
124: FND_MESSAGE.GET,NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
125: END IF;
126: END IF;

Line 259: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN
257: --log message that the party_id passed is Invalid, Party ID passed must be present in Hz_parties
258: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
259: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
260: 'igs.plsql.igs_or_inst_imp_003.process_institution_notes.nodatafound',
261: 'Invalid Party Id: '||p_party_id ||' ,Party ID passed must be present in HZ_parties' || SQLERRM,
262: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
263: END IF;

Line 269: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

265: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
266: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
267: FND_MESSAGE.SET_TOKEN('NAME','igs_or_inst_imp_003.process_institution_notes');
268:
269: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
270: 'igs.plsql.igs_or_inst_imp_003.process_institution_notes.others',
271: FND_MESSAGE.Get || '-' || SQLERRM,
272: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
273: END IF;

Line 427: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

423: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
424: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
425: FND_MESSAGE.SET_TOKEN('INT_ID', p_interface_contacts_id);
426: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_code);
427: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
428: 'igs.plsql.igs_or_inst_imp_003.update_int_contact.' || p_err_code,
429: FND_MESSAGE.GET,
430: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
431: END IF;

Line 510: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

506: IF l_message_name = 'IGS_AD_PROSPCT_XST_NO_EVAL' THEN
507: p_error_code := 'E049';
508: -- write in log message that the evaluator already exists
509: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROSPCT_XST_NO_EVAL');
510: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
511: 'igs.plsql.igs_or_inst_imp_003.associate_persontype.evalexst',
512: FND_MESSAGE.Get || '-' || SQLERRM,
513: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
514:

Line 519: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

515: ELSE
516: p_error_code := 'E049';
517: -- Write the warning to log file --
518: FND_MESSAGE.SET_NAME('IGS','IGS_OR_ERROR_PERSONTYPE');
519: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
520: 'igs.plsql.igs_or_inst_imp_003.associate_persontype.perstype',
521: FND_MESSAGE.Get || '-' || SQLERRM,
522: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
523: END IF;

Line 613: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

609: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
610: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
611: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_phones_rec.interface_inst_cont_phone_id);
612: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
613: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
614: 'igs.plsql.igs_or_inst_imp_003.update_int_phones.' || p_err_cd,
615: FND_MESSAGE.GET,
616: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
617: END IF;

Line 712: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

708: update_int_phones(int_phones_rec,l_val_fail_err_cd,NULL);
709:
710: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
711: FND_MESSAGE.SET_NAME('IGS','IGS_OR_PHONEINSERT_ERROR');
712: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
713: 'igs.plsql.igs_or_inst_imp_003.process_contact_phones.' || l_val_fail_err_cd,
714: 'contact phone id: ' || l_phone_id || '-' || FND_MESSAGE.GET || '-' || l_msg_dt,
715: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
716: END IF;

Line 765: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

761: END LOOP;
762: EXCEPTION
763: WHEN OTHERS THEN
764: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
765: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
766: 'igs.plsql.igs_or_inst_imp_003.process_contacts_phones.others',
767: SQLERRM,
768: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
769: END IF;

Line 918: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

914: Update_int_contact(int_cont_rec.status,int_cont_rec.interface_contacts_id,int_cont_rec.contact_party_id,l_val_fail_err_cd,NULL);
915:
916: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
917: FND_MESSAGE.SET_NAME('IGS','IGS_OR_CONTUPDATE_ERROR');
918: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
919: 'igs.plsql.igs_or_inst_imp_003.process_institution_contacts.' || l_val_fail_err_cd,
920: FND_MESSAGE.GET || '-' || l_msg_data,
921: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
922: END IF;

Line 1025: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1021: Update_int_contact(int_cont_rec.status,int_cont_rec.interface_contacts_id,int_cont_rec.contact_party_id,l_val_fail_err_cd,NULL);
1022:
1023: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1024: FND_MESSAGE.SET_NAME('IGS','IGS_OR_CONTINSERT_ERROR');
1025: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1026: 'igs.plsql.igs_or_inst_imp_003.process_institution_contacts.' || l_val_fail_err_cd ,
1027: FND_MESSAGE.GET || '-' || l_msg_data,
1028: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1029: END IF;

Line 1085: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1081: EXCEPTION
1082: WHEN NO_DATA_FOUND THEN
1083: --log message that the party_id passed is , Party ID passed must be present in Hz_partie
1084: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1085: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1086: 'igs.plsql.igs_or_inst_imp_003.process_institution_contacts.nodatafound',
1087: 'Invalid Party Id: '||p_party_id ||' ,Party ID passed must be present in HZ_parties - ' || SQLERRM,
1088: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1089: END IF;

Line 1092: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1088: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1089: END IF;
1090: WHEN OTHERS THEN
1091: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1092: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1093: 'igs.plsql.igs_or_inst_imp_003.process_institution_contacts.others',
1094: SQLERRM,
1095: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1096: END IF;

Line 1198: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1194: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1195: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1196: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_rec.interface_inst_stat_id);
1197: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_rec.error_code);
1198: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1199: 'igs.plsql.igs_or_inst_imp_003.update_int_stat.' || p_int_stat_rec.error_code,
1200: FND_MESSAGE.GET,
1201: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1202: END IF;

Line 1225: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1221: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1222: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1223: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_det_rec.interface_inst_stat_dtl_id);
1224: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_det_rec.error_code);
1225: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1226: 'igs.plsql.igs_or_inst_imp_003.update_int_stat_det.' || p_int_stat_det_rec.error_code,
1227: FND_MESSAGE.GET,
1228: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1229: END IF;

Line 1352: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1348: CLOSE cur_get_oss_stat_det;
1349:
1350: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1351: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_LOCKED');
1352: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1353: 'igs.plsql.igs_or_inst_imp_003.process_institution_statistics.recordlock1',
1354: FND_MESSAGE.GET || '-' || SQLERRM,
1355: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1356: END IF;

Line 1418: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1414: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1415: CLOSE cur_get_oss_stat_det;
1416: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1417: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_LOCKED');
1418: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1419: 'igs.plsql.igs_or_inst_imp_003.process_institution_statistics.recordlock2',
1420: FND_MESSAGE.GET || '-' || SQLERRM,
1421: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1422: END IF;

Line 1474: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1470: WHEN NO_DATA_FOUND THEN
1471: --log message that the party_id passed is Invalid, Party ID passed must be present in Hz_partie
1472:
1473: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1474: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1475: 'igs.plsql.igs_or_inst_imp_003.process_institution_statistics.nodatafound',
1476: 'Invalid Party Id: '||p_party_id ||' ,Party ID passed must be present in HZ_parties' || '-' || SQLERRM,
1477: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1478: END IF;

Line 1484: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1480: WHEN OTHERS THEN
1481: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1482: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1483: FND_MESSAGE.SET_TOKEN('NAME','igs_or_inst_imp_003.process_institution_statistics');
1484: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1485: 'igs.plsql.igs_or_inst_imp_003.process_institution_statistics.others',
1486: FND_MESSAGE.GET || '-' || SQLERRM,
1487: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1488: END IF;

Line 1618: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1614: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1615: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1616: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);
1617: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
1618: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1619: 'igs.plsql.igs_or_inst_imp_003.update_address_int.' || p_err_cd,
1620: FND_MESSAGE.GET,
1621: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1622: END IF;

Line 1638: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1634: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1635: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1636: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);
1637: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
1638: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1639: 'igs.plsql.igs_or_inst_imp_003.update_address_int.' || p_err_cd,
1640: FND_MESSAGE.GET,
1641: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1642: END IF;

Line 1700: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1696: --Error while associating the Address Usage with the Address
1697:
1698: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1699: FND_MESSAGE.SET_NAME('IGS','IGS_OR_USG_INSERT');
1700: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1701: 'igs.plsql.igs_or_inst_imp_003.insert_addr_usage.fail',
1702: FND_MESSAGE.GET || '-' || l_msg_data,
1703: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1704: END IF;

Line 1831: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1827:
1828: IF l_return_status IN ('E','U') THEN
1829: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1830: FND_MESSAGE.SET_NAME('IGS','IGS_OR_ADDR_NO_INSERT');
1831: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1832: 'igs.plsql.igs_or_inst_imp_003.process_institution_address.addrins',
1833: FND_MESSAGE.GET || '-' || l_msg_data,
1834: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1835: END IF;

Line 1845: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1841: ELSE
1842: IF l_return_status = 'W' THEN
1843: l_addr_warning := 'Y';
1844: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1845: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1846: 'igs.plsql.igs_or_inst_imp_003.process_institution_address.addrins',
1847: 'Warning: '|| '-' ||l_msg_data,
1848: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1849: END IF;

Line 1928: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1924: EXCEPTION
1925: WHEN NO_DATA_FOUND THEN
1926: --log message that the party_id passed is Invalid, Party ID passed must be present in Hz_partie
1927: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1928: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1929: 'igs.plsql.igs_or_inst_imp_003.process_institution_address.nodatafound',
1930: 'Invalid Party Id: '||p_party_id ||' ,Party ID passed must be present in HZ_parties - ' || SQLERRM,
1931: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1932: END IF;

Line 1935: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1931: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1932: END IF;
1933: WHEN OTHERS THEN
1934: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1935: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1936: 'igs.plsql.igs_or_inst_imp_003.process_institution_address.others',
1937: SQLERRM,
1938: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1939: END IF;