APPS.AHL_UMP_SR_PVT dependencies on AHL_UTIL_UC_PKG

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

427: l_accomplished_date := SYSDATE;
428: END IF;
429:
430: /* retrieve active unit on which SR instance is installed */
431: SELECT ahl_util_uc_pkg.get_uc_header_id(l_customer_product_id) into l_uc_hdr_id from dual;
432: IF (l_uc_hdr_id is not null)
433: THEN
434: -- if the instance's unit is in QUARANTINE/DEACTIVATE_QUARANTINE throw error
435: -- if the instance's unit is COMPLETE/INCOMPLETE, it is active hence use the unit

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

433: THEN
434: -- if the instance's unit is in QUARANTINE/DEACTIVATE_QUARANTINE throw error
435: -- if the instance's unit is COMPLETE/INCOMPLETE, it is active hence use the unit
436: -- for all other cases treat the NR as being created for IB component only, i.e. no unit info
437: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(l_uc_hdr_id);
438: IF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))
439: THEN
440: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_NR_UNIT_QUAR_INV');
441: FND_MSG_PUB.ADD;