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

Line 56: x_return_status := fnd_api.g_ret_sts_success;

52: Begin
53:
54:
55: SAVEPOINT purge_task_attach;
56: x_return_status := fnd_api.g_ret_sts_success;
57:
58:
59:
60: Open c_fetch_task_ids;

Line 88: WHEN fnd_api.g_exc_unexpected_error

84:
85: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
86:
87: EXCEPTION
88: WHEN fnd_api.g_exc_unexpected_error
89: THEN
90: ROLLBACK TO purge_task_attach;
91: x_return_status := fnd_api.g_ret_sts_unexp_error;
92: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 91: x_return_status := fnd_api.g_ret_sts_unexp_error;

87: EXCEPTION
88: WHEN fnd_api.g_exc_unexpected_error
89: THEN
90: ROLLBACK TO purge_task_attach;
91: x_return_status := fnd_api.g_ret_sts_unexp_error;
92: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
93: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
94: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_return_status= '||x_return_status);
95: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_msg_data= '||x_msg_data);

Line 111: x_return_status := fnd_api.g_ret_sts_unexp_error;

107: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_msg_data= '||x_msg_data);
108: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_msg_count= '||x_msg_count);
109: end if;
110:
111: x_return_status := fnd_api.g_ret_sts_unexp_error;
112: fnd_msg_pub.count_and_get (
113: p_count => x_msg_count,
114: p_data => x_msg_data
115: );

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

117: end delete_atth_to_tasks;
118:
119: Procedure purge_tasks(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
122: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,

Line 122: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

118:
119: Procedure purge_tasks(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
122: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: p_object_type IN VARCHAR2,

Line 152: x_return_status := fnd_api.g_ret_sts_success;

148: l_msg_index_out VARCHAR2(100);
149: BEGIN
150:
151: SAVEPOINT purge_tasks;
152: x_return_status := fnd_api.g_ret_sts_success;
153:
154: IF NOT fnd_api.compatible_api_call (
155: l_api_version,
156: p_api_version,

Line 154: IF NOT fnd_api.compatible_api_call (

150:
151: SAVEPOINT purge_tasks;
152: x_return_status := fnd_api.g_ret_sts_success;
153:
154: IF NOT fnd_api.compatible_api_call (
155: l_api_version,
156: p_api_version,
157: l_api_name,
158: g_pkg_name

Line 161: RAISE fnd_api.g_exc_unexpected_error;

157: l_api_name,
158: g_pkg_name
159: )
160: THEN
161: RAISE fnd_api.g_exc_unexpected_error;
162: END IF;
163:
164: IF fnd_api.to_boolean (p_init_msg_list)
165: THEN

Line 164: IF fnd_api.to_boolean (p_init_msg_list)

160: THEN
161: RAISE fnd_api.g_exc_unexpected_error;
162: END IF;
163:
164: IF fnd_api.to_boolean (p_init_msg_list)
165: THEN
166: fnd_msg_pub.initialize;
167: END IF;
168: --Logging input parameters

Line 212: P_INIT_MSG_LIST => FND_API.G_FALSE,

208: end if;
209:
210: CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS(
211: P_API_VERSION => 1.0,
212: P_INIT_MSG_LIST => FND_API.G_FALSE,
213: P_COMMIT => FND_API.G_FALSE,
214: P_PROCESSING_SET_ID => proc_seq_num ,
215: P_OBJECT_TYPE => 'TASK' ,
216: X_RETURN_STATUS => x_return_status,

Line 213: P_COMMIT => FND_API.G_FALSE,

209:
210: CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS(
211: P_API_VERSION => 1.0,
212: P_INIT_MSG_LIST => FND_API.G_FALSE,
213: P_COMMIT => FND_API.G_FALSE,
214: P_PROCESSING_SET_ID => proc_seq_num ,
215: P_OBJECT_TYPE => 'TASK' ,
216: X_RETURN_STATUS => x_return_status,
217: X_MSG_COUNT => x_msg_count,

Line 220: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

216: X_RETURN_STATUS => x_return_status,
217: X_MSG_COUNT => x_msg_count,
218: X_MSG_DATA => x_msg_data);
219:
220: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
221: THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223:
224: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 222: x_return_status := fnd_api.g_ret_sts_unexp_error;

218: X_MSG_DATA => x_msg_data);
219:
220: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
221: THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223:
224: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
225: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', 'return status error after calling CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS');
226: end if;

Line 227: RAISE fnd_api.g_exc_unexpected_error;

223:
224: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
225: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', 'return status error after calling CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS');
226: end if;
227: RAISE fnd_api.g_exc_unexpected_error;
228: end if;
229:
230: /************* Start of addition by SBARAT on 03/02/2006 for bug# 4997851 *************/
231:

Line 241: p_init_msg_list => FND_API.G_FALSE,

237: END IF;
238:
239: IEU_WR_PUB.Purge_Wr_Item(
240: p_api_version_number => 1.0,
241: p_init_msg_list => FND_API.G_FALSE,
242: p_commit => FND_API.G_FALSE,
243: p_processing_set_id => proc_seq_num,
244: p_object_type => 'TASK',
245: x_return_status => x_return_status,

Line 242: p_commit => FND_API.G_FALSE,

238:
239: IEU_WR_PUB.Purge_Wr_Item(
240: p_api_version_number => 1.0,
241: p_init_msg_list => FND_API.G_FALSE,
242: p_commit => FND_API.G_FALSE,
243: p_processing_set_id => proc_seq_num,
244: p_object_type => 'TASK',
245: x_return_status => x_return_status,
246: x_msg_count => x_msg_count,

Line 249: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

245: x_return_status => x_return_status,
246: x_msg_count => x_msg_count,
247: x_msg_data => x_msg_data);
248:
249: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
250: THEN
251: x_return_status := fnd_api.g_ret_sts_unexp_error;
252:
253: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 251: x_return_status := fnd_api.g_ret_sts_unexp_error;

247: x_msg_data => x_msg_data);
248:
249: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
250: THEN
251: x_return_status := fnd_api.g_ret_sts_unexp_error;
252:
253: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
254: THEN
255: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', 'return status error after calling IEU_WR_PUB.PURGE_WR_ITEM');

Line 258: RAISE fnd_api.g_exc_unexpected_error;

254: THEN
255: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', 'return status error after calling IEU_WR_PUB.PURGE_WR_ITEM');
256: END IF;
257:
258: RAISE fnd_api.g_exc_unexpected_error;
259:
260: END IF;
261:
262:

Line 272: p_init_msg_list => FND_API.G_FALSE,

268: END IF;
269:
270: JTF_IH_PURGE.P_Delete_Interactions(
271: p_api_version => 1.0,
272: p_init_msg_list => FND_API.G_FALSE,
273: p_commit => FND_API.G_FALSE,
274: p_processing_set_id => proc_seq_num,
275: p_object_type => 'TASK',
276: x_return_status => x_return_status,

Line 273: p_commit => FND_API.G_FALSE,

269:
270: JTF_IH_PURGE.P_Delete_Interactions(
271: p_api_version => 1.0,
272: p_init_msg_list => FND_API.G_FALSE,
273: p_commit => FND_API.G_FALSE,
274: p_processing_set_id => proc_seq_num,
275: p_object_type => 'TASK',
276: x_return_status => x_return_status,
277: x_msg_count => x_msg_count,

Line 280: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

276: x_return_status => x_return_status,
277: x_msg_count => x_msg_count,
278: x_msg_data => x_msg_data);
279:
280: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
281: THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283:
284: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 282: x_return_status := fnd_api.g_ret_sts_unexp_error;

278: x_msg_data => x_msg_data);
279:
280: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
281: THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283:
284: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
285: THEN
286: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', 'return status error after calling JTF_IH_PURGE.P_DELETE_INTERACTIONS');

Line 289: RAISE fnd_api.g_exc_unexpected_error;

285: THEN
286: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', 'return status error after calling JTF_IH_PURGE.P_DELETE_INTERACTIONS');
287: END IF;
288:
289: RAISE fnd_api.g_exc_unexpected_error;
290:
291: END IF;
292:
293: /************* End of addition by SBARAT on 03/02/2006 for bug# 4997851 *************/

Line 308: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

304: x_return_status => x_return_status,
305: x_msg_count => x_msg_count,
306: x_msg_data => x_msg_data);
307:
308: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
309:
310: THEN
311:
312: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 312: x_return_status := fnd_api.g_ret_sts_unexp_error;

308: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
309:
310: THEN
311:
312: x_return_status := fnd_api.g_ret_sts_unexp_error;
313:
314:
315: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
316:

Line 319: RAISE fnd_api.g_exc_unexpected_error;

315: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
316:
317: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', 'return status error after calling cac_task_purge_pub.delete_atth_to_tasks');
318: end if;
319: RAISE fnd_api.g_exc_unexpected_error;
320: end if;
321:
322:
323: --Calling notes api

Line 338: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

334: x_msg_data => x_msg_data,
335: p_processing_set_id => proc_seq_num,
336: p_object_type => 'TASK' );
337:
338: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
339: THEN
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341:
342: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 340: x_return_status := fnd_api.g_ret_sts_unexp_error;

336: p_object_type => 'TASK' );
337:
338: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
339: THEN
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341:
342: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
343: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', 'return status error after calling cac_note_purge_pub.purge_notes');
344: end if;

Line 345: RAISE fnd_api.g_exc_unexpected_error;

341:
342: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
343: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', 'return status error after calling cac_note_purge_pub.purge_notes');
344: end if;
345: RAISE fnd_api.g_exc_unexpected_error;
346: end if;
347:
348:
349: --calling the cac_task_purge_pvt.purge_task_entities API

Line 357: p_init_msg_list => fnd_api.g_false,

353: end if;
354:
355: cac_task_purge_pvt.purge_task_entities(
356: p_api_version => 1.0,
357: p_init_msg_list => fnd_api.g_false,
358: p_commit => fnd_api.g_false,
359: x_return_status => x_return_status,
360: x_msg_data => x_msg_data,
361: x_msg_count => x_msg_count,

Line 358: p_commit => fnd_api.g_false,

354:
355: cac_task_purge_pvt.purge_task_entities(
356: p_api_version => 1.0,
357: p_init_msg_list => fnd_api.g_false,
358: p_commit => fnd_api.g_false,
359: x_return_status => x_return_status,
360: x_msg_data => x_msg_data,
361: x_msg_count => x_msg_count,
362: p_processing_set_id => proc_seq_num,

Line 368: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

364: );
365:
366:
367:
368: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
369: THEN
370: x_return_status := fnd_api.g_ret_sts_unexp_error;
371:
372: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 370: x_return_status := fnd_api.g_ret_sts_unexp_error;

366:
367:
368: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
369: THEN
370: x_return_status := fnd_api.g_ret_sts_unexp_error;
371:
372: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
373: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', ' return status error after calling cac_task_purge_pvt.purge_task_entities');
374: end if;

Line 376: RAISE fnd_api.g_exc_unexpected_error;

372: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
373: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', ' return status error after calling cac_task_purge_pvt.purge_task_entities');
374: end if;
375:
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;
378:
379:
380: else --no task data exists for the selected service requests

Line 392: IF fnd_api.to_boolean (p_commit)

388:
389: end if;-- for If ( l_tab_tasks_id.COUNT > 0)
390:
391:
392: IF fnd_api.to_boolean (p_commit)
393: THEN
394: COMMIT WORK;
395: END IF;
396:

Line 401: WHEN fnd_api.g_exc_unexpected_error

397: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
398:
399:
400: EXCEPTION
401: WHEN fnd_api.g_exc_unexpected_error
402: THEN
403: ROLLBACK TO purge_tasks;
404: x_return_status := fnd_api.g_ret_sts_unexp_error;
405: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 404: x_return_status := fnd_api.g_ret_sts_unexp_error;

400: EXCEPTION
401: WHEN fnd_api.g_exc_unexpected_error
402: THEN
403: ROLLBACK TO purge_tasks;
404: x_return_status := fnd_api.g_ret_sts_unexp_error;
405: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
406: if (get_tasks_ids%ISOPEN) then
407: Close get_tasks_ids;
408: END IF;

Line 439: x_return_status := fnd_api.g_ret_sts_unexp_error;

435: ROLLBACK TO purge_tasks;
436: fnd_message.set_name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
437: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
438: fnd_msg_pub.add;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: if (get_tasks_ids%ISOPEN) then
441: Close get_tasks_ids;
442: END IF;
443: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 474: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

470:
471:
472: Procedure validate_tasks(
473: p_api_version IN NUMBER,
474: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
475: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
476: x_return_status OUT NOCOPY VARCHAR2,
477: x_msg_data OUT NOCOPY VARCHAR2,
478: x_msg_count OUT NOCOPY NUMBER,

Line 475: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

471:
472: Procedure validate_tasks(
473: p_api_version IN NUMBER,
474: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
475: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
476: x_return_status OUT NOCOPY VARCHAR2,
477: x_msg_data OUT NOCOPY VARCHAR2,
478: x_msg_count OUT NOCOPY NUMBER,
479: p_object_type IN VARCHAR2,

Line 505: x_return_status := fnd_api.g_ret_sts_success;

501: proc_seq_num NUMBER;
502: l_msg_index_out VARCHAR2(100);
503: BEGIN
504: SAVEPOINT validate_tasks;
505: x_return_status := fnd_api.g_ret_sts_success;
506:
507: IF NOT fnd_api.compatible_api_call (
508: l_api_version,
509: p_api_version,

Line 507: IF NOT fnd_api.compatible_api_call (

503: BEGIN
504: SAVEPOINT validate_tasks;
505: x_return_status := fnd_api.g_ret_sts_success;
506:
507: IF NOT fnd_api.compatible_api_call (
508: l_api_version,
509: p_api_version,
510: l_api_name,
511: g_pkg_name

Line 514: RAISE fnd_api.g_exc_unexpected_error;

510: l_api_name,
511: g_pkg_name
512: )
513: THEN
514: RAISE fnd_api.g_exc_unexpected_error;
515: END IF;
516:
517: IF fnd_api.to_boolean (p_init_msg_list)
518: THEN

Line 517: IF fnd_api.to_boolean (p_init_msg_list)

513: THEN
514: RAISE fnd_api.g_exc_unexpected_error;
515: END IF;
516:
517: IF fnd_api.to_boolean (p_init_msg_list)
518: THEN
519: fnd_msg_pub.initialize;
520: END IF;
521: --Logging input parameters

Line 574: P_INIT_MSG_LIST => FND_API.G_FALSE,

570: end if;
571:
572: CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS(
573: P_API_VERSION => 1.0,
574: P_INIT_MSG_LIST => FND_API.G_FALSE,
575: P_COMMIT => FND_API.G_FALSE,
576: P_PROCESSING_SET_ID => proc_seq_num ,
577: P_OBJECT_TYPE => 'TASK' ,
578: X_RETURN_STATUS => x_return_status,

Line 575: P_COMMIT => FND_API.G_FALSE,

571:
572: CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS(
573: P_API_VERSION => 1.0,
574: P_INIT_MSG_LIST => FND_API.G_FALSE,
575: P_COMMIT => FND_API.G_FALSE,
576: P_PROCESSING_SET_ID => proc_seq_num ,
577: P_OBJECT_TYPE => 'TASK' ,
578: X_RETURN_STATUS => x_return_status,
579: X_MSG_COUNT => x_msg_count,

Line 582: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

578: X_RETURN_STATUS => x_return_status,
579: X_MSG_COUNT => x_msg_count,
580: X_MSG_DATA => x_msg_data);
581:
582: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
583: THEN
584: x_return_status := fnd_api.g_ret_sts_unexp_error;
585:
586: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 584: x_return_status := fnd_api.g_ret_sts_unexp_error;

580: X_MSG_DATA => x_msg_data);
581:
582: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
583: THEN
584: x_return_status := fnd_api.g_ret_sts_unexp_error;
585:
586: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
587: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', 'return status error after calling CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS');
588: end if;

Line 589: RAISE fnd_api.g_exc_unexpected_error;

585:
586: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
587: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.purge_tasks', 'return status error after calling CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS');
588: end if;
589: RAISE fnd_api.g_exc_unexpected_error;
590: end if;
591:
592:
593: --bulk update the rows with error status E for which tasks validations have failed.

Line 621: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

617:
618:
619: END IF;-- for If ( l_tab_tasks_id.COUNT > 0) then
620:
621: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
622: THEN
623: x_return_status := fnd_api.g_ret_sts_unexp_error;
624: RAISE fnd_api.g_exc_unexpected_error;
625: END IF;

Line 623: x_return_status := fnd_api.g_ret_sts_unexp_error;

619: END IF;-- for If ( l_tab_tasks_id.COUNT > 0) then
620:
621: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
622: THEN
623: x_return_status := fnd_api.g_ret_sts_unexp_error;
624: RAISE fnd_api.g_exc_unexpected_error;
625: END IF;
626:
627: IF fnd_api.to_boolean (p_commit)

Line 624: RAISE fnd_api.g_exc_unexpected_error;

620:
621: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
622: THEN
623: x_return_status := fnd_api.g_ret_sts_unexp_error;
624: RAISE fnd_api.g_exc_unexpected_error;
625: END IF;
626:
627: IF fnd_api.to_boolean (p_commit)
628: THEN

Line 627: IF fnd_api.to_boolean (p_commit)

623: x_return_status := fnd_api.g_ret_sts_unexp_error;
624: RAISE fnd_api.g_exc_unexpected_error;
625: END IF;
626:
627: IF fnd_api.to_boolean (p_commit)
628: THEN
629: COMMIT WORK;
630: END IF;
631:

Line 635: WHEN fnd_api.g_exc_unexpected_error

631:
632: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
633:
634: EXCEPTION
635: WHEN fnd_api.g_exc_unexpected_error
636: THEN
637: ROLLBACK TO validate_tasks;
638: if (tasks_ids%ISOPEN) then
639: CLOSE tasks_ids;

Line 641: x_return_status := fnd_api.g_ret_sts_unexp_error;

637: ROLLBACK TO validate_tasks;
638: if (tasks_ids%ISOPEN) then
639: CLOSE tasks_ids;
640: end if;
641: x_return_status := fnd_api.g_ret_sts_unexp_error;
642: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
643:
644:
645: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 678: x_return_status := fnd_api.g_ret_sts_unexp_error;

674: end if;
675: fnd_message.set_name ('JTF', 'JTF_TASK_VALID_UNKNOWN_ERR');
676: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
677: fnd_msg_pub.add;
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679:
680: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
681: IF FND_MSG_PUB.Count_Msg > 0
682: THEN