[Home] [Help]
884: 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
885: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
886: 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);
887: END IF;
888: RAISE FND_API.G_EXC_ERROR;
889: END IF;
890: END IF;
891:
892: 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'), sysdate) ) THEN
892: 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'), sysdate) ) THEN
893: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
894: iby_debug_pub.add(debug_msg => 'From Payment Date is greater than To Payment Date', debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
895: END IF;
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
898:
899: IF (trim(p_payment_status) = '' or p_payment_status is null or p_payment_status = 'null') THEN
900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
899: IF (trim(p_payment_status) = '' or p_payment_status is null or p_payment_status = 'null') THEN
900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
901: iby_debug_pub.add(debug_msg => 'Cannot proceed since Payment Status attribute is not supplied', debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
902: END IF;
903: RAISE FND_API.G_EXC_ERROR;
904: END IF;
905:
906: IF (trim(p_reselect) = '' or p_reselect is null or p_reselect = 'null') THEN
907: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
906: IF (trim(p_reselect) = '' or p_reselect is null or p_reselect = 'null') THEN
907: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
908: iby_debug_pub.add(debug_msg => 'Cannot proceed since Reselect attribute is not supplied', debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
909: END IF;
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912:
913: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
914: -- edited parameter disp
1208:
1209: XLE_UTILITIES_GRP.Get_FP_VATRegistration_LEID
1210: (
1211: p_api_version => 1.0,
1212: p_init_msg_list => fnd_api.g_false,
1213: p_commit => fnd_api.g_false,
1214: p_effective_date => SYSDATE,
1215: x_return_status => l_return_status,
1216: x_msg_count => l_msg_count,
1209: XLE_UTILITIES_GRP.Get_FP_VATRegistration_LEID
1210: (
1211: p_api_version => 1.0,
1212: p_init_msg_list => fnd_api.g_false,
1213: p_commit => fnd_api.g_false,
1214: p_effective_date => SYSDATE,
1215: x_return_status => l_return_status,
1216: x_msg_count => l_msg_count,
1217: x_msg_data => l_msg_data,
1252: -- registration number
1253: XLE_THIRDPARTY.Get_LegalInformation
1254: (
1255: p_api_version => 1.0,
1256: p_init_msg_list => fnd_api.g_false,
1257: p_commit => fnd_api.g_false,
1258: x_return_status => l_return_status,
1259: x_msg_count => l_msg_count,
1260: x_msg_data => l_msg_data,
1253: XLE_THIRDPARTY.Get_LegalInformation
1254: (
1255: p_api_version => 1.0,
1256: p_init_msg_list => fnd_api.g_false,
1257: p_commit => fnd_api.g_false,
1258: x_return_status => l_return_status,
1259: x_msg_count => l_msg_count,
1260: x_msg_data => l_msg_data,
1261: p_business_entity_type => 'SUPPLIER',
1325: -- Standard Start of API savepoint
1326: SAVEPOINT Get_LegalInformation;
1327:
1328: -- Standard call to check for call compatibility.
1329: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1330: p_api_version,
1331: l_api_name,
1332: G_PKG_NAME ) THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1329: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1330: p_api_version,
1331: l_api_name,
1332: G_PKG_NAME ) THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335:
1336: -- Initialize message list if p_init_msg_list is set to TRUE.
1337: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335:
1336: -- Initialize message list if p_init_msg_list is set to TRUE.
1337: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1338: FND_MSG_PUB.initialize;
1339: END IF;
1340:
1341: -- Initialize API return status to success
1338: FND_MSG_PUB.initialize;
1339: END IF;
1340:
1341: -- Initialize API return status to success
1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343:
1344: -- ======== START OF API BODY ============
1345:
1346: -- ***** Business entity type is SUPPLIER *****
1368: IF case1_legal_information_cur%NOTFOUND THEN
1369: --specific xle message under creation fnd message used as workaround
1370: FND_MESSAGE.SET_NAME('FND','FND_GRANTS_RECORD_NOT_FOUND');
1371: FND_MSG_PUB.Add;
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: END IF;
1374:
1375:
1376: CLOSE case1_legal_information_cur;
1398: IF case2_legal_information_cur%NOTFOUND THEN
1399: --specific xle message under creation fnd message used as workaround
1400: FND_MESSAGE.SET_NAME('FND','FND_GRANTS_RECORD_NOT_FOUND');
1401: FND_MSG_PUB.Add;
1402: x_return_status := FND_API.G_RET_STS_ERROR;
1403: END IF;
1404:
1405:
1406: CLOSE case2_legal_information_cur;
1505: /* -- XLE descoped third party APIs
1506: XLE_THIRDPARTY.Get_TP_VATRegistration_PTY
1507: (
1508: p_api_version => 1.0,
1509: p_init_msg_list => fnd_api.g_false,
1510: p_commit => fnd_api.g_false,
1511: p_effective_date => SYSDATE,
1512: x_return_status => l_return_status,
1513: x_msg_count => l_msg_count,
1506: XLE_THIRDPARTY.Get_TP_VATRegistration_PTY
1507: (
1508: p_api_version => 1.0,
1509: p_init_msg_list => fnd_api.g_false,
1510: p_commit => fnd_api.g_false,
1511: p_effective_date => SYSDATE,
1512: x_return_status => l_return_status,
1513: x_msg_count => l_msg_count,
1514: x_msg_data => l_msg_data,