1: PACKAGE BODY AMW_PURGE_MVIEW_LOG AS
2: /* $Header: amwslprb.pls 120.2 2006/01/06 17:44:14 appldev noship $ */
3:
4: FUNCTION GET_ROW_COUNT (schema_name VARCHAR2, table_name VARCHAR2)
5: RETURN NUMBER IS
65:
66:
67: EXCEPTION
68: WHEN NO_DATA_FOUND THEN
69: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in AMW_PURGE_MVIEW_LOG.REFRESH_ALL'
70: || SUBSTR (SQLERRM, 1, 100), 1, 200));
71: WHEN OTHERS THEN
72: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in AMW_PURGE_MVIEW_LOG.REFRESH_ALL'
73: || SUBSTR (SQLERRM, 1, 100), 1, 200));
68: WHEN NO_DATA_FOUND THEN
69: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in AMW_PURGE_MVIEW_LOG.REFRESH_ALL'
70: || SUBSTR (SQLERRM, 1, 100), 1, 200));
71: WHEN OTHERS THEN
72: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in AMW_PURGE_MVIEW_LOG.REFRESH_ALL'
73: || SUBSTR (SQLERRM, 1, 100), 1, 200));
74: errbuf := SQLERRM;
75: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
76:
77:
78: END REFRESH_ALL;
79:
80:
81: END AMW_PURGE_MVIEW_LOG;