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_UTIL_PKG

Line 45: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_INS_INIT for debrief_header_id: ' || p_debrief_header_id,

41: l_csm_debrfHdInsInit_rec l_csm_debrfHdInsInit_csr%ROWTYPE;
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:

Line 59: IF ( NOT (CSM_UTIL_PKG.is_palm_resource(l_csm_debrfHdInsInit_rec.resource_id))) THEN

55: END IF;
56: CLOSE l_csm_debrfHdInsInit_csr;
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;

Line 60: CSM_UTIL_PKG.LOG('Not a mobile resource for debrief_header_id: ' || p_debrief_header_id,

56: CLOSE l_csm_debrfHdInsInit_csr;
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;

Line 80: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_HEADER_INS_INIT for debrief_header_id: ' || p_debrief_header_id,

76: -- insert debrief headers into acc table
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);

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 100: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_MDIRTY_I for debrief_header_id: ' || p_debrief_header_id,

96: l_error_msg VARCHAR2(4000);
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')

Line 112: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_HEADER_MDIRTY_I for debrief_header_id: ' || p_debrief_header_id,

108: ,P_PK1_NUM_VALUE => p_debrief_header_id
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);

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 147: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_DEL_INIT for debrief_header_id: ' || p_debrief_header_id,

143: l_csm_debrfHdDel_rec l_csm_debrfHdDel_csr%ROWTYPE;
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:

Line 175: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_HEADER_DEL_INIT for debrief_header_id: ' || p_debrief_header_id,

171: -- delete debrief headers from acc table
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);

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 196: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_MDIRTY_D for debrief_header_id: ' || p_debrief_header_id,

192: l_return_status VARCHAR2(2000);
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')

Line 207: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_HEADER_MDIRTY_D for debrief_header_id: ' || p_debrief_header_id,

203: ,P_PK1_NUM_VALUE => p_debrief_header_id
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);

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 228: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_MDIRTY_U for debrief_header_id: ' || p_debrief_header_id,

224: l_return_status VARCHAR2(2000);
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

Line 247: CSM_UTIL_PKG.LOG('Leaving DEBRIEF_HEADER_MDIRTY_U for debrief_header_id: ' || p_debrief_header_id,

243: ,p_ACCESS_ID => l_access_id
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);

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;