24: g_pkg_name CONSTANT VARCHAR2 (30) := 'Pv_Enrq_Bins_PVT';
25: g_file_name CONSTANT VARCHAR2 (15) := 'pvxvbinb.pls';
26: g_program_mode CONSTANT VARCHAR2 (15) := 'BINS';
27:
28: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
29: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
30: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
31:
32:
25: g_file_name CONSTANT VARCHAR2 (15) := 'pvxvbinb.pls';
26: g_program_mode CONSTANT VARCHAR2 (15) := 'BINS';
27:
28: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
29: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
30: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
31:
32:
33: FUNCTION getInviteHeaderId(p_partner_id in number,p_program_id in NUMBER,p_invite_type_code in VARCHAR2)
26: g_program_mode CONSTANT VARCHAR2 (15) := 'BINS';
27:
28: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
29: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
30: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
31:
32:
33: FUNCTION getInviteHeaderId(p_partner_id in number,p_program_id in NUMBER,p_invite_type_code in VARCHAR2)
34: RETURN NUMBER is
292:
293: -- Initialize message list if p_init_msg_list is set to TRUE.
294: IF FND_API.to_Boolean( p_init_msg_list )
295: THEN
296: FND_MSG_PUB.initialize;
297: END IF;
298:
299: -- Debug Message
300: IF (PV_DEBUG_HIGH_ON) THEN
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
468: );
468: );
469:
470: WHEN OTHERS THEN
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
470: WHEN OTHERS THEN
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,
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
481: );
637:
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list )
640: THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643:
644: -- Debug Message
645: IF (PV_DEBUG_HIGH_ON) THEN
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
754: );
754: );
755:
756: WHEN OTHERS THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
756: WHEN OTHERS THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,
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
767: );
928:
929: -- Initialize message list if p_init_msg_list is set to TRUE.
930: IF FND_API.to_Boolean( p_init_msg_list )
931: THEN
932: FND_MSG_PUB.initialize;
933: END IF;
934:
935: -- Debug Message
936: IF (PV_DEBUG_HIGH_ON) THEN
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
1040: );
1040: );
1041:
1042: WHEN OTHERS THEN
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
1042: WHEN OTHERS THEN
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,
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
1053: );
1144:
1145: -- Initialize message list if p_init_msg_list is set to TRUE.
1146: IF FND_API.to_Boolean( p_init_msg_list )
1147: THEN
1148: FND_MSG_PUB.initialize;
1149: END IF;
1150:
1151: -- Debug Message
1152: IF (PV_DEBUG_HIGH_ON) THEN
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
1205: );
1205: );
1206:
1207: WHEN OTHERS THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
1207: WHEN OTHERS THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,
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
1218: );
1266:
1267: -- Initialize message list if p_init_msg_list is set to TRUE.
1268: IF FND_API.to_Boolean( p_init_msg_list )
1269: THEN
1270: FND_MSG_PUB.initialize;
1271: END IF;
1272:
1273: -- Debug Message
1274: IF (PV_DEBUG_HIGH_ON) THEN
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
1387: );
1387: );
1388:
1389: WHEN OTHERS THEN
1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
1389: WHEN OTHERS THEN
1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,
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
1400: );
1590:
1591: -- Initialize message list if p_init_msg_list is set to TRUE.
1592: IF FND_API.to_Boolean( p_init_msg_list )
1593: THEN
1594: FND_MSG_PUB.initialize;
1595: END IF;
1596:
1597: -- Debug Message
1598: IF (PV_DEBUG_HIGH_ON) THEN
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
1702: );
1702: );
1703: WHEN OTHERS THEN
1704: ROLLBACK TO isPartnerEligible;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
1704: ROLLBACK TO isPartnerEligible;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,
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
1715: );