83: END IF;
84:
85: -- Debug Message
86: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
87: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - start');
88: END IF;
89:
90:
91: -- Initialize API return status to SUCCESS
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: --first call validations API, get valiodation id and update entity_attr_values API with that validation_id
95: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
96: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - calling PV_ENTY_ATTR_VALIDATIONS_PVT.Create_Enty_Attr_Validation');
97: END IF;
98: PV_ENTY_ATTR_VALIDATIONS_PVT.Create_Enty_Attr_Validation(
99: p_api_version_number => p_api_version_number
100: ,p_init_msg_list => p_init_msg_list
117:
118:
119: -- Debug Message
120: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
121: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
122: END IF;
123:
124: OPEN c_get_Enty_Attr_Value( cv_entity_id =>p_entity_id ,
125: cv_attribute_id => p_attribute_id,
154: l_tar_enty_attr_val_rec.latest_flag := l_ref_enty_attr_val_rec.latest_flag ;
155: l_tar_enty_attr_val_rec.attr_value_extn := l_ref_enty_attr_val_rec.attr_value_extn;
156:
157: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
158: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - calling PV_Enty_Attr_Value_PVT.Update_Attr_Value');
159: END IF;
160: PV_Enty_Attr_Value_PVT.Update_Attr_Value(
161: p_api_version_number => p_api_version_number
162: ,p_init_msg_list => p_init_msg_list
178: l_count := l_count +1;
179: END LOOP;
180: -- Debug Message
181: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
182: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Close Cursor');
183: END IF;
184: CLOSE c_get_Enty_Attr_Value;
185:
186:
208: END IF;
209:
210: -- Debug Message
211: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
212: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
213: END IF;
214:
215: -- Standard call to get message count and if count is 1, get message info.
216: FND_MSG_PUB.Count_And_Get (
218: ,p_data => x_msg_data
219: );
220: EXCEPTION
221: /*
222: WHEN PVX_Utility_PVT.resource_locked THEN
223: x_return_status := FND_API.g_ret_sts_error;
224: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
225: */
226: WHEN FND_API.G_EXC_ERROR THEN
220: EXCEPTION
221: /*
222: WHEN PVX_Utility_PVT.resource_locked THEN
223: x_return_status := FND_API.g_ret_sts_error;
224: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
225: */
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO Update_Attr_Validations_PUB;
228: x_return_status := FND_API.G_RET_STS_ERROR;