DBA Data[Home] [Help]

APPS.GMD_COMMON_SCALE dependencies on FND_MSG_PUB

Line 104: fnd_msg_pub.add;

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;
108:

Line 191: fnd_msg_pub.add;

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

Line 207: fnd_msg_pub.add;

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

Line 216: fnd_msg_pub.add;

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

Line 224: fnd_msg_pub.add;

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

Line 233: fnd_msg_pub.add;

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

Line 242: fnd_msg_pub.add;

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

Line 252: fnd_msg_pub.add;

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

Line 263: fnd_msg_pub.add;

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

Line 273: fnd_msg_pub.add;

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

Line 408: fnd_msg_pub.add;

404:
405: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
406: THEN
407: fnd_message.set_name('GME','GME_INTEGER_MULTIPLE_SCALE_ERR');
408: fnd_msg_pub.add;
409: -- dbms_output.put_line('INTEGER_MULTIPLE_SCALE_ERROR ');
410: RETURN;
411: END IF;
412: --Begin Bug#3164299 P.Raghu

Line 434: fnd_msg_pub.add;

430: THEN
431: x_scale_tab := p_scale_tab;
432:
433: fnd_message.set_name('GME','GME_ALL_FIXED_NO_SCALING');
434: fnd_msg_pub.add;
435: -- dbms_output.put_line('All items are non-scaleable. No scaling permitted');
436:
437: x_return_status := FND_API.G_RET_STS_ERROR;
438: RETURN;

Line 459: fnd_msg_pub.add;

455: -- dbms_output.put_line('l_type_1_N_inputs = ' || l_type_1_N_inputs);
456: -- dbms_output.put_line('l_type_2_N_inputs = ' || l_type_2_N_inputs);
457:
458: fnd_message.set_name('GME','GME_NO_YC_PROPORTIONAL_INPUT');
459: fnd_msg_pub.add;
460: -- dbms_output.put_line('At least one YC scaleable ingredient must exist.') ;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: RETURN;
463:

Line 473: fnd_msg_pub.add;

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

Line 540: fnd_msg_pub.add;

536: THEN
537: -- Report UOM failure
538: -- dbms_output.put_line('x_return_status = ' || x_return_status);
539: fnd_message.set_name('GMI','GMI_OPM_UOM_NOT_FOUND');
540: fnd_msg_pub.add;
541: -- dbms_output.put_line('GMI UOM_CONVERSION_ERROR');
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: RETURN;
544: ELSE

Line 610: fnd_msg_pub.add;

606: IF (l_fixed_output_qty + l_proportional_output_qty +
607: l_fixed_input_qty +l_proportional_input_qty = 0 )
608: THEN
609: fnd_message.set_name('GME','NO_YIELD_CONTR_PRIM_OR_SEC');
610: fnd_msg_pub.add;
611: -- dbms_output.put_line('NO_FIXED_OR_PROPORTIONAL_PRIMARY_OR_SECONDARY');
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: RETURN;
614: END IF;

Line 641: fnd_msg_pub.add;

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

Line 657: fnd_msg_pub.add;

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

Line 668: fnd_msg_pub.add;

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

Line 727: fnd_msg_pub.add;

723: -- dbms_output.put_line(' b1 = '||to_char(b1));
724: IF b1 < 0
725: THEN
726: fnd_message.set_name('GME','GME_NEGATIVE_SCALE_FACTOR_CALC');
727: fnd_msg_pub.add;
728: -- dbms_output.put_line('Cannot scale to a qty lower than the qty of your non-scaleable items ') ;
729:
730: x_return_status := FND_API.G_RET_STS_ERROR;
731: RETURN;

Line 790: fnd_msg_pub.add;

786:
787: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
788: THEN
789: fnd_message.set_name('GME','GME_INTEGER_MULTIPLE_SCALE_ERR');
790: fnd_msg_pub.add;
791: -- dbms_output.put_line('INTEGER_MULTIPLE_SCALE_ERROR ');
792: RETURN;
793: END IF;
794: --Begin Bug#3164299 P.Raghu

Line 819: fnd_msg_pub.add;

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

Line 833: fnd_msg_pub.add;

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

Line 846: fnd_msg_pub.add;

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

Line 904: fnd_msg_pub.add;

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

Line 966: fnd_msg_pub.add;

962:
963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
964: THEN
965: fnd_message.set_name('GME','GME_INTEGER_MULTIPLE_SCALE_ERR');
966: fnd_msg_pub.add;
967: -- dbms_output.put_line('INTEGER_MULTIPLE_SCALE_ERROR ');
968: RETURN;
969: END IF;
970: --Begin Bug#3164299 P.Raghu

Line 1499: fnd_msg_pub.add;

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

Line 1507: fnd_msg_pub.add;

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

Line 1515: fnd_msg_pub.add;

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

Line 1523: fnd_msg_pub.add;

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

Line 1531: fnd_msg_pub.add;

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

Line 1538: fnd_msg_pub.add;

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

Line 1546: fnd_msg_pub.add;

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

Line 1553: fnd_msg_pub.add;

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

Line 1618: fnd_msg_pub.add;

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

Line 1655: fnd_msg_pub.add;

1651: THEN
1652: -- Report UOM failure
1653: -- dbms_output.put_line('x_return_status = ' || x_return_status);
1654: fnd_message.set_name('GMI','GMI_OPM_UOM_NOT_FOUND');
1655: fnd_msg_pub.add;
1656: -- dbms_output.put_line('GMI UOM_CONVERSION_ERROR');
1657: x_return_status := FND_API.G_RET_STS_ERROR;
1658: RETURN;
1659: ELSE

Line 1725: fnd_msg_pub.add;

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