DBA Data[Home] [Help]

APPS.CZ_IB_TRANSACTIONS dependencies on CZ_UTILS

Line 38: cz_utils.log_report('CZ_IB_TRANSACTIONS', null, m_COUNTER,

34: p_error_message,
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

Line 65: cz_utils.log_report('CZ_IB_TRANSACTIONS', null, m_COUNTER,

61: fnd_msg_pub.GET(i,fnd_api.g_false),
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;

Line 486: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||

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)|| ' ||
490: ' '').config_revision_number = ''||TO_CHAR(t_config_query_table(i).config_revision_number)|| ' ||

Line 497: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||

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; ' ||
501: ' csi_cz_int.get_connected_configurations ' ||

Line 510: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||

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; ' ||
514: ' IF t_config_pair_table.COUNT > 0 THEN ' ||

Line 534: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||

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; ' ||
538: ' END LOOP; ' ||

Line 554: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_connected_configurations', l_ndebug,

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;
558:

Line 578: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_configuration_revision', l_ndebug,

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||
582: ' : current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24-MI-SS'),

Line 593: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||

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; ' ||
597: ' csi_cz_int.get_configuration_revision ' ||

Line 607: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||

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; ' ||
611: ' CZ_IB_TRANSACTIONS.m_config_rec.source_application_id := l_config_rec.source_application_id; ' ||

Line 623: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||

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; ' ||
627: ' END;' USING p_config_header_id,p_target_commitment_date;

Line 641: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_configuration_revision', l_ndebug,

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;
645: END get_configuration_revision;

Line 1093: -- IF t_ib_trackable_tbl(i)=NO_FLAG OR NOT(CZ_UTILS.conv_num(t_quantity_tbl(i)) > 0) THEN

1089: ELSE
1090: t_is_item_changed_tbl(i):='0';
1091: END IF;
1092:
1093: -- IF t_ib_trackable_tbl(i)=NO_FLAG OR NOT(CZ_UTILS.conv_num(t_quantity_tbl(i)) > 0) THEN
1094: IF t_ib_trackable_tbl(i)=NO_FLAG OR NOT(t_quantity_tbl(i) > 0) THEN -- sselahi: removed conv_num function
1095: FOR k IN t_config_item_tbl.FIRST..t_config_item_tbl.LAST
1096: LOOP
1097: IF t_parent_config_item_tbl(k) = t_config_item_tbl(i) THEN

Line 2280: ' AND CZ_UTILS.conv_num(item_val) IS NOT NULL AND ib_trackable=''1''; ' ||

2276: 'BULK COLLECT INTO ' ||
2277: ' CZ_IB_TRANSACTIONS.m_config_item_tbl ' ||
2278: 'FROM CZ_CONFIG_ITEMS_V ' ||
2279: 'WHERE instance_hdr_id=:1 AND instance_rev_nbr=:2 ' ||
2280: ' AND CZ_UTILS.conv_num(item_val) IS NOT NULL AND ib_trackable=''1''; ' ||
2281: 'END;'
2282: USING p_config_hdr_id,p_config_rev_nbr;
2283:
2284: ERROR_CODE := '0002';