DBA Data[Home] [Help]

APPS.WMS_OP_INBOUND_PVT dependencies on FND_MSG_PUB

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

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

Line 470: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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:

Line 471: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);

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;

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

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: /**

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

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

Line 684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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:

Line 685: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);

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;

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

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:

Line 1347: fnd_msg_pub.ADD;

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

Line 1355: fnd_msg_pub.ADD;

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

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

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

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

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;

Line 2161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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:

Line 2162: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);

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

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

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;

Line 2180: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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:

Line 2181: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);

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

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

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;

Line 2440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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;

Line 2441: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);

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;

Line 2462: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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;

Line 2463: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);

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:

Line 2807: fnd_msg_pub.ADD;

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

Line 2950: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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

Line 2951: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);

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;

Line 2968: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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;

Line 2969: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);

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