[Home] [Help]
42:
43: BEGIN
44:
45: IF (p_progress_ind = 1) THEN
46: GMA_COMMON_LOGGING.gma_migration_central_log (
47: p_run_id => p_migration_run_id,
48: p_log_level => FND_LOG.LEVEL_EVENT,
49: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
50: p_context => 'Quality Setup',
62: END IF;
63:
64:
65: IF (p_progress_ind = 2) THEN
66: GMA_COMMON_LOGGING.gma_migration_central_log (
67: p_run_id => p_migration_run_id,
68: p_log_level => FND_LOG.LEVEL_EVENT,
69: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
70: p_context => 'Quality Setup',
81: p_app_short_name => 'GMD');
82: END IF;
83:
84: IF (p_progress_ind = 3) THEN
85: GMA_COMMON_LOGGING.gma_migration_central_log (
86: p_run_id => p_migration_run_id,
87: p_log_level => FND_LOG.LEVEL_EVENT,
88: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
89: p_context => 'Quality Setup',
125:
126: BEGIN
127:
128: IF (p_progress_ind = 1) THEN
129: GMA_COMMON_LOGGING.gma_migration_central_log (
130: p_run_id => p_migration_run_id,
131: p_log_level => FND_LOG.LEVEL_EVENT,
132: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
133: p_context => 'Quality Samples',
144: p_app_short_name => 'GMD');
145: END IF;
146:
147: IF (p_progress_ind = 2) THEN
148: GMA_COMMON_LOGGING.gma_migration_central_log (
149: p_run_id => p_migration_run_id,
150: p_log_level => FND_LOG.LEVEL_EVENT,
151: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
152: p_context => 'Quality Samples',
163: p_app_short_name => 'GMD');
164: END IF;
165:
166: IF (p_progress_ind = 3) THEN
167: GMA_COMMON_LOGGING.gma_migration_central_log (
168: p_run_id => p_migration_run_id,
169: p_log_level => FND_LOG.LEVEL_EVENT,
170: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
171: p_context => 'Quality Samples',
207:
208: BEGIN
209:
210: IF (p_progress_ind = 1) THEN
211: GMA_COMMON_LOGGING.gma_migration_central_log (
212: p_run_id => p_migration_run_id,
213: p_log_level => FND_LOG.LEVEL_EVENT,
214: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
215: p_context => 'Quality Specifications',
226: p_app_short_name => 'GMD');
227: END IF;
228:
229: IF (p_progress_ind = 2) THEN
230: GMA_COMMON_LOGGING.gma_migration_central_log (
231: p_run_id => p_migration_run_id,
232: p_log_level => FND_LOG.LEVEL_EVENT,
233: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY',
234: p_context => 'Quality Specifications',
242: p_param3 => to_char(GMD_QC_MIG12.g_inv_spec_upd_count),
243: p_param4 => to_char(GMD_QC_MIG12.g_inv_spec_ins_count),
244: p_param5 => to_char(GMD_QC_MIG12.g_inv_spec_err_count),
245: p_app_short_name => 'GMD');
246: GMA_COMMON_LOGGING.gma_migration_central_log (
247: p_run_id => p_migration_run_id,
248: p_log_level => FND_LOG.LEVEL_EVENT,
249: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
250: p_context => 'Quality Specifications',
255: p_app_short_name => 'GMD');
256: END IF;
257:
258: IF (p_progress_ind = 3) THEN
259: GMA_COMMON_LOGGING.gma_migration_central_log (
260: p_run_id => p_migration_run_id,
261: p_log_level => FND_LOG.LEVEL_EVENT,
262: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY',
263: p_context => 'Quality Specifications',
271: p_param3 => to_char(GMD_QC_MIG12.g_wip_spec_upd_count),
272: p_param4 => to_char(GMD_QC_MIG12.g_wip_spec_ins_count),
273: p_param5 => to_char(GMD_QC_MIG12.g_wip_spec_err_count),
274: p_app_short_name => 'GMD');
275: GMA_COMMON_LOGGING.gma_migration_central_log (
276: p_run_id => p_migration_run_id,
277: p_log_level => FND_LOG.LEVEL_EVENT,
278: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
279: p_context => 'Quality Specifications',
284: p_app_short_name => 'GMD');
285: END IF;
286:
287: IF (p_progress_ind = 4) THEN
288: GMA_COMMON_LOGGING.gma_migration_central_log (
289: p_run_id => p_migration_run_id,
290: p_log_level => FND_LOG.LEVEL_EVENT,
291: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY',
292: p_context => 'Quality Specifications',
300: p_param3 => to_char(GMD_QC_MIG12.g_cust_spec_upd_count),
301: p_param4 => to_char(GMD_QC_MIG12.g_cust_spec_ins_count),
302: p_param5 => to_char(GMD_QC_MIG12.g_cust_spec_err_count),
303: p_app_short_name => 'GMD');
304: GMA_COMMON_LOGGING.gma_migration_central_log (
305: p_run_id => p_migration_run_id,
306: p_log_level => FND_LOG.LEVEL_EVENT,
307: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
308: p_context => 'Quality Specifications',
313: p_app_short_name => 'GMD');
314: END IF;
315:
316: IF (p_progress_ind = 5) THEN
317: GMA_COMMON_LOGGING.gma_migration_central_log (
318: p_run_id => p_migration_run_id,
319: p_log_level => FND_LOG.LEVEL_EVENT,
320: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY',
321: p_context => 'Quality Specifications',
329: p_param3 => to_char(GMD_QC_MIG12.g_supl_spec_upd_count),
330: p_param4 => to_char(GMD_QC_MIG12.g_supl_spec_ins_count),
331: p_param5 => to_char(GMD_QC_MIG12.g_supl_spec_err_count),
332: p_app_short_name => 'GMD');
333: GMA_COMMON_LOGGING.gma_migration_central_log (
334: p_run_id => p_migration_run_id,
335: p_log_level => FND_LOG.LEVEL_EVENT,
336: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
337: p_context => 'Quality Specifications',
342: p_app_short_name => 'GMD');
343: END IF;
344:
345: IF (p_progress_ind = 6) THEN
346: GMA_COMMON_LOGGING.gma_migration_central_log (
347: p_run_id => p_migration_run_id,
348: p_log_level => FND_LOG.LEVEL_EVENT,
349: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY',
350: p_context => 'Quality Specifications',
358: p_param3 => to_char(GMD_QC_MIG12.g_mon_spec_upd_count),
359: p_param4 => to_char(GMD_QC_MIG12.g_mon_spec_ins_count),
360: p_param5 => to_char(GMD_QC_MIG12.g_mon_spec_err_count),
361: p_app_short_name => 'GMD');
362: GMA_COMMON_LOGGING.gma_migration_central_log (
363: p_run_id => p_migration_run_id,
364: p_log_level => FND_LOG.LEVEL_EVENT,
365: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
366: p_context => 'Quality Specifications',
397:
398: BEGIN
399:
400: IF (p_progress_ind = 1) THEN
401: GMA_COMMON_LOGGING.gma_migration_central_log (
402: p_run_id => p_migration_run_id,
403: p_log_level => FND_LOG.LEVEL_EVENT,
404: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
405: p_context => 'Quality Stability Studies',
416: p_app_short_name => 'GMD');
417: END IF;
418:
419: IF (p_progress_ind = 2) THEN
420: GMA_COMMON_LOGGING.gma_migration_central_log (
421: p_run_id => p_migration_run_id,
422: p_log_level => FND_LOG.LEVEL_EVENT,
423: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
424: p_context => 'Quality Stability Studies',
435: p_app_short_name => 'GMD');
436: END IF;
437:
438: IF (p_progress_ind = 3) THEN
439: GMA_COMMON_LOGGING.gma_migration_central_log (
440: p_run_id => p_migration_run_id,
441: p_log_level => FND_LOG.LEVEL_EVENT,
442: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
443: p_context => 'Quality Stability Studies',
454: p_app_short_name => 'GMD');
455: END IF;
456:
457: IF (p_progress_ind = 4) THEN
458: GMA_COMMON_LOGGING.gma_migration_central_log (
459: p_run_id => p_migration_run_id,
460: p_log_level => FND_LOG.LEVEL_EVENT,
461: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
462: p_context => 'Quality Stability Studies',
473: p_app_short_name => 'GMD');
474: END IF;
475:
476: IF (p_progress_ind = 5) THEN
477: GMA_COMMON_LOGGING.gma_migration_central_log (
478: p_run_id => p_migration_run_id,
479: p_log_level => FND_LOG.LEVEL_EVENT,
480: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
481: p_context => 'Quality Stability Studies',
492: p_app_short_name => 'GMD');
493: END IF;
494:
495: IF (p_progress_ind = 6) THEN
496: GMA_COMMON_LOGGING.gma_migration_central_log (
497: p_run_id => p_migration_run_id,
498: p_log_level => FND_LOG.LEVEL_EVENT,
499: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
500: p_context => 'Quality Stability Studies',
750:
751: EXCEPTION
752:
753: WHEN TEXT_SEQ_ERROR THEN
754: GMA_COMMON_LOGGING.gma_migration_central_log (
755: p_run_id => p_migration_run_id,
756: p_log_level => FND_LOG.LEVEL_ERROR,
757: p_message_token => 'GMD_MIG_TEXT_SEQ_ERROR',
758: p_table_name => NULL,
988: CLOSE cur_orgn_config;
989: END LOOP;
990: EXCEPTION
991: WHEN OTHERS THEN
992: GMA_COMMON_LOGGING.gma_migration_central_log (
993: p_run_id => p_migration_run_id,
994: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
995: p_message_token => 'GMA_MIGRATION_DB_ERROR',
996: p_context => 'Quality Setup - quality config ins',
1299: l_valfield := 'GEMMS_DEFAULT_LAB_TYPE';
1300: l_value := NVL(l_lab_profile,' ');
1301:
1302: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1303: GMA_COMMON_LOGGING.gma_migration_central_log (
1304: p_run_id => p_migration_run_id,
1305: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1306: p_message_token => 'GMD_MIG_VALUE',
1307: p_context => 'Quality Setup',
1328: /*==============================================
1329: Log Start of gmd_test_method migration.
1330: ==============================================*/
1331:
1332: GMA_COMMON_LOGGING.gma_migration_central_log (
1333: p_run_id => p_migration_run_id,
1334: p_log_level => FND_LOG.LEVEL_EVENT,
1335: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1336: p_table_name => 'GMD_QUALITY_CONFIG',
1399:
1400: EXCEPTION
1401:
1402: WHEN METHOD_ITEM_ERROR THEN
1403: GMA_COMMON_LOGGING.gma_migration_central_log (
1404: p_run_id => p_migration_run_id,
1405: p_log_level => FND_LOG.LEVEL_ERROR,
1406: p_message_token => 'GMD_MIG_INVALID_ITEM',
1407: p_context => 'Quality Setup - gmd_test_methods_b',
1420: WHEN NEXT_TEST_METHOD THEN
1421: NULL;
1422:
1423: WHEN OTHERS THEN
1424: GMA_COMMON_LOGGING.gma_migration_central_log (
1425: p_run_id => p_migration_run_id,
1426: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1427: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1428: p_context => 'Quality Setup - gmd_test_methods_b',
1457: l_valfield := 'QC$EXACTSPECMATCH';
1458: l_value := NVL(P_exact_match,' ');
1459:
1460: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1461: GMA_COMMON_LOGGING.gma_migration_central_log (
1462: p_run_id => p_migration_run_id,
1463: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1464: p_message_token => 'GMD_MIG_VALUE',
1465: p_context => 'Quality Setup',
1484: l_value := NVL(P_inc_opt,' ');
1485:
1486:
1487: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1488: GMA_COMMON_LOGGING.gma_migration_central_log (
1489: p_run_id => p_migration_run_id,
1490: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1491: p_message_token => 'GMD_MIG_VALUE',
1492: p_context => 'Quality Setup',
1513: l_valfield := 'GMD_OPERATION_VERSION_CONTROL';
1514: l_value := NVL(P_version_control,' ');
1515:
1516: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1517: GMA_COMMON_LOGGING.gma_migration_central_log (
1518: p_run_id => p_migration_run_id,
1519: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1520: p_message_token => 'GMD_MIG_VALUE',
1521: p_context => 'Quality Setup',
1533: /*==============================================
1534: Log Start of Quality Config Migration.
1535: ==============================================*/
1536:
1537: GMA_COMMON_LOGGING.gma_migration_central_log (
1538: p_run_id => p_migration_run_id,
1539: p_log_level => FND_LOG.LEVEL_EVENT,
1540: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1541: p_table_name => 'GMD_QUALITY_CONFIG',
1676:
1677: EXCEPTION
1678:
1679: WHEN MIG_NO_ORG THEN
1680: GMA_COMMON_LOGGING.gma_migration_central_log (
1681: p_run_id => p_migration_run_id,
1682: p_log_level => FND_LOG.LEVEL_ERROR,
1683: p_message_token => 'GMD_MIG_NO_ORG',
1684: p_context => 'Quality Setup - quality config update',
1696: x_exception_count := x_exception_count + 1;
1697:
1698:
1699: WHEN REASON_CODE_ERROR THEN
1700: GMA_COMMON_LOGGING.gma_migration_central_log (
1701: p_run_id => p_migration_run_id,
1702: p_log_level => FND_LOG.LEVEL_ERROR,
1703: p_message_token => 'GMD_MIG_REASON_ID',
1704: p_context => 'Quality Setup - quality config update',
1712: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
1713: x_exception_count := x_exception_count + 1;
1714:
1715: WHEN IN_SPEC_ERROR THEN
1716: GMA_COMMON_LOGGING.gma_migration_central_log (
1717: p_run_id => p_migration_run_id,
1718: p_log_level => FND_LOG.LEVEL_ERROR,
1719: p_message_token => 'GMD_MIG_STATUS_ID',
1720: p_context => 'Quality Setup - quality config update',
1728: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
1729: x_exception_count := x_exception_count + 1;
1730:
1731: WHEN OUT_SPEC_ERROR THEN
1732: GMA_COMMON_LOGGING.gma_migration_central_log (
1733: p_run_id => p_migration_run_id,
1734: p_log_level => FND_LOG.LEVEL_ERROR,
1735: p_message_token => 'GMD_MIG_STATUS_ID',
1736: p_context => 'Quality Setup - quality config update',
1744: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
1745: x_exception_count := x_exception_count + 1;
1746:
1747: WHEN GET_LAB_ERROR THEN
1748: GMA_COMMON_LOGGING.gma_migration_central_log (
1749: p_run_id => p_migration_run_id,
1750: p_log_level => FND_LOG.LEVEL_ERROR,
1751: p_message_token => 'GMD_MIG_GET_LAB',
1752: p_context => 'Quality Setup - quality config update',
1760: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
1761: x_exception_count := x_exception_count + 1;
1762:
1763: WHEN OTHERS THEN
1764: GMA_COMMON_LOGGING.gma_migration_central_log (
1765: p_run_id => p_migration_run_id,
1766: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1767: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1768: p_context => 'Quality Setup - quality config update',
2042: WHEN NEXT_CONFIG_INSERT THEN
2043: NULL;
2044:
2045: WHEN GET_ORGN_CODE_ERROR THEN
2046: GMA_COMMON_LOGGING.gma_migration_central_log (
2047: p_run_id => p_migration_run_id,
2048: p_log_level => FND_LOG.LEVEL_ERROR,
2049: p_message_token => 'GMD_MIG_ORG_CODE',
2050: p_context => 'Quality Setup - quality config ins',
2058: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
2059: x_exception_count := x_exception_count + 1;
2060:
2061: WHEN GET_LAB_ERROR THEN
2062: GMA_COMMON_LOGGING.gma_migration_central_log (
2063: p_run_id => p_migration_run_id,
2064: p_log_level => FND_LOG.LEVEL_ERROR,
2065: p_message_token => 'GMD_MIG_GET_LAB',
2066: p_context => 'Quality Setup - quality config ins',
2074: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
2075: x_exception_count := x_exception_count + 1;
2076:
2077: WHEN OTHERS THEN
2078: GMA_COMMON_LOGGING.gma_migration_central_log (
2079: p_run_id => p_migration_run_id,
2080: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2081: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2082: p_context => 'Quality Setup - quality config ins',
2163: WHEN NO_NULL_RECORD THEN
2164: NULL;
2165:
2166: WHEN CONFIG_INCOMPLETE THEN
2167: GMA_COMMON_LOGGING.gma_migration_central_log (
2168: p_run_id => p_migration_run_id,
2169: p_log_level => FND_LOG.LEVEL_ERROR,
2170: p_message_token => 'GMD_MIG_CONFIG_INCOMPLETE',
2171: p_context => 'Quality Setup - quality config ins',
2172: p_app_short_name => 'GMD');
2173: x_exception_count := x_exception_count + 1;
2174:
2175: WHEN CONFIG_FINAL_INCOMPLETE THEN
2176: GMA_COMMON_LOGGING.gma_migration_central_log (
2177: p_run_id => p_migration_run_id,
2178: p_log_level => FND_LOG.LEVEL_ERROR,
2179: p_message_token => 'GMD_MIG_CONFIG_INCOMPLETE2',
2180: p_context => 'Quality Setup - quality config ins',
2181: p_app_short_name => 'GMD');
2182: x_exception_count := x_exception_count + 1;
2183:
2184: WHEN REASON_CODE_ERROR THEN
2185: GMA_COMMON_LOGGING.gma_migration_central_log (
2186: p_run_id => p_migration_run_id,
2187: p_log_level => FND_LOG.LEVEL_ERROR,
2188: p_message_token => 'GMD_MIG_REASON_ID',
2189: p_context => 'Quality Setup - quality config ins',
2197: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
2198: x_exception_count := x_exception_count + 1;
2199:
2200: WHEN IN_SPEC_ERROR THEN
2201: GMA_COMMON_LOGGING.gma_migration_central_log (
2202: p_run_id => p_migration_run_id,
2203: p_log_level => FND_LOG.LEVEL_ERROR,
2204: p_message_token => 'GMD_MIG_STATUS_ID',
2205: p_context => 'Quality Setup - quality config ins',
2213: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
2214: x_exception_count := x_exception_count + 1;
2215:
2216: WHEN OUT_SPEC_ERROR THEN
2217: GMA_COMMON_LOGGING.gma_migration_central_log (
2218: p_run_id => p_migration_run_id,
2219: p_log_level => FND_LOG.LEVEL_ERROR,
2220: p_message_token => 'GMD_MIG_STATUS_ID',
2221: p_context => 'Quality Setup - quality config ins',
2229: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
2230: x_exception_count := x_exception_count + 1;
2231:
2232: WHEN OTHERS THEN
2233: GMA_COMMON_LOGGING.gma_migration_central_log (
2234: p_run_id => p_migration_run_id,
2235: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2236: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2237: p_context => 'Quality Setup - quality config ins',
2254: /*==============================================
2255: Log Start of gmd_sampling_plan_b migration.
2256: ==============================================*/
2257:
2258: GMA_COMMON_LOGGING.gma_migration_central_log (
2259: p_run_id => p_migration_run_id,
2260: p_log_level => FND_LOG.LEVEL_EVENT,
2261: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2262: p_table_name => 'GMD_SAMPLING_PLAN_B',
2307:
2308: EXCEPTION
2309:
2310: WHEN MIG_NO_UOM THEN
2311: GMA_COMMON_LOGGING.gma_migration_central_log (
2312: p_run_id => p_migration_run_id,
2313: p_log_level => FND_LOG.LEVEL_ERROR,
2314: p_message_token => 'GMD_MIG_NO_UOM',
2315: p_context => 'Quality Setup - gmd_sampling_plan',
2324: GMD_QC_MIG12.g_sampling_plan_err_count := GMD_QC_MIG12.g_sampling_plan_err_count + 1;
2325: x_exception_count := x_exception_count + 1;
2326:
2327: WHEN OTHERS THEN
2328: GMA_COMMON_LOGGING.gma_migration_central_log (
2329: p_run_id => p_migration_run_id,
2330: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2331: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2332: p_context => 'Quality Setup - gmd_sampling_plan',
2350:
2351: EXCEPTION
2352:
2353: WHEN DEFAULT_LAB_NULL THEN
2354: GMA_COMMON_LOGGING.gma_migration_central_log (
2355: p_run_id => p_migration_run_id,
2356: p_log_level => FND_LOG.LEVEL_ERROR,
2357: p_message_token => 'GMD_MIG_DEFAULT_LAB_NULL',
2358: p_context => 'Quality Setup - general',
2360:
2361: x_exception_count := x_exception_count + 1;
2362:
2363: WHEN NULL_DEF_ORGANIZATION_ID THEN
2364: GMA_COMMON_LOGGING.gma_migration_central_log (
2365: p_run_id => p_migration_run_id,
2366: p_log_level => FND_LOG.LEVEL_ERROR,
2367: p_message_token => 'GMD_MIG_NULL_DEF_ORG_ID',
2368: p_context => 'Quality Setup - general',
2375: WHEN OTHERS THEN
2376:
2377: LOG_SETUP_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
2378:
2379: GMA_COMMON_LOGGING.gma_migration_central_log (
2380: p_run_id => p_migration_run_id,
2381: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2382: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2383: p_context => 'Quality Setup - general',
2543: /*==============================================
2544: Log Start of gmd_samples migration.
2545: ==============================================*/
2546:
2547: GMA_COMMON_LOGGING.gma_migration_central_log (
2548: p_run_id => p_migration_run_id,
2549: p_log_level => FND_LOG.LEVEL_EVENT,
2550: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2551: p_table_name => 'GMD_SAMPLES',
2963:
2964: EXCEPTION
2965:
2966: WHEN MIG_NO_ORG THEN
2967: GMA_COMMON_LOGGING.gma_migration_central_log (
2968: p_run_id => p_migration_run_id,
2969: p_log_level => FND_LOG.LEVEL_ERROR,
2970: p_message_token => 'GMD_MIG_NO_ORG',
2971: p_context => 'Quality Samples - gmd_samples',
2981: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
2982: x_exception_count := x_exception_count + 1;
2983:
2984: WHEN MIG_NO_LAB_ORG THEN
2985: GMA_COMMON_LOGGING.gma_migration_central_log (
2986: p_run_id => p_migration_run_id,
2987: p_log_level => FND_LOG.LEVEL_ERROR,
2988: p_message_token => 'GMD_MIG_NO_ORG',
2989: p_context => 'Quality Samples - gmd_samples',
2999: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3000: x_exception_count := x_exception_count + 1;
3001:
3002: WHEN MIG_WHSE_ERROR THEN
3003: GMA_COMMON_LOGGING.gma_migration_central_log (
3004: p_run_id => p_migration_run_id,
3005: p_log_level => FND_LOG.LEVEL_ERROR,
3006: p_message_token => 'GMD_MIG_WHSE_ERROR',
3007: p_context => 'Quality Samples - gmd_samples',
3018: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3019: x_exception_count := x_exception_count + 1;
3020:
3021: WHEN MIG_SUBINV_MISMATCH THEN
3022: GMA_COMMON_LOGGING.gma_migration_central_log (
3023: p_run_id => p_migration_run_id,
3024: p_log_level => FND_LOG.LEVEL_ERROR,
3025: p_message_token => 'GMD_MIG_SUBINV_MISMATCH',
3026: p_table_name => NULL,
3040: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3041: x_exception_count := x_exception_count + 1;
3042:
3043: WHEN MIG_NON_LOC_FAIL THEN
3044: GMA_COMMON_LOGGING.gma_migration_central_log (
3045: p_run_id => p_migration_run_id,
3046: p_log_level => FND_LOG.LEVEL_ERROR,
3047: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3048: p_context => 'Quality Samples - gmd_samples',
3057: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3058: x_exception_count := x_exception_count + 1;
3059:
3060: WHEN MIG_LOCATOR_ID THEN
3061: GMA_COMMON_LOGGING.gma_migration_central_log (
3062: p_run_id => p_migration_run_id,
3063: p_log_level => FND_LOG.LEVEL_ERROR,
3064: p_message_token => 'GMD_MIG_LOCATOR_ID',
3065: p_context => 'Quality Samples - gmd_samples',
3078: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3079: x_exception_count := x_exception_count + 1;
3080:
3081: WHEN MIG_SUBINV_ERROR THEN
3082: GMA_COMMON_LOGGING.gma_migration_central_log (
3083: p_run_id => p_migration_run_id,
3084: p_log_level => FND_LOG.LEVEL_ERROR,
3085: p_message_token => 'GMD_MIG_SUBINV',
3086: p_context => 'Quality Samples - gmd_samples',
3096: x_exception_count := x_exception_count + 1;
3097:
3098:
3099: WHEN MIG_STORE_WHSE_ERROR THEN
3100: GMA_COMMON_LOGGING.gma_migration_central_log (
3101: p_run_id => p_migration_run_id,
3102: p_log_level => FND_LOG.LEVEL_ERROR,
3103: p_message_token => 'GMD_MIG_WHSE_ERROR',
3104: p_context => 'Quality Samples - gmd_samples',
3115: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3116: x_exception_count := x_exception_count + 1;
3117:
3118: WHEN MIG_STORE_NON_LOC_ERROR THEN
3119: GMA_COMMON_LOGGING.gma_migration_central_log (
3120: p_run_id => p_migration_run_id,
3121: p_log_level => FND_LOG.LEVEL_ERROR,
3122: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3123: p_context => 'Quality Samples - gmd_samples',
3132: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3133: x_exception_count := x_exception_count + 1;
3134:
3135: WHEN MIG_STORE_LOCATOR_ID THEN
3136: GMA_COMMON_LOGGING.gma_migration_central_log (
3137: p_run_id => p_migration_run_id,
3138: p_log_level => FND_LOG.LEVEL_ERROR,
3139: p_message_token => 'GMD_MIG_LOCATOR_ID',
3140: p_context => 'Quality Samples - gmd_samples',
3155:
3156: -- BEGIN Bug# 5261810
3157: -- Added code to handle exceptions for source_whse and source_location
3158: WHEN MIG_SOURCE_WHSE_ERROR THEN
3159: GMA_COMMON_LOGGING.gma_migration_central_log (
3160: p_run_id => p_migration_run_id,
3161: p_log_level => FND_LOG.LEVEL_ERROR,
3162: p_message_token => 'GMD_MIG_WHSE_ERROR',
3163: p_context => 'Quality Samples - gmd_samples',
3174: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3175: x_exception_count := x_exception_count + 1;
3176:
3177: WHEN MIG_SOURCE_NON_LOC_ERROR THEN
3178: GMA_COMMON_LOGGING.gma_migration_central_log (
3179: p_run_id => p_migration_run_id,
3180: p_log_level => FND_LOG.LEVEL_ERROR,
3181: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3182: p_context => 'Quality Samples - gmd_samples',
3191: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3192: x_exception_count := x_exception_count + 1;
3193:
3194: WHEN MIG_SOURCE_LOCATOR_ID THEN
3195: GMA_COMMON_LOGGING.gma_migration_central_log (
3196: p_run_id => p_migration_run_id,
3197: p_log_level => FND_LOG.LEVEL_ERROR,
3198: p_message_token => 'GMD_MIG_LOCATOR_ID',
3199: p_context => 'Quality Samples - gmd_samples',
3212: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3213: x_exception_count := x_exception_count + 1;
3214:
3215: WHEN MIG_SOURCE_SUBINV_ERROR THEN
3216: GMA_COMMON_LOGGING.gma_migration_central_log (
3217: p_run_id => p_migration_run_id,
3218: p_log_level => FND_LOG.LEVEL_ERROR,
3219: p_message_token => 'GMD_MIG_SUBINV',
3220: p_context => 'Quality Samples - gmd_samples',
3229: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3230: x_exception_count := x_exception_count + 1;
3231: -- End Bug# 5261810
3232: WHEN MIG_ODM_ITEM THEN
3233: GMA_COMMON_LOGGING.gma_migration_central_log (
3234: p_run_id => p_migration_run_id,
3235: p_log_level => FND_LOG.LEVEL_ERROR,
3236: p_message_token => 'GMD_MIG_ODM_ITEM',
3237: p_context => 'Quality Samples - gmd_samples',
3248: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3249: x_exception_count := x_exception_count + 1;
3250:
3251: WHEN MIG_OPM_ITEM THEN
3252: GMA_COMMON_LOGGING.gma_migration_central_log (
3253: p_run_id => p_migration_run_id,
3254: p_log_level => FND_LOG.LEVEL_ERROR,
3255: p_message_token => 'GMD_MIG_OPM_ITEM',
3256: p_context => 'Quality Samples - gmd_samples',
3265: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3266: x_exception_count := x_exception_count + 1;
3267:
3268: WHEN MIG_LOT_ERROR THEN
3269: GMA_COMMON_LOGGING.gma_migration_central_log (
3270: p_run_id => p_migration_run_id,
3271: p_log_level => FND_LOG.LEVEL_ERROR,
3272: p_message_token => 'GMD_MIG_LOT',
3273: p_context => 'Quality Samples - gmd_samples',
3281: x_exception_count := x_exception_count + 1;
3282:
3283: WHEN OTHERS THEN
3284:
3285: GMA_COMMON_LOGGING.gma_migration_central_log (
3286: p_run_id => p_migration_run_id,
3287: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3288: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3289: p_context => 'Quality Samples - gmd_samples',
3307: /*==============================================
3308: Log Start of gmd_sampling_events migration.
3309: ==============================================*/
3310:
3311: GMA_COMMON_LOGGING.gma_migration_central_log (
3312: p_run_id => p_migration_run_id,
3313: p_log_level => FND_LOG.LEVEL_EVENT,
3314: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3315: p_table_name => 'GMD_SAMPLING_EVENTS',
3365:
3366: WHEN MIG_GET_SAMPLE_ERROR THEN
3367: -- Bug# 5462876
3368: -- Supress logging of the following message since there are lot of rows in gmd_sampling_events where there is no corresponding sample row.
3369: /*GMA_COMMON_LOGGING.gma_migration_central_log (
3370: p_run_id => p_migration_run_id,
3371: p_log_level => FND_LOG.LEVEL_ERROR,
3372: p_message_token => 'GMD_MIG_GET_SAMPLE',
3373: p_context => 'Quality Samples - gmd_sampling_events',
3378: x_exception_count := x_exception_count + 1;
3379:
3380: WHEN OTHERS THEN
3381: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3382: GMA_COMMON_LOGGING.gma_migration_central_log (
3383: p_run_id => p_migration_run_id,
3384: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3385: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3386: p_context => 'Quality Samples - gmd_sampling_events',
3402: /*=====================================
3403: Log Start of gmd_results.
3404: =====================================*/
3405:
3406: GMA_COMMON_LOGGING.gma_migration_central_log (
3407: p_run_id => p_migration_run_id,
3408: p_log_level => FND_LOG.LEVEL_EVENT,
3409: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3410: p_table_name => 'GMD_RESULTS',
3511:
3512: EXCEPTION
3513:
3514: WHEN MIG_NO_LAB_ORG THEN
3515: GMA_COMMON_LOGGING.gma_migration_central_log (
3516: p_run_id => p_migration_run_id,
3517: p_log_level => FND_LOG.LEVEL_ERROR,
3518: p_message_token => 'GMD_MIG_NO_ORG',
3519: p_context => 'Quality Samples - gmd_results',
3532: WHEN NEXTRESULT THEN
3533: NULL;
3534:
3535: WHEN MIG_ODM_ITEM THEN
3536: GMA_COMMON_LOGGING.gma_migration_central_log (
3537: p_run_id => p_migration_run_id,
3538: p_log_level => FND_LOG.LEVEL_ERROR,
3539: p_message_token => 'GMD_MIG_ODM_ITEM',
3540: p_context => 'Quality Samples - gmd_results',
3550: GMD_QC_MIG12.g_result_err_count := GMD_QC_MIG12.g_result_err_count + 1;
3551: x_exception_count := x_exception_count + 1;
3552:
3553: WHEN MIG_LOT_ERROR THEN
3554: GMA_COMMON_LOGGING.gma_migration_central_log (
3555: p_run_id => p_migration_run_id,
3556: p_log_level => FND_LOG.LEVEL_ERROR,
3557: p_message_token => 'GMD_MIG_LOT',
3558: p_context => 'Quality Samples - gmd_results',
3565: x_exception_count := x_exception_count + 1;
3566:
3567: WHEN OTHERS THEN
3568: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3569: GMA_COMMON_LOGGING.gma_migration_central_log (
3570: p_run_id => p_migration_run_id,
3571: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3572: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3573: p_context => 'Quality Samples - gmd_results',
3588: EXCEPTION
3589:
3590: WHEN OTHERS THEN
3591: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3592: GMA_COMMON_LOGGING.gma_migration_central_log (
3593: p_run_id => p_migration_run_id,
3594: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3595: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3596: p_context => 'Quality Samples - general',
4087: /*==============================================
4088: Log Start of gmd_specifications_b.
4089: ==============================================*/
4090:
4091: GMA_COMMON_LOGGING.gma_migration_central_log (
4092: p_run_id => p_migration_run_id,
4093: p_log_level => FND_LOG.LEVEL_EVENT,
4094: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
4095: p_table_name => 'GMD_SPECIFICATIONS',
4160:
4161: EXCEPTION
4162:
4163: WHEN MIG_NO_ORG THEN
4164: GMA_COMMON_LOGGING.gma_migration_central_log (
4165: p_run_id => p_migration_run_id,
4166: p_log_level => FND_LOG.LEVEL_ERROR,
4167: p_message_token => 'GMD_MIG_NO_ORG',
4168: p_table_name => NULL,
4179: GMD_QC_MIG12.g_specs_err_count := GMD_QC_MIG12.g_specs_err_count + 1;
4180: x_exception_count := x_exception_count + 1;
4181:
4182: WHEN MIG_ODM_ITEM THEN
4183: GMA_COMMON_LOGGING.gma_migration_central_log (
4184: p_run_id => p_migration_run_id,
4185: p_log_level => FND_LOG.LEVEL_ERROR,
4186: p_message_token => 'GMD_MIG_ODM_ITEM',
4187: p_context => 'Quality Specifications - gmd_specifications_b',
4198: x_exception_count := x_exception_count + 1;
4199:
4200: WHEN OTHERS THEN
4201: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
4202: GMA_COMMON_LOGGING.gma_migration_central_log (
4203: p_run_id => p_migration_run_id,
4204: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
4205: p_message_token => 'GMA_MIGRATION_DB_ERROR',
4206: p_context => 'Quality Specifications - gmd_specifications_b',
4228: /*=======================================
4229: Migrate gmd_inventory_spec_vrs.
4230: =======================================*/
4231:
4232: GMA_COMMON_LOGGING.gma_migration_central_log (
4233: p_run_id => p_migration_run_id,
4234: p_log_level => FND_LOG.LEVEL_EVENT,
4235: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
4236: p_table_name => 'GMD_INVENTORY_SPEC_VRS',
4489: /*========================================
4490: Log the spec record and Delete it
4491: as it is not tied to any Sample.
4492: ========================================*/
4493: GMA_COMMON_LOGGING.gma_migration_central_log (
4494: p_run_id => p_migration_run_id,
4495: p_log_level => FND_LOG.LEVEL_EVENT,
4496: p_message_token => 'GMD_MIG_SPEC_DELETE',
4497: p_table_name => NULL,
4832:
4833: EXCEPTION
4834:
4835: WHEN ISPEC_NO_ORG THEN
4836: GMA_COMMON_LOGGING.gma_migration_central_log (
4837: p_run_id => p_migration_run_id,
4838: p_log_level => FND_LOG.LEVEL_ERROR,
4839: p_message_token => 'GMD_MIG_NO_ORG',
4840: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4853:
4854:
4855: WHEN ISPEC_WHSE_ERROR THEN
4856:
4857: GMA_COMMON_LOGGING.gma_migration_central_log (
4858: p_run_id => p_migration_run_id,
4859: p_log_level => FND_LOG.LEVEL_ERROR,
4860: p_message_token => 'GMD_MIG_WHSE_ERROR',
4861: p_table_name => NULL,
4873: GMD_QC_MIG12.g_inv_spec_err_count := GMD_QC_MIG12.g_inv_spec_err_count + 1;
4874: x_exception_count := x_exception_count + 1;
4875:
4876: WHEN ISPEC_SUB_MISMATCH THEN
4877: GMA_COMMON_LOGGING.gma_migration_central_log (
4878: p_run_id => p_migration_run_id,
4879: p_log_level => FND_LOG.LEVEL_ERROR,
4880: p_message_token => 'GMD_MIG_ISPEC_SUB_MISMATCH',
4881: p_table_name => NULL,
4895: GMD_QC_MIG12.g_inv_spec_err_count := GMD_QC_MIG12.g_inv_spec_err_count + 1;
4896: x_exception_count := x_exception_count + 1;
4897:
4898: WHEN ISPEC_NON_LOC THEN
4899: GMA_COMMON_LOGGING.gma_migration_central_log (
4900: p_run_id => p_migration_run_id,
4901: p_log_level => FND_LOG.LEVEL_ERROR,
4902: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
4903: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4913:
4914:
4915:
4916: WHEN ISPEC_LOCATOR_ID THEN
4917: GMA_COMMON_LOGGING.gma_migration_central_log (
4918: p_run_id => p_migration_run_id,
4919: p_log_level => FND_LOG.LEVEL_ERROR,
4920: p_message_token => 'GMD_MIG_LOCATOR_ID',
4921: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4935: x_exception_count := x_exception_count + 1;
4936:
4937:
4938: WHEN ISPEC_SUBINV THEN
4939: GMA_COMMON_LOGGING.gma_migration_central_log (
4940: p_run_id => p_migration_run_id,
4941: p_log_level => FND_LOG.LEVEL_ERROR,
4942: p_message_token => 'GMD_MIG_SUBINV',
4943: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4953: x_exception_count := x_exception_count + 1;
4954:
4955:
4956: WHEN ISPEC_GET_OPM_LOT THEN
4957: GMA_COMMON_LOGGING.gma_migration_central_log (
4958: p_run_id => p_migration_run_id,
4959: p_log_level => FND_LOG.LEVEL_ERROR,
4960: p_message_token => 'GMD_MIG_GET_OPM_LOT',
4961: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4970: GMD_QC_MIG12.g_inv_spec_err_count := GMD_QC_MIG12.g_inv_spec_err_count + 1;
4971: x_exception_count := x_exception_count + 1;
4972:
4973: WHEN ISPEC_GET_SPEC_ITEM THEN
4974: GMA_COMMON_LOGGING.gma_migration_central_log (
4975: p_run_id => p_migration_run_id,
4976: p_log_level => FND_LOG.LEVEL_ERROR,
4977: p_message_token => 'GMD_MIG_GET_ITEM_SPEC',
4978: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4988: x_exception_count := x_exception_count + 1;
4989:
4990:
4991: WHEN ISPEC_GET_OPM_ITEM THEN
4992: GMA_COMMON_LOGGING.gma_migration_central_log (
4993: p_run_id => p_migration_run_id,
4994: p_log_level => FND_LOG.LEVEL_ERROR,
4995: p_message_token => 'GMD_MIG_OPM_ITEM',
4996: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5006: x_exception_count := x_exception_count + 1;
5007:
5008:
5009: WHEN ISPEC_MIG_LOT THEN
5010: GMA_COMMON_LOGGING.gma_migration_central_log (
5011: p_run_id => p_migration_run_id,
5012: p_log_level => FND_LOG.LEVEL_ERROR,
5013: p_message_token => 'GMD_MIG_LOT',
5014: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5022: x_exception_count := x_exception_count + 1;
5023:
5024:
5025: WHEN ISPEC_IN_STATUS THEN
5026: GMA_COMMON_LOGGING.gma_migration_central_log (
5027: p_run_id => p_migration_run_id,
5028: p_log_level => FND_LOG.LEVEL_ERROR,
5029: p_message_token => 'GMD_MIG_STATUS_ID',
5030: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5040: x_exception_count := x_exception_count + 1;
5041:
5042:
5043: WHEN ISPEC_OUT_STATUS THEN
5044: GMA_COMMON_LOGGING.gma_migration_central_log (
5045: p_run_id => p_migration_run_id,
5046: p_log_level => FND_LOG.LEVEL_ERROR,
5047: p_message_token => 'GMD_MIG_STATUS_ID',
5048: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5060: WHEN ISPEC_DELETE_INVSPEC THEN
5061: NULL;
5062:
5063: WHEN ISPEC_SAMPLE_ORG THEN
5064: GMA_COMMON_LOGGING.gma_migration_central_log (
5065: p_run_id => p_migration_run_id,
5066: p_log_level => FND_LOG.LEVEL_ERROR,
5067: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5068: p_table_name => NULL,
5079: x_exception_count := x_exception_count + 1;
5080:
5081:
5082: WHEN ISPEC_SAMPLE_ORG_ID THEN
5083: GMA_COMMON_LOGGING.gma_migration_central_log (
5084: p_run_id => p_migration_run_id,
5085: p_log_level => FND_LOG.LEVEL_ERROR,
5086: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5087: p_table_name => NULL,
5098: x_exception_count := x_exception_count + 1;
5099:
5100: WHEN OTHERS THEN
5101: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5102: GMA_COMMON_LOGGING.gma_migration_central_log (
5103: p_run_id => p_migration_run_id,
5104: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5105: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5106: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5125: /*================================
5126: Migrate gmd_wip_spec_vrs.
5127: ================================*/
5128:
5129: GMA_COMMON_LOGGING.gma_migration_central_log (
5130: p_run_id => p_migration_run_id,
5131: p_log_level => FND_LOG.LEVEL_EVENT,
5132: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5133: p_table_name => 'GMD_WIP_SPEC_VRS',
5467:
5468: EXCEPTION
5469:
5470: WHEN WIP_NO_ORG THEN
5471: GMA_COMMON_LOGGING.gma_migration_central_log (
5472: p_run_id => p_migration_run_id,
5473: p_log_level => FND_LOG.LEVEL_ERROR,
5474: p_message_token => 'GMD_MIG_NO_ORG',
5475: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5485: GMD_QC_MIG12.g_wip_spec_err_count := GMD_QC_MIG12.g_wip_spec_err_count + 1;
5486: x_exception_count := x_exception_count + 1;
5487:
5488: WHEN WIP_IN_STATUS THEN
5489: GMA_COMMON_LOGGING.gma_migration_central_log (
5490: p_run_id => p_migration_run_id,
5491: p_log_level => FND_LOG.LEVEL_ERROR,
5492: p_message_token => 'GMD_MIG_STATUS_ID',
5493: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5502: x_exception_count := x_exception_count + 1;
5503:
5504:
5505: WHEN WIP_OUT_STATUS THEN
5506: GMA_COMMON_LOGGING.gma_migration_central_log (
5507: p_run_id => p_migration_run_id,
5508: p_log_level => FND_LOG.LEVEL_ERROR,
5509: p_message_token => 'GMD_MIG_STATUS_ID',
5510: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5519: x_exception_count := x_exception_count + 1;
5520:
5521:
5522: WHEN WIP_SPEC_DELETE THEN
5523: GMA_COMMON_LOGGING.gma_migration_central_log (
5524: p_run_id => p_migration_run_id,
5525: p_log_level => FND_LOG.LEVEL_EVENT,
5526: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
5527: p_table_name => NULL,
5530: p_param1 => 'gmd_wip_spec_vrs',
5531: p_app_short_name => 'GMD');
5532:
5533: WHEN WIP_SAMPLE_ORG THEN
5534: GMA_COMMON_LOGGING.gma_migration_central_log (
5535: p_run_id => p_migration_run_id,
5536: p_log_level => FND_LOG.LEVEL_ERROR,
5537: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5538: p_table_name => NULL,
5547: GMD_QC_MIG12.g_wip_spec_err_count := GMD_QC_MIG12.g_wip_spec_err_count + 1;
5548: x_exception_count := x_exception_count + 1;
5549:
5550: WHEN WIP_SAMPLE_ORG_ID THEN
5551: GMA_COMMON_LOGGING.gma_migration_central_log (
5552: p_run_id => p_migration_run_id,
5553: p_log_level => FND_LOG.LEVEL_ERROR,
5554: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5555: p_table_name => NULL,
5566:
5567:
5568: WHEN OTHERS THEN
5569: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5570: GMA_COMMON_LOGGING.gma_migration_central_log (
5571: p_run_id => p_migration_run_id,
5572: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5573: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5574: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5593: /*=======================================
5594: Migrate gmd_customer_spec_vrs.
5595: =======================================*/
5596:
5597: GMA_COMMON_LOGGING.gma_migration_central_log (
5598: p_run_id => p_migration_run_id,
5599: p_log_level => FND_LOG.LEVEL_EVENT,
5600: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5601: p_table_name => 'GMD_CUSTOMER_SPEC_VRS',
5701: NULL;
5702:
5703: WHEN OTHERS THEN
5704: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5705: GMA_COMMON_LOGGING.gma_migration_central_log (
5706: p_run_id => p_migration_run_id,
5707: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5708: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5709: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5849:
5850: EXCEPTION
5851:
5852: WHEN CUST_NO_ORG THEN
5853: GMA_COMMON_LOGGING.gma_migration_central_log (
5854: p_run_id => p_migration_run_id,
5855: p_log_level => FND_LOG.LEVEL_ERROR,
5856: p_message_token => 'GMD_MIG_NO_ORG',
5857: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5868: GMD_QC_MIG12.g_cust_spec_err_count := GMD_QC_MIG12.g_cust_spec_err_count + 1;
5869: x_exception_count := x_exception_count + 1;
5870:
5871: WHEN CUST_SPEC_DELETE THEN
5872: GMA_COMMON_LOGGING.gma_migration_central_log (
5873: p_run_id => p_migration_run_id,
5874: p_log_level => FND_LOG.LEVEL_ERROR,
5875: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
5876: p_table_name => NULL,
5880: p_app_short_name => 'GMD');
5881:
5882:
5883: WHEN CUST_NO_ORG_ID THEN
5884: GMA_COMMON_LOGGING.gma_migration_central_log (
5885: p_run_id => p_migration_run_id,
5886: p_log_level => FND_LOG.LEVEL_ERROR,
5887: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5888: p_table_name => NULL,
5899: x_exception_count := x_exception_count + 1;
5900:
5901: WHEN OTHERS THEN
5902: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5903: GMA_COMMON_LOGGING.gma_migration_central_log (
5904: p_run_id => p_migration_run_id,
5905: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5906: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5907: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5928: /*===================================
5929: Migrate gmd_supplier_spec_vrs.
5930: ===================================*/
5931:
5932: GMA_COMMON_LOGGING.gma_migration_central_log (
5933: p_run_id => p_migration_run_id,
5934: p_log_level => FND_LOG.LEVEL_EVENT,
5935: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5936: p_table_name => 'GMD_SUPPLIER_SPEC_VRS',
6234:
6235: EXCEPTION
6236:
6237: WHEN SUP_NO_ORG THEN
6238: GMA_COMMON_LOGGING.gma_migration_central_log (
6239: p_run_id => p_migration_run_id,
6240: p_log_level => FND_LOG.LEVEL_ERROR,
6241: p_message_token => 'GMD_MIG_NO_ORG',
6242: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6252: GMD_QC_MIG12.g_supl_spec_err_count := GMD_QC_MIG12.g_supl_spec_err_count + 1;
6253: x_exception_count := x_exception_count + 1;
6254:
6255: WHEN SUP_IN_STATUS THEN
6256: GMA_COMMON_LOGGING.gma_migration_central_log (
6257: p_run_id => p_migration_run_id,
6258: p_log_level => FND_LOG.LEVEL_ERROR,
6259: p_message_token => 'GMD_MIG_STATUS_ID',
6260: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6268: GMD_QC_MIG12.g_supl_spec_err_count := GMD_QC_MIG12.g_supl_spec_err_count + 1;
6269: x_exception_count := x_exception_count + 1;
6270:
6271: WHEN SUP_OUT_STATUS THEN
6272: GMA_COMMON_LOGGING.gma_migration_central_log (
6273: p_run_id => p_migration_run_id,
6274: p_log_level => FND_LOG.LEVEL_ERROR,
6275: p_message_token => 'GMD_MIG_STATUS_ID',
6276: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6284: GMD_QC_MIG12.g_supl_spec_err_count := GMD_QC_MIG12.g_supl_spec_err_count + 1;
6285: x_exception_count := x_exception_count + 1;
6286:
6287: WHEN SUP_SPEC_DELETE THEN
6288: GMA_COMMON_LOGGING.gma_migration_central_log (
6289: p_run_id => p_migration_run_id,
6290: p_log_level => FND_LOG.LEVEL_ERROR,
6291: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6292: p_table_name => NULL,
6296: p_app_short_name => 'GMD');
6297:
6298:
6299: WHEN SUP_NO_ORG_ID THEN
6300: GMA_COMMON_LOGGING.gma_migration_central_log (
6301: p_run_id => p_migration_run_id,
6302: p_log_level => FND_LOG.LEVEL_ERROR,
6303: p_message_token => 'GMD_MIG_NULL_ORG_ID',
6304: p_table_name => NULL,
6314: x_exception_count := x_exception_count + 1;
6315:
6316: WHEN OTHERS THEN
6317: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
6318: GMA_COMMON_LOGGING.gma_migration_central_log (
6319: p_run_id => p_migration_run_id,
6320: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
6321: p_message_token => 'GMA_MIGRATION_DB_ERROR',
6322: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6341: /*====================================
6342: Migrate gmd_monitoring_spec_vrs;
6343: ====================================*/
6344:
6345: GMA_COMMON_LOGGING.gma_migration_central_log (
6346: p_run_id => p_migration_run_id,
6347: p_log_level => FND_LOG.LEVEL_EVENT,
6348: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
6349: p_table_name => 'GMD_MONITORING_SPEC_VRS',
6695:
6696: EXCEPTION
6697:
6698: WHEN MON_NO_ORG THEN
6699: GMA_COMMON_LOGGING.gma_migration_central_log (
6700: p_run_id => p_migration_run_id,
6701: p_log_level => FND_LOG.LEVEL_ERROR,
6702: p_message_token => 'GMD_MIG_NO_ORG',
6703: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6713: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
6714: x_exception_count := x_exception_count + 1;
6715:
6716: WHEN MON_NO_RES_ORG THEN
6717: GMA_COMMON_LOGGING.gma_migration_central_log (
6718: p_run_id => p_migration_run_id,
6719: p_log_level => FND_LOG.LEVEL_ERROR,
6720: p_message_token => 'GMD_MIG_NO_ORG',
6721: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6731: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
6732: x_exception_count := x_exception_count + 1;
6733:
6734: WHEN MON_WHSE_ERROR THEN
6735: GMA_COMMON_LOGGING.gma_migration_central_log (
6736: p_run_id => p_migration_run_id,
6737: p_log_level => FND_LOG.LEVEL_ERROR,
6738: p_message_token => 'GMD_MIG_WHSE_ERROR',
6739: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6749: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
6750: x_exception_count := x_exception_count + 1;
6751:
6752: WHEN MON_SUB_MISMATCH THEN
6753: GMA_COMMON_LOGGING.gma_migration_central_log (
6754: p_run_id => p_migration_run_id,
6755: p_log_level => FND_LOG.LEVEL_ERROR,
6756: p_message_token => 'GMD_MIG_MSPEC_SUB_MISMATCH',
6757: p_table_name => NULL,
6770: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
6771: x_exception_count := x_exception_count + 1;
6772:
6773: WHEN MON_CREATE_LOC THEN
6774: GMA_COMMON_LOGGING.gma_migration_central_log (
6775: p_run_id => p_migration_run_id,
6776: p_log_level => FND_LOG.LEVEL_ERROR,
6777: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
6778: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6786: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
6787: x_exception_count := x_exception_count + 1;
6788:
6789: WHEN MON_LOCATOR_ID THEN
6790: GMA_COMMON_LOGGING.gma_migration_central_log (
6791: p_run_id => p_migration_run_id,
6792: p_log_level => FND_LOG.LEVEL_ERROR,
6793: p_message_token => 'GMD_MIG_LOCATOR_ID',
6794: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6806: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
6807: x_exception_count := x_exception_count + 1;
6808:
6809: WHEN MON_SUBINV_ERROR THEN
6810: GMA_COMMON_LOGGING.gma_migration_central_log (
6811: p_run_id => p_migration_run_id,
6812: p_log_level => FND_LOG.LEVEL_ERROR,
6813: p_message_token => 'GMD_MIG_SUBINV',
6814: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6823: x_exception_count := x_exception_count + 1;
6824:
6825:
6826: WHEN MON_SPEC_DELETE THEN
6827: GMA_COMMON_LOGGING.gma_migration_central_log (
6828: p_run_id => p_migration_run_id,
6829: p_log_level => FND_LOG.LEVEL_ERROR,
6830: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6831: p_table_name => NULL,
6834: p_param1 => 'gmd_monitoring_spec_vrs',
6835: p_app_short_name => 'GMD');
6836:
6837: WHEN MON_NO_ORG_ID THEN
6838: GMA_COMMON_LOGGING.gma_migration_central_log (
6839: p_run_id => p_migration_run_id,
6840: p_log_level => FND_LOG.LEVEL_ERROR,
6841: p_message_token => 'GMD_MIG_NULL_ORG_ID',
6842: p_table_name => NULL,
6869: EXCEPTION
6870:
6871: WHEN OTHERS THEN
6872: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
6873: GMA_COMMON_LOGGING.gma_migration_central_log (
6874: p_run_id => p_migration_run_id,
6875: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
6876: p_message_token => 'GMA_MIGRATION_DB_ERROR',
6877: p_context => 'Quality Specifications - general',
7124: /*==============================================
7125: Log Start of gmd_storage_plan_details.
7126: ==============================================*/
7127:
7128: GMA_COMMON_LOGGING.gma_migration_central_log (
7129: p_run_id => p_migration_run_id,
7130: p_log_level => FND_LOG.LEVEL_EVENT,
7131: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7132: p_table_name => 'GMD_STORAGE_PLAN_DETAILS',
7257:
7258: EXCEPTION
7259:
7260: WHEN SP_WHSE_ERROR THEN
7261: GMA_COMMON_LOGGING.gma_migration_central_log (
7262: p_run_id => p_migration_run_id,
7263: p_log_level => FND_LOG.LEVEL_ERROR,
7264: p_message_token => 'GMD_MIG_WHSE_ERROR',
7265: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7275: GMD_QC_MIG12.g_store_plan_err_count := GMD_QC_MIG12.g_store_plan_err_count + 1;
7276: x_exception_count := x_exception_count + 1;
7277:
7278: WHEN SP_CREATE_LOCATION THEN
7279: GMA_COMMON_LOGGING.gma_migration_central_log (
7280: p_run_id => p_migration_run_id,
7281: p_log_level => FND_LOG.LEVEL_ERROR,
7282: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
7283: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7291: GMD_QC_MIG12.g_store_plan_err_count := GMD_QC_MIG12.g_store_plan_err_count + 1;
7292: x_exception_count := x_exception_count + 1;
7293:
7294: WHEN SP_LOCATOR_ID THEN
7295: GMA_COMMON_LOGGING.gma_migration_central_log (
7296: p_run_id => p_migration_run_id,
7297: p_log_level => FND_LOG.LEVEL_ERROR,
7298: p_message_token => 'GMD_MIG_LOCATOR_ID',
7299: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7312: x_exception_count := x_exception_count + 1;
7313:
7314:
7315: WHEN SP_SUBINV_ERROR THEN
7316: GMA_COMMON_LOGGING.gma_migration_central_log (
7317: p_run_id => p_migration_run_id,
7318: p_log_level => FND_LOG.LEVEL_ERROR,
7319: p_message_token => 'GMD_MIG_SUBINV',
7320: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7329: x_exception_count := x_exception_count + 1;
7330:
7331: -- Bug# 5109039
7332: WHEN DEFAULT_SS_ORG_ERROR THEN
7333: GMA_COMMON_LOGGING.gma_migration_central_log (
7334: p_run_id => p_migration_run_id,
7335: p_log_level => FND_LOG.LEVEL_ERROR,
7336: p_message_token => 'GMD_MIG_DEF_SS_ORG_ERROR',
7337: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7340: x_exception_count := x_exception_count + 1;
7341:
7342: WHEN OTHERS THEN
7343: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7344: GMA_COMMON_LOGGING.gma_migration_central_log (
7345: p_run_id => p_migration_run_id,
7346: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7347: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7348: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7366: /*==============================================
7367: Log Start of gmd_stability_studies.
7368: ==============================================*/
7369:
7370: GMA_COMMON_LOGGING.gma_migration_central_log (
7371: p_run_id => p_migration_run_id,
7372: p_log_level => FND_LOG.LEVEL_EVENT,
7373: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7374: p_table_name => 'GMD_STABILITY_STUDIES_B',
7438: GMD_QC_MIG12.g_stab_upd_count := GMD_QC_MIG12.g_stab_upd_count + 1;
7439:
7440: EXCEPTION
7441: WHEN STAB_NO_ORG THEN
7442: GMA_COMMON_LOGGING.gma_migration_central_log (
7443: p_run_id => p_migration_run_id,
7444: p_log_level => FND_LOG.LEVEL_ERROR,
7445: p_message_token => 'GMD_MIG_NO_ORG',
7446: p_context => 'Quality Stability Studies - gmd_stability_studies_b',
7456: GMD_QC_MIG12.g_stab_err_count := GMD_QC_MIG12.g_stab_err_count + 1;
7457: x_exception_count := x_exception_count + 1;
7458:
7459: WHEN STAB_NO_LAB_ORG THEN
7460: GMA_COMMON_LOGGING.gma_migration_central_log (
7461: p_run_id => p_migration_run_id,
7462: p_log_level => FND_LOG.LEVEL_ERROR,
7463: p_message_token => 'GMD_MIG_NO_ORG',
7464: p_context => 'Quality Stability Studies - gmd_stability_studies_b',
7474: GMD_QC_MIG12.g_stab_err_count := GMD_QC_MIG12.g_stab_err_count + 1;
7475: x_exception_count := x_exception_count + 1;
7476:
7477: WHEN STAB_ODM_ITEM THEN
7478: GMA_COMMON_LOGGING.gma_migration_central_log (
7479: p_run_id => p_migration_run_id,
7480: p_log_level => FND_LOG.LEVEL_ERROR,
7481: p_message_token => 'GMD_MIG_ODM_ITEM',
7482: p_context => 'Quality Stability Studies - gmd_stability_studies_b',
7493: x_exception_count := x_exception_count + 1;
7494:
7495: WHEN OTHERS THEN
7496: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7497: GMA_COMMON_LOGGING.gma_migration_central_log (
7498: p_run_id => p_migration_run_id,
7499: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7500: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7501: p_context => 'Quality Stability Studies - gmd_stability_studies_b',
7520: /*==============================================
7521: Log Start of gmd_ss_material_sources.
7522: ==============================================*/
7523:
7524: GMA_COMMON_LOGGING.gma_migration_central_log (
7525: p_run_id => p_migration_run_id,
7526: p_log_level => FND_LOG.LEVEL_EVENT,
7527: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7528: p_table_name => 'GMD_SS_MATERIAL_SOURCES',
7628: GMD_QC_MIG12.g_matl_source_upd_count := GMD_QC_MIG12.g_matl_source_upd_count + 1;
7629:
7630: EXCEPTION
7631: WHEN MATL_NO_ORG THEN
7632: GMA_COMMON_LOGGING.gma_migration_central_log (
7633: p_run_id => p_migration_run_id,
7634: p_log_level => FND_LOG.LEVEL_ERROR,
7635: p_message_token => 'GMD_MIG_NO_ORG',
7636: p_context => 'Quality Stability Studies - gmd_ss_material_sources',
7646: GMD_QC_MIG12.g_matl_source_err_count := GMD_QC_MIG12.g_matl_source_err_count + 1;
7647: x_exception_count := x_exception_count + 1;
7648:
7649: WHEN MATL_GET_SS THEN
7650: GMA_COMMON_LOGGING.gma_migration_central_log (
7651: p_run_id => p_migration_run_id,
7652: p_log_level => FND_LOG.LEVEL_ERROR,
7653: p_message_token => 'GMD_MIG_GET_SS_ERROR',
7654: p_context => 'Quality Stability Studies - gmd_ss_material_sources',
7662: GMD_QC_MIG12.g_matl_source_err_count := GMD_QC_MIG12.g_matl_source_err_count + 1;
7663: x_exception_count := x_exception_count + 1;
7664:
7665: WHEN MATL_PLANT_ORG THEN
7666: GMA_COMMON_LOGGING.gma_migration_central_log (
7667: p_run_id => p_migration_run_id,
7668: p_log_level => FND_LOG.LEVEL_ERROR,
7669: p_message_token => 'GMD_MIG_PLANT_ORG_ID',
7670: p_context => 'Quality Stability Studies - gmd_ss_material_sources',
7680: GMD_QC_MIG12.g_matl_source_err_count := GMD_QC_MIG12.g_matl_source_err_count + 1;
7681: x_exception_count := x_exception_count + 1;
7682:
7683: WHEN MATL_MIG_LOT THEN
7684: GMA_COMMON_LOGGING.gma_migration_central_log (
7685: p_run_id => p_migration_run_id,
7686: p_log_level => FND_LOG.LEVEL_ERROR,
7687: p_message_token => 'GMD_MIG_LOT',
7688: p_context => 'Quality Stability Studies - gmd_ss_material_sources',
7695: x_exception_count := x_exception_count + 1;
7696:
7697: WHEN OTHERS THEN
7698: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7699: GMA_COMMON_LOGGING.gma_migration_central_log (
7700: p_run_id => p_migration_run_id,
7701: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7702: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7703: p_context => 'Quality Stability Studies - gmd_ss_material_sources',
7721: /*===================================
7722: Log Start of gmd_ss_variants.
7723: ===================================*/
7724:
7725: GMA_COMMON_LOGGING.gma_migration_central_log (
7726: p_run_id => p_migration_run_id,
7727: p_log_level => FND_LOG.LEVEL_EVENT,
7728: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7729: p_table_name => 'GMD_SS_VARIANTS',
7845:
7846: EXCEPTION
7847:
7848: WHEN VAR_WHSE_ERROR THEN
7849: GMA_COMMON_LOGGING.gma_migration_central_log (
7850: p_run_id => p_migration_run_id,
7851: p_log_level => FND_LOG.LEVEL_ERROR,
7852: p_message_token => 'GMD_MIG_WHSE_ERROR',
7853: p_context => 'Quality Stability Studies - gmd_ss_variants',
7863: GMD_QC_MIG12.g_ss_variant_err_count := GMD_QC_MIG12.g_ss_variant_err_count + 1;
7864: x_exception_count := x_exception_count + 1;
7865:
7866: WHEN VAR_CREATE_LOC THEN
7867: GMA_COMMON_LOGGING.gma_migration_central_log (
7868: p_run_id => p_migration_run_id,
7869: p_log_level => FND_LOG.LEVEL_ERROR,
7870: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
7871: p_context => 'Quality Stability Studies - gmd_ss_variants',
7879: GMD_QC_MIG12.g_ss_variant_err_count := GMD_QC_MIG12.g_ss_variant_err_count + 1;
7880: x_exception_count := x_exception_count + 1;
7881:
7882: WHEN VAR_LOCATOR_ID THEN
7883: GMA_COMMON_LOGGING.gma_migration_central_log (
7884: p_run_id => p_migration_run_id,
7885: p_log_level => FND_LOG.LEVEL_ERROR,
7886: p_message_token => 'GMD_MIG_LOCATOR_ID',
7887: p_context => 'Quality Stability Studies - gmd_ss_variants',
7899: GMD_QC_MIG12.g_ss_variant_err_count := GMD_QC_MIG12.g_ss_variant_err_count + 1;
7900: x_exception_count := x_exception_count + 1;
7901:
7902: WHEN VAR_SUBINV_ERROR THEN
7903: GMA_COMMON_LOGGING.gma_migration_central_log (
7904: p_run_id => p_migration_run_id,
7905: p_log_level => FND_LOG.LEVEL_ERROR,
7906: p_message_token => 'GMD_MIG_SUBINV',
7907: p_context => 'Quality Stability Studies - gmd_ss_variants',
7917:
7918:
7919: WHEN OTHERS THEN
7920: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7921: GMA_COMMON_LOGGING.gma_migration_central_log (
7922: p_run_id => p_migration_run_id,
7923: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7924: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7925: p_context => 'Quality Stability Studies - gmd_ss_variants',
7970: END IF;
7971:
7972: EXCEPTION
7973: WHEN NULL_DEFAULT_LAB THEN
7974: GMA_COMMON_LOGGING.gma_migration_central_log (
7975: p_run_id => p_migration_run_id,
7976: p_log_level => FND_LOG.LEVEL_ERROR,
7977: p_message_token => 'GMD_MIG_DEFAULT_LAB_NULL',
7978: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',
7981: RETURN;
7982: x_exception_count := x_exception_count + 1;
7983:
7984: WHEN DEFAULT_SS_ORG_ERROR THEN
7985: GMA_COMMON_LOGGING.gma_migration_central_log (
7986: p_run_id => p_migration_run_id,
7987: p_log_level => FND_LOG.LEVEL_ERROR,
7988: p_message_token => 'GMD_MIG_DEF_SS_ORG_ERROR',
7989: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',
7993: RETURN;
7994:
7995: WHEN OTHERS THEN
7996: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7997: GMA_COMMON_LOGGING.gma_migration_central_log (
7998: p_run_id => p_migration_run_id,
7999: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8000: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8001: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',
8011: /*==============================================
8012: Log Start of gmd_storage_package.
8013: ==============================================*/
8014:
8015: GMA_COMMON_LOGGING.gma_migration_central_log (
8016: p_run_id => p_migration_run_id,
8017: p_log_level => FND_LOG.LEVEL_EVENT,
8018: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8019: p_table_name => 'GMD_SS_STORAGE_PACKAGE',
8255: END IF;
8256:
8257: EXCEPTION
8258: WHEN STORE_DEF_ODM_ITEM THEN
8259: GMA_COMMON_LOGGING.gma_migration_central_log (
8260: p_run_id => p_migration_run_id,
8261: p_log_level => FND_LOG.LEVEL_ERROR,
8262: p_message_token => 'GMD_MIG_ODM_ITEM',
8263: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8275: x_exception_count := x_exception_count + 1;
8276:
8277:
8278: WHEN STORE_SS_ORG THEN
8279: GMA_COMMON_LOGGING.gma_migration_central_log (
8280: p_run_id => p_migration_run_id,
8281: p_log_level => FND_LOG.LEVEL_ERROR,
8282: p_message_token => 'GMD_MIG_SS_ORG',
8283: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8292: GMD_QC_MIG12.g_store_pack_err_count := GMD_QC_MIG12.g_store_pack_err_count + 1;
8293: x_exception_count := x_exception_count + 1;
8294:
8295: WHEN STORE_ODM_ITEM THEN
8296: GMA_COMMON_LOGGING.gma_migration_central_log (
8297: p_run_id => p_migration_run_id,
8298: p_log_level => FND_LOG.LEVEL_ERROR,
8299: p_message_token => 'GMD_MIG_ODM_ITEM',
8300: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8313:
8314:
8315: WHEN OTHERS THEN
8316: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8317: GMA_COMMON_LOGGING.gma_migration_central_log (
8318: p_run_id => p_migration_run_id,
8319: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8320: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8321: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8339: /*==============================================
8340: Log Start of gmd_ss_storage_history.
8341: ==============================================*/
8342:
8343: GMA_COMMON_LOGGING.gma_migration_central_log (
8344: p_run_id => p_migration_run_id,
8345: p_log_level => FND_LOG.LEVEL_EVENT,
8346: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8347: p_table_name => 'GMD_SS_STORAGE_HISTORY',
8459: GMD_QC_MIG12.g_ss_storehist_upd_count := GMD_QC_MIG12.g_ss_storehist_upd_count + 1;
8460:
8461: EXCEPTION
8462: WHEN HIST_WHSE_ERROR THEN
8463: GMA_COMMON_LOGGING.gma_migration_central_log (
8464: p_run_id => p_migration_run_id,
8465: p_log_level => FND_LOG.LEVEL_ERROR,
8466: p_message_token => 'GMD_MIG_WHSE_ERROR',
8467: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8477: GMD_QC_MIG12.g_ss_storehist_err_count := GMD_QC_MIG12.g_ss_storehist_err_count + 1;
8478: x_exception_count := x_exception_count + 1;
8479:
8480: WHEN HIST_CREATE_LOC THEN
8481: GMA_COMMON_LOGGING.gma_migration_central_log (
8482: p_run_id => p_migration_run_id,
8483: p_log_level => FND_LOG.LEVEL_ERROR,
8484: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
8485: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8493: GMD_QC_MIG12.g_ss_storehist_err_count := GMD_QC_MIG12.g_ss_storehist_err_count + 1;
8494: x_exception_count := x_exception_count + 1;
8495:
8496: WHEN HIST_LOCATOR_ID THEN
8497: GMA_COMMON_LOGGING.gma_migration_central_log (
8498: p_run_id => p_migration_run_id,
8499: p_log_level => FND_LOG.LEVEL_ERROR,
8500: p_message_token => 'GMD_MIG_LOCATOR_ID',
8501: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8513: GMD_QC_MIG12.g_ss_storehist_err_count := GMD_QC_MIG12.g_ss_storehist_err_count + 1;
8514: x_exception_count := x_exception_count + 1;
8515:
8516: WHEN HIST_SUBINV_ERROR THEN
8517: GMA_COMMON_LOGGING.gma_migration_central_log (
8518: p_run_id => p_migration_run_id,
8519: p_log_level => FND_LOG.LEVEL_ERROR,
8520: p_message_token => 'GMD_MIG_SUBINV',
8521: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8530: x_exception_count := x_exception_count + 1;
8531:
8532: WHEN OTHERS THEN
8533: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8534: GMA_COMMON_LOGGING.gma_migration_central_log (
8535: p_run_id => p_migration_run_id,
8536: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8537: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8538: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8555:
8556: EXCEPTION
8557:
8558: WHEN DEFAULT_SS_ORG_ERROR THEN
8559: GMA_COMMON_LOGGING.gma_migration_central_log (
8560: p_run_id => p_migration_run_id,
8561: p_log_level => FND_LOG.LEVEL_ERROR,
8562: p_message_token => 'GMD_MIG_DEF_SS_ORG_ERROR',
8563: p_context => 'Quality Stability Studies - general',
8566: x_exception_count := x_exception_count + 1;
8567:
8568: WHEN OTHERS THEN
8569: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8570: GMA_COMMON_LOGGING.gma_migration_central_log (
8571: p_run_id => p_migration_run_id,
8572: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8573: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8574: p_context => 'Quality Stability Studies - general',