DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_CUHK dependencies on FND_API

Line 43: x_return_status := fnd_api.g_ret_sts_success;

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:
47: IBU_SR_CUHK.Create_ServiceRequest_Pre(

Line 51: p_validation_level => fnd_api.g_valid_level_full,

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

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

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

Line 72: RAISE FND_API.G_EXC_ERROR;

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

Line 82: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,

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

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

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

Line 93: RAISE FND_API.G_EXC_ERROR;

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

Line 104: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

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

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

Line 112: RAISE FND_API.G_EXC_ERROR;

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

Line 120: WHEN FND_API.G_EXC_ERROR THEN

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

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
126: WHEN OTHERS THEN

Line 128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
132: FND_MSG_PUB.Count_And_Get

Line 169: x_return_status := fnd_api.g_ret_sts_success;

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(
172: p_api_version => p_api_version,
173: p_init_msg_list => p_init_msg_list,

Line 175: p_validation_level => fnd_api.g_valid_level_full,

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

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

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

Line 197: RAISE FND_API.G_EXC_ERROR;

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

Line 205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

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

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

Line 216: RAISE FND_API.G_EXC_ERROR;

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

Line 225: WHEN FND_API.G_EXC_ERROR THEN

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

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
231: WHEN OTHERS THEN

Line 233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
237: FND_MSG_PUB.Count_And_Get

Line 292: x_return_status := fnd_api.g_ret_sts_success;

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
295:
296: IBU_SR_CUHK.Update_ServiceRequest_Pre(

Line 300: p_validation_level => fnd_api.g_valid_level_full,

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

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

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

Line 324: RAISE FND_API.G_EXC_ERROR;

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

Line 332: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

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

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

Line 342: RAISE FND_API.G_EXC_ERROR;

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

Line 351: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

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

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

Line 359: RAISE FND_API.G_EXC_ERROR;

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

Line 366: WHEN FND_API.G_EXC_ERROR THEN

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

Line 368: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
372: WHEN OTHERS THEN

Line 374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
378: FND_MSG_PUB.Count_And_Get

Line 431: x_return_status := fnd_api.g_ret_sts_success;

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(
434: p_api_version => p_api_version,
435: p_init_msg_list => p_init_msg_list,

Line 437: p_validation_level => fnd_api.g_valid_level_full,

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

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

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

Line 461: RAISE FND_API.G_EXC_ERROR;

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

Line 468: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

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

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

Line 478: RAISE FND_API.G_EXC_ERROR;

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

Line 488: WHEN FND_API.G_EXC_ERROR THEN

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

Line 490: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
494: WHEN OTHERS THEN

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
500: FND_MSG_PUB.Count_And_Get