DBA Data[Home] [Help]

APPS.WMS_OP_INBOUND_PVT dependencies on FND_MSG_PUB

Line 171: fnd_msg_pub.ADD;

167: -- Start of Bug 12861439 change
168: -- The message 'Error: Validation of Lot/Serial failed' will be
169: -- shown on Oracle mobile when this case occurs
170: fnd_message.set_name('WMS', 'WMS_LOT_SER_VALIDATION_FAIL');
171: fnd_msg_pub.ADD;
172: -- End of Bug 12861439 change
173:
174: /* Throwing exception for this condition as of now as Invalid document record*/
175: RAISE FND_API.G_EXC_ERROR;

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

460: END IF;
461:
462: END IF;
463:
464: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
465:
466: EXCEPTION
467: WHEN fnd_api.g_exc_error THEN
468: IF (l_debug=1) THEN

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

476: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
477: IF (l_debug=1) THEN
478: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
479: END IF;
480: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
481: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
482: END IF;
483: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
484:

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

477: IF (l_debug=1) THEN
478: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
479: END IF;
480: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
481: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
482: END IF;
483: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
484:
485: END;

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

479: END IF;
480: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
481: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
482: END IF;
483: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
484:
485: END;
486:
487: /**

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

675: END IF;
676:
677: END IF;
678:
679: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
680:
681: EXCEPTION
682: WHEN fnd_api.g_exc_error THEN
683: IF (l_debug=1) THEN

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

691: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
692: IF (l_debug=1) THEN
693: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
694: END IF;
695: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
696: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
697: END IF;
698: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
699:

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

692: IF (l_debug=1) THEN
693: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
694: END IF;
695: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
696: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
697: END IF;
698: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
699:
700: END activate;

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

694: END IF;
695: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
696: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
697: END IF;
698: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
699:
700: END activate;
701:
702:

Line 1386: fnd_msg_pub.ADD;

1382: print_debug('Error callinf WF wrapper',l_module_name,4);
1383: END IF;
1384:
1385: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
1386: fnd_msg_pub.ADD;
1387: RAISE fnd_api.g_exc_unexpected_error;
1388: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1389: IF (l_debug = 1) THEN
1390: print_debug('Error calling WF wrapper',l_module_name,4);

Line 1394: fnd_msg_pub.ADD;

1390: print_debug('Error calling WF wrapper',l_module_name,4);
1391: END IF;
1392:
1393: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
1394: fnd_msg_pub.ADD;
1395: RAISE fnd_api.g_exc_error;
1396: END IF;
1397: END IF; -- END IF (l_wf > 0)
1398: END IF; -- END IF reason id is not null

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

2193: END IF;
2194:
2195: END IF;
2196:
2197: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2198:
2199: IF (l_debug=1) THEN
2200: print_debug('x_return_status => '||x_return_status,l_module_name,1);
2201: print_debug('x_msg_data => '||x_msg_data,l_module_name,1);

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

2212: IF (l_debug=1) THEN
2213: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2214: END IF;
2215: x_return_status:=FND_API.G_RET_STS_ERROR;
2216: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2217:
2218: IF c_mmtt_data_rec%isopen THEN
2219: CLOSE c_mmtt_data_rec;
2220: END IF;

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

2225: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2226: IF (l_debug=1) THEN
2227: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2228: END IF;
2229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2230: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2231: END IF;
2232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2233:

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

2226: IF (l_debug=1) THEN
2227: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2228: END IF;
2229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2230: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2231: END IF;
2232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2233:
2234: IF c_mmtt_data_rec%isopen THEN

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

2228: END IF;
2229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2230: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2231: END IF;
2232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2233:
2234: IF c_mmtt_data_rec%isopen THEN
2235: CLOSE c_mmtt_data_rec;
2236: END IF;

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

2244: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);
2245: END IF;
2246: END IF;
2247:
2248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2249: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2250: END IF;
2251: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2252:

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

2245: END IF;
2246: END IF;
2247:
2248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2249: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2250: END IF;
2251: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2252:
2253: IF c_mmtt_data_rec%isopen THEN

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

2247:
2248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2249: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2250: END IF;
2251: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2252:
2253: IF c_mmtt_data_rec%isopen THEN
2254: CLOSE c_mmtt_data_rec;
2255: END IF;

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

2505: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2506: IF (l_debug=1) THEN
2507: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2508: END IF;
2509: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2510: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2511: END IF;
2512: IF c_mmtt_data_rec%isopen THEN
2513: CLOSE c_mmtt_data_rec;

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

2506: IF (l_debug=1) THEN
2507: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2508: END IF;
2509: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2510: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2511: END IF;
2512: IF c_mmtt_data_rec%isopen THEN
2513: CLOSE c_mmtt_data_rec;
2514: END IF;

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

2527: IF c_mmtt_data_rec%isopen THEN
2528: CLOSE c_mmtt_data_rec;
2529: END IF;
2530:
2531: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2532: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2533: END IF;
2534:
2535: ROLLBACK TO sp_op_inbound_cleanup;

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

2528: CLOSE c_mmtt_data_rec;
2529: END IF;
2530:
2531: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2532: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2533: END IF;
2534:
2535: ROLLBACK TO sp_op_inbound_cleanup;
2536:

Line 2883: fnd_msg_pub.ADD;

2879: IF l_debug = 1 THEN
2880: print_debug('Sub/Loc cannot be null for loaded LPN:'||l_subinventory_code||':'||l_locator_id,l_module_name,4);
2881: END IF;
2882: fnd_message.set_name('WMS','WMS_UNLD_TASK_INFO_ERR');
2883: fnd_msg_pub.ADD;
2884: RAISE fnd_api.g_exc_error;
2885: END IF;
2886: ELSE
2887: IF (l_debug=1) THEN

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

3022: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3023: IF (l_debug=1) THEN
3024: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3025: END IF;
3026: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3027: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3028: END IF;
3029: ROLLBACK TO sp_op_inbound_cancel;
3030: IF c_mmtt_data_rec%isopen THEN

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

3023: IF (l_debug=1) THEN
3024: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3025: END IF;
3026: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3027: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3028: END IF;
3029: ROLLBACK TO sp_op_inbound_cancel;
3030: IF c_mmtt_data_rec%isopen THEN
3031: CLOSE c_mmtt_data_rec;

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

3040: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);
3041: END IF;
3042: END IF;
3043:
3044: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3045: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3046: END IF;
3047:
3048: ROLLBACK TO sp_op_inbound_cancel;

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

3041: END IF;
3042: END IF;
3043:
3044: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3045: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3046: END IF;
3047:
3048: ROLLBACK TO sp_op_inbound_cancel;
3049: IF c_mmtt_data_rec%isopen THEN