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_API

Line 106: p_encoded => fnd_api.g_false,

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
108: );
109: END LOOP;
110: EXCEPTION

Line 136: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;

132: l_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;
133: x_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;
134: l_msg_count NUMBER;
135: l_msg_data VARCHAR2(32627);
136: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
137: next_row INTEGER;
138: l_error_msg_tbl error_message_type;
139:
140:

Line 188: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 ');
192:

Line 235: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN

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
238: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
239: 'Updation of cure amounts is Successful');

Line 236: RAISE Fnd_Api.G_EXC_ERROR;

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

Line 250: WHEN Fnd_Api.G_EXC_ERROR THEN

246: okl_debug_pub.logmessage('Update_cure_amounts : END ');
247:
248: EXCEPTION
249:
250: WHEN Fnd_Api.G_EXC_ERROR THEN
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 ;

Line 252: x_return_status := Fnd_Api.G_RET_STS_ERROR;

248: EXCEPTION
249:
250: WHEN Fnd_Api.G_EXC_ERROR THEN
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

Line 258: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 260: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 268: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

264: p_count => x_msg_count
265: ,p_data => x_msg_data);
266: WHEN OTHERS THEN
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(

Line 296: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_SUCCESS;

292:
293: l_repurchase_amount NUMBER;
294: l_api_version CONSTANT NUMBER := 1;
295: l_api_name CONSTANT VARCHAR2(30) := 'OKL_CURE_CALC_PVT';
296: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_SUCCESS;
297:
298: l_quot_rec OKL_AM_CREATE_QUOTE_PUB.quot_rec_type;
299: l_assn_tbl OKL_AM_CREATE_QUOTE_PUB.assn_tbl_type;
300: l_qpyv_tbl OKL_AM_CREATE_QUOTE_Pub.qpyv_tbl_type;

Line 361: ,p_init_msg_list =>FND_API.G_TRUE

357:
358:
359: OKL_AM_PARTIES_PVT.fetch_rule_quote_parties
360: (p_api_version =>1.0
361: ,p_init_msg_list =>FND_API.G_TRUE
362: ,x_return_status =>l_return_status
363: ,x_msg_count =>l_msg_count
364: ,x_msg_data =>l_msg_data
365: ,p_qtev_rec =>L_qtev_rec

Line 403: if l_return_status <> FND_Api.G_RET_STS_SUCCESS THEN

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',
406: p_data => l_msg_data,
407: p_msg_index_out => l_msg_index_out);

Line 410: RAISE Fnd_Api.G_EXC_ERROR;

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:
413: l_repurchase_amount := 0;
414: FOR i in x_tqlv_tbl.FIRST..x_tqlv_tbl.LAST LOOP

Line 442: WHEN Fnd_Api.G_EXC_ERROR THEN

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;
444: x_return_status := Fnd_Api.G_RET_STS_ERROR;
445: x_msg_count := l_msg_count ;
446: x_msg_data := l_msg_data ;

Line 444: x_return_status := Fnd_Api.G_RET_STS_ERROR;

440:
441: EXCEPTION
442: WHEN Fnd_Api.G_EXC_ERROR THEN
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

Line 453: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

449: ,p_data => x_msg_data);
450:
451: WHEN OTHERS THEN
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(

Line 489: l_return_status VARCHAR2(1) := FND_Api.G_RET_STS_SUCCESS;

485: l_current_due_date DATE;
486: l_contract_rate NUMBER;
487: l_months_requiring_cure NUMBER := 0;
488: l_net_investment NUMBER := 0;
489: l_return_status VARCHAR2(1) := FND_Api.G_RET_STS_SUCCESS;
490: l_last_due_date DATE;
491: l_sysdate DATE := TRUNC(SYSDATE);
492: l_id1 VARCHAR2(40);
493: l_id2 VARCHAR2(200);

Line 582: IF l_return_status =FND_Api.G_RET_STS_SUCCESS THEN

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,
585: 'l_days allowed for days past due ' || l_days_allowed);
586: END IF;

Line 612: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 686: l_return_Status VARCHAR2(1):=FND_Api.G_RET_STS_SUCCESS;

682:
683: l_contract_number okc_k_headers_b.contract_number%TYPE;
684: l_rule_name VARCHAR2(200);
685: l_rule_value VARCHAR2(2000);
686: l_return_Status VARCHAR2(1):=FND_Api.G_RET_STS_SUCCESS;
687: l_id1 VARCHAR2(40);
688: l_id2 VARCHAR2(200);
689: l_days_allowed NUMBER :=0;
690:

Line 731: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN

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;
734: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Remaining_payments is '
735: ||x_payments_remaining);

Line 756: IF l_return_status =FND_Api.G_RET_STS_SUCCESS THEN

752: ,x_id1 => l_id1
753: ,x_id2 => l_id2
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;

Line 793: p_init_msg_list IN VARCHAR2 DEFAULT FND_api.G_FALSE,

