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_PROCESS_WO_PVT

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 73: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND

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
76: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
77: l_token_tbl(1).token_value := p_eam_res_rec.resource_seq_num;

Line 74: p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

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

Line 90: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND

86: l_mesg_token_tbl := l_out_mesg_token_tbl;
87:
88: l_return_status := FND_API.G_RET_STS_ERROR;
89:
90: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND
91: p_eam_res_rec.transaction_type IN
92: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)
93: THEN
94: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';

Line 92: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)

88: l_return_status := FND_API.G_RET_STS_ERROR;
89:
90: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND
91: p_eam_res_rec.transaction_type IN
92: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)
93: THEN
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:

Line 121: IF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN

117: l_mesg_token_tbl := l_out_mesg_token_tbl;
118: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119:
120: ELSE /* Assign the relevant transaction type for SYNC operations */
121: IF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
122: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
123: x_old_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
124: ELSE
125: x_old_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

Line 122: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN

118: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119:
120: ELSE /* Assign the relevant transaction type for SYNC operations */
121: IF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
122: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
123: x_old_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
124: ELSE
125: x_old_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
126: END IF;

Line 123: x_old_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;

119:
120: ELSE /* Assign the relevant transaction type for SYNC operations */
121: IF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
122: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
123: x_old_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
124: ELSE
125: x_old_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
126: END IF;
127: END IF;

Line 125: x_old_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

121: IF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
122: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
123: x_old_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
124: ELSE
125: x_old_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
126: END IF;
127: END IF;
128: l_return_status := FND_API.G_RET_STS_SUCCESS;
129:

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 172: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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
173:
174: select 1
175: into g_dummy
176: from wip_operations wo

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 212: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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
213:
214: if p_eam_res_rec.start_date > p_eam_res_rec.completion_date then
215: raise fnd_api.g_exc_unexpected_error;
216: end if;

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 249: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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
250:
251: if (p_eam_res_rec.assigned_units is null or p_eam_res_rec.assigned_units < 0 ) then
252: raise fnd_api.g_exc_unexpected_error;
253: end if;

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 286: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE)) then

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
287:
288: begin
289: select 1
290: into g_dummy

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 335: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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
336:
337: select 1
338: into g_dummy
339: from bom_resources

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 389: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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
390:
391: select 1
392: into g_dummy
393: from mtl_units_of_measure

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 433: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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
434:
435: select 1
436: into g_dummy
437: from mfg_lookups

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 473: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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
474:
475: IF (p_eam_res_rec.activity_id is not NULL)
476: THEN
477:

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 519: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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
520:
521: select 1
522: into g_dummy
523: from mfg_lookups

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 559: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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
560:
561: if p_eam_res_rec.scheduled_flag not in (1,2) then
562: raise fnd_api.g_exc_error;
563: end if;

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 596: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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
597:
598: IF (p_eam_res_rec.standard_rate_flag is not NULL) and (p_eam_res_rec.standard_rate_flag not in (1, 2))
599: THEN
600:

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 650: IF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE THEN

646: bd.organization_id = p_eam_res_rec.organization_id
647: and bd.department_id = p_eam_res_rec.department_id;
648:
649: -- Check whether trying to update department (which is disallowed).
650: IF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE THEN
651: SELECT 1 into g_dummy
652: FROM wip_operation_resources wor, wip_operations wo
653: WHERE wor.wip_entity_id = p_eam_res_rec.wip_entity_id
654: AND wo.wip_entity_id = p_eam_res_rec.wip_entity_id

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 693: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

689: l_uom_time_class_flag varchar2(3);
690: l_uom_class varchar2(10);
691: begin
692:
693: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
694:
695: l_hour_uom := FND_PROFILE.value('BOM:HOUR_UOM_CODE');
696: l_hour_uom_class := WIP_OP_RESOURCES_UTILITIES.Get_Uom_Class(l_hour_uom);
697:

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 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 824: if (p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then

820: l_count_wcti NUMBER :=0;
821: l_applied_res_units NUMBER :=0;
822: begin
823:
824: if (p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
825:
826: select count(*)
827: into l_count_wt
828: from DUAL

Line 898: if (p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then

894: --if any resource instances are there we should not be able to delete the resource
895: declare
896: l_count_inst NUMBER :=0;
897: begin
898: if (p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
899: select count(*)
900: into l_count_inst
901: from wip_op_resource_instances
902: where wip_entity_id = p_eam_res_rec.wip_entity_id

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 939: if (p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then

935: l_count_req NUMBER :=0;
936: l_count_dist NUMBER :=0;
937: begin
938:
939: if (p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
940:
941: select count(*)
942: into l_count_po
943: from DUAL

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;