DBA Data[Home] [Help]

APPS.OKL_LTE_CHRG_PVT dependencies on FND_FILE

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

623: END IF;
624:
625: l_init_msg_list := p_init_msg_list ;
626:
627: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Start of Calculate Late Charges.');
628:
629: SELECT FND_GLOBAL.USER_ID
630: ,FND_GLOBAL.LOGIN_ID
631: ,NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)

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

635: FROM dual;
636:
637: FOR l_inv_cur IN l_late_invs_cur1
638: LOOP
639: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Processing:Never Late: Receivables invoice => '||l_inv_cur.consolidated_invoice_number||
640: ' ,due date=> '||l_inv_cur.DUE_DATE||' and Amount=> '||l_inv_cur.AMOUNT_DUE_REMAINING
641: ||' ,Contract => '||l_inv_cur.CONTRACT_NUMBER );
642: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Late policy => ' || l_inv_cur.late_policy
643: || ' ,Contract currency => ' || l_inv_cur.currency_code);

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

638: LOOP
639: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Processing:Never Late: Receivables invoice => '||l_inv_cur.consolidated_invoice_number||
640: ' ,due date=> '||l_inv_cur.DUE_DATE||' and Amount=> '||l_inv_cur.AMOUNT_DUE_REMAINING
641: ||' ,Contract => '||l_inv_cur.CONTRACT_NUMBER );
642: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Late policy => ' || l_inv_cur.late_policy
643: || ' ,Contract currency => ' || l_inv_cur.currency_code);
644:
645: -- vdamerla bug 5474844
646: open l_receivables_inv_csr(l_inv_cur.CONTRACT_ID,l_inv_cur.consolidated_invoice_number);

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

660: ,x_msg_data => x_msg_data
661: ,x_remaining_amount => l_amt_due_remaining);
662: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
663: l_error_flag := TRUE;
664: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
665: ||l_inv_cur.contract_number
666: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);
667: ELSE
668: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Successfully fetched Consolidated Invoice Balance for contract: '

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

664: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
665: ||l_inv_cur.contract_number
666: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);
667: ELSE
668: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Successfully fetched Consolidated Invoice Balance for contract: '
669: ||l_inv_cur.contract_number
670: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number
671: ||'Invoice Balance:'|| l_amt_due_remaining);
672: END IF;

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

672: END IF;
673:
674: else
675: l_amt_due_remaining := l_inv_cur.AMOUNT_DUE_REMAINING;
676: FND_FILE.PUT_LINE (FND_FILE.LOG, 'AR Invoice Balance => '||l_amt_due_remaining);
677: end if;
678:
679: l_due_date := l_inv_cur.DUE_DATE;
680: l_khr_id := l_inv_cur.CONTRACT_ID;

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

753: l_late_chrg_fixed_yn := l_lpo_cur.late_chrg_fixed_yn;
754: l_late_chrg_allowed_yn := l_lpo_cur.late_chrg_allowed_yn;
755: l_late_chrg_rate := l_lpo_cur.late_chrg_rate;
756:
757: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Processing: LATE POLICY TYPE CODE => '||l_lpo_cur.LATE_POLICY_TYPE_CODE||
758: ' LATE CHRG MINIMUM BALANCE=> '||l_late_chrg_minimum_balance
759: ||' ,LATE CHRG GRACE PERIOD=> '||l_lpo_cur.LATE_CHRG_GRACE_PERIOD);
760: END LOOP;
761: l_prev_late_policy := l_late_policy;

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

773: l_late_charge_amt := l_late_chrg_amount;
774: l_investor_disb_flag := 'N';
775: ELSE --IF(l_lpo_cur.LATE_CHRG_FIXED_YN = 'N') THEN
776: l_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_amt_due_remaining*(l_late_chrg_rate/100), l_contract_currency);
777: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Calculated late charge => '||l_amount);
778:
779: IF(l_amount < nvl(l_minimum_late_charge,0)) THEN
780: l_late_charge_amt := l_minimum_late_charge;
781: l_investor_disb_flag := 'N';

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

784: l_investor_disb_flag := 'N';
785: ELSE
786: l_late_charge_amt := l_amount;
787: l_investor_disb_flag := 'Y';
788: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_investor_disb_flag is set to '||l_investor_disb_flag );
789: END IF;
790: END IF;
791: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Applied late charge => '||l_late_charge_amt);
792: -- pgomes 12/18/2002 end, changed code to consider converted charges

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

787: l_investor_disb_flag := 'Y';
788: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_investor_disb_flag is set to '||l_investor_disb_flag );
789: END IF;
790: END IF;
791: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Applied late charge => '||l_late_charge_amt);
792: -- pgomes 12/18/2002 end, changed code to consider converted charges
793:
794:
795: ----------------------------------------------------------------

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

805: x_return_status => l_return_status,
806: x_primary_sty_id => l_sty_id );
807:
808: IF (l_return_status = 'S' ) THEN
809: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose LATE_FEE retrieved.');
810: ELSE
811: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose LATE_FEE.');
812: l_error_flag := TRUE;
813: END IF;

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

807:
808: IF (l_return_status = 'S' ) THEN
809: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose LATE_FEE retrieved.');
810: ELSE
811: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose LATE_FEE.');
812: l_error_flag := TRUE;
813: END IF;
814:
815:

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

844: l_stmv_rec.active_yn := 'Y';
845: l_stmv_rec.date_current := sysdate;
846: l_stmv_rec.comments := 'LATE FEE BILLING';
847:
848: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating LATE FEE Stream');
849:
850: Okl_Streams_Pub.create_streams(
851: p_api_version => p_api_version,
852: p_init_msg_list => p_init_msg_list,

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

865:
866:
867: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
868: l_error_flag := TRUE;
869: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for LATE FEE');
870: ELSE
871: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for LATE FEE');
872: END IF;
873: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);

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

867: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
868: l_error_flag := TRUE;
869: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for LATE FEE');
870: ELSE
871: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for LATE FEE');
872: END IF;
873: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
874: ELSE
875: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');

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

869: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for LATE FEE');
870: ELSE
871: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for LATE FEE');
872: END IF;
873: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
874: ELSE
875: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');
876: open l_stream_line_nbr_csr(l_stm_id);
877: fetch l_stream_line_nbr_csr into l_se_line_number;

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

871: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for LATE FEE');
872: END IF;
873: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
874: ELSE
875: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');
876: open l_stream_line_nbr_csr(l_stm_id);
877: fetch l_stream_line_nbr_csr into l_se_line_number;
878: close l_stream_line_nbr_csr;
879: l_se_line_number := nvl(l_se_line_number,0) + 1;

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

876: open l_stream_line_nbr_csr(l_stm_id);
877: fetch l_stream_line_nbr_csr into l_se_line_number;
878: close l_stream_line_nbr_csr;
879: l_se_line_number := nvl(l_se_line_number,0) + 1;
880: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
881: END IF;
882:
883: --create stream element for late charge
884: IF (l_stm_id IS NOT NULL) THEN

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

881: END IF;
882:
883: --create stream element for late charge
884: IF (l_stm_id IS NOT NULL) THEN
885: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating Stream Element for LATE FEE');
886: l_selv_rec := l_init_selv_rec;
887:
888: l_selv_rec.stm_id := l_stm_id;
889: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;

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

923: --l_sec_rec_inv_id := lx_selv_rec.source_id;
924:
925: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
926: l_error_flag := TRUE;
927: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Stream Element for Contract: '
928:
929: ||l_inv_cur.contract_number
930: ||' Stream Purpose: '||cns_late_fee
931: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE

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

932: ||' Amount: '||l_late_charge_amt
933: ||'source_id:'||l_selv_rec.source_id);
934: ELSE
935:
936: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Late Fee Stream Element for Contract: '
937: ||l_inv_cur.contract_number
938: ||' Stream Purpose: '||cns_late_fee
939: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
940: ||' Amount: '||l_late_charge_amt

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

944:
945: ----------------------------------------------------------------
946: --PROCESSING FOR LATE CHARGE PAYABLE TO INVESTOR
947: ----------------------------------------------------------------
948: FND_FILE.PUT_LINE (FND_FILE.LOG, '(l_late_invs_cur) l_investor_disb_flag:'||l_investor_disb_flag);
949:
950: IF nvl(l_investor_disb_flag,'N') = 'Y' then
951: IF l_inv_cur.consolidated_invoice_id is null then
952: FOR cur_sec_strm IN c_sec_strm_AR_csr(l_inv_cur.contract_id, l_inv_cur.consolidated_invoice_number)

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

960: x_return_status => l_return_status,
961: x_primary_sty_id => l_sty_id );
962:
963: IF (l_return_status = 'S' ) THEN
964: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
965: ELSE
966: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE.');
967: l_error_flag := TRUE;
968: END IF;

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

962:
963: IF (l_return_status = 'S' ) THEN
964: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
965: ELSE
966: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE.');
967: l_error_flag := TRUE;
968: END IF;
969:
970: --check for stream

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

998: l_stmv_rec.source_id := cur_sec_strm.khr_id;
999: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1000: END IF;
1001:
1002: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1003:
1004: Okl_Streams_Pub.create_streams(
1005: p_api_version => p_api_version,
1006: p_init_msg_list => p_init_msg_list,

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

1012:
1013: l_stm_id := lx_stmv_rec.id;
1014: l_se_line_number := 1;
1015:
1016: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1017: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1018: l_error_flag := TRUE;
1019: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1020: ELSE

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

1015:
1016: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1017: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1018: l_error_flag := TRUE;
1019: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1020: ELSE
1021: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1022: END IF;
1023: ELSE

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

1017: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1018: l_error_flag := TRUE;
1019: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1020: ELSE
1021: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1022: END IF;
1023: ELSE
1024: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1025: open l_stream_line_nbr_csr(l_stm_id);

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

1020: ELSE
1021: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1022: END IF;
1023: ELSE
1024: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1025: open l_stream_line_nbr_csr(l_stm_id);
1026: fetch l_stream_line_nbr_csr into l_se_line_number;
1027: close l_stream_line_nbr_csr;
1028: l_se_line_number := nvl(l_se_line_number,0) + 1;

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

1025: open l_stream_line_nbr_csr(l_stm_id);
1026: fetch l_stream_line_nbr_csr into l_se_line_number;
1027: close l_stream_line_nbr_csr;
1028: l_se_line_number := nvl(l_se_line_number,0) + 1;
1029: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1030: END IF;
1031:
1032: --create stream element for late charge payable
1033: IF (l_stm_id IS NOT NULL) THEN

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

1030: END IF;
1031:
1032: --create stream element for late charge payable
1033: IF (l_stm_id IS NOT NULL) THEN
1034: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream Elements');
1035: l_selv_rec := l_init_selv_rec;
1036:
1037: l_selv_rec.stm_id := l_stm_id;
1038: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;

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

1056: lx_selv_rec);
1057:
1058: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1059: l_error_flag := TRUE;
1060: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1061: ||l_inv_cur.contract_number
1062: ||' Stream Purpose: '||cns_late_fee
1063: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1064: ||' Amount: '||l_late_charge_amt);

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

1063: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1064: ||' Amount: '||l_late_charge_amt);
1065: ELSE
1066:
1067: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge 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 1089: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');

1085: ,date_history = SYSDATE
1086: WHERE id = l_late_stm_id;
1087:
1088: IF (SQL%NOTFOUND) THEN
1089: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1090: ELSE
1091: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1092: END IF;
1093: END IF;

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

1087:
1088: IF (SQL%NOTFOUND) THEN
1089: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1090: ELSE
1091: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1092: END IF;
1093: END IF;
1094: END LOOP;
1095: END IF; -- if consolidated_invoice_id is null

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

1106: x_return_status => l_return_status,
1107: x_primary_sty_id => l_sty_id );
1108:
1109: IF (l_return_status = 'S' ) THEN
1110: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1111: ELSE
1112: --Added by bkatraga for bug 5601733
1113: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE while processing Consolidated invoice => '||
1114: l_inv_cur.consolidated_INVOICE_NUMBER);

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

1109: IF (l_return_status = 'S' ) THEN
1110: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1111: ELSE
1112: --Added by bkatraga for bug 5601733
1113: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE while processing Consolidated invoice => '||
1114: l_inv_cur.consolidated_INVOICE_NUMBER);
1115: --end bkatraga
1116: l_error_flag := TRUE;
1117: END IF;

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

1148: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1149: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1150: END IF;
1151:
1152: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1153:
1154: Okl_Streams_Pub.create_streams(
1155: p_api_version => p_api_version,
1156: p_init_msg_list => p_init_msg_list,

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

1162:
1163: l_stm_id := lx_stmv_rec.id;
1164: l_se_line_number := 1;
1165:
1166: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1167: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1168: l_error_flag := TRUE;
1169: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1170: ELSE

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

1165:
1166: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1167: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1168: l_error_flag := TRUE;
1169: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1170: ELSE
1171: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1172: END IF;
1173: ELSE

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

1167: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1168: l_error_flag := TRUE;
1169: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1170: ELSE
1171: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1172: END IF;
1173: ELSE
1174: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1175: open l_stream_line_nbr_csr(l_stm_id);

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

1170: ELSE
1171: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1172: END IF;
1173: ELSE
1174: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1175: open l_stream_line_nbr_csr(l_stm_id);
1176: fetch l_stream_line_nbr_csr into l_se_line_number;
1177: close l_stream_line_nbr_csr;
1178: l_se_line_number := nvl(l_se_line_number,0) + 1;

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

1175: open l_stream_line_nbr_csr(l_stm_id);
1176: fetch l_stream_line_nbr_csr into l_se_line_number;
1177: close l_stream_line_nbr_csr;
1178: l_se_line_number := nvl(l_se_line_number,0) + 1;
1179: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1180: END IF;
1181:
1182: --create stream element for late charge payable
1183: IF (l_stm_id IS NOT NULL) THEN

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

1180: END IF;
1181:
1182: --create stream element for late charge payable
1183: IF (l_stm_id IS NOT NULL) THEN
1184: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream Elements');
1185: l_selv_rec := l_init_selv_rec;
1186: l_selv_rec.stm_id := l_stm_id;
1187: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;
1188: l_selv_rec.STREAM_ELEMENT_DATE := sysdate;

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

1207: lx_selv_rec);
1208:
1209: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1210: l_error_flag := TRUE;
1211: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1212: ||l_inv_cur.contract_number
1213: ||' Stream Purpose: '||cns_late_fee
1214: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1215: ||' Amount: '||l_late_charge_amt);

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

1214: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1215: ||' Amount: '||l_late_charge_amt);
1216: ELSE
1217:
1218: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge 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 1240: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');

1236: ,date_history = SYSDATE
1237: WHERE id = l_late_stm_id;
1238:
1239: IF (SQL%NOTFOUND) THEN
1240: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1241: ELSE
1242: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1243: END IF;
1244:

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

1238:
1239: IF (SQL%NOTFOUND) THEN
1240: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1241: ELSE
1242: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1243: END IF;
1244:
1245: END IF;
1246: END LOOP;

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

1264: ,request_id = l_request_id
1265: WHERE CURRENT OF l_cons_lsm_cur; -- Made changes by bkatraga for bug 5601733
1266:
1267: IF (SQL%NOTFOUND) THEN
1268: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1269: ELSE
1270: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1271: END IF;
1272:

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

1266:
1267: IF (SQL%NOTFOUND) THEN
1268: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1269: ELSE
1270: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1271: END IF;
1272:
1273: END LOOP;
1274: ELSE

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

1286: ,request_id = l_request_id
1287: WHERE CURRENT OF l_AR_lsm_cur;
1288:
1289: IF (SQL%NOTFOUND) THEN
1290: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1291: ELSE
1292: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1293: END IF;
1294:

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

1288:
1289: IF (SQL%NOTFOUND) THEN
1290: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1291: ELSE
1292: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1293: END IF;
1294:
1295: END LOOP;
1296: END IF;

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

1322: l_prev_khr_id := null; --dkagrawa bug# 4728636
1323:
1324: FOR l_inv_cur IN l_late_invs_cur
1325: LOOP
1326: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Processing:Already Late: Receivables invoice => '||l_inv_cur.consolidated_invoice_number||
1327: ' ,due date=> '||l_inv_cur.DUE_DATE||' and Amount=> '||l_inv_cur.AMOUNT_DUE_REMAINING
1328: ||' ,Contract => '||l_inv_cur.CONTRACT_NUMBER);
1329: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Late policy => ' || l_inv_cur.late_policy
1330: || ' ,Contract currency => ' || l_inv_cur.currency_code);

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

1325: LOOP
1326: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Processing:Already Late: Receivables invoice => '||l_inv_cur.consolidated_invoice_number||
1327: ' ,due date=> '||l_inv_cur.DUE_DATE||' and Amount=> '||l_inv_cur.AMOUNT_DUE_REMAINING
1328: ||' ,Contract => '||l_inv_cur.CONTRACT_NUMBER);
1329: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Late policy => ' || l_inv_cur.late_policy
1330: || ' ,Contract currency => ' || l_inv_cur.currency_code);
1331: -- vdamerla bug 5474844
1332: open l_receivables_inv_csr(l_inv_cur.CONTRACT_ID,l_inv_cur.consolidated_invoice_number);
1333: fetch l_receivables_inv_csr into l_rec_inv_id,l_rec_inv_contract_id;

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

1346: ,x_msg_data => x_msg_data
1347: ,x_remaining_amount => l_amt_due_remaining);
1348: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1349: l_error_flag := TRUE;
1350: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
1351: ||l_inv_cur.contract_number
1352: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);
1353: ELSE
1354: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Successfully fetched Consolidated Invoice Balance for contract: '

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

1350: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
1351: ||l_inv_cur.contract_number
1352: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);
1353: ELSE
1354: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Successfully fetched Consolidated Invoice Balance for contract: '
1355: ||l_inv_cur.contract_number
1356: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number
1357: ||'Invoice Balance:'|| l_amt_due_remaining);
1358:

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

1358:
1359:
1360: END IF;
1361:
1362: FND_FILE.PUT_LINE (FND_FILE.LOG,' Contract Number => '||l_inv_cur.CONTRACT_NUMBER);
1363: FND_FILE.PUT_LINE (FND_FILE.LOG,'consolidated_invoice_number => '||l_inv_cur.consolidated_invoice_number);
1364: FND_FILE.PUT_LINE (FND_FILE.LOG,'Consolidated Invoice Balance => '||l_amt_due_remaining);
1365: else
1366: l_amt_due_remaining := l_inv_cur.AMOUNT_DUE_REMAINING;

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

1359:
1360: END IF;
1361:
1362: FND_FILE.PUT_LINE (FND_FILE.LOG,' Contract Number => '||l_inv_cur.CONTRACT_NUMBER);
1363: FND_FILE.PUT_LINE (FND_FILE.LOG,'consolidated_invoice_number => '||l_inv_cur.consolidated_invoice_number);
1364: FND_FILE.PUT_LINE (FND_FILE.LOG,'Consolidated Invoice Balance => '||l_amt_due_remaining);
1365: else
1366: l_amt_due_remaining := l_inv_cur.AMOUNT_DUE_REMAINING;
1367: FND_FILE.PUT_LINE (FND_FILE.LOG, 'AR Invoice Balance => '||l_amt_due_remaining);

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

1360: END IF;
1361:
1362: FND_FILE.PUT_LINE (FND_FILE.LOG,' Contract Number => '||l_inv_cur.CONTRACT_NUMBER);
1363: FND_FILE.PUT_LINE (FND_FILE.LOG,'consolidated_invoice_number => '||l_inv_cur.consolidated_invoice_number);
1364: FND_FILE.PUT_LINE (FND_FILE.LOG,'Consolidated Invoice Balance => '||l_amt_due_remaining);
1365: else
1366: l_amt_due_remaining := l_inv_cur.AMOUNT_DUE_REMAINING;
1367: FND_FILE.PUT_LINE (FND_FILE.LOG, 'AR Invoice Balance => '||l_amt_due_remaining);
1368: end if;

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

1363: FND_FILE.PUT_LINE (FND_FILE.LOG,'consolidated_invoice_number => '||l_inv_cur.consolidated_invoice_number);
1364: FND_FILE.PUT_LINE (FND_FILE.LOG,'Consolidated Invoice Balance => '||l_amt_due_remaining);
1365: else
1366: l_amt_due_remaining := l_inv_cur.AMOUNT_DUE_REMAINING;
1367: FND_FILE.PUT_LINE (FND_FILE.LOG, 'AR Invoice Balance => '||l_amt_due_remaining);
1368: end if;
1369:
1370: l_due_date := l_inv_cur.DUE_DATE;
1371: l_khr_id := l_inv_cur.CONTRACT_ID;

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

1381: FOR l_lpo_cur IN l_late_policy_cur(l_late_policy)
1382: LOOP
1383:
1384: --start code pgomes 12/18/2002
1385: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Functional currency : ' || l_func_currency || ' Contract currency : ' || l_contract_currency);
1386: IF (l_func_currency <> NVL(l_contract_currency, '000')) THEN
1387: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Converting late charge amounts from functional to contract.');
1388: --convert late_chrg_amount to contract currency
1389: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

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

1383:
1384: --start code pgomes 12/18/2002
1385: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Functional currency : ' || l_func_currency || ' Contract currency : ' || l_contract_currency);
1386: IF (l_func_currency <> NVL(l_contract_currency, '000')) THEN
1387: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Converting late charge amounts from functional to contract.');
1388: --convert late_chrg_amount to contract currency
1389: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1390: p_khr_id => l_khr_id,
1391: p_from_currency => l_func_currency,

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

1452: l_late_chrg_allowed_yn := l_lpo_cur.late_chrg_allowed_yn;
1453: l_late_chrg_rate := l_lpo_cur.late_chrg_rate;
1454:
1455: -- pgomes 12/18/2002 start, changed code to consider converted charges
1456: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Processing: LATE POLICY TYPE CODE => '||l_lpo_cur.LATE_POLICY_TYPE_CODE||
1457: ' LATE CHRG MINIMUM BALANCE=> '||l_late_chrg_minimum_balance
1458: ||' ,LATE CHRG GRACE PERIOD=> '||l_lpo_cur.LATE_CHRG_GRACE_PERIOD);
1459:
1460: END LOOP;

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

1472: l_late_charge_amt := l_late_chrg_amount;
1473: l_investor_disb_flag := 'N';
1474: ELSE --(l_lpo_cur.LATE_CHRG_FIXED_YN = 'N') THEN
1475: l_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_amt_due_remaining*(l_late_chrg_rate/100), l_contract_currency);
1476: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Calculated late charge => '||l_amount);
1477:
1478: IF(l_amount < nvl(l_minimum_late_charge,0)) THEN
1479: l_late_charge_amt := l_minimum_late_charge;
1480: l_investor_disb_flag := 'N';

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

1483: l_investor_disb_flag := 'N';
1484: ELSE
1485: l_late_charge_amt := l_amount;
1486: l_investor_disb_flag := 'Y';
1487: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_investor_disb_flag is set to '||l_investor_disb_flag );
1488: END IF;
1489:
1490: END IF;
1491:

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

1488: END IF;
1489:
1490: END IF;
1491:
1492: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Applied late charge => '||l_late_charge_amt);
1493: -- pgomes 12/18/2002 end, changed code to consider converted charges
1494:
1495:
1496: ----------------------------------------------------------------

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

1506: x_return_status => l_return_status,
1507: x_primary_sty_id => l_sty_id );
1508:
1509: IF (l_return_status = 'S' ) THEN
1510: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose LATE_FEE retrieved.');
1511: ELSE
1512: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose LATE_FEE.');
1513: l_error_flag := TRUE;
1514: END IF;

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

1508:
1509: IF (l_return_status = 'S' ) THEN
1510: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose LATE_FEE retrieved.');
1511: ELSE
1512: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose LATE_FEE.');
1513: l_error_flag := TRUE;
1514: END IF;
1515:
1516: --check for stream

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

1545: l_stmv_rec.active_yn := 'Y';
1546: l_stmv_rec.date_current := sysdate;
1547: l_stmv_rec.comments := 'LATE FEE BILLING';
1548:
1549: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating LATE FEE Streams');
1550:
1551: Okl_Streams_Pub.create_streams(
1552: p_api_version => p_api_version,
1553: p_init_msg_list => p_init_msg_list,

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

1563: --save the parent stm id so that if creation of payable stm is unsuccessful
1564: --then the parent stm can be invalidated
1565: l_late_stm_id := l_stm_id;
1566:
1567: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1568: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1569: l_error_flag := TRUE;
1570: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for LATE FEE');
1571: ELSE

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

1566:
1567: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1568: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1569: l_error_flag := TRUE;
1570: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for LATE FEE');
1571: ELSE
1572: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for LATE FEE');
1573: END IF;
1574:

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

1568: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1569: l_error_flag := TRUE;
1570: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for LATE FEE');
1571: ELSE
1572: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for LATE FEE');
1573: END IF;
1574:
1575: ELSE
1576: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');

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

1572: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for LATE FEE');
1573: END IF;
1574:
1575: ELSE
1576: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for LATE FEE found');
1577: open l_stream_line_nbr_csr(l_stm_id);
1578: fetch l_stream_line_nbr_csr into l_se_line_number;
1579: close l_stream_line_nbr_csr;
1580: l_se_line_number := nvl(l_se_line_number,0) + 1;

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

1577: open l_stream_line_nbr_csr(l_stm_id);
1578: fetch l_stream_line_nbr_csr into l_se_line_number;
1579: close l_stream_line_nbr_csr;
1580: l_se_line_number := nvl(l_se_line_number,0) + 1;
1581: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1582: END IF;
1583:
1584:
1585: --create stream element for late charge

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

1620: l_sec_rec_inv_id := lx_selv_rec.source_id;
1621:
1622: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1623: l_error_flag := TRUE;
1624: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Stream Element for Contract: '
1625:
1626: ||l_inv_cur.contract_number
1627: ||' Stream Purpose: '||cns_late_fee
1628: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE

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

1629: ||' Amount: '||l_late_charge_amt
1630: ||'source_id:'||l_selv_rec.source_id);
1631: ELSE
1632:
1633: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Late Fee Stream Element for Contract: '
1634: ||l_inv_cur.contract_number
1635: ||' Stream Purpose: '||cns_late_fee
1636: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1637: ||' Amount: '||l_late_charge_amt

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

1641:
1642: ----------------------------------------------------------------
1643: --PROCESSING FOR LATE CHARGE PAYABLE TO INVESTOR
1644: ----------------------------------------------------------------
1645: FND_FILE.PUT_LINE (FND_FILE.LOG, '(l_late_invs_cur1) l_investor_disb_flag:'||l_investor_disb_flag);
1646: IF nvl(l_investor_disb_flag,'N') = 'Y' THEN
1647: IF l_inv_cur.consolidated_invoice_id is null then
1648: FOR cur_sec_strm IN c_sec_strm_AR_csr(l_inv_cur.contract_id, l_inv_cur.consolidated_invoice_number) LOOP
1649: --get stream type id

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

1655: x_return_status => l_return_status,
1656: x_primary_sty_id => l_sty_id );
1657:
1658: IF (l_return_status = 'S' ) THEN
1659: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1660: ELSE
1661: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE.');
1662: l_error_flag := TRUE;
1663: END IF;

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

1657:
1658: IF (l_return_status = 'S' ) THEN
1659: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1660: ELSE
1661: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE.');
1662: l_error_flag := TRUE;
1663: END IF;
1664:
1665: --check for stream

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

1699: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1700: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1701: END IF;
1702: -- gboomina Bug 6797000 - End
1703: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Streams');
1704:
1705: Okl_Streams_Pub.create_streams(
1706: p_api_version => p_api_version,
1707: p_init_msg_list => p_init_msg_list,

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

1713:
1714: l_stm_id := lx_stmv_rec.id;
1715: l_se_line_number := 1;
1716:
1717: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1718: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1719: l_error_flag := TRUE;
1720: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for INVESTOR LATE FEE PAYABLE');
1721: ELSE

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

1716:
1717: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1718: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1719: l_error_flag := TRUE;
1720: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for INVESTOR LATE FEE PAYABLE');
1721: ELSE
1722: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for INVESTOR LATE FEE PAYABLE');
1723: END IF;
1724: ELSE

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

1718: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1719: l_error_flag := TRUE;
1720: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for INVESTOR LATE FEE PAYABLE');
1721: ELSE
1722: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for INVESTOR LATE FEE PAYABLE');
1723: END IF;
1724: ELSE
1725: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1726: open l_stream_line_nbr_csr(l_stm_id);

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

1721: ELSE
1722: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for INVESTOR LATE FEE PAYABLE');
1723: END IF;
1724: ELSE
1725: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1726: open l_stream_line_nbr_csr(l_stm_id);
1727: fetch l_stream_line_nbr_csr into l_se_line_number;
1728: close l_stream_line_nbr_csr;
1729: l_se_line_number := nvl(l_se_line_number,0) + 1;

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

1726: open l_stream_line_nbr_csr(l_stm_id);
1727: fetch l_stream_line_nbr_csr into l_se_line_number;
1728: close l_stream_line_nbr_csr;
1729: l_se_line_number := nvl(l_se_line_number,0) + 1;
1730: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1731: END IF;
1732:
1733: --create stream element for late charge payable
1734: IF (l_stm_id IS NOT NULL) THEN

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

1764: lx_selv_rec);
1765:
1766: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1767: l_error_flag := TRUE;
1768: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1769: ||l_inv_cur.contract_number
1770: ||' Stream Purpose: '||cns_late_fee
1771: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1772: ||' Amount: '||l_late_charge_amt);

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

1771: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1772: ||' Amount: '||l_late_charge_amt);
1773: ELSE
1774:
1775: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge Payable Stream Element for Contract: '
1776: ||l_inv_cur.contract_number
1777: ||' Stream Purpose: '||cns_late_fee
1778: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1779: ||' Amount: '||l_late_charge_amt

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

1793: ,date_history = SYSDATE
1794: WHERE id = l_late_stm_id;
1795:
1796: IF (SQL%NOTFOUND) THEN
1797: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1798: ELSE
1799: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1800: END IF;
1801:

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

1795:
1796: IF (SQL%NOTFOUND) THEN
1797: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1798: ELSE
1799: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1800: END IF;
1801:
1802: END IF;
1803:

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

1816: x_return_status => l_return_status,
1817: x_primary_sty_id => l_sty_id );
1818:
1819: IF (l_return_status = 'S' ) THEN
1820: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1821: ELSE
1822: --Added by bkatraga for bug 5601733
1823: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE while processing Consolidated invoice => '||
1824: l_inv_cur.consolidated_INVOICE_NUMBER);

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

1819: IF (l_return_status = 'S' ) THEN
1820: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE retrieved.');
1821: ELSE
1822: --Added by bkatraga for bug 5601733
1823: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose INVESTOR_LATE_FEE_PAYABLE while processing Consolidated invoice => '||
1824: l_inv_cur.consolidated_INVOICE_NUMBER);
1825: --end bkatraga
1826: l_error_flag := TRUE;
1827: END IF;

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

1858: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1859: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1860: END IF;
1861:
1862: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1863:
1864: Okl_Streams_Pub.create_streams(
1865: p_api_version => p_api_version,
1866: p_init_msg_list => p_init_msg_list,

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

1872:
1873: l_stm_id := lx_stmv_rec.id;
1874: l_se_line_number := 1;
1875:
1876: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1877: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1878: l_error_flag := TRUE;
1879: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1880: ELSE

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

1875:
1876: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1877: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1878: l_error_flag := TRUE;
1879: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1880: ELSE
1881: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1882: END IF;
1883: ELSE

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

1877: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1878: l_error_flag := TRUE;
1879: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1880: ELSE
1881: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1882: END IF;
1883: ELSE
1884: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1885: open l_stream_line_nbr_csr(l_stm_id);

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

1880: ELSE
1881: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');
1882: END IF;
1883: ELSE
1884: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream for INVESTOR LATE FEE PAYABLE found');
1885: open l_stream_line_nbr_csr(l_stm_id);
1886: fetch l_stream_line_nbr_csr into l_se_line_number;
1887: close l_stream_line_nbr_csr;
1888: l_se_line_number := nvl(l_se_line_number,0) + 1;

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

1885: open l_stream_line_nbr_csr(l_stm_id);
1886: fetch l_stream_line_nbr_csr into l_se_line_number;
1887: close l_stream_line_nbr_csr;
1888: l_se_line_number := nvl(l_se_line_number,0) + 1;
1889: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1890: END IF;
1891:
1892: --create stream element for late charge payable
1893: IF (l_stm_id IS NOT NULL) THEN

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

1890: END IF;
1891:
1892: --create stream element for late charge payable
1893: IF (l_stm_id IS NOT NULL) THEN
1894: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream Elements');
1895: l_selv_rec := l_init_selv_rec;
1896:
1897: l_selv_rec.stm_id := l_stm_id;
1898: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;

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

1918: lx_selv_rec);
1919:
1920: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1921: l_error_flag := TRUE;
1922: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1923: ||l_inv_cur.contract_number
1924: ||' Stream Purpose: '||cns_late_fee
1925: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1926: ||' Amount: '||l_late_charge_amt);

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

1925: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1926: ||' Amount: '||l_late_charge_amt);
1927: ELSE
1928:
1929: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Created Investor Late Charge Payable Stream Element for Contract: '
1930: ||l_inv_cur.contract_number
1931: ||' Stream Purpose: '||cns_late_fee
1932: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1933: ||' Amount: '||l_late_charge_amt

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

1947: ,date_history = SYSDATE
1948: WHERE id = l_late_stm_id;
1949:
1950: IF (SQL%NOTFOUND) THEN
1951: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1952: ELSE
1953: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1954: END IF;
1955: END IF;

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

1949:
1950: IF (SQL%NOTFOUND) THEN
1951: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream not deactivated successfully as payable stream creation was unsuccessful.');
1952: ELSE
1953: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Late charge stream deactivated successfully as payable stream creation was unsuccessful.');
1954: END IF;
1955: END IF;
1956: END LOOP;
1957: END IF; -- if consolidated_invoice_id is not null

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

1971: WHERE CURRENT OF l_AR_lsm_cur;
1972:
1973: -- IF (l_return_status = Fnd_Api.G_RET_STS_SUCCESS) THEN
1974: IF (SQL%NOTFOUND) THEN
1975: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1976: ELSE
1977: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1978: END IF;
1979: -- END IF;

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

1973: -- IF (l_return_status = Fnd_Api.G_RET_STS_SUCCESS) THEN
1974: IF (SQL%NOTFOUND) THEN
1975: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Update Unsuccessful.');
1976: ELSE
1977: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ... Internal Consolidation Record Updated.');
1978: END IF;
1979: -- END IF;
1980:
1981: END LOOP;

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

2000: END IF;
2001: --dkagrawa bug# 4728636 changes end
2002:
2003:
2004: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End of Calculate charges.');
2005: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2006: x_return_status := l_return_status;
2007:
2008: EXCEPTION

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

2006: x_return_status := l_return_status;
2007:
2008: EXCEPTION
2009: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2010: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (EXCP) => '||SQLERRM);
2011: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2012: (
2013: l_api_name,
2014: G_PKG_NAME,

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

2017: x_msg_data,
2018: '_PVT'
2019: );
2020: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2021: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (UNEXCP) => '||SQLERRM);
2022: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2023: (
2024: l_api_name,
2025: G_PKG_NAME,

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

2028: x_msg_data,
2029: '_PVT'
2030: );
2031: WHEN OTHERS THEN
2032: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (Other) => '||SQLERRM);
2033: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2034: (
2035: l_api_name,
2036: G_PKG_NAME,