DBA Data[Home] [Help]

APPS.FEM_DIM_HIER_LOADER_PKG dependencies on FEM_ENGINES_PKG

Line 64: fem_engines_pkg.tech_message (p_severity => g_log_level_2

60: BEGIN
61:
62: fnd_log_repository.init;
63:
64: fem_engines_pkg.tech_message (p_severity => g_log_level_2
65: ,p_module => g_block||'.process_request(PROCEDURE)'
66: ,p_msg_text => 'BEGIN..for process_request');
67:
68: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 68: fem_engines_pkg.tech_message (p_severity => g_log_level_1

64: fem_engines_pkg.tech_message (p_severity => g_log_level_2
65: ,p_module => g_block||'.process_request(PROCEDURE)'
66: ,p_msg_text => 'BEGIN..for process_request');
67:
68: fem_engines_pkg.tech_message (p_severity => g_log_level_1
69: ,p_module => g_block||'.process_request(PARAMETERS)'
70: ,p_msg_text => 'p_obj_def_id :: ' || p_obj_def_id);
71:
72: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 72: fem_engines_pkg.tech_message (p_severity => g_log_level_1

68: fem_engines_pkg.tech_message (p_severity => g_log_level_1
69: ,p_module => g_block||'.process_request(PARAMETERS)'
70: ,p_msg_text => 'p_obj_def_id :: ' || p_obj_def_id);
71:
72: fem_engines_pkg.tech_message (p_severity => g_log_level_1
73: ,p_module => g_block||'.process_request(PROCEDURE)'
74: ,p_msg_text => 'Calling get_parameters');
75:
76: get_parameters(p_obj_def_id);

Line 78: fem_engines_pkg.tech_message (p_severity => g_log_level_1

74: ,p_msg_text => 'Calling get_parameters');
75:
76: get_parameters(p_obj_def_id);
77:
78: fem_engines_pkg.tech_message (p_severity => g_log_level_1
79: ,p_module => g_block||'.process_request(PROCEDURE)'
80: ,p_msg_text => 'Completed get_parameters');
81:
82: fnd_msg_pub.initialize;

Line 85: fem_engines_pkg.tech_message (p_severity => g_log_level_1

81:
82: fnd_msg_pub.initialize;
83:
84: IF g_load_dimensions THEN
85: fem_engines_pkg.tech_message (p_severity => g_log_level_1
86: ,p_module => g_block||'.process_request(PROCEDURE)'
87: ,p_msg_text => 'Calling build_dim_stages');
88:
89:

Line 92: fem_engines_pkg.tech_message (p_severity => g_log_level_1

88:
89:
90: build_dim_stages;
91:
92: fem_engines_pkg.tech_message (p_severity => g_log_level_1
93: ,p_module => g_block||'.process_request(PROCEDURE)'
94: ,p_msg_text => 'Completed build_dim_stages');
95:
96: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 96: fem_engines_pkg.tech_message (p_severity => g_log_level_1

92: fem_engines_pkg.tech_message (p_severity => g_log_level_1
93: ,p_module => g_block||'.process_request(PROCEDURE)'
94: ,p_msg_text => 'Completed build_dim_stages');
95:
96: fem_engines_pkg.tech_message (p_severity => g_log_level_1
97: ,p_module => g_block||'.process_request(PROCEDURE)'
98: ,p_msg_text => 'Calling log_dimensions');
99:
100: log_dimensions;

Line 102: fem_engines_pkg.tech_message (p_severity => g_log_level_1

98: ,p_msg_text => 'Calling log_dimensions');
99:
100: log_dimensions;
101:
102: fem_engines_pkg.tech_message (p_severity => g_log_level_1
103: ,p_module => g_block||'.process_request(PROCEDURE)'
104: ,p_msg_text => 'Completed log_dimensions');
105:
106: END IF;

Line 109: fem_engines_pkg.tech_message (p_severity => g_log_level_1

105:
106: END IF;
107:
108: IF g_load_hierarchies THEN
109: fem_engines_pkg.tech_message (p_severity => g_log_level_1
110: ,p_module => g_block||'.process_request(PROCEDURE)'
111: ,p_msg_text => 'Calling build_hier_stages');
112:
113: build_hier_stages;

Line 115: fem_engines_pkg.tech_message (p_severity => g_log_level_1

111: ,p_msg_text => 'Calling build_hier_stages');
112:
113: build_hier_stages;
114:
115: fem_engines_pkg.tech_message (p_severity => g_log_level_1
116: ,p_module => g_block||'.process_request(PROCEDURE)'
117: ,p_msg_text => 'Completed build_hier_stages');
118:
119: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 119: fem_engines_pkg.tech_message (p_severity => g_log_level_1

115: fem_engines_pkg.tech_message (p_severity => g_log_level_1
116: ,p_module => g_block||'.process_request(PROCEDURE)'
117: ,p_msg_text => 'Completed build_hier_stages');
118:
119: fem_engines_pkg.tech_message (p_severity => g_log_level_1
120: ,p_module => g_block||'.process_request(PROCEDURE)'
121: ,p_msg_text => 'Calling log_hierarchies');
122:
123:

Line 126: fem_engines_pkg.tech_message (p_severity => g_log_level_1

122:
123:
124: log_hierarchies;
125:
126: fem_engines_pkg.tech_message (p_severity => g_log_level_1
127: ,p_module => g_block||'.process_request(PROCEDURE)'
128: ,p_msg_text => 'Completed log_hierarchies');
129:
130: END IF;

Line 138: fem_engines_pkg.tech_message (p_severity => g_log_level_1

134: END IF;
135:
136: print_params;
137:
138: fem_engines_pkg.tech_message (p_severity => g_log_level_1
139: ,p_module => g_block||'.process_request(PROCEDURE)'
140: ,p_msg_text => 'Calling cleanup');
141:
142: cleanup;

Line 144: fem_engines_pkg.tech_message (p_severity => g_log_level_1

140: ,p_msg_text => 'Calling cleanup');
141:
142: cleanup;
143:
144: fem_engines_pkg.tech_message (p_severity => g_log_level_1
145: ,p_module => g_block||'.process_request(PROCEDURE)'
146: ,p_msg_text => 'Completed cleanup');
147:
148:

Line 149: fem_engines_pkg.tech_message (p_severity => g_log_level_2

145: ,p_module => g_block||'.process_request(PROCEDURE)'
146: ,p_msg_text => 'Completed cleanup');
147:
148:
149: fem_engines_pkg.tech_message (p_severity => g_log_level_2
150: ,p_module => g_block||'.process_request(PROCEDURE)'
151: ,p_msg_text => 'END process_request');
152:
153: EXCEPTION

Line 155: fem_engines_pkg.tech_message (p_severity => g_log_level_6

151: ,p_msg_text => 'END process_request');
152:
153: EXCEPTION
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;

Line 182: fem_engines_pkg.tech_message (p_severity => g_log_level_2

178: PROCEDURE cleanup IS
179:
180: BEGIN
181:
182: fem_engines_pkg.tech_message (p_severity => g_log_level_2
183: ,p_module => g_block||'.cleanup(PROCEDURE)'
184: ,p_msg_text => 'BEGIN..for cleanup ');
185:
186: gs_dim_id_tab.DELETE;

Line 196: fem_engines_pkg.tech_message (p_severity => g_log_level_2

192: DELETE fem_ld_dim_requests_gt;
193:
194: DELETE fem_ld_hier_requests_gt;
195:
196: fem_engines_pkg.tech_message (p_severity => g_log_level_2
197: ,p_module => g_block||'.cleanup(PROCEDURE)'
198: ,p_msg_text => 'END cleanup ');
199:
200:

Line 219: fem_engines_pkg.tech_message (p_severity => g_log_level_2

215: PROCEDURE get_parameters(p_obj_def_id IN NUMBER) IS
216: dim_loader_rule_error EXCEPTION;
217: BEGIN
218:
219: fem_engines_pkg.tech_message (p_severity => g_log_level_2
220: ,p_module => g_block||'.get_parameters(PROCEDURE)'
221: ,p_msg_text => 'BEGIN..for get_parameters ');
222:
223:

Line 237: fem_engines_pkg.tech_message (p_severity => g_log_level_6

233: EXCEPTION
234: WHEN NO_DATA_FOUND THEN
235: NULL; -- Dimension page not populated
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;

Line 267: fem_engines_pkg.tech_message (p_severity => g_log_level_6

263: EXCEPTION
264: WHEN NO_DATA_FOUND THEN
265: NULL; -- Hierarchy page not populated
266: WHEN OTHERS THEN
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');

Line 279: fem_engines_pkg.tech_message (p_severity => g_log_level_2

275: IF gs_hier_obj_id_tab.COUNT > 0.0 THEN
276: g_load_hierarchies := TRUE;
277: END IF;
278:
279: fem_engines_pkg.tech_message (p_severity => g_log_level_2
280: ,p_module => g_block||'.get_parameters(PROCEDURE)'
281: ,p_msg_text => 'END get_parameters ');
282:
283:

Line 314: fem_engines_pkg.tech_message (p_severity => g_log_level_2

310: l_err_buff VARCHAR2(1000);
311: l_compl_status BOOLEAN;
312: BEGIN
313:
314: fem_engines_pkg.tech_message (p_severity => g_log_level_2
315: ,p_module => g_block||'.wait_for_requests(PROCEDURE)'
316: ,p_msg_text => 'BEGIN..for wait_for_requests ');
317:
318: CASE p_wait_for

Line 379: fem_engines_pkg.tech_message (p_severity => g_log_level_2

375: END LOOP; -- dim_rec
376:
377: END CASE; -- p_wait_for
378:
379: fem_engines_pkg.tech_message (p_severity => g_log_level_2
380: ,p_module => g_block||'.wait_for_requests(PROCEDURE)'
381: ,p_msg_text => 'END wait_for_requests ');
382:
383: EXCEPTION

Line 385: fem_engines_pkg.tech_message (p_severity => g_log_level_6

381: ,p_msg_text => 'END wait_for_requests ');
382:
383: EXCEPTION
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;

Line 422: fem_engines_pkg.tech_message (p_severity => g_log_level_2

418: l_compl_status BOOLEAN;
419:
420: BEGIN
421:
422: fem_engines_pkg.tech_message (p_severity => g_log_level_2
423: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
424: ,p_msg_text => 'BEGIN..for submit_dimension_loaders');
425:
426:

Line 440: fem_engines_pkg.tech_message (p_severity => g_log_level_6

436: EXCEPTION
437: WHEN NO_DATA_FOUND THEN
438: l_dummy := 0.0;
439: WHEN OTHERS THEN
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 ');

Line 486: fem_engines_pkg.tech_message (p_severity => g_log_level_1

482:
483: END LOOP;
484:
485: IF l_at_least_one THEN
486: fem_engines_pkg.tech_message (p_severity => g_log_level_1
487: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
488: ,p_msg_text => 'Calling wait_for_requests - DIMENSION');
489:
490: wait_for_requests(c_dim_loader);

Line 492: fem_engines_pkg.tech_message (p_severity => g_log_level_1

488: ,p_msg_text => 'Calling wait_for_requests - DIMENSION');
489:
490: wait_for_requests(c_dim_loader);
491:
492: fem_engines_pkg.tech_message (p_severity => g_log_level_1
493: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
494: ,p_msg_text => 'Completed wait_for_requests - DIMENSION');
495: END IF;
496:

Line 497: fem_engines_pkg.tech_message (p_severity => g_log_level_2

493: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
494: ,p_msg_text => 'Completed wait_for_requests - DIMENSION');
495: END IF;
496:
497: fem_engines_pkg.tech_message (p_severity => g_log_level_2
498: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
499: ,p_msg_text => 'END submit_dimension_loaders');
500:
501: EXCEPTION

Line 503: fem_engines_pkg.tech_message (p_severity => g_log_level_6

499: ,p_msg_text => 'END submit_dimension_loaders');
500:
501: EXCEPTION
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;

Line 538: fem_engines_pkg.tech_message (p_severity => g_log_level_2

534: l_at_least_one BOOLEAN;
535:
536: BEGIN
537:
538: fem_engines_pkg.tech_message (p_severity => g_log_level_2
539: ,p_module => g_block||'.submit_hierarchy_loader(PROCEDURE)'
540: ,p_msg_text => 'BEGIN..for submit_hierarchy_loader');
541:
542: l_at_least_one := FALSE;

Line 587: fem_engines_pkg.tech_message (p_severity => g_log_level_1

583:
584: END LOOP;
585:
586: IF l_at_least_one THEN
587: fem_engines_pkg.tech_message (p_severity => g_log_level_1
588: ,p_module => g_block||'.submit_hierarchy_loaders(PROCEDURE)'
589: ,p_msg_text => 'Calling wait_for_requests - HIERARCHY');
590:
591: wait_for_requests(c_hier_loader);

Line 593: fem_engines_pkg.tech_message (p_severity => g_log_level_1

589: ,p_msg_text => 'Calling wait_for_requests - HIERARCHY');
590:
591: wait_for_requests(c_hier_loader);
592:
593: fem_engines_pkg.tech_message (p_severity => g_log_level_1
594: ,p_module => g_block||'.submit_hierarchy_loaders(PROCEDURE)'
595: ,p_msg_text => 'Completed wait_for_requests - HIERARCHY');
596: END IF;
597:

Line 598: fem_engines_pkg.tech_message (p_severity => g_log_level_2

594: ,p_module => g_block||'.submit_hierarchy_loaders(PROCEDURE)'
595: ,p_msg_text => 'Completed wait_for_requests - HIERARCHY');
596: END IF;
597:
598: fem_engines_pkg.tech_message (p_severity => g_log_level_2
599: ,p_module => g_block||'.submit_hierarchy_loader(PROCEDURE)'
600: ,p_msg_text => 'END submit_hierarchy_loader');
601:
602:

Line 605: fem_engines_pkg.tech_message (p_severity => g_log_level_6

601:
602:
603: EXCEPTION
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;

Line 627: fem_engines_pkg.tech_message (p_severity => g_log_level_2

623:
624: PROCEDURE build_dim_stages IS
625: BEGIN
626:
627: fem_engines_pkg.tech_message (p_severity => g_log_level_2
628: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
629: ,p_msg_text => 'BEGIN..for build_dim_stages');
630:
631:

Line 654: fem_engines_pkg.tech_message (p_severity => g_log_level_2

650: UPDATE fem_ld_dim_requests_gt
651: SET request_id = -10000;
652: END IF;
653:
654: fem_engines_pkg.tech_message (p_severity => g_log_level_2
655: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
656: ,p_msg_text => 'END build_dim_stages');
657:
658:

Line 661: fem_engines_pkg.tech_message (p_severity => g_log_level_6

657:
658:
659: EXCEPTION
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;

Line 698: fem_engines_pkg.tech_message (p_severity => g_log_level_6

694: AND d.old_approved_copy_flag = 'N'
695: AND d.approval_status_code NOT IN ('SUBMIT_DELETE','SUBMIT_APPROVAL');
696: EXCEPTION
697: WHEN OTHERS THEN
698: fem_engines_pkg.tech_message (p_severity => g_log_level_6
699: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
700: ,p_msg_text => 'EXCEPTION in build_dim_stages -
701: fetching object_def_id for HIER');
702: fem_data_loader_pkg.trace('Error in build dim stages while building HIER'); RAISE;

Line 786: fem_engines_pkg.tech_message (p_severity => g_log_level_1

782: FROM fem_ld_hier_requests_gt
783: WHERE ROWNUM = 1;
784:
785: IF l_hier_count > 0.0 THEN
786: fem_engines_pkg.tech_message (p_severity => g_log_level_1
787: ,p_module => g_block||'.build_hier_stages(PROCEDURE)'
788: ,p_msg_text => 'Calling submit_hierarchy_loaders');
789:
790: submit_hierarchy_loaders;

Line 792: fem_engines_pkg.tech_message (p_severity => g_log_level_1

788: ,p_msg_text => 'Calling submit_hierarchy_loaders');
789:
790: submit_hierarchy_loaders;
791:
792: fem_engines_pkg.tech_message (p_severity => g_log_level_1
793: ,p_module => g_block||'.build_hier_stages(PROCEDURE)'
794: ,p_msg_text => 'Calling submit_hierarchy_loaders');
795:
796: END IF;

Line 798: fem_engines_pkg.tech_message (p_severity => g_log_level_2

794: ,p_msg_text => 'Calling submit_hierarchy_loaders');
795:
796: END IF;
797:
798: fem_engines_pkg.tech_message (p_severity => g_log_level_2
799: ,p_module => g_block||'.build_hier_stages(PROCEDURE)'
800: ,p_msg_text => 'END build_hier_stages');
801:
802:

Line 805: fem_engines_pkg.tech_message (p_severity => g_log_level_6

801:
802:
803: EXCEPTION
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;

Line 877: fem_engines_pkg.tech_message (p_severity => g_log_level_2

873: PROCEDURE log_dimensions IS
874:
875: BEGIN
876:
877: fem_engines_pkg.tech_message (p_severity => g_log_level_2
878: ,p_module => g_block||'.log_dimensions(PROCEDURE)'
879: ,p_msg_text => 'BEGIN..for log_dimensions');
880:
881:

Line 913: fem_engines_pkg.tech_message (p_severity => g_log_level_2

909: END LOOP; -- dim_rec
910:
911: fem_data_loader_pkg.trace('SEPARATOR');
912:
913: fem_engines_pkg.tech_message (p_severity => g_log_level_2
914: ,p_module => g_block||'.log_dimensions(PROCEDURE)'
915: ,p_msg_text => 'END log_dimensions');
916:
917: EXCEPTION

Line 919: fem_engines_pkg.tech_message (p_severity => g_log_level_6

915: ,p_msg_text => 'END log_dimensions');
916:
917: EXCEPTION
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;

Line 950: fem_engines_pkg.tech_message (p_severity => g_log_level_2

946: l_lang VARCHAR2(100);
947:
948: BEGIN
949:
950: fem_engines_pkg.tech_message (p_severity => g_log_level_2
951: ,p_module => g_block||'.log_hierarchies(PROCEDURE)'
952: ,p_msg_text => 'BEGIN..for log_hierarchies');
953:
954: fem_data_loader_pkg.trace('SEPARATOR');

Line 1037: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1033: END LOOP; -- 1..gs_table_row_tab
1034:
1035: fem_data_loader_pkg.trace('SEPARATOR');
1036:
1037: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1038: ,p_module => g_block||'.log_hierarchies(PROCEDURE)'
1039: ,p_msg_text => 'END log_hierarchies');
1040:
1041:

Line 1044: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1040:
1041:
1042: EXCEPTION
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;

Line 1057: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1053: ----------------------
1054:
1055: BEGIN
1056:
1057: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1058: ,p_module => g_block||'.MAIN - start'
1059: ,p_msg_text => 'BEGIN MAIN PACKAGE SECTION');
1060:
1061: g_load_dimensions := FALSE;

Line 1072: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1068: DELETE fem_ld_dim_requests_gt;
1069:
1070: DELETE fem_ld_hier_requests_gt;
1071:
1072: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1073: ,p_module => g_block||'.MAIN - end'
1074: ,p_msg_text => 'END MAIN PACKAGE SECTION');
1075:
1076:

Line 1079: fem_engines_pkg.tech_message (p_severity => g_log_level_6

1075:
1076:
1077: EXCEPTION
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;