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.OKL_PERD_STATUS_PVT dependencies on OKL_API

Line 42: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

38:
39: l_api_name CONSTANT VARCHAR2(40) := 'SEARCH_PERIOD_STATUS';
40: l_api_version CONSTANT NUMBER := 1.0;
41: l_row_count NUMBER;
42: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
43:
44: l_period_rec period_rec_type;
45: l_stmt VARCHAR2(3000);
46: l_application_id NUMBER := 540;

Line 61: x_return_status := OKL_API.G_RET_STS_SUCCESS;

57:
58: BEGIN
59:
60:
61: x_return_status := OKL_API.G_RET_STS_SUCCESS;
62:
63: l_set_of_books_id := p_period_rec.SET_OF_BOOKS_ID;
64:
65:

Line 163: WHEN OKL_API.G_EXCEPTION_ERROR THEN

159: CLOSE perd_csr;
160:
161: EXCEPTION
162:
163: WHEN OKL_API.G_EXCEPTION_ERROR THEN
164: x_return_status := OKL_API.G_RET_STS_ERROR;
165:
166:
167: END SEARCH_PERIOD_STATUS;

Line 164: x_return_status := OKL_API.G_RET_STS_ERROR;

160:
161: EXCEPTION
162:
163: WHEN OKL_API.G_EXCEPTION_ERROR THEN
164: x_return_status := OKL_API.G_RET_STS_ERROR;
165:
166:
167: END SEARCH_PERIOD_STATUS;
168:

Line 194: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

190: WHERE application_id = 540
191: AND ledger_id = p_ledger_id
192: AND period_name = p_period_name;
193:
194: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
195: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
196: l_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;
197: l_msg_data_comp VARCHAR2(2000);
198: l_msg_data VARCHAR2(2000);

Line 195: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

191: AND ledger_id = p_ledger_id
192: AND period_name = p_period_name;
193:
194: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
195: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
196: l_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;
197: l_msg_data_comp VARCHAR2(2000);
198: l_msg_data VARCHAR2(2000);
199: l_msg_count NUMBER;

Line 203: x_return_status := OKL_API.G_RET_STS_SUCCESS;

199: l_msg_count NUMBER;
200:
201: BEGIN
202:
203: x_return_status := OKL_API.G_RET_STS_SUCCESS;
204:
205: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
206: G_PKG_NAME,
207: p_init_msg_list,

Line 205: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

201: BEGIN
202:
203: x_return_status := OKL_API.G_RET_STS_SUCCESS;
204:
205: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
206: G_PKG_NAME,
207: p_init_msg_list,
208: l_api_version,
209: p_api_version,

Line 212: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

208: l_api_version,
209: p_api_version,
210: '_PVT',
211: x_return_status);
212: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
214: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_ERROR;
216: END IF;

Line 213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

209: p_api_version,
210: '_PVT',
211: x_return_status);
212: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
214: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_ERROR;
216: END IF;
217:

Line 214: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

210: '_PVT',
211: x_return_status);
212: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
214: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_ERROR;
216: END IF;
217:
218:

Line 215: RAISE OKL_API.G_EXCEPTION_ERROR;

211: x_return_status);
212: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
214: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_ERROR;
216: END IF;
217:
218:
219: FOR i IN 1..p_period_tbl.COUNT

Line 240: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

236: x_msg_data => x_msg_data,
237: p_period_rec => p_period_tbl(i));
238:
239:
240: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
241: Clear_Message;
242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
244: Clear_Message;

Line 242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

238:
239:
240: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
241: Clear_Message;
242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
244: Clear_Message;
245: RAISE OKL_API.G_EXCEPTION_ERROR;
246: END IF;

Line 243: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

239:
240: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
241: Clear_Message;
242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
244: Clear_Message;
245: RAISE OKL_API.G_EXCEPTION_ERROR;
246: END IF;
247:

Line 245: RAISE OKL_API.G_EXCEPTION_ERROR;

241: Clear_Message;
242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
244: Clear_Message;
245: RAISE OKL_API.G_EXCEPTION_ERROR;
246: END IF;
247:
248: IF l_return_status = G_WARNING_STATUS THEN
249: l_overall_status := G_WARNING_STATUS;

Line 255: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

251:
252: END IF;
253: END LOOP;
254:
255: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
256:
257:
258: -- Added by kthiruva on 26-Sep-2003 Bug No.3126403
259: -- To get the warning messages in message stack incase of warnings

Line 280: WHEN OKL_API.G_EXCEPTION_ERROR THEN

276: x_msg_data := l_msg_data_comp;
277:
278:
279: EXCEPTION
280: WHEN OKL_API.G_EXCEPTION_ERROR THEN
281: x_return_status := OKL_API.HANDLE_EXCEPTIONS
282: (
283: l_api_name,
284: G_PKG_NAME,

Line 281: x_return_status := OKL_API.HANDLE_EXCEPTIONS

277:
278:
279: EXCEPTION
280: WHEN OKL_API.G_EXCEPTION_ERROR THEN
281: x_return_status := OKL_API.HANDLE_EXCEPTIONS
282: (
283: l_api_name,
284: G_PKG_NAME,
285: 'OKL_API.G_RET_STS_ERROR',

Line 285: 'OKL_API.G_RET_STS_ERROR',

281: x_return_status := OKL_API.HANDLE_EXCEPTIONS
282: (
283: l_api_name,
284: G_PKG_NAME,
285: 'OKL_API.G_RET_STS_ERROR',
286: x_msg_count,
287: x_msg_data,
288: '_PVT'
289: );

Line 290: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

286: x_msg_count,
287: x_msg_data,
288: '_PVT'
289: );
290: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
291: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
292: (
293: l_api_name,
294: G_PKG_NAME,

Line 291: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

287: x_msg_data,
288: '_PVT'
289: );
290: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
291: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
292: (
293: l_api_name,
294: G_PKG_NAME,
295: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 295: 'OKL_API.G_RET_STS_UNEXP_ERROR',

291: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
292: (
293: l_api_name,
294: G_PKG_NAME,
295: 'OKL_API.G_RET_STS_UNEXP_ERROR',
296: x_msg_count,
297: x_msg_data,
298: '_PVT'
299: );

Line 301: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

297: x_msg_data,
298: '_PVT'
299: );
300: WHEN OTHERS THEN
301: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
302: (
303: l_api_name,
304: G_PKG_NAME,
305: 'OTHERS',

Line 328: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

324:
325: l_api_name CONSTANT VARCHAR2(40) := 'UPDATE_PERD_ROW';
326: l_api_version CONSTANT NUMBER := 1.0;
327: l_row_count NUMBER;
328: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
329:
330: CURSOR prd_csr (v_period_name VARCHAR2,p_ledger_id NUMBER) IS
331: SELECT closing_status
332: FROM GL_PERIOD_STATUSES

Line 420: x_return_status := OKL_API.G_RET_STS_SUCCESS;

416: l_gl_closing_status GL_PERIOD_STATUSES.closing_status%TYPE;
417:
418: BEGIN
419:
420: x_return_status := OKL_API.G_RET_STS_SUCCESS;
421:
422: IF (p_period_rec.CLOSING_STATUS IS NULL) OR
423: (p_period_rec.CLOSING_STATUS = OKL_API.G_MISS_CHAR) THEN
424:

Line 423: (p_period_rec.CLOSING_STATUS = OKL_API.G_MISS_CHAR) THEN

419:
420: x_return_status := OKL_API.G_RET_STS_SUCCESS;
421:
422: IF (p_period_rec.CLOSING_STATUS IS NULL) OR
423: (p_period_rec.CLOSING_STATUS = OKL_API.G_MISS_CHAR) THEN
424:
425: OKL_API.SET_MESSAGE(p_app_name => g_app_name
426: ,p_msg_name => g_required_value
427: ,p_token1 => g_col_name_token

Line 425: OKL_API.SET_MESSAGE(p_app_name => g_app_name

421:
422: IF (p_period_rec.CLOSING_STATUS IS NULL) OR
423: (p_period_rec.CLOSING_STATUS = OKL_API.G_MISS_CHAR) THEN
424:
425: OKL_API.SET_MESSAGE(p_app_name => g_app_name
426: ,p_msg_name => g_required_value
427: ,p_token1 => g_col_name_token
428: ,p_token1_value => 'PERIOD STATUS');
429:

Line 430: RAISE OKL_API.G_EXCEPTION_ERROR;

426: ,p_msg_name => g_required_value
427: ,p_token1 => g_col_name_token
428: ,p_token1_value => 'PERIOD STATUS');
429:
430: RAISE OKL_API.G_EXCEPTION_ERROR;
431:
432: END IF;
433:
434: OPEN prd_csr(p_period_rec.period_name,p_period_rec.set_of_books_id);

Line 439: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

435: FETCH prd_csr INTO l_closing_status;
436:
437: IF prd_csr%NOTFOUND THEN
438: CLOSE prd_csr;
439: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
440: p_msg_name => 'OKL_PERIOD_NOT_FOUND',
441: p_token1 => 'PERIOD_NAME',
442: p_token1_value => p_period_rec.period_name);
443: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 443: RAISE OKL_API.G_EXCEPTION_ERROR;

439: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
440: p_msg_name => 'OKL_PERIOD_NOT_FOUND',
441: p_token1 => 'PERIOD_NAME',
442: p_token1_value => p_period_rec.period_name);
443: RAISE OKL_API.G_EXCEPTION_ERROR;
444: END IF;
445:
446: CLOSE prd_csr;
447:

Line 454: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

450:
451: IF (l_closing_status = 'N') THEN
452: IF NOT (p_period_rec.closing_status IN('F','O','N')) THEN
453:
454: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
455: p_msg_name => 'OKL_PERD_INVALID_CHANGE',
456: p_token1 => 'PERIOD_NAME',
457: p_token1_value => p_period_rec.period_name);
458:

