DBA Data[Home] [Help]

APPS.JTF_BRMWFATTRVALUE_PVT dependencies on FND_MSG_PUB

Line 77: FND_MSG_PUB.Initialize;

73: -- Initialize message list if p_init_msg_list is set to TRUE
74: --
75: IF FND_API.To_Boolean(p_init_msg_list)
76: THEN
77: FND_MSG_PUB.Initialize;
78: END IF;
79:
80: --
81: -- Initialize API return status to success

Line 199: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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

Line 208: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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

Line 216: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
213: THEN
214: ROLLBACK TO Create_WFAttrValue_PVT;
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
217: , p_data => x_msg_data
218: );
219:
220: WHEN OTHERS

Line 224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

220: WHEN OTHERS
221: THEN
222: ROLLBACK TO Create_WFAttrValue_PVT;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
225: THEN
226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
227: , l_api_name
228: );

Line 226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

222: ROLLBACK TO Create_WFAttrValue_PVT;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
225: THEN
226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
227: , l_api_name
228: );
229: END IF;
230: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 230: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
227: , l_api_name
228: );
229: END IF;
230: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
231: , p_data => x_msg_data
232: );
233:
234: END Create_WFAttrValue;

Line 304: FND_MSG_PUB.Initialize;

300: -- Initialize message list if p_init_msg_list is set to TRUE
301: --
302: IF FND_API.To_Boolean(p_init_msg_list)
303: THEN
304: FND_MSG_PUB.Initialize;
305: END IF;
306:
307: --
308: -- Initialize API return status to success

Line 371: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

367:
368: --
369: -- Standard call to get message count and if count is 1, get message info
370: --
371: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
372: , p_data => x_msg_data
373: );
374:
375: EXCEPTION

Line 380: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

376: WHEN FND_API.G_EXC_ERROR
377: THEN
378: ROLLBACK TO Update_WFAttrValue_PVT;
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
381: , p_data => x_msg_data
382: );
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 388: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
385: THEN
386: ROLLBACK TO Update_WFAttrValue_PVT;
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
389: , p_data => x_msg_data
390: );
391:
392: WHEN OTHERS

Line 396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

392: WHEN OTHERS
393: THEN
394: ROLLBACK TO Update_WFAttrValue_PVT;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
397: THEN
398: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
399: , l_api_name
400: );

Line 398: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

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

Line 402: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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

Line 474: FND_MSG_PUB.initialize;

470: -- Initialize message list if requested
471: --
472: IF FND_API.to_Boolean( p_init_msg_list )
473: THEN
474: FND_MSG_PUB.initialize;
475: END IF;
476:
477: --
478: -- Initialize return status to SUCCESS

Line 498: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

494: THEN
495: COMMIT WORK;
496: END IF;
497:
498: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
499: , p_data => X_MSG_DATA
500: );
501:
502: EXCEPTION

Line 507: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

503: WHEN FND_API.G_EXC_ERROR
504: THEN
505: ROLLBACK TO Delete_WFAttrValue_PVT;
506: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
507: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
508: , p_data => X_MSG_DATA
509: );
510:
511: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 515: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

511: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
512: THEN
513: ROLLBACK TO Delete_WFAttrValue_PVT;
514: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
515: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
516: , p_data => X_MSG_DATA
517: );
518:
519: WHEN OTHERS

Line 523: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

519: WHEN OTHERS
520: THEN
521: ROLLBACK TO Delete_WFAttrValue_PVT;
522: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
523: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
524: THEN
525: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
526: , l_api_name
527: );

Line 525: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

521: ROLLBACK TO Delete_WFAttrValue_PVT;
522: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
523: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
524: THEN
525: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
526: , l_api_name
527: );
528: END IF;
529: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 529: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

525: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
526: , l_api_name
527: );
528: END IF;
529: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
530: , p_data => X_MSG_DATA
531: );
532:
533: END Delete_WFAttrValue;