APPS.BSC_UPDATE_LOG dependencies on BSC_MESSAGE

Line 81: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_CREATION_FAILED'),

77: RETURN TRUE;
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

Line 86: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_DIR_NOT_SPECIFIED'),

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'),
87: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
88: RETURN FALSE;
89:
90: WHEN UTL_FILE.INVALID_PATH THEN

Line 91: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_PATH_FAILED'),

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'),
92: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
93: RETURN FALSE;
94:
95: WHEN UTL_FILE.INVALID_MODE THEN

Line 96: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_MODE_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'),
97: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
98: RETURN FALSE;
99:
100: WHEN UTL_FILE.INVALID_OPERATION THEN

Line 101: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_OPERATION_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'),
102: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
103: RETURN FALSE;
104:
105: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 106: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_HANDLE_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'),
107: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
108: RETURN FALSE;
109:
110: WHEN UTL_FILE.WRITE_ERROR THEN

Line 111: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_WRITE_LOGFILE_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'),
112: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
113: RETURN FALSE;
114:
115: WHEN OTHERS THEN

Line 116: BSC_MESSAGE.Add(x_message => SQLERRM,

112: 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;

Line 195: ' FROM bsc_message_logs'||

191: TYPE t_cursor IS REF CURSOR;
192:
193: c_messages t_cursor; -- h_sessionid
194: c_messages_sql VARCHAR2(2000) := 'SELECT message'||
195: ' FROM bsc_message_logs'||
196: ' WHERE last_update_login = :1'||
197: ' ORDER BY last_update_date';
198:
199: h_sessionid NUMBER := USERENV('SESSIONID');

Line 201: h_message bsc_message_logs.message%TYPE;

197: ' ORDER BY last_update_date';
198:
199: h_sessionid NUMBER := USERENV('SESSIONID');
200:
201: h_message bsc_message_logs.message%TYPE;
202:
203:
204: BEGIN
205: OPEN c_messages FOR c_messages_sql USING h_sessionid;