DBA Data[Home] [Help]

APPS.EAM_PROCESS_FAILURE_ENTRY_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 919: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Start') ; END IF;

915: l_failure_id NUMBER;
916: l_api_version NUMBER := 1.0;
917: l_api_name VARCHAR2(200) := 'Delete_Failure_Entry';
918: BEGIN
919: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Start') ; END IF;
920:
921: -- API savepoint
922: SAVEPOINT Delete_Failure_Entry_pvt;
923:

Line 945: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Deleting the earlier failure data') ; END IF;

941: SELECT COUNT(1) INTO l_count FROM eam_asset_failures WHERE source_id = p_source_id;
942:
943: IF l_count >=1 THEN
944:
945: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Deleting the earlier failure data') ; END IF;
946:
947: SELECT failure_id INTO l_failure_id FROM eam_asset_failures WHERE source_id = p_source_id;
948:
949: DELETE FROM eam_asset_failure_codes eafc

Line 955: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Failure information doesn''t exist') ; END IF;

951:
952: DELETE FROM eam_asset_failures eaf
953: WHERE eaf.failure_id=l_failure_id;
954: ELSE
955: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Failure information doesn''t exist') ; END IF;
956: END IF;
957:
958: IF(p_commit = FND_API.G_TRUE) THEN
959: COMMIT;

Line 967: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Error in deleting the existing failure data:'||SQLERRM) ; END IF;

963:
964: EXCEPTION
965: WHEN OTHERS THEN
966: ROLLBACK TO Delete_Failure_Entry_pvt;
967: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Error in deleting the existing failure data:'||SQLERRM) ; END IF;
968: x_return_status := FND_API.G_RET_STS_ERROR;
969:
970: END Delete_Failure_Entry;
971: