DBA Data[Home] [Help]

APPS.EAM_DIRECT_ITEMS_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_DIRECT_ITEMS_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_direct_items_rec IN EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
48: , x_old_eam_direct_items_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_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 Direct Item'); END IF;

Line 59: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Direct Item'); 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 Direct Item'); END IF;
60:
61: EAM_DIRECT_ITEMS_UTILITY_PVT.Query_Row
62: ( p_wip_entity_id => p_eam_direct_items_rec.wip_entity_id
63: , p_organization_id => p_eam_direct_items_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_direct_items_rec => x_old_eam_direct_items_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_direct_items_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 := 'DIRECT_ITEM_SEQUENCE_ID';
76: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_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_DI_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 := 'DIRECT_ITEM_SEQUENCE_ID';
94: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_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_DI_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 ' || 'Direct Item '|| p_eam_direct_items_rec.direct_item_sequence_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_direct_items_rec IN EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
149: , p_old_eam_direct_items_rec IN EAM_PROCESS_WO_PUB.eam_direct_items_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:

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:
161: BEGIN

Line 165: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Direct Item Check Attributes . . . '); END IF;

161: BEGIN
162:
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Direct Item Check Attributes . . . '); END IF;
166:
167:
168: -- department_id
169: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating department_id . . . '); END IF;

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

165: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Direct Item Check Attributes . . . '); END IF;
166:
167:
168: -- department_id
169: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating department_id . . . '); END IF;
170:
171: begin
172:
173: if (p_eam_direct_items_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 := 'DEPARTMENT_ID';
206: l_token_tbl(1).token_value := p_eam_direct_items_rec.department_id;
207:
208: l_out_mesg_token_tbl := l_mesg_token_tbl;
209: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
210: ( p_message_name => 'EAM_DI_DEPT_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 312: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

308: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
309: l_token_tbl(1).token_value := p_eam_direct_items_rec.wip_entity_id;
310:
311: l_out_mesg_token_tbl := l_mesg_token_tbl;
312: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
313: ( p_message_name => 'EAM_DI_DELETE_INVALID'
314: , p_token_tbl => l_token_tbl
315: , p_mesg_token_tbl => l_mesg_token_tbl
316: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 319: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete direct item . . . '); END IF;

315: , p_mesg_token_tbl => l_mesg_token_tbl
316: , x_mesg_token_tbl => l_out_mesg_token_tbl
317: );
318: l_mesg_token_tbl := l_out_mesg_token_tbl;
319: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete direct item . . . '); END IF;
320:
321: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
322: x_mesg_token_tbl := l_mesg_token_tbl ;
323: return;

Line 321: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;

317: );
318: l_mesg_token_tbl := l_out_mesg_token_tbl;
319: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete direct item . . . '); END IF;
320:
321: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
322: x_mesg_token_tbl := l_mesg_token_tbl ;
323: return;
324: END IF;
325: END IF;

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

327: /*
328:
329: -- operation_seq_num
330:
331: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
332:
333: begin
334:
335: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 365: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

361: l_token_tbl(1).token_name := 'OP_SEQ_NUM';
362: l_token_tbl(1).token_value := p_eam_direct_items_rec.operation_seq_num;
363:
364: l_out_mesg_token_tbl := l_mesg_token_tbl;
365: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
366: ( p_message_name => 'EAM_DI_OP_SEQ_INVALID'
367: , p_token_tbl => l_token_tbl
368: , p_mesg_token_tbl => l_mesg_token_tbl
369: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

377: end;
378:
379:
380: -- direct_item_sequence_id
381: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating direct_item_sequence_id . . . '); END IF;
382:
383: begin
384:
385: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 410: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

406: l_token_tbl(1).token_name := 'DIRECT_ITEM_SEQUENCE_ID';
407: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_id;
408:
409: l_out_mesg_token_tbl := l_mesg_token_tbl;
410: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
411: ( p_message_name => 'EAM_DI_INV_ITEM_INVALID'
412: , p_token_tbl => l_token_tbl
413: , p_mesg_token_tbl => l_mesg_token_tbl
414: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

421:
422: end;
423:
424: -- quantity_per_assembly
425: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating quantity_per_assembly . . . '); END IF;
426:
427: begin
428:
429: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 446: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

442: l_token_tbl(1).token_name := 'QUANTITY_PER_ASSEMBLY';
443: l_token_tbl(1).token_value := p_eam_direct_items_rec.quantity_per_assembly;
444:
445: l_out_mesg_token_tbl := l_mesg_token_tbl;
446: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
447: ( p_message_name => 'EAM_DI_QTY_PER_ASSY_INVALID'
448: , p_token_tbl => l_token_tbl
449: , p_mesg_token_tbl => l_mesg_token_tbl
450: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

458: end;
459:
460:
461: -- wip_supply_type
462: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating wip_supply_type . . . '); END IF;
463:
464: begin
465:
466: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 487: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

483: l_token_tbl(1).token_name := 'WIP_SUPPLY_TYPE';
484: l_token_tbl(1).token_value := p_eam_direct_items_rec.wip_supply_type;
485:
486: l_out_mesg_token_tbl := l_mesg_token_tbl;
487: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
488: ( p_message_name => 'EAM_DI_SUPPLY_TYPE_INVALID'
489: , p_token_tbl => l_token_tbl
490: , p_mesg_token_tbl => l_mesg_token_tbl
491: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

499: end;
500:
501:
502: -- mrp_net_flag
503: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating mrp_net_flag . . . '); END IF;
504:
505: begin
506:
507: if (p_eam_direct_items_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 := 'MRP_NET_FLAG';
521: l_token_tbl(1).token_value := p_eam_direct_items_rec.mrp_net_flag;
522:
523: l_out_mesg_token_tbl := l_mesg_token_tbl;
524: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
525: ( p_message_name => 'EAM_DI_MRP_NET_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 541: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating material_requirement . . . '); END IF;

537:
538:
539:
540: -- delete material_requirement
541: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating material_requirement . . . '); END IF;
542:
543: declare
544: l_count_mmt NUMBER :=0;
545: l_count_mmtt NUMBER :=0;

Line 598: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

594: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
595: l_token_tbl(1).token_value := p_eam_direct_items_rec.wip_entity_id;
596:
597: l_out_mesg_token_tbl := l_mesg_token_tbl;
598: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
599: ( p_message_name => 'EAM_DI_DELETE_INVALID'
600: , p_token_tbl => l_token_tbl
601: , p_mesg_token_tbl => l_mesg_token_tbl
602: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

611:
612:
613:
614: -- Required Quantity
615: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating required_quantity . . . '); END IF;
616:
617: begin
618: if p_eam_direct_items_rec.required_quantity < p_eam_direct_items_rec.quantity_issued then
619: raise fnd_api.g_exc_unexpected_error;

Line 628: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

624: exception
625: when others then
626:
627: l_out_mesg_token_tbl := l_mesg_token_tbl;
628: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
629: ( p_message_name => 'EAM_DI_REQ_QTY_INVALID'
630: , p_token_tbl => l_token_tbl
631: , p_mesg_token_tbl => l_mesg_token_tbl
632: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 655: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

651: l_token_tbl(1).token_name := 'Validation (Check Attributes)';
652: l_token_tbl(1).token_value := substrb(SQLERRM,1,200);
653:
654: l_out_mesg_token_tbl := l_mesg_token_tbl;
655: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
656: ( p_message_name => NULL
657: , p_token_tbl => l_token_tbl
658: , p_mesg_token_tbl => l_mesg_token_tbl
659: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 681: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

677:
678: PROCEDURE Check_Required
679: ( p_eam_direct_items_rec IN EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
680: , x_return_status OUT NOCOPY VARCHAR2
681: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
682: )
683: IS
684: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
685: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 684: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

680: , x_return_status OUT NOCOPY VARCHAR2
681: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
682: )
683: IS
684: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
685: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
686: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
687: BEGIN
688:

Line 685: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

681: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
682: )
683: IS
684: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
685: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
686: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
687: BEGIN
688:
689: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 686: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

682: )
683: IS
684: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
685: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
686: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
687: BEGIN
688:
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690:

Line 699: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

695: l_token_tbl(1).token_name := 'DIRECT_ITEM_SEQUENCE_ID';
696: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_id;
697:
698: l_out_mesg_token_tbl := l_mesg_token_tbl;
699: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
700: ( p_message_name => 'EAM_DI_ENTITY_ID_REQUIRED'
701: , p_token_tbl => l_Token_tbl
702: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
703: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 718: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

714: l_token_tbl(1).token_name := 'DIRECT_ITEM_SEQUENCE_ID';
715: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_id;
716:
717: l_out_mesg_token_tbl := l_mesg_token_tbl;
718: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
719: ( p_message_name => 'EAM_DI_ORG_REQUIRED'
720: , p_token_tbl => l_Token_tbl
721: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
722: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 737: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

733: l_token_tbl(1).token_name := 'DIRECT_ITEM_SEQUENCE_ID';
734: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_id;
735:
736: l_out_mesg_token_tbl := l_mesg_token_tbl;
737: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
738: ( p_message_name => 'EAM_DI_INV_ITEM_REQUIRED'
739: , p_token_tbl => l_Token_tbl
740: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
741: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 756: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

752: l_token_tbl(1).token_name := 'DIRECT_ITEM_SEQUENCE_ID';
753: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_id;
754:
755: l_out_mesg_token_tbl := l_mesg_token_tbl;
756: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
757: ( p_message_name => 'EAM_DI_OP_SEQ_REQUIRED'
758: , p_token_tbl => l_Token_tbl
759: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
760: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 774: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

770: l_token_tbl(1).token_name := 'DIRECT_ITEM_SEQUENCE_ID';
771: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_id;
772:
773: l_out_mesg_token_tbl := l_mesg_token_tbl;
774: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
775: ( p_message_name => 'EAM_DI_DESC_REQUIRED'
776: , p_token_tbl => l_Token_tbl
777: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
778: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 793: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

789: l_token_tbl(1).token_name := 'DIRECT_ITEM_SEQUENCE_ID';
790: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_id;
791:
792: l_out_mesg_token_tbl := l_mesg_token_tbl;
793: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
794: ( p_message_name => 'EAM_DI_PURCH_CAT_REQUIRED'
795: , p_token_tbl => l_Token_tbl
796: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
797: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 812: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

808: l_token_tbl(1).token_name := 'DIRECT_ITEM_SEQUENCE_ID';
809: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_id;
810:
811: l_out_mesg_token_tbl := l_mesg_token_tbl;
812: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
813: ( p_message_name => 'EAM_DI_REQ_QTY_REQUIRED'
814: , p_token_tbl => l_Token_tbl
815: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
816: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 831: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

827: l_token_tbl(1).token_name := 'DIRECT_ITEM_SEQUENCE_ID';
828: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_id;
829:
830: l_out_mesg_token_tbl := l_mesg_token_tbl;
831: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
832: ( p_message_name => 'EAM_DI_UOM_REQUIRED'
833: , p_token_tbl => l_Token_tbl
834: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
835: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl