225: IF (l_debug = 1) THEN
226: Mdebug(l_api_name||' : '||p_subinventory_code||' is an invalid subinv',g_error);
227: END IF;
228: fnd_message.Set_name('WMS','WMS_CONT_INVALID_SUB');
229: fnd_msg_pub.ADD;
230: RAISE fnd_api.g_exc_error;
231: END IF;
232:
233: SELECT NVL((Trunc(SYSDATE) - Trunc(Max(count_date_current))),l_opp_cyc_count_days)
297: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
298: END IF;
299:
300: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
301: fnd_msg_pub.ADD;
302: RAISE fnd_api.g_exc_error;
303:
304: END IF;
305:
320: Mdebug(l_api_name||' : '||p_subinventory_code||' is an invalid subinv',g_error);
321: END IF;
322:
323: fnd_message.Set_name('WMS','WMS_CONT_INVALID_SUB');
324: fnd_msg_pub.ADD;
325: RAISE fnd_api.g_exc_error;
326:
327: END IF;
328:
832: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
833: END IF;
834:
835: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
836: fnd_msg_pub.ADD;
837: RAISE fnd_api.g_exc_error;
838:
839: END IF;
840:
1070: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
1071: END IF;
1072:
1073: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
1074: fnd_msg_pub.ADD;
1075: RAISE fnd_api.g_exc_error;
1076:
1077: END IF;
1078:
1081: mdebug(l_api_name||' : '||p_organization_id||' is an invalid organization id',g_error);
1082: END IF;
1083:
1084: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ORG');
1085: fnd_msg_pub.ADD;
1086: RAISE fnd_api.g_exc_error;
1087:
1088: END IF;
1089:
1564: mdebug(l_api_name||' : '||p_organization_id||' is an invalid organization id',g_error);
1565: END IF;
1566:
1567: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ORG');
1568: fnd_msg_pub.ADD;
1569: RAISE fnd_api.g_exc_error;
1570:
1571: END IF;
1572:
1834: mdebug(l_api_name||' : '||lpn_contents_cur.inventory_item_id||' is an invalid item',g_error);
1835: END IF;
1836:
1837: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
1838: fnd_msg_pub.ADD;
1839: RAISE fnd_api.g_exc_error;
1840:
1841: END IF;
1842:
1940: mdebug(l_api_name||' : '||lpn_contents_cur.inventory_item_id||' is an invalid item',g_error);
1941: END IF;
1942:
1943: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
1944: fnd_msg_pub.ADD;
1945: RAISE fnd_api.g_exc_error;
1946:
1947: END IF;
1948:
2014: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
2015: END IF;
2016:
2017: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2018: fnd_msg_pub.ADD;
2019: RAISE fnd_api.g_exc_error;
2020:
2021: END IF;
2022:
2193: EXCEPTION
2194: WHEN fnd_api.g_exc_error THEN
2195: x_return_status := fnd_api.g_ret_sts_error;
2196: IF (x_msg_count IS NULL AND x_msg_data IS NULL) THEN
2197: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2198: END IF;
2199: IF (l_debug = 1) THEN
2200: Mdebug(l_api_name||' : l_progress is ' || l_progress);
2201: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM);
2202: END IF;
2203: WHEN OTHERS THEN
2204: x_return_status := fnd_api.g_ret_sts_unexp_error;
2205: IF (x_msg_count IS NULL AND x_msg_data IS NULL) THEN
2206: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2207: END IF;
2208: IF (l_debug = 1) THEN
2209: Mdebug(l_api_name||' : l_progress is ' || l_progress);
2210: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_unexpected_error: ' || SQLERRM);
2284: mdebug(l_api_name||' : '||p_organization_id||' is an invalid organization id',g_error);
2285: END IF;
2286:
2287: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ORG');
2288: fnd_msg_pub.ADD;
2289: RAISE fnd_api.g_exc_error;
2290:
2291: END IF;
2292:
2300: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
2301: END IF;
2302:
2303: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2304: fnd_msg_pub.ADD;
2305: RAISE fnd_api.g_exc_error;
2306:
2307: END IF;
2308:
2443: mdebug(l_api_name||' : '||p_organization_id||' is an invalid organization id',g_error);
2444: END IF;
2445:
2446: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ORG');
2447: fnd_msg_pub.ADD;
2448: RAISE fnd_api.g_exc_error;
2449:
2450: END IF;
2451:
2459: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
2460: END IF;
2461:
2462: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2463: fnd_msg_pub.ADD;
2464: RAISE fnd_api.g_exc_error;
2465:
2466: END IF;
2467:
2513: mdebug(l_api_name||' : '||lpn_contents_cur.inventory_item_id||' is an invalid item',g_error);
2514: END IF;
2515:
2516: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2517: fnd_msg_pub.ADD;
2518: RAISE fnd_api.g_exc_error;
2519:
2520: END IF;
2521:
2619: mdebug(l_api_name||' : '||lpn_contents_cur.inventory_item_id||' is an invalid item',g_error);
2620: END IF;
2621:
2622: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2623: fnd_msg_pub.ADD;
2624: RAISE fnd_api.g_exc_error;
2625:
2626: END IF;
2627:
2693: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
2694: END IF;
2695:
2696: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2697: fnd_msg_pub.ADD;
2698: RAISE fnd_api.g_exc_error;
2699:
2700: END IF;
2701: