eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_RELEASE_SO dependencies on FND_FILE

Line 88: FND_FILE.PUT_LINE(FND_FILE.LOG,'rec ='||a);

84: currIndex number;
85:
86: PROCEDURE show_so_details(p_so_table OE_SCHEDULE_GRP.Sch_Tbl_Type , a number) IS
87: BEGIN
88: FND_FILE.PUT_LINE(FND_FILE.LOG,'rec ='||a);
89: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
90: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
91: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
92: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(a).line_id);

Line 89: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));

85:
86: PROCEDURE show_so_details(p_so_table OE_SCHEDULE_GRP.Sch_Tbl_Type , a number) IS
87: BEGIN
88: FND_FILE.PUT_LINE(FND_FILE.LOG,'rec ='||a);
89: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
90: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
91: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
92: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(a).line_id);
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id='||p_so_table(a).header_id);

Line 90: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));

86: PROCEDURE show_so_details(p_so_table OE_SCHEDULE_GRP.Sch_Tbl_Type , a number) IS
87: BEGIN
88: FND_FILE.PUT_LINE(FND_FILE.LOG,'rec ='||a);
89: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
90: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
91: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
92: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(a).line_id);
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id='||p_so_table(a).header_id);
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship_from_org_id='||p_so_table(a).Ship_from_org_id);

Line 91: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));

87: BEGIN
88: FND_FILE.PUT_LINE(FND_FILE.LOG,'rec ='||a);
89: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
90: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
91: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
92: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(a).line_id);
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id='||p_so_table(a).header_id);
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship_from_org_id='||p_so_table(a).Ship_from_org_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_so_table(a).org_id);

Line 92: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(a).line_id);

88: FND_FILE.PUT_LINE(FND_FILE.LOG,'rec ='||a);
89: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
90: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
91: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
92: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(a).line_id);
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id='||p_so_table(a).header_id);
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship_from_org_id='||p_so_table(a).Ship_from_org_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_so_table(a).org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'delivery_lead_time='||p_so_table(a).delivery_lead_time);

Line 93: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id='||p_so_table(a).header_id);

89: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
90: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
91: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
92: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(a).line_id);
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id='||p_so_table(a).header_id);
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship_from_org_id='||p_so_table(a).Ship_from_org_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_so_table(a).org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'delivery_lead_time='||p_so_table(a).delivery_lead_time);
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipping_method_code='||p_so_table(a).shipping_method_code);

Line 94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship_from_org_id='||p_so_table(a).Ship_from_org_id);

90: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
91: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
92: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(a).line_id);
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id='||p_so_table(a).header_id);
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship_from_org_id='||p_so_table(a).Ship_from_org_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_so_table(a).org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'delivery_lead_time='||p_so_table(a).delivery_lead_time);
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipping_method_code='||p_so_table(a).shipping_method_code);
98: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_ship_date='||to_char(p_so_table(a).orig_schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));

Line 95: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_so_table(a).org_id);

91: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
92: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(a).line_id);
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id='||p_so_table(a).header_id);
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship_from_org_id='||p_so_table(a).Ship_from_org_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_so_table(a).org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'delivery_lead_time='||p_so_table(a).delivery_lead_time);
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipping_method_code='||p_so_table(a).shipping_method_code);
98: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_ship_date='||to_char(p_so_table(a).orig_schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
99: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_arrival_date='||to_char(p_so_table(a).orig_schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));

Line 96: FND_FILE.PUT_LINE(FND_FILE.LOG,'delivery_lead_time='||p_so_table(a).delivery_lead_time);

92: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(a).line_id);
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id='||p_so_table(a).header_id);
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship_from_org_id='||p_so_table(a).Ship_from_org_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_so_table(a).org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'delivery_lead_time='||p_so_table(a).delivery_lead_time);
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipping_method_code='||p_so_table(a).shipping_method_code);
98: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_ship_date='||to_char(p_so_table(a).orig_schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
99: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_arrival_date='||to_char(p_so_table(a).orig_schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
100: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ship_from_org_id='||p_so_table(a).orig_ship_from_org_id);

Line 97: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipping_method_code='||p_so_table(a).shipping_method_code);

93: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id='||p_so_table(a).header_id);
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship_from_org_id='||p_so_table(a).Ship_from_org_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_so_table(a).org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'delivery_lead_time='||p_so_table(a).delivery_lead_time);
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipping_method_code='||p_so_table(a).shipping_method_code);
98: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_ship_date='||to_char(p_so_table(a).orig_schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
99: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_arrival_date='||to_char(p_so_table(a).orig_schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
100: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ship_from_org_id='||p_so_table(a).orig_ship_from_org_id);
101: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_shipping_method_code='||p_so_table(a).orig_shipping_method_code);

Line 98: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_ship_date='||to_char(p_so_table(a).orig_schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));

94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship_from_org_id='||p_so_table(a).Ship_from_org_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_so_table(a).org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'delivery_lead_time='||p_so_table(a).delivery_lead_time);
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipping_method_code='||p_so_table(a).shipping_method_code);
98: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_ship_date='||to_char(p_so_table(a).orig_schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
99: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_arrival_date='||to_char(p_so_table(a).orig_schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
100: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ship_from_org_id='||p_so_table(a).orig_ship_from_org_id);
101: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_shipping_method_code='||p_so_table(a).orig_shipping_method_code);
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ordered_quantity='||p_so_table(a).orig_ordered_quantity);

Line 99: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_arrival_date='||to_char(p_so_table(a).orig_schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));

95: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_so_table(a).org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'delivery_lead_time='||p_so_table(a).delivery_lead_time);
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipping_method_code='||p_so_table(a).shipping_method_code);
98: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_ship_date='||to_char(p_so_table(a).orig_schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
99: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_arrival_date='||to_char(p_so_table(a).orig_schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
100: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ship_from_org_id='||p_so_table(a).orig_ship_from_org_id);
101: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_shipping_method_code='||p_so_table(a).orig_shipping_method_code);
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ordered_quantity='||p_so_table(a).orig_ordered_quantity);
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'firm_demand_flag='||p_so_table(a).firm_demand_flag);

Line 100: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ship_from_org_id='||p_so_table(a).orig_ship_from_org_id);

96: FND_FILE.PUT_LINE(FND_FILE.LOG,'delivery_lead_time='||p_so_table(a).delivery_lead_time);
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipping_method_code='||p_so_table(a).shipping_method_code);
98: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_ship_date='||to_char(p_so_table(a).orig_schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
99: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_arrival_date='||to_char(p_so_table(a).orig_schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
100: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ship_from_org_id='||p_so_table(a).orig_ship_from_org_id);
101: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_shipping_method_code='||p_so_table(a).orig_shipping_method_code);
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ordered_quantity='||p_so_table(a).orig_ordered_quantity);
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'firm_demand_flag='||p_so_table(a).firm_demand_flag);
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_inventory_item_id='||p_so_table(a).orig_inventory_item_id);

Line 101: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_shipping_method_code='||p_so_table(a).orig_shipping_method_code);

97: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipping_method_code='||p_so_table(a).shipping_method_code);
98: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_ship_date='||to_char(p_so_table(a).orig_schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
99: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_arrival_date='||to_char(p_so_table(a).orig_schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
100: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ship_from_org_id='||p_so_table(a).orig_ship_from_org_id);
101: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_shipping_method_code='||p_so_table(a).orig_shipping_method_code);
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ordered_quantity='||p_so_table(a).orig_ordered_quantity);
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'firm_demand_flag='||p_so_table(a).firm_demand_flag);
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_inventory_item_id='||p_so_table(a).orig_inventory_item_id);
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'inventory_item_id='||p_so_table(a).inventory_item_id);

Line 102: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ordered_quantity='||p_so_table(a).orig_ordered_quantity);

98: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_ship_date='||to_char(p_so_table(a).orig_schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
99: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_arrival_date='||to_char(p_so_table(a).orig_schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
100: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ship_from_org_id='||p_so_table(a).orig_ship_from_org_id);
101: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_shipping_method_code='||p_so_table(a).orig_shipping_method_code);
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ordered_quantity='||p_so_table(a).orig_ordered_quantity);
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'firm_demand_flag='||p_so_table(a).firm_demand_flag);
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_inventory_item_id='||p_so_table(a).orig_inventory_item_id);
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'inventory_item_id='||p_so_table(a).inventory_item_id);
106:

Line 103: FND_FILE.PUT_LINE(FND_FILE.LOG,'firm_demand_flag='||p_so_table(a).firm_demand_flag);

99: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_schedule_arrival_date='||to_char(p_so_table(a).orig_schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
100: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ship_from_org_id='||p_so_table(a).orig_ship_from_org_id);
101: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_shipping_method_code='||p_so_table(a).orig_shipping_method_code);
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ordered_quantity='||p_so_table(a).orig_ordered_quantity);
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'firm_demand_flag='||p_so_table(a).firm_demand_flag);
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_inventory_item_id='||p_so_table(a).orig_inventory_item_id);
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'inventory_item_id='||p_so_table(a).inventory_item_id);
106:
107: END show_so_details;

Line 104: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_inventory_item_id='||p_so_table(a).orig_inventory_item_id);

100: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ship_from_org_id='||p_so_table(a).orig_ship_from_org_id);
101: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_shipping_method_code='||p_so_table(a).orig_shipping_method_code);
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ordered_quantity='||p_so_table(a).orig_ordered_quantity);
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'firm_demand_flag='||p_so_table(a).firm_demand_flag);
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_inventory_item_id='||p_so_table(a).orig_inventory_item_id);
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'inventory_item_id='||p_so_table(a).inventory_item_id);
106:
107: END show_so_details;
108:

Line 105: FND_FILE.PUT_LINE(FND_FILE.LOG,'inventory_item_id='||p_so_table(a).inventory_item_id);

101: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_shipping_method_code='||p_so_table(a).orig_shipping_method_code);
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_ordered_quantity='||p_so_table(a).orig_ordered_quantity);
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'firm_demand_flag='||p_so_table(a).firm_demand_flag);
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_inventory_item_id='||p_so_table(a).orig_inventory_item_id);
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'inventory_item_id='||p_so_table(a).inventory_item_id);
106:
107: END show_so_details;
108:
109:

Line 151: FND_FILE.PUT_LINE(FND_FILE.LOG,' re group table by header_id');

147: order by number1; -- header_id
148:
149: a number;
150: BEGIN
151: FND_FILE.PUT_LINE(FND_FILE.LOG,' re group table by header_id');
152:
153: for a in 1..p_so_table.count loop
154: insert into msc_form_query
155: (query_ID,

Line 274: FND_FILE.PUT_LINE(FND_FILE.LOG,'addLineList , p_line_index='||p_line_index||', i='||i);

270:
271: i := nvl(p_line_list.LAST, 0) +1;
272: p_line_list.extend;
273: p_line_list(i) := p_line_index;
274: FND_FILE.PUT_LINE(FND_FILE.LOG,'addLineList , p_line_index='||p_line_index||', i='||i);
275:
276:
277:
278: EXCEPTION WHEN OTHERS THEN

Line 288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_latest_date_index ='||p_latest_date_index);

284: if p_latest_date_index is null or
285: p_so_table(p_line_index).schedule_ship_date >
286: p_so_table(p_latest_date_index).schedule_ship_date then
287: p_latest_date_index := p_line_index;
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_latest_date_index ='||p_latest_date_index);
289: end if;
290: END getLatestDate;
291:
292: PROCEDURE modifyPTODates(p_TopModelID number default null) IS

Line 305: FND_FILE.PUT_LINE(FND_FILE.LOG,' change the dates for PTO model line '||p_so_table(i).line_id ||' to use the dates from rec '||p_latest_date_index);

301: p_so_table(i).schedule_arrival_date :=
302: p_so_table(p_latest_date_index).schedule_arrival_date;
303: p_so_table(i).earliest_ship_date :=
304: p_so_table(p_latest_date_index).earliest_ship_date;
305: FND_FILE.PUT_LINE(FND_FILE.LOG,' change the dates for PTO model line '||p_so_table(i).line_id ||' to use the dates from rec '||p_latest_date_index);
306:
307: EXIT;
308: Elsif p_TopModelID is null THEN
309: p_so_table(i).schedule_ship_date :=

Line 315: FND_FILE.PUT_LINE(FND_FILE.LOG,' change the dates for PTO model line '||p_so_table(i).line_id ||' to use the dates from rec '||p_latest_date_index);

311: p_so_table(i).schedule_arrival_date :=
312: p_so_table(p_latest_date_index).schedule_arrival_date;
313: p_so_table(i).earliest_ship_date :=
314: p_so_table(p_latest_date_index).earliest_ship_date;
315: FND_FILE.PUT_LINE(FND_FILE.LOG,' change the dates for PTO model line '||p_so_table(i).line_id ||' to use the dates from rec '||p_latest_date_index);
316: end if;
317: -- show_so_details(p_so_table,i);
318: end loop;
319: END modifyPTODates;

Line 338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'batch_id='||p_batch_id||', instance_id='||p_instance_id||', dblink='||p_dblink);

334: begin
335:
336:
337:
338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'batch_id='||p_batch_id||', instance_id='||p_instance_id||', dblink='||p_dblink);
339:
340: retcode :=0;
341:
342: -- release so with source_type = null thru oe package

Line 395: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_so_count='||orig_so_count);

391: CLOSE so_cursor;
392:
393: orig_so_count := so_count;
394:
395: FND_FILE.PUT_LINE(FND_FILE.LOG,'orig_so_count='||orig_so_count);
396:
397: FOR i in 1..orig_so_count LOOP
398:
399: OPEN line_c(p_so_table(i).line_id);

Line 405: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id for line_id '||p_so_table(i).line_id||' is '||p_so_table(i).header_id);

401: p_item_type_code, p_uom_code;
402: CLOSE line_c;
403: if p_so_table(i).header_id is null then
404: p_so_table(i).header_id := p_header_id;
405: FND_FILE.PUT_LINE(FND_FILE.LOG,'header_id for line_id '||p_so_table(i).line_id||' is '||p_so_table(i).header_id);
406: end if;
407:
408: addHeaderList(p_so_table(i).header_id);
409:

Line 412: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id for line_id = '||p_so_table(i).line_id||' is changed to '||p_org_id ||' from '||p_so_table(i).org_id);

408: addHeaderList(p_so_table(i).header_id);
409:
410: if p_so_table(i).org_id <> p_org_id then
411: -- bug 7537394, get operating_unit from oe_order_lines_all
412: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id for line_id = '||p_so_table(i).line_id||' is changed to '||p_org_id ||' from '||p_so_table(i).org_id);
413: p_so_table(i).org_id := p_org_id;
414: end if;
415:
416: -- bug#9339922

Line 423: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UOM code is different : OM UOM = ' ||

419: FETCH mtl_primary_uom INTO l_primary_uom_code;
420: CLOSE mtl_primary_uom;
421:
422: IF p_uom_code <> l_primary_uom_code THEN
423: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UOM code is different : OM UOM = ' ||
424: p_uom_code || ' mtl_system_items UOM, primary UOM = '|| l_primary_uom_code);
425: -- convert the qty from ascp workbench back to OM qty
426: l_converted_qty :=
427: inv_convert.inv_um_convert(p_so_table(i).inventory_item_id,

Line 433: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Converted qty = '||

429: p_so_table(i).orig_ordered_quantity,
430: l_primary_uom_code,
431: p_uom_code,
432: null, null);
433: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Converted qty = '||
434: l_converted_qty|| ' Qty from ASCP wb = ' || p_so_table(i).orig_ordered_quantity);
435: p_so_table(i).orig_ordered_quantity := l_converted_qty;
436:
437: END IF;

Line 441: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(i).line_id);

437: END IF;
438:
439: if p_top_model_line_id is not null and
440: p_item_type_code <> 'CONFIG' then
441: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(i).line_id);
442: FND_FILE.PUT_LINE(FND_FILE.LOG,' pto/ato exists, top_model_line_id='||p_top_model_line_id);
443: if isModelIncluded(p_top_model_line_id) then
444: FND_FILE.PUT_LINE(FND_FILE.LOG,' top model is included already');
445: p_isSMC_PTO := null;

Line 442: FND_FILE.PUT_LINE(FND_FILE.LOG,' pto/ato exists, top_model_line_id='||p_top_model_line_id);

438:
439: if p_top_model_line_id is not null and
440: p_item_type_code <> 'CONFIG' then
441: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(i).line_id);
442: FND_FILE.PUT_LINE(FND_FILE.LOG,' pto/ato exists, top_model_line_id='||p_top_model_line_id);
443: if isModelIncluded(p_top_model_line_id) then
444: FND_FILE.PUT_LINE(FND_FILE.LOG,' top model is included already');
445: p_isSMC_PTO := null;
446: else -- new Model

Line 444: FND_FILE.PUT_LINE(FND_FILE.LOG,' top model is included already');

440: p_item_type_code <> 'CONFIG' then
441: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_so_table(i).line_id);
442: FND_FILE.PUT_LINE(FND_FILE.LOG,' pto/ato exists, top_model_line_id='||p_top_model_line_id);
443: if isModelIncluded(p_top_model_line_id) then
444: FND_FILE.PUT_LINE(FND_FILE.LOG,' top model is included already');
445: p_isSMC_PTO := null;
446: else -- new Model
447: addModelList(p_top_model_line_id);
448:

Line 461: FND_FILE.PUT_LINE(FND_FILE.LOG,' this is non-SMC PTO top model line ='||options_rec.line_id);

457: addLineList(i);
458: getLatestDate(i);
459:
460: if nvl(options_rec.ship_model_complete_flag,'N') = 'N' then
461: FND_FILE.PUT_LINE(FND_FILE.LOG,' this is non-SMC PTO top model line ='||options_rec.line_id);
462: p_isSMC_PTO := FALSE;
463: else
464: FND_FILE.PUT_LINE(FND_FILE.LOG,' this is SMC PTO top model line ='||options_rec.line_id);
465: p_isSMC_PTO := true;

Line 464: FND_FILE.PUT_LINE(FND_FILE.LOG,' this is SMC PTO top model line ='||options_rec.line_id);

460: if nvl(options_rec.ship_model_complete_flag,'N') = 'N' then
461: FND_FILE.PUT_LINE(FND_FILE.LOG,' this is non-SMC PTO top model line ='||options_rec.line_id);
462: p_isSMC_PTO := FALSE;
463: else
464: FND_FILE.PUT_LINE(FND_FILE.LOG,' this is SMC PTO top model line ='||options_rec.line_id);
465: p_isSMC_PTO := true;
466:
467: end if;
468:

Line 472: FND_FILE.PUT_LINE(FND_FILE.LOG,'currIndex='||currIndex);

468:
469: end if;
470:
471: currIndex := isSOIncluded(options_rec.line_id);
472: FND_FILE.PUT_LINE(FND_FILE.LOG,'currIndex='||currIndex);
473: if currIndex <> -1 then
474:
475: FND_FILE.PUT_LINE(FND_FILE.LOG,' line is already included, line_id='||options_rec.line_id);
476: addLineList(currIndex);

Line 475: FND_FILE.PUT_LINE(FND_FILE.LOG,' line is already included, line_id='||options_rec.line_id);

471: currIndex := isSOIncluded(options_rec.line_id);
472: FND_FILE.PUT_LINE(FND_FILE.LOG,'currIndex='||currIndex);
473: if currIndex <> -1 then
474:
475: FND_FILE.PUT_LINE(FND_FILE.LOG,' line is already included, line_id='||options_rec.line_id);
476: addLineList(currIndex);
477: getLatestDate(currIndex);
478: else -- need to include
479: addLineList(a);

Line 493: FND_FILE.PUT_LINE(FND_FILE.LOG,' include line_id='||p_so_table(a).line_id);

489: p_so_table(i).earliest_ship_date;
490: so_count := so_count +1;
491:
492:
493: FND_FILE.PUT_LINE(FND_FILE.LOG,' include line_id='||p_so_table(a).line_id);
494: show_so_details(p_so_table,a);
495: a := a+1;
496: end if;
497: END LOOP;

Line 502: FND_FILE.PUT_LINE(FND_FILE.LOG,'modify PTODates');

498: CLOSE options_c;
499:
500: -- 14356932, all SMC PTO line should use the latest date of the child lines
501: if p_isSMC_PTO then
502: FND_FILE.PUT_LINE(FND_FILE.LOG,'modify PTODates');
503: modifyPTODates();
504: elsif not p_isSMC_PTO then
505: FND_FILE.PUT_LINE(FND_FILE.LOG,'modify PTODate for TopModel');
506: modifyPTODates(p_top_model_line_id);

Line 505: FND_FILE.PUT_LINE(FND_FILE.LOG,'modify PTODate for TopModel');

501: if p_isSMC_PTO then
502: FND_FILE.PUT_LINE(FND_FILE.LOG,'modify PTODates');
503: modifyPTODates();
504: elsif not p_isSMC_PTO then
505: FND_FILE.PUT_LINE(FND_FILE.LOG,'modify PTODate for TopModel');
506: modifyPTODates(p_top_model_line_id);
507: end if;
508:
509: end if; -- new Model

Line 510: FND_FILE.PUT_LINE(FND_FILE.LOG,' done with pto/ato data for top_model_line_id='||p_top_model_line_id);

506: modifyPTODates(p_top_model_line_id);
507: end if;
508:
509: end if; -- new Model
510: FND_FILE.PUT_LINE(FND_FILE.LOG,' done with pto/ato data for top_model_line_id='||p_top_model_line_id);
511: end if; -- p_top_model_line_id is not null
512:
513: END LOOP;
514:

Line 543: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_crm_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));

539: p_crm_so_table(a).org_id,
540: p_crm_so_table(a).quantity_by_due_date;
541: EXIT WHEN so_cursor%NOTFOUND;
542: crm_so_count := crm_so_count +1;
543: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_crm_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
544: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_crm_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_crm_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_crm_so_table(a).order_line_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_crm_so_table(a).org_id);

Line 544: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_crm_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));

540: p_crm_so_table(a).quantity_by_due_date;
541: EXIT WHEN so_cursor%NOTFOUND;
542: crm_so_count := crm_so_count +1;
543: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_crm_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
544: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_crm_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_crm_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_crm_so_table(a).order_line_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_crm_so_table(a).org_id);
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'qty='||p_crm_so_table(a).quantity_by_due_date);

Line 545: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_crm_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));

541: EXIT WHEN so_cursor%NOTFOUND;
542: crm_so_count := crm_so_count +1;
543: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_crm_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
544: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_crm_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_crm_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_crm_so_table(a).order_line_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_crm_so_table(a).org_id);
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'qty='||p_crm_so_table(a).quantity_by_due_date);
549: a := a+1;

Line 546: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_crm_so_table(a).order_line_id);

542: crm_so_count := crm_so_count +1;
543: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_crm_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
544: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_crm_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_crm_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_crm_so_table(a).order_line_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_crm_so_table(a).org_id);
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'qty='||p_crm_so_table(a).quantity_by_due_date);
549: a := a+1;
550: END LOOP;

Line 547: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_crm_so_table(a).org_id);

543: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_crm_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
544: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_crm_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_crm_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_crm_so_table(a).order_line_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_crm_so_table(a).org_id);
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'qty='||p_crm_so_table(a).quantity_by_due_date);
549: a := a+1;
550: END LOOP;
551: CLOSE so_cursor;

Line 548: FND_FILE.PUT_LINE(FND_FILE.LOG,'qty='||p_crm_so_table(a).quantity_by_due_date);

544: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_crm_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'earliest_ship_date='||to_char(p_crm_so_table(a).earliest_ship_date,'MM-DD-RRRR HH24:MI:SS'));
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_id='||p_crm_so_table(a).order_line_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id='||p_crm_so_table(a).org_id);
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'qty='||p_crm_so_table(a).quantity_by_due_date);
549: a := a+1;
550: END LOOP;
551: CLOSE so_cursor;
552:

Line 615: FND_FILE.PUT_LINE(FND_FILE.LOG,'update fails for line id '||p_so_table(a).line_id||', Order Number: '||p_order_num||', Line Number: '||p_line_num||', om return status ='||p_so_table(a).x_return_status);

611: p_line_num := null;
612: OPEN ord_num_c(p_so_table(a).line_id);
613: FETCH ord_num_c INTO p_order_num, p_line_num;
614: CLOSE ord_num_c;
615: FND_FILE.PUT_LINE(FND_FILE.LOG,'update fails for line id '||p_so_table(a).line_id||', Order Number: '||p_order_num||', Line Number: '||p_line_num||', om return status ='||p_so_table(a).x_return_status);
616: p_status := 2; -- fails
617: retcode :=2;
618: else
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'atp override for line id'||p_so_table(a).line_id);

Line 619: FND_FILE.PUT_LINE(FND_FILE.LOG,'atp override for line id'||p_so_table(a).line_id);

615: FND_FILE.PUT_LINE(FND_FILE.LOG,'update fails for line id '||p_so_table(a).line_id||', Order Number: '||p_order_num||', Line Number: '||p_line_num||', om return status ='||p_so_table(a).x_return_status);
616: p_status := 2; -- fails
617: retcode :=2;
618: else
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'atp override for line id'||p_so_table(a).line_id);
620: p_status := 1; -- override
621: end if;
622: EXECUTE IMMEDIATE sql_stmt using p_status, p_instance_id, p_batch_id,
623: p_so_table(a).line_id;

Line 626: FND_FILE.PUT_LINE(FND_FILE.LOG,'update scceeds for line id'||p_so_table(a).line_id);

622: EXECUTE IMMEDIATE sql_stmt using p_status, p_instance_id, p_batch_id,
623: p_so_table(a).line_id;
624: p_need_notify := true;
625: else
626: FND_FILE.PUT_LINE(FND_FILE.LOG,'update scceeds for line id'||p_so_table(a).line_id);
627: end if;
628:
629: end loop;
630:

Line 649: FND_FILE.PUT_LINE(FND_FILE.LOG,'update fails for line id '||p_crm_so_table(a).order_line_id);

645: ' and source_type = 100 ';
646: EXECUTE IMMEDIATE sql_stmt using p_status, p_instance_id, p_batch_id;
647: commit;
648: for a in 1..crm_so_count loop
649: FND_FILE.PUT_LINE(FND_FILE.LOG,'update fails for line id '||p_crm_so_table(a).order_line_id);
650: end loop;
651: ELSE
652: for a in 1..crm_so_count loop
653: FND_FILE.PUT_LINE(FND_FILE.LOG,'update successfully for line id '||p_crm_so_table(a).order_line_id);

Line 653: FND_FILE.PUT_LINE(FND_FILE.LOG,'update successfully for line id '||p_crm_so_table(a).order_line_id);

649: FND_FILE.PUT_LINE(FND_FILE.LOG,'update fails for line id '||p_crm_so_table(a).order_line_id);
650: end loop;
651: ELSE
652: for a in 1..crm_so_count loop
653: FND_FILE.PUT_LINE(FND_FILE.LOG,'update successfully for line id '||p_crm_so_table(a).order_line_id);
654: end loop;
655: END IF;
656:
657: sql_stmt:=

Line 678: FND_FILE.PUT_LINE(FND_FILE.LOG,'send workflow notification to planners, request id='||p_request_id);

674: EXECUTE IMMEDIATE sql_stmt using in p_batch_id,in p_instance_id,
675: in p_user_name, out p_request_id ;
676: commit;
677:
678: FND_FILE.PUT_LINE(FND_FILE.LOG,'send workflow notification to planners, request id='||p_request_id);
679: end if;
680: exception when others then
681: retcode :=2;
682: raise;