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.OKC_TASK_ALERT_ESCL_PVT dependencies on OKC_API

Line 115: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

111: OKC_DEBUG.set_indentation(l_api_name);
112: OKC_DEBUG.log('10: Entered task_alert', 2);
113: END IF;
114:
115: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
116: G_PKG_NAME,
117: p_init_msg_list,
118: g_api_version,
119: p_api_version,

Line 122: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

118: g_api_version,
119: p_api_version,
120: G_LEVEL,
121: g_return_status);
122: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
123: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
124: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
125: RAISE OKC_API.G_EXCEPTION_ERROR;
126: END IF;

Line 123: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

119: p_api_version,
120: G_LEVEL,
121: g_return_status);
122: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
123: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
124: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
125: RAISE OKC_API.G_EXCEPTION_ERROR;
126: END IF;
127:

Line 124: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

120: G_LEVEL,
121: g_return_status);
122: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
123: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
124: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
125: RAISE OKC_API.G_EXCEPTION_ERROR;
126: END IF;
127:
128: --Initialize the return code

Line 125: RAISE OKC_API.G_EXCEPTION_ERROR;

121: g_return_status);
122: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
123: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
124: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
125: RAISE OKC_API.G_EXCEPTION_ERROR;
126: END IF;
127:
128: --Initialize the return code
129: retcode := 0;

Line 133: okc_api.set_message(p_app_name => G_APP_NAME,

129: retcode := 0;
130:
131: --Check if the workflow name and process name exists
132: IF p_wf_name IS NULL OR p_wf_process IS NULL THEN
133: okc_api.set_message(p_app_name => G_APP_NAME,
134: p_msg_name => G_PROCESS_NOTFOUND,
135: p_token1 => G_WF_NAME_TOKEN,
136: p_token1_value => P_WF_NAME,
137: p_token2 => G_WF_P_NAME_TOKEN,

Line 143: RAISE OKC_API.G_EXCEPTION_ERROR;

139: IF (l_debug = 'Y') THEN
140: OKC_DEBUG.log('20: WorkFlow Name OR Process Name do not exist ....');
141: OKC_DEBUG.log('30: WorkFlow Name ' || p_wf_name || ' OR Process Name '|| p_wf_process);
142: END IF;
143: RAISE OKC_API.G_EXCEPTION_ERROR;
144: END IF;
145: --Check if the cursor is already open
146: IF alert_cur%ISOPEN THEN
147: CLOSE alert_cur;

Line 317: l_return_status := OKC_API.START_ACTIVITY(

313: END IF;
314:
315: -- commit;
316:
317: l_return_status := OKC_API.START_ACTIVITY(
318: l_api_name,
319: G_PKG_NAME,
320: p_init_msg_list,
321: g_api_version,

Line 325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

321: g_api_version,
322: p_api_version,
323: G_LEVEL,
324: g_return_status);
325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;

Line 326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

322: p_api_version,
323: G_LEVEL,
324: g_return_status);
325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;
330:

Line 327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

323: G_LEVEL,
324: g_return_status);
325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;
330:
331: IF (l_debug = 'Y') THEN

Line 328: RAISE OKC_API.G_EXCEPTION_ERROR;

324: g_return_status);
325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;
330:
331: IF (l_debug = 'Y') THEN
332: OKC_DEBUG.log('290: before OKC_TASK_PUB.update_task .....');

Line 350: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

346: IF (l_debug = 'Y') THEN
347: OKC_DEBUG.log('300: after OKC_TASK_PUB.update_task return_status is '|| g_return_status );
348: END IF;
349:
350: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
351: l_failure_count := l_failure_count + 1;
352: rollback to task_alert_PVT;
353: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
354: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 353: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

349:
350: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
351: l_failure_count := l_failure_count + 1;
352: rollback to task_alert_PVT;
353: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
354: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
355: l_failure_count := l_failure_count + 1;
356: rollback to task_alert_PVT;
357: raise OKC_API.G_EXCEPTION_ERROR;

Line 354: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN

350: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
351: l_failure_count := l_failure_count + 1;
352: rollback to task_alert_PVT;
353: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
354: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
355: l_failure_count := l_failure_count + 1;
356: rollback to task_alert_PVT;
357: raise OKC_API.G_EXCEPTION_ERROR;
358: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 357: raise OKC_API.G_EXCEPTION_ERROR;

353: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
354: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
355: l_failure_count := l_failure_count + 1;
356: rollback to task_alert_PVT;
357: raise OKC_API.G_EXCEPTION_ERROR;
358: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
359: l_success_count := l_success_count + 1;
360: commit;
361: END IF;

Line 358: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

354: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
355: l_failure_count := l_failure_count + 1;
356: rollback to task_alert_PVT;
357: raise OKC_API.G_EXCEPTION_ERROR;
358: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
359: l_success_count := l_success_count + 1;
360: commit;
361: END IF;
362: END IF;

Line 364: WHEN OKC_API.G_EXCEPTION_ERROR THEN

360: commit;
361: END IF;
362: END IF;
363: EXCEPTION
364: WHEN OKC_API.G_EXCEPTION_ERROR THEN
365: IF (l_debug = 'Y') THEN
366: OKC_DEBUG.log(' 400:Exception Error in task_alert...', 2);
367: OKC_DEBUG.Reset_Indentation;
368: END IF;

Line 372: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

368: END IF;
369: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
370: get_fnd_msg_stack(' Exception Error in task_alert is '||g_msg_data);
371:
372: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
373: IF (l_debug = 'Y') THEN
374: OKC_DEBUG.log(' 400:Unexcepted Error in task_alert...', 2);
375: OKC_DEBUG.Reset_Indentation;
376: END IF;

Line 392: OKC_API.END_ACTIVITY(g_msg_count, g_msg_data);

388: get_fnd_msg_stack(' Other Exception Error in task_alert is '||g_msg_data);
389: exit;
390: END;
391: END LOOP;
392: OKC_API.END_ACTIVITY(g_msg_count, g_msg_data);
393:
394: IF (l_debug = 'Y') THEN
395: OKC_DEBUG.log('400: Exiting task_alert...', 2);
396: OKC_DEBUG.Reset_Indentation;

Line 402: WHEN OKC_API.G_EXCEPTION_ERROR THEN

398: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);
399: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);
400:
401: EXCEPTION
402: WHEN OKC_API.G_EXCEPTION_ERROR THEN
403: IF (l_debug = 'Y') THEN
404: OKC_DEBUG.log(' 400:Exception Error in task_alert...', 2);
405: OKC_DEBUG.Reset_Indentation;
406: END IF;

Line 411: g_return_status := OKC_API.HANDLE_EXCEPTIONS

407: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
408:
409: retcode := 2;
410: errbuf := substr(sqlerrm,1,250);
411: g_return_status := OKC_API.HANDLE_EXCEPTIONS
412: (l_api_name,
413: G_PKG_NAME,
414: 'OKC_API.G_RET_STS_ERROR',
415: g_msg_count,

Line 414: 'OKC_API.G_RET_STS_ERROR',

410: errbuf := substr(sqlerrm,1,250);
411: g_return_status := OKC_API.HANDLE_EXCEPTIONS
412: (l_api_name,
413: G_PKG_NAME,
414: 'OKC_API.G_RET_STS_ERROR',
415: g_msg_count,
416: g_msg_data,
417: G_LEVEL);
418:

Line 421: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

417: G_LEVEL);
418:
419: get_fnd_msg_stack(' Exception Error in task_alert is '||g_msg_data);
420:
421: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
422: IF (l_debug = 'Y') THEN
423: OKC_DEBUG.log(' 400:Unexcepted Error in task_alert...', 2);
424: OKC_DEBUG.Reset_Indentation;
425: END IF;

Line 430: g_return_status := OKC_API.HANDLE_EXCEPTIONS

426: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
427:
428: retcode := 2;
429: errbuf := substr(sqlerrm,1,250);
430: g_return_status := OKC_API.HANDLE_EXCEPTIONS
431: (l_api_name,
432: G_PKG_NAME,
433: 'OKC_API.G_RET_STS_UNEXP_ERROR',
434: g_msg_count,

Line 433: 'OKC_API.G_RET_STS_UNEXP_ERROR',

429: errbuf := substr(sqlerrm,1,250);
430: g_return_status := OKC_API.HANDLE_EXCEPTIONS
431: (l_api_name,
432: G_PKG_NAME,
433: 'OKC_API.G_RET_STS_UNEXP_ERROR',
434: g_msg_count,
435: g_msg_data,
436: G_LEVEL);
437:

Line 449: g_return_status := OKC_API.HANDLE_EXCEPTIONS

445: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
446:
447: retcode := 2;
448: errbuf := substr(sqlerrm,1,250);
449: g_return_status := OKC_API.HANDLE_EXCEPTIONS
450: (l_api_name,
451: G_PKG_NAME,
452: 'OTHERS',
453: g_msg_count,

Line 541: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

537: OKC_DEBUG.set_indentation(l_api_name);
538: OKC_DEBUG.log('510: Entered task_escalation1', 2);
539: END IF;
540:
541: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
542: G_PKG_NAME,
543: p_init_msg_list,
544: g_api_version,
545: p_api_version,

Line 548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

544: g_api_version,
545: p_api_version,
546: G_LEVEL,
547: g_return_status);
548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
551: RAISE OKC_API.G_EXCEPTION_ERROR;
552: END IF;

Line 549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

545: p_api_version,
546: G_LEVEL,
547: g_return_status);
548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
551: RAISE OKC_API.G_EXCEPTION_ERROR;
552: END IF;
553:

Line 550: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

546: G_LEVEL,
547: g_return_status);
548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
551: RAISE OKC_API.G_EXCEPTION_ERROR;
552: END IF;
553:
554: --Initialize the return code

Line 551: RAISE OKC_API.G_EXCEPTION_ERROR;

547: g_return_status);
548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
551: RAISE OKC_API.G_EXCEPTION_ERROR;
552: END IF;
553:
554: --Initialize the return code
555: retcode := 0;

Line 559: okc_api.set_message(p_app_name => G_APP_NAME,

555: retcode := 0;
556:
557: --Check if the workflow name and process_name exists
558: IF p_wf_name IS NULL OR p_wf_process IS NULL THEN
559: okc_api.set_message(p_app_name => G_APP_NAME,
560: p_msg_name => G_PROCESS_NOTFOUND,
561: p_token1 => G_WF_NAME_TOKEN,
562: p_token1_value => P_WF_NAME,
563: p_token2 => G_WF_P_NAME_TOKEN,

Line 571: RAISE OKC_API.G_EXCEPTION_ERROR;

567: OKC_DEBUG.log('520: WorkFlow Name OR Process Name do not exist ....');
568: OKC_DEBUG.log('530: WorkFlow Name ' || p_wf_name || ' OR Process Name '|| p_wf_process);
569: END IF;
570:
571: RAISE OKC_API.G_EXCEPTION_ERROR;
572: END IF;
573:
574: --Check if the cursor is already open
575: IF escalate_owner1_cur%ISOPEN THEN

Line 758: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

754: END IF;
755:
756: -- commit;
757:
758: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
759: G_PKG_NAME,
760: p_init_msg_list,
761: g_api_version,
762: p_api_version,

Line 765: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

761: g_api_version,
762: p_api_version,
763: G_LEVEL,
764: g_return_status);
765: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
768: RAISE OKC_API.G_EXCEPTION_ERROR;
769: END IF;

Line 766: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

762: p_api_version,
763: G_LEVEL,
764: g_return_status);
765: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
768: RAISE OKC_API.G_EXCEPTION_ERROR;
769: END IF;
770:

Line 767: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

763: G_LEVEL,
764: g_return_status);
765: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
768: RAISE OKC_API.G_EXCEPTION_ERROR;
769: END IF;
770:
771: IF (l_debug = 'Y') THEN

Line 768: RAISE OKC_API.G_EXCEPTION_ERROR;

764: g_return_status);
765: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
768: RAISE OKC_API.G_EXCEPTION_ERROR;
769: END IF;
770:
771: IF (l_debug = 'Y') THEN
772: OKC_DEBUG.log('790: before OKC_TASK_PUB.update_task .....');

Line 791: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

787: IF (l_debug = 'Y') THEN
788: OKC_DEBUG.log('800: after OKC_TASK_PUB.update_task return_status is '|| g_return_status);
789: END IF;
790:
791: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
792: l_failure_count := l_failure_count + 1;
793: rollback to task_alert_pvt;
794: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 794: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

790:
791: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
792: l_failure_count := l_failure_count + 1;
793: rollback to task_alert_pvt;
794: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
796: l_failure_count := l_failure_count + 1;
797: rollback to task_alert_pvt;
798: raise OKC_API.G_EXCEPTION_ERROR;

Line 795: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN

791: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
792: l_failure_count := l_failure_count + 1;
793: rollback to task_alert_pvt;
794: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
796: l_failure_count := l_failure_count + 1;
797: rollback to task_alert_pvt;
798: raise OKC_API.G_EXCEPTION_ERROR;
799: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 798: raise OKC_API.G_EXCEPTION_ERROR;

794: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
796: l_failure_count := l_failure_count + 1;
797: rollback to task_alert_pvt;
798: raise OKC_API.G_EXCEPTION_ERROR;
799: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
800: l_success_count := l_success_count + 1;
801: commit;
802: END IF;

Line 799: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

795: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
796: l_failure_count := l_failure_count + 1;
797: rollback to task_alert_pvt;
798: raise OKC_API.G_EXCEPTION_ERROR;
799: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
800: l_success_count := l_success_count + 1;
801: commit;
802: END IF;
803: END IF;

Line 805: WHEN OKC_API.G_EXCEPTION_ERROR THEN

801: commit;
802: END IF;
803: END IF;
804: EXCEPTION
805: WHEN OKC_API.G_EXCEPTION_ERROR THEN
806: IF (l_debug = 'Y') THEN
807: OKC_DEBUG.log(' 400:Exception Error in task_alert...', 2);
808: OKC_DEBUG.Reset_Indentation;
809: END IF;

Line 813: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

809: END IF;
810: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
811: get_fnd_msg_stack(' Exception Error in task_alert is '||g_msg_data);
812:
813: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
814: IF (l_debug = 'Y') THEN
815: OKC_DEBUG.log(' 400:Unexcepted Error in task_alert...', 2);
816: OKC_DEBUG.Reset_Indentation;
817: END IF;

Line 835: OKC_API.END_ACTIVITY(g_msg_count, g_msg_data);

831: get_fnd_msg_stack(' Other Exception Error in task_alert is '||g_msg_data);
832: exit;
833: END;
834: END LOOP;
835: OKC_API.END_ACTIVITY(g_msg_count, g_msg_data);
836:
837: IF (l_debug = 'Y') THEN
838: OKC_DEBUG.log('900: Exiting task_task_escalation1...', 2);
839: OKC_DEBUG.Reset_Indentation;

Line 845: WHEN OKC_API.G_EXCEPTION_ERROR THEN

841: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);
842: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);
843:
844: EXCEPTION
845: WHEN OKC_API.G_EXCEPTION_ERROR THEN
846: IF (l_debug = 'Y') THEN
847: OKC_DEBUG.log(' 900:Exception Error in task_escalation1...', 2);
848: OKC_DEBUG.Reset_Indentation;
849: END IF;

Line 854: g_return_status := OKC_API.HANDLE_EXCEPTIONS

850: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
851:
852: retcode := 2;
853: errbuf := substr(sqlerrm,1,250);
854: g_return_status := OKC_API.HANDLE_EXCEPTIONS
855: (l_api_name,
856: G_PKG_NAME,
857: 'OKC_API.G_RET_STS_ERROR',
858: g_msg_count,

Line 857: 'OKC_API.G_RET_STS_ERROR',

853: errbuf := substr(sqlerrm,1,250);
854: g_return_status := OKC_API.HANDLE_EXCEPTIONS
855: (l_api_name,
856: G_PKG_NAME,
857: 'OKC_API.G_RET_STS_ERROR',
858: g_msg_count,
859: g_msg_data,
860: G_LEVEL);
861:

Line 864: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

860: G_LEVEL);
861:
862: get_fnd_msg_stack(' Exception Error in task_escalation1 is '||g_msg_data);
863:
864: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
865: IF (l_debug = 'Y') THEN
866: OKC_DEBUG.log(' 900:Unexcepted Error in task_escalation1...', 2);
867: OKC_DEBUG.Reset_Indentation;
868: END IF;

Line 873: g_return_status := OKC_API.HANDLE_EXCEPTIONS

869: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
870:
871: retcode := 2;
872: errbuf := substr(sqlerrm,1,250);
873: g_return_status := OKC_API.HANDLE_EXCEPTIONS
874: (l_api_name,
875: G_PKG_NAME,
876: 'OKC_API.G_RET_STS_UNEXP_ERROR',
877: g_msg_count,

Line 876: 'OKC_API.G_RET_STS_UNEXP_ERROR',

872: errbuf := substr(sqlerrm,1,250);
873: g_return_status := OKC_API.HANDLE_EXCEPTIONS
874: (l_api_name,
875: G_PKG_NAME,
876: 'OKC_API.G_RET_STS_UNEXP_ERROR',
877: g_msg_count,
878: g_msg_data,
879: G_LEVEL);
880:

Line 892: g_return_status := OKC_API.HANDLE_EXCEPTIONS

888: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
889:
890: retcode := 2;
891: errbuf := substr(sqlerrm,1,250);
892: g_return_status := OKC_API.HANDLE_EXCEPTIONS
893: (l_api_name,
894: G_PKG_NAME,
895: 'OTHERS',
896: g_msg_count,

Line 984: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

980: OKC_DEBUG.set_indentation(l_api_name);
981: OKC_DEBUG.log('1010: Entered task_escalation2', 2);
982: END IF;
983:
984: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
985: G_PKG_NAME,
986: p_init_msg_list,
987: g_api_version,
988: p_api_version,

Line 991: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

987: g_api_version,
988: p_api_version,
989: G_LEVEL,
990: g_return_status);
991: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
994: RAISE OKC_API.G_EXCEPTION_ERROR;
995: END IF;

Line 992: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

988: p_api_version,
989: G_LEVEL,
990: g_return_status);
991: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
994: RAISE OKC_API.G_EXCEPTION_ERROR;
995: END IF;
996:

Line 993: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

989: G_LEVEL,
990: g_return_status);
991: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
994: RAISE OKC_API.G_EXCEPTION_ERROR;
995: END IF;
996:
997: --Initialize the return code

Line 994: RAISE OKC_API.G_EXCEPTION_ERROR;

990: g_return_status);
991: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
994: RAISE OKC_API.G_EXCEPTION_ERROR;
995: END IF;
996:
997: --Initialize the return code
998: retcode := 0;

Line 1002: okc_api.set_message(p_app_name => G_APP_NAME,

998: retcode := 0;
999:
1000: --Check if the item_type and process_name exists
1001: IF p_wf_name IS NULL OR p_wf_process IS NULL THEN
1002: okc_api.set_message(p_app_name => G_APP_NAME,
1003: p_msg_name => G_PROCESS_NOTFOUND,
1004: p_token1 => G_WF_NAME_TOKEN,
1005: p_token1_value => P_WF_NAME,
1006: p_token2 => G_WF_P_NAME_TOKEN,

Line 1014: RAISE OKC_API.G_EXCEPTION_ERROR;

1010: OKC_DEBUG.log('1020: WorkFlow Name OR Process Name do not exist ....');
1011: OKC_DEBUG.log('1030: WorkFlow Name ' || p_wf_name || ' OR Process Name '|| p_wf_process);
1012: END IF;
1013:
1014: RAISE OKC_API.G_EXCEPTION_ERROR;
1015: END IF;
1016:
1017: --Check if the cursor is already open
1018: IF escalate_owner2_cur%ISOPEN THEN

Line 1188: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1184: END IF;
1185:
1186: -- commit;
1187:
1188: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1189: G_PKG_NAME,
1190: p_init_msg_list,
1191: g_api_version,
1192: p_api_version,

Line 1195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1191: g_api_version,
1192: p_api_version,
1193: G_LEVEL,
1194: g_return_status);
1195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1198: RAISE OKC_API.G_EXCEPTION_ERROR;
1199: END IF;

Line 1196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1192: p_api_version,
1193: G_LEVEL,
1194: g_return_status);
1195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1198: RAISE OKC_API.G_EXCEPTION_ERROR;
1199: END IF;
1200:

Line 1197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1193: G_LEVEL,
1194: g_return_status);
1195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1198: RAISE OKC_API.G_EXCEPTION_ERROR;
1199: END IF;
1200:
1201: IF (l_debug = 'Y') THEN

Line 1198: RAISE OKC_API.G_EXCEPTION_ERROR;

1194: g_return_status);
1195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1198: RAISE OKC_API.G_EXCEPTION_ERROR;
1199: END IF;
1200:
1201: IF (l_debug = 'Y') THEN
1202: OKC_DEBUG.log('2090: before OKC_TASK_PUB.update_task .....');

Line 1221: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1217: IF (l_debug = 'Y') THEN
1218: OKC_DEBUG.log('3000: after OKC_TASK_PUB.update_task return_status is '|| g_return_status);
1219: END IF;
1220:
1221: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1222: l_failure_count := l_failure_count + 1;
1223: rollback to task_alert_pvt;
1224: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1224: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1220:
1221: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1222: l_failure_count := l_failure_count + 1;
1223: rollback to task_alert_pvt;
1224: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
1226: l_failure_count := l_failure_count + 1;
1227: rollback to task_alert_pvt;
1228: raise OKC_API.G_EXCEPTION_ERROR;

Line 1225: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN

1221: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1222: l_failure_count := l_failure_count + 1;
1223: rollback to task_alert_pvt;
1224: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
1226: l_failure_count := l_failure_count + 1;
1227: rollback to task_alert_pvt;
1228: raise OKC_API.G_EXCEPTION_ERROR;
1229: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 1228: raise OKC_API.G_EXCEPTION_ERROR;

1224: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
1226: l_failure_count := l_failure_count + 1;
1227: rollback to task_alert_pvt;
1228: raise OKC_API.G_EXCEPTION_ERROR;
1229: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1230: l_success_count := l_success_count + 1;
1231: commit;
1232: END IF;

Line 1229: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1225: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
1226: l_failure_count := l_failure_count + 1;
1227: rollback to task_alert_pvt;
1228: raise OKC_API.G_EXCEPTION_ERROR;
1229: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1230: l_success_count := l_success_count + 1;
1231: commit;
1232: END IF;
1233: END IF;

Line 1235: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1231: commit;
1232: END IF;
1233: END IF;
1234: EXCEPTION
1235: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1236: IF (l_debug = 'Y') THEN
1237: OKC_DEBUG.log(' 400:Exception Error in task_alert...', 2);
1238: OKC_DEBUG.Reset_Indentation;
1239: END IF;

Line 1243: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1239: END IF;
1240: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
1241: get_fnd_msg_stack(' Exception Error in task_alert is '||g_msg_data);
1242:
1243: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1244: IF (l_debug = 'Y') THEN
1245: OKC_DEBUG.log(' 400:Unexcepted Error in task_alert...', 2);
1246: OKC_DEBUG.Reset_Indentation;
1247: END IF;

Line 1263: OKC_API.END_ACTIVITY(g_msg_count, g_msg_data);

1259: FND_FILE.PUT_LINE( FND_FILE.LOG,substr(sqlerrm,1,250));
1260: exit;
1261: END;
1262: END LOOP;
1263: OKC_API.END_ACTIVITY(g_msg_count, g_msg_data);
1264:
1265: IF (l_debug = 'Y') THEN
1266: OKC_DEBUG.log('4000: Exiting task_task_escalation2...', 2);
1267: OKC_DEBUG.Reset_Indentation;

Line 1273: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1269: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);
1270: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);
1271:
1272: EXCEPTION
1273: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1274: IF (l_debug = 'Y') THEN
1275: OKC_DEBUG.log(' 4000:Exception Error in task_escalation2...', 2);
1276: OKC_DEBUG.Reset_Indentation;
1277: END IF;

Line 1281: g_return_status := OKC_API.HANDLE_EXCEPTIONS

1277: END IF;
1278: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_name);
1279: retcode := 2;
1280: errbuf := substr(sqlerrm,1,250);
1281: g_return_status := OKC_API.HANDLE_EXCEPTIONS
1282: (l_api_name,
1283: G_PKG_NAME,
1284: 'OKC_API.G_RET_STS_ERROR',
1285: g_msg_count,

Line 1284: 'OKC_API.G_RET_STS_ERROR',

1280: errbuf := substr(sqlerrm,1,250);
1281: g_return_status := OKC_API.HANDLE_EXCEPTIONS
1282: (l_api_name,
1283: G_PKG_NAME,
1284: 'OKC_API.G_RET_STS_ERROR',
1285: g_msg_count,
1286: g_msg_data,
1287: G_LEVEL);
1288:

Line 1291: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1287: G_LEVEL);
1288:
1289: get_fnd_msg_stack(' Exception Error in task_escaltion2 is '||g_msg_data);
1290:
1291: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1292: IF (l_debug = 'Y') THEN
1293: OKC_DEBUG.log(' 4000:Unexcepted Error in task_escalation2...', 2);
1294: OKC_DEBUG.Reset_Indentation;
1295: END IF;

Line 1300: g_return_status := OKC_API.HANDLE_EXCEPTIONS

1296: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_name);
1297:
1298: retcode := 2;
1299: errbuf := substr(sqlerrm,1,250);
1300: g_return_status := OKC_API.HANDLE_EXCEPTIONS
1301: (l_api_name,
1302: G_PKG_NAME,
1303: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1304: g_msg_count,

Line 1303: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1299: errbuf := substr(sqlerrm,1,250);
1300: g_return_status := OKC_API.HANDLE_EXCEPTIONS
1301: (l_api_name,
1302: G_PKG_NAME,
1303: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1304: g_msg_count,
1305: g_msg_data,
1306: G_LEVEL);
1307:

Line 1319: g_return_status := OKC_API.HANDLE_EXCEPTIONS

1315: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_name);
1316:
1317: retcode := 2;
1318: errbuf := substr(sqlerrm,1,250);
1319: g_return_status := OKC_API.HANDLE_EXCEPTIONS
1320: (l_api_name,
1321: G_PKG_NAME,
1322: 'OTHERS',
1323: g_msg_count,

Line 1362: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1358: OKC_DEBUG.set_indentation(l_api_name);
1359: OKC_DEBUG.log('5010: Entered okc_pdate_reach_pvt', 2);
1360: END IF;
1361:
1362: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1363: G_PKG_NAME,
1364: p_init_msg_list,
1365: g_api_version,
1366: p_api_version,

Line 1369: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1365: g_api_version,
1366: p_api_version,
1367: G_LEVEL,
1368: g_return_status);
1369: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;

Line 1370: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1366: p_api_version,
1367: G_LEVEL,
1368: g_return_status);
1369: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;
1374:

Line 1371: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1367: G_LEVEL,
1368: g_return_status);
1369: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;
1374:
1375: --Initialize the return code

Line 1372: RAISE OKC_API.G_EXCEPTION_ERROR;

1368: g_return_status);
1369: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;
1374:
1375: --Initialize the return code
1376: retcode := 0;

Line 1417: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1413: IF (l_debug = 'Y') THEN
1414: OKC_DEBUG.log('5060: After Calling the action assembler return_status is '||g_return_status);
1415: END IF;
1416:
1417: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1418: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1419: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
1420: raise OKC_API.G_EXCEPTION_ERROR;
1421: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 1418: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1414: OKC_DEBUG.log('5060: After Calling the action assembler return_status is '||g_return_status);
1415: END IF;
1416:
1417: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1418: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1419: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
1420: raise OKC_API.G_EXCEPTION_ERROR;
1421: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1422: commit;

Line 1419: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN

1415: END IF;
1416:
1417: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1418: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1419: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
1420: raise OKC_API.G_EXCEPTION_ERROR;
1421: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1422: commit;
1423: END IF;

Line 1420: raise OKC_API.G_EXCEPTION_ERROR;

1416:
1417: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1418: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1419: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
1420: raise OKC_API.G_EXCEPTION_ERROR;
1421: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1422: commit;
1423: END IF;
1424: END IF;

Line 1421: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1417: IF (g_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1418: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1419: ELSIF (g_return_status = OKC_API.G_RET_STS_ERROR) THEN
1420: raise OKC_API.G_EXCEPTION_ERROR;
1421: ELSIF (g_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1422: commit;
1423: END IF;
1424: END IF;
1425: END LOOP;

Line 1433: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1429: OKC_DEBUG.Reset_Indentation;
1430: END IF;
1431:
1432: EXCEPTION
1433: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1434: IF (l_debug = 'Y') THEN
1435: OKC_DEBUG.log(' 6000:Exception Error in okc_pdate_reach_pvt...', 2);
1436: OKC_DEBUG.Reset_Indentation;
1437: END IF;

Line 1441: g_return_status := OKC_API.HANDLE_EXCEPTIONS

1437: END IF;
1438:
1439: retcode := 2;
1440: errbuf := substr(sqlerrm,1,250);
1441: g_return_status := OKC_API.HANDLE_EXCEPTIONS
1442: (l_api_name,
1443: G_PKG_NAME,
1444: 'OKC_API.G_RET_STS_ERROR',
1445: g_msg_count,

Line 1444: 'OKC_API.G_RET_STS_ERROR',

1440: errbuf := substr(sqlerrm,1,250);
1441: g_return_status := OKC_API.HANDLE_EXCEPTIONS
1442: (l_api_name,
1443: G_PKG_NAME,
1444: 'OKC_API.G_RET_STS_ERROR',
1445: g_msg_count,
1446: g_msg_data,
1447: G_LEVEL);
1448:

Line 1451: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1447: G_LEVEL);
1448:
1449: get_fnd_msg_stack(' Exception Error in okc_pdate_reach_pvt is '||g_msg_data);
1450:
1451: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1452: IF (l_debug = 'Y') THEN
1453: OKC_DEBUG.log(' 6000:Unexcepted Error in okc_pdate_reach_pvt...', 2);
1454: OKC_DEBUG.Reset_Indentation;
1455: END IF;

Line 1459: g_return_status := OKC_API.HANDLE_EXCEPTIONS

1455: END IF;
1456:
1457: retcode := 2;
1458: errbuf := substr(sqlerrm,1,250);
1459: g_return_status := OKC_API.HANDLE_EXCEPTIONS
1460: (l_api_name,
1461: G_PKG_NAME,
1462: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1463: g_msg_count,

Line 1462: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1458: errbuf := substr(sqlerrm,1,250);
1459: g_return_status := OKC_API.HANDLE_EXCEPTIONS
1460: (l_api_name,
1461: G_PKG_NAME,
1462: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1463: g_msg_count,
1464: g_msg_data,
1465: G_LEVEL);
1466:

Line 1477: g_return_status := OKC_API.HANDLE_EXCEPTIONS

1473: END IF;
1474:
1475: retcode := 2;
1476: errbuf := substr(sqlerrm,1,250);
1477: g_return_status := OKC_API.HANDLE_EXCEPTIONS
1478: (l_api_name,
1479: G_PKG_NAME,
1480: 'OTHERS',
1481: g_msg_count,