DBA Data[Home] [Help]

APPS.OKL_LCKBX_CSH_APP_PVT dependencies on OKL_AUTO_CASH_APPL_RULES_PVT

Line 1335: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv with parameters: '

1331: log_debug
1332: ('Trying to match Invocie Reference to OKL related AR invoice. ( Post R12 OKL Invoice)'
1333: );
1334: log_debug
1335: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv with parameters: '
1336: );
1337: log_debug ('p_customer_num = ' || l_customer_number);
1338: log_debug ( 'p_arinv_number = '
1339: || l_orig_rcpt_tbl (i).invoice_number

Line 1373: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv

1369: log_debug('p_amount_app_to = '|| l_orig_rcpt_tbl(i).amount_applied);
1370: log_debug('p_amount_app_from = '|| l_orig_rcpt_tbl(i).amount_applied_from);
1371: log_debug('invoice currency = '|| l_returned_curr_code);
1372: --Check if reference number matches any okl related AR invoices(Post R12 okl invoices)
1373: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv
1374: (p_api_version => l_api_version,
1375: p_init_msg_list => l_init_msg_list,
1376: x_return_status => l_return_status,
1377: x_msg_count => l_msg_count,

Line 1395: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv return status = '

1391: x_onacc_amount => l_onacc_amount,
1392: x_unapply_amount => l_unapply_amount
1393: );
1394: log_debug
1395: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv return status = '
1396: || l_return_status
1397: );
1398: log_debug
1399: ( 'Number of invoices identified for application purpose = '

Line 1425: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv with parameters: '

1421: log_debug
1422: ('Trying to match Invocie Reference to OKL Consolidated invoice. ( Pre R12 OKL Invoice)'
1423: );
1424: log_debug
1425: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv with parameters: '
1426: );
1427: log_debug ('p_customer_num = ' || l_customer_number);
1428: log_debug ( 'p_cons_inv = '
1429: || l_orig_rcpt_tbl (i).invoice_number

Line 1464: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv

1460: log_debug('p_amount_app_to = '|| l_orig_rcpt_tbl(i).amount_applied);
1461: log_debug('p_amount_app_from = '|| l_orig_rcpt_tbl(i).amount_applied_from);
1462: log_debug('invoice currency = '|| l_returned_curr_code);
1463: --Check if reference number matches any okl consolidated invoices (PRE R12 okl invoices)
1464: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv
1465: (p_api_version => l_api_version,
1466: p_init_msg_list => l_init_msg_list,
1467: x_return_status => l_return_status,
1468: x_msg_count => l_msg_count,

Line 1486: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv return status = '

1482: x_onacc_amount => l_onacc_amount,
1483: x_unapply_amount => l_unapply_amount
1484: );
1485: log_debug
1486: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv return status = '
1487: || l_return_status
1488: );
1489: log_debug
1490: ( 'Number of invoices identified for application purpose = '

Line 1516: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract with parameters: '

1512: log_debug
1513: ('Trying to match Invocie Reference to OKL Contract Number.'
1514: );
1515: log_debug
1516: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract with parameters: '
1517: );
1518: log_debug ('p_customer_num = ' || l_customer_number);
1519: log_debug ( 'p_contract_num = '
1520: || l_orig_rcpt_tbl (i).invoice_number

Line 1555: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract

1551: log_debug('p_amount_app_to = '|| l_orig_rcpt_tbl(i).amount_applied);
1552: log_debug('p_amount_app_from = '|| l_orig_rcpt_tbl(i).amount_applied_from);
1553: log_debug('invoice currency = '|| l_returned_curr_code);
1554: --Check if reference number matches any okl contracts
1555: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract
1556: (p_api_version => l_api_version,
1557: p_init_msg_list => l_init_msg_list,
1558: x_return_status => l_return_status,
1559: x_msg_count => l_msg_count,

Line 1577: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract return status = '

1573: x_onacc_amount => l_onacc_amount,
1574: x_unapply_amount => l_unapply_amount
1575: );
1576: log_debug
1577: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract return status = '
1578: || l_return_status
1579: );
1580: log_debug
1581: ( 'Number of invoices identified for application purpose = '

Line 1632: ( 'okl_auto_cash_appl_rules_pvt.handle_combi_pay return status = '

1628: p_currency_code => l_currency_code,
1629: x_appl_tbl => l_okl_rcpt_tbl
1630: );
1631: log_debug
1632: ( 'okl_auto_cash_appl_rules_pvt.handle_combi_pay return status = '
1633: || l_return_status
1634: );
1635: log_debug
1636: ( 'Number of invoices identified for application purpose = '

Line 1653: ('Calling okl_auto_cash_appl_rules_pvt.receipt_mismatch with parameters: '

1649: -- still no match, lets apply to customers oldest/newest invoice(s)
1650: log_debug ('Search Rules failed.');
1651: log_debug ('Trying to use Receipt Mismatch Rules');
1652: log_debug
1653: ('Calling okl_auto_cash_appl_rules_pvt.receipt_mismatch with parameters: '
1654: );
1655: log_debug ('p_customer_num = ' || l_customer_number);
1656: log_debug ('p_currency_code = ' || l_currency_code);
1657: log_debug ( 'p_rcpt_amount = '

Line 1665: okl_auto_cash_appl_rules_pvt.receipt_mismatch

1661: --asawanka modified for llca start
1662: --changed api call
1663: IF l_tmp_currency_code IS NULL OR l_tmp_currency_code = l_currency_code
1664: THEN
1665: okl_auto_cash_appl_rules_pvt.receipt_mismatch
1666: (p_api_version => l_api_version,
1667: p_init_msg_list => l_init_msg_list,
1668: x_return_status => l_return_status,
1669: x_msg_count => l_msg_count,

Line 1681: ( 'okl_auto_cash_appl_rules_pvt.receipt_mismatch return status = '

1677: x_onacc_amount => l_onacc_amount
1678: );
1679: --asawanka modified for llca end
1680: log_debug
1681: ( 'okl_auto_cash_appl_rules_pvt.receipt_mismatch return status = '
1682: || l_return_status
1683: );
1684: log_debug
1685: ( 'Number of invoices identified for application purpose = '

Line 2564: -- Start of wraper code generated automatically by Debug code generator for okl_auto_cash_appl_rules_pvt.auto_cash_app

2560: INTO l_lockbox_run_already;
2561:
2562: CLOSE c_lckbx_status;
2563:
2564: -- Start of wraper code generated automatically by Debug code generator for okl_auto_cash_appl_rules_pvt.auto_cash_app
2565: IF (l_debug_enabled = 'Y') THEN
2566: l_level_statement := fnd_log.level_procedure;
2567: is_debug_statement_on :=
2568: okl_debug_pub.check_log_on (l_module,

Line 2590: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv with parameters: '

2586: log_debug
2587: ('Trying to match Invocie Reference to OKL related AR invoice. ( Post R12 OKL Invoice)'
2588: );
2589: log_debug
2590: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv with parameters: '
2591: );
2592: log_debug ('p_customer_num = ' || l_customer_number);
2593: log_debug ( 'p_arinv_number = '
2594: || l_orig_rcpt_tbl (i).invoice_number

Line 2632: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv

2628: log_debug('p_amount_app_to = '|| l_orig_rcpt_tbl(i).amount_applied);
2629: log_debug('p_amount_app_from = '|| l_orig_rcpt_tbl(i).amount_applied_from);
2630: log_debug('invoice currency = '|| l_returned_curr_code);
2631: --Check if reference number matches any okl related AR invoices(Post R12 okl invoices)
2632: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv
2633: (p_api_version => l_api_version,
2634: p_init_msg_list => l_init_msg_list,
2635: x_return_status => l_return_status,
2636: x_msg_count => l_msg_count,

Line 2654: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv return status = '

2650: x_onacc_amount => l_onacc_amount,
2651: x_unapply_amount => l_unapply_amount
2652: );
2653: log_debug
2654: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv return status = '
2655: || l_return_status
2656: );
2657: log_debug
2658: ( 'Number of invoices identified for application purpose = '

Line 2685: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv with parameters: '

2681: log_debug
2682: ('Trying to match Invocie Reference to OKL Consolidated invoice. ( Pre R12 OKL Invoice)'
2683: );
2684: log_debug
2685: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv with parameters: '
2686: );
2687: log_debug ('p_customer_num = ' || l_customer_number);
2688: log_debug ( 'p_cons_inv = '
2689: || l_orig_rcpt_tbl (i).invoice_number

Line 2726: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv

2722: log_debug('p_amount_app_to = '|| l_orig_rcpt_tbl(i).amount_applied);
2723: log_debug('p_amount_app_from = '|| l_orig_rcpt_tbl(i).amount_applied_from);
2724: log_debug('invoice currency = '|| l_returned_curr_code);
2725: --Check if reference number matches any okl consolidated invoices (PRE R12 okl invoices)
2726: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv
2727: (p_api_version => l_api_version,
2728: p_init_msg_list => l_init_msg_list,
2729: x_return_status => l_return_status,
2730: x_msg_count => l_msg_count,

Line 2748: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv return status = '

2744: x_onacc_amount => l_onacc_amount,
2745: x_unapply_amount => l_unapply_amount
2746: );
2747: log_debug
2748: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv return status = '
2749: || l_return_status
2750: );
2751: log_debug
2752: ( 'Number of invoices identified for application purpose = '

Line 2779: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract with parameters: '

2775: log_debug
2776: ('Trying to match Invocie Reference to OKL Contract Number.'
2777: );
2778: log_debug
2779: ('Calling okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract with parameters: '
2780: );
2781: log_debug ('p_customer_num = ' || l_customer_number);
2782: log_debug ( 'p_contract_num = '
2783: || l_orig_rcpt_tbl (i).invoice_number

Line 2820: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract

2816: log_debug('p_amount_app_to = '|| l_orig_rcpt_tbl(i).amount_applied);
2817: log_debug('p_amount_app_from = '|| l_orig_rcpt_tbl(i).amount_applied_from);
2818: log_debug('invoice currency = '|| l_returned_curr_code);
2819: --Check if reference number matches any okl contracts
2820: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract
2821: (p_api_version => l_api_version,
2822: p_init_msg_list => l_init_msg_list,
2823: x_return_status => l_return_status,
2824: x_msg_count => l_msg_count,

Line 2842: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract return status = '

2838: x_onacc_amount => l_onacc_amount,
2839: x_unapply_amount => l_unapply_amount
2840: );
2841: log_debug
2842: ( 'okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract return status = '
2843: || l_return_status
2844: );
2845: log_debug
2846: ( 'Number of invoices identified for application purpose = '

Line 2896: ( 'okl_auto_cash_appl_rules_pvt.handle_combi_pay return status = '

2892: p_currency_code => l_currency_code,
2893: x_appl_tbl => l_okl_rcpt_tbl
2894: );
2895: log_debug
2896: ( 'okl_auto_cash_appl_rules_pvt.handle_combi_pay return status = '
2897: || l_return_status
2898: );
2899: log_debug
2900: ( 'Number of invoices identified for application purpose = '

Line 2917: ('Calling okl_auto_cash_appl_rules_pvt.receipt_mismatch with parameters: '

2913: -- still no match, lets apply to customers oldest/newest invoice(s)
2914: log_debug ('Search Rules failed.');
2915: log_debug ('Trying to use Receipt Mismatch Rules');
2916: log_debug
2917: ('Calling okl_auto_cash_appl_rules_pvt.receipt_mismatch with parameters: '
2918: );
2919: log_debug ('p_customer_num = ' || l_customer_number);
2920: log_debug ('p_currency_code = ' || l_currency_code);
2921: log_debug ( 'p_rcpt_amount = '

Line 2929: okl_auto_cash_appl_rules_pvt.receipt_mismatch

2925: --asawanka modified for llca start
2926: --changed api call
2927: IF l_tmp_currency_code IS NULL OR l_tmp_currency_code = l_currency_code
2928: THEN
2929: okl_auto_cash_appl_rules_pvt.receipt_mismatch
2930: (p_api_version => l_api_version,
2931: p_init_msg_list => l_init_msg_list,
2932: x_return_status => l_return_status,
2933: x_msg_count => l_msg_count,

Line 2945: ( 'okl_auto_cash_appl_rules_pvt.receipt_mismatch return status = '

2941: x_onacc_amount => l_onacc_amount
2942: );
2943: --asawanka modified for llca end
2944: log_debug
2945: ( 'okl_auto_cash_appl_rules_pvt.receipt_mismatch return status = '
2946: || l_return_status
2947: );
2948: log_debug
2949: ( 'Number of invoices identified for application purpose = '