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_AQ_PUB dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

3:
4: PROCEDURE ENQUEUE_REQUEST
5: (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
8: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
9:
10: p_node_id IN VARCHAR2,
11: p_xml_data IN VARCHAR2,

Line 8: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

4: PROCEDURE ENQUEUE_REQUEST
5: (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
8: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
9:
10: p_node_id IN VARCHAR2,
11: p_xml_data IN VARCHAR2,
12:

Line 32: IF NOT FND_API.Compatible_API_Call

28: -- Standard Start of API savepoint
29: SAVEPOINT ENQUEUE_REQUEST_PUB;
30:
31: -- Standard call to check for call compatibility.
32: IF NOT FND_API.Compatible_API_Call
33: (
34: l_api_version,
35: p_api_version,
36: l_api_name,

Line 40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

36: l_api_name,
37: G_PKG_NAME
38: )
39: THEN
40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42:
43: -- Initialize message list if p_init_msg_list is set to TRUE.
44: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 44: IF FND_API.To_Boolean( p_init_msg_list ) THEN

40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42:
43: -- Initialize message list if p_init_msg_list is set to TRUE.
44: IF FND_API.To_Boolean( p_init_msg_list ) THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: -- Initialize API return status to success

Line 49: x_return_status := FND_API.G_RET_STS_SUCCESS;

45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: -- Initialize API return status to success
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50:
51: -- API body
52:
53: IF p_xml_data IS NULL then

Line 78: IF FND_API.To_Boolean( p_commit ) THEN

74: x_request_id := request_id ;
75: -- End of API body.
76:
77: -- Standard check of p_commit.
78: IF FND_API.To_Boolean( p_commit ) THEN
79: COMMIT WORK;
80: END IF;
81: -- Standard call to get message count and if count is 1, get message info.
82: FND_MSG_PUB.Count_And_Get

Line 93: x_return_status := FND_API.G_RET_STS_ERROR ;

89: WHEN xml_data_null THEN
90: ROLLBACK TO ENQUEUE_REQUEST_PUB;
91: FND_MESSAGE.SET_NAME('IEO','IEO_AQ_XML_DATA_NULL');
92: FND_MSG_PUB.Add;
93: x_return_status := FND_API.G_RET_STS_ERROR ;
94: WHEN FND_API.G_EXC_ERROR THEN
95: ROLLBACK TO ENQUEUE_REQUEST_PUB;
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: FND_MSG_PUB.Count_And_Get

Line 94: WHEN FND_API.G_EXC_ERROR THEN

90: ROLLBACK TO ENQUEUE_REQUEST_PUB;
91: FND_MESSAGE.SET_NAME('IEO','IEO_AQ_XML_DATA_NULL');
92: FND_MSG_PUB.Add;
93: x_return_status := FND_API.G_RET_STS_ERROR ;
94: WHEN FND_API.G_EXC_ERROR THEN
95: ROLLBACK TO ENQUEUE_REQUEST_PUB;
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: FND_MSG_PUB.Count_And_Get
98: (

Line 96: x_return_status := FND_API.G_RET_STS_ERROR ;

92: FND_MSG_PUB.Add;
93: x_return_status := FND_API.G_RET_STS_ERROR ;
94: WHEN FND_API.G_EXC_ERROR THEN
95: ROLLBACK TO ENQUEUE_REQUEST_PUB;
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: FND_MSG_PUB.Count_And_Get
98: (
99: p_count => x_msg_count,
100: p_data => x_msg_data

Line 102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

98: (
99: p_count => x_msg_count,
100: p_data => x_msg_data
101: );
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103: ROLLBACK TO ENQUEUE_REQUEST_PUB;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
105: FND_MSG_PUB.Count_And_Get
106: (

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

100: p_data => x_msg_data
101: );
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103: ROLLBACK TO ENQUEUE_REQUEST_PUB;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
105: FND_MSG_PUB.Count_And_Get
106: (
107: p_count => x_msg_count,
108: p_data => x_msg_data

Line 112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

108: p_data => x_msg_data
109: );
110: /* WHEN OTHERS THEN
111: ROLLBACK TO ENQUEUE_REQUEST_PUB;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
113: IF FND_MSG_PUB.Check_Msg_Level
114: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
115: THEN
116: FND_MSG_PUB.Add_Exc_Msg

Line 132: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

128:
129: PROCEDURE ENQUEUE_RESPONSE
130: (
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
133: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
134:
135: p_node_id IN NUMBER,
136: p_request_id IN NUMBER,

Line 133: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

129: PROCEDURE ENQUEUE_RESPONSE
130: (
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
133: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
134:
135: p_node_id IN NUMBER,
136: p_request_id IN NUMBER,
137: p_xml_data IN VARCHAR2,

Line 156: IF NOT FND_API.Compatible_API_Call

152: -- Standard Start of API savepoint
153: SAVEPOINT ENQUEUE_RESPONSE_PUB;
154:
155: -- Standard call to check for call compatibility.
156: IF NOT FND_API.Compatible_API_Call
157: (
158: l_api_version,
159: p_api_version,
160: l_api_name,

Line 164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

160: l_api_name,
161: G_PKG_NAME
162: )
163: THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: -- Initialize message list if p_init_msg_list is set to TRUE.
168: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 168: IF FND_API.To_Boolean( p_init_msg_list ) THEN

164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: -- Initialize message list if p_init_msg_list is set to TRUE.
168: IF FND_API.To_Boolean( p_init_msg_list ) THEN
169: FND_MSG_PUB.initialize;
170: END IF;
171:
172: -- Initialize API return status to success

Line 173: x_return_status := FND_API.G_RET_STS_SUCCESS;

169: FND_MSG_PUB.initialize;
170: END IF;
171:
172: -- Initialize API return status to success
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175: -- API body
176:
177: IF p_xml_data IS NULL then

Line 198: IF FND_API.To_Boolean( p_commit ) THEN

194:
195: -- End of API body.
196:
197: -- Standard check of p_commit.
198: IF FND_API.To_Boolean( p_commit ) THEN
199: COMMIT WORK;
200: END IF;
201: -- Standard call to get message count and if count is 1, get message info.
202: FND_MSG_PUB.Count_And_Get

Line 213: x_return_status := FND_API.G_RET_STS_ERROR ;

209: WHEN xml_data_null THEN
210: ROLLBACK TO ENQUEUE_RESPONSE_PUB;
211: FND_MESSAGE.SET_NAME('IEO','IEO_AQ_XML_DATA_NULL');
212: FND_MSG_PUB.Add;
213: x_return_status := FND_API.G_RET_STS_ERROR ;
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO ENQUEUE_RESPONSE_PUB;
216: x_return_status := FND_API.G_RET_STS_ERROR ;
217: FND_MSG_PUB.Count_And_Get

Line 214: WHEN FND_API.G_EXC_ERROR THEN

210: ROLLBACK TO ENQUEUE_RESPONSE_PUB;
211: FND_MESSAGE.SET_NAME('IEO','IEO_AQ_XML_DATA_NULL');
212: FND_MSG_PUB.Add;
213: x_return_status := FND_API.G_RET_STS_ERROR ;
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO ENQUEUE_RESPONSE_PUB;
216: x_return_status := FND_API.G_RET_STS_ERROR ;
217: FND_MSG_PUB.Count_And_Get
218: (

Line 216: x_return_status := FND_API.G_RET_STS_ERROR ;

212: FND_MSG_PUB.Add;
213: x_return_status := FND_API.G_RET_STS_ERROR ;
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO ENQUEUE_RESPONSE_PUB;
216: x_return_status := FND_API.G_RET_STS_ERROR ;
217: FND_MSG_PUB.Count_And_Get
218: (
219: p_count => x_msg_count,
220: p_data => x_msg_data

Line 222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

218: (
219: p_count => x_msg_count,
220: p_data => x_msg_data
221: );
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO ENQUEUE_RESPONSE_PUB;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
225: FND_MSG_PUB.Count_And_Get
226: (

Line 224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

220: p_data => x_msg_data
221: );
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO ENQUEUE_RESPONSE_PUB;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
225: FND_MSG_PUB.Count_And_Get
226: (
227: p_count => x_msg_count,
228: p_data => x_msg_data

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

228: p_data => x_msg_data
229: );
230: /* WHEN OTHERS THEN
231: ROLLBACK TO ENQUEUE_RESPONSE_PUB;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: IF FND_MSG_PUB.Check_Msg_Level
234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg

Line 252: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

248:
249: PROCEDURE DEQUEUE_REQUEST
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_node_id IN NUMBER,
256: p_wait IN NUMBER,

Line 253: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

249: PROCEDURE DEQUEUE_REQUEST
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_node_id IN NUMBER,
256: p_wait IN NUMBER,
257:

Line 278: IF NOT FND_API.Compatible_API_Call

274: -- Standard Start of API savepoint
275: SAVEPOINT DEQUEUE_REQUEST_PUB;
276:
277: -- Standard call to check for call compatibility.
278: IF NOT FND_API.Compatible_API_Call
279: (
280: l_api_version,
281: p_api_version,
282: l_api_name,

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

282: l_api_name,
283: G_PKG_NAME
284: )
285: THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:
289: -- Initialize message list if p_init_msg_list is set to TRUE.
290: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 290: IF FND_API.To_Boolean( p_init_msg_list ) THEN

286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:
289: -- Initialize message list if p_init_msg_list is set to TRUE.
290: IF FND_API.To_Boolean( p_init_msg_list ) THEN
291: FND_MSG_PUB.initialize;
292: END IF;
293:
294: -- Initialize API return status to success

Line 295: x_return_status := FND_API.G_RET_STS_SUCCESS;

291: FND_MSG_PUB.initialize;
292: END IF;
293:
294: -- Initialize API return status to success
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296:
297: -- API body
298:
299: dequeue_options.correlation := p_node_id;

Line 319: WHEN FND_API.G_EXC_ERROR THEN

315:
316: EXCEPTION
317: WHEN no_messages THEN
318: x_return_status := G_TIMEOUT ;
319: WHEN FND_API.G_EXC_ERROR THEN
320: ROLLBACK TO DEQUEUE_REQUEST_PUB;
321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: FND_MSG_PUB.Count_And_Get
323: (

Line 321: x_return_status := FND_API.G_RET_STS_ERROR ;

317: WHEN no_messages THEN
318: x_return_status := G_TIMEOUT ;
319: WHEN FND_API.G_EXC_ERROR THEN
320: ROLLBACK TO DEQUEUE_REQUEST_PUB;
321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: FND_MSG_PUB.Count_And_Get
323: (
324: p_count => x_msg_count,
325: p_data => x_msg_data

Line 327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

323: (
324: p_count => x_msg_count,
325: p_data => x_msg_data
326: );
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: ROLLBACK TO DEQUEUE_REQUEST_PUB;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
330: FND_MSG_PUB.Count_And_Get
331: (

Line 329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

325: p_data => x_msg_data
326: );
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: ROLLBACK TO DEQUEUE_REQUEST_PUB;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
330: FND_MSG_PUB.Count_And_Get
331: (
332: p_count => x_msg_count,
333: p_data => x_msg_data

Line 337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

333: p_data => x_msg_data
334: );
335: /* WHEN OTHERS THEN
336: ROLLBACK TO DEQUEUE_REQUEST_PUB;
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
338: IF FND_MSG_PUB.Check_Msg_Level
339: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
340: THEN
341: FND_MSG_PUB.Add_Exc_Msg

Line 358: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

354:
355: PROCEDURE DEQUEUE_RESPONSE
356: (
357: p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
359: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
360:
361: p_request_id IN NUMBER,
362: p_wait IN NUMBER,

Line 359: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

355: PROCEDURE DEQUEUE_RESPONSE
356: (
357: p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
359: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
360:
361: p_request_id IN NUMBER,
362: p_wait IN NUMBER,
363:

Line 383: IF NOT FND_API.Compatible_API_Call

379: -- Standard Start of API savepoint
380: SAVEPOINT DEQUEUE_RESPONSE_PUB;
381:
382: -- Standard call to check for call compatibility.
383: IF NOT FND_API.Compatible_API_Call
384: (
385: l_api_version,
386: p_api_version,
387: l_api_name,

Line 391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

387: l_api_name,
388: G_PKG_NAME
389: )
390: THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: END IF;
393:
394: -- Initialize message list if p_init_msg_list is set to TRUE.
395: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 395: IF FND_API.To_Boolean( p_init_msg_list ) THEN

391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: END IF;
393:
394: -- Initialize message list if p_init_msg_list is set to TRUE.
395: IF FND_API.To_Boolean( p_init_msg_list ) THEN
396: FND_MSG_PUB.initialize;
397: END IF;
398:
399: -- Initialize API return status to success

Line 400: x_return_status := FND_API.G_RET_STS_SUCCESS;

396: FND_MSG_PUB.initialize;
397: END IF;
398:
399: -- Initialize API return status to success
400: x_return_status := FND_API.G_RET_STS_SUCCESS;
401:
402: -- API body
403:
404: --DBMS_OUTPUT.put_line('before dequeuing in dequeue response');

Line 427: WHEN FND_API.G_EXC_ERROR THEN

423: EXCEPTION
424: WHEN no_messages THEN
425: --DBMS_OUTPUT.put_line('timeout dequeuing response');
426: x_return_status := G_TIMEOUT;
427: WHEN FND_API.G_EXC_ERROR THEN
428: ROLLBACK TO DEQUEUE_RESPONSE_PUB;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get
431: (

Line 429: x_return_status := FND_API.G_RET_STS_ERROR ;

425: --DBMS_OUTPUT.put_line('timeout dequeuing response');
426: x_return_status := G_TIMEOUT;
427: WHEN FND_API.G_EXC_ERROR THEN
428: ROLLBACK TO DEQUEUE_RESPONSE_PUB;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get
431: (
432: p_count => x_msg_count,
433: p_data => x_msg_data

Line 435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

431: (
432: p_count => x_msg_count,
433: p_data => x_msg_data
434: );
435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
436: ROLLBACK TO DEQUEUE_RESPONSE_PUB;
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: FND_MSG_PUB.Count_And_Get
439: (

Line 437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

433: p_data => x_msg_data
434: );
435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
436: ROLLBACK TO DEQUEUE_RESPONSE_PUB;
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: FND_MSG_PUB.Count_And_Get
439: (
440: p_count => x_msg_count,
441: p_data => x_msg_data

Line 445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

441: p_data => x_msg_data
442: );
443: /* WHEN OTHERS THEN
444: ROLLBACK TO DEQUEUE_RESPONSE_PUB;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
446: IF FND_MSG_PUB.Check_Msg_Level
447: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
448: THEN
449: FND_MSG_PUB.Add_Exc_Msg