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.14 2010/10/28 13:31:42 rsatyava 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.14 2010/10/28 13:31:42 rsatyava 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 4673: l_plan_element_rec cn_plan_element_pub.plan_element_rec_type;

4669: )
4670: IS
4671: l_api_name CONSTANT VARCHAR2 (30) := 'Duplicate_Plan_Element';
4672: l_api_version CONSTANT NUMBER := 1.0;
4673: l_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
4674: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
4675: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4676: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4677: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;

Line 4674: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;

4670: IS
4671: l_api_name CONSTANT VARCHAR2 (30) := 'Duplicate_Plan_Element';
4672: l_api_version CONSTANT NUMBER := 1.0;
4673: l_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
4674: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
4675: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4676: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4677: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
4678: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;

Line 4675: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;

4671: l_api_name CONSTANT VARCHAR2 (30) := 'Duplicate_Plan_Element';
4672: l_api_version CONSTANT NUMBER := 1.0;
4673: l_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
4674: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
4675: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4676: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4677: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
4678: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
4679: l_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;

Line 4677: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;

4673: l_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
4674: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
4675: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4676: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4677: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
4678: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
4679: l_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
4680: l_length INTEGER := 30 - LENGTHB ('_2');
4681: l_name_too_long VARCHAR2 (1) := 'F';

Line 4678: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;

4674: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
4675: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4676: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4677: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
4678: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
4679: l_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
4680: l_length INTEGER := 30 - LENGTHB ('_2');
4681: l_name_too_long VARCHAR2 (1) := 'F';
4682: l_quota_id NUMBER;

Line 4679: l_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;

4675: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4676: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4677: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
4678: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
4679: l_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
4680: l_length INTEGER := 30 - LENGTHB ('_2');
4681: l_name_too_long VARCHAR2 (1) := 'F';
4682: l_quota_id NUMBER;
4683: l_warning_flag VARCHAR2 (1) := 'F';

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

4716: status => l_status);
4717:
4718: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4719: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4720: 'cn.plsql.cn_plan_element_pub.duplicate_plan_element.org_validate',
4721: 'Validated org_id = ' || l_org_id || ' status = '||l_status);
4722: end if;
4723: -- END OF MOAC ORG_ID VALIDATION
4724:

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

4724:
4725: -- API body
4726: l_p_plan_element_name := p_plan_element_name;
4727:
4728: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'B', 'C')
4729: THEN
4730: cn_plan_element_cuhk.duplicate_plan_element_pre (p_api_version => p_api_version,
4731: p_init_msg_list => p_init_msg_list,
4732: p_commit => fnd_api.g_false,

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

4747: RAISE fnd_api.g_exc_unexpected_error;
4748: END IF;
4749: END IF;
4750:
4751: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'B', 'V')
4752: THEN
4753: cn_plan_element_vuhk.duplicate_plan_element_pre (p_api_version => p_api_version,
4754: p_init_msg_list => p_init_msg_list,
4755: p_commit => fnd_api.g_false,

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

4892: x_return_status := cn_api.g_ret_sts_warning;
4893: END IF;
4894: END IF;
4895:
4896: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'A', 'V')
4897: THEN
4898: cn_plan_element_vuhk.duplicate_plan_element_post (p_api_version => p_api_version,
4899: p_init_msg_list => p_init_msg_list,
4900: p_commit => fnd_api.g_false,

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

4915: RAISE fnd_api.g_exc_unexpected_error;
4916: END IF;
4917: END IF;
4918:
4919: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'A', 'C')
4920: THEN
4921: cn_plan_element_cuhk.duplicate_plan_element_post (p_api_version => p_api_version,
4922: p_init_msg_list => p_init_msg_list,
4923: p_commit => fnd_api.g_false,

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

4942: -- x_plan_element_name := l_x_plan_element_name;
4943: x_plan_element_name := cn_chk_plan_element_pkg.get_quota_id (l_x_plan_element_name, p_org_id);
4944:
4945: /* Following code is for message generation */
4946: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'M', 'M')
4947: THEN
4948: IF (cn_plan_element_cuhk.ok_to_generate_msg (p_plan_element_name => l_x_plan_element_name))
4949: THEN
4950: -- XMLGEN.clearBindValues;

Line 5011: END cn_plan_element_pub;

5007: END IF;
5008:
5009: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
5010: END duplicate_plan_element;
5011: END cn_plan_element_pub;