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:
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
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
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
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);
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);
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;
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:
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
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
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);
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);
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;
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:
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
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