DBA Data[Home] [Help]

APPS.PV_PRGM_BENEFITS_PVT dependencies on STANDARD

Line 70: -- Standard Start of API savepoint

66: WHERE PROGRAM_BENEFITS_ID = l_id;
67:
68: BEGIN
69: ---------------Initialize --------------------
70: -- Standard Start of API savepoint
71: SAVEPOINT CREATE_Prgm_Benefits_PVT;
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list )

Line 79: -- Standard call to check for call compatibility.

75: THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Standard call to check for call compatibility.
80: IF NOT FND_API.Compatible_API_Call (
81: l_api_version_number
82: ,p_api_version_number
83: ,l_api_name

Line 227: -- Standard check for p_commit

223:
224: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
225: END IF;
226:
227: -- Standard check for p_commit
228: IF FND_API.to_Boolean( p_commit ) THEN
229: COMMIT WORK;
230: END IF;
231:

Line 237: -- Standard call to get message count and if count=1, get the message

233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: ROLLBACK TO CREATE_PRGM_BENEFITS_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: -- Standard call to get message count and if count=1, get the message
238: FND_MSG_PUB.Count_And_Get (
239: p_encoded => FND_API.G_FALSE
240: ,p_count => x_msg_count
241: ,p_data => x_msg_data

Line 247: -- Standard call to get message count and if count=1, get the message

243:
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK TO CREATE_PRGM_BENEFITS_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (
249: p_encoded => FND_API.G_FALSE
250: ,p_count => x_msg_count
251: ,p_data => x_msg_data

Line 262: -- Standard call to get message count and if count=1, get the message

258: THEN
259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
260: END IF;
261:
262: -- Standard call to get message count and if count=1, get the message
263: FND_MSG_PUB.Count_And_Get (
264: p_encoded => FND_API.G_FALSE
265: ,p_count => x_msg_count
266: ,p_data => x_msg_data

Line 304: -- Standard Start of API savepoint

300:
301: BEGIN
302: ---------Initialize ------------------
303:
304: -- Standard Start of API savepoint
305: SAVEPOINT UPDATE_Prgm_Benefits_PVT;
306:
307: -- Standard call to check for call compatibility.
308: IF NOT FND_API.Compatible_API_Call (l_api_version_number

Line 307: -- Standard call to check for call compatibility.

303:
304: -- Standard Start of API savepoint
305: SAVEPOINT UPDATE_Prgm_Benefits_PVT;
306:
307: -- Standard call to check for call compatibility.
308: IF NOT FND_API.Compatible_API_Call (l_api_version_number
309: ,p_api_version_number
310: ,l_api_name
311: ,G_PKG_NAME

Line 435: -- Standard call to get message count and if count=1, get the message

431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: ROLLBACK TO UPDATE_Prgm_Benefits_PVT;
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: -- Standard call to get message count and if count=1, get the message
436: FND_MSG_PUB.Count_And_Get (
437: p_encoded => FND_API.G_FALSE
438: ,p_count => x_msg_count
439: ,p_data => x_msg_data

Line 445: -- Standard call to get message count and if count=1, get the message

441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: ROLLBACK TO UPDATE_Prgm_Benefits_PVT;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: -- Standard call to get message count and if count=1, get the message
446: FND_MSG_PUB.Count_And_Get (
447: p_encoded => FND_API.G_FALSE,
448: p_count => x_msg_count,
449: p_data => x_msg_data

Line 459: -- Standard call to get message count and if count=1, get the message

455: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
456: THEN
457: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
458: END IF;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (
461: p_encoded => FND_API.G_FALSE
462: ,p_count => x_msg_count
463: ,p_data => x_msg_data

Line 493: -- Standard Start of API savepoint

489: BEGIN
490:
491: ---- Initialize----------------
492:
493: -- Standard Start of API savepoint
494: SAVEPOINT DELETE_Prgm_Benefits_PVT;
495:
496: -- Debug Message
497: IF (PV_DEBUG_HIGH_ON) THEN

Line 502: -- Standard call to check for call compatibility.

498:
499: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
500: END IF;
501:
502: -- Standard call to check for call compatibility.
503: IF NOT FND_API.Compatible_API_Call (l_api_version_number
504: ,p_api_version_number
505: ,l_api_name
506: ,G_PKG_NAME

Line 554: -- Standard call to get message count and if count=1, get the message

550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN
552: ROLLBACK TO DELETE_Prgm_Benefits_PVT;
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: -- Standard call to get message count and if count=1, get the message
555: FND_MSG_PUB.Count_And_Get (
556: p_encoded => FND_API.G_FALSE
557: ,p_count => x_msg_count
558: ,p_data => x_msg_data

Line 564: -- Standard call to get message count and if count=1, get the message

560:
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: ROLLBACK TO DELETE_Prgm_Benefits_PVT;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (
566: p_encoded => FND_API.G_FALSE
567: ,p_count => x_msg_count
568: ,p_data => x_msg_data

Line 578: -- Standard call to get message count and if count=1, get the message

574: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
575: THEN
576: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
577: END IF;
578: -- Standard call to get message count and if count=1, get the message
579: FND_MSG_PUB.Count_And_Get (
580: p_encoded => FND_API.G_FALSE
581: ,p_count => x_msg_count
582: ,p_data => x_msg_data

Line 629: -- Standard call to check for call compatibility.

625: THEN
626: FND_MSG_PUB.initialize;
627: END IF;
628:
629: -- Standard call to check for call compatibility.
630: IF NOT FND_API.Compatible_API_Call (
631: l_api_version_number
632: ,p_api_version_number
633: ,l_api_name

Line 691: -- Standard call to get message count and if count=1, get the message

687: */
688: WHEN FND_API.G_EXC_ERROR THEN
689: ROLLBACK TO LOCK_Prgm_Benefits_PVT;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: -- Standard call to get message count and if count=1, get the message
692: FND_MSG_PUB.Count_And_Get (
693: p_encoded => FND_API.G_FALSE
694: ,p_count => x_msg_count
695: ,p_data => x_msg_data

Line 701: -- Standard call to get message count and if count=1, get the message

697:
698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
699: ROLLBACK TO LOCK_Prgm_Benefits_PVT;
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: -- Standard call to get message count and if count=1, get the message
702: FND_MSG_PUB.Count_And_Get (
703: p_encoded => FND_API.G_FALSE
704: ,p_count => x_msg_count
705: ,p_data => x_msg_data

Line 715: -- Standard call to get message count and if count=1, get the message

711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
712: THEN
713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
714: END IF;
715: -- Standard call to get message count and if count=1, get the message
716: FND_MSG_PUB.Count_And_Get (
717: p_encoded => FND_API.G_FALSE
718: ,p_count => x_msg_count
719: ,p_data => x_msg_data

Line 1279: -- Standard Start of API savepoint

1275: l_prgm_benefits_rec PV_PRGM_BENEFITS_PVT.prgm_benefits_rec_type;
1276:
1277: BEGIN
1278:
1279: -- Standard Start of API savepoint
1280: SAVEPOINT Validate_Prgm_Benefits_;
1281:
1282: -- Initialize API return status to SUCCESS
1283: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1285: -- Standard call to check for call compatibility.

1281:
1282: -- Initialize API return status to SUCCESS
1283: x_return_status := FND_API.G_RET_STS_SUCCESS;
1284:
1285: -- Standard call to check for call compatibility.
1286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1287: p_api_version_number,
1288: l_api_name,
1289: G_PKG_NAME)

Line 1355: -- Standard call to get message count and if count is 1, get message info.

1351:
1352: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');
1353: END IF;
1354:
1355: -- Standard call to get message count and if count is 1, get message info.
1356: FND_MSG_PUB.Count_And_Get
1357: ( p_encoded => FND_API.G_FALSE,
1358: p_count => x_msg_count,
1359: p_data => x_msg_data

Line 1366: -- Standard call to get message count and if count=1, get the message

1362: EXCEPTION
1363: WHEN FND_API.G_EXC_ERROR THEN
1364: ROLLBACK TO Validate_Prgm_Benefits_;
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366: -- Standard call to get message count and if count=1, get the message
1367: FND_MSG_PUB.Count_And_Get (
1368: p_encoded => FND_API.G_FALSE
1369: ,p_count => x_msg_count
1370: ,p_data => x_msg_data

Line 1376: -- Standard call to get message count and if count=1, get the message

1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: ROLLBACK TO Validate_Prgm_Benefits_;
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376: -- Standard call to get message count and if count=1, get the message
1377: FND_MSG_PUB.Count_And_Get (
1378: p_encoded => FND_API.G_FALSE
1379: ,p_count => x_msg_count
1380: ,p_data => x_msg_data

Line 1390: -- Standard call to get message count and if count=1, get the message

1386: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1387: THEN
1388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1389: END IF;
1390: -- Standard call to get message count and if count=1, get the message
1391: FND_MSG_PUB.Count_And_Get (
1392: p_encoded => FND_API.G_FALSE
1393: ,p_count => x_msg_count
1394: ,p_data => x_msg_data

Line 1428: -- Standard call to get message count and if count is 1, get message info.

1424: -- If data not valid
1425: -- THEN
1426: -- x_return_status := FND_API.G_RET_STS_ERROR;
1427:
1428: -- Standard call to get message count and if count is 1, get message info.
1429: FND_MSG_PUB.Count_And_Get
1430: (p_count => x_msg_count,
1431: p_data => x_msg_data
1432: );