eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 26: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

22: PROCEDURE Check_Required
23: (
24: p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
25: , x_return_status OUT NOCOPY VARCHAR2
26: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
27: )
28: IS
29: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
30: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 29: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

25: , x_return_status OUT NOCOPY VARCHAR2
26: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
27: )
28: IS
29: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
30: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
31: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
32: l_shutdown_type VARCHAR2(30);
33: l_wip_entity_name VARCHAR2(240);

Line 30: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

26: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
27: )
28: IS
29: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
30: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
31: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
32: l_shutdown_type VARCHAR2(30);
33: l_wip_entity_name VARCHAR2(240);
34: l_status_type NUMBER;

Line 31: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

27: )
28: IS
29: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
30: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
31: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
32: l_shutdown_type VARCHAR2(30);
33: l_wip_entity_name VARCHAR2(240);
34: l_status_type NUMBER;
35: BEGIN

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 58: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

54: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
55: l_token_tbl(1).token_value := l_wip_entity_name;
56:
57: l_out_mesg_token_tbl := l_mesg_token_tbl;
58: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
59: ( p_message_name => 'EAM_WCMP_ACT_STDATE_REQ'
60: , p_token_tbl => l_Token_tbl
61: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
62: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

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 77: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

73: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
74: l_token_tbl(1).token_value := l_wip_entity_name;
75:
76: l_out_mesg_token_tbl := l_mesg_token_tbl;
77: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
78: ( p_message_name => 'EAM_WCMP_ACT_ENDDATE_REQ'
79: , p_token_tbl => l_Token_tbl
80: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
81: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

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 96: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

92: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
93: l_token_tbl(1).token_value := l_wip_entity_name;
94:
95: l_out_mesg_token_tbl := l_mesg_token_tbl;
96: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
97: ( p_message_name => 'EAM_WCMP_ACT_DUR_REQ'
98: , p_token_tbl => l_Token_tbl
99: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
100: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

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 119: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

115: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
116: l_token_tbl(1).token_value := l_wip_entity_name;
117:
118: l_out_mesg_token_tbl := l_mesg_token_tbl;
119: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
120: ( p_message_name => 'EAM_WCMPL_SHUTDOWN_DATE_MISS'
121: , p_token_tbl => l_Token_tbl
122: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
123: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

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 146: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

142: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
143: l_token_tbl(1).token_value := l_wip_entity_name;
144: l_out_mesg_token_tbl := l_mesg_token_tbl;
145:
146: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
147: ( p_message_name => 'EAM_WO_COMP_WRONG_STATUS'
148: , p_token_tbl => l_Token_tbl
149: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
150: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 173: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

169: (
170: p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
171: , x_eam_wo_comp_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
172: , x_return_status OUT NOCOPY VARCHAR2
173: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
174: )
175: IS
176: l_err_text VARCHAR2(2000) := NULL;
177: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 177: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

173: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
174: )
175: IS
176: l_err_text VARCHAR2(2000) := NULL;
177: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
178: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
179: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
180: network_child_job_var VARCHAR2(2):='0';
181: sibling_parent_job_var VARCHAR2(2):='0';

Line 178: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

174: )
175: IS
176: l_err_text VARCHAR2(2000) := NULL;
177: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
178: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
179: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
180: network_child_job_var VARCHAR2(2):='0';
181: sibling_parent_job_var VARCHAR2(2):='0';
182: l_reconciliation_code VARCHAR2(30);

Line 179: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

175: IS
176: l_err_text VARCHAR2(2000) := NULL;
177: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
178: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
179: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
180: network_child_job_var VARCHAR2(2):='0';
181: sibling_parent_job_var VARCHAR2(2):='0';
182: l_reconciliation_code VARCHAR2(30);
183: l_manual_rebuild_flag VARCHAR2(1);

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 270: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

266: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
267: l_token_tbl(1).token_value := l_wip_entity_name;
268:
269: l_out_mesg_token_tbl := l_mesg_token_tbl;
270: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
271: ( p_message_name => 'EAM_WC_SHUTDOWN_STAF_END'
272: , p_token_tbl => l_token_tbl
273: , p_mesg_token_tbl => l_mesg_token_tbl
274: , x_mesg_token_tbl => l_out_mesg_token_tbl

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 306: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

302: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
303: l_token_tbl(1).token_value := l_wip_entity_name;
304:
305: l_out_mesg_token_tbl := l_mesg_token_tbl;
306: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
307: ( p_message_name => 'EAM_TRANSACTION_DATE_INVALID'
308: , p_token_tbl => l_token_tbl
309: , p_mesg_token_tbl => l_mesg_token_tbl
310: , x_mesg_token_tbl => l_out_mesg_token_tbl

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 336: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

332: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
333: l_token_tbl(1).token_value := l_wip_entity_name;
334:
335: l_out_mesg_token_tbl := l_mesg_token_tbl;
336: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
337: ( p_message_name => 'EAM_WC_SHUTDOWN_DATE_BAD'
338: , p_token_tbl => l_token_tbl
339: , p_mesg_token_tbl => l_mesg_token_tbl
340: , x_mesg_token_tbl => l_out_mesg_token_tbl

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 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 417: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

413: l_token_tbl(2).token_value := TO_CHAR(l_max_compl_op_date,'dd-MON-yyyy HH24:MI:SS');
414:
415:
416: l_out_mesg_token_tbl := l_mesg_token_tbl;
417: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
418: ( p_message_name => 'EAM_WO_COMPL_DATES_INVALID'
419: , p_token_tbl => l_token_tbl
420: , p_mesg_token_tbl => l_mesg_token_tbl
421: , x_mesg_token_tbl => l_out_mesg_token_tbl

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 451: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

447: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
448: l_token_tbl(1).token_value := l_wip_entity_name;
449:
450: l_out_mesg_token_tbl := l_mesg_token_tbl;
451: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
452: ( p_message_name => 'EAM_WC_NEGATIVE_DURATION'
453: , p_token_tbl => l_token_tbl
454: , p_mesg_token_tbl => l_mesg_token_tbl
455: , x_mesg_token_tbl => l_out_mesg_token_tbl

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 480: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

476: exception
477: when others then
478:
479: l_out_mesg_token_tbl := l_mesg_token_tbl;
480: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
481: ( p_message_name => 'EAM_END_LATER_THAN_TODAY'
482: , p_token_tbl => l_token_tbl
483: , p_mesg_token_tbl => l_mesg_token_tbl
484: , x_mesg_token_tbl => l_out_mesg_token_tbl

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 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 664: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

660: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
661: l_token_tbl(1).token_value := l_wip_entity_name;
662:
663: l_out_mesg_token_tbl := l_mesg_token_tbl;
664: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
665: ( p_message_name => 'EAM_WC_RET_MAT_INVALID_SUBINV'
666: , p_token_tbl => l_token_tbl
667: , p_mesg_token_tbl => l_mesg_token_tbl
668: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 681: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

677: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
678: l_token_tbl(1).token_value := l_wip_entity_name;
679:
680: l_out_mesg_token_tbl := l_mesg_token_tbl;
681: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
682: ( p_message_name => 'EAM_WC_NOT_ENOUGH_VALUES'
683: , p_token_tbl => l_token_tbl
684: , p_mesg_token_tbl => l_mesg_token_tbl
685: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 698: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

694: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
695: l_token_tbl(1).token_value := l_wip_entity_name;
696:
697: l_out_mesg_token_tbl := l_mesg_token_tbl;
698: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
699: ( p_message_name => 'EAM_WC_LOCATOR_DEFAULT_ERR'
700: , p_token_tbl => l_token_tbl
701: , p_mesg_token_tbl => l_mesg_token_tbl
702: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 714: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

710: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
711: l_token_tbl(1).token_value := l_wip_entity_name;
712:
713: l_out_mesg_token_tbl := l_mesg_token_tbl;
714: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
715: ( p_message_name => 'EAM_WC_RET_MAT_LOCATOR_NEEDED'
716: , p_token_tbl => l_token_tbl
717: , p_mesg_token_tbl => l_mesg_token_tbl
718: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 730: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

726: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
727: l_token_tbl(1).token_value := l_wip_entity_name;
728:
729: l_out_mesg_token_tbl := l_mesg_token_tbl;
730: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
731: ( p_message_name => 'EAM_WC_RET_MAT_LOCATOR_RESTRICTED'
732: , p_token_tbl => l_token_tbl
733: , p_mesg_token_tbl => l_mesg_token_tbl
734: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 746: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

742: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
743: l_token_tbl(1).token_value := l_wip_entity_name;
744:
745: l_out_mesg_token_tbl := l_mesg_token_tbl;
746: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
747: ( p_message_name => 'EAM_WC_NO_LOT_NUMBER'
748: , p_token_tbl => l_token_tbl
749: , p_mesg_token_tbl => l_mesg_token_tbl
750: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 762: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

758: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
759: l_token_tbl(1).token_value := l_wip_entity_name;
760:
761: l_out_mesg_token_tbl := l_mesg_token_tbl;
762: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
763: ( p_message_name => 'EAM_WC_LOT_NEEDED'
764: , p_token_tbl => l_token_tbl
765: , p_mesg_token_tbl => l_mesg_token_tbl
766: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 778: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

774: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
775: l_token_tbl(1).token_value := l_wip_entity_name;
776:
777: l_out_mesg_token_tbl := l_mesg_token_tbl;
778: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
779: ( p_message_name => 'EAM_WC_LOT_NOT_NEEDED'
780: , p_token_tbl => l_token_tbl
781: , p_mesg_token_tbl => l_mesg_token_tbl
782: , x_mesg_token_tbl => l_out_mesg_token_tbl

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 822: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

818: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
819: l_token_tbl(1).token_value := l_wip_entity_name;
820:
821: l_out_mesg_token_tbl := l_mesg_token_tbl;
822: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
823: ( p_message_name => 'EAM_CHILD_JOB_NOT_COMPLETE'
824: , p_token_tbl => l_token_tbl
825: , p_mesg_token_tbl => l_mesg_token_tbl
826: , x_mesg_token_tbl => l_out_mesg_token_tbl

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 854: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

850: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
851: l_token_tbl(1).token_value := l_wip_entity_name;
852:
853: l_out_mesg_token_tbl := l_mesg_token_tbl;
854: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
855: ( p_message_name => 'EAM_WC_RECONCILIATION_CODE_INV'
856: , p_token_tbl => l_token_tbl
857: , p_mesg_token_tbl => l_mesg_token_tbl
858: , x_mesg_token_tbl => l_out_mesg_token_tbl

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 903: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

899: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
900: l_token_tbl(1).token_value := l_wip_entity_name;
901:
902: l_out_mesg_token_tbl := l_mesg_token_tbl;
903: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
904: ( p_message_name => 'EAM_NETWRK_CHILD_JOB_NOT_COMP'
905: , p_token_tbl => l_token_tbl
906: , p_mesg_token_tbl => l_mesg_token_tbl
907: , x_mesg_token_tbl => l_out_mesg_token_tbl

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 949: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

945: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
946: l_token_tbl(1).token_value := l_wip_entity_name;
947:
948: l_out_mesg_token_tbl := l_mesg_token_tbl;
949: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
950: ( p_message_name => 'EAM_NETWRK_SIB_JOB_NOT_COM'
951: , p_token_tbl => l_token_tbl
952: , p_mesg_token_tbl => l_mesg_token_tbl
953: , x_mesg_token_tbl => l_out_mesg_token_tbl

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 990: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

986: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
987: l_token_tbl(1).token_value := l_wip_entity_name;
988:
989: l_out_mesg_token_tbl := l_mesg_token_tbl;
990: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
991: ( p_message_name => 'EAM_PARENT_JOB_COMPLETED'
992: , p_token_tbl => l_token_tbl
993: , p_mesg_token_tbl => l_mesg_token_tbl
994: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 1012: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

1008:
1009:
1010: PROCEDURE Check_Attributes_b4_Defaulting
1011: ( p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
1012: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
1013: , x_return_status OUT NOCOPY VARCHAR2
1014: )
1015: IS
1016: l_err_text VARCHAR2(2000) := NULL;

Line 1017: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

1013: , x_return_status OUT NOCOPY VARCHAR2
1014: )
1015: IS
1016: l_err_text VARCHAR2(2000) := NULL;
1017: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1018: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1019: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1020: g_dummy NUMBER;
1021:

Line 1018: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

1014: )
1015: IS
1016: l_err_text VARCHAR2(2000) := NULL;
1017: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1018: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1019: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1020: g_dummy NUMBER;
1021:
1022: BEGIN

Line 1019: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

1015: IS
1016: l_err_text VARCHAR2(2000) := NULL;
1017: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1018: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1019: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1020: g_dummy NUMBER;
1021:
1022: BEGIN
1023:

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 1058: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1054: l_token_tbl(1).token_name := 'Organization Id';
1055: l_token_tbl(1).token_value := p_eam_wo_comp_rec.organization_id;
1056:
1057: l_out_mesg_token_tbl := l_mesg_token_tbl;
1058: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1059: ( p_message_name => 'EAM_WO_ORGANIZATION_ID'
1060: , p_token_tbl => l_token_tbl
1061: , p_mesg_token_tbl => l_mesg_token_tbl
1062: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

Line 1094: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1090: l_token_tbl(1).token_name := 'Organization Id';
1091: l_token_tbl(1).token_value := p_eam_wo_comp_rec.organization_id;
1092:
1093: l_out_mesg_token_tbl := l_mesg_token_tbl;
1094: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1095: ( p_message_name => 'EAM_WO_ORG_EAM_ENABLED'
1096: , p_token_tbl => l_token_tbl
1097: , p_mesg_token_tbl => l_mesg_token_tbl
1098: , x_mesg_token_tbl => l_out_mesg_token_tbl