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_DEFERRED_TXNS_PKG dependencies on FND_LOG

Line 32: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_PROCEDURE);

28: AND nfn.OBJECT_NAME = pi.item_id;
29:
30: IF l_proceed > 0 THEN
31: CSM_UTIL_PKG.LOG('Multiple Pks in '||inq_table||' is not supported for correction',
32: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_PROCEDURE);
33: RETURN;
34: END IF;
35:
36: BEGIN

Line 51: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_PROCEDURE);

47:
48: IF(SQL%ROWCOUNT=0) THEN -- Chances are there that MFS admin discarded this record already
49: -- in which case let the so-called corrected record go in the same txn
50: CSM_UTIL_PKG.LOG('Tracking INQ record was lost',
51: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_PROCEDURE);
52:
53: RETURN;
54: END IF;
55:

Line 65: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_EXCEPTION);

61:
62: EXCEPTION
63: WHEN NO_DATA_FOUND THEN
64: CSM_UTIL_PKG.LOG('No data found in '||inq_table||'_INQ'||' with pk:'||inq_pk_value,
65: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_EXCEPTION);
66:
67: CSM_UTIL_PKG.LOG('Query is: '||l_qry,
68: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_EXCEPTION);
69:

Line 68: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_EXCEPTION);

64: CSM_UTIL_PKG.LOG('No data found in '||inq_table||'_INQ'||' with pk:'||inq_pk_value,
65: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_EXCEPTION);
66:
67: CSM_UTIL_PKG.LOG('Query is: '||l_qry,
68: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_EXCEPTION);
69:
70: CSM_UTIL_PKG.LOG('If there is no issue with query then a blind Re-apply was initiated from client without a corrected root record.',
71: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_PROCEDURE);
72: END;

Line 71: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_PROCEDURE);

67: CSM_UTIL_PKG.LOG('Query is: '||l_qry,
68: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_EXCEPTION);
69:
70: CSM_UTIL_PKG.LOG('If there is no issue with query then a blind Re-apply was initiated from client without a corrected root record.',
71: 'CSM_DEFERRED_TXNS_PKG.correct_inq_for_reapply',FND_LOG.LEVEL_PROCEDURE);
72: END;
73: EXCEPTION
74: WHEN NO_DATA_FOUND THEN
75: NULL; -- can't happen as we check base table for existence before calling this api.

Line 137: 'CSM_DEFERRED_TXNS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

133: WHERE TRANID$$=p_tranid AND CLID$$CS=p_user_name AND dmltype$$='D')
134: LOOP
135:
136: CSM_UTIL_PKG.LOG('Delete DML received for tracking Id: '||dml_0_rec.tracking_id||' from -'||p_user_name ||' in txn-'||p_tranid,
137: 'CSM_DEFERRED_TXNS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
138:
139: --root is deleted by client so no mark dirty required
140: DELETE FROM CSM_DEFERRED_TRANSACTIONS_ACC
141: WHERE tracking_id = dml_0_rec.tracking_id

Line 230: 'CSM_DEFERRED_TXNS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

226: END LOOP;
227:
228: IF(l_cnt>0) THEN
229: CSM_UTIL_PKG.LOG('Purged and rejected '||l_cnt|| ' tracking records from INQ as they are missing in base table for -'||p_user_name ||' in current txn-'||p_tranid,
230: 'CSM_DEFERRED_TXNS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
231: END IF;
232:
233:
234: /***************************************PROCESS INQ RECORDS*********************************************/

Line 248: 'CSM_DEFERRED_TXNS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

244:
245: FOR def_rec IN c_inq_records(p_user_name,p_tranid)
246: LOOP
247: CSM_UTIL_PKG.LOG('Found '||def_rec.tracking_id||' with action '||def_rec.action||' for -'||p_user_name ||' for txn-'||p_tranid,
248: 'CSM_DEFERRED_TXNS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
249:
250: /*Take action*/
251: IF def_rec.ACTION = 'D' THEN
252: -- Discard root(need not be main root,can be partial) and all its related entries

Line 268: 'CSM_DEFERRED_TXNS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

264: l_process_status);
265: END IF;
266:
267: CSM_UTIL_PKG.LOG('Discarding Tracking Id: '||disc_rec.tracking_id,
268: 'CSM_DEFERRED_TXNS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
269:
270: asg_defer.discard_transaction(disc_rec.client_id,
271: disc_rec.deferred_tran_id,
272: disc_rec.OBJECT_NAME,

Line 344: 'CSM_DEFERRED_TXNS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

340: --RE-APPLY
341: FOR I IN 1..l_reapply_tab.COUNT
342: LOOP
343: CSM_UTIL_PKG.LOG('Reapplying Transaction:'||l_reapply_tab(I).DEFERRED_TRAN_ID ||' of user:'||l_reapply_tab(I).CLIENT_ID,
344: 'CSM_DEFERRED_TXNS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
345: ASG_DEFER.reapply_transaction(l_reapply_tab(I).CLIENT_ID,l_reapply_tab(I).DEFERRED_TRAN_ID,l_process_status,false);
346: END LOOP;
347:
348:

Line 360: FND_LOG.LEVEL_EXCEPTION);

356: /*** catch and log exceptions ***/
357: CSM_UTIL_PKG.LOG
358: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
359: g_object_name || '.APPLY_CLIENT_CHANGES',
360: FND_LOG.LEVEL_EXCEPTION);
361: x_return_status := FND_API.G_RET_STS_ERROR;
362:
363: END APPLY_CLIENT_CHANGES;
364: