DBA Data[Home] [Help]

APPS.OZF_OFFER_PERFORMANCE_PVT dependencies on FND_MSG_PUB

Line 71: FND_MSG_PUB.initialize;

67:
68: -- Initialize message list if p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list )
70: THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: -- Debug Message
75: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');

Line 193: FND_MSG_PUB.Count_And_Get

189: -- Debug Message
190: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
191:
192: -- Standard call to get message count and if count is 1, get message info.
193: FND_MSG_PUB.Count_And_Get
194: (p_count => x_msg_count,
195: p_data => x_msg_data
196: );
197: EXCEPTION

Line 207: FND_MSG_PUB.Count_And_Get (

203: WHEN FND_API.G_EXC_ERROR THEN
204: ROLLBACK TO CREATE_Offer_Performance_PVT;
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: -- Standard call to get message count and if count=1, get the message
207: FND_MSG_PUB.Count_And_Get (
208: p_encoded => FND_API.G_FALSE,
209: p_count => x_msg_count,
210: p_data => x_msg_data
211: );

Line 217: FND_MSG_PUB.Count_And_Get (

213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: ROLLBACK TO CREATE_Offer_Performance_PVT;
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: -- Standard call to get message count and if count=1, get the message
217: FND_MSG_PUB.Count_And_Get (
218: p_encoded => FND_API.G_FALSE,
219: p_count => x_msg_count,
220: p_data => x_msg_data
221: );

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

222:
223: WHEN OTHERS THEN
224: ROLLBACK TO CREATE_Offer_Performance_PVT;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
229: END IF;
230: -- Standard call to get message count and if count=1, get the message

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

224: ROLLBACK TO CREATE_Offer_Performance_PVT;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
229: END IF;
230: -- Standard call to get message count and if count=1, get the message
231: FND_MSG_PUB.Count_And_Get (
232: p_encoded => FND_API.G_FALSE,

Line 231: FND_MSG_PUB.Count_And_Get (

227: THEN
228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
229: END IF;
230: -- Standard call to get message count and if count=1, get the message
231: FND_MSG_PUB.Count_And_Get (
232: p_encoded => FND_API.G_FALSE,
233: p_count => x_msg_count,
234: p_data => x_msg_data
235: );

Line 289: FND_MSG_PUB.initialize;

285:
286: -- Initialize message list if p_init_msg_list is set to TRUE.
287: IF FND_API.to_Boolean( p_init_msg_list )
288: THEN
289: FND_MSG_PUB.initialize;
290: END IF;
291:
292: -- Debug Message
293: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');

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

353: END IF;
354:
355: ozf_utility_pvt.debug_message('out OUT NOCOPY out of validate');
356: -- Debug Message
357: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW||'Private API: Calling update table handler');
358: l_object_version_number := l_tar_offer_perf_rec.object_version_number + 1;
359: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Update_Row)
360: OZF_OFFER_PERFORMANCES_PKG.Update_Row(
361: p_offer_performance_id => p_offer_perf_rec.offer_performance_id,

Line 415: FND_MSG_PUB.Count_And_Get

411: -- Debug Message
412: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
413:
414: -- Standard call to get message count and if count is 1, get message info.
415: FND_MSG_PUB.Count_And_Get
416: (p_count => x_msg_count,
417: p_data => x_msg_data
418: );
419: EXCEPTION

Line 429: FND_MSG_PUB.Count_And_Get (

425: WHEN FND_API.G_EXC_ERROR THEN
426: ROLLBACK TO UPDATE_Offer_Performance_PVT;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (
430: p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,
432: p_data => x_msg_data
433: );

Line 439: FND_MSG_PUB.Count_And_Get (

435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
436: ROLLBACK TO UPDATE_Offer_Performance_PVT;
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: -- Standard call to get message count and if count=1, get the message
439: FND_MSG_PUB.Count_And_Get (
440: p_encoded => FND_API.G_FALSE,
441: p_count => x_msg_count,
442: p_data => x_msg_data
443: );

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

444:
445: WHEN OTHERS THEN
446: ROLLBACK TO UPDATE_Offer_Performance_PVT;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
451: END IF;
452: -- Standard call to get message count and if count=1, get the message

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

446: ROLLBACK TO UPDATE_Offer_Performance_PVT;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
451: END IF;
452: -- Standard call to get message count and if count=1, get the message
453: FND_MSG_PUB.Count_And_Get (
454: p_encoded => FND_API.G_FALSE,

Line 453: FND_MSG_PUB.Count_And_Get (

449: THEN
450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
451: END IF;
452: -- Standard call to get message count and if count=1, get the message
453: FND_MSG_PUB.Count_And_Get (
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,
456: p_data => x_msg_data
457: );

Line 495: FND_MSG_PUB.initialize;

491:
492: -- Initialize message list if p_init_msg_list is set to TRUE.
493: IF FND_API.to_Boolean( p_init_msg_list )
494: THEN
495: FND_MSG_PUB.initialize;
496: END IF;
497:
498: -- Debug Message
499: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');

Line 529: FND_MSG_PUB.Count_And_Get

525: -- Debug Message
526: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
527:
528: -- Standard call to get message count and if count is 1, get message info.
529: FND_MSG_PUB.Count_And_Get
530: (p_count => x_msg_count,
531: p_data => x_msg_data
532: );
533: EXCEPTION

Line 543: FND_MSG_PUB.Count_And_Get (

539: WHEN FND_API.G_EXC_ERROR THEN
540: ROLLBACK TO DELETE_Offer_Performance_PVT;
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: -- Standard call to get message count and if count=1, get the message
543: FND_MSG_PUB.Count_And_Get (
544: p_encoded => FND_API.G_FALSE,
545: p_count => x_msg_count,
546: p_data => x_msg_data
547: );

Line 553: FND_MSG_PUB.Count_And_Get (

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

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

558:
559: WHEN OTHERS THEN
560: ROLLBACK TO DELETE_Offer_Performance_PVT;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563: THEN
564: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
565: END IF;
566: -- Standard call to get message count and if count=1, get the message

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

560: ROLLBACK TO DELETE_Offer_Performance_PVT;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563: THEN
564: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
565: END IF;
566: -- Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,

Line 567: FND_MSG_PUB.Count_And_Get (

563: THEN
564: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
565: END IF;
566: -- Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data
571: );

Line 610: FND_MSG_PUB.initialize;

606:
607: -- Initialize message list if p_init_msg_list is set to TRUE.
608: IF FND_API.to_Boolean( p_init_msg_list )
609: THEN
610: FND_MSG_PUB.initialize;
611: END IF;
612:
613: -- Standard call to check for call compatibility.
614: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 636: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

632: FETCH c_Offer_Performance INTO l_OFFER_PERFORMANCE_ID;
633:
634: IF (c_Offer_Performance%NOTFOUND) THEN
635: CLOSE c_Offer_Performance;
636: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
637: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
638: FND_MSG_PUB.add;
639: END IF;
640: RAISE FND_API.g_exc_error;

Line 638: FND_MSG_PUB.add;

634: IF (c_Offer_Performance%NOTFOUND) THEN
635: CLOSE c_Offer_Performance;
636: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
637: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
638: FND_MSG_PUB.add;
639: END IF;
640: RAISE FND_API.g_exc_error;
641: END IF;
642:

Line 646: FND_MSG_PUB.count_and_get(

642:
643: CLOSE c_Offer_Performance;
644:
645: -------------------- finish --------------------------
646: FND_MSG_PUB.count_and_get(
647: p_encoded => FND_API.g_false,
648: p_count => x_msg_count,
649: p_data => x_msg_data);
650: ozf_utility_pvt.debug_message(l_full_name ||': end');

Line 661: FND_MSG_PUB.Count_And_Get (

657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO LOCK_Offer_Performance_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: -- Standard call to get message count and if count=1, get the message
661: FND_MSG_PUB.Count_And_Get (
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data
665: );

Line 671: FND_MSG_PUB.Count_And_Get (

667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO LOCK_Offer_Performance_PVT;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: -- Standard call to get message count and if count=1, get the message
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data
675: );

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

676:
677: WHEN OTHERS THEN
678: ROLLBACK TO LOCK_Offer_Performance_PVT;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
684: -- Standard call to get message count and if count=1, get the message

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

678: ROLLBACK TO LOCK_Offer_Performance_PVT;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
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,

Line 685: FND_MSG_PUB.Count_And_Get (

681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
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
689: );

Line 1064: FND_MSG_PUB.initialize;

1060:
1061: -- Initialize message list if p_init_msg_list is set to TRUE.
1062: IF FND_API.to_Boolean( p_init_msg_list )
1063: THEN
1064: FND_MSG_PUB.initialize;
1065: END IF;
1066: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1067: Check_offer_perf_Items(
1068: p_offer_perf_rec => p_offer_perf_rec,

Line 1114: FND_MSG_PUB.Count_And_Get

1110: -- Debug Message
1111: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
1112:
1113: -- Standard call to get message count and if count is 1, get message info.
1114: FND_MSG_PUB.Count_And_Get
1115: (p_count => x_msg_count,
1116: p_data => x_msg_data
1117: );
1118: EXCEPTION

Line 1128: FND_MSG_PUB.Count_And_Get (

1124: WHEN FND_API.G_EXC_ERROR THEN
1125: ROLLBACK TO VALIDATE_Offer_Performance_;
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: -- Standard call to get message count and if count=1, get the message
1128: FND_MSG_PUB.Count_And_Get (
1129: p_encoded => FND_API.G_FALSE,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1132: );

Line 1138: FND_MSG_PUB.Count_And_Get (

1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1135: ROLLBACK TO VALIDATE_Offer_Performance_;
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137: -- Standard call to get message count and if count=1, get the message
1138: FND_MSG_PUB.Count_And_Get (
1139: p_encoded => FND_API.G_FALSE,
1140: p_count => x_msg_count,
1141: p_data => x_msg_data
1142: );

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

1143:
1144: WHEN OTHERS THEN
1145: ROLLBACK TO VALIDATE_Offer_Performance_;
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1147: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1148: THEN
1149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1150: END IF;
1151: -- Standard call to get message count and if count=1, get the message

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

1145: ROLLBACK TO VALIDATE_Offer_Performance_;
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1147: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1148: THEN
1149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1150: END IF;
1151: -- Standard call to get message count and if count=1, get the message
1152: FND_MSG_PUB.Count_And_Get (
1153: p_encoded => FND_API.G_FALSE,

Line 1152: FND_MSG_PUB.Count_And_Get (

1148: THEN
1149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1150: END IF;
1151: -- Standard call to get message count and if count=1, get the message
1152: FND_MSG_PUB.Count_And_Get (
1153: p_encoded => FND_API.G_FALSE,
1154: p_count => x_msg_count,
1155: p_data => x_msg_data
1156: );

Line 1173: FND_MSG_PUB.initialize;

1169: BEGIN
1170: -- Initialize message list if p_init_msg_list is set to TRUE.
1171: IF FND_API.to_Boolean( p_init_msg_list )
1172: THEN
1173: FND_MSG_PUB.initialize;
1174: END IF;
1175:
1176: -- Initialize API return status to SUCCESS
1177: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1187: FND_MSG_PUB.Count_And_Get

1183:
1184: -- Debug Message
1185: ozf_utility_pvt.debug_message('Private API: Validate_dm_model_rec');
1186: -- Standard call to get message count and if count is 1, get message info.
1187: FND_MSG_PUB.Count_And_Get
1188: (p_count => x_msg_count,
1189: p_data => x_msg_data
1190: );
1191: END Validate_offer_perf_Rec;