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_RESULT_TRANSFER_GRP dependencies on GMD_DEBUG

Line 180: GMD_debug.put_line('Entering populate transfer for samples');

176: IF (p_transfer_type = 'S') THEN
177: l_place := 20;
178:
179: IF (l_debug = 'Y') THEN
180: GMD_debug.put_line('Entering populate transfer for samples');
181: END IF;
182: OPEN c_get_common_test(p_child_id,
183: p_parent_id);
184:

Line 190: GMD_debug.put_line('Common Test Id, test_method_id Is '||l_test_id||' '||l_test_method_id);

186: LOOP
187: FETCH c_get_common_test INTO l_seq,l_test_id,l_test_method_id; --RLNAGARA Bug5197746 Added l_seq
188:
189: IF (l_debug = 'Y') THEN
190: GMD_debug.put_line('Common Test Id, test_method_id Is '||l_test_id||' '||l_test_method_id);
191: END IF;
192:
193: l_place := 40;
194: IF (c_get_common_test%NOTFOUND) THEN

Line 214: GMD_debug.put_line('Child result id, replicate_cnt is '||c_get_child_sample_row.result_id||' '||c_get_child_sample_row.test_replicate_cnt);

210: LOOP
211: FETCH c_get_child_test INTO c_get_child_sample_row;
212: --lock the child row
213: IF (l_debug = 'Y') THEN
214: GMD_debug.put_line('Child result id, replicate_cnt is '||c_get_child_sample_row.result_id||' '||c_get_child_sample_row.test_replicate_cnt);
215: END IF;
216:
217:
218: l_place := 70;

Line 240: gmd_debug.put_line('The value of the prev used parameter is '||l_prev_used);

236: l_prev_used := 'N';
237: END;
238:
239: IF (l_debug = 'Y') THEN
240: gmd_debug.put_line('The value of the prev used parameter is '||l_prev_used);
241: END IF;
242:
243: l_place := 85;
244: --insert statement for temp table

Line 517: gmd_debug.put_line('The value of spec_id and event_spec_disp_id is '||l_spec_id||' '||l_event_spec_disp_id);

513: AND spec_used_for_lot_attrib_ind = 'Y';
514: l_place := 1;
515:
516: IF (l_debug = 'Y') THEN
517: gmd_debug.put_line('The value of spec_id and event_spec_disp_id is '||l_spec_id||' '||l_event_spec_disp_id);
518: END IF;
519: EXCEPTION
520: WHEN NO_DATA_FOUND THEN
521: FND_MESSAGE.SET_NAME('GMD','GMD_NO_SAMPLING_EVENT');

Line 543: gmd_debug.put_line('Copy flex field flag is '||p_copy_flex);

539: p_copy_flex := 'Y';
540: END IF;
541:
542: IF (l_debug = 'Y') THEN
543: gmd_debug.put_line('Copy flex field flag is '||p_copy_flex);
544: END IF;
545: FOR temp_table_rslt_row in c_temp_table_rslt LOOP
546: -- Get Test record for results
547: l_tests_rec_in.test_id := temp_table_rslt_row.test_id;

Line 556: gmd_debug.put_line('Test_id, Test_code, test_type To be copied is '||l_tests_rec.test_id||' '||l_tests_rec.test_code||' '||l_tests_rec.test_type);

552: RAISE FND_API.G_EXC_ERROR;
553: END IF;
554:
555: IF (l_debug = 'Y') THEN
556: gmd_debug.put_line('Test_id, Test_code, test_type To be copied is '||l_tests_rec.test_id||' '||l_tests_rec.test_code||' '||l_tests_rec.test_type);
557: END IF;
558: --set up param_list
559: l_place := 20;
560: IF (l_spec_id IS NOT NULL) THEN

Line 576: gmd_debug.put_line('The value of additional_test_ind, result is '||l_validate_res.additional_test_ind||' '||temp_table_rslt_row.result);

