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_DOWNLOAD dependencies on ASG_DOWNLOAD

Line 1: PACKAGE BODY asg_download AS

1: PACKAGE BODY asg_download AS
2: /* $Header: asgdwldb.pls 120.10.12020000.5 2013/04/09 11:56:11 saradhak ship $*/
3:
4: /** CONSTANTS */
5: CONS_SCHEMA CONSTANT VARCHAR2(30) := ASG_BASE.G_OLITE_SCHEMA;

Line 69: ' transaction_id , asg_download.get_pk(pub_item,sdq.qid) pk_val, '||

65: ' and pub_item in ( select item_id from asg_pub_item '||
66: ' where nvl(enable_download_events,''N'') = ''Y'' )'||
67: ' UNION ALL '||
68: ' select client_id,pub_item,access_id,dml_type, '||
69: ' transaction_id , asg_download.get_pk(pub_item,sdq.qid) pk_val, '||
70: ' sysdate synch_time '||
71: ' from asg_system_dirty_queue sdq,asg_delete_queue dq '||
72: ' where download_flag=''Y'' and client_id=asg_base.get_user_name'||
73: ' and transaction_id = asg_base.get_current_tranid '||

Line 94: log('Raising event oracle.apps.asg.download.datasynched');

90: l_ctx := dbms_xmlquery.newContext(l_qry);
91: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
92: l_clob := dbms_xmlquery.getXml(l_ctx);
93: log('Finished building clob. Num of records :'||l_ct);
94: log('Raising event oracle.apps.asg.download.datasynched');
95: select asg_events_s.nextval into l_seq from dual;
96: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynched',
97: p_event_key=>l_seq,p_parameters=>null,
98: p_event_data=>l_clob,p_send_date=>null);

Line 96: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynched',

92: l_clob := dbms_xmlquery.getXml(l_ctx);
93: log('Finished building clob. Num of records :'||l_ct);
94: log('Raising event oracle.apps.asg.download.datasynched');
95: select asg_events_s.nextval into l_seq from dual;
96: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynched',
97: p_event_key=>l_seq,p_parameters=>null,
98: p_event_data=>l_clob,p_send_date=>null);
99: log('Successfully raised event oracle.apps.asg.download.datasynched');
100: else

Line 99: log('Successfully raised event oracle.apps.asg.download.datasynched');

95: select asg_events_s.nextval into l_seq from dual;
96: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynched',
97: p_event_key=>l_seq,p_parameters=>null,
98: p_event_data=>l_clob,p_send_date=>null);
99: log('Successfully raised event oracle.apps.asg.download.datasynched');
100: else
101: log('No data to raise the event oracle.apps.asg.download.datasynched');
102: end if;
103: log('End raise_data_downloaded');

Line 101: log('No data to raise the event oracle.apps.asg.download.datasynched');

97: p_event_key=>l_seq,p_parameters=>null,
98: p_event_data=>l_clob,p_send_date=>null);
99: log('Successfully raised event oracle.apps.asg.download.datasynched');
100: else
101: log('No data to raise the event oracle.apps.asg.download.datasynched');
102: end if;
103: log('End raise_data_downloaded');
104: return true;
105: exception

Line 107: log('Error raising event oracle.apps.asg.download.datasynched');

103: log('End raise_data_downloaded');
104: return true;
105: exception
106: when others then
107: log('Error raising event oracle.apps.asg.download.datasynched');
108: return false;
109: end raise_data_downloaded;
110:
111:

Line 134: ' curr_tran_id, asg_download.get_pk(pub_item,sdq.qid) pk_val, '||

130: ' where nvl(enable_download_events,''N'') = ''Y'' )'||
131: ' UNION ALL '||
132: ' select client_id,pub_item,access_id,dml_type, '||
133: ' transaction_id last_tran_id,asg_base.get_current_tranid '||
134: ' curr_tran_id, asg_download.get_pk(pub_item,sdq.qid) pk_val, '||
135: ' sysdate synch_time '||
136: ' from asg_system_dirty_queue sdq,asg_delete_queue dq '||
137: ' where download_flag=''Y'' and client_id=asg_base.get_user_name'||
138: ' and transaction_id <= asg_base.get_last_tranid '||

Line 159: log('Raising event oracle.apps.asg.download.datasynchconfirmed');

155: l_ctx := dbms_xmlquery.newContext(l_qry);
156: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
157: l_clob := dbms_xmlquery.getXml(l_ctx);
158: log('Finished building clob. Num of records :'||l_ct);
159: log('Raising event oracle.apps.asg.download.datasynchconfirmed');
160: select asg_events_s.nextval into l_seq from dual;
161: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynchconfirmed',
162: p_event_key=>l_seq,p_parameters=>null,
163: p_event_data=>l_clob,p_send_date=>null);

Line 161: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynchconfirmed',

157: l_clob := dbms_xmlquery.getXml(l_ctx);
158: log('Finished building clob. Num of records :'||l_ct);
159: log('Raising event oracle.apps.asg.download.datasynchconfirmed');
160: select asg_events_s.nextval into l_seq from dual;
161: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynchconfirmed',
162: p_event_key=>l_seq,p_parameters=>null,
163: p_event_data=>l_clob,p_send_date=>null);
164: log('Successfully raised event oracle.apps.asg.download.datasynchconfirmed');
165: else

Line 164: log('Successfully raised event oracle.apps.asg.download.datasynchconfirmed');

160: select asg_events_s.nextval into l_seq from dual;
161: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynchconfirmed',
162: p_event_key=>l_seq,p_parameters=>null,
163: p_event_data=>l_clob,p_send_date=>null);
164: log('Successfully raised event oracle.apps.asg.download.datasynchconfirmed');
165: else
166: log('No data to raise the event oracle.apps.asg.download.datasynchconfirmed');
167: end if;
168: log('End raise_data_download_confirmed');

Line 166: log('No data to raise the event oracle.apps.asg.download.datasynchconfirmed');

162: p_event_key=>l_seq,p_parameters=>null,
163: p_event_data=>l_clob,p_send_date=>null);
164: log('Successfully raised event oracle.apps.asg.download.datasynchconfirmed');
165: else
166: log('No data to raise the event oracle.apps.asg.download.datasynchconfirmed');
167: end if;
168: log('End raise_data_download_confirmed');
169: return true;
170: exception

Line 172: log('Error raising event oracle.apps.asg.download.datasynchconfirmed');

168: log('End raise_data_download_confirmed');
169: return true;
170: exception
171: when others then
172: log('Error raising event oracle.apps.asg.download.datasynchconfirmed');
173: return false;
174: end raise_data_download_confirmed;
175:
176:

Line 1604: asg_helper.log(p_mesg, 'asg_download', FND_LOG.LEVEL_STATEMENT);

1600: PROCEDURE log (p_mesg VARCHAR2 ) IS
1601: BEGIN
1602: IF(asg_helper.check_is_log_enabled(LOG_LEVEL))
1603: THEN
1604: asg_helper.log(p_mesg, 'asg_download', FND_LOG.LEVEL_STATEMENT);
1605: END IF;
1606: END log;
1607:
1608:

Line 1849: 'asg_download',

1845: EXECUTE IMMEDIATE l_dml USING l_user_name;
1846: l_count := SQL%ROWCOUNT;
1847: /* log_concprogram('Removed '||l_count||' duplicate rows from Delete queue '||
1848: ' for user : '||l_user_name,
1849: 'asg_download',
1850: FND_LOG.LEVEL_STATEMENT);*/
1851: -- delete from asg_system_dirty_queue
1852: l_dml := 'Delete /*+ INDEX(asg_system_dirty_queue ASG_SYSTEM_DIRTY_QUEUE_U1) */ from asg_system_dirty_queue where qid in '||
1853: ' ( Select qid from '||

Line 1867: 'asg_download',

1863: EXECUTE IMMEDIATE l_dml USING l_user_name;
1864: l_count := SQL%ROWCOUNT;
1865: /*log_concprogram('Removed '||l_count||' duplicate rows from Dirty queue '||
1866: ' for user : '||l_user_name,
1867: 'asg_download',
1868: FND_LOG.LEVEL_STATEMENT);*/
1869: commit;
1870: EXCEPTION
1871: WHEN OTHERS THEN

Line 1874: 'asg_download',FND_LOG.LEVEL_UNEXPECTED);*/

1870: EXCEPTION
1871: WHEN OTHERS THEN
1872: /*log_concprogram('Error deleting duplicate record from SDQ for '||
1873: l_user_name||' : '||SQLERRM,
1874: 'asg_download',FND_LOG.LEVEL_UNEXPECTED);*/
1875: rollback;
1876: -- raise;
1877: END delete_duplicate_records;
1878:

Line 1888: l_user_name,'asg_download',

1884: is
1885: PRAGMA autonomous_transaction;
1886: BEGIN
1887: log_concprogram('Setting user '||l_user_name ||' to first synch '||
1888: l_user_name,'asg_download',
1889: FND_LOG.LEVEL_STATEMENT);
1890:
1891: INSERT INTO asg_purge_sdq(user_name,pub_name,creation_date,created_by,
1892: last_update_date,last_updated_by )

Line 1901: l_user_name,'asg_download',

1897: (select name from asg_pub where nvl(custom,'N') = 'N' )
1898: );
1899: commit;
1900: log_concprogram('Done setting user '||l_user_name ||' to first synch '||
1901: l_user_name,'asg_download',
1902: FND_LOG.LEVEL_STATEMENT);
1903: EXCEPTION
1904: WHEN OTHERS then
1905: log_concprogram('Error setting user '||l_user_name||' to first synch: '||

Line 1906: SQLERRM,'asg_download',

1902: FND_LOG.LEVEL_STATEMENT);
1903: EXCEPTION
1904: WHEN OTHERS then
1905: log_concprogram('Error setting user '||l_user_name||' to first synch: '||
1906: SQLERRM,'asg_download',
1907: FND_LOG.LEVEL_UNEXPECTED);
1908: rollback;
1909: raise;
1910: END set_user_first_synch;

Line 1922: l_user_name,'asg_download',

1918: PRAGMA autonomous_transaction;
1919: l_count NUMBER;
1920: BEGIN
1921: /*log_concprogram('Setting user '||l_user_name ||' to first synch '||
1922: l_user_name,'asg_download',
1923: FND_LOG.LEVEL_STATEMENT);*/
1924: SELECT COUNT(*) INTO l_count
1925: FROM asg_purge_sdq
1926: WHERE user_name = l_user_name

Line 1936: l_user_name,'asg_download',

1932: VALUES (l_user_name,l_pub_name,sysdate,1,sysdate,1);
1933: commit;
1934: END IF;
1935: /*log_concprogram('Done setting user '||l_user_name ||' to first synch '||
1936: l_user_name,'asg_download',
1937: FND_LOG.LEVEL_STATEMENT);*/
1938: EXCEPTION
1939: WHEN OTHERS THEN
1940: /*log_concprogram('Error setting user '||l_user_name||' to first synch: '||

Line 1941: SQLERRM,'asg_download',

1937: FND_LOG.LEVEL_STATEMENT);*/
1938: EXCEPTION
1939: WHEN OTHERS THEN
1940: /*log_concprogram('Error setting user '||l_user_name||' to first synch: '||
1941: SQLERRM,'asg_download',
1942: FND_LOG.LEVEL_UNEXPECTED);*/
1943: ROLLBACK;
1944: --raise;
1945: END set_user_first_synch_pub;

Line 2042: log_concprogram('Start SDQ purge ','asg_download',

2038: l_purge_conf_interval NUMBER := 30;
2039: l_date date;
2040: l_total NUMBER;
2041: BEGIN
2042: log_concprogram('Start SDQ purge ','asg_download',
2043: FND_LOG.LEVEL_STATEMENT);
2044: l_final_user := null;
2045:
2046: -- Fix to 3536657

Line 2062: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2058: fnd_profile.VALUE('ASG_SDQ_PURGE_USER_COUNT');
2059: if(l_max_users is null )
2060: then
2061: log_concprogram('Profile ASG: Purge User Count is set to null. Exiting',
2062: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2063: log_concprogram('Please set the profile ASG: Purge User Count to a '||
2064: 'non-null value and resubmit the concurrent program',
2065: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2066: P_status := 'Warning';

Line 2065: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2061: log_concprogram('Profile ASG: Purge User Count is set to null. Exiting',
2062: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2063: log_concprogram('Please set the profile ASG: Purge User Count to a '||
2064: 'non-null value and resubmit the concurrent program',
2065: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2066: P_status := 'Warning';
2067: p_message := 'Profile ASG: Purge User Count is set to null';
2068: return;
2069: end if;

Line 2071: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2067: p_message := 'Profile ASG: Purge User Count is set to null';
2068: return;
2069: end if;
2070: log_concprogram('Number of users to be processed : '||l_max_users,
2071: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2072:
2073: if(l_dormancy_period is null )
2074: then
2075: log_concprogram('Profile ASG: Dormancy Period is set to null. Exiting',

Line 2076: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2072:
2073: if(l_dormancy_period is null )
2074: then
2075: log_concprogram('Profile ASG: Dormancy Period is set to null. Exiting',
2076: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2077: log_concprogram('Please set the profile ASG: Dormancy Period to a '||
2078: 'non-null value and resubmit the concurrent program',
2079: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2080: P_status := 'Warning';

Line 2079: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2075: log_concprogram('Profile ASG: Dormancy Period is set to null. Exiting',
2076: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2077: log_concprogram('Please set the profile ASG: Dormancy Period to a '||
2078: 'non-null value and resubmit the concurrent program',
2079: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2080: P_status := 'Warning';
2081: p_message := 'Profile ASG: Dormancy Period is set to null';
2082: return;
2083: end if;

Line 2085: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2081: p_message := 'Profile ASG: Dormancy Period is set to null';
2082: return;
2083: end if;
2084: log_concprogram('Dormancy period : '||l_dormancy_period,
2085: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2086:
2087:
2088: OPEN c_last_processed_dupdel_user;
2089: FETCH c_last_processed_dupdel_user INTO l_last_dupdel_user;

Line 2104: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2100: THEN
2101: l_last_dupdel_user := to_char(0);
2102: log_concprogram('Last user hit for deleting duplicates..'||
2103: 'starting from first user',
2104: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2105:
2106: END if;
2107: CLOSE c_all_users;
2108: END IF;

Line 2115: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2111: l_last_user := null;
2112: SELECT SYSDATE INTO l_date FROM dual;
2113: log_concprogram('Starting to delete duplicate records : '||
2114: to_char(l_date,'dd-mon-yyyy hh24:mi:ss'),
2115: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2116: OPEN c_all_users(l_last_dupdel_user,l_max_users);
2117: LOOP
2118: FETCH c_all_users INTO l_user_name;
2119: EXIT WHEN c_all_users%NOTFOUND;

Line 2124: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2120: l_last_user := l_user_name;
2121: SELECT SYSDATE INTO l_date FROM dual;
2122: log_concprogram('Deleting duplicate records for '||l_user_name||' : '||
2123: to_char(l_date,'dd-mon-yyyy hh24:mi:ss'),
2124: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2125: delete_duplicate_records(l_user_name);
2126: END loop;
2127: CLOSE c_all_users;
2128:

Line 2136: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2132:
2133: SELECT SYSDATE INTO l_date FROM dual;
2134: log_concprogram('End of deleting duplicate records'||' : '||
2135: to_char(l_date,'dd-mon-yyyy hh24:mi:ss'),
2136: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2137:
2138: OPEN c_last_processed_user();
2139: FETCH c_last_processed_user INTO l_last_processed_user;
2140: CLOSE c_last_processed_user;

Line 2156: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2152: IF(c_get_last_user%NOTFOUND) --we have hit last user.so reset to to_char(0)
2153: THEN
2154: l_last_processed_user := to_char(0);
2155: log_concprogram('Last user hit..starting from first user',
2156: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2157:
2158: END if;
2159: CLOSE c_get_last_user;
2160: END IF;

Line 2164: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2160: END IF;
2161:
2162: log_concprogram('Last User to be processed in previous run : '||
2163: l_last_processed_user,
2164: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2165:
2166: -- get last user
2167: OPEN c_get_last_user(l_dormancy_period,l_last_processed_user,l_max_users);
2168: FETCH c_get_last_user INTO l_final_user;

Line 2181: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2177: OPEN c_get_count(l_dormancy_period,l_last_processed_user);
2178: FETCH c_get_count INTO l_total;
2179: CLOSE c_get_count;
2180: log_concprogram('Processing : '||l_total||' users',
2181: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2182:
2183: OPEN c_get_last_user(l_dormancy_period,l_last_processed_user,l_total);
2184: FETCH c_get_last_user INTO l_final_user;
2185: CLOSE c_get_last_user;

Line 2189: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2185: CLOSE c_get_last_user;
2186: END IF;
2187:
2188: log_concprogram('Final user processed in this run : '||l_final_user,
2189: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2190:
2191: l_tmp_user := null;
2192: l_last_user := null;
2193: OPEN c_dormant_users(l_dormancy_period,l_last_processed_user,

Line 2202: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2198: l_last_user := l_dormant_rec.user_name;
2199: log_concprogram('Purging SDQ for dormant user : '||
2200: l_dormant_rec.user_name||' and publication :'||
2201: l_dormant_rec.pub_name,
2202: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2203: BEGIN
2204: DELETE /*+ INDEX(asg_delete_queue ASG_DELETE_QUEUE_U1) */ FROM
2205: asg_delete_queue
2206: WHERE qid IN

Line 2216: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2212: WHERE pub_name=l_dormant_rec.pub_name));
2213:
2214: log_concprogram('Done deleting DQ for '||l_tmp_user||' '||
2215: SQL%ROWCOUNT||' rows',
2216: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2217:
2218:
2219: DELETE FROM asg_system_dirty_queue
2220: WHERE client_id = l_dormant_rec.user_name

Line 2226: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2222: (SELECT item_id FROM asg_pub_item
2223: WHERE pub_name=l_dormant_rec.pub_name);
2224: log_concprogram('Done deleting SDQ for '||l_tmp_user||' '||
2225: SQL%ROWCOUNT||' rows',
2226: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2227:
2228: DELETE FROM asg_complete_refresh
2229: WHERE user_name = l_dormant_rec.user_name
2230: AND publication_item IN

Line 2248: 'asg_download',FND_LOG.LEVEL_STATEMENT);

2244: END LOOP;
2245: CLOSE c_dormant_users;
2246:
2247: log_concprogram('Last user to be processed in this run : '||l_last_user,
2248: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2249:
2250: UPDATE asg_config
2251: SET value = nvl(l_last_user,value)
2252: WHERE NAME ='ASG_SDQ_PURGE_LAST_USER';

Line 2257: WHERE package_name = 'ASG_DOWNLOAD'

2253: commit;
2254:
2255: UPDATE jtm_con_request_data
2256: SET last_run_date = SYSDATE
2257: WHERE package_name = 'ASG_DOWNLOAD'
2258: AND procedure_name = 'DELETE_SDQ';
2259: COMMIT;
2260:
2261: log_concprogram('End SDQ purge ','asg_download',

Line 2261: log_concprogram('End SDQ purge ','asg_download',

2257: WHERE package_name = 'ASG_DOWNLOAD'
2258: AND procedure_name = 'DELETE_SDQ';
2259: COMMIT;
2260:
2261: log_concprogram('End SDQ purge ','asg_download',
2262: FND_LOG.LEVEL_STATEMENT);
2263: p_status := 'Fine';
2264: p_message := 'Purging asg_system_dirty_queue and asg_delete_queue completed successfully.';
2265:

Line 2271: 'asg_download',FND_LOG.LEVEL_UNEXPECTED);

2267: WHEN OTHERS THEN
2268: p_status := 'Error';
2269: p_message := 'Exception in purge :'||SQLERRM;
2270: log_concprogram('Exception in purge :'||SQLERRM,
2271: 'asg_download',FND_LOG.LEVEL_UNEXPECTED);
2272: END delete_Sdq;
2273:
2274: /*
2275: function to verify whether record shd be inserted into SDQ or not

Line 2373: 'asg_download',

2369: l_purge_session_data session_id_list;
2370: c_hist c_purge_session;
2371: BEGIN
2372: log_concprogram('Starting to purge synch history data',
2373: 'asg_download',
2374: FND_LOG.LEVEL_STATEMENT);
2375: l_purge_interval := fnd_profile.VALUE('ASG_SYNCH_HIST_PURGE_PERIOD');
2376: if( l_purge_interval is null )
2377: then

Line 2379: 'asg_download',

2375: l_purge_interval := fnd_profile.VALUE('ASG_SYNCH_HIST_PURGE_PERIOD');
2376: if( l_purge_interval is null )
2377: then
2378: log_concprogram('Synch history purge interval is set to NULL ',
2379: 'asg_download',
2380: FND_LOG.LEVEL_STATEMENT);
2381: log_concprogram('Please set profile ASG:Synch Histoy Purge Period to '||
2382: 'a non-null value and resubmit the concurrent program',
2383: 'asg_download',

Line 2383: 'asg_download',

2379: 'asg_download',
2380: FND_LOG.LEVEL_STATEMENT);
2381: log_concprogram('Please set profile ASG:Synch Histoy Purge Period to '||
2382: 'a non-null value and resubmit the concurrent program',
2383: 'asg_download',
2384: FND_LOG.LEVEL_STATEMENT);
2385: P_status := 'Warning';
2386: p_message := 'Profile ASG:Synch Histoy Purge Period is set to null';
2387: return;

Line 2390: 'asg_download',

2386: p_message := 'Profile ASG:Synch Histoy Purge Period is set to null';
2387: return;
2388: else
2389: log_concprogram('Synch history purge interval : '||l_purge_interval,
2390: 'asg_download',
2391: FND_LOG.LEVEL_STATEMENT);
2392:
2393: /*l_qry := 'delete from '||CONS_SCHEMA||'.'||'c$sync_history where '
2394: ||' (sysdate-start_time) > '||l_purge_interval||' ';

Line 2396: 'asg_download',

2392:
2393: /*l_qry := 'delete from '||CONS_SCHEMA||'.'||'c$sync_history where '
2394: ||' (sysdate-start_time) > '||l_purge_interval||' ';
2395: log_concprogram('Query : '||l_qry,
2396: 'asg_download',
2397: FND_LOG.LEVEL_STATEMENT);
2398: EXECUTE IMMEDIATE l_qry;
2399: l_row_count := SQL%ROWCOUNT;
2400: log_concprogram('Deleted '||l_row_count||' row(s)',

Line 2401: 'asg_download',

2397: FND_LOG.LEVEL_STATEMENT);
2398: EXECUTE IMMEDIATE l_qry;
2399: l_row_count := SQL%ROWCOUNT;
2400: log_concprogram('Deleted '||l_row_count||' row(s)',
2401: 'asg_download',
2402: FND_LOG.LEVEL_STATEMENT);
2403: COMMIT;
2404: */
2405:

Line 2430: 'asg_download',

2426: EXCEPTION
2427: WHEN others THEN
2428: log_concprogram
2429: ('Error occured when deleting from sync history table: ' ||SQLERRM ,
2430: 'asg_download',
2431: FND_LOG.LEVEL_STATEMENT);
2432: end;
2433: commit;
2434: END IF;

Line 2439: 'asg_download',

2435: END LOOP;
2436: close c_hist;
2437:
2438: log_concprogram('Deleted '||l_row_count||' row(s)',
2439: 'asg_download',
2440: FND_LOG.LEVEL_STATEMENT);
2441:
2442: log_concprogram('Done purging synch history data',
2443: 'asg_download',

Line 2443: 'asg_download',

2439: 'asg_download',
2440: FND_LOG.LEVEL_STATEMENT);
2441:
2442: log_concprogram('Done purging synch history data',
2443: 'asg_download',
2444: FND_LOG.LEVEL_STATEMENT);
2445: UPDATE jtm_con_request_data
2446: SET last_run_date = SYSDATE
2447: WHERE package_name = 'ASG_DOWNLOAD'

Line 2447: WHERE package_name = 'ASG_DOWNLOAD'

2443: 'asg_download',
2444: FND_LOG.LEVEL_STATEMENT);
2445: UPDATE jtm_con_request_data
2446: SET last_run_date = SYSDATE
2447: WHERE package_name = 'ASG_DOWNLOAD'
2448: AND procedure_name = 'DELETE_SYNCH_HISTORY';
2449: COMMIT;
2450:
2451: p_status := 'Fine';

Line 2459: 'asg_download',

2455: when others then
2456: p_status := 'Error';
2457: p_message := 'Error purging synch history data '||SQLERRM;
2458: log_concprogram('Error purging synch history data '||SQLERRM,
2459: 'asg_download',
2460: FND_LOG.LEVEL_STATEMENT);
2461: END delete_synch_history;
2462:
2463:

Line 2567: END asg_download;

2563: log('Error identifying user incompatibility information'||SQLERRM);
2564:
2565: end user_incompatibility_test;
2566:
2567: END asg_download;