DBA Data[Home] [Help]

APPS.CSC_PROF_GROUP_CAT_PUB dependencies on FND_MSG_PUB

Line 158: FND_MSG_PUB.initialize;

154:
155: -- Initialize message list if p_init_msg_list is set to TRUE.
156: IF FND_API.to_Boolean( p_init_msg_list )
157: THEN
158: FND_MSG_PUB.initialize;
159: END IF;
160:
161:
162: -- Initialize API return status to SUCCESS

Line 212: FND_MSG_PUB.Count_And_Get

208:
209:
210:
211: -- Standard call to get message count and if count is 1, get message info.
212: FND_MSG_PUB.Count_And_Get
213: ( p_count => x_msg_count,
214: p_data => x_msg_data
215: );
216:

Line 221: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;
220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
222: p_data => x_msg_data) ;
223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;

Line 227: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
228: p_data => x_msg_data) ;
229:
230: WHEN OTHERS THEN
231: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;

Line 233: IF FND_MSG_PUB.Check_Msg_Level

229:
230: WHEN OTHERS THEN
231: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: IF FND_MSG_PUB.Check_Msg_Level
234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
237: END IF ;

Line 234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

230: WHEN OTHERS THEN
231: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: IF FND_MSG_PUB.Check_Msg_Level
234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
237: END IF ;
238: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: IF FND_MSG_PUB.Check_Msg_Level
234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
237: END IF ;
238: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
239: p_data => x_msg_data) ;
240:

Line 238: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
237: END IF ;
238: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
239: p_data => x_msg_data) ;
240:
241: End Create_csc_prof_group_cat;
242:

Line 326: FND_MSG_PUB.initialize;

322:
323: -- Initialize message list if p_init_msg_list is set to TRUE.
324: IF FND_API.to_Boolean( p_init_msg_list )
325: THEN
326: FND_MSG_PUB.initialize;
327: END IF;
328:
329:
330:

Line 377: FND_MSG_PUB.Count_And_Get

373:
374:
375:
376: -- Standard call to get message count and if count is 1, get message info.
377: FND_MSG_PUB.Count_And_Get
378: ( p_count => x_msg_count,
379: p_data => x_msg_data
380: );
381:

Line 386: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
387: p_data => x_msg_data) ;
388:
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 393: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
394: p_data => x_msg_data) ;
395:
396: WHEN OTHERS THEN
397: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;

Line 399: IF FND_MSG_PUB.Check_Msg_Level

395:
396: WHEN OTHERS THEN
397: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
399: IF FND_MSG_PUB.Check_Msg_Level
400: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
403: END IF ;

Line 400: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

396: WHEN OTHERS THEN
397: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
399: IF FND_MSG_PUB.Check_Msg_Level
400: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
403: END IF ;
404: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
399: IF FND_MSG_PUB.Check_Msg_Level
400: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
403: END IF ;
404: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
405: p_data => x_msg_data) ;
406:

Line 404: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

400: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
403: END IF ;
404: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
405: p_data => x_msg_data) ;
406:
407: End Update_csc_prof_group_cat;
408:

Line 443: FND_MSG_PUB.initialize;

439:
440: -- Initialize message list if p_init_msg_list is set to TRUE.
441: IF FND_API.to_Boolean( p_init_msg_list )
442: THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445:
446:
447:

Line 493: FND_MSG_PUB.Count_And_Get

489:
490:
491:
492: -- Standard call to get message count and if count is 1, get message info.
493: FND_MSG_PUB.Count_And_Get
494: ( p_count => x_msg_count,
495: p_data => x_msg_data
496: );
497:

Line 502: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
501: x_return_status := FND_API.G_RET_STS_ERROR ;
502: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
503: p_data => x_msg_data) ;
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;

Line 508: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
508: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
509: p_data => x_msg_data) ;
510:
511: WHEN OTHERS THEN
512: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;

Line 514: IF FND_MSG_PUB.Check_Msg_Level

510:
511: WHEN OTHERS THEN
512: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
514: IF FND_MSG_PUB.Check_Msg_Level
515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
516: THEN
517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
518: END IF ;

Line 515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

511: WHEN OTHERS THEN
512: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
514: IF FND_MSG_PUB.Check_Msg_Level
515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
516: THEN
517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
518: END IF ;
519: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
514: IF FND_MSG_PUB.Check_Msg_Level
515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
516: THEN
517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
518: END IF ;
519: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
520: p_data => x_msg_data) ;
521:

Line 519: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
516: THEN
517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
518: END IF ;
519: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
520: p_data => x_msg_data) ;
521:
522: End Delete_csc_prof_group_cat;
523: