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_SUBSIDY_POOL_PVT dependencies on OKL_API

Line 77: x_return_status := OKL_API.G_RET_STS_SUCCESS;

73: p_event_param_list IN WF_PARAMETER_LIST_T
74: ) IS
75: l_event_param_list WF_PARAMETER_LIST_T ;
76: BEGIN
77: x_return_status := OKL_API.G_RET_STS_SUCCESS;
78: l_event_param_list := p_event_param_list;
79:
80: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
81: p_init_msg_list => p_init_msg_list,

Line 89: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

85: p_event_name => p_event_name,
86: p_parameters => l_event_param_list);
87: EXCEPTION
88: WHEN OTHERS THEN
89: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
90: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
91: END raise_business_event;
92:
93: ---------------------------------------------------------------------------

Line 90: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

86: p_parameters => l_event_param_list);
87: EXCEPTION
88: WHEN OTHERS THEN
89: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
90: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
91: END raise_business_event;
92:
93: ---------------------------------------------------------------------------
94: -- PROCEDURE create_sub_pool

Line 157: l_init_msg_list := OKL_API.g_false;

153: l_effective_to_date := l_sub_pool_rec.effective_to_date;
154: l_total_budgets := l_sub_pool_rec.total_budgets;
155: l_system_date := TRUNC(SYSDATE);
156: l_api_version := 1.0;
157: l_init_msg_list := OKL_API.g_false;
158: l_msg_count := 0;
159:
160: SAVEPOINT create_sub_pool_PVT;
161: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

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

157: l_init_msg_list := OKL_API.g_false;
158: l_msg_count := 0;
159:
160: SAVEPOINT create_sub_pool_PVT;
161: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
162: G_PKG_NAME,
163: p_init_msg_list,
164: l_api_version,
165: p_api_version,

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

165: p_api_version,
166: '_PVT',
167: l_return_status);
168:
169: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
171: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
172: RAISE OKL_API.G_EXCEPTION_ERROR;
173: END IF;

Line 170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

166: '_PVT',
167: l_return_status);
168:
169: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
171: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
172: RAISE OKL_API.G_EXCEPTION_ERROR;
173: END IF;
174:

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

167: l_return_status);
168:
169: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
171: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
172: RAISE OKL_API.G_EXCEPTION_ERROR;
173: END IF;
174:
175: -- check trunc(effective to date) < trunc(sysdate)

Line 172: RAISE OKL_API.G_EXCEPTION_ERROR;

168:
169: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
171: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
172: RAISE OKL_API.G_EXCEPTION_ERROR;
173: END IF;
174:
175: -- check trunc(effective to date) < trunc(sysdate)
176: IF ((p_sub_pool_rec.EFFECTIVE_TO_DATE is NOT NULL) AND (p_sub_pool_rec.EFFECTIVE_TO_DATE < TRUNC(SYSDATE))) THEN

Line 178: l_return_status := OKL_API.G_RET_STS_ERROR;

174:
175: -- check trunc(effective to date) < trunc(sysdate)
176: IF ((p_sub_pool_rec.EFFECTIVE_TO_DATE is NOT NULL) AND (p_sub_pool_rec.EFFECTIVE_TO_DATE < TRUNC(SYSDATE))) THEN
177: -- Message Text: Effective to date must be greater than or equal to system date.
178: l_return_status := OKL_API.G_RET_STS_ERROR;
179: OKL_API.set_message( p_app_name => G_APP_NAME,
180: p_msg_name => 'OKL_AM_DATE_EFF_TO_PAST');
181: RAISE G_EXCEPTION_HALT_VALIDATION;
182: END IF;

Line 179: OKL_API.set_message( p_app_name => G_APP_NAME,

175: -- check trunc(effective to date) < trunc(sysdate)
176: IF ((p_sub_pool_rec.EFFECTIVE_TO_DATE is NOT NULL) AND (p_sub_pool_rec.EFFECTIVE_TO_DATE < TRUNC(SYSDATE))) THEN
177: -- Message Text: Effective to date must be greater than or equal to system date.
178: l_return_status := OKL_API.G_RET_STS_ERROR;
179: OKL_API.set_message( p_app_name => G_APP_NAME,
180: p_msg_name => 'OKL_AM_DATE_EFF_TO_PAST');
181: RAISE G_EXCEPTION_HALT_VALIDATION;
182: END IF;
183:

Line 185: IF (l_total_budgets = OKL_API.G_MISS_NUM OR l_total_budgets IS NULL) THEN

181: RAISE G_EXCEPTION_HALT_VALIDATION;
182: END IF;
183:
184: -- if the totoal budget amount is null set it to zero.
185: IF (l_total_budgets = OKL_API.G_MISS_NUM OR l_total_budgets IS NULL) THEN
186: l_total_budgets := 0;
187: END IF;
188: l_sub_pool_rec.total_budgets := l_total_budgets;
189:

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

195: l_msg_data,
196: l_sub_pool_rec,
197: x_sub_pool_rec);
198:
199: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
200: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
201: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
202: RAISE OKL_API.G_EXCEPTION_ERROR;
203: END IF;

Line 200: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

196: l_sub_pool_rec,
197: x_sub_pool_rec);
198:
199: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
200: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
201: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
202: RAISE OKL_API.G_EXCEPTION_ERROR;
203: END IF;
204:

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

197: x_sub_pool_rec);
198:
199: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
200: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
201: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
202: RAISE OKL_API.G_EXCEPTION_ERROR;
203: END IF;
204:
205: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 202: RAISE OKL_API.G_EXCEPTION_ERROR;

198:
199: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
200: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
201: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
202: RAISE OKL_API.G_EXCEPTION_ERROR;
203: END IF;
204:
205: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
206: x_return_status := l_return_status;

Line 205: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

201: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
202: RAISE OKL_API.G_EXCEPTION_ERROR;
203: END IF;
204:
205: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
206: x_return_status := l_return_status;
207: x_msg_data := l_msg_data;
208: x_msg_count := l_msg_count;
209:

Line 218: x_return_status := OKL_API.HANDLE_EXCEPTIONS

214: END IF;
215:
216: EXCEPTION
217: WHEN G_EXCEPTION_HALT_VALIDATION THEN
218: x_return_status := OKL_API.HANDLE_EXCEPTIONS
219: (
220: l_api_name,
221: G_PKG_NAME,
222: 'OKL_API.G_RET_STS_ERROR',

Line 222: 'OKL_API.G_RET_STS_ERROR',

218: x_return_status := OKL_API.HANDLE_EXCEPTIONS
219: (
220: l_api_name,
221: G_PKG_NAME,
222: 'OKL_API.G_RET_STS_ERROR',
223: x_msg_count,
224: x_msg_data,
225: '_PVT'
226: );

Line 229: WHEN OKL_API.G_EXCEPTION_ERROR THEN

225: '_PVT'
226: );
227:
228:
229: WHEN OKL_API.G_EXCEPTION_ERROR THEN
230: x_return_status := OKL_API.HANDLE_EXCEPTIONS
231: (
232: l_api_name,
233: G_PKG_NAME,

Line 230: x_return_status := OKL_API.HANDLE_EXCEPTIONS

226: );
227:
228:
229: WHEN OKL_API.G_EXCEPTION_ERROR THEN
230: x_return_status := OKL_API.HANDLE_EXCEPTIONS
231: (
232: l_api_name,
233: G_PKG_NAME,
234: 'OKL_API.G_RET_STS_ERROR',

Line 234: 'OKL_API.G_RET_STS_ERROR',

230: x_return_status := OKL_API.HANDLE_EXCEPTIONS
231: (
232: l_api_name,
233: G_PKG_NAME,
234: 'OKL_API.G_RET_STS_ERROR',
235: x_msg_count,
236: x_msg_data,
237: '_PVT'
238: );

Line 241: x_return_status := OKL_API.HANDLE_EXCEPTIONS

237: '_PVT'
238: );
239:
240: WHEN OTHERS THEN
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS
242: (
243: l_api_name,
244: G_PKG_NAME,
245: 'OKL_API.G_OTHERS',

Line 245: 'OKL_API.G_OTHERS',

241: x_return_status := OKL_API.HANDLE_EXCEPTIONS
242: (
243: l_api_name,
244: G_PKG_NAME,
245: 'OKL_API.G_OTHERS',
246: x_msg_count,
247: x_msg_data,
248: '_PVT'
249: );

Line 344: l_init_msg_list := OKL_API.g_false;

340: --cklee 09/12/2005 l_sub_pool_rec.decision_status_code := TRUNC(SYSDATE);
341: l_system_date := TRUNC(SYSDATE);
342: --END:cklee 09/12/2005
343: l_api_version := 1.0;
344: l_init_msg_list := OKL_API.g_false;
345: l_msg_count := 0;
346: l_pool_name := l_sub_pool_rec.subsidy_pool_name;
347:
348: SAVEPOINT update_sub_pool_PVT;

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

345: l_msg_count := 0;
346: l_pool_name := l_sub_pool_rec.subsidy_pool_name;
347:
348: SAVEPOINT update_sub_pool_PVT;
349: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
350: G_PKG_NAME,
351: p_init_msg_list,
352: l_api_version,
353: p_api_version,

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

353: p_api_version,
354: '_PVT',
355: l_return_status);
356:
357: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
360: RAISE OKL_API.G_EXCEPTION_ERROR;
361: END IF;

Line 358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

354: '_PVT',
355: l_return_status);
356:
357: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
360: RAISE OKL_API.G_EXCEPTION_ERROR;
361: END IF;
362:

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

355: l_return_status);
356:
357: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
360: RAISE OKL_API.G_EXCEPTION_ERROR;
361: END IF;
362:
363: OPEN c_get_to_date(l_sub_pool_rec.id);

Line 360: RAISE OKL_API.G_EXCEPTION_ERROR;

356:
357: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
360: RAISE OKL_API.G_EXCEPTION_ERROR;
361: END IF;
362:
363: OPEN c_get_to_date(l_sub_pool_rec.id);
364: FETCH c_get_to_date INTO l_db_effective_to;

