DBA Data[Home] [Help]

APPS.PV_ENTY_ATTR_VALIDATIONS_PUB dependencies on FND_MSG_PUB

Line 82: FND_MSG_PUB.initialize;

78:
79: -- Initialize message list if p_init_msg_list is set to TRUE.
80: IF FND_API.to_Boolean( p_init_msg_list )
81: THEN
82: FND_MSG_PUB.initialize;
83: END IF;
84:
85: -- Debug Message
86: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

Line 86: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

82: FND_MSG_PUB.initialize;
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:

Line 95: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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

Line 120: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

116:
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 ,

Line 157: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

153: l_tar_enty_attr_val_rec.version := l_ref_enty_attr_val_rec.version;
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

Line 181: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

177:
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:

Line 188: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

184: CLOSE c_get_Enty_Attr_Value;
185:
186:
187: if(l_count = 0) then
188: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
189: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
190: FND_MESSAGE.set_token('MODE','Update');
191: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
192: FND_MESSAGE.set_token('ID','Entity:' || p_entity || ' entity id:' || p_entity_id || ' attribute id:' || p_attribute_id);

Line 193: FND_MSG_PUB.add;

189: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
190: FND_MESSAGE.set_token('MODE','Update');
191: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
192: FND_MESSAGE.set_token('ID','Entity:' || p_entity || ' entity id:' || p_entity_id || ' attribute id:' || p_attribute_id);
193: FND_MSG_PUB.add;
194: END IF;
195: RAISE FND_API.G_EXC_ERROR;
196: end if;
197:

Line 211: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

207: COMMIT WORK;
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.

Line 216: FND_MSG_PUB.Count_And_Get (

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 (
217: p_count => x_msg_count
218: ,p_data => x_msg_data
219: );
220: EXCEPTION

Line 230: FND_MSG_PUB.Count_And_Get (

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;
229: -- Standard call to get message count and if count=1, get the message
230: FND_MSG_PUB.Count_And_Get (
231: p_encoded => FND_API.G_FALSE
232: ,p_count => x_msg_count
233: ,p_data => x_msg_data
234: );

Line 240: FND_MSG_PUB.Count_And_Get (

236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: ROLLBACK TO Update_Attr_Validations_PUB;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: -- Standard call to get message count and if count=1, get the message
240: FND_MSG_PUB.Count_And_Get (
241: p_encoded => FND_API.G_FALSE
242: ,p_count => x_msg_count
243: ,p_data => x_msg_data
244: );

Line 249: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

245:
246: WHEN OTHERS THEN
247: ROLLBACK TO Update_Attr_Validations_PUB;
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
250: THEN
251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
252: END IF;
253: -- Standard call to get message count and if count=1, get the message

Line 251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

247: ROLLBACK TO Update_Attr_Validations_PUB;
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
250: THEN
251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
252: END IF;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (
255: p_encoded => FND_API.G_FALSE

Line 254: FND_MSG_PUB.Count_And_Get (

250: THEN
251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
252: END IF;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (
255: p_encoded => FND_API.G_FALSE
256: ,p_count => x_msg_count
257: ,p_data => x_msg_data
258: );