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 3131: fnd_file.put_line(fnd_file.LOG, l_msg_data);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3345: fnd_file.put_line(fnd_file.LOG

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

Line 3369: WHEN fnd_file.utl_file_error THEN

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

Line 3498: fnd_file.put_line(fnd_file.LOG

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

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

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

Line 3701: fnd_file.put_line(fnd_file.LOG

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

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

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

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

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

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

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

Line 4102: fnd_file.put_line(fnd_file.LOG

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

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

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

Line 4186: fnd_file.put_line(fnd_file.LOG

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

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

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

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

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

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

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

Line 4891: fnd_file.put_line

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

Line 4893: fnd_file.LOG

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

Line 4909: fnd_file.put_line(fnd_file.LOG

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