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: l_inventory_item_name VARCHAR2(240);

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: l_inventory_item_name VARCHAR2(240);
58: BEGIN

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: l_inventory_item_name VARCHAR2(240);
58: BEGIN
59:

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

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

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

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

Line 83: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

79: l_token_tbl(1).token_value := l_inventory_item_name;
80: --End bug# 11672256
81:
82: l_out_mesg_token_tbl := l_mesg_token_tbl;
83: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
84: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl
85: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
86: , p_message_name => 'EAM_MR_ALREADY_EXISTS'
87: , p_token_tbl => l_token_tbl

Line 101: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 114: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

110:
111: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
112: THEN
113: l_out_mesg_token_tbl := l_mesg_token_tbl;
114: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
115: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl
116: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
117: , p_message_name => NULL
118: , 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 155: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

151: PROCEDURE Check_Attributes
152: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
153: , p_old_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
154: , x_return_status OUT NOCOPY VARCHAR2
155: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
156: )
157: IS
158: l_err_text VARCHAR2(2000) := NULL;
159: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 159: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

155: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
156: )
157: IS
158: l_err_text VARCHAR2(2000) := NULL;
159: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
160: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
161: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
162: g_dummy NUMBER;
163: l_ordered_quantity NUMBER;

Line 160: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

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

Line 161: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

157: IS
158: l_err_text VARCHAR2(2000) := NULL;
159: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
160: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
161: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
162: g_dummy NUMBER;
163: l_ordered_quantity NUMBER;
164: l_stockable_flag VARCHAR2(1);
165: l_allocated NUMBER;

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

169: BEGIN
170:
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172:
173: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Material Requirement Check Attributes . . . '); END IF;
174:
175:
176: -- operation_seq_num
177:

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

174:
175:
176: -- operation_seq_num
177:
178: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
179:
180: begin
181:
182: 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 213: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

