APPS.EGO_RULE_SETS_PKG dependencies on UTL_FILE

Line 33: log_file UTL_FILE.FILE_TYPE;

29: * We just support one log file per ruleset
30: **/
31: log_path VARCHAR2(2000) DEFAULT '/usr/tmp';
32: log_name VARCHAR2(1000);
33: log_file UTL_FILE.FILE_TYPE;
34:
35:
36:
37: procedure LOG_MSG (X_MSG_TYPE IN VARCHAR2, X_MSG_DATA IN VARCHAR2) is

Line 40: log_file := utl_file.fopen(log_path, log_name, 'A');

36:
37: procedure LOG_MSG (X_MSG_TYPE IN VARCHAR2, X_MSG_DATA IN VARCHAR2) is
38:
39: begin
40: log_file := utl_file.fopen(log_path, log_name, 'A');
41: utl_file.put_line(log_file, to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS ') || X_MSG_TYPE || '::' || X_MSG_DATA);
42: utl_file.fclose(log_file);
43: end LOG_MSG;
44:

Line 41: utl_file.put_line(log_file, to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS ') || X_MSG_TYPE || '::' || X_MSG_DATA);

37: procedure LOG_MSG (X_MSG_TYPE IN VARCHAR2, X_MSG_DATA IN VARCHAR2) is
38:
39: begin
40: log_file := utl_file.fopen(log_path, log_name, 'A');
41: utl_file.put_line(log_file, to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS ') || X_MSG_TYPE || '::' || X_MSG_DATA);
42: utl_file.fclose(log_file);
43: end LOG_MSG;
44:
45: function BUSINESS_ENTITIES_TO_STRING (X_RULESET_ID in number) return varchar2

Line 42: utl_file.fclose(log_file);

38:
39: begin
40: log_file := utl_file.fopen(log_path, log_name, 'A');
41: utl_file.put_line(log_file, to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS ') || X_MSG_TYPE || '::' || X_MSG_DATA);
42: utl_file.fclose(log_file);
43: end LOG_MSG;
44:
45: function BUSINESS_ENTITIES_TO_STRING (X_RULESET_ID in number) return varchar2
46: is

Line 189: select substr(value,1,instr(value||',', ',')-1) into log_path from v$parameter where name = 'utl_file_dir';

185: log_name := X_LOG_NAME;
186: else
187: log_name := X_RULESET_NAME || '_' || to_char(sysdate, 'yyyy-mm-dd') || '_' || to_char(sysdate, 'SSSSS') || '.txt';
188: end if;
189: select substr(value,1,instr(value||',', ',')-1) into log_path from v$parameter where name = 'utl_file_dir';
190: end INITIALIZE_RULESET;
191:
192: procedure CLEAR_RULE is
193: