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.GMD_QC_MIG12 dependencies on GMA_COMMON_LOGGING

Line 54: GMA_COMMON_LOGGING.gma_migration_central_log (

50:
51: BEGIN
52:
53: IF (p_progress_ind = 1) THEN
54: GMA_COMMON_LOGGING.gma_migration_central_log (
55: p_run_id => p_migration_run_id,
56: p_log_level => FND_LOG.LEVEL_EVENT,
57: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
58: p_context => 'Quality Setup',

Line 74: GMA_COMMON_LOGGING.gma_migration_central_log (

70: END IF;
71:
72:
73: IF (p_progress_ind = 2) THEN
74: GMA_COMMON_LOGGING.gma_migration_central_log (
75: p_run_id => p_migration_run_id,
76: p_log_level => FND_LOG.LEVEL_EVENT,
77: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
78: p_context => 'Quality Setup',

Line 93: GMA_COMMON_LOGGING.gma_migration_central_log (

89: p_app_short_name => 'GMD');
90: END IF;
91:
92: IF (p_progress_ind = 3) THEN
93: GMA_COMMON_LOGGING.gma_migration_central_log (
94: p_run_id => p_migration_run_id,
95: p_log_level => FND_LOG.LEVEL_EVENT,
96: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
97: p_context => 'Quality Setup',

Line 137: GMA_COMMON_LOGGING.gma_migration_central_log (

133:
134: BEGIN
135:
136: IF (p_progress_ind = 1) THEN
137: GMA_COMMON_LOGGING.gma_migration_central_log (
138: p_run_id => p_migration_run_id,
139: p_log_level => FND_LOG.LEVEL_EVENT,
140: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
141: p_context => 'Quality Samples',

Line 156: GMA_COMMON_LOGGING.gma_migration_central_log (

152: p_app_short_name => 'GMD');
153: END IF;
154:
155: IF (p_progress_ind = 2) THEN
156: GMA_COMMON_LOGGING.gma_migration_central_log (
157: p_run_id => p_migration_run_id,
158: p_log_level => FND_LOG.LEVEL_EVENT,
159: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
160: p_context => 'Quality Samples',

Line 175: GMA_COMMON_LOGGING.gma_migration_central_log (

171: p_app_short_name => 'GMD');
172: END IF;
173:
174: IF (p_progress_ind = 3) THEN
175: GMA_COMMON_LOGGING.gma_migration_central_log (
176: p_run_id => p_migration_run_id,
177: p_log_level => FND_LOG.LEVEL_EVENT,
178: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
179: p_context => 'Quality Samples',

Line 219: GMA_COMMON_LOGGING.gma_migration_central_log (

215:
216: BEGIN
217:
218: IF (p_progress_ind = 1) THEN
219: GMA_COMMON_LOGGING.gma_migration_central_log (
220: p_run_id => p_migration_run_id,
221: p_log_level => FND_LOG.LEVEL_EVENT,
222: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
223: p_context => 'Quality Specifications',

Line 238: GMA_COMMON_LOGGING.gma_migration_central_log (

234: p_app_short_name => 'GMD');
235: END IF;
236:
237: IF (p_progress_ind = 2) THEN
238: GMA_COMMON_LOGGING.gma_migration_central_log (
239: p_run_id => p_migration_run_id,
240: p_log_level => FND_LOG.LEVEL_EVENT,
241: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY',
242: p_context => 'Quality Specifications',

Line 254: GMA_COMMON_LOGGING.gma_migration_central_log (

250: p_param3 => to_char(GMD_QC_MIG12.g_inv_spec_upd_count),
251: p_param4 => to_char(GMD_QC_MIG12.g_inv_spec_ins_count),
252: p_param5 => to_char(GMD_QC_MIG12.g_inv_spec_err_count),
253: p_app_short_name => 'GMD');
254: GMA_COMMON_LOGGING.gma_migration_central_log (
255: p_run_id => p_migration_run_id,
256: p_log_level => FND_LOG.LEVEL_EVENT,
257: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
258: p_context => 'Quality Specifications',

Line 267: GMA_COMMON_LOGGING.gma_migration_central_log (

263: p_app_short_name => 'GMD');
264: END IF;
265:
266: IF (p_progress_ind = 3) THEN
267: GMA_COMMON_LOGGING.gma_migration_central_log (
268: p_run_id => p_migration_run_id,
269: p_log_level => FND_LOG.LEVEL_EVENT,
270: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY',
271: p_context => 'Quality Specifications',

Line 283: GMA_COMMON_LOGGING.gma_migration_central_log (

279: p_param3 => to_char(GMD_QC_MIG12.g_wip_spec_upd_count),
280: p_param4 => to_char(GMD_QC_MIG12.g_wip_spec_ins_count),
281: p_param5 => to_char(GMD_QC_MIG12.g_wip_spec_err_count),
282: p_app_short_name => 'GMD');
283: GMA_COMMON_LOGGING.gma_migration_central_log (
284: p_run_id => p_migration_run_id,
285: p_log_level => FND_LOG.LEVEL_EVENT,
286: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
287: p_context => 'Quality Specifications',

Line 296: GMA_COMMON_LOGGING.gma_migration_central_log (

292: p_app_short_name => 'GMD');
293: END IF;
294:
295: IF (p_progress_ind = 4) THEN
296: GMA_COMMON_LOGGING.gma_migration_central_log (
297: p_run_id => p_migration_run_id,
298: p_log_level => FND_LOG.LEVEL_EVENT,
299: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY',
300: p_context => 'Quality Specifications',

Line 312: GMA_COMMON_LOGGING.gma_migration_central_log (

308: p_param3 => to_char(GMD_QC_MIG12.g_cust_spec_upd_count),
309: p_param4 => to_char(GMD_QC_MIG12.g_cust_spec_ins_count),
310: p_param5 => to_char(GMD_QC_MIG12.g_cust_spec_err_count),
311: p_app_short_name => 'GMD');
312: GMA_COMMON_LOGGING.gma_migration_central_log (
313: p_run_id => p_migration_run_id,
314: p_log_level => FND_LOG.LEVEL_EVENT,
315: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
316: p_context => 'Quality Specifications',

Line 325: GMA_COMMON_LOGGING.gma_migration_central_log (

321: p_app_short_name => 'GMD');
322: END IF;
323:
324: IF (p_progress_ind = 5) THEN
325: GMA_COMMON_LOGGING.gma_migration_central_log (
326: p_run_id => p_migration_run_id,
327: p_log_level => FND_LOG.LEVEL_EVENT,
328: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY',
329: p_context => 'Quality Specifications',

Line 341: GMA_COMMON_LOGGING.gma_migration_central_log (

337: p_param3 => to_char(GMD_QC_MIG12.g_supl_spec_upd_count),
338: p_param4 => to_char(GMD_QC_MIG12.g_supl_spec_ins_count),
339: p_param5 => to_char(GMD_QC_MIG12.g_supl_spec_err_count),
340: p_app_short_name => 'GMD');
341: GMA_COMMON_LOGGING.gma_migration_central_log (
342: p_run_id => p_migration_run_id,
343: p_log_level => FND_LOG.LEVEL_EVENT,
344: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
345: p_context => 'Quality Specifications',

Line 354: GMA_COMMON_LOGGING.gma_migration_central_log (

350: p_app_short_name => 'GMD');
351: END IF;
352:
353: IF (p_progress_ind = 6) THEN
354: GMA_COMMON_LOGGING.gma_migration_central_log (
355: p_run_id => p_migration_run_id,
356: p_log_level => FND_LOG.LEVEL_EVENT,
357: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY',
358: p_context => 'Quality Specifications',

Line 370: GMA_COMMON_LOGGING.gma_migration_central_log (

366: p_param3 => to_char(GMD_QC_MIG12.g_mon_spec_upd_count),
367: p_param4 => to_char(GMD_QC_MIG12.g_mon_spec_ins_count),
368: p_param5 => to_char(GMD_QC_MIG12.g_mon_spec_err_count),
369: p_app_short_name => 'GMD');
370: GMA_COMMON_LOGGING.gma_migration_central_log (
371: p_run_id => p_migration_run_id,
372: p_log_level => FND_LOG.LEVEL_EVENT,
373: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
374: p_context => 'Quality Specifications',

Line 409: GMA_COMMON_LOGGING.gma_migration_central_log (

405:
406: BEGIN
407:
408: IF (p_progress_ind = 1) THEN
409: GMA_COMMON_LOGGING.gma_migration_central_log (
410: p_run_id => p_migration_run_id,
411: p_log_level => FND_LOG.LEVEL_EVENT,
412: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
413: p_context => 'Quality Stability Studies',

Line 428: GMA_COMMON_LOGGING.gma_migration_central_log (

424: p_app_short_name => 'GMD');
425: END IF;
426:
427: IF (p_progress_ind = 2) THEN
428: GMA_COMMON_LOGGING.gma_migration_central_log (
429: p_run_id => p_migration_run_id,
430: p_log_level => FND_LOG.LEVEL_EVENT,
431: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
432: p_context => 'Quality Stability Studies',

Line 447: GMA_COMMON_LOGGING.gma_migration_central_log (

443: p_app_short_name => 'GMD');
444: END IF;
445:
446: IF (p_progress_ind = 3) THEN
447: GMA_COMMON_LOGGING.gma_migration_central_log (
448: p_run_id => p_migration_run_id,
449: p_log_level => FND_LOG.LEVEL_EVENT,
450: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
451: p_context => 'Quality Stability Studies',

Line 466: GMA_COMMON_LOGGING.gma_migration_central_log (

462: p_app_short_name => 'GMD');
463: END IF;
464:
465: IF (p_progress_ind = 4) THEN
466: GMA_COMMON_LOGGING.gma_migration_central_log (
467: p_run_id => p_migration_run_id,
468: p_log_level => FND_LOG.LEVEL_EVENT,
469: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
470: p_context => 'Quality Stability Studies',

Line 485: GMA_COMMON_LOGGING.gma_migration_central_log (

481: p_app_short_name => 'GMD');
482: END IF;
483:
484: IF (p_progress_ind = 5) THEN
485: GMA_COMMON_LOGGING.gma_migration_central_log (
486: p_run_id => p_migration_run_id,
487: p_log_level => FND_LOG.LEVEL_EVENT,
488: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
489: p_context => 'Quality Stability Studies',

Line 504: GMA_COMMON_LOGGING.gma_migration_central_log (

500: p_app_short_name => 'GMD');
501: END IF;
502:
503: IF (p_progress_ind = 6) THEN
504: GMA_COMMON_LOGGING.gma_migration_central_log (
505: p_run_id => p_migration_run_id,
506: p_log_level => FND_LOG.LEVEL_EVENT,
507: p_message_token => 'GMD_MIG_TABLE_SUMMARY',
508: p_context => 'Quality Stability Studies',

Line 762: GMA_COMMON_LOGGING.gma_migration_central_log (

758:
759: EXCEPTION
760:
761: WHEN TEXT_SEQ_ERROR THEN
762: GMA_COMMON_LOGGING.gma_migration_central_log (
763: p_run_id => p_migration_run_id,
764: p_log_level => FND_LOG.LEVEL_ERROR,
765: p_message_token => 'GMD_MIG_TEXT_SEQ_ERROR',
766: p_table_name => NULL,

Line 1000: GMA_COMMON_LOGGING.gma_migration_central_log (

996: CLOSE cur_orgn_config;
997: END LOOP;
998: EXCEPTION
999: WHEN OTHERS THEN
1000: GMA_COMMON_LOGGING.gma_migration_central_log (
1001: p_run_id => p_migration_run_id,
1002: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1003: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1004: p_context => 'Quality Setup - quality config ins',

Line 1311: GMA_COMMON_LOGGING.gma_migration_central_log (

1307: l_valfield := 'GEMMS_DEFAULT_LAB_TYPE';
1308: l_value := NVL(l_lab_profile,' ');
1309:
1310: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1311: GMA_COMMON_LOGGING.gma_migration_central_log (
1312: p_run_id => p_migration_run_id,
1313: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1314: p_message_token => 'GMD_MIG_VALUE',
1315: p_context => 'Quality Setup',

Line 1340: GMA_COMMON_LOGGING.gma_migration_central_log (

1336: /*==============================================
1337: Log Start of gmd_test_method migration.
1338: ==============================================*/
1339:
1340: GMA_COMMON_LOGGING.gma_migration_central_log (
1341: p_run_id => p_migration_run_id,
1342: p_log_level => FND_LOG.LEVEL_EVENT,
1343: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1344: p_table_name => 'GMD_QUALITY_CONFIG',

Line 1411: GMA_COMMON_LOGGING.gma_migration_central_log (

1407:
1408: EXCEPTION
1409:
1410: WHEN METHOD_ITEM_ERROR THEN
1411: GMA_COMMON_LOGGING.gma_migration_central_log (
1412: p_run_id => p_migration_run_id,
1413: p_log_level => FND_LOG.LEVEL_ERROR,
1414: p_message_token => 'GMD_MIG_INVALID_ITEM',
1415: p_context => 'Quality Setup - gmd_test_methods_b',

Line 1432: GMA_COMMON_LOGGING.gma_migration_central_log (

1428: WHEN NEXT_TEST_METHOD THEN
1429: NULL;
1430:
1431: WHEN OTHERS THEN
1432: GMA_COMMON_LOGGING.gma_migration_central_log (
1433: p_run_id => p_migration_run_id,
1434: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1435: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1436: p_context => 'Quality Setup - gmd_test_methods_b',

Line 1469: GMA_COMMON_LOGGING.gma_migration_central_log (

1465: l_valfield := 'QC$EXACTSPECMATCH';
1466: l_value := NVL(P_exact_match,' ');
1467:
1468: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1469: GMA_COMMON_LOGGING.gma_migration_central_log (
1470: p_run_id => p_migration_run_id,
1471: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1472: p_message_token => 'GMD_MIG_VALUE',
1473: p_context => 'Quality Setup',

Line 1496: GMA_COMMON_LOGGING.gma_migration_central_log (

1492: l_value := NVL(P_inc_opt,' ');
1493:
1494:
1495: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1496: GMA_COMMON_LOGGING.gma_migration_central_log (
1497: p_run_id => p_migration_run_id,
1498: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1499: p_message_token => 'GMD_MIG_VALUE',
1500: p_context => 'Quality Setup',

Line 1525: GMA_COMMON_LOGGING.gma_migration_central_log (

1521: l_valfield := 'GMD_OPERATION_VERSION_CONTROL';
1522: l_value := NVL(P_version_control,' ');
1523:
1524: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1525: GMA_COMMON_LOGGING.gma_migration_central_log (
1526: p_run_id => p_migration_run_id,
1527: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1528: p_message_token => 'GMD_MIG_VALUE',
1529: p_context => 'Quality Setup',

Line 1545: GMA_COMMON_LOGGING.gma_migration_central_log (

1541: /*==============================================
1542: Log Start of Quality Config Migration.
1543: ==============================================*/
1544:
1545: GMA_COMMON_LOGGING.gma_migration_central_log (
1546: p_run_id => p_migration_run_id,
1547: p_log_level => FND_LOG.LEVEL_EVENT,
1548: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1549: p_table_name => 'GMD_QUALITY_CONFIG',

Line 1688: GMA_COMMON_LOGGING.gma_migration_central_log (

1684:
1685: EXCEPTION
1686:
1687: WHEN MIG_NO_ORG THEN
1688: GMA_COMMON_LOGGING.gma_migration_central_log (
1689: p_run_id => p_migration_run_id,
1690: p_log_level => FND_LOG.LEVEL_ERROR,
1691: p_message_token => 'GMD_MIG_NO_ORG',
1692: p_context => 'Quality Setup - quality config update',

Line 1708: GMA_COMMON_LOGGING.gma_migration_central_log (

1704: x_exception_count := x_exception_count + 1;
1705:
1706:
1707: WHEN REASON_CODE_ERROR THEN
1708: GMA_COMMON_LOGGING.gma_migration_central_log (
1709: p_run_id => p_migration_run_id,
1710: p_log_level => FND_LOG.LEVEL_ERROR,
1711: p_message_token => 'GMD_MIG_REASON_ID',
1712: p_context => 'Quality Setup - quality config update',

Line 1724: GMA_COMMON_LOGGING.gma_migration_central_log (

1720: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
1721: x_exception_count := x_exception_count + 1;
1722:
1723: WHEN IN_SPEC_ERROR THEN
1724: GMA_COMMON_LOGGING.gma_migration_central_log (
1725: p_run_id => p_migration_run_id,
1726: p_log_level => FND_LOG.LEVEL_ERROR,
1727: p_message_token => 'GMD_MIG_STATUS_ID',
1728: p_context => 'Quality Setup - quality config update',

Line 1740: GMA_COMMON_LOGGING.gma_migration_central_log (

1736: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
1737: x_exception_count := x_exception_count + 1;
1738:
1739: WHEN OUT_SPEC_ERROR THEN
1740: GMA_COMMON_LOGGING.gma_migration_central_log (
1741: p_run_id => p_migration_run_id,
1742: p_log_level => FND_LOG.LEVEL_ERROR,
1743: p_message_token => 'GMD_MIG_STATUS_ID',
1744: p_context => 'Quality Setup - quality config update',

Line 1756: GMA_COMMON_LOGGING.gma_migration_central_log (

1752: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
1753: x_exception_count := x_exception_count + 1;
1754:
1755: WHEN GET_LAB_ERROR THEN
1756: GMA_COMMON_LOGGING.gma_migration_central_log (
1757: p_run_id => p_migration_run_id,
1758: p_log_level => FND_LOG.LEVEL_ERROR,
1759: p_message_token => 'GMD_MIG_GET_LAB',
1760: p_context => 'Quality Setup - quality config update',

Line 1772: GMA_COMMON_LOGGING.gma_migration_central_log (

1768: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
1769: x_exception_count := x_exception_count + 1;
1770:
1771: WHEN OTHERS THEN
1772: GMA_COMMON_LOGGING.gma_migration_central_log (
1773: p_run_id => p_migration_run_id,
1774: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1775: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1776: p_context => 'Quality Setup - quality config update',

Line 2054: GMA_COMMON_LOGGING.gma_migration_central_log (

2050: WHEN NEXT_CONFIG_INSERT THEN
2051: NULL;
2052:
2053: WHEN GET_ORGN_CODE_ERROR THEN
2054: GMA_COMMON_LOGGING.gma_migration_central_log (
2055: p_run_id => p_migration_run_id,
2056: p_log_level => FND_LOG.LEVEL_ERROR,
2057: p_message_token => 'GMD_MIG_ORG_CODE',
2058: p_context => 'Quality Setup - quality config ins',

Line 2070: GMA_COMMON_LOGGING.gma_migration_central_log (

2066: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
2067: x_exception_count := x_exception_count + 1;
2068:
2069: WHEN GET_LAB_ERROR THEN
2070: GMA_COMMON_LOGGING.gma_migration_central_log (
2071: p_run_id => p_migration_run_id,
2072: p_log_level => FND_LOG.LEVEL_ERROR,
2073: p_message_token => 'GMD_MIG_GET_LAB',
2074: p_context => 'Quality Setup - quality config ins',

Line 2086: GMA_COMMON_LOGGING.gma_migration_central_log (

2082: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
2083: x_exception_count := x_exception_count + 1;
2084:
2085: WHEN OTHERS THEN
2086: GMA_COMMON_LOGGING.gma_migration_central_log (
2087: p_run_id => p_migration_run_id,
2088: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2089: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2090: p_context => 'Quality Setup - quality config ins',

Line 2175: GMA_COMMON_LOGGING.gma_migration_central_log (

2171: WHEN NO_NULL_RECORD THEN
2172: NULL;
2173:
2174: WHEN CONFIG_INCOMPLETE THEN
2175: GMA_COMMON_LOGGING.gma_migration_central_log (
2176: p_run_id => p_migration_run_id,
2177: p_log_level => FND_LOG.LEVEL_ERROR,
2178: p_message_token => 'GMD_MIG_CONFIG_INCOMPLETE',
2179: p_context => 'Quality Setup - quality config ins',

Line 2184: GMA_COMMON_LOGGING.gma_migration_central_log (

2180: p_app_short_name => 'GMD');
2181: x_exception_count := x_exception_count + 1;
2182:
2183: WHEN CONFIG_FINAL_INCOMPLETE THEN
2184: GMA_COMMON_LOGGING.gma_migration_central_log (
2185: p_run_id => p_migration_run_id,
2186: p_log_level => FND_LOG.LEVEL_ERROR,
2187: p_message_token => 'GMD_MIG_CONFIG_INCOMPLETE2',
2188: p_context => 'Quality Setup - quality config ins',

Line 2193: GMA_COMMON_LOGGING.gma_migration_central_log (

2189: p_app_short_name => 'GMD');
2190: x_exception_count := x_exception_count + 1;
2191:
2192: WHEN REASON_CODE_ERROR THEN
2193: GMA_COMMON_LOGGING.gma_migration_central_log (
2194: p_run_id => p_migration_run_id,
2195: p_log_level => FND_LOG.LEVEL_ERROR,
2196: p_message_token => 'GMD_MIG_REASON_ID',
2197: p_context => 'Quality Setup - quality config ins',

Line 2209: GMA_COMMON_LOGGING.gma_migration_central_log (

2205: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
2206: x_exception_count := x_exception_count + 1;
2207:
2208: WHEN IN_SPEC_ERROR THEN
2209: GMA_COMMON_LOGGING.gma_migration_central_log (
2210: p_run_id => p_migration_run_id,
2211: p_log_level => FND_LOG.LEVEL_ERROR,
2212: p_message_token => 'GMD_MIG_STATUS_ID',
2213: p_context => 'Quality Setup - quality config ins',

Line 2225: GMA_COMMON_LOGGING.gma_migration_central_log (

2221: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
2222: x_exception_count := x_exception_count + 1;
2223:
2224: WHEN OUT_SPEC_ERROR THEN
2225: GMA_COMMON_LOGGING.gma_migration_central_log (
2226: p_run_id => p_migration_run_id,
2227: p_log_level => FND_LOG.LEVEL_ERROR,
2228: p_message_token => 'GMD_MIG_STATUS_ID',
2229: p_context => 'Quality Setup - quality config ins',

Line 2241: GMA_COMMON_LOGGING.gma_migration_central_log (

2237: GMD_QC_MIG12.g_quality_config_err_count := GMD_QC_MIG12.g_quality_config_err_count + 1;
2238: x_exception_count := x_exception_count + 1;
2239:
2240: WHEN OTHERS THEN
2241: GMA_COMMON_LOGGING.gma_migration_central_log (
2242: p_run_id => p_migration_run_id,
2243: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2244: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2245: p_context => 'Quality Setup - quality config ins',

Line 2266: GMA_COMMON_LOGGING.gma_migration_central_log (

2262: /*==============================================
2263: Log Start of gmd_sampling_plan_b migration.
2264: ==============================================*/
2265:
2266: GMA_COMMON_LOGGING.gma_migration_central_log (
2267: p_run_id => p_migration_run_id,
2268: p_log_level => FND_LOG.LEVEL_EVENT,
2269: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2270: p_table_name => 'GMD_SAMPLING_PLAN_B',

Line 2319: GMA_COMMON_LOGGING.gma_migration_central_log (

2315:
2316: EXCEPTION
2317:
2318: WHEN MIG_NO_UOM THEN
2319: GMA_COMMON_LOGGING.gma_migration_central_log (
2320: p_run_id => p_migration_run_id,
2321: p_log_level => FND_LOG.LEVEL_ERROR,
2322: p_message_token => 'GMD_MIG_NO_UOM',
2323: p_context => 'Quality Setup - gmd_sampling_plan',

Line 2336: GMA_COMMON_LOGGING.gma_migration_central_log (

2332: GMD_QC_MIG12.g_sampling_plan_err_count := GMD_QC_MIG12.g_sampling_plan_err_count + 1;
2333: x_exception_count := x_exception_count + 1;
2334:
2335: WHEN OTHERS THEN
2336: GMA_COMMON_LOGGING.gma_migration_central_log (
2337: p_run_id => p_migration_run_id,
2338: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2339: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2340: p_context => 'Quality Setup - gmd_sampling_plan',

Line 2362: GMA_COMMON_LOGGING.gma_migration_central_log (

2358:
2359: EXCEPTION
2360:
2361: WHEN DEFAULT_LAB_NULL THEN
2362: GMA_COMMON_LOGGING.gma_migration_central_log (
2363: p_run_id => p_migration_run_id,
2364: p_log_level => FND_LOG.LEVEL_ERROR,
2365: p_message_token => 'GMD_MIG_DEFAULT_LAB_NULL',
2366: p_context => 'Quality Setup - general',

Line 2372: GMA_COMMON_LOGGING.gma_migration_central_log (

2368:
2369: x_exception_count := x_exception_count + 1;
2370:
2371: WHEN NULL_DEF_ORGANIZATION_ID THEN
2372: GMA_COMMON_LOGGING.gma_migration_central_log (
2373: p_run_id => p_migration_run_id,
2374: p_log_level => FND_LOG.LEVEL_ERROR,
2375: p_message_token => 'GMD_MIG_NULL_DEF_ORG_ID',
2376: p_context => 'Quality Setup - general',

Line 2387: GMA_COMMON_LOGGING.gma_migration_central_log (

2383: WHEN OTHERS THEN
2384:
2385: LOG_SETUP_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
2386:
2387: GMA_COMMON_LOGGING.gma_migration_central_log (
2388: p_run_id => p_migration_run_id,
2389: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2390: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2391: p_context => 'Quality Setup - general',

Line 2584: GMA_COMMON_LOGGING.gma_migration_central_log (

2580: /*==============================================
2581: Log Start of gmd_samples migration.
2582: ==============================================*/
2583:
2584: GMA_COMMON_LOGGING.gma_migration_central_log (
2585: p_run_id => p_migration_run_id,
2586: p_log_level => FND_LOG.LEVEL_EVENT,
2587: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2588: p_table_name => 'GMD_SAMPLES',

Line 3141: GMA_COMMON_LOGGING.gma_migration_central_log (

3137:
3138: EXCEPTION
3139:
3140: WHEN MIG_NO_ORG THEN
3141: GMA_COMMON_LOGGING.gma_migration_central_log (
3142: p_run_id => p_migration_run_id,
3143: p_log_level => FND_LOG.LEVEL_ERROR,
3144: p_message_token => 'GMD_MIG_NO_ORG',
3145: p_context => 'Quality Samples - gmd_samples',

Line 3159: GMA_COMMON_LOGGING.gma_migration_central_log (

3155: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3156: x_exception_count := x_exception_count + 1;
3157:
3158: WHEN MIG_NO_LAB_ORG 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_NO_ORG',
3163: p_context => 'Quality Samples - gmd_samples',

Line 3177: GMA_COMMON_LOGGING.gma_migration_central_log (

3173: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3174: x_exception_count := x_exception_count + 1;
3175:
3176: WHEN MIG_WHSE_ERROR THEN
3177: GMA_COMMON_LOGGING.gma_migration_central_log (
3178: p_run_id => p_migration_run_id,
3179: p_log_level => FND_LOG.LEVEL_ERROR,
3180: p_message_token => 'GMD_MIG_WHSE_ERROR',
3181: p_context => 'Quality Samples - gmd_samples',

Line 3196: GMA_COMMON_LOGGING.gma_migration_central_log (

3192: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3193: x_exception_count := x_exception_count + 1;
3194:
3195: WHEN MIG_SUBINV_MISMATCH THEN
3196: GMA_COMMON_LOGGING.gma_migration_central_log (
3197: p_run_id => p_migration_run_id,
3198: p_log_level => FND_LOG.LEVEL_ERROR,
3199: p_message_token => 'GMD_MIG_SUBINV_MISMATCH',
3200: p_table_name => NULL,

Line 3218: GMA_COMMON_LOGGING.gma_migration_central_log (

3214: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3215: x_exception_count := x_exception_count + 1;
3216:
3217: WHEN MIG_NON_LOC_FAIL THEN
3218: GMA_COMMON_LOGGING.gma_migration_central_log (
3219: p_run_id => p_migration_run_id,
3220: p_log_level => FND_LOG.LEVEL_ERROR,
3221: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3222: p_context => 'Quality Samples - gmd_samples',

Line 3235: GMA_COMMON_LOGGING.gma_migration_central_log (

3231: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3232: x_exception_count := x_exception_count + 1;
3233:
3234: WHEN MIG_LOCATOR_ID THEN
3235: GMA_COMMON_LOGGING.gma_migration_central_log (
3236: p_run_id => p_migration_run_id,
3237: p_log_level => FND_LOG.LEVEL_ERROR,
3238: p_message_token => 'GMD_MIG_LOCATOR_ID',
3239: p_context => 'Quality Samples - gmd_samples',

Line 3256: GMA_COMMON_LOGGING.gma_migration_central_log (

3252: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3253: x_exception_count := x_exception_count + 1;
3254:
3255: WHEN MIG_SUBINV_ERROR THEN
3256: GMA_COMMON_LOGGING.gma_migration_central_log (
3257: p_run_id => p_migration_run_id,
3258: p_log_level => FND_LOG.LEVEL_ERROR,
3259: p_message_token => 'GMD_MIG_SUBINV',
3260: p_context => 'Quality Samples - gmd_samples',

Line 3274: GMA_COMMON_LOGGING.gma_migration_central_log (

3270: x_exception_count := x_exception_count + 1;
3271:
3272:
3273: WHEN MIG_STORE_WHSE_ERROR THEN
3274: GMA_COMMON_LOGGING.gma_migration_central_log (
3275: p_run_id => p_migration_run_id,
3276: p_log_level => FND_LOG.LEVEL_ERROR,
3277: p_message_token => 'GMD_MIG_WHSE_ERROR',
3278: p_context => 'Quality Samples - gmd_samples',

Line 3293: GMA_COMMON_LOGGING.gma_migration_central_log (

3289: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3290: x_exception_count := x_exception_count + 1;
3291:
3292: WHEN MIG_STORE_NON_LOC_ERROR THEN
3293: GMA_COMMON_LOGGING.gma_migration_central_log (
3294: p_run_id => p_migration_run_id,
3295: p_log_level => FND_LOG.LEVEL_ERROR,
3296: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3297: p_context => 'Quality Samples - gmd_samples',

Line 3310: GMA_COMMON_LOGGING.gma_migration_central_log (

3306: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3307: x_exception_count := x_exception_count + 1;
3308:
3309: WHEN MIG_STORE_LOCATOR_ID THEN
3310: GMA_COMMON_LOGGING.gma_migration_central_log (
3311: p_run_id => p_migration_run_id,
3312: p_log_level => FND_LOG.LEVEL_ERROR,
3313: p_message_token => 'GMD_MIG_LOCATOR_ID',
3314: p_context => 'Quality Samples - gmd_samples',

Line 3333: GMA_COMMON_LOGGING.gma_migration_central_log (

3329:
3330: -- BEGIN Bug# 5261810
3331: -- Added code to handle exceptions for source_whse and source_location
3332: WHEN MIG_SOURCE_WHSE_ERROR THEN
3333: GMA_COMMON_LOGGING.gma_migration_central_log (
3334: p_run_id => p_migration_run_id,
3335: p_log_level => FND_LOG.LEVEL_ERROR,
3336: p_message_token => 'GMD_MIG_WHSE_ERROR',
3337: p_context => 'Quality Samples - gmd_samples',

Line 3352: GMA_COMMON_LOGGING.gma_migration_central_log (

3348: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3349: x_exception_count := x_exception_count + 1;
3350:
3351: WHEN MIG_SOURCE_NON_LOC_ERROR THEN
3352: GMA_COMMON_LOGGING.gma_migration_central_log (
3353: p_run_id => p_migration_run_id,
3354: p_log_level => FND_LOG.LEVEL_ERROR,
3355: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3356: p_context => 'Quality Samples - gmd_samples',

Line 3369: GMA_COMMON_LOGGING.gma_migration_central_log (

3365: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3366: x_exception_count := x_exception_count + 1;
3367:
3368: WHEN MIG_SOURCE_LOCATOR_ID THEN
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_LOCATOR_ID',
3373: p_context => 'Quality Samples - gmd_samples',

Line 3390: GMA_COMMON_LOGGING.gma_migration_central_log (

3386: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3387: x_exception_count := x_exception_count + 1;
3388:
3389: WHEN MIG_SOURCE_SUBINV_ERROR THEN
3390: GMA_COMMON_LOGGING.gma_migration_central_log (
3391: p_run_id => p_migration_run_id,
3392: p_log_level => FND_LOG.LEVEL_ERROR,
3393: p_message_token => 'GMD_MIG_SUBINV',
3394: p_context => 'Quality Samples - gmd_samples',

Line 3407: GMA_COMMON_LOGGING.gma_migration_central_log (

3403: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3404: x_exception_count := x_exception_count + 1;
3405: -- End Bug# 5261810
3406: WHEN MIG_ODM_ITEM THEN
3407: GMA_COMMON_LOGGING.gma_migration_central_log (
3408: p_run_id => p_migration_run_id,
3409: p_log_level => FND_LOG.LEVEL_ERROR,
3410: p_message_token => 'GMD_MIG_ODM_ITEM',
3411: p_context => 'Quality Samples - gmd_samples',

Line 3426: GMA_COMMON_LOGGING.gma_migration_central_log (

3422: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3423: x_exception_count := x_exception_count + 1;
3424:
3425: WHEN MIG_OPM_ITEM THEN
3426: GMA_COMMON_LOGGING.gma_migration_central_log (
3427: p_run_id => p_migration_run_id,
3428: p_log_level => FND_LOG.LEVEL_ERROR,
3429: p_message_token => 'GMD_MIG_OPM_ITEM',
3430: p_context => 'Quality Samples - gmd_samples',

Line 3443: GMA_COMMON_LOGGING.gma_migration_central_log (

3439: GMD_QC_MIG12.g_sample_err_count := GMD_QC_MIG12.g_sample_err_count + 1;
3440: x_exception_count := x_exception_count + 1;
3441:
3442: WHEN MIG_LOT_ERROR THEN
3443: GMA_COMMON_LOGGING.gma_migration_central_log (
3444: p_run_id => p_migration_run_id,
3445: p_log_level => FND_LOG.LEVEL_ERROR,
3446: p_message_token => 'GMD_MIG_LOT',
3447: p_context => 'Quality Samples - gmd_samples',

Line 3459: GMA_COMMON_LOGGING.gma_migration_central_log (

3455: x_exception_count := x_exception_count + 1;
3456:
3457: WHEN OTHERS THEN
3458:
3459: GMA_COMMON_LOGGING.gma_migration_central_log (
3460: p_run_id => p_migration_run_id,
3461: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3462: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3463: p_context => 'Quality Samples - gmd_samples',

Line 3485: GMA_COMMON_LOGGING.gma_migration_central_log (

3481: /*==============================================
3482: Log Start of gmd_sampling_events migration.
3483: ==============================================*/
3484:
3485: GMA_COMMON_LOGGING.gma_migration_central_log (
3486: p_run_id => p_migration_run_id,
3487: p_log_level => FND_LOG.LEVEL_EVENT,
3488: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3489: p_table_name => 'GMD_SAMPLING_EVENTS',

Line 3543: /*GMA_COMMON_LOGGING.gma_migration_central_log (

3539:
3540: WHEN MIG_GET_SAMPLE_ERROR THEN
3541: -- Bug# 5462876
3542: -- Supress logging of the following message since there are lot of rows in gmd_sampling_events where there is no corresponding sample row.
3543: /*GMA_COMMON_LOGGING.gma_migration_central_log (
3544: p_run_id => p_migration_run_id,
3545: p_log_level => FND_LOG.LEVEL_ERROR,
3546: p_message_token => 'GMD_MIG_GET_SAMPLE',
3547: p_context => 'Quality Samples - gmd_sampling_events',

Line 3556: GMA_COMMON_LOGGING.gma_migration_central_log (

3552: x_exception_count := x_exception_count + 1;
3553:
3554: WHEN OTHERS THEN
3555: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3556: GMA_COMMON_LOGGING.gma_migration_central_log (
3557: p_run_id => p_migration_run_id,
3558: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3559: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3560: p_context => 'Quality Samples - gmd_sampling_events',

Line 3603: GMA_COMMON_LOGGING.gma_migration_central_log (

3599: EXCEPTION
3600:
3601: WHEN OTHERS THEN
3602: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3603: GMA_COMMON_LOGGING.gma_migration_central_log (
3604: p_run_id => p_migration_run_id,
3605: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3606: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3607: p_context => 'Quality Samples - general',

Line 3670: GMA_COMMON_LOGGING.gma_migration_central_log (

3666: /*=====================================
3667: Log Start of gmd_results.
3668: =====================================*/
3669:
3670: GMA_COMMON_LOGGING.gma_migration_central_log (
3671: p_run_id => p_migration_run_id,
3672: p_log_level => FND_LOG.LEVEL_EVENT,
3673: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3674: p_table_name => 'GMD_RESULTS',

Line 3786: GMA_COMMON_LOGGING.gma_migration_central_log (

3782:
3783: EXCEPTION
3784:
3785: WHEN MIG_NO_LAB_ORG THEN
3786: GMA_COMMON_LOGGING.gma_migration_central_log (
3787: p_run_id => p_migration_run_id,
3788: p_log_level => FND_LOG.LEVEL_ERROR,
3789: p_message_token => 'GMD_MIG_NO_ORG',
3790: p_context => 'Quality Results - gmd_results',

Line 3807: GMA_COMMON_LOGGING.gma_migration_central_log (

3803: WHEN NEXTRESULT THEN
3804: NULL;
3805:
3806: WHEN MIG_ODM_ITEM THEN
3807: GMA_COMMON_LOGGING.gma_migration_central_log (
3808: p_run_id => p_migration_run_id,
3809: p_log_level => FND_LOG.LEVEL_ERROR,
3810: p_message_token => 'GMD_MIG_ODM_ITEM',
3811: p_context => 'Quality Results - gmd_results',

Line 3825: GMA_COMMON_LOGGING.gma_migration_central_log (

3821: GMD_QC_MIG12.g_result_err_count := GMD_QC_MIG12.g_result_err_count + 1;
3822: x_exception_count := x_exception_count + 1;
3823:
3824: WHEN MIG_LOT_ERROR THEN
3825: GMA_COMMON_LOGGING.gma_migration_central_log (
3826: p_run_id => p_migration_run_id,
3827: p_log_level => FND_LOG.LEVEL_ERROR,
3828: p_message_token => 'GMD_MIG_LOT',
3829: p_context => 'Quality Results - gmd_results',

Line 3840: GMA_COMMON_LOGGING.gma_migration_central_log (

3836: x_exception_count := x_exception_count + 1;
3837:
3838: WHEN OTHERS THEN
3839: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3840: GMA_COMMON_LOGGING.gma_migration_central_log (
3841: p_run_id => p_migration_run_id,
3842: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3843: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3844: p_context => 'Quality Results - gmd_results',

Line 3863: GMA_COMMON_LOGGING.gma_migration_central_log (

3859: EXCEPTION
3860:
3861: WHEN OTHERS THEN
3862: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3863: GMA_COMMON_LOGGING.gma_migration_central_log (
3864: p_run_id => p_migration_run_id,
3865: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3866: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3867: p_context => 'Quality Results - general',

Line 4360: GMA_COMMON_LOGGING.gma_migration_central_log (

4356: /*==============================================
4357: Log Start of gmd_specifications_b.
4358: ==============================================*/
4359:
4360: GMA_COMMON_LOGGING.gma_migration_central_log (
4361: p_run_id => p_migration_run_id,
4362: p_log_level => FND_LOG.LEVEL_EVENT,
4363: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
4364: p_table_name => 'GMD_SPECIFICATIONS',

Line 4433: GMA_COMMON_LOGGING.gma_migration_central_log (

4429:
4430: EXCEPTION
4431:
4432: WHEN MIG_NO_ORG THEN
4433: GMA_COMMON_LOGGING.gma_migration_central_log (
4434: p_run_id => p_migration_run_id,
4435: p_log_level => FND_LOG.LEVEL_ERROR,
4436: p_message_token => 'GMD_MIG_NO_ORG',
4437: p_table_name => NULL,

Line 4452: GMA_COMMON_LOGGING.gma_migration_central_log (

4448: GMD_QC_MIG12.g_specs_err_count := GMD_QC_MIG12.g_specs_err_count + 1;
4449: x_exception_count := x_exception_count + 1;
4450:
4451: WHEN MIG_ODM_ITEM THEN
4452: GMA_COMMON_LOGGING.gma_migration_central_log (
4453: p_run_id => p_migration_run_id,
4454: p_log_level => FND_LOG.LEVEL_ERROR,
4455: p_message_token => 'GMD_MIG_ODM_ITEM',
4456: p_context => 'Quality Specifications - gmd_specifications_b',

Line 4471: GMA_COMMON_LOGGING.gma_migration_central_log (

4467: x_exception_count := x_exception_count + 1;
4468:
4469: WHEN OTHERS THEN
4470: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
4471: GMA_COMMON_LOGGING.gma_migration_central_log (
4472: p_run_id => p_migration_run_id,
4473: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
4474: p_message_token => 'GMA_MIGRATION_DB_ERROR',
4475: p_context => 'Quality Specifications - gmd_specifications_b',

Line 4501: GMA_COMMON_LOGGING.gma_migration_central_log (

4497: /*=======================================
4498: Migrate gmd_inventory_spec_vrs.
4499: =======================================*/
4500:
4501: GMA_COMMON_LOGGING.gma_migration_central_log (
4502: p_run_id => p_migration_run_id,
4503: p_log_level => FND_LOG.LEVEL_EVENT,
4504: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
4505: p_table_name => 'GMD_INVENTORY_SPEC_VRS',

Line 4762: GMA_COMMON_LOGGING.gma_migration_central_log (

4758: /*========================================
4759: Log the spec record and Delete it
4760: as it is not tied to any Sample.
4761: ========================================*/
4762: GMA_COMMON_LOGGING.gma_migration_central_log (
4763: p_run_id => p_migration_run_id,
4764: p_log_level => FND_LOG.LEVEL_EVENT,
4765: p_message_token => 'GMD_MIG_SPEC_DELETE',
4766: p_table_name => NULL,

Line 5105: GMA_COMMON_LOGGING.gma_migration_central_log (

5101:
5102: EXCEPTION
5103:
5104: WHEN ISPEC_NO_ORG THEN
5105: GMA_COMMON_LOGGING.gma_migration_central_log (
5106: p_run_id => p_migration_run_id,
5107: p_log_level => FND_LOG.LEVEL_ERROR,
5108: p_message_token => 'GMD_MIG_NO_ORG',
5109: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

Line 5126: GMA_COMMON_LOGGING.gma_migration_central_log (

5122:
5123:
5124: WHEN ISPEC_WHSE_ERROR THEN
5125:
5126: GMA_COMMON_LOGGING.gma_migration_central_log (
5127: p_run_id => p_migration_run_id,
5128: p_log_level => FND_LOG.LEVEL_ERROR,
5129: p_message_token => 'GMD_MIG_WHSE_ERROR',
5130: p_table_name => NULL,

Line 5146: GMA_COMMON_LOGGING.gma_migration_central_log (

5142: GMD_QC_MIG12.g_inv_spec_err_count := GMD_QC_MIG12.g_inv_spec_err_count + 1;
5143: x_exception_count := x_exception_count + 1;
5144:
5145: WHEN ISPEC_SUB_MISMATCH THEN
5146: GMA_COMMON_LOGGING.gma_migration_central_log (
5147: p_run_id => p_migration_run_id,
5148: p_log_level => FND_LOG.LEVEL_ERROR,
5149: p_message_token => 'GMD_MIG_ISPEC_SUB_MISMATCH',
5150: p_table_name => NULL,

Line 5168: GMA_COMMON_LOGGING.gma_migration_central_log (

5164: GMD_QC_MIG12.g_inv_spec_err_count := GMD_QC_MIG12.g_inv_spec_err_count + 1;
5165: x_exception_count := x_exception_count + 1;
5166:
5167: WHEN ISPEC_NON_LOC THEN
5168: GMA_COMMON_LOGGING.gma_migration_central_log (
5169: p_run_id => p_migration_run_id,
5170: p_log_level => FND_LOG.LEVEL_ERROR,
5171: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
5172: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

Line 5186: GMA_COMMON_LOGGING.gma_migration_central_log (

5182:
5183:
5184:
5185: WHEN ISPEC_LOCATOR_ID THEN
5186: GMA_COMMON_LOGGING.gma_migration_central_log (
5187: p_run_id => p_migration_run_id,
5188: p_log_level => FND_LOG.LEVEL_ERROR,
5189: p_message_token => 'GMD_MIG_LOCATOR_ID',
5190: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

Line 5208: GMA_COMMON_LOGGING.gma_migration_central_log (

5204: x_exception_count := x_exception_count + 1;
5205:
5206:
5207: WHEN ISPEC_SUBINV THEN
5208: GMA_COMMON_LOGGING.gma_migration_central_log (
5209: p_run_id => p_migration_run_id,
5210: p_log_level => FND_LOG.LEVEL_ERROR,
5211: p_message_token => 'GMD_MIG_SUBINV',
5212: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

Line 5226: GMA_COMMON_LOGGING.gma_migration_central_log (

5222: x_exception_count := x_exception_count + 1;
5223:
5224:
5225: WHEN ISPEC_GET_OPM_LOT THEN
5226: GMA_COMMON_LOGGING.gma_migration_central_log (
5227: p_run_id => p_migration_run_id,
5228: p_log_level => FND_LOG.LEVEL_ERROR,
5229: p_message_token => 'GMD_MIG_GET_OPM_LOT',
5230: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

Line 5243: GMA_COMMON_LOGGING.gma_migration_central_log (

5239: GMD_QC_MIG12.g_inv_spec_err_count := GMD_QC_MIG12.g_inv_spec_err_count + 1;
5240: x_exception_count := x_exception_count + 1;
5241:
5242: WHEN ISPEC_GET_SPEC_ITEM THEN
5243: GMA_COMMON_LOGGING.gma_migration_central_log (
5244: p_run_id => p_migration_run_id,
5245: p_log_level => FND_LOG.LEVEL_ERROR,
5246: p_message_token => 'GMD_MIG_GET_ITEM_SPEC',
5247: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

Line 5261: GMA_COMMON_LOGGING.gma_migration_central_log (

5257: x_exception_count := x_exception_count + 1;
5258:
5259:
5260: WHEN ISPEC_GET_OPM_ITEM THEN
5261: GMA_COMMON_LOGGING.gma_migration_central_log (
5262: p_run_id => p_migration_run_id,
5263: p_log_level => FND_LOG.LEVEL_ERROR,
5264: p_message_token => 'GMD_MIG_OPM_ITEM',
5265: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

Line 5279: GMA_COMMON_LOGGING.gma_migration_central_log (

5275: x_exception_count := x_exception_count + 1;
5276:
5277:
5278: WHEN ISPEC_MIG_LOT THEN
5279: GMA_COMMON_LOGGING.gma_migration_central_log (
5280: p_run_id => p_migration_run_id,
5281: p_log_level => FND_LOG.LEVEL_ERROR,
5282: p_message_token => 'GMD_MIG_LOT',
5283: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

Line 5295: GMA_COMMON_LOGGING.gma_migration_central_log (

5291: x_exception_count := x_exception_count + 1;
5292:
5293:
5294: WHEN ISPEC_IN_STATUS THEN
5295: GMA_COMMON_LOGGING.gma_migration_central_log (
5296: p_run_id => p_migration_run_id,
5297: p_log_level => FND_LOG.LEVEL_ERROR,
5298: p_message_token => 'GMD_MIG_STATUS_ID',
5299: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

Line 5313: GMA_COMMON_LOGGING.gma_migration_central_log (

5309: x_exception_count := x_exception_count + 1;
5310:
5311:
5312: WHEN ISPEC_OUT_STATUS THEN
5313: GMA_COMMON_LOGGING.gma_migration_central_log (
5314: p_run_id => p_migration_run_id,
5315: p_log_level => FND_LOG.LEVEL_ERROR,
5316: p_message_token => 'GMD_MIG_STATUS_ID',
5317: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

Line 5333: GMA_COMMON_LOGGING.gma_migration_central_log (

5329: WHEN ISPEC_DELETE_INVSPEC THEN
5330: NULL;
5331:
5332: WHEN ISPEC_SAMPLE_ORG THEN
5333: GMA_COMMON_LOGGING.gma_migration_central_log (
5334: p_run_id => p_migration_run_id,
5335: p_log_level => FND_LOG.LEVEL_ERROR,
5336: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5337: p_table_name => NULL,

Line 5352: GMA_COMMON_LOGGING.gma_migration_central_log (

5348: x_exception_count := x_exception_count + 1;
5349:
5350:
5351: WHEN ISPEC_SAMPLE_ORG_ID THEN
5352: GMA_COMMON_LOGGING.gma_migration_central_log (
5353: p_run_id => p_migration_run_id,
5354: p_log_level => FND_LOG.LEVEL_ERROR,
5355: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5356: p_table_name => NULL,

Line 5371: GMA_COMMON_LOGGING.gma_migration_central_log (

5367: x_exception_count := x_exception_count + 1;
5368:
5369: WHEN OTHERS THEN
5370: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5371: GMA_COMMON_LOGGING.gma_migration_central_log (
5372: p_run_id => p_migration_run_id,
5373: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5374: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5375: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

Line 5398: GMA_COMMON_LOGGING.gma_migration_central_log (

5394: /*================================
5395: Migrate gmd_wip_spec_vrs.
5396: ================================*/
5397:
5398: GMA_COMMON_LOGGING.gma_migration_central_log (
5399: p_run_id => p_migration_run_id,
5400: p_log_level => FND_LOG.LEVEL_EVENT,
5401: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5402: p_table_name => 'GMD_WIP_SPEC_VRS',

Line 5740: GMA_COMMON_LOGGING.gma_migration_central_log (

5736:
5737: EXCEPTION
5738:
5739: WHEN WIP_NO_ORG THEN
5740: GMA_COMMON_LOGGING.gma_migration_central_log (
5741: p_run_id => p_migration_run_id,
5742: p_log_level => FND_LOG.LEVEL_ERROR,
5743: p_message_token => 'GMD_MIG_NO_ORG',
5744: p_context => 'Quality Specifications - gmd_wip_spec_vrs',

Line 5758: GMA_COMMON_LOGGING.gma_migration_central_log (

5754: GMD_QC_MIG12.g_wip_spec_err_count := GMD_QC_MIG12.g_wip_spec_err_count + 1;
5755: x_exception_count := x_exception_count + 1;
5756:
5757: WHEN WIP_IN_STATUS THEN
5758: GMA_COMMON_LOGGING.gma_migration_central_log (
5759: p_run_id => p_migration_run_id,
5760: p_log_level => FND_LOG.LEVEL_ERROR,
5761: p_message_token => 'GMD_MIG_STATUS_ID',
5762: p_context => 'Quality Specifications - gmd_wip_spec_vrs',

Line 5775: GMA_COMMON_LOGGING.gma_migration_central_log (

5771: x_exception_count := x_exception_count + 1;
5772:
5773:
5774: WHEN WIP_OUT_STATUS THEN
5775: GMA_COMMON_LOGGING.gma_migration_central_log (
5776: p_run_id => p_migration_run_id,
5777: p_log_level => FND_LOG.LEVEL_ERROR,
5778: p_message_token => 'GMD_MIG_STATUS_ID',
5779: p_context => 'Quality Specifications - gmd_wip_spec_vrs',

Line 5792: GMA_COMMON_LOGGING.gma_migration_central_log (

5788: x_exception_count := x_exception_count + 1;
5789:
5790:
5791: WHEN WIP_SPEC_DELETE THEN
5792: GMA_COMMON_LOGGING.gma_migration_central_log (
5793: p_run_id => p_migration_run_id,
5794: p_log_level => FND_LOG.LEVEL_EVENT,
5795: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
5796: p_table_name => NULL,

Line 5803: GMA_COMMON_LOGGING.gma_migration_central_log (

5799: p_param1 => 'gmd_wip_spec_vrs',
5800: p_app_short_name => 'GMD');
5801:
5802: WHEN WIP_SAMPLE_ORG THEN
5803: GMA_COMMON_LOGGING.gma_migration_central_log (
5804: p_run_id => p_migration_run_id,
5805: p_log_level => FND_LOG.LEVEL_ERROR,
5806: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5807: p_table_name => NULL,

Line 5820: GMA_COMMON_LOGGING.gma_migration_central_log (

5816: GMD_QC_MIG12.g_wip_spec_err_count := GMD_QC_MIG12.g_wip_spec_err_count + 1;
5817: x_exception_count := x_exception_count + 1;
5818:
5819: WHEN WIP_SAMPLE_ORG_ID THEN
5820: GMA_COMMON_LOGGING.gma_migration_central_log (
5821: p_run_id => p_migration_run_id,
5822: p_log_level => FND_LOG.LEVEL_ERROR,
5823: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5824: p_table_name => NULL,

Line 5839: GMA_COMMON_LOGGING.gma_migration_central_log (

5835:
5836:
5837: WHEN OTHERS THEN
5838: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5839: GMA_COMMON_LOGGING.gma_migration_central_log (
5840: p_run_id => p_migration_run_id,
5841: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5842: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5843: p_context => 'Quality Specifications - gmd_wip_spec_vrs',

Line 5866: GMA_COMMON_LOGGING.gma_migration_central_log (

5862: /*=======================================
5863: Migrate gmd_customer_spec_vrs.
5864: =======================================*/
5865:
5866: GMA_COMMON_LOGGING.gma_migration_central_log (
5867: p_run_id => p_migration_run_id,
5868: p_log_level => FND_LOG.LEVEL_EVENT,
5869: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5870: p_table_name => 'GMD_CUSTOMER_SPEC_VRS',

Line 5974: GMA_COMMON_LOGGING.gma_migration_central_log (

5970: NULL;
5971:
5972: WHEN OTHERS THEN
5973: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5974: GMA_COMMON_LOGGING.gma_migration_central_log (
5975: p_run_id => p_migration_run_id,
5976: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5977: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5978: p_context => 'Quality Specifications - gmd_customer_spec_vrs',

Line 6122: GMA_COMMON_LOGGING.gma_migration_central_log (

6118:
6119: EXCEPTION
6120:
6121: WHEN CUST_NO_ORG THEN
6122: GMA_COMMON_LOGGING.gma_migration_central_log (
6123: p_run_id => p_migration_run_id,
6124: p_log_level => FND_LOG.LEVEL_ERROR,
6125: p_message_token => 'GMD_MIG_NO_ORG',
6126: p_context => 'Quality Specifications - gmd_customer_spec_vrs',

Line 6141: GMA_COMMON_LOGGING.gma_migration_central_log (

6137: GMD_QC_MIG12.g_cust_spec_err_count := GMD_QC_MIG12.g_cust_spec_err_count + 1;
6138: x_exception_count := x_exception_count + 1;
6139:
6140: WHEN CUST_SPEC_DELETE THEN
6141: GMA_COMMON_LOGGING.gma_migration_central_log (
6142: p_run_id => p_migration_run_id,
6143: p_log_level => FND_LOG.LEVEL_ERROR,
6144: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6145: p_table_name => NULL,

Line 6153: GMA_COMMON_LOGGING.gma_migration_central_log (

6149: p_app_short_name => 'GMD');
6150:
6151:
6152: WHEN CUST_NO_ORG_ID THEN
6153: GMA_COMMON_LOGGING.gma_migration_central_log (
6154: p_run_id => p_migration_run_id,
6155: p_log_level => FND_LOG.LEVEL_ERROR,
6156: p_message_token => 'GMD_MIG_NULL_ORG_ID',
6157: p_table_name => NULL,

Line 6172: GMA_COMMON_LOGGING.gma_migration_central_log (

6168: x_exception_count := x_exception_count + 1;
6169:
6170: WHEN OTHERS THEN
6171: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
6172: GMA_COMMON_LOGGING.gma_migration_central_log (
6173: p_run_id => p_migration_run_id,
6174: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
6175: p_message_token => 'GMA_MIGRATION_DB_ERROR',
6176: p_context => 'Quality Specifications - gmd_customer_spec_vrs',

Line 6201: GMA_COMMON_LOGGING.gma_migration_central_log (

6197: /*===================================
6198: Migrate gmd_supplier_spec_vrs.
6199: ===================================*/
6200:
6201: GMA_COMMON_LOGGING.gma_migration_central_log (
6202: p_run_id => p_migration_run_id,
6203: p_log_level => FND_LOG.LEVEL_EVENT,
6204: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
6205: p_table_name => 'GMD_SUPPLIER_SPEC_VRS',

Line 6507: GMA_COMMON_LOGGING.gma_migration_central_log (

6503:
6504: EXCEPTION
6505:
6506: WHEN SUP_NO_ORG THEN
6507: GMA_COMMON_LOGGING.gma_migration_central_log (
6508: p_run_id => p_migration_run_id,
6509: p_log_level => FND_LOG.LEVEL_ERROR,
6510: p_message_token => 'GMD_MIG_NO_ORG',
6511: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',

Line 6525: GMA_COMMON_LOGGING.gma_migration_central_log (

6521: GMD_QC_MIG12.g_supl_spec_err_count := GMD_QC_MIG12.g_supl_spec_err_count + 1;
6522: x_exception_count := x_exception_count + 1;
6523:
6524: WHEN SUP_IN_STATUS THEN
6525: GMA_COMMON_LOGGING.gma_migration_central_log (
6526: p_run_id => p_migration_run_id,
6527: p_log_level => FND_LOG.LEVEL_ERROR,
6528: p_message_token => 'GMD_MIG_STATUS_ID',
6529: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',

Line 6541: GMA_COMMON_LOGGING.gma_migration_central_log (

6537: GMD_QC_MIG12.g_supl_spec_err_count := GMD_QC_MIG12.g_supl_spec_err_count + 1;
6538: x_exception_count := x_exception_count + 1;
6539:
6540: WHEN SUP_OUT_STATUS THEN
6541: GMA_COMMON_LOGGING.gma_migration_central_log (
6542: p_run_id => p_migration_run_id,
6543: p_log_level => FND_LOG.LEVEL_ERROR,
6544: p_message_token => 'GMD_MIG_STATUS_ID',
6545: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',

Line 6557: GMA_COMMON_LOGGING.gma_migration_central_log (

6553: GMD_QC_MIG12.g_supl_spec_err_count := GMD_QC_MIG12.g_supl_spec_err_count + 1;
6554: x_exception_count := x_exception_count + 1;
6555:
6556: WHEN SUP_SPEC_DELETE THEN
6557: GMA_COMMON_LOGGING.gma_migration_central_log (
6558: p_run_id => p_migration_run_id,
6559: p_log_level => FND_LOG.LEVEL_ERROR,
6560: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6561: p_table_name => NULL,

Line 6569: GMA_COMMON_LOGGING.gma_migration_central_log (

6565: p_app_short_name => 'GMD');
6566:
6567:
6568: WHEN SUP_NO_ORG_ID THEN
6569: GMA_COMMON_LOGGING.gma_migration_central_log (
6570: p_run_id => p_migration_run_id,
6571: p_log_level => FND_LOG.LEVEL_ERROR,
6572: p_message_token => 'GMD_MIG_NULL_ORG_ID',
6573: p_table_name => NULL,

Line 6587: GMA_COMMON_LOGGING.gma_migration_central_log (

6583: x_exception_count := x_exception_count + 1;
6584:
6585: WHEN OTHERS THEN
6586: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
6587: GMA_COMMON_LOGGING.gma_migration_central_log (
6588: p_run_id => p_migration_run_id,
6589: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
6590: p_message_token => 'GMA_MIGRATION_DB_ERROR',
6591: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',

Line 6614: GMA_COMMON_LOGGING.gma_migration_central_log (

6610: /*====================================
6611: Migrate gmd_monitoring_spec_vrs;
6612: ====================================*/
6613:
6614: GMA_COMMON_LOGGING.gma_migration_central_log (
6615: p_run_id => p_migration_run_id,
6616: p_log_level => FND_LOG.LEVEL_EVENT,
6617: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
6618: p_table_name => 'GMD_MONITORING_SPEC_VRS',

Line 6968: GMA_COMMON_LOGGING.gma_migration_central_log (

6964:
6965: EXCEPTION
6966:
6967: WHEN MON_NO_ORG THEN
6968: GMA_COMMON_LOGGING.gma_migration_central_log (
6969: p_run_id => p_migration_run_id,
6970: p_log_level => FND_LOG.LEVEL_ERROR,
6971: p_message_token => 'GMD_MIG_NO_ORG',
6972: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

Line 6986: GMA_COMMON_LOGGING.gma_migration_central_log (

6982: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
6983: x_exception_count := x_exception_count + 1;
6984:
6985: WHEN MON_NO_RES_ORG THEN
6986: GMA_COMMON_LOGGING.gma_migration_central_log (
6987: p_run_id => p_migration_run_id,
6988: p_log_level => FND_LOG.LEVEL_ERROR,
6989: p_message_token => 'GMD_MIG_NO_ORG',
6990: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

Line 7004: GMA_COMMON_LOGGING.gma_migration_central_log (

7000: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
7001: x_exception_count := x_exception_count + 1;
7002:
7003: WHEN MON_WHSE_ERROR THEN
7004: GMA_COMMON_LOGGING.gma_migration_central_log (
7005: p_run_id => p_migration_run_id,
7006: p_log_level => FND_LOG.LEVEL_ERROR,
7007: p_message_token => 'GMD_MIG_WHSE_ERROR',
7008: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

Line 7022: GMA_COMMON_LOGGING.gma_migration_central_log (

7018: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
7019: x_exception_count := x_exception_count + 1;
7020:
7021: WHEN MON_SUB_MISMATCH THEN
7022: GMA_COMMON_LOGGING.gma_migration_central_log (
7023: p_run_id => p_migration_run_id,
7024: p_log_level => FND_LOG.LEVEL_ERROR,
7025: p_message_token => 'GMD_MIG_MSPEC_SUB_MISMATCH',
7026: p_table_name => NULL,

Line 7043: GMA_COMMON_LOGGING.gma_migration_central_log (

7039: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
7040: x_exception_count := x_exception_count + 1;
7041:
7042: WHEN MON_CREATE_LOC THEN
7043: GMA_COMMON_LOGGING.gma_migration_central_log (
7044: p_run_id => p_migration_run_id,
7045: p_log_level => FND_LOG.LEVEL_ERROR,
7046: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
7047: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

Line 7059: GMA_COMMON_LOGGING.gma_migration_central_log (

7055: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
7056: x_exception_count := x_exception_count + 1;
7057:
7058: WHEN MON_LOCATOR_ID THEN
7059: GMA_COMMON_LOGGING.gma_migration_central_log (
7060: p_run_id => p_migration_run_id,
7061: p_log_level => FND_LOG.LEVEL_ERROR,
7062: p_message_token => 'GMD_MIG_LOCATOR_ID',
7063: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

Line 7079: GMA_COMMON_LOGGING.gma_migration_central_log (

7075: GMD_QC_MIG12.g_mon_spec_err_count := GMD_QC_MIG12.g_mon_spec_err_count + 1;
7076: x_exception_count := x_exception_count + 1;
7077:
7078: WHEN MON_SUBINV_ERROR THEN
7079: GMA_COMMON_LOGGING.gma_migration_central_log (
7080: p_run_id => p_migration_run_id,
7081: p_log_level => FND_LOG.LEVEL_ERROR,
7082: p_message_token => 'GMD_MIG_SUBINV',
7083: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

Line 7096: GMA_COMMON_LOGGING.gma_migration_central_log (

7092: x_exception_count := x_exception_count + 1;
7093:
7094:
7095: WHEN MON_SPEC_DELETE THEN
7096: GMA_COMMON_LOGGING.gma_migration_central_log (
7097: p_run_id => p_migration_run_id,
7098: p_log_level => FND_LOG.LEVEL_ERROR,
7099: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
7100: p_table_name => NULL,

Line 7107: GMA_COMMON_LOGGING.gma_migration_central_log (

7103: p_param1 => 'gmd_monitoring_spec_vrs',
7104: p_app_short_name => 'GMD');
7105:
7106: WHEN MON_NO_ORG_ID THEN
7107: GMA_COMMON_LOGGING.gma_migration_central_log (
7108: p_run_id => p_migration_run_id,
7109: p_log_level => FND_LOG.LEVEL_ERROR,
7110: p_message_token => 'GMD_MIG_NULL_ORG_ID',
7111: p_table_name => NULL,

Line 7142: GMA_COMMON_LOGGING.gma_migration_central_log (

7138: EXCEPTION
7139:
7140: WHEN OTHERS THEN
7141: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7142: GMA_COMMON_LOGGING.gma_migration_central_log (
7143: p_run_id => p_migration_run_id,
7144: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7145: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7146: p_context => 'Quality Specifications - general',

Line 7397: GMA_COMMON_LOGGING.gma_migration_central_log (

7393: /*==============================================
7394: Log Start of gmd_storage_plan_details.
7395: ==============================================*/
7396:
7397: GMA_COMMON_LOGGING.gma_migration_central_log (
7398: p_run_id => p_migration_run_id,
7399: p_log_level => FND_LOG.LEVEL_EVENT,
7400: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7401: p_table_name => 'GMD_STORAGE_PLAN_DETAILS',

Line 7530: GMA_COMMON_LOGGING.gma_migration_central_log (

7526:
7527: EXCEPTION
7528:
7529: WHEN SP_WHSE_ERROR THEN
7530: GMA_COMMON_LOGGING.gma_migration_central_log (
7531: p_run_id => p_migration_run_id,
7532: p_log_level => FND_LOG.LEVEL_ERROR,
7533: p_message_token => 'GMD_MIG_WHSE_ERROR',
7534: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

Line 7548: GMA_COMMON_LOGGING.gma_migration_central_log (

7544: GMD_QC_MIG12.g_store_plan_err_count := GMD_QC_MIG12.g_store_plan_err_count + 1;
7545: x_exception_count := x_exception_count + 1;
7546:
7547: WHEN SP_CREATE_LOCATION THEN
7548: GMA_COMMON_LOGGING.gma_migration_central_log (
7549: p_run_id => p_migration_run_id,
7550: p_log_level => FND_LOG.LEVEL_ERROR,
7551: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
7552: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

Line 7564: GMA_COMMON_LOGGING.gma_migration_central_log (

7560: GMD_QC_MIG12.g_store_plan_err_count := GMD_QC_MIG12.g_store_plan_err_count + 1;
7561: x_exception_count := x_exception_count + 1;
7562:
7563: WHEN SP_LOCATOR_ID THEN
7564: GMA_COMMON_LOGGING.gma_migration_central_log (
7565: p_run_id => p_migration_run_id,
7566: p_log_level => FND_LOG.LEVEL_ERROR,
7567: p_message_token => 'GMD_MIG_LOCATOR_ID',
7568: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

Line 7585: GMA_COMMON_LOGGING.gma_migration_central_log (

7581: x_exception_count := x_exception_count + 1;
7582:
7583:
7584: WHEN SP_SUBINV_ERROR THEN
7585: GMA_COMMON_LOGGING.gma_migration_central_log (
7586: p_run_id => p_migration_run_id,
7587: p_log_level => FND_LOG.LEVEL_ERROR,
7588: p_message_token => 'GMD_MIG_SUBINV',
7589: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

Line 7602: GMA_COMMON_LOGGING.gma_migration_central_log (

7598: x_exception_count := x_exception_count + 1;
7599:
7600: -- Bug# 5109039
7601: WHEN DEFAULT_SS_ORG_ERROR THEN
7602: GMA_COMMON_LOGGING.gma_migration_central_log (
7603: p_run_id => p_migration_run_id,
7604: p_log_level => FND_LOG.LEVEL_ERROR,
7605: p_message_token => 'GMD_MIG_DEF_SS_ORG_ERROR',
7606: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

Line 7613: GMA_COMMON_LOGGING.gma_migration_central_log (

7609: x_exception_count := x_exception_count + 1;
7610:
7611: WHEN OTHERS THEN
7612: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7613: GMA_COMMON_LOGGING.gma_migration_central_log (
7614: p_run_id => p_migration_run_id,
7615: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7616: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7617: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

Line 7639: GMA_COMMON_LOGGING.gma_migration_central_log (

7635: /*==============================================
7636: Log Start of gmd_stability_studies.
7637: ==============================================*/
7638:
7639: GMA_COMMON_LOGGING.gma_migration_central_log (
7640: p_run_id => p_migration_run_id,
7641: p_log_level => FND_LOG.LEVEL_EVENT,
7642: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7643: p_table_name => 'GMD_STABILITY_STUDIES_B',

Line 7711: GMA_COMMON_LOGGING.gma_migration_central_log (

7707: GMD_QC_MIG12.g_stab_upd_count := GMD_QC_MIG12.g_stab_upd_count + 1;
7708:
7709: EXCEPTION
7710: WHEN STAB_NO_ORG THEN
7711: GMA_COMMON_LOGGING.gma_migration_central_log (
7712: p_run_id => p_migration_run_id,
7713: p_log_level => FND_LOG.LEVEL_ERROR,
7714: p_message_token => 'GMD_MIG_NO_ORG',
7715: p_context => 'Quality Stability Studies - gmd_stability_studies_b',

Line 7729: GMA_COMMON_LOGGING.gma_migration_central_log (

7725: GMD_QC_MIG12.g_stab_err_count := GMD_QC_MIG12.g_stab_err_count + 1;
7726: x_exception_count := x_exception_count + 1;
7727:
7728: WHEN STAB_NO_LAB_ORG THEN
7729: GMA_COMMON_LOGGING.gma_migration_central_log (
7730: p_run_id => p_migration_run_id,
7731: p_log_level => FND_LOG.LEVEL_ERROR,
7732: p_message_token => 'GMD_MIG_NO_ORG',
7733: p_context => 'Quality Stability Studies - gmd_stability_studies_b',

Line 7747: GMA_COMMON_LOGGING.gma_migration_central_log (

7743: GMD_QC_MIG12.g_stab_err_count := GMD_QC_MIG12.g_stab_err_count + 1;
7744: x_exception_count := x_exception_count + 1;
7745:
7746: WHEN STAB_ODM_ITEM THEN
7747: GMA_COMMON_LOGGING.gma_migration_central_log (
7748: p_run_id => p_migration_run_id,
7749: p_log_level => FND_LOG.LEVEL_ERROR,
7750: p_message_token => 'GMD_MIG_ODM_ITEM',
7751: p_context => 'Quality Stability Studies - gmd_stability_studies_b',

Line 7766: GMA_COMMON_LOGGING.gma_migration_central_log (

7762: x_exception_count := x_exception_count + 1;
7763:
7764: WHEN OTHERS THEN
7765: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7766: GMA_COMMON_LOGGING.gma_migration_central_log (
7767: p_run_id => p_migration_run_id,
7768: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7769: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7770: p_context => 'Quality Stability Studies - gmd_stability_studies_b',

Line 7793: GMA_COMMON_LOGGING.gma_migration_central_log (

7789: /*==============================================
7790: Log Start of gmd_ss_material_sources.
7791: ==============================================*/
7792:
7793: GMA_COMMON_LOGGING.gma_migration_central_log (
7794: p_run_id => p_migration_run_id,
7795: p_log_level => FND_LOG.LEVEL_EVENT,
7796: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7797: p_table_name => 'GMD_SS_MATERIAL_SOURCES',

Line 7901: GMA_COMMON_LOGGING.gma_migration_central_log (

7897: GMD_QC_MIG12.g_matl_source_upd_count := GMD_QC_MIG12.g_matl_source_upd_count + 1;
7898:
7899: EXCEPTION
7900: WHEN MATL_NO_ORG THEN
7901: GMA_COMMON_LOGGING.gma_migration_central_log (
7902: p_run_id => p_migration_run_id,
7903: p_log_level => FND_LOG.LEVEL_ERROR,
7904: p_message_token => 'GMD_MIG_NO_ORG',
7905: p_context => 'Quality Stability Studies - gmd_ss_material_sources',

Line 7919: GMA_COMMON_LOGGING.gma_migration_central_log (

7915: GMD_QC_MIG12.g_matl_source_err_count := GMD_QC_MIG12.g_matl_source_err_count + 1;
7916: x_exception_count := x_exception_count + 1;
7917:
7918: WHEN MATL_GET_SS THEN
7919: GMA_COMMON_LOGGING.gma_migration_central_log (
7920: p_run_id => p_migration_run_id,
7921: p_log_level => FND_LOG.LEVEL_ERROR,
7922: p_message_token => 'GMD_MIG_GET_SS_ERROR',
7923: p_context => 'Quality Stability Studies - gmd_ss_material_sources',

Line 7935: GMA_COMMON_LOGGING.gma_migration_central_log (

7931: GMD_QC_MIG12.g_matl_source_err_count := GMD_QC_MIG12.g_matl_source_err_count + 1;
7932: x_exception_count := x_exception_count + 1;
7933:
7934: WHEN MATL_PLANT_ORG THEN
7935: GMA_COMMON_LOGGING.gma_migration_central_log (
7936: p_run_id => p_migration_run_id,
7937: p_log_level => FND_LOG.LEVEL_ERROR,
7938: p_message_token => 'GMD_MIG_PLANT_ORG_ID',
7939: p_context => 'Quality Stability Studies - gmd_ss_material_sources',

Line 7953: GMA_COMMON_LOGGING.gma_migration_central_log (

7949: GMD_QC_MIG12.g_matl_source_err_count := GMD_QC_MIG12.g_matl_source_err_count + 1;
7950: x_exception_count := x_exception_count + 1;
7951:
7952: WHEN MATL_MIG_LOT THEN
7953: GMA_COMMON_LOGGING.gma_migration_central_log (
7954: p_run_id => p_migration_run_id,
7955: p_log_level => FND_LOG.LEVEL_ERROR,
7956: p_message_token => 'GMD_MIG_LOT',
7957: p_context => 'Quality Stability Studies - gmd_ss_material_sources',

Line 7968: GMA_COMMON_LOGGING.gma_migration_central_log (

7964: x_exception_count := x_exception_count + 1;
7965:
7966: WHEN OTHERS THEN
7967: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7968: GMA_COMMON_LOGGING.gma_migration_central_log (
7969: p_run_id => p_migration_run_id,
7970: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7971: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7972: p_context => 'Quality Stability Studies - gmd_ss_material_sources',

Line 7994: GMA_COMMON_LOGGING.gma_migration_central_log (

7990: /*===================================
7991: Log Start of gmd_ss_variants.
7992: ===================================*/
7993:
7994: GMA_COMMON_LOGGING.gma_migration_central_log (
7995: p_run_id => p_migration_run_id,
7996: p_log_level => FND_LOG.LEVEL_EVENT,
7997: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7998: p_table_name => 'GMD_SS_VARIANTS',

Line 8118: GMA_COMMON_LOGGING.gma_migration_central_log (

8114:
8115: EXCEPTION
8116:
8117: WHEN VAR_WHSE_ERROR THEN
8118: GMA_COMMON_LOGGING.gma_migration_central_log (
8119: p_run_id => p_migration_run_id,
8120: p_log_level => FND_LOG.LEVEL_ERROR,
8121: p_message_token => 'GMD_MIG_WHSE_ERROR',
8122: p_context => 'Quality Stability Studies - gmd_ss_variants',

Line 8136: GMA_COMMON_LOGGING.gma_migration_central_log (

8132: GMD_QC_MIG12.g_ss_variant_err_count := GMD_QC_MIG12.g_ss_variant_err_count + 1;
8133: x_exception_count := x_exception_count + 1;
8134:
8135: WHEN VAR_CREATE_LOC THEN
8136: GMA_COMMON_LOGGING.gma_migration_central_log (
8137: p_run_id => p_migration_run_id,
8138: p_log_level => FND_LOG.LEVEL_ERROR,
8139: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
8140: p_context => 'Quality Stability Studies - gmd_ss_variants',

Line 8152: GMA_COMMON_LOGGING.gma_migration_central_log (

8148: GMD_QC_MIG12.g_ss_variant_err_count := GMD_QC_MIG12.g_ss_variant_err_count + 1;
8149: x_exception_count := x_exception_count + 1;
8150:
8151: WHEN VAR_LOCATOR_ID THEN
8152: GMA_COMMON_LOGGING.gma_migration_central_log (
8153: p_run_id => p_migration_run_id,
8154: p_log_level => FND_LOG.LEVEL_ERROR,
8155: p_message_token => 'GMD_MIG_LOCATOR_ID',
8156: p_context => 'Quality Stability Studies - gmd_ss_variants',

Line 8172: GMA_COMMON_LOGGING.gma_migration_central_log (

8168: GMD_QC_MIG12.g_ss_variant_err_count := GMD_QC_MIG12.g_ss_variant_err_count + 1;
8169: x_exception_count := x_exception_count + 1;
8170:
8171: WHEN VAR_SUBINV_ERROR THEN
8172: GMA_COMMON_LOGGING.gma_migration_central_log (
8173: p_run_id => p_migration_run_id,
8174: p_log_level => FND_LOG.LEVEL_ERROR,
8175: p_message_token => 'GMD_MIG_SUBINV',
8176: p_context => 'Quality Stability Studies - gmd_ss_variants',

Line 8190: GMA_COMMON_LOGGING.gma_migration_central_log (

8186:
8187:
8188: WHEN OTHERS THEN
8189: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8190: GMA_COMMON_LOGGING.gma_migration_central_log (
8191: p_run_id => p_migration_run_id,
8192: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8193: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8194: p_context => 'Quality Stability Studies - gmd_ss_variants',

Line 8243: GMA_COMMON_LOGGING.gma_migration_central_log (

8239: END IF;
8240:
8241: EXCEPTION
8242: WHEN NULL_DEFAULT_LAB THEN
8243: GMA_COMMON_LOGGING.gma_migration_central_log (
8244: p_run_id => p_migration_run_id,
8245: p_log_level => FND_LOG.LEVEL_ERROR,
8246: p_message_token => 'GMD_MIG_DEFAULT_LAB_NULL',
8247: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',

Line 8254: GMA_COMMON_LOGGING.gma_migration_central_log (

8250: RETURN;
8251: x_exception_count := x_exception_count + 1;
8252:
8253: WHEN DEFAULT_SS_ORG_ERROR THEN
8254: GMA_COMMON_LOGGING.gma_migration_central_log (
8255: p_run_id => p_migration_run_id,
8256: p_log_level => FND_LOG.LEVEL_ERROR,
8257: p_message_token => 'GMD_MIG_DEF_SS_ORG_ERROR',
8258: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',

Line 8266: GMA_COMMON_LOGGING.gma_migration_central_log (

8262: RETURN;
8263:
8264: WHEN OTHERS THEN
8265: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8266: GMA_COMMON_LOGGING.gma_migration_central_log (
8267: p_run_id => p_migration_run_id,
8268: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8269: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8270: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',

Line 8284: GMA_COMMON_LOGGING.gma_migration_central_log (

8280: /*==============================================
8281: Log Start of gmd_storage_package.
8282: ==============================================*/
8283:
8284: GMA_COMMON_LOGGING.gma_migration_central_log (
8285: p_run_id => p_migration_run_id,
8286: p_log_level => FND_LOG.LEVEL_EVENT,
8287: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8288: p_table_name => 'GMD_SS_STORAGE_PACKAGE',

Line 8528: GMA_COMMON_LOGGING.gma_migration_central_log (

8524: END IF;
8525:
8526: EXCEPTION
8527: WHEN STORE_DEF_ODM_ITEM THEN
8528: GMA_COMMON_LOGGING.gma_migration_central_log (
8529: p_run_id => p_migration_run_id,
8530: p_log_level => FND_LOG.LEVEL_ERROR,
8531: p_message_token => 'GMD_MIG_ODM_ITEM',
8532: p_context => 'Quality Stability Studies - gmd_ss_storage_package',

Line 8548: GMA_COMMON_LOGGING.gma_migration_central_log (

8544: x_exception_count := x_exception_count + 1;
8545:
8546:
8547: WHEN STORE_SS_ORG THEN
8548: GMA_COMMON_LOGGING.gma_migration_central_log (
8549: p_run_id => p_migration_run_id,
8550: p_log_level => FND_LOG.LEVEL_ERROR,
8551: p_message_token => 'GMD_MIG_SS_ORG',
8552: p_context => 'Quality Stability Studies - gmd_ss_storage_package',

Line 8565: GMA_COMMON_LOGGING.gma_migration_central_log (

8561: GMD_QC_MIG12.g_store_pack_err_count := GMD_QC_MIG12.g_store_pack_err_count + 1;
8562: x_exception_count := x_exception_count + 1;
8563:
8564: WHEN STORE_ODM_ITEM THEN
8565: GMA_COMMON_LOGGING.gma_migration_central_log (
8566: p_run_id => p_migration_run_id,
8567: p_log_level => FND_LOG.LEVEL_ERROR,
8568: p_message_token => 'GMD_MIG_ODM_ITEM',
8569: p_context => 'Quality Stability Studies - gmd_ss_storage_package',

Line 8586: GMA_COMMON_LOGGING.gma_migration_central_log (

8582:
8583:
8584: WHEN OTHERS THEN
8585: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8586: GMA_COMMON_LOGGING.gma_migration_central_log (
8587: p_run_id => p_migration_run_id,
8588: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8589: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8590: p_context => 'Quality Stability Studies - gmd_ss_storage_package',

Line 8612: GMA_COMMON_LOGGING.gma_migration_central_log (

8608: /*==============================================
8609: Log Start of gmd_ss_storage_history.
8610: ==============================================*/
8611:
8612: GMA_COMMON_LOGGING.gma_migration_central_log (
8613: p_run_id => p_migration_run_id,
8614: p_log_level => FND_LOG.LEVEL_EVENT,
8615: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8616: p_table_name => 'GMD_SS_STORAGE_HISTORY',

Line 8732: GMA_COMMON_LOGGING.gma_migration_central_log (

8728: GMD_QC_MIG12.g_ss_storehist_upd_count := GMD_QC_MIG12.g_ss_storehist_upd_count + 1;
8729:
8730: EXCEPTION
8731: WHEN HIST_WHSE_ERROR THEN
8732: GMA_COMMON_LOGGING.gma_migration_central_log (
8733: p_run_id => p_migration_run_id,
8734: p_log_level => FND_LOG.LEVEL_ERROR,
8735: p_message_token => 'GMD_MIG_WHSE_ERROR',
8736: p_context => 'Quality Stability Studies - gmd_ss_storage_history',

Line 8750: GMA_COMMON_LOGGING.gma_migration_central_log (

8746: GMD_QC_MIG12.g_ss_storehist_err_count := GMD_QC_MIG12.g_ss_storehist_err_count + 1;
8747: x_exception_count := x_exception_count + 1;
8748:
8749: WHEN HIST_CREATE_LOC THEN
8750: GMA_COMMON_LOGGING.gma_migration_central_log (
8751: p_run_id => p_migration_run_id,
8752: p_log_level => FND_LOG.LEVEL_ERROR,
8753: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
8754: p_context => 'Quality Stability Studies - gmd_ss_storage_history',

Line 8766: GMA_COMMON_LOGGING.gma_migration_central_log (

8762: GMD_QC_MIG12.g_ss_storehist_err_count := GMD_QC_MIG12.g_ss_storehist_err_count + 1;
8763: x_exception_count := x_exception_count + 1;
8764:
8765: WHEN HIST_LOCATOR_ID THEN
8766: GMA_COMMON_LOGGING.gma_migration_central_log (
8767: p_run_id => p_migration_run_id,
8768: p_log_level => FND_LOG.LEVEL_ERROR,
8769: p_message_token => 'GMD_MIG_LOCATOR_ID',
8770: p_context => 'Quality Stability Studies - gmd_ss_storage_history',

Line 8786: GMA_COMMON_LOGGING.gma_migration_central_log (

8782: GMD_QC_MIG12.g_ss_storehist_err_count := GMD_QC_MIG12.g_ss_storehist_err_count + 1;
8783: x_exception_count := x_exception_count + 1;
8784:
8785: WHEN HIST_SUBINV_ERROR THEN
8786: GMA_COMMON_LOGGING.gma_migration_central_log (
8787: p_run_id => p_migration_run_id,
8788: p_log_level => FND_LOG.LEVEL_ERROR,
8789: p_message_token => 'GMD_MIG_SUBINV',
8790: p_context => 'Quality Stability Studies - gmd_ss_storage_history',

Line 8803: GMA_COMMON_LOGGING.gma_migration_central_log (

8799: x_exception_count := x_exception_count + 1;
8800:
8801: WHEN OTHERS THEN
8802: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8803: GMA_COMMON_LOGGING.gma_migration_central_log (
8804: p_run_id => p_migration_run_id,
8805: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8806: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8807: p_context => 'Quality Stability Studies - gmd_ss_storage_history',

Line 8828: GMA_COMMON_LOGGING.gma_migration_central_log (

8824:
8825: EXCEPTION
8826:
8827: WHEN DEFAULT_SS_ORG_ERROR THEN
8828: GMA_COMMON_LOGGING.gma_migration_central_log (
8829: p_run_id => p_migration_run_id,
8830: p_log_level => FND_LOG.LEVEL_ERROR,
8831: p_message_token => 'GMD_MIG_DEF_SS_ORG_ERROR',
8832: p_context => 'Quality Stability Studies - general',

Line 8839: GMA_COMMON_LOGGING.gma_migration_central_log (

8835: x_exception_count := x_exception_count + 1;
8836:
8837: WHEN OTHERS THEN
8838: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8839: GMA_COMMON_LOGGING.gma_migration_central_log (
8840: p_run_id => p_migration_run_id,
8841: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8842: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8843: p_context => 'Quality Stability Studies - general',