[Home] [Help]
138: Validate_attribute(
139: p_api_version_number => 1.0,
140: p_init_msg_list => FND_API.G_FALSE,
141: p_validation_level => p_validation_level,
142: p_validation_mode => JTF_PLSQL_API.g_create,
143: p_attribute_rec => l_attribute_rec,
144: x_return_status => x_return_status,
145: x_msg_count => x_msg_count,
146: x_msg_data => x_msg_data);
675: Validate_attribute(
676: p_api_version_number => 1.0,
677: p_init_msg_list => FND_API.G_FALSE,
678: p_validation_level => p_validation_level,
679: p_validation_mode => JTF_PLSQL_API.g_update,
680: p_attribute_rec => p_attribute_rec,
681: x_return_status => x_return_status,
682: x_msg_count => x_msg_count,
683: x_msg_data => x_msg_data);
1334:
1335:
1336: PROCEDURE check_uk_items(
1337: p_attribute_rec IN attribute_rec_type,
1338: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1339: x_return_status OUT NOCOPY VARCHAR2)
1340: IS
1341: l_valid_flag VARCHAR2(1);
1342: l_valid_tl_flag VARCHAR2(1);
1347:
1348: BEGIN
1349:
1350: x_return_status := FND_API.g_ret_sts_success;
1351: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1352: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
1353: 'PV_ATTRIBUTES_B',
1354: 'ATTRIBUTE_ID = ''' || p_attribute_rec.ATTRIBUTE_ID ||''''
1355: );
1377: -- Added for Bug # 2480199 Begin
1378:
1379: --check for uniqueness of attribute_code
1380:
1381: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1382: for x in lc_get_attr_name
1383: loop
1384: if (UPPER(p_attribute_rec.name)=UPPER(x.name)) then
1385: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1398: END IF;
1399:
1400:
1401:
1402: /* IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1403: l_valid_tl_flag := PVX_UTILITY_PVT.check_uniqueness(
1404: 'PV_ATTRIBUTES_TL','SHORT_NAME = ''' || p_attribute_rec.SHORT_NAME
1405: ||''' AND LANGUAGE = ' || userenv('LANG') );
1406: END IF ;
1419: END check_uk_items;
1420:
1421: PROCEDURE check_req_items(
1422: p_attribute_rec IN attribute_rec_type,
1423: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1424: x_return_status OUT NOCOPY VARCHAR2
1425: )
1426: IS
1427: BEGIN
1426: IS
1427: BEGIN
1428: x_return_status := FND_API.g_ret_sts_success;
1429:
1430: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1431:
1432: IF p_attribute_rec.attribute_id = FND_API.g_miss_num OR p_attribute_rec.attribute_id IS NULL THEN
1433: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1434: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1888: PROCEDURE Validate_attribute(
1889: p_api_version_number IN NUMBER
1890: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1891: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1892: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update
1893: ,p_attribute_rec IN attribute_rec_type
1894: ,x_return_status OUT NOCOPY VARCHAR2
1895: ,x_msg_count OUT NOCOPY NUMBER
1896: ,x_msg_data OUT NOCOPY VARCHAR2
1922: IF FND_API.to_Boolean( p_init_msg_list )
1923: THEN
1924: FND_MSG_PUB.initialize;
1925: END IF;
1926: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1927:
1928: --DBMS_output.put_line('Before Check_attribute_Items');
1929:
1930: Check_attribute_Items(
1946: p_attribute_rec => p_attribute_rec,
1947: x_complete_rec => l_attribute_rec
1948: );
1949:
1950: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1951:
1952: --DBMS_output.put_line('Before Validate_attribute_Rec');
1953:
1954: Validate_attribute_Rec(
2037: ,x_return_status OUT NOCOPY VARCHAR2
2038: ,x_msg_count OUT NOCOPY NUMBER
2039: ,x_msg_data OUT NOCOPY VARCHAR2
2040: ,p_attribute_rec IN attribute_rec_type
2041: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
2042: )
2043: IS
2044: BEGIN
2045: