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.

APPS.OKL_BPD_ADVANCED_CASH_APP_PVT dependencies on FND_FILE

Line 12: FND_FILE.PUT_LINE (FND_FILE.LOG, p_message);

8: -- End of wraper code generated automatically by Debug code generator
9:
10: PROCEDURE log_file(p_message IN VARCHAR2) IS
11: BEGIN
12: FND_FILE.PUT_LINE (FND_FILE.LOG, p_message);
13: END;
14:
15: PROCEDURE migrate_Applications ( p_api_version IN NUMBER
16: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE

Line 615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');

611: fetch c_customer_acc_num into l_customer_num;
612: close c_customer_acc_num;
613: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
614:
615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
616: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
618:
619: IF l_contract_num IS NULL THEN

Line 616: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Start Processing. Please See Error Log for any errored transactions ');

612: close c_customer_acc_num;
613: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
614:
615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
616: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
618:
619: IF l_contract_num IS NULL THEN
620: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------------');

Line 617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');

613: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
614:
615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
616: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
618:
619: IF l_contract_num IS NULL THEN
620: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------------');
621: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify a contract Number.');

Line 620: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------------');

616: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
618:
619: IF l_contract_num IS NULL THEN
620: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------------');
621: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify a contract Number.');
622: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------------');
623: END IF;
624:

Line 621: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify a contract Number.');

617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
618:
619: IF l_contract_num IS NULL THEN
620: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------------');
621: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify a contract Number.');
622: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------------');
623: END IF;
624:
625: ------------------------------------------------------------

Line 622: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------------');

618:
619: IF l_contract_num IS NULL THEN
620: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------------');
621: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify a contract Number.');
622: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------------');
623: END IF;
624:
625: ------------------------------------------------------------
626: -- Handle call from auto billing api ...

Line 631: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num);

627: ------------------------------------------------------------
628:
629: IF l_contract_num IS NOT NULL THEN
630:
631: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num);
632: log_file('BEFORE CUrsor');
633: FOR c_open_invs_rec IN c_open_invs (l_contract_num, l_customer_num, null)
634: LOOP
635: l_inv_tot := l_inv_tot + c_open_invs_rec.amount_due_remaining;

Line 645: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');

641: log_file('l_inv_tot = '||l_inv_tot);
642: log_file('l_contract_id = '||l_contract_id);
643: log_file('l_customer_id = '||l_customer_id);
644: IF l_inv_tot = 0 THEN
645: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
646: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply advanced receipts');
647: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_contract_num);
648: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
649: END IF;

Line 646: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply advanced receipts');

642: log_file('l_contract_id = '||l_contract_id);
643: log_file('l_customer_id = '||l_customer_id);
644: IF l_inv_tot = 0 THEN
645: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
646: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply advanced receipts');
647: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_contract_num);
648: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
649: END IF;
650:

Line 647: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_contract_num);

643: log_file('l_customer_id = '||l_customer_id);
644: IF l_inv_tot = 0 THEN
645: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
646: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply advanced receipts');
647: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_contract_num);
648: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
649: END IF;
650:
651: IF l_inv_tot > 0 THEN

Line 648: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');

644: IF l_inv_tot = 0 THEN
645: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
646: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply advanced receipts');
647: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_contract_num);
648: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
649: END IF;
650:
651: IF l_inv_tot > 0 THEN
652:

Line 667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT '||l_contract_num|| 'now has a zero balance - receipt application complete');

663: l_inv_tot := l_inv_tot + c_open_invs_rec.amount_due_remaining;
664: END LOOP;
665:
666: IF l_inv_tot = 0 THEN
667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT '||l_contract_num|| 'now has a zero balance - receipt application complete');
668: l_exit_loop := 1;
669: END IF;
670:
671: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' NEW CONTRACT BALANCE: '||l_inv_tot);

Line 671: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' NEW CONTRACT BALANCE: '||l_inv_tot);

667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT '||l_contract_num|| 'now has a zero balance - receipt application complete');
668: l_exit_loop := 1;
669: END IF;
670:
671: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' NEW CONTRACT BALANCE: '||l_inv_tot);
672: log_file('New Contract balance = '||l_inv_tot);
673: EXIT WHEN l_exit_loop = 1;
674:
675: l_receipt_count := l_receipt_count + 1;

Line 695: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT '||l_check_number|| 'now has zero Balance');

691: log_file('l_cash_receipt_id = '||l_cash_receipt_id);
692: log_file('l_actual_remittance_amount = '||l_actual_remittance_amount);
693: IF l_actual_remittance_amount = 0 OR l_actual_remittance_amount IS NULL THEN
694:
695: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT '||l_check_number|| 'now has zero Balance');
696: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'MOVING ON TO NEXT RECEIPT');
697:
698: GOTO NEXT_RECEIPT;
699: END IF;

Line 696: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'MOVING ON TO NEXT RECEIPT');

692: log_file('l_actual_remittance_amount = '||l_actual_remittance_amount);
693: IF l_actual_remittance_amount = 0 OR l_actual_remittance_amount IS NULL THEN
694:
695: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT '||l_check_number|| 'now has zero Balance');
696: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'MOVING ON TO NEXT RECEIPT');
697:
698: GOTO NEXT_RECEIPT;
699: END IF;
700:

Line 705: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT NUMBER: '||l_check_number);

701: IF l_actual_remittance_amount <> l_remittance_amount THEN
702: l_remittance_amount := l_actual_remittance_amount;
703: END IF;
704: log_file('l_remittance_amount = '||l_remittance_amount);
705: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT NUMBER: '||l_check_number);
706: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT AMOUNT: '||l_actual_remittance_amount);
707:
708: --following code added by dkagrawa for cross currency
709: IF l_invoice_currency_code <> l_receipt_currency THEN

Line 706: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT AMOUNT: '||l_actual_remittance_amount);

702: l_remittance_amount := l_actual_remittance_amount;
703: END IF;
704: log_file('l_remittance_amount = '||l_remittance_amount);
705: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT NUMBER: '||l_check_number);
706: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT AMOUNT: '||l_actual_remittance_amount);
707:
708: --following code added by dkagrawa for cross currency
709: IF l_invoice_currency_code <> l_receipt_currency THEN
710: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

Line 735: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'No cash application rules required. Balance of contract is less than or equal to receipt amount');

731: END IF;
732:
733: IF l_inv_tot <= l_remittance_amount THEN
734:
735: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'No cash application rules required. Balance of contract is less than or equal to receipt amount');
736: log_file('calling apply_rcpt_to_contract_no_rule ');
737: apply_rcpt_to_contract_no_rule ( p_api_version => l_api_version
738: ,p_init_msg_list => l_init_msg_list
739: ,x_return_status => l_return_status

Line 767: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cash application rule required. Balance of contract is greater than receipt amount');

763: ELSIF l_inv_tot > l_remittance_amount THEN
764:
765: -- call procedure to do cash app
766:
767: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cash application rule required. Balance of contract is greater than receipt amount');
768: log_file('calling apply_rcpt_to_contract_w_rule');
769: apply_rcpt_to_contract_w_rule ( p_api_version => l_api_version
770: ,p_init_msg_list => l_init_msg_list
771: ,x_return_status => l_return_status

Line 849: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------------------------------------------');

845:
846: END LOOP; -- looping through available advanced receipts for contract ...
847:
848: IF l_receipt_count = 0 THEN
849: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------------------------------------------');
850: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'There are no advanced receipts for this contract - EXITING PROCESS');
851: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------------------------------------------');
852: END IF;
853:

Line 850: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'There are no advanced receipts for this contract - EXITING PROCESS');

846: END LOOP; -- looping through available advanced receipts for contract ...
847:
848: IF l_receipt_count = 0 THEN
849: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------------------------------------------');
850: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'There are no advanced receipts for this contract - EXITING PROCESS');
851: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------------------------------------------');
852: END IF;
853:
854: END IF; -- IF inv_tot > 0

Line 851: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------------------------------------------');

847:
848: IF l_receipt_count = 0 THEN
849: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------------------------------------------');
850: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'There are no advanced receipts for this contract - EXITING PROCESS');
851: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------------------------------------------');
852: END IF;
853:
854: END IF; -- IF inv_tot > 0
855:

Line 862: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

858: ------------------------------------------------------------
859: -- END Handle call from auto billing api ...
860: ------------------------------------------------------------
861:
862: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
863: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
864: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
865: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
866: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

Line 863: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);

859: -- END Handle call from auto billing api ...
860: ------------------------------------------------------------
861:
862: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
863: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
864: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
865: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
866: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);

Line 864: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);

860: ------------------------------------------------------------
861:
862: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
863: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
864: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
865: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
866: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
868: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

Line 865: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);

861:
862: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
863: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
864: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
865: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
866: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
868: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
869:

Line 866: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

862: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
863: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
864: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
865: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
866: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
868: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
869:
870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

Line 867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);

863: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
864: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
865: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
866: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
868: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
869:
870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
871: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** End Processing. Please See Error Log for any errored transactions ** ');

Line 868: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

864: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
865: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
866: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
868: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
869:
870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
871: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** End Processing. Please See Error Log for any errored transactions ** ');
872: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

Line 870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

866: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
868: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
869:
870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
871: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** End Processing. Please See Error Log for any errored transactions ** ');
872: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
873:
874: ------------------------------------------------------------

Line 871: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' End Processing. Please See Error Log for any errored transactions ');

867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
868: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
869:
870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
871: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** End Processing. Please See Error Log for any errored transactions ** ');
872: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
873:
874: ------------------------------------------------------------
875: -- End processing

Line 872: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

868: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
869:
870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
871: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** End Processing. Please See Error Log for any errored transactions ** ');
872: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
873:
874: ------------------------------------------------------------
875: -- End processing
876: ------------------------------------------------------------

Line 1074: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'No cash application, ON-ACCOUNT Cash Application Rule.');

1070: CLOSE c_cash_rle_id_csr;
1071: log_file('l_cau_id = '||l_cau_id);
1072: -- don't do cash application if CAR is 'On Account' -- varao start
1073: IF NVL(l_cau_id, 0) = -1 THEN
1074: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'No cash application, ON-ACCOUNT Cash Application Rule.');
1075: p_remain_rcpt_amount := l_receipt_amount;
1076: ELSE -- varao end
1077: i := 0;
1078: ------------------------------------------------------------

Line 1608: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ADVANCED ALLOCATION RULE USED');

1604: l_applied_running_total := 0;
1605: l_amt_due_remaining_tot := 0;
1606: l_receipt_remaining := l_receipt_amount;
1607:
1608: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ADVANCED ALLOCATION RULE USED');
1609: --Fixed bug 7034283, by nikshah
1610: i := 0;
1611: OPEN c_get_purpose_for_adv_rcpt (l_contract_id, l_receipt_id);
1612: LOOP

Line 1680: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'USING CASH APPLICATIONM RULE');

1676: IF NVL(l_cau_id, 0) = -1 THEN
1677: l_receipt_remaining := l_receipt_amount;
1678: ELSE -- abindal end
1679:
1680: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'USING CASH APPLICATIONM RULE');
1681: IF l_customer_num IS NULL THEN
1682: OPEN c_get_cust_acct_num(l_receipt_id);
1683: FETCH c_get_cust_acct_num INTO l_customer_num; -- now this is a real customer number: HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE
1684: CLOSE c_get_cust_acct_num;

Line 2140: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');

2136: FETCH c_get_cust_Acct_num INTO l_customer_num; -- HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE
2137: CLOSE c_get_cust_Acct_num;
2138: END IF;
2139: log_file('l_customer_num = '||l_customer_num);
2140: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
2141: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
2142: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
2143:
2144: IF l_customer_num IS NULL AND

Line 2141: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Start Processing. Please See Error Log for any errored transactions ');

2137: CLOSE c_get_cust_Acct_num;
2138: END IF;
2139: log_file('l_customer_num = '||l_customer_num);
2140: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
2141: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
2142: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
2143:
2144: IF l_customer_num IS NULL AND
2145: l_contract_num IS NULL AND

Line 2142: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');

2138: END IF;
2139: log_file('l_customer_num = '||l_customer_num);
2140: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
2141: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
2142: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');
2143:
2144: IF l_customer_num IS NULL AND
2145: l_contract_num IS NULL AND
2146: l_receipt_date_from IS NULL AND

Line 2149: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');

2145: l_contract_num IS NULL AND
2146: l_receipt_date_from IS NULL AND
2147: l_receipt_date_to IS NULL AND
2148: l_receipt_num IS NULL THEN
2149: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2150: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - No input parameters specified');
2151: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2152: GOTO END_PROCESS;
2153: END IF;

Line 2150: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - No input parameters specified');

2146: l_receipt_date_from IS NULL AND
2147: l_receipt_date_to IS NULL AND
2148: l_receipt_num IS NULL THEN
2149: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2150: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - No input parameters specified');
2151: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2152: GOTO END_PROCESS;
2153: END IF;
2154:

Line 2151: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');

2147: l_receipt_date_to IS NULL AND
2148: l_receipt_num IS NULL THEN
2149: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2150: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - No input parameters specified');
2151: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2152: GOTO END_PROCESS;
2153: END IF;
2154:
2155: IF l_receipt_num IS NOT NULL AND l_contract_num IS NULL THEN

Line 2156: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------');

2152: GOTO END_PROCESS;
2153: END IF;
2154:
2155: IF l_receipt_num IS NOT NULL AND l_contract_num IS NULL THEN
2156: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------');
2157: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify a contract number to apply cash to');
2158: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------');
2159: GOTO END_PROCESS;
2160: END IF;

Line 2157: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify a contract number to apply cash to');

2153: END IF;
2154:
2155: IF l_receipt_num IS NOT NULL AND l_contract_num IS NULL THEN
2156: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------');
2157: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify a contract number to apply cash to');
2158: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------');
2159: GOTO END_PROCESS;
2160: END IF;
2161:

Line 2158: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------');

2154:
2155: IF l_receipt_num IS NOT NULL AND l_contract_num IS NULL THEN
2156: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------');
2157: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify a contract number to apply cash to');
2158: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------');
2159: GOTO END_PROCESS;
2160: END IF;
2161:
2162: IF l_customer_num IS NOT NULL AND (l_receipt_date_from IS NULL OR l_receipt_date_to IS NULL) THEN

Line 2163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');

2159: GOTO END_PROCESS;
2160: END IF;
2161:
2162: IF l_customer_num IS NOT NULL AND (l_receipt_date_from IS NULL OR l_receipt_date_to IS NULL) THEN
2163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify start and end dates for receipt');
2165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2166: GOTO END_PROCESS;
2167: END IF;

Line 2164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify start and end dates for receipt');

2160: END IF;
2161:
2162: IF l_customer_num IS NOT NULL AND (l_receipt_date_from IS NULL OR l_receipt_date_to IS NULL) THEN
2163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify start and end dates for receipt');
2165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2166: GOTO END_PROCESS;
2167: END IF;
2168:

Line 2165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');

2161:
2162: IF l_customer_num IS NOT NULL AND (l_receipt_date_from IS NULL OR l_receipt_date_to IS NULL) THEN
2163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify start and end dates for receipt');
2165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2166: GOTO END_PROCESS;
2167: END IF;
2168:
2169: IF l_customer_num IS NOT NULL AND (l_receipt_type IS NULL) THEN

Line 2170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');

2166: GOTO END_PROCESS;
2167: END IF;
2168:
2169: IF l_customer_num IS NOT NULL AND (l_receipt_type IS NULL) THEN
2170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify Receipt Type');
2172: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2173: GOTO END_PROCESS;
2174: END IF;

Line 2171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify Receipt Type');

2167: END IF;
2168:
2169: IF l_customer_num IS NOT NULL AND (l_receipt_type IS NULL) THEN
2170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify Receipt Type');
2172: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2173: GOTO END_PROCESS;
2174: END IF;
2175:

Line 2172: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');

2168:
2169: IF l_customer_num IS NOT NULL AND (l_receipt_type IS NULL) THEN
2170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - You must specify Receipt Type');
2172: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------');
2173: GOTO END_PROCESS;
2174: END IF;
2175:
2176:

Line 2260: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num);

2256: ---------------------------------------------------------------
2257:
2258: IF l_contract_num IS NOT NULL AND l_receipt_num IS NOT NULL THEN
2259:
2260: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num);
2261:
2262: IF l_receipt_num IS NOT NULL THEN
2263: l_receipt_id := NULL;
2264: OPEN c_get_rcpt_id(l_receipt_num, l_customer_num);

Line 2296: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT NUMBER: '||l_check_number);

2292: OPEN c_ver_on_acct_amt(l_receipt_id);
2293: FETCH c_ver_on_acct_amt INTO l_actual_remittance_amount;
2294: CLOSE c_ver_on_acct_amt;
2295:
2296: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT NUMBER: '||l_check_number);
2297: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT AMOUNT: '||l_actual_remittance_amount);
2298:
2299: IF l_actual_remittance_amount = 0 THEN
2300: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Receipt number '||l_check_number||' has a zero balance - Cash application cannot continue');

Line 2297: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT AMOUNT: '||l_actual_remittance_amount);

2293: FETCH c_ver_on_acct_amt INTO l_actual_remittance_amount;
2294: CLOSE c_ver_on_acct_amt;
2295:
2296: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT NUMBER: '||l_check_number);
2297: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT AMOUNT: '||l_actual_remittance_amount);
2298:
2299: IF l_actual_remittance_amount = 0 THEN
2300: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Receipt number '||l_check_number||' has a zero balance - Cash application cannot continue');
2301: GOTO END_PROCESS;

Line 2300: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Receipt number '||l_check_number||' has a zero balance - Cash application cannot continue');

2296: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT NUMBER: '||l_check_number);
2297: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT AMOUNT: '||l_actual_remittance_amount);
2298:
2299: IF l_actual_remittance_amount = 0 THEN
2300: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Receipt number '||l_check_number||' has a zero balance - Cash application cannot continue');
2301: GOTO END_PROCESS;
2302: END IF;
2303:
2304: IF l_actual_remittance_amount <> l_remittance_amount THEN

Line 2334: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'No cash application rules required. Balance of contract is less than or equal to receipt amount');

2330: l_inv_tot := l_inv_tot*l_conversion_rate;
2331: END IF;
2332: IF l_inv_tot <= l_remittance_amount THEN
2333:
2334: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'No cash application rules required. Balance of contract is less than or equal to receipt amount');
2335: log_file('calling apply_rcpt_to_contract_no_rule');
2336: apply_rcpt_to_contract_no_rule ( p_api_version => l_api_version
2337: ,p_init_msg_list => l_init_msg_list
2338: ,x_return_status => l_return_status

Line 2358: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cash application rule required. Balance of contract is greater than receipt amount');

2354: );
2355: log_file('l_return_status ='||l_return_status);
2356: ELSIF l_inv_tot > l_remittance_amount THEN
2357:
2358: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cash application rule required. Balance of contract is greater than receipt amount');
2359: log_file('calling apply_rcpt_to_contract_w_rule');
2360: apply_rcpt_to_contract_w_rule ( p_api_version => l_api_version
2361: ,p_init_msg_list => l_init_msg_list
2362: ,x_return_status => l_return_status

Line 2400: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Receipt number '||l_check_number||' has been partially applied.');

2396: END IF;
2397:
2398: IF l_remain_rcpt_amount > 0 THEN
2399: l_rctv_rec.FULLY_APPLIED_FLAG := 'N';
2400: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Receipt number '||l_check_number||' has been partially applied.');
2401: ELSE
2402: l_rctv_rec.FULLY_APPLIED_FLAG := 'Y';
2403: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Receipt number '||l_check_number||' has been fully applied.');
2404: END IF;

Line 2403: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Receipt number '||l_check_number||' has been fully applied.');

2399: l_rctv_rec.FULLY_APPLIED_FLAG := 'N';
2400: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Receipt number '||l_check_number||' has been partially applied.');
2401: ELSE
2402: l_rctv_rec.FULLY_APPLIED_FLAG := 'Y';
2403: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Receipt number '||l_check_number||' has been fully applied.');
2404: END IF;
2405: -- commented out for testing purposes.
2406: -------------------------------------------------------------------
2407: -- COMMIT; -- Need to commit here to update balance of contract ...

Line 2436: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num ||' has no balance.');

2432: END IF;
2433:
2434: END IF;
2435: ELSE
2436: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num ||' has no balance.');
2437: END IF; -- IF l_inv_tot > 0
2438: GOTO END_PROCESS;
2439:
2440: END IF; -- if we have contract number

Line 2446: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CUSTOMER NUMBER: '||l_customer_num);

2442: IF (l_customer_num IS NOT NULL AND l_receipt_type = 'ADV') OR
2443: (l_customer_num IS NULL AND l_contract_num IS NOT NULL)
2444: THEN
2445:
2446: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CUSTOMER NUMBER: '||l_customer_num);
2447:
2448: FOR c_get_cont_for_cust_rec IN c_get_cont_for_cust (l_customer_num, l_contract_num)
2449: LOOP
2450:

Line 2483: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

2479: END IF;
2480:
2481: IF l_customer_num IS NOT NULL AND l_receipt_type = 'ALL' THEN
2482:
2483: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2484: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CUSTOMER NUMBER: '||l_customer_num);
2485:
2486: -- get contract details first, then loop through receipts report all events on form
2487:

Line 2484: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CUSTOMER NUMBER: '||l_customer_num);

2480:
2481: IF l_customer_num IS NOT NULL AND l_receipt_type = 'ALL' THEN
2482:
2483: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2484: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CUSTOMER NUMBER: '||l_customer_num);
2485:
2486: -- get contract details first, then loop through receipts report all events on form
2487:
2488: OPEN c_get_cust_id(l_customer_num);

Line 2505: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '---------------');

2501: l_invoice_currency_code := c_open_invs_rec.currency_code;
2502: l_inv_tot := l_inv_tot + c_open_invs_rec.amount_due_remaining;
2503: END LOOP;
2504: log_file('l_inv_tot = '||l_inv_tot);
2505: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '---------------');
2506: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num|| ' located for cash application ');
2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT BALANCE: '||l_inv_tot);
2508: IF l_inv_tot = 0 THEN
2509: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');

Line 2506: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num|| ' located for cash application ');

2502: l_inv_tot := l_inv_tot + c_open_invs_rec.amount_due_remaining;
2503: END LOOP;
2504: log_file('l_inv_tot = '||l_inv_tot);
2505: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '---------------');
2506: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num|| ' located for cash application ');
2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT BALANCE: '||l_inv_tot);
2508: IF l_inv_tot = 0 THEN
2509: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
2510: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply receipts');

Line 2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT BALANCE: '||l_inv_tot);

2503: END LOOP;
2504: log_file('l_inv_tot = '||l_inv_tot);
2505: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '---------------');
2506: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num|| ' located for cash application ');
2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT BALANCE: '||l_inv_tot);
2508: IF l_inv_tot = 0 THEN
2509: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
2510: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply receipts');
2511: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_contract_num);

Line 2509: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');

2505: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '---------------');
2506: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num|| ' located for cash application ');
2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT BALANCE: '||l_inv_tot);
2508: IF l_inv_tot = 0 THEN
2509: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
2510: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply receipts');
2511: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_contract_num);
2512: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
2513: END IF;

Line 2510: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply receipts');

2506: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT NUMBER: '||l_contract_num|| ' located for cash application ');
2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT BALANCE: '||l_inv_tot);
2508: IF l_inv_tot = 0 THEN
2509: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
2510: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply receipts');
2511: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_contract_num);
2512: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
2513: END IF;
2514: IF l_inv_tot > 0 THEN

Line 2511: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_contract_num);

2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT BALANCE: '||l_inv_tot);
2508: IF l_inv_tot = 0 THEN
2509: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
2510: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply receipts');
2511: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_contract_num);
2512: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
2513: END IF;
2514: IF l_inv_tot > 0 THEN
2515: FOR c_get_csh_rcpt_id_rec IN c_get_csh_rcpt_id (l_customer_id, l_receipt_date_from, l_receipt_date_to, l_invoice_currency_code)

Line 2512: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');

2508: IF l_inv_tot = 0 THEN
2509: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
2510: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Following contract has a balance of zero -- unable to apply receipts');
2511: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_contract_num);
2512: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------');
2513: END IF;
2514: IF l_inv_tot > 0 THEN
2515: FOR c_get_csh_rcpt_id_rec IN c_get_csh_rcpt_id (l_customer_id, l_receipt_date_from, l_receipt_date_to, l_invoice_currency_code)
2516: LOOP

Line 2534: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT '||l_check_number|| ' located with balance of '||l_actual_remittance_amount||' '||l_receipt_currency);

2530: l_remittance_amount := l_actual_remittance_amount;
2531: log_file('l_remittance_amount = '||l_remittance_amount);
2532: IF l_actual_remittance_amount > 0 THEN
2533:
2534: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT '||l_check_number|| ' located with balance of '||l_actual_remittance_amount||' '||l_receipt_currency);
2535: IF l_invoice_currency_code <> l_receipt_currency THEN
2536: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2537: IF l_exchange_rate_type IS NULL THEN
2538: OKL_API.set_message( p_app_name => G_APP_NAME

Line 2559: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'No cash application rules required. Balance of contract is less than or equal to receipt amount');

2555: END IF;
2556: l_inv_tot := l_inv_tot*l_conversion_rate;
2557: END IF;
2558: IF l_inv_tot <= l_actual_remittance_amount THEN
2559: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'No cash application rules required. Balance of contract is less than or equal to receipt amount');
2560: log_file('calling apply_rcpt_to_contract_no_rule ');
2561: apply_rcpt_to_contract_no_rule ( p_api_version => l_api_version
2562: ,p_init_msg_list => l_init_msg_list
2563: ,x_return_status => l_return_status

Line 2587: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cash application rule required. Balance of contract is greater than receipt amount');

2583:
2584:
2585: ELSIF l_inv_tot > l_actual_remittance_amount THEN
2586:
2587: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cash application rule required. Balance of contract is greater than receipt amount');
2588: log_file('calling apply_rcpt_to_contract_w_rule');
2589: apply_rcpt_to_contract_w_rule ( p_api_version => l_api_version
2590: ,p_init_msg_list => l_init_msg_list
2591: ,x_return_status => l_return_status

Line 2641: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

2637: EXIT WHEN l_exit_loop = 1;
2638: END IF; --check remittance amount
2639: END LOOP; -- receipt loop
2640: END IF; --check if inv_total>0
2641: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2642:
2643: END LOOP; -- contract loop
2644:
2645: -- END IF;

Line 2651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

2647: END IF;
2648:
2649: <>
2650:
2651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
2653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
2654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
2655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

Line 2652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);

2648:
2649: <>
2650:
2651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
2653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
2654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
2655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);

Line 2653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);

2649: <>
2650:
2651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
2653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
2654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
2655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
2657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

Line 2654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);

2650:
2651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
2653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
2654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
2655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
2657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2658:

Line 2655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

2651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
2653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
2654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
2655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
2657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2658:
2659: ------------------------------------------------------------

Line 2656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);

2652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of receipts processed: '||l_stat_num_of_rcpts);
2653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
2654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
2655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
2657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2658:
2659: ------------------------------------------------------------
2660: -- End processing

Line 2657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');

2653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total of receipt amounts: '||l_stat_total_rcpt_amt);
2654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Total number of contracts that received cash application: '||l_stat_num_of_cont);
2655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PROCESS COMPLETE: '||SYSDATE);
2657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '====================================================================================');
2658:
2659: ------------------------------------------------------------
2660: -- End processing
2661: ------------------------------------------------------------

Line 2905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');

2901: END IF;
2902:
2903: IF l_customer_acct_id IS NULL AND
2904: l_contract_num IS NULL THEN
2905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2906: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - No input parameters specified');
2907: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2908: GOTO END_PROCESS;
2909: END IF;

Line 2906: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - No input parameters specified');

2902:
2903: IF l_customer_acct_id IS NULL AND
2904: l_contract_num IS NULL THEN
2905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2906: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - No input parameters specified');
2907: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2908: GOTO END_PROCESS;
2909: END IF;
2910:

Line 2907: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');

2903: IF l_customer_acct_id IS NULL AND
2904: l_contract_num IS NULL THEN
2905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2906: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'ERROR - No input parameters specified');
2907: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-------------------------------------');
2908: GOTO END_PROCESS;
2909: END IF;
2910:
2911: IF l_customer_acct_id IS NOT NULL THEN

Line 3024: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT '||l_contract_num|| 'HAS NO OPEN INVOICES - EXITING PROCESS ... ');

3020: FETCH c_open_invs INTO l_customer_num;
3021: CLOSE c_open_invs;
3022:
3023: IF l_customer_num IS NULL THEN
3024: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'CONTRACT '||l_contract_num|| 'HAS NO OPEN INVOICES - EXITING PROCESS ... ');
3025: GOTO END_PROCESS;
3026: END IF;
3027:
3028: END IF;

Line 3161: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Process Advanced Monies');

3157: OPEN req_id_csr;
3158: FETCH req_id_csr INTO l_request_id;
3159: CLOSE req_id_csr;
3160:
3161: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Process Advanced Monies');
3162: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
3163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
3164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');

Line 3162: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');

3158: FETCH req_id_csr INTO l_request_id;
3159: CLOSE req_id_csr;
3160:
3161: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Process Advanced Monies');
3162: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
3163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
3164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
3166: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||l_contract_num);

Line 3163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);

3159: CLOSE req_id_csr;
3160:
3161: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Process Advanced Monies');
3162: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
3163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
3164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
3166: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||l_contract_num);
3167: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Customer Account Id = ' ||l_customer_acct_id);

Line 3164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

3160:
3161: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Process Advanced Monies');
3162: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
3163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
3164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
3166: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||l_contract_num);
3167: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Customer Account Id = ' ||l_customer_acct_id);
3168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

Line 3165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');

3161: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Process Advanced Monies');
3162: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
3163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
3164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
3166: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||l_contract_num);
3167: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Customer Account Id = ' ||l_customer_acct_id);
3168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3169: log_file('calling reapplic_rcpt_w_cntrct');

Line 3166: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||l_contract_num);

3162: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
3163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
3164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
3166: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||l_contract_num);
3167: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Customer Account Id = ' ||l_customer_acct_id);
3168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3169: log_file('calling reapplic_rcpt_w_cntrct');
3170: reapplic_rcpt_w_cntrct ( p_api_version => l_api_version

Line 3167: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Customer Account Id = ' ||l_customer_acct_id);

3163: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
3164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
3166: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||l_contract_num);
3167: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Customer Account Id = ' ||l_customer_acct_id);
3168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3169: log_file('calling reapplic_rcpt_w_cntrct');
3170: reapplic_rcpt_w_cntrct ( p_api_version => l_api_version
3171: ,p_init_msg_list => l_init_msg_list

Line 3168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

3164: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
3166: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||l_contract_num);
3167: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Customer Account Id = ' ||l_customer_acct_id);
3168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
3169: log_file('calling reapplic_rcpt_w_cntrct');
3170: reapplic_rcpt_w_cntrct ( p_api_version => l_api_version
3171: ,p_init_msg_list => l_init_msg_list
3172: ,x_return_status => l_return_status

Line 3180: fnd_file.put_line(fnd_file.log

3176: ,p_customer_num => l_customer_acct_id
3177: );
3178: log_file('l_return_status= '||l_return_status);
3179: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3180: fnd_file.put_line(fnd_file.log
3181: ,'Unexpected error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_RCPT_W_CNTRCT');
3182: RAISE okl_api.g_exception_unexpected_error;
3183: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3184: fnd_file.put_line(fnd_file.log

Line 3184: fnd_file.put_line(fnd_file.log

3180: fnd_file.put_line(fnd_file.log
3181: ,'Unexpected error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_RCPT_W_CNTRCT');
3182: RAISE okl_api.g_exception_unexpected_error;
3183: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3184: fnd_file.put_line(fnd_file.log
3185: ,'Error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_RCPT_W_CNTRCT');
3186: END IF;
3187:
3188:

Line 3196: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));

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));
3197: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
3198: END LOOP;
3199: END IF;
3200:

Line 3197: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');

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));
3197: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
3198: END LOOP;
3199: END IF;
3200:
3201: EXCEPTION

Line 3203: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);

3199: END IF;
3200:
3201: EXCEPTION
3202: WHEN OTHERS THEN
3203: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
3204: END;
3205: retcode := 0;
3206: EXCEPTION
3207: WHEN okl_api.g_exception_error THEN

Line 3218: fnd_file.put_line(fnd_file.log, l_data);

3214: fnd_msg_pub.get(p_msg_index => l_counter
3215: ,p_encoded => 'F'
3216: ,p_data => l_data
3217: ,p_msg_index_out => l_msg_index_out);
3218: fnd_file.put_line(fnd_file.log, l_data);
3219: END LOOP;
3220:
3221: END IF;
3222:

Line 3235: fnd_file.put_line(fnd_file.log, l_data);

3231: fnd_msg_pub.get(p_msg_index => l_counter
3232: ,p_encoded => 'F'
3233: ,p_data => l_data
3234: ,p_msg_index_out => l_msg_index_out);
3235: fnd_file.put_line(fnd_file.log, l_data);
3236: END LOOP;
3237:
3238: END IF;
3239:

Line 3253: fnd_file.put_line(fnd_file.log, l_data);

3249: fnd_msg_pub.get(p_msg_index => l_counter
3250: ,p_encoded => 'F'
3251: ,p_data => l_data
3252: ,p_msg_index_out => l_msg_index_out);
3253: fnd_file.put_line(fnd_file.log, l_data);
3254: END LOOP;
3255:
3256: END IF;
3257: fnd_file.put_line(fnd_file.log, sqlerrm);

Line 3257: fnd_file.put_line(fnd_file.log, sqlerrm);

3253: fnd_file.put_line(fnd_file.log, l_data);
3254: END LOOP;
3255:
3256: END IF;
3257: fnd_file.put_line(fnd_file.log, sqlerrm);
3258: END REAPPLIC_RCPT_W_CNTRCT_CONC;
3259: */
3260: ---------------------------------------------------------------------------
3261: -- PROCEDURE AR_advance_receipt