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_DS_WHERE_CLAUSE_GENERATOR dependencies on FEM_ENGINES_PKG

Line 88: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

84: -- HISTORY
85: -- 09-Jan-2004 rjking comment header added, reformatted and commented.
86: --
87: -- *******************************************************************************************
88: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
89: p_module=> l_module_name,
90: p_msg_text=> 'ENTRY');
91:
92: OPEN c1;

Line 96: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

92: OPEN c1;
93: FETCH c1 into l_Table_Classification_Code;
94: CLOSE c1;
95:
96: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
97: p_module=> l_module_name,
98: p_msg_text=> 'EXIT');
99:
100: RETURN l_Table_Classification_Code;

Line 154: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

150: -- HISTORY
151: -- 09-Jan-2004 rjking comment header added, reformatted and commented.
152: --
153: -- *******************************************************************************************
154: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
155: p_module=> l_module_name,
156: p_msg_text=> 'ENTRY');
157:
158: -- look for a match in p_List_B

Line 172: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

168:
169: l_curr_list_b := l_curr_list_b + 1;
170: END LOOP;
171:
172: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
173: p_module=> l_module_name,
174: p_msg_text=> 'EXIT');
175: RETURN l_retval;
176:

Line 238: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

234: -- HISTORY
235: -- 09-Jan-2004 rjking comment header added, reformatted and commented.
236: --
237: -- *******************************************************************************************
238: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
239: p_module=> l_module_name,
240: p_msg_text=> 'ENTRY');
241:
242: p_List_B(p_List_B_Ctr).X_DATASET_CODE := p_Input_Dataset_Code;

Line 246: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

242: p_List_B(p_List_B_Ctr).X_DATASET_CODE := p_Input_Dataset_Code;
243: p_List_B(p_List_B_Ctr).X_CAL_PERIOD_ID := p_Input_Calendar_Period_ID;
244: p_List_B_Ctr := p_List_B_Ctr +1;
245:
246: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
247: p_module=> l_module_name,
248: p_msg_text=> 'EXIT');
249: EXCEPTION
250: WHEN OTHERS THEN

Line 314: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

310: -- HISTORY
311: -- 09-Jan-2004 rjking comment header added, reformatted and commented.
312: --
313: -- *******************************************************************************************
314: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
315: p_module=> l_module_name,
316: p_msg_text=> 'ENTRY');
317: If (p_Missing_Entry_Type = 'DUP_ENTRY') then
318:

Line 356: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

352: := z_No_Eff_Cal_Entries_Ctr + 1;
353:
354: End If;
355:
356: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
357: p_module=> l_module_name,
358: p_msg_text=> 'EXIT');
359:
360: EXCEPTION

Line 421: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

417: -- HISTORY
418: -- 09-Jan-2004 rjking comment header added, reformatted and commented.
419: --
420: -- *******************************************************************************************
421: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
422: p_module=> l_module_name,
423: p_msg_text=> 'ENTRY');
424: OPEN getIODDNameandFolder;
425: FETCH getIODDNameandFolder INTO

Line 433: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

429:
430: p_Dataset_Group_Name := l_IODD_Name;
431: p_Dataset_Group_Folder_Name := l_Folder_Name;
432:
433: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
434: p_module=> l_module_name,
435: p_msg_text=> 'EXIT');
436: EXCEPTION
437: WHEN OTHERS THEN

Line 484: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

480: -- HISTORY
481: -- 09-Jan-2004 rjking comment header added, reformatted and commented.
482: --
483: -- *******************************************************************************************
484: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
485: p_module=> l_module_name,
486: p_msg_text=> 'ENTRY');
487: OPEN getName;
488: Fetch getName into l_Dim_Grp_Name;

Line 492: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

488: Fetch getName into l_Dim_Grp_Name;
489: CLOSE getName;
490:
491:
492: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
493: p_module=> l_module_name,
494: p_msg_text=> 'EXIT');
495: RETURN l_Dim_Grp_Name;
496:

Line 546: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

542: -- HISTORY
543: -- 09-Jan-2004 rjking comment header added, reformatted and commented.
544: --
545: -- *******************************************************************************************
546: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
547: p_module=> l_module_name,
548: p_msg_text=> 'ENTRY');
549: OPEN getName;
550: Fetch getName into l_Dataset_Name;

Line 553: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

