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 179: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

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

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

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

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

235: p_billing_category=>l_material_billable_flag,
236: p_user_id=>l_user_id);
237: END IF;
238: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_LINE_INS_INIT for debrief_line_id: ' || p_debrief_line_id,
239: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
240: EXCEPTION
241: WHEN OTHERS THEN
242: l_sqlerrno := to_char(SQLCODE);
243: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

242: l_sqlerrno := to_char(SQLCODE);
243: l_sqlerrmsg := substr(SQLERRM, 1,2000);
244: l_error_msg := ' Exception in DEBRIEF_LINE_INS_INIT for debrief_line_id:'
245: || to_char(p_debrief_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
246: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_INS_INIT',FND_LOG.LEVEL_EXCEPTION);
247: RAISE;
248: END DEBRIEF_LINE_INS_INIT;
249:
250: PROCEDURE DEBRIEF_LINE_DEL_INIT (p_debrief_line_id IN NUMBER, p_user_id IN NUMBER,

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

272: l_csm_debrfLnDel_null l_csm_debrfLnDel_csr%ROWTYPE;
273:
274: BEGIN
275: CSM_UTIL_PKG.LOG('Entering DEBRIEF_LINE_DEL_INIT for debrief_line_id: ' || p_debrief_line_id,
276: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
277: l_csm_debrfLnDel_rec := l_csm_debrfLnDel_null;
278:
279: OPEN l_csm_debrfLnDel_csr(p_debrief_line_id, p_user_id);
280: FETCH l_csm_debrfLnDel_csr INTO l_csm_debrfLnDel_rec;

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

316: p_billing_category=>l_material_billable_flag,
317: p_user_id=>p_user_id);
318: END IF;
319: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_LINE_DEL_INIT for debrief_line_id: ' || p_debrief_line_id,
320: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
321: EXCEPTION
322: WHEN OTHERS THEN
323: l_sqlerrno := to_char(SQLCODE);
324: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

323: l_sqlerrno := to_char(SQLCODE);
324: l_sqlerrmsg := substr(SQLERRM, 1,2000);
325: l_error_msg := ' Exception in DEBRIEF_LINE_DEL_INIT for debrief_line_id:'
326: || to_char(p_debrief_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
327: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
328: RAISE;
329: END DEBRIEF_LINE_DEL_INIT;
330:
331: PROCEDURE DEBRIEF_LINES_ACC_D(p_debrief_line_id IN NUMBER, p_billing_category IN VARCHAR2,

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

337: l_return_status VARCHAR2(2000);
338:
339: BEGIN
340: CSM_UTIL_PKG.LOG('Entering DEBRIEF_LINES_ACC_D for debrief_line_id: ' || p_debrief_line_id,
341: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_D',FND_LOG.LEVEL_PROCEDURE);
342:
343: CSM_ACC_PKG.Delete_Acc
344: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list(get_debrief_pi_name (p_billing_category))
345: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name

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

347: ,P_PK1_NUM_VALUE => p_debrief_line_id
348: ,P_USER_ID => p_user_id
349: );
350: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_LINES_ACC_D for debrief_line_id: ' || p_debrief_line_id,
351: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_D',FND_LOG.LEVEL_PROCEDURE);
352: EXCEPTION
353: WHEN OTHERS THEN
354: l_sqlerrno := to_char(SQLCODE);
355: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

354: l_sqlerrno := to_char(SQLCODE);
355: l_sqlerrmsg := substr(SQLERRM, 1,2000);
356: l_error_msg := ' Exception in DEBRIEF_LINES_ACC_D for debrief_line_id:'
357: || to_char(p_debrief_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
358: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_D',FND_LOG.LEVEL_EXCEPTION);
359: RAISE;
360: END DEBRIEF_LINES_ACC_D;
361:
362: PROCEDURE DEBRIEF_LINE_UPD_INIT(p_debrief_line_id IN NUMBER, p_old_inventory_item_id IN NUMBER,

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

395: l_csm_debrfLnUpdInit_null l_csm_debrfLnUpdInit_csr%ROWTYPE;
396:
397: BEGIN
398: CSM_UTIL_PKG.LOG('Entering DEBRIEF_LINE_UPD_INIT for debrief_line_id: ' || p_debrief_line_id,
399: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);
400:
401: l_csm_debrfLnUpdInit_rec := l_csm_debrfLnUpdInit_null;
402:
403: OPEN l_csm_debrfLnUpdInit_csr(p_debrief_line_id);

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

463: END IF;
464: END IF;
465:
466: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_LINE_UPD_INIT for debrief_line_id: ' || p_debrief_line_id,
467: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);
468: EXCEPTION
469: WHEN OTHERS THEN
470: l_sqlerrno := to_char(SQLCODE);
471: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

470: l_sqlerrno := to_char(SQLCODE);
471: l_sqlerrmsg := substr(SQLERRM, 1,2000);
472: l_error_msg := ' Exception in DEBRIEF_LINE_UPD_INIT for debrief_line_id:'
473: || to_char(p_debrief_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
474: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINE_UPD_INIT',FND_LOG.LEVEL_EXCEPTION);
475: RAISE;
476: END DEBRIEF_LINE_UPD_INIT;
477:
478: PROCEDURE DEBRIEF_LINES_ACC_U(p_debrief_line_id IN NUMBER, p_billing_category IN VARCHAR2,

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

484: l_return_status VARCHAR2(2000);
485:
486: BEGIN
487: CSM_UTIL_PKG.LOG('Entering DEBRIEF_LINES_ACC_U for debrief_line_id: ' || p_debrief_line_id,
488: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_U',FND_LOG.LEVEL_PROCEDURE);
489:
490: CSM_ACC_PKG.Update_Acc
491: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list(get_debrief_pi_name (p_billing_category))
492: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name

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

494: ,P_USER_ID => p_user_id
495: );
496:
497: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_LINES_ACC_U for debrief_line_id: ' || p_debrief_line_id,
498: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_U',FND_LOG.LEVEL_PROCEDURE);
499: EXCEPTION
500: WHEN OTHERS THEN
501: l_sqlerrno := to_char(SQLCODE);
502: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

501: l_sqlerrno := to_char(SQLCODE);
502: l_sqlerrmsg := substr(SQLERRM, 1,2000);
503: l_error_msg := ' Exception in DEBRIEF_LINES_ACC_U for debrief_line_id:'
504: || to_char(p_debrief_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
505: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_LINES_ACC_U',FND_LOG.LEVEL_EXCEPTION);
506: RAISE;
507: END DEBRIEF_LINES_ACC_U;
508:
509: END CSM_DEBRIEF_EVENT_PKG;