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 FND_LOG

Line 48: p_log_level => FND_LOG.LEVEL_EVENT,

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',
51: p_token1 => 'TAB',
52: p_token2 => 'PRO',

Line 68: p_log_level => FND_LOG.LEVEL_EVENT,

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',
71: p_token1 => 'TAB',
72: p_token2 => 'PRO',

Line 87: p_log_level => FND_LOG.LEVEL_EVENT,

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',
90: p_token1 => 'TAB',
91: p_token2 => 'PRO',

Line 131: p_log_level => FND_LOG.LEVEL_EVENT,

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',
134: p_token1 => 'TAB',
135: p_token2 => 'PRO',

Line 150: p_log_level => FND_LOG.LEVEL_EVENT,

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',
153: p_token1 => 'TAB',
154: p_token2 => 'PRO',

Line 169: p_log_level => FND_LOG.LEVEL_EVENT,

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',
172: p_token1 => 'TAB',
173: p_token2 => 'PRO',

Line 213: p_log_level => FND_LOG.LEVEL_EVENT,

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',
216: p_token1 => 'TAB',
217: p_token2 => 'PRO',

Line 232: p_log_level => FND_LOG.LEVEL_EVENT,

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',
235: p_token1 => 'TAB',
236: p_token2 => 'PRO',

Line 248: p_log_level => FND_LOG.LEVEL_EVENT,

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',
251: p_token1 => 'TAB',
252: p_token2 => 'DEL',

Line 261: p_log_level => FND_LOG.LEVEL_EVENT,

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',
264: p_token1 => 'TAB',
265: p_token2 => 'PRO',

Line 277: p_log_level => FND_LOG.LEVEL_EVENT,

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',
280: p_token1 => 'TAB',
281: p_token2 => 'DEL',

Line 290: p_log_level => FND_LOG.LEVEL_EVENT,

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',
293: p_token1 => 'TAB',
294: p_token2 => 'PRO',

Line 306: p_log_level => FND_LOG.LEVEL_EVENT,

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',
309: p_token1 => 'TAB',
310: p_token2 => 'DEL',

Line 319: p_log_level => FND_LOG.LEVEL_EVENT,

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',
322: p_token1 => 'TAB',
323: p_token2 => 'PRO',

Line 335: p_log_level => FND_LOG.LEVEL_EVENT,

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',
338: p_token1 => 'TAB',
339: p_token2 => 'DEL',

Line 348: p_log_level => FND_LOG.LEVEL_EVENT,

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',
351: p_token1 => 'TAB',
352: p_token2 => 'PRO',

Line 364: p_log_level => FND_LOG.LEVEL_EVENT,

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',
367: p_token1 => 'TAB',
368: p_token2 => 'DEL',

Line 403: p_log_level => FND_LOG.LEVEL_EVENT,

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',
406: p_token1 => 'TAB',
407: p_token2 => 'PRO',

Line 422: p_log_level => FND_LOG.LEVEL_EVENT,

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',
425: p_token1 => 'TAB',
426: p_token2 => 'PRO',

Line 441: p_log_level => FND_LOG.LEVEL_EVENT,

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',
444: p_token1 => 'TAB',
445: p_token2 => 'PRO',

Line 460: p_log_level => FND_LOG.LEVEL_EVENT,

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',
463: p_token1 => 'TAB',
464: p_token2 => 'PRO',

Line 479: p_log_level => FND_LOG.LEVEL_EVENT,

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',
482: p_token1 => 'TAB',
483: p_token2 => 'PRO',

Line 498: p_log_level => FND_LOG.LEVEL_EVENT,

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',
501: p_token1 => 'TAB',
502: p_token2 => 'PRO',

Line 756: p_log_level => FND_LOG.LEVEL_ERROR,

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,
759: p_context => 'Quality Text',
760: p_app_short_name => 'GMD');

Line 994: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
997: p_db_error => SQLERRM,
998: p_app_short_name => 'GMA');

Line 1302: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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

Line 1305: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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',
1308: p_token1 => 'VALFIELD',
1309: p_token2 => 'VALUE',

Line 1334: p_log_level => FND_LOG.LEVEL_EVENT,

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',
1337: p_token1 => 'TABLE_NAME',
1338: p_param1 => 'GMD_TEST_METHODS_B',

Line 1405: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1408: p_token1 => 'ORG',
1409: p_token2 => 'ITEMID',

Line 1426: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
1429: p_db_error => SQLERRM,
1430: p_app_short_name => 'GMA');

Line 1460: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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

Line 1463: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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',
1466: p_token1 => 'VALFIELD',
1467: p_token2 => 'VALUE',

Line 1487: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1483: l_valfield := 'GMD_INCLUDE_OPTIONAL_TEST';
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',

Line 1490: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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',
1493: p_token1 => 'VALFIELD',
1494: p_token2 => 'VALUE',

Line 1516: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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

Line 1519: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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',
1522: p_token1 => 'VALFIELD',
1523: p_token2 => 'VALUE',

Line 1539: p_log_level => FND_LOG.LEVEL_EVENT,

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',
1542: p_token1 => 'TABLE_NAME',
1543: p_param1 => 'GMD_QUALITY_CONFIG',

Line 1682: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1685: p_token1 => 'ORG',
1686: p_token2 => 'ONAME',

Line 1702: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1705: p_token1 => 'REASON',
1706: p_token2 => 'ROWK',

Line 1718: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1721: p_token1 => 'STAT',
1722: p_token2 => 'ROWK',

Line 1734: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1737: p_token1 => 'STAT',
1738: p_token2 => 'ROWK',

Line 1750: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1753: p_token1 => 'ORG',
1754: p_token2 => 'ROWK',

Line 1766: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
1769: p_db_error => SQLERRM,
1770: p_app_short_name => 'GMA');

Line 2048: p_log_level => FND_LOG.LEVEL_ERROR,

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',
2051: p_token1 => 'ORGID',
2052: p_token2 => 'ROWK',

Line 2064: p_log_level => FND_LOG.LEVEL_ERROR,

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',
2067: p_token1 => 'ORG',
2068: p_token2 => 'ROWK',

Line 2080: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
2083: p_db_error => SQLERRM,
2084: p_app_short_name => 'GMA');

Line 2169: p_log_level => FND_LOG.LEVEL_ERROR,

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;

Line 2178: p_log_level => FND_LOG.LEVEL_ERROR,

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;

Line 2187: p_log_level => FND_LOG.LEVEL_ERROR,

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',
2190: p_token1 => 'REASON',
2191: p_token2 => 'ROWK',

Line 2203: p_log_level => FND_LOG.LEVEL_ERROR,

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',
2206: p_token1 => 'STAT',
2207: p_token2 => 'ROWK',

Line 2219: p_log_level => FND_LOG.LEVEL_ERROR,

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',
2222: p_token1 => 'STAT',
2223: p_token2 => 'ROWK',

Line 2235: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
2238: p_db_error => SQLERRM,
2239: p_app_short_name => 'GMA');

Line 2260: p_log_level => FND_LOG.LEVEL_EVENT,

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',
2263: p_token1 => 'TABLE_NAME',
2264: p_param1 => 'GMD_SAMPLING_PLAN_B',

Line 2313: p_log_level => FND_LOG.LEVEL_ERROR,

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',
2316: p_token1 => 'ROWK',
2317: p_token2 => 'ROWV',

Line 2330: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
2333: p_db_error => SQLERRM,
2334: p_app_short_name => 'GMA');

Line 2356: p_log_level => FND_LOG.LEVEL_ERROR,

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',
2359: p_app_short_name => 'GMD');
2360:

Line 2366: p_log_level => FND_LOG.LEVEL_ERROR,

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',
2369: p_token1 => 'ORG',
2370: p_param1 => l_lab_profile,

Line 2381: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
2384: p_db_error => SQLERRM,
2385: p_app_short_name => 'GMA');

Line 2549: p_log_level => FND_LOG.LEVEL_EVENT,

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',
2552: p_token1 => 'TABLE_NAME',
2553: p_param1 => 'GMD_SAMPLES',

Line 2969: p_log_level => FND_LOG.LEVEL_ERROR,

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',
2972: p_token1 => 'ORG',
2973: p_token2 => 'ONAME',

Line 2987: p_log_level => FND_LOG.LEVEL_ERROR,

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',
2990: p_token1 => 'ORG',
2991: p_token2 => 'ONAME',

Line 3005: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3008: p_token1 => 'WHSE',
3009: p_token2 => 'WNAME',

Line 3024: p_log_level => FND_LOG.LEVEL_ERROR,

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,
3027: p_context => 'Quality Samples - gmd_samples',
3028: p_token1 => 'SAMPLEID',

Line 3046: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3049: p_token1 => 'ROWK',
3050: p_token2 => 'ROWV',

Line 3063: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3066: p_token1 => 'WHSE',
3067: p_token2 => 'LOCATION',

Line 3084: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3087: p_token1 => 'LOCATOR',
3088: p_token2 => 'ROWK',

Line 3102: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3105: p_token1 => 'WHSE',
3106: p_token2 => 'WNAME',

Line 3121: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3124: p_token1 => 'ROWK',
3125: p_token2 => 'ROWV',

Line 3138: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3141: p_token1 => 'WHSE',
3142: p_token2 => 'LOCATION',

Line 3161: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3164: p_token1 => 'WHSE',
3165: p_token2 => 'WNAME',

Line 3180: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3183: p_token1 => 'ROWK',
3184: p_token2 => 'ROWV',

Line 3197: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3200: p_token1 => 'WHSE',
3201: p_token2 => 'LOCATION',

Line 3218: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3221: p_token1 => 'LOCATOR',
3222: p_token2 => 'ROWK',

Line 3235: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3238: p_token1 => 'ORG',
3239: p_token2 => 'ITEMID',

Line 3254: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3257: p_token1 => 'ITEMID',
3258: p_token2 => 'ROWK',

Line 3271: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3274: p_token1 => 'ROWK',
3275: p_token2 => 'ROWV',

Line 3287: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
3290: p_db_error => SQLERRM,
3291: p_app_short_name => 'GMA');

Line 3313: p_log_level => FND_LOG.LEVEL_EVENT,

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',
3316: p_token1 => 'TABLE_NAME',
3317: p_param1 => 'GMD_SAMPLING_EVENTS',

Line 3371: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3374: p_token1 => 'SAMPLEVT',
3375: p_param1 => to_char(v_samp_event.sampling_event_id),

Line 3384: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
3387: p_db_error => SQLERRM,
3388: p_app_short_name => 'GMA');

Line 3408: p_log_level => FND_LOG.LEVEL_EVENT,

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',
3411: p_token1 => 'TABLE_NAME',
3412: p_param1 => 'GMD_RESULTS',

Line 3517: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3520: p_token1 => 'ORG',
3521: p_token2 => 'ONAME',

Line 3538: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3541: p_token1 => 'ORG',
3542: p_token2 => 'ITEMID',

Line 3556: p_log_level => FND_LOG.LEVEL_ERROR,

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',
3559: p_token1 => 'ROWK',
3560: p_token2 => 'ROWV',

Line 3571: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
3574: p_db_error => SQLERRM,
3575: p_app_short_name => 'GMA');

Line 3594: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
3597: p_db_error => SQLERRM,
3598: p_app_short_name => 'GMA');

Line 4093: p_log_level => FND_LOG.LEVEL_EVENT,

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',
4096: p_token1 => 'TABLE_NAME',
4097: p_param1 => 'GMD_SPECIFICATIONS',

Line 4166: p_log_level => FND_LOG.LEVEL_ERROR,

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,
4169: p_context => 'Quality Specifications - gmd_specifications_b',
4170: p_token1 => 'ORG',

Line 4185: p_log_level => FND_LOG.LEVEL_ERROR,

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',
4188: p_token1 => 'ORG',
4189: p_token2 => 'ITEMID',

Line 4204: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
4207: p_db_error => SQLERRM,
4208: p_app_short_name => 'GMA');

Line 4234: p_log_level => FND_LOG.LEVEL_EVENT,

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',
4237: p_token1 => 'TABLE_NAME',
4238: p_param1 => 'GMD_INVENTORY_SPEC_VRS',

Line 4495: p_log_level => FND_LOG.LEVEL_EVENT,

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,
4498: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4499: p_token1 => 'TAB',

Line 4838: p_log_level => FND_LOG.LEVEL_ERROR,

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',
4841: p_token1 => 'ORG',
4842: p_token2 => 'ONAME',

Line 4859: p_log_level => FND_LOG.LEVEL_ERROR,

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,
4862: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4863: p_token1 => 'WHSE',

Line 4879: p_log_level => FND_LOG.LEVEL_ERROR,

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,
4882: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4883: p_token1 => 'VRID',

Line 4901: p_log_level => FND_LOG.LEVEL_ERROR,

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',
4904: p_token1 => 'ROWK',
4905: p_token2 => 'ROWV',

Line 4919: p_log_level => FND_LOG.LEVEL_ERROR,

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',
4922: p_token1 => 'WHSE',
4923: p_token2 => 'LOCATION',

Line 4941: p_log_level => FND_LOG.LEVEL_ERROR,

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',
4944: p_token1 => 'LOCATOR',
4945: p_token2 => 'ROWK',

Line 4959: p_log_level => FND_LOG.LEVEL_ERROR,

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',
4962: p_token1 => 'LOTID',
4963: p_token2 => 'ROWK',

Line 4976: p_log_level => FND_LOG.LEVEL_ERROR,

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',
4979: p_token1 => 'SPECID',
4980: p_token2 => 'ROWK',

Line 4994: p_log_level => FND_LOG.LEVEL_ERROR,

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',
4997: p_token1 => 'ITEMID',
4998: p_token2 => 'ROWK',

Line 5012: p_log_level => FND_LOG.LEVEL_ERROR,

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',
5015: p_token1 => 'ROWK',
5016: p_token2 => 'ROWV',

Line 5028: p_log_level => FND_LOG.LEVEL_ERROR,

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',
5031: p_token1 => 'STAT',
5032: p_token2 => 'ROWK',

Line 5046: p_log_level => FND_LOG.LEVEL_ERROR,

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',
5049: p_token1 => 'STAT',
5050: p_token2 => 'ROWK',

Line 5066: p_log_level => FND_LOG.LEVEL_ERROR,

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,
5069: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5070: p_token1 => 'ORG',

Line 5085: p_log_level => FND_LOG.LEVEL_ERROR,

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,
5088: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5089: p_token1 => 'ORG',

Line 5104: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
5107: p_db_error => SQLERRM,
5108: p_app_short_name => 'GMA');

Line 5131: p_log_level => FND_LOG.LEVEL_EVENT,

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',
5134: p_token1 => 'TABLE_NAME',
5135: p_param1 => 'GMD_WIP_SPEC_VRS',

Line 5473: p_log_level => FND_LOG.LEVEL_ERROR,

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',
5476: p_token1 => 'ORG',
5477: p_token2 => 'ONAME',

Line 5491: p_log_level => FND_LOG.LEVEL_ERROR,

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',
5494: p_token1 => 'STAT',
5495: p_token2 => 'ROWK',

Line 5508: p_log_level => FND_LOG.LEVEL_ERROR,

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',
5511: p_token1 => 'STAT',
5512: p_token2 => 'ROWK',

Line 5525: p_log_level => FND_LOG.LEVEL_EVENT,

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,
5528: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5529: p_token1 => 'TAB',

Line 5536: p_log_level => FND_LOG.LEVEL_ERROR,

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,
5539: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5540: p_token1 => 'ORG',

Line 5553: p_log_level => FND_LOG.LEVEL_ERROR,

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,
5556: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5557: p_token1 => 'ORG',

Line 5572: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
5575: p_db_error => SQLERRM,
5576: p_app_short_name => 'GMA');

Line 5599: p_log_level => FND_LOG.LEVEL_EVENT,

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',
5602: p_token1 => 'TABLE_NAME',
5603: p_param1 => 'GMD_CUSTOMER_SPEC_VRS',

Line 5707: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
5710: p_db_error => SQLERRM,
5711: p_app_short_name => 'GMA');

Line 5855: p_log_level => FND_LOG.LEVEL_ERROR,

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',
5858: p_token1 => 'ORG',
5859: p_token2 => 'ONAME',

Line 5874: p_log_level => FND_LOG.LEVEL_ERROR,

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,
5877: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5878: p_token1 => 'TAB',

Line 5886: p_log_level => FND_LOG.LEVEL_ERROR,

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,
5889: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5890: p_token1 => 'ORG',

Line 5905: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
5908: p_db_error => SQLERRM,
5909: p_app_short_name => 'GMA');

Line 5934: p_log_level => FND_LOG.LEVEL_EVENT,

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',
5937: p_token1 => 'TABLE_NAME',
5938: p_param1 => 'GMD_SUPPLIER_SPEC_VRS',

Line 6240: p_log_level => FND_LOG.LEVEL_ERROR,

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',
6243: p_token1 => 'ORG',
6244: p_token2 => 'ONAME',

Line 6258: p_log_level => FND_LOG.LEVEL_ERROR,

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',
6261: p_token1 => 'STAT',
6262: p_token2 => 'ROWK',

Line 6274: p_log_level => FND_LOG.LEVEL_ERROR,

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',
6277: p_token1 => 'STAT',
6278: p_token2 => 'ROWK',

Line 6290: p_log_level => FND_LOG.LEVEL_ERROR,

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,
6293: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6294: p_token1 => 'TAB',

Line 6302: p_log_level => FND_LOG.LEVEL_ERROR,

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,
6305: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6306: p_token1 => 'ORG',

Line 6320: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
6323: p_db_error => SQLERRM,
6324: p_app_short_name => 'GMA');

Line 6347: p_log_level => FND_LOG.LEVEL_EVENT,

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',
6350: p_token1 => 'TABLE_NAME',
6351: p_param1 => 'GMD_MONITORING_SPEC_VRS',

Line 6701: p_log_level => FND_LOG.LEVEL_ERROR,

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',
6704: p_token1 => 'ORG',
6705: p_token2 => 'ONAME',

Line 6719: p_log_level => FND_LOG.LEVEL_ERROR,

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',
6722: p_token1 => 'ORG',
6723: p_token2 => 'ONAME',

Line 6737: p_log_level => FND_LOG.LEVEL_ERROR,

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',
6740: p_token1 => 'WHSE',
6741: p_token2 => 'WNAME',

Line 6755: p_log_level => FND_LOG.LEVEL_ERROR,

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,
6758: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6759: p_token1 => 'VRID',

Line 6776: p_log_level => FND_LOG.LEVEL_ERROR,

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',
6779: p_token1 => 'ROWK',
6780: p_token2 => 'ROWV',

Line 6792: p_log_level => FND_LOG.LEVEL_ERROR,

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',
6795: p_token1 => 'WHSE',
6796: p_token2 => 'LOCATION',

Line 6812: p_log_level => FND_LOG.LEVEL_ERROR,

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',
6815: p_token1 => 'LOCATOR',
6816: p_token2 => 'ROWK',

Line 6829: p_log_level => FND_LOG.LEVEL_ERROR,

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,
6832: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6833: p_token1 => 'TAB',

Line 6840: p_log_level => FND_LOG.LEVEL_ERROR,

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,
6843: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6844: p_token1 => 'ORG',

Line 6875: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
6878: p_db_error => SQLERRM,
6879: p_app_short_name => 'GMA');

Line 7130: p_log_level => FND_LOG.LEVEL_EVENT,

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',
7133: p_token1 => 'TABLE_NAME',
7134: p_param1 => 'GMD_STORAGE_PLAN_DETAILS',

Line 7263: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7266: p_token1 => 'WHSE',
7267: p_token2 => 'WNAME',

Line 7281: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7284: p_token1 => 'ROWK',
7285: p_token2 => 'ROWV',

Line 7297: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7300: p_token1 => 'WHSE',
7301: p_token2 => 'LOCATION',

Line 7318: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7321: p_token1 => 'LOCATOR',
7322: p_token2 => 'ROWK',

Line 7335: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7338: p_app_short_name => 'GMD');
7339: GMD_QC_MIG12.g_store_plan_err_count := GMD_QC_MIG12.g_store_plan_err_count + 1;

Line 7346: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
7349: p_db_error => SQLERRM,
7350: p_app_short_name => 'GMA');

Line 7372: p_log_level => FND_LOG.LEVEL_EVENT,

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',
7375: p_token1 => 'TABLE_NAME',
7376: p_param1 => 'GMD_STABILITY_STUDIES_B',

Line 7444: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7447: p_token1 => 'ORG',
7448: p_token2 => 'ONAME',

Line 7462: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7465: p_token1 => 'ORG',
7466: p_token2 => 'ONAME',

Line 7480: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7483: p_token1 => 'ORG',
7484: p_token2 => 'ITEMID',

Line 7499: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
7502: p_db_error => SQLERRM,
7503: p_app_short_name => 'GMA');

Line 7526: p_log_level => FND_LOG.LEVEL_EVENT,

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',
7529: p_token1 => 'TABLE_NAME',
7530: p_param1 => 'GMD_SS_MATERIAL_SOURCES',

Line 7634: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7637: p_token1 => 'ORG',
7638: p_token2 => 'ONAME',

Line 7652: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7655: p_token1 => 'STABID',
7656: p_token2 => 'ROWK',

Line 7668: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7671: p_token1 => 'ORG',
7672: p_token2 => 'SRC',

Line 7686: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7689: p_token1 => 'ROWK',
7690: p_token2 => 'ROWV',

Line 7701: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
7704: p_db_error => SQLERRM,
7705: p_app_short_name => 'GMA');

Line 7727: p_log_level => FND_LOG.LEVEL_EVENT,

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',
7730: p_token1 => 'TABLE_NAME',
7731: p_param1 => 'GMD_SS_VARIANTS',

Line 7851: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7854: p_token1 => 'WHSE',
7855: p_token2 => 'WNAME',

Line 7869: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7872: p_token1 => 'ROWK',
7873: p_token2 => 'ROWV',

Line 7885: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7888: p_token1 => 'WHSE',
7889: p_token2 => 'LOCATION',

Line 7905: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7908: p_token1 => 'LOCATOR',
7909: p_token2 => 'ROWK',

Line 7923: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
7926: p_db_error => SQLERRM,
7927: p_app_short_name => 'GMA');

Line 7976: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7979: p_app_short_name => 'GMD');
7980: ROLLBACK;

Line 7987: p_log_level => FND_LOG.LEVEL_ERROR,

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',
7990: p_app_short_name => 'GMD');
7991: x_exception_count := x_exception_count + 1;

Line 7999: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
8002: p_db_error => SQLERRM,
8003: p_app_short_name => 'GMA');

Line 8017: p_log_level => FND_LOG.LEVEL_EVENT,

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',
8020: p_token1 => 'TABLE_NAME',
8021: p_param1 => 'GMD_SS_STORAGE_PACKAGE',

Line 8261: p_log_level => FND_LOG.LEVEL_ERROR,

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',
8264: p_token1 => 'ORG',
8265: p_token2 => 'ITEMID',

Line 8281: p_log_level => FND_LOG.LEVEL_ERROR,

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',
8284: p_token1 => 'ORG',
8285: p_token2 => 'ROWK',

Line 8298: p_log_level => FND_LOG.LEVEL_ERROR,

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',
8301: p_token1 => 'ORG',
8302: p_token2 => 'ITEMID',

Line 8319: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
8322: p_db_error => SQLERRM,
8323: p_app_short_name => 'GMA');

Line 8345: p_log_level => FND_LOG.LEVEL_EVENT,

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',
8348: p_token1 => 'TABLE_NAME',
8349: p_param1 => 'GMD_SS_STORAGE_HISTORY',

Line 8465: p_log_level => FND_LOG.LEVEL_ERROR,

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',
8468: p_token1 => 'WHSE',
8469: p_token2 => 'WNAME',

Line 8483: p_log_level => FND_LOG.LEVEL_ERROR,

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',
8486: p_token1 => 'ROWK',
8487: p_token2 => 'ROWV',

Line 8499: p_log_level => FND_LOG.LEVEL_ERROR,

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',
8502: p_token1 => 'WHSE',
8503: p_token2 => 'LOCATION',

Line 8519: p_log_level => FND_LOG.LEVEL_ERROR,

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',
8522: p_token1 => 'LOCATOR',
8523: p_token2 => 'ROWK',

Line 8536: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
8539: p_db_error => SQLERRM,
8540: p_app_short_name => 'GMA');

Line 8561: p_log_level => FND_LOG.LEVEL_ERROR,

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',
8564: p_app_short_name => 'GMD');
8565:

Line 8572: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
8575: p_db_error => SQLERRM,
8576: p_app_short_name => 'GMA');