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

Line 55: CSM_UTIL_PKG.LOG('Processing deletes', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD', FND_LOG.LEVEL_PROCEDURE);

51: l_r varchar2(10);
52: BEGIN
53:
54:
55: CSM_UTIL_PKG.LOG('Processing deletes', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD', FND_LOG.LEVEL_PROCEDURE);
56:
57: OPEN c_del_cur;
58: LOOP
59: l_tab_access_id.DELETE;

Line 65: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_HZ_CUST_ACCT_SITES_ALL_ACC' ,

61:
62: FETCH c_del_cur BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
63: EXIT WHEN l_tab_access_id.COUNT = 0;
64:
65: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_HZ_CUST_ACCT_SITES_ALL_ACC' ,
66: 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD', FND_LOG.LEVEL_PROCEDURE);
67:
68: l_markdirty := asg_download.mark_dirty(
69: P_PUB_ITEM => 'CSM_HZ_CUST_ACCT_SITES_ALL'

Line 83: CSM_UTIL_PKG.LOG('Processing Inserts', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD', FND_LOG.LEVEL_PROCEDURE);

79: COMMIT;
80: END LOOP;
81: CLOSE c_del_cur;
82:
83: CSM_UTIL_PKG.LOG('Processing Inserts', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD', FND_LOG.LEVEL_PROCEDURE);
84:
85: OPEN c_ins_cur;
86: LOOP
87: l_tab_access_id.DELETE;

Line 108: CSM_UTIL_PKG.LOG('Bulk Inserted ' || l_tab_access_id.count || ' records into CSM_HZ_CUST_ACCT_SITES_ALL_ACC' ,

104: , p_dml_type => 'I'
105: , P_TIMESTAMP => sysdate
106: );
107:
108: CSM_UTIL_PKG.LOG('Bulk Inserted ' || l_tab_access_id.count || ' records into CSM_HZ_CUST_ACCT_SITES_ALL_ACC' ,
109: 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD',FND_LOG.LEVEL_PROCEDURE);
110: COMMIT;
111: END LOOP;
112: CLOSE c_ins_cur;

Line 114: CSM_UTIL_PKG.LOG('Leaving CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD',FND_LOG.LEVEL_PROCEDURE);

110: COMMIT;
111: END LOOP;
112: CLOSE c_ins_cur;
113:
114: CSM_UTIL_PKG.LOG('Leaving CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD',FND_LOG.LEVEL_PROCEDURE);
115:
116: END CUST_ACCT_SITES_UPD;
117:
118: --insert cust acct sites of passed CUST_ACCOUNT_ID

Line 133: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS',FND_LOG.LEVEL_PROCEDURE);

129: l_e VARCHAR2(4000);
130: l_r varchar2(10);
131: BEGIN
132:
133: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS',FND_LOG.LEVEL_PROCEDURE);
134:
135: OPEN c_ins_cur FOR select CSM_HZ_CUST_ACCOUNTS_ACC_S.nextval as ACCESS_ID, p_user_id,hcas.cust_acct_site_id
136: from hz_cust_acct_sites_all hcas
137: where hcas.party_site_id = p_party_site_id

Line 169: CSM_UTIL_PKG.LOG('Leaving after insert of '||l_tab_access_id.COUNT||' records', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS',FND_LOG.LEVEL_PROCEDURE);

165: END IF;
166:
167: CLOSE c_ins_cur;
168:
169: CSM_UTIL_PKG.LOG('Leaving after insert of '||l_tab_access_id.COUNT||' records', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS',FND_LOG.LEVEL_PROCEDURE);
170:
171: END CUST_ACCT_SITES_INS;
172:
173: --PROCEDURE IMPLEMENTATION DETAILS

Line 201: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_INS Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_INS',FND_LOG.LEVEL_EXCEPTION);

197: p_message VARCHAR2(3000);
198:
199: BEGIN
200:
201: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_INS Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_INS',FND_LOG.LEVEL_EXCEPTION);
202:
203:
204: FOR l_cust_accnt_rec IN c_cust_accnt_ins(p_party_id,p_user_id)
205: LOOP

Line 216: CSM_UTIL_PKG.LOG('Leaving CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_INS Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_INS',FND_LOG.LEVEL_EXCEPTION);

212: ,P_USER_ID => p_user_id
213: );
214: END LOOP;
215:
216: CSM_UTIL_PKG.LOG('Leaving CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_INS Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_INS',FND_LOG.LEVEL_EXCEPTION);
217:
218: EXCEPTION
219: WHEN others THEN
220: l_sqlerrno := to_char(SQLCODE);

Line 223: CSM_UTIL_PKG.LOG(p_message, 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_INS',FND_LOG.LEVEL_EXCEPTION);

219: WHEN others THEN
220: l_sqlerrno := to_char(SQLCODE);
221: l_sqlerrmsg := substr(SQLERRM, 1,2000);
222: p_message := 'Exception in CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_INS Procedure :' || l_sqlerrno || ':' || l_sqlerrmsg;
223: CSM_UTIL_PKG.LOG(p_message, 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_INS',FND_LOG.LEVEL_EXCEPTION);
224: RAISE;
225:
226: END CUST_ACCOUNTS_INS;
227: --update cannot be logically called from anywhere...

Line 260: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD',FND_LOG.LEVEL_EXCEPTION);

256: l_userid_lst asg_download.user_list;
257: l_last_run_date JTM_CON_REQUEST_DATA.LAST_RUN_DATE%TYPE;
258:
259: BEGIN
260: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD',FND_LOG.LEVEL_EXCEPTION);
261:
262: OPEN csr_last_run_date;
263: FETCH csr_last_run_date INTO l_last_run_date;
264: CLOSE csr_last_run_date;

Line 303: CSM_UTIL_PKG.LOG('Leaving CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD',FND_LOG.LEVEL_EXCEPTION);

299: COMMIT;
300: CLOSE c_cust_accnt_upd;
301: p_status := 'FINE';
302: p_message := 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD Executed successfully';
303: CSM_UTIL_PKG.LOG('Leaving CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD',FND_LOG.LEVEL_EXCEPTION);
304:
305: EXCEPTION
306: WHEN others THEN
307: l_sqlerrno := to_char(SQLCODE);

Line 311: CSM_UTIL_PKG.LOG(p_message, 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD',FND_LOG.LEVEL_EXCEPTION);

307: l_sqlerrno := to_char(SQLCODE);
308: l_sqlerrmsg := substr(SQLERRM, 1,2000);
309: p_status := 'ERROR';
310: p_message := 'Exception in CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD Procedure :' || l_sqlerrno || ':' || l_sqlerrmsg;
311: CSM_UTIL_PKG.LOG(p_message, 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD',FND_LOG.LEVEL_EXCEPTION);
312: ROLLBACK;
313:
314: END CUST_ACCOUNTS_UPD;
315:

Line 347: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL',FND_LOG.LEVEL_EXCEPTION);

343: l_access_id CSM_HZ_CUST_ACCOUNTS_ACC.ACCESS_ID%TYPE;
344: l_markdirty BOOLEAN;
345: BEGIN
346:
347: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL',FND_LOG.LEVEL_EXCEPTION);
348:
349: --take all teh cust_account_id for the party which doesnot exists for the user_id
350: FOR l_cust_accnt_rec IN c_cust_accnt_del(p_party_id,p_user_id)
351: LOOP

Line 363: CSM_UTIL_PKG.LOG('Leaving CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL',FND_LOG.LEVEL_EXCEPTION);

359: );
360:
361: END LOOP;
362:
363: CSM_UTIL_PKG.LOG('Leaving CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL',FND_LOG.LEVEL_EXCEPTION);
364:
365: EXCEPTION
366: WHEN others THEN
367: l_sqlerrno := to_char(SQLCODE);

Line 370: CSM_UTIL_PKG.LOG(p_message, 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL',FND_LOG.LEVEL_EXCEPTION);

366: WHEN others THEN
367: l_sqlerrno := to_char(SQLCODE);
368: l_sqlerrmsg := substr(SQLERRM, 1,2000);
369: p_message := 'Exception in CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL Procedure : for accessid ' || l_access_id ||': with error' || l_sqlerrno || ':' || l_sqlerrmsg;
370: CSM_UTIL_PKG.LOG(p_message, 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL',FND_LOG.LEVEL_EXCEPTION);
371: RAISE;
372:
373: END CUST_ACCOUNTS_DEL;
374: