APPS.BSC_UPDATE_LOG dependencies on BSC_UPDATE_LOG

Line 1: PACKAGE BODY BSC_UPDATE_LOG AS

1: PACKAGE BODY BSC_UPDATE_LOG AS
2: /* $Header: BSCDLOGB.pls 120.1 2005/06/30 16:29:10 meastmon noship $ */
3: --
4: -- Package constants
5: --

Line 82: x_source => 'BSC_UPDATE_LOG.Init_Log_File');

78:
79: EXCEPTION
80: WHEN e_unexpected_error THEN
81: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_CREATION_FAILED'),
82: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
83: RETURN FALSE;
84:
85: WHEN e_no_log_file_dir THEN
86: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_DIR_NOT_SPECIFIED'),

Line 87: x_source => 'BSC_UPDATE_LOG.Init_Log_File');

83: RETURN FALSE;
84:
85: WHEN e_no_log_file_dir THEN
86: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_DIR_NOT_SPECIFIED'),
87: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
88: RETURN FALSE;
89:
90: WHEN UTL_FILE.INVALID_PATH THEN
91: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_PATH_FAILED'),

Line 92: x_source => 'BSC_UPDATE_LOG.Init_Log_File');

88: RETURN FALSE;
89:
90: WHEN UTL_FILE.INVALID_PATH THEN
91: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_PATH_FAILED'),
92: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
93: RETURN FALSE;
94:
95: WHEN UTL_FILE.INVALID_MODE THEN
96: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_MODE_FAILED'),

Line 97: x_source => 'BSC_UPDATE_LOG.Init_Log_File');

93: RETURN FALSE;
94:
95: WHEN UTL_FILE.INVALID_MODE THEN
96: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_MODE_FAILED'),
97: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
98: RETURN FALSE;
99:
100: WHEN UTL_FILE.INVALID_OPERATION THEN
101: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_OPERATION_FAILED'),

Line 102: x_source => 'BSC_UPDATE_LOG.Init_Log_File');

98: RETURN FALSE;
99:
100: WHEN UTL_FILE.INVALID_OPERATION THEN
101: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_OPERATION_FAILED'),
102: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
103: RETURN FALSE;
104:
105: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
106: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_HANDLE_FAILED'),

Line 107: x_source => 'BSC_UPDATE_LOG.Init_Log_File');

103: RETURN FALSE;
104:
105: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
106: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_HANDLE_FAILED'),
107: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
108: RETURN FALSE;
109:
110: WHEN UTL_FILE.WRITE_ERROR THEN
111: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_WRITE_LOGFILE_FAILED'),

Line 112: x_source => 'BSC_UPDATE_LOG.Init_Log_File');

108: RETURN FALSE;
109:
110: WHEN UTL_FILE.WRITE_ERROR THEN
111: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_WRITE_LOGFILE_FAILED'),
112: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
113: RETURN FALSE;
114:
115: WHEN OTHERS THEN
116: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 117: x_source => 'BSC_UPDATE_LOG.Init_Log_File');

113: RETURN FALSE;
114:
115: WHEN OTHERS THEN
116: BSC_MESSAGE.Add(x_message => SQLERRM,
117: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
118: RETURN FALSE;
119:
120: END Init_Log_File;
121:

Line 209: Write_Line_Log(h_message, BSC_UPDATE_LOG.LOG);

205: OPEN c_messages FOR c_messages_sql USING h_sessionid;
206: FETCH c_messages INTO h_message;
207:
208: WHILE c_messages%FOUND LOOP
209: Write_Line_Log(h_message, BSC_UPDATE_LOG.LOG);
210: FETCH c_messages INTO h_message;
211: END LOOP;
212:
213: CLOSE c_messages;

Line 218: END BSC_UPDATE_LOG;

214:
215: END Write_Errors_To_Log;
216:
217:
218: END BSC_UPDATE_LOG;