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

Line 293: migration_id := GMA_MIGRATION.gma_migration_start( p_app_short_name =>

289: l_data_fix := p_data_fix;
290: --We are making migration_id and p_data_fix flag independent....
291: IF (p_migration_id IS NULL) THEN
292: mig_name := 'QM Migration Data Validation Script';
293: migration_id := GMA_MIGRATION.gma_migration_start( p_app_short_name =>
294: 'GMD',
295: p_mig_name =>
296: mig_name);
297: ELSE

Line 304: GMA_COMMON_LOGGING.gma_migration_central_log (

300:
301:
302: -- 5727706 add message below
303:
304: GMA_COMMON_LOGGING.gma_migration_central_log (
305: p_run_id => migration_id,
306: p_log_level => FND_LOG.LEVEL_EVENT, -- = informational ,
307: p_message_token => 'GMA_PRE_MIGRATION_STARTED',
308: p_table_name => 'VALIDATION_FIX',

Line 418: /*-- replaced below with GMA_COMMON_LOGGING.gma_migration_central_log to make it not an error but informational

414: --Bug start 3542894
415: l_position := 51;
416:
417:
418: /*-- replaced below with GMA_COMMON_LOGGING.gma_migration_central_log to make it not an error but informational
419: GMA_MIGRATION.gma_insert_message (
420: p_run_id => migration_id,
421: p_table_name => 'QC_SPEC_MST',
422: p_DB_ERROR => '',

Line 419: GMA_MIGRATION.gma_insert_message (

415: l_position := 51;
416:
417:
418: /*-- replaced below with GMA_COMMON_LOGGING.gma_migration_central_log to make it not an error but informational
419: GMA_MIGRATION.gma_insert_message (
420: p_run_id => migration_id,
421: p_table_name => 'QC_SPEC_MST',
422: p_DB_ERROR => '',
423: p_param1 => '',

Line 435: GMA_COMMON_LOGGING.gma_migration_central_log (

431: p_position => l_position,
432: p_base_message => '');
433: */
434:
435: GMA_COMMON_LOGGING.gma_migration_central_log (
436: p_run_id => migration_id,
437: p_log_level => FND_LOG.LEVEL_EVENT, -- = informational ,
438: p_message_token => 'LESS_FROM_START',
439: p_table_name => 'QC_SPEC_MST',

Line 465: GMA_MIGRATION.gma_insert_message (

461: SET from_date = l_samples_date.min_date,
462: to_date = l_samples_date.max_date
463: WHERE qc_spec_id = l_spec_less_from_date.qc_spec_id;
464: END IF;
465: GMA_MIGRATION.gma_insert_message (
466: p_run_id => migration_id,
467: p_table_name => 'QC_SPEC_MST',
468: p_DB_ERROR => '',
469: p_param1 => l_spec_less_from_date.qc_spec_id,

Line 490: GMA_MIGRATION.gma_insert_message (

486: UPDATE qc_spec_mst
487: SET migration_status = 'WD'
488: WHERE qc_spec_id = l_spec_less_from_date.qc_spec_id;
489: END IF;
490: GMA_MIGRATION.gma_insert_message (
491: p_run_id => migration_id,
492: p_table_name => 'QC_SPEC_MST',
493: p_DB_ERROR => '',
494: p_param1 => l_spec_less_from_date.qc_spec_id,

Line 510: /*-- replaced below with GMA_COMMON_LOGGING.gma_migration_central_log to make it not an error but informational

506: END LOOP;
507: END LOOP;
508: l_position:=59;
509:
510: /*-- replaced below with GMA_COMMON_LOGGING.gma_migration_central_log to make it not an error but informational
511:
512: GMA_MIGRATION.gma_insert_message (
513: p_run_id => migration_id,
514: p_table_name => 'QC_SPEC_MST',

Line 512: GMA_MIGRATION.gma_insert_message (

508: l_position:=59;
509:
510: /*-- replaced below with GMA_COMMON_LOGGING.gma_migration_central_log to make it not an error but informational
511:
512: GMA_MIGRATION.gma_insert_message (
513: p_run_id => migration_id,
514: p_table_name => 'QC_SPEC_MST',
515: p_DB_ERROR => '',
516: p_param1 => '',

Line 528: GMA_COMMON_LOGGING.gma_migration_central_log (

524: p_position => l_position,
525: p_base_message => ''); */
526:
527:
528: GMA_COMMON_LOGGING.gma_migration_central_log (
529: p_run_id => migration_id,
530: p_log_level => FND_LOG.LEVEL_EVENT, -- = informational ,
531: p_message_token => 'LESS_FROM_END',
532: p_table_name => 'QC_SPEC_MST',

Line 555: GMA_MIGRATION.gma_insert_message (

551: -- of_vendor_id
552: FOR l_null_vendor_id_spec IN c_null_vendor_id_spec
553: LOOP
554: -- The spec vendor_id does not have corresponding of_vendor_id
555: GMA_MIGRATION.gma_insert_message (
556: p_run_id => migration_id,
557: p_table_name => 'QC_SPEC_MST',
558: p_DB_ERROR => '',
559: p_param1 => l_null_vendor_id_spec.qc_spec_id,

Line 623: /*-- replaced below with GMA_COMMON_LOGGING.gma_migration_central_log to make it not an error but informational

619:
620:
621: l_position :=60;
622:
623: /*-- replaced below with GMA_COMMON_LOGGING.gma_migration_central_log to make it not an error but informational
624:
625: GMA_MIGRATION.gma_insert_message (
626: p_run_id => migration_id,
627: p_table_name => 'QC_SPEC_MST',

Line 625: GMA_MIGRATION.gma_insert_message (

621: l_position :=60;
622:
623: /*-- replaced below with GMA_COMMON_LOGGING.gma_migration_central_log to make it not an error but informational
624:
625: GMA_MIGRATION.gma_insert_message (
626: p_run_id => migration_id,
627: p_table_name => 'QC_SPEC_MST',
628: p_DB_ERROR => '',
629: p_param1 => '',

Line 640: GMA_COMMON_LOGGING.gma_migration_central_log (

636: p_line_no => '1',
637: p_position => l_position,
638: p_base_message => ''); */
639:
640: GMA_COMMON_LOGGING.gma_migration_central_log (
641: p_run_id => migration_id,
642: p_log_level => FND_LOG.LEVEL_EVENT, -- = informational ,
643: p_message_token => 'OVERLAP_START',
644: p_table_name => 'QC_SPEC_MST',

Line 687: GMA_MIGRATION.gma_insert_message (

683: is_total_overlap := TRUE;
684: l_position :=90;
685: --dbms_output.put_line('Is overlap true is true, no processing exit...');
686: -- CN Just return or continue after marking Spec, Smpl and Rslt
687: GMA_MIGRATION.gma_insert_message (
688: p_run_id => migration_id,
689: p_table_name => 'QC_SPEC_TEST',
690: p_DB_ERROR => '',
691: p_param1 => l_specs.l_a_qc_spec_id,

Line 759: GMA_MIGRATION.gma_insert_message (

755: l_position :=120;
756:
757:
758:
759: GMA_MIGRATION.gma_insert_message (
760: p_run_id => migration_id,
761: p_table_name => 'QC_SPEC_TEST',
762: p_DB_ERROR => '',
763: p_param1 => l_specs.l_a_qc_spec_id,

Line 786: GMA_MIGRATION.gma_insert_message (

782: WHERE qc_spec_id = l_specs.l_a_qc_spec_id;
783: END IF;
784: l_position :=130;
785:
786: GMA_MIGRATION.gma_insert_message (
787: p_run_id => migration_id,
788: p_table_name => 'QC_SPEC_TEST',
789: p_DB_ERROR => '',
790: p_param1 => l_specs.l_a_qc_spec_id,

Line 817: GMA_MIGRATION.gma_insert_message (

813: END IF;
814:
815: l_position :=150;
816:
817: GMA_MIGRATION.gma_insert_message (
818: p_run_id => migration_id,
819: p_table_name => 'QC_SPEC_TEST',
820: p_DB_ERROR => '',
821: p_param1 => l_specs.l_a_qc_spec_id,

Line 859: GMA_MIGRATION.gma_insert_message (

855: END IF;
856:
857: l_position :=180;
858:
859: GMA_MIGRATION.gma_insert_message (
860: p_run_id => migration_id,
861: p_table_name => 'QC_SPEC_TEST',
862: p_DB_ERROR => '',
863: p_param1 => l_specs.l_a_qc_spec_id,

Line 877: GMA_MIGRATION.gma_insert_message (

873: ELSE
874:
875: unable_to_resolve := TRUE;
876: l_position :=190;
877: GMA_MIGRATION.gma_insert_message (
878: p_run_id => migration_id,
879: p_table_name => 'QC_SPEC_TEST',
880: p_DB_ERROR => '',
881: p_param1 => l_specs.l_a_qc_spec_id,

Line 965: GMA_COMMON_LOGGING.gma_migration_central_log (

961: --------------------------------
962:
963: -- 5727706 add message below
964:
965: GMA_COMMON_LOGGING.gma_migration_central_log (
966: p_run_id => migration_id,
967: p_log_level => FND_LOG.LEVEL_EVENT, -- = informational ,
968: p_message_token => 'GMA_PRE_MIGRATION_SUCCESS',
969: p_table_name => 'VALIDATION_FIX',

Line 982: GMA_MIGRATION.gma_insert_message (

978:
979: EXCEPTION
980: WHEN OTHERS THEN
981: x_return_status := 'U';
982: GMA_MIGRATION.gma_insert_message (
983: p_run_id => migration_id,
984: p_table_name => 'QC_SPEC_MST',
985: p_DB_ERROR => sqlerrm,
986: p_param1 => '',

Line 991: p_message_token => 'GMA_MIGRATION_DB_ERROR',

987: p_param2 => '',
988: p_param3 => '',
989: p_param4 => '',
990: p_param5 => '',
991: p_message_token => 'GMA_MIGRATION_DB_ERROR',
992: p_message_type => 'E',
993: p_line_no => '1',
994: p_position => l_position,
995: p_base_message => 'Validation DB ERROR '||sqlerrm);