128: END IF;
129:
130: -- Initialize message list.
131: IF fnd_api.to_boolean(p_init_msg_lst) THEN
132: fnd_msg_pub.initialize;
133: END IF;
134:
135: IF (l_debug = 1) THEN
136: inv_log_util.trace('****** GET_CONSIGNED_QUANTITIES *******','CONSIGNED_VALIDATIONS_GRP',9);
196: WHEN fnd_api.g_exc_error THEN
197: x_return_status := fnd_api.g_ret_sts_error;
198:
199: -- Get message count and data
200: fnd_msg_pub.count_and_get
201: ( p_count => x_msg_count
202: , p_data => x_msg_data
203: );
204:
205: WHEN fnd_api.g_exc_unexpected_error THEN
206: x_return_status := fnd_api.g_ret_sts_unexp_error ;
207:
208: -- Get message count and data
209: fnd_msg_pub.count_and_get
210: ( p_count => x_msg_count
211: , p_data => x_msg_data
212: );
213:
213:
214: WHEN OTHERS THEN
215: x_return_status := fnd_api.g_ret_sts_unexp_error ;
216:
217: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
218: THEN
219: fnd_msg_pub.add_exc_msg
220: ( g_pkg_name
221: , l_api_name
215: x_return_status := fnd_api.g_ret_sts_unexp_error ;
216:
217: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
218: THEN
219: fnd_msg_pub.add_exc_msg
220: ( g_pkg_name
221: , l_api_name
222: );
223: END IF;
222: );
223: END IF;
224:
225: -- Get message count and data
226: fnd_msg_pub.count_and_get
227: ( p_count => x_msg_count
228: , p_data => x_msg_data
229: );
230: END get_consigned_quantity;
303: END IF;
304:
305: -- Initialize message list.
306: IF fnd_api.to_boolean(p_init_msg_lst) THEN
307: fnd_msg_pub.initialize;
308: END IF;
309:
310: IF (l_debug=1) THEN
311: inv_log_util.trace('*** GET_PLANNING_QUANTITY ***','CONSIGNED_VALIDATIONS_GRP',9);
344: WHEN fnd_api.g_exc_error THEN
345: x_return_status := fnd_api.g_ret_sts_error;
346:
347: -- Get message count and data
348: fnd_msg_pub.count_and_get
349: ( p_count => x_msg_count
350: , p_data => x_msg_data
351: );
352:
353: WHEN fnd_api.g_exc_unexpected_error THEN
354: x_return_status := fnd_api.g_ret_sts_unexp_error ;
355:
356: -- Get message count and data
357: fnd_msg_pub.count_and_get
358: ( p_count => x_msg_count
359: , p_data => x_msg_data
360: );
361:
361:
362: WHEN OTHERS THEN
363: x_return_status := fnd_api.g_ret_sts_unexp_error ;
364:
365: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
366: THEN
367: fnd_msg_pub.add_exc_msg
368: ( g_pkg_name
369: , l_api_name
363: x_return_status := fnd_api.g_ret_sts_unexp_error ;
364:
365: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
366: THEN
367: fnd_msg_pub.add_exc_msg
368: ( g_pkg_name
369: , l_api_name
370: );
371: END IF;
370: );
371: END IF;
372:
373: -- Get message count and data
374: fnd_msg_pub.count_and_get
375: ( p_count => x_msg_count
376: , p_data => x_msg_data
377: );
378:
412: END IF;
413:
414: -- Initialize message list.
415: IF fnd_api.to_boolean(p_init_msg_lst) THEN
416: fnd_msg_pub.initialize;
417: END IF;
418:
419: IF (l_debug=1) THEN
420: inv_log_util.trace('*** GET_PLANNING_SD_QUANTITY ***','CONSIGNED_VALIDATIONS_GRP',9);
437: WHEN fnd_api.g_exc_error THEN
438: x_return_status := fnd_api.g_ret_sts_error;
439:
440: -- Get message count and data
441: fnd_msg_pub.count_and_get
442: ( p_count => x_msg_count
443: , p_data => x_msg_data
444: );
445:
446: WHEN fnd_api.g_exc_unexpected_error THEN
447: x_return_status := fnd_api.g_ret_sts_unexp_error ;
448:
449: -- Get message count and data
450: fnd_msg_pub.count_and_get
451: ( p_count => x_msg_count
452: , p_data => x_msg_data
453: );
454:
454:
455: WHEN OTHERS THEN
456: x_return_status := fnd_api.g_ret_sts_unexp_error ;
457:
458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
459: THEN
460: fnd_msg_pub.add_exc_msg
461: ( g_pkg_name
462: , l_api_name
456: x_return_status := fnd_api.g_ret_sts_unexp_error ;
457:
458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
459: THEN
460: fnd_msg_pub.add_exc_msg
461: ( g_pkg_name
462: , l_api_name
463: );
464: END IF;
463: );
464: END IF;
465:
466: -- Get message count and data
467: fnd_msg_pub.count_and_get
468: ( p_count => x_msg_count
469: , p_data => x_msg_data
470: );
471: