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:
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;
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:
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;
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:
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:
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;
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:
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;
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:
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:
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;
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;
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: