eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.48 2006/12/16 14:21:54 anthiyag noship $ */
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 4060: p_run_id => gmf_migration.G_migration_run_id,

4056: **************************************/
4057:
4058: GMA_COMMON_LOGGING.gma_migration_central_log
4059: (
4060: p_run_id => gmf_migration.G_migration_run_id,
4061: p_log_level => FND_LOG.LEVEL_PROCEDURE,
4062: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
4063: p_table_name => gmf_migration.G_Table_name,
4064: p_context => gmf_migration.G_context,

Line 4063: p_table_name => gmf_migration.G_Table_name,

4059: (
4060: p_run_id => gmf_migration.G_migration_run_id,
4061: p_log_level => FND_LOG.LEVEL_PROCEDURE,
4062: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
4063: p_table_name => gmf_migration.G_Table_name,
4064: p_context => gmf_migration.G_context,
4065: p_db_error => NULL,
4066: p_app_short_name => 'GMA'
4067: );

Line 4064: p_context => gmf_migration.G_context,

4060: p_run_id => gmf_migration.G_migration_run_id,
4061: p_log_level => FND_LOG.LEVEL_PROCEDURE,
4062: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
4063: p_table_name => gmf_migration.G_Table_name,
4064: p_context => gmf_migration.G_context,
4065: p_db_error => NULL,
4066: p_app_short_name => 'GMA'
4067: );
4068:

Line 4588: gmf_migration.Log_Errors (

4584:
4585: /**********************************************
4586: * Handle all the rows which were not migrated *
4587: **********************************************/
4588: gmf_migration.Log_Errors (
4589: p_log_level => 1,
4590: p_from_rowid => NULL,
4591: p_to_rowid => NULL
4592: );

Line 4836: gmf_migration.Log_Errors (

4832:
4833: /**********************************************
4834: * Handle all the rows which were not migrated *
4835: **********************************************/
4836: gmf_migration.Log_Errors (
4837: p_log_level => 1,
4838: p_from_rowid => NULL,
4839: p_to_rowid => NULL
4840: );

Line 5275: gmf_migration.Log_Errors (

5271:
5272: /**********************************************
5273: * Handle all the rows which were not migrated *
5274: **********************************************/
5275: gmf_migration.Log_Errors (
5276: p_log_level => 1,
5277: p_from_rowid => NULL,
5278: p_to_rowid => NULL
5279: );

Line 5454: gmf_migration.Log_Errors (

5450:
5451: /**********************************************
5452: * Handle all the rows which were not migrated *
5453: **********************************************/
5454: gmf_migration.Log_Errors (
5455: p_log_level => 1,
5456: p_from_rowid => NULL,
5457: p_to_rowid => NULL
5458: );

Line 5835: gmf_migration.Log_Errors (

5831:
5832: /**********************************************
5833: * Handle all the rows which were not migrated *
5834: **********************************************/
5835: gmf_migration.Log_Errors (
5836: p_log_level => 1,
5837: p_from_rowid => NULL,
5838: p_to_rowid => NULL
5839: );

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

5999:
6000: UPDATE gl_aloc_bas a
6001: SET a.basis_account_id
6002: = (
6003: SELECT gmf_migration.get_account_id(a.basis_Account_key, x.co_code)
6004: FROM gl_aloc_mst x
6005: WHERE x.alloc_id = a.alloc_id
6006: ),
6007: a.basis_type = decode(a.alloc_method, 0, a.basis_type, 1),

Line 6089: p_run_id => gmf_migration.G_migration_run_id,

6085: **************************************/
6086:
6087: GMA_COMMON_LOGGING.gma_migration_central_log
6088: (
6089: p_run_id => gmf_migration.G_migration_run_id,
6090: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6091: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6092: p_table_name => gmf_migration.G_Table_name,
6093: p_context => gmf_migration.G_context,

Line 6092: p_table_name => gmf_migration.G_Table_name,

6088: (
6089: p_run_id => gmf_migration.G_migration_run_id,
6090: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6091: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6092: p_table_name => gmf_migration.G_Table_name,
6093: p_context => gmf_migration.G_context,
6094: p_db_error => NULL,
6095: p_app_short_name => 'GMA'
6096: );

Line 6093: p_context => gmf_migration.G_context,

6089: p_run_id => gmf_migration.G_migration_run_id,
6090: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6091: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6092: p_table_name => gmf_migration.G_Table_name,
6093: p_context => gmf_migration.G_context,
6094: p_db_error => NULL,
6095: p_app_short_name => 'GMA'
6096: );
6097:

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

6235: a.from_account_id,
6236: a.to_account_id
6237: )
6238: = (
6239: SELECT gmf_migration.get_account_id(a.from_account, x.co_code),
6240: gmf_migration.get_account_id(a.to_account, x.co_code)
6241: FROM gl_aloc_mst x
6242: WHERE x.alloc_id = a.alloc_id
6243: )

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

6236: a.to_account_id
6237: )
6238: = (
6239: SELECT gmf_migration.get_account_id(a.from_account, x.co_code),
6240: gmf_migration.get_account_id(a.to_account, x.co_code)
6241: FROM gl_aloc_mst x
6242: WHERE x.alloc_id = a.alloc_id
6243: )
6244: WHERE (

Line 6310: p_run_id => gmf_migration.G_migration_run_id,

6306: **************************************/
6307:
6308: GMA_COMMON_LOGGING.gma_migration_central_log
6309: (
6310: p_run_id => gmf_migration.G_migration_run_id,
6311: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6312: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6313: p_table_name => gmf_migration.G_Table_name,
6314: p_context => gmf_migration.G_context,

Line 6313: p_table_name => gmf_migration.G_Table_name,

6309: (
6310: p_run_id => gmf_migration.G_migration_run_id,
6311: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6312: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6313: p_table_name => gmf_migration.G_Table_name,
6314: p_context => gmf_migration.G_context,
6315: p_db_error => NULL,
6316: p_app_short_name => 'GMA'
6317: );

Line 6314: p_context => gmf_migration.G_context,

6310: p_run_id => gmf_migration.G_migration_run_id,
6311: p_log_level => FND_LOG.LEVEL_PROCEDURE,
6312: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
6313: p_table_name => gmf_migration.G_Table_name,
6314: p_context => gmf_migration.G_context,
6315: p_db_error => NULL,
6316: p_app_short_name => 'GMA'
6317: );
6318:

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

7893: p_segment_rule_detail_id => l_segment_rule_detail_id
7894: );
7895: END IF;
7896: IF l_item_id(m) IS NOT NULL THEN
7897: l_inventory_item_id := gmf_migration.get_inventory_item_id(p_item_id => l_item_id(m));
7898: IF l_inventory_item_id IS NOT NULL THEN
7899: insert_conditions (
7900: p_condition_tag => 'MID',
7901: p_sequence => l_adr_condition_priority,

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

7947: p_segment_rule_detail_id => l_segment_rule_detail_id
7948: );
7949: END IF;
7950: IF l_reason_code(m) IS NOT NULL THEN
7951: l_reason_id := gmf_migration.Get_reason_id(p_reason_code => l_reason_code(m));
7952: IF l_reason_id IS NOT NULL THEN
7953: insert_conditions (
7954: p_condition_tag => 'MID',
7955: p_sequence => l_adr_condition_priority,

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

7974: p_segment_rule_detail_id => l_segment_rule_detail_id
7975: );
7976: END IF;
7977: IF l_aqui_cost_id(m) IS NOT NULL THEN
7978: l_price_element_type_id := gmf_migration.Get_price_element_type_id(p_aqui_cost_id => l_aqui_cost_id(m));
7979: IF l_price_element_type_id IS NOT NULL THEN
7980: insert_conditions (
7981: p_condition_tag => 'MID',
7982: p_sequence => l_adr_condition_priority,

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

8484: END IF;
8485: /************************************
8486: * ADR Rules Migration Error Logging *
8487: ************************************/
8488: gmf_migration.G_Table_name := 'XLA_RULES_T';
8489: gmf_migration.G_context := 'GMF Error Logging';
8490: gmf_migration.Log_Errors (
8491: p_log_level => 1,
8492: p_from_rowid => NULL,

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

8485: /************************************
8486: * ADR Rules Migration Error Logging *
8487: ************************************/
8488: gmf_migration.G_Table_name := 'XLA_RULES_T';
8489: gmf_migration.G_context := 'GMF Error Logging';
8490: gmf_migration.Log_Errors (
8491: p_log_level => 1,
8492: p_from_rowid => NULL,
8493: p_to_rowid => NULL

Line 8490: gmf_migration.Log_Errors (

8486: * ADR Rules Migration Error Logging *
8487: ************************************/
8488: gmf_migration.G_Table_name := 'XLA_RULES_T';
8489: gmf_migration.G_context := 'GMF Error Logging';
8490: gmf_migration.Log_Errors (
8491: p_log_level => 1,
8492: p_from_rowid => NULL,
8493: p_to_rowid => NULL
8494: );

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

8494: );
8495: /*******************************************
8496: * ADR Rule Details Migration Error Logging *
8497: *******************************************/
8498: gmf_migration.G_Table_name := 'XLA_RULE_DETAILS_T';
8499: gmf_migration.G_context := 'GMF Error Logging';
8500: gmf_migration.Log_Errors (
8501: p_log_level => 1,
8502: p_from_rowid => NULL,

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

8495: /*******************************************
8496: * ADR Rule Details Migration Error Logging *
8497: *******************************************/
8498: gmf_migration.G_Table_name := 'XLA_RULE_DETAILS_T';
8499: gmf_migration.G_context := 'GMF Error Logging';
8500: gmf_migration.Log_Errors (
8501: p_log_level => 1,
8502: p_from_rowid => NULL,
8503: p_to_rowid => NULL

Line 8500: gmf_migration.Log_Errors (

8496: * ADR Rule Details Migration Error Logging *
8497: *******************************************/
8498: gmf_migration.G_Table_name := 'XLA_RULE_DETAILS_T';
8499: gmf_migration.G_context := 'GMF Error Logging';
8500: gmf_migration.Log_Errors (
8501: p_log_level => 1,
8502: p_from_rowid => NULL,
8503: p_to_rowid => NULL
8504: );

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

8504: );
8505: /*****************************************
8506: * ADR Conditions Migration Error Logging *
8507: *****************************************/
8508: gmf_migration.G_Table_name := 'XLA_CONDITIONS_T';
8509: gmf_migration.G_context := 'GMF Error Logging';
8510: gmf_migration.Log_Errors (
8511: p_log_level => 1,
8512: p_from_rowid => NULL,

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

8505: /*****************************************
8506: * ADR Conditions Migration Error Logging *
8507: *****************************************/
8508: gmf_migration.G_Table_name := 'XLA_CONDITIONS_T';
8509: gmf_migration.G_context := 'GMF Error Logging';
8510: gmf_migration.Log_Errors (
8511: p_log_level => 1,
8512: p_from_rowid => NULL,
8513: p_to_rowid => NULL

Line 8510: gmf_migration.Log_Errors (

8506: * ADR Conditions Migration Error Logging *
8507: *****************************************/
8508: gmf_migration.G_Table_name := 'XLA_CONDITIONS_T';
8509: gmf_migration.G_context := 'GMF Error Logging';
8510: gmf_migration.Log_Errors (
8511: p_log_level => 1,
8512: p_from_rowid => NULL,
8513: p_to_rowid => NULL
8514: );

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

8514: );
8515: /***********************************************
8516: * ADR Line Assignments Migration Error Logging *
8517: ***********************************************/
8518: gmf_migration.G_Table_name := 'XLA_LINE_ASSGNS_T';
8519: gmf_migration.G_context := 'GMF Error Logging';
8520: gmf_migration.Log_Errors (
8521: p_log_level => 1,
8522: p_from_rowid => NULL,

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

8515: /***********************************************
8516: * ADR Line Assignments Migration Error Logging *
8517: ***********************************************/
8518: gmf_migration.G_Table_name := 'XLA_LINE_ASSGNS_T';
8519: gmf_migration.G_context := 'GMF Error Logging';
8520: gmf_migration.Log_Errors (
8521: p_log_level => 1,
8522: p_from_rowid => NULL,
8523: p_to_rowid => NULL

Line 8520: gmf_migration.Log_Errors (

8516: * ADR Line Assignments Migration Error Logging *
8517: ***********************************************/
8518: gmf_migration.G_Table_name := 'XLA_LINE_ASSGNS_T';
8519: gmf_migration.G_context := 'GMF Error Logging';
8520: gmf_migration.Log_Errors (
8521: p_log_level => 1,
8522: p_from_rowid => NULL,
8523: p_to_rowid => NULL
8524: );

Line 8756: p_run_id => gmf_migration.G_migration_run_id,

8752: **************************************/
8753:
8754: GMA_COMMON_LOGGING.gma_migration_central_log
8755: (
8756: p_run_id => gmf_migration.G_migration_run_id,
8757: p_log_level => FND_LOG.LEVEL_PROCEDURE,
8758: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
8759: p_table_name => gmf_migration.G_Table_name,
8760: p_context => gmf_migration.G_context,

Line 8759: p_table_name => gmf_migration.G_Table_name,

8755: (
8756: p_run_id => gmf_migration.G_migration_run_id,
8757: p_log_level => FND_LOG.LEVEL_PROCEDURE,
8758: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
8759: p_table_name => gmf_migration.G_Table_name,
8760: p_context => gmf_migration.G_context,
8761: p_db_error => NULL,
8762: p_app_short_name => 'GMA'
8763: );

Line 8760: p_context => gmf_migration.G_context,

8756: p_run_id => gmf_migration.G_migration_run_id,
8757: p_log_level => FND_LOG.LEVEL_PROCEDURE,
8758: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
8759: p_table_name => gmf_migration.G_Table_name,
8760: p_context => gmf_migration.G_context,
8761: p_db_error => NULL,
8762: p_app_short_name => 'GMA'
8763: );
8764:

Line 9068: p_run_id => gmf_migration.G_migration_run_id,

9064: **************************************/
9065:
9066: GMA_COMMON_LOGGING.gma_migration_central_log
9067: (
9068: p_run_id => gmf_migration.G_migration_run_id,
9069: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9070: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9071: p_table_name => gmf_migration.G_Table_name,
9072: p_context => gmf_migration.G_context,

Line 9071: p_table_name => gmf_migration.G_Table_name,

9067: (
9068: p_run_id => gmf_migration.G_migration_run_id,
9069: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9070: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9071: p_table_name => gmf_migration.G_Table_name,
9072: p_context => gmf_migration.G_context,
9073: p_db_error => NULL,
9074: p_app_short_name => 'GMA'
9075: );

Line 9072: p_context => gmf_migration.G_context,

9068: p_run_id => gmf_migration.G_migration_run_id,
9069: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9070: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9071: p_table_name => gmf_migration.G_Table_name,
9072: p_context => gmf_migration.G_context,
9073: p_db_error => NULL,
9074: p_app_short_name => 'GMA'
9075: );
9076:

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

9231: BEGIN
9232:
9233: UPDATE gl_aloc_inp a
9234: SET a.account_id = (
9235: SELECT gmf_migration.get_account_id(a.account_key, x.co_code)
9236: FROM gl_aloc_mst x
9237: WHERE x.alloc_id = a.alloc_id
9238: )
9239: WHERE (account_id IS NULL AND a.account_key IS NOT NULL);

Line 9302: p_run_id => gmf_migration.G_migration_run_id,

9298: **************************************/
9299:
9300: GMA_COMMON_LOGGING.gma_migration_central_log
9301: (
9302: p_run_id => gmf_migration.G_migration_run_id,
9303: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9304: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9305: p_table_name => gmf_migration.G_Table_name,
9306: p_context => gmf_migration.G_context,

Line 9305: p_table_name => gmf_migration.G_Table_name,

9301: (
9302: p_run_id => gmf_migration.G_migration_run_id,
9303: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9304: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9305: p_table_name => gmf_migration.G_Table_name,
9306: p_context => gmf_migration.G_context,
9307: p_db_error => NULL,
9308: p_app_short_name => 'GMA'
9309: );

Line 9306: p_context => gmf_migration.G_context,

9302: p_run_id => gmf_migration.G_migration_run_id,
9303: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9304: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9305: p_table_name => gmf_migration.G_Table_name,
9306: p_context => gmf_migration.G_context,
9307: p_db_error => NULL,
9308: p_app_short_name => 'GMA'
9309: );
9310:

Line 9496: p_run_id => gmf_migration.G_migration_run_id,

9492: **************************************/
9493:
9494: GMA_COMMON_LOGGING.gma_migration_central_log
9495: (
9496: p_run_id => gmf_migration.G_migration_run_id,
9497: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9498: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9499: p_table_name => gmf_migration.G_Table_name,
9500: p_context => gmf_migration.G_context,

Line 9499: p_table_name => gmf_migration.G_Table_name,

9495: (
9496: p_run_id => gmf_migration.G_migration_run_id,
9497: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9498: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9499: p_table_name => gmf_migration.G_Table_name,
9500: p_context => gmf_migration.G_context,
9501: p_db_error => NULL,
9502: p_app_short_name => 'GMA'
9503: );

Line 9500: p_context => gmf_migration.G_context,

9496: p_run_id => gmf_migration.G_migration_run_id,
9497: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9498: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9499: p_table_name => gmf_migration.G_Table_name,
9500: p_context => gmf_migration.G_context,
9501: p_db_error => NULL,
9502: p_app_short_name => 'GMA'
9503: );
9504:

Line 9752: p_run_id => gmf_migration.G_migration_run_id,

9748: **************************************/
9749:
9750: GMA_COMMON_LOGGING.gma_migration_central_log
9751: (
9752: p_run_id => gmf_migration.G_migration_run_id,
9753: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9754: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9755: p_table_name => gmf_migration.G_Table_name,
9756: p_context => gmf_migration.G_context,

Line 9755: p_table_name => gmf_migration.G_Table_name,

9751: (
9752: p_run_id => gmf_migration.G_migration_run_id,
9753: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9754: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9755: p_table_name => gmf_migration.G_Table_name,
9756: p_context => gmf_migration.G_context,
9757: p_db_error => NULL,
9758: p_app_short_name => 'GMA'
9759: );

Line 9756: p_context => gmf_migration.G_context,

9752: p_run_id => gmf_migration.G_migration_run_id,
9753: p_log_level => FND_LOG.LEVEL_PROCEDURE,
9754: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
9755: p_table_name => gmf_migration.G_Table_name,
9756: p_context => gmf_migration.G_context,
9757: p_db_error => NULL,
9758: p_app_short_name => 'GMA'
9759: );
9760:

Line 10067: p_run_id => gmf_migration.G_migration_run_id,

10063: **************************************/
10064:
10065: GMA_COMMON_LOGGING.gma_migration_central_log
10066: (
10067: p_run_id => gmf_migration.G_migration_run_id,
10068: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10069: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10070: p_table_name => gmf_migration.G_Table_name,
10071: p_context => gmf_migration.G_context,

Line 10070: p_table_name => gmf_migration.G_Table_name,

10066: (
10067: p_run_id => gmf_migration.G_migration_run_id,
10068: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10069: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10070: p_table_name => gmf_migration.G_Table_name,
10071: p_context => gmf_migration.G_context,
10072: p_db_error => NULL,
10073: p_app_short_name => 'GMA'
10074: );

Line 10071: p_context => gmf_migration.G_context,

10067: p_run_id => gmf_migration.G_migration_run_id,
10068: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10069: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10070: p_table_name => gmf_migration.G_Table_name,
10071: p_context => gmf_migration.G_context,
10072: p_db_error => NULL,
10073: p_app_short_name => 'GMA'
10074: );
10075:

Line 10251: p_run_id => gmf_migration.G_migration_run_id,

10247: **************************************/
10248:
10249: GMA_COMMON_LOGGING.gma_migration_central_log
10250: (
10251: p_run_id => gmf_migration.G_migration_run_id,
10252: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10253: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10254: p_table_name => gmf_migration.G_Table_name,
10255: p_context => gmf_migration.G_context,

Line 10254: p_table_name => gmf_migration.G_Table_name,

10250: (
10251: p_run_id => gmf_migration.G_migration_run_id,
10252: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10253: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10254: p_table_name => gmf_migration.G_Table_name,
10255: p_context => gmf_migration.G_context,
10256: p_db_error => NULL,
10257: p_app_short_name => 'GMA'
10258: );

Line 10255: p_context => gmf_migration.G_context,

10251: p_run_id => gmf_migration.G_migration_run_id,
10252: p_log_level => FND_LOG.LEVEL_PROCEDURE,
10253: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
10254: p_table_name => gmf_migration.G_Table_name,
10255: p_context => gmf_migration.G_context,
10256: p_db_error => NULL,
10257: p_app_short_name => 'GMA'
10258: );
10259:

Line 10505: gmf_migration.Log_Errors (

10501:
10502: /**********************************************
10503: * Handle all the rows which were not migrated *
10504: **********************************************/
10505: gmf_migration.Log_Errors (
10506: p_log_level => 1,
10507: p_from_rowid => NULL,
10508: p_to_rowid => NULL
10509: );

Line 10921: gmf_migration.Log_Errors (

10917:
10918: /**********************************************
10919: * Handle all the rows which were not migrated *
10920: **********************************************/
10921: gmf_migration.Log_Errors (
10922: p_log_level => 1,
10923: p_from_rowid => NULL,
10924: p_to_rowid => NULL
10925: );

Line 11136: gmf_migration.Log_Errors (

11132:
11133: /**********************************************
11134: * Handle all the rows which were not migrated *
11135: **********************************************/
11136: gmf_migration.Log_Errors (
11137: p_log_level => 1,
11138: p_from_rowid => NULL,
11139: p_to_rowid => NULL
11140: );

Line 11234: gmf_migration.Log_Errors (

11230:
11231: /**********************************************
11232: * Handle all the rows which were not migrated *
11233: **********************************************/
11234: gmf_migration.Log_Errors (
11235: p_log_level => 1,
11236: p_from_rowid => NULL,
11237: p_to_rowid => NULL
11238: );

Line 11424: gmf_migration.Log_Errors (

11420:
11421: /**********************************************
11422: * Handle all the rows which were not migrated *
11423: **********************************************/
11424: gmf_migration.Log_Errors (
11425: p_log_level => 1,
11426: p_from_rowid => NULL,
11427: p_to_rowid => NULL
11428: );

Line 11680: gmf_migration.Log_Errors (

11676:
11677: /**********************************************
11678: * Handle all the rows which were not migrated *
11679: **********************************************/
11680: gmf_migration.Log_Errors (
11681: p_log_level => 1,
11682: p_from_rowid => NULL,
11683: p_to_rowid => NULL
11684: );

Line 11929: p_run_id => gmf_migration.G_migration_run_id,

11925: **************************************/
11926:
11927: GMA_COMMON_LOGGING.gma_migration_central_log
11928: (
11929: p_run_id => gmf_migration.G_migration_run_id,
11930: p_log_level => FND_LOG.LEVEL_PROCEDURE,
11931: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
11932: p_table_name => gmf_migration.G_Table_name,
11933: p_context => gmf_migration.G_context,

Line 11932: p_table_name => gmf_migration.G_Table_name,

11928: (
11929: p_run_id => gmf_migration.G_migration_run_id,
11930: p_log_level => FND_LOG.LEVEL_PROCEDURE,
11931: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
11932: p_table_name => gmf_migration.G_Table_name,
11933: p_context => gmf_migration.G_context,
11934: p_db_error => NULL,
11935: p_app_short_name => 'GMA'
11936: );

Line 11933: p_context => gmf_migration.G_context,

11929: p_run_id => gmf_migration.G_migration_run_id,
11930: p_log_level => FND_LOG.LEVEL_PROCEDURE,
11931: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
11932: p_table_name => gmf_migration.G_Table_name,
11933: p_context => gmf_migration.G_context,
11934: p_db_error => NULL,
11935: p_app_short_name => 'GMA'
11936: );
11937:

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

12039: /******************
12040: * Local Variables *
12041: ******************/
12042: l_error_tbl p_error_tbl;
12043: l_table_name VARCHAR2(256) := gmf_migration.G_Table_name;
12044: l_sql_statement VARCHAR2(32000) := 'SELECT count(*) FROM '||l_table_name||' WHERE ';
12045: l_failure_count NUMBER;
12046: l_legal_entity_count PLS_INTEGER := 0;
12047: l_organization_count PLS_INTEGER := 0;

Line 13743: p_run_id => gmf_migration.G_migration_run_id,

13739: * Migration Failure Log Message *
13740: **************************************/
13741: GMA_COMMON_LOGGING.gma_migration_central_log
13742: (
13743: p_run_id => gmf_migration.G_migration_run_id,
13744: p_log_level => FND_LOG.LEVEL_PROCEDURE,
13745: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
13746: p_table_name => gmf_migration.G_Table_name,
13747: p_context => gmf_migration.G_context,

Line 13746: p_table_name => gmf_migration.G_Table_name,

13742: (
13743: p_run_id => gmf_migration.G_migration_run_id,
13744: p_log_level => FND_LOG.LEVEL_PROCEDURE,
13745: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
13746: p_table_name => gmf_migration.G_Table_name,
13747: p_context => gmf_migration.G_context,
13748: p_db_error => NULL,
13749: p_app_short_name => 'GMA'
13750: );

Line 13747: p_context => gmf_migration.G_context,

13743: p_run_id => gmf_migration.G_migration_run_id,
13744: p_log_level => FND_LOG.LEVEL_PROCEDURE,
13745: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
13746: p_table_name => gmf_migration.G_Table_name,
13747: p_context => gmf_migration.G_context,
13748: p_db_error => NULL,
13749: p_app_short_name => 'GMA'
13750: );
13751: ELSE

Line 13757: p_run_id => gmf_migration.G_migration_run_id,

13753: * Migration Success Log Message *
13754: **************************************/
13755: GMA_COMMON_LOGGING.gma_migration_central_log
13756: (
13757: p_run_id => gmf_migration.G_migration_run_id,
13758: p_log_level => FND_LOG.LEVEL_PROCEDURE,
13759: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
13760: p_table_name => gmf_migration.G_Table_name,
13761: p_context => gmf_migration.G_context,

Line 13760: p_table_name => gmf_migration.G_Table_name,

13756: (
13757: p_run_id => gmf_migration.G_migration_run_id,
13758: p_log_level => FND_LOG.LEVEL_PROCEDURE,
13759: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
13760: p_table_name => gmf_migration.G_Table_name,
13761: p_context => gmf_migration.G_context,
13762: p_param1 => 1,
13763: p_param2 => 0,
13764: p_db_error => NULL,

Line 13761: p_context => gmf_migration.G_context,

13757: p_run_id => gmf_migration.G_migration_run_id,
13758: p_log_level => FND_LOG.LEVEL_PROCEDURE,
13759: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
13760: p_table_name => gmf_migration.G_Table_name,
13761: p_context => gmf_migration.G_context,
13762: p_param1 => 1,
13763: p_param2 => 0,
13764: p_db_error => NULL,
13765: p_app_short_name => 'GMA'

Line 13782: p_run_id => gmf_migration.G_migration_run_id,

13778: ***********************************/
13779: IF nvl(l_legal_entity_count,0) > 0 THEN
13780: GMA_COMMON_LOGGING.gma_migration_central_log
13781: (
13782: p_run_id => gmf_migration.G_migration_run_id,
13783: p_log_level => FND_LOG.LEVEL_ERROR,
13784: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13785: p_table_name => gmf_migration.G_Table_name,
13786: p_context => gmf_migration.G_Context,

Line 13785: p_table_name => gmf_migration.G_Table_name,

13781: (
13782: p_run_id => gmf_migration.G_migration_run_id,
13783: p_log_level => FND_LOG.LEVEL_ERROR,
13784: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13785: p_table_name => gmf_migration.G_Table_name,
13786: p_context => gmf_migration.G_Context,
13787: p_token1 => 'TABLE_NAME',
13788: p_token2 => 'COLUMN_NAME',
13789: p_token3 => 'RECORD_COUNT',

Line 13786: p_context => gmf_migration.G_Context,

13782: p_run_id => gmf_migration.G_migration_run_id,
13783: p_log_level => FND_LOG.LEVEL_ERROR,
13784: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13785: p_table_name => gmf_migration.G_Table_name,
13786: p_context => gmf_migration.G_Context,
13787: p_token1 => 'TABLE_NAME',
13788: p_token2 => 'COLUMN_NAME',
13789: p_token3 => 'RECORD_COUNT',
13790: p_param1 => gmf_migration.G_Table_name,

Line 13790: p_param1 => gmf_migration.G_Table_name,

13786: p_context => gmf_migration.G_Context,
13787: p_token1 => 'TABLE_NAME',
13788: p_token2 => 'COLUMN_NAME',
13789: p_token3 => 'RECORD_COUNT',
13790: p_param1 => gmf_migration.G_Table_name,
13791: p_param2 => 'Legal Entities',
13792: p_param3 => l_legal_entity_count,
13793: p_db_error => NULL,
13794: p_app_short_name => 'GMA'

Line 13803: p_run_id => gmf_migration.G_migration_run_id,

13799: ***********************************/
13800: IF nvl(l_organization_count,0) > 0 THEN
13801: GMA_COMMON_LOGGING.gma_migration_central_log
13802: (
13803: p_run_id => gmf_migration.G_migration_run_id,
13804: p_log_level => FND_LOG.LEVEL_ERROR,
13805: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13806: p_table_name => gmf_migration.G_Table_name,
13807: p_context => gmf_migration.G_Context,

Line 13806: p_table_name => gmf_migration.G_Table_name,

13802: (
13803: p_run_id => gmf_migration.G_migration_run_id,
13804: p_log_level => FND_LOG.LEVEL_ERROR,
13805: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13806: p_table_name => gmf_migration.G_Table_name,
13807: p_context => gmf_migration.G_Context,
13808: p_token1 => 'TABLE_NAME',
13809: p_token2 => 'COLUMN_NAME',
13810: p_token3 => 'RECORD_COUNT',

Line 13807: p_context => gmf_migration.G_Context,

13803: p_run_id => gmf_migration.G_migration_run_id,
13804: p_log_level => FND_LOG.LEVEL_ERROR,
13805: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13806: p_table_name => gmf_migration.G_Table_name,
13807: p_context => gmf_migration.G_Context,
13808: p_token1 => 'TABLE_NAME',
13809: p_token2 => 'COLUMN_NAME',
13810: p_token3 => 'RECORD_COUNT',
13811: p_param1 => gmf_migration.G_Table_name,

Line 13811: p_param1 => gmf_migration.G_Table_name,

13807: p_context => gmf_migration.G_Context,
13808: p_token1 => 'TABLE_NAME',
13809: p_token2 => 'COLUMN_NAME',
13810: p_token3 => 'RECORD_COUNT',
13811: p_param1 => gmf_migration.G_Table_name,
13812: p_param2 => 'Organizations',
13813: p_param3 => l_organization_count,
13814: p_db_error => NULL,
13815: p_app_short_name => 'GMA'

Line 13824: p_run_id => gmf_migration.G_migration_run_id,

13820: ******************************************/
13821: IF nvl(l_source_organization_count,0) > 0 THEN
13822: GMA_COMMON_LOGGING.gma_migration_central_log
13823: (
13824: p_run_id => gmf_migration.G_migration_run_id,
13825: p_log_level => FND_LOG.LEVEL_ERROR,
13826: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13827: p_table_name => gmf_migration.G_Table_name,
13828: p_context => gmf_migration.G_Context,

Line 13827: p_table_name => gmf_migration.G_Table_name,

13823: (
13824: p_run_id => gmf_migration.G_migration_run_id,
13825: p_log_level => FND_LOG.LEVEL_ERROR,
13826: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13827: p_table_name => gmf_migration.G_Table_name,
13828: p_context => gmf_migration.G_Context,
13829: p_token1 => 'TABLE_NAME',
13830: p_token2 => 'COLUMN_NAME',
13831: p_token3 => 'RECORD_COUNT',

Line 13828: p_context => gmf_migration.G_Context,

13824: p_run_id => gmf_migration.G_migration_run_id,
13825: p_log_level => FND_LOG.LEVEL_ERROR,
13826: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13827: p_table_name => gmf_migration.G_Table_name,
13828: p_context => gmf_migration.G_Context,
13829: p_token1 => 'TABLE_NAME',
13830: p_token2 => 'COLUMN_NAME',
13831: p_token3 => 'RECORD_COUNT',
13832: p_param1 => gmf_migration.G_Table_name,

Line 13832: p_param1 => gmf_migration.G_Table_name,

13828: p_context => gmf_migration.G_Context,
13829: p_token1 => 'TABLE_NAME',
13830: p_token2 => 'COLUMN_NAME',
13831: p_token3 => 'RECORD_COUNT',
13832: p_param1 => gmf_migration.G_Table_name,
13833: p_param2 => 'Source Organizations',
13834: p_param3 => l_source_organization_count,
13835: p_db_error => NULL,
13836: p_app_short_name => 'GMA'

Line 13845: p_run_id => gmf_migration.G_migration_run_id,

13841: ******************************************/
13842: IF nvl(l_master_organization_count,0) > 0 THEN
13843: GMA_COMMON_LOGGING.gma_migration_central_log
13844: (
13845: p_run_id => gmf_migration.G_migration_run_id,
13846: p_log_level => FND_LOG.LEVEL_ERROR,
13847: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13848: p_table_name => gmf_migration.G_Table_name,
13849: p_context => gmf_migration.G_Context,

Line 13848: p_table_name => gmf_migration.G_Table_name,

13844: (
13845: p_run_id => gmf_migration.G_migration_run_id,
13846: p_log_level => FND_LOG.LEVEL_ERROR,
13847: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13848: p_table_name => gmf_migration.G_Table_name,
13849: p_context => gmf_migration.G_Context,
13850: p_token1 => 'TABLE_NAME',
13851: p_token2 => 'COLUMN_NAME',
13852: p_token3 => 'RECORD_COUNT',

Line 13849: p_context => gmf_migration.G_Context,

13845: p_run_id => gmf_migration.G_migration_run_id,
13846: p_log_level => FND_LOG.LEVEL_ERROR,
13847: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13848: p_table_name => gmf_migration.G_Table_name,
13849: p_context => gmf_migration.G_Context,
13850: p_token1 => 'TABLE_NAME',
13851: p_token2 => 'COLUMN_NAME',
13852: p_token3 => 'RECORD_COUNT',
13853: p_param1 => gmf_migration.G_Table_name,

Line 13853: p_param1 => gmf_migration.G_Table_name,

13849: p_context => gmf_migration.G_Context,
13850: p_token1 => 'TABLE_NAME',
13851: p_token2 => 'COLUMN_NAME',
13852: p_token3 => 'RECORD_COUNT',
13853: p_param1 => gmf_migration.G_Table_name,
13854: p_param2 => 'Master Organizations',
13855: p_param3 => l_master_organization_count,
13856: p_db_error => NULL,
13857: p_app_short_name => 'GMA'

Line 13866: p_run_id => gmf_migration.G_migration_run_id,

13862: ***************************/
13863: IF nvl(l_inventory_item_count,0) > 0 THEN
13864: GMA_COMMON_LOGGING.gma_migration_central_log
13865: (
13866: p_run_id => gmf_migration.G_migration_run_id,
13867: p_log_level => FND_LOG.LEVEL_ERROR,
13868: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13869: p_table_name => gmf_migration.G_Table_name,
13870: p_context => gmf_migration.G_Context,

Line 13869: p_table_name => gmf_migration.G_Table_name,

13865: (
13866: p_run_id => gmf_migration.G_migration_run_id,
13867: p_log_level => FND_LOG.LEVEL_ERROR,
13868: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13869: p_table_name => gmf_migration.G_Table_name,
13870: p_context => gmf_migration.G_Context,
13871: p_token1 => 'TABLE_NAME',
13872: p_token2 => 'COLUMN_NAME',
13873: p_token3 => 'RECORD_COUNT',

Line 13870: p_context => gmf_migration.G_Context,

13866: p_run_id => gmf_migration.G_migration_run_id,
13867: p_log_level => FND_LOG.LEVEL_ERROR,
13868: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13869: p_table_name => gmf_migration.G_Table_name,
13870: p_context => gmf_migration.G_Context,
13871: p_token1 => 'TABLE_NAME',
13872: p_token2 => 'COLUMN_NAME',
13873: p_token3 => 'RECORD_COUNT',
13874: p_param1 => gmf_migration.G_Table_name,

Line 13874: p_param1 => gmf_migration.G_Table_name,

13870: p_context => gmf_migration.G_Context,
13871: p_token1 => 'TABLE_NAME',
13872: p_token2 => 'COLUMN_NAME',
13873: p_token3 => 'RECORD_COUNT',
13874: p_param1 => gmf_migration.G_Table_name,
13875: p_param2 => 'Items',
13876: p_param3 => l_inventory_item_count,
13877: p_db_error => NULL,
13878: p_app_short_name => 'GMA'

Line 13887: p_run_id => gmf_migration.G_migration_run_id,

13883: ***********************************/
13884: IF nvl(l_cost_type_count,0) > 0 THEN
13885: GMA_COMMON_LOGGING.gma_migration_central_log
13886: (
13887: p_run_id => gmf_migration.G_migration_run_id,
13888: p_log_level => FND_LOG.LEVEL_ERROR,
13889: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13890: p_table_name => gmf_migration.G_Table_name,
13891: p_context => gmf_migration.G_Context,

Line 13890: p_table_name => gmf_migration.G_Table_name,

13886: (
13887: p_run_id => gmf_migration.G_migration_run_id,
13888: p_log_level => FND_LOG.LEVEL_ERROR,
13889: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13890: p_table_name => gmf_migration.G_Table_name,
13891: p_context => gmf_migration.G_Context,
13892: p_token1 => 'TABLE_NAME',
13893: p_token2 => 'COLUMN_NAME',
13894: p_token3 => 'RECORD_COUNT',

Line 13891: p_context => gmf_migration.G_Context,

13887: p_run_id => gmf_migration.G_migration_run_id,
13888: p_log_level => FND_LOG.LEVEL_ERROR,
13889: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13890: p_table_name => gmf_migration.G_Table_name,
13891: p_context => gmf_migration.G_Context,
13892: p_token1 => 'TABLE_NAME',
13893: p_token2 => 'COLUMN_NAME',
13894: p_token3 => 'RECORD_COUNT',
13895: p_param1 => gmf_migration.G_Table_name,

Line 13895: p_param1 => gmf_migration.G_Table_name,

13891: p_context => gmf_migration.G_Context,
13892: p_token1 => 'TABLE_NAME',
13893: p_token2 => 'COLUMN_NAME',
13894: p_token3 => 'RECORD_COUNT',
13895: p_param1 => gmf_migration.G_Table_name,
13896: p_param2 => 'Cost Types',
13897: p_param3 => l_cost_type_count,
13898: p_db_error => NULL,
13899: p_app_short_name => 'GMA'

Line 13908: p_run_id => gmf_migration.G_migration_run_id,

13904: ********************************************/
13905: IF nvl(l_prev_cost_type_count,0) > 0 THEN
13906: GMA_COMMON_LOGGING.gma_migration_central_log
13907: (
13908: p_run_id => gmf_migration.G_migration_run_id,
13909: p_log_level => FND_LOG.LEVEL_ERROR,
13910: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13911: p_table_name => gmf_migration.G_Table_name,
13912: p_context => gmf_migration.G_Context,

Line 13911: p_table_name => gmf_migration.G_Table_name,

13907: (
13908: p_run_id => gmf_migration.G_migration_run_id,
13909: p_log_level => FND_LOG.LEVEL_ERROR,
13910: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13911: p_table_name => gmf_migration.G_Table_name,
13912: p_context => gmf_migration.G_Context,
13913: p_token1 => 'TABLE_NAME',
13914: p_token2 => 'COLUMN_NAME',
13915: p_token3 => 'RECORD_COUNT',

Line 13912: p_context => gmf_migration.G_Context,

13908: p_run_id => gmf_migration.G_migration_run_id,
13909: p_log_level => FND_LOG.LEVEL_ERROR,
13910: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13911: p_table_name => gmf_migration.G_Table_name,
13912: p_context => gmf_migration.G_Context,
13913: p_token1 => 'TABLE_NAME',
13914: p_token2 => 'COLUMN_NAME',
13915: p_token3 => 'RECORD_COUNT',
13916: p_param1 => gmf_migration.G_Table_name,

Line 13916: p_param1 => gmf_migration.G_Table_name,

13912: p_context => gmf_migration.G_Context,
13913: p_token1 => 'TABLE_NAME',
13914: p_token2 => 'COLUMN_NAME',
13915: p_token3 => 'RECORD_COUNT',
13916: p_param1 => gmf_migration.G_Table_name,
13917: p_param2 => 'Previous Cost Types',
13918: p_param3 => l_prev_cost_type_count,
13919: p_db_error => NULL,
13920: p_app_short_name => 'GMA'

Line 13929: p_run_id => gmf_migration.G_migration_run_id,

13925: *******************************************/
13926: IF nvl(l_curr_cost_type_count,0) > 0 THEN
13927: GMA_COMMON_LOGGING.gma_migration_central_log
13928: (
13929: p_run_id => gmf_migration.G_migration_run_id,
13930: p_log_level => FND_LOG.LEVEL_ERROR,
13931: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13932: p_table_name => gmf_migration.G_Table_name,
13933: p_context => gmf_migration.G_Context,

Line 13932: p_table_name => gmf_migration.G_Table_name,

13928: (
13929: p_run_id => gmf_migration.G_migration_run_id,
13930: p_log_level => FND_LOG.LEVEL_ERROR,
13931: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13932: p_table_name => gmf_migration.G_Table_name,
13933: p_context => gmf_migration.G_Context,
13934: p_token1 => 'TABLE_NAME',
13935: p_token2 => 'COLUMN_NAME',
13936: p_token3 => 'RECORD_COUNT',

Line 13933: p_context => gmf_migration.G_Context,

13929: p_run_id => gmf_migration.G_migration_run_id,
13930: p_log_level => FND_LOG.LEVEL_ERROR,
13931: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13932: p_table_name => gmf_migration.G_Table_name,
13933: p_context => gmf_migration.G_Context,
13934: p_token1 => 'TABLE_NAME',
13935: p_token2 => 'COLUMN_NAME',
13936: p_token3 => 'RECORD_COUNT',
13937: p_param1 => gmf_migration.G_Table_name,

Line 13937: p_param1 => gmf_migration.G_Table_name,

13933: p_context => gmf_migration.G_Context,
13934: p_token1 => 'TABLE_NAME',
13935: p_token2 => 'COLUMN_NAME',
13936: p_token3 => 'RECORD_COUNT',
13937: p_param1 => gmf_migration.G_Table_name,
13938: p_param2 => 'Current Cost Types',
13939: p_param3 => l_curr_cost_type_count,
13940: p_db_error => NULL,
13941: p_app_short_name => 'GMA'

Line 13950: p_run_id => gmf_migration.G_migration_run_id,

13946: ***********************************/
13947: IF nvl(l_period_count,0) > 0 THEN
13948: GMA_COMMON_LOGGING.gma_migration_central_log
13949: (
13950: p_run_id => gmf_migration.G_migration_run_id,
13951: p_log_level => FND_LOG.LEVEL_ERROR,
13952: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13953: p_table_name => gmf_migration.G_Table_name,
13954: p_context => gmf_migration.G_Context,

Line 13953: p_table_name => gmf_migration.G_Table_name,

13949: (
13950: p_run_id => gmf_migration.G_migration_run_id,
13951: p_log_level => FND_LOG.LEVEL_ERROR,
13952: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13953: p_table_name => gmf_migration.G_Table_name,
13954: p_context => gmf_migration.G_Context,
13955: p_token1 => 'TABLE_NAME',
13956: p_token2 => 'COLUMN_NAME',
13957: p_token3 => 'RECORD_COUNT',

Line 13954: p_context => gmf_migration.G_Context,

13950: p_run_id => gmf_migration.G_migration_run_id,
13951: p_log_level => FND_LOG.LEVEL_ERROR,
13952: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13953: p_table_name => gmf_migration.G_Table_name,
13954: p_context => gmf_migration.G_Context,
13955: p_token1 => 'TABLE_NAME',
13956: p_token2 => 'COLUMN_NAME',
13957: p_token3 => 'RECORD_COUNT',
13958: p_param1 => gmf_migration.G_Table_name,

Line 13958: p_param1 => gmf_migration.G_Table_name,

13954: p_context => gmf_migration.G_Context,
13955: p_token1 => 'TABLE_NAME',
13956: p_token2 => 'COLUMN_NAME',
13957: p_token3 => 'RECORD_COUNT',
13958: p_param1 => gmf_migration.G_Table_name,
13959: p_param2 => 'Periods',
13960: p_param3 => l_period_count,
13961: p_db_error => NULL,
13962: p_app_short_name => 'GMA'

Line 13971: p_run_id => gmf_migration.G_migration_run_id,

13967: ********************************************/
13968: IF nvl(l_prev_period_count,0) > 0 THEN
13969: GMA_COMMON_LOGGING.gma_migration_central_log
13970: (
13971: p_run_id => gmf_migration.G_migration_run_id,
13972: p_log_level => FND_LOG.LEVEL_ERROR,
13973: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13974: p_table_name => gmf_migration.G_Table_name,
13975: p_context => gmf_migration.G_Context,

Line 13974: p_table_name => gmf_migration.G_Table_name,

13970: (
13971: p_run_id => gmf_migration.G_migration_run_id,
13972: p_log_level => FND_LOG.LEVEL_ERROR,
13973: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13974: p_table_name => gmf_migration.G_Table_name,
13975: p_context => gmf_migration.G_Context,
13976: p_token1 => 'TABLE_NAME',
13977: p_token2 => 'COLUMN_NAME',
13978: p_token3 => 'RECORD_COUNT',

Line 13975: p_context => gmf_migration.G_Context,

13971: p_run_id => gmf_migration.G_migration_run_id,
13972: p_log_level => FND_LOG.LEVEL_ERROR,
13973: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13974: p_table_name => gmf_migration.G_Table_name,
13975: p_context => gmf_migration.G_Context,
13976: p_token1 => 'TABLE_NAME',
13977: p_token2 => 'COLUMN_NAME',
13978: p_token3 => 'RECORD_COUNT',
13979: p_param1 => gmf_migration.G_Table_name,

Line 13979: p_param1 => gmf_migration.G_Table_name,

13975: p_context => gmf_migration.G_Context,
13976: p_token1 => 'TABLE_NAME',
13977: p_token2 => 'COLUMN_NAME',
13978: p_token3 => 'RECORD_COUNT',
13979: p_param1 => gmf_migration.G_Table_name,
13980: p_param2 => 'Previous Periods',
13981: p_param3 => l_prev_period_count,
13982: p_db_error => NULL,
13983: p_app_short_name => 'GMA'

Line 13992: p_run_id => gmf_migration.G_migration_run_id,

13988: ********************************************/
13989: IF nvl(l_curr_period_count,0) > 0 THEN
13990: GMA_COMMON_LOGGING.gma_migration_central_log
13991: (
13992: p_run_id => gmf_migration.G_migration_run_id,
13993: p_log_level => FND_LOG.LEVEL_ERROR,
13994: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13995: p_table_name => gmf_migration.G_Table_name,
13996: p_context => gmf_migration.G_Context,

Line 13995: p_table_name => gmf_migration.G_Table_name,

13991: (
13992: p_run_id => gmf_migration.G_migration_run_id,
13993: p_log_level => FND_LOG.LEVEL_ERROR,
13994: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13995: p_table_name => gmf_migration.G_Table_name,
13996: p_context => gmf_migration.G_Context,
13997: p_token1 => 'TABLE_NAME',
13998: p_token2 => 'COLUMN_NAME',
13999: p_token3 => 'RECORD_COUNT',

Line 13996: p_context => gmf_migration.G_Context,

13992: p_run_id => gmf_migration.G_migration_run_id,
13993: p_log_level => FND_LOG.LEVEL_ERROR,
13994: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
13995: p_table_name => gmf_migration.G_Table_name,
13996: p_context => gmf_migration.G_Context,
13997: p_token1 => 'TABLE_NAME',
13998: p_token2 => 'COLUMN_NAME',
13999: p_token3 => 'RECORD_COUNT',
14000: p_param1 => gmf_migration.G_Table_name,

Line 14000: p_param1 => gmf_migration.G_Table_name,

13996: p_context => gmf_migration.G_Context,
13997: p_token1 => 'TABLE_NAME',
13998: p_token2 => 'COLUMN_NAME',
13999: p_token3 => 'RECORD_COUNT',
14000: p_param1 => gmf_migration.G_Table_name,
14001: p_param2 => 'Current Periods',
14002: p_param3 => l_curr_period_count,
14003: p_db_error => NULL,
14004: p_app_short_name => 'GMA'

Line 14013: p_run_id => gmf_migration.G_migration_run_id,

14009: ***********************************/
14010: IF nvl(l_uom_count1,0) > 0 THEN
14011: GMA_COMMON_LOGGING.gma_migration_central_log
14012: (
14013: p_run_id => gmf_migration.G_migration_run_id,
14014: p_log_level => FND_LOG.LEVEL_ERROR,
14015: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14016: p_table_name => gmf_migration.G_Table_name,
14017: p_context => gmf_migration.G_Context,

Line 14016: p_table_name => gmf_migration.G_Table_name,

14012: (
14013: p_run_id => gmf_migration.G_migration_run_id,
14014: p_log_level => FND_LOG.LEVEL_ERROR,
14015: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14016: p_table_name => gmf_migration.G_Table_name,
14017: p_context => gmf_migration.G_Context,
14018: p_token1 => 'TABLE_NAME',
14019: p_token2 => 'COLUMN_NAME',
14020: p_token3 => 'RECORD_COUNT',

Line 14017: p_context => gmf_migration.G_Context,

14013: p_run_id => gmf_migration.G_migration_run_id,
14014: p_log_level => FND_LOG.LEVEL_ERROR,
14015: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14016: p_table_name => gmf_migration.G_Table_name,
14017: p_context => gmf_migration.G_Context,
14018: p_token1 => 'TABLE_NAME',
14019: p_token2 => 'COLUMN_NAME',
14020: p_token3 => 'RECORD_COUNT',
14021: p_param1 => gmf_migration.G_Table_name,

Line 14021: p_param1 => gmf_migration.G_Table_name,

14017: p_context => gmf_migration.G_Context,
14018: p_token1 => 'TABLE_NAME',
14019: p_token2 => 'COLUMN_NAME',
14020: p_token3 => 'RECORD_COUNT',
14021: p_param1 => gmf_migration.G_Table_name,
14022: p_param2 => 'UOMs',
14023: p_param3 => l_uom_count1,
14024: p_db_error => NULL,
14025: p_app_short_name => 'GMA'

Line 14034: p_run_id => gmf_migration.G_migration_run_id,

14030: ***********************************/
14031: IF nvl(l_uom_count2,0) > 0 THEN
14032: GMA_COMMON_LOGGING.gma_migration_central_log
14033: (
14034: p_run_id => gmf_migration.G_migration_run_id,
14035: p_log_level => FND_LOG.LEVEL_ERROR,
14036: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14037: p_table_name => gmf_migration.G_Table_name,
14038: p_context => gmf_migration.G_Context,

Line 14037: p_table_name => gmf_migration.G_Table_name,

14033: (
14034: p_run_id => gmf_migration.G_migration_run_id,
14035: p_log_level => FND_LOG.LEVEL_ERROR,
14036: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14037: p_table_name => gmf_migration.G_Table_name,
14038: p_context => gmf_migration.G_Context,
14039: p_token1 => 'TABLE_NAME',
14040: p_token2 => 'COLUMN_NAME',
14041: p_token3 => 'RECORD_COUNT',

Line 14038: p_context => gmf_migration.G_Context,

14034: p_run_id => gmf_migration.G_migration_run_id,
14035: p_log_level => FND_LOG.LEVEL_ERROR,
14036: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14037: p_table_name => gmf_migration.G_Table_name,
14038: p_context => gmf_migration.G_Context,
14039: p_token1 => 'TABLE_NAME',
14040: p_token2 => 'COLUMN_NAME',
14041: p_token3 => 'RECORD_COUNT',
14042: p_param1 => gmf_migration.G_Table_name,

Line 14042: p_param1 => gmf_migration.G_Table_name,

14038: p_context => gmf_migration.G_Context,
14039: p_token1 => 'TABLE_NAME',
14040: p_token2 => 'COLUMN_NAME',
14041: p_token3 => 'RECORD_COUNT',
14042: p_param1 => gmf_migration.G_Table_name,
14043: p_param2 => 'UOMs',
14044: p_param3 => l_uom_count2,
14045: p_db_error => NULL,
14046: p_app_short_name => 'GMA'

Line 14055: p_run_id => gmf_migration.G_migration_run_id,

14051: ***********************************/
14052: IF nvl(l_uom_count3,0) > 0 THEN
14053: GMA_COMMON_LOGGING.gma_migration_central_log
14054: (
14055: p_run_id => gmf_migration.G_migration_run_id,
14056: p_log_level => FND_LOG.LEVEL_ERROR,
14057: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14058: p_table_name => gmf_migration.G_Table_name,
14059: p_context => gmf_migration.G_Context,

Line 14058: p_table_name => gmf_migration.G_Table_name,

14054: (
14055: p_run_id => gmf_migration.G_migration_run_id,
14056: p_log_level => FND_LOG.LEVEL_ERROR,
14057: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14058: p_table_name => gmf_migration.G_Table_name,
14059: p_context => gmf_migration.G_Context,
14060: p_token1 => 'TABLE_NAME',
14061: p_token2 => 'COLUMN_NAME',
14062: p_token3 => 'RECORD_COUNT',

Line 14059: p_context => gmf_migration.G_Context,

14055: p_run_id => gmf_migration.G_migration_run_id,
14056: p_log_level => FND_LOG.LEVEL_ERROR,
14057: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14058: p_table_name => gmf_migration.G_Table_name,
14059: p_context => gmf_migration.G_Context,
14060: p_token1 => 'TABLE_NAME',
14061: p_token2 => 'COLUMN_NAME',
14062: p_token3 => 'RECORD_COUNT',
14063: p_param1 => gmf_migration.G_Table_name,

Line 14063: p_param1 => gmf_migration.G_Table_name,

14059: p_context => gmf_migration.G_Context,
14060: p_token1 => 'TABLE_NAME',
14061: p_token2 => 'COLUMN_NAME',
14062: p_token3 => 'RECORD_COUNT',
14063: p_param1 => gmf_migration.G_Table_name,
14064: p_param2 => 'UOMs',
14065: p_param3 => l_uom_count3,
14066: p_db_error => NULL,
14067: p_app_short_name => 'GMA'

Line 14076: p_run_id => gmf_migration.G_migration_run_id,

14072: *******************************************/
14073: IF nvl(l_adjustment_ind_count,0) > 0 THEN
14074: GMA_COMMON_LOGGING.gma_migration_central_log
14075: (
14076: p_run_id => gmf_migration.G_migration_run_id,
14077: p_log_level => FND_LOG.LEVEL_ERROR,
14078: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14079: p_table_name => gmf_migration.G_Table_name,
14080: p_context => gmf_migration.G_Context,

Line 14079: p_table_name => gmf_migration.G_Table_name,

14075: (
14076: p_run_id => gmf_migration.G_migration_run_id,
14077: p_log_level => FND_LOG.LEVEL_ERROR,
14078: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14079: p_table_name => gmf_migration.G_Table_name,
14080: p_context => gmf_migration.G_Context,
14081: p_token1 => 'TABLE_NAME',
14082: p_token2 => 'COLUMN_NAME',
14083: p_token3 => 'RECORD_COUNT',

Line 14080: p_context => gmf_migration.G_Context,

14076: p_run_id => gmf_migration.G_migration_run_id,
14077: p_log_level => FND_LOG.LEVEL_ERROR,
14078: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14079: p_table_name => gmf_migration.G_Table_name,
14080: p_context => gmf_migration.G_Context,
14081: p_token1 => 'TABLE_NAME',
14082: p_token2 => 'COLUMN_NAME',
14083: p_token3 => 'RECORD_COUNT',
14084: p_param1 => gmf_migration.G_Table_name,

Line 14084: p_param1 => gmf_migration.G_Table_name,

14080: p_context => gmf_migration.G_Context,
14081: p_token1 => 'TABLE_NAME',
14082: p_token2 => 'COLUMN_NAME',
14083: p_token3 => 'RECORD_COUNT',
14084: p_param1 => gmf_migration.G_Table_name,
14085: p_param2 => 'Adjustment Indicators',
14086: p_param3 => l_adjustment_ind_count,
14087: p_db_error => NULL,
14088: p_app_short_name => 'GMA'

Line 14097: p_run_id => gmf_migration.G_migration_run_id,

14093: ***********************************/
14094: IF nvl(l_lot_number_count,0) > 0 THEN
14095: GMA_COMMON_LOGGING.gma_migration_central_log
14096: (
14097: p_run_id => gmf_migration.G_migration_run_id,
14098: p_log_level => FND_LOG.LEVEL_ERROR,
14099: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14100: p_table_name => gmf_migration.G_Table_name,
14101: p_context => gmf_migration.G_Context,

Line 14100: p_table_name => gmf_migration.G_Table_name,

14096: (
14097: p_run_id => gmf_migration.G_migration_run_id,
14098: p_log_level => FND_LOG.LEVEL_ERROR,
14099: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14100: p_table_name => gmf_migration.G_Table_name,
14101: p_context => gmf_migration.G_Context,
14102: p_token1 => 'TABLE_NAME',
14103: p_token2 => 'COLUMN_NAME',
14104: p_token3 => 'RECORD_COUNT',

Line 14101: p_context => gmf_migration.G_Context,

14097: p_run_id => gmf_migration.G_migration_run_id,
14098: p_log_level => FND_LOG.LEVEL_ERROR,
14099: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14100: p_table_name => gmf_migration.G_Table_name,
14101: p_context => gmf_migration.G_Context,
14102: p_token1 => 'TABLE_NAME',
14103: p_token2 => 'COLUMN_NAME',
14104: p_token3 => 'RECORD_COUNT',
14105: p_param1 => gmf_migration.G_Table_name,

Line 14105: p_param1 => gmf_migration.G_Table_name,

14101: p_context => gmf_migration.G_Context,
14102: p_token1 => 'TABLE_NAME',
14103: p_token2 => 'COLUMN_NAME',
14104: p_token3 => 'RECORD_COUNT',
14105: p_param1 => gmf_migration.G_Table_name,
14106: p_param2 => 'Lot Numbers',
14107: p_param3 => l_lot_number_count,
14108: p_db_error => NULL,
14109: p_app_short_name => 'GMA'

Line 14118: p_run_id => gmf_migration.G_migration_run_id,

14114: ****************************************/
14115: IF nvl(l_unique_error_count,0) > 0 THEN
14116: GMA_COMMON_LOGGING.gma_migration_central_log
14117: (
14118: p_run_id => gmf_migration.G_migration_run_id,
14119: p_log_level => FND_LOG.LEVEL_ERROR,
14120: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14121: p_table_name => gmf_migration.G_Table_name,
14122: p_context => gmf_migration.G_Context,

Line 14121: p_table_name => gmf_migration.G_Table_name,

14117: (
14118: p_run_id => gmf_migration.G_migration_run_id,
14119: p_log_level => FND_LOG.LEVEL_ERROR,
14120: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14121: p_table_name => gmf_migration.G_Table_name,
14122: p_context => gmf_migration.G_Context,
14123: p_token1 => 'TABLE_NAME',
14124: p_token2 => 'COLUMN_NAME',
14125: p_token3 => 'RECORD_COUNT',

Line 14122: p_context => gmf_migration.G_Context,

14118: p_run_id => gmf_migration.G_migration_run_id,
14119: p_log_level => FND_LOG.LEVEL_ERROR,
14120: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14121: p_table_name => gmf_migration.G_Table_name,
14122: p_context => gmf_migration.G_Context,
14123: p_token1 => 'TABLE_NAME',
14124: p_token2 => 'COLUMN_NAME',
14125: p_token3 => 'RECORD_COUNT',
14126: p_param1 => gmf_migration.G_Table_name,

Line 14126: p_param1 => gmf_migration.G_Table_name,

14122: p_context => gmf_migration.G_Context,
14123: p_token1 => 'TABLE_NAME',
14124: p_token2 => 'COLUMN_NAME',
14125: p_token3 => 'RECORD_COUNT',
14126: p_param1 => gmf_migration.G_Table_name,
14127: p_param2 => 'Unique Constraint',
14128: p_param3 => l_unique_error_count,
14129: p_db_error => NULL,
14130: p_app_short_name => 'GMA'

Line 14139: p_run_id => gmf_migration.G_migration_run_id,

14135: ******************************************/
14136: IF nvl(l_not_null_error_count,0) > 0 THEN
14137: GMA_COMMON_LOGGING.gma_migration_central_log
14138: (
14139: p_run_id => gmf_migration.G_migration_run_id,
14140: p_log_level => FND_LOG.LEVEL_ERROR,
14141: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14142: p_table_name => gmf_migration.G_Table_name,
14143: p_context => gmf_migration.G_Context,

Line 14142: p_table_name => gmf_migration.G_Table_name,

14138: (
14139: p_run_id => gmf_migration.G_migration_run_id,
14140: p_log_level => FND_LOG.LEVEL_ERROR,
14141: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14142: p_table_name => gmf_migration.G_Table_name,
14143: p_context => gmf_migration.G_Context,
14144: p_token1 => 'TABLE_NAME',
14145: p_token2 => 'COLUMN_NAME',
14146: p_token3 => 'RECORD_COUNT',

Line 14143: p_context => gmf_migration.G_Context,

14139: p_run_id => gmf_migration.G_migration_run_id,
14140: p_log_level => FND_LOG.LEVEL_ERROR,
14141: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14142: p_table_name => gmf_migration.G_Table_name,
14143: p_context => gmf_migration.G_Context,
14144: p_token1 => 'TABLE_NAME',
14145: p_token2 => 'COLUMN_NAME',
14146: p_token3 => 'RECORD_COUNT',
14147: p_param1 => gmf_migration.G_Table_name,

Line 14147: p_param1 => gmf_migration.G_Table_name,

14143: p_context => gmf_migration.G_Context,
14144: p_token1 => 'TABLE_NAME',
14145: p_token2 => 'COLUMN_NAME',
14146: p_token3 => 'RECORD_COUNT',
14147: p_param1 => gmf_migration.G_Table_name,
14148: p_param2 => 'Not Null Constraint',
14149: p_param3 => l_not_null_error_count,
14150: p_db_error => NULL,
14151: p_app_short_name => 'GMA'

Line 14160: p_run_id => gmf_migration.G_migration_run_id,

14156: ************************************/
14157: IF nvl(l_value_error_count,0) > 0 THEN
14158: GMA_COMMON_LOGGING.gma_migration_central_log
14159: (
14160: p_run_id => gmf_migration.G_migration_run_id,
14161: p_log_level => FND_LOG.LEVEL_ERROR,
14162: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14163: p_table_name => gmf_migration.G_Table_name,
14164: p_context => gmf_migration.G_Context,

Line 14163: p_table_name => gmf_migration.G_Table_name,

14159: (
14160: p_run_id => gmf_migration.G_migration_run_id,
14161: p_log_level => FND_LOG.LEVEL_ERROR,
14162: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14163: p_table_name => gmf_migration.G_Table_name,
14164: p_context => gmf_migration.G_Context,
14165: p_token1 => 'TABLE_NAME',
14166: p_token2 => 'COLUMN_NAME',
14167: p_token3 => 'RECORD_COUNT',

Line 14164: p_context => gmf_migration.G_Context,

14160: p_run_id => gmf_migration.G_migration_run_id,
14161: p_log_level => FND_LOG.LEVEL_ERROR,
14162: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14163: p_table_name => gmf_migration.G_Table_name,
14164: p_context => gmf_migration.G_Context,
14165: p_token1 => 'TABLE_NAME',
14166: p_token2 => 'COLUMN_NAME',
14167: p_token3 => 'RECORD_COUNT',
14168: p_param1 => gmf_migration.G_Table_name,

Line 14168: p_param1 => gmf_migration.G_Table_name,

14164: p_context => gmf_migration.G_Context,
14165: p_token1 => 'TABLE_NAME',
14166: p_token2 => 'COLUMN_NAME',
14167: p_token3 => 'RECORD_COUNT',
14168: p_param1 => gmf_migration.G_Table_name,
14169: p_param2 => 'Invalid Value',
14170: p_param3 => l_value_error_count,
14171: p_db_error => NULL,
14172: p_app_short_name => 'GMA'

Line 14181: p_run_id => gmf_migration.G_migration_run_id,

14177: *******************************************/
14178: IF nvl(l_parent_key_error_count,0) > 0 THEN
14179: GMA_COMMON_LOGGING.gma_migration_central_log
14180: (
14181: p_run_id => gmf_migration.G_migration_run_id,
14182: p_log_level => FND_LOG.LEVEL_ERROR,
14183: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14184: p_table_name => gmf_migration.G_Table_name,
14185: p_context => gmf_migration.G_Context,

Line 14184: p_table_name => gmf_migration.G_Table_name,

14180: (
14181: p_run_id => gmf_migration.G_migration_run_id,
14182: p_log_level => FND_LOG.LEVEL_ERROR,
14183: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14184: p_table_name => gmf_migration.G_Table_name,
14185: p_context => gmf_migration.G_Context,
14186: p_token1 => 'TABLE_NAME',
14187: p_token2 => 'COLUMN_NAME',
14188: p_token3 => 'RECORD_COUNT',

Line 14185: p_context => gmf_migration.G_Context,

14181: p_run_id => gmf_migration.G_migration_run_id,
14182: p_log_level => FND_LOG.LEVEL_ERROR,
14183: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14184: p_table_name => gmf_migration.G_Table_name,
14185: p_context => gmf_migration.G_Context,
14186: p_token1 => 'TABLE_NAME',
14187: p_token2 => 'COLUMN_NAME',
14188: p_token3 => 'RECORD_COUNT',
14189: p_param1 => gmf_migration.G_Table_name,

Line 14189: p_param1 => gmf_migration.G_Table_name,

14185: p_context => gmf_migration.G_Context,
14186: p_token1 => 'TABLE_NAME',
14187: p_token2 => 'COLUMN_NAME',
14188: p_token3 => 'RECORD_COUNT',
14189: p_param1 => gmf_migration.G_Table_name,
14190: p_param2 => 'Parent Key Constraint',
14191: p_param3 => l_parent_key_error_count,
14192: p_db_error => NULL,
14193: p_app_short_name => 'GMA'

Line 14202: p_run_id => gmf_migration.G_migration_run_id,

14198: *************************************/
14199: IF nvl(l_too_long_error_count,0) > 0 THEN
14200: GMA_COMMON_LOGGING.gma_migration_central_log
14201: (
14202: p_run_id => gmf_migration.G_migration_run_id,
14203: p_log_level => FND_LOG.LEVEL_ERROR,
14204: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14205: p_table_name => gmf_migration.G_Table_name,
14206: p_context => gmf_migration.G_Context,

Line 14205: p_table_name => gmf_migration.G_Table_name,

14201: (
14202: p_run_id => gmf_migration.G_migration_run_id,
14203: p_log_level => FND_LOG.LEVEL_ERROR,
14204: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14205: p_table_name => gmf_migration.G_Table_name,
14206: p_context => gmf_migration.G_Context,
14207: p_token1 => 'TABLE_NAME',
14208: p_token2 => 'COLUMN_NAME',
14209: p_token3 => 'RECORD_COUNT',

Line 14206: p_context => gmf_migration.G_Context,

14202: p_run_id => gmf_migration.G_migration_run_id,
14203: p_log_level => FND_LOG.LEVEL_ERROR,
14204: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14205: p_table_name => gmf_migration.G_Table_name,
14206: p_context => gmf_migration.G_Context,
14207: p_token1 => 'TABLE_NAME',
14208: p_token2 => 'COLUMN_NAME',
14209: p_token3 => 'RECORD_COUNT',
14210: p_param1 => gmf_migration.G_Table_name,

Line 14210: p_param1 => gmf_migration.G_Table_name,

14206: p_context => gmf_migration.G_Context,
14207: p_token1 => 'TABLE_NAME',
14208: p_token2 => 'COLUMN_NAME',
14209: p_token3 => 'RECORD_COUNT',
14210: p_param1 => gmf_migration.G_Table_name,
14211: p_param2 => 'Value Too Long Error',
14212: p_param3 => l_too_long_error_count,
14213: p_db_error => NULL,
14214: p_app_short_name => 'GMA'

Line 14223: p_run_id => gmf_migration.G_migration_run_id,

14219: *************************************/
14220: IF nvl(l_invalid_number_error_count,0) > 0 THEN
14221: GMA_COMMON_LOGGING.gma_migration_central_log
14222: (
14223: p_run_id => gmf_migration.G_migration_run_id,
14224: p_log_level => FND_LOG.LEVEL_ERROR,
14225: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14226: p_table_name => gmf_migration.G_Table_name,
14227: p_context => gmf_migration.G_Context,

Line 14226: p_table_name => gmf_migration.G_Table_name,

14222: (
14223: p_run_id => gmf_migration.G_migration_run_id,
14224: p_log_level => FND_LOG.LEVEL_ERROR,
14225: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14226: p_table_name => gmf_migration.G_Table_name,
14227: p_context => gmf_migration.G_Context,
14228: p_token1 => 'TABLE_NAME',
14229: p_token2 => 'COLUMN_NAME',
14230: p_token3 => 'RECORD_COUNT',

Line 14227: p_context => gmf_migration.G_Context,

14223: p_run_id => gmf_migration.G_migration_run_id,
14224: p_log_level => FND_LOG.LEVEL_ERROR,
14225: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14226: p_table_name => gmf_migration.G_Table_name,
14227: p_context => gmf_migration.G_Context,
14228: p_token1 => 'TABLE_NAME',
14229: p_token2 => 'COLUMN_NAME',
14230: p_token3 => 'RECORD_COUNT',
14231: p_param1 => gmf_migration.G_Table_name,

Line 14231: p_param1 => gmf_migration.G_Table_name,

14227: p_context => gmf_migration.G_Context,
14228: p_token1 => 'TABLE_NAME',
14229: p_token2 => 'COLUMN_NAME',
14230: p_token3 => 'RECORD_COUNT',
14231: p_param1 => gmf_migration.G_Table_name,
14232: p_param2 => 'Invalid Number Error',
14233: p_param3 => l_invalid_number_error_count,
14234: p_db_error => NULL,
14235: p_app_short_name => 'GMA'

Line 14244: p_run_id => gmf_migration.G_migration_run_id,

14240: ********************************************/
14241: IF nvl(l_not_picked_up_error_count,0) > 0 THEN
14242: GMA_COMMON_LOGGING.gma_migration_central_log
14243: (
14244: p_run_id => gmf_migration.G_migration_run_id,
14245: p_log_level => FND_LOG.LEVEL_ERROR,
14246: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14247: p_table_name => gmf_migration.G_Table_name,
14248: p_context => gmf_migration.G_Context,

Line 14247: p_table_name => gmf_migration.G_Table_name,

14243: (
14244: p_run_id => gmf_migration.G_migration_run_id,
14245: p_log_level => FND_LOG.LEVEL_ERROR,
14246: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14247: p_table_name => gmf_migration.G_Table_name,
14248: p_context => gmf_migration.G_Context,
14249: p_token1 => 'TABLE_NAME',
14250: p_token2 => 'COLUMN_NAME',
14251: p_token3 => 'RECORD_COUNT',

Line 14248: p_context => gmf_migration.G_Context,

14244: p_run_id => gmf_migration.G_migration_run_id,
14245: p_log_level => FND_LOG.LEVEL_ERROR,
14246: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14247: p_table_name => gmf_migration.G_Table_name,
14248: p_context => gmf_migration.G_Context,
14249: p_token1 => 'TABLE_NAME',
14250: p_token2 => 'COLUMN_NAME',
14251: p_token3 => 'RECORD_COUNT',
14252: p_param1 => gmf_migration.G_Table_name,

Line 14252: p_param1 => gmf_migration.G_Table_name,

14248: p_context => gmf_migration.G_Context,
14249: p_token1 => 'TABLE_NAME',
14250: p_token2 => 'COLUMN_NAME',
14251: p_token3 => 'RECORD_COUNT',
14252: p_param1 => gmf_migration.G_Table_name,
14253: p_param2 => 'Records not Picked up Error',
14254: p_param3 => l_not_picked_up_error_count,
14255: p_db_error => NULL,
14256: p_app_short_name => 'GMA'

Line 14273: p_run_id => gmf_migration.G_migration_run_id,

14269: nvl(l_too_long_error_count,0)
14270: ) > 0 THEN
14271: GMA_COMMON_LOGGING.gma_migration_central_log
14272: (
14273: p_run_id => gmf_migration.G_migration_run_id,
14274: p_log_level => FND_LOG.LEVEL_ERROR,
14275: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14276: p_table_name => gmf_migration.G_Table_name,
14277: p_context => gmf_migration.G_Context,

Line 14276: p_table_name => gmf_migration.G_Table_name,

14272: (
14273: p_run_id => gmf_migration.G_migration_run_id,
14274: p_log_level => FND_LOG.LEVEL_ERROR,
14275: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14276: p_table_name => gmf_migration.G_Table_name,
14277: p_context => gmf_migration.G_Context,
14278: p_token1 => 'TABLE_NAME',
14279: p_token2 => 'COLUMN_NAME',
14280: p_token3 => 'RECORD_COUNT',

Line 14277: p_context => gmf_migration.G_Context,

14273: p_run_id => gmf_migration.G_migration_run_id,
14274: p_log_level => FND_LOG.LEVEL_ERROR,
14275: p_message_token => 'GMA_MIGRATION_ERROR_ABSTRACT',
14276: p_table_name => gmf_migration.G_Table_name,
14277: p_context => gmf_migration.G_Context,
14278: p_token1 => 'TABLE_NAME',
14279: p_token2 => 'COLUMN_NAME',
14280: p_token3 => 'RECORD_COUNT',
14281: p_param1 => gmf_migration.G_Table_name,

Line 14281: p_param1 => gmf_migration.G_Table_name,

14277: p_context => gmf_migration.G_Context,
14278: p_token1 => 'TABLE_NAME',
14279: p_token2 => 'COLUMN_NAME',
14280: p_token3 => 'RECORD_COUNT',
14281: p_param1 => gmf_migration.G_Table_name,
14282: p_param2 => 'Other Errors',
14283: p_param3 => nvl(l_total_error_count,0) - (
14284: nvl(l_unique_error_count,0) +
14285: nvl(l_not_null_error_count,0) +

Line 14302: p_run_id => gmf_migration.G_migration_run_id,

14298: * Migration Success Log Message *
14299: **************************************/
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_PROCEDURE,
14304: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
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_PROCEDURE,
14304: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14305: p_table_name => gmf_migration.G_Table_name,
14306: p_context => gmf_migration.G_context,
14307: p_param1 => 1,
14308: p_param2 => 0,
14309: p_db_error => NULL,

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_PROCEDURE,
14304: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14305: p_table_name => gmf_migration.G_Table_name,
14306: p_context => gmf_migration.G_context,
14307: p_param1 => 1,
14308: p_param2 => 0,
14309: p_db_error => NULL,
14310: p_app_short_name => 'GMA'

Line 14318: p_run_id => gmf_migration.G_migration_run_id,

14314: IF l_error_tbl.count > 0 THEN
14315: FOR i IN l_error_tbl.first..l_error_tbl.last LOOP
14316: GMA_COMMON_LOGGING.gma_migration_central_log
14317: (
14318: p_run_id => gmf_migration.G_migration_run_id,
14319: p_log_level => FND_LOG.LEVEL_ERROR,
14320: p_message_token => 'GMA_MIGRATION_ERROR_DETAIL',
14321: p_table_name => gmf_migration.G_Table_name,
14322: p_context => gmf_migration.G_Context,

Line 14321: p_table_name => gmf_migration.G_Table_name,

14317: (
14318: p_run_id => gmf_migration.G_migration_run_id,
14319: p_log_level => FND_LOG.LEVEL_ERROR,
14320: p_message_token => 'GMA_MIGRATION_ERROR_DETAIL',
14321: p_table_name => gmf_migration.G_Table_name,
14322: p_context => gmf_migration.G_Context,
14323: p_token1 => 'TABLE_NAME',
14324: p_token2 => 'COLUMN_NAME',
14325: p_token3 => 'PARAMETERS',

Line 14322: p_context => gmf_migration.G_Context,

14318: p_run_id => gmf_migration.G_migration_run_id,
14319: p_log_level => FND_LOG.LEVEL_ERROR,
14320: p_message_token => 'GMA_MIGRATION_ERROR_DETAIL',
14321: p_table_name => gmf_migration.G_Table_name,
14322: p_context => gmf_migration.G_Context,
14323: p_token1 => 'TABLE_NAME',
14324: p_token2 => 'COLUMN_NAME',
14325: p_token3 => 'PARAMETERS',
14326: p_token4 => 'RECORD_COUNT',

Line 14341: p_run_id => gmf_migration.G_migration_run_id,

14337: * Migration Success Log Message *
14338: **************************************/
14339: GMA_COMMON_LOGGING.gma_migration_central_log
14340: (
14341: p_run_id => gmf_migration.G_migration_run_id,
14342: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14343: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14344: p_table_name => gmf_migration.G_Table_name,
14345: p_context => gmf_migration.G_context,

Line 14344: p_table_name => gmf_migration.G_Table_name,

14340: (
14341: p_run_id => gmf_migration.G_migration_run_id,
14342: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14343: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14344: p_table_name => gmf_migration.G_Table_name,
14345: p_context => gmf_migration.G_context,
14346: p_param1 => 1,
14347: p_param2 => 0,
14348: p_db_error => NULL,

Line 14345: p_context => gmf_migration.G_context,

14341: p_run_id => gmf_migration.G_migration_run_id,
14342: p_log_level => FND_LOG.LEVEL_PROCEDURE,
14343: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
14344: p_table_name => gmf_migration.G_Table_name,
14345: p_context => gmf_migration.G_context,
14346: p_param1 => 1,
14347: p_param2 => 0,
14348: p_db_error => NULL,
14349: p_app_short_name => 'GMA'

Line 14471: END GMF_MIGRATION;

14467: p_app_short_name => 'GMA'
14468: );
14469: END Migrate_Vendor_id;
14470:
14471: END GMF_MIGRATION;