[Home] [Help]
137: Validate_Attribute_Code(
138: p_api_version_number => 1.0
139: ,p_init_msg_list => FND_API.G_FALSE
140: ,p_validation_level => p_validation_level
141: ,p_validation_mode => JTF_PLSQL_API.g_create
142: ,p_attribute_code_rec => l_attribute_code_rec
143: ,x_return_status => x_return_status
144: ,x_msg_count => x_msg_count
145: ,x_msg_data => x_msg_data
495: Validate_Attribute_Code(
496: p_api_version_number => 1.0
497: ,p_init_msg_list => FND_API.G_FALSE
498: ,p_validation_level => p_validation_level
499: ,p_validation_mode => JTF_PLSQL_API.g_update
500: ,p_attribute_code_rec => p_attribute_code_rec
501: ,x_return_status => x_return_status
502: ,x_msg_count => x_msg_count
503: ,x_msg_data => x_msg_data
1031:
1032:
1033: PROCEDURE check_uk_items(
1034: p_attribute_code_rec IN attribute_code_rec_type
1035: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
1036: ,x_return_status OUT NOCOPY VARCHAR2)
1037: IS
1038: l_valid_flag VARCHAR2(1);
1039:
1044:
1045:
1046: BEGIN
1047: x_return_status := FND_API.g_ret_sts_success;
1048: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1049: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
1050: 'PV_ATTRIBUTE_CODES_B',
1051: 'ATTR_CODE_ID = ''' || p_attribute_code_rec.ATTR_CODE_ID ||''''
1052: );
1070: RETURN;
1071: END IF;
1072:
1073: --check for uniqueness of attribute_code
1074: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1075: for x in lc_get_attr_code (pc_attribute_id =>p_attribute_code_rec.attribute_id)
1076: loop
1077: if (UPPER(p_attribute_code_rec.attr_code)=UPPER(x.attr_code)) then
1078: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1093: END check_uk_items;
1094:
1095: PROCEDURE check_req_items(
1096: p_attribute_code_rec IN attribute_code_rec_type
1097: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
1098: ,x_return_status OUT NOCOPY VARCHAR2
1099: )
1100: IS
1101: BEGIN
1100: IS
1101: BEGIN
1102: x_return_status := FND_API.g_ret_sts_success;
1103:
1104: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1105:
1106: IF p_attribute_code_rec.attr_code_id = FND_API.G_MISS_NUM
1107: OR p_attribute_code_rec.attr_code_id IS NULL THEN
1108: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1506: PROCEDURE Validate_Attribute_Code(
1507: p_api_version_number IN NUMBER
1508: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1509: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1510: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
1511: ,p_attribute_code_rec IN attribute_code_rec_type
1512: ,x_return_status OUT NOCOPY VARCHAR2
1513: ,x_msg_count OUT NOCOPY NUMBER
1514: ,x_msg_data OUT NOCOPY VARCHAR2
1537: IF FND_API.to_Boolean( p_init_msg_list )
1538: THEN
1539: FND_MSG_PUB.initialize;
1540: END IF;
1541: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1542: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Check_Attr_Code_Items' );
1543: Check_Attr_Code_Items(
1544: p_attribute_code_rec => p_attribute_code_rec
1545: ,p_validation_mode => p_validation_mode
1557: p_attribute_code_rec => p_attribute_code_rec
1558: ,x_complete_rec => l_attribute_code_rec
1559: );
1560:
1561: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1562: Validate_attr_code_rec(
1563: p_api_version_number => 1.0
1564: ,p_init_msg_list => FND_API.G_FALSE
1565: ,x_return_status => x_return_status
1644: ,x_return_status OUT NOCOPY VARCHAR2
1645: ,x_msg_count OUT NOCOPY NUMBER
1646: ,x_msg_data OUT NOCOPY VARCHAR2
1647: ,p_attribute_code_rec IN attribute_code_rec_type
1648: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
1649: )
1650: IS
1651: BEGIN
1652: -- Initialize message list if p_init_msg_list is set to TRUE.