Line 459: RAISE OKL_API.G_EXCEPTION_ERROR;

455: p_msg_name => 'OKL_PERD_INVALID_CHANGE',
456: p_token1 => 'PERIOD_NAME',
457: p_token1_value => p_period_rec.period_name);
458:
459: RAISE OKL_API.G_EXCEPTION_ERROR;
460:
461: END IF;
462: ELSIF (l_closing_status = 'F') THEN
463: IF NOT (p_period_rec.closing_status IN ('O','F')) THEN

Line 465: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

461: END IF;
462: ELSIF (l_closing_status = 'F') THEN
463: IF NOT (p_period_rec.closing_status IN ('O','F')) THEN
464:
465: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
466: p_msg_name => 'OKL_PERD_INVALID_CHANGE',
467: p_token1 => 'PERIOD_NAME',
468: p_token1_value => p_period_rec.period_name);
469:

Line 470: RAISE OKL_API.G_EXCEPTION_ERROR;

466: p_msg_name => 'OKL_PERD_INVALID_CHANGE',
467: p_token1 => 'PERIOD_NAME',
468: p_token1_value => p_period_rec.period_name);
469:
470: RAISE OKL_API.G_EXCEPTION_ERROR;
471:
472: END IF;
473: ELSIF (l_closing_status = 'O') THEN
474: IF NOT (p_period_rec.closing_status IN ('C','O')) THEN

Line 476: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

472: END IF;
473: ELSIF (l_closing_status = 'O') THEN
474: IF NOT (p_period_rec.closing_status IN ('C','O')) THEN
475:
476: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
477: p_msg_name => 'OKL_PERD_INVALID_CHANGE',
478: p_token1 => 'PERIOD_NAME',
479: p_token1_value => p_period_rec.period_name);
480:

Line 481: RAISE OKL_API.G_EXCEPTION_ERROR;

477: p_msg_name => 'OKL_PERD_INVALID_CHANGE',
478: p_token1 => 'PERIOD_NAME',
479: p_token1_value => p_period_rec.period_name);
480:
481: RAISE OKL_API.G_EXCEPTION_ERROR;
482:
483: END IF;
484: ELSIF (l_closing_status = 'C') THEN
485: IF NOT (p_period_rec.closing_status IN ('O','P','C')) THEN

Line 487: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

483: END IF;
484: ELSIF (l_closing_status = 'C') THEN
485: IF NOT (p_period_rec.closing_status IN ('O','P','C')) THEN
486:
487: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
488: p_msg_name => 'OKL_PERD_INVALID_CHANGE',
489: p_token1 => 'PERIOD_NAME',
490: p_token1_value => p_period_rec.period_name);
491:

Line 492: RAISE OKL_API.G_EXCEPTION_ERROR;

488: p_msg_name => 'OKL_PERD_INVALID_CHANGE',
489: p_token1 => 'PERIOD_NAME',
490: p_token1_value => p_period_rec.period_name);
491:
492: RAISE OKL_API.G_EXCEPTION_ERROR;
493:
494: END IF;
495: ELSIF (l_closing_status = 'P') THEN
496: IF NOT (p_period_rec.closing_status = 'P') THEN

Line 498: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

494: END IF;
495: ELSIF (l_closing_status = 'P') THEN
496: IF NOT (p_period_rec.closing_status = 'P') THEN
497:
498: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
499: p_msg_name => 'OKL_PERD_INVALID_CHANGE',
500: p_token1 => 'PERIOD_NAME',
501: p_token1_value => p_period_rec.period_name);
502:

Line 503: RAISE OKL_API.G_EXCEPTION_ERROR;

499: p_msg_name => 'OKL_PERD_INVALID_CHANGE',
500: p_token1 => 'PERIOD_NAME',
501: p_token1_value => p_period_rec.period_name);
502:
503: RAISE OKL_API.G_EXCEPTION_ERROR;
504: END IF;
505:
506: END IF;
507:

Line 529: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

525: FETCH gl_csr1 INTO l_period_name;
526: CLOSE gl_csr1;
527:
528: IF (l_period_name IS NULL) THEN
529: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
530: p_msg_name => 'OKL_PERD_LATER_THAN_GL',
531: p_token1 => 'PERIOD_NAME',
532: p_token1_value => p_period_rec.period_name);
533: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 533: RAISE OKL_API.G_EXCEPTION_ERROR;

529: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
530: p_msg_name => 'OKL_PERD_LATER_THAN_GL',
531: p_token1 => 'PERIOD_NAME',
532: p_token1_value => p_period_rec.period_name);
533: RAISE OKL_API.G_EXCEPTION_ERROR;
534:
535: END IF;
536:
537: END IF;

Line 552: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

548: CLOSE gl_csr2;
549:
550: IF (l_gl_closing_status IN ('C','P')) THEN
551:
552: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
553: p_msg_name => 'OKL_GL_PERD_NOT_OPEN',
554: p_token1 => 'PERIOD_NAME',
555: p_token1_value => p_period_rec.period_name);
556:

Line 557: RAISE OKL_API.G_EXCEPTION_ERROR;

553: p_msg_name => 'OKL_GL_PERD_NOT_OPEN',
554: p_token1 => 'PERIOD_NAME',
555: p_token1_value => p_period_rec.period_name);
556:
557: RAISE OKL_API.G_EXCEPTION_ERROR;
558:
559: END IF;
560:
561: END IF;

Line 578: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

574: CLOSE prior_csr;
575:
576: IF (l_period_name IS NOT NULL) THEN
577:
578: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
579: p_msg_name => 'OKL_PRIOR_PERD_NOT_OPEN',
580: p_token1 => 'PERIOD_NAME',
581: p_token1_value => p_period_rec.period_name);
582:

Line 593: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

589: OPEN dist_csr(l_start_date,l_end_date,p_period_rec.set_of_books_id);
590: FETCH dist_csr INTO l_dummy;
591:
592: IF (l_dummy = '1')THEN
593: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
594: p_msg_name => 'OKL_PERD_INVALID_CLOSE',
595: p_token1 => 'PERIOD_NAME',
596: p_token1_value => p_period_rec.period_name);
597: CLOSE dist_csr;

Line 598: RAISE OKL_API.G_EXCEPTION_ERROR;

594: p_msg_name => 'OKL_PERD_INVALID_CLOSE',
595: p_token1 => 'PERIOD_NAME',
596: p_token1_value => p_period_rec.period_name);
597: CLOSE dist_csr;
598: RAISE OKL_API.G_EXCEPTION_ERROR;
599:
600: END IF;
601:
602: CLOSE dist_csr;

Line 612: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

608: FETCH unprocessed_events_csr INTO l_dummy;
609: CLOSE unprocessed_events_csr;
610:
611: IF (l_dummy = '1')THEN
612: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
613: p_msg_name => 'OKL_PERD_INVALID_CLOSE',
614: p_token1 => 'PERIOD_NAME',
615: p_token1_value => p_period_rec.period_name);
616: CLOSE unprocessed_events_csr;

Line 617: RAISE OKL_API.G_EXCEPTION_ERROR;

613: p_msg_name => 'OKL_PERD_INVALID_CLOSE',
614: p_token1 => 'PERIOD_NAME',
615: p_token1_value => p_period_rec.period_name);
616: CLOSE unprocessed_events_csr;
617: RAISE OKL_API.G_EXCEPTION_ERROR;
618:
619: END IF;
620:
621:

Line 631: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

627: OPEN aeh_csr(p_period_rec.set_of_books_id);
628: FETCH aeh_csr INTO l_dummy;
629:
630: IF (l_dummy = '1') THEN
631: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
632: p_msg_name => 'OKL_RUN_GL_TRANSFER',
633: p_token1 => 'PERIOD_NAME',
634: p_token1_value => p_period_rec.period_name);
635: CLOSE aeh_csr;

Line 636: RAISE OKL_API.G_EXCEPTION_ERROR;

632: p_msg_name => 'OKL_RUN_GL_TRANSFER',
633: p_token1 => 'PERIOD_NAME',
634: p_token1_value => p_period_rec.period_name);
635: CLOSE aeh_csr;
636: RAISE OKL_API.G_EXCEPTION_ERROR;
637: END IF;
638: CLOSE aeh_csr;
639: */
640: END IF;

Line 656: WHEN OKL_API.G_EXCEPTION_ERROR THEN

652:
653:
654: EXCEPTION
655:
656: WHEN OKL_API.G_EXCEPTION_ERROR THEN
657: x_return_status := OKL_API.G_RET_STS_ERROR;
658:
659: WHEN OTHERS THEN
660: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 657: x_return_status := OKL_API.G_RET_STS_ERROR;

653:
654: EXCEPTION
655:
656: WHEN OKL_API.G_EXCEPTION_ERROR THEN
657: x_return_status := OKL_API.G_RET_STS_ERROR;
658:
659: WHEN OTHERS THEN
660: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
661:

Line 660: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

656: WHEN OKL_API.G_EXCEPTION_ERROR THEN
657: x_return_status := OKL_API.G_RET_STS_ERROR;
658:
659: WHEN OTHERS THEN
660: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
661:
662: END UPDATE_PERD_ROW;
663:
664: END OKL_PERD_STATUS_PVT ;