eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_ADMIN dependencies on CZ_ADMIN

Line 1: PACKAGE BODY CZ_ADMIN as

1: PACKAGE BODY CZ_ADMIN as
2: /* $Header: czcadmnb.pls 115.18 2003/10/31 19:49:48 qmao ship $ */
3: PROCEDURE VALIDATE_END_USERS IS
4: CURSOR C_GET_USER IS
5: SELECT LOGIN_NAME FROM CZ_END_USERS;

Line 15: -- xERROR:=CZ_UTILS.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_LOGIN_NAME'),1,'CZ_ADMIN.VALIDATE_END_USER',11276);

11: LOOP
12: FETCH C_GET_USER INTO sLogin_name;
13: EXIT WHEN C_GET_USER%NOTFOUND;
14: IF(sLogin_name IS NULL)THEN
15: -- xERROR:=CZ_UTILS.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_LOGIN_NAME'),1,'CZ_ADMIN.VALIDATE_END_USER',11276);
16: cz_utils.log_report('CZ_ADMIN', 'VALIDATE_END_USERS', null,
17: CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_LOGIN_NAME'),
18: fnd_log.LEVEL_ERROR);
19: END IF;

Line 16: cz_utils.log_report('CZ_ADMIN', 'VALIDATE_END_USERS', null,

12: FETCH C_GET_USER INTO sLogin_name;
13: EXIT WHEN C_GET_USER%NOTFOUND;
14: IF(sLogin_name IS NULL)THEN
15: -- xERROR:=CZ_UTILS.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_LOGIN_NAME'),1,'CZ_ADMIN.VALIDATE_END_USER',11276);
16: cz_utils.log_report('CZ_ADMIN', 'VALIDATE_END_USERS', null,
17: CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_LOGIN_NAME'),
18: fnd_log.LEVEL_ERROR);
19: END IF;
20: END LOOP;

Line 26: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.VALIDATE_END_USER',11276);

22:
23: EXCEPTION
24: WHEN OTHERS THEN
25: CLOSE C_GET_USER;
26: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.VALIDATE_END_USER',11276);
27: cz_utils.log_report('CZ_ADMIN', 'VALIDATE_END_USERS', null,
28: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
29: END VALIDATE_END_USERS;
30: ------------------------------------------------------------------------------------------

Line 27: cz_utils.log_report('CZ_ADMIN', 'VALIDATE_END_USERS', null,

23: EXCEPTION
24: WHEN OTHERS THEN
25: CLOSE C_GET_USER;
26: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.VALIDATE_END_USER',11276);
27: cz_utils.log_report('CZ_ADMIN', 'VALIDATE_END_USERS', null,
28: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
29: END VALIDATE_END_USERS;
30: ------------------------------------------------------------------------------------------
31: PROCEDURE ENABLE_END_USERS IS

Line 72: -- xERROR:=CZ_UTILS.REPORT('Invalid login name',1,'CZ_ADMIN.ENABLE_END_USER',11276);

68: FETCH C_GET_USER INTO sLogin_name;
69: EXIT WHEN C_GET_USER%NOTFOUND;
70:
71: IF(sLogin_name IS NULL)THEN
72: -- xERROR:=CZ_UTILS.REPORT('Invalid login name',1,'CZ_ADMIN.ENABLE_END_USER',11276);
73: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
74: 'Invalid login name', fnd_log.LEVEL_ERROR);
75: ELSE
76: BEGIN

Line 73: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,

69: EXIT WHEN C_GET_USER%NOTFOUND;
70:
71: IF(sLogin_name IS NULL)THEN
72: -- xERROR:=CZ_UTILS.REPORT('Invalid login name',1,'CZ_ADMIN.ENABLE_END_USER',11276);
73: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
74: 'Invalid login name', fnd_log.LEVEL_ERROR);
75: ELSE
76: BEGIN
77:

Line 93: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);

89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
93: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
94: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
95: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
96: END;
97:

Line 94: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,

90: EXCEPTION
91: WHEN OTHERS THEN
92: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
93: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
94: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
95: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
96: END;
97:
98: BEGIN

Line 108: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);

104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
108: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
109: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
110: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
111: END;
112:

Line 109: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,

105: EXCEPTION
106: WHEN OTHERS THEN
107: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
108: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
109: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
110: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
111: END;
112:
113: BEGIN

Line 123: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);

119:
120: EXCEPTION
121: WHEN OTHERS THEN
122: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
123: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
124: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
125: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
126: END;
127:

Line 124: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,

120: EXCEPTION
121: WHEN OTHERS THEN
122: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
123: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
124: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
125: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
126: END;
127:
128: nUserID:=NULL;

Line 137: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);

133: BEGIN
134: UPDATE CZ_END_USERS SET DBMS_ID=nUserID WHERE UPPER(LOGIN_NAME)=sLogin_name;
135: EXCEPTION
136: WHEN OTHERS THEN
137: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
138: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
139: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
140: END;
141: END IF;

Line 138: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,

134: UPDATE CZ_END_USERS SET DBMS_ID=nUserID WHERE UPPER(LOGIN_NAME)=sLogin_name;
135: EXCEPTION
136: WHEN OTHERS THEN
137: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
138: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
139: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
140: END;
141: END IF;
142: END LOOP;

Line 149: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);

145:
146: EXCEPTION
147: WHEN OTHERS THEN
148: CLOSE C_GET_USER;
149: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
150: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
151: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
152: END ENABLE_END_USERS;
153: ------------------------------------------------------------------------------------------

Line 150: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,

146: EXCEPTION
147: WHEN OTHERS THEN
148: CLOSE C_GET_USER;
149: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
150: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
151: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
152: END ENABLE_END_USERS;
153: ------------------------------------------------------------------------------------------
154: PROCEDURE SPX_WAIT(nSeconds IN NUMBER DEFAULT 0) IS

Line 232: END CZ_ADMIN;

228: RAISE IMP_ACTIVE_SESSION_EXISTS;
229: END;
230: ------------------------------------------------------------------------------------------
231:
232: END CZ_ADMIN;