eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_MOBILE_TXN dependencies on FND_MESSAGE

Line 146: fnd_message.set_name('GME','INVALID_VALUE');

142: END IF;
143: EXCEPTION
144: WHEN NO_RSRV_PNDLOT_ID THEN
145: x_return_status := fnd_api.g_ret_sts_error;
146: fnd_message.set_name('GME','INVALID_VALUE');
147: x_error_msg := fnd_message.get;
148: WHEN OTHERS THEN
149: IF g_debug <= gme_debug.g_log_unexpected THEN
150: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');

Line 147: x_error_msg := fnd_message.get;

143: EXCEPTION
144: WHEN NO_RSRV_PNDLOT_ID THEN
145: x_return_status := fnd_api.g_ret_sts_error;
146: fnd_message.set_name('GME','INVALID_VALUE');
147: x_error_msg := fnd_message.get;
148: WHEN OTHERS THEN
149: IF g_debug <= gme_debug.g_log_unexpected THEN
150: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');
151: END IF;

Line 154: x_error_msg := fnd_message.get;

150: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');
151: END IF;
152: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_pend_lots');
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: x_error_msg := fnd_message.get;
155:
156: END relieve_resvns_pend_lots;
157:
158: /*

Line 201: x_error_msg := fnd_message.get;

197: gme_debug.put_line('When others exception in relieve_resvns_disp_items');
198: END IF;
199: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_disp_items');
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: x_error_msg := fnd_message.get;
202: END relieve_resvns_disp_items;
203:
204:
205: /*+========================================================================+

Line 391: --x_error_msg := fnd_message.get;

387:
388:
389: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
390: -- Bug 5255933 Use GME_COMMON_PVT to get error message
391: --x_error_msg := fnd_message.get;
392: GME_COMMON_PVT.count_and_get (x_count => l_count
393: ,p_encoded => fnd_api.g_false
394: ,x_data => x_error_msg);
395:

Line 412: x_error_msg := fnd_message.get;

408: gme_debug.put_line('When others exception in Create MAterial Txn');
409: END IF;
410: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_material_txn');
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: x_error_msg := fnd_message.get;
413:
414: END Create_Material_Txn;
415:
416: /*+========================================================================+

Line 478: x_error_msg := fnd_message.get;

474: x_return_status => x_return_status
475: );
476:
477: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
478: x_error_msg := fnd_message.get;
479: END IF;
480:
481: EXCEPTION
482: WHEN OTHERS THEN

Line 488: x_error_msg := fnd_message.get;

484: gme_debug.put_line('When others exception in Create Lot Txn');
485: END IF;
486: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_lot_txn');
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: x_error_msg := fnd_message.get;
489:
490: END Create_Lot_Txn;
491:
492: /*+========================================================================+

Line 568: x_error_msg := fnd_message.get;

564: gme_debug.put_line('When others exception in Validate Indiv Lot Txn');
565: END IF;
566: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Indiv_Lot_Txn');
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: x_error_msg := fnd_message.get;
569:
570: END Validate_Indiv_Lot_Txn;
571:
572: /*+========================================================================+

Line 665: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_LOT');

661: WHERE organization_id = p_organization_id
662: AND inventory_item_id = p_inventory_item_id;
663:
664: IF p_object_type = 'O' THEN --- Lot
665: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_LOT');
666: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
667: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
668: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
669: ELSIF p_object_type = 'Z' THEN --- Subinventory

Line 666: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);

662: AND inventory_item_id = p_inventory_item_id;
663:
664: IF p_object_type = 'O' THEN --- Lot
665: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_LOT');
666: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
667: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
668: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
669: ELSIF p_object_type = 'Z' THEN --- Subinventory
670: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');

Line 667: FND_MESSAGE.SET_TOKEN('ITEM', l_item);

663:
664: IF p_object_type = 'O' THEN --- Lot
665: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_LOT');
666: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
667: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
668: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
669: ELSIF p_object_type = 'Z' THEN --- Subinventory
670: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
671: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);

Line 668: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);

664: IF p_object_type = 'O' THEN --- Lot
665: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_LOT');
666: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
667: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
668: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
669: ELSIF p_object_type = 'Z' THEN --- Subinventory
670: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
671: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
672: FND_MESSAGE.SET_TOKEN('ITEM', l_item);

Line 670: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');

666: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
667: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
668: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
669: ELSIF p_object_type = 'Z' THEN --- Subinventory
670: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
671: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
672: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
673: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
674: ELSIF p_object_type = 'L' THEN --- Locator

Line 671: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);

667: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
668: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
669: ELSIF p_object_type = 'Z' THEN --- Subinventory
670: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
671: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
672: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
673: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
674: ELSIF p_object_type = 'L' THEN --- Locator
675: SELECT substr(concatenated_segments,1,100)

Line 672: FND_MESSAGE.SET_TOKEN('ITEM', l_item);

668: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
669: ELSIF p_object_type = 'Z' THEN --- Subinventory
670: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
671: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
672: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
673: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
674: ELSIF p_object_type = 'L' THEN --- Locator
675: SELECT substr(concatenated_segments,1,100)
676: INTO l_locator

Line 673: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);

669: ELSIF p_object_type = 'Z' THEN --- Subinventory
670: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
671: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
672: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
673: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
674: ELSIF p_object_type = 'L' THEN --- Locator
675: SELECT substr(concatenated_segments,1,100)
676: INTO l_locator
677: FROM wms_item_locations_kfv

Line 682: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB_LOC');

678: WHERE organization_id = p_organization_id
679: AND subinventory_code = p_sub_code
680: AND inventory_location_id = p_locator_id;
681:
682: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB_LOC');
683: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
684: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
685: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050
686: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);

Line 683: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);

679: AND subinventory_code = p_sub_code
680: AND inventory_location_id = p_locator_id;
681:
682: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB_LOC');
683: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
684: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
685: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050
686: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);
687: END IF;

Line 684: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);

680: AND inventory_location_id = p_locator_id;
681:
682: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB_LOC');
683: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
684: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
685: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050
686: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);
687: END IF;
688:

Line 685: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050

681:
682: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB_LOC');
683: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
684: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
685: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050
686: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);
687: END IF;
688:
689: x_return_status := FND_API.G_RET_STS_ERROR;

Line 686: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);

682: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB_LOC');
683: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
684: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
685: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050
686: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);
687: END IF;
688:
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: x_error_msg := fnd_message.get;

Line 690: x_error_msg := fnd_message.get;

686: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);
687: END IF;
688:
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: x_error_msg := fnd_message.get;
691:
692: END IF;
693:
694: EXCEPTION

Line 701: x_error_msg := fnd_message.get;

697: gme_debug.put_line('When others exception in Is_Material_Status_Applicable');
698: END IF;
699: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Is_Material_Status_Applicable');
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: x_error_msg := fnd_message.get;
702:
703: END Is_Material_Status_Applicable;
704:
705: /*+========================================================================+

Line 757: x_error_msg := fnd_message.get;

753: gme_debug.put_line('When others exception in fetch aggrageted txns');
754: END IF;
755: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_txns');
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: x_error_msg := fnd_message.get;
758:
759: END Fetch_Aggregated_Txns;
760:
761: /*+========================================================================+

Line 814: x_error_msg := fnd_message.get;

810: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
811: END IF;
812: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_lot_txns');
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: x_error_msg := fnd_message.get;
815:
816: END Fetch_Aggregated_Lot_Txns;
817:
818: /* Bug 5451006: Added to used in return of the revision controlled plain items */

Line 874: x_error_msg := fnd_message.get;

870: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
871: END IF;
872: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_rev_txns');
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: x_error_msg := fnd_message.get;
875:
876: END Fetch_Aggregated_Rev_Txns;
877:
878: /*+========================================================================+

Line 946: x_error_msg := fnd_message.get;

942: gme_debug.put_line('When others exception in fetch Mtl Transactions');
943: END IF;
944: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_transactions');
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: x_error_msg := fnd_message.get;
947:
948: END Fetch_Material_Transactions;
949:
950: /*+========================================================================+

Line 997: x_error_msg := fnd_message.get;

993: gme_debug.put_line('When others exception in fetch Mtl Lot Transactions');
994: END IF;
995: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_lot_transactions');
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: x_error_msg := fnd_message.get;
998:
999: END Fetch_Lot_Transactions;
1000:
1001: /*+========================================================================+

Line 1051: --x_error_msg := fnd_message.get;

1047: x_msg_data => l_msg_data,
1048: x_trans_count => l_trans_count);
1049:
1050: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1051: --x_error_msg := fnd_message.get;
1052: x_error_msg := l_msg_data;
1053: /* Bug 5438355: Added success message. */
1054: ELSE
1055: gme_common_pvt.log_message('PM_SAVED_CHANGES');

Line 1074: x_error_msg := fnd_message.get;

1070: gme_debug.put_line('When others exception in Process_Transactions');
1071: END IF;
1072: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','process_transactions');
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: x_error_msg := fnd_message.get;
1075:
1076: END Process_Interface_Txn;
1077:
1078: /*+========================================================================+

Line 1128: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

1124: , p_child_lot_number => p_lot_number
1125: ) ;
1126:
1127: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1128: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1129: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.VALIDATE_CHILD_LOT');
1130: fnd_msg_pub.ADD;
1131: RAISE fnd_api.g_exc_unexpected_error;
1132: END IF;

Line 1129: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.VALIDATE_CHILD_LOT');

1125: ) ;
1126:
1127: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1128: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1129: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.VALIDATE_CHILD_LOT');
1130: fnd_msg_pub.ADD;
1131: RAISE fnd_api.g_exc_unexpected_error;
1132: END IF;
1133:

Line 1589: fnd_message.set_name('INV', 'INV_INT_TDATEEX');

1585: x_error_msg := ' ';
1586:
1587: --- Check that transaction date is not in the future
1588: IF p_txn_date > SYSDATE THEN
1589: fnd_message.set_name('INV', 'INV_INT_TDATEEX');
1590: RAISE DATE_ERROR;
1591: END IF;
1592:
1593: --- Check that transaction date falls within an open period

Line 1600: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');

1596: , period_id => x_period_id
1597: , open_past_period => l_open_past_period);
1598:
1599: IF x_period_id <= 0 THEN
1600: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
1601: RAISE DATE_ERROR;
1602: END IF;
1603:
1604:

Line 1608: x_error_msg := fnd_message.get;

1604:
1605: EXCEPTION
1606: WHEN DATE_ERROR THEN
1607: x_period_id := -1;
1608: x_error_msg := fnd_message.get;
1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610:
1611: WHEN OTHERS THEN
1612: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 1617: x_error_msg := fnd_message.get;

1613: gme_debug.put_line('When others exception in Validate Txn Date');
1614: END IF;
1615: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Txn_Date');
1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: x_error_msg := fnd_message.get;
1618:
1619: END Validate_Txn_Date;
1620:
1621: /*+========================================================================+

Line 1676: FND_MESSAGE.SET_NAME('GME', 'PM_INVBATCHNO');

1672:
1673: OPEN Cur_batch_no;
1674: FETCH Cur_batch_no INTO l_parent_line_id;
1675: IF Cur_batch_no%NOTFOUND THEN
1676: FND_MESSAGE.SET_NAME('GME', 'PM_INVBATCHNO');
1677: FND_MESSAGE.SET_TOKEN('STEP_NO', l_batchstep_no);
1678: CLOSE Cur_batch_no;
1679: RAISE BATCH_NOT_VALID;
1680: END IF;

Line 1677: FND_MESSAGE.SET_TOKEN('STEP_NO', l_batchstep_no);

1673: OPEN Cur_batch_no;
1674: FETCH Cur_batch_no INTO l_parent_line_id;
1675: IF Cur_batch_no%NOTFOUND THEN
1676: FND_MESSAGE.SET_NAME('GME', 'PM_INVBATCHNO');
1677: FND_MESSAGE.SET_TOKEN('STEP_NO', l_batchstep_no);
1678: CLOSE Cur_batch_no;
1679: RAISE BATCH_NOT_VALID;
1680: END IF;
1681:

Line 1689: FND_MESSAGE.SET_NAME('GME','GME_STEP_CLOSED_ERR');

1685: -- item associated to a closed step.
1686: OPEN cur_get_step_status;
1687: FETCH cur_get_step_status INTO l_batchstep_no;
1688: IF cur_get_step_status%FOUND THEN
1689: FND_MESSAGE.SET_NAME('GME','GME_STEP_CLOSED_ERR');
1690: FND_MESSAGE.SET_TOKEN('STEP_NO', l_batchstep_no);
1691: CLOSE cur_get_step_status;
1692: RAISE BATCH_NOT_VALID;
1693: END IF;

Line 1690: FND_MESSAGE.SET_TOKEN('STEP_NO', l_batchstep_no);

1686: OPEN cur_get_step_status;
1687: FETCH cur_get_step_status INTO l_batchstep_no;
1688: IF cur_get_step_status%FOUND THEN
1689: FND_MESSAGE.SET_NAME('GME','GME_STEP_CLOSED_ERR');
1690: FND_MESSAGE.SET_TOKEN('STEP_NO', l_batchstep_no);
1691: CLOSE cur_get_step_status;
1692: RAISE BATCH_NOT_VALID;
1693: END IF;
1694:

Line 1698: FND_MESSAGE.SET_NAME('GME', 'PM_INVALID_PHANTOM_ACTION');

1694:
1695: CLOSE cur_get_step_status;
1696:
1697: IF l_parent_line_id > 0 THEN
1698: FND_MESSAGE.SET_NAME('GME', 'PM_INVALID_PHANTOM_ACTION');
1699: RAISE BATCH_NOT_VALID;
1700: END IF;
1701:
1702:

Line 1706: x_error_msg := fnd_message.get;

1702:
1703: EXCEPTION
1704: WHEN BATCH_NOT_VALID THEN
1705: x_return_status := FND_API.G_RET_STS_ERROR;
1706: x_error_msg := fnd_message.get;
1707:
1708: WHEN OTHERS THEN
1709: IF g_debug <= gme_debug.g_log_unexpected THEN
1710: gme_debug.put_line('When others exception in Validate Batch For IB');

Line 1714: x_error_msg := fnd_message.get;

1710: gme_debug.put_line('When others exception in Validate Batch For IB');
1711: END IF;
1712: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Batch_For_IB');
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: x_error_msg := fnd_message.get;
1715:
1716: END Validate_Batch_For_IB;
1717:
1718: /*+========================================================================+

Line 1772: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_PHANTOM_NOT_EXPLOD');

1768: -- cannot consume it.
1769:
1770: IF l_mat_rec.phantom_ind <> 0 THEN
1771: IF l_mat_rec.phantom_line_id IS NULL THEN
1772: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_PHANTOM_NOT_EXPLOD');
1773: RAISE ITEM_NOT_VALID;
1774: END IF;
1775: END IF;
1776:

Line 1778: FND_MESSAGE.SET_NAME('GME', 'GME_API_INV_RELEASE_TYPE');

1774: END IF;
1775: END IF;
1776:
1777: IF l_mat_rec.release_type IN (0,3) THEN
1778: FND_MESSAGE.SET_NAME('GME', 'GME_API_INV_RELEASE_TYPE');
1779: RAISE ITEM_NOT_VALID;
1780: END IF;
1781:
1782: -- Bug#5331639. Compare wip_plan_qty instead of plan_qty

Line 1784: FND_MESSAGE.SET_NAME('GME', 'GME_API_INV_PLAN_QTY_PC');

1780: END IF;
1781:
1782: -- Bug#5331639. Compare wip_plan_qty instead of plan_qty
1783: IF l_mat_rec.wip_planned_qty = 0 THEN
1784: FND_MESSAGE.SET_NAME('GME', 'GME_API_INV_PLAN_QTY_PC');
1785: RAISE ITEM_NOT_VALID;
1786: END IF;
1787:
1788:

Line 1792: x_error_msg := fnd_message.get;

1788:
1789: EXCEPTION
1790: WHEN ITEM_NOT_VALID THEN
1791: x_return_status := FND_API.G_RET_STS_ERROR;
1792: x_error_msg := fnd_message.get;
1793:
1794: WHEN OTHERS THEN
1795: IF g_debug <= gme_debug.g_log_unexpected THEN
1796: gme_debug.put_line('When others exception in Validate Item For IB');

Line 1800: x_error_msg := fnd_message.get;

1796: gme_debug.put_line('When others exception in Validate Item For IB');
1797: END IF;
1798: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_For_IB');
1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1800: x_error_msg := fnd_message.get;
1801:
1802: END Validate_Item_For_IB;
1803:
1804:

Line 1886: FND_MESSAGE.SET_NAME('GME','GME_INCR_BACKFLUSH_EXCEPTIONS');

1882: gme_debug.put_line('Error Msg = '||l_msg_list);
1883: END IF;
1884:
1885: IF x_return_status = 'X' THEN
1886: FND_MESSAGE.SET_NAME('GME','GME_INCR_BACKFLUSH_EXCEPTIONS');
1887: x_error_msg := FND_MESSAGE.GET;
1888: RAISE BACKFLUSH_ERROR;
1889: ELSIF x_return_status <> 'S' THEN
1890: FND_MSG_PUB.GET(p_msg_index => 1,

Line 1887: x_error_msg := FND_MESSAGE.GET;

1883: END IF;
1884:
1885: IF x_return_status = 'X' THEN
1886: FND_MESSAGE.SET_NAME('GME','GME_INCR_BACKFLUSH_EXCEPTIONS');
1887: x_error_msg := FND_MESSAGE.GET;
1888: RAISE BACKFLUSH_ERROR;
1889: ELSIF x_return_status <> 'S' THEN
1890: FND_MSG_PUB.GET(p_msg_index => 1,
1891: p_data => x_error_msg,

Line 1911: x_error_msg := fnd_message.get;

1907: gme_debug.put_line('When others exception in Backflush Material');
1908: END IF;
1909: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Backflush_Material');
1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1911: x_error_msg := fnd_message.get;
1912: ROLLBACK;
1913:
1914: END Backflush_Material;
1915:

Line 2013: x_error_msg := fnd_message.get;

2009: gme_debug.put_line('When others exception in Save Resource Usage');
2010: END IF;
2011: x_result := -4;
2012: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Save_Resource_Usage');
2013: x_error_msg := fnd_message.get;
2014: ROLLBACK;
2015:
2016: END Save_Resource_Usage;
2017:

Line 2090: x_error_msg := fnd_message.get;

2086: gme_debug.put_line('When others exception in fetch Pending Lots');
2087: END IF;
2088: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_pending_product_lots');
2089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2090: x_error_msg := fnd_message.get;
2091:
2092: END Fetch_Product_Pending_Lots;
2093:
2094:

Line 2154: x_error_msg := fnd_message.get;

2150: gme_debug.put_line('When others exception in fetch Rev Pending Lots');
2151: END IF;
2152: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_rev_pending_product_lots');
2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2154: x_error_msg := fnd_message.get;
2155:
2156: END Fetch_Rev_Product_Pending_Lots;
2157:
2158: /*+========================================================================+

Line 2281: x_error_msg := fnd_message.get;

2277: gme_debug.put_line('When others exception in Create Pending Lots');
2278: END IF;
2279: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_pending_product_lots');
2280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2281: x_error_msg := fnd_message.get;
2282:
2283: END Create_Product_Pending_Lot;
2284:
2285: /*+========================================================================+

Line 2549: x_error_msg := fnd_message.get;

2545:
2546: END IF;
2547: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Populate_Dispensing_Table');
2548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2549: x_error_msg := fnd_message.get;
2550:
2551: END Populate_Dispensing_Table;
2552:
2553: /*+========================================================================+

Line 2592: x_error_msg := fnd_message.get;

2588: gme_debug.put_line('When others exception in Delete_Dispensing_Record');
2589: END IF;
2590: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Delete_Dispensing_Record');
2591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2592: x_error_msg := fnd_message.get;
2593:
2594: END Delete_Dispensing_Record;
2595:
2596: /*+========================================================================+

Line 2643: x_error_msg := fnd_message.get;

2639: gme_debug.put_line('When others exception in Get_Dispensed_Lot_Count');
2640: END IF;
2641: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Get_Dispensed_Lot_Count');
2642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2643: x_error_msg := fnd_message.get;
2644:
2645: END Get_Dispensed_Lot_Count;
2646:
2647: /*+========================================================================+

Line 2858: x_error_msg := fnd_message.get;

2854: gme_debug.put_line('When others exception in Create Qty Tree');
2855: END IF;
2856: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Create_Qty_Tree');
2857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2858: x_error_msg := fnd_message.get;
2859:
2860: END Create_Qty_Tree;
2861:
2862: /*+========================================================================+

Line 2950: x_error_msg := fnd_message.get;

2946: gme_debug.put_line('When others exception in Query_Tree');
2947: END IF;
2948: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Tree');
2949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2950: x_error_msg := fnd_message.get;
2951:
2952: END Query_Qty_Tree;
2953:
2954: /*+========================================================================+

Line 3070: x_error_msg := fnd_message.get;

3066: gme_debug.put_line('When others exception in Update Qty Tree');
3067: END IF;
3068: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Update_Qty_Tree');
3069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3070: x_error_msg := fnd_message.get;
3071:
3072: END Update_Qty_Tree;
3073:
3074: /*+========================================================================+

Line 3183: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_PHANTOM_NOT_EXPLOD');

3179: -- cannot consume it.
3180:
3181: IF l_phantom_type <> 0 THEN
3182: IF l_phantom_line_id IS NULL THEN
3183: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_PHANTOM_NOT_EXPLOD');
3184: RAISE ITEM_NOT_VALID;
3185: END IF;
3186: END IF;
3187:

Line 3198: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_STEP_WIP_COMPLETE');

3194: ,x_batchstep_status => l_batchstep_status);
3195: IF l_is_item_associated_to_step AND
3196: l_batchstep_status <> 2 AND
3197: l_batchstep_status <> 3 THEN
3198: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_STEP_WIP_COMPLETE');
3199: RAISE ITEM_NOT_VALID;
3200: END IF;
3201: END IF;
3202:

Line 3211: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_INDIV_PPLOT_EXIST');

3207: FETCH Get_pplot_count INTO l_pplot_count;
3208: CLOSE Get_pplot_count;
3209:
3210: IF l_pplot_count > 0 THEN
3211: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_INDIV_PPLOT_EXIST');
3212: RAISE ITEM_NOT_VALID;
3213: END IF;
3214: END IF; */
3215:

Line 3219: x_error_msg := fnd_message.get;

3215:
3216: EXCEPTION
3217: WHEN ITEM_NOT_VALID THEN
3218: x_return_status := FND_API.G_RET_STS_ERROR;
3219: x_error_msg := fnd_message.get;
3220:
3221: WHEN OTHERS THEN
3222: IF g_debug <= gme_debug.g_log_unexpected THEN
3223: gme_debug.put_line('When others exception in Validate Item To Issue');

Line 3227: x_error_msg := fnd_message.get;

3223: gme_debug.put_line('When others exception in Validate Item To Issue');
3224: END IF;
3225: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Issue');
3226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3227: x_error_msg := fnd_message.get;
3228:
3229: END Validate_Item_To_Issue;
3230:
3231: /*+========================================================================+

Line 3279: FND_MESSAGE.SET_NAME('GME', 'GME_RETURN_DISPENSE_ING_ERROR');

3275:
3276: -- Cannot return an ingredient that was dispensed
3277:
3278: IF l_dispense_ind = 'Y' THEN
3279: FND_MESSAGE.SET_NAME('GME', 'GME_RETURN_DISPENSE_ING_ERROR');
3280: RAISE ITEM_NOT_VALID;
3281: END IF;
3282:
3283: EXCEPTION

Line 3286: x_error_msg := fnd_message.get;

3282:
3283: EXCEPTION
3284: WHEN ITEM_NOT_VALID THEN
3285: x_return_status := FND_API.G_RET_STS_ERROR;
3286: x_error_msg := fnd_message.get;
3287:
3288: WHEN OTHERS THEN
3289: IF g_debug <= gme_debug.g_log_unexpected THEN
3290: gme_debug.put_line('When others exception in Validate Item To Return');

Line 3294: x_error_msg := fnd_message.get;

3290: gme_debug.put_line('When others exception in Validate Item To Return');
3291: END IF;
3292: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Return');
3293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3294: x_error_msg := fnd_message.get;
3295:
3296: END Validate_Item_To_Return;
3297:
3298: /*+========================================================================+

Line 3365: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');

3361: -- b) if not associated to a step, batch status must be Completed
3362:
3363: IF l_release_type = GME_COMMON_PVT.g_mtl_auto_release THEN
3364: IF l_batch_status <> 3 THEN
3365: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');
3366: RAISE ITEM_NOT_VALID;
3367: END IF;
3368: ELSIF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN
3369: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(

Line 3375: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_STEP_COMPLETE');

3371: ,x_batchstep_id => l_batchstep_id
3372: ,x_batchstep_status => l_batchstep_status);
3373: IF l_is_item_associated_to_step THEN
3374: IF l_batchstep_status <> 3 THEN
3375: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_STEP_COMPLETE');
3376: RAISE ITEM_NOT_VALID;
3377: END IF;
3378: ELSIF l_batch_status <> 3 THEN
3379: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');

Line 3379: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');

3375: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_STEP_COMPLETE');
3376: RAISE ITEM_NOT_VALID;
3377: END IF;
3378: ELSIF l_batch_status <> 3 THEN
3379: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');
3380: RAISE ITEM_NOT_VALID;
3381: END IF;
3382: END IF;
3383:

Line 3389: x_error_msg := fnd_message.get;

3385:
3386: EXCEPTION
3387: WHEN ITEM_NOT_VALID THEN
3388: x_return_status := FND_API.G_RET_STS_ERROR;
3389: x_error_msg := fnd_message.get;
3390:
3391: WHEN OTHERS THEN
3392: IF g_debug <= gme_debug.g_log_unexpected THEN
3393: gme_debug.put_line('When others exception in Validate Prod To Yield');

Line 3397: x_error_msg := fnd_message.get;

3393: gme_debug.put_line('When others exception in Validate Prod To Yield');
3394: END IF;
3395: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Prod_To_Yield');
3396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3397: x_error_msg := fnd_message.get;
3398:
3399: END Validate_Prod_To_Yield;
3400:
3401: /*+========================================================================+

Line 3472: x_error_msg := fnd_message.get;

3468: gme_debug.put_line('When others exception in fetch Issue Transactions');
3469: END IF;
3470: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_issue_transactions');
3471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3472: x_error_msg := fnd_message.get;
3473:
3474: END Fetch_Issue_Transactions;
3475:
3476: /*+========================================================================+

Line 3551: x_error_msg := fnd_message.get;

3547: gme_debug.put_line('When others exception in fetch yield Transactions');
3548: END IF;
3549: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_yield_transactions');
3550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3551: x_error_msg := fnd_message.get;
3552:
3553: END Fetch_Yield_Transactions;
3554:
3555:

Line 3668: x_error_msg := fnd_message.get;

3664:
3665: EXCEPTION
3666: WHEN fnd_api.g_exc_error THEN
3667: x_return_status := fnd_api.g_ret_sts_error;
3668: x_error_msg := fnd_message.get;
3669:
3670: WHEN fnd_api.g_exc_unexpected_error THEN
3671: x_return_status := fnd_api.g_ret_sts_unexp_error;
3672:

Line 3676: x_error_msg := fnd_message.get;

3672:
3673: WHEN OTHERS THEN
3674: x_return_status := fnd_api.g_ret_sts_unexp_error;
3675: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3676: x_error_msg := fnd_message.get;
3677: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3678: gme_debug.put_line ( g_pkg_name
3679: || '.'
3680: || l_api_name

Line 3807: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');

3803: WHEN expected_error THEN
3804: x_return_status := FND_API.G_RET_STS_ERROR;
3805: WHEN step_alloc_error THEN
3806: ROLLBACK TO SAVEPOINT complete_step_mobile ;
3807: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3808: x_message_list := FND_MESSAGE.GET;
3809: WHEN validate_step_error THEN
3810: gme_common_pvt.count_and_get (x_count => x_message_count
3811: ,p_encoded => fnd_api.g_false

Line 3808: x_message_list := FND_MESSAGE.GET;

3804: x_return_status := FND_API.G_RET_STS_ERROR;
3805: WHEN step_alloc_error THEN
3806: ROLLBACK TO SAVEPOINT complete_step_mobile ;
3807: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3808: x_message_list := FND_MESSAGE.GET;
3809: WHEN validate_step_error THEN
3810: gme_common_pvt.count_and_get (x_count => x_message_count
3811: ,p_encoded => fnd_api.g_false
3812: ,x_data => x_message_list);

Line 3814: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_CMPL_STEP');

3810: gme_common_pvt.count_and_get (x_count => x_message_count
3811: ,p_encoded => fnd_api.g_false
3812: ,x_data => x_message_list);
3813: WHEN validate_step_status_error THEN
3814: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_CMPL_STEP');
3815: x_message_list := FND_MESSAGE.GET;
3816: WHEN OTHERS THEN
3817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3818: END complete_step;

Line 3815: x_message_list := FND_MESSAGE.GET;

3811: ,p_encoded => fnd_api.g_false
3812: ,x_data => x_message_list);
3813: WHEN validate_step_status_error THEN
3814: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_CMPL_STEP');
3815: x_message_list := FND_MESSAGE.GET;
3816: WHEN OTHERS THEN
3817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3818: END complete_step;
3819:

Line 4003: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');

3999: WHEN expected_error THEN
4000: x_return_status := FND_API.G_RET_STS_ERROR;
4001: WHEN step_alloc_error THEN
4002: ROLLBACK TO SAVEPOINT release_step_mobile ;
4003: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
4004: x_message_list := FND_MESSAGE.GET;
4005: WHEN validate_step_error THEN
4006: GME_COMMON_PVT.count_and_get (x_count => l_count
4007: ,p_encoded => fnd_api.g_false

Line 4004: x_message_list := FND_MESSAGE.GET;

4000: x_return_status := FND_API.G_RET_STS_ERROR;
4001: WHEN step_alloc_error THEN
4002: ROLLBACK TO SAVEPOINT release_step_mobile ;
4003: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
4004: x_message_list := FND_MESSAGE.GET;
4005: WHEN validate_step_error THEN
4006: GME_COMMON_PVT.count_and_get (x_count => l_count
4007: ,p_encoded => fnd_api.g_false
4008: ,x_data => x_message_list);

Line 4011: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_REL_STEP');

4007: ,p_encoded => fnd_api.g_false
4008: ,x_data => x_message_list);
4009:
4010: WHEN validate_step_status_error THEN
4011: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_REL_STEP');
4012: x_message_list := FND_MESSAGE.GET;
4013: WHEN OTHERS THEN
4014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4015: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 4012: x_message_list := FND_MESSAGE.GET;

4008: ,x_data => x_message_list);
4009:
4010: WHEN validate_step_status_error THEN
4011: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_REL_STEP');
4012: x_message_list := FND_MESSAGE.GET;
4013: WHEN OTHERS THEN
4014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4015: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4016: END release_step;

Line 4121: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');

4117: END IF;
4118: EXCEPTION
4119: WHEN FUTURE_DATE_EX THEN
4120: x_return_status := FND_API.G_RET_STS_ERROR;
4121: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
4122: x_error_msg := FND_MESSAGE.GET;
4123: WHEN INVALID_STEP_COMPLT_DATE THEN
4124: x_return_status := FND_API.G_RET_STS_ERROR;
4125: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');

Line 4122: x_error_msg := FND_MESSAGE.GET;

4118: EXCEPTION
4119: WHEN FUTURE_DATE_EX THEN
4120: x_return_status := FND_API.G_RET_STS_ERROR;
4121: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
4122: x_error_msg := FND_MESSAGE.GET;
4123: WHEN INVALID_STEP_COMPLT_DATE THEN
4124: x_return_status := FND_API.G_RET_STS_ERROR;
4125: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');
4126: x_error_msg := FND_MESSAGE.GET;

Line 4125: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');

4121: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
4122: x_error_msg := FND_MESSAGE.GET;
4123: WHEN INVALID_STEP_COMPLT_DATE THEN
4124: x_return_status := FND_API.G_RET_STS_ERROR;
4125: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');
4126: x_error_msg := FND_MESSAGE.GET;
4127: WHEN OTHERS THEN
4128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4129: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 4126: x_error_msg := FND_MESSAGE.GET;

4122: x_error_msg := FND_MESSAGE.GET;
4123: WHEN INVALID_STEP_COMPLT_DATE THEN
4124: x_return_status := FND_API.G_RET_STS_ERROR;
4125: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');
4126: x_error_msg := FND_MESSAGE.GET;
4127: WHEN OTHERS THEN
4128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4129: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4130: x_error_msg := FND_MESSAGE.GET;

Line 4130: x_error_msg := FND_MESSAGE.GET;

4126: x_error_msg := FND_MESSAGE.GET;
4127: WHEN OTHERS THEN
4128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4129: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4130: x_error_msg := FND_MESSAGE.GET;
4131: END Validate_Step_Completion_Date;
4132:
4133: /*###############################################################
4134: # DESCRIPTION

Line 4149: FND_MESSAGE.SET_NAME('GME', 'GME_VALUE_ERROR');

4145: l_step_qty := TO_NUMBER(p_step_qty);
4146: EXCEPTION
4147: WHEN VALUE_ERROR THEN
4148: x_return_status := FND_API.G_RET_STS_ERROR;
4149: FND_MESSAGE.SET_NAME('GME', 'GME_VALUE_ERROR');
4150: x_error_msg := FND_MESSAGE.GET;
4151: WHEN OTHERS THEN
4152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4153: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 4150: x_error_msg := FND_MESSAGE.GET;

4146: EXCEPTION
4147: WHEN VALUE_ERROR THEN
4148: x_return_status := FND_API.G_RET_STS_ERROR;
4149: FND_MESSAGE.SET_NAME('GME', 'GME_VALUE_ERROR');
4150: x_error_msg := FND_MESSAGE.GET;
4151: WHEN OTHERS THEN
4152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4153: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4154: x_error_msg := FND_MESSAGE.GET;

Line 4154: x_error_msg := FND_MESSAGE.GET;

4150: x_error_msg := FND_MESSAGE.GET;
4151: WHEN OTHERS THEN
4152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4153: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4154: x_error_msg := FND_MESSAGE.GET;
4155: END Validate_Step_Qty;
4156:
4157: /*###############################################################
4158: # DESCRIPTION

Line 4205: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');

4201: END IF;
4202: EXCEPTION
4203: WHEN FUTURE_DATE_EX THEN
4204: x_return_status := FND_API.G_RET_STS_ERROR;
4205: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
4206: x_error_msg := FND_MESSAGE.GET;
4207: WHEN INVALID_STEP_START_DATE THEN
4208: x_return_status := FND_API.G_RET_STS_ERROR;
4209: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');

Line 4206: x_error_msg := FND_MESSAGE.GET;

4202: EXCEPTION
4203: WHEN FUTURE_DATE_EX THEN
4204: x_return_status := FND_API.G_RET_STS_ERROR;
4205: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
4206: x_error_msg := FND_MESSAGE.GET;
4207: WHEN INVALID_STEP_START_DATE THEN
4208: x_return_status := FND_API.G_RET_STS_ERROR;
4209: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');
4210: x_error_msg := FND_MESSAGE.GET;

Line 4209: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');

4205: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
4206: x_error_msg := FND_MESSAGE.GET;
4207: WHEN INVALID_STEP_START_DATE THEN
4208: x_return_status := FND_API.G_RET_STS_ERROR;
4209: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');
4210: x_error_msg := FND_MESSAGE.GET;
4211: WHEN OTHERS THEN
4212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4213: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 4210: x_error_msg := FND_MESSAGE.GET;

4206: x_error_msg := FND_MESSAGE.GET;
4207: WHEN INVALID_STEP_START_DATE THEN
4208: x_return_status := FND_API.G_RET_STS_ERROR;
4209: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');
4210: x_error_msg := FND_MESSAGE.GET;
4211: WHEN OTHERS THEN
4212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4213: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4214: x_error_msg := FND_MESSAGE.GET;

Line 4214: x_error_msg := FND_MESSAGE.GET;

4210: x_error_msg := FND_MESSAGE.GET;
4211: WHEN OTHERS THEN
4212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4213: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4214: x_error_msg := FND_MESSAGE.GET;
4215: END Validate_Step_Start_Date;
4216:
4217: PROCEDURE check_close_period(p_org_id IN NUMBER,
4218: p_trans_date IN DATE,

Line 4305: x_error_msg := fnd_message.get;

4301: gme_debug.put_line('When others exception in fetch_txn_date');
4302: END IF;
4303: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_txn_date');
4304: x_return_status := fnd_api.g_ret_sts_unexp_error;
4305: x_error_msg := fnd_message.get;
4306: END;
4307:
4308: --Bug#5867209 added restricted subinv code
4309: PROCEDURE Validate_Subinv_Master(p_organization_id IN NUMBER,

Line 4362: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_SUBINV');

4358:
4359: EXCEPTION
4360: WHEN ERROR_INV_SUBINV THEN
4361: x_return_status := fnd_api.g_ret_sts_error;
4362: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_SUBINV');
4363: x_error_message := FND_MESSAGE.GET;
4364: END Validate_Subinv_Master;
4365:
4366: --Bug#5867209 added restricted locator code

Line 4363: x_error_message := FND_MESSAGE.GET;

4359: EXCEPTION
4360: WHEN ERROR_INV_SUBINV THEN
4361: x_return_status := fnd_api.g_ret_sts_error;
4362: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_SUBINV');
4363: x_error_message := FND_MESSAGE.GET;
4364: END Validate_Subinv_Master;
4365:
4366: --Bug#5867209 added restricted locator code
4367: PROCEDURE Validate_Locator_Master(p_organization_id IN NUMBER,

Line 4419: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_LOC');

4415: END IF;
4416: EXCEPTION
4417: WHEN ERROR_INVALID_LOCATOR THEN
4418: x_return_status := fnd_api.g_ret_sts_error;
4419: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_LOC');
4420: x_error_message := FND_MESSAGE.GET;
4421: END Validate_Locator_Master;
4422: /* Bug#5663458 End*/
4423:

Line 4420: x_error_message := FND_MESSAGE.GET;

4416: EXCEPTION
4417: WHEN ERROR_INVALID_LOCATOR THEN
4418: x_return_status := fnd_api.g_ret_sts_error;
4419: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_LOC');
4420: x_error_message := FND_MESSAGE.GET;
4421: END Validate_Locator_Master;
4422: /* Bug#5663458 End*/
4423:
4424: --Bug#5867209 added the procedure

Line 4461: x_error_msg := fnd_message.get;

4457: gme_debug.put_line('When others exception in Fetch_subinv_locator');
4458: END IF;
4459: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Fetch_subinv_locator');
4460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4461: x_error_msg := fnd_message.get;
4462: END Fetch_subinv_locator;
4463:
4464: -- nsinghi bug#5209065 START. Added following Procs.
4465: PROCEDURE get_expiration_date (

Line 4500: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

4496: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4497: IF g_debug <= gme_debug.g_log_statement THEN
4498: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4499: END IF;
4500: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4501: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
4502: fnd_msg_pub.ADD;
4503: RAISE fnd_api.g_exc_unexpected_error;
4504: END IF;

Line 4501: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');

4497: IF g_debug <= gme_debug.g_log_statement THEN
4498: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4499: END IF;
4500: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4501: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
4502: fnd_msg_pub.ADD;
4503: RAISE fnd_api.g_exc_unexpected_error;
4504: END IF;
4505: IF g_debug = 1 THEN