DBA Data[Home] [Help]

APPS.IGS_RE_THE_LGCY_PUB dependencies on FND_API

Line 483: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,

479: -- Standard Start of API savepoint
480: SAVEPOINT THEDET_PUB;
481:
482: -- Standard call to check for call compatibility.
483: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,
484: p_api_version,
485: l_api_name,
486: g_pkg_name ) THEN
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

483: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,
484: p_api_version,
485: l_api_name,
486: g_pkg_name ) THEN
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: END IF;
489:
490: -- Initialize message list if p_init_msg_list is set to TRUE.
491: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

Line 491: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: END IF;
489:
490: -- Initialize message list if p_init_msg_list is set to TRUE.
491: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
492: FND_MSG_PUB.INITIALIZE;
493: END IF;
494:
495: -- Initialize API return status to success

Line 496: x_return_status := FND_API.G_RET_STS_SUCCESS;

492: FND_MSG_PUB.INITIALIZE;
493: END IF;
494:
495: -- Initialize API return status to success
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497:
498: /****** Validating all the parameters available ******/
499: validate_parameters( p_the_dtls_rec,
500: l_the_exam_status );

Line 684: x_return_status := FND_API.G_RET_STS_ERROR ;

680: END IF; --1st level IF clause ends here
681:
682: IF l_the_exam_status = 'INVALID' THEN
683: IF x_return_status <> 'W' THEN
684: x_return_status := FND_API.G_RET_STS_ERROR ;
685: END IF;
686: ROLLBACK TO THEDET_PUB;
687: ELSIF l_the_exam_status = 'VALID' THEN
688: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 688: x_return_status := FND_API.G_RET_STS_SUCCESS ;

684: x_return_status := FND_API.G_RET_STS_ERROR ;
685: END IF;
686: ROLLBACK TO THEDET_PUB;
687: ELSIF l_the_exam_status = 'VALID' THEN
688: x_return_status := FND_API.G_RET_STS_SUCCESS ;
689: -- Standard check of p_commit.
690: IF FND_API.To_Boolean( p_commit ) THEN
691: COMMIT WORK;
692: END IF;

Line 690: IF FND_API.To_Boolean( p_commit ) THEN

686: ROLLBACK TO THEDET_PUB;
687: ELSIF l_the_exam_status = 'VALID' THEN
688: x_return_status := FND_API.G_RET_STS_SUCCESS ;
689: -- Standard check of p_commit.
690: IF FND_API.To_Boolean( p_commit ) THEN
691: COMMIT WORK;
692: END IF;
693: END IF;
694:

Line 701: WHEN FND_API.G_EXC_ERROR THEN

697: p_count => x_msg_count,
698: p_data => x_msg_data );
699:
700: EXCEPTION
701: WHEN FND_API.G_EXC_ERROR THEN
702: ROLLBACK TO THEDET_PUB;
703: x_return_status := FND_API.G_RET_STS_ERROR ;
704: FND_MSG_PUB.Count_And_Get (
705: p_count => x_msg_count,

Line 703: x_return_status := FND_API.G_RET_STS_ERROR ;

699:
700: EXCEPTION
701: WHEN FND_API.G_EXC_ERROR THEN
702: ROLLBACK TO THEDET_PUB;
703: x_return_status := FND_API.G_RET_STS_ERROR ;
704: FND_MSG_PUB.Count_And_Get (
705: p_count => x_msg_count,
706: p_data => x_msg_data );
707:

Line 708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

704: FND_MSG_PUB.Count_And_Get (
705: p_count => x_msg_count,
706: p_data => x_msg_data );
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO THEDET_PUB;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
711: FND_MSG_PUB.Count_And_Get (
712: p_count => x_msg_count,

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

706: p_data => x_msg_data );
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO THEDET_PUB;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
711: FND_MSG_PUB.Count_And_Get (
712: p_count => x_msg_count,
713: p_data => x_msg_data );
714:

Line 717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

713: p_data => x_msg_data );
714:
715: WHEN OTHERS THEN
716: ROLLBACK TO THEDET_PUB;
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
718: IF FND_MSG_PUB.Check_Msg_Level
719: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
720: THEN
721: FND_MSG_PUB.Add_Exc_Msg