DBA Data[Home] [Help]

APPS.EAM_OP_VALIDATE_PVT dependencies on STANDARD

Line 402: -- standard_operation_id

398: return;
399:
400: end;
401:
402: -- standard_operation_id
403: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating standard_operation_id . . . '); END IF;
404:
405: begin
406:

Line 403: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating standard_operation_id . . . '); END IF;

399:
400: end;
401:
402: -- standard_operation_id
403: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating standard_operation_id . . . '); END IF;
404:
405: begin
406:
407: if (p_eam_op_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 409: if (p_eam_op_rec.standard_operation_id is not null) then

405: begin
406:
407: if (p_eam_op_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
408:
409: if (p_eam_op_rec.standard_operation_id is not null) then
410:
411: select 1
412: into g_dummy
413: from bom_standard_operations

Line 413: from bom_standard_operations

409: if (p_eam_op_rec.standard_operation_id is not null) then
410:
411: select 1
412: into g_dummy
413: from bom_standard_operations
414: where standard_operation_id = p_eam_op_rec.standard_operation_id
415: and organization_id = p_eam_op_rec.organization_id;
416: end if;
417:

Line 414: where standard_operation_id = p_eam_op_rec.standard_operation_id

410:
411: select 1
412: into g_dummy
413: from bom_standard_operations
414: where standard_operation_id = p_eam_op_rec.standard_operation_id
415: and organization_id = p_eam_op_rec.organization_id;
416: end if;
417:
418: end if;

Line 425: l_token_tbl(1).token_name := 'STANDARD_OPERATION';

421:
422: exception
423: when others then
424:
425: l_token_tbl(1).token_name := 'STANDARD_OPERATION';
426: l_token_tbl(1).token_value := p_eam_op_rec.standard_operation_id;
427:
428: l_out_mesg_token_tbl := l_mesg_token_tbl;
429: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

Line 426: l_token_tbl(1).token_value := p_eam_op_rec.standard_operation_id;

422: exception
423: when others then
424:
425: l_token_tbl(1).token_name := 'STANDARD_OPERATION';
426: l_token_tbl(1).token_value := p_eam_op_rec.standard_operation_id;
427:
428: l_out_mesg_token_tbl := l_mesg_token_tbl;
429: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
430: ( p_message_name => 'EAM_OP_STD_OP_INVALID'