eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_CALC_ROLLUP_PVT dependencies on FND_LOG

Line 96: IF ( fnd_log.level_procedure >= fnd_log.g_current_runtime_level ) THEN

92: , ch.comp_group_id
93: , ch.revenue_class_id
94: , ch.trx_type;
95: BEGIN
96: IF ( fnd_log.level_procedure >= fnd_log.g_current_runtime_level ) THEN
97: fnd_log.STRING( fnd_log.level_procedure
98: , 'cn.plsql.cn_calc_rollup_pvt.aggregate_trx.begin'
99: , 'Beginning of aggregate_trx ...' );
100: END IF;

Line 97: fnd_log.STRING( fnd_log.level_procedure

93: , ch.revenue_class_id
94: , ch.trx_type;
95: BEGIN
96: IF ( fnd_log.level_procedure >= fnd_log.g_current_runtime_level ) THEN
97: fnd_log.STRING( fnd_log.level_procedure
98: , 'cn.plsql.cn_calc_rollup_pvt.aggregate_trx.begin'
99: , 'Beginning of aggregate_trx ...' );
100: END IF;
101:

Line 149: IF ( fnd_log.level_procedure >= fnd_log.g_current_runtime_level ) THEN

145: END IF;
146:
147: COMMIT;
148:
149: IF ( fnd_log.level_procedure >= fnd_log.g_current_runtime_level ) THEN
150: fnd_log.STRING( fnd_log.level_procedure, 'cn.plsql.cn_calc_rollup_pvt.aggregate_trx.end'
151: , 'End of aggregate_trx.' );
152: END IF;
153: END aggregate_trx;

Line 150: fnd_log.STRING( fnd_log.level_procedure, 'cn.plsql.cn_calc_rollup_pvt.aggregate_trx.end'

146:
147: COMMIT;
148:
149: IF ( fnd_log.level_procedure >= fnd_log.g_current_runtime_level ) THEN
150: fnd_log.STRING( fnd_log.level_procedure, 'cn.plsql.cn_calc_rollup_pvt.aggregate_trx.end'
151: , 'End of aggregate_trx.' );
152: END IF;
153: END aggregate_trx;
154:

Line 255: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN

251: END IF;
252: END IF;
253: EXCEPTION
254: WHEN OTHERS THEN
255: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
256: fnd_log.STRING( fnd_log.level_unexpected
257: , 'cn.plsql.cn_calc_rollup_pvt.create_comm_line.exception'
258: , 'Failed to create commission line: ' || p_commission_header_id );
259: END IF;

Line 256: fnd_log.STRING( fnd_log.level_unexpected

252: END IF;
253: EXCEPTION
254: WHEN OTHERS THEN
255: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
256: fnd_log.STRING( fnd_log.level_unexpected
257: , 'cn.plsql.cn_calc_rollup_pvt.create_comm_line.exception'
258: , 'Failed to create commission line: ' || p_commission_header_id );
259: END IF;
260:

Line 318: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN

314: END IF; -- end of echecking l_group_member.count > 0
315: END IF; -- end of checking salesrep_id is not null
316: EXCEPTION
317: WHEN OTHERS THEN
318: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
319: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.xroll.exception', SQLERRM );
320: END IF;
321:
322: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.xroll:' );

Line 319: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.xroll.exception', SQLERRM );

315: END IF; -- end of checking salesrep_id is not null
316: EXCEPTION
317: WHEN OTHERS THEN
318: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
319: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.xroll.exception', SQLERRM );
320: END IF;
321:
322: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.xroll:' );
323: cn_message_pkg.DEBUG( SQLERRM );

Line 442: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN

438: END IF;
439: END LOOP;
440: EXCEPTION
441: WHEN OTHERS THEN
442: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
443: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.source_cls.exception', SQLERRM );
444: END IF;
445:
446: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.source_cls:' );

Line 443: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.source_cls.exception', SQLERRM );

439: END LOOP;
440: EXCEPTION
441: WHEN OTHERS THEN
442: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
443: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.source_cls.exception', SQLERRM );
444: END IF;
445:
446: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.source_cls:' );
447: cn_message_pkg.DEBUG( SQLERRM );

Line 616: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN

612: END IF; -- end check of the number of active groups
613: END IF; -- end of action check
614: EXCEPTION
615: WHEN OTHERS THEN
616: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
617: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.pull.exception', SQLERRM );
618: END IF;
619:
620: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.pull:' );

Line 617: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.pull.exception', SQLERRM );

613: END IF; -- end of action check
614: EXCEPTION
615: WHEN OTHERS THEN
616: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
617: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.pull.exception', SQLERRM );
618: END IF;
619:
620: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.pull:' );
621: cn_message_pkg.DEBUG( SQLERRM );

Line 823: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN

819: END LOOP; -- End of l_ancestor
820: END IF;
821: EXCEPTION
822: WHEN OTHERS THEN
823: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
824: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.roll_pull.exception', SQLERRM );
825: END IF;
826:
827: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.roll_pull:' );

Line 824: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.roll_pull.exception', SQLERRM );

820: END IF;
821: EXCEPTION
822: WHEN OTHERS THEN
823: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
824: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.roll_pull.exception', SQLERRM );
825: END IF;
826:
827: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.roll_pull:' );
828: cn_message_pkg.DEBUG( SQLERRM );

Line 1214: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN

1210: END LOOP; -- End of eachsrp
1211: END IF;
1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1215: fnd_log.STRING( fnd_log.level_unexpected
1216: , 'cn.plsql.cn_calc_rollup_pvt.rollup_new_trx.exception'
1217: , SQLERRM );
1218: END IF;

Line 1215: fnd_log.STRING( fnd_log.level_unexpected

1211: END IF;
1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1215: fnd_log.STRING( fnd_log.level_unexpected
1216: , 'cn.plsql.cn_calc_rollup_pvt.rollup_new_trx.exception'
1217: , SQLERRM );
1218: END IF;
1219:

Line 1250: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN

1246: NULL;
1247: END LOOP; -- End of each trx
1248: EXCEPTION
1249: WHEN OTHERS THEN
1250: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1251: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.rollup_new_trx.exception', SQLERRM );
1252: END IF;
1253:
1254: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.rollup_new_trx:' );

Line 1251: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.rollup_new_trx.exception', SQLERRM );

1247: END LOOP; -- End of each trx
1248: EXCEPTION
1249: WHEN OTHERS THEN
1250: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1251: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.rollup_new_trx.exception', SQLERRM );
1252: END IF;
1253:
1254: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.rollup_new_trx:' );
1255: cn_message_pkg.DEBUG( SQLERRM );

Line 1304: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN

1300: END IF;
1301: END LOOP;
1302: EXCEPTION
1303: WHEN OTHERS THEN
1304: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1305: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.revaliation.exception', SQLERRM );
1306: END IF;
1307:
1308: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.revaliation: ' );

Line 1305: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.revaliation.exception', SQLERRM );

1301: END LOOP;
1302: EXCEPTION
1303: WHEN OTHERS THEN
1304: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1305: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.revaliation.exception', SQLERRM );
1306: END IF;
1307:
1308: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.revaliation: ' );
1309: cn_message_pkg.DEBUG( SQLERRM );

Line 1442: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level ) THEN

1438: IF l_is_incremental = 'Y' THEN
1439: FOR event IN l_notify_cr LOOP
1440: -- Perform the update after completing calculation
1441: -- UPDATE cn_notify_log SET status = 'COMPLETE' WHERE notify_log_id = event.notify_log_id;
1442: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level ) THEN
1443: fnd_log.STRING( fnd_log.level_statement
1444: , 'cn.plsql.cn_calc_rollup_pvt.rollup_batch.notify_log'
1445: , 'Processing notify log record ID=' || event.notify_log_id );
1446: END IF;

Line 1443: fnd_log.STRING( fnd_log.level_statement

1439: FOR event IN l_notify_cr LOOP
1440: -- Perform the update after completing calculation
1441: -- UPDATE cn_notify_log SET status = 'COMPLETE' WHERE notify_log_id = event.notify_log_id;
1442: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level ) THEN
1443: fnd_log.STRING( fnd_log.level_statement
1444: , 'cn.plsql.cn_calc_rollup_pvt.rollup_batch.notify_log'
1445: , 'Processing notify log record ID=' || event.notify_log_id );
1446: END IF;
1447:

Line 1475: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN

1471: , p_action => event.action );
1472: END IF;
1473: END LOOP;
1474: ELSE
1475: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1476: fnd_file.put_line( fnd_file.LOG, 'Full Calc: Skipped the notify log pull calls.' );
1477: END IF;
1478:
1479: cn_message_pkg.DEBUG( 'Full Calc: Skipped the notify log pull calls.' );

Line 1491: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN

1487: BEGIN
1488: cn_aggrt_trx_pkg.aggregate_trx( p_physical_batch_id );
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1492: fnd_log.STRING( fnd_log.level_unexpected
1493: , 'cn.plsql.cn_calc_rollup_pvt.rollup_batch.exception'
1494: , 'Error in Custom Code: ' || SQLERRM );
1495: END IF;

Line 1492: fnd_log.STRING( fnd_log.level_unexpected

1488: cn_aggrt_trx_pkg.aggregate_trx( p_physical_batch_id );
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1492: fnd_log.STRING( fnd_log.level_unexpected
1493: , 'cn.plsql.cn_calc_rollup_pvt.rollup_batch.exception'
1494: , 'Error in Custom Code: ' || SQLERRM );
1495: END IF;
1496:

Line 1545: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN

1541: END IF;
1542:
1543: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1544:
1545: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1546: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.rollup_batch.exception', SQLERRM );
1547: END IF;
1548:
1549: fnd_file.put_line( fnd_file.LOG, SQLERRM );

Line 1546: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.rollup_batch.exception', SQLERRM );

1542:
1543: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1544:
1545: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1546: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.rollup_batch.exception', SQLERRM );
1547: END IF;
1548:
1549: fnd_file.put_line( fnd_file.LOG, SQLERRM );
1550: END rollup_batch;