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

Line 17: -- p_init_msg_list FND_API.G_TRUE to reset list

13: --========================================================================
14: -- PROCEDURE : Assign_Org_Carrier_Service PUBLIC
15: --
16: -- PARAMETERS: p_api_version_number known api version error number
17: -- p_init_msg_list FND_API.G_TRUE to reset list
18: -- p_commit FND_API.G_TRUE to commit.
19: -- p_action_code Valid action codes are
20: -- 'ASSIGN','UNASSIGN'
21: -- p_org_info_tab Input table variable containing org_id and org_code for which needs to be assigned/unassigned

Line 18: -- p_commit FND_API.G_TRUE to commit.

14: -- PROCEDURE : Assign_Org_Carrier_Service PUBLIC
15: --
16: -- PARAMETERS: p_api_version_number known api version error number
17: -- p_init_msg_list FND_API.G_TRUE to reset list
18: -- p_commit FND_API.G_TRUE to commit.
19: -- p_action_code Valid action codes are
20: -- 'ASSIGN','UNASSIGN'
21: -- p_org_info_tab Input table variable containing org_id and org_code for which needs to be assigned/unassigned
22: -- p_carrier_id Carrier Id of the carrier

Line 60: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

56:
57: PROCEDURE Assign_Org_Carrier_Service
58: ( p_api_version_number IN NUMBER,
59: p_init_msg_list IN VARCHAR2,
60: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
61: p_action_code IN VARCHAR2,
62: p_org_info_tab IN WSH_CARRIERS_PUB.Org_Info_Tab_Type,
63: p_carrier_id IN NUMBER DEFAULT NULL,
64: p_freight_code IN VARCHAR2 DEFAULT NULL,

Line 178: IF NOT FND_API.Compatible_API_Call

174: IF l_debug_on IS NULL
175: THEN
176: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
177: END IF;
178: IF NOT FND_API.Compatible_API_Call
179: (
180: l_api_version_number,
181: p_api_version_number,
182: l_api_name,

Line 186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

182: l_api_name,
183: G_PKG_NAME
184: )
185: THEN
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: END IF;
188:
189: IF FND_API.to_Boolean(p_init_msg_list) THEN
190: FND_MSG_PUB.initialize;

Line 189: IF FND_API.to_Boolean(p_init_msg_list) THEN

185: THEN
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: END IF;
188:
189: IF FND_API.to_Boolean(p_init_msg_list) THEN
190: FND_MSG_PUB.initialize;
191: END IF;
192:
193: IF l_debug_on THEN

Line 220: IF ( NVL(p_org_info_tab(l_temp).org_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM ) OR

216:
217: IF l_temp is not null THEN
218: LOOP
219: -- Exchange the org values from p_org_info_tab to l_org_info_tab only if either org_id / org_code is not null.
220: IF ( NVL(p_org_info_tab(l_temp).org_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM ) OR
221: ( NVL(p_org_info_tab(l_temp).org_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR ) THEN
222: --{
223: l_org_info_tab(l_org_info_tab.count+1).org_id := p_org_info_tab(l_temp).org_id;
224: l_org_info_tab(l_org_info_tab.count).org_code := p_org_info_tab(l_temp).org_code;

Line 221: ( NVL(p_org_info_tab(l_temp).org_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR ) THEN

217: IF l_temp is not null THEN
218: LOOP
219: -- Exchange the org values from p_org_info_tab to l_org_info_tab only if either org_id / org_code is not null.
220: IF ( NVL(p_org_info_tab(l_temp).org_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM ) OR
221: ( NVL(p_org_info_tab(l_temp).org_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR ) THEN
222: --{
223: l_org_info_tab(l_org_info_tab.count+1).org_id := p_org_info_tab(l_temp).org_id;
224: l_org_info_tab(l_org_info_tab.count).org_code := p_org_info_tab(l_temp).org_code;
225: --}

Line 257: RAISE FND_API.G_EXC_ERROR;

253: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
254: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_param_name);
255: x_return_status := wsh_util_core.g_ret_sts_error;
256: wsh_util_core.add_message(x_return_status,l_module_name);
257: RAISE FND_API.G_EXC_ERROR;
258: --}
259: END IF;
260:
261: IF p_action_code NOT IN ('ASSIGN','UNASSIGN') THEN

Line 267: RAISE FND_API.G_EXC_ERROR;

263: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
264: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_code);
265: x_return_status := wsh_util_core.g_ret_sts_error;
266: wsh_util_core.add_message(x_return_status,l_module_name);
267: RAISE FND_API.G_EXC_ERROR;
268: --}
269: END IF;
270:
271: IF l_debug_on THEN

Line 319: RAISE FND_API.G_EXC_ERROR;

315: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE'); --Bug 9706100 added error message
316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Carrier Service Id');
317: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
318: wsh_util_core.add_message(x_return_status,l_module_name);
319: RAISE FND_API.G_EXC_ERROR;
320: --}
321: END IF;
322:
323: CLOSE c_check_carrier_ser_exists;

Line 361: RAISE FND_API.G_EXC_ERROR;

357: CLOSE c_check_carrier_sm_exists;
358: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD'); --Bug 9706100 added error message
359: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
360: wsh_util_core.add_message(x_return_status,l_module_name);
361: RAISE FND_API.G_EXC_ERROR;
362: --}
363: END IF;
364:
365: CLOSE c_check_carrier_sm_exists;

Line 494: WHEN FND_API.G_EXC_ERROR THEN

490: WSH_DEBUG_SV.pop(l_module_name);
491: END IF;
492:
493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN
495: --{
496: IF c_check_carrier_ser_exists%ISOPEN THEN
497: CLOSE c_check_carrier_ser_exists;
498: END IF;

Line 508: x_return_status := FND_API.G_RET_STS_ERROR;

504: IF get_carrier_ser_info%ISOPEN THEN
505: CLOSE get_carrier_ser_info;
506: END IF;
507:
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: -- Get message count and data
510: FND_MSG_PUB.Count_And_Get (
511: p_count => x_msg_count,
512: p_data => x_msg_data );

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

512: p_data => x_msg_data );
513: --
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'Expected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
517: END IF;
518: --
519: --}
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
517: END IF;
518: --
519: --}
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: --{
522: IF c_check_carrier_ser_exists%ISOPEN THEN
523: CLOSE c_check_carrier_ser_exists;
524: END IF;

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

530: IF get_carrier_ser_info%ISOPEN THEN
531: CLOSE get_carrier_ser_info;
532: END IF;
533:
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
535: -- Get message count and data
536: FND_MSG_PUB.Count_And_Get(
537: p_count => x_msg_count ,
538: p_data => x_msg_data );

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

538: p_data => x_msg_data );
539: --
540: IF l_debug_on THEN
541: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
543: END IF;
544: --}
545: WHEN OTHERS THEN
546: --{

Line 559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

555: IF get_carrier_ser_info%ISOPEN THEN
556: CLOSE get_carrier_ser_info;
557: END IF;
558:
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
561: FND_MSG_PUB.Add_Exc_Msg
562: (
563: G_PKG_NAME