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.36.12020000.3 2012/08/08 12:17:14 apmishra ship $ */
3: /*===========================================================================+
4: | Copyright (c) 2005 Oracle Corporation, Redwood Shores, CA, USA |
5: | All rights reserved. |

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

49: | after converting them to the correct format |
50: +===========================================================================*/
51:
52: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
53: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MOBILE_TXN';
54:
55: /*+========================================================================+
56: | PROCEDURE NAME
57: | Get_Txn_Type

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

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

Line 199: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_disp_items');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1257: gme_debug.put_line ( 'GME_MOBILE_TXNS'

1253:
1254: EXCEPTION
1255: WHEN fnd_api.g_exc_error THEN
1256: IF g_debug <= gme_debug.g_log_unexpected THEN
1257: gme_debug.put_line ( 'GME_MOBILE_TXNS'
1258: || '.'
1259: || 'Generate_Lot_Number'
1260: || ':'
1261: || 'When others exception:'

Line 1269: gme_debug.put_line ( 'GME_MOBILE_TXNS'

1265: x_return_status := fnd_api.g_ret_sts_error;
1266:
1267: WHEN OTHERS THEN
1268: IF g_debug <= gme_debug.g_log_unexpected THEN
1269: gme_debug.put_line ( 'GME_MOBILE_TXNS'
1270: || '.'
1271: || 'Generate_Lot_Number'
1272: || ':'
1273: || 'When others exception:'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2421: , p_data => x_error_msg
2422: );
2423: gme_debug.put_line('Error = '||x_error_msg);
2424: END IF;
2425: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','update_pending_product_lots');
2426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2427:
2428: END Update_Product_Pending_Lot;
2429:

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

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

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

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

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

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

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

2753: WHEN OTHERS THEN
2754: IF g_debug <= gme_debug.g_log_unexpected THEN
2755: gme_debug.put_line('When others exception in Query_Qty_Tree');
2756: END IF;
2757: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Qty_Tree');
2758:
2759: END Query_Qty_Tree;
2760:
2761: /*+========================================================================+

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4661: END GME_MOBILE_TXN;

4657: WHEN OTHERS THEN
4658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4659: END print_label;
4660:
4661: END GME_MOBILE_TXN;