DBA Data[Home] [Help]

APPS.EDW_DB_STATUS dependencies on EDW_MESSAGE_S

Line 188: edw_message_s.sql_error('check_db_status',l_progress,sqlcode);

184: EXCEPTION
185: when others then
186: l_status := FALSE;
187: x_instance_code:=x_instance_code||l_instance_code||' ';
188: edw_message_s.sql_error('check_db_status',l_progress,sqlcode);
189: END;
190: END LOOP;
191:
192: CLOSE instances;

Line 256: edw_message_s.sql_error('check_db_status',l_progress,sqlcode);

252: EXCEPTION
253: when others then
254: DBMS_SQL.close_cursor(cid);
255: l_status := FALSE;
256: edw_message_s.sql_error('check_db_status',l_progress,sqlcode);
257:
258: END check_db_status_site;
259:
260: FUNCTION check_repository_status RETURN VARCHAR2 IS

Line 359: edw_message_s.sql_error('check_repository_status',l_progress,sqlcode);

355: DBMS_SQL.close_cursor(cid);
356: DBMS_SQL.close_cursor(cid1);
357: DBMS_SQL.close_cursor(cid2);
358:
359: edw_message_s.sql_error('check_repository_status',l_progress,sqlcode);
360:
361:
362: END check_repository_status;
363:

Line 423: edw_message_s.sql_error('replicate_table_to_all_site',l_progress,sqlcode);

419: END IF;
420:
421: EXCEPTION
422: when others then
423: edw_message_s.sql_error('replicate_table_to_all_site',l_progress,sqlcode);
424: l_status:=l_status||' '||l_instance_code||' ';
425: END;
426:
427: END LOOP;

Line 498: edw_message_s.sql_error('replicate_table_to_all_site1',l_progress,sqlcode);

494:
495: EXCEPTION
496: when others then
497: DBMS_SQL.close_cursor(cid);
498: edw_message_s.sql_error('replicate_table_to_all_site1',l_progress,sqlcode);
499: l_status:='FALSE';
500: return l_status;
501:
502: END replicate_tbl_to_site;