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_PERIODS_API dependencies on CN_MESSAGE_PKG

Line 200: cn_message_pkg.flush;

196: SELECT DISTINCT physical_batch_id
197: FROM cn_process_batches
198: WHERE logical_batch_id = p_logical_batch_id;
199: BEGIN
200: cn_message_pkg.flush;
201:
202: l_sleep_time_char := fnd_profile.value('CN_SLEEP_TIME');
203: IF l_sleep_time_char IS NOT NULL THEN
204: l_sleep_time := to_number(l_sleep_time_char);

Line 228: cn_message_pkg.debug('Submitted Request: ' || l_temp_id);

224: argument1 => physical_rec.physical_batch_id,
225: argument2 => p_parent_proc_audit_id
226: );
227:
228: cn_message_pkg.debug('Submitted Request: ' || l_temp_id);
229: commit;
230:
231: g_batch_total := g_batch_total+1;
232: l_primary_request_stack(g_batch_total) := l_temp_id;

Line 247: cn_message_pkg.debug('Number of batches submitted: ' || g_batch_total);

243: IF (g_batch_total = 0) THEN
244: RAISE no_data_found;
245: END IF;
246:
247: cn_message_pkg.debug('Number of batches submitted: ' || g_batch_total);
248: ------------------------------------------------------------------------------------------
249: fnd_file.put_line(fnd_file.Log, 'Step 6 : Total Batches Submitted => ' || g_batch_total);
250: ------------------------------------------------------------------------------------------
251: dbms_lock.sleep(l_sleep_time);

Line 298: cn_message_pkg.debug('Conc_dispatch: no physical batches to process');

294: END LOOP;
295: END LOOP;
296: EXCEPTION
297: WHEN no_data_found THEN
298: cn_message_pkg.debug('Conc_dispatch: no physical batches to process');
299: ---------------------------------------------------------------------------
300: fnd_file.put_line(fnd_file.Log, 'Step 7 : No Physical Batches to process');
301: ---------------------------------------------------------------------------
302: WHEN conc_fail THEN

Line 304: cn_message_pkg.debug('Concurrent program fails: ' || l_temp_phys_batch_id);

300: fnd_file.put_line(fnd_file.Log, 'Step 7 : No Physical Batches to process');
301: ---------------------------------------------------------------------------
302: WHEN conc_fail THEN
303: update_error(l_temp_phys_batch_id);
304: cn_message_pkg.debug('Concurrent program fails: ' || l_temp_phys_batch_id);
305: --------------------------------------------------------------------------------------------------------------------
306: fnd_file.put_line(fnd_file.Log, 'Step 7 : Concurrent Program (Physical Batch) Failed => ' || l_temp_phys_batch_id);
307: --------------------------------------------------------------------------------------------------------------------
308: WHEN others THEN

Line 309: cn_message_pkg.debug(sqlerrm);

305: --------------------------------------------------------------------------------------------------------------------
306: fnd_file.put_line(fnd_file.Log, 'Step 7 : Concurrent Program (Physical Batch) Failed => ' || l_temp_phys_batch_id);
307: --------------------------------------------------------------------------------------------------------------------
308: WHEN others THEN
309: cn_message_pkg.debug(sqlerrm);
310: cn_message_pkg.rollback_errormsg_commit('Exception in conc_dispatch');
311: ---------------------------------------------------------------------------------
312: fnd_file.put_line(fnd_file.Log, 'Step 7 : Some Other Exception in Conc Dispatch');
313: ---------------------------------------------------------------------------------

Line 310: cn_message_pkg.rollback_errormsg_commit('Exception in conc_dispatch');

306: fnd_file.put_line(fnd_file.Log, 'Step 7 : Concurrent Program (Physical Batch) Failed => ' || l_temp_phys_batch_id);
307: --------------------------------------------------------------------------------------------------------------------
308: WHEN others THEN
309: cn_message_pkg.debug(sqlerrm);
310: cn_message_pkg.rollback_errormsg_commit('Exception in conc_dispatch');
311: ---------------------------------------------------------------------------------
312: fnd_file.put_line(fnd_file.Log, 'Step 7 : Some Other Exception in Conc Dispatch');
313: ---------------------------------------------------------------------------------
314: RAISE;

Line 363: cn_message_pkg.begin_batch(x_process_type => 'OPEN_PERIODS',

359: -- org ID is not set... raise error
360: RAISE fnd_api.g_exc_unexpected_error;
361: END IF;
362:
363: cn_message_pkg.begin_batch(x_process_type => 'OPEN_PERIODS',
364: x_process_audit_id => l_proc_audit_id,
365: x_parent_proc_audit_id => l_proc_audit_id,
366: x_request_id => fnd_global.conc_request_id,
367: p_org_id => l_org_id);

Line 369: cn_message_pkg.debug('Beginning of open periods process.');

365: x_parent_proc_audit_id => l_proc_audit_id,
366: x_request_id => fnd_global.conc_request_id,
367: p_org_id => l_org_id);
368:
369: cn_message_pkg.debug('Beginning of open periods process.');
370: ---------------------------------------------------------------
371: fnd_file.put_line(fnd_file.Log, 'Open Period Process - Start');
372: ---------------------------------------------------------------
373: --initialize message list

Line 531: cn_message_pkg.debug('There is some physical batch that failed.');

527: FROM cn_process_batches
528: WHERE logical_batch_id = l_logical_batch_id AND status_code = 'ERROR');
529: EXCEPTION
530: WHEN no_data_found THEN
531: cn_message_pkg.debug('There is some physical batch that failed.');
532: RAISE;
533: END;
534:
535: ----------------------------------------------------------------------------------------

Line 553: cn_message_pkg.debug('End of open periods process.');

549: ------------------------------------------------------------------------
550: fnd_file.put_line(fnd_file.Log, 'Step 10 : Processing Status => CLEAN ');
551: ------------------------------------------------------------------------
552:
553: cn_message_pkg.debug('End of open periods process.');
554: COMMIT;
555:
556: -------------------------------------------------------------
557: fnd_file.put_line(fnd_file.Log, 'Open Period Process - End');

Line 560: cn_message_pkg.end_batch(l_proc_audit_id);

556: -------------------------------------------------------------
557: fnd_file.put_line(fnd_file.Log, 'Open Period Process - End');
558: -------------------------------------------------------------
559:
560: cn_message_pkg.end_batch(l_proc_audit_id);
561: EXCEPTION
562: WHEN OTHERS THEN
563: rollback;
564: retcode := 2;

Line 573: cn_message_pkg.end_batch(l_proc_audit_id);

569: SET processing_status_code = 'FAILED'
570: WHERE processing_status_code = 'PROCESSING';
571:
572: IF l_org_id IS NOT NULL THEN
573: cn_message_pkg.end_batch(l_proc_audit_id);
574: END IF;
575:
576: -- commit status change
577: COMMIT;

Line 669: cn_message_pkg.begin_batch

665: -- org ID is not set... raise error
666: RAISE fnd_api.g_exc_unexpected_error;
667: END IF;
668:
669: cn_message_pkg.begin_batch
670: (
671: x_parent_proc_audit_id => p_parent_proc_audit_id
672: ,x_process_audit_id => l_proc_audit_id
673: ,x_request_id => fnd_global.conc_request_id

Line 677: cn_message_pkg.debug('Populate SRP tables runner');

673: ,x_request_id => fnd_global.conc_request_id
674: ,x_process_type => 'OPEN_PERIODS_RUNNER'
675: ,p_org_id => l_org_id);
676:
677: cn_message_pkg.debug('Populate SRP tables runner');
678:
679: FOR srp IN affected_srps LOOP
680: IF srp.period_id <> l_orig_pd_id THEN
681: l_orig_pd_id := srp.period_id;

Line 874: cn_message_pkg.debug('Update cn_period_statuses.processing_status_code');

870:
871: COMMIT; -- commit for each srp and period
872: END LOOP; -- main srp loop
873:
874: cn_message_pkg.debug('Update cn_period_statuses.processing_status_code');
875: cn_message_pkg.debug('Populate SRP tables runner <<');
876: cn_message_pkg.end_batch(l_proc_audit_id);
877: EXCEPTION
878: WHEN payee_pop_failed THEN

Line 875: cn_message_pkg.debug('Populate SRP tables runner <<');

871: COMMIT; -- commit for each srp and period
872: END LOOP; -- main srp loop
873:
874: cn_message_pkg.debug('Update cn_period_statuses.processing_status_code');
875: cn_message_pkg.debug('Populate SRP tables runner <<');
876: cn_message_pkg.end_batch(l_proc_audit_id);
877: EXCEPTION
878: WHEN payee_pop_failed THEN
879: --ROLLBACK TO populate_srp_tables;

Line 876: cn_message_pkg.end_batch(l_proc_audit_id);

872: END LOOP; -- main srp loop
873:
874: cn_message_pkg.debug('Update cn_period_statuses.processing_status_code');
875: cn_message_pkg.debug('Populate SRP tables runner <<');
876: cn_message_pkg.end_batch(l_proc_audit_id);
877: EXCEPTION
878: WHEN payee_pop_failed THEN
879: --ROLLBACK TO populate_srp_tables;
880: retcode := 2;