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_VALIDATE_SETUP dependencies on RA_SALESREPS_ALL

Line 293: SELECT count(*) INTO l_count FROM RA_SALESREPS_ALL rrep

289: Write_Log(l_module, 'Success: no invalid Contact Relation in AS_CONTACT_FAMILY');
290: END IF;
291:
292: BEGIN
293: SELECT count(*) INTO l_count FROM RA_SALESREPS_ALL rrep
294: WHERE not exists
295: (select 1 from OE_SALES_CREDIT_TYPES osct
296: where rrep.sales_credit_type_id = osct.sales_credit_type_id);
297: EXCEPTION

Line 307: ||'): bad data found in RA_SALESREPS_ALL');

303: l_err_num := l_err_num+1;
304: l_err_total := l_err_total+1;
305: Write_Log(l_module, ' ');
306: Write_Log(l_module, 'Error('||to_char(l_err_total)
307: ||'): bad data found in RA_SALESREPS_ALL');
308: Write_Log(l_module, 'The sales_credit_type of the salesrep must be'
309: ||' defined in OE_SALES_CREDIT_TYPES');
310: ELSE
311: Write_Log(l_module, ' ');

Line 312: Write_Log(l_module, 'Success: all salesrep in RA_SALESREPS_ALL have valid sales credit type');

308: Write_Log(l_module, 'The sales_credit_type of the salesrep must be'
309: ||' defined in OE_SALES_CREDIT_TYPES');
310: ELSE
311: Write_Log(l_module, ' ');
312: Write_Log(l_module, 'Success: all salesrep in RA_SALESREPS_ALL have valid sales credit type');
313: END IF;
314:
315: BEGIN
316: SELECT count(*) INTO l_count FROM RA_SALESREPS_ALL

Line 316: SELECT count(*) INTO l_count FROM RA_SALESREPS_ALL

312: Write_Log(l_module, 'Success: all salesrep in RA_SALESREPS_ALL have valid sales credit type');
313: END IF;
314:
315: BEGIN
316: SELECT count(*) INTO l_count FROM RA_SALESREPS_ALL
317: WHERE (start_date_active > end_date_active
318: AND start_date_active is not null
319: AND end_date_active is not null)
320: OR (start_date_active is null

Line 331: ||'): bad data found in RA_SALESREPS_ALL');

327: l_err_num := l_err_num+1;
328: l_err_total := l_err_total+1;
329: Write_Log(l_module, ' ');
330: Write_Log(l_module, 'Error('||to_char(l_err_total)
331: ||'): bad data found in RA_SALESREPS_ALL');
332: Write_Log(l_module, 'The start_date_active of the salesrep must earlier '
333: ||'than the end_date_active');
334: ELSE
335: Write_Log(l_module, ' ');

Line 336: Write_Log(l_module, 'Success: all salesrep in RA_SALESREPS_ALL have '

332: Write_Log(l_module, 'The start_date_active of the salesrep must earlier '
333: ||'than the end_date_active');
334: ELSE
335: Write_Log(l_module, ' ');
336: Write_Log(l_module, 'Success: all salesrep in RA_SALESREPS_ALL have '
337: ||'valid active date');
338: END IF;
339:
340: BEGIN

Line 342: from RA_SALESREPS_ALL

338: END IF;
339:
340: BEGIN
341: SELECT count(*) INTO l_count FROM (select salesrep_number
342: from RA_SALESREPS_ALL
343: group by salesrep_number having count(1) > 1);
344: EXCEPTION
345: WHEN OTHERS THEN
346: l_count := 0;

Line 353: ||'): found duplicate SALESREP_NUMBER in RA_SALESREPS_ALL');

349: l_err_num := l_err_num+1;
350: l_err_total := l_err_total+1;
351: Write_Log(l_module, ' ');
352: Write_Log(l_module, 'Error('||to_char(l_err_total)
353: ||'): found duplicate SALESREP_NUMBER in RA_SALESREPS_ALL');
354: ELSE
355: Write_Log(l_module, ' ');
356: Write_Log(l_module, 'Success: no duplicate SALESREP_NUMBER found '
357: ||'in RA_SALESREPS_ALL');

Line 357: ||'in RA_SALESREPS_ALL');

353: ||'): found duplicate SALESREP_NUMBER in RA_SALESREPS_ALL');
354: ELSE
355: Write_Log(l_module, ' ');
356: Write_Log(l_module, 'Success: no duplicate SALESREP_NUMBER found '
357: ||'in RA_SALESREPS_ALL');
358: END IF;
359:
360: /* BEGIN
361: SELECT count(*) INTO l_count