789: -- PROCEDURE CALC_CURE_REPURCHASE
790: ---------------------------------------------------------------------------
791: PROCEDURE CALC_CURE_REPURCHASE(
792: p_api_version IN NUMBER,
793: p_init_msg_list IN VARCHAR2 DEFAULT FND_api.G_FALSE,
794: p_contract_id IN NUMBER,
795: p_contract_number IN VARCHAR2,
796: p_program_id IN NUMBER,
797: p_rule_group_code IN VARCHAR2,

Line 809: l_return_status VARCHAR2(1) := FND_Api.G_RET_STS_SUCCESS;

805: )
806: IS
807:
808:
809: l_return_status VARCHAR2(1) := FND_Api.G_RET_STS_SUCCESS;
810: l_repurchase_amount NUMBER := 0;
811: l_cure_amount NUMBER := 0;
812: l_payments_remaining NUMBER := 0;
813: l_effective_date DATE;

Line 883: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN

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

Line 884: RAISE Fnd_Api.G_EXC_ERROR;

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

Line 924: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN

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;
927: x_cure_amount := l_cure_amount; -- Bug 6487958
928:

Line 925: RAISE Fnd_Api.G_EXC_ERROR;

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;
927: x_cure_amount := l_cure_amount; -- Bug 6487958
928:
929: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Cure Amount Is '

Line 977: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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 '
980: || p_contract_number );
981: GET_ERROR_MESSAGE(l_error_msg_tbl);

Line 1016: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN

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
1019: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
1020: ' Cure amount is '||x_cure_amount ||

Line 1017: RAISE Fnd_Api.G_EXC_ERROR;

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

Line 1037: WHEN Fnd_Api.G_EXC_ERROR THEN

1033: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : END ');
1034:
1035: EXCEPTION
1036:
1037: WHEN Fnd_Api.G_EXC_ERROR THEN
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 ;

Line 1039: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1035: EXCEPTION
1036:
1037: WHEN Fnd_Api.G_EXC_ERROR THEN
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

Line 1045: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1047: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 1055: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1051: p_count => x_msg_count
1052: ,p_data => x_msg_data);
1053: WHEN OTHERS THEN
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(

Line 1143: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

1139: l_id1 VARCHAR2(40);
1140: l_id2 VARCHAR2(200);
1141: l_rule_value VARCHAR2(2000);
1142: l_days_allowed NUMBER :=0;
1143: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1144:
1145:
1146:
1147: -- ASHIM CHANGE - START

Line 1203: x_return_status := FND_API.G_RET_STS_SUCCESS;

1199: l_amount_past_due NUMBER :=0;
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:

Line 1220: IF l_return_status =FND_Api.G_RET_STS_SUCCESS THEN

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,
1223: 'No of Past due days allowed from Rule is ' || l_days_allowed);
1224: END IF;

Line 1238: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1241: okl_debug_pub.logmessage('check_contract : l_amount_past_due : '||l_amount_past_due);
1242: okl_debug_pub.logmessage('check_contract : END ');

Line 1262: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_SUCCESS;

1258: )
1259: IS
1260: l_api_version CONSTANT NUMBER := 1.0;
1261: l_api_name CONSTANT VARCHAR2(30) := 'OKL_CURE_CALC_PVT';
1262: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_SUCCESS;
1263: l_msg_count NUMBER ;
1264: l_msg_data VARCHAR2(32627);
1265: l_init_msg_list VARCHAR2(1) DEFAULT fnd_api.g_false;
1266:

Line 1265: l_init_msg_list VARCHAR2(1) DEFAULT fnd_api.g_false;

1261: l_api_name CONSTANT VARCHAR2(30) := 'OKL_CURE_CALC_PVT';
1262: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_SUCCESS;
1263: l_msg_count NUMBER ;
1264: l_msg_data VARCHAR2(32627);
1265: l_init_msg_list VARCHAR2(1) DEFAULT fnd_api.g_false;
1266:
1267: l_cure_flag VARCHAR2(1);
1268: l_rule_group_code VARCHAR2(30) := 'COCURP';
1269: l_rule_code VARCHAR2(30) := 'COCURE';

Line 1437: l_return_status :=FND_Api.G_RET_STS_SUCCESS;

1433: l_no_of_cures := 0;
1434: l_no_of_cures_allowed := 0;
1435: l_repurchase_days_past_allowed := 0;
1436: l_cure_calc_flag := NULL;
1437: l_return_status :=FND_Api.G_RET_STS_SUCCESS;
1438: l_days_past :=SYSDATE;
1439: -----------------------------------------------------------------
1440: -- CHECK IF THE CONTRACT HAS CURE RULE - WE DO NOT GENERATE CURES
1441: -- FOR CONTRACT THAT DOES NOT HAVE CURE AGREEMENT

Line 1454: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1450: ,x_id1 => l_id1
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,

Line 1499: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1495: i.contract_number,
1496: l_return_status);
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 ');

Line 1513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1509: x_return_status =>l_return_status,
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);

Line 1569: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN

1565: ,x_id1 => l_id1
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(

Line 1603: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN

1599: ,x_id1 => l_id1
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,

Line 1646: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN

1642: ,x_id1 => l_id1
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,

Line 1732: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN

1728: ,x_id1 => l_id1
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,

Line 1770: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN

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
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