[Home] [Help]
215: x_failure_count := 0;
216:
217: GMA_COMMON_LOGGING.gma_migration_central_log (
218: p_run_id => P_migration_run_id,
219: p_log_level => FND_LOG.LEVEL_PROCEDURE,
220: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
221: p_table_name => 'PO_HAZARD_CLASSES',
222: p_context => 'HAZARD_CLASSES',
223: p_param1 => NULL,
308: l_mig_status := 0;
309:
310: GMA_COMMON_LOGGING.gma_migration_central_log (
311: p_run_id => P_migration_run_id,
312: p_log_level => FND_LOG.LEVEL_STATEMENT,
313: p_message_token => 'GR_HAZARD_CLASS_EXISTS',
314: p_table_name => 'PO_HAZARD_CLASSES',
315: p_context => 'HAZARD_CLASSES',
316: p_param1 => l_hazard_class_rec.value,
343: x_failure_count := x_failure_count + 1;
344:
345: GMA_COMMON_LOGGING.gma_migration_central_log (
346: p_run_id => P_migration_run_id,
347: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
348: p_message_token => 'GMA_MIGRATION_DB_ERROR',
349: p_table_name => 'PO_HAZARD_CLASSES',
350: p_context => 'HAZARD_CLASSES',
351: p_param1 => NULL,
368:
369:
370: GMA_COMMON_LOGGING.gma_migration_central_log (
371: p_run_id => P_migration_run_id,
372: p_log_level => FND_LOG.LEVEL_PROCEDURE,
373: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
374: p_table_name => 'PO_HAZARD_CLASSES',
375: p_context => 'HAZARD_CLASSES',
376: p_param1 => l_migration_count,
387: x_failure_count := x_failure_count + 1;
388:
389: GMA_COMMON_LOGGING.gma_migration_central_log (
390: p_run_id => P_migration_run_id,
391: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
392: p_message_token => 'GMA_MIGRATION_DB_ERROR',
393: p_table_name => 'PO_HAZARD_CLASSES',
394: p_context => 'HAZARD_CLASSES',
395: p_param1 => NULL,
401: p_app_short_name => 'GMA');
402:
403: GMA_COMMON_LOGGING.gma_migration_central_log (
404: p_run_id => P_migration_run_id,
405: p_log_level => FND_LOG.LEVEL_PROCEDURE,
406: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
407: p_table_name => 'PO_HAZARD_CLASSES',
408: p_context => 'HAZARD_CLASSES',
409: p_param1 => x_failure_count,
497: x_failure_count := 0;
498:
499: GMA_COMMON_LOGGING.gma_migration_central_log (
500: p_run_id => P_migration_run_id,
501: p_log_level => FND_LOG.LEVEL_PROCEDURE,
502: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
503: p_table_name => 'PO_UN_NUMBERS',
504: p_context => 'UN_NUMBERS',
505: p_param1 => NULL,
586: l_mig_status := 0;
587:
588: GMA_COMMON_LOGGING.gma_migration_central_log (
589: p_run_id => P_migration_run_id,
590: p_log_level => FND_LOG.LEVEL_STATEMENT,
591: p_message_token => 'GR_UN_NUMBER_EXISTS',
592: p_table_name => 'PO_UN_NUMBERS',
593: p_context => 'UN_NUMBERS',
594: p_param1 => TO_CHAR(l_un_number_rec.number_value),
630: ROLLBACK to SAVEPOINT UN_Number;
631:
632: GMA_COMMON_LOGGING.gma_migration_central_log (
633: p_run_id => P_migration_run_id,
634: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
635: p_message_token => 'GMA_MIGRATION_DB_ERROR',
636: p_table_name => 'PO_UN_NUMBERS',
637: p_context => 'UN_NUMBERS',
638: p_param1 => NULL,
653:
654:
655: GMA_COMMON_LOGGING.gma_migration_central_log (
656: p_run_id => P_migration_run_id,
657: p_log_level => FND_LOG.LEVEL_PROCEDURE,
658: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
659: p_table_name => 'PO_UN_NUMBERS',
660: p_context => 'UN_NUMBERS',
661: p_param1 => l_migration_count,
672: x_failure_count := x_failure_count + 1;
673:
674: GMA_COMMON_LOGGING.gma_migration_central_log (
675: p_run_id => P_migration_run_id,
676: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
677: p_message_token => 'GMA_MIGRATION_DB_ERROR',
678: p_table_name => 'PO_UN_NUMBERS',
679: p_context => 'UN_NUMBERS',
680: p_param1 => NULL,
686: p_app_short_name => 'GMA');
687:
688: GMA_COMMON_LOGGING.gma_migration_central_log (
689: p_run_id => P_migration_run_id,
690: p_log_level => FND_LOG.LEVEL_PROCEDURE,
691: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
692: p_table_name => 'PO_UN_NUMBERS',
693: p_context => 'UN_NUMBERS',
694: p_param1 => x_failure_count,