APPS.EAM_WO_NETWORK_VALIDATE_PVT dependencies on EAM_PROCESS_WO_PVT

Line 920: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('workorder status'||l_wo_status); END IF;

916: FROM wip_discrete_jobs wdj,eam_work_order_details_v ewod
917: WHERE wdj.wip_entity_id=p_work_object_id
918: and ewod.wip_entity_id=wdj.wip_entity_id;
919:
920: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('workorder status'||l_wo_status); END IF;
921:
922: BEGIN
923: SELECT wdj.status_type
924: INTO l_parent_status

Line 933: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('inside parent status validation :parent status'||l_parent_status); END IF;

929: and wdj.wip_entity_id = wsr.parent_object_id;
930:
931:
932:
933: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('inside parent status validation :parent status'||l_parent_status); END IF;
934:
935: IF( ((l_parent_status=17) and (l_wo_status NOT IN (17,7,6)))
936: OR ((l_parent_status=1) and (l_wo_status NOT IN (17,7,1,6)))
937: OR ((l_parent_status IN (3,6)) and (l_wo_status NOT IN (3,6,17,7,1,12,14,15,4,5)))

Line 945: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after parent status validation :'||x_return_status); END IF;

941: OR ((l_parent_status NOT IN (3,6))and (l_user_defined_status IN(3) and l_pending_flag='Y'))
942: ) THEN
943: x_return_status:=FND_API.G_RET_STS_ERROR;
944: END IF;
945: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after parent status validation :'||x_return_status); END IF;
946:
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
949: null;

Line 1010: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after child status validation :'||x_return_status); END IF;

1006: IF(l_invalid_child<>0) THEN
1007: x_return_status:=FND_API.G_RET_STS_ERROR;
1008: END IF;
1009:
1010: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after child status validation :'||x_return_status); END IF;
1011: END Validate_Status;
1012:
1013: -- Added for Detailed Scheduling.Validates the status of entire hierarchy
1014: PROCEDURE Validate_Network_Status

Line 1144: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN

1140: p_wo_relationship_exc_tbl => p_wo_relationship_exc_tbl
1141: );
1142: END LOOP;
1143:
1144: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
1145: IF p_wo_relationship_exc_tbl.count >0 THEN
1146: x_return_status:=FND_API.G_RET_STS_ERROR;
1147: END IF;
1148: EAM_ERROR_MESSAGE_PVT.Write_Debug('after Validate_Network_Status status validation :'||x_return_status);