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

Line 65: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

61: BEGIN
62: -- Standard Start of API savepoint
63: SAVEPOINT ENQUEUE_ITEM_PUB;
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
66: p_api_version ,
67: l_api_name ,
68: G_PKG_NAME )
69: THEN

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

66: p_api_version ,
67: l_api_name ,
68: G_PKG_NAME )
69: THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF FND_API.To_Boolean( p_init_msg_list ) THEN
74: FND_MSG_PUB.initialize;

Line 73: IF FND_API.To_Boolean( p_init_msg_list ) THEN

69: THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF FND_API.To_Boolean( p_init_msg_list ) THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76: -- Initialize API return status to success
77: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73: IF FND_API.To_Boolean( p_init_msg_list ) THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76: -- Initialize API return status to success
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78: x_msg_data := 'CCT_AQ_SUCCESS';
79: x_msg_count := 0;
80: -- API body
81: IF p_server_group_name IS NULL then

Line 126: IF FND_API.To_Boolean( p_commit ) THEN

122: --dbms_output.put_line ('ENQUEUE_ITEM: Enqueue done');
123:
124: -- End of API body.
125: -- Standard check of p_commit.
126: IF FND_API.To_Boolean( p_commit ) THEN
127: COMMIT WORK;
128: END IF;
129:
130: EXCEPTION

Line 135: x_return_status := FND_API.G_RET_STS_ERROR;

131:
132: WHEN server_group_id_null THEN
133: ROLLBACK TO ENQUEUE_ITEM_PUB;
134: x_msg_data := 'CCT_AQ_SERVER_GROUP_ID_NULL' ;
135: x_return_status := FND_API.G_RET_STS_ERROR;
136: x_msg_count := 1;
137:
138: WHEN server_group_name_null THEN
139: ROLLBACK TO ENQUEUE_ITEM_PUB;

Line 141: x_return_status := FND_API.G_RET_STS_ERROR;

137:
138: WHEN server_group_name_null THEN
139: ROLLBACK TO ENQUEUE_ITEM_PUB;
140: x_msg_data := 'CCT_AQ_SERVER_GROUP_NAME_NULL';
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: x_msg_count := 1;
143:
144: WHEN xml_data1_null THEN
145: ROLLBACK TO ENQUEUE_ITEM_PUB;

Line 147: x_return_status := FND_API.G_RET_STS_ERROR;

143:
144: WHEN xml_data1_null THEN
145: ROLLBACK TO ENQUEUE_ITEM_PUB;
146: x_msg_data := 'CCT_AQ_XML_DATA1_NULL';
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: x_msg_count := 1;
149:
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO ENQUEUE_ITEM_PUB;

Line 150: WHEN FND_API.G_EXC_ERROR THEN

146: x_msg_data := 'CCT_AQ_XML_DATA1_NULL';
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: x_msg_count := 1;
149:
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO ENQUEUE_ITEM_PUB;
152: x_msg_data := 'CCT_AQ_ERROR';
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: x_msg_count := 1;

Line 153: x_return_status := FND_API.G_RET_STS_ERROR;

149:
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO ENQUEUE_ITEM_PUB;
152: x_msg_data := 'CCT_AQ_ERROR';
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: x_msg_count := 1;
155:
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO ENQUEUE_ITEM_PUB;

Line 156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

152: x_msg_data := 'CCT_AQ_ERROR';
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: x_msg_count := 1;
155:
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO ENQUEUE_ITEM_PUB;
158: x_msg_data := 'CCT_AQ_ERROR';
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: x_msg_count := 1;

Line 159: x_return_status := FND_API.G_RET_STS_ERROR;

155:
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO ENQUEUE_ITEM_PUB;
158: x_msg_data := 'CCT_AQ_ERROR';
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: x_msg_count := 1;
161:
162: WHEN OTHERS THEN
163: ROLLBACK TO ENQUEUE_ITEM_PUB;

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161:
162: WHEN OTHERS THEN
163: ROLLBACK TO ENQUEUE_ITEM_PUB;
164: x_msg_data := 'CCT_AQ_ERROR';
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: x_msg_count := 1;
167:
168: END ENQUEUE_ITEM;
169:

Line 188: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

184: server_group_name_null EXCEPTION;
185:
186: BEGIN
187:
188: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
189: p_api_version ,
190: l_api_name ,
191: G_PKG_NAME )
192: THEN

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

189: p_api_version ,
190: l_api_name ,
191: G_PKG_NAME )
192: THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195: -- Initialize message list if p_init_msg_list is set to TRUE.
196: IF FND_API.to_Boolean( p_init_msg_list ) THEN
197: FND_MSG_PUB.initialize;

Line 196: IF FND_API.to_Boolean( p_init_msg_list ) THEN

192: THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195: -- Initialize message list if p_init_msg_list is set to TRUE.
196: IF FND_API.to_Boolean( p_init_msg_list ) THEN
197: FND_MSG_PUB.initialize;
198: END IF;
199: -- Initialize API return status to success
200: -- Initialize API return status to succes

Line 201: x_return_status := FND_API.G_RET_STS_SUCCESS;

197: FND_MSG_PUB.initialize;
198: END IF;
199: -- Initialize API return status to success
200: -- Initialize API return status to succes
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202: x_msg_data := 'CCT_AQ_SUCCESS';
203: x_msg_count := 0;
204:
205: -- API body

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

223: x_root_server_group_name := curr_server_group_name;
224:
225: WHEN server_group_name_null THEN
226: x_msg_data := 'CCT_AQ_SERVER_GROUP_ID_NULL';
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: x_msg_count := 1;
229:
230: WHEN FND_API.G_EXC_ERROR THEN
231: x_msg_data := 'CCT_AQ_ERROR';

Line 230: WHEN FND_API.G_EXC_ERROR THEN

226: x_msg_data := 'CCT_AQ_SERVER_GROUP_ID_NULL';
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: x_msg_count := 1;
229:
230: WHEN FND_API.G_EXC_ERROR THEN
231: x_msg_data := 'CCT_AQ_ERROR';
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: x_msg_count := 1;
234:

Line 232: x_return_status := FND_API.G_RET_STS_ERROR;

228: x_msg_count := 1;
229:
230: WHEN FND_API.G_EXC_ERROR THEN
231: x_msg_data := 'CCT_AQ_ERROR';
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: x_msg_count := 1;
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: x_msg_data := 'CCT_AQ_ERROR';

Line 235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

231: x_msg_data := 'CCT_AQ_ERROR';
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: x_msg_count := 1;
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: x_msg_data := 'CCT_AQ_ERROR';
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: x_msg_count := 1;
239:

Line 237: x_return_status := FND_API.G_RET_STS_ERROR;

233: x_msg_count := 1;
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: x_msg_data := 'CCT_AQ_ERROR';
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: x_msg_count := 1;
239:
240: WHEN OTHERS THEN
241: x_msg_data := 'CCT_AQ_ERROR';

Line 242: x_return_status := FND_API.G_RET_STS_ERROR;

238: x_msg_count := 1;
239:
240: WHEN OTHERS THEN
241: x_msg_data := 'CCT_AQ_ERROR';
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: x_msg_count := 1;
244:
245: END GET_ROOT_GROUP_NAME;
246:

Line 273: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

269: BEGIN
270: -- Standard Start of API savepoint
271: SAVEPOINT DEQUEUE_ITEM_PUB;
272: -- Standard call to check for call compatibility.
273: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
274: p_api_version ,
275: l_api_name ,
276: G_PKG_NAME )
277: THEN

Line 278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

274: p_api_version ,
275: l_api_name ,
276: G_PKG_NAME )
277: THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280: -- Initialize message list if p_init_msg_list is set to TRUE.
281: IF FND_API.to_Boolean( p_init_msg_list ) THEN
282: FND_MSG_PUB.initialize;

Line 281: IF FND_API.to_Boolean( p_init_msg_list ) THEN

277: THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280: -- Initialize message list if p_init_msg_list is set to TRUE.
281: IF FND_API.to_Boolean( p_init_msg_list ) THEN
282: FND_MSG_PUB.initialize;
283: END IF;
284: -- Initialize API return status to success
285: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 285: x_return_status := FND_API.G_RET_STS_SUCCESS;

281: IF FND_API.to_Boolean( p_init_msg_list ) THEN
282: FND_MSG_PUB.initialize;
283: END IF;
284: -- Initialize API return status to success
285: x_return_status := FND_API.G_RET_STS_SUCCESS;
286: x_msg_data := 'CCT_AQ_SUCCESS';
287: x_msg_count := 0;
288:
289: -- API body

Line 313: IF FND_API.To_Boolean( p_commit ) THEN

309: --dbms_output.put_line('DEQUEUE_ITEM: Select done');
310:
311: -- End of API body.
312: -- Standard check of p_commit.
313: IF FND_API.To_Boolean( p_commit ) THEN
314: COMMIT WORK;
315: END IF;
316:
317: EXCEPTION

Line 323: x_return_status := FND_API.G_RET_STS_ERROR;

319: x_return_status := G_TIMEOUT ;
320: WHEN server_group_id_null THEN
321: ROLLBACK TO DEQUEUE_ITEM_PUB;
322: x_msg_data := 'CCT_AQ_SERVER_GROUP_ID_NULL';
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: x_msg_count := 1;
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO DEQUEUE_ITEM_PUB;
327: x_msg_data := 'CCT_AQ_ERROR';

Line 325: WHEN FND_API.G_EXC_ERROR THEN

321: ROLLBACK TO DEQUEUE_ITEM_PUB;
322: x_msg_data := 'CCT_AQ_SERVER_GROUP_ID_NULL';
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: x_msg_count := 1;
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO DEQUEUE_ITEM_PUB;
327: x_msg_data := 'CCT_AQ_ERROR';
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: x_msg_count := 1;

Line 328: x_return_status := FND_API.G_RET_STS_ERROR;

324: x_msg_count := 1;
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO DEQUEUE_ITEM_PUB;
327: x_msg_data := 'CCT_AQ_ERROR';
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: x_msg_count := 1;
330:
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: --dbms_output.put_line('Unexpected error');

Line 331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

327: x_msg_data := 'CCT_AQ_ERROR';
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: x_msg_count := 1;
330:
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: --dbms_output.put_line('Unexpected error');
333: ROLLBACK TO DEQUEUE_ITEM_PUB;
334: x_msg_data := 'CCT_AQ_ERROR';
335: x_return_status := FND_API.G_RET_STS_ERROR;

Line 335: x_return_status := FND_API.G_RET_STS_ERROR;

331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: --dbms_output.put_line('Unexpected error');
333: ROLLBACK TO DEQUEUE_ITEM_PUB;
334: x_msg_data := 'CCT_AQ_ERROR';
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: x_msg_count := 1;
337:
338: WHEN OTHERS THEN
339: ROLLBACK TO DEQUEUE_ITEM_PUB;

Line 341: x_return_status := FND_API.G_RET_STS_ERROR;

337:
338: WHEN OTHERS THEN
339: ROLLBACK TO DEQUEUE_ITEM_PUB;
340: x_msg_data := 'CCT_AQ_ERROR';
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: x_msg_count := 1;
343:
344: END DEQUEUE_ITEM;
345:

Line 416: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

412: BEGIN
413: -- Standard Start of API savepoint
414: SAVEPOINT ENQUEUE_WEB_CALLBACK_ITEM_PUB;
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
417: p_api_version ,
418: l_api_name ,
419: G_PKG_NAME )
420: THEN

Line 421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

417: p_api_version ,
418: l_api_name ,
419: G_PKG_NAME )
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423: -- Initialize message list if p_init_msg_list is set to TRUE.
424: IF FND_API.To_Boolean( p_init_msg_list ) THEN
425: FND_MSG_PUB.initialize;

Line 424: IF FND_API.To_Boolean( p_init_msg_list ) THEN

420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423: -- Initialize message list if p_init_msg_list is set to TRUE.
424: IF FND_API.To_Boolean( p_init_msg_list ) THEN
425: FND_MSG_PUB.initialize;
426: END IF;
427: -- Initialize API return status to success
428: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 428: x_return_status := FND_API.G_RET_STS_SUCCESS;

424: IF FND_API.To_Boolean( p_init_msg_list ) THEN
425: FND_MSG_PUB.initialize;
426: END IF;
427: -- Initialize API return status to success
428: x_return_status := FND_API.G_RET_STS_SUCCESS;
429: x_msg_data := 'CCT_AQ_SUCCESS';
430: x_msg_count := 0;
431: -- API body
432:

Line 638: IF FND_API.To_Boolean( p_commit ) THEN

634: END;
635: END IF;
636:
637:
638: IF FND_API.To_Boolean( p_commit ) THEN
639: COMMIT WORK;
640: END IF;
641:
642:

Line 648: x_return_status := FND_API.G_RET_STS_ERROR;

644:
645: WHEN web_callback_false THEN
646: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
647: x_msg_data := 'CCT_AQ_WEB_CALLBACK_FALSE';
648: x_return_status := FND_API.G_RET_STS_ERROR;
649: x_msg_count := 1;
650: WHEN server_group_name_null THEN
651: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
652: x_msg_data := 'CCT_AQ_SERVER_GROUP_NAME_NULL';

Line 653: x_return_status := FND_API.G_RET_STS_ERROR;

649: x_msg_count := 1;
650: WHEN server_group_name_null THEN
651: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
652: x_msg_data := 'CCT_AQ_SERVER_GROUP_NAME_NULL';
653: x_return_status := FND_API.G_RET_STS_ERROR;
654: x_msg_count := 1;
655: WHEN country_code_null THEN
656: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
657: x_msg_data := 'CCT_AQ_COUNTRY_CODE_NULL';

Line 658: x_return_status := FND_API.G_RET_STS_ERROR;

654: x_msg_count := 1;
655: WHEN country_code_null THEN
656: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
657: x_msg_data := 'CCT_AQ_COUNTRY_CODE_NULL';
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: x_msg_count := 1;
660: WHEN area_code_null THEN
661: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
662: x_msg_data := 'CCT_AQ_AREA_CODE_NULL';

Line 663: x_return_status := FND_API.G_RET_STS_ERROR;

659: x_msg_count := 1;
660: WHEN area_code_null THEN
661: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
662: x_msg_data := 'CCT_AQ_AREA_CODE_NULL';
663: x_return_status := FND_API.G_RET_STS_ERROR;
664: x_msg_count := 1;
665: WHEN phone_number_null THEN
666: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
667: x_msg_data := 'CCT_AQ_PHONE_NUMBER_NULL';

Line 668: x_return_status := FND_API.G_RET_STS_ERROR;

664: x_msg_count := 1;
665: WHEN phone_number_null THEN
666: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
667: x_msg_data := 'CCT_AQ_PHONE_NUMBER_NULL';
668: x_return_status := FND_API.G_RET_STS_ERROR;
669: x_msg_count := 1;
670: WHEN FND_API.G_EXC_ERROR THEN
671: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
672: x_msg_data := 'CCT_AQ_ERROR' || SQLCODE || SUBSTR(SQLERRM, 1, 100);

Line 670: WHEN FND_API.G_EXC_ERROR THEN

666: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
667: x_msg_data := 'CCT_AQ_PHONE_NUMBER_NULL';
668: x_return_status := FND_API.G_RET_STS_ERROR;
669: x_msg_count := 1;
670: WHEN FND_API.G_EXC_ERROR THEN
671: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
672: x_msg_data := 'CCT_AQ_ERROR' || SQLCODE || SUBSTR(SQLERRM, 1, 100);
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: x_msg_count := 1;

Line 673: x_return_status := FND_API.G_RET_STS_ERROR;

669: x_msg_count := 1;
670: WHEN FND_API.G_EXC_ERROR THEN
671: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
672: x_msg_data := 'CCT_AQ_ERROR' || SQLCODE || SUBSTR(SQLERRM, 1, 100);
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: x_msg_count := 1;
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
677: x_msg_data := 'CCT_AQ_ERROR' || SQLCODE || SUBSTR(SQLERRM, 1, 100);

Line 675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

671: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
672: x_msg_data := 'CCT_AQ_ERROR' || SQLCODE || SUBSTR(SQLERRM, 1, 100);
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: x_msg_count := 1;
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
677: x_msg_data := 'CCT_AQ_ERROR' || SQLCODE || SUBSTR(SQLERRM, 1, 100);
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: x_msg_count := 1;

Line 678: x_return_status := FND_API.G_RET_STS_ERROR;

674: x_msg_count := 1;
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
677: x_msg_data := 'CCT_AQ_ERROR' || SQLCODE || SUBSTR(SQLERRM, 1, 100);
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: x_msg_count := 1;
680: WHEN OTHERS THEN
681: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
682: x_msg_data := 'CCT_AQ_ERROR' || SQLCODE || SUBSTR(SQLERRM, 1, 100);

Line 683: x_return_status := FND_API.G_RET_STS_ERROR;

679: x_msg_count := 1;
680: WHEN OTHERS THEN
681: ROLLBACK TO ENQUEUE_WEB_CALLBACK_ITEM_PUB;
682: x_msg_data := 'CCT_AQ_ERROR' || SQLCODE || SUBSTR(SQLERRM, 1, 100);
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: x_msg_count := 1;
685: END ENQUEUE_WEB_CALLBACK_ITEM;
686:
687:

Line 752: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

748: BEGIN
749: -- Standard Start of API savepoint
750: SAVEPOINT ENQUEUE_WEB_COLLAB_ITEM_PUB;
751: -- Standard call to check for call compatibility.
752: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
753: p_api_version ,
754: l_api_name ,
755: G_PKG_NAME )
756: THEN

Line 757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

753: p_api_version ,
754: l_api_name ,
755: G_PKG_NAME )
756: THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.To_Boolean( p_init_msg_list ) THEN
761: FND_MSG_PUB.initialize;

Line 760: IF FND_API.To_Boolean( p_init_msg_list ) THEN

756: THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.To_Boolean( p_init_msg_list ) THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763: -- Initialize API return status to success
764:

Line 765: x_return_status := FND_API.G_RET_STS_SUCCESS;

761: FND_MSG_PUB.initialize;
762: END IF;
763: -- Initialize API return status to success
764:
765: x_return_status := FND_API.G_RET_STS_SUCCESS;
766: x_msg_data := 'CCT_AQ_SUCCESS';
767: x_msg_count := 0;
768:
769: -- API body

Line 783: IF (p_with_callback = FND_API.G_TRUE) THEN

779: IF (p_ih_media_item_id = -1) THEN
780: raise ih_media_item_id_null;
781: END IF;
782:
783: IF (p_with_callback = FND_API.G_TRUE) THEN
784: IF (p_phone_number IS NULL) THEN
785: raise phone_number_null;
786: END IF;
787: END IF;

Line 890: IF FND_API.To_Boolean( p_commit ) THEN

886:
887: --dbms_output.put_line('ENQUEUE_WEB_COLLAB_ITEM: Enqueue done!');
888: --End of API body.
889: --Standard check of p_commit.
890: IF FND_API.To_Boolean( p_commit ) THEN
891: COMMIT WORK;
892: END IF;
893:
894: EXCEPTION

Line 899: x_return_status := FND_API.G_RET_STS_ERROR;

895:
896: WHEN server_group_undefined THEN
897: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;
898: x_msg_data := 'CCT_AQ_SERVER_GROUP_NAME_NULL';
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: x_msg_count := 1;
901:
902: WHEN meeting_url_null THEN
903: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;

Line 905: x_return_status := FND_API.G_RET_STS_ERROR;

901:
902: WHEN meeting_url_null THEN
903: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;
904: x_msg_data := 'CCT_AQ_MEETING_URL_NULL';
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: x_msg_count := 1;
907:
908: WHEN ih_media_item_id_null THEN
909: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;

Line 911: x_return_status := FND_API.G_RET_STS_ERROR;

907:
908: WHEN ih_media_item_id_null THEN
909: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;
910: x_msg_data := 'CCT_AQ_IH_MEDIA_ITEM_ID_NULL';
911: x_return_status := FND_API.G_RET_STS_ERROR;
912: x_msg_count := 1;
913:
914: WHEN phone_number_null THEN
915: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;

Line 917: x_return_status := FND_API.G_RET_STS_ERROR;

913:
914: WHEN phone_number_null THEN
915: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;
916: x_msg_data := 'CCT_AQ_PHONE_NUMBER_NULL';
917: x_return_status := FND_API.G_RET_STS_ERROR;
918: x_msg_count := 1;
919:
920: WHEN FND_API.G_EXC_ERROR THEN
921: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;

Line 920: WHEN FND_API.G_EXC_ERROR THEN

916: x_msg_data := 'CCT_AQ_PHONE_NUMBER_NULL';
917: x_return_status := FND_API.G_RET_STS_ERROR;
918: x_msg_count := 1;
919:
920: WHEN FND_API.G_EXC_ERROR THEN
921: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;
922: x_msg_data := 'CCT_AQ_ERROR';
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: x_msg_count := 1;

Line 923: x_return_status := FND_API.G_RET_STS_ERROR;

919:
920: WHEN FND_API.G_EXC_ERROR THEN
921: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;
922: x_msg_data := 'CCT_AQ_ERROR';
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: x_msg_count := 1;
925:
926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
927: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;

Line 926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

922: x_msg_data := 'CCT_AQ_ERROR';
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: x_msg_count := 1;
925:
926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
927: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;
928: x_msg_data := 'CCT_AQ_ERROR';
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: x_msg_count := 1;

Line 929: x_return_status := FND_API.G_RET_STS_ERROR;

925:
926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
927: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;
928: x_msg_data := 'CCT_AQ_ERROR';
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: x_msg_count := 1;
931:
932: WHEN OTHERS THEN
933: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;

Line 935: x_return_status := FND_API.G_RET_STS_ERROR;

931:
932: WHEN OTHERS THEN
933: ROLLBACK TO ENQUEUE_WEB_COLLAB_ITEM_PUB;
934: x_msg_data := 'CCT_AQ_ERROR';
935: x_return_status := FND_API.G_RET_STS_ERROR;
936: x_msg_count := 1;
937:
938: END ENQUEUE_WEB_COLLAB_ITEM;
939:

Line 966: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

962: BEGIN
963: -- Standard Start of API savepoint
964: SAVEPOINT ABANDON_MEDIA_PUB;
965: -- Standard call to check for call compatibility.
966: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
967: p_api_version ,
968: l_api_name ,
969: G_PKG_NAME )
970: THEN

Line 971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

967: p_api_version ,
968: l_api_name ,
969: G_PKG_NAME )
970: THEN
971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
972: END IF;
973: -- Initialize message list if p_init_msg_list is set to TRUE.
974: IF FND_API.To_Boolean( p_init_msg_list ) THEN
975: FND_MSG_PUB.initialize;

Line 974: IF FND_API.To_Boolean( p_init_msg_list ) THEN

970: THEN
971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
972: END IF;
973: -- Initialize message list if p_init_msg_list is set to TRUE.
974: IF FND_API.To_Boolean( p_init_msg_list ) THEN
975: FND_MSG_PUB.initialize;
976: END IF;
977: -- Initialize API return status to success
978: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 978: x_return_status := FND_API.G_RET_STS_SUCCESS;

974: IF FND_API.To_Boolean( p_init_msg_list ) THEN
975: FND_MSG_PUB.initialize;
976: END IF;
977: -- Initialize API return status to success
978: x_return_status := FND_API.G_RET_STS_SUCCESS;
979: x_msg_data := 'CCT_AQ_SUCCESS';
980: x_msg_count := 0;
981:
982: -- API body

Line 1021: IF FND_API.To_Boolean( p_commit ) THEN

1017:
1018: --dbms_output.put_line('ABANDON_MEDIA: Enqueue done!');
1019: --End of API body.
1020: --Standard check of p_commit.
1021: IF FND_API.To_Boolean( p_commit ) THEN
1022: COMMIT WORK;
1023: END IF;
1024:
1025: EXCEPTION

Line 1030: x_return_status := FND_API.G_RET_STS_ERROR;

1026:
1027: WHEN server_group_name_null THEN
1028: ROLLBACK TO ABANDON_MEDIA_PUB;
1029: x_msg_data := 'CCT_AQ_SERVER_GROUP_NAME_NULL';
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: x_msg_count := 1;
1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO ABANDON_MEDIA_PUB;

Line 1033: WHEN FND_API.G_EXC_ERROR THEN

1029: x_msg_data := 'CCT_AQ_SERVER_GROUP_NAME_NULL';
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: x_msg_count := 1;
1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO ABANDON_MEDIA_PUB;
1035: x_msg_data := 'CCT_AQ_ERROR';
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: x_msg_count := 1;

Line 1036: x_return_status := FND_API.G_RET_STS_ERROR;

1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO ABANDON_MEDIA_PUB;
1035: x_msg_data := 'CCT_AQ_ERROR';
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: x_msg_count := 1;
1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040: ROLLBACK TO ABANDON_MEDIA_PUB;

Line 1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1035: x_msg_data := 'CCT_AQ_ERROR';
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: x_msg_count := 1;
1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040: ROLLBACK TO ABANDON_MEDIA_PUB;
1041: x_msg_data := 'CCT_AQ_ERROR';
1042: x_return_status := FND_API.G_RET_STS_ERROR;
1043: x_msg_count := 1;

Line 1042: x_return_status := FND_API.G_RET_STS_ERROR;

1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040: ROLLBACK TO ABANDON_MEDIA_PUB;
1041: x_msg_data := 'CCT_AQ_ERROR';
1042: x_return_status := FND_API.G_RET_STS_ERROR;
1043: x_msg_count := 1;
1044:
1045: WHEN OTHERS THEN
1046: ROLLBACK TO ABANDON_MEDIA_PUB;

Line 1048: x_return_status := FND_API.G_RET_STS_ERROR;

1044:
1045: WHEN OTHERS THEN
1046: ROLLBACK TO ABANDON_MEDIA_PUB;
1047: x_msg_data := 'CCT_AQ_ERROR';
1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: x_msg_count := 1;
1050:
1051: END ABANDON_MEDIA;
1052: