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_SETUPDSFPARAMETERS_PVT dependencies on OKC_API

Line 163: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

159:
160: BEGIN
161:
162: -- initialize return status
163: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
164:
165: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_FNCT_PARMS_CRUPD','OKL_PARAMETER');
166:
167:

Line 168: IF p_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM OR

164:
165: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_FNCT_PARMS_CRUPD','OKL_PARAMETER');
166:
167:
168: IF p_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM OR
169: p_fprv_rec.pmr_id IS NULL THEN
170: --Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);
171: Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name
172: ,p_msg_name => Okl_fpr_Pvt.g_required_value

Line 170: --Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);

166:
167:
168: IF p_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM OR
169: p_fprv_rec.pmr_id IS NULL THEN
170: --Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);
171: Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name
172: ,p_msg_name => Okl_fpr_Pvt.g_required_value
173: ,p_token1 => Okl_fpr_Pvt.g_col_name_token
174: ,p_token1_value => l_token_1);

Line 171: Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name

167:
168: IF p_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM OR
169: p_fprv_rec.pmr_id IS NULL THEN
170: --Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);
171: Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name
172: ,p_msg_name => Okl_fpr_Pvt.g_required_value
173: ,p_token1 => Okl_fpr_Pvt.g_col_name_token
174: ,p_token1_value => l_token_1);
175: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 175: x_return_status := Okc_Api.G_RET_STS_ERROR;

171: Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name
172: ,p_msg_name => Okl_fpr_Pvt.g_required_value
173: ,p_token1 => Okl_fpr_Pvt.g_col_name_token
174: ,p_token1_value => l_token_1);
175: x_return_status := Okc_Api.G_RET_STS_ERROR;
176: END IF;
177:
178: -- RPOONUGA001: Modified the if condition to check the validility
179: -- in the case of valid pmr_id passed

Line 188: --Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);

184: l_row_not_found := okl_pmrv_pk_csr%NOTFOUND;
185: CLOSE okl_pmrv_pk_csr;
186:
187: IF l_row_not_found THEN
188: --Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);
189:
190: Okc_Api.set_message(Okl_fpr_Pvt.G_APP_NAME, Okl_fpr_Pvt.G_INVALID_VALUE,Okl_fpr_Pvt.G_COL_NAME_TOKEN,l_token_1);
191:
192: /*Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name

Line 190: Okc_Api.set_message(Okl_fpr_Pvt.G_APP_NAME, Okl_fpr_Pvt.G_INVALID_VALUE,Okl_fpr_Pvt.G_COL_NAME_TOKEN,l_token_1);

186:
187: IF l_row_not_found THEN
188: --Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);
189:
190: Okc_Api.set_message(Okl_fpr_Pvt.G_APP_NAME, Okl_fpr_Pvt.G_INVALID_VALUE,Okl_fpr_Pvt.G_COL_NAME_TOKEN,l_token_1);
191:
192: /*Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name
193: ,p_msg_name => Okl_fpr_Pvt.g_required_value
194: ,p_token1 => Okl_fpr_Pvt.g_col_name_token

Line 192: /*Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name

188: --Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);
189:
190: Okc_Api.set_message(Okl_fpr_Pvt.G_APP_NAME, Okl_fpr_Pvt.G_INVALID_VALUE,Okl_fpr_Pvt.G_COL_NAME_TOKEN,l_token_1);
191:
192: /*Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name
193: ,p_msg_name => Okl_fpr_Pvt.g_required_value
194: ,p_token1 => Okl_fpr_Pvt.g_col_name_token
195: ,p_token1_value => l_token_1);*/
196: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 196: x_return_status := Okc_Api.G_RET_STS_ERROR;

192: /*Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name
193: ,p_msg_name => Okl_fpr_Pvt.g_required_value
194: ,p_token1 => Okl_fpr_Pvt.g_col_name_token
195: ,p_token1_value => l_token_1);*/
196: x_return_status := Okc_Api.G_RET_STS_ERROR;
197: END IF;
198: END IF;
199:
200: EXCEPTION

Line 208: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

204: NULL;
205:
206: WHEN OTHERS THEN
207: -- store SQL error message on message stack for caller
208: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
209: ,p_msg_name => G_UNEXPECTED_ERROR
210: ,p_token1 => G_SQLCODE_TOKEN
211: ,p_token1_value => SQLCODE
212: ,p_token2 => G_SQLERRM_TOKEN

Line 216: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

212: ,p_token2 => G_SQLERRM_TOKEN
213: ,p_token2_value => SQLERRM);
214:
215: -- notify caller of an UNEXPECTED error
216: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
217:
218: -- verify that the cursor was closed
219: IF okl_pmrv_pk_csr%ISOPEN THEN
220: CLOSE okl_pmrv_pk_csr;

Line 241: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

237: PROCEDURE Validate_sequence_number(p_fprv_rec IN fprv_rec_type
238: ,x_return_status OUT NOCOPY VARCHAR2 )
239: IS
240:
241: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
242: l_token_1 VARCHAR2(1999);
243:
244: BEGIN
245: -- initialize return status

Line 246: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

242: l_token_1 VARCHAR2(1999);
243:
244: BEGIN
245: -- initialize return status
246: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
247:
248: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_FNCT_PARMS_CRUPD','OKL_SEQUENCE');
249:
250: -- check for data before processing

Line 251: IF (p_fprv_rec.sequence_number IS NULL) AND (p_fprv_rec.sequence_number = Okc_Api.G_MISS_NUM) THEN

247:
248: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_FNCT_PARMS_CRUPD','OKL_SEQUENCE');
249:
250: -- check for data before processing
251: IF (p_fprv_rec.sequence_number IS NULL) AND (p_fprv_rec.sequence_number = Okc_Api.G_MISS_NUM) THEN
252: Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name
253: ,p_msg_name => Okl_fpr_Pvt.g_required_value
254: ,p_token1 => Okl_fpr_Pvt.g_col_name_token
255: ,p_token1_value => l_token_1);

Line 252: Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name

248: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_FNCT_PARMS_CRUPD','OKL_SEQUENCE');
249:
250: -- check for data before processing
251: IF (p_fprv_rec.sequence_number IS NULL) AND (p_fprv_rec.sequence_number = Okc_Api.G_MISS_NUM) THEN
252: Okc_Api.SET_MESSAGE(p_app_name => Okl_fpr_Pvt.g_app_name
253: ,p_msg_name => Okl_fpr_Pvt.g_required_value
254: ,p_token1 => Okl_fpr_Pvt.g_col_name_token
255: ,p_token1_value => l_token_1);
256:

Line 257: x_return_status := Okc_Api.G_RET_STS_ERROR;

253: ,p_msg_name => Okl_fpr_Pvt.g_required_value
254: ,p_token1 => Okl_fpr_Pvt.g_col_name_token
255: ,p_token1_value => l_token_1);
256:
257: x_return_status := Okc_Api.G_RET_STS_ERROR;
258: RAISE G_EXCEPTION_HALT_PROCESSING;
259: END IF;
260:
261: EXCEPTION

Line 269: Okc_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,

265: NULL;
266:
267: WHEN OTHERS THEN
268: -- store SQL error message on message stack for caller
269: Okc_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
270: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
271: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
272: p_token1_value => SQLCODE,
273: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 277: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

273: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
274: p_token2_value => SQLERRM);
275:
276: -- notify caller of an UNEXPECTED error
277: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
278:
279: END Validate_sequence_number;
280:
281: ---------------------------------------------------------------------------

Line 298: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

294: FUNCTION Validate_Attributes (
295: p_fprv_rec IN fprv_rec_type
296: ) RETURN VARCHAR2 IS
297:
298: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
299: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
300: BEGIN
301: -- call each column-level validation
302:

Line 299: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

295: p_fprv_rec IN fprv_rec_type
296: ) RETURN VARCHAR2 IS
297:
298: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
299: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
300: BEGIN
301: -- call each column-level validation
302:
303: -- Validate_Pmr_Id

Line 305: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

301: -- call each column-level validation
302:
303: -- Validate_Pmr_Id
304: Validate_Pmr_Id(p_fprv_rec, x_return_status);
305: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
306: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
307: -- need to exit
308: l_return_status := x_return_status;
309: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 306: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

302:
303: -- Validate_Pmr_Id
304: Validate_Pmr_Id(p_fprv_rec, x_return_status);
305: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
306: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
307: -- need to exit
308: l_return_status := x_return_status;
309: RAISE G_EXCEPTION_HALT_PROCESSING;
310: ELSE

