DBA Data[Home] [Help]

APPS.CN_REASONS_PUB dependencies on FND_MSG_PUB

Line 109: FND_MSG_PUB.initialize;

105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106: END IF;
107: -- Initialize message list if p_init_msg_list is set to TRUE.
108: IF FND_API.to_Boolean( p_init_msg_list ) THEN
109: FND_MSG_PUB.initialize;
110: END IF;
111: -- Initialize API return status to success
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113: x_loading_status := 'CN_INSERTED';

Line 166: FND_MSG_PUB.Count_And_Get(

162: EXCEPTION
163: WHEN FND_API.G_EXC_ERROR THEN
164: ROLLBACK TO show_analyst_notes;
165: x_return_status := FND_API.G_RET_STS_ERROR ;
166: FND_MSG_PUB.Count_And_Get(
167: p_count => x_msg_count ,
168: p_data => x_msg_data ,
169: p_encoded => FND_API.G_FALSE);
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 174: FND_MSG_PUB.Count_And_Get(

170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO show_analyst_notes;
172: x_loading_status := 'UNEXPECTED_ERR';
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: FND_MSG_PUB.Count_And_Get(
175: p_count => x_msg_count ,
176: p_data => x_msg_data ,
177: p_encoded => FND_API.G_FALSE);
178: WHEN OTHERS THEN

Line 182: IF FND_MSG_PUB.Check_Msg_Level(

178: WHEN OTHERS THEN
179: ROLLBACK TO show_analyst_notes;
180: x_loading_status := 'UNEXPECTED_ERR';
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
182: IF FND_MSG_PUB.Check_Msg_Level(
183: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
185: END IF;
186: FND_MSG_PUB.Count_And_Get(

Line 183: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

179: ROLLBACK TO show_analyst_notes;
180: x_loading_status := 'UNEXPECTED_ERR';
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
182: IF FND_MSG_PUB.Check_Msg_Level(
183: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
185: END IF;
186: FND_MSG_PUB.Count_And_Get(
187: p_count => x_msg_count ,

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

180: x_loading_status := 'UNEXPECTED_ERR';
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
182: IF FND_MSG_PUB.Check_Msg_Level(
183: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
185: END IF;
186: FND_MSG_PUB.Count_And_Get(
187: p_count => x_msg_count ,
188: p_data => x_msg_data ,

Line 186: FND_MSG_PUB.Count_And_Get(

182: IF FND_MSG_PUB.Check_Msg_Level(
183: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
185: END IF;
186: FND_MSG_PUB.Count_And_Get(
187: p_count => x_msg_count ,
188: p_data => x_msg_data ,
189: p_encoded => FND_API.G_FALSE);
190: END;

Line 219: FND_MSG_PUB.initialize;

215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF FND_API.to_Boolean( p_init_msg_list ) THEN
219: FND_MSG_PUB.initialize;
220: END IF;
221: -- Initialize API return status to success
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223: x_loading_status := 'CN_INSERTED';

Line 294: FND_MSG_PUB.Count_And_Get(

290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
292: ROLLBACK TO manage_analyst_notes;
293: x_return_status := FND_API.G_RET_STS_ERROR ;
294: FND_MSG_PUB.Count_And_Get(
295: p_count => x_msg_count ,
296: p_data => x_msg_data ,
297: p_encoded => FND_API.G_FALSE);
298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 302: FND_MSG_PUB.Count_And_Get(

298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
299: ROLLBACK TO manage_analyst_notes;
300: x_loading_status := 'UNEXPECTED_ERR';
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: FND_MSG_PUB.Count_And_Get(
303: p_count => x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE);
306: WHEN OTHERS THEN

Line 310: IF FND_MSG_PUB.Check_Msg_Level(

306: WHEN OTHERS THEN
307: ROLLBACK TO manage_analyst_notes;
308: x_loading_status := 'UNEXPECTED_ERR';
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: IF FND_MSG_PUB.Check_Msg_Level(
311: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
313: END IF;
314: FND_MSG_PUB.Count_And_Get(

Line 311: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

307: ROLLBACK TO manage_analyst_notes;
308: x_loading_status := 'UNEXPECTED_ERR';
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: IF FND_MSG_PUB.Check_Msg_Level(
311: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
313: END IF;
314: FND_MSG_PUB.Count_And_Get(
315: p_count => x_msg_count ,

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

308: x_loading_status := 'UNEXPECTED_ERR';
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: IF FND_MSG_PUB.Check_Msg_Level(
311: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
313: END IF;
314: FND_MSG_PUB.Count_And_Get(
315: p_count => x_msg_count ,
316: p_data => x_msg_data ,

Line 314: FND_MSG_PUB.Count_And_Get(

310: IF FND_MSG_PUB.Check_Msg_Level(
311: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
313: END IF;
314: FND_MSG_PUB.Count_And_Get(
315: p_count => x_msg_count ,
316: p_data => x_msg_data ,
317: p_encoded => FND_API.G_FALSE);
318: END;

Line 348: FND_MSG_PUB.initialize;

344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list ) THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350: -- Initialize API return status to success
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352: x_loading_status := 'CN_INSERTED';

Line 373: FND_MSG_PUB.Count_And_Get(

369: EXCEPTION
370: WHEN FND_API.G_EXC_ERROR THEN
371: ROLLBACK TO remove_analyst_notes;
372: x_return_status := FND_API.G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get(
374: p_count => x_msg_count ,
375: p_data => x_msg_data ,
376: p_encoded => FND_API.G_FALSE);
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 381: FND_MSG_PUB.Count_And_Get(

377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: ROLLBACK TO remove_analyst_notes;
379: x_loading_status := 'UNEXPECTED_ERR';
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.Count_And_Get(
382: p_count => x_msg_count ,
383: p_data => x_msg_data ,
384: p_encoded => FND_API.G_FALSE);
385: WHEN OTHERS THEN

Line 389: IF FND_MSG_PUB.Check_Msg_Level(

385: WHEN OTHERS THEN
386: ROLLBACK TO remove_analyst_notes;
387: x_loading_status := 'UNEXPECTED_ERR';
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: IF FND_MSG_PUB.Check_Msg_Level(
390: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
392: END IF;
393: FND_MSG_PUB.Count_And_Get(

Line 390: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

386: ROLLBACK TO remove_analyst_notes;
387: x_loading_status := 'UNEXPECTED_ERR';
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: IF FND_MSG_PUB.Check_Msg_Level(
390: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
392: END IF;
393: FND_MSG_PUB.Count_And_Get(
394: p_count => x_msg_count ,

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

387: x_loading_status := 'UNEXPECTED_ERR';
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: IF FND_MSG_PUB.Check_Msg_Level(
390: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
392: END IF;
393: FND_MSG_PUB.Count_And_Get(
394: p_count => x_msg_count ,
395: p_data => x_msg_data ,

Line 393: FND_MSG_PUB.Count_And_Get(

389: IF FND_MSG_PUB.Check_Msg_Level(
390: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
392: END IF;
393: FND_MSG_PUB.Count_And_Get(
394: p_count => x_msg_count ,
395: p_data => x_msg_data ,
396: p_encoded => FND_API.G_FALSE);
397: END;

Line 468: FND_MSG_PUB.initialize;

464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
465: END IF;
466: -- Initialize message list if p_init_msg_list is set to TRUE.
467: IF FND_API.to_Boolean( p_init_msg_list ) THEN
468: FND_MSG_PUB.initialize;
469: END IF;
470: -- Initialize API return status to success
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472: x_loading_status := 'CN_INSERTED';

Line 526: FND_MSG_PUB.Count_And_Get(

522: EXCEPTION
523: WHEN FND_API.G_EXC_ERROR THEN
524: ROLLBACK TO show_last_analyst_note;
525: x_return_status := FND_API.G_RET_STS_ERROR ;
526: FND_MSG_PUB.Count_And_Get(
527: p_count => x_msg_count ,
528: p_data => x_msg_data ,
529: p_encoded => FND_API.G_FALSE);
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 534: FND_MSG_PUB.Count_And_Get(

530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: ROLLBACK TO show_last_analyst_note;
532: x_loading_status := 'UNEXPECTED_ERR';
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
534: FND_MSG_PUB.Count_And_Get(
535: p_count => x_msg_count ,
536: p_data => x_msg_data ,
537: p_encoded => FND_API.G_FALSE);
538: WHEN OTHERS THEN

Line 542: IF FND_MSG_PUB.Check_Msg_Level(

538: WHEN OTHERS THEN
539: ROLLBACK TO show_last_analyst_note;
540: x_loading_status := 'UNEXPECTED_ERR';
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
542: IF FND_MSG_PUB.Check_Msg_Level(
543: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
544: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
545: END IF;
546: FND_MSG_PUB.Count_And_Get(

Line 543: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

539: ROLLBACK TO show_last_analyst_note;
540: x_loading_status := 'UNEXPECTED_ERR';
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
542: IF FND_MSG_PUB.Check_Msg_Level(
543: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
544: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
545: END IF;
546: FND_MSG_PUB.Count_And_Get(
547: p_count => x_msg_count ,

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

540: x_loading_status := 'UNEXPECTED_ERR';
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
542: IF FND_MSG_PUB.Check_Msg_Level(
543: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
544: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
545: END IF;
546: FND_MSG_PUB.Count_And_Get(
547: p_count => x_msg_count ,
548: p_data => x_msg_data ,

Line 546: FND_MSG_PUB.Count_And_Get(

542: IF FND_MSG_PUB.Check_Msg_Level(
543: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
544: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
545: END IF;
546: FND_MSG_PUB.Count_And_Get(
547: p_count => x_msg_count ,
548: p_data => x_msg_data ,
549: p_encoded => FND_API.G_FALSE);
550: