APPS.AS_VALIDATE_SETUP dependencies on ASO_I_SALES_CREDIT_TYPES_V

Line 828: FROM ASO_I_SALES_CREDIT_TYPES_V

824: END IF;
825: BEGIN
826: BEGIN
827: SELECT count(*) INTO l_count
828: FROM ASO_I_SALES_CREDIT_TYPES_V
829: WHERE ENABLED_FLAG='Y'
830: AND QUOTA_FLAG='N';
831: EXCEPTION
832: WHEN OTHERS THEN

Line 840: ||'): no active revenue credit type found in ASO_I_SALES_CREDIT_TYPES_V.');

836: l_err_num := l_err_num+1;
837: l_err_total := l_err_total+1;
838: Write_log(l_module, ' ');
839: Write_log(l_module, 'Error('||to_char(l_err_total)
840: ||'): no active revenue credit type found in ASO_I_SALES_CREDIT_TYPES_V.');
841: ELSE
842: Write_log(l_module, ' ');
843: Write_log(l_module, 'Success: revenue credit type'||
844: ' found in ASO_I_SALES_CREDIT_TYPES_V');

Line 844: ' found in ASO_I_SALES_CREDIT_TYPES_V');

840: ||'): no active revenue credit type found in ASO_I_SALES_CREDIT_TYPES_V.');
841: ELSE
842: Write_log(l_module, ' ');
843: Write_log(l_module, 'Success: revenue credit type'||
844: ' found in ASO_I_SALES_CREDIT_TYPES_V');
845: END IF;
846: BEGIN
847: SELECT count(*) INTO l_count
848: FROM ASO_I_SALES_CREDIT_TYPES_V

Line 848: FROM ASO_I_SALES_CREDIT_TYPES_V

844: ' found in ASO_I_SALES_CREDIT_TYPES_V');
845: END IF;
846: BEGIN
847: SELECT count(*) INTO l_count
848: FROM ASO_I_SALES_CREDIT_TYPES_V
849: WHERE ENABLED_FLAG='Y'
850: AND QUOTA_FLAG='Y';
851: EXCEPTION
852: WHEN OTHERS THEN

Line 861: 'in ASO_I_SALES_CREDIT_TYPES_V.');

857: l_err_total := l_err_total+1;
858: Write_log(l_module, ' ');
859: Write_log(l_module, 'Error('||to_char(l_err_total)
860: ||'): no active non-revenue credit type found '||
861: 'in ASO_I_SALES_CREDIT_TYPES_V.');
862: ELSE
863: Write_log(l_module, ' ');
864: Write_log(l_module, 'Success: non-revenue credit type'||
865: ' found in ASO_I_SALES_CREDIT_TYPES_V');

Line 865: ' found in ASO_I_SALES_CREDIT_TYPES_V');

861: 'in ASO_I_SALES_CREDIT_TYPES_V.');
862: ELSE
863: Write_log(l_module, ' ');
864: Write_log(l_module, 'Success: non-revenue credit type'||
865: ' found in ASO_I_SALES_CREDIT_TYPES_V');
866: END IF;
867: END;
868: -- SOLIN, 06/12/2001
869: -- AS_MC_REPORTING_CURR will be obsolete and migrate to