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_ROLE_PLANS_PUB dependencies on CN_ROLE_PLANS_PUB

Line 1: PACKAGE BODY cn_role_plans_pub AS

1: PACKAGE BODY cn_role_plans_pub AS
2: /* $Header: cnprlplb.pls 120.11 2007/07/26 01:10:20 appldev ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_ROLE_PLANS_PUB';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnprlplb.pls';
5: g_last_update_date DATE := SYSDATE;

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

1: PACKAGE BODY cn_role_plans_pub AS
2: /* $Header: cnprlplb.pls 120.11 2007/07/26 01:10:20 appldev ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_ROLE_PLANS_PUB';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnprlplb.pls';
5: g_last_update_date DATE := SYSDATE;
6: g_last_updated_by NUMBER := fnd_global.user_id;
7: g_creation_date DATE := SYSDATE;

Line 1303: 'cn.plsql.cn_role_plans_pub.create_role_plan.org_validate',

1299: status => l_status);
1300:
1301: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1302: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1303: 'cn.plsql.cn_role_plans_pub.create_role_plan.org_validate',
1304: 'Validated org_id = ' || l_org_id || ' status = '||l_status);
1305: end if;
1306: -- END OF MOAC ORG_ID VALIDATION
1307:

Line 1323: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1319:
1320: -- User hooks
1321:
1322: -- Customer pre-processing section
1323: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1324: 'CREATE_ROLE_PLAN',
1325: 'B',
1326: 'C'
1327: )

Line 1329: cn_role_plans_pub_cuhk.create_role_plan_pre

1325: 'B',
1326: 'C'
1327: )
1328: THEN
1329: cn_role_plans_pub_cuhk.create_role_plan_pre
1330: (p_api_version => p_api_version,
1331: p_init_msg_list => p_init_msg_list,
1332: p_commit => p_commit,
1333: p_validation_level => p_validation_level,

Line 1351: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1347: END IF;
1348: END IF;
1349:
1350: -- Vertical industry pre-processing section
1351: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1352: 'CREATE_ROLE_PLAN',
1353: 'B',
1354: 'V'
1355: )

Line 1357: cn_role_plans_pub_vuhk.create_role_plan_pre

1353: 'B',
1354: 'V'
1355: )
1356: THEN
1357: cn_role_plans_pub_vuhk.create_role_plan_pre
1358: (p_api_version => p_api_version,
1359: p_init_msg_list => p_init_msg_list,
1360: p_commit => p_commit,
1361: p_validation_level => p_validation_level,

Line 1485: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1481:
1482: -- User hooks
1483:
1484: -- Customer post-processing section
1485: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1486: 'CREATE_ROLE_PLAN',
1487: 'A',
1488: 'V'
1489: )

Line 1491: cn_role_plans_pub_cuhk.create_role_plan_post

1487: 'A',
1488: 'V'
1489: )
1490: THEN
1491: cn_role_plans_pub_cuhk.create_role_plan_post
1492: (p_api_version => p_api_version,
1493: p_init_msg_list => p_init_msg_list,
1494: p_commit => p_commit,
1495: p_validation_level => p_validation_level,

Line 1513: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1509: END IF;
1510: END IF;
1511:
1512: -- Vertical industry post-processing section
1513: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1514: 'CREATE_ROLE_PLAN',
1515: 'A',
1516: 'C'
1517: )

Line 1519: cn_role_plans_pub_vuhk.create_role_plan_post

1515: 'A',
1516: 'C'
1517: )
1518: THEN
1519: cn_role_plans_pub_vuhk.create_role_plan_post
1520: (p_api_version => p_api_version,
1521: p_init_msg_list => p_init_msg_list,
1522: p_commit => p_commit,
1523: p_validation_level => p_validation_level,

Line 1541: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1537: END IF;
1538: END IF;
1539:
1540: -- Message enable hook
1541: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1542: 'CREATE_ROLE_PLAN',
1543: 'M',
1544: 'M'
1545: )

Line 1547: IF cn_role_plans_pub_cuhk.ok_to_generate_msg

1543: 'M',
1544: 'M'
1545: )
1546: THEN
1547: IF cn_role_plans_pub_cuhk.ok_to_generate_msg
1548: (p_role_plan_rec => l_rec)
1549: THEN
1550: -- Clear bind variables
1551: -- XMLGEN.clearBindValues;

Line 1756: 'cn.plsql.cn_role_plans_pub.update_role_plan.org_validate',

1752: status => l_status);
1753:
1754: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1755: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1756: 'cn.plsql.cn_role_plans_pub.update_role_plan.org_validate',
1757: 'Validated org_id = ' || l_org_id || ' status = '||l_status);
1758: end if;
1759:
1760: if (nvl(p_role_plan_rec_new.org_id, l_org_id)

Line 1765: 'cn.plsql.cn_role_plans_pub.update_role_plan.error',

1761: <> nvl(l_rec_old.org_id, l_org_id)) then
1762: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1763: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1764: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1765: 'cn.plsql.cn_role_plans_pub.update_role_plan.error',
1766: true);
1767: end if;
1768:
1769: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1793: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1789:
1790: -- User hooks
1791:
1792: -- Customer pre-processing section
1793: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1794: 'UPDATE_ROLE_PLAN',
1795: 'B',
1796: 'C'
1797: )

Line 1799: cn_role_plans_pub_cuhk.update_role_plan_pre

1795: 'B',
1796: 'C'
1797: )
1798: THEN
1799: cn_role_plans_pub_cuhk.update_role_plan_pre
1800: (p_api_version => p_api_version,
1801: p_init_msg_list => p_init_msg_list,
1802: p_commit => p_commit,
1803: p_validation_level => p_validation_level,

Line 1822: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1818: END IF;
1819: END IF;
1820:
1821: -- Vertical industry pre-processing section
1822: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1823: 'UPDATE_ROLE_PLAN',
1824: 'B',
1825: 'V'
1826: )

Line 1828: cn_role_plans_pub_vuhk.update_role_plan_pre

1824: 'B',
1825: 'V'
1826: )
1827: THEN
1828: cn_role_plans_pub_vuhk.update_role_plan_pre
1829: (p_api_version => p_api_version,
1830: p_init_msg_list => p_init_msg_list,
1831: p_commit => p_commit,
1832: p_validation_level => p_validation_level,

Line 2177: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2173:
2174: -- User hooks
2175:
2176: -- Customer post-processing section
2177: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2178: 'UPDATE_ROLE_PLAN',
2179: 'A',
2180: 'V'
2181: )

Line 2183: cn_role_plans_pub_cuhk.update_role_plan_post

2179: 'A',
2180: 'V'
2181: )
2182: THEN
2183: cn_role_plans_pub_cuhk.update_role_plan_post
2184: (p_api_version => p_api_version,
2185: p_init_msg_list => p_init_msg_list,
2186: p_commit => p_commit,
2187: p_validation_level => p_validation_level,

Line 2206: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2202: END IF;
2203: END IF;
2204:
2205: -- Vertical industry post-processing section
2206: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2207: 'UPDATE_ROLE_PLAN',
2208: 'A',
2209: 'C'
2210: )

Line 2212: cn_role_plans_pub_vuhk.update_role_plan_post

2208: 'A',
2209: 'C'
2210: )
2211: THEN
2212: cn_role_plans_pub_vuhk.update_role_plan_post
2213: (p_api_version => p_api_version,
2214: p_init_msg_list => p_init_msg_list,
2215: p_commit => p_commit,
2216: p_validation_level => p_validation_level,

Line 2235: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2231: END IF;
2232: END IF;
2233:
2234: -- Message enable hook
2235: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2236: 'UPDATE_ROLE_PLAN',
2237: 'M',
2238: 'M'
2239: )

Line 2241: IF cn_role_plans_pub_cuhk.ok_to_generate_msg

2237: 'M',
2238: 'M'
2239: )
2240: THEN
2241: IF cn_role_plans_pub_cuhk.ok_to_generate_msg
2242: (p_role_plan_rec => l_rec_new)
2243: THEN
2244: -- Clear bind variables
2245: -- XMLGEN.clearBindValues;

Line 2387: 'cn.plsql.cn_role_plans_pub.delete_role_plan.org_validate',

2383: status => l_status);
2384:
2385: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2386: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2387: 'cn.plsql.cn_role_plans_pub.delete_role_plan.org_validate',
2388: 'Validated org_id = ' || l_org_id || ' status = '||l_status);
2389: end if;
2390: -- END OF MOAC ORG_ID VALIDATION
2391:

Line 2408: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2404:
2405: -- User hooks
2406:
2407: -- Customer pre-processing section
2408: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2409: 'DELETE_ROLE_PLAN',
2410: 'B',
2411: 'C'
2412: )

Line 2414: cn_role_plans_pub_cuhk.delete_role_plan_pre

2410: 'B',
2411: 'C'
2412: )
2413: THEN
2414: cn_role_plans_pub_cuhk.delete_role_plan_pre
2415: (p_api_version => p_api_version,
2416: p_init_msg_list => p_init_msg_list,
2417: p_commit => p_commit,
2418: p_validation_level => p_validation_level,

Line 2436: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2432: END IF;
2433: END IF;
2434:
2435: -- Vertical industry pre-processing section
2436: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2437: 'DELETE_ROLE_PLAN',
2438: 'B',
2439: 'V'
2440: )

Line 2442: cn_role_plans_pub_vuhk.delete_role_plan_pre

2438: 'B',
2439: 'V'
2440: )
2441: THEN
2442: cn_role_plans_pub_vuhk.delete_role_plan_pre
2443: (p_api_version => p_api_version,
2444: p_init_msg_list => p_init_msg_list,
2445: p_commit => p_commit,
2446: p_validation_level => p_validation_level,

Line 2565: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2561:
2562: -- User hooks
2563:
2564: -- Customer post-processing section
2565: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2566: 'DELETE_ROLE_PLAN',
2567: 'A',
2568: 'V'
2569: )

Line 2571: cn_role_plans_pub_cuhk.delete_role_plan_post

2567: 'A',
2568: 'V'
2569: )
2570: THEN
2571: cn_role_plans_pub_cuhk.delete_role_plan_post
2572: (p_api_version => p_api_version,
2573: p_init_msg_list => p_init_msg_list,
2574: p_commit => p_commit,
2575: p_validation_level => p_validation_level,

Line 2593: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2589: END IF;
2590: END IF;
2591:
2592: -- Vertical industry post-processing section
2593: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2594: 'DELETE_ROLE_PLAN',
2595: 'A',
2596: 'C'
2597: )

Line 2599: cn_role_plans_pub_vuhk.delete_role_plan_post

2595: 'A',
2596: 'C'
2597: )
2598: THEN
2599: cn_role_plans_pub_vuhk.delete_role_plan_post
2600: (p_api_version => p_api_version,
2601: p_init_msg_list => p_init_msg_list,
2602: p_commit => p_commit,
2603: p_validation_level => p_validation_level,

Line 2621: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2617: END IF;
2618: END IF;
2619:
2620: -- Message enable hook
2621: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2622: 'DELETE_ROLE_PLAN',
2623: 'M',
2624: 'M'
2625: )

Line 2627: IF cn_role_plans_pub_cuhk.ok_to_generate_msg

2623: 'M',
2624: 'M'
2625: )
2626: THEN
2627: IF cn_role_plans_pub_cuhk.ok_to_generate_msg
2628: (p_role_plan_rec => l_rec)
2629: THEN
2630: -- Clear bind variables
2631: -- XMLGEN.clearBindValues;

Line 2713: END cn_role_plans_pub;

2709: p_encoded => fnd_api.g_false
2710: );
2711: END delete_role_plan;
2712:
2713: END cn_role_plans_pub;