[Home] [Help]
278: l_query_str1 VARCHAR2(1200);
279:
280: l_cache VARCHAR2(1);
281: BEGIN
282: --Standard call to check for call compatibility.
283: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
284: ,p_api_version_number
285: ,l_api_name
286: ,G_PKG_NAME
459:
460: EXCEPTION
461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: -- Standard call to get message count and if count=1, get the message
464: FND_MSG_PUB.Count_And_Get (
465: p_encoded => FND_API.G_FALSE,
466: p_count => x_msg_count,
467: p_data => x_msg_data
472: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
475: END IF;
476: -- Standard call to get message count and if count=1, get the message
477: FND_MSG_PUB.Count_And_Get (
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data
623: l_cache VARCHAR2(1);
624:
625: BEGIN
626:
627: --Standard call to check for call compatibility.
628: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
629: ,p_api_version_number
630: ,l_api_name
631: ,G_PKG_NAME
745:
746: EXCEPTION
747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749: -- Standard call to get message count and if count=1, get the message
750: FND_MSG_PUB.Count_And_Get (
751: p_encoded => FND_API.G_FALSE,
752: p_count => x_msg_count,
753: p_data => x_msg_data
758: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
759: THEN
760: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
761: END IF;
762: -- Standard call to get message count and if count=1, get the message
763: FND_MSG_PUB.Count_And_Get (
764: p_encoded => FND_API.G_FALSE,
765: p_count => x_msg_count,
766: p_data => x_msg_data
914: l_cache VARCHAR2(1);
915:
916: BEGIN
917:
918: --Standard call to check for call compatibility.
919: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
920: ,p_api_version_number
921: ,l_api_name
922: ,G_PKG_NAME
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: -- Standard call to get message count and if count=1, get the message
1036: FND_MSG_PUB.Count_And_Get (
1037: p_encoded => FND_API.G_FALSE,
1038: p_count => x_msg_count,
1039: p_data => x_msg_data
1044: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1045: THEN
1046: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1047: END IF;
1048: -- Standard call to get message count and if count=1, get the message
1049: FND_MSG_PUB.Count_And_Get (
1050: p_encoded => FND_API.G_FALSE,
1051: p_count => x_msg_count,
1052: p_data => x_msg_data
1130: l_cache VARCHAR2(1);
1131:
1132: BEGIN
1133:
1134: --Standard call to check for call compatibility.
1135: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
1136: ,p_api_version_number
1137: ,l_api_name
1138: ,G_PKG_NAME
1196:
1197: EXCEPTION
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1200: -- Standard call to get message count and if count=1, get the message
1201: FND_MSG_PUB.Count_And_Get (
1202: p_encoded => FND_API.G_FALSE,
1203: p_count => x_msg_count,
1204: p_data => x_msg_data
1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1210: THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1212: END IF;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1252: l_no_fee VARCHAR2(1);
1253: l_vad_invite VARCHAR2(1);
1254: counter NUMBER:=1;
1255: BEGIN
1256: --Standard call to check for call compatibility.
1257: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
1258: ,p_api_version_number
1259: ,l_api_name
1260: ,G_PKG_NAME
1378:
1379: EXCEPTION
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: -- Standard call to get message count and if count=1, get the message
1383: FND_MSG_PUB.Count_And_Get (
1384: p_encoded => FND_API.G_FALSE,
1385: p_count => x_msg_count,
1386: p_data => x_msg_data
1391: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1392: THEN
1393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1394: END IF;
1395: -- Standard call to get message count and if count=1, get the message
1396: FND_MSG_PUB.Count_And_Get (
1397: p_encoded => FND_API.G_FALSE,
1398: p_count => x_msg_count,
1399: p_data => x_msg_data
1576: l_cache VARCHAR2(1):=null;
1577:
1578: BEGIN
1579: SAVEPOINT isPartnerEligible;
1580: --Standard call to check for call compatibility.
1581: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
1582: ,p_api_version_number
1583: ,l_api_name
1584: ,G_PKG_NAME
1684: EXCEPTION
1685: WHEN FND_API.G_EXC_ERROR THEN
1686: ROLLBACK TO isPartnerEligible;
1687: x_return_status := FND_API.G_RET_STS_ERROR;
1688: -- Standard call to get message count and if count=1, get the message
1689: FND_MSG_PUB.Count_And_Get (
1690: p_encoded => FND_API.G_FALSE,
1691: p_count => x_msg_count,
1692: p_data => x_msg_data
1693: );
1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1695: ROLLBACK TO isPartnerEligible;
1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1697: -- Standard call to get message count and if count=1, get the message
1698: FND_MSG_PUB.Count_And_Get (
1699: p_encoded => FND_API.G_FALSE,
1700: p_count => x_msg_count,
1701: p_data => x_msg_data
1706: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1707: THEN
1708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1709: END IF;
1710: -- Standard call to get message count and if count=1, get the message
1711: FND_MSG_PUB.Count_And_Get (
1712: p_encoded => FND_API.G_FALSE,
1713: p_count => x_msg_count,
1714: p_data => x_msg_data