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.

[Home] [Help]

APPS.OKL_MULTIGAAP_ENGINE_PVT dependencies on OKL_API

Line 68: p_init_msg_list => OKL_API.G_FALSE,

64: lp_pdtv_rec.id := l_fin_product_id;
65:
66: -- check if the fin product has a reporting product
67: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters( p_api_version => p_api_version,
68: p_init_msg_list => OKL_API.G_FALSE,
69: x_return_status => x_return_status,
70: x_no_data_found => lx_no_data_found,
71: x_msg_count => x_msg_count,
72: x_msg_data => x_msg_data,

Line 77: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

73: p_pdtv_rec => lp_pdtv_rec,
74: p_product_date => l_start_date,
75: p_pdt_parameter_rec => lx_pdt_parameter_rec);
76:
77: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
78: -- Error getting financial product parameters for contract CONTRACT_NUMBER.
79: OKL_API.set_message( p_app_name => 'OKL',
80: p_msg_name => 'OKL_AM_FIN_PROD_PARAM_ERR',
81: p_token1 => 'CONTRACT_NUMBER',

Line 79: OKL_API.set_message( p_app_name => 'OKL',

75: p_pdt_parameter_rec => lx_pdt_parameter_rec);
76:
77: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
78: -- Error getting financial product parameters for contract CONTRACT_NUMBER.
79: OKL_API.set_message( p_app_name => 'OKL',
80: p_msg_name => 'OKL_AM_FIN_PROD_PARAM_ERR',
81: p_token1 => 'CONTRACT_NUMBER',
82: p_token1_value => l_contract_number);
83:

Line 89: IF l_reporting_product IS NOT NULL AND l_reporting_product <> OKL_API.G_MISS_CHAR THEN

85:
86: l_reporting_product := lx_pdt_parameter_rec.reporting_product;
87: l_reporting_product_id := lx_pdt_parameter_rec.reporting_pdt_id;
88:
89: IF l_reporting_product IS NOT NULL AND l_reporting_product <> OKL_API.G_MISS_CHAR THEN
90: -- Contract has a reporting product
91: x_rep_product_id := l_reporting_product_id;
92: END IF;
93: END IF;

Line 99: -- x_return_status := OKL_API.G_RET_STS_ERROR;

95: --WHEN mg_error THEN
96: -- IF l_get_fin_product%ISOPEN THEN
97: -- CLOSE l_get_fin_product;
98: -- END IF;
99: -- x_return_status := OKL_API.G_RET_STS_ERROR;
100: WHEN OTHERS THEN
101: IF l_get_fin_product%ISOPEN THEN
102: CLOSE l_get_fin_product;
103: END IF;

Line 104: OKL_API.set_message(p_app_name => 'OKC',

100: WHEN OTHERS THEN
101: IF l_get_fin_product%ISOPEN THEN
102: CLOSE l_get_fin_product;
103: END IF;
104: OKL_API.set_message(p_app_name => 'OKC',
105: p_msg_name => g_unexpected_error,
106: p_token1 => g_sqlcode_token,
107: p_token1_value => sqlcode,
108: p_token2 => g_sqlerrm_token,

Line 110: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

106: p_token1 => g_sqlcode_token,
107: p_token1_value => sqlcode,
108: p_token2 => g_sqlerrm_token,
109: p_token2_value => sqlerrm);
110: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
111: END get_reporting_product;
112:
113: ---------------------------------------------------------------------------
114: -- FUNCTION is_srm_automated

Line 281: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

277:
278:
279: PROCEDURE set_secondary_trx_attribs(
280: p_api_version IN NUMBER,
281: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: p_tcnv_rec IN tcnv_rec_type,

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

287: IS
288:
289: l_api_version NUMBER := 1.0;
290: l_api_name CONSTANT VARCHAR2(30) := 'set_secondary_trx_attribs';
291: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
292: x_no_data_found BOOLEAN := TRUE;
293:
294: CURSOR get_secondary_rep_code_csr IS
295: select representation_code,representation_name

Line 325: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'

321: p_contract_id => l_tcnv_rec.khr_id,
322: x_rep_product_id => l_rep_product_id);
323:
324: IF (l_rep_product_id IS NULL) THEN
325: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'
326: ,p_msg_name => g_required_value
327: ,p_token1 => g_col_name_token
328: ,p_token1_value => 'PDT_ID');
329: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 329: x_return_status := OKL_API.G_RET_STS_ERROR;

325: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'
326: ,p_msg_name => g_required_value
327: ,p_token1 => g_col_name_token
328: ,p_token1_value => 'PDT_ID');
329: x_return_status := OKL_API.G_RET_STS_ERROR;
330: RAISE OKL_API.G_EXCEPTION_ERROR;
331: END IF;
332:
333: lp_pdtv_rec.id := l_rep_product_id;

Line 330: RAISE OKL_API.G_EXCEPTION_ERROR;

326: ,p_msg_name => g_required_value
327: ,p_token1 => g_col_name_token
328: ,p_token1_value => 'PDT_ID');
329: x_return_status := OKL_API.G_RET_STS_ERROR;
330: RAISE OKL_API.G_EXCEPTION_ERROR;
331: END IF;
332:
333: lp_pdtv_rec.id := l_rep_product_id;
334: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(

Line 345: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

341: p_pdtv_rec => lp_pdtv_rec,
342: p_product_date => NULL,
343: p_pdt_parameter_rec => lx_pdt_param_rec);
344:
345: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
348: RAISE OKL_API.G_EXCEPTION_ERROR;
349: END IF;

Line 346: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

342: p_product_date => NULL,
343: p_pdt_parameter_rec => lx_pdt_param_rec);
344:
345: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
348: RAISE OKL_API.G_EXCEPTION_ERROR;
349: END IF;
350:

Line 347: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

343: p_pdt_parameter_rec => lx_pdt_param_rec);
344:
345: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
348: RAISE OKL_API.G_EXCEPTION_ERROR;
349: END IF;
350:
351:

Line 348: RAISE OKL_API.G_EXCEPTION_ERROR;

344:
345: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
348: RAISE OKL_API.G_EXCEPTION_ERROR;
349: END IF;
350:
351:
352: l_set_of_books_id := Okl_Accounting_util.get_set_of_books_id(G_SECONDARY);

Line 354: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'

350:
351:
352: l_set_of_books_id := Okl_Accounting_util.get_set_of_books_id(G_SECONDARY);
353: IF (l_set_of_books_id IS NULL) THEN
354: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'
355: ,p_msg_name => g_required_value
356: ,p_token1 => g_col_name_token
357: ,p_token1_value => 'SET_OF_BOOKS_ID');
358: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 358: x_return_status := OKL_API.G_RET_STS_ERROR;

354: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'
355: ,p_msg_name => g_required_value
356: ,p_token1 => g_col_name_token
357: ,p_token1_value => 'SET_OF_BOOKS_ID');
358: x_return_status := OKL_API.G_RET_STS_ERROR;
359: RAISE OKL_API.G_EXCEPTION_ERROR;
360: END IF;
361:
362: l_formula_yn := is_formula_based (l_tcnv_rec.id);

Line 359: RAISE OKL_API.G_EXCEPTION_ERROR;

355: ,p_msg_name => g_required_value
356: ,p_token1 => g_col_name_token
357: ,p_token1_value => 'SET_OF_BOOKS_ID');
358: x_return_status := OKL_API.G_RET_STS_ERROR;
359: RAISE OKL_API.G_EXCEPTION_ERROR;
360: END IF;
361:
362: l_formula_yn := is_formula_based (l_tcnv_rec.id);
363: IF(l_formula_yn) THEN

Line 377: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'

373: l_representation_name := null;
374: l_representation_code := get_secondary_rep_code.representation_code;
375: l_representation_name := get_secondary_rep_code.representation_name;
376: IF (l_representation_code IS NULL) THEN
377: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'
378: ,p_msg_name => g_required_value
379: ,p_token1 => g_col_name_token
380: ,p_token1_value => 'REPRESENTATION_CODE');
381: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 381: x_return_status := OKL_API.G_RET_STS_ERROR;

377: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'
378: ,p_msg_name => g_required_value
379: ,p_token1 => g_col_name_token
380: ,p_token1_value => 'REPRESENTATION_CODE');
381: x_return_status := OKL_API.G_RET_STS_ERROR;
382: RAISE OKL_API.G_EXCEPTION_ERROR;
383: END IF;
384:
385: IF (l_representation_name IS NULL ) THEN

Line 382: RAISE OKL_API.G_EXCEPTION_ERROR;

378: ,p_msg_name => g_required_value
379: ,p_token1 => g_col_name_token
380: ,p_token1_value => 'REPRESENTATION_CODE');
381: x_return_status := OKL_API.G_RET_STS_ERROR;
382: RAISE OKL_API.G_EXCEPTION_ERROR;
383: END IF;
384:
385: IF (l_representation_name IS NULL ) THEN
386: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'

Line 386: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'

382: RAISE OKL_API.G_EXCEPTION_ERROR;
383: END IF;
384:
385: IF (l_representation_name IS NULL ) THEN
386: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'
387: ,p_msg_name => g_required_value
388: ,p_token1 => g_col_name_token
389: ,p_token1_value => 'REPRESENTATION_NAME');
390: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 390: x_return_status := OKL_API.G_RET_STS_ERROR;

386: OKL_Api.SET_MESSAGE(p_app_name => 'OKC'
387: ,p_msg_name => g_required_value
388: ,p_token1 => g_col_name_token
389: ,p_token1_value => 'REPRESENTATION_NAME');
390: x_return_status := OKL_API.G_RET_STS_ERROR;
391: RAISE OKL_API.G_EXCEPTION_ERROR;
392: END IF;
393:
394: l_tcnv_tbl(i) := l_tcnv_rec;

Line 391: RAISE OKL_API.G_EXCEPTION_ERROR;

387: ,p_msg_name => g_required_value
388: ,p_token1 => g_col_name_token
389: ,p_token1_value => 'REPRESENTATION_NAME');
390: x_return_status := OKL_API.G_RET_STS_ERROR;
391: RAISE OKL_API.G_EXCEPTION_ERROR;
392: END IF;
393:
394: l_tcnv_tbl(i) := l_tcnv_rec;
395: --l_tcnv_tbl(i).trx_number := null;

Line 412: WHEN OKL_API.G_EXCEPTION_ERROR THEN

408: x_tcnv_tbl := l_tcnv_tbl;
409: x_return_status := l_return_status;
410:
411: EXCEPTION
412: WHEN OKL_API.G_EXCEPTION_ERROR THEN
413: x_return_status := OKL_API.HANDLE_EXCEPTIONS
414: (
415: l_api_name,
416: G_PKG_NAME,

Line 413: x_return_status := OKL_API.HANDLE_EXCEPTIONS

409: x_return_status := l_return_status;
410:
411: EXCEPTION
412: WHEN OKL_API.G_EXCEPTION_ERROR THEN
413: x_return_status := OKL_API.HANDLE_EXCEPTIONS
414: (
415: l_api_name,
416: G_PKG_NAME,
417: 'OKL_API.G_RET_STS_ERROR',

Line 417: 'OKL_API.G_RET_STS_ERROR',

413: x_return_status := OKL_API.HANDLE_EXCEPTIONS
414: (
415: l_api_name,
416: G_PKG_NAME,
417: 'OKL_API.G_RET_STS_ERROR',
418: x_msg_count,
419: x_msg_data,
420: '_PVT'
421: );

Line 422: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

418: x_msg_count,
419: x_msg_data,
420: '_PVT'
421: );
422: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
423: x_return_status := OKL_API.HANDLE_EXCEPTIONS
424: (
425: l_api_name,
426: G_PKG_NAME,

Line 423: x_return_status := OKL_API.HANDLE_EXCEPTIONS

419: x_msg_data,
420: '_PVT'
421: );
422: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
423: x_return_status := OKL_API.HANDLE_EXCEPTIONS
424: (
425: l_api_name,
426: G_PKG_NAME,
427: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 427: 'OKL_API.G_RET_STS_UNEXP_ERROR',

423: x_return_status := OKL_API.HANDLE_EXCEPTIONS
424: (
425: l_api_name,
426: G_PKG_NAME,
427: 'OKL_API.G_RET_STS_UNEXP_ERROR',
428: x_msg_count,
429: x_msg_data,
430: '_PVT'
431: );

Line 433: x_return_status := OKL_API.HANDLE_EXCEPTIONS

429: x_msg_data,
430: '_PVT'
431: );
432: WHEN OTHERS THEN
433: x_return_status := OKL_API.HANDLE_EXCEPTIONS
434: (
435: l_api_name,
436: G_PKG_NAME,
437: 'OTHERS',

Line 448: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

444: END set_secondary_trx_attribs;
445:
446: PROCEDURE CREATE_SEC_REP_TRX (
447: P_API_VERSION IN NUMBER,
448: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
449: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
450: X_MSG_COUNT OUT NOCOPY NUMBER,
451: X_MSG_DATA OUT NOCOPY VARCHAR2,
452: P_TCNV_REC OKL_TCN_PVT.TCNV_REC_TYPE,

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

457:
458: l_api_version NUMBER := 1.0;
459: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SEC_REP_TRX';
460: l_row_notfound BOOLEAN := TRUE;
461: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
462:
463: l_try_id NUMBER := 0;
464:
465: l_pri_trx_tcnv_rec tcnv_rec_type := p_tcnv_rec;

Line 563: x_return_status := OKL_API.START_ACTIVITY(

559: IF (G_DEBUG_ENABLED = 'Y') THEN
560: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
561: END IF;
562:
563: x_return_status := OKL_API.START_ACTIVITY(
564: p_api_name => l_api_name,
565: p_pkg_name => g_pkg_name,
566: p_init_msg_list => p_init_msg_list,
567: l_api_version => l_api_version,

Line 573: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

569: p_api_type => G_API_TYPE,
570: x_return_status => x_return_status);
571:
572: -- check if activity started successfully
573: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
574: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
576: raise OKL_API.G_EXCEPTION_ERROR;
577: End If;

Line 574: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

570: x_return_status => x_return_status);
571:
572: -- check if activity started successfully
573: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
574: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
576: raise OKL_API.G_EXCEPTION_ERROR;
577: End If;
578:

Line 575: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

571:
572: -- check if activity started successfully
573: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
574: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
576: raise OKL_API.G_EXCEPTION_ERROR;
577: End If;
578:
579:

Line 576: raise OKL_API.G_EXCEPTION_ERROR;

572: -- check if activity started successfully
573: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
574: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
576: raise OKL_API.G_EXCEPTION_ERROR;
577: End If;
578:
579:
580: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 629: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

625: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to set_secondary_trx_attribs, the return status is :'||x_return_status);
627: END IF;
628:
629: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
632: RAISE OKL_API.G_EXCEPTION_ERROR;
633: END IF;

Line 630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to set_secondary_trx_attribs, the return status is :'||x_return_status);
627: END IF;
628:
629: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
632: RAISE OKL_API.G_EXCEPTION_ERROR;
633: END IF;
634:

Line 631: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

627: END IF;
628:
629: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
632: RAISE OKL_API.G_EXCEPTION_ERROR;
633: END IF;
634:
635:

Line 632: RAISE OKL_API.G_EXCEPTION_ERROR;

628:
629: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
632: RAISE OKL_API.G_EXCEPTION_ERROR;
633: END IF;
634:
635:
636: -- create the secondary transaction header

Line 654: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

650: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
651: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.create_trx_contracts, the return status is :'||x_return_status);
652: END IF;
653:
654: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;

Line 655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

651: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.create_trx_contracts, the return status is :'||x_return_status);
652: END IF;
653:
654: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;
659:

Line 656: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

652: END IF;
653:
654: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;
659:
660: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 657: RAISE OKL_API.G_EXCEPTION_ERROR;

653:
654: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;
659:
660: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
661: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to okl_accounting_util.get_valid_gl_date');

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

666: (p_gl_date => l_sec_trx_tcnv_tbl(1).date_transaction_occurred,
667: p_ledger_id => l_sec_trx_tcnv_tbl(1).set_of_books_id);
668:
669: IF (l_valid_gl_date is null) THEN
670: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
671: p_msg_name => 'OKL_INVALID_GL_DATE');
672: RAISE OKL_API.G_EXCEPTION_ERROR;
673: END IF;
674:

Line 672: RAISE OKL_API.G_EXCEPTION_ERROR;

668:
669: IF (l_valid_gl_date is null) THEN
670: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
671: p_msg_name => 'OKL_INVALID_GL_DATE');
672: RAISE OKL_API.G_EXCEPTION_ERROR;
673: END IF;
674:
675: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
676: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.create_trx_contracts'||to_char(l_valid_gl_date));

Line 725: Okl_Api.set_message(p_app_name => g_app_name,

721: IF (l_template_tbl.COUNT = 0) THEN
722: FOR trx_type_rec IN trx_type_csr (l_tmpl_identify_rec.transaction_type_id) LOOP
723: l_trx_type_name := trx_type_rec.name;
724: END LOOP;
725: Okl_Api.set_message(p_app_name => g_app_name,
726: p_msg_name => 'OKL_LA_NO_ACCOUNTING_TMPLTS',
727: p_token1 => 'TRANSACTION_TYPE',
728: p_token1_value => l_trx_type_name);
729: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 729: RAISE OKL_API.G_EXCEPTION_ERROR;

725: Okl_Api.set_message(p_app_name => g_app_name,
726: p_msg_name => 'OKL_LA_NO_ACCOUNTING_TMPLTS',
727: p_token1 => 'TRANSACTION_TYPE',
728: p_token1_value => l_trx_type_name);
729: RAISE OKL_API.G_EXCEPTION_ERROR;
730: END IF;
731:
732: -- chekc if the transaction line or contract based
733: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

823: x_msg_data => x_msg_data,
824: p_tclv_tbl => l_sec_trx_tclv_tbl,
825: x_tclv_tbl => x_sec_trx_tclv_tbl);
826:
827: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
829: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_ERROR;
831: END IF;

Line 828: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

824: p_tclv_tbl => l_sec_trx_tclv_tbl,
825: x_tclv_tbl => x_sec_trx_tclv_tbl);
826:
827: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
829: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_ERROR;
831: END IF;
832:

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

825: x_tclv_tbl => x_sec_trx_tclv_tbl);
826:
827: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
829: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_ERROR;
831: END IF;
832:
833: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 830: RAISE OKL_API.G_EXCEPTION_ERROR;

826:
827: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
829: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_ERROR;
831: END IF;
832:
833: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
834: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines :'||l_return_status);

Line 844: OKL_API.set_message( p_app_name => 'OKL',

840: FETCH l_contract_currency_csr INTO l_curr_code, l_currency_conversion_rate,l_currency_conversion_type, l_currency_conversion_date ;
841: CLOSE l_contract_currency_csr;
842:
843: IF( l_curr_code IS NULL ) THEN
844: OKL_API.set_message( p_app_name => 'OKL',
845: p_msg_name => G_REQUIRED_VALUE,
846: p_token1 => g_col_name_token,
847: p_token1_value => 'CURRENCY_CODE');
848: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 848: RAISE OKL_API.G_EXCEPTION_ERROR;

844: OKL_API.set_message( p_app_name => 'OKL',
845: p_msg_name => G_REQUIRED_VALUE,
846: p_token1 => g_col_name_token,
847: p_token1_value => 'CURRENCY_CODE');
848: RAISE OKL_API.G_EXCEPTION_ERROR;
849: END IF;
850:
851: FOR i IN x_sec_trx_tclv_tbl.FIRST..x_sec_trx_tclv_tbl.LAST LOOP
852:

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

894: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
895: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);
896: END IF;
897:
898: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
900: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
901: RAISE OKL_API.G_EXCEPTION_ERROR;
902: END IF;

Line 899: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

895: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);
896: END IF;
897:
898: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
900: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
901: RAISE OKL_API.G_EXCEPTION_ERROR;
902: END IF;
903:

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

896: END IF;
897:
898: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
900: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
901: RAISE OKL_API.G_EXCEPTION_ERROR;
902: END IF;
903:
904: If x_sec_trx_tclv_tbl.COUNT > 0 then

Line 901: RAISE OKL_API.G_EXCEPTION_ERROR;

897:
898: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
900: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
901: RAISE OKL_API.G_EXCEPTION_ERROR;
902: END IF;
903:
904: If x_sec_trx_tclv_tbl.COUNT > 0 then
905: FOR i in x_sec_trx_tclv_tbl.FIRST..x_sec_trx_tclv_tbl.LAST LOOP

Line 943: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

939: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
940: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines :'||x_return_status);
941: END IF;
942:
943: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
945: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;

Line 944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

940: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines :'||x_return_status);
941: END IF;
942:
943: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
945: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;
948:

Line 945: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

941: END IF;
942:
943: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
945: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;
948:
949: --Update the header with the amount

Line 946: RAISE OKL_API.G_EXCEPTION_ERROR;

942:
943: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
945: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;
948:
949: --Update the header with the amount
950: x_sec_trx_tcnv_tbl(1).tsu_code := 'PROCESSED';

Line 970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

966: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
967: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts :'||x_return_status);
968: END IF;
969:
970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
972: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_ERROR;
974: END IF;

Line 971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

967: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts :'||x_return_status);
968: END IF;
969:
970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
972: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_ERROR;
974: END IF;
975:

Line 972: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

968: END IF;
969:
970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
972: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_ERROR;
974: END IF;
975:
976: ELSE

Line 973: RAISE OKL_API.G_EXCEPTION_ERROR;

969:
970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
972: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_ERROR;
974: END IF;
975:
976: ELSE
977:

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

995: FETCH cntrct_csr INTO l_contract_start_date;
996: CLOSE cntrct_csr;
997:
998: IF l_contract_start_date IS NULL THEN
999: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1000: p_msg_name => g_required_value,
1001: p_token1 => g_col_name_token,
1002: p_token1_value => 'CONTRACT_START_DATE');
1003:

Line 1004: RAISE OKL_API.G_EXCEPTION_ERROR;

1000: p_msg_name => g_required_value,
1001: p_token1 => g_col_name_token,
1002: p_token1_value => 'CONTRACT_START_DATE');
1003:
1004: RAISE OKL_API.G_EXCEPTION_ERROR;
1005: END IF;
1006:
1007: open get_sty_id_csr(l_sec_trx_tcnv_tbl(1).pdt_id, l_sec_trx_tclv_tbl(i).stream_type_purpose, l_contract_start_date);
1008: fetch get_sty_id_csr into l_sty_id;

Line 1012: Okl_Api.set_message(p_app_name => g_app_name,

1008: fetch get_sty_id_csr into l_sty_id;
1009: close get_sty_id_csr;
1010:
1011: IF( l_sty_id IS NULL ) THEN
1012: Okl_Api.set_message(p_app_name => g_app_name,
1013: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
1014: p_token1 => g_stream_name_token,
1015: p_token1_value => 'SPECIFIC LOSS PROVISION');
1016: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1016: RAISE OKL_API.G_EXCEPTION_ERROR;

1012: Okl_Api.set_message(p_app_name => g_app_name,
1013: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
1014: p_token1 => g_stream_name_token,
1015: p_token1_value => 'SPECIFIC LOSS PROVISION');
1016: RAISE OKL_API.G_EXCEPTION_ERROR;
1017: END IF;
1018: l_sec_trx_tclv_tbl(i).sty_id := l_sty_id;
1019:
1020: END LOOP;

Line 1040: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1036: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1037: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines :'||x_return_status);
1038: END IF;
1039:
1040: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1041: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1042: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1043: RAISE OKL_API.G_EXCEPTION_ERROR;
1044: END IF;

Line 1041: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1037: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines :'||x_return_status);
1038: END IF;
1039:
1040: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1041: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1042: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1043: RAISE OKL_API.G_EXCEPTION_ERROR;
1044: END IF;
1045:

Line 1042: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1038: END IF;
1039:
1040: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1041: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1042: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1043: RAISE OKL_API.G_EXCEPTION_ERROR;
1044: END IF;
1045:
1046: -- make the call to accounting distributions

Line 1043: RAISE OKL_API.G_EXCEPTION_ERROR;

1039:
1040: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1041: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1042: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1043: RAISE OKL_API.G_EXCEPTION_ERROR;
1044: END IF;
1045:
1046: -- make the call to accounting distributions
1047: OPEN l_contract_currency_csr;

Line 1052: OKL_API.set_message( p_app_name => 'OKL',

1048: FETCH l_contract_currency_csr INTO l_curr_code, l_currency_conversion_rate,l_currency_conversion_type, l_currency_conversion_date ;
1049: CLOSE l_contract_currency_csr;
1050:
1051: IF( l_curr_code IS NULL ) THEN
1052: OKL_API.set_message( p_app_name => 'OKL',
1053: p_msg_name => G_REQUIRED_VALUE,
1054: p_token1 => g_col_name_token,
1055: p_token1_value => 'CURRENCY_CODE');
1056: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1056: RAISE OKL_API.G_EXCEPTION_ERROR;

1052: OKL_API.set_message( p_app_name => 'OKL',
1053: p_msg_name => G_REQUIRED_VALUE,
1054: p_token1 => g_col_name_token,
1055: p_token1_value => 'CURRENCY_CODE');
1056: RAISE OKL_API.G_EXCEPTION_ERROR;
1057: END IF;
1058:
1059:
1060: FOR i IN x_sec_trx_tclv_tbl.FIRST..x_sec_trx_tclv_tbl.LAST LOOP

Line 1116: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1112: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1113: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);
1114: END IF;
1115:
1116: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1117: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1118: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1119: RAISE OKL_API.G_EXCEPTION_ERROR;
1120: END IF;

Line 1117: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1113: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);
1114: END IF;
1115:
1116: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1117: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1118: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1119: RAISE OKL_API.G_EXCEPTION_ERROR;
1120: END IF;
1121:

Line 1118: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1114: END IF;
1115:
1116: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1117: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1118: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1119: RAISE OKL_API.G_EXCEPTION_ERROR;
1120: END IF;
1121:
1122: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1119: RAISE OKL_API.G_EXCEPTION_ERROR;

1115:
1116: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1117: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1118: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1119: RAISE OKL_API.G_EXCEPTION_ERROR;
1120: END IF;
1121:
1122: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1123: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

Line 1141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1137: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1138: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts :'||x_return_status);
1139: END IF;
1140:
1141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;

Line 1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1138: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts :'||x_return_status);
1139: END IF;
1140:
1141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:

Line 1143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1139: END IF;
1140:
1141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:
1147: END IF;

Line 1144: RAISE OKL_API.G_EXCEPTION_ERROR;

1140:
1141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:
1147: END IF;
1148: x_return_status := okl_api.g_ret_sts_success;

Line 1148: x_return_status := okl_api.g_ret_sts_success;

1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:
1147: END IF;
1148: x_return_status := okl_api.g_ret_sts_success;
1149: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1150:
1151: EXCEPTION
1152: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1149: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1145: END IF;
1146:
1147: END IF;
1148: x_return_status := okl_api.g_ret_sts_success;
1149: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1150:
1151: EXCEPTION
1152: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1153: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 1152: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1148: x_return_status := okl_api.g_ret_sts_success;
1149: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1150:
1151: EXCEPTION
1152: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1153: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1154: (
1155: l_api_name,
1156: G_PKG_NAME,

Line 1153: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1149: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1150:
1151: EXCEPTION
1152: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1153: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1154: (
1155: l_api_name,
1156: G_PKG_NAME,
1157: 'OKL_API.G_RET_STS_ERROR',

Line 1157: 'OKL_API.G_RET_STS_ERROR',

1153: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1154: (
1155: l_api_name,
1156: G_PKG_NAME,
1157: 'OKL_API.G_RET_STS_ERROR',
1158: x_msg_count,
1159: x_msg_data,
1160: '_PVT'
1161: );

Line 1162: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1158: x_msg_count,
1159: x_msg_data,
1160: '_PVT'
1161: );
1162: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1163: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1164: (
1165: l_api_name,
1166: G_PKG_NAME,

Line 1163: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1159: x_msg_data,
1160: '_PVT'
1161: );
1162: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1163: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1164: (
1165: l_api_name,
1166: G_PKG_NAME,
1167: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1167: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1163: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1164: (
1165: l_api_name,
1166: G_PKG_NAME,
1167: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1168: x_msg_count,
1169: x_msg_data,
1170: '_PVT'
1171: );

Line 1173: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1169: x_msg_data,
1170: '_PVT'
1171: );
1172: WHEN OTHERS THEN
1173: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1174: (
1175: l_api_name,
1176: G_PKG_NAME,
1177: 'OTHERS',

Line 1186: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1182: END CREATE_SEC_REP_TRX;
1183:
1184: PROCEDURE REVERSE_SEC_REP_TRX (
1185: P_API_VERSION IN NUMBER,
1186: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1187: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1188: X_MSG_COUNT OUT NOCOPY NUMBER,
1189: X_MSG_DATA OUT NOCOPY VARCHAR2,
1190: P_TCNV_REC OKL_TCN_PVT.TCNV_REC_TYPE

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

1189: X_MSG_DATA OUT NOCOPY VARCHAR2,
1190: P_TCNV_REC OKL_TCN_PVT.TCNV_REC_TYPE
1191: ) IS
1192:
1193: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1194:
1195: /* variables */
1196: l_api_name CONSTANT VARCHAR2(40) := 'REVERSE_SEC_REP_TRX';
1197: l_api_version CONSTANT NUMBER := 1.0;

Line 1239: l_return_status := OKL_API.START_ACTIVITY(l_api_name

1235: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1236: END IF;
1237:
1238:
1239: l_return_status := OKL_API.START_ACTIVITY(l_api_name
1240: ,G_PKG_NAME
1241: ,p_init_msg_list
1242: ,l_api_version
1243: ,p_api_version

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

1243: ,p_api_version
1244: ,'_PVT'
1245: ,l_return_status);
1246:
1247: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1250: RAISE OKL_API.G_EXCEPTION_ERROR;
1251: END IF;

Line 1248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1244: ,'_PVT'
1245: ,l_return_status);
1246:
1247: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1250: RAISE OKL_API.G_EXCEPTION_ERROR;
1251: END IF;
1252:

Line 1249: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1245: ,l_return_status);
1246:
1247: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1250: RAISE OKL_API.G_EXCEPTION_ERROR;
1251: END IF;
1252:
1253: -- Open reverse trx csr for update of transaction header

Line 1250: RAISE OKL_API.G_EXCEPTION_ERROR;

1246:
1247: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1250: RAISE OKL_API.G_EXCEPTION_ERROR;
1251: END IF;
1252:
1253: -- Open reverse trx csr for update of transaction header
1254: FOR l_reverse_trx_csr IN reverse_trx_csr(l_pri_tcnv_rec.ID)

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

1302: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||l_return_status);
1303: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Reversal_Pub.REVERSE_ENTRIES, l_source_table :'||l_source_table);
1304: END IF;
1305:
1306: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_ERROR;
1310: END IF;

Line 1307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1303: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Reversal_Pub.REVERSE_ENTRIES, l_source_table :'||l_source_table);
1304: END IF;
1305:
1306: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_ERROR;
1310: END IF;
1311:

Line 1308: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1304: END IF;
1305:
1306: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_ERROR;
1310: END IF;
1311:
1312: END LOOP; -- new logic for reversing by tcn_id.

Line 1309: RAISE OKL_API.G_EXCEPTION_ERROR;

1305:
1306: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_ERROR;
1310: END IF;
1311:
1312: END LOOP; -- new logic for reversing by tcn_id.
1313:

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

1328: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Trx_Contracts_Pub.update_trx_contracts :'||l_return_status);
1329: END IF;
1330:
1331: -- store the highest degree of error
1332: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1334: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1335: RAISE OKL_API.G_EXCEPTION_ERROR;
1336: END IF;

Line 1333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1329: END IF;
1330:
1331: -- store the highest degree of error
1332: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1334: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1335: RAISE OKL_API.G_EXCEPTION_ERROR;
1336: END IF;
1337:

Line 1334: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1330:
1331: -- store the highest degree of error
1332: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1334: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1335: RAISE OKL_API.G_EXCEPTION_ERROR;
1336: END IF;
1337:
1338:

Line 1335: RAISE OKL_API.G_EXCEPTION_ERROR;

1331: -- store the highest degree of error
1332: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1334: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1335: RAISE OKL_API.G_EXCEPTION_ERROR;
1336: END IF;
1337:
1338:
1339: END IF; -- for if tcnv_tbl.count > 0 condition

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

1340:
1341: -- set the return status
1342: x_return_status := l_return_status;
1343:
1344: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1345:
1346: EXCEPTION
1347: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1348: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

Line 1347: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1343:
1344: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1345:
1346: EXCEPTION
1347: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1348: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1349: ,g_pkg_name
1350: ,'OKL_API.G_RET_STS_ERROR'
1351: ,x_msg_count

Line 1348: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

1344: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1345:
1346: EXCEPTION
1347: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1348: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1349: ,g_pkg_name
1350: ,'OKL_API.G_RET_STS_ERROR'
1351: ,x_msg_count
1352: ,x_msg_data

Line 1350: ,'OKL_API.G_RET_STS_ERROR'

1346: EXCEPTION
1347: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1348: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1349: ,g_pkg_name
1350: ,'OKL_API.G_RET_STS_ERROR'
1351: ,x_msg_count
1352: ,x_msg_data
1353: ,'_PVT');
1354:

Line 1355: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1351: ,x_msg_count
1352: ,x_msg_data
1353: ,'_PVT');
1354:
1355: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1356: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1357: ,g_pkg_name
1358: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1359: ,x_msg_count

Line 1356: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

1352: ,x_msg_data
1353: ,'_PVT');
1354:
1355: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1356: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1357: ,g_pkg_name
1358: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1359: ,x_msg_count
1360: ,x_msg_data

Line 1358: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1354:
1355: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1356: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1357: ,g_pkg_name
1358: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1359: ,x_msg_count
1360: ,x_msg_data
1361: ,'_PVT');
1362:

Line 1364: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1360: ,x_msg_data
1361: ,'_PVT');
1362:
1363: WHEN OTHERS THEN
1364: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1365: (l_api_name,
1366: G_PKG_NAME,
1367: 'OTHERS',
1368: x_msg_count,

Line 1375: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1371: END REVERSE_SEC_REP_TRX;
1372:
1373: PROCEDURE REVERSE_SEC_REP_TRX (
1374: P_API_VERSION IN NUMBER,
1375: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1376: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1377: X_MSG_COUNT OUT NOCOPY NUMBER,
1378: X_MSG_DATA OUT NOCOPY VARCHAR2,
1379: P_TCNV_TBL tcnv_tbl_type)

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

1381:
1382: /* variables */
1383: l_api_name CONSTANT VARCHAR2(40) := 'REVERSE_SEC_REP_TRX';
1384: l_api_version CONSTANT NUMBER := 1.0;
1385: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1386:
1387: BEGIN
1388:
1389: l_return_status := OKL_API.START_ACTIVITY(l_api_name

Line 1389: l_return_status := OKL_API.START_ACTIVITY(l_api_name

1385: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1386:
1387: BEGIN
1388:
1389: l_return_status := OKL_API.START_ACTIVITY(l_api_name
1390: ,G_PKG_NAME
1391: ,p_init_msg_list
1392: ,l_api_version
1393: ,p_api_version

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

1393: ,p_api_version
1394: ,'_PVT'
1395: ,l_return_status);
1396:
1397: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1399: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1400: RAISE OKL_API.G_EXCEPTION_ERROR;
1401: END IF;

Line 1398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1394: ,'_PVT'
1395: ,l_return_status);
1396:
1397: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1399: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1400: RAISE OKL_API.G_EXCEPTION_ERROR;
1401: END IF;
1402:

Line 1399: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1395: ,l_return_status);
1396:
1397: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1399: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1400: RAISE OKL_API.G_EXCEPTION_ERROR;
1401: END IF;
1402:
1403: IF (p_tcnv_tbl.COUNT > 0) THEN

Line 1400: RAISE OKL_API.G_EXCEPTION_ERROR;

1396:
1397: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1399: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1400: RAISE OKL_API.G_EXCEPTION_ERROR;
1401: END IF;
1402:
1403: IF (p_tcnv_tbl.COUNT > 0) THEN
1404:

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

1411: ,x_msg_count => x_msg_count
1412: ,x_msg_data => x_msg_data
1413: ,p_tcnv_rec => p_tcnv_tbl(i));
1414:
1415: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1417: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1418: RAISE OKL_API.G_EXCEPTION_ERROR;
1419: END IF;

Line 1416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1412: ,x_msg_data => x_msg_data
1413: ,p_tcnv_rec => p_tcnv_tbl(i));
1414:
1415: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1417: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1418: RAISE OKL_API.G_EXCEPTION_ERROR;
1419: END IF;
1420:

Line 1417: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1413: ,p_tcnv_rec => p_tcnv_tbl(i));
1414:
1415: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1417: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1418: RAISE OKL_API.G_EXCEPTION_ERROR;
1419: END IF;
1420:
1421: END LOOP;

Line 1418: RAISE OKL_API.G_EXCEPTION_ERROR;

1414:
1415: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1417: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1418: RAISE OKL_API.G_EXCEPTION_ERROR;
1419: END IF;
1420:
1421: END LOOP;
1422:

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

1424:
1425: -- set the overall return status
1426: x_return_status := l_return_status;
1427:
1428: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1429:
1430: EXCEPTION
1431: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

Line 1431: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1427:
1428: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1429:
1430: EXCEPTION
1431: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1433: ,g_pkg_name
1434: ,'OKL_API.G_RET_STS_ERROR'
1435: ,x_msg_count

Line 1432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

1428: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1429:
1430: EXCEPTION
1431: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1433: ,g_pkg_name
1434: ,'OKL_API.G_RET_STS_ERROR'
1435: ,x_msg_count
1436: ,x_msg_data

Line 1434: ,'OKL_API.G_RET_STS_ERROR'

1430: EXCEPTION
1431: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1433: ,g_pkg_name
1434: ,'OKL_API.G_RET_STS_ERROR'
1435: ,x_msg_count
1436: ,x_msg_data
1437: ,'_PVT');
1438:

Line 1439: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1435: ,x_msg_count
1436: ,x_msg_data
1437: ,'_PVT');
1438:
1439: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1441: ,g_pkg_name
1442: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1443: ,x_msg_count

Line 1440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

1436: ,x_msg_data
1437: ,'_PVT');
1438:
1439: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1441: ,g_pkg_name
1442: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1443: ,x_msg_count
1444: ,x_msg_data

Line 1442: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1438:
1439: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
1441: ,g_pkg_name
1442: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1443: ,x_msg_count
1444: ,x_msg_data
1445: ,'_PVT');
1446:

Line 1448: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1444: ,x_msg_data
1445: ,'_PVT');
1446:
1447: WHEN OTHERS THEN
1448: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1449: (l_api_name,
1450: G_PKG_NAME,
1451: 'OTHERS',
1452: x_msg_count,