DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_PRD_UTIL_PKG

Line 1222: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => NULL,

1218:
1219:
1220: -- rroy
1221: -- ACL Changes
1222: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => NULL,
1223: p_ue_id => NULL,
1224: p_visit_id => NULL,
1225: p_item_instance_id => p_prd_workorder_rec.item_instance_id);
1226: IF l_return_status = FND_API.G_TRUE THEN

Line 7560: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,

7556: IF ( l_status_code = G_JOB_STATUS_UNRELEASED OR
7557: l_status_code = G_JOB_STATUS_DRAFT ) THEN
7558: -- rroy
7559: -- ACL Changes
7560: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
7561: p_ue_id => NULL,
7562: p_visit_id => NULL,
7563: p_item_instance_id => NULL);
7564:

Line 7596: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,

7592: IF ( l_sts_code = G_JOB_STATUS_UNRELEASED OR
7593: l_sts_code = G_JOB_STATUS_DRAFT ) THEN
7594: -- rroy
7595: -- ACL Changes
7596: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
7597: p_ue_id => NULL,
7598: p_visit_id => NULL,
7599: p_item_instance_id => NULL);
7600:

Line 7660: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,

7656: l_sts_code = G_JOB_STATUS_DRAFT ) THEN
7657: -- rroy
7658: -- ACL Changes
7659: -- skip the check for master workorders
7660: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
7661: p_ue_id => NULL,
7662: p_visit_id => NULL,
7663: p_item_instance_id => NULL);
7664:

Line 7696: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,

7692: IF ( l_status_code = G_JOB_STATUS_UNRELEASED OR
7693: l_status_code = G_JOB_STATUS_DRAFT ) THEN
7694: -- rroy
7695: -- ACL Changes
7696: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
7697: p_ue_id => NULL,
7698: p_visit_id => NULL,
7699: p_item_instance_id => NULL);
7700:

Line 7734: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,

7730: IF ( l_sts_code = G_JOB_STATUS_UNRELEASED OR
7731: l_sts_code = G_JOB_STATUS_DRAFT ) THEN
7732: -- rroy
7733: -- ACL Changes
7734: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
7735: p_ue_id => NULL,
7736: p_visit_id => NULL,
7737: p_item_instance_id => NULL);
7738: IF l_return_status = FND_API.G_TRUE THEN

Line 7796: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,

7792: l_sts_code = G_JOB_STATUS_DRAFT ) THEN
7793: -- rroy
7794: -- ACL Changes
7795: -- skip the check for master workorders
7796: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
7797: p_ue_id => NULL,
7798: p_visit_id => NULL,
7799: p_item_instance_id => NULL);
7800: IF l_return_status = FND_API.G_TRUE THEN

Line 7830: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,

7826: IF ( l_status_code = G_JOB_STATUS_UNRELEASED OR
7827: l_status_code = G_JOB_STATUS_DRAFT ) THEN
7828: -- rroy
7829: -- ACL Changes
7830: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
7831: p_ue_id => NULL,
7832: p_visit_id => NULL,
7833: p_item_instance_id => NULL);
7834: IF l_return_status = FND_API.G_TRUE THEN

Line 8663: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed = FND_API.G_FALSE THEN

8659: AHL_DEBUG_PUB.enable_debug;
8660: END IF;
8661:
8662: --sikumar: added for FP for ER 5571241 -- Check if user has permission to cancel jobs.
8663: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed = FND_API.G_FALSE THEN
8664: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_NOT_ALLOWED');
8665: FND_MSG_PUB.add;
8666: RAISE FND_API.G_EXC_ERROR;
8667: END IF;

Line 8740: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,

8736: CLOSE get_visit_mwo;
8737:
8738: -- rroy
8739: -- ACL Changes
8740: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
8741: p_ue_id => NULL,
8742: p_visit_id => NULL,
8743: p_item_instance_id => NULL);
8744: IF l_return_status = FND_API.G_TRUE THEN

Line 8860: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,

8856: l_sts_code <> G_JOB_STATUS_CLOSED AND
8857: l_sts_code <> G_JOB_STATUS_DELETED ) THEN
8858: -- rroy
8859: -- ACL Changes
8860: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
8861: p_ue_id => NULL,
8862: p_visit_id => NULL,
8863: p_item_instance_id => NULL);
8864: IF l_return_status = FND_API.G_TRUE THEN

Line 8888: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed(l_wo_id) = FND_API.G_FALSE THEN

8884: /* bug 5104519 - start */
8885: IF l_mwo_flag = 'N' THEN
8886:
8887: --sikumar: added for FP for ER 5571241 -- Check if user has permission to cancel jobs.
8888: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed(l_wo_id) = FND_API.G_FALSE THEN
8889: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_NOT_ALLOWED');
8890: FND_MSG_PUB.add;
8891: RAISE FND_API.G_EXC_ERROR;
8892: END IF;

Line 8972: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,

8968:
8969: CLOSE get_ue_mwo;
8970: -- rroy
8971: -- ACL Changes
8972: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
8973: p_ue_id => NULL,
8974: p_visit_id => NULL,
8975: p_item_instance_id => NULL);
8976: IF l_return_status = FND_API.G_TRUE THEN

Line 9022: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,

9018: l_sts_code <> G_JOB_STATUS_CLOSED AND
9019: l_sts_code <> G_JOB_STATUS_DELETED ) THEN
9020: -- rroy
9021: -- ACL Changes
9022: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
9023: p_ue_id => NULL,
9024: p_visit_id => NULL,
9025: p_item_instance_id => NULL);
9026: IF l_return_status = FND_API.G_TRUE THEN

Line 9050: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed(l_wo_id) = FND_API.G_FALSE THEN

9046: /* bug 5104519 - start */
9047: IF l_mwo_flag = 'N' THEN
9048:
9049: --sikumar: added for FP for ER 5571241 -- Check if user has permission to cancel jobs.
9050: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed(l_wo_id) = FND_API.G_FALSE THEN
9051: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_NOT_ALLOWED');
9052: FND_MSG_PUB.add;
9053: RAISE FND_API.G_EXC_ERROR;
9054: END IF;

Line 9169: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,

9165: -- Parent WO can be cancelled only if all the children are cancelled
9166: IF ( are_child_wos_cancelled( parent_csr.parent_object_id, l_workorder_tbl ) ) THEN
9167: -- rroy
9168: -- ACL Changes
9169: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
9170: p_ue_id => NULL,
9171: p_visit_id => NULL,
9172: p_item_instance_id => NULL);
9173: IF l_return_status = FND_API.G_TRUE THEN

Line 9330: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,

9326: RAISE FND_API.G_EXC_ERROR;
9327: END IF;
9328: -- rroy
9329: -- ACL Changes
9330: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
9331: p_ue_id => NULL,
9332: p_visit_id => NULL,
9333: p_item_instance_id => NULL);
9334: IF l_return_status = FND_API.G_TRUE THEN

Line 9346: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed(p_workorder_id) = FND_API.G_FALSE THEN

9342:
9343: CLOSE get_wo;
9344:
9345: --sikumar: added for FP for ER 5571241 -- Check if user has permission to cancel jobs.
9346: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed(p_workorder_id) = FND_API.G_FALSE THEN
9347: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_NOT_ALLOWED');
9348: FND_MSG_PUB.add;
9349: RAISE FND_API.G_EXC_ERROR;
9350: END IF;

Line 9444: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,

9440: -- Parent WO can be cancelled only if all the children are cancelled
9441: IF ( are_child_wos_cancelled( parent_csr.parent_object_id, l_workorder_tbl ) ) THEN
9442: -- rroy
9443: -- ACL Changes
9444: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
9445: p_ue_id => NULL,
9446: p_visit_id => NULL,
9447: p_item_instance_id => NULL);
9448: IF l_return_status = FND_API.G_TRUE THEN