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_RES_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_RES_VALIDATE_PVT';
24:
25: g_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
26: g_dummy NUMBER;
27: g_autocharge_type VARCHAR2(30) := EAM_CONSTANTS.G_AUTOCHARGE_TYPE;
28:
29: /*******************************************************************

Line 50: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

46:
47: PROCEDURE Check_Existence
48: ( p_eam_res_rec IN EAM_PROCESS_WO_PUB.eam_res_rec_type
49: , x_old_eam_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_rec_type
50: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
51: , x_return_status OUT NOCOPY VARCHAR2
52: )
53: IS
54: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

Line 54: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

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

Line 55: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

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

Line 56: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

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

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

56: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
57: l_return_status VARCHAR2(1);
58: BEGIN
59:
60: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Resource'); END IF;
61:
62: EAM_RES_UTILITY_PVT.Query_Row
63: ( p_wip_entity_id => p_eam_res_rec.wip_entity_id
64: , p_organization_id => p_eam_res_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_res_rec => x_old_eam_res_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_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
75: THEN

Line 80: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

76: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
77: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
78:
79: l_out_mesg_token_tbl := l_mesg_token_tbl;
80: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
81: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl
82: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
83: , p_message_name => 'EAM_RES_ALREADY_EXISTS'
84: , p_token_tbl => l_token_tbl

Line 98: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

94: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
95: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
96:
97: l_out_mesg_token_tbl := l_mesg_token_tbl;
98: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
99: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl
100: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
101: , p_message_name => 'EAM_RES_DOESNOT_EXISTS'
102: , p_token_tbl => l_token_tbl

Line 111: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 154: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

150: PROCEDURE Check_Attributes
151: ( p_eam_res_rec IN EAM_PROCESS_WO_PUB.eam_res_rec_type
152: , p_old_eam_res_rec IN EAM_PROCESS_WO_PUB.eam_res_rec_type
153: , x_return_status OUT NOCOPY VARCHAR2
154: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
155: )
156: IS
157: l_err_text VARCHAR2(2000) := NULL;
158: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 158: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

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

Line 159: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

155: )
156: IS
157: l_err_text VARCHAR2(2000) := NULL;
158: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
159: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
160: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
161: l_24_hr_resource NUMBER ;
162: l_calendar_code VARCHAR2(10);
163: l_count_shift_num NUMBER;

Line 160: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

156: IS
157: l_err_text VARCHAR2(2000) := NULL;
158: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
159: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
160: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
161: l_24_hr_resource NUMBER ;
162: l_calendar_code VARCHAR2(10);
163: l_count_shift_num NUMBER;
164: BEGIN

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

164: BEGIN
165:
166: -- operation_seq_num
167:
168: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
169:
170: begin
171:
172: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 192: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

188: l_token_tbl(1).token_name := 'OP_SEQ_NUM_INVALID';
189: l_token_tbl(1).token_value := p_eam_res_rec.operation_seq_num;
190:
191: l_out_mesg_token_tbl := l_mesg_token_tbl;
192: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
193: ( p_message_name => 'EAM_RES_OP_SEQ_INVALID'
194: , p_token_tbl => l_token_tbl
195: , p_mesg_token_tbl => l_mesg_token_tbl
196: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

204: end;
205:
206:
207: -- start_date
208: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating start_date . . . '); END IF;
209:
210: begin
211:
212: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 229: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

225: l_token_tbl(1).token_name := 'START_DATE';
226: l_token_tbl(1).token_value := p_eam_res_rec.start_date;
227:
228: l_out_mesg_token_tbl := l_mesg_token_tbl;
229: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
230: ( p_message_name => 'EAM_RES_START_DATE_INVALID'
231: , p_token_tbl => l_token_tbl
232: , p_mesg_token_tbl => l_mesg_token_tbl
233: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

241: end;
242:
243:
244: -- assigned_units
245: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating assigned_units . . . '); END IF;
246:
247: begin
248:
249: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 266: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

262: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
263: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
264:
265: l_out_mesg_token_tbl := l_mesg_token_tbl;
266: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
267: ( p_message_name => 'EAM_RES_ASSIGNED_UNIT_INVALID'
268: , p_token_tbl => l_token_tbl
269: , p_mesg_token_tbl => l_mesg_token_tbl
270: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 282: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating resource uniquness in operation . . . '); END IF;

278: end;
279: /*commenting this check for 7183942
280:
281: -- A resource cannot be added to same operation twice
282: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating resource uniquness in operation . . . '); END IF;
283:
284: begin
285:
286: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE)) then

Line 315: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

311: l_token_tbl(1).token_name := 'RES_ID';
312: l_token_tbl(1).token_value := p_eam_res_rec.resource_id;
313:
314: l_out_mesg_token_tbl := l_mesg_token_tbl;
315: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
316: ( p_message_name => 'EAM_RES_ALD_ADDED_WO'
317: , p_token_tbl => l_token_tbl
318: , p_mesg_token_tbl => l_mesg_token_tbl
319: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

327: end;
328:
329: /*commenting this check for 7183942*/
330: -- resource_id
331: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating resource_id . . . '); END IF;
332:
333: begin
334:
335: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 369: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

365: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
366: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
367:
368: l_out_mesg_token_tbl := l_mesg_token_tbl;
369: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
370: ( p_message_name => 'EAM_RES_RESOURCE_SEQ_INVALID'
371: , p_token_tbl => l_token_tbl
372: , p_mesg_token_tbl => l_mesg_token_tbl
373: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

381: end;
382:
383:
384: -- uom_code
385: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating uom_code . . . '); END IF;
386:
387: begin
388:
389: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 413: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

409: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
410: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
411:
412: l_out_mesg_token_tbl := l_mesg_token_tbl;
413: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
414: ( p_message_name => 'EAM_RES_UOM_INVALID'
415: , p_token_tbl => l_token_tbl
416: , p_mesg_token_tbl => l_mesg_token_tbl
417: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

425: end;
426:
427:
428: -- basis_type
429: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating basis_type . . . '); END IF;
430:
431: begin
432:
433: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 453: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

449: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
450: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
451:
452: l_out_mesg_token_tbl := l_mesg_token_tbl;
453: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
454: ( p_message_name => 'EAM_RES_BASIS_TYPE_INVALID'
455: , p_token_tbl => l_token_tbl
456: , p_mesg_token_tbl => l_mesg_token_tbl
457: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

465: end;
466:
467:
468: -- activity_id
469: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating activity_id . . . '); END IF;
470:
471: begin
472:
473: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 499: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

495: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
496:
497:
498: l_out_mesg_token_tbl := l_mesg_token_tbl;
499: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
500: ( p_message_name => 'EAM_RES_ACTIVITY_INVALID'
501: , p_token_tbl => l_token_tbl
502: , p_mesg_token_tbl => l_mesg_token_tbl
503: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

511: end;
512:
513:
514: -- autocharge_type
515: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating autocharge_type . . . '); END IF;
516:
517: begin
518:
519: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 539: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

535: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
536: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
537:
538: l_out_mesg_token_tbl := l_mesg_token_tbl;
539: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
540: ( p_message_name => 'EAM_RES_AC_TYPE_INVALID'
541: , p_token_tbl => l_token_tbl
542: , p_mesg_token_tbl => l_mesg_token_tbl
543: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

551: end;
552:
553:
554: -- scheduled_flag
555: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating schedule_flag . . . '); END IF;
556:
557: begin
558:
559: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 576: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

572: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
573: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
574:
575: l_out_mesg_token_tbl := l_mesg_token_tbl;
576: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
577: ( p_message_name => 'EAM_RES_SCHEDULE_TYPE_INVALID'
578: , p_token_tbl => l_token_tbl
579: , p_mesg_token_tbl => l_mesg_token_tbl
580: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

588: end;
589:
590:
591: -- standard_rate_flag
592: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating schedule_flag . . . '); END IF;
593:
594: begin
595:
596: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 616: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

612: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
613: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
614:
615: l_out_mesg_token_tbl := l_mesg_token_tbl;
616: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
617: ( p_message_name => 'EAM_RES_STANDARD_RATE_INVALID'
618: , p_token_tbl => l_token_tbl
619: , p_mesg_token_tbl => l_mesg_token_tbl
620: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

627:
628: end;
629:
630: -- department_id
631: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Department. . . '); END IF;
632:
633: begin
634:
635: -- Check whether resource dept and op dept match.

Line 669: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

665: exception
666: when others then
667:
668: l_out_mesg_token_tbl := l_mesg_token_tbl;
669: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
670: ( p_message_name => 'EAM_RES_DEPARTMENT_INVALID'
671: , p_token_tbl => l_token_tbl
672: , p_mesg_token_tbl => l_mesg_token_tbl
673: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

681: end;
682:
683:
684: -- usage_rate_or_amount
685: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating usage_rate_or_amount . . . '); END IF;
686: declare
687: l_hour_uom varchar2(50);
688: l_hour_uom_class varchar2(200);
689: l_uom_time_class_flag varchar2(3);

Line 728: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

724: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
725: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
726:
727: l_out_mesg_token_tbl := l_mesg_token_tbl;
728: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
729: ( p_message_name => 'EAM_RES_USAGE_RATE_INVALID'
730: , p_token_tbl => l_token_tbl
731: , p_mesg_token_tbl => l_mesg_token_tbl
732: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 744: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating that shift must exists if resource is not 24 hr resource . . . '); END IF;

740: end;
741:
742:
743: /* added for bug no 3393323 */
744: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating that shift must exists if resource is not 24 hr resource . . . '); END IF;
745:
746: begin
747:
748: if p_eam_res_rec.scheduled_flag = 1 then

Line 780: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

776: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
777: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
778:
779: l_out_mesg_token_tbl := l_mesg_token_tbl;
780: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
781: ( p_message_name => 'EAM_RES_RESOURCE_SHIFT_ND'
782: , p_token_tbl => l_token_tbl
783: , p_mesg_token_tbl => l_mesg_token_tbl
784: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 801: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

797: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
798: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
799:
800: l_out_mesg_token_tbl := l_mesg_token_tbl;
801: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
802: ( p_message_name => 'EAM_RES_RESOURCE_SHIFT_ND'
803: , p_token_tbl => l_token_tbl
804: , p_mesg_token_tbl => l_mesg_token_tbl
805: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

812: end;
813:
814:
815: -- delete resource
816: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating resource . . . '); END IF;
817:
818: declare
819: l_count_wt NUMBER :=0;
820: l_count_wcti NUMBER :=0;

Line 880: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

876: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
877: l_token_tbl(1).token_value := p_eam_res_rec.wip_entity_id;
878:
879: l_out_mesg_token_tbl := l_mesg_token_tbl;
880: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
881: ( p_message_name => 'EAM_RES_DELETE_INVALID'
882: , p_token_tbl => l_token_tbl
883: , p_mesg_token_tbl => l_mesg_token_tbl
884: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 916: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

912: exception
913: when others then
914:
915: l_out_mesg_token_tbl := l_mesg_token_tbl;
916: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
917: ( p_message_name => 'EAM_INSTANCES_EXIST'
918: , p_token_tbl => l_token_tbl
919: , p_mesg_token_tbl => l_mesg_token_tbl
920: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

927: end;
928:
929:
930: -- delete resource
931: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating substitute_resource . . . '); END IF;
932:
933: declare
934: l_count_po NUMBER :=0;
935: l_count_req NUMBER :=0;

Line 1013: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1009: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
1010: l_token_tbl(1).token_value := p_eam_res_rec.wip_entity_id;
1011:
1012: l_out_mesg_token_tbl := l_mesg_token_tbl;
1013: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1014: ( p_message_name => 'EAM_RES_DELETE_PO_INVALID'
1015: , p_token_tbl => l_token_tbl
1016: , p_mesg_token_tbl => l_mesg_token_tbl
1017: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 1031: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Resource Check Attributes . . . '); END IF;

1027:
1028:
1029: x_return_status := FND_API.G_RET_STS_SUCCESS;
1030:
1031: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Resource Check Attributes . . . '); END IF;
1032:
1033:
1034:
1035: END Check_Attributes;

Line 1048: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

1044:
1045: PROCEDURE Check_Required
1046: ( p_eam_res_rec IN EAM_PROCESS_WO_PUB.eam_res_rec_type
1047: , x_return_status OUT NOCOPY VARCHAR2
1048: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
1049: )
1050: IS
1051: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1052: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 1051: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

1047: , x_return_status OUT NOCOPY VARCHAR2
1048: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
1049: )
1050: IS
1051: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1052: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1053: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1054: BEGIN
1055:

Line 1052: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

1048: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
1049: )
1050: IS
1051: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1052: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1053: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1054: BEGIN
1055:
1056: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1053: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

1049: )
1050: IS
1051: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1052: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1053: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1054: BEGIN
1055:
1056: x_return_status := FND_API.G_RET_STS_SUCCESS;
1057:

Line 1064: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1060: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1061: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1062:
1063: l_out_mesg_token_tbl := l_mesg_token_tbl;
1064: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1065: ( p_message_name => 'EAM_RES_ENTITY_ID_REQUIRED'
1066: , p_token_tbl => l_Token_tbl
1067: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1068: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1083: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1079: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1080: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1081:
1082: l_out_mesg_token_tbl := l_mesg_token_tbl;
1083: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1084: ( p_message_name => 'EAM_RES_ORG_REQUIRED'
1085: , p_token_tbl => l_Token_tbl
1086: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1087: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1102: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1098: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1099: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1100:
1101: l_out_mesg_token_tbl := l_mesg_token_tbl;
1102: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1103: ( p_message_name => 'EAM_RES_OP_SEQ_REQUIRED'
1104: , p_token_tbl => l_Token_tbl
1105: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1106: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1121: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1117: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1118: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1119:
1120: l_out_mesg_token_tbl := l_mesg_token_tbl;
1121: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1122: ( p_message_name => 'EAM_RES_RES_SEQ_REQUIRED'
1123: , p_token_tbl => l_Token_tbl
1124: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1125: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1140: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1136: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1137: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1138:
1139: l_out_mesg_token_tbl := l_mesg_token_tbl;
1140: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1141: ( p_message_name => 'EAM_RES_RESOURCE_REQUIRED'
1142: , p_token_tbl => l_Token_tbl
1143: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1144: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1159: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1155: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1156: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1157:
1158: l_out_mesg_token_tbl := l_mesg_token_tbl;
1159: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1160: ( p_message_name => 'EAM_RES_BASIS_TYPE_REQUIRED'
1161: , p_token_tbl => l_Token_tbl
1162: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1163: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1178: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1174: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1175: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1176:
1177: l_out_mesg_token_tbl := l_mesg_token_tbl;
1178: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1179: ( p_message_name => 'EAM_RES_USAGE_RATE_REQUIRED'
1180: , p_token_tbl => l_Token_tbl
1181: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1182: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1197: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1193: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1194: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1195:
1196: l_out_mesg_token_tbl := l_mesg_token_tbl;
1197: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1198: ( p_message_name => 'EAM_RES_SCHEDULE_TYPE_REQUIRED'
1199: , p_token_tbl => l_Token_tbl
1200: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1201: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1216: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1212: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1213: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1214:
1215: l_out_mesg_token_tbl := l_mesg_token_tbl;
1216: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1217: ( p_message_name => 'EAM_RES_AC_TYPE_REQUIRED'
1218: , p_token_tbl => l_Token_tbl
1219: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1220: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1235: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1231: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1232: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1233:
1234: l_out_mesg_token_tbl := l_mesg_token_tbl;
1235: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1236: ( p_message_name => 'EAM_RES_STD_RATE_REQUIRED'
1237: , p_token_tbl => l_Token_tbl
1238: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1239: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1254: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1250: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1251: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1252:
1253: l_out_mesg_token_tbl := l_mesg_token_tbl;
1254: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1255: ( p_message_name => 'EAM_RES_APPL_UNIT_REQUIRED'
1256: , p_token_tbl => l_Token_tbl
1257: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1258: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1273: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1269: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1270: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1271:
1272: l_out_mesg_token_tbl := l_mesg_token_tbl;
1273: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1274: ( p_message_name => 'EAM_RES_APPL_VALUE_REQUIRED'
1275: , p_token_tbl => l_Token_tbl
1276: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1277: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1292: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1288: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1289: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1290:
1291: l_out_mesg_token_tbl := l_mesg_token_tbl;
1292: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1293: ( p_message_name => 'EAM_RES_START_DATE_REQUIRED'
1294: , p_token_tbl => l_Token_tbl
1295: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1296: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1311: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1307: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1308: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1309:
1310: l_out_mesg_token_tbl := l_mesg_token_tbl;
1311: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1312: ( p_message_name => 'EAM_RES_COMPL_DATE_REQUIRED'
1313: , p_token_tbl => l_Token_tbl
1314: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1315: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1330: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1326: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1327: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1328:
1329: l_out_mesg_token_tbl := l_mesg_token_tbl;
1330: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1331: ( p_message_name => 'EAM_RES_DEPARTMENT_REQUIRED'
1332: , p_token_tbl => l_Token_tbl
1333: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1334: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1348: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1344: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1345: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;
1346:
1347: l_out_mesg_token_tbl := l_mesg_token_tbl;
1348: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1349: ( p_message_name => 'EAM_RES_UOM_CODE_REQUIRED'
1350: , p_token_tbl => l_Token_tbl
1351: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1352: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl