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 AS_SALES_GRP_ADMIN

Line 384: FROM AS_SALES_GRP_ADMIN sga

380: END IF;*/
381:
382: BEGIN
383: SELECT count(*) INTO l_count
384: FROM AS_SALES_GRP_ADMIN sga
385: WHERE not exists
386: ( select 1 from PER_ALL_PEOPLE_F per
387: where per.person_id = sga.person_id )
388: and not exists

Line 401: ||' in AS_SALES_GRP_ADMIN');

397: l_err_total := l_err_total+1;
398: Write_Log(l_module, ' ');
399: Write_Log(l_module, 'Error('||to_char(l_err_total)
400: ||'): found record(s) with invalid person_id/salesforce_id'
401: ||' in AS_SALES_GRP_ADMIN');
402: ELSE
403: Write_Log(l_module, ' ');
404: Write_Log(l_module, 'Success: records in AS_SALES_GRP_ADMIN'
405: ||' having valid person_id/salesforce_id');

Line 404: Write_Log(l_module, 'Success: records in AS_SALES_GRP_ADMIN'

400: ||'): found record(s) with invalid person_id/salesforce_id'
401: ||' in AS_SALES_GRP_ADMIN');
402: ELSE
403: Write_Log(l_module, ' ');
404: Write_Log(l_module, 'Success: records in AS_SALES_GRP_ADMIN'
405: ||' having valid person_id/salesforce_id');
406: END IF;
407:
408: BEGIN

Line 410: FROM AS_SALES_GRP_ADMIN a, AS_SALESFORCE b

406: END IF;
407:
408: BEGIN
409: SELECT count(*) INTO l_count
410: FROM AS_SALES_GRP_ADMIN a, AS_SALESFORCE b
411: WHERE a.salesforce_id <> b.salesforce_id
412: and a.person_id = b.employee_person_id
413: and b.type = 'EMPLOYEE';
414: EXCEPTION

Line 423: ||'): Dangling FK to AS_SALESFORCE found in AS_SALES_GRP_ADMIN');

419: l_err_num := l_err_num+1;
420: l_err_total := l_err_total+1;
421: Write_Log(l_module, ' ');
422: Write_Log(l_module, 'Error('||to_char(l_err_total)
423: ||'): Dangling FK to AS_SALESFORCE found in AS_SALES_GRP_ADMIN');
424: ELSE
425: Write_Log(l_module, ' ');
426: Write_Log(l_module, 'Success: salesforce_id in AS_SALES_GRP_ADMIN'
427: ||' exists in AS_SALESFORCE');

Line 426: Write_Log(l_module, 'Success: salesforce_id in AS_SALES_GRP_ADMIN'

422: Write_Log(l_module, 'Error('||to_char(l_err_total)
423: ||'): Dangling FK to AS_SALESFORCE found in AS_SALES_GRP_ADMIN');
424: ELSE
425: Write_Log(l_module, ' ');
426: Write_Log(l_module, 'Success: salesforce_id in AS_SALES_GRP_ADMIN'
427: ||' exists in AS_SALESFORCE');
428: END IF;
429:
430: /* BEGIN

Line 432: FROM AS_SALES_GRP_ADMIN sga

428: END IF;
429:
430: /* BEGIN
431: SELECT count(*) INTO l_count
432: FROM AS_SALES_GRP_ADMIN sga
433: WHERE not exists
434: ( select 1 from AS_SALES_GROUPS sg
435: where sga.sales_group_id = sg.sales_group_id );
436: EXCEPTION

Line 446: ||' in AS_SALES_GRP_ADMIN');

442: l_err_total := l_err_total+1;
443: Write_Log(l_module, ' ');
444: Write_Log(l_module, 'Error('||to_char(l_err_total)
445: ||'): found record(s) with invalid sales_group_id'
446: ||' in AS_SALES_GRP_ADMIN');
447: ELSE
448: Write_Log(l_module, ' ');
449: Write_Log(l_module, 'Success: sales_group_id in AS_SALES_GRP_ADMIN'
450: ||' exists in AS_SALES_GROUPS');

Line 449: Write_Log(l_module, 'Success: sales_group_id in AS_SALES_GRP_ADMIN'

445: ||'): found record(s) with invalid sales_group_id'
446: ||' in AS_SALES_GRP_ADMIN');
447: ELSE
448: Write_Log(l_module, ' ');
449: Write_Log(l_module, 'Success: sales_group_id in AS_SALES_GRP_ADMIN'
450: ||' exists in AS_SALES_GROUPS');
451: END IF;
452: */
453: Write_Log(l_module, ' ');