205: ,to_unit => l_sec_uom_code
206: ,from_name => NULL
207: ,to_name => NULL);
208: IF l_temp_qty < 0 THEN
209: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
210: fnd_message.set_token ('ITEM_NO', l_item_no);
211: fnd_message.set_token ('FROM_UOM', l_material_details_tbl (l_count).dtl_um);
212: fnd_message.set_token ('TO_UOM', l_sec_uom_code);
213: fnd_msg_pub.add;
206: ,from_name => NULL
207: ,to_name => NULL);
208: IF l_temp_qty < 0 THEN
209: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
210: fnd_message.set_token ('ITEM_NO', l_item_no);
211: fnd_message.set_token ('FROM_UOM', l_material_details_tbl (l_count).dtl_um);
212: fnd_message.set_token ('TO_UOM', l_sec_uom_code);
213: fnd_msg_pub.add;
214: l_temp_qty := NULL;
207: ,to_name => NULL);
208: IF l_temp_qty < 0 THEN
209: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
210: fnd_message.set_token ('ITEM_NO', l_item_no);
211: fnd_message.set_token ('FROM_UOM', l_material_details_tbl (l_count).dtl_um);
212: fnd_message.set_token ('TO_UOM', l_sec_uom_code);
213: fnd_msg_pub.add;
214: l_temp_qty := NULL;
215: END IF;
208: IF l_temp_qty < 0 THEN
209: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
210: fnd_message.set_token ('ITEM_NO', l_item_no);
211: fnd_message.set_token ('FROM_UOM', l_material_details_tbl (l_count).dtl_um);
212: fnd_message.set_token ('TO_UOM', l_sec_uom_code);
213: fnd_msg_pub.add;
214: l_temp_qty := NULL;
215: END IF;
216: ELSE
496: WHEN create_mo_err OR unable_to_query_tree THEN
497: x_return_status := l_return_status;
498: WHEN uom_conversion_err THEN
499: x_return_status := fnd_api.g_ret_sts_error;
500: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
501: fnd_message.set_token ('ITEM_NO', l_item_no);
502: fnd_message.set_token ('FROM_UOM', l_from_uom);
503: fnd_message.set_token ('TO_UOM', l_to_uom);
504: WHEN OTHERS THEN
497: x_return_status := l_return_status;
498: WHEN uom_conversion_err THEN
499: x_return_status := fnd_api.g_ret_sts_error;
500: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
501: fnd_message.set_token ('ITEM_NO', l_item_no);
502: fnd_message.set_token ('FROM_UOM', l_from_uom);
503: fnd_message.set_token ('TO_UOM', l_to_uom);
504: WHEN OTHERS THEN
505: IF g_debug <= gme_debug.g_log_unexpected THEN
498: WHEN uom_conversion_err THEN
499: x_return_status := fnd_api.g_ret_sts_error;
500: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
501: fnd_message.set_token ('ITEM_NO', l_item_no);
502: fnd_message.set_token ('FROM_UOM', l_from_uom);
503: fnd_message.set_token ('TO_UOM', l_to_uom);
504: WHEN OTHERS THEN
505: IF g_debug <= gme_debug.g_log_unexpected THEN
506: gme_debug.put_line ( 'When others exception in '
499: x_return_status := fnd_api.g_ret_sts_error;
500: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
501: fnd_message.set_token ('ITEM_NO', l_item_no);
502: fnd_message.set_token ('FROM_UOM', l_from_uom);
503: fnd_message.set_token ('TO_UOM', l_to_uom);
504: WHEN OTHERS THEN
505: IF g_debug <= gme_debug.g_log_unexpected THEN
506: gme_debug.put_line ( 'When others exception in '
507: || g_pkg_name
1089: END IF;
1090: EXCEPTION
1091: WHEN uom_conv_error THEN
1092: x_return_status := fnd_api.g_ret_sts_error;
1093: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1094: fnd_message.set_token ('ITEM_NO', l_item_no);
1095: fnd_message.set_token ('FROM_UOM', l_from_uom);
1096: fnd_message.set_token ('TO_UOM', l_to_uom);
1097: fnd_msg_pub.ADD;
1090: EXCEPTION
1091: WHEN uom_conv_error THEN
1092: x_return_status := fnd_api.g_ret_sts_error;
1093: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1094: fnd_message.set_token ('ITEM_NO', l_item_no);
1095: fnd_message.set_token ('FROM_UOM', l_from_uom);
1096: fnd_message.set_token ('TO_UOM', l_to_uom);
1097: fnd_msg_pub.ADD;
1098: WHEN get_mo_line_err THEN
1091: WHEN uom_conv_error THEN
1092: x_return_status := fnd_api.g_ret_sts_error;
1093: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1094: fnd_message.set_token ('ITEM_NO', l_item_no);
1095: fnd_message.set_token ('FROM_UOM', l_from_uom);
1096: fnd_message.set_token ('TO_UOM', l_to_uom);
1097: fnd_msg_pub.ADD;
1098: WHEN get_mo_line_err THEN
1099: x_return_status := l_return_status;
1092: x_return_status := fnd_api.g_ret_sts_error;
1093: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1094: fnd_message.set_token ('ITEM_NO', l_item_no);
1095: fnd_message.set_token ('FROM_UOM', l_from_uom);
1096: fnd_message.set_token ('TO_UOM', l_to_uom);
1097: fnd_msg_pub.ADD;
1098: WHEN get_mo_line_err THEN
1099: x_return_status := l_return_status;
1100: WHEN OTHERS THEN