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 IGS_OR_INST_IMP_001

Line 118: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

114: WHERE interface_inst_notes_id = p_int_notes_rec.interface_inst_notes_id;
115:
116: --put this information about the failed record in the log file too
117: IF p_int_notes_rec.status = '3' THEN
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,

Line 124: FND_MESSAGE.GET,NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
127: END update_int_notes;
128:

Line 258: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

254:
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);

Line 262: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
264: WHEN OTHERS THEN
265: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
266: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 265: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

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;
264: WHEN OTHERS THEN
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,

Line 272: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
274: APP_EXCEPTION.RAISE_EXCEPTION;
275: END process_institution_notes;
276:

Line 423: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

419: WHERE interface_contacts_id =p_interface_contacts_id;
420:
421: --put this information about the failed record in the log file too
422: IF p_status ='3' THEN
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,

Line 430: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_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;
432: END IF;
433:
434: END update_int_contact;

Line 499: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

495: --Rollback changes
496: ROLLBACK TO contact;
497: p_status := '3';
498:
499: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
500:
501: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
502: -- The following code checks what message is returned from the API in case of an exception.
503: -- It notes the message name and puts the same in the log file

Line 513: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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:
515: ELSE
516: p_error_code := 'E049';
517: -- Write the warning to log file --

Line 522: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
524:
525: END IF;
526: --Update the interface record status as 3

Line 609: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

605: WHERE interface_inst_cont_phone_id = p_int_phones_rec.interface_inst_cont_phone_id;
606:
607: --put this information about the failed record in the log file too
608: IF p_int_phones_rec.status='3' THEN
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,

Line 616: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_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;
618: END IF;
619: END update_int_phones;
620:

Line 710: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

706: l_val_fail_err_cd :='E047';
707: int_phones_rec.status:='3';
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,

Line 715: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
717:
718: RAISE SKIP_PHONE;
719: ELSE

Line 764: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

760: END;
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);

Line 768: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
770:
771: APP_EXCEPTION.RAISE_EXCEPTION;
772: END process_contact_phones;

Line 916: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

912: l_val_fail_err_cd :='E025';
913: int_cont_rec.status:='3';
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,

Line 921: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
923:
924: RAISE SKIP_CONTACT;
925: ELSE

Line 1023: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1019: l_val_fail_err_cd :='E024';
1020: int_cont_rec.status:='3';
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,

Line 1028: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
1030:
1031: RAISE SKIP_CONTACT;
1032: END IF;

Line 1084: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

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

Line 1088: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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

Line 1091: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

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

Line 1095: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
1097: APP_EXCEPTION.RAISE_EXCEPTION;
1098: END process_institution_contacts;
1099:

Line 1194: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1190: WHERE interface_inst_stat_id =p_int_stat_rec.interface_inst_stat_id;
1191:
1192: --put this information about the failed record in the log file too
1193: IF p_int_stat_rec.status='3' THEN
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,

Line 1201: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_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;
1203: END IF;
1204:
1205: END update_int_stat;

Line 1221: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1217: WHERE interface_inst_stat_dtl_id = p_int_stat_det_rec.interface_inst_stat_dtl_id;
1218:
1219: --put this information about the failed record in the log file too
1220: IF p_int_stat_det_rec.status='3' THEN
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,

Line 1228: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_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;
1230: END IF;
1231:
1232: END update_int_stat_det;

Line 1350: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1346: EXCEPTION --Handle Exception for Every Detail Record
1347: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
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,

Line 1355: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
1357:
1358: ROLLBACK TO stat_mast;
1359: RAISE SKIP_STAT_MAST;

Line 1416: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1412: --Handle Exception for every detail record processed
1413: 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,

Line 1421: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
1423:
1424: --Rollback changes
1425: ROLLBACK TO stat_mast;

Line 1473: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1469: 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);

Line 1477: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
1479:
1480: WHEN OTHERS THEN
1481: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

Line 1481: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1477: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1478: END IF;
1479:
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',

Line 1487: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
1489:
1490: APP_EXCEPTION.RAISE_EXCEPTION;
1491: END process_institution_statistics;

Line 1614: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1610: AND interface_addr_id= p_addr_id ;
1611:
1612: --put this information about the failed record in the log file too
1613: IF p_status='3' THEN
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,

Line 1621: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_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;
1623: END IF;
1624: END IF;
1625:

Line 1634: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1630: WHERE interface_addr_id= p_addr_id;
1631:
1632: --put this information about the failed record in the log file too
1633: IF p_status='3' THEN
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,

Line 1641: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_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;
1643: END IF;
1644:
1645: END IF;

Line 1698: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1694:
1695: IF l_return_status IN ('E','U') THEN
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,

Line 1703: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
1705:
1706: --Error in Address Record Status
1707: CLOSE c_val_addr_usage;

Line 1829: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1825: p_status => 'A'
1826: );
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,

Line 1834: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
1836:
1837: ROLLBACK TO address;
1838: --Error in Address Record Status

Line 1844: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1840: RAISE SKIP_ADDR;
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);

Line 1848: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
1850: --Error in Address Record Status
1851: update_address_int(p_interface_id,int_addr_rec.interface_addr_id,'4','E022',l_msg_data,'adr');
1852: END IF;

Line 1927: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

1923:
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);

Line 1931: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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

Line 1934: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN

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

Line 1938: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

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;
1940: APP_EXCEPTION.RAISE_EXCEPTION;
1941: END process_institution_address;
1942: