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 GME_MOBILE_TXN

Line 1: PACKAGE BODY GME_MOBILE_TXN AS

1: PACKAGE BODY GME_MOBILE_TXN AS
2: /* $Header: GMEMOTXB.pls 120.29 2008/04/15 19:13:03 adeshmuk ship $ */
3: /*===========================================================================+
4: | Copyright (c) 2005 Oracle Corporation, Redwood Shores, CA, USA |
5: | All rights reserved. |

Line 35: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MOBILE_TXN';

31: | |
32: +===========================================================================*/
33:
34: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
35: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MOBILE_TXN';
36:
37: /*+========================================================================+
38: | PROCEDURE NAME
39: | Get_Txn_Type

Line 134: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_pend_lots');

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

Line 317: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_material_txn');

313: WHEN OTHERS THEN
314: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 395: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_lot_txn');

391: WHEN OTHERS THEN
392: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 475: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Indiv_Lot_Txn');

471: WHEN OTHERS THEN
472: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 608: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Is_Material_Status_Applicable');

604: WHEN OTHERS THEN
605: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 664: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_txns');

660: WHEN OTHERS THEN
661: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 721: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_lot_txns');

717: WHEN OTHERS THEN
718: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 781: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_rev_txns');

777: WHEN OTHERS THEN
778: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 853: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_transactions');

849: WHEN OTHERS THEN
850: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 904: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_lot_transactions');

900: WHEN OTHERS THEN
901: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 976: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','process_transactions');

972: WHEN OTHERS THEN
973: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 1161: gme_debug.put_line ( 'GME_MOBILE_TXNS'

1157:
1158: EXCEPTION
1159: WHEN fnd_api.g_exc_error THEN
1160: IF g_debug <= gme_debug.g_log_unexpected THEN
1161: gme_debug.put_line ( 'GME_MOBILE_TXNS'
1162: || '.'
1163: || 'Generate_Lot_Number'
1164: || ':'
1165: || 'When others exception:'

Line 1173: gme_debug.put_line ( 'GME_MOBILE_TXNS'

1169: x_return_status := fnd_api.g_ret_sts_error;
1170:
1171: WHEN OTHERS THEN
1172: IF g_debug <= gme_debug.g_log_unexpected THEN
1173: gme_debug.put_line ( 'GME_MOBILE_TXNS'
1174: || '.'
1175: || 'Generate_Lot_Number'
1176: || ':'
1177: || 'When others exception:'

Line 1519: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Txn_Date');

1515: WHEN OTHERS THEN
1516: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 1616: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Batch_For_IB');

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

Line 1702: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_For_IB');

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

Line 1813: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Backflush_Material');

1809: WHEN OTHERS THEN
1810: IF g_debug <= gme_debug.g_log_unexpected THEN
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:

Line 1916: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Save_Resource_Usage');

1912: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 1992: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_pending_product_lots');

1988: WHEN OTHERS THEN
1989: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 2056: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_rev_pending_product_lots');

2052: WHEN OTHERS THEN
2053: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 2183: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_pending_product_lots');

2179: );
2180: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 2329: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','update_pending_product_lots');

2325: , p_data => x_error_msg
2326: );
2327: gme_debug.put_line('Error = '||x_error_msg);
2328: END IF;
2329: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','update_pending_product_lots');
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331:
2332: END Update_Product_Pending_Lot;
2333:

Line 2451: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Populate_Dispensing_Table');

2447: gme_debug.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,
2448: 255));
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;

Line 2494: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Delete_Dispensing_Record');

2490: WHEN OTHERS THEN
2491: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 2545: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Get_Dispensed_Lot_Count');

2541: WHEN OTHERS THEN
2542: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 2661: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Qty_Tree');

2657: WHEN OTHERS THEN
2658: IF g_debug <= gme_debug.g_log_unexpected THEN
2659: gme_debug.put_line('When others exception in Query_Qty_Tree');
2660: END IF;
2661: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Qty_Tree');
2662:
2663: END Query_Qty_Tree;
2664:
2665: /*+========================================================================+

Line 2760: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Create_Qty_Tree');

2756: WHEN OTHERS THEN
2757: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 2852: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Tree');

2848: WHEN OTHERS THEN
2849: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 2972: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Update_Qty_Tree');

2968: WHEN OTHERS THEN
2969: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 3129: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Issue');

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

Line 3196: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Return');

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

Line 3299: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Prod_To_Yield');

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

Line 3374: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_issue_transactions');

3370: WHEN OTHERS THEN
3371: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 3453: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_yield_transactions');

3449: WHEN OTHERS THEN
3450: IF g_debug <= gme_debug.g_log_unexpected THEN
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;

Line 4173: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_txn_date');

4169: WHEN OTHERS THEN
4170: IF g_debug <= gme_debug.g_log_unexpected THEN
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:

Line 4329: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Fetch_subinv_locator');

4325: WHEN OTHERS THEN
4326: IF g_debug <= gme_debug.g_log_unexpected THEN
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:

Line 4413: END GME_MOBILE_TXN;

4409: END IF;
4410: END get_exp_action_date;
4411: -- nsinghi bug#5209065 END.
4412:
4413: END GME_MOBILE_TXN;