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