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.3 2005/09/12 10:58:57 ymao 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.3 2005/09/12 10:58:57 ymao 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 865: 'cn.plsql.cn_rollup_pvt.get_ancestor_salesrep.exception',

861: p_data => x_msg_data );
862:
863: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
864: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
865: 'cn.plsql.cn_rollup_pvt.get_ancestor_salesrep.exception',
866: sqlerrm);
867: end if;
868:
869: END get_ancestor_salesrep;

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

1030: p_data => x_msg_data );
1031:
1032: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1033: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1034: 'cn.plsql.cn_rollup_pvt.get_descendant_salesrep.exception',
1035: sqlerrm);
1036: end if;
1037:
1038: END get_descendant_salesrep;

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

1181: p_data => x_msg_data );
1182:
1183: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1184: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1185: 'cn.plsql.cn_rollup_pvt.get_descendant_salesrep.exception',
1186: sqlerrm);
1187: end if;
1188:
1189: END get_descendant_salesrep;

Line 1191: END cn_rollup_pvt;

1187: end if;
1188:
1189: END get_descendant_salesrep;
1190:
1191: END cn_rollup_pvt;