549: OPEN getName;
550: Fetch getName into l_Dataset_Name;
551: CLOSE getName;
552:
553: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
554: p_module=> l_module_name,
555: p_msg_text=> 'EXIT');
556:
557: RETURN l_Dataset_Name;

Line 608: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

604: -- HISTORY
605: -- 09-Jan-2004 rjking comment header added, reformatted and commented.
606: --
607: -- *******************************************************************************************
608: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
609: p_module=> l_module_name,
610: p_msg_text=> 'ENTRY');
611: OPEN getName;
612: Fetch getName into l_Cal_Period_Name;

Line 615: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

611: OPEN getName;
612: Fetch getName into l_Cal_Period_Name;
613: CLOSE getName;
614:
615: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
616: p_module=> l_module_name,
617: p_msg_text=> 'EXIT');
618:
619: RETURN l_Cal_Period_Name;

Line 662: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

658: -- HISTORY
659: -- 09-Jan-2004 rjking comment header added, reformatted and commented.
660: --
661: -- *******************************************************************************************
662: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
663: p_module=> l_module_name,
664: p_msg_text=> 'ENTRY');
665: /*--Get Dataset Group Name and Folder Name--*/
666: GetDatasetGroupNameandFolder

Line 725: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

721: || RPAD(z_No_Eff_Cal_Entries_Tab(i).Relative_Cal_Period_Offset,5,' ')
722: );
723: End LOOP;
724:
725: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
726: p_module=> l_module_name,
727: p_msg_text=> 'EXIT');
728: EXCEPTION
729: WHEN OTHERS THEN

Line 826: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

822: -- HISTORY
823: -- 09-Jan-2004 rjking comment header added, reformatted and commented.
824: --
825: -- *******************************************************************************************
826: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
827: p_module=> l_module_name,
828: p_msg_text=> 'ENTRY');
829:
830: ------------------------------------------------

Line 866: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

862: ,l_Rel_Cal_Period_Offset;
863:
864: EXIT WHEN get_Input_List%NOTFOUND;
865:
866: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
867: p_module=> l_module_name,
868: p_msg_text=> '========loop execution==============');
869:
870: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

Line 870: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

866: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
867: p_module=> l_module_name,
868: p_msg_text=> '========loop execution==============');
869:
870: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
871: p_module=> l_module_name,
872: p_msg_text=> 'l_Input_Dataset_Code(' || l_Input_Dataset_Code || ')');
873:
874: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

Line 874: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

870: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
871: p_module=> l_module_name,
872: p_msg_text=> 'l_Input_Dataset_Code(' || l_Input_Dataset_Code || ')');
873:
874: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
875: p_module=> l_module_name,
876: p_msg_text=> 'l_Input_Dataset_Name(' || l_Input_Dataset_Name || ')');
877: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
878: p_module=> l_module_name,

Line 877: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

873:
874: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
875: p_module=> l_module_name,
876: p_msg_text=> 'l_Input_Dataset_Name(' || l_Input_Dataset_Name || ')');
877: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
878: p_module=> l_module_name,
879: p_msg_text=> 'l_Absolute_Cal_Period_Flag(' || l_Absolute_Cal_Period_Flag || ')');
880: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
881: p_module=> l_module_name,

Line 880: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

876: p_msg_text=> 'l_Input_Dataset_Name(' || l_Input_Dataset_Name || ')');
877: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
878: p_module=> l_module_name,
879: p_msg_text=> 'l_Absolute_Cal_Period_Flag(' || l_Absolute_Cal_Period_Flag || ')');
880: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
881: p_module=> l_module_name,
882: p_msg_text=> 'l_Absolute_Cal_Period_ID(' || l_Absolute_Cal_Period_ID || ')');
883: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
884: p_module=> l_module_name,

Line 883: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

879: p_msg_text=> 'l_Absolute_Cal_Period_Flag(' || l_Absolute_Cal_Period_Flag || ')');
880: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
881: p_module=> l_module_name,
882: p_msg_text=> 'l_Absolute_Cal_Period_ID(' || l_Absolute_Cal_Period_ID || ')');
883: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
884: p_module=> l_module_name,
885: p_msg_text=> 'l_Absolute_Cal_Period_Name(' || l_Absolute_Cal_Period_Name || ')');
886: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
887: p_module=> l_module_name,

Line 886: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

882: p_msg_text=> 'l_Absolute_Cal_Period_ID(' || l_Absolute_Cal_Period_ID || ')');
883: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
884: p_module=> l_module_name,
885: p_msg_text=> 'l_Absolute_Cal_Period_Name(' || l_Absolute_Cal_Period_Name || ')');
886: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
887: p_module=> l_module_name,
888: p_msg_text=> 'l_Rel_Dimension_Group_ID(' || l_Rel_Dimension_Group_ID || ')');
889: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
890: p_module=> l_module_name,

Line 889: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

885: p_msg_text=> 'l_Absolute_Cal_Period_Name(' || l_Absolute_Cal_Period_Name || ')');
886: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
887: p_module=> l_module_name,
888: p_msg_text=> 'l_Rel_Dimension_Group_ID(' || l_Rel_Dimension_Group_ID || ')');
889: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
890: p_module=> l_module_name,
891: p_msg_text=> 'l_Rel_Dimension_Group_Name(' || l_Rel_Dimension_Group_Name || ')');
892: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
893: p_module=> l_module_name,

Line 892: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

888: p_msg_text=> 'l_Rel_Dimension_Group_ID(' || l_Rel_Dimension_Group_ID || ')');
889: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
890: p_module=> l_module_name,
891: p_msg_text=> 'l_Rel_Dimension_Group_Name(' || l_Rel_Dimension_Group_Name || ')');
892: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
893: p_module=> l_module_name,
894: p_msg_text=> 'l_Rel_Cal_Period_Offset(' || l_Rel_Cal_Period_Offset || ')');
895:
896:

Line 900: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

896:
897: If (l_Absolute_Cal_Period_Flag = 'Y') then
898: l_Effective_Cal_Period_ID := l_Absolute_Cal_Period_ID;
899: Else
900: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
901: p_module=> l_module_name,
902: p_msg_text=> 'before fem_dimension_util_pkg.Effective_Cal_Period_ID');
903: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
904: p_module=> l_module_name,

Line 903: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

899: Else
900: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
901: p_module=> l_module_name,
902: p_msg_text=> 'before fem_dimension_util_pkg.Effective_Cal_Period_ID');
903: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
904: p_module=> l_module_name,
905: p_msg_text=> 'p_Ledger_ID(' || p_Ledger_ID || ')');
906: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
907: p_module=> l_module_name,

Line 906: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

902: p_msg_text=> 'before fem_dimension_util_pkg.Effective_Cal_Period_ID');
903: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
904: p_module=> l_module_name,
905: p_msg_text=> 'p_Ledger_ID(' || p_Ledger_ID || ')');
906: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
907: p_module=> l_module_name,
908: p_msg_text=> 'p_Output_Period_ID(' || p_Output_Period_ID || ')');
909:
910: l_Effective_Cal_Period_ID :=

Line 919: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,

915: x_msg_data => l_msg_data ,
916: p_per_num_offset => l_Rel_Cal_Period_Offset ,
917: p_base_cal_period_id => p_Output_Period_ID);
918:
919: fem_engines_pkg.tech_message(p_severity=>G_LOG_STATEMENT ,
920: p_module=> l_module_name,
921: p_msg_text=> 'l_Effective_Cal_Period_ID(' || l_Effective_Cal_Period_ID || ')');
922:
923:

Line 1006: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

1002: End If;
1003:
1004: END LOOP;
1005:
1006: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
1007: p_module=> l_module_name,
1008: p_msg_text=> 'EXIT');
1009: EXCEPTION
1010: WHEN OTHERS THEN

Line 1098: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

1094: -- Previous version N/A
1095: -- Initial version 1.0
1096: -- *******************************************************************************************
1097:
1098: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
1099: p_module=> l_module_name,
1100: p_msg_text=> 'ENTRY');
1101: reset_master_err_state;
1102:

Line 1140: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

1136: x_msg_count,
1137: x_msg_data );
1138: END IF;
1139:
1140: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
1141: p_module=> l_module_name,
1142: p_msg_text=> 'EXIT');
1143:
1144:

Line 1275: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

1271: l_msg_count NUMBER;
1272: l_msg_data VARCHAR2(2000);
1273:
1274: BEGIN
1275: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
1276: p_module=> l_module_name,
1277: p_msg_text=> 'ENTRY');
1278: reset_master_err_state;
1279:

Line 1384: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

1380:
1381:
1382: p_where_clause := x_WhereClause;
1383:
1384: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
1385: p_module=> l_module_name,
1386: p_msg_text=> 'EXIT');
1387:
1388: