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_RULE_SET_MANAGER dependencies on FND_FILE

Line 734: -- Function : Log dependent object status to the fnd_file output file.

730: l_module_name VARCHAR2(70) := G_MODULE_NAME || 'Log_Dependent_Object_Status';
731: Begin
732: -- *******************************************************************************************
733: -- name : Log_Dependent_Object_Status
734: -- Function : Log dependent object status to the fnd_file output file.
735: -- ?? this may be where we output invalid rules found in rulesets rjk ??
736: -- Parameters
737: -- IN
738: -- p_Parent_Object_ID

Line 763: fnd_file.put_line(FND_FILE.OUTPUT,

759:
760: For i in 0..p_Dependent_Objects_Count-1 LOOP
761: if (p_Dependent_Objects_Tab(i).Parent_Object_ID = p_Parent_Object_ID) then
762:
763: fnd_file.put_line(FND_FILE.OUTPUT,
764: '=>'
765: || RPAD(p_Dependent_Objects_Tab(i).Dependent_Object_Display_Name,40,' ')
766: || RPAD(p_Dependent_Objects_Tab(i).Dependent_Object_Type_Code,32,' ')
767: || RPAD(p_Dependent_Objects_Tab(i).Dependent_Object_Folder_Name,32,' ')

Line 792: -- Function : Log dependent object status to the fnd_file output file.

788: l_module_name VARCHAR2(70) := G_MODULE_NAME || 'Log_Dep_Status_For_Single_Rule';
789: Begin
790: -- *******************************************************************************************
791: -- name : Log_Dep_Status_For_Single_Rule
792: -- Function : Log dependent object status to the fnd_file output file.
793: -- ?? this may be where we output invalid rules found in rulesets rjk ??
794: -- Parameters
795: -- IN
796: -- p_Parent_Object_ID

Line 820: fnd_file.put_line(FND_FILE.OUTPUT,

816: -- implemented as linear search
817: For i in 0..p_Dependent_Objects_Count-1 LOOP
818: if (p_Dependent_Objects_Tab(i).Parent_Object_ID = p_Parent_Object_ID) then
819:
820: fnd_file.put_line(FND_FILE.OUTPUT,
821: '=>'
822: || RPAD(p_Dependent_Objects_Tab(i).Dependent_Object_Display_Name,40,' ')
823: || RPAD(p_Dependent_Objects_Tab(i).Dependent_Object_Folder_Name,32,' ')
824: || RPAD(G_RSM_NO_VALID_DEFN,32,' ')

Line 879: fnd_file.put_line(FND_FILE.OUTPUT,

875: p_msg_text=> 'ENTRY');
876:
877: For i in 0..p_Flagged_Members_Count -1 LOOP
878:
879: fnd_file.put_line(FND_FILE.OUTPUT,
880: RPAD(p_Flagged_Members_Tab(i).Object_Name,42,' ')
881: || RPAD(p_Flagged_Members_Tab(i).Object_Type,32,' ')
882: || RPAD(p_Flagged_Members_Tab(i).Folder_Name,32,' ')
883: || RPAD(p_Flagged_Members_Tab(i).Owning_RuleSet_Name,42,' ')

Line 948: fnd_file.put_line(FND_FILE.OUTPUT,

944: p_msg_text=> 'ENTRY');
945:
946:
947: For i in 0..p_Valid_Invalid_Members_Count-1 LOOP
948: fnd_file.put_line(FND_FILE.OUTPUT,
949: RPAD(p_Valid_Invalid_Members_Tab(i).Object_Name,40,' ')
950: || RPAD(p_Valid_Invalid_Members_Tab(i).Object_Type,30,' ')
951: || RPAD(p_Valid_Invalid_Members_Tab(i).Folder_Name,30,' ')
952: || RPAD(p_Valid_Invalid_Members_Tab(i).Owning_RuleSet_Name,40,' ')

Line 994: -- Function : write a report to the fnd_file output file.

990: l_IsProductionODSstr VARCHAR2(6) := NULL;
991: Begin
992: -- *******************************************************************************************
993: -- name : Write_Output
994: -- Function : write a report to the fnd_file output file.
995: --
996: -- Parameters
997: -- IN
998: --

Line 1013: fnd_file.put_line(FND_FILE.OUTPUT,'Procedure Name : Fem_Rule_Set_Manager.Preprocess_RuleSet');

1009: p_module=> l_module_name,
1010: p_msg_text=> 'ENTRY');
1011:
1012:
1013: fnd_file.put_line(FND_FILE.OUTPUT,'Procedure Name : Fem_Rule_Set_Manager.Preprocess_RuleSet');
1014: fnd_file.put_line(FND_FILE.OUTPUT,'Package Version');
1015: fnd_file.put_line(FND_FILE.OUTPUT,' : '||getProcedureVersionFromDB);
1016: fnd_file.put_line(FND_FILE.OUTPUT,'Run Date : '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
1017: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------');

Line 1014: fnd_file.put_line(FND_FILE.OUTPUT,'Package Version');

1010: p_msg_text=> 'ENTRY');
1011:
1012:
1013: fnd_file.put_line(FND_FILE.OUTPUT,'Procedure Name : Fem_Rule_Set_Manager.Preprocess_RuleSet');
1014: fnd_file.put_line(FND_FILE.OUTPUT,'Package Version');
1015: fnd_file.put_line(FND_FILE.OUTPUT,' : '||getProcedureVersionFromDB);
1016: fnd_file.put_line(FND_FILE.OUTPUT,'Run Date : '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
1017: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------');
1018:

Line 1015: fnd_file.put_line(FND_FILE.OUTPUT,' : '||getProcedureVersionFromDB);

1011:
1012:
1013: fnd_file.put_line(FND_FILE.OUTPUT,'Procedure Name : Fem_Rule_Set_Manager.Preprocess_RuleSet');
1014: fnd_file.put_line(FND_FILE.OUTPUT,'Package Version');
1015: fnd_file.put_line(FND_FILE.OUTPUT,' : '||getProcedureVersionFromDB);
1016: fnd_file.put_line(FND_FILE.OUTPUT,'Run Date : '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
1017: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------');
1018:
1019: fnd_file.put_line(FND_FILE.OUTPUT

Line 1016: fnd_file.put_line(FND_FILE.OUTPUT,'Run Date : '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));

1012:
1013: fnd_file.put_line(FND_FILE.OUTPUT,'Procedure Name : Fem_Rule_Set_Manager.Preprocess_RuleSet');
1014: fnd_file.put_line(FND_FILE.OUTPUT,'Package Version');
1015: fnd_file.put_line(FND_FILE.OUTPUT,' : '||getProcedureVersionFromDB);
1016: fnd_file.put_line(FND_FILE.OUTPUT,'Run Date : '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
1017: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------');
1018:
1019: fnd_file.put_line(FND_FILE.OUTPUT
1020: ,'Rule Set being validated : '||GetObjectDisplayName(p_Orig_RuleSet_Object_ID));

Line 1017: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------');

1013: fnd_file.put_line(FND_FILE.OUTPUT,'Procedure Name : Fem_Rule_Set_Manager.Preprocess_RuleSet');
1014: fnd_file.put_line(FND_FILE.OUTPUT,'Package Version');
1015: fnd_file.put_line(FND_FILE.OUTPUT,' : '||getProcedureVersionFromDB);
1016: fnd_file.put_line(FND_FILE.OUTPUT,'Run Date : '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
1017: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------');
1018:
1019: fnd_file.put_line(FND_FILE.OUTPUT
1020: ,'Rule Set being validated : '||GetObjectDisplayName(p_Orig_RuleSet_Object_ID));
1021:

Line 1019: fnd_file.put_line(FND_FILE.OUTPUT

1015: fnd_file.put_line(FND_FILE.OUTPUT,' : '||getProcedureVersionFromDB);
1016: fnd_file.put_line(FND_FILE.OUTPUT,'Run Date : '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
1017: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------');
1018:
1019: fnd_file.put_line(FND_FILE.OUTPUT
1020: ,'Rule Set being validated : '||GetObjectDisplayName(p_Orig_RuleSet_Object_ID));
1021:
1022: fnd_file.put_line(FND_FILE.OUTPUT
1023: ,'Rule Effective Date : '||p_Rule_Effective_Date);

Line 1022: fnd_file.put_line(FND_FILE.OUTPUT

1018:
1019: fnd_file.put_line(FND_FILE.OUTPUT
1020: ,'Rule Set being validated : '||GetObjectDisplayName(p_Orig_RuleSet_Object_ID));
1021:
1022: fnd_file.put_line(FND_FILE.OUTPUT
1023: ,'Rule Effective Date : '||p_Rule_Effective_Date);
1024:
1025: fnd_file.put_line(FND_FILE.OUTPUT
1026: ,'Output Dataset : '||p_Output_Dataset_Name);

Line 1025: fnd_file.put_line(FND_FILE.OUTPUT

1021:
1022: fnd_file.put_line(FND_FILE.OUTPUT
1023: ,'Rule Effective Date : '||p_Rule_Effective_Date);
1024:
1025: fnd_file.put_line(FND_FILE.OUTPUT
1026: ,'Output Dataset : '||p_Output_Dataset_Name);
1027:
1028: IF p_IsProductionODS THEN
1029: l_IsProductionODSstr := 'Y';

Line 1034: fnd_file.put_line(FND_FILE.OUTPUT

1030: ELSE
1031: l_IsProductionODSstr := 'N';
1032: END IF;
1033:
1034: fnd_file.put_line(FND_FILE.OUTPUT
1035: ,'Is Output Dataset Production: '||l_IsProductionODSstr);
1036:
1037: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------');
1038:

Line 1037: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------');

1033:
1034: fnd_file.put_line(FND_FILE.OUTPUT
1035: ,'Is Output Dataset Production: '||l_IsProductionODSstr);
1036:
1037: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------');
1038:
1039: If (NOT z_dataset_error) then
1040:
1041: --***********************************************************************

Line 1049: fnd_file.put_line(FND_FILE.OUTPUT,' ');

1045: -- I=Invalid Rules (report on invalid rules only)
1046: -- V=Valid Rules (report on valid rules only)
1047: --***********************************************************************
1048: If (p_Execution_Mode = 'V' OR p_Execution_Mode = 'A' OR p_Execution_Mode = 'E') then
1049: fnd_file.put_line(FND_FILE.OUTPUT,' ');
1050: fnd_file.put_line(FND_FILE.OUTPUT,'Valid Rules/Rule Sets');
1051: fnd_file.put_line(FND_FILE.OUTPUT,'=====================');
1052: fnd_file.put_line(FND_FILE.OUTPUT,
1053: RPAD('Rule Name',40,' ')

Line 1050: fnd_file.put_line(FND_FILE.OUTPUT,'Valid Rules/Rule Sets');

1046: -- V=Valid Rules (report on valid rules only)
1047: --***********************************************************************
1048: If (p_Execution_Mode = 'V' OR p_Execution_Mode = 'A' OR p_Execution_Mode = 'E') then
1049: fnd_file.put_line(FND_FILE.OUTPUT,' ');
1050: fnd_file.put_line(FND_FILE.OUTPUT,'Valid Rules/Rule Sets');
1051: fnd_file.put_line(FND_FILE.OUTPUT,'=====================');
1052: fnd_file.put_line(FND_FILE.OUTPUT,
1053: RPAD('Rule Name',40,' ')
1054: || RPAD('Type',30,' ')

Line 1051: fnd_file.put_line(FND_FILE.OUTPUT,'=====================');

1047: --***********************************************************************
1048: If (p_Execution_Mode = 'V' OR p_Execution_Mode = 'A' OR p_Execution_Mode = 'E') then
1049: fnd_file.put_line(FND_FILE.OUTPUT,' ');
1050: fnd_file.put_line(FND_FILE.OUTPUT,'Valid Rules/Rule Sets');
1051: fnd_file.put_line(FND_FILE.OUTPUT,'=====================');
1052: fnd_file.put_line(FND_FILE.OUTPUT,
1053: RPAD('Rule Name',40,' ')
1054: || RPAD('Type',30,' ')
1055: || RPAD('Folder',30,' ')

Line 1052: fnd_file.put_line(FND_FILE.OUTPUT,

1048: If (p_Execution_Mode = 'V' OR p_Execution_Mode = 'A' OR p_Execution_Mode = 'E') then
1049: fnd_file.put_line(FND_FILE.OUTPUT,' ');
1050: fnd_file.put_line(FND_FILE.OUTPUT,'Valid Rules/Rule Sets');
1051: fnd_file.put_line(FND_FILE.OUTPUT,'=====================');
1052: fnd_file.put_line(FND_FILE.OUTPUT,
1053: RPAD('Rule Name',40,' ')
1054: || RPAD('Type',30,' ')
1055: || RPAD('Folder',30,' ')
1056: || RPAD('Owning RuleSet',40,' ')

Line 1059: fnd_file.put_line(FND_FILE.OUTPUT,

1055: || RPAD('Folder',30,' ')
1056: || RPAD('Owning RuleSet',40,' ')
1057: || RPAD('Status',12,' ')
1058: );
1059: fnd_file.put_line(FND_FILE.OUTPUT,
1060: RPAD('---------',40,' ')
1061: || RPAD('----',30,' ')
1062: || RPAD('------',30,' ')
1063: || RPAD('--------------',40,' ')

Line 1087: fnd_file.put_line(FND_FILE.OUTPUT,' ');

1083: --***********************************************************************
1084: If ( p_Execution_Mode = 'I'
1085: OR p_Execution_Mode = 'A'
1086: OR p_Execution_Mode = 'E') then
1087: fnd_file.put_line(FND_FILE.OUTPUT,' ');
1088: fnd_file.put_line(FND_FILE.OUTPUT,'Invalid Rules/Rule Sets');
1089: fnd_file.put_line(FND_FILE.OUTPUT,'=======================');
1090:
1091: fnd_file.put_line(FND_FILE.OUTPUT,

Line 1088: fnd_file.put_line(FND_FILE.OUTPUT,'Invalid Rules/Rule Sets');

1084: If ( p_Execution_Mode = 'I'
1085: OR p_Execution_Mode = 'A'
1086: OR p_Execution_Mode = 'E') then
1087: fnd_file.put_line(FND_FILE.OUTPUT,' ');
1088: fnd_file.put_line(FND_FILE.OUTPUT,'Invalid Rules/Rule Sets');
1089: fnd_file.put_line(FND_FILE.OUTPUT,'=======================');
1090:
1091: fnd_file.put_line(FND_FILE.OUTPUT,
1092: RPAD('Rule Name',42,' ')

Line 1089: fnd_file.put_line(FND_FILE.OUTPUT,'=======================');

1085: OR p_Execution_Mode = 'A'
1086: OR p_Execution_Mode = 'E') then
1087: fnd_file.put_line(FND_FILE.OUTPUT,' ');
1088: fnd_file.put_line(FND_FILE.OUTPUT,'Invalid Rules/Rule Sets');
1089: fnd_file.put_line(FND_FILE.OUTPUT,'=======================');
1090:
1091: fnd_file.put_line(FND_FILE.OUTPUT,
1092: RPAD('Rule Name',42,' ')
1093: || RPAD('Type',32,' ')

Line 1091: fnd_file.put_line(FND_FILE.OUTPUT,

1087: fnd_file.put_line(FND_FILE.OUTPUT,' ');
1088: fnd_file.put_line(FND_FILE.OUTPUT,'Invalid Rules/Rule Sets');
1089: fnd_file.put_line(FND_FILE.OUTPUT,'=======================');
1090:
1091: fnd_file.put_line(FND_FILE.OUTPUT,
1092: RPAD('Rule Name',42,' ')
1093: || RPAD('Type',32,' ')
1094: || RPAD('Folder',32,' ')
1095: || RPAD('Owning RuleSet',42,' ')

Line 1105: fnd_file.put_line(FND_FILE.OUTPUT,

1101: || RPAD('Approval Status',17,' ')
1102: || RPAD('Dependent Status',18,' ')
1103: );
1104:
1105: fnd_file.put_line(FND_FILE.OUTPUT,
1106: RPAD('---------',42,' ')
1107: || RPAD('----',32,' ')
1108: || RPAD('------',32,' ')
1109: || RPAD('--------------',42,' ')

Line 1128: fnd_file.put_line(FND_FILE.OUTPUT,' ');

1124: End If;
1125:
1126: End If;
1127:
1128: fnd_file.put_line(FND_FILE.OUTPUT,' ');
1129: fnd_file.put_line(FND_FILE.OUTPUT,' -----------------End of Report-----------------');
1130:
1131: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
1132: p_module=> l_module_name,

Line 1129: fnd_file.put_line(FND_FILE.OUTPUT,' -----------------End of Report-----------------');

1125:
1126: End If;
1127:
1128: fnd_file.put_line(FND_FILE.OUTPUT,' ');
1129: fnd_file.put_line(FND_FILE.OUTPUT,' -----------------End of Report-----------------');
1130:
1131: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,
1132: p_module=> l_module_name,
1133: p_msg_text=> 'EXIT');

Line 1449: --fnd_file.put_line(fnd_file.LOG,'Inserting row :'||GetObjectDisplayName(p_Child_Object_ID)||':'||p_RuleSet_Object_ID||':'||z_conc_request_id||':'||p_Child_Object_Definition_ID);

1445: p_msg_text=> 'ENTRY');
1446:
1447: z_global_counter := z_global_counter+1;
1448: --Bug # 4283689
1449: --fnd_file.put_line(fnd_file.LOG,'Inserting row :'||GetObjectDisplayName(p_Child_Object_ID)||':'||p_RuleSet_Object_ID||':'||z_conc_request_id||':'||p_Child_Object_Definition_ID);
1450:
1451: insert into fem_ruleset_process_data
1452: (RULE_SET_OBJ_ID
1453: ,CHILD_OBJ_ID

Line 2570: -- fnd_file.put_line(FND_FILE.LOG,'Error Code after internal Process Rule Set call is : '||z_Err_Code);

2566: ,p_Ledger_ID
2567: ,l_Maximum_Sequence
2568: ,l_curr_RS );
2569:
2570: -- fnd_file.put_line(FND_FILE.LOG,'Error Code after internal Process Rule Set call is : '||z_Err_Code);
2571:
2572: -- capture error state and react accordingly
2573: If (z_master_err_state = FEM_UTILS.G_RSM_FATAL_ERR ) THEN
2574: -- this is a backstop err capture routine.. we (hopefully) should never get here..

Line 2728: fnd_file.put_line(FND_FILE.OUTPUT

2724: GetObjectDisplayNameandFolder(p_Rule_Object_ID
2725: ,l_Rule_Display_Name
2726: ,l_Rule_Folder_Name);
2727:
2728: fnd_file.put_line(FND_FILE.OUTPUT
2729: ,RPAD('Rule Name',42,' ')
2730: ||RPAD('Folder',32,' ')
2731: ||RPAD('Rule Def',32,' ')
2732: ||RPAD('Lock Status',13,' ')

Line 2738: fnd_file.put_line(FND_FILE.OUTPUT

2734: ||RPAD('Approval Status',17,' ')
2735: ||RPAD('Dependent Status',18,' ')
2736: );
2737:
2738: fnd_file.put_line(FND_FILE.OUTPUT
2739: ,RPAD('---------',42,' ')
2740: ||RPAD('------',32,' ')
2741: ||RPAD('---------------------',32,' ')
2742: ||RPAD('-----------',13,' ')

Line 2748: fnd_file.put_line(FND_FILE.OUTPUT

2744: ||RPAD('---------------',17,' ')
2745: ||RPAD('----------------',18,' ')
2746: );
2747:
2748: fnd_file.put_line(FND_FILE.OUTPUT
2749: ,RPAD(l_Rule_Display_Name,42,' ')
2750: ||RPAD(l_Rule_Folder_Name,32,' ')
2751: ||RPAD(p_Valid_Rule_Def_Status,32,' ')
2752: ||RPAD(p_Valid_Lock_Status,13,' ')

Line 2948: fnd_file.put_line(FND_FILE.OUTPUT,z_Err_Msg);

2944: x_Err_Msg := z_Err_Msg;
2945: -- todo:: fix to new standards
2946: fem_engines_pkg.user_message(p_msg_text =>
2947: z_Err_Code||':'||z_Err_Msg);
2948: fnd_file.put_line(FND_FILE.OUTPUT,z_Err_Msg);
2949: ROLLBACK TO Validate_Rule_Public_SvPt;
2950: WHEN OTHERS THEN
2951: x_Err_Code := -1;
2952: -- todo:: this is a main I/F procedure and should conform to the 'new way of thinking'.

Line 3223: fnd_file.put_line(FND_FILE.OUTPUT,z_Err_Code||':'||z_Err_Msg);

3219: WHEN USER_EXCEPTION THEN
3220: x_Err_Code := z_Err_Code;
3221: x_Err_Msg := z_Err_Msg;
3222: fem_engines_pkg.user_message(p_msg_text => z_Err_Code||':'||z_Err_Msg);
3223: fnd_file.put_line(FND_FILE.OUTPUT,z_Err_Code||':'||z_Err_Msg);
3224: rollback;
3225: RETURN;
3226:
3227: WHEN OTHERS THEN