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

310: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
311: l_token_tbl(1).token_value := p_eam_direct_items_rec.wip_entity_id;
312:
313: l_out_mesg_token_tbl := l_mesg_token_tbl;
314: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
315: ( p_message_name => 'EAM_DI_DELETE_INVALID'
316: , p_token_tbl => l_token_tbl
317: , p_mesg_token_tbl => l_mesg_token_tbl
318: , 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('Cannot delete direct item . . . '); END IF;

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

Line 323: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;

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

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

329: /*
330:
331: -- operation_seq_num
332:
333: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
334:
335: begin
336:
337: 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 367: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

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

379: end;
380:
381:
382: -- direct_item_sequence_id
383: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating direct_item_sequence_id . . . '); END IF;
384:
385: begin
386:
387: 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 412: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

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

423:
424: end;
425:
426: -- quantity_per_assembly
427: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating quantity_per_assembly . . . '); END IF;
428:
429: begin
430:
431: 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 448: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

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

460: end;
461:
462:
463: -- wip_supply_type
464: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating wip_supply_type . . . '); END IF;
465:
466: begin
467:
468: 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 489: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

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

501: end;
502:
503:
504: -- mrp_net_flag
505: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating mrp_net_flag . . . '); END IF;
506:
507: begin
508:
509: 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 526: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

522: l_token_tbl(1).token_name := 'MRP_NET_FLAG';
523: l_token_tbl(1).token_value := p_eam_direct_items_rec.mrp_net_flag;
524:
525: l_out_mesg_token_tbl := l_mesg_token_tbl;
526: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
527: ( p_message_name => 'EAM_DI_MRP_NET_INVALID'
528: , p_token_tbl => l_token_tbl
529: , p_mesg_token_tbl => l_mesg_token_tbl
530: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

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

Line 600: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

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

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

Line 630: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 657: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 683: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

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

Line 686: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

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

Line 687: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

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

Line 688: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

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

Line 701: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 720: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 739: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 758: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 776: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 795: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 814: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 833: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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