APPS.CSM_DEFERRED_TXNS_PKG dependencies on CSM_UTIL_PKG

Line 31: CSM_UTIL_PKG.LOG('Multiple Pks in '||inq_table||' is not supported for correction',

27: WHERE nfn.tracking_id=p_tracking_id
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:

Line 50: CSM_UTIL_PKG.LOG('Tracking INQ record was lost',

46: EXECUTE IMMEDIATE l_qry;
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;

Line 64: CSM_UTIL_PKG.LOG('No data found in '||inq_table||'_INQ'||' with pk:'||inq_pk_value,

60: EXECUTE IMMEDIATE l_qry;
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);

Line 67: CSM_UTIL_PKG.LOG('Query is: '||l_qry,

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:
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);

Line 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.',

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;
73: EXCEPTION
74: WHEN NO_DATA_FOUND THEN

Line 136: CSM_UTIL_PKG.LOG('Delete DML received for tracking Id: '||dml_0_rec.tracking_id||' from -'||p_user_name ||' in txn-'||p_tranid,

132: FOR dml_0_rec IN (SELECT TRACKING_ID,SEQNO$$ FROM CSM_DEFERRED_TRANSACTIONS_INQ inq
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

Line 159: CSM_UTIL_PKG.DELETE_RECORD

155: END LOOP;
156:
157: DELETE FROM CSM_DEFERRED_NFN_INFO WHERE dml_0_rec.tracking_id IN (TRACKING_ID,PARENT_ID) AND CLIENT_ID=p_user_name;
158:
159: CSM_UTIL_PKG.DELETE_RECORD
160: (
161: p_user_name,
162: p_tranid,
163: dml_0_rec.seqno$$,

Line 197: CSM_UTIL_PKG.DELETE_RECORD

193: AND PARENT_ID IS NOT NULL) /*REAPPLY supported only at ROOT level*/
194: )
195: ))
196: LOOP
197: CSM_UTIL_PKG.DELETE_RECORD
198: (
199: p_user_name,
200: p_tranid,
201: clear_rec.seqno$$,

Line 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,

225:
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:

Line 247: CSM_UTIL_PKG.LOG('Found '||def_rec.tracking_id||' with action '||def_rec.action||' for -'||p_user_name ||' for txn-'||p_tranid,

243: CLOSE c_reapply_txn;
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

Line 267: CSM_UTIL_PKG.LOG('Discarding Tracking Id: '||disc_rec.tracking_id,

263: disc_rec.error_msg, --IN variable of asg api
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,

Line 325: CSM_UTIL_PKG.DELETE_RECORD

321:
322: END IF;
323:
324: --INQ Record processed successfully.
325: CSM_UTIL_PKG.DELETE_RECORD
326: (
327: p_user_name,
328: p_tranid,
329: def_rec.seqno$$,

Line 343: CSM_UTIL_PKG.LOG('Reapplying Transaction:'||l_reapply_tab(I).DEFERRED_TRAN_ID ||' of user:'||l_reapply_tab(I).CLIENT_ID,

339:
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:

Line 357: CSM_UTIL_PKG.LOG

353: */
354:
355: EXCEPTION WHEN OTHERS THEN
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;