APPS.AS_VALIDATE_SETUP dependencies on AS_PE_INT_CATEGORIES

Line 1028: FROM as_pe_int_categories

1024: ' found in AS_FST_SALES_CATEGORIES');
1025: END IF;
1026: BEGIN
1027: SELECT count(*) INTO l_count
1028: FROM as_pe_int_categories
1029: WHERE product_category_id is not null
1030: and ROWID NOT IN ( SELECT MIN(ROWID)
1031: FROM as_pe_int_categories
1032: GROUP BY quota_id, product_category_id );

Line 1031: FROM as_pe_int_categories

1027: SELECT count(*) INTO l_count
1028: FROM as_pe_int_categories
1029: WHERE product_category_id is not null
1030: and ROWID NOT IN ( SELECT MIN(ROWID)
1031: FROM as_pe_int_categories
1032: GROUP BY quota_id, product_category_id );
1033: EXCEPTION
1034: WHEN OTHERS THEN
1035: l_count := 0;

Line 1042: ||'): duplicate records found in AS_PE_INT_CATEGORIES');

1038: l_err_num := l_err_num+1;
1039: l_err_total := l_err_total+1;
1040: Write_log(l_module, ' ');
1041: Write_log(l_module, 'Error('||to_char(l_err_total)
1042: ||'): duplicate records found in AS_PE_INT_CATEGORIES');
1043: ELSE
1044: Write_log(l_module, ' ');
1045: Write_log(l_module, 'Success: no duplicate records'||
1046: ' found in AS_PE_INT_CATEGORIES');

Line 1046: ' found in AS_PE_INT_CATEGORIES');

1042: ||'): duplicate records found in AS_PE_INT_CATEGORIES');
1043: ELSE
1044: Write_log(l_module, ' ');
1045: Write_log(l_module, 'Success: no duplicate records'||
1046: ' found in AS_PE_INT_CATEGORIES');
1047: END IF;
1048: Write_log(l_module, ' ');
1049: Write_log(l_module, '**** '||to_char(l_err_num)
1050: ||' error(s) found in Forecast setup ****');