113:
114: -- Initialize message list if p_init_msg_list is set to TRUE.
115: IF FND_API.to_Boolean( p_init_msg_list )
116: THEN
117: FND_MSG_PUB.initialize;
118: END IF;
119:
120:
121:
218: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
219:
220:
221: -- Standard call to get message count and if count is 1, get message info.
222: FND_MSG_PUB.Count_And_Get
223: (p_count => x_msg_count,
224: p_data => x_msg_data
225: );
226: EXCEPTION
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: -- Standard call to get message count and if count=1, get the message
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data
240: );
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: -- Standard call to get message count and if count=1, get the message
246: FND_MSG_PUB.Count_And_Get (
247: p_encoded => FND_API.G_FALSE,
248: p_count => x_msg_count,
249: p_data => x_msg_data
250: );
251:
252: WHEN OTHERS THEN
253: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
258: END IF;
259: -- Standard call to get message count and if count=1, get the message
253: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
258: END IF;
259: -- Standard call to get message count and if count=1, get the message
260: FND_MSG_PUB.Count_And_Get (
261: p_encoded => FND_API.G_FALSE,
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
258: END IF;
259: -- Standard call to get message count and if count=1, get the message
260: FND_MSG_PUB.Count_And_Get (
261: p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data
264: );
347:
348: -- Initialize message list if p_init_msg_list is set to TRUE.
349: IF FND_API.to_Boolean( p_init_msg_list )
350: THEN
351: FND_MSG_PUB.initialize;
352: END IF;
353:
354:
355:
417: END IF;
418:
419:
420: -- Debug Message
421: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW || ' Private API: Calling update table handler');
422:
423: l_object_version_number := p_offadj_tier_rec.object_version_number;
424:
425: -- Invoke table handler(Ozf_Offer_Adj_Tier_Pkg.Update_Row)
453: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
454:
455:
456: -- Standard call to get message count and if count is 1, get message info.
457: FND_MSG_PUB.Count_And_Get
458: (p_count => x_msg_count,
459: p_data => x_msg_data
460: );
461: EXCEPTION
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: -- Standard call to get message count and if count=1, get the message
471: FND_MSG_PUB.Count_And_Get (
472: p_encoded => FND_API.G_FALSE,
473: p_count => x_msg_count,
474: p_data => x_msg_data
475: );
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: -- Standard call to get message count and if count=1, get the message
481: FND_MSG_PUB.Count_And_Get (
482: p_encoded => FND_API.G_FALSE,
483: p_count => x_msg_count,
484: p_data => x_msg_data
485: );
486:
487: WHEN OTHERS THEN
488: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
491: THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
493: END IF;
494: -- Standard call to get message count and if count=1, get the message
488: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
491: THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
493: END IF;
494: -- Standard call to get message count and if count=1, get the message
495: FND_MSG_PUB.Count_And_Get (
496: p_encoded => FND_API.G_FALSE,
491: THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
493: END IF;
494: -- Standard call to get message count and if count=1, get the message
495: FND_MSG_PUB.Count_And_Get (
496: p_encoded => FND_API.G_FALSE,
497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );
567:
568: -- Initialize message list if p_init_msg_list is set to TRUE.
569: IF FND_API.to_Boolean( p_init_msg_list )
570: THEN
571: FND_MSG_PUB.initialize;
572: END IF;
573:
574:
575:
606: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get
611: (p_count => x_msg_count,
612: p_data => x_msg_data
613: );
614: EXCEPTION
620: WHEN FND_API.G_EXC_ERROR THEN
621: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: -- Standard call to get message count and if count=1, get the message
624: FND_MSG_PUB.Count_And_Get (
625: p_encoded => FND_API.G_FALSE,
626: p_count => x_msg_count,
627: p_data => x_msg_data
628: );
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: -- Standard call to get message count and if count=1, get the message
634: FND_MSG_PUB.Count_And_Get (
635: p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => x_msg_data
638: );
639:
640: WHEN OTHERS THEN
641: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
644: THEN
645: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
646: END IF;
647: -- Standard call to get message count and if count=1, get the message
641: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
644: THEN
645: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
646: END IF;
647: -- Standard call to get message count and if count=1, get the message
648: FND_MSG_PUB.Count_And_Get (
649: p_encoded => FND_API.G_FALSE,
644: THEN
645: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
646: END IF;
647: -- Standard call to get message count and if count=1, get the message
648: FND_MSG_PUB.Count_And_Get (
649: p_encoded => FND_API.G_FALSE,
650: p_count => x_msg_count,
651: p_data => x_msg_data
652: );
714:
715: -- Initialize message list if p_init_msg_list is set to TRUE.
716: IF FND_API.to_Boolean( p_init_msg_list )
717: THEN
718: FND_MSG_PUB.initialize;
719: END IF;
720:
721:
722:
739: OZF_Offer_Adj_Tier_PKG.Lock_Row(l_offer_adjst_tier_id,p_object_version);
740:
741:
742: -------------------- finish --------------------------
743: FND_MSG_PUB.count_and_get(
744: p_encoded => FND_API.g_false,
745: p_count => x_msg_count,
746: p_data => x_msg_data);
747: OZF_Utility_PVT.debug_message(l_full_name ||': end');
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => x_msg_data
762: );
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: -- Standard call to get message count and if count=1, get the message
768: FND_MSG_PUB.Count_And_Get (
769: p_encoded => FND_API.G_FALSE,
770: p_count => x_msg_count,
771: p_data => x_msg_data
772: );
773:
774: WHEN OTHERS THEN
775: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
778: THEN
779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;
781: -- Standard call to get message count and if count=1, get the message
775: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
778: THEN
779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;
781: -- Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (
783: p_encoded => FND_API.G_FALSE,
778: THEN
779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;
781: -- Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (
783: p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data
786: );
1175:
1176: -- Initialize message list if p_init_msg_list is set to TRUE.
1177: IF FND_API.to_Boolean( p_init_msg_list )
1178: THEN
1179: FND_MSG_PUB.initialize;
1180: END IF;
1181:
1182:
1183: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1235: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1236:
1237:
1238: -- Standard call to get message count and if count is 1, get message info.
1239: FND_MSG_PUB.Count_And_Get
1240: (p_count => x_msg_count,
1241: p_data => x_msg_data
1242: );
1243: EXCEPTION
1249: WHEN FND_API.G_EXC_ERROR THEN
1250: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1251: x_return_status := FND_API.G_RET_STS_ERROR;
1252: -- Standard call to get message count and if count=1, get the message
1253: FND_MSG_PUB.Count_And_Get (
1254: p_encoded => FND_API.G_FALSE,
1255: p_count => x_msg_count,
1256: p_data => x_msg_data
1257: );
1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1260: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: -- Standard call to get message count and if count=1, get the message
1263: FND_MSG_PUB.Count_And_Get (
1264: p_encoded => FND_API.G_FALSE,
1265: p_count => x_msg_count,
1266: p_data => x_msg_data
1267: );
1268:
1269: WHEN OTHERS THEN
1270: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1273: THEN
1274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1275: END IF;
1276: -- Standard call to get message count and if count=1, get the message
1270: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1273: THEN
1274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1275: END IF;
1276: -- Standard call to get message count and if count=1, get the message
1277: FND_MSG_PUB.Count_And_Get (
1278: p_encoded => FND_API.G_FALSE,
1273: THEN
1274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1275: END IF;
1276: -- Standard call to get message count and if count=1, get the message
1277: FND_MSG_PUB.Count_And_Get (
1278: p_encoded => FND_API.G_FALSE,
1279: p_count => x_msg_count,
1280: p_data => x_msg_data
1281: );
1294: BEGIN
1295: -- Initialize message list if p_init_msg_list is set to TRUE.
1296: IF FND_API.to_Boolean( p_init_msg_list )
1297: THEN
1298: FND_MSG_PUB.initialize;
1299: END IF;
1300:
1301:
1302:
1310:
1311: -- Debug Message
1312: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1313: -- Standard call to get message count and if count is 1, get message info.
1314: FND_MSG_PUB.Count_And_Get
1315: (p_count => x_msg_count,
1316: p_data => x_msg_data
1317: );
1318: END Validate_offadj_tier_Rec;