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.OZF_CLAIM_SETTLEMENT_PVT dependencies on OZF_UTILITY_PVT

Line 39: OZF_Utility_PVT.debug_message(l_full_name||': start');

35: l_return_status VARCHAR2(1);
36:
37: BEGIN
38: IF OZF_DEBUG_HIGH_ON THEN
39: OZF_Utility_PVT.debug_message(l_full_name||': start');
40: END IF;
41:
42: -------------------- initialize -----------------------
43: x_return_status := FND_API.g_ret_sts_success;

Line 62: OZF_Utility_PVT.debug_message(l_full_name||': end');

58: RAISE FND_API.g_exc_unexpected_error;
59: END;
60:
61: IF OZF_DEBUG_HIGH_ON THEN
62: OZF_Utility_PVT.debug_message(l_full_name||': end');
63: END IF;
64: EXCEPTION
65: WHEN FND_API.g_exc_unexpected_error THEN
66: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 170: OZF_UTILITY_PVT.Convert_Currency(

166: x_claim_rec.acctd_amount_settled := 0;
167:
168: x_claim_rec.amount_remaining := x_claim_rec.amount - x_claim_rec.amount_adjusted - x_claim_rec.amount_settled - NVL(x_claim_rec.tax_amount, 0);
169:
170: OZF_UTILITY_PVT.Convert_Currency(
171: P_SET_OF_BOOKS_ID => p_claim_rec.set_of_books_id,
172: P_FROM_CURRENCY => p_claim_rec.currency_code,
173: P_CONVERSION_DATE => p_claim_rec.exchange_rate_date,
174: P_CONVERSION_TYPE => p_claim_rec.exchange_rate_type,

Line 276: OZF_Utility_PVT.debug_message(l_full_name||' : start');

272: l_vendor_site_id NUMBER;
273:
274: BEGIN
275: IF OZF_DEBUG_HIGH_ON THEN
276: OZF_Utility_PVT.debug_message(l_full_name||' : start');
277: END IF;
278:
279: -- Initialize API return status to sucess
280: x_return_status := FND_API.g_ret_sts_success;

Line 334: OZF_Utility_PVT.debug_message(l_full_name||' : end');

330: END IF;
331: END IF;
332:
333: IF OZF_DEBUG_HIGH_ON THEN
334: OZF_Utility_PVT.debug_message(l_full_name||' : end');
335: END IF;
336:
337: EXCEPTION
338: WHEN FND_API.G_EXC_ERROR THEN

Line 389: OZF_Utility_PVT.debug_message(l_full_name||' : start');

385: l_line_obj_ver NUMBER;
386:
387: BEGIN
388: IF OZF_DEBUG_HIGH_ON THEN
389: OZF_Utility_PVT.debug_message(l_full_name||' : start');
390: END IF;
391:
392: -- Initialize API return status to sucess
393: x_return_status := FND_API.g_ret_sts_success;

Line 433: OZF_Utility_PVT.debug_message(l_full_name||' : end');

429: END LOOP;
430: END IF;
431:
432: IF OZF_DEBUG_HIGH_ON THEN
433: OZF_Utility_PVT.debug_message(l_full_name||' : end');
434: END IF;
435:
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN

Line 474: OZF_Utility_PVT.debug_message(l_full_name||' : start');

470: l_return_status VARCHAR2(1);
471:
472: BEGIN
473: IF OZF_DEBUG_HIGH_ON THEN
474: OZF_Utility_PVT.debug_message(l_full_name||' : start');
475: END IF;
476:
477: -- Initialize API return status to sucess
478: x_return_status := FND_API.g_ret_sts_success;

Line 494: OZF_Utility_PVT.debug_message(l_full_name||' : end');

490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;
492:
493: IF OZF_DEBUG_HIGH_ON THEN
494: OZF_Utility_PVT.debug_message(l_full_name||' : end');
495: END IF;
496: EXCEPTION
497: WHEN FND_API.G_EXC_ERROR THEN
498: x_return_status := FND_API.G_RET_STS_ERROR;

Line 534: OZF_Utility_PVT.debug_message(l_full_name||' : start');

530: l_return_status VARCHAR2(1);
531:
532: BEGIN
533: IF OZF_DEBUG_HIGH_ON THEN
534: OZF_Utility_PVT.debug_message(l_full_name||' : start');
535: END IF;
536:
537: -- Initialize API return status to sucess
538: x_return_status := FND_API.g_ret_sts_success;

Line 554: OZF_Utility_PVT.debug_message(l_full_name||' : end');

550: RAISE FND_API.g_exc_unexpected_error;
551: END IF;
552:
553: IF OZF_DEBUG_HIGH_ON THEN
554: OZF_Utility_PVT.debug_message(l_full_name||' : end');
555: END IF;
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: x_return_status := FND_API.G_RET_STS_ERROR;

Line 603: OZF_Utility_PVT.debug_message(l_full_name||' : start');

599: l_claim_class VARCHAR2(30);
600:
601: BEGIN
602: IF OZF_DEBUG_HIGH_ON THEN
603: OZF_Utility_PVT.debug_message(l_full_name||' : start');
604: END IF;
605:
606: -- Initialize API return status to sucess
607: x_return_status := FND_API.g_ret_sts_success;

Line 632: OZF_Utility_PVT.debug_message(l_full_name||' : end');

628: END;
629: END IF;
630: */
631: IF OZF_DEBUG_HIGH_ON THEN
632: OZF_Utility_PVT.debug_message(l_full_name||' : end');
633: END IF;
634: EXCEPTION
635: WHEN FND_API.G_EXC_ERROR THEN
636: x_return_status := FND_API.G_RET_STS_ERROR;

Line 678: OZF_Utility_PVT.debug_message(l_full_name||' : start');

674: l_return_status VARCHAR2(1);
675:
676: BEGIN
677: IF OZF_DEBUG_HIGH_ON THEN
678: OZF_Utility_PVT.debug_message(l_full_name||' : start');
679: END IF;
680:
681: -- Initialize API return status to sucess
682: x_return_status := FND_API.g_ret_sts_success;

Line 692: OZF_UTILITY_PVT.Convert_Currency(

688: x_claim_rec.acctd_amount_settled := 0;
689:
690: x_claim_rec.amount_remaining := x_claim_rec.amount - x_claim_rec.amount_adjusted - x_claim_rec.amount_settled - NVL(x_claim_rec.tax_amount, 0);
691:
692: OZF_UTILITY_PVT.Convert_Currency(
693: P_SET_OF_BOOKS_ID => p_claim_rec.set_of_books_id,
694: P_FROM_CURRENCY => p_claim_rec.currency_code,
695: P_CONVERSION_DATE => p_claim_rec.exchange_rate_date,
696: P_CONVERSION_TYPE => p_claim_rec.exchange_rate_type,

Line 710: OZF_Utility_PVT.debug_message(l_full_name||' : end');

706: RAISE FND_API.g_exc_unexpected_error;
707: END IF;
708:
709: IF OZF_DEBUG_HIGH_ON THEN
710: OZF_Utility_PVT.debug_message(l_full_name||' : end');
711: END IF;
712: EXCEPTION
713: WHEN FND_API.G_EXC_ERROR THEN
714: x_return_status := FND_API.G_RET_STS_ERROR;

Line 759: OZF_Utility_PVT.debug_message(l_full_name||' : start');

755: l_claim_class VARCHAR2(30);
756:
757: BEGIN
758: IF OZF_DEBUG_HIGH_ON THEN
759: OZF_Utility_PVT.debug_message(l_full_name||' : start');
760: END IF;
761:
762: -- Initialize API return status to sucess
763: x_return_status := FND_API.g_ret_sts_success;

Line 788: OZF_Utility_PVT.debug_message(l_full_name||' : end');

784: END;
785: END IF;
786: */
787: IF OZF_DEBUG_HIGH_ON THEN
788: OZF_Utility_PVT.debug_message(l_full_name||' : end');
789: END IF;
790: EXCEPTION
791: WHEN FND_API.G_EXC_ERROR THEN
792: x_return_status := FND_API.G_RET_STS_ERROR;

Line 834: OZF_Utility_PVT.debug_message(l_full_name||' : start');

830: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;
831:
832: BEGIN
833: IF OZF_DEBUG_HIGH_ON THEN
834: OZF_Utility_PVT.debug_message(l_full_name||' : start');
835: END IF;
836:
837: -- Initialize API return status to sucess
838: x_return_status := FND_API.g_ret_sts_success;

Line 859: OZF_Utility_PVT.debug_message(l_full_name||' : end');

855: RAISE FND_API.g_exc_unexpected_error;
856: END IF;
857:
858: IF OZF_DEBUG_HIGH_ON THEN
859: OZF_Utility_PVT.debug_message(l_full_name||' : end');
860: END IF;
861: EXCEPTION
862: WHEN FND_API.G_EXC_ERROR THEN
863: x_return_status := FND_API.G_RET_STS_ERROR;

Line 899: OZF_Utility_PVT.debug_message(l_full_name||' : start');

895: l_return_status VARCHAR2(1);
896:
897: BEGIN
898: IF OZF_DEBUG_HIGH_ON THEN
899: OZF_Utility_PVT.debug_message(l_full_name||' : start');
900: END IF;
901: -- Initialize API return status to sucess
902: x_return_status := FND_API.g_ret_sts_success;
903:

Line 918: OZF_Utility_PVT.debug_message(l_full_name||' : end');

914: RAISE FND_API.g_exc_unexpected_error;
915: END IF;
916:
917: IF OZF_DEBUG_HIGH_ON THEN
918: OZF_Utility_PVT.debug_message(l_full_name||' : end');
919: END IF;
920:
921: EXCEPTION
922: WHEN FND_API.G_EXC_ERROR THEN

Line 988: OZF_Utility_PVT.debug_message(l_full_name||' : start');

984: l_perf_appr_req VARCHAR2(1);
985:
986: BEGIN
987: IF OZF_DEBUG_HIGH_ON THEN
988: OZF_Utility_PVT.debug_message(l_full_name||' : start');
989: END IF;
990: -- Initialize API return status to sucess
991: x_return_status := FND_API.g_ret_sts_success;
992:

Line 1025: OZF_UTILITY_PVT.Convert_Currency(

1021: x_claim_rec.amount_settled := p_claim_rec.amount_remaining;
1022: END IF;
1023:
1024: -- acctd_amount_settled
1025: OZF_UTILITY_PVT.Convert_Currency(
1026: P_SET_OF_BOOKS_ID => p_claim_rec.set_of_books_id,
1027: P_FROM_CURRENCY => p_claim_rec.currency_code,
1028: P_CONVERSION_DATE => p_claim_rec.exchange_rate_date,
1029: P_CONVERSION_TYPE => p_claim_rec.exchange_rate_type,

Line 1046: OZF_UTILITY_PVT.Convert_Currency(

1042: -- amount_remaining
1043: x_claim_rec.amount_remaining := x_claim_rec.amount - x_claim_rec.amount_adjusted - x_claim_rec.amount_settled - NVL(x_claim_rec.tax_amount, 0);
1044:
1045: -- acctd_amount_remaining
1046: OZF_UTILITY_PVT.Convert_Currency(
1047: P_SET_OF_BOOKS_ID => p_claim_rec.set_of_books_id,
1048: P_FROM_CURRENCY => p_claim_rec.currency_code,
1049: P_CONVERSION_DATE => p_claim_rec.exchange_rate_date,
1050: P_CONVERSION_TYPE => p_claim_rec.exchange_rate_type,

Line 1078: x_claim_rec.settled_by := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);

1074: END IF;
1075: */
1076:
1077: -- settled_by / settled_date
1078: x_claim_rec.settled_by := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
1079: x_claim_rec.settled_date := SYSDATE;
1080:
1081: IF OZF_DEBUG_HIGH_ON THEN
1082: OZF_Utility_PVT.debug_message(l_full_name||' : end');

Line 1082: OZF_Utility_PVT.debug_message(l_full_name||' : end');

1078: x_claim_rec.settled_by := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
1079: x_claim_rec.settled_date := SYSDATE;
1080:
1081: IF OZF_DEBUG_HIGH_ON THEN
1082: OZF_Utility_PVT.debug_message(l_full_name||' : end');
1083: END IF;
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_ERROR THEN
1086: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1147: OZF_Utility_PVT.debug_message(l_full_name||' : start');

1143: WHERE claim_id = l_claim_id;
1144:
1145: BEGIN
1146: IF OZF_DEBUG_HIGH_ON THEN
1147: OZF_Utility_PVT.debug_message(l_full_name||' : start');
1148: END IF;
1149: -- Initialize API return status to sucess
1150: x_return_status := FND_API.g_ret_sts_success;
1151:

Line 1159: l_orig_status_id := OZF_UTILITY_PVT.get_default_user_status(

1155: l_requester_id, -- Fix for Bug 4754509
1156: l_comments;
1157: CLOSE claim_rec_csr;
1158:
1159: l_orig_status_id := OZF_UTILITY_PVT.get_default_user_status(
1160: l_status_type
1161: ,l_orig_status_code
1162: );
1163:

Line 1164: l_new_status_id := OZF_UTILITY_PVT.get_default_user_status(

1160: l_status_type
1161: ,l_orig_status_code
1162: );
1163:
1164: l_new_status_id := OZF_UTILITY_PVT.get_default_user_status(
1165: l_status_type
1166: ,p_curr_status
1167: );
1168:

Line 1169: l_reject_status_id := OZF_UTILITY_PVT.get_default_user_status(

1165: l_status_type
1166: ,p_curr_status
1167: );
1168:
1169: l_reject_status_id := OZF_UTILITY_PVT.get_default_user_status(
1170: l_status_type
1171: ,l_reject_status_code
1172: );
1173: IF OZF_Claim_Accrual_PVT.Earnings_Approval_Required(p_claim_id) = FND_API.g_true THEN

Line 1205: OZF_Utility_PVT.debug_message(l_full_name||' : end');

1201: RAISE FND_API.g_exc_unexpected_error;
1202: END IF;
1203:
1204: IF OZF_DEBUG_HIGH_ON THEN
1205: OZF_Utility_PVT.debug_message(l_full_name||' : end');
1206: END IF;
1207: EXCEPTION
1208: WHEN FND_API.G_EXC_ERROR THEN
1209: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1298: OZF_Utility_PVT.debug_message(l_full_name||' : start');

1294: l_trx_currency VARCHAR2(15);
1295:
1296: BEGIN
1297: IF OZF_DEBUG_HIGH_ON THEN
1298: OZF_Utility_PVT.debug_message(l_full_name||' : start');
1299: END IF;
1300: -- Initialize API return status to sucess
1301: x_return_status := FND_API.g_ret_sts_success;
1302:

Line 1332: OZF_UTILITY_PVT.Convert_Currency(

1328: x_claim_rec.amount_settled := p_claim_rec.amount_remaining;
1329: END IF;
1330:
1331: -- update acctd_amount_settled
1332: OZF_UTILITY_PVT.Convert_Currency(
1333: P_SET_OF_BOOKS_ID => p_claim_rec.set_of_books_id,
1334: P_FROM_CURRENCY => p_claim_rec.currency_code,
1335: P_CONVERSION_DATE => p_claim_rec.exchange_rate_date,
1336: P_CONVERSION_TYPE => p_claim_rec.exchange_rate_type,

Line 1356: OZF_UTILITY_PVT.Convert_Currency(

1352: - x_claim_rec.amount_settled
1353: - NVL(x_claim_rec.tax_amount,0);
1354:
1355: -- update acctd_amount_remaining
1356: OZF_UTILITY_PVT.Convert_Currency(
1357: P_SET_OF_BOOKS_ID => p_claim_rec.set_of_books_id,
1358: P_FROM_CURRENCY => p_claim_rec.currency_code,
1359: P_CONVERSION_DATE => p_claim_rec.exchange_rate_date,
1360: P_CONVERSION_TYPE => p_claim_rec.exchange_rate_type,

Line 1394: x_claim_rec.settled_by := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);

1390: RAISE FND_API.g_exc_error;
1391: END IF;
1392: */
1393:
1394: x_claim_rec.settled_by := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
1395: x_claim_rec.settled_date := SYSDATE;
1396:
1397: END IF;
1398: /*

Line 1405: x_claim_rec.settled_by := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);

1401: -- -> (CLOSED)
1402: -- -> APPROVED
1403: -- --(time gap)--> CLOSED
1404: IF p_prev_status = 'APPROVED' THEN
1405: x_claim_rec.settled_by := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
1406: x_claim_rec.settled_date := SYSDATE;
1407: END IF;
1408: */
1409:

Line 1590: OZF_Utility_PVT.debug_message(l_full_name||' : end');

1586: FETCH csr_user_status_id INTO x_claim_rec.user_status_id;
1587: CLOSE csr_user_status_id;
1588:
1589: IF OZF_DEBUG_HIGH_ON THEN
1590: OZF_Utility_PVT.debug_message(l_full_name||' : end');
1591: END IF;
1592: EXCEPTION
1593: WHEN FND_API.G_EXC_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1699: OZF_Utility_PVT.debug_message(l_full_name||' : start');

1695:
1696:
1697: BEGIN
1698: IF OZF_DEBUG_HIGH_ON THEN
1699: OZF_Utility_PVT.debug_message(l_full_name||' : start');
1700: END IF;
1701:
1702: -- Initialize API return status to sucess
1703: x_return_status := FND_API.g_ret_sts_success;

Line 1722: OZF_Utility_PVT.debug_message('l_bg_process_mode 1:'||l_bg_process_mode);

1718:
1719: -- Added for Multi Currency
1720:
1721: IF OZF_DEBUG_HIGH_ON THEN
1722: OZF_Utility_PVT.debug_message('l_bg_process_mode 1:'||l_bg_process_mode);
1723: OZF_Utility_PVT.debug_message('l_asso_amount 1:'||l_asso_amount);
1724: OZF_Utility_PVT.debug_message('l_post_to_gl 1:'||l_post_to_gl);
1725: END IF;
1726:

Line 1723: OZF_Utility_PVT.debug_message('l_asso_amount 1:'||l_asso_amount);

1719: -- Added for Multi Currency
1720:
1721: IF OZF_DEBUG_HIGH_ON THEN
1722: OZF_Utility_PVT.debug_message('l_bg_process_mode 1:'||l_bg_process_mode);
1723: OZF_Utility_PVT.debug_message('l_asso_amount 1:'||l_asso_amount);
1724: OZF_Utility_PVT.debug_message('l_post_to_gl 1:'||l_post_to_gl);
1725: END IF;
1726:
1727: IF l_bg_process_mode = 'Y' THEN

Line 1724: OZF_Utility_PVT.debug_message('l_post_to_gl 1:'||l_post_to_gl);

1720:
1721: IF OZF_DEBUG_HIGH_ON THEN
1722: OZF_Utility_PVT.debug_message('l_bg_process_mode 1:'||l_bg_process_mode);
1723: OZF_Utility_PVT.debug_message('l_asso_amount 1:'||l_asso_amount);
1724: OZF_Utility_PVT.debug_message('l_post_to_gl 1:'||l_post_to_gl);
1725: END IF;
1726:
1727: IF l_bg_process_mode = 'Y' THEN
1728: IF l_asso_amount <> 0 AND NVL(l_post_to_gl,'F') = 'T' THEN -- Bug4308173

Line 1737: OZF_Utility_PVT.debug_message('l_bg_process_mode 2:'||l_bg_process_mode);

1733: END IF;
1734:
1735: -- Added for Multi Currency
1736: IF OZF_DEBUG_HIGH_ON THEN
1737: OZF_Utility_PVT.debug_message('l_bg_process_mode 2:'||l_bg_process_mode);
1738: OZF_Utility_PVT.debug_message('l_claim_settle.payment_method:'||l_claim_settle.payment_method);
1739: END IF;
1740:
1741: --R12.1 Enhancement:Checking for claim which have accrual and payment method ACCOUNTING_ONLY

Line 1738: OZF_Utility_PVT.debug_message('l_claim_settle.payment_method:'||l_claim_settle.payment_method);

1734:
1735: -- Added for Multi Currency
1736: IF OZF_DEBUG_HIGH_ON THEN
1737: OZF_Utility_PVT.debug_message('l_bg_process_mode 2:'||l_bg_process_mode);
1738: OZF_Utility_PVT.debug_message('l_claim_settle.payment_method:'||l_claim_settle.payment_method);
1739: END IF;
1740:
1741: --R12.1 Enhancement:Checking for claim which have accrual and payment method ACCOUNTING_ONLY
1742: IF ((l_bg_process = 'Y') and (l_claim_settle.payment_method <> 'ACCOUNTING_ONLY'))THEN

Line 1744: OZF_Utility_PVT.debug_message(l_full_name||' : promo claim');

1740:
1741: --R12.1 Enhancement:Checking for claim which have accrual and payment method ACCOUNTING_ONLY
1742: IF ((l_bg_process = 'Y') and (l_claim_settle.payment_method <> 'ACCOUNTING_ONLY'))THEN
1743: IF OZF_DEBUG_HIGH_ON THEN
1744: OZF_Utility_PVT.debug_message(l_full_name||' : promo claim');
1745: END IF;
1746: -- promotional claims settled by workflow
1747: BEGIN
1748: OZF_AR_SETTLEMENT_PVT.Start_Settlement(

Line 1791: OZF_Utility_PVT.debug_message('Accounting Event Id :'||l_event_id );

1787: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1788: RAISE FND_API.g_exc_unexpected_error;
1789: END IF;
1790: IF OZF_DEBUG_HIGH_ON THEN
1791: OZF_Utility_PVT.debug_message('Accounting Event Id :'||l_event_id );
1792: OZF_Utility_PVT.debug_message('Code Combination Id :'||l_ccid );
1793: END IF;
1794:
1795: OPEN csr_payment_term(l_claim_settle.set_of_books_id);

Line 1792: OZF_Utility_PVT.debug_message('Code Combination Id :'||l_ccid );

1788: RAISE FND_API.g_exc_unexpected_error;
1789: END IF;
1790: IF OZF_DEBUG_HIGH_ON THEN
1791: OZF_Utility_PVT.debug_message('Accounting Event Id :'||l_event_id );
1792: OZF_Utility_PVT.debug_message('Code Combination Id :'||l_ccid );
1793: END IF;
1794:
1795: OPEN csr_payment_term(l_claim_settle.set_of_books_id);
1796: FETCH csr_payment_term INTO l_payment_term;

Line 1852: OZF_Utility_PVT.debug_message('Accounting Event Id :'||l_event_id );

1848: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1849: RAISE FND_API.g_exc_unexpected_error;
1850: END IF;
1851: IF OZF_DEBUG_HIGH_ON THEN
1852: OZF_Utility_PVT.debug_message('Accounting Event Id :'||l_event_id );
1853: OZF_Utility_PVT.debug_message('Code Combination Id :'||l_ccid );
1854: END IF;
1855:
1856: l_automate_settlement := NVL(FND_PROFILE.value('OZF_CLAIM_USE_AR_AUTOMATION'), 'Y');

Line 1853: OZF_Utility_PVT.debug_message('Code Combination Id :'||l_ccid );

1849: RAISE FND_API.g_exc_unexpected_error;
1850: END IF;
1851: IF OZF_DEBUG_HIGH_ON THEN
1852: OZF_Utility_PVT.debug_message('Accounting Event Id :'||l_event_id );
1853: OZF_Utility_PVT.debug_message('Code Combination Id :'||l_ccid );
1854: END IF;
1855:
1856: l_automate_settlement := NVL(FND_PROFILE.value('OZF_CLAIM_USE_AR_AUTOMATION'), 'Y');
1857:

Line 1947: OZF_Utility_PVT.debug_message('Accounting Event Id :'||l_event_id );

1943: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1944: RAISE FND_API.g_exc_unexpected_error;
1945: END IF;
1946: IF OZF_DEBUG_HIGH_ON THEN
1947: OZF_Utility_PVT.debug_message('Accounting Event Id :'||l_event_id );
1948: OZF_Utility_PVT.debug_message('Code Combination Id :'||l_ccid );
1949: END IF;
1950:
1951: -- Kickoff Settlement Workflow for contra charge

Line 1948: OZF_Utility_PVT.debug_message('Code Combination Id :'||l_ccid );

1944: RAISE FND_API.g_exc_unexpected_error;
1945: END IF;
1946: IF OZF_DEBUG_HIGH_ON THEN
1947: OZF_Utility_PVT.debug_message('Accounting Event Id :'||l_event_id );
1948: OZF_Utility_PVT.debug_message('Code Combination Id :'||l_ccid );
1949: END IF;
1950:
1951: -- Kickoff Settlement Workflow for contra charge
1952: Process_Settlement_WF(

Line 2002: OZF_Utility_PVT.debug_message(l_full_name||' : end');

1998:
1999: END IF; -- end l_bg_process = 'Y'
2000:
2001: IF OZF_DEBUG_HIGH_ON THEN
2002: OZF_Utility_PVT.debug_message(l_full_name||' : end');
2003: END IF;
2004: EXCEPTION
2005: WHEN FND_API.G_EXC_ERROR THEN
2006: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2059: OZF_Utility_PVT.debug_message(l_full_name||' : start');

2055:
2056:
2057: BEGIN
2058: IF OZF_DEBUG_HIGH_ON THEN
2059: OZF_Utility_PVT.debug_message(l_full_name||' : start');
2060: END IF;
2061: -- Initialize API return status to sucess
2062: x_return_status := FND_API.g_ret_sts_success;
2063:

Line 2080: OZF_UTILITY_PVT.Convert_Currency(

2076: END IF;
2077:
2078: x_claim_rec.amount_remaining := x_claim_rec.amount - x_claim_rec.amount_adjusted - x_claim_rec.amount_settled - NVL(x_claim_rec.tax_amount, 0);
2079:
2080: OZF_UTILITY_PVT.Convert_Currency(
2081: P_SET_OF_BOOKS_ID => p_claim_rec.set_of_books_id,
2082: P_FROM_CURRENCY => p_claim_rec.currency_code,
2083: P_CONVERSION_DATE => p_claim_rec.exchange_rate_date,
2084: P_CONVERSION_TYPE => p_claim_rec.exchange_rate_type,

Line 2099: OZF_Utility_PVT.debug_message(l_full_name||' : end');

2095: END IF;
2096: */
2097:
2098: IF OZF_DEBUG_HIGH_ON THEN
2099: OZF_Utility_PVT.debug_message(l_full_name||' : end');
2100: END IF;
2101: EXCEPTION
2102: WHEN FND_API.G_EXC_ERROR THEN
2103: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2336: OZF_Utility_PVT.debug_message(l_full_name||' : start');

2332:
2333: BEGIN
2334:
2335: IF OZF_DEBUG_HIGH_ON THEN
2336: OZF_Utility_PVT.debug_message(l_full_name||' : start');
2337: OZF_Utility_PVT.debug_message('trunc(p_settled_date)' || trunc(p_settled_date));
2338: OZF_Utility_PVT.debug_message('trunc(p_claim_exchange_date)' || trunc(p_claim_exchange_date));
2339: OZF_Utility_PVT.debug_message('p_claim_rate' || p_claim_rate);
2340: END IF;

Line 2337: OZF_Utility_PVT.debug_message('trunc(p_settled_date)' || trunc(p_settled_date));

2333: BEGIN
2334:
2335: IF OZF_DEBUG_HIGH_ON THEN
2336: OZF_Utility_PVT.debug_message(l_full_name||' : start');
2337: OZF_Utility_PVT.debug_message('trunc(p_settled_date)' || trunc(p_settled_date));
2338: OZF_Utility_PVT.debug_message('trunc(p_claim_exchange_date)' || trunc(p_claim_exchange_date));
2339: OZF_Utility_PVT.debug_message('p_claim_rate' || p_claim_rate);
2340: END IF;
2341:

Line 2338: OZF_Utility_PVT.debug_message('trunc(p_claim_exchange_date)' || trunc(p_claim_exchange_date));

2334:
2335: IF OZF_DEBUG_HIGH_ON THEN
2336: OZF_Utility_PVT.debug_message(l_full_name||' : start');
2337: OZF_Utility_PVT.debug_message('trunc(p_settled_date)' || trunc(p_settled_date));
2338: OZF_Utility_PVT.debug_message('trunc(p_claim_exchange_date)' || trunc(p_claim_exchange_date));
2339: OZF_Utility_PVT.debug_message('p_claim_rate' || p_claim_rate);
2340: END IF;
2341:
2342: x_return_status := FND_API.g_ret_sts_success;

Line 2339: OZF_Utility_PVT.debug_message('p_claim_rate' || p_claim_rate);

2335: IF OZF_DEBUG_HIGH_ON THEN
2336: OZF_Utility_PVT.debug_message(l_full_name||' : start');
2337: OZF_Utility_PVT.debug_message('trunc(p_settled_date)' || trunc(p_settled_date));
2338: OZF_Utility_PVT.debug_message('trunc(p_claim_exchange_date)' || trunc(p_claim_exchange_date));
2339: OZF_Utility_PVT.debug_message('p_claim_rate' || p_claim_rate);
2340: END IF;
2341:
2342: x_return_status := FND_API.g_ret_sts_success;
2343:

Line 2386: OZF_Utility_PVT.debug_message('p_claim_id = '||p_claim_id);

2382:
2383:
2384:
2385: IF OZF_DEBUG_HIGH_ON THEN
2386: OZF_Utility_PVT.debug_message('p_claim_id = '||p_claim_id);
2387: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);
2388: OZF_Utility_PVT.debug_message('l_line_util_amount = '||l_line_util_amount);
2389: OZF_Utility_PVT.debug_message('l_claim_currency_code = '||l_claim_currency_code);
2390: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);

Line 2387: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);

2383:
2384:
2385: IF OZF_DEBUG_HIGH_ON THEN
2386: OZF_Utility_PVT.debug_message('p_claim_id = '||p_claim_id);
2387: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);
2388: OZF_Utility_PVT.debug_message('l_line_util_amount = '||l_line_util_amount);
2389: OZF_Utility_PVT.debug_message('l_claim_currency_code = '||l_claim_currency_code);
2390: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2391: OZF_Utility_PVT.debug_message('l_claim_exc_type = '||l_claim_exc_type);

Line 2388: OZF_Utility_PVT.debug_message('l_line_util_amount = '||l_line_util_amount);

2384:
2385: IF OZF_DEBUG_HIGH_ON THEN
2386: OZF_Utility_PVT.debug_message('p_claim_id = '||p_claim_id);
2387: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);
2388: OZF_Utility_PVT.debug_message('l_line_util_amount = '||l_line_util_amount);
2389: OZF_Utility_PVT.debug_message('l_claim_currency_code = '||l_claim_currency_code);
2390: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2391: OZF_Utility_PVT.debug_message('l_claim_exc_type = '||l_claim_exc_type);
2392: OZF_Utility_PVT.debug_message('l_plan_currency_code = '||l_plan_currency_code);

Line 2389: OZF_Utility_PVT.debug_message('l_claim_currency_code = '||l_claim_currency_code);

2385: IF OZF_DEBUG_HIGH_ON THEN
2386: OZF_Utility_PVT.debug_message('p_claim_id = '||p_claim_id);
2387: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);
2388: OZF_Utility_PVT.debug_message('l_line_util_amount = '||l_line_util_amount);
2389: OZF_Utility_PVT.debug_message('l_claim_currency_code = '||l_claim_currency_code);
2390: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2391: OZF_Utility_PVT.debug_message('l_claim_exc_type = '||l_claim_exc_type);
2392: OZF_Utility_PVT.debug_message('l_plan_currency_code = '||l_plan_currency_code);
2393: OZF_Utility_PVT.debug_message('l_fu_exc_type = '||l_fu_exc_type);

Line 2390: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);

2386: OZF_Utility_PVT.debug_message('p_claim_id = '||p_claim_id);
2387: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);
2388: OZF_Utility_PVT.debug_message('l_line_util_amount = '||l_line_util_amount);
2389: OZF_Utility_PVT.debug_message('l_claim_currency_code = '||l_claim_currency_code);
2390: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2391: OZF_Utility_PVT.debug_message('l_claim_exc_type = '||l_claim_exc_type);
2392: OZF_Utility_PVT.debug_message('l_plan_currency_code = '||l_plan_currency_code);
2393: OZF_Utility_PVT.debug_message('l_fu_exc_type = '||l_fu_exc_type);
2394: OZF_Utility_PVT.debug_message('l_fu_exc_rate = '||l_fu_exc_rate);

Line 2391: OZF_Utility_PVT.debug_message('l_claim_exc_type = '||l_claim_exc_type);

2387: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);
2388: OZF_Utility_PVT.debug_message('l_line_util_amount = '||l_line_util_amount);
2389: OZF_Utility_PVT.debug_message('l_claim_currency_code = '||l_claim_currency_code);
2390: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2391: OZF_Utility_PVT.debug_message('l_claim_exc_type = '||l_claim_exc_type);
2392: OZF_Utility_PVT.debug_message('l_plan_currency_code = '||l_plan_currency_code);
2393: OZF_Utility_PVT.debug_message('l_fu_exc_type = '||l_fu_exc_type);
2394: OZF_Utility_PVT.debug_message('l_fu_exc_rate = '||l_fu_exc_rate);
2395: OZF_Utility_PVT.debug_message('l_fu_exc_date = '||l_fu_exc_date);

Line 2392: OZF_Utility_PVT.debug_message('l_plan_currency_code = '||l_plan_currency_code);

2388: OZF_Utility_PVT.debug_message('l_line_util_amount = '||l_line_util_amount);
2389: OZF_Utility_PVT.debug_message('l_claim_currency_code = '||l_claim_currency_code);
2390: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2391: OZF_Utility_PVT.debug_message('l_claim_exc_type = '||l_claim_exc_type);
2392: OZF_Utility_PVT.debug_message('l_plan_currency_code = '||l_plan_currency_code);
2393: OZF_Utility_PVT.debug_message('l_fu_exc_type = '||l_fu_exc_type);
2394: OZF_Utility_PVT.debug_message('l_fu_exc_rate = '||l_fu_exc_rate);
2395: OZF_Utility_PVT.debug_message('l_fu_exc_date = '||l_fu_exc_date);
2396: END IF;

Line 2393: OZF_Utility_PVT.debug_message('l_fu_exc_type = '||l_fu_exc_type);

2389: OZF_Utility_PVT.debug_message('l_claim_currency_code = '||l_claim_currency_code);
2390: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2391: OZF_Utility_PVT.debug_message('l_claim_exc_type = '||l_claim_exc_type);
2392: OZF_Utility_PVT.debug_message('l_plan_currency_code = '||l_plan_currency_code);
2393: OZF_Utility_PVT.debug_message('l_fu_exc_type = '||l_fu_exc_type);
2394: OZF_Utility_PVT.debug_message('l_fu_exc_rate = '||l_fu_exc_rate);
2395: OZF_Utility_PVT.debug_message('l_fu_exc_date = '||l_fu_exc_date);
2396: END IF;
2397:

Line 2394: OZF_Utility_PVT.debug_message('l_fu_exc_rate = '||l_fu_exc_rate);

2390: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2391: OZF_Utility_PVT.debug_message('l_claim_exc_type = '||l_claim_exc_type);
2392: OZF_Utility_PVT.debug_message('l_plan_currency_code = '||l_plan_currency_code);
2393: OZF_Utility_PVT.debug_message('l_fu_exc_type = '||l_fu_exc_type);
2394: OZF_Utility_PVT.debug_message('l_fu_exc_rate = '||l_fu_exc_rate);
2395: OZF_Utility_PVT.debug_message('l_fu_exc_date = '||l_fu_exc_date);
2396: END IF;
2397:
2398: IF l_claim_currency_code = l_plan_currency_code AND

Line 2395: OZF_Utility_PVT.debug_message('l_fu_exc_date = '||l_fu_exc_date);

2391: OZF_Utility_PVT.debug_message('l_claim_exc_type = '||l_claim_exc_type);
2392: OZF_Utility_PVT.debug_message('l_plan_currency_code = '||l_plan_currency_code);
2393: OZF_Utility_PVT.debug_message('l_fu_exc_type = '||l_fu_exc_type);
2394: OZF_Utility_PVT.debug_message('l_fu_exc_rate = '||l_fu_exc_rate);
2395: OZF_Utility_PVT.debug_message('l_fu_exc_date = '||l_fu_exc_date);
2396: END IF;
2397:
2398: IF l_claim_currency_code = l_plan_currency_code AND
2399: l_claim_currency_code <> l_functional_currency THEN

Line 2402: OZF_UTILITY_PVT.Convert_Currency(

2398: IF l_claim_currency_code = l_plan_currency_code AND
2399: l_claim_currency_code <> l_functional_currency THEN
2400: IF l_claim_exc_rate <> l_fu_exc_rate AND l_fu_exc_rate IS NOT NULL THEN
2401:
2402: OZF_UTILITY_PVT.Convert_Currency(
2403: p_from_currency => l_claim_currency_code
2404: ,p_to_currency => l_functional_currency
2405: ,p_conv_type => l_claim_exc_type
2406: ,p_conv_date => l_claim_settled_date

Line 2419: OZF_UTILITY_PVT.Convert_Currency(

2415: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2416: RAISE FND_API.g_exc_unexpected_error;
2417: END IF;
2418:
2419: OZF_UTILITY_PVT.Convert_Currency(
2420: p_from_currency => l_plan_currency_code
2421: ,p_to_currency => l_functional_currency
2422: ,p_conv_type => l_fu_exc_type
2423: ,p_conv_date => l_fu_exc_date

Line 2439: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);

2435:
2436: l_fxgl_amount := l_lu_acctd_amount - l_util_acctd_amount;
2437:
2438: IF OZF_DEBUG_HIGH_ON THEN
2439: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);
2440: OZF_Utility_PVT.debug_message('l_lu_acctd_amount = '||l_lu_acctd_amount);
2441: OZF_Utility_PVT.debug_message('l_util_acctd_amount = '||l_util_acctd_amount);
2442: OZF_Utility_PVT.debug_message('l_fxgl_amount = '||l_fxgl_amount);
2443: OZF_Utility_PVT.debug_message('l_claim_settled_date = '||l_claim_settled_date);

Line 2440: OZF_Utility_PVT.debug_message('l_lu_acctd_amount = '||l_lu_acctd_amount);

2436: l_fxgl_amount := l_lu_acctd_amount - l_util_acctd_amount;
2437:
2438: IF OZF_DEBUG_HIGH_ON THEN
2439: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);
2440: OZF_Utility_PVT.debug_message('l_lu_acctd_amount = '||l_lu_acctd_amount);
2441: OZF_Utility_PVT.debug_message('l_util_acctd_amount = '||l_util_acctd_amount);
2442: OZF_Utility_PVT.debug_message('l_fxgl_amount = '||l_fxgl_amount);
2443: OZF_Utility_PVT.debug_message('l_claim_settled_date = '||l_claim_settled_date);
2444: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);

Line 2441: OZF_Utility_PVT.debug_message('l_util_acctd_amount = '||l_util_acctd_amount);

2437:
2438: IF OZF_DEBUG_HIGH_ON THEN
2439: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);
2440: OZF_Utility_PVT.debug_message('l_lu_acctd_amount = '||l_lu_acctd_amount);
2441: OZF_Utility_PVT.debug_message('l_util_acctd_amount = '||l_util_acctd_amount);
2442: OZF_Utility_PVT.debug_message('l_fxgl_amount = '||l_fxgl_amount);
2443: OZF_Utility_PVT.debug_message('l_claim_settled_date = '||l_claim_settled_date);
2444: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2445: END IF;

Line 2442: OZF_Utility_PVT.debug_message('l_fxgl_amount = '||l_fxgl_amount);

2438: IF OZF_DEBUG_HIGH_ON THEN
2439: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);
2440: OZF_Utility_PVT.debug_message('l_lu_acctd_amount = '||l_lu_acctd_amount);
2441: OZF_Utility_PVT.debug_message('l_util_acctd_amount = '||l_util_acctd_amount);
2442: OZF_Utility_PVT.debug_message('l_fxgl_amount = '||l_fxgl_amount);
2443: OZF_Utility_PVT.debug_message('l_claim_settled_date = '||l_claim_settled_date);
2444: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2445: END IF;
2446:

Line 2443: OZF_Utility_PVT.debug_message('l_claim_settled_date = '||l_claim_settled_date);

2439: OZF_Utility_PVT.debug_message('l_line_util_id = '||l_line_util_id);
2440: OZF_Utility_PVT.debug_message('l_lu_acctd_amount = '||l_lu_acctd_amount);
2441: OZF_Utility_PVT.debug_message('l_util_acctd_amount = '||l_util_acctd_amount);
2442: OZF_Utility_PVT.debug_message('l_fxgl_amount = '||l_fxgl_amount);
2443: OZF_Utility_PVT.debug_message('l_claim_settled_date = '||l_claim_settled_date);
2444: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2445: END IF;
2446:
2447: UPDATE ozf_claim_lines_util_all

Line 2444: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);

2440: OZF_Utility_PVT.debug_message('l_lu_acctd_amount = '||l_lu_acctd_amount);
2441: OZF_Utility_PVT.debug_message('l_util_acctd_amount = '||l_util_acctd_amount);
2442: OZF_Utility_PVT.debug_message('l_fxgl_amount = '||l_fxgl_amount);
2443: OZF_Utility_PVT.debug_message('l_claim_settled_date = '||l_claim_settled_date);
2444: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2445: END IF;
2446:
2447: UPDATE ozf_claim_lines_util_all
2448: SET acctd_amount = l_lu_acctd_amount

Line 2465: OZF_Utility_PVT.debug_message(l_full_name||' : end');

2461: p_claim_rate := l_claim_exc_rate;
2462:
2463:
2464: IF OZF_DEBUG_HIGH_ON THEN
2465: OZF_Utility_PVT.debug_message(l_full_name||' : end');
2466: END IF;
2467:
2468: EXCEPTION
2469: WHEN FND_API.G_EXC_ERROR THEN

Line 2539: OZF_Utility_PVT.debug_message(l_full_name||' : start');

2535: --------------------- initialize -----------------------
2536: SAVEPOINT Complete_Settlement;
2537:
2538: IF OZF_DEBUG_HIGH_ON THEN
2539: OZF_Utility_PVT.debug_message(l_full_name||' : start');
2540: END IF;
2541:
2542: IF FND_API.to_boolean(p_init_msg_list) THEN
2543: FND_MSG_PUB.initialize;

Line 2568: OZF_Utility_PVT.debug_message('l_app_match_cr :'||l_app_match_cr);

2564: FETCH csr_rule_based_approval INTO l_app_match_cr,l_app_new_cr;
2565: CLOSE csr_rule_based_approval;
2566:
2567: IF OZF_DEBUG_HIGH_ON THEN
2568: OZF_Utility_PVT.debug_message('l_app_match_cr :'||l_app_match_cr);
2569: OZF_Utility_PVT.debug_message('l_app_new_cr :'|| l_app_new_cr);
2570: OZF_Utility_PVT.debug_message('p_claim_rec.settled_from :'|| p_claim_rec.settled_from);
2571: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_number :'|| p_claim_rec.payment_reference_number);
2572: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_id:'|| p_claim_rec.payment_reference_id);

Line 2569: OZF_Utility_PVT.debug_message('l_app_new_cr :'|| l_app_new_cr);

2565: CLOSE csr_rule_based_approval;
2566:
2567: IF OZF_DEBUG_HIGH_ON THEN
2568: OZF_Utility_PVT.debug_message('l_app_match_cr :'||l_app_match_cr);
2569: OZF_Utility_PVT.debug_message('l_app_new_cr :'|| l_app_new_cr);
2570: OZF_Utility_PVT.debug_message('p_claim_rec.settled_from :'|| p_claim_rec.settled_from);
2571: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_number :'|| p_claim_rec.payment_reference_number);
2572: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_id:'|| p_claim_rec.payment_reference_id);
2573: END IF;

Line 2570: OZF_Utility_PVT.debug_message('p_claim_rec.settled_from :'|| p_claim_rec.settled_from);

2566:
2567: IF OZF_DEBUG_HIGH_ON THEN
2568: OZF_Utility_PVT.debug_message('l_app_match_cr :'||l_app_match_cr);
2569: OZF_Utility_PVT.debug_message('l_app_new_cr :'|| l_app_new_cr);
2570: OZF_Utility_PVT.debug_message('p_claim_rec.settled_from :'|| p_claim_rec.settled_from);
2571: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_number :'|| p_claim_rec.payment_reference_number);
2572: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_id:'|| p_claim_rec.payment_reference_id);
2573: END IF;
2574:

Line 2571: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_number :'|| p_claim_rec.payment_reference_number);

2567: IF OZF_DEBUG_HIGH_ON THEN
2568: OZF_Utility_PVT.debug_message('l_app_match_cr :'||l_app_match_cr);
2569: OZF_Utility_PVT.debug_message('l_app_new_cr :'|| l_app_new_cr);
2570: OZF_Utility_PVT.debug_message('p_claim_rec.settled_from :'|| p_claim_rec.settled_from);
2571: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_number :'|| p_claim_rec.payment_reference_number);
2572: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_id:'|| p_claim_rec.payment_reference_id);
2573: END IF;
2574:
2575: -- End of Rule Based Settlement

Line 2572: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_id:'|| p_claim_rec.payment_reference_id);

2568: OZF_Utility_PVT.debug_message('l_app_match_cr :'||l_app_match_cr);
2569: OZF_Utility_PVT.debug_message('l_app_new_cr :'|| l_app_new_cr);
2570: OZF_Utility_PVT.debug_message('p_claim_rec.settled_from :'|| p_claim_rec.settled_from);
2571: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_number :'|| p_claim_rec.payment_reference_number);
2572: OZF_Utility_PVT.debug_message('p_claim_rec.payment_reference_id:'|| p_claim_rec.payment_reference_id);
2573: END IF;
2574:
2575: -- End of Rule Based Settlement
2576: l_curr_status := p_claim_rec.status_code;

Line 2744: OZF_Utility_PVT.debug_message('l_approval_require:' || l_approval_require);

2740: l_approval_require := 'Y';
2741: END IF;
2742:
2743: IF OZF_DEBUG_HIGH_ON THEN
2744: OZF_Utility_PVT.debug_message('l_approval_require:' || l_approval_require);
2745: END IF;
2746: IF l_approval_require = 'Y' THEN
2747: Approve_Claim_for_Completion (
2748: x_return_status => l_return_status

Line 3002: OZF_Utility_PVT.debug_message('x_claim_rec.settled_date' || x_claim_rec.settled_date);

2998: END IF;
2999: --Printing the values for Claim Multi Currency
3000:
3001: IF OZF_DEBUG_HIGH_ON THEN
3002: OZF_Utility_PVT.debug_message('x_claim_rec.settled_date' || x_claim_rec.settled_date);
3003: OZF_Utility_PVT.debug_message('x_claim_rec.claim_id' || x_claim_rec.claim_id);
3004: OZF_Utility_PVT.debug_message('x_claim_rec.org_id' || x_claim_rec.org_id);
3005: OZF_Utility_PVT.debug_message('x_claim_rec.claim_number' || x_claim_rec.claim_number);
3006: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate_date);

Line 3003: OZF_Utility_PVT.debug_message('x_claim_rec.claim_id' || x_claim_rec.claim_id);

2999: --Printing the values for Claim Multi Currency
3000:
3001: IF OZF_DEBUG_HIGH_ON THEN
3002: OZF_Utility_PVT.debug_message('x_claim_rec.settled_date' || x_claim_rec.settled_date);
3003: OZF_Utility_PVT.debug_message('x_claim_rec.claim_id' || x_claim_rec.claim_id);
3004: OZF_Utility_PVT.debug_message('x_claim_rec.org_id' || x_claim_rec.org_id);
3005: OZF_Utility_PVT.debug_message('x_claim_rec.claim_number' || x_claim_rec.claim_number);
3006: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate_date);
3007: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate);

Line 3004: OZF_Utility_PVT.debug_message('x_claim_rec.org_id' || x_claim_rec.org_id);

3000:
3001: IF OZF_DEBUG_HIGH_ON THEN
3002: OZF_Utility_PVT.debug_message('x_claim_rec.settled_date' || x_claim_rec.settled_date);
3003: OZF_Utility_PVT.debug_message('x_claim_rec.claim_id' || x_claim_rec.claim_id);
3004: OZF_Utility_PVT.debug_message('x_claim_rec.org_id' || x_claim_rec.org_id);
3005: OZF_Utility_PVT.debug_message('x_claim_rec.claim_number' || x_claim_rec.claim_number);
3006: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate_date);
3007: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate);
3008: END IF;

Line 3005: OZF_Utility_PVT.debug_message('x_claim_rec.claim_number' || x_claim_rec.claim_number);

3001: IF OZF_DEBUG_HIGH_ON THEN
3002: OZF_Utility_PVT.debug_message('x_claim_rec.settled_date' || x_claim_rec.settled_date);
3003: OZF_Utility_PVT.debug_message('x_claim_rec.claim_id' || x_claim_rec.claim_id);
3004: OZF_Utility_PVT.debug_message('x_claim_rec.org_id' || x_claim_rec.org_id);
3005: OZF_Utility_PVT.debug_message('x_claim_rec.claim_number' || x_claim_rec.claim_number);
3006: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate_date);
3007: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate);
3008: END IF;
3009: -- Added For Multi currency ER - kpatro

Line 3006: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate_date);

3002: OZF_Utility_PVT.debug_message('x_claim_rec.settled_date' || x_claim_rec.settled_date);
3003: OZF_Utility_PVT.debug_message('x_claim_rec.claim_id' || x_claim_rec.claim_id);
3004: OZF_Utility_PVT.debug_message('x_claim_rec.org_id' || x_claim_rec.org_id);
3005: OZF_Utility_PVT.debug_message('x_claim_rec.claim_number' || x_claim_rec.claim_number);
3006: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate_date);
3007: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate);
3008: END IF;
3009: -- Added For Multi currency ER - kpatro
3010: IF(x_claim_rec.settled_date IS NOT NULL) THEN

