51: * message.
52: *********************************************************************/
53:
54: PROCEDURE Check_Existence
55: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
56: , x_old_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
57: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
58: , x_return_status OUT NOCOPY VARCHAR2
59: )
52: *********************************************************************/
53:
54: PROCEDURE Check_Existence
55: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
56: , x_old_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
57: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
58: , x_return_status OUT NOCOPY VARCHAR2
59: )
60: IS
152: -- 02-May-2005 Anju Gupta IB/Transactable Asset changes for R12
153: **********************************************************************/
154:
155: PROCEDURE Check_Attributes_b4_Defaulting
156: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
157: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
158: , x_return_status OUT NOCOPY VARCHAR2
159: )
160: IS
574:
575: begin
576:
577: if p_eam_wo_rec.wip_entity_id is not null and
578: p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE
579: then
580: raise fnd_api.g_exc_error;
581: end if;
582:
637: -- Anju Gupta 05/03/05 IB/Transactable Asset changes for R12
638: **********************************************************************/
639:
640: PROCEDURE Check_Attributes
641: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
642: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
643: , x_return_status OUT NOCOPY VARCHAR2
644: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
645: )
638: **********************************************************************/
639:
640: PROCEDURE Check_Attributes
641: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
642: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
643: , x_return_status OUT NOCOPY VARCHAR2
644: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
645: )
646: IS
1799: -- primary_item_id (asset activity)
1800: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating asset_activity_id . . . '); END IF;
1801:
1802: declare
1803: l_eam_op_tbl EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE;
1804: l_mat_req_exists number;
1805: l_serial_number_control NUMBER := 0;
1806: l_count NUMBER := 0;
1807:
3399: * Purpose :
3400: **********************************************************************/
3401:
3402: PROCEDURE Check_Required
3403: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
3404: , x_return_status OUT NOCOPY VARCHAR2
3405: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
3406: )
3407: IS