DBA Data[Home] [Help]

APPS.GME_API_GRP dependencies on FND_MSG_PUB

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

59: || 'WHEN OTHERS:'
60: || SQLERRM);
61: END IF;
62:
63: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
64: END;
65:
66: PROCEDURE gme_post_process_txns (
67: p_transaction_id IN NUMBER

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

125: || 'WHEN OTHERS:'
126: || SQLERRM);
127: END IF;
128:
129: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
130: END gme_post_process_txns;
131:
132: PROCEDURE update_material_date (
133: p_material_detail_id IN NUMBER

Line 198: fnd_msg_pub.initialize;

194: /* Set the valid status to YES initially */
195: x_valid_status := 'Y';
196:
197: IF p_init_msg_lst = FND_API.G_TRUE THEN
198: fnd_msg_pub.initialize;
199: END IF;
200:
201: IF NOT FND_API.compatible_api_call(1.0, p_api_version_number, 'validate_supply_demand', g_pkg_name ) THEN
202: x_return_status := FND_API.G_RET_STS_ERROR;

Line 438: fnd_msg_pub.initialize;

434: /* Set the return status to success initially */
435: x_return_status := FND_API.G_RET_STS_SUCCESS;
436:
437: IF p_init_msg_lst = FND_API.G_TRUE THEN
438: fnd_msg_pub.initialize;
439: END IF;
440:
441: IF NOT FND_API.compatible_api_call(1.0, p_api_version_number, 'validate_supply_demand', g_pkg_name ) THEN
442: x_return_status := FND_API.G_RET_STS_ERROR;

Line 627: fnd_msg_pub.add_exc_msg ('GME_API_GRP'

623: EXCEPTION
624: WHEN expected_err THEN
625: x_return_status := fnd_api.g_ret_sts_error;
626: WHEN OTHERS THEN
627: fnd_msg_pub.add_exc_msg ('GME_API_GRP'
628: ,'UPDATE_STEP_QUALITY_STATUS');
629: x_return_status := fnd_api.g_ret_sts_unexp_error;
630: END update_step_quality_status;
631:

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

699: END IF;
700: gme_common_pvt.count_and_get (x_count => x_msg_count
701: ,p_encoded => fnd_api.g_false
702: ,x_data => x_msg_data);
703: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
704: END;
705: PROCEDURE get_material_reservations (
706: p_api_version_number IN NUMBER DEFAULT 1.0
707: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

770: END IF;
771: gme_common_pvt.count_and_get (x_count => x_msg_count
772: ,p_encoded => fnd_api.g_false
773: ,x_data => x_msg_data);
774: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
775: END get_material_reservations;
776:
777: PROCEDURE create_lcf_batch (
778: p_api_version IN NUMBER DEFAULT 1.0

Line 809: fnd_msg_pub.initialize;

805: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
806: || l_api_name);
807: END IF;
808: IF p_init_msg_list = fnd_api.g_true THEN
809: fnd_msg_pub.initialize;
810: gme_common_pvt.g_error_count := 0;
811: END IF;
812: /* Make sure we are call compatible */
813: IF NOT fnd_api.compatible_api_call (1

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

892: || 'WHEN OTHERS:'
893: || SQLERRM);
894: END IF;
895:
896: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
897:
898: END create_lcf_batch;
899:
900: FUNCTION get_planning_open_qty (

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

935: RETURN l_open_qty;
936: END IF;
937: EXCEPTION
938: WHEN OTHERS THEN
939: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
940:
941: IF g_debug <= gme_debug.g_log_unexpected THEN
942: gme_debug.put_line ( 'When others exception in '
943: || g_pkg_name

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

1065: ,p_encoded => fnd_api.g_false
1066: ,x_data => l_msg_list);
1067:
1068: WHEN OTHERS THEN
1069: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1070:
1071: IF g_debug <= gme_debug.g_log_unexpected THEN
1072: gme_debug.put_line ( 'When others exception in '
1073: || g_pkg_name

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

2237: ,p_encoded => fnd_api.g_false
2238: ,x_data => x_msg_data);
2239: WHEN OTHERS THEN
2240: x_return_status := fnd_api.g_ret_sts_unexp_error;
2241: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2242: gme_common_pvt.count_and_get
2243: ( x_count => x_msg_count
2244: ,p_encoded => fnd_api.g_false
2245: ,x_data => x_msg_data);

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

2368: ORDER BY mr.requirement_date, mr.reservation_id;
2369: EXCEPTION
2370: WHEN OTHERS THEN
2371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2373: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2374: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2375: END IF;
2376: END get_mat_resvns;

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

2391: ORDER BY sequence asc, lot_number asc;
2392: EXCEPTION
2393: WHEN OTHERS THEN
2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2395: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2396: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2397: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2398: END IF;
2399: END get_mat_pplots;

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

2423: ORDER BY mmt.transaction_id;
2424: EXCEPTION
2425: WHEN OTHERS THEN
2426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2427: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2428: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2429: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2430: END IF;
2431: END get_mat_trans;

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

2445: WHERE transaction_id = p_transaction_id;
2446: EXCEPTION
2447: WHEN OTHERS THEN
2448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2449: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2450: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2451: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2452: END IF;
2453: END get_lot_trans;

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

2496: WHEN create_txn_fail OR validate_txn_fail THEN
2497: x_return_status := l_return_status;
2498: WHEN OTHERS THEN
2499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2500: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2501: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2502: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2503: END IF;
2504: END create_material_txn;

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

2570: WHEN update_txn_fail OR validate_txn_fail THEN
2571: x_return_status := l_return_status;
2572: WHEN OTHERS THEN
2573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2574: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2575: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2576: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2577: END IF;
2578: END update_material_txn;

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

2641: WHEN delete_txn_fail OR get_txn_fail OR const_txn_fail OR validate_txn_fail THEN
2642: x_return_status := l_return_status;
2643: WHEN OTHERS THEN
2644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2645: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2646: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2647: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2648: END IF;
2649: END delete_material_txn;

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

2768: WHEN create_txn_fail OR validate_txn_fail OR error_load_trans OR reduce_pend_usage_err THEN
2769: x_return_status := l_return_status;
2770: WHEN OTHERS THEN
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2773: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2774: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2775: END IF;
2776: END create_resource_txn;

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

2867: WHEN update_txn_fail OR validate_txn_fail OR reduce_pend_usage_err THEN
2868: x_return_status := l_return_status;
2869: WHEN OTHERS THEN
2870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2871: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2872: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2873: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2874: END IF;
2875: END update_resource_txn;

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

2962: WHEN delete_txn_fail OR get_usage_fail OR reduce_pend_usage_err THEN
2963: x_return_status := l_return_status;
2964: WHEN OTHERS THEN
2965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2966: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2967: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2968: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2969: END IF;
2970: END delete_resource_txn;