DBA Data[Home] [Help]

APPS.GMD_COMMON_SCALE dependencies on FND_MSG_PUB

Line 103: fnd_msg_pub.add;

99:
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:

Line 190: fnd_msg_pub.add;

186:
187: IF (l_conv_uom IS NULL OR l_conv_uom = ' ')
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;

Line 206: fnd_msg_pub.add;

202: IF (p_scale_tab(l_row_count).inventory_item_id IS NULL
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

Line 215: fnd_msg_pub.add;

211: IF (p_scale_tab(l_row_count).line_type IS NULL) OR
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

Line 223: fnd_msg_pub.add;

219: IF (p_scale_tab(l_row_count).line_no IS NULL
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

Line 232: fnd_msg_pub.add;

228: IF (p_scale_tab(l_row_count).scale_type IS NULL) OR
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

Line 241: fnd_msg_pub.add;

237: IF (p_scale_tab(l_row_count).contribute_yield_ind IS NULL) OR
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

Line 251: fnd_msg_pub.add;

247: IF (p_scale_tab(l_row_count).scale_multiple IS NULL) OR
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

Line 262: fnd_msg_pub.add;

258: IF ((p_scale_tab(l_row_count).scale_rounding_variance < 0)
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

Line 272: fnd_msg_pub.add;

268: IF (p_scale_tab(l_row_count).rounding_direction IS NULL) OR
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;

Line 407: fnd_msg_pub.add;

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 ');
409: RETURN;
410: END IF;
411: --Begin Bug#3164299 P.Raghu

Line 433: fnd_msg_pub.add;

429: THEN
430: x_scale_tab := p_scale_tab;
431:
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;

Line 458: fnd_msg_pub.add;

454: -- dbms_output.put_line('l_type_1_N_inputs = ' || l_type_1_N_inputs);
455: -- dbms_output.put_line('l_type_2_N_inputs = ' || l_type_2_N_inputs);
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:

Line 472: fnd_msg_pub.add;

468: -- dbms_output.put_line('l_type_1_N_outputs = ' || l_type_1_N_outputs);
469: -- dbms_output.put_line('l_type_2_N_outputs = ' || l_type_2_N_outputs);
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:

Line 539: fnd_msg_pub.add;

535: THEN
536: -- Report UOM failure
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

Line 609: fnd_msg_pub.add;

605: IF (l_fixed_output_qty + l_proportional_output_qty +
606: l_fixed_input_qty +l_proportional_input_qty = 0 )
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;

Line 640: fnd_msg_pub.add;

636: THEN
637: -- dbms_output.put_line('P=0');
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;

Line 656: fnd_msg_pub.add;

652: -- dbms_output.put_line('S=0');
653:
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;

Line 667: fnd_msg_pub.add;

663: -- dbms_output.put_line('l_proportional_input_qty=0');
664:
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;

Line 726: fnd_msg_pub.add;

722: -- dbms_output.put_line(' b1 = '||to_char(b1));
723: IF b1 < 0
724: THEN
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;

Line 789: fnd_msg_pub.add;

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 ');
791: RETURN;
792: END IF;
793: --Begin Bug#3164299 P.Raghu

Line 818: fnd_msg_pub.add;

814: THEN
815: -- dbms_output.put_line('P=0');
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;

Line 832: fnd_msg_pub.add;

828: THEN
829: -- dbms_output.put_line('S=0');
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;

Line 845: fnd_msg_pub.add;

841: -- dbms_output.put_line('l_proportional_output_qty=0');
842:
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;

Line 903: fnd_msg_pub.add;

899: -- dbms_output.put_line(' b1 = '||to_char(b1));
900: IF b1 < 0
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

Line 965: fnd_msg_pub.add;

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 ');
967: RETURN;
968: END IF;
969: --Begin Bug#3164299 P.Raghu

Line 1498: fnd_msg_pub.add;

1494: IF (p_scale_tab(l_row_count).inventory_item_id IS NULL
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

Line 1506: fnd_msg_pub.add;

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))
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

Line 1514: fnd_msg_pub.add;

1510: IF (p_scale_tab(l_row_count).line_no IS NULL
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

Line 1522: fnd_msg_pub.add;

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))
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

Line 1530: fnd_msg_pub.add;

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'))
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 )

Line 1537: fnd_msg_pub.add;

1533: END IF;
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)

Line 1545: fnd_msg_pub.add;

1541: IF ((p_scale_tab(l_row_count).scale_rounding_variance < 0)
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))

Line 1552: fnd_msg_pub.add;

1548: END IF;
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:

Line 1617: fnd_msg_pub.add;

1613: END LOOP;
1614:
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;

Line 1654: fnd_msg_pub.add;

1650: THEN
1651: -- Report UOM failure
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

Line 1724: fnd_msg_pub.add;

1720: -- 'prop inp '||l_proportional_input_qty||
1721: -- 'fixed inp '||l_fixed_input_qty||
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;