DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_CASH_APP_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 717: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_invoice_currency_code

713: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
714: );
715: RAISE G_EXCEPTION_HALT_VALIDATION;
716: ELSE
717: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_invoice_currency_code
718: ,l_receipt_currency
719: ,l_receipt_date
720: ,l_exchange_rate_type
721: );

Line 1092: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_invoice_currency_code

1088: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1089: );
1090: RAISE G_EXCEPTION_HALT_VALIDATION;
1091: ELSE
1092: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_invoice_currency_code
1093: ,l_receipt_currency_code
1094: ,l_receipt_date
1095: ,l_exchange_rate_type
1096: );

Line 1564: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_invoice_currency_code

1560: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1561: );
1562: RAISE G_EXCEPTION_HALT_VALIDATION;
1563: ELSE
1564: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_invoice_currency_code
1565: ,l_receipt_currency_code
1566: ,l_receipt_date
1567: ,l_exchange_rate_type
1568: );

Line 2317: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_invoice_currency_code

2313: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2314: );
2315: RAISE G_EXCEPTION_HALT_VALIDATION;
2316: ELSE
2317: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_invoice_currency_code
2318: ,l_receipt_currency
2319: ,l_receipt_date
2320: ,l_exchange_rate_type
2321: );

Line 2543: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_invoice_currency_code

2539: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2540: );
2541: RAISE G_EXCEPTION_HALT_VALIDATION;
2542: ELSE
2543: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_invoice_currency_code
2544: ,l_receipt_currency
2545: ,l_receipt_date
2546: ,l_exchange_rate_type
2547: );

Line 3140: l_error_msg_rec Okl_Accounting_Util.Error_message_Type;

3136: l_msg_data VARCHAR2(450);
3137: l_init_msg_list VARCHAR2(1) := 'T';
3138:
3139: l_msg_index_out NUMBER :=0;
3140: l_error_msg_rec Okl_Accounting_Util.Error_message_Type;
3141:
3142: l_contract_num VARCHAR2(250) := p_contract_num;
3143: l_customer_acct_id NUMBER := p_customer_acct_id;
3144:

Line 3192: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);

3188:
3189:
3190: BEGIN
3191:
3192: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3193: IF (l_error_msg_rec.COUNT > 0) THEN
3194: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
3195: LOOP
3196: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));

Line 3359: AND ledger_id = okl_accounting_util.get_set_of_books_id

3355: WHERE application_id = 222
3356: -- BEGIN abindal bug 4356410 --
3357: AND closing_status IN ('F','O')
3358: -- END abindal bug 4356410 --
3359: AND ledger_id = okl_accounting_util.get_set_of_books_id
3360: AND trunc(cp_date) between start_date and end_date
3361: AND adjustment_period_flag = 'N'
3362: UNION
3363: SELECT MAX(end_date) gl_date, 2 Counter

Line 3366: AND ledger_id = okl_accounting_util.get_set_of_books_id

3362: UNION
3363: SELECT MAX(end_date) gl_date, 2 Counter
3364: FROM gl_period_statuses
3365: WHERE application_id = 222
3366: AND ledger_id = okl_accounting_util.get_set_of_books_id
3367: AND closing_status IN ('F','O')
3368: AND end_date <= trunc(cp_date)
3369: AND adjustment_period_flag = 'N'
3370: UNION

Line 3374: AND ledger_id = okl_accounting_util.get_set_of_books_id

3370: UNION
3371: SELECT MIN(start_date) gl_date, 3 Counter
3372: FROM gl_period_statuses
3373: WHERE application_id = 222
3374: AND ledger_id = okl_accounting_util.get_set_of_books_id
3375: AND closing_status IN ('F','O')
3376: AND start_date >= trunc(cp_date)
3377: AND adjustment_period_flag = 'N'
3378: )