APPS.OZF_QUOTA_ALLOCATIONS_PVT dependencies on FND_MSG_PUB

Line 178: Fnd_Msg_Pub.Count_AND_Get

174: EXCEPTION
175: WHEN Fnd_Api.G_EXC_ERROR THEN
176: x_return_status := Fnd_Api.g_ret_sts_error ;
177: ROLLBACK TO generate_product_spread_sp;
178: Fnd_Msg_Pub.Count_AND_Get
179: ( p_count => x_msg_count,
180: p_data => x_msg_data,
181: p_encoded => Fnd_Api.G_FALSE
182: );

Line 186: Fnd_Msg_Pub.Count_AND_Get

182: );
183: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
184: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
185: ROLLBACK TO generate_product_spread_sp;
186: Fnd_Msg_Pub.Count_AND_Get
187: ( p_count => x_msg_count,
188: p_data => x_msg_data,
189: p_encoded => Fnd_Api.G_FALSE
190: );

Line 194: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

190: );
191: WHEN OTHERS THEN
192: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
193: ROLLBACK TO generate_product_spread_sp;
194: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
195: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
196: END IF;
197: Fnd_Msg_Pub.Count_AND_Get
198: ( p_count => x_msg_count,

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

191: WHEN OTHERS THEN
192: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
193: ROLLBACK TO generate_product_spread_sp;
194: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
195: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
196: END IF;
197: Fnd_Msg_Pub.Count_AND_Get
198: ( p_count => x_msg_count,
199: p_data => x_msg_data,

Line 197: Fnd_Msg_Pub.Count_AND_Get

193: ROLLBACK TO generate_product_spread_sp;
194: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
195: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
196: END IF;
197: Fnd_Msg_Pub.Count_AND_Get
198: ( p_count => x_msg_count,
199: p_data => x_msg_data,
200: p_encoded => Fnd_Api.G_FALSE
201: );

Line 269: Fnd_Msg_Pub.Count_AND_Get

265: EXCEPTION
266: WHEN Fnd_Api.G_EXC_ERROR THEN
267: x_return_status := Fnd_Api.g_ret_sts_error ;
268: ROLLBACK TO create_quota_alloc_hier_sp;
269: Fnd_Msg_Pub.Count_AND_Get
270: ( p_count => x_msg_count,
271: p_data => x_msg_data,
272: p_encoded => Fnd_Api.G_FALSE
273: );

Line 277: Fnd_Msg_Pub.Count_AND_Get

273: );
274: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
275: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
276: ROLLBACK TO create_quota_alloc_hier_sp;
277: Fnd_Msg_Pub.Count_AND_Get
278: ( p_count => x_msg_count,
279: p_data => x_msg_data,
280: p_encoded => Fnd_Api.G_FALSE
281: );

Line 285: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

281: );
282: WHEN OTHERS THEN
283: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
284: ROLLBACK TO create_quota_alloc_hier_sp;
285: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
286: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: Fnd_Msg_Pub.Count_AND_Get
289: ( p_count => x_msg_count,

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

282: WHEN OTHERS THEN
283: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
284: ROLLBACK TO create_quota_alloc_hier_sp;
285: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
286: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: Fnd_Msg_Pub.Count_AND_Get
289: ( p_count => x_msg_count,
290: p_data => x_msg_data,

Line 288: Fnd_Msg_Pub.Count_AND_Get

284: ROLLBACK TO create_quota_alloc_hier_sp;
285: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
286: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: Fnd_Msg_Pub.Count_AND_Get
289: ( p_count => x_msg_count,
290: p_data => x_msg_data,
291: p_encoded => Fnd_Api.G_FALSE
292: );

Line 345: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

341: EXCEPTION
342: WHEN OTHERS THEN
343: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
344: ROLLBACK TO update_fund_sp;
345: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
346: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
347: END IF;
348: Fnd_Msg_Pub.Count_AND_Get
349: ( p_count => x_msg_count,

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

342: WHEN OTHERS THEN
343: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
344: ROLLBACK TO update_fund_sp;
345: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
346: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
347: END IF;
348: Fnd_Msg_Pub.Count_AND_Get
349: ( p_count => x_msg_count,
350: p_data => x_msg_data,

Line 348: Fnd_Msg_Pub.Count_AND_Get

344: ROLLBACK TO update_fund_sp;
345: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
346: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
347: END IF;
348: Fnd_Msg_Pub.Count_AND_Get
349: ( p_count => x_msg_count,
350: p_data => x_msg_data,
351: p_encoded => Fnd_Api.G_FALSE
352: );

Line 434: Fnd_Msg_Pub.Count_AND_Get

430: EXCEPTION
431: WHEN Fnd_Api.G_EXC_ERROR THEN
432: x_return_status := Fnd_Api.g_ret_sts_error ;
433: ROLLBACK TO allocate_target_sp;
434: Fnd_Msg_Pub.Count_AND_Get
435: ( p_count => x_msg_count,
436: p_data => x_msg_data,
437: p_encoded => Fnd_Api.G_FALSE
438: );

Line 442: Fnd_Msg_Pub.Count_AND_Get

438: );
439: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
440: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
441: ROLLBACK TO allocate_target_sp;
442: Fnd_Msg_Pub.Count_AND_Get
443: ( p_count => x_msg_count,
444: p_data => x_msg_data,
445: p_encoded => Fnd_Api.G_FALSE
446: );

Line 450: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

446: );
447: WHEN OTHERS THEN
448: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
449: ROLLBACK TO allocate_target_sp;
450: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
451: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
452: END IF;
453: Fnd_Msg_Pub.Count_AND_Get
454: ( p_count => x_msg_count,

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

447: WHEN OTHERS THEN
448: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
449: ROLLBACK TO allocate_target_sp;
450: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
451: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
452: END IF;
453: Fnd_Msg_Pub.Count_AND_Get
454: ( p_count => x_msg_count,
455: p_data => x_msg_data,

Line 453: Fnd_Msg_Pub.Count_AND_Get

449: ROLLBACK TO allocate_target_sp;
450: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
451: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
452: END IF;
453: Fnd_Msg_Pub.Count_AND_Get
454: ( p_count => x_msg_count,
455: p_data => x_msg_data,
456: p_encoded => Fnd_Api.G_FALSE
457: );

Line 490: Fnd_Msg_Pub.initialize;

486:
487: SAVEPOINT publish_allocation_sp;
488:
489: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
490: Fnd_Msg_Pub.initialize;
491: END IF;
492:
493: /* IF NOT Fnd_Api.compatible_api_call
494: (

Line 600: Fnd_Msg_Pub.Count_AND_Get

596: EXCEPTION
597: WHEN Fnd_Api.G_EXC_ERROR THEN
598: x_return_status := Fnd_Api.g_ret_sts_error ;
599: ROLLBACK TO publish_allocation_sp;
600: Fnd_Msg_Pub.Count_AND_Get
601: ( p_count => x_msg_count,
602: p_data => x_msg_data,
603: p_encoded => Fnd_Api.G_FALSE
604: );

Line 608: Fnd_Msg_Pub.Count_AND_Get

604: );
605: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
606: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
607: ROLLBACK TO publish_allocation_sp;
608: Fnd_Msg_Pub.Count_AND_Get
609: ( p_count => x_msg_count,
610: p_data => x_msg_data,
611: p_encoded => Fnd_Api.G_FALSE
612: );

Line 616: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

612: );
613: WHEN OTHERS THEN
614: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
615: ROLLBACK TO publish_allocation_sp;
616: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
617: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
618: END IF;
619: Fnd_Msg_Pub.Count_AND_Get
620: ( p_count => x_msg_count,

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

613: WHEN OTHERS THEN
614: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
615: ROLLBACK TO publish_allocation_sp;
616: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
617: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
618: END IF;
619: Fnd_Msg_Pub.Count_AND_Get
620: ( p_count => x_msg_count,
621: p_data => x_msg_data,

Line 619: Fnd_Msg_Pub.Count_AND_Get

615: ROLLBACK TO publish_allocation_sp;
616: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
617: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
618: END IF;
619: Fnd_Msg_Pub.Count_AND_Get
620: ( p_count => x_msg_count,
621: p_data => x_msg_data,
622: p_encoded => Fnd_Api.G_FALSE
623: );

Line 713: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

709: EXCEPTION
710: WHEN OTHERS THEN
711: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
712: ROLLBACK TO cancel_alloc_hfq_sp;
713: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
714: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
715: END IF;
716: Fnd_Msg_Pub.Count_AND_Get
717: ( p_count => x_msg_count,

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

710: WHEN OTHERS THEN
711: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
712: ROLLBACK TO cancel_alloc_hfq_sp;
713: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
714: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
715: END IF;
716: Fnd_Msg_Pub.Count_AND_Get
717: ( p_count => x_msg_count,
718: p_data => x_msg_data,

Line 716: Fnd_Msg_Pub.Count_AND_Get

712: ROLLBACK TO cancel_alloc_hfq_sp;
713: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
714: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
715: END IF;
716: Fnd_Msg_Pub.Count_AND_Get
717: ( p_count => x_msg_count,
718: p_data => x_msg_data,
719: p_encoded => Fnd_Api.G_FALSE
720: );