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.ASG_DEFER dependencies on ASG_DEFER

Line 1: PACKAGE BODY asg_defer AS

1: PACKAGE BODY asg_defer AS
2: /*$Header: asgdfrb.pls 120.2 2006/02/02 16:06:23 rsripada noship $*/
3:
4: -- DESCRIPTION
5: -- This package supports deferred transactions.

Line 46: asg_helper.log('Begin raise_row_deferred','asg_defer',g_stmt_level);

42: l_qry varchar2(2048);
43: begin
44: if(asg_helper.check_is_log_enabled(g_stmt_level))
45: then
46: asg_helper.log('Begin raise_row_deferred','asg_defer',g_stmt_level);
47: end if;
48: l_qry := 'select '''||p_user_name||''' user_name,'''||to_char(p_tranid)
49: ||''' tran_id, '''||p_error_msg||''' ERROR_DESCRIPTION ,'
50: ||''''||p_pubitem||''' pub_item ,'''||p_sequence||''' SEQUENCE '

Line 54: ||'from asg_deferred_traninfo where CREATION_DATE >= to_date('''

50: ||''''||p_pubitem||''' pub_item ,'''||p_sequence||''' SEQUENCE '
51: ||' from dual';
52: /*l_qry := 'select DEVICE_USER_NAME user_name,DEFERRED_TRAN_ID tran_id ,'
53: ||'ERROR_DESCRIPTION ,OBJECT_NAME pub_item,SEQUENCE '
54: ||'from asg_deferred_traninfo where CREATION_DATE >= to_date('''
55: ||to_char(p_start_time,'mm-dd-yyyy hh24:mi:ss')
56: ||''',''mm-dd-yyyy hh24:mi:ss'') ';*/
57: if(asg_helper.check_is_log_enabled(g_stmt_level))
58: then

Line 59: asg_helper.log('Query :'||l_qry,'asg_defer',g_stmt_level);

55: ||to_char(p_start_time,'mm-dd-yyyy hh24:mi:ss')
56: ||''',''mm-dd-yyyy hh24:mi:ss'') ';*/
57: if(asg_helper.check_is_log_enabled(g_stmt_level))
58: then
59: asg_helper.log('Query :'||l_qry,'asg_defer',g_stmt_level);
60: end if;
61: l_ctx := dbms_xmlquery.newContext(l_qry);
62: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
63: l_clob := dbms_xmlquery.getXml(l_ctx);

Line 67: 'asg_defer',g_stmt_level);

63: l_clob := dbms_xmlquery.getXml(l_ctx);
64: if(asg_helper.check_is_log_enabled(g_stmt_level))
65: then
66: asg_helper.log('Raising event oracle.apps.asg.upload.datadeferred',
67: 'asg_defer',g_stmt_level);
68: end if;
69: select asg_events_s.nextval into l_seq from dual;
70: wf_event.raise(p_event_name=>'oracle.apps.asg.upload.datadeferred',
71: p_event_key=>l_seq,p_parameters=>null,

Line 76: ||'deferred','asg_defer',g_stmt_level);

72: p_event_data=>l_clob,p_send_date=>null);
73: if(asg_helper.check_is_log_enabled(g_stmt_level))
74: then
75: asg_helper.log('Successfully raised event oracle.apps.asg.upload.data'
76: ||'deferred','asg_defer',g_stmt_level);
77: end if;
78: return true;
79: exception
80: when others then

Line 81: asg_helper.log('Error raising oracle.apps.asg.upload.datadeferred :'||SQLERRM,'asg_defer',g_err_level);

77: end if;
78: return true;
79: exception
80: when others then
81: asg_helper.log('Error raising oracle.apps.asg.upload.datadeferred :'||SQLERRM,'asg_defer',g_err_level);
82: return false;
83: end raise_row_deferred;
84:
85: PROCEDURE defer_row(p_user_name IN VARCHAR2,

Line 150: 'asg_defer',g_stmt_level);

146: then
147: if(asg_helper.check_is_log_enabled(g_stmt_level))
148: then
149: asg_helper.log('Raising oracle.apps.asg.upload.datadeferred',
150: 'asg_defer',g_stmt_level);
151: end if;
152: l_bool_ret:=raise_row_deferred(p_user_name,p_tranid,p_pubitem,
153: p_sequence,l_error_msg);
154: if(asg_helper.check_is_log_enabled(g_stmt_level))

Line 157: 'asg_defer',g_stmt_level);

153: p_sequence,l_error_msg);
154: if(asg_helper.check_is_log_enabled(g_stmt_level))
155: then
156: asg_helper.log('Done raising oracle.apps.asg.upload.datadeferred',
157: 'asg_defer',g_stmt_level);
158: end if;
159: else
160: if(asg_helper.check_is_log_enabled(g_stmt_level))
161: then

Line 163: ||'since call is made from CP','asg_defer',

159: else
160: if(asg_helper.check_is_log_enabled(g_stmt_level))
161: then
162: asg_helper.log('Not Raising oracle.apps.asg.upload.datadeferred '
163: ||'since call is made from CP','asg_defer',
164: g_stmt_level);
165: end if;
166: end if;
167: else

Line 172: ||'set to ''Y''','asg_defer',g_stmt_level);

168: if(asg_helper.check_is_log_enabled(g_stmt_level))
169: then
170: asg_helper.log('Not raising oracle.apps.asg.upload.datadeferred since '
171: ||' the profile '||' ASG_ENABLE_UPLOAD_EVENTS is not '
172: ||'set to ''Y''','asg_defer',g_stmt_level);
173: end if;
174: end if;
175: -- First try to update if that fails, insert.
176: -- #$% Should use table handler

Line 177: UPDATE asg_deferred_traninfo

173: end if;
174: end if;
175: -- First try to update if that fails, insert.
176: -- #$% Should use table handler
177: UPDATE asg_deferred_traninfo
178: SET failures = failures +1, error_description = l_error_msg,
179: last_update_date = SYSDATE
180: WHERE device_user_name = p_user_name AND
181: deferred_tran_id = p_tranid AND

Line 193: INSERT INTO asg_deferred_traninfo (DEVICE_USER_NAME,

189: x_return_status := FND_API.G_RET_STS_ERROR;
190: return;
191: END IF;
192: CLOSE c_resource_id;
193: INSERT INTO asg_deferred_traninfo (DEVICE_USER_NAME,
194: RESOURCE_ID,
195: DEFERRED_TRAN_ID,
196: MOBILE_ERROR_ID,
197: ERROR_DESCRIPTION,

Line 233: 'asg_defer',g_stmt_level);

229: THEN
230: asg_helper.log('defer_row: Deferred a row for user: '|| p_user_name ||
231: ' tranid: ' || p_tranid || ' publication item: ' ||
232: p_pubitem || ' and sequence: ' || p_sequence,
233: 'asg_defer',g_stmt_level);
234: END IF;
235:
236: END defer_row;
237:

Line 258: 'asg_defer',g_stmt_level);

254: ' tranid$$ =:2';
255: IF(asg_helper.check_is_log_enabled(g_stmt_level))
256: THEN
257: asg_helper.log('purge_deferred_rows: SQL Command: ' || sql_string,
258: 'asg_defer',g_stmt_level);
259: END IF;
260: BEGIN
261: EXECUTE IMMEDIATE sql_string
262: USING p_user_name, p_tranid;

Line 270: 'asg_defer', g_err_level);

266: x_return_status := FND_API.G_RET_STS_ERROR;
267: IF(asg_helper.check_is_log_enabled(g_err_level))
268: THEN
269: asg_helper.log('purge_deferred_rows: Exception: ',
270: 'asg_defer', g_err_level);
271: END IF;
272: END;
273:
274: -- Delete any reference in asg_deferred_traninfo

Line 274: -- Delete any reference in asg_deferred_traninfo

270: 'asg_defer', g_err_level);
271: END IF;
272: END;
273:
274: -- Delete any reference in asg_deferred_traninfo
275: -- #$% Should use table handler
276: -- Should also optimize based on whether tranid is deferred or not
277: BEGIN
278: DELETE FROM asg_deferred_traninfo

Line 278: DELETE FROM asg_deferred_traninfo

274: -- Delete any reference in asg_deferred_traninfo
275: -- #$% Should use table handler
276: -- Should also optimize based on whether tranid is deferred or not
277: BEGIN
278: DELETE FROM asg_deferred_traninfo
279: WHERE device_user_name = p_user_name AND
280: deferred_tran_id = p_tranid AND
281: object_name = p_pubitem;
282: EXCEPTION

Line 288: 'asg_defer', g_err_level);

284: -- Ignore exceptions
285: IF(asg_helper.check_is_log_enabled(g_err_level))
286: THEN
287: asg_helper.log('purge_deferred_rows: Exception: ' || SQLERRM,
288: 'asg_defer', g_err_level);
289: END IF;
290: END;
291: IF(asg_helper.check_is_log_enabled(g_stmt_level))
292: THEN

Line 298: 'asg_defer',g_stmt_level);

294: 'Deleted deferred rows for user: '||
295: p_user_name ||
296: ' tranid: ' || p_tranid || ' publication item: ' ||
297: p_pubitem,
298: 'asg_defer',g_stmt_level);
299: END IF;
300: END purge_deferred_rows;
301:
302:

Line 325: 'asg_defer',g_stmt_level);

321: ' seqno$$ = :3';
322: IF(asg_helper.check_is_log_enabled(g_stmt_level))
323: THEN
324: asg_helper.log('delete_deferred_row_internal: SQL Command: ' || sql_string,
325: 'asg_defer',g_stmt_level);
326: END IF;
327: BEGIN
328: EXECUTE IMMEDIATE sql_string
329: USING p_user_name, p_tranid, p_sequence;

Line 337: 'asg_defer', g_err_level);

333: x_return_status := FND_API.G_RET_STS_ERROR;
334: IF(asg_helper.check_is_log_enabled(g_err_level))
335: THEN
336: asg_helper.log('delete_deferred_row_internal: Exception: ',
337: 'asg_defer', g_err_level);
338: END IF;
339: END;
340:
341: -- Delete any reference in asg_deferred_traninfo

Line 341: -- Delete any reference in asg_deferred_traninfo

337: 'asg_defer', g_err_level);
338: END IF;
339: END;
340:
341: -- Delete any reference in asg_deferred_traninfo
342: -- #$% Should use table handler
343: -- Should also optimize based on whether tranid is deferred or not
344: BEGIN
345: DELETE FROM asg_deferred_traninfo

Line 345: DELETE FROM asg_deferred_traninfo

341: -- Delete any reference in asg_deferred_traninfo
342: -- #$% Should use table handler
343: -- Should also optimize based on whether tranid is deferred or not
344: BEGIN
345: DELETE FROM asg_deferred_traninfo
346: WHERE device_user_name = p_user_name AND
347: deferred_tran_id = p_tranid AND
348: object_name = p_pubitem AND
349: sequence = p_sequence;

Line 356: 'asg_defer', g_err_level);

352: -- Ignore exceptions
353: IF(asg_helper.check_is_log_enabled(g_err_level))
354: THEN
355: asg_helper.log('delete_deferred_row_internal: Exception: ' || SQLERRM,
356: 'asg_defer', g_err_level);
357: END IF;
358: END;
359: IF(asg_helper.check_is_log_enabled(g_stmt_level))
360: THEN

Line 366: 'asg_defer',g_stmt_level);

362: 'Deleted a deferred row for user: '||
363: p_user_name ||
364: ' tranid: ' || p_tranid || ' publication item: ' ||
365: p_pubitem || ' and sequence: ' || p_sequence,
366: 'asg_defer',g_stmt_level);
367: END IF;
368:
369: END delete_deferred_row_internal;
370:

Line 389: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,

385: x_return_status := FND_API.G_RET_STS_ERROR;
386: return;
387: END IF;
388:
389: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,
390: p_pubitem, p_sequence);
391: -- Row is not deferred do not delete.
392: IF l_deferred_row = FND_API.G_FALSE THEN
393: IF(asg_helper.check_is_log_enabled(g_err_level))

Line 396: 'asg_defer',g_err_level);

392: IF l_deferred_row = FND_API.G_FALSE THEN
393: IF(asg_helper.check_is_log_enabled(g_err_level))
394: THEN
395: asg_helper.log('delete_deferred_row: Row is not deferred. Returning...',
396: 'asg_defer',g_err_level);
397: END IF;
398: return;
399: END IF;
400:

Line 434: 'asg_defer', g_err_level);

430: x_return_status := FND_API.G_RET_STS_ERROR;
431: IF(asg_helper.check_is_log_enabled(g_err_level))
432: THEN
433: asg_helper.log('reject_row: Error in call to markdirty',
434: 'asg_defer', g_err_level);
435: END IF;
436: RETURN;
437: END IF;
438:

Line 451: 'asg_defer',g_stmt_level);

447: THEN
448: asg_helper.log('reject_row: rejected a row for user: '|| p_user_name ||
449: ' tranid: ' || p_tranid || ' publication item: ' ||
450: p_pubitem || ' and sequence: ' || p_sequence,
451: 'asg_defer',g_stmt_level);
452: END IF;
453: END reject_row;
454:
455: -- Returns FND_API.G_TRUE if the transaction is deferred

Line 485: 'asg_defer',g_stmt_level);

481: IF(asg_helper.check_is_log_enabled(g_stmt_level))
482: THEN
483: asg_helper.log('is_deferred: ' || p_user_name || ' transaction: ' ||
484: p_tranid || ' is deferred: ' || l_retcode,
485: 'asg_defer',g_stmt_level);
486: END IF;
487: return l_retcode;
488:
489: END is_deferred;

Line 502: FROM asg_deferred_traninfo

498: l_user_name VARCHAR2(30);
499: CURSOR c_isdeferred(p_user_name VARCHAR2, p_tranid NUMBER,
500: p_pubitem VARCHAR2, p_sequence NUMBER) IS
501: SELECT device_user_name
502: FROM asg_deferred_traninfo
503: WHERE device_user_name = p_user_name AND
504: deferred_tran_id = p_tranid AND
505: object_name = p_pubitem AND
506: sequence = p_sequence;

Line 529: 'asg_defer',g_stmt_level);

525: asg_helper.log('is_deferred: ' || p_user_name || ' transaction: ' ||
526: p_tranid || ' and for publication item: ' || p_pubitem ||
527: ' and sequence: ' || p_sequence ||
528: ' is deferred: ' || l_retcode,
529: 'asg_defer',g_stmt_level);
530: END IF;
531:
532: return l_retcode;
533: END is_deferred;

Line 558: 'asg_defer',g_stmt_level);

554: IF(asg_helper.check_is_log_enabled(g_stmt_level))
555: THEN
556: asg_helper.log('discard_transaction: Setting user: '||p_user_name ||
557: ' transaction: ' || p_tranid || ' to discarded status.',
558: 'asg_defer',g_stmt_level);
559: END IF;
560: END discard_transaction;
561:
562: -- Discard the specified deferred row

Line 572: FROM asg_deferred_traninfo

568: IS
569: l_def_count PLS_INTEGER;
570: CURSOR c_deferred_discarded (p_user_name VARCHAR2, p_tranid NUMBER) IS
571: SELECT count(*) count
572: FROM asg_deferred_traninfo
573: WHERE device_user_name = p_user_name AND
574: deferred_tran_id = p_tranid;
575: BEGIN
576: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 619: FROM asg_pub a, asg_pub_item b, asg_deferred_traninfo c

615: l_orig_resp_id NUMBER;
616: l_orig_app_id NUMBER;
617: CURSOR c_pub_wrapper(p_user_name VARCHAR2, p_tranid NUMBER) IS
618: SELECT distinct a.wrapper_name, a.name
619: FROM asg_pub a, asg_pub_item b, asg_deferred_traninfo c
620: WHERE device_user_name = p_user_name AND
621: deferred_tran_id = p_tranid AND
622: c.object_name = b.name AND
623: b.pub_name = a.name

Line 627: FROM asg_deferred_traninfo

623: b.pub_name = a.name
624: ORDER BY a.name;
625: CURSOR c_deferred_processed (p_user_name VARCHAR2, p_tranid NUMBER) IS
626: SELECT count(*) count
627: FROM asg_deferred_traninfo
628: WHERE device_user_name = p_user_name AND
629: deferred_tran_id = p_tranid AND
630: status <> 0;
631: BEGIN

Line 665: 'asg_defer',g_stmt_level);

661: asg_helper.log('reapply_transaction: user: ' || p_user_name ||
662: ' transaction id: ' || p_tranid ||
663: ' current pub : ' || l_pubname ||
664: ' current pub handler: ' || l_pub_handler,
665: 'asg_defer',g_stmt_level);
666: END IF;
667: l_pubitems_tbl := asg_apply.g_empty_vc2_tbl;
668: asg_apply.get_all_pub_items(p_user_name, p_tranid, l_pubname,
669: l_pubitems_tbl, l_return_status);

Line 676: 'asg_defer',g_stmt_level);

672: (l_pubitems_tbl.count >0) THEN
673: IF(asg_helper.check_is_log_enabled(g_stmt_level))
674: THEN
675: asg_helper.log('reapply_transaction: Calling handler package',
676: 'asg_defer',g_stmt_level);
677: END IF;
678: sql_string := 'begin ' ||
679: l_pub_handler || '.apply_client_changes( ''' ||
680: p_user_name || ''',' || p_tranid || '); ' ||

Line 706: 'asg_defer',g_err_level);

702: IF(asg_helper.check_is_log_enabled(g_err_level))
703: THEN
704: asg_helper.log('reapply_transaction: Exception in ' ||
705: 'wrapper call. Check if valid wrapper exists',
706: 'asg_defer',g_err_level);
707: END IF;
708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709: fnd_global.apps_initialize(l_orig_user_id, l_orig_resp_id,
710: l_orig_app_id);

Line 718: 'asg_defer',g_stmt_level);

714: IF(asg_helper.check_is_log_enabled(g_stmt_level))
715: THEN
716: asg_helper.log('No pubitems from publication: ' ||
717: l_pubname || ' to process',
718: 'asg_defer',g_stmt_level);
719: END IF;
720: END IF;
721: END LOOP;
722: END IF;

Line 738: 'asg_defer',g_stmt_level);

734: COMMIT;
735: IF(asg_helper.check_is_log_enabled(g_stmt_level))
736: THEN
737: asg_helper.log('reapply_transaction: Done reapplying the transaction',
738: 'asg_defer',g_stmt_level);
739: END IF;
740: END reapply_transaction;
741:
742: -- Purge all the inq entries

Line 768: 'asg_defer',g_stmt_level);

764: IF(asg_helper.check_is_log_enabled(g_stmt_level))
765: THEN
766: asg_helper.log('purge_transaction: Purging user: ' || p_user_name ||
767: ' transaction: ' || p_tranid,
768: 'asg_defer',g_stmt_level);
769: END IF;
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771: asg_apply.get_all_pub_items(p_user_name, p_tranid,
772: l_pubitems_tbl, l_return_status);

Line 782: 'asg_defer',g_stmt_level);

778: IF(asg_helper.check_is_log_enabled(g_stmt_level))
779: THEN
780: asg_helper.log('purge_transaction: Purging pub item : '||
781: l_curr_pubitem || ' entries',
782: 'asg_defer',g_stmt_level);
783: END IF;
784: purge_deferred_rows(p_user_name, p_tranid,
785: l_curr_pubitem, l_return_status);
786: END LOOP;

Line 801: 'asg_defer',g_stmt_level);

797: COMMIT;
798: IF(asg_helper.check_is_log_enabled(g_stmt_level))
799: THEN
800: asg_helper.log('purge_transaction: Done purging all items in this transaction',
801: 'asg_defer',g_stmt_level);
802: END IF;
803: END purge_transaction;
804:
805: -- Delete rows in asg_deferred_traninfo/asg_users_inqinfo with no data in INQ.

Line 805: -- Delete rows in asg_deferred_traninfo/asg_users_inqinfo with no data in INQ.

801: 'asg_defer',g_stmt_level);
802: END IF;
803: END purge_transaction;
804:
805: -- Delete rows in asg_deferred_traninfo/asg_users_inqinfo with no data in INQ.
806: PROCEDURE delete_deferred(p_status OUT NOCOPY VARCHAR2,
807: p_message OUT NOCOPY VARCHAR2)
808: IS
809: CURSOR c_deferred_lines

Line 812: from asg_deferred_traninfo;

808: IS
809: CURSOR c_deferred_lines
810: IS
811: select distinct object_name
812: from asg_deferred_traninfo;
813: l_sql VARCHAR2(512);
814: l_row_count NUMBER;
815: l_inq_table_name VARCHAR2(128);
816: BEGIN

Line 820: asg_helper.log('delete_deferred: Entering asg_defer.delete_deferred.',

816: BEGIN
817:
818:
819: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
820: asg_helper.log('delete_deferred: Entering asg_defer.delete_deferred.',
821: 'asg_defer',g_stmt_level);
822: END IF;
823:
824: FOR cdl in c_deferred_lines LOOP

Line 821: 'asg_defer',g_stmt_level);

817:
818:
819: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
820: asg_helper.log('delete_deferred: Entering asg_defer.delete_deferred.',
821: 'asg_defer',g_stmt_level);
822: END IF;
823:
824: FOR cdl in c_deferred_lines LOOP
825:

Line 828: 'asg_defer',g_stmt_level);

824: FOR cdl in c_deferred_lines LOOP
825:
826: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
827: asg_helper.log('delete_deferred: Processing object: ' || cdl.object_name,
828: 'asg_defer',g_stmt_level);
829: END IF;
830:
831: l_inq_table_name := asg_base.G_OLITE_SCHEMA || '.CFM$' || cdl.object_name;
832: l_sql := 'DELETE FROM asg_deferred_traninfo ' ||

Line 832: l_sql := 'DELETE FROM asg_deferred_traninfo ' ||

828: 'asg_defer',g_stmt_level);
829: END IF;
830:
831: l_inq_table_name := asg_base.G_OLITE_SCHEMA || '.CFM$' || cdl.object_name;
832: l_sql := 'DELETE FROM asg_deferred_traninfo ' ||
833: 'WHERE object_name = :1 AND ' ||
834: '(device_user_name, deferred_tran_id, sequence) NOT IN ' ||
835: ' (SELECT clid$$cs, tranid$$, seqno$$ ' ||
836: ' FROM ' || l_inq_table_name || ' )';

Line 840: 'asg_defer',g_stmt_level);

836: ' FROM ' || l_inq_table_name || ' )';
837:
838: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
839: asg_helper.log('delete_deferred: SQL Command: ' || l_sql,
840: 'asg_defer',g_stmt_level);
841: END IF;
842:
843: EXECUTE IMMEDIATE l_sql USING cdl.object_name;
844: l_row_count := SQL%ROWCOUNT;

Line 848: 'asg_defer',g_stmt_level);

844: l_row_count := SQL%ROWCOUNT;
845:
846: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
847: asg_helper.log('delete_deferred: : Deleted ' || l_row_count || ' row(s)',
848: 'asg_defer',g_stmt_level);
849: END IF;
850:
851: -- Commit after each object.
852: COMMIT;

Line 860: FROM asg_deferred_traninfo);

856: -- Delete any deferred headers
857: DELETE FROM asg_users_inqinfo
858: WHERE (device_user_name, tranid) NOT IN
859: (SELECT device_user_name, deferred_tran_id
860: FROM asg_deferred_traninfo);
861:
862: p_status := 'Fine';
863: p_message := 'Purging deferred transaction metadata completed successfully.';
864: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN

Line 865: asg_helper.log('delete_deferred: Exiting asg_defer.delete_deferred.',

861:
862: p_status := 'Fine';
863: p_message := 'Purging deferred transaction metadata completed successfully.';
864: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
865: asg_helper.log('delete_deferred: Exiting asg_defer.delete_deferred.',
866: 'asg_defer',g_stmt_level);
867: END IF;
868: EXCEPTION
869: WHEN OTHERS THEN

Line 866: 'asg_defer',g_stmt_level);

862: p_status := 'Fine';
863: p_message := 'Purging deferred transaction metadata completed successfully.';
864: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
865: asg_helper.log('delete_deferred: Exiting asg_defer.delete_deferred.',
866: 'asg_defer',g_stmt_level);
867: END IF;
868: EXCEPTION
869: WHEN OTHERS THEN
870: p_status := 'Error';

Line 874: 'asg_defer',g_stmt_level);

870: p_status := 'Error';
871: p_message := 'Error deleting deferred transaction metadata.';
872: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
873: asg_helper.log('delete_deferred: Error Message: ' || SQLERRM,
874: 'asg_defer',g_stmt_level);
875: END IF;
876:
877: END delete_deferred;
878:

Line 879: END asg_defer;

875: END IF;
876:
877: END delete_deferred;
878:
879: END asg_defer;