[Home] [Help]
18:
19:
20: IF p_payment_group_code is null
21: THEN
22: p_payment_group_code := 'STANDARD';
23:
24: ELSE
25:
26: -- Check/Valid quota_type_code
1587: RAISE fnd_api.g_exc_error;
1588: END IF;
1589: END IF;
1590:
1591: -- Standard message count
1592: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1593: -- end check_quota_exists
1594: EXCEPTION
1595: WHEN fnd_api.g_exc_error
1766:
1767: -- End of API body.
1768: <
1769: NULL;
1770: -- Standard call to get message count and if count is 1, get message info.
1771: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1772: -- end valid_plan_element
1773: EXCEPTION
1774: WHEN fnd_api.g_exc_error
1971: THEN
1972: RAISE fnd_api.g_exc_error;
1973: END IF;
1974:
1975: -- Standard call to get message count and if count is 1, get message info.
1976: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1977: -- End of Check_valid_update
1978: EXCEPTION
1979: WHEN fnd_api.g_exc_error
2052: l_status VARCHAR2(1);
2053: p_payment_group_code l_p_plan_element_rec.payment_group_code%type;
2054:
2055: BEGIN
2056: -- Standard Start of API savepoint
2057: SAVEPOINT create_plan_element;
2058:
2059: -- Standard call to check for call compatibility.
2060: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2055: BEGIN
2056: -- Standard Start of API savepoint
2057: SAVEPOINT create_plan_element;
2058:
2059: -- Standard call to check for call compatibility.
2060: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2061: THEN
2062: RAISE fnd_api.g_exc_unexpected_error;
2063: END IF;
2449: p_trx_factor_rec_tbl => l_p_trx_factor_rec_tbl,
2450: x_loading_status => x_loading_status
2451: );
2452:
2453: -- standard check to insert status if the return status is not succes
2454: -- raise an error
2455: IF (x_return_status <> fnd_api.g_ret_sts_success)
2456: THEN
2457: RAISE fnd_api.g_exc_error;
2624: -- End of API body
2625: <
2626: NULL;
2627:
2628: -- Standard check of p_commit.
2629: IF fnd_api.to_boolean (p_commit)
2630: THEN
2631: COMMIT WORK;
2632: END IF;
2631: COMMIT WORK;
2632: END IF;
2633:
2634: --
2635: -- Standard call to get message count and if count is 1, get message info.
2636: --
2637: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2638: EXCEPTION
2639: WHEN fnd_api.g_exc_error
2818: FROM cn_quotas_v cq,
2819: cn_calc_formulas ccf
2820: WHERE cq.quota_id = l_quota_id AND cq.calc_formula_id = ccf.calc_formula_id;
2821: BEGIN
2822: -- Standard Start of API savepoint
2823: SAVEPOINT update_plan_element;
2824:
2825: -- Standard call to check for call compatibility.
2826: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2821: BEGIN
2822: -- Standard Start of API savepoint
2823: SAVEPOINT update_plan_element;
2824:
2825: -- Standard call to check for call compatibility.
2826: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2827: THEN
2828: RAISE fnd_api.g_exc_unexpected_error;
2829: END IF;
3492: END IF;
3493:
3494: x_return_status := fnd_api.g_ret_sts_success;
3495:
3496: -- Standard check of p_commit.
3497: IF fnd_api.to_boolean (p_commit)
3498: THEN
3499: COMMIT WORK;
3500: END IF;
3498: THEN
3499: COMMIT WORK;
3500: END IF;
3501:
3502: -- Standard call to get message count and if count is 1, get message info.
3503: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3504: -- End of Update Plan Element
3505: EXCEPTION
3506: WHEN fnd_api.g_exc_error
3622: l_loading_status VARCHAR2 (80);
3623: l_org_id cn_quotas.org_id%TYPE;
3624: l_quota_id cn_quotas.quota_id%TYPE;
3625: BEGIN
3626: -- Standard Start of API savepoint
3627: SAVEPOINT process_input_records;
3628: -- Initialize API return status to success
3629: x_return_status := fnd_api.g_ret_sts_success;
3630: l_p_quota_name := p_quota_rec.NAME;
3783: l_val_org_id NUMBER;
3784: l_status VARCHAR2(1);
3785:
3786: BEGIN
3787: -- Standard Start of API savepoint
3788: SAVEPOINT delete_plan_element;
3789:
3790: -- Standard call to check for call compatibility.
3791: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
3786: BEGIN
3787: -- Standard Start of API savepoint
3788: SAVEPOINT delete_plan_element;
3789:
3790: -- Standard call to check for call compatibility.
3791: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
3792: THEN
3793: RAISE fnd_api.g_exc_unexpected_error;
3794: END IF;
4054: END IF;
4055:
4056: x_return_status := fnd_api.g_ret_sts_success;
4057:
4058: -- Standard Commit.
4059: IF fnd_api.to_boolean (p_commit)
4060: THEN
4061: COMMIT WORK;
4062: END IF;
4061: COMMIT WORK;
4062: END IF;
4063:
4064: --
4065: -- Standard call to get message count and if count is 1, get message info.
4066: --
4067: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4068: -- End of Delete Plan Element
4069: EXCEPTION
4355:
4356:
4357:
4358: BEGIN
4359: -- Standard Start of API savepoint
4360: SAVEPOINT get_plan_element;
4361:
4362: -- Standard call to check for call compatibility.
4363: IF NOT fnd_api.compatible_api_call (p_api_version, p_api_version, l_api_name, g_pkg_name)
4358: BEGIN
4359: -- Standard Start of API savepoint
4360: SAVEPOINT get_plan_element;
4361:
4362: -- Standard call to check for call compatibility.
4363: IF NOT fnd_api.compatible_api_call (p_api_version, p_api_version, l_api_name, g_pkg_name)
4364: THEN
4365: RAISE fnd_api.g_exc_unexpected_error;
4366: END IF;
4561:
4562: CLOSE c_rt_quota_asgns_rec_csr;
4563:
4564: -- End of API body.
4565: -- Standard check of p_commit.
4566: IF fnd_api.to_boolean (p_commit)
4567: THEN
4568: COMMIT WORK;
4569: END IF;
4569: END IF;
4570:
4571: <
4572: NULL;
4573: -- Standard call to get message count and if count is 1, get message info.
4574: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4575: -- END get plan element
4576: EXCEPTION
4577: WHEN fnd_api.g_exc_error
4690: l_suffix varchar2(10) := null;
4691: l_prefix varchar2(10) := null;
4692:
4693: BEGIN
4694: -- Standard Start of API savepoint
4695: SAVEPOINT duplicate_pe;
4696:
4697: -- Standard call to check for call compatibility.
4698: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
4693: BEGIN
4694: -- Standard Start of API savepoint
4695: SAVEPOINT duplicate_pe;
4696:
4697: -- Standard call to check for call compatibility.
4698: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
4699: THEN
4700: RAISE fnd_api.g_exc_unexpected_error;
4701: END IF;
4973:
4974: x_return_status := fnd_api.g_ret_sts_success;
4975:
4976: -- End of API body.
4977: -- Standard check of p_commit.
4978: IF fnd_api.to_boolean (p_commit)
4979: THEN
4980: COMMIT WORK;
4981: END IF;
4979: THEN
4980: COMMIT WORK;
4981: END IF;
4982:
4983: -- Standard call to get message count and if count is 1, get message info.
4984: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4985: -- End of Duplicate Plan ELement
4986: EXCEPTION
4987: WHEN fnd_api.g_exc_error