DBA Data[Home] [Help]

APPS.IEX_PROFILE dependencies on FND_API

Line 519: IF NOT FND_API.Compatible_API_Call (l_api_version,

515:
516: SAVEPOINT Get_Profile_Info_PVT;
517:
518: -- Standard call to check for call compatibility.
519: IF NOT FND_API.Compatible_API_Call (l_api_version,
520: p_api_version,
521: l_api_name,
522: G_PKG_NAME) THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

519: IF NOT FND_API.Compatible_API_Call (l_api_version,
520: p_api_version,
521: l_api_name,
522: G_PKG_NAME) THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525:
526: -- Check p_init_msg_list
527: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 527: IF FND_API.to_Boolean( p_init_msg_list ) THEN

523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525:
526: -- Check p_init_msg_list
527: IF FND_API.to_Boolean( p_init_msg_list ) THEN
528: FND_MSG_PUB.initialize;
529: END IF;
530:
531: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 531: x_return_status := FND_API.G_RET_STS_SUCCESS;

527: IF FND_API.to_Boolean( p_init_msg_list ) THEN
528: FND_MSG_PUB.initialize;
529: END IF;
530:
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532: --Bug4562698. Moved the Constructor to GET_PROFILE_INFO. Begin.
533: Begin
534: SELECT distinct sob.currency_code
535: INTO g_curr_rec.base_currency

Line 652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

648: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
649: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CUSTOMER_PROFILE_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
650: END IF;
651: ROLLBACK TO Get_Profile_Info_PVT;
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
654: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
655: END IF;
656: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

740: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
741: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CUSTOMER_PROFILE_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
742: END IF;
743: ROLLBACK TO Get_Profile_Info_PVT;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
746: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
747: END IF;
748: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

803: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CREDIT - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
804:
805: END IF;
806: ROLLBACK TO Get_Profile_Info_PVT;
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
809: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
810: END IF;
811: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 817: IF FND_API.To_Boolean(p_commit) THEN

813:
814: x_profile_rec := l_profile_rec ;
815:
816: -- Standard check of p_commit
817: IF FND_API.To_Boolean(p_commit) THEN
818: COMMIT WORK;
819: END IF;
820:
821: -- Standard call to get message count AND IF count is 1, get message info

Line 824: WHEN FND_API.G_EXC_ERROR THEN

820:
821: -- Standard call to get message count AND IF count is 1, get message info
822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
823: EXCEPTION
824: WHEN FND_API.G_EXC_ERROR THEN
825: ROLLBACK TO Get_Profile_Info_PVT;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
828:

Line 826: x_return_status := FND_API.G_RET_STS_ERROR;

822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
823: EXCEPTION
824: WHEN FND_API.G_EXC_ERROR THEN
825: ROLLBACK TO Get_Profile_Info_PVT;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
828:
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: ROLLBACK TO Get_Profile_Info_PVT;

Line 829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

825: ROLLBACK TO Get_Profile_Info_PVT;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
828:
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: ROLLBACK TO Get_Profile_Info_PVT;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
833:

Line 831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

827: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
828:
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: ROLLBACK TO Get_Profile_Info_PVT;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
833:
834: WHEN OTHERS THEN
835: ROLLBACK TO Get_Profile_Info_PVT;

Line 836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

832: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
833:
834: WHEN OTHERS THEN
835: ROLLBACK TO Get_Profile_Info_PVT;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
838: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
839: END IF;
840: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);