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_VENDOR_REFUND_PVT dependencies on FND_MSG_PUB

Line 9: l_msg_count := fnd_msg_pub.count_msg;

5: IS
6: l_msg_text VARCHAR2(32627);
7: l_msg_count NUMBER ;
8: BEGIN
9: l_msg_count := fnd_msg_pub.count_msg;
10: FOR i IN 1..l_msg_count
11: LOOP
12: fnd_msg_pub.get
13: (p_data => p_all_message(i),

Line 12: fnd_msg_pub.get

8: BEGIN
9: l_msg_count := fnd_msg_pub.count_msg;
10: FOR i IN 1..l_msg_count
11: LOOP
12: fnd_msg_pub.get
13: (p_data => p_all_message(i),
14: p_msg_index_out => l_msg_count,
15: p_encoded => fnd_api.g_false,
16: p_msg_index => fnd_msg_pub.g_next

Line 16: p_msg_index => fnd_msg_pub.g_next

12: fnd_msg_pub.get
13: (p_data => p_all_message(i),
14: p_msg_index_out => l_msg_count,
15: p_encoded => fnd_api.g_false,
16: p_msg_index => fnd_msg_pub.g_next
17: );
18: END LOOP;
19: EXCEPTION
20: WHEN OTHERS THEN

Line 52: FND_MSG_PUB.initialize;

48: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : Update_cure_amounts : START ');
49: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : Update_cure_amounts : p_contract_id : '||p_contract_id);
50:
51: SAVEPOINT UPDATE_CURE_AMOUNTS;
52: FND_MSG_PUB.initialize;
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Calling Cure Amount Update Api');
55:
56: --update cure amounts table

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

50:
51: SAVEPOINT UPDATE_CURE_AMOUNTS;
52: FND_MSG_PUB.initialize;
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Calling Cure Amount Update Api');
55:
56: --update cure amounts table
57: FOR i in c_get_cure_amts (p_contract_id)
58: LOOP

Line 77: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

73: l_camv_tbl(next_row).program_update_date
74: FROM DUAL;
75:
76: END LOOP;
77: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
78: 'no of records to be updated in Cure amounts '||l_camv_tbl.COUNT);
79: IF (l_camv_tbl.COUNT > 0)
80: THEN
81: OKL_cure_amounts_pub.update_cure_amounts

Line 96: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

92: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS )
93: THEN
94: RAISE Fnd_Api.G_EXC_ERROR;
95: ELSE
96: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
97: 'Updation of cure amounts is Successful');
98: END IF;
99: x_return_status := l_return_status;
100: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

96: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
97: 'Updation of cure amounts is Successful');
98: END IF;
99: x_return_status := l_return_status;
100: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
101: p_data => x_msg_data );
102: END IF;
103:
104: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : Update_cure_amounts : END ');

Line 112: Fnd_Msg_Pub.count_and_get(

108: ROLLBACK TO UPDATE_CURE_AMOUNTS;
109: x_return_status := Fnd_Api.G_RET_STS_ERROR;
110: x_msg_count := l_msg_count ;
111: x_msg_data := l_msg_data ;
112: Fnd_Msg_Pub.count_and_get(
113: p_count => x_msg_count
114: ,p_data => x_msg_data);
115: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
116: ROLLBACK TO UPDATE_CURE_AMOUNTS;

Line 120: Fnd_Msg_Pub.count_and_get(

116: ROLLBACK TO UPDATE_CURE_AMOUNTS;
117: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
118: x_msg_count := l_msg_count ;
119: x_msg_data := l_msg_data ;
120: Fnd_Msg_Pub.count_and_get(
121: p_count => x_msg_count
122: ,p_data => x_msg_data);
123: WHEN OTHERS THEN
124: ROLLBACK TO UPDATE_CURE_AMOUNTS;

Line 128: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_VENDOR_REFUND_PVT','UPDATE_CURE_AMOUNTS');

124: ROLLBACK TO UPDATE_CURE_AMOUNTS;
125: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
126: x_msg_count := l_msg_count ;
127: x_msg_data := l_msg_data ;
128: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_VENDOR_REFUND_PVT','UPDATE_CURE_AMOUNTS');
129: Fnd_Msg_Pub.count_and_get(
130: p_count => x_msg_count
131: ,p_data => x_msg_data);
132: End update_cure_amounts;

Line 129: Fnd_Msg_Pub.count_and_get(

125: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
126: x_msg_count := l_msg_count ;
127: x_msg_data := l_msg_data ;
128: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_VENDOR_REFUND_PVT','UPDATE_CURE_AMOUNTS');
129: Fnd_Msg_Pub.count_and_get(
130: p_count => x_msg_count
131: ,p_data => x_msg_data);
132: End update_cure_amounts;
133:

Line 191: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

187: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : CALC_CURE_REFUND : p_times_cured : '||p_times_cured);
188:
189: SAVEPOINT CALC_CURE_REFUND;
190:
191: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
192: 'Calc refund started for ' || p_contract_number);
193: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Before Inserting Cure Amounts');
194:
195: OPEN c_calc_refund_csr(p_contract_id);

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

189: SAVEPOINT CALC_CURE_REFUND;
190:
191: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
192: 'Calc refund started for ' || p_contract_number);
193: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Before Inserting Cure Amounts');
194:
195: OPEN c_calc_refund_csr(p_contract_id);
196: FETCH c_calc_refund_csr INTO l_negotiated_amount, l_received_amount;
197: CLOSE c_calc_refund_csr;

Line 202: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_negotiated_amount'||l_negotiated_amount);

198:
199: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : CALC_CURE_REFUND : l_negotiated_amount : '||l_negotiated_amount);
200: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : CALC_CURE_REFUND : l_received_amount : '||l_received_amount);
201:
202: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_negotiated_amount'||l_negotiated_amount);
203: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_received_amount'||l_received_amount);
204:
205: IF ((l_negotiated_amount > 0)
206: AND

Line 203: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_received_amount'||l_received_amount);

199: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : CALC_CURE_REFUND : l_negotiated_amount : '||l_negotiated_amount);
200: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : CALC_CURE_REFUND : l_received_amount : '||l_received_amount);
201:
202: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_negotiated_amount'||l_negotiated_amount);
203: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_received_amount'||l_received_amount);
204:
205: IF ((l_negotiated_amount > 0)
206: AND
207: (l_received_amount > 0)

Line 221: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

217: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : CALC_CURE_REFUND : Update_cure_amounts : '||l_return_status);
218:
219: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
220: THEN
221: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
222: 'Error Updating Cure amounts Table for contract '|| p_contract_number );
223: GET_ERROR_MESSAGE(l_error_msg_tbl);
224: IF (l_error_msg_tbl.COUNT > 0)
225: THEN

Line 228: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, l_error_msg_tbl(i));

224: IF (l_error_msg_tbl.COUNT > 0)
225: THEN
226: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
227: LOOP
228: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, l_error_msg_tbl(i));
229: END LOOP;
230: END IF; --end of l_error_msg_tbl
231: END IF; -- update_cure_amounts
232:

Line 251: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Before Inserting Cure Refunds');

247: l_crsv_rec.program_id,
248: l_crsv_rec.program_update_date
249: FROM DUAL;
250:
251: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Before Inserting Cure Refunds');
252:
253: OKL_cure_rfnd_stage_pub.insert_cure_refunds
254: ( p_api_version => p_api_version
255: ,p_init_msg_list => p_init_msg_list

Line 265: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, ' Error Inserting Cure Refunds');

261:
262: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : CALC_CURE_REFUND : OKL_cure_rfnd_stage_pub.insert_cure_refunds : '||l_return_status);
263: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS )
264: THEN
265: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, ' Error Inserting Cure Refunds');
266: RAISE Fnd_Api.G_EXC_ERROR;
267: ELSE
268: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
269: 'Done inserting cure refunds, cure received amount is '||l_received_amount || 'and negotiated amount is'||l_negotiated_amount);

Line 268: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

264: THEN
265: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM, ' Error Inserting Cure Refunds');
266: RAISE Fnd_Api.G_EXC_ERROR;
267: ELSE
268: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
269: 'Done inserting cure refunds, cure received amount is '||l_received_amount || 'and negotiated amount is'||l_negotiated_amount);
270: x_cure_amount:=l_received_amount; -- bug 6487958
271: END IF;
272: ELSE

Line 273: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

269: 'Done inserting cure refunds, cure received amount is '||l_received_amount || 'and negotiated amount is'||l_negotiated_amount);
270: x_cure_amount:=l_received_amount; -- bug 6487958
271: END IF;
272: ELSE
273: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
274: ' Cure refund received amount and negotiated amount not equal, cure refund record is not created');
275: END IF;
276:
277: x_return_status := l_return_status;

Line 279: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

275: END IF;
276:
277: x_return_status := l_return_status;
278:
279: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
280:
281: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : CALC_CURE_REFUND : END ');
282:
283: EXCEPTION

Line 289: Fnd_Msg_Pub.count_and_get(

285: ROLLBACK TO CALC_CURE_REFUND;
286: x_return_status := Fnd_Api.G_RET_STS_ERROR;
287: x_msg_count := l_msg_count ;
288: x_msg_data := l_msg_data ;
289: Fnd_Msg_Pub.count_and_get(
290: p_count => x_msg_count
291: ,p_data => x_msg_data);
292: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
293: ROLLBACK TO CALC_CURE_REFUND;

Line 297: Fnd_Msg_Pub.count_and_get(

293: ROLLBACK TO CALC_CURE_REFUND;
294: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
295: x_msg_count := l_msg_count ;
296: x_msg_data := l_msg_data ;
297: Fnd_Msg_Pub.count_and_get(
298: p_count => x_msg_count
299: ,p_data => x_msg_data);
300: WHEN OTHERS THEN
301: ROLLBACK TO CALC_CURE_REFUND;

Line 305: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_VENDOR_REFUND_PVT','CALC_CURE_REFUND');

301: ROLLBACK TO CALC_CURE_REFUND;
302: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
303: x_msg_count := l_msg_count ;
304: x_msg_data := l_msg_data ;
305: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_VENDOR_REFUND_PVT','CALC_CURE_REFUND');
306: Fnd_Msg_Pub.count_and_get(
307: p_count => x_msg_count
308: ,p_data => x_msg_data);
309: END CALC_CURE_REFUND ;

Line 306: Fnd_Msg_Pub.count_and_get(

302: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
303: x_msg_count := l_msg_count ;
304: x_msg_data := l_msg_data ;
305: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_VENDOR_REFUND_PVT','CALC_CURE_REFUND');
306: Fnd_Msg_Pub.count_and_get(
307: p_count => x_msg_count
308: ,p_data => x_msg_data);
309: END CALC_CURE_REFUND ;
310:

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

447: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : check_contract : START ');
448: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : check_contract : p_contract_id : '||p_contract_id);
449: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : check_contract : p_program_id : '||p_program_id);
450: x_return_status := FND_API.G_RET_STS_SUCCESS;
451: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start of check_contract Procedure' );
452:
453: -- Get Contract allowed value for days past due from rules
454: l_return_status := okl_contract_info.get_rule_value(
455: p_contract_id => p_program_id

Line 468: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

464:
465: IF l_return_status =FND_Api.G_RET_STS_SUCCESS
466: THEN
467: l_days_allowed :=nvl(l_rule_value,0);
468: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
469: 'Days allowed before refund is issued from Rule is ' || l_days_allowed);
470: END IF;
471: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : check_contract : l_days_allowed : '||l_days_allowed);
472:

Line 479: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

475: FETCH c_amount_past_due INTO l_non_del;
476: CLOSE c_amount_past_due;
477: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : check_contract : l_non_del : '||l_non_del);
478:
479: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
480: 'Amount Past due with grace days is ' || nvl(l_days_allowed,0));
481:
482: IF (l_non_del > 0)
483: THEN

Line 484: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

480: 'Amount Past due with grace days is ' || nvl(l_days_allowed,0));
481:
482: IF (l_non_del > 0)
483: THEN
484: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
485: 'Contract'||p_contract_number || ' is not delinquent');
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: END IF;
488:

Line 679: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'OKL Generate Cure Refund');

675: BEGIN
676: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : GENERATE_VENDOR_REFUND : START ');
677: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : GENERATE_VENDOR_REFUND : p_contract_number : '||p_contract_number);
678:
679: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'OKL Generate Cure Refund');
680: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Program Run Date:'||SYSDATE);
681: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
682: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
683: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);

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

676: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : GENERATE_VENDOR_REFUND : START ');
677: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : GENERATE_VENDOR_REFUND : p_contract_number : '||p_contract_number);
678:
679: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'OKL Generate Cure Refund');
680: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Program Run Date:'||SYSDATE);
681: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
682: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
683: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);
684: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');

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

677: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : GENERATE_VENDOR_REFUND : p_contract_number : '||p_contract_number);
678:
679: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'OKL Generate Cure Refund');
680: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Program Run Date:'||SYSDATE);
681: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
682: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
683: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);
684: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
685:

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

678:
679: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'OKL Generate Cure Refund');
680: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Program Run Date:'||SYSDATE);
681: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
682: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
683: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);
684: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
685:
686: -- Open the contract cursor for process

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

679: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'OKL Generate Cure Refund');
680: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Program Run Date:'||SYSDATE);
681: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
682: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
683: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);
684: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
685:
686: -- Open the contract cursor for process
687: FOR i IN contract_csr(p_contract_number)

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

680: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Program Run Date:'||SYSDATE);
681: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
682: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'PARAMETERS');
683: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Contract Number = ' ||p_contract_number);
684: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, '***********************************************');
685:
686: -- Open the contract cursor for process
687: FOR i IN contract_csr(p_contract_number)
688: LOOP

Line 689: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

685:
686: -- Open the contract cursor for process
687: FOR i IN contract_csr(p_contract_number)
688: LOOP
689: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
690: '***********************************************');
691: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
692: ' Processing: Contract Number=> '||i.contract_number);
693: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

Line 691: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

687: FOR i IN contract_csr(p_contract_number)
688: LOOP
689: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
690: '***********************************************');
691: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
692: ' Processing: Contract Number=> '||i.contract_number);
693: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
694: ' Program number is ' ||i.program_number);
695: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

Line 693: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

689: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
690: '***********************************************');
691: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
692: ' Processing: Contract Number=> '||i.contract_number);
693: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
694: ' Program number is ' ||i.program_number);
695: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
696: ' Contract Id is ' ||i.contract_id);
697: --need to process other contract if the first one errors out

Line 695: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

691: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
692: ' Processing: Contract Number=> '||i.contract_number);
693: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
694: ' Program number is ' ||i.program_number);
695: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
696: ' Contract Id is ' ||i.contract_id);
697: --need to process other contract if the first one errors out
698: --so introducing this while loop
699:

Line 729: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

725: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : GENERATE_VENDOR_REFUND : okl_contract_info.get_rule_value : '||l_return_status);
726:
727: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
728: THEN
729: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
730: 'Did not return a value from rule for grace days allowed before cure refund starts');
731:
732: POPULATE_LOG_TBL(
733: p_contract_number =>i.contract_number,

Line 740: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

736: P_type =>'ERROR');
737: EXIT;
738:
739: ELSE
740: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
741: 'Cure Refund grace days allowed rule exists and rule value is ' || l_rule_value);
742: END IF;
743:
744: IF (l_rule_value is null and to_number(l_rule_value) < 0)

Line 746: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

742: END IF;
743:
744: IF (l_rule_value is null and to_number(l_rule_value) < 0)
745: THEN
746: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
747: 'Cure Refund grace days allowed rule segment value does not exist and rule value is '||l_rule_value);
748: POPULATE_LOG_TBL(
749: p_contract_number =>i.contract_number,
750: p_cure_flag =>NULL,

Line 770: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,

766: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : GENERATE_VENDOR_REFUND : CHECK_CONTRACT : '||l_return_status);
767:
768: IF l_return_status = FND_API.G_RET_STS_SUCCESS
769: THEN
770: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ,
771: 'Contract ' || i.contract_number ||'is Delinquent ');
772: --jsanju added this
773: POPULATE_LOG_TBL(
774: p_contract_number =>i.contract_number,

Line 795: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,

791: x_msg_data =>l_msg_data ,
792: x_cure_amount =>l_cure_amount);
793: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : GENERATE_VENDOR_REFUND : CALC_CURE_REFUND : '||l_return_status);
794:
795: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM,
796: 'Result of Cure Refund for contract_number '||
797: i.contract_number || ' is ' ||l_return_status);
798:
799: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS)

Line 804: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,' Error in calculating Cure Refund');

800: THEN
801: GET_ERROR_MESSAGE(l_error_msg_tbl);
802: IF (l_error_msg_tbl.COUNT > 0)
803: THEN
804: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,' Error in calculating Cure Refund');
805: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
806: LOOP
807: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,l_error_msg_tbl(i));
808: END LOOP;

Line 807: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,l_error_msg_tbl(i));

803: THEN
804: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,' Error in calculating Cure Refund');
805: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
806: LOOP
807: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH,l_error_msg_tbl(i));
808: END LOOP;
809: END IF;
810: POPULATE_LOG_TBL(
811: p_contract_number =>i.contract_number,