DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GMA_COMMON_LOGGING

Line 555: gma_common_logging.gma_migration_central_log

551: ROLLBACK;
552: OPEN Cur_item_mst(l_item_id);
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',

Line 570: gma_common_logging.gma_migration_central_log

566: WHEN setup_failed OR calc_mtl_req_date_err OR create_mo_hdr_err OR create_mo_line_err THEN
567: ROLLBACK;
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',

Line 586: gma_common_logging.gma_migration_central_log

582: IF (g_debug <= gme_debug.g_log_unexpected) THEN
583: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
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',

Line 664: gma_common_logging.gma_migration_central_log

660: WHEN OTHERS THEN
661: IF (g_debug <= gme_debug.g_log_unexpected) THEN
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',

Line 1580: gma_common_logging.gma_migration_central_log

1576: WHERE material_detail_id = l_new_prod_line_id;
1577: EXCEPTION
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',

Line 1591: gma_common_logging.gma_migration_central_log

1587: p_token1 => 'BATCH_NO',
1588: p_param1 => get_phantoms.plant_code||'-'||get_phantoms.new_batch_no);
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',

Line 1605: gma_common_logging.gma_migration_central_log

1601: IF (g_debug <= gme_debug.g_log_unexpected) THEN
1602: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
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',

Line 1853: gma_common_logging.gma_migration_central_log

1849: EXCEPTION
1850: WHEN inv_phantoms_found THEN
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',

Line 1865: gma_common_logging.gma_migration_central_log

1861: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,
1862: p_token2 => 'STEP_NO',
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',

Line 1879: gma_common_logging.gma_migration_central_log

1875: p_param2 => get_steps.batchstep_no,
1876: p_token3 => 'MSG',
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',

Line 1896: gma_common_logging.gma_migration_central_log

1892: WHEN OTHERS THEN
1893: IF (g_debug <= gme_debug.g_log_unexpected) THEN
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',

Line 1913: gma_common_logging.gma_migration_central_log

1909: END;
1910: END LOOP;
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',

Line 1925: gma_common_logging.gma_migration_central_log

1921: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no);
1922: WHEN release_batch_err THEN
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',

Line 1940: gma_common_logging.gma_migration_central_log

1936: WHEN OTHERS THEN
1937: IF (g_debug <= gme_debug.g_log_unexpected) THEN
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',

Line 2413: gma_common_logging.gma_migration_central_log

2409: 'trans qty '||l_txns_tbl(i).trans_qty||'->'||'primary uom '||l_mtl_rec.primary_uom_code||'->'||
2410: 'detail uom '||l_mtl_rec.dtl_um||'->'||
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',

Line 3100: gma_common_logging.gma_migration_central_log

3096: EXCEPTION
3097: WHEN setup_failed OR batch_fetch_err THEN
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',

Line 3121: gma_common_logging.gma_migration_central_log

3117: 'trans date '||to_char(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');
3118:
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',

Line 3144: gma_common_logging.gma_migration_central_log

3140: 'trans qty '||l_txns_tbl(i).trans_qty||'->'||'primary uom '||l_mtl_rec.primary_uom_code||'->'||
3141: 'detail uom '||l_mtl_rec.dtl_um||'->'||
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',

Line 3165: gma_common_logging.gma_migration_central_log

3161: 'trans qty '||l_txns_tbl(i).trans_qty||'->'||'primary uom '||l_mtl_rec.primary_uom_code||'->'||
3162: 'detail uom '||l_mtl_rec.dtl_um||'->'||
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',

Line 3194: gma_common_logging.gma_migration_central_log

3190: 'trans qty '||l_txns_tbl(i).trans_qty||'->'||'primary uom '||l_mtl_rec.primary_uom_code||'->'||
3191: 'detail uom '||l_mtl_rec.dtl_um||'->'||
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',

Line 3223: gma_common_logging.gma_migration_central_log

3219: 'trans qty '||l_txns_tbl(i).trans_qty||'->'||'primary uom '||l_mtl_rec.primary_uom_code||'->'||
3220: 'detail uom '||l_mtl_rec.dtl_um||'->'||
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',

Line 3338: gma_common_logging.gma_migration_central_log

3334: IF (g_debug <= gme_debug.g_log_statement) THEN
3335: gme_debug.put_line('TXN Data = '||l_txn_data);
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',

Line 3720: gma_common_logging.gma_migration_central_log

3716: gme_debug.put_line('End procedure '||l_api_name);
3717: END IF;
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',

Line 3736: gma_common_logging.gma_migration_central_log

3732: WHEN no_open_period_err THEN
3733: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
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',

Line 3762: gma_common_logging.gma_migration_central_log

3758:
3759: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
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',

Line 3785: gma_common_logging.gma_migration_central_log

3781: 'trans qty '||p_txn_rec.trans_qty||'->'||'trans um '||p_txn_rec.trans_um||'->'||
3782: 'primary um '||l_item_rec.primary_uom_code||'->'||
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',

Line 3810: gma_common_logging.gma_migration_central_log

3806: 'primary um '||l_item_rec.primary_uom_code||'->'||
3807: 'trans date '||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
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',

Line 3855: gma_common_logging.gma_migration_central_log

3851: IF (g_debug <= gme_debug.g_log_unexpected) THEN
3852: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
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',

Line 3928: gma_common_logging.gma_migration_central_log

3924: CLOSE Cur_verify_txns;
3925: END IF;
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',

Line 3945: gma_common_logging.gma_migration_central_log

3941: WHEN OTHERS THEN
3942: IF (g_debug <= gme_debug.g_log_unexpected) THEN
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',

Line 4069: gma_common_logging.gma_migration_central_log

4065: EXCEPTION
4066: WHEN batch_fetch_err THEN
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',

Line 4087: gma_common_logging.gma_migration_central_log

4083: ,x_count => l_msg_cnt
4084: ,x_data => l_msg_data);
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',

Line 4110: gma_common_logging.gma_migration_central_log

4106: IF (g_debug <= gme_debug.g_log_unexpected) THEN
4107: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
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',