DBA Data[Home] [Help]

APPS.GME_RESERVATIONS_PVT dependencies on FND_MSG_PUB

Line 85: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

81: || ' Error is '
82: || SQLERRM);
83: END IF;
84:
85: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
86: x_return_status := fnd_api.g_ret_sts_unexp_error;
87: x_error_msg := fnd_message.get;
88: END get_reservations_msca;
89:

Line 193: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

189: || ' Error is '
190: || SQLERRM);
191: END IF;
192:
193: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: END create_batch_reservations;
196:
197: PROCEDURE create_material_reservation (

Line 362: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

358: || ' Error is '
359: || SQLERRM);
360: END IF;
361:
362: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
363: x_return_status := fnd_api.g_ret_sts_unexp_error;
364: END create_material_reservation;
365:
366: PROCEDURE get_material_reservations (

Line 442: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

438: || ' Error is '
439: || SQLERRM);
440: END IF;
441:
442: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
443: x_return_status := fnd_api.g_ret_sts_unexp_error;
444: END get_material_reservations;
445:
446: FUNCTION reservation_fully_specified (

Line 502: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

498: || ' Error is '
499: || SQLERRM);
500: END IF;
501:
502: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
503: RETURN -1;
504: END reservation_fully_specified;
505:
506: PROCEDURE convert_partial_to_dlr (

Line 579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

575: || ' Error is '
576: || SQLERRM);
577: END IF;
578:
579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
580: x_return_status := fnd_api.g_ret_sts_unexp_error;
581: END convert_partial_to_dlr;
582:
583: PROCEDURE delete_batch_reservations (

Line 638: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

634: || ' Error is '
635: || SQLERRM);
636: END IF;
637:
638: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
639: x_return_status := fnd_api.g_ret_sts_unexp_error;
640: END delete_batch_reservations;
641:
642: PROCEDURE delete_material_reservations (

Line 702: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

698: || ' Error is '
699: || SQLERRM);
700: END IF;
701:
702: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
703: x_return_status := fnd_api.g_ret_sts_unexp_error;
704: END delete_material_reservations;
705:
706: PROCEDURE delete_reservation (

Line 770: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

766: || ' Error is '
767: || SQLERRM);
768: END IF;
769:
770: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
771: x_return_status := fnd_api.g_ret_sts_unexp_error;
772: END delete_reservation;
773:
774: PROCEDURE get_reservation_dtl_qty (

Line 847: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

843: || ' Error is '
844: || SQLERRM);
845: END IF;
846:
847: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
848: x_return_status := fnd_api.g_ret_sts_unexp_error;
849: END get_reservation_dtl_qty;
850:
851: PROCEDURE get_reserved_qty (

Line 937: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

933: || ' Error is '
934: || SQLERRM);
935: END IF;
936:
937: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
938: x_return_status := fnd_api.g_ret_sts_unexp_error;
939: END get_reserved_qty;
940:
941: PROCEDURE relieve_reservation (

Line 1023: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1019: || ' Error is '
1020: || SQLERRM);
1021: END IF;
1022:
1023: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1024: x_return_status := fnd_api.g_ret_sts_unexp_error;
1025: END relieve_reservation;
1026:
1027: /* Pass only values needed to be updated reservation ID is required */

Line 1132: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1128: || ' Error is '
1129: || SQLERRM);
1130: END IF;
1131:
1132: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1133: x_return_status := fnd_api.g_ret_sts_unexp_error;
1134: END update_reservation;
1135:
1136: /* Pass reservation ID to be queried */

Line 1220: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1216: || ' Error is '
1217: || SQLERRM);
1218: END IF;
1219:
1220: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1221: x_return_status := fnd_api.g_ret_sts_unexp_error;
1222: END query_reservation;
1223:
1224: FUNCTION pending_reservations_exist (

Line 1288: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1284: || ' Error is '
1285: || SQLERRM);
1286: END IF;
1287:
1288: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1289: RETURN FALSE;
1290: END pending_reservations_exist;
1291:
1292: PROCEDURE convert_dtl_reservation (

Line 2007: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2003: || ' Error is '
2004: || SQLERRM);
2005: END IF;
2006:
2007: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2008: x_return_status := fnd_api.g_ret_sts_unexp_error;
2009: END auto_detail_line;
2010:
2011: PROCEDURE auto_detail_batch(p_batch_rec IN GME_BATCH_HEADER%ROWTYPE,

Line 2102: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2098: WHEN OTHERS THEN
2099: IF g_debug <= gme_debug.g_log_unexpected THEN
2100: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
2101: END IF;
2102: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: END auto_detail_batch;
2105:
2106: --Bug#4604943 created the following procedure

Line 2186: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2182: || ' Error is '
2183: || SQLERRM);
2184: END IF;
2185:
2186: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2187: x_return_status := fnd_api.g_ret_sts_unexp_error;
2188: END validate_mtl_for_reservation;
2189: END gme_reservations_pvt;