DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on FND_API

Line 1162: RAISE FND_API.G_EXC_ERROR;

1158: IF ((trim(p_format_name) = '' or p_format_name is null or p_format_name = 'null') OR (trim(p_internal_bank_account_name) = '' or p_internal_bank_account_name is null or p_internal_bank_account_name = 'null')) THEN
1159: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1160: iby_debug_pub.add(debug_msg => 'Enter the conditional mandatory fields Format Name and Internal Bank Account ID or Payment Instruction ', debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
1161: END IF;
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164: END IF;
1165:
1166: IF (nvl(to_date(l_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate) < nvl(to_date(l_from_date, 'YYYY/MM/DD HH24:MI:SS'), nvl(to_date(l_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)) ) THEN

Line 1170: RAISE FND_API.G_EXC_ERROR;

1166: IF (nvl(to_date(l_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate) < nvl(to_date(l_from_date, 'YYYY/MM/DD HH24:MI:SS'), nvl(to_date(l_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)) ) THEN
1167: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1168: iby_debug_pub.add(debug_msg => 'From Payment Date is greater than To Payment Date', debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
1169: END IF;
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;
1172:
1173: IF (trim(p_payment_status) = '' or p_payment_status is null or p_payment_status = 'null') THEN
1174: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1177: RAISE FND_API.G_EXC_ERROR;

1173: IF (trim(p_payment_status) = '' or p_payment_status is null or p_payment_status = 'null') THEN
1174: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1175: iby_debug_pub.add(debug_msg => 'Cannot proceed since Payment Status attribute is not supplied', debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
1176: END IF;
1177: RAISE FND_API.G_EXC_ERROR;
1178: END IF;
1179:
1180: IF (trim(p_reselect) = '' or p_reselect is null or p_reselect = 'null') THEN
1181: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1184: RAISE FND_API.G_EXC_ERROR;

1180: IF (trim(p_reselect) = '' or p_reselect is null or p_reselect = 'null') THEN
1181: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1182: iby_debug_pub.add(debug_msg => 'Cannot proceed since Reselect attribute is not supplied', debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
1183: END IF;
1184: RAISE FND_API.G_EXC_ERROR;
1185: END IF;
1186:
1187: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1188: -- edited parameter disp

Line 1617: p_init_msg_list => fnd_api.g_false,

1613:
1614: XLE_UTILITIES_GRP.Get_FP_VATRegistration_LEID
1615: (
1616: p_api_version => 1.0,
1617: p_init_msg_list => fnd_api.g_false,
1618: p_commit => fnd_api.g_false,
1619: p_effective_date => SYSDATE,
1620: x_return_status => l_return_status,
1621: x_msg_count => l_msg_count,

Line 1618: p_commit => fnd_api.g_false,

1614: XLE_UTILITIES_GRP.Get_FP_VATRegistration_LEID
1615: (
1616: p_api_version => 1.0,
1617: p_init_msg_list => fnd_api.g_false,
1618: p_commit => fnd_api.g_false,
1619: p_effective_date => SYSDATE,
1620: x_return_status => l_return_status,
1621: x_msg_count => l_msg_count,
1622: x_msg_data => l_msg_data,

Line 1692: p_init_msg_list => fnd_api.g_false,

1688: -- registration number
1689: XLE_THIRDPARTY.Get_LegalInformation
1690: (
1691: p_api_version => 1.0,
1692: p_init_msg_list => fnd_api.g_false,
1693: p_commit => fnd_api.g_false,
1694: x_return_status => l_return_status,
1695: x_msg_count => l_msg_count,
1696: x_msg_data => l_msg_data,

Line 1693: p_commit => fnd_api.g_false,

1689: XLE_THIRDPARTY.Get_LegalInformation
1690: (
1691: p_api_version => 1.0,
1692: p_init_msg_list => fnd_api.g_false,
1693: p_commit => fnd_api.g_false,
1694: x_return_status => l_return_status,
1695: x_msg_count => l_msg_count,
1696: x_msg_data => l_msg_data,
1697: p_business_entity_type => 'SUPPLIER',

Line 1765: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1761: -- Standard Start of API savepoint
1762: SAVEPOINT Get_LegalInformation;
1763:
1764: -- Standard call to check for call compatibility.
1765: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1766: p_api_version,
1767: l_api_name,
1768: G_PKG_NAME ) THEN
1769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1765: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1766: p_api_version,
1767: l_api_name,
1768: G_PKG_NAME ) THEN
1769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1770: END IF;
1771:
1772: -- Initialize message list if p_init_msg_list is set to TRUE.
1773: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1773: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1770: END IF;
1771:
1772: -- Initialize message list if p_init_msg_list is set to TRUE.
1773: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1774: FND_MSG_PUB.initialize;
1775: END IF;
1776:
1777: -- Initialize API return status to success

Line 1778: x_return_status := FND_API.G_RET_STS_SUCCESS;

1774: FND_MSG_PUB.initialize;
1775: END IF;
1776:
1777: -- Initialize API return status to success
1778: x_return_status := FND_API.G_RET_STS_SUCCESS;
1779:
1780: -- ======== START OF API BODY ============
1781:
1782: -- ***** Business entity type is SUPPLIER *****

Line 1808: x_return_status := FND_API.G_RET_STS_ERROR;

1804: IF case1_legal_information_cur%NOTFOUND THEN
1805: --specific xle message under creation fnd message used as workaround
1806: FND_MESSAGE.SET_NAME('FND','FND_GRANTS_RECORD_NOT_FOUND');
1807: FND_MSG_PUB.Add;
1808: x_return_status := FND_API.G_RET_STS_ERROR;
1809: END IF;
1810:
1811:
1812: CLOSE case1_legal_information_cur;

Line 1838: x_return_status := FND_API.G_RET_STS_ERROR;

1834: IF case2_legal_information_cur%NOTFOUND THEN
1835: --specific xle message under creation fnd message used as workaround
1836: FND_MESSAGE.SET_NAME('FND','FND_GRANTS_RECORD_NOT_FOUND');
1837: FND_MSG_PUB.Add;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: END IF;
1840:
1841:
1842: CLOSE case2_legal_information_cur;

Line 2020: p_init_msg_list => fnd_api.g_false,

2016: /* -- XLE descoped third party APIs
2017: XLE_THIRDPARTY.Get_TP_VATRegistration_PTY
2018: (
2019: p_api_version => 1.0,
2020: p_init_msg_list => fnd_api.g_false,
2021: p_commit => fnd_api.g_false,
2022: p_effective_date => SYSDATE,
2023: x_return_status => l_return_status,
2024: x_msg_count => l_msg_count,

Line 2021: p_commit => fnd_api.g_false,

2017: XLE_THIRDPARTY.Get_TP_VATRegistration_PTY
2018: (
2019: p_api_version => 1.0,
2020: p_init_msg_list => fnd_api.g_false,
2021: p_commit => fnd_api.g_false,
2022: p_effective_date => SYSDATE,
2023: x_return_status => l_return_status,
2024: x_msg_count => l_msg_count,
2025: x_msg_data => l_msg_data,