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_FREIGHT_COSTS_PUB dependencies on FND_API

Line 25: IF (p_freight_cost_type <> FND_API.G_MISS_CHAR) THEN

21: --
22: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
23:
24: IF (x_freight_cost_type_id IS NULL) THEN
25: IF (p_freight_cost_type <> FND_API.G_MISS_CHAR) THEN
26: SELECT freight_cost_type_id INTO x_freight_cost_type_id
27: FROM wsh_freight_cost_types
28: WHERE name = p_freight_cost_type;
29: IF (SQL%NOTFOUND) THEN

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

72: x_return_status => x_return_status);
73:
74: EXCEPTION
75: WHEN OTHERS THEN
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
77: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
78: FND_MSG_PUB.Add_Exc_Msg (
79: G_PKG_NAME,
80: '_x_'

Line 123: x_pvt_freight_rec.CALCULATION_METHOD := FND_API.G_MISS_CHAR;

119:
120: x_pvt_freight_rec.FREIGHT_COST_ID := p_pub_freight_rec.FREIGHT_COST_ID;
121: x_pvt_freight_rec.FREIGHT_COST_TYPE_ID := p_pub_freight_rec.FREIGHT_COST_TYPE_ID;
122: x_pvt_freight_rec.UNIT_AMOUNT := p_pub_freight_rec.UNIT_AMOUNT;
123: x_pvt_freight_rec.CALCULATION_METHOD := FND_API.G_MISS_CHAR;
124: x_pvt_freight_rec.UOM := FND_API.G_MISS_CHAR;
125: x_pvt_freight_rec.QUANTITY := FND_API.G_MISS_NUM;
126: x_pvt_freight_rec.TOTAL_AMOUNT := FND_API.G_MISS_NUM;
127: x_pvt_freight_rec.CURRENCY_CODE := p_pub_freight_rec.CURRENCY_CODE;

Line 124: x_pvt_freight_rec.UOM := FND_API.G_MISS_CHAR;

120: x_pvt_freight_rec.FREIGHT_COST_ID := p_pub_freight_rec.FREIGHT_COST_ID;
121: x_pvt_freight_rec.FREIGHT_COST_TYPE_ID := p_pub_freight_rec.FREIGHT_COST_TYPE_ID;
122: x_pvt_freight_rec.UNIT_AMOUNT := p_pub_freight_rec.UNIT_AMOUNT;
123: x_pvt_freight_rec.CALCULATION_METHOD := FND_API.G_MISS_CHAR;
124: x_pvt_freight_rec.UOM := FND_API.G_MISS_CHAR;
125: x_pvt_freight_rec.QUANTITY := FND_API.G_MISS_NUM;
126: x_pvt_freight_rec.TOTAL_AMOUNT := FND_API.G_MISS_NUM;
127: x_pvt_freight_rec.CURRENCY_CODE := p_pub_freight_rec.CURRENCY_CODE;
128: x_pvt_freight_rec.CONVERSION_DATE := p_pub_freight_rec.CONVERSION_DATE;

Line 125: x_pvt_freight_rec.QUANTITY := FND_API.G_MISS_NUM;

121: x_pvt_freight_rec.FREIGHT_COST_TYPE_ID := p_pub_freight_rec.FREIGHT_COST_TYPE_ID;
122: x_pvt_freight_rec.UNIT_AMOUNT := p_pub_freight_rec.UNIT_AMOUNT;
123: x_pvt_freight_rec.CALCULATION_METHOD := FND_API.G_MISS_CHAR;
124: x_pvt_freight_rec.UOM := FND_API.G_MISS_CHAR;
125: x_pvt_freight_rec.QUANTITY := FND_API.G_MISS_NUM;
126: x_pvt_freight_rec.TOTAL_AMOUNT := FND_API.G_MISS_NUM;
127: x_pvt_freight_rec.CURRENCY_CODE := p_pub_freight_rec.CURRENCY_CODE;
128: x_pvt_freight_rec.CONVERSION_DATE := p_pub_freight_rec.CONVERSION_DATE;
129: x_pvt_freight_rec.CONVERSION_RATE := p_pub_freight_rec.CONVERSION_RATE;

Line 126: x_pvt_freight_rec.TOTAL_AMOUNT := FND_API.G_MISS_NUM;

122: x_pvt_freight_rec.UNIT_AMOUNT := p_pub_freight_rec.UNIT_AMOUNT;
123: x_pvt_freight_rec.CALCULATION_METHOD := FND_API.G_MISS_CHAR;
124: x_pvt_freight_rec.UOM := FND_API.G_MISS_CHAR;
125: x_pvt_freight_rec.QUANTITY := FND_API.G_MISS_NUM;
126: x_pvt_freight_rec.TOTAL_AMOUNT := FND_API.G_MISS_NUM;
127: x_pvt_freight_rec.CURRENCY_CODE := p_pub_freight_rec.CURRENCY_CODE;
128: x_pvt_freight_rec.CONVERSION_DATE := p_pub_freight_rec.CONVERSION_DATE;
129: x_pvt_freight_rec.CONVERSION_RATE := p_pub_freight_rec.CONVERSION_RATE;
130: x_pvt_freight_rec.CONVERSION_TYPE_CODE := p_pub_freight_rec.CONVERSION_TYPE_CODE;

Line 162: x_pvt_freight_rec.PRICING_LIST_HEADER_ID := FND_API.G_MISS_NUM;

158: x_pvt_freight_rec.PROGRAM_ID := p_pub_freight_rec.PROGRAM_ID;
159: x_pvt_freight_rec.PROGRAM_UPDATE_DATE := p_pub_freight_rec.PROGRAM_UPDATE_DATE;
160: x_pvt_freight_rec.REQUEST_ID := p_pub_freight_rec.REQUEST_ID;
161:
162: x_pvt_freight_rec.PRICING_LIST_HEADER_ID := FND_API.G_MISS_NUM;
163: x_pvt_freight_rec.PRICING_LIST_LINE_ID := FND_API.G_MISS_NUM;
164: x_pvt_freight_rec.APPLIED_TO_CHARGE_ID := FND_API.G_MISS_NUM;
165: x_pvt_freight_rec.CHARGE_UNIT_VALUE := FND_API.G_MISS_NUM;
166: x_pvt_freight_rec.CHARGE_SOURCE_CODE := FND_API.G_MISS_CHAR;

Line 163: x_pvt_freight_rec.PRICING_LIST_LINE_ID := FND_API.G_MISS_NUM;

159: x_pvt_freight_rec.PROGRAM_UPDATE_DATE := p_pub_freight_rec.PROGRAM_UPDATE_DATE;
160: x_pvt_freight_rec.REQUEST_ID := p_pub_freight_rec.REQUEST_ID;
161:
162: x_pvt_freight_rec.PRICING_LIST_HEADER_ID := FND_API.G_MISS_NUM;
163: x_pvt_freight_rec.PRICING_LIST_LINE_ID := FND_API.G_MISS_NUM;
164: x_pvt_freight_rec.APPLIED_TO_CHARGE_ID := FND_API.G_MISS_NUM;
165: x_pvt_freight_rec.CHARGE_UNIT_VALUE := FND_API.G_MISS_NUM;
166: x_pvt_freight_rec.CHARGE_SOURCE_CODE := FND_API.G_MISS_CHAR;
167: x_pvt_freight_rec.LINE_TYPE_CODE := FND_API.G_MISS_CHAR;

Line 164: x_pvt_freight_rec.APPLIED_TO_CHARGE_ID := FND_API.G_MISS_NUM;

160: x_pvt_freight_rec.REQUEST_ID := p_pub_freight_rec.REQUEST_ID;
161:
162: x_pvt_freight_rec.PRICING_LIST_HEADER_ID := FND_API.G_MISS_NUM;
163: x_pvt_freight_rec.PRICING_LIST_LINE_ID := FND_API.G_MISS_NUM;
164: x_pvt_freight_rec.APPLIED_TO_CHARGE_ID := FND_API.G_MISS_NUM;
165: x_pvt_freight_rec.CHARGE_UNIT_VALUE := FND_API.G_MISS_NUM;
166: x_pvt_freight_rec.CHARGE_SOURCE_CODE := FND_API.G_MISS_CHAR;
167: x_pvt_freight_rec.LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
168: x_pvt_freight_rec.ESTIMATED_FLAG := FND_API.G_MISS_CHAR;

Line 165: x_pvt_freight_rec.CHARGE_UNIT_VALUE := FND_API.G_MISS_NUM;

161:
162: x_pvt_freight_rec.PRICING_LIST_HEADER_ID := FND_API.G_MISS_NUM;
163: x_pvt_freight_rec.PRICING_LIST_LINE_ID := FND_API.G_MISS_NUM;
164: x_pvt_freight_rec.APPLIED_TO_CHARGE_ID := FND_API.G_MISS_NUM;
165: x_pvt_freight_rec.CHARGE_UNIT_VALUE := FND_API.G_MISS_NUM;
166: x_pvt_freight_rec.CHARGE_SOURCE_CODE := FND_API.G_MISS_CHAR;
167: x_pvt_freight_rec.LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
168: x_pvt_freight_rec.ESTIMATED_FLAG := FND_API.G_MISS_CHAR;
169: x_pvt_freight_rec.FREIGHT_CODE := FND_API.G_MISS_CHAR;

Line 166: x_pvt_freight_rec.CHARGE_SOURCE_CODE := FND_API.G_MISS_CHAR;

162: x_pvt_freight_rec.PRICING_LIST_HEADER_ID := FND_API.G_MISS_NUM;
163: x_pvt_freight_rec.PRICING_LIST_LINE_ID := FND_API.G_MISS_NUM;
164: x_pvt_freight_rec.APPLIED_TO_CHARGE_ID := FND_API.G_MISS_NUM;
165: x_pvt_freight_rec.CHARGE_UNIT_VALUE := FND_API.G_MISS_NUM;
166: x_pvt_freight_rec.CHARGE_SOURCE_CODE := FND_API.G_MISS_CHAR;
167: x_pvt_freight_rec.LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
168: x_pvt_freight_rec.ESTIMATED_FLAG := FND_API.G_MISS_CHAR;
169: x_pvt_freight_rec.FREIGHT_CODE := FND_API.G_MISS_CHAR;
170: x_pvt_freight_rec.TRIP_NAME := p_pub_freight_rec.TRIP_NAME;

Line 167: x_pvt_freight_rec.LINE_TYPE_CODE := FND_API.G_MISS_CHAR;

163: x_pvt_freight_rec.PRICING_LIST_LINE_ID := FND_API.G_MISS_NUM;
164: x_pvt_freight_rec.APPLIED_TO_CHARGE_ID := FND_API.G_MISS_NUM;
165: x_pvt_freight_rec.CHARGE_UNIT_VALUE := FND_API.G_MISS_NUM;
166: x_pvt_freight_rec.CHARGE_SOURCE_CODE := FND_API.G_MISS_CHAR;
167: x_pvt_freight_rec.LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
168: x_pvt_freight_rec.ESTIMATED_FLAG := FND_API.G_MISS_CHAR;
169: x_pvt_freight_rec.FREIGHT_CODE := FND_API.G_MISS_CHAR;
170: x_pvt_freight_rec.TRIP_NAME := p_pub_freight_rec.TRIP_NAME;
171: x_pvt_freight_rec.DELIVERY_NAME := p_pub_freight_rec.DELIVERY_NAME;

Line 168: x_pvt_freight_rec.ESTIMATED_FLAG := FND_API.G_MISS_CHAR;

164: x_pvt_freight_rec.APPLIED_TO_CHARGE_ID := FND_API.G_MISS_NUM;
165: x_pvt_freight_rec.CHARGE_UNIT_VALUE := FND_API.G_MISS_NUM;
166: x_pvt_freight_rec.CHARGE_SOURCE_CODE := FND_API.G_MISS_CHAR;
167: x_pvt_freight_rec.LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
168: x_pvt_freight_rec.ESTIMATED_FLAG := FND_API.G_MISS_CHAR;
169: x_pvt_freight_rec.FREIGHT_CODE := FND_API.G_MISS_CHAR;
170: x_pvt_freight_rec.TRIP_NAME := p_pub_freight_rec.TRIP_NAME;
171: x_pvt_freight_rec.DELIVERY_NAME := p_pub_freight_rec.DELIVERY_NAME;
172: x_pvt_freight_rec.FREIGHT_COST_TYPE := p_pub_freight_rec.FREIGHT_COST_TYPE;

Line 169: x_pvt_freight_rec.FREIGHT_CODE := FND_API.G_MISS_CHAR;

165: x_pvt_freight_rec.CHARGE_UNIT_VALUE := FND_API.G_MISS_NUM;
166: x_pvt_freight_rec.CHARGE_SOURCE_CODE := FND_API.G_MISS_CHAR;
167: x_pvt_freight_rec.LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
168: x_pvt_freight_rec.ESTIMATED_FLAG := FND_API.G_MISS_CHAR;
169: x_pvt_freight_rec.FREIGHT_CODE := FND_API.G_MISS_CHAR;
170: x_pvt_freight_rec.TRIP_NAME := p_pub_freight_rec.TRIP_NAME;
171: x_pvt_freight_rec.DELIVERY_NAME := p_pub_freight_rec.DELIVERY_NAME;
172: x_pvt_freight_rec.FREIGHT_COST_TYPE := p_pub_freight_rec.FREIGHT_COST_TYPE;
173: x_pvt_freight_rec.STOP_LOCATION_ID := p_pub_freight_rec.STOP_LOCATION_ID;

Line 243: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN

239: IF l_debug_on THEN
240: wsh_debug_sv.push (l_module_name, 'Create_Update_Freight_Costs');
241: END IF;
242:
243: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:
247: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

240: wsh_debug_sv.push (l_module_name, 'Create_Update_Freight_Costs');
241: END IF;
242:
243: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:
247: IF FND_API.to_Boolean(p_init_msg_list) THEN
248: FND_MSG_PUB.initialize;

Line 247: IF FND_API.to_Boolean(p_init_msg_list) THEN

243: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:
247: IF FND_API.to_Boolean(p_init_msg_list) THEN
248: FND_MSG_PUB.initialize;
249: END IF;
250:
251: map_freightpub_to_pvt(

Line 260: raise FND_API.G_EXC_ERROR;

256: wsh_debug_sv.log(l_module_name, 'map_freightpub_to_pvt x_return_status',x_return_status);
257: END IF;
258:
259: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
260: raise FND_API.G_EXC_ERROR;
261: END IF;
262:
263: l_in_rec.caller:='PLSQL';
264: l_in_rec.phase:= 1;

Line 266: IF (p_pub_freight_costs.action_code IS NOT NULL and p_pub_freight_costs.action_code <> FND_API.G_MISS_CHAR) THEN

262:
263: l_in_rec.caller:='PLSQL';
264: l_in_rec.phase:= 1;
265:
266: IF (p_pub_freight_costs.action_code IS NOT NULL and p_pub_freight_costs.action_code <> FND_API.G_MISS_CHAR) THEN
267: l_in_rec.action_code:= p_pub_freight_costs.action_code;
268: ELSE
269: l_in_rec.action_code:= p_action_code;
270: END IF;

Line 298: WHEN FND_API.G_EXC_ERROR THEN

294: WSH_DEBUG_SV.pop(l_module_name);
295: END IF;
296:
297: EXCEPTION
298: WHEN FND_API.G_EXC_ERROR THEN
299: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
300: FND_MSG_PUB.Count_And_Get (
301: p_count => x_msg_count,
302: p_data => x_msg_data,

Line 303: p_encoded => FND_API.G_FALSE);

299: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
300: FND_MSG_PUB.Count_And_Get (
301: p_count => x_msg_count,
302: p_data => x_msg_data,
303: p_encoded => FND_API.G_FALSE);
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
306: WSH_DEBUG_SV.C_EXCEP_LEVEL);
307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 305: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',

301: p_count => x_msg_count,
302: p_data => x_msg_data,
303: p_encoded => FND_API.G_FALSE);
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
306: WSH_DEBUG_SV.C_EXCEP_LEVEL);
307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
308: END IF;
309:

Line 307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

303: p_encoded => FND_API.G_FALSE);
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
306: WSH_DEBUG_SV.C_EXCEP_LEVEL);
307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
308: END IF;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

306: WSH_DEBUG_SV.C_EXCEP_LEVEL);
307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
308: END IF;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
312: FND_MSG_PUB.Count_And_Get (
313: p_count => x_msg_count,
314: p_data => x_msg_data,

Line 315: p_encoded => FND_API.G_FALSE);

311: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
312: FND_MSG_PUB.Count_And_Get (
313: p_count => x_msg_count,
314: p_data => x_msg_data,
315: p_encoded => FND_API.G_FALSE);
316: IF l_debug_on THEN
317: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
318: WSH_DEBUG_SV.C_EXCEP_LEVEL);
319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 317: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',

313: p_count => x_msg_count,
314: p_data => x_msg_data,
315: p_encoded => FND_API.G_FALSE);
316: IF l_debug_on THEN
317: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
318: WSH_DEBUG_SV.C_EXCEP_LEVEL);
319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
320: END IF;
321:

Line 319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

315: p_encoded => FND_API.G_FALSE);
316: IF l_debug_on THEN
317: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
318: WSH_DEBUG_SV.C_EXCEP_LEVEL);
319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
320: END IF;
321:
322: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
323: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 327: p_encoded => FND_API.G_FALSE);

323: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
324: FND_MSG_PUB.Count_And_Get (
325: p_count => x_msg_count,
326: p_data => x_msg_data,
327: p_encoded => FND_API.G_FALSE);
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
330: WSH_DEBUG_SV.C_EXCEP_LEVEL);
331: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

Line 340: p_encoded => FND_API.G_FALSE);

336: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
337: FND_MSG_PUB.Count_And_Get (
338: p_count => x_msg_count,
339: p_data => x_msg_data,
340: p_encoded => FND_API.G_FALSE);
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
343: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');