DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_PRD_UTIL_PKG

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

1104:
1105:
1106: -- rroy
1107: -- ACL Changes
1108: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => NULL,
1109: p_ue_id => NULL,
1110: p_visit_id => NULL,
1111: p_item_instance_id => p_prd_workorder_rec.item_instance_id);
1112: IF l_return_status = FND_API.G_TRUE THEN

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

5127: IF ( l_status_code = G_JOB_STATUS_UNRELEASED OR
5128: l_status_code = G_JOB_STATUS_DRAFT ) THEN
5129: -- rroy
5130: -- ACL Changes
5131: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
5132: p_ue_id => NULL,
5133: p_visit_id => NULL,
5134: p_item_instance_id => NULL);
5135:

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

5163: IF ( l_sts_code = G_JOB_STATUS_UNRELEASED OR
5164: l_sts_code = G_JOB_STATUS_DRAFT ) THEN
5165: -- rroy
5166: -- ACL Changes
5167: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
5168: p_ue_id => NULL,
5169: p_visit_id => NULL,
5170: p_item_instance_id => NULL);
5171:

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

5227: l_sts_code = G_JOB_STATUS_DRAFT ) THEN
5228: -- rroy
5229: -- ACL Changes
5230: -- skip the check for master workorders
5231: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
5232: p_ue_id => NULL,
5233: p_visit_id => NULL,
5234: p_item_instance_id => NULL);
5235:

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

5263: IF ( l_status_code = G_JOB_STATUS_UNRELEASED OR
5264: l_status_code = G_JOB_STATUS_DRAFT ) THEN
5265: -- rroy
5266: -- ACL Changes
5267: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
5268: p_ue_id => NULL,
5269: p_visit_id => NULL,
5270: p_item_instance_id => NULL);
5271:

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

5301: IF ( l_sts_code = G_JOB_STATUS_UNRELEASED OR
5302: l_sts_code = G_JOB_STATUS_DRAFT ) THEN
5303: -- rroy
5304: -- ACL Changes
5305: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
5306: p_ue_id => NULL,
5307: p_visit_id => NULL,
5308: p_item_instance_id => NULL);
5309: IF l_return_status = FND_API.G_TRUE THEN

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

5363: l_sts_code = G_JOB_STATUS_DRAFT ) THEN
5364: -- rroy
5365: -- ACL Changes
5366: -- skip the check for master workorders
5367: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
5368: p_ue_id => NULL,
5369: p_visit_id => NULL,
5370: p_item_instance_id => NULL);
5371: IF l_return_status = FND_API.G_TRUE THEN

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

5397: IF ( l_status_code = G_JOB_STATUS_UNRELEASED OR
5398: l_status_code = G_JOB_STATUS_DRAFT ) THEN
5399: -- rroy
5400: -- ACL Changes
5401: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
5402: p_ue_id => NULL,
5403: p_visit_id => NULL,
5404: p_item_instance_id => NULL);
5405: IF l_return_status = FND_API.G_TRUE THEN

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

6225: AHL_DEBUG_PUB.enable_debug;
6226: END IF;
6227:
6228: --sikumar: added for FP for ER 5571241 -- Check if user has permission to cancel jobs.
6229: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed = FND_API.G_FALSE THEN
6230: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_NOT_ALLOWED');
6231: FND_MSG_PUB.add;
6232: RAISE FND_API.G_EXC_ERROR;
6233: END IF;

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

6358: CLOSE get_visit_mwo;
6359:
6360: -- rroy
6361: -- ACL Changes
6362: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
6363: p_ue_id => NULL,
6364: p_visit_id => NULL,
6365: p_item_instance_id => NULL);
6366: IF l_return_status = FND_API.G_TRUE THEN

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

6407: l_sts_code <> G_JOB_STATUS_CLOSED AND
6408: l_sts_code <> G_JOB_STATUS_DELETED ) THEN
6409: -- rroy
6410: -- ACL Changes
6411: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
6412: p_ue_id => NULL,
6413: p_visit_id => NULL,
6414: p_item_instance_id => NULL);
6415: IF l_return_status = FND_API.G_TRUE THEN

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

6435: /* bug 5104519 - start */
6436: IF l_mwo_flag = 'N' THEN
6437:
6438: --sikumar: added for FP for ER 5571241 -- Check if user has permission to cancel jobs.
6439: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed(l_wo_id) = FND_API.G_FALSE THEN
6440: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_NOT_ALLOWED');
6441: FND_MSG_PUB.add;
6442: RAISE FND_API.G_EXC_ERROR;
6443: END IF;

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

6513:
6514: CLOSE get_ue_mwo;
6515: -- rroy
6516: -- ACL Changes
6517: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
6518: p_ue_id => NULL,
6519: p_visit_id => NULL,
6520: p_item_instance_id => NULL);
6521: IF l_return_status = FND_API.G_TRUE THEN

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

6563: l_sts_code <> G_JOB_STATUS_CLOSED AND
6564: l_sts_code <> G_JOB_STATUS_DELETED ) THEN
6565: -- rroy
6566: -- ACL Changes
6567: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
6568: p_ue_id => NULL,
6569: p_visit_id => NULL,
6570: p_item_instance_id => NULL);
6571: IF l_return_status = FND_API.G_TRUE THEN

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

6591: /* bug 5104519 - start */
6592: IF l_mwo_flag = 'N' THEN
6593:
6594: --sikumar: added for FP for ER 5571241 -- Check if user has permission to cancel jobs.
6595: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed(l_wo_id) = FND_API.G_FALSE THEN
6596: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_NOT_ALLOWED');
6597: FND_MSG_PUB.add;
6598: RAISE FND_API.G_EXC_ERROR;
6599: END IF;

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

6709: -- Parent WO can be cancelled only if all the children are cancelled
6710: IF ( are_child_wos_cancelled( parent_csr.parent_object_id, l_workorder_tbl ) ) THEN
6711: -- rroy
6712: -- ACL Changes
6713: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
6714: p_ue_id => NULL,
6715: p_visit_id => NULL,
6716: p_item_instance_id => NULL);
6717: IF l_return_status = FND_API.G_TRUE THEN

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

6870: RAISE FND_API.G_EXC_ERROR;
6871: END IF;
6872: -- rroy
6873: -- ACL Changes
6874: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id,
6875: p_ue_id => NULL,
6876: p_visit_id => NULL,
6877: p_item_instance_id => NULL);
6878: IF l_return_status = FND_API.G_TRUE THEN

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

6886:
6887: CLOSE get_wo;
6888:
6889: --sikumar: added for FP for ER 5571241 -- Check if user has permission to cancel jobs.
6890: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed(p_workorder_id) = FND_API.G_FALSE THEN
6891: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_NOT_ALLOWED');
6892: FND_MSG_PUB.add;
6893: RAISE FND_API.G_EXC_ERROR;
6894: END IF;

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

6984: -- Parent WO can be cancelled only if all the children are cancelled
6985: IF ( are_child_wos_cancelled( parent_csr.parent_object_id, l_workorder_tbl ) ) THEN
6986: -- rroy
6987: -- ACL Changes
6988: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_wo_id,
6989: p_ue_id => NULL,
6990: p_visit_id => NULL,
6991: p_item_instance_id => NULL);
6992: IF l_return_status = FND_API.G_TRUE THEN