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.OKE_VERSION_PVT dependencies on FND_API

Line 255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

251: END IF;
252: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
253: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,statement);
254: END IF;
255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
256:
257: END version_table;
258:
259:

Line 262: , p_commit IN VARCHAR2 := FND_API.G_FALSE

258:
259:
260: PROCEDURE restore_table
261: ( p_api_version IN NUMBER
262: , p_commit IN VARCHAR2 := FND_API.G_FALSE
263: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
264: , x_msg_count OUT NOCOPY NUMBER
265: , x_msg_data OUT NOCOPY VARCHAR2
266: , x_return_status OUT NOCOPY VARCHAR2

Line 263: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

259:
260: PROCEDURE restore_table
261: ( p_api_version IN NUMBER
262: , p_commit IN VARCHAR2 := FND_API.G_FALSE
263: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
264: , x_msg_count OUT NOCOPY NUMBER
265: , x_msg_data OUT NOCOPY VARCHAR2
266: , x_return_status OUT NOCOPY VARCHAR2
267: , p_header_id IN NUMBER

Line 434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

430: END IF;
431: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,statement);
433: END IF;
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435:
436: END restore_table;
437:
438:

Line 444: , p_commit IN VARCHAR2 := FND_API.G_FALSE

440: -- Private Procedures
441: --
442: PROCEDURE version_contract
443: ( p_api_version IN NUMBER
444: , p_commit IN VARCHAR2 := FND_API.G_FALSE
445: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
446: , x_msg_count OUT NOCOPY NUMBER
447: , x_msg_data OUT NOCOPY VARCHAR2
448: , x_return_status OUT NOCOPY VARCHAR2

Line 445: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

441: --
442: PROCEDURE version_contract
443: ( p_api_version IN NUMBER
444: , p_commit IN VARCHAR2 := FND_API.G_FALSE
445: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
446: , x_msg_count OUT NOCOPY NUMBER
447: , x_msg_data OUT NOCOPY VARCHAR2
448: , x_return_status OUT NOCOPY VARCHAR2
449: , p_chr_id IN NUMBER

Line 488: x_return_status := FND_API.G_RET_STS_SUCCESS;

484:
485: --
486: -- Set API return status to success
487: --
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489: l_return_status := FND_API.G_RET_STS_SUCCESS;
490:
491: --
492: -- Check API incompatibility

Line 489: l_return_status := FND_API.G_RET_STS_SUCCESS;

485: --
486: -- Set API return status to success
487: --
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489: l_return_status := FND_API.G_RET_STS_SUCCESS;
490:
491: --
492: -- Check API incompatibility
493: --

Line 498: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

494:
495: --
496: -- Initialize the message table if requested.
497: --
498: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
499: FND_MSG_PUB.initialize;
500: END IF;
501:
502: --

Line 525: x_return_status := FND_API.G_RET_STS_ERROR;

521: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
522: FND_MESSAGE.set_name('OKE','OKE_VERS_INVALID_CONTRACT');
523: FND_MSG_PUB.add;
524: END IF;
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
528: CLOSE cvmv;
529:

Line 526: RAISE FND_API.G_EXC_ERROR;

522: FND_MESSAGE.set_name('OKE','OKE_VERS_INVALID_CONTRACT');
523: FND_MSG_PUB.add;
524: END IF;
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
528: CLOSE cvmv;
529:
530: progress := 2;

Line 543: , p_commit => FND_API.G_FALSE

539: -- Version OKC side of contract components
540: --
541: OKC_VERSION_PVT.Version_Contract
542: ( p_api_version => p_api_version
543: , p_commit => FND_API.G_FALSE
544: , p_init_msg_list => p_init_msg_list
545: , x_return_status => l_return_status
546: , x_msg_count => x_msg_count
547: , x_msg_data => x_msg_data

Line 556: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

552: --
553:
554: progress := 3;
555:
556: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
557: ROLLBACK TO version_contract_pvt;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

Line 558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

554: progress := 3;
555:
556: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
557: ROLLBACK TO version_contract_pvt;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
561: ROLLBACK TO version_contract_pvt;
562: x_return_status := FND_API.G_RET_STS_ERROR;

Line 559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

555:
556: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
557: ROLLBACK TO version_contract_pvt;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
561: ROLLBACK TO version_contract_pvt;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: RAISE FND_API.G_EXC_ERROR;

Line 560: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

556: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
557: ROLLBACK TO version_contract_pvt;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
561: ROLLBACK TO version_contract_pvt;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;

Line 562: x_return_status := FND_API.G_RET_STS_ERROR;

558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
561: ROLLBACK TO version_contract_pvt;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565:
566: progress := 4;

Line 563: RAISE FND_API.G_EXC_ERROR;

559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
561: ROLLBACK TO version_contract_pvt;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565:
566: progress := 4;
567:

Line 630: IF FND_API.TO_BOOLEAN( p_commit ) THEN

626:
627: --
628: -- Standard commit check
629: --
630: IF FND_API.TO_BOOLEAN( p_commit ) THEN
631: COMMIT;
632: END IF;
633:
634: progress := 8;

Line 646: WHEN FND_API.G_EXC_ERROR THEN

642:
643: TimeStamp('version_contract() >>');
644:
645: EXCEPTION
646: WHEN FND_API.G_EXC_ERROR THEN
647: ROLLBACK TO version_contract_pvt;
648: x_return_status := FND_API.G_RET_STS_ERROR;
649: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
650: , p_data => x_msg_data );

Line 648: x_return_status := FND_API.G_RET_STS_ERROR;

644:
645: EXCEPTION
646: WHEN FND_API.G_EXC_ERROR THEN
647: ROLLBACK TO version_contract_pvt;
648: x_return_status := FND_API.G_RET_STS_ERROR;
649: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
650: , p_data => x_msg_data );
651:
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

648: x_return_status := FND_API.G_RET_STS_ERROR;
649: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
650: , p_data => x_msg_data );
651:
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653: ROLLBACK TO version_contract_pvt;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
656: , p_data => x_msg_data );

Line 654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

650: , p_data => x_msg_data );
651:
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653: ROLLBACK TO version_contract_pvt;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
656: , p_data => x_msg_data );
657:
658: WHEN OTHERS THEN

Line 660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

656: , p_data => x_msg_data );
657:
658: WHEN OTHERS THEN
659: ROLLBACK TO version_contract_pvt;
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
662: FND_MSG_PUB.add_exc_msg
663: ( p_pkg_name => G_PKG_NAME
664: , p_procedure_name => 'VERSION_CONTRACT(' || progress || ')');

Line 676: , p_commit IN VARCHAR2 := FND_API.G_FALSE

672:
673:
674: PROCEDURE restore_contract_version
675: ( p_api_version IN NUMBER
676: , p_commit IN VARCHAR2 := FND_API.G_FALSE
677: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
678: , x_msg_count OUT NOCOPY NUMBER
679: , x_msg_data OUT NOCOPY VARCHAR2
680: , x_return_status OUT NOCOPY VARCHAR2

Line 677: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

673:
674: PROCEDURE restore_contract_version
675: ( p_api_version IN NUMBER
676: , p_commit IN VARCHAR2 := FND_API.G_FALSE
677: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
678: , x_msg_count OUT NOCOPY NUMBER
679: , x_msg_data OUT NOCOPY VARCHAR2
680: , x_return_status OUT NOCOPY VARCHAR2
681: , p_chr_id IN NUMBER

Line 721: x_return_status := FND_API.G_RET_STS_SUCCESS;

717:
718: --
719: -- Set API return status to success
720: --
721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722: l_return_status := FND_API.G_RET_STS_SUCCESS;
723:
724: --
725: -- Check API incompatibility

Line 722: l_return_status := FND_API.G_RET_STS_SUCCESS;

718: --
719: -- Set API return status to success
720: --
721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722: l_return_status := FND_API.G_RET_STS_SUCCESS;
723:
724: --
725: -- Check API incompatibility
726: --

Line 731: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

727:
728: --
729: -- Initialize the message table if requested.
730: --
731: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
732: FND_MSG_PUB.initialize;
733: END IF;
734: /* bug#4451971
735: --

Line 739: , p_commit => FND_API.G_FALSE

735: --
736: -- First version the current state of the contract
737: --
738: version_contract( p_api_version => p_api_version
739: , p_commit => FND_API.G_FALSE
740: , p_init_msg_list => FND_API.G_FALSE
741: , x_msg_count => x_msg_count
742: , x_msg_data => x_msg_data
743: , x_return_status => l_return_status

Line 740: , p_init_msg_list => FND_API.G_FALSE

736: -- First version the current state of the contract
737: --
738: version_contract( p_api_version => p_api_version
739: , p_commit => FND_API.G_FALSE
740: , p_init_msg_list => FND_API.G_FALSE
741: , x_msg_count => x_msg_count
742: , x_msg_data => x_msg_data
743: , x_return_status => l_return_status
744: , p_chr_id => p_chr_id

Line 754: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

750:
751: --
752: -- If anything happens, abort API
753: --
754: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
755: ROLLBACK TO rstr_contract_version_pvt;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

Line 756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

752: -- If anything happens, abort API
753: --
754: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
755: ROLLBACK TO rstr_contract_version_pvt;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
759: ROLLBACK TO rstr_contract_version_pvt;
760: x_return_status := FND_API.G_RET_STS_ERROR;

Line 757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

753: --
754: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
755: ROLLBACK TO rstr_contract_version_pvt;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
759: ROLLBACK TO rstr_contract_version_pvt;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: RAISE FND_API.G_EXC_ERROR;

Line 758: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

754: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
755: ROLLBACK TO rstr_contract_version_pvt;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
759: ROLLBACK TO rstr_contract_version_pvt;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;

Line 760: x_return_status := FND_API.G_RET_STS_ERROR;

756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
759: ROLLBACK TO rstr_contract_version_pvt;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763:
764: x_new_vers := l_new_vers_num;

Line 761: RAISE FND_API.G_EXC_ERROR;

757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
759: ROLLBACK TO rstr_contract_version_pvt;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763:
764: x_new_vers := l_new_vers_num;
765: end of bug#4451971 */

Line 801: IF FND_API.TO_BOOLEAN( p_commit ) THEN

797:
798: --
799: -- Standard commit check
800: --
801: IF FND_API.TO_BOOLEAN( p_commit ) THEN
802: COMMIT;
803: END IF;
804:
805: --

Line 815: WHEN FND_API.G_EXC_ERROR THEN

811:
812: TimeStamp('restore_contract_version() >>');
813:
814: EXCEPTION
815: WHEN FND_API.G_EXC_ERROR THEN
816: ROLLBACK TO rstr_contract_version_pvt;
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
819: , p_data => x_msg_data );

Line 817: x_return_status := FND_API.G_RET_STS_ERROR;

813:
814: EXCEPTION
815: WHEN FND_API.G_EXC_ERROR THEN
816: ROLLBACK TO rstr_contract_version_pvt;
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
819: , p_data => x_msg_data );
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

817: x_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
819: , p_data => x_msg_data );
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO rstr_contract_version_pvt;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
825: , p_data => x_msg_data );

Line 823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

819: , p_data => x_msg_data );
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO rstr_contract_version_pvt;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
825: , p_data => x_msg_data );
826:
827: WHEN OTHERS THEN

Line 829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

825: , p_data => x_msg_data );
826:
827: WHEN OTHERS THEN
828: ROLLBACK TO rstr_contract_version_pvt;
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
831: FND_MSG_PUB.add_exc_msg
832: ( p_pkg_name => G_PKG_NAME
833: , p_procedure_name => 'RESTORE_CONTRACT_VERSION' );