255: ,to_unit => l_sec_uom_code
256: ,from_name => NULL
257: ,to_name => NULL);
258: IF l_temp_qty < 0 THEN
259: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
260: fnd_message.set_token ('ITEM_NO', l_item_no);
261: fnd_message.set_token ('FROM_UOM', l_material_details_tbl (l_count).dtl_um);
262: fnd_message.set_token ('TO_UOM', l_sec_uom_code);
263: fnd_msg_pub.add;
256: ,from_name => NULL
257: ,to_name => NULL);
258: IF l_temp_qty < 0 THEN
259: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
260: fnd_message.set_token ('ITEM_NO', l_item_no);
261: fnd_message.set_token ('FROM_UOM', l_material_details_tbl (l_count).dtl_um);
262: fnd_message.set_token ('TO_UOM', l_sec_uom_code);
263: fnd_msg_pub.add;
264: l_temp_qty := NULL;
257: ,to_name => NULL);
258: IF l_temp_qty < 0 THEN
259: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
260: fnd_message.set_token ('ITEM_NO', l_item_no);
261: fnd_message.set_token ('FROM_UOM', l_material_details_tbl (l_count).dtl_um);
262: fnd_message.set_token ('TO_UOM', l_sec_uom_code);
263: fnd_msg_pub.add;
264: l_temp_qty := NULL;
265: END IF;
258: IF l_temp_qty < 0 THEN
259: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
260: fnd_message.set_token ('ITEM_NO', l_item_no);
261: fnd_message.set_token ('FROM_UOM', l_material_details_tbl (l_count).dtl_um);
262: fnd_message.set_token ('TO_UOM', l_sec_uom_code);
263: fnd_msg_pub.add;
264: l_temp_qty := NULL;
265: END IF;
266: ELSE
559: WHEN create_mo_err OR unable_to_query_tree THEN
560: x_return_status := l_return_status;
561: WHEN uom_conversion_err THEN
562: x_return_status := fnd_api.g_ret_sts_error;
563: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
564: fnd_message.set_token ('ITEM_NO', l_item_no);
565: fnd_message.set_token ('FROM_UOM', l_from_uom);
566: fnd_message.set_token ('TO_UOM', l_to_uom);
567: WHEN OTHERS THEN
560: x_return_status := l_return_status;
561: WHEN uom_conversion_err THEN
562: x_return_status := fnd_api.g_ret_sts_error;
563: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
564: fnd_message.set_token ('ITEM_NO', l_item_no);
565: fnd_message.set_token ('FROM_UOM', l_from_uom);
566: fnd_message.set_token ('TO_UOM', l_to_uom);
567: WHEN OTHERS THEN
568: IF g_debug <= gme_debug.g_log_unexpected THEN
561: WHEN uom_conversion_err THEN
562: x_return_status := fnd_api.g_ret_sts_error;
563: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
564: fnd_message.set_token ('ITEM_NO', l_item_no);
565: fnd_message.set_token ('FROM_UOM', l_from_uom);
566: fnd_message.set_token ('TO_UOM', l_to_uom);
567: WHEN OTHERS THEN
568: IF g_debug <= gme_debug.g_log_unexpected THEN
569: gme_debug.put_line ( 'When others exception in '
562: x_return_status := fnd_api.g_ret_sts_error;
563: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
564: fnd_message.set_token ('ITEM_NO', l_item_no);
565: fnd_message.set_token ('FROM_UOM', l_from_uom);
566: fnd_message.set_token ('TO_UOM', l_to_uom);
567: WHEN OTHERS THEN
568: IF g_debug <= gme_debug.g_log_unexpected THEN
569: gme_debug.put_line ( 'When others exception in '
570: || g_pkg_name
1290: END IF;
1291: EXCEPTION
1292: WHEN uom_conv_error THEN
1293: x_return_status := fnd_api.g_ret_sts_error;
1294: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1295: fnd_message.set_token ('ITEM_NO', l_item_no);
1296: fnd_message.set_token ('FROM_UOM', l_from_uom);
1297: fnd_message.set_token ('TO_UOM', l_to_uom);
1298: fnd_msg_pub.ADD;
1291: EXCEPTION
1292: WHEN uom_conv_error THEN
1293: x_return_status := fnd_api.g_ret_sts_error;
1294: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1295: fnd_message.set_token ('ITEM_NO', l_item_no);
1296: fnd_message.set_token ('FROM_UOM', l_from_uom);
1297: fnd_message.set_token ('TO_UOM', l_to_uom);
1298: fnd_msg_pub.ADD;
1299: WHEN get_mo_line_err THEN
1292: WHEN uom_conv_error THEN
1293: x_return_status := fnd_api.g_ret_sts_error;
1294: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1295: fnd_message.set_token ('ITEM_NO', l_item_no);
1296: fnd_message.set_token ('FROM_UOM', l_from_uom);
1297: fnd_message.set_token ('TO_UOM', l_to_uom);
1298: fnd_msg_pub.ADD;
1299: WHEN get_mo_line_err THEN
1300: x_return_status := l_return_status;
1293: x_return_status := fnd_api.g_ret_sts_error;
1294: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1295: fnd_message.set_token ('ITEM_NO', l_item_no);
1296: fnd_message.set_token ('FROM_UOM', l_from_uom);
1297: fnd_message.set_token ('TO_UOM', l_to_uom);
1298: fnd_msg_pub.ADD;
1299: WHEN get_mo_line_err THEN
1300: x_return_status := l_return_status;
1301: WHEN OTHERS THEN