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.5.12010000.2 2008/11/14 09:50:52 trajasek 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 1851: 'asg_download',

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

Line 1869: 'asg_download',

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

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

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

Line 1890: l_user_name,'asg_download',

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

Line 1903: l_user_name,'asg_download',

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

Line 1908: SQLERRM,'asg_download',

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

Line 1924: l_user_name,'asg_download',

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

Line 1938: l_user_name,'asg_download',

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

Line 1943: SQLERRM,'asg_download',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2259: WHERE package_name = 'ASG_DOWNLOAD'

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

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

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

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

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

Line 2375: 'asg_download',

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

Line 2381: 'asg_download',

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

Line 2385: 'asg_download',

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

Line 2392: 'asg_download',

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

Line 2398: 'asg_download',

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

Line 2403: 'asg_download',

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

Line 2432: 'asg_download',

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

Line 2441: 'asg_download',

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

Line 2445: 'asg_download',

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

Line 2449: WHERE package_name = 'ASG_DOWNLOAD'

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

Line 2461: 'asg_download',

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

Line 2569: END asg_download;

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