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.WSH_PR_CREATE_DELIVERIES dependencies on WSH_UTIL

Line 43: WSH_UTIL.Write_Log('Package already initialized for session');

39: RETURN BINARY_INTEGER IS
40: BEGIN
41:
42: IF initialized = TRUE THEN
43: WSH_UTIL.Write_Log('Package already initialized for session');
44: RETURN SUCCESS;
45: END IF;
46:
47: delivery_table.delete;

Line 57: WSH_UTIL.Default_Handler('WSH_PR_CREATE_DELIVERIES.Init');

53: RETURN SUCCESS;
54:
55: EXCEPTION
56: WHEN OTHERS THEN
57: WSH_UTIL.Default_Handler('WSH_PR_CREATE_DELIVERIES.Init');
58: RETURN FAILURE;
59:
60: END Init;
61:

Line 132: WSH_UTIL.Write_Log('Error: Cannot find order header');

128: v_freight_terms_code,
129: v_currency_code;
130:
131: IF get_delivery_info%NOTFOUND THEN
132: WSH_UTIL.Write_Log('Error: Cannot find order header');
133: RETURN FAILURE;
134: END IF;
135:
136: IF WSH_PR_PICKING_OBJECTS.g_use_autocreate_del_orders = 'Y' THEN

Line 164: WSH_UTIL.Write_Log('Found delivery_id ' || to_char(v_delivery_id) ||

160: (delivery_table(i).fob_code = v_fob_code) AND
161: (delivery_table(i).freight_terms_code = v_freight_terms_code) AND
162: (delivery_table(i).currency_code = v_currency_code)) THEN
163: v_delivery_id := delivery_table(i).delivery_id;
164: WSH_UTIL.Write_Log('Found delivery_id ' || to_char(v_delivery_id) ||
165: ' in table');
166: END IF;
167:
168: -- If found, return the associated delivery_id

Line 177: WSH_UTIL.Write_Log('Will create a new delivery id');

173: END LOOP;
174:
175: -- Must create a new delivery
176: IF v_delivery_id = -1 THEN
177: WSH_UTIL.Write_Log('Will create a new delivery id');
178: WSH_UTIL.Write_Log('Calling WSH_DELIVERIES_PKG.Insert_Row');
179:
180: v_rowid := NULL;
181: v_delivery_id := NULL;

Line 178: WSH_UTIL.Write_Log('Calling WSH_DELIVERIES_PKG.Insert_Row');

174:
175: -- Must create a new delivery
176: IF v_delivery_id = -1 THEN
177: WSH_UTIL.Write_Log('Will create a new delivery id');
178: WSH_UTIL.Write_Log('Calling WSH_DELIVERIES_PKG.Insert_Row');
179:
180: v_rowid := NULL;
181: v_delivery_id := NULL;
182: v_delivery_name := NULL;

Line 197: WSH_UTIL.Write_Log('volume_uom_class = ' || v_volume_uom_class);

193:
194: wsh_parameters_pvt.get_param_value(p_organization_id,
195: 'VOLUME_UOM_CLASS',
196: v_volume_uom_class);
197: WSH_UTIL.Write_Log('volume_uom_class = ' || v_volume_uom_class);
198:
199: wsh_parameters_pvt.get_param_value(p_organization_id,
200: 'WEIGHT_UOM_CLASS',
201: v_weight_uom_class);

Line 202: WSH_UTIL.Write_Log('weight_uom_class = ' || v_weight_uom_class);

198:
199: wsh_parameters_pvt.get_param_value(p_organization_id,
200: 'WEIGHT_UOM_CLASS',
201: v_weight_uom_class);
202: WSH_UTIL.Write_Log('weight_uom_class = ' || v_weight_uom_class);
203:
204: OPEN get_vol_weight_uom(v_volume_uom_class);
205: FETCH get_vol_weight_uom
206: INTO v_volume_uom_code ;

Line 208: WSH_UTIL.Write_Log('Warning: Cannot find UOM code for Volume. Using NULL ....');

204: OPEN get_vol_weight_uom(v_volume_uom_class);
205: FETCH get_vol_weight_uom
206: INTO v_volume_uom_code ;
207: IF get_delivery_info%NOTFOUND THEN
208: WSH_UTIL.Write_Log('Warning: Cannot find UOM code for Volume. Using NULL ....');
209: END IF;
210: CLOSE get_vol_weight_uom ;
211:
212: OPEN get_vol_weight_uom(v_weight_uom_class);

Line 216: WSH_UTIL.Write_Log('Warning: Cannot find UOM code for Weight. Using NULL ....');

212: OPEN get_vol_weight_uom(v_weight_uom_class);
213: FETCH get_vol_weight_uom
214: INTO v_weight_uom_code ;
215: IF get_delivery_info%NOTFOUND THEN
216: WSH_UTIL.Write_Log('Warning: Cannot find UOM code for Weight. Using NULL ....');
217: END IF;
218: CLOSE get_vol_weight_uom ;
219:
220:

Line 221: WSH_UTIL.Write_Log('org_id = ' || to_char(p_organization_id));

217: END IF;
218: CLOSE get_vol_weight_uom ;
219:
220:
221: WSH_UTIL.Write_Log('org_id = ' || to_char(p_organization_id));
222: WSH_UTIL.Write_Log('cust_id = ' || to_char(v_customer_id));
223: WSH_UTIL.Write_Log('ship_to = ' || to_char(v_ship_to_site_use_id));
224: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));
225: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));

Line 222: WSH_UTIL.Write_Log('cust_id = ' || to_char(v_customer_id));

218: CLOSE get_vol_weight_uom ;
219:
220:
221: WSH_UTIL.Write_Log('org_id = ' || to_char(p_organization_id));
222: WSH_UTIL.Write_Log('cust_id = ' || to_char(v_customer_id));
223: WSH_UTIL.Write_Log('ship_to = ' || to_char(v_ship_to_site_use_id));
224: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));
225: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));
226: WSH_UTIL.Write_Log('volume_uom_code = ' || v_volume_uom_code);

Line 223: WSH_UTIL.Write_Log('ship_to = ' || to_char(v_ship_to_site_use_id));

219:
220:
221: WSH_UTIL.Write_Log('org_id = ' || to_char(p_organization_id));
222: WSH_UTIL.Write_Log('cust_id = ' || to_char(v_customer_id));
223: WSH_UTIL.Write_Log('ship_to = ' || to_char(v_ship_to_site_use_id));
224: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));
225: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));
226: WSH_UTIL.Write_Log('volume_uom_code = ' || v_volume_uom_code);
227: WSH_UTIL.Write_Log('weight_uom_code = ' || v_weight_uom_code);

Line 224: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));

220:
221: WSH_UTIL.Write_Log('org_id = ' || to_char(p_organization_id));
222: WSH_UTIL.Write_Log('cust_id = ' || to_char(v_customer_id));
223: WSH_UTIL.Write_Log('ship_to = ' || to_char(v_ship_to_site_use_id));
224: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));
225: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));
226: WSH_UTIL.Write_Log('volume_uom_code = ' || v_volume_uom_code);
227: WSH_UTIL.Write_Log('weight_uom_code = ' || v_weight_uom_code);
228:

Line 225: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));

221: WSH_UTIL.Write_Log('org_id = ' || to_char(p_organization_id));
222: WSH_UTIL.Write_Log('cust_id = ' || to_char(v_customer_id));
223: WSH_UTIL.Write_Log('ship_to = ' || to_char(v_ship_to_site_use_id));
224: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));
225: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));
226: WSH_UTIL.Write_Log('volume_uom_code = ' || v_volume_uom_code);
227: WSH_UTIL.Write_Log('weight_uom_code = ' || v_weight_uom_code);
228:
229: WSH_DELIVERIES_PKG1.Insert_Row(

Line 226: WSH_UTIL.Write_Log('volume_uom_code = ' || v_volume_uom_code);

222: WSH_UTIL.Write_Log('cust_id = ' || to_char(v_customer_id));
223: WSH_UTIL.Write_Log('ship_to = ' || to_char(v_ship_to_site_use_id));
224: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));
225: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));
226: WSH_UTIL.Write_Log('volume_uom_code = ' || v_volume_uom_code);
227: WSH_UTIL.Write_Log('weight_uom_code = ' || v_weight_uom_code);
228:
229: WSH_DELIVERIES_PKG1.Insert_Row(
230: X_Rowid => v_rowid,

Line 227: WSH_UTIL.Write_Log('weight_uom_code = ' || v_weight_uom_code);

223: WSH_UTIL.Write_Log('ship_to = ' || to_char(v_ship_to_site_use_id));
224: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));
225: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));
226: WSH_UTIL.Write_Log('volume_uom_code = ' || v_volume_uom_code);
227: WSH_UTIL.Write_Log('weight_uom_code = ' || v_weight_uom_code);
228:
229: WSH_DELIVERIES_PKG1.Insert_Row(
230: X_Rowid => v_rowid,
231: X_Organization_Id => p_organization_id,

Line 283: WSH_UTIL.Write_Log('New delivery is ' || v_delivery_name);

279: X_Last_Updated_By => user_id,
280: X_Last_Update_Login => login_id
281: );
282:
283: WSH_UTIL.Write_Log('New delivery is ' || v_delivery_name);
284:
285: -- Inserting row in delivery_table
286: delivery_table(current_line).header_id := v_header_id;
287: delivery_table(current_line).ship_to_site_use_id := v_ship_to_site_use_id;

Line 302: WSH_UTIL.Default_Handler('WSH_PR_CREATE_DELIVERIES.Get_Delivery');

298: RETURN v_delivery_id;
299:
300: EXCEPTION
301: WHEN OTHERS THEN
302: WSH_UTIL.Default_Handler('WSH_PR_CREATE_DELIVERIES.Get_Delivery');
303: RETURN FAILURE;
304:
305: END Get_Delivery;
306: