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 1795: --RAISE FND_API.G_EXC_ERROR;

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

Line 1808: --RAISE FND_API.G_EXC_ERROR;

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

Line 1947: RAISE FND_API.G_EXC_ERROR;

1943: END IF;
1944:
1945: CLOSE c_inbound_doc;
1946:
1947: RAISE FND_API.G_EXC_ERROR;
1948:
1949: END IF;
1950:
1951: CLOSE c_inbound_doc;

Line 2020: RAISE FND_API.G_EXC_ERROR;

2016: IF (l_debug=1) THEN
2017: print_debug('Expected error from table handler',l_module_name,1);
2018: END IF;
2019:
2020: RAISE FND_API.G_EXC_ERROR;
2021:
2022: ELSIF (x_return_status<>g_ret_sts_success) THEN
2023: IF (l_debug=1) THEN
2024: print_debug('Unexpected error fromt table hander',l_module_name,1);

Line 2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2022: ELSIF (x_return_status<>g_ret_sts_success) THEN
2023: IF (l_debug=1) THEN
2024: print_debug('Unexpected error fromt table hander',l_module_name,1);
2025: END IF;
2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2027:
2028: END IF;
2029:
2030: END IF; /*WDT Record to be inserted*/

Line 2060: RAISE FND_API.G_EXC_ERROR;

2056: END IF;
2057:
2058: CLOSE c_operation_instance_details;
2059:
2060: RAISE FND_API.G_EXC_ERROR;
2061:
2062: END IF;
2063: CLOSE c_operation_instance_details;
2064:

Line 2142: RAISE FND_API.G_EXC_ERROR;

2138: IF (l_debug=1) THEN
2139: print_debug('Expected error from table handler',l_module_name,1);
2140: END IF;
2141:
2142: RAISE FND_API.G_EXC_ERROR;
2143:
2144: ELSIF (x_return_status<>g_ret_sts_success) THEN
2145: IF (l_debug=1) THEN
2146: print_debug('Unexpected error fromt table hander',l_module_name,1);

Line 2148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2144: ELSIF (x_return_status<>g_ret_sts_success) THEN
2145: IF (l_debug=1) THEN
2146: print_debug('Unexpected error fromt table hander',l_module_name,1);
2147: END IF;
2148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2149:
2150: END IF;
2151:
2152: END IF; /*WDT Record to be inserted*/

Line 2189: RAISE FND_API.G_EXC_ERROR;

2185: IF (x_return_status=g_ret_sts_error) THEN
2186: IF (l_debug=1) THEN
2187: print_debug('Error Obtained from Abort_operation_plan',l_module_name,1);
2188: END IF;
2189: RAISE FND_API.G_EXC_ERROR;
2190:
2191: ELSIF (x_return_status=g_ret_sts_unexp_error) THEN
2192:
2193: IF (l_debug=1) THEN

Line 2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2192:
2193: IF (l_debug=1) THEN
2194: print_debug('Error Obtained from Abort_operation_plan',l_module_name,1);
2195: END IF;
2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2197: ELSE
2198: /*Return status from Abort is sucess.REturn from here*/
2199: RETURN;
2200:

Line 2274: RAISE FND_API.G_EXC_ERROR;

2270: print_debug('Return status from table hanlder'||x_return_status,l_module_name,9);
2271: END IF;
2272:
2273: IF (x_return_status=g_ret_sts_error) THEN
2274: RAISE FND_API.G_EXC_ERROR;
2275: ELSIF (x_return_status<>g_ret_sts_success) THEN
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END IF;
2278:

Line 2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2272:
2273: IF (x_return_status=g_ret_sts_error) THEN
2274: RAISE FND_API.G_EXC_ERROR;
2275: ELSIF (x_return_status<>g_ret_sts_success) THEN
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END IF;
2278:
2279: END IF;/*Count=1*/
2280:

Line 2322: RAISE FND_API.G_EXC_ERROR;

2318: IF (x_return_status=g_ret_sts_error) THEN
2319: IF (l_debug=1) THEN
2320: print_debug('Error obtained and hence raising exception',l_module_name,1);
2321: END IF;
2322: RAISE FND_API.G_EXC_ERROR;
2323:
2324: ELSIF (x_return_status=g_ret_sts_unexp_error) THEN
2325: IF (l_debug=1) THEN
2326: print_debug('Unexpected error obtained ',l_module_name,1);

Line 2328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2324: ELSIF (x_return_status=g_ret_sts_unexp_error) THEN
2325: IF (l_debug=1) THEN
2326: print_debug('Unexpected error obtained ',l_module_name,1);
2327: END IF;
2328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2329:
2330: END IF;
2331:
2332: IF (l_debug=1) THEN

Line 2375: RAISE FND_API.G_EXC_ERROR;

2371: print_debug('Return status from document handler'||l_return_status,l_module_name,9);
2372: END IF;
2373:
2374: IF (l_return_status=g_ret_sts_error) THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: ELSIF (l_return_status<>g_ret_sts_success) THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: END IF;
2379:

Line 2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2373:
2374: IF (l_return_status=g_ret_sts_error) THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: ELSIF (l_return_status<>g_ret_sts_success) THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: END IF;
2379:
2380: l_progress:=230;
2381:

Line 2401: RAISE FND_API.G_EXC_ERROR;

2397: print_debug('Return status from table hanlder'||l_return_status,l_module_name,9);
2398: END IF;
2399:
2400: IF (l_return_status=g_ret_sts_error) THEN
2401: RAISE FND_API.G_EXC_ERROR;
2402: ELSIF (l_return_status<>g_ret_sts_success) THEN
2403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2404: END IF;
2405:

Line 2403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2399:
2400: IF (l_return_status=g_ret_sts_error) THEN
2401: RAISE FND_API.G_EXC_ERROR;
2402: ELSIF (l_return_status<>g_ret_sts_success) THEN
2403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2404: END IF;
2405:
2406: l_progress:=250;
2407:

Line 2411: WHEN FND_API.G_EXC_ERROR THEN

2407:
2408:
2409: EXCEPTION
2410:
2411: WHEN FND_API.G_EXC_ERROR THEN
2412: IF (l_debug=1) THEN
2413: print_debug('Expected Error at '||l_progress, l_module_name,1);
2414: END IF;
2415:

Line 2635: RAISE FND_API.G_EXC_ERROR;

2631: IF p_source_task_id IS NULL THEN
2632: IF (l_debug=1) THEN
2633: print_debug('Invalid input param. p_source_task_id Cannot be NULL.',l_module_name,4);
2634: END IF;
2635: RAISE FND_API.G_EXC_ERROR;
2636: END IF;
2637:
2638:
2639: IF p_activity_id IS NULL THEN

Line 2643: RAISE FND_API.G_EXC_ERROR;

2639: IF p_activity_id IS NULL THEN
2640: IF (l_debug=1) THEN
2641: print_debug('Invalid input param. p_activity_id Cannot be NULL.',l_module_name,4);
2642: END IF;
2643: RAISE FND_API.G_EXC_ERROR;
2644: END IF;
2645:
2646: IF p_operation_type_id IS NOT NULL AND
2647: p_operation_type_id NOT IN (g_op_type_drop, g_op_type_load, g_op_type_inspect)THEN

Line 2651: RAISE FND_API.G_EXC_ERROR;

2647: p_operation_type_id NOT IN (g_op_type_drop, g_op_type_load, g_op_type_inspect)THEN
2648: IF (l_debug=1) THEN
2649: print_debug('Invalid input param. p_operation_type_id can only be load, drop, inspect or NULL.',l_module_name,4);
2650: END IF;
2651: RAISE FND_API.G_EXC_ERROR;
2652: END IF;
2653:
2654: l_operation_type_id := p_operation_type_id;
2655:

Line 2672: RAISE FND_API.G_EXC_ERROR;

2668: IF c_inbound_document_details%notfound THEN
2669: IF (l_debug=1) THEN
2670: print_debug('Invalid input param. p_source_task_id does not match to an MMTT record.',l_module_name,4);
2671: END IF;
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674:
2675: CLOSE c_inbound_document_details;
2676:

Line 2733: RAISE FND_API.G_EXC_ERROR;

2729: print_debug('Operation instance record does not exist for this task.',l_module_name,4);
2730: END IF;
2731: fnd_message.set_name('WMS', 'WMS_ATF_NO_ACTIVE_PLAN');
2732: fnd_msg_pub.ADD;
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2735:
2736: CLOSE c_wooi_data_rec;
2737:

Line 2786: RAISE FND_API.G_EXC_ERROR;

2782: WHEN no_data_found THEN
2783: IF (l_debug=1) THEN
2784: print_debug('WDT does not exist for this MMTT.',l_module_name,4);
2785: END IF;
2786: RAISE FND_API.G_EXC_ERROR;
2787:
2788: END;
2789:
2790: l_progress := 30;

Line 2803: RAISE FND_API.G_EXC_ERROR;

2799: print_debug('Invalid WDT status.' ,l_module_name,4);
2800: END IF;
2801: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
2802: fnd_msg_pub.ADD;
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF; -- IF l_wdt_status NOT IN (g_task_status_loaded, g_task_status_dispatched)
2805:
2806: END IF; -- IF p_activity_id = g_op_activity_inbound
2807:

Line 2867: IF l_return_status <>FND_API.g_ret_sts_success THEN

2863: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2864: END IF;
2865:
2866:
2867: IF l_return_status <>FND_API.g_ret_sts_success THEN
2868: IF (l_debug=1) THEN
2869: print_debug('wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2870: END IF;
2871: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');

Line 2873: RAISE FND_API.G_EXC_ERROR;

2869: print_debug('wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2870: END IF;
2871: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
2872: fnd_msg_pub.ADD;
2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;
2875:
2876: ELSIF p_operation_type_id IS NULL OR p_operation_type_id = g_op_type_load THEN
2877: IF (l_debug=1) THEN

Line 2907: RAISE FND_API.G_EXC_ERROR;

2903: print_debug('Current operation ('|| p_operation_type_id ||') is not compatible with WDT status of dispatched.' ,l_module_name,4);
2904: END IF;
2905: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
2906: fnd_msg_pub.ADD;
2907: RAISE FND_API.G_EXC_ERROR;
2908:
2909: END IF; -- IF p_operation_type_id = g_op_type_inspect
2910:
2911:

Line 2956: IF l_return_status <>FND_API.g_ret_sts_success THEN

2952: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2953: END IF;
2954:
2955:
2956: IF l_return_status <>FND_API.g_ret_sts_success THEN
2957: IF (l_debug=1) THEN
2958: print_debug('Drop - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2959: END IF;
2960: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');

Line 2962: RAISE FND_API.G_EXC_ERROR;

2958: print_debug('Drop - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2959: END IF;
2960: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
2961: fnd_msg_pub.ADD;
2962: RAISE FND_API.G_EXC_ERROR;
2963: END IF;
2964:
2965: ELSE -- l_wdt_status = g_task_status_dispatched (not dispatched or loaded)
2966:

Line 2972: RAISE FND_API.G_EXC_ERROR;

2968: print_debug('Invalid WDT status.' ,l_module_name,4);
2969: END IF;
2970: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
2971: fnd_msg_pub.ADD;
2972: RAISE FND_API.G_EXC_ERROR;
2973:
2974:
2975: END IF; -- IF l_wdt_status = g_task_status_dispatched
2976:

Line 3039: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3035: print_debug('x_source_task_id => '||l_new_mmtt_id, l_module_name,4);
3036: print_debug('x_error_code => '||l_atf_error_code, l_module_name,4);
3037: END IF;
3038: --bug 6924639
3039: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3040: IF (l_debug = 1) THEN
3041: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3042: END IF;
3043:

Line 3046: RAISE fnd_api.g_exc_unexpected_error;

3042: END IF;
3043:
3044: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3045: fnd_msg_pub.ADD;
3046: RAISE fnd_api.g_exc_unexpected_error;
3047: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3048: IF (l_debug = 1) THEN
3049: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3050: END IF;

Line 3047: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

3043:
3044: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3045: fnd_msg_pub.ADD;
3046: RAISE fnd_api.g_exc_unexpected_error;
3047: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3048: IF (l_debug = 1) THEN
3049: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3050: END IF;
3051:

Line 3054: RAISE fnd_api.g_exc_error;

3050: END IF;
3051:
3052: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3053: fnd_msg_pub.ADD;
3054: RAISE fnd_api.g_exc_error;
3055: END IF;
3056: --bug 6924639
3057: /*
3058: IF l_return_status <>FND_API.g_ret_sts_success THEN

Line 3058: IF l_return_status <>FND_API.g_ret_sts_success THEN

3054: RAISE fnd_api.g_exc_error;
3055: END IF;
3056: --bug 6924639
3057: /*
3058: IF l_return_status <>FND_API.g_ret_sts_success THEN
3059: IF (l_debug=1) THEN
3060: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3061: END IF;
3062:

Line 3063: RAISE FND_API.G_EXC_ERROR;

3059: IF (l_debug=1) THEN
3060: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3061: END IF;
3062:
3063: RAISE FND_API.G_EXC_ERROR;
3064: END IF;
3065: */
3066: END IF; -- IF l_operation_type_id IN (g_op_type_drop, g_op_type_inspect)
3067: IF (l_debug=1) THEN

Line 3090: RAISE FND_API.G_EXC_ERROR;

3086: 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);
3087: END IF;
3088: fnd_message.set_name('WMS', 'WMS_ATF_OPERATION_MISMATCH');
3089: fnd_msg_pub.ADD;
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;
3092:
3093: IF (l_debug=1) THEN
3094: 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 3117: RAISE FND_API.G_EXC_ERROR;

3113: IF (l_debug=1) THEN
3114: print_debug('Exception when getting max operation_sequence.' ,l_module_name,4);
3115: END IF;
3116:
3117: RAISE FND_API.G_EXC_ERROR;
3118: END;
3119:
3120:
3121: IF (l_debug=1) THEN

Line 3252: RAISE FND_API.G_EXC_ERROR;

3248: IF (l_debug = 1) THEN
3249: print_debug('wms_atf_dest_locator.get_dest_locator failed: l_return_status = '|| l_return_status, l_module_name, 4);
3250: END IF;
3251:
3252: RAISE FND_API.G_EXC_ERROR;
3253:
3254: END IF;
3255: */
3256: IF l_valid_flag = 'E' THEN

Line 3272: RAISE FND_API.G_EXC_ERROR;

3268: print_debug('Invalid locator determination method.',l_module_name,4);
3269: END IF;
3270: fnd_message.set_name('WMS', 'WMS_ATF_LOC_DET_NOT_DEFINED');
3271: fnd_msg_pub.ADD;
3272: RAISE FND_API.G_EXC_ERROR;
3273:
3274: END IF; -- IF NVL(l_loc_sel_criteria_id, 0) = wms_globals.G_OP_DEST_PRE_SPECIFIED
3275:
3276: END IF; -- IF l_wooi_data_rec.sug_to_locator_id <> Nvl(l_mmtt_rec.transfer_to_location

Line 3305: IF l_return_status <>FND_API.g_ret_sts_success THEN

3301: print_debug('x_msg_count => '||l_msg_count,l_module_name,9);
3302: print_debug('x_error_code => '||l_atf_error_code,l_module_name,9);
3303: END IF;
3304:
3305: IF l_return_status <>FND_API.g_ret_sts_success THEN
3306: IF (l_debug=1) THEN
3307: print_debug('wms_atf_runtime_pub_apis.abort_operation_plan finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3308: END IF;
3309:

Line 3310: RAISE FND_API.G_EXC_ERROR;

3306: IF (l_debug=1) THEN
3307: print_debug('wms_atf_runtime_pub_apis.abort_operation_plan finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3308: END IF;
3309:
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;
3312:
3313:
3314: IF (l_debug=1) THEN

Line 3353: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3349: print_debug('x_source_task_id => '||l_new_mmtt_id, l_module_name,4);
3350: print_debug('x_error_code => '||l_atf_error_code, l_module_name,4);
3351: END IF;
3352: --bug 6924639
3353: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3354: IF (l_debug = 1) THEN
3355: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3356: END IF;
3357:

Line 3360: RAISE fnd_api.g_exc_unexpected_error;

3356: END IF;
3357:
3358: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3359: fnd_msg_pub.ADD;
3360: RAISE fnd_api.g_exc_unexpected_error;
3361: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3362: IF (l_debug = 1) THEN
3363: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3364: END IF;

Line 3361: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

3357:
3358: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3359: fnd_msg_pub.ADD;
3360: RAISE fnd_api.g_exc_unexpected_error;
3361: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3362: IF (l_debug = 1) THEN
3363: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3364: END IF;
3365:

Line 3368: RAISE fnd_api.g_exc_error;

3364: END IF;
3365:
3366: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3367: fnd_msg_pub.ADD;
3368: RAISE fnd_api.g_exc_error;
3369: END IF;
3370: --bug 6924639
3371: /*
3372: IF l_return_status <>FND_API.g_ret_sts_success THEN

Line 3372: IF l_return_status <>FND_API.g_ret_sts_success THEN

3368: RAISE fnd_api.g_exc_error;
3369: END IF;
3370: --bug 6924639
3371: /*
3372: IF l_return_status <>FND_API.g_ret_sts_success THEN
3373: IF (l_debug=1) THEN
3374: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3375: END IF;
3376:

Line 3377: RAISE FND_API.G_EXC_ERROR;

3373: IF (l_debug=1) THEN
3374: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3375: END IF;
3376:
3377: RAISE FND_API.G_EXC_ERROR;
3378: END IF;
3379: */
3380:
3381: IF c_inbound_document_details%isopen THEN

Line 3459: IF l_return_status <>FND_API.g_ret_sts_success THEN

3455: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
3456: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
3457: END IF;
3458:
3459: IF l_return_status <>FND_API.g_ret_sts_success THEN
3460: IF (l_debug=1) THEN
3461: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3462: END IF;
3463:

Line 3464: RAISE FND_API.G_EXC_ERROR;

3460: IF (l_debug=1) THEN
3461: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3462: END IF;
3463:
3464: RAISE FND_API.G_EXC_ERROR;
3465: END IF;
3466:
3467:
3468: -- Handle situation where current operation is the last step in the plan.

Line 3506: IF l_return_status <>FND_API.g_ret_sts_success THEN

3502: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
3503:
3504: END IF;
3505:
3506: IF l_return_status <>FND_API.g_ret_sts_success THEN
3507: IF (l_debug=1) THEN
3508: 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);
3509: END IF;
3510: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');

Line 3512: RAISE FND_API.G_EXC_ERROR;

3508: 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);
3509: END IF;
3510: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
3511: fnd_msg_pub.ADD;
3512: RAISE FND_API.G_EXC_ERROR;
3513: END IF;
3514:
3515: IF (l_debug=1) THEN
3516: print_debug('Before calling wms_op_runtime_pvt_apis.complete_plan_instance with following parameters:', l_module_name,4);

Line 3540: IF l_return_status <>FND_API.g_ret_sts_success THEN

3536: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3537: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);
3538: END IF;
3539:
3540: IF l_return_status <>FND_API.g_ret_sts_success THEN
3541: IF (l_debug=1) THEN
3542: print_debug('wms_op_runtime_pvt_apis.complete_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3543: END IF;
3544:

Line 3545: RAISE FND_API.G_EXC_ERROR;

3541: IF (l_debug=1) THEN
3542: print_debug('wms_op_runtime_pvt_apis.complete_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3543: END IF;
3544:
3545: RAISE FND_API.G_EXC_ERROR;
3546: END IF;
3547:
3548:
3549:

Line 3596: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3592: print_debug('x_source_task_id => '||l_new_mmtt_id, l_module_name,4);
3593: print_debug('x_error_code => '||l_atf_error_code, l_module_name,4);
3594: END IF;
3595: --bug 6924639
3596: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3597: IF (l_debug = 1) THEN
3598: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3599: END IF;
3600:

Line 3603: RAISE fnd_api.g_exc_unexpected_error;

3599: END IF;
3600:
3601: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3602: fnd_msg_pub.ADD;
3603: RAISE fnd_api.g_exc_unexpected_error;
3604: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3605: IF (l_debug = 1) THEN
3606: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3607: END IF;

Line 3604: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

3600:
3601: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3602: fnd_msg_pub.ADD;
3603: RAISE fnd_api.g_exc_unexpected_error;
3604: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3605: IF (l_debug = 1) THEN
3606: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3607: END IF;
3608:

Line 3611: RAISE fnd_api.g_exc_error;

3607: END IF;
3608:
3609: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3610: fnd_msg_pub.ADD;
3611: RAISE fnd_api.g_exc_error;
3612: END IF;
3613: --bug 6924639
3614: /*
3615: IF l_return_status <>FND_API.g_ret_sts_success THEN

Line 3615: IF l_return_status <>FND_API.g_ret_sts_success THEN

3611: RAISE fnd_api.g_exc_error;
3612: END IF;
3613: --bug 6924639
3614: /*
3615: IF l_return_status <>FND_API.g_ret_sts_success THEN
3616: IF (l_debug=1) THEN
3617: print_debug('Last operation in plan - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3618: END IF;
3619:

Line 3620: RAISE FND_API.G_EXC_ERROR;

3616: IF (l_debug=1) THEN
3617: print_debug('Last operation in plan - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3618: END IF;
3619:
3620: RAISE FND_API.G_EXC_ERROR;
3621: END IF;
3622: */
3623: END IF; -- IF p_activity_id = g_op_activity_inbound
3624:

Line 3643: RAISE FND_API.G_EXC_ERROR;

3639:
3640: fnd_message.set_name('WMS', 'WMS_ATF_NO_NEXT_OPERATION');
3641: fnd_msg_pub.ADD;
3642:
3643: RAISE FND_API.G_EXC_ERROR;
3644:
3645: END IF;
3646:
3647: CLOSE c_next_plan_detail;

Line 3741: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3737: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);
3738: print_debug('x_source_task_id => '||l_new_mmtt_id, l_module_name,4);
3739: print_debug('x_error_code => '||l_atf_error_code, l_module_name,4);
3740: END IF;
3741: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3742: IF (l_debug = 1) THEN
3743: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3744: END IF;
3745:

Line 3748: RAISE fnd_api.g_exc_unexpected_error;

3744: END IF;
3745:
3746: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3747: fnd_msg_pub.ADD;
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3750: IF (l_debug = 1) THEN
3751: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3752: END IF;

Line 3749: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

3745:
3746: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3747: fnd_msg_pub.ADD;
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3750: IF (l_debug = 1) THEN
3751: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3752: END IF;
3753:

Line 3756: RAISE fnd_api.g_exc_error;

3752: END IF;
3753:
3754: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3755: fnd_msg_pub.ADD;
3756: RAISE fnd_api.g_exc_error;
3757: END IF;
3758:
3759:
3760: END IF; -- IF p_activity_id = g_op_activity_inbound

Line 3785: IF l_return_status <>FND_API.g_ret_sts_success THEN

3781: IF (l_debug=1) THEN
3782: print_debug('After calling wms_op_runtime_pvt_apis.insert_operation_instance:' ,l_module_name,4);
3783: END IF;
3784:
3785: IF l_return_status <>FND_API.g_ret_sts_success THEN
3786: IF (l_debug=1) THEN
3787: print_debug('wms_op_runtime_pvt_apis.insert_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3788: END IF;
3789:

Line 3790: RAISE FND_API.G_EXC_ERROR;

3786: IF (l_debug=1) THEN
3787: print_debug('wms_op_runtime_pvt_apis.insert_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3788: END IF;
3789:
3790: RAISE FND_API.G_EXC_ERROR;
3791: END IF;
3792:
3793:
3794: END IF; -- IF l_last_op_sequence = l_wooi_data_rec.operation_sequence

Line 3808: WHEN fnd_api.g_exc_error THEN

3804: END IF;
3805:
3806: EXCEPTION
3807:
3808: WHEN fnd_api.g_exc_error THEN
3809: IF (l_debug=1) THEN
3810: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
3811: END IF;
3812: x_return_status:=FND_API.G_RET_STS_ERROR;

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

3806: EXCEPTION
3807:
3808: WHEN fnd_api.g_exc_error THEN
3809: IF (l_debug=1) THEN
3810: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
3811: END IF;
3812: x_return_status:=FND_API.G_RET_STS_ERROR;
3813: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3814: fnd_msg_pub.ADD;

Line 3812: x_return_status:=FND_API.G_RET_STS_ERROR;

3808: WHEN fnd_api.g_exc_error THEN
3809: IF (l_debug=1) THEN
3810: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
3811: END IF;
3812: x_return_status:=FND_API.G_RET_STS_ERROR;
3813: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3814: fnd_msg_pub.ADD;
3815: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3816: ROLLBACK TO sp_complete_oprtn_instance;

Line 3840: WHEN fnd_api.g_exc_unexpected_error THEN

3836: CLOSE c_next_plan_detail;
3837: END IF;
3838:
3839:
3840: WHEN fnd_api.g_exc_unexpected_error THEN
3841:
3842: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3843: IF (l_debug=1) THEN
3844: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 3842: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

3838:
3839:
3840: WHEN fnd_api.g_exc_unexpected_error THEN
3841:
3842: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3843: IF (l_debug=1) THEN
3844: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3845: END IF;
3846: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

3840: WHEN fnd_api.g_exc_unexpected_error THEN
3841:
3842: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3843: IF (l_debug=1) THEN
3844: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3845: END IF;
3846: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3847: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3848: END IF;

Line 3877: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

3873: END IF;
3874:
3875: WHEN OTHERS THEN
3876:
3877: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3878: IF (l_debug=1) THEN
3879: print_debug('Other Error occured at '||l_progress,l_module_name,1);
3880: IF SQLCODE IS NOT NULL AND SQLCODE >= -20000
3881: THEN

Line 4769: WHEN FND_API.G_EXC_ERROR THEN

4765:
4766: END IF;/*Activity Type =Inbound*/
4767:
4768: EXCEPTION
4769: WHEN FND_API.G_EXC_ERROR THEN
4770: x_return_status:=g_ret_sts_error;
4771: IF mol_details%ISOPEN THEN
4772: CLOSE mol_details;
4773: END IF;

Line 4794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4790: END IF;
4791:
4792: /*Populate error message and error Code*/
4793:
4794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4795: x_return_status:=g_ret_sts_unexp_error;
4796:
4797: IF (l_debug=1) THEN
4798: print_debug('Unexpected error'||SQLERRM||l_progress,l_module_name,1);

Line 5268: RAISE FND_API.G_EXC_ERROR;

5264:
5265: IF (l_debug=1) THEN
5266: print_debug('Item -Org combnation not found',l_module_name,1);
5267: END IF;
5268: RAISE FND_API.G_EXC_ERROR;
5269:
5270: END IF;
5271:
5272: CLOSE c_item_details;

Line 5502: RAISE FND_API.G_EXC_ERROR;

5498: , p_primary_qty => l_inbound_doc_parent_split_rec.primary_quantity
5499: );
5500:
5501: IF (x_return_status=g_ret_sts_error) THEN
5502: RAISE FND_API.G_EXC_ERROR;
5503: ELSIF (x_return_status<>g_ret_sts_success) THEN
5504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5505: END IF;
5506:

Line 5504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5500:
5501: IF (x_return_status=g_ret_sts_error) THEN
5502: RAISE FND_API.G_EXC_ERROR;
5503: ELSIF (x_return_status<>g_ret_sts_success) THEN
5504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5505: END IF;
5506:
5507:
5508: l_progress := 120;

Line 5530: RAISE FND_API.G_EXC_ERROR;

5526:
5527: IF (l_debug=1) THEN
5528: print_debug('Item -Org combnation not found',l_module_name,1);
5529: END IF;
5530: RAISE FND_API.G_EXC_ERROR;
5531:
5532: END IF;
5533:
5534: CLOSE c_item_details;

Line 5750: RAISE FND_API.G_EXC_ERROR;

5746: x_msg_data => x_msg_data ,
5747: p_insert_rec => l_wopi_split_rec );
5748:
5749: IF (x_return_status=g_ret_sts_error) THEN
5750: RAISE FND_API.G_EXC_ERROR;
5751: ELSIF (x_return_status<>g_ret_sts_success) THEN
5752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5753: END IF;
5754: /* BEGIN: GRACE11-02-2003

Line 5752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5748:
5749: IF (x_return_status=g_ret_sts_error) THEN
5750: RAISE FND_API.G_EXC_ERROR;
5751: ELSIF (x_return_status<>g_ret_sts_success) THEN
5752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5753: END IF;
5754: /* BEGIN: GRACE11-02-2003
5755: * For each new WOPI that we are creating, we should copy all WDTH
5756: * records from the the original WOPI, and link these new WDTH

Line 6082: RAISE FND_API.G_EXC_ERROR;

6078: print_debug('Return Status from table handler',l_module_name,9);
6079: END IF;
6080:
6081: IF (x_return_status=g_ret_sts_error) THEN
6082: RAISE FND_API.G_EXC_ERROR;
6083: ELSIF (x_return_status<>g_ret_sts_success) THEN
6084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6085: END IF;
6086:

Line 6084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6080:
6081: IF (x_return_status=g_ret_sts_error) THEN
6082: RAISE FND_API.G_EXC_ERROR;
6083: ELSIF (x_return_status<>g_ret_sts_success) THEN
6084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6085: END IF;
6086:
6087: END LOOP;
6088: CLOSE wooi_cursor;

Line 6212: WHEN FND_API.G_EXC_ERROR THEN

6208: /* END: GRACE11-02-2003 */
6209:
6210: END LOOP;
6211: EXCEPTION
6212: WHEN FND_API.G_EXC_ERROR THEN
6213: IF (l_debug=1) THEN
6214: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
6215: END IF;
6216:

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

6210: END LOOP;
6211: EXCEPTION
6212: WHEN FND_API.G_EXC_ERROR THEN
6213: IF (l_debug=1) THEN
6214: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
6215: END IF;
6216:
6217: IF (inbound_document_details%ISOPEN) THEN
6218: CLOSE inbound_document_details;

Line 6237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6233: ROLLBACK TO split_op_instance_sp;
6234:
6235: x_return_status:=g_ret_sts_error;
6236:
6237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6238: IF (l_debug=1) THEN
6239: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,1);
6240: --print_debug('UnExpected Error: '||SQLERRM,l_module_name,1);
6241: END IF;

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

6235: x_return_status:=g_ret_sts_error;
6236:
6237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6238: IF (l_debug=1) THEN
6239: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,1);
6240: --print_debug('UnExpected Error: '||SQLERRM,l_module_name,1);
6241: END IF;
6242:
6243: IF (inbound_document_details%ISOPEN) THEN

Line 6380: RAISE FND_API.G_EXC_ERROR;

6376: IF p_source_task_id IS NULL THEN
6377: IF (l_debug=1) THEN
6378: print_debug('Invalid input param. p_source_task_id Cannot be NULL.',l_module_name,4);
6379: END IF;
6380: RAISE FND_API.G_EXC_ERROR;
6381: END IF;
6382:
6383:
6384: IF p_activity_type_id IS NULL THEN

Line 6388: RAISE FND_API.G_EXC_ERROR;

6384: IF p_activity_type_id IS NULL THEN
6385: IF (l_debug=1) THEN
6386: print_debug('Invalid input param. p_activity_type_id Cannot be NULL.',l_module_name,4);
6387: END IF;
6388: RAISE FND_API.G_EXC_ERROR;
6389: END IF;
6390:
6391:
6392: l_progress := 20;

Line 6406: RAISE FND_API.G_EXC_ERROR;

6402: WHEN no_data_found THEN
6403: IF (l_debug=1) THEN
6404: print_debug('WDT does not exist for this MMTT.',l_module_name,4);
6405: END IF;
6406: RAISE FND_API.G_EXC_ERROR;
6407:
6408: END;
6409:
6410: l_progress := 30;

Line 6423: RAISE FND_API.G_EXC_ERROR;

6419: print_debug('Invalid WDT status.' ,l_module_name,4);
6420: END IF;
6421: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
6422: fnd_msg_pub.ADD;
6423: RAISE FND_API.G_EXC_ERROR;
6424: END IF; -- IF l_wdt_status NOT IN (g_task_status_loaded, g_task_status_dispatched)
6425:
6426:
6427: IF l_wdt_status = g_task_status_dispatched THEN

Line 6470: RAISE FND_API.G_EXC_ERROR;

6466: IF c_inbound_document_details%notfound THEN
6467: IF (l_debug=1) THEN
6468: print_debug('Invalid input param. p_source_task_id does not match to an MMTT record.',l_module_name,4);
6469: END IF;
6470: RAISE FND_API.G_EXC_ERROR;
6471: END IF;
6472:
6473: CLOSE c_inbound_document_details;
6474:

Line 6519: IF l_return_status <>FND_API.g_ret_sts_success THEN

6515: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6516: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6517: END IF;
6518:
6519: IF l_return_status <>FND_API.g_ret_sts_success THEN
6520: IF (l_debug=1) THEN
6521: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6522: END IF;
6523:

Line 6524: RAISE FND_API.G_EXC_ERROR;

6520: IF (l_debug=1) THEN
6521: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6522: END IF;
6523:
6524: RAISE FND_API.G_EXC_ERROR;
6525: END IF;
6526:
6527: END IF;
6528:

Line 6545: RAISE FND_API.G_EXC_ERROR;

6541: print_debug('Active operation instance record does not exist for this task.',l_module_name,4);
6542: END IF;
6543: fnd_message.set_name('WMS', 'WMS_ATF_NO_ACTIVE_PLAN');
6544: fnd_msg_pub.ADD;
6545: RAISE FND_API.G_EXC_ERROR;
6546: END IF;
6547:
6548: CLOSE c_wooi_data_rec;
6549:

Line 6587: IF l_return_status <>FND_API.g_ret_sts_success THEN

6583: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6584: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6585: END IF;
6586:
6587: IF l_return_status <>FND_API.g_ret_sts_success THEN
6588: IF (l_debug=1) THEN
6589: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6590: END IF;
6591:

Line 6592: RAISE FND_API.G_EXC_ERROR;

6588: IF (l_debug=1) THEN
6589: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6590: END IF;
6591:
6592: RAISE FND_API.G_EXC_ERROR;
6593: END IF;
6594:
6595: BEGIN
6596: -- If this the first operation within a plan,

Line 6618: RAISE FND_API.G_EXC_ERROR;

6614: IF (l_debug=1) THEN
6615: print_debug('Exception when getting min operation_sequence.' ,l_module_name,4);
6616: END IF;
6617:
6618: RAISE FND_API.G_EXC_ERROR;
6619: END;
6620:
6621:
6622: IF l_first_op_sequence = l_wooi_data_rec.operation_sequence AND

Line 6657: IF l_return_status <>FND_API.g_ret_sts_success THEN

6653: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6654: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6655: END IF;
6656:
6657: IF l_return_status <>FND_API.g_ret_sts_success THEN
6658: IF (l_debug=1) THEN
6659: print_debug('wms_op_runtime_pvt_apis.Update_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6660: END IF;
6661:

Line 6662: RAISE FND_API.G_EXC_ERROR;

6658: IF (l_debug=1) THEN
6659: print_debug('wms_op_runtime_pvt_apis.Update_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6660: END IF;
6661:
6662: RAISE FND_API.G_EXC_ERROR;
6663: END IF;
6664:
6665:
6666: END IF; -- IF l_first_op_sequence = l_wooi_data_rec.operation_sequence

Line 6694: IF l_return_status <>FND_API.g_ret_sts_success THEN

6690: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6691: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6692: END IF;
6693:
6694: IF l_return_status <>FND_API.g_ret_sts_success THEN
6695: IF (l_debug=1) THEN
6696: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6697: END IF;
6698:

Line 6699: RAISE FND_API.G_EXC_ERROR;

6695: IF (l_debug=1) THEN
6696: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6697: END IF;
6698:
6699: RAISE FND_API.G_EXC_ERROR;
6700: END IF;
6701:
6702:
6703: END IF; -- IF l_wooi_data_rec.operation_type_id = g_op_type_drop

Line 6720: WHEN fnd_api.g_exc_error THEN

6716: END IF;
6717:
6718: EXCEPTION
6719:
6720: WHEN fnd_api.g_exc_error THEN
6721: IF (l_debug=1) THEN
6722: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
6723: END IF;
6724: x_return_status:=FND_API.G_RET_STS_ERROR;

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

6718: EXCEPTION
6719:
6720: WHEN fnd_api.g_exc_error THEN
6721: IF (l_debug=1) THEN
6722: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
6723: END IF;
6724: x_return_status:=FND_API.G_RET_STS_ERROR;
6725: ROLLBACK TO sp_cleanup_oprtn_instance;
6726:

Line 6724: x_return_status:=FND_API.G_RET_STS_ERROR;

6720: WHEN fnd_api.g_exc_error THEN
6721: IF (l_debug=1) THEN
6722: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
6723: END IF;
6724: x_return_status:=FND_API.G_RET_STS_ERROR;
6725: ROLLBACK TO sp_cleanup_oprtn_instance;
6726:
6727: IF c_inbound_document_details%isopen THEN
6728: CLOSE c_inbound_document_details;

Line 6737: WHEN fnd_api.g_exc_unexpected_error THEN

6733: END IF;
6734: fnd_message.set_name('WMS', 'WMS_ATF_CLEANUP_FAILURE');
6735: fnd_msg_pub.ADD;
6736:
6737: WHEN fnd_api.g_exc_unexpected_error THEN
6738:
6739: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
6740: IF (l_debug=1) THEN
6741: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 6739: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

6735: fnd_msg_pub.ADD;
6736:
6737: WHEN fnd_api.g_exc_unexpected_error THEN
6738:
6739: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
6740: IF (l_debug=1) THEN
6741: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
6742: END IF;
6743: ROLLBACK TO sp_cleanup_oprtn_instance;

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

6737: WHEN fnd_api.g_exc_unexpected_error THEN
6738:
6739: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
6740: IF (l_debug=1) THEN
6741: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
6742: END IF;
6743: ROLLBACK TO sp_cleanup_oprtn_instance;
6744:
6745: IF c_inbound_document_details%isopen THEN

Line 6758: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

6754: fnd_msg_pub.ADD;
6755:
6756: WHEN OTHERS THEN
6757:
6758: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
6759: IF (l_debug=1) THEN
6760: print_debug('Other Error occured at '||l_progress,l_module_name,1);
6761: IF SQLCODE IS NOT NULL THEN
6762: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);

Line 6989: RAISE FND_API.G_EXC_ERROR;

6985: print_debug('Return status from table handler'||x_return_status,l_module_name,9);
6986: END IF;
6987:
6988: IF (x_return_status=g_ret_sts_error) THEN
6989: RAISE FND_API.G_EXC_ERROR;
6990:
6991: ELSIF (x_return_status<>g_ret_sts_success) THEN
6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6993:

Line 6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6988: IF (x_return_status=g_ret_sts_error) THEN
6989: RAISE FND_API.G_EXC_ERROR;
6990:
6991: ELSIF (x_return_status<>g_ret_sts_success) THEN
6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6993:
6994: END IF;
6995:
6996: l_progress:=120;

Line 7024: RAISE FND_API.G_EXC_ERROR;

7020: END IF;
7021:
7022: IF (x_return_status=g_ret_sts_error) THEN
7023:
7024: RAISE FND_API.G_EXC_ERROR;
7025:
7026: ELSIF (x_return_status<>g_ret_sts_success) THEN
7027:
7028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7024: RAISE FND_API.G_EXC_ERROR;
7025:
7026: ELSIF (x_return_status<>g_ret_sts_success) THEN
7027:
7028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7029:
7030: END IF;
7031:
7032:

Line 7055: RAISE FND_API.G_EXC_ERROR;

7051: l_progress:=150;
7052:
7053: IF (x_return_status=g_ret_sts_error) THEN
7054:
7055: RAISE FND_API.G_EXC_ERROR;
7056:
7057: ELSIF (x_return_status<>g_ret_sts_success) THEN
7058:
7059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7055: RAISE FND_API.G_EXC_ERROR;
7056:
7057: ELSIF (x_return_status<>g_ret_sts_success) THEN
7058:
7059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7060:
7061: END IF;
7062:
7063: /*For MMTT.parent_line_id call WMS_OP_RUNTIME_PVT_API.Archive_Dispatched_tasks to Archive WDT*/

Line 7092: RAISE FND_API.G_EXC_ERROR;

7088: l_progress :=170;
7089:
7090: IF (x_return_status=g_ret_sts_error) THEN
7091:
7092: RAISE FND_API.G_EXC_ERROR;
7093:
7094: ELSIF (x_return_status<>g_ret_sts_success) THEN
7095:
7096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7092: RAISE FND_API.G_EXC_ERROR;
7093:
7094: ELSIF (x_return_status<>g_ret_sts_success) THEN
7095:
7096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7097:
7098: END IF;
7099:
7100: IF (p_activity_type_id = G_OP_ACTIVITY_INBOUND) THEN

Line 7129: IF x_return_status <>FND_API.g_ret_sts_success THEN

7125: print_debug('x_msg_data => '|| x_msg_data,l_module_name,4);
7126: print_debug('x_msg_count => '|| x_msg_count,l_module_name,4);
7127: END IF;
7128:
7129: IF x_return_status <>FND_API.g_ret_sts_success THEN
7130: IF (l_debug=1) THEN
7131: print_debug('wms_op_inbound_pvt.cancel finished with error. x_return_status = ' || x_return_status,l_module_name,4);
7132: END IF;
7133:

Line 7134: RAISE FND_API.G_EXC_ERROR;

7130: IF (l_debug=1) THEN
7131: print_debug('wms_op_inbound_pvt.cancel finished with error. x_return_status = ' || x_return_status,l_module_name,4);
7132: END IF;
7133:
7134: RAISE FND_API.G_EXC_ERROR;
7135: END IF;
7136:
7137: l_progress := 200;
7138: END IF; -- IF (p_activity_type_id = G_OP_ACTIVITY_INBOUND)

Line 7142: WHEN FND_API.G_EXC_ERROR THEN

7138: END IF; -- IF (p_activity_type_id = G_OP_ACTIVITY_INBOUND)
7139:
7140: EXCEPTION
7141:
7142: WHEN FND_API.G_EXC_ERROR THEN
7143:
7144: IF (l_debug=1) THEN
7145: print_debug('Expected Error Obtained at'||l_progress,l_module_name,1);
7146: END IF;

Line 7161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7157: ROLLBACK TO cancel_op_plan_sp;
7158:
7159: x_return_status:=g_ret_sts_error;
7160:
7161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7162:
7163: IF (l_debug=1) THEN
7164: print_debug('UnExpected Error Obtained at'||l_progress||SQLERRM,l_module_name,1);
7165: END IF;

Line 7456: RAISE FND_API.G_EXC_ERROR;

7452: print_debug('Return status from table handler'||x_return_status,l_module_name,9);
7453: END IF;
7454:
7455: IF (x_return_status=g_ret_sts_error) THEN
7456: RAISE FND_API.G_EXC_ERROR;
7457:
7458: ELSIF (x_return_status<>g_ret_sts_success) THEN
7459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7460:

Line 7459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7455: IF (x_return_status=g_ret_sts_error) THEN
7456: RAISE FND_API.G_EXC_ERROR;
7457:
7458: ELSIF (x_return_status<>g_ret_sts_success) THEN
7459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7460:
7461: END IF;
7462:
7463: l_progress:=100;

Line 7491: RAISE FND_API.G_EXC_ERROR;

7487: END IF;
7488:
7489: IF (x_return_status=g_ret_sts_error) THEN
7490:
7491: RAISE FND_API.G_EXC_ERROR;
7492:
7493: ELSIF (x_return_status<>g_ret_sts_success) THEN
7494:
7495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7491: RAISE FND_API.G_EXC_ERROR;
7492:
7493: ELSIF (x_return_status<>g_ret_sts_success) THEN
7494:
7495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7496:
7497: END IF;
7498:
7499:

Line 7523: RAISE FND_API.G_EXC_ERROR;

7519: l_progress:=130;
7520:
7521: IF (x_return_status=g_ret_sts_error) THEN
7522:
7523: RAISE FND_API.G_EXC_ERROR;
7524:
7525: ELSIF (x_return_status<>g_ret_sts_success) THEN
7526:
7527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7523: RAISE FND_API.G_EXC_ERROR;
7524:
7525: ELSIF (x_return_status<>g_ret_sts_success) THEN
7526:
7527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7528:
7529: END IF;
7530:
7531: /*For MMTT.parent_line_id call WMS_OP_RUNTIME_PVT_API.Archive_Dispatched_tasks to Archive WDT*/

Line 7560: RAISE FND_API.G_EXC_ERROR;

7556: l_progress :=150;
7557:
7558: IF (x_return_status=g_ret_sts_error) THEN
7559:
7560: RAISE FND_API.G_EXC_ERROR;
7561:
7562: ELSIF (x_return_status<>g_ret_sts_success) THEN
7563:
7564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7560: RAISE FND_API.G_EXC_ERROR;
7561:
7562: ELSIF (x_return_status<>g_ret_sts_success) THEN
7563:
7564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7565:
7566: END IF;
7567:
7568: IF (p_activity_type_id = G_OP_ACTIVITY_INBOUND) THEN

Line 7588: RAISE FND_API.G_EXC_ERROR;

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

Line 7592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7588: RAISE FND_API.G_EXC_ERROR;
7589:
7590: ELSIF (x_return_status<>g_ret_sts_success) THEN
7591:
7592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7593:
7594: END IF;
7595:
7596: l_progress:=170;

Line 7668: IF l_return_status <> FND_API.g_ret_sts_success THEN

7664: print_debug('x_msg_data => '||l_msg_data,l_module_name,4);
7665: print_debug('x_msg_count => '||l_msg_count,l_module_name,4);
7666: END IF;
7667:
7668: IF l_return_status <> FND_API.g_ret_sts_success THEN
7669: IF (l_debug=1) THEN
7670: print_debug(' wms_op_inbound_pvt.ABORT finished with error. l_return_status = ' || l_return_status,l_module_name,4);
7671: END IF;
7672:

Line 7673: RAISE FND_API.G_EXC_ERROR;

7669: IF (l_debug=1) THEN
7670: print_debug(' wms_op_inbound_pvt.ABORT finished with error. l_return_status = ' || l_return_status,l_module_name,4);
7671: END IF;
7672:
7673: RAISE FND_API.G_EXC_ERROR;
7674: END IF;
7675:
7676: IF l_debug=1 THEN
7677: print_debug('Need to update the WDT /WDTH records nulling out operation Plan id',l_module_name,9);

Line 7720: WHEN FND_API.G_EXC_ERROR THEN

7716: /*Need for calling a document handler or not..mostly not*/
7717:
7718: EXCEPTION
7719:
7720: WHEN FND_API.G_EXC_ERROR THEN
7721:
7722: IF (l_debug=1) THEN
7723: print_debug('Expected Error Obtained at'||l_progress,l_module_name,1);
7724: END IF;

Line 7742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7738: ROLLBACK TO abort_plan_sp;
7739:
7740: x_return_status:=g_ret_sts_error;
7741:
7742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7743:
7744: IF (l_debug=1) THEN
7745: print_debug('UnExpected Error Obtained at'||l_progress||SQLERRM,l_module_name,1);
7746: END IF;

Line 8013: RAISE FND_API.G_EXC_ERROR;

8009: END IF;
8010:
8011:
8012: IF (x_return_status=g_ret_sts_error) THEN
8013: RAISE FND_API.G_EXC_ERROR;
8014:
8015: ELSIF (x_return_status<>g_ret_sts_success) THEN
8016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8017:

Line 8016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8012: IF (x_return_status=g_ret_sts_error) THEN
8013: RAISE FND_API.G_EXC_ERROR;
8014:
8015: ELSIF (x_return_status<>g_ret_sts_success) THEN
8016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8017:
8018: END IF;
8019: end if ;
8020:

Line 8099: RAISE FND_API.G_EXC_ERROR;

8095: print_debug('Return Status from Update Operation Instance is '||x_return_status,l_module_name,9);
8096: END IF;
8097:
8098: IF (x_return_status=g_ret_sts_error) THEN
8099: RAISE FND_API.G_EXC_ERROR;
8100:
8101: ELSIF (x_return_status<>g_ret_sts_success) THEN
8102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8103:

Line 8102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8098: IF (x_return_status=g_ret_sts_error) THEN
8099: RAISE FND_API.G_EXC_ERROR;
8100:
8101: ELSIF (x_return_status<>g_ret_sts_success) THEN
8102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8103:
8104: END IF;
8105:
8106: l_op_plan_instance_id := l_wooi_data_rec.op_plan_instance_id;

Line 8178: RAISE FND_API.G_EXC_ERROR;

8174: print_debug('Return Status from Delete Operation Instance '||x_return_status,l_module_name,9);
8175: END IF;
8176:
8177: IF (x_return_status=g_ret_sts_error) THEN
8178: RAISE FND_API.G_EXC_ERROR;
8179:
8180: ELSIF (x_return_status<>g_ret_sts_success) THEN
8181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8182:

Line 8181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8177: IF (x_return_status=g_ret_sts_error) THEN
8178: RAISE FND_API.G_EXC_ERROR;
8179:
8180: ELSIF (x_return_status<>g_ret_sts_success) THEN
8181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8182:
8183: END IF;
8184:
8185: END IF; /*Operation Type Drop*/

Line 8243: RAISE FND_API.G_EXC_ERROR;

8239: print_debug('Return Status from Update Plan Instance'||x_return_status,l_module_name,9);
8240: END IF;
8241:
8242: IF (x_return_status=g_ret_sts_error) THEN
8243: RAISE FND_API.G_EXC_ERROR;
8244:
8245: ELSIF (x_return_status<>g_ret_sts_success) THEN
8246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8247:

Line 8246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8242: IF (x_return_status=g_ret_sts_error) THEN
8243: RAISE FND_API.G_EXC_ERROR;
8244:
8245: ELSIF (x_return_status<>g_ret_sts_success) THEN
8246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8247:
8248: END IF;
8249:
8250: END IF;/*First Operation in Plan*/

Line 8272: RAISE FND_API.G_EXC_ERROR;

8268: END IF;
8269:
8270:
8271: IF (x_return_status=g_ret_sts_error) THEN
8272: RAISE FND_API.G_EXC_ERROR;
8273:
8274: ELSIF (x_return_status<>g_ret_sts_success) THEN
8275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8276:

Line 8275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8271: IF (x_return_status=g_ret_sts_error) THEN
8272: RAISE FND_API.G_EXC_ERROR;
8273:
8274: ELSIF (x_return_status<>g_ret_sts_success) THEN
8275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8276:
8277: END IF;
8278:
8279:

Line 8294: WHEN FND_API.G_EXC_ERROR THEN

8290: END IF;/*Activity is Inbound*/
8291:
8292: EXCEPTION
8293:
8294: WHEN FND_API.G_EXC_ERROR THEN
8295:
8296: IF (l_debug=1) THEN
8297: print_debug('Expected Error Obtained at'||l_progress,l_module_name,1);
8298: END IF;

Line 8320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8316: x_return_status := g_ret_sts_error;
8317:
8318: ROLLBACK TO rollback_op_plan_sp;
8319:
8320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8321:
8322: IF (l_debug=1) THEN
8323: print_debug('Expected Error Obtained at'||l_progress,l_module_name,1);
8324: END IF;

Line 8470: /RAISE fnd_api.g_exc_error;/

8466: */
8467:
8468: IF (p_source_task_id IS NULL OR p_activity_type_id IS NULL) THEN
8469:
8470: /*RAISE fnd_api.g_exc_error;*/
8471: RAISE_APPLICATION_ERROR(INVALID_INPUT,'Invalid inputs passed'||p_source_task_id||p_activity_type_id);
8472:
8473: END IF; /* p_source_task_id IS...*/
8474:

Line 8508: /RAISE fnd_api.g_exc_error;/

8504: */
8505:
8506: IF l_plan_id = -1 THEN
8507:
8508: /*RAISE fnd_api.g_exc_error;*/
8509: RAISE_APPLICATION_ERROR(INVALID_DOC_ID,'Document Record does not exist for Source_task_id'||p_source_task_id);
8510:
8511: END IF; /* l_plan_id = -1 */
8512:

Line 8580: /*WHEN FND_API.G_EXC_ERROR THEN

8576: );
8577:
8578: EXCEPTION
8579:
8580: /*WHEN FND_API.G_EXC_ERROR THEN
8581: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8582:
8583: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
8584: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);