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:
261: cn_message_pkg.DEBUG( 'Exception occurs in creating commission lines: ' );
262: cn_message_pkg.DEBUG( SQLERRM );
263: fnd_file.put_line( fnd_file.LOG, SQLERRM );
264: RAISE;
265: END create_comm_line;
258: , 'Failed to create commission line: ' || p_commission_header_id );
259: END IF;
260:
261: cn_message_pkg.DEBUG( 'Exception occurs in creating commission lines: ' );
262: cn_message_pkg.DEBUG( SQLERRM );
263: fnd_file.put_line( fnd_file.LOG, SQLERRM );
264: RAISE;
265: END create_comm_line;
266:
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 );
324: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.xroll: ' || SQLERRM );
325: RAISE;
326: END xroll;
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 );
324: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.xroll: ' || SQLERRM );
325: RAISE;
326: END xroll;
327:
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 );
448: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.source_cls: ' || SQLERRM );
449: RAISE;
450: END source_cls;
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 );
448: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.source_cls: ' || SQLERRM );
449: RAISE;
450: END source_cls;
451:
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 );
622: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.pull: ' || SQLERRM );
623: RAISE;
624: END pull;
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 );
622: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.pull: ' || SQLERRM );
623: RAISE;
624: END pull;
625:
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 );
829: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.roll_pull: ' || SQLERRM );
830: RAISE;
831: END roll_pull;
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 );
829: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.roll_pull: ' || SQLERRM );
830: RAISE;
831: END roll_pull;
832:
1216: , 'cn.plsql.cn_calc_rollup_pvt.rollup_new_trx.exception'
1217: , SQLERRM );
1218: END IF;
1219:
1220: cn_message_pkg.DEBUG( 'Exception occurs in creating commission lines for managers:' );
1221: cn_message_pkg.DEBUG( SQLERRM );
1222: fnd_file.put_line( fnd_file.LOG, 'In rollup_new_trx creating transaction for managers: ' || SQLERRM );
1223: RAISE;
1224: END;
1217: , SQLERRM );
1218: END IF;
1219:
1220: cn_message_pkg.DEBUG( 'Exception occurs in creating commission lines for managers:' );
1221: cn_message_pkg.DEBUG( SQLERRM );
1222: fnd_file.put_line( fnd_file.LOG, 'In rollup_new_trx creating transaction for managers: ' || SQLERRM );
1223: RAISE;
1224: END;
1225:
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 );
1256: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.rollup_new_trx: ' || SQLERRM );
1257: RAISE;
1258: END rollup_new_trx;
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 );
1256: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.rollup_new_trx: ' || SQLERRM );
1257: RAISE;
1258: END rollup_new_trx;
1259:
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 );
1310: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.revalidation: ' || SQLERRM );
1311: RAISE;
1312: END revalidation;
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 );
1310: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.revalidation: ' || SQLERRM );
1311: RAISE;
1312: END revalidation;
1313:
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:
1448: cn_message_pkg.DEBUG('Processing the Notification Log#' || event.notify_log_id || ' : Action = ' || event.action);
1449:
1450: IF event.action = 'SOURCE_CLS' THEN
1451: source_cls( p_salesrep_id => event.salesrep_id
1452: , p_comp_group_id => event.comp_group_id
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.' );
1480: END IF;
1481: END IF;
1482:
1483: COMMIT;