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

86: l_count NUMBER;
87: no_rsrv_pndlot_id EXCEPTION;
88: BEGIN
89: IF (g_debug IS NOT NULL) THEN
90: gme_debug.log_initialize ('RelieveRsrvPndLots');
91: END IF;
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94: x_error_msg := ' ';

Line 131: IF g_debug <= gme_debug.g_log_unexpected THEN

127: x_return_status := fnd_api.g_ret_sts_error;
128: fnd_message.set_name('GME','INVALID_VALUE');
129: x_error_msg := fnd_message.get;
130: WHEN OTHERS THEN
131: IF g_debug <= gme_debug.g_log_unexpected THEN
132: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');
133: END IF;
134: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_pend_lots');
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

128: fnd_message.set_name('GME','INVALID_VALUE');
129: x_error_msg := fnd_message.get;
130: WHEN OTHERS THEN
131: IF g_debug <= gme_debug.g_log_unexpected THEN
132: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');
133: END IF;
134: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_pend_lots');
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: x_error_msg := fnd_message.get;

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

247: -- Clearing the quantity cache
248: inv_quantity_tree_pub.clear_quantity_cache;
249:
250: IF (g_debug IS NOT NULL) THEN
251: gme_debug.log_initialize ('MobileCreTxn');
252: END IF;
253:
254: gme_common_pvt.g_user_ident := p_user_id;
255: gme_common_pvt.g_login_id := p_login_id;

Line 314: IF g_debug <= gme_debug.g_log_unexpected THEN

310: END IF;
311:
312: EXCEPTION
313: WHEN OTHERS THEN
314: IF g_debug <= gme_debug.g_log_unexpected THEN
315: gme_debug.put_line('When others exception in Create MAterial Txn');
316: END IF;
317: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_material_txn');
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

311:
312: EXCEPTION
313: WHEN OTHERS THEN
314: IF g_debug <= gme_debug.g_log_unexpected THEN
315: gme_debug.put_line('When others exception in Create MAterial Txn');
316: END IF;
317: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_material_txn');
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: x_error_msg := fnd_message.get;

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

354: l_mmli_rec_out mtl_transaction_lots_interface%ROWTYPE;
355: BEGIN
356:
357: IF (g_debug IS NOT NULL) THEN
358: gme_debug.log_initialize ('MobileCreLotTxn');
359: END IF;
360:
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362: x_error_msg := ' ';

Line 392: IF g_debug <= gme_debug.g_log_unexpected THEN

388: END IF;
389:
390: EXCEPTION
391: WHEN OTHERS THEN
392: IF g_debug <= gme_debug.g_log_unexpected THEN
393: gme_debug.put_line('When others exception in Create Lot Txn');
394: END IF;
395: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_lot_txn');
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

389:
390: EXCEPTION
391: WHEN OTHERS THEN
392: IF g_debug <= gme_debug.g_log_unexpected THEN
393: gme_debug.put_line('When others exception in Create Lot Txn');
394: END IF;
395: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_lot_txn');
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: x_error_msg := fnd_message.get;

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

432:
433: BEGIN
434:
435: IF (g_debug IS NOT NULL) THEN
436: gme_debug.log_initialize ('MobileValLotTxn');
437: END IF;
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439: x_error_msg := ' ';
440:

Line 472: IF g_debug <= gme_debug.g_log_unexpected THEN

468: END IF;
469:
470: EXCEPTION
471: WHEN OTHERS THEN
472: IF g_debug <= gme_debug.g_log_unexpected THEN
473: gme_debug.put_line('When others exception in Validate Indiv Lot Txn');
474: END IF;
475: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Indiv_Lot_Txn');
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

469:
470: EXCEPTION
471: WHEN OTHERS THEN
472: IF g_debug <= gme_debug.g_log_unexpected THEN
473: gme_debug.put_line('When others exception in Validate Indiv Lot Txn');
474: END IF;
475: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Indiv_Lot_Txn');
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: x_error_msg := fnd_message.get;

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

514:
515: BEGIN
516:
517: IF (g_debug IS NOT NULL) THEN
518: gme_debug.log_initialize ('MobileValMtlSts');
519: END IF;
520:
521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522: x_error_msg := ' ';

Line 605: IF g_debug <= gme_debug.g_log_unexpected THEN

601: END IF;
602:
603: EXCEPTION
604: WHEN OTHERS THEN
605: IF g_debug <= gme_debug.g_log_unexpected THEN
606: gme_debug.put_line('When others exception in Is_Material_Status_Applicable');
607: END IF;
608: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Is_Material_Status_Applicable');
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

602:
603: EXCEPTION
604: WHEN OTHERS THEN
605: IF g_debug <= gme_debug.g_log_unexpected THEN
606: gme_debug.put_line('When others exception in Is_Material_Status_Applicable');
607: END IF;
608: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Is_Material_Status_Applicable');
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610: x_error_msg := fnd_message.get;

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

644: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type;
645: BEGIN
646:
647: IF (g_debug IS NOT NULL) THEN
648: gme_debug.log_initialize ('MobileFetchAgrTxns');
649: END IF;
650:
651:
652: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 661: IF g_debug <= gme_debug.g_log_unexpected THEN

657: CLOSE Get_Agg_Txn;
658:
659: EXCEPTION
660: WHEN OTHERS THEN
661: IF g_debug <= gme_debug.g_log_unexpected THEN
662: gme_debug.put_line('When others exception in fetch aggrageted txns');
663: END IF;
664: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_txns');
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

658:
659: EXCEPTION
660: WHEN OTHERS THEN
661: IF g_debug <= gme_debug.g_log_unexpected THEN
662: gme_debug.put_line('When others exception in fetch aggrageted txns');
663: END IF;
664: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_txns');
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666: x_error_msg := fnd_message.get;

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

691: IS
692: BEGIN
693:
694: IF (g_debug IS NOT NULL) THEN
695: gme_debug.log_initialize ('MobileFetchAgrLotTxns');
696: END IF;
697:
698:
699: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 718: IF g_debug <= gme_debug.g_log_unexpected THEN

714: GROUP BY m.revision,l.lot_number;
715:
716: EXCEPTION
717: WHEN OTHERS THEN
718: IF g_debug <= gme_debug.g_log_unexpected THEN
719: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
720: END IF;
721: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_lot_txns');
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

715:
716: EXCEPTION
717: WHEN OTHERS THEN
718: IF g_debug <= gme_debug.g_log_unexpected THEN
719: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
720: END IF;
721: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_lot_txns');
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: x_error_msg := fnd_message.get;

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

760: GROUP BY revision;
761: BEGIN
762:
763: IF (g_debug IS NOT NULL) THEN
764: gme_debug.log_initialize ('MobileFetchAgrRevTxns');
765: END IF;
766:
767:
768: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 778: IF g_debug <= gme_debug.g_log_unexpected THEN

774:
775:
776: EXCEPTION
777: WHEN OTHERS THEN
778: IF g_debug <= gme_debug.g_log_unexpected THEN
779: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
780: END IF;
781: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_rev_txns');
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

775:
776: EXCEPTION
777: WHEN OTHERS THEN
778: IF g_debug <= gme_debug.g_log_unexpected THEN
779: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
780: END IF;
781: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_rev_txns');
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783: x_error_msg := fnd_message.get;

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

810: l_txn_type_id NUMBER;
811: BEGIN
812:
813: IF (g_debug IS NOT NULL) THEN
814: gme_debug.log_initialize ('MobileFetchMtl');
815: END IF;
816:
817: l_txn_type_id := Get_Txn_Type(p_txn_type_id);
818:

Line 850: IF g_debug <= gme_debug.g_log_unexpected THEN

846: AND l.inventory_location_id = m.locator_id(+);
847:
848: EXCEPTION
849: WHEN OTHERS THEN
850: IF g_debug <= gme_debug.g_log_unexpected THEN
851: gme_debug.put_line('When others exception in fetch Mtl Transactions');
852: END IF;
853: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_transactions');
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

847:
848: EXCEPTION
849: WHEN OTHERS THEN
850: IF g_debug <= gme_debug.g_log_unexpected THEN
851: gme_debug.put_line('When others exception in fetch Mtl Transactions');
852: END IF;
853: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_transactions');
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855: x_error_msg := fnd_message.get;

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

879: IS
880: BEGIN
881:
882: IF (g_debug IS NOT NULL) THEN
883: gme_debug.log_initialize ('MobileFetchLotTxn');
884: END IF;
885:
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887: x_error_msg := ' ';

Line 901: IF g_debug <= gme_debug.g_log_unexpected THEN

897: lot_number = NVL(p_lot_number, lot_number);
898:
899: EXCEPTION
900: WHEN OTHERS THEN
901: IF g_debug <= gme_debug.g_log_unexpected THEN
902: gme_debug.put_line('When others exception in fetch Mtl Lot Transactions');
903: END IF;
904: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_lot_transactions');
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

898:
899: EXCEPTION
900: WHEN OTHERS THEN
901: IF g_debug <= gme_debug.g_log_unexpected THEN
902: gme_debug.put_line('When others exception in fetch Mtl Lot Transactions');
903: END IF;
904: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_lot_transactions');
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: x_error_msg := fnd_message.get;

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

933:
934: BEGIN
935:
936: IF (g_debug IS NOT NULL) THEN
937: gme_debug.log_initialize ('MobileProcessTxn');
938: END IF;
939:
940: gme_common_pvt.g_user_ident := p_user_id;
941: gme_common_pvt.g_login_id := p_login_id;

Line 973: IF g_debug <= gme_debug.g_log_unexpected THEN

969: GME_COMMON_PVT.g_transaction_header_id := NULL;
970:
971: EXCEPTION
972: WHEN OTHERS THEN
973: IF g_debug <= gme_debug.g_log_unexpected THEN
974: gme_debug.put_line('When others exception in Process_Transactions');
975: END IF;
976: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','process_transactions');
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

970:
971: EXCEPTION
972: WHEN OTHERS THEN
973: IF g_debug <= gme_debug.g_log_unexpected THEN
974: gme_debug.put_line('When others exception in Process_Transactions');
975: END IF;
976: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','process_transactions');
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: x_error_msg := fnd_message.get;

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

1112:
1113: BEGIN
1114:
1115: IF (g_debug IS NOT NULL) THEN
1116: gme_debug.log_initialize ('MobileGenLotNumber');
1117: END IF;
1118:
1119: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1120: x_error_msg := '';

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

1147: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1148: RAISE fnd_api.g_exc_error;
1149: END IF;
1150:
1151: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1152: gme_debug.put_line ( 'lot_gen'
1153: || ':'
1154: || 'x_lot_number'
1155: || x_return_status);

Line 1152: gme_debug.put_line ( 'lot_gen'

1148: RAISE fnd_api.g_exc_error;
1149: END IF;
1150:
1151: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1152: gme_debug.put_line ( 'lot_gen'
1153: || ':'
1154: || 'x_lot_number'
1155: || x_return_status);
1156: END IF;

Line 1160: IF g_debug <= gme_debug.g_log_unexpected THEN

1156: END IF;
1157:
1158: EXCEPTION
1159: WHEN fnd_api.g_exc_error THEN
1160: IF g_debug <= gme_debug.g_log_unexpected THEN
1161: gme_debug.put_line ( 'GME_MOBILE_TXNS'
1162: || '.'
1163: || 'Generate_Lot_Number'
1164: || ':'

Line 1161: gme_debug.put_line ( 'GME_MOBILE_TXNS'

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

Line 1172: IF g_debug <= gme_debug.g_log_unexpected THEN

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

Line 1173: gme_debug.put_line ( 'GME_MOBILE_TXNS'

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

Line 1485: gme_debug.log_initialize ('MobileValTxnDate');

1481: DATE_ERROR EXCEPTION;
1482: BEGIN
1483:
1484: IF (g_debug IS NOT NULL) THEN
1485: gme_debug.log_initialize ('MobileValTxnDate');
1486: END IF;
1487:
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;
1489: x_error_msg := ' ';

Line 1516: IF g_debug <= gme_debug.g_log_unexpected THEN

1512: x_error_msg := fnd_message.get;
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514:
1515: WHEN OTHERS THEN
1516: IF g_debug <= gme_debug.g_log_unexpected THEN
1517: gme_debug.put_line('When others exception in Validate Txn Date');
1518: END IF;
1519: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Txn_Date');
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514:
1515: WHEN OTHERS THEN
1516: IF g_debug <= gme_debug.g_log_unexpected THEN
1517: gme_debug.put_line('When others exception in Validate Txn Date');
1518: END IF;
1519: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Txn_Date');
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: x_error_msg := fnd_message.get;

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

1567:
1568: BEGIN
1569:
1570: IF (g_debug IS NOT NULL) THEN
1571: gme_debug.log_initialize ('MobileValBatchForIB');
1572: END IF;
1573:
1574: x_return_status := FND_API.G_RET_STS_SUCCESS;
1575: x_error_msg := ' ';

Line 1613: IF g_debug <= gme_debug.g_log_unexpected THEN

1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610: x_error_msg := fnd_message.get;
1611:
1612: WHEN OTHERS THEN
1613: IF g_debug <= gme_debug.g_log_unexpected THEN
1614: gme_debug.put_line('When others exception in Validate Batch For IB');
1615: END IF;
1616: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Batch_For_IB');
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1610: x_error_msg := fnd_message.get;
1611:
1612: WHEN OTHERS THEN
1613: IF g_debug <= gme_debug.g_log_unexpected THEN
1614: gme_debug.put_line('When others exception in Validate Batch For IB');
1615: END IF;
1616: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Batch_For_IB');
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: x_error_msg := fnd_message.get;

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

1657:
1658: BEGIN
1659:
1660: IF (g_debug IS NOT NULL) THEN
1661: gme_debug.log_initialize ('MobileValItemForIB');
1662: END IF;
1663:
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;
1665: x_error_msg := ' ';

Line 1699: IF g_debug <= gme_debug.g_log_unexpected THEN

1695: x_return_status := FND_API.G_RET_STS_ERROR;
1696: x_error_msg := fnd_message.get;
1697:
1698: WHEN OTHERS THEN
1699: IF g_debug <= gme_debug.g_log_unexpected THEN
1700: gme_debug.put_line('When others exception in Validate Item For IB');
1701: END IF;
1702: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_For_IB');
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1696: x_error_msg := fnd_message.get;
1697:
1698: WHEN OTHERS THEN
1699: IF g_debug <= gme_debug.g_log_unexpected THEN
1700: gme_debug.put_line('When others exception in Validate Item For IB');
1701: END IF;
1702: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_For_IB');
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: x_error_msg := fnd_message.get;

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

1745:
1746: BEGIN
1747:
1748: IF (g_debug IS NOT NULL) THEN
1749: gme_debug.log_initialize ('MobileBackflushMtl');
1750: gme_debug.put_line('BatchId id = '||p_batch_id);
1751: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1752: gme_debug.put_line('Backflush Qty = '||p_qty);
1753: gme_debug.put_line('Qty Type = '||p_qty_type);

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

1746: BEGIN
1747:
1748: IF (g_debug IS NOT NULL) THEN
1749: gme_debug.log_initialize ('MobileBackflushMtl');
1750: gme_debug.put_line('BatchId id = '||p_batch_id);
1751: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1752: gme_debug.put_line('Backflush Qty = '||p_qty);
1753: gme_debug.put_line('Qty Type = '||p_qty_type);
1754: gme_debug.put_line('Org Code = '||p_org_code);

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

1747:
1748: IF (g_debug IS NOT NULL) THEN
1749: gme_debug.log_initialize ('MobileBackflushMtl');
1750: gme_debug.put_line('BatchId id = '||p_batch_id);
1751: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1752: gme_debug.put_line('Backflush Qty = '||p_qty);
1753: gme_debug.put_line('Qty Type = '||p_qty_type);
1754: gme_debug.put_line('Org Code = '||p_org_code);
1755: END IF;

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

1748: IF (g_debug IS NOT NULL) THEN
1749: gme_debug.log_initialize ('MobileBackflushMtl');
1750: gme_debug.put_line('BatchId id = '||p_batch_id);
1751: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1752: gme_debug.put_line('Backflush Qty = '||p_qty);
1753: gme_debug.put_line('Qty Type = '||p_qty_type);
1754: gme_debug.put_line('Org Code = '||p_org_code);
1755: END IF;
1756:

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

1749: gme_debug.log_initialize ('MobileBackflushMtl');
1750: gme_debug.put_line('BatchId id = '||p_batch_id);
1751: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1752: gme_debug.put_line('Backflush Qty = '||p_qty);
1753: gme_debug.put_line('Qty Type = '||p_qty_type);
1754: gme_debug.put_line('Org Code = '||p_org_code);
1755: END IF;
1756:
1757: fnd_profile.put('USER_ID',to_char(p_user_id));

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

1750: gme_debug.put_line('BatchId id = '||p_batch_id);
1751: gme_debug.put_line('Mtl DetailId = '||p_material_detail_id);
1752: gme_debug.put_line('Backflush Qty = '||p_qty);
1753: gme_debug.put_line('Qty Type = '||p_qty_type);
1754: gme_debug.put_line('Org Code = '||p_org_code);
1755: END IF;
1756:
1757: fnd_profile.put('USER_ID',to_char(p_user_id));
1758: fnd_profile.put('LOGIN_ID',to_char(p_login_id));

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

1781: ,p_adjust_cmplt => fnd_api.g_false --- Completed batches not supported
1782: ,x_exception_material_tbl => l_exception_material_tab);
1783:
1784: IF (g_debug IS NOT NULL) THEN
1785: gme_debug.put_line('Return Status = '||x_return_status);
1786: gme_debug.put_line('Error Msg = '||l_msg_list);
1787: END IF;
1788:
1789: IF x_return_status = 'X' THEN

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

1782: ,x_exception_material_tbl => l_exception_material_tab);
1783:
1784: IF (g_debug IS NOT NULL) THEN
1785: gme_debug.put_line('Return Status = '||x_return_status);
1786: gme_debug.put_line('Error Msg = '||l_msg_list);
1787: END IF;
1788:
1789: IF x_return_status = 'X' THEN
1790: FND_MESSAGE.SET_NAME('GME','GME_INCR_BACKFLUSH_EXCEPTIONS');

Line 1810: IF g_debug <= gme_debug.g_log_unexpected THEN

1806: x_return_status := FND_API.G_RET_STS_ERROR;
1807: ROLLBACK;
1808:
1809: WHEN OTHERS THEN
1810: IF g_debug <= gme_debug.g_log_unexpected THEN
1811: gme_debug.put_line('When others exception in Backflush Material');
1812: END IF;
1813: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Backflush_Material');
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1807: ROLLBACK;
1808:
1809: WHEN OTHERS THEN
1810: IF g_debug <= gme_debug.g_log_unexpected THEN
1811: gme_debug.put_line('When others exception in Backflush Material');
1812: END IF;
1813: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Backflush_Material');
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: x_error_msg := fnd_message.get;

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

1852: l_output_rec GME_BATCH_STEP_RESOURCES%ROWTYPE;
1853: BEGIN
1854:
1855: IF (g_debug IS NOT NULL) THEN
1856: gme_debug.log_initialize ('MobileSaveRsrcUsage');
1857: END IF;
1858:
1859: fnd_profile.put('USER_ID',to_char(p_uid));
1860: gme_common_pvt.g_user_ident := p_uid;

Line 1912: IF g_debug <= gme_debug.g_log_unexpected THEN

1908: END IF;
1909:
1910: EXCEPTION
1911: WHEN OTHERS THEN
1912: IF g_debug <= gme_debug.g_log_unexpected THEN
1913: gme_debug.put_line('When others exception in Save Resource Usage');
1914: END IF;
1915: x_result := -4;
1916: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Save_Resource_Usage');

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

1909:
1910: EXCEPTION
1911: WHEN OTHERS THEN
1912: IF g_debug <= gme_debug.g_log_unexpected THEN
1913: gme_debug.put_line('When others exception in Save Resource Usage');
1914: END IF;
1915: x_result := -4;
1916: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Save_Resource_Usage');
1917: x_error_msg := fnd_message.get;

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

1944: l_date_format VARCHAR2(100);
1945: BEGIN
1946:
1947: IF (g_debug IS NOT NULL) THEN
1948: gme_debug.log_initialize ('MobileFetchPendingLot');
1949: END IF;
1950:
1951: x_return_status := FND_API.G_RET_STS_SUCCESS;
1952: x_error_msg := ' ';

Line 1989: IF g_debug <= gme_debug.g_log_unexpected THEN

1985: l.reason_id = r.reason_id(+);
1986:
1987: EXCEPTION
1988: WHEN OTHERS THEN
1989: IF g_debug <= gme_debug.g_log_unexpected THEN
1990: gme_debug.put_line('When others exception in fetch Pending Lots');
1991: END IF;
1992: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_pending_product_lots');
1993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1986:
1987: EXCEPTION
1988: WHEN OTHERS THEN
1989: IF g_debug <= gme_debug.g_log_unexpected THEN
1990: gme_debug.put_line('When others exception in fetch Pending Lots');
1991: END IF;
1992: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_pending_product_lots');
1993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1994: x_error_msg := fnd_message.get;

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

2007: l_date_format VARCHAR2(100);
2008: BEGIN
2009:
2010: IF (g_debug IS NOT NULL) THEN
2011: gme_debug.log_initialize ('MobileFetchRevPendingLot');
2012: END IF;
2013:
2014: x_return_status := FND_API.G_RET_STS_SUCCESS;
2015: x_error_msg := ' ';

Line 2053: IF g_debug <= gme_debug.g_log_unexpected THEN

2049: l.reason_id = r.reason_id(+);
2050:
2051: EXCEPTION
2052: WHEN OTHERS THEN
2053: IF g_debug <= gme_debug.g_log_unexpected THEN
2054: gme_debug.put_line('When others exception in fetch Rev Pending Lots');
2055: END IF;
2056: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_rev_pending_product_lots');
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2050:
2051: EXCEPTION
2052: WHEN OTHERS THEN
2053: IF g_debug <= gme_debug.g_log_unexpected THEN
2054: gme_debug.put_line('When others exception in fetch Rev Pending Lots');
2055: END IF;
2056: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_rev_pending_product_lots');
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: x_error_msg := fnd_message.get;

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

2114: l_create_lot := fnd_api.g_false;
2115: END IF;
2116:
2117: IF (g_debug IS NOT NULL) THEN
2118: gme_debug.log_initialize ('MobileCrePendingLot');
2119: gme_debug.put_line('New lot = ' || p_create_lot);
2120: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2121: gme_debug.put_line('Sequence = ' || p_sequence);
2122: gme_debug.put_line('Revision = ' || p_revision);

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

2115: END IF;
2116:
2117: IF (g_debug IS NOT NULL) THEN
2118: gme_debug.log_initialize ('MobileCrePendingLot');
2119: gme_debug.put_line('New lot = ' || p_create_lot);
2120: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2121: gme_debug.put_line('Sequence = ' || p_sequence);
2122: gme_debug.put_line('Revision = ' || p_revision);
2123: gme_debug.put_line('Lot number = ' || p_lot_number);

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

2116:
2117: IF (g_debug IS NOT NULL) THEN
2118: gme_debug.log_initialize ('MobileCrePendingLot');
2119: gme_debug.put_line('New lot = ' || p_create_lot);
2120: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2121: gme_debug.put_line('Sequence = ' || p_sequence);
2122: gme_debug.put_line('Revision = ' || p_revision);
2123: gme_debug.put_line('Lot number = ' || p_lot_number);
2124: gme_debug.put_line('Quantity = ' || p_qty);

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

2117: IF (g_debug IS NOT NULL) THEN
2118: gme_debug.log_initialize ('MobileCrePendingLot');
2119: gme_debug.put_line('New lot = ' || p_create_lot);
2120: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2121: gme_debug.put_line('Sequence = ' || p_sequence);
2122: gme_debug.put_line('Revision = ' || p_revision);
2123: gme_debug.put_line('Lot number = ' || p_lot_number);
2124: gme_debug.put_line('Quantity = ' || p_qty);
2125: gme_debug.put_line('Sec quantity = ' || p_sec_qty);

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

2118: gme_debug.log_initialize ('MobileCrePendingLot');
2119: gme_debug.put_line('New lot = ' || p_create_lot);
2120: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2121: gme_debug.put_line('Sequence = ' || p_sequence);
2122: gme_debug.put_line('Revision = ' || p_revision);
2123: gme_debug.put_line('Lot number = ' || p_lot_number);
2124: gme_debug.put_line('Quantity = ' || p_qty);
2125: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2126: gme_debug.put_line('Reason_id = ' || p_reason_id);

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

2119: gme_debug.put_line('New lot = ' || p_create_lot);
2120: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2121: gme_debug.put_line('Sequence = ' || p_sequence);
2122: gme_debug.put_line('Revision = ' || p_revision);
2123: gme_debug.put_line('Lot number = ' || p_lot_number);
2124: gme_debug.put_line('Quantity = ' || p_qty);
2125: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2126: gme_debug.put_line('Reason_id = ' || p_reason_id);
2127: gme_debug.put_line('User Id = ' || p_user_id);

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

2120: gme_debug.put_line('Material Detail Id = ' || p_material_detail_id);
2121: gme_debug.put_line('Sequence = ' || p_sequence);
2122: gme_debug.put_line('Revision = ' || p_revision);
2123: gme_debug.put_line('Lot number = ' || p_lot_number);
2124: gme_debug.put_line('Quantity = ' || p_qty);
2125: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2126: gme_debug.put_line('Reason_id = ' || p_reason_id);
2127: gme_debug.put_line('User Id = ' || p_user_id);
2128: gme_debug.put_line('Login Id = ' || p_login_id);

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

2121: gme_debug.put_line('Sequence = ' || p_sequence);
2122: gme_debug.put_line('Revision = ' || p_revision);
2123: gme_debug.put_line('Lot number = ' || p_lot_number);
2124: gme_debug.put_line('Quantity = ' || p_qty);
2125: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2126: gme_debug.put_line('Reason_id = ' || p_reason_id);
2127: gme_debug.put_line('User Id = ' || p_user_id);
2128: gme_debug.put_line('Login Id = ' || p_login_id);
2129: END IF;

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

2122: gme_debug.put_line('Revision = ' || p_revision);
2123: gme_debug.put_line('Lot number = ' || p_lot_number);
2124: gme_debug.put_line('Quantity = ' || p_qty);
2125: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2126: gme_debug.put_line('Reason_id = ' || p_reason_id);
2127: gme_debug.put_line('User Id = ' || p_user_id);
2128: gme_debug.put_line('Login Id = ' || p_login_id);
2129: END IF;
2130:

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

2123: gme_debug.put_line('Lot number = ' || p_lot_number);
2124: gme_debug.put_line('Quantity = ' || p_qty);
2125: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2126: gme_debug.put_line('Reason_id = ' || p_reason_id);
2127: gme_debug.put_line('User Id = ' || p_user_id);
2128: gme_debug.put_line('Login Id = ' || p_login_id);
2129: END IF;
2130:
2131: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2124: gme_debug.put_line('Quantity = ' || p_qty);
2125: gme_debug.put_line('Sec quantity = ' || p_sec_qty);
2126: gme_debug.put_line('Reason_id = ' || p_reason_id);
2127: gme_debug.put_line('User Id = ' || p_user_id);
2128: gme_debug.put_line('Login Id = ' || p_login_id);
2129: END IF;
2130:
2131: x_return_status := FND_API.G_RET_STS_SUCCESS;
2132: x_error_msg := ' ';

Line 2180: IF g_debug <= gme_debug.g_log_unexpected THEN

2176: FND_MSG_PUB.count_and_get
2177: ( p_count => l_message_count
2178: , p_data => x_error_msg
2179: );
2180: IF g_debug <= gme_debug.g_log_unexpected THEN
2181: gme_debug.put_line('When others exception in Create Pending Lots');
2182: END IF;
2183: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_pending_product_lots');
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2177: ( p_count => l_message_count
2178: , p_data => x_error_msg
2179: );
2180: IF g_debug <= gme_debug.g_log_unexpected THEN
2181: gme_debug.put_line('When others exception in Create Pending Lots');
2182: END IF;
2183: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_pending_product_lots');
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: x_error_msg := fnd_message.get;

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

2236:
2237: BEGIN
2238:
2239: IF (g_debug IS NOT NULL) THEN
2240: gme_debug.log_initialize ('MobileUpdatePendingLot');
2241: END IF;
2242:
2243: x_return_status := FND_API.G_RET_STS_SUCCESS;
2244: x_error_msg := ' ';

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

2281: END IF;
2282:
2283: l_pending_product_lots_rec.last_update_date := to_date(p_last_update_date, 'MM/DD/YYYY HH24:MI:SS');
2284:
2285: gme_debug.put_line('Update Pending Lot: ');
2286: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2287: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2288: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2289: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);

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

2282:
2283: l_pending_product_lots_rec.last_update_date := to_date(p_last_update_date, 'MM/DD/YYYY HH24:MI:SS');
2284:
2285: gme_debug.put_line('Update Pending Lot: ');
2286: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2287: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2288: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2289: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2290: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);

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

2283: l_pending_product_lots_rec.last_update_date := to_date(p_last_update_date, 'MM/DD/YYYY HH24:MI:SS');
2284:
2285: gme_debug.put_line('Update Pending Lot: ');
2286: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2287: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2288: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2289: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2290: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2291: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);

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

2284:
2285: gme_debug.put_line('Update Pending Lot: ');
2286: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2287: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2288: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2289: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2290: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2291: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2292: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);

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

2285: gme_debug.put_line('Update Pending Lot: ');
2286: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2287: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2288: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2289: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2290: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2291: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2292: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);
2293: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);

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

2286: gme_debug.put_line('Last Upd Date = '|| to_char(l_pending_product_lots_rec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
2287: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2288: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2289: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2290: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2291: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2292: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);
2293: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);
2294:

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

2287: gme_debug.put_line('Sequence Chg = '|| p_is_seq_changed);
2288: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2289: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2290: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2291: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2292: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);
2293: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);
2294:
2295: GME_API_PUB.update_pending_product_lot

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

2288: gme_debug.put_line('Sequence = '|| l_pending_product_lots_rec.sequence);
2289: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2290: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2291: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2292: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);
2293: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);
2294:
2295: GME_API_PUB.update_pending_product_lot
2296: (p_api_version => 2.0

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

2289: gme_debug.put_line('Lot id = '|| l_pending_product_lots_rec.pending_product_lot_id);
2290: gme_debug.put_line('Line Id = '|| l_pending_product_lots_rec.material_detail_id);
2291: gme_debug.put_line('Qty = '|| l_pending_product_lots_rec.quantity);
2292: gme_debug.put_line('Sec Qty = '|| l_pending_product_lots_rec.secondary_quantity);
2293: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);
2294:
2295: GME_API_PUB.update_pending_product_lot
2296: (p_api_version => 2.0
2297: ,p_validation_level => gme_common_pvt.g_max_errors

Line 2321: IF g_debug <= gme_debug.g_log_unexpected THEN

2317: END IF;
2318:
2319: EXCEPTION
2320: WHEN OTHERS THEN
2321: IF g_debug <= gme_debug.g_log_unexpected THEN
2322: gme_debug.put_line('When others exception in Update Pending Lots');
2323: FND_MSG_PUB.count_and_get
2324: ( p_count => l_message_count
2325: , p_data => x_error_msg

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

2318:
2319: EXCEPTION
2320: WHEN OTHERS THEN
2321: IF g_debug <= gme_debug.g_log_unexpected THEN
2322: gme_debug.put_line('When others exception in Update Pending Lots');
2323: FND_MSG_PUB.count_and_get
2324: ( p_count => l_message_count
2325: , p_data => x_error_msg
2326: );

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

2323: FND_MSG_PUB.count_and_get
2324: ( p_count => l_message_count
2325: , p_data => x_error_msg
2326: );
2327: gme_debug.put_line('Error = '||x_error_msg);
2328: END IF;
2329: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','update_pending_product_lots');
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331:

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

2364:
2365: BEGIN
2366:
2367: IF (g_debug IS NOT NULL) THEN
2368: gme_debug.log_initialize ('MobilePopulateDispTbl');
2369: END IF;
2370:
2371: x_return_status := FND_API.G_RET_STS_SUCCESS;
2372: x_error_msg := ' ';

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

2392: LOOP
2393:
2394: IF l_rsrv_tab(l_index).external_source_line_id IS NOT NULL THEN
2395:
2396: gme_debug.put_line('Inserting Dispensed record ');
2397: gme_debug.put_line('ID = ' ||
2398: l_rsrv_tab(l_index).external_source_line_id);
2399: gme_debug.put_line('Sub = ' ||
2400: l_rsrv_tab(l_index).subinventory_code);

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

2393:
2394: IF l_rsrv_tab(l_index).external_source_line_id IS NOT NULL THEN
2395:
2396: gme_debug.put_line('Inserting Dispensed record ');
2397: gme_debug.put_line('ID = ' ||
2398: l_rsrv_tab(l_index).external_source_line_id);
2399: gme_debug.put_line('Sub = ' ||
2400: l_rsrv_tab(l_index).subinventory_code);
2401: gme_debug.put_line('Locator Id = ' ||

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

2395:
2396: gme_debug.put_line('Inserting Dispensed record ');
2397: gme_debug.put_line('ID = ' ||
2398: l_rsrv_tab(l_index).external_source_line_id);
2399: gme_debug.put_line('Sub = ' ||
2400: l_rsrv_tab(l_index).subinventory_code);
2401: gme_debug.put_line('Locator Id = ' ||
2402: l_rsrv_tab(l_index).locator_id);
2403: gme_debug.put_line('UOM = ' ||

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

2397: gme_debug.put_line('ID = ' ||
2398: l_rsrv_tab(l_index).external_source_line_id);
2399: gme_debug.put_line('Sub = ' ||
2400: l_rsrv_tab(l_index).subinventory_code);
2401: gme_debug.put_line('Locator Id = ' ||
2402: l_rsrv_tab(l_index).locator_id);
2403: gme_debug.put_line('UOM = ' ||
2404: l_rsrv_tab(l_index).reservation_uom_code);
2405: gme_debug.put_line('QTY = ' ||

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

2399: gme_debug.put_line('Sub = ' ||
2400: l_rsrv_tab(l_index).subinventory_code);
2401: gme_debug.put_line('Locator Id = ' ||
2402: l_rsrv_tab(l_index).locator_id);
2403: gme_debug.put_line('UOM = ' ||
2404: l_rsrv_tab(l_index).reservation_uom_code);
2405: gme_debug.put_line('QTY = ' ||
2406: l_rsrv_tab(l_index).reservation_quantity);
2407: gme_debug.put_line('Sec QTY = ' ||

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

2401: gme_debug.put_line('Locator Id = ' ||
2402: l_rsrv_tab(l_index).locator_id);
2403: gme_debug.put_line('UOM = ' ||
2404: l_rsrv_tab(l_index).reservation_uom_code);
2405: gme_debug.put_line('QTY = ' ||
2406: l_rsrv_tab(l_index).reservation_quantity);
2407: gme_debug.put_line('Sec QTY = ' ||
2408: l_rsrv_tab(l_index).secondary_reservation_quantity);
2409: gme_debug.put_line('Lot = ' ||

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

2403: gme_debug.put_line('UOM = ' ||
2404: l_rsrv_tab(l_index).reservation_uom_code);
2405: gme_debug.put_line('QTY = ' ||
2406: l_rsrv_tab(l_index).reservation_quantity);
2407: gme_debug.put_line('Sec QTY = ' ||
2408: l_rsrv_tab(l_index).secondary_reservation_quantity);
2409: gme_debug.put_line('Lot = ' ||
2410: l_rsrv_tab(l_index).lot_number);
2411: gme_debug.put_line('Revision = ' ||

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

2405: gme_debug.put_line('QTY = ' ||
2406: l_rsrv_tab(l_index).reservation_quantity);
2407: gme_debug.put_line('Sec QTY = ' ||
2408: l_rsrv_tab(l_index).secondary_reservation_quantity);
2409: gme_debug.put_line('Lot = ' ||
2410: l_rsrv_tab(l_index).lot_number);
2411: gme_debug.put_line('Revision = ' ||
2412: l_rsrv_tab(l_index).revision);
2413:

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

2407: gme_debug.put_line('Sec QTY = ' ||
2408: l_rsrv_tab(l_index).secondary_reservation_quantity);
2409: gme_debug.put_line('Lot = ' ||
2410: l_rsrv_tab(l_index).lot_number);
2411: gme_debug.put_line('Revision = ' ||
2412: l_rsrv_tab(l_index).revision);
2413:
2414: INSERT INTO GME_MATERIAL_DISPENSING_GTMP
2415: (

Line 2445: IF g_debug <= gme_debug.g_log_unexpected THEN

2441: x_dispensed_count := l_dispensed;
2442:
2443: EXCEPTION
2444: WHEN OTHERS THEN
2445: IF g_debug <= gme_debug.g_log_unexpected THEN
2446: gme_debug.put_line('When others exception in Populate_Dispensing_Table');
2447: gme_debug.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,
2448: 255));
2449:

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

2442:
2443: EXCEPTION
2444: WHEN OTHERS THEN
2445: IF g_debug <= gme_debug.g_log_unexpected THEN
2446: gme_debug.put_line('When others exception in Populate_Dispensing_Table');
2447: gme_debug.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,
2448: 255));
2449:
2450: END IF;

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

2443: EXCEPTION
2444: WHEN OTHERS THEN
2445: IF g_debug <= gme_debug.g_log_unexpected THEN
2446: gme_debug.put_line('When others exception in Populate_Dispensing_Table');
2447: gme_debug.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,
2448: 255));
2449:
2450: END IF;
2451: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Populate_Dispensing_Table');

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

2476:
2477: BEGIN
2478:
2479: IF (g_debug IS NOT NULL) THEN
2480: gme_debug.log_initialize ('MobileDelDispRec');
2481: END IF;
2482:
2483: x_return_status := FND_API.G_RET_STS_SUCCESS;
2484: x_error_msg := ' ';

Line 2491: IF g_debug <= gme_debug.g_log_unexpected THEN

2487: WHERE dispense_id = p_dispense_id;
2488:
2489: EXCEPTION
2490: WHEN OTHERS THEN
2491: IF g_debug <= gme_debug.g_log_unexpected THEN
2492: gme_debug.put_line('When others exception in Delete_Dispensing_Record');
2493: END IF;
2494: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Delete_Dispensing_Record');
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2488:
2489: EXCEPTION
2490: WHEN OTHERS THEN
2491: IF g_debug <= gme_debug.g_log_unexpected THEN
2492: gme_debug.put_line('When others exception in Delete_Dispensing_Record');
2493: END IF;
2494: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Delete_Dispensing_Record');
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2496: x_error_msg := fnd_message.get;

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

2526: NVL(locator_id, -1) = NVL(p_locator_id, -1);
2527: BEGIN
2528:
2529: IF (g_debug IS NOT NULL) THEN
2530: gme_debug.log_initialize ('MobileCountDispLot');
2531: END IF;
2532:
2533: x_return_status := FND_API.G_RET_STS_SUCCESS;
2534: x_error_msg := ' ';

Line 2542: IF g_debug <= gme_debug.g_log_unexpected THEN

2538: CLOSE lot_count;
2539:
2540: EXCEPTION
2541: WHEN OTHERS THEN
2542: IF g_debug <= gme_debug.g_log_unexpected THEN
2543: gme_debug.put_line('When others exception in Get_Dispensed_Lot_Count');
2544: END IF;
2545: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Get_Dispensed_Lot_Count');
2546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2539:
2540: EXCEPTION
2541: WHEN OTHERS THEN
2542: IF g_debug <= gme_debug.g_log_unexpected THEN
2543: gme_debug.put_line('When others exception in Get_Dispensed_Lot_Count');
2544: END IF;
2545: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Get_Dispensed_Lot_Count');
2546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2547: x_error_msg := fnd_message.get;

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

2601: x_return_status := FND_API.G_RET_STS_SUCCESS;
2602: x_error_msg := ' ';
2603:
2604: IF (g_debug IS NOT NULL) THEN
2605: gme_debug.log_initialize ('MobileQueryQtyTree');
2606: END IF;
2607:
2608: -- Clearing the quantity cache
2609: inv_quantity_tree_pub.clear_quantity_cache;

Line 2658: IF g_debug <= gme_debug.g_log_unexpected THEN

2654:
2655:
2656: EXCEPTION
2657: WHEN OTHERS THEN
2658: IF g_debug <= gme_debug.g_log_unexpected THEN
2659: gme_debug.put_line('When others exception in Query_Qty_Tree');
2660: END IF;
2661: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Qty_Tree');
2662:

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

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

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

2698: BEGIN
2699:
2700:
2701: IF (g_debug IS NOT NULL) THEN
2702: gme_debug.log_initialize ('MobileCreQtyTree');
2703: END IF;
2704:
2705: x_return_status := FND_API.G_RET_STS_SUCCESS;
2706: x_error_msg := ' ';

Line 2752: IF g_debug <= gme_debug.g_log_unexpected THEN

2748: END IF;
2749:
2750: EXCEPTION
2751: WHEN CREATE_TREE_ERROR THEN
2752: IF g_debug <= gme_debug.g_log_unexpected THEN
2753: gme_debug.put_line('Create Qty Tree exception');
2754: END IF;
2755:
2756: WHEN OTHERS THEN

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

2749:
2750: EXCEPTION
2751: WHEN CREATE_TREE_ERROR THEN
2752: IF g_debug <= gme_debug.g_log_unexpected THEN
2753: gme_debug.put_line('Create Qty Tree exception');
2754: END IF;
2755:
2756: WHEN OTHERS THEN
2757: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 2757: IF g_debug <= gme_debug.g_log_unexpected THEN

2753: gme_debug.put_line('Create Qty Tree exception');
2754: END IF;
2755:
2756: WHEN OTHERS THEN
2757: IF g_debug <= gme_debug.g_log_unexpected THEN
2758: gme_debug.put_line('When others exception in Create Qty Tree');
2759: END IF;
2760: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Create_Qty_Tree');
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2754: END IF;
2755:
2756: WHEN OTHERS THEN
2757: IF g_debug <= gme_debug.g_log_unexpected THEN
2758: gme_debug.put_line('When others exception in Create Qty Tree');
2759: END IF;
2760: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Create_Qty_Tree');
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2762: x_error_msg := fnd_message.get;

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

2802:
2803: BEGIN
2804:
2805: IF (g_debug IS NOT NULL) THEN
2806: gme_debug.log_initialize ('MobileQtyTree');
2807: END IF;
2808:
2809: x_return_status := FND_API.G_RET_STS_SUCCESS;
2810: x_error_msg := ' ';

Line 2844: IF g_debug <= gme_debug.g_log_unexpected THEN

2840: END IF;
2841:
2842: EXCEPTION
2843: WHEN QUERY_TREE_ERROR THEN
2844: IF g_debug <= gme_debug.g_log_unexpected THEN
2845: gme_debug.put_line('Query Qty Tree exception');
2846: END IF;
2847:
2848: WHEN OTHERS THEN

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

2841:
2842: EXCEPTION
2843: WHEN QUERY_TREE_ERROR THEN
2844: IF g_debug <= gme_debug.g_log_unexpected THEN
2845: gme_debug.put_line('Query Qty Tree exception');
2846: END IF;
2847:
2848: WHEN OTHERS THEN
2849: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 2849: IF g_debug <= gme_debug.g_log_unexpected THEN

2845: gme_debug.put_line('Query Qty Tree exception');
2846: END IF;
2847:
2848: WHEN OTHERS THEN
2849: IF g_debug <= gme_debug.g_log_unexpected THEN
2850: gme_debug.put_line('When others exception in Query_Tree');
2851: END IF;
2852: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Tree');
2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2846: END IF;
2847:
2848: WHEN OTHERS THEN
2849: IF g_debug <= gme_debug.g_log_unexpected THEN
2850: gme_debug.put_line('When others exception in Query_Tree');
2851: END IF;
2852: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Tree');
2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2854: x_error_msg := fnd_message.get;

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

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

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

2913: END IF;
2914:
2915: IF (p_primary_qty <> 0) THEN
2916:
2917: gme_debug.put_line('Tree id = '||p_tree_id);
2918: gme_debug.put_line('Qty = '||p_primary_qty);
2919: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
2920: gme_debug.put_line('lot = '||p_lot_number);
2921: gme_debug.put_line('Sub = '||p_subinventory_code);

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

2914:
2915: IF (p_primary_qty <> 0) THEN
2916:
2917: gme_debug.put_line('Tree id = '||p_tree_id);
2918: gme_debug.put_line('Qty = '||p_primary_qty);
2919: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
2920: gme_debug.put_line('lot = '||p_lot_number);
2921: gme_debug.put_line('Sub = '||p_subinventory_code);
2922: gme_debug.put_line('Locator id = '||p_locator_id);

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

2915: IF (p_primary_qty <> 0) THEN
2916:
2917: gme_debug.put_line('Tree id = '||p_tree_id);
2918: gme_debug.put_line('Qty = '||p_primary_qty);
2919: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
2920: gme_debug.put_line('lot = '||p_lot_number);
2921: gme_debug.put_line('Sub = '||p_subinventory_code);
2922: gme_debug.put_line('Locator id = '||p_locator_id);
2923: gme_debug.put_line('revision = '||p_revision);

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

2916:
2917: gme_debug.put_line('Tree id = '||p_tree_id);
2918: gme_debug.put_line('Qty = '||p_primary_qty);
2919: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
2920: gme_debug.put_line('lot = '||p_lot_number);
2921: gme_debug.put_line('Sub = '||p_subinventory_code);
2922: gme_debug.put_line('Locator id = '||p_locator_id);
2923: gme_debug.put_line('revision = '||p_revision);
2924:

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

2917: gme_debug.put_line('Tree id = '||p_tree_id);
2918: gme_debug.put_line('Qty = '||p_primary_qty);
2919: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
2920: gme_debug.put_line('lot = '||p_lot_number);
2921: gme_debug.put_line('Sub = '||p_subinventory_code);
2922: gme_debug.put_line('Locator id = '||p_locator_id);
2923: gme_debug.put_line('revision = '||p_revision);
2924:
2925: INV_Quantity_Tree_Grp.Update_Quantities(

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

2918: gme_debug.put_line('Qty = '||p_primary_qty);
2919: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
2920: gme_debug.put_line('lot = '||p_lot_number);
2921: gme_debug.put_line('Sub = '||p_subinventory_code);
2922: gme_debug.put_line('Locator id = '||p_locator_id);
2923: gme_debug.put_line('revision = '||p_revision);
2924:
2925: INV_Quantity_Tree_Grp.Update_Quantities(
2926: p_api_version_number => 1.0,

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

2919: gme_debug.put_line('Sec Qty = '||p_secondary_qty);
2920: gme_debug.put_line('lot = '||p_lot_number);
2921: gme_debug.put_line('Sub = '||p_subinventory_code);
2922: gme_debug.put_line('Locator id = '||p_locator_id);
2923: gme_debug.put_line('revision = '||p_revision);
2924:
2925: INV_Quantity_Tree_Grp.Update_Quantities(
2926: p_api_version_number => 1.0,
2927: p_init_msg_lst => 'T',

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

2950: x_satr => l_satr,
2951: p_containerized => 0,
2952: p_lpn_id => NULL);
2953:
2954: gme_debug.put_line('New ATT = '||l_att);
2955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2956: RAISE UPDATE_TREE_ERROR;
2957: END IF;
2958:

Line 2964: IF g_debug <= gme_debug.g_log_unexpected THEN

2960:
2961:
2962: EXCEPTION
2963: WHEN UPDATE_TREE_ERROR THEN
2964: IF g_debug <= gme_debug.g_log_unexpected THEN
2965: gme_debug.put_line('Update Qty Tree exception');
2966: END IF;
2967:
2968: WHEN OTHERS THEN

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

2961:
2962: EXCEPTION
2963: WHEN UPDATE_TREE_ERROR THEN
2964: IF g_debug <= gme_debug.g_log_unexpected THEN
2965: gme_debug.put_line('Update Qty Tree exception');
2966: END IF;
2967:
2968: WHEN OTHERS THEN
2969: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 2969: IF g_debug <= gme_debug.g_log_unexpected THEN

2965: gme_debug.put_line('Update Qty Tree exception');
2966: END IF;
2967:
2968: WHEN OTHERS THEN
2969: IF g_debug <= gme_debug.g_log_unexpected THEN
2970: gme_debug.put_line('When others exception in Update Qty Tree');
2971: END IF;
2972: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Update_Qty_Tree');
2973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2966: END IF;
2967:
2968: WHEN OTHERS THEN
2969: IF g_debug <= gme_debug.g_log_unexpected THEN
2970: gme_debug.put_line('When others exception in Update Qty Tree');
2971: END IF;
2972: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Update_Qty_Tree');
2973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2974: x_error_msg := fnd_message.get;

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

3064:
3065: BEGIN
3066:
3067: IF (g_debug IS NOT NULL) THEN
3068: gme_debug.log_initialize ('MobileValItemForIssue');
3069: gme_debug.put_line('Org Id = ' || p_organization_id);
3070: gme_debug.put_line('Batch Id = ' || p_batch_id);
3071: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3072: gme_debug.put_line('Item Id = ' || p_item_id);

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

3065: BEGIN
3066:
3067: IF (g_debug IS NOT NULL) THEN
3068: gme_debug.log_initialize ('MobileValItemForIssue');
3069: gme_debug.put_line('Org Id = ' || p_organization_id);
3070: gme_debug.put_line('Batch Id = ' || p_batch_id);
3071: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3072: gme_debug.put_line('Item Id = ' || p_item_id);
3073: END IF;

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

3066:
3067: IF (g_debug IS NOT NULL) THEN
3068: gme_debug.log_initialize ('MobileValItemForIssue');
3069: gme_debug.put_line('Org Id = ' || p_organization_id);
3070: gme_debug.put_line('Batch Id = ' || p_batch_id);
3071: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3072: gme_debug.put_line('Item Id = ' || p_item_id);
3073: END IF;
3074:

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

3067: IF (g_debug IS NOT NULL) THEN
3068: gme_debug.log_initialize ('MobileValItemForIssue');
3069: gme_debug.put_line('Org Id = ' || p_organization_id);
3070: gme_debug.put_line('Batch Id = ' || p_batch_id);
3071: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3072: gme_debug.put_line('Item Id = ' || p_item_id);
3073: END IF;
3074:
3075: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3068: gme_debug.log_initialize ('MobileValItemForIssue');
3069: gme_debug.put_line('Org Id = ' || p_organization_id);
3070: gme_debug.put_line('Batch Id = ' || p_batch_id);
3071: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3072: gme_debug.put_line('Item Id = ' || p_item_id);
3073: END IF;
3074:
3075: x_return_status := FND_API.G_RET_STS_SUCCESS;
3076: x_error_msg := ' ';

Line 3126: IF g_debug <= gme_debug.g_log_unexpected THEN

3122: x_return_status := FND_API.G_RET_STS_ERROR;
3123: x_error_msg := fnd_message.get;
3124:
3125: WHEN OTHERS THEN
3126: IF g_debug <= gme_debug.g_log_unexpected THEN
3127: gme_debug.put_line('When others exception in Validate Item To Issue');
3128: END IF;
3129: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Issue');
3130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3123: x_error_msg := fnd_message.get;
3124:
3125: WHEN OTHERS THEN
3126: IF g_debug <= gme_debug.g_log_unexpected THEN
3127: gme_debug.put_line('When others exception in Validate Item To Issue');
3128: END IF;
3129: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Issue');
3130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3131: x_error_msg := fnd_message.get;

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

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

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

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

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

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

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

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

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

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

Line 3193: IF g_debug <= gme_debug.g_log_unexpected THEN

3189: x_return_status := FND_API.G_RET_STS_ERROR;
3190: x_error_msg := fnd_message.get;
3191:
3192: WHEN OTHERS THEN
3193: IF g_debug <= gme_debug.g_log_unexpected THEN
3194: gme_debug.put_line('When others exception in Validate Item To Return');
3195: END IF;
3196: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Return');
3197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3190: x_error_msg := fnd_message.get;
3191:
3192: WHEN OTHERS THEN
3193: IF g_debug <= gme_debug.g_log_unexpected THEN
3194: gme_debug.put_line('When others exception in Validate Item To Return');
3195: END IF;
3196: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Return');
3197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3198: x_error_msg := fnd_message.get;

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

3239:
3240: BEGIN
3241:
3242: IF (g_debug IS NOT NULL) THEN
3243: gme_debug.log_initialize ('MobileValProdToYield');
3244: gme_debug.put_line('Org Id = ' || p_organization_id);
3245: gme_debug.put_line('Batch Id = ' || p_batch_id);
3246: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3247: gme_debug.put_line('Item Id = ' || p_item_id);

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

3240: BEGIN
3241:
3242: IF (g_debug IS NOT NULL) THEN
3243: gme_debug.log_initialize ('MobileValProdToYield');
3244: gme_debug.put_line('Org Id = ' || p_organization_id);
3245: gme_debug.put_line('Batch Id = ' || p_batch_id);
3246: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3247: gme_debug.put_line('Item Id = ' || p_item_id);
3248: END IF;

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

3241:
3242: IF (g_debug IS NOT NULL) THEN
3243: gme_debug.log_initialize ('MobileValProdToYield');
3244: gme_debug.put_line('Org Id = ' || p_organization_id);
3245: gme_debug.put_line('Batch Id = ' || p_batch_id);
3246: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3247: gme_debug.put_line('Item Id = ' || p_item_id);
3248: END IF;
3249:

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

3242: IF (g_debug IS NOT NULL) THEN
3243: gme_debug.log_initialize ('MobileValProdToYield');
3244: gme_debug.put_line('Org Id = ' || p_organization_id);
3245: gme_debug.put_line('Batch Id = ' || p_batch_id);
3246: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3247: gme_debug.put_line('Item Id = ' || p_item_id);
3248: END IF;
3249:
3250: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3243: gme_debug.log_initialize ('MobileValProdToYield');
3244: gme_debug.put_line('Org Id = ' || p_organization_id);
3245: gme_debug.put_line('Batch Id = ' || p_batch_id);
3246: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3247: gme_debug.put_line('Item Id = ' || p_item_id);
3248: END IF;
3249:
3250: x_return_status := FND_API.G_RET_STS_SUCCESS;
3251: x_error_msg := ' ';

Line 3296: IF g_debug <= gme_debug.g_log_unexpected THEN

3292: x_return_status := FND_API.G_RET_STS_ERROR;
3293: x_error_msg := fnd_message.get;
3294:
3295: WHEN OTHERS THEN
3296: IF g_debug <= gme_debug.g_log_unexpected THEN
3297: gme_debug.put_line('When others exception in Validate Prod To Yield');
3298: END IF;
3299: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Prod_To_Yield');
3300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3293: x_error_msg := fnd_message.get;
3294:
3295: WHEN OTHERS THEN
3296: IF g_debug <= gme_debug.g_log_unexpected THEN
3297: gme_debug.put_line('When others exception in Validate Prod To Yield');
3298: END IF;
3299: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Prod_To_Yield');
3300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3301: x_error_msg := fnd_message.get;

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

3328: l_date_format VARCHAR2(100);
3329: BEGIN
3330:
3331: IF (g_debug IS NOT NULL) THEN
3332: gme_debug.log_initialize ('MobileFetchIssueTxn');
3333: END IF;
3334:
3335: x_return_status := FND_API.G_RET_STS_SUCCESS;
3336: x_error_msg := ' ';

Line 3371: IF g_debug <= gme_debug.g_log_unexpected THEN

3367: AND lc.inventory_location_id(+) = m.locator_id;
3368:
3369: EXCEPTION
3370: WHEN OTHERS THEN
3371: IF g_debug <= gme_debug.g_log_unexpected THEN
3372: gme_debug.put_line('When others exception in fetch Issue Transactions');
3373: END IF;
3374: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_issue_transactions');
3375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3368:
3369: EXCEPTION
3370: WHEN OTHERS THEN
3371: IF g_debug <= gme_debug.g_log_unexpected THEN
3372: gme_debug.put_line('When others exception in fetch Issue Transactions');
3373: END IF;
3374: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_issue_transactions');
3375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3376: x_error_msg := fnd_message.get;

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

3405: l_txn_type_id NUMBER;
3406: BEGIN
3407:
3408: IF (g_debug IS NOT NULL) THEN
3409: gme_debug.log_initialize ('MobileFetchYieldTxn');
3410: END IF;
3411:
3412: x_return_status := FND_API.G_RET_STS_SUCCESS;
3413: x_error_msg := ' ';

Line 3450: IF g_debug <= gme_debug.g_log_unexpected THEN

3446: AND lc.inventory_location_id(+) = m.locator_id;
3447:
3448: EXCEPTION
3449: WHEN OTHERS THEN
3450: IF g_debug <= gme_debug.g_log_unexpected THEN
3451: gme_debug.put_line('When others exception in fetch yield Transactions');
3452: END IF;
3453: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_yield_transactions');
3454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3447:
3448: EXCEPTION
3449: WHEN OTHERS THEN
3450: IF g_debug <= gme_debug.g_log_unexpected THEN
3451: gme_debug.put_line('When others exception in fetch yield Transactions');
3452: END IF;
3453: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_yield_transactions');
3454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3455: x_error_msg := fnd_message.get;

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

3497: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
3498: BEGIN
3499:
3500: IF (g_debug IS NOT NULL) THEN
3501: gme_debug.log_initialize ('MobileCreatePhantomTxn');
3502: END IF;
3503:
3504: --Initially let us assign the return status to success
3505: x_return_status := fnd_api.g_ret_sts_success;

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

3503:
3504: --Initially let us assign the return status to success
3505: x_return_status := fnd_api.g_ret_sts_success;
3506:
3507: IF (g_debug <= gme_debug.g_log_statement) THEN
3508: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3509: || 'Entering');
3510: END IF;
3511:

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

3504: --Initially let us assign the return status to success
3505: x_return_status := fnd_api.g_ret_sts_success;
3506:
3507: IF (g_debug <= gme_debug.g_log_statement) THEN
3508: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3509: || 'Entering');
3510: END IF;
3511:
3512: OPEN cur_get_transaction(p_mmti_trans_id);

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

3556: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3557: RAISE fnd_api.g_exc_error;
3558: END IF;
3559:
3560: IF (g_debug <= gme_debug.g_log_statement) THEN
3561: gme_debug.put_line ( g_pkg_name
3562: || '.'
3563: || l_api_name
3564: || ':'

Line 3561: gme_debug.put_line ( g_pkg_name

3557: RAISE fnd_api.g_exc_error;
3558: END IF;
3559:
3560: IF (g_debug <= gme_debug.g_log_statement) THEN
3561: gme_debug.put_line ( g_pkg_name
3562: || '.'
3563: || l_api_name
3564: || ':'
3565: || 'Exiting with '

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

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

Line 3582: gme_debug.put_line ( g_pkg_name

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

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

4136: l_count NUMBER;
4137: l_date_format VARCHAR2(100);
4138: BEGIN
4139: IF (g_debug IS NOT NULL) THEN
4140: gme_debug.log_initialize ('RelieveRsrvPndLots');
4141: END IF;
4142:
4143: x_return_status := fnd_api.g_ret_sts_success;
4144: x_error_msg := ' ';

Line 4170: IF g_debug <= gme_debug.g_log_unexpected THEN

4166: x_trans_date := TO_CHAR(l_trans_date,l_date_format||HOUR_MIN_SEC_FORMAT_STRING);
4167:
4168: EXCEPTION
4169: WHEN OTHERS THEN
4170: IF g_debug <= gme_debug.g_log_unexpected THEN
4171: gme_debug.put_line('When others exception in fetch_txn_date');
4172: END IF;
4173: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_txn_date');
4174: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4167:
4168: EXCEPTION
4169: WHEN OTHERS THEN
4170: IF g_debug <= gme_debug.g_log_unexpected THEN
4171: gme_debug.put_line('When others exception in fetch_txn_date');
4172: END IF;
4173: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_txn_date');
4174: x_return_status := fnd_api.g_ret_sts_unexp_error;
4175: x_error_msg := fnd_message.get;

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

4309: AND m.batch_id = p_batch_id
4310: AND m.material_Detail_id = p_material_detail_id;
4311: BEGIN
4312: IF (g_debug IS NOT NULL) THEN
4313: gme_debug.log_initialize ('MobileFetchSubinvLoc');
4314: END IF;
4315:
4316:
4317: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4326: IF g_debug <= gme_debug.g_log_unexpected THEN

4322: CLOSE c_subinv_loc;
4323:
4324: EXCEPTION
4325: WHEN OTHERS THEN
4326: IF g_debug <= gme_debug.g_log_unexpected THEN
4327: gme_debug.put_line('When others exception in Fetch_subinv_locator');
4328: END IF;
4329: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Fetch_subinv_locator');
4330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4323:
4324: EXCEPTION
4325: WHEN OTHERS THEN
4326: IF g_debug <= gme_debug.g_log_unexpected THEN
4327: gme_debug.put_line('When others exception in Fetch_subinv_locator');
4328: END IF;
4329: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Fetch_subinv_locator');
4330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4331: x_error_msg := fnd_message.get;

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

4346:
4347: BEGIN
4348: x_return_status := FND_API.G_RET_STS_SUCCESS;
4349: IF (g_debug IS NOT NULL) THEN
4350: gme_debug.log_initialize ('MobileGetExpDate');
4351: END IF;
4352:
4353: l_mti_txn_tbl := inv_calculate_exp_date.get_mti_tbl;
4354: IF l_mti_txn_tbl.COUNT > 0 THEN

Line 4367: IF g_debug <= gme_debug.g_log_statement THEN

4363: ,x_return_status => x_return_status);
4364:
4365: inv_calculate_exp_date.purge_mti_tab;
4366: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4367: IF g_debug <= gme_debug.g_log_statement THEN
4368: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4369: END IF;
4370: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4371: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');

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

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

Line 4376: gme_debug.put_line('l_lot_expiration_date '||l_lot_expiration_date);

4372: fnd_msg_pub.ADD;
4373: RAISE fnd_api.g_exc_unexpected_error;
4374: END IF;
4375: IF g_debug = 1 THEN
4376: gme_debug.put_line('l_lot_expiration_date '||l_lot_expiration_date);
4377: END IF;
4378: x_expiration_date := l_lot_expiration_date;
4379: -- ELSE
4380: -- x_expiration_date := x_origination_date + l_get_dft_attr_rec.shelf_life_days;

Line 4385: IF g_debug <= gme_debug.g_log_unexpected THEN

4381: END IF;
4382: EXCEPTION
4383: WHEN OTHERS THEN
4384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4385: IF g_debug <= gme_debug.g_log_unexpected THEN
4386: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);
4387: END IF;
4388: END get_expiration_date;
4389:

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

4382: EXCEPTION
4383: WHEN OTHERS THEN
4384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4385: IF g_debug <= gme_debug.g_log_unexpected THEN
4386: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);
4387: END IF;
4388: END get_expiration_date;
4389:
4390: PROCEDURE get_exp_action_date (

Line 4407: IF g_debug <= gme_debug.g_log_unexpected THEN

4403:
4404: EXCEPTION
4405: WHEN OTHERS THEN
4406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4407: IF g_debug <= gme_debug.g_log_unexpected THEN
4408: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);
4409: END IF;
4410: END get_exp_action_date;
4411: -- nsinghi bug#5209065 END.

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

4404: EXCEPTION
4405: WHEN OTHERS THEN
4406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4407: IF g_debug <= gme_debug.g_log_unexpected THEN
4408: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);
4409: END IF;
4410: END get_exp_action_date;
4411: -- nsinghi bug#5209065 END.
4412: