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

Line 63: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

59: AND au.USER_ID = au.owner_id;
60:
61: BEGIN
62: CSM_UTIL_PKG.LOG('Entering INV_LOC_ASSIGNMENT_INS_INIT for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
63: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
64:
65: FOR r_invLocAsgn_rec IN l_invLocAsgn_csr(p_csp_inv_loc_assignment_id) LOOP
66: -- download subinventory and locator info
67: CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_I(p_csp_inv_loc_assignment_id=>p_csp_inv_loc_assignment_id,

Line 79: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

75: -- for inventory download....JTM Master conc program for INV needs to be run
76: END LOOP;
77:
78: CSM_UTIL_PKG.LOG('Leaving INV_LOC_ASSIGNMENT_INS_INIT for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
79: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
80: EXCEPTION
81: WHEN OTHERS THEN
82: l_sqlerrno := to_char(SQLCODE);
83: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 86: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_INS_INIT',FND_LOG.LEVEL_EXCEPTION);

82: l_sqlerrno := to_char(SQLCODE);
83: l_sqlerrmsg := substr(SQLERRM, 1,2000);
84: l_error_msg := ' Exception in INV_LOC_ASSIGNMENT_INS_INIT for csp_inv_loc_assignment_id:'
85: || to_char(p_csp_inv_loc_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
86: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_INS_INIT',FND_LOG.LEVEL_EXCEPTION);
87: RAISE;
88: END INV_LOC_ASSIGNMENT_INS_INIT;
89:
90: PROCEDURE INV_LOC_ASS_ACC_I(p_csp_inv_loc_assignment_id IN NUMBER, p_user_id IN NUMBER)

Line 119: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_I',FND_LOG.LEVEL_PROCEDURE);

115: AND mil.organization_id = p_organization_id;
116:
117: BEGIN
118: CSM_UTIL_PKG.LOG('Entering INV_LOC_ASS_ACC_I for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
119: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
120:
121: OPEN l_inv_loc_ass_csr(p_csp_inv_loc_assignment_id);
122: FETCH l_inv_loc_ass_csr INTO l_subinventory_code, l_organization_id;
123: IF l_inv_loc_ass_csr%FOUND THEN

Line 169: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_I',FND_LOG.LEVEL_PROCEDURE);

165: END LOOP;
166: CLOSE l_inv_location_csr;
167:
168: CSM_UTIL_PKG.LOG('Leaving INV_LOC_ASS_ACC_I for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
169: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
170:
171: EXCEPTION
172: WHEN OTHERS THEN
173: l_sqlerrno := to_char(SQLCODE);

Line 177: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_I',FND_LOG.LEVEL_EXCEPTION);

173: l_sqlerrno := to_char(SQLCODE);
174: l_sqlerrmsg := substr(SQLERRM, 1,2000);
175: l_error_msg := ' Exception in INV_LOC_ASS_ACC_I for csp_inv_loc_assignment_id:'
176: || to_char(p_csp_inv_loc_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
177: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_I',FND_LOG.LEVEL_EXCEPTION);
178: RAISE;
179: END INV_LOC_ASS_ACC_I;
180:
181: PROCEDURE INV_LOC_ASSIGNMENT_DEL_INIT(p_csp_inv_loc_assignment_id IN NUMBER)

Line 202: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

198: AND au.USER_ID = au.owner_id;
199:
200: BEGIN
201: CSM_UTIL_PKG.LOG('Entering INV_LOC_ASSIGNMENT_DEL_INIT for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
202: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
203:
204: FOR r_cila_post_del_rec IN l_cila_post_del_csr(p_csp_inv_loc_assignment_id) LOOP
205: -- delete downloaded subinventory and locator info
206: CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_D(p_csp_inv_loc_assignment_id=>p_csp_inv_loc_assignment_id,

Line 218: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

214: -- for inventory data to be deleted....JTM Master conc program for INV needs to be run
215: END LOOP;
216:
217: CSM_UTIL_PKG.LOG('Leaving INV_LOC_ASSIGNMENT_DEL_INIT for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
218: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
219: EXCEPTION
220: WHEN OTHERS THEN
221: l_sqlerrno := to_char(SQLCODE);
222: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 225: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);

221: l_sqlerrno := to_char(SQLCODE);
222: l_sqlerrmsg := substr(SQLERRM, 1,2000);
223: l_error_msg := ' Exception in INV_LOC_ASSIGNMENT_DEL_INIT for csp_inv_loc_assignment_id:'
224: || to_char(p_csp_inv_loc_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
225: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
226: RAISE;
227: END INV_LOC_ASSIGNMENT_DEL_INIT;
228:
229: PROCEDURE INV_LOC_ASS_ACC_D(p_csp_inv_loc_assignment_id IN NUMBER, p_user_id IN NUMBER)

Line 258: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_D',FND_LOG.LEVEL_PROCEDURE);

254: AND mil.organization_id = p_organization_id;
255:
256: BEGIN
257: CSM_UTIL_PKG.LOG('Entering INV_LOC_ASS_ACC_D for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
258: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
259:
260: OPEN l_inv_loc_ass_csr(p_csp_inv_loc_assignment_id);
261: FETCH l_inv_loc_ass_csr INTO l_subinventory_code, l_organization_id;
262: IF l_inv_loc_ass_csr%FOUND THEN

Line 308: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_D',FND_LOG.LEVEL_PROCEDURE);

304: END LOOP;
305: CLOSE l_inv_location_csr;
306:
307: CSM_UTIL_PKG.LOG('Leaving INV_LOC_ASS_ACC_D for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
308: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
309:
310: EXCEPTION
311: WHEN OTHERS THEN
312: l_sqlerrno := to_char(SQLCODE);

Line 316: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_D',FND_LOG.LEVEL_EXCEPTION);

312: l_sqlerrno := to_char(SQLCODE);
313: l_sqlerrmsg := substr(SQLERRM, 1,2000);
314: l_error_msg := ' Exception in INV_LOC_ASS_ACC_D for csp_inv_loc_assignment_id:'
315: || to_char(p_csp_inv_loc_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
316: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASS_ACC_D',FND_LOG.LEVEL_EXCEPTION);
317: RAISE;
318: END INV_LOC_ASS_ACC_D;
319:
320: PROCEDURE INV_LOC_ASSIGNMENT_UPD_INIT(p_csp_inv_loc_assignment_id IN NUMBER)

Line 343: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);

339: l_invLocAsgn_rec l_invLocAsgn_csr%ROWTYPE;
340:
341: BEGIN
342: CSM_UTIL_PKG.LOG('Entering INV_LOC_ASSIGNMENT_UPD_INIT for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
343: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);
344:
345: OPEN l_invLocAsgn_csr(p_csp_inv_loc_assignment_id);
346: FETCH l_invLocAsgn_csr INTO l_invLocAsgn_rec;
347: IF l_invLocAsgn_csr%FOUND THEN

Line 360: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);

356: END IF;
357: CLOSE l_invLocAsgn_csr;
358:
359: CSM_UTIL_PKG.LOG('Leaving INV_LOC_ASSIGNMENT_UPD_INIT for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
360: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);
361: EXCEPTION
362: WHEN OTHERS THEN
363: l_sqlerrno := to_char(SQLCODE);
364: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 367: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_UPD_INIT',FND_LOG.LEVEL_EXCEPTION);

363: l_sqlerrno := to_char(SQLCODE);
364: l_sqlerrmsg := substr(SQLERRM, 1,2000);
365: l_error_msg := ' Exception in INV_LOC_ASSIGNMENT_UPD_INIT for csp_inv_loc_assignment_id:'
366: || to_char(p_csp_inv_loc_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
367: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_UPD_INIT',FND_LOG.LEVEL_EXCEPTION);
368: RAISE;
369: END INV_LOC_ASSIGNMENT_UPD_INIT;
370:
371: END CSM_INV_LOC_ASS_EVENT_PKG;