APPS.AS_VALIDATE_SETUP dependencies on OE_SALES_CREDIT_TYPES

Line 295: (select 1 from OE_SALES_CREDIT_TYPES osct

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
298: WHEN OTHERS THEN
299: l_count := 0;

Line 309: ||' defined in OE_SALES_CREDIT_TYPES');

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, ' ');
312: Write_Log(l_module, 'Success: all salesrep in RA_SALESREPS_ALL have valid sales credit type');
313: END IF;