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.AS_OPP_INITIAL_LOG_PKG dependencies on AS_LEAD_LINES_LOG

Line 98: Insert into AS_LEAD_LINES_LOG (

94: END;
95: END IF;
96: IF( UPPER(nvl(FND_PROFILE.VALUE('AS_OPP_LINE_ENABLE_LOG'), 'N')) = 'Y' ) THEN
97: BEGIN
98: Insert into AS_LEAD_LINES_LOG (
99: log_id, lead_id, lead_line_id,
100: last_update_date, last_updated_by, last_update_login, creation_date,
101: created_by, log_mode, interest_type_id, primary_interest_code_id, secondary_interest_code_id,
102: product_category_id, product_cat_set_id,

Line 105: SELECT AS_LEAD_LINES_LOG_S.NEXTVAL , a.lead_id, a.lead_line_id,

101: created_by, log_mode, interest_type_id, primary_interest_code_id, secondary_interest_code_id,
102: product_category_id, product_cat_set_id,
103: inventory_item_id, organization_id, source_promotion_id, offer_id, org_id,
104: forecast_date, rolling_forecast_flag, endday_log_flag)
105: SELECT AS_LEAD_LINES_LOG_S.NEXTVAL , a.lead_id, a.lead_line_id,
106: a.last_update_date, a.last_updated_by, a.last_update_login, a.creation_date,
107: a.created_by, 'I', a.interest_type_id, a.primary_interest_code_id, a.secondary_interest_code_id,
108: a.product_category_id, a.product_cat_set_id,
109: a.inventory_item_id, a.organization_id, a.source_promotion_id, a.offer_id, a.org_id,

Line 112: where a.lead_line_id not in ( select log.lead_line_id from AS_LEAD_LINES_LOG log);

108: a.product_category_id, a.product_cat_set_id,
109: a.inventory_item_id, a.organization_id, a.source_promotion_id, a.offer_id, a.org_id,
110: a.forecast_date , a.rolling_forecast_flag, 'Y'
111: FROM AS_LEAD_LINES_ALL a
112: where a.lead_line_id not in ( select log.lead_line_id from AS_LEAD_LINES_LOG log);
113: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_lead_lines_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
114: COMMIT;
115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: ERRBUF := ERRBUF||'Error in loging of AS_LEAD_LINES_LOG:'||to_char(sqlcode)||sqlerrm;

Line 113: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_lead_lines_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));

109: a.inventory_item_id, a.organization_id, a.source_promotion_id, a.offer_id, a.org_id,
110: a.forecast_date , a.rolling_forecast_flag, 'Y'
111: FROM AS_LEAD_LINES_ALL a
112: where a.lead_line_id not in ( select log.lead_line_id from AS_LEAD_LINES_LOG log);
113: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_lead_lines_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
114: COMMIT;
115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: ERRBUF := ERRBUF||'Error in loging of AS_LEAD_LINES_LOG:'||to_char(sqlcode)||sqlerrm;
117: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 116: ERRBUF := ERRBUF||'Error in loging of AS_LEAD_LINES_LOG:'||to_char(sqlcode)||sqlerrm;

112: where a.lead_line_id not in ( select log.lead_line_id from AS_LEAD_LINES_LOG log);
113: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_lead_lines_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
114: COMMIT;
115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: ERRBUF := ERRBUF||'Error in loging of AS_LEAD_LINES_LOG:'||to_char(sqlcode)||sqlerrm;
117: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
118: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in loging of AS_LEAD_LINES_LOG');
119: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
120: ROLLBACK;

Line 118: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in loging of AS_LEAD_LINES_LOG');

114: COMMIT;
115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: ERRBUF := ERRBUF||'Error in loging of AS_LEAD_LINES_LOG:'||to_char(sqlcode)||sqlerrm;
117: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
118: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in loging of AS_LEAD_LINES_LOG');
119: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
120: ROLLBACK;
121: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
122: IF l_status = TRUE THEN

Line 126: ERRBUF := ERRBUF||'Error in loging of AS_LEAD_LINES_LOG:'||to_char(sqlcode)||sqlerrm;

122: IF l_status = TRUE THEN
123: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Error, can not complete Concurrent Program') ;
124: END IF;
125: WHEN OTHERS THEN
126: ERRBUF := ERRBUF||'Error in loging of AS_LEAD_LINES_LOG:'||to_char(sqlcode)||sqlerrm;
127: RETCODE := '2';
128: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in loging of AS_LEAD_LINES_LOG');
129: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
130: ROLLBACK;

Line 128: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in loging of AS_LEAD_LINES_LOG');

124: END IF;
125: WHEN OTHERS THEN
126: ERRBUF := ERRBUF||'Error in loging of AS_LEAD_LINES_LOG:'||to_char(sqlcode)||sqlerrm;
127: RETCODE := '2';
128: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in loging of AS_LEAD_LINES_LOG');
129: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
130: ROLLBACK;
131: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
132: IF l_status = TRUE THEN