DBA Data[Home] [Help]

APPS.EAM_METERS_UTIL dependencies on FND_API

Line 414: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 433: WHEN FND_API.G_EXC_ERROR THEN

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

Line 435: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 497: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 535: p_commit => FND_API.G_FALSE ,

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

Line 547: x_return_status := FND_API.G_RET_STS_ERROR;

543: EXCEPTION
544: WHEN NO_DATA_FOUND THEN
545: NULL;
546: WHEN OTHERS THEN
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END;
549:
550:
551:

Line 560: WHEN FND_API.G_EXC_ERROR THEN

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

Line 562: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 616: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 641: p_commit => FND_API.G_FALSE ,

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

Line 653: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 669: WHEN FND_API.G_EXC_ERROR THEN

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

Line 671: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1503: x_return_status := FND_API.G_RET_STS_SUCCESS;

1499: l_exists := 'N';
1500: END;
1501:
1502: IF(l_exists='N') THEN
1503: x_return_status := FND_API.G_RET_STS_SUCCESS;
1504: ELSE
1505: x_return_status := FND_API.G_RET_STS_ERROR ;
1506: fnd_message.set_name('EAM', 'EAM_METER_USED_IN_PM');
1507: fnd_msg_pub.add;

Line 1505: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1516: WHEN FND_API.G_EXC_ERROR THEN

1512: ( p_count => x_msg_count ,
1513: p_data => x_msg_data
1514: );
1515: EXCEPTION
1516: WHEN FND_API.G_EXC_ERROR THEN
1517: x_return_status := FND_API.G_RET_STS_ERROR ;
1518: FND_MSG_PUB.Count_And_Get
1519: ( p_count => x_msg_count ,
1520: p_data => x_msg_data

Line 1517: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1518: FND_MSG_PUB.Count_And_Get
1519: ( p_count => x_msg_count ,
1520: p_data => x_msg_data
1521: );
1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1524: FND_MSG_PUB.Count_And_Get
1525: ( p_count => x_msg_count ,
1526: p_data => x_msg_data

Line 1523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1525: ( p_count => x_msg_count ,
1526: p_data => x_msg_data
1527: );
1528: WHEN OTHERS THEN
1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1530: IF FND_MSG_PUB.Check_Msg_Level
1531: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1532: THEN
1533: FND_MSG_PUB.Add_Exc_Msg