APPS.CN_CALC_POPULATE_PVT dependencies on FND_LOG

Line 124: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

120: (g_calc_type = 'FORECAST'
121: AND cl.trx_type = 'FORECAST'));
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;

Line 125: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

121: AND cl.trx_type = 'FORECAST'));
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:

Line 461: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

457: from cn_process_batches_all
458: where physical_batch_id = p_physical_batch_id
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;

Line 462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

458: where physical_batch_id = p_physical_batch_id
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:

Line 540: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

536: OPEN rev_class_hierarchy_id;
537: FETCH rev_class_hierarchy_id INTO l_rev_class_hierarchy_id;
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;

Line 541: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

537: FETCH rev_class_hierarchy_id INTO l_rev_class_hierarchy_id;
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:

Line 981: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

977:
978: commit;
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;

Line 982: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

978: commit;
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:

Line 1080: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1076: END LOOP;
1077:
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;

Line 1081: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1077:
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:

Line 1143: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1139: p_data => x_msg_data ,
1140: p_encoded => FND_API.G_FALSE
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;

Line 1144: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1140: p_encoded => FND_API.G_FALSE
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);