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 128: fnd_message.set_name('GME','INVALID_VALUE');

124: END IF;
125: EXCEPTION
126: WHEN NO_RSRV_PNDLOT_ID THEN
127: x_return_status := fnd_api.g_ret_sts_error;
128: fnd_message.set_name('GME','INVALID_VALUE');
129: x_error_msg := fnd_message.get;
130: WHEN OTHERS THEN
131: IF g_debug <= gme_debug.g_log_unexpected THEN
132: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');

Line 129: x_error_msg := fnd_message.get;

125: EXCEPTION
126: WHEN NO_RSRV_PNDLOT_ID THEN
127: x_return_status := fnd_api.g_ret_sts_error;
128: fnd_message.set_name('GME','INVALID_VALUE');
129: x_error_msg := fnd_message.get;
130: WHEN OTHERS THEN
131: IF g_debug <= gme_debug.g_log_unexpected THEN
132: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');
133: END IF;

Line 136: x_error_msg := fnd_message.get;

132: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');
133: END IF;
134: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_pend_lots');
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: x_error_msg := fnd_message.get;
137:
138: END relieve_resvns_pend_lots;
139:
140:

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

294:
295:
296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: -- Bug 5255933 Use GME_COMMON_PVT to get error message
298: --x_error_msg := fnd_message.get;
299: GME_COMMON_PVT.count_and_get (x_count => l_count
300: ,p_encoded => fnd_api.g_false
301: ,x_data => x_error_msg);
302:

Line 319: x_error_msg := fnd_message.get;

315: gme_debug.put_line('When others exception in Create MAterial Txn');
316: END IF;
317: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_material_txn');
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: x_error_msg := fnd_message.get;
320:
321: END Create_Material_Txn;
322:
323: /*+========================================================================+

Line 387: x_error_msg := fnd_message.get;

383: x_return_status => x_return_status
384: );
385:
386: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
387: x_error_msg := fnd_message.get;
388: END IF;
389:
390: EXCEPTION
391: WHEN OTHERS THEN

Line 397: x_error_msg := fnd_message.get;

393: gme_debug.put_line('When others exception in Create Lot Txn');
394: END IF;
395: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_lot_txn');
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: x_error_msg := fnd_message.get;
398:
399: END Create_Lot_Txn;
400:
401: /*+========================================================================+

Line 477: x_error_msg := fnd_message.get;

473: gme_debug.put_line('When others exception in Validate Indiv Lot Txn');
474: END IF;
475: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Indiv_Lot_Txn');
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: x_error_msg := fnd_message.get;
478:
479: END Validate_Indiv_Lot_Txn;
480:
481: /*+========================================================================+

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

570: WHERE organization_id = p_organization_id
571: AND inventory_item_id = p_inventory_item_id;
572:
573: IF p_object_type = 'O' THEN --- Lot
574: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_LOT');
575: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
576: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
577: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
578: ELSIF p_object_type = 'Z' THEN --- Subinventory

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

571: AND inventory_item_id = p_inventory_item_id;
572:
573: IF p_object_type = 'O' THEN --- Lot
574: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_LOT');
575: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
576: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
577: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
578: ELSIF p_object_type = 'Z' THEN --- Subinventory
579: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');

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

572:
573: IF p_object_type = 'O' THEN --- Lot
574: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_LOT');
575: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
576: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
577: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
578: ELSIF p_object_type = 'Z' THEN --- Subinventory
579: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
580: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);

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

573: IF p_object_type = 'O' THEN --- Lot
574: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_LOT');
575: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
576: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
577: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
578: ELSIF p_object_type = 'Z' THEN --- Subinventory
579: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
580: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
581: FND_MESSAGE.SET_TOKEN('ITEM', l_item);

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

575: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
576: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
577: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
578: ELSIF p_object_type = 'Z' THEN --- Subinventory
579: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
580: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
581: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
582: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
583: ELSIF p_object_type = 'L' THEN --- Locator

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

576: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
577: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
578: ELSIF p_object_type = 'Z' THEN --- Subinventory
579: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
580: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
581: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
582: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
583: ELSIF p_object_type = 'L' THEN --- Locator
584: SELECT substr(concatenated_segments,1,100)

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

577: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
578: ELSIF p_object_type = 'Z' THEN --- Subinventory
579: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
580: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
581: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
582: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
583: ELSIF p_object_type = 'L' THEN --- Locator
584: SELECT substr(concatenated_segments,1,100)
585: INTO l_locator

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

578: ELSIF p_object_type = 'Z' THEN --- Subinventory
579: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB');
580: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
581: FND_MESSAGE.SET_TOKEN('ITEM', l_item);
582: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
583: ELSIF p_object_type = 'L' THEN --- Locator
584: SELECT substr(concatenated_segments,1,100)
585: INTO l_locator
586: FROM wms_item_locations_kfv

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

587: WHERE organization_id = p_organization_id
588: AND subinventory_code = p_sub_code
589: AND inventory_location_id = p_locator_id;
590:
591: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB_LOC');
592: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
593: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
594: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050
595: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);

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

588: AND subinventory_code = p_sub_code
589: AND inventory_location_id = p_locator_id;
590:
591: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB_LOC');
592: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
593: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
594: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050
595: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);
596: END IF;

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

589: AND inventory_location_id = p_locator_id;
590:
591: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB_LOC');
592: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
593: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
594: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050
595: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);
596: END IF;
597:

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

590:
591: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB_LOC');
592: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
593: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
594: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050
595: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);
596: END IF;
597:
598: x_return_status := FND_API.G_RET_STS_ERROR;

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

591: FND_MESSAGE.SET_NAME('GME','GME_MATERIAL_STS_INV_SUB_LOC');
592: FND_MESSAGE.SET_TOKEN('TRANSTYPE', l_type);
593: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
594: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050
595: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);
596: END IF;
597:
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: x_error_msg := fnd_message.get;

Line 599: x_error_msg := fnd_message.get;

595: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);
596: END IF;
597:
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: x_error_msg := fnd_message.get;
600:
601: END IF;
602:
603: EXCEPTION

Line 610: x_error_msg := fnd_message.get;

606: gme_debug.put_line('When others exception in Is_Material_Status_Applicable');
607: END IF;
608: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Is_Material_Status_Applicable');
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610: x_error_msg := fnd_message.get;
611:
612: END Is_Material_Status_Applicable;
613:
614: /*+========================================================================+

Line 666: x_error_msg := fnd_message.get;

662: gme_debug.put_line('When others exception in fetch aggrageted txns');
663: END IF;
664: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_txns');
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666: x_error_msg := fnd_message.get;
667:
668: END Fetch_Aggregated_Txns;
669:
670: /*+========================================================================+

Line 723: x_error_msg := fnd_message.get;

719: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
720: END IF;
721: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_lot_txns');
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: x_error_msg := fnd_message.get;
724:
725: END Fetch_Aggregated_Lot_Txns;
726:
727: /* Bug 5451006: Added to used in return of the revision controlled plain items */

Line 783: x_error_msg := fnd_message.get;

779: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
780: END IF;
781: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_rev_txns');
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783: x_error_msg := fnd_message.get;
784:
785: END Fetch_Aggregated_Rev_Txns;
786:
787: /*+========================================================================+

Line 855: x_error_msg := fnd_message.get;

851: gme_debug.put_line('When others exception in fetch Mtl Transactions');
852: END IF;
853: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_transactions');
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855: x_error_msg := fnd_message.get;
856:
857: END Fetch_Material_Transactions;
858:
859: /*+========================================================================+

Line 906: x_error_msg := fnd_message.get;

902: gme_debug.put_line('When others exception in fetch Mtl Lot Transactions');
903: END IF;
904: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_lot_transactions');
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: x_error_msg := fnd_message.get;
907:
908: END Fetch_Lot_Transactions;
909:
910: /*+========================================================================+

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

953: x_msg_data => l_msg_data,
954: x_trans_count => l_trans_count);
955:
956: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
957: --x_error_msg := fnd_message.get;
958: x_error_msg := l_msg_data;
959: /* Bug 5438355: Added success message. */
960: ELSE
961: gme_common_pvt.log_message('PM_SAVED_CHANGES');

Line 978: x_error_msg := fnd_message.get;

974: gme_debug.put_line('When others exception in Process_Transactions');
975: END IF;
976: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','process_transactions');
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: x_error_msg := fnd_message.get;
979:
980: END Process_Interface_Txn;
981:
982: /*+========================================================================+

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

1028: , p_child_lot_number => p_lot_number
1029: ) ;
1030:
1031: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1032: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1033: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.VALIDATE_CHILD_LOT');
1034: fnd_msg_pub.ADD;
1035: RAISE fnd_api.g_exc_unexpected_error;
1036: END IF;

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

1029: ) ;
1030:
1031: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1032: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1033: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.VALIDATE_CHILD_LOT');
1034: fnd_msg_pub.ADD;
1035: RAISE fnd_api.g_exc_unexpected_error;
1036: END IF;
1037:

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

1489: x_error_msg := ' ';
1490:
1491: --- Check that transaction date is not in the future
1492: IF p_txn_date > SYSDATE THEN
1493: fnd_message.set_name('INV', 'INV_INT_TDATEEX');
1494: RAISE DATE_ERROR;
1495: END IF;
1496:
1497: --- Check that transaction date falls within an open period

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

1500: , period_id => x_period_id
1501: , open_past_period => l_open_past_period);
1502:
1503: IF x_period_id <= 0 THEN
1504: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
1505: RAISE DATE_ERROR;
1506: END IF;
1507:
1508:

Line 1512: x_error_msg := fnd_message.get;

1508:
1509: EXCEPTION
1510: WHEN DATE_ERROR THEN
1511: x_period_id := -1;
1512: x_error_msg := fnd_message.get;
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514:
1515: WHEN OTHERS THEN
1516: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 1521: x_error_msg := fnd_message.get;

1517: gme_debug.put_line('When others exception in Validate Txn Date');
1518: END IF;
1519: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Txn_Date');
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: x_error_msg := fnd_message.get;
1522:
1523: END Validate_Txn_Date;
1524:
1525: /*+========================================================================+

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

1576:
1577: OPEN Cur_batch_no;
1578: FETCH Cur_batch_no INTO l_parent_line_id;
1579: IF Cur_batch_no%NOTFOUND THEN
1580: FND_MESSAGE.SET_NAME('GME', 'PM_INVBATCHNO');
1581: FND_MESSAGE.SET_TOKEN('STEP_NO', l_batchstep_no);
1582: CLOSE Cur_batch_no;
1583: RAISE BATCH_NOT_VALID;
1584: END IF;

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

1577: OPEN Cur_batch_no;
1578: FETCH Cur_batch_no INTO l_parent_line_id;
1579: IF Cur_batch_no%NOTFOUND THEN
1580: FND_MESSAGE.SET_NAME('GME', 'PM_INVBATCHNO');
1581: FND_MESSAGE.SET_TOKEN('STEP_NO', l_batchstep_no);
1582: CLOSE Cur_batch_no;
1583: RAISE BATCH_NOT_VALID;
1584: END IF;
1585:

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

1589: -- item associated to a closed step.
1590: OPEN cur_get_step_status;
1591: FETCH cur_get_step_status INTO l_batchstep_no;
1592: IF cur_get_step_status%FOUND THEN
1593: FND_MESSAGE.SET_NAME('GME','GME_STEP_CLOSED_ERR');
1594: FND_MESSAGE.SET_TOKEN('STEP_NO', l_batchstep_no);
1595: CLOSE cur_get_step_status;
1596: RAISE BATCH_NOT_VALID;
1597: END IF;

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

1590: OPEN cur_get_step_status;
1591: FETCH cur_get_step_status INTO l_batchstep_no;
1592: IF cur_get_step_status%FOUND THEN
1593: FND_MESSAGE.SET_NAME('GME','GME_STEP_CLOSED_ERR');
1594: FND_MESSAGE.SET_TOKEN('STEP_NO', l_batchstep_no);
1595: CLOSE cur_get_step_status;
1596: RAISE BATCH_NOT_VALID;
1597: END IF;
1598:

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

1598:
1599: CLOSE cur_get_step_status;
1600:
1601: IF l_parent_line_id > 0 THEN
1602: FND_MESSAGE.SET_NAME('GME', 'PM_INVALID_PHANTOM_ACTION');
1603: RAISE BATCH_NOT_VALID;
1604: END IF;
1605:
1606:

Line 1610: x_error_msg := fnd_message.get;

1606:
1607: EXCEPTION
1608: WHEN BATCH_NOT_VALID THEN
1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610: x_error_msg := fnd_message.get;
1611:
1612: WHEN OTHERS THEN
1613: IF g_debug <= gme_debug.g_log_unexpected THEN
1614: gme_debug.put_line('When others exception in Validate Batch For IB');

Line 1618: x_error_msg := fnd_message.get;

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

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

1672: -- cannot consume it.
1673:
1674: IF l_mat_rec.phantom_ind <> 0 THEN
1675: IF l_mat_rec.phantom_line_id IS NULL THEN
1676: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_PHANTOM_NOT_EXPLOD');
1677: RAISE ITEM_NOT_VALID;
1678: END IF;
1679: END IF;
1680:

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

1678: END IF;
1679: END IF;
1680:
1681: IF l_mat_rec.release_type IN (0,3) THEN
1682: FND_MESSAGE.SET_NAME('GME', 'GME_API_INV_RELEASE_TYPE');
1683: RAISE ITEM_NOT_VALID;
1684: END IF;
1685:
1686: -- Bug#5331639. Compare wip_plan_qty instead of plan_qty

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

1684: END IF;
1685:
1686: -- Bug#5331639. Compare wip_plan_qty instead of plan_qty
1687: IF l_mat_rec.wip_planned_qty = 0 THEN
1688: FND_MESSAGE.SET_NAME('GME', 'GME_API_INV_PLAN_QTY_PC');
1689: RAISE ITEM_NOT_VALID;
1690: END IF;
1691:
1692:

Line 1696: x_error_msg := fnd_message.get;

1692:
1693: EXCEPTION
1694: WHEN ITEM_NOT_VALID THEN
1695: x_return_status := FND_API.G_RET_STS_ERROR;
1696: x_error_msg := fnd_message.get;
1697:
1698: WHEN OTHERS THEN
1699: IF g_debug <= gme_debug.g_log_unexpected THEN
1700: gme_debug.put_line('When others exception in Validate Item For IB');

Line 1704: x_error_msg := fnd_message.get;

1700: gme_debug.put_line('When others exception in Validate Item For IB');
1701: END IF;
1702: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_For_IB');
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: x_error_msg := fnd_message.get;
1705:
1706: END Validate_Item_For_IB;
1707:
1708:

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

1786: gme_debug.put_line('Error Msg = '||l_msg_list);
1787: END IF;
1788:
1789: IF x_return_status = 'X' THEN
1790: FND_MESSAGE.SET_NAME('GME','GME_INCR_BACKFLUSH_EXCEPTIONS');
1791: x_error_msg := FND_MESSAGE.GET;
1792: RAISE BACKFLUSH_ERROR;
1793: ELSIF x_return_status <> 'S' THEN
1794: FND_MSG_PUB.GET(p_msg_index => 1,

Line 1791: x_error_msg := FND_MESSAGE.GET;

1787: END IF;
1788:
1789: IF x_return_status = 'X' THEN
1790: FND_MESSAGE.SET_NAME('GME','GME_INCR_BACKFLUSH_EXCEPTIONS');
1791: x_error_msg := FND_MESSAGE.GET;
1792: RAISE BACKFLUSH_ERROR;
1793: ELSIF x_return_status <> 'S' THEN
1794: FND_MSG_PUB.GET(p_msg_index => 1,
1795: p_data => x_error_msg,

Line 1815: x_error_msg := fnd_message.get;

1811: gme_debug.put_line('When others exception in Backflush Material');
1812: END IF;
1813: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Backflush_Material');
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: x_error_msg := fnd_message.get;
1816: ROLLBACK;
1817:
1818: END Backflush_Material;
1819:

Line 1917: x_error_msg := fnd_message.get;

1913: gme_debug.put_line('When others exception in Save Resource Usage');
1914: END IF;
1915: x_result := -4;
1916: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Save_Resource_Usage');
1917: x_error_msg := fnd_message.get;
1918: ROLLBACK;
1919:
1920: END Save_Resource_Usage;
1921:

Line 1994: x_error_msg := fnd_message.get;

1990: gme_debug.put_line('When others exception in fetch Pending Lots');
1991: END IF;
1992: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_pending_product_lots');
1993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1994: x_error_msg := fnd_message.get;
1995:
1996: END Fetch_Product_Pending_Lots;
1997:
1998:

Line 2058: x_error_msg := fnd_message.get;

2054: gme_debug.put_line('When others exception in fetch Rev Pending Lots');
2055: END IF;
2056: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_rev_pending_product_lots');
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: x_error_msg := fnd_message.get;
2059:
2060: END Fetch_Rev_Product_Pending_Lots;
2061:
2062: /*+========================================================================+

Line 2185: x_error_msg := fnd_message.get;

2181: gme_debug.put_line('When others exception in Create Pending Lots');
2182: END IF;
2183: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_pending_product_lots');
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: x_error_msg := fnd_message.get;
2186:
2187: END Create_Product_Pending_Lot;
2188:
2189: /*+========================================================================+

Line 2453: x_error_msg := fnd_message.get;

2449:
2450: END IF;
2451: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Populate_Dispensing_Table');
2452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2453: x_error_msg := fnd_message.get;
2454:
2455: END Populate_Dispensing_Table;
2456:
2457: /*+========================================================================+

Line 2496: x_error_msg := fnd_message.get;

2492: gme_debug.put_line('When others exception in Delete_Dispensing_Record');
2493: END IF;
2494: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Delete_Dispensing_Record');
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2496: x_error_msg := fnd_message.get;
2497:
2498: END Delete_Dispensing_Record;
2499:
2500: /*+========================================================================+

Line 2547: x_error_msg := fnd_message.get;

2543: gme_debug.put_line('When others exception in Get_Dispensed_Lot_Count');
2544: END IF;
2545: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Get_Dispensed_Lot_Count');
2546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2547: x_error_msg := fnd_message.get;
2548:
2549: END Get_Dispensed_Lot_Count;
2550:
2551: /*+========================================================================+

Line 2762: x_error_msg := fnd_message.get;

2758: gme_debug.put_line('When others exception in Create Qty Tree');
2759: END IF;
2760: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Create_Qty_Tree');
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2762: x_error_msg := fnd_message.get;
2763:
2764: END Create_Qty_Tree;
2765:
2766: /*+========================================================================+

Line 2854: x_error_msg := fnd_message.get;

2850: gme_debug.put_line('When others exception in Query_Tree');
2851: END IF;
2852: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Tree');
2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2854: x_error_msg := fnd_message.get;
2855:
2856: END Query_Qty_Tree;
2857:
2858: /*+========================================================================+

Line 2974: x_error_msg := fnd_message.get;

2970: gme_debug.put_line('When others exception in Update Qty Tree');
2971: END IF;
2972: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Update_Qty_Tree');
2973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2974: x_error_msg := fnd_message.get;
2975:
2976: END Update_Qty_Tree;
2977:
2978: /*+========================================================================+

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

3083: -- cannot consume it.
3084:
3085: IF l_phantom_type <> 0 THEN
3086: IF l_phantom_line_id IS NULL THEN
3087: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_PHANTOM_NOT_EXPLOD');
3088: RAISE ITEM_NOT_VALID;
3089: END IF;
3090: END IF;
3091:

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

3098: ,x_batchstep_status => l_batchstep_status);
3099: IF l_is_item_associated_to_step AND
3100: l_batchstep_status <> 2 AND
3101: l_batchstep_status <> 3 THEN
3102: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_STEP_WIP_COMPLETE');
3103: RAISE ITEM_NOT_VALID;
3104: END IF;
3105: END IF;
3106:

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

3111: FETCH Get_pplot_count INTO l_pplot_count;
3112: CLOSE Get_pplot_count;
3113:
3114: IF l_pplot_count > 0 THEN
3115: FND_MESSAGE.SET_NAME('GME', 'GME_ISSUE_INDIV_PPLOT_EXIST');
3116: RAISE ITEM_NOT_VALID;
3117: END IF;
3118: END IF; */
3119:

Line 3123: x_error_msg := fnd_message.get;

3119:
3120: EXCEPTION
3121: WHEN ITEM_NOT_VALID THEN
3122: x_return_status := FND_API.G_RET_STS_ERROR;
3123: x_error_msg := fnd_message.get;
3124:
3125: WHEN OTHERS THEN
3126: IF g_debug <= gme_debug.g_log_unexpected THEN
3127: gme_debug.put_line('When others exception in Validate Item To Issue');

Line 3131: x_error_msg := fnd_message.get;

3127: gme_debug.put_line('When others exception in Validate Item To Issue');
3128: END IF;
3129: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Issue');
3130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3131: x_error_msg := fnd_message.get;
3132:
3133: END Validate_Item_To_Issue;
3134:
3135: /*+========================================================================+

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

3179:
3180: -- Cannot return an ingredient that was dispensed
3181:
3182: IF l_dispense_ind = 'Y' THEN
3183: FND_MESSAGE.SET_NAME('GME', 'GME_RETURN_DISPENSE_ING_ERROR');
3184: RAISE ITEM_NOT_VALID;
3185: END IF;
3186:
3187: EXCEPTION

Line 3190: x_error_msg := fnd_message.get;

3186:
3187: EXCEPTION
3188: WHEN ITEM_NOT_VALID THEN
3189: x_return_status := FND_API.G_RET_STS_ERROR;
3190: x_error_msg := fnd_message.get;
3191:
3192: WHEN OTHERS THEN
3193: IF g_debug <= gme_debug.g_log_unexpected THEN
3194: gme_debug.put_line('When others exception in Validate Item To Return');

Line 3198: x_error_msg := fnd_message.get;

3194: gme_debug.put_line('When others exception in Validate Item To Return');
3195: END IF;
3196: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Return');
3197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3198: x_error_msg := fnd_message.get;
3199:
3200: END Validate_Item_To_Return;
3201:
3202: /*+========================================================================+

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

3265: -- b) if not associated to a step, batch status must be Completed
3266:
3267: IF l_release_type = GME_COMMON_PVT.g_mtl_auto_release THEN
3268: IF l_batch_status <> 3 THEN
3269: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');
3270: RAISE ITEM_NOT_VALID;
3271: END IF;
3272: ELSIF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN
3273: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(

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

3275: ,x_batchstep_id => l_batchstep_id
3276: ,x_batchstep_status => l_batchstep_status);
3277: IF l_is_item_associated_to_step THEN
3278: IF l_batchstep_status <> 3 THEN
3279: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_STEP_COMPLETE');
3280: RAISE ITEM_NOT_VALID;
3281: END IF;
3282: ELSIF l_batch_status <> 3 THEN
3283: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');

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

3279: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_STEP_COMPLETE');
3280: RAISE ITEM_NOT_VALID;
3281: END IF;
3282: ELSIF l_batch_status <> 3 THEN
3283: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');
3284: RAISE ITEM_NOT_VALID;
3285: END IF;
3286: END IF;
3287:

Line 3293: x_error_msg := fnd_message.get;

3289:
3290: EXCEPTION
3291: WHEN ITEM_NOT_VALID THEN
3292: x_return_status := FND_API.G_RET_STS_ERROR;
3293: x_error_msg := fnd_message.get;
3294:
3295: WHEN OTHERS THEN
3296: IF g_debug <= gme_debug.g_log_unexpected THEN
3297: gme_debug.put_line('When others exception in Validate Prod To Yield');

Line 3301: x_error_msg := fnd_message.get;

3297: gme_debug.put_line('When others exception in Validate Prod To Yield');
3298: END IF;
3299: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Prod_To_Yield');
3300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3301: x_error_msg := fnd_message.get;
3302:
3303: END Validate_Prod_To_Yield;
3304:
3305: /*+========================================================================+

Line 3376: x_error_msg := fnd_message.get;

3372: gme_debug.put_line('When others exception in fetch Issue Transactions');
3373: END IF;
3374: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_issue_transactions');
3375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3376: x_error_msg := fnd_message.get;
3377:
3378: END Fetch_Issue_Transactions;
3379:
3380: /*+========================================================================+

Line 3455: x_error_msg := fnd_message.get;

3451: gme_debug.put_line('When others exception in fetch yield Transactions');
3452: END IF;
3453: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_yield_transactions');
3454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3455: x_error_msg := fnd_message.get;
3456:
3457: END Fetch_Yield_Transactions;
3458:
3459:

Line 3572: x_error_msg := fnd_message.get;

3568:
3569: EXCEPTION
3570: WHEN fnd_api.g_exc_error THEN
3571: x_return_status := fnd_api.g_ret_sts_error;
3572: x_error_msg := fnd_message.get;
3573:
3574: WHEN fnd_api.g_exc_unexpected_error THEN
3575: x_return_status := fnd_api.g_ret_sts_unexp_error;
3576:

Line 3580: x_error_msg := fnd_message.get;

3576:
3577: WHEN OTHERS THEN
3578: x_return_status := fnd_api.g_ret_sts_unexp_error;
3579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3580: x_error_msg := fnd_message.get;
3581: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3582: gme_debug.put_line ( g_pkg_name
3583: || '.'
3584: || l_api_name

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

3699: WHEN expected_error THEN
3700: x_return_status := FND_API.G_RET_STS_ERROR;
3701: WHEN step_alloc_error THEN
3702: ROLLBACK TO SAVEPOINT complete_step_mobile ;
3703: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3704: x_message_list := FND_MESSAGE.GET;
3705: WHEN validate_step_error THEN
3706: gme_common_pvt.count_and_get (x_count => x_message_count
3707: ,p_encoded => fnd_api.g_false

Line 3704: x_message_list := FND_MESSAGE.GET;

3700: x_return_status := FND_API.G_RET_STS_ERROR;
3701: WHEN step_alloc_error THEN
3702: ROLLBACK TO SAVEPOINT complete_step_mobile ;
3703: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3704: x_message_list := FND_MESSAGE.GET;
3705: WHEN validate_step_error THEN
3706: gme_common_pvt.count_and_get (x_count => x_message_count
3707: ,p_encoded => fnd_api.g_false
3708: ,x_data => x_message_list);

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

3706: gme_common_pvt.count_and_get (x_count => x_message_count
3707: ,p_encoded => fnd_api.g_false
3708: ,x_data => x_message_list);
3709: WHEN validate_step_status_error THEN
3710: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_CMPL_STEP');
3711: x_message_list := FND_MESSAGE.GET;
3712: WHEN OTHERS THEN
3713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3714: END complete_step;

Line 3711: x_message_list := FND_MESSAGE.GET;

3707: ,p_encoded => fnd_api.g_false
3708: ,x_data => x_message_list);
3709: WHEN validate_step_status_error THEN
3710: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_CMPL_STEP');
3711: x_message_list := FND_MESSAGE.GET;
3712: WHEN OTHERS THEN
3713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3714: END complete_step;
3715:

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

3885: WHEN expected_error THEN
3886: x_return_status := FND_API.G_RET_STS_ERROR;
3887: WHEN step_alloc_error THEN
3888: ROLLBACK TO SAVEPOINT release_step_mobile ;
3889: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3890: x_message_list := FND_MESSAGE.GET;
3891: WHEN validate_step_error THEN
3892: GME_COMMON_PVT.count_and_get (x_count => l_count
3893: ,p_encoded => fnd_api.g_false

Line 3890: x_message_list := FND_MESSAGE.GET;

3886: x_return_status := FND_API.G_RET_STS_ERROR;
3887: WHEN step_alloc_error THEN
3888: ROLLBACK TO SAVEPOINT release_step_mobile ;
3889: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3890: x_message_list := FND_MESSAGE.GET;
3891: WHEN validate_step_error THEN
3892: GME_COMMON_PVT.count_and_get (x_count => l_count
3893: ,p_encoded => fnd_api.g_false
3894: ,x_data => x_message_list);

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

3893: ,p_encoded => fnd_api.g_false
3894: ,x_data => x_message_list);
3895:
3896: WHEN validate_step_status_error THEN
3897: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_REL_STEP');
3898: x_message_list := FND_MESSAGE.GET;
3899: WHEN OTHERS THEN
3900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3898: x_message_list := FND_MESSAGE.GET;

3894: ,x_data => x_message_list);
3895:
3896: WHEN validate_step_status_error THEN
3897: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_REL_STEP');
3898: x_message_list := FND_MESSAGE.GET;
3899: WHEN OTHERS THEN
3900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3902: END release_step;

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

3987: END IF;
3988: EXCEPTION
3989: WHEN FUTURE_DATE_EX THEN
3990: x_return_status := FND_API.G_RET_STS_ERROR;
3991: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
3992: x_error_msg := FND_MESSAGE.GET;
3993: WHEN INVALID_STEP_COMPLT_DATE THEN
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');

Line 3992: x_error_msg := FND_MESSAGE.GET;

3988: EXCEPTION
3989: WHEN FUTURE_DATE_EX THEN
3990: x_return_status := FND_API.G_RET_STS_ERROR;
3991: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
3992: x_error_msg := FND_MESSAGE.GET;
3993: WHEN INVALID_STEP_COMPLT_DATE THEN
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');
3996: x_error_msg := FND_MESSAGE.GET;

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

3991: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
3992: x_error_msg := FND_MESSAGE.GET;
3993: WHEN INVALID_STEP_COMPLT_DATE THEN
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');
3996: x_error_msg := FND_MESSAGE.GET;
3997: WHEN OTHERS THEN
3998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3999: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3996: x_error_msg := FND_MESSAGE.GET;

3992: x_error_msg := FND_MESSAGE.GET;
3993: WHEN INVALID_STEP_COMPLT_DATE THEN
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');
3996: x_error_msg := FND_MESSAGE.GET;
3997: WHEN OTHERS THEN
3998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3999: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4000: x_error_msg := FND_MESSAGE.GET;

Line 4000: x_error_msg := FND_MESSAGE.GET;

3996: x_error_msg := FND_MESSAGE.GET;
3997: WHEN OTHERS THEN
3998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3999: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4000: x_error_msg := FND_MESSAGE.GET;
4001: END Validate_Step_Completion_Date;
4002:
4003: /*###############################################################
4004: # DESCRIPTION

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

4015: l_step_qty := TO_NUMBER(p_step_qty);
4016: EXCEPTION
4017: WHEN VALUE_ERROR THEN
4018: x_return_status := FND_API.G_RET_STS_ERROR;
4019: FND_MESSAGE.SET_NAME('GME', 'GME_VALUE_ERROR');
4020: x_error_msg := FND_MESSAGE.GET;
4021: WHEN OTHERS THEN
4022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4023: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 4020: x_error_msg := FND_MESSAGE.GET;

4016: EXCEPTION
4017: WHEN VALUE_ERROR THEN
4018: x_return_status := FND_API.G_RET_STS_ERROR;
4019: FND_MESSAGE.SET_NAME('GME', 'GME_VALUE_ERROR');
4020: x_error_msg := FND_MESSAGE.GET;
4021: WHEN OTHERS THEN
4022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4023: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4024: x_error_msg := FND_MESSAGE.GET;

Line 4024: x_error_msg := FND_MESSAGE.GET;

4020: x_error_msg := FND_MESSAGE.GET;
4021: WHEN OTHERS THEN
4022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4023: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4024: x_error_msg := FND_MESSAGE.GET;
4025: END Validate_Step_Qty;
4026:
4027: /*###############################################################
4028: # DESCRIPTION

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

4071: END IF;
4072: EXCEPTION
4073: WHEN FUTURE_DATE_EX THEN
4074: x_return_status := FND_API.G_RET_STS_ERROR;
4075: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
4076: x_error_msg := FND_MESSAGE.GET;
4077: WHEN INVALID_STEP_START_DATE THEN
4078: x_return_status := FND_API.G_RET_STS_ERROR;
4079: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');

Line 4076: x_error_msg := FND_MESSAGE.GET;

4072: EXCEPTION
4073: WHEN FUTURE_DATE_EX THEN
4074: x_return_status := FND_API.G_RET_STS_ERROR;
4075: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
4076: x_error_msg := FND_MESSAGE.GET;
4077: WHEN INVALID_STEP_START_DATE THEN
4078: x_return_status := FND_API.G_RET_STS_ERROR;
4079: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');
4080: x_error_msg := FND_MESSAGE.GET;

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

4075: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
4076: x_error_msg := FND_MESSAGE.GET;
4077: WHEN INVALID_STEP_START_DATE THEN
4078: x_return_status := FND_API.G_RET_STS_ERROR;
4079: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');
4080: x_error_msg := FND_MESSAGE.GET;
4081: WHEN OTHERS THEN
4082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4083: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 4080: x_error_msg := FND_MESSAGE.GET;

4076: x_error_msg := FND_MESSAGE.GET;
4077: WHEN INVALID_STEP_START_DATE THEN
4078: x_return_status := FND_API.G_RET_STS_ERROR;
4079: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');
4080: x_error_msg := FND_MESSAGE.GET;
4081: WHEN OTHERS THEN
4082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4083: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4084: x_error_msg := FND_MESSAGE.GET;

Line 4084: x_error_msg := FND_MESSAGE.GET;

4080: x_error_msg := FND_MESSAGE.GET;
4081: WHEN OTHERS THEN
4082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4083: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4084: x_error_msg := FND_MESSAGE.GET;
4085: END Validate_Step_Start_Date;
4086:
4087: PROCEDURE check_close_period(p_org_id IN NUMBER,
4088: p_trans_date IN DATE,

Line 4175: x_error_msg := fnd_message.get;

4171: gme_debug.put_line('When others exception in fetch_txn_date');
4172: END IF;
4173: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_txn_date');
4174: x_return_status := fnd_api.g_ret_sts_unexp_error;
4175: x_error_msg := fnd_message.get;
4176: END;
4177:
4178: --Bug#5867209 added restricted subinv code
4179: PROCEDURE Validate_Subinv_Master(p_organization_id IN NUMBER,

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

4228:
4229: EXCEPTION
4230: WHEN ERROR_INV_SUBINV THEN
4231: x_return_status := fnd_api.g_ret_sts_error;
4232: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_SUBINV');
4233: x_error_message := FND_MESSAGE.GET;
4234: END Validate_Subinv_Master;
4235:
4236: --Bug#5867209 added restricted locator code

Line 4233: x_error_message := FND_MESSAGE.GET;

4229: EXCEPTION
4230: WHEN ERROR_INV_SUBINV THEN
4231: x_return_status := fnd_api.g_ret_sts_error;
4232: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_SUBINV');
4233: x_error_message := FND_MESSAGE.GET;
4234: END Validate_Subinv_Master;
4235:
4236: --Bug#5867209 added restricted locator code
4237: PROCEDURE Validate_Locator_Master(p_organization_id IN NUMBER,

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

4285: END IF;
4286: EXCEPTION
4287: WHEN ERROR_INVALID_LOCATOR THEN
4288: x_return_status := fnd_api.g_ret_sts_error;
4289: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_LOC');
4290: x_error_message := FND_MESSAGE.GET;
4291: END Validate_Locator_Master;
4292: /* Bug#5663458 End*/
4293:

Line 4290: x_error_message := FND_MESSAGE.GET;

4286: EXCEPTION
4287: WHEN ERROR_INVALID_LOCATOR THEN
4288: x_return_status := fnd_api.g_ret_sts_error;
4289: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_LOC');
4290: x_error_message := FND_MESSAGE.GET;
4291: END Validate_Locator_Master;
4292: /* Bug#5663458 End*/
4293:
4294: --Bug#5867209 added the procedure

Line 4331: x_error_msg := fnd_message.get;

4327: gme_debug.put_line('When others exception in Fetch_subinv_locator');
4328: END IF;
4329: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Fetch_subinv_locator');
4330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4331: x_error_msg := fnd_message.get;
4332: END Fetch_subinv_locator;
4333:
4334: -- nsinghi bug#5209065 START. Added following Procs.
4335: PROCEDURE get_expiration_date (

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

4366: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4367: IF g_debug <= gme_debug.g_log_statement THEN
4368: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4369: END IF;
4370: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4371: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
4372: fnd_msg_pub.ADD;
4373: RAISE fnd_api.g_exc_unexpected_error;
4374: END IF;

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

4367: IF g_debug <= gme_debug.g_log_statement THEN
4368: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4369: END IF;
4370: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4371: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
4372: fnd_msg_pub.ADD;
4373: RAISE fnd_api.g_exc_unexpected_error;
4374: END IF;
4375: IF g_debug = 1 THEN