Line 318: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

314: END IF;
315:
316: -- Validate_sequence_number
317: Validate_sequence_number(p_fprv_rec, x_return_status);
318: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
319: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
320: -- need to exit
321: l_return_status := x_return_status;
322: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 319: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

315:
316: -- Validate_sequence_number
317: Validate_sequence_number(p_fprv_rec, x_return_status);
318: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
319: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
320: -- need to exit
321: l_return_status := x_return_status;
322: RAISE G_EXCEPTION_HALT_PROCESSING;
323: ELSE

Line 338: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

334: RETURN (l_return_status);
335:
336: WHEN OTHERS THEN
337: -- store SQL error message on message stack for caller
338: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
339: p_msg_name => g_unexpected_error,
340: p_token1 => g_sqlcode_token,
341: p_token1_value => SQLCODE,
342: p_token2 => g_sqlerrm_token,

Line 345: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

341: p_token1_value => SQLCODE,
342: p_token2 => g_sqlerrm_token,
343: p_token2_value => SQLERRM);
344: -- notify caller of an UNEXPECTED error
345: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
346:
347: RETURN(l_return_status);
348: END Validate_Attributes;
349:

Line 364: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

360: x_fprv_rec OUT NOCOPY fprv_rec_type
361: ) IS
362: l_api_version CONSTANT NUMBER := 1;
363: l_api_name CONSTANT VARCHAR2(30) := 'insert_dsfparameters';
364: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
365: l_valid BOOLEAN;
366: l_dsfv_rec dsfv_rec_type;
367: l_fprv_rec fprv_rec_type;
368: BEGIN

Line 369: x_return_status := OKC_API.G_RET_STS_SUCCESS;

365: l_valid BOOLEAN;
366: l_dsfv_rec dsfv_rec_type;
367: l_fprv_rec fprv_rec_type;
368: BEGIN
369: x_return_status := OKC_API.G_RET_STS_SUCCESS;
370: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
371: p_pkg_name => G_PKG_NAME,
372: p_init_msg_list => p_init_msg_list,
373: l_api_version => l_api_version,

Line 370: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

366: l_dsfv_rec dsfv_rec_type;
367: l_fprv_rec fprv_rec_type;
368: BEGIN
369: x_return_status := OKC_API.G_RET_STS_SUCCESS;
370: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
371: p_pkg_name => G_PKG_NAME,
372: p_init_msg_list => p_init_msg_list,
373: l_api_version => l_api_version,
374: p_api_version => p_api_version,

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

373: l_api_version => l_api_version,
374: p_api_version => p_api_version,
375: p_api_type => '_PVT',
376: x_return_status => l_return_status);
377: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
378: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
379: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
380: RAISE OKC_API.G_EXCEPTION_ERROR;
381: END IF;

Line 378: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

374: p_api_version => p_api_version,
375: p_api_type => '_PVT',
376: x_return_status => l_return_status);
377: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
378: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
379: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
380: RAISE OKC_API.G_EXCEPTION_ERROR;
381: END IF;
382:

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

375: p_api_type => '_PVT',
376: x_return_status => l_return_status);
377: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
378: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
379: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
380: RAISE OKC_API.G_EXCEPTION_ERROR;
381: END IF;
382:
383: l_dsfv_rec := p_dsfv_rec;

Line 380: RAISE OKC_API.G_EXCEPTION_ERROR;

376: x_return_status => l_return_status);
377: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
378: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
379: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
380: RAISE OKC_API.G_EXCEPTION_ERROR;
381: END IF;
382:
383: l_dsfv_rec := p_dsfv_rec;
384: l_fprv_rec := p_fprv_rec;

Line 388: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

384: l_fprv_rec := p_fprv_rec;
385:
386: l_return_status := Validate_Attributes(l_fprv_rec);
387: --- If any errors happen abort API
388: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
389: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
390: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
391: RAISE Okc_Api.G_EXCEPTION_ERROR;
392: END IF;

Line 389: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

385:
386: l_return_status := Validate_Attributes(l_fprv_rec);
387: --- If any errors happen abort API
388: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
389: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
390: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
391: RAISE Okc_Api.G_EXCEPTION_ERROR;
392: END IF;
393:

Line 390: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

386: l_return_status := Validate_Attributes(l_fprv_rec);
387: --- If any errors happen abort API
388: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
389: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
390: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
391: RAISE Okc_Api.G_EXCEPTION_ERROR;
392: END IF;
393:
394: /* call check_constraints to check the validity of this relationship */

Line 391: RAISE Okc_Api.G_EXCEPTION_ERROR;

387: --- If any errors happen abort API
388: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
389: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
390: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
391: RAISE Okc_Api.G_EXCEPTION_ERROR;
392: END IF;
393:
394: /* call check_constraints to check the validity of this relationship */
395: check_constraints(p_fprv_rec => l_fprv_rec,

Line 399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

395: check_constraints(p_fprv_rec => l_fprv_rec,
396: x_return_status => l_return_status,
397: x_valid => l_valid);
398: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
401: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
402: l_valid <> TRUE) THEN
403: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 404: RAISE OKC_API.G_EXCEPTION_ERROR;

400: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
401: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
402: l_valid <> TRUE) THEN
403: x_return_status := OKL_API.G_RET_STS_ERROR;
404: RAISE OKC_API.G_EXCEPTION_ERROR;
405: END IF;
406:
407: /* public api to insert function parameters */
408: okl_fnctn_prmtrs_pub.insert_fnctn_prmtrs(p_api_version => p_api_version,

Line 416: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

412: x_msg_data => x_msg_data,
413: p_fprv_rec => l_fprv_rec,
414: x_fprv_rec => x_fprv_rec);
415:
416: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
417: RAISE OKC_API.G_EXCEPTION_ERROR;
418: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: END IF;

Line 417: RAISE OKC_API.G_EXCEPTION_ERROR;

413: p_fprv_rec => l_fprv_rec,
414: x_fprv_rec => x_fprv_rec);
415:
416: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
417: RAISE OKC_API.G_EXCEPTION_ERROR;
418: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: END IF;
421:

Line 418: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

414: x_fprv_rec => x_fprv_rec);
415:
416: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
417: RAISE OKC_API.G_EXCEPTION_ERROR;
418: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: END IF;
421:
422: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

415:
416: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
417: RAISE OKC_API.G_EXCEPTION_ERROR;
418: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: END IF;
421:
422: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
423: x_msg_data => x_msg_data);

Line 422: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

418: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: END IF;
421:
422: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
423: x_msg_data => x_msg_data);
424: EXCEPTION
425: WHEN OKC_API.G_EXCEPTION_ERROR THEN
426: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 425: WHEN OKC_API.G_EXCEPTION_ERROR THEN

421:
422: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
423: x_msg_data => x_msg_data);
424: EXCEPTION
425: WHEN OKC_API.G_EXCEPTION_ERROR THEN
426: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
427: p_pkg_name => G_PKG_NAME,
428: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
429: x_msg_count => x_msg_count,

Line 426: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

422: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
423: x_msg_data => x_msg_data);
424: EXCEPTION
425: WHEN OKC_API.G_EXCEPTION_ERROR THEN
426: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
427: p_pkg_name => G_PKG_NAME,
428: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
429: x_msg_count => x_msg_count,
430: x_msg_data => x_msg_data,

Line 428: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

424: EXCEPTION
425: WHEN OKC_API.G_EXCEPTION_ERROR THEN
426: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
427: p_pkg_name => G_PKG_NAME,
428: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
429: x_msg_count => x_msg_count,
430: x_msg_data => x_msg_data,
431: p_api_type => '_PVT');
432: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 432: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

428: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
429: x_msg_count => x_msg_count,
430: x_msg_data => x_msg_data,
431: p_api_type => '_PVT');
432: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
433: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
434: p_pkg_name => G_PKG_NAME,
435: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
436: x_msg_count => x_msg_count,

Line 433: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

429: x_msg_count => x_msg_count,
430: x_msg_data => x_msg_data,
431: p_api_type => '_PVT');
432: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
433: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
434: p_pkg_name => G_PKG_NAME,
435: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
436: x_msg_count => x_msg_count,
437: x_msg_data => x_msg_data,

Line 435: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

431: p_api_type => '_PVT');
432: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
433: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
434: p_pkg_name => G_PKG_NAME,
435: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
436: x_msg_count => x_msg_count,
437: x_msg_data => x_msg_data,
438: p_api_type => '_PVT');
439: WHEN OTHERS THEN

Line 440: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

436: x_msg_count => x_msg_count,
437: x_msg_data => x_msg_data,
438: p_api_type => '_PVT');
439: WHEN OTHERS THEN
440: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
441: p_pkg_name => G_PKG_NAME,
442: p_exc_name => 'OTHERS',
443: x_msg_count => x_msg_count,
444: x_msg_data => x_msg_data,

Line 463: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

459: x_fprv_rec OUT NOCOPY fprv_rec_type
460: ) IS
461: l_api_version CONSTANT NUMBER := 1;
462: l_api_name CONSTANT VARCHAR2(30) := 'update_dsfparameters';
463: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
464: l_valid BOOLEAN;
465: l_dsfv_rec dsfv_rec_type;
466: l_fprv_rec fprv_rec_type;
467: BEGIN

Line 468: x_return_status := OKC_API.G_RET_STS_SUCCESS;

464: l_valid BOOLEAN;
465: l_dsfv_rec dsfv_rec_type;
466: l_fprv_rec fprv_rec_type;
467: BEGIN
468: x_return_status := OKC_API.G_RET_STS_SUCCESS;
469: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
470: p_pkg_name => G_PKG_NAME,
471: p_init_msg_list => p_init_msg_list,
472: l_api_version => l_api_version,

Line 469: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

465: l_dsfv_rec dsfv_rec_type;
466: l_fprv_rec fprv_rec_type;
467: BEGIN
468: x_return_status := OKC_API.G_RET_STS_SUCCESS;
469: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
470: p_pkg_name => G_PKG_NAME,
471: p_init_msg_list => p_init_msg_list,
472: l_api_version => l_api_version,
473: p_api_version => p_api_version,

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

472: l_api_version => l_api_version,
473: p_api_version => p_api_version,
474: p_api_type => '_PVT',
475: x_return_status => l_return_status);
476: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
477: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
478: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
479: RAISE OKC_API.G_EXCEPTION_ERROR;
480: END IF;

Line 477: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

473: p_api_version => p_api_version,
474: p_api_type => '_PVT',
475: x_return_status => l_return_status);
476: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
477: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
478: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
479: RAISE OKC_API.G_EXCEPTION_ERROR;
480: END IF;
481:

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

474: p_api_type => '_PVT',
475: x_return_status => l_return_status);
476: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
477: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
478: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
479: RAISE OKC_API.G_EXCEPTION_ERROR;
480: END IF;
481:
482: l_dsfv_rec := p_dsfv_rec;

Line 479: RAISE OKC_API.G_EXCEPTION_ERROR;

475: x_return_status => l_return_status);
476: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
477: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
478: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
479: RAISE OKC_API.G_EXCEPTION_ERROR;
480: END IF;
481:
482: l_dsfv_rec := p_dsfv_rec;
483: l_fprv_rec := p_fprv_rec;

Line 490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

486: check_constraints(p_fprv_rec => l_fprv_rec,
487: x_return_status => l_return_status,
488: x_valid => l_valid);
489: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
492: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
493: l_valid <> TRUE) THEN
494: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 495: RAISE OKC_API.G_EXCEPTION_ERROR;

491: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
492: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
493: l_valid <> TRUE) THEN
494: x_return_status := OKL_API.G_RET_STS_ERROR;
495: RAISE OKC_API.G_EXCEPTION_ERROR;
496: END IF;
497:
498: /* public api to insert function parameters */
499: okl_fnctn_prmtrs_pub.update_fnctn_prmtrs(p_api_version => p_api_version,

Line 507: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

503: x_msg_data => x_msg_data,
504: p_fprv_rec => l_fprv_rec,
505: x_fprv_rec => x_fprv_rec);
506:
507: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
508: RAISE OKC_API.G_EXCEPTION_ERROR;
509: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: END IF;

Line 508: RAISE OKC_API.G_EXCEPTION_ERROR;

504: p_fprv_rec => l_fprv_rec,
505: x_fprv_rec => x_fprv_rec);
506:
507: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
508: RAISE OKC_API.G_EXCEPTION_ERROR;
509: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: END IF;
512:

Line 509: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

505: x_fprv_rec => x_fprv_rec);
506:
507: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
508: RAISE OKC_API.G_EXCEPTION_ERROR;
509: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: END IF;
512:
513: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

506:
507: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
508: RAISE OKC_API.G_EXCEPTION_ERROR;
509: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: END IF;
512:
513: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
514: x_msg_data => x_msg_data);

Line 513: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

509: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: END IF;
512:
513: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
514: x_msg_data => x_msg_data);
515: EXCEPTION
516: WHEN OKC_API.G_EXCEPTION_ERROR THEN
517: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 516: WHEN OKC_API.G_EXCEPTION_ERROR THEN

512:
513: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
514: x_msg_data => x_msg_data);
515: EXCEPTION
516: WHEN OKC_API.G_EXCEPTION_ERROR THEN
517: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
518: p_pkg_name => G_PKG_NAME,
519: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
520: x_msg_count => x_msg_count,

Line 517: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

513: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
514: x_msg_data => x_msg_data);
515: EXCEPTION
516: WHEN OKC_API.G_EXCEPTION_ERROR THEN
517: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
518: p_pkg_name => G_PKG_NAME,
519: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
520: x_msg_count => x_msg_count,
521: x_msg_data => x_msg_data,

Line 519: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

515: EXCEPTION
516: WHEN OKC_API.G_EXCEPTION_ERROR THEN
517: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
518: p_pkg_name => G_PKG_NAME,
519: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
520: x_msg_count => x_msg_count,
521: x_msg_data => x_msg_data,
522: p_api_type => '_PVT');
523: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 523: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

519: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
520: x_msg_count => x_msg_count,
521: x_msg_data => x_msg_data,
522: p_api_type => '_PVT');
523: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
524: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
525: p_pkg_name => G_PKG_NAME,
526: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
527: x_msg_count => x_msg_count,

Line 524: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

520: x_msg_count => x_msg_count,
521: x_msg_data => x_msg_data,
522: p_api_type => '_PVT');
523: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
524: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
525: p_pkg_name => G_PKG_NAME,
526: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
527: x_msg_count => x_msg_count,
528: x_msg_data => x_msg_data,

Line 526: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

522: p_api_type => '_PVT');
523: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
524: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
525: p_pkg_name => G_PKG_NAME,
526: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
527: x_msg_count => x_msg_count,
528: x_msg_data => x_msg_data,
529: p_api_type => '_PVT');
530: WHEN OTHERS THEN

Line 531: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

527: x_msg_count => x_msg_count,
528: x_msg_data => x_msg_data,
529: p_api_type => '_PVT');
530: WHEN OTHERS THEN
531: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
532: p_pkg_name => G_PKG_NAME,
533: p_exc_name => 'OTHERS',
534: x_msg_count => x_msg_count,
535: x_msg_data => x_msg_data,

Line 555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

551: ) IS
552: l_api_version CONSTANT NUMBER := 1;
553: l_fprv_tbl fprv_tbl_type;
554: l_api_name CONSTANT VARCHAR2(30) := 'delete_dsfparameters';
555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
556:
557: BEGIN
558: x_return_status := OKC_API.G_RET_STS_SUCCESS;
559: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

Line 558: x_return_status := OKC_API.G_RET_STS_SUCCESS;

554: l_api_name CONSTANT VARCHAR2(30) := 'delete_dsfparameters';
555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
556:
557: BEGIN
558: x_return_status := OKC_API.G_RET_STS_SUCCESS;
559: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
560: p_pkg_name => G_PKG_NAME,
561: p_init_msg_list => p_init_msg_list,
562: l_api_version => l_api_version,

Line 559: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
556:
557: BEGIN
558: x_return_status := OKC_API.G_RET_STS_SUCCESS;
559: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
560: p_pkg_name => G_PKG_NAME,
561: p_init_msg_list => p_init_msg_list,
562: l_api_version => l_api_version,
563: p_api_version => p_api_version,

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

562: l_api_version => l_api_version,
563: p_api_version => p_api_version,
564: p_api_type => '_PVT',
565: x_return_status => l_return_status);
566: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
569: RAISE OKC_API.G_EXCEPTION_ERROR;
570: END IF;

Line 567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

563: p_api_version => p_api_version,
564: p_api_type => '_PVT',
565: x_return_status => l_return_status);
566: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
569: RAISE OKC_API.G_EXCEPTION_ERROR;
570: END IF;
571:

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

564: p_api_type => '_PVT',
565: x_return_status => l_return_status);
566: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
569: RAISE OKC_API.G_EXCEPTION_ERROR;
570: END IF;
571:
572: l_fprv_tbl := p_fprv_tbl;

Line 569: RAISE OKC_API.G_EXCEPTION_ERROR;

565: x_return_status => l_return_status);
566: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
569: RAISE OKC_API.G_EXCEPTION_ERROR;
570: END IF;
571:
572: l_fprv_tbl := p_fprv_tbl;
573:

Line 582: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

578: x_msg_count => x_msg_count,
579: x_msg_data => x_msg_data,
580: p_fprv_tbl => l_fprv_tbl);
581:
582: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
583: RAISE OKC_API.G_EXCEPTION_ERROR;
584: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
586: END IF;

Line 583: RAISE OKC_API.G_EXCEPTION_ERROR;

579: x_msg_data => x_msg_data,
580: p_fprv_tbl => l_fprv_tbl);
581:
582: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
583: RAISE OKC_API.G_EXCEPTION_ERROR;
584: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
586: END IF;
587:

Line 584: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

580: p_fprv_tbl => l_fprv_tbl);
581:
582: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
583: RAISE OKC_API.G_EXCEPTION_ERROR;
584: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
586: END IF;
587:
588: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

581:
582: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
583: RAISE OKC_API.G_EXCEPTION_ERROR;
584: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
586: END IF;
587:
588: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
589: x_msg_data => x_msg_data);

Line 588: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

584: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
586: END IF;
587:
588: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
589: x_msg_data => x_msg_data);
590: EXCEPTION
591: WHEN OKC_API.G_EXCEPTION_ERROR THEN
592: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 591: WHEN OKC_API.G_EXCEPTION_ERROR THEN

587:
588: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
589: x_msg_data => x_msg_data);
590: EXCEPTION
591: WHEN OKC_API.G_EXCEPTION_ERROR THEN
592: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
593: p_pkg_name => G_PKG_NAME,
594: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
595: x_msg_count => x_msg_count,

Line 592: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

588: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
589: x_msg_data => x_msg_data);
590: EXCEPTION
591: WHEN OKC_API.G_EXCEPTION_ERROR THEN
592: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
593: p_pkg_name => G_PKG_NAME,
594: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
595: x_msg_count => x_msg_count,
596: x_msg_data => x_msg_data,

Line 594: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

590: EXCEPTION
591: WHEN OKC_API.G_EXCEPTION_ERROR THEN
592: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
593: p_pkg_name => G_PKG_NAME,
594: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
595: x_msg_count => x_msg_count,
596: x_msg_data => x_msg_data,
597: p_api_type => '_PVT');
598: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 598: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

594: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
595: x_msg_count => x_msg_count,
596: x_msg_data => x_msg_data,
597: p_api_type => '_PVT');
598: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
599: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
600: p_pkg_name => G_PKG_NAME,
601: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
602: x_msg_count => x_msg_count,

Line 599: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

595: x_msg_count => x_msg_count,
596: x_msg_data => x_msg_data,
597: p_api_type => '_PVT');
598: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
599: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
600: p_pkg_name => G_PKG_NAME,
601: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
602: x_msg_count => x_msg_count,
603: x_msg_data => x_msg_data,

Line 601: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

597: p_api_type => '_PVT');
598: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
599: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
600: p_pkg_name => G_PKG_NAME,
601: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
602: x_msg_count => x_msg_count,
603: x_msg_data => x_msg_data,
604: p_api_type => '_PVT');
605: WHEN OTHERS THEN

Line 606: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

602: x_msg_count => x_msg_count,
603: x_msg_data => x_msg_data,
604: p_api_type => '_PVT');
605: WHEN OTHERS THEN
606: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
607: p_pkg_name => G_PKG_NAME,
608: p_exc_name => 'OTHERS',
609: x_msg_count => x_msg_count,
610: x_msg_data => x_msg_data,