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 CN_CALC_ROLLUP_PVT

Line 1: PACKAGE BODY cn_calc_rollup_pvt AS

1: PACKAGE BODY cn_calc_rollup_pvt AS
2: -- $Header: cnvcrolb.pls 120.9.12010000.3 2008/09/22 13:41:19 rajukum ship $
3: g_pkg_name CONSTANT VARCHAR2( 30 ) := 'CN_CALC_ROLLUP_PVT';
4: g_file_name CONSTANT VARCHAR2( 12 ) := 'cnvcrolb.pls';
5: g_last_update_date DATE := SYSDATE;

Line 3: g_pkg_name CONSTANT VARCHAR2( 30 ) := 'CN_CALC_ROLLUP_PVT';

1: PACKAGE BODY cn_calc_rollup_pvt AS
2: -- $Header: cnvcrolb.pls 120.9.12010000.3 2008/09/22 13:41:19 rajukum ship $
3: g_pkg_name CONSTANT VARCHAR2( 30 ) := 'CN_CALC_ROLLUP_PVT';
4: g_file_name CONSTANT VARCHAR2( 12 ) := 'cnvcrolb.pls';
5: g_last_update_date DATE := SYSDATE;
6: g_last_updated_by NUMBER := fnd_global.user_id;
7: g_creation_date DATE := SYSDATE;

Line 98: , 'cn.plsql.cn_calc_rollup_pvt.aggregate_trx.begin'

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:
102: OPEN intel_calc_flag;

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 257: , 'cn.plsql.cn_calc_rollup_pvt.create_comm_line.exception'

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:
261: cn_message_pkg.DEBUG( 'Exception occurs in creating commission lines: ' );

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 322: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.xroll:' );

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;

Line 324: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.xroll: ' || 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:
328: PROCEDURE source_cls( p_salesrep_id NUMBER, p_comp_group_id NUMBER, p_start_date DATE, p_end_date DATE ) IS

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 446: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.source_cls:' );

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;

Line 448: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.source_cls: ' || 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:
452: PROCEDURE pull( p_salesrep_id NUMBER, p_comp_group_id NUMBER, p_start_date DATE, p_end_date DATE, p_action VARCHAR2 ) IS

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 620: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.pull:' );

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;

Line 622: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.pull: ' || 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:
626: PROCEDURE 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 827: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.roll_pull:' );

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;

Line 829: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.roll_pull: ' || 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:
833: PROCEDURE rollup_new_trx( p_salesrep_id NUMBER, p_start_date DATE, p_end_date DATE ) IS

Line 1216: , 'cn.plsql.cn_calc_rollup_pvt.rollup_new_trx.exception'

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:
1220: cn_message_pkg.DEBUG( 'Exception occurs in creating commission lines for managers:' );

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 1254: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.rollup_new_trx:' );

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;

Line 1256: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.rollup_new_trx: ' || 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:
1260: PROCEDURE revalidation( p_physical_batch_id NUMBER ) IS

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 1308: cn_message_pkg.DEBUG( 'Exception occurs in cn_calc_rollup_pvt.revaliation: ' );

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;

Line 1310: fnd_file.put_line( fnd_file.LOG, 'In cn_calc_rollup_pvt.revalidation: ' || 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:
1314: --+=========================================================================+

Line 1444: , 'cn.plsql.cn_calc_rollup_pvt.rollup_batch.notify_log'

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:
1448: cn_message_pkg.DEBUG('Processing the Notification Log#' || event.notify_log_id || ' : Action = ' || event.action);

Line 1493: , 'cn.plsql.cn_calc_rollup_pvt.rollup_batch.exception'

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:
1497: 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;

Line 1551: END cn_calc_rollup_pvt;

1547: END IF;
1548:
1549: fnd_file.put_line( fnd_file.LOG, SQLERRM );
1550: END rollup_batch;
1551: END cn_calc_rollup_pvt;