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_SALES_CREDITS

Line 139: Insert into AS_SALES_CREDITS_LOG ( log_id,

135: END;
136: END IF;
137: IF( UPPER(nvl(FND_PROFILE.VALUE('AS_OPP_SC_ENABLE_LOG'), 'N')) = 'Y' ) THEN
138: BEGIN
139: Insert into AS_SALES_CREDITS_LOG ( log_id,
140: lead_id, lead_line_id, sales_credit_id, last_update_date,
141: last_updated_by, last_update_login, creation_date, created_by,
142: log_mode, salesforce_id, salesgroup_id, credit_type_id,
143: credit_percent, credit_amount, endday_log_flag)

Line 149: FROM AS_SALES_CREDITS

145: lead_id, lead_line_id, sales_credit_id, last_update_date,
146: last_updated_by, last_update_login, creation_date, created_by,
147: 'I', salesforce_id, salesgroup_id, credit_type_id,
148: credit_percent, credit_amount, 'Y'
149: FROM AS_SALES_CREDITS
150: where AS_SALES_CREDITS.sales_credit_id not in (select AS_SALES_CREDITS_LOG.sales_credit_id
151: FROM AS_SALES_CREDITS_LOG);
152: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_sales_credits_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
153: COMMIT;

Line 150: where AS_SALES_CREDITS.sales_credit_id not in (select AS_SALES_CREDITS_LOG.sales_credit_id

146: last_updated_by, last_update_login, creation_date, created_by,
147: 'I', salesforce_id, salesgroup_id, credit_type_id,
148: credit_percent, credit_amount, 'Y'
149: FROM AS_SALES_CREDITS
150: where AS_SALES_CREDITS.sales_credit_id not in (select AS_SALES_CREDITS_LOG.sales_credit_id
151: FROM AS_SALES_CREDITS_LOG);
152: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_sales_credits_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
153: COMMIT;
154: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 151: FROM AS_SALES_CREDITS_LOG);

147: 'I', salesforce_id, salesgroup_id, credit_type_id,
148: credit_percent, credit_amount, 'Y'
149: FROM AS_SALES_CREDITS
150: where AS_SALES_CREDITS.sales_credit_id not in (select AS_SALES_CREDITS_LOG.sales_credit_id
151: FROM AS_SALES_CREDITS_LOG);
152: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_sales_credits_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
153: COMMIT;
154: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: ERRBUF := ERRBUF||'Error in login of AS_SALES_CREDITS_LOG:'||to_char(sqlcode)||sqlerrm;

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

148: credit_percent, credit_amount, 'Y'
149: FROM AS_SALES_CREDITS
150: where AS_SALES_CREDITS.sales_credit_id not in (select AS_SALES_CREDITS_LOG.sales_credit_id
151: FROM AS_SALES_CREDITS_LOG);
152: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_sales_credits_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
153: COMMIT;
154: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: ERRBUF := ERRBUF||'Error in login of AS_SALES_CREDITS_LOG:'||to_char(sqlcode)||sqlerrm;
156: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 155: ERRBUF := ERRBUF||'Error in login of AS_SALES_CREDITS_LOG:'||to_char(sqlcode)||sqlerrm;

151: FROM AS_SALES_CREDITS_LOG);
152: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_sales_credits_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
153: COMMIT;
154: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: ERRBUF := ERRBUF||'Error in login of AS_SALES_CREDITS_LOG:'||to_char(sqlcode)||sqlerrm;
156: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
157: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in login of AS_SALES_CREDITS_LOG');
158: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
159: ROLLBACK;

Line 157: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in login of AS_SALES_CREDITS_LOG');

153: COMMIT;
154: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: ERRBUF := ERRBUF||'Error in login of AS_SALES_CREDITS_LOG:'||to_char(sqlcode)||sqlerrm;
156: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
157: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in login of AS_SALES_CREDITS_LOG');
158: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
159: ROLLBACK;
160: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
161: IF l_status = TRUE THEN

Line 165: ERRBUF := ERRBUF||'Error in login of AS_SALES_CREDITS_LOG:'||to_char(sqlcode)||sqlerrm;

161: IF l_status = TRUE THEN
162: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Error, can not complete Concurrent Program') ;
163: END IF;
164: WHEN OTHERS THEN
165: ERRBUF := ERRBUF||'Error in login of AS_SALES_CREDITS_LOG:'||to_char(sqlcode)||sqlerrm;
166: RETCODE := '2';
167: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in login of AS_SALES_CREDITS_LOG');
168: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
169: ROLLBACK;

Line 167: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in login of AS_SALES_CREDITS_LOG');

163: END IF;
164: WHEN OTHERS THEN
165: ERRBUF := ERRBUF||'Error in login of AS_SALES_CREDITS_LOG:'||to_char(sqlcode)||sqlerrm;
166: RETCODE := '2';
167: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in login of AS_SALES_CREDITS_LOG');
168: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
169: ROLLBACK;
170: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
171: IF l_status = TRUE THEN