APPS.CSTPMECS dependencies on FND_FILE

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

605: AND pod.destination_organization_id = rcvcur.organization_id
606: GROUP BY POL.item_id);
607:
608:
609: fnd_file.put_line(fnd_file.log,'Inserted '||to_char(SQL%ROWCOUNT)||' rows into temp table.');
610:
611: /* Now delete all items from the temp tables where there were no OPEN POs found */
612: DELETE FROM cst_open_pos_temp
613: WHERE usage_rate_or_amount IS NULL;

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

679: FROM cst_open_pos_temp
680: )
681: ;
682:
683: fnd_file.put_line(fnd_file.log,'Updated '||to_char(SQL%ROWCOUNT)||' rows in cst_item_cost_details.');
684:
685: O_RETURN_CODE := 0;
686:
687: EXCEPTION

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

1109: AND UCR.unit_of_measure = AIP.MATCHED_UOM_LOOKUP_CODE
1110: HAVING ((NVL(sum(quantity_invoiced * UCR.conversion_rate),0) <=0)
1111: OR (sum(nvl(AIP.base_amount, AIP.amount)) <0)));
1112:
1113: fnd_file.put_line(fnd_file.log,to_char(SQL%ROWCOUNT)|| ' Items were deleted from list');
1114: fnd_file.put_line(fnd_file.log,'Since they had negative or zero Invoiced quantity or negative Invoiced value ');
1115:
1116: /*==================================================================*/
1117: /* insert item cost WHERE there is AP invoice but no pending cost */

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

1110: HAVING ((NVL(sum(quantity_invoiced * UCR.conversion_rate),0) <=0)
1111: OR (sum(nvl(AIP.base_amount, AIP.amount)) <0)));
1112:
1113: fnd_file.put_line(fnd_file.log,to_char(SQL%ROWCOUNT)|| ' Items were deleted from list');
1114: fnd_file.put_line(fnd_file.log,'Since they had negative or zero Invoiced quantity or negative Invoiced value ');
1115:
1116: /*==================================================================*/
1117: /* insert item cost WHERE there is AP invoice but no pending cost */
1118: /* information */