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
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;
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,
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
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;
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;
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;
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,
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
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;
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;
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;
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,
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
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;
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
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;
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,
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
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;