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

Line 81: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name

77: l_api_name CONSTANT VARCHAR2(30) := 'validate_chr';
78:
79: BEGIN
80:
81: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name
82: ,p_init_msg_list => p_init_msg_list
83: ,p_api_type => '_PVT'
84: ,x_return_status => x_return_status
85: );

Line 86: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

82: ,p_init_msg_list => p_init_msg_list
83: ,p_api_type => '_PVT'
84: ,x_return_status => x_return_status
85: );
86: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
87: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
88: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
89: RAISE OKL_API.G_EXCEPTION_ERROR;
90: END IF;

Line 87: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

83: ,p_api_type => '_PVT'
84: ,x_return_status => x_return_status
85: );
86: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
87: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
88: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
89: RAISE OKL_API.G_EXCEPTION_ERROR;
90: END IF;
91:

Line 88: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

84: ,x_return_status => x_return_status
85: );
86: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
87: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
88: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
89: RAISE OKL_API.G_EXCEPTION_ERROR;
90: END IF;
91:
92: x_return_status := okc_api.g_ret_sts_success;

Line 89: RAISE OKL_API.G_EXCEPTION_ERROR;

85: );
86: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
87: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
88: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
89: RAISE OKL_API.G_EXCEPTION_ERROR;
90: END IF;
91:
92: x_return_status := okc_api.g_ret_sts_success;
93:

Line 108: RAISE OKL_API.G_EXCEPTION_ERROR;

104: p_token1 => 'NUMBER',
105: p_token1_value => l_chrv_rec.contract_number);
106:
107: x_return_status := okc_api.g_ret_sts_error;
108: RAISE OKL_API.G_EXCEPTION_ERROR;
109: END if;
110:
111: OPEN is_k_locked;
112: FETCH is_k_locked into l_chg_request_in_process;

Line 122: RAISE OKL_API.G_EXCEPTION_ERROR;

118: );
119:
120: x_return_status := okc_api.g_ret_sts_error;
121: CLOSE is_k_locked;
122: RAISE OKL_API.G_EXCEPTION_ERROR;
123:
124: END IF;
125:
126: CLOSE is_k_locked;

Line 142: RAISE OKL_API.G_EXCEPTION_ERROR;

138: p_msg_name => 'OKL_INVALID_K_STATUS',
139: p_token1 => 'STATUS',
140: p_token1_value => l_chrv_rec.sts_code);
141:
142: RAISE OKL_API.G_EXCEPTION_ERROR;
143:
144: END IF;
145:
146: IF (l_status NOT IN ('ACTIVE','HOLD','SIGNED')) OR (l_status='HOLD' and l_chrv_rec.sts_code='QA_HOLD') THEN

Line 155: RAISE OKL_API.G_EXCEPTION_ERROR;

151: p_msg_name => 'OKL_INVALID_K_STATUS',
152: p_token1 => 'STATUS',
153: p_token1_value => l_meaning);
154:
155: RAISE OKL_API.G_EXCEPTION_ERROR;
156: ELSIF l_chrv_rec.date_terminated is not null THEN
157:
158: x_return_status := OKC_API.G_RET_STS_ERROR;
159:

Line 165: RAISE OKL_API.G_EXCEPTION_ERROR;

161: p_msg_name => 'OKL_FUTURE_TERMINATED_K',
162: p_token1 => 'NUMBER',
163: p_token1_value => l_chrv_rec.contract_number );
164:
165: RAISE OKL_API.G_EXCEPTION_ERROR;
166:
167:
168:
169: END IF;

Line 181: RAISE OKL_API.G_EXCEPTION_ERROR;

177: OKC_API.set_message( p_app_name => g_app_name,
178: p_msg_name =>'OKL_TRMDATE_MORE_END'
179: );
180:
181: RAISE OKL_API.G_EXCEPTION_ERROR;
182: END IF;
183: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
184: ,x_msg_data => x_msg_data
185: );

Line 183: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

179: );
180:
181: RAISE OKL_API.G_EXCEPTION_ERROR;
182: END IF;
183: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
184: ,x_msg_data => x_msg_data
185: );
186: EXCEPTION
187: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 187: WHEN OKL_API.G_EXCEPTION_ERROR THEN

183: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
184: ,x_msg_data => x_msg_data
185: );
186: EXCEPTION
187: WHEN OKL_API.G_EXCEPTION_ERROR THEN
188:
189: -- x_return_status := l1_return_status;
190:
191: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 191: x_return_status := OKL_API.HANDLE_EXCEPTIONS

187: WHEN OKL_API.G_EXCEPTION_ERROR THEN
188:
189: -- x_return_status := l1_return_status;
190:
191: x_return_status := OKL_API.HANDLE_EXCEPTIONS
192: (p_api_name => l_api_name
193: ,p_pkg_name => G_PKG_NAME
194: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
195: ,x_msg_count => x_msg_count

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

190:
191: x_return_status := OKL_API.HANDLE_EXCEPTIONS
192: (p_api_name => l_api_name
193: ,p_pkg_name => G_PKG_NAME
194: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
195: ,x_msg_count => x_msg_count
196: ,x_msg_data => x_msg_data
197: ,p_api_type => '_PVT'
198: );

Line 201: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

197: ,p_api_type => '_PVT'
198: );
199:
200:
201: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
202:
203: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
204: ,g_pkg_name
205: ,'OKL_API.G_RET_STS_ERROR'

Line 203: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

199:
200:
201: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
202:
203: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
204: ,g_pkg_name
205: ,'OKL_API.G_RET_STS_ERROR'
206: ,x_msg_count
207: ,x_msg_data

Line 205: ,'OKL_API.G_RET_STS_ERROR'

201: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
202:
203: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
204: ,g_pkg_name
205: ,'OKL_API.G_RET_STS_ERROR'
206: ,x_msg_count
207: ,x_msg_data
208: ,'_PVT'
209: );

Line 213: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

209: );
210:
211: WHEN OTHERS THEN
212:
213: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
214: ,g_pkg_name
215: ,'OTHERS'
216: ,x_msg_count
217: ,x_msg_data

Line 277: l1_return_status :=OKL_API.G_RET_STS_ERROR;

273: -- Commented by Murthy on 26-Apr-02
274: --update allowed checking is not required here for extend agreement
275: /*IF (OKL_OKC_MIGRATION_A_PVT.update_allowed(p_chr_id) <> 'Y') THEN
276:
277: l1_return_status :=OKL_API.G_RET_STS_ERROR;
278:
279: OKC_API.set_message(p_app_name => g_app_name,
280: p_msg_name => 'OKL_VP_UPDATE_NOT_ALLOWED'
281: );

Line 283: RAISE OKL_API.G_EXCEPTION_ERROR;

279: OKC_API.set_message(p_app_name => g_app_name,
280: p_msg_name => 'OKL_VP_UPDATE_NOT_ALLOWED'
281: );
282:
283: RAISE OKL_API.G_EXCEPTION_ERROR;
284:
285: END IF;
286: */
287:

Line 318: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

314: RETURN(l_return_value);
315: END is_k_term_allowed;
316:
317: PROCEDURE terminate_contract(p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: p_ter_header_rec IN terminate_header_rec_type)

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

340: l_api_version NUMBER := 1.0;
341:
342: l_api_name CONSTANT VARCHAR2(30) := 'terminate_contract';
343:
344: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
345:
346: l1_return_status VARCHAR2(3);
347:
348:

Line 358: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name

354: -- begin of block
355:
356: BEGIN
357:
358: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name
359: ,p_init_msg_list => p_init_msg_list
360: ,p_api_type => '_PVT'
361: ,x_return_status => x_return_status
362: );

Line 363: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

359: ,p_init_msg_list => p_init_msg_list
360: ,p_api_type => '_PVT'
361: ,x_return_status => x_return_status
362: );
363: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
365: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
366: RAISE OKL_API.G_EXCEPTION_ERROR;
367: END IF;

Line 364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

360: ,p_api_type => '_PVT'
361: ,x_return_status => x_return_status
362: );
363: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
365: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
366: RAISE OKL_API.G_EXCEPTION_ERROR;
367: END IF;
368:

Line 365: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

361: ,x_return_status => x_return_status
362: );
363: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
365: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
366: RAISE OKL_API.G_EXCEPTION_ERROR;
367: END IF;
368:
369:

Line 366: RAISE OKL_API.G_EXCEPTION_ERROR;

362: );
363: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
365: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
366: RAISE OKL_API.G_EXCEPTION_ERROR;
367: END IF;
368:
369:
370:

Line 371: x_return_status := OKL_API.G_RET_STS_SUCCESS;

367: END IF;
368:
369:
370:
371: x_return_status := OKL_API.G_RET_STS_SUCCESS;
372:
373: l_contract_id :=p_ter_header_rec.p_id;
374:
375: -- Added by Ajay 25-MAR-2002

Line 402: IF ((p_ter_header_rec.p_terminate_date = OKL_API.G_MISS_DATE) OR (p_ter_header_rec.p_terminate_date IS NULL)) THEN

398: END IF;
399: --59 lines
400: -- validate the passed parameters ie end date.
401:
402: IF ((p_ter_header_rec.p_terminate_date = OKL_API.G_MISS_DATE) OR (p_ter_header_rec.p_terminate_date IS NULL)) THEN
403:
404: l1_return_status :=OKL_API.G_RET_STS_ERROR;
405: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_TERM_DT_REQD');
406: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 404: l1_return_status :=OKL_API.G_RET_STS_ERROR;

400: -- validate the passed parameters ie end date.
401:
402: IF ((p_ter_header_rec.p_terminate_date = OKL_API.G_MISS_DATE) OR (p_ter_header_rec.p_terminate_date IS NULL)) THEN
403:
404: l1_return_status :=OKL_API.G_RET_STS_ERROR;
405: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_TERM_DT_REQD');
406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;
408:

Line 405: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_TERM_DT_REQD');

401:
402: IF ((p_ter_header_rec.p_terminate_date = OKL_API.G_MISS_DATE) OR (p_ter_header_rec.p_terminate_date IS NULL)) THEN
403:
404: l1_return_status :=OKL_API.G_RET_STS_ERROR;
405: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_TERM_DT_REQD');
406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;
408:
409: OPEN cur_k_header(l_contract_id);

Line 406: RAISE OKL_API.G_EXCEPTION_ERROR;

402: IF ((p_ter_header_rec.p_terminate_date = OKL_API.G_MISS_DATE) OR (p_ter_header_rec.p_terminate_date IS NULL)) THEN
403:
404: l1_return_status :=OKL_API.G_RET_STS_ERROR;
405: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_TERM_DT_REQD');
406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;
408:
409: OPEN cur_k_header(l_contract_id);
410: FETCH cur_k_header INTO l_contract_no,l_scs_code,l_sts_code,l_end_date;

Line 417: l1_return_status :=OKL_API.G_RET_STS_ERROR;

413:
414:
415: IF l_end_date <> p_ter_header_rec.p_current_end_date THEN
416:
417: l1_return_status :=OKL_API.G_RET_STS_ERROR;
418: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_INV_CUR_END_DATE');
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: END IF;
421:

Line 418: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_INV_CUR_END_DATE');

414:
415: IF l_end_date <> p_ter_header_rec.p_current_end_date THEN
416:
417: l1_return_status :=OKL_API.G_RET_STS_ERROR;
418: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_INV_CUR_END_DATE');
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: END IF;
421:
422:

Line 419: RAISE OKL_API.G_EXCEPTION_ERROR;

415: IF l_end_date <> p_ter_header_rec.p_current_end_date THEN
416:
417: l1_return_status :=OKL_API.G_RET_STS_ERROR;
418: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_INV_CUR_END_DATE');
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: END IF;
421:
422:
423:

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

423:
424: IF (p_ter_header_rec.p_terminate_date < trunc(sysdate)) THEN
425:
426:
427: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
428: p_msg_name => 'OKL_INV_TERM_DATE'
429: );
430:
431:

Line 432: l1_return_status :=OKL_API.G_RET_STS_ERROR;

428: p_msg_name => 'OKL_INV_TERM_DATE'
429: );
430:
431:
432: l1_return_status :=OKL_API.G_RET_STS_ERROR;
433:
434: RAISE OKL_API.G_EXCEPTION_ERROR;
435:
436: END IF;

Line 434: RAISE OKL_API.G_EXCEPTION_ERROR;

430:
431:
432: l1_return_status :=OKL_API.G_RET_STS_ERROR;
433:
434: RAISE OKL_API.G_EXCEPTION_ERROR;
435:
436: END IF;
437:
438:

Line 449: l1_return_status :=OKL_API.G_RET_STS_ERROR;

445:
446: CLOSE cur_k_header;
447:
448: ELSE
449: l1_return_status :=OKL_API.G_RET_STS_ERROR;
450:
451: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
452: p_msg_name => 'OKL_VP_AGREEMENT_NOT_FOUND');
453:

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

447:
448: ELSE
449: l1_return_status :=OKL_API.G_RET_STS_ERROR;
450:
451: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
452: p_msg_name => 'OKL_VP_AGREEMENT_NOT_FOUND');
453:
454: CLOSE cur_k_header;
455:

Line 456: RAISE OKL_API.G_EXCEPTION_ERROR;

452: p_msg_name => 'OKL_VP_AGREEMENT_NOT_FOUND');
453:
454: CLOSE cur_k_header;
455:
456: RAISE OKL_API.G_EXCEPTION_ERROR;
457:
458: END IF;
459: --59 lines end
460: okc_terminate_pub.terminate_chr(p_api_version => l_api_version,

Line 464: p_init_msg_list => OKL_API.G_TRUE,

460: okc_terminate_pub.terminate_chr(p_api_version => l_api_version,
461: x_return_status => l_return_status,
462: x_msg_data => l_msg_data,
463: x_msg_count => l_msg_count,
464: p_init_msg_list => OKL_API.G_TRUE,
465: p_terminate_in_parameters_rec => l1_ter_header_rec);
466:
467: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
468: NULL;

Line 467: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

463: x_msg_count => l_msg_count,
464: p_init_msg_list => OKL_API.G_TRUE,
465: p_terminate_in_parameters_rec => l1_ter_header_rec);
466:
467: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
468: NULL;
469: ELSE
470: l1_return_status :=l_return_status;
471:

Line 472: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

468: NULL;
469: ELSE
470: l1_return_status :=l_return_status;
471:
472: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
474: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
475: RAISE OKL_API.G_EXCEPTION_ERROR;
476: END IF;

Line 473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

469: ELSE
470: l1_return_status :=l_return_status;
471:
472: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
474: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
475: RAISE OKL_API.G_EXCEPTION_ERROR;
476: END IF;
477: END IF;

Line 474: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

470: l1_return_status :=l_return_status;
471:
472: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
474: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
475: RAISE OKL_API.G_EXCEPTION_ERROR;
476: END IF;
477: END IF;
478:

Line 475: RAISE OKL_API.G_EXCEPTION_ERROR;

471:
472: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
474: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
475: RAISE OKL_API.G_EXCEPTION_ERROR;
476: END IF;
477: END IF;
478:
479: ELSE

Line 480: l1_return_status :=OKL_API.G_RET_STS_ERROR;

476: END IF;
477: END IF;
478:
479: ELSE
480: l1_return_status :=OKL_API.G_RET_STS_ERROR;
481: RAISE OKL_API.G_EXCEPTION_ERROR;
482: END IF;
483:
484: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

Line 481: RAISE OKL_API.G_EXCEPTION_ERROR;

477: END IF;
478:
479: ELSE
480: l1_return_status :=OKL_API.G_RET_STS_ERROR;
481: RAISE OKL_API.G_EXCEPTION_ERROR;
482: END IF;
483:
484: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
485: ,x_msg_data => x_msg_data

Line 484: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

480: l1_return_status :=OKL_API.G_RET_STS_ERROR;
481: RAISE OKL_API.G_EXCEPTION_ERROR;
482: END IF;
483:
484: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
485: ,x_msg_data => x_msg_data
486: );
487:
488:

Line 492: WHEN OKL_API.G_EXCEPTION_ERROR THEN

488:
489:
490: EXCEPTION
491:
492: WHEN OKL_API.G_EXCEPTION_ERROR THEN
493:
494: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name
495: ,p_pkg_name => G_PKG_NAME
496: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'

Line 494: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name

490: EXCEPTION
491:
492: WHEN OKL_API.G_EXCEPTION_ERROR THEN
493:
494: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name
495: ,p_pkg_name => G_PKG_NAME
496: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
497: ,x_msg_count => x_msg_count
498: ,x_msg_data => x_msg_data

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

492: WHEN OKL_API.G_EXCEPTION_ERROR THEN
493:
494: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name
495: ,p_pkg_name => G_PKG_NAME
496: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
497: ,x_msg_count => x_msg_count
498: ,x_msg_data => x_msg_data
499: ,p_api_type => '_PVT'
500: );

Line 503: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

499: ,p_api_type => '_PVT'
500: );
501:
502:
503: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
504:
505: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
506: ,g_pkg_name
507: ,'OKL_API.G_RET_STS_ERROR'

Line 505: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

501:
502:
503: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
504:
505: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
506: ,g_pkg_name
507: ,'OKL_API.G_RET_STS_ERROR'
508: ,x_msg_count
509: ,x_msg_data

Line 507: ,'OKL_API.G_RET_STS_ERROR'

503: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
504:
505: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
506: ,g_pkg_name
507: ,'OKL_API.G_RET_STS_ERROR'
508: ,x_msg_count
509: ,x_msg_data
510: ,'_PVT'
511: );

Line 515: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

511: );
512:
513: WHEN OTHERS THEN
514:
515: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
516: ,g_pkg_name
517: ,'OTHERS'
518: ,x_msg_count
519: ,x_msg_data