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

Line 111: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108:
109: --enable_debug;
110: -- Debug info.
111: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
112: hz_utility_v2pub.debug(p_message=>'FR:load_finreports()+',
113: p_prefix=>l_debug_prefix,
114: p_msg_level=>fnd_log.level_procedure);
115: END IF;

Line 114: p_msg_level=>fnd_log.level_procedure);

110: -- Debug info.
111: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
112: hz_utility_v2pub.debug(p_message=>'FR:load_finreports()+',
113: p_prefix=>l_debug_prefix,
114: p_msg_level=>fnd_log.level_procedure);
115: END IF;
116:
117: process_insert_reports(P_DML_RECORD,
118: x_return_status, x_msg_count, x_msg_data );

Line 126: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

122: x_return_status, x_msg_count, x_msg_data );
123: END IF;
124:
125: -- Debug info.
126: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
127: hz_utility_v2pub.debug(p_message=>'FR:load_finreports()-',
128: p_prefix=>l_debug_prefix,
129: p_msg_level=>fnd_log.level_procedure);
130: END IF;

Line 129: p_msg_level=>fnd_log.level_procedure);

125: -- Debug info.
126: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
127: hz_utility_v2pub.debug(p_message=>'FR:load_finreports()-',
128: p_prefix=>l_debug_prefix,
129: p_msg_level=>fnd_log.level_procedure);
130: END IF;
131: --disable_debug;
132:
133: EXCEPTION

Line 165: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

161:
162: WHEN OTHERS THEN
163: --dbms_output.put_line('load finreport exception ' || SQLERRM);
164:
165: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
166: hz_utility_v2pub.debug(p_message=>'load_finreports Exception:',
167: p_prefix=>'SQL ERROR',
168: p_msg_level=>fnd_log.level_error);
169: hz_utility_v2pub.debug(p_message=>SQLERRM,

Line 168: p_msg_level=>fnd_log.level_error);

164:
165: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
166: hz_utility_v2pub.debug(p_message=>'load_finreports Exception:',
167: p_prefix=>'SQL ERROR',
168: p_msg_level=>fnd_log.level_error);
169: hz_utility_v2pub.debug(p_message=>SQLERRM,
170: p_prefix=>'SQL ERROR',
171: p_msg_level=>fnd_log.level_error);
172: END IF;

Line 171: p_msg_level=>fnd_log.level_error);

167: p_prefix=>'SQL ERROR',
168: p_msg_level=>fnd_log.level_error);
169: hz_utility_v2pub.debug(p_message=>SQLERRM,
170: p_prefix=>'SQL ERROR',
171: p_msg_level=>fnd_log.level_error);
172: END IF;
173:
174: ROLLBACK TO load_finreports_pvt;
175: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial reports');

Line 484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

480: l_debug_prefix VARCHAR2(30) := '';
481: BEGIN
482: -- Debug info.
483:
484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
485: hz_utility_v2pub.debug(p_message=>'FR:process_insert_reports()+',
486: p_prefix=>l_debug_prefix,
487: p_msg_level=>fnd_log.level_procedure);
488: END IF;

Line 487: p_msg_level=>fnd_log.level_procedure);

483:
484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
485: hz_utility_v2pub.debug(p_message=>'FR:process_insert_reports()+',
486: p_prefix=>l_debug_prefix,
487: p_msg_level=>fnd_log.level_procedure);
488: END IF;
489:
490: savepoint process_insert_finreports_pvt;
491: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 523: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

519: P_DML_RECORD.GMISS_CHAR, P_DML_RECORD.GMISS_DATE,
520: P_DML_RECORD.OS, P_DML_RECORD.FROM_OSR, P_DML_RECORD.TO_OSR,
521: P_DML_RECORD.BATCH_MODE_FLAG;
522:
523: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
524: hz_utility_v2pub.debug(p_message=>'FR:process_insert_reports()-',
525: p_prefix=>l_debug_prefix,
526: p_msg_level=>fnd_log.level_procedure);
527: END IF;

Line 526: p_msg_level=>fnd_log.level_procedure);

522:
523: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
524: hz_utility_v2pub.debug(p_message=>'FR:process_insert_reports()-',
525: p_prefix=>l_debug_prefix,
526: p_msg_level=>fnd_log.level_procedure);
527: END IF;
528:
529: EXCEPTION
530: WHEN DUP_VAL_ON_INDEX THEN

Line 567: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

563: other_exp_val VARCHAR2(1) := 'Y';
564: l_debug_prefix VARCHAR2(30) := '';
565: BEGIN
566:
567: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
568: hz_utility_v2pub.debug(p_message=>'FR:populate_error_table()+',
569: p_prefix=>l_debug_prefix,
570: p_msg_level=>fnd_log.level_procedure);
571: END IF;

Line 570: p_msg_level=>fnd_log.level_procedure);

566:
567: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
568: hz_utility_v2pub.debug(p_message=>'FR:populate_error_table()+',
569: p_prefix=>l_debug_prefix,
570: p_msg_level=>fnd_log.level_procedure);
571: END IF;
572:
573: /* other entities need to add checking for other constraints */
574: if (P_DUP_VAL_EXP = 'Y') then

Line 636: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

632: and fr_sg.party_orig_system_reference
633: between P_DML_RECORD.FROM_OSR and P_DML_RECORD.TO_OSR
634: );
635:
636: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
637: hz_utility_v2pub.debug(p_message=>'FR:populate_error_table()-',
638: p_prefix=>l_debug_prefix,
639: p_msg_level=>fnd_log.level_procedure);
640: END IF;

Line 639: p_msg_level=>fnd_log.level_procedure);

635:
636: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
637: hz_utility_v2pub.debug(p_message=>'FR:populate_error_table()-',
638: p_prefix=>l_debug_prefix,
639: p_msg_level=>fnd_log.level_procedure);
640: END IF;
641:
642: END populate_error_table;
643:

Line 654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

650: c_update_cursor update_cursor_type;
651: l_dml_exception varchar2(1) := 'N';
652: l_debug_prefix VARCHAR2(30) := '';
653: BEGIN
654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
655: hz_utility_v2pub.debug(p_message=>'process_update_reports()+',
656: p_prefix=>l_debug_prefix,
657: p_msg_level=>fnd_log.level_procedure);
658: END IF;

Line 657: p_msg_level=>fnd_log.level_procedure);

653: BEGIN
654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
655: hz_utility_v2pub.debug(p_message=>'process_update_reports()+',
656: p_prefix=>l_debug_prefix,
657: p_msg_level=>fnd_log.level_procedure);
658: END IF;
659: savepoint process_update_reports_pvt;
660: FND_MSG_PUB.initialize;
661: --Initialize API return status to success.

Line 761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

757: ;
758:
759: report_errors(P_DML_RECORD, l_dml_exception);
760:
761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
762: hz_utility_v2pub.debug(p_message=>'process_update_reports()-',
763: p_prefix=>l_debug_prefix,
764: p_msg_level=>fnd_log.level_procedure);
765: END IF;

Line 764: p_msg_level=>fnd_log.level_procedure);

760:
761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
762: hz_utility_v2pub.debug(p_message=>'process_update_reports()-',
763: p_prefix=>l_debug_prefix,
764: p_msg_level=>fnd_log.level_procedure);
765: END IF;
766:
767: EXCEPTION
768: WHEN OTHERS THEN

Line 850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

846: l_re_run_clause varchar2(40) := ' AND fr_int.interface_status = ''C''';
847: l_debug_prefix VARCHAR2(30) := '';
848: BEGIN
849:
850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug(p_message=>'FR:open_update_cursor()+',
852: p_prefix=>l_debug_prefix,
853: p_msg_level=>fnd_log.level_procedure);
854: END IF;

Line 853: p_msg_level=>fnd_log.level_procedure);

849:
850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug(p_message=>'FR:open_update_cursor()+',
852: p_prefix=>l_debug_prefix,
853: p_msg_level=>fnd_log.level_procedure);
854: END IF;
855:
856: if(P_DML_RECORD.RERUN='Y') then
857: OPEN update_cursor FOR l_sql_query || l_re_run_clause

Line 874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

870: P_DML_RECORD.BATCH_ID, P_DML_RECORD.BATCH_MODE_FLAG,
871: P_DML_RECORD.OS, P_DML_RECORD.FROM_OSR, P_DML_RECORD.TO_OSR;
872: end if;
873:
874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
875: hz_utility_v2pub.debug(p_message=>'FR:open_update_cursor()-',
876: p_prefix=>l_debug_prefix,
877: p_msg_level=>fnd_log.level_procedure);
878: END IF;

Line 877: p_msg_level=>fnd_log.level_procedure);

873:
874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
875: hz_utility_v2pub.debug(p_message=>'FR:open_update_cursor()-',
876: p_prefix=>l_debug_prefix,
877: p_msg_level=>fnd_log.level_procedure);
878: END IF;
879:
880: END open_update_cursor;
881:

Line 892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

888: num_exp NUMBER;
889: exp_ind NUMBER := 1;
890: l_debug_prefix VARCHAR2(30) := '';
891: BEGIN
892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
893: hz_utility_v2pub.debug(p_message=>'FR:report_errors()+',
894: p_prefix=>l_debug_prefix,
895: p_msg_level=>fnd_log.level_procedure);
896: END IF;

Line 895: p_msg_level=>fnd_log.level_procedure);

891: BEGIN
892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
893: hz_utility_v2pub.debug(p_message=>'FR:report_errors()+',
894: p_prefix=>l_debug_prefix,
895: p_msg_level=>fnd_log.level_procedure);
896: END IF;
897:
898: /**********************************/
899: /* Validation and Error reporting */

Line 916: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

912:
913: FOR k IN 1..l_fr_id.count LOOP
914:
915: IF SQL%BULK_ROWCOUNT(k) = 0 THEN
916: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
917: hz_utility_v2pub.debug(p_message=>'DML fails at ' || k,
918: p_prefix=>'ERROR',
919: p_msg_level=>fnd_log.level_error);
920: END IF;

Line 919: p_msg_level=>fnd_log.level_error);

915: IF SQL%BULK_ROWCOUNT(k) = 0 THEN
916: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
917: hz_utility_v2pub.debug(p_message=>'DML fails at ' || k,
918: p_prefix=>'ERROR',
919: p_msg_level=>fnd_log.level_error);
920: END IF;
921: l_num_row_processed(k) := 0;
922:
923: /* Check for any exceptions during DML */

Line 1005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1001: from dual
1002: where l_num_row_processed(j) = 0
1003: );
1004:
1005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1006: hz_utility_v2pub.debug(p_message=>'FR:report_errors()-',
1007: p_prefix=>l_debug_prefix,
1008: p_msg_level=>fnd_log.level_procedure);
1009: END IF;

Line 1008: p_msg_level=>fnd_log.level_procedure);

1004:
1005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1006: hz_utility_v2pub.debug(p_message=>'FR:report_errors()-',
1007: p_prefix=>l_debug_prefix,
1008: p_msg_level=>fnd_log.level_procedure);
1009: END IF;
1010:
1011: END report_errors;
1012: