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_RESULTS_PUB dependencies on GMD_API_PUB

Line 179: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

175: ,x_user_id => l_user_id);
176:
177: IF NVL(l_user_id, -1) < 0
178: THEN
179: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
180: 'l_user_name', p_user_name);
181:
182: RAISE FND_API.G_EXC_ERROR;
183: ELSE

Line 185: GMD_API_PUB.SET_USER_CONTEXT(p_user_id => l_user_id,

181:
182: RAISE FND_API.G_EXC_ERROR;
183: ELSE
184: -- Added below for BUG 2711643. Hverddin
185: GMD_API_PUB.SET_USER_CONTEXT(p_user_id => l_user_id,
186: x_return_status => l_return_status);
187:
188: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
189: RAISE FND_API.G_EXC_ERROR;

Line 202: GMD_API_PUB.Log_Message('GMD_RESP_LAB_NOACCESS');

198: CLOSE cur_get_appl_id;
199:
200: OPEN check_resp_lab_access(l_results_row.organization_id,l_application_id);
201: IF check_resp_lab_access%NOTFOUND THEN
202: GMD_API_PUB.Log_Message('GMD_RESP_LAB_NOACCESS');
203: CLOSE check_resp_lab_access;
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206: CLOSE check_resp_lab_access;

Line 276: GMD_API_PUB.Log_Message('GMD_RESULT_DELETED');

272:
273:
274: -- Validate that Result Record is Not deleted
275: IF l_results_row.delete_mark = 1 THEN
276: GMD_API_PUB.Log_Message('GMD_RESULT_DELETED');
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279:
280: -- If values have been populated for this result then

Line 286: GMD_API_PUB.Log_Message('GMD_RESULT_RECORDED',

282:
283: IF l_results_row.result_value_num IS NOT NULL OR
284: l_results_row.result_value_char IS NOT NULL THEN
285: -- Result values have been recorded for this Result
286: GMD_API_PUB.Log_Message('GMD_RESULT_RECORDED',
287: 'l_ORGN_CODE', l_samples_rec.orgn_code,
288: 'l_SAMPLE_NO', l_samples_rec.sample_no,
289: 'l_TEST', l_tests_rec.test_code);
290: RAISE FND_API.G_EXC_ERROR;

Line 311: GMD_API_PUB.Log_Message('GMD_NO_SPEC_EVENT_FOUND',

307: l_samples_rec.sample_id);
308: FETCH c_get_event_spec INTO l_event_spec_disp_id, l_sample_disp, l_spec_id,
309: l_samples_req, l_samples_act;
310: IF c_get_event_spec%NOTFOUND THEN
311: GMD_API_PUB.Log_Message('GMD_NO_SPEC_EVENT_FOUND',
312: 'SPEC_ID', l_spec_id,
313: 'SAMP_EVENT', l_samples_rec.sampling_event_id);
314: RAISE FND_API.G_EXC_ERROR;
315: CLOSE c_get_event_spec;

Line 327: GMD_API_PUB.Log_Message('GMD_EXP_RES_DISALLOWED');

323: , x_rslt_tbl => l_rslt_tbl
324: , x_return_status => l_return_status);
325:
326: IF (l_return_Status <> 'S') THEN
327: GMD_API_PUB.Log_Message('GMD_EXP_RES_DISALLOWED');
328: RAISE FND_API.G_EXC_ERROR;
329: END IF;
330: --RLNAGARA Bug5076736 end
331:

Line 338: GMD_API_PUB.Log_Message('GMD_RESULT_VAL_NUM_REQD');

334:
335: -- Check that the result_value is Numeric
336: IF NOT GMD_RESULTS_GRP.is_value_numeric
337: ( p_char_number => p_results_rec.result_value) THEN
338: GMD_API_PUB.Log_Message('GMD_RESULT_VAL_NUM_REQD');
339: RAISE FND_API.G_EXC_ERROR;
340: END IF;
341:
342: -- l_result_value_num := p_results_rec.result_value;

Line 348: GMD_API_PUB.Log_Message('GMD_RESULT_VAL_CHAR_REQD');

344:
345: ELSIF l_tests_rec.test_type in ( 'T','V','U') THEN
346:
347: IF p_results_rec.result_value is NULL THEN
348: GMD_API_PUB.Log_Message('GMD_RESULT_VAL_CHAR_REQD');
349: RAISE FND_API.G_EXC_ERROR;
350: END IF;
351:
352: l_validate_res.result := p_results_rec.result_value;

Line 366: GMD_API_PUB.Log_Message('GMD_NO_SPEC_EVENT_FOUND',

362: l_samples_rec.sample_id);
363: FETCH c_get_event_spec INTO l_event_spec_disp_id, l_sample_disp, l_spec_id,
364: l_samples_req, l_samples_act;
365: IF c_get_event_spec%NOTFOUND THEN
366: GMD_API_PUB.Log_Message('GMD_NO_SPEC_EVENT_FOUND',
367: 'SPEC_ID', l_spec_id,
368: 'SAMP_EVENT', l_samples_rec.sampling_event_id);
369: RAISE FND_API.G_EXC_ERROR;
370: CLOSE c_get_event_spec;

Line 380: GMD_API_PUB.Log_Message('GMD_SAMPLE_DISP_INVALID',

376: --Commented the following code. No need to check the sample disposition.
377: /*
378: --== SHOULD THIS BE THE SAMPLE OR SAMPLE EVENT DISP
379: IF l_sample_disp NOT IN ('1P','2I') THEN
380: GMD_API_PUB.Log_Message('GMD_SAMPLE_DISP_INVALID',
381: 'l_SAMPLE_DISP', l_sample_disp);
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384: */

Line 460: GMD_API_PUB.Log_Message('GMD_RESULT_CHAR_NOTFOUND');

456: l_tests_rec.test_id);
457: FETCH c_get_result_num INTO l_validate_res.result_num;
458: IF c_get_result_num%NOTFOUND THEN
459: CLOSE c_get_result_num;
460: GMD_API_PUB.Log_Message('GMD_RESULT_CHAR_NOTFOUND');
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
463: CLOSE c_get_result_num;
464: END IF;

Line 479: GMD_API_PUB.Log_Message('GMD_INVALID_RESERVE_SMPL');

475: FROM gmd_samples
476: WHERE sample_id = p_results_rec.reserve_sample_id;
477: EXCEPTION
478: WHEN NO_DATA_FOUND THEN
479: GMD_API_PUB.Log_Message('GMD_INVALID_RESERVE_SMPL');
480: RAISE FND_API.G_EXC_ERROR;
481: END;
482:
483: IF (l_samples_rec.sampling_event_id <> l_reserve_sampling_event_id) THEN

Line 484: GMD_API_PUB.Log_Message('GMD_INVALID_RESERVE_SMPL');

480: RAISE FND_API.G_EXC_ERROR;
481: END;
482:
483: IF (l_samples_rec.sampling_event_id <> l_reserve_sampling_event_id) THEN
484: GMD_API_PUB.Log_Message('GMD_INVALID_RESERVE_SMPL');
485: RAISE FND_API.G_EXC_ERROR;
486: END IF;
487: END IF;
488: --==================================================

Line 509: GMD_API_PUB.Log_Message('GMD_QM_NEGATIVE_QTY');

505: l_results_row.consumed_qty := p_results_rec.consumed_qty;
506: END IF;
507:
508: IF (NVL(l_results_row.consumed_qty, 0) < 0) THEN
509: GMD_API_PUB.Log_Message('GMD_QM_NEGATIVE_QTY');
510: RAISE FND_API.G_EXC_ERROR;
511: --END IF; Bug 3468300: added else statement
512: ELSIF (( NVL(l_results_row.consumed_qty, 0) <> 0 )
513: AND (NVL(l_results_row.test_uom, '0') = '0' )) THEN

Line 520: GMD_API_PUB.Log_Message('GMD_QM_TEST_UOM');

516: l_results_row.test_uom := p_results_rec.test_qty_uom; /*NSRIVAST, INVCONV*/
517: END IF;
518:
519: IF ( NVL(l_results_row.test_uom, '0') = '0' ) THEN
520: GMD_API_PUB.Log_Message('GMD_QM_TEST_UOM');
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523: END IF;
524:

Line 728: GMD_API_PUB.Log_Message('GMD_NO_SPEC_EVENT_FOUND',

724:
725: IF (c_sample_event%NOTFOUND)
726: THEN
727: CLOSE c_sample_event;
728: GMD_API_PUB.Log_Message('GMD_NO_SPEC_EVENT_FOUND',
729: 'EVENT_SPEC_DISP_ID', l_event_spec_disp_id);
730: RAISE FND_API.G_EXC_ERROR;
731: END IF;
732: CLOSE c_sample_event;

Line 810: , p_test_id_tab IN GMD_API_PUB.number_tab

806: , p_commit IN VARCHAR2
807: , p_validation_level IN NUMBER
808: , p_user_name IN VARCHAR2
809: , p_sample_rec IN GMD_SAMPLES%ROWTYPE
810: , p_test_id_tab IN GMD_API_PUB.number_tab
811: , p_event_spec_disp_id IN NUMBER
812: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
813: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
814: , x_return_status OUT NOCOPY VARCHAR2

Line 812: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab

808: , p_user_name IN VARCHAR2
809: , p_sample_rec IN GMD_SAMPLES%ROWTYPE
810: , p_test_id_tab IN GMD_API_PUB.number_tab
811: , p_event_spec_disp_id IN NUMBER
812: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
813: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
814: , x_return_status OUT NOCOPY VARCHAR2
815: , x_msg_count OUT NOCOPY NUMBER
816: , x_msg_data OUT NOCOPY VARCHAR2

Line 813: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab

809: , p_sample_rec IN GMD_SAMPLES%ROWTYPE
810: , p_test_id_tab IN GMD_API_PUB.number_tab
811: , p_event_spec_disp_id IN NUMBER
812: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
813: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
814: , x_return_status OUT NOCOPY VARCHAR2
815: , x_msg_count OUT NOCOPY NUMBER
816: , x_msg_data OUT NOCOPY VARCHAR2
817: )

Line 824: l_results_tab GMD_API_PUB.gmd_results_tab;

820: l_api_version CONSTANT NUMBER := 2.0;
821: l_msg_count NUMBER :=0;
822: l_msg_data VARCHAR2(2000);
823: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
824: l_results_tab GMD_API_PUB.gmd_results_tab;
825: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
826: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;
827: l_user_id NUMBER(15);
828: l_date DATE := SYSDATE;

Line 825: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;

821: l_msg_count NUMBER :=0;
822: l_msg_data VARCHAR2(2000);
823: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
824: l_results_tab GMD_API_PUB.gmd_results_tab;
825: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
826: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;
827: l_user_id NUMBER(15);
828: l_date DATE := SYSDATE;
829: l_event_spec_disp_id NUMBER;

Line 876: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

872: ,x_user_id => l_user_id);
873:
874: IF NVL(l_user_id, -1) < 0
875: THEN
876: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
877: 'l_user_name', p_user_name);
878:
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;

Line 891: GMD_API_PUB.Log_Message('GMD_SAMPLE_NUMBER_REQD');

887: IF ( p_sample_rec.sample_id is NULL) THEN
888: -- Validate that composite keys are present
889:
890: IF ( p_sample_rec.sample_no is NULL) THEN
891: GMD_API_PUB.Log_Message('GMD_SAMPLE_NUMBER_REQD');
892: RAISE FND_API.G_EXC_ERROR;
893: END IF;
894:
895: IF ( p_sample_rec.orgn_code is NULL) THEN

Line 896: GMD_API_PUB.Log_Message('GMD_SAMPLE_ORGN_CODE_REQD');

892: RAISE FND_API.G_EXC_ERROR;
893: END IF;
894:
895: IF ( p_sample_rec.orgn_code is NULL) THEN
896: GMD_API_PUB.Log_Message('GMD_SAMPLE_ORGN_CODE_REQD');
897: RAISE FND_API.G_EXC_ERROR;
898: END IF;
899:
900: END IF; -- Key Sample values Present

Line 906: GMD_API_PUB.Log_Message('GMD_TEST_ID_TABLE_EMPTY');

902:
903: -- Validate that test id's are present
904:
905: IF ( p_test_id_tab.COUNT < 1 ) THEN
906: GMD_API_PUB.Log_Message('GMD_TEST_ID_TABLE_EMPTY');
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
910: -- Validate event spec disp id is present and valid

Line 913: GMD_API_PUB.Log_Message('GMD_EVENT_SPEC_DISP_NULL');

909:
910: -- Validate event spec disp id is present and valid
911:
912: IF ( p_event_spec_disp_id is NULL) THEN
913: GMD_API_PUB.Log_Message('GMD_EVENT_SPEC_DISP_NULL');
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916:
917: -- Validate that the event_spec_disp_id is Valid

Line 922: GMD_API_PUB.Log_Message('GMD_EVENT_SPEC_NOTFOUND',

918:
919: OPEN c_check_event_spec(p_event_spec_disp_id);
920: FETCH c_check_event_spec INTO l_event_spec_exists;
921: IF c_check_event_spec%NOTFOUND THEN
922: GMD_API_PUB.Log_Message('GMD_EVENT_SPEC_NOTFOUND',
923: 'event_disp', p_event_spec_disp_id);
924: RAISE FND_API.G_EXC_ERROR;
925: CLOSE c_check_event_spec;
926: END IF;

Line 1008: GMD_API_PUB.Log_Message('GMD_RESULT_VALUE_REQ');

1004: -- Validate Results Record For Result Table Key Fields
1005: -- Bug 3763419 ; add Guaranteed by Manufacturer
1006: IF p_results_rec.result_value IS NULL AND
1007: p_results_rec.eval_ind NOT IN ('4C', '5O', '1Z') THEN
1008: GMD_API_PUB.Log_Message('GMD_RESULT_VALUE_REQ');
1009: RAISE FND_API.G_EXC_ERROR;
1010: END IF;
1011:
1012: --============================

Line 1018: GMD_API_PUB.Log_Message('GMD_INVALID_INSPEC_VALUE');

1014: -- be NULL or 'Y'
1015: --============================
1016: IF ( p_results_rec.in_spec IS NOT NULL AND
1017: UPPER(p_results_rec.in_spec) <> 'Y') THEN
1018: GMD_API_PUB.Log_Message('GMD_INVALID_INSPEC_VALUE');
1019: RAISE FND_API.G_EXC_ERROR;
1020: END IF;
1021:
1022: IF p_results_rec.result_id IS NULL THEN

Line 1029: GMD_API_PUB.Log_Message('GMD_SAMPLE_NUMBER_REQD');

1025: -- Valdate Sample Definition.
1026: --============================
1027: IF ( p_results_rec.sample_id is NULL) THEN
1028: IF ( p_results_rec.sample_no is NULL) THEN
1029: GMD_API_PUB.Log_Message('GMD_SAMPLE_NUMBER_REQD');
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;
1032:
1033: IF ( p_results_rec.organization_id is NULL) THEN /*NSRIVAST, INVCONV*/

Line 1034: GMD_API_PUB.Log_Message('GMD_SAMPLE_ORGN_CODE_REQD');

1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;
1032:
1033: IF ( p_results_rec.organization_id is NULL) THEN /*NSRIVAST, INVCONV*/
1034: GMD_API_PUB.Log_Message('GMD_SAMPLE_ORGN_CODE_REQD');
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037: END IF;
1038:

Line 1044: GMD_API_PUB.Log_Message('GMD_TEST_ID_CODE_NULL');

1040: -- Validate test_code
1041: --============================
1042: IF ( p_results_rec.test_id is NULL) THEN
1043: IF ( p_results_rec.test_code is NULL) THEN
1044: GMD_API_PUB.Log_Message('GMD_TEST_ID_CODE_NULL');
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047: END IF;
1048:

Line 1053: GMD_API_PUB.Log_Message('GMD_TEST_REP_CNT_REQD');

1049: --============================
1050: -- Test Replicate Cnt
1051: --============================
1052: IF ( p_results_rec.test_replicate_cnt is NULL) THEN
1053: GMD_API_PUB.Log_Message('GMD_TEST_REP_CNT_REQD');
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056:
1057: END IF;

Line 1064: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE',

1060: WHEN FND_API.G_EXC_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: WHEN OTHERS THEN
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1064: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE',
1065: 'GMD_RESULTS_PUB.VALIDATE_INPUT',
1066: 'ERROR',SUBSTR(SQLERRM,1,100),
1067: 'POSITION','010');
1068:

Line 1113: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',

1109: RAISE FND_API.G_EXC_ERROR;
1110: END IF;
1111:
1112: IF x_samples_rec.delete_mark = 1 THEN
1113: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
1114: 'l_table_name', 'GMD_SAMPLES',
1115: 'l_column_name', 'SAMPLE_ID',
1116: 'l_key_value', x_samples_rec.sample_id);
1117: RAISE FND_API.G_EXC_ERROR;

Line 1125: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE',

1121: WHEN FND_API.G_EXC_ERROR THEN
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: WHEN OTHERS THEN
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE',
1126: 'GMD_RESULTS_PUB.GET_RESULT_INFO',
1127: 'ERROR',SUBSTR(SQLERRM,1,100),
1128: 'POSITION','010');
1129: