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.IEO_ICSM_CMD_PUB dependencies on FND_API

Line 35: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

31:
32: PROCEDURE EXECUTE_SERVER_CMD
33: (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
36: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
37:
38: p_cmd IN VARCHAR2,
39: p_server_id IN NUMBER,

Line 36: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

32: PROCEDURE EXECUTE_SERVER_CMD
33: (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
36: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
37:
38: p_cmd IN VARCHAR2,
39: p_server_id IN NUMBER,
40: x_result OUT NOCOPY VARCHAR2,

Line 55: IF NOT FND_API.Compatible_API_Call

51: BEGIN
52: -- Standard Start of API savepoint
53:
54: -- Standard call to check for call compatibility.
55: IF NOT FND_API.Compatible_API_Call
56: (
57: l_api_version,
58: p_api_version,
59: l_api_name,

Line 63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

59: l_api_name,
60: G_PKG_NAME
61: )
62: THEN
63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END IF;
65:
66: -- Initialize message list if p_init_msg_list is set to TRUE.
67: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 67: IF FND_API.To_Boolean( p_init_msg_list ) THEN

63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END IF;
65:
66: -- Initialize message list if p_init_msg_list is set to TRUE.
67: IF FND_API.To_Boolean( p_init_msg_list ) THEN
68: FND_MSG_PUB.initialize;
69: END IF;
70:
71: -- Initialize API return status to success

Line 72: x_return_status := FND_API.G_RET_STS_SUCCESS;

68: FND_MSG_PUB.initialize;
69: END IF;
70:
71: -- Initialize API return status to success
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: -- API body
75:
76: IF GET_SERVER_STATUS(p_server_id) <> 4 THEN

Line 116: IF FND_API.To_Boolean( p_commit ) THEN

112:
113: -- End of API body.
114:
115: -- Standard check of p_commit.
116: IF FND_API.To_Boolean( p_commit ) THEN
117: COMMIT WORK;
118: END IF;
119: -- Standard call to get message count and if count is 1, get message info.
120: FND_MSG_PUB.Count_And_Get

Line 126: WHEN FND_API.G_EXC_ERROR THEN

122: p_count => x_msg_count,
123: p_data => x_msg_data
124: );
125: EXCEPTION
126: WHEN FND_API.G_EXC_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_ERROR ;
128: FND_MSG_PUB.Count_And_Get
129: (
130: p_count => x_msg_count,

Line 127: x_return_status := FND_API.G_RET_STS_ERROR ;

123: p_data => x_msg_data
124: );
125: EXCEPTION
126: WHEN FND_API.G_EXC_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_ERROR ;
128: FND_MSG_PUB.Count_And_Get
129: (
130: p_count => x_msg_count,
131: p_data => x_msg_data

Line 133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

129: (
130: p_count => x_msg_count,
131: p_data => x_msg_data
132: );
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
135: FND_MSG_PUB.Count_And_Get
136: (
137: p_count => x_msg_count,

Line 134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

130: p_count => x_msg_count,
131: p_data => x_msg_data
132: );
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
135: FND_MSG_PUB.Count_And_Get
136: (
137: p_count => x_msg_count,
138: p_data => x_msg_data

Line 145: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

141:
142: PROCEDURE EXECUTE_ICSM_CMD
143: (
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
146: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
147:
148: p_cmd IN VARCHAR2,
149: p_node_id IN NUMBER,

Line 146: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

142: PROCEDURE EXECUTE_ICSM_CMD
143: (
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
146: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
147:
148: p_cmd IN VARCHAR2,
149: p_node_id IN NUMBER,
150: x_result OUT NOCOPY VARCHAR2,

Line 164: IF NOT FND_API.Compatible_API_Call

160: BEGIN
161: -- Standard Start of API savepoint
162:
163: -- Standard call to check for call compatibility.
164: IF NOT FND_API.Compatible_API_Call
165: (
166: l_api_version,
167: p_api_version,
168: l_api_name,

Line 172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

168: l_api_name,
169: G_PKG_NAME
170: )
171: THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: -- Initialize message list if p_init_msg_list is set to TRUE.
176: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 176: IF FND_API.To_Boolean( p_init_msg_list ) THEN

172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: -- Initialize message list if p_init_msg_list is set to TRUE.
176: IF FND_API.To_Boolean( p_init_msg_list ) THEN
177: FND_MSG_PUB.initialize;
178: END IF;
179:
180: -- Initialize API return status to success

Line 181: x_return_status := FND_API.G_RET_STS_SUCCESS;

177: FND_MSG_PUB.initialize;
178: END IF;
179:
180: -- Initialize API return status to success
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: -- API body
184:
185: IF GET_NODE_STATUS(p_node_id) = 0 THEN

Line 223: IF FND_API.To_Boolean( p_commit ) THEN

219:
220: -- End of API body.
221:
222: -- Standard check of p_commit.
223: IF FND_API.To_Boolean( p_commit ) THEN
224: COMMIT WORK;
225: END IF;
226: -- Standard call to get message count and if count is 1, get message info.
227: FND_MSG_PUB.Count_And_Get

Line 233: WHEN FND_API.G_EXC_ERROR THEN

229: p_count => x_msg_count,
230: p_data => x_msg_data
231: );
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: x_return_status := FND_API.G_RET_STS_ERROR ;
235: FND_MSG_PUB.Count_And_Get
236: (
237: p_count => x_msg_count,

Line 234: x_return_status := FND_API.G_RET_STS_ERROR ;

230: p_data => x_msg_data
231: );
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: x_return_status := FND_API.G_RET_STS_ERROR ;
235: FND_MSG_PUB.Count_And_Get
236: (
237: p_count => x_msg_count,
238: p_data => x_msg_data

Line 240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

236: (
237: p_count => x_msg_count,
238: p_data => x_msg_data
239: );
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
242: FND_MSG_PUB.Count_And_Get
243: (
244: p_count => x_msg_count,

Line 241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

237: p_count => x_msg_count,
238: p_data => x_msg_data
239: );
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
242: FND_MSG_PUB.Count_And_Get
243: (
244: p_count => x_msg_count,
245: p_data => x_msg_data

Line 252: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

248:
249: PROCEDURE TEST_IP
250: (
251: p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
253: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
254:
255: p_ip_addr IN VARCHAR2,
256: p_node_id IN NUMBER,

Line 253: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

249: PROCEDURE TEST_IP
250: (
251: p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
253: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
254:
255: p_ip_addr IN VARCHAR2,
256: p_node_id IN NUMBER,
257: x_result OUT NOCOPY VARCHAR2,

Line 272: IF NOT FND_API.Compatible_API_Call

268: BEGIN
269: -- Standard Start of API savepoint
270:
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call
273: (
274: l_api_version,
275: p_api_version,
276: l_api_name,

Line 280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

276: l_api_name,
277: G_PKG_NAME
278: )
279: THEN
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: -- Initialize message list if p_init_msg_list is set to TRUE.
284: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 284: IF FND_API.To_Boolean( p_init_msg_list ) THEN

280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: -- Initialize message list if p_init_msg_list is set to TRUE.
284: IF FND_API.To_Boolean( p_init_msg_list ) THEN
285: FND_MSG_PUB.initialize;
286: END IF;
287:
288: -- Initialize API return status to success

Line 289: x_return_status := FND_API.G_RET_STS_SUCCESS;

285: FND_MSG_PUB.initialize;
286: END IF;
287:
288: -- Initialize API return status to success
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290:
291: -- API body
292:
293: IF GET_NODE_STATUS(p_node_id) = 0 THEN

Line 333: IF FND_API.To_Boolean( p_commit ) THEN

329:
330: -- End of API body.
331:
332: -- Standard check of p_commit.
333: IF FND_API.To_Boolean( p_commit ) THEN
334: COMMIT WORK;
335: END IF;
336: -- Standard call to get message count and if count is 1, get message info.
337: FND_MSG_PUB.Count_And_Get

Line 343: WHEN FND_API.G_EXC_ERROR THEN

339: p_count => x_msg_count,
340: p_data => x_msg_data
341: );
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345: FND_MSG_PUB.Count_And_Get
346: (
347: p_count => x_msg_count,

Line 344: x_return_status := FND_API.G_RET_STS_ERROR ;

340: p_data => x_msg_data
341: );
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345: FND_MSG_PUB.Count_And_Get
346: (
347: p_count => x_msg_count,
348: p_data => x_msg_data

Line 350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

346: (
347: p_count => x_msg_count,
348: p_data => x_msg_data
349: );
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
352: FND_MSG_PUB.Count_And_Get
353: (
354: p_count => x_msg_count,

Line 351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

347: p_count => x_msg_count,
348: p_data => x_msg_data
349: );
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
352: FND_MSG_PUB.Count_And_Get
353: (
354: p_count => x_msg_count,
355: p_data => x_msg_data

Line 359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

355: p_data => x_msg_data
356: );
357: /* WHEN OTHERS THEN
358: ROLLBACK TO ENQUEUE_REQUEST_PUB;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: IF FND_MSG_PUB.Check_Msg_Level
361: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: THEN
363: FND_MSG_PUB.Add_Exc_Msg

Line 380: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

376:
377: PROCEDURE START_SERVER
378: (
379: p_api_version IN NUMBER,
380: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
381: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
382:
383: p_server_name IN VARCHAR2,
384: p_node_id IN NUMBER,

Line 381: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

377: PROCEDURE START_SERVER
378: (
379: p_api_version IN NUMBER,
380: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
381: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
382:
383: p_server_name IN VARCHAR2,
384: p_node_id IN NUMBER,
385:

Line 400: IF NOT FND_API.Compatible_API_Call

396: BEGIN
397: -- Standard Start of API savepoint
398:
399: -- Standard call to check for call compatibility.
400: IF NOT FND_API.Compatible_API_Call
401: (
402: l_api_version,
403: p_api_version,
404: l_api_name,

Line 408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

404: l_api_name,
405: G_PKG_NAME
406: )
407: THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410:
411: -- Initialize message list if p_init_msg_list is set to TRUE.
412: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 412: IF FND_API.To_Boolean( p_init_msg_list ) THEN

408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410:
411: -- Initialize message list if p_init_msg_list is set to TRUE.
412: IF FND_API.To_Boolean( p_init_msg_list ) THEN
413: FND_MSG_PUB.initialize;
414: END IF;
415:
416: -- Initialize API return status to success

Line 417: x_return_status := FND_API.G_RET_STS_SUCCESS;

413: FND_MSG_PUB.initialize;
414: END IF;
415:
416: -- Initialize API return status to success
417: x_return_status := FND_API.G_RET_STS_SUCCESS;
418:
419: -- API body
420:
421: IF GET_NODE_STATUS(p_node_id) = 0 THEN

Line 460: IF FND_API.To_Boolean( p_commit ) THEN

456: -- get the return data for response
457: x_xml_data := xml_data;
458:
459: -- Standard check of p_commit.
460: IF FND_API.To_Boolean( p_commit ) THEN
461: COMMIT WORK;
462: END IF;
463: -- Standard call to get message count and if count is 1, get message info.
464: FND_MSG_PUB.Count_And_Get

Line 471: WHEN FND_API.G_EXC_ERROR THEN

467: p_data => x_msg_data
468: );
469: EXCEPTION
470:
471: WHEN FND_API.G_EXC_ERROR THEN
472: x_return_status := FND_API.G_RET_STS_ERROR ;
473: FND_MSG_PUB.Count_And_Get
474: (
475: p_count => x_msg_count,

Line 472: x_return_status := FND_API.G_RET_STS_ERROR ;

468: );
469: EXCEPTION
470:
471: WHEN FND_API.G_EXC_ERROR THEN
472: x_return_status := FND_API.G_RET_STS_ERROR ;
473: FND_MSG_PUB.Count_And_Get
474: (
475: p_count => x_msg_count,
476: p_data => x_msg_data

Line 478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

474: (
475: p_count => x_msg_count,
476: p_data => x_msg_data
477: );
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: FND_MSG_PUB.Count_And_Get
481: (
482: p_count => x_msg_count,

Line 479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

475: p_count => x_msg_count,
476: p_data => x_msg_data
477: );
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: FND_MSG_PUB.Count_And_Get
481: (
482: p_count => x_msg_count,
483: p_data => x_msg_data

Line 490: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

486:
487: PROCEDURE STOP_SERVER
488: (
489: p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
491: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
492:
493: p_server_name IN VARCHAR2,
494: p_node_id IN NUMBER,

Line 491: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

487: PROCEDURE STOP_SERVER
488: (
489: p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
491: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
492:
493: p_server_name IN VARCHAR2,
494: p_node_id IN NUMBER,
495:

Line 509: IF NOT FND_API.Compatible_API_Call

505: BEGIN
506: -- Standard Start of API savepoint
507:
508: -- Standard call to check for call compatibility.
509: IF NOT FND_API.Compatible_API_Call
510: (
511: l_api_version,
512: p_api_version,
513: l_api_name,

Line 517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

513: l_api_name,
514: G_PKG_NAME
515: )
516: THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519:
520: -- Initialize message list if p_init_msg_list is set to TRUE.
521: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 521: IF FND_API.To_Boolean( p_init_msg_list ) THEN

517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519:
520: -- Initialize message list if p_init_msg_list is set to TRUE.
521: IF FND_API.To_Boolean( p_init_msg_list ) THEN
522: FND_MSG_PUB.initialize;
523: END IF;
524:
525: -- Initialize API return status to success

Line 526: x_return_status := FND_API.G_RET_STS_SUCCESS;

522: FND_MSG_PUB.initialize;
523: END IF;
524:
525: -- Initialize API return status to success
526: x_return_status := FND_API.G_RET_STS_SUCCESS;
527:
528: -- API body
529:
530: IF GET_NODE_STATUS(p_node_id) = 0 THEN

Line 566: IF FND_API.To_Boolean( p_commit ) THEN

562:
563: -- End of API body.
564:
565: -- Standard check of p_commit.
566: IF FND_API.To_Boolean( p_commit ) THEN
567: COMMIT WORK;
568: END IF;
569: -- Standard call to get message count and if count is 1, get message info.
570: FND_MSG_PUB.Count_And_Get

Line 576: WHEN FND_API.G_EXC_ERROR THEN

572: p_count => x_msg_count,
573: p_data => x_msg_data
574: );
575: EXCEPTION
576: WHEN FND_API.G_EXC_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_ERROR ;
578: FND_MSG_PUB.Count_And_Get
579: (
580: p_count => x_msg_count,

Line 577: x_return_status := FND_API.G_RET_STS_ERROR ;

573: p_data => x_msg_data
574: );
575: EXCEPTION
576: WHEN FND_API.G_EXC_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_ERROR ;
578: FND_MSG_PUB.Count_And_Get
579: (
580: p_count => x_msg_count,
581: p_data => x_msg_data

Line 583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

579: (
580: p_count => x_msg_count,
581: p_data => x_msg_data
582: );
583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
585: FND_MSG_PUB.Count_And_Get
586: (
587: p_count => x_msg_count,

Line 584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

580: p_count => x_msg_count,
581: p_data => x_msg_data
582: );
583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
585: FND_MSG_PUB.Count_And_Get
586: (
587: p_count => x_msg_count,
588: p_data => x_msg_data

Line 596: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

592:
593: PROCEDURE PING_SERVER
594: (
595: p_api_version IN NUMBER,
596: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
597: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
598:
599: p_server_name IN VARCHAR2,
600: p_node_id IN NUMBER,

Line 597: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

593: PROCEDURE PING_SERVER
594: (
595: p_api_version IN NUMBER,
596: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
597: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
598:
599: p_server_name IN VARCHAR2,
600: p_node_id IN NUMBER,
601: x_status OUT NOCOPY VARCHAR2,

Line 616: IF NOT FND_API.Compatible_API_Call

612: BEGIN
613: -- Standard Start of API savepoint
614:
615: -- Standard call to check for call compatibility.
616: IF NOT FND_API.Compatible_API_Call
617: (
618: l_api_version,
619: p_api_version,
620: l_api_name,

Line 624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

620: l_api_name,
621: G_PKG_NAME
622: )
623: THEN
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END IF;
626:
627: -- Initialize message list if p_init_msg_list is set to TRUE.
628: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 628: IF FND_API.To_Boolean( p_init_msg_list ) THEN

624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END IF;
626:
627: -- Initialize message list if p_init_msg_list is set to TRUE.
628: IF FND_API.To_Boolean( p_init_msg_list ) THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631:
632: -- Initialize API return status to success

Line 633: x_return_status := FND_API.G_RET_STS_SUCCESS;

629: FND_MSG_PUB.initialize;
630: END IF;
631:
632: -- Initialize API return status to success
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: -- API body
636:
637: IF GET_NODE_STATUS(p_node_id) = 0 THEN

Line 673: IF FND_API.To_Boolean( p_commit ) THEN

669:
670: -- End of API body.
671:
672: -- Standard check of p_commit.
673: IF FND_API.To_Boolean( p_commit ) THEN
674: COMMIT WORK;
675: END IF;
676: -- Standard call to get message count and if count is 1, get message info.
677: FND_MSG_PUB.Count_And_Get

Line 684: WHEN FND_API.G_EXC_ERROR THEN

680: p_data => x_msg_data
681: );
682: EXCEPTION
683:
684: WHEN FND_API.G_EXC_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_ERROR ;
686: FND_MSG_PUB.Count_And_Get
687: (
688: p_count => x_msg_count,

Line 685: x_return_status := FND_API.G_RET_STS_ERROR ;

681: );
682: EXCEPTION
683:
684: WHEN FND_API.G_EXC_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_ERROR ;
686: FND_MSG_PUB.Count_And_Get
687: (
688: p_count => x_msg_count,
689: p_data => x_msg_data

Line 691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

687: (
688: p_count => x_msg_count,
689: p_data => x_msg_data
690: );
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: ROLLBACK TO ENQUEUE_REQUEST_PUB;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
694: FND_MSG_PUB.Count_And_Get
695: (

Line 693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

689: p_data => x_msg_data
690: );
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: ROLLBACK TO ENQUEUE_REQUEST_PUB;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
694: FND_MSG_PUB.Count_And_Get
695: (
696: p_count => x_msg_count,
697: p_data => x_msg_data

Line 705: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

701:
702: PROCEDURE SHUTDOWN_ICSM
703: (
704: p_api_version IN NUMBER,
705: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
706: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
707:
708: p_node_id IN NUMBER,
709:

Line 706: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

702: PROCEDURE SHUTDOWN_ICSM
703: (
704: p_api_version IN NUMBER,
705: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
706: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
707:
708: p_node_id IN NUMBER,
709:
710: x_return_status OUT NOCOPY VARCHAR2,

Line 723: IF NOT FND_API.Compatible_API_Call

719: BEGIN
720: -- Standard Start of API savepoint
721:
722: -- Standard call to check for call compatibility.
723: IF NOT FND_API.Compatible_API_Call
724: (
725: l_api_version,
726: p_api_version,
727: l_api_name,

Line 731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

727: l_api_name,
728: G_PKG_NAME
729: )
730: THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 735: IF FND_API.To_Boolean( p_init_msg_list ) THEN

731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.To_Boolean( p_init_msg_list ) THEN
736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- Initialize API return status to success

Line 740: x_return_status := FND_API.G_RET_STS_SUCCESS;

736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- Initialize API return status to success
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741:
742: -- API body
743:
744: IF GET_NODE_STATUS(p_node_id) = 0 THEN

Line 780: IF FND_API.To_Boolean( p_commit ) THEN

776:
777: -- End of API body.
778:
779: -- Standard check of p_commit.
780: IF FND_API.To_Boolean( p_commit ) THEN
781: COMMIT WORK;
782: END IF;
783: -- Standard call to get message count and if count is 1, get message info.
784: FND_MSG_PUB.Count_And_Get

Line 791: WHEN FND_API.G_EXC_ERROR THEN

787: p_data => x_msg_data
788: );
789: EXCEPTION
790:
791: WHEN FND_API.G_EXC_ERROR THEN
792: x_return_status := FND_API.G_RET_STS_ERROR ;
793: FND_MSG_PUB.Count_And_Get
794: (
795: p_count => x_msg_count,

Line 792: x_return_status := FND_API.G_RET_STS_ERROR ;

788: );
789: EXCEPTION
790:
791: WHEN FND_API.G_EXC_ERROR THEN
792: x_return_status := FND_API.G_RET_STS_ERROR ;
793: FND_MSG_PUB.Count_And_Get
794: (
795: p_count => x_msg_count,
796: p_data => x_msg_data

Line 798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

794: (
795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
800: FND_MSG_PUB.Count_And_Get
801: (
802: p_count => x_msg_count,

Line 799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
800: FND_MSG_PUB.Count_And_Get
801: (
802: p_count => x_msg_count,
803: p_data => x_msg_data

Line 811: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

807:
808: PROCEDURE STOP_ALL_SERVER
809: (
810: p_api_version IN NUMBER,
811: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
812: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
813:
814: p_node_id IN NUMBER,
815:

Line 812: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

808: PROCEDURE STOP_ALL_SERVER
809: (
810: p_api_version IN NUMBER,
811: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
812: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
813:
814: p_node_id IN NUMBER,
815:
816: x_return_status OUT NOCOPY VARCHAR2,

Line 829: IF NOT FND_API.Compatible_API_Call

825: BEGIN
826: -- Standard Start of API savepoint
827:
828: -- Standard call to check for call compatibility.
829: IF NOT FND_API.Compatible_API_Call
830: (
831: l_api_version,
832: p_api_version,
833: l_api_name,

Line 837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

833: l_api_name,
834: G_PKG_NAME
835: )
836: THEN
837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
838: END IF;
839:
840: -- Initialize message list if p_init_msg_list is set to TRUE.
841: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 841: IF FND_API.To_Boolean( p_init_msg_list ) THEN

837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
838: END IF;
839:
840: -- Initialize message list if p_init_msg_list is set to TRUE.
841: IF FND_API.To_Boolean( p_init_msg_list ) THEN
842: FND_MSG_PUB.initialize;
843: END IF;
844:
845: -- Initialize API return status to success

Line 846: x_return_status := FND_API.G_RET_STS_SUCCESS;

842: FND_MSG_PUB.initialize;
843: END IF;
844:
845: -- Initialize API return status to success
846: x_return_status := FND_API.G_RET_STS_SUCCESS;
847:
848: -- API body
849:
850: IF GET_NODE_STATUS(p_node_id) = 0 THEN

Line 886: IF FND_API.To_Boolean( p_commit ) THEN

882:
883: -- End of API body.
884:
885: -- Standard check of p_commit.
886: IF FND_API.To_Boolean( p_commit ) THEN
887: COMMIT WORK;
888: END IF;
889: -- Standard call to get message count and if count is 1, get message info.
890: FND_MSG_PUB.Count_And_Get

Line 897: WHEN FND_API.G_EXC_ERROR THEN

893: p_data => x_msg_data
894: );
895: EXCEPTION
896:
897: WHEN FND_API.G_EXC_ERROR THEN
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: FND_MSG_PUB.Count_And_Get
900: (
901: p_count => x_msg_count,

Line 898: x_return_status := FND_API.G_RET_STS_ERROR ;

894: );
895: EXCEPTION
896:
897: WHEN FND_API.G_EXC_ERROR THEN
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: FND_MSG_PUB.Count_And_Get
900: (
901: p_count => x_msg_count,
902: p_data => x_msg_data

Line 904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

900: (
901: p_count => x_msg_count,
902: p_data => x_msg_data
903: );
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
906: FND_MSG_PUB.Count_And_Get
907: (
908: p_count => x_msg_count,

Line 905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

901: p_count => x_msg_count,
902: p_data => x_msg_data
903: );
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
906: FND_MSG_PUB.Count_And_Get
907: (
908: p_count => x_msg_count,
909: p_data => x_msg_data

Line 916: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

912:
913: PROCEDURE GET_LOG_FILES
914: (
915: p_api_version IN NUMBER,
916: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
917: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
918:
919: p_node_id IN NUMBER,
920: p_server_name IN VARCHAR2,

Line 917: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

913: PROCEDURE GET_LOG_FILES
914: (
915: p_api_version IN NUMBER,
916: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
917: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
918:
919: p_node_id IN NUMBER,
920: p_server_name IN VARCHAR2,
921: p_fetch_count IN NUMBER,

Line 938: IF NOT FND_API.Compatible_API_Call

934: BEGIN
935: -- Standard Start of API savepoint
936:
937: -- Standard call to check for call compatibility.
938: IF NOT FND_API.Compatible_API_Call
939: (
940: l_api_version,
941: p_api_version,
942: l_api_name,

Line 946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

942: l_api_name,
943: G_PKG_NAME
944: )
945: THEN
946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
947: END IF;
948:
949: -- Initialize message list if p_init_msg_list is set to TRUE.
950: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 950: IF FND_API.To_Boolean( p_init_msg_list ) THEN

946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
947: END IF;
948:
949: -- Initialize message list if p_init_msg_list is set to TRUE.
950: IF FND_API.To_Boolean( p_init_msg_list ) THEN
951: FND_MSG_PUB.initialize;
952: END IF;
953:
954: -- Initialize API return status to success

Line 955: x_return_status := FND_API.G_RET_STS_SUCCESS;

951: FND_MSG_PUB.initialize;
952: END IF;
953:
954: -- Initialize API return status to success
955: x_return_status := FND_API.G_RET_STS_SUCCESS;
956:
957: -- API body
958:
959: IF GET_NODE_STATUS(p_node_id) = 0 THEN

Line 995: IF FND_API.To_Boolean( p_commit ) THEN

991:
992: -- End of API body.
993:
994: -- Standard check of p_commit.
995: IF FND_API.To_Boolean( p_commit ) THEN
996: COMMIT WORK;
997: END IF;
998: -- Standard call to get message count and if count is 1, get message info.
999: FND_MSG_PUB.Count_And_Get

Line 1006: WHEN FND_API.G_EXC_ERROR THEN

1002: p_data => x_msg_data
1003: );
1004: EXCEPTION
1005:
1006: WHEN FND_API.G_EXC_ERROR THEN
1007: x_return_status := FND_API.G_RET_STS_ERROR ;
1008: FND_MSG_PUB.Count_And_Get
1009: (
1010: p_count => x_msg_count,

Line 1007: x_return_status := FND_API.G_RET_STS_ERROR ;

1003: );
1004: EXCEPTION
1005:
1006: WHEN FND_API.G_EXC_ERROR THEN
1007: x_return_status := FND_API.G_RET_STS_ERROR ;
1008: FND_MSG_PUB.Count_And_Get
1009: (
1010: p_count => x_msg_count,
1011: p_data => x_msg_data

Line 1013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1009: (
1010: p_count => x_msg_count,
1011: p_data => x_msg_data
1012: );
1013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1015: FND_MSG_PUB.Count_And_Get
1016: (
1017: p_count => x_msg_count,

Line 1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1010: p_count => x_msg_count,
1011: p_data => x_msg_data
1012: );
1013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1015: FND_MSG_PUB.Count_And_Get
1016: (
1017: p_count => x_msg_count,
1018: p_data => x_msg_data

Line 1025: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

1021:
1022: PROCEDURE DELETE_FILE
1023: (
1024: p_api_version IN NUMBER,
1025: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
1026: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
1027:
1028: p_node_id IN NUMBER,
1029: p_server_name IN VARCHAR2,

Line 1026: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

1022: PROCEDURE DELETE_FILE
1023: (
1024: p_api_version IN NUMBER,
1025: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
1026: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
1027:
1028: p_node_id IN NUMBER,
1029: p_server_name IN VARCHAR2,
1030: p_file_name IN VARCHAR2,

Line 1045: IF NOT FND_API.Compatible_API_Call

1041: BEGIN
1042: -- Standard Start of API savepoint
1043:
1044: -- Standard call to check for call compatibility.
1045: IF NOT FND_API.Compatible_API_Call
1046: (
1047: l_api_version,
1048: p_api_version,
1049: l_api_name,

Line 1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1049: l_api_name,
1050: G_PKG_NAME
1051: )
1052: THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1055:
1056: -- Initialize message list if p_init_msg_list is set to TRUE.
1057: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 1057: IF FND_API.To_Boolean( p_init_msg_list ) THEN

1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1055:
1056: -- Initialize message list if p_init_msg_list is set to TRUE.
1057: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1058: FND_MSG_PUB.initialize;
1059: END IF;
1060:
1061: -- Initialize API return status to success

Line 1062: x_return_status := FND_API.G_RET_STS_SUCCESS;

1058: FND_MSG_PUB.initialize;
1059: END IF;
1060:
1061: -- Initialize API return status to success
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063:
1064: -- API body
1065:
1066: IF GET_NODE_STATUS(p_node_id) = 0 THEN

Line 1102: IF FND_API.To_Boolean( p_commit ) THEN

1098:
1099: -- End of API body.
1100:
1101: -- Standard check of p_commit.
1102: IF FND_API.To_Boolean( p_commit ) THEN
1103: COMMIT WORK;
1104: END IF;
1105: -- Standard call to get message count and if count is 1, get message info.
1106: FND_MSG_PUB.Count_And_Get

Line 1113: WHEN FND_API.G_EXC_ERROR THEN

1109: p_data => x_msg_data
1110: );
1111: EXCEPTION
1112:
1113: WHEN FND_API.G_EXC_ERROR THEN
1114: x_return_status := FND_API.G_RET_STS_ERROR ;
1115: FND_MSG_PUB.Count_And_Get
1116: (
1117: p_count => x_msg_count,

Line 1114: x_return_status := FND_API.G_RET_STS_ERROR ;

1110: );
1111: EXCEPTION
1112:
1113: WHEN FND_API.G_EXC_ERROR THEN
1114: x_return_status := FND_API.G_RET_STS_ERROR ;
1115: FND_MSG_PUB.Count_And_Get
1116: (
1117: p_count => x_msg_count,
1118: p_data => x_msg_data

Line 1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1116: (
1117: p_count => x_msg_count,
1118: p_data => x_msg_data
1119: );
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1122: FND_MSG_PUB.Count_And_Get
1123: (
1124: p_count => x_msg_count,

Line 1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1117: p_count => x_msg_count,
1118: p_data => x_msg_data
1119: );
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1122: FND_MSG_PUB.Count_And_Get
1123: (
1124: p_count => x_msg_count,
1125: p_data => x_msg_data