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.CSM_GROUP_DOWNLOAD_PVT dependencies on FND_LOG

Line 45: 'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_STATEMENT);

41: l_owner_id CSM_GROUPS.GROUP_OWNER_ID%TYPE := NULL;
42: BEGIN
43:
44: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP Proc ',
45: 'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
46: OPEN c_group_ins (p_user_id);
47: FETCH c_group_ins INTO l_group_id,l_owner_id;
48: CLOSE c_group_ins;
49:

Line 72: 'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_STATEMENT);

68: x_return_status := 'SUCCESS';
69: x_error_message := 'Group Data for Current Group successfully Inserted';
70:
71: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP Proc ',
72: 'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
73:
74: EXCEPTION
75: WHEN others THEN
76: l_sqlerrno := to_char(SQLCODE);

Line 81: CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_EXCEPTION);

77: l_sqlerrmsg := substr(SQLERRM, 1,2000);
78: x_return_status := 'ERROR';
79: x_error_message := l_sqlerrmsg;
80: l_message := 'Exception in CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP Procedure :' || l_sqlerrno || ':' || l_sqlerrmsg;
81: CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_EXCEPTION);
82: END INSERT_MY_GROUP;
83:
84:
85: -- The Group which was downloaded for the user has to be deleted from the

Line 109: 'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_STATEMENT);

105: l_access_id CSM_GROUPS.ACCESS_ID%TYPE;
106:
107: BEGIN
108: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP Proc ',
109: 'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
110: OPEN c_group_del(p_user_id);
111: FETCH c_group_del INTO l_group_id;
112: CLOSE c_group_del;
113:

Line 128: 'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_STATEMENT);

124:
125: x_return_status := 'SUCCESS';
126: x_error_message := 'Group Data successfully Deleted';
127: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP Proc ',
128: 'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
129:
130: EXCEPTION
131: WHEN others THEN
132: l_sqlerrno := to_char(SQLCODE);

Line 138: CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_EXCEPTION);

134: x_return_status := 'ERROR';
135: x_error_message := 'l_sqlerrmsg';
136: l_message := 'Exception in CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP Procedure : for accessid '
137: || l_access_id ||': with error ' || l_sqlerrno || ':' || l_sqlerrmsg;
138: CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_EXCEPTION);
139: END DELETE_MY_GROUP;
140:
141: PROCEDURE INSERT_GROUP_ACC (p_user_id NUMBER
142: , p_group_id NUMBER

Line 165: 'CSM_GROUP_DOWNLOAD.INSERT_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);

161:
162: BEGIN
163:
164: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC Proc ',
165: 'CSM_GROUP_DOWNLOAD.INSERT_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
166:
167: OPEN c_rel_group_ins(p_group_id);
168: FETCH c_rel_group_ins INTO l_chk_rel_grp;
169:

Line 205: 'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);

201: x_return_status := 'SUCCESS';
202: x_error_message := 'Group Data successfully Inserted';
203:
204: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC Proc ',
205: 'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
206:
207: EXCEPTION
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: x_return_status := 'ERROR';

Line 210: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_EXCEPTION);

206:
207: EXCEPTION
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: x_return_status := 'ERROR';
210: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_EXCEPTION);
211: WHEN others THEN
212: l_sqlerrno := to_char(SQLCODE);
213: l_sqlerrmsg := substr(SQLERRM, 1,2000);
214: x_return_status := 'ERROR';

Line 217: CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_EXCEPTION);

213: l_sqlerrmsg := substr(SQLERRM, 1,2000);
214: x_return_status := 'ERROR';
215: x_error_message := l_sqlerrmsg;
216: l_message := 'Exception in CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC Procedure :' || l_sqlerrno || ':' || l_sqlerrmsg;
217: CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_EXCEPTION);
218: END INSERT_GROUP_ACC;
219:
220:
221: --The Group which was downloaded for the user has to be deleted from the

Line 239: 'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);

235: l_access_id CSM_GROUPS.ACCESS_ID%TYPE;
236:
237: BEGIN
238: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC Proc ',
239: 'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
240:
241: IF p_user_id IS NOT NULL AND p_group_id IS NOT NULL THEN
242:
243: CSM_ACC_PKG.Delete_Acc

Line 255: 'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);

251:
252: x_return_status := 'SUCCESS';
253: x_error_message := 'Group Data successfully Deleted';
254: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC Proc ',
255: 'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
256:
257: EXCEPTION
258: WHEN others THEN
259: l_sqlerrno := to_char(SQLCODE);

Line 266: FND_LOG.LEVEL_EXCEPTION);

262: x_error_message := 'l_sqlerrmsg';
263: l_message := 'Exception in CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC Procedure : for accessid '
264: || l_access_id ||': with error ' || l_sqlerrno || ':' || l_sqlerrmsg;
265: CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',
266: FND_LOG.LEVEL_EXCEPTION);
267: END DELETE_GROUP_ACC;
268:
269: END CSM_GROUP_DOWNLOAD_PVT;