DBA Data[Home] [Help]

APPS.GMD_NPD_MIGRATE dependencies on GMA_MIGRATION

Line 110: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 113: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',

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,

Line 175: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 192: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 195: p_message_token => 'GMA_MIGRATION_DB_ERROR',

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,

Line 212: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 215: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',

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,

Line 230: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 233: p_message_token => 'GMA_MIGRATION_DB_ERROR',

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,

Line 244: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 344: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 347: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',

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,

Line 386: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 389: p_message_token => 'GMA_MIGRATION_STARTED',

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,

Line 967: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 970: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',

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,

Line 986: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 989: p_message_token => 'GMA_MIGRATION_DB_ERROR',

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,

Line 1000: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 1063: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 1066: p_message_token => 'GMA_MIGRATION_STARTED',

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,

Line 1108: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 1111: p_message_token => 'GMA_MIGRATION_COMPLETED',

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,

Line 1122: GMA_MIGRATION.gma_migration_end (l_run_id => P_migration_run_id);

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;

Line 1128: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 1131: p_message_token => 'GMA_MIGRATION_DB_ERROR',

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,

Line 1142: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 1198: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 1201: p_message_token => 'GMA_MIGRATION_STARTED',

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,

Line 1231: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 1234: p_message_token => 'GMA_MIGRATION_COMPLETED',

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,

Line 1245: GMA_MIGRATION.gma_migration_end (l_run_id => P_migration_run_id);

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;

Line 1250: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 1263: GMA_COMMON_LOGGING.gma_migration_central_log (

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',

Line 1266: p_message_token => 'GMA_MIGRATION_DB_ERROR',

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,

Line 1277: GMA_COMMON_LOGGING.gma_migration_central_log (

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',