DBA Data[Home] [Help]

APPS.OZF_QUAL_MARKET_OPTION_PVT dependencies on STANDARD

Line 244: -- Standard Start of API savepoint

240: l_api_version_number CONSTANT NUMBER := 1.0;
241: l_object_version_number NUMBER;
242: l_qual_mo_rec qual_mo_rec_type;
243: BEGIN
244: -- Standard Start of API savepoint
245: SAVEPOINT validate_qual_mkt_options_pvt;
246:
247: -- Standard call to check for call compatibility.
248: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

243: BEGIN
244: -- Standard Start of API savepoint
245: SAVEPOINT validate_qual_mkt_options_pvt;
246:
247: -- Standard call to check for call compatibility.
248: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
249: p_api_version_number,
250: l_api_name,
251: G_PKG_NAME)

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

304: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
305:
306: -- collect message
307:
308: -- Standard call to get message count and if count is 1, get message info.
309: FND_MSG_PUB.Count_And_Get
310: (p_count => x_msg_count,
311: p_data => x_msg_data
312: );

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

320:
321: WHEN FND_API.G_EXC_ERROR THEN
322: ROLLBACK TO validate_qual_mkt_options_pvt;
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: -- Standard call to get message count and if count=1, get the message
325: FND_MSG_PUB.Count_And_Get (
326: p_encoded => FND_API.G_FALSE,
327: p_count => x_msg_count,
328: p_data => x_msg_data

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

330:
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: ROLLBACK TO validate_qual_mkt_options_pvt;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: -- Standard call to get message count and if count=1, get the message
335: FND_MSG_PUB.Count_And_Get (
336: p_encoded => FND_API.G_FALSE,
337: p_count => x_msg_count,
338: p_data => x_msg_data

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

344: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
345: THEN
346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
347: END IF;
348: -- Standard call to get message count and if count=1, get the message
349: FND_MSG_PUB.Count_And_Get (
350: p_encoded => FND_API.G_FALSE,
351: p_count => x_msg_count,
352: p_data => x_msg_data

Line 418: -- Standard Start of API savepoint

414: WHERE qualifier_market_option_id = l_id;
415: l_object_version_number NUMBER;
416: BEGIN
417: --initialize
418: -- Standard Start of API savepoint
419: SAVEPOINT Create_qual_market_options_pvt;
420:
421: -- Standard call to check for call compatibility.
422: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

417: --initialize
418: -- Standard Start of API savepoint
419: SAVEPOINT Create_qual_market_options_pvt;
420:
421: -- Standard call to check for call compatibility.
422: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
423: p_api_version_number,
424: l_api_name,
425: G_PKG_NAME)

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

509: END IF;
510: -- Debug Message
511: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
512: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
513: -- Standard call to get message count and if count is 1, get message info.
514:
515: FND_MSG_PUB.Count_And_Get
516: (p_count => x_msg_count,
517: p_data => x_msg_data

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

521: EXCEPTION
522: WHEN FND_API.G_EXC_ERROR THEN
523: ROLLBACK TO Create_qual_market_options_pvt;
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: -- Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.Count_And_Get (
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data

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

531:
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO Create_qual_market_options_pvt;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: -- Standard call to get message count and if count=1, get the message
536: FND_MSG_PUB.Count_And_Get (
537: p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count,
539: p_data => x_msg_data

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

545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
546: THEN
547: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
548: END IF;
549: -- Standard call to get message count and if count=1, get the message
550: FND_MSG_PUB.Count_And_Get (
551: p_encoded => FND_API.G_FALSE,
552: p_count => x_msg_count,
553: p_data => x_msg_data

Line 588: -- Standard Start of API savepoint

584: l_tar_qual_mo_rec qual_mo_rec_type := p_qual_mo_rec ;
585: l_rowid ROWID;
586: BEGIN
587: --initialize
588: -- Standard Start of API savepoint
589: SAVEPOINT update_qual_market_options_pvt;
590: -- Standard call to check for call compatibility.
591: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
592: p_api_version_number,

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

586: BEGIN
587: --initialize
588: -- Standard Start of API savepoint
589: SAVEPOINT update_qual_market_options_pvt;
590: -- Standard call to check for call compatibility.
591: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
592: p_api_version_number,
593: l_api_name,
594: G_PKG_NAME)

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

668: END IF;
669: -- Debug Message
670: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
671: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
672: -- Standard call to get message count and if count is 1, get message info.
673:
674: FND_MSG_PUB.Count_And_Get
675: (p_count => x_msg_count,
676: p_data => x_msg_data

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

680: EXCEPTION
681: WHEN FND_API.G_EXC_ERROR THEN
682: ROLLBACK TO update_qual_market_options_pvt;
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data

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

690:
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: ROLLBACK TO update_qual_market_options_pvt;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: -- Standard call to get message count and if count=1, get the message
695: FND_MSG_PUB.Count_And_Get (
696: p_encoded => FND_API.G_FALSE,
697: p_count => x_msg_count,
698: p_data => x_msg_data

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

704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
705: THEN
706: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
707: END IF;
708: -- Standard call to get message count and if count=1, get the message
709: FND_MSG_PUB.Count_And_Get (
710: p_encoded => FND_API.G_FALSE,
711: p_count => x_msg_count,
712: p_data => x_msg_data

Line 735: -- Standard Start of API savepoint

731: l_api_version_number CONSTANT NUMBER := 1.0;
732: l_object_version_number NUMBER;
733: BEGIN
734: --initialize
735: -- Standard Start of API savepoint
736: SAVEPOINT Delete_qual_market_options_PVT;
737:
738: -- Standard call to check for call compatibility.
739: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

734: --initialize
735: -- Standard Start of API savepoint
736: SAVEPOINT Delete_qual_market_options_PVT;
737:
738: -- Standard call to check for call compatibility.
739: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
740: p_api_version_number,
741: l_api_name,
742: G_PKG_NAME)

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

763: THEN
764: COMMIT WORK;
765: END IF;
766:
767: -- Standard call to get message count and if count is 1, get message info.
768: FND_MSG_PUB.Count_And_Get
769: (p_count => x_msg_count,
770: p_data => x_msg_data
771: );

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

779:
780: WHEN FND_API.G_EXC_ERROR THEN
781: ROLLBACK TO Delete_qual_market_options_PVT;
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: -- Standard call to get message count and if count=1, get the message
784: FND_MSG_PUB.Count_And_Get (
785: p_encoded => FND_API.G_FALSE,
786: p_count => x_msg_count,
787: p_data => x_msg_data

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

789:
790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
791: ROLLBACK TO Delete_qual_market_options_PVT;
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: -- Standard call to get message count and if count=1, get the message
794: FND_MSG_PUB.Count_And_Get (
795: p_encoded => FND_API.G_FALSE,
796: p_count => x_msg_count,
797: p_data => x_msg_data

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

803: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
804: THEN
805: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
806: END IF;
807: -- Standard call to get message count and if count=1, get the message
808: FND_MSG_PUB.Count_And_Get (
809: p_encoded => FND_API.G_FALSE,
810: p_count => x_msg_count,
811: p_data => x_msg_data