eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_PLAN_ELEMENT_PUB

Line 1: PACKAGE BODY CN_PLAN_ELEMENT_PUB AS

1: PACKAGE BODY CN_PLAN_ELEMENT_PUB AS
2: /* $Header: cnppeb.pls 120.12 2007/10/19 11:56:08 rnagired ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_PLAN_ELEMENT_PUB';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnppeb.pls';
5:

Line 3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_PLAN_ELEMENT_PUB';

1: PACKAGE BODY CN_PLAN_ELEMENT_PUB AS
2: /* $Header: cnppeb.pls 120.12 2007/10/19 11:56:08 rnagired ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_PLAN_ELEMENT_PUB';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnppeb.pls';
5:
6:
7: PROCEDURE validate_payment_group_code (

Line 2082: 'cn.plsql.cn_plan_element_pub.create_plan_element.org_validate',

2078: status => l_status);
2079:
2080: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2081: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2082: 'cn.plsql.cn_plan_element_pub.create_plan_element.org_validate',
2083: 'Validated org_id = ' || l_org_id || ' status = '||l_status);
2084: end if;
2085: -- END OF MOAC ORG_ID VALIDATION
2086:

Line 2109: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'CREATE_PLAN_ELEMENT', 'B', 'C')

2105:
2106:
2107:
2108: /* pre processing call */
2109: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'CREATE_PLAN_ELEMENT', 'B', 'C')
2110: THEN
2111: cn_plan_element_cuhk.create_plan_element_pre (p_api_version => p_api_version,
2112: p_init_msg_list => p_init_msg_list,
2113: p_commit => fnd_api.g_false,

Line 2136: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'CREATE_PLAN_ELEMENT', 'B', 'V')

2132: RAISE fnd_api.g_exc_unexpected_error;
2133: END IF;
2134: END IF;
2135:
2136: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'CREATE_PLAN_ELEMENT', 'B', 'V')
2137: THEN
2138: cn_plan_element_vuhk.create_plan_element_pre (p_api_version => p_api_version,
2139: p_init_msg_list => p_init_msg_list,
2140: p_commit => fnd_api.g_false,

Line 2532: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'CREATE_PLAN_ELEMENT', 'A', 'V')

2528: END IF;
2529: END IF;
2530:
2531: /* Post processing */
2532: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'CREATE_PLAN_ELEMENT', 'A', 'V')
2533: THEN
2534: cn_plan_element_vuhk.create_plan_element_post (p_api_version => p_api_version,
2535: p_init_msg_list => p_init_msg_list,
2536: p_commit => fnd_api.g_false,

Line 2559: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'CREATE_PLAN_ELEMENT', 'A', 'C')

2555: RAISE fnd_api.g_exc_unexpected_error;
2556: END IF;
2557: END IF;
2558:
2559: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'CREATE_PLAN_ELEMENT', 'A', 'C')
2560: THEN
2561: cn_plan_element_cuhk.create_plan_element_post (p_api_version => p_api_version,
2562: p_init_msg_list => p_init_msg_list,
2563: p_commit => fnd_api.g_false,

Line 2587: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'CREATE_PLAN_ELEMENT', 'M', 'M')

2583: END IF;
2584: END IF;
2585:
2586: /* Following code is for message generation */
2587: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'CREATE_PLAN_ELEMENT', 'M', 'M')
2588: THEN
2589: IF (cn_plan_element_cuhk.ok_to_generate_msg (p_plan_element_rec => l_p_plan_element_rec,
2590: p_revenue_class_rec_tbl => l_p_revenue_class_rec_tbl,
2591: p_rev_uplift_rec_tbl => l_p_rev_uplift_rec_tbl,

Line 2848: 'cn.plsql.cn_plan_element_pub.update_plan_element.org_validate',

2844: status => l_status);
2845:
2846: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2847: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2848: 'cn.plsql.cn_plan_element_pub.update_plan_element.org_validate',
2849: 'Validated org_id = ' || l_org_id || ' status = '||l_status);
2850: end if;
2851: -- END OF MOAC ORG_ID VALIDATION
2852:

Line 2873: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'UPDATE_PLAN_ELEMENT', 'B', 'C')

2869: RAISE fnd_api.g_exc_error;
2870: END IF;
2871:
2872: /* pre processing call */
2873: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'UPDATE_PLAN_ELEMENT', 'B', 'C')
2874: THEN
2875: cn_plan_element_cuhk.update_plan_element_pre (p_api_version => p_api_version,
2876: p_init_msg_list => p_init_msg_list,
2877: p_commit => fnd_api.g_false,

Line 2901: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'UPDATE_PLAN_ELEMENT', 'B', 'V')

2897: RAISE fnd_api.g_exc_unexpected_error;
2898: END IF;
2899: END IF;
2900:
2901: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'UPDATE_PLAN_ELEMENT', 'B', 'V')
2902: THEN
2903: cn_plan_element_vuhk.update_plan_element_pre (p_api_version => p_api_version,
2904: p_init_msg_list => p_init_msg_list,
2905: p_commit => fnd_api.g_false,

Line 3401: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'UPDATE_PLAN_ELEMENT', 'A', 'V')

3397: END IF;
3398: END IF; -- end if x_loading_status = 'CN_CHILD'
3399:
3400: /* Post processing */
3401: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'UPDATE_PLAN_ELEMENT', 'A', 'V')
3402: THEN
3403: cn_plan_element_vuhk.update_plan_element_post (p_api_version => p_api_version,
3404: p_init_msg_list => p_init_msg_list,
3405: p_commit => fnd_api.g_false,

Line 3429: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'UPDATE_PLAN_ELEMENT', 'A', 'C')

3425: RAISE fnd_api.g_exc_unexpected_error;
3426: END IF;
3427: END IF;
3428:
3429: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'UPDATE_PLAN_ELEMENT', 'A', 'C')
3430: THEN
3431: cn_plan_element_cuhk.update_plan_element_post (p_api_version => p_api_version,
3432: p_init_msg_list => p_init_msg_list,
3433: p_commit => fnd_api.g_false,

Line 3458: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'UPDATE_PLAN_ELEMENT', 'M', 'M')

3454: END IF;
3455: END IF;
3456:
3457: /* Following code is for message generation */
3458: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'UPDATE_PLAN_ELEMENT', 'M', 'M')
3459: THEN
3460: IF (cn_plan_element_cuhk.ok_to_generate_msg (p_plan_element_rec => l_p_new_plan_element_rec,
3461: p_revenue_class_rec_tbl => l_p_revenue_class_rec_tbl,
3462: p_rev_uplift_rec_tbl => l_p_rev_uplift_rec_tbl,

Line 3813: 'cn.plsql.cn_plan_element_pub.delete_plan_element.org_validate',

3809: status => l_status);
3810:
3811: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3812: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3813: 'cn.plsql.cn_plan_element_pub.delete_plan_element.org_validate',
3814: 'Validated org_id = ' || l_val_org_id || ' status = '||l_status);
3815: end if;
3816: -- END OF MOAC ORG_ID VALIDATION
3817:

Line 3840: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DELETE_PLAN_ELEMENT', 'B', 'C')

3836:
3837:
3838:
3839: /* 1. Calling BEFORE-CUSTOM Hook */
3840: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DELETE_PLAN_ELEMENT', 'B', 'C')
3841: THEN
3842: cn_plan_element_cuhk.delete_plan_element_pre (p_api_version => p_api_version,
3843: p_init_msg_list => p_init_msg_list,
3844: p_commit => fnd_api.g_false,

Line 3859: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DELETE_PLAN_ELEMENT', 'B', 'V')

3855: check_status (p_return_status => x_return_status);
3856: END IF;
3857:
3858: /* 2. Calling BEFORE-VERTICAL Hook */
3859: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DELETE_PLAN_ELEMENT', 'B', 'V')
3860: THEN
3861: cn_plan_element_vuhk.delete_plan_element_pre (p_api_version => p_api_version,
3862: p_init_msg_list => p_init_msg_list,
3863: p_commit => fnd_api.g_false,

Line 3993: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DELETE_PLAN_ELEMENT', 'A', 'V')

3989: END IF;
3990: END IF; /* ## MAIN IF ENDS ## */
3991:
3992: /* Post processing */
3993: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DELETE_PLAN_ELEMENT', 'A', 'V')
3994: THEN
3995: cn_plan_element_vuhk.delete_plan_element_post (p_api_version => p_api_version,
3996: p_init_msg_list => p_init_msg_list,
3997: p_commit => fnd_api.g_false,

Line 4011: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DELETE_PLAN_ELEMENT', 'A', 'C')

4007: );
4008: check_status (p_return_status => x_return_status);
4009: END IF;
4010:
4011: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DELETE_PLAN_ELEMENT', 'A', 'C')
4012: THEN
4013: cn_plan_element_cuhk.delete_plan_element_post (p_api_version => p_api_version,
4014: p_init_msg_list => p_init_msg_list,
4015: p_commit => fnd_api.g_false,

Line 4030: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DELETE_PLAN_ELEMENT', 'M', 'M')

4026: check_status (p_return_status => x_return_status);
4027: END IF;
4028:
4029: /* Following code is for message generation */
4030: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DELETE_PLAN_ELEMENT', 'M', 'M')
4031: THEN
4032: IF (cn_plan_element_cuhk.ok_to_generate_msg (p_plan_element_name => l_p_quota_name,
4033: p_revenue_class_rec_tbl => l_p_revenue_class_rec_tbl,
4034: p_rev_uplift_rec_tbl => l_p_rev_uplift_rec_tbl,

Line 4636: l_plan_element_rec cn_plan_element_pub.plan_element_rec_type;

4632: )
4633: IS
4634: l_api_name CONSTANT VARCHAR2 (30) := 'Duplicate_Plan_Element';
4635: l_api_version CONSTANT NUMBER := 1.0;
4636: l_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
4637: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
4638: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4639: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4640: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;

Line 4637: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;

4633: IS
4634: l_api_name CONSTANT VARCHAR2 (30) := 'Duplicate_Plan_Element';
4635: l_api_version CONSTANT NUMBER := 1.0;
4636: l_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
4637: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
4638: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4639: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4640: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
4641: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;

Line 4638: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;

4634: l_api_name CONSTANT VARCHAR2 (30) := 'Duplicate_Plan_Element';
4635: l_api_version CONSTANT NUMBER := 1.0;
4636: l_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
4637: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
4638: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4639: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4640: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
4641: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
4642: l_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;

Line 4640: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;

4636: l_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
4637: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
4638: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4639: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4640: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
4641: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
4642: l_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
4643: l_length INTEGER := 30 - LENGTHB ('_2');
4644: l_name_too_long VARCHAR2 (1) := 'F';

Line 4641: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;

4637: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
4638: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4639: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4640: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
4641: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
4642: l_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
4643: l_length INTEGER := 30 - LENGTHB ('_2');
4644: l_name_too_long VARCHAR2 (1) := 'F';
4645: l_quota_id NUMBER;

Line 4642: l_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;

4638: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4639: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4640: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
4641: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
4642: l_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
4643: l_length INTEGER := 30 - LENGTHB ('_2');
4644: l_name_too_long VARCHAR2 (1) := 'F';
4645: l_quota_id NUMBER;
4646: l_warning_flag VARCHAR2 (1) := 'F';

Line 4683: 'cn.plsql.cn_plan_element_pub.duplicate_plan_element.org_validate',

4679: status => l_status);
4680:
4681: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4682: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4683: 'cn.plsql.cn_plan_element_pub.duplicate_plan_element.org_validate',
4684: 'Validated org_id = ' || l_org_id || ' status = '||l_status);
4685: end if;
4686: -- END OF MOAC ORG_ID VALIDATION
4687:

Line 4691: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'B', 'C')

4687:
4688: -- API body
4689: l_p_plan_element_name := p_plan_element_name;
4690:
4691: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'B', 'C')
4692: THEN
4693: cn_plan_element_cuhk.duplicate_plan_element_pre (p_api_version => p_api_version,
4694: p_init_msg_list => p_init_msg_list,
4695: p_commit => fnd_api.g_false,

Line 4714: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'B', 'V')

4710: RAISE fnd_api.g_exc_unexpected_error;
4711: END IF;
4712: END IF;
4713:
4714: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'B', 'V')
4715: THEN
4716: cn_plan_element_vuhk.duplicate_plan_element_pre (p_api_version => p_api_version,
4717: p_init_msg_list => p_init_msg_list,
4718: p_commit => fnd_api.g_false,

Line 4859: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'A', 'V')

4855: x_return_status := cn_api.g_ret_sts_warning;
4856: END IF;
4857: END IF;
4858:
4859: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'A', 'V')
4860: THEN
4861: cn_plan_element_vuhk.duplicate_plan_element_post (p_api_version => p_api_version,
4862: p_init_msg_list => p_init_msg_list,
4863: p_commit => fnd_api.g_false,

Line 4882: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'A', 'C')

4878: RAISE fnd_api.g_exc_unexpected_error;
4879: END IF;
4880: END IF;
4881:
4882: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'A', 'C')
4883: THEN
4884: cn_plan_element_cuhk.duplicate_plan_element_post (p_api_version => p_api_version,
4885: p_init_msg_list => p_init_msg_list,
4886: p_commit => fnd_api.g_false,

Line 4909: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'M', 'M')

4905: -- x_plan_element_name := l_x_plan_element_name;
4906: x_plan_element_name := cn_chk_plan_element_pkg.get_quota_id (l_x_plan_element_name, p_org_id);
4907:
4908: /* Following code is for message generation */
4909: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'M', 'M')
4910: THEN
4911: IF (cn_plan_element_cuhk.ok_to_generate_msg (p_plan_element_name => l_x_plan_element_name))
4912: THEN
4913: -- XMLGEN.clearBindValues;

Line 4974: END cn_plan_element_pub;

4970: END IF;
4971:
4972: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4973: END duplicate_plan_element;
4974: END cn_plan_element_pub;