572: END IF;
573: END IF;
574: l_place := 30;
575: IF (l_debug = 'Y') THEN
576: gmd_debug.put_line('The value of additional_test_ind, result is '||l_validate_res.additional_test_ind||' '||temp_table_rslt_row.result);
577: END IF;
578:
579: IF (l_validate_res.additional_test_ind IS NULL) THEN
580:

Line 609: gmd_debug.put_line('The value of Exp Error Typ, action code is '||l_validate_res.exp_error_type||' '||l_validate_res.out_action_code);

605: l_validate_res.below_max_action_code := l_spec_tests.below_max_action_code;
606: l_validate_res.above_max_action_code := l_spec_tests.above_max_action_code;
607: l_validate_res.out_action_code := l_spec_tests.out_of_spec_action;
608: IF (l_debug = 'Y') THEN
609: gmd_debug.put_line('The value of Exp Error Typ, action code is '||l_validate_res.exp_error_type||' '||l_validate_res.out_action_code);
610: END IF;
611: ELSE
612: OPEN cur_get_test(temp_table_rslt_row.test_id);
613: FETCH cur_get_test INTO l_get_test_row;

Line 655: gmd_debug.put_line('Evaluation Ind In Spec');

651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653:
654: IF (l_debug = 'Y') THEN
655: gmd_debug.put_line('Evaluation Ind In Spec');
656: gmd_debug.put_line(l_validate_res.evaluation_ind||' '||l_validate_res.in_spec);
657: gmd_debug.put_line('p_copy_edit_text, p_copy_flex, p_copy_attachment '||p_copy_edit_text||' '||p_copy_flex||' '||p_copy_attachment);
658: gmd_debug.put_line('Edit Text Code '||temp_table_rslt_row.text_code);
659: END IF;

Line 656: gmd_debug.put_line(l_validate_res.evaluation_ind||' '||l_validate_res.in_spec);

652: END IF;
653:
654: IF (l_debug = 'Y') THEN
655: gmd_debug.put_line('Evaluation Ind In Spec');
656: gmd_debug.put_line(l_validate_res.evaluation_ind||' '||l_validate_res.in_spec);
657: gmd_debug.put_line('p_copy_edit_text, p_copy_flex, p_copy_attachment '||p_copy_edit_text||' '||p_copy_flex||' '||p_copy_attachment);
658: gmd_debug.put_line('Edit Text Code '||temp_table_rslt_row.text_code);
659: END IF;
660:

Line 657: gmd_debug.put_line('p_copy_edit_text, p_copy_flex, p_copy_attachment '||p_copy_edit_text||' '||p_copy_flex||' '||p_copy_attachment);

653:
654: IF (l_debug = 'Y') THEN
655: gmd_debug.put_line('Evaluation Ind In Spec');
656: gmd_debug.put_line(l_validate_res.evaluation_ind||' '||l_validate_res.in_spec);
657: gmd_debug.put_line('p_copy_edit_text, p_copy_flex, p_copy_attachment '||p_copy_edit_text||' '||p_copy_flex||' '||p_copy_attachment);
658: gmd_debug.put_line('Edit Text Code '||temp_table_rslt_row.text_code);
659: END IF;
660:
661:

Line 658: gmd_debug.put_line('Edit Text Code '||temp_table_rslt_row.text_code);

654: IF (l_debug = 'Y') THEN
655: gmd_debug.put_line('Evaluation Ind In Spec');
656: gmd_debug.put_line(l_validate_res.evaluation_ind||' '||l_validate_res.in_spec);
657: gmd_debug.put_line('p_copy_edit_text, p_copy_flex, p_copy_attachment '||p_copy_edit_text||' '||p_copy_flex||' '||p_copy_attachment);
658: gmd_debug.put_line('Edit Text Code '||temp_table_rslt_row.text_code);
659: END IF;
660:
661:
662:

Line 757: gmd_debug.put_line('Result Action code for the child result row is '||l_validate_res.result_action_code);

753: --Now if the evaluation is reject make sure that you add a test
754: -- or resample depending on action code.
755: IF (l_validate_res.result_action_code IS NOT NULL) THEN
756: IF (l_debug = 'Y') THEN
757: gmd_debug.put_line('Result Action code for the child result row is '||l_validate_res.result_action_code);
758: END IF;
759: OPEN c_action_code(p_sample_id);
760: FETCH c_action_code into l_action_code.retest_action_code,
761: l_action_code.resample_action_code;

Line 1030: gmd_debug.put_line('The value of event_spec_disp_id is '||l_previous_row.event_spec_disp_id);

1026: BEGIN
1027: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1028: FOR l_previous_row IN c_previous_row LOOP
1029: l_place := 20;
1030: gmd_debug.put_line('The value of event_spec_disp_id is '||l_previous_row.event_spec_disp_id);
1031: gmd_debug.put_line('The value of test_id is '||l_previous_row.test_id);
1032: FOR l_curr_compo_rec IN c_curr_compo_rec(l_previous_row.event_spec_disp_id,
1033: l_previous_row.test_id) LOOP
1034: gmd_debug.put_line('The value of composite_result_id is '||l_curr_compo_rec.composite_result_id);

Line 1031: gmd_debug.put_line('The value of test_id is '||l_previous_row.test_id);

1027: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1028: FOR l_previous_row IN c_previous_row LOOP
1029: l_place := 20;
1030: gmd_debug.put_line('The value of event_spec_disp_id is '||l_previous_row.event_spec_disp_id);
1031: gmd_debug.put_line('The value of test_id is '||l_previous_row.test_id);
1032: FOR l_curr_compo_rec IN c_curr_compo_rec(l_previous_row.event_spec_disp_id,
1033: l_previous_row.test_id) LOOP
1034: gmd_debug.put_line('The value of composite_result_id is '||l_curr_compo_rec.composite_result_id);
1035: UPDATE gmd_composite_results

Line 1034: gmd_debug.put_line('The value of composite_result_id is '||l_curr_compo_rec.composite_result_id);

1030: gmd_debug.put_line('The value of event_spec_disp_id is '||l_previous_row.event_spec_disp_id);
1031: gmd_debug.put_line('The value of test_id is '||l_previous_row.test_id);
1032: FOR l_curr_compo_rec IN c_curr_compo_rec(l_previous_row.event_spec_disp_id,
1033: l_previous_row.test_id) LOOP
1034: gmd_debug.put_line('The value of composite_result_id is '||l_curr_compo_rec.composite_result_id);
1035: UPDATE gmd_composite_results
1036: SET in_spec_ind = l_previous_row.in_spec_ind,
1037: mean= l_previous_row.mean ,
1038: mode_num= l_previous_row.mode_num,

Line 1111: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_result_assoc for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');

1107: (select composite_result_id
1108: from gmd_composite_results
1109: where composite_spec_disp_id = p_composite_spec_disp_id);
1110: IF (l_debug = 'Y') THEN
1111: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_result_assoc for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');
1112: END IF;
1113: l_place := 20;
1114: delete gmd_composite_results
1115: where composite_spec_disp_id = p_composite_spec_disp_id;

Line 1118: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_results for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');

1114: delete gmd_composite_results
1115: where composite_spec_disp_id = p_composite_spec_disp_id;
1116:
1117: IF (l_debug = 'Y') THEN
1118: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_results for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');
1119: END IF;
1120:
1121: l_place := 30;
1122: delete gmd_composite_spec_disp

Line 1125: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_spec_disp for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');

1121: l_place := 30;
1122: delete gmd_composite_spec_disp
1123: where composite_spec_disp_id = p_composite_spec_disp_id;
1124: IF (l_debug = 'Y') THEN
1125: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_spec_disp for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');
1126: END IF;
1127: --Bug 3334382, single sample group transaction not gettting deleted
1128: COMMIT;
1129: --end bug 3334382