Line 376: l_return_status := OKL_API.G_RET_STS_ERROR;

372: -- effective to date cannot be less than the system date if pool status is "NEW"
373: -- if pool status is "ACTIVE" and effective to date is less than system date then change
374: -- the pool status to "EXPIRED".
375: IF(l_sub_pool_rec.decision_status_code = 'NEW') THEN
376: l_return_status := OKL_API.G_RET_STS_ERROR;
377: OKL_API.set_message( p_app_name => G_APP_NAME,
378: p_msg_name => 'OKL_AM_DATE_EFF_TO_PAST');
379: RAISE G_EXCEPTION_HALT_VALIDATION;
380: ELSE

Line 377: OKL_API.set_message( p_app_name => G_APP_NAME,

373: -- if pool status is "ACTIVE" and effective to date is less than system date then change
374: -- the pool status to "EXPIRED".
375: IF(l_sub_pool_rec.decision_status_code = 'NEW') THEN
376: l_return_status := OKL_API.G_RET_STS_ERROR;
377: OKL_API.set_message( p_app_name => G_APP_NAME,
378: p_msg_name => 'OKL_AM_DATE_EFF_TO_PAST');
379: RAISE G_EXCEPTION_HALT_VALIDATION;
380: ELSE
381: l_status_code := 'EXPIRED';

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

432: l_msg_data,
433: l_sub_pool_rec,
434: x_sub_pool_rec);
435:
436: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
437: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
438: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
439: RAISE OKL_API.G_EXCEPTION_ERROR;
440: END IF;

Line 437: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

433: l_sub_pool_rec,
434: x_sub_pool_rec);
435:
436: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
437: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
438: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
439: RAISE OKL_API.G_EXCEPTION_ERROR;
440: END IF;
441:

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

434: x_sub_pool_rec);
435:
436: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
437: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
438: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
439: RAISE OKL_API.G_EXCEPTION_ERROR;
440: END IF;
441:
442: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 439: RAISE OKL_API.G_EXCEPTION_ERROR;

435:
436: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
437: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
438: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
439: RAISE OKL_API.G_EXCEPTION_ERROR;
440: END IF;
441:
442: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
443: x_return_status := l_return_status;

Line 442: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

438: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
439: RAISE OKL_API.G_EXCEPTION_ERROR;
440: END IF;
441:
442: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
443: x_return_status := l_return_status;
444: x_msg_data := l_msg_data;
445: x_msg_count := l_msg_count;
446:

Line 455: x_return_status := OKL_API.HANDLE_EXCEPTIONS

451: END IF;
452:
453: EXCEPTION
454: WHEN G_EXCEPTION_HALT_VALIDATION THEN
455: x_return_status := OKL_API.HANDLE_EXCEPTIONS
456: (
457: l_api_name,
458: G_PKG_NAME,
459: 'OKL_API.G_RET_STS_ERROR',

Line 459: 'OKL_API.G_RET_STS_ERROR',

455: x_return_status := OKL_API.HANDLE_EXCEPTIONS
456: (
457: l_api_name,
458: G_PKG_NAME,
459: 'OKL_API.G_RET_STS_ERROR',
460: x_msg_count,
461: x_msg_data,
462: '_PVT'
463: );

Line 466: WHEN OKL_API.G_EXCEPTION_ERROR THEN

462: '_PVT'
463: );
464:
465:
466: WHEN OKL_API.G_EXCEPTION_ERROR THEN
467: x_return_status := OKL_API.HANDLE_EXCEPTIONS
468: (
469: l_api_name,
470: G_PKG_NAME,

Line 467: x_return_status := OKL_API.HANDLE_EXCEPTIONS

463: );
464:
465:
466: WHEN OKL_API.G_EXCEPTION_ERROR THEN
467: x_return_status := OKL_API.HANDLE_EXCEPTIONS
468: (
469: l_api_name,
470: G_PKG_NAME,
471: 'OKL_API.G_RET_STS_ERROR',

Line 471: 'OKL_API.G_RET_STS_ERROR',

467: x_return_status := OKL_API.HANDLE_EXCEPTIONS
468: (
469: l_api_name,
470: G_PKG_NAME,
471: 'OKL_API.G_RET_STS_ERROR',
472: x_msg_count,
473: x_msg_data,
474: '_PVT'
475: );

Line 478: x_return_status := OKL_API.HANDLE_EXCEPTIONS

474: '_PVT'
475: );
476:
477: WHEN OTHERS THEN
478: x_return_status := OKL_API.HANDLE_EXCEPTIONS
479: (
480: l_api_name,
481: G_PKG_NAME,
482: 'OKL_API.G_OTHERS',

Line 482: 'OKL_API.G_OTHERS',

478: x_return_status := OKL_API.HANDLE_EXCEPTIONS
479: (
480: l_api_name,
481: G_PKG_NAME,
482: 'OKL_API.G_OTHERS',
483: x_msg_count,
484: x_msg_data,
485: '_PVT'
486: );

Line 551: l_init_msg_list := OKL_API.g_false;

547: END IF;
548: l_subsidy_pool_id := p_subsidy_pool_id;
549: l_row_found := FALSE;
550: l_api_version := 1.0;
551: l_init_msg_list := OKL_API.g_false;
552: l_msg_count := 0;
553:
554: SAVEPOINT expire_sub_pool_PVT;
555: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

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

551: l_init_msg_list := OKL_API.g_false;
552: l_msg_count := 0;
553:
554: SAVEPOINT expire_sub_pool_PVT;
555: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
556: G_PKG_NAME,
557: p_init_msg_list,
558: l_api_version,
559: p_api_version,

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

559: p_api_version,
560: '_PVT',
561: l_return_status);
562:
563: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
565: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
566: RAISE OKL_API.G_EXCEPTION_ERROR;
567: END IF;

Line 564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

560: '_PVT',
561: l_return_status);
562:
563: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
565: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
566: RAISE OKL_API.G_EXCEPTION_ERROR;
567: END IF;
568:

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

561: l_return_status);
562:
563: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
565: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
566: RAISE OKL_API.G_EXCEPTION_ERROR;
567: END IF;
568:
569: -- fetch the record with the passed id .

Line 566: RAISE OKL_API.G_EXCEPTION_ERROR;

562:
563: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
565: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
566: RAISE OKL_API.G_EXCEPTION_ERROR;
567: END IF;
568:
569: -- fetch the record with the passed id .
570: OPEN c_get_pool_id(l_subsidy_pool_id);

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

582: l_msg_count,
583: l_msg_data,
584: l_sub_pool_rec,
585: x_sub_pool_rec);
586: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
587: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
588: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
589: RAISE OKL_API.G_EXCEPTION_ERROR;
590: END IF;

Line 587: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

583: l_msg_data,
584: l_sub_pool_rec,
585: x_sub_pool_rec);
586: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
587: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
588: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
589: RAISE OKL_API.G_EXCEPTION_ERROR;
590: END IF;
591: END IF;

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

584: l_sub_pool_rec,
585: x_sub_pool_rec);
586: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
587: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
588: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
589: RAISE OKL_API.G_EXCEPTION_ERROR;
590: END IF;
591: END IF;
592: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 589: RAISE OKL_API.G_EXCEPTION_ERROR;

585: x_sub_pool_rec);
586: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
587: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
588: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
589: RAISE OKL_API.G_EXCEPTION_ERROR;
590: END IF;
591: END IF;
592: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
593: x_return_status := l_return_status;

Line 592: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

588: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
589: RAISE OKL_API.G_EXCEPTION_ERROR;
590: END IF;
591: END IF;
592: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
593: x_return_status := l_return_status;
594: x_msg_data := l_msg_data;
595: x_msg_count := l_msg_count;
596:

Line 606: x_return_status := OKL_API.HANDLE_EXCEPTIONS

602: END IF;
603:
604: EXCEPTION
605: WHEN G_EXCEPTION_HALT_VALIDATION THEN
606: x_return_status := OKL_API.HANDLE_EXCEPTIONS
607: (
608: l_api_name,
609: G_PKG_NAME,
610: 'OKL_API.G_RET_STS_ERROR',

Line 610: 'OKL_API.G_RET_STS_ERROR',

606: x_return_status := OKL_API.HANDLE_EXCEPTIONS
607: (
608: l_api_name,
609: G_PKG_NAME,
610: 'OKL_API.G_RET_STS_ERROR',
611: x_msg_count,
612: x_msg_data,
613: '_PVT'
614: );

Line 616: WHEN OKL_API.G_EXCEPTION_ERROR THEN

612: x_msg_data,
613: '_PVT'
614: );
615:
616: WHEN OKL_API.G_EXCEPTION_ERROR THEN
617: x_return_status := OKL_API.HANDLE_EXCEPTIONS
618: (
619: l_api_name,
620: G_PKG_NAME,

Line 617: x_return_status := OKL_API.HANDLE_EXCEPTIONS

613: '_PVT'
614: );
615:
616: WHEN OKL_API.G_EXCEPTION_ERROR THEN
617: x_return_status := OKL_API.HANDLE_EXCEPTIONS
618: (
619: l_api_name,
620: G_PKG_NAME,
621: 'OKL_API.G_RET_STS_ERROR',

Line 621: 'OKL_API.G_RET_STS_ERROR',

617: x_return_status := OKL_API.HANDLE_EXCEPTIONS
618: (
619: l_api_name,
620: G_PKG_NAME,
621: 'OKL_API.G_RET_STS_ERROR',
622: x_msg_count,
623: x_msg_data,
624: '_PVT'
625: );

Line 628: x_return_status := OKL_API.HANDLE_EXCEPTIONS

624: '_PVT'
625: );
626:
627: WHEN OTHERS THEN
628: x_return_status := OKL_API.HANDLE_EXCEPTIONS
629: (
630: l_api_name,
631: G_PKG_NAME,
632: 'OKL_API.G_OTHERS',

Line 632: 'OKL_API.G_OTHERS',

628: x_return_status := OKL_API.HANDLE_EXCEPTIONS
629: (
630: l_api_name,
631: G_PKG_NAME,
632: 'OKL_API.G_OTHERS',
633: x_msg_count,
634: x_msg_data,
635: '_PVT'
636: );

Line 698: l_init_msg_list := OKL_API.g_false;

694: END IF;
695: l_subsidy_pool_id := p_subsidy_pool_id;
696: l_row_found := FALSE;
697: l_api_version := 1.0;
698: l_init_msg_list := OKL_API.g_false;
699: l_msg_count := 0;
700:
701: SAVEPOINT update_total_budget_PVT;
702: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

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

698: l_init_msg_list := OKL_API.g_false;
699: l_msg_count := 0;
700:
701: SAVEPOINT update_total_budget_PVT;
702: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
703: G_PKG_NAME,
704: p_init_msg_list,
705: l_api_version,
706: p_api_version,

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

706: p_api_version,
707: '_PVT',
708: l_return_status);
709:
710: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
713: RAISE OKL_API.G_EXCEPTION_ERROR;
714: END IF;

Line 711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

707: '_PVT',
708: l_return_status);
709:
710: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
713: RAISE OKL_API.G_EXCEPTION_ERROR;
714: END IF;
715:

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

708: l_return_status);
709:
710: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
713: RAISE OKL_API.G_EXCEPTION_ERROR;
714: END IF;
715:
716: -- fetch the record with the passed id.

Line 713: RAISE OKL_API.G_EXCEPTION_ERROR;

709:
710: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
713: RAISE OKL_API.G_EXCEPTION_ERROR;
714: END IF;
715:
716: -- fetch the record with the passed id.
717: OPEN c_get_pool_id(l_subsidy_pool_id);

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

728: l_msg_count,
729: l_msg_data,
730: l_sub_pool_rec,
731: x_sub_pool_rec);
732: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
733: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
734: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
735: RAISE OKL_API.G_EXCEPTION_ERROR;
736: END IF;

Line 733: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

729: l_msg_data,
730: l_sub_pool_rec,
731: x_sub_pool_rec);
732: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
733: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
734: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
735: RAISE OKL_API.G_EXCEPTION_ERROR;
736: END IF;
737: END IF;

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

730: l_sub_pool_rec,
731: x_sub_pool_rec);
732: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
733: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
734: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
735: RAISE OKL_API.G_EXCEPTION_ERROR;
736: END IF;
737: END IF;
738: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 735: RAISE OKL_API.G_EXCEPTION_ERROR;

731: x_sub_pool_rec);
732: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
733: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
734: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
735: RAISE OKL_API.G_EXCEPTION_ERROR;
736: END IF;
737: END IF;
738: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
739: x_return_status := l_return_status;

Line 738: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

734: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
735: RAISE OKL_API.G_EXCEPTION_ERROR;
736: END IF;
737: END IF;
738: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
739: x_return_status := l_return_status;
740: x_msg_data := l_msg_data;
741: x_msg_count := l_msg_count;
742:

Line 751: x_return_status := OKL_API.HANDLE_EXCEPTIONS

747: END IF;
748:
749: EXCEPTION
750: WHEN G_EXCEPTION_HALT_VALIDATION THEN
751: x_return_status := OKL_API.HANDLE_EXCEPTIONS
752: (
753: l_api_name,
754: G_PKG_NAME,
755: 'OKL_API.G_RET_STS_ERROR',

Line 755: 'OKL_API.G_RET_STS_ERROR',

751: x_return_status := OKL_API.HANDLE_EXCEPTIONS
752: (
753: l_api_name,
754: G_PKG_NAME,
755: 'OKL_API.G_RET_STS_ERROR',
756: x_msg_count,
757: x_msg_data,
758: '_PVT'
759: );

Line 761: WHEN OKL_API.G_EXCEPTION_ERROR THEN

757: x_msg_data,
758: '_PVT'
759: );
760:
761: WHEN OKL_API.G_EXCEPTION_ERROR THEN
762: x_return_status := OKL_API.HANDLE_EXCEPTIONS
763: (
764: l_api_name,
765: G_PKG_NAME,

Line 762: x_return_status := OKL_API.HANDLE_EXCEPTIONS

758: '_PVT'
759: );
760:
761: WHEN OKL_API.G_EXCEPTION_ERROR THEN
762: x_return_status := OKL_API.HANDLE_EXCEPTIONS
763: (
764: l_api_name,
765: G_PKG_NAME,
766: 'OKL_API.G_RET_STS_ERROR',

Line 766: 'OKL_API.G_RET_STS_ERROR',

762: x_return_status := OKL_API.HANDLE_EXCEPTIONS
763: (
764: l_api_name,
765: G_PKG_NAME,
766: 'OKL_API.G_RET_STS_ERROR',
767: x_msg_count,
768: x_msg_data,
769: '_PVT'
770: );

Line 773: x_return_status := OKL_API.HANDLE_EXCEPTIONS

769: '_PVT'
770: );
771:
772: WHEN OTHERS THEN
773: x_return_status := OKL_API.HANDLE_EXCEPTIONS
774: (
775: l_api_name,
776: G_PKG_NAME,
777: 'OKL_API.G_OTHERS',

Line 777: 'OKL_API.G_OTHERS',

773: x_return_status := OKL_API.HANDLE_EXCEPTIONS
774: (
775: l_api_name,
776: G_PKG_NAME,
777: 'OKL_API.G_OTHERS',
778: x_msg_count,
779: x_msg_data,
780: '_PVT'
781: );

Line 844: l_init_msg_list := OKL_API.g_false;

840: END IF;
841: l_subsidy_pool_id := p_subsidy_pool_id;
842: l_row_found := FALSE;
843: l_api_version := 1.0;
844: l_init_msg_list := OKL_API.g_false;
845: l_msg_count := 0;
846:
847: SAVEPOINT update_subsidy_amount_PVT;
848: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

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

844: l_init_msg_list := OKL_API.g_false;
845: l_msg_count := 0;
846:
847: SAVEPOINT update_subsidy_amount_PVT;
848: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
849: G_PKG_NAME,
850: p_init_msg_list,
851: l_api_version,
852: p_api_version,

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

852: p_api_version,
853: '_PVT',
854: l_return_status);
855:
856: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
857: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
858: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
859: RAISE OKL_API.G_EXCEPTION_ERROR;
860: END IF;

Line 857: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

853: '_PVT',
854: l_return_status);
855:
856: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
857: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
858: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
859: RAISE OKL_API.G_EXCEPTION_ERROR;
860: END IF;
861:

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

854: l_return_status);
855:
856: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
857: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
858: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
859: RAISE OKL_API.G_EXCEPTION_ERROR;
860: END IF;
861:
862: OPEN c_get_pool_id(l_subsidy_pool_id);

Line 859: RAISE OKL_API.G_EXCEPTION_ERROR;

855:
856: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
857: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
858: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
859: RAISE OKL_API.G_EXCEPTION_ERROR;
860: END IF;
861:
862: OPEN c_get_pool_id(l_subsidy_pool_id);
863: FETCH c_get_pool_id INTO l_sub_pool_rec;

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

873: l_msg_count,
874: l_msg_data,
875: l_sub_pool_rec,
876: x_sub_pool_rec);
877: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;

Line 878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

874: l_msg_data,
875: l_sub_pool_rec,
876: x_sub_pool_rec);
877: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;
882: END IF;

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

875: l_sub_pool_rec,
876: x_sub_pool_rec);
877: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;
882: END IF;
883: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 880: RAISE OKL_API.G_EXCEPTION_ERROR;

876: x_sub_pool_rec);
877: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;
882: END IF;
883: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
884: x_return_status := l_return_status;

Line 883: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;
882: END IF;
883: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
884: x_return_status := l_return_status;
885: x_msg_data := l_msg_data;
886: x_msg_count := l_msg_count;
887:

Line 896: x_return_status := OKL_API.HANDLE_EXCEPTIONS

892: END IF;
893:
894: EXCEPTION
895: WHEN G_EXCEPTION_HALT_VALIDATION THEN
896: x_return_status := OKL_API.HANDLE_EXCEPTIONS
897: (
898: l_api_name,
899: G_PKG_NAME,
900: 'OKL_API.G_RET_STS_ERROR',

Line 900: 'OKL_API.G_RET_STS_ERROR',

896: x_return_status := OKL_API.HANDLE_EXCEPTIONS
897: (
898: l_api_name,
899: G_PKG_NAME,
900: 'OKL_API.G_RET_STS_ERROR',
901: x_msg_count,
902: x_msg_data,
903: '_PVT'
904: );

Line 906: WHEN OKL_API.G_EXCEPTION_ERROR THEN

902: x_msg_data,
903: '_PVT'
904: );
905:
906: WHEN OKL_API.G_EXCEPTION_ERROR THEN
907: x_return_status := OKL_API.HANDLE_EXCEPTIONS
908: (
909: l_api_name,
910: G_PKG_NAME,

Line 907: x_return_status := OKL_API.HANDLE_EXCEPTIONS

903: '_PVT'
904: );
905:
906: WHEN OKL_API.G_EXCEPTION_ERROR THEN
907: x_return_status := OKL_API.HANDLE_EXCEPTIONS
908: (
909: l_api_name,
910: G_PKG_NAME,
911: 'OKL_API.G_RET_STS_ERROR',

Line 911: 'OKL_API.G_RET_STS_ERROR',

907: x_return_status := OKL_API.HANDLE_EXCEPTIONS
908: (
909: l_api_name,
910: G_PKG_NAME,
911: 'OKL_API.G_RET_STS_ERROR',
912: x_msg_count,
913: x_msg_data,
914: '_PVT'
915: );

Line 918: x_return_status := OKL_API.HANDLE_EXCEPTIONS

914: '_PVT'
915: );
916:
917: WHEN OTHERS THEN
918: x_return_status := OKL_API.HANDLE_EXCEPTIONS
919: (
920: l_api_name,
921: G_PKG_NAME,
922: 'OKL_API.G_OTHERS',

Line 922: 'OKL_API.G_OTHERS',

918: x_return_status := OKL_API.HANDLE_EXCEPTIONS
919: (
920: l_api_name,
921: G_PKG_NAME,
922: 'OKL_API.G_OTHERS',
923: x_msg_count,
924: x_msg_data,
925: '_PVT'
926: );

Line 991: l_init_msg_list := OKL_API.g_false;

987: END IF;
988: l_subsidy_pool_id := p_subsidy_pool_id;
989: l_row_found := FALSE;
990: l_api_version := 1.0;
991: l_init_msg_list := OKL_API.g_false;
992: l_msg_count := 0;
993:
994: SAVEPOINT set_decision_status_code_PVT;
995: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

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

991: l_init_msg_list := OKL_API.g_false;
992: l_msg_count := 0;
993:
994: SAVEPOINT set_decision_status_code_PVT;
995: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
996: G_PKG_NAME,
997: p_init_msg_list,
998: l_api_version,
999: p_api_version,

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

999: p_api_version,
1000: '_PVT',
1001: l_return_status);
1002:
1003: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1005: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1006: RAISE OKL_API.G_EXCEPTION_ERROR;
1007: END IF;

Line 1004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1000: '_PVT',
1001: l_return_status);
1002:
1003: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1005: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1006: RAISE OKL_API.G_EXCEPTION_ERROR;
1007: END IF;
1008:

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

1001: l_return_status);
1002:
1003: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1005: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1006: RAISE OKL_API.G_EXCEPTION_ERROR;
1007: END IF;
1008:
1009: OPEN c_get_pool_id(l_subsidy_pool_id);

Line 1006: RAISE OKL_API.G_EXCEPTION_ERROR;

1002:
1003: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1005: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1006: RAISE OKL_API.G_EXCEPTION_ERROR;
1007: END IF;
1008:
1009: OPEN c_get_pool_id(l_subsidy_pool_id);
1010: FETCH c_get_pool_id INTO l_sub_pool_rec;

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

1021: l_msg_count,
1022: l_msg_data,
1023: l_sub_pool_rec,
1024: x_sub_pool_rec);
1025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1028: RAISE OKL_API.G_EXCEPTION_ERROR;
1029: END IF;

Line 1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1022: l_msg_data,
1023: l_sub_pool_rec,
1024: x_sub_pool_rec);
1025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1028: RAISE OKL_API.G_EXCEPTION_ERROR;
1029: END IF;
1030: IF(l_sub_pool_rec.decision_status_code = 'PENDING')THEN

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

1023: l_sub_pool_rec,
1024: x_sub_pool_rec);
1025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1028: RAISE OKL_API.G_EXCEPTION_ERROR;
1029: END IF;
1030: IF(l_sub_pool_rec.decision_status_code = 'PENDING')THEN
1031: -- add subsidy pool id and subsidy pool to the parameter list and call the corresponding business event.

Line 1028: RAISE OKL_API.G_EXCEPTION_ERROR;

1024: x_sub_pool_rec);
1025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1028: RAISE OKL_API.G_EXCEPTION_ERROR;
1029: END IF;
1030: IF(l_sub_pool_rec.decision_status_code = 'PENDING')THEN
1031: -- add subsidy pool id and subsidy pool to the parameter list and call the corresponding business event.
1032: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_sub_pool_rec.id, l_parameter_list);

Line 1054: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

1050: p_event_param_list => l_parameter_list
1051: );
1052: END IF;
1053: END IF;
1054: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1055: x_return_status := l_return_status;
1056: x_msg_data := l_msg_data;
1057: x_msg_count := l_msg_count;
1058:

Line 1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1063: END IF;
1064:
1065: EXCEPTION
1066: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1068: (
1069: l_api_name,
1070: G_PKG_NAME,
1071: 'OKL_API.G_RET_STS_ERROR',

Line 1071: 'OKL_API.G_RET_STS_ERROR',

1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1068: (
1069: l_api_name,
1070: G_PKG_NAME,
1071: 'OKL_API.G_RET_STS_ERROR',
1072: x_msg_count,
1073: x_msg_data,
1074: '_PVT'
1075: );

Line 1077: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1073: x_msg_data,
1074: '_PVT'
1075: );
1076:
1077: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1078: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1079: (
1080: l_api_name,
1081: G_PKG_NAME,

Line 1078: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1074: '_PVT'
1075: );
1076:
1077: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1078: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1079: (
1080: l_api_name,
1081: G_PKG_NAME,
1082: 'OKL_API.G_RET_STS_ERROR',

Line 1082: 'OKL_API.G_RET_STS_ERROR',

1078: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1079: (
1080: l_api_name,
1081: G_PKG_NAME,
1082: 'OKL_API.G_RET_STS_ERROR',
1083: x_msg_count,
1084: x_msg_data,
1085: '_PVT'
1086: );

Line 1089: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1085: '_PVT'
1086: );
1087:
1088: WHEN OTHERS THEN
1089: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1090: (
1091: l_api_name,
1092: G_PKG_NAME,
1093: 'OKL_API.G_OTHERS',

Line 1093: 'OKL_API.G_OTHERS',

1089: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1090: (
1091: l_api_name,
1092: G_PKG_NAME,
1093: 'OKL_API.G_OTHERS',
1094: x_msg_count,
1095: x_msg_data,
1096: '_PVT'
1097: );

Line 1147: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1143: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.validate_row ');
1144: END;
1145: END IF;
1146: l_api_version := 1.0;
1147: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1148:
1149: -- call START_ACTIVITY to create savepoint, check compatibility
1150: -- and initialize message list
1151:

Line 1152: l_return_status := OKL_API.START_ACTIVITY(

1148:
1149: -- call START_ACTIVITY to create savepoint, check compatibility
1150: -- and initialize message list
1151:
1152: l_return_status := OKL_API.START_ACTIVITY(
1153: p_api_name => l_api_name,
1154: p_pkg_name => g_pkg_name,
1155: p_init_msg_list => p_init_msg_list,
1156: l_api_version => l_api_version,

Line 1162: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1158: p_api_type => g_api_type,
1159: x_return_status => x_return_status);
1160:
1161: -- check if activity started successfully
1162: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1163: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1164: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1165: raise OKL_API.G_EXCEPTION_ERROR;
1166: End If;

Line 1163: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1159: x_return_status => x_return_status);
1160:
1161: -- check if activity started successfully
1162: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1163: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1164: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1165: raise OKL_API.G_EXCEPTION_ERROR;
1166: End If;
1167:

Line 1164: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

1160:
1161: -- check if activity started successfully
1162: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1163: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1164: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1165: raise OKL_API.G_EXCEPTION_ERROR;
1166: End If;
1167:
1168: l_sub_pool_rec := p_sub_pool_rec;

Line 1165: raise OKL_API.G_EXCEPTION_ERROR;

1161: -- check if activity started successfully
1162: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1163: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1164: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1165: raise OKL_API.G_EXCEPTION_ERROR;
1166: End If;
1167:
1168: l_sub_pool_rec := p_sub_pool_rec;
1169:

Line 1180: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1176: x_msg_data => x_msg_data,
1177: p_sipv_rec => l_sub_pool_rec);
1178:
1179: -- check return status
1180: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1181: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1182: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1183: raise OKL_API.G_EXCEPTION_ERROR;
1184: End If;

Line 1181: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1177: p_sipv_rec => l_sub_pool_rec);
1178:
1179: -- check return status
1180: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1181: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1182: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1183: raise OKL_API.G_EXCEPTION_ERROR;
1184: End If;
1185:

Line 1182: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1178:
1179: -- check return status
1180: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1181: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1182: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1183: raise OKL_API.G_EXCEPTION_ERROR;
1184: End If;
1185:
1186: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1183: raise OKL_API.G_EXCEPTION_ERROR;

1179: -- check return status
1180: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1181: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1182: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1183: raise OKL_API.G_EXCEPTION_ERROR;
1184: End If;
1185:
1186: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1187: x_msg_data => x_msg_data);

Line 1186: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1182: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1183: raise OKL_API.G_EXCEPTION_ERROR;
1184: End If;
1185:
1186: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1187: x_msg_data => x_msg_data);
1188:
1189: IF(IS_DEBUG_PROCEDURE_ON) THEN
1190: BEGIN

Line 1196: when OKL_API.G_EXCEPTION_ERROR then

1192: END;
1193: END IF;
1194:
1195: EXCEPTION
1196: when OKL_API.G_EXCEPTION_ERROR then
1197: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1198: p_api_name => l_api_name,
1199: p_pkg_name => g_pkg_name,
1200: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1197: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1193: END IF;
1194:
1195: EXCEPTION
1196: when OKL_API.G_EXCEPTION_ERROR then
1197: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1198: p_api_name => l_api_name,
1199: p_pkg_name => g_pkg_name,
1200: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1201: x_msg_count => x_msg_count,

Line 1200: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1196: when OKL_API.G_EXCEPTION_ERROR then
1197: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1198: p_api_name => l_api_name,
1199: p_pkg_name => g_pkg_name,
1200: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1201: x_msg_count => x_msg_count,
1202: x_msg_data => x_msg_data,
1203: p_api_type => g_api_type);
1204:

Line 1205: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1201: x_msg_count => x_msg_count,
1202: x_msg_data => x_msg_data,
1203: p_api_type => g_api_type);
1204:
1205: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1206: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1207: p_api_name => l_api_name,
1208: p_pkg_name => g_pkg_name,
1209: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1206: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1202: x_msg_data => x_msg_data,
1203: p_api_type => g_api_type);
1204:
1205: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1206: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1207: p_api_name => l_api_name,
1208: p_pkg_name => g_pkg_name,
1209: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1210: x_msg_count => x_msg_count,

Line 1209: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1205: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1206: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1207: p_api_name => l_api_name,
1208: p_pkg_name => g_pkg_name,
1209: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1210: x_msg_count => x_msg_count,
1211: x_msg_data => x_msg_data,
1212: p_api_type => g_api_type);
1213:

Line 1215: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1211: x_msg_data => x_msg_data,
1212: p_api_type => g_api_type);
1213:
1214: when OTHERS then
1215: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1216: p_api_name => l_api_name,
1217: p_pkg_name => g_pkg_name,
1218: p_exc_name => 'OTHERS',
1219: x_msg_count => x_msg_count,