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_HELPER

Line 47: if(asg_helper.check_is_log_enabled(g_stmt_level))

43: l_clob clob;
44: l_seq number;
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)

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 60: if(asg_helper.check_is_log_enabled(g_stmt_level))

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
62: asg_helper.log('Query :'||l_qry,'asg_defer',g_stmt_level);
63: end if;
64: l_ctx := dbms_xmlquery.newContext(l_qry);

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 67: if(asg_helper.check_is_log_enabled(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);
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;

Line 69: asg_helper.log('Raising event oracle.apps.asg.upload.datadeferred',

65: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
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',

Line 76: if(asg_helper.check_is_log_enabled(g_stmt_level))

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

Line 78: asg_helper.log('Successfully raised event oracle.apps.asg.upload.data'

74: p_event_key=>l_seq,p_parameters=>null,
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

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 151: if(asg_helper.check_is_log_enabled(g_stmt_level))

147: if(l_prof_value = 'Y')
148: then
149: if(l_cp_run = 'N' )
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;

Line 153: asg_helper.log('Raising oracle.apps.asg.upload.datadeferred',

149: if(l_cp_run = 'N' )
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);

Line 158: if(asg_helper.check_is_log_enabled(g_stmt_level))

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))
159: then
160: asg_helper.log('Done raising oracle.apps.asg.upload.datadeferred',
161: 'asg_defer',g_stmt_level);
162: end if;

Line 160: asg_helper.log('Done raising oracle.apps.asg.upload.datadeferred',

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

Line 164: if(asg_helper.check_is_log_enabled(g_stmt_level))

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
166: asg_helper.log('Not Raising oracle.apps.asg.upload.datadeferred '
167: ||'since call is made from CP','asg_defer',
168: g_stmt_level);

Line 166: asg_helper.log('Not Raising oracle.apps.asg.upload.datadeferred '

162: end if;
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;

Line 172: if(asg_helper.check_is_log_enabled(g_stmt_level))

168: g_stmt_level);
169: end if;
170: end if;
171: else
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);

Line 174: asg_helper.log('Not raising oracle.apps.asg.upload.datadeferred since '

170: end if;
171: else
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;

Line 236: IF(asg_helper.check_is_log_enabled(g_stmt_level))

232: WHERE device_user_name = p_user_name AND
233: tranid = p_tranid;
234:
235: END IF;
236: IF(asg_helper.check_is_log_enabled(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,

Line 238: asg_helper.log('defer_row: Deferred a row for user: '|| p_user_name ||

234:
235: END IF;
236: IF(asg_helper.check_is_log_enabled(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;

Line 269: IF(asg_helper.check_is_log_enabled(g_stmt_level))

265: '.' || inq_tbl_name ||
266: ' WHERE clid$$cs = :1 AND ' ||
267: ' tranid$$ =:2';
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;

Line 271: asg_helper.log('purge_deferred_rows: SQL Command: ' || sql_string,

267: ' tranid$$ =:2';
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

Line 281: IF(asg_helper.check_is_log_enabled(g_err_level))

277: EXCEPTION
278: WHEN OTHERS THEN
279: -- Ignore exceptions
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;

Line 283: asg_helper.log('purge_deferred_rows: Exception: ',

279: -- Ignore exceptions
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:

Line 299: IF(asg_helper.check_is_log_enabled(g_err_level))

295: object_name = p_pubitem;
296: EXCEPTION
297: WHEN OTHERS THEN
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;

Line 301: asg_helper.log('purge_deferred_rows: Exception: ' || SQLERRM,

297: WHEN OTHERS THEN
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))

Line 305: IF(asg_helper.check_is_log_enabled(g_stmt_level))

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
307: asg_helper.log('purge_deferred_rows: ' ||
308: 'Deleted deferred rows for user: '||
309: p_user_name ||

Line 307: asg_helper.log('purge_deferred_rows: ' ||

303: END IF;
304: END;
305: IF(asg_helper.check_is_log_enabled(g_stmt_level))
306: THEN
307: asg_helper.log('purge_deferred_rows: ' ||
308: 'Deleted deferred rows for user: '||
309: p_user_name ||
310: ' tranid: ' || p_tranid || ' publication item: ' ||
311: p_pubitem,

Line 342: IF(asg_helper.check_is_log_enabled(g_stmt_level))

338: ' tranid$$ = :2 AND ' ||
339: ' seqno$$ = :3';
340: END IF;
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;

Line 344: asg_helper.log('delete_deferred_row_internal: SQL Command: ' || sql_string,

340: END IF;
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

Line 354: IF(asg_helper.check_is_log_enabled(g_err_level))

350: EXCEPTION
351: WHEN OTHERS THEN
352: -- Ignore exceptions
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;

Line 356: asg_helper.log('delete_deferred_row_internal: Exception: ',

352: -- Ignore exceptions
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:

Line 373: IF(asg_helper.check_is_log_enabled(g_err_level))

369: sequence = p_sequence;
370: EXCEPTION
371: WHEN OTHERS THEN
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;

Line 375: asg_helper.log('delete_deferred_row_internal: Exception: ' || SQLERRM,

371: WHEN OTHERS THEN
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))

Line 379: IF(asg_helper.check_is_log_enabled(g_stmt_level))

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
381: asg_helper.log('delete_deferred_row_internal: ' ||
382: 'Deleted a deferred row for user: '||
383: p_user_name ||

Line 381: asg_helper.log('delete_deferred_row_internal: ' ||

377: END IF;
378: END;
379: IF(asg_helper.check_is_log_enabled(g_stmt_level))
380: THEN
381: asg_helper.log('delete_deferred_row_internal: ' ||
382: 'Deleted a deferred row for user: '||
383: p_user_name ||
384: ' tranid: ' || p_tranid || ' publication item: ' ||
385: p_pubitem || ' and sequence: ' || p_sequence,

Line 413: IF(asg_helper.check_is_log_enabled(g_err_level))

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))
414: THEN
415: asg_helper.log('delete_deferred_row: Row is not deferred. Returning...',
416: 'asg_defer',g_err_level);
417: END IF;

Line 415: asg_helper.log('delete_deferred_row: Row is not deferred. Returning...',

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

Line 451: IF(asg_helper.check_is_log_enabled(g_err_level))

447: l_ret_status := asg_download.markdirty(p_pubitem, p_user_name,
448: p_tranid, p_sequence);
449: IF (l_ret_status = FALSE) THEN
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;

Line 453: asg_helper.log('reject_row: Error in call to markdirty',

449: IF (l_ret_status = FALSE) THEN
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;

Line 466: IF(asg_helper.check_is_log_enabled(g_stmt_level))

462: -- Delete the row from inq
463: asg_apply.delete_row(p_user_name, p_tranid, p_pubitem, p_sequence,
464: x_return_status);
465: END IF;
466: IF(asg_helper.check_is_log_enabled(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,

Line 468: asg_helper.log('reject_row: rejected a row for user: '|| p_user_name ||

464: x_return_status);
465: END IF;
466: IF(asg_helper.check_is_log_enabled(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;

Line 501: IF(asg_helper.check_is_log_enabled(g_stmt_level))

497: IF c_isdeferred%NOTFOUND THEN
498: l_retcode := FND_API.G_FALSE;
499: END IF;
500: CLOSE c_isdeferred;
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);

Line 503: asg_helper.log('is_deferred: ' || p_user_name || ' transaction: ' ||

499: END IF;
500: CLOSE c_isdeferred;
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;

Line 543: IF(asg_helper.check_is_log_enabled(g_stmt_level))

539: IF c_isdeferred%NOTFOUND THEN
540: l_retcode := FND_API.G_FALSE;
541: END IF;
542: CLOSE c_isdeferred;
543: IF(asg_helper.check_is_log_enabled(g_stmt_level))
544: THEN
545: asg_helper.log('is_deferred: ' || p_user_name || ' transaction: ' ||
546: p_tranid || ' and for publication item: ' || p_pubitem ||
547: ' and sequence: ' || p_sequence ||

Line 545: asg_helper.log('is_deferred: ' || p_user_name || ' transaction: ' ||

541: END IF;
542: CLOSE c_isdeferred;
543: IF(asg_helper.check_is_log_enabled(g_stmt_level))
544: THEN
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);

Line 574: IF(asg_helper.check_is_log_enabled(g_stmt_level))

570: SET deferred = 'D'
571: WHERE device_user_name = p_user_name AND
572: tranid = p_tranid;
573: COMMIT;
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);

Line 576: asg_helper.log('discard_transaction: Setting user: '||p_user_name ||

572: tranid = p_tranid;
573: COMMIT;
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;

Line 688: IF(asg_helper.check_is_log_enabled(g_stmt_level))

684: FOR curr_index in 1..l_pubs_tbl.count LOOP
685:
686: l_pubname := l_pubs_tbl(curr_index);
687: l_pub_handler := l_pubhandlers_tbl(curr_index);
688: IF(asg_helper.check_is_log_enabled(g_stmt_level))
689: THEN
690: asg_helper.log('reapply_transaction: user: ' || p_user_name ||
691: ' transaction id: ' || p_tranid ||
692: ' current pub : ' || l_pubname ||

Line 690: asg_helper.log('reapply_transaction: user: ' || p_user_name ||

686: l_pubname := l_pubs_tbl(curr_index);
687: l_pub_handler := l_pubhandlers_tbl(curr_index);
688: IF(asg_helper.check_is_log_enabled(g_stmt_level))
689: THEN
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);

Line 702: IF(asg_helper.check_is_log_enabled(g_stmt_level))

698: l_pubitems_tbl, l_return_status);
699: -- Check if there is any data for this publication
700: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
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;

Line 704: asg_helper.log('reapply_transaction: Calling handler package',

700: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
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( ''' ||

Line 731: IF(asg_helper.check_is_log_enabled(g_err_level))

727: fnd_global.apps_initialize(l_orig_user_id, l_orig_resp_id,
728: l_orig_app_id);
729: EXCEPTION
730: WHEN OTHERS THEN
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);

Line 733: asg_helper.log('reapply_transaction: Exception in ' ||

729: EXCEPTION
730: WHEN OTHERS THEN
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;

Line 743: IF(asg_helper.check_is_log_enabled(g_stmt_level))

739: l_orig_app_id);
740: return;
741: END;
742: ELSE
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);

Line 745: asg_helper.log('No pubitems from publication: ' ||

741: END;
742: ELSE
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;

Line 767: IF(asg_helper.check_is_log_enabled(g_stmt_level))

763:
764: IF p_commit_flag THEN
765: COMMIT;
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;

Line 769: asg_helper.log('reapply_transaction: Done reapplying the transaction',

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

Line 796: IF(asg_helper.check_is_log_enabled(g_stmt_level))

792: IF l_def_trans = FND_API.G_FALSE THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: return;
795: END IF;
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);

Line 798: asg_helper.log('purge_transaction: Purging user: ' || p_user_name ||

794: return;
795: END IF;
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;

Line 810: IF(asg_helper.check_is_log_enabled(g_stmt_level))

806: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
807: (l_pubitems_tbl.count >0) THEN
808: FOR curr_index in 1..l_pubitems_tbl.count LOOP
809: l_curr_pubitem := l_pubitems_tbl(curr_index);
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);

Line 812: asg_helper.log('purge_transaction: Purging pub item : '||

808: FOR curr_index in 1..l_pubitems_tbl.count LOOP
809: l_curr_pubitem := l_pubitems_tbl(curr_index);
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,

Line 830: IF(asg_helper.check_is_log_enabled(g_stmt_level))

826:
827: DELETE FROM asg_users_inqinfo
828: WHERE device_user_name = p_user_name AND tranid = p_tranid;
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;

Line 832: asg_helper.log('purge_transaction: Done purging all items in this transaction',

828: WHERE device_user_name = p_user_name AND tranid = p_tranid;
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:

Line 854: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN

850: l_inq_table_name VARCHAR2(128);
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:

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 861: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN

857: END IF;
858:
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

Line 862: asg_helper.log('delete_deferred: Processing object: ' || cdl.object_name,

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

Line 875: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN

871: ' (SELECT clid$$cs, tranid$$, seqno$$ ' ||
872: ' FROM ' || l_inq_table_name || ' )';
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:

Line 876: asg_helper.log('delete_deferred: SQL Command: ' || l_sql,

872: ' FROM ' || l_inq_table_name || ' )';
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;

Line 887: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN

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,
889: 'asg_defer',g_stmt_level);
890: END IF;
891:

Line 888: asg_helper.log('delete_deferred: for the PIV that is disabled ' || cdl.object_name,

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,
889: 'asg_defer',g_stmt_level);
890: END IF;
891:
892: END IF;

Line 894: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN

890: END IF;
891:
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:

Line 895: asg_helper.log('delete_deferred: : Deleted ' || l_row_count || ' row(s)',

891:
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.

Line 914: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN

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

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 922: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN

918: EXCEPTION
919: WHEN OTHERS THEN
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:

Line 923: asg_helper.log('delete_deferred: Error Message: ' || SQLERRM,

919: WHEN OTHERS THEN
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;