Line 3007: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate);

3003: OZF_Utility_PVT.debug_message('x_claim_rec.claim_id' || x_claim_rec.claim_id);
3004: OZF_Utility_PVT.debug_message('x_claim_rec.org_id' || x_claim_rec.org_id);
3005: OZF_Utility_PVT.debug_message('x_claim_rec.claim_number' || x_claim_rec.claim_number);
3006: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate_date);
3007: OZF_Utility_PVT.debug_message('x_claim_rec.exchange_rate_date' || x_claim_rec.exchange_rate);
3008: END IF;
3009: -- Added For Multi currency ER - kpatro
3010: IF(x_claim_rec.settled_date IS NOT NULL) THEN
3011:

Line 3020: OZF_Utility_PVT.debug_message('l_return_status' ||l_return_status);

3016: , p_claim_rate => x_claim_rec.exchange_rate
3017: , x_return_status => l_return_status
3018: );
3019: IF OZF_DEBUG_HIGH_ON THEN
3020: OZF_Utility_PVT.debug_message('l_return_status' ||l_return_status);
3021: END IF;
3022:
3023: IF l_return_status = FND_API.g_ret_sts_error THEN
3024: RAISE FND_API.g_exc_error;

Line 3047: OZF_Utility_PVT.debug_message(l_full_name ||': end');

3043: p_data => x_msg_data
3044: );
3045:
3046: IF OZF_DEBUG_HIGH_ON THEN
3047: OZF_Utility_PVT.debug_message(l_full_name ||': end');
3048: END IF;
3049:
3050: EXCEPTION
3051: WHEN FND_API.g_exc_error THEN

Line 3144: OZF_Utility_PVT.debug_message(l_full_name||' : start');

3140: --------------------- initialize -----------------------
3141: SAVEPOINT Settle_Claim;
3142:
3143: IF OZF_DEBUG_HIGH_ON THEN
3144: OZF_Utility_PVT.debug_message(l_full_name||' : start');
3145: END IF;
3146:
3147: IF FND_API.to_boolean(p_init_msg_list) THEN
3148: FND_MSG_PUB.initialize;

Line 3232: OZF_Utility_PVT.debug_message('l_app_match_cr :'||l_app_match_cr);

3228: FETCH csr_rule_based_approval INTO l_app_match_cr,l_app_new_cr;
3229: CLOSE csr_rule_based_approval;
3230:
3231: IF OZF_DEBUG_HIGH_ON THEN
3232: OZF_Utility_PVT.debug_message('l_app_match_cr :'||l_app_match_cr);
3233: OZF_Utility_PVT.debug_message('l_app_new_cr :'|| l_app_new_cr);
3234: OZF_Utility_PVT.debug_message('l_claim_approval_attr.payment_reference_number :'|| l_claim_approval_attr.payment_reference_number);
3235: OZF_Utility_PVT.debug_message('l_claim_approval_attr.payment_reference_id :'|| l_claim_approval_attr.payment_reference_id);
3236: END IF;

Line 3233: OZF_Utility_PVT.debug_message('l_app_new_cr :'|| l_app_new_cr);

3229: CLOSE csr_rule_based_approval;
3230:
3231: IF OZF_DEBUG_HIGH_ON THEN
3232: OZF_Utility_PVT.debug_message('l_app_match_cr :'||l_app_match_cr);
3233: OZF_Utility_PVT.debug_message('l_app_new_cr :'|| l_app_new_cr);
3234: OZF_Utility_PVT.debug_message('l_claim_approval_attr.payment_reference_number :'|| l_claim_approval_attr.payment_reference_number);
3235: OZF_Utility_PVT.debug_message('l_claim_approval_attr.payment_reference_id :'|| l_claim_approval_attr.payment_reference_id);
3236: END IF;
3237:

Line 3234: OZF_Utility_PVT.debug_message('l_claim_approval_attr.payment_reference_number :'|| l_claim_approval_attr.payment_reference_number);

3230:
3231: IF OZF_DEBUG_HIGH_ON THEN
3232: OZF_Utility_PVT.debug_message('l_app_match_cr :'||l_app_match_cr);
3233: OZF_Utility_PVT.debug_message('l_app_new_cr :'|| l_app_new_cr);
3234: OZF_Utility_PVT.debug_message('l_claim_approval_attr.payment_reference_number :'|| l_claim_approval_attr.payment_reference_number);
3235: OZF_Utility_PVT.debug_message('l_claim_approval_attr.payment_reference_id :'|| l_claim_approval_attr.payment_reference_id);
3236: END IF;
3237:
3238: IF NVL(l_claim_approval_attr.settled_from,'X') <> 'RULEBASED' THEN

Line 3235: OZF_Utility_PVT.debug_message('l_claim_approval_attr.payment_reference_id :'|| l_claim_approval_attr.payment_reference_id);

3231: IF OZF_DEBUG_HIGH_ON THEN
3232: OZF_Utility_PVT.debug_message('l_app_match_cr :'||l_app_match_cr);
3233: OZF_Utility_PVT.debug_message('l_app_new_cr :'|| l_app_new_cr);
3234: OZF_Utility_PVT.debug_message('l_claim_approval_attr.payment_reference_number :'|| l_claim_approval_attr.payment_reference_number);
3235: OZF_Utility_PVT.debug_message('l_claim_approval_attr.payment_reference_id :'|| l_claim_approval_attr.payment_reference_id);
3236: END IF;
3237:
3238: IF NVL(l_claim_approval_attr.settled_from,'X') <> 'RULEBASED' THEN
3239: Claim_Approval_Required(

Line 3402: OZF_Utility_PVT.debug_message(l_full_name ||': end');

3398: p_data => x_msg_data
3399: );
3400:
3401: IF OZF_DEBUG_HIGH_ON THEN
3402: OZF_Utility_PVT.debug_message(l_full_name ||': end');
3403: END IF;
3404:
3405: EXCEPTION
3406: WHEN FND_API.g_exc_error THEN

Line 3484: OZF_Utility_PVT.debug_message(l_full_name||' : start');

3480: --------------------- initialize -----------------------
3481: SAVEPOINT Raise_Business_Event;
3482:
3483: IF OZF_DEBUG_HIGH_ON THEN
3484: OZF_Utility_PVT.debug_message(l_full_name||' : start');
3485: OZF_Utility_PVT.debug_message(l_full_name||' : event = '||p_event_name);
3486: END IF;
3487:
3488: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 3485: OZF_Utility_PVT.debug_message(l_full_name||' : event = '||p_event_name);

3481: SAVEPOINT Raise_Business_Event;
3482:
3483: IF OZF_DEBUG_HIGH_ON THEN
3484: OZF_Utility_PVT.debug_message(l_full_name||' : start');
3485: OZF_Utility_PVT.debug_message(l_full_name||' : event = '||p_event_name);
3486: END IF;
3487:
3488: IF FND_API.to_boolean(p_init_msg_list) THEN
3489: FND_MSG_PUB.initialize;

Line 3548: OZF_Utility_PVT.debug_message(l_full_name ||': end');

3544: p_data => x_msg_data
3545: );
3546:
3547: IF OZF_DEBUG_HIGH_ON THEN
3548: OZF_Utility_PVT.debug_message(l_full_name ||': end');
3549: END IF;
3550:
3551: EXCEPTION
3552: WHEN FND_API.g_exc_error THEN