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 FND_LOG

Line 214: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

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;
216:
217: SAVEPOINT CREATE_REFUND;
218: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 233: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before creating TAP record ');

229: -- STEP 1
230: --populate the ap invoice header table (okl_trx_ap_invoices_b)
231: IF PG_DEBUG < 11 THEN
232: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
233: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before creating TAP record ');
234: END IF;
235: END IF;
236:
237: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 254: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.org_id '||

250: RAISE FND_API.G_EXC_ERROR;
251: ELSE
252: IF PG_DEBUG < 11 THEN
253: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
254: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.org_id '||
255: lp_tapv_rec.org_id);
256: END IF;
257: END IF;
258: END IF;

Line 274: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.set_of_books_id'||

270: RAISE FND_API.G_EXC_ERROR;
271: ELSE
272: IF PG_DEBUG < 11 THEN
273: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
274: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.set_of_books_id'||
275: lp_tapv_rec.set_of_books_id);
276: END IF;
277: END IF;
278: END IF;

Line 293: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.try_id'||

289: RAISE FND_API.G_EXC_ERROR;
290: ELSE
291: IF PG_DEBUG < 11 THEN
292: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
293: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.try_id'||
294: lp_tapv_rec.try_id);
295: END IF;
296: END IF;
297: END IF;

Line 340: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.invoice_number'||

336: RAISE FND_API.G_EXC_ERROR;
337: ELSE
338: IF PG_DEBUG < 11 THEN
339: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
340: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.invoice_number'||
341: lp_tapv_rec.invoice_number);
342: END IF;
343: END IF;
344:

Line 422: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

418: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS or x_primary_sty_id is null) THEN
419: Get_Messages (l_msg_count,l_message);
420: IF PG_DEBUG < 11 THEN
421: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
422: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
423: END IF;
424: END IF;
425: raise FND_API.G_EXC_ERROR;
426:

Line 431: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sty_id ' ||x_primary_sty_id);

427: ELSE
428:
429: IF PG_DEBUG < 11 THEN
430: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
431: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sty_id ' ||x_primary_sty_id);
432: END IF;
433: END IF;
434:
435: END IF;

Line 483: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
483: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
484: END IF;
485: END IF;
486: raise FND_API.G_EXC_ERROR;
487: ELSE

Line 490: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tapv_rec.id'

486: raise FND_API.G_EXC_ERROR;
487: ELSE
488: IF PG_DEBUG < 11 THEN
489: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
490: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tapv_rec.id'
491: ||lx_tapv_rec.id);
492: END IF;
493: END IF;
494: FND_MSG_PUB.initialize;

Line 513: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
512: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
513: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
514: END IF;
515: END IF;
516: raise FND_API.G_EXC_ERROR;
517: ELSE

Line 520: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tplv_rec.id'

516: raise FND_API.G_EXC_ERROR;
517: ELSE
518: IF PG_DEBUG < 11 THEN
519: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
520: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tplv_rec.id'
521: ||lx_tplv_rec.id);
522: END IF;
523: END IF;
524: FND_MSG_PUB.initialize;

Line 565: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
564: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
565: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
566: END IF;
567: END IF;
568: raise FND_API.G_EXC_ERROR;
569: ELSE

Line 571: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_crfv_rec.cure_refund_id'

567: END IF;
568: raise FND_API.G_EXC_ERROR;
569: ELSE
570: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
571: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_crfv_rec.cure_refund_id'
572: ||lx_crfv_rec.cure_refund_id);
573: END IF;
574: x_cure_refund_id :=lx_crfv_rec.cure_refund_id;
575: END IF;

Line 587: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'* End of Procedure'||

583: p_data => x_msg_data
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;

Line 684: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

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;
686:
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 689: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Start of check_contract' );

685: END IF;
686:
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
689: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Start of check_contract' );
690:
691: END IF;
692: IF p_pay_cure_refunds_rec.chr_id is not null THEN
693: -- then check for this contract only

Line 718: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'in else part of ref cursor for check contract' );

714: and st.khr_id = p_pay_cure_refunds_rec.chr_id;
715: --end changed by abhsaxen for Bug#6174484
716: ELSE
717: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
718: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'in else part of ref cursor for check contract' );
719: END IF;
720: --check for other 2 types;
721: if p_pay_cure_refunds_rec.REFUND_TYPE ='VENDOR_SITE' THEN
722: OPEN c_getcontracts

Line 803: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'coming out from the cursor');

799: FETCH c_getcontracts INTO l_contract_id,l_contract_number;
800:
801: IF c_getcontracts%NOTFOUND THEN
802: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
803: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'coming out from the cursor');
804: END IF;
805: x_return_status := FND_API.G_RET_STS_SUCCESS;
806: x_contract_number:=l_contract_number;
807: EXIT;

Line 833: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,

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
833: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,
834: 'l_days allowed for days past due ' || l_days_allowed);
835: END IF;
836: END IF;
837:

Line 849: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Contract' ||l_contract_number ||

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 ||
850: ' is delinquent');
851: END IF;
852: x_return_status := FND_API.G_RET_STS_ERROR;
853: x_contract_number:=l_contract_number;

Line 859: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Result of check Contract is '||

855: END IF;
856:
857: END LOOP;
858: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
859: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Result of check Contract is '||
860: x_return_status);
861: END IF;
862: CLOSE c_getcontracts;
863:

Line 886: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

