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_CSP_REQ_LINES_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 30: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_I for requirement_line_id: ' || p_requirement_line_id,

26: l_error_msg VARCHAR2(4000);
27: l_return_status VARCHAR2(2000);
28:
29: BEGIN
30: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_I for requirement_line_id: ' || p_requirement_line_id,
31: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
32:
33: CSM_ACC_PKG.Insert_Acc
34: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

Line 42: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_I for requirement_line_id: ' || p_requirement_line_id,

38: ,P_PK1_NUM_VALUE => p_requirement_line_id
39: ,P_USER_ID => p_user_id
40: );
41:
42: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_I for requirement_line_id: ' || p_requirement_line_id,
43: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
44: EXCEPTION
45: WHEN OTHERS THEN
46: l_sqlerrno := to_char(SQLCODE);

Line 50: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);

46: l_sqlerrno := to_char(SQLCODE);
47: l_sqlerrmsg := substr(SQLERRM, 1,2000);
48: l_error_msg := ' Exception in CSP_REQ_LINES_MDIRTY_I for requirement_line_id:'
49: || to_char(p_requirement_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
50: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);
51: RAISE;
52: END CSP_REQ_LINES_MDIRTY_I;
53:
54: PROCEDURE CSP_REQ_LINES_MDIRTY_D(p_requirement_line_id IN NUMBER, p_user_id IN NUMBER)

Line 63: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_D for requirement_line_id: ' || p_requirement_line_id,

59: l_return_status VARCHAR2(2000);
60:
61:
62: BEGIN
63: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_D for requirement_line_id: ' || p_requirement_line_id,
64: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
65:
66: CSM_ACC_PKG.Delete_Acc
67: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

Line 74: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_D for requirement_line_id: ' || p_requirement_line_id,

70: ,P_PK1_NUM_VALUE => p_requirement_line_id
71: ,P_USER_ID => p_user_id
72: );
73:
74: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_D for requirement_line_id: ' || p_requirement_line_id,
75: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
76: EXCEPTION
77: WHEN OTHERS THEN
78: l_sqlerrno := to_char(SQLCODE);

Line 82: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);

78: l_sqlerrno := to_char(SQLCODE);
79: l_sqlerrmsg := substr(SQLERRM, 1,2000);
80: l_error_msg := ' Exception in CSP_REQ_LINES_MDIRTY_D for requirement_line_id:'
81: || to_char(p_requirement_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
82: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);
83: RAISE;
84: END CSP_REQ_LINES_MDIRTY_D;
85:
86: PROCEDURE CSP_REQ_LINES_MDIRTY_U(p_requirement_line_id IN NUMBER, p_user_id IN NUMBER)

Line 95: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_U for requirement_line_id: ' || p_requirement_line_id,

91: l_return_status VARCHAR2(2000);
92: l_access_id NUMBER;
93:
94: BEGIN
95: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_U for requirement_line_id: ' || p_requirement_line_id,
96: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
97:
98: l_access_id := CSM_ACC_PKG.Get_Acc_Id
99: ( P_ACC_TABLE_NAME => g_acc_table_name1

Line 114: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_U for requirement_line_id: ' || p_requirement_line_id,

110: ,P_USER_ID => p_user_id
111: );
112: END IF;
113:
114: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_U for requirement_line_id: ' || p_requirement_line_id,
115: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
116: EXCEPTION
117: WHEN OTHERS THEN
118: l_sqlerrno := to_char(SQLCODE);

Line 122: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);

118: l_sqlerrno := to_char(SQLCODE);
119: l_sqlerrmsg := substr(SQLERRM, 1,2000);
120: l_error_msg := ' Exception in CSP_REQ_LINES_MDIRTY_U for requirement_line_id:'
121: || to_char(p_requirement_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
122: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);
123: RAISE;
124: END CSP_REQ_LINES_MDIRTY_U;
125:
126:

Line 192: CSM_UTIL_PKG.LOG('Entering CONC_ORDER_UPDATE','CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE',FND_LOG.LEVEL_PROCEDURE);

188: SELECT HEADER_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID=b_line_id;
189:
190: l_hrd_id NUMBER;
191: BEGIN
192: CSM_UTIL_PKG.LOG('Entering CONC_ORDER_UPDATE','CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE',FND_LOG.LEVEL_PROCEDURE);
193:
194: l_current_run_date := sysdate;
195:
196: /*** First retrieve last run date of the conccurent program ***/

Line 209: CSM_UTIL_PKG.LOG('Updating Order Lines','CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE',FND_LOG.LEVEL_PROCEDURE);

205: OPEN c_order_info(r_LastRundate.LAST_RUN_DATE);
206: FETCH c_order_info BULK COLLECT INTO l_tab_oe_line_id,l_tab_user_id,l_tab_rqmt_line_id;
207: CLOSE c_order_info;
208:
209: CSM_UTIL_PKG.LOG('Updating Order Lines','CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE',FND_LOG.LEVEL_PROCEDURE);
210:
211: FOR i IN 1..l_tab_oe_line_id.COUNT
212: LOOP
213: -- mark dirty the record

Line 234: IF(NOT CSM_UTIL_PKG.is_html5_user(l_tab_user_id(i)) AND NOT CSM_UTIL_PKG.is_new_mmu_user(CSM_UTIL_PKG.get_user_name(l_tab_user_id(i)))) THEN

230: , p_timestamp => l_current_run_date
231: );
232:
233: --Notify User of update on Order placed
234: IF(NOT CSM_UTIL_PKG.is_html5_user(l_tab_user_id(i)) AND NOT CSM_UTIL_PKG.is_new_mmu_user(CSM_UTIL_PKG.get_user_name(l_tab_user_id(i)))) THEN
235: CSM_WF_PKG.RAISE_START_AUTO_SYNC_EVENT('CSM_REQ_LINES',to_char(l_tab_rqmt_line_id(i)),'UPDATE');
236: END IF;
237: END LOOP;
238:

Line 247: CSM_UTIL_PKG.LOG('Updating Reservation Lines','CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE',FND_LOG.LEVEL_PROCEDURE);

243: OPEN c_res_info(r_LastRundate.LAST_RUN_DATE);
244: FETCH c_res_info BULK COLLECT INTO l_tab_user_id, l_tab_res_id;
245: CLOSE c_res_info;
246:
247: CSM_UTIL_PKG.LOG('Updating Reservation Lines','CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE',FND_LOG.LEVEL_PROCEDURE);
248:
249: FOR i IN 1..l_tab_res_id.COUNT
250: LOOP
251: -- mark dirty the record

Line 269: CSM_UTIL_PKG.LOG('Leaving CONC_ORDER_UPDATE','CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE',FND_LOG.LEVEL_PROCEDURE);

265: AND procedure_name = 'CONC_ORDER_UPDATE';
266:
267: COMMIT;
268:
269: CSM_UTIL_PKG.LOG('Leaving CONC_ORDER_UPDATE','CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE',FND_LOG.LEVEL_PROCEDURE);
270:
271: p_status := 'FINE';
272: p_message := 'CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE Executed successfully';
273:

Line 327: CSM_UTIL_PKG.LOG('Entering REQ_LINE_DTL_IUD for req_line_dtl_id:' || p_rld||' with DML:'||p_DML_t,

323: l_tab_old_src_id ASG_DOWNLOAD.ACCESS_LIST;
324: l_upd_dml_t VARCHAR2(10):=p_DML_t;
325: l_header_id NUMBER;
326: BEGIN
327: CSM_UTIL_PKG.LOG('Entering REQ_LINE_DTL_IUD for req_line_dtl_id:' || p_rld||' with DML:'||p_DML_t,
328: 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_PROCEDURE);
329:
330: SELECT REQUIREMENT_LINE_ID,SOURCE_TYPE,SOURCE_ID INTO l_req_line_id,l_src,l_src_id FROM CSP_REQ_LINE_DETAILS WHERE req_line_detail_id=l_req_line_detail_id;
331:

Line 332: CSM_UTIL_PKG.LOG('Processing req_line_id:'||l_req_line_id||fnd_global.local_chr(10)||'req line detail_id:'||l_req_line_detail_id

328: 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_PROCEDURE);
329:
330: SELECT REQUIREMENT_LINE_ID,SOURCE_TYPE,SOURCE_ID INTO l_req_line_id,l_src,l_src_id FROM CSP_REQ_LINE_DETAILS WHERE req_line_detail_id=l_req_line_detail_id;
331:
332: CSM_UTIL_PKG.LOG('Processing req_line_id:'||l_req_line_id||fnd_global.local_chr(10)||'req line detail_id:'||l_req_line_detail_id
333: ||fnd_global.local_chr(10)||'src type:'||l_src
334: ||fnd_global.local_chr(10)||'src id:'||l_src_id, 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD', FND_LOG.LEVEL_PROCEDURE );
335:
336: OPEN c_get_dtl;

Line 366: CSM_UTIL_PKG.LOG('Leaving-1 REQ_LINE_DTL_IUD for req_line_dtl_id: ' || p_rld, 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_PROCEDURE);

362: where acc.req_line_detail_id=b.req_line_detail_id
363: and acc.user_id=b.user_id);
364:
365: IF (sql%rowcount=0) THEN
366: CSM_UTIL_PKG.LOG('Leaving-1 REQ_LINE_DTL_IUD for req_line_dtl_id: ' || p_rld, 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_PROCEDURE);
367: RETURN;
368: END IF;
369:
370: SELECT ACCESS_ID,USER_ID,ITEM_ID,ORG_ID BULK COLLECT INTO l_tab_access_id,l_tab_user_id,l_tab_item_id,l_tab_org_id

Line 385: CSM_UTIL_PKG.LOG('Leaving-2 REQ_LINE_DTL_IUD for req_line_dtl_id: ' || p_rld, 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_PROCEDURE);

381: l_found:=true;
382: END IF;
383:
384: IF (l_tab_access_id.COUNT=0) THEN
385: CSM_UTIL_PKG.LOG('Leaving-2 REQ_LINE_DTL_IUD for req_line_dtl_id: ' || p_rld, 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_PROCEDURE);
386: RETURN;
387: END IF;
388:
389: FOR I IN 1..l_tab_access_id.COUNT

Line 399: CSM_UTIL_PKG.LOG('Update Acc src and Mark Delete for old '||l_src||':'||l_tab_old_src_id(I)||' for user_id'||l_tab_user_id(I),

395: IF l_src_id IS NOT NULL THEN
396: IF p_DML_t='U' AND l_tab_old_src_id(I) <> l_src_id THEN --on receive, reservation gets deleted and new one gets created with RLD updated to new one
397: --on Addr change , RLD is updated with new IO line/header(Bug 16339885)
398:
399: CSM_UTIL_PKG.LOG('Update Acc src and Mark Delete for old '||l_src||':'||l_tab_old_src_id(I)||' for user_id'||l_tab_user_id(I),
400: 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_PROCEDURE);
401:
402: IF l_src='RES' THEN
403: doMarkDirty('CSM_MTL_RESERVATIONS',l_tab_old_src_id(I),l_tab_user_id(I),'D');

Line 471: CSM_UTIL_PKG.LOG('Leaving REQ_LINE_DTL_IUD for req_line_dtl_id: ' || p_rld,

467: END IF;
468:
469: END LOOP;
470: END IF;
471: CSM_UTIL_PKG.LOG('Leaving REQ_LINE_DTL_IUD for req_line_dtl_id: ' || p_rld,
472: 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_PROCEDURE);
473: EXCEPTION
474: WHEN OTHERS THEN
475: l_sqlerrno := to_char(SQLCODE);

Line 477: CSM_UTIL_PKG.LOG(' Exception in REQ_LINE_DTL_IUD for req_line_dtl_id:'

473: EXCEPTION
474: WHEN OTHERS THEN
475: l_sqlerrno := to_char(SQLCODE);
476: l_sqlerrmsg := substr(SQLERRM, 1,2000);
477: CSM_UTIL_PKG.LOG(' Exception in REQ_LINE_DTL_IUD for req_line_dtl_id:'
478: || to_char(p_rld) || ':' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_EXCEPTION);
479: END REQ_LINE_DTL_IUD;
480:
481: END CSM_CSP_REQ_LINES_EVENT_PKG;