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

Line 138: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

134: 'Y', -- exclude details for AM
135: NULL);
136: -- attr_diff
137:
138: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
139: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name || to_char(systimestamp), 'Inserting into az_diff_results for request_id: '
140: || p_request_id || ' source: ' || p_source);
141: END IF;
142:

Line 139: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name || to_char(systimestamp), 'Inserting into az_diff_results for request_id: '

135: NULL);
136: -- attr_diff
137:
138: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
139: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name || to_char(systimestamp), 'Inserting into az_diff_results for request_id: '
140: || p_request_id || ' source: ' || p_source);
141: END IF;
142:
143: v_dml_count := v_dml_count + 1;

Line 255: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

251: AND source = p_source
252: AND id = v_matching_vo_id_b
253: AND is_primary = 'N';
254:
255: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
256: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
257: || to_char(systimestamp), 'Updating v_children_A_ID_List_I: '
258: || v_children_a_hc_list(i) || ' p_data_pid_B: ' || p_data_pid_b
259: || ' p_request_id: ' || p_request_id || ' v_matching_VO_id_B: ' || v_matching_vo_id_b);

Line 256: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

252: AND id = v_matching_vo_id_b
253: AND is_primary = 'N';
254:
255: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
256: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
257: || to_char(systimestamp), 'Updating v_children_A_ID_List_I: '
258: || v_children_a_hc_list(i) || ' p_data_pid_B: ' || p_data_pid_b
259: || ' p_request_id: ' || p_request_id || ' v_matching_VO_id_B: ' || v_matching_vo_id_b);
260: END IF;

Line 314: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

310: ELSE
311: v_exclude_details := 'N';
312: END IF;
313:
314: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
315: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
316: || to_char(systimestamp), 'Constructing exclude details and is different '
317: || ' v_is_different: ' || v_is_different || ' v_exclude_details_temp: '
318: || v_exclude_details_temp || ' v_exclude_details: ' || v_exclude_details);

Line 315: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

311: v_exclude_details := 'N';
312: END IF;
313:
314: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
315: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
316: || to_char(systimestamp), 'Constructing exclude details and is different '
317: || ' v_is_different: ' || v_is_different || ' v_exclude_details_temp: '
318: || v_exclude_details_temp || ' v_exclude_details: ' || v_exclude_details);
319: END IF;

Line 422: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

418: l_api_name constant VARCHAR2(30) := 'output_A_only : ';
419: BEGIN
420: -- output this
421:
422: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
423: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
424: || to_char(systimestamp), 'Called output_A_only with ' || ' p_request_id: '
425: || p_request_id || ' p_source: ' || p_source || ' p_depth: ' || p_depth
426: || ' p_data_id: ' || p_data_id);

Line 423: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

419: BEGIN
420: -- output this
421:
422: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
423: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
424: || to_char(systimestamp), 'Called output_A_only with ' || ' p_request_id: '
425: || p_request_id || ' p_source: ' || p_source || ' p_depth: ' || p_depth
426: || ' p_data_id: ' || p_data_id);
427: END IF;

Line 469: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

465: ELSE
466: v_type := 2;
467: END IF;
468:
469: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
470: -- IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN
471: -- fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
472: -- || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());
473: -- END IF;

Line 471: -- fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

467: END IF;
468:
469: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
470: -- IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN
471: -- fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
472: -- || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());
473: -- END IF;
474: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
475: || to_char(systimestamp), 'v_exclude_details: ' || v_exclude_details || ' p_results_pid: ' || p_results_pid);

Line 474: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

470: -- IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN
471: -- fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
472: -- || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());
473: -- END IF;
474: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
475: || to_char(systimestamp), 'v_exclude_details: ' || v_exclude_details || ' p_results_pid: ' || p_results_pid);
476: END IF;
477:
478: INSERT

Line 540: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

536: l_api_name constant VARCHAR2(30) := 'output_B_only : ';
537: BEGIN
538: -- output this
539:
540: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
541: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
542: || to_char(systimestamp), 'Called output_B_only with ' || ' p_request_id: ' || p_request_id
543: || ' p_source: ' || p_source || ' p_depth: ' || p_depth || ' p_results_pid: ' || p_results_pid
544: || ' p_data_id: ' || p_data_id);

Line 541: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

537: BEGIN
538: -- output this
539:
540: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
541: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
542: || to_char(systimestamp), 'Called output_B_only with ' || ' p_request_id: ' || p_request_id
543: || ' p_source: ' || p_source || ' p_depth: ' || p_depth || ' p_results_pid: ' || p_results_pid
544: || ' p_data_id: ' || p_data_id);
545: END IF;

Line 587: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

583: ELSE
584: v_type := 2;
585: END IF;
586:
587: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
588: IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN
589: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
590: || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());
591: END IF;

Line 589: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

585: END IF;
586:
587: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
588: IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN
589: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
590: || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());
591: END IF;
592: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
593: || to_char(systimestamp), 'v_exclude_details: ' || v_exclude_details || ' p_results_pid: '

Line 592: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

588: IF(LENGTH(v_temp_xmltype.getClobVal()) > 0 ) THEN
589: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
590: || to_char(systimestamp), ' v_temp_xmltype: ' || v_temp_xmltype.getclobval());
591: END IF;
592: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
593: || to_char(systimestamp), 'v_exclude_details: ' || v_exclude_details || ' p_results_pid: '
594: || p_results_pid);
595: END IF;
596:

Line 689: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level)

685: WHERE request_id = p_request_id
686: AND source = p_source
687: AND id = v_id;
688:
689: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level)
690: THEN
691: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
692: || to_char(systimestamp), 'v_different_ID_List_I: ' || v_different_id_list(i)
693: || ' v_different_PID_List: ' || v_different_pid_list(i) || ' v_parent_id: ' || v_parent_id ||

Line 691: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

687: AND id = v_id;
688:
689: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level)
690: THEN
691: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
692: || to_char(systimestamp), 'v_different_ID_List_I: ' || v_different_id_list(i)
693: || ' v_different_PID_List: ' || v_different_pid_list(i) || ' v_parent_id: ' || v_parent_id ||
694: ' v_is_different: ' || v_is_different || ' v_show_only_diff: ' || v_show_only_diff);
695: END IF;

Line 747: if( FND_LOG.LEVEL_UNEXPECTED >=

743: v_message VARCHAR2(2048);
744:
745: BEGIN
746:
747: if( FND_LOG.LEVEL_UNEXPECTED >=
748: FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
749: FND_MESSAGE.SET_NAME('AZ', 'AZ_R12_PLSQL_EXCEPTION'); -- Seeded Message
750: -- Runtime Information
751: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ErrCode);

Line 748: FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

744:
745: BEGIN
746:
747: if( FND_LOG.LEVEL_UNEXPECTED >=
748: FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
749: FND_MESSAGE.SET_NAME('AZ', 'AZ_R12_PLSQL_EXCEPTION'); -- Seeded Message
750: -- Runtime Information
751: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ErrCode);
752: FND_MESSAGE.SET_TOKEN('ERROR_MESG', ErrMsg);

Line 770: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

766:
767: IF MOD(v_dml_count, commit_batch_size) = 0 THEN
768: COMMIT;
769:
770: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
771: fnd_log.string(fnd_log.level_statement, c_log_head || 'commit_if_required : ' || to_char(systimestamp), 'Committed transaction');
772: END IF;
773:
774: END IF;

Line 771: fnd_log.string(fnd_log.level_statement, c_log_head || 'commit_if_required : ' || to_char(systimestamp), 'Committed transaction');

767: IF MOD(v_dml_count, commit_batch_size) = 0 THEN
768: COMMIT;
769:
770: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
771: fnd_log.string(fnd_log.level_statement, c_log_head || 'commit_if_required : ' || to_char(systimestamp), 'Committed transaction');
772: END IF;
773:
774: END IF;
775:

Line 786: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

782: v_transform_xml VARCHAR2(32767) := '';
783: l_api_name constant VARCHAR2(40) := 'update_diff_type_counts : ';
784: BEGIN
785:
786: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
787: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name || to_char(systimestamp), 'update_diff_type_counts called with p_request_id: ' || p_request_id || ' p_source: ' || p_source);
788: END IF;
789:
790: SELECT nvl(COUNT, 0),

Line 787: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name || to_char(systimestamp), 'update_diff_type_counts called with p_request_id: ' || p_request_id || ' p_source: ' || p_source);

783: l_api_name constant VARCHAR2(40) := 'update_diff_type_counts : ';
784: BEGIN
785:
786: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
787: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name || to_char(systimestamp), 'update_diff_type_counts called with p_request_id: ' || p_request_id || ' p_source: ' || p_source);
788: END IF;
789:
790: SELECT nvl(COUNT, 0),
791: e.column_value.getrootelement() AS

Line 843: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

839:
840:
841: ';
842:
843: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
844: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name ||
845: to_char(systimestamp), 'Query to update selection set with counts : update az_requests d set d.selection_set = d.selection_set.transform(xmltype(''' ||
846: v_transform_xml || ''')).createSchemabasedxml(d.selection_set.getSchemaURL()) WHERE request_id=' || p_request_id || ' and request_type=''C''');
847: END IF;

Line 844: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name ||

840:
841: ';
842:
843: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
844: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name ||
845: to_char(systimestamp), 'Query to update selection set with counts : update az_requests d set d.selection_set = d.selection_set.transform(xmltype(''' ||
846: v_transform_xml || ''')).createSchemabasedxml(d.selection_set.getSchemaURL()) WHERE request_id=' || p_request_id || ' and request_type=''C''');
847: END IF;
848: