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_PARTY_ASSIGNMENT_PKG dependencies on FND_LOG

Line 29: CSM_UTIL_PKG.LOG('Entering CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG Package ', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

25: l_deleted_flag VARCHAR2(1) := NULL;
26:
27: BEGIN
28:
29: CSM_UTIL_PKG.LOG('Entering CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG Package ', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
30:
31: l_party_site_id := NVL(p_party_site_id,-1);
32:
33: IF l_party_site_id = -1

Line 81: CSM_UTIL_PKG.LOG('Inserting the record with party id only ', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

77: AND PARTY_SITE_ID = l_party_site_id;
78:
79: IF l_cnt_party = 0 AND l_party_site_id = -1 THEN
80:
81: CSM_UTIL_PKG.LOG('Inserting the record with party id only ', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
82:
83: INSERT INTO CSM_PARTY_ASSIGNMENT( USER_ID, PARTY_ID,
84: OWNER_ID, PARTY_SITE_ID,
85: DELETED_FLAG, CREATED_BY,

Line 123: CSM_UTIL_PKG.LOG('Updating the deleted flag to Y for party record ', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

119: AND PARTY_SITE_ID = -1;
120:
121: IF l_cnt_upd_party <> 0 THEN
122:
123: CSM_UTIL_PKG.LOG('Updating the deleted flag to Y for party record ', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
124:
125: UPDATE CSM_PARTY_ASSIGNMENT
126: SET DELETED_FLAG = 'Y'
127: WHERE USER_ID = p_user_id

Line 137: CSM_UTIL_PKG.LOG('Inserting the record with party id and party site id along with another record with - 2 as party site value', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

133: /* if the party is inserted along with the party_site
134: another record is inserted with party_site_id as -2
135: for deleting the access table purpose*/
136:
137: CSM_UTIL_PKG.LOG('Inserting the record with party id and party site id along with another record with - 2 as party site value', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
138:
139: INSERT INTO CSM_PARTY_ASSIGNMENT( USER_ID, PARTY_ID,
140: OWNER_ID, PARTY_SITE_ID,
141: DELETED_FLAG, CREATED_BY,

Line 170: CSM_UTIL_PKG.LOG('Inserting the record with party id and party site id only', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

166: END IF;
167:
168: IF l_cnt_party_site <> 0 THEN
169:
170: CSM_UTIL_PKG.LOG('Inserting the record with party id and party site id only', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
171:
172: INSERT INTO CSM_PARTY_ASSIGNMENT( USER_ID, PARTY_ID,
173: OWNER_ID, PARTY_SITE_ID,
174: DELETED_FLAG, CREATED_BY,

Line 204: CSM_UTIL_PKG.LOG('Updating the deleted flag to N for record which was deleted by mistake', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

200: AND PARTY_SITE_ID = l_party_site_id;
201:
202: IF l_deleted_flag = 'Y' THEN
203:
204: CSM_UTIL_PKG.LOG('Updating the deleted flag to N for record which was deleted by mistake', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
205:
206: UPDATE CSM_PARTY_ASSIGNMENT
207: SET DELETED_FLAG = 'N'
208: WHERE USER_ID = p_user_id

Line 230: CSM_UTIL_PKG.LOG('Updating the deleted flag to N for record which hold the -2 value if any record with part site is inserted', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

226: AND DELETED_FLAG = 'N';
227:
228: IF l_cnt_upd_site <> 0 THEN
229:
230: CSM_UTIL_PKG.LOG('Updating the deleted flag to N for record which hold the -2 value if any record with part site is inserted', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
231:
232: UPDATE CSM_PARTY_ASSIGNMENT
233: SET DELETED_FLAG = 'N'
234: WHERE USER_ID = p_user_id

Line 243: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG Package ', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

239: END IF;
240:
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242: x_error_message := 'PARTY_ID successfully Inserted ';
243: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG Package ', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
244:
245: EXCEPTION
246:
247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 252: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

248:
249: THEN
250:
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
253:
254: WHEN OTHERS THEN
255: l_sqlerrno := TO_CHAR(SQLCODE);
256: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 259: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

255: l_sqlerrno := TO_CHAR(SQLCODE);
256: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: x_error_message := 'Exception in CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG Procedure :'||'while inserting the party -'||p_party_id|| 'for the user -'||p_user_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
259: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
260:
261: END INSERT_PARTY_ASSG;
262:
263: PROCEDURE DELETE_PARTY_ASSG (p_user_id IN NUMBER,

Line 284: CSM_UTIL_PKG.LOG('Entering CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG Package ', 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

280: l_party_site_id NUMBER;
281:
282: BEGIN
283:
284: CSM_UTIL_PKG.LOG('Entering CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG Package ', 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
285:
286: l_party_site_id := NVL(p_party_site_id,-1);
287:
288: SELECT COUNT(1)

Line 297: CSM_UTIL_PKG.LOG('Updating the deleted flag to Y for Deleted records', 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

293: AND PARTY_SITE_ID = l_party_site_id;
294:
295: IF l_cnt_upd <> 0 THEN
296:
297: CSM_UTIL_PKG.LOG('Updating the deleted flag to Y for Deleted records', 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
298:
299: UPDATE CSM_PARTY_ASSIGNMENT
300: SET DELETED_FLAG = 'Y'
301: WHERE USER_ID = p_user_id

Line 310: CSM_UTIL_PKG.LOG('No records found for Deleting', 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

306: l_error_message := 'PARTY_ID successfully Deleted ';
307:
308: ELSE
309:
310: CSM_UTIL_PKG.LOG('No records found for Deleting', 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
311:
312: l_error_message := 'No records found for Deleting for user - '||p_user_id ||'and party -'||p_party_id||' and party site -'||l_party_site_id;
313:
314: END IF;

Line 330: CSM_UTIL_PKG.LOG('Updating the deleted flag to Y for the record which holds the -2 value', 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

326: AND DELETED_FLAG = 'N';
327:
328: IF l_cnt_upd_site = 0 THEN
329:
330: CSM_UTIL_PKG.LOG('Updating the deleted flag to Y for the record which holds the -2 value', 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
331:
332: UPDATE CSM_PARTY_ASSIGNMENT
333: SET DELETED_FLAG = 'Y'
334: WHERE USER_ID = p_user_id

Line 343: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG Package ', 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

339: END IF;
340:
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342: x_error_message := l_error_message;
343: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG Package ', 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
344:
345: EXCEPTION
346: WHEN others THEN
347: l_sqlerrno := TO_CHAR(SQLCODE);

Line 351: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);

347: l_sqlerrno := TO_CHAR(SQLCODE);
348: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: x_error_message := 'Exception in CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG Procedure :'||'while deleting the party -'||p_party_id|| 'for the user -'||p_user_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
351: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
352:
353: END DELETE_PARTY_ASSG;
354:
355: END CSM_PARTY_ASSIGNMENT_PKG;