106: BEGIN
107:
108: X_failure_count := 0;
109:
110: GMA_COMMON_LOGGING.gma_migration_central_log (
111: p_run_id => P_migration_run_id,
112: p_log_level => FND_LOG.LEVEL_PROCEDURE,
113: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
114: p_table_name => 'GMD_PARAMETERS',
109:
110: GMA_COMMON_LOGGING.gma_migration_central_log (
111: p_run_id => P_migration_run_id,
112: p_log_level => FND_LOG.LEVEL_PROCEDURE,
113: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
114: p_table_name => 'GMD_PARAMETERS',
115: p_context => 'PROFILES',
116: p_param1 => NULL,
117: p_param2 => NULL,
171: EXCEPTION
172: WHEN Org_Not_Migrated THEN
173: X_failure_count := X_failure_count + 1;
174:
175: GMA_COMMON_LOGGING.gma_migration_central_log (
176: p_run_id => P_migration_run_id,
177: p_log_level => FND_LOG.LEVEL_ERROR,
178: p_message_token => 'GMD_ORG_NOT_MIGRATED',
179: p_table_name => 'GMD_PARAMETERS',
188:
189: WHEN OTHERS THEN
190: x_failure_count := x_failure_count + 1;
191:
192: GMA_COMMON_LOGGING.gma_migration_central_log (
193: p_run_id => P_migration_run_id,
194: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
195: p_message_token => 'GMA_MIGRATION_DB_ERROR',
196: p_table_name => 'GMD_PARAMETERS',
191:
192: GMA_COMMON_LOGGING.gma_migration_central_log (
193: p_run_id => P_migration_run_id,
194: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
195: p_message_token => 'GMA_MIGRATION_DB_ERROR',
196: p_table_name => 'GMD_PARAMETERS',
197: p_context => 'PROFILES',
198: p_param1 => NULL,
199: p_param2 => NULL,
208: IF (p_commit = FND_API.G_TRUE) THEN
209: COMMIT;
210: END IF;
211:
212: GMA_COMMON_LOGGING.gma_migration_central_log (
213: p_run_id => P_migration_run_id,
214: p_log_level => FND_LOG.LEVEL_PROCEDURE,
215: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
216: p_table_name => 'GMD_PARAMETERS',
211:
212: GMA_COMMON_LOGGING.gma_migration_central_log (
213: p_run_id => P_migration_run_id,
214: p_log_level => FND_LOG.LEVEL_PROCEDURE,
215: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
216: p_table_name => 'GMD_PARAMETERS',
217: p_context => 'PROFILES',
218: p_param1 => l_migrate_count,
219: p_param2 => X_failure_count,
226: EXCEPTION
227: WHEN OTHERS THEN
228: x_failure_count := x_failure_count + 1;
229:
230: GMA_COMMON_LOGGING.gma_migration_central_log (
231: p_run_id => P_migration_run_id,
232: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
233: p_message_token => 'GMA_MIGRATION_DB_ERROR',
234: p_table_name => 'GMD_PARAMETERS',
229:
230: GMA_COMMON_LOGGING.gma_migration_central_log (
231: p_run_id => P_migration_run_id,
232: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
233: p_message_token => 'GMA_MIGRATION_DB_ERROR',
234: p_table_name => 'GMD_PARAMETERS',
235: p_context => 'PROFILES',
236: p_param1 => l_migrate_count,
237: p_param2 => x_failure_count,
240: p_param5 => NULL,
241: p_db_error => SQLERRM,
242: p_app_short_name => 'GMD');
243:
244: GMA_COMMON_LOGGING.gma_migration_central_log (
245: p_run_id => P_migration_run_id,
246: p_log_level => FND_LOG.LEVEL_PROCEDURE,
247: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
248: p_table_name => 'GMD_PARAMETERS',
340:
341: X_failure_count := 0;
342: l_migrate_count := 0;
343:
344: GMA_COMMON_LOGGING.gma_migration_central_log (
345: p_run_id => P_migration_run_id,
346: p_log_level => FND_LOG.LEVEL_PROCEDURE,
347: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
348: p_table_name => 'GMD_PARAMETERS',
343:
344: GMA_COMMON_LOGGING.gma_migration_central_log (
345: p_run_id => P_migration_run_id,
346: p_log_level => FND_LOG.LEVEL_PROCEDURE,
347: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
348: p_table_name => 'GMD_PARAMETERS',
349: p_context => 'PROFILES',
350: p_param1 => NULL,
351: p_param2 => NULL,
382: CLOSE Cur_get_parameter_id;
383:
384:
385: /* Logging the start of the migration*/
386: GMA_COMMON_LOGGING.gma_migration_central_log (
387: p_run_id => P_migration_run_id,
388: p_log_level => FND_LOG.LEVEL_EVENT,
389: p_message_token => 'GMA_MIGRATION_STARTED',
390: p_table_name => 'GMD_PARAMETERS',
385: /* Logging the start of the migration*/
386: GMA_COMMON_LOGGING.gma_migration_central_log (
387: p_run_id => P_migration_run_id,
388: p_log_level => FND_LOG.LEVEL_EVENT,
389: p_message_token => 'GMA_MIGRATION_STARTED',
390: p_table_name => 'GMD_PARAMETERS',
391: p_context => 'PROFILES',
392: p_param1 => NULL,
393: p_param2 => NULL,
963: IF (p_commit = FND_API.G_TRUE) THEN
964: COMMIT;
965: END IF;
966:
967: GMA_COMMON_LOGGING.gma_migration_central_log (
968: p_run_id => P_migration_run_id,
969: p_log_level => FND_LOG.LEVEL_PROCEDURE,
970: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
971: p_table_name => 'GMD_PARAMETERS',
966:
967: GMA_COMMON_LOGGING.gma_migration_central_log (
968: p_run_id => P_migration_run_id,
969: p_log_level => FND_LOG.LEVEL_PROCEDURE,
970: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
971: p_table_name => 'GMD_PARAMETERS',
972: p_context => 'PROFILES',
973: p_param1 => l_migrate_count,
974: p_param2 => 0,
982: EXCEPTION
983: WHEN OTHERS THEN
984: x_failure_count := x_failure_count + 1;
985:
986: GMA_COMMON_LOGGING.gma_migration_central_log (
987: p_run_id => P_migration_run_id,
988: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
989: p_message_token => 'GMA_MIGRATION_DB_ERROR',
990: p_table_name => 'GMD_PARAMETERS',
985:
986: GMA_COMMON_LOGGING.gma_migration_central_log (
987: p_run_id => P_migration_run_id,
988: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
989: p_message_token => 'GMA_MIGRATION_DB_ERROR',
990: p_table_name => 'GMD_PARAMETERS',
991: p_context => 'PROFILES',
992: p_param1 => l_migrate_count,
993: p_param2 => x_failure_count,
996: p_param5 => NULL,
997: p_db_error => SQLERRM,
998: p_app_short_name => 'GMD');
999:
1000: GMA_COMMON_LOGGING.gma_migration_central_log (
1001: p_run_id => P_migration_run_id,
1002: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1003: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1004: p_table_name => 'GMD_PARAMETERS',
1059:
1060: X_failure_count := 0;
1061:
1062: /* Logging the start of the migration*/
1063: GMA_COMMON_LOGGING.gma_migration_central_log (
1064: p_run_id => P_migration_run_id,
1065: p_log_level => FND_LOG.LEVEL_EVENT,
1066: p_message_token => 'GMA_MIGRATION_STARTED',
1067: p_table_name => 'GMD_RECIPES_B',
1062: /* Logging the start of the migration*/
1063: GMA_COMMON_LOGGING.gma_migration_central_log (
1064: p_run_id => P_migration_run_id,
1065: p_log_level => FND_LOG.LEVEL_EVENT,
1066: p_message_token => 'GMA_MIGRATION_STARTED',
1067: p_table_name => 'GMD_RECIPES_B',
1068: p_context => 'GMD_RECIPE_TYPE',
1069: p_param1 => NULL,
1070: p_param2 => NULL,
1104: COMMIT;
1105: END IF;
1106:
1107:
1108: GMA_COMMON_LOGGING.gma_migration_central_log (
1109: p_run_id => P_migration_run_id,
1110: p_log_level => FND_LOG.LEVEL_EVENT,
1111: p_message_token => 'GMA_MIGRATION_COMPLETED',
1112: p_table_name => 'GMD_RECIPES_B',
1107:
1108: GMA_COMMON_LOGGING.gma_migration_central_log (
1109: p_run_id => P_migration_run_id,
1110: p_log_level => FND_LOG.LEVEL_EVENT,
1111: p_message_token => 'GMA_MIGRATION_COMPLETED',
1112: p_table_name => 'GMD_RECIPES_B',
1113: p_context => 'GMD_RECIPE_TYPE',
1114: p_param1 => NULL,
1115: p_param2 => NULL,
1118: p_param5 => NULL,
1119: p_db_error => NULL,
1120: p_app_short_name => 'GMD');
1121:
1122: GMA_MIGRATION.gma_migration_end (l_run_id => P_migration_run_id);
1123:
1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: x_failure_count := x_failure_count + 1;
1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: x_failure_count := x_failure_count + 1;
1127:
1128: GMA_COMMON_LOGGING.gma_migration_central_log (
1129: p_run_id => P_migration_run_id,
1130: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1131: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1132: p_table_name => 'GMD_RECIPES_B',
1127:
1128: GMA_COMMON_LOGGING.gma_migration_central_log (
1129: p_run_id => P_migration_run_id,
1130: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1131: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1132: p_table_name => 'GMD_RECIPES_B',
1133: p_context => 'GMD_RECIPE_TYPE',
1134: p_param1 => NULL,
1135: p_param2 => NULL,
1138: p_param5 => NULL,
1139: p_db_error => SQLERRM,
1140: p_app_short_name => 'GMD');
1141:
1142: GMA_COMMON_LOGGING.gma_migration_central_log (
1143: p_run_id => P_migration_run_id,
1144: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1145: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1146: p_table_name => 'GMD_RECIPES_B',
1194: BEGIN
1195: X_failure_count := 0;
1196:
1197: /* Logging the start of the migration*/
1198: GMA_COMMON_LOGGING.gma_migration_central_log (
1199: p_run_id => P_migration_run_id,
1200: p_log_level => FND_LOG.LEVEL_EVENT,
1201: p_message_token => 'GMA_MIGRATION_STARTED',
1202: p_table_name => 'LM_SPRD_FLS',
1197: /* Logging the start of the migration*/
1198: GMA_COMMON_LOGGING.gma_migration_central_log (
1199: p_run_id => P_migration_run_id,
1200: p_log_level => FND_LOG.LEVEL_EVENT,
1201: p_message_token => 'GMA_MIGRATION_STARTED',
1202: p_table_name => 'LM_SPRD_FLS',
1203: p_context => 'SIMULATOR_LAB_TYPE',
1204: p_param1 => NULL,
1205: p_param2 => NULL,
1227: IF (p_commit = FND_API.G_TRUE) THEN
1228: COMMIT;
1229: END IF;
1230:
1231: GMA_COMMON_LOGGING.gma_migration_central_log (
1232: p_run_id => P_migration_run_id,
1233: p_log_level => FND_LOG.LEVEL_EVENT,
1234: p_message_token => 'GMA_MIGRATION_COMPLETED',
1235: p_table_name => 'LM_SPRD_FLS',
1230:
1231: GMA_COMMON_LOGGING.gma_migration_central_log (
1232: p_run_id => P_migration_run_id,
1233: p_log_level => FND_LOG.LEVEL_EVENT,
1234: p_message_token => 'GMA_MIGRATION_COMPLETED',
1235: p_table_name => 'LM_SPRD_FLS',
1236: p_context => 'SIMULATOR_LAB_TYPE',
1237: p_param1 => NULL,
1238: p_param2 => NULL,
1241: p_param5 => NULL,
1242: p_db_error => NULL,
1243: p_app_short_name => 'GMD');
1244:
1245: GMA_MIGRATION.gma_migration_end (l_run_id => P_migration_run_id);
1246:
1247: EXCEPTION
1248: WHEN ORGN_MISSING THEN
1249: x_failure_count := x_failure_count + 1;
1246:
1247: EXCEPTION
1248: WHEN ORGN_MISSING THEN
1249: x_failure_count := x_failure_count + 1;
1250: GMA_COMMON_LOGGING.gma_migration_central_log (
1251: p_run_id => P_migration_run_id,
1252: p_log_level => FND_LOG.LEVEL_ERROR,
1253: p_message_token => 'GMA_ORGN_MISSING_ERROR',
1254: p_table_name => 'LM_SPRD_FLS',
1259:
1260: WHEN OTHERS THEN
1261: x_failure_count := x_failure_count + 1;
1262:
1263: GMA_COMMON_LOGGING.gma_migration_central_log (
1264: p_run_id => P_migration_run_id,
1265: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1266: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1267: p_table_name => 'LM_SPRD_FLS',
1262:
1263: GMA_COMMON_LOGGING.gma_migration_central_log (
1264: p_run_id => P_migration_run_id,
1265: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1266: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1267: p_table_name => 'LM_SPRD_FLS',
1268: p_context => 'SIMULATOR_LAB_TYPE',
1269: p_param1 => NULL,
1270: p_param2 => NULL,
1273: p_param5 => NULL,
1274: p_db_error => SQLERRM,
1275: p_app_short_name => 'GMD');
1276:
1277: GMA_COMMON_LOGGING.gma_migration_central_log (
1278: p_run_id => P_migration_run_id,
1279: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1280: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1281: p_table_name => 'LM_SPRD_FLS',