209: l_token_tbl(1).token_name := 'OP_SEQ_NUM';
210: l_token_tbl(1).token_value := p_eam_mat_req_rec.operation_seq_num;
211:
212: l_out_mesg_token_tbl := l_mesg_token_tbl;
213: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
214: ( p_message_name => 'EAM_MR_OP_SEQ_INVALID'
215: , p_token_tbl => l_token_tbl
216: , p_mesg_token_tbl => l_mesg_token_tbl
217: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

225: end;
226:
227:
228: -- inventory_item_id
229: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating inventory_item_id . . . '); END IF;
230:
231: declare
232: l_stockable_flag VARCHAR2(2);
233: NOT_PURCHASABLE EXCEPTION;

Line 280: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

276: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
277: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
278:
279: l_out_mesg_token_tbl := l_mesg_token_tbl;
280: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
281: ( p_message_name => 'EAM_MR_ITEM_NOT_PURCH'
282: , p_token_tbl => l_token_tbl
283: , p_mesg_token_tbl => l_mesg_token_tbl
284: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 298: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

294: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
295: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
296:
297: l_out_mesg_token_tbl := l_mesg_token_tbl;
298: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
299: ( p_message_name => 'EAM_MR_INV_ITEM_INVALID'
300: , p_token_tbl => l_token_tbl
301: , p_mesg_token_tbl => l_mesg_token_tbl
302: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

310: end;
311:
312:
313: -- quantity_per_assembly
314: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating quantity_per_assembly . . . '); END IF;
315:
316: begin
317:
318: 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 335: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

331: l_token_tbl(1).token_name := 'QUANTITY_PER_ASSEMBLY';
332: l_token_tbl(1).token_value := p_eam_mat_req_rec.quantity_per_assembly;
333:
334: l_out_mesg_token_tbl := l_mesg_token_tbl;
335: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
336: ( p_message_name => 'EAM_MR_QTY_PER_ASSY_INVALID'
337: , p_token_tbl => l_token_tbl
338: , p_mesg_token_tbl => l_mesg_token_tbl
339: , 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('Validating supply_subinventory . . . '); END IF;

347: end;
348:
349:
350: -- supply_subinventory
351: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_subinventory . . . '); END IF;
352:
353: begin
354:
355: 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 376: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

372: l_token_tbl(1).token_name := 'SUPPLY_SUB';
373: l_token_tbl(1).token_value := p_eam_mat_req_rec.supply_subinventory;
374:
375: l_out_mesg_token_tbl := l_mesg_token_tbl;
376: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
377: ( p_message_name => 'EAM_MR_SUPPLY_SUB_INVALID'
378: , p_token_tbl => l_token_tbl
379: , p_mesg_token_tbl => l_mesg_token_tbl
380: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

389:
390:
391:
392: -- supply_locator_id
393: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_locator_id . . . '); END IF;
394:
395: begin
396:
397: 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 419: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

415: l_token_tbl(1).token_name := 'SUPPLY_LOC';
416: l_token_tbl(1).token_value := p_eam_mat_req_rec.supply_locator_id;
417:
418: l_out_mesg_token_tbl := l_mesg_token_tbl;
419: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
420: ( p_message_name => 'EAM_MR_SUPPLY_LOC_INVALID'
421: , p_token_tbl => l_token_tbl
422: , p_mesg_token_tbl => l_mesg_token_tbl
423: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

433:
434:
435:
436: -- department_id
437: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating department_id . . . '); END IF;
438:
439: begin
440:
441: 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 483: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

479:
480:
481:
482: l_out_mesg_token_tbl := l_mesg_token_tbl;
483: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
484: ( p_message_name => 'EAM_MR_DEPT_INVALID'
485: , p_token_tbl => l_token_tbl
486: , p_mesg_token_tbl => l_mesg_token_tbl
487: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

495: end;
496:
497:
498: -- wip_supply_type
499: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating wip_supply_type . . . '); END IF;
500:
501: begin
502:
503: 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 524: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

520: l_token_tbl(1).token_name := 'WIP_SUPPLY_TYPE';
521: l_token_tbl(1).token_value := p_eam_mat_req_rec.wip_supply_type;
522:
523: l_out_mesg_token_tbl := l_mesg_token_tbl;
524: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
525: ( p_message_name => 'EAM_MR_SUPPLY_TYPE_INVALID'
526: , p_token_tbl => l_token_tbl
527: , p_mesg_token_tbl => l_mesg_token_tbl
528: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

536: end;
537:
538:
539: -- mrp_net_flag
540: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating mrp_net_flag . . . '); END IF;
541:
542: begin
543:
544: 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 561: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

557: l_token_tbl(1).token_name := 'MRP_NET_FLAG';
558: l_token_tbl(1).token_value := p_eam_mat_req_rec.mrp_net_flag;
559:
560: l_out_mesg_token_tbl := l_mesg_token_tbl;
561: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
562: ( p_message_name => 'EAM_MR_MRP_NET_INVALID'
563: , p_token_tbl => l_token_tbl
564: , p_mesg_token_tbl => l_mesg_token_tbl
565: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

587: END IF;
588:
589: IF(l_stockable_flag='Y') THEN
590: -- delete material_requirement
591: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating material_requirement . . . '); END IF;
592:
593: declare
594: l_count_mmt NUMBER :=0;
595: l_count_mmtt NUMBER :=0;

Line 648: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

644: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
645: l_token_tbl(1).token_value := p_eam_mat_req_rec.wip_entity_id;
646:
647: l_out_mesg_token_tbl := l_mesg_token_tbl;
648: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
649: ( p_message_name => 'EAM_MR_DELETE_INVALID'
650: , p_token_tbl => l_token_tbl
651: , p_mesg_token_tbl => l_mesg_token_tbl
652: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

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

Line 686: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

682: exception
683: when others then
684:
685: l_out_mesg_token_tbl := l_mesg_token_tbl;
686: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
687: ( p_message_name => 'EAM_MR_REQ_QTY_INVALID'
688: , p_token_tbl => l_token_tbl
689: , p_mesg_token_tbl => l_mesg_token_tbl
690: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 779: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

775: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
776: l_token_tbl(1).token_value := p_eam_mat_req_rec.wip_entity_id;
777:
778: l_out_mesg_token_tbl := l_mesg_token_tbl;
779: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
780: ( p_message_name => 'EAM_DI_DELETE_INVALID'
781: , p_token_tbl => l_token_tbl
782: , p_mesg_token_tbl => l_mesg_token_tbl
783: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

782: , p_mesg_token_tbl => l_mesg_token_tbl
783: , x_mesg_token_tbl => l_out_mesg_token_tbl
784: );
785: l_mesg_token_tbl := l_out_mesg_token_tbl;
786: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete non-stockable inventory item . . . '); END IF;
787:
788: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
789: x_mesg_token_tbl := l_mesg_token_tbl ;
790: return;

Line 788: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;

784: );
785: l_mesg_token_tbl := l_out_mesg_token_tbl;
786: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete non-stockable inventory item . . . '); END IF;
787:
788: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
789: x_mesg_token_tbl := l_mesg_token_tbl ;
790: return;
791: END IF;
792: END IF;

Line 806: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

802: l_token_tbl(1).token_name := 'Validation (Check Attributes)';
803: l_token_tbl(1).token_value := substrb(SQLERRM,1,200);
804:
805: l_out_mesg_token_tbl := l_mesg_token_tbl;
806: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
807: ( p_message_name => NULL
808: , p_token_tbl => l_token_tbl
809: , p_mesg_token_tbl => l_mesg_token_tbl
810: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 832: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

828:
829: PROCEDURE Check_Required
830: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
831: , x_return_status OUT NOCOPY VARCHAR2
832: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
833: )
834: IS
835: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
836: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 835: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

831: , x_return_status OUT NOCOPY VARCHAR2
832: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
833: )
834: IS
835: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
836: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
837: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
838: BEGIN
839:

Line 836: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

832: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
833: )
834: IS
835: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
836: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
837: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
838: BEGIN
839:
840: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 837: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

833: )
834: IS
835: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
836: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
837: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
838: BEGIN
839:
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841:

Line 849: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

845: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
846: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
847:
848: l_out_mesg_token_tbl := l_mesg_token_tbl;
849: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
850: ( p_message_name => 'EAM_MR_ENTITY_ID_REQUIRED'
851: , p_token_tbl => l_Token_tbl
852: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
853: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 868: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

864: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
865: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
866:
867: l_out_mesg_token_tbl := l_mesg_token_tbl;
868: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
869: ( p_message_name => 'EAM_MR_ORG_REQUIRED'
870: , p_token_tbl => l_Token_tbl
871: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
872: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 887: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

883: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
884: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
885:
886: l_out_mesg_token_tbl := l_mesg_token_tbl;
887: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
888: ( p_message_name => 'EAM_MR_INV_ITEM_REQUIRED'
889: , p_token_tbl => l_Token_tbl
890: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
891: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 906: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

902: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
903: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
904:
905: l_out_mesg_token_tbl := l_mesg_token_tbl;
906: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
907: ( p_message_name => 'EAM_MR_OP_SEQ_REQUIRED'
908: , p_token_tbl => l_Token_tbl
909: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
910: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 925: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

921: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
922: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
923:
924: l_out_mesg_token_tbl := l_mesg_token_tbl;
925: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
926: ( p_message_name => 'EAM_MR_SUPPLY_TYPE_REQUIRED'
927: , p_token_tbl => l_Token_tbl
928: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
929: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 944: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

940: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
941: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
942:
943: l_out_mesg_token_tbl := l_mesg_token_tbl;
944: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
945: ( p_message_name => 'EAM_MR_REQUIRED_QTY_REQUIRED'
946: , p_token_tbl => l_Token_tbl
947: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
948: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 963: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

959: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
960: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
961:
962: l_out_mesg_token_tbl := l_mesg_token_tbl;
963: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
964: ( p_message_name => 'EAM_MR_ISSUED_QTY_REQUIRED'
965: , p_token_tbl => l_Token_tbl
966: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
967: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 982: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

978: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
979: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
980:
981: l_out_mesg_token_tbl := l_mesg_token_tbl;
982: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
983: ( p_message_name => 'EAM_MR_ASSY_QTY_REQUIRED'
984: , p_token_tbl => l_Token_tbl
985: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
986: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1001: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

997: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
998: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
999:
1000: l_out_mesg_token_tbl := l_mesg_token_tbl;
1001: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1002: ( p_message_name => 'EAM_MR_MRP_NET_REQUIRED'
1003: , p_token_tbl => l_Token_tbl
1004: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1005: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1020: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1016: l_token_tbl(1).token_name := 'INV_ID';
1017: l_token_tbl(1).token_value := p_eam_mat_req_rec.wip_entity_id;
1018:
1019: l_out_mesg_token_tbl := l_mesg_token_tbl;
1020: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1021: ( p_message_name => 'EAM_MR_DATE_REQ_REQUIRED'
1022: , p_token_tbl => l_Token_tbl
1023: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1024: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl