eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on FND_API

Line 22: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;

18: g_wms_task_type_putaway NUMBER := wms_globals.g_wms_task_type_putaway;
19: g_wms_task_type_inspect NUMBER := wms_globals.g_wms_task_type_inspect;
20: g_op_drop_lpn_no_lpn NUMBER := wms_globals.g_op_drop_lpn_no_lpn;
21: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
22: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
23: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
24: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
25: g_msg_lvl_unexp_error NUMBER := fnd_msg_pub.g_msg_lvl_unexp_error;
26: g_msg_lvl_error NUMBER := fnd_msg_pub.g_msg_lvl_error;

Line 23: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;

19: g_wms_task_type_inspect NUMBER := wms_globals.g_wms_task_type_inspect;
20: g_op_drop_lpn_no_lpn NUMBER := wms_globals.g_op_drop_lpn_no_lpn;
21: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
22: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
23: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
24: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
25: g_msg_lvl_unexp_error NUMBER := fnd_msg_pub.g_msg_lvl_unexp_error;
26: g_msg_lvl_error NUMBER := fnd_msg_pub.g_msg_lvl_error;
27: g_version_printed BOOLEAN := FALSE;

Line 24: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;

20: g_op_drop_lpn_no_lpn NUMBER := wms_globals.g_op_drop_lpn_no_lpn;
21: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
22: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
23: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
24: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
25: g_msg_lvl_unexp_error NUMBER := fnd_msg_pub.g_msg_lvl_unexp_error;
26: g_msg_lvl_error NUMBER := fnd_msg_pub.g_msg_lvl_error;
27: g_version_printed BOOLEAN := FALSE;
28: g_pkg_name VARCHAR2(30) := 'WMS_ATF_RUNTIME_PUB_APIS';

Line 181: --RAISE FND_API.G_EXC_ERROR;

177: END IF;
178:
179: /*Raise Invalid Arguement exception*/
180: --x_error_code:=1;
181: --RAISE FND_API.G_EXC_ERROR;
182: raise_application_error(INVALID_INPUT,'Invalid inputs passed'||p_source_task_id||' '||p_activity_id);
183:
184: END IF;
185:

Line 212: --RAISE FND_API.G_EXC_ERROR;

208: print_debug('Invalid document',l_module_name,3);
209: END IF;
210:
211: --x_error_code:=2;
212: --RAISE FND_API.G_EXC_ERROR;
213: CLOSE inbound_document_details;
214:
215: raise_application_error(INVALID_DOC_ID,'Invalid Document');
216: END IF;

Line 245: --RAISE FND_API.G_EXC_ERROR;

241: print_debug('Operation Plan Id is null and unforgivable error',l_module_name,1);
242: END IF;
243:
244: --x_error_code:=3;
245: --RAISE FND_API.G_EXC_ERROR;
246: raise_application_error(INVALID_PLAN_ID, 'Invalid Plan');
247: /*Raise user defined exception to populated error code*/
248:
249: END IF;

Line 275: --RAISE FND_API.G_EXC_ERROR;

271: IF (l_debug=1) THEN
272: print_debug('Invalid operation Plan stamped on document',l_module_name,3);
273: END IF;
274: --x_error_code:=4;
275: --RAISE FND_API.G_EXC_ERROR;
276: CLOSE c_operation_plan;
277: raise_application_error(INVALID_PLAN_ID, 'Invalid Plan');
278:
279: END IF;

Line 296: --RAISE FND_API.G_EXC_ERROR;

292: IF (l_debug=1) THEN
293: print_debug('Invalid operation Plan stamped on document',l_module_name,3);
294: END IF;
295: --x_error_code:=4;
296: --RAISE FND_API.G_EXC_ERROR;
297: CLOSE c_plan_detail;
298: raise_application_error(INVALID_PLAN_ID,'Invalid Plan');
299:
300: END IF;

Line 321: --RAISE FND_API.G_EXC_ERROR;

317: IF (l_debug=1) THEN
318: print_debug('Plan instance already exists for Plan instance and src task id',l_module_name,1);
319: END IF;
320:
321: --RAISE FND_API.G_EXC_ERROR;
322: CLOSE c_plan_instance_exists;
323:
324: raise_application_error(PLAN_INSTANCE_EXISTS,'Plan Instance already exists');
325:

Line 460: RAISE FND_API.G_EXC_ERROR;

456: IF (x_return_status=g_ret_sts_error) THEN
457: IF (l_debug=1) THEN
458: print_debug('Error returned from doc handlers with err code'||x_error_code,l_module_name,9);
459: END IF;
460: RAISE FND_API.G_EXC_ERROR;
461:
462:
463: ELSIF (x_return_status<>g_ret_sts_success) THEN
464:

Line 468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

464:
465: IF (l_debug=1) THEN
466: print_debug('unexpected error from doc handler',l_module_name,9);
467: END IF;
468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
469:
470: END IF;
471:
472: IF (l_debug=1) THEN

Line 547: RAISE FND_API.G_EXC_ERROR;

543: print_debug('Return Status from table handler',l_module_name,9);
544: END IF;
545:
546: IF (x_return_status=g_ret_sts_error) THEN
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF (x_return_status<>g_ret_sts_success) THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: END IF;
551:

Line 549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

545:
546: IF (x_return_status=g_ret_sts_error) THEN
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF (x_return_status<>g_ret_sts_success) THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: END IF;
551:
552: /*Create WMS_OP_OPERATION_INSTANCES (WOOI) PL/SQL record for the first operation.,
553: with proper operation_type_ID, source_task_ID (ID which is returned by the document hanlder),

Line 606: RAISE FND_API.G_EXC_ERROR;

602: print_debug('Return Status from table handler',l_module_name,9);
603: END IF;
604:
605: IF (x_return_status=g_ret_sts_error) THEN
606: RAISE FND_API.G_EXC_ERROR;
607: ELSIF (x_return_status<>g_ret_sts_success) THEN
608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
609: END IF;
610:

Line 608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

604:
605: IF (x_return_status=g_ret_sts_error) THEN
606: RAISE FND_API.G_EXC_ERROR;
607: ELSIF (x_return_status<>g_ret_sts_success) THEN
608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
609: END IF;
610:
611:
612:

Line 615: WHEN FND_API.G_EXC_ERROR THEN

611:
612:
613: EXCEPTION
614:
615: WHEN FND_API.G_EXC_ERROR THEN
616: IF (l_debug=1) THEN
617: print_debug('Expected Error Obtained at'||l_progress,l_module_name,1);
618: END IF;
619: IF (inbound_document_details%ISOPEN) THEN

Line 643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

639: ROLLBACK TO init_plan_sp;
640:
641: x_return_status:=g_ret_sts_error;
642:
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: IF (l_debug=1) THEN
645: print_debug('UnExpected Error Obtained at'||l_progress||SQLERRM,l_module_name,1);
646: END IF;
647: IF (inbound_document_details%ISOPEN) THEN

Line 1000: RAISE FND_API.G_EXC_ERROR;

996: fnd_message.set_name('WMS', 'DERIVE_DEST_SUGGESTIONS_FAILED');
997: fnd_message.set_token('OPERATION_PLAN_NAME', l_operation_plan_name);
998: fnd_msg_pub.ADD;
999:
1000: RAISE FND_API.G_EXC_ERROR;
1001:
1002: END IF;
1003:
1004: IF l_attributes.sug_location_id IS NULL THEN

Line 1023: RAISE FND_API.G_EXC_ERROR;

1019: fnd_message.set_name('WMS', 'DERIVE_DEST_SUGGESTIONS_FAILED');
1020: fnd_message.set_token('OPERATION_PLAN_NAME', l_operation_plan_name);
1021: fnd_msg_pub.ADD;
1022:
1023: RAISE FND_API.G_EXC_ERROR;
1024:
1025: END IF;
1026:
1027: l_validate_loc := TRUE;

Line 1056: RAISE FND_API.G_EXC_ERROR;

1052: WHEN OTHERS THEN
1053: IF (l_debug = 1) THEN
1054: print_debug('Error retrievine info from outbound plan',l_module_name,1);
1055: END IF;
1056: RAISE FND_API.G_EXC_ERROR;
1057: END ;
1058:
1059: IF (l_debug = 1) THEN
1060: print_debug('l_consolidation_method_id =>'||l_consolidation_method_id,l_module_name,4);

Line 1070: RAISE fnd_api.g_exc_error;

1066: IF (l_xd_loc_selection_criteria = wms_globals.g_op_dest_sys_suggested) THEN --4
1067: IF (l_debug = 1) THEN
1068: print_debug('Outbound plan should not have this value.',l_module_name,4);
1069: END IF;
1070: RAISE fnd_api.g_exc_error;
1071: ELSIF (l_xd_loc_selection_criteria = wms_globals.g_op_dest_api) THEN --2
1072: IF (l_xd_loc_selection_api_id = 1) THEN--Consolidation Lane
1073:
1074: --If it is consolidation based in consolidation loc, always treat

Line 1123: RAISE fnd_api.g_exc_error;

1119: IF l_return_status = 'W' THEN
1120: x_return_status := l_return_status;
1121: x_msg_data := l_msg_data;
1122: ELSE
1123: RAISE fnd_api.g_exc_error;
1124: END IF;
1125:
1126: END IF;
1127: ELSE --l_task_drop_loc_rec.loc_selection_api_id = 1 (Staging Lane)

Line 1191: RAISE fnd_api.g_exc_error;

1187: IF (l_debug = 1) THEN
1188: print_debug('Failed calling wms_mdc_pvt.suggest_to_lpn.',l_module_name, 4);
1189: END IF;
1190:
1191: RAISE fnd_api.g_exc_error;
1192: END IF;
1193: END IF; --END IF (l_mol_count = 1)
1194:
1195: IF (l_consolidation_method_id = 2 OR

Line 1240: RAISE fnd_api.g_exc_error;

1236: IF l_return_status = 'W' THEN
1237: x_return_status := l_return_status;
1238: x_msg_data := l_msg_data;
1239: ELSE
1240: RAISE fnd_api.g_exc_error;
1241: END IF;
1242:
1243: END IF;
1244: END IF; --END IF (l_consolidation_method_id = 2 OR

Line 1302: RAISE FND_API.G_EXC_ERROR;

1298: print_debug('Invalid Selection critiera value '||
1299: l_plan_details.loc_selection_criteria, l_module_name, 1);
1300: END IF;
1301:
1302: RAISE FND_API.G_EXC_ERROR;
1303:
1304: END IF; /* l_plan_details.sug_loca.... */
1305:
1306: IF l_validate_loc THEN

Line 1355: RAISE fnd_api.g_exc_error;

1351: fnd_msg_pub.ADD;
1352:
1353: CLOSE c_item_sub;
1354:
1355: RAISE fnd_api.g_exc_error;
1356:
1357: END IF;
1358:
1359: CLOSE c_item_sub;

Line 1383: RAISE fnd_api.g_exc_error;

1379:
1380: fnd_message.set_name('WMS','WMS_ATF_ITEM_SUBLOC_FAIL');
1381: fnd_msg_pub.ADD;
1382:
1383: RAISE fnd_api.g_exc_error;
1384:
1385: END IF;
1386:
1387: END IF;

Line 1487: RAISE FND_API.G_EXC_ERROR;

1483: IF (l_debug = 1) THEN
1484: print_debug('wms_atf_dest_lpn.get_dest_lpn: l_return_status = '|| l_return_status, l_module_name, 4);
1485: END IF;
1486:
1487: RAISE FND_API.G_EXC_ERROR;
1488:
1489: END IF;
1490:
1491: ELSIF l_plan_details.operation_type = g_op_type_crossdock AND

Line 1545: RAISE FND_API.G_EXC_ERROR;

1541: IF (l_debug = 1) THEN
1542: print_debug('wms_atf_dest_lpn.get_dest_lpn: l_return_status = '|| l_return_status, l_module_name, 4);
1543: END IF;
1544:
1545: RAISE FND_API.G_EXC_ERROR;
1546:
1547: END IF;
1548:
1549: END IF; -- (x_consolidation_method_id = 2) T

Line 1565: RAISE FND_API.G_EXC_ERROR;

1561: print_debug('Invalid LPN Selection critiera value '||
1562: l_plan_details.lpn_selection_criteria, l_module_name, 1);
1563: END IF;
1564:
1565: RAISE FND_API.G_EXC_ERROR;
1566:
1567: END IF; /* lpn_selection...*/
1568:
1569:

Line 1588: WHEN FND_API.G_EXC_ERROR THEN

1584: --x_return_status := g_ret_sts_success;
1585:
1586: EXCEPTION
1587:
1588: WHEN FND_API.G_EXC_ERROR THEN
1589: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
1590:
1591: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
1592: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

Line 1796: --RAISE FND_API.G_EXC_ERROR;

1792: END IF;
1793:
1794: /*Raise Invalid Arguement exception*/
1795: --x_error_code:=1;
1796: --RAISE FND_API.G_EXC_ERROR;
1797: raise_application_error(INVALID_INPUT,'Invalid inputs passed'||p_source_task_id||' '||p_activity_id);
1798:
1799: END IF;
1800:

Line 1809: --RAISE FND_API.G_EXC_ERROR;

1805: END IF;
1806:
1807: /*Raise Invalid Arguement exception*/
1808: --x_error_code:=1;
1809: --RAISE FND_API.G_EXC_ERROR;
1810: raise_application_error(INVALID_INPUT,'Invalid inputs passed'||p_source_task_id||' '||p_activity_id);
1811: END IF;
1812:
1813: IF (p_activity_id =G_OP_ACTIVITY_INBOUND) THEN

Line 1950: RAISE FND_API.G_EXC_ERROR;

1946: END IF;
1947:
1948: CLOSE c_inbound_doc;
1949:
1950: RAISE FND_API.G_EXC_ERROR;
1951:
1952: END IF;
1953:
1954: CLOSE c_inbound_doc;

Line 2039: RAISE FND_API.G_EXC_ERROR;

2035: IF (l_debug=1) THEN
2036: print_debug('Expected error from table handler',l_module_name,1);
2037: END IF;
2038:
2039: RAISE FND_API.G_EXC_ERROR;
2040:
2041: ELSIF (x_return_status<>g_ret_sts_success) THEN
2042: IF (l_debug=1) THEN
2043: print_debug('Unexpected error fromt table hander',l_module_name,1);

Line 2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2041: ELSIF (x_return_status<>g_ret_sts_success) THEN
2042: IF (l_debug=1) THEN
2043: print_debug('Unexpected error fromt table hander',l_module_name,1);
2044: END IF;
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046:
2047: END IF;
2048:
2049: END IF; /*WDT Record to be inserted*/

Line 2079: RAISE FND_API.G_EXC_ERROR;

2075: END IF;
2076:
2077: CLOSE c_operation_instance_details;
2078:
2079: RAISE FND_API.G_EXC_ERROR;
2080:
2081: END IF;
2082: CLOSE c_operation_instance_details;
2083:

Line 2177: RAISE FND_API.G_EXC_ERROR;

2173: IF (l_debug=1) THEN
2174: print_debug('Expected error from table handler',l_module_name,1);
2175: END IF;
2176:
2177: RAISE FND_API.G_EXC_ERROR;
2178:
2179: ELSIF (x_return_status<>g_ret_sts_success) THEN
2180: IF (l_debug=1) THEN
2181: print_debug('Unexpected error fromt table hander',l_module_name,1);

Line 2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2179: ELSIF (x_return_status<>g_ret_sts_success) THEN
2180: IF (l_debug=1) THEN
2181: print_debug('Unexpected error fromt table hander',l_module_name,1);
2182: END IF;
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184:
2185: END IF;
2186:
2187: END IF; /*WDT Record to be inserted*/

Line 2224: RAISE FND_API.G_EXC_ERROR;

2220: IF (x_return_status=g_ret_sts_error) THEN
2221: IF (l_debug=1) THEN
2222: print_debug('Error Obtained from Abort_operation_plan',l_module_name,1);
2223: END IF;
2224: RAISE FND_API.G_EXC_ERROR;
2225:
2226: ELSIF (x_return_status=g_ret_sts_unexp_error) THEN
2227:
2228: IF (l_debug=1) THEN

Line 2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2227:
2228: IF (l_debug=1) THEN
2229: print_debug('Error Obtained from Abort_operation_plan',l_module_name,1);
2230: END IF;
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2232: ELSE
2233: /*Return status from Abort is sucess.REturn from here*/
2234: RETURN;
2235:

Line 2309: RAISE FND_API.G_EXC_ERROR;

2305: print_debug('Return status from table hanlder'||x_return_status,l_module_name,9);
2306: END IF;
2307:
2308: IF (x_return_status=g_ret_sts_error) THEN
2309: RAISE FND_API.G_EXC_ERROR;
2310: ELSIF (x_return_status<>g_ret_sts_success) THEN
2311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2312: END IF;
2313:

Line 2311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2307:
2308: IF (x_return_status=g_ret_sts_error) THEN
2309: RAISE FND_API.G_EXC_ERROR;
2310: ELSIF (x_return_status<>g_ret_sts_success) THEN
2311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2312: END IF;
2313:
2314: END IF;/*Count=1*/
2315:

Line 2357: RAISE FND_API.G_EXC_ERROR;

2353: IF (x_return_status=g_ret_sts_error) THEN
2354: IF (l_debug=1) THEN
2355: print_debug('Error obtained and hence raising exception',l_module_name,1);
2356: END IF;
2357: RAISE FND_API.G_EXC_ERROR;
2358:
2359: ELSIF (x_return_status=g_ret_sts_unexp_error) THEN
2360: IF (l_debug=1) THEN
2361: print_debug('Unexpected error obtained ',l_module_name,1);

Line 2363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2359: ELSIF (x_return_status=g_ret_sts_unexp_error) THEN
2360: IF (l_debug=1) THEN
2361: print_debug('Unexpected error obtained ',l_module_name,1);
2362: END IF;
2363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2364:
2365: END IF;
2366:
2367: IF (l_debug=1) THEN

Line 2410: RAISE FND_API.G_EXC_ERROR;

2406: print_debug('Return status from document handler'||l_return_status,l_module_name,9);
2407: END IF;
2408:
2409: IF (l_return_status=g_ret_sts_error) THEN
2410: RAISE FND_API.G_EXC_ERROR;
2411: ELSIF (l_return_status<>g_ret_sts_success) THEN
2412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2413: END IF;
2414:

Line 2412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2408:
2409: IF (l_return_status=g_ret_sts_error) THEN
2410: RAISE FND_API.G_EXC_ERROR;
2411: ELSIF (l_return_status<>g_ret_sts_success) THEN
2412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2413: END IF;
2414:
2415: l_progress:=230;
2416:

Line 2436: RAISE FND_API.G_EXC_ERROR;

2432: print_debug('Return status from table hanlder'||l_return_status,l_module_name,9);
2433: END IF;
2434:
2435: IF (l_return_status=g_ret_sts_error) THEN
2436: RAISE FND_API.G_EXC_ERROR;
2437: ELSIF (l_return_status<>g_ret_sts_success) THEN
2438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2439: END IF;
2440:

Line 2438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2434:
2435: IF (l_return_status=g_ret_sts_error) THEN
2436: RAISE FND_API.G_EXC_ERROR;
2437: ELSIF (l_return_status<>g_ret_sts_success) THEN
2438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2439: END IF;
2440:
2441: l_progress:=250;
2442:

Line 2446: WHEN FND_API.G_EXC_ERROR THEN

2442:
2443:
2444: EXCEPTION
2445:
2446: WHEN FND_API.G_EXC_ERROR THEN
2447: IF (l_debug=1) THEN
2448: print_debug('Expected Error at '||l_progress, l_module_name,1);
2449: END IF;
2450:

Line 2672: RAISE FND_API.G_EXC_ERROR;

2668: IF p_source_task_id IS NULL THEN
2669: IF (l_debug=1) THEN
2670: print_debug('Invalid input param. p_source_task_id Cannot be NULL.',l_module_name,4);
2671: END IF;
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674:
2675:
2676: IF p_activity_id IS NULL THEN

Line 2680: RAISE FND_API.G_EXC_ERROR;

2676: IF p_activity_id IS NULL THEN
2677: IF (l_debug=1) THEN
2678: print_debug('Invalid input param. p_activity_id Cannot be NULL.',l_module_name,4);
2679: END IF;
2680: RAISE FND_API.G_EXC_ERROR;
2681: END IF;
2682:
2683: IF p_operation_type_id IS NOT NULL AND
2684: p_operation_type_id NOT IN (g_op_type_drop, g_op_type_load, g_op_type_inspect)THEN

Line 2688: RAISE FND_API.G_EXC_ERROR;

2684: p_operation_type_id NOT IN (g_op_type_drop, g_op_type_load, g_op_type_inspect)THEN
2685: IF (l_debug=1) THEN
2686: print_debug('Invalid input param. p_operation_type_id can only be load, drop, inspect or NULL.',l_module_name,4);
2687: END IF;
2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;
2690:
2691: l_operation_type_id := p_operation_type_id;
2692:

Line 2709: RAISE FND_API.G_EXC_ERROR;

2705: IF c_inbound_document_details%notfound THEN
2706: IF (l_debug=1) THEN
2707: print_debug('Invalid input param. p_source_task_id does not match to an MMTT record.',l_module_name,4);
2708: END IF;
2709: RAISE FND_API.G_EXC_ERROR;
2710: END IF;
2711:
2712: CLOSE c_inbound_document_details;
2713:

Line 2773: RAISE FND_API.G_EXC_ERROR;

2769: print_debug('Operation instance record does not exist for this task.',l_module_name,4);
2770: END IF;
2771: fnd_message.set_name('WMS', 'WMS_ATF_NO_ACTIVE_PLAN');
2772: fnd_msg_pub.ADD;
2773: RAISE FND_API.G_EXC_ERROR;
2774: END IF;
2775:
2776: CLOSE c_wooi_data_rec;
2777:

Line 2826: RAISE FND_API.G_EXC_ERROR;

2822: WHEN no_data_found THEN
2823: IF (l_debug=1) THEN
2824: print_debug('WDT does not exist for this MMTT.',l_module_name,4);
2825: END IF;
2826: RAISE FND_API.G_EXC_ERROR;
2827:
2828: END;
2829:
2830: l_progress := 30;

Line 2843: RAISE FND_API.G_EXC_ERROR;

2839: print_debug('Invalid WDT status.' ,l_module_name,4);
2840: END IF;
2841: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
2842: fnd_msg_pub.ADD;
2843: RAISE FND_API.G_EXC_ERROR;
2844: END IF; -- IF l_wdt_status NOT IN (g_task_status_loaded, g_task_status_dispatched)
2845:
2846: END IF; -- IF p_activity_id = g_op_activity_inbound
2847:

Line 2907: IF l_return_status <>FND_API.g_ret_sts_success THEN

2903: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2904: END IF;
2905:
2906:
2907: IF l_return_status <>FND_API.g_ret_sts_success THEN
2908: IF (l_debug=1) THEN
2909: print_debug('wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2910: END IF;
2911: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');

Line 2913: RAISE FND_API.G_EXC_ERROR;

2909: print_debug('wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2910: END IF;
2911: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
2912: fnd_msg_pub.ADD;
2913: RAISE FND_API.G_EXC_ERROR;
2914: END IF;
2915:
2916: ELSIF p_operation_type_id IS NULL OR p_operation_type_id = g_op_type_load THEN
2917: IF (l_debug=1) THEN

Line 2947: RAISE FND_API.G_EXC_ERROR;

2943: print_debug('Current operation ('|| p_operation_type_id ||') is not compatible with WDT status of dispatched.' ,l_module_name,4);
2944: END IF;
2945: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
2946: fnd_msg_pub.ADD;
2947: RAISE FND_API.G_EXC_ERROR;
2948:
2949: END IF; -- IF p_operation_type_id = g_op_type_inspect
2950:
2951:

Line 2996: IF l_return_status <>FND_API.g_ret_sts_success THEN

2992: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2993: END IF;
2994:
2995:
2996: IF l_return_status <>FND_API.g_ret_sts_success THEN
2997: IF (l_debug=1) THEN
2998: print_debug('Drop - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2999: END IF;
3000: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');

Line 3002: RAISE FND_API.G_EXC_ERROR;

2998: print_debug('Drop - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2999: END IF;
3000: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
3001: fnd_msg_pub.ADD;
3002: RAISE FND_API.G_EXC_ERROR;
3003: END IF;
3004:
3005: ELSE -- l_wdt_status = g_task_status_dispatched (not dispatched or loaded)
3006:

Line 3012: RAISE FND_API.G_EXC_ERROR;

3008: print_debug('Invalid WDT status.' ,l_module_name,4);
3009: END IF;
3010: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
3011: fnd_msg_pub.ADD;
3012: RAISE FND_API.G_EXC_ERROR;
3013:
3014:
3015: END IF; -- IF l_wdt_status = g_task_status_dispatched
3016:

Line 3079: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3075: print_debug('x_source_task_id => '||l_new_mmtt_id, l_module_name,4);
3076: print_debug('x_error_code => '||l_atf_error_code, l_module_name,4);
3077: END IF;
3078: --bug 6924639
3079: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3080: IF (l_debug = 1) THEN
3081: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3082: END IF;
3083:

Line 3086: RAISE fnd_api.g_exc_unexpected_error;

3082: END IF;
3083:
3084: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3085: fnd_msg_pub.ADD;
3086: RAISE fnd_api.g_exc_unexpected_error;
3087: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3088: IF (l_debug = 1) THEN
3089: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3090: END IF;

Line 3087: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

3083:
3084: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3085: fnd_msg_pub.ADD;
3086: RAISE fnd_api.g_exc_unexpected_error;
3087: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3088: IF (l_debug = 1) THEN
3089: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3090: END IF;
3091:

Line 3094: RAISE fnd_api.g_exc_error;

3090: END IF;
3091:
3092: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3093: fnd_msg_pub.ADD;
3094: RAISE fnd_api.g_exc_error;
3095: END IF;
3096: --bug 6924639
3097: /*
3098: IF l_return_status <>FND_API.g_ret_sts_success THEN

Line 3098: IF l_return_status <>FND_API.g_ret_sts_success THEN

3094: RAISE fnd_api.g_exc_error;
3095: END IF;
3096: --bug 6924639
3097: /*
3098: IF l_return_status <>FND_API.g_ret_sts_success THEN
3099: IF (l_debug=1) THEN
3100: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3101: END IF;
3102:

Line 3103: RAISE FND_API.G_EXC_ERROR;

3099: IF (l_debug=1) THEN
3100: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3101: END IF;
3102:
3103: RAISE FND_API.G_EXC_ERROR;
3104: END IF;
3105: */
3106: END IF; -- IF l_operation_type_id IN (g_op_type_drop, g_op_type_inspect)
3107: IF (l_debug=1) THEN

Line 3130: RAISE FND_API.G_EXC_ERROR;

3126: print_debug('Operation type on operation instance : '||l_wooi_data_rec.operation_type_id||' does not match that passed in by user : '||l_operation_type_id, l_module_name,4);
3127: END IF;
3128: fnd_message.set_name('WMS', 'WMS_ATF_OPERATION_MISMATCH');
3129: fnd_msg_pub.ADD;
3130: RAISE FND_API.G_EXC_ERROR;
3131: END IF;
3132:
3133: IF (l_debug=1) THEN
3134: print_debug('Get MAX operation_sequence for the operation plan for detail ID: '||l_wooi_data_rec.operation_plan_detail_id,l_module_name,4);

Line 3157: RAISE FND_API.G_EXC_ERROR;

3153: IF (l_debug=1) THEN
3154: print_debug('Exception when getting max operation_sequence.' ,l_module_name,4);
3155: END IF;
3156:
3157: RAISE FND_API.G_EXC_ERROR;
3158: END;
3159:
3160:
3161: IF (l_debug=1) THEN

Line 3292: RAISE FND_API.G_EXC_ERROR;

3288: IF (l_debug = 1) THEN
3289: print_debug('wms_atf_dest_locator.get_dest_locator failed: l_return_status = '|| l_return_status, l_module_name, 4);
3290: END IF;
3291:
3292: RAISE FND_API.G_EXC_ERROR;
3293:
3294: END IF;
3295: */
3296: IF l_valid_flag = 'E' THEN

Line 3312: RAISE FND_API.G_EXC_ERROR;

3308: print_debug('Invalid locator determination method.',l_module_name,4);
3309: END IF;
3310: fnd_message.set_name('WMS', 'WMS_ATF_LOC_DET_NOT_DEFINED');
3311: fnd_msg_pub.ADD;
3312: RAISE FND_API.G_EXC_ERROR;
3313:
3314: END IF; -- IF NVL(l_loc_sel_criteria_id, 0) = wms_globals.G_OP_DEST_PRE_SPECIFIED
3315:
3316: END IF; -- IF l_wooi_data_rec.sug_to_locator_id <> Nvl(l_mmtt_rec.transfer_to_location

Line 3345: IF l_return_status <>FND_API.g_ret_sts_success THEN

3341: print_debug('x_msg_count => '||l_msg_count,l_module_name,9);
3342: print_debug('x_error_code => '||l_atf_error_code,l_module_name,9);
3343: END IF;
3344:
3345: IF l_return_status <>FND_API.g_ret_sts_success THEN
3346: IF (l_debug=1) THEN
3347: print_debug('wms_atf_runtime_pub_apis.abort_operation_plan finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3348: END IF;
3349:

Line 3350: RAISE FND_API.G_EXC_ERROR;

3346: IF (l_debug=1) THEN
3347: print_debug('wms_atf_runtime_pub_apis.abort_operation_plan finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3348: END IF;
3349:
3350: RAISE FND_API.G_EXC_ERROR;
3351: END IF;
3352:
3353:
3354: IF (l_debug=1) THEN

Line 3393: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3389: print_debug('x_source_task_id => '||l_new_mmtt_id, l_module_name,4);
3390: print_debug('x_error_code => '||l_atf_error_code, l_module_name,4);
3391: END IF;
3392: --bug 6924639
3393: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3394: IF (l_debug = 1) THEN
3395: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3396: END IF;
3397:

Line 3400: RAISE fnd_api.g_exc_unexpected_error;

3396: END IF;
3397:
3398: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3399: fnd_msg_pub.ADD;
3400: RAISE fnd_api.g_exc_unexpected_error;
3401: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3402: IF (l_debug = 1) THEN
3403: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3404: END IF;

Line 3401: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

3397:
3398: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3399: fnd_msg_pub.ADD;
3400: RAISE fnd_api.g_exc_unexpected_error;
3401: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3402: IF (l_debug = 1) THEN
3403: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3404: END IF;
3405:

Line 3408: RAISE fnd_api.g_exc_error;

3404: END IF;
3405:
3406: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3407: fnd_msg_pub.ADD;
3408: RAISE fnd_api.g_exc_error;
3409: END IF;
3410: --bug 6924639
3411: /*
3412: IF l_return_status <>FND_API.g_ret_sts_success THEN

Line 3412: IF l_return_status <>FND_API.g_ret_sts_success THEN

3408: RAISE fnd_api.g_exc_error;
3409: END IF;
3410: --bug 6924639
3411: /*
3412: IF l_return_status <>FND_API.g_ret_sts_success THEN
3413: IF (l_debug=1) THEN
3414: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3415: END IF;
3416:

Line 3417: RAISE FND_API.G_EXC_ERROR;

3413: IF (l_debug=1) THEN
3414: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3415: END IF;
3416:
3417: RAISE FND_API.G_EXC_ERROR;
3418: END IF;
3419: */
3420:
3421: IF c_inbound_document_details%isopen THEN

Line 3499: IF l_return_status <>FND_API.g_ret_sts_success THEN

3495: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
3496: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
3497: END IF;
3498:
3499: IF l_return_status <>FND_API.g_ret_sts_success THEN
3500: IF (l_debug=1) THEN
3501: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3502: END IF;
3503:

Line 3504: RAISE FND_API.G_EXC_ERROR;

3500: IF (l_debug=1) THEN
3501: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3502: END IF;
3503:
3504: RAISE FND_API.G_EXC_ERROR;
3505: END IF;
3506:
3507:
3508: -- Handle situation where current operation is the last step in the plan.

Line 3546: IF l_return_status <>FND_API.g_ret_sts_success THEN

3542: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
3543:
3544: END IF;
3545:
3546: IF l_return_status <>FND_API.g_ret_sts_success THEN
3547: IF (l_debug=1) THEN
3548: print_debug('Last operation: archive parent MMTT - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3549: END IF;
3550: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');

Line 3552: RAISE FND_API.G_EXC_ERROR;

3548: print_debug('Last operation: archive parent MMTT - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3549: END IF;
3550: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
3551: fnd_msg_pub.ADD;
3552: RAISE FND_API.G_EXC_ERROR;
3553: END IF;
3554:
3555: IF (l_debug=1) THEN
3556: print_debug('Before calling wms_op_runtime_pvt_apis.complete_plan_instance with following parameters:', l_module_name,4);

Line 3580: IF l_return_status <>FND_API.g_ret_sts_success THEN

3576: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3577: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);
3578: END IF;
3579:
3580: IF l_return_status <>FND_API.g_ret_sts_success THEN
3581: IF (l_debug=1) THEN
3582: print_debug('wms_op_runtime_pvt_apis.complete_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3583: END IF;
3584:

Line 3585: RAISE FND_API.G_EXC_ERROR;

3581: IF (l_debug=1) THEN
3582: print_debug('wms_op_runtime_pvt_apis.complete_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3583: END IF;
3584:
3585: RAISE FND_API.G_EXC_ERROR;
3586: END IF;
3587:
3588:
3589:

Line 3636: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3632: print_debug('x_source_task_id => '||l_new_mmtt_id, l_module_name,4);
3633: print_debug('x_error_code => '||l_atf_error_code, l_module_name,4);
3634: END IF;
3635: --bug 6924639
3636: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3637: IF (l_debug = 1) THEN
3638: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3639: END IF;
3640:

Line 3643: RAISE fnd_api.g_exc_unexpected_error;

3639: END IF;
3640:
3641: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3642: fnd_msg_pub.ADD;
3643: RAISE fnd_api.g_exc_unexpected_error;
3644: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3645: IF (l_debug = 1) THEN
3646: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3647: END IF;

Line 3644: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

3640:
3641: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3642: fnd_msg_pub.ADD;
3643: RAISE fnd_api.g_exc_unexpected_error;
3644: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3645: IF (l_debug = 1) THEN
3646: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3647: END IF;
3648:

Line 3651: RAISE fnd_api.g_exc_error;

3647: END IF;
3648:
3649: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3650: fnd_msg_pub.ADD;
3651: RAISE fnd_api.g_exc_error;
3652: END IF;
3653: --bug 6924639
3654: /*
3655: IF l_return_status <>FND_API.g_ret_sts_success THEN

Line 3655: IF l_return_status <>FND_API.g_ret_sts_success THEN

3651: RAISE fnd_api.g_exc_error;
3652: END IF;
3653: --bug 6924639
3654: /*
3655: IF l_return_status <>FND_API.g_ret_sts_success THEN
3656: IF (l_debug=1) THEN
3657: print_debug('Last operation in plan - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3658: END IF;
3659:

Line 3660: RAISE FND_API.G_EXC_ERROR;

3656: IF (l_debug=1) THEN
3657: print_debug('Last operation in plan - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3658: END IF;
3659:
3660: RAISE FND_API.G_EXC_ERROR;
3661: END IF;
3662: */
3663: END IF; -- IF p_activity_id = g_op_activity_inbound
3664:

Line 3683: RAISE FND_API.G_EXC_ERROR;

3679:
3680: fnd_message.set_name('WMS', 'WMS_ATF_NO_NEXT_OPERATION');
3681: fnd_msg_pub.ADD;
3682:
3683: RAISE FND_API.G_EXC_ERROR;
3684:
3685: END IF;
3686:
3687: CLOSE c_next_plan_detail;

Line 3781: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3777: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);
3778: print_debug('x_source_task_id => '||l_new_mmtt_id, l_module_name,4);
3779: print_debug('x_error_code => '||l_atf_error_code, l_module_name,4);
3780: END IF;
3781: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3782: IF (l_debug = 1) THEN
3783: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3784: END IF;
3785:

Line 3788: RAISE fnd_api.g_exc_unexpected_error;

3784: END IF;
3785:
3786: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3787: fnd_msg_pub.ADD;
3788: RAISE fnd_api.g_exc_unexpected_error;
3789: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3790: IF (l_debug = 1) THEN
3791: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3792: END IF;

Line 3789: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

3785:
3786: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3787: fnd_msg_pub.ADD;
3788: RAISE fnd_api.g_exc_unexpected_error;
3789: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3790: IF (l_debug = 1) THEN
3791: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3792: END IF;
3793:

Line 3796: RAISE fnd_api.g_exc_error;

3792: END IF;
3793:
3794: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3795: fnd_msg_pub.ADD;
3796: RAISE fnd_api.g_exc_error;
3797: END IF;
3798:
3799:
3800: END IF; -- IF p_activity_id = g_op_activity_inbound

Line 3825: IF l_return_status <>FND_API.g_ret_sts_success THEN

3821: IF (l_debug=1) THEN
3822: print_debug('After calling wms_op_runtime_pvt_apis.insert_operation_instance:' ,l_module_name,4);
3823: END IF;
3824:
3825: IF l_return_status <>FND_API.g_ret_sts_success THEN
3826: IF (l_debug=1) THEN
3827: print_debug('wms_op_runtime_pvt_apis.insert_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3828: END IF;
3829:

Line 3830: RAISE FND_API.G_EXC_ERROR;

3826: IF (l_debug=1) THEN
3827: print_debug('wms_op_runtime_pvt_apis.insert_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3828: END IF;
3829:
3830: RAISE FND_API.G_EXC_ERROR;
3831: END IF;
3832:
3833:
3834: END IF; -- IF l_last_op_sequence = l_wooi_data_rec.operation_sequence

Line 3848: WHEN fnd_api.g_exc_error THEN

3844: END IF;
3845:
3846: EXCEPTION
3847:
3848: WHEN fnd_api.g_exc_error THEN
3849: IF (l_debug=1) THEN
3850: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
3851: END IF;
3852: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 3850: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);

3846: EXCEPTION
3847:
3848: WHEN fnd_api.g_exc_error THEN
3849: IF (l_debug=1) THEN
3850: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
3851: END IF;
3852: x_return_status:=FND_API.G_RET_STS_ERROR;
3853: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3854: fnd_msg_pub.ADD;

Line 3852: x_return_status:=FND_API.G_RET_STS_ERROR;

3848: WHEN fnd_api.g_exc_error THEN
3849: IF (l_debug=1) THEN
3850: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
3851: END IF;
3852: x_return_status:=FND_API.G_RET_STS_ERROR;
3853: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3854: fnd_msg_pub.ADD;
3855: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3856: ROLLBACK TO sp_complete_oprtn_instance;

Line 3880: WHEN fnd_api.g_exc_unexpected_error THEN

3876: CLOSE c_next_plan_detail;
3877: END IF;
3878:
3879:
3880: WHEN fnd_api.g_exc_unexpected_error THEN
3881:
3882: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3883: IF (l_debug=1) THEN
3884: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 3882: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

3878:
3879:
3880: WHEN fnd_api.g_exc_unexpected_error THEN
3881:
3882: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3883: IF (l_debug=1) THEN
3884: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3885: END IF;
3886: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3884: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

3880: WHEN fnd_api.g_exc_unexpected_error THEN
3881:
3882: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3883: IF (l_debug=1) THEN
3884: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3885: END IF;
3886: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3887: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3888: END IF;

Line 3917: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

3913: END IF;
3914:
3915: WHEN OTHERS THEN
3916:
3917: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3918: IF (l_debug=1) THEN
3919: print_debug('Other Error occured at '||l_progress,l_module_name,1);
3920: IF SQLCODE IS NOT NULL AND SQLCODE >= -20000
3921: THEN

Line 4626: RAISE FND_API.G_EXC_ERROR;

4622:
4623: IF (l_debug=1) THEN
4624: print_debug('Demand source header id does not exist for this MMTT.',l_module_name,4);
4625: END IF;
4626: RAISE FND_API.G_EXC_ERROR;
4627:
4628: WHEN OTHERS THEN
4629: IF (l_debug = 1) THEN
4630: print_debug('Error retrievine info from wip_requirement_operations',l_module_name,4);

Line 4632: RAISE FND_API.G_EXC_ERROR;

4628: WHEN OTHERS THEN
4629: IF (l_debug = 1) THEN
4630: print_debug('Error retrievine info from wip_requirement_operations',l_module_name,4);
4631: END IF;
4632: RAISE FND_API.G_EXC_ERROR;
4633:
4634:
4635: END;
4636:

Line 4879: WHEN FND_API.G_EXC_ERROR THEN

4875:
4876: END IF;/*Activity Type =Inbound*/
4877:
4878: EXCEPTION
4879: WHEN FND_API.G_EXC_ERROR THEN
4880: x_return_status:=g_ret_sts_error;
4881: IF mol_details%ISOPEN THEN
4882: CLOSE mol_details;
4883: END IF;

Line 4904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4900: END IF;
4901:
4902: /*Populate error message and error Code*/
4903:
4904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4905: x_return_status:=g_ret_sts_unexp_error;
4906:
4907: IF (l_debug=1) THEN
4908: print_debug('Unexpected error'||SQLERRM||l_progress,l_module_name,1);

Line 5389: RAISE FND_API.G_EXC_ERROR;

5385:
5386: IF (l_debug=1) THEN
5387: print_debug('Item -Org combnation not found',l_module_name,1);
5388: END IF;
5389: RAISE FND_API.G_EXC_ERROR;
5390:
5391: END IF;
5392:
5393: CLOSE c_item_details;

Line 5627: RAISE FND_API.G_EXC_ERROR;

5623: , p_sec_txn_qty => l_inbound_doc_parent_split_rec.secondary_transaction_quantity -- 9037915
5624: );
5625:
5626: IF (x_return_status=g_ret_sts_error) THEN
5627: RAISE FND_API.G_EXC_ERROR;
5628: ELSIF (x_return_status<>g_ret_sts_success) THEN
5629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5630: END IF;
5631:

Line 5629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5625:
5626: IF (x_return_status=g_ret_sts_error) THEN
5627: RAISE FND_API.G_EXC_ERROR;
5628: ELSIF (x_return_status<>g_ret_sts_success) THEN
5629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5630: END IF;
5631:
5632:
5633: l_progress := 120;

Line 5655: RAISE FND_API.G_EXC_ERROR;

5651:
5652: IF (l_debug=1) THEN
5653: print_debug('Item -Org combnation not found',l_module_name,1);
5654: END IF;
5655: RAISE FND_API.G_EXC_ERROR;
5656:
5657: END IF;
5658:
5659: CLOSE c_item_details;

Line 5875: RAISE FND_API.G_EXC_ERROR;

5871: x_msg_data => x_msg_data ,
5872: p_insert_rec => l_wopi_split_rec );
5873:
5874: IF (x_return_status=g_ret_sts_error) THEN
5875: RAISE FND_API.G_EXC_ERROR;
5876: ELSIF (x_return_status<>g_ret_sts_success) THEN
5877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5878: END IF;
5879: /* BEGIN: GRACE11-02-2003

Line 5877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5873:
5874: IF (x_return_status=g_ret_sts_error) THEN
5875: RAISE FND_API.G_EXC_ERROR;
5876: ELSIF (x_return_status<>g_ret_sts_success) THEN
5877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5878: END IF;
5879: /* BEGIN: GRACE11-02-2003
5880: * For each new WOPI that we are creating, we should copy all WDTH
5881: * records from the the original WOPI, and link these new WDTH

Line 6212: RAISE FND_API.G_EXC_ERROR;

6208: print_debug('Return Status from table handler',l_module_name,9);
6209: END IF;
6210:
6211: IF (x_return_status=g_ret_sts_error) THEN
6212: RAISE FND_API.G_EXC_ERROR;
6213: ELSIF (x_return_status<>g_ret_sts_success) THEN
6214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6215: END IF;
6216:

Line 6214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6210:
6211: IF (x_return_status=g_ret_sts_error) THEN
6212: RAISE FND_API.G_EXC_ERROR;
6213: ELSIF (x_return_status<>g_ret_sts_success) THEN
6214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6215: END IF;
6216:
6217: END LOOP;
6218: CLOSE wooi_cursor;

Line 6342: WHEN FND_API.G_EXC_ERROR THEN

6338: /* END: GRACE11-02-2003 */
6339:
6340: END LOOP;
6341: EXCEPTION
6342: WHEN FND_API.G_EXC_ERROR THEN
6343: IF (l_debug=1) THEN
6344: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
6345: END IF;
6346:

Line 6344: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);

6340: END LOOP;
6341: EXCEPTION
6342: WHEN FND_API.G_EXC_ERROR THEN
6343: IF (l_debug=1) THEN
6344: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
6345: END IF;
6346:
6347: IF (inbound_document_details%ISOPEN) THEN
6348: CLOSE inbound_document_details;

Line 6367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6363: ROLLBACK TO split_op_instance_sp;
6364:
6365: x_return_status:=g_ret_sts_error;
6366:
6367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6368: IF (l_debug=1) THEN
6369: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,1);
6370: --print_debug('UnExpected Error: '||SQLERRM,l_module_name,1);
6371: END IF;

Line 6369: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,1);

6365: x_return_status:=g_ret_sts_error;
6366:
6367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6368: IF (l_debug=1) THEN
6369: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,1);
6370: --print_debug('UnExpected Error: '||SQLERRM,l_module_name,1);
6371: END IF;
6372:
6373: IF (inbound_document_details%ISOPEN) THEN

Line 6510: RAISE FND_API.G_EXC_ERROR;

6506: IF p_source_task_id IS NULL THEN
6507: IF (l_debug=1) THEN
6508: print_debug('Invalid input param. p_source_task_id Cannot be NULL.',l_module_name,4);
6509: END IF;
6510: RAISE FND_API.G_EXC_ERROR;
6511: END IF;
6512:
6513:
6514: IF p_activity_type_id IS NULL THEN

Line 6518: RAISE FND_API.G_EXC_ERROR;

6514: IF p_activity_type_id IS NULL THEN
6515: IF (l_debug=1) THEN
6516: print_debug('Invalid input param. p_activity_type_id Cannot be NULL.',l_module_name,4);
6517: END IF;
6518: RAISE FND_API.G_EXC_ERROR;
6519: END IF;
6520:
6521:
6522: l_progress := 20;

Line 6536: RAISE FND_API.G_EXC_ERROR;

6532: WHEN no_data_found THEN
6533: IF (l_debug=1) THEN
6534: print_debug('WDT does not exist for this MMTT.',l_module_name,4);
6535: END IF;
6536: RAISE FND_API.G_EXC_ERROR;
6537:
6538: END;
6539:
6540: l_progress := 30;

Line 6553: RAISE FND_API.G_EXC_ERROR;

6549: print_debug('Invalid WDT status.' ,l_module_name,4);
6550: END IF;
6551: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
6552: fnd_msg_pub.ADD;
6553: RAISE FND_API.G_EXC_ERROR;
6554: END IF; -- IF l_wdt_status NOT IN (g_task_status_loaded, g_task_status_dispatched)
6555:
6556:
6557: IF l_wdt_status = g_task_status_dispatched THEN

Line 6600: RAISE FND_API.G_EXC_ERROR;

6596: IF c_inbound_document_details%notfound THEN
6597: IF (l_debug=1) THEN
6598: print_debug('Invalid input param. p_source_task_id does not match to an MMTT record.',l_module_name,4);
6599: END IF;
6600: RAISE FND_API.G_EXC_ERROR;
6601: END IF;
6602:
6603: CLOSE c_inbound_document_details;
6604:

Line 6649: IF l_return_status <>FND_API.g_ret_sts_success THEN

6645: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6646: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6647: END IF;
6648:
6649: IF l_return_status <>FND_API.g_ret_sts_success THEN
6650: IF (l_debug=1) THEN
6651: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6652: END IF;
6653:

Line 6654: RAISE FND_API.G_EXC_ERROR;

6650: IF (l_debug=1) THEN
6651: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6652: END IF;
6653:
6654: RAISE FND_API.G_EXC_ERROR;
6655: END IF;
6656:
6657: END IF;
6658:

Line 6675: RAISE FND_API.G_EXC_ERROR;

6671: print_debug('Active operation instance record does not exist for this task.',l_module_name,4);
6672: END IF;
6673: fnd_message.set_name('WMS', 'WMS_ATF_NO_ACTIVE_PLAN');
6674: fnd_msg_pub.ADD;
6675: RAISE FND_API.G_EXC_ERROR;
6676: END IF;
6677:
6678: CLOSE c_wooi_data_rec;
6679:

Line 6717: IF l_return_status <>FND_API.g_ret_sts_success THEN

6713: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6714: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6715: END IF;
6716:
6717: IF l_return_status <>FND_API.g_ret_sts_success THEN
6718: IF (l_debug=1) THEN
6719: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6720: END IF;
6721:

Line 6722: RAISE FND_API.G_EXC_ERROR;

6718: IF (l_debug=1) THEN
6719: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6720: END IF;
6721:
6722: RAISE FND_API.G_EXC_ERROR;
6723: END IF;
6724:
6725: BEGIN
6726: -- If this the first operation within a plan,

Line 6748: RAISE FND_API.G_EXC_ERROR;

6744: IF (l_debug=1) THEN
6745: print_debug('Exception when getting min operation_sequence.' ,l_module_name,4);
6746: END IF;
6747:
6748: RAISE FND_API.G_EXC_ERROR;
6749: END;
6750:
6751:
6752: IF l_first_op_sequence = l_wooi_data_rec.operation_sequence AND

Line 6787: IF l_return_status <>FND_API.g_ret_sts_success THEN

6783: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6784: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6785: END IF;
6786:
6787: IF l_return_status <>FND_API.g_ret_sts_success THEN
6788: IF (l_debug=1) THEN
6789: print_debug('wms_op_runtime_pvt_apis.Update_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6790: END IF;
6791:

Line 6792: RAISE FND_API.G_EXC_ERROR;

6788: IF (l_debug=1) THEN
6789: print_debug('wms_op_runtime_pvt_apis.Update_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6790: END IF;
6791:
6792: RAISE FND_API.G_EXC_ERROR;
6793: END IF;
6794:
6795:
6796: END IF; -- IF l_first_op_sequence = l_wooi_data_rec.operation_sequence

Line 6824: IF l_return_status <>FND_API.g_ret_sts_success THEN

6820: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6821: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6822: END IF;
6823:
6824: IF l_return_status <>FND_API.g_ret_sts_success THEN
6825: IF (l_debug=1) THEN
6826: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6827: END IF;
6828:

Line 6829: RAISE FND_API.G_EXC_ERROR;

6825: IF (l_debug=1) THEN
6826: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6827: END IF;
6828:
6829: RAISE FND_API.G_EXC_ERROR;
6830: END IF;
6831:
6832:
6833: END IF; -- IF l_wooi_data_rec.operation_type_id = g_op_type_drop

Line 6850: WHEN fnd_api.g_exc_error THEN

6846: END IF;
6847:
6848: EXCEPTION
6849:
6850: WHEN fnd_api.g_exc_error THEN
6851: IF (l_debug=1) THEN
6852: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
6853: END IF;
6854: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 6852: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);

6848: EXCEPTION
6849:
6850: WHEN fnd_api.g_exc_error THEN
6851: IF (l_debug=1) THEN
6852: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
6853: END IF;
6854: x_return_status:=FND_API.G_RET_STS_ERROR;
6855: ROLLBACK TO sp_cleanup_oprtn_instance;
6856:

Line 6854: x_return_status:=FND_API.G_RET_STS_ERROR;

6850: WHEN fnd_api.g_exc_error THEN
6851: IF (l_debug=1) THEN
6852: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
6853: END IF;
6854: x_return_status:=FND_API.G_RET_STS_ERROR;
6855: ROLLBACK TO sp_cleanup_oprtn_instance;
6856:
6857: IF c_inbound_document_details%isopen THEN
6858: CLOSE c_inbound_document_details;

Line 6867: WHEN fnd_api.g_exc_unexpected_error THEN

6863: END IF;
6864: fnd_message.set_name('WMS', 'WMS_ATF_CLEANUP_FAILURE');
6865: fnd_msg_pub.ADD;
6866:
6867: WHEN fnd_api.g_exc_unexpected_error THEN
6868:
6869: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
6870: IF (l_debug=1) THEN
6871: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 6869: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

6865: fnd_msg_pub.ADD;
6866:
6867: WHEN fnd_api.g_exc_unexpected_error THEN
6868:
6869: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
6870: IF (l_debug=1) THEN
6871: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
6872: END IF;
6873: ROLLBACK TO sp_cleanup_oprtn_instance;

Line 6871: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

6867: WHEN fnd_api.g_exc_unexpected_error THEN
6868:
6869: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
6870: IF (l_debug=1) THEN
6871: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
6872: END IF;
6873: ROLLBACK TO sp_cleanup_oprtn_instance;
6874:
6875: IF c_inbound_document_details%isopen THEN

Line 6888: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

6884: fnd_msg_pub.ADD;
6885:
6886: WHEN OTHERS THEN
6887:
6888: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
6889: IF (l_debug=1) THEN
6890: print_debug('Other Error occured at '||l_progress,l_module_name,1);
6891: IF SQLCODE IS NOT NULL THEN
6892: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);

Line 7119: RAISE FND_API.G_EXC_ERROR;

7115: print_debug('Return status from table handler'||x_return_status,l_module_name,9);
7116: END IF;
7117:
7118: IF (x_return_status=g_ret_sts_error) THEN
7119: RAISE FND_API.G_EXC_ERROR;
7120:
7121: ELSIF (x_return_status<>g_ret_sts_success) THEN
7122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7123:

Line 7122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7118: IF (x_return_status=g_ret_sts_error) THEN
7119: RAISE FND_API.G_EXC_ERROR;
7120:
7121: ELSIF (x_return_status<>g_ret_sts_success) THEN
7122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7123:
7124: END IF;
7125:
7126: l_progress:=120;

Line 7154: RAISE FND_API.G_EXC_ERROR;

7150: END IF;
7151:
7152: IF (x_return_status=g_ret_sts_error) THEN
7153:
7154: RAISE FND_API.G_EXC_ERROR;
7155:
7156: ELSIF (x_return_status<>g_ret_sts_success) THEN
7157:
7158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7154: RAISE FND_API.G_EXC_ERROR;
7155:
7156: ELSIF (x_return_status<>g_ret_sts_success) THEN
7157:
7158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7159:
7160: END IF;
7161:
7162:

Line 7185: RAISE FND_API.G_EXC_ERROR;

7181: l_progress:=150;
7182:
7183: IF (x_return_status=g_ret_sts_error) THEN
7184:
7185: RAISE FND_API.G_EXC_ERROR;
7186:
7187: ELSIF (x_return_status<>g_ret_sts_success) THEN
7188:
7189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7185: RAISE FND_API.G_EXC_ERROR;
7186:
7187: ELSIF (x_return_status<>g_ret_sts_success) THEN
7188:
7189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7190:
7191: END IF;
7192:
7193: /*For MMTT.parent_line_id call WMS_OP_RUNTIME_PVT_API.Archive_Dispatched_tasks to Archive WDT*/

Line 7222: RAISE FND_API.G_EXC_ERROR;

7218: l_progress :=170;
7219:
7220: IF (x_return_status=g_ret_sts_error) THEN
7221:
7222: RAISE FND_API.G_EXC_ERROR;
7223:
7224: ELSIF (x_return_status<>g_ret_sts_success) THEN
7225:
7226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7222: RAISE FND_API.G_EXC_ERROR;
7223:
7224: ELSIF (x_return_status<>g_ret_sts_success) THEN
7225:
7226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7227:
7228: END IF;
7229:
7230: IF (p_activity_type_id = G_OP_ACTIVITY_INBOUND) THEN

Line 7259: IF x_return_status <>FND_API.g_ret_sts_success THEN

7255: print_debug('x_msg_data => '|| x_msg_data,l_module_name,4);
7256: print_debug('x_msg_count => '|| x_msg_count,l_module_name,4);
7257: END IF;
7258:
7259: IF x_return_status <>FND_API.g_ret_sts_success THEN
7260: IF (l_debug=1) THEN
7261: print_debug('wms_op_inbound_pvt.cancel finished with error. x_return_status = ' || x_return_status,l_module_name,4);
7262: END IF;
7263:

Line 7264: RAISE FND_API.G_EXC_ERROR;

7260: IF (l_debug=1) THEN
7261: print_debug('wms_op_inbound_pvt.cancel finished with error. x_return_status = ' || x_return_status,l_module_name,4);
7262: END IF;
7263:
7264: RAISE FND_API.G_EXC_ERROR;
7265: END IF;
7266:
7267: l_progress := 200;
7268: END IF; -- IF (p_activity_type_id = G_OP_ACTIVITY_INBOUND)

Line 7272: WHEN FND_API.G_EXC_ERROR THEN

7268: END IF; -- IF (p_activity_type_id = G_OP_ACTIVITY_INBOUND)
7269:
7270: EXCEPTION
7271:
7272: WHEN FND_API.G_EXC_ERROR THEN
7273:
7274: IF (l_debug=1) THEN
7275: print_debug('Expected Error Obtained at'||l_progress,l_module_name,1);
7276: END IF;

Line 7291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7287: ROLLBACK TO cancel_op_plan_sp;
7288:
7289: x_return_status:=g_ret_sts_error;
7290:
7291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7292:
7293: IF (l_debug=1) THEN
7294: print_debug('UnExpected Error Obtained at'||l_progress||SQLERRM,l_module_name,1);
7295: END IF;

Line 7586: RAISE FND_API.G_EXC_ERROR;

7582: print_debug('Return status from table handler'||x_return_status,l_module_name,9);
7583: END IF;
7584:
7585: IF (x_return_status=g_ret_sts_error) THEN
7586: RAISE FND_API.G_EXC_ERROR;
7587:
7588: ELSIF (x_return_status<>g_ret_sts_success) THEN
7589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7590:

Line 7589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7585: IF (x_return_status=g_ret_sts_error) THEN
7586: RAISE FND_API.G_EXC_ERROR;
7587:
7588: ELSIF (x_return_status<>g_ret_sts_success) THEN
7589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7590:
7591: END IF;
7592:
7593: l_progress:=100;

Line 7621: RAISE FND_API.G_EXC_ERROR;

7617: END IF;
7618:
7619: IF (x_return_status=g_ret_sts_error) THEN
7620:
7621: RAISE FND_API.G_EXC_ERROR;
7622:
7623: ELSIF (x_return_status<>g_ret_sts_success) THEN
7624:
7625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7621: RAISE FND_API.G_EXC_ERROR;
7622:
7623: ELSIF (x_return_status<>g_ret_sts_success) THEN
7624:
7625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7626:
7627: END IF;
7628:
7629:

Line 7653: RAISE FND_API.G_EXC_ERROR;

7649: l_progress:=130;
7650:
7651: IF (x_return_status=g_ret_sts_error) THEN
7652:
7653: RAISE FND_API.G_EXC_ERROR;
7654:
7655: ELSIF (x_return_status<>g_ret_sts_success) THEN
7656:
7657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7653: RAISE FND_API.G_EXC_ERROR;
7654:
7655: ELSIF (x_return_status<>g_ret_sts_success) THEN
7656:
7657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7658:
7659: END IF;
7660:
7661: /*For MMTT.parent_line_id call WMS_OP_RUNTIME_PVT_API.Archive_Dispatched_tasks to Archive WDT*/

Line 7690: RAISE FND_API.G_EXC_ERROR;

7686: l_progress :=150;
7687:
7688: IF (x_return_status=g_ret_sts_error) THEN
7689:
7690: RAISE FND_API.G_EXC_ERROR;
7691:
7692: ELSIF (x_return_status<>g_ret_sts_success) THEN
7693:
7694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7690: RAISE FND_API.G_EXC_ERROR;
7691:
7692: ELSIF (x_return_status<>g_ret_sts_success) THEN
7693:
7694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7695:
7696: END IF;
7697:
7698: IF (p_activity_type_id = G_OP_ACTIVITY_INBOUND) THEN

Line 7718: RAISE FND_API.G_EXC_ERROR;

7714: END IF;
7715:
7716: IF (x_return_status=g_ret_sts_error) THEN
7717:
7718: RAISE FND_API.G_EXC_ERROR;
7719:
7720: ELSIF (x_return_status<>g_ret_sts_success) THEN
7721:
7722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7718: RAISE FND_API.G_EXC_ERROR;
7719:
7720: ELSIF (x_return_status<>g_ret_sts_success) THEN
7721:
7722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7723:
7724: END IF;
7725:
7726: l_progress:=170;

Line 7798: IF l_return_status <> FND_API.g_ret_sts_success THEN

7794: print_debug('x_msg_data => '||l_msg_data,l_module_name,4);
7795: print_debug('x_msg_count => '||l_msg_count,l_module_name,4);
7796: END IF;
7797:
7798: IF l_return_status <> FND_API.g_ret_sts_success THEN
7799: IF (l_debug=1) THEN
7800: print_debug(' wms_op_inbound_pvt.ABORT finished with error. l_return_status = ' || l_return_status,l_module_name,4);
7801: END IF;
7802:

Line 7803: RAISE FND_API.G_EXC_ERROR;

7799: IF (l_debug=1) THEN
7800: print_debug(' wms_op_inbound_pvt.ABORT finished with error. l_return_status = ' || l_return_status,l_module_name,4);
7801: END IF;
7802:
7803: RAISE FND_API.G_EXC_ERROR;
7804: END IF;
7805:
7806: IF l_debug=1 THEN
7807: print_debug('Need to update the WDT /WDTH records nulling out operation Plan id',l_module_name,9);

Line 7850: WHEN FND_API.G_EXC_ERROR THEN

7846: /*Need for calling a document handler or not..mostly not*/
7847:
7848: EXCEPTION
7849:
7850: WHEN FND_API.G_EXC_ERROR THEN
7851:
7852: IF (l_debug=1) THEN
7853: print_debug('Expected Error Obtained at'||l_progress,l_module_name,1);
7854: END IF;

Line 7872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7868: ROLLBACK TO abort_plan_sp;
7869:
7870: x_return_status:=g_ret_sts_error;
7871:
7872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7873:
7874: IF (l_debug=1) THEN
7875: print_debug('UnExpected Error Obtained at'||l_progress||SQLERRM,l_module_name,1);
7876: END IF;

Line 8143: RAISE FND_API.G_EXC_ERROR;

8139: END IF;
8140:
8141:
8142: IF (x_return_status=g_ret_sts_error) THEN
8143: RAISE FND_API.G_EXC_ERROR;
8144:
8145: ELSIF (x_return_status<>g_ret_sts_success) THEN
8146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8147:

Line 8146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8142: IF (x_return_status=g_ret_sts_error) THEN
8143: RAISE FND_API.G_EXC_ERROR;
8144:
8145: ELSIF (x_return_status<>g_ret_sts_success) THEN
8146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8147:
8148: END IF;
8149: end if ;
8150:

Line 8229: RAISE FND_API.G_EXC_ERROR;

8225: print_debug('Return Status from Update Operation Instance is '||x_return_status,l_module_name,9);
8226: END IF;
8227:
8228: IF (x_return_status=g_ret_sts_error) THEN
8229: RAISE FND_API.G_EXC_ERROR;
8230:
8231: ELSIF (x_return_status<>g_ret_sts_success) THEN
8232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8233:

Line 8232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8228: IF (x_return_status=g_ret_sts_error) THEN
8229: RAISE FND_API.G_EXC_ERROR;
8230:
8231: ELSIF (x_return_status<>g_ret_sts_success) THEN
8232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8233:
8234: END IF;
8235:
8236: l_op_plan_instance_id := l_wooi_data_rec.op_plan_instance_id;

Line 8308: RAISE FND_API.G_EXC_ERROR;

8304: print_debug('Return Status from Delete Operation Instance '||x_return_status,l_module_name,9);
8305: END IF;
8306:
8307: IF (x_return_status=g_ret_sts_error) THEN
8308: RAISE FND_API.G_EXC_ERROR;
8309:
8310: ELSIF (x_return_status<>g_ret_sts_success) THEN
8311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8312:

Line 8311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8307: IF (x_return_status=g_ret_sts_error) THEN
8308: RAISE FND_API.G_EXC_ERROR;
8309:
8310: ELSIF (x_return_status<>g_ret_sts_success) THEN
8311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8312:
8313: END IF;
8314:
8315: END IF; /*Operation Type Drop*/

Line 8373: RAISE FND_API.G_EXC_ERROR;

8369: print_debug('Return Status from Update Plan Instance'||x_return_status,l_module_name,9);
8370: END IF;
8371:
8372: IF (x_return_status=g_ret_sts_error) THEN
8373: RAISE FND_API.G_EXC_ERROR;
8374:
8375: ELSIF (x_return_status<>g_ret_sts_success) THEN
8376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8377:

Line 8376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8372: IF (x_return_status=g_ret_sts_error) THEN
8373: RAISE FND_API.G_EXC_ERROR;
8374:
8375: ELSIF (x_return_status<>g_ret_sts_success) THEN
8376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8377:
8378: END IF;
8379:
8380: END IF;/*First Operation in Plan*/

Line 8402: RAISE FND_API.G_EXC_ERROR;

8398: END IF;
8399:
8400:
8401: IF (x_return_status=g_ret_sts_error) THEN
8402: RAISE FND_API.G_EXC_ERROR;
8403:
8404: ELSIF (x_return_status<>g_ret_sts_success) THEN
8405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8406:

Line 8405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8401: IF (x_return_status=g_ret_sts_error) THEN
8402: RAISE FND_API.G_EXC_ERROR;
8403:
8404: ELSIF (x_return_status<>g_ret_sts_success) THEN
8405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8406:
8407: END IF;
8408:
8409:

Line 8424: WHEN FND_API.G_EXC_ERROR THEN

8420: END IF;/*Activity is Inbound*/
8421:
8422: EXCEPTION
8423:
8424: WHEN FND_API.G_EXC_ERROR THEN
8425:
8426: IF (l_debug=1) THEN
8427: print_debug('Expected Error Obtained at'||l_progress,l_module_name,1);
8428: END IF;

Line 8450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8446: x_return_status := g_ret_sts_error;
8447:
8448: ROLLBACK TO rollback_op_plan_sp;
8449:
8450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8451:
8452: IF (l_debug=1) THEN
8453: print_debug('Expected Error Obtained at'||l_progress,l_module_name,1);
8454: END IF;

Line 8600: /RAISE fnd_api.g_exc_error;/

8596: */
8597:
8598: IF (p_source_task_id IS NULL OR p_activity_type_id IS NULL) THEN
8599:
8600: /*RAISE fnd_api.g_exc_error;*/
8601: RAISE_APPLICATION_ERROR(INVALID_INPUT,'Invalid inputs passed'||p_source_task_id||p_activity_type_id);
8602:
8603: END IF; /* p_source_task_id IS...*/
8604:

Line 8638: /RAISE fnd_api.g_exc_error;/

8634: */
8635:
8636: IF l_plan_id = -1 THEN
8637:
8638: /*RAISE fnd_api.g_exc_error;*/
8639: RAISE_APPLICATION_ERROR(INVALID_DOC_ID,'Document Record does not exist for Source_task_id'||p_source_task_id);
8640:
8641: END IF; /* l_plan_id = -1 */
8642:

Line 8710: /*WHEN FND_API.G_EXC_ERROR THEN

8706: );
8707:
8708: EXCEPTION
8709:
8710: /*WHEN FND_API.G_EXC_ERROR THEN
8711: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8712:
8713: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
8714: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);