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_SUB_RESOURCE_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_SUB_RESOURCE_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_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
49: , x_old_eam_sub_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_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 Sub Resource'); END IF;

Line 60: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Sub 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 Sub Resource'); END IF;
61:
62: EAM_SUB_RESOURCE_UTILITY_PVT.Query_Row
63: ( p_wip_entity_id => p_eam_sub_res_rec.wip_entity_id
64: , p_organization_id => p_eam_sub_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_sub_res_rec => x_old_eam_sub_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_sub_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_sub_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_SR_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_sub_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_SR_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 ' || 'Sub Resource '|| p_eam_sub_res_rec.resource_seq_num , p_token_tbl => l_token_tbl

Line 152: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

148: PROCEDURE Check_Attributes
149: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
150: , p_old_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
151: , x_return_status OUT NOCOPY VARCHAR2
152: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
153: )
154: IS
155: l_err_text VARCHAR2(2000) := NULL;
156: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 156: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

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

Line 157: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

153: )
154: IS
155: l_err_text VARCHAR2(2000) := NULL;
156: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
157: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
158: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
159:
160: BEGIN
161:

Line 158: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

154: IS
155: l_err_text VARCHAR2(2000) := NULL;
156: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
157: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
158: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
159:
160: BEGIN
161:
162:

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

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

Line 190: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

186: l_token_tbl(1).token_name := 'OP_SEQ_NUM';
187: l_token_tbl(1).token_value := p_eam_sub_res_rec.operation_seq_num;
188:
189: l_out_mesg_token_tbl := l_mesg_token_tbl;
190: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
191: ( p_message_name => 'EAM_SR_OP_SEQ_INVALID'
192: , p_token_tbl => l_token_tbl
193: , p_mesg_token_tbl => l_mesg_token_tbl
194: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

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

Line 227: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

223: l_token_tbl(1).token_name := 'START_DATE';
224: l_token_tbl(1).token_value := p_eam_sub_res_rec.start_date;
225:
226: l_out_mesg_token_tbl := l_mesg_token_tbl;
227: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
228: ( p_message_name => 'EAM_SR_START_DATE_INVALID'
229: , p_token_tbl => l_token_tbl
230: , p_mesg_token_tbl => l_mesg_token_tbl
231: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

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

Line 264: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

260: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
261: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
262:
263: l_out_mesg_token_tbl := l_mesg_token_tbl;
264: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
265: ( p_message_name => 'EAM_SR_ASSIGNED_UNIT_INVALID'
266: , p_token_tbl => l_token_tbl
267: , p_mesg_token_tbl => l_mesg_token_tbl
268: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

276: end;
277:
278:
279: -- resource_id
280: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating resource_id . . . '); END IF;
281:
282: begin
283:
284: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 303: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

299: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
300: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
301:
302: l_out_mesg_token_tbl := l_mesg_token_tbl;
303: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
304: ( p_message_name => 'EAM_SR_RESOURCE_INVALID'
305: , p_token_tbl => l_token_tbl
306: , p_mesg_token_tbl => l_mesg_token_tbl
307: , 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('Validating uom_code . . . '); END IF;

315: end;
316:
317:
318: -- uom_code
319: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating uom_code . . . '); END IF;
320:
321: begin
322:
323: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 341: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

337: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
338: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
339:
340: l_out_mesg_token_tbl := l_mesg_token_tbl;
341: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
342: ( p_message_name => 'EAM_SR_UOM_INVALID'
343: , p_token_tbl => l_token_tbl
344: , p_mesg_token_tbl => l_mesg_token_tbl
345: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

353: end;
354:
355:
356: -- basis_type
357: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating basis_type . . . '); END IF;
358:
359: begin
360:
361: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 381: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

377: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
378: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
379:
380: l_out_mesg_token_tbl := l_mesg_token_tbl;
381: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
382: ( p_message_name => 'EAM_SR_BASIS_TYPE_INVALID'
383: , p_token_tbl => l_token_tbl
384: , p_mesg_token_tbl => l_mesg_token_tbl
385: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

393: end;
394:
395:
396: -- activity_id
397: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating activity_id . . . '); END IF;
398:
399: begin
400:
401: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 426: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

422: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
423: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
424:
425: l_out_mesg_token_tbl := l_mesg_token_tbl;
426: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
427: ( p_message_name => 'EAM_SR_ACTIVITY_INVALID'
428: , p_token_tbl => l_token_tbl
429: , p_mesg_token_tbl => l_mesg_token_tbl
430: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

438: end;
439:
440:
441: -- autocharge_type
442: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating autocharge_type . . . '); END IF;
443:
444: begin
445:
446: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 466: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

462: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
463: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
464:
465: l_out_mesg_token_tbl := l_mesg_token_tbl;
466: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
467: ( p_message_name => 'EAM_SR_AC_TYPE_INVALID'
468: , p_token_tbl => l_token_tbl
469: , p_mesg_token_tbl => l_mesg_token_tbl
470: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

478: end;
479:
480:
481: -- scheduled_flag
482: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating schedule_flag . . . '); END IF;
483:
484: begin
485:
486: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 505: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

501: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
502: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
503:
504: l_out_mesg_token_tbl := l_mesg_token_tbl;
505: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
506: ( p_message_name => 'EAM_SR_SCHEDULE_TYPE_INVALID'
507: , p_token_tbl => l_token_tbl
508: , p_mesg_token_tbl => l_mesg_token_tbl
509: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

517: end;
518:
519:
520: -- standard_rate_flag
521: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating schedule_flag . . . '); END IF;
522:
523: begin
524:
525: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 545: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

541: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
542: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
543:
544: l_out_mesg_token_tbl := l_mesg_token_tbl;
545: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
546: ( p_message_name => 'EAM_SR_STANDARD_RATE_INVALID'
547: , p_token_tbl => l_token_tbl
548: , p_mesg_token_tbl => l_mesg_token_tbl
549: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 560: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Department. . .

556:
557: end;
558:
559: -- department_id
560: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Department. . .
561: '); END IF;
562:
563: begin
564:

Line 598: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

594: exception
595: when others then
596:
597: l_out_mesg_token_tbl := l_mesg_token_tbl;
598: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
599: ( p_message_name => 'EAM_SR_DEPARTMENT_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 usage_rate_or_amount . . . '); END IF;

611:
612:
613:
614: -- usage_rate_or_amount
615: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating usage_rate_or_amount . . . '); END IF;
616: declare
617: l_hour_uom varchar2(50);
618: l_hour_uom_class varchar2(200);
619: l_uom_time_class_flag varchar2(3);

Line 658: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

654: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
655: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
656:
657: l_out_mesg_token_tbl := l_mesg_token_tbl;
658: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
659: ( p_message_name => 'EAM_SR_USAGE_RATE_INVALID'
660: , p_token_tbl => l_token_tbl
661: , p_mesg_token_tbl => l_mesg_token_tbl
662: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

671:
672:
673:
674: -- delete substitute_resource
675: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating substitute_resource . . . '); END IF;
676:
677: declare
678: l_count_wt NUMBER :=0;
679: l_count_wcti NUMBER :=0;

Line 739: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

735: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
736: l_token_tbl(1).token_value := p_eam_sub_res_rec.wip_entity_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_SR_DELETE_INVALID'
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 755: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating substitute_resource . . . '); END IF;

751: end;
752:
753:
754: -- delete substitute_resource
755: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating substitute_resource . . . '); END IF;
756:
757: declare
758: l_count_po NUMBER :=0;
759: l_count_req NUMBER :=0;

Line 823: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

819: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
820: l_token_tbl(1).token_value := p_eam_sub_res_rec.wip_entity_id;
821:
822: l_out_mesg_token_tbl := l_mesg_token_tbl;
823: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
824: ( p_message_name => 'EAM_SR_DELETE_PO_INVALID'
825: , p_token_tbl => l_token_tbl
826: , p_mesg_token_tbl => l_mesg_token_tbl
827: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

837:
838:
839: x_return_status := FND_API.G_RET_STS_SUCCESS;
840:
841: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Sub Resource Check Attributes . . . '); END IF;
842:
843:
844:
845: END Check_Attributes;

Line 858: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

854:
855: PROCEDURE Check_Required
856: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
857: , x_return_status OUT NOCOPY VARCHAR2
858: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
859: )
860: IS
861: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
862: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 861: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

857: , x_return_status OUT NOCOPY VARCHAR2
858: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
859: )
860: IS
861: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
862: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
863: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
864: BEGIN
865:

Line 862: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

858: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
859: )
860: IS
861: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
862: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
863: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
864: BEGIN
865:
866: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 863: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

859: )
860: IS
861: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
862: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
863: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
864: BEGIN
865:
866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867:

Line 874: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

870: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
871: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
872:
873: l_out_mesg_token_tbl := l_mesg_token_tbl;
874: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
875: ( p_message_name => 'EAM_SR_ENTITY_ID_REQUIRED'
876: , p_token_tbl => l_Token_tbl
877: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
878: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 893: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

889: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
890: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
891:
892: l_out_mesg_token_tbl := l_mesg_token_tbl;
893: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
894: ( p_message_name => 'EAM_SR_ORG_REQUIRED'
895: , p_token_tbl => l_Token_tbl
896: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
897: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 912: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

908: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
909: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
910:
911: l_out_mesg_token_tbl := l_mesg_token_tbl;
912: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
913: ( p_message_name => 'EAM_SR_OP_SEQ_REQUIRED'
914: , p_token_tbl => l_Token_tbl
915: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
916: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 931: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

927: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
928: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
929:
930: l_out_mesg_token_tbl := l_mesg_token_tbl;
931: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
932: ( p_message_name => 'EAM_SR_RES_SEQ_REQUIRED'
933: , p_token_tbl => l_Token_tbl
934: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
935: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 950: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

946: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
947: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
948:
949: l_out_mesg_token_tbl := l_mesg_token_tbl;
950: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
951: ( p_message_name => 'EAM_SR_RESOURCE_REQUIRED'
952: , p_token_tbl => l_Token_tbl
953: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
954: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 969: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

965: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
966: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
967:
968: l_out_mesg_token_tbl := l_mesg_token_tbl;
969: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
970: ( p_message_name => 'EAM_SR_BASIS_TYPE_REQUIRED'
971: , p_token_tbl => l_Token_tbl
972: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
973: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 988: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

984: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
985: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
986:
987: l_out_mesg_token_tbl := l_mesg_token_tbl;
988: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
989: ( p_message_name => 'EAM_SR_USAGE_RATE_REQUIRED'
990: , p_token_tbl => l_Token_tbl
991: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
992: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1007: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1003: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1004: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
1005:
1006: l_out_mesg_token_tbl := l_mesg_token_tbl;
1007: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1008: ( p_message_name => 'EAM_SR_SCHEDULE_TYPE_REQUIRED'
1009: , p_token_tbl => l_Token_tbl
1010: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1011: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1026: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1022: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1023: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
1024:
1025: l_out_mesg_token_tbl := l_mesg_token_tbl;
1026: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1027: ( p_message_name => 'EAM_SR_AC_REQUIRED'
1028: , p_token_tbl => l_Token_tbl
1029: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1030: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 1045: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1041: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
1042: l_token_tbl(1).token_value := p_eam_sub_res_rec.resource_seq_num;
1043:
1044: l_out_mesg_token_tbl := l_mesg_token_tbl;
1045: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1046: ( p_message_name => 'EAM_SR_STD_RATE_REQUIRED'
1047: , p_token_tbl => l_Token_tbl
1048: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1049: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

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_sub_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_SR_APPL_UNIT_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_sub_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_SR_APPL_VALUE_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_sub_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_SR_START_DATE_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_sub_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_SR_COMPL_DATE_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 1137: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1133: IF p_eam_sub_res_rec.department_id IS NULL
1134: THEN
1135:
1136: l_out_mesg_token_tbl := l_mesg_token_tbl;
1137: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1138: ( p_message_name => 'EAM_SR_DEPARTMENT_REQUIRED'
1139: , p_token_tbl => l_Token_tbl
1140: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1141: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl