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.FEM_DIM_HIER_LOADER_PKG dependencies on FND_FILE

Line 133: fnd_file.put_line(fnd_file.log, ' No data found for loading dimensions and hierarchies');

129:
130: END IF;
131:
132: IF NOT g_load_dimensions AND NOT g_load_hierarchies THEN
133: fnd_file.put_line(fnd_file.log, ' No data found for loading dimensions and hierarchies');
134: END IF;
135:
136: print_params;
137:

Line 158: fnd_file.put_line(fnd_file.log, 'Exception - process_request ' || sqlerrm);

154: WHEN OTHERS THEN
155: fem_engines_pkg.tech_message (p_severity => g_log_level_6
156: ,p_module => g_block||'.process_request(PROCEDURE)'
157: ,p_msg_text => 'EXCEPTION in process_request ' || sqlerrm);
158: fnd_file.put_line(fnd_file.log, 'Exception - process_request ' || sqlerrm);
159: RAISE;
160:
161: END process_request;
162:

Line 240: fnd_file.put_line(fnd_file.log, 'Error @ get parameters');

236: WHEN OTHERS THEN
237: fem_engines_pkg.tech_message (p_severity => g_log_level_6
238: ,p_module => g_block||'.get_parameters (PROCEDURE)'
239: ,p_msg_text => 'EXCEPTION in get_parameters.loading dimensions ' || sqlerrm);
240: fnd_file.put_line(fnd_file.log, 'Error @ get parameters');
241: RAISE; -- dim_loader_rule_error;
242: END;
243:
244: IF gs_dim_id_tab.COUNT > 0.0 THEN

Line 271: fnd_file.put_line(fnd_file.log, 'Error @ get parameters');

267: fem_engines_pkg.tech_message (p_severity => g_log_level_6
268: ,p_module => g_block||'.get_parameters (PROCEDURE)'
269: ,p_msg_text => 'EXCEPTION in get_parameters.loading hierarchies ' || sqlerrm);
270:
271: fnd_file.put_line(fnd_file.log, 'Error @ get parameters');
272: RAISE; -- dim_loader_rule_error;
273: END;
274:
275: IF gs_hier_obj_id_tab.COUNT > 0.0 THEN

Line 388: fnd_file.put_line(fnd_file.log, 'Exception - wait_for_requests' || sqlerrm);

384: WHEN OTHERS THEN
385: fem_engines_pkg.tech_message (p_severity => g_log_level_6
386: ,p_module => g_block||'.wait_for_requests(PROCEDURE)'
387: ,p_msg_text => 'EXCEPTION in wait_for_requests ' || sqlerrm);
388: fnd_file.put_line(fnd_file.log, 'Exception - wait_for_requests' || sqlerrm);
389: RAISE;
390: END wait_for_requests;
391:
392: ------------------------

Line 444: fnd_file.put_line(fnd_file.log, 'Table ' || dim_rec.dim_intf_table_name || ' does not exist ');

440: fem_engines_pkg.tech_message (p_severity => g_log_level_6
441: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
442: ,p_msg_text => 'Error while checking if data EXISTS in interface table '
443: || dim_rec.dim_intf_table_name || ' - ' || sqlerrm);
444: fnd_file.put_line(fnd_file.log, 'Table ' || dim_rec.dim_intf_table_name || ' does not exist ');
445: fnd_file.put_line(fnd_file.log, 'Exception - submit_dimension_loaders ' || sqlerrm);
446:
447: RAISE;
448: END;

Line 445: fnd_file.put_line(fnd_file.log, 'Exception - submit_dimension_loaders ' || sqlerrm);

441: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
442: ,p_msg_text => 'Error while checking if data EXISTS in interface table '
443: || dim_rec.dim_intf_table_name || ' - ' || sqlerrm);
444: fnd_file.put_line(fnd_file.log, 'Table ' || dim_rec.dim_intf_table_name || ' does not exist ');
445: fnd_file.put_line(fnd_file.log, 'Exception - submit_dimension_loaders ' || sqlerrm);
446:
447: RAISE;
448: END;
449:

Line 506: fnd_file.put_line(fnd_file.log, 'Exception - submit_dimension_loaders' || sqlerrm);

502: WHEN OTHERS THEN
503: fem_engines_pkg.tech_message (p_severity => g_log_level_6
504: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
505: ,p_msg_text => 'EXCEPTION in submit_dimension_loaders ' || sqlerrm);
506: fnd_file.put_line(fnd_file.log, 'Exception - submit_dimension_loaders' || sqlerrm);
507: RAISE;
508: END submit_dimension_loaders;
509:
510: -------------------------------

Line 608: fnd_file.put_line(fnd_file.log, 'Exception - submit_hierarchy_loaders' || sqlerrm);

604: WHEN OTHERS THEN
605: fem_engines_pkg.tech_message (p_severity => g_log_level_6
606: ,p_module => g_block||'.submit_hierarchy_loader(PROCEDURE)'
607: ,p_msg_text => 'EXCEPTION in submit_hierarchy_loader ' || sqlerrm);
608: fnd_file.put_line(fnd_file.log, 'Exception - submit_hierarchy_loaders' || sqlerrm);
609: RAISE;
610: END submit_hierarchy_loaders;
611:
612: -------------------------------

Line 664: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages' || sqlerrm);

660: WHEN OTHERS THEN
661: fem_engines_pkg.tech_message (p_severity => g_log_level_6
662: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
663: ,p_msg_text => 'EXCEPTION in build_dim_stages ' || sqlerrm);
664: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages' || sqlerrm);
665: RAISE;
666: END build_dim_stages;
667:
668: -----------------------

Line 808: fnd_file.put_line(fnd_file.log, 'Exception - build_hier_stages' || sqlerrm);

804: WHEN OTHERS THEN
805: fem_engines_pkg.tech_message (p_severity => g_log_level_6
806: ,p_module => g_block||'.build_hier_stages(PROCEDURE)'
807: ,p_msg_text => 'EXCEPTION in build_hier_stages ' || sqlerrm);
808: fnd_file.put_line(fnd_file.log, 'Exception - build_hier_stages' || sqlerrm);
809: RAISE;
810: END build_hier_stages;
811:
812: ------------------------

Line 827: fnd_file.put_line(FND_FILE.log, '=============================================================================');

823: PROCEDURE print_params IS
824:
825: BEGIN
826:
827: fnd_file.put_line(FND_FILE.log, '=============================================================================');
828: fnd_file.put_line(FND_FILE.log, '======================== Printing Parameters ==========================');
829:
830: FOR dim_rec IN (SELECT dimension_id,
831: dim_intf_table_name,

Line 828: fnd_file.put_line(FND_FILE.log, '======================== Printing Parameters ==========================');

824:
825: BEGIN
826:
827: fnd_file.put_line(FND_FILE.log, '=============================================================================');
828: fnd_file.put_line(FND_FILE.log, '======================== Printing Parameters ==========================');
829:
830: FOR dim_rec IN (SELECT dimension_id,
831: dim_intf_table_name,
832: dimension_varchar_label

Line 835: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || dim_rec.dimension_id);

831: dim_intf_table_name,
832: dimension_varchar_label
833: FROM fem_ld_dim_requests_gt )
834: LOOP
835: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || dim_rec.dimension_id);
836: fnd_file.put_line(FND_FILE.log, ' Interface TB :: ' || dim_rec.dim_intf_table_name);
837: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || dim_rec.dimension_varchar_label);
838: END LOOP;
839:

Line 836: fnd_file.put_line(FND_FILE.log, ' Interface TB :: ' || dim_rec.dim_intf_table_name);

832: dimension_varchar_label
833: FROM fem_ld_dim_requests_gt )
834: LOOP
835: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || dim_rec.dimension_id);
836: fnd_file.put_line(FND_FILE.log, ' Interface TB :: ' || dim_rec.dim_intf_table_name);
837: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || dim_rec.dimension_varchar_label);
838: END LOOP;
839:
840: fnd_file.put_line(FND_FILE.log, '=============================================================================');

Line 837: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || dim_rec.dimension_varchar_label);

833: FROM fem_ld_dim_requests_gt )
834: LOOP
835: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || dim_rec.dimension_id);
836: fnd_file.put_line(FND_FILE.log, ' Interface TB :: ' || dim_rec.dim_intf_table_name);
837: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || dim_rec.dimension_varchar_label);
838: END LOOP;
839:
840: fnd_file.put_line(FND_FILE.log, '=============================================================================');
841:

Line 840: fnd_file.put_line(FND_FILE.log, '=============================================================================');

836: fnd_file.put_line(FND_FILE.log, ' Interface TB :: ' || dim_rec.dim_intf_table_name);
837: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || dim_rec.dimension_varchar_label);
838: END LOOP;
839:
840: fnd_file.put_line(FND_FILE.log, '=============================================================================');
841:
842: FOR hier_rec IN (SELECT dimension_id,
843: dimension_varchar_label,
844: hierarchy_object_name,

Line 849: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || hier_rec.table_row);

845: hier_obj_def_display_name,
846: table_row
847: FROM fem_ld_hier_requests_gt )
848: LOOP
849: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || hier_rec.table_row);
850: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || hier_rec.dimension_id);
851: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || hier_rec.dimension_varchar_label);
852: fnd_file.put_line(FND_FILE.log, ' Hier Obj Name:: ' || hier_rec.hierarchy_object_name);
853: fnd_file.put_line(FND_FILE.log, ' Hier Obj Def :: ' || hier_rec.hier_obj_def_display_name);

Line 850: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || hier_rec.dimension_id);

846: table_row
847: FROM fem_ld_hier_requests_gt )
848: LOOP
849: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || hier_rec.table_row);
850: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || hier_rec.dimension_id);
851: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || hier_rec.dimension_varchar_label);
852: fnd_file.put_line(FND_FILE.log, ' Hier Obj Name:: ' || hier_rec.hierarchy_object_name);
853: fnd_file.put_line(FND_FILE.log, ' Hier Obj Def :: ' || hier_rec.hier_obj_def_display_name);
854: END LOOP;

Line 851: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || hier_rec.dimension_varchar_label);

847: FROM fem_ld_hier_requests_gt )
848: LOOP
849: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || hier_rec.table_row);
850: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || hier_rec.dimension_id);
851: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || hier_rec.dimension_varchar_label);
852: fnd_file.put_line(FND_FILE.log, ' Hier Obj Name:: ' || hier_rec.hierarchy_object_name);
853: fnd_file.put_line(FND_FILE.log, ' Hier Obj Def :: ' || hier_rec.hier_obj_def_display_name);
854: END LOOP;
855:

Line 852: fnd_file.put_line(FND_FILE.log, ' Hier Obj Name:: ' || hier_rec.hierarchy_object_name);

848: LOOP
849: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || hier_rec.table_row);
850: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || hier_rec.dimension_id);
851: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || hier_rec.dimension_varchar_label);
852: fnd_file.put_line(FND_FILE.log, ' Hier Obj Name:: ' || hier_rec.hierarchy_object_name);
853: fnd_file.put_line(FND_FILE.log, ' Hier Obj Def :: ' || hier_rec.hier_obj_def_display_name);
854: END LOOP;
855:
856: fnd_file.put_line(FND_FILE.log, '======================== End Printing Parameters ======================');

Line 853: fnd_file.put_line(FND_FILE.log, ' Hier Obj Def :: ' || hier_rec.hier_obj_def_display_name);

849: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || hier_rec.table_row);
850: fnd_file.put_line(FND_FILE.log, ' Dimension ID :: ' || hier_rec.dimension_id);
851: fnd_file.put_line(FND_FILE.log, ' Dim Label :: ' || hier_rec.dimension_varchar_label);
852: fnd_file.put_line(FND_FILE.log, ' Hier Obj Name:: ' || hier_rec.hierarchy_object_name);
853: fnd_file.put_line(FND_FILE.log, ' Hier Obj Def :: ' || hier_rec.hier_obj_def_display_name);
854: END LOOP;
855:
856: fnd_file.put_line(FND_FILE.log, '======================== End Printing Parameters ======================');
857: fnd_file.put_line(FND_FILE.log, '=============================================================================');

Line 856: fnd_file.put_line(FND_FILE.log, '======================== End Printing Parameters ======================');

852: fnd_file.put_line(FND_FILE.log, ' Hier Obj Name:: ' || hier_rec.hierarchy_object_name);
853: fnd_file.put_line(FND_FILE.log, ' Hier Obj Def :: ' || hier_rec.hier_obj_def_display_name);
854: END LOOP;
855:
856: fnd_file.put_line(FND_FILE.log, '======================== End Printing Parameters ======================');
857: fnd_file.put_line(FND_FILE.log, '=============================================================================');
858:
859:
860: END print_params;

Line 857: fnd_file.put_line(FND_FILE.log, '=============================================================================');

853: fnd_file.put_line(FND_FILE.log, ' Hier Obj Def :: ' || hier_rec.hier_obj_def_display_name);
854: END LOOP;
855:
856: fnd_file.put_line(FND_FILE.log, '======================== End Printing Parameters ======================');
857: fnd_file.put_line(FND_FILE.log, '=============================================================================');
858:
859:
860: END print_params;
861:

Line 922: fnd_file.put_line(fnd_file.log, 'Exception - log_dimensions' || sqlerrm);

918: WHEN OTHERS THEN
919: fem_engines_pkg.tech_message (p_severity => g_log_level_6
920: ,p_module => g_block||'.log_dimensions(PROCEDURE)'
921: ,p_msg_text => 'EXCEPTION in log_dimensions ' || sqlerrm);
922: fnd_file.put_line(fnd_file.log, 'Exception - log_dimensions' || sqlerrm);
923: RAISE;
924:
925: END log_dimensions;
926:

Line 1047: fnd_file.put_line(fnd_file.log, 'Exception - log_hierarchies' || sqlerrm);

1043: WHEN OTHERS THEN
1044: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1045: ,p_module => g_block||'.log_hierarchies(PROCEDURE)'
1046: ,p_msg_text => 'EXCEPTION in log_hierarchies ' || sqlerrm);
1047: fnd_file.put_line(fnd_file.log, 'Exception - log_hierarchies' || sqlerrm);
1048: RAISE;
1049: END log_hierarchies;
1050:
1051: ----------------------

Line 1082: fnd_file.put_line(fnd_file.log, 'Exception - main ' || sqlerrm);

1078: WHEN OTHERS THEN
1079: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1080: ,p_module => g_block||'.MAIN'
1081: ,p_msg_text => 'EXCEPTION in MAIN PACKAGE SECTION ' || sqlerrm);
1082: fnd_file.put_line(fnd_file.log, 'Exception - main ' || sqlerrm);
1083: RAISE;
1084:
1085: END Fem_Dim_Hier_Loader_Pkg;