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 56: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 76: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 95: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 139: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 158: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 177: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 221: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 240: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 256: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 269: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 285: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 298: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 314: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 327: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 343: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 356: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 372: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 411: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 430: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 449: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 468: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 487: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 506: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 764: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 1002: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 1313: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 1342: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 1413: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 1434: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 1471: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1498: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1527: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 1547: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 1690: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 1710: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 1726: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 1742: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 1758: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 1774: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 2056: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 2072: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 2088: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 2177: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 2186: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 2195: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 2211: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 2227: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 2243: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 2268: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 2321: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 2338: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 2364: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 2374: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 2389: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 2586: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 3143: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3161: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3179: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3198: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3220: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3237: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3258: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3276: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3295: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3312: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3335: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3354: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3371: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3392: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3409: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3428: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3445: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3461: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 3487: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 3545: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3558: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 3605: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 3672: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 3788: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3809: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3827: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 3842: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 3865: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 4362: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 4435: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 4454: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 4473: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 4503: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 4764: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 5107: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5128: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5148: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5170: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5188: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5210: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5228: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5245: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5263: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5281: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5297: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5315: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5335: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5354: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5373: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 5400: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 5742: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5760: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5777: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5794: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 5805: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5822: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 5841: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 5868: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 5976: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 6124: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 6143: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 6155: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 6174: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 6203: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 6509: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 6527: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 6543: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 6559: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 6571: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 6589: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 6616: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 6970: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 6988: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7006: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7024: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7045: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7061: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7081: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7098: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7109: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7144: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 7399: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 7532: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7550: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7566: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7587: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7604: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7615: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 7641: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 7713: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7731: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7749: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7768: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 7795: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 7903: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7921: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7937: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7955: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 7970: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 7996: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 8120: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8138: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8154: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8174: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8192: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 8245: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8256: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8268: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 8286: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 8530: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8550: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8567: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8588: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 8614: p_log_level => FND_LOG.LEVEL_EVENT,

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

Line 8734: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8752: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8768: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8788: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8805: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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

Line 8830: p_log_level => FND_LOG.LEVEL_ERROR,

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

Line 8841: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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