DBA Data[Home] [Help]

APPS.GMD_RESULT_TRANSFER_GRP dependencies on FND_API

Line 170: x_return_status :=FND_API.G_RET_STS_SUCCESS;

166:
167:
168:
169: BEGIN
170: x_return_status :=FND_API.G_RET_STS_SUCCESS;
171: FND_MSG_PUB.initialize;
172: --GMD_API_PUB.Log_Message('Deleting gmd_result_transfer_gt');
173: l_place := 0;
174: DELETE gmd_result_transfer_gt;

Line 250: RAISE FND_API.G_EXC_ERROR;

246:
247: l_common_test_count := l_common_test_count +1;
248:
249: IF NOT GMD_RESULTS_PVT.LOCK_ROW ( p_result_id => c_get_child_sample_row.result_id ) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252: l_test_code := get_test_code(l_test_id);
253:
254: INSERT INTO gmd_result_transfer_gt

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

318:
319: EXCEPTION
320:
321: WHEN OTHERS THEN
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: log_msg('GMD_QC_RESULT_TRANSFER_GRP.POPULATE_TRANSFER AT '||l_place||' '|| SUBSTR(SQLERRM,1,100));
324: FND_MSG_PUB.Count_AND_GET
325: (p_count => x_message_count, p_data => x_message_data);
326:

Line 504: x_return_status :=FND_API.G_RET_STS_SUCCESS;

500: l_return_status_expression VARCHAR2(10);
501:
502:
503: BEGIN
504: x_return_status :=FND_API.G_RET_STS_SUCCESS;
505: FND_MSG_PUB.initialize;
506: BEGIN
507: SELECT spec_id,
508: event_spec_disp_id

Line 552: RAISE FND_API.G_EXC_ERROR;

548: l_place := 15;
549: IF NOT GMD_QC_TESTS_PVT.fetch_row
550: ( p_gmd_qc_tests => l_tests_rec_in,
551: x_gmd_qc_tests => l_tests_rec) THEN
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);

Line 651: RAISE FND_API.G_EXC_ERROR;

647: x_return_status => l_return_status
648: );
649: l_place := 35;
650: IF l_return_status<>'S' THEN
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');

Line 723: RAISE FND_API.G_EXC_ERROR;

719: , x_rslt_tbl => l_rslt_tbl
720: , x_return_status => l_return_status);
721:
722: IF l_return_status<>'S' THEN
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725: END IF;
726:
727:

Line 741: RAISE FND_API.G_EXC_ERROR;

737: IF NOT GMD_SPEC_RESULTS_PVT.lock_row
738: ( p_event_spec_disp_id => l_event_spec_disp_id,
739: p_result_id => temp_table_rslt_row.child_result_id
740: ) THEN
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743:
744: UPDATE GMD_SPEC_RESULTS
745: SET IN_SPEC_IND = l_validate_res.in_spec,

Line 788: RAISE FND_API.G_EXC_ERROR;

784:
785:
786:
787: IF l_return_status <> 'S' THEN
788: RAISE FND_API.G_EXC_ERROR;
789: ELSE
790: gmd_api_pub.RAISE2(
791: P_event_name =>'oracle.apps.gmd.qm.performtest',
792: P_event_key =>p_sample_id,

Line 821: RAISE FND_API.G_EXC_ERROR;

817: , x_rslt_tbl => l_rslt_tbl_expression
818: , x_return_status => l_return_status_expression);
819:
820: IF (l_return_status_expression <>'S') THEN
821: RAISE FND_API.G_EXC_ERROR;
822: END IF ;
823: -- Bug 3892771
824:
825:

Line 845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

841: GMD_RESULTS_GRP.se_recomposite_required ( p_sampling_event_id => p_sampling_event_id
842: , p_event_spec_disp_id => l_event_spec_disp_id
843: , x_return_status => l_return_status
844: );
845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848: END IF;
849:

Line 846: RAISE FND_API.G_EXC_ERROR;

842: , p_event_spec_disp_id => l_event_spec_disp_id
843: , x_return_status => l_return_status
844: );
845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848: END IF;
849:
850:

Line 940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

936: COMMIT;
937: EXCEPTION
938:
939: WHEN OTHERS THEN
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: log_msg('GMD_QC_RESULT_TRANSFER_GRP.DO_TRANSFER AT '||l_place||' '|| SUBSTR(SQLERRM,1,100));
942: FND_MSG_PUB.Count_AND_GET
943: (p_count => x_message_count, p_data => x_message_data);
944: END do_transfer;

Line 1027: x_return_status :=FND_API.G_RET_STS_SUCCESS;

1023:
1024: l_place NUMBER;
1025:
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);

Line 1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1084: END LOOP;
1085: EXCEPTION
1086:
1087: WHEN OTHERS THEN
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1089: log_msg('GMD_QC_RESULT_TRANSFER_GRP.DO_TRANSFER AT '||l_place||' '|| SUBSTR(SQLERRM,1,100));
1090: FND_MSG_PUB.Count_AND_GET
1091: (p_count => x_message_count, p_data => x_message_data);
1092:

Line 1101: x_return_status :=FND_API.G_RET_STS_SUCCESS;

1097: x_message_data OUT NOCOPY VARCHAR2,
1098: x_return_status OUT NOCOPY VARCHAR2) IS
1099: l_place NUMBER;
1100: BEGIN
1101: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1102: -- There can never be any issue with locking as exiting the form should always delete single
1103: -- composites.
1104: l_place := 10;
1105: delete gmd_composite_result_assoc

Line 1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1129: --end bug 3334382
1130: EXCEPTION
1131:
1132: WHEN OTHERS THEN
1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: log_msg('GMD_RESULT_TRANSFER_GRP.delete_single_composite AT '||l_place||' '|| SUBSTR(SQLERRM,1,100));
1135: FND_MSG_PUB.Count_AND_GET
1136: (p_count => x_message_count, p_data => x_message_data);
1137: END delete_single_composite;