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_PROC_BATCHES_PKG dependencies on CN_CALC_SUB_BATCHES_PKG

Line 1545: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'COMPLETE');

1541: , 'No salesreps to calculate ...'
1542: );
1543: END IF;
1544:
1545: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'COMPLETE');
1546: END IF;
1547: END;
1548: END IF;
1549: EXCEPTION

Line 1701: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');

1697: );
1698: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.calculation_submission');
1699: cn_message_pkg.rollback_errormsg_commit
1700: ('No resource with complete compensation plan to calculate.');
1701: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
1702: COMMIT;
1703: app_exception.raise_exception;
1704: WHEN OTHERS THEN
1705: x_process_status_code := 'FAIL';

Line 1710: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');

1706: fnd_file.put_line(fnd_file.LOG, 'Error in cn_proc_batches_pkg.calculation_submission.');
1707: fnd_file.put_line(fnd_file.LOG, SQLERRM);
1708: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.calculation_submission:');
1709: cn_message_pkg.rollback_errormsg_commit(SQLERRM);
1710: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
1711: COMMIT;
1712:
1713: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1714: fnd_log.STRING(

Line 3303: l_calc_sub_batch_id := cn_calc_sub_batches_pkg.get_calc_sub_batch_id;

3299:
3300: RAISE ABORT;
3301: END IF;
3302:
3303: l_calc_sub_batch_id := cn_calc_sub_batches_pkg.get_calc_sub_batch_id;
3304: cn_calc_sub_batches_pkg.begin_record
3305: (
3306: p_operation => 'INSERT'
3307: , p_calc_sub_batch_id => l_calc_sub_batch_id

Line 3304: cn_calc_sub_batches_pkg.begin_record

3300: RAISE ABORT;
3301: END IF;
3302:
3303: l_calc_sub_batch_id := cn_calc_sub_batches_pkg.get_calc_sub_batch_id;
3304: cn_calc_sub_batches_pkg.begin_record
3305: (
3306: p_operation => 'INSERT'
3307: , p_calc_sub_batch_id => l_calc_sub_batch_id
3308: , p_name => p_batch_name

Line 3976: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'COMPLETE');

3972: WHERE NOT EXISTS(SELECT 1
3973: FROM cn_process_batches_all
3974: WHERE logical_batch_id = p_logical_batch_id AND status_code = 'ERROR');
3975:
3976: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'COMPLETE');
3977: fnd_message.set_name('CN', 'ALL_PROCESS_DONE_OK');
3978:
3979: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level) THEN
3980: fnd_log.MESSAGE(fnd_log.level_event, 'cn.plsql.cn_proc_batches_pkg.processor.event'

Line 3987: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');

3983: EXCEPTION
3984: WHEN NO_DATA_FOUND THEN
3985: retcode := 2;
3986: errbuf := 'Completed with error. Please see the log file for details.';
3987: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
3988: fnd_message.set_name('CN', 'ALL_PROCESS_DONE_FAIL');
3989:
3990: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3991: fnd_log.MESSAGE(fnd_log.level_error

Line 4010: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');

4006: fnd_file.put_line(fnd_file.LOG, 'Unexpected exception in cn_proc_batches_pkg.processor');
4007: fnd_file.put_line(fnd_file.LOG, SQLERRM);
4008: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.processor:');
4009: cn_message_pkg.rollback_errormsg_commit(errbuf);
4010: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
4011: cn_message_pkg.end_batch(l_paid);
4012:
4013: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4014: fnd_log.STRING(fnd_log.level_unexpected

Line 4074: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'PROCESSING');

4070: , 'Beginning of cn_proc_batches_pkg.main...'
4071: );
4072: END IF;
4073:
4074: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'PROCESSING');
4075: COMMIT;
4076:
4077: -- The process audit_id is passed in when called from the trx form.
4078: IF x_process_audit_id IS NULL THEN

Line 4150: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'COMPLETE');

4146: WHERE NOT EXISTS(SELECT 1
4147: FROM cn_process_batches_all
4148: WHERE logical_batch_id = p_logical_batch_id AND status_code = 'ERROR');
4149:
4150: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'COMPLETE');
4151: x_process_status_code := 'SUCCESS';
4152: --cn_message_pkg.set_name('CN','ALL_PROCESS_DONE_OK');
4153: cn_message_pkg.end_batch(x_process_audit_id);
4154: EXCEPTION

Line 4156: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');

4152: --cn_message_pkg.set_name('CN','ALL_PROCESS_DONE_OK');
4153: cn_message_pkg.end_batch(x_process_audit_id);
4154: EXCEPTION
4155: WHEN NO_DATA_FOUND THEN
4156: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
4157: x_process_status_code := 'FAIL';
4158: --cn_message_pkg.set_name('CN','ALL_PROCESS_DONE_FAIL');
4159: cn_message_pkg.end_batch(x_process_audit_id);
4160: END;

Line 4233: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');

4229: END IF;
4230: EXCEPTION
4231: WHEN ABORT THEN
4232: cn_message_pkg.rollback_errormsg_commit('Exception occurs in cn_proc_batches_pkg.main.');
4233: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
4234: COMMIT;
4235: x_process_status_code := 'FAIL';
4236: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
4237: cn_message_pkg.end_batch(x_process_audit_id);

Line 4243: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');

4239: fnd_file.put_line(fnd_file.LOG, 'unexpected exception in cn_proc_batches_pkg.main');
4240: fnd_file.put_line(fnd_file.LOG, SQLERRM);
4241: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.main: ');
4242: cn_message_pkg.rollback_errormsg_commit(SQLERRM);
4243: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
4244: COMMIT;
4245: x_process_status_code := 'FAIL';
4246: --cn_message_pkg.set_name('CN','ALL_PROCESS_DONE_FAIL');
4247: cn_message_pkg.end_batch(x_process_audit_id);