DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on FND_LOG

Line 557: p_log_level => fnd_log.level_error,

553: FETCH Cur_item_mst INTO l_item_no;
554: CLOSE Cur_item_mst;
555: gma_common_logging.gma_migration_central_log
556: (p_run_id => g_migration_run_id,
557: p_log_level => fnd_log.level_error,
558: p_message_token => 'INV_IC_INVALID_ITEM_ORG',
559: p_table_name => 'GME_BATCH_HEADER',
560: p_context => 'RECREATE_OPEN_BATCHES',
561: p_app_short_name => 'INV',

Line 572: p_log_level => fnd_log.level_error,

568: gme_common_pvt.count_and_get(x_count => l_msg_count
569: ,x_data => l_msg_data);
570: gma_common_logging.gma_migration_central_log
571: (p_run_id => g_migration_run_id,
572: p_log_level => fnd_log.level_error,
573: p_message_token => 'GME_BATCH_MIG_FAILED',
574: p_table_name => 'GME_BATCH_HEADER',
575: p_context => 'RECREATE_OPEN_BATCHES',
576: p_app_short_name => 'GME',

Line 588: p_log_level => fnd_log.level_error,

584: END IF;
585: ROLLBACK;
586: gma_common_logging.gma_migration_central_log
587: (p_run_id => g_migration_run_id,
588: p_log_level => fnd_log.level_error,
589: p_message_token => 'GME_BATCH_MIG_FAILED',
590: p_table_name => 'GME_BATCH_HEADER',
591: p_context => 'RECREATE_OPEN_BATCHES',
592: p_app_short_name => 'GME',

Line 666: p_log_level => fnd_log.level_unexpected,

662: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
663: END IF;
664: gma_common_logging.gma_migration_central_log
665: (p_run_id => g_migration_run_id,
666: p_log_level => fnd_log.level_unexpected,
667: p_message_token => 'GMA_MIGRATION_DB_ERROR',
668: p_table_name => 'GME_BATCH_HEADER',
669: p_context => 'RECREATE_OPEN_BATCHES',
670: p_db_error => SQLERRM,

Line 1582: p_log_level => fnd_log.level_error,

1578: WHEN new_phant_batch_not_found THEN
1579: ROLLBACK;
1580: gma_common_logging.gma_migration_central_log
1581: (p_run_id => g_migration_run_id,
1582: p_log_level => fnd_log.level_error,
1583: p_message_token => 'GME_PHANT_BATCH_NOT_FOUND',
1584: p_table_name => 'GME_BATCH_HEADER',
1585: p_context => 'RECREATE_OPEN_BATCHES',
1586: p_app_short_name => 'GME',

Line 1593: p_log_level => fnd_log.level_error,

1589: WHEN new_phant_prod_not_found THEN
1590: ROLLBACK;
1591: gma_common_logging.gma_migration_central_log
1592: (p_run_id => g_migration_run_id,
1593: p_log_level => fnd_log.level_error,
1594: p_message_token => 'GME_PHANTOM_PROD_NOT_FOUND',
1595: p_table_name => 'GME_BATCH_HEADER',
1596: p_context => 'RECREATE_OPEN_BATCHES',
1597: p_app_short_name => 'GME',

Line 1607: p_log_level => fnd_log.level_error,

1603: END IF;
1604: ROLLBACK;
1605: gma_common_logging.gma_migration_central_log
1606: (p_run_id => g_migration_run_id,
1607: p_log_level => fnd_log.level_error,
1608: p_message_token => 'GME_PHANT_BATCH_UNEXPECTED',
1609: p_table_name => 'GME_BATCH_HEADER',
1610: p_context => 'RECREATE_OPEN_BATCHES',
1611: p_app_short_name => 'GME',

Line 1855: p_log_level => fnd_log.level_error,

1851: NULL;
1852: WHEN no_open_period_err THEN
1853: gma_common_logging.gma_migration_central_log
1854: (p_run_id => g_migration_run_id,
1855: p_log_level => fnd_log.level_error,
1856: p_message_token => 'GME_NO_OPEN_PERIODS_STEP',
1857: p_table_name => 'GME_BATCH_HEADER',
1858: p_context => 'RECREATE_OPEN_BATCHES',
1859: p_app_short_name => 'GME',

Line 1867: p_log_level => fnd_log.level_error,

1863: p_param2 => get_steps.batchstep_no);
1864: WHEN step_cmplt_err THEN
1865: gma_common_logging.gma_migration_central_log
1866: (p_run_id => g_migration_run_id,
1867: p_log_level => fnd_log.level_error,
1868: p_message_token => 'GME_STEP_CMPLT_ERR',
1869: p_table_name => 'GME_BATCH_HEADER',
1870: p_context => 'RECREATE_OPEN_BATCHES',
1871: p_app_short_name => 'GME',

Line 1881: p_log_level => fnd_log.level_error,

1877: p_param3 => l_msg_data);
1878: WHEN step_release_err THEN
1879: gma_common_logging.gma_migration_central_log
1880: (p_run_id => g_migration_run_id,
1881: p_log_level => fnd_log.level_error,
1882: p_message_token => 'GME_STEP_RELEASE_ERR',
1883: p_table_name => 'GME_BATCH_HEADER',
1884: p_context => 'RECREATE_OPEN_BATCHES',
1885: p_app_short_name => 'GME',

Line 1898: p_log_level => fnd_log.level_error,

1894: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
1895: END IF;
1896: gma_common_logging.gma_migration_central_log
1897: (p_run_id => g_migration_run_id,
1898: p_log_level => fnd_log.level_error,
1899: p_message_token => 'GME_STEP_PROCESS_UNEXP',
1900: p_table_name => 'GME_BATCH_HEADER',
1901: p_context => 'RECREATE_OPEN_BATCHES',
1902: p_app_short_name => 'GME',

Line 1915: p_log_level => fnd_log.level_error,

1911: EXCEPTION
1912: WHEN no_open_period_err THEN
1913: gma_common_logging.gma_migration_central_log
1914: (p_run_id => g_migration_run_id,
1915: p_log_level => fnd_log.level_error,
1916: p_message_token => 'GME_NO_OPEN_PERIODS_BATCH',
1917: p_table_name => 'GME_BATCH_HEADER',
1918: p_context => 'RECREATE_OPEN_BATCHES',
1919: p_app_short_name => 'GME',

Line 1927: p_log_level => fnd_log.level_error,

1923: gme_common_pvt.count_and_get(x_count => l_msg_cnt
1924: ,x_data => l_msg_data);
1925: gma_common_logging.gma_migration_central_log
1926: (p_run_id => g_migration_run_id,
1927: p_log_level => fnd_log.level_error,
1928: p_message_token => 'GME_BATCH_RELEASE_ERR',
1929: p_table_name => 'GME_BATCH_HEADER',
1930: p_context => 'RECREATE_OPEN_BATCHES',
1931: p_app_short_name => 'GME',

Line 1942: p_log_level => fnd_log.level_error,

1938: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
1939: END IF;
1940: gma_common_logging.gma_migration_central_log
1941: (p_run_id => g_migration_run_id,
1942: p_log_level => fnd_log.level_error,
1943: p_message_token => 'GME_BATCH_PROCESS_UNEXP',
1944: p_table_name => 'GME_BATCH_HEADER',
1945: p_context => 'RECREATE_OPEN_BATCHES',
1946: p_app_short_name => 'GME',

Line 2415: p_log_level => fnd_log.level_error,

2411: 'trans date '||to_char(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
2412:
2413: gma_common_logging.gma_migration_central_log
2414: (p_run_id => g_migration_run_id,
2415: p_log_level => fnd_log.level_error,
2416: p_message_token => 'GME_MIG_REASON_NOT_FOUND',
2417: p_table_name => 'GME_BATCH_HEADER',
2418: p_context => 'RECREATE_OPEN_BATCHES',
2419: p_app_short_name => 'GME',

Line 3102: p_log_level => fnd_log.level_error,

3098: gme_common_pvt.count_and_get(x_count => l_msg_cnt
3099: ,x_data => l_msg_data);
3100: gma_common_logging.gma_migration_central_log
3101: (p_run_id => g_migration_run_id,
3102: p_log_level => fnd_log.level_error,
3103: p_message_token => 'GME_TXNS_MIG_FAILED',
3104: p_table_name => 'GME_BATCH_HEADER',
3105: p_context => 'RECREATE_OPEN_BATCHES',
3106: p_app_short_name => 'GME',

Line 3123: p_log_level => fnd_log.level_error,

3119: gme_common_pvt.count_and_get(x_count => l_msg_cnt
3120: ,x_data => l_msg_data);
3121: gma_common_logging.gma_migration_central_log
3122: (p_run_id => g_migration_run_id,
3123: p_log_level => fnd_log.level_error,
3124: p_message_token => 'GME_GENERAL_TXN_FAIL',
3125: p_table_name => 'GME_BATCH_HEADER',
3126: p_context => 'CREATE_TXNS_RESERVATIONS_EXP_ERROR',
3127: p_app_short_name => 'GME',

Line 3146: p_log_level => fnd_log.level_error,

3142: 'trans date '||to_char(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
3143:
3144: gma_common_logging.gma_migration_central_log
3145: (p_run_id => g_migration_run_id,
3146: p_log_level => fnd_log.level_error,
3147: p_message_token => l_msg_name,
3148: p_table_name => 'GME_BATCH_HEADER',
3149: p_context => 'RECREATE_OPEN_BATCHES',
3150: p_app_short_name => 'GME',

Line 3167: p_log_level => fnd_log.level_error,

3163: 'trans date '||to_char(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
3164:
3165: gma_common_logging.gma_migration_central_log
3166: (p_run_id => g_migration_run_id,
3167: p_log_level => fnd_log.level_error,
3168: p_message_token => 'GME_MIG_UOM_CONV_FAIL',
3169: p_table_name => 'GME_BATCH_HEADER',
3170: p_context => 'RECREATE_OPEN_BATCHES',
3171: p_app_short_name => 'GME',

Line 3196: p_log_level => fnd_log.level_error,

3192: 'trans date '||to_char(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
3193:
3194: gma_common_logging.gma_migration_central_log
3195: (p_run_id => g_migration_run_id,
3196: p_log_level => fnd_log.level_error,
3197: p_message_token => l_msg_name,
3198: p_table_name => 'GME_BATCH_HEADER',
3199: p_context => 'RECREATE_OPEN_BATCHES',
3200: p_app_short_name => 'GME',

Line 3225: p_log_level => fnd_log.level_error,

3221: 'trans date '||to_char(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
3222:
3223: gma_common_logging.gma_migration_central_log
3224: (p_run_id => g_migration_run_id,
3225: p_log_level => fnd_log.level_error,
3226: p_message_token => 'GME_GENERAL_TXN_FAIL',
3227: p_table_name => 'GME_BATCH_HEADER',
3228: p_context => 'CREATE_TXNS_RESERVATIONS_OTHERS',
3229: p_app_short_name => 'GME',

Line 3340: p_log_level => fnd_log.level_error,

3336: END IF;
3337:
3338: gma_common_logging.gma_migration_central_log
3339: (p_run_id => g_migration_run_id,
3340: p_log_level => fnd_log.level_error,
3341: p_message_token => 'GME_MIG_INV_TRANSFER',
3342: p_table_name => 'GME_BATCH_HEADER',
3343: p_context => 'RECREATE_OPEN_BATCHES',
3344: p_app_short_name => 'GME',

Line 3722: p_log_level => fnd_log.level_error,

3718: EXCEPTION
3719: WHEN item_not_defined THEN
3720: gma_common_logging.gma_migration_central_log
3721: (p_run_id => g_migration_run_id,
3722: p_log_level => fnd_log.level_error,
3723: p_message_token => 'INV_IC_INVALID_ITEM_ORG',
3724: p_table_name => 'GME_BATCH_HEADER',
3725: p_context => 'RECREATE_OPEN_BATCHES',
3726: p_app_short_name => 'INV',

Line 3738: p_log_level => fnd_log.level_error,

3734: ,x_count => l_msg_cnt
3735: ,x_data => l_msg_data);
3736: gma_common_logging.gma_migration_central_log
3737: (p_run_id => g_migration_run_id,
3738: p_log_level => fnd_log.level_error,
3739: p_message_token => 'GME_GENERAL_TXN_FAIL',
3740: p_table_name => 'GME_BATCH_HEADER',
3741: p_context => 'CREATE_ISSUE_RECEIPT_NO_OPEN_PER',
3742: p_app_short_name => 'GME',

Line 3764: p_log_level => fnd_log.level_error,

3760: ,x_count => l_msg_cnt
3761: ,x_data => l_msg_data);
3762: gma_common_logging.gma_migration_central_log
3763: (p_run_id => g_migration_run_id,
3764: p_log_level => fnd_log.level_error,
3765: p_message_token => 'GME_GENERAL_TXN_FAIL',
3766: p_table_name => 'GME_BATCH_HEADER',
3767: p_context => 'CREATE_ISSUE_RECEIPT_EXP_ERROR',
3768: p_app_short_name => 'GME',

Line 3787: p_log_level => fnd_log.level_error,

3783: 'trans date '||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
3784:
3785: gma_common_logging.gma_migration_central_log
3786: (p_run_id => g_migration_run_id,
3787: p_log_level => fnd_log.level_error,
3788: p_message_token => l_msg_name,
3789: p_table_name => 'GME_BATCH_HEADER',
3790: p_context => 'RECREATE_OPEN_BATCHES',
3791: p_app_short_name => 'GME',

Line 3812: p_log_level => fnd_log.level_error,

3808:
3809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3810: gma_common_logging.gma_migration_central_log
3811: (p_run_id => g_migration_run_id,
3812: p_log_level => fnd_log.level_error,
3813: p_message_token => 'GME_GENERAL_TXN_FAIL',
3814: p_table_name => 'GME_BATCH_HEADER',
3815: p_context => 'CREATE_ISSUE_RECEIPT_OTHERS',
3816: p_app_short_name => 'GME',

Line 3857: p_log_level => fnd_log.level_unexpected,

3853: END IF;
3854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3855: gma_common_logging.gma_migration_central_log
3856: (p_run_id => g_migration_run_id,
3857: p_log_level => fnd_log.level_unexpected,
3858: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3859: p_table_name => 'GME_BATCH_HEADER',
3860: p_context => 'RECREATE_OPEN_BATCHES',
3861: p_db_error => SQLERRM,

Line 3930: p_log_level => fnd_log.level_error,

3926: EXCEPTION
3927: WHEN step_close_fail THEN
3928: gma_common_logging.gma_migration_central_log
3929: (p_run_id => g_migration_run_id,
3930: p_log_level => fnd_log.level_error,
3931: p_message_token => 'GME_STEP_CLOSE_ERR',
3932: p_table_name => 'GME_BATCH_HEADER',
3933: p_context => 'RECREATE_OPEN_BATCHES',
3934: p_app_short_name => 'GME',

Line 3947: p_log_level => fnd_log.level_error,

3943: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
3944: END IF;
3945: gma_common_logging.gma_migration_central_log
3946: (p_run_id => g_migration_run_id,
3947: p_log_level => fnd_log.level_error,
3948: p_message_token => 'GME_STEP_PROCESS_UNEXP',
3949: p_table_name => 'GME_BATCH_HEADER',
3950: p_context => 'RECREATE_OPEN_BATCHES',
3951: p_app_short_name => 'GME',

Line 4071: p_log_level => fnd_log.level_error,

4067: gme_common_pvt.count_and_get(x_count => l_msg_cnt
4068: ,x_data => l_msg_data);
4069: gma_common_logging.gma_migration_central_log
4070: (p_run_id => g_migration_run_id,
4071: p_log_level => fnd_log.level_error,
4072: p_message_token => 'GME_TXNS_MIG_FAILED',
4073: p_table_name => 'GME_BATCH_HEADER',
4074: p_context => 'RECREATE_OPEN_BATCHES',
4075: p_app_short_name => 'GME',

Line 4089: p_log_level => fnd_log.level_error,

4085: l_txn_data := l_item_rec.segment1||'->'||get_lots.lot_id||'->'||get_lots.qty||'->'||get_lots.qty2;
4086: l_new_data := l_item_rec.segment1||'->'||l_lot_number||'->'||get_lots.qty||'->'||get_lots.qty2;
4087: gma_common_logging.gma_migration_central_log
4088: (p_run_id => g_migration_run_id,
4089: p_log_level => fnd_log.level_error,
4090: p_message_token => 'GME_CREATE_PPLOT_FAIL',
4091: p_table_name => 'GME_BATCH_HEADER',
4092: p_context => 'RECREATE_OPEN_BATCHES',
4093: p_app_short_name => 'GME',

Line 4112: p_log_level => fnd_log.level_error,

4108: END IF;
4109: l_txn_data := l_item_rec.segment1||'->'||get_lots.lot_id||'->'||get_lots.qty||'->'||get_lots.qty2;
4110: gma_common_logging.gma_migration_central_log
4111: (p_run_id => g_migration_run_id,
4112: p_log_level => fnd_log.level_error,
4113: p_message_token => 'GME_TXNS_MIG_FAILED',
4114: p_table_name => 'GME_BATCH_HEADER',
4115: p_context => 'RECREATE_OPEN_BATCHES',
4116: p_app_short_name => 'GME',