eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CURE_CALC_PVT dependencies on OKL_DEBUG_PUB

Line 24: okl_debug_pub.logmessage('populate_qte_rec : START ');

20: l_type okl_trx_quotes_b.qtp_code%TYPE;
21:
22: BEGIN
23:
24: okl_debug_pub.logmessage('populate_qte_rec : START ');
25:
26: p_quot_rec_type.khr_id := p_contract_id;
27:
28: -- QUOTE Type from vendor agreement

Line 44: okl_debug_pub.logmessage('populate_qte_rec : l_type : '|| l_type);

40: p_quot_rec_type.qrs_code := 'RES_DELINQUENCY';
41: p_quot_rec_type.comments := 'Requesting Repurchase Amount'||
42: 'From Collections for Vendor Cure Request';
43:
44: okl_debug_pub.logmessage('populate_qte_rec : l_type : '|| l_type);
45:
46: okl_debug_pub.logmessage('populate_qte_rec : END ');
47:
48: END populate_qte_rec;

Line 46: okl_debug_pub.logmessage('populate_qte_rec : END ');

42: 'From Collections for Vendor Cure Request';
43:
44: okl_debug_pub.logmessage('populate_qte_rec : l_type : '|| l_type);
45:
46: okl_debug_pub.logmessage('populate_qte_rec : END ');
47:
48: END populate_qte_rec;
49:
50: ---------------------------------------------------------------------------

Line 80: okl_debug_pub.logmessage('populate_asset_table : START ');

76:
77: l_counter Number :=1;
78: BEGIN
79:
80: okl_debug_pub.logmessage('populate_asset_table : START ');
81:
82: FOR i IN asset_line_dur (p_contract_id)
83: LOOP
84: p_assn_tbl(l_counter).p_asset_id := i.kle_id;

Line 90: okl_debug_pub.logmessage('populate_asset_table : END ');

86: l_counter :=l_counter + 1;
87:
88: END LOOP;
89:
90: okl_debug_pub.logmessage('populate_asset_table : END ');
91:
92: END populate_asset_table;
93:
94: PROCEDURE get_error_message(p_all_message

Line 191: okl_debug_pub.logmessage('Update_cure_amounts : START ');

187: FND_MSG_PUB.initialize;
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Calling Cure Amount Update Api');
190:
191: okl_debug_pub.logmessage('Update_cure_amounts : START ');
192:
193: --update cure amounts table
194: FOR i in c_get_cure_amts (p_contract_id)
195: LOOP

Line 207: okl_debug_pub.logmessage('Update_cure_amounts : i.cure_amount_id '|| i.cure_amount_id);

203: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
204: 'cure_amount id '||i.cure_amount_id ||
205: 'recevied_amount '||l_camv_tbl(next_row).received_amount);
206:
207: okl_debug_pub.logmessage('Update_cure_amounts : i.cure_amount_id '|| i.cure_amount_id);
208: okl_debug_pub.logmessage('Update_cure_amounts : l_camv_tbl(next_row).received_amount '|| l_camv_tbl(next_row).received_amount);
209: CLOSE c_get_received_amounts;
210:
211: --commented out on 09/23 , requested by pdeveraj

Line 208: okl_debug_pub.logmessage('Update_cure_amounts : l_camv_tbl(next_row).received_amount '|| l_camv_tbl(next_row).received_amount);

204: 'cure_amount id '||i.cure_amount_id ||
205: 'recevied_amount '||l_camv_tbl(next_row).received_amount);
206:
207: okl_debug_pub.logmessage('Update_cure_amounts : i.cure_amount_id '|| i.cure_amount_id);
208: okl_debug_pub.logmessage('Update_cure_amounts : l_camv_tbl(next_row).received_amount '|| l_camv_tbl(next_row).received_amount);
209: CLOSE c_get_received_amounts;
210:
211: --commented out on 09/23 , requested by pdeveraj
212: /* If nvl(i.negotiated_amount,0) = 0 THEN

Line 233: okl_debug_pub.logmessage('Update_cure_amounts : OKL_cure_amounts_pub.update_cure_amounts : '||l_return_status);

229: ,p_camv_tbl => l_camv_tbl
230: ,x_camv_tbl => x_camv_tbl
231: );
232:
233: okl_debug_pub.logmessage('Update_cure_amounts : OKL_cure_amounts_pub.update_cure_amounts : '||l_return_status);
234:
235: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN
236: RAISE Fnd_Api.G_EXC_ERROR;
237: ELSE

Line 246: okl_debug_pub.logmessage('Update_cure_amounts : END ');

242: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
243: p_data => x_msg_data );
244: END IF;
245:
246: okl_debug_pub.logmessage('Update_cure_amounts : END ');
247:
248: EXCEPTION
249:
250: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 345: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : START ');

341: BEGIN
342:
343: SAVEPOINT GET_REPURCHASE_AMT;
344:
345: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : START ');
346:
347: populate_qte_rec( p_contract_id
348: ,l_quot_rec );
349:

Line 383: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : l_cpl_id : '|| l_cpl_id);

379:
380:
381: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CPL ID' || l_cpl_id );
382:
383: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : l_cpl_id : '|| l_cpl_id);
384:
385: -- Call the Asset Management Quote Creation API to get
386: -- Repurchase amount for the contract
387:

Line 401: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : OKL_AM_CREATE_QUOTE_PUB.create_terminate_quote : '|| l_return_status);

397: ,x_quot_rec => x_quot_rec
398: ,x_tqlv_tbl => x_tqlv_tbl
399: ,x_assn_tbl => x_assn_tbl);
400:
401: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : OKL_AM_CREATE_QUOTE_PUB.create_terminate_quote : '|| l_return_status);
402:
403: if l_return_status <> FND_Api.G_RET_STS_SUCCESS THEN
404: fnd_msg_pub.get (p_msg_index => 1,
405: p_encoded => 'F',

Line 438: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : l_repurchase_amount : '|| l_repurchase_amount);

434: FND_MSG_PUB.Count_And_Get
435: ( p_count => x_msg_count,
436: p_data => x_msg_data
437: );
438: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : l_repurchase_amount : '|| l_repurchase_amount);
439: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : END ');
440:
441: EXCEPTION
442: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 439: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : END ');

435: ( p_count => x_msg_count,
436: p_data => x_msg_data
437: );
438: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : l_repurchase_amount : '|| l_repurchase_amount);
439: okl_debug_pub.logmessage('GET_REPURCHASE_AMT : END ');
440:
441: EXCEPTION
442: WHEN Fnd_Api.G_EXC_ERROR THEN
443: ROLLBACK TO GET_REPURCHASE_AMT;

Line 567: okl_debug_pub.logmessage('GET_CURE_AMT : START ');

563: -- Process Full Cure Payment
564: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
565: 'Getting cure amounts' || ' and cure_type is ' ||p_cure_type);
566:
567: okl_debug_pub.logmessage('GET_CURE_AMT : START ');
568:
569: IF (p_cure_type = 'Full Cure') THEN
570: -- Get Contract allowed value for days past due from rules
571: l_return_status := okl_contract_info.get_rule_value(

Line 580: okl_debug_pub.logmessage('GET_CURE_AMT : okl_contract_info.get_rule_value : '||l_return_status);

576: ,x_id1 => l_id1
577: ,x_id2 => l_id2
578: ,x_value => l_rule_value);
579:
580: okl_debug_pub.logmessage('GET_CURE_AMT : okl_contract_info.get_rule_value : '||l_return_status);
581:
582: IF l_return_status =FND_Api.G_RET_STS_SUCCESS THEN
583: l_days_allowed :=nvl(l_rule_value,0);
584: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 588: okl_debug_pub.logmessage('GET_CURE_AMT : l_days_allowed : '||l_days_allowed);

584: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
585: 'l_days allowed for days past due ' || l_days_allowed);
586: END IF;
587:
588: okl_debug_pub.logmessage('GET_CURE_AMT : l_days_allowed : '||l_days_allowed);
589:
590: -- Get Past Due Amount
591: OPEN c_amount_past_due (p_contract_id,l_days_allowed);
592: FETCH c_amount_past_due INTO l_amount_past_due;

Line 595: okl_debug_pub.logmessage('GET_CURE_AMT : l_amount_past_due : '||l_amount_past_due);

591: OPEN c_amount_past_due (p_contract_id,l_days_allowed);
592: FETCH c_amount_past_due INTO l_amount_past_due;
593: CLOSE c_amount_past_due;
594:
595: okl_debug_pub.logmessage('GET_CURE_AMT : l_amount_past_due : '||l_amount_past_due);
596:
597: -- cures in possession
598: OPEN c_cures_in_possession (p_contract_id);
599: FETCH c_cures_in_possession INTO l_cures_in_possession;

Line 607: okl_debug_pub.logmessage('GET_CURE_AMT : x_cure_amount : '||x_cure_amount);

603: ELSIF (p_cure_type = 'Interest Cure') THEN
604: x_cure_amount := OKL_seeded_functions_pvt.contract_interest_cure (p_contract_id);
605: END IF;
606:
607: okl_debug_pub.logmessage('GET_CURE_AMT : x_cure_amount : '||x_cure_amount);
608: okl_debug_pub.logmessage('GET_CURE_AMT : END ');
609:
610: EXCEPTION
611: WHEN OTHERS THEN

Line 608: okl_debug_pub.logmessage('GET_CURE_AMT : END ');

604: x_cure_amount := OKL_seeded_functions_pvt.contract_interest_cure (p_contract_id);
605: END IF;
606:
607: okl_debug_pub.logmessage('GET_CURE_AMT : x_cure_amount : '||x_cure_amount);
608: okl_debug_pub.logmessage('GET_CURE_AMT : END ');
609:
610: EXCEPTION
611: WHEN OTHERS THEN
612: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 722: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : START ');

718:
719: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, ' Effective Day ' ||
720: ' is ' ||x_effective_date );
721:
722: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : START ');
723:
724: -- Get remaining payments
725: l_return_status := okl_contract_info.get_remaining_payments
726: ( p_contract_id

Line 729: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : okl_contract_info.get_remaining_payments : '||l_return_status);

725: l_return_status := okl_contract_info.get_remaining_payments
726: ( p_contract_id
727: ,x_payments_remaining );
728:
729: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : okl_contract_info.get_remaining_payments : '||l_return_status);
730:
731: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN
732: x_payments_remaining :=0;
733: END IF;

Line 745: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : x_cures_in_possession : '||x_cures_in_possession);

741:
742: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Cures in possession is '
743: ||x_cures_in_possession);
744:
745: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : x_cures_in_possession : '||x_cures_in_possession);
746:
747: l_return_status := okl_contract_info.get_rule_value(
748: p_contract_id => p_program_id
749: ,p_rule_group_code => 'COCURP'

Line 762: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : l_days_allowed : '||l_days_allowed);

758: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
759: 'days allowed for days past due ' || l_days_allowed);
760: END IF;
761:
762: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : l_days_allowed : '||l_days_allowed);
763:
764: -- Get Past Due Amount
765: OPEN c_amount_past_due (p_contract_id,0);
766: FETCH c_amount_past_due INTO x_outstanding_amount;

Line 769: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : x_outstanding_amount : '||x_outstanding_amount);

765: OPEN c_amount_past_due (p_contract_id,0);
766: FETCH c_amount_past_due INTO x_outstanding_amount;
767: CLOSE c_amount_past_due;
768:
769: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : x_outstanding_amount : '||x_outstanding_amount);
770:
771: -- Get Past Due Amount with maximium days allowed
772: OPEN c_amount_past_due (p_contract_id,l_days_allowed);
773: FETCH c_amount_past_due INTO x_delinquent_amount;

Line 781: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : x_delinquent_amount : '||x_delinquent_amount);

777: || ' is ' ||x_outstanding_amount);
778:
779: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Amount past due with maximum day allowed'
780: || ' is ' ||x_delinquent_amount);
781: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : x_delinquent_amount : '||x_delinquent_amount);
782: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : END ');
783:
784: END Calculate_CAM_COLUMNS;
785:

Line 782: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : END ');

778:
779: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Amount past due with maximum day allowed'
780: || ' is ' ||x_delinquent_amount);
781: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : x_delinquent_amount : '||x_delinquent_amount);
782: okl_debug_pub.logmessage('Calculate_CAM_COLUMNS : END ');
783:
784: END Calculate_CAM_COLUMNS;
785:
786:

Line 842: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : START ');

838: BEGIN
839:
840: SAVEPOINT CALC_CURE_REPURCHASE;
841:
842: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : START ');
843: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : p_cure_calc_flag : '||p_cure_calc_flag);
844: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : p_process : '||p_process);
845:
846: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 843: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : p_cure_calc_flag : '||p_cure_calc_flag);

839:
840: SAVEPOINT CALC_CURE_REPURCHASE;
841:
842: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : START ');
843: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : p_cure_calc_flag : '||p_cure_calc_flag);
844: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : p_process : '||p_process);
845:
846: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
847: 'Calc repurchase started for ' || p_contract_number);

Line 844: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : p_process : '||p_process);

840: SAVEPOINT CALC_CURE_REPURCHASE;
841:
842: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : START ');
843: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : p_cure_calc_flag : '||p_cure_calc_flag);
844: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : p_process : '||p_process);
845:
846: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
847: 'Calc repurchase started for ' || p_contract_number);
848:

Line 881: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : GET_REPURCHASE_AMT : '||l_return_status);

877: x_msg_count => l_msg_count,
878: x_msg_data => l_msg_data
879: ,x_qte_id => l_qte_id );
880:
881: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : GET_REPURCHASE_AMT : '||l_return_status);
882:
883: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN
884: RAISE Fnd_Api.G_EXC_ERROR;
885: ELSE

Line 892: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : GET_REPURCHASE_AMT : l_repurchase_amount : '||l_repurchase_amount);

888:
889: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Repurchase amount Is '
890: ||l_repurchase_amount);
891:
892: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : GET_REPURCHASE_AMT : l_repurchase_amount : '||l_repurchase_amount);
893:
894: END IF;
895:
896: IF p_process IN ('CURE','BOTH') AND p_cure_calc_flag = 'Interest Cure' THEN

Line 903: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : Interest Cure Amount : '||l_cure_amount);

899:
900: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Interest Cure Amount Is '
901: ||l_cure_amount);
902:
903: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : Interest Cure Amount : '||l_cure_amount);
904:
905: END IF;
906:
907: IF p_process IN('CURE','BOTH') AND p_cure_calc_flag = 'Full Cure' THEN

Line 922: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : Okl_Execute_Formula_Pub : '||l_return_status);

918: ,p_contract_id => p_contract_id
919: ,x_value => l_cure_amount
920: );
921:
922: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : Okl_Execute_Formula_Pub : '||l_return_status);
923:
924: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN
925: RAISE Fnd_Api.G_EXC_ERROR;
926: END IF;

Line 932: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : Full Cure : l_cure_amount : '||l_cure_amount);

928:
929: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Cure Amount Is '
930: ||l_cure_amount);
931:
932: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : Full Cure : l_cure_amount : '||l_cure_amount);
933:
934: END IF; -- p_process ='CURE'
935:
936:

Line 975: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : Update_cure_amounts : '||l_return_status);

971: x_return_status =>l_return_status,
972: x_msg_count =>l_msg_count,
973: x_msg_data =>l_msg_data );
974:
975: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : Update_cure_amounts : '||l_return_status);
976:
977: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
978: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
979: 'Error Updating Cure amounts Table for contract '

Line 1014: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : OKL_cure_amounts_pub.insert_cure_amounts : '||l_return_status);

1010: ,p_camv_rec => l_camv_rec
1011: ,x_camv_rec => x_camv_rec
1012: );
1013:
1014: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : OKL_cure_amounts_pub.insert_cure_amounts : '||l_return_status);
1015:
1016: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN
1017: RAISE Fnd_Api.G_EXC_ERROR;
1018: ELSE

Line 1033: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : END ');

1029: x_return_status := l_return_status;
1030: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1031: p_data => x_msg_data );
1032:
1033: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : END ');
1034:
1035: EXCEPTION
1036:
1037: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1206: okl_debug_pub.logmessage('check_contract : START ');

1202:
1203: x_return_status := FND_API.G_RET_STS_SUCCESS;
1204: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start of check_contract Procedure' );
1205:
1206: okl_debug_pub.logmessage('check_contract : START ');
1207:
1208: -- Get Contract allowed value for days past due from rules
1209: l_return_status := okl_contract_info.get_rule_value(
1210: p_contract_id => p_program_id

Line 1218: okl_debug_pub.logmessage('check_contract : okl_contract_info.get_rule_value : '||l_return_status);

1214: ,x_id1 => l_id1
1215: ,x_id2 => l_id2
1216: ,x_value => l_rule_value);
1217:
1218: okl_debug_pub.logmessage('check_contract : okl_contract_info.get_rule_value : '||l_return_status);
1219:
1220: IF l_return_status =FND_Api.G_RET_STS_SUCCESS THEN
1221: l_days_allowed :=nvl(l_rule_value,0);
1222: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1226: okl_debug_pub.logmessage('check_contract : l_days_allowed : '||l_days_allowed);

1222: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1223: 'No of Past due days allowed from Rule is ' || l_days_allowed);
1224: END IF;
1225:
1226: okl_debug_pub.logmessage('check_contract : l_days_allowed : '||l_days_allowed);
1227:
1228: -- Get Past Due Amount
1229: OPEN c_amount_past_due (p_contract_id,l_days_allowed);
1230: FETCH c_amount_past_due INTO l_amount_past_due;

Line 1241: okl_debug_pub.logmessage('check_contract : l_amount_past_due : '||l_amount_past_due);

1237: ||p_contract_number || ' is delinquent');
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: END IF;
1240:
1241: okl_debug_pub.logmessage('check_contract : l_amount_past_due : '||l_amount_past_due);
1242: okl_debug_pub.logmessage('check_contract : END ');
1243:
1244: END check_contract;
1245:

Line 1242: okl_debug_pub.logmessage('check_contract : END ');

1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: END IF;
1240:
1241: okl_debug_pub.logmessage('check_contract : l_amount_past_due : '||l_amount_past_due);
1242: okl_debug_pub.logmessage('check_contract : END ');
1243:
1244: END check_contract;
1245:
1246:

Line 1403: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: START');

1399: l_repurchase_amount NUMBER;
1400:
1401: BEGIN
1402:
1403: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: START');
1404: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: p_contract_number : ' || p_contract_number);
1405:
1406: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'OKL Generate Cure Amounts');
1407: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Program Run Date:'||SYSDATE);

Line 1404: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: p_contract_number : ' || p_contract_number);

1400:
1401: BEGIN
1402:
1403: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: START');
1404: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: p_contract_number : ' || p_contract_number);
1405:
1406: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'OKL Generate Cure Amounts');
1407: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Program Run Date:'||SYSDATE);
1408: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');

Line 1422: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: p_contract_number : ' || i.program_number);

1418: ||i.contract_number);
1419: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, ' Program number is ' ||i.program_number);
1420: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, ' Contract Id is ' ||i.contract_id);
1421:
1422: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: p_contract_number : ' || i.program_number);
1423: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: p_contract_number : ' || i.contract_id);
1424:
1425: --need to process other contract if the first one errors out
1426: --so introducing this while loop

Line 1423: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: p_contract_number : ' || i.contract_id);

1419: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, ' Program number is ' ||i.program_number);
1420: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, ' Contract Id is ' ||i.contract_id);
1421:
1422: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: p_contract_number : ' || i.program_number);
1423: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: p_contract_number : ' || i.contract_id);
1424:
1425: --need to process other contract if the first one errors out
1426: --so introducing this while loop
1427:

Line 1468: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Cure Applicable rule value : ' || l_rule_value);

1464: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
1465: 'Is Cure Applicable and rule value is ' || l_rule_value);
1466: END IF;
1467:
1468: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Cure Applicable rule value : ' || l_rule_value);
1469:
1470: IF (l_rule_value <> 'Yes') THEN
1471: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
1472: 'Is not cure applicable ');

Line 1505: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Contract ' || i.contract_number || ' is Not Delinquent');

1501: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
1502: 'Contract ' || i.contract_number ||
1503: 'is Not Delinquent ');
1504:
1505: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Contract ' || i.contract_number || ' is Not Delinquent');
1506:
1507: Update_cure_amounts(
1508: p_contract_id =>i.contract_id,
1509: x_return_status =>l_return_status,

Line 1554: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Days past due : ' || l_days_past_due);

1550:
1551: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1552: 'Days past due is ' ||l_days_past_due);
1553:
1554: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Days past due : ' || l_days_past_due);
1555: ----------------------------------------------------------
1556: -- Get Contract allowed value for days past due from rules
1557: --For Cure
1558: ----------------------------------------------------------

Line 1586: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Days past due allowed for Cure : ' || l_cure_past_due_allowed);

1582: || l_rule_value);
1583: l_cure_past_due_allowed :=nvl(l_rule_value,0);
1584: END IF;
1585:
1586: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Days past due allowed for Cure : ' || l_cure_past_due_allowed);
1587:
1588: ----------------------------------------------------------
1589: -- Get Contract allowed value for days past due from rules
1590: -- For repurchase

Line 1618: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Days past due allowed for repurchase : ' || l_repurchase_days_past_allowed);

1614: 'Days_past due_allowed for repurchase is ' || l_rule_value);
1615: l_repurchase_days_past_allowed := nvl(l_rule_value,0);
1616: END IF;
1617:
1618: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Days past due allowed for repurchase : ' || l_repurchase_days_past_allowed);
1619:
1620: ----------------------------------------------------------
1621: -- Get no of cures made against contract
1622: -- For repurchase

Line 1633: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: No of cures from cursor : ' || l_no_of_cures);

1629:
1630: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, ' No of cures is '
1631: ||l_no_of_cures);
1632:
1633: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: No of cures from cursor : ' || l_no_of_cures);
1634:
1635: -- Now get the no of cures allowed value from Rule
1636: l_rule_value := NULL;
1637: l_return_status := okl_contract_info.get_rule_value(

Line 1661: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: No of cures from rule : ' || l_no_of_cures_allowed);

1657: 'No of cures allowed before Repurchase is ' || l_rule_value);
1658: l_no_of_cures_allowed := nvl(l_rule_value,0);
1659: END IF;
1660:
1661: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: No of cures from rule : ' || l_no_of_cures_allowed);
1662:
1663: /* If days past due is more than days past due allowed
1664: and number of cures received is more than number of
1665: cures allowed for repurchase, ask for repurchase, else

Line 1706: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Contract '|| i.contract_number || ' is processed for ' ||l_process);

1702:
1703: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, ' Contract '||
1704: i.contract_number || ' will be in ' ||l_process);
1705:
1706: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: Contract '|| i.contract_number || ' is processed for ' ||l_process);
1707:
1708: /* Check if the contract is in litigation
1709: The code will be added once the source is finalized
1710: The code will check if the contract is in litigation,

Line 1764: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: after CALC_CURE_REPURCHASE : '|| l_return_status);

1760: x_return_status =>l_return_status,
1761: x_msg_count =>l_msg_count,
1762: x_msg_data =>l_msg_data );
1763:
1764: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: after CALC_CURE_REPURCHASE : '|| l_return_status);
1765:
1766: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
1767: 'Result of Cure or Repurchase for contract_number '||
1768: i.contract_number || ' is ' ||l_return_status);

Line 1799: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: END');

1795: END LOOP;
1796: Print_log (p_contract_number);
1797: retcode :=0; --success
1798:
1799: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: END');
1800:
1801: EXCEPTION
1802: WHEN OTHERS THEN
1803: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS)IN OKL_CURE_CALC_PVT => '||SQLERRM);