DBA Data[Home] [Help]

APPS.JTF_PREFAB_UD_KEY_PUB dependencies on FND_MSG_PUB

Line 53: FND_MSG_PUB.initialize;

49: END IF;
50:
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52: IF FND_API.To_Boolean( p_init_msg_list ) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: -- Initialize API return status to success
57: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 122: FND_MSG_PUB.Count_And_Get(

118: COMMIT WORK;
119: END IF;
120:
121: -- Standard call to get message count and if count is 1, get message info.
122: FND_MSG_PUB.Count_And_Get(
123: p_count => x_msg_count,
124: p_data => x_msg_data );
125:
126: EXCEPTION

Line 131: FND_MSG_PUB.Count_And_Get(

127: WHEN FND_API.G_EXC_ERROR THEN
128: ROLLBACK TO INSERT_UD_KEY;
129: x_return_status := FND_API.G_RET_STS_ERROR ;
130:
131: FND_MSG_PUB.Count_And_Get(
132: p_count => x_msg_count,
133: p_data => x_msg_data );
134:
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 139: FND_MSG_PUB.Count_And_Get(

135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
136: ROLLBACK TO INSERT_UD_KEY;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138:
139: FND_MSG_PUB.Count_And_Get(
140: p_count => x_msg_count,
141: p_data => x_msg_data );
142:
143: WHEN OTHERS THEN

Line 147: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

143: WHEN OTHERS THEN
144: ROLLBACK TO INSERT_UD_KEY;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146:
147: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
148: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
149: END IF;
150:
151: FND_MSG_PUB.Count_And_Get(

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

144: ROLLBACK TO INSERT_UD_KEY;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146:
147: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
148: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
149: END IF;
150:
151: FND_MSG_PUB.Count_And_Get(
152: p_count => x_msg_count,

Line 151: FND_MSG_PUB.Count_And_Get(

147: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
148: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
149: END IF;
150:
151: FND_MSG_PUB.Count_And_Get(
152: p_count => x_msg_count,
153: p_data => x_msg_data );
154:
155: END INSERT_UD_KEY;

Line 196: FND_MSG_PUB.initialize;

192: END IF;
193:
194: -- Initialize message list if p_init_msg_list is set to TRUE.
195: IF FND_API.To_Boolean( p_init_msg_list ) THEN
196: FND_MSG_PUB.initialize;
197: END IF;
198:
199: -- Initialize API return status to success
200: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 240: FND_MSG_PUB.Count_And_Get(

236: COMMIT WORK;
237: END IF;
238:
239: -- Standard call to get message count and if count is 1, get message info.
240: FND_MSG_PUB.Count_And_Get(
241: p_count => x_msg_count,
242: p_data => x_msg_data );
243:
244: EXCEPTION

Line 249: FND_MSG_PUB.Count_And_Get(

245: WHEN FND_API.G_EXC_ERROR THEN
246: ROLLBACK TO UPDATE_UD_KEY;
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248:
249: FND_MSG_PUB.Count_And_Get(
250: p_count => x_msg_count,
251: p_data => x_msg_data );
252:
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 257: FND_MSG_PUB.Count_And_Get(

253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: ROLLBACK TO UPDATE_UD_KEY;
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
256:
257: FND_MSG_PUB.Count_And_Get(
258: p_count => x_msg_count,
259: p_data => x_msg_data );
260:
261: WHEN OTHERS THEN

Line 265: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

261: WHEN OTHERS THEN
262: ROLLBACK TO UPDATE_UD_KEY;
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
264:
265: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
267: END IF;
268:
269: FND_MSG_PUB.Count_And_Get(

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

262: ROLLBACK TO UPDATE_UD_KEY;
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
264:
265: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
267: END IF;
268:
269: FND_MSG_PUB.Count_And_Get(
270: p_count => x_msg_count,

Line 269: FND_MSG_PUB.Count_And_Get(

265: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
267: END IF;
268:
269: FND_MSG_PUB.Count_And_Get(
270: p_count => x_msg_count,
271: p_data => x_msg_data );
272:
273: END UPDATE_UD_KEY;

Line 307: FND_MSG_PUB.initialize;

303: END IF;
304:
305: -- Initialize message list if p_init_msg_list is set to TRUE.
306: IF FND_API.To_Boolean( p_init_msg_list ) THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309:
310: -- Initialize API return status to success
311: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 332: FND_MSG_PUB.Count_And_Get(

328: COMMIT WORK;
329: END IF;
330:
331: -- Standard call to get message count and if count is 1, get message info.
332: FND_MSG_PUB.Count_And_Get(
333: p_count => x_msg_count,
334: p_data => x_msg_data );
335:
336: EXCEPTION

Line 341: FND_MSG_PUB.Count_And_Get(

337: WHEN FND_API.G_EXC_ERROR THEN
338: ROLLBACK TO DELETE_UD_KEY;
339: x_return_status := FND_API.G_RET_STS_ERROR ;
340:
341: FND_MSG_PUB.Count_And_Get(
342: p_count => x_msg_count,
343: p_data => x_msg_data );
344:
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 349: FND_MSG_PUB.Count_And_Get(

345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346: ROLLBACK TO DELETE_UD_KEY;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348:
349: FND_MSG_PUB.Count_And_Get(
350: p_count => x_msg_count,
351: p_data => x_msg_data );
352:
353: WHEN OTHERS THEN

Line 357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

353: WHEN OTHERS THEN
354: ROLLBACK TO DELETE_UD_KEY;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
356:
357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
359: END IF;
360:
361: FND_MSG_PUB.Count_And_Get(

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

354: ROLLBACK TO DELETE_UD_KEY;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
356:
357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
359: END IF;
360:
361: FND_MSG_PUB.Count_And_Get(
362: p_count => x_msg_count,

Line 361: FND_MSG_PUB.Count_And_Get(

357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
359: END IF;
360:
361: FND_MSG_PUB.Count_And_Get(
362: p_count => x_msg_count,
363: p_data => x_msg_data );
364:
365: END DELETE_UD_KEY;