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_MAT_REQ_VALIDATE_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 25: g_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

21: ***************************************************************************/
22:
23: G_Pkg_Name VARCHAR2(30) := 'EAM_MAT_REQ_VALIDATE_PVT';
24:
25: g_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
26:
27:
28: /*******************************************************************
29: * Procedure : Check_Existence

Line 49: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

45:
46: PROCEDURE Check_Existence
47: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
48: , x_old_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
49: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
50: , x_return_status OUT NOCOPY VARCHAR2
51: )
52: IS
53: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

Line 53: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

49: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
50: , x_return_status OUT NOCOPY VARCHAR2
51: )
52: IS
53: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
54: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
56: l_return_status VARCHAR2(1);
57: BEGIN

Line 54: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

50: , x_return_status OUT NOCOPY VARCHAR2
51: )
52: IS
53: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
54: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
56: l_return_status VARCHAR2(1);
57: BEGIN
58:

Line 55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

51: )
52: IS
53: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
54: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
56: l_return_status VARCHAR2(1);
57: BEGIN
58:
59: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Material Requirement'); END IF;

Line 59: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Material Requirement'); END IF;

55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
56: l_return_status VARCHAR2(1);
57: BEGIN
58:
59: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Material Requirement'); END IF;
60:
61: EAM_MAT_REQ_UTILITY_PVT.Query_Row
62: ( p_wip_entity_id => p_eam_mat_req_rec.wip_entity_id
63: , p_organization_id => p_eam_mat_req_rec.organization_id

Line 70: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;

66: , x_eam_mat_req_rec => x_old_eam_mat_req_rec
67: , x_Return_status => l_return_status
68: );
69:
70: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
71:
72: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND
73: p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
74: THEN

Line 79: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

75: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
76: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
77:
78: l_out_mesg_token_tbl := l_mesg_token_tbl;
79: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
80: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl
81: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
82: , p_message_name => 'EAM_MR_ALREADY_EXISTS'
83: , p_token_tbl => l_token_tbl

Line 97: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

93: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
94: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
95:
96: l_out_mesg_token_tbl := l_mesg_token_tbl;
97: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
98: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl
99: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
100: , p_message_name => 'EAM_MR_DOESNOT_EXISTS'
101: , p_token_tbl => l_token_tbl

Line 110: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

106:
107: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
108: THEN
109: l_out_mesg_token_tbl := l_mesg_token_tbl;
110: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
111: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl
112: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
113: , p_message_name => NULL
114: , p_message_text => 'Unexpected error while existence verification of ' || 'Material Requirement '|| p_eam_mat_req_rec.inventory_item_id , p_token_tbl => l_token_tbl

Line 151: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

147: PROCEDURE Check_Attributes
148: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
149: , p_old_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
150: , x_return_status OUT NOCOPY VARCHAR2
151: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
152: )
153: IS
154: l_err_text VARCHAR2(2000) := NULL;
155: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 155: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

151: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
152: )
153: IS
154: l_err_text VARCHAR2(2000) := NULL;
155: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
156: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
157: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
158: g_dummy NUMBER;
159: l_ordered_quantity NUMBER;

Line 156: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

152: )
153: IS
154: l_err_text VARCHAR2(2000) := NULL;
155: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
156: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
157: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
158: g_dummy NUMBER;
159: l_ordered_quantity NUMBER;
160: l_stockable_flag VARCHAR2(1);

Line 157: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

153: IS
154: l_err_text VARCHAR2(2000) := NULL;
155: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
156: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
157: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
158: g_dummy NUMBER;
159: l_ordered_quantity NUMBER;
160: l_stockable_flag VARCHAR2(1);
161: l_allocated NUMBER;

Line 169: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Material Requirement Check Attributes . . . '); END IF;

165: BEGIN
166:
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168:
169: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Material Requirement Check Attributes . . . '); END IF;
170:
171:
172: -- operation_seq_num
173:

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

170:
171:
172: -- operation_seq_num
173:
174: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
175:
176: begin
177:
178: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 209: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

205: l_token_tbl(1).token_name := 'OP_SEQ_NUM';
206: l_token_tbl(1).token_value := p_eam_mat_req_rec.operation_seq_num;
207:
208: l_out_mesg_token_tbl := l_mesg_token_tbl;
209: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
210: ( p_message_name => 'EAM_MR_OP_SEQ_INVALID'
211: , p_token_tbl => l_token_tbl
212: , p_mesg_token_tbl => l_mesg_token_tbl
213: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

221: end;
222:
223:
224: -- inventory_item_id
225: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating inventory_item_id . . . '); END IF;
226:
227: declare
228: l_stockable_flag VARCHAR2(2);
229: NOT_PURCHASABLE EXCEPTION;

Line 276: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

272: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
273: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
274:
275: l_out_mesg_token_tbl := l_mesg_token_tbl;
276: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
277: ( p_message_name => 'EAM_MR_ITEM_NOT_PURCH'
278: , p_token_tbl => l_token_tbl
279: , p_mesg_token_tbl => l_mesg_token_tbl
280: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 294: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

290: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
291: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
292:
293: l_out_mesg_token_tbl := l_mesg_token_tbl;
294: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
295: ( p_message_name => 'EAM_MR_INV_ITEM_INVALID'
296: , p_token_tbl => l_token_tbl
297: , p_mesg_token_tbl => l_mesg_token_tbl
298: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

306: end;
307:
308:
309: -- quantity_per_assembly
310: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating quantity_per_assembly . . . '); END IF;
311:
312: begin
313:
314: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 331: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

327: l_token_tbl(1).token_name := 'QUANTITY_PER_ASSEMBLY';
328: l_token_tbl(1).token_value := p_eam_mat_req_rec.quantity_per_assembly;
329:
330: l_out_mesg_token_tbl := l_mesg_token_tbl;
331: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
332: ( p_message_name => 'EAM_MR_QTY_PER_ASSY_INVALID'
333: , p_token_tbl => l_token_tbl
334: , p_mesg_token_tbl => l_mesg_token_tbl
335: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

343: end;
344:
345:
346: -- supply_subinventory
347: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_subinventory . . . '); END IF;
348:
349: begin
350:
351: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 372: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

368: l_token_tbl(1).token_name := 'SUPPLY_SUB';
369: l_token_tbl(1).token_value := p_eam_mat_req_rec.supply_subinventory;
370:
371: l_out_mesg_token_tbl := l_mesg_token_tbl;
372: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
373: ( p_message_name => 'EAM_MR_SUPPLY_SUB_INVALID'
374: , p_token_tbl => l_token_tbl
375: , p_mesg_token_tbl => l_mesg_token_tbl
376: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

385:
386:
387:
388: -- supply_locator_id
389: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_locator_id . . . '); END IF;
390:
391: begin
392:
393: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 415: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

411: l_token_tbl(1).token_name := 'SUPPLY_LOC';
412: l_token_tbl(1).token_value := p_eam_mat_req_rec.supply_locator_id;
413:
414: l_out_mesg_token_tbl := l_mesg_token_tbl;
415: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
416: ( p_message_name => 'EAM_MR_SUPPLY_LOC_INVALID'
417: , p_token_tbl => l_token_tbl
418: , p_mesg_token_tbl => l_mesg_token_tbl
419: , 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('Validating department_id . . . '); END IF;

429:
430:
431:
432: -- department_id
433: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating department_id . . . '); END IF;
434:
435: begin
436:
437: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 479: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

475:
476:
477:
478: l_out_mesg_token_tbl := l_mesg_token_tbl;
479: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
480: ( p_message_name => 'EAM_MR_DEPT_INVALID'
481: , p_token_tbl => l_token_tbl
482: , p_mesg_token_tbl => l_mesg_token_tbl
483: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

491: end;
492:
493:
494: -- wip_supply_type
495: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating wip_supply_type . . . '); END IF;
496:
497: begin
498:
499: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 520: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

516: l_token_tbl(1).token_name := 'WIP_SUPPLY_TYPE';
517: l_token_tbl(1).token_value := p_eam_mat_req_rec.wip_supply_type;
518:
519: l_out_mesg_token_tbl := l_mesg_token_tbl;
520: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
521: ( p_message_name => 'EAM_MR_SUPPLY_TYPE_INVALID'
522: , p_token_tbl => l_token_tbl
523: , p_mesg_token_tbl => l_mesg_token_tbl
524: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

532: end;
533:
534:
535: -- mrp_net_flag
536: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating mrp_net_flag . . . '); END IF;
537:
538: begin
539:
540: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 557: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

553: l_token_tbl(1).token_name := 'MRP_NET_FLAG';
554: l_token_tbl(1).token_value := p_eam_mat_req_rec.mrp_net_flag;
555:
556: l_out_mesg_token_tbl := l_mesg_token_tbl;
557: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
558: ( p_message_name => 'EAM_MR_MRP_NET_INVALID'
559: , p_token_tbl => l_token_tbl
560: , p_mesg_token_tbl => l_mesg_token_tbl
561: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

583: END IF;
584:
585: IF(l_stockable_flag='Y') THEN
586: -- delete material_requirement
587: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating material_requirement . . . '); END IF;
588:
589: declare
590: l_count_mmt NUMBER :=0;
591: l_count_mmtt NUMBER :=0;

Line 644: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

640: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
641: l_token_tbl(1).token_value := p_eam_mat_req_rec.wip_entity_id;
642:
643: l_out_mesg_token_tbl := l_mesg_token_tbl;
644: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
645: ( p_message_name => 'EAM_MR_DELETE_INVALID'
646: , p_token_tbl => l_token_tbl
647: , p_mesg_token_tbl => l_mesg_token_tbl
648: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

657:
658:
659:
660: -- Required Quantity
661: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating required_quantity . . . '); END IF;
662: if (p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
663: and p_eam_mat_req_rec.required_quantity < p_old_eam_mat_req_rec.required_quantity) then
664: begin
665:

Line 682: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

678: exception
679: when others then
680:
681: l_out_mesg_token_tbl := l_mesg_token_tbl;
682: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
683: ( p_message_name => 'EAM_MR_REQ_QTY_INVALID'
684: , p_token_tbl => l_token_tbl
685: , p_mesg_token_tbl => l_mesg_token_tbl
686: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 773: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

769: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
770: l_token_tbl(1).token_value := p_eam_mat_req_rec.wip_entity_id;
771:
772: l_out_mesg_token_tbl := l_mesg_token_tbl;
773: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
774: ( p_message_name => 'EAM_DI_DELETE_INVALID'
775: , p_token_tbl => l_token_tbl
776: , p_mesg_token_tbl => l_mesg_token_tbl
777: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 780: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete non-stockable inventory item . . . '); END IF;

776: , p_mesg_token_tbl => l_mesg_token_tbl
777: , x_mesg_token_tbl => l_out_mesg_token_tbl
778: );
779: l_mesg_token_tbl := l_out_mesg_token_tbl;
780: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete non-stockable inventory item . . . '); END IF;
781:
782: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
783: x_mesg_token_tbl := l_mesg_token_tbl ;
784: return;

Line 782: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;

778: );
779: l_mesg_token_tbl := l_out_mesg_token_tbl;
780: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete non-stockable inventory item . . . '); END IF;
781:
782: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
783: x_mesg_token_tbl := l_mesg_token_tbl ;
784: return;
785: END IF;
786: END IF;

Line 800: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

796: l_token_tbl(1).token_name := 'Validation (Check Attributes)';
797: l_token_tbl(1).token_value := substrb(SQLERRM,1,200);
798:
799: l_out_mesg_token_tbl := l_mesg_token_tbl;
800: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
801: ( p_message_name => NULL
802: , p_token_tbl => l_token_tbl
803: , p_mesg_token_tbl => l_mesg_token_tbl
804: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 826: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

822:
823: PROCEDURE Check_Required
824: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
825: , x_return_status OUT NOCOPY VARCHAR2
826: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
827: )
828: IS
829: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
830: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 829: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

825: , x_return_status OUT NOCOPY VARCHAR2
826: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
827: )
828: IS
829: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
830: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
831: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
832: BEGIN
833:

Line 830: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

826: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
827: )
828: IS
829: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
830: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
831: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
832: BEGIN
833:
834: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 831: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

827: )
828: IS
829: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
830: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
831: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
832: BEGIN
833:
834: x_return_status := FND_API.G_RET_STS_SUCCESS;
835:

Line 843: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

839: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
840: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
841:
842: l_out_mesg_token_tbl := l_mesg_token_tbl;
843: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
844: ( p_message_name => 'EAM_MR_ENTITY_ID_REQUIRED'
845: , p_token_tbl => l_Token_tbl
846: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
847: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 862: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

858: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
859: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
860:
861: l_out_mesg_token_tbl := l_mesg_token_tbl;
862: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
863: ( p_message_name => 'EAM_MR_ORG_REQUIRED'
864: , p_token_tbl => l_Token_tbl
865: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
866: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 881: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

877: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
878: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
879:
880: l_out_mesg_token_tbl := l_mesg_token_tbl;
881: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
882: ( p_message_name => 'EAM_MR_INV_ITEM_REQUIRED'
883: , p_token_tbl => l_Token_tbl
884: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
885: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 900: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

896: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
897: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
898:
899: l_out_mesg_token_tbl := l_mesg_token_tbl;
900: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
901: ( p_message_name => 'EAM_MR_OP_SEQ_REQUIRED'
902: , p_token_tbl => l_Token_tbl
903: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
904: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 919: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

915: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
916: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
917:
918: l_out_mesg_token_tbl := l_mesg_token_tbl;
919: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
920: ( p_message_name => 'EAM_MR_SUPPLY_TYPE_REQUIRED'
921: , p_token_tbl => l_Token_tbl
922: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
923: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 938: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

934: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
935: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
936:
937: l_out_mesg_token_tbl := l_mesg_token_tbl;
938: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
939: ( p_message_name => 'EAM_MR_REQUIRED_QTY_REQUIRED'
940: , p_token_tbl => l_Token_tbl
941: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
942: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 957: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

953: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
954: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
955:
956: l_out_mesg_token_tbl := l_mesg_token_tbl;
957: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
958: ( p_message_name => 'EAM_MR_ISSUED_QTY_REQUIRED'
959: , p_token_tbl => l_Token_tbl
960: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
961: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 976: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

972: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
973: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
974:
975: l_out_mesg_token_tbl := l_mesg_token_tbl;
976: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
977: ( p_message_name => 'EAM_MR_ASSY_QTY_REQUIRED'
978: , p_token_tbl => l_Token_tbl
979: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
980: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 995: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

991: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
992: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
993:
994: l_out_mesg_token_tbl := l_mesg_token_tbl;
995: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
996: ( p_message_name => 'EAM_MR_MRP_NET_REQUIRED'
997: , p_token_tbl => l_Token_tbl
998: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
999: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1014: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1010: l_token_tbl(1).token_name := 'INV_ID';
1011: l_token_tbl(1).token_value := p_eam_mat_req_rec.wip_entity_id;
1012:
1013: l_out_mesg_token_tbl := l_mesg_token_tbl;
1014: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1015: ( p_message_name => 'EAM_MR_DATE_REQ_REQUIRED'
1016: , p_token_tbl => l_Token_tbl
1017: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1018: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl