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.CZ_IB_TRANSACTIONS dependencies on FND_LOG

Line 9: -- this method add log message to both CZ_DB_LOGS and FND LOG tables

5:
6: TYPE cv_cursor_type IS REF CURSOR;
7:
8: --
9: -- this method add log message to both CZ_DB_LOGS and FND LOG tables
10: --
11: PROCEDURE LOG_REPORT
12: (p_run_id IN VARCHAR2,
13: p_error_message IN VARCHAR2,

Line 39: p_error_message, fnd_log.LEVEL_ERROR);

35: m_COUNTER);
36: COMMIT;
37:
38: cz_utils.log_report('CZ_IB_TRANSACTIONS', null, m_COUNTER,
39: p_error_message, fnd_log.LEVEL_ERROR);
40:
41: ELSE
42: FOR i IN 1..p_count
43: LOOP

Line 66: fnd_msg_pub.GET(i,fnd_api.g_false), fnd_log.LEVEL_ERROR);

62: m_COUNTER);
63: COMMIT;
64:
65: cz_utils.log_report('CZ_IB_TRANSACTIONS', null, m_COUNTER,
66: fnd_msg_pub.GET(i,fnd_api.g_false), fnd_log.LEVEL_ERROR);
67: END LOOP;
68:
69: END IF;
70:

Line 485: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

481: ' FOR i IN CZ_IB_TRANSACTIONS.m_config_query_table.FIRST..CZ_IB_TRANSACTIONS.m_config_query_table.LAST ' ||
482: ' LOOP ' ||
483: ' t_config_query_table(i).config_header_id := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_header_id; ' ||
484: ' t_config_query_table(i).config_revision_number := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_revision_number; ' ||
485: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
486: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
487: ' ''csi_cz_int.get_connected_configurations() : parameters p_config_query_table(''||TO_CHAR(i)|| ' ||
488: ' '').config_header_id = ''||TO_CHAR(t_config_query_table(i).config_header_id)|| ' ||
489: ' '' p_config_query_table(''||TO_CHAR(i)|| ' ||

Line 492: ' fnd_log.LEVEL_STATEMENT); ' ||

488: ' '').config_header_id = ''||TO_CHAR(t_config_query_table(i).config_header_id)|| ' ||
489: ' '' p_config_query_table(''||TO_CHAR(i)|| ' ||
490: ' '').config_revision_number = ''||TO_CHAR(t_config_query_table(i).config_revision_number)|| ' ||
491: ' '' : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
492: ' fnd_log.LEVEL_STATEMENT); ' ||
493: ' END IF; ' ||
494: ' END LOOP; ' ||
495: ' END IF; ' ||
496: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

Line 496: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

492: ' fnd_log.LEVEL_STATEMENT); ' ||
493: ' END IF; ' ||
494: ' END LOOP; ' ||
495: ' END IF; ' ||
496: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
497: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
498: ' ''csi_cz_int.get_connected_configurations() will be called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
499: ' fnd_log.LEVEL_STATEMENT); ' ||
500: ' END IF; ' ||

Line 499: ' fnd_log.LEVEL_STATEMENT); ' ||

495: ' END IF; ' ||
496: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
497: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
498: ' ''csi_cz_int.get_connected_configurations() will be called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
499: ' fnd_log.LEVEL_STATEMENT); ' ||
500: ' END IF; ' ||
501: ' csi_cz_int.get_connected_configurations ' ||
502: ' ( ' ||
503: ' p_config_query_table => t_config_query_table, ' ||

Line 509: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

505: ' x_config_pair_table => t_config_pair_table, ' ||
506: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
507: ' x_return_message => CZ_IB_TRANSACTIONS.m_return_message ' ||
508: ' ); ' ||
509: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
510: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
511: ' ''csi_cz_int.get_connected_configurations() has been called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
512: ' fnd_log.LEVEL_STATEMENT); ' ||
513: ' END IF; ' ||

Line 512: ' fnd_log.LEVEL_STATEMENT); ' ||

508: ' ); ' ||
509: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
510: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
511: ' ''csi_cz_int.get_connected_configurations() has been called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
512: ' fnd_log.LEVEL_STATEMENT); ' ||
513: ' END IF; ' ||
514: ' IF t_config_pair_table.COUNT > 0 THEN ' ||
515: ' FOR i IN t_config_pair_table.FIRST..t_config_pair_table.LAST ' ||
516: ' LOOP ' ||

Line 533: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

529: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF2 := t_config_pair_table(i).SOURCE_TXN_LINE_REF2; ' ||
530: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF3 := t_config_pair_table(i).SOURCE_TXN_LINE_REF3; ' ||
531: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_ID := t_config_pair_table(i).LOCK_ID; ' ||
532: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_STATUS := t_config_pair_table(i).LOCK_STATUS; ' ||
533: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
534: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
535: ' ''Out array for get_connected_configurations() has been populated : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
536: ' fnd_log.LEVEL_STATEMENT); ' ||
537: ' END IF; ' ||

Line 536: ' fnd_log.LEVEL_STATEMENT); ' ||

532: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_STATUS := t_config_pair_table(i).LOCK_STATUS; ' ||
533: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
534: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
535: ' ''Out array for get_connected_configurations() has been populated : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
536: ' fnd_log.LEVEL_STATEMENT); ' ||
537: ' END IF; ' ||
538: ' END LOOP; ' ||
539: ' END IF; ' ||
540: ' END;' USING p_instance_level;

Line 553: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

549: WHEN OTHERS THEN
550: x_return_status := FND_API.g_ret_sts_unexp_error;
551: x_return_message := 'CZ_IB_TRANSACTIONS.Get_Connected_Configurations : '||SQLERRM;
552:
553: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
554: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_connected_configurations', l_ndebug,
555: 'Fatal error : '||SQLERRM||' : current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24-MI-SS'),
556: fnd_log.LEVEL_ERROR);
557: END IF;

Line 556: fnd_log.LEVEL_ERROR);

552:
553: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
554: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_connected_configurations', l_ndebug,
555: 'Fatal error : '||SQLERRM||' : current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24-MI-SS'),
556: fnd_log.LEVEL_ERROR);
557: END IF;
558:
559: LOG_REPORT(m_RUN_ID,x_return_message);
560: END get_connected_configurations;

Line 577: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

573: l_ndebug NUMBER := 1;
574:
575: BEGIN
576:
577: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_configuration_revision', l_ndebug,
579: 'csi_cz_int.get_configuration_revision() parameters : p_config_header_id='||TO_CHAR(p_config_header_id)||
580: ' p_target_commitment_date='||TO_CHAR(p_target_commitment_date,'DD-MM-YYYY HH24-MI-SS')||
581: ' px_instance_level='||px_instance_level||

Line 583: fnd_log.LEVEL_STATEMENT);

579: 'csi_cz_int.get_configuration_revision() parameters : p_config_header_id='||TO_CHAR(p_config_header_id)||
580: ' p_target_commitment_date='||TO_CHAR(p_target_commitment_date,'DD-MM-YYYY HH24-MI-SS')||
581: ' px_instance_level='||px_instance_level||
582: ' : current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24-MI-SS'),
583: fnd_log.LEVEL_STATEMENT);
584: END IF;
585:
586: EXECUTE IMMEDIATE
587: ' DECLARE ' ||

Line 592: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

588: ' v_instance_level VARCHAR2(255):='''||px_instance_level||'''; ' ||
589: ' l_config_rec CSI_CZ_INT.config_rec; ' ||
590: ' l_ndebug NUMBER := 1; ' ||
591: ' BEGIN ' ||
592: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
593: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
594: ' ''csi_cz_int.get_configuration_revision() will be called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
595: ' fnd_log.LEVEL_STATEMENT); ' ||
596: ' END IF; ' ||

Line 595: ' fnd_log.LEVEL_STATEMENT); ' ||

591: ' BEGIN ' ||
592: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
593: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
594: ' ''csi_cz_int.get_configuration_revision() will be called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
595: ' fnd_log.LEVEL_STATEMENT); ' ||
596: ' END IF; ' ||
597: ' csi_cz_int.get_configuration_revision ' ||
598: ' ( ' ||
599: ' p_config_header_id => :1, ' ||

Line 606: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

602: ' x_install_config_rec => l_config_rec, ' ||
603: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
604: ' x_return_message => CZ_IB_TRANSACTIONS.m_return_message ' ||
605: ' ); ' ||
606: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
607: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
608: ' ''csi_cz_int.get_configuration_revision() has been called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
609: ' fnd_log.LEVEL_STATEMENT); ' ||
610: ' END IF; ' ||

Line 609: ' fnd_log.LEVEL_STATEMENT); ' ||

605: ' ); ' ||
606: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
607: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
608: ' ''csi_cz_int.get_configuration_revision() has been called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
609: ' fnd_log.LEVEL_STATEMENT); ' ||
610: ' END IF; ' ||
611: ' CZ_IB_TRANSACTIONS.m_config_rec.source_application_id := l_config_rec.source_application_id; ' ||
612: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_header_ref := l_config_rec.source_txn_header_ref; ' ||
613: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref1 := l_config_rec.source_txn_line_ref1; ' ||

Line 622: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

618: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_status := l_config_rec.lock_status; ' ||
619: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_hdr_id := l_config_rec.config_inst_hdr_id; ' ||
620: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_item_id := l_config_rec.config_inst_item_id; ' ||
621: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_rev_num := l_config_rec.config_inst_rev_num; ' ||
622: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
623: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
624: ' ''Out array for get_configuration_revision() has been populated : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
625: ' fnd_log.LEVEL_STATEMENT); ' ||
626: ' END IF; ' ||

Line 625: ' fnd_log.LEVEL_STATEMENT); ' ||

621: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_rev_num := l_config_rec.config_inst_rev_num; ' ||
622: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
623: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
624: ' ''Out array for get_configuration_revision() has been populated : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
625: ' fnd_log.LEVEL_STATEMENT); ' ||
626: ' END IF; ' ||
627: ' END;' USING p_config_header_id,p_target_commitment_date;
628:
629: x_config_rev_number := CZ_IB_TRANSACTIONS.m_config_rev_number;

Line 640: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

636: x_return_status := FND_API.g_ret_sts_unexp_error;
637: x_return_message := 'CZ_IB_TRANSACTIONS.Get_Configuration_Revision : '||SQLERRM;
638: LOG_REPORT(m_RUN_ID,x_return_message);
639:
640: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
641: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_configuration_revision', l_ndebug,
642: 'Fatal error : '||SQLERRM||' : current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24-MI-SS'),
643: fnd_log.LEVEL_ERROR);
644: END IF;

Line 643: fnd_log.LEVEL_ERROR);

639:
640: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
641: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_configuration_revision', l_ndebug,
642: 'Fatal error : '||SQLERRM||' : current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24-MI-SS'),
643: fnd_log.LEVEL_ERROR);
644: END IF;
645: END get_configuration_revision;
646:
647: --