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.

[Home] [Help]

APPS.EAM_METERS_UTIL dependencies on FND_API

Line 415: x_return_status := FND_API.G_RET_STS_SUCCESS;

411: begin
412: SAVEPOINT EAM_METERS_UTIL;
413: x_assoc_id := get_activity_assoc_id(p_wip_entity_id);
414:
415: x_return_status := FND_API.G_RET_STS_SUCCESS;
416: --bug 3762560: if x_assoc_id is null, then don't process anything, just return
417: IF x_assoc_id is not null then
418: select last_service_end_date into l_last_service_end_date
419: from mtl_eam_asset_activities

Line 422: if (l_last_service_end_date <= p_wo_end_date and p_meter_reading <> FND_API.G_MISS_NUM ) then --bug# 14549822, prevents corruption of last_service_reading

418: select last_service_end_date into l_last_service_end_date
419: from mtl_eam_asset_activities
420: where activity_association_id=x_assoc_id;
421:
422: if (l_last_service_end_date <= p_wo_end_date and p_meter_reading <> FND_API.G_MISS_NUM ) then --bug# 14549822, prevents corruption of last_service_reading
423: update_last_service_reading(p_wip_entity_id, x_assoc_id, p_meter_id, p_meter_reading);
424: /* Shifted above the if condition as FIX for bug no :2752841 */
425: end if;
426: END IF;

Line 434: WHEN FND_API.G_EXC_ERROR THEN

430: ( p_count => x_msg_count ,
431: p_data => x_msg_data
432: );
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO EAM_METERS_UTIL;
436: x_return_status := FND_API.G_RET_STS_ERROR ;
437: FND_MSG_PUB.Count_And_Get
438: ( p_count => x_msg_count ,

Line 436: x_return_status := FND_API.G_RET_STS_ERROR ;

432: );
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO EAM_METERS_UTIL;
436: x_return_status := FND_API.G_RET_STS_ERROR ;
437: FND_MSG_PUB.Count_And_Get
438: ( p_count => x_msg_count ,
439: p_data => x_msg_data
440: );

Line 441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

437: FND_MSG_PUB.Count_And_Get
438: ( p_count => x_msg_count ,
439: p_data => x_msg_data
440: );
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: ROLLBACK TO EAM_METERS_UTIL;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: FND_MSG_PUB.Count_And_Get
445: ( p_count => x_msg_count ,

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

439: p_data => x_msg_data
440: );
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: ROLLBACK TO EAM_METERS_UTIL;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: FND_MSG_PUB.Count_And_Get
445: ( p_count => x_msg_count ,
446: p_data => x_msg_data
447: );

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

446: p_data => x_msg_data
447: );
448: WHEN OTHERS THEN
449: ROLLBACK TO EAM_METERS_UTIL;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: IF FND_MSG_PUB.Check_Msg_Level
452: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg

Line 498: x_return_status := FND_API.G_RET_STS_SUCCESS;

494:
495: if x_assoc_id is not null then
496:
497: update_last_service_dates(p_wip_entity_id, x_assoc_id, p_start_date, p_end_date);
498: x_return_status := FND_API.G_RET_STS_SUCCESS;
499:
500: --check if workorder is pm suggested workorder or not
501: BEGIN
502: SELECT wdj.pm_schedule_id,ewod.cycle_id,ewod.seq_id

Line 538: p_commit => FND_API.G_FALSE ,

534: --if pm generate workorder then update last cyclic actviity of the PM
535: EAM_PMDEF_PUB.Update_Pm_Last_Cyclic_Act
536: ( X_Return_Status => x_return_status,
537: p_api_version => 1.0 ,
538: p_commit => FND_API.G_FALSE ,
539: X_msg_count => x_msg_count ,
540: X_msg_data => x_msg_data ,
541: p_pm_schedule_id =>l_pm_schedule_id
542: );

Line 550: x_return_status := FND_API.G_RET_STS_ERROR;

546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN
548: NULL;
549: WHEN OTHERS THEN
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: END;
552:
553:
554:

Line 563: WHEN FND_API.G_EXC_ERROR THEN

559: ( p_count => x_msg_count ,
560: p_data => x_msg_data
561: );
562: EXCEPTION
563: WHEN FND_API.G_EXC_ERROR THEN
564: ROLLBACK TO EAM_METERS_UTIL;
565: x_return_status := FND_API.G_RET_STS_ERROR ;
566: FND_MSG_PUB.Count_And_Get
567: ( p_count => x_msg_count ,

Line 565: x_return_status := FND_API.G_RET_STS_ERROR ;

561: );
562: EXCEPTION
563: WHEN FND_API.G_EXC_ERROR THEN
564: ROLLBACK TO EAM_METERS_UTIL;
565: x_return_status := FND_API.G_RET_STS_ERROR ;
566: FND_MSG_PUB.Count_And_Get
567: ( p_count => x_msg_count ,
568: p_data => x_msg_data
569: );

Line 570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

566: FND_MSG_PUB.Count_And_Get
567: ( p_count => x_msg_count ,
568: p_data => x_msg_data
569: );
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: ROLLBACK TO EAM_METERS_UTIL;
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: FND_MSG_PUB.Count_And_Get
574: ( p_count => x_msg_count ,

Line 572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

568: p_data => x_msg_data
569: );
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: ROLLBACK TO EAM_METERS_UTIL;
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: FND_MSG_PUB.Count_And_Get
574: ( p_count => x_msg_count ,
575: p_data => x_msg_data
576: );

Line 579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

575: p_data => x_msg_data
576: );
577: WHEN OTHERS THEN
578: ROLLBACK TO EAM_METERS_UTIL;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
580: IF FND_MSG_PUB.Check_Msg_Level
581: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: FND_MSG_PUB.Add_Exc_Msg

Line 619: x_return_status := FND_API.G_RET_STS_SUCCESS;

615: x_assoc_id := get_activity_assoc_id(p_wip_entity_id);
616:
617: if x_assoc_id is not null then
618: update_last_service_dates(p_wip_entity_id, x_assoc_id, p_start_date, p_end_date);
619: x_return_status := FND_API.G_RET_STS_SUCCESS;
620:
621: --check if workorder is pm suggested workorder or not
622: BEGIN
623: SELECT wdj.pm_schedule_id,ewod.cycle_id,ewod.seq_id

Line 644: p_commit => FND_API.G_FALSE ,

640: --if pm generate workorder then update last cyclic actviity of the PM
641: EAM_PMDEF_PUB.Update_Pm_Last_Cyclic_Act
642: ( X_Return_Status => x_return_status,
643: p_api_version => 1.0 ,
644: p_commit => FND_API.G_FALSE ,
645: X_msg_count => x_msg_count ,
646: X_msg_data => x_msg_data ,
647: p_pm_schedule_id =>l_pm_schedule_id
648: );

Line 656: x_return_status := FND_API.G_RET_STS_ERROR;

652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
654: NULL;
655: WHEN OTHERS THEN
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: END;
658:
659: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
660: COMMIT;

Line 659: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

655: WHEN OTHERS THEN
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: END;
658:
659: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
660: COMMIT;
661: ELSE
662: ROLLBACK TO EAM_METERS_UTIL_NEW;
663: END IF;

Line 672: WHEN FND_API.G_EXC_ERROR THEN

668: ( p_count => x_msg_count ,
669: p_data => x_msg_data
670: );
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: ROLLBACK TO EAM_METERS_UTIL_NEW;
674: x_return_status := FND_API.G_RET_STS_ERROR ;
675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count ,

Line 674: x_return_status := FND_API.G_RET_STS_ERROR ;

670: );
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: ROLLBACK TO EAM_METERS_UTIL_NEW;
674: x_return_status := FND_API.G_RET_STS_ERROR ;
675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count ,
677: p_data => x_msg_data
678: );

Line 679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count ,
677: p_data => x_msg_data
678: );
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: ROLLBACK TO EAM_METERS_UTIL_NEW;
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
682: FND_MSG_PUB.Count_And_Get
683: ( p_count => x_msg_count ,

Line 681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

677: p_data => x_msg_data
678: );
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: ROLLBACK TO EAM_METERS_UTIL_NEW;
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
682: FND_MSG_PUB.Count_And_Get
683: ( p_count => x_msg_count ,
684: p_data => x_msg_data
685: );

Line 688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

684: p_data => x_msg_data
685: );
686: WHEN OTHERS THEN
687: ROLLBACK TO EAM_METERS_UTIL_NEW;
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
689: IF FND_MSG_PUB.Check_Msg_Level
690: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: FND_MSG_PUB.Add_Exc_Msg

Line 1507: x_return_status := FND_API.G_RET_STS_SUCCESS;

1503: l_exists := 'N';
1504: END;
1505:
1506: IF(l_exists='N') THEN
1507: x_return_status := FND_API.G_RET_STS_SUCCESS;
1508: ELSE
1509: x_return_status := FND_API.G_RET_STS_ERROR ;
1510: fnd_message.set_name('EAM', 'EAM_METER_USED_IN_PM');
1511: fnd_msg_pub.add;

Line 1509: x_return_status := FND_API.G_RET_STS_ERROR ;

1505:
1506: IF(l_exists='N') THEN
1507: x_return_status := FND_API.G_RET_STS_SUCCESS;
1508: ELSE
1509: x_return_status := FND_API.G_RET_STS_ERROR ;
1510: fnd_message.set_name('EAM', 'EAM_METER_USED_IN_PM');
1511: fnd_msg_pub.add;
1512: END IF;
1513:

Line 1520: WHEN FND_API.G_EXC_ERROR THEN

1516: ( p_count => x_msg_count ,
1517: p_data => x_msg_data
1518: );
1519: EXCEPTION
1520: WHEN FND_API.G_EXC_ERROR THEN
1521: x_return_status := FND_API.G_RET_STS_ERROR ;
1522: FND_MSG_PUB.Count_And_Get
1523: ( p_count => x_msg_count ,
1524: p_data => x_msg_data

Line 1521: x_return_status := FND_API.G_RET_STS_ERROR ;

1517: p_data => x_msg_data
1518: );
1519: EXCEPTION
1520: WHEN FND_API.G_EXC_ERROR THEN
1521: x_return_status := FND_API.G_RET_STS_ERROR ;
1522: FND_MSG_PUB.Count_And_Get
1523: ( p_count => x_msg_count ,
1524: p_data => x_msg_data
1525: );

Line 1526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1522: FND_MSG_PUB.Count_And_Get
1523: ( p_count => x_msg_count ,
1524: p_data => x_msg_data
1525: );
1526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1528: FND_MSG_PUB.Count_And_Get
1529: ( p_count => x_msg_count ,
1530: p_data => x_msg_data

Line 1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1523: ( p_count => x_msg_count ,
1524: p_data => x_msg_data
1525: );
1526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1528: FND_MSG_PUB.Count_And_Get
1529: ( p_count => x_msg_count ,
1530: p_data => x_msg_data
1531: );

Line 1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1529: ( p_count => x_msg_count ,
1530: p_data => x_msg_data
1531: );
1532: WHEN OTHERS THEN
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1534: IF FND_MSG_PUB.Check_Msg_Level
1535: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1536: THEN
1537: FND_MSG_PUB.Add_Exc_Msg