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_SPEC_GRP dependencies on GMD_SPEC_GRP

Line 1: PACKAGE BODY GMD_SPEC_GRP AS

1: PACKAGE BODY GMD_SPEC_GRP AS
2: --$Header: GMDGSPCB.pls 120.3 2006/05/31 14:50:07 ragsriva noship $ */
3:
4: -- Global variables
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_Spec_GRP';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_Spec_GRP';

1: PACKAGE BODY GMD_SPEC_GRP AS
2: --$Header: GMDGSPCB.pls 120.3 2006/05/31 14:50:07 ragsriva noship $ */
3:
4: -- Global variables
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_Spec_GRP';
6: --Bug 3222090, magupta removed call to FND_PROFILE.VALUE('AFLOG_ENABLED')
7: --forward decl.
8: function set_debug_flag return varchar2;
9: --l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 27: --| Package Name : GMD_Spec_GRP |

23: --| Redwood Shores, CA, USA |
24: --| All rights reserved. |
25: --+==========================================================================+
26: --| File Name : GMDGSPCB.pls |
27: --| Package Name : GMD_Spec_GRP |
28: --| Type : Group |
29: --| |
30: --| Notes |
31: --| This package contains group layer APIs for Specification Entity |

Line 320: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.check_for_null_and_fks_in_spec',

316: x_return_status := FND_API.G_RET_STS_ERROR ;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: WHEN OTHERS THEN
320: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.check_for_null_and_fks_in_spec',
321: 'ERROR',substr(sqlerrm,1,100),'POSITION','010');
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323:
324: END check_for_null_and_fks_in_spec;

Line 738: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.check_for_null_and_fks_in_stst',

734: x_return_status := FND_API.G_RET_STS_ERROR ;
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
737: WHEN OTHERS THEN
738: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.check_for_null_and_fks_in_stst',
739: 'ERROR',substr(sqlerrm,1,100),'POSITION','010');
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741:
742: END check_for_null_and_fks_in_stst;

Line 790: GMD_Spec_GRP.check_for_null_and_fks_in_spec

786: x_return_status := FND_API.G_RET_STS_SUCCESS;
787:
788: IF (p_called_from = 'API') THEN
789: -- Check for NULLs and Valid Foreign Keys in the input parameter
790: GMD_Spec_GRP.check_for_null_and_fks_in_spec
791: (
792: p_spec_header => p_spec_header
793: , x_item_number => l_item_number
794: , x_owner => l_owner

Line 839: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_spec_header',

835: x_return_status := FND_API.G_RET_STS_ERROR ;
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
838: WHEN OTHERS THEN
839: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_spec_header',
840: 'ERROR',substr(sqlerrm,1,100),'POSITION','010');
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
842:
843:

Line 1094: GMD_Spec_GRP.check_for_null_and_fks_in_stst

1090: -- Check for NULLs and Valid Foreign Keys in the input parameter
1091: -- No need if called from FORM since it is already
1092: -- done in the form
1093:
1094: GMD_Spec_GRP.check_for_null_and_fks_in_stst
1095: (
1096: p_spec_tests => p_spec_test
1097: , x_spec_tests => x_spec_test
1098: , x_return_status => l_return_status

Line 1364: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_spec_test',

1360: x_return_status := FND_API.G_RET_STS_ERROR ;
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1363: WHEN OTHERS THEN
1364: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_spec_test',
1365: 'ERROR',substr(sqlerrm,1,100),'POSITION','010');
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1367:
1368:

Line 1425: IF NOT GMD_SPEC_GRP.spec_reference_tests_exist(

1421: FETCH cr_expression_tests INTO l_test_id,l_test_seq;
1422: IF cr_expression_tests%NOTFOUND THEN
1423: EXIT;
1424: END IF;
1425: IF NOT GMD_SPEC_GRP.spec_reference_tests_exist(
1426: p_spec_id => p_spec_id,
1427: p_exp_test_seq => l_test_seq,
1428: p_exp_test_id => l_test_id ) THEN
1429: CLOSE cr_expression_tests ;

Line 1440: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_after_insert_all',

1436: WHEN FND_API.G_EXC_ERROR THEN
1437: x_return_status := FND_API.G_RET_STS_ERROR ;
1438:
1439: WHEN OTHERS THEN
1440: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_after_insert_all',
1441: 'ERROR',substr(sqlerrm,1,100),'POSITION','010');
1442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1443:
1444: END validate_after_insert_all;

Line 1522: IF NOT GMD_SPEC_GRP.Record_Updateable_With_Status(l_spec.spec_status)

1518: END IF;
1519:
1520: -- Ensure that the status permits updates
1521: -- ======================================
1522: IF NOT GMD_SPEC_GRP.Record_Updateable_With_Status(l_spec.spec_status)
1523: THEN
1524: fnd_message.set_name('GMD','GMD_SPEC_STATUS_BLOCKS_UPDATE');
1525: fnd_msg_pub.ADD;
1526: RAISE FND_API.G_EXC_ERROR;

Line 1536: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

1532: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1533:
1534: WHEN OTHERS THEN
1535: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1536: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
1537: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1538: FND_MESSAGE.Set_Token('POSITION',l_progress );
1539: FND_MSG_PUB.ADD;
1540: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 1626: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

1622: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1623:
1624: WHEN OTHERS THEN
1625: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1626: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
1627: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1628: FND_MESSAGE.Set_Token('POSITION',l_progress );
1629: FND_MSG_PUB.ADD;
1630: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 1857: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY');

1853: RETURN FALSE;
1854:
1855: EXCEPTION
1856: WHEN REQ_FIELDS_MISSING THEN
1857: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY');
1858: x_return_status := FND_API.G_RET_STS_ERROR ;
1859: RETURN FALSE;
1860: WHEN OTHERS THEN
1861: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

Line 1861: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

1857: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY');
1858: x_return_status := FND_API.G_RET_STS_ERROR ;
1859: RETURN FALSE;
1860: WHEN OTHERS THEN
1861: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1863: RETURN FALSE;
1864: END value_in_num_range_display ;
1865:

Line 1966: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_MIN_TARGET_MAX_VALID');

1962: RETURN TRUE;
1963:
1964: EXCEPTION
1965: WHEN REQ_FIELDS_MISSING THEN
1966: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_MIN_TARGET_MAX_VALID');
1967: RETURN FALSE;
1968: WHEN e_min_error THEN
1969: gmd_api_pub.log_message('GMD_SPEC_TEST_MIN_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',
1970: to_char(p_st_max),'SPEC_TEST_TARGET',to_char(p_st_target),'TEST_MIN',to_char(p_t_min),'TEST_MAX',to_char(p_t_max));

Line 1981: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_MIN_TARGET_MAX_VALID','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

1977: gmd_api_pub.log_message('GMD_SPEC_TEST_TARGET_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',
1978: to_char(p_st_max),'SPEC_TEST_TARGET',to_char(p_st_target),'TEST_MIN',to_char(p_t_min),'TEST_MAX',to_char(p_t_max));
1979: RETURN FALSE;
1980: WHEN OTHERS THEN
1981: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_MIN_TARGET_MAX_VALID','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1982: RETURN FALSE;
1983: END spec_test_min_target_max_valid;
1984:
1985:

Line 2164: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_EXP_ERROR_REGION_VAL','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

2160: RETURN TRUE;
2161:
2162: EXCEPTION
2163: WHEN OTHERS THEN
2164: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_EXP_ERROR_REGION_VAL','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
2165: RETURN FALSE;
2166: END SPEC_TEST_EXP_ERROR_REGION_VAL;
2167:
2168:

Line 2653: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.CREATE_SPECIFICATION');

2649: EXCEPTION
2650: WHEN OTHERS THEN
2651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2652: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
2653: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.CREATE_SPECIFICATION');
2654: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
2655: FND_MESSAGE.Set_Token('POSITION',l_progress );
2656: FND_MSG_PUB.ADD;
2657: END create_specification ;

Line 2805: FND_MESSAGE.SET_TOKEN('PACKAGE','GMD_SPEC_GRP.change_status');

2801:
2802: EXCEPTION
2803: WHEN OTHERS THEN
2804: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
2805: FND_MESSAGE.SET_TOKEN('PACKAGE','GMD_SPEC_GRP.change_status');
2806: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,100));
2807: x_message := FND_MESSAGE.GET;
2808: x_return_status := 'E';
2809: RETURN;

Line 2864: END GMD_SPEC_GRP;

2860: RAISE;
2861:
2862: END Get_Who;
2863:
2864: END GMD_SPEC_GRP;