DBA Data[Home] [Help]

APPS.PV_ENRQ_BINS_PVT dependencies on FND_MSG_PUB

Line 28: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

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:

Line 29: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

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)

Line 30: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

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

Line 296: FND_MSG_PUB.initialize;

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

Line 464: FND_MSG_PUB.Count_And_Get (

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: );

Line 472: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 474: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 477: FND_MSG_PUB.Count_And_Get (

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: );

Line 641: FND_MSG_PUB.initialize;

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

Line 750: FND_MSG_PUB.Count_And_Get (

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: );

Line 758: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 760: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 763: FND_MSG_PUB.Count_And_Get (

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: );

Line 932: FND_MSG_PUB.initialize;

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

Line 1036: FND_MSG_PUB.Count_And_Get (

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: );

Line 1044: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1046: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 1049: FND_MSG_PUB.Count_And_Get (

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: );

Line 1148: FND_MSG_PUB.initialize;

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

Line 1201: FND_MSG_PUB.Count_And_Get (

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: );

Line 1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 1214: FND_MSG_PUB.Count_And_Get (

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: );

Line 1270: FND_MSG_PUB.initialize;

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

Line 1383: FND_MSG_PUB.Count_And_Get (

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: );

Line 1391: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 1396: FND_MSG_PUB.Count_And_Get (

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: );

Line 1594: FND_MSG_PUB.initialize;

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

Line 1689: FND_MSG_PUB.Count_And_Get (

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: );

Line 1698: FND_MSG_PUB.Count_And_Get (

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: );

Line 1706: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 1711: FND_MSG_PUB.Count_And_Get (

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: );