[Home] [Help]
235:
236: /* Begin by logging a message that open order lines migration has started */
237: gma_common_logging.gma_migration_central_log (
238: p_run_id => p_migration_run_id
239: , p_log_level => FND_LOG.LEVEL_PROCEDURE
240: , p_app_short_name => 'GML'
241: , p_message_token => 'GML_MIGRATION_TABLE_STARTED'
242: , p_table_name => l_opm_table_name
243: , p_context => 'OPEN_ORDER_LINES');
372: -- Log Error
373: GMI_RESERVATION_UTIL.PrintLn(' Failed to get discrete item. Item id :'||to_char(allocations_for_line_rec.item_id));
374: GMA_COMMON_LOGGING.gma_migration_central_log (
375: p_run_id => p_migration_run_id,
376: p_log_level => FND_LOG.LEVEL_ERROR,
377: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
378: p_table_name => 'IC_ITEM_CNV',
379: p_context => 'GET_ODM_ITEM',
380: p_param1 => allocations_for_line_rec.item_id,
469: -- Log error
470: GMI_RESERVATION_UTIL.Println('Unable to create the locator for dynamic OPM location :' || allocations_for_line_rec.whse_code ||', '||allocations_for_line_rec.location );
471: GMA_COMMON_LOGGING.gma_migration_central_log (
472: p_run_id => p_migration_run_id,
473: p_log_level => FND_LOG.LEVEL_ERROR,
474: p_message_token => 'GMI_LOC_CREATION_FAILED',
475: p_table_name => 'IC_LOCT_MST',
476: p_context => 'inv_migrate_process_org.create_location',
477: p_param1 => allocations_for_line_rec.whse_code,
540: GMI_RESERVATION_UTIL.Println('Failed to migrate lot - OPM lot_id = '|| to_char(allocations_for_line_rec.lot_id));
541: GMI_RESERVATION_UTIL.Println('Failed to migrate lot - OPM lot_no = '|| l_lot_no);
542: GMA_COMMON_LOGGING.gma_migration_central_log (
543: p_run_id => p_migration_run_id,
544: p_log_level => FND_LOG.LEVEL_ERROR,
545: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
546: p_table_name => 'IC_LOTS_MST',
547: p_context => 'GET_ODM_LOT',
548: p_param1 => l_lot_no,
624: FOR i in 1..l_msg_count LOOP
625:
626: GMA_COMMON_LOGGING.gma_migration_central_log (
627: p_run_id => p_migration_run_id,
628: p_log_level => FND_LOG.LEVEL_ERROR,
629: p_message_token => 'GMI_UNEXPECTED_ERROR',
630: p_table_name => 'IC_TRAN_PND',
631: p_context => 'CREATE RESERVATION',
632: p_token1 => 'ERROR',
641: -- insert more comprehensive data into gma log table.
642:
643: GMA_COMMON_LOGGING.gma_migration_central_log (
644: p_run_id => p_migration_run_id,
645: p_log_level => FND_LOG.LEVEL_ERROR,
646: p_message_token => 'GMI_UNEXPECTED_ERROR',
647: p_table_name => 'IC_TRAN_PND',
648: p_context => 'CREATE RESERVATION',
649: p_param1 => INV_GMI_Migration.item(allocations_for_line_rec.item_id),
680: /* Failure count goes up by 1 */
681: l_failure_count := l_failure_count+1;
682: gma_common_logging.gma_migration_central_log (
683: p_run_id => p_migration_run_id
684: , p_log_level => FND_LOG.LEVEL_UNEXPECTED
685: , p_app_short_name =>'GML'
686: , p_message_token => 'GML_MIGRATION_DB_ERROR'
687: , p_db_error => sqlerrm
688: , p_table_name => 'IC_TRAN_PND'
794: FOR i in 1..l_msg_count LOOP
795:
796: GMA_COMMON_LOGGING.gma_migration_central_log (
797: p_run_id => p_migration_run_id,
798: p_log_level => FND_LOG.LEVEL_ERROR,
799: p_message_token => 'GMI_UNEXPECTED_ERROR',
800: p_table_name => 'mtl_txn_request_headers',
801: p_context => 'Create_move_order_header',
802: p_token1 => 'ERROR',
811: -- insert more comprehensive data into gma log table.
812:
813: GMA_COMMON_LOGGING.gma_migration_central_log (
814: p_run_id => p_migration_run_id,
815: p_log_level => FND_LOG.LEVEL_ERROR,
816: p_message_token => 'INV_ERROR_CREATING_MO',
817: p_table_name => 'mtl_txn_request_headers',
818: p_context => 'Create_move_order_header',
819: p_param1 => l_ic_mo_header_rec.request_number,
952: FOR i in 1..l_msg_count LOOP
953:
954: GMA_COMMON_LOGGING.gma_migration_central_log (
955: p_run_id => p_migration_run_id,
956: p_log_level => FND_LOG.LEVEL_ERROR,
957: p_message_token => 'GMI_UNEXPECTED_ERROR',
958: p_table_name => 'mtl_txn_request_lines',
959: p_context => 'Create_Move_Order_Lines',
960: p_token1 => 'ERROR',
969: -- insert more comprehensive data into gma log table.
970:
971: GMA_COMMON_LOGGING.gma_migration_central_log (
972: p_run_id => p_migration_run_id,
973: p_log_level => FND_LOG.LEVEL_ERROR,
974: p_message_token => 'INV_ERROR_CREATING_MO',
975: p_table_name => 'mtl_txn_request_lines',
976: p_context => 'Create_Move_Order_Lines',
977: p_param1 => l_mo_header_id,
1082:
1083: if L_FAILURE_COUNT < 1 THEN
1084: gma_common_logging.gma_migration_central_log (
1085: p_run_id => p_migration_run_id
1086: , p_log_level => FND_LOG.LEVEL_PROCEDURE
1087: , p_app_short_name => 'GML'
1088: , p_message_token => 'GML_MIGRATION_TABLE_SUCCESS'
1089: , p_table_name => NULL
1090: , p_context => 'OPEN_ORDER_LINES'
1093: else
1094:
1095: gma_common_logging.gma_migration_central_log (
1096: p_run_id => p_migration_run_id
1097: , p_log_level => FND_LOG.LEVEL_PROCEDURE
1098: , p_app_short_name => 'GML'
1099: , p_message_token => 'GML_MIGRATION_TABLE_FAILURE'
1100: , p_table_name => NULL
1101: , p_context => 'OPEN_ORDER_LINES'
1113: EXCEPTION
1114: WHEN OTHERS THEN
1115: gma_common_logging.gma_migration_central_log (
1116: p_run_id => p_migration_run_id
1117: , p_log_level => FND_LOG.LEVEL_UNEXPECTED
1118: , p_app_short_name =>'GML'
1119: , p_message_token => 'GML_MIGRATION_DB_ERROR'
1120: , p_db_error => sqlerrm
1121: , p_table_name => NULL