DBA Data[Home] [Help]

APPS.IEX_PROFILE dependencies on FND_API

Line 637: IF NOT FND_API.Compatible_API_Call (l_api_version,

633:
634: SAVEPOINT Get_Profile_Info_PVT;
635:
636: -- Standard call to check for call compatibility.
637: IF NOT FND_API.Compatible_API_Call (l_api_version,
638: p_api_version,
639: l_api_name,
640: G_PKG_NAME) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

637: IF NOT FND_API.Compatible_API_Call (l_api_version,
638: p_api_version,
639: l_api_name,
640: G_PKG_NAME) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643:
644: -- Check p_init_msg_list
645: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 645: IF FND_API.to_Boolean( p_init_msg_list ) THEN

641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643:
644: -- Check p_init_msg_list
645: IF FND_API.to_Boolean( p_init_msg_list ) THEN
646: FND_MSG_PUB.initialize;
647: END IF;
648:
649: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 649: x_return_status := FND_API.G_RET_STS_SUCCESS;

645: IF FND_API.to_Boolean( p_init_msg_list ) THEN
646: FND_MSG_PUB.initialize;
647: END IF;
648:
649: x_return_status := FND_API.G_RET_STS_SUCCESS;
650: --Bug4562698. Moved the Constructor to GET_PROFILE_INFO. Begin.
651: Begin
652: SELECT distinct sob.currency_code
653: INTO g_curr_rec.base_currency

Line 770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

766: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
767: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CUSTOMER_PROFILE_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
768: END IF;
769: ROLLBACK TO Get_Profile_Info_PVT;
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
772: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
773: END IF;
774: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

894: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
895: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CUSTOMER_PROFILE_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
896: END IF;
897: ROLLBACK TO Get_Profile_Info_PVT;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
900: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
901: END IF;
902: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

992: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CREDIT - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
993:
994: END IF;
995: ROLLBACK TO Get_Profile_Info_PVT;
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
998: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
999: END IF;
1000: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1006: IF FND_API.To_Boolean(p_commit) THEN

1002:
1003: x_profile_rec := l_profile_rec ;
1004:
1005: -- Standard check of p_commit
1006: IF FND_API.To_Boolean(p_commit) THEN
1007: COMMIT WORK;
1008: END IF;
1009:
1010: -- Standard call to get message count AND IF count is 1, get message info

Line 1013: WHEN FND_API.G_EXC_ERROR THEN

1009:
1010: -- Standard call to get message count AND IF count is 1, get message info
1011: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1012: EXCEPTION
1013: WHEN FND_API.G_EXC_ERROR THEN
1014: ROLLBACK TO Get_Profile_Info_PVT;
1015: x_return_status := FND_API.G_RET_STS_ERROR;
1016: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1017:

Line 1015: x_return_status := FND_API.G_RET_STS_ERROR;

1011: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1012: EXCEPTION
1013: WHEN FND_API.G_EXC_ERROR THEN
1014: ROLLBACK TO Get_Profile_Info_PVT;
1015: x_return_status := FND_API.G_RET_STS_ERROR;
1016: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019: ROLLBACK TO Get_Profile_Info_PVT;

Line 1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1014: ROLLBACK TO Get_Profile_Info_PVT;
1015: x_return_status := FND_API.G_RET_STS_ERROR;
1016: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019: ROLLBACK TO Get_Profile_Info_PVT;
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1022:

Line 1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1016: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019: ROLLBACK TO Get_Profile_Info_PVT;
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1022:
1023: WHEN OTHERS THEN
1024: ROLLBACK TO Get_Profile_Info_PVT;

Line 1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1021: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1022:
1023: WHEN OTHERS THEN
1024: ROLLBACK TO Get_Profile_Info_PVT;
1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1026: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1027: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1028: END IF;
1029: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);