DBA Data[Home] [Help]

APPS.CSC_PROF_COLOR_CODE_PUB dependencies on FND_MSG_PUB

Line 146: FND_MSG_PUB.initialize;

142:
143: -- Initialize message list if p_init_msg_list is set to TRUE.
144: IF FND_API.to_Boolean( p_init_msg_list )
145: THEN
146: FND_MSG_PUB.initialize;
147: END IF;
148:
149:
150:

Line 197: FND_MSG_PUB.Count_And_Get

193:
194:
195:
196: -- Standard call to get message count and if count is 1, get message info.
197: FND_MSG_PUB.Count_And_Get
198: ( p_count => x_msg_count,
199: p_data => x_msg_data
200: );
201:

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

202: EXCEPTION
203: WHEN FND_API.G_EXC_ERROR THEN
204: ROLLBACK TO CREATE_PROF_COLOR_CODE_PUB;
205: x_return_status := FND_API.G_RET_STS_ERROR ;
206: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
207: p_data => x_msg_data) ;
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO CREATE_PROF_COLOR_CODE_PUB;

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

208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO CREATE_PROF_COLOR_CODE_PUB;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
212: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
213: p_data => x_msg_data) ;
214:
215: WHEN OTHERS THEN
216: ROLLBACK TO CREATE_PROF_COLOR_CODE_PUB;

Line 218: IF FND_MSG_PUB.Check_Msg_Level

214:
215: WHEN OTHERS THEN
216: ROLLBACK TO CREATE_PROF_COLOR_CODE_PUB;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
218: IF FND_MSG_PUB.Check_Msg_Level
219: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
220: THEN
221: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
222: END IF ;

Line 219: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

215: WHEN OTHERS THEN
216: ROLLBACK TO CREATE_PROF_COLOR_CODE_PUB;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
218: IF FND_MSG_PUB.Check_Msg_Level
219: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
220: THEN
221: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
222: END IF ;
223: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
218: IF FND_MSG_PUB.Check_Msg_Level
219: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
220: THEN
221: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
222: END IF ;
223: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
224: p_data => x_msg_data) ;
225: End Create_prof_color_code;

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

219: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
220: THEN
221: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
222: END IF ;
223: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
224: p_data => x_msg_data) ;
225: End Create_prof_color_code;
226:
227:

Line 302: FND_MSG_PUB.initialize;

298:
299: -- Initialize message list if p_init_msg_list is set to TRUE.
300: IF FND_API.to_Boolean( p_init_msg_list )
301: THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:
305:
306:

Line 352: FND_MSG_PUB.Count_And_Get

348:
349:
350:
351: -- Standard call to get message count and if count is 1, get message info.
352: FND_MSG_PUB.Count_And_Get
353: ( p_count => x_msg_count,
354: p_data => x_msg_data
355: );
356:

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

357: EXCEPTION
358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;
360: x_return_status := FND_API.G_RET_STS_ERROR ;
361: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
362: p_data => x_msg_data) ;
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;

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

363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
367: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
368: p_data => x_msg_data) ;
369:
370: WHEN OTHERS THEN
371: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;

Line 373: IF FND_MSG_PUB.Check_Msg_Level

369:
370: WHEN OTHERS THEN
371: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: IF FND_MSG_PUB.Check_Msg_Level
374: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
375: THEN
376: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
377: END IF ;

Line 374: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

370: WHEN OTHERS THEN
371: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: IF FND_MSG_PUB.Check_Msg_Level
374: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
375: THEN
376: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
377: END IF ;
378: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: IF FND_MSG_PUB.Check_Msg_Level
374: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
375: THEN
376: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
377: END IF ;
378: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
379: p_data => x_msg_data) ;
380:

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

374: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
375: THEN
376: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
377: END IF ;
378: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
379: p_data => x_msg_data) ;
380:
381:
382: End Update_prof_color_code;