DBA Data[Home] [Help]

APPS.MRP_PO_RESCHEDULE dependencies on UTL_FILE

Line 34: fname utl_file.file_type ;

30: RAISE;
31: END log_message;
32:
33: PROCEDURE debug_message( p_user_info IN VARCHAR2) IS
34: fname utl_file.file_type ;
35: BEGIN
36: -- fname := utl_file.fopen('/sqlcom/log/mfgstrw','dttmp2','a');
37: -- utl_file.put(fname, p_user_info);
38: -- utl_file.fflush(fname);

Line 36: -- fname := utl_file.fopen('/sqlcom/log/mfgstrw','dttmp2','a');

32:
33: PROCEDURE debug_message( p_user_info IN VARCHAR2) IS
34: fname utl_file.file_type ;
35: BEGIN
36: -- fname := utl_file.fopen('/sqlcom/log/mfgstrw','dttmp2','a');
37: -- utl_file.put(fname, p_user_info);
38: -- utl_file.fflush(fname);
39: -- utl_file.fclose(fname);
40:

Line 37: -- utl_file.put(fname, p_user_info);

33: PROCEDURE debug_message( p_user_info IN VARCHAR2) IS
34: fname utl_file.file_type ;
35: BEGIN
36: -- fname := utl_file.fopen('/sqlcom/log/mfgstrw','dttmp2','a');
37: -- utl_file.put(fname, p_user_info);
38: -- utl_file.fflush(fname);
39: -- utl_file.fclose(fname);
40:
41: IF l_debug = 'Y' THEN

Line 38: -- utl_file.fflush(fname);

34: fname utl_file.file_type ;
35: BEGIN
36: -- fname := utl_file.fopen('/sqlcom/log/mfgstrw','dttmp2','a');
37: -- utl_file.put(fname, p_user_info);
38: -- utl_file.fflush(fname);
39: -- utl_file.fclose(fname);
40:
41: IF l_debug = 'Y' THEN
42: log_message(p_user_info);

Line 39: -- utl_file.fclose(fname);

35: BEGIN
36: -- fname := utl_file.fopen('/sqlcom/log/mfgstrw','dttmp2','a');
37: -- utl_file.put(fname, p_user_info);
38: -- utl_file.fflush(fname);
39: -- utl_file.fclose(fname);
40:
41: IF l_debug = 'Y' THEN
42: log_message(p_user_info);
43: --INSERT INTO dt_debug VALUES (p_user_info);