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 FND_LOG

Line 7: LOG_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

3:
4: /** CONSTANTS */
5: CONS_SCHEMA CONSTANT VARCHAR2(30) := ASG_BASE.G_OLITE_SCHEMA;
6: OLITE_SEQUENCE CONSTANT VARCHAR2(30) := 'C$ALL_SEQUENCE_PARTITIONS';
7: LOG_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8:
9:
10: /** Global Variables */
11: g_clientid VARCHAR2(100);

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 1850: FND_LOG.LEVEL_STATEMENT);*/

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 '||
1854: ' ( select qid, pub_item, access_id, dml_type, '||

Line 1868: FND_LOG.LEVEL_STATEMENT);*/

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
1872: /*log_concprogram('Error deleting duplicate record from SDQ for '||

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 1889: FND_LOG.LEVEL_STATEMENT);

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 )
1893: ( SELECT user_name,pub_name ,sysdate,1,sysdate,1

Line 1902: FND_LOG.LEVEL_STATEMENT);

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: '||
1906: SQLERRM,'asg_download',

Line 1907: FND_LOG.LEVEL_UNEXPECTED);

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

Line 1923: FND_LOG.LEVEL_STATEMENT);*/

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
1927: AND pub_name = l_pub_name;

Line 1937: FND_LOG.LEVEL_STATEMENT);*/

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: '||
1941: SQLERRM,'asg_download',

Line 1942: FND_LOG.LEVEL_UNEXPECTED);*/

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

Line 2043: FND_LOG.LEVEL_STATEMENT);

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
2047: -- Later, allow customer to specify the interval via a separate

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 2262: FND_LOG.LEVEL_STATEMENT);

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:
2266: EXCEPTION

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 2374: FND_LOG.LEVEL_STATEMENT);

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
2378: log_concprogram('Synch history purge interval is set to NULL ',

Line 2380: FND_LOG.LEVEL_STATEMENT);

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',
2384: FND_LOG.LEVEL_STATEMENT);

Line 2384: FND_LOG.LEVEL_STATEMENT);

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;
2388: else

Line 2391: FND_LOG.LEVEL_STATEMENT);

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||' ';
2395: log_concprogram('Query : '||l_qry,

Line 2397: FND_LOG.LEVEL_STATEMENT);

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)',
2401: 'asg_download',

Line 2402: 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:
2406: l_row_count := 0;

Line 2431: FND_LOG.LEVEL_STATEMENT);

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;
2435: END LOOP;

Line 2440: FND_LOG.LEVEL_STATEMENT);

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',
2444: FND_LOG.LEVEL_STATEMENT);

Line 2444: FND_LOG.LEVEL_STATEMENT);

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'
2448: AND procedure_name = 'DELETE_SYNCH_HISTORY';

Line 2460: FND_LOG.LEVEL_STATEMENT);

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:
2464: procedure user_incompatibility_test(P_status OUT NOCOPY VARCHAR2,