DBA Data[Home] [Help]

APPS.OKL_PRB_UPGRADE_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 153: l_outer_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;

149: AND opp.assigned_process = p_worker_id; -- Fetch only this worker related contracts
150: TYPE esg_upg_cntrcts_tbl_type IS TABLE OF get_esg_upgw_contracts_csr%ROWTYPE
151: INDEX BY BINARY_INTEGER;
152: -- Local Variable Declaration
153: l_outer_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;
154: l_esg_upg_cntrcts_tbl esg_upg_cntrcts_tbl_type;
155: l_khr_id NUMBER;
156: -- Common Local Variables
157: l_api_name CONSTANT VARCHAR2(30) := 'EFF_DATED_RBK_UPGRADE';

Line 308: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

304: log_msg(FND_FILE.OUTPUT,'');
305: log_msg(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
306: log_msg(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
307: ||' '||l_return_status);
308: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
309: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
310: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
311: LOOP
312: log_msg(FND_FILE.LOG, l_outer_error_msg_tbl(i));

Line 325: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

321: log_msg(FND_FILE.OUTPUT,'');
322: log_msg(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
323: log_msg(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
324: ||' '||l_return_status);
325: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
326: IF (l_outer_error_msg_tbl.COUNT > 0)
327: THEN
328: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
329: LOOP

Line 343: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

339: log_msg(FND_FILE.OUTPUT,'');
340: log_msg(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
341: log_msg(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
342: ||' '||l_return_status);
343: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
344: IF (l_outer_error_msg_tbl.COUNT > 0)
345: THEN
346: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
347: LOOP

Line 445: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_BOOK_CLASS',p_book_classification) book_classification

441: ,( SELECT DISTINCT legal_entity_name from XLE_LE_OU_LEDGER_V
442: WHERE legal_entity_id = p_le_id
443: AND rownum <= 1 ) le_id
444: ,( SELECT contract_number FROM OKC_K_HEADERS_B WHERE id = p_khr_id ) khr_id
445: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_BOOK_CLASS',p_book_classification) book_classification
446: ,( SELECT name from okl_products where id = p_pdt_id ) pdt_id
447: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_INTEREST_CALCULATION_BASIS',p_int_calc_method) int_calc_method
448: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REVENUE_RECOGNITION_METHOD',p_rev_rec_method) rev_rec_method
449: ,p_start_date_low start_date_low

Line 447: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_INTEREST_CALCULATION_BASIS',p_int_calc_method) int_calc_method

443: AND rownum <= 1 ) le_id
444: ,( SELECT contract_number FROM OKC_K_HEADERS_B WHERE id = p_khr_id ) khr_id
445: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_BOOK_CLASS',p_book_classification) book_classification
446: ,( SELECT name from okl_products where id = p_pdt_id ) pdt_id
447: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_INTEREST_CALCULATION_BASIS',p_int_calc_method) int_calc_method
448: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REVENUE_RECOGNITION_METHOD',p_rev_rec_method) rev_rec_method
449: ,p_start_date_low start_date_low
450: ,p_start_date_high start_date_high
451: ,p_end_date_low end_date_low

Line 448: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REVENUE_RECOGNITION_METHOD',p_rev_rec_method) rev_rec_method

444: ,( SELECT contract_number FROM OKC_K_HEADERS_B WHERE id = p_khr_id ) khr_id
445: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_BOOK_CLASS',p_book_classification) book_classification
446: ,( SELECT name from okl_products where id = p_pdt_id ) pdt_id
447: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_INTEREST_CALCULATION_BASIS',p_int_calc_method) int_calc_method
448: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REVENUE_RECOGNITION_METHOD',p_rev_rec_method) rev_rec_method
449: ,p_start_date_low start_date_low
450: ,p_start_date_high start_date_high
451: ,p_end_date_low end_date_low
452: ,p_end_date_high end_date_high

Line 453: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_UPG_INTRANSIT_CAT',p_in_transit_category) in_transit_category

449: ,p_start_date_low start_date_low
450: ,p_start_date_high start_date_high
451: ,p_end_date_low end_date_low
452: ,p_end_date_high end_date_high
453: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_UPG_INTRANSIT_CAT',p_in_transit_category) in_transit_category
454: ,DECODE(p_mode_of_run, 'REVIEW', 'Review', 'SUBMIT', 'Submit' ) mode_of_run
455: ,p_tag_name tag_name
456: ,p_no_of_workers no_of_workers
457: FROM DUAL;