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 CSM_PARTY_ASSIGNMENT

Line 1: PACKAGE BODY CSM_PARTY_ASSIGNMENT_PKG AS

1: PACKAGE BODY CSM_PARTY_ASSIGNMENT_PKG AS
2: /* $Header: csmptagb.pls 120.4 2008/02/29 08:58:24 anaraman noship $ */
3:
4: PROCEDURE INSERT_PARTY_ASSG (p_user_id IN NUMBER,
5: p_party_id IN NUMBER,

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 74: FROM CSM_PARTY_ASSIGNMENT

70: END IF;
71:
72: SELECT COUNT(1)
73: INTO l_cnt_party
74: FROM CSM_PARTY_ASSIGNMENT
75: WHERE USER_ID = p_user_id
76: AND PARTY_ID = p_party_id
77: AND PARTY_SITE_ID = l_party_site_id;
78:

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 83: INSERT INTO CSM_PARTY_ASSIGNMENT( USER_ID, PARTY_ID,

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,
86: CREATION_DATE, LAST_UPDATED_BY,
87: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 103: FROM CSM_PARTY_ASSIGNMENT

99: IF l_cnt_party = 0 AND l_party_site_id <> -1 THEN
100:
101: SELECT COUNT(1)
102: INTO l_cnt_party_site
103: FROM CSM_PARTY_ASSIGNMENT
104: WHERE USER_ID = p_user_id
105: AND PARTY_ID = p_party_id
106: AND PARTY_SITE_ID = -2;
107:

Line 116: FROM CSM_PARTY_ASSIGNMENT

112: we have to delete the record which hold the party alone */
113:
114: SELECT COUNT(1)
115: INTO l_cnt_upd_party
116: FROM CSM_PARTY_ASSIGNMENT
117: WHERE USER_ID = p_user_id
118: AND PARTY_ID = p_party_id
119: AND PARTY_SITE_ID = -1;
120:

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 125: UPDATE CSM_PARTY_ASSIGNMENT

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
128: AND PARTY_ID = p_party_id
129: AND PARTY_SITE_ID = -1;

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 139: INSERT INTO CSM_PARTY_ASSIGNMENT( USER_ID, PARTY_ID,

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,
142: CREATION_DATE, LAST_UPDATED_BY,
143: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 153: INSERT INTO CSM_PARTY_ASSIGNMENT( USER_ID, PARTY_ID,

149: SYSDATE, 1,
150: SYSDATE, 1
151: );
152:
153: INSERT INTO CSM_PARTY_ASSIGNMENT( USER_ID, PARTY_ID,
154: OWNER_ID, PARTY_SITE_ID,
155: DELETED_FLAG, CREATED_BY,
156: CREATION_DATE, LAST_UPDATED_BY,
157: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

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 172: INSERT INTO CSM_PARTY_ASSIGNMENT( USER_ID, PARTY_ID,

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,
175: CREATION_DATE, LAST_UPDATED_BY,
176: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 197: FROM CSM_PARTY_ASSIGNMENT

193: IF l_cnt_party <> 0 THEN
194:
195: SELECT deleted_flag
196: INTO l_deleted_flag
197: FROM CSM_PARTY_ASSIGNMENT
198: WHERE USER_ID = p_user_id
199: AND PARTY_ID = p_party_id
200: AND PARTY_SITE_ID = l_party_site_id;
201:

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 206: UPDATE CSM_PARTY_ASSIGNMENT

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
209: AND PARTY_ID = p_party_id
210: AND PARTY_SITE_ID = l_party_site_id;

Line 222: FROM CSM_PARTY_ASSIGNMENT

218: then we are updating the deleted flag to N*/
219:
220: SELECT COUNT(1)
221: INTO l_cnt_upd_site
222: FROM CSM_PARTY_ASSIGNMENT
223: WHERE USER_ID = p_user_id
224: AND PARTY_ID = p_party_id
225: AND PARTY_SITE_ID not in (-2,-1)
226: AND DELETED_FLAG = 'N';

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 232: UPDATE CSM_PARTY_ASSIGNMENT

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
235: AND PARTY_ID = p_party_id
236: AND OWNER_ID = p_owner_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 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;

254: WHEN OTHERS THEN
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:

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 290: FROM CSM_PARTY_ASSIGNMENT

286: l_party_site_id := NVL(p_party_site_id,-1);
287:
288: SELECT COUNT(1)
289: INTO l_cnt_upd
290: FROM CSM_PARTY_ASSIGNMENT
291: WHERE USER_ID = p_user_id
292: AND PARTY_ID = p_party_id
293: AND PARTY_SITE_ID = l_party_site_id;
294:

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 299: UPDATE CSM_PARTY_ASSIGNMENT

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
302: AND PARTY_ID = p_party_id
303: AND OWNER_ID = p_owner_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 322: FROM CSM_PARTY_ASSIGNMENT

318: will also be deleted*/
319:
320: SELECT COUNT(1)
321: INTO l_cnt_upd_site
322: FROM CSM_PARTY_ASSIGNMENT
323: WHERE USER_ID = p_user_id
324: AND PARTY_ID = p_party_id
325: AND PARTY_SITE_ID not in (-2,-1)
326: AND DELETED_FLAG = 'N';

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 332: UPDATE CSM_PARTY_ASSIGNMENT

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
335: AND PARTY_ID = p_party_id
336: AND OWNER_ID = p_owner_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 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;

346: WHEN others THEN
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:

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;

Line 355: END CSM_PARTY_ASSIGNMENT_PKG;

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;