882: l_refund_amount_due okl_cure_refunds_dtls_uv.refund_amount_due%TYPE;
883:
884: BEGIN
885: IF (G_DEBUG_ENABLED = 'Y') THEN
886: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
887: END IF;
888: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
889: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Start of populate_chr_tbl' );
890:

Line 889: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Start of populate_chr_tbl' );

885: IF (G_DEBUG_ENABLED = 'Y') THEN
886: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
887: END IF;
888: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
889: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Start of populate_chr_tbl' );
890:
891: END IF;
892: total_rfnd_amt := p_pay_cure_refunds_rec.refund_amount;
893:

Line 916: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'coming out from the cursor');

912: LOOP
913: FETCH c_getcontracts INTO l_contract_id,l_refund_amount_due;
914: IF c_getcontracts%NOTFOUND THEN
915: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
916: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'coming out from the cursor');
917: END IF;
918: EXIT;
919: END IF;
920: con_rfnd_amt := 0;

Line 939: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'contract id '||x_pay_tbl(l_idx).chr_id ||

935: x_pay_tbl(l_idx).refund_amount_due :=l_refund_amount_due;
936: x_pay_tbl(l_idx).refund_amount :=con_rfnd_amt;
937:
938: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
939: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'contract id '||x_pay_tbl(l_idx).chr_id ||
940: ' refund_amount_due '||
941: x_pay_tbl(l_idx).refund_amount_due ||
942: ' refund_amount '||
943: x_pay_tbl(l_idx).refund_amount);

Line 947: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'amount exhausted');

943: x_pay_tbl(l_idx).refund_amount);
944: END IF;
945: ELSE
946: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
947: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'amount exhausted');
948: END IF;
949: EXIT;
950: END IF;
951:

Line 1016: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'duplicate refund number' );

1012: if l_cure_refund_header_number IS NOT NULL THEN
1013:
1014: IF PG_DEBUG < 11 THEN
1015: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1016: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'duplicate refund number' );
1017: END IF;
1018: END IF;
1019: fnd_message.set_name('OKL', 'OKL_DUPLICATE_REFUND_NUMBER');
1020: fnd_msg_pub.add;

Line 1031: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Refund amount exceeds 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
1029: IF PG_DEBUG < 11 THEN
1030: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1031: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Refund amount exceeds total refund due' );
1032: END IF;
1033: END IF;
1034: fnd_message.set_name('OKL', 'OKL_CURE_REFUND_EXCEEDS');
1035: fnd_msg_pub.add;

Line 1041: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before calling create refund');

1037: END IF;
1038:
1039: IF PG_DEBUG < 11 THEN
1040: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1041: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before calling create refund');
1042: END IF;
1043: END IF;
1044:
1045:

Line 1062: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Contract ' ||x_contract_number);

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);
1063: END IF;
1064: fnd_message.set_name('OKL', 'OKL_CO_CONTRACT_DELINQUENT');
1065: fnd_message.set_token('CONTRACT_NUMBER', x_contract_number);
1066: fnd_msg_pub.add;

Line 1120: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
1119: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1120: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
1121: END IF;
1122: END IF;
1123: raise FND_API.G_EXC_ERROR;
1124: ELSE

Line 1126: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_chdv_rec.cure_refund_header_id'

1122: END IF;
1123: raise FND_API.G_EXC_ERROR;
1124: ELSE
1125: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1126: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_chdv_rec.cure_refund_header_id'
1127: ||lx_chdv_rec.cure_refund_header_id);
1128: END IF;
1129: l_pay_cure_refunds_rec.refund_header_id :=
1130: lx_chdv_rec.cure_refund_header_id;

Line 1150: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_pay_cure_refunds_rec.refund_TYPE'||

1146: l_pay_cure_refunds_rec.refund_amount_due:=x_pay_tbl(i).refund_amount_due;
1147: l_pay_cure_refunds_rec.refund_amount:=x_pay_tbl(i).refund_amount;
1148: l_pay_cure_refunds_rec.chr_id :=x_pay_tbl(i).chr_id;
1149: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1150: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_pay_cure_refunds_rec.refund_TYPE'||
1151: l_pay_cure_refunds_rec.refund_TYPE);
1152: END IF;
1153: create_refund
1154: (p_pay_cure_refunds_rec => l_pay_cure_refunds_rec

Line 1167: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
1166: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1167: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
1168: END IF;
1169: END IF;
1170: raise FND_API.G_EXC_ERROR;
1171: ELSE

Line 1173: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cure_refund_id'

1169: END IF;
1170: raise FND_API.G_EXC_ERROR;
1171: ELSE
1172: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1173: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cure_refund_id'
1174: ||l_cure_refund_id);
1175: END IF;
1176: END IF;
1177:

Line 1297: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'no of records to be updated in TAP'||

1293: END LOOP;
1294:
1295: IF PG_DEBUG <11 THEN
1296: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1297: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'no of records to be updated in TAP'||
1298: lp_tapv_tbl.COUNT);
1299: END IF;
1300: END IF;
1301:

Line 1317: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
1316: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1317: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
1318: END IF;
1319: END IF;
1320: raise FND_API.G_EXC_ERROR;
1321: ELSE

Line 1324: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated tap records');

1320: raise FND_API.G_EXC_ERROR;
1321: ELSE
1322: IF PG_DEBUG < 11 THEN
1323: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1324: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated tap records');
1325: END IF;
1326: END IF;
1327: FND_MSG_PUB.initialize;
1328: END IF;

Line 1354: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
1353: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1354: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
1355: END IF;
1356: END IF;
1357: raise FND_API.G_EXC_ERROR;
1358: ELSE

Line 1361: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated CRF records');

1357: raise FND_API.G_EXC_ERROR;
1358: ELSE
1359: IF PG_DEBUG < 11 THEN
1360: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1361: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated CRF records');
1362: END IF;
1363: END IF;
1364: FND_MSG_PUB.initialize;
1365: END IF;

Line 1400: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
1399: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1400: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
1401: END IF;
1402: END IF;
1403: raise FND_API.G_EXC_ERROR;
1404: ELSE

Line 1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Successfully updated Cure refund '||

1402: END IF;
1403: raise FND_API.G_EXC_ERROR;
1404: ELSE
1405: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Successfully updated Cure refund '||
1407: 'header table');
1408:
1409: END IF;
1410: END IF;

Line 1538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'no of records to be updated in TAP'||

1534: END LOOP;
1535:
1536: IF PG_DEBUG <11 THEN
1537: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'no of records to be updated in TAP'||
1539: lp_tapv_tbl.COUNT);
1540: END IF;
1541: END IF;
1542:

Line 1557: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
1556: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1557: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
1558: END IF;
1559: END IF;
1560: raise FND_API.G_EXC_ERROR;
1561: ELSE

Line 1564: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully deleted tap records');

1560: raise FND_API.G_EXC_ERROR;
1561: ELSE
1562: IF PG_DEBUG < 11 THEN
1563: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1564: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully deleted tap records');
1565: END IF;
1566: END IF;
1567: FND_MSG_PUB.initialize;
1568: END IF;

Line 1591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
1590: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
1592: END IF;
1593: END IF;
1594: raise FND_API.G_EXC_ERROR;
1595: ELSE

Line 1598: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully deleted tap records');

1594: raise FND_API.G_EXC_ERROR;
1595: ELSE
1596: IF PG_DEBUG < 11 THEN
1597: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1598: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully deleted tap records');
1599: END IF;
1600: END IF;
1601: FND_MSG_PUB.initialize;
1602: END IF;

Line 1624: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
1623: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1624: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
1625: END IF;
1626: END IF;
1627: raise FND_API.G_EXC_ERROR;
1628: ELSE

Line 1631: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully deleted CRF records');

1627: raise FND_API.G_EXC_ERROR;
1628: ELSE
1629: IF PG_DEBUG < 11 THEN
1630: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1631: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully deleted CRF records');
1632: END IF;
1633: END IF;
1634: FND_MSG_PUB.initialize;
1635: END IF;

Line 1666: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
1665: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1666: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
1667: END IF;
1668: END IF;
1669: raise FND_API.G_EXC_ERROR;
1670: ELSE

Line 1672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Successfully deleted Cure refund '||

1668: END IF;
1669: raise FND_API.G_EXC_ERROR;
1670: ELSE
1671: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Successfully deleted Cure refund '||
1673: 'header table');
1674:
1675: END IF;
1676: END IF;

Line 1855: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start CREATE_TAI_ACCOUNTING');

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');
1856:
1857: END IF;
1858: x_return_status := FND_API.G_RET_STS_SUCCESS;
1859:

Line 1875: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'product_id '

1871: raise FND_API.G_EXC_ERROR;
1872: END IF;
1873: IF PG_DEBUG < 11 THEN
1874: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1875: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'product_id '
1876: ||l_tmpl_identify_tbl(1).product_id);
1877: END IF;
1878: END IF;
1879: END LOOP;

Line 1980: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_acc_gen_primary_key_tbl for TAI'

1976: ELSE
1977: FND_MSG_PUB.initialize;
1978: IF PG_DEBUG < 11 THEN
1979: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1980: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_acc_gen_primary_key_tbl for TAI'
1981: ||l_acc_gen_primary_key_tbl(1).acc_gen_key_tbl.count
1982: ||l_acc_gen_primary_key_tbl(1).acc_gen_key_tbl(1).primary_key_column
1983: ||l_acc_gen_primary_key_tbl(1).acc_gen_key_tbl(1).source_table );
1984: END IF;

Line 2069: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
2068: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2069: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
2070: END IF;
2071: END IF;
2072: raise FND_API.G_EXC_ERROR;
2073: ELSE

Line 2075: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_template_tbl'||l_template_tbl.count);

2071: END IF;
2072: raise FND_API.G_EXC_ERROR;
2073: ELSE
2074: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2075: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_template_tbl'||l_template_tbl.count);
2076: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_amount_tbl'||l_amount_tbl.count);
2077: END IF;
2078: FND_MSG_PUB.initialize;
2079: END IF;

Line 2076: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_amount_tbl'||l_amount_tbl.count);

2072: raise FND_API.G_EXC_ERROR;
2073: ELSE
2074: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2075: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_template_tbl'||l_template_tbl.count);
2076: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_amount_tbl'||l_amount_tbl.count);
2077: END IF;
2078: FND_MSG_PUB.initialize;
2079: END IF;
2080:

Line 2085: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'after accounting dist '||l_return_status);

2081: END LOOP; -- for c_get_accounting cursor
2082:
2083:
2084: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2085: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'after accounting dist '||l_return_status);
2086:
2087: END IF;
2088: FND_MSG_PUB.Count_And_Get
2089: ( p_count => x_msg_count,

Line 2093: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' End of Procedure'||

2089: ( p_count => x_msg_count,
2090: p_data => x_msg_data
2091: );
2092: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2093: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' End of Procedure'||
2094: '=>OKL_PAY_RECON_PVT.'||
2095: 'CREATE_TAI_ACCOUNTING');
2096: END IF;
2097:

