APPS.AHL_UMP_SR_PVT dependencies on AHL_UTIL_UC_PKG

Line 413: SELECT ahl_util_uc_pkg.get_uc_header_id(l_customer_product_id) into l_uc_hdr_id from dual;

409: l_accomplished_date := SYSDATE;
410: END IF;
411:
412: /* retrieve active unit on which SR instance is installed */
413: SELECT ahl_util_uc_pkg.get_uc_header_id(l_customer_product_id) into l_uc_hdr_id from dual;
414: IF (l_uc_hdr_id is not null)
415: THEN
416: -- if the instance's unit is in QUARANTINE/DEACTIVATE_QUARANTINE throw error
417: -- if the instance's unit is COMPLETE/INCOMPLETE, it is active hence use the unit

Line 419: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(l_uc_hdr_id);

415: THEN
416: -- if the instance's unit is in QUARANTINE/DEACTIVATE_QUARANTINE throw error
417: -- if the instance's unit is COMPLETE/INCOMPLETE, it is active hence use the unit
418: -- for all other cases treat the NR as being created for IB component only, i.e. no unit info
419: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(l_uc_hdr_id);
420: IF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))
421: THEN
422: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_NR_UNIT_QUAR_INV');
423: FND_MSG_PUB.ADD;