DBA Data[Home] [Help]

APPS.EAM_OP_VALIDATE_PVT dependencies on STANDARD

Line 375: -- standard_operation_id

371: return;
372:
373: end;
374:
375: -- standard_operation_id
376: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating standard_operation_id . . . '); END IF;
377:
378: begin
379:

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

372:
373: end;
374:
375: -- standard_operation_id
376: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating standard_operation_id . . . '); END IF;
377:
378: begin
379:
380: if (p_eam_op_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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

378: begin
379:
380: if (p_eam_op_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
381:
382: if (p_eam_op_rec.standard_operation_id is not null) then
383:
384: select 1
385: into g_dummy
386: from bom_standard_operations

Line 386: from bom_standard_operations

382: if (p_eam_op_rec.standard_operation_id is not null) then
383:
384: select 1
385: into g_dummy
386: from bom_standard_operations
387: where standard_operation_id = p_eam_op_rec.standard_operation_id
388: and organization_id = p_eam_op_rec.organization_id;
389: end if;
390:

Line 387: where standard_operation_id = p_eam_op_rec.standard_operation_id

383:
384: select 1
385: into g_dummy
386: from bom_standard_operations
387: where standard_operation_id = p_eam_op_rec.standard_operation_id
388: and organization_id = p_eam_op_rec.organization_id;
389: end if;
390:
391: end if;

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

394:
395: exception
396: when others then
397:
398: l_token_tbl(1).token_name := 'STANDARD_OPERATION';
399: l_token_tbl(1).token_value := p_eam_op_rec.standard_operation_id;
400:
401: l_out_mesg_token_tbl := l_mesg_token_tbl;
402: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

395: exception
396: when others then
397:
398: l_token_tbl(1).token_name := 'STANDARD_OPERATION';
399: l_token_tbl(1).token_value := p_eam_op_rec.standard_operation_id;
400:
401: l_out_mesg_token_tbl := l_mesg_token_tbl;
402: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
403: ( p_message_name => 'EAM_OP_STD_OP_INVALID'