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 FND_MSG_PUB

Line 100: l_msg_count := fnd_msg_pub.count_msg;

96: IS
97: l_msg_text VARCHAR2(32627);
98: l_msg_count NUMBER ;
99: BEGIN
100: l_msg_count := fnd_msg_pub.count_msg;
101: FOR i IN 1..l_msg_count
102: LOOP
103: fnd_msg_pub.get
104: (p_data => p_all_message(i),

Line 103: fnd_msg_pub.get

99: BEGIN
100: l_msg_count := fnd_msg_pub.count_msg;
101: FOR i IN 1..l_msg_count
102: LOOP
103: fnd_msg_pub.get
104: (p_data => p_all_message(i),
105: p_msg_index_out => l_msg_count,
106: p_encoded => fnd_api.g_false,
107: p_msg_index => fnd_msg_pub.g_next

Line 107: p_msg_index => fnd_msg_pub.g_next

103: fnd_msg_pub.get
104: (p_data => p_all_message(i),
105: p_msg_index_out => l_msg_count,
106: p_encoded => fnd_api.g_false,
107: p_msg_index => fnd_msg_pub.g_next
108: );
109: END LOOP;
110: EXCEPTION
111: WHEN OTHERS THEN

Line 187: FND_MSG_PUB.initialize;

183: BEGIN
184:
185:
186: SAVEPOINT UPDATE_CURE_AMOUNTS;
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 ');

Line 189: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Calling Cure Amount Update Api');

185:
186: SAVEPOINT UPDATE_CURE_AMOUNTS;
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

Line 203: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

199: l_camv_tbl(next_row).SHOW_ON_REQUEST :='N';
200: OPEN c_get_received_amounts(i.cure_amount_id);
201: FETCH c_get_received_amounts INTO
202: l_camv_tbl(next_row).received_amount;
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);

Line 219: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

215: */
216:
217: END LOOP;
218:
219: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
220: 'no of records to be updated in Cure amounts '||
221: l_camv_tbl.COUNT);
222: IF l_camv_tbl.COUNT > 0 THEN
223: OKL_cure_amounts_pub.update_cure_amounts

Line 238: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

234:
235: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN
236: RAISE Fnd_Api.G_EXC_ERROR;
237: ELSE
238: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
239: 'Updation of cure amounts is Successful');
240: END IF;
241: x_return_status := l_return_status;
242: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 242: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

238: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
239: 'Updation of cure amounts is Successful');
240: END IF;
241: x_return_status := l_return_status;
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 ');

Line 255: Fnd_Msg_Pub.count_and_get(

251: ROLLBACK TO UPDATE_CURE_AMOUNTS;
252: x_return_status := Fnd_Api.G_RET_STS_ERROR;
253: x_msg_count := l_msg_count ;
254: x_msg_data := l_msg_data ;
255: Fnd_Msg_Pub.count_and_get(
256: p_count => x_msg_count
257: ,p_data => x_msg_data);
258: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
259: ROLLBACK TO UPDATE_CURE_AMOUNTS;

Line 263: Fnd_Msg_Pub.count_and_get(

259: ROLLBACK TO UPDATE_CURE_AMOUNTS;
260: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
261: x_msg_count := l_msg_count ;
262: x_msg_data := l_msg_data ;
263: Fnd_Msg_Pub.count_and_get(
264: p_count => x_msg_count
265: ,p_data => x_msg_data);
266: WHEN OTHERS THEN
267: ROLLBACK TO UPDATE_CURE_AMOUNTS;

Line 271: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','UPDATE_CURE_AMOUNTS');

267: ROLLBACK TO UPDATE_CURE_AMOUNTS;
268: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
269: x_msg_count := l_msg_count ;
270: x_msg_data := l_msg_data ;
271: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','UPDATE_CURE_AMOUNTS');
272: Fnd_Msg_Pub.count_and_get(
273: p_count => x_msg_count
274: ,p_data => x_msg_data);
275:

Line 272: Fnd_Msg_Pub.count_and_get(

268: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
269: x_msg_count := l_msg_count ;
270: x_msg_data := l_msg_data ;
271: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','UPDATE_CURE_AMOUNTS');
272: Fnd_Msg_Pub.count_and_get(
273: p_count => x_msg_count
274: ,p_data => x_msg_data);
275:
276:

Line 381: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CPL ID' || l_cpl_id );

377: l_qpyv_tbl(1).cpl_id := l_cpl_id;
378: l_qpyv_tbl(1).qpt_code := 'RECIPIENT';
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

Line 404: fnd_msg_pub.get (p_msg_index => 1,

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',
406: p_data => l_msg_data,
407: p_msg_index_out => l_msg_index_out);
408: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,'error after calling create terminate quote '||

Line 408: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,'error after calling create terminate quote '||

404: fnd_msg_pub.get (p_msg_index => 1,
405: p_encoded => 'F',
406: p_data => l_msg_data,
407: p_msg_index_out => l_msg_index_out);
408: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,'error after calling create terminate quote '||
409: ' is ' || l_msg_data);
410: RAISE Fnd_Api.G_EXC_ERROR;
411: END IF;
412:

Line 428: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Repurchase Amount is '

424: x_msg_count := l_msg_count ;
425: x_msg_data := l_msg_data ;
426:
427:
428: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Repurchase Amount is '
429: ||l_repurchase_amount
430: || 'and Quote id is '||x_qte_id);
431:
432:

Line 434: FND_MSG_PUB.Count_And_Get

430: || 'and Quote id is '||x_qte_id);
431:
432:
433:
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);

Line 447: Fnd_Msg_Pub.count_and_get(

443: ROLLBACK TO GET_REPURCHASE_AMT;
444: x_return_status := Fnd_Api.G_RET_STS_ERROR;
445: x_msg_count := l_msg_count ;
446: x_msg_data := l_msg_data ;
447: Fnd_Msg_Pub.count_and_get(
448: p_count => x_msg_count
449: ,p_data => x_msg_data);
450:
451: WHEN OTHERS THEN

Line 456: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','GET_REPURCHASE_AMT');

452: ROLLBACK TO GET_REPURCHASE_AMT;
453: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
454: x_msg_count := l_msg_count ;
455: x_msg_data := l_msg_data ;
456: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','GET_REPURCHASE_AMT');
457: Fnd_Msg_Pub.count_and_get(
458: p_count => x_msg_count
459: ,p_data => x_msg_data);
460: END GET_REPURCHASE_AMT;

Line 457: Fnd_Msg_Pub.count_and_get(

453: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
454: x_msg_count := l_msg_count ;
455: x_msg_data := l_msg_data ;
456: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','GET_REPURCHASE_AMT');
457: Fnd_Msg_Pub.count_and_get(
458: p_count => x_msg_count
459: ,p_data => x_msg_data);
460: END GET_REPURCHASE_AMT;
461:

Line 564: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

560:
561: BEGIN
562:
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:

Line 584: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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,
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);

Line 613: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','GET_CURE_AMT');

609:
610: EXCEPTION
611: WHEN OTHERS THEN
612: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
613: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','GET_CURE_AMT');
614: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
615: ,p_data => x_msg_data);
616: END GET_CURE_AMT;
617:

Line 614: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count

610: EXCEPTION
611: WHEN OTHERS THEN
612: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
613: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','GET_CURE_AMT');
614: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
615: ,p_data => x_msg_data);
616: END GET_CURE_AMT;
617:
618:

Line 719: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, ' Effective Day ' ||

715: */
716:
717: x_effective_date :=SYSDATE;
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:

Line 734: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Remaining_payments is '

730:
731: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN
732: x_payments_remaining :=0;
733: END IF;
734: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Remaining_payments is '
735: ||x_payments_remaining);
736:
737: -- cures in possession
738: OPEN c_cures_in_possession (p_contract_id);

Line 742: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Cures in possession is '

738: OPEN c_cures_in_possession (p_contract_id);
739: FETCH c_cures_in_possession INTO x_cures_in_possession;
740: CLOSE c_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:

Line 758: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

754: ,x_value => l_rule_value);
755:
756: IF l_return_status =FND_Api.G_RET_STS_SUCCESS THEN
757: l_days_allowed :=nvl(l_rule_value,0);
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);

Line 776: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Amount past due '

772: OPEN c_amount_past_due (p_contract_id,l_days_allowed);
773: FETCH c_amount_past_due INTO x_delinquent_amount;
774: CLOSE c_amount_past_due;
775:
776: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Amount past due '
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);

Line 779: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Amount past due with maximum day allowed'

775:
776: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Amount past due '
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:

Line 846: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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:
849: Calculate_CAM_COLUMNS ( p_contract_id =>p_contract_id,
850: p_program_id =>p_program_id,

Line 889: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Repurchase amount Is '

885: ELSE
886: x_repurchase_amount :=l_repurchase_amount;
887: END IF;
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:

Line 900: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Interest Cure Amount Is '

896: IF p_process IN ('CURE','BOTH') AND p_cure_calc_flag = 'Interest Cure' THEN
897: l_cure_amount := OKL_seeded_functions_pvt.contract_interest_cure(p_contract_id);
898: x_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:

Line 929: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Cure Amount Is '

925: RAISE Fnd_Api.G_EXC_ERROR;
926: END IF;
927: x_cure_amount := l_cure_amount; -- Bug 6487958
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:

Line 963: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Before updating Cure Amounts');

959: OPEN c_get_org_id(p_contract_id);
960: FETCH c_get_org_id INTO l_camv_rec.org_id;
961: CLOSE c_get_org_id;
962:
963: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Before updating Cure Amounts');
964: -- IF (l_negotiated_amount > 0) THEN
965:
966:
967: IF (l_cure_amount > 0 or l_repurchase_amount > 0) THEN

Line 978: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

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 '
980: || p_contract_number );
981: GET_ERROR_MESSAGE(l_error_msg_tbl);
982: IF (l_error_msg_tbl.COUNT > 0) THEN

Line 985: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,

981: GET_ERROR_MESSAGE(l_error_msg_tbl);
982: IF (l_error_msg_tbl.COUNT > 0) THEN
983: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
984: LOOP
985: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,
986: l_error_msg_tbl(i));
987: END LOOP;
988: END IF; --end of l_error_msg_tbl
989: END IF; -- update_cure_amounts

Line 992: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Before Inserting Cure Amounts');

988: END IF; --end of l_error_msg_tbl
989: END IF; -- update_cure_amounts
990: -- END IF; --negotiated _amount;
991:
992: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Before Inserting Cure Amounts');
993:
994: -- Populate null for repurchase amount and cure amount if =0
995: --requested by pdevaraj for UI purposes
996: --09/17/2003

Line 1019: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

1015:
1016: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN
1017: RAISE Fnd_Api.G_EXC_ERROR;
1018: ELSE
1019: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
1020: ' Cure amount is '||x_cure_amount ||
1021: ' Repurchase Amount is '||x_repurchase_amount);
1022: END IF;
1023: ELSE

Line 1024: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

1020: ' Cure amount is '||x_cure_amount ||
1021: ' Repurchase Amount is '||x_repurchase_amount);
1022: END IF;
1023: ELSE
1024: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
1025: ' Cure amount or repurchase amount= 0 , so cure amount record is not created');
1026: END IF;
1027:
1028:

Line 1030: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1026: END IF;
1027:
1028:
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:

Line 1042: Fnd_Msg_Pub.count_and_get(

1038: ROLLBACK TO CALC_CURE_REPURCHASE;
1039: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1040: x_msg_count := l_msg_count ;
1041: x_msg_data := l_msg_data ;
1042: Fnd_Msg_Pub.count_and_get(
1043: p_count => x_msg_count
1044: ,p_data => x_msg_data);
1045: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1046: ROLLBACK TO CALC_CURE_REPURCHASE;

Line 1050: Fnd_Msg_Pub.count_and_get(

1046: ROLLBACK TO CALC_CURE_REPURCHASE;
1047: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1048: x_msg_count := l_msg_count ;
1049: x_msg_data := l_msg_data ;
1050: Fnd_Msg_Pub.count_and_get(
1051: p_count => x_msg_count
1052: ,p_data => x_msg_data);
1053: WHEN OTHERS THEN
1054: ROLLBACK TO CALC_CURE_REPURCHASE;

Line 1058: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','CALC_CURE_REPURCHASE');

1054: ROLLBACK TO CALC_CURE_REPURCHASE;
1055: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1056: x_msg_count := l_msg_count ;
1057: x_msg_data := l_msg_data ;
1058: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','CALC_CURE_REPURCHASE');
1059: Fnd_Msg_Pub.count_and_get(
1060: p_count => x_msg_count
1061: ,p_data => x_msg_data);
1062:

Line 1059: Fnd_Msg_Pub.count_and_get(

1055: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1056: x_msg_count := l_msg_count ;
1057: x_msg_data := l_msg_data ;
1058: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_CALC_PVT','CALC_CURE_REPURCHASE');
1059: Fnd_Msg_Pub.count_and_get(
1060: p_count => x_msg_count
1061: ,p_data => x_msg_data);
1062:
1063: END CALC_CURE_REPURCHASE ;

Line 1204: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start of check_contract Procedure' );

1200:
1201: BEGIN
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

Line 1222: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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,
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);

Line 1232: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;
1231: CLOSE c_amount_past_due;
1232: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1233: 'Amount Past due with grace days is ' || nvl(l_days_allowed,0));
1234:
1235: IF nvl(l_amount_past_due,0) > 0 THEN
1236: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Contract'

Line 1236: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Contract'

1232: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1233: 'Amount Past due with grace days is ' || nvl(l_days_allowed,0));
1234:
1235: IF nvl(l_amount_past_due,0) > 0 THEN
1236: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Contract'
1237: ||p_contract_number || ' is delinquent');
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: END IF;
1240:

Line 1406: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'OKL Generate Cure Amounts');

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, '***********************************************');
1409: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
1410: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);

Line 1407: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Program Run Date:'||SYSDATE);

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, '***********************************************');
1409: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
1410: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);
1411: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');

Line 1408: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');

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, '***********************************************');
1409: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
1410: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);
1411: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
1412:

Line 1409: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');

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, '***********************************************');
1409: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
1410: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);
1411: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
1412:
1413: -- Open the contract cursor for process

Line 1410: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);

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, '***********************************************');
1409: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
1410: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);
1411: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
1412:
1413: -- Open the contract cursor for process
1414: FOR i IN contract_csr(p_contract_number)

Line 1411: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');

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, '***********************************************');
1409: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
1410: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);
1411: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
1412:
1413: -- Open the contract cursor for process
1414: FOR i IN contract_csr(p_contract_number)
1415: LOOP

Line 1416: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, '***********************************************');

1412:
1413: -- Open the contract cursor for process
1414: FOR i IN contract_csr(p_contract_number)
1415: LOOP
1416: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, '***********************************************');
1417: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,' Processing: Contract 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);

Line 1417: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,' Processing: Contract Number=> '

1413: -- Open the contract cursor for process
1414: FOR i IN contract_csr(p_contract_number)
1415: LOOP
1416: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, '***********************************************');
1417: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,' Processing: Contract 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:

Line 1419: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, ' Program number is ' ||i.program_number);

1415: LOOP
1416: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, '***********************************************');
1417: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,' Processing: Contract 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);

Line 1420: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, ' Contract Id is ' ||i.contract_id);

1416: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, '***********************************************');
1417: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,' Processing: Contract 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:

Line 1455: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

1451: ,x_id2 => l_id2
1452: ,x_value => l_rule_value);
1453:
1454: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1455: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
1456: 'Did not return a value for cure applicable Rule ');
1457: POPULATE_LOG_TBL(
1458: p_contract_number =>i.contract_number,
1459: p_cure_flag =>NULL,

Line 1464: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

1460: p_cure_amount =>NULL,
1461: P_type =>'ERROR');
1462: EXIT;
1463: ELSE
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);

Line 1471: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

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 ');
1473: POPULATE_LOG_TBL(
1474: p_contract_number =>i.contract_number,
1475: p_cure_flag =>NULL,

Line 1501: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

1497:
1498:
1499: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1500:
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');

Line 1514: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

1510: x_msg_count =>l_msg_count,
1511: x_msg_data =>l_msg_data );
1512:
1513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1514: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
1515: 'Error Updating Cure amounts Table for contract '
1516: || i.contract_number );
1517: GET_ERROR_MESSAGE(l_error_msg_tbl);
1518: IF (l_error_msg_tbl.COUNT > 0) THEN

Line 1521: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,

1517: GET_ERROR_MESSAGE(l_error_msg_tbl);
1518: IF (l_error_msg_tbl.COUNT > 0) THEN
1519: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
1520: LOOP
1521: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,
1522: l_error_msg_tbl(i));
1523: END LOOP;
1524: END IF; --end of l_error_msg_tbl
1525: END IF; -- update_cure_amounts

Line 1551: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1547:
1548: l_days_past_due := l_default_date - nvl(TRUNC(l_days_past),
1549: l_default_date);
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: ----------------------------------------------------------

Line 1570: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

1566: ,x_id2 => l_id2
1567: ,x_value => l_rule_value);
1568:
1569: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN
1570: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
1571: 'Did not return a value for days past due ');
1572:
1573: POPULATE_LOG_TBL(
1574: p_contract_number =>i.contract_number,

Line 1580: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,'Days past '||

1576: p_cure_amount =>NULL,
1577: P_type =>'ERROR');
1578: EXIT;
1579: ELSE
1580: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,'Days past '||
1581: 'due allowed from rule is '
1582: || l_rule_value);
1583: l_cure_past_due_allowed :=nvl(l_rule_value,0);
1584: END IF;

Line 1604: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

1600: ,x_id2 => l_id2
1601: ,x_value => l_rule_value);
1602:
1603: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN
1604: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
1605: 'Did not return a value for days past due allowed for Repurchase' );
1606: POPULATE_LOG_TBL(
1607: p_contract_number =>i.contract_number,
1608: p_cure_flag =>NULL,

Line 1613: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1609: p_cure_amount =>NULL,
1610: P_type =>'ERROR');
1611: EXIT;
1612: ELSE
1613: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
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:

Line 1630: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, ' No of cures is '

1626: OPEN c_get_noof_cures(i.contract_id);
1627: FETCH c_get_noof_cures INTO l_no_of_cures;
1628: CLOSE c_get_noof_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:

Line 1647: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

1643: ,x_id2 => l_id2
1644: ,x_value => l_rule_value);
1645:
1646: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN
1647: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
1648: 'Did not return a value for no of cures allowed ');
1649: POPULATE_LOG_TBL(
1650: p_contract_number =>i.contract_number,
1651: p_cure_flag =>NULL,

Line 1656: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

1652: p_cure_amount =>NULL,
1653: P_type =>'ERROR');
1654: EXIT;
1655: ELSE
1656: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
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:

Line 1693: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

1689: l_process := l_process1;
1690: ELSIF l_process2 IS NOT NULL THEN
1691: l_process := l_process2;
1692: ELSE
1693: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
1694: 'Did not Satisfy The Rule Values ');
1695: POPULATE_LOG_TBL(
1696: p_contract_number =>i.contract_number,
1697: p_cure_flag =>NULL,

Line 1703: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, ' Contract '||

1699: P_type =>'ERROR');
1700: EXIT;
1701: END IF;
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:

Line 1733: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

1729: ,x_id2 => l_id2
1730: ,x_value => l_rule_value );
1731:
1732: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN
1733: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
1734: 'Did not return a value for Type of Cure ' );
1735: POPULATE_LOG_TBL(
1736: p_contract_number =>i.contract_number,
1737: p_cure_flag =>NULL,

Line 1742: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

1738: p_cure_amount =>NULL,
1739: P_type =>'ERROR');
1740: EXIT;
1741: ELSE
1742: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
1743: 'Type of Cure is ' || l_rule_value);
1744: END IF;
1745: l_cure_calc_flag := l_rule_value;
1746:

Line 1766: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

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);
1769:
1770: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN

Line 1773: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,' Error in calculating repurchase');

1769:
1770: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN
1771: GET_ERROR_MESSAGE(l_error_msg_tbl);
1772: IF (l_error_msg_tbl.COUNT > 0) THEN
1773: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,' Error in calculating repurchase');
1774: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
1775: LOOP
1776: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,
1777: l_error_msg_tbl(i));

Line 1776: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,

1772: IF (l_error_msg_tbl.COUNT > 0) THEN
1773: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,' Error in calculating repurchase');
1774: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
1775: LOOP
1776: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,
1777: l_error_msg_tbl(i));
1778: END LOOP;
1779: END IF;
1780: POPULATE_LOG_TBL(