DBA Data[Home] [Help]

APPS.CSTPSCCM dependencies on FND_FILE

Line 104: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Merge Routine');

100:
101: BEGIN
102:
103:
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Merge Routine');
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item = '||p_inventory_item_id);
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||p_dest_organization_id);
107: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
108:

Line 105: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item = '||p_inventory_item_id);

101: BEGIN
102:
103:
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Merge Routine');
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item = '||p_inventory_item_id);
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||p_dest_organization_id);
107: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
108:
109: x_return_code := 0;

Line 106: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||p_dest_organization_id);

102:
103:
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Merge Routine');
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item = '||p_inventory_item_id);
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||p_dest_organization_id);
107: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
108:
109: x_return_code := 0;
110:

Line 107: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

103:
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Merge Routine');
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item = '||p_inventory_item_id);
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||p_dest_organization_id);
107: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
108:
109: x_return_code := 0;
110:
111: l_stmt_num := 1;

Line 244: FND_FILE.PUT_LINE(FND_FILE.LOG,'Make Updated = '||SQL%ROWCOUNT);

240: AND CICD.rollup_source_type NOT IN (1,2)
241: -- Bug 2302328: Do not reaverage for user-defined and default rows
242: AND curr_org_make_weight <> 1;
243:
244: FND_FILE.PUT_LINE(FND_FILE.LOG,'Make Updated = '||SQL%ROWCOUNT);
245: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alloc = '||curr_org_make_weight);
246:
247:
248:

Line 245: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alloc = '||curr_org_make_weight);

241: -- Bug 2302328: Do not reaverage for user-defined and default rows
242: AND curr_org_make_weight <> 1;
243:
244: FND_FILE.PUT_LINE(FND_FILE.LOG,'Make Updated = '||SQL%ROWCOUNT);
245: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alloc = '||curr_org_make_weight);
246:
247:
248:
249:

Line 496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Buy Inserted = '||SQL%ROWCOUNT);

492: );
493:
494: END IF;
495:
496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Buy Inserted = '||SQL%ROWCOUNT);
497: FND_FILE.PUT_LINE(FND_FILE.LOG,'Vendor = '||vendor_cur.vendor_id);
498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alloc = '||curr_vendor_buy_weight);
499:
500: END IF;

Line 497: FND_FILE.PUT_LINE(FND_FILE.LOG,'Vendor = '||vendor_cur.vendor_id);

493:
494: END IF;
495:
496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Buy Inserted = '||SQL%ROWCOUNT);
497: FND_FILE.PUT_LINE(FND_FILE.LOG,'Vendor = '||vendor_cur.vendor_id);
498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alloc = '||curr_vendor_buy_weight);
499:
500: END IF;
501:

Line 498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alloc = '||curr_vendor_buy_weight);

494: END IF;
495:
496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Buy Inserted = '||SQL%ROWCOUNT);
497: FND_FILE.PUT_LINE(FND_FILE.LOG,'Vendor = '||vendor_cur.vendor_id);
498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alloc = '||curr_vendor_buy_weight);
499:
500: END IF;
501:
502: END LOOP;

Line 639: FND_FILE.PUT_LINE(FND_FILE.LOG,'Txf Inserted = '||SQL%ROWCOUNT);

635: AND CIA4.cost_type_id in (p_dest_cost_type_id,default_cost_type_id))
636: )
637: ); /* Supply chain enhancement: support default valuation cost type */
638:
639: FND_FILE.PUT_LINE(FND_FILE.LOG,'Txf Inserted = '||SQL%ROWCOUNT);
640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||src_org.source_organization_id);
641: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alloc = '||src_org.allocation_factor);
642:
643:

Line 640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||src_org.source_organization_id);

636: )
637: ); /* Supply chain enhancement: support default valuation cost type */
638:
639: FND_FILE.PUT_LINE(FND_FILE.LOG,'Txf Inserted = '||SQL%ROWCOUNT);
640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||src_org.source_organization_id);
641: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alloc = '||src_org.allocation_factor);
642:
643:
644:

Line 641: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alloc = '||src_org.allocation_factor);

637: ); /* Supply chain enhancement: support default valuation cost type */
638:
639: FND_FILE.PUT_LINE(FND_FILE.LOG,'Txf Inserted = '||SQL%ROWCOUNT);
640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||src_org.source_organization_id);
641: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alloc = '||src_org.allocation_factor);
642:
643:
644:
645: l_stmt_num := 90;

Line 817: FND_FILE.PUT_LINE(FND_FILE.LOG,'Markup and Ship Inserted = '||SQL%ROWCOUNT);

813: AND src_org.SHIP_CHARGE <> 0
814: GROUP BY CICD2.inventory_item_id, CICD2.organization_id, MP.organization_id
815: HAVING SUM(CICD2.ITEM_COST) > 0;
816:
817: FND_FILE.PUT_LINE(FND_FILE.LOG,'Markup and Ship Inserted = '||SQL%ROWCOUNT);
818: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||src_org.source_organization_id);
819:
820:
821: END LOOP;

Line 818: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||src_org.source_organization_id);

814: GROUP BY CICD2.inventory_item_id, CICD2.organization_id, MP.organization_id
815: HAVING SUM(CICD2.ITEM_COST) > 0;
816:
817: FND_FILE.PUT_LINE(FND_FILE.LOG,'Markup and Ship Inserted = '||SQL%ROWCOUNT);
818: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org = '||src_org.source_organization_id);
819:
820:
821: END LOOP;
822: