402: END IF;-- If mean or mode composite result exists
403: END IF; -- test ids match
404: END LOOP; -- Loop thro all composite results
405: ELSE -- No composite results found
406: FND_MESSAGE.SET_NAME('GMD','GMD_RESULT_NOT_FOUND');
407: FND_MESSAGE.SET_TOKEN('SAMPLE_ID', X_sampling_events(i).sample_id);
408: FND_MESSAGE.SET_TOKEN('TEST_ID', p_inv_rslt_inp_rec.test_id);
409: FND_MSG_PUB.ADD;
410: END IF; -- if the composite disposition id is found
403: END IF; -- test ids match
404: END LOOP; -- Loop thro all composite results
405: ELSE -- No composite results found
406: FND_MESSAGE.SET_NAME('GMD','GMD_RESULT_NOT_FOUND');
407: FND_MESSAGE.SET_TOKEN('SAMPLE_ID', X_sampling_events(i).sample_id);
408: FND_MESSAGE.SET_TOKEN('TEST_ID', p_inv_rslt_inp_rec.test_id);
409: FND_MSG_PUB.ADD;
410: END IF; -- if the composite disposition id is found
411: CLOSE get_composite_disp;
404: END LOOP; -- Loop thro all composite results
405: ELSE -- No composite results found
406: FND_MESSAGE.SET_NAME('GMD','GMD_RESULT_NOT_FOUND');
407: FND_MESSAGE.SET_TOKEN('SAMPLE_ID', X_sampling_events(i).sample_id);
408: FND_MESSAGE.SET_TOKEN('TEST_ID', p_inv_rslt_inp_rec.test_id);
409: FND_MSG_PUB.ADD;
410: END IF; -- if the composite disposition id is found
411: CLOSE get_composite_disp;
412: ELSE -- for simple results
465: x_inv_rslt_out_rec.composite_ind := 1;
466: l_row_num := i;
467: l_test_found := TRUE;
468: ELSE -- No Results were found
469: FND_MESSAGE.SET_NAME('GMD','GMD_RESULT_NOT_FOUND');
470: FND_MESSAGE.SET_TOKEN('SAMPLE_ID', X_sampling_events(i).sample_id);
471: FND_MESSAGE.SET_TOKEN('TEST_ID', p_inv_rslt_inp_rec.test_id);
472: FND_MSG_PUB.ADD;
473: END IF; -- geting simple results
466: l_row_num := i;
467: l_test_found := TRUE;
468: ELSE -- No Results were found
469: FND_MESSAGE.SET_NAME('GMD','GMD_RESULT_NOT_FOUND');
470: FND_MESSAGE.SET_TOKEN('SAMPLE_ID', X_sampling_events(i).sample_id);
471: FND_MESSAGE.SET_TOKEN('TEST_ID', p_inv_rslt_inp_rec.test_id);
472: FND_MSG_PUB.ADD;
473: END IF; -- geting simple results
474:
467: l_test_found := TRUE;
468: ELSE -- No Results were found
469: FND_MESSAGE.SET_NAME('GMD','GMD_RESULT_NOT_FOUND');
470: FND_MESSAGE.SET_TOKEN('SAMPLE_ID', X_sampling_events(i).sample_id);
471: FND_MESSAGE.SET_TOKEN('TEST_ID', p_inv_rslt_inp_rec.test_id);
472: FND_MSG_PUB.ADD;
473: END IF; -- geting simple results
474:
475: CLOSE get_simple_results;
637: END IF;
638:
639: EXCEPTION
640: WHEN No_Appr_Sample_evt_exp THEN
641: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLING_EVENT_NOT_FOUND');
642: FND_MSG_PUB.ADD;
643: WHEN FND_API.G_EXC_ERROR THEN
644: x_return_status := FND_API.G_RET_STS_ERROR ;
645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: );
804:
805: END IF; -- If spec id is not null
806: ELSE
807: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_NOT_FOUND');
808: FND_MSG_PUB.ADD;
809: END IF; -- If the inventory spec match exists
810:
811: EXCEPTION