DBA Data[Home] [Help]

APPS.OKL_ACCT_GEN_RULE_PVT dependencies on OKL_API

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

14:
15: l_api_name CONSTANT VARCHAR2(40) := 'GET_RULE_LINES_COUNT';
16: l_api_version CONSTANT NUMBER := 1.0;
17: l_row_count NUMBER;
18: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19: l_acc_lines aulv_tbl_type;
20: i NUMBER := 0;
21: l_set_of_books_id NUMBER ;
22: l_agr_id NUMBER;

Line 75: x_return_status := OKL_API.G_RET_STS_SUCCESS;

71:
72:
73: BEGIN
74:
75: x_return_status := OKL_API.G_RET_STS_SUCCESS;
76:
77: -- Get set of books id
78:
79: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;

Line 114: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

110:
111: EXCEPTION
112:
113: WHEN OTHERS THEN
114: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
115:
116: END GET_RULE_LINES_COUNT;
117:
118:

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

129:
130: l_api_name CONSTANT VARCHAR2(40) := 'GET_RULE_LINES';
131: l_api_version CONSTANT NUMBER := 1.0;
132: l_row_count NUMBER;
133: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
134: l_acc_lines acct_tbl_type;
135: i NUMBER := 0;
136: l_set_of_books_id NUMBER ;
137: l_agr_id NUMBER;

Line 190: x_return_status := OKL_API.G_RET_STS_SUCCESS;

186:
187:
188: BEGIN
189:
190: x_return_status := OKL_API.G_RET_STS_SUCCESS;
191:
192: -- Get set of books id and ORG id
193:
194: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;

Line 268: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

264: EXCEPTION
265:
266: WHEN OTHERS THEN
267:
268: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
269:
270: END GET_RULE_LINES;
271:
272:

Line 389: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

385: AND set_of_books_id = v_set_of_books_id;
386:
387: l_dummy VARCHAR2(1);
388: l_api_version NUMBER := 1.0;
389: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
390: l_msg_count NUMBER := 0;
391: l_msg_data VARCHAR2(2000);
392: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
393: l_ae_line_type OKL_ACCT_GEN_RULES_V.AE_LINE_TYPE%TYPE;

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

388: l_api_version NUMBER := 1.0;
389: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
390: l_msg_count NUMBER := 0;
391: l_msg_data VARCHAR2(2000);
392: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
393: l_ae_line_type OKL_ACCT_GEN_RULES_V.AE_LINE_TYPE%TYPE;
394:
395: l_aulv_tbl_in AULV_TBL_TYPE;
396: l_aulv_tbl_out AULV_TBL_TYPE;

Line 408: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

404: BEGIN
405: -- Added by Santonyr 13-Aug-2002
406: -- Fixed bug 2500771
407:
408: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
409: ,G_PKG_NAME
410: ,p_init_msg_list
411: ,l_api_version
412: ,p_api_version

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

411: ,l_api_version
412: ,p_api_version
413: ,'_PVT'
414: ,l_return_status);
415: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
417: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;

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

413: ,'_PVT'
414: ,l_return_status);
415: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
417: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:
421:

Line 484: Okl_Api.end_activity(x_msg_count, x_msg_data);

480: -- Added by Santonyr 13-Aug-2002
481: -- Fixed bug 2500771
482:
483: x_return_status := l_return_status;
484: Okl_Api.end_activity(x_msg_count, x_msg_data);
485:
486: EXCEPTION
487:
488: WHEN FND_API.G_EXC_ERROR THEN

Line 489: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

485:
486: EXCEPTION
487:
488: WHEN FND_API.G_EXC_ERROR THEN
489: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
490: ,g_pkg_name
491: ,'OKL_API.G_RET_STS_ERROR'
492: ,x_msg_count
493: ,x_msg_data

Line 491: ,'OKL_API.G_RET_STS_ERROR'

487:
488: WHEN FND_API.G_EXC_ERROR THEN
489: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
490: ,g_pkg_name
491: ,'OKL_API.G_RET_STS_ERROR'
492: ,x_msg_count
493: ,x_msg_data
494: ,'_PVT');
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 496: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

492: ,x_msg_count
493: ,x_msg_data
494: ,'_PVT');
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
497: ,g_pkg_name
498: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
499: ,x_msg_count
500: ,x_msg_data

Line 498: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

494: ,'_PVT');
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
497: ,g_pkg_name
498: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
499: ,x_msg_count
500: ,x_msg_data
501: ,'_PVT');
502: WHEN OTHERS THEN

Line 503: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

499: ,x_msg_count
500: ,x_msg_data
501: ,'_PVT');
502: WHEN OTHERS THEN
503: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
504: ,g_pkg_name
505: ,'OTHERS'
506: ,x_msg_count
507: ,x_msg_data