APPS.CSTPMECS dependencies on FND_FILE

Line 545: fnd_file.put_line(fnd_file.log,'Inserted '||to_char(SQL%ROWCOUNT)||' rows into temp table.');

541: AND UOM.inventory_item_id = POL.item_id
542: AND UOM.unit_of_measure = POL.unit_meas_lookup_code
543: GROUP BY POL.item_id);
544:
545: fnd_file.put_line(fnd_file.log,'Inserted '||to_char(SQL%ROWCOUNT)||' rows into temp table.');
546:
547: /* Now delete all items from the temp tables where there were no OPEN POs found */
548: DELETE FROM cst_open_pos_temp
549: WHERE usage_rate_or_amount IS NULL;

Line 619: fnd_file.put_line(fnd_file.log,'Updated '||to_char(SQL%ROWCOUNT)||' rows in cst_item_cost_details.');

615: FROM cst_open_pos_temp
616: )
617: ;
618:
619: fnd_file.put_line(fnd_file.log,'Updated '||to_char(SQL%ROWCOUNT)||' rows in cst_item_cost_details.');
620:
621: O_RETURN_CODE := 0;
622:
623: EXCEPTION

Line 1072: fnd_file.put_line(fnd_file.log,to_char(SQL%ROWCOUNT)|| ' Items were deleted from list');

1068: AND UCR.unit_of_measure = AIP.MATCHED_UOM_LOOKUP_CODE
1069: HAVING ((NVL(sum(quantity_invoiced * UCR.conversion_rate),0) <=0)
1070: OR (sum(nvl(AIP.base_amount, AIP.amount)) <0)));
1071:
1072: fnd_file.put_line(fnd_file.log,to_char(SQL%ROWCOUNT)|| ' Items were deleted from list');
1073: fnd_file.put_line(fnd_file.log,'Since they had negative or zero Invoiced quantity or negative Invoiced value ');
1074: --}
1075:
1076:

Line 1073: fnd_file.put_line(fnd_file.log,'Since they had negative or zero Invoiced quantity or negative Invoiced value ');

1069: HAVING ((NVL(sum(quantity_invoiced * UCR.conversion_rate),0) <=0)
1070: OR (sum(nvl(AIP.base_amount, AIP.amount)) <0)));
1071:
1072: fnd_file.put_line(fnd_file.log,to_char(SQL%ROWCOUNT)|| ' Items were deleted from list');
1073: fnd_file.put_line(fnd_file.log,'Since they had negative or zero Invoiced quantity or negative Invoiced value ');
1074: --}
1075:
1076:
1077: