118:
119: -- Initialize message list if p_init_msg_list is set to TRUE.
120: IF FND_API.to_Boolean( p_init_msg_list )
121: THEN
122: FND_MSG_PUB.initialize;
123: END IF;
124:
125:
126:
247: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
248:
249:
250: -- Standard call to get message count and if count is 1, get message info.
251: FND_MSG_PUB.Count_And_Get
252: (p_count => x_msg_count,
253: p_data => x_msg_data
254: );
255: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN
262: ROLLBACK TO CREATE_Offr_Qual_PVT;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: -- Standard call to get message count and if count=1, get the message
265: FND_MSG_PUB.Count_And_Get (
266: p_encoded => FND_API.G_FALSE,
267: p_count => x_msg_count,
268: p_data => x_msg_data
269: );
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO CREATE_Offr_Qual_PVT;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: -- Standard call to get message count and if count=1, get the message
275: FND_MSG_PUB.Count_And_Get (
276: p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data
279: );
280:
281: WHEN OTHERS THEN
282: ROLLBACK TO CREATE_Offr_Qual_PVT;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285: THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: -- Standard call to get message count and if count=1, get the message
282: ROLLBACK TO CREATE_Offr_Qual_PVT;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285: THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
285: THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );
375:
376: -- Initialize message list if p_init_msg_list is set to TRUE.
377: IF FND_API.to_Boolean( p_init_msg_list )
378: THEN
379: FND_MSG_PUB.initialize;
380: END IF;
381:
382:
383:
495: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
496:
497:
498: -- Standard call to get message count and if count is 1, get message info.
499: FND_MSG_PUB.Count_And_Get
500: (p_count => x_msg_count,
501: p_data => x_msg_data
502: );
503: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO UPDATE_Offr_Qual_PVT;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data
517: );
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: ROLLBACK TO UPDATE_Offr_Qual_PVT;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: -- Standard call to get message count and if count=1, get the message
523: FND_MSG_PUB.Count_And_Get (
524: p_encoded => FND_API.G_FALSE,
525: p_count => x_msg_count,
526: p_data => x_msg_data
527: );
528:
529: WHEN OTHERS THEN
530: ROLLBACK TO UPDATE_Offr_Qual_PVT;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
533: THEN
534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
535: END IF;
536: -- Standard call to get message count and if count=1, get the message
530: ROLLBACK TO UPDATE_Offr_Qual_PVT;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
533: THEN
534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
535: END IF;
536: -- Standard call to get message count and if count=1, get the message
537: FND_MSG_PUB.Count_And_Get (
538: p_encoded => FND_API.G_FALSE,
533: THEN
534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
535: END IF;
536: -- Standard call to get message count and if count=1, get the message
537: FND_MSG_PUB.Count_And_Get (
538: p_encoded => FND_API.G_FALSE,
539: p_count => x_msg_count,
540: p_data => x_msg_data
541: );
609:
610: -- Initialize message list if p_init_msg_list is set to TRUE.
611: IF FND_API.to_Boolean( p_init_msg_list )
612: THEN
613: FND_MSG_PUB.initialize;
614: END IF;
615:
616:
617:
648: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
649:
650:
651: -- Standard call to get message count and if count is 1, get message info.
652: FND_MSG_PUB.Count_And_Get
653: (p_count => x_msg_count,
654: p_data => x_msg_data
655: );
656: EXCEPTION
662: WHEN FND_API.G_EXC_ERROR THEN
663: ROLLBACK TO DELETE_Offr_Qual_PVT;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: -- Standard call to get message count and if count=1, get the message
666: FND_MSG_PUB.Count_And_Get (
667: p_encoded => FND_API.G_FALSE,
668: p_count => x_msg_count,
669: p_data => x_msg_data
670: );
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: ROLLBACK TO DELETE_Offr_Qual_PVT;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681:
682: WHEN OTHERS THEN
683: ROLLBACK TO DELETE_Offr_Qual_PVT;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: THEN
687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
688: END IF;
689: -- Standard call to get message count and if count=1, get the message
683: ROLLBACK TO DELETE_Offr_Qual_PVT;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: THEN
687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
688: END IF;
689: -- Standard call to get message count and if count=1, get the message
690: FND_MSG_PUB.Count_And_Get (
691: p_encoded => FND_API.G_FALSE,
686: THEN
687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
688: END IF;
689: -- Standard call to get message count and if count=1, get the message
690: FND_MSG_PUB.Count_And_Get (
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_msg_count,
693: p_data => x_msg_data
694: );
756:
757: -- Initialize message list if p_init_msg_list is set to TRUE.
758: IF FND_API.to_Boolean( p_init_msg_list )
759: THEN
760: FND_MSG_PUB.initialize;
761: END IF;
762:
763:
764:
781: Ozf_Offr_Qual_Pkg.Lock_Row(l_qualifier_id,p_object_version);
782:
783:
784: -------------------- finish --------------------------
785: FND_MSG_PUB.count_and_get(
786: p_encoded => FND_API.g_false,
787: p_count => x_msg_count,
788: p_data => x_msg_data);
789: OZF_Utility_PVT.debug_message(l_full_name ||': end');
796: WHEN FND_API.G_EXC_ERROR THEN
797: ROLLBACK TO LOCK_Offr_Qual_PVT;
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: -- Standard call to get message count and if count=1, get the message
800: FND_MSG_PUB.Count_And_Get (
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_msg_count,
803: p_data => x_msg_data
804: );
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: ROLLBACK TO LOCK_Offr_Qual_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: -- Standard call to get message count and if count=1, get the message
810: FND_MSG_PUB.Count_And_Get (
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => x_msg_data
814: );
815:
816: WHEN OTHERS THEN
817: ROLLBACK TO LOCK_Offr_Qual_PVT;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
820: THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
822: END IF;
823: -- Standard call to get message count and if count=1, get the message
817: ROLLBACK TO LOCK_Offr_Qual_PVT;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
820: THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
822: END IF;
823: -- Standard call to get message count and if count=1, get the message
824: FND_MSG_PUB.Count_And_Get (
825: p_encoded => FND_API.G_FALSE,
820: THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
822: END IF;
823: -- Standard call to get message count and if count=1, get the message
824: FND_MSG_PUB.Count_And_Get (
825: p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,
827: p_data => x_msg_data
828: );
1265:
1266: -- Initialize message list if p_init_msg_list is set to TRUE.
1267: IF FND_API.to_Boolean( p_init_msg_list )
1268: THEN
1269: FND_MSG_PUB.initialize;
1270: END IF;
1271: l_ozf_offr_qual_rec := p_ozf_offr_qual_rec ;
1272:
1273:
1311: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1312:
1313:
1314: -- Standard call to get message count and if count is 1, get message info.
1315: FND_MSG_PUB.Count_And_Get
1316: (p_count => x_msg_count,
1317: p_data => x_msg_data
1318: );
1319: EXCEPTION
1325: WHEN FND_API.G_EXC_ERROR THEN
1326: ROLLBACK TO validate_offr_qual_Pvt;
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: -- Standard call to get message count and if count=1, get the message
1329: FND_MSG_PUB.Count_And_Get (
1330: p_encoded => FND_API.G_FALSE,
1331: p_count => x_msg_count,
1332: p_data => x_msg_data
1333: );
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: ROLLBACK TO validate_offr_qual_Pvt;
1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1338: -- Standard call to get message count and if count=1, get the message
1339: FND_MSG_PUB.Count_And_Get (
1340: p_encoded => FND_API.G_FALSE,
1341: p_count => x_msg_count,
1342: p_data => x_msg_data
1343: );
1344:
1345: WHEN OTHERS THEN
1346: ROLLBACK TO validate_offr_qual_Pvt;
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1346: ROLLBACK TO validate_offr_qual_Pvt;
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,
1355: p_count => x_msg_count,
1356: p_data => x_msg_data
1357: );
1370: BEGIN
1371: -- Initialize message list if p_init_msg_list is set to TRUE.
1372: IF FND_API.to_Boolean( p_init_msg_list )
1373: THEN
1374: FND_MSG_PUB.initialize;
1375: END IF;
1376:
1377:
1378:
1386:
1387: -- Debug Message
1388: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1389: -- Standard call to get message count and if count is 1, get message info.
1390: FND_MSG_PUB.Count_And_Get
1391: (p_count => x_msg_count,
1392: p_data => x_msg_data
1393: );
1394: END Validate_ozf_offr_qual_Rec;