DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on FND_LOG

Line 446: p_log_level => fnd_log.level_error,

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',
449: p_context => 'RECREATE_OPEN_BATCHES',
450: p_app_short_name => 'INV',

Line 461: p_log_level => fnd_log.level_error,

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',
464: p_context => 'RECREATE_OPEN_BATCHES',
465: p_app_short_name => 'GME',

Line 477: p_log_level => fnd_log.level_error,

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',
480: p_context => 'RECREATE_OPEN_BATCHES',
481: p_app_short_name => 'GME',

Line 544: p_log_level => fnd_log.level_unexpected,

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',
547: p_context => 'RECREATE_OPEN_BATCHES',
548: p_db_error => SQLERRM,

Line 1448: p_log_level => fnd_log.level_error,

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',
1451: p_context => 'RECREATE_OPEN_BATCHES',
1452: p_app_short_name => 'GME',

Line 1459: p_log_level => fnd_log.level_error,

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',
1462: p_context => 'RECREATE_OPEN_BATCHES',
1463: p_app_short_name => 'GME',

Line 1473: p_log_level => fnd_log.level_error,

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',
1476: p_context => 'RECREATE_OPEN_BATCHES',
1477: p_app_short_name => 'GME',

Line 1639: p_log_level => fnd_log.level_error,

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',
1642: p_context => 'RECREATE_OPEN_BATCHES',
1643: p_app_short_name => 'GME',

Line 1651: p_log_level => fnd_log.level_error,

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',
1654: p_context => 'RECREATE_OPEN_BATCHES',
1655: p_app_short_name => 'GME',

Line 1665: p_log_level => fnd_log.level_error,

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',
1668: p_context => 'RECREATE_OPEN_BATCHES',
1669: p_app_short_name => 'GME',

Line 1682: p_log_level => fnd_log.level_error,

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',
1685: p_context => 'RECREATE_OPEN_BATCHES',
1686: p_app_short_name => 'GME',

Line 1699: p_log_level => fnd_log.level_error,

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',
1702: p_context => 'RECREATE_OPEN_BATCHES',
1703: p_app_short_name => 'GME',

Line 1711: p_log_level => fnd_log.level_error,

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',
1714: p_context => 'RECREATE_OPEN_BATCHES',
1715: p_app_short_name => 'GME',

Line 1726: p_log_level => fnd_log.level_error,

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',
1729: p_context => 'RECREATE_OPEN_BATCHES',
1730: p_app_short_name => 'GME',

Line 2165: p_log_level => fnd_log.level_error,

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',
2168: p_context => 'RECREATE_OPEN_BATCHES',
2169: p_app_short_name => 'GME',

Line 2715: p_log_level => fnd_log.level_error,

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',
2718: p_context => 'RECREATE_OPEN_BATCHES',
2719: p_app_short_name => 'GME',

Line 2732: p_log_level => fnd_log.level_error,

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',
2735: p_context => 'RECREATE_OPEN_BATCHES',
2736: p_app_short_name => 'GME',

Line 2749: p_log_level => fnd_log.level_error,

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',
2752: p_context => 'RECREATE_OPEN_BATCHES',
2753: p_app_short_name => 'GME',

Line 2766: p_log_level => fnd_log.level_error,

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',
2769: p_context => 'RECREATE_OPEN_BATCHES',
2770: p_app_short_name => 'GME',

Line 2790: p_log_level => fnd_log.level_error,

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',
2793: p_context => 'RECREATE_OPEN_BATCHES',
2794: p_app_short_name => 'GME',

Line 2814: p_log_level => fnd_log.level_error,

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',
2817: p_context => 'RECREATE_OPEN_BATCHES',
2818: p_app_short_name => 'GME',

Line 2906: p_log_level => fnd_log.level_error,

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',
2909: p_context => 'RECREATE_OPEN_BATCHES',
2910: p_app_short_name => 'GME',

Line 3192: p_log_level => fnd_log.level_error,

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',
3195: p_context => 'RECREATE_OPEN_BATCHES',
3196: p_app_short_name => 'INV',

Line 3208: p_log_level => fnd_log.level_error,

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',
3211: p_context => 'RECREATE_OPEN_BATCHES',
3212: p_app_short_name => 'GME',

Line 3228: p_log_level => fnd_log.level_error,

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',
3231: p_context => 'RECREATE_OPEN_BATCHES',
3232: p_app_short_name => 'GME',

Line 3244: p_log_level => fnd_log.level_error,

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',
3247: p_context => 'RECREATE_OPEN_BATCHES',
3248: p_app_short_name => 'GME',

Line 3264: p_log_level => fnd_log.level_error,

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',
3267: p_context => 'RECREATE_OPEN_BATCHES',
3268: p_app_short_name => 'GME',

Line 3307: p_log_level => fnd_log.level_unexpected,

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',
3310: p_context => 'RECREATE_OPEN_BATCHES',
3311: p_db_error => SQLERRM,

Line 3380: p_log_level => fnd_log.level_error,

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',
3383: p_context => 'RECREATE_OPEN_BATCHES',
3384: p_app_short_name => 'GME',

Line 3397: p_log_level => fnd_log.level_error,

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',
3400: p_context => 'RECREATE_OPEN_BATCHES',
3401: p_app_short_name => 'GME',

Line 3521: p_log_level => fnd_log.level_error,

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',
3524: p_context => 'RECREATE_OPEN_BATCHES',
3525: p_app_short_name => 'GME',

Line 3539: p_log_level => fnd_log.level_error,

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',
3542: p_context => 'RECREATE_OPEN_BATCHES',
3543: p_app_short_name => 'GME',

Line 3562: p_log_level => fnd_log.level_error,

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',
3565: p_context => 'RECREATE_OPEN_BATCHES',
3566: p_app_short_name => 'GME',