DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_CUHK dependencies on CS_SERVICEREQUEST_CUHK

Line 1: PACKAGE BODY cs_servicerequest_cuhk AS

1: PACKAGE BODY cs_servicerequest_cuhk AS
2: /* $Header: cscsrb.pls 120.0.12020000.2 2012/12/24 09:05:00 lkullamb ship $ */
3:
4: /*****************************************************************************************
5: This is the Customer User Hook API.

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ServiceRequest_CUHK';

4: /*****************************************************************************************
5: This is the Customer User Hook API.
6: The Customers can add customization procedures here for Pre and Post Processing.
7: ******************************************************************************************/
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ServiceRequest_CUHK';
9:
10: PROCEDURE Create_ServiceRequest_Pre
11: ( p_api_version IN NUMBER,
12: p_init_msg_list IN VARCHAR2 ,

Line 42: Savepoint CS_ServiceRequest_CUHK;

38: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
39:
40: Begin
41:
42: Savepoint CS_ServiceRequest_CUHK;
43: x_return_status := fnd_api.g_ret_sts_success;
44: /*
45: -- Call to ISupport Package
46:

Line 121: ROLLBACK TO CS_ServiceRequest_CUHK;

117: p_data => x_msg_data );
118:
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 );

Line 127: ROLLBACK TO CS_ServiceRequest_CUHK;

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

Line 167: Savepoint CS_ServiceRequest_CUHK;

163: l_api_name VARCHAR2(30) := 'Create_ServiceRequest_Post';
164: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
165: BEGIN
166:
167: Savepoint CS_ServiceRequest_CUHK;
168:
169: x_return_status := fnd_api.g_ret_sts_success;
170: /*
171: IBU_SR_CUHK.Create_ServiceRequest_Post(

Line 226: ROLLBACK TO CS_ServiceRequest_CUHK;

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

Line 232: ROLLBACK TO CS_ServiceRequest_CUHK;

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

Line 290: Savepoint CS_ServiceRequest_CUHK;

286: l_api_name VARCHAR2(30) := 'Update_ServiceRequest_Post';
287: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
288: Begin
289:
290: Savepoint CS_ServiceRequest_CUHK;
291:
292: x_return_status := fnd_api.g_ret_sts_success;
293: /*
294: -- Call to ISupport Package

Line 367: ROLLBACK TO CS_ServiceRequest_CUHK;

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

Line 373: ROLLBACK TO CS_ServiceRequest_CUHK;

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

Line 429: Savepoint CS_ServiceRequest_CUHK;

425: l_api_name VARCHAR2(30) := 'Update_ServiceRequest_Post';
426: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
427: BEGIN
428:
429: Savepoint CS_ServiceRequest_CUHK;
430:
431: x_return_status := fnd_api.g_ret_sts_success;
432: /*
433: IBU_SR_CUHK.Update_ServiceRequest_Post(

Line 489: ROLLBACK TO CS_ServiceRequest_CUHK;

485: p_data => x_msg_data );
486:
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 );

Line 495: ROLLBACK TO CS_ServiceRequest_CUHK;

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

Line 524: END cs_servicerequest_cuhk;

520: return false;
521: End;
522:
523:
524: END cs_servicerequest_cuhk;