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.5.12020000.2 2013/04/09 11:55:59 saradhak ship $*/
3:
4: -- DESCRIPTION
5: -- This package supports deferred transactions.

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

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

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

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

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

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

Line 70: 'asg_defer',g_stmt_level);

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

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

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

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

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

Line 154: 'asg_defer',g_stmt_level);

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

Line 161: 'asg_defer',g_stmt_level);

157: p_sequence,l_error_msg);
158: if(asg_helper.check_is_log_enabled(g_stmt_level))
159: then
160: asg_helper.log('Done raising oracle.apps.asg.upload.datadeferred',
161: 'asg_defer',g_stmt_level);
162: end if;
163: else
164: if(asg_helper.check_is_log_enabled(g_stmt_level))
165: then

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

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

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

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

Line 181: UPDATE asg_deferred_traninfo

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

Line 199: INSERT INTO asg_deferred_traninfo (DEVICE_USER_NAME,

195: COMMIT;
196: return;
197: END IF;
198: CLOSE c_resource_id;
199: INSERT INTO asg_deferred_traninfo (DEVICE_USER_NAME,
200: RESOURCE_ID,
201: DEFERRED_TRAN_ID,
202: MOBILE_ERROR_ID,
203: ERROR_DESCRIPTION,

Line 241: 'asg_defer',g_stmt_level);

237: THEN
238: asg_helper.log('defer_row: Deferred a row for user: '|| p_user_name ||
239: ' tranid: ' || p_tranid || ' publication item: ' ||
240: p_pubitem || ' and sequence: ' || p_sequence,
241: 'asg_defer',g_stmt_level);
242: END IF;
243: COMMIT;
244: END defer_row;
245:

Line 272: 'asg_defer',g_stmt_level);

268: END IF;
269: IF(asg_helper.check_is_log_enabled(g_stmt_level))
270: THEN
271: asg_helper.log('purge_deferred_rows: SQL Command: ' || sql_string,
272: 'asg_defer',g_stmt_level);
273: END IF;
274: BEGIN
275: EXECUTE IMMEDIATE sql_string
276: USING p_user_name, p_tranid;

Line 284: 'asg_defer', g_err_level);

280: x_return_status := FND_API.G_RET_STS_ERROR;
281: IF(asg_helper.check_is_log_enabled(g_err_level))
282: THEN
283: asg_helper.log('purge_deferred_rows: Exception: ',
284: 'asg_defer', g_err_level);
285: END IF;
286: END;
287:
288: -- Delete any reference in asg_deferred_traninfo

Line 288: -- Delete any reference in asg_deferred_traninfo

284: 'asg_defer', g_err_level);
285: END IF;
286: END;
287:
288: -- Delete any reference in asg_deferred_traninfo
289: -- #$% Should use table handler
290: -- Should also optimize based on whether tranid is deferred or not
291: BEGIN
292: DELETE FROM asg_deferred_traninfo

Line 292: DELETE FROM asg_deferred_traninfo

288: -- Delete any reference in asg_deferred_traninfo
289: -- #$% Should use table handler
290: -- Should also optimize based on whether tranid is deferred or not
291: BEGIN
292: DELETE FROM asg_deferred_traninfo
293: WHERE device_user_name = p_user_name AND
294: deferred_tran_id = p_tranid AND
295: object_name = p_pubitem;
296: EXCEPTION

Line 302: 'asg_defer', g_err_level);

298: -- Ignore exceptions
299: IF(asg_helper.check_is_log_enabled(g_err_level))
300: THEN
301: asg_helper.log('purge_deferred_rows: Exception: ' || SQLERRM,
302: 'asg_defer', g_err_level);
303: END IF;
304: END;
305: IF(asg_helper.check_is_log_enabled(g_stmt_level))
306: THEN

Line 312: 'asg_defer',g_stmt_level);

308: 'Deleted deferred rows for user: '||
309: p_user_name ||
310: ' tranid: ' || p_tranid || ' publication item: ' ||
311: p_pubitem,
312: 'asg_defer',g_stmt_level);
313: END IF;
314: END purge_deferred_rows;
315:
316:

Line 345: 'asg_defer',g_stmt_level);

341:
342: IF(asg_helper.check_is_log_enabled(g_stmt_level))
343: THEN
344: asg_helper.log('delete_deferred_row_internal: SQL Command: ' || sql_string,
345: 'asg_defer',g_stmt_level);
346: END IF;
347: BEGIN
348: EXECUTE IMMEDIATE sql_string
349: USING p_user_name, p_tranid, p_sequence;

Line 357: 'asg_defer', g_err_level);

353: x_return_status := FND_API.G_RET_STS_ERROR;
354: IF(asg_helper.check_is_log_enabled(g_err_level))
355: THEN
356: asg_helper.log('delete_deferred_row_internal: Exception: ',
357: 'asg_defer', g_err_level);
358: END IF;
359: END;
360:
361: -- Delete any reference in asg_deferred_traninfo

Line 361: -- Delete any reference in asg_deferred_traninfo

357: 'asg_defer', g_err_level);
358: END IF;
359: END;
360:
361: -- Delete any reference in asg_deferred_traninfo
362: -- #$% Should use table handler
363: -- Should also optimize based on whether tranid is deferred or not
364: BEGIN
365: DELETE FROM asg_deferred_traninfo

Line 365: DELETE FROM asg_deferred_traninfo

361: -- Delete any reference in asg_deferred_traninfo
362: -- #$% Should use table handler
363: -- Should also optimize based on whether tranid is deferred or not
364: BEGIN
365: DELETE FROM asg_deferred_traninfo
366: WHERE device_user_name = p_user_name AND
367: deferred_tran_id = p_tranid AND
368: object_name = p_pubitem AND
369: sequence = p_sequence;

Line 376: 'asg_defer', g_err_level);

372: -- Ignore exceptions
373: IF(asg_helper.check_is_log_enabled(g_err_level))
374: THEN
375: asg_helper.log('delete_deferred_row_internal: Exception: ' || SQLERRM,
376: 'asg_defer', g_err_level);
377: END IF;
378: END;
379: IF(asg_helper.check_is_log_enabled(g_stmt_level))
380: THEN

Line 386: 'asg_defer',g_stmt_level);

382: 'Deleted a deferred row for user: '||
383: p_user_name ||
384: ' tranid: ' || p_tranid || ' publication item: ' ||
385: p_pubitem || ' and sequence: ' || p_sequence,
386: 'asg_defer',g_stmt_level);
387: END IF;
388:
389: END delete_deferred_row_internal;
390:

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

405: x_return_status := FND_API.G_RET_STS_ERROR;
406: return;
407: END IF;
408:
409: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,
410: p_pubitem, p_sequence);
411: -- Row is not deferred do not delete.
412: IF l_deferred_row = FND_API.G_FALSE THEN
413: IF(asg_helper.check_is_log_enabled(g_err_level))

Line 416: 'asg_defer',g_err_level);

412: IF l_deferred_row = FND_API.G_FALSE THEN
413: IF(asg_helper.check_is_log_enabled(g_err_level))
414: THEN
415: asg_helper.log('delete_deferred_row: Row is not deferred. Returning...',
416: 'asg_defer',g_err_level);
417: END IF;
418: return;
419: END IF;
420:

Line 454: 'asg_defer', g_err_level);

450: x_return_status := FND_API.G_RET_STS_ERROR;
451: IF(asg_helper.check_is_log_enabled(g_err_level))
452: THEN
453: asg_helper.log('reject_row: Error in call to markdirty',
454: 'asg_defer', g_err_level);
455: END IF;
456: RETURN;
457: END IF;
458:

Line 471: 'asg_defer',g_stmt_level);

467: THEN
468: asg_helper.log('reject_row: rejected a row for user: '|| p_user_name ||
469: ' tranid: ' || p_tranid || ' publication item: ' ||
470: p_pubitem || ' and sequence: ' || p_sequence,
471: 'asg_defer',g_stmt_level);
472: END IF;
473: END reject_row;
474:
475: -- Returns FND_API.G_TRUE if the transaction is deferred

Line 505: 'asg_defer',g_stmt_level);

501: IF(asg_helper.check_is_log_enabled(g_stmt_level))
502: THEN
503: asg_helper.log('is_deferred: ' || p_user_name || ' transaction: ' ||
504: p_tranid || ' is deferred: ' || l_retcode,
505: 'asg_defer',g_stmt_level);
506: END IF;
507: return l_retcode;
508:
509: END is_deferred;

Line 522: FROM asg_deferred_traninfo

518: l_user_name VARCHAR2(100);
519: CURSOR c_isdeferred(p_user_name VARCHAR2, p_tranid NUMBER,
520: p_pubitem VARCHAR2, p_sequence NUMBER) IS
521: SELECT device_user_name
522: FROM asg_deferred_traninfo
523: WHERE device_user_name = p_user_name AND
524: deferred_tran_id = p_tranid AND
525: object_name = p_pubitem AND
526: sequence = p_sequence;

Line 549: 'asg_defer',g_stmt_level);

545: asg_helper.log('is_deferred: ' || p_user_name || ' transaction: ' ||
546: p_tranid || ' and for publication item: ' || p_pubitem ||
547: ' and sequence: ' || p_sequence ||
548: ' is deferred: ' || l_retcode,
549: 'asg_defer',g_stmt_level);
550: END IF;
551:
552: return l_retcode;
553: END is_deferred;

Line 578: 'asg_defer',g_stmt_level);

574: IF(asg_helper.check_is_log_enabled(g_stmt_level))
575: THEN
576: asg_helper.log('discard_transaction: Setting user: '||p_user_name ||
577: ' transaction: ' || p_tranid || ' to discarded status.',
578: 'asg_defer',g_stmt_level);
579: END IF;
580: END discard_transaction;
581:
582: -- Discard the specified deferred row

Line 593: FROM asg_deferred_traninfo

589: IS
590: l_def_count PLS_INTEGER;
591: CURSOR c_deferred_discarded (p_user_name VARCHAR2, p_tranid NUMBER) IS
592: SELECT count(*) count
593: FROM asg_deferred_traninfo
594: WHERE device_user_name = p_user_name AND
595: deferred_tran_id = p_tranid;
596: BEGIN
597: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

639: l_orig_resp_id NUMBER;
640: l_orig_app_id NUMBER;
641: CURSOR c_pub_wrapper(p_user_name VARCHAR2, p_tranid NUMBER) IS
642: SELECT distinct a.wrapper_name, a.name
643: FROM asg_pub a, asg_pub_item b, asg_deferred_traninfo c
644: WHERE device_user_name = p_user_name AND
645: deferred_tran_id = p_tranid AND
646: c.object_name = b.name AND
647: b.pub_name = a.name

Line 651: FROM asg_deferred_traninfo

647: b.pub_name = a.name
648: ORDER BY a.name;
649: CURSOR c_deferred_processed (p_user_name VARCHAR2, p_tranid NUMBER) IS
650: SELECT count(*) count
651: FROM asg_deferred_traninfo
652: WHERE device_user_name = p_user_name AND
653: deferred_tran_id = p_tranid AND
654: status <> 0;
655: BEGIN

Line 694: 'asg_defer',g_stmt_level);

690: asg_helper.log('reapply_transaction: user: ' || p_user_name ||
691: ' transaction id: ' || p_tranid ||
692: ' current pub : ' || l_pubname ||
693: ' current pub handler: ' || l_pub_handler,
694: 'asg_defer',g_stmt_level);
695: END IF;
696: l_pubitems_tbl := asg_apply.g_empty_vc2_tbl;
697: asg_apply.get_all_pub_items(p_user_name, p_tranid, l_pubname,
698: l_pubitems_tbl, l_return_status);

Line 705: 'asg_defer',g_stmt_level);

701: (l_pubitems_tbl.count >0) THEN
702: IF(asg_helper.check_is_log_enabled(g_stmt_level))
703: THEN
704: asg_helper.log('reapply_transaction: Calling handler package',
705: 'asg_defer',g_stmt_level);
706: END IF;
707: sql_string := 'begin ' ||
708: l_pub_handler || '.apply_client_changes( ''' ||
709: p_user_name || ''',' || p_tranid || '); ' ||

Line 735: 'asg_defer',g_err_level);

731: IF(asg_helper.check_is_log_enabled(g_err_level))
732: THEN
733: asg_helper.log('reapply_transaction: Exception in ' ||
734: 'wrapper call. Check if valid wrapper exists',
735: 'asg_defer',g_err_level);
736: END IF;
737: x_return_status := FND_API.G_RET_STS_SUCCESS;
738: fnd_global.apps_initialize(l_orig_user_id, l_orig_resp_id,
739: l_orig_app_id);

Line 747: 'asg_defer',g_stmt_level);

743: IF(asg_helper.check_is_log_enabled(g_stmt_level))
744: THEN
745: asg_helper.log('No pubitems from publication: ' ||
746: l_pubname || ' to process',
747: 'asg_defer',g_stmt_level);
748: END IF;
749: END IF;
750: END LOOP;
751: END IF;

Line 770: 'asg_defer',g_stmt_level);

766: END IF;
767: IF(asg_helper.check_is_log_enabled(g_stmt_level))
768: THEN
769: asg_helper.log('reapply_transaction: Done reapplying the transaction',
770: 'asg_defer',g_stmt_level);
771: END IF;
772: END reapply_transaction;
773:
774: -- Purge all the inq entries

Line 800: 'asg_defer',g_stmt_level);

796: IF(asg_helper.check_is_log_enabled(g_stmt_level))
797: THEN
798: asg_helper.log('purge_transaction: Purging user: ' || p_user_name ||
799: ' transaction: ' || p_tranid,
800: 'asg_defer',g_stmt_level);
801: END IF;
802: x_return_status := FND_API.G_RET_STS_SUCCESS;
803: asg_apply.get_all_pub_items(p_user_name, p_tranid,
804: l_pubitems_tbl, l_return_status);

Line 814: 'asg_defer',g_stmt_level);

810: IF(asg_helper.check_is_log_enabled(g_stmt_level))
811: THEN
812: asg_helper.log('purge_transaction: Purging pub item : '||
813: l_curr_pubitem || ' entries',
814: 'asg_defer',g_stmt_level);
815: END IF;
816: purge_deferred_rows(p_user_name, p_tranid,
817: l_curr_pubitem, l_return_status);
818: END LOOP;

Line 833: 'asg_defer',g_stmt_level);

829: COMMIT;
830: IF(asg_helper.check_is_log_enabled(g_stmt_level))
831: THEN
832: asg_helper.log('purge_transaction: Done purging all items in this transaction',
833: 'asg_defer',g_stmt_level);
834: END IF;
835: END purge_transaction;
836:
837: -- Delete rows in asg_deferred_traninfo/asg_users_inqinfo with no data in INQ.

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

833: 'asg_defer',g_stmt_level);
834: END IF;
835: END purge_transaction;
836:
837: -- Delete rows in asg_deferred_traninfo/asg_users_inqinfo with no data in INQ.
838: PROCEDURE delete_deferred(p_status OUT NOCOPY VARCHAR2,
839: p_message OUT NOCOPY VARCHAR2)
840: IS
841: CURSOR c_deferred_lines

Line 844: from asg_deferred_traninfo def,

840: IS
841: CURSOR c_deferred_lines
842: IS
843: select distinct def.object_name,pub.enabled
844: from asg_deferred_traninfo def,
845: asg_pub_item pub
846: where pub.item_id = def.object_name;
847:
848: l_sql VARCHAR2(512);

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

851: BEGIN
852:
853:
854: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
855: asg_helper.log('delete_deferred: Entering asg_defer.delete_deferred.',
856: 'asg_defer',g_stmt_level);
857: END IF;
858:
859: FOR cdl in c_deferred_lines LOOP

Line 856: 'asg_defer',g_stmt_level);

852:
853:
854: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
855: asg_helper.log('delete_deferred: Entering asg_defer.delete_deferred.',
856: 'asg_defer',g_stmt_level);
857: END IF;
858:
859: FOR cdl in c_deferred_lines LOOP
860:

Line 863: 'asg_defer',g_stmt_level);

859: FOR cdl in c_deferred_lines LOOP
860:
861: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
862: asg_helper.log('delete_deferred: Processing object: ' || cdl.object_name,
863: 'asg_defer',g_stmt_level);
864: END IF;
865: IF cdl.enabled = 'Y' THEN
866:
867: l_inq_table_name := asg_base.G_OLITE_SCHEMA || '.CFM$' || cdl.object_name;

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

864: END IF;
865: IF cdl.enabled = 'Y' THEN
866:
867: l_inq_table_name := asg_base.G_OLITE_SCHEMA || '.CFM$' || cdl.object_name;
868: l_sql := 'DELETE FROM asg_deferred_traninfo ' ||
869: 'WHERE object_name = :1 AND ' ||
870: '(device_user_name, deferred_tran_id, sequence) NOT IN ' ||
871: ' (SELECT clid$$cs, tranid$$, seqno$$ ' ||
872: ' FROM ' || l_inq_table_name || ' )';

Line 877: 'asg_defer',g_stmt_level);

873:
874:
875: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
876: asg_helper.log('delete_deferred: SQL Command: ' || l_sql,
877: 'asg_defer',g_stmt_level);
878: END IF;
879:
880: EXECUTE IMMEDIATE l_sql USING cdl.object_name;
881: l_row_count := SQL%ROWCOUNT;

Line 883: ELSE --For disable pub items blindly delete from asg deferred traninfo table

879:
880: EXECUTE IMMEDIATE l_sql USING cdl.object_name;
881: l_row_count := SQL%ROWCOUNT;
882:
883: ELSE --For disable pub items blindly delete from asg deferred traninfo table
884: DELETE FROM asg_deferred_traninfo WHERE object_name = cdl.object_name;
885: l_row_count := SQL%ROWCOUNT;
886:
887: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN

Line 884: DELETE FROM asg_deferred_traninfo WHERE object_name = cdl.object_name;

880: EXECUTE IMMEDIATE l_sql USING cdl.object_name;
881: l_row_count := SQL%ROWCOUNT;
882:
883: ELSE --For disable pub items blindly delete from asg deferred traninfo table
884: DELETE FROM asg_deferred_traninfo WHERE object_name = cdl.object_name;
885: l_row_count := SQL%ROWCOUNT;
886:
887: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
888: asg_helper.log('delete_deferred: for the PIV that is disabled ' || cdl.object_name,

Line 889: 'asg_defer',g_stmt_level);

885: l_row_count := SQL%ROWCOUNT;
886:
887: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
888: asg_helper.log('delete_deferred: for the PIV that is disabled ' || cdl.object_name,
889: 'asg_defer',g_stmt_level);
890: END IF;
891:
892: END IF;
893:

Line 896: 'asg_defer',g_stmt_level);

892: END IF;
893:
894: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
895: asg_helper.log('delete_deferred: : Deleted ' || l_row_count || ' row(s)',
896: 'asg_defer',g_stmt_level);
897: END IF;
898:
899: -- Commit after each object.
900: COMMIT;

Line 908: FROM asg_deferred_traninfo);

904: -- Delete any deferred headers
905: DELETE FROM asg_users_inqinfo
906: WHERE (device_user_name, tranid) NOT IN
907: (SELECT device_user_name, deferred_tran_id
908: FROM asg_deferred_traninfo);
909:
910: COMMIT;
911:
912: p_status := 'Fine';

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

911:
912: p_status := 'Fine';
913: p_message := 'Purging deferred transaction metadata completed successfully.';
914: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
915: asg_helper.log('delete_deferred: Exiting asg_defer.delete_deferred.',
916: 'asg_defer',g_stmt_level);
917: END IF;
918: EXCEPTION
919: WHEN OTHERS THEN

Line 916: 'asg_defer',g_stmt_level);

912: p_status := 'Fine';
913: p_message := 'Purging deferred transaction metadata completed successfully.';
914: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
915: asg_helper.log('delete_deferred: Exiting asg_defer.delete_deferred.',
916: 'asg_defer',g_stmt_level);
917: END IF;
918: EXCEPTION
919: WHEN OTHERS THEN
920: p_status := 'Error';

Line 924: 'asg_defer',g_stmt_level);

920: p_status := 'Error';
921: p_message := 'Error deleting deferred transaction metadata.';
922: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
923: asg_helper.log('delete_deferred: Error Message: ' || SQLERRM,
924: 'asg_defer',g_stmt_level);
925: END IF;
926:
927: END delete_deferred;
928:

Line 929: END asg_defer;

925: END IF;
926:
927: END delete_deferred;
928:
929: END asg_defer;