APPS.CN_CALC_POPULATE_PVT dependencies on CN_CALC_POPULATE_PVT

Line 1: PACKAGE BODY cn_calc_populate_pvt AS

1: PACKAGE BODY cn_calc_populate_pvt AS
2: -- $Header: cnvcpopb.pls 120.13 2011/03/10 06:03:31 rnagired ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_POPULATE_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvcpopb.pls';

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

1: PACKAGE BODY cn_calc_populate_pvt AS
2: -- $Header: cnvcpopb.pls 120.13 2011/03/10 06:03:31 rnagired ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_POPULATE_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvcpopb.pls';
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;

Line 126: 'cn.plsql.cn_calc_populate_pvt.populate_lines.exception',

122: END IF;
123: EXCEPTION WHEN OTHERS THEN
124: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
125: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
126: 'cn.plsql.cn_calc_populate_pvt.populate_lines.exception',
127: sqlerrm);
128: end if;
129:
130: fnd_file.put_line(fnd_file.Log, 'In cn_calc_populate_pvt.populate_lines: '||sqlerrm);

Line 130: fnd_file.put_line(fnd_file.Log, 'In cn_calc_populate_pvt.populate_lines: '||sqlerrm);

126: 'cn.plsql.cn_calc_populate_pvt.populate_lines.exception',
127: sqlerrm);
128: end if;
129:
130: fnd_file.put_line(fnd_file.Log, 'In cn_calc_populate_pvt.populate_lines: '||sqlerrm);
131: cn_message_pkg.debug('Exception occurs in creating commission lines in the population phase:');
132: cn_message_pkg.debug('sqlerrm');
133: RAISE;
134: END populate_lines;

Line 463: 'cn.plsql.cn_calc_populate_pvt.populate_batch.progress',

459: and rownum = 1;
460:
461: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
463: 'cn.plsql.cn_calc_populate_pvt.populate_batch.progress',
464: 'Performing team rollup.');
465: end if;
466:
467: -- get credits from team members

Line 542: 'cn.plsql.cn_calc_populate_pvt.populate_batch.progress',

538: CLOSE rev_class_hierarchy_id;
539:
540: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
541: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
542: 'cn.plsql.cn_calc_populate_pvt.populate_batch.progress',
543: 'Populating transactions.');
544: end if;
545:
546: for rep in salesreps loop

Line 983: 'cn.plsql.cn_calc_populate_pvt.populate_batch.progress',

979:
980: --handle those trxs skipping POP phase. BUT only SOURCE trxs can skip POP phase.
981: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
982: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
983: 'cn.plsql.cn_calc_populate_pvt.populate_batch.progress',
984: 'Processing transactions that skip POP phase.');
985: end if;
986:
987: l_processed_date_prev := To_date('01/01/1900', 'DD/MM/YYYY');

Line 1082: 'cn.plsql.cn_calc_populate_pvt.populate_batch.progress',

1078: commit;
1079:
1080: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1081: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1082: 'cn.plsql.cn_calc_populate_pvt.populate_batch.progress',
1083: 'Updating unpopulated transactions to XPOP.');
1084: end if;
1085:
1086: UPDATE cn_commission_lines_all cl

Line 1145: 'cn.plsql.cn_calc_populate_pvt.populate_batch.exception',

1141: );
1142:
1143: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1144: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1145: 'cn.plsql.cn_calc_populate_pvt.populate_batch.exception',
1146: sqlerrm);
1147: end if;
1148: fnd_file.put_line(fnd_file.log, 'In populate_batch: '||sqlerrm);
1149: cn_message_pkg.debug('Exception occurs in cn_calc_populate_pvt.populate_batch:');

Line 1149: cn_message_pkg.debug('Exception occurs in cn_calc_populate_pvt.populate_batch:');

1145: 'cn.plsql.cn_calc_populate_pvt.populate_batch.exception',
1146: sqlerrm);
1147: end if;
1148: fnd_file.put_line(fnd_file.log, 'In populate_batch: '||sqlerrm);
1149: cn_message_pkg.debug('Exception occurs in cn_calc_populate_pvt.populate_batch:');
1150: cn_message_pkg.debug(sqlerrm);
1151: END populate_batch;
1152:
1153: END cn_calc_populate_pvt;

Line 1153: END cn_calc_populate_pvt;

1149: cn_message_pkg.debug('Exception occurs in cn_calc_populate_pvt.populate_batch:');
1150: cn_message_pkg.debug(sqlerrm);
1151: END populate_batch;
1152:
1153: END cn_calc_populate_pvt;