860: ,to_name => NULL);
861:
862: IF l_temp_qty < 0
863: THEN
864: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
865: fnd_message.set_token('UOM',l_conv_uom);
866: fnd_msg_pub.ADD;
867: RAISE CANNOT_CONVERT;
868: -- EXIT;
861:
862: IF l_temp_qty < 0
863: THEN
864: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
865: fnd_message.set_token('UOM',l_conv_uom);
866: fnd_msg_pub.ADD;
867: RAISE CANNOT_CONVERT;
868: -- EXIT;
869: END IF;
886: ,to_name => NULL);
887:
888: IF l_temp_qty < 0
889: THEN
890: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
891: fnd_message.set_token('UOM',l_conv_uom);
892: fnd_msg_pub.ADD;
893: RAISE CANNOT_CONVERT;
894: -- EXIT;
887:
888: IF l_temp_qty < 0
889: THEN
890: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
891: fnd_message.set_token('UOM',l_conv_uom);
892: fnd_msg_pub.ADD;
893: RAISE CANNOT_CONVERT;
894: -- EXIT;
895: END IF;
912: ,to_name => NULL);
913:
914: IF l_temp_qty < 0
915: THEN
916: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
917: fnd_message.set_token('UOM',l_conv_uom);
918: fnd_msg_pub.ADD;
919: RAISE CANNOT_CONVERT;
920: -- EXIT;
913:
914: IF l_temp_qty < 0
915: THEN
916: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
917: fnd_message.set_token('UOM',l_conv_uom);
918: fnd_msg_pub.ADD;
919: RAISE CANNOT_CONVERT;
920: -- EXIT;
921: END IF;
943:
944: IF l_temp_qty < 0
945: THEN
946: x_return_status := 'Q';
947: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
948: fnd_message.set_token('UOM',l_conv_uom);
949: fnd_msg_pub.ADD;
950: EXIT;
951: END IF;
944: IF l_temp_qty < 0
945: THEN
946: x_return_status := 'Q';
947: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
948: fnd_message.set_token('UOM',l_conv_uom);
949: fnd_msg_pub.ADD;
950: EXIT;
951: END IF;
952: ELSE
961:
962: EXCEPTION
963: WHEN CANNOT_CONVERT THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: /* fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
966: fnd_message.set_token ('ERROR', SQLERRM);
967: fnd_msg_pub.ADD; */
968: fnd_msg_pub.count_and_get (p_count => x_msg_count,
969: p_data => x_msg_data);
962: EXCEPTION
963: WHEN CANNOT_CONVERT THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: /* fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
966: fnd_message.set_token ('ERROR', SQLERRM);
967: fnd_msg_pub.ADD; */
968: fnd_msg_pub.count_and_get (p_count => x_msg_count,
969: p_data => x_msg_data);
970: END auto_calc_product;