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_HEADER_EVENT_PKG dependencies on CSM_DEBRIEF_HEADER_EVENT_PKG

Line 1: PACKAGE BODY csm_debrief_header_event_pkg AS

1: PACKAGE BODY csm_debrief_header_event_pkg AS
2: /* $Header: csmedbhb.pls 120.1 2005/07/24 23:45:04 trajasek noship $*/
3:
4: --
5: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE

Line 61: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

57:
58: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
59: IF ( NOT (CSM_UTIL_PKG.is_palm_resource(l_csm_debrfHdInsInit_rec.resource_id))) THEN
60: CSM_UTIL_PKG.LOG('Not a mobile resource for debrief_header_id: ' || p_debrief_header_id,
61: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
62: RETURN;
63: END IF;
64: l_user_id := l_csm_debrfHdInsInit_rec.user_id;
65:

Line 101: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

97: l_return_status VARCHAR2(2000);
98:
99: BEGIN
100: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_MDIRTY_I for debrief_header_id: ' || p_debrief_header_id,
101: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
102:
103: CSM_ACC_PKG.Insert_Acc
104: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')
105: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name

Line 113: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

109: ,P_USER_ID => p_user_id
110: );
111:
112: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_HEADER_MDIRTY_I for debrief_header_id: ' || p_debrief_header_id,
113: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
114: EXCEPTION
115: WHEN OTHERS THEN
116: l_sqlerrno := to_char(SQLCODE);
117: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 120: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);

116: l_sqlerrno := to_char(SQLCODE);
117: l_sqlerrmsg := substr(SQLERRM, 1,2000);
118: l_error_msg := ' Exception in DEBRIEF_HEADER_MDIRTY_I for debrief_header_id:'
119: || to_char(p_debrief_header_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
120: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);
121: RAISE;
122: END DEBRIEF_HEADER_MDIRTY_I;
123:
124: PROCEDURE DEBRIEF_HEADER_DEL_INIT(p_debrief_header_id IN NUMBER, p_user_id IN NUMBER,

Line 197: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

193: l_user_id NUMBER;
194:
195: BEGIN
196: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_MDIRTY_D for debrief_header_id: ' || p_debrief_header_id,
197: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
198:
199: CSM_ACC_PKG.Delete_Acc
200: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')
201: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name

Line 208: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

204: ,P_USER_ID => p_user_id
205: );
206:
207: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_HEADER_MDIRTY_D for debrief_header_id: ' || p_debrief_header_id,
208: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
209: EXCEPTION
210: WHEN OTHERS THEN
211: l_sqlerrno := to_char(SQLCODE);
212: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 215: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);

211: l_sqlerrno := to_char(SQLCODE);
212: l_sqlerrmsg := substr(SQLERRM, 1,2000);
213: l_error_msg := ' Exception in DEBRIEF_HEADER_MDIRTY_D for debrief_header_id:'
214: || to_char(p_debrief_header_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
215: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);
216: RAISE;
217: END DEBRIEF_HEADER_MDIRTY_D;
218:
219: PROCEDURE DEBRIEF_HEADER_MDIRTY_U(p_debrief_header_id IN NUMBER, p_user_id IN NUMBER)

Line 229: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);

225: l_access_id NUMBER;
226:
227: BEGIN
228: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_MDIRTY_U for debrief_header_id: ' || p_debrief_header_id,
229: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
230:
231: l_access_id := CSM_ACC_PKG.Get_Acc_Id
232: ( P_ACC_TABLE_NAME => g_debrief_acc_table_name
233: ,P_PK1_NAME => g_debrief_pk1_name

Line 248: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);

244: );
245: END IF;
246:
247: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_HEADER_MDIRTY_U for debrief_header_id: ' || p_debrief_header_id,
248: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
249: EXCEPTION
250: WHEN OTHERS THEN
251: l_sqlerrno := to_char(SQLCODE);
252: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 255: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);

251: l_sqlerrno := to_char(SQLCODE);
252: l_sqlerrmsg := substr(SQLERRM, 1,2000);
253: l_error_msg := ' Exception in DEBRIEF_HEADER_MDIRTY_U for debrief_header_id:'
254: || to_char(p_debrief_header_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
255: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);
256: RAISE;
257: END DEBRIEF_HEADER_MDIRTY_U;
258:
259: END CSM_DEBRIEF_HEADER_EVENT_PKG;

Line 259: END CSM_DEBRIEF_HEADER_EVENT_PKG;

255: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);
256: RAISE;
257: END DEBRIEF_HEADER_MDIRTY_U;
258:
259: END CSM_DEBRIEF_HEADER_EVENT_PKG;