450: END IF;
451:
452: END IF;
453:
454: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
455:
456: EXCEPTION
457: WHEN fnd_api.g_exc_error THEN
458: IF (l_debug=1) THEN
466: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
467: IF (l_debug=1) THEN
468: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
469: END IF;
470: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
471: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
472: END IF;
473: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
474:
467: IF (l_debug=1) THEN
468: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
469: END IF;
470: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
471: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
472: END IF;
473: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
474:
475: END;
469: END IF;
470: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
471: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
472: END IF;
473: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
474:
475: END;
476:
477: /**
664: END IF;
665:
666: END IF;
667:
668: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
669:
670: EXCEPTION
671: WHEN fnd_api.g_exc_error THEN
672: IF (l_debug=1) THEN
680: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
681: IF (l_debug=1) THEN
682: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
683: END IF;
684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
685: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
686: END IF;
687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
688:
681: IF (l_debug=1) THEN
682: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
683: END IF;
684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
685: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
686: END IF;
687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
688:
689: END activate;
683: END IF;
684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
685: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
686: END IF;
687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
688:
689: END activate;
690:
691:
1343: print_debug('Error callinf WF wrapper',l_module_name,4);
1344: END IF;
1345:
1346: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
1347: fnd_msg_pub.ADD;
1348: RAISE fnd_api.g_exc_unexpected_error;
1349: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1350: IF (l_debug = 1) THEN
1351: print_debug('Error calling WF wrapper',l_module_name,4);
1351: print_debug('Error calling WF wrapper',l_module_name,4);
1352: END IF;
1353:
1354: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
1355: fnd_msg_pub.ADD;
1356: RAISE fnd_api.g_exc_error;
1357: END IF;
1358: END IF; -- END IF (l_wf > 0)
1359: END IF; -- END IF reason id is not null
2125: END IF;
2126:
2127: END IF;
2128:
2129: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2130:
2131: IF (l_debug=1) THEN
2132: print_debug('x_return_status => '||x_return_status,l_module_name,1);
2133: print_debug('x_msg_data => '||x_msg_data,l_module_name,1);
2144: IF (l_debug=1) THEN
2145: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2146: END IF;
2147: x_return_status:=FND_API.G_RET_STS_ERROR;
2148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2149:
2150: IF c_mmtt_data_rec%isopen THEN
2151: CLOSE c_mmtt_data_rec;
2152: END IF;
2157: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2158: IF (l_debug=1) THEN
2159: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2160: END IF;
2161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2162: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2163: END IF;
2164: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2165:
2158: IF (l_debug=1) THEN
2159: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2160: END IF;
2161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2162: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2163: END IF;
2164: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2165:
2166: IF c_mmtt_data_rec%isopen THEN
2160: END IF;
2161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2162: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2163: END IF;
2164: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2165:
2166: IF c_mmtt_data_rec%isopen THEN
2167: CLOSE c_mmtt_data_rec;
2168: END IF;
2176: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);
2177: END IF;
2178: END IF;
2179:
2180: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2181: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2182: END IF;
2183: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2184:
2177: END IF;
2178: END IF;
2179:
2180: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2181: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2182: END IF;
2183: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2184:
2185: IF c_mmtt_data_rec%isopen THEN
2179:
2180: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2181: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2182: END IF;
2183: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2184:
2185: IF c_mmtt_data_rec%isopen THEN
2186: CLOSE c_mmtt_data_rec;
2187: END IF;
2436: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2437: IF (l_debug=1) THEN
2438: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2439: END IF;
2440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2441: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2442: END IF;
2443: IF c_mmtt_data_rec%isopen THEN
2444: CLOSE c_mmtt_data_rec;
2437: IF (l_debug=1) THEN
2438: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2439: END IF;
2440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2441: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2442: END IF;
2443: IF c_mmtt_data_rec%isopen THEN
2444: CLOSE c_mmtt_data_rec;
2445: END IF;
2458: IF c_mmtt_data_rec%isopen THEN
2459: CLOSE c_mmtt_data_rec;
2460: END IF;
2461:
2462: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2463: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2464: END IF;
2465:
2466: ROLLBACK TO sp_op_inbound_cleanup;
2459: CLOSE c_mmtt_data_rec;
2460: END IF;
2461:
2462: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2463: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2464: END IF;
2465:
2466: ROLLBACK TO sp_op_inbound_cleanup;
2467:
2803: IF l_debug = 1 THEN
2804: print_debug('Sub/Loc cannot be null for loaded LPN:'||l_subinventory_code||':'||l_locator_id,l_module_name,4);
2805: END IF;
2806: fnd_message.set_name('WMS','WMS_UNLD_TASK_INFO_ERR');
2807: fnd_msg_pub.ADD;
2808: RAISE fnd_api.g_exc_error;
2809: END IF;
2810: ELSE
2811: IF (l_debug=1) THEN
2946: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2947: IF (l_debug=1) THEN
2948: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2949: END IF;
2950: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2951: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2952: END IF;
2953: ROLLBACK TO sp_op_inbound_cancel;
2954: IF c_mmtt_data_rec%isopen THEN
2947: IF (l_debug=1) THEN
2948: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2949: END IF;
2950: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2951: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2952: END IF;
2953: ROLLBACK TO sp_op_inbound_cancel;
2954: IF c_mmtt_data_rec%isopen THEN
2955: CLOSE c_mmtt_data_rec;
2964: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);
2965: END IF;
2966: END IF;
2967:
2968: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2969: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2970: END IF;
2971:
2972: ROLLBACK TO sp_op_inbound_cancel;
2965: END IF;
2966: END IF;
2967:
2968: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2969: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2970: END IF;
2971:
2972: ROLLBACK TO sp_op_inbound_cancel;
2973: IF c_mmtt_data_rec%isopen THEN