DBA Data[Home] [Help]

APPS.OKL_LTE_CHRG_PVT dependencies on FND_FILE

Line 632: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Start of Calculate Late Charges.');

628: END IF;
629:
630: l_init_msg_list := p_init_msg_list ;
631:
632: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Start of Calculate Late Charges.');
633:
634: SELECT FND_GLOBAL.USER_ID
635: ,FND_GLOBAL.LOGIN_ID
636: ,NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)

Line 643: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Subsequent late charges');

639: ,l_request_id
640: FROM dual;
641:
642: /* -- for bug 7295166 - start
643: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Subsequent late charges');
644: FOR l_inv_cur IN l_late_invs_cur1
645: LOOP
646: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Processing:Never Late: Receivables invoice => '||l_inv_cur.consolidated_invoice_number||
647: ' ,due date=> '||l_inv_cur.DUE_DATE||' and Amount=> '||l_inv_cur.AMOUNT_DUE_REMAINING

Line 646: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Processing:Never Late: Receivables invoice => '||l_inv_cur.consolidated_invoice_number||

642: /* -- for bug 7295166 - start
643: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Subsequent late charges');
644: FOR l_inv_cur IN l_late_invs_cur1
645: LOOP
646: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Processing:Never Late: Receivables invoice => '||l_inv_cur.consolidated_invoice_number||
647: ' ,due date=> '||l_inv_cur.DUE_DATE||' and Amount=> '||l_inv_cur.AMOUNT_DUE_REMAINING
648: ||' ,Contract => '||l_inv_cur.CONTRACT_NUMBER );
649: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Late policy => ' || l_inv_cur.late_policy
650: || ' ,Contract currency => ' || l_inv_cur.currency_code);

Line 649: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Late policy => ' || l_inv_cur.late_policy

645: LOOP
646: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Processing:Never Late: Receivables invoice => '||l_inv_cur.consolidated_invoice_number||
647: ' ,due date=> '||l_inv_cur.DUE_DATE||' and Amount=> '||l_inv_cur.AMOUNT_DUE_REMAINING
648: ||' ,Contract => '||l_inv_cur.CONTRACT_NUMBER );
649: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Late policy => ' || l_inv_cur.late_policy
650: || ' ,Contract currency => ' || l_inv_cur.currency_code);
651:
652: -- vdamerla bug 5474844
653: open l_receivables_inv_csr(l_inv_cur.CONTRACT_ID,l_inv_cur.consolidated_invoice_number);

Line 671: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '

667: ,x_msg_data => x_msg_data
668: ,x_remaining_amount => l_amt_due_remaining);
669: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
670: l_error_flag := TRUE;
671: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
672: ||l_inv_cur.contract_number
673: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);
674: ELSE
675: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Successfully fetched Consolidated Invoice Balance for contract: '

Line 675: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Successfully fetched Consolidated Invoice Balance for contract: '

671: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
672: ||l_inv_cur.contract_number
673: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);
674: ELSE
675: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Successfully fetched Consolidated Invoice Balance for contract: '
676: ||l_inv_cur.contract_number
677: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number
678: ||'Invoice Balance:'|| l_amt_due_remaining);
679: END IF;

Line 683: FND_FILE.PUT_LINE (FND_FILE.LOG, 'AR Invoice Balance => '||l_amt_due_remaining);

679: END IF;
680:
681: else
682: l_amt_due_remaining := l_inv_cur.AMOUNT_DUE_REMAINING;
683: FND_FILE.PUT_LINE (FND_FILE.LOG, 'AR Invoice Balance => '||l_amt_due_remaining);
684: end if;
685:
686: l_due_date := l_inv_cur.DUE_DATE;
687: l_khr_id := l_inv_cur.CONTRACT_ID;

Line 764: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Processing: LATE POLICY TYPE CODE => '||l_lpo_cur.LATE_POLICY_TYPE_CODE||

760: l_late_chrg_fixed_yn := l_lpo_cur.late_chrg_fixed_yn;
761: l_late_chrg_allowed_yn := l_lpo_cur.late_chrg_allowed_yn;
762: l_late_chrg_rate := l_lpo_cur.late_chrg_rate;
763:
764: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Processing: LATE POLICY TYPE CODE => '||l_lpo_cur.LATE_POLICY_TYPE_CODE||
765: ' LATE CHRG MINIMUM BALANCE=> '||l_late_chrg_minimum_balance
766: ||' ,LATE CHRG GRACE PERIOD=> '||l_lpo_cur.LATE_CHRG_GRACE_PERIOD);
767: END LOOP;
768: l_prev_late_policy := l_late_policy;

Line 784: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Calculated late charge => '||l_amount);

780: l_late_charge_amt := l_late_chrg_amount;
781: l_investor_disb_flag := 'N';
782: ELSE --IF(l_lpo_cur.LATE_CHRG_FIXED_YN = 'N') THEN
783: l_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_amt_due_remaining*(l_late_chrg_rate/100), l_contract_currency);
784: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Calculated late charge => '||l_amount);
785:
786: IF(l_amount < nvl(l_minimum_late_charge,0)) THEN
787: l_late_charge_amt := l_minimum_late_charge;
788: l_investor_disb_flag := 'N';

Line 795: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_investor_disb_flag is set to '||l_investor_disb_flag );

791: l_investor_disb_flag := 'N';
792: ELSE
793: l_late_charge_amt := l_amount;
794: l_investor_disb_flag := 'Y';
795: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_investor_disb_flag is set to '||l_investor_disb_flag );
796: END IF;
797: END IF;
798: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Applied late charge => '||l_late_charge_amt);
799: -- pgomes 12/18/2002 end, changed code to consider converted charges

Line 798: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Applied late charge => '||l_late_charge_amt);

794: l_investor_disb_flag := 'Y';
795: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_investor_disb_flag is set to '||l_investor_disb_flag );
796: END IF;
797: END IF;
798: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Applied late charge => '||l_late_charge_amt);
799: -- pgomes 12/18/2002 end, changed code to consider converted charges
800:
801:
802: ----------------------------------------------------------------

Line 816: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose LATE_FEE retrieved.');

812: x_return_status => l_return_status,
813: x_primary_sty_id => l_sty_id );
814:
815: IF (l_return_status = 'S' ) THEN
816: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose LATE_FEE retrieved.');
817: ELSE
818: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose LATE_FEE.');
819: l_error_flag := TRUE;
820: END IF;

Line 818: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose LATE_FEE.');

814:
815: IF (l_return_status = 'S' ) THEN
816: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose LATE_FEE retrieved.');
817: ELSE
818: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose LATE_FEE.');
819: l_error_flag := TRUE;
820: END IF;
821:
822:

Line 855: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating LATE FEE Stream');

851: l_stmv_rec.active_yn := 'Y';
852: l_stmv_rec.date_current := sysdate;
853: l_stmv_rec.comments := 'LATE FEE BILLING';
854:
855: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating LATE FEE Stream');
856:
857: Okl_Streams_Pub.create_streams(
858: p_api_version => p_api_version,
859: p_init_msg_list => p_init_msg_list,

Line 876: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for LATE FEE');

872:
873:
874: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
875: l_error_flag := TRUE;
876: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for LATE FEE');
877: ELSE
878: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for LATE FEE');
879: END IF;
880: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

Line 878: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for LATE FEE');

874: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
875: l_error_flag := TRUE;
876: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for LATE FEE');
877: ELSE
878: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for LATE FEE');
879: END IF;
880: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
881: ELSE
882: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');

Line 880: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

876: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for LATE FEE');
877: ELSE
878: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for LATE FEE');
879: END IF;
880: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
881: ELSE
882: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');
883: open l_stream_line_nbr_csr(l_stm_id);
884: fetch l_stream_line_nbr_csr into l_se_line_number;

Line 882: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');

878: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for LATE FEE');
879: END IF;
880: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
881: ELSE
882: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');
883: open l_stream_line_nbr_csr(l_stm_id);
884: fetch l_stream_line_nbr_csr into l_se_line_number;
885: close l_stream_line_nbr_csr;
886: l_se_line_number := nvl(l_se_line_number,0) + 1;

Line 887: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

883: open l_stream_line_nbr_csr(l_stm_id);
884: fetch l_stream_line_nbr_csr into l_se_line_number;
885: close l_stream_line_nbr_csr;
886: l_se_line_number := nvl(l_se_line_number,0) + 1;
887: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
888: END IF;
889:
890: --create stream element for late charge
891: IF (l_stm_id IS NOT NULL) THEN

Line 892: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating Stream Element for LATE FEE');

888: END IF;
889:
890: --create stream element for late charge
891: IF (l_stm_id IS NOT NULL) THEN
892: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating Stream Element for LATE FEE');
893: l_selv_rec := l_init_selv_rec;
894:
895: l_selv_rec.stm_id := l_stm_id;
896: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;

Line 934: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Stream Element for Contract: '

930: --l_sec_rec_inv_id := lx_selv_rec.source_id;
931:
932: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
933: l_error_flag := TRUE;
934: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Stream Element for Contract: '
935:
936: ||l_inv_cur.contract_number
937: ||' Stream Purpose: '||cns_late_fee
938: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE

Line 943: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Late Fee Stream Element for Contract: '

939: ||' Amount: '||l_late_charge_amt
940: ||'source_id:'||l_selv_rec.source_id);
941: ELSE
942:
943: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Late Fee Stream Element for Contract: '
944: ||l_inv_cur.contract_number
945: ||' Stream Purpose: '||cns_late_fee
946: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
947: ||' Amount: '||l_late_charge_amt

Line 955: FND_FILE.PUT_LINE (FND_FILE.LOG, '(l_late_invs_cur) l_investor_disb_flag:'||l_investor_disb_flag);

951:
952: ----------------------------------------------------------------
953: --PROCESSING FOR LATE CHARGE PAYABLE TO INVESTOR
954: ----------------------------------------------------------------
955: FND_FILE.PUT_LINE (FND_FILE.LOG, '(l_late_invs_cur) l_investor_disb_flag:'||l_investor_disb_flag);
956:
957: IF nvl(l_investor_disb_flag,'N') = 'Y' then
958: IF l_inv_cur.consolidated_invoice_id is null then
959: FOR cur_sec_strm IN c_sec_strm_AR_csr(l_inv_cur.contract_id, l_inv_cur.consolidated_invoice_number)

Line 971: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');

967: x_return_status => l_return_status,
968: x_primary_sty_id => l_sty_id );
969:
970: IF (l_return_status = 'S' ) THEN
971: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
972: ELSE
973: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE.');
974: l_error_flag := TRUE;
975: END IF;

Line 973: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE.');

969:
970: IF (l_return_status = 'S' ) THEN
971: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
972: ELSE
973: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE.');
974: l_error_flag := TRUE;
975: END IF;
976:
977: --check for stream

Line 1009: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');

1005: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1006: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1007: END IF;
1008:
1009: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1010:
1011: Okl_Streams_Pub.create_streams(
1012: p_api_version => p_api_version,
1013: p_init_msg_list => p_init_msg_list,

Line 1023: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

1019:
1020: l_stm_id := lx_stmv_rec.id;
1021: l_se_line_number := 1;
1022:
1023: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1024: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1025: l_error_flag := TRUE;
1026: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1027: ELSE

Line 1026: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');

1022:
1023: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1024: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1025: l_error_flag := TRUE;
1026: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1027: ELSE
1028: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1029: END IF;
1030: ELSE

Line 1028: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');

1024: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1025: l_error_flag := TRUE;
1026: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1027: ELSE
1028: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1029: END IF;
1030: ELSE
1031: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1032: open l_stream_line_nbr_csr(l_stm_id);

Line 1031: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');

1027: ELSE
1028: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1029: END IF;
1030: ELSE
1031: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1032: open l_stream_line_nbr_csr(l_stm_id);
1033: fetch l_stream_line_nbr_csr into l_se_line_number;
1034: close l_stream_line_nbr_csr;
1035: l_se_line_number := nvl(l_se_line_number,0) + 1;

Line 1036: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

1032: open l_stream_line_nbr_csr(l_stm_id);
1033: fetch l_stream_line_nbr_csr into l_se_line_number;
1034: close l_stream_line_nbr_csr;
1035: l_se_line_number := nvl(l_se_line_number,0) + 1;
1036: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1037: END IF;
1038:
1039: --create stream element for late charge payable
1040: IF (l_stm_id IS NOT NULL) THEN

Line 1041: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream Elements');

1037: END IF;
1038:
1039: --create stream element for late charge payable
1040: IF (l_stm_id IS NOT NULL) THEN
1041: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream Elements');
1042: l_selv_rec := l_init_selv_rec;
1043:
1044: l_selv_rec.stm_id := l_stm_id;
1045: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;

Line 1067: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '

1063: lx_selv_rec);
1064:
1065: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1066: l_error_flag := TRUE;
1067: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1068: ||l_inv_cur.contract_number
1069: ||' Stream Purpose: '||cns_late_fee
1070: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1071: ||' Amount: '||l_late_charge_amt);

Line 1074: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge Payable Stream Element for Contract: '

1070: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1071: ||' Amount: '||l_late_charge_amt);
1072: ELSE
1073:
1074: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge Payable Stream Element for Contract: '
1075: ||l_inv_cur.contract_number
1076: ||' Stream Purpose: '||cns_late_fee
1077: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1078: ||' Amount: '||l_late_charge_amt

Line 1096: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');

1092: ,date_history = SYSDATE
1093: WHERE id = l_late_stm_id;
1094:
1095: IF (SQL%NOTFOUND) THEN
1096: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1097: ELSE
1098: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1099: END IF;
1100: END IF;

Line 1098: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');

1094:
1095: IF (SQL%NOTFOUND) THEN
1096: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1097: ELSE
1098: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1099: END IF;
1100: END IF;
1101: END LOOP;
1102: END IF; -- if consolidated_invoice_id is null

Line 1117: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');

1113: x_return_status => l_return_status,
1114: x_primary_sty_id => l_sty_id );
1115:
1116: IF (l_return_status = 'S' ) THEN
1117: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1118: ELSE
1119: --Added by bkatraga for bug 5601733
1120: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE while processing Consolidated invoice => '||
1121: l_inv_cur.consolidated_INVOICE_NUMBER);

Line 1120: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE while processing Consolidated invoice => '||

1116: IF (l_return_status = 'S' ) THEN
1117: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1118: ELSE
1119: --Added by bkatraga for bug 5601733
1120: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE while processing Consolidated invoice => '||
1121: l_inv_cur.consolidated_INVOICE_NUMBER);
1122: --end bkatraga
1123: l_error_flag := TRUE;
1124: END IF;

Line 1159: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');

1155: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1156: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1157: END IF;
1158:
1159: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1160:
1161: Okl_Streams_Pub.create_streams(
1162: p_api_version => p_api_version,
1163: p_init_msg_list => p_init_msg_list,

Line 1173: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

1169:
1170: l_stm_id := lx_stmv_rec.id;
1171: l_se_line_number := 1;
1172:
1173: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1174: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1175: l_error_flag := TRUE;
1176: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1177: ELSE

Line 1176: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');

1172:
1173: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1174: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1175: l_error_flag := TRUE;
1176: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1177: ELSE
1178: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1179: END IF;
1180: ELSE

Line 1178: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');

1174: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1175: l_error_flag := TRUE;
1176: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1177: ELSE
1178: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1179: END IF;
1180: ELSE
1181: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1182: open l_stream_line_nbr_csr(l_stm_id);

Line 1181: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');

1177: ELSE
1178: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1179: END IF;
1180: ELSE
1181: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1182: open l_stream_line_nbr_csr(l_stm_id);
1183: fetch l_stream_line_nbr_csr into l_se_line_number;
1184: close l_stream_line_nbr_csr;
1185: l_se_line_number := nvl(l_se_line_number,0) + 1;

Line 1186: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

1182: open l_stream_line_nbr_csr(l_stm_id);
1183: fetch l_stream_line_nbr_csr into l_se_line_number;
1184: close l_stream_line_nbr_csr;
1185: l_se_line_number := nvl(l_se_line_number,0) + 1;
1186: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1187: END IF;
1188:
1189: --create stream element for late charge payable
1190: IF (l_stm_id IS NOT NULL) THEN

Line 1191: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream Elements');

1187: END IF;
1188:
1189: --create stream element for late charge payable
1190: IF (l_stm_id IS NOT NULL) THEN
1191: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream Elements');
1192: l_selv_rec := l_init_selv_rec;
1193: l_selv_rec.stm_id := l_stm_id;
1194: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;
1195: l_selv_rec.STREAM_ELEMENT_DATE := sysdate;

Line 1218: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '

1214: lx_selv_rec);
1215:
1216: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1217: l_error_flag := TRUE;
1218: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1219: ||l_inv_cur.contract_number
1220: ||' Stream Purpose: '||cns_late_fee
1221: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1222: ||' Amount: '||l_late_charge_amt);

Line 1225: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge Payable Stream Element for Contract: '

1221: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1222: ||' Amount: '||l_late_charge_amt);
1223: ELSE
1224:
1225: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge Payable Stream Element for Contract: '
1226: ||l_inv_cur.contract_number
1227: ||' Stream Purpose: '||cns_late_fee
1228: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1229: ||' Amount: '||l_late_charge_amt

Line 1247: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');

1243: ,date_history = SYSDATE
1244: WHERE id = l_late_stm_id;
1245:
1246: IF (SQL%NOTFOUND) THEN
1247: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1248: ELSE
1249: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1250: END IF;
1251:

Line 1249: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');

1245:
1246: IF (SQL%NOTFOUND) THEN
1247: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1248: ELSE
1249: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1250: END IF;
1251:
1252: END IF;
1253: END LOOP;

Line 1275: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');

1271: ,request_id = l_request_id
1272: WHERE CURRENT OF l_cons_lsm_cur; -- Made changes by bkatraga for bug 5601733
1273:
1274: IF (SQL%NOTFOUND) THEN
1275: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1276: ELSE
1277: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1278: END IF;
1279:

Line 1277: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');

1273:
1274: IF (SQL%NOTFOUND) THEN
1275: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1276: ELSE
1277: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1278: END IF;
1279:
1280: END LOOP;
1281: ELSE

Line 1297: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');

1293: ,request_id = l_request_id
1294: WHERE CURRENT OF l_AR_lsm_cur;
1295:
1296: IF (SQL%NOTFOUND) THEN
1297: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1298: ELSE
1299: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1300: END IF;
1301:

Line 1299: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');

1295:
1296: IF (SQL%NOTFOUND) THEN
1297: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1298: ELSE
1299: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1300: END IF;
1301:
1302: END LOOP;
1303: END IF;

Line 1334: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Processing:Already Late: Receivables invoice => '||l_inv_cur.consolidated_invoice_number||

1330: l_prev_khr_id := null; --dkagrawa bug# 4728636
1331:
1332: FOR l_inv_cur IN l_late_invs_cur
1333: LOOP
1334: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Processing:Already Late: Receivables invoice => '||l_inv_cur.consolidated_invoice_number||
1335: ' ,due date=> '||l_inv_cur.DUE_DATE||' and Amount=> '||l_inv_cur.AMOUNT_DUE_REMAINING
1336: ||' ,Contract => '||l_inv_cur.CONTRACT_NUMBER);
1337: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Late policy => ' || l_inv_cur.late_policy
1338: || ' ,Contract currency => ' || l_inv_cur.currency_code);

Line 1337: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Late policy => ' || l_inv_cur.late_policy

1333: LOOP
1334: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Processing:Already Late: Receivables invoice => '||l_inv_cur.consolidated_invoice_number||
1335: ' ,due date=> '||l_inv_cur.DUE_DATE||' and Amount=> '||l_inv_cur.AMOUNT_DUE_REMAINING
1336: ||' ,Contract => '||l_inv_cur.CONTRACT_NUMBER);
1337: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Late policy => ' || l_inv_cur.late_policy
1338: || ' ,Contract currency => ' || l_inv_cur.currency_code);
1339: -- vdamerla bug 5474844
1340: open l_receivables_inv_csr(l_inv_cur.CONTRACT_ID,l_inv_cur.consolidated_invoice_number);
1341: fetch l_receivables_inv_csr into l_rec_inv_id,l_rec_inv_contract_id;

Line 1358: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '

1354: ,x_msg_data => x_msg_data
1355: ,x_remaining_amount => l_amt_due_remaining);
1356: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1357: l_error_flag := TRUE;
1358: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
1359: ||l_inv_cur.contract_number
1360: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);
1361: ELSE
1362: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Successfully fetched Consolidated Invoice Balance for contract: '

Line 1362: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Successfully fetched Consolidated Invoice Balance for contract: '

1358: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
1359: ||l_inv_cur.contract_number
1360: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);
1361: ELSE
1362: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Successfully fetched Consolidated Invoice Balance for contract: '
1363: ||l_inv_cur.contract_number
1364: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number
1365: ||'Invoice Balance:'|| l_amt_due_remaining);
1366:

Line 1370: FND_FILE.PUT_LINE (FND_FILE.LOG,' Contract Number => '||l_inv_cur.CONTRACT_NUMBER);

1366:
1367:
1368: END IF;
1369:
1370: FND_FILE.PUT_LINE (FND_FILE.LOG,' Contract Number => '||l_inv_cur.CONTRACT_NUMBER);
1371: FND_FILE.PUT_LINE (FND_FILE.LOG,'consolidated_invoice_number => '||l_inv_cur.consolidated_invoice_number);
1372: FND_FILE.PUT_LINE (FND_FILE.LOG,'Consolidated Invoice Balance => '||l_amt_due_remaining);
1373: else
1374: l_amt_due_remaining := l_inv_cur.AMOUNT_DUE_REMAINING;

Line 1371: FND_FILE.PUT_LINE (FND_FILE.LOG,'consolidated_invoice_number => '||l_inv_cur.consolidated_invoice_number);

1367:
1368: END IF;
1369:
1370: FND_FILE.PUT_LINE (FND_FILE.LOG,' Contract Number => '||l_inv_cur.CONTRACT_NUMBER);
1371: FND_FILE.PUT_LINE (FND_FILE.LOG,'consolidated_invoice_number => '||l_inv_cur.consolidated_invoice_number);
1372: FND_FILE.PUT_LINE (FND_FILE.LOG,'Consolidated Invoice Balance => '||l_amt_due_remaining);
1373: else
1374: l_amt_due_remaining := l_inv_cur.AMOUNT_DUE_REMAINING;
1375: FND_FILE.PUT_LINE (FND_FILE.LOG, 'AR Invoice Balance => '||l_amt_due_remaining);

Line 1372: FND_FILE.PUT_LINE (FND_FILE.LOG,'Consolidated Invoice Balance => '||l_amt_due_remaining);

1368: END IF;
1369:
1370: FND_FILE.PUT_LINE (FND_FILE.LOG,' Contract Number => '||l_inv_cur.CONTRACT_NUMBER);
1371: FND_FILE.PUT_LINE (FND_FILE.LOG,'consolidated_invoice_number => '||l_inv_cur.consolidated_invoice_number);
1372: FND_FILE.PUT_LINE (FND_FILE.LOG,'Consolidated Invoice Balance => '||l_amt_due_remaining);
1373: else
1374: l_amt_due_remaining := l_inv_cur.AMOUNT_DUE_REMAINING;
1375: FND_FILE.PUT_LINE (FND_FILE.LOG, 'AR Invoice Balance => '||l_amt_due_remaining);
1376: end if;

Line 1375: FND_FILE.PUT_LINE (FND_FILE.LOG, 'AR Invoice Balance => '||l_amt_due_remaining);

1371: FND_FILE.PUT_LINE (FND_FILE.LOG,'consolidated_invoice_number => '||l_inv_cur.consolidated_invoice_number);
1372: FND_FILE.PUT_LINE (FND_FILE.LOG,'Consolidated Invoice Balance => '||l_amt_due_remaining);
1373: else
1374: l_amt_due_remaining := l_inv_cur.AMOUNT_DUE_REMAINING;
1375: FND_FILE.PUT_LINE (FND_FILE.LOG, 'AR Invoice Balance => '||l_amt_due_remaining);
1376: end if;
1377:
1378: l_due_date := l_inv_cur.DUE_DATE;
1379: l_khr_id := l_inv_cur.CONTRACT_ID;

Line 1393: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Functional currency : ' || l_func_currency || ' Contract currency : ' || l_contract_currency);

1389: FOR l_lpo_cur IN l_late_policy_cur(l_late_policy)
1390: LOOP
1391:
1392: --start code pgomes 12/18/2002
1393: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Functional currency : ' || l_func_currency || ' Contract currency : ' || l_contract_currency);
1394: IF (l_func_currency <> NVL(l_contract_currency, '000')) THEN
1395: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Converting late charge amounts from functional to contract.');
1396: --convert late_chrg_amount to contract currency
1397: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

Line 1395: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Converting late charge amounts from functional to contract.');

1391:
1392: --start code pgomes 12/18/2002
1393: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Functional currency : ' || l_func_currency || ' Contract currency : ' || l_contract_currency);
1394: IF (l_func_currency <> NVL(l_contract_currency, '000')) THEN
1395: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Converting late charge amounts from functional to contract.');
1396: --convert late_chrg_amount to contract currency
1397: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1398: p_khr_id => l_khr_id,
1399: p_from_currency => l_func_currency,

Line 1464: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Processing: LATE POLICY TYPE CODE => '||l_lpo_cur.LATE_POLICY_TYPE_CODE||

1460: l_late_chrg_allowed_yn := l_lpo_cur.late_chrg_allowed_yn;
1461: l_late_chrg_rate := l_lpo_cur.late_chrg_rate;
1462:
1463: -- pgomes 12/18/2002 start, changed code to consider converted charges
1464: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Processing: LATE POLICY TYPE CODE => '||l_lpo_cur.LATE_POLICY_TYPE_CODE||
1465: ' LATE CHRG MINIMUM BALANCE=> '||l_late_chrg_minimum_balance
1466: ||' ,LATE CHRG GRACE PERIOD=> '||l_lpo_cur.LATE_CHRG_GRACE_PERIOD);
1467:
1468: END LOOP;

Line 1484: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Calculated late charge => '||l_amount);

1480: l_late_charge_amt := l_late_chrg_amount;
1481: l_investor_disb_flag := 'N';
1482: ELSE --(l_lpo_cur.LATE_CHRG_FIXED_YN = 'N') THEN
1483: l_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_amt_due_remaining*(l_late_chrg_rate/100), l_contract_currency);
1484: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Calculated late charge => '||l_amount);
1485:
1486: IF(l_amount < nvl(l_minimum_late_charge,0)) THEN
1487: l_late_charge_amt := l_minimum_late_charge;
1488: l_investor_disb_flag := 'N';

Line 1495: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_investor_disb_flag is set to '||l_investor_disb_flag );

1491: l_investor_disb_flag := 'N';
1492: ELSE
1493: l_late_charge_amt := l_amount;
1494: l_investor_disb_flag := 'Y';
1495: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_investor_disb_flag is set to '||l_investor_disb_flag );
1496: END IF;
1497:
1498: END IF;
1499:

Line 1500: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Applied late charge => '||l_late_charge_amt);

1496: END IF;
1497:
1498: END IF;
1499:
1500: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Applied late charge => '||l_late_charge_amt);
1501: -- pgomes 12/18/2002 end, changed code to consider converted charges
1502:
1503:
1504: ----------------------------------------------------------------

Line 1518: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose LATE_FEE retrieved.');

1514: x_return_status => l_return_status,
1515: x_primary_sty_id => l_sty_id );
1516:
1517: IF (l_return_status = 'S' ) THEN
1518: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose LATE_FEE retrieved.');
1519: ELSE
1520: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose LATE_FEE.');
1521: l_error_flag := TRUE;
1522: END IF;

Line 1520: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose LATE_FEE.');

1516:
1517: IF (l_return_status = 'S' ) THEN
1518: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose LATE_FEE retrieved.');
1519: ELSE
1520: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose LATE_FEE.');
1521: l_error_flag := TRUE;
1522: END IF;
1523:
1524: --check for stream

Line 1557: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating LATE FEE Streams');

1553: l_stmv_rec.active_yn := 'Y';
1554: l_stmv_rec.date_current := sysdate;
1555: l_stmv_rec.comments := 'LATE FEE BILLING';
1556:
1557: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating LATE FEE Streams');
1558:
1559: Okl_Streams_Pub.create_streams(
1560: p_api_version => p_api_version,
1561: p_init_msg_list => p_init_msg_list,

Line 1575: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

1571: --save the parent stm id so that if creation of payable stm is unsuccessful
1572: --then the parent stm can be invalidated
1573: l_late_stm_id := l_stm_id;
1574:
1575: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1576: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1577: l_error_flag := TRUE;
1578: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for LATE FEE');
1579: ELSE

Line 1578: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for LATE FEE');

1574:
1575: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1576: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1577: l_error_flag := TRUE;
1578: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for LATE FEE');
1579: ELSE
1580: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for LATE FEE');
1581: END IF;
1582:

Line 1580: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for LATE FEE');

1576: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1577: l_error_flag := TRUE;
1578: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for LATE FEE');
1579: ELSE
1580: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for LATE FEE');
1581: END IF;
1582:
1583: ELSE
1584: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');

Line 1584: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');

1580: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for LATE FEE');
1581: END IF;
1582:
1583: ELSE
1584: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');
1585: open l_stream_line_nbr_csr(l_stm_id);
1586: fetch l_stream_line_nbr_csr into l_se_line_number;
1587: close l_stream_line_nbr_csr;
1588: l_se_line_number := nvl(l_se_line_number,0) + 1;

Line 1589: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

1585: open l_stream_line_nbr_csr(l_stm_id);
1586: fetch l_stream_line_nbr_csr into l_se_line_number;
1587: close l_stream_line_nbr_csr;
1588: l_se_line_number := nvl(l_se_line_number,0) + 1;
1589: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1590: END IF;
1591:
1592:
1593: --create stream element for late charge

Line 1632: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Stream Element for Contract: '

1628: l_sec_rec_inv_id := lx_selv_rec.source_id;
1629:
1630: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1631: l_error_flag := TRUE;
1632: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Stream Element for Contract: '
1633:
1634: ||l_inv_cur.contract_number
1635: ||' Stream Purpose: '||cns_late_fee
1636: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE

Line 1641: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Late Fee Stream Element for Contract: '

1637: ||' Amount: '||l_late_charge_amt
1638: ||'source_id:'||l_selv_rec.source_id);
1639: ELSE
1640:
1641: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Late Fee Stream Element for Contract: '
1642: ||l_inv_cur.contract_number
1643: ||' Stream Purpose: '||cns_late_fee
1644: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1645: ||' Amount: '||l_late_charge_amt

Line 1653: FND_FILE.PUT_LINE (FND_FILE.LOG, '(l_late_invs_cur1) l_investor_disb_flag:'||l_investor_disb_flag);

1649:
1650: ----------------------------------------------------------------
1651: --PROCESSING FOR LATE CHARGE PAYABLE TO INVESTOR
1652: ----------------------------------------------------------------
1653: FND_FILE.PUT_LINE (FND_FILE.LOG, '(l_late_invs_cur1) l_investor_disb_flag:'||l_investor_disb_flag);
1654: IF nvl(l_investor_disb_flag,'N') = 'Y' THEN
1655: IF l_inv_cur.consolidated_invoice_id is null then
1656: FOR cur_sec_strm IN c_sec_strm_AR_csr(l_inv_cur.contract_id, l_inv_cur.consolidated_invoice_number) LOOP
1657: --get stream type id

Line 1667: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');

1663: x_return_status => l_return_status,
1664: x_primary_sty_id => l_sty_id );
1665:
1666: IF (l_return_status = 'S' ) THEN
1667: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1668: ELSE
1669: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE.');
1670: l_error_flag := TRUE;
1671: END IF;

Line 1669: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE.');

1665:
1666: IF (l_return_status = 'S' ) THEN
1667: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1668: ELSE
1669: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE.');
1670: l_error_flag := TRUE;
1671: END IF;
1672:
1673: --check for stream

Line 1711: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Streams');

1707: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1708: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1709: END IF;
1710: -- gboomina Bug 6797000 - End
1711: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Streams');
1712:
1713: Okl_Streams_Pub.create_streams(
1714: p_api_version => p_api_version,
1715: p_init_msg_list => p_init_msg_list,

Line 1725: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

1721:
1722: l_stm_id := lx_stmv_rec.id;
1723: l_se_line_number := 1;
1724:
1725: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1726: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1727: l_error_flag := TRUE;
1728: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for INVESTOR LATE FEE PAYABLE');
1729: ELSE

Line 1728: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for INVESTOR LATE FEE PAYABLE');

1724:
1725: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1726: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1727: l_error_flag := TRUE;
1728: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for INVESTOR LATE FEE PAYABLE');
1729: ELSE
1730: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for INVESTOR LATE FEE PAYABLE');
1731: END IF;
1732: ELSE

Line 1730: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for INVESTOR LATE FEE PAYABLE');

1726: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1727: l_error_flag := TRUE;
1728: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for INVESTOR LATE FEE PAYABLE');
1729: ELSE
1730: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for INVESTOR LATE FEE PAYABLE');
1731: END IF;
1732: ELSE
1733: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1734: open l_stream_line_nbr_csr(l_stm_id);

Line 1733: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');

1729: ELSE
1730: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for INVESTOR LATE FEE PAYABLE');
1731: END IF;
1732: ELSE
1733: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1734: open l_stream_line_nbr_csr(l_stm_id);
1735: fetch l_stream_line_nbr_csr into l_se_line_number;
1736: close l_stream_line_nbr_csr;
1737: l_se_line_number := nvl(l_se_line_number,0) + 1;

Line 1738: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

1734: open l_stream_line_nbr_csr(l_stm_id);
1735: fetch l_stream_line_nbr_csr into l_se_line_number;
1736: close l_stream_line_nbr_csr;
1737: l_se_line_number := nvl(l_se_line_number,0) + 1;
1738: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1739: END IF;
1740:
1741: --create stream element for late charge payable
1742: IF (l_stm_id IS NOT NULL) THEN

Line 1776: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '

1772: lx_selv_rec);
1773:
1774: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1775: l_error_flag := TRUE;
1776: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1777: ||l_inv_cur.contract_number
1778: ||' Stream Purpose: '||cns_late_fee
1779: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1780: ||' Amount: '||l_late_charge_amt);

Line 1783: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge Payable Stream Element for Contract: '

1779: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1780: ||' Amount: '||l_late_charge_amt);
1781: ELSE
1782:
1783: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge Payable Stream Element for Contract: '
1784: ||l_inv_cur.contract_number
1785: ||' Stream Purpose: '||cns_late_fee
1786: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1787: ||' Amount: '||l_late_charge_amt

Line 1805: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');

1801: ,date_history = SYSDATE
1802: WHERE id = l_late_stm_id;
1803:
1804: IF (SQL%NOTFOUND) THEN
1805: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1806: ELSE
1807: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1808: END IF;
1809:

Line 1807: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');

1803:
1804: IF (SQL%NOTFOUND) THEN
1805: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1806: ELSE
1807: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1808: END IF;
1809:
1810: END IF;
1811:

Line 1828: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');

1824: x_return_status => l_return_status,
1825: x_primary_sty_id => l_sty_id );
1826:
1827: IF (l_return_status = 'S' ) THEN
1828: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1829: ELSE
1830: --Added by bkatraga for bug 5601733
1831: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE while processing Consolidated invoice => '||
1832: l_inv_cur.consolidated_INVOICE_NUMBER);

Line 1831: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE while processing Consolidated invoice => '||

1827: IF (l_return_status = 'S' ) THEN
1828: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1829: ELSE
1830: --Added by bkatraga for bug 5601733
1831: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE while processing Consolidated invoice => '||
1832: l_inv_cur.consolidated_INVOICE_NUMBER);
1833: --end bkatraga
1834: l_error_flag := TRUE;
1835: END IF;

Line 1870: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');

1866: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1867: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1868: END IF;
1869:
1870: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1871:
1872: Okl_Streams_Pub.create_streams(
1873: p_api_version => p_api_version,
1874: p_init_msg_list => p_init_msg_list,

Line 1884: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

1880:
1881: l_stm_id := lx_stmv_rec.id;
1882: l_se_line_number := 1;
1883:
1884: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1885: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1886: l_error_flag := TRUE;
1887: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1888: ELSE

Line 1887: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');

1883:
1884: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1885: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1886: l_error_flag := TRUE;
1887: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1888: ELSE
1889: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1890: END IF;
1891: ELSE

Line 1889: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');

1885: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1886: l_error_flag := TRUE;
1887: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1888: ELSE
1889: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1890: END IF;
1891: ELSE
1892: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1893: open l_stream_line_nbr_csr(l_stm_id);

Line 1892: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');

1888: ELSE
1889: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1890: END IF;
1891: ELSE
1892: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1893: open l_stream_line_nbr_csr(l_stm_id);
1894: fetch l_stream_line_nbr_csr into l_se_line_number;
1895: close l_stream_line_nbr_csr;
1896: l_se_line_number := nvl(l_se_line_number,0) + 1;

Line 1897: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

1893: open l_stream_line_nbr_csr(l_stm_id);
1894: fetch l_stream_line_nbr_csr into l_se_line_number;
1895: close l_stream_line_nbr_csr;
1896: l_se_line_number := nvl(l_se_line_number,0) + 1;
1897: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1898: END IF;
1899:
1900: --create stream element for late charge payable
1901: IF (l_stm_id IS NOT NULL) THEN

Line 1902: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream Elements');

1898: END IF;
1899:
1900: --create stream element for late charge payable
1901: IF (l_stm_id IS NOT NULL) THEN
1902: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream Elements');
1903: l_selv_rec := l_init_selv_rec;
1904:
1905: l_selv_rec.stm_id := l_stm_id;
1906: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;

Line 1930: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '

1926: lx_selv_rec);
1927:
1928: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1929: l_error_flag := TRUE;
1930: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1931: ||l_inv_cur.contract_number
1932: ||' Stream Purpose: '||cns_late_fee
1933: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1934: ||' Amount: '||l_late_charge_amt);

Line 1937: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge Payable Stream Element for Contract: '

1933: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1934: ||' Amount: '||l_late_charge_amt);
1935: ELSE
1936:
1937: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge Payable Stream Element for Contract: '
1938: ||l_inv_cur.contract_number
1939: ||' Stream Purpose: '||cns_late_fee
1940: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1941: ||' Amount: '||l_late_charge_amt

Line 1959: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');

1955: ,date_history = SYSDATE
1956: WHERE id = l_late_stm_id;
1957:
1958: IF (SQL%NOTFOUND) THEN
1959: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1960: ELSE
1961: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1962: END IF;
1963: END IF;

Line 1961: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');

1957:
1958: IF (SQL%NOTFOUND) THEN
1959: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1960: ELSE
1961: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1962: END IF;
1963: END IF;
1964: END LOOP;
1965: END IF; -- if consolidated_invoice_id is not null

Line 1983: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');

1979: WHERE CURRENT OF l_AR_lsm_cur;
1980:
1981: -- IF (l_return_status = Fnd_Api.G_RET_STS_SUCCESS) THEN
1982: IF (SQL%NOTFOUND) THEN
1983: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1984: ELSE
1985: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1986: END IF;
1987: -- END IF;

Line 1985: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');

1981: -- IF (l_return_status = Fnd_Api.G_RET_STS_SUCCESS) THEN
1982: IF (SQL%NOTFOUND) THEN
1983: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1984: ELSE
1985: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1986: END IF;
1987: -- END IF;
1988:
1989: END LOOP;

Line 2012: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End of Calculate charges.');

2008: END IF;
2009: --dkagrawa bug# 4728636 changes end
2010:
2011:
2012: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End of Calculate charges.');
2013: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2014: x_return_status := l_return_status;
2015:
2016: EXCEPTION

Line 2018: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (EXCP) => '||SQLERRM);

2014: x_return_status := l_return_status;
2015:
2016: EXCEPTION
2017: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2018: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (EXCP) => '||SQLERRM);
2019: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2020: (
2021: l_api_name,
2022: G_PKG_NAME,

Line 2029: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (UNEXCP) => '||SQLERRM);

2025: x_msg_data,
2026: '_PVT'
2027: );
2028: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2029: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (UNEXCP) => '||SQLERRM);
2030: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2031: (
2032: l_api_name,
2033: G_PKG_NAME,

Line 2040: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (Other) => '||SQLERRM);

2036: x_msg_data,
2037: '_PVT'
2038: );
2039: WHEN OTHERS THEN
2040: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (Other) => '||SQLERRM);
2041: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2042: (
2043: l_api_name,
2044: G_PKG_NAME,