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 FND_FILE

Line 403: fnd_file.put_line(fnd_file.LOG, 'Invalid process code: ' || x_physical_process);

399: currst := g_post;
400: newst := g_post;
401: ELSE
402: cn_message_pkg.DEBUG('Invalid process code: ' || x_physical_process);
403: fnd_file.put_line(fnd_file.LOG, 'Invalid process code: ' || x_physical_process);
404: RAISE ABORT;
405: END IF;
406:
407: x_curr_status := currst;

Line 435: fnd_file.put_line(

431: || ' (logical process: '
432: || g_logical_process
433: || ')'
434: );
435: fnd_file.put_line(
436: fnd_file.LOG
437: , 'Invalid process code: '
438: || x_physical_process
439: || ' (logical process: '

Line 436: fnd_file.LOG

432: || g_logical_process
433: || ')'
434: );
435: fnd_file.put_line(
436: fnd_file.LOG
437: , 'Invalid process code: '
438: || x_physical_process
439: || ' (logical process: '
440: || g_logical_process

Line 470: fnd_file.put_line(

466: || ' (logical process: '
467: || g_logical_process
468: || ')'
469: );
470: fnd_file.put_line(
471: fnd_file.LOG
472: , 'Invalid process code: '
473: || x_physical_process
474: || ' (logical process: '

Line 471: fnd_file.LOG

467: || g_logical_process
468: || ')'
469: );
470: fnd_file.put_line(
471: fnd_file.LOG
472: , 'Invalid process code: '
473: || x_physical_process
474: || ' (logical process: '
475: || g_logical_process

Line 495: fnd_file.put_line(

491: || ' (logical process: '
492: || g_logical_process
493: || ')'
494: );
495: fnd_file.put_line(
496: fnd_file.LOG
497: , 'Invalid process code: '
498: || x_physical_process
499: || ' (logical process: '

Line 496: fnd_file.LOG

492: || g_logical_process
493: || ')'
494: );
495: fnd_file.put_line(
496: fnd_file.LOG
497: , 'Invalid process code: '
498: || x_physical_process
499: || ' (logical process: '
500: || g_logical_process

Line 522: fnd_file.put_line(

518: || ' (logical process: '
519: || g_logical_process
520: || ')'
521: );
522: fnd_file.put_line(
523: fnd_file.LOG
524: , 'Invalid process code: '
525: || x_physical_process
526: || ' (logical process: '

Line 523: fnd_file.LOG

519: || g_logical_process
520: || ')'
521: );
522: fnd_file.put_line(
523: fnd_file.LOG
524: , 'Invalid process code: '
525: || x_physical_process
526: || ' (logical process: '
527: || g_logical_process

Line 553: fnd_file.put_line(

549: || ' (logical process: '
550: || g_logical_process
551: || ')'
552: );
553: fnd_file.put_line(
554: fnd_file.LOG
555: , 'Invalid process code: '
556: || x_physical_process
557: || ' (logical process: '

Line 554: fnd_file.LOG

550: || g_logical_process
551: || ')'
552: );
553: fnd_file.put_line(
554: fnd_file.LOG
555: , 'Invalid process code: '
556: || x_physical_process
557: || ' (logical process: '
558: || g_logical_process

Line 774: fnd_file.put_line(fnd_file.LOG

770: EXCEPTION
771: WHEN api_call_failed THEN
772: IF (l_msg_count > 0) THEN
773: FOR l_counter IN 1 .. l_msg_count LOOP
774: fnd_file.put_line(fnd_file.LOG
775: , fnd_msg_pub.get(p_msg_index => l_counter, p_encoded => fnd_api.g_false));
776: END LOOP;
777: END IF;
778:

Line 781: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches_pkg.populate_calcsub_batch: ' || SQLERRM);

777: END IF;
778:
779: cn_message_pkg.FLUSH;
780: WHEN OTHERS THEN
781: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches_pkg.populate_calcsub_batch: ' || SQLERRM);
782: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.populate_calcsub_batch:');
783: cn_message_pkg.rollback_errormsg_commit(SQLERRM);
784:
785: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

Line 1551: fnd_file.put_line

1547: END;
1548: END IF;
1549: EXCEPTION
1550: WHEN no_one_with_complete_plan THEN
1551: fnd_file.put_line
1552: (
1553: fnd_file.LOG
1554: , 'Exception occurs in cn_proc_batches_pkg.populate_process_batch: No one with complete compensation plan to calculate.'
1555: );

Line 1553: fnd_file.LOG

1549: EXCEPTION
1550: WHEN no_one_with_complete_plan THEN
1551: fnd_file.put_line
1552: (
1553: fnd_file.LOG
1554: , 'Exception occurs in cn_proc_batches_pkg.populate_process_batch: No one with complete compensation plan to calculate.'
1555: );
1556: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.populate_process_batch:');
1557: cn_message_pkg.rollback_errormsg_commit

Line 1561: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches_pkg.populate_process_batch:' || SQLERRM);

1557: cn_message_pkg.rollback_errormsg_commit
1558: ('No one with complete compensation plan to calculate.');
1559: RAISE;
1560: WHEN OTHERS THEN
1561: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches_pkg.populate_process_batch:' || SQLERRM);
1562:
1563: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1564: fnd_log.STRING(
1565: fnd_log.level_unexpected

Line 1693: fnd_file.put_line

1689: );
1690: END IF;
1691: EXCEPTION
1692: WHEN no_one_with_complete_plan THEN
1693: fnd_file.put_line
1694: (
1695: fnd_file.LOG
1696: , 'no_one_with_complete_plan EXCEPTION in cn_proc_batches_pkg.calculation_submission'
1697: );

Line 1695: fnd_file.LOG

1691: EXCEPTION
1692: WHEN no_one_with_complete_plan THEN
1693: fnd_file.put_line
1694: (
1695: fnd_file.LOG
1696: , 'no_one_with_complete_plan EXCEPTION in cn_proc_batches_pkg.calculation_submission'
1697: );
1698: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.calculation_submission');
1699: cn_message_pkg.rollback_errormsg_commit

Line 1706: fnd_file.put_line(fnd_file.LOG, 'Error in cn_proc_batches_pkg.calculation_submission.');

1702: COMMIT;
1703: app_exception.raise_exception;
1704: WHEN OTHERS THEN
1705: x_process_status_code := 'FAIL';
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');

Line 1707: fnd_file.put_line(fnd_file.LOG, SQLERRM);

1703: app_exception.raise_exception;
1704: WHEN OTHERS THEN
1705: x_process_status_code := 'FAIL';
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;

Line 1744: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches.get_physical_batch_id: ' || SQLERRM);

1740: , SQLERRM
1741: );
1742: END IF;
1743:
1744: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches.get_physical_batch_id: ' || SQLERRM);
1745: RAISE;
1746: END get_physical_batch_id;
1747:
1748: -- Procedure Name

Line 1968: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

1964: , 'No salesreps to process.'
1965: );
1966: END IF;
1967:
1968: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
1969: RAISE no_comm_lines;
1970: END IF;
1971:
1972: -- get the first physical batch id

Line 2057: fnd_file.put_line(fnd_file.LOG, 'no_comm_lines exception in cn_proc_batches_pkg.assign');

2053: cn_message_pkg.FLUSH;
2054: COMMIT;
2055: EXCEPTION
2056: WHEN no_comm_lines THEN
2057: fnd_file.put_line(fnd_file.LOG, 'no_comm_lines exception in cn_proc_batches_pkg.assign');
2058: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.assign:');
2059: cn_message_pkg.DEBUG('No transactions to process.');
2060: RAISE;
2061: WHEN OTHERS THEN

Line 2067: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches.assign: ' || SQLERRM);

2063: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_proc_batches_pkg.assign.exception'
2064: , SQLERRM);
2065: END IF;
2066:
2067: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches.assign: ' || SQLERRM);
2068: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.assign:');
2069: cn_message_pkg.rollback_errormsg_commit(SQLERRM);
2070: RAISE;
2071: END assign;

Line 2127: fnd_file.put_line(fnd_file.LOG, 'Submission failure for batch' || x_physical_batch_id);

2123: , 'Submission failure for batch: ' || x_physical_batch_id
2124: );
2125: END IF;
2126:
2127: fnd_file.put_line(fnd_file.LOG, 'Submission failure for batch' || x_physical_batch_id);
2128: cn_message_pkg.DEBUG('Failed to submit concurrent request (batch ID=' || x_physical_batch_id
2129: || ')');
2130: cn_message_pkg.DEBUG(fnd_message.get);
2131: -- raise conc_fail;

Line 2348: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request completed with error for ' || l_failed_request_id);

2344: );
2345: END IF;
2346:
2347: cn_message_pkg.DEBUG('Concurrent Request#' || l_failed_request_id || ' for Physical Batch#' || l_temp_phys_batch_id || ' completed with error');
2348: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request completed with error for ' || l_failed_request_id);
2349: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request failed for physical batch' || l_temp_phys_batch_id);
2350: RAISE conc_fail;
2351: END IF;
2352:

Line 2349: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request failed for physical batch' || l_temp_phys_batch_id);

2345: END IF;
2346:
2347: cn_message_pkg.DEBUG('Concurrent Request#' || l_failed_request_id || ' for Physical Batch#' || l_temp_phys_batch_id || ' completed with error');
2348: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request completed with error for ' || l_failed_request_id);
2349: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request failed for physical batch' || l_temp_phys_batch_id);
2350: RAISE conc_fail;
2351: END IF;
2352:
2353: IF l_dev_phase = 'COMPLETE' THEN

Line 2391: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request completed with error for ' || l_failed_request_id);

2387: );
2388: END IF;
2389:
2390: cn_message_pkg.DEBUG('Concurrent Request#' || l_failed_request_id || ' for Physical Batch#' || l_temp_phys_batch_id || ' completed with error');
2391: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request completed with error for ' || l_failed_request_id);
2392: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request failed for physical_batch' || l_temp_phys_batch_id);
2393: RAISE conc_fail;
2394: END IF; -- If error
2395: END IF; -- If complete

Line 2392: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request failed for physical_batch' || l_temp_phys_batch_id);

2388: END IF;
2389:
2390: cn_message_pkg.DEBUG('Concurrent Request#' || l_failed_request_id || ' for Physical Batch#' || l_temp_phys_batch_id || ' completed with error');
2391: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request completed with error for ' || l_failed_request_id);
2392: fnd_file.put_line(fnd_file.LOG, 'Conc_dispatch: Request failed for physical_batch' || l_temp_phys_batch_id);
2393: RAISE conc_fail;
2394: END IF; -- If error
2395: END IF; -- If complete
2396: END IF; -- If request_id is not null

Line 2492: fnd_file.put_line(fnd_file.LOG, 'conc_fail exception in cn_proc_batches_pkg.conc_dispatch');

2488: );
2489: END IF;
2490: EXCEPTION
2491: WHEN conc_fail THEN
2492: fnd_file.put_line(fnd_file.LOG, 'conc_fail exception in cn_proc_batches_pkg.conc_dispatch');
2493: update_error(l_temp_phys_batch_id);
2494:
2495: -- canceling running/pending requests
2496: IF (l_primary_request_stack.COUNT > 0) THEN

Line 2521: fnd_file.put_line(fnd_file.LOG, 'unexpected exception in cn_proc_batches_pkg.conc_dispatch');

2517: fnd_log.STRING(fnd_log.level_unexpected
2518: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.exception', SQLERRM);
2519: END IF;
2520:
2521: fnd_file.put_line(fnd_file.LOG, 'unexpected exception in cn_proc_batches_pkg.conc_dispatch');
2522: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.conc_dispatch:');
2523: cn_message_pkg.rollback_errormsg_commit(SQLERRM);
2524: RAISE;
2525: END conc_dispatch;

Line 2738: fnd_file.put_line(

2734:
2735: cn_message_pkg.DEBUG('Concurrent request completed with error (request ID='
2736: || l_failed_request_id || ')');
2737: cn_message_pkg.DEBUG('(physical batch ID=' || l_temp_phys_batch_id || ')');
2738: fnd_file.put_line(
2739: fnd_file.LOG
2740: , 'Conc_dispatch2: Request completed with error for ' || l_failed_request_id
2741: );
2742: fnd_file.put_line(

Line 2739: fnd_file.LOG

2735: cn_message_pkg.DEBUG('Concurrent request completed with error (request ID='
2736: || l_failed_request_id || ')');
2737: cn_message_pkg.DEBUG('(physical batch ID=' || l_temp_phys_batch_id || ')');
2738: fnd_file.put_line(
2739: fnd_file.LOG
2740: , 'Conc_dispatch2: Request completed with error for ' || l_failed_request_id
2741: );
2742: fnd_file.put_line(
2743: fnd_file.LOG

Line 2742: fnd_file.put_line(

2738: fnd_file.put_line(
2739: fnd_file.LOG
2740: , 'Conc_dispatch2: Request completed with error for ' || l_failed_request_id
2741: );
2742: fnd_file.put_line(
2743: fnd_file.LOG
2744: , 'Conc_dispatch2: Request failed for physical batch' || l_temp_phys_batch_id
2745: );
2746: RAISE conc_fail;

Line 2743: fnd_file.LOG

2739: fnd_file.LOG
2740: , 'Conc_dispatch2: Request completed with error for ' || l_failed_request_id
2741: );
2742: fnd_file.put_line(
2743: fnd_file.LOG
2744: , 'Conc_dispatch2: Request failed for physical batch' || l_temp_phys_batch_id
2745: );
2746: RAISE conc_fail;
2747: END IF;

Line 2789: fnd_file.put_line(

2785:
2786: cn_message_pkg.DEBUG('Concurrent request completed with error (request ID='
2787: || l_failed_request_id || ')');
2788: cn_message_pkg.DEBUG('(physical batch ID=' || l_temp_phys_batch_id || ')');
2789: fnd_file.put_line(
2790: fnd_file.LOG
2791: , 'Conc_dispatch2: Request completed with error for ' || l_failed_request_id
2792: );
2793: fnd_file.put_line(

Line 2790: fnd_file.LOG

2786: cn_message_pkg.DEBUG('Concurrent request completed with error (request ID='
2787: || l_failed_request_id || ')');
2788: cn_message_pkg.DEBUG('(physical batch ID=' || l_temp_phys_batch_id || ')');
2789: fnd_file.put_line(
2790: fnd_file.LOG
2791: , 'Conc_dispatch2: Request completed with error for ' || l_failed_request_id
2792: );
2793: fnd_file.put_line(
2794: fnd_file.LOG

Line 2793: fnd_file.put_line(

2789: fnd_file.put_line(
2790: fnd_file.LOG
2791: , 'Conc_dispatch2: Request completed with error for ' || l_failed_request_id
2792: );
2793: fnd_file.put_line(
2794: fnd_file.LOG
2795: , 'Conc_dispatch2: Request failed for physical_batch' || l_temp_phys_batch_id
2796: );
2797: RAISE conc_fail;

Line 2794: fnd_file.LOG

2790: fnd_file.LOG
2791: , 'Conc_dispatch2: Request completed with error for ' || l_failed_request_id
2792: );
2793: fnd_file.put_line(
2794: fnd_file.LOG
2795: , 'Conc_dispatch2: Request failed for physical_batch' || l_temp_phys_batch_id
2796: );
2797: RAISE conc_fail;
2798: END IF; -- If error

Line 2933: fnd_file.put_line(fnd_file.LOG, 'conc_fail exception in cn_proc_batches_pkg.conc_dispatch');

2929: );
2930: END IF;
2931: EXCEPTION
2932: WHEN conc_fail THEN
2933: fnd_file.put_line(fnd_file.LOG, 'conc_fail exception in cn_proc_batches_pkg.conc_dispatch');
2934: update_error(l_temp_phys_batch_id);
2935:
2936: -- canceling running/pending requests
2937: IF (l_primary_request_stack.COUNT > 0) THEN

Line 2969: fnd_file.put_line(fnd_file.LOG, 'unexpected exception in cn_proc_batches_pkg.conc_dispatch');

2965: , SQLERRM
2966: );
2967: END IF;
2968:
2969: fnd_file.put_line(fnd_file.LOG, 'unexpected exception in cn_proc_batches_pkg.conc_dispatch');
2970: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.conc_dispatch2:');
2971: cn_message_pkg.rollback_errormsg_commit(SQLERRM);
2972: RAISE;
2973: END conc_dispatch2;

Line 3110: fnd_file.put_line(fnd_file.LOG, 'Beginning of calculate_batch...');

3106: , x_process_audit_id => l_process_audit_id
3107: , x_request_id => fnd_global.conc_request_id
3108: , p_org_id => l_org_id
3109: );
3110: fnd_file.put_line(fnd_file.LOG, 'Beginning of calculate_batch...');
3111: cn_message_pkg.DEBUG('Beginning of calculate_batch...');
3112:
3113: UPDATE cn_calc_submission_batches_all
3114: SET process_audit_id = l_process_audit_id,

Line 3132: fnd_file.put_line(fnd_file.LOG, l_msg_data);

3128:
3129: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3130: FOR l_counter IN 1 .. l_msg_count LOOP
3131: l_msg_data := fnd_msg_pub.get(p_msg_index => l_counter, p_encoded => fnd_api.g_false);
3132: fnd_file.put_line(fnd_file.LOG, l_msg_data);
3133: cn_message_pkg.DEBUG(l_msg_data);
3134: END LOOP;
3135:
3136: retcode := 2;

Line 3148: fnd_file.put_line(fnd_file.LOG, 'End of the calculation process.');

3144: , 'End of calculate_batch.'
3145: );
3146: END IF;
3147:
3148: fnd_file.put_line(fnd_file.LOG, 'End of the calculation process.');
3149: cn_message_pkg.DEBUG('End of the calculation process.');
3150: cn_message_pkg.end_batch(l_process_audit_id);
3151: EXCEPTION
3152: WHEN OTHERS THEN

Line 3220: fnd_file.put_line(fnd_file.LOG, 'Beginning of concurrent program calc ... ');

3216: , 'Beginning of concurrent program calc ...'
3217: );
3218: END IF;
3219:
3220: fnd_file.put_line(fnd_file.LOG, 'Beginning of concurrent program calc ... ');
3221: -- Concurrent Manager will call set_policy_context('S', user_selected_org)
3222: l_org_id := mo_global.get_current_org_id;
3223:
3224: -- check uniqueness of batch name

Line 3234: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

3230:
3231: fnd_message.set_name('CN', 'CN_CALC_SUB_EXISTS');
3232: fnd_message.set_token('BATCH_NAME'
3233: , cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));
3234: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3235:
3236: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3237: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3238: END IF;

Line 3248: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

3244:
3245: -- check the validility of p_start_date and p_end_date
3246: IF p_start_date > p_end_date THEN
3247: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
3248: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3249:
3250: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3251: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3252: END IF;

Line 3262: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

3258:
3259: IF l_chk_start_date_csr%NOTFOUND THEN
3260: fnd_message.set_name('CN', 'CN_CALC_SUB_OPEN_DATE');
3261: fnd_message.set_token('DATE', p_start_date);
3262: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3263:
3264: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3265: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3266: END IF;

Line 3279: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

3275:
3276: IF l_chk_end_date_csr%NOTFOUND THEN
3277: fnd_message.set_name('CN', 'CN_CALC_SUB_OPEN_DATE');
3278: fnd_message.set_token('DATE', p_end_date);
3279: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3280:
3281: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3282: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation'
3283: , TRUE);

Line 3294: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

3290: END IF;
3291:
3292: IF p_salesrep_option = 'USER_SPECIFY' AND p_salesrep_id IS NULL THEN
3293: fnd_message.set_name('CN', 'CN_CALC_NO_SALESREP');
3294: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3295:
3296: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3297: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3298: END IF;

Line 3346: fnd_file.put_line(fnd_file.LOG

3342: );
3343: END IF;
3344:
3345: IF find_srp_incomplete_plan(l_calc_sub_batch_id) THEN
3346: fnd_file.put_line(fnd_file.LOG
3347: , 'Abort the process because there is rep with incomplete comp plans.');
3348: RAISE ABORT;
3349: ELSE
3350: calculation_submission(

Line 3370: WHEN fnd_file.utl_file_error THEN

3366: , 'End of concurrent program calc.'
3367: );
3368: END IF;
3369: EXCEPTION
3370: WHEN fnd_file.utl_file_error THEN
3371: retcode := 2;
3372: errbuf := SUBSTR(fnd_message.get, 1, 254);
3373: WHEN ABORT THEN
3374: retcode := 2;

Line 3499: fnd_file.put_line(fnd_file.LOG

3495: || TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI:SS')
3496: );
3497: END IF;
3498:
3499: fnd_file.put_line(fnd_file.LOG
3500: , 'Inside batch runner: ' || TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI:SS'));
3501:
3502: SELECT org_id
3503: INTO l_org_id

Line 3694: fnd_file.put_line(fnd_file.LOG, 'Time is ' || TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI:SS'));

3690: );
3691: END IF;
3692:
3693: cn_message_pkg.DEBUG('Time is ' || TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI:SS'));
3694: fnd_file.put_line(fnd_file.LOG, 'Time is ' || TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI:SS'));
3695: EXCEPTION
3696: WHEN api_call_failed THEN
3697: retcode := 2;
3698: errbuf := SUBSTR(fnd_message.get, 1, 254);

Line 3702: fnd_file.put_line(fnd_file.LOG

3698: errbuf := SUBSTR(fnd_message.get, 1, 254);
3699:
3700: IF (l_msg_count > 0) THEN
3701: FOR l_counter IN 1 .. l_msg_count LOOP
3702: fnd_file.put_line(fnd_file.LOG
3703: , fnd_msg_pub.get(p_msg_index => l_counter, p_encoded => fnd_api.g_false));
3704: END LOOP;
3705: END IF;
3706:

Line 4006: fnd_file.put_line(fnd_file.LOG, 'Unexpected exception in cn_proc_batches_pkg.processor');

4002: EXCEPTION
4003: WHEN OTHERS THEN
4004: retcode := 2;
4005: errbuf := SQLERRM;
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');

Line 4007: fnd_file.put_line(fnd_file.LOG, SQLERRM);

4003: WHEN OTHERS THEN
4004: retcode := 2;
4005: errbuf := SQLERRM;
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);

Line 4099: fnd_file.put_line(fnd_file.LOG, 'classification ruleset is not valid');

4095: IF p_process_name = g_collection THEN
4096: NULL;
4097: ELSIF p_process_name IN(g_classification, g_rollup, g_population, g_calculation) THEN
4098: IF NOT validate_ruleset_status(p_start_date, p_end_date, g_org_id) THEN
4099: fnd_file.put_line(fnd_file.LOG, 'classification ruleset is not valid');
4100: RAISE ABORT;
4101: END IF;
4102: ELSE
4103: fnd_file.put_line(fnd_file.LOG

Line 4103: fnd_file.put_line(fnd_file.LOG

4099: fnd_file.put_line(fnd_file.LOG, 'classification ruleset is not valid');
4100: RAISE ABORT;
4101: END IF;
4102: ELSE
4103: fnd_file.put_line(fnd_file.LOG
4104: , 'cn_proc_batches_pkg.main: bad process name: ' || p_process_name);
4105: cn_message_pkg.DEBUG('Invalid process code (' || p_process_name || ')');
4106: RAISE ABORT;
4107: END IF;

Line 4111: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

4107: END IF;
4108:
4109: IF NVL(cn_global_var.g_system_batch_size, 0) = 0 THEN
4110: cn_message_pkg.set_name('CN', 'PROC_BAD_BATCH_SIZE');
4111: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
4112: RAISE ABORT;
4113: END IF;
4114:
4115: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 4187: fnd_file.put_line(fnd_file.LOG

4183: , argument8 => p_comp_plan_id
4184: );
4185:
4186: IF l_request_id = 0 THEN
4187: fnd_file.put_line(fnd_file.LOG
4188: , 'cn_proc_batches_pkg.main: unable to submit batch_processor');
4189: cn_message_pkg.DEBUG('Failed to submit concurrent request (Batch Processor)');
4190: cn_message_pkg.DEBUG(fnd_message.get);
4191: x_process_status_code := 'FAIL';

Line 4236: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

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);
4238: WHEN OTHERS THEN
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);

Line 4239: fnd_file.put_line(fnd_file.LOG, 'unexpected exception in cn_proc_batches_pkg.main');

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);
4238: WHEN OTHERS THEN
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');

Line 4240: fnd_file.put_line(fnd_file.LOG, SQLERRM);

4236: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
4237: cn_message_pkg.end_batch(x_process_audit_id);
4238: WHEN OTHERS THEN
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;

Line 4892: fnd_file.put_line

4888: cn_message_pkg.rollback_errormsg_commit
4889: (
4890: 'No one with complete compensation plan to calculate or the period specified is not at the end of the plan element interval'
4891: );
4892: fnd_file.put_line
4893: (
4894: fnd_file.LOG
4895: , 'Exception in cn_proc_batches_pkg.populate_bonus_process_batch: no one with complete '
4896: || 'compensation plan or the period specified is not at the end of the interval'

Line 4894: fnd_file.LOG

4890: 'No one with complete compensation plan to calculate or the period specified is not at the end of the plan element interval'
4891: );
4892: fnd_file.put_line
4893: (
4894: fnd_file.LOG
4895: , 'Exception in cn_proc_batches_pkg.populate_bonus_process_batch: no one with complete '
4896: || 'compensation plan or the period specified is not at the end of the interval'
4897: );
4898: RAISE;

Line 4910: fnd_file.put_line(fnd_file.LOG

4906: END IF;
4907:
4908: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.populate_bonus_process_batch: ');
4909: cn_message_pkg.rollback_errormsg_commit(SQLERRM);
4910: fnd_file.put_line(fnd_file.LOG
4911: , 'Exception in cn_proc_batches_pkg.populate_bonus_process_batch: ' || SQLERRM);
4912: RAISE;
4913: END populate_bonus_process_batch;
4914: END cn_proc_batches_pkg;