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_DEBUG

Line 108: gme_debug.log_initialize ('RelieveRsrvPndLots');

104: l_count NUMBER;
105: no_rsrv_pndlot_id EXCEPTION;
106: BEGIN
107: IF (g_debug IS NOT NULL) THEN
108: gme_debug.log_initialize ('RelieveRsrvPndLots');
109: END IF;
110:
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112: x_error_msg := ' ';

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

Line 150: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');

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

Line 196: IF g_debug <= gme_debug.g_log_unexpected THEN

192:
193: END IF;
194: EXCEPTION
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;

Line 197: gme_debug.put_line('When others exception in relieve_resvns_disp_items');

193: END IF;
194: EXCEPTION
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;

Line 329: gme_debug.log_initialize ('MobileCreTxn');

325: -- Clearing the quantity cache
326: inv_quantity_tree_pub.clear_quantity_cache;
327:
328: IF (g_debug IS NOT NULL) THEN
329: gme_debug.log_initialize ('MobileCreTxn');
330: END IF;
331:
332: gme_common_pvt.g_user_ident := p_user_id;
333: gme_common_pvt.g_login_id := p_login_id;

Line 407: IF g_debug <= gme_debug.g_log_unexpected THEN

403: END IF;
404:
405: EXCEPTION
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;

Line 408: gme_debug.put_line('When others exception in Create MAterial Txn');

404:
405: EXCEPTION
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;

Line 449: gme_debug.log_initialize ('MobileCreLotTxn');

445: l_mmli_rec_out mtl_transaction_lots_interface%ROWTYPE;
446: BEGIN
447:
448: IF (g_debug IS NOT NULL) THEN
449: gme_debug.log_initialize ('MobileCreLotTxn');
450: END IF;
451:
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453: x_error_msg := ' ';

Line 483: IF g_debug <= gme_debug.g_log_unexpected THEN

479: END IF;
480:
481: EXCEPTION
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;

Line 484: gme_debug.put_line('When others exception in Create Lot Txn');

480:
481: EXCEPTION
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;

Line 527: gme_debug.log_initialize ('MobileValLotTxn');

523:
524: BEGIN
525:
526: IF (g_debug IS NOT NULL) THEN
527: gme_debug.log_initialize ('MobileValLotTxn');
528: END IF;
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530: x_error_msg := ' ';
531:

Line 563: IF g_debug <= gme_debug.g_log_unexpected THEN

559: END IF;
560:
561: EXCEPTION
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;

Line 564: gme_debug.put_line('When others exception in Validate Indiv Lot Txn');

560:
561: EXCEPTION
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;

Line 609: gme_debug.log_initialize ('MobileValMtlSts');

605:
606: BEGIN
607:
608: IF (g_debug IS NOT NULL) THEN
609: gme_debug.log_initialize ('MobileValMtlSts');
610: END IF;
611:
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613: x_error_msg := ' ';

Line 696: IF g_debug <= gme_debug.g_log_unexpected THEN

692: END IF;
693:
694: EXCEPTION
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;

Line 697: gme_debug.put_line('When others exception in Is_Material_Status_Applicable');

693:
694: EXCEPTION
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;

Line 739: gme_debug.log_initialize ('MobileFetchAgrTxns');

735: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type;
736: BEGIN
737:
738: IF (g_debug IS NOT NULL) THEN
739: gme_debug.log_initialize ('MobileFetchAgrTxns');
740: END IF;
741:
742:
743: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 752: IF g_debug <= gme_debug.g_log_unexpected THEN

748: CLOSE Get_Agg_Txn;
749:
750: EXCEPTION
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;

Line 753: gme_debug.put_line('When others exception in fetch aggrageted txns');

749:
750: EXCEPTION
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;

Line 786: gme_debug.log_initialize ('MobileFetchAgrLotTxns');

782: IS
783: BEGIN
784:
785: IF (g_debug IS NOT NULL) THEN
786: gme_debug.log_initialize ('MobileFetchAgrLotTxns');
787: END IF;
788:
789:
790: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 809: IF g_debug <= gme_debug.g_log_unexpected THEN

805: GROUP BY m.revision,l.lot_number;
806:
807: EXCEPTION
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;

Line 810: gme_debug.put_line('When others exception in fetch aggrageted lot txns');

806:
807: EXCEPTION
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;

Line 855: gme_debug.log_initialize ('MobileFetchAgrRevTxns');

851: GROUP BY revision;
852: BEGIN
853:
854: IF (g_debug IS NOT NULL) THEN
855: gme_debug.log_initialize ('MobileFetchAgrRevTxns');
856: END IF;
857:
858:
859: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 869: IF g_debug <= gme_debug.g_log_unexpected THEN

865:
866:
867: EXCEPTION
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;

Line 870: gme_debug.put_line('When others exception in fetch aggrageted lot txns');

866:
867: EXCEPTION
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;

Line 905: gme_debug.log_initialize ('MobileFetchMtl');

901: l_txn_type_id NUMBER;
902: BEGIN
903:
904: IF (g_debug IS NOT NULL) THEN
905: gme_debug.log_initialize ('MobileFetchMtl');
906: END IF;
907:
908: l_txn_type_id := Get_Txn_Type(p_txn_type_id);
909:

Line 941: IF g_debug <= gme_debug.g_log_unexpected THEN

937: AND l.inventory_location_id = m.locator_id(+);
938:
939: EXCEPTION
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;

Line 942: gme_debug.put_line('When others exception in fetch Mtl Transactions');

938:
939: EXCEPTION
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;

Line 974: gme_debug.log_initialize ('MobileFetchLotTxn');

970: IS
971: BEGIN
972:
973: IF (g_debug IS NOT NULL) THEN
974: gme_debug.log_initialize ('MobileFetchLotTxn');
975: END IF;
976:
977: x_return_status := FND_API.G_RET_STS_SUCCESS;
978: x_error_msg := ' ';

Line 992: IF g_debug <= gme_debug.g_log_unexpected THEN

988: lot_number = NVL(p_lot_number, lot_number);
989:
990: EXCEPTION
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;

Line 993: gme_debug.put_line('When others exception in fetch Mtl Lot Transactions');

989:
990: EXCEPTION
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;

Line 1028: gme_debug.log_initialize ('MobileProcessTxn');

1024:
1025: BEGIN
1026:
1027: IF (g_debug IS NOT NULL) THEN
1028: gme_debug.log_initialize ('MobileProcessTxn');
1029: END IF;
1030:
1031: gme_common_pvt.g_user_ident := p_user_id;
1032: gme_common_pvt.g_login_id := p_login_id;

Line 1069: IF g_debug <= gme_debug.g_log_unexpected THEN

1065: GME_COMMON_PVT.g_transaction_header_id := NULL;
1066:
1067: EXCEPTION
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;

Line 1070: gme_debug.put_line('When others exception in Process_Transactions');

1066:
1067: EXCEPTION
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;

Line 1212: gme_debug.log_initialize ('MobileGenLotNumber');

1208:
1209: BEGIN
1210:
1211: IF (g_debug IS NOT NULL) THEN
1212: gme_debug.log_initialize ('MobileGenLotNumber');
1213: END IF;
1214:
1215: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1216: x_error_msg := '';

Line 1247: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1243: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1244: RAISE fnd_api.g_exc_error;
1245: END IF;
1246:
1247: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1248: gme_debug.put_line ( 'lot_gen'
1249: || ':'
1250: || 'x_lot_number'
1251: || x_return_status);

Line 1248: gme_debug.put_line ( 'lot_gen'

1244: RAISE fnd_api.g_exc_error;
1245: END IF;
1246:
1247: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1248: gme_debug.put_line ( 'lot_gen'
1249: || ':'
1250: || 'x_lot_number'
1251: || x_return_status);
1252: END IF;

Line 1256: IF g_debug <= gme_debug.g_log_unexpected THEN

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

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

1264:
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: || ':'

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 1581: gme_debug.log_initialize ('MobileValTxnDate');

1577: DATE_ERROR EXCEPTION;
1578: BEGIN
1579:
1580: IF (g_debug IS NOT NULL) THEN
1581: gme_debug.log_initialize ('MobileValTxnDate');
1582: END IF;
1583:
1584: x_return_status := FND_API.G_RET_STS_SUCCESS;
1585: x_error_msg := ' ';

Line 1612: IF g_debug <= gme_debug.g_log_unexpected THEN

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

Line 1613: gme_debug.put_line('When others exception in Validate Txn Date');

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

Line 1667: gme_debug.log_initialize ('MobileValBatchForIB');

1663:
1664: BEGIN
1665:
1666: IF (g_debug IS NOT NULL) THEN
1667: gme_debug.log_initialize ('MobileValBatchForIB');
1668: END IF;
1669:
1670: x_return_status := FND_API.G_RET_STS_SUCCESS;
1671: x_error_msg := ' ';

Line 1709: IF g_debug <= gme_debug.g_log_unexpected 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');
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;

Line 1710: gme_debug.put_line('When others exception in Validate Batch For IB');

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

Line 1757: gme_debug.log_initialize ('MobileValItemForIB');

1753:
1754: BEGIN
1755:
1756: IF (g_debug IS NOT NULL) THEN
1757: gme_debug.log_initialize ('MobileValItemForIB');
1758: END IF;
1759:
1760: x_return_status := FND_API.G_RET_STS_SUCCESS;
1761: x_error_msg := ' ';

Line 1795: IF g_debug <= gme_debug.g_log_unexpected 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');
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;

Line 1796: gme_debug.put_line('When others exception in Validate Item For IB');

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

Line 1845: gme_debug.log_initialize ('MobileBackflushMtl');

1841:
1842: BEGIN
1843:
1844: IF (g_debug IS NOT NULL) THEN
1845: gme_debug.log_initialize ('MobileBackflushMtl');
1846: gme_debug.put_line('BatchId id = '||p_batch_id);
1847: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1848: gme_debug.put_line('Backflush Qty = '||p_qty);
1849: gme_debug.put_line('Qty Type = '||p_qty_type);

Line 1846: gme_debug.put_line('BatchId id = '||p_batch_id);

1842: BEGIN
1843:
1844: IF (g_debug IS NOT NULL) THEN
1845: gme_debug.log_initialize ('MobileBackflushMtl');
1846: gme_debug.put_line('BatchId id = '||p_batch_id);
1847: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1848: gme_debug.put_line('Backflush Qty = '||p_qty);
1849: gme_debug.put_line('Qty Type = '||p_qty_type);
1850: gme_debug.put_line('Org Code = '||p_org_code);

Line 1847: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);

1843:
1844: IF (g_debug IS NOT NULL) THEN
1845: gme_debug.log_initialize ('MobileBackflushMtl');
1846: gme_debug.put_line('BatchId id = '||p_batch_id);
1847: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1848: gme_debug.put_line('Backflush Qty = '||p_qty);
1849: gme_debug.put_line('Qty Type = '||p_qty_type);
1850: gme_debug.put_line('Org Code = '||p_org_code);
1851: END IF;

Line 1848: gme_debug.put_line('Backflush Qty = '||p_qty);

1844: IF (g_debug IS NOT NULL) THEN
1845: gme_debug.log_initialize ('MobileBackflushMtl');
1846: gme_debug.put_line('BatchId id = '||p_batch_id);
1847: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1848: gme_debug.put_line('Backflush Qty = '||p_qty);
1849: gme_debug.put_line('Qty Type = '||p_qty_type);
1850: gme_debug.put_line('Org Code = '||p_org_code);
1851: END IF;
1852:

Line 1849: gme_debug.put_line('Qty Type = '||p_qty_type);

1845: gme_debug.log_initialize ('MobileBackflushMtl');
1846: gme_debug.put_line('BatchId id = '||p_batch_id);
1847: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1848: gme_debug.put_line('Backflush Qty = '||p_qty);
1849: gme_debug.put_line('Qty Type = '||p_qty_type);
1850: gme_debug.put_line('Org Code = '||p_org_code);
1851: END IF;
1852:
1853: fnd_profile.put('USER_ID',to_char(p_user_id));

Line 1850: gme_debug.put_line('Org Code = '||p_org_code);

1846: gme_debug.put_line('BatchId id = '||p_batch_id);
1847: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1848: gme_debug.put_line('Backflush Qty = '||p_qty);
1849: gme_debug.put_line('Qty Type = '||p_qty_type);
1850: gme_debug.put_line('Org Code = '||p_org_code);
1851: END IF;
1852:
1853: fnd_profile.put('USER_ID',to_char(p_user_id));
1854: fnd_profile.put('LOGIN_ID',to_char(p_login_id));

Line 1881: gme_debug.put_line('Return Status = '||x_return_status);

1877: ,p_adjust_cmplt => fnd_api.g_false --- Completed batches not supported
1878: ,x_exception_material_tbl => l_exception_material_tab);
1879:
1880: IF (g_debug IS NOT NULL) THEN
1881: gme_debug.put_line('Return Status = '||x_return_status);
1882: gme_debug.put_line('Error Msg = '||l_msg_list);
1883: END IF;
1884:
1885: IF x_return_status = 'X' THEN

Line 1882: gme_debug.put_line('Error Msg = '||l_msg_list);

1878: ,x_exception_material_tbl => l_exception_material_tab);
1879:
1880: IF (g_debug IS NOT NULL) THEN
1881: gme_debug.put_line('Return Status = '||x_return_status);
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');

Line 1906: IF g_debug <= gme_debug.g_log_unexpected THEN

1902: x_return_status := FND_API.G_RET_STS_ERROR;
1903: ROLLBACK;
1904:
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;

Line 1907: gme_debug.put_line('When others exception in Backflush Material');

1903: ROLLBACK;
1904:
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;

Line 1952: gme_debug.log_initialize ('MobileSaveRsrcUsage');

1948: l_output_rec GME_BATCH_STEP_RESOURCES%ROWTYPE;
1949: BEGIN
1950:
1951: IF (g_debug IS NOT NULL) THEN
1952: gme_debug.log_initialize ('MobileSaveRsrcUsage');
1953: END IF;
1954:
1955: fnd_profile.put('USER_ID',to_char(p_uid));
1956: gme_common_pvt.g_user_ident := p_uid;

Line 2008: IF g_debug <= gme_debug.g_log_unexpected THEN

2004: END IF;
2005:
2006: EXCEPTION
2007: WHEN OTHERS THEN
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');

Line 2009: gme_debug.put_line('When others exception in Save Resource Usage');

2005:
2006: EXCEPTION
2007: WHEN OTHERS THEN
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;

Line 2044: gme_debug.log_initialize ('MobileFetchPendingLot');

2040: l_date_format VARCHAR2(100);
2041: BEGIN
2042:
2043: IF (g_debug IS NOT NULL) THEN
2044: gme_debug.log_initialize ('MobileFetchPendingLot');
2045: END IF;
2046:
2047: x_return_status := FND_API.G_RET_STS_SUCCESS;
2048: x_error_msg := ' ';

Line 2085: IF g_debug <= gme_debug.g_log_unexpected THEN

2081: l.reason_id = r.reason_id(+);
2082:
2083: EXCEPTION
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;

Line 2086: gme_debug.put_line('When others exception in fetch Pending Lots');

2082:
2083: EXCEPTION
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;

Line 2107: gme_debug.log_initialize ('MobileFetchRevPendingLot');

2103: l_date_format VARCHAR2(100);
2104: BEGIN
2105:
2106: IF (g_debug IS NOT NULL) THEN
2107: gme_debug.log_initialize ('MobileFetchRevPendingLot');
2108: END IF;
2109:
2110: x_return_status := FND_API.G_RET_STS_SUCCESS;
2111: x_error_msg := ' ';

Line 2149: IF g_debug <= gme_debug.g_log_unexpected THEN

2145: l.reason_id = r.reason_id(+);
2146:
2147: EXCEPTION
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;

Line 2150: gme_debug.put_line('When others exception in fetch Rev Pending Lots');

2146:
2147: EXCEPTION
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;

Line 2214: gme_debug.log_initialize ('MobileCrePendingLot');

2210: l_create_lot := fnd_api.g_false;
2211: END IF;
2212:
2213: IF (g_debug IS NOT NULL) THEN
2214: gme_debug.log_initialize ('MobileCrePendingLot');
2215: gme_debug.put_line('New lot = ' || p_create_lot);
2216: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2217: gme_debug.put_line('Sequence = ' || p_sequence);
2218: gme_debug.put_line('Revision = ' || p_revision);

Line 2215: gme_debug.put_line('New lot = ' || p_create_lot);

2211: END IF;
2212:
2213: IF (g_debug IS NOT NULL) THEN
2214: gme_debug.log_initialize ('MobileCrePendingLot');
2215: gme_debug.put_line('New lot = ' || p_create_lot);
2216: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2217: gme_debug.put_line('Sequence = ' || p_sequence);
2218: gme_debug.put_line('Revision = ' || p_revision);
2219: gme_debug.put_line('Lot number = ' || p_lot_number);

Line 2216: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);

2212:
2213: IF (g_debug IS NOT NULL) THEN
2214: gme_debug.log_initialize ('MobileCrePendingLot');
2215: gme_debug.put_line('New lot = ' || p_create_lot);
2216: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2217: gme_debug.put_line('Sequence = ' || p_sequence);
2218: gme_debug.put_line('Revision = ' || p_revision);
2219: gme_debug.put_line('Lot number = ' || p_lot_number);
2220: gme_debug.put_line('Quantity = ' || p_qty);

Line 2217: gme_debug.put_line('Sequence = ' || p_sequence);

2213: IF (g_debug IS NOT NULL) THEN
2214: gme_debug.log_initialize ('MobileCrePendingLot');
2215: gme_debug.put_line('New lot = ' || p_create_lot);
2216: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2217: gme_debug.put_line('Sequence = ' || p_sequence);
2218: gme_debug.put_line('Revision = ' || p_revision);
2219: gme_debug.put_line('Lot number = ' || p_lot_number);
2220: gme_debug.put_line('Quantity = ' || p_qty);
2221: gme_debug.put_line('Sec quantity = ' || p_sec_qty);

Line 2218: gme_debug.put_line('Revision = ' || p_revision);

2214: gme_debug.log_initialize ('MobileCrePendingLot');
2215: gme_debug.put_line('New lot = ' || p_create_lot);
2216: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2217: gme_debug.put_line('Sequence = ' || p_sequence);
2218: gme_debug.put_line('Revision = ' || p_revision);
2219: gme_debug.put_line('Lot number = ' || p_lot_number);
2220: gme_debug.put_line('Quantity = ' || p_qty);
2221: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2222: gme_debug.put_line('Reason_id = ' || p_reason_id);

Line 2219: gme_debug.put_line('Lot number = ' || p_lot_number);

2215: gme_debug.put_line('New lot = ' || p_create_lot);
2216: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2217: gme_debug.put_line('Sequence = ' || p_sequence);
2218: gme_debug.put_line('Revision = ' || p_revision);
2219: gme_debug.put_line('Lot number = ' || p_lot_number);
2220: gme_debug.put_line('Quantity = ' || p_qty);
2221: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2222: gme_debug.put_line('Reason_id = ' || p_reason_id);
2223: gme_debug.put_line('User Id = ' || p_user_id);

Line 2220: gme_debug.put_line('Quantity = ' || p_qty);

2216: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2217: gme_debug.put_line('Sequence = ' || p_sequence);
2218: gme_debug.put_line('Revision = ' || p_revision);
2219: gme_debug.put_line('Lot number = ' || p_lot_number);
2220: gme_debug.put_line('Quantity = ' || p_qty);
2221: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2222: gme_debug.put_line('Reason_id = ' || p_reason_id);
2223: gme_debug.put_line('User Id = ' || p_user_id);
2224: gme_debug.put_line('Login Id = ' || p_login_id);

Line 2221: gme_debug.put_line('Sec quantity = ' || p_sec_qty);

2217: gme_debug.put_line('Sequence = ' || p_sequence);
2218: gme_debug.put_line('Revision = ' || p_revision);
2219: gme_debug.put_line('Lot number = ' || p_lot_number);
2220: gme_debug.put_line('Quantity = ' || p_qty);
2221: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2222: gme_debug.put_line('Reason_id = ' || p_reason_id);
2223: gme_debug.put_line('User Id = ' || p_user_id);
2224: gme_debug.put_line('Login Id = ' || p_login_id);
2225: END IF;

Line 2222: gme_debug.put_line('Reason_id = ' || p_reason_id);

2218: gme_debug.put_line('Revision = ' || p_revision);
2219: gme_debug.put_line('Lot number = ' || p_lot_number);
2220: gme_debug.put_line('Quantity = ' || p_qty);
2221: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2222: gme_debug.put_line('Reason_id = ' || p_reason_id);
2223: gme_debug.put_line('User Id = ' || p_user_id);
2224: gme_debug.put_line('Login Id = ' || p_login_id);
2225: END IF;
2226:

Line 2223: gme_debug.put_line('User Id = ' || p_user_id);

2219: gme_debug.put_line('Lot number = ' || p_lot_number);
2220: gme_debug.put_line('Quantity = ' || p_qty);
2221: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2222: gme_debug.put_line('Reason_id = ' || p_reason_id);
2223: gme_debug.put_line('User Id = ' || p_user_id);
2224: gme_debug.put_line('Login Id = ' || p_login_id);
2225: END IF;
2226:
2227: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2224: gme_debug.put_line('Login Id = ' || p_login_id);

2220: gme_debug.put_line('Quantity = ' || p_qty);
2221: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2222: gme_debug.put_line('Reason_id = ' || p_reason_id);
2223: gme_debug.put_line('User Id = ' || p_user_id);
2224: gme_debug.put_line('Login Id = ' || p_login_id);
2225: END IF;
2226:
2227: x_return_status := FND_API.G_RET_STS_SUCCESS;
2228: x_error_msg := ' ';

Line 2276: IF g_debug <= gme_debug.g_log_unexpected THEN

2272: FND_MSG_PUB.count_and_get
2273: ( p_count => l_message_count
2274: , p_data => x_error_msg
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;

Line 2277: gme_debug.put_line('When others exception in Create Pending Lots');

2273: ( p_count => l_message_count
2274: , p_data => x_error_msg
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;

Line 2336: gme_debug.log_initialize ('MobileUpdatePendingLot');

2332:
2333: BEGIN
2334:
2335: IF (g_debug IS NOT NULL) THEN
2336: gme_debug.log_initialize ('MobileUpdatePendingLot');
2337: END IF;
2338:
2339: x_return_status := FND_API.G_RET_STS_SUCCESS;
2340: x_error_msg := ' ';

Line 2381: gme_debug.put_line('Update Pending Lot: ');

2377: END IF;
2378:
2379: l_pending_product_lots_rec.last_update_date := to_date(p_last_update_date, 'MM/DD/YYYY HH24:MI:SS');
2380:
2381: gme_debug.put_line('Update Pending Lot: ');
2382: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2383: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2384: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2385: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);

Line 2382: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));

2378:
2379: l_pending_product_lots_rec.last_update_date := to_date(p_last_update_date, 'MM/DD/YYYY HH24:MI:SS');
2380:
2381: gme_debug.put_line('Update Pending Lot: ');
2382: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2383: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2384: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2385: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2386: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);

Line 2383: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);

2379: l_pending_product_lots_rec.last_update_date := to_date(p_last_update_date, 'MM/DD/YYYY HH24:MI:SS');
2380:
2381: gme_debug.put_line('Update Pending Lot: ');
2382: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2383: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2384: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2385: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2386: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2387: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);

Line 2384: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);

2380:
2381: gme_debug.put_line('Update Pending Lot: ');
2382: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2383: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2384: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2385: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2386: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2387: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2388: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);

Line 2385: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);

2381: gme_debug.put_line('Update Pending Lot: ');
2382: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2383: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2384: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2385: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2386: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2387: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2388: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);
2389: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);

Line 2386: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);

2382: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2383: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2384: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2385: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2386: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2387: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2388: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);
2389: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);
2390:

Line 2387: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);

2383: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2384: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2385: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2386: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2387: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2388: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);
2389: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);
2390:
2391: GME_API_PUB.update_pending_product_lot

Line 2388: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);

2384: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2385: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2386: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2387: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2388: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);
2389: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);
2390:
2391: GME_API_PUB.update_pending_product_lot
2392: (p_api_version => 2.0

Line 2389: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);

2385: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2386: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2387: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2388: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);
2389: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);
2390:
2391: GME_API_PUB.update_pending_product_lot
2392: (p_api_version => 2.0
2393: ,p_validation_level => gme_common_pvt.g_max_errors

Line 2417: IF g_debug <= gme_debug.g_log_unexpected THEN

2413: END IF;
2414:
2415: EXCEPTION
2416: WHEN OTHERS THEN
2417: IF g_debug <= gme_debug.g_log_unexpected THEN
2418: gme_debug.put_line('When others exception in Update Pending Lots');
2419: FND_MSG_PUB.count_and_get
2420: ( p_count => l_message_count
2421: , p_data => x_error_msg

Line 2418: gme_debug.put_line('When others exception in Update Pending Lots');

2414:
2415: EXCEPTION
2416: WHEN OTHERS THEN
2417: IF g_debug <= gme_debug.g_log_unexpected THEN
2418: gme_debug.put_line('When others exception in Update Pending Lots');
2419: FND_MSG_PUB.count_and_get
2420: ( p_count => l_message_count
2421: , p_data => x_error_msg
2422: );

Line 2423: gme_debug.put_line('Error = '||x_error_msg);

2419: FND_MSG_PUB.count_and_get
2420: ( p_count => l_message_count
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:

Line 2464: gme_debug.log_initialize ('MobilePopulateDispTbl');

2460:
2461: BEGIN
2462:
2463: IF (g_debug IS NOT NULL) THEN
2464: gme_debug.log_initialize ('MobilePopulateDispTbl');
2465: END IF;
2466:
2467: x_return_status := FND_API.G_RET_STS_SUCCESS;
2468: x_error_msg := ' ';

Line 2492: gme_debug.put_line('Inserting Dispensed record ');

2488: LOOP
2489:
2490: IF l_rsrv_tab(l_index).external_source_line_id IS NOT NULL THEN
2491:
2492: gme_debug.put_line('Inserting Dispensed record ');
2493: gme_debug.put_line('ID = ' ||
2494: l_rsrv_tab(l_index).external_source_line_id);
2495: gme_debug.put_line('Sub = ' ||
2496: l_rsrv_tab(l_index).subinventory_code);

Line 2493: gme_debug.put_line('ID = ' ||

2489:
2490: IF l_rsrv_tab(l_index).external_source_line_id IS NOT NULL THEN
2491:
2492: gme_debug.put_line('Inserting Dispensed record ');
2493: gme_debug.put_line('ID = ' ||
2494: l_rsrv_tab(l_index).external_source_line_id);
2495: gme_debug.put_line('Sub = ' ||
2496: l_rsrv_tab(l_index).subinventory_code);
2497: gme_debug.put_line('Locator Id = ' ||

Line 2495: gme_debug.put_line('Sub = ' ||

2491:
2492: gme_debug.put_line('Inserting Dispensed record ');
2493: gme_debug.put_line('ID = ' ||
2494: l_rsrv_tab(l_index).external_source_line_id);
2495: gme_debug.put_line('Sub = ' ||
2496: l_rsrv_tab(l_index).subinventory_code);
2497: gme_debug.put_line('Locator Id = ' ||
2498: l_rsrv_tab(l_index).locator_id);
2499: gme_debug.put_line('UOM = ' ||

Line 2497: gme_debug.put_line('Locator Id = ' ||

2493: gme_debug.put_line('ID = ' ||
2494: l_rsrv_tab(l_index).external_source_line_id);
2495: gme_debug.put_line('Sub = ' ||
2496: l_rsrv_tab(l_index).subinventory_code);
2497: gme_debug.put_line('Locator Id = ' ||
2498: l_rsrv_tab(l_index).locator_id);
2499: gme_debug.put_line('UOM = ' ||
2500: l_rsrv_tab(l_index).reservation_uom_code);
2501: gme_debug.put_line('QTY = ' ||

Line 2499: gme_debug.put_line('UOM = ' ||

2495: gme_debug.put_line('Sub = ' ||
2496: l_rsrv_tab(l_index).subinventory_code);
2497: gme_debug.put_line('Locator Id = ' ||
2498: l_rsrv_tab(l_index).locator_id);
2499: gme_debug.put_line('UOM = ' ||
2500: l_rsrv_tab(l_index).reservation_uom_code);
2501: gme_debug.put_line('QTY = ' ||
2502: l_rsrv_tab(l_index).reservation_quantity);
2503: gme_debug.put_line('Sec QTY = ' ||

Line 2501: gme_debug.put_line('QTY = ' ||

2497: gme_debug.put_line('Locator Id = ' ||
2498: l_rsrv_tab(l_index).locator_id);
2499: gme_debug.put_line('UOM = ' ||
2500: l_rsrv_tab(l_index).reservation_uom_code);
2501: gme_debug.put_line('QTY = ' ||
2502: l_rsrv_tab(l_index).reservation_quantity);
2503: gme_debug.put_line('Sec QTY = ' ||
2504: l_rsrv_tab(l_index).secondary_reservation_quantity);
2505: gme_debug.put_line('Lot = ' ||

Line 2503: gme_debug.put_line('Sec QTY = ' ||

2499: gme_debug.put_line('UOM = ' ||
2500: l_rsrv_tab(l_index).reservation_uom_code);
2501: gme_debug.put_line('QTY = ' ||
2502: l_rsrv_tab(l_index).reservation_quantity);
2503: gme_debug.put_line('Sec QTY = ' ||
2504: l_rsrv_tab(l_index).secondary_reservation_quantity);
2505: gme_debug.put_line('Lot = ' ||
2506: l_rsrv_tab(l_index).lot_number);
2507: gme_debug.put_line('Revision = ' ||

Line 2505: gme_debug.put_line('Lot = ' ||

2501: gme_debug.put_line('QTY = ' ||
2502: l_rsrv_tab(l_index).reservation_quantity);
2503: gme_debug.put_line('Sec QTY = ' ||
2504: l_rsrv_tab(l_index).secondary_reservation_quantity);
2505: gme_debug.put_line('Lot = ' ||
2506: l_rsrv_tab(l_index).lot_number);
2507: gme_debug.put_line('Revision = ' ||
2508: l_rsrv_tab(l_index).revision);
2509:

Line 2507: gme_debug.put_line('Revision = ' ||

2503: gme_debug.put_line('Sec QTY = ' ||
2504: l_rsrv_tab(l_index).secondary_reservation_quantity);
2505: gme_debug.put_line('Lot = ' ||
2506: l_rsrv_tab(l_index).lot_number);
2507: gme_debug.put_line('Revision = ' ||
2508: l_rsrv_tab(l_index).revision);
2509:
2510: INSERT INTO GME_MATERIAL_DISPENSING_GTMP
2511: (

Line 2541: IF g_debug <= gme_debug.g_log_unexpected THEN

2537: x_dispensed_count := l_dispensed;
2538:
2539: EXCEPTION
2540: WHEN OTHERS THEN
2541: IF g_debug <= gme_debug.g_log_unexpected THEN
2542: gme_debug.put_line('When others exception in Populate_Dispensing_Table');
2543: gme_debug.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,
2544: 255));
2545:

Line 2542: gme_debug.put_line('When others exception in Populate_Dispensing_Table');

2538:
2539: EXCEPTION
2540: WHEN OTHERS THEN
2541: IF g_debug <= gme_debug.g_log_unexpected THEN
2542: gme_debug.put_line('When others exception in Populate_Dispensing_Table');
2543: gme_debug.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,
2544: 255));
2545:
2546: END IF;

Line 2543: gme_debug.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,

2539: EXCEPTION
2540: WHEN OTHERS THEN
2541: IF g_debug <= gme_debug.g_log_unexpected THEN
2542: gme_debug.put_line('When others exception in 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');

Line 2576: gme_debug.log_initialize ('MobileDelDispRec');

2572:
2573: BEGIN
2574:
2575: IF (g_debug IS NOT NULL) THEN
2576: gme_debug.log_initialize ('MobileDelDispRec');
2577: END IF;
2578:
2579: x_return_status := FND_API.G_RET_STS_SUCCESS;
2580: x_error_msg := ' ';

Line 2587: IF g_debug <= gme_debug.g_log_unexpected THEN

2583: WHERE dispense_id = p_dispense_id;
2584:
2585: EXCEPTION
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;

Line 2588: gme_debug.put_line('When others exception in Delete_Dispensing_Record');

2584:
2585: EXCEPTION
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;

Line 2626: gme_debug.log_initialize ('MobileCountDispLot');

2622: NVL(locator_id, -1) = NVL(p_locator_id, -1);
2623: BEGIN
2624:
2625: IF (g_debug IS NOT NULL) THEN
2626: gme_debug.log_initialize ('MobileCountDispLot');
2627: END IF;
2628:
2629: x_return_status := FND_API.G_RET_STS_SUCCESS;
2630: x_error_msg := ' ';

Line 2638: IF g_debug <= gme_debug.g_log_unexpected THEN

2634: CLOSE lot_count;
2635:
2636: EXCEPTION
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;

Line 2639: gme_debug.put_line('When others exception in Get_Dispensed_Lot_Count');

2635:
2636: EXCEPTION
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;

Line 2701: gme_debug.log_initialize ('MobileQueryQtyTree');

2697: x_return_status := FND_API.G_RET_STS_SUCCESS;
2698: x_error_msg := ' ';
2699:
2700: IF (g_debug IS NOT NULL) THEN
2701: gme_debug.log_initialize ('MobileQueryQtyTree');
2702: END IF;
2703:
2704: -- Clearing the quantity cache
2705: inv_quantity_tree_pub.clear_quantity_cache;

Line 2754: IF g_debug <= gme_debug.g_log_unexpected THEN

2750:
2751:
2752: EXCEPTION
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:

Line 2755: gme_debug.put_line('When others exception in Query_Qty_Tree');

2751:
2752: EXCEPTION
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;

Line 2798: gme_debug.log_initialize ('MobileCreQtyTree');

2794: BEGIN
2795:
2796:
2797: IF (g_debug IS NOT NULL) THEN
2798: gme_debug.log_initialize ('MobileCreQtyTree');
2799: END IF;
2800:
2801: x_return_status := FND_API.G_RET_STS_SUCCESS;
2802: x_error_msg := ' ';

Line 2848: IF g_debug <= gme_debug.g_log_unexpected THEN

2844: END IF;
2845:
2846: EXCEPTION
2847: WHEN CREATE_TREE_ERROR THEN
2848: IF g_debug <= gme_debug.g_log_unexpected THEN
2849: gme_debug.put_line('Create Qty Tree exception');
2850: END IF;
2851:
2852: WHEN OTHERS THEN

Line 2849: gme_debug.put_line('Create Qty Tree exception');

2845:
2846: EXCEPTION
2847: WHEN CREATE_TREE_ERROR THEN
2848: IF g_debug <= gme_debug.g_log_unexpected THEN
2849: gme_debug.put_line('Create Qty Tree exception');
2850: END IF;
2851:
2852: WHEN OTHERS THEN
2853: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 2853: IF g_debug <= gme_debug.g_log_unexpected THEN

2849: gme_debug.put_line('Create Qty Tree exception');
2850: END IF;
2851:
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;

Line 2854: gme_debug.put_line('When others exception in Create Qty Tree');

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

Line 2902: gme_debug.log_initialize ('MobileQtyTree');

2898:
2899: BEGIN
2900:
2901: IF (g_debug IS NOT NULL) THEN
2902: gme_debug.log_initialize ('MobileQtyTree');
2903: END IF;
2904:
2905: x_return_status := FND_API.G_RET_STS_SUCCESS;
2906: x_error_msg := ' ';

Line 2940: IF g_debug <= gme_debug.g_log_unexpected THEN

2936: END IF;
2937:
2938: EXCEPTION
2939: WHEN QUERY_TREE_ERROR THEN
2940: IF g_debug <= gme_debug.g_log_unexpected THEN
2941: gme_debug.put_line('Query Qty Tree exception');
2942: END IF;
2943:
2944: WHEN OTHERS THEN

Line 2941: gme_debug.put_line('Query Qty Tree exception');

2937:
2938: EXCEPTION
2939: WHEN QUERY_TREE_ERROR THEN
2940: IF g_debug <= gme_debug.g_log_unexpected THEN
2941: gme_debug.put_line('Query Qty Tree exception');
2942: END IF;
2943:
2944: WHEN OTHERS THEN
2945: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 2945: IF g_debug <= gme_debug.g_log_unexpected THEN

2941: gme_debug.put_line('Query Qty Tree exception');
2942: END IF;
2943:
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;

Line 2946: gme_debug.put_line('When others exception in Query_Tree');

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

Line 2999: gme_debug.log_initialize ('MobileUpdateQtyTree');

2995: BEGIN
2996:
2997:
2998: IF (g_debug IS NOT NULL) THEN
2999: gme_debug.log_initialize ('MobileUpdateQtyTree');
3000: END IF;
3001:
3002: x_return_status := FND_API.G_RET_STS_SUCCESS;
3003: x_error_msg := ' ';

Line 3013: gme_debug.put_line('Tree id = '||p_tree_id);

3009: END IF;
3010:
3011: IF (p_primary_qty <> 0) THEN
3012:
3013: gme_debug.put_line('Tree id = '||p_tree_id);
3014: gme_debug.put_line('Qty = '||p_primary_qty);
3015: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
3016: gme_debug.put_line('lot = '||p_lot_number);
3017: gme_debug.put_line('Sub = '||p_subinventory_code);

Line 3014: gme_debug.put_line('Qty = '||p_primary_qty);

3010:
3011: IF (p_primary_qty <> 0) THEN
3012:
3013: gme_debug.put_line('Tree id = '||p_tree_id);
3014: gme_debug.put_line('Qty = '||p_primary_qty);
3015: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
3016: gme_debug.put_line('lot = '||p_lot_number);
3017: gme_debug.put_line('Sub = '||p_subinventory_code);
3018: gme_debug.put_line('Locator id = '||p_locator_id);

Line 3015: gme_debug.put_line('Sec Qty = '||p_secondary_qty);

3011: IF (p_primary_qty <> 0) THEN
3012:
3013: gme_debug.put_line('Tree id = '||p_tree_id);
3014: gme_debug.put_line('Qty = '||p_primary_qty);
3015: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
3016: gme_debug.put_line('lot = '||p_lot_number);
3017: gme_debug.put_line('Sub = '||p_subinventory_code);
3018: gme_debug.put_line('Locator id = '||p_locator_id);
3019: gme_debug.put_line('revision = '||p_revision);

Line 3016: gme_debug.put_line('lot = '||p_lot_number);

3012:
3013: gme_debug.put_line('Tree id = '||p_tree_id);
3014: gme_debug.put_line('Qty = '||p_primary_qty);
3015: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
3016: gme_debug.put_line('lot = '||p_lot_number);
3017: gme_debug.put_line('Sub = '||p_subinventory_code);
3018: gme_debug.put_line('Locator id = '||p_locator_id);
3019: gme_debug.put_line('revision = '||p_revision);
3020:

Line 3017: gme_debug.put_line('Sub = '||p_subinventory_code);

3013: gme_debug.put_line('Tree id = '||p_tree_id);
3014: gme_debug.put_line('Qty = '||p_primary_qty);
3015: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
3016: gme_debug.put_line('lot = '||p_lot_number);
3017: gme_debug.put_line('Sub = '||p_subinventory_code);
3018: gme_debug.put_line('Locator id = '||p_locator_id);
3019: gme_debug.put_line('revision = '||p_revision);
3020:
3021: INV_Quantity_Tree_Grp.Update_Quantities(

Line 3018: gme_debug.put_line('Locator id = '||p_locator_id);

3014: gme_debug.put_line('Qty = '||p_primary_qty);
3015: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
3016: gme_debug.put_line('lot = '||p_lot_number);
3017: gme_debug.put_line('Sub = '||p_subinventory_code);
3018: gme_debug.put_line('Locator id = '||p_locator_id);
3019: gme_debug.put_line('revision = '||p_revision);
3020:
3021: INV_Quantity_Tree_Grp.Update_Quantities(
3022: p_api_version_number => 1.0,

Line 3019: gme_debug.put_line('revision = '||p_revision);

3015: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
3016: gme_debug.put_line('lot = '||p_lot_number);
3017: gme_debug.put_line('Sub = '||p_subinventory_code);
3018: gme_debug.put_line('Locator id = '||p_locator_id);
3019: gme_debug.put_line('revision = '||p_revision);
3020:
3021: INV_Quantity_Tree_Grp.Update_Quantities(
3022: p_api_version_number => 1.0,
3023: p_init_msg_lst => 'T',

Line 3050: gme_debug.put_line('New ATT = '||l_att);

3046: x_satr => l_satr,
3047: p_containerized => 0,
3048: p_lpn_id => NULL);
3049:
3050: gme_debug.put_line('New ATT = '||l_att);
3051: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3052: RAISE UPDATE_TREE_ERROR;
3053: END IF;
3054:

Line 3060: IF g_debug <= gme_debug.g_log_unexpected THEN

3056:
3057:
3058: EXCEPTION
3059: WHEN UPDATE_TREE_ERROR THEN
3060: IF g_debug <= gme_debug.g_log_unexpected THEN
3061: gme_debug.put_line('Update Qty Tree exception');
3062: END IF;
3063:
3064: WHEN OTHERS THEN

Line 3061: gme_debug.put_line('Update Qty Tree exception');

3057:
3058: EXCEPTION
3059: WHEN UPDATE_TREE_ERROR THEN
3060: IF g_debug <= gme_debug.g_log_unexpected THEN
3061: gme_debug.put_line('Update Qty Tree exception');
3062: END IF;
3063:
3064: WHEN OTHERS THEN
3065: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 3065: IF g_debug <= gme_debug.g_log_unexpected THEN

3061: gme_debug.put_line('Update Qty Tree exception');
3062: END IF;
3063:
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;

Line 3066: gme_debug.put_line('When others exception in Update Qty Tree');

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

Line 3164: gme_debug.log_initialize ('MobileValItemForIssue');

3160:
3161: BEGIN
3162:
3163: IF (g_debug IS NOT NULL) THEN
3164: gme_debug.log_initialize ('MobileValItemForIssue');
3165: gme_debug.put_line('Org Id = ' || p_organization_id);
3166: gme_debug.put_line('Batch Id = ' || p_batch_id);
3167: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3168: gme_debug.put_line('Item Id = ' || p_item_id);

Line 3165: gme_debug.put_line('Org Id = ' || p_organization_id);

3161: BEGIN
3162:
3163: IF (g_debug IS NOT NULL) THEN
3164: gme_debug.log_initialize ('MobileValItemForIssue');
3165: gme_debug.put_line('Org Id = ' || p_organization_id);
3166: gme_debug.put_line('Batch Id = ' || p_batch_id);
3167: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3168: gme_debug.put_line('Item Id = ' || p_item_id);
3169: END IF;

Line 3166: gme_debug.put_line('Batch Id = ' || p_batch_id);

3162:
3163: IF (g_debug IS NOT NULL) THEN
3164: gme_debug.log_initialize ('MobileValItemForIssue');
3165: gme_debug.put_line('Org Id = ' || p_organization_id);
3166: gme_debug.put_line('Batch Id = ' || p_batch_id);
3167: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3168: gme_debug.put_line('Item Id = ' || p_item_id);
3169: END IF;
3170:

Line 3167: gme_debug.put_line('Line Id = ' || p_material_detail_id);

3163: IF (g_debug IS NOT NULL) THEN
3164: gme_debug.log_initialize ('MobileValItemForIssue');
3165: gme_debug.put_line('Org Id = ' || p_organization_id);
3166: gme_debug.put_line('Batch Id = ' || p_batch_id);
3167: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3168: gme_debug.put_line('Item Id = ' || p_item_id);
3169: END IF;
3170:
3171: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3168: gme_debug.put_line('Item Id = ' || p_item_id);

3164: gme_debug.log_initialize ('MobileValItemForIssue');
3165: gme_debug.put_line('Org Id = ' || p_organization_id);
3166: gme_debug.put_line('Batch Id = ' || p_batch_id);
3167: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3168: gme_debug.put_line('Item Id = ' || p_item_id);
3169: END IF;
3170:
3171: x_return_status := FND_API.G_RET_STS_SUCCESS;
3172: x_error_msg := ' ';

Line 3222: IF g_debug <= gme_debug.g_log_unexpected 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');
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;

Line 3223: gme_debug.put_line('When others exception in Validate Item To Issue');

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

Line 3262: gme_debug.log_initialize ('MobileValItemToReturn');

3258:
3259: BEGIN
3260:
3261: IF (g_debug IS NOT NULL) THEN
3262: gme_debug.log_initialize ('MobileValItemToReturn');
3263: gme_debug.put_line('Org Id = ' || p_organization_id);
3264: gme_debug.put_line('Batch Id = ' || p_batch_id);
3265: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3266: gme_debug.put_line('Item Id = ' || p_item_id);

Line 3263: gme_debug.put_line('Org Id = ' || p_organization_id);

3259: BEGIN
3260:
3261: IF (g_debug IS NOT NULL) THEN
3262: gme_debug.log_initialize ('MobileValItemToReturn');
3263: gme_debug.put_line('Org Id = ' || p_organization_id);
3264: gme_debug.put_line('Batch Id = ' || p_batch_id);
3265: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3266: gme_debug.put_line('Item Id = ' || p_item_id);
3267: END IF;

Line 3264: gme_debug.put_line('Batch Id = ' || p_batch_id);

3260:
3261: IF (g_debug IS NOT NULL) THEN
3262: gme_debug.log_initialize ('MobileValItemToReturn');
3263: gme_debug.put_line('Org Id = ' || p_organization_id);
3264: gme_debug.put_line('Batch Id = ' || p_batch_id);
3265: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3266: gme_debug.put_line('Item Id = ' || p_item_id);
3267: END IF;
3268:

Line 3265: gme_debug.put_line('Line Id = ' || p_material_detail_id);

3261: IF (g_debug IS NOT NULL) THEN
3262: gme_debug.log_initialize ('MobileValItemToReturn');
3263: gme_debug.put_line('Org Id = ' || p_organization_id);
3264: gme_debug.put_line('Batch Id = ' || p_batch_id);
3265: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3266: gme_debug.put_line('Item Id = ' || p_item_id);
3267: END IF;
3268:
3269: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3266: gme_debug.put_line('Item Id = ' || p_item_id);

3262: gme_debug.log_initialize ('MobileValItemToReturn');
3263: gme_debug.put_line('Org Id = ' || p_organization_id);
3264: gme_debug.put_line('Batch Id = ' || p_batch_id);
3265: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3266: gme_debug.put_line('Item Id = ' || p_item_id);
3267: END IF;
3268:
3269: x_return_status := FND_API.G_RET_STS_SUCCESS;
3270: x_error_msg := ' ';

Line 3289: IF g_debug <= gme_debug.g_log_unexpected 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');
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;

Line 3290: gme_debug.put_line('When others exception in Validate Item To Return');

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

Line 3339: gme_debug.log_initialize ('MobileValProdToYield');

3335:
3336: BEGIN
3337:
3338: IF (g_debug IS NOT NULL) THEN
3339: gme_debug.log_initialize ('MobileValProdToYield');
3340: gme_debug.put_line('Org Id = ' || p_organization_id);
3341: gme_debug.put_line('Batch Id = ' || p_batch_id);
3342: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3343: gme_debug.put_line('Item Id = ' || p_item_id);

Line 3340: gme_debug.put_line('Org Id = ' || p_organization_id);

3336: BEGIN
3337:
3338: IF (g_debug IS NOT NULL) THEN
3339: gme_debug.log_initialize ('MobileValProdToYield');
3340: gme_debug.put_line('Org Id = ' || p_organization_id);
3341: gme_debug.put_line('Batch Id = ' || p_batch_id);
3342: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3343: gme_debug.put_line('Item Id = ' || p_item_id);
3344: END IF;

Line 3341: gme_debug.put_line('Batch Id = ' || p_batch_id);

3337:
3338: IF (g_debug IS NOT NULL) THEN
3339: gme_debug.log_initialize ('MobileValProdToYield');
3340: gme_debug.put_line('Org Id = ' || p_organization_id);
3341: gme_debug.put_line('Batch Id = ' || p_batch_id);
3342: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3343: gme_debug.put_line('Item Id = ' || p_item_id);
3344: END IF;
3345:

Line 3342: gme_debug.put_line('Line Id = ' || p_material_detail_id);

3338: IF (g_debug IS NOT NULL) THEN
3339: gme_debug.log_initialize ('MobileValProdToYield');
3340: gme_debug.put_line('Org Id = ' || p_organization_id);
3341: gme_debug.put_line('Batch Id = ' || p_batch_id);
3342: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3343: gme_debug.put_line('Item Id = ' || p_item_id);
3344: END IF;
3345:
3346: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3343: gme_debug.put_line('Item Id = ' || p_item_id);

3339: gme_debug.log_initialize ('MobileValProdToYield');
3340: gme_debug.put_line('Org Id = ' || p_organization_id);
3341: gme_debug.put_line('Batch Id = ' || p_batch_id);
3342: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3343: gme_debug.put_line('Item Id = ' || p_item_id);
3344: END IF;
3345:
3346: x_return_status := FND_API.G_RET_STS_SUCCESS;
3347: x_error_msg := ' ';

Line 3392: IF g_debug <= gme_debug.g_log_unexpected 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');
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;

Line 3393: gme_debug.put_line('When others exception in Validate Prod To Yield');

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

Line 3428: gme_debug.log_initialize ('MobileFetchIssueTxn');

3424: l_date_format VARCHAR2(100);
3425: BEGIN
3426:
3427: IF (g_debug IS NOT NULL) THEN
3428: gme_debug.log_initialize ('MobileFetchIssueTxn');
3429: END IF;
3430:
3431: x_return_status := FND_API.G_RET_STS_SUCCESS;
3432: x_error_msg := ' ';

Line 3467: IF g_debug <= gme_debug.g_log_unexpected THEN

3463: AND lc.inventory_location_id(+) = m.locator_id;
3464:
3465: EXCEPTION
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;

Line 3468: gme_debug.put_line('When others exception in fetch Issue Transactions');

3464:
3465: EXCEPTION
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;

Line 3505: gme_debug.log_initialize ('MobileFetchYieldTxn');

3501: l_txn_type_id NUMBER;
3502: BEGIN
3503:
3504: IF (g_debug IS NOT NULL) THEN
3505: gme_debug.log_initialize ('MobileFetchYieldTxn');
3506: END IF;
3507:
3508: x_return_status := FND_API.G_RET_STS_SUCCESS;
3509: x_error_msg := ' ';

Line 3546: IF g_debug <= gme_debug.g_log_unexpected THEN

3542: AND lc.inventory_location_id(+) = m.locator_id;
3543:
3544: EXCEPTION
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;

Line 3547: gme_debug.put_line('When others exception in fetch yield Transactions');

3543:
3544: EXCEPTION
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;

Line 3597: gme_debug.log_initialize ('MobileCreatePhantomTxn');

3593: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
3594: BEGIN
3595:
3596: IF (g_debug IS NOT NULL) THEN
3597: gme_debug.log_initialize ('MobileCreatePhantomTxn');
3598: END IF;
3599:
3600: --Initially let us assign the return status to success
3601: x_return_status := fnd_api.g_ret_sts_success;

Line 3603: IF (g_debug <= gme_debug.g_log_statement) THEN

3599:
3600: --Initially let us assign the return status to success
3601: x_return_status := fnd_api.g_ret_sts_success;
3602:
3603: IF (g_debug <= gme_debug.g_log_statement) THEN
3604: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3605: || 'Entering');
3606: END IF;
3607:

Line 3604: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

3600: --Initially let us assign the return status to success
3601: x_return_status := fnd_api.g_ret_sts_success;
3602:
3603: IF (g_debug <= gme_debug.g_log_statement) THEN
3604: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3605: || 'Entering');
3606: END IF;
3607:
3608: OPEN cur_get_transaction(p_mmti_trans_id);

Line 3656: IF (g_debug <= gme_debug.g_log_statement) THEN

3652: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3653: RAISE fnd_api.g_exc_error;
3654: END IF;
3655:
3656: IF (g_debug <= gme_debug.g_log_statement) THEN
3657: gme_debug.put_line ( g_pkg_name
3658: || '.'
3659: || l_api_name
3660: || ':'

Line 3657: gme_debug.put_line ( g_pkg_name

3653: RAISE fnd_api.g_exc_error;
3654: END IF;
3655:
3656: IF (g_debug <= gme_debug.g_log_statement) THEN
3657: gme_debug.put_line ( g_pkg_name
3658: || '.'
3659: || l_api_name
3660: || ':'
3661: || 'Exiting with '

Line 3677: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

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
3681: || ':'

Line 3678: gme_debug.put_line ( g_pkg_name

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
3681: || ':'
3682: || 'WHEN OTHERS:'

Line 4270: gme_debug.log_initialize ('RelieveRsrvPndLots');

4266: l_count NUMBER;
4267: l_date_format VARCHAR2(100);
4268: BEGIN
4269: IF (g_debug IS NOT NULL) THEN
4270: gme_debug.log_initialize ('RelieveRsrvPndLots');
4271: END IF;
4272:
4273: x_return_status := fnd_api.g_ret_sts_success;
4274: x_error_msg := ' ';

Line 4300: IF g_debug <= gme_debug.g_log_unexpected THEN

4296: x_trans_date := TO_CHAR(l_trans_date,l_date_format||HOUR_MIN_SEC_FORMAT_STRING);
4297:
4298: EXCEPTION
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;

Line 4301: gme_debug.put_line('When others exception in fetch_txn_date');

4297:
4298: EXCEPTION
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;

Line 4443: gme_debug.log_initialize ('MobileFetchSubinvLoc');

4439: AND m.batch_id = p_batch_id
4440: AND m.material_Detail_id = p_material_detail_id;
4441: BEGIN
4442: IF (g_debug IS NOT NULL) THEN
4443: gme_debug.log_initialize ('MobileFetchSubinvLoc');
4444: END IF;
4445:
4446:
4447: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4456: IF g_debug <= gme_debug.g_log_unexpected THEN

4452: CLOSE c_subinv_loc;
4453:
4454: EXCEPTION
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;

Line 4457: gme_debug.put_line('When others exception in Fetch_subinv_locator');

4453:
4454: EXCEPTION
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;

Line 4480: gme_debug.log_initialize ('MobileGetExpDate');

4476:
4477: BEGIN
4478: x_return_status := FND_API.G_RET_STS_SUCCESS;
4479: IF (g_debug IS NOT NULL) THEN
4480: gme_debug.log_initialize ('MobileGetExpDate');
4481: END IF;
4482:
4483: l_mti_txn_tbl := inv_calculate_exp_date.get_mti_tbl;
4484: IF l_mti_txn_tbl.COUNT > 0 THEN

Line 4497: IF g_debug <= gme_debug.g_log_statement THEN

4493: ,x_return_status => x_return_status);
4494:
4495: inv_calculate_exp_date.purge_mti_tab;
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');

Line 4498: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');

4494:
4495: inv_calculate_exp_date.purge_mti_tab;
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;

Line 4506: gme_debug.put_line('l_lot_expiration_date '||l_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
4506: gme_debug.put_line('l_lot_expiration_date '||l_lot_expiration_date);
4507: END IF;
4508: x_expiration_date := l_lot_expiration_date;
4509: -- ELSE
4510: -- x_expiration_date := x_origination_date + l_get_dft_attr_rec.shelf_life_days;

Line 4515: IF g_debug <= gme_debug.g_log_unexpected THEN

4511: END IF;
4512: EXCEPTION
4513: WHEN OTHERS THEN
4514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4515: IF g_debug <= gme_debug.g_log_unexpected THEN
4516: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);
4517: END IF;
4518: END get_expiration_date;
4519:

Line 4516: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);

4512: EXCEPTION
4513: WHEN OTHERS THEN
4514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4515: IF g_debug <= gme_debug.g_log_unexpected THEN
4516: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);
4517: END IF;
4518: END get_expiration_date;
4519:
4520: PROCEDURE get_exp_action_date (

Line 4537: IF g_debug <= gme_debug.g_log_unexpected THEN

4533:
4534: EXCEPTION
4535: WHEN OTHERS THEN
4536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4537: IF g_debug <= gme_debug.g_log_unexpected THEN
4538: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);
4539: END IF;
4540: END get_exp_action_date;
4541: -- nsinghi bug#5209065 END.

Line 4538: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);

4534: EXCEPTION
4535: WHEN OTHERS THEN
4536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4537: IF g_debug <= gme_debug.g_log_unexpected THEN
4538: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);
4539: END IF;
4540: END get_exp_action_date;
4541: -- nsinghi bug#5209065 END.
4542: