[Home] [Help]
231:
232: /* Begin by logging a message that open order lines migration has started */
233: gma_common_logging.gma_migration_central_log (
234: p_run_id => p_migration_run_id
235: , p_log_level => FND_LOG.LEVEL_PROCEDURE
236: , p_app_short_name => 'GML'
237: , p_message_token => 'GML_MIGRATION_TABLE_STARTED'
238: , p_table_name => l_opm_table_name
239: , p_context => 'OPEN_ORDER_LINES');
368: -- Log Error
369: GMI_RESERVATION_UTIL.PrintLn(' Failed to get discrete item. Item id :'||to_char(allocations_for_line_rec.item_id));
370: GMA_COMMON_LOGGING.gma_migration_central_log (
371: p_run_id => p_migration_run_id,
372: p_log_level => FND_LOG.LEVEL_ERROR,
373: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
374: p_table_name => 'IC_ITEM_CNV',
375: p_context => 'GET_ODM_ITEM',
376: p_param1 => allocations_for_line_rec.item_id,
465: -- Log error
466: GMI_RESERVATION_UTIL.Println('Unable to create the locator for dynamic OPM location :' || allocations_for_line_rec.whse_code ||', '||allocations_for_line_rec.location );
467: GMA_COMMON_LOGGING.gma_migration_central_log (
468: p_run_id => p_migration_run_id,
469: p_log_level => FND_LOG.LEVEL_ERROR,
470: p_message_token => 'GMI_LOC_CREATION_FAILED',
471: p_table_name => 'IC_LOCT_MST',
472: p_context => 'inv_migrate_process_org.create_location',
473: p_param1 => allocations_for_line_rec.whse_code,
536: GMI_RESERVATION_UTIL.Println('Failed to migrate lot - OPM lot_id = '|| to_char(allocations_for_line_rec.lot_id));
537: GMI_RESERVATION_UTIL.Println('Failed to migrate lot - OPM lot_no = '|| l_lot_no);
538: GMA_COMMON_LOGGING.gma_migration_central_log (
539: p_run_id => p_migration_run_id,
540: p_log_level => FND_LOG.LEVEL_ERROR,
541: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
542: p_table_name => 'IC_LOTS_MST',
543: p_context => 'GET_ODM_LOT',
544: p_param1 => l_lot_no,
620: FOR i in 1..l_msg_count LOOP
621:
622: GMA_COMMON_LOGGING.gma_migration_central_log (
623: p_run_id => p_migration_run_id,
624: p_log_level => FND_LOG.LEVEL_ERROR,
625: p_message_token => 'GMI_UNEXPECTED_ERROR',
626: p_table_name => 'IC_TRAN_PND',
627: p_context => 'CREATE RESERVATION',
628: p_token1 => 'ERROR',
637: -- insert more comprehensive data into gma log table.
638:
639: GMA_COMMON_LOGGING.gma_migration_central_log (
640: p_run_id => p_migration_run_id,
641: p_log_level => FND_LOG.LEVEL_ERROR,
642: p_message_token => 'GMI_UNEXPECTED_ERROR',
643: p_table_name => 'IC_TRAN_PND',
644: p_context => 'CREATE RESERVATION',
645: p_param1 => INV_GMI_Migration.item(allocations_for_line_rec.item_id),
676: /* Failure count goes up by 1 */
677: l_failure_count := l_failure_count+1;
678: gma_common_logging.gma_migration_central_log (
679: p_run_id => p_migration_run_id
680: , p_log_level => FND_LOG.LEVEL_UNEXPECTED
681: , p_app_short_name =>'GML'
682: , p_message_token => 'GML_MIGRATION_DB_ERROR'
683: , p_db_error => sqlerrm
684: , p_table_name => 'IC_TRAN_PND'
790: FOR i in 1..l_msg_count LOOP
791:
792: GMA_COMMON_LOGGING.gma_migration_central_log (
793: p_run_id => p_migration_run_id,
794: p_log_level => FND_LOG.LEVEL_ERROR,
795: p_message_token => 'GMI_UNEXPECTED_ERROR',
796: p_table_name => 'mtl_txn_request_headers',
797: p_context => 'Create_move_order_header',
798: p_token1 => 'ERROR',
807: -- insert more comprehensive data into gma log table.
808:
809: GMA_COMMON_LOGGING.gma_migration_central_log (
810: p_run_id => p_migration_run_id,
811: p_log_level => FND_LOG.LEVEL_ERROR,
812: p_message_token => 'INV_ERROR_CREATING_MO',
813: p_table_name => 'mtl_txn_request_headers',
814: p_context => 'Create_move_order_header',
815: p_param1 => l_ic_mo_header_rec.request_number,
948: FOR i in 1..l_msg_count LOOP
949:
950: GMA_COMMON_LOGGING.gma_migration_central_log (
951: p_run_id => p_migration_run_id,
952: p_log_level => FND_LOG.LEVEL_ERROR,
953: p_message_token => 'GMI_UNEXPECTED_ERROR',
954: p_table_name => 'mtl_txn_request_lines',
955: p_context => 'Create_Move_Order_Lines',
956: p_token1 => 'ERROR',
965: -- insert more comprehensive data into gma log table.
966:
967: GMA_COMMON_LOGGING.gma_migration_central_log (
968: p_run_id => p_migration_run_id,
969: p_log_level => FND_LOG.LEVEL_ERROR,
970: p_message_token => 'INV_ERROR_CREATING_MO',
971: p_table_name => 'mtl_txn_request_lines',
972: p_context => 'Create_Move_Order_Lines',
973: p_param1 => l_mo_header_id,
1078:
1079: if L_FAILURE_COUNT < 1 THEN
1080: gma_common_logging.gma_migration_central_log (
1081: p_run_id => p_migration_run_id
1082: , p_log_level => FND_LOG.LEVEL_PROCEDURE
1083: , p_app_short_name => 'GML'
1084: , p_message_token => 'GML_MIGRATION_TABLE_SUCCESS'
1085: , p_table_name => NULL
1086: , p_context => 'OPEN_ORDER_LINES'
1089: else
1090:
1091: gma_common_logging.gma_migration_central_log (
1092: p_run_id => p_migration_run_id
1093: , p_log_level => FND_LOG.LEVEL_PROCEDURE
1094: , p_app_short_name => 'GML'
1095: , p_message_token => 'GML_MIGRATION_TABLE_FAILURE'
1096: , p_table_name => NULL
1097: , p_context => 'OPEN_ORDER_LINES'
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: gma_common_logging.gma_migration_central_log (
1112: p_run_id => p_migration_run_id
1113: , p_log_level => FND_LOG.LEVEL_UNEXPECTED
1114: , p_app_short_name =>'GML'
1115: , p_message_token => 'GML_MIGRATION_DB_ERROR'
1116: , p_db_error => sqlerrm
1117: , p_table_name => NULL