DBA Data[Home] [Help]

APPS.GMD_QC_TESTS_GRP dependencies on GMD_QC_TESTS_GRP

Line 1: PACKAGE BODY GMD_QC_TESTS_GRP as

1: PACKAGE BODY GMD_QC_TESTS_GRP as
2: /* $Header: GMDGTSTB.pls 120.1 2006/03/22 23:07:10 rlnagara noship $*/
3:
4: /*===========================================================================
5: FUNCTION NAME: check_test_exist

Line 62: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.CHECK_TEST_EXIST' );

58:
59: EXCEPTION WHEN OTHERS
60: THEN
61: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
62: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.CHECK_TEST_EXIST' );
63: FND_MESSAGE.Set_Token('ERROR', SUBSTR(SQLERRM,1,100));
64: FND_MESSAGE.Set_Token('POSITION',l_progress );
65: FND_MSG_PUB.ADD;
66: RETURN FALSE;

Line 118: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.TEST_EXIST_IN_SPEC' );

114:
115: EXCEPTION WHEN OTHERS
116: THEN
117: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
118: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.TEST_EXIST_IN_SPEC' );
119: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
120: FND_MESSAGE.Set_Token('POSITION',l_progress );
121: FND_MSG_PUB.ADD;
122: RETURN FALSE;

Line 221: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.VALIDATE_EXPRESSION' );

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_TESTS_GRP.VALIDATE_EXPRESSION' );
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 297: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.INSERT_EXP_TEST_VALUES' );

293: x_return_status := FND_API.G_RET_STS_ERROR ;
294: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
295: WHEN OTHERS THEN
296: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
297: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.INSERT_EXP_TEST_VALUES' );
298: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
299: FND_MESSAGE.Set_Token('POSITION',l_progress );
300: FND_MSG_PUB.ADD;
301: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 437: IF gmd_qc_tests_grp.test_exist_in_spec(p_test_id => p_test_id) THEN

433:
434: l_progress := '060';
435:
436: IF p_test_id IS NOT NULL THEN
437: IF gmd_qc_tests_grp.test_exist_in_spec(p_test_id => p_test_id) THEN
438: IF p_validation_level IN ('FULL','REPORT_PRECISION') THEN
439: IF p_new_report_precision < l_old_report_precision THEN
440: FND_MESSAGE.Set_Name('GMD','GMD_NEW_PRCSN_LESS_OLD');
441: FND_MESSAGE.Set_Token('OLD_PRECISION',to_char(l_old_report_precision));

Line 464: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.DISPLAY_REPORT_PRECISION' );

460: x_return_status := FND_API.G_RET_STS_ERROR ;
461: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
462: WHEN OTHERS THEN
463: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
464: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.DISPLAY_REPORT_PRECISION' );
465: FND_MESSAGE.Set_Token('ERROR', SUBSTR(SQLERRM,1,100));
466: FND_MESSAGE.Set_Token('POSITION',l_progress );
467: FND_MSG_PUB.ADD;
468: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 511: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.MIN_MAX_VALUE_NUM');

507: x_return_status := FND_API.G_RET_STS_ERROR ;
508: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
509: WHEN OTHERS THEN
510: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
511: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.MIN_MAX_VALUE_NUM');
512: FND_MESSAGE.Set_Token('ERROR', SUBSTR(SQLERRM,1,100));
513: FND_MESSAGE.Set_Token('POSITION',l_progress );
514: FND_MSG_PUB.ADD;
515: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 589: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.validate_experimental_error');

585: x_return_status := FND_API.G_RET_STS_ERROR ;
586: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
587: WHEN OTHERS THEN
588: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
589: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.validate_experimental_error');
590: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
591: FND_MESSAGE.Set_Token('POSITION',l_progress );
592: FND_MSG_PUB.ADD;
593: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 709: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.validate_all_exp_error');

705: x_return_status := FND_API.G_RET_STS_ERROR ;
706: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
707: WHEN OTHERS THEN
708: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
709: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.validate_all_exp_error');
710: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
711: FND_MESSAGE.Set_Token('POSITION',l_progress );
712: FND_MSG_PUB.ADD;
713: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 1054: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.check_for_null_and_fks');

1050: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1051:
1052: WHEN OTHERS THEN
1053: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1054: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.check_for_null_and_fks');
1055: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1056: FND_MESSAGE.Set_Token('POSITION',l_progress );
1057: FND_MSG_PUB.ADD;
1058: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 1180: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.validate_before_insert');

1176: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1177:
1178: WHEN OTHERS THEN
1179: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1180: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.validate_before_insert');
1181: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1182: FND_MESSAGE.Set_Token('POSITION',l_progress );
1183: FND_MSG_PUB.ADD;
1184: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 1231: GMD_QC_TESTS_GRP.INSERT_EXP_TEST_VALUES(

1227: RETURN;
1228: END IF;
1229:
1230: IF l_exp_test_id_tab.COUNT > 0 THEN
1231: GMD_QC_TESTS_GRP.INSERT_EXP_TEST_VALUES(
1232: p_test_id => p_gmd_qc_tests_rec.test_id,
1233: p_test_id_tab => l_exp_test_id_tab,
1234: x_return_status => x_return_status,
1235: x_message_data => x_message_data);

Line 1250: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.process_after_insert');

1246: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1247:
1248: WHEN OTHERS THEN
1249: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1250: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.process_after_insert');
1251: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1252: FND_MESSAGE.Set_Token('POSITION',l_progress );
1253: FND_MSG_PUB.ADD;
1254: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 1299: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.test_group_order_exist' );

1295: END;
1296: EXCEPTION WHEN OTHERS
1297: THEN
1298: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1299: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.test_group_order_exist' );
1300: FND_MESSAGE.Set_Token('ERROR', SUBSTR(SQLERRM,1,100));
1301: FND_MESSAGE.Set_Token('POSITION',l_progress );
1302: FND_MSG_PUB.ADD;
1303: RETURN FALSE;

Line 1415: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.POPULATE_TEST_GRP_GT' );

1411: COMMIT;
1412: EXCEPTION
1413: WHEN OTHERS THEN
1414: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1415: FND_MESSAGE.Set_Token('PACKAGE','GMD_QC_TESTS_GRP.POPULATE_TEST_GRP_GT' );
1416: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1417: FND_MSG_PUB.ADD;
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1419: END POPULATE_TEST_GRP_GT;

Line 1443: END gmd_qc_tests_grp ;

1439: WHERE test_id = p_test_id;
1440: COMMIT;
1441: END update_test_grp;
1442:
1443: END gmd_qc_tests_grp ;