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

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

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

Line 1870: FND_LOG.LEVEL_STATEMENT);*/

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

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

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

Line 1904: FND_LOG.LEVEL_STATEMENT);

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

Line 1909: FND_LOG.LEVEL_UNEXPECTED);

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

Line 1925: FND_LOG.LEVEL_STATEMENT);*/

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

Line 1939: FND_LOG.LEVEL_STATEMENT);*/

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

Line 1944: FND_LOG.LEVEL_UNEXPECTED);*/

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

Line 2045: FND_LOG.LEVEL_STATEMENT);

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

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

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

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

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

Line 2382: FND_LOG.LEVEL_STATEMENT);

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

Line 2386: FND_LOG.LEVEL_STATEMENT);

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

Line 2393: FND_LOG.LEVEL_STATEMENT);

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

Line 2399: FND_LOG.LEVEL_STATEMENT);

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

Line 2404: 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:
2408: l_row_count := 0;

Line 2433: FND_LOG.LEVEL_STATEMENT);

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

Line 2442: FND_LOG.LEVEL_STATEMENT);

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

Line 2446: FND_LOG.LEVEL_STATEMENT);

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

Line 2462: FND_LOG.LEVEL_STATEMENT);

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