DBA Data[Home] [Help]

APPS.WMS_OPP_CYC_COUNT dependencies on FND_MSG_PUB

Line 229: fnd_msg_pub.ADD;

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)

Line 301: fnd_msg_pub.ADD;

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:

Line 324: fnd_msg_pub.ADD;

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:

Line 836: fnd_msg_pub.ADD;

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:

Line 1074: fnd_msg_pub.ADD;

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:

Line 1085: fnd_msg_pub.ADD;

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:

Line 1568: fnd_msg_pub.ADD;

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:

Line 1838: fnd_msg_pub.ADD;

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:

Line 1944: fnd_msg_pub.ADD;

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:

Line 2018: fnd_msg_pub.ADD;

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:

Line 2197: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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);

Line 2206: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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);

Line 2288: fnd_msg_pub.ADD;

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:

Line 2304: fnd_msg_pub.ADD;

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:

Line 2447: fnd_msg_pub.ADD;

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:

Line 2463: fnd_msg_pub.ADD;

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:

Line 2517: fnd_msg_pub.ADD;

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:

Line 2623: fnd_msg_pub.ADD;

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:

Line 2697: fnd_msg_pub.ADD;

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: