62: If these conditions are not met, continue on to PHASE I and
63: then PHASE II of the full scaling process.
64: **********************************************************************/
65:
66: /* Procedure to get the standard uom for the 'fm_yield_type'
67: This will be used to convert all the quantities into single
68: unit of measure
69: */
70:
99: CLOSE sy_uoms_typ_cursor;
100:
101: IF (x_conv_uom IS NULL OR x_conv_uom = ' ')
102: THEN
103: fnd_message.set_name('GME','GME_STANDARD_UOM_NOT_DEFINED');
104: fnd_msg_pub.add;
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: RETURN;
107: END IF;
186: -- dbms_output.put_line('l_conv_uom ' || l_conv_uom);
187:
188: IF (l_conv_uom IS NULL OR l_conv_uom = ' ')
189: THEN
190: fnd_message.set_name('GME','GME_STANDARD_UOM_NOT_DEFINED');
191: fnd_msg_pub.add;
192: -- dbms_output.put_line('No standard UOM for FM_YIELD_TYPE');
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: RETURN;
188: IF (l_conv_uom IS NULL OR l_conv_uom = ' ')
189: THEN
190: fnd_message.set_name('GME','GME_STANDARD_UOM_NOT_DEFINED');
191: fnd_msg_pub.add;
192: -- dbms_output.put_line('No standard UOM for FM_YIELD_TYPE');
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: RETURN;
195: END IF;
196: FOR l_row_count IN 1 .. l_tab_size