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 310: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 743: if( FND_LOG.LEVEL_UNEXPECTED >=

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

Line 744: FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

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

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

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

778: v_transform_xml VARCHAR2(32767) := '';
779: l_api_name constant VARCHAR2(40) := 'update_diff_type_counts : ';
780: BEGIN
781:
782: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
783: 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);
784: END IF;
785:
786: SELECT nvl(COUNT, 0),

Line 783: 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);

779: l_api_name constant VARCHAR2(40) := 'update_diff_type_counts : ';
780: BEGIN
781:
782: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
783: 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);
784: END IF;
785:
786: SELECT nvl(COUNT, 0),
787: e.column_value.getrootelement() AS

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

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

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

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