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

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

47:
48:
49: BEGIN
50:
51: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name
52: ,p_init_msg_list => p_init_msg_list
53: ,p_api_type => '_PVT'
54: ,x_return_status => x_return_status
55: );

Line 56: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

52: ,p_init_msg_list => p_init_msg_list
53: ,p_api_type => '_PVT'
54: ,x_return_status => x_return_status
55: );
56: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
57: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
58: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
59: RAISE OKL_API.G_EXCEPTION_ERROR;
60: END IF;

Line 57: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

53: ,p_api_type => '_PVT'
54: ,x_return_status => x_return_status
55: );
56: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
57: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
58: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
59: RAISE OKL_API.G_EXCEPTION_ERROR;
60: END IF;
61:

Line 58: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

54: ,x_return_status => x_return_status
55: );
56: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
57: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
58: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
59: RAISE OKL_API.G_EXCEPTION_ERROR;
60: END IF;
61:
62: x_return_status := okc_api.g_ret_sts_success;

Line 59: RAISE OKL_API.G_EXCEPTION_ERROR;

55: );
56: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
57: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
58: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
59: RAISE OKL_API.G_EXCEPTION_ERROR;
60: END IF;
61:
62: x_return_status := okc_api.g_ret_sts_success;
63:

Line 79: RAISE OKL_API.G_EXCEPTION_ERROR;

75: p_token1 => 'NUMBER',
76: p_token1_value => l_chr_rec.contract_number );
77:
78: x_return_status := okc_api.g_ret_sts_error;
79: RAISE OKL_API.G_EXCEPTION_ERROR;
80: END IF;
81:
82: OPEN is_k_locked;
83: FETCH is_k_locked into l_chg_request_in_process;

Line 91: RAISE OKL_API.G_EXCEPTION_ERROR;

87: p_msg_name => 'OKL_K_LOCKED'
88: );
89: x_return_status := okc_api.g_ret_sts_error;
90: CLOSE is_k_locked;
91: RAISE OKL_API.G_EXCEPTION_ERROR;
92: END IF;
93:
94: CLOSE is_k_locked;
95:

Line 105: RAISE OKL_API.G_EXCEPTION_ERROR;

101: OKC_API.set_message(p_app_name => g_app_name,
102: p_msg_name => 'OKL_INVALID_K_STATUS',
103: p_token1 => 'STATUS',
104: p_token1_value => l_chr_rec.sts_code);
105: RAISE OKL_API.G_EXCEPTION_ERROR;
106: END IF;
107:
108: OPEN cur_mean(l_status);
109: FETCH cur_mean into l_status_meaning;

Line 119: RAISE OKL_API.G_EXCEPTION_ERROR;

115: OKC_API.set_message(p_app_name => g_app_name,
116: p_msg_name => 'OKL_INVALID_K_STATUS',
117: p_token1 => 'STATUS',
118: p_token1_value => l_chr_rec.sts_code);
119: RAISE OKL_API.G_EXCEPTION_ERROR;
120: ELSIF l_chr_rec.date_terminated IS NOT NULL THEN
121:
122: x_return_status := OKC_API.G_RET_STS_ERROR;
123:

Line 129: RAISE OKL_API.G_EXCEPTION_ERROR;

125: p_msg_name => 'OKL_FUTURE_TERMINATED_K',
126: p_token1 => 'NUMBER',
127: p_token1_value => l_chr_rec.contract_number );
128:
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130:
131: END IF;
132: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
133: ,x_msg_data => x_msg_data

Line 132: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

128:
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130:
131: END IF;
132: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
133: ,x_msg_data => x_msg_data
134: );
135:
136:

Line 138: WHEN OKL_API.G_EXCEPTION_ERROR THEN

134: );
135:
136:
137: EXCEPTION
138: WHEN OKL_API.G_EXCEPTION_ERROR THEN
139:
140: -- x_return_status := l1_return_status;
141:
142: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 142: x_return_status := OKL_API.HANDLE_EXCEPTIONS

138: WHEN OKL_API.G_EXCEPTION_ERROR THEN
139:
140: -- x_return_status := l1_return_status;
141:
142: x_return_status := OKL_API.HANDLE_EXCEPTIONS
143: (p_api_name => l_api_name
144: ,p_pkg_name => G_PKG_NAME
145: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
146: ,x_msg_count => x_msg_count

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

141:
142: x_return_status := OKL_API.HANDLE_EXCEPTIONS
143: (p_api_name => l_api_name
144: ,p_pkg_name => G_PKG_NAME
145: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
146: ,x_msg_count => x_msg_count
147: ,x_msg_data => x_msg_data
148: ,p_api_type => '_PVT'
149: );

Line 152: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

148: ,p_api_type => '_PVT'
149: );
150:
151:
152: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
153:
154: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
155: ,g_pkg_name
156: ,'OKL_API.G_RET_STS_ERROR'

Line 154: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

150:
151:
152: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
153:
154: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
155: ,g_pkg_name
156: ,'OKL_API.G_RET_STS_ERROR'
157: ,x_msg_count
158: ,x_msg_data

Line 156: ,'OKL_API.G_RET_STS_ERROR'

152: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
153:
154: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
155: ,g_pkg_name
156: ,'OKL_API.G_RET_STS_ERROR'
157: ,x_msg_count
158: ,x_msg_data
159: ,'_PVT'
160: );

Line 164: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

160: );
161:
162: WHEN OTHERS THEN
163:
164: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
165: ,g_pkg_name
166: ,'OTHERS'
167: ,x_msg_count
168: ,x_msg_data

Line 246: -- l1_return_status :=OKL_API.G_RET_STS_ERROR;

242: -- Commented by Murthy on 26-Apr-02
243: --update allowed checking is not required here for extend agreement
244: /* IF (OKL_OKC_MIGRATION_A_PVT.update_allowed(p_chr_id) <> 'Y') THEN
245:
246: -- l1_return_status :=OKL_API.G_RET_STS_ERROR;
247:
248: OKC_API.set_message(p_app_name => g_app_name,
249: p_msg_name => 'OKL_VP_UPDATE_NOT_ALLOWED'
250: );

Line 252: RAISE OKL_API.G_EXCEPTION_ERROR;

248: OKC_API.set_message(p_app_name => g_app_name,
249: p_msg_name => 'OKL_VP_UPDATE_NOT_ALLOWED'
250: );
251:
252: RAISE OKL_API.G_EXCEPTION_ERROR;
253:
254: END IF;
255: */
256:

Line 270: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

266:
267: END is_k_extend_allowed;
268:
269: PROCEDURE extend_contract(p_api_version IN NUMBER,
270: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
274: p_ext_header_rec IN extension_header_rec_type)

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

288:
289: l_return_value VARCHAR2(1) := 'N';
290: l_msg_count NUMBER;
291: l_msg_data VARCHAR2(2000);
292: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
293: l_api_version NUMBER := 1.0;
294:
295: l_api_name CONSTANT VARCHAR2(30) := 'extend_contract';
296:

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

303: -- begin of block
304:
305: BEGIN
306:
307: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name
308: ,p_init_msg_list => p_init_msg_list
309: ,p_api_type => '_PVT'
310: ,x_return_status => x_return_status
311: );

Line 312: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

308: ,p_init_msg_list => p_init_msg_list
309: ,p_api_type => '_PVT'
310: ,x_return_status => x_return_status
311: );
312: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
314: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
315: RAISE OKL_API.G_EXCEPTION_ERROR;
316: END IF;

Line 313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

309: ,p_api_type => '_PVT'
310: ,x_return_status => x_return_status
311: );
312: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
314: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
315: RAISE OKL_API.G_EXCEPTION_ERROR;
316: END IF;
317:

Line 314: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

310: ,x_return_status => x_return_status
311: );
312: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
314: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
315: RAISE OKL_API.G_EXCEPTION_ERROR;
316: END IF;
317:
318: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 315: RAISE OKL_API.G_EXCEPTION_ERROR;

311: );
312: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
314: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
315: RAISE OKL_API.G_EXCEPTION_ERROR;
316: END IF;
317:
318: x_return_status := OKL_API.G_RET_STS_SUCCESS;
319:

Line 318: x_return_status := OKL_API.G_RET_STS_SUCCESS;

314: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
315: RAISE OKL_API.G_EXCEPTION_ERROR;
316: END IF;
317:
318: x_return_status := OKL_API.G_RET_STS_SUCCESS;
319:
320: l_contract_id := p_ext_header_rec.p_id;
321:
322: -- Added by Ajay 25-MAR-2002

Line 349: IF ((p_ext_header_rec.p_new_end_date = OKL_API.G_MISS_DATE) OR (p_ext_header_rec.p_new_end_date IS NULL)) THEN

345: --50 lines
346: -- Validate the passed parameters
347: -- new end date should be given
348:
349: IF ((p_ext_header_rec.p_new_end_date = OKL_API.G_MISS_DATE) OR (p_ext_header_rec.p_new_end_date IS NULL)) THEN
350:
351: l1_return_status :=OKL_API.G_RET_STS_ERROR;
352: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_EXT_DT_REQD');
353: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 351: l1_return_status :=OKL_API.G_RET_STS_ERROR;

347: -- new end date should be given
348:
349: IF ((p_ext_header_rec.p_new_end_date = OKL_API.G_MISS_DATE) OR (p_ext_header_rec.p_new_end_date IS NULL)) THEN
350:
351: l1_return_status :=OKL_API.G_RET_STS_ERROR;
352: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_EXT_DT_REQD');
353: RAISE OKL_API.G_EXCEPTION_ERROR;
354: END IF;
355:

Line 352: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_EXT_DT_REQD');

348:
349: IF ((p_ext_header_rec.p_new_end_date = OKL_API.G_MISS_DATE) OR (p_ext_header_rec.p_new_end_date IS NULL)) THEN
350:
351: l1_return_status :=OKL_API.G_RET_STS_ERROR;
352: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_EXT_DT_REQD');
353: RAISE OKL_API.G_EXCEPTION_ERROR;
354: END IF;
355:
356: OPEN cur_k_header(l_contract_id);

Line 353: RAISE OKL_API.G_EXCEPTION_ERROR;

349: IF ((p_ext_header_rec.p_new_end_date = OKL_API.G_MISS_DATE) OR (p_ext_header_rec.p_new_end_date IS NULL)) THEN
350:
351: l1_return_status :=OKL_API.G_RET_STS_ERROR;
352: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_EXT_DT_REQD');
353: RAISE OKL_API.G_EXCEPTION_ERROR;
354: END IF;
355:
356: OPEN cur_k_header(l_contract_id);
357: FETCH cur_k_header INTO l_contract_no,l_scs_code,l_sts_code,l_start_date,l_end_date;

Line 366: l1_return_status :=OKL_API.G_RET_STS_ERROR;

362: -- this if condition checks whether end date date displayed has changed by someone
363: -- when the user tries to extend the contract and throws the error if it's changed
364:
365: IF l_end_date <> p_ext_header_rec.p_current_end_date THEN
366: l1_return_status :=OKL_API.G_RET_STS_ERROR;
367: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_INV_CUR_END_DATE');
368: RAISE OKL_API.G_EXCEPTION_ERROR;
369: END IF;
370:

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

363: -- when the user tries to extend the contract and throws the error if it's changed
364:
365: IF l_end_date <> p_ext_header_rec.p_current_end_date THEN
366: l1_return_status :=OKL_API.G_RET_STS_ERROR;
367: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_INV_CUR_END_DATE');
368: RAISE OKL_API.G_EXCEPTION_ERROR;
369: END IF;
370:
371: IF l_end_date > p_ext_header_rec.p_new_end_date THEN

Line 368: RAISE OKL_API.G_EXCEPTION_ERROR;

364:
365: IF l_end_date <> p_ext_header_rec.p_current_end_date THEN
366: l1_return_status :=OKL_API.G_RET_STS_ERROR;
367: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_INV_CUR_END_DATE');
368: RAISE OKL_API.G_EXCEPTION_ERROR;
369: END IF;
370:
371: IF l_end_date > p_ext_header_rec.p_new_end_date THEN
372: l1_return_status :=OKL_API.G_RET_STS_ERROR;

Line 372: l1_return_status :=OKL_API.G_RET_STS_ERROR;

368: RAISE OKL_API.G_EXCEPTION_ERROR;
369: END IF;
370:
371: IF l_end_date > p_ext_header_rec.p_new_end_date THEN
372: l1_return_status :=OKL_API.G_RET_STS_ERROR;
373: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name =>'OKL_INV_EXT_DATE');
374: RAISE OKL_API.G_EXCEPTION_ERROR;
375: END IF;
376:

Line 373: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name =>'OKL_INV_EXT_DATE');

369: END IF;
370:
371: IF l_end_date > p_ext_header_rec.p_new_end_date THEN
372: l1_return_status :=OKL_API.G_RET_STS_ERROR;
373: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name =>'OKL_INV_EXT_DATE');
374: RAISE OKL_API.G_EXCEPTION_ERROR;
375: END IF;
376:
377: l_ext_header_rec.p_contract_id :=l_contract_id;

Line 374: RAISE OKL_API.G_EXCEPTION_ERROR;

370:
371: IF l_end_date > p_ext_header_rec.p_new_end_date THEN
372: l1_return_status :=OKL_API.G_RET_STS_ERROR;
373: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name =>'OKL_INV_EXT_DATE');
374: RAISE OKL_API.G_EXCEPTION_ERROR;
375: END IF;
376:
377: l_ext_header_rec.p_contract_id :=l_contract_id;
378: l_ext_header_rec.p_contract_number :=l_contract_no;

Line 387: l1_return_status :=OKL_API.G_RET_STS_ERROR;

383: CLOSE cur_k_header;
384:
385: ELSE
386:
387: l1_return_status :=OKL_API.G_RET_STS_ERROR;
388: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
389: p_msg_name => 'OKL_VP_AGREEMENT_NOT_FOUND'
390: );
391: CLOSE cur_k_header;

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

384:
385: ELSE
386:
387: l1_return_status :=OKL_API.G_RET_STS_ERROR;
388: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
389: p_msg_name => 'OKL_VP_AGREEMENT_NOT_FOUND'
390: );
391: CLOSE cur_k_header;
392:

Line 393: RAISE OKL_API.G_EXCEPTION_ERROR;

389: p_msg_name => 'OKL_VP_AGREEMENT_NOT_FOUND'
390: );
391: CLOSE cur_k_header;
392:
393: RAISE OKL_API.G_EXCEPTION_ERROR;
394:
395: END IF;
396: --end 50 lines
397:

Line 399: p_init_msg_list => OKL_API.G_TRUE,

395: END IF;
396: --end 50 lines
397:
398: okc_extend_pub.extend_chr(p_api_version => l_api_version,
399: p_init_msg_list => OKL_API.G_TRUE,
400: x_return_status => l_return_status,
401: x_msg_count => l_msg_count,
402: x_msg_data => l_msg_data,
403: p_extend_in_parameters_rec => l_ext_header_rec);

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

401: x_msg_count => l_msg_count,
402: x_msg_data => l_msg_data,
403: p_extend_in_parameters_rec => l_ext_header_rec);
404:
405: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
406: NULL;
407: ELSE
408: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 408: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

404:
405: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
406: NULL;
407: ELSE
408: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
411: RAISE OKL_API.G_EXCEPTION_ERROR;
412: END IF;

Line 409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

405: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
406: NULL;
407: ELSE
408: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
411: RAISE OKL_API.G_EXCEPTION_ERROR;
412: END IF;
413: END IF;

Line 410: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

406: NULL;
407: ELSE
408: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
411: RAISE OKL_API.G_EXCEPTION_ERROR;
412: END IF;
413: END IF;
414:

Line 411: RAISE OKL_API.G_EXCEPTION_ERROR;

407: ELSE
408: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
411: RAISE OKL_API.G_EXCEPTION_ERROR;
412: END IF;
413: END IF;
414:
415: ELSE

Line 416: l1_return_status :=OKL_API.G_RET_STS_ERROR;

412: END IF;
413: END IF;
414:
415: ELSE
416: l1_return_status :=OKL_API.G_RET_STS_ERROR;
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419:
420: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

Line 417: RAISE OKL_API.G_EXCEPTION_ERROR;

413: END IF;
414:
415: ELSE
416: l1_return_status :=OKL_API.G_RET_STS_ERROR;
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419:
420: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
421: ,x_msg_data => x_msg_data

Line 420: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

416: l1_return_status :=OKL_API.G_RET_STS_ERROR;
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419:
420: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
421: ,x_msg_data => x_msg_data
422: );
423:
424: EXCEPTION

Line 426: WHEN OKL_API.G_EXCEPTION_ERROR THEN

422: );
423:
424: EXCEPTION
425:
426: WHEN OKL_API.G_EXCEPTION_ERROR THEN
427:
428: x_return_status := OKL_API.HANDLE_EXCEPTIONS
429: (p_api_name => l_api_name
430: ,p_pkg_name => G_PKG_NAME

Line 428: x_return_status := OKL_API.HANDLE_EXCEPTIONS

424: EXCEPTION
425:
426: WHEN OKL_API.G_EXCEPTION_ERROR THEN
427:
428: x_return_status := OKL_API.HANDLE_EXCEPTIONS
429: (p_api_name => l_api_name
430: ,p_pkg_name => G_PKG_NAME
431: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
432: ,x_msg_count => x_msg_count

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

427:
428: x_return_status := OKL_API.HANDLE_EXCEPTIONS
429: (p_api_name => l_api_name
430: ,p_pkg_name => G_PKG_NAME
431: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
432: ,x_msg_count => x_msg_count
433: ,x_msg_data => x_msg_data
434: ,p_api_type => '_PVT'
435: );

Line 438: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

434: ,p_api_type => '_PVT'
435: );
436:
437:
438: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
439:
440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
441: ,g_pkg_name
442: ,'OKL_API.G_RET_STS_ERROR'

Line 440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

436:
437:
438: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
439:
440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
441: ,g_pkg_name
442: ,'OKL_API.G_RET_STS_ERROR'
443: ,x_msg_count
444: ,x_msg_data

Line 442: ,'OKL_API.G_RET_STS_ERROR'

438: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
439:
440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
441: ,g_pkg_name
442: ,'OKL_API.G_RET_STS_ERROR'
443: ,x_msg_count
444: ,x_msg_data
445: ,'_PVT'
446: );

Line 450: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

446: );
447:
448: WHEN OTHERS THEN
449:
450: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
451: ,g_pkg_name
452: ,'OTHERS'
453: ,x_msg_count
454: ,x_msg_data