DBA Data[Home] [Help]

APPS.CSM_DEFERRED_TXNS_PKG dependencies on ASG_DEFER

Line 217: asg_defer.reject_row(p_user_name,

213: EXCEPTION
214: WHEN NO_DATA_FOUND THEN
215: /*Send a reject row for recs in INQ that don't exist in Base*/
216: l_error_msg:= 'No such record in Base table';
217: asg_defer.reject_row(p_user_name,
218: p_tranid,
219: g_pub_name,
220: clear_rec.seqno$$,
221: l_error_msg, --IN variable of asg api

Line 259: asg_defer.reject_row(disc_rec.client_id,

255: connect by prior tracking_id=parent_id
256: start with tracking_id=def_rec.tracking_id)
257: LOOP
258: IF(disc_rec.dml='I') THEN
259: asg_defer.reject_row(disc_rec.client_id,
260: disc_rec.deferred_tran_id,
261: disc_rec.OBJECT_NAME,
262: disc_rec.sequence,
263: disc_rec.error_msg, --IN variable of asg api

Line 270: asg_defer.discard_transaction(disc_rec.client_id,

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,
273: disc_rec.sequence,l_process_status,false);
274:

Line 345: ASG_DEFER.reapply_transaction(l_reapply_tab(I).CLIENT_ID,l_reapply_tab(I).DEFERRED_TRAN_ID,l_process_status,false);

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:
349: /* not required..done while upload in purge_pub_items

Line 382: asg_defer.reject_row(disc_rec.client_id,

378: connect by prior tracking_id=parent_id
379: start with tracking_id=root_rec.tracking_id)
380: LOOP
381: IF(disc_rec.dml='I') THEN
382: asg_defer.reject_row(disc_rec.client_id,
383: disc_rec.deferred_tran_id,
384: disc_rec.OBJECT_NAME,
385: disc_rec.sequence,
386: disc_rec.error_msg, --IN variable of asg api

Line 408: ASG_DEFER.discard_transaction(p_user_name,p_tranid,x_return_status);

404:
405: END; --processed tracking records
406:
407:
408: ASG_DEFER.discard_transaction(p_user_name,p_tranid,x_return_status);
409:
410: END discard_transaction;
411:
412: -- Discards the specified deferred row ONLY

Line 443: asg_defer.reject_row(disc_rec.client_id,

439: connect by prior tracking_id=parent_id
440: start with tracking_id=l_tracking_id)
441: LOOP
442: IF(disc_rec.dml='I') THEN
443: asg_defer.reject_row(disc_rec.client_id,
444: disc_rec.deferred_tran_id,
445: disc_rec.OBJECT_NAME,
446: disc_rec.sequence,
447: disc_rec.error_msg, --IN variable of asg api

Line 471: ASG_DEFER.discard_transaction(p_user_name,p_tranid,p_pubitem,p_sequence,x_return_status,p_commit_flag);

467: WHEN NO_DATA_FOUND THEN
468: NULL;
469: END; --processed tracking records
470:
471: ASG_DEFER.discard_transaction(p_user_name,p_tranid,p_pubitem,p_sequence,x_return_status,p_commit_flag);
472:
473: END discard_transaction;
474:
475: END CSM_DEFERRED_TXNS_PKG;