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_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 130: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

126: AND organization_id = p_organization_id
127: AND operation_seq_num = p_operation_seq_num
128: AND resource_seq_num = p_resource_seq_num;
129:
130: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
131: x_eam_res_rec := l_eam_res_rec;
132:
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN

Line 135: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;

131: x_eam_res_rec := l_eam_res_rec;
132:
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
136: x_eam_res_rec := l_eam_res_rec;
137:
138: WHEN OTHERS THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 166: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Resource rec for ' || p_eam_res_rec.resource_seq_num); END IF;

162: l_msg_data VARCHAR2(2000) := '';
163:
164: BEGIN
165:
166: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Resource rec for ' || p_eam_res_rec.resource_seq_num); END IF;
167:
168: -- bug no 3444091
169: if p_eam_res_rec.start_date > p_eam_res_rec.completion_date then
170: x_return_status := fnd_api.g_ret_sts_error;

Line 274: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new resources') ; END IF;

270: , p_eam_res_rec.program_application_id
271: , p_eam_res_rec.program_id
272: , SYSDATE);
273:
274: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new resources') ; END IF;
275:
276:
277: x_return_status := FND_API.G_RET_STS_SUCCESS;
278:

Line 329: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Resource: '|| p_eam_res_rec.resource_seq_num); END IF;

325: l_usage_rate_or_amount NUMBER := 0;
326:
327: BEGIN
328:
329: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Resource: '|| p_eam_res_rec.resource_seq_num); END IF;
330:
331: -- bug no 3444091
332: if p_eam_res_rec.start_date > p_eam_res_rec.completion_date then
333: x_return_status := fnd_api.g_ret_sts_error;

Line 394: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Updating resources') ; END IF;

390: AND organization_id = p_eam_res_rec.organization_id
391: AND operation_seq_num = p_eam_res_rec.operation_seq_num
392: AND resource_seq_num = p_eam_res_rec.resource_seq_num;
393:
394: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Updating resources') ; END IF;
395:
396: x_return_status := FND_API.G_RET_STS_SUCCESS;
397:
398: -- comparing new usage rate with existing

Line 443: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Deleting Resource Usage') ; END IF;

439: l_msg_data VARCHAR2(2000) := '';
440:
441: BEGIN
442:
443: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Deleting Resource Usage') ; END IF;
444:
445: EAM_RES_USAGE_UTILITY_PVT.Delete_Usage
446: ( p_wip_entity_id => p_eam_res_rec.wip_entity_id
447: , p_organization_id => p_eam_res_rec.organization_id

Line 454: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance for '|| p_eam_res_rec.resource_seq_num); END IF;

450: , x_mesg_token_Tbl => l_mesg_token_Tbl
451: , x_return_Status => l_return_Status
452: );
453:
454: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance for '|| p_eam_res_rec.resource_seq_num); END IF;
455:
456: DELETE FROM WIP_OP_RESOURCE_INSTANCES
457: WHERE wip_entity_id = p_eam_res_rec.wip_entity_id
458: AND organization_id = p_eam_res_rec.organization_id

Line 463: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource: '|| p_eam_res_rec.resource_seq_num); END IF;

459: AND operation_seq_num = p_eam_res_rec.operation_seq_num
460: AND resource_seq_num = p_eam_res_rec.resource_seq_num;
461:
462:
463: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource: '|| p_eam_res_rec.resource_seq_num); END IF;
464:
465: DELETE FROM WIP_OPERATION_RESOURCES
466: WHERE wip_entity_id = p_eam_res_rec.wip_entity_id
467: AND organization_id = p_eam_res_rec.organization_id

Line 514: IF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

510: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
511: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
512: BEGIN
513:
514: IF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
515: THEN
516: Insert_Row
517: ( p_eam_res_rec => p_eam_res_rec
518: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 521: ELSIF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE

517: ( p_eam_res_rec => p_eam_res_rec
518: , x_mesg_token_Tbl => l_mesg_token_tbl
519: , x_return_Status => l_return_status
520: );
521: ELSIF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
522: THEN
523: Update_Row
524: ( p_eam_res_rec => p_eam_res_rec
525: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 528: ELSIF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE

524: ( p_eam_res_rec => p_eam_res_rec
525: , x_mesg_token_Tbl => l_mesg_token_tbl
526: , x_return_Status => l_return_status
527: );
528: ELSIF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE
529: THEN
530: Delete_Row
531: ( p_eam_res_rec => p_eam_res_rec
532: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 586: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing osp creation for resource'|| I || ' record') ; END IF ;

582:
583: FOR I IN 1..p_eam_res_tbl.COUNT LOOP
584:
585:
586: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing osp creation for resource'|| I || ' record') ; END IF ;
587:
588: -- Load local records.
589: l_eam_res_rec := p_eam_res_tbl(I);
590:

Line 591: IF(l_eam_res_rec.transaction_type= EAM_PROCESS_WO_PVT.G_OPR_CREATE AND

587:
588: -- Load local records.
589: l_eam_res_rec := p_eam_res_tbl(I);
590:
591: IF(l_eam_res_rec.transaction_type= EAM_PROCESS_WO_PVT.G_OPR_CREATE AND
592: l_eam_res_rec.autocharge_type=WIP_CONSTANTS.PO_RECEIPT) THEN
593:
594: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('inside if to create req') ; END IF ;
595: WIP_OSP.CREATE_REQUISITION(

Line 594: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('inside if to create req') ; END IF ;

590:
591: IF(l_eam_res_rec.transaction_type= EAM_PROCESS_WO_PVT.G_OPR_CREATE AND
592: l_eam_res_rec.autocharge_type=WIP_CONSTANTS.PO_RECEIPT) THEN
593:
594: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('inside if to create req') ; END IF ;
595: WIP_OSP.CREATE_REQUISITION(
596: P_Wip_Entity_Id =>l_eam_res_rec.wip_entity_id,
597: P_Organization_Id =>l_eam_res_rec.organization_id,
598: P_Repetitive_Schedule_Id =>NULL,

Line 610: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exception in creating req for osp') ; END IF ;

606: END LOOP;
607: EXCEPTION
608: WHEN OTHERS THEN
609: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
610: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exception in creating req for osp') ; END IF ;
611: END CREATE_OSP_REQ;
612:
613:
614: