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_QC_TEST_VALUES_GRP dependencies on FND_MESSAGE

Line 46: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_ID_CODE_NULL');

42:
43: x_return_status := FND_API.G_RET_STS_SUCCESS ;
44:
45: IF p_test_id IS NULL THEN
46: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_ID_CODE_NULL');
47: FND_MSG_PUB.ADD;
48: RAISE FND_API.G_EXC_ERROR;
49: END IF;
50:

Line 70: FND_MESSAGE.SET_NAME('GMD','GMD_RANGES_MAY_NOT_OVERLAP');

66: x_max_range := l_max ;
67: IF l_counter > 1 THEN
68: IF NVL(l_min,-999999999.999999999) <= NVL(l_prev_max,999999999.999999999) THEN
69: CLOSE CR_TEST_VALUES ;
70: FND_MESSAGE.SET_NAME('GMD','GMD_RANGES_MAY_NOT_OVERLAP');
71: FND_MSG_PUB.ADD;
72: RAISE FND_API.G_EXC_ERROR;
73: END IF;
74: ELSIF l_counter = 1 THEN

Line 89: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

85: THEN
86: IF CR_TEST_VALUES%ISOPEN THEN
87: CLOSE CR_TEST_VALUES ;
88: END IF;
89: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
90: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_RANGE_OVERLAP' );
91: FND_MESSAGE.Set_Token('ERROR', SUBSTR(SQLERRM,1,100));
92: FND_MESSAGE.Set_Token('POSITION',l_progress );
93: FND_MSG_PUB.ADD;

Line 90: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_RANGE_OVERLAP' );

86: IF CR_TEST_VALUES%ISOPEN THEN
87: CLOSE CR_TEST_VALUES ;
88: END IF;
89: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
90: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_RANGE_OVERLAP' );
91: FND_MESSAGE.Set_Token('ERROR', SUBSTR(SQLERRM,1,100));
92: FND_MESSAGE.Set_Token('POSITION',l_progress );
93: FND_MSG_PUB.ADD;
94: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 91: FND_MESSAGE.Set_Token('ERROR', SUBSTR(SQLERRM,1,100));

87: CLOSE CR_TEST_VALUES ;
88: END IF;
89: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
90: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_RANGE_OVERLAP' );
91: FND_MESSAGE.Set_Token('ERROR', SUBSTR(SQLERRM,1,100));
92: FND_MESSAGE.Set_Token('POSITION',l_progress );
93: FND_MSG_PUB.ADD;
94: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 92: FND_MESSAGE.Set_Token('POSITION',l_progress );

88: END IF;
89: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
90: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_RANGE_OVERLAP' );
91: FND_MESSAGE.Set_Token('ERROR', SUBSTR(SQLERRM,1,100));
92: FND_MESSAGE.Set_Token('POSITION',l_progress );
93: FND_MSG_PUB.ADD;
94: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
96: END CHECK_RANGE_OVERLAP;

Line 183: FND_MESSAGE.SET_NAME('GMD','TEST_ID_CODE_NULL');

179:
180: x_return_status := FND_API.G_RET_STS_SUCCESS ;
181:
182: IF p_test_id IS NULL THEN
183: FND_MESSAGE.SET_NAME('GMD','TEST_ID_CODE_NULL');
184: FND_MSG_PUB.ADD;
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:

Line 192: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_TEST');

188: OPEN cr_get_test_type(p_test_id);
189: FETCH cr_get_test_type INTO x_test_type,x_display_precision,l_delete_mark;
190: IF cr_get_test_type%NOTFOUND THEN
191: CLOSE cr_get_test_type;
192: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_TEST');
193: FND_MESSAGE.SET_TOKEN('TEST', TO_CHAR(p_test_id));
194: FND_MSG_PUB.ADD;
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;

Line 193: FND_MESSAGE.SET_TOKEN('TEST', TO_CHAR(p_test_id));

189: FETCH cr_get_test_type INTO x_test_type,x_display_precision,l_delete_mark;
190: IF cr_get_test_type%NOTFOUND THEN
191: CLOSE cr_get_test_type;
192: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_TEST');
193: FND_MESSAGE.SET_TOKEN('TEST', TO_CHAR(p_test_id));
194: FND_MSG_PUB.ADD;
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197: CLOSE cr_get_test_type ;

Line 202: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_DELETED');

198:
199: l_progress := '020';
200:
201: IF l_delete_mark = 1 THEN
202: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_DELETED');
203: FND_MESSAGE.SET_TOKEN('TEST',TO_CHAR(p_test_id));
204: FND_MSG_PUB.ADD;
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;

Line 203: FND_MESSAGE.SET_TOKEN('TEST',TO_CHAR(p_test_id));

199: l_progress := '020';
200:
201: IF l_delete_mark = 1 THEN
202: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_DELETED');
203: FND_MESSAGE.SET_TOKEN('TEST',TO_CHAR(p_test_id));
204: FND_MSG_PUB.ADD;
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207: IF GMD_QC_TESTS_GRP.test_exist_in_spec(p_test_id => p_test_id) THEN

Line 208: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_USED_IN_SPEC');

204: FND_MSG_PUB.ADD;
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207: IF GMD_QC_TESTS_GRP.test_exist_in_spec(p_test_id => p_test_id) THEN
208: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_USED_IN_SPEC');
209: FND_MESSAGE.SET_TOKEN('TEST',TO_CHAR(p_test_id));
210: FND_MSG_PUB.ADD;
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;

Line 209: FND_MESSAGE.SET_TOKEN('TEST',TO_CHAR(p_test_id));

205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207: IF GMD_QC_TESTS_GRP.test_exist_in_spec(p_test_id => p_test_id) THEN
208: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_USED_IN_SPEC');
209: FND_MESSAGE.SET_TOKEN('TEST',TO_CHAR(p_test_id));
210: FND_MSG_PUB.ADD;
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:

Line 220: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

216: x_return_status := FND_API.G_RET_STS_ERROR ;
217: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
218:
219: WHEN OTHERS THEN
220: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
221: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_VALID_TEST');
222: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
223: FND_MESSAGE.Set_Token('POSITION',l_progress );
224: FND_MSG_PUB.ADD;

Line 221: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_VALID_TEST');

217: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
218:
219: WHEN OTHERS THEN
220: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
221: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_VALID_TEST');
222: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
223: FND_MESSAGE.Set_Token('POSITION',l_progress );
224: FND_MSG_PUB.ADD;
225: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 222: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

218:
219: WHEN OTHERS THEN
220: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
221: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_VALID_TEST');
222: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
223: FND_MESSAGE.Set_Token('POSITION',l_progress );
224: FND_MSG_PUB.ADD;
225: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 223: FND_MESSAGE.Set_Token('POSITION',l_progress );

219: WHEN OTHERS THEN
220: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
221: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_VALID_TEST');
222: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
223: FND_MESSAGE.Set_Token('POSITION',l_progress );
224: FND_MSG_PUB.ADD;
225: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227:

Line 251: FND_MESSAGE.SET_NAME('GMD','GMD_EXP_TEST_ID_NOT_REQD');

247:
248: -- There should be no test values for p_test_type IN ('U','N','E').. Do that validation in PUBLIC API's
249:
250: IF x_qc_test_values_rec.EXPRESSION_REF_TEST_ID IS NOT NULL THEN
251: FND_MESSAGE.SET_NAME('GMD','GMD_EXP_TEST_ID_NOT_REQD');
252: FND_MSG_PUB.ADD;
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;
255:

Line 259: FND_MESSAGE.SET_NAME('GMD', 'GMD_MIN_MAX_REQ');

255:
256: IF p_test_type = 'L' THEN -- numeric range with label.
257: IF x_qc_test_values_rec.min_num IS NULL AND x_qc_test_values_rec.max_num IS NULL
258: THEN
259: FND_MESSAGE.SET_NAME('GMD', 'GMD_MIN_MAX_REQ');
260: FND_MSG_PUB.ADD;
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263:

Line 265: FND_MESSAGE.SET_NAME('GMD', 'GMD_DISPLAY_LABEL_REQ');

261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263:
264: IF LTRIM(RTRIM(x_qc_test_values_rec.display_label_numeric_range)) IS NULL THEN
265: FND_MESSAGE.SET_NAME('GMD', 'GMD_DISPLAY_LABEL_REQ');
266: FND_MSG_PUB.ADD;
267: RAISE FND_API.G_EXC_ERROR;
268: END IF;
269:

Line 271: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_VALUE_CHAR_NOT_REQD');

267: RAISE FND_API.G_EXC_ERROR;
268: END IF;
269:
270: IF x_qc_test_values_rec.value_char IS NOT NULL THEN
271: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_VALUE_CHAR_NOT_REQD');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275:

Line 277: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_VALUE_DESC_NOT_REQD');

273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275:
276: IF x_qc_test_values_rec.test_value_desc IS NOT NULL THEN
277: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_VALUE_DESC_NOT_REQD');
278: FND_MSG_PUB.ADD;
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:

Line 288: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_MIN_MAX_ERROR');

284:
285: IF x_qc_test_values_rec.min_num IS NOT NULL AND x_qc_test_values_rec.max_num IS NOT NULL
286: THEN
287: IF x_qc_test_values_rec.min_num > x_qc_test_values_rec.max_num THEN
288: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_MIN_MAX_ERROR');
289: FND_MSG_PUB.ADD;
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292: END IF;

Line 295: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_RANGE_NOT_REQD');

291: END IF;
292: END IF;
293: ELSE
294: IF x_qc_test_values_rec.min_num IS NOT NULL OR x_qc_test_values_rec.max_num IS NOT NULL THEN
295: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_RANGE_NOT_REQD');
296: FND_MSG_PUB.ADD;
297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299:

Line 301: FND_MESSAGE.SET_NAME('GMD', 'GMD_DISPLAY_LABEL_NOT_REQD');

297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299:
300: IF x_qc_test_values_rec.display_label_numeric_range IS NOT NULL THEN
301: FND_MESSAGE.SET_NAME('GMD', 'GMD_DISPLAY_LABEL_NOT_REQD');
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305: END IF;

Line 309: FND_MESSAGE.SET_NAME('GMD', 'GMD_VALUE_CHAR_REQ');

305: END IF;
306:
307: IF p_test_type = 'V' THEN -- List Of Values
308: IF LTRIM(RTRIM(x_qc_test_values_rec.value_char)) IS NULL THEN
309: FND_MESSAGE.SET_NAME('GMD', 'GMD_VALUE_CHAR_REQ');
310: FND_MSG_PUB.ADD;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313:

Line 315: FND_MESSAGE.SET_NAME('GMD', 'GMD_TEST_VALUE_DESC_REQ');

311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313:
314: IF LTRIM(RTRIM(x_qc_test_values_rec.test_value_desc)) IS NULL THEN
315: FND_MESSAGE.SET_NAME('GMD', 'GMD_TEST_VALUE_DESC_REQ');
316: FND_MSG_PUB.ADD;
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319: END IF;

Line 323: FND_MESSAGE.SET_NAME('GMD', 'GMD_VALUE_CHAR_REQ');

319: END IF;
320:
321: IF p_test_type = 'T' THEN -- Text Range
322: IF LTRIM(RTRIM(x_qc_test_values_rec.value_char)) IS NULL THEN
323: FND_MESSAGE.SET_NAME('GMD', 'GMD_VALUE_CHAR_REQ');
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326: END IF;
327:

Line 329: FND_MESSAGE.SET_NAME('GMD', 'GMD_TEST_VALUE_DESC_REQ');

325: RAISE FND_API.G_EXC_ERROR;
326: END IF;
327:
328: IF LTRIM(RTRIM(x_qc_test_values_rec.test_value_desc)) IS NULL THEN
329: FND_MESSAGE.SET_NAME('GMD', 'GMD_TEST_VALUE_DESC_REQ');
330: FND_MSG_PUB.ADD;
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
333:

Line 341: FND_MESSAGE.SET_NAME('GMD', 'GMD_SEQ_NOT_REQD');

337:
338: ELSE
339:
340: IF x_qc_test_values_rec.text_range_seq IS NOT NULL THEN
341: FND_MESSAGE.SET_NAME('GMD', 'GMD_SEQ_NOT_REQD');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;
345: END IF;

Line 353: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

349: x_return_status := FND_API.G_RET_STS_ERROR ;
350: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
351:
352: WHEN OTHERS THEN
353: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
354: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_FOR_NULL_AND_FKS');
355: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
356: FND_MESSAGE.Set_Token('POSITION',l_progress );
357: FND_MSG_PUB.ADD;

Line 354: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_FOR_NULL_AND_FKS');

350: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
351:
352: WHEN OTHERS THEN
353: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
354: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_FOR_NULL_AND_FKS');
355: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
356: FND_MESSAGE.Set_Token('POSITION',l_progress );
357: FND_MSG_PUB.ADD;
358: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 355: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

351:
352: WHEN OTHERS THEN
353: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
354: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_FOR_NULL_AND_FKS');
355: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
356: FND_MESSAGE.Set_Token('POSITION',l_progress );
357: FND_MSG_PUB.ADD;
358: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 356: FND_MESSAGE.Set_Token('POSITION',l_progress );

352: WHEN OTHERS THEN
353: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
354: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.CHECK_FOR_NULL_AND_FKS');
355: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
356: FND_MESSAGE.Set_Token('POSITION',l_progress );
357: FND_MSG_PUB.ADD;
358: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360:

Line 396: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_ID_REQ');

392:
393: x_return_status := FND_API.G_RET_STS_SUCCESS ;
394:
395: IF p_qc_test_values_rec.test_id IS NULL THEN
396: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_ID_REQ');
397: FND_MSG_PUB.ADD;
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:

Line 412: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_VALUE_REC_NOT_REQ');

408: RETURN;
409: END IF;
410:
411: IF l_test_type IN ('N','E','U') THEN
412: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_VALUE_REC_NOT_REQ');
413: FND_MSG_PUB.ADD;
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:

Line 435: FND_MESSAGE.SET_NAME('GMD','GMD_DUP_TEST_VALUE');

431: OPEN cr_test_value_exist;
432: FETCH cr_test_value_exist INTO l_temp;
433: IF cr_test_value_exist%FOUND THEN
434: CLOSE cr_test_value_exist;
435: FND_MESSAGE.SET_NAME('GMD','GMD_DUP_TEST_VALUE');
436: FND_MESSAGE.SET_TOKEN('TEST',to_char(x_qc_test_values_rec.test_id));
437: FND_MSG_PUB.ADD;
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;

Line 436: FND_MESSAGE.SET_TOKEN('TEST',to_char(x_qc_test_values_rec.test_id));

432: FETCH cr_test_value_exist INTO l_temp;
433: IF cr_test_value_exist%FOUND THEN
434: CLOSE cr_test_value_exist;
435: FND_MESSAGE.SET_NAME('GMD','GMD_DUP_TEST_VALUE');
436: FND_MESSAGE.SET_TOKEN('TEST',to_char(x_qc_test_values_rec.test_id));
437: FND_MSG_PUB.ADD;
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440: CLOSE cr_test_value_exist;

Line 449: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

445: x_return_status := FND_API.G_RET_STS_ERROR ;
446: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
447:
448: WHEN OTHERS THEN
449: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
450: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_INSERT');
451: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
452: FND_MESSAGE.Set_Token('POSITION',l_progress );
453: FND_MSG_PUB.ADD;

Line 450: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_INSERT');

446: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
447:
448: WHEN OTHERS THEN
449: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
450: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_INSERT');
451: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
452: FND_MESSAGE.Set_Token('POSITION',l_progress );
453: FND_MSG_PUB.ADD;
454: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 451: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

447:
448: WHEN OTHERS THEN
449: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
450: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_INSERT');
451: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
452: FND_MESSAGE.Set_Token('POSITION',l_progress );
453: FND_MSG_PUB.ADD;
454: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 452: FND_MESSAGE.Set_Token('POSITION',l_progress );

448: WHEN OTHERS THEN
449: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
450: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_INSERT');
451: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
452: FND_MESSAGE.Set_Token('POSITION',l_progress );
453: FND_MSG_PUB.ADD;
454: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456:

Line 490: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_ID_CODE_NULL');

486: x_gmd_qc_tests_rec := p_gmd_qc_tests_rec;
487:
488:
489: IF x_gmd_qc_tests_rec.test_id IS NULL THEN
490: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_ID_CODE_NULL');
491: FND_MSG_PUB.ADD;
492: RAISE FND_API.G_EXC_ERROR;
493: END IF;
494:

Line 502: FND_MESSAGE.SET_NAME('GMD','GMD_NO_TEST_VALUES');

498: FROM GMD_QC_TEST_VALUES_B
499: WHERE test_id = x_gmd_qc_tests_rec.test_id ;
500:
501: IF l_test_values_count = 0 THEN
502: FND_MESSAGE.SET_NAME('GMD','GMD_NO_TEST_VALUES');
503: FND_MESSAGE.SET_TOKEN('TEST',x_gmd_qc_tests_rec.test_code);
504: FND_MSG_PUB.ADD;
505: RAISE FND_API.G_EXC_ERROR;
506: END IF;

Line 503: FND_MESSAGE.SET_TOKEN('TEST',x_gmd_qc_tests_rec.test_code);

499: WHERE test_id = x_gmd_qc_tests_rec.test_id ;
500:
501: IF l_test_values_count = 0 THEN
502: FND_MESSAGE.SET_NAME('GMD','GMD_NO_TEST_VALUES');
503: FND_MESSAGE.SET_TOKEN('TEST',x_gmd_qc_tests_rec.test_code);
504: FND_MSG_PUB.ADD;
505: RAISE FND_API.G_EXC_ERROR;
506: END IF;
507: END IF;

Line 581: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

577: x_return_status := FND_API.G_RET_STS_ERROR ;
578: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
579:
580: WHEN OTHERS THEN
581: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
582: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_INSERT_ALL');
583: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
584: FND_MESSAGE.Set_Token('POSITION',l_progress );
585: FND_MSG_PUB.ADD;

Line 582: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_INSERT_ALL');

578: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
579:
580: WHEN OTHERS THEN
581: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
582: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_INSERT_ALL');
583: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
584: FND_MESSAGE.Set_Token('POSITION',l_progress );
585: FND_MSG_PUB.ADD;
586: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 583: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

579:
580: WHEN OTHERS THEN
581: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
582: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_INSERT_ALL');
583: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
584: FND_MESSAGE.Set_Token('POSITION',l_progress );
585: FND_MSG_PUB.ADD;
586: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 584: FND_MESSAGE.Set_Token('POSITION',l_progress );

580: WHEN OTHERS THEN
581: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
582: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_INSERT_ALL');
583: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
584: FND_MESSAGE.Set_Token('POSITION',l_progress );
585: FND_MSG_PUB.ADD;
586: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588:

Line 622: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_VALUE_ID_REQ');

618: l_progress := '010';
619: x_return_status := FND_API.G_RET_STS_SUCCESS ;
620:
621: IF p_test_value_id IS NULL THEN
622: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_VALUE_ID_REQ');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626:

Line 631: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_VALUE_INVALID');

627: OPEN cr_get_test_id;
628: FETCH cr_get_test_id INTO l_test_id;
629: IF cr_get_test_id%NOTFOUND THEN
630: CLOSE cr_get_test_id;
631: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_VALUE_INVALID');
632: FND_MESSAGE.SET_TOKEN('TEST_VALUE',to_char(p_test_value_id));
633: FND_MSG_PUB.ADD;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;

Line 632: FND_MESSAGE.SET_TOKEN('TEST_VALUE',to_char(p_test_value_id));

628: FETCH cr_get_test_id INTO l_test_id;
629: IF cr_get_test_id%NOTFOUND THEN
630: CLOSE cr_get_test_id;
631: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_VALUE_INVALID');
632: FND_MESSAGE.SET_TOKEN('TEST_VALUE',to_char(p_test_value_id));
633: FND_MSG_PUB.ADD;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636: CLOSE cr_get_test_id;

Line 654: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

650: x_return_status := FND_API.G_RET_STS_ERROR ;
651: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
652:
653: WHEN OTHERS THEN
654: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
655: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_DELETE');
656: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
657: FND_MESSAGE.Set_Token('POSITION',l_progress );
658: FND_MSG_PUB.ADD;

Line 655: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_DELETE');

651: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
652:
653: WHEN OTHERS THEN
654: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
655: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_DELETE');
656: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
657: FND_MESSAGE.Set_Token('POSITION',l_progress );
658: FND_MSG_PUB.ADD;
659: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 656: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

652:
653: WHEN OTHERS THEN
654: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
655: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_DELETE');
656: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
657: FND_MESSAGE.Set_Token('POSITION',l_progress );
658: FND_MSG_PUB.ADD;
659: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 657: FND_MESSAGE.Set_Token('POSITION',l_progress );

653: WHEN OTHERS THEN
654: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
655: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_DELETE');
656: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
657: FND_MESSAGE.Set_Token('POSITION',l_progress );
658: FND_MSG_PUB.ADD;
659: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661:

Line 690: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

686: x_return_status := FND_API.G_RET_STS_ERROR ;
687: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
688:
689: WHEN OTHERS THEN
690: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
691: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_DELETE_ALL');
692: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
693: FND_MESSAGE.Set_Token('POSITION',l_progress );
694: FND_MSG_PUB.ADD;

Line 691: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_DELETE_ALL');

687: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
688:
689: WHEN OTHERS THEN
690: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
691: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_DELETE_ALL');
692: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
693: FND_MESSAGE.Set_Token('POSITION',l_progress );
694: FND_MSG_PUB.ADD;
695: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 692: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

688:
689: WHEN OTHERS THEN
690: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
691: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_DELETE_ALL');
692: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
693: FND_MESSAGE.Set_Token('POSITION',l_progress );
694: FND_MSG_PUB.ADD;
695: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 693: FND_MESSAGE.Set_Token('POSITION',l_progress );

689: WHEN OTHERS THEN
690: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
691: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_DELETE_ALL');
692: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
693: FND_MESSAGE.Set_Token('POSITION',l_progress );
694: FND_MSG_PUB.ADD;
695: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697:

Line 715: FND_MESSAGE.Set_Name('GMD','GMD_TEXT_RANGE_SEQ_INVALID');

711:
712: RETURN (l_seq);
713:
714: EXCEPTION WHEN OTHERS THEN
715: FND_MESSAGE.Set_Name('GMD','GMD_TEXT_RANGE_SEQ_INVALID');
716: FND_MESSAGE.Set_Token('TEST',to_char(p_test_id));
717: FND_MESSAGE.Set_Token('VALUE',p_value_char);
718: FND_MSG_PUB.ADD;
719: RETURN(-1);

Line 716: FND_MESSAGE.Set_Token('TEST',to_char(p_test_id));

712: RETURN (l_seq);
713:
714: EXCEPTION WHEN OTHERS THEN
715: FND_MESSAGE.Set_Name('GMD','GMD_TEXT_RANGE_SEQ_INVALID');
716: FND_MESSAGE.Set_Token('TEST',to_char(p_test_id));
717: FND_MESSAGE.Set_Token('VALUE',p_value_char);
718: FND_MSG_PUB.ADD;
719: RETURN(-1);
720: END text_range_char_to_seq;

Line 717: FND_MESSAGE.Set_Token('VALUE',p_value_char);

713:
714: EXCEPTION WHEN OTHERS THEN
715: FND_MESSAGE.Set_Name('GMD','GMD_TEXT_RANGE_SEQ_INVALID');
716: FND_MESSAGE.Set_Token('TEST',to_char(p_test_id));
717: FND_MESSAGE.Set_Token('VALUE',p_value_char);
718: FND_MSG_PUB.ADD;
719: RETURN(-1);
720: END text_range_char_to_seq;
721: