DBA Data[Home] [Help]

APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on EAM_PROCESS_WO_PVT

Line 37: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Check Required'); END IF;

33: l_wip_entity_name VARCHAR2(240);
34: l_status_type NUMBER;
35: BEGIN
36:
37: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Check Required'); END IF;
38:
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41: SELECT wip_entity_name

Line 45: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check Actual start date'); END IF;

41: SELECT wip_entity_name
42: INTO l_wip_entity_name
43: FROM wip_entities
44: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
45: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check Actual start date'); END IF;
46:
47: SELECT status_type,shutdown_type
48: INTO l_status_type,l_shutdown_type
49: FROM wip_discrete_jobs

Line 70: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check Actual end date'); END IF;

66: x_return_status := FND_API.G_RET_STS_ERROR;
67: return;
68: END IF;
69:
70: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check Actual end date'); END IF;
71: IF p_eam_wo_comp_rec.actual_end_date IS NULL
72: THEN
73: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
74: l_token_tbl(1).token_value := l_wip_entity_name;

Line 89: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check Actual duration '); END IF;

85: x_return_status := FND_API.G_RET_STS_ERROR;
86: return;
87: END IF;
88:
89: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check Actual duration '); END IF;
90: IF p_eam_wo_comp_rec.actual_duration IS NULL
91: THEN
92: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
93: l_token_tbl(1).token_value := l_wip_entity_name;

Line 108: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE

104: x_return_status := FND_API.G_RET_STS_ERROR;
105: return;
106: END IF;
107:
108: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE
109: THEN
110:
111: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check shutdown type '); END IF;
112: IF l_shutdown_type = 2 THEN -- Bug #5165813. Only Required shutdown_type needs to be validate

Line 111: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check shutdown type '); END IF;

107:
108: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE
109: THEN
110:
111: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check shutdown type '); END IF;
112: IF l_shutdown_type = 2 THEN -- Bug #5165813. Only Required shutdown_type needs to be validate
113: IF p_eam_wo_comp_rec.shutdown_start_date IS NULL OR p_eam_wo_comp_rec.shutdown_end_date IS NULL THEN
114:
115: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';

Line 133: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check status type '); END IF;

129: END IF;
130: END IF;
131: END IF;
132:
133: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check status type '); END IF;
134: IF (p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE AND l_status_type <> 3 )
135: OR
136: (
137: ( p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE)

Line 134: IF (p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE AND l_status_type <> 3 )

130: END IF;
131: END IF;
132:
133: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check status type '); END IF;
134: IF (p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE AND l_status_type <> 3 )
135: OR
136: (
137: ( p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE)
138: AND

Line 137: ( p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE)

133: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check status type '); END IF;
134: IF (p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE AND l_status_type <> 3 )
135: OR
136: (
137: ( p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE)
138: AND
139: ( l_status_type not in (4 ,5))
140: )
141: THEN

Line 234: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Check_Attributes'); END IF;

230: AND wdj.maintenance_object_type = 2;
231:
232: BEGIN
233:
234: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Check_Attributes'); END IF;
235:
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: x_eam_wo_comp_rec := p_eam_wo_comp_rec;
238: l_org_id := p_eam_wo_comp_rec.organization_id;

Line 253: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check shutdown start and end date'); END IF;

249:
250: OPEN cur_work_order_details;
251: FETCH cur_work_order_details into l_inventory_item_id;
252: CLOSE cur_work_order_details;
253: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check shutdown start and end date'); END IF;
254:
255: begin
256:
257: IF p_eam_wo_comp_rec.actual_start_date > p_eam_wo_comp_rec.actual_end_date THEN

Line 283: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check transaction date and open period'); END IF;

279: x_mesg_token_tbl := l_mesg_token_tbl ;
280: return;
281: end;
282:
283: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check transaction date and open period'); END IF;
284: begin
285:
286: SELECT NVL(MIN(period_start_date), sysdate+2)
287: INTO l_min_open_period

Line 321: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check shutdown start and end date'); END IF;

317:
318: end;
319:
320:
321: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check shutdown start and end date'); END IF;
322: begin
323: IF p_eam_wo_comp_rec.shutdown_start_date > p_eam_wo_comp_rec.shutdown_end_date THEN
324: raise fnd_api.g_exc_unexpected_error;
325: END IF;

Line 351: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check completion date'); END IF;

347: end;
348:
349:
350:
351: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check completion date'); END IF;
352: begin
353: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
354: begin
355:

Line 353: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then

349:
350:
351: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check completion date'); END IF;
352: begin
353: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
354: begin
355:
356: /* Fix for Bug 2100416 */
357: select nvl(max(actual_end_date), sysdate - 200000)

Line 368: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Allowing for completed operations'); END IF;

364: from eam_op_completion_txns
365: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
366: and operation_seq_num = eoct.operation_seq_num
367: );
368: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Allowing for completed operations'); END IF;
369: /* Fix for bug no:2730242 */
370: select nvl(min(actual_start_date), sysdate + 200000)
371: into l_min_compl_op_date
372: from eam_op_completion_txns eoct

Line 433: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check duration'); END IF;

429: end;
430: end if;
431: end;
432:
433: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check duration'); END IF;
434: begin
435: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
436:
437: begin

Line 435: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then

431: end;
432:
433: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check duration'); END IF;
434: begin
435: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
436:
437: begin
438: IF p_eam_wo_comp_rec.actual_duration < 0 THEN
439: raise fnd_api.g_exc_unexpected_error;

Line 466: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check actual end date in future'); END IF;

462: end;
463: end if;
464: end;
465:
466: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check actual end date in future'); END IF;
467: begin
468: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
469: begin
470:

Line 468: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then

464: end;
465:
466: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check actual end date in future'); END IF;
467: begin
468: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
469: begin
470:
471: IF p_eam_wo_comp_rec.actual_end_date > sysdate THEN
472: raise fnd_api.g_exc_unexpected_error;

Line 496: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check subinventory and lot information '); END IF;

492: end if;
493: end;
494:
495:
496: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check subinventory and lot information '); END IF;
497: begin
498: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE and
499: p_eam_wo_comp_rec.completion_subinventory IS NOT NULL
500: then

Line 498: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE and

494:
495:
496: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check subinventory and lot information '); END IF;
497: begin
498: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE and
499: p_eam_wo_comp_rec.completion_subinventory IS NOT NULL
500: then
501:
502: begin

Line 554: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check subinventory'); END IF;

550: END IF;
551:
552: END IF;
553:
554: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check subinventory'); END IF;
555:
556: IF l_completion_info = 1 THEN
557: SELECT lot_control_code into l_lot_ctrl_code
558: FROM mtl_system_items_b

Line 603: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check locator control code'); END IF;

599: END IF; -- end of l_completion_info = 1
600:
601: l_locator_id := p_eam_wo_comp_rec.completion_locator_id;
602:
603: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check locator control code'); END IF;
604: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_MTL_TXN_PROCESS.Get_LocatorControl_Code'); END IF;
605: /* Check for Locator Control which could be defined
606: at 3 level Organization,Subinventory,Item .
607: */

Line 604: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_MTL_TXN_PROCESS.Get_LocatorControl_Code'); END IF;

600:
601: l_locator_id := p_eam_wo_comp_rec.completion_locator_id;
602:
603: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check locator control code'); END IF;
604: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_MTL_TXN_PROCESS.Get_LocatorControl_Code'); END IF;
605: /* Check for Locator Control which could be defined
606: at 3 level Organization,Subinventory,Item .
607: */
608: EAM_MTL_TXN_PROCESS.Get_LocatorControl_Code(

Line 632: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check lot entry '); END IF;

628: raise G_EXC_RET_MAT_LOCATOR_RESTRIC;
629: end if;
630: end if; -- end of locator_control checkif
631:
632: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check lot entry '); END IF;
633:
634: /* CHECK for lot entry */
635: if(l_lot_ctrl_code = 2) then
636: if(p_eam_wo_comp_rec.lot_number is not null)then

Line 794: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check whether child job is complete'); END IF;

790:
791: end if;
792: end;
793:
794: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check whether child job is complete'); END IF;
795: begin
796: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
797: begin
798: -- Replaced the above cursor loop and cursor with the following query.

Line 796: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then

792: end;
793:
794: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check whether child job is complete'); END IF;
795: begin
796: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
797: begin
798: -- Replaced the above cursor loop and cursor with the following query.
799: -- for bug #2414513.
800: SELECT '1'

Line 837: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check reconciliation code'); END IF;

833: end;
834: end if;
835: end;
836:
837: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check reconciliation code'); END IF;
838: begin
839: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE and
840: p_eam_wo_comp_rec.reconciliation_code is not null then
841:

Line 839: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE and

835: end;
836:
837: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check reconciliation code'); END IF;
838: begin
839: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE and
840: p_eam_wo_comp_rec.reconciliation_code is not null then
841:
842: begin
843: SELECT mlu.lookup_code

Line 869: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check whether WO network child is complete ...'); END IF;

865: end;
866: end if;
867: end;
868:
869: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check whether WO network child is complete ...'); END IF;
870: begin
871: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
872: begin
873: SELECT '1'

Line 871: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then

867: end;
868:
869: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check whether WO network child is complete ...'); END IF;
870: begin
871: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
872: begin
873: SELECT '1'
874: INTO network_child_job_var
875: FROM dual

Line 918: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check whether WO network sibling is complete ...'); END IF;

914: end;
915: end if;
916: end;
917:
918: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check whether WO network sibling is complete ...'); END IF;
919: begin
920: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
921: begin
922: SELECT '1'

Line 920: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN

916: end;
917:
918: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check whether WO network sibling is complete ...'); END IF;
919: begin
920: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
921: begin
922: SELECT '1'
923: INTO sibling_parent_job_var
924: FROM dual

Line 964: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check whether parent rebuild job is complete if manual rebuild WO ...'); END IF;

960: end;
961: end if;
962: end ;
963:
964: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check whether parent rebuild job is complete if manual rebuild WO ...'); END IF;
965: begin
966: SELECT manual_rebuild_flag,
967: parent_wip_entity_id
968: INTO l_manual_rebuild_flag,

Line 1024: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Check_Attributes_b4_Defaulting'); END IF;

1020: g_dummy NUMBER;
1021:
1022: BEGIN
1023:
1024: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Check_Attributes_b4_Defaulting'); END IF;
1025:
1026: x_return_status := FND_API.G_RET_STS_SUCCESS;
1027:
1028: -- organization_id

Line 1029: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check organization_id'); END IF;

1025:
1026: x_return_status := FND_API.G_RET_STS_SUCCESS;
1027:
1028: -- organization_id
1029: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check organization_id'); END IF;
1030:
1031: declare
1032: l_disable_date date;
1033: begin

Line 1074: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating organization_id (EAM enabled) . . . '); END IF;

1070: end;
1071:
1072: -- organization_id (EAM enabled)
1073:
1074: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating organization_id (EAM enabled) . . . '); END IF;
1075:
1076: begin
1077:
1078: select 1