DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_CUHK dependencies on FND_API

Line 42: x_return_status := fnd_api.g_ret_sts_success;

38: Begin
39:
40: Savepoint CS_ServiceRequest_CUHK;
41:
42: x_return_status := fnd_api.g_ret_sts_success;
43: /*
44: -- Call to ISupport Package
45:
46: IBU_SR_CUHK.Create_ServiceRequest_Pre(

Line 50: p_validation_level => fnd_api.g_valid_level_full,

46: IBU_SR_CUHK.Create_ServiceRequest_Pre(
47: p_api_version => p_api_version,
48: p_init_msg_list => p_init_msg_list,
49: p_commit => p_commit,
50: p_validation_level => fnd_api.g_valid_level_full,
51: x_return_status => l_return_status,
52: x_msg_count => x_msg_count,
53: x_msg_data => x_msg_data,
54: p_resp_appl_id => p_resp_appl_id,

Line 70: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

66: x_request_number => x_request_number,
67: x_interaction_id => x_interaction_id,
68: x_workflow_process_id => x_workflow_process_id
69: );
70: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73: --------
74:

Line 71: RAISE FND_API.G_EXC_ERROR;

67: x_interaction_id => x_interaction_id,
68: x_workflow_process_id => x_workflow_process_id
69: );
70: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73: --------
74:
75:

Line 81: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,

77: CS_GIT_USERHOOK_PKG.GIT_Create_ServiceRequest_Pre (
78: p_api_version => p_api_version,
79: p_init_msg_list => p_init_msg_list,
80: p_commit => p_commit,
81: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
82: x_return_status => l_return_status,
83: x_msg_count => x_msg_count,
84: x_msg_data => x_msg_data,
85: p_sr_rec => p_service_request_rec,

Line 91: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

87: p_incident_id => p_request_id,
88: p_invocation_mode => p_invocation_mode
89: );
90:
91: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
92: RAISE FND_API.G_EXC_ERROR;
93: END IF;
94: */
95: -- Added null b'coz patch# 2192849 giving errors b'coz of this file.

Line 92: RAISE FND_API.G_EXC_ERROR;

88: p_invocation_mode => p_invocation_mode
89: );
90:
91: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
92: RAISE FND_API.G_EXC_ERROR;
93: END IF;
94: */
95: -- Added null b'coz patch# 2192849 giving errors b'coz of this file.
96: NULL;

Line 103: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

99: /*CS_OSS_USERHOOK_PKG.OSS_Create_ServiceRequest_Pre(
100: p_api_version => p_api_version,
101: p_init_msg_list => p_init_msg_list,
102: p_commit => p_commit,
103: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
104: x_return_status => l_return_status,
105: x_msg_count => x_msg_count,
106: x_msg_data => x_msg_data,
107: p_service_request_rec => p_service_request_rec

Line 110: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

106: x_msg_data => x_msg_data,
107: p_service_request_rec => p_service_request_rec
108: );
109:
110: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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

Line 111: RAISE FND_API.G_EXC_ERROR;

107: p_service_request_rec => p_service_request_rec
108: );
109:
110: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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,

Line 119: WHEN FND_API.G_EXC_ERROR THEN

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

Line 121: x_return_status := FND_API.G_RET_STS_ERROR;

117:
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

Line 127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

123: ( p_count => x_msg_count,
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

Line 168: x_return_status := fnd_api.g_ret_sts_success;

164: BEGIN
165:
166: Savepoint CS_ServiceRequest_CUHK;
167:
168: x_return_status := fnd_api.g_ret_sts_success;
169: /*
170: IBU_SR_CUHK.Create_ServiceRequest_Post(
171: p_api_version => p_api_version,
172: p_init_msg_list => p_init_msg_list,

Line 174: p_validation_level => fnd_api.g_valid_level_full,

170: IBU_SR_CUHK.Create_ServiceRequest_Post(
171: p_api_version => p_api_version,
172: p_init_msg_list => p_init_msg_list,
173: p_commit => p_commit,
174: p_validation_level => fnd_api.g_valid_level_full,
175: x_return_status => l_return_status,
176: x_msg_count => x_msg_count,
177: x_msg_data => x_msg_data,
178: p_resp_appl_id => p_resp_appl_id,

Line 195: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

191: x_interaction_id => x_interaction_id,
192: x_workflow_process_id => x_workflow_process_id
193: );
194:
195: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199:

Line 196: RAISE FND_API.G_EXC_ERROR;

192: x_workflow_process_id => x_workflow_process_id
193: );
194:
195: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199:
200: CS_GIT_USERHOOK_PKG.GIT_Create_ServiceRequest_Post(

Line 204: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

200: CS_GIT_USERHOOK_PKG.GIT_Create_ServiceRequest_Post(
201: p_api_version => p_api_version,
202: p_init_msg_list => p_init_msg_list,
203: p_commit => p_commit,
204: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
205: x_return_status => l_return_status,
206: x_msg_count => x_msg_count,
207: x_msg_data => x_msg_data,
208: p_sr_rec => p_service_request_rec,

Line 214: If (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

210: p_incident_id => p_request_id,
211: p_invocation_mode => p_invocation_mode
212: );
213:
214: If (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217: */
218: NULL;

Line 215: RAISE FND_API.G_EXC_ERROR;

211: p_invocation_mode => p_invocation_mode
212: );
213:
214: If (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217: */
218: NULL;
219:

Line 224: WHEN FND_API.G_EXC_ERROR THEN

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;
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: FND_MSG_PUB.Count_And_Get
228: ( p_count => x_msg_count,

Line 226: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

228: ( p_count => x_msg_count,
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

Line 291: x_return_status := fnd_api.g_ret_sts_success;

287: Begin
288:
289: Savepoint CS_ServiceRequest_CUHK;
290:
291: x_return_status := fnd_api.g_ret_sts_success;
292: /*
293: -- Call to ISupport Package
294:
295: IBU_SR_CUHK.Update_ServiceRequest_Pre(

Line 299: p_validation_level => fnd_api.g_valid_level_full,

295: IBU_SR_CUHK.Update_ServiceRequest_Pre(
296: p_api_version => p_api_version,
297: p_init_msg_list => p_init_msg_list,
298: p_commit => p_commit,
299: p_validation_level => fnd_api.g_valid_level_full,
300: x_return_status => l_return_status,
301: x_msg_count => x_msg_count,
302: x_msg_data => x_msg_data,
303: p_request_id => p_request_id,

Line 322: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

318: x_workflow_process_id => x_workflow_process_id,
319: x_interaction_id => x_interaction_id
320: );
321:
322: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
323: RAISE FND_API.G_EXC_ERROR;
324: END IF;
325: ---------
326:

Line 323: RAISE FND_API.G_EXC_ERROR;

319: x_interaction_id => x_interaction_id
320: );
321:
322: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
323: RAISE FND_API.G_EXC_ERROR;
324: END IF;
325: ---------
326:
327: CS_GIT_USERHOOK_PKG.GIT_Update_ServiceRequest_Pre(

Line 331: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

327: CS_GIT_USERHOOK_PKG.GIT_Update_ServiceRequest_Pre(
328: p_api_version => p_api_version,
329: p_init_msg_list => p_init_msg_list,
330: p_commit => p_commit,
331: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
332: x_return_status => l_return_status,
333: x_msg_count => x_msg_count,
334: x_msg_data => x_msg_data,
335: p_sr_rec => p_service_request_rec,

Line 340: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

336: p_incident_id => p_request_id,
337: p_invocation_mode => p_invocation_mode
338: );
339:
340: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343: */
344: NULL;

Line 341: RAISE FND_API.G_EXC_ERROR;

337: p_invocation_mode => p_invocation_mode
338: );
339:
340: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343: */
344: NULL;
345:

Line 350: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

346: /*CS_OSS_USERHOOK_PKG.OSS_Update_ServiceRequest_Pre(
347: p_api_version => p_api_version,
348: p_init_msg_list => p_init_msg_list,
349: p_commit => p_commit,
350: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
351: x_return_status => l_return_status,
352: x_msg_count => x_msg_count,
353: x_msg_data => x_msg_data,
354: p_service_request_rec => p_service_request_rec

Line 357: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

353: x_msg_data => x_msg_data,
354: p_service_request_rec => p_service_request_rec
355: );
356:
357: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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

Line 358: RAISE FND_API.G_EXC_ERROR;

354: p_service_request_rec => p_service_request_rec
355: );
356:
357: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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,

Line 365: WHEN FND_API.G_EXC_ERROR THEN

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;
367: x_return_status := FND_API.G_RET_STS_ERROR;
368: FND_MSG_PUB.Count_And_Get
369: ( p_count => x_msg_count,

Line 367: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

369: ( p_count => x_msg_count,
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

Line 430: x_return_status := fnd_api.g_ret_sts_success;

426: BEGIN
427:
428: Savepoint CS_ServiceRequest_CUHK;
429:
430: x_return_status := fnd_api.g_ret_sts_success;
431: /*
432: IBU_SR_CUHK.Update_ServiceRequest_Post(
433: p_api_version => p_api_version,
434: p_init_msg_list => p_init_msg_list,

Line 436: p_validation_level => fnd_api.g_valid_level_full,

432: IBU_SR_CUHK.Update_ServiceRequest_Post(
433: p_api_version => p_api_version,
434: p_init_msg_list => p_init_msg_list,
435: p_commit => p_commit,
436: p_validation_level => fnd_api.g_valid_level_full,
437: x_return_status => l_return_status,
438: x_msg_count => x_msg_count,
439: x_msg_data => x_msg_data,
440: p_request_id => p_request_id,

Line 459: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

455: x_workflow_process_id => x_workflow_process_id,
456: x_interaction_id => x_interaction_id
457: );
458:
459: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462:
463: CS_GIT_USERHOOK_PKG.GIT_Update_ServiceRequest_Post(

Line 460: RAISE FND_API.G_EXC_ERROR;

456: x_interaction_id => x_interaction_id
457: );
458:
459: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462:
463: CS_GIT_USERHOOK_PKG.GIT_Update_ServiceRequest_Post(
464: p_api_version => p_api_version,

Line 467: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

463: CS_GIT_USERHOOK_PKG.GIT_Update_ServiceRequest_Post(
464: p_api_version => p_api_version,
465: p_init_msg_list => p_init_msg_list,
466: p_commit => p_commit,
467: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
468: x_return_status => l_return_status,
469: x_msg_count => x_msg_count,
470: x_msg_data => x_msg_data,
471: p_sr_rec => p_service_request_rec,

Line 476: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

472: p_incident_id => p_request_id,
473: p_invocation_mode => p_invocation_mode
474: );
475:
476: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479: */
480: NULL;

Line 477: RAISE FND_API.G_EXC_ERROR;

473: p_invocation_mode => p_invocation_mode
474: );
475:
476: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479: */
480: NULL;
481:

Line 487: WHEN FND_API.G_EXC_ERROR THEN

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

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485:
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

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

491: ( p_count => x_msg_count,
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