APPS.EAM_OP_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 118: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

114: WHERE wo.wip_entity_id = p_wip_entity_id
115: AND wo.organization_id = p_organization_id
116: AND wo.operation_seq_num = p_operation_seq_num;
117:
118: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
119: x_eam_op_rec := l_eam_op_rec;
120:
121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN

Line 123: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;

119: x_eam_op_rec := l_eam_op_rec;
120:
121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN
123: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
124: x_eam_op_rec := l_eam_op_rec;
125:
126: WHEN OTHERS THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 153: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing OP rec for ' || p_eam_op_rec.operation_seq_num); END IF;

149: l_min_op_seq_num number;
150: l_department_id number;
151: BEGIN
152:
153: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing OP rec for ' || p_eam_op_rec.operation_seq_num); END IF;
154:
155: -- bug no 3444091
156: if p_eam_op_rec.start_date > p_eam_op_rec.completion_date then
157: x_return_status := fnd_api.g_ret_sts_error;

Line 349: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new operation') ; END IF;

345: and organization_id = p_eam_op_rec.organization_id
346: and wip_entity_id = p_eam_op_rec.wip_entity_id ;
347: END IF;
348:
349: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new operation') ; END IF;
350:
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: EXCEPTION

Line 384: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating OP '|| p_eam_op_rec.operation_seq_num); END IF;

380:
381: l_old_dept_id NUMBER;
382: BEGIN
383:
384: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating OP '|| p_eam_op_rec.operation_seq_num); END IF;
385:
386: -- bug no 3444091
387: if p_eam_op_rec.start_date > p_eam_op_rec.completion_date then
388: x_return_status := fnd_api.g_ret_sts_error;

Line 472: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Operation: '|| p_eam_op_rec.operation_seq_num); END IF;

468: )
469: IS
470: BEGIN
471:
472: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Operation: '|| p_eam_op_rec.operation_seq_num); END IF;
473:
474: DELETE FROM WIP_OPERATIONS
475: WHERE wip_entity_id = p_eam_op_rec.wip_entity_id
476: AND organization_id = p_eam_op_rec.organization_id

Line 516: IF p_eam_op_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

512: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
513: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
514: BEGIN
515:
516: IF p_eam_op_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
517: THEN
518: Insert_Row
519: ( p_eam_op_rec => p_eam_op_rec
520: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 523: ELSIF p_eam_op_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE

519: ( p_eam_op_rec => p_eam_op_rec
520: , x_mesg_token_Tbl => l_mesg_token_tbl
521: , x_return_Status => l_return_status
522: );
523: ELSIF p_eam_op_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
524: THEN
525: Update_Row
526: ( p_eam_op_rec => p_eam_op_rec
527: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 530: ELSIF p_eam_op_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE

526: ( p_eam_op_rec => p_eam_op_rec
527: , x_mesg_token_Tbl => l_mesg_token_tbl
528: , x_return_Status => l_return_status
529: );
530: ELSIF p_eam_op_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE
531: THEN
532: Delete_Row
533: ( p_eam_op_rec => p_eam_op_rec
534: , x_mesg_token_Tbl => l_mesg_token_tbl