APPS.AS_VALIDATE_SETUP dependencies on AS_SALES_CREDITS

Line 903: FROM AS_SALES_CREDITS

899:
900: IF p_upgrade = 'Y' THEN
901: BEGIN
902: SELECT count(*) INTO l_count
903: FROM AS_SALES_CREDITS
904: WHERE (REVENUE_PERCENT IS NOT NULL AND REVENUE_AMOUNT IS NOT NULL)
905: OR (QUOTA_CREDIT_PERCENT IS NOT NULL AND QUOTA_CREDIT_AMOUNT IS NOT NULL)
906: OR (REVENUE_PERCENT IS NULL AND REVENUE_AMOUNT IS NULL AND
907: QUOTA_CREDIT_PERCENT IS NULL AND QUOTA_CREDIT_AMOUNT IS NULL);

Line 917: ||'): bad data found in AS_SALES_CREDITS');

913: l_err_num := l_err_num+1;
914: l_err_total := l_err_total+1;
915: Write_log(l_module, ' ');
916: Write_log(l_module, 'Error('||to_char(l_err_total)
917: ||'): bad data found in AS_SALES_CREDITS');
918: Write_log(l_module, 'Before 11i data migration, one and only one of the two fields, '||
919: 'amount or percent, must be entered for either revenue or quota credtis.');
920: ELSE
921: Write_log(l_module, ' ');

Line 922: Write_log(l_module, 'Success: no bad data found in AS_SALES_CREDITS');

918: Write_log(l_module, 'Before 11i data migration, one and only one of the two fields, '||
919: 'amount or percent, must be entered for either revenue or quota credtis.');
920: ELSE
921: Write_log(l_module, ' ');
922: Write_log(l_module, 'Success: no bad data found in AS_SALES_CREDITS');
923: END IF;
924:
925: BEGIN
926: SELECT count(*) INTO l_count