DBA Data[Home] [Help]

APPS.CCT_MEDIA_QUEUE_PUB dependencies on FND_MSG_PUB

Line 36: FND_MSG_PUB.initialize;

32: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
33: END IF;
34: -- Initialize message list if p_init_msg_list is set to TRUE.
35: IF FND_API.To_Boolean( p_init_msg_list ) THEN
36: FND_MSG_PUB.initialize;
37: END IF;
38: -- Initialize API return status to success
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40: -- API body

Line 57: FND_MSG_PUB.Count_And_Get

53: IF FND_API.To_Boolean( p_commit ) THEN
54: COMMIT WORK;
55: END IF;
56: -- Standard call to get message count and if count is 1, get message info.
57: FND_MSG_PUB.Count_And_Get
58: ( p_count => x_msg_count ,
59: p_data => x_msg_data
60: );
61: EXCEPTION

Line 77: FND_MSG_PUB.Count_And_Get

73:
74: WHEN FND_API.G_EXC_ERROR THEN
75: ROLLBACK TO UPDATE_DEQUEUE_COUNT_PUB;
76: x_return_status := FND_API.G_RET_STS_ERROR ;
77: FND_MSG_PUB.Count_And_Get
78: ( p_count => x_msg_count ,
79: p_data => x_msg_data
80: );
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 84: FND_MSG_PUB.Count_And_Get

80: );
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
82: ROLLBACK TO UPDATE_DEQUEUE_COUNT_PUB;
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
84: FND_MSG_PUB.Count_And_Get
85: ( p_count => x_msg_count ,
86: p_data => x_msg_data
87: );
88: WHEN OTHERS THEN

Line 91: IF FND_MSG_PUB.Check_Msg_Level

87: );
88: WHEN OTHERS THEN
89: ROLLBACK TO UPDATE_DEQUEUE_COUNT_PUB;
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
91: IF FND_MSG_PUB.Check_Msg_Level
92: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
93: THEN
94: FND_MSG_PUB.Add_Exc_Msg
95: ( G_PKG_NAME ,

Line 92: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

88: WHEN OTHERS THEN
89: ROLLBACK TO UPDATE_DEQUEUE_COUNT_PUB;
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
91: IF FND_MSG_PUB.Check_Msg_Level
92: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
93: THEN
94: FND_MSG_PUB.Add_Exc_Msg
95: ( G_PKG_NAME ,
96: l_api_name

Line 94: FND_MSG_PUB.Add_Exc_Msg

90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
91: IF FND_MSG_PUB.Check_Msg_Level
92: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
93: THEN
94: FND_MSG_PUB.Add_Exc_Msg
95: ( G_PKG_NAME ,
96: l_api_name
97: );
98: END IF;

Line 99: FND_MSG_PUB.Count_And_Get

95: ( G_PKG_NAME ,
96: l_api_name
97: );
98: END IF;
99: FND_MSG_PUB.Count_And_Get
100: ( p_count => x_msg_count ,
101: p_data => x_msg_data
102: );
103: END UPDATE_DEQUEUE_COUNT;

Line 153: FND_MSG_PUB.initialize;

149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151: -- Initialize message list if p_init_msg_list is set to TRUE.
152: IF FND_API.To_Boolean( p_init_msg_list ) THEN
153: FND_MSG_PUB.initialize;
154: END IF;
155: -- Initialize API return status to success
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157:

Line 264: FND_MSG_PUB.Count_And_Get

260: IF FND_API.To_Boolean( p_commit ) THEN
261: COMMIT WORK;
262: END IF;
263: -- Standard call to get message count and if count is 1, get message info.
264: FND_MSG_PUB.Count_And_Get
265: ( p_count => x_msg_count ,
266: p_data => x_msg_data
267: );
268: EXCEPTION

Line 273: FND_MSG_PUB.Add;

269:
270: WHEN MEDIA_ITEM_NOT_FOUND THEN
271: ROLLBACK TO GET_MEDIA_QUEUE_DETAILS_PUB;
272: FND_MESSAGE.SET_NAME('CCT','CCT_MEDIA_ITEM_NOT_FOUND');
273: FND_MSG_PUB.Add;
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275:
276: WHEN l_queue_position_undefined THEN
277: ROLLBACK TO GET_MEDIA_QUEUE_DETAILS_PUB;

Line 279: FND_MSG_PUB.Add;

275:
276: WHEN l_queue_position_undefined THEN
277: ROLLBACK TO GET_MEDIA_QUEUE_DETAILS_PUB;
278: FND_MESSAGE.SET_NAME('CCT','CCT_QUEUE_POSITION_UNDEFINED');
279: FND_MSG_PUB.Add;
280: x_return_status := FND_API.G_RET_STS_ERROR ;
281:
282:
283: WHEN l_queue_seq_num_undefined THEN

Line 286: FND_MSG_PUB.Add;

282:
283: WHEN l_queue_seq_num_undefined THEN
284: ROLLBACK TO GET_MEDIA_QUEUE_DETAILS_PUB;
285: FND_MESSAGE.SET_NAME('CCT','CCT_QUEUE_SEQ_NUM_UNDEFINED');
286: FND_MSG_PUB.Add;
287: x_return_status := FND_API.G_RET_STS_ERROR ;
288:
289:
290: WHEN FND_API.G_EXC_ERROR THEN

Line 293: FND_MSG_PUB.Count_And_Get

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

Line 300: FND_MSG_PUB.Count_And_Get

296: );
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: ROLLBACK TO GET_MEDIA_QUEUE_DETAILS_PUB;
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
300: FND_MSG_PUB.Count_And_Get
301: ( p_count => x_msg_count ,
302: p_data => x_msg_data
303: );
304: WHEN OTHERS THEN

Line 307: IF FND_MSG_PUB.Check_Msg_Level

303: );
304: WHEN OTHERS THEN
305: ROLLBACK TO GET_MEDIA_QUEUE_DETAILS_PUB;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
307: IF FND_MSG_PUB.Check_Msg_Level
308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg
311: ( G_PKG_NAME ,

Line 308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

304: WHEN OTHERS THEN
305: ROLLBACK TO GET_MEDIA_QUEUE_DETAILS_PUB;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
307: IF FND_MSG_PUB.Check_Msg_Level
308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg
311: ( G_PKG_NAME ,
312: l_api_name

Line 310: FND_MSG_PUB.Add_Exc_Msg

306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
307: IF FND_MSG_PUB.Check_Msg_Level
308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg
311: ( G_PKG_NAME ,
312: l_api_name
313: );
314: END IF;

Line 315: FND_MSG_PUB.Count_And_Get

311: ( G_PKG_NAME ,
312: l_api_name
313: );
314: END IF;
315: FND_MSG_PUB.Count_And_Get
316: ( p_count => x_msg_count ,
317: p_data => x_msg_data
318: );
319: END GET_MEDIA_QUEUE_DETAILS ;