DBA Data[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 3231: fnd_message.set_name('CN', 'CN_CALC_SUB_EXISTS');

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

Line 3232: fnd_message.set_token('BATCH_NAME'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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