Line 2287: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'no of records to be updated in TAP'||

2283:
2284:
2285: IF PG_DEBUG <11 THEN
2286: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2287: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'no of records to be updated in TAP'||
2288: lp_tapv_tbl.COUNT);
2289: END IF;
2290: END IF;
2291:

Line 2307: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
2306: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2307: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
2308: END IF;
2309: END IF;
2310: raise FND_API.G_EXC_ERROR;
2311: ELSE

Line 2314: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated tap records');

2310: raise FND_API.G_EXC_ERROR;
2311: ELSE
2312: IF PG_DEBUG < 11 THEN
2313: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2314: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated tap records');
2315: END IF;
2316: END IF;
2317: FND_MSG_PUB.initialize;
2318: END IF;

Line 2353: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

2349: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2350: Get_Messages (l_msg_count,l_message);
2351: IF PG_DEBUG <11 THEN
2352: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2353: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
2354: END IF;
2355: END IF;
2356: raise FND_API.G_EXC_ERROR;
2357: ELSE

Line 2360: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated tai records');

2356: raise FND_API.G_EXC_ERROR;
2357: ELSE
2358: IF PG_DEBUG < 11 THEN
2359: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2360: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated tai records');
2361: END IF;
2362: END IF;
2363: FND_MSG_PUB.initialize;
2364: END IF;

Line 2391: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
2390: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2391: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
2392: END IF;
2393: END IF;
2394: raise FND_API.G_EXC_ERROR;
2395: ELSE

Line 2398: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund stage' );

2394: raise FND_API.G_EXC_ERROR;
2395: ELSE
2396: IF PG_DEBUG < 11 THEN
2397: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2398: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund stage' );
2399: END IF;
2400: END IF;
2401: FND_MSG_PUB.initialize;
2402: END IF;

Line 2418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'product_id '

2414: l_tmpl_identify_tbl(1).product_id := i.pdt_id;
2415: l_acc_gen_primary_key_tbl(1).source_id := j.id; -- cklee 06/29/07
2416: IF PG_DEBUG < 11 THEN
2417: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'product_id '
2419: ||l_tmpl_identify_tbl(1).product_id);
2420: END IF;
2421: END IF;
2422: END LOOP;

Line 2493: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

2489: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2490: Get_Messages (l_msg_count,l_message);
2491: IF PG_DEBUG < 11 THEN
2492: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2493: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
2494: END IF;
2495: END IF;
2496: raise FND_API.G_EXC_ERROR;
2497: ELSE

Line 2500: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -Okl_Securitization_Pvt.check_khr_ia_associated' );

2496: raise FND_API.G_EXC_ERROR;
2497: ELSE
2498: IF PG_DEBUG < 11 THEN
2499: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2500: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -Okl_Securitization_Pvt.check_khr_ia_associated' );
2501: END IF;
2502: END IF;
2503: FND_MSG_PUB.initialize;
2504: END IF;

Line 2554: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_acc_gen_primary_key_tbl'

2550: ELSE
2551: FND_MSG_PUB.initialize;
2552: IF PG_DEBUG < 11 THEN
2553: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2554: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_acc_gen_primary_key_tbl'
2555: ||l_acc_gen_primary_key_tbl(1).acc_gen_key_tbl.count
2556: ||l_acc_gen_primary_key_tbl(1).acc_gen_key_tbl(1).primary_key_column
2557: ||l_acc_gen_primary_key_tbl(1).acc_gen_key_tbl(1).source_table );
2558: END IF;

Line 2612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
2611: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
2613: END IF;
2614: END IF;
2615: raise FND_API.G_EXC_ERROR;
2616: ELSE

Line 2618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_template_tbl for tap '||l_template_tbl.count);

2614: END IF;
2615: raise FND_API.G_EXC_ERROR;
2616: ELSE
2617: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_template_tbl for tap '||l_template_tbl.count);
2619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_amount_tbl for tap '||l_amount_tbl.count);
2620: END IF;
2621: FND_MSG_PUB.initialize;
2622: END IF;

Line 2619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_amount_tbl for tap '||l_amount_tbl.count);

2615: raise FND_API.G_EXC_ERROR;
2616: ELSE
2617: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_template_tbl for tap '||l_template_tbl.count);
2619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_amount_tbl for tap '||l_amount_tbl.count);
2620: END IF;
2621: FND_MSG_PUB.initialize;
2622: END IF;
2623:

Line 2648: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

2644: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2645: Get_Messages (l_msg_count,l_message);
2646: IF PG_DEBUG < 11 THEN
2647: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2648: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
2649: END IF;
2650: END IF;
2651: raise FND_API.G_EXC_ERROR;
2652: ELSE

Line 2655: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -created accounting for tai records');

2651: raise FND_API.G_EXC_ERROR;
2652: ELSE
2653: IF PG_DEBUG < 11 THEN
2654: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2655: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -created accounting for tai records');
2656: END IF;
2657: END IF;
2658: FND_MSG_PUB.initialize;
2659: END IF;

Line 2663: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before updating cure refund header table');

2659: END IF;
2660:
2661: IF PG_DEBUG <11 THEN
2662: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2663: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before updating cure refund header table');
2664: END IF;
2665: END IF;
2666:
2667: --set error message,so this will be prefixed before the

Line 2696: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
2695: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2696: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
2697: END IF;
2698: END IF;
2699: raise FND_API.G_EXC_ERROR;
2700: ELSE

Line 2703: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Successfully updated Cure refund '||

2699: raise FND_API.G_EXC_ERROR;
2700: ELSE
2701: IF PG_DEBUG < 11 THEN
2702: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2703: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Successfully updated Cure refund '||
2704: 'header table');
2705: END IF;
2706: END IF;
2707:

Line 2814: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

2810: and rownum <2;
2811:
2812: BEGIN
2813: IF (G_DEBUG_ENABLED = 'Y') THEN
2814: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2815: END IF;
2816:
2817: x_return_status := FND_API.G_RET_STS_SUCCESS;
2818: SAVEPOINT GET_ROLE;

Line 2829: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Email Address ' ||l_email ||

2825: END LOOP;
2826:
2827: IF PG_DEBUG < 11 THEN
2828: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2829: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Email Address ' ||l_email ||
2830: ' Role ' ||l_role_name||
2831: ' Role Display ' ||l_role_display_name);
2832: END IF;
2833: END IF;

Line 2961: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

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:
2964: x_return_status := FND_API.G_RET_STS_SUCCESS;
2965: --set error message,so this will be prefixed before the

Line 2980: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Event Key ' ||l_key);

2976: l_key := l_event_name ||'-'||l_seq;
2977:
2978: IF PG_DEBUG < 11 THEN
2979: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2980: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Event Key ' ||l_key);
2981: END IF;
2982: END IF;
2983:
2984: OPEN c_get_ref_details (p_refund_header_id );

Line 3051: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

3047: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3048: Get_Messages (l_msg_count,l_message);
3049: IF PG_DEBUG < 11 THEN
3050: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3051: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
3052: END IF;
3053: END IF;
3054: raise FND_API.G_EXC_ERROR;
3055: END IF;

Line 3068: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before launching workflow');

3064: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
3065:
3066:
3067: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3068: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before launching workflow');
3069:
3070: END IF;
3071: wf_event.raise(p_event_name => l_event_name
3072: ,p_event_key => l_key

Line 3082: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Successfully launched Cure refund workflow');

3078:
3079:
3080: IF PG_DEBUG < 11 THEN
3081: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3082: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Successfully launched Cure refund workflow');
3083: END IF;
3084: END IF;
3085:
3086:

Line 3187: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

3183: begin
3184: -- Set API savepoint
3185: SAVEPOINT additional_tld_attr;
3186: IF (G_DEBUG_ENABLED = 'Y') THEN
3187: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3188: END IF;
3189: --Print Input Variables
3190: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3191: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_tldv_rec.id :'||p_tldv_rec.id);

Line 3191: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_tldv_rec.id :'||p_tldv_rec.id);

3187: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3188: END IF;
3189: --Print Input Variables
3190: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3191: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_tldv_rec.id :'||p_tldv_rec.id);
3192: END IF;
3193: -- Check for call compatibility
3194: IF (NOT FND_API.Compatible_API_Call (l_api_version,
3195: p_api_version,

Line 3452: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'trxid '||lp_taiv_rec.try_id);

3448: FETCH get_trx_id INTO lp_taiv_rec.try_id;
3449: CLOSE get_trx_id;
3450:
3451: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3452: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'trxid '||lp_taiv_rec.try_id);
3453:
3454: END IF;
3455: IF lp_taiv_rec.try_id IS NULL THEN
3456: OKL_API.SET_MESSAGE (

Line 3478: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'sty_id '||lp_tilv_rec.sty_id);

3474: );
3475:
3476: lp_tilv_rec.sty_id := x_primary_sty_id;
3477: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3478: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'sty_id '||lp_tilv_rec.sty_id);
3479:
3480: END IF;
3481: IF lp_tilv_rec.sty_id IS NULL THEN
3482: OKL_API.SET_MESSAGE (

Line 3507: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'program Id' ||l_program_id);

3503: p_token1_value => 'Vendor Program');
3504: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3505: END IF;
3506: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3507: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'program Id' ||l_program_id);
3508:
3509:
3510: END IF;
3511:

Line 3519: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Retrieval of Bill To Address Id failed');

3515: CLOSE bill_to_csr;
3516:
3517: IF trunc(l_bill_to_address_id) IS NULL THEN
3518: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3519: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Retrieval of Bill To Address Id failed');
3520: END IF;
3521: OKL_API.SET_MESSAGE (
3522: p_app_name => 'OKL',
3523: p_msg_name => 'OKL_REQUIRED_VALUE',

Line 3530: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Bill to address id from rule is ' || l_btc_id);

3526: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3527: END IF;
3528: l_btc_id :=l_bill_to_address_id;
3529: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3530: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Bill to address id from rule is ' || l_btc_id);
3531:
3532: END IF;
3533: -- *****************************************************
3534: -- Extract Customer, Bill To and Payment Term from rules

Line 3604: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Payment method from rule is ' || l_id1);

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
3604: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Payment method from rule is ' || l_id1);
3605: END IF;
3606: else
3607: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Retrieval of Payment Method Id failed');

Line 3608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Retrieval of Payment Method Id failed');

3604: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Payment method from rule is ' || l_id1);
3605: END IF;
3606: else
3607: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Retrieval of Payment Method Id failed');
3609: END IF;
3610: OKL_API.SET_MESSAGE (
3611: p_app_name => 'OKL',
3612: p_msg_name => 'OKL_REQUIRED_VALUE',

Line 3625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'receipt method id is not found');

3621:
3622: IF lp_taiv_rec.irm_id IS NULL
3623: OR lp_taiv_rec.irm_id = FND_API.G_MISS_NUM THEN
3624: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'receipt method id is not found');
3626: END IF;
3627: OKL_API.SET_MESSAGE (
3628: p_app_name => 'OKL',
3629: p_msg_name => 'OKL_REQUIRED_VALUE',

Line 3655: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'taiv_rec.cpy_id' ||lp_taiv_rec.cpy_id ||

3651: -- R12 Changes - END
3652:
3653:
3654: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3655: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'taiv_rec.cpy_id' ||lp_taiv_rec.cpy_id ||
3656: ' taiv_rec.try_id' ||lp_taiv_rec.try_id||
3657: ' taiv_rec.khr_id' ||lp_taiv_rec.khr_id||
3658: ' taiv_rec.irm_id'||lp_taiv_rec.irm_id||
3659: ' taiv_rec.ibt_id'||lp_taiv_rec.ibt_id||

Line 3683: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error in updating okl_trx_ar_invoices_b '

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
3683: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error in updating okl_trx_ar_invoices_b '
3684: ||l_message);
3685: END IF;
3686: raise FND_API.G_EXC_ERROR;
3687: ELSE

Line 3713: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'tilv_rec.tai_id' ||lp_tilv_rec.tai_id||

3709:
3710: -- R12 Change - END
3711:
3712: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3713: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'tilv_rec.tai_id' ||lp_tilv_rec.tai_id||
3714: 'tilv_rec.amount' ||lp_tilv_rec.amount||
3715: 'tilv_rec.sty_id' ||lp_tilv_rec.sty_id);
3716:
3717:

Line 3736: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error in updating okl_txl_ar_inv_lns '

3732:
3733: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3734: Get_Messages (l_msg_count,l_message);
3735: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3736: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error in updating okl_txl_ar_inv_lns '
3737: ||l_message);
3738: END IF;
3739: raise FND_API.G_EXC_ERROR;
3740: ELSE

Line 3857: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
3857: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
3858: END IF;
3859: END IF;
3860: raise FND_API.G_EXC_ERROR;
3861: ELSE

Line 3864: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated CRF records');

3860: raise FND_API.G_EXC_ERROR;
3861: ELSE
3862: IF PG_DEBUG < 11 THEN
3863: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3864: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated CRF records');
3865: END IF;
3866: END IF;
3867: FND_MSG_PUB.initialize;
3868: END IF;

Line 4032: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.org_id '||

4028: RAISE FND_API.G_EXC_ERROR;
4029: ELSE
4030: IF PG_DEBUG < 11 THEN
4031: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4032: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.org_id '||
4033: lp_tapv_rec.org_id);
4034: END IF;
4035: END IF;
4036: END IF;

Line 4046: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'update cure refunds ');

4042: -- STEP 1
4043: --populate the ap invoice header table (okl_trx_ap_invoices_b)
4044: IF PG_DEBUG < 11 THEN
4045: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4046: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'update cure refunds ');
4047: END IF;
4048: END IF;
4049:
4050:

Line 4055: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before creating TAP record ');

4051: -- STEP 1
4052: --populate the ap invoice header table (okl_trx_ap_invoices_b)
4053: IF PG_DEBUG < 11 THEN
4054: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4055: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before creating TAP record ');
4056: END IF;
4057: END IF;
4058:
4059:

Line 4075: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.org_id '||

4071: RAISE FND_API.G_EXC_ERROR;
4072: ELSE
4073: IF PG_DEBUG < 11 THEN
4074: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4075: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.org_id '||
4076: lp_tapv_rec.org_id);
4077: END IF;
4078: END IF;
4079: END IF;

Line 4093: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.set_of_books_id'||

4089: RAISE FND_API.G_EXC_ERROR;
4090: ELSE
4091: IF PG_DEBUG < 11 THEN
4092: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4093: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.set_of_books_id'||
4094: lp_tapv_rec.set_of_books_id);
4095: END IF;
4096: END IF;
4097: END IF;

Line 4112: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.try_id'||

4108: RAISE FND_API.G_EXC_ERROR;
4109: ELSE
4110: IF PG_DEBUG < 11 THEN
4111: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4112: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.try_id'||
4113: lp_tapv_rec.try_id);
4114: END IF;
4115: END IF;
4116: END IF;

Line 4156: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.invoice_number'||

4152: RAISE FND_API.G_EXC_ERROR;
4153: ELSE
4154: IF PG_DEBUG < 11 THEN
4155: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4156: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lp_tapv_rec.invoice_number'||
4157: lp_tapv_rec.invoice_number);
4158: END IF;
4159: END IF;
4160:

Line 4234: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

4230: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4231: Get_Messages (l_msg_count,l_message);
4232: IF PG_DEBUG < 11 THEN
4233: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4234: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
4235: END IF;
4236: END IF;
4237: raise FND_API.G_EXC_ERROR;
4238:

Line 4243: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sty_id ' ||x_primary_sty_id);

4239: ELSE
4240:
4241: IF PG_DEBUG < 11 THEN
4242: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4243: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sty_id ' ||x_primary_sty_id);
4244: END IF;
4245: END IF;
4246:
4247: END IF;

Line 4290: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
4289: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4290: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
4291: END IF;
4292: END IF;
4293: raise FND_API.G_EXC_ERROR;
4294: ELSE

Line 4297: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tapv_rec.id'

4293: raise FND_API.G_EXC_ERROR;
4294: ELSE
4295: IF PG_DEBUG < 11 THEN
4296: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4297: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tapv_rec.id'
4298: ||lx_tapv_rec.id);
4299: END IF;
4300: END IF;
4301: FND_MSG_PUB.initialize;

Line 4319: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
4319: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
4320: END IF;
4321: END IF;
4322: raise FND_API.G_EXC_ERROR;
4323: ELSE

Line 4326: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tplv_rec.id'

4322: raise FND_API.G_EXC_ERROR;
4323: ELSE
4324: IF PG_DEBUG < 11 THEN
4325: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4326: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tplv_rec.id'
4327: ||lx_tplv_rec.id);
4328: END IF;
4329: END IF;
4330: FND_MSG_PUB.initialize;

Line 4362: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
4362: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
4363: END IF;
4364: END IF;
4365: raise FND_API.G_EXC_ERROR;
4366: ELSE

Line 4369: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated CRF records');

4365: raise FND_API.G_EXC_ERROR;
4366: ELSE
4367: IF PG_DEBUG < 11 THEN
4368: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4369: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated CRF records');
4370: END IF;
4371: END IF;
4372: FND_MSG_PUB.initialize;
4373: END IF;

Line 4405: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

4401: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4402: Get_Messages (l_msg_count,l_message);
4403: IF PG_DEBUG < 11 THEN
4404: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4405: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
4406: END IF;
4407: END IF;
4408: raise FND_API.G_EXC_ERROR;
4409: ELSE

Line 4412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success ' );

4408: raise FND_API.G_EXC_ERROR;
4409: ELSE
4410: IF PG_DEBUG < 11 THEN
4411: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success ' );
4413: END IF;
4414: END IF;
4415: FND_MSG_PUB.initialize;
4416: END IF;

Line 4540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'No refund details exists for '

4536: IF c_check_dtls_ctr = 0 THEN
4537: -- no refund details
4538: IF PG_DEBUG < 11 THEN
4539: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'No refund details exists for '
4541: ||p_refund_header_id);
4542: END IF;
4543: END IF;
4544: fnd_message.set_name('OKL', 'OKL_CO_MISSING_REFUND_DETAILS');

Line 4553: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Refund status is not in progress');

4549: --check for refund header status
4550: IF l_refund_status <> 'IN_PROGRESS' THEN
4551: IF PG_DEBUG < 11 THEN
4552: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4553: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Refund status is not in progress');
4554: END IF;
4555: END IF;
4556: fnd_message.set_name('OKL', 'OKL_CO_REFUND_STATUS');
4557: fnd_message.set_token('REFUND_NUMBER',l_refund_header_number);

Line 4566: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before creating TAP record ');

4562: -- STEP 0
4563: --populate the ap invoice header table (okl_trx_ap_invoices_b)
4564: IF PG_DEBUG < 11 THEN
4565: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4566: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before creating TAP record ');
4567: END IF;
4568: END IF;
4569:
4570: create_curerefunds(

Line 4582: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after calling WF' ||l_message);

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
4581: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4582: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after calling WF' ||l_message);
4583: END IF;
4584: END IF;
4585: raise FND_API.G_EXC_ERROR;
4586: ELSE

Line 4602: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after calling WF' ||l_message);

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
4602: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after calling WF' ||l_message);
4603: END IF;
4604: END IF;
4605: raise FND_API.G_EXC_ERROR;
4606: ELSE

Line 4637: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after updating Refund header'

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
4636: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4637: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after updating Refund header'
4638: ||l_message);
4639: END IF;
4640: END IF;
4641: raise FND_API.G_EXC_ERROR;

Line 4645: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );

4641: raise FND_API.G_EXC_ERROR;
4642: ELSE
4643: IF PG_DEBUG < 11 THEN
4644: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4645: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );
4646: END IF;
4647: END IF;
4648: FND_MSG_PUB.initialize;
4649: END IF;

Line 4772: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
4771: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4772: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
4773: END IF;
4774: END IF;
4775: raise FND_API.G_EXC_ERROR;
4776: ELSE

Line 4779: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated TAP ' );

4775: raise FND_API.G_EXC_ERROR;
4776: ELSE
4777: IF PG_DEBUG < 11 THEN
4778: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4779: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated TAP ' );
4780: END IF;
4781: END IF;
4782: FND_MSG_PUB.initialize;
4783: END IF;

Line 4795: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' cure refund header id ' ||

4791: **/
4792:
4793: IF PG_DEBUG < 11 THEN
4794: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4795: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' cure refund header id ' ||
4796: p_refund_header_id);
4797: END IF;
4798: END IF;
4799:

Line 4842: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
4842: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
4843: END IF;
4844: END IF;
4845: raise FND_API.G_EXC_ERROR;
4846: ELSE

Line 4849: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated tap records');

4845: raise FND_API.G_EXC_ERROR;
4846: ELSE
4847: IF PG_DEBUG < 11 THEN
4848: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4849: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated tap records');
4850: END IF;
4851: END IF;
4852: FND_MSG_PUB.initialize;
4853: END IF;

Line 4886: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

4882: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4883: Get_Messages (l_msg_count,l_message);
4884: IF PG_DEBUG <11 THEN
4885: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4886: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
4887: END IF;
4888: END IF;
4889: raise FND_API.G_EXC_ERROR;
4890: ELSE

Line 4893: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated tai records');

4889: raise FND_API.G_EXC_ERROR;
4890: ELSE
4891: IF PG_DEBUG < 11 THEN
4892: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4893: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Succesfully updated tai records');
4894: END IF;
4895: END IF;
4896: FND_MSG_PUB.initialize;
4897: END IF;

Line 4921: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
4921: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
4922: END IF;
4923: END IF;
4924: raise FND_API.G_EXC_ERROR;
4925: ELSE

Line 4928: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );

4924: raise FND_API.G_EXC_ERROR;
4925: ELSE
4926: IF PG_DEBUG < 11 THEN
4927: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4928: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );
4929: END IF;
4930: END IF;
4931: END IF;
4932:

Line 4967: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
4966: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4967: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
4968: END IF;
4969: END IF;
4970: raise FND_API.G_EXC_ERROR;
4971: ELSE

Line 4974: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );

4970: raise FND_API.G_EXC_ERROR;
4971: ELSE
4972: IF PG_DEBUG < 11 THEN
4973: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4974: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );
4975: END IF;
4976: END IF;
4977: FND_MSG_PUB.initialize;
4978: END IF;

Line 5064: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

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;
5066:
5067: if funcmode <> 'RUN' then
5068: result := wf_engine.eng_null;

Line 5079: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' cure refund header id ' ||

5075: aname => 'CURE_REFUND_HEADER_ID');
5076:
5077: IF PG_DEBUG < 11 THEN
5078: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5079: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' cure refund header id ' ||
5080: l_refund_header_id);
5081: END IF;
5082: END IF;
5083:

Line 5099: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error---->' ||l_message);

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
5099: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error---->' ||l_message);
5100: END IF;
5101: --set error message
5102: -- sent a notification to SYSADMIN with the error message
5103: -- Also update the refund_header to IN_PROGRESS

Line 5142: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error in update of cure refund to PENDINGI' ||l_message);

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
5142: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error in update of cure refund to PENDINGI' ||l_message);
5143: END IF;
5144: END IF;
5145: raise FND_API.G_EXC_ERROR;
5146: ELSE

Line 5149: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );

5145: raise FND_API.G_EXC_ERROR;
5146: ELSE
5147: IF PG_DEBUG < 11 THEN
5148: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5149: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );
5150: END IF;
5151: END IF;
5152: END IF;
5153:

Line 5157: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );

5153:
5154: ELSE
5155: IF PG_DEBUG < 11 THEN
5156: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5157: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );
5158: END IF;
5159: END IF;
5160:
5161: --send notification to Vendor

Line 5171: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,

5167: itemkey => itemkey,
5168: aname => 'VENDOR_ROLE');
5169: IF PG_DEBUG < 11 THEN
5170: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5171: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,
5172: 'Vendor Role Name is ' ||l_role_name );
5173: END IF;
5174: END IF;
5175:

Line 5235: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

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:
5238: if funcmode <> 'RUN' then
5239: result := wf_engine.eng_null;

Line 5264: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
5264: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
5265: END IF;
5266: END IF;
5267: raise FND_API.G_EXC_ERROR;
5268: ELSE

Line 5271: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );

5267: raise FND_API.G_EXC_ERROR;
5268: ELSE
5269: IF PG_DEBUG < 11 THEN
5270: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
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 ');

Line 5354: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'duplicate refund number' );

5350: if l_cure_refund_header_number IS NOT NULL THEN
5351:
5352: IF PG_DEBUG < 11 THEN
5353: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5354: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'duplicate refund number' );
5355: END IF;
5356: END IF;
5357: fnd_message.set_name('OKL', 'OKL_DUPLICATE_REFUND_NUMBER');
5358: fnd_msg_pub.add;

Line 5396: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
5396: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
5397: END IF;
5398: END IF;
5399: raise FND_API.G_EXC_ERROR;
5400: ELSE

Line 5402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_chdv_rec.cure_refund_header_id'

5398: END IF;
5399: raise FND_API.G_EXC_ERROR;
5400: ELSE
5401: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_chdv_rec.cure_refund_header_id'
5403: ||lx_chdv_rec.cure_refund_header_id);
5404: END IF;
5405: l_pay_cure_refunds_rec.refund_header_id :=
5406: lx_chdv_rec.cure_refund_header_id;

Line 5540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

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
5540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
5541: END IF;
5542: END IF;
5543: raise FND_API.G_EXC_ERROR;
5544: ELSE

Line 5546: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Successfully updated Cure refund '||

5542: END IF;
5543: raise FND_API.G_EXC_ERROR;
5544: ELSE
5545: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5546: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Successfully updated Cure refund '||
5547: 'header table');
5548:
5549: END IF;
5550: END IF;

Line 5668: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

5664: c_emps_rec c_emps%ROWTYPE;
5665:
5666: BEGIN
5667: IF (G_DEBUG_ENABLED = 'Y') THEN
5668: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
5669: END IF;
5670:
5671: IF PG_DEBUG < 11 THEN
5672: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 5673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In gen Doc' ||document_id);

5669: END IF;
5670:
5671: IF PG_DEBUG < 11 THEN
5672: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In gen Doc' ||document_id);
5674: END IF;
5675: END IF;
5676:
5677: document_type := document_type;