789: , l_proc
790: , 9);
791: END IF;
792: fnd_message.set_name('INV','INV_MINMAX_NO_ITEM_SETUP');
793: fnd_msg_pub.add;
794: RAISE fnd_api.g_exc_error;
795: END IF;
796: ELSE
797: l_subinv_tbl := p_subinv_tbl;
1012: EXCEPTION
1013: WHEN fnd_api.g_exc_error THEN
1014: ROLLBACK TO sp_exec_min_max;
1015: x_return_status := fnd_api.g_ret_sts_error;
1016: fnd_msg_pub.count_and_get
1017: ( p_count => x_msg_count,
1018: p_data => x_msg_data
1019: );
1020:
1020:
1021: WHEN fnd_api.g_exc_unexpected_error THEN
1022: ROLLBACK TO sp_exec_min_max;
1023: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1024: fnd_msg_pub.count_and_get
1025: ( p_count => x_msg_count,
1026: p_data => x_msg_data
1027: );
1028:
1028:
1029: WHEN OTHERS THEN
1030: ROLLBACK TO sp_exec_min_max;
1031: x_return_status := fnd_api.g_ret_sts_unexp_error;
1032: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1033: fnd_msg_pub.add_exc_msg
1034: ('INV_MMX_WRAPPER_PVT'
1035: ,l_proc
1036: );
1029: WHEN OTHERS THEN
1030: ROLLBACK TO sp_exec_min_max;
1031: x_return_status := fnd_api.g_ret_sts_unexp_error;
1032: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1033: fnd_msg_pub.add_exc_msg
1034: ('INV_MMX_WRAPPER_PVT'
1035: ,l_proc
1036: );
1037: END IF;
1034: ('INV_MMX_WRAPPER_PVT'
1035: ,l_proc
1036: );
1037: END IF;
1038: fnd_msg_pub.count_and_get
1039: ( p_count => x_msg_count,
1040: p_data => x_msg_data
1041: );
1042:
1345: EXCEPTION
1346: WHEN fnd_api.g_exc_error THEN
1347: ROLLBACK TO sp_do_restock;
1348: x_return_status := fnd_api.g_ret_sts_error;
1349: fnd_msg_pub.count_and_get
1350: ( p_count => x_msg_count,
1351: p_data => x_msg_data
1352: );
1353:
1353:
1354: WHEN fnd_api.g_exc_unexpected_error THEN
1355: ROLLBACK TO sp_do_restock;
1356: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1357: fnd_msg_pub.count_and_get
1358: ( p_count => x_msg_count,
1359: p_data => x_msg_data
1360: );
1361:
1361:
1362: WHEN OTHERS THEN
1363: ROLLBACK TO sp_do_restock;
1364: x_return_status := fnd_api.g_ret_sts_unexp_error;
1365: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1366: fnd_msg_pub.add_exc_msg
1367: ( G_PKG_NAME
1368: , l_proc_name
1369: );
1362: WHEN OTHERS THEN
1363: ROLLBACK TO sp_do_restock;
1364: x_return_status := fnd_api.g_ret_sts_unexp_error;
1365: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1366: fnd_msg_pub.add_exc_msg
1367: ( G_PKG_NAME
1368: , l_proc_name
1369: );
1370: END IF;
1367: ( G_PKG_NAME
1368: , l_proc_name
1369: );
1370: END IF;
1371: fnd_msg_pub.count_and_get
1372: ( p_count => x_msg_count,
1373: p_data => x_msg_data
1374: );
1375: END do_restock;
1534: EXCEPTION
1535: WHEN fnd_api.g_exc_error THEN
1536: ROLLBACK TO sp_get_move_order_info;
1537: x_return_status := fnd_api.g_ret_sts_error;
1538: fnd_msg_pub.count_and_get
1539: ( p_count => x_msg_count,
1540: p_data => x_msg_data
1541: );
1542:
1542:
1543: WHEN fnd_api.g_exc_unexpected_error THEN
1544: ROLLBACK TO sp_get_move_order_info;
1545: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1546: fnd_msg_pub.count_and_get
1547: ( p_count => x_msg_count,
1548: p_data => x_msg_data
1549: );
1550:
1550:
1551: WHEN OTHERS THEN
1552: ROLLBACK TO sp_get_move_order_info;
1553: x_return_status := fnd_api.g_ret_sts_unexp_error;
1554: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1555: fnd_msg_pub.add_exc_msg
1556: ( G_PKG_NAME
1557: , l_proc_name
1558: );
1551: WHEN OTHERS THEN
1552: ROLLBACK TO sp_get_move_order_info;
1553: x_return_status := fnd_api.g_ret_sts_unexp_error;
1554: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1555: fnd_msg_pub.add_exc_msg
1556: ( G_PKG_NAME
1557: , l_proc_name
1558: );
1559: END IF;
1556: ( G_PKG_NAME
1557: , l_proc_name
1558: );
1559: END IF;
1560: fnd_msg_pub.count_and_get
1561: ( p_count => x_msg_count,
1562: p_data => x_msg_data
1563: );
1564: