APPS.GMF_MIGRATION dependencies on GMF_MIGRATION

Line 1: PACKAGE BODY GMF_MIGRATION AS

1: PACKAGE BODY GMF_MIGRATION AS
2: /* $Header: gmfmigrb.pls 120.56.12020000.3 2012/10/19 12:07:50 uskumari ship $ */
3:
4: /**********************************************************************
5: * FUNCTION: *

Line 2050: p_run_id => gmf_migration.G_migration_run_id,

2046: **************************************/
2047:
2048: GMA_COMMON_LOGGING.gma_migration_central_log
2049: (
2050: p_run_id => gmf_migration.G_migration_run_id,
2051: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2052: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2053: p_table_name => gmf_migration.G_Table_name,
2054: p_context => gmf_migration.G_context,

Line 2053: p_table_name => gmf_migration.G_Table_name,

2049: (
2050: p_run_id => gmf_migration.G_migration_run_id,
2051: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2052: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2053: p_table_name => gmf_migration.G_Table_name,
2054: p_context => gmf_migration.G_context,
2055: p_db_error => NULL,
2056: p_app_short_name => 'GMA'
2057: );

Line 2054: p_context => gmf_migration.G_context,

2050: p_run_id => gmf_migration.G_migration_run_id,
2051: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2052: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2053: p_table_name => gmf_migration.G_Table_name,
2054: p_context => gmf_migration.G_context,
2055: p_db_error => NULL,
2056: p_app_short_name => 'GMA'
2057: );
2058:

Line 2295: p_run_id => gmf_migration.G_migration_run_id,

2291: **************************************/
2292:
2293: GMA_COMMON_LOGGING.gma_migration_central_log
2294: (
2295: p_run_id => gmf_migration.G_migration_run_id,
2296: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2297: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2298: p_table_name => gmf_migration.G_Table_name,
2299: p_context => gmf_migration.G_context,

Line 2298: p_table_name => gmf_migration.G_Table_name,

2294: (
2295: p_run_id => gmf_migration.G_migration_run_id,
2296: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2297: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2298: p_table_name => gmf_migration.G_Table_name,
2299: p_context => gmf_migration.G_context,
2300: p_db_error => NULL,
2301: p_app_short_name => 'GMA'
2302: );

Line 2299: p_context => gmf_migration.G_context,

2295: p_run_id => gmf_migration.G_migration_run_id,
2296: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2297: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2298: p_table_name => gmf_migration.G_Table_name,
2299: p_context => gmf_migration.G_context,
2300: p_db_error => NULL,
2301: p_app_short_name => 'GMA'
2302: );
2303:

Line 2458: p_run_id => gmf_migration.G_migration_run_id,

2454: **************************************/
2455:
2456: GMA_COMMON_LOGGING.gma_migration_central_log
2457: (
2458: p_run_id => gmf_migration.G_migration_run_id,
2459: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2460: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2461: p_table_name => gmf_migration.G_Table_name,
2462: p_context => gmf_migration.G_context,

Line 2461: p_table_name => gmf_migration.G_Table_name,

2457: (
2458: p_run_id => gmf_migration.G_migration_run_id,
2459: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2460: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2461: p_table_name => gmf_migration.G_Table_name,
2462: p_context => gmf_migration.G_context,
2463: p_db_error => NULL,
2464: p_app_short_name => 'GMA'
2465: );

Line 2462: p_context => gmf_migration.G_context,

2458: p_run_id => gmf_migration.G_migration_run_id,
2459: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2460: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2461: p_table_name => gmf_migration.G_Table_name,
2462: p_context => gmf_migration.G_context,
2463: p_db_error => NULL,
2464: p_app_short_name => 'GMA'
2465: );
2466:

Line 2677: p_run_id => gmf_migration.G_migration_run_id,

2673: **************************************/
2674:
2675: GMA_COMMON_LOGGING.gma_migration_central_log
2676: (
2677: p_run_id => gmf_migration.G_migration_run_id,
2678: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2679: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2680: p_table_name => gmf_migration.G_Table_name,
2681: p_context => gmf_migration.G_context,

Line 2680: p_table_name => gmf_migration.G_Table_name,

2676: (
2677: p_run_id => gmf_migration.G_migration_run_id,
2678: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2679: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2680: p_table_name => gmf_migration.G_Table_name,
2681: p_context => gmf_migration.G_context,
2682: p_db_error => NULL,
2683: p_app_short_name => 'GMA'
2684: );

Line 2681: p_context => gmf_migration.G_context,

2677: p_run_id => gmf_migration.G_migration_run_id,
2678: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2679: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2680: p_table_name => gmf_migration.G_Table_name,
2681: p_context => gmf_migration.G_context,
2682: p_db_error => NULL,
2683: p_app_short_name => 'GMA'
2684: );
2685:

Line 4083: p_run_id => gmf_migration.G_migration_run_id,

4079: **************************************/
4080:
4081: GMA_COMMON_LOGGING.gma_migration_central_log
4082: (
4083: p_run_id => gmf_migration.G_migration_run_id,
4084: p_log_level => FND_LOG.LEVEL_PROCEDURE,
4085: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
4086: p_table_name => gmf_migration.G_Table_name,
4087: p_context => gmf_migration.G_context,

Line 4086: p_table_name => gmf_migration.G_Table_name,

4082: (
4083: p_run_id => gmf_migration.G_migration_run_id,
4084: p_log_level => FND_LOG.LEVEL_PROCEDURE,
4085: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
4086: p_table_name => gmf_migration.G_Table_name,
4087: p_context => gmf_migration.G_context,
4088: p_db_error => NULL,
4089: p_app_short_name => 'GMA'
4090: );

Line 4087: p_context => gmf_migration.G_context,

4083: p_run_id => gmf_migration.G_migration_run_id,
4084: p_log_level => FND_LOG.LEVEL_PROCEDURE,
4085: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
4086: p_table_name => gmf_migration.G_Table_name,
4087: p_context => gmf_migration.G_context,
4088: p_db_error => NULL,
4089: p_app_short_name => 'GMA'
4090: );
4091:

Line 4611: gmf_migration.Log_Errors (

4607:
4608: /**********************************************
4609: * Handle all the rows which were not migrated *
4610: **********************************************/
4611: gmf_migration.Log_Errors (
4612: p_log_level => 1,
4613: p_from_rowid => NULL,
4614: p_to_rowid => NULL
4615: );

Line 4859: gmf_migration.Log_Errors (

4855:
4856: /**********************************************
4857: * Handle all the rows which were not migrated *
4858: **********************************************/
4859: gmf_migration.Log_Errors (
4860: p_log_level => 1,
4861: p_from_rowid => NULL,
4862: p_to_rowid => NULL
4863: );

Line 5298: gmf_migration.Log_Errors (

5294:
5295: /**********************************************
5296: * Handle all the rows which were not migrated *
5297: **********************************************/
5298: gmf_migration.Log_Errors (
5299: p_log_level => 1,
5300: p_from_rowid => NULL,
5301: p_to_rowid => NULL
5302: );

Line 5477: gmf_migration.Log_Errors (

5473:
5474: /**********************************************
5475: * Handle all the rows which were not migrated *
5476: **********************************************/
5477: gmf_migration.Log_Errors (
5478: p_log_level => 1,
5479: p_from_rowid => NULL,
5480: p_to_rowid => NULL
5481: );

Line 5858: gmf_migration.Log_Errors (

5854:
5855: /**********************************************
5856: * Handle all the rows which were not migrated *
5857: **********************************************/
5858: gmf_migration.Log_Errors (
5859: p_log_level => 1,
5860: p_from_rowid => NULL,
5861: p_to_rowid => NULL
5862: );

Line 6026: -- SELECT gmf_migration.get_account_id(a.basis_Account_key, x.co_code)

6022: /* B8266256 -- Splitting update into 2 parts Starts */
6023: -- UPDATE gl_aloc_bas a
6024: -- SET a.basis_account_id
6025: -- = (
6026: -- SELECT gmf_migration.get_account_id(a.basis_Account_key, x.co_code)
6027: -- FROM gl_aloc_mst x
6028: -- WHERE x.alloc_id = a.alloc_id
6029: -- ),
6030: -- a.basis_type = decode(a.alloc_method, 0, a.basis_type, 1),

Line 6077: SELECT decode(a.alloc_method,0, gmf_migration.get_account_id(a.basis_Account_key, x.co_code), NULL)

6073: /* For GL Balance percentage allocations */
6074: UPDATE gl_aloc_bas a
6075: SET a.basis_account_id
6076: = (
6077: SELECT decode(a.alloc_method,0, gmf_migration.get_account_id(a.basis_Account_key, x.co_code), NULL)
6078: FROM gl_aloc_mst x
6079: WHERE x.alloc_id = a.alloc_id
6080: ),
6081: a.basis_type = decode(a.alloc_method, 0, a.basis_type, 1),

Line 6166: p_run_id => gmf_migration.G_migration_run_id,

6162: **************************************/
6163:
6164: GMA_COMMON_LOGGING.gma_migration_central_log
6165: (
6166: p_run_id => gmf_migration.G_migration_run_id,
6167: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6168: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6169: p_table_name => gmf_migration.G_Table_name,
6170: p_context => gmf_migration.G_context,

Line 6169: p_table_name => gmf_migration.G_Table_name,

6165: (
6166: p_run_id => gmf_migration.G_migration_run_id,
6167: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6168: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6169: p_table_name => gmf_migration.G_Table_name,
6170: p_context => gmf_migration.G_context,
6171: p_db_error => NULL,
6172: p_app_short_name => 'GMA'
6173: );

Line 6170: p_context => gmf_migration.G_context,

6166: p_run_id => gmf_migration.G_migration_run_id,
6167: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6168: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6169: p_table_name => gmf_migration.G_Table_name,
6170: p_context => gmf_migration.G_context,
6171: p_db_error => NULL,
6172: p_app_short_name => 'GMA'
6173: );
6174:

Line 6316: SELECT gmf_migration.get_account_id(a.from_account, x.co_code),

6312: a.from_account_id,
6313: a.to_account_id
6314: )
6315: = (
6316: SELECT gmf_migration.get_account_id(a.from_account, x.co_code),
6317: gmf_migration.get_account_id(a.to_account, x.co_code)
6318: FROM gl_aloc_mst x
6319: WHERE x.alloc_id = a.alloc_id
6320: )

Line 6317: gmf_migration.get_account_id(a.to_account, x.co_code)

6313: a.to_account_id
6314: )
6315: = (
6316: SELECT gmf_migration.get_account_id(a.from_account, x.co_code),
6317: gmf_migration.get_account_id(a.to_account, x.co_code)
6318: FROM gl_aloc_mst x
6319: WHERE x.alloc_id = a.alloc_id
6320: )
6321: WHERE (

Line 6387: p_run_id => gmf_migration.G_migration_run_id,

6383: **************************************/
6384:
6385: GMA_COMMON_LOGGING.gma_migration_central_log
6386: (
6387: p_run_id => gmf_migration.G_migration_run_id,
6388: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6389: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6390: p_table_name => gmf_migration.G_Table_name,
6391: p_context => gmf_migration.G_context,

Line 6390: p_table_name => gmf_migration.G_Table_name,

6386: (
6387: p_run_id => gmf_migration.G_migration_run_id,
6388: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6389: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6390: p_table_name => gmf_migration.G_Table_name,
6391: p_context => gmf_migration.G_context,
6392: p_db_error => NULL,
6393: p_app_short_name => 'GMA'
6394: );

Line 6391: p_context => gmf_migration.G_context,

6387: p_run_id => gmf_migration.G_migration_run_id,
6388: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6389: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6390: p_table_name => gmf_migration.G_Table_name,
6391: p_context => gmf_migration.G_context,
6392: p_db_error => NULL,
6393: p_app_short_name => 'GMA'
6394: );
6395:

Line 7984: l_inventory_item_id := gmf_migration.get_inventory_item_id(p_item_id => l_item_id(m));

7980: p_segment_rule_detail_id => l_segment_rule_detail_id
7981: );
7982: END IF;
7983: IF l_item_id(m) IS NOT NULL THEN
7984: l_inventory_item_id := gmf_migration.get_inventory_item_id(p_item_id => l_item_id(m));
7985: IF l_inventory_item_id IS NOT NULL THEN
7986: insert_conditions (
7987: p_condition_tag => 'MID',
7988: p_sequence => l_adr_condition_priority,

Line 8038: l_reason_id := gmf_migration.Get_reason_id(p_reason_code => l_reason_code(m));

8034: p_segment_rule_detail_id => l_segment_rule_detail_id
8035: );
8036: END IF;
8037: IF l_reason_code(m) IS NOT NULL THEN
8038: l_reason_id := gmf_migration.Get_reason_id(p_reason_code => l_reason_code(m));
8039: IF l_reason_id IS NOT NULL THEN
8040: insert_conditions (
8041: p_condition_tag => 'MID',
8042: p_sequence => l_adr_condition_priority,

Line 8065: l_price_element_type_id := gmf_migration.Get_price_element_type_id(p_aqui_cost_id => l_aqui_cost_id(m));

8061: p_segment_rule_detail_id => l_segment_rule_detail_id
8062: );
8063: END IF;
8064: IF l_aqui_cost_id(m) IS NOT NULL THEN
8065: l_price_element_type_id := gmf_migration.Get_price_element_type_id(p_aqui_cost_id => l_aqui_cost_id(m));
8066: IF l_price_element_type_id IS NOT NULL THEN
8067: insert_conditions (
8068: p_condition_tag => 'MID',
8069: p_sequence => l_adr_condition_priority,

Line 8576: gmf_migration.G_Table_name := 'XLA_RULES_T';

8572: END IF;
8573: /************************************
8574: * ADR Rules Migration Error Logging *
8575: ************************************/
8576: gmf_migration.G_Table_name := 'XLA_RULES_T';
8577: gmf_migration.G_context := 'GMF Error Logging';
8578: gmf_migration.Log_Errors (
8579: p_log_level => 1,
8580: p_from_rowid => NULL,

Line 8577: gmf_migration.G_context := 'GMF Error Logging';

8573: /************************************
8574: * ADR Rules Migration Error Logging *
8575: ************************************/
8576: gmf_migration.G_Table_name := 'XLA_RULES_T';
8577: gmf_migration.G_context := 'GMF Error Logging';
8578: gmf_migration.Log_Errors (
8579: p_log_level => 1,
8580: p_from_rowid => NULL,
8581: p_to_rowid => NULL

Line 8578: gmf_migration.Log_Errors (

8574: * ADR Rules Migration Error Logging *
8575: ************************************/
8576: gmf_migration.G_Table_name := 'XLA_RULES_T';
8577: gmf_migration.G_context := 'GMF Error Logging';
8578: gmf_migration.Log_Errors (
8579: p_log_level => 1,
8580: p_from_rowid => NULL,
8581: p_to_rowid => NULL
8582: );

Line 8586: gmf_migration.G_Table_name := 'XLA_RULE_DETAILS_T';

8582: );
8583: /*******************************************
8584: * ADR Rule Details Migration Error Logging *
8585: *******************************************/
8586: gmf_migration.G_Table_name := 'XLA_RULE_DETAILS_T';
8587: gmf_migration.G_context := 'GMF Error Logging';
8588: gmf_migration.Log_Errors (
8589: p_log_level => 1,
8590: p_from_rowid => NULL,

Line 8587: gmf_migration.G_context := 'GMF Error Logging';

8583: /*******************************************
8584: * ADR Rule Details Migration Error Logging *
8585: *******************************************/
8586: gmf_migration.G_Table_name := 'XLA_RULE_DETAILS_T';
8587: gmf_migration.G_context := 'GMF Error Logging';
8588: gmf_migration.Log_Errors (
8589: p_log_level => 1,
8590: p_from_rowid => NULL,
8591: p_to_rowid => NULL

Line 8588: gmf_migration.Log_Errors (

8584: * ADR Rule Details Migration Error Logging *
8585: *******************************************/
8586: gmf_migration.G_Table_name := 'XLA_RULE_DETAILS_T';
8587: gmf_migration.G_context := 'GMF Error Logging';
8588: gmf_migration.Log_Errors (
8589: p_log_level => 1,
8590: p_from_rowid => NULL,
8591: p_to_rowid => NULL
8592: );

Line 8596: gmf_migration.G_Table_name := 'XLA_CONDITIONS_T';

8592: );
8593: /*****************************************
8594: * ADR Conditions Migration Error Logging *
8595: *****************************************/
8596: gmf_migration.G_Table_name := 'XLA_CONDITIONS_T';
8597: gmf_migration.G_context := 'GMF Error Logging';
8598: gmf_migration.Log_Errors (
8599: p_log_level => 1,
8600: p_from_rowid => NULL,

Line 8597: gmf_migration.G_context := 'GMF Error Logging';

8593: /*****************************************
8594: * ADR Conditions Migration Error Logging *
8595: *****************************************/
8596: gmf_migration.G_Table_name := 'XLA_CONDITIONS_T';
8597: gmf_migration.G_context := 'GMF Error Logging';
8598: gmf_migration.Log_Errors (
8599: p_log_level => 1,
8600: p_from_rowid => NULL,
8601: p_to_rowid => NULL

Line 8598: gmf_migration.Log_Errors (

8594: * ADR Conditions Migration Error Logging *
8595: *****************************************/
8596: gmf_migration.G_Table_name := 'XLA_CONDITIONS_T';
8597: gmf_migration.G_context := 'GMF Error Logging';
8598: gmf_migration.Log_Errors (
8599: p_log_level => 1,
8600: p_from_rowid => NULL,
8601: p_to_rowid => NULL
8602: );

Line 8606: gmf_migration.G_Table_name := 'XLA_LINE_ASSGNS_T';

8602: );
8603: /***********************************************
8604: * ADR Line Assignments Migration Error Logging *
8605: ***********************************************/
8606: gmf_migration.G_Table_name := 'XLA_LINE_ASSGNS_T';
8607: gmf_migration.G_context := 'GMF Error Logging';
8608: gmf_migration.Log_Errors (
8609: p_log_level => 1,
8610: p_from_rowid => NULL,

Line 8607: gmf_migration.G_context := 'GMF Error Logging';

8603: /***********************************************
8604: * ADR Line Assignments Migration Error Logging *
8605: ***********************************************/
8606: gmf_migration.G_Table_name := 'XLA_LINE_ASSGNS_T';
8607: gmf_migration.G_context := 'GMF Error Logging';
8608: gmf_migration.Log_Errors (
8609: p_log_level => 1,
8610: p_from_rowid => NULL,
8611: p_to_rowid => NULL

Line 8608: gmf_migration.Log_Errors (

8604: * ADR Line Assignments Migration Error Logging *
8605: ***********************************************/
8606: gmf_migration.G_Table_name := 'XLA_LINE_ASSGNS_T';
8607: gmf_migration.G_context := 'GMF Error Logging';
8608: gmf_migration.Log_Errors (
8609: p_log_level => 1,
8610: p_from_rowid => NULL,
8611: p_to_rowid => NULL
8612: );

Line 8844: p_run_id => gmf_migration.G_migration_run_id,

8840: **************************************/
8841:
8842: GMA_COMMON_LOGGING.gma_migration_central_log
8843: (
8844: p_run_id => gmf_migration.G_migration_run_id,
8845: p_log_level => FND_LOG.LEVEL_PROCEDURE,
8846: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
8847: p_table_name => gmf_migration.G_Table_name,
8848: p_context => gmf_migration.G_context,

Line 8847: p_table_name => gmf_migration.G_Table_name,

8843: (
8844: p_run_id => gmf_migration.G_migration_run_id,
8845: p_log_level => FND_LOG.LEVEL_PROCEDURE,
8846: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
8847: p_table_name => gmf_migration.G_Table_name,
8848: p_context => gmf_migration.G_context,
8849: p_db_error => NULL,
8850: p_app_short_name => 'GMA'
8851: );

Line 8848: p_context => gmf_migration.G_context,

8844: p_run_id => gmf_migration.G_migration_run_id,
8845: p_log_level => FND_LOG.LEVEL_PROCEDURE,
8846: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
8847: p_table_name => gmf_migration.G_Table_name,
8848: p_context => gmf_migration.G_context,
8849: p_db_error => NULL,
8850: p_app_short_name => 'GMA'
8851: );
8852:

Line 9101: p_migration_run_id => gmf_migration.G_migration_run_id,

9097: l_failure_count := 0;
9098:
9099: IF (bal.lot_id > 0) THEN -- Lot controlled item
9100: INV_OPM_Lot_Migration.get_ODM_lot (
9101: p_migration_run_id => gmf_migration.G_migration_run_id,
9102: p_item_id => bal.item_id,
9103: p_lot_id => bal.lot_id,
9104: p_whse_code => bal.whse_code,
9105: p_orgn_code => NULL,

Line 9117: p_run_id => gmf_migration.G_migration_run_id,

9113: IF (l_failure_count > 0) THEN
9114: -- Log Error
9115: -- dbms_output.put_line ('Failed to migrate lot = '||to_char(bal.lot_id)||', '||bal.whse_code||', '||bal.location);
9116: GMA_COMMON_LOGGING.gma_migration_central_log (
9117: p_run_id => gmf_migration.G_migration_run_id,
9118: p_log_level => FND_LOG.LEVEL_ERROR,
9119: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
9120: p_table_name => gmf_migration.G_Table_name,
9121: p_context => gmf_migration.G_context,

Line 9120: p_table_name => gmf_migration.G_Table_name,

9116: GMA_COMMON_LOGGING.gma_migration_central_log (
9117: p_run_id => gmf_migration.G_migration_run_id,
9118: p_log_level => FND_LOG.LEVEL_ERROR,
9119: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
9120: p_table_name => gmf_migration.G_Table_name,
9121: p_context => gmf_migration.G_context,
9122: p_param1 => INV_GMI_Migration.item(bal.item_id),
9123: p_param2 => INV_GMI_Migration.lot(bal.lot_id),
9124: p_param3 => bal.whse_code,

Line 9121: p_context => gmf_migration.G_context,

9117: p_run_id => gmf_migration.G_migration_run_id,
9118: p_log_level => FND_LOG.LEVEL_ERROR,
9119: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
9120: p_table_name => gmf_migration.G_Table_name,
9121: p_context => gmf_migration.G_context,
9122: p_param1 => INV_GMI_Migration.item(bal.item_id),
9123: p_param2 => INV_GMI_Migration.lot(bal.lot_id),
9124: p_param3 => bal.whse_code,
9125: /* p_param4 => bal.location, Bug 13942118 */

Line 9335: p_run_id => gmf_migration.G_migration_run_id,

9331: **************************************/
9332:
9333: GMA_COMMON_LOGGING.gma_migration_central_log
9334: (
9335: p_run_id => gmf_migration.G_migration_run_id,
9336: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9337: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9338: p_table_name => gmf_migration.G_Table_name,
9339: p_context => gmf_migration.G_context,

Line 9338: p_table_name => gmf_migration.G_Table_name,

9334: (
9335: p_run_id => gmf_migration.G_migration_run_id,
9336: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9337: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9338: p_table_name => gmf_migration.G_Table_name,
9339: p_context => gmf_migration.G_context,
9340: p_db_error => NULL,
9341: p_app_short_name => 'GMA'
9342: );

Line 9339: p_context => gmf_migration.G_context,

9335: p_run_id => gmf_migration.G_migration_run_id,
9336: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9337: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9338: p_table_name => gmf_migration.G_Table_name,
9339: p_context => gmf_migration.G_context,
9340: p_db_error => NULL,
9341: p_app_short_name => 'GMA'
9342: );
9343:

Line 9555: SELECT gmf_migration.get_account_id(a.account_key, x.co_code)

9551: BEGIN
9552:
9553: UPDATE gl_aloc_inp a
9554: SET a.account_id = (
9555: SELECT gmf_migration.get_account_id(a.account_key, x.co_code)
9556: FROM gl_aloc_mst x
9557: WHERE x.alloc_id = a.alloc_id
9558: )
9559: WHERE (account_id IS NULL AND a.account_key IS NOT NULL);

Line 9622: p_run_id => gmf_migration.G_migration_run_id,

9618: **************************************/
9619:
9620: GMA_COMMON_LOGGING.gma_migration_central_log
9621: (
9622: p_run_id => gmf_migration.G_migration_run_id,
9623: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9624: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9625: p_table_name => gmf_migration.G_Table_name,
9626: p_context => gmf_migration.G_context,

Line 9625: p_table_name => gmf_migration.G_Table_name,

9621: (
9622: p_run_id => gmf_migration.G_migration_run_id,
9623: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9624: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9625: p_table_name => gmf_migration.G_Table_name,
9626: p_context => gmf_migration.G_context,
9627: p_db_error => NULL,
9628: p_app_short_name => 'GMA'
9629: );

Line 9626: p_context => gmf_migration.G_context,

9622: p_run_id => gmf_migration.G_migration_run_id,
9623: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9624: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9625: p_table_name => gmf_migration.G_Table_name,
9626: p_context => gmf_migration.G_context,
9627: p_db_error => NULL,
9628: p_app_short_name => 'GMA'
9629: );
9630:

Line 9816: p_run_id => gmf_migration.G_migration_run_id,

9812: **************************************/
9813:
9814: GMA_COMMON_LOGGING.gma_migration_central_log
9815: (
9816: p_run_id => gmf_migration.G_migration_run_id,
9817: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9818: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9819: p_table_name => gmf_migration.G_Table_name,
9820: p_context => gmf_migration.G_context,

Line 9819: p_table_name => gmf_migration.G_Table_name,

9815: (
9816: p_run_id => gmf_migration.G_migration_run_id,
9817: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9818: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9819: p_table_name => gmf_migration.G_Table_name,
9820: p_context => gmf_migration.G_context,
9821: p_db_error => NULL,
9822: p_app_short_name => 'GMA'
9823: );

Line 9820: p_context => gmf_migration.G_context,

9816: p_run_id => gmf_migration.G_migration_run_id,
9817: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9818: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9819: p_table_name => gmf_migration.G_Table_name,
9820: p_context => gmf_migration.G_context,
9821: p_db_error => NULL,
9822: p_app_short_name => 'GMA'
9823: );
9824:

Line 10079: p_run_id => gmf_migration.G_migration_run_id,

10075: **************************************/
10076:
10077: GMA_COMMON_LOGGING.gma_migration_central_log
10078: (
10079: p_run_id => gmf_migration.G_migration_run_id,
10080: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10081: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10082: p_table_name => gmf_migration.G_Table_name,
10083: p_context => gmf_migration.G_context,

Line 10082: p_table_name => gmf_migration.G_Table_name,

10078: (
10079: p_run_id => gmf_migration.G_migration_run_id,
10080: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10081: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10082: p_table_name => gmf_migration.G_Table_name,
10083: p_context => gmf_migration.G_context,
10084: p_db_error => NULL,
10085: p_app_short_name => 'GMA'
10086: );

Line 10083: p_context => gmf_migration.G_context,

10079: p_run_id => gmf_migration.G_migration_run_id,
10080: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10081: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10082: p_table_name => gmf_migration.G_Table_name,
10083: p_context => gmf_migration.G_context,
10084: p_db_error => NULL,
10085: p_app_short_name => 'GMA'
10086: );
10087:

Line 10396: p_run_id => gmf_migration.G_migration_run_id,

10392: **************************************/
10393:
10394: GMA_COMMON_LOGGING.gma_migration_central_log
10395: (
10396: p_run_id => gmf_migration.G_migration_run_id,
10397: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10398: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10399: p_table_name => gmf_migration.G_Table_name,
10400: p_context => gmf_migration.G_context,

Line 10399: p_table_name => gmf_migration.G_Table_name,

10395: (
10396: p_run_id => gmf_migration.G_migration_run_id,
10397: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10398: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10399: p_table_name => gmf_migration.G_Table_name,
10400: p_context => gmf_migration.G_context,
10401: p_db_error => NULL,
10402: p_app_short_name => 'GMA'
10403: );

Line 10400: p_context => gmf_migration.G_context,

10396: p_run_id => gmf_migration.G_migration_run_id,
10397: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10398: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10399: p_table_name => gmf_migration.G_Table_name,
10400: p_context => gmf_migration.G_context,
10401: p_db_error => NULL,
10402: p_app_short_name => 'GMA'
10403: );
10404:

Line 10580: p_run_id => gmf_migration.G_migration_run_id,

10576: **************************************/
10577:
10578: GMA_COMMON_LOGGING.gma_migration_central_log
10579: (
10580: p_run_id => gmf_migration.G_migration_run_id,
10581: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10582: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10583: p_table_name => gmf_migration.G_Table_name,
10584: p_context => gmf_migration.G_context,

Line 10583: p_table_name => gmf_migration.G_Table_name,

10579: (
10580: p_run_id => gmf_migration.G_migration_run_id,
10581: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10582: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10583: p_table_name => gmf_migration.G_Table_name,
10584: p_context => gmf_migration.G_context,
10585: p_db_error => NULL,
10586: p_app_short_name => 'GMA'
10587: );

Line 10584: p_context => gmf_migration.G_context,

10580: p_run_id => gmf_migration.G_migration_run_id,
10581: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10582: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10583: p_table_name => gmf_migration.G_Table_name,
10584: p_context => gmf_migration.G_context,
10585: p_db_error => NULL,
10586: p_app_short_name => 'GMA'
10587: );
10588:

Line 10834: gmf_migration.Log_Errors (

10830:
10831: /**********************************************
10832: * Handle all the rows which were not migrated *
10833: **********************************************/
10834: gmf_migration.Log_Errors (
10835: p_log_level => 1,
10836: p_from_rowid => NULL,
10837: p_to_rowid => NULL
10838: );

Line 11252: gmf_migration.Log_Errors (

11248:
11249: /**********************************************
11250: * Handle all the rows which were not migrated *
11251: **********************************************/
11252: gmf_migration.Log_Errors (
11253: p_log_level => 1,
11254: p_from_rowid => NULL,
11255: p_to_rowid => NULL
11256: );

Line 11467: gmf_migration.Log_Errors (

11463:
11464: /**********************************************
11465: * Handle all the rows which were not migrated *
11466: **********************************************/
11467: gmf_migration.Log_Errors (
11468: p_log_level => 1,
11469: p_from_rowid => NULL,
11470: p_to_rowid => NULL
11471: );

Line 11565: gmf_migration.Log_Errors (

11561:
11562: /**********************************************
11563: * Handle all the rows which were not migrated *
11564: **********************************************/
11565: gmf_migration.Log_Errors (
11566: p_log_level => 1,
11567: p_from_rowid => NULL,
11568: p_to_rowid => NULL
11569: );

Line 11755: gmf_migration.Log_Errors (

11751:
11752: /**********************************************
11753: * Handle all the rows which were not migrated *
11754: **********************************************/
11755: gmf_migration.Log_Errors (
11756: p_log_level => 1,
11757: p_from_rowid => NULL,
11758: p_to_rowid => NULL
11759: );

Line 12011: gmf_migration.Log_Errors (

12007:
12008: /**********************************************
12009: * Handle all the rows which were not migrated *
12010: **********************************************/
12011: gmf_migration.Log_Errors (
12012: p_log_level => 1,
12013: p_from_rowid => NULL,
12014: p_to_rowid => NULL
12015: );

Line 12260: p_run_id => gmf_migration.G_migration_run_id,

12256: **************************************/
12257:
12258: GMA_COMMON_LOGGING.gma_migration_central_log
12259: (
12260: p_run_id => gmf_migration.G_migration_run_id,
12261: p_log_level => FND_LOG.LEVEL_PROCEDURE,
12262: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
12263: p_table_name => gmf_migration.G_Table_name,
12264: p_context => gmf_migration.G_context,

Line 12263: p_table_name => gmf_migration.G_Table_name,

12259: (
12260: p_run_id => gmf_migration.G_migration_run_id,
12261: p_log_level => FND_LOG.LEVEL_PROCEDURE,
12262: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
12263: p_table_name => gmf_migration.G_Table_name,
12264: p_context => gmf_migration.G_context,
12265: p_db_error => NULL,
12266: p_app_short_name => 'GMA'
12267: );

Line 12264: p_context => gmf_migration.G_context,

12260: p_run_id => gmf_migration.G_migration_run_id,
12261: p_log_level => FND_LOG.LEVEL_PROCEDURE,
12262: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
12263: p_table_name => gmf_migration.G_Table_name,
12264: p_context => gmf_migration.G_context,
12265: p_db_error => NULL,
12266: p_app_short_name => 'GMA'
12267: );
12268:

Line 12374: l_table_name VARCHAR2(256) := gmf_migration.G_Table_name;

12370: /******************
12371: * Local Variables *
12372: ******************/
12373: l_error_tbl p_error_tbl;
12374: l_table_name VARCHAR2(256) := gmf_migration.G_Table_name;
12375: l_sql_statement VARCHAR2(32000) := 'SELECT count(*) FROM '||l_table_name||' WHERE ';
12376: l_failure_count NUMBER;
12377: l_legal_entity_count PLS_INTEGER := 0;
12378: l_organization_count PLS_INTEGER := 0;

Line 14074: p_run_id => gmf_migration.G_migration_run_id,

14070: * Migration Failure Log Message *
14071: **************************************/
14072: GMA_COMMON_LOGGING.gma_migration_central_log
14073: (
14074: p_run_id => gmf_migration.G_migration_run_id,
14075: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14076: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
14077: p_table_name => gmf_migration.G_Table_name,
14078: p_context => gmf_migration.G_context,

Line 14077: p_table_name => gmf_migration.G_Table_name,

14073: (
14074: p_run_id => gmf_migration.G_migration_run_id,
14075: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14076: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
14077: p_table_name => gmf_migration.G_Table_name,
14078: p_context => gmf_migration.G_context,
14079: p_db_error => NULL,
14080: p_app_short_name => 'GMA'
14081: );

Line 14078: p_context => gmf_migration.G_context,

14074: p_run_id => gmf_migration.G_migration_run_id,
14075: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14076: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
14077: p_table_name => gmf_migration.G_Table_name,
14078: p_context => gmf_migration.G_context,
14079: p_db_error => NULL,
14080: p_app_short_name => 'GMA'
14081: );
14082: ELSE

Line 14088: p_run_id => gmf_migration.G_migration_run_id,

14084: * Migration Success Log Message *
14085: **************************************/
14086: GMA_COMMON_LOGGING.gma_migration_central_log
14087: (
14088: p_run_id => gmf_migration.G_migration_run_id,
14089: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14090: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14091: p_table_name => gmf_migration.G_Table_name,
14092: p_context => gmf_migration.G_context,

Line 14091: p_table_name => gmf_migration.G_Table_name,

14087: (
14088: p_run_id => gmf_migration.G_migration_run_id,
14089: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14090: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14091: p_table_name => gmf_migration.G_Table_name,
14092: p_context => gmf_migration.G_context,
14093: p_param1 => 1,
14094: p_param2 => 0,
14095: p_db_error => NULL,

Line 14092: p_context => gmf_migration.G_context,

14088: p_run_id => gmf_migration.G_migration_run_id,
14089: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14090: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14091: p_table_name => gmf_migration.G_Table_name,
14092: p_context => gmf_migration.G_context,
14093: p_param1 => 1,
14094: p_param2 => 0,
14095: p_db_error => NULL,
14096: p_app_short_name => 'GMA'

Line 14113: p_run_id => gmf_migration.G_migration_run_id,

14109: ***********************************/
14110: IF nvl(l_legal_entity_count,0) > 0 THEN
14111: GMA_COMMON_LOGGING.gma_migration_central_log
14112: (
14113: p_run_id => gmf_migration.G_migration_run_id,
14114: p_log_level => FND_LOG.LEVEL_ERROR,
14115: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14116: p_table_name => gmf_migration.G_Table_name,
14117: p_context => gmf_migration.G_Context,

Line 14116: p_table_name => gmf_migration.G_Table_name,

14112: (
14113: p_run_id => gmf_migration.G_migration_run_id,
14114: p_log_level => FND_LOG.LEVEL_ERROR,
14115: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14116: p_table_name => gmf_migration.G_Table_name,
14117: p_context => gmf_migration.G_Context,
14118: p_token1 => 'TABLE_NAME',
14119: p_token2 => 'COLUMN_NAME',
14120: p_token3 => 'RECORD_COUNT',

Line 14117: p_context => gmf_migration.G_Context,

14113: p_run_id => gmf_migration.G_migration_run_id,
14114: p_log_level => FND_LOG.LEVEL_ERROR,
14115: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14116: p_table_name => gmf_migration.G_Table_name,
14117: p_context => gmf_migration.G_Context,
14118: p_token1 => 'TABLE_NAME',
14119: p_token2 => 'COLUMN_NAME',
14120: p_token3 => 'RECORD_COUNT',
14121: p_param1 => gmf_migration.G_Table_name,

Line 14121: p_param1 => gmf_migration.G_Table_name,

14117: p_context => gmf_migration.G_Context,
14118: p_token1 => 'TABLE_NAME',
14119: p_token2 => 'COLUMN_NAME',
14120: p_token3 => 'RECORD_COUNT',
14121: p_param1 => gmf_migration.G_Table_name,
14122: p_param2 => 'Legal Entities',
14123: p_param3 => l_legal_entity_count,
14124: p_db_error => NULL,
14125: p_app_short_name => 'GMA'

Line 14134: p_run_id => gmf_migration.G_migration_run_id,

14130: ***********************************/
14131: IF nvl(l_organization_count,0) > 0 THEN
14132: GMA_COMMON_LOGGING.gma_migration_central_log
14133: (
14134: p_run_id => gmf_migration.G_migration_run_id,
14135: p_log_level => FND_LOG.LEVEL_ERROR,
14136: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14137: p_table_name => gmf_migration.G_Table_name,
14138: p_context => gmf_migration.G_Context,

Line 14137: p_table_name => gmf_migration.G_Table_name,

14133: (
14134: p_run_id => gmf_migration.G_migration_run_id,
14135: p_log_level => FND_LOG.LEVEL_ERROR,
14136: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14137: p_table_name => gmf_migration.G_Table_name,
14138: p_context => gmf_migration.G_Context,
14139: p_token1 => 'TABLE_NAME',
14140: p_token2 => 'COLUMN_NAME',
14141: p_token3 => 'RECORD_COUNT',

Line 14138: p_context => gmf_migration.G_Context,

14134: p_run_id => gmf_migration.G_migration_run_id,
14135: p_log_level => FND_LOG.LEVEL_ERROR,
14136: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14137: p_table_name => gmf_migration.G_Table_name,
14138: p_context => gmf_migration.G_Context,
14139: p_token1 => 'TABLE_NAME',
14140: p_token2 => 'COLUMN_NAME',
14141: p_token3 => 'RECORD_COUNT',
14142: p_param1 => gmf_migration.G_Table_name,

Line 14142: p_param1 => gmf_migration.G_Table_name,

14138: p_context => gmf_migration.G_Context,
14139: p_token1 => 'TABLE_NAME',
14140: p_token2 => 'COLUMN_NAME',
14141: p_token3 => 'RECORD_COUNT',
14142: p_param1 => gmf_migration.G_Table_name,
14143: p_param2 => 'Organizations',
14144: p_param3 => l_organization_count,
14145: p_db_error => NULL,
14146: p_app_short_name => 'GMA'

Line 14155: p_run_id => gmf_migration.G_migration_run_id,

14151: ******************************************/
14152: IF nvl(l_source_organization_count,0) > 0 THEN
14153: GMA_COMMON_LOGGING.gma_migration_central_log
14154: (
14155: p_run_id => gmf_migration.G_migration_run_id,
14156: p_log_level => FND_LOG.LEVEL_ERROR,
14157: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14158: p_table_name => gmf_migration.G_Table_name,
14159: p_context => gmf_migration.G_Context,

Line 14158: p_table_name => gmf_migration.G_Table_name,

14154: (
14155: p_run_id => gmf_migration.G_migration_run_id,
14156: p_log_level => FND_LOG.LEVEL_ERROR,
14157: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14158: p_table_name => gmf_migration.G_Table_name,
14159: p_context => gmf_migration.G_Context,
14160: p_token1 => 'TABLE_NAME',
14161: p_token2 => 'COLUMN_NAME',
14162: p_token3 => 'RECORD_COUNT',

Line 14159: p_context => gmf_migration.G_Context,

14155: p_run_id => gmf_migration.G_migration_run_id,
14156: p_log_level => FND_LOG.LEVEL_ERROR,
14157: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14158: p_table_name => gmf_migration.G_Table_name,
14159: p_context => gmf_migration.G_Context,
14160: p_token1 => 'TABLE_NAME',
14161: p_token2 => 'COLUMN_NAME',
14162: p_token3 => 'RECORD_COUNT',
14163: p_param1 => gmf_migration.G_Table_name,

Line 14163: p_param1 => gmf_migration.G_Table_name,

14159: p_context => gmf_migration.G_Context,
14160: p_token1 => 'TABLE_NAME',
14161: p_token2 => 'COLUMN_NAME',
14162: p_token3 => 'RECORD_COUNT',
14163: p_param1 => gmf_migration.G_Table_name,
14164: p_param2 => 'Source Organizations',
14165: p_param3 => l_source_organization_count,
14166: p_db_error => NULL,
14167: p_app_short_name => 'GMA'

Line 14176: p_run_id => gmf_migration.G_migration_run_id,

14172: ******************************************/
14173: IF nvl(l_master_organization_count,0) > 0 THEN
14174: GMA_COMMON_LOGGING.gma_migration_central_log
14175: (
14176: p_run_id => gmf_migration.G_migration_run_id,
14177: p_log_level => FND_LOG.LEVEL_ERROR,
14178: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14179: p_table_name => gmf_migration.G_Table_name,
14180: p_context => gmf_migration.G_Context,

Line 14179: p_table_name => gmf_migration.G_Table_name,

14175: (
14176: p_run_id => gmf_migration.G_migration_run_id,
14177: p_log_level => FND_LOG.LEVEL_ERROR,
14178: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14179: p_table_name => gmf_migration.G_Table_name,
14180: p_context => gmf_migration.G_Context,
14181: p_token1 => 'TABLE_NAME',
14182: p_token2 => 'COLUMN_NAME',
14183: p_token3 => 'RECORD_COUNT',

Line 14180: p_context => gmf_migration.G_Context,

14176: p_run_id => gmf_migration.G_migration_run_id,
14177: p_log_level => FND_LOG.LEVEL_ERROR,
14178: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14179: p_table_name => gmf_migration.G_Table_name,
14180: p_context => gmf_migration.G_Context,
14181: p_token1 => 'TABLE_NAME',
14182: p_token2 => 'COLUMN_NAME',
14183: p_token3 => 'RECORD_COUNT',
14184: p_param1 => gmf_migration.G_Table_name,

Line 14184: p_param1 => gmf_migration.G_Table_name,

14180: p_context => gmf_migration.G_Context,
14181: p_token1 => 'TABLE_NAME',
14182: p_token2 => 'COLUMN_NAME',
14183: p_token3 => 'RECORD_COUNT',
14184: p_param1 => gmf_migration.G_Table_name,
14185: p_param2 => 'Master Organizations',
14186: p_param3 => l_master_organization_count,
14187: p_db_error => NULL,
14188: p_app_short_name => 'GMA'

Line 14197: p_run_id => gmf_migration.G_migration_run_id,

14193: ***************************/
14194: IF nvl(l_inventory_item_count,0) > 0 THEN
14195: GMA_COMMON_LOGGING.gma_migration_central_log
14196: (
14197: p_run_id => gmf_migration.G_migration_run_id,
14198: p_log_level => FND_LOG.LEVEL_ERROR,
14199: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14200: p_table_name => gmf_migration.G_Table_name,
14201: p_context => gmf_migration.G_Context,

Line 14200: p_table_name => gmf_migration.G_Table_name,

14196: (
14197: p_run_id => gmf_migration.G_migration_run_id,
14198: p_log_level => FND_LOG.LEVEL_ERROR,
14199: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14200: p_table_name => gmf_migration.G_Table_name,
14201: p_context => gmf_migration.G_Context,
14202: p_token1 => 'TABLE_NAME',
14203: p_token2 => 'COLUMN_NAME',
14204: p_token3 => 'RECORD_COUNT',

Line 14201: p_context => gmf_migration.G_Context,

14197: p_run_id => gmf_migration.G_migration_run_id,
14198: p_log_level => FND_LOG.LEVEL_ERROR,
14199: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14200: p_table_name => gmf_migration.G_Table_name,
14201: p_context => gmf_migration.G_Context,
14202: p_token1 => 'TABLE_NAME',
14203: p_token2 => 'COLUMN_NAME',
14204: p_token3 => 'RECORD_COUNT',
14205: p_param1 => gmf_migration.G_Table_name,

Line 14205: p_param1 => gmf_migration.G_Table_name,

14201: p_context => gmf_migration.G_Context,
14202: p_token1 => 'TABLE_NAME',
14203: p_token2 => 'COLUMN_NAME',
14204: p_token3 => 'RECORD_COUNT',
14205: p_param1 => gmf_migration.G_Table_name,
14206: p_param2 => 'Items',
14207: p_param3 => l_inventory_item_count,
14208: p_db_error => NULL,
14209: p_app_short_name => 'GMA'

Line 14218: p_run_id => gmf_migration.G_migration_run_id,

14214: ***********************************/
14215: IF nvl(l_cost_type_count,0) > 0 THEN
14216: GMA_COMMON_LOGGING.gma_migration_central_log
14217: (
14218: p_run_id => gmf_migration.G_migration_run_id,
14219: p_log_level => FND_LOG.LEVEL_ERROR,
14220: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14221: p_table_name => gmf_migration.G_Table_name,
14222: p_context => gmf_migration.G_Context,

Line 14221: p_table_name => gmf_migration.G_Table_name,

14217: (
14218: p_run_id => gmf_migration.G_migration_run_id,
14219: p_log_level => FND_LOG.LEVEL_ERROR,
14220: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14221: p_table_name => gmf_migration.G_Table_name,
14222: p_context => gmf_migration.G_Context,
14223: p_token1 => 'TABLE_NAME',
14224: p_token2 => 'COLUMN_NAME',
14225: p_token3 => 'RECORD_COUNT',

Line 14222: p_context => gmf_migration.G_Context,

14218: p_run_id => gmf_migration.G_migration_run_id,
14219: p_log_level => FND_LOG.LEVEL_ERROR,
14220: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14221: p_table_name => gmf_migration.G_Table_name,
14222: p_context => gmf_migration.G_Context,
14223: p_token1 => 'TABLE_NAME',
14224: p_token2 => 'COLUMN_NAME',
14225: p_token3 => 'RECORD_COUNT',
14226: p_param1 => gmf_migration.G_Table_name,

Line 14226: p_param1 => gmf_migration.G_Table_name,

14222: p_context => gmf_migration.G_Context,
14223: p_token1 => 'TABLE_NAME',
14224: p_token2 => 'COLUMN_NAME',
14225: p_token3 => 'RECORD_COUNT',
14226: p_param1 => gmf_migration.G_Table_name,
14227: p_param2 => 'Cost Types',
14228: p_param3 => l_cost_type_count,
14229: p_db_error => NULL,
14230: p_app_short_name => 'GMA'

Line 14239: p_run_id => gmf_migration.G_migration_run_id,

14235: ********************************************/
14236: IF nvl(l_prev_cost_type_count,0) > 0 THEN
14237: GMA_COMMON_LOGGING.gma_migration_central_log
14238: (
14239: p_run_id => gmf_migration.G_migration_run_id,
14240: p_log_level => FND_LOG.LEVEL_ERROR,
14241: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14242: p_table_name => gmf_migration.G_Table_name,
14243: p_context => gmf_migration.G_Context,

Line 14242: p_table_name => gmf_migration.G_Table_name,

14238: (
14239: p_run_id => gmf_migration.G_migration_run_id,
14240: p_log_level => FND_LOG.LEVEL_ERROR,
14241: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14242: p_table_name => gmf_migration.G_Table_name,
14243: p_context => gmf_migration.G_Context,
14244: p_token1 => 'TABLE_NAME',
14245: p_token2 => 'COLUMN_NAME',
14246: p_token3 => 'RECORD_COUNT',

Line 14243: p_context => gmf_migration.G_Context,

14239: p_run_id => gmf_migration.G_migration_run_id,
14240: p_log_level => FND_LOG.LEVEL_ERROR,
14241: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14242: p_table_name => gmf_migration.G_Table_name,
14243: p_context => gmf_migration.G_Context,
14244: p_token1 => 'TABLE_NAME',
14245: p_token2 => 'COLUMN_NAME',
14246: p_token3 => 'RECORD_COUNT',
14247: p_param1 => gmf_migration.G_Table_name,

Line 14247: p_param1 => gmf_migration.G_Table_name,

14243: p_context => gmf_migration.G_Context,
14244: p_token1 => 'TABLE_NAME',
14245: p_token2 => 'COLUMN_NAME',
14246: p_token3 => 'RECORD_COUNT',
14247: p_param1 => gmf_migration.G_Table_name,
14248: p_param2 => 'Previous Cost Types',
14249: p_param3 => l_prev_cost_type_count,
14250: p_db_error => NULL,
14251: p_app_short_name => 'GMA'

Line 14260: p_run_id => gmf_migration.G_migration_run_id,

14256: *******************************************/
14257: IF nvl(l_curr_cost_type_count,0) > 0 THEN
14258: GMA_COMMON_LOGGING.gma_migration_central_log
14259: (
14260: p_run_id => gmf_migration.G_migration_run_id,
14261: p_log_level => FND_LOG.LEVEL_ERROR,
14262: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14263: p_table_name => gmf_migration.G_Table_name,
14264: p_context => gmf_migration.G_Context,

Line 14263: p_table_name => gmf_migration.G_Table_name,

14259: (
14260: p_run_id => gmf_migration.G_migration_run_id,
14261: p_log_level => FND_LOG.LEVEL_ERROR,
14262: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14263: p_table_name => gmf_migration.G_Table_name,
14264: p_context => gmf_migration.G_Context,
14265: p_token1 => 'TABLE_NAME',
14266: p_token2 => 'COLUMN_NAME',
14267: p_token3 => 'RECORD_COUNT',

Line 14264: p_context => gmf_migration.G_Context,

14260: p_run_id => gmf_migration.G_migration_run_id,
14261: p_log_level => FND_LOG.LEVEL_ERROR,
14262: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14263: p_table_name => gmf_migration.G_Table_name,
14264: p_context => gmf_migration.G_Context,
14265: p_token1 => 'TABLE_NAME',
14266: p_token2 => 'COLUMN_NAME',
14267: p_token3 => 'RECORD_COUNT',
14268: p_param1 => gmf_migration.G_Table_name,

Line 14268: p_param1 => gmf_migration.G_Table_name,

14264: p_context => gmf_migration.G_Context,
14265: p_token1 => 'TABLE_NAME',
14266: p_token2 => 'COLUMN_NAME',
14267: p_token3 => 'RECORD_COUNT',
14268: p_param1 => gmf_migration.G_Table_name,
14269: p_param2 => 'Current Cost Types',
14270: p_param3 => l_curr_cost_type_count,
14271: p_db_error => NULL,
14272: p_app_short_name => 'GMA'

Line 14281: p_run_id => gmf_migration.G_migration_run_id,

14277: ***********************************/
14278: IF nvl(l_period_count,0) > 0 THEN
14279: GMA_COMMON_LOGGING.gma_migration_central_log
14280: (
14281: p_run_id => gmf_migration.G_migration_run_id,
14282: p_log_level => FND_LOG.LEVEL_ERROR,
14283: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14284: p_table_name => gmf_migration.G_Table_name,
14285: p_context => gmf_migration.G_Context,

Line 14284: p_table_name => gmf_migration.G_Table_name,

14280: (
14281: p_run_id => gmf_migration.G_migration_run_id,
14282: p_log_level => FND_LOG.LEVEL_ERROR,
14283: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14284: p_table_name => gmf_migration.G_Table_name,
14285: p_context => gmf_migration.G_Context,
14286: p_token1 => 'TABLE_NAME',
14287: p_token2 => 'COLUMN_NAME',
14288: p_token3 => 'RECORD_COUNT',

Line 14285: p_context => gmf_migration.G_Context,

14281: p_run_id => gmf_migration.G_migration_run_id,
14282: p_log_level => FND_LOG.LEVEL_ERROR,
14283: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14284: p_table_name => gmf_migration.G_Table_name,
14285: p_context => gmf_migration.G_Context,
14286: p_token1 => 'TABLE_NAME',
14287: p_token2 => 'COLUMN_NAME',
14288: p_token3 => 'RECORD_COUNT',
14289: p_param1 => gmf_migration.G_Table_name,

Line 14289: p_param1 => gmf_migration.G_Table_name,

14285: p_context => gmf_migration.G_Context,
14286: p_token1 => 'TABLE_NAME',
14287: p_token2 => 'COLUMN_NAME',
14288: p_token3 => 'RECORD_COUNT',
14289: p_param1 => gmf_migration.G_Table_name,
14290: p_param2 => 'Periods',
14291: p_param3 => l_period_count,
14292: p_db_error => NULL,
14293: p_app_short_name => 'GMA'

Line 14302: p_run_id => gmf_migration.G_migration_run_id,

14298: ********************************************/
14299: IF nvl(l_prev_period_count,0) > 0 THEN
14300: GMA_COMMON_LOGGING.gma_migration_central_log
14301: (
14302: p_run_id => gmf_migration.G_migration_run_id,
14303: p_log_level => FND_LOG.LEVEL_ERROR,
14304: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14305: p_table_name => gmf_migration.G_Table_name,
14306: p_context => gmf_migration.G_Context,

Line 14305: p_table_name => gmf_migration.G_Table_name,

14301: (
14302: p_run_id => gmf_migration.G_migration_run_id,
14303: p_log_level => FND_LOG.LEVEL_ERROR,
14304: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14305: p_table_name => gmf_migration.G_Table_name,
14306: p_context => gmf_migration.G_Context,
14307: p_token1 => 'TABLE_NAME',
14308: p_token2 => 'COLUMN_NAME',
14309: p_token3 => 'RECORD_COUNT',

Line 14306: p_context => gmf_migration.G_Context,

14302: p_run_id => gmf_migration.G_migration_run_id,
14303: p_log_level => FND_LOG.LEVEL_ERROR,
14304: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14305: p_table_name => gmf_migration.G_Table_name,
14306: p_context => gmf_migration.G_Context,
14307: p_token1 => 'TABLE_NAME',
14308: p_token2 => 'COLUMN_NAME',
14309: p_token3 => 'RECORD_COUNT',
14310: p_param1 => gmf_migration.G_Table_name,

Line 14310: p_param1 => gmf_migration.G_Table_name,

14306: p_context => gmf_migration.G_Context,
14307: p_token1 => 'TABLE_NAME',
14308: p_token2 => 'COLUMN_NAME',
14309: p_token3 => 'RECORD_COUNT',
14310: p_param1 => gmf_migration.G_Table_name,
14311: p_param2 => 'Previous Periods',
14312: p_param3 => l_prev_period_count,
14313: p_db_error => NULL,
14314: p_app_short_name => 'GMA'

Line 14323: p_run_id => gmf_migration.G_migration_run_id,

14319: ********************************************/
14320: IF nvl(l_curr_period_count,0) > 0 THEN
14321: GMA_COMMON_LOGGING.gma_migration_central_log
14322: (
14323: p_run_id => gmf_migration.G_migration_run_id,
14324: p_log_level => FND_LOG.LEVEL_ERROR,
14325: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14326: p_table_name => gmf_migration.G_Table_name,
14327: p_context => gmf_migration.G_Context,

Line 14326: p_table_name => gmf_migration.G_Table_name,

14322: (
14323: p_run_id => gmf_migration.G_migration_run_id,
14324: p_log_level => FND_LOG.LEVEL_ERROR,
14325: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14326: p_table_name => gmf_migration.G_Table_name,
14327: p_context => gmf_migration.G_Context,
14328: p_token1 => 'TABLE_NAME',
14329: p_token2 => 'COLUMN_NAME',
14330: p_token3 => 'RECORD_COUNT',

Line 14327: p_context => gmf_migration.G_Context,

14323: p_run_id => gmf_migration.G_migration_run_id,
14324: p_log_level => FND_LOG.LEVEL_ERROR,
14325: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14326: p_table_name => gmf_migration.G_Table_name,
14327: p_context => gmf_migration.G_Context,
14328: p_token1 => 'TABLE_NAME',
14329: p_token2 => 'COLUMN_NAME',
14330: p_token3 => 'RECORD_COUNT',
14331: p_param1 => gmf_migration.G_Table_name,

Line 14331: p_param1 => gmf_migration.G_Table_name,

14327: p_context => gmf_migration.G_Context,
14328: p_token1 => 'TABLE_NAME',
14329: p_token2 => 'COLUMN_NAME',
14330: p_token3 => 'RECORD_COUNT',
14331: p_param1 => gmf_migration.G_Table_name,
14332: p_param2 => 'Current Periods',
14333: p_param3 => l_curr_period_count,
14334: p_db_error => NULL,
14335: p_app_short_name => 'GMA'

Line 14344: p_run_id => gmf_migration.G_migration_run_id,

14340: ***********************************/
14341: IF nvl(l_uom_count1,0) > 0 THEN
14342: GMA_COMMON_LOGGING.gma_migration_central_log
14343: (
14344: p_run_id => gmf_migration.G_migration_run_id,
14345: p_log_level => FND_LOG.LEVEL_ERROR,
14346: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14347: p_table_name => gmf_migration.G_Table_name,
14348: p_context => gmf_migration.G_Context,

Line 14347: p_table_name => gmf_migration.G_Table_name,

14343: (
14344: p_run_id => gmf_migration.G_migration_run_id,
14345: p_log_level => FND_LOG.LEVEL_ERROR,
14346: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14347: p_table_name => gmf_migration.G_Table_name,
14348: p_context => gmf_migration.G_Context,
14349: p_token1 => 'TABLE_NAME',
14350: p_token2 => 'COLUMN_NAME',
14351: p_token3 => 'RECORD_COUNT',

Line 14348: p_context => gmf_migration.G_Context,

14344: p_run_id => gmf_migration.G_migration_run_id,
14345: p_log_level => FND_LOG.LEVEL_ERROR,
14346: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14347: p_table_name => gmf_migration.G_Table_name,
14348: p_context => gmf_migration.G_Context,
14349: p_token1 => 'TABLE_NAME',
14350: p_token2 => 'COLUMN_NAME',
14351: p_token3 => 'RECORD_COUNT',
14352: p_param1 => gmf_migration.G_Table_name,

Line 14352: p_param1 => gmf_migration.G_Table_name,

14348: p_context => gmf_migration.G_Context,
14349: p_token1 => 'TABLE_NAME',
14350: p_token2 => 'COLUMN_NAME',
14351: p_token3 => 'RECORD_COUNT',
14352: p_param1 => gmf_migration.G_Table_name,
14353: p_param2 => 'UOMs',
14354: p_param3 => l_uom_count1,
14355: p_db_error => NULL,
14356: p_app_short_name => 'GMA'

Line 14365: p_run_id => gmf_migration.G_migration_run_id,

14361: ***********************************/
14362: IF nvl(l_uom_count2,0) > 0 THEN
14363: GMA_COMMON_LOGGING.gma_migration_central_log
14364: (
14365: p_run_id => gmf_migration.G_migration_run_id,
14366: p_log_level => FND_LOG.LEVEL_ERROR,
14367: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14368: p_table_name => gmf_migration.G_Table_name,
14369: p_context => gmf_migration.G_Context,

Line 14368: p_table_name => gmf_migration.G_Table_name,

14364: (
14365: p_run_id => gmf_migration.G_migration_run_id,
14366: p_log_level => FND_LOG.LEVEL_ERROR,
14367: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14368: p_table_name => gmf_migration.G_Table_name,
14369: p_context => gmf_migration.G_Context,
14370: p_token1 => 'TABLE_NAME',
14371: p_token2 => 'COLUMN_NAME',
14372: p_token3 => 'RECORD_COUNT',

Line 14369: p_context => gmf_migration.G_Context,

14365: p_run_id => gmf_migration.G_migration_run_id,
14366: p_log_level => FND_LOG.LEVEL_ERROR,
14367: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14368: p_table_name => gmf_migration.G_Table_name,
14369: p_context => gmf_migration.G_Context,
14370: p_token1 => 'TABLE_NAME',
14371: p_token2 => 'COLUMN_NAME',
14372: p_token3 => 'RECORD_COUNT',
14373: p_param1 => gmf_migration.G_Table_name,

Line 14373: p_param1 => gmf_migration.G_Table_name,

14369: p_context => gmf_migration.G_Context,
14370: p_token1 => 'TABLE_NAME',
14371: p_token2 => 'COLUMN_NAME',
14372: p_token3 => 'RECORD_COUNT',
14373: p_param1 => gmf_migration.G_Table_name,
14374: p_param2 => 'UOMs',
14375: p_param3 => l_uom_count2,
14376: p_db_error => NULL,
14377: p_app_short_name => 'GMA'

Line 14386: p_run_id => gmf_migration.G_migration_run_id,

14382: ***********************************/
14383: IF nvl(l_uom_count3,0) > 0 THEN
14384: GMA_COMMON_LOGGING.gma_migration_central_log
14385: (
14386: p_run_id => gmf_migration.G_migration_run_id,
14387: p_log_level => FND_LOG.LEVEL_ERROR,
14388: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14389: p_table_name => gmf_migration.G_Table_name,
14390: p_context => gmf_migration.G_Context,

Line 14389: p_table_name => gmf_migration.G_Table_name,

14385: (
14386: p_run_id => gmf_migration.G_migration_run_id,
14387: p_log_level => FND_LOG.LEVEL_ERROR,
14388: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14389: p_table_name => gmf_migration.G_Table_name,
14390: p_context => gmf_migration.G_Context,
14391: p_token1 => 'TABLE_NAME',
14392: p_token2 => 'COLUMN_NAME',
14393: p_token3 => 'RECORD_COUNT',

Line 14390: p_context => gmf_migration.G_Context,

14386: p_run_id => gmf_migration.G_migration_run_id,
14387: p_log_level => FND_LOG.LEVEL_ERROR,
14388: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14389: p_table_name => gmf_migration.G_Table_name,
14390: p_context => gmf_migration.G_Context,
14391: p_token1 => 'TABLE_NAME',
14392: p_token2 => 'COLUMN_NAME',
14393: p_token3 => 'RECORD_COUNT',
14394: p_param1 => gmf_migration.G_Table_name,

Line 14394: p_param1 => gmf_migration.G_Table_name,

14390: p_context => gmf_migration.G_Context,
14391: p_token1 => 'TABLE_NAME',
14392: p_token2 => 'COLUMN_NAME',
14393: p_token3 => 'RECORD_COUNT',
14394: p_param1 => gmf_migration.G_Table_name,
14395: p_param2 => 'UOMs',
14396: p_param3 => l_uom_count3,
14397: p_db_error => NULL,
14398: p_app_short_name => 'GMA'

Line 14407: p_run_id => gmf_migration.G_migration_run_id,

14403: *******************************************/
14404: IF nvl(l_adjustment_ind_count,0) > 0 THEN
14405: GMA_COMMON_LOGGING.gma_migration_central_log
14406: (
14407: p_run_id => gmf_migration.G_migration_run_id,
14408: p_log_level => FND_LOG.LEVEL_ERROR,
14409: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14410: p_table_name => gmf_migration.G_Table_name,
14411: p_context => gmf_migration.G_Context,

Line 14410: p_table_name => gmf_migration.G_Table_name,

14406: (
14407: p_run_id => gmf_migration.G_migration_run_id,
14408: p_log_level => FND_LOG.LEVEL_ERROR,
14409: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14410: p_table_name => gmf_migration.G_Table_name,
14411: p_context => gmf_migration.G_Context,
14412: p_token1 => 'TABLE_NAME',
14413: p_token2 => 'COLUMN_NAME',
14414: p_token3 => 'RECORD_COUNT',

Line 14411: p_context => gmf_migration.G_Context,

14407: p_run_id => gmf_migration.G_migration_run_id,
14408: p_log_level => FND_LOG.LEVEL_ERROR,
14409: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14410: p_table_name => gmf_migration.G_Table_name,
14411: p_context => gmf_migration.G_Context,
14412: p_token1 => 'TABLE_NAME',
14413: p_token2 => 'COLUMN_NAME',
14414: p_token3 => 'RECORD_COUNT',
14415: p_param1 => gmf_migration.G_Table_name,

Line 14415: p_param1 => gmf_migration.G_Table_name,

14411: p_context => gmf_migration.G_Context,
14412: p_token1 => 'TABLE_NAME',
14413: p_token2 => 'COLUMN_NAME',
14414: p_token3 => 'RECORD_COUNT',
14415: p_param1 => gmf_migration.G_Table_name,
14416: p_param2 => 'Adjustment Indicators',
14417: p_param3 => l_adjustment_ind_count,
14418: p_db_error => NULL,
14419: p_app_short_name => 'GMA'

Line 14428: p_run_id => gmf_migration.G_migration_run_id,

14424: ***********************************/
14425: IF nvl(l_lot_number_count,0) > 0 THEN
14426: GMA_COMMON_LOGGING.gma_migration_central_log
14427: (
14428: p_run_id => gmf_migration.G_migration_run_id,
14429: p_log_level => FND_LOG.LEVEL_ERROR,
14430: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14431: p_table_name => gmf_migration.G_Table_name,
14432: p_context => gmf_migration.G_Context,

Line 14431: p_table_name => gmf_migration.G_Table_name,

14427: (
14428: p_run_id => gmf_migration.G_migration_run_id,
14429: p_log_level => FND_LOG.LEVEL_ERROR,
14430: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14431: p_table_name => gmf_migration.G_Table_name,
14432: p_context => gmf_migration.G_Context,
14433: p_token1 => 'TABLE_NAME',
14434: p_token2 => 'COLUMN_NAME',
14435: p_token3 => 'RECORD_COUNT',

Line 14432: p_context => gmf_migration.G_Context,

14428: p_run_id => gmf_migration.G_migration_run_id,
14429: p_log_level => FND_LOG.LEVEL_ERROR,
14430: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14431: p_table_name => gmf_migration.G_Table_name,
14432: p_context => gmf_migration.G_Context,
14433: p_token1 => 'TABLE_NAME',
14434: p_token2 => 'COLUMN_NAME',
14435: p_token3 => 'RECORD_COUNT',
14436: p_param1 => gmf_migration.G_Table_name,

Line 14436: p_param1 => gmf_migration.G_Table_name,

14432: p_context => gmf_migration.G_Context,
14433: p_token1 => 'TABLE_NAME',
14434: p_token2 => 'COLUMN_NAME',
14435: p_token3 => 'RECORD_COUNT',
14436: p_param1 => gmf_migration.G_Table_name,
14437: p_param2 => 'Lot Numbers',
14438: p_param3 => l_lot_number_count,
14439: p_db_error => NULL,
14440: p_app_short_name => 'GMA'

Line 14449: p_run_id => gmf_migration.G_migration_run_id,

14445: ****************************************/
14446: IF nvl(l_unique_error_count,0) > 0 THEN
14447: GMA_COMMON_LOGGING.gma_migration_central_log
14448: (
14449: p_run_id => gmf_migration.G_migration_run_id,
14450: p_log_level => FND_LOG.LEVEL_ERROR,
14451: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14452: p_table_name => gmf_migration.G_Table_name,
14453: p_context => gmf_migration.G_Context,

Line 14452: p_table_name => gmf_migration.G_Table_name,

14448: (
14449: p_run_id => gmf_migration.G_migration_run_id,
14450: p_log_level => FND_LOG.LEVEL_ERROR,
14451: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14452: p_table_name => gmf_migration.G_Table_name,
14453: p_context => gmf_migration.G_Context,
14454: p_token1 => 'TABLE_NAME',
14455: p_token2 => 'COLUMN_NAME',
14456: p_token3 => 'RECORD_COUNT',

Line 14453: p_context => gmf_migration.G_Context,

14449: p_run_id => gmf_migration.G_migration_run_id,
14450: p_log_level => FND_LOG.LEVEL_ERROR,
14451: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14452: p_table_name => gmf_migration.G_Table_name,
14453: p_context => gmf_migration.G_Context,
14454: p_token1 => 'TABLE_NAME',
14455: p_token2 => 'COLUMN_NAME',
14456: p_token3 => 'RECORD_COUNT',
14457: p_param1 => gmf_migration.G_Table_name,

Line 14457: p_param1 => gmf_migration.G_Table_name,

14453: p_context => gmf_migration.G_Context,
14454: p_token1 => 'TABLE_NAME',
14455: p_token2 => 'COLUMN_NAME',
14456: p_token3 => 'RECORD_COUNT',
14457: p_param1 => gmf_migration.G_Table_name,
14458: p_param2 => 'Unique Constraint',
14459: p_param3 => l_unique_error_count,
14460: p_db_error => NULL,
14461: p_app_short_name => 'GMA'

Line 14470: p_run_id => gmf_migration.G_migration_run_id,

14466: ******************************************/
14467: IF nvl(l_not_null_error_count,0) > 0 THEN
14468: GMA_COMMON_LOGGING.gma_migration_central_log
14469: (
14470: p_run_id => gmf_migration.G_migration_run_id,
14471: p_log_level => FND_LOG.LEVEL_ERROR,
14472: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14473: p_table_name => gmf_migration.G_Table_name,
14474: p_context => gmf_migration.G_Context,

Line 14473: p_table_name => gmf_migration.G_Table_name,

14469: (
14470: p_run_id => gmf_migration.G_migration_run_id,
14471: p_log_level => FND_LOG.LEVEL_ERROR,
14472: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14473: p_table_name => gmf_migration.G_Table_name,
14474: p_context => gmf_migration.G_Context,
14475: p_token1 => 'TABLE_NAME',
14476: p_token2 => 'COLUMN_NAME',
14477: p_token3 => 'RECORD_COUNT',

Line 14474: p_context => gmf_migration.G_Context,

14470: p_run_id => gmf_migration.G_migration_run_id,
14471: p_log_level => FND_LOG.LEVEL_ERROR,
14472: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14473: p_table_name => gmf_migration.G_Table_name,
14474: p_context => gmf_migration.G_Context,
14475: p_token1 => 'TABLE_NAME',
14476: p_token2 => 'COLUMN_NAME',
14477: p_token3 => 'RECORD_COUNT',
14478: p_param1 => gmf_migration.G_Table_name,

Line 14478: p_param1 => gmf_migration.G_Table_name,

14474: p_context => gmf_migration.G_Context,
14475: p_token1 => 'TABLE_NAME',
14476: p_token2 => 'COLUMN_NAME',
14477: p_token3 => 'RECORD_COUNT',
14478: p_param1 => gmf_migration.G_Table_name,
14479: p_param2 => 'Not Null Constraint',
14480: p_param3 => l_not_null_error_count,
14481: p_db_error => NULL,
14482: p_app_short_name => 'GMA'

Line 14491: p_run_id => gmf_migration.G_migration_run_id,

14487: ************************************/
14488: IF nvl(l_value_error_count,0) > 0 THEN
14489: GMA_COMMON_LOGGING.gma_migration_central_log
14490: (
14491: p_run_id => gmf_migration.G_migration_run_id,
14492: p_log_level => FND_LOG.LEVEL_ERROR,
14493: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14494: p_table_name => gmf_migration.G_Table_name,
14495: p_context => gmf_migration.G_Context,

Line 14494: p_table_name => gmf_migration.G_Table_name,

14490: (
14491: p_run_id => gmf_migration.G_migration_run_id,
14492: p_log_level => FND_LOG.LEVEL_ERROR,
14493: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14494: p_table_name => gmf_migration.G_Table_name,
14495: p_context => gmf_migration.G_Context,
14496: p_token1 => 'TABLE_NAME',
14497: p_token2 => 'COLUMN_NAME',
14498: p_token3 => 'RECORD_COUNT',

Line 14495: p_context => gmf_migration.G_Context,

14491: p_run_id => gmf_migration.G_migration_run_id,
14492: p_log_level => FND_LOG.LEVEL_ERROR,
14493: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14494: p_table_name => gmf_migration.G_Table_name,
14495: p_context => gmf_migration.G_Context,
14496: p_token1 => 'TABLE_NAME',
14497: p_token2 => 'COLUMN_NAME',
14498: p_token3 => 'RECORD_COUNT',
14499: p_param1 => gmf_migration.G_Table_name,

Line 14499: p_param1 => gmf_migration.G_Table_name,

14495: p_context => gmf_migration.G_Context,
14496: p_token1 => 'TABLE_NAME',
14497: p_token2 => 'COLUMN_NAME',
14498: p_token3 => 'RECORD_COUNT',
14499: p_param1 => gmf_migration.G_Table_name,
14500: p_param2 => 'Invalid Value',
14501: p_param3 => l_value_error_count,
14502: p_db_error => NULL,
14503: p_app_short_name => 'GMA'

Line 14512: p_run_id => gmf_migration.G_migration_run_id,

14508: *******************************************/
14509: IF nvl(l_parent_key_error_count,0) > 0 THEN
14510: GMA_COMMON_LOGGING.gma_migration_central_log
14511: (
14512: p_run_id => gmf_migration.G_migration_run_id,
14513: p_log_level => FND_LOG.LEVEL_ERROR,
14514: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14515: p_table_name => gmf_migration.G_Table_name,
14516: p_context => gmf_migration.G_Context,

Line 14515: p_table_name => gmf_migration.G_Table_name,

14511: (
14512: p_run_id => gmf_migration.G_migration_run_id,
14513: p_log_level => FND_LOG.LEVEL_ERROR,
14514: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14515: p_table_name => gmf_migration.G_Table_name,
14516: p_context => gmf_migration.G_Context,
14517: p_token1 => 'TABLE_NAME',
14518: p_token2 => 'COLUMN_NAME',
14519: p_token3 => 'RECORD_COUNT',

Line 14516: p_context => gmf_migration.G_Context,

14512: p_run_id => gmf_migration.G_migration_run_id,
14513: p_log_level => FND_LOG.LEVEL_ERROR,
14514: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14515: p_table_name => gmf_migration.G_Table_name,
14516: p_context => gmf_migration.G_Context,
14517: p_token1 => 'TABLE_NAME',
14518: p_token2 => 'COLUMN_NAME',
14519: p_token3 => 'RECORD_COUNT',
14520: p_param1 => gmf_migration.G_Table_name,

Line 14520: p_param1 => gmf_migration.G_Table_name,

14516: p_context => gmf_migration.G_Context,
14517: p_token1 => 'TABLE_NAME',
14518: p_token2 => 'COLUMN_NAME',
14519: p_token3 => 'RECORD_COUNT',
14520: p_param1 => gmf_migration.G_Table_name,
14521: p_param2 => 'Parent Key Constraint',
14522: p_param3 => l_parent_key_error_count,
14523: p_db_error => NULL,
14524: p_app_short_name => 'GMA'

Line 14533: p_run_id => gmf_migration.G_migration_run_id,

14529: *************************************/
14530: IF nvl(l_too_long_error_count,0) > 0 THEN
14531: GMA_COMMON_LOGGING.gma_migration_central_log
14532: (
14533: p_run_id => gmf_migration.G_migration_run_id,
14534: p_log_level => FND_LOG.LEVEL_ERROR,
14535: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14536: p_table_name => gmf_migration.G_Table_name,
14537: p_context => gmf_migration.G_Context,

Line 14536: p_table_name => gmf_migration.G_Table_name,

14532: (
14533: p_run_id => gmf_migration.G_migration_run_id,
14534: p_log_level => FND_LOG.LEVEL_ERROR,
14535: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14536: p_table_name => gmf_migration.G_Table_name,
14537: p_context => gmf_migration.G_Context,
14538: p_token1 => 'TABLE_NAME',
14539: p_token2 => 'COLUMN_NAME',
14540: p_token3 => 'RECORD_COUNT',

Line 14537: p_context => gmf_migration.G_Context,

14533: p_run_id => gmf_migration.G_migration_run_id,
14534: p_log_level => FND_LOG.LEVEL_ERROR,
14535: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14536: p_table_name => gmf_migration.G_Table_name,
14537: p_context => gmf_migration.G_Context,
14538: p_token1 => 'TABLE_NAME',
14539: p_token2 => 'COLUMN_NAME',
14540: p_token3 => 'RECORD_COUNT',
14541: p_param1 => gmf_migration.G_Table_name,

Line 14541: p_param1 => gmf_migration.G_Table_name,

14537: p_context => gmf_migration.G_Context,
14538: p_token1 => 'TABLE_NAME',
14539: p_token2 => 'COLUMN_NAME',
14540: p_token3 => 'RECORD_COUNT',
14541: p_param1 => gmf_migration.G_Table_name,
14542: p_param2 => 'Value Too Long Error',
14543: p_param3 => l_too_long_error_count,
14544: p_db_error => NULL,
14545: p_app_short_name => 'GMA'

Line 14554: p_run_id => gmf_migration.G_migration_run_id,

14550: *************************************/
14551: IF nvl(l_invalid_number_error_count,0) > 0 THEN
14552: GMA_COMMON_LOGGING.gma_migration_central_log
14553: (
14554: p_run_id => gmf_migration.G_migration_run_id,
14555: p_log_level => FND_LOG.LEVEL_ERROR,
14556: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14557: p_table_name => gmf_migration.G_Table_name,
14558: p_context => gmf_migration.G_Context,

Line 14557: p_table_name => gmf_migration.G_Table_name,

14553: (
14554: p_run_id => gmf_migration.G_migration_run_id,
14555: p_log_level => FND_LOG.LEVEL_ERROR,
14556: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14557: p_table_name => gmf_migration.G_Table_name,
14558: p_context => gmf_migration.G_Context,
14559: p_token1 => 'TABLE_NAME',
14560: p_token2 => 'COLUMN_NAME',
14561: p_token3 => 'RECORD_COUNT',

Line 14558: p_context => gmf_migration.G_Context,

14554: p_run_id => gmf_migration.G_migration_run_id,
14555: p_log_level => FND_LOG.LEVEL_ERROR,
14556: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14557: p_table_name => gmf_migration.G_Table_name,
14558: p_context => gmf_migration.G_Context,
14559: p_token1 => 'TABLE_NAME',
14560: p_token2 => 'COLUMN_NAME',
14561: p_token3 => 'RECORD_COUNT',
14562: p_param1 => gmf_migration.G_Table_name,

Line 14562: p_param1 => gmf_migration.G_Table_name,

14558: p_context => gmf_migration.G_Context,
14559: p_token1 => 'TABLE_NAME',
14560: p_token2 => 'COLUMN_NAME',
14561: p_token3 => 'RECORD_COUNT',
14562: p_param1 => gmf_migration.G_Table_name,
14563: p_param2 => 'Invalid Number Error',
14564: p_param3 => l_invalid_number_error_count,
14565: p_db_error => NULL,
14566: p_app_short_name => 'GMA'

Line 14575: p_run_id => gmf_migration.G_migration_run_id,

14571: ********************************************/
14572: IF nvl(l_not_picked_up_error_count,0) > 0 THEN
14573: GMA_COMMON_LOGGING.gma_migration_central_log
14574: (
14575: p_run_id => gmf_migration.G_migration_run_id,
14576: p_log_level => FND_LOG.LEVEL_ERROR,
14577: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14578: p_table_name => gmf_migration.G_Table_name,
14579: p_context => gmf_migration.G_Context,

Line 14578: p_table_name => gmf_migration.G_Table_name,

14574: (
14575: p_run_id => gmf_migration.G_migration_run_id,
14576: p_log_level => FND_LOG.LEVEL_ERROR,
14577: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14578: p_table_name => gmf_migration.G_Table_name,
14579: p_context => gmf_migration.G_Context,
14580: p_token1 => 'TABLE_NAME',
14581: p_token2 => 'COLUMN_NAME',
14582: p_token3 => 'RECORD_COUNT',

Line 14579: p_context => gmf_migration.G_Context,

14575: p_run_id => gmf_migration.G_migration_run_id,
14576: p_log_level => FND_LOG.LEVEL_ERROR,
14577: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14578: p_table_name => gmf_migration.G_Table_name,
14579: p_context => gmf_migration.G_Context,
14580: p_token1 => 'TABLE_NAME',
14581: p_token2 => 'COLUMN_NAME',
14582: p_token3 => 'RECORD_COUNT',
14583: p_param1 => gmf_migration.G_Table_name,

Line 14583: p_param1 => gmf_migration.G_Table_name,

14579: p_context => gmf_migration.G_Context,
14580: p_token1 => 'TABLE_NAME',
14581: p_token2 => 'COLUMN_NAME',
14582: p_token3 => 'RECORD_COUNT',
14583: p_param1 => gmf_migration.G_Table_name,
14584: p_param2 => 'Records not Picked up Error',
14585: p_param3 => l_not_picked_up_error_count,
14586: p_db_error => NULL,
14587: p_app_short_name => 'GMA'

Line 14604: p_run_id => gmf_migration.G_migration_run_id,

14600: nvl(l_too_long_error_count,0)
14601: ) > 0 THEN
14602: GMA_COMMON_LOGGING.gma_migration_central_log
14603: (
14604: p_run_id => gmf_migration.G_migration_run_id,
14605: p_log_level => FND_LOG.LEVEL_ERROR,
14606: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14607: p_table_name => gmf_migration.G_Table_name,
14608: p_context => gmf_migration.G_Context,

Line 14607: p_table_name => gmf_migration.G_Table_name,

14603: (
14604: p_run_id => gmf_migration.G_migration_run_id,
14605: p_log_level => FND_LOG.LEVEL_ERROR,
14606: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14607: p_table_name => gmf_migration.G_Table_name,
14608: p_context => gmf_migration.G_Context,
14609: p_token1 => 'TABLE_NAME',
14610: p_token2 => 'COLUMN_NAME',
14611: p_token3 => 'RECORD_COUNT',

Line 14608: p_context => gmf_migration.G_Context,

14604: p_run_id => gmf_migration.G_migration_run_id,
14605: p_log_level => FND_LOG.LEVEL_ERROR,
14606: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14607: p_table_name => gmf_migration.G_Table_name,
14608: p_context => gmf_migration.G_Context,
14609: p_token1 => 'TABLE_NAME',
14610: p_token2 => 'COLUMN_NAME',
14611: p_token3 => 'RECORD_COUNT',
14612: p_param1 => gmf_migration.G_Table_name,

Line 14612: p_param1 => gmf_migration.G_Table_name,

14608: p_context => gmf_migration.G_Context,
14609: p_token1 => 'TABLE_NAME',
14610: p_token2 => 'COLUMN_NAME',
14611: p_token3 => 'RECORD_COUNT',
14612: p_param1 => gmf_migration.G_Table_name,
14613: p_param2 => 'Other Errors',
14614: p_param3 => nvl(l_total_error_count,0) - (
14615: nvl(l_unique_error_count,0) +
14616: nvl(l_not_null_error_count,0) +

Line 14633: p_run_id => gmf_migration.G_migration_run_id,

14629: * Migration Success Log Message *
14630: **************************************/
14631: GMA_COMMON_LOGGING.gma_migration_central_log
14632: (
14633: p_run_id => gmf_migration.G_migration_run_id,
14634: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14635: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14636: p_table_name => gmf_migration.G_Table_name,
14637: p_context => gmf_migration.G_context,

Line 14636: p_table_name => gmf_migration.G_Table_name,

14632: (
14633: p_run_id => gmf_migration.G_migration_run_id,
14634: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14635: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14636: p_table_name => gmf_migration.G_Table_name,
14637: p_context => gmf_migration.G_context,
14638: p_param1 => 1,
14639: p_param2 => 0,
14640: p_db_error => NULL,

Line 14637: p_context => gmf_migration.G_context,

14633: p_run_id => gmf_migration.G_migration_run_id,
14634: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14635: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14636: p_table_name => gmf_migration.G_Table_name,
14637: p_context => gmf_migration.G_context,
14638: p_param1 => 1,
14639: p_param2 => 0,
14640: p_db_error => NULL,
14641: p_app_short_name => 'GMA'

Line 14649: p_run_id => gmf_migration.G_migration_run_id,

14645: IF l_error_tbl.count > 0 THEN
14646: FOR i IN l_error_tbl.first..l_error_tbl.last LOOP
14647: GMA_COMMON_LOGGING.gma_migration_central_log
14648: (
14649: p_run_id => gmf_migration.G_migration_run_id,
14650: p_log_level => FND_LOG.LEVEL_ERROR,
14651: p_message_token => 'GMA_MIGRATION_ERROR_DETAIL',
14652: p_table_name => gmf_migration.G_Table_name,
14653: p_context => gmf_migration.G_Context,

Line 14652: p_table_name => gmf_migration.G_Table_name,

14648: (
14649: p_run_id => gmf_migration.G_migration_run_id,
14650: p_log_level => FND_LOG.LEVEL_ERROR,
14651: p_message_token => 'GMA_MIGRATION_ERROR_DETAIL',
14652: p_table_name => gmf_migration.G_Table_name,
14653: p_context => gmf_migration.G_Context,
14654: p_token1 => 'TABLE_NAME',
14655: p_token2 => 'COLUMN_NAME',
14656: p_token3 => 'PARAMETERS',

Line 14653: p_context => gmf_migration.G_Context,

14649: p_run_id => gmf_migration.G_migration_run_id,
14650: p_log_level => FND_LOG.LEVEL_ERROR,
14651: p_message_token => 'GMA_MIGRATION_ERROR_DETAIL',
14652: p_table_name => gmf_migration.G_Table_name,
14653: p_context => gmf_migration.G_Context,
14654: p_token1 => 'TABLE_NAME',
14655: p_token2 => 'COLUMN_NAME',
14656: p_token3 => 'PARAMETERS',
14657: p_token4 => 'RECORD_COUNT',

Line 14672: p_run_id => gmf_migration.G_migration_run_id,

14668: * Migration Success Log Message *
14669: **************************************/
14670: GMA_COMMON_LOGGING.gma_migration_central_log
14671: (
14672: p_run_id => gmf_migration.G_migration_run_id,
14673: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14674: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14675: p_table_name => gmf_migration.G_Table_name,
14676: p_context => gmf_migration.G_context,

Line 14675: p_table_name => gmf_migration.G_Table_name,

14671: (
14672: p_run_id => gmf_migration.G_migration_run_id,
14673: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14674: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14675: p_table_name => gmf_migration.G_Table_name,
14676: p_context => gmf_migration.G_context,
14677: p_param1 => 1,
14678: p_param2 => 0,
14679: p_db_error => NULL,

Line 14676: p_context => gmf_migration.G_context,

14672: p_run_id => gmf_migration.G_migration_run_id,
14673: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14674: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14675: p_table_name => gmf_migration.G_Table_name,
14676: p_context => gmf_migration.G_context,
14677: p_param1 => 1,
14678: p_param2 => 0,
14679: p_db_error => NULL,
14680: p_app_short_name => 'GMA'

Line 14802: END GMF_MIGRATION;

14798: p_app_short_name => 'GMA'
14799: );
14800: END Migrate_Vendor_id;
14801:
14802: END GMF_MIGRATION;