896: ,to_name => NULL);
897:
898: IF l_temp_qty < 0
899: THEN
900: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
901: fnd_message.set_token('UOM',l_conv_uom);
902: fnd_msg_pub.ADD;
903: RAISE CANNOT_CONVERT;
904: -- EXIT;
897:
898: IF l_temp_qty < 0
899: THEN
900: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
901: fnd_message.set_token('UOM',l_conv_uom);
902: fnd_msg_pub.ADD;
903: RAISE CANNOT_CONVERT;
904: -- EXIT;
905: END IF;
922: ,to_name => NULL);
923:
924: IF l_temp_qty < 0
925: THEN
926: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
927: fnd_message.set_token('UOM',l_conv_uom);
928: fnd_msg_pub.ADD;
929: RAISE CANNOT_CONVERT;
930: -- EXIT;
923:
924: IF l_temp_qty < 0
925: THEN
926: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
927: fnd_message.set_token('UOM',l_conv_uom);
928: fnd_msg_pub.ADD;
929: RAISE CANNOT_CONVERT;
930: -- EXIT;
931: END IF;
948: ,to_name => NULL);
949:
950: IF l_temp_qty < 0
951: THEN
952: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
953: fnd_message.set_token('UOM',l_conv_uom);
954: fnd_msg_pub.ADD;
955: RAISE CANNOT_CONVERT;
956: -- EXIT;
949:
950: IF l_temp_qty < 0
951: THEN
952: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
953: fnd_message.set_token('UOM',l_conv_uom);
954: fnd_msg_pub.ADD;
955: RAISE CANNOT_CONVERT;
956: -- EXIT;
957: END IF;
979:
980: IF l_temp_qty < 0
981: THEN
982: x_return_status := 'Q';
983: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
984: fnd_message.set_token('UOM',l_conv_uom);
985: fnd_msg_pub.ADD;
986: EXIT;
987: END IF;
980: IF l_temp_qty < 0
981: THEN
982: x_return_status := 'Q';
983: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
984: fnd_message.set_token('UOM',l_conv_uom);
985: fnd_msg_pub.ADD;
986: EXIT;
987: END IF;
988: ELSE
997:
998: EXCEPTION
999: WHEN CANNOT_CONVERT THEN
1000: x_return_status := fnd_api.g_ret_sts_unexp_error;
1001: /* fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
1002: fnd_message.set_token ('ERROR', SQLERRM);
1003: fnd_msg_pub.ADD; */
1004: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1005: p_data => x_msg_data);
998: EXCEPTION
999: WHEN CANNOT_CONVERT THEN
1000: x_return_status := fnd_api.g_ret_sts_unexp_error;
1001: /* fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
1002: fnd_message.set_token ('ERROR', SQLERRM);
1003: fnd_msg_pub.ADD; */
1004: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1005: p_data => x_msg_data);
1006: END auto_calc_product;