eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SYSTEM_LINK_UTIL dependencies on FND_API

Line 14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

10:
11: PROCEDURE Associate_System_With_User
12: (
13: p_api_version_number IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR := FND_API.G_FALSE,
16: p_system_id IN NUMBER,
17: p_party_id IN NUMBER,
18: x_return_status OUT VARCHAR2,

Line 15: p_commit IN VARCHAR := FND_API.G_FALSE,

11: PROCEDURE Associate_System_With_User
12: (
13: p_api_version_number IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR := FND_API.G_FALSE,
16: p_system_id IN NUMBER,
17: p_party_id IN NUMBER,
18: x_return_status OUT VARCHAR2,
19: x_msg_count OUT NUMBER,

Line 38: IF FND_API.to_Boolean( p_init_msg_list ) THEN

34:
35: BEGIN
36: SAVEPOINT Associate_System_User;
37: -- Initialize message list if p_init_msg_list is set to TRUE.
38: IF FND_API.to_Boolean( p_init_msg_list ) THEN
39: FND_MSG_PUB.initialize;
40: END IF;
41:
42: OPEN c1;

Line 75: IF FND_API.To_Boolean( p_commit ) THEN

71: l_link_id,
72: 1
73: );
74: -- Standard check of p_commit.
75: IF FND_API.To_Boolean( p_commit ) THEN
76: COMMIT WORK;
77: END IF;
78: END IF;
79: CLOSE c1;

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: COMMIT WORK;
77: END IF;
78: END IF;
79: CLOSE c1;
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82:
83: EXCEPTION
84: WHEN OTHERS THEN

Line 86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

82:
83: EXCEPTION
84: WHEN OTHERS THEN
85: CLOSE c1;
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: FND_MESSAGE.SET_NAME('CS','CS_INSERT_UNEXP_ERR');
88: FND_MSG_PUB.Add;
89: FND_MSG_PUB.Count_And_Get (
90: p_count => x_msg_count ,

Line 93: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

89: FND_MSG_PUB.Count_And_Get (
90: p_count => x_msg_count ,
91: p_data => x_msg_data
92: );
93: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
94: ROLLBACK TO Associate_System_User;
95:
96: END Associate_System_With_User;
97:

Line 101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

97:
98: PROCEDURE Disassociate_System_With_User
99: (
100: p_api_version_number IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR := FND_API.G_FALSE,
103: p_system_id IN NUMBER,
104: p_party_id IN NUMBER,
105: x_return_status OUT VARCHAR2,

Line 102: p_commit IN VARCHAR := FND_API.G_FALSE,

98: PROCEDURE Disassociate_System_With_User
99: (
100: p_api_version_number IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR := FND_API.G_FALSE,
103: p_system_id IN NUMBER,
104: p_party_id IN NUMBER,
105: x_return_status OUT VARCHAR2,
106: x_msg_count OUT NUMBER,

Line 126: IF FND_API.to_Boolean( p_init_msg_list ) THEN

122:
123: SAVEPOINT Disassociate_System_User;
124:
125: -- Initialize message list if p_init_msg_list is set to TRUE.
126: IF FND_API.to_Boolean( p_init_msg_list ) THEN
127: FND_MSG_PUB.initialize;
128: END IF;
129:
130: OPEN c1;

Line 134: x_return_status := FND_API.G_RET_STS_ERROR ;

130: OPEN c1;
131: FETCH c1 INTO l_dummy;
132: -- If there is no present link then insert.
133: IF c1%NOTFOUND THEN
134: x_return_status := FND_API.G_RET_STS_ERROR ;
135: FND_MESSAGE.SET_NAME('CS','CS_NO_LINK_FOUND');
136: FND_MSG_PUB.Add;
137: FND_MSG_PUB.Count_And_Get (
138: p_count => x_msg_count ,

Line 141: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

137: FND_MSG_PUB.Count_And_Get (
138: p_count => x_msg_count ,
139: p_data => x_msg_data
140: );
141: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
142: ELSE
143: UPDATE CS_SYSTEM_PARTY_LINKS SET
144: end_date = sysdate,
145: last_update_date = sysdate,

Line 150: x_return_status := FND_API.G_RET_STS_SUCCESS;

146: last_updated_by = G_USER,
147: object_version_number = object_version_number + 1
148: WHERE party_id = p_party_id AND system_id = p_system_id AND end_date is null;
149:
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151: -- Standard check of p_commit.
152: IF FND_API.To_Boolean( p_commit ) THEN
153: COMMIT WORK;
154: END IF;

Line 152: IF FND_API.To_Boolean( p_commit ) THEN

148: WHERE party_id = p_party_id AND system_id = p_system_id AND end_date is null;
149:
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151: -- Standard check of p_commit.
152: IF FND_API.To_Boolean( p_commit ) THEN
153: COMMIT WORK;
154: END IF;
155: END IF;
156: CLOSE c1;

Line 161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

157:
158: EXCEPTION
159: WHEN OTHERS THEN
160: CLOSE c1;
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: FND_MESSAGE.SET_NAME('CS','CS_UPDATE_UNEXP_ERR');
163: FND_MSG_PUB.Add;
164: FND_MSG_PUB.Count_And_Get
165: (

Line 169: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

165: (
166: p_count => x_msg_count ,
167: p_data => x_msg_data
168: );
169: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
170: ROLLBACK TO Disassociate_System_User;
171:
172: END Disassociate_System_With_User;
173:

Line 177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

173:
174: PROCEDURE Associate_Name_With_User
175: (
176: p_api_version_number IN NUMBER,
177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178: p_commit IN VARCHAR := FND_API.G_FALSE,
179: p_system_name IN VARCHAR2,
180: p_party_id IN NUMBER,
181: x_return_status OUT VARCHAR2,

Line 178: p_commit IN VARCHAR := FND_API.G_FALSE,

174: PROCEDURE Associate_Name_With_User
175: (
176: p_api_version_number IN NUMBER,
177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178: p_commit IN VARCHAR := FND_API.G_FALSE,
179: p_system_name IN VARCHAR2,
180: p_party_id IN NUMBER,
181: x_return_status OUT VARCHAR2,
182: x_msg_count OUT NUMBER,

Line 198: IF FND_API.to_Boolean( p_init_msg_list ) THEN

194:
195: SAVEPOINT Associate_Name_User;
196:
197: -- Initialize message list if p_init_msg_list is set to TRUE.
198: IF FND_API.to_Boolean( p_init_msg_list ) THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:
202: OPEN c1;

Line 206: x_return_status := FND_API.G_RET_STS_ERROR ;

202: OPEN c1;
203: FETCH c1 INTO l_system_id;
204: -- If there is no present link then insert.
205: IF c1%NOTFOUND THEN
206: x_return_status := FND_API.G_RET_STS_ERROR ;
207: FND_MESSAGE.SET_NAME('CS','CS_SYSTEM_NAME_NOT_EXIST');
208: FND_MSG_PUB.Add;
209: FND_MSG_PUB.Count_And_Get(
210: p_count => x_msg_count ,

Line 213: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

209: FND_MSG_PUB.Count_And_Get(
210: p_count => x_msg_count ,
211: p_data => x_msg_data
212: );
213: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
214: ELSE
215: Associate_System_With_User (p_api_version_number,
216: p_init_msg_list,
217: p_commit,

Line 231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

227:
228: EXCEPTION
229: WHEN OTHERS THEN
230: CLOSE c1;
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: FND_MESSAGE.SET_NAME('CS','CS_SYSTEM_NAME_UNEXP_ERR');
233: FND_MSG_PUB.Add;
234: FND_MSG_PUB.Count_And_Get
235: (

Line 239: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

235: (
236: p_count => x_msg_count ,
237: p_data => x_msg_data
238: );
239: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
240: ROLLBACK TO Associate_Name_User;
241:
242: END Associate_Name_With_User;
243:

Line 247: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

243:
244: PROCEDURE Disassociate_Name_With_User
245: (
246: p_api_version_number IN NUMBER,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
248: p_commit IN VARCHAR := FND_API.G_FALSE,
249: p_system_name IN VARCHAR2,
250: p_party_id IN NUMBER,
251: x_return_status OUT VARCHAR2,

Line 248: p_commit IN VARCHAR := FND_API.G_FALSE,

244: PROCEDURE Disassociate_Name_With_User
245: (
246: p_api_version_number IN NUMBER,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
248: p_commit IN VARCHAR := FND_API.G_FALSE,
249: p_system_name IN VARCHAR2,
250: p_party_id IN NUMBER,
251: x_return_status OUT VARCHAR2,
252: x_msg_count OUT NUMBER,

Line 268: IF FND_API.to_Boolean( p_init_msg_list ) THEN

264:
265: SAVEPOINT Disassociate_Name_User;
266:
267: -- Initialize message list if p_init_msg_list is set to TRUE.
268: IF FND_API.to_Boolean( p_init_msg_list ) THEN
269: FND_MSG_PUB.initialize;
270: END IF;
271:
272: OPEN c1;

Line 276: x_return_status := FND_API.G_RET_STS_ERROR ;

272: OPEN c1;
273: FETCH c1 INTO l_system_id;
274: -- If there is no present link then insert.
275: IF c1%NOTFOUND THEN
276: x_return_status := FND_API.G_RET_STS_ERROR ;
277: FND_MESSAGE.SET_NAME('CS','CS_SYSTEM_NAME_NOT_EXIST');
278: FND_MSG_PUB.Add;
279: FND_MSG_PUB.Count_And_Get
280: (

Line 284: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

280: (
281: p_count => x_msg_count ,
282: p_data => x_msg_data
283: );
284: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
285: ELSE
286: Disassociate_System_With_User (p_api_version_number,
287: p_init_msg_list,
288: p_commit,

Line 302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

298:
299: EXCEPTION
300: WHEN OTHERS THEN
301: CLOSE c1;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MESSAGE.SET_NAME('CS','CS_SYSTEM_NAME_UNEXP_ERR');
304: FND_MSG_PUB.Add;
305: FND_MSG_PUB.Count_And_Get
306: (

Line 310: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

306: (
307: p_count => x_msg_count ,
308: p_data => x_msg_data
309: );
310: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
311: ROLLBACK TO Disassociate_Name_User;
312:
313: END Disassociate_Name_With_User;
314:

Line 318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

314:
315: PROCEDURE Associate_System_With_SR
316: (
317: p_api_version_number IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_commit IN VARCHAR := FND_API.G_FALSE,
320: p_system_id IN NUMBER,
321: p_service_request_id IN NUMBER,
322: x_return_status OUT VARCHAR2,

Line 319: p_commit IN VARCHAR := FND_API.G_FALSE,

315: PROCEDURE Associate_System_With_SR
316: (
317: p_api_version_number IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_commit IN VARCHAR := FND_API.G_FALSE,
320: p_system_id IN NUMBER,
321: p_service_request_id IN NUMBER,
322: x_return_status OUT VARCHAR2,
323: x_msg_count OUT NUMBER,

Line 344: IF FND_API.to_Boolean( p_init_msg_list ) THEN

340:
341: SAVEPOINT Associate_System_SR;
342:
343: -- Initialize message list if p_init_msg_list is set to TRUE.
344: IF FND_API.to_Boolean( p_init_msg_list ) THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: OPEN c1;

Line 381: IF FND_API.To_Boolean( p_commit ) THEN

377: l_link_id,
378: 1
379: );
380: -- Standard check of p_commit.
381: IF FND_API.To_Boolean( p_commit ) THEN
382: COMMIT WORK;
383: END IF;
384: END IF;
385: CLOSE c1;

Line 386: x_return_status := FND_API.G_RET_STS_SUCCESS;

382: COMMIT WORK;
383: END IF;
384: END IF;
385: CLOSE c1;
386: x_return_status := FND_API.G_RET_STS_SUCCESS;
387:
388: EXCEPTION
389: WHEN OTHERS THEN
390: CLOSE c1;

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

387:
388: EXCEPTION
389: WHEN OTHERS THEN
390: CLOSE c1;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MESSAGE.SET_NAME('CS','CS_INSERT_UNEXP_ERR');
393: FND_MSG_PUB.Add;
394: FND_MSG_PUB.Count_And_Get (
395: p_count => x_msg_count ,

Line 398: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

394: FND_MSG_PUB.Count_And_Get (
395: p_count => x_msg_count ,
396: p_data => x_msg_data
397: );
398: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
399: ROLLBACK TO Associate_System_SR;
400:
401: END Associate_System_With_SR;
402:

Line 406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

402:
403: PROCEDURE Disassociate_System_With_SR
404: (
405: p_api_version_number IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407: p_commit IN VARCHAR := FND_API.G_FALSE,
408: p_system_id IN NUMBER,
409: p_service_request_id IN NUMBER,
410: x_return_status OUT VARCHAR2,

Line 407: p_commit IN VARCHAR := FND_API.G_FALSE,

403: PROCEDURE Disassociate_System_With_SR
404: (
405: p_api_version_number IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407: p_commit IN VARCHAR := FND_API.G_FALSE,
408: p_system_id IN NUMBER,
409: p_service_request_id IN NUMBER,
410: x_return_status OUT VARCHAR2,
411: x_msg_count OUT NUMBER,

Line 432: IF FND_API.to_Boolean( p_init_msg_list ) THEN

428:
429: SAVEPOINT Disassociate_System_SR;
430:
431: -- Initialize message list if p_init_msg_list is set to TRUE.
432: IF FND_API.to_Boolean( p_init_msg_list ) THEN
433: FND_MSG_PUB.initialize;
434: END IF;
435:
436: OPEN c1;

Line 440: x_return_status := FND_API.G_RET_STS_ERROR ;

436: OPEN c1;
437: FETCH c1 INTO l_dummy;
438: -- If there is no present link then insert.
439: IF c1%NOTFOUND THEN
440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: FND_MESSAGE.SET_NAME('CS','CS_NO_LINK_FOUND');
442: FND_MSG_PUB.Add;
443: FND_MSG_PUB.Count_And_Get(
444: p_count => x_msg_count ,

Line 447: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

443: FND_MSG_PUB.Count_And_Get(
444: p_count => x_msg_count ,
445: p_data => x_msg_data
446: );
447: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
448: ELSE
449: -- Will only update the end_date of the links that have end_date = null
450: UPDATE CS_SYSTEM_SR_LINKS SET
451: end_date = sysdate,

Line 456: x_return_status := FND_API.G_RET_STS_SUCCESS;

452: last_update_date = sysdate,
453: last_updated_by = G_USER,
454: object_version_number = object_version_number + 1
455: WHERE incident_id = p_service_request_id AND system_id = p_system_id AND end_date is null;
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
457: -- Standard check of p_commit.
458: IF FND_API.To_Boolean( p_commit ) THEN
459: COMMIT WORK;
460: END IF;

Line 458: IF FND_API.To_Boolean( p_commit ) THEN

454: object_version_number = object_version_number + 1
455: WHERE incident_id = p_service_request_id AND system_id = p_system_id AND end_date is null;
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
457: -- Standard check of p_commit.
458: IF FND_API.To_Boolean( p_commit ) THEN
459: COMMIT WORK;
460: END IF;
461: END IF;
462: CLOSE c1;

Line 467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

463:
464: EXCEPTION
465: WHEN OTHERS THEN
466: CLOSE c1;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: FND_MESSAGE.SET_NAME('CS','CS_UPDATE_UNEXP_ERR');
469: FND_MSG_PUB.Add;
470: FND_MSG_PUB.Count_And_Get(
471: p_count => x_msg_count ,

Line 474: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

470: FND_MSG_PUB.Count_And_Get(
471: p_count => x_msg_count ,
472: p_data => x_msg_data
473: );
474: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
475: ROLLBACK TO Disassociate_System_SR;
476:
477:
478: END Disassociate_System_With_SR;

Line 483: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

479:
480: PROCEDURE Associate_Name_With_SR
481: (
482: p_api_version_number IN NUMBER,
483: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
484: p_commit IN VARCHAR := FND_API.G_FALSE,
485: p_system_name IN VARCHAR2,
486: p_service_request_id IN NUMBER,
487: x_return_status OUT VARCHAR2,

Line 484: p_commit IN VARCHAR := FND_API.G_FALSE,

480: PROCEDURE Associate_Name_With_SR
481: (
482: p_api_version_number IN NUMBER,
483: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
484: p_commit IN VARCHAR := FND_API.G_FALSE,
485: p_system_name IN VARCHAR2,
486: p_service_request_id IN NUMBER,
487: x_return_status OUT VARCHAR2,
488: x_msg_count OUT NUMBER,

Line 504: IF FND_API.to_Boolean( p_init_msg_list ) THEN

500:
501: SAVEPOINT Associate_Name_SR;
502:
503: -- Initialize message list if p_init_msg_list is set to TRUE.
504: IF FND_API.to_Boolean( p_init_msg_list ) THEN
505: FND_MSG_PUB.initialize;
506: END IF;
507:
508: OPEN c1;

Line 512: x_return_status := FND_API.G_RET_STS_ERROR ;

508: OPEN c1;
509: FETCH c1 INTO l_system_id;
510: -- If there is no present link then insert.
511: IF c1%NOTFOUND THEN
512: x_return_status := FND_API.G_RET_STS_ERROR ;
513: FND_MESSAGE.SET_NAME('CS','CS_SYSTEM_NAME_NOT_EXIST');
514: FND_MSG_PUB.Add;
515: FND_MSG_PUB.Count_And_Get(
516: p_count => x_msg_count ,

Line 519: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

515: FND_MSG_PUB.Count_And_Get(
516: p_count => x_msg_count ,
517: p_data => x_msg_data
518: );
519: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
520: ELSE
521: Associate_System_With_SR (p_api_version_number,
522: p_init_msg_list,
523: p_commit,

Line 537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

533:
534: EXCEPTION
535: WHEN OTHERS THEN
536: CLOSE c1;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: FND_MESSAGE.SET_NAME('CS','CS_SYSTEM_NAME_UNEXP_ERR');
539: FND_MSG_PUB.Add;
540: FND_MSG_PUB.Count_And_Get
541: (

Line 545: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

541: (
542: p_count => x_msg_count ,
543: p_data => x_msg_data
544: );
545: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
546: ROLLBACK TO Associate_Name_SR;
547:
548: END Associate_Name_With_SR;
549:

Line 553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

549:
550: PROCEDURE Disassociate_Name_With_SR
551: (
552: p_api_version_number IN NUMBER,
553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
554: p_commit IN VARCHAR := FND_API.G_FALSE,
555: p_system_name IN VARCHAR2,
556: p_service_request_id IN NUMBER,
557: x_return_status OUT VARCHAR2,

Line 554: p_commit IN VARCHAR := FND_API.G_FALSE,

550: PROCEDURE Disassociate_Name_With_SR
551: (
552: p_api_version_number IN NUMBER,
553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
554: p_commit IN VARCHAR := FND_API.G_FALSE,
555: p_system_name IN VARCHAR2,
556: p_service_request_id IN NUMBER,
557: x_return_status OUT VARCHAR2,
558: x_msg_count OUT NUMBER,

Line 574: IF FND_API.to_Boolean( p_init_msg_list ) THEN

570:
571: SAVEPOINT Disassociate_Name_SR;
572:
573: -- Initialize message list if p_init_msg_list is set to TRUE.
574: IF FND_API.to_Boolean( p_init_msg_list ) THEN
575: FND_MSG_PUB.initialize;
576: END IF;
577:
578: OPEN c1;

Line 582: x_return_status := FND_API.G_RET_STS_ERROR ;

578: OPEN c1;
579: FETCH c1 INTO l_system_id;
580: -- If there is no present link then insert.
581: IF c1%NOTFOUND THEN
582: x_return_status := FND_API.G_RET_STS_ERROR ;
583: FND_MESSAGE.SET_NAME('CS','CS_SYSTEM_NAME_NOT_EXIST');
584: FND_MSG_PUB.Add;
585: FND_MSG_PUB.Count_And_Get(
586: p_count => x_msg_count ,

Line 589: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

585: FND_MSG_PUB.Count_And_Get(
586: p_count => x_msg_count ,
587: p_data => x_msg_data
588: );
589: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
590: ELSE
591: Disassociate_System_With_SR (p_api_version_number,
592: p_init_msg_list,
593: p_commit,

Line 607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: CLOSE c1;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MESSAGE.SET_NAME('CS','CS_SYSTEM_NAME_UNEXP_ERR');
609: FND_MSG_PUB.Add;
610: FND_MSG_PUB.Count_And_Get
611: (

Line 615: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

611: (
612: p_count => x_msg_count ,
613: p_data => x_msg_data
614: );
615: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
616: ROLLBACK TO Disassociate_Name_SR;
617:
618: END Disassociate_Name_With_SR;
619: