DBA Data[Home] [Help]

APPS.GMD_COMMON_SCALE dependencies on FND_API

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: l_return_status VARCHAR2(10);
85:
86: BEGIN
87:
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90: -- NPD Convergence
91: GMD_API_GRP.FETCH_PARM_VALUES ( P_orgn_id => p_orgn_id ,
92: P_parm_name => 'FM_YIELD_TYPE' ,

Line 104: x_return_status := FND_API.G_RET_STS_ERROR;

100: IF (x_conv_uom IS NULL OR x_conv_uom = ' ')
101: THEN
102: fnd_message.set_name('GME','GME_STANDARD_UOM_NOT_DEFINED');
103: fnd_msg_pub.add;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: RETURN;
106: END IF;
107:
108: END get_fm_yield_type;

Line 167: x_return_status := FND_API.G_RET_STS_SUCCESS;

163: --**********************************************************************
164:
165: BEGIN
166: -- added by pawan kumar for intializing success
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168: l_tab_size := p_scale_tab.count;
169: --**********************************************************************
170: --Determine the uom to which the items that conbribute to yield
171: --must be converted.

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

188: THEN
189: fnd_message.set_name('GME','GME_STANDARD_UOM_NOT_DEFINED');
190: fnd_msg_pub.add;
191: -- dbms_output.put_line('No standard UOM for FM_YIELD_TYPE');
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: RETURN;
194: END IF;
195: FOR l_row_count IN 1 .. l_tab_size
196: LOOP

Line 207: x_return_status := FND_API.G_RET_STS_ERROR;

203: OR p_scale_tab(l_row_count).detail_uom IS NULL)
204: THEN
205: fnd_message.set_name('GME','GME_INVALID_ITEM_OR_ITEM_UM');
206: fnd_msg_pub.add;
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: -- dbms_output.put_line('INVALID_ITEM_AND_OR_ITEM_UM');
209: END IF;
210: -- Pawan Kumar added check for null
211: IF (p_scale_tab(l_row_count).line_type IS NULL) OR

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

212: (p_scale_tab(l_row_count).line_type NOT IN (-1,1,2))
213: THEN
214: fnd_message.set_name('GME','GME_INVALID_LINE_TYPE');
215: fnd_msg_pub.add;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: -- dbms_output.put_line('INVALID_LINE_TYPE');
218: END IF;
219: IF (p_scale_tab(l_row_count).line_no IS NULL
220: OR p_scale_tab(l_row_count).line_no <= 0 )

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220: OR p_scale_tab(l_row_count).line_no <= 0 )
221: THEN
222: fnd_message.set_name('GME','GME_INVALID_LINE_NUMBER');
223: fnd_msg_pub.add;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: -- dbms_output.put_line('INVALID_LINE_NUMBER');
226: END IF ;
227: -- Pawan Kumar added check for null
228: IF (p_scale_tab(l_row_count).scale_type IS NULL) OR

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

229: (p_scale_tab(l_row_count).scale_type NOT IN (0,1,2))
230: THEN
231: fnd_message.set_name('GME','GME_INVALID_SCALE_TYPE');
232: fnd_msg_pub.add;
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: -- dbms_output.put_line('INVALID_SCALE_TYPE');
235: END IF;
236: -- Pawan Kumar added check for null
237: IF (p_scale_tab(l_row_count).contribute_yield_ind IS NULL) OR

Line 242: x_return_status := FND_API.G_RET_STS_ERROR;

238: (p_scale_tab(l_row_count).contribute_yield_ind NOT IN ('Y','N'))
239: THEN
240: fnd_message.set_name('GME','GME_INVALID_CONTRIBUTE_YIELD');
241: fnd_msg_pub.add;
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: -- dbms_output.put_line('INVALID_CONTRIBUTE_YIELD_IND');
244: END IF;
245: -- Pawan Kumar added check for scale type = 2 as the following are required then only
246: IF (p_scale_tab(l_row_count).scale_type = 2) THEN

Line 252: x_return_status := FND_API.G_RET_STS_ERROR;

248: (p_scale_tab(l_row_count).scale_multiple < 0 )
249: THEN
250: fnd_message.set_name('GME','GME_INVALID_SCALE_MULTIPLE');
251: fnd_msg_pub.add;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: -- dbms_output.put_line('INVALID_SCALE_MULTIPLE');
254: END IF;
255: --BEGIN BUG#2901379
256: --Do not validate the scale_rounding_variance being NULL.

Line 263: x_return_status := FND_API.G_RET_STS_ERROR;

259: OR (p_scale_tab(l_row_count).scale_rounding_variance > 1))
260: THEN
261: fnd_message.set_name('GME','GME_INVALID_SCALE_VARIANCE');
262: fnd_msg_pub.add;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: -- dbms_output.put_line('INVALID_SCALE_ROUNDING_VARIANCE');
265: END IF;
266: --END BUG#2901379
267:

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

269: (p_scale_tab(l_row_count).rounding_direction NOT IN (0,1,2))
270: THEN
271: fnd_message.set_name('GME','GME_INVALID_ROUNDING_DIRECTION');
272: fnd_msg_pub.add;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: -- dbms_output.put_line('INVALID_ROUNDING_DIRECTION');
275: END IF;
276: END IF;
277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

Line 277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

273: x_return_status := FND_API.G_RET_STS_ERROR;
274: -- dbms_output.put_line('INVALID_ROUNDING_DIRECTION');
275: END IF;
276: END IF;
277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
278: THEN
279: RETURN;
280: END IF;
281:

Line 404: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

400: --End Bug#3164299
401: , x_return_status);
402: -- dbms_output.put_line('just after call to integer_multiple_scale');
403:
404: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
405: THEN
406: fnd_message.set_name('GME','GME_INTEGER_MULTIPLE_SCALE_ERR');
407: fnd_msg_pub.add;
408: -- dbms_output.put_line('INTEGER_MULTIPLE_SCALE_ERROR ');

Line 416: x_return_status := FND_API.G_RET_STS_SUCCESS;

412: x_scale_tab(l_row_count) := x_scale_rec_out;
413: --End Bug#3164299
414: END IF;
415: END LOOP;
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417: RETURN;
418:
419: --**********************************************************************
420: --Condition 2:

Line 436: x_return_status := FND_API.G_RET_STS_ERROR;

432: fnd_message.set_name('GME','GME_ALL_FIXED_NO_SCALING');
433: fnd_msg_pub.add;
434: -- dbms_output.put_line('All items are non-scaleable. No scaling permitted');
435:
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: RETURN;
438:
439: --**********************************************************************
440: --Condition 3:

Line 460: x_return_status := FND_API.G_RET_STS_ERROR;

456:
457: fnd_message.set_name('GME','GME_NO_YC_PROPORTIONAL_INPUT');
458: fnd_msg_pub.add;
459: -- dbms_output.put_line('At least one YC scaleable ingredient must exist.') ;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: RETURN;
462:
463: ELSIF (l_type_0_Y_outputs + l_type_0_N_outputs + l_type_1_N_outputs
464: + l_type_2_N_outputs = l_output_total)

Line 474: x_return_status := FND_API.G_RET_STS_ERROR;

470:
471: fnd_message.set_name('GME','GME_NO_YC_PROPORTIONAL_OUTPUT');
472: fnd_msg_pub.add;
473: -- dbms_output.put_line('At least one YC scaleable product must exist.') ;
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: RETURN;
476:
477:
478: END IF;

Line 541: x_return_status := FND_API.G_RET_STS_ERROR;

537: -- dbms_output.put_line('x_return_status = ' || x_return_status);
538: fnd_message.set_name('GMI','GMI_OPM_UOM_NOT_FOUND');
539: fnd_msg_pub.add;
540: -- dbms_output.put_line('GMI UOM_CONVERSION_ERROR');
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: RETURN;
543: ELSE
544: l_scale_tab(l_row_count).qty := l_qty;
545: l_scale_tab(l_row_count).detail_uom := l_conv_uom;

Line 546: x_return_status := FND_API.G_RET_STS_SUCCESS;

542: RETURN;
543: ELSE
544: l_scale_tab(l_row_count).qty := l_qty;
545: l_scale_tab(l_row_count).detail_uom := l_conv_uom;
546: x_return_status := FND_API.G_RET_STS_SUCCESS;
547:
548: -- dbms_output.put_line('x_return_status = ' || x_return_status);
549:
550: --**********************************************************************

Line 611: x_return_status := FND_API.G_RET_STS_ERROR;

607: THEN
608: fnd_message.set_name('GME','NO_YIELD_CONTR_PRIM_OR_SEC');
609: fnd_msg_pub.add;
610: -- dbms_output.put_line('NO_FIXED_OR_PROPORTIONAL_PRIMARY_OR_SECONDARY');
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: RETURN;
613: END IF;
614: */
615:

Line 642: x_return_status := FND_API.G_RET_STS_ERROR;

638: /*
639: fnd_message.set_name('GME','NO_YIELD_CONTR_PRIMARIES');
640: fnd_msg_pub.add;
641: -- dbms_output.put_line('NO_YIELD_CONTR_PRIMARIES_EXIT');
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: */
644: RETURN;
645: END IF;
646:

Line 658: x_return_status := FND_API.G_RET_STS_ERROR;

654: /*
655: fnd_message.set_name('GME','NO_YIELD_CONTR_SECONDARIES');
656: fnd_msg_pub.add;
657: -- dbms_output.put_line('NO_YIELD_CONTR_SECONDARIES_EXIST');
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: */
660: RETURN;
661: ELSIF (l_proportional_input_qty = 0)
662: THEN

Line 669: x_return_status := FND_API.G_RET_STS_ERROR;

665: /*
666: fnd_message.set_name('GME','NO_PROPORTIONAL_SECONDARIES');
667: fnd_msg_pub.add;
668: -- dbms_output.put_line('NO_PROPORTIONAL_SECONDARIES_EXIST');
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: */
671: RETURN;
672:
673: END IF;

Line 729: x_return_status := FND_API.G_RET_STS_ERROR;

725: fnd_message.set_name('GME','GME_NEGATIVE_SCALE_FACTOR_CALC');
726: fnd_msg_pub.add;
727: -- dbms_output.put_line('Cannot scale to a qty lower than the qty of your non-scaleable items ') ;
728:
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: RETURN;
731: ELSE
732: b := b1 / l_proportional_input_qty;
733: END IF;

Line 786: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

782: --End Bug#3164299
783: , x_return_status);
784: -- dbms_output.put_line('just after call to integer_multiple_scale');
785:
786: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
787: THEN
788: fnd_message.set_name('GME','GME_INTEGER_MULTIPLE_SCALE_ERR');
789: fnd_msg_pub.add;
790: -- dbms_output.put_line('INTEGER_MULTIPLE_SCALE_ERROR ');

Line 820: x_return_status := FND_API.G_RET_STS_ERROR;

816: /*
817: fnd_message.set_name('GME','NO_YIELD_CONTR_PRIMARIES');
818: fnd_msg_pub.add;
819: -- dbms_output.put_line('NO_YIELD_CONTR_PRIMARIES_EXIT');
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: */
822: RETURN;
823: END IF;
824:

Line 834: x_return_status := FND_API.G_RET_STS_ERROR;

830: /*
831: fnd_message.set_name('GME','NO_YIELD_CONTR_SECONDARIES');
832: fnd_msg_pub.add;
833: -- dbms_output.put_line('NO_YIELD_CONTR_SECONDARIES_EXIST');
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: */
836: RETURN;
837:
838:

Line 847: x_return_status := FND_API.G_RET_STS_ERROR;

843: /*
844: fnd_message.set_name('GME','NO_PROPORTIONAL_SECONDARIES');
845: fnd_msg_pub.add;
846: -- dbms_output.put_line('NO_PROPORTIONAL_SECONDARIES_EXIST');
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: */
849: RETURN;
850: END IF;
851:

Line 905: x_return_status := FND_API.G_RET_STS_ERROR;

901: THEN
902: fnd_message.set_name('GME','GME_NEGATIVE_SCALE_FACTOR_CALC');
903: fnd_msg_pub.add;
904: -- dbms_output.put_line('Cannot scale to a qty lower than the qty of your non-scaleable items ') ;
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: RETURN;
907: ELSE
908: b := b1 / l_proportional_output_qty;
909: END IF;

Line 962: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

958: --End Bug#3164299
959: , x_return_status);
960: -- dbms_output.put_line('just after call to integer_multiple_scale');
961:
962: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
963: THEN
964: fnd_message.set_name('GME','GME_INTEGER_MULTIPLE_SCALE_ERR');
965: fnd_msg_pub.add;
966: -- dbms_output.put_line('INTEGER_MULTIPLE_SCALE_ERROR ');

Line 978: x_return_status := FND_API.G_RET_STS_SUCCESS;

974: END LOOP;
975:
976: END IF;
977:
978: x_return_status := FND_API.G_RET_STS_SUCCESS;
979:
980: EXCEPTION
981: WHEN OTHERS
982: THEN x_return_status := FND_API.G_RET_STS_ERROR;

Line 982: THEN x_return_status := FND_API.G_RET_STS_ERROR;

978: x_return_status := FND_API.G_RET_STS_SUCCESS;
979:
980: EXCEPTION
981: WHEN OTHERS
982: THEN x_return_status := FND_API.G_RET_STS_ERROR;
983: END scale;
984:
985:
986: /**********************************************************************

Line 1121: x_return_status := FND_API.G_RET_STS_SUCCESS;

1117: END IF;
1118: --END BUG#2901379 PR
1119: -- dbms_output.put_line('x_scale_rec.qty = ' || to_char(x_scale_rec.qty));
1120:
1121: x_return_status := FND_API.G_RET_STS_SUCCESS;
1122: RETURN;
1123:
1124: --*********************************************************************
1125: --Phase - Round UP

Line 1158: x_return_status := FND_API.G_RET_STS_SUCCESS;

1154: END IF;
1155: --END BUG#2901379 PR
1156: -- dbms_output.put_line('x_scale_rec.qty = ' || to_char(x_scale_rec.qty));
1157:
1158: x_return_status := FND_API.G_RET_STS_SUCCESS;
1159: RETURN;
1160:
1161: --*********************************************************************
1162: --Phase - Round EITHER

Line 1197: x_return_status := FND_API.G_RET_STS_SUCCESS;

1193: THEN
1194: -- dbms_output.put_line('floor_d and ceil_d = 0');
1195: x_scale_rec.qty := l_im_scale_rec.qty;
1196: -- dbms_output.put_line('x_scale_rec.qty = ' || to_char(x_scale_rec.qty));
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198: RETURN;
1199: -- dbms_output.put_line('test to see if hits message after RETURN');
1200: END IF;
1201:

Line 1227: x_return_status := FND_API.G_RET_STS_SUCCESS;

1223: -- dbms_output.put_line('in ELSE for floor_d > v or floor_qty=0 ') ;
1224: END IF;
1225: --END BUG#2901379 PR
1226: -- dbms_output.put_line('x_scale_rec.qty = ' || to_char(x_scale_rec.qty));
1227: x_return_status := FND_API.G_RET_STS_SUCCESS;
1228: RETURN;
1229:
1230: ELSE
1231: -- dbms_output.put_line('ceil_d <= floor_d');

Line 1249: x_return_status := FND_API.G_RET_STS_SUCCESS;

1245: -- dbms_output.put_line('in ceil ELSE if ceild_d >v') ;
1246: END IF;
1247: --END BUG#2901379 PR
1248: -- dbms_output.put_line('x_scale_rec.qty = ' || to_char(x_scale_rec.qty));
1249: x_return_status := FND_API.G_RET_STS_SUCCESS;
1250: RETURN;
1251: END IF;
1252:
1253: END IF; --End Rounding Direction Evaluation

Line 1256: THEN x_return_status := FND_API.G_RET_STS_ERROR;

1252:
1253: END IF; --End Rounding Direction Evaluation
1254: EXCEPTION
1255: WHEN OTHERS
1256: THEN x_return_status := FND_API.G_RET_STS_ERROR;
1257:
1258: END integer_multiple_scale;
1259:
1260:

Line 1423: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1419: , l_scale_out_tab
1420: , x_return_status
1421: );
1422: -- Bug #3890191 (JKB) Added l_scale_out_tab above.
1423: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1424: THEN
1425: x_fm_matl_dtl_tab := p_fm_matl_dtl_tab;
1426: FOR l_row_number in 1 .. l_row_count
1427: LOOP

Line 1479: x_return_status := FND_API.G_RET_STS_SUCCESS;

1475: --**********************************************************************
1476:
1477: BEGIN
1478:
1479: x_return_status := FND_API.G_RET_STS_SUCCESS;
1480:
1481:
1482: l_tab_size := p_scale_tab.count;
1483:

Line 1499: x_return_status := FND_API.G_RET_STS_ERROR;

1495: OR p_scale_tab(l_row_count).detail_uom IS NULL)
1496: THEN
1497: fnd_message.set_name('GME','GME_INVALID_ITEM_OR_ITEM_UM');
1498: fnd_msg_pub.add;
1499: x_return_status := FND_API.G_RET_STS_ERROR;
1500: -- dbms_output.put_line('INVALID_ITEM_AND_OR_ITEM_UM');
1501: END IF;
1502: IF (p_scale_tab(l_row_count).line_type IS NULL) OR
1503: (p_scale_tab(l_row_count).line_type NOT IN (-1,1,2))

Line 1507: x_return_status := FND_API.G_RET_STS_ERROR;

1503: (p_scale_tab(l_row_count).line_type NOT IN (-1,1,2))
1504: THEN
1505: fnd_message.set_name('GME','GME_INVALID_LINE_TYPE');
1506: fnd_msg_pub.add;
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: -- dbms_output.put_line('INVALID_LINE_TYPE');
1509: END IF;
1510: IF (p_scale_tab(l_row_count).line_no IS NULL
1511: OR p_scale_tab(l_row_count).line_no <= 0 )

Line 1515: x_return_status := FND_API.G_RET_STS_ERROR;

1511: OR p_scale_tab(l_row_count).line_no <= 0 )
1512: THEN
1513: fnd_message.set_name('GME','GME_INVALID_LINE_NUMBER');
1514: fnd_msg_pub.add;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: -- dbms_output.put_line('INVALID_LINE_NUMBER');
1517: END IF ;
1518: IF (p_scale_tab(l_row_count).scale_type IS NULL) OR
1519: (p_scale_tab(l_row_count).scale_type NOT IN (0,1,2))

Line 1523: x_return_status := FND_API.G_RET_STS_ERROR;

1519: (p_scale_tab(l_row_count).scale_type NOT IN (0,1,2))
1520: THEN
1521: fnd_message.set_name('GME','GME_INVALID_SCALE_TYPE');
1522: fnd_msg_pub.add;
1523: x_return_status := FND_API.G_RET_STS_ERROR;
1524: -- dbms_output.put_line('INVALID_SCALE_TYPE');
1525: END IF;
1526: IF (p_scale_tab(l_row_count).contribute_yield_ind IS NULL ) OR
1527: (p_scale_tab(l_row_count).contribute_yield_ind NOT IN ('Y','N'))

Line 1531: x_return_status := FND_API.G_RET_STS_ERROR;

1527: (p_scale_tab(l_row_count).contribute_yield_ind NOT IN ('Y','N'))
1528: THEN
1529: fnd_message.set_name('GME','GME_INVALID_CONTRIBUTE_YIELD');
1530: fnd_msg_pub.add;
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: -- dbms_output.put_line('INVALID_CONTRIBUTE_YIELD_IND');
1533: END IF;
1534: IF (p_scale_tab(l_row_count).scale_multiple < 0 )
1535: THEN

Line 1538: x_return_status := FND_API.G_RET_STS_ERROR;

1534: IF (p_scale_tab(l_row_count).scale_multiple < 0 )
1535: THEN
1536: fnd_message.set_name('GME','GME_INVALID_SCALE_MULTIPLE');
1537: fnd_msg_pub.add;
1538: x_return_status := FND_API.G_RET_STS_ERROR;
1539: -- dbms_output.put_line('INVALID_SCALE_MULTIPLE');
1540: END IF;
1541: IF ((p_scale_tab(l_row_count).scale_rounding_variance < 0)
1542: OR (p_scale_tab(l_row_count).scale_rounding_variance > 1))

Line 1546: x_return_status := FND_API.G_RET_STS_ERROR;

1542: OR (p_scale_tab(l_row_count).scale_rounding_variance > 1))
1543: THEN
1544: fnd_message.set_name('GME','GME_INVALID_SCALE_VARIANCE');
1545: fnd_msg_pub.add;
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: -- dbms_output.put_line('INVALID_SCALE_ROUNDING_VARIANCE');
1548: END IF;
1549: IF (p_scale_tab(l_row_count).rounding_direction NOT IN (0,1,2))
1550: THEN

Line 1553: x_return_status := FND_API.G_RET_STS_ERROR;

1549: IF (p_scale_tab(l_row_count).rounding_direction NOT IN (0,1,2))
1550: THEN
1551: fnd_message.set_name('GME','GME_INVALID_ROUNDING_DIRECTION');
1552: fnd_msg_pub.add;
1553: x_return_status := FND_API.G_RET_STS_ERROR;
1554: -- dbms_output.put_line('INVALID_ROUNDING_DIRECTION');
1555: END IF;
1556:
1557: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

Line 1557: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1553: x_return_status := FND_API.G_RET_STS_ERROR;
1554: -- dbms_output.put_line('INVALID_ROUNDING_DIRECTION');
1555: END IF;
1556:
1557: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1558: THEN
1559: RETURN;
1560: END IF;
1561:

Line 1619: x_return_status := FND_API.G_RET_STS_ERROR;*/

1615: IF (l_type_1_Y_outputs + l_type_2_Y_outputs = 0) THEN
1616: /*fnd_message.set_name('GME','NO_YIELD_CONTR_SECONDARIES');
1617: fnd_msg_pub.add;
1618: -- dbms_output.put_line('NO_YIELD_CONTR_SECONDARIES_EXIST');
1619: x_return_status := FND_API.G_RET_STS_ERROR;*/
1620: RETURN;
1621: END IF;
1622:
1623: -- dbms_output.put_line('Phase I: calling uom conv ');

Line 1627: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1623: -- dbms_output.put_line('Phase I: calling uom conv ');
1624:
1625: get_fm_yield_type(p_orgn_id, l_conv_uom, x_return_status); -- NPD Convergence
1626:
1627: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1628: THEN
1629: RETURN;
1630: END IF;
1631:

Line 1656: x_return_status := FND_API.G_RET_STS_ERROR;

1652: -- dbms_output.put_line('x_return_status = ' || x_return_status);
1653: fnd_message.set_name('GMI','GMI_OPM_UOM_NOT_FOUND');
1654: fnd_msg_pub.add;
1655: -- dbms_output.put_line('GMI UOM_CONVERSION_ERROR');
1656: x_return_status := FND_API.G_RET_STS_ERROR;
1657: RETURN;
1658: ELSE
1659: l_scale_tab(l_row_count).qty := l_qty;
1660: l_scale_tab(l_row_count).detail_uom := l_conv_uom;

Line 1661: x_return_status := FND_API.G_RET_STS_SUCCESS;

1657: RETURN;
1658: ELSE
1659: l_scale_tab(l_row_count).qty := l_qty;
1660: l_scale_tab(l_row_count).detail_uom := l_conv_uom;
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:
1663: -- dbms_output.put_line('x_return_status = ' || x_return_status);
1664:
1665: --**********************************************************************

Line 1726: x_return_status := FND_API.G_RET_STS_ERROR;

1722: -- 'fixed output '||l_fixed_output_qty);
1723: fnd_message.set_name('GME','GME_FIX_ITEM_GTR_YIELD');
1724: fnd_msg_pub.add;
1725: -- dbms_output.put_line('Fixed items are greater than desired yield');
1726: x_return_status := FND_API.G_RET_STS_ERROR;
1727: RETURN;
1728: END IF;
1729:
1730: IF l_proportional_output_qty <= 0 THEN