[Home] [Help]
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
131: || 'WHEN OTHERS:'
132: || SQLERRM);
133: END IF;
134:
135: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
136: END gme_post_process_txns;
137:
138: PROCEDURE update_material_date (
139: p_material_detail_id IN NUMBER
201: /* Set the valid status to YES initially */
202: x_valid_status := 'Y';
203:
204: IF p_init_msg_lst = FND_API.G_TRUE THEN
205: fnd_msg_pub.initialize;
206: END IF;
207:
208: IF NOT FND_API.compatible_api_call(1.0, p_api_version_number, 'validate_supply_demand', g_pkg_name ) THEN
209: x_return_status := FND_API.G_RET_STS_ERROR;
455: /* Set the return status to success initially */
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
457:
458: IF p_init_msg_lst = FND_API.G_TRUE THEN
459: fnd_msg_pub.initialize;
460: END IF;
461:
462: IF NOT FND_API.compatible_api_call(1.0, p_api_version_number, 'validate_supply_demand', g_pkg_name ) THEN
463: x_return_status := FND_API.G_RET_STS_ERROR;
647: EXCEPTION
648: WHEN expected_err THEN
649: x_return_status := fnd_api.g_ret_sts_error;
650: WHEN OTHERS THEN
651: fnd_msg_pub.add_exc_msg ('GME_API_GRP'
652: ,'UPDATE_STEP_QUALITY_STATUS');
653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: END update_step_quality_status;
655:
723: END IF;
724: gme_common_pvt.count_and_get (x_count => x_msg_count
725: ,p_encoded => fnd_api.g_false
726: ,x_data => x_msg_data);
727: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
728: END;
729: PROCEDURE get_material_reservations (
730: p_api_version_number IN NUMBER DEFAULT 1.0
731: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
794: END IF;
795: gme_common_pvt.count_and_get (x_count => x_msg_count
796: ,p_encoded => fnd_api.g_false
797: ,x_data => x_msg_data);
798: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
799: END get_material_reservations;
800:
801: PROCEDURE create_lcf_batch (
802: p_api_version IN NUMBER DEFAULT 1.0
829: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
830: || l_api_name);
831: END IF;
832: IF p_init_msg_list = fnd_api.g_true THEN
833: fnd_msg_pub.initialize;
834: gme_common_pvt.g_error_count := 0;
835: END IF;
836: /* Make sure we are call compatible */
837: IF NOT fnd_api.compatible_api_call (1
916: || 'WHEN OTHERS:'
917: || SQLERRM);
918: END IF;
919:
920: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
921:
922: END create_lcf_batch;
923:
924: FUNCTION get_planning_open_qty (
959: RETURN l_open_qty;
960: END IF;
961: EXCEPTION
962: WHEN OTHERS THEN
963: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
964:
965: IF g_debug <= gme_debug.g_log_unexpected THEN
966: gme_debug.put_line ( 'When others exception in '
967: || g_pkg_name
1089: ,p_encoded => fnd_api.g_false
1090: ,x_data => l_msg_list);
1091:
1092: WHEN OTHERS THEN
1093: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1094:
1095: IF g_debug <= gme_debug.g_log_unexpected THEN
1096: gme_debug.put_line ( 'When others exception in '
1097: || g_pkg_name
2322: ,p_encoded => fnd_api.g_false
2323: ,x_data => x_msg_data);
2324: WHEN OTHERS THEN
2325: x_return_status := fnd_api.g_ret_sts_unexp_error;
2326: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2327: gme_common_pvt.count_and_get
2328: ( x_count => x_msg_count
2329: ,p_encoded => fnd_api.g_false
2330: ,x_data => x_msg_data);
2453: ORDER BY mr.requirement_date, mr.reservation_id;
2454: EXCEPTION
2455: WHEN OTHERS THEN
2456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2457: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2458: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2459: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2460: END IF;
2461: END get_mat_resvns;
2476: ORDER BY sequence asc, lot_number asc;
2477: EXCEPTION
2478: WHEN OTHERS THEN
2479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2480: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2481: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2482: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2483: END IF;
2484: END get_mat_pplots;
2508: ORDER BY mmt.transaction_id;
2509: EXCEPTION
2510: WHEN OTHERS THEN
2511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2512: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2513: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2514: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2515: END IF;
2516: END get_mat_trans;
2530: WHERE transaction_id = p_transaction_id;
2531: EXCEPTION
2532: WHEN OTHERS THEN
2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2534: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2535: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2536: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2537: END IF;
2538: END get_lot_trans;
2581: WHEN create_txn_fail OR validate_txn_fail THEN
2582: x_return_status := l_return_status;
2583: WHEN OTHERS THEN
2584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2585: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2586: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2587: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2588: END IF;
2589: END create_material_txn;
2655: WHEN update_txn_fail OR validate_txn_fail THEN
2656: x_return_status := l_return_status;
2657: WHEN OTHERS THEN
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2660: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2661: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2662: END IF;
2663: END update_material_txn;
2726: WHEN delete_txn_fail OR get_txn_fail OR const_txn_fail OR validate_txn_fail THEN
2727: x_return_status := l_return_status;
2728: WHEN OTHERS THEN
2729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2730: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2731: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2732: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2733: END IF;
2734: END delete_material_txn;
2853: WHEN create_txn_fail OR validate_txn_fail OR error_load_trans OR reduce_pend_usage_err THEN
2854: x_return_status := l_return_status;
2855: WHEN OTHERS THEN
2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2857: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2858: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2859: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2860: END IF;
2861: END create_resource_txn;
2952: WHEN update_txn_fail OR validate_txn_fail OR reduce_pend_usage_err THEN
2953: x_return_status := l_return_status;
2954: WHEN OTHERS THEN
2955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2956: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2957: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2958: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2959: END IF;
2960: END update_resource_txn;
3047: WHEN delete_txn_fail OR get_usage_fail OR reduce_pend_usage_err THEN
3048: x_return_status := l_return_status;
3049: WHEN OTHERS THEN
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3051: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3052: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3053: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
3054: END IF;
3055: END delete_resource_txn;