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

40: l_clob clob;
41: l_seq number;
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)

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

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

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

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

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

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

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

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

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

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

143: if(l_prof_value = 'Y')
144: then
145: if(l_cp_run = 'N' )
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;

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

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

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

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))
155: then
156: asg_helper.log('Done raising oracle.apps.asg.upload.datadeferred',
157: 'asg_defer',g_stmt_level);
158: end if;

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

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

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

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

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

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

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

164: g_stmt_level);
165: end if;
166: end if;
167: else
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);

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

166: end if;
167: else
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;

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

224: WHERE device_user_name = p_user_name AND
225: tranid = p_tranid;
226: END IF;
227: COMMIT;
228: IF(asg_helper.check_is_log_enabled(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,

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

226: END IF;
227: COMMIT;
228: IF(asg_helper.check_is_log_enabled(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;

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

251: sql_string := 'DELETE FROM '|| asg_base.G_OLITE_SCHEMA ||
252: '.' || inq_tbl_name ||
253: ' WHERE clid$$cs = :1 AND ' ||
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;

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

253: ' WHERE clid$$cs = :1 AND ' ||
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

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

263: EXCEPTION
264: WHEN OTHERS THEN
265: -- Ignore exceptions
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;

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

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

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

281: object_name = p_pubitem;
282: EXCEPTION
283: WHEN OTHERS THEN
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;

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

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

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

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
293: asg_helper.log('purge_deferred_rows: ' ||
294: 'Deleted deferred rows for user: '||
295: p_user_name ||

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

289: END IF;
290: END;
291: IF(asg_helper.check_is_log_enabled(g_stmt_level))
292: THEN
293: asg_helper.log('purge_deferred_rows: ' ||
294: 'Deleted deferred rows for user: '||
295: p_user_name ||
296: ' tranid: ' || p_tranid || ' publication item: ' ||
297: p_pubitem,

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

318: '.' || inq_tbl_name ||
319: ' WHERE clid$$cs = :1 AND ' ||
320: ' tranid$$ = :2 AND ' ||
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;

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

320: ' tranid$$ = :2 AND ' ||
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

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

330: EXCEPTION
331: WHEN OTHERS THEN
332: -- Ignore exceptions
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;

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

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

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

349: sequence = p_sequence;
350: EXCEPTION
351: WHEN OTHERS THEN
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;

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

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

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

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
361: asg_helper.log('delete_deferred_row_internal: ' ||
362: 'Deleted a deferred row for user: '||
363: p_user_name ||

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

357: END IF;
358: END;
359: IF(asg_helper.check_is_log_enabled(g_stmt_level))
360: THEN
361: asg_helper.log('delete_deferred_row_internal: ' ||
362: 'Deleted a deferred row for user: '||
363: p_user_name ||
364: ' tranid: ' || p_tranid || ' publication item: ' ||
365: p_pubitem || ' and sequence: ' || p_sequence,

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

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))
394: THEN
395: asg_helper.log('delete_deferred_row: Row is not deferred. Returning...',
396: 'asg_defer',g_err_level);
397: END IF;

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

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

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

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

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

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

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

442: -- Delete the row from inq
443: asg_apply.delete_row(p_user_name, p_tranid, p_pubitem, p_sequence,
444: x_return_status);
445: END IF;
446: IF(asg_helper.check_is_log_enabled(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,

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

444: x_return_status);
445: END IF;
446: IF(asg_helper.check_is_log_enabled(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;

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

477: IF c_isdeferred%NOTFOUND THEN
478: l_retcode := FND_API.G_FALSE;
479: END IF;
480: CLOSE c_isdeferred;
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);

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

479: END IF;
480: CLOSE c_isdeferred;
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;

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

519: IF c_isdeferred%NOTFOUND THEN
520: l_retcode := FND_API.G_FALSE;
521: END IF;
522: CLOSE c_isdeferred;
523: IF(asg_helper.check_is_log_enabled(g_stmt_level))
524: THEN
525: asg_helper.log('is_deferred: ' || p_user_name || ' transaction: ' ||
526: p_tranid || ' and for publication item: ' || p_pubitem ||
527: ' and sequence: ' || p_sequence ||

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

521: END IF;
522: CLOSE c_isdeferred;
523: IF(asg_helper.check_is_log_enabled(g_stmt_level))
524: THEN
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);

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

550: SET deferred = 'D'
551: WHERE device_user_name = p_user_name AND
552: tranid = p_tranid;
553: COMMIT;
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);

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

552: tranid = p_tranid;
553: COMMIT;
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;

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

655: FOR curr_index in 1..l_pubs_tbl.count LOOP
656:
657: l_pubname := l_pubs_tbl(curr_index);
658: l_pub_handler := l_pubhandlers_tbl(curr_index);
659: IF(asg_helper.check_is_log_enabled(g_stmt_level))
660: THEN
661: asg_helper.log('reapply_transaction: user: ' || p_user_name ||
662: ' transaction id: ' || p_tranid ||
663: ' current pub : ' || l_pubname ||

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

657: l_pubname := l_pubs_tbl(curr_index);
658: l_pub_handler := l_pubhandlers_tbl(curr_index);
659: IF(asg_helper.check_is_log_enabled(g_stmt_level))
660: THEN
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);

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

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

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

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

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

698: fnd_global.apps_initialize(l_orig_user_id, l_orig_resp_id,
699: l_orig_app_id);
700: EXCEPTION
701: WHEN OTHERS THEN
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);

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

700: EXCEPTION
701: WHEN OTHERS THEN
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;

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

710: l_orig_app_id);
711: return;
712: END;
713: ELSE
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);

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

712: END;
713: ELSE
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;

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

731: WHERE device_user_name = p_user_name AND
732: tranid = p_tranid;
733: END IF;
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;

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

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

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

760: IF l_def_trans = FND_API.G_FALSE THEN
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: return;
763: END IF;
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);

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

762: return;
763: END IF;
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;

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

774: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
775: (l_pubitems_tbl.count >0) THEN
776: FOR curr_index in 1..l_pubitems_tbl.count LOOP
777: l_curr_pubitem := l_pubitems_tbl(curr_index);
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);

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

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

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

794:
795: DELETE FROM asg_users_inqinfo
796: WHERE device_user_name = p_user_name AND tranid = p_tranid;
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;

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

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

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

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

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

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

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

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

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

834: '(device_user_name, deferred_tran_id, sequence) NOT IN ' ||
835: ' (SELECT clid$$cs, tranid$$, seqno$$ ' ||
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:

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

835: ' (SELECT clid$$cs, tranid$$, seqno$$ ' ||
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;

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

842:
843: EXECUTE IMMEDIATE l_sql USING cdl.object_name;
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:

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

843: EXECUTE IMMEDIATE l_sql USING cdl.object_name;
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.

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

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
865: asg_helper.log('delete_deferred: Exiting asg_defer.delete_deferred.',
866: 'asg_defer',g_stmt_level);
867: END IF;
868: EXCEPTION

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

868: EXCEPTION
869: WHEN OTHERS THEN
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:

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

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