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 FND_LOG

Line 46: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_HEADER_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

42: l_csm_debrfHdInsInit_null l_csm_debrfHdInsInit_csr%ROWTYPE;
43:
44: BEGIN
45: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_INS_INIT for debrief_header_id: ' || p_debrief_header_id,
46: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_HEADER_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
47:
48: l_csm_debrfHdInsInit_rec := l_csm_debrfHdInsInit_null;
49:
50: OPEN l_csm_debrfHdInsInit_csr(p_debrief_header_id);

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

77: DEBRIEF_HEADER_MDIRTY_I(p_debrief_header_id=>p_debrief_header_id,
78: p_user_id=>l_user_id);
79:
80: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_HEADER_INS_INIT for debrief_header_id: ' || p_debrief_header_id,
81: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_HEADER_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
82: EXCEPTION
83: WHEN OTHERS THEN
84: l_sqlerrno := to_char(SQLCODE);
85: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 88: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_HEADER_INS_INIT',FND_LOG.LEVEL_EXCEPTION);

84: l_sqlerrno := to_char(SQLCODE);
85: l_sqlerrmsg := substr(SQLERRM, 1,2000);
86: l_error_msg := ' Exception in DEBRIEF_HEADER_INS_INIT for debrief_header_id:'
87: || to_char(p_debrief_header_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
88: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_HEADER_INS_INIT',FND_LOG.LEVEL_EXCEPTION);
89: RAISE;
90: END DEBRIEF_HEADER_INS_INIT;
91:
92: PROCEDURE DEBRIEF_HEADER_MDIRTY_I(p_debrief_header_id IN NUMBER, p_user_id IN NUMBER)

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

144: l_csm_debrfHdDel_null l_csm_debrfHdDel_csr%ROWTYPE;
145:
146: BEGIN
147: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_DEL_INIT for debrief_header_id: ' || p_debrief_header_id,
148: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_HEADER_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
149:
150: l_csm_debrfHdDel_rec := l_csm_debrfHdDel_null;
151:
152: OPEN l_csm_debrfHdDel_csr(p_debrief_header_id, p_user_id);

Line 176: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_HEADER_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

172: DEBRIEF_HEADER_MDIRTY_D(p_debrief_header_id=>p_debrief_header_id,
173: p_user_id=>l_user_id);
174:
175: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_HEADER_DEL_INIT for debrief_header_id: ' || p_debrief_header_id,
176: 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_HEADER_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
177: EXCEPTION
178: WHEN OTHERS THEN
179: l_sqlerrno := to_char(SQLCODE);
180: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 183: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_HEADER_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);

179: l_sqlerrno := to_char(SQLCODE);
180: l_sqlerrmsg := substr(SQLERRM, 1,2000);
181: l_error_msg := ' Exception in DEBRIEF_HEADER_DEL_INIT for debrief_header_id:'
182: || to_char(p_debrief_header_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
183: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_DEBRIEF_EVENT_PKG.DEBRIEF_HEADER_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
184: RAISE;
185: END DEBRIEF_HEADER_DEL_INIT;
186:
187: PROCEDURE DEBRIEF_HEADER_MDIRTY_D(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;