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.

[Home] [Help]

APPS.CN_PROC_BATCHES_PKG dependencies on FND_MESSAGE

Line 1246: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_CALCULATE');

1242: END LOOP;
1243: END IF;
1244:
1245: IF l_counter = 0 THEN /* no one to be calculated */
1246: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_CALCULATE');
1247:
1248: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1249: fnd_log.MESSAGE(
1250: fnd_log.level_exception

Line 1342: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_CALCULATE');

1338: END LOOP;
1339: END IF;
1340:
1341: IF l_counter = 0 THEN /* no one to be calculated */
1342: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_CALCULATE');
1343:
1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1345: fnd_log.MESSAGE(
1346: fnd_log.level_exception

Line 1532: --fnd_message.set_name('CN', 'CNSBCS_NO_ONE_IN_NOTIFY_LOG');

1528: );
1529: END LOOP;
1530:
1531: IF l_counter = 0 THEN /* no one to be calculated */
1532: --fnd_message.set_name('CN', 'CNSBCS_NO_ONE_IN_NOTIFY_LOG');
1533: --raise no_one_with_complete_plan;
1534: -- clku, bug 2783261, we won;t error out if we do not find any reps in
1535: -- notify log, we just set status to complete and return
1536: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

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 2130: cn_message_pkg.DEBUG(fnd_message.get);

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;
2132: ELSE
2133: cn_message_pkg.FLUSH;
2134: COMMIT;

Line 3230: fnd_message.set_name('CN', 'CN_CALC_SUB_EXISTS');

3226:
3227: IF l_batch_name_csr%FOUND THEN
3228: CLOSE l_batch_name_csr;
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:

Line 3231: fnd_message.set_token('BATCH_NAME'

3227: IF l_batch_name_csr%FOUND THEN
3228: CLOSE l_batch_name_csr;
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

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 3246: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');

3242: CLOSE l_batch_name_csr;
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);

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 3259: fnd_message.set_name('CN', 'CN_CALC_SUB_OPEN_DATE');

3255: OPEN l_chk_start_date_csr;
3256: FETCH l_chk_start_date_csr INTO l_counter;
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

Line 3260: fnd_message.set_token('DATE', p_start_date);

3256: FETCH l_chk_start_date_csr INTO l_counter;
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);

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 3276: fnd_message.set_name('CN', 'CN_CALC_SUB_OPEN_DATE');

3272: OPEN l_chk_end_date_csr;
3273: FETCH l_chk_end_date_csr INTO l_counter;
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

Line 3277: fnd_message.set_token('DATE', p_end_date);

3273: FETCH l_chk_end_date_csr INTO l_counter;
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'

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 3292: fnd_message.set_name('CN', 'CN_CALC_NO_SALESREP');

3288: CLOSE l_chk_end_date_csr;
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);

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 3371: errbuf := SUBSTR(fnd_message.get, 1, 254);

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;
3374: errbuf := 'Please check request log file for further information. ';
3375:

Line 3697: errbuf := SUBSTR(fnd_message.get, 1, 254);

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);
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

Line 3850: fnd_message.set_name('CN', 'PROC_CLS_PKG_MISSING');

3846: END IF;
3847: END LOOP;
3848:
3849: IF l_error_ctr = 1 THEN
3850: fnd_message.set_name('CN', 'PROC_CLS_PKG_MISSING');
3851:
3852: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3853: fnd_log.MESSAGE(
3854: fnd_log.level_error

Line 3976: fnd_message.set_name('CN', 'ALL_PROCESS_DONE_OK');

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'
3980: , TRUE);

Line 3987: fnd_message.set_name('CN', 'ALL_PROCESS_DONE_FAIL');

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
3991: , 'cn.plsql.cn_proc_batches_pkg.processor.exception', TRUE);

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 4189: cn_message_pkg.DEBUG(fnd_message.get);

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';
4191:
4192: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4193: fnd_log.STRING(

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 4864: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_BONUS');

4860: END IF;
4861: END IF;
4862:
4863: IF l_counter = 0 THEN /* no one to be calculated */
4864: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_BONUS');
4865:
4866: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4867: fnd_log.MESSAGE(
4868: fnd_log.level_exception