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 62: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

334: l_invLocAsgn_rec l_invLocAsgn_csr%ROWTYPE;
335:
336: BEGIN
337: CSM_UTIL_PKG.LOG('Entering INV_LOC_ASSIGNMENT_UPD_INIT for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
338: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);
339:
340: OPEN l_invLocAsgn_csr(p_csp_inv_loc_assignment_id);
341: FETCH l_invLocAsgn_csr INTO l_invLocAsgn_rec;
342: IF l_invLocAsgn_csr%FOUND THEN

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

351: END IF;
352: CLOSE l_invLocAsgn_csr;
353:
354: CSM_UTIL_PKG.LOG('Leaving INV_LOC_ASSIGNMENT_UPD_INIT for csp_inv_loc_assignment_id: ' || p_csp_inv_loc_assignment_id,
355: 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);
356: EXCEPTION
357: WHEN OTHERS THEN
358: l_sqlerrno := to_char(SQLCODE);
359: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

358: l_sqlerrno := to_char(SQLCODE);
359: l_sqlerrmsg := substr(SQLERRM, 1,2000);
360: l_error_msg := ' Exception in INV_LOC_ASSIGNMENT_UPD_INIT for csp_inv_loc_assignment_id:'
361: || to_char(p_csp_inv_loc_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
362: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_UPD_INIT',FND_LOG.LEVEL_EXCEPTION);
363: RAISE;
364: END INV_LOC_ASSIGNMENT_UPD_INIT;
365:
366: END CSM_INV_LOC_ASS_EVENT_PKG;