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_PAY_CURE_REFUNDS_PVT dependencies on OKL_PAY_CURE_REFUNDS_PVT

Line 1: PACKAGE BODY OKL_PAY_CURE_REFUNDS_PVT as

1: PACKAGE BODY OKL_PAY_CURE_REFUNDS_PVT as
2: /* $Header: OKLRPCRB.pls 120.16 2007/09/20 16:41:19 cklee noship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.cure.refund.OKL_PAY_CURE_REFUNDS_PVT';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 4: G_MODULE VARCHAR2(255) := 'okl.cure.refund.OKL_PAY_CURE_REFUNDS_PVT';

1: PACKAGE BODY OKL_PAY_CURE_REFUNDS_PVT as
2: /* $Header: OKLRPCRB.pls 120.16 2007/09/20 16:41:19 cklee noship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.cure.refund.OKL_PAY_CURE_REFUNDS_PVT';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7:
8:

Line 211: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : START ');

207:
208:
209: BEGIN
210:
211: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : START ');
212:
213: IF (G_DEBUG_ENABLED = 'Y') THEN
214: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
215: END IF;

Line 244: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tapv_rec.org_id : '||lp_tapv_rec.org_id);

240: OPEN org_id_csr ( p_pay_cure_refunds_rec.chr_id) ;
241: FETCH org_id_csr INTO lp_tapv_rec.org_id;
242: CLOSE org_id_csr;
243:
244: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tapv_rec.org_id : '||lp_tapv_rec.org_id);
245:
246: IF (lp_tapv_rec.org_id IS NULL) THEN
247: AddMissingArgMsg(
248: p_api_name => l_api_name_full,

Line 264: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tapv_rec.set_of_books_id : '||lp_tapv_rec.set_of_books_id);

260: OPEN sob_csr ( lp_tapv_rec.org_id );
261: FETCH sob_csr INTO lp_tapv_rec.set_of_books_id;
262: CLOSE sob_csr;
263:
264: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tapv_rec.set_of_books_id : '||lp_tapv_rec.set_of_books_id);
265:
266: IF (lp_tapv_rec.set_of_books_id IS NULL) THEN
267: AddMissingArgMsg(
268: p_api_name => l_api_name_full,

Line 298: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tapv_rec.try_id : '||lp_tapv_rec.try_id);

294: lp_tapv_rec.try_id);
295: END IF;
296: END IF;
297: END IF;
298: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tapv_rec.try_id : '||lp_tapv_rec.try_id);
299: lp_tapv_rec.invoice_number := NULL;
300:
301: --
302: -- display specific application error if 'OKL Lease Pay Invoices'

Line 330: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tapv_rec.invoice_number : '||lp_tapv_rec.invoice_number);

326: RAISE FND_API.G_EXC_ERROR;
327: END IF;
328: END;
329:
330: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tapv_rec.invoice_number : '||lp_tapv_rec.invoice_number);
331:
332: IF (lp_tapv_rec.invoice_number IS NULL) THEN
333: AddMissingArgMsg(
334: p_api_name => l_api_name_full,

Line 367: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tapv_rec.amount : '||lp_tapv_rec.amount);

363: lp_tapv_rec.object_version_number := 1;
364: --20-NOV-2006 ANSETHUR R12B - LEGAL ENTITY UPTAKE PROJECT
365: lp_tapv_rec.legal_entity_id := OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_pay_cure_refunds_rec.chr_id);
366:
367: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tapv_rec.amount : '||lp_tapv_rec.amount);
368: -- not sure of these 4 variable
369: /* invoice_type,
370: invoice_category_code,
371: pay_group_lookup_code,

Line 437: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tplv_rec.sty_id : '||lp_tplv_rec.sty_id);

433: END IF;
434:
435: END IF;
436:
437: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tplv_rec.sty_id : '||lp_tplv_rec.sty_id);
438: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tplv_rec.amount : '||lp_tplv_rec.amount);
439: --set error message,so this will be prefixed before the
440: --actual message, so it makes more sense than displaying an
441: -- OKL message.

Line 438: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tplv_rec.amount : '||lp_tplv_rec.amount);

434:
435: END IF;
436:
437: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tplv_rec.sty_id : '||lp_tplv_rec.sty_id);
438: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : lp_tplv_rec.amount : '||lp_tplv_rec.amount);
439: --set error message,so this will be prefixed before the
440: --actual message, so it makes more sense than displaying an
441: -- OKL message.
442: AddfailMsg(

Line 478: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : OKL_TRX_AP_INVOICES_PUB.INSERT_TRX_AP_INVOICES : '||x_return_status);

474: x_msg_count => x_msg_count,
475: x_msg_data => x_msg_data,
476: p_tapv_rec => lp_tapv_rec,
477: x_tapv_rec => lx_tapv_rec);
478: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : OKL_TRX_AP_INVOICES_PUB.INSERT_TRX_AP_INVOICES : '||x_return_status);
479: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
480: Get_Messages (l_msg_count,l_message);
481: IF PG_DEBUG <11 THEN
482: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 507: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : OKL_TXL_AP_INV_LNS_PUB.INSERT_TXL_AP_INV_LNS : '||x_return_status);

503: x_msg_count => x_msg_count,
504: x_msg_data => x_msg_data,
505: p_tplv_rec => lp_tplv_rec,
506: x_tplv_rec => lx_tplv_rec);
507: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : OKL_TXL_AP_INV_LNS_PUB.INSERT_TXL_AP_INV_LNS : '||x_return_status);
508:
509: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
510: Get_Messages (l_msg_count,l_message);
511: IF PG_DEBUG <11 THEN

Line 559: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : OKL_cure_refunds_pub.insert_cure_refunds : '||l_return_status);

555: ,x_msg_data => l_msg_data
556: ,p_crfv_rec => lp_crfv_rec
557: ,x_crfv_rec => lx_crfv_rec);
558:
559: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : OKL_cure_refunds_pub.insert_cure_refunds : '||l_return_status);
560:
561: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
562: Get_Messages (l_msg_count,l_message);
563: IF PG_DEBUG < 11 THEN

Line 588: '=>OKL_PAY_CURE_REFUNDS_PVT.'||

584: );
585:
586: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
587: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'* End of Procedure'||
588: '=>OKL_PAY_CURE_REFUNDS_PVT.'||
589: 'create_refund *');
590:
591: END IF;
592:

Line 593: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : START ');

589: 'create_refund *');
590:
591: END IF;
592:
593: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund : START ');
594:
595: EXCEPTION
596:
597: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 618: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','CREATE_REFUND');

614: ROLLBACK TO CREATE_REFUND;
615: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
616: x_msg_count := l_msg_count ;
617: x_msg_data := l_msg_data ;
618: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','CREATE_REFUND');
619: Fnd_Msg_Pub.count_and_get(
620: p_count => x_msg_count
621: ,p_data => x_msg_data);
622:

Line 681: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : START ');

677: l_idx INTEGER;
678: l_amount_past_due NUMBER;
679: BEGIN
680:
681: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : START ');
682:
683: IF (G_DEBUG_ENABLED = 'Y') THEN
684: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
685: END IF;

Line 809: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : l_contract_id : '||l_contract_id);

805: x_return_status := FND_API.G_RET_STS_SUCCESS;
806: x_contract_number:=l_contract_number;
807: EXIT;
808: END IF;
809: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : l_contract_id : '||l_contract_id);
810: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : l_contract_number : '||l_contract_number);
811:
812: -- Get Contract allowed value for days past due from rules
813: OPEN c_program_id(l_contract_id);

Line 810: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : l_contract_number : '||l_contract_number);

806: x_contract_number:=l_contract_number;
807: EXIT;
808: END IF;
809: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : l_contract_id : '||l_contract_id);
810: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : l_contract_number : '||l_contract_number);
811:
812: -- Get Contract allowed value for days past due from rules
813: OPEN c_program_id(l_contract_id);
814: FETCH c_program_id INTO l_program_id;

Line 817: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : l_program_id : '||l_program_id);

813: OPEN c_program_id(l_contract_id);
814: FETCH c_program_id INTO l_program_id;
815: CLOSE c_program_id;
816:
817: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : l_program_id : '||l_program_id);
818:
819: l_return_status := okl_contract_info.get_rule_value(
820: p_contract_id => l_program_id
821: ,p_rule_group_code => 'COCURP'

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

824: ,x_id1 => l_id1
825: ,x_id2 => l_id2
826: ,x_value => l_rule_value);
827:
828: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : okl_contract_info.get_rule_value : '||l_return_status);
829:
830: IF l_return_status =FND_Api.G_RET_STS_SUCCESS THEN
831: l_days_allowed :=nvl(l_rule_value,0);
832: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

834: 'l_days allowed for days past due ' || l_days_allowed);
835: END IF;
836: END IF;
837:
838: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : l_days_allowed : '||l_days_allowed);
839:
840: -- Get Past Due Amount
841: OPEN c_amount_past_due (l_contract_id,l_days_allowed);
842: FETCH c_amount_past_due INTO l_amount_past_due;

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

841: OPEN c_amount_past_due (l_contract_id,l_days_allowed);
842: FETCH c_amount_past_due INTO l_amount_past_due;
843: CLOSE c_amount_past_due;
844:
845: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : l_amount_past_due : '||l_amount_past_due);
846:
847: IF l_amount_past_due > 0 THEN
848: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
849: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Contract' ||l_contract_number ||

Line 864: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : END ');

860: x_return_status);
861: END IF;
862: CLOSE c_getcontracts;
863:
864: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: check_contract : END ');
865:
866: END check_contract;
867:
868: PROCEDURE populate_chr_tbl(p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type

Line 997: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : START ');

993: x_contract_number okc_k_headers_b.contract_number%TYPE;
994:
995: BEGIN
996:
997: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : START ');
998:
999: SAVEPOINT CREATE_REFUND_HDR;
1000: -- Initialize message list if p_init_msg_list is set to TRUE.
1001: IF FND_API.to_Boolean( p_init_msg_list )

Line 1024: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : l_cure_refund_header_number : '||l_cure_refund_header_number);

1020: fnd_msg_pub.add;
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023:
1024: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : l_cure_refund_header_number : '||l_cure_refund_header_number);
1025:
1026: --check if refund amount is less than total_refund_due
1027: IF nvl(p_pay_cure_refunds_rec.refund_amount,0)
1028: > nvl(p_pay_cure_refunds_rec.refund_amount_due,0) THEN

Line 1058: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : CHECK_CONTRACT : '||l_return_status);

1054: CHECK_CONTRACT(p_pay_cure_refunds_rec,
1055: l_return_status,
1056: x_contract_number);
1057:
1058: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : CHECK_CONTRACT : '||l_return_status);
1059:
1060: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1062: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Contract ' ||x_contract_number);

Line 1114: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : OKL_cure_rfnd_hdr_pub.insert_cure_rfnd_hdr : '||l_return_status);

1110: ,x_msg_data => l_msg_data
1111: ,p_chdv_rec => lp_chdv_rec
1112: ,x_chdv_rec => lx_chdv_rec);
1113:
1114: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : OKL_cure_rfnd_hdr_pub.insert_cure_rfnd_hdr : '||l_return_status);
1115:
1116: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1117: Get_Messages (l_msg_count,l_message);
1118: IF PG_DEBUG < 11 THEN

Line 1161: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : create_refund : '||l_return_status);

1157: ,x_msg_count =>l_msg_count
1158: ,x_msg_data =>l_msg_data
1159: );
1160:
1161: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : create_refund : '||l_return_status);
1162:
1163: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1164: Get_Messages (l_msg_count,l_message);
1165: IF PG_DEBUG < 11 THEN

Line 1194: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : END ');

1190: ( p_count => x_msg_count,
1191: p_data => x_msg_data
1192: );
1193:
1194: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : END ');
1195:
1196: EXCEPTION
1197:
1198: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1219: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','CREATE_REFUND_HDR');

1215: ROLLBACK TO CREATE_REFUND_HDR;
1216: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1217: x_msg_count := l_msg_count ;
1218: x_msg_data := l_msg_data ;
1219: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','CREATE_REFUND_HDR');
1220: Fnd_Msg_Pub.count_and_get(
1221: p_count => x_msg_count
1222: ,p_data => x_msg_data);
1223:

Line 1270: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : START ');

1266: lp_crfv_tbl okl_crf_pvt.crfv_tbl_type;
1267: lx_crfv_tbl okl_crf_pvt.crfv_tbl_type;
1268:
1269: BEGIN
1270: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : START ');
1271: SAVEPOINT UPDATE_REFUND_HDR;
1272:
1273: -- Initialize message list if p_init_msg_list is set to TRUE.
1274: IF FND_API.to_Boolean( p_init_msg_list )

Line 1311: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : okl_trx_ap_invoices_pub.update_trx_ap_invoices : '||l_return_status);

1307: ,x_msg_data => l_msg_data
1308: ,p_tapv_tbl => lp_tapv_tbl
1309: ,x_tapv_tbl => lx_tapv_tbl);
1310:
1311: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : okl_trx_ap_invoices_pub.update_trx_ap_invoices : '||l_return_status);
1312:
1313: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1314: Get_Messages (l_msg_count,l_message);
1315: IF PG_DEBUG <11 THEN

Line 1348: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : OKL_cure_refunds_pub.update_cure_refunds : '||l_return_status);

1344: ,x_msg_data => l_msg_data
1345: ,p_crfv_tbl => lp_crfv_tbl
1346: ,x_crfv_tbl => lx_crfv_tbl);
1347:
1348: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : OKL_cure_refunds_pub.update_cure_refunds : '||l_return_status);
1349:
1350: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1351: Get_Messages (l_msg_count,l_message);
1352: IF PG_DEBUG < 11 THEN

Line 1394: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr : '||l_return_status);

1390: ,x_msg_data => l_msg_data
1391: ,p_chdv_rec => lp_chdv_rec
1392: ,x_chdv_rec => lx_chdv_rec);
1393:
1394: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr : '||l_return_status);
1395:
1396: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1397: Get_Messages (l_msg_count,l_message);
1398: IF PG_DEBUG < 11 THEN

Line 1428: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : END ');

1424: ( p_count => x_msg_count,
1425: p_data => x_msg_data
1426: );
1427:
1428: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_hdr : END ');
1429:
1430: EXCEPTION
1431:
1432: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1453: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','UPDATE_REFUND_HDR');

1449: ROLLBACK TO UPDATE_REFUND_HDR;
1450: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1451: x_msg_count := l_msg_count ;
1452: x_msg_data := l_msg_data ;
1453: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','UPDATE_REFUND_HDR');
1454: Fnd_Msg_Pub.count_and_get(
1455: p_count => x_msg_count
1456: ,p_data => x_msg_data);
1457:

Line 1506: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : START ');

1502:
1503:
1504: BEGIN
1505:
1506: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : START ');
1507:
1508: SAVEPOINT DELETE_REFUND_HDR;
1509:
1510: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1551: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : okl_trx_ap_invoices_pub.delete_trx_ap_invoices : '||l_return_status);

1547: ,x_msg_count => l_msg_count
1548: ,x_msg_data => l_msg_data
1549: ,p_tapv_tbl => lp_tapv_tbl);
1550:
1551: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : okl_trx_ap_invoices_pub.delete_trx_ap_invoices : '||l_return_status);
1552:
1553: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1554: Get_Messages (l_msg_count,l_message);
1555: IF PG_DEBUG <11 THEN

Line 1585: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : okl_txl_ap_inv_lns_pub.delete_txl_ap_inv_lns : '||l_return_status);

1581: ,x_msg_count => l_msg_count
1582: ,x_msg_data => l_msg_data
1583: ,p_tplv_tbl => lp_tplv_tbl);
1584:
1585: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : okl_txl_ap_inv_lns_pub.delete_txl_ap_inv_lns : '||l_return_status);
1586:
1587: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1588: Get_Messages (l_msg_count,l_message);
1589: IF PG_DEBUG <11 THEN

Line 1618: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : OKL_cure_refunds_pub.delete_cure_refunds : '||l_return_status);

1614: ,x_return_status => l_return_status
1615: ,x_msg_count => l_msg_count
1616: ,x_msg_data => l_msg_data
1617: ,p_crfv_tbl => lp_crfv_tbl);
1618: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : OKL_cure_refunds_pub.delete_cure_refunds : '||l_return_status);
1619:
1620: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1621: Get_Messages (l_msg_count,l_message);
1622: IF PG_DEBUG < 11 THEN

Line 1660: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : OKL_cure_rfnd_hdr_pub.delete_cure_rfnd_hdr : '||l_return_status);

1656: ,x_msg_count => l_msg_count
1657: ,x_msg_data => l_msg_data
1658: ,p_chdv_rec => lp_chdv_rec);
1659:
1660: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : OKL_cure_rfnd_hdr_pub.delete_cure_rfnd_hdr : '||l_return_status);
1661:
1662: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1663: Get_Messages (l_msg_count,l_message);
1664: IF PG_DEBUG < 11 THEN

Line 1695: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : END ');

1691: ( p_count => x_msg_count,
1692: p_data => x_msg_data
1693: );
1694:
1695: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: delete_refund_hdr : END ');
1696: EXCEPTION
1697:
1698: WHEN Fnd_Api.G_EXC_ERROR THEN
1699: ROLLBACK TO DELETE_REFUND_HDR;

Line 1719: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','DELETE_REFUND_HDR');

1715: ROLLBACK TO DELETE_REFUND_HDR;
1716: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1717: x_msg_count := l_msg_count ;
1718: x_msg_data := l_msg_data ;
1719: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','DELETE_REFUND_HDR');
1720: Fnd_Msg_Pub.count_and_get(
1721: p_count => x_msg_count
1722: ,p_data => x_msg_data);
1723:

Line 1851: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_TAI_ACCOUNTING : START ');

1847:
1848:
1849: BEGIN
1850:
1851: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_TAI_ACCOUNTING : START ');
1852:
1853: SAVEPOINT CREATE_TAI_ACCOUNTING;
1854: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1855: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start CREATE_TAI_ACCOUNTING');

Line 2063: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_TAI_ACCOUNTING : okl_account_dist_pvt.create_accounting_dist : '||l_return_status);

2059: p_trx_header_table => 'OKL_TRX_AR_INVOICES_B'); -- 06/28/07 cklee
2060:
2061: -- R12 CHANGE - END
2062:
2063: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_TAI_ACCOUNTING : okl_account_dist_pvt.create_accounting_dist : '||l_return_status);
2064:
2065: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2066: Get_Messages (l_msg_count,l_message);
2067: IF PG_DEBUG < 11 THEN

Line 2098: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_TAI_ACCOUNTING : END ');

2094: '=>OKL_PAY_RECON_PVT.'||
2095: 'CREATE_TAI_ACCOUNTING');
2096: END IF;
2097:
2098: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_TAI_ACCOUNTING : END ');
2099:
2100: EXCEPTION
2101: WHEN Fnd_Api.G_EXC_ERROR THEN
2102: ROLLBACK TO CREATE_TAI_ACCOUNTING;

Line 2246: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : START ');

2242: l_contract_currency OKC_K_HEADERS_b.currency_code%TYPE;
2243: /*---New Code end ---*/
2244:
2245: BEGIN
2246: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : START ');
2247: SAVEPOINT SUBMIT_CURE_REFUND_HDR;
2248:
2249: -- Initialize message list if p_init_msg_list is set to TRUE.
2250: IF FND_API.to_Boolean( p_init_msg_list )

Line 2301: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : okl_trx_ap_invoices_pub.update_trx_ap_invoices : '||l_return_status);

2297: ,x_msg_data => l_msg_data
2298: ,p_tapv_tbl => lp_tapv_tbl
2299: ,x_tapv_tbl => lx_tapv_tbl);
2300:
2301: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : okl_trx_ap_invoices_pub.update_trx_ap_invoices : '||l_return_status);
2302:
2303: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2304: Get_Messages (l_msg_count,l_message);
2305: IF PG_DEBUG <11 THEN

Line 2344: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : okl_trx_ar_invoices_pub.update_trx_ar_invoices : '||l_return_status);

2340: ,x_msg_data => l_msg_data
2341: ,p_taiv_tbl => lp_taiv_tbl
2342: ,x_taiv_tbl => lx_taiv_tbl);
2343:
2344: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : okl_trx_ar_invoices_pub.update_trx_ar_invoices : '||l_return_status);
2345: -- ASHIM CHANGE - END
2346:
2347:
2348:

Line 2385: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : OKL_cure_rfnd_stage_pub.update_cure_refunds : '||l_return_status);

2381: ,x_msg_data => l_msg_data
2382: ,p_crsv_tbl => lp_crsv_tbl
2383: ,x_crsv_tbl => xp_crsv_tbl);
2384:
2385: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : OKL_cure_rfnd_stage_pub.update_cure_refunds : '||l_return_status);
2386:
2387: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2388: Get_Messages (l_msg_count,l_message);
2389: IF PG_DEBUG < 11 THEN

Line 2606: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : okl_account_dist_pvt.create_accounting_dist : '||l_return_status);

2602: p_trx_header_id => j.tap_id,
2603: p_trx_header_table => 'OKL_TRX_AP_INVOICES_B'); -- cklee 07/06/07
2604: --end: 06/04/07 cklee
2605: -- R12 CHANGE - END
2606: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : okl_account_dist_pvt.create_accounting_dist : '||l_return_status);
2607:
2608: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2609: Get_Messages (l_msg_count,l_message);
2610: IF PG_DEBUG < 11 THEN

Line 2638: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : CREATE_TAI_ACCOUNTING : '||l_return_status);

2634: x_return_status =>l_return_status,
2635: x_msg_count =>l_msg_count,
2636: x_msg_data =>l_msg_data);
2637:
2638: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : CREATE_TAI_ACCOUNTING : '||l_return_status);
2639:
2640:
2641: -- ASHIM CHANGE - END
2642:

Line 2690: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr : '||l_return_status);

2686: ,x_msg_data => l_msg_data
2687: ,p_chdv_rec => lp_chdv_rec
2688: ,x_chdv_rec => lx_chdv_rec);
2689:
2690: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr : '||l_return_status);
2691:
2692: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2693: Get_Messages (l_msg_count,l_message);
2694: IF PG_DEBUG < 11 THEN

Line 2727: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : END ');

2723: ( p_count => x_msg_count,
2724: p_data => x_msg_data
2725: );
2726:
2727: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : END ');
2728: EXCEPTION
2729:
2730: WHEN Fnd_Api.G_EXC_ERROR THEN
2731: ROLLBACK TO SUBMIT_CURE_REFUND_HDR;

Line 2751: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','SUBMIT_CURE_REFUND_HDR');

2747: ROLLBACK TO SUBMIT_CURE_REFUND_HDR;
2748: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2749: x_msg_count := l_msg_count ;
2750: x_msg_data := l_msg_data ;
2751: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','SUBMIT_CURE_REFUND_HDR');
2752: Fnd_Msg_Pub.count_and_get(
2753: p_count => x_msg_count
2754: ,p_data => x_msg_data);
2755:

Line 2894: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','GET_ROLE');

2890: ROLLBACK TO GET_ROLE;
2891: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2892: x_msg_count := l_msg_count ;
2893: x_msg_data := l_msg_data ;
2894: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','GET_ROLE');
2895: Fnd_Msg_Pub.count_and_get(
2896: p_count => x_msg_count
2897: ,p_data => x_msg_data);
2898:

Line 2959: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: invoke_refund_wf : START ');

2955: l_role_name VARCHAR2(30);
2956: l_offset_count NUMBER;
2957:
2958: BEGIN
2959: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: invoke_refund_wf : START ');
2960: IF (G_DEBUG_ENABLED = 'Y') THEN
2961: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2962: END IF;
2963:

Line 3091: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: invoke_refund_wf : END ');

3087: FND_MSG_PUB.Count_And_Get
3088: ( p_count => x_msg_count,
3089: p_data => x_msg_data
3090: );
3091: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: invoke_refund_wf : END ');
3092: EXCEPTION
3093: WHEN Fnd_Api.G_EXC_ERROR THEN
3094: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: invoke_refund_wf : Fnd_Api.G_EXC_ERROR ');
3095: ROLLBACK TO INVOKE_REFUND_WF;

Line 3094: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: invoke_refund_wf : Fnd_Api.G_EXC_ERROR ');

3090: );
3091: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: invoke_refund_wf : END ');
3092: EXCEPTION
3093: WHEN Fnd_Api.G_EXC_ERROR THEN
3094: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: invoke_refund_wf : Fnd_Api.G_EXC_ERROR ');
3095: ROLLBACK TO INVOKE_REFUND_WF;
3096: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3097: x_msg_count := l_msg_count ;
3098: x_msg_data := l_msg_data ;

Line 3104: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: invoke_refund_wf : OTHERS ');

3100: p_count => x_msg_count
3101: ,p_data => x_msg_data);
3102:
3103: WHEN OTHERS THEN
3104: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: invoke_refund_wf : OTHERS ');
3105: ROLLBACK TO INVOKE_REFUND_WF;
3106: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3107: x_msg_count := l_msg_count ;
3108: x_msg_data := l_msg_data ;

Line 3109: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','INVOKE_REFUND_WF');

3105: ROLLBACK TO INVOKE_REFUND_WF;
3106: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3107: x_msg_count := l_msg_count ;
3108: x_msg_data := l_msg_data ;
3109: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','INVOKE_REFUND_WF');
3110: Fnd_Msg_Pub.count_and_get(
3111: p_count => x_msg_count
3112: ,p_data => x_msg_data);
3113:

Line 3425: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : START ');

3421: l_bill_to_address_id NUMBER;
3422: x_primary_sty_id NUMBER;
3423:
3424: BEGIN
3425: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : START ');
3426: SAVEPOINT CREATE_CREDIT_MEMO;
3427: -- Initialize message list if p_init_msg_list is set to TRUE.
3428: FND_MSG_PUB.initialize;
3429:

Line 3489: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : lp_tilv_rec.sty_id : '||lp_tilv_rec.sty_id);

3485: p_token1 => 'COL_NAME',
3486: p_token1_value => 'Transaction Type');
3487: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3488: END IF;
3489: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : lp_tilv_rec.sty_id : '||lp_tilv_rec.sty_id);
3490: -- need to populate 4 fields. so that cure invoice gets
3491: --generated for vendor and not for the customer
3492: -- ibt_id,ixx_id,irm_id,irt_id
3493: --get cust_account from rule vendor billing set up

Line 3599: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_contract_info.get_rule_value : '||l_return_status);

3595: ,x_id1 => l_id1
3596: ,x_id2 => l_id2
3597: ,x_value => l_rule_value);
3598:
3599: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_contract_info.get_rule_value : '||l_return_status);
3600: if l_return_status =FND_Api.G_RET_STS_SUCCESS
3601: and l_id1 IS NOT NULL THEN
3602: lp_taiv_rec.irm_id :=l_id1;
3603: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3678: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_trx_ar_invoices_pub.INSERT_trx_ar_invoices : '||l_return_status);

3674: x_msg_data => l_msg_data,
3675: p_taiv_rec => lp_taiv_rec,
3676: x_taiv_rec => xp_taiv_rec);
3677:
3678: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_trx_ar_invoices_pub.INSERT_trx_ar_invoices : '||l_return_status);
3679:
3680: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3681: Get_Messages (l_msg_count,l_message);
3682: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3728: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns : '||l_return_status);

3724: x_msg_data => l_msg_data,
3725: p_tilv_rec => lp_tilv_rec,
3726: x_tilv_rec => xp_tilv_rec);
3727:
3728: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns : '||l_return_status);
3729: -- ASHIM CHANGE - END
3730:
3731:
3732:

Line 3772: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_internal_billing_pvt.Get_Invoice_format : '||l_return_status);

3768: ,p_inf_id => lp_taiv_rec.inf_id
3769: ,p_sty_id => lp_tldv_rec.STY_ID
3770: ,x_invoice_format_type => lp_tldv_rec.invoice_format_type
3771: ,x_invoice_format_line_type => lp_tldv_rec.invoice_format_line_type);
3772: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_internal_billing_pvt.Get_Invoice_format : '||l_return_status);
3773:
3774: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
3775: THEN
3776: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 3790: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : additional_tld_attr : '||l_return_status);

3786: x_msg_count => x_msg_count,
3787: x_msg_data => x_msg_data,
3788: p_tldv_rec => lp_tldv_rec,
3789: x_tldv_rec => xp_tldv_rec);
3790: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : additional_tld_attr : '||l_return_status);
3791: lp_tldv_rec := xp_tldv_rec;
3792:
3793: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3794: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3809: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_tld_pvt.insert_row : '||l_return_status);

3805: x_msg_data => x_msg_data,
3806: p_tldv_rec => lp_tldv_rec,
3807: x_tldv_rec => xp_tldv_rec);
3808:
3809: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_tld_pvt.insert_row : '||l_return_status);
3810:
3811: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3812: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3813: x_return_status := l_return_status;

Line 3852: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : OKL_cure_refunds_pub.update_cure_refunds : '||l_return_status);

3848: ,x_msg_count => l_msg_count
3849: ,x_msg_data => l_msg_data
3850: ,p_crfv_rec => lp_crfv_rec
3851: ,x_crfv_rec => lx_crfv_rec);
3852: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : OKL_cure_refunds_pub.update_cure_refunds : '||l_return_status);
3853: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3854: Get_Messages (l_msg_count,l_message);
3855: IF PG_DEBUG < 11 THEN
3856: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3880: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : END ');

3876: ( p_count => x_msg_count,
3877: p_data => x_msg_data
3878: );
3879:
3880: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : END ');
3881: EXCEPTION
3882: WHEN Fnd_Api.G_EXC_ERROR THEN
3883: ROLLBACK TO CREATE_CREDIT_MEMO;
3884: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 3903: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','CREATE_CREDIT_MEMO');

3899: ROLLBACK TO CREATE_CREDIT_MEMO;
3900: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3901: x_msg_count := l_msg_count ;
3902: x_msg_data := l_msg_data ;
3903: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','CREATE_CREDIT_MEMO');
3904: Fnd_Msg_Pub.count_and_get(
3905: p_count => x_msg_count
3906: ,p_data => x_msg_data);
3907:

Line 4017: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : START ');

4013: lX_dbseqid NUMBER(38):= NULL;
4014:
4015:
4016: BEGIN
4017: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : START ');
4018: SAVEPOINT CREATE_CUREREFUNDS;
4019: -- Initialize message list if p_init_msg_list is set to TRUE.
4020: FND_MSG_PUB.initialize;
4021:

Line 4284: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : OKL_TRX_AP_INVOICES_PUB.INSERT_TRX_AP_INVOICES : '||x_return_status);

4280: x_msg_data => x_msg_data,
4281: p_tapv_rec => lp_tapv_rec,
4282: x_tapv_rec => lx_tapv_rec);
4283:
4284: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : OKL_TRX_AP_INVOICES_PUB.INSERT_TRX_AP_INVOICES : '||x_return_status);
4285:
4286: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4287: Get_Messages (l_msg_count,l_message);
4288: IF PG_DEBUG <11 THEN

Line 4314: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : OKL_TXL_AP_INV_LNS_PUB.INSERT_TXL_AP_INV_LNS : '||x_return_status);

4310: x_msg_count => x_msg_count,
4311: x_msg_data => x_msg_data,
4312: p_tplv_rec => lp_tplv_rec,
4313: x_tplv_rec => lx_tplv_rec);
4314: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : OKL_TXL_AP_INV_LNS_PUB.INSERT_TXL_AP_INV_LNS : '||x_return_status);
4315: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4316: Get_Messages (l_msg_count,l_message);
4317: IF PG_DEBUG <11 THEN
4318: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4357: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : OKL_cure_refunds_pub.update_cure_refunds : '||x_return_status);

4353: ,x_msg_count => l_msg_count
4354: ,x_msg_data => l_msg_data
4355: ,p_crfv_rec => lp_crfv_rec
4356: ,x_crfv_rec => lx_crfv_rec);
4357: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : OKL_cure_refunds_pub.update_cure_refunds : '||x_return_status);
4358: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4359: Get_Messages (l_msg_count,l_message);
4360: IF PG_DEBUG < 11 THEN
4361: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4396: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : create_credit_memo : '||l_return_status);

4392: ,x_return_status => l_return_status
4393: ,x_msg_count => l_msg_count
4394: ,x_msg_data => l_msg_data );
4395:
4396: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : create_credit_memo : '||l_return_status);
4397:
4398: -- ASHIM CHANGE - END
4399:
4400:

Line 4435: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : END ');

4431: ( p_count => x_msg_count,
4432: p_data => x_msg_data
4433: );
4434:
4435: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_CUREREFUNDS : END ');
4436: EXCEPTION
4437: WHEN Fnd_Api.G_EXC_ERROR THEN
4438: ROLLBACK TO CREATE_CUREREFUNDS;
4439: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 4458: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','CREATE_CUREREFUNDS');

4454: ROLLBACK TO CREATE_CUREREFUNDS;
4455: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4456: x_msg_count := l_msg_count ;
4457: x_msg_data := l_msg_data ;
4458: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','CREATE_CUREREFUNDS');
4459: Fnd_Msg_Pub.count_and_get(
4460: p_count => x_msg_count
4461: ,p_data => x_msg_data);
4462:

Line 4506: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: approve_cure_refunds : START ');

4502: cure_refund_header_id =p_refund_header_id;
4503:
4504:
4505: BEGIN
4506: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: approve_cure_refunds : START ');
4507: SAVEPOINT APPROVE_CURE_REFUNDS_PVT;
4508: -- Initialize message list if p_init_msg_list is set to TRUE.
4509: IF FND_API.to_Boolean( p_init_msg_list )
4510: THEN

Line 4576: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: approve_cure_refunds : create_curerefunds : '||l_return_status);

4572: ,p_refund_header_id =>p_refund_header_id
4573: ,x_return_status => l_return_status
4574: ,x_msg_count => l_msg_count
4575: ,x_msg_data => l_msg_data );
4576: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: approve_cure_refunds : create_curerefunds : '||l_return_status);
4577:
4578: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4579: Get_Messages (l_msg_count,l_message);
4580: IF PG_DEBUG < 11 THEN

Line 4597: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: approve_cure_refunds : invoke_refund_wf : '||l_return_status);

4593: ,x_return_status => l_return_status
4594: ,x_msg_count => l_msg_count
4595: ,x_msg_data => l_msg_data );
4596:
4597: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: approve_cure_refunds : invoke_refund_wf : '||l_return_status);
4598: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4599: Get_Messages (l_msg_count,l_message);
4600: IF PG_DEBUG < 11 THEN
4601: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4631: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: approve_cure_refunds : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr : '||l_return_status);

4627: ,x_msg_data => l_msg_data
4628: ,p_chdv_rec => lp_chdv_rec
4629: ,x_chdv_rec => lx_chdv_rec);
4630:
4631: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: approve_cure_refunds : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr : '||l_return_status);
4632:
4633: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4634: Get_Messages (l_msg_count,l_message);
4635: IF PG_DEBUG < 11 THEN

Line 4667: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: approve_cure_refunds : END ');

4663: ( p_count => x_msg_count,
4664: p_data => x_msg_data
4665: );
4666:
4667: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: approve_cure_refunds : END ');
4668: EXCEPTION
4669: WHEN Fnd_Api.G_EXC_ERROR THEN
4670: ROLLBACK TO APPROVE_CURE_REFUNDS_PVT;
4671: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 4690: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','APPROVE_CURE_REFUNDS');

4686: ROLLBACK TO APPROVE_CURE_REFUNDS;
4687: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4688: x_msg_count := l_msg_count ;
4689: x_msg_data := l_msg_data ;
4690: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','APPROVE_CURE_REFUNDS');
4691: Fnd_Msg_Pub.count_and_get(
4692: p_count => x_msg_count
4693: ,p_data => x_msg_data);
4694:

Line 4747: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : START ');

4743:
4744: next_row integer;
4745: tai_next_row integer;
4746: BEGIN
4747: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : START ');
4748:
4749: SAVEPOINT SUBMIT_CURE_REFUNDS;
4750: -- Initialize message list if p_init_msg_list is set to TRUE.
4751: IF FND_API.to_Boolean( p_init_msg_list )

Line 4766: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : submit_cure_refund_hdr : '||l_return_status);

4762: ,p_refund_header_id =>p_refund_header_id
4763: ,x_return_status => l_return_status
4764: ,x_msg_count => l_msg_count
4765: ,x_msg_data => l_msg_data);
4766: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : submit_cure_refund_hdr : '||l_return_status);
4767:
4768: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4769: Get_Messages (l_msg_count,l_message);
4770: IF PG_DEBUG < 11 THEN

Line 4837: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : okl_trx_ap_invoices_pub.update_trx_ap_invoices : '||l_return_status);

4833: ,x_msg_count => l_msg_count
4834: ,x_msg_data => l_msg_data
4835: ,p_tapv_tbl => lp_tapv_tbl
4836: ,x_tapv_tbl => lx_tapv_tbl);
4837: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : okl_trx_ap_invoices_pub.update_trx_ap_invoices : '||l_return_status);
4838: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4839: Get_Messages (l_msg_count,l_message);
4840: IF PG_DEBUG <11 THEN
4841: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4878: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : okl_trx_ar_invoices_pub.update_trx_ar_invoices : '||l_return_status);

4874: ,x_msg_data => l_msg_data
4875: ,p_taiv_tbl => lp_taiv_tbl
4876: ,x_taiv_tbl => lx_taiv_tbl);
4877:
4878: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : okl_trx_ar_invoices_pub.update_trx_ar_invoices : '||l_return_status);
4879: -- ASHIM CHANGE - END
4880:
4881:
4882: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 4916: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : OKL_cure_rfnd_stage_pub.update_cure_refunds : '||l_return_status);

4912: ,x_msg_count => l_msg_count
4913: ,x_msg_data => l_msg_data
4914: ,p_crsv_tbl => lp_crsv_tbl
4915: ,x_crsv_tbl => xp_crsv_tbl);
4916: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : OKL_cure_rfnd_stage_pub.update_cure_refunds : '||l_return_status);
4917: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4918: Get_Messages (l_msg_count,l_message);
4919: IF PG_DEBUG < 11 THEN
4920: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4961: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr : '||l_return_status);

4957: ,x_msg_data => l_msg_data
4958: ,p_chdv_rec => lp_chdv_rec
4959: ,x_chdv_rec => lx_chdv_rec);
4960:
4961: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr : '||l_return_status);
4962:
4963: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4964: Get_Messages (l_msg_count,l_message);
4965: IF PG_DEBUG < 11 THEN

Line 4997: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : END ');

4993: ( p_count => x_msg_count,
4994: p_data => x_msg_data
4995: );
4996:
4997: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refunds : END ');
4998: EXCEPTION
4999: WHEN Fnd_Api.G_EXC_ERROR THEN
5000: ROLLBACK TO SUBMIT_CURE_REFUNDS;
5001: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 5020: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','SUBMIT_CURE_REFUNDS');

5016: ROLLBACK TO SUBMIT_CURE_REFUNDS;
5017: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5018: x_msg_count := l_msg_count ;
5019: x_msg_data := l_msg_data ;
5020: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','SUBMIT_CURE_REFUNDS');
5021: Fnd_Msg_Pub.count_and_get(
5022: p_count => x_msg_count
5023: ,p_data => x_msg_data);
5024:

Line 5061: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_approval_status : START ');

5057:
5058:
5059:
5060: BEGIN
5061: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_approval_status : START ');
5062:
5063: IF (G_DEBUG_ENABLED = 'Y') THEN
5064: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
5065: END IF;

Line 5084: OKL_PAY_CURE_REFUNDS_PVT.SUBMIT_CURE_REFUNDS(

5080: l_refund_header_id);
5081: END IF;
5082: END IF;
5083:
5084: OKL_PAY_CURE_REFUNDS_PVT.SUBMIT_CURE_REFUNDS(
5085: p_api_version => 1.0
5086: ,p_init_msg_list => 'T'
5087: ,p_commit => 'F'
5088: ,p_status => 'APPROVED'

Line 5094: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_approval_status : OKL_PAY_CURE_REFUNDS_PVT.SUBMIT_CURE_REFUNDS : '||l_return_status);

5090: ,x_return_status => l_return_status
5091: ,x_msg_count => l_msg_count
5092: ,x_msg_data => l_msg_data
5093: );
5094: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_approval_status : OKL_PAY_CURE_REFUNDS_PVT.SUBMIT_CURE_REFUNDS : '||l_return_status);
5095: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5096: Get_Messages (l_msg_count,l_message);
5097: IF PG_DEBUG < 11 THEN
5098: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 5137: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_approval_status : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr : '||l_return_status);

5133: ,x_msg_count => l_msg_count
5134: ,x_msg_data => l_msg_data
5135: ,p_chdv_rec => lp_chdv_rec
5136: ,x_chdv_rec => lx_chdv_rec);
5137: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_approval_status : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr : '||l_return_status);
5138: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5139: Get_Messages (l_msg_count,l_message);
5140: IF PG_DEBUG < 11 THEN
5141: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 5188: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_approval_status : END ');

5184:
5185: END IF;
5186:
5187:
5188: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_approval_status : END ');
5189:
5190: EXCEPTION
5191: WHEN FND_API.G_EXC_ERROR THEN
5192: --resultout := wf_engine.eng_completed ||':'||wf_no;

Line 5193: wf_core.context('OKL_PAY_CURE_REFUNDS_PVT',

5189:
5190: EXCEPTION
5191: WHEN FND_API.G_EXC_ERROR THEN
5192: --resultout := wf_engine.eng_completed ||':'||wf_no;
5193: wf_core.context('OKL_PAY_CURE_REFUNDS_PVT',
5194: 'set_approval_status',
5195: itemtype,
5196: itemkey,
5197: to_char(actid),

Line 5203: wf_core.context('OKL_PAY_CURE_REFUNDS_PVT',

5199: raise;
5200:
5201: when others then
5202: --resultout := wf_engine.eng_completed ||':'||wf_no;
5203: wf_core.context('OKL_PAY_CURE_REFUNDS_PVT',
5204: 'set_approval_status',
5205: itemtype,
5206: itemkey,
5207: to_char(actid),

Line 5233: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_reject_status : START ');

5229: l_refund_status okl_cure_refund_headers_b.refund_status%TYPE;
5230:
5231:
5232: BEGIN
5233: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_reject_status : START ');
5234: IF (G_DEBUG_ENABLED = 'Y') THEN
5235: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
5236: END IF;
5237:

Line 5249: OKL_PAY_CURE_REFUNDS_PVT.SUBMIT_CURE_REFUNDS(

5245: itemkey => itemkey,
5246: aname => 'CURE_REFUND_HEADER_ID');
5247:
5248:
5249: OKL_PAY_CURE_REFUNDS_PVT.SUBMIT_CURE_REFUNDS(
5250: p_api_version => 1.0
5251: ,p_init_msg_list => 'T'
5252: ,p_commit => 'F'
5253: ,p_status => 'REJECTED'

Line 5259: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_reject_status : OKL_PAY_CURE_REFUNDS_PVT.SUBMIT_CURE_REFUNDS : '||l_return_status);

5255: ,x_return_status => l_return_status
5256: ,x_msg_count => l_msg_count
5257: ,x_msg_data => l_msg_data
5258: );
5259: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_reject_status : OKL_PAY_CURE_REFUNDS_PVT.SUBMIT_CURE_REFUNDS : '||l_return_status);
5260: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5261: Get_Messages (l_msg_count,l_message);
5262: IF PG_DEBUG < 11 THEN
5263: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 5275: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_reject_status : END ');

5271: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );
5272: END IF;
5273: END IF;
5274: END IF;
5275: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_reject_status : END ');
5276: EXCEPTION
5277: WHEN FND_API.G_EXC_ERROR THEN
5278: --resultout := wf_engine.eng_completed ||':'||wf_no;
5279: wf_core.context('OKL_PAY_CURE_REFUNDS_PVT',

Line 5279: wf_core.context('OKL_PAY_CURE_REFUNDS_PVT',

5275: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: set_reject_status : END ');
5276: EXCEPTION
5277: WHEN FND_API.G_EXC_ERROR THEN
5278: --resultout := wf_engine.eng_completed ||':'||wf_no;
5279: wf_core.context('OKL_PAY_CURE_REFUNDS_PVT',
5280: 'set_reject_status',
5281: itemtype,
5282: itemkey,
5283: to_char(actid),

Line 5289: wf_core.context('OKL_PAY_CURE_REFUNDS_PVT',

5285: raise;
5286:
5287: when others then
5288: --resultout := wf_engine.eng_completed ||':'||wf_no;
5289: wf_core.context('OKL_PAY_CURE_REFUNDS_PVT',
5290: 'set_reject_status',
5291: itemtype,
5292: itemkey,
5293: to_char(actid),

Line 5336: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_headers : START ');

5332:
5333: x_contract_number okc_k_headers_b.contract_number%TYPE;
5334:
5335: BEGIN
5336: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_headers : START ');
5337: SAVEPOINT CREATE_REFUND_HEADERS;
5338: -- Initialize message list if p_init_msg_list is set to TRUE.
5339: IF FND_API.to_Boolean( p_init_msg_list )
5340: THEN

Line 5391: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_headers : OKL_cure_rfnd_hdr_pub.insert_cure_rfnd_hdr : '||l_return_status);

5387: ,x_msg_count => l_msg_count
5388: ,x_msg_data => l_msg_data
5389: ,p_chdv_rec => lp_chdv_rec
5390: ,x_chdv_rec => lx_chdv_rec);
5391: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_headers : OKL_cure_rfnd_hdr_pub.insert_cure_rfnd_hdr : '||l_return_status);
5392: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5393: Get_Messages (l_msg_count,l_message);
5394: IF PG_DEBUG < 11 THEN
5395: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 5424: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_headers : END ');

5420: ( p_count => x_msg_count,
5421: p_data => x_msg_data
5422: );
5423:
5424: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_headers : END ');
5425: EXCEPTION
5426:
5427: WHEN Fnd_Api.G_EXC_ERROR THEN
5428: ROLLBACK TO CREATE_REFUND_HEADERS;

Line 5448: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','CREATE_REFUND_HEADERS');

5444: ROLLBACK TO CREATE_REFUND_HEADERS;
5445: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5446: x_msg_count := l_msg_count ;
5447: x_msg_data := l_msg_data ;
5448: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','CREATE_REFUND_HEADERS');
5449: Fnd_Msg_Pub.count_and_get(
5450: p_count => x_msg_count
5451: ,p_data => x_msg_data);
5452:

Line 5499: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_headers : START');

5495: lp_crfv_tbl okl_crf_pvt.crfv_tbl_type;
5496: lx_crfv_tbl okl_crf_pvt.crfv_tbl_type;
5497:
5498: BEGIN
5499: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_headers : START');
5500: SAVEPOINT UPDATE_REFUND_HEADERS;
5501:
5502: -- Initialize message list if p_init_msg_list is set to TRUE.
5503: IF FND_API.to_Boolean( p_init_msg_list )

Line 5535: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_headers : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr :'||l_return_status);

5531: ,x_msg_count => l_msg_count
5532: ,x_msg_data => l_msg_data
5533: ,p_chdv_rec => lp_chdv_rec
5534: ,x_chdv_rec => lx_chdv_rec);
5535: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_headers : OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr :'||l_return_status);
5536: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5537: Get_Messages (l_msg_count,l_message);
5538: IF PG_DEBUG < 11 THEN
5539: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 5568: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_headers : END');

5564: ( p_count => x_msg_count,
5565: p_data => x_msg_data
5566: );
5567:
5568: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: update_refund_headers : END');
5569: EXCEPTION
5570:
5571: WHEN Fnd_Api.G_EXC_ERROR THEN
5572: ROLLBACK TO UPDATE_REFUND_HEADERS;

Line 5592: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','UPDATE_REFUND_HEADERS');

5588: ROLLBACK TO UPDATE_REFUND_HEADERS;
5589: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5590: x_msg_count := l_msg_count ;
5591: x_msg_data := l_msg_data ;
5592: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PVT','UPDATE_REFUND_HEADERS');
5593: Fnd_Msg_Pub.count_and_get(
5594: p_count => x_msg_count
5595: ,p_data => x_msg_data);
5596:

Line 5703: end OKL_PAY_CURE_REFUNDS_PVT;

5699:
5700: document := document||'';
5701:
5702: END gen_doc;
5703: end OKL_PAY_CURE_REFUNDS_PVT;