DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PUB dependencies on OZF_UTILITY_PVT

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

396: RETURN;
397: END IF;
398:
399: IF G_DEBUG THEN
400: ozf_utility_pvt.debug_message('p_adj_rec.product_id: ' || p_adj_rec.product_id);
401: ozf_utility_pvt.debug_message('p_adj_rec.product_name: ' || p_adj_rec.product_name);
402: ozf_utility_pvt.debug_message('p_adj_rec.org_id: ' || p_adj_rec.org_id);
403: END IF;
404:

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

397: END IF;
398:
399: IF G_DEBUG THEN
400: ozf_utility_pvt.debug_message('p_adj_rec.product_id: ' || p_adj_rec.product_id);
401: ozf_utility_pvt.debug_message('p_adj_rec.product_name: ' || p_adj_rec.product_name);
402: ozf_utility_pvt.debug_message('p_adj_rec.org_id: ' || p_adj_rec.org_id);
403: END IF;
404:
405: IF p_adj_rec.product_name = fnd_api.g_miss_char OR p_adj_rec.product_name IS NULL THEN

Line 402: ozf_utility_pvt.debug_message('p_adj_rec.org_id: ' || p_adj_rec.org_id);

398:
399: IF G_DEBUG THEN
400: ozf_utility_pvt.debug_message('p_adj_rec.product_id: ' || p_adj_rec.product_id);
401: ozf_utility_pvt.debug_message('p_adj_rec.product_name: ' || p_adj_rec.product_name);
402: ozf_utility_pvt.debug_message('p_adj_rec.org_id: ' || p_adj_rec.org_id);
403: END IF;
404:
405: IF p_adj_rec.product_name = fnd_api.g_miss_char OR p_adj_rec.product_name IS NULL THEN
406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 589: ozf_utility_pvt.debug_message('l_parent_src_tbl.count: ' || l_parent_src_tbl.count);

585: RAISE fnd_api.g_exc_error;
586: END IF;
587:
588: IF G_DEBUG THEN
589: ozf_utility_pvt.debug_message('l_parent_src_tbl.count: ' || l_parent_src_tbl.count);
590: END IF;
591:
592: --check the number of records returned by l_parent_src_tbl. if no records returned, raise exception
593: IF l_parent_src_tbl.count > 0 THEN

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

785: FETCH c_orig_util_id INTO l_act_util_rec.orig_utilization_id, l_gl_posted_flag;
786: CLOSE c_orig_util_id;
787:
788: IF G_DEBUG THEN
789: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
790: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
791: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
792: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
793: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);

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

786: CLOSE c_orig_util_id;
787:
788: IF G_DEBUG THEN
789: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
790: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
791: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
792: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
793: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
794: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);

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

787:
788: IF G_DEBUG THEN
789: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
790: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
791: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
792: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
793: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
794: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
795: END IF;

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

788: IF G_DEBUG THEN
789: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
790: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
791: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
792: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
793: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
794: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
795: END IF;
796:

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

789: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
790: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
791: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
792: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
793: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
794: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
795: END IF;
796:
797: IF l_act_util_rec.orig_utilization_id IS NULL THEN

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

790: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
791: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
792: ozf_utility_pvt.debug_message('fund_id: ' || l_adj_rec.fund_id);
793: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
794: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
795: END IF;
796:
797: IF l_act_util_rec.orig_utilization_id IS NULL THEN
798: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

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

860: FETCH c_orig_util_id INTO l_act_util_rec.orig_utilization_id, l_gl_posted_flag;
861: CLOSE c_orig_util_id;
862:
863: IF G_DEBUG THEN
864: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
865: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
866: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
867: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
868: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);

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

861: CLOSE c_orig_util_id;
862:
863: IF G_DEBUG THEN
864: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
865: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
866: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
867: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
868: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
869: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);

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

862:
863: IF G_DEBUG THEN
864: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
865: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
866: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
867: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
868: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
869: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
870: END IF;

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

863: IF G_DEBUG THEN
864: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
865: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
866: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
867: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
868: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
869: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
870: END IF;
871:

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

864: ozf_utility_pvt.debug_message('orig_utilization_id: ' || l_act_util_rec.orig_utilization_id);
865: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
866: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
867: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
868: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
869: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
870: END IF;
871:
872: IF l_act_util_rec.orig_utilization_id IS NULL THEN

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

865: ozf_utility_pvt.debug_message('activity_id: ' || l_adj_rec.activity_id);
866: ozf_utility_pvt.debug_message('activity_type: ' || l_adj_rec.activity_type);
867: ozf_utility_pvt.debug_message('fund_id: ' || l_parent_src_tbl (i).fund_id);
868: ozf_utility_pvt.debug_message('product_id: ' || l_adj_rec.product_id);
869: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
870: END IF;
871:
872: IF l_act_util_rec.orig_utilization_id IS NULL THEN
873: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN