DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_CUHK dependencies on FND_MSG_PUB

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

112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114: */
115: -- Standard call to get message count and if count is 1, get message info
116: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
117: p_data => x_msg_data );
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN

Line 123: FND_MSG_PUB.Count_And_Get

119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: ROLLBACK TO CS_ServiceRequest_CUHK;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: FND_MSG_PUB.Count_And_Get
124: ( p_count => x_msg_count,
125: p_data => x_msg_data );
126: WHEN OTHERS THEN
127: ROLLBACK TO CS_ServiceRequest_CUHK;

Line 129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

125: p_data => x_msg_data );
126: WHEN OTHERS THEN
127: ROLLBACK TO CS_ServiceRequest_CUHK;
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
130: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
131: END IF;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,

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

126: WHEN OTHERS THEN
127: ROLLBACK TO CS_ServiceRequest_CUHK;
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
130: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
131: END IF;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data

Line 132: FND_MSG_PUB.Count_And_Get

128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
130: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
131: END IF;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data
135: );
136: END;

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

218: */
219: NULL;
220:
221: -- Standard call to get message count and if count is 1, get message info
222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
223: p_data => x_msg_data );
224: EXCEPTION
225: WHEN FND_API.G_EXC_ERROR THEN
226: ROLLBACK TO CS_ServiceRequest_CUHK;

Line 228: FND_MSG_PUB.Count_And_Get

224: EXCEPTION
225: WHEN FND_API.G_EXC_ERROR THEN
226: ROLLBACK TO CS_ServiceRequest_CUHK;
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: FND_MSG_PUB.Count_And_Get
229: ( p_count => x_msg_count,
230: p_data => x_msg_data );
231: WHEN OTHERS THEN
232: ROLLBACK TO CS_ServiceRequest_CUHK;

Line 234: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

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

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

Line 237: FND_MSG_PUB.Count_And_Get

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

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

359: RAISE FND_API.G_EXC_ERROR;
360: END IF;
361: */
362: -- Standard call to get message count and if count is 1, get message info
363: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
364: p_data => x_msg_data );
365: EXCEPTION
366: WHEN FND_API.G_EXC_ERROR THEN
367: ROLLBACK TO CS_ServiceRequest_CUHK;

Line 369: FND_MSG_PUB.Count_And_Get

365: EXCEPTION
366: WHEN FND_API.G_EXC_ERROR THEN
367: ROLLBACK TO CS_ServiceRequest_CUHK;
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count,
371: p_data => x_msg_data );
372: WHEN OTHERS THEN
373: ROLLBACK TO CS_ServiceRequest_CUHK;

Line 375: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

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

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

Line 378: FND_MSG_PUB.Count_And_Get

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

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

480: */
481: NULL;
482:
483: -- Standard call to get message count and if count is 1, get message info
484: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
485: p_data => x_msg_data );
486:
487: EXCEPTION
488: WHEN FND_API.G_EXC_ERROR THEN

Line 491: FND_MSG_PUB.Count_And_Get

487: EXCEPTION
488: WHEN FND_API.G_EXC_ERROR THEN
489: ROLLBACK TO CS_ServiceRequest_CUHK;
490: x_return_status := FND_API.G_RET_STS_ERROR;
491: FND_MSG_PUB.Count_And_Get
492: ( p_count => x_msg_count,
493: p_data => x_msg_data );
494: WHEN OTHERS THEN
495: ROLLBACK TO CS_ServiceRequest_CUHK;

Line 497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

493: p_data => x_msg_data );
494: WHEN OTHERS THEN
495: ROLLBACK TO CS_ServiceRequest_CUHK;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
498: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
499: END IF;
500: FND_MSG_PUB.Count_And_Get
501: ( p_count => x_msg_count,

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

494: WHEN OTHERS THEN
495: ROLLBACK TO CS_ServiceRequest_CUHK;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
498: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
499: END IF;
500: FND_MSG_PUB.Count_And_Get
501: ( p_count => x_msg_count,
502: p_data => x_msg_data

Line 500: FND_MSG_PUB.Count_And_Get

496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
498: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
499: END IF;
500: FND_MSG_PUB.Count_And_Get
501: ( p_count => x_msg_count,
502: p_data => x_msg_data
503: );
504: END;