DBA Data[Home] [Help]

APPS.GME_RESERVATIONS_PVT dependencies on FND_MSG_PUB

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

138: || ' Error is '
139: || SQLERRM);
140: END IF;
141:
142: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
143: x_return_status := fnd_api.g_ret_sts_unexp_error;
144: x_error_msg := fnd_message.get;
145: END get_reservations_msca;
146:

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

246: || ' Error is '
247: || SQLERRM);
248: END IF;
249:
250: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
251: x_return_status := fnd_api.g_ret_sts_unexp_error;
252: END create_batch_reservations;
253:
254: -- Bug 6437252

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

425: || ' Error is '
426: || SQLERRM);
427: END IF;
428:
429: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
430: x_return_status := fnd_api.g_ret_sts_unexp_error;
431: END create_material_reservation;
432:
433: PROCEDURE get_material_reservations (

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

505: || ' Error is '
506: || SQLERRM);
507: END IF;
508:
509: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
510: x_return_status := fnd_api.g_ret_sts_unexp_error;
511: END get_material_reservations;
512:
513: /* Procedure Added in Bug No.9924437 */

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

595: || ' Error is '
596: || SQLERRM);
597: END IF;
598:
599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
600: x_return_status := fnd_api.g_ret_sts_unexp_error;
601: END get_material_res;
602:
603: PROCEDURE get_MO_allocated_qty (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

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

716: || ' Error is '
717: || SQLERRM);
718: END IF;
719:
720: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
721: x_return_status := fnd_api.g_ret_sts_unexp_error;
722: END get_MO_allocated_qty;
723:
724:

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

778: || ' Error is '
779: || SQLERRM);
780: END IF;
781:
782: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
783: RETURN -1;
784: END reservation_fully_specified;
785:
786: PROCEDURE convert_partial_to_dlr (

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

855: || ' Error is '
856: || SQLERRM);
857: END IF;
858:
859: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
860: x_return_status := fnd_api.g_ret_sts_unexp_error;
861: END convert_partial_to_dlr;
862:
863: PROCEDURE delete_batch_reservations (

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

914: || ' Error is '
915: || SQLERRM);
916: END IF;
917:
918: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
919: x_return_status := fnd_api.g_ret_sts_unexp_error;
920: END delete_batch_reservations;
921:
922: PROCEDURE delete_material_reservations (

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

978: || ' Error is '
979: || SQLERRM);
980: END IF;
981:
982: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984: END delete_material_reservations;
985:
986: PROCEDURE delete_reservation (

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

1046: || ' Error is '
1047: || SQLERRM);
1048: END IF;
1049:
1050: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1051: x_return_status := fnd_api.g_ret_sts_unexp_error;
1052: END delete_reservation;
1053:
1054: PROCEDURE get_reservation_dtl_qty (

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

1123: || ' Error is '
1124: || SQLERRM);
1125: END IF;
1126:
1127: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1128: x_return_status := fnd_api.g_ret_sts_unexp_error;
1129: END get_reservation_dtl_qty;
1130:
1131: -- Bug 12613813 - add p_locator_only parameter so picking can consider locator also.

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

1226: || ' Error is '
1227: || SQLERRM);
1228: END IF;
1229:
1230: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1231: x_return_status := fnd_api.g_ret_sts_unexp_error;
1232: END get_reserved_qty;
1233:
1234: PROCEDURE relieve_reservation (

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

1312: || ' Error is '
1313: || SQLERRM);
1314: END IF;
1315:
1316: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1317: x_return_status := fnd_api.g_ret_sts_unexp_error;
1318: END relieve_reservation;
1319:
1320: /* Pass only values needed to be updated reservation ID is required */

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

1421: || ' Error is '
1422: || SQLERRM);
1423: END IF;
1424:
1425: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1426: x_return_status := fnd_api.g_ret_sts_unexp_error;
1427: END update_reservation;
1428:
1429: /* Pass reservation ID to be queried */

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

1509: || ' Error is '
1510: || SQLERRM);
1511: END IF;
1512:
1513: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1514: x_return_status := fnd_api.g_ret_sts_unexp_error;
1515: END query_reservation;
1516:
1517: FUNCTION pending_reservations_exist (

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

1577: || ' Error is '
1578: || SQLERRM);
1579: END IF;
1580:
1581: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1582: RETURN FALSE;
1583: END pending_reservations_exist;
1584:
1585: PROCEDURE convert_dtl_reservation (

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

2405: || ' Error is '
2406: || SQLERRM);
2407: END IF;
2408:
2409: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2410: x_return_status := fnd_api.g_ret_sts_unexp_error;
2411: END auto_detail_line;
2412:
2413: PROCEDURE auto_detail_batch(p_batch_rec IN GME_BATCH_HEADER%ROWTYPE,

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

2575: WHEN OTHERS THEN
2576: IF g_debug <= gme_debug.g_log_unexpected THEN
2577: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
2578: END IF;
2579: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2581: END auto_detail_batch;
2582:
2583: --Bug#4604943 created the following procedure

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

2659: || ' Error is '
2660: || SQLERRM);
2661: END IF;
2662:
2663: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2664: x_return_status := fnd_api.g_ret_sts_unexp_error;
2665: END validate_mtl_for_reservation;
2666: END gme_reservations_pvt;