109: FND_MSG_PUB.Count_And_Get
110: (p_count => x_msg_count ,
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;
110: (p_count => x_msg_count ,
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:
227: FND_MSG_PUB.Count_And_Get
228: (p_count => x_msg_count ,
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;
228: (p_count => x_msg_count ,
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;
346: FND_MSG_PUB.Count_And_Get
347: (p_count => x_msg_count ,
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;
347: (p_count => x_msg_count ,
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;
464: FND_MSG_PUB.Count_And_Get
465: (p_count => x_msg_count ,
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;
465: (p_count => x_msg_count ,
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:
578: FND_MSG_PUB.Count_And_Get
579: (p_count => x_msg_count ,
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;
579: (p_count => x_msg_count ,
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:
691: FND_MSG_PUB.Count_And_Get
692: (p_count => x_msg_count ,
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;
692: (p_count => x_msg_count ,
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:
859: FND_MSG_PUB.Count_And_Get
860: (p_count => x_msg_count ,
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;
860: (p_count => x_msg_count ,
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:
1028: FND_MSG_PUB.Count_And_Get
1029: (p_count => x_msg_count ,
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;
1029: (p_count => x_msg_count ,
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:
1179: FND_MSG_PUB.Count_And_Get
1180: (p_count => x_msg_count ,
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;
1180: (p_count => x_msg_count ,
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: