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_POST_MIGRATION dependencies on GMA_COMMON_LOGGING

Line 444: gma_common_logging.gma_migration_central_log

440: ROLLBACK;
441: OPEN Cur_item_mst(l_item_id);
442: FETCH Cur_item_mst INTO l_item_no;
443: CLOSE Cur_item_mst;
444: gma_common_logging.gma_migration_central_log
445: (p_run_id => g_migration_run_id,
446: p_log_level => fnd_log.level_error,
447: p_message_token => 'INV_IC_INVALID_ITEM_ORG',
448: p_table_name => 'GME_BATCH_HEADER',

Line 459: gma_common_logging.gma_migration_central_log

455: WHEN setup_failed OR calc_mtl_req_date_err OR create_mo_hdr_err OR create_mo_line_err THEN
456: ROLLBACK;
457: gme_common_pvt.count_and_get(x_count => l_msg_count
458: ,x_data => l_msg_data);
459: gma_common_logging.gma_migration_central_log
460: (p_run_id => g_migration_run_id,
461: p_log_level => fnd_log.level_error,
462: p_message_token => 'GME_BATCH_MIG_FAILED',
463: p_table_name => 'GME_BATCH_HEADER',

Line 475: gma_common_logging.gma_migration_central_log

471: IF (g_debug <= gme_debug.g_log_unexpected) THEN
472: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
473: END IF;
474: ROLLBACK;
475: gma_common_logging.gma_migration_central_log
476: (p_run_id => g_migration_run_id,
477: p_log_level => fnd_log.level_error,
478: p_message_token => 'GME_BATCH_MIG_FAILED',
479: p_table_name => 'GME_BATCH_HEADER',

Line 542: gma_common_logging.gma_migration_central_log

538: WHEN OTHERS THEN
539: IF (g_debug <= gme_debug.g_log_unexpected) THEN
540: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
541: END IF;
542: gma_common_logging.gma_migration_central_log
543: (p_run_id => g_migration_run_id,
544: p_log_level => fnd_log.level_unexpected,
545: p_message_token => 'GMA_MIGRATION_DB_ERROR',
546: p_table_name => 'GME_BATCH_HEADER',

Line 1446: gma_common_logging.gma_migration_central_log

1442: WHERE material_detail_id = l_new_prod_line_id;
1443: EXCEPTION
1444: WHEN new_phant_batch_not_found THEN
1445: ROLLBACK;
1446: gma_common_logging.gma_migration_central_log
1447: (p_run_id => g_migration_run_id,
1448: p_log_level => fnd_log.level_error,
1449: p_message_token => 'GME_PHANT_BATCH_NOT_FOUND',
1450: p_table_name => 'GME_BATCH_HEADER',

Line 1457: gma_common_logging.gma_migration_central_log

1453: p_token1 => 'BATCH_NO',
1454: p_param1 => get_phantoms.plant_code||'-'||get_phantoms.new_batch_no);
1455: WHEN new_phant_prod_not_found THEN
1456: ROLLBACK;
1457: gma_common_logging.gma_migration_central_log
1458: (p_run_id => g_migration_run_id,
1459: p_log_level => fnd_log.level_error,
1460: p_message_token => 'GME_PHANTOM_PROD_NOT_FOUND',
1461: p_table_name => 'GME_BATCH_HEADER',

Line 1471: gma_common_logging.gma_migration_central_log

1467: IF (g_debug <= gme_debug.g_log_unexpected) THEN
1468: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
1469: END IF;
1470: ROLLBACK;
1471: gma_common_logging.gma_migration_central_log
1472: (p_run_id => g_migration_run_id,
1473: p_log_level => fnd_log.level_error,
1474: p_message_token => 'GME_PHANT_BATCH_UNEXPECTED',
1475: p_table_name => 'GME_BATCH_HEADER',

Line 1637: gma_common_logging.gma_migration_central_log

1633: EXCEPTION
1634: WHEN inv_phantoms_found THEN
1635: NULL;
1636: WHEN no_open_period_err THEN
1637: gma_common_logging.gma_migration_central_log
1638: (p_run_id => g_migration_run_id,
1639: p_log_level => fnd_log.level_error,
1640: p_message_token => 'GME_NO_OPEN_PERIODS_STEP',
1641: p_table_name => 'GME_BATCH_HEADER',

Line 1649: gma_common_logging.gma_migration_central_log

1645: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,
1646: p_token2 => 'STEP_NO',
1647: p_param2 => get_steps.batchstep_no);
1648: WHEN step_cmplt_err THEN
1649: gma_common_logging.gma_migration_central_log
1650: (p_run_id => g_migration_run_id,
1651: p_log_level => fnd_log.level_error,
1652: p_message_token => 'GME_STEP_CMPLT_ERR',
1653: p_table_name => 'GME_BATCH_HEADER',

Line 1663: gma_common_logging.gma_migration_central_log

1659: p_param2 => get_steps.batchstep_no,
1660: p_token3 => 'MSG',
1661: p_param3 => l_msg_data);
1662: WHEN step_release_err THEN
1663: gma_common_logging.gma_migration_central_log
1664: (p_run_id => g_migration_run_id,
1665: p_log_level => fnd_log.level_error,
1666: p_message_token => 'GME_STEP_RELEASE_ERR',
1667: p_table_name => 'GME_BATCH_HEADER',

Line 1680: gma_common_logging.gma_migration_central_log

1676: WHEN OTHERS THEN
1677: IF (g_debug <= gme_debug.g_log_unexpected) THEN
1678: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
1679: END IF;
1680: gma_common_logging.gma_migration_central_log
1681: (p_run_id => g_migration_run_id,
1682: p_log_level => fnd_log.level_error,
1683: p_message_token => 'GME_STEP_PROCESS_UNEXP',
1684: p_table_name => 'GME_BATCH_HEADER',

Line 1697: gma_common_logging.gma_migration_central_log

1693: END;
1694: END LOOP;
1695: EXCEPTION
1696: WHEN no_open_period_err THEN
1697: gma_common_logging.gma_migration_central_log
1698: (p_run_id => g_migration_run_id,
1699: p_log_level => fnd_log.level_error,
1700: p_message_token => 'GME_NO_OPEN_PERIODS_BATCH',
1701: p_table_name => 'GME_BATCH_HEADER',

Line 1709: gma_common_logging.gma_migration_central_log

1705: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no);
1706: WHEN release_batch_err THEN
1707: gme_common_pvt.count_and_get(x_count => l_msg_cnt
1708: ,x_data => l_msg_data);
1709: gma_common_logging.gma_migration_central_log
1710: (p_run_id => g_migration_run_id,
1711: p_log_level => fnd_log.level_error,
1712: p_message_token => 'GME_BATCH_RELEASE_ERR',
1713: p_table_name => 'GME_BATCH_HEADER',

Line 1724: gma_common_logging.gma_migration_central_log

1720: WHEN OTHERS THEN
1721: IF (g_debug <= gme_debug.g_log_unexpected) THEN
1722: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
1723: END IF;
1724: gma_common_logging.gma_migration_central_log
1725: (p_run_id => g_migration_run_id,
1726: p_log_level => fnd_log.level_error,
1727: p_message_token => 'GME_BATCH_PROCESS_UNEXP',
1728: p_table_name => 'GME_BATCH_HEADER',

Line 2163: gma_common_logging.gma_migration_central_log

2159: l_mmti_rec.reason_id := get_reason(l_txns_tbl(i).reason_code);
2160: IF (l_txns_tbl(i).reason_code IS NOT NULL AND l_mmti_rec.reason_id IS NULL) THEN
2161: l_txn_data := l_mtl_rec.item_no||'->'||l_txns_tbl(i).whse_code||'->'||l_txns_tbl(i).location||'->'||
2162: l_txns_tbl(i).lot_id||'->'||l_txns_tbl(i).trans_qty||'->'||l_mtl_rec.primary_uom_code||'->'||to_char(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
2163: gma_common_logging.gma_migration_central_log
2164: (p_run_id => g_migration_run_id,
2165: p_log_level => fnd_log.level_error,
2166: p_message_token => 'GME_MIG_REASON_NOT_FOUND',
2167: p_table_name => 'GME_BATCH_HEADER',

Line 2713: gma_common_logging.gma_migration_central_log

2709: EXCEPTION
2710: WHEN setup_failed OR batch_fetch_err THEN
2711: gme_common_pvt.count_and_get(x_count => l_msg_cnt
2712: ,x_data => l_msg_data);
2713: gma_common_logging.gma_migration_central_log
2714: (p_run_id => g_migration_run_id,
2715: p_log_level => fnd_log.level_error,
2716: p_message_token => 'GME_TXNS_MIG_FAILED',
2717: p_table_name => 'GME_BATCH_HEADER',

Line 2730: gma_common_logging.gma_migration_central_log

2726: l_txn_data := l_mtl_rec.item_no||'->'||l_txns_tbl(i).whse_code||'->'||l_txns_tbl(i).location||'->'||
2727: l_txns_tbl(i).lot_id||'->'||l_txns_tbl(i).trans_qty||'->'||l_mtl_rec.primary_uom_code||'->'||to_char(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
2728: gme_common_pvt.count_and_get(x_count => l_msg_cnt
2729: ,x_data => l_msg_data);
2730: gma_common_logging.gma_migration_central_log
2731: (p_run_id => g_migration_run_id,
2732: p_log_level => fnd_log.level_error,
2733: p_message_token => 'GME_GENERAL_TXN_FAIL',
2734: p_table_name => 'GME_BATCH_HEADER',

Line 2747: gma_common_logging.gma_migration_central_log

2743: ROLLBACK;
2744: WHEN defined_error THEN
2745: l_txn_data := l_mtl_rec.item_no||'->'||l_txns_tbl(i).whse_code||'->'||l_txns_tbl(i).location||'->'||
2746: l_txns_tbl(i).lot_id||'->'||l_txns_tbl(i).trans_qty||'->'||l_mtl_rec.primary_uom_code||'->'||to_char(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
2747: gma_common_logging.gma_migration_central_log
2748: (p_run_id => g_migration_run_id,
2749: p_log_level => fnd_log.level_error,
2750: p_message_token => l_msg_name,
2751: p_table_name => 'GME_BATCH_HEADER',

Line 2764: gma_common_logging.gma_migration_central_log

2760: ROLLBACK;
2761: WHEN uom_conversion_fail THEN
2762: l_txn_data := l_mtl_rec.item_no||'->'||l_txns_tbl(i).whse_code||'->'||l_txns_tbl(i).location||'->'||
2763: l_txns_tbl(i).lot_id||'->'||l_txns_tbl(i).trans_qty||'->'||l_mtl_rec.primary_uom_code||'->'||TO_CHAR(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
2764: gma_common_logging.gma_migration_central_log
2765: (p_run_id => g_migration_run_id,
2766: p_log_level => fnd_log.level_error,
2767: p_message_token => 'GME_MIG_UOM_CONV_FAIL',
2768: p_table_name => 'GME_BATCH_HEADER',

Line 2788: gma_common_logging.gma_migration_central_log

2784: ,x_count => l_msg_cnt
2785: ,x_data => l_msg_data);
2786: l_txn_data := l_mtl_rec.item_no||'->'||l_txns_tbl(i).whse_code||'->'||l_txns_tbl(i).location||'->'||
2787: l_txns_tbl(i).lot_id||'->'||l_txns_tbl(i).trans_qty||'->'||l_mtl_rec.primary_uom_code||'->'||TO_CHAR(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
2788: gma_common_logging.gma_migration_central_log
2789: (p_run_id => g_migration_run_id,
2790: p_log_level => fnd_log.level_error,
2791: p_message_token => l_msg_name,
2792: p_table_name => 'GME_BATCH_HEADER',

Line 2812: gma_common_logging.gma_migration_central_log

2808: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
2809: END IF;
2810: l_txn_data := l_mtl_rec.item_no||'->'||l_txns_tbl(i).whse_code||'->'||l_txns_tbl(i).location||'->'||
2811: l_txns_tbl(i).lot_id||'->'||l_txns_tbl(i).trans_qty||'->'||l_mtl_rec.primary_uom_code||'->'||TO_CHAR(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
2812: gma_common_logging.gma_migration_central_log
2813: (p_run_id => g_migration_run_id,
2814: p_log_level => fnd_log.level_error,
2815: p_message_token => 'GME_GENERAL_TXN_FAIL',
2816: p_table_name => 'GME_BATCH_HEADER',

Line 2904: gma_common_logging.gma_migration_central_log

2900: l_txn_data := p_item_no||'->'||p_txn_rec.whse_code||'->'||p_txn_rec.location||'->'||p_txn_rec.lot_id||'->'||p_txn_rec.trans_qty||'->'||p_txn_rec.trans_um||'->'||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
2901: IF (g_debug <= gme_debug.g_log_statement) THEN
2902: gme_debug.put_line('TXN Data = '||l_txn_data);
2903: END IF;
2904: gma_common_logging.gma_migration_central_log
2905: (p_run_id => g_migration_run_id,
2906: p_log_level => fnd_log.level_error,
2907: p_message_token => 'GME_MIG_INV_TRANSFER',
2908: p_table_name => 'GME_BATCH_HEADER',

Line 3190: gma_common_logging.gma_migration_central_log

3186: gme_debug.put_line('End procedure '||l_api_name);
3187: END IF;
3188: EXCEPTION
3189: WHEN item_not_defined THEN
3190: gma_common_logging.gma_migration_central_log
3191: (p_run_id => g_migration_run_id,
3192: p_log_level => fnd_log.level_error,
3193: p_message_token => 'INV_IC_INVALID_ITEM_ORG',
3194: p_table_name => 'GME_BATCH_HEADER',

Line 3206: gma_common_logging.gma_migration_central_log

3202: WHEN no_open_period_err THEN
3203: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
3204: ,x_count => l_msg_cnt
3205: ,x_data => l_msg_data);
3206: gma_common_logging.gma_migration_central_log
3207: (p_run_id => g_migration_run_id,
3208: p_log_level => fnd_log.level_error,
3209: p_message_token => 'GME_GENERAL_TXN_FAIL',
3210: p_table_name => 'GME_BATCH_HEADER',

Line 3226: gma_common_logging.gma_migration_central_log

3222: p_txn_rec.trans_qty||'->'||l_item_rec.primary_uom_code||'->'||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
3223: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
3224: ,x_count => l_msg_cnt
3225: ,x_data => l_msg_data);
3226: gma_common_logging.gma_migration_central_log
3227: (p_run_id => g_migration_run_id,
3228: p_log_level => fnd_log.level_error,
3229: p_message_token => 'GME_GENERAL_TXN_FAIL',
3230: p_table_name => 'GME_BATCH_HEADER',

Line 3242: gma_common_logging.gma_migration_central_log

3238: p_param3 => l_txn_data);
3239: x_return_status := l_return_status;
3240: WHEN defined_error THEN
3241: l_txn_data := p_item_no||'->'||p_txn_rec.whse_code||'->'||p_txn_rec.location||'->'||p_txn_rec.lot_id||'->'||p_txn_rec.trans_qty||'->'||l_item_rec.primary_uom_code||'->'||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
3242: gma_common_logging.gma_migration_central_log
3243: (p_run_id => g_migration_run_id,
3244: p_log_level => fnd_log.level_error,
3245: p_message_token => l_msg_name,
3246: p_table_name => 'GME_BATCH_HEADER',

Line 3262: gma_common_logging.gma_migration_central_log

3258: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
3259: END IF;
3260: l_txn_data := p_item_no||'->'||p_txn_rec.whse_code||'->'||p_txn_rec.location||'->'||p_txn_rec.lot_id||'->'||p_txn_rec.trans_qty||'->'||l_item_rec.primary_uom_code||'->'||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3262: gma_common_logging.gma_migration_central_log
3263: (p_run_id => g_migration_run_id,
3264: p_log_level => fnd_log.level_error,
3265: p_message_token => 'GME_GENERAL_TXN_FAIL',
3266: p_table_name => 'GME_BATCH_HEADER',

Line 3305: gma_common_logging.gma_migration_central_log

3301: IF (g_debug <= gme_debug.g_log_unexpected) THEN
3302: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
3303: END IF;
3304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3305: gma_common_logging.gma_migration_central_log
3306: (p_run_id => g_migration_run_id,
3307: p_log_level => fnd_log.level_unexpected,
3308: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3309: p_table_name => 'GME_BATCH_HEADER',

Line 3378: gma_common_logging.gma_migration_central_log

3374: CLOSE Cur_verify_txns;
3375: END IF;
3376: EXCEPTION
3377: WHEN step_close_fail THEN
3378: gma_common_logging.gma_migration_central_log
3379: (p_run_id => g_migration_run_id,
3380: p_log_level => fnd_log.level_error,
3381: p_message_token => 'GME_STEP_CLOSE_ERR',
3382: p_table_name => 'GME_BATCH_HEADER',

Line 3395: gma_common_logging.gma_migration_central_log

3391: WHEN OTHERS THEN
3392: IF (g_debug <= gme_debug.g_log_unexpected) THEN
3393: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
3394: END IF;
3395: gma_common_logging.gma_migration_central_log
3396: (p_run_id => g_migration_run_id,
3397: p_log_level => fnd_log.level_error,
3398: p_message_token => 'GME_STEP_PROCESS_UNEXP',
3399: p_table_name => 'GME_BATCH_HEADER',

Line 3519: gma_common_logging.gma_migration_central_log

3515: EXCEPTION
3516: WHEN batch_fetch_err THEN
3517: gme_common_pvt.count_and_get(x_count => l_msg_cnt
3518: ,x_data => l_msg_data);
3519: gma_common_logging.gma_migration_central_log
3520: (p_run_id => g_migration_run_id,
3521: p_log_level => fnd_log.level_error,
3522: p_message_token => 'GME_TXNS_MIG_FAILED',
3523: p_table_name => 'GME_BATCH_HEADER',

Line 3537: gma_common_logging.gma_migration_central_log

3533: ,x_count => l_msg_cnt
3534: ,x_data => l_msg_data);
3535: l_txn_data := l_item_rec.segment1||'->'||get_lots.lot_id||'->'||get_lots.qty||'->'||get_lots.qty2;
3536: l_new_data := l_item_rec.segment1||'->'||l_lot_number||'->'||get_lots.qty||'->'||get_lots.qty2;
3537: gma_common_logging.gma_migration_central_log
3538: (p_run_id => g_migration_run_id,
3539: p_log_level => fnd_log.level_error,
3540: p_message_token => 'GME_CREATE_PPLOT_FAIL',
3541: p_table_name => 'GME_BATCH_HEADER',

Line 3560: gma_common_logging.gma_migration_central_log

3556: IF (g_debug <= gme_debug.g_log_unexpected) THEN
3557: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
3558: END IF;
3559: l_txn_data := l_item_rec.segment1||'->'||get_lots.lot_id||'->'||get_lots.qty||'->'||get_lots.qty2;
3560: gma_common_logging.gma_migration_central_log
3561: (p_run_id => g_migration_run_id,
3562: p_log_level => fnd_log.level_error,
3563: p_message_token => 'GME_TXNS_MIG_FAILED',
3564: p_table_name => 'GME_BATCH_HEADER',