DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on FND_MSG_PUB

Line 17: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

13: G_PRICING_EVENT CONSTANT VARCHAR2(30) := 'PRICING';
14:
15: G_TP_ACCRUAL_UTIL_TYPE CONSTANT VARCHAR2(30) :='ADJUSTMENT';
16:
17: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
18: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
19:
20: G_PRC_DIFF_BUDGET NUMBER := FND_PROFILE.value('OZF_THRDPTY_PRCDIFF_BUDGET');
21: G_TP_DEFAULT_PRICE_LIST NUMBER := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');

Line 18: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

14:
15: G_TP_ACCRUAL_UTIL_TYPE CONSTANT VARCHAR2(30) :='ADJUSTMENT';
16:
17: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
18: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
19:
20: G_PRC_DIFF_BUDGET NUMBER := FND_PROFILE.value('OZF_THRDPTY_PRCDIFF_BUDGET');
21: G_TP_DEFAULT_PRICE_LIST NUMBER := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');
22: G_PRICING_SIM_EVENT VARCHAR2(30) := FND_PROFILE.value('OZF_PRICING_SIMULATION_EVENT');

Line 180: FND_MSG_PUB.initialize;

176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: --Initialize message list if p_init_msg_list is TRUE.
179: IF FND_API.To_Boolean (p_init_msg_list) THEN
180: FND_MSG_PUB.initialize;
181: END IF;
182:
183: -- Debug Message
184: IF OZF_DEBUG_HIGH_ON THEN

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

224: AND a.error_code = 'OZF_BATCH_STATUS_WNG'
225: );
226: EXCEPTION
227: WHEN OTHERS THEN
228: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
229: FND_MESSAGE.set_name('OZF', 'OZF_INS_RESALE_LOG_WRG');
230: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
231: FND_MSG_PUB.add;
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 231: FND_MSG_PUB.add;

227: WHEN OTHERS THEN
228: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
229: FND_MESSAGE.set_name('OZF', 'OZF_INS_RESALE_LOG_WRG');
230: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
231: FND_MSG_PUB.add;
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234: END;
235: END IF;

Line 243: FND_MSG_PUB.Count_And_Get (

239: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
240: END IF;
241:
242: --Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );

Line 252: FND_MSG_PUB.Count_And_Get (

248: EXCEPTION
249: WHEN FND_API.G_EXC_ERROR THEN
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: -- Standard call to get message count and if count=1, get the message
252: FND_MSG_PUB.Count_And_Get (
253: p_encoded => FND_API.G_FALSE,
254: p_count => x_msg_count,
255: p_data => x_msg_data
256: );

Line 260: FND_MSG_PUB.Count_And_Get (

256: );
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 269: FND_MSG_PUB.Count_And_Get (

265: WHEN OTHERS THEN
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267:
268: -- Standard call to get message count and if count=1, get the message
269: FND_MSG_PUB.Count_And_Get (
270: p_encoded => FND_API.G_FALSE,
271: p_count => x_msg_count,
272: p_data => x_msg_data
273: );

Line 319: FND_MSG_PUB.initialize;

315: END IF;
316:
317: --Initialize message list if p_init_msg_list is TRUE.
318: IF FND_API.To_Boolean (p_init_msg_list) THEN
319: FND_MSG_PUB.initialize;
320: END IF;
321:
322: -- Debug Message
323: IF OZF_DEBUG_HIGH_ON THEN

Line 428: FND_MSG_PUB.Count_And_Get (

424: IF OZF_DEBUG_HIGH_ON THEN
425: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
426: END IF;
427: --Standard call to get message count and if count=1, get the message
428: FND_MSG_PUB.Count_And_Get (
429: p_encoded => FND_API.G_FALSE,
430: p_count => x_msg_count,
431: p_data => x_msg_data
432: );

Line 437: FND_MSG_PUB.Count_And_Get (

433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: -- Standard call to get message count and if count=1, get the message
437: FND_MSG_PUB.Count_And_Get (
438: p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data
441: );

Line 445: FND_MSG_PUB.Count_And_Get (

441: );
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: -- Standard call to get message count and if count=1, get the message
445: FND_MSG_PUB.Count_And_Get (
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,
448: p_data => x_msg_data
449: );

Line 454: FND_MSG_PUB.Count_And_Get (

450: WHEN OTHERS THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452:
453: -- Standard call to get message count and if count=1, get the message
454: FND_MSG_PUB.Count_And_Get (
455: p_encoded => FND_API.G_FALSE,
456: p_count => x_msg_count,
457: p_data => x_msg_data
458: );

Line 1180: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1176: FETCH c_purchase_price INTO l_cost_price;
1177: CLOSE c_purchase_price;
1178:
1179: IF (l_cost_price = -1 AND (l_ldets_tbl(k).operand_calculation_code = '%' OR l_ldets_tbl(k).operand_calculation_code ='UNIT_PRICE')) THEN
1180: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1181: FND_MESSAGE.Set_Token('OZF', 'OZF_COST_PRICE_NOT_FOUND');
1182: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
1183: FND_MESSAGE.Set_Token('ORDER',l_act_util_rec.object_id);
1184: FND_MESSAGE.Set_Token('ITEM',l_act_util_rec.product_id);

Line 1186: fnd_msg_pub.add;

1182: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
1183: FND_MESSAGE.Set_Token('ORDER',l_act_util_rec.object_id);
1184: FND_MESSAGE.Set_Token('ITEM',l_act_util_rec.product_id);
1185: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1186: fnd_msg_pub.add;
1187: END IF;
1188: RAISE fnd_api.g_exc_error;
1189: END IF;
1190:

Line 2421: FND_MSG_PUB.initialize;

2417: END IF;
2418:
2419: --Initialize message list if p_init_msg_list is TRUE.
2420: IF FND_API.To_Boolean (p_init_msg_list) THEN
2421: FND_MSG_PUB.initialize;
2422: END IF;
2423:
2424: -- Debug Message
2425: IF OZF_DEBUG_HIGH_ON THEN

Line 2887: FND_MSG_PUB.Count_And_Get (

2883: x_ozf_act_budgets_tbl => l_ozf_act_budgets_tbl,
2884: x_ozf_funds_new_tbl => l_ozf_funds_new_tbl
2885: );
2886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2887: FND_MSG_PUB.Count_And_Get (
2888: p_encoded => FND_API.G_FALSE,
2889: p_count => l_temp_count,
2890: p_data => l_temp_data
2891: );

Line 2893: fnd_msg_pub.Get(

2889: p_count => l_temp_count,
2890: p_data => l_temp_data
2891: );
2892:
2893: fnd_msg_pub.Get(
2894: p_msg_index => l_temp_count,
2895: p_encoded => FND_API.G_FALSE,
2896: p_data => l_temp_data,
2897: p_msg_index_out => l_temp_count

Line 2998: FND_MSG_PUB.Count_And_Get (

2994: IF OZF_DEBUG_HIGH_ON THEN
2995: OZF_UTILITY_PVT.debug_message(l_full_name||': End'|| x_return_status);
2996: END IF;
2997: --Standard call to get message count and if count=1, get the message
2998: FND_MSG_PUB.Count_And_Get (
2999: p_encoded => FND_API.G_FALSE,
3000: p_count => x_msg_count,
3001: p_data => x_msg_data
3002: );

Line 3008: FND_MSG_PUB.Count_And_Get (

3004: WHEN FND_API.G_EXC_ERROR THEN
3005: ROLLBACK TO Process_Resale_Order;
3006: x_return_status := FND_API.G_RET_STS_ERROR;
3007: -- Standard call to get message count and if count=1, get the message
3008: FND_MSG_PUB.Count_And_Get (
3009: p_encoded => FND_API.G_FALSE,
3010: p_count => x_msg_count,
3011: p_data => x_msg_data
3012: );

Line 3018: FND_MSG_PUB.Count_And_Get (

3014: ROLLBACK TO Process_Resale_Order;
3015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3016:
3017: -- Standard call to get message count and if count=1, get the message
3018: FND_MSG_PUB.Count_And_Get (
3019: p_encoded => FND_API.G_FALSE,
3020: p_count => x_msg_count,
3021: p_data => x_msg_data
3022: );

Line 3028: FND_MSG_PUB.Count_And_Get (

3024: ROLLBACK TO Process_Resale_Order;
3025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3026:
3027: -- Standard call to get message count and if count=1, get the message
3028: FND_MSG_PUB.Count_And_Get (
3029: p_encoded => FND_API.G_FALSE,
3030: p_count => x_msg_count,
3031: p_data => x_msg_data
3032: );

Line 3080: FND_MSG_PUB.initialize;

3076: END IF;
3077:
3078: --Initialize message lISt if p_init_msg_list IS TRUE.
3079: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN
3080: FND_MSG_PUB.initialize;
3081: END IF;
3082:
3083: -- Debug Message
3084: IF OZF_DEBUG_LOW_ON THEN

Line 3150: FND_MSG_PUB.Count_And_Get (

3146: IF OZF_DEBUG_HIGH_ON THEN
3147: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
3148: END IF;
3149: --Standard call to get message count and if count=1, get the message
3150: FND_MSG_PUB.Count_And_Get (
3151: p_encoded => FND_API.G_FALSE,
3152: p_count => x_msg_count,
3153: p_data => x_msg_data
3154: );

Line 3161: FND_MSG_PUB.Count_And_Get (

3157: WHEN FND_API.G_EXC_ERROR THEN
3158: ROLLBACK TO PROCESS_TP_RESALE;
3159: x_return_status := FND_API.G_RET_STS_ERROR;
3160: -- Standard call to get message count and if count=1, get the message
3161: FND_MSG_PUB.Count_And_Get (
3162: p_encoded => FND_API.G_FALSE,
3163: p_count => x_msg_count,
3164: p_data => x_msg_data
3165: );

Line 3171: FND_MSG_PUB.Count_And_Get (

3167: ROLLBACK TO PROCESS_TP_RESALE;
3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3169:
3170: -- Standard call to get message count and if count=1, get the message
3171: FND_MSG_PUB.Count_And_Get (
3172: p_encoded => FND_API.G_FALSE,
3173: p_count => x_msg_count,
3174: p_data => x_msg_data
3175: );

Line 3181: FND_MSG_PUB.Count_And_Get (

3177: ROLLBACK TO PROCESS_TP_RESALE;
3178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3179:
3180: -- Standard call to get message count and if count=1, get the message
3181: FND_MSG_PUB.Count_And_Get (
3182: p_encoded => FND_API.G_FALSE,
3183: p_count => x_msg_count,
3184: p_data => x_msg_data
3185: );

Line 3287: FND_MSG_PUB.initialize;

3283: END IF;
3284:
3285: --Initialize message list if p_init_msg_list is TRUE.
3286: IF FND_API.To_Boolean (p_init_msg_list) THEN
3287: FND_MSG_PUB.initialize;
3288: END IF;
3289:
3290: -- Debug Message
3291: IF OZF_DEBUG_HIGH_ON THEN

Line 3422: FND_MSG_PUB.Count_And_Get (

3418: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
3419: END IF;
3420:
3421: --Standard call to get message count and if count=1, get the message
3422: FND_MSG_PUB.Count_And_Get (
3423: p_encoded => FND_API.G_FALSE,
3424: p_count => x_msg_count,
3425: p_data => x_msg_data
3426: );

Line 3431: FND_MSG_PUB.Count_And_Get (

3427: EXCEPTION
3428: WHEN FND_API.G_EXC_ERROR THEN
3429: x_return_status := FND_API.G_RET_STS_ERROR;
3430: -- Standard call to get message count and if count=1, get the message
3431: FND_MSG_PUB.Count_And_Get (
3432: p_encoded => FND_API.G_FALSE,
3433: p_count => x_msg_count,
3434: p_data => x_msg_data
3435: );

Line 3440: FND_MSG_PUB.Count_And_Get (

3436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3438:
3439: -- Standard call to get message count and if count=1, get the message
3440: FND_MSG_PUB.Count_And_Get (
3441: p_encoded => FND_API.G_FALSE,
3442: p_count => x_msg_count,
3443: p_data => x_msg_data
3444: );

Line 3450: FND_MSG_PUB.Count_And_Get (

3446: ROLLBACK TO TP_ACCRUAL_MV_IC;
3447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3448:
3449: -- Standard call to get message count and if count=1, get the message
3450: FND_MSG_PUB.Count_And_Get (
3451: p_encoded => FND_API.G_FALSE,
3452: p_count => x_msg_count,
3453: p_data => x_msg_data
3454: );

Line 3664: FND_MSG_PUB.initialize;

3660: END IF;
3661:
3662: --Initialize message list if p_init_msg_list is TRUE.
3663: IF FND_API.To_Boolean (p_init_msg_list) THEN
3664: FND_MSG_PUB.initialize;
3665: END IF;
3666:
3667: -- Debug Message
3668: IF OZF_DEBUG_HIGH_ON THEN

Line 4228: FND_MSG_PUB.Count_And_Get (

4224: x_ozf_funds_new_tbl => l_ozf_funds_new_tbl,
4225: x_draft_accrual_tbl => l_ozf_draft_accrual_tbl
4226: );
4227: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4228: FND_MSG_PUB.Count_And_Get (
4229: p_encoded => FND_API.G_FALSE,
4230: p_count => l_temp_count,
4231: p_data => l_temp_data
4232: );

Line 4234: -- FND_MSG_PUB.Get(

4230: p_count => l_temp_count,
4231: p_data => l_temp_data
4232: );
4233:
4234: -- FND_MSG_PUB.Get(
4235: -- p_msg_index => l_temp_count,
4236: -- p_encoded => FND_API.G_FALSE,
4237: -- p_data => l_temp_data,
4238: -- p_msg_index_out => l_temp_count

Line 4582: FND_MSG_PUB.Count_And_Get (

4578: IF OZF_DEBUG_HIGH_ON THEN
4579: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');
4580: END IF;
4581: --Standard call to get message count and if count=1, get the message
4582: FND_MSG_PUB.Count_And_Get (
4583: p_encoded => FND_API.G_FALSE,
4584: p_count => x_msg_count,
4585: p_data => x_msg_data
4586: );

Line 4593: FND_MSG_PUB.Count_And_Get (

4589: WHEN FND_API.G_EXC_ERROR THEN
4590: ozf_utility_pvt.write_conc_log('ERROR in Process_Order');
4591: x_return_status := FND_API.G_RET_STS_ERROR;
4592: -- Standard call to get message count and if count=1, get the message
4593: FND_MSG_PUB.Count_And_Get (
4594: p_encoded => FND_API.G_FALSE,
4595: p_count => x_msg_count,
4596: p_data => x_msg_data
4597: );

Line 4604: FND_MSG_PUB.Count_And_Get (

4600: --ROLLBACK TO Process_Order;
4601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4602:
4603: -- Standard call to get message count and if count=1, get the message
4604: FND_MSG_PUB.Count_And_Get (
4605: p_encoded => FND_API.G_FALSE,
4606: p_count => x_msg_count,
4607: p_data => x_msg_data
4608: );

Line 4615: FND_MSG_PUB.Count_And_Get (

4611: --ROLLBACK TO Process_Order;
4612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4613:
4614: -- Standard call to get message count and if count=1, get the message
4615: FND_MSG_PUB.Count_And_Get (
4616: p_encoded => FND_API.G_FALSE,
4617: p_count => x_msg_count,
4618: p_data => x_msg_data
4619: );

Line 4837: FND_MSG_PUB.initialize;

4833: END IF;
4834:
4835: --Initialize message list if p_init_msg_list is TRUE.
4836: IF FND_API.To_Boolean (p_init_msg_list) THEN
4837: FND_MSG_PUB.initialize;
4838: END IF;
4839:
4840: -- Debug Message
4841: IF OZF_DEBUG_HIGH_ON THEN

Line 5668: FND_MSG_PUB.Count_And_Get (

5664: IF OZF_DEBUG_HIGH_ON THEN
5665: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
5666: END IF;
5667: --Standard call to get message count and if count=1, get the message
5668: FND_MSG_PUB.Count_And_Get (
5669: p_encoded => FND_API.G_FALSE,
5670: p_count => x_msg_count,
5671: p_data => x_msg_data
5672: );

Line 5679: FND_MSG_PUB.Count_And_Get (

5675: WHEN FND_API.G_EXC_ERROR THEN
5676: ozf_utility_pvt.write_conc_log('ERROR in Process_TP_ACCRUAL: '|| SQLERRM);
5677: x_return_status := FND_API.G_RET_STS_ERROR;
5678: -- Standard call to get message count and if count=1, get the message
5679: FND_MSG_PUB.Count_And_Get (
5680: p_encoded => FND_API.G_FALSE,
5681: p_count => x_msg_count,
5682: p_data => x_msg_data
5683: );

Line 5689: FND_MSG_PUB.Count_And_Get (

5685: ozf_utility_pvt.write_conc_log('UNEXPECTED ERROR in Process_TP_ACCRUAL: '|| SQLERRM);
5686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5687:
5688: -- Standard call to get message count and if count=1, get the message
5689: FND_MSG_PUB.Count_And_Get (
5690: p_encoded => FND_API.G_FALSE,
5691: p_count => x_msg_count,
5692: p_data => x_msg_data
5693: );

Line 5700: FND_MSG_PUB.Count_And_Get (

5696: --ROLLBACK TO Process_TP_ACCRUAL;
5697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5698:
5699: -- Standard call to get message count and if count=1, get the message
5700: FND_MSG_PUB.Count_And_Get (
5701: p_encoded => FND_API.G_FALSE,
5702: p_count => x_msg_count,
5703: p_data => x_msg_data
5704: );