APPS.IGS_OR_INST_IMP_003_PKG dependencies on APP_EXCEPTION

Line 274: APP_EXCEPTION.RAISE_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:
277:
278: --Procedure to process the Contacts

Line 771: APP_EXCEPTION.RAISE_EXCEPTION;

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;
773:
774: BEGIN
775:

Line 1097: APP_EXCEPTION.RAISE_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:
1100: --Procedure to Upload the Institution Statistics
1101: PROCEDURE process_institution_statistics (

Line 1347: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

1343: int_stat_det_rec.status:='1';
1344: update_int_stat_det(int_stat_det_rec);
1345:
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');

Line 1414: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

1410: int_stat_det_rec.error_code:=NULL;
1411: update_int_stat_det(int_stat_det_rec);
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,

Line 1490: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1492:
1493:
1494: --Procedure to process the Institution Addresses

Line 1940: APP_EXCEPTION.RAISE_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:
1943: END igs_or_inst_imp_003_pkg;