eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_BACKDATE_PVT dependencies on FND_MSG_PUB

Line 87: FND_MSG_PUB.initialize;

83:
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF FND_API.to_Boolean( p_init_msg_list )
86: THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Debug Message
91: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 188: FND_MSG_PUB.Count_And_Get

184: -- Debug Message
185: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
186:
187: -- Standard call to get message count and if count is 1, get message info.
188: FND_MSG_PUB.Count_And_Get
189: (p_count => x_msg_count,
190: p_data => x_msg_data
191: );
192: EXCEPTION

Line 202: FND_MSG_PUB.Count_And_Get (

198: WHEN FND_API.G_EXC_ERROR THEN
199: ROLLBACK TO CREATE_Offer_Backdate_PVT;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: -- Standard call to get message count and if count=1, get the message
202: FND_MSG_PUB.Count_And_Get (
203: p_encoded => FND_API.G_FALSE,
204: p_count => x_msg_count,
205: p_data => x_msg_data
206: );

Line 212: FND_MSG_PUB.Count_And_Get (

208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: ROLLBACK TO CREATE_Offer_Backdate_PVT;
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: -- Standard call to get message count and if count=1, get the message
212: FND_MSG_PUB.Count_And_Get (
213: p_encoded => FND_API.G_FALSE,
214: p_count => x_msg_count,
215: p_data => x_msg_data
216: );

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

217:
218: WHEN OTHERS THEN
219: ROLLBACK TO CREATE_Offer_Backdate_PVT;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
222: THEN
223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
224: END IF;
225: -- Standard call to get message count and if count=1, get the message

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

219: ROLLBACK TO CREATE_Offer_Backdate_PVT;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
222: THEN
223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
224: END IF;
225: -- Standard call to get message count and if count=1, get the message
226: FND_MSG_PUB.Count_And_Get (
227: p_encoded => FND_API.G_FALSE,

Line 226: FND_MSG_PUB.Count_And_Get (

222: THEN
223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
224: END IF;
225: -- Standard call to get message count and if count=1, get the message
226: FND_MSG_PUB.Count_And_Get (
227: p_encoded => FND_API.G_FALSE,
228: p_count => x_msg_count,
229: p_data => x_msg_data
230: );

Line 288: FND_MSG_PUB.initialize;

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

Line 390: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

386:
387:
388:
389: -- Debug Message
390: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
391:
392: -- Invoke table handler(ozf_OFFER_ADJUSTMENTS_PKG.Update_Row)
393: ozf_OFFER_ADJUSTMENTS_PKG.Update_Row(
394: p_offer_adjustment_id => p_offer_backdate_rec.offer_adjustment_id,

Line 426: FND_MSG_PUB.Count_And_Get

422: -- Debug Message
423: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
424:
425: -- Standard call to get message count and if count is 1, get message info.
426: FND_MSG_PUB.Count_And_Get
427: (p_count => x_msg_count,
428: p_data => x_msg_data
429: );
430: EXCEPTION

Line 440: FND_MSG_PUB.Count_And_Get (

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

Line 450: FND_MSG_PUB.Count_And_Get (

446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: ROLLBACK TO UPDATE_Offer_Backdate_PVT;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: -- Standard call to get message count and if count=1, get the message
450: FND_MSG_PUB.Count_And_Get (
451: p_encoded => FND_API.G_FALSE,
452: p_count => x_msg_count,
453: p_data => x_msg_data
454: );

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

455:
456: WHEN OTHERS THEN
457: ROLLBACK TO UPDATE_Offer_Backdate_PVT;
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
460: THEN
461: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
462: END IF;
463: -- Standard call to get message count and if count=1, get the message

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

457: ROLLBACK TO UPDATE_Offer_Backdate_PVT;
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
460: THEN
461: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
462: END IF;
463: -- Standard call to get message count and if count=1, get the message
464: FND_MSG_PUB.Count_And_Get (
465: p_encoded => FND_API.G_FALSE,

Line 464: FND_MSG_PUB.Count_And_Get (

460: THEN
461: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
462: END IF;
463: -- Standard call to get message count and if count=1, get the message
464: FND_MSG_PUB.Count_And_Get (
465: p_encoded => FND_API.G_FALSE,
466: p_count => x_msg_count,
467: p_data => x_msg_data
468: );

Line 505: FND_MSG_PUB.initialize;

501:
502: -- Initialize message list if p_init_msg_list is set to TRUE.
503: IF FND_API.to_Boolean( p_init_msg_list )
504: THEN
505: FND_MSG_PUB.initialize;
506: END IF;
507:
508: -- Debug Message
509: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 539: FND_MSG_PUB.Count_And_Get

535: -- Debug Message
536: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
537:
538: -- Standard call to get message count and if count is 1, get message info.
539: FND_MSG_PUB.Count_And_Get
540: (p_count => x_msg_count,
541: p_data => x_msg_data
542: );
543: EXCEPTION

Line 553: FND_MSG_PUB.Count_And_Get (

549: WHEN FND_API.G_EXC_ERROR THEN
550: ROLLBACK TO DELETE_Offer_Backdate_PVT;
551: x_return_status := FND_API.G_RET_STS_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 563: FND_MSG_PUB.Count_And_Get (

559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: ROLLBACK TO DELETE_Offer_Backdate_PVT;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: -- Standard call to get message count and if count=1, get the message
563: FND_MSG_PUB.Count_And_Get (
564: p_encoded => FND_API.G_FALSE,
565: p_count => x_msg_count,
566: p_data => x_msg_data
567: );

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

568:
569: WHEN OTHERS THEN
570: ROLLBACK TO DELETE_Offer_Backdate_PVT;
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
575: END IF;
576: -- Standard call to get message count and if count=1, get the message

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

570: ROLLBACK TO DELETE_Offer_Backdate_PVT;
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
575: END IF;
576: -- Standard call to get message count and if count=1, get the message
577: FND_MSG_PUB.Count_And_Get (
578: p_encoded => FND_API.G_FALSE,

Line 577: FND_MSG_PUB.Count_And_Get (

573: THEN
574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
575: END IF;
576: -- Standard call to get message count and if count=1, get the message
577: FND_MSG_PUB.Count_And_Get (
578: p_encoded => FND_API.G_FALSE,
579: p_count => x_msg_count,
580: p_data => x_msg_data
581: );

Line 620: FND_MSG_PUB.initialize;

616:
617: -- Initialize message list if p_init_msg_list is set to TRUE.
618: IF FND_API.to_Boolean( p_init_msg_list )
619: THEN
620: FND_MSG_PUB.initialize;
621: END IF;
622:
623: -- Standard call to check for call compatibility.
624: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

642: FETCH c_Offer_Backdate INTO l_OFFER_ADJUSTMENT_ID;
643:
644: IF (c_Offer_Backdate%NOTFOUND) THEN
645: CLOSE c_Offer_Backdate;
646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
647: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
648: FND_MSG_PUB.add;
649: END IF;
650: RAISE FND_API.g_exc_error;

Line 648: FND_MSG_PUB.add;

644: IF (c_Offer_Backdate%NOTFOUND) THEN
645: CLOSE c_Offer_Backdate;
646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
647: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
648: FND_MSG_PUB.add;
649: END IF;
650: RAISE FND_API.g_exc_error;
651: END IF;
652:

Line 656: FND_MSG_PUB.count_and_get(

652:
653: CLOSE c_Offer_Backdate;
654:
655: -------------------- finish --------------------------
656: FND_MSG_PUB.count_and_get(
657: p_encoded => FND_API.g_false,
658: p_count => x_msg_count,
659: p_data => x_msg_data);
660: OZF_Utility_PVT.debug_message(l_full_name ||': end');

Line 671: FND_MSG_PUB.Count_And_Get (

667: WHEN FND_API.G_EXC_ERROR THEN
668: ROLLBACK TO LOCK_Offer_Backdate_PVT;
669: x_return_status := FND_API.G_RET_STS_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 681: FND_MSG_PUB.Count_And_Get (

677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: ROLLBACK TO LOCK_Offer_Backdate_PVT;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: -- Standard call to get message count and if count=1, get the message
681: FND_MSG_PUB.Count_And_Get (
682: p_encoded => FND_API.G_FALSE,
683: p_count => x_msg_count,
684: p_data => x_msg_data
685: );

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

686:
687: WHEN OTHERS THEN
688: ROLLBACK TO LOCK_Offer_Backdate_PVT;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
693: END IF;
694: -- Standard call to get message count and if count=1, get the message

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

688: ROLLBACK TO LOCK_Offer_Backdate_PVT;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
693: END IF;
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,

Line 695: FND_MSG_PUB.Count_And_Get (

691: THEN
692: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
693: END IF;
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
699: );

Line 1001: FND_MSG_PUB.initialize;

997:
998: -- Initialize message list if p_init_msg_list is set to TRUE.
999: IF FND_API.to_Boolean( p_init_msg_list )
1000: THEN
1001: FND_MSG_PUB.initialize;
1002: END IF;
1003: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1004: Check_offer_backdate_Items(
1005: p_offer_backdate_rec => p_offer_backdate_rec,

Line 1051: FND_MSG_PUB.Count_And_Get

1047: -- Debug Message
1048: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1049:
1050: -- Standard call to get message count and if count is 1, get message info.
1051: FND_MSG_PUB.Count_And_Get
1052: (p_count => x_msg_count,
1053: p_data => x_msg_data
1054: );
1055: EXCEPTION

Line 1065: FND_MSG_PUB.Count_And_Get (

1061: WHEN FND_API.G_EXC_ERROR THEN
1062: ROLLBACK TO VALIDATE_Offer_Backdate_;
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: -- Standard call to get message count and if count=1, get the message
1065: FND_MSG_PUB.Count_And_Get (
1066: p_encoded => FND_API.G_FALSE,
1067: p_count => x_msg_count,
1068: p_data => x_msg_data
1069: );

Line 1075: FND_MSG_PUB.Count_And_Get (

1071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1072: ROLLBACK TO VALIDATE_Offer_Backdate_;
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: -- Standard call to get message count and if count=1, get the message
1075: FND_MSG_PUB.Count_And_Get (
1076: p_encoded => FND_API.G_FALSE,
1077: p_count => x_msg_count,
1078: p_data => x_msg_data
1079: );

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

1080:
1081: WHEN OTHERS THEN
1082: ROLLBACK TO VALIDATE_Offer_Backdate_;
1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1084: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1085: THEN
1086: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1087: END IF;
1088: -- Standard call to get message count and if count=1, get the message

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

1082: ROLLBACK TO VALIDATE_Offer_Backdate_;
1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1084: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1085: THEN
1086: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1087: END IF;
1088: -- Standard call to get message count and if count=1, get the message
1089: FND_MSG_PUB.Count_And_Get (
1090: p_encoded => FND_API.G_FALSE,

Line 1089: FND_MSG_PUB.Count_And_Get (

1085: THEN
1086: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1087: END IF;
1088: -- Standard call to get message count and if count=1, get the message
1089: FND_MSG_PUB.Count_And_Get (
1090: p_encoded => FND_API.G_FALSE,
1091: p_count => x_msg_count,
1092: p_data => x_msg_data
1093: );

Line 1110: FND_MSG_PUB.initialize;

1106: BEGIN
1107: -- Initialize message list if p_init_msg_list is set to TRUE.
1108: IF FND_API.to_Boolean( p_init_msg_list )
1109: THEN
1110: FND_MSG_PUB.initialize;
1111: END IF;
1112:
1113: -- Initialize API return status to SUCCESS
1114: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1124: FND_MSG_PUB.Count_And_Get

1120:
1121: -- Debug Message
1122: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1123: -- Standard call to get message count and if count is 1, get message info.
1124: FND_MSG_PUB.Count_And_Get
1125: (p_count => x_msg_count,
1126: p_data => x_msg_data
1127: );
1128: END Validate_offer_backdate_Rec;

Line 1267: FND_MSG_PUB.add;

1263: x_return_status := FND_API.g_ret_sts_unexp_error;
1264:
1265: FND_MESSAGE.set_name('OZF', 'OZF_CREATE_OFFR_ADJ_FAILED');
1266: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1267: FND_MSG_PUB.add;
1268:
1269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1270: THEN
1271: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1265: FND_MESSAGE.set_name('OZF', 'OZF_CREATE_OFFR_ADJ_FAILED');
1266: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1267: FND_MSG_PUB.add;
1268:
1269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1270: THEN
1271: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1272: END IF;
1273:

Line 1271: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1267: FND_MSG_PUB.add;
1268:
1269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1270: THEN
1271: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1272: END IF;
1273:
1274: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1275: p_count => x_msg_count,

Line 1274: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

1270: THEN
1271: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1272: END IF;
1273:
1274: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1275: p_count => x_msg_count,
1276: p_data => x_msg_data);
1277:
1278: END Create_Initial_Adj;

Line 1377: Fnd_Msg_Pub.initialize;

1373: ozf_utility_pvt.debug_message('inside process new adjustments');
1374: IF Fnd_Api.to_boolean(p_init_msg_list)
1375: THEN
1376:
1377: Fnd_Msg_Pub.initialize;
1378:
1379:
1380: END IF;
1381:

Line 2062: FND_MSG_PUB.count_and_get(

2058: EXCEPTION
2059: WHEN FND_API.G_EXC_ERROR THEN
2060: rollback to process_vo_adj_products;
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062: FND_MSG_PUB.count_and_get(
2063: p_encoded => FND_API.g_false
2064: , p_count => x_msg_count
2065: , p_data => x_msg_data
2066: );

Line 2070: FND_MSG_PUB.count_and_get(

2066: );
2067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2068: ROLLBACK TO process_vo_adj_products;
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2070: FND_MSG_PUB.count_and_get(
2071: p_encoded => FND_API.g_false
2072: , p_count => x_msg_count
2073: , p_data => x_msg_data
2074: );

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

2074: );
2075: WHEN OTHERS THEN
2076: ROLLBACK TO process_vo_adj_products;
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2078: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2079: THEN
2080: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2081: END IF;
2082: FND_MSG_PUB.count_and_get(

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

2076: ROLLBACK TO process_vo_adj_products;
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2078: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2079: THEN
2080: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2081: END IF;
2082: FND_MSG_PUB.count_and_get(
2083: p_encoded => FND_API.g_false
2084: , p_count => x_msg_count

Line 2082: FND_MSG_PUB.count_and_get(

2078: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2079: THEN
2080: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2081: END IF;
2082: FND_MSG_PUB.count_and_get(
2083: p_encoded => FND_API.g_false
2084: , p_count => x_msg_count
2085: , p_data => x_msg_data
2086: );

Line 2144: FND_MSG_PUB.INITIALIZE;

2140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2141: END IF;
2142:
2143: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2144: FND_MSG_PUB.INITIALIZE;
2145: END IF;*/
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2147: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');
2148: -- inactivate existing qp_list_lines

Line 2349: FND_MSG_PUB.count_and_get(

2345: EXCEPTION
2346: WHEN FND_API.G_EXC_ERROR THEN
2347: ROLLBACK TO process_vo_adj_tiers;
2348: x_return_status := FND_API.G_RET_STS_ERROR;
2349: FND_MSG_PUB.count_and_get(
2350: p_encoded => FND_API.g_false
2351: , p_count => x_msg_count
2352: , p_data => x_msg_data
2353: );

Line 2357: FND_MSG_PUB.count_and_get(

2353: );
2354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2355: ROLLBACK TO process_vo_adj_tiers;
2356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2357: FND_MSG_PUB.count_and_get(
2358: p_encoded => FND_API.g_false
2359: , p_count => x_msg_count
2360: , p_data => x_msg_data
2361: );

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

2361: );
2362: WHEN OTHERS THEN
2363: rollback to process_vo_adj_tiers;
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2366: THEN
2367: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2368: END IF;
2369: FND_MSG_PUB.count_and_get(

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

2363: rollback to process_vo_adj_tiers;
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2366: THEN
2367: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2368: END IF;
2369: FND_MSG_PUB.count_and_get(
2370: p_encoded => FND_API.g_false
2371: , p_count => x_msg_count

Line 2369: FND_MSG_PUB.count_and_get(

2365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2366: THEN
2367: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2368: END IF;
2369: FND_MSG_PUB.count_and_get(
2370: p_encoded => FND_API.g_false
2371: , p_count => x_msg_count
2372: , p_data => x_msg_data
2373: );

Line 2408: FND_MSG_PUB.INITIALIZE;

2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: END IF;
2406:
2407: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2408: FND_MSG_PUB.INITIALIZE;
2409: END IF;
2410:
2411: x_return_status := FND_API.G_RET_STS_SUCCESS;
2412: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');

Line 2449: FND_MSG_PUB.count_and_get(

2445: EXCEPTION
2446: WHEN FND_API.G_EXC_ERROR THEN
2447: ROLLBACK TO process_vo_adjustments;
2448: x_return_status := FND_API.G_RET_STS_ERROR;
2449: FND_MSG_PUB.count_and_get(
2450: p_encoded => FND_API.g_false
2451: , p_count => x_msg_count
2452: , p_data => x_msg_data
2453: );

Line 2457: FND_MSG_PUB.count_and_get(

2453: );
2454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2455: ROLLBACK TO process_vo_adjustments;
2456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2457: FND_MSG_PUB.count_and_get(
2458: p_encoded => FND_API.g_false
2459: , p_count => x_msg_count
2460: , p_data => x_msg_data
2461: );

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

2461: );
2462: WHEN OTHERS THEN
2463: ROLLBACK TO process_vo_adjustments;
2464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2465: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2466: THEN
2467: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2468: END IF;
2469: FND_MSG_PUB.count_and_get(

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

2463: ROLLBACK TO process_vo_adjustments;
2464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2465: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2466: THEN
2467: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2468: END IF;
2469: FND_MSG_PUB.count_and_get(
2470: p_encoded => FND_API.g_false
2471: , p_count => x_msg_count

Line 2469: FND_MSG_PUB.count_and_get(

2465: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2466: THEN
2467: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2468: END IF;
2469: FND_MSG_PUB.count_and_get(
2470: p_encoded => FND_API.g_false
2471: , p_count => x_msg_count
2472: , p_data => x_msg_data
2473: );

Line 2570: Fnd_Msg_Pub.Count_AND_Get

2566:
2567: EXCEPTION
2568: WHEN OTHERS THEN
2569: x_return_status := FND_API.G_RET_STS_ERROR;
2570: Fnd_Msg_Pub.Count_AND_Get
2571: ( p_count => x_msg_count,
2572: p_data => x_msg_data,
2573: p_encoded => Fnd_Api.G_FALSE
2574: );

Line 2602: Fnd_Msg_Pub.initialize;

2598: SAVEPOINT update_offer_discounts ;
2599:
2600: IF Fnd_Api.to_boolean(p_init_msg_list)
2601: THEN
2602: Fnd_Msg_Pub.initialize;
2603: END IF;
2604: IF NOT Fnd_Api.compatible_api_call ( l_api_version,
2605: p_api_version,
2606: l_api_name,

Line 2648: Fnd_Msg_Pub.Count_AND_Get

2644: EXCEPTION
2645: WHEN Fnd_Api.G_EXC_ERROR THEN
2646: x_return_status := Fnd_Api.g_ret_sts_error ;
2647: ROLLBACK TO update_offer_discounts;
2648: Fnd_Msg_Pub.Count_AND_Get
2649: ( p_count => x_msg_count,
2650: p_data => x_msg_data,
2651: p_encoded => Fnd_Api.G_FALSE
2652: );

Line 2656: Fnd_Msg_Pub.Count_AND_Get

2652: );
2653: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2654: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2655: ROLLBACK TO update_offer_discounts;
2656: Fnd_Msg_Pub.Count_AND_Get
2657: ( p_count => x_msg_count,
2658: p_data => x_msg_data,
2659: p_encoded => Fnd_Api.G_FALSE
2660: );

Line 2664: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

2660: );
2661: WHEN OTHERS THEN
2662: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2663: ROLLBACK TO update_offer_discounts ;
2664: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2665: THEN
2666: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2667: END IF;
2668: Fnd_Msg_Pub.Count_AND_Get

Line 2666: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2662: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2663: ROLLBACK TO update_offer_discounts ;
2664: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2665: THEN
2666: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2667: END IF;
2668: Fnd_Msg_Pub.Count_AND_Get
2669: ( p_count => x_msg_count,
2670: p_data => x_msg_data,

Line 2668: Fnd_Msg_Pub.Count_AND_Get

2664: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2665: THEN
2666: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2667: END IF;
2668: Fnd_Msg_Pub.Count_AND_Get
2669: ( p_count => x_msg_count,
2670: p_data => x_msg_data,
2671: p_encoded => Fnd_Api.G_FALSE
2672: );