1: PACKAGE BODY OZF_Fund_Extension_Pvt AS
2: /* $Header: ozfvfexb.pls 120.1 2011/10/17 06:37:12 ninarasi ship $*/
3: g_pkg_name CONSTANT VARCHAR2(30) := 'OZF_Fund_Extension_Pvt';
4: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
5:
6: ---------------------------------------------------------------------
7: -- PROCEDURE
8: --- get_object_info
316:
317: EXCEPTION
318: WHEN OTHERS THEN
319: x_return_status := fnd_api.g_ret_sts_unexp_error;
320: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
321: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
322: END IF;
323: fnd_msg_pub.count_and_get(
324: p_encoded => fnd_api.g_false
317: EXCEPTION
318: WHEN OTHERS THEN
319: x_return_status := fnd_api.g_ret_sts_unexp_error;
320: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
321: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
322: END IF;
323: fnd_msg_pub.count_and_get(
324: p_encoded => fnd_api.g_false
325: ,p_count => x_msg_count
319: x_return_status := fnd_api.g_ret_sts_unexp_error;
320: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
321: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
322: END IF;
323: fnd_msg_pub.count_and_get(
324: p_encoded => fnd_api.g_false
325: ,p_count => x_msg_count
326: ,p_data => x_msg_data);
327: END get_actbudgets;
449:
450: EXCEPTION
451: WHEN OTHERS THEN
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
454: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
455: END IF;
456: fnd_msg_pub.count_and_get(
457: p_encoded => fnd_api.g_false
450: EXCEPTION
451: WHEN OTHERS THEN
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
454: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
455: END IF;
456: fnd_msg_pub.count_and_get(
457: p_encoded => fnd_api.g_false
458: ,p_count => x_msg_count
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
454: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
455: END IF;
456: fnd_msg_pub.count_and_get(
457: p_encoded => fnd_api.g_false
458: ,p_count => x_msg_count
459: ,p_data => x_msg_data);
460:
561:
562: EXCEPTION
563: WHEN fnd_api.g_exc_error THEN
564: x_return_status := fnd_api.g_ret_sts_error;
565: fnd_msg_pub.count_and_get(
566: p_encoded => fnd_api.g_false
567: ,p_count => x_msg_count
568: ,p_data => x_msg_data);
569: WHEN fnd_api.g_exc_unexpected_error THEN
567: ,p_count => x_msg_count
568: ,p_data => x_msg_data);
569: WHEN fnd_api.g_exc_unexpected_error THEN
570: x_return_status := fnd_api.g_ret_sts_unexp_error;
571: fnd_msg_pub.count_and_get(
572: p_encoded => fnd_api.g_false
573: ,p_count => x_msg_count
574: ,p_data => x_msg_data);
575: WHEN OTHERS THEN
573: ,p_count => x_msg_count
574: ,p_data => x_msg_data);
575: WHEN OTHERS THEN
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
578: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
579: END IF;
580: fnd_msg_pub.count_and_get(
581: p_encoded => fnd_api.g_false
574: ,p_data => x_msg_data);
575: WHEN OTHERS THEN
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
578: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
579: END IF;
580: fnd_msg_pub.count_and_get(
581: p_encoded => fnd_api.g_false
582: ,p_count => x_msg_count
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
578: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
579: END IF;
580: fnd_msg_pub.count_and_get(
581: p_encoded => fnd_api.g_false
582: ,p_count => x_msg_count
583: ,p_data => x_msg_data);
584:
807:
808: --ninarasi fix for motorola bug 13054588
809: IF l_utiz_count = 1 THEN
810: FND_MESSAGE.set_name('OZF', 'OZF_DEL_FUND_ACCRUALS');
811: FND_MSG_PUB.add;
812: RAISE fnd_api.g_exc_unexpected_error;
813: END IF;
814:
815: FOR child_rec IN c_get_child_funds LOOP
1090: EXCEPTION
1091: WHEN fnd_api.g_exc_error THEN
1092: -- dbms_output.put_line('delete_fund_schema exception expected error');
1093: x_return_status := fnd_api.g_ret_sts_error;
1094: fnd_msg_pub.count_and_get(
1095: p_encoded => fnd_api.g_false
1096: ,p_count => x_msg_count
1097: ,p_data => x_msg_data);
1098: WHEN fnd_api.g_exc_unexpected_error THEN
1097: ,p_data => x_msg_data);
1098: WHEN fnd_api.g_exc_unexpected_error THEN
1099: -- dbms_output.put_line('delete_fund_schema exception unexpected error');
1100: x_return_status := fnd_api.g_ret_sts_unexp_error;
1101: fnd_msg_pub.count_and_get(
1102: p_encoded => fnd_api.g_false
1103: ,p_count => x_msg_count
1104: ,p_data => x_msg_data);
1105: WHEN OTHERS THEN
1104: ,p_data => x_msg_data);
1105: WHEN OTHERS THEN
1106: -- dbms_output.put_line('delete_fund_schema exception other error');
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1109: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1110: END IF;
1111: fnd_msg_pub.count_and_get(
1112: p_encoded => fnd_api.g_false
1105: WHEN OTHERS THEN
1106: -- dbms_output.put_line('delete_fund_schema exception other error');
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1109: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1110: END IF;
1111: fnd_msg_pub.count_and_get(
1112: p_encoded => fnd_api.g_false
1113: ,p_count => x_msg_count
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1109: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1110: END IF;
1111: fnd_msg_pub.count_and_get(
1112: p_encoded => fnd_api.g_false
1113: ,p_count => x_msg_count
1114: ,p_data => x_msg_data);
1115: END delete_fund_schema;
1141: l_api_name CONSTANT VARCHAR2(30) := 'delete_fund';
1142: BEGIN
1143: -- Initialize message list IF p_init_msg_list is set to TRUE.
1144: IF fnd_api.to_boolean (p_init_msg_list) THEN
1145: fnd_msg_pub.initialize;
1146: END IF;
1147:
1148: delete_fund_schema(
1149: p_api_version_number => p_api_version_number
1162:
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: -- dbms_output.put_line('delete_fund exception other error');
1166: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1168: END IF;
1169: fnd_msg_pub.count_and_get(
1170: p_encoded => fnd_api.g_false
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: -- dbms_output.put_line('delete_fund exception other error');
1166: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1168: END IF;
1169: fnd_msg_pub.count_and_get(
1170: p_encoded => fnd_api.g_false
1171: ,p_count => x_msg_count
1165: -- dbms_output.put_line('delete_fund exception other error');
1166: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1168: END IF;
1169: fnd_msg_pub.count_and_get(
1170: p_encoded => fnd_api.g_false
1171: ,p_count => x_msg_count
1172: ,p_data => x_msg_data);
1173: END delete_fund;