DBA Data[Home] [Help]

APPS.CN_PLANCOPY_UTIL_PVT dependencies on FND_MSG_PUB

Line 84: FND_MSG_PUB.Count_And_Get

80: end if;
81: -- ******* End of API body. ********
82:
83: -- Standard call to get message count and if count is 1, get message info.
84: FND_MSG_PUB.Count_And_Get
85: (p_count => x_msg_count ,
86: p_data => x_msg_data ,
87: p_encoded => FND_API.G_FALSE );
88: EXCEPTION

Line 92: FND_MSG_PUB.count_and_get

88: EXCEPTION
89: WHEN FND_API.G_EXC_ERROR THEN
90: ROLLBACK TO get_unique_name_for_component;
91: x_return_status := FND_API.G_RET_STS_ERROR ;
92: FND_MSG_PUB.count_and_get
93: (p_count => x_msg_count ,
94: p_data => x_msg_data ,
95: p_encoded => FND_API.G_FALSE );
96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 99: FND_MSG_PUB.count_and_get

95: p_encoded => FND_API.G_FALSE );
96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
97: ROLLBACK TO get_unique_name_for_component;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: FND_MSG_PUB.count_and_get
100: (p_count => x_msg_count ,
101: p_data => x_msg_data ,
102: p_encoded => FND_API.G_FALSE );
103: WHEN OTHERS THEN

Line 106: IF FND_MSG_PUB.check_msg_level

102: p_encoded => FND_API.G_FALSE );
103: WHEN OTHERS THEN
104: ROLLBACK TO get_unique_name_for_component;
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
106: IF FND_MSG_PUB.check_msg_level
107: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
108: THEN
109: FND_MSG_PUB.add_exc_msg
110: (G_PKG_NAME ,

Line 107: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

103: WHEN OTHERS THEN
104: ROLLBACK TO get_unique_name_for_component;
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
106: IF FND_MSG_PUB.check_msg_level
107: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
108: THEN
109: FND_MSG_PUB.add_exc_msg
110: (G_PKG_NAME ,
111: l_api_name );

Line 109: FND_MSG_PUB.add_exc_msg

105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
106: IF FND_MSG_PUB.check_msg_level
107: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
108: THEN
109: FND_MSG_PUB.add_exc_msg
110: (G_PKG_NAME ,
111: l_api_name );
112: END IF;
113: FND_MSG_PUB.count_and_get

Line 113: FND_MSG_PUB.count_and_get

109: FND_MSG_PUB.add_exc_msg
110: (G_PKG_NAME ,
111: l_api_name );
112: END IF;
113: FND_MSG_PUB.count_and_get
114: (p_count => x_msg_count ,
115: p_data => x_msg_data ,
116: p_encoded => FND_API.G_FALSE );
117: END get_unique_name_for_component;

Line 182: FND_MSG_PUB.initialize;

178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: END IF;
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean( p_init_msg_list ) THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Initialize API return status to success
186: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 206: FND_MSG_PUB.Count_And_Get

202: COMMIT WORK;
203: END IF;
204:
205: -- Standard call to get message count and if count is 1, get message info.
206: FND_MSG_PUB.Count_And_Get
207: (p_count => x_msg_count ,
208: p_data => x_msg_data ,
209: p_encoded => FND_API.G_FALSE );
210:

Line 215: FND_MSG_PUB.count_and_get

211: EXCEPTION
212: WHEN FND_API.G_EXC_ERROR THEN
213: ROLLBACK TO convert_blob_to_clob;
214: x_return_status := FND_API.G_RET_STS_ERROR ;
215: FND_MSG_PUB.count_and_get
216: (p_count => x_msg_count ,
217: p_data => x_msg_data ,
218: p_encoded => FND_API.G_FALSE );
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 222: FND_MSG_PUB.count_and_get

218: p_encoded => FND_API.G_FALSE );
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO convert_blob_to_clob;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
222: FND_MSG_PUB.count_and_get
223: (p_count => x_msg_count ,
224: p_data => x_msg_data ,
225: p_encoded => FND_API.G_FALSE );
226: WHEN OTHERS THEN

Line 229: IF FND_MSG_PUB.check_msg_level

225: p_encoded => FND_API.G_FALSE );
226: WHEN OTHERS THEN
227: ROLLBACK TO convert_blob_to_clob;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: IF FND_MSG_PUB.check_msg_level
230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.add_exc_msg
233: (G_PKG_NAME ,

Line 230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

226: WHEN OTHERS THEN
227: ROLLBACK TO convert_blob_to_clob;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: IF FND_MSG_PUB.check_msg_level
230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.add_exc_msg
233: (G_PKG_NAME ,
234: l_api_name );

Line 232: FND_MSG_PUB.add_exc_msg

228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: IF FND_MSG_PUB.check_msg_level
230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.add_exc_msg
233: (G_PKG_NAME ,
234: l_api_name );
235: END IF;
236: FND_MSG_PUB.count_and_get

Line 236: FND_MSG_PUB.count_and_get

232: FND_MSG_PUB.add_exc_msg
233: (G_PKG_NAME ,
234: l_api_name );
235: END IF;
236: FND_MSG_PUB.count_and_get
237: (p_count => x_msg_count ,
238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE );
240: END convert_blob_to_clob;

Line 276: FND_MSG_PUB.initialize;

272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: -- Initialize message list if p_init_msg_list is set to TRUE.
275: IF FND_API.to_Boolean( p_init_msg_list ) THEN
276: FND_MSG_PUB.initialize;
277: END IF;
278:
279: -- Initialize API return status to success
280: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 299: FND_MSG_PUB.Count_And_Get

295: COMMIT WORK;
296: END IF;
297:
298: -- Standard call to get message count and if count is 1, get message info.
299: FND_MSG_PUB.Count_And_Get
300: (p_count => x_msg_count ,
301: p_data => x_msg_data ,
302: p_encoded => FND_API.G_FALSE );
303:

Line 308: FND_MSG_PUB.count_and_get

304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: ROLLBACK TO convert_clob_to_xmltype;
307: x_return_status := FND_API.G_RET_STS_ERROR ;
308: FND_MSG_PUB.count_and_get
309: (p_count => x_msg_count ,
310: p_data => x_msg_data ,
311: p_encoded => FND_API.G_FALSE );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 315: FND_MSG_PUB.count_and_get

311: p_encoded => FND_API.G_FALSE );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: ROLLBACK TO convert_clob_to_xmltype;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315: FND_MSG_PUB.count_and_get
316: (p_count => x_msg_count ,
317: p_data => x_msg_data ,
318: p_encoded => FND_API.G_FALSE );
319: WHEN OTHERS THEN

Line 322: IF FND_MSG_PUB.check_msg_level

318: p_encoded => FND_API.G_FALSE );
319: WHEN OTHERS THEN
320: ROLLBACK TO convert_clob_to_xmltype;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: IF FND_MSG_PUB.check_msg_level
323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.add_exc_msg
326: (G_PKG_NAME ,

Line 323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

319: WHEN OTHERS THEN
320: ROLLBACK TO convert_clob_to_xmltype;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: IF FND_MSG_PUB.check_msg_level
323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.add_exc_msg
326: (G_PKG_NAME ,
327: l_api_name );

Line 325: FND_MSG_PUB.add_exc_msg

321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: IF FND_MSG_PUB.check_msg_level
323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.add_exc_msg
326: (G_PKG_NAME ,
327: l_api_name );
328: END IF;
329: FND_MSG_PUB.count_and_get

Line 329: FND_MSG_PUB.count_and_get

325: FND_MSG_PUB.add_exc_msg
326: (G_PKG_NAME ,
327: l_api_name );
328: END IF;
329: FND_MSG_PUB.count_and_get
330: (p_count => x_msg_count ,
331: p_data => x_msg_data ,
332: p_encoded => FND_API.G_FALSE );
333: END convert_clob_to_xmltype;

Line 369: FND_MSG_PUB.initialize;

365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;
367: -- Initialize message list if p_init_msg_list is set to TRUE.
368: IF FND_API.to_Boolean( p_init_msg_list ) THEN
369: FND_MSG_PUB.initialize;
370: END IF;
371:
372:
373: -- Initialize API return status to success

Line 420: FND_MSG_PUB.Count_And_Get

416: COMMIT WORK;
417: END IF;
418:
419: -- Standard call to get message count and if count is 1, get message info.
420: FND_MSG_PUB.Count_And_Get
421: (p_count => x_msg_count ,
422: p_data => x_msg_data ,
423: p_encoded => FND_API.G_FALSE );
424:

Line 429: FND_MSG_PUB.count_and_get

425: EXCEPTION
426: WHEN FND_API.G_EXC_ERROR THEN
427: ROLLBACK TO convert_blob_to_xmltype;
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: FND_MSG_PUB.count_and_get
430: (p_count => x_msg_count ,
431: p_data => x_msg_data ,
432: p_encoded => FND_API.G_FALSE );
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 436: FND_MSG_PUB.count_and_get

432: p_encoded => FND_API.G_FALSE );
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: ROLLBACK TO convert_blob_to_xmltype;
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
436: FND_MSG_PUB.count_and_get
437: (p_count => x_msg_count ,
438: p_data => x_msg_data ,
439: p_encoded => FND_API.G_FALSE );
440: WHEN OTHERS THEN

Line 443: IF FND_MSG_PUB.check_msg_level

439: p_encoded => FND_API.G_FALSE );
440: WHEN OTHERS THEN
441: ROLLBACK TO convert_blob_to_xmltype;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
443: IF FND_MSG_PUB.check_msg_level
444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
445: THEN
446: FND_MSG_PUB.add_exc_msg
447: (G_PKG_NAME ,

Line 444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

440: WHEN OTHERS THEN
441: ROLLBACK TO convert_blob_to_xmltype;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
443: IF FND_MSG_PUB.check_msg_level
444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
445: THEN
446: FND_MSG_PUB.add_exc_msg
447: (G_PKG_NAME ,
448: l_api_name );

Line 446: FND_MSG_PUB.add_exc_msg

442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
443: IF FND_MSG_PUB.check_msg_level
444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
445: THEN
446: FND_MSG_PUB.add_exc_msg
447: (G_PKG_NAME ,
448: l_api_name );
449: END IF;
450: FND_MSG_PUB.count_and_get

Line 450: FND_MSG_PUB.count_and_get

446: FND_MSG_PUB.add_exc_msg
447: (G_PKG_NAME ,
448: l_api_name );
449: END IF;
450: FND_MSG_PUB.count_and_get
451: (p_count => x_msg_count ,
452: p_data => x_msg_data ,
453: p_encoded => FND_API.G_FALSE );
454: END convert_blob_to_xmltype;