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 3302: l_calc_sub_batch_id := cn_calc_sub_batches_pkg.get_calc_sub_batch_id;

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

Line 3303: cn_calc_sub_batches_pkg.begin_record

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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