DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_VALIDATE_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 25: g_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

21: ***************************************************************************/
22:
23: G_Pkg_Name VARCHAR2(30) := 'EAM_WO_NETWORK_VALIDATE_PVT';
24:
25: g_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
26: g_dummy NUMBER;
27:
28:
29: /*******************************************************************

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

939: l_user_defined_status := l_wo_status;
940: l_pending_flag := null;
941: END;
942:
943: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('workorder status'||l_wo_status); END IF;
944:
945: BEGIN
946: SELECT wdj.status_type
947: INTO l_parent_status

Line 956: 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;

952: and wdj.wip_entity_id = wsr.parent_object_id;
953:
954:
955:
956: 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;
957:
958: IF( ((l_parent_status=17) and (l_wo_status NOT IN (17,7,6)))
959: OR ((l_parent_status=1) and (l_wo_status NOT IN (17,7,1,6)))
960: OR ((l_parent_status IN (3,6)) and (l_wo_status NOT IN (3,6,17,7,1,12,14,15,4,5)))

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

964: OR ((l_parent_status NOT IN (3,6))and (l_user_defined_status IN(3) and l_pending_flag='Y'))
965: ) THEN
966: x_return_status:=FND_API.G_RET_STS_ERROR;
967: END IF;
968: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after parent status validation :'||x_return_status); END IF;
969:
970: EXCEPTION
971: WHEN NO_DATA_FOUND THEN
972: null;

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

1029: IF(l_invalid_child<>0) THEN
1030: x_return_status:=FND_API.G_RET_STS_ERROR;
1031: END IF;
1032:
1033: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after child status validation :'||x_return_status); END IF;
1034: END Validate_Status;
1035:
1036: -- Added for Detailed Scheduling.Validates the status of entire hierarchy
1037: PROCEDURE Validate_Network_Status

Line 1171: EAM_ERROR_MESSAGE_PVT.Write_Debug('after Validate_Network_Status status validation :'||x_return_status);

1167: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
1168: IF p_wo_relationship_exc_tbl.count >0 THEN
1169: x_return_status:=FND_API.G_RET_STS_ERROR;
1170: END IF;
1171: EAM_ERROR_MESSAGE_PVT.Write_Debug('after Validate_Network_Status status validation :'||x_return_status);
1172: END IF;
1173:
1174: END Validate_Network_Status;
1175: