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_MIGRATE_TO_1151J dependencies on GMA_MIGRATION

Line 364: GMA_MIGRATION.gma_insert_message (

360: commit;
361:
362: commit;
363: new_mig_status := NULL;
364: GMA_MIGRATION.gma_insert_message (
365: p_run_id => p_migration_id,
366: p_table_name => 'QC_SPEC_MST',
367: p_DB_ERROR => '',
368: p_param1 => 'Overlapping spec test dates ',

Line 429: GMA_MIGRATION.gma_insert_message (

425: SET migration_status = 'UM'
426: WHERE qc_spec_id = o_qc_spec_id;
427: commit;
428: new_mig_status := NULL;
429: GMA_MIGRATION.gma_insert_message (
430: p_run_id => p_migration_id,
431: p_table_name => 'QC_SPEC_MST',
432: p_DB_ERROR => '',
433: p_param1 => 'qc_spec_id = '||o_qc_spec_id,

Line 479: GMA_MIGRATION.gma_insert_message (

475:
476: EXCEPTION
477: WHEN OTHERS THEN
478: x_return_status := 'U';
479: GMA_MIGRATION.gma_insert_message (
480: p_run_id => p_migration_id,
481: p_table_name => 'QC_SPEC_MST',
482: p_DB_ERROR => sqlerrm,
483: p_param1 => '',

Line 488: p_message_token => 'GMA_MIGRATION_DB_ERROR',

484: p_param2 => '',
485: p_param3 => '',
486: p_param4 => '',
487: p_param5 => '',
488: p_message_token => 'GMA_MIGRATION_DB_ERROR',
489: p_message_type => 'E',
490: p_line_no => '1',
491: p_position => '',
492: p_base_message => 'Failed to complete spec test dates chk '||sqlerrm);

Line 673: GMA_MIGRATION.gma_insert_message (

669: SET migration_status = 'MO';
670:
671: l_rec_count := SQL%ROWCOUNT;
672:
673: GMA_MIGRATION.gma_insert_message (
674: p_run_id => p_migration_id,
675: p_table_name => 'GMD_QC_ASSAY_CLASS',
676: p_DB_ERROR => '',
677: p_param1 => '',

Line 682: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',

678: p_param2 => l_rec_count,
679: p_param3 => '',
680: p_param4 => '',
681: p_param5 => '',
682: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',
683: p_message_type => 'P',
684: p_line_no => '1',
685: p_position => '',
686: p_base_message => '');

Line 694: GMA_MIGRATION.gma_insert_message (

690:
691: EXCEPTION
692: WHEN OTHERS THEN
693: x_return_status := 'U';
694: GMA_MIGRATION.gma_insert_message (
695: p_run_id => p_migration_id,
696: p_table_name => 'GMD_QC_ASSAY_CLASS',
697: p_DB_ERROR => sqlerrm,
698: p_param1 => '',

Line 703: p_message_token => 'GMA_MIGRATION_DB_ERROR',

699: p_param2 => '',
700: p_param3 => '',
701: p_param4 => '',
702: p_param5 => '',
703: p_message_token => 'GMA_MIGRATION_DB_ERROR',
704: p_message_type => 'E',
705: p_line_no => '1',
706: p_position => '',
707: p_base_message => 'Failed to migrate assay classes due to '||sqlerrm);

Line 709: GMA_MIGRATION.gma_insert_message (

705: p_line_no => '1',
706: p_position => '',
707: p_base_message => 'Failed to migrate assay classes due to '||sqlerrm);
708:
709: GMA_MIGRATION.gma_insert_message (
710: p_run_id => p_migration_id,
711: p_table_name => 'GMD_QC_ASSAY_CLASS',
712: p_DB_ERROR => '',
713: p_param1 => '',

Line 877: GMA_MIGRATION.gma_insert_message (

873: SET migration_status = 'MO';
874:
875: l_rec_count := SQL%ROWCOUNT;
876:
877: GMA_MIGRATION.gma_insert_message (
878: p_run_id => p_migration_id,
879: p_table_name => 'QC_ACTN_MST_BAK',
880: p_DB_ERROR => '',
881: p_param1 => '',

Line 886: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',

882: p_param2 => l_rec_count,
883: p_param3 => '',
884: p_param4 => '',
885: p_param5 => '',
886: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',
887: p_message_type => 'P',
888: p_line_no => '1',
889: p_position => '',
890: p_base_message => '') ;

Line 898: GMA_MIGRATION.gma_insert_message (

894:
895: EXCEPTION
896: WHEN OTHERS THEN
897: x_return_status := 'U';
898: GMA_MIGRATION.gma_insert_message (
899: p_run_id => p_migration_id,
900: p_table_name => 'QC_ACTN_MST_BAK',
901: p_DB_ERROR => sqlerrm,
902: p_param1 => '',

Line 907: p_message_token => 'GMA_MIGRATION_DB_ERROR',

903: p_param2 => '',
904: p_param3 => '',
905: p_param4 => '',
906: p_param5 => '',
907: p_message_token => 'GMA_MIGRATION_DB_ERROR',
908: p_message_type => 'E',
909: p_line_no => '1',
910: p_position => '',
911: p_base_message => 'Failed to migrate action codes due to '||sqlerrm);

Line 913: GMA_MIGRATION.gma_insert_message (

909: p_line_no => '1',
910: p_position => '',
911: p_base_message => 'Failed to migrate action codes due to '||sqlerrm);
912:
913: GMA_MIGRATION.gma_insert_message (
914: p_run_id => p_migration_id,
915: p_table_name => 'QC_ACTN_MST',
916: p_DB_ERROR => '',
917: p_param1 => '',

Line 1078: GMA_MIGRATION.gma_insert_message (

1074: SET migration_status = 'MO';
1075:
1076: l_rec_count := SQL%ROWCOUNT;
1077:
1078: GMA_MIGRATION.gma_insert_message (
1079: p_run_id => p_migration_id,
1080: p_table_name => 'QC_HRES_MST_BAK',
1081: p_DB_ERROR => '',
1082: p_param1 => '',

Line 1087: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',

1083: p_param2 => l_rec_count,
1084: p_param3 => '',
1085: p_param4 => '',
1086: p_param5 => '',
1087: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',
1088: p_message_type => 'P',
1089: p_line_no => '1',
1090: p_position => '',
1091: p_base_message => '');

Line 1099: GMA_MIGRATION.gma_insert_message (

1095:
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: x_return_status := 'U';
1099: GMA_MIGRATION.gma_insert_message (
1100: p_run_id => p_migration_id,
1101: p_table_name => 'QC_HRES_MST_BAK',
1102: p_DB_ERROR => sqlerrm,
1103: p_param1 => '',

Line 1108: p_message_token => 'GMA_MIGRATION_DB_ERROR',

1104: p_param2 => '',
1105: p_param3 => '',
1106: p_param4 => '',
1107: p_param5 => '',
1108: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1109: p_message_type => 'E',
1110: p_line_no => '1',
1111: p_position => '',
1112: p_base_message => 'Failed to migrate hold reasons due to '||sqlerrm);

Line 1114: GMA_MIGRATION.gma_insert_message (

1110: p_line_no => '1',
1111: p_position => '',
1112: p_base_message => 'Failed to migrate hold reasons due to '||sqlerrm);
1113:
1114: GMA_MIGRATION.gma_insert_message (
1115: p_run_id => p_migration_id,
1116: p_table_name => 'QC_HRES_MST_BAK',
1117: p_DB_ERROR => '',
1118: p_param1 => '',

Line 1323: GMA_MIGRATION.gma_insert_message (

1319: SET migration_status = 'MO';
1320:
1321: l_rec_count := SQL%ROWCOUNT;
1322:
1323: GMA_MIGRATION.gma_insert_message (
1324: p_run_id => p_migration_id,
1325: p_table_name => 'GMD_TESTS_B',
1326: p_DB_ERROR => '',
1327: p_param1 => '',

Line 1332: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',

1328: p_param2 => l_rec_count,
1329: p_param3 => '',
1330: p_param4 => '',
1331: p_param5 => '',
1332: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',
1333: p_message_type => 'P',
1334: p_line_no => '1',
1335: p_position => '',
1336: p_base_message => '');

Line 1344: GMA_MIGRATION.gma_insert_message (

1340:
1341: EXCEPTION
1342: WHEN OTHERS THEN
1343: x_return_status := 'U';
1344: GMA_MIGRATION.gma_insert_message (
1345: p_run_id => p_migration_id,
1346: p_table_name => 'GMD_TESTS_B',
1347: p_DB_ERROR => sqlerrm,
1348: p_param1 => '',

Line 1353: p_message_token => 'GMA_MIGRATION_DB_ERROR',

1349: p_param2 => '',
1350: p_param3 => '',
1351: p_param4 => '',
1352: p_param5 => '',
1353: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1354: p_message_type => 'E',
1355: p_line_no => '1',
1356: p_position => '',
1357: p_base_message => 'Failed to migrate tests base due to '||sqlerrm);

Line 1359: GMA_MIGRATION.gma_insert_message (

1355: p_line_no => '1',
1356: p_position => '',
1357: p_base_message => 'Failed to migrate tests base due to '||sqlerrm);
1358:
1359: GMA_MIGRATION.gma_insert_message (
1360: p_run_id => p_migration_id,
1361: p_table_name => 'GMD_TESTS_B',
1362: p_DB_ERROR => '',
1363: p_param1 => '',

Line 1435: GMA_MIGRATION.gma_insert_message (

1431: SET migration_status = 'MO';
1432:
1433: l_rec_count := SQL%ROWCOUNT;
1434:
1435: GMA_MIGRATION.gma_insert_message (
1436: p_run_id => p_migration_id,
1437: p_table_name => 'GMD_TESTS_TL',
1438: p_DB_ERROR => '',
1439: p_param1 => '',

Line 1444: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',

1440: p_param2 => l_rec_count,
1441: p_param3 => '',
1442: p_param4 => '',
1443: p_param5 => '',
1444: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',
1445: p_message_type => 'P',
1446: p_line_no => '1',
1447: p_position => '',
1448: p_base_message => '');

Line 1456: GMA_MIGRATION.gma_insert_message (

1452:
1453: EXCEPTION
1454: WHEN OTHERS THEN
1455: x_return_status := 'U';
1456: GMA_MIGRATION.gma_insert_message (
1457: p_run_id => p_migration_id,
1458: p_table_name => 'GMD_TESTS_TL',
1459: p_DB_ERROR => sqlerrm,
1460: p_param1 => '',

Line 1465: p_message_token => 'GMA_MIGRATION_DB_ERROR',

1461: p_param2 => '',
1462: p_param3 => '',
1463: p_param4 => '',
1464: p_param5 => '',
1465: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1466: p_message_type => 'E',
1467: p_line_no => '1',
1468: p_position => '',
1469: p_base_message => 'Failed to migrate tests translated due to '||sqlerrm);

Line 1471: GMA_MIGRATION.gma_insert_message (

1467: p_line_no => '1',
1468: p_position => '',
1469: p_base_message => 'Failed to migrate tests translated due to '||sqlerrm);
1470:
1471: GMA_MIGRATION.gma_insert_message (
1472: p_run_id => p_migration_id,
1473: p_table_name => 'GMD_TESTS_TL',
1474: p_DB_ERROR => '',
1475: p_param1 => '',

Line 1616: GMA_MIGRATION.gma_insert_message (

1612: SET migration_status = 'MO';
1613:
1614: l_rec_count := SQL%ROWCOUNT;
1615:
1616: GMA_MIGRATION.gma_insert_message (
1617: p_run_id => p_migration_id,
1618: p_table_name => 'GMD_TEST_VALUES_B',
1619: p_DB_ERROR => '',
1620: p_param1 => '',

Line 1625: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',

1621: p_param2 => l_rec_count,
1622: p_param3 => '',
1623: p_param4 => '',
1624: p_param5 => '',
1625: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',
1626: p_message_type => 'P',
1627: p_line_no => '1',
1628: p_position => '',
1629: p_base_message => '');

Line 1637: GMA_MIGRATION.gma_insert_message (

1633:
1634: EXCEPTION
1635: WHEN OTHERS THEN
1636: x_return_status := 'U';
1637: GMA_MIGRATION.gma_insert_message (
1638: p_run_id => p_migration_id,
1639: p_table_name => 'GMD_TEST_VALUES_B',
1640: p_DB_ERROR => sqlerrm,
1641: p_param1 => '',

Line 1646: p_message_token => 'GMA_MIGRATION_DB_ERROR',

1642: p_param2 => '',
1643: p_param3 => '',
1644: p_param4 => '',
1645: p_param5 => '',
1646: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1647: p_message_type => 'E',
1648: p_line_no => '1',
1649: p_position => '',
1650: p_base_message => 'Failed to migrate test values base due to '||sqlerrm);

Line 1652: GMA_MIGRATION.gma_insert_message (

1648: p_line_no => '1',
1649: p_position => '',
1650: p_base_message => 'Failed to migrate test values base due to '||sqlerrm);
1651:
1652: GMA_MIGRATION.gma_insert_message (
1653: p_run_id => p_migration_id,
1654: p_table_name => 'GMD_TEST_VALUES_B',
1655: p_DB_ERROR => '',
1656: p_param1 => '',

Line 1731: GMA_MIGRATION.gma_insert_message (

1727: SET migration_status = 'MO';
1728:
1729: l_rec_count := SQL%ROWCOUNT;
1730:
1731: GMA_MIGRATION.gma_insert_message (
1732: p_run_id => p_migration_id,
1733: p_table_name => 'GMD_TEST_VALUES_TL',
1734: p_DB_ERROR => '',
1735: p_param1 => '',

Line 1740: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',

1736: p_param2 => l_rec_count,
1737: p_param3 => '',
1738: p_param4 => '',
1739: p_param5 => '',
1740: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',
1741: p_message_type => 'P',
1742: p_line_no => '1',
1743: p_position => '',
1744: p_base_message => '');

Line 1752: GMA_MIGRATION.gma_insert_message (

1748:
1749: EXCEPTION
1750: WHEN OTHERS THEN
1751: x_return_status := 'U';
1752: GMA_MIGRATION.gma_insert_message (
1753: p_run_id => p_migration_id,
1754: p_table_name => 'GMD_TEST_VALUES_TL',
1755: p_DB_ERROR => sqlerrm,
1756: p_param1 => '',

Line 1761: p_message_token => 'GMA_MIGRATION_DB_ERROR',

1757: p_param2 => '',
1758: p_param3 => '',
1759: p_param4 => '',
1760: p_param5 => '',
1761: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1762: p_message_type => 'E',
1763: p_line_no => '1',
1764: p_position => '',
1765: p_base_message => 'Failed to migrate test values translated due to '||sqlerrm);

Line 1767: GMA_MIGRATION.gma_insert_message (

1763: p_line_no => '1',
1764: p_position => '',
1765: p_base_message => 'Failed to migrate test values translated due to '||sqlerrm);
1766:
1767: GMA_MIGRATION.gma_insert_message (
1768: p_run_id => p_migration_id,
1769: p_table_name => 'GMD_TEST_VALUES_TL',
1770: p_DB_ERROR => '',
1771: p_param1 => '',

Line 2436: GMA_MIGRATION.gma_insert_message (

2432: WHEN OTHERS THEN
2433: l_max_date := trunc(to_date('2010/12/31' , 'YYYY/MM/DD'));
2434: END;
2435:
2436: GMA_MIGRATION.gma_insert_message (
2437: p_run_id => p_migration_id,
2438: p_table_name => 'QC_SPEC_MST',
2439: p_DB_ERROR => '',
2440: p_param1 => '',

Line 2445: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',

2441: p_param2 => '',
2442: p_param3 => '',
2443: p_param4 => '',
2444: p_param5 => '',
2445: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2446: p_message_type => 'P',
2447: p_line_no => '1',
2448: p_position => '',
2449: p_base_message => '');

Line 2752: GMA_MIGRATION.gma_insert_message (

2748: sd.text_code := l_copied_text_code;
2749:
2750: EXCEPTION
2751: WHEN others THEN
2752: GMA_MIGRATION.gma_insert_message (
2753: p_run_id => p_migration_id,
2754: p_table_name => 'GMD_SPEC_TESTS_B',
2755: p_DB_ERROR => '',
2756: p_param1 => l_spec_id,

Line 3661: GMA_MIGRATION.gma_insert_message (

3657: CLOSE c_get_spec_header;
3658:
3659:
3660:
3661: GMA_MIGRATION.gma_insert_message (
3662: p_run_id => p_migration_id,
3663: p_table_name => 'QC_SPEC_MST',
3664: p_DB_ERROR => '',
3665: p_param1 => '',

Line 3670: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',

3666: p_param2 => '',
3667: p_param3 => '',
3668: p_param4 => '',
3669: p_param5 => '',
3670: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
3671: p_message_type => 'P',
3672: p_line_no => '1',
3673: p_position => '',
3674: p_base_message => '');

Line 3683: GMA_MIGRATION.gma_insert_message (

3679: EXCEPTION
3680: WHEN OTHERS THEN
3681: x_return_status := 'U';
3682: /* ROLLBACK TO SAVEPOINT Specification_Group; */
3683: GMA_MIGRATION.gma_insert_message (
3684: p_run_id => p_migration_id,
3685: p_table_name => 'QC_SPEC_MST',
3686: p_DB_ERROR => sqlerrm,
3687: p_param1 => sd.qc_spec_id,

Line 3692: p_message_token => 'GMA_MIGRATION_DB_ERROR',

3688: p_param2 => l_spec_id,
3689: p_param3 => sd.qcassy_typ_id,
3690: p_param4 => '',
3691: p_param5 => '',
3692: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3693: p_message_type => 'E',
3694: p_line_no => '1',
3695: p_position => '',
3696: p_base_message => 'Failed to migrate specifications due to '||sqlerrm);

Line 3698: GMA_MIGRATION.gma_insert_message (

3694: p_line_no => '1',
3695: p_position => '',
3696: p_base_message => 'Failed to migrate specifications due to '||sqlerrm);
3697:
3698: GMA_MIGRATION.gma_insert_message (
3699: p_run_id => p_migration_id,
3700: p_table_name => 'QC_SPEC_MST',
3701: p_DB_ERROR => '',
3702: p_param1 => '',

Line 3989: GMA_MIGRATION.gma_insert_message (

3985:
3986:
3987: BEGIN
3988:
3989: GMA_MIGRATION.gma_insert_message (
3990: p_run_id => p_migration_id,
3991: p_table_name => 'QC_SMPL_MST',
3992: p_DB_ERROR => '',
3993: p_param1 => '',

Line 3998: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',

3994: p_param2 => '',
3995: p_param3 => '',
3996: p_param4 => '',
3997: p_param5 => '',
3998: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3999: p_message_type => 'P',
4000: p_line_no => '1',
4001: p_position => '',
4002: p_base_message => '');

Line 4591: GMA_MIGRATION.gma_insert_message (

4587: FETCH c_get_sm_specs into l_spec_id, l_spec_vr_id, l_sm_tests_cnt;
4588: IF c_get_sm_specs%FOUND then
4589:
4590: IF l_sm_tests_cnt = 0 then
4591: GMA_MIGRATION.gma_insert_message (
4592: p_run_id => p_migration_id,
4593: p_table_name => 'QC_SMPL_MST',
4594: p_DB_ERROR => '',
4595: p_param1 => 'Sample with results have with spec tests',

Line 4600: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',

4596: p_param2 => 'Cannot match migrated spec ',
4597: p_param3 => 'Sample_id = '||smpl_rec.sample_id,
4598: p_param4 => '',
4599: p_param5 => '',
4600: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',
4601: p_message_type => 'P',
4602: p_line_no => '1',
4603: p_position => '',
4604: p_base_message => '');

Line 5094: GMA_MIGRATION.gma_insert_message (

5090: END LOOP; /* Number of records returned */
5091:
5092: CLOSE c_get_samples;
5093:
5094: GMA_MIGRATION.gma_insert_message (
5095: p_run_id => p_migration_id,
5096: p_table_name => 'QC_SMPL_MST',
5097: p_DB_ERROR => '',
5098: p_param1 => '',

Line 5103: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',

5099: p_param2 => l_rec_count,
5100: p_param3 => '',
5101: p_param4 => '',
5102: p_param5 => '',
5103: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',
5104: p_message_type => 'P',
5105: p_line_no => '1',
5106: p_position => '',
5107: p_base_message => '');

Line 5113: GMA_MIGRATION.gma_insert_message (

5109: EXCEPTION
5110: WHEN OTHERS THEN
5111: x_return_status := 'U';
5112: ROLLBACK TO SAVEPOINT Sample_Rec;
5113: GMA_MIGRATION.gma_insert_message (
5114: p_run_id => p_migration_id,
5115: p_table_name => 'QC_SMPL_MST',
5116: p_DB_ERROR => sqlerrm,
5117: p_param1 => '',

Line 5122: p_message_token => 'GMA_MIGRATION_DB_ERROR',

5118: p_param2 => '',
5119: p_param3 => '',
5120: p_param4 => '',
5121: p_param5 => '',
5122: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5123: p_message_type => 'E',
5124: p_line_no => '1',
5125: p_position => '',
5126: p_base_message => 'Failed to migrate samples due to '||sqlerrm);

Line 5128: GMA_MIGRATION.gma_insert_message (

5124: p_line_no => '1',
5125: p_position => '',
5126: p_base_message => 'Failed to migrate samples due to '||sqlerrm);
5127:
5128: GMA_MIGRATION.gma_insert_message (
5129: p_run_id => p_migration_id,
5130: p_table_name => 'QC_SMPL_MST',
5131: p_DB_ERROR => '',
5132: p_param1 => '',

Line 5317: GMA_MIGRATION.gma_insert_message (

5313: WHERE spec_id = pspec_id;
5314:
5315: BEGIN
5316:
5317: GMA_MIGRATION.gma_insert_message (
5318: p_run_id => p_migration_id,
5319: p_table_name => 'QC_RSLT_MST',
5320: p_DB_ERROR => '',
5321: p_param1 => '',

Line 5326: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',

5322: p_param2 => '',
5323: p_param3 => '',
5324: p_param4 => '',
5325: p_param5 => '',
5326: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5327: p_message_type => 'P',
5328: p_line_no => '1',
5329: p_position => '',
5330: p_base_message => '');

Line 5400: GMA_MIGRATION.gma_insert_message (

5396: -- do not match.
5397: -- Changed to add the test as an additional test and
5398: -- msg is written to migration log.
5399: IF c_check_spec%NOTFOUND THEN
5400: GMA_MIGRATION.gma_insert_message (
5401: p_run_id => p_migration_id,
5402: p_table_name => 'QC_RSLT_MST',
5403: p_DB_ERROR => '',
5404: p_param1 => ' Spec_Id = '||id_rec.spec_id,

Line 5620: /* GMA_MIGRATION.gma_insert_message (

5616: rslt_rec.last_update_date,
5617: rslt_rec.last_updated_by,
5618: rslt_rec.last_update_login
5619: );
5620: /* GMA_MIGRATION.gma_insert_message (
5621: p_run_id => p_migration_id,
5622: p_table_name => 'QC_RSLT_MST',
5623: p_DB_ERROR => '',
5624: p_param1 => '',

Line 5666: GMA_MIGRATION.gma_insert_message (

5662:
5663: COMMIT;
5664:
5665:
5666: GMA_MIGRATION.gma_insert_message (
5667: p_run_id => p_migration_id,
5668: p_table_name => 'QC_RSLT_MST',
5669: p_DB_ERROR => '',
5670: p_param1 => '',

Line 5675: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',

5671: p_param2 => l_rec_count,
5672: p_param3 => '',
5673: p_param4 => '',
5674: p_param5 => '',
5675: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS_RW',
5676: p_message_type => 'P',
5677: p_line_no => '1',
5678: p_position => '',
5679: p_base_message => '');

Line 5685: GMA_MIGRATION.gma_insert_message (

5681: EXCEPTION
5682: WHEN OTHERS THEN
5683: x_return_status := 'U';
5684: /* ROLLBACK TO SAVEPOINT Result_Rec; */
5685: GMA_MIGRATION.gma_insert_message (
5686: p_run_id => p_migration_id,
5687: p_table_name => 'QC_RSLT_MST',
5688: p_DB_ERROR => sqlerrm,
5689: p_param1 => '',

Line 5694: p_message_token => 'GMA_MIGRATION_DB_ERROR',

5690: p_param2 => '',
5691: p_param3 => '',
5692: p_param4 => '',
5693: p_param5 => '',
5694: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5695: p_message_type => 'E',
5696: p_line_no => '1',
5697: p_position => '',
5698: p_base_message => 'Failed to migrate results due to '||sqlerrm);

Line 5700: GMA_MIGRATION.gma_insert_message (

5696: p_line_no => '1',
5697: p_position => '',
5698: p_base_message => 'Failed to migrate results due to '||sqlerrm);
5699:
5700: GMA_MIGRATION.gma_insert_message (
5701: p_run_id => p_migration_id,
5702: p_table_name => 'QC_RSLT_MST',
5703: p_DB_ERROR => '',
5704: p_param1 => '',

Line 5822: GMA_MIGRATION.gma_insert_message (

5818: -- gmd_p_fs_context sets the formula security context
5819: --
5820: gmd_p_fs_context.set_additional_attr;
5821:
5822: GMA_MIGRATION.gma_insert_message (
5823: p_run_id => p_migration_id,
5824: p_table_name => 'Create_Sample_Results',
5825: p_DB_ERROR => '',
5826: p_param1 => '',

Line 5869: GMA_MIGRATION.gma_insert_message (

5865: IF l_return_status = 'S' THEN
5866: COMMIT;
5867: ELSE
5868: ROLLBACK;
5869: GMA_MIGRATION.gma_insert_message (
5870: p_run_id => p_migration_id,
5871: p_table_name => 'GMD_SPEC_RESULTS',
5872: p_DB_ERROR => sqlerrm,
5873: p_param1 => 'l_spec_vr_id= '||l_spec_vr_id,

Line 5878: p_message_token => 'GMA_MIGRATION_DB_ERROR',

5874: p_param2 => 'nores_rec.sample_id= '||nores_rec.sample_id,
5875: p_param3 => 'nores_rec.lot_retest_ind= '||nores_rec.lot_retest_ind,
5876: p_param4 => 'nores_rec.sampling_event_id= '||nores_rec.sampling_event_id,
5877: p_param5 => '',
5878: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5879: p_message_type => 'E',
5880: p_line_no => '1',
5881: p_position => '',
5882: p_base_message => 'Failed to migrate results due to '||sqlerrm);

Line 5899: GMA_MIGRATION.gma_insert_message (

5895: -- tests and all tests are evaluated.
5896:
5897: select sysdate into l_date from dual ;
5898:
5899: GMA_MIGRATION.gma_insert_message (
5900: p_run_id => p_migration_id,
5901: p_table_name => 'Create_Sample_Results',
5902: p_DB_ERROR => '',
5903: p_param1 => '',

Line 5960: GMA_MIGRATION.gma_insert_message (

5956: CLOSE c_rep_cnt;
5957:
5958: commit;
5959:
5960: GMA_MIGRATION.gma_insert_message (
5961: p_run_id => p_migration_id,
5962: p_table_name => 'Create_Sample_Results',
5963: p_DB_ERROR => '',
5964: p_param1 => '',

Line 5978: GMA_MIGRATION.gma_insert_message (

5974:
5975: EXCEPTION
5976: WHEN OTHERS THEN
5977: x_return_status := 'U';
5978: GMA_MIGRATION.gma_insert_message (
5979: p_run_id => p_migration_id,
5980: p_table_name => 'SAMPLE_RESULTS',
5981: p_DB_ERROR => sqlerrm,
5982: p_param1 => '',

Line 5987: p_message_token => 'GMA_MIGRATION_DB_ERROR',

5983: p_param2 => '',
5984: p_param3 => '',
5985: p_param4 => '',
5986: p_param5 => '',
5987: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5988: p_message_type => 'E',
5989: p_line_no => '1',
5990: p_position => '',
5991: p_base_message => '');

Line 6006: GMA_MIGRATION.gma_insert_message (

6002: BEGIN
6003:
6004: l_max_date := trunc(fnd_date.canonical_to_date(nvl(fnd_profile.value('SY$MAX_DATE'),'2010/12/31') ));
6005:
6006: GMA_MIGRATION.gma_insert_message (
6007: p_run_id => p_migration_id,
6008: p_table_name => 'GMD_WIP_SPEC_VRS',
6009: p_DB_ERROR => '',
6010: p_param1 => 'Nulling out end date on wip vrs ',

Line 6026: GMA_MIGRATION.gma_insert_message (

6022: set end_date = NULL
6023: where trunc(end_date + 1) >= l_max_date
6024: and SPEC_VR_STATUS = 700;
6025:
6026: GMA_MIGRATION.gma_insert_message (
6027: p_run_id => p_migration_id,
6028: p_table_name => 'GMD_INVENTORY_SPEC_VRS',
6029: p_DB_ERROR => '',
6030: p_param1 => 'Nulling out end date on Inventory vrs ',

Line 6047: GMA_MIGRATION.gma_insert_message (

6043: set end_date = NULL
6044: where trunc(end_date + 1) >= l_max_date
6045: and SPEC_VR_STATUS = 700;
6046:
6047: GMA_MIGRATION.gma_insert_message (
6048: p_run_id => p_migration_id,
6049: p_table_name => 'GMD_CUSTOMER_SPEC_VRS',
6050: p_DB_ERROR => '',
6051: p_param1 => 'Nulling out end date on customer vrs ',

Line 6067: GMA_MIGRATION.gma_insert_message (

6063: set end_date = NULL
6064: where trunc(end_date + 1) >= l_max_date
6065: and SPEC_VR_STATUS = 700;
6066:
6067: GMA_MIGRATION.gma_insert_message (
6068: p_run_id => p_migration_id,
6069: p_table_name => 'GMD_SUPPLIER_SPEC_VRS',
6070: p_DB_ERROR => '',
6071: p_param1 => 'Nulling out end date on supplier vrs ',

Line 6092: GMA_MIGRATION.gma_insert_message (

6088:
6089: EXCEPTION
6090: WHEN OTHERS THEN
6091: x_return_status := 'U';
6092: GMA_MIGRATION.gma_insert_message (
6093: p_run_id => p_migration_id,
6094: p_table_name => 'GMD_***_SPEC_VRS',
6095: p_DB_ERROR => sqlerrm,
6096: p_param1 => '',

Line 6101: p_message_token => 'GMA_MIGRATION_DB_ERROR',

6097: p_param2 => '',
6098: p_param3 => '',
6099: p_param4 => '',
6100: p_param5 => '',
6101: p_message_token => 'GMA_MIGRATION_DB_ERROR',
6102: p_message_type => 'E',
6103: p_line_no => '1',
6104: p_position => '',
6105: p_base_message => '');