DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJ_TIER_PVT dependencies on FND_MSG_PUB

Line 117: FND_MSG_PUB.initialize;

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:

Line 222: FND_MSG_PUB.Count_And_Get

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

Line 236: FND_MSG_PUB.Count_And_Get (

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

Line 246: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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,

Line 260: FND_MSG_PUB.Count_And_Get (

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

Line 351: FND_MSG_PUB.initialize;

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:

Line 421: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW || ' Private API: Calling update table handler');

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)

Line 457: FND_MSG_PUB.Count_And_Get

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

Line 471: FND_MSG_PUB.Count_And_Get (

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

Line 481: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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,

Line 495: FND_MSG_PUB.Count_And_Get (

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

Line 571: FND_MSG_PUB.initialize;

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:

Line 610: FND_MSG_PUB.Count_And_Get

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

Line 624: FND_MSG_PUB.Count_And_Get (

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

Line 634: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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,

Line 648: FND_MSG_PUB.Count_And_Get (

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

Line 718: FND_MSG_PUB.initialize;

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:

Line 743: FND_MSG_PUB.count_and_get(

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

Line 758: FND_MSG_PUB.Count_And_Get (

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

Line 768: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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,

Line 782: FND_MSG_PUB.Count_And_Get (

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

Line 1179: FND_MSG_PUB.initialize;

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

Line 1239: FND_MSG_PUB.Count_And_Get

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

Line 1253: FND_MSG_PUB.Count_And_Get (

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

Line 1263: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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,

Line 1277: FND_MSG_PUB.Count_And_Get (

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

Line 1298: FND_MSG_PUB.initialize;

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:

Line 1314: FND_MSG_PUB.Count_And_Get

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;