DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_CUHK dependencies on FND_MSG_PUB

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

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

Line 122: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 131: FND_MSG_PUB.Count_And_Get

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

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

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

Line 227: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 236: FND_MSG_PUB.Count_And_Get

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

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

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

Line 368: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 377: FND_MSG_PUB.Count_And_Get

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

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

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

Line 490: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 499: FND_MSG_PUB.Count_And_Get

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