[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
4337: FROM cn_rt_quota_asgns
4338: WHERE quota_id = pe_id
4339: ORDER BY start_date;
4340: BEGIN
4341: -- Standard Start of API savepoint
4342: SAVEPOINT get_plan_element;
4343:
4344: -- Standard call to check for call compatibility.
4345: IF NOT fnd_api.compatible_api_call (p_api_version, p_api_version, l_api_name, g_pkg_name)
4340: BEGIN
4341: -- Standard Start of API savepoint
4342: SAVEPOINT get_plan_element;
4343:
4344: -- Standard call to check for call compatibility.
4345: IF NOT fnd_api.compatible_api_call (p_api_version, p_api_version, l_api_name, g_pkg_name)
4346: THEN
4347: RAISE fnd_api.g_exc_unexpected_error;
4348: END IF;
4524:
4525: CLOSE c_rt_quota_asgns_rec_csr;
4526:
4527: -- End of API body.
4528: -- Standard check of p_commit.
4529: IF fnd_api.to_boolean (p_commit)
4530: THEN
4531: COMMIT WORK;
4532: END IF;
4532: END IF;
4533:
4534: <
4535: NULL;
4536: -- Standard call to get message count and if count is 1, get message info.
4537: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4538: -- END get plan element
4539: EXCEPTION
4540: WHEN fnd_api.g_exc_error
4653: l_suffix varchar2(10) := null;
4654: l_prefix varchar2(10) := null;
4655:
4656: BEGIN
4657: -- Standard Start of API savepoint
4658: SAVEPOINT duplicate_pe;
4659:
4660: -- Standard call to check for call compatibility.
4661: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
4656: BEGIN
4657: -- Standard Start of API savepoint
4658: SAVEPOINT duplicate_pe;
4659:
4660: -- Standard call to check for call compatibility.
4661: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
4662: THEN
4663: RAISE fnd_api.g_exc_unexpected_error;
4664: END IF;
4936:
4937: x_return_status := fnd_api.g_ret_sts_success;
4938:
4939: -- End of API body.
4940: -- Standard check of p_commit.
4941: IF fnd_api.to_boolean (p_commit)
4942: THEN
4943: COMMIT WORK;
4944: END IF;
4942: THEN
4943: COMMIT WORK;
4944: END IF;
4945:
4946: -- Standard call to get message count and if count is 1, get message info.
4947: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4948: -- End of Duplicate Plan ELement
4949: EXCEPTION
4950: WHEN fnd_api.g_exc_error