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

Line 111: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.MATERIAL_BILLABLE_FLAG',FND_LOG.LEVEL_EXCEPTION);

107: l_sqlerrno := to_char(SQLCODE);
108: l_sqlerrmsg := substr(SQLERRM, 1,2000);
109: l_error_msg := ' Exception in MATERIAL_BILLABLE_FLAG for debrief_line_id: ' || p_debrief_line_id
110: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
111: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.MATERIAL_BILLABLE_FLAG',FND_LOG.LEVEL_EXCEPTION);
112: RETURN l_billing_type_category;
113: END MATERIAL_BILLABLE_FLAG;
114:
115: PROCEDURE DEBRIEF_LINES_ACC_I(p_debrief_line_id IN NUMBER, p_billing_category IN VARCHAR2,

Line 125: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_I',FND_LOG.LEVEL_PROCEDURE);

121: l_return_status VARCHAR2(2000);
122:
123: BEGIN
124: CSM_UTIL_PKG.LOG('Entering DEBRIEF_LINES_ACC_I for debrief_line_id: ' || p_debrief_line_id,
125: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_I',FND_LOG.LEVEL_PROCEDURE);
126:
127: CSM_ACC_PKG.Insert_Acc
128: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list(get_debrief_pi_name (p_billing_category))
129: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name

Line 137: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_I',FND_LOG.LEVEL_PROCEDURE);

133: ,P_USER_ID => p_user_id
134: );
135:
136: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_LINES_ACC_I for debrief_line_id: ' || p_debrief_line_id,
137: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_I',FND_LOG.LEVEL_PROCEDURE);
138: EXCEPTION
139: WHEN OTHERS THEN
140: l_sqlerrno := to_char(SQLCODE);
141: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 144: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_I',FND_LOG.LEVEL_EXCEPTION);

140: l_sqlerrno := to_char(SQLCODE);
141: l_sqlerrmsg := substr(SQLERRM, 1,2000);
142: l_error_msg := ' Exception in DEBRIEF_LINES_ACC_I for debrief_line_id:'
143: || to_char(p_debrief_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
144: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_I',FND_LOG.LEVEL_EXCEPTION);
145: RAISE;
146: END DEBRIEF_LINES_ACC_I;
147:
148: PROCEDURE DEBRIEF_LINE_INS_INIT (p_debrief_line_id IN NUMBER, p_h_user_id IN NUMBER,

Line 178: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

174: l_csm_debrfLnInsInit_null l_csm_debrfLnInsInit_csr%ROWTYPE;
175:
176: BEGIN
177: CSM_UTIL_PKG.LOG('Entering DEBRIEF_LINE_INS_INIT for debrief_line_id: ' || p_debrief_line_id,
178: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
179:
180: l_csm_debrfLnInsInit_rec := l_csm_debrfLnInsInit_null;
181:
182: OPEN l_csm_debrfLnInsInit_csr(p_debrief_line_id);

Line 193: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

189:
190: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
191: IF ( NOT (CSM_UTIL_PKG.is_palm_resource(l_csm_debrfLnInsInit_rec.resource_id))) THEN
192: CSM_UTIL_PKG.LOG('Not a mobile resource for debrief_line_id: ' || p_debrief_line_id,
193: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
194: RETURN;
195: END IF;
196: l_user_id := l_csm_debrfLnInsInit_rec.user_id;
197: l_labor_exp_organization_id := l_csm_debrfLnInsInit_rec.organization_id;

Line 233: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

229: p_billing_category=>l_material_billable_flag,
230: p_user_id=>l_user_id);
231: END IF;
232: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_LINE_INS_INIT for debrief_line_id: ' || p_debrief_line_id,
233: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
234: EXCEPTION
235: WHEN OTHERS THEN
236: l_sqlerrno := to_char(SQLCODE);
237: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 240: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_INS_INIT',FND_LOG.LEVEL_EXCEPTION);

236: l_sqlerrno := to_char(SQLCODE);
237: l_sqlerrmsg := substr(SQLERRM, 1,2000);
238: l_error_msg := ' Exception in DEBRIEF_LINE_INS_INIT for debrief_line_id:'
239: || to_char(p_debrief_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
240: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_INS_INIT',FND_LOG.LEVEL_EXCEPTION);
241: RAISE;
242: END DEBRIEF_LINE_INS_INIT;
243:
244: PROCEDURE DEBRIEF_LINE_DEL_INIT (p_debrief_line_id IN NUMBER, p_user_id IN NUMBER,

Line 269: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

265: l_csm_debrfLnDel_null l_csm_debrfLnDel_csr%ROWTYPE;
266:
267: BEGIN
268: CSM_UTIL_PKG.LOG('Entering DEBRIEF_LINE_DEL_INIT for debrief_line_id: ' || p_debrief_line_id,
269: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
270: l_csm_debrfLnDel_rec := l_csm_debrfLnDel_null;
271:
272: OPEN l_csm_debrfLnDel_csr(p_debrief_line_id, p_user_id);
273: FETCH l_csm_debrfLnDel_csr INTO l_csm_debrfLnDel_rec;

Line 307: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

303: p_billing_category=>l_material_billable_flag,
304: p_user_id=>p_user_id);
305: END IF;
306: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_LINE_DEL_INIT for debrief_line_id: ' || p_debrief_line_id,
307: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
308: EXCEPTION
309: WHEN OTHERS THEN
310: l_sqlerrno := to_char(SQLCODE);
311: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 314: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);

310: l_sqlerrno := to_char(SQLCODE);
311: l_sqlerrmsg := substr(SQLERRM, 1,2000);
312: l_error_msg := ' Exception in DEBRIEF_LINE_DEL_INIT for debrief_line_id:'
313: || to_char(p_debrief_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
314: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
315: RAISE;
316: END DEBRIEF_LINE_DEL_INIT;
317:
318: PROCEDURE DEBRIEF_LINES_ACC_D(p_debrief_line_id IN NUMBER, p_billing_category IN VARCHAR2,

Line 328: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_D',FND_LOG.LEVEL_PROCEDURE);

324: l_return_status VARCHAR2(2000);
325:
326: BEGIN
327: CSM_UTIL_PKG.LOG('Entering DEBRIEF_LINES_ACC_D for debrief_line_id: ' || p_debrief_line_id,
328: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_D',FND_LOG.LEVEL_PROCEDURE);
329:
330: CSM_ACC_PKG.Delete_Acc
331: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list(get_debrief_pi_name (p_billing_category))
332: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name

Line 338: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_D',FND_LOG.LEVEL_PROCEDURE);

334: ,P_PK1_NUM_VALUE => p_debrief_line_id
335: ,P_USER_ID => p_user_id
336: );
337: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_LINES_ACC_D for debrief_line_id: ' || p_debrief_line_id,
338: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_D',FND_LOG.LEVEL_PROCEDURE);
339: EXCEPTION
340: WHEN OTHERS THEN
341: l_sqlerrno := to_char(SQLCODE);
342: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 345: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_D',FND_LOG.LEVEL_EXCEPTION);

341: l_sqlerrno := to_char(SQLCODE);
342: l_sqlerrmsg := substr(SQLERRM, 1,2000);
343: l_error_msg := ' Exception in DEBRIEF_LINES_ACC_D for debrief_line_id:'
344: || to_char(p_debrief_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
345: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_D',FND_LOG.LEVEL_EXCEPTION);
346: RAISE;
347: END DEBRIEF_LINES_ACC_D;
348:
349: PROCEDURE DEBRIEF_LINE_UPD_INIT(p_debrief_line_id IN NUMBER, p_old_inventory_item_id IN NUMBER,

Line 385: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);

381: l_csm_debrfLnUpdInit_null l_csm_debrfLnUpdInit_csr%ROWTYPE;
382:
383: BEGIN
384: CSM_UTIL_PKG.LOG('Entering DEBRIEF_LINE_UPD_INIT for debrief_line_id: ' || p_debrief_line_id,
385: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);
386:
387: l_csm_debrfLnUpdInit_rec := l_csm_debrfLnUpdInit_null;
388:
389: OPEN l_csm_debrfLnUpdInit_csr(p_debrief_line_id);

Line 448: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);

444: END IF;
445: END IF;
446:
447: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_LINE_UPD_INIT for debrief_line_id: ' || p_debrief_line_id,
448: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);
449: EXCEPTION
450: WHEN OTHERS THEN
451: l_sqlerrno := to_char(SQLCODE);
452: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 455: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_UPD_INIT',FND_LOG.LEVEL_EXCEPTION);

451: l_sqlerrno := to_char(SQLCODE);
452: l_sqlerrmsg := substr(SQLERRM, 1,2000);
453: l_error_msg := ' Exception in DEBRIEF_LINE_UPD_INIT for debrief_line_id:'
454: || to_char(p_debrief_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
455: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_UPD_INIT',FND_LOG.LEVEL_EXCEPTION);
456: RAISE;
457: END DEBRIEF_LINE_UPD_INIT;
458:
459: PROCEDURE DEBRIEF_LINES_ACC_U(p_debrief_line_id IN NUMBER, p_billing_category IN VARCHAR2,

Line 469: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_U',FND_LOG.LEVEL_PROCEDURE);

465: l_return_status VARCHAR2(2000);
466:
467: BEGIN
468: CSM_UTIL_PKG.LOG('Entering DEBRIEF_LINES_ACC_U for debrief_line_id: ' || p_debrief_line_id,
469: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_U',FND_LOG.LEVEL_PROCEDURE);
470:
471: CSM_ACC_PKG.Update_Acc
472: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list(get_debrief_pi_name (p_billing_category))
473: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name

Line 479: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_U',FND_LOG.LEVEL_PROCEDURE);

475: ,P_USER_ID => p_user_id
476: );
477:
478: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_LINES_ACC_U for debrief_line_id: ' || p_debrief_line_id,
479: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_U',FND_LOG.LEVEL_PROCEDURE);
480: EXCEPTION
481: WHEN OTHERS THEN
482: l_sqlerrno := to_char(SQLCODE);
483: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 486: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_U',FND_LOG.LEVEL_EXCEPTION);

482: l_sqlerrno := to_char(SQLCODE);
483: l_sqlerrmsg := substr(SQLERRM, 1,2000);
484: l_error_msg := ' Exception in DEBRIEF_LINES_ACC_U for debrief_line_id:'
485: || to_char(p_debrief_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
486: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_U',FND_LOG.LEVEL_EXCEPTION);
487: RAISE;
488: END DEBRIEF_LINES_ACC_U;
489:
490: END CSM_DEBRIEF_EVENT_PKG;