DBA Data[Home] [Help]

APPS.CN_ROLLUP_PVT dependencies on CN_ROLLUP_PVT

Line 1: PACKAGE BODY cn_rollup_pvt AS

1: PACKAGE BODY cn_rollup_pvt AS
2: --$Header: cnvrollb.pls 120.4 2010/08/04 22:08:38 rnagired ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='cn_rollup_pvt';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='cn_rollup_pvt';

1: PACKAGE BODY cn_rollup_pvt AS
2: --$Header: cnvrollb.pls 120.4 2010/08/04 22:08:38 rnagired ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='cn_rollup_pvt';
5:
6: -- API name : get_active_role
7: -- Type : Private.
8: -- Pre-reqs : None

Line 115: 'cn.plsql.cn_rollup_pvt.get_active_role.exception',

111: p_data => x_msg_data );
112:
113: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
114: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
115: 'cn.plsql.cn_rollup_pvt.get_active_role.exception',
116: sqlerrm);
117: end if;
118:
119: END get_active_role;

Line 233: 'cn.plsql.cn_rollup_pvt.get_active_group_member.exception',

229: p_data => x_msg_data );
230:
231: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
232: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
233: 'cn.plsql.cn_rollup_pvt.get_active_group_member.exception',
234: sqlerrm);
235: end if;
236: END get_active_group_member;
237:

Line 274: l_group_member cn_rollup_pvt.group_mem_tbl_type;

270: l_api_version CONSTANT NUMBER := 1.0;
271:
272: l_counter NUMBER(15);
273:
274: l_group_member cn_rollup_pvt.group_mem_tbl_type;
275: BEGIN
276: -- Standard call to check for call compatibility.
277: IF NOT FND_API.Compatible_API_Call
278: (l_api_version ,

Line 352: 'cn.plsql.cn_rollup_pvt.get_active_group_member.exception',

348: p_data => x_msg_data );
349:
350: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
351: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
352: 'cn.plsql.cn_rollup_pvt.get_active_group_member.exception',
353: sqlerrm);
354: end if;
355: END get_active_group_member;
356:

Line 470: 'cn.plsql.cn_rollup_pvt.get_active_group.exception',

466: p_data => x_msg_data );
467:
468: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
469: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
470: 'cn.plsql.cn_rollup_pvt.get_active_group.exception',
471: sqlerrm);
472: end if;
473:
474: END get_active_group;

Line 584: 'cn.plsql.cn_rollup_pvt.get_ancestor_group.exception',

580: p_data => x_msg_data );
581:
582: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
583: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
584: 'cn.plsql.cn_rollup_pvt.get_ancestor_group.exception',
585: sqlerrm);
586: end if;
587:
588: END get_ancestor_group;

Line 697: 'cn.plsql.cn_rollup_pvt.get_descendant_group.exception',

693: p_data => x_msg_data );
694:
695: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
696: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
697: 'cn.plsql.cn_rollup_pvt.get_descendant_group.exception',
698: sqlerrm);
699: end if;
700:
701: END get_descendant_group;

Line 902: 'cn.plsql.cn_rollup_pvt.get_ancestor_salesrep.exception',

898: p_data => x_msg_data );
899:
900: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
901: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
902: 'cn.plsql.cn_rollup_pvt.get_ancestor_salesrep.exception',
903: sqlerrm);
904: end if;
905:
906: END get_ancestor_salesrep;

Line 1071: 'cn.plsql.cn_rollup_pvt.get_descendant_salesrep.exception',

1067: p_data => x_msg_data );
1068:
1069: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1070: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1071: 'cn.plsql.cn_rollup_pvt.get_descendant_salesrep.exception',
1072: sqlerrm);
1073: end if;
1074:
1075: END get_descendant_salesrep;

Line 1222: 'cn.plsql.cn_rollup_pvt.get_descendant_salesrep.exception',

1218: p_data => x_msg_data );
1219:
1220: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1221: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1222: 'cn.plsql.cn_rollup_pvt.get_descendant_salesrep.exception',
1223: sqlerrm);
1224: end if;
1225:
1226: END get_descendant_salesrep;

Line 1228: END cn_rollup_pvt;

1224: end if;
1225:
1226: END get_descendant_salesrep;
1227:
1228: END cn_rollup_pvt;