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_FUND_UTILIZED_PUB dependencies on OZF_UTILITY_PVT

Line 574: ozf_utility_pvt.debug_message('p_adj_rec.product_id: ' || p_adj_rec.product_id);

570: RETURN;
571: END IF;
572:
573: IF G_DEBUG THEN
574: ozf_utility_pvt.debug_message('p_adj_rec.product_id: ' || p_adj_rec.product_id);
575: ozf_utility_pvt.debug_message('p_adj_rec.product_name: ' || p_adj_rec.product_name);
576: ozf_utility_pvt.debug_message('l_inv_org_id: ' || l_inv_org_id);
577: END IF;
578:

Line 575: ozf_utility_pvt.debug_message('p_adj_rec.product_name: ' || p_adj_rec.product_name);

571: END IF;
572:
573: IF G_DEBUG THEN
574: ozf_utility_pvt.debug_message('p_adj_rec.product_id: ' || p_adj_rec.product_id);
575: ozf_utility_pvt.debug_message('p_adj_rec.product_name: ' || p_adj_rec.product_name);
576: ozf_utility_pvt.debug_message('l_inv_org_id: ' || l_inv_org_id);
577: END IF;
578:
579: IF p_adj_rec.product_name = fnd_api.g_miss_char OR p_adj_rec.product_name IS NULL THEN

Line 576: ozf_utility_pvt.debug_message('l_inv_org_id: ' || l_inv_org_id);

572:
573: IF G_DEBUG THEN
574: ozf_utility_pvt.debug_message('p_adj_rec.product_id: ' || p_adj_rec.product_id);
575: ozf_utility_pvt.debug_message('p_adj_rec.product_name: ' || p_adj_rec.product_name);
576: ozf_utility_pvt.debug_message('l_inv_org_id: ' || l_inv_org_id);
577: END IF;
578:
579: IF p_adj_rec.product_name = fnd_api.g_miss_char OR p_adj_rec.product_name IS NULL THEN
580: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 613: ozf_utility_pvt.debug_message('l_inv_org_id: ' || l_inv_org_id);

609: FETCH c_inventory_org INTO l_inv_org_id;
610: CLOSE c_inventory_org;
611:
612: IF G_DEBUG THEN
613: ozf_utility_pvt.debug_message('l_inv_org_id: ' || l_inv_org_id);
614: END IF;
615: END IF;
616:
617: OPEN c_valid_product (p_adj_rec.product_name, l_inv_org_id);

Line 1344: ozf_utility_pvt.convert_currency (

1340:
1341: IF l_offer_currency.transaction_currency_code IS NULL
1342: OR l_offer_currency.transaction_currency_code = FND_API.G_MISS_CHAR THEN
1343: IF l_adj_rec.plan_currency_code <> l_offer_currency.fund_request_curr_code THEN
1344: ozf_utility_pvt.convert_currency (
1345: x_return_status => x_return_status
1346: ,p_from_currency => l_adj_rec.plan_currency_code
1347: ,p_to_currency => l_offer_currency.fund_request_curr_code
1348: ,p_from_amount => l_adj_rec.plan_amount

Line 1450: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);

1446: FETCH c_orig_util_id INTO l_act_util_rec.orig_utilization_id, l_gl_posted_flag;
1447: CLOSE c_orig_util_id;
1448:
1449: IF G_DEBUG THEN
1450: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
1451: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1452: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1453: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
1454: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);

Line 1451: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);

1447: CLOSE c_orig_util_id;
1448:
1449: IF G_DEBUG THEN
1450: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
1451: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1452: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1453: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
1454: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
1455: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);

Line 1452: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);

1448:
1449: IF G_DEBUG THEN
1450: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
1451: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1452: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1453: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
1454: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
1455: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
1456: END IF;

Line 1453: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);

1449: IF G_DEBUG THEN
1450: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
1451: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1452: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1453: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
1454: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
1455: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
1456: END IF;
1457:

Line 1454: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);

1450: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
1451: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1452: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1453: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
1454: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
1455: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
1456: END IF;
1457:
1458: IF l_act_util_rec.orig_utilization_id IS NULL THEN

Line 1455: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);

1451: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1452: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1453: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
1454: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
1455: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
1456: END IF;
1457:
1458: IF l_act_util_rec.orig_utilization_id IS NULL THEN
1459: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 1493: ozf_utility_pvt.convert_currency (

1489: IF ((l_act_budgets_rec.parent_src_apprvd_amt IS NULL
1490: OR l_act_budgets_rec.parent_src_apprvd_amt = fnd_api.g_miss_num)
1491: AND l_act_budgets_rec.request_currency <> l_act_budgets_rec.parent_src_curr) THEN
1492:
1493: ozf_utility_pvt.convert_currency (
1494: x_return_status=> x_return_status
1495: ,p_from_currency=> l_act_budgets_rec.request_currency
1496: ,p_to_currency=> l_act_budgets_rec.parent_src_curr
1497: ,p_conv_type=>l_exchange_rate_type --Added for bug 7030415

Line 1516: ozf_utility_pvt.convert_currency (

1512: IF l_act_budgets_rec.request_currency <> l_act_budgets_rec.parent_src_curr
1513: AND (l_act_budgets_rec.request_amount IS NULL
1514: OR l_act_budgets_rec.request_amount = fnd_api.g_miss_num) THEN
1515: --nirprasa,ER 8399134
1516: ozf_utility_pvt.convert_currency (
1517: x_return_status=> x_return_status
1518: ,p_from_currency=> l_act_budgets_rec.parent_src_curr
1519: ,p_to_currency=> l_act_budgets_rec.request_currency
1520: ,p_conv_type=>l_exchange_rate_type --Added for bug 7030415

Line 1583: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);

1579: FETCH c_orig_util_id INTO l_act_util_rec.orig_utilization_id, l_gl_posted_flag;
1580: CLOSE c_orig_util_id;
1581:
1582: IF G_DEBUG THEN
1583: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
1584: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1585: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1586: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
1587: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);

Line 1584: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);

1580: CLOSE c_orig_util_id;
1581:
1582: IF G_DEBUG THEN
1583: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
1584: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1585: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1586: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
1587: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
1588: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);

Line 1585: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);

1581:
1582: IF G_DEBUG THEN
1583: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
1584: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1585: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1586: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
1587: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
1588: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
1589: END IF;

Line 1586: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);

1582: IF G_DEBUG THEN
1583: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
1584: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1585: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1586: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
1587: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
1588: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
1589: END IF;
1590:

Line 1587: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);

1583: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
1584: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1585: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1586: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
1587: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
1588: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
1589: END IF;
1590:
1591: IF l_act_util_rec.orig_utilization_id IS NULL THEN

Line 1588: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);

1584: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
1585: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
1586: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
1587: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
1588: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
1589: END IF;
1590:
1591: IF l_act_util_rec.orig_utilization_id IS NULL THEN
1592: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN