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

Line 240: RAISE FND_API.G_EXC_ERROR;

236: l_module_name);
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.pop(l_module_name);
239: END IF;
240: RAISE FND_API.G_EXC_ERROR;
241: /*
242: l_loc_string := 'WRONG'|| g_loc_desc_Tab(l_counter).location_code;
243: */
244: END IF;

Line 485: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

481: IF l_debug_on THEN
482: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
483: END IF;
484:
485: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
486: OR (l_loc_rec.WSH_LOCATION_ID IS NULL) THEN
487: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
488: END IF;
489: g_org_Id_Tab(p_source_id) := l_loc_rec.WSH_LOCATION_ID;

Line 542: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS )

538: IF l_debug_on THEN
539: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
540: END IF;
541:
542: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS )
543: OR (l_loc_rec.WSH_LOCATION_ID IS NULL) THEN
544: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
545: END IF;
546: g_cust_Id_Tab(p_source_id) := l_loc_rec.WSH_LOCATION_ID;

Line 586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

582: IF l_debug_on THEN
583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');
584: END IF;
585: --
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
588: --
589: IF l_debug_on THEN
590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_EXC_UNEXPECTED_ERROR');

Line 593: WHEN FND_API.G_EXC_ERROR THEN

589: IF l_debug_on THEN
590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_EXC_UNEXPECTED_ERROR');
591: END IF;
592: --
593: WHEN FND_API.G_EXC_ERROR THEN
594: IF (NOT p_transfer_location)
595: AND (l_loc_rec.WSH_LOCATION_ID IS NULL) THEN
596: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
597: ELSE

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

700: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
701: --
702: IF l_debug_on THEN
703: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
704: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
705: END IF;
706: --
707:
708: END get_master_from_org;

Line 2126: FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE,

2122: END IF;
2123: --
2124: x_count := FND_MSG_PUB.count_msg;
2125:
2126: FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE,
2127: p_msg_index => x_count,
2128: p_data => x_summary,
2129: p_msg_index_out => l_tmp_out);
2130:

Line 2131: FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE,

2127: p_msg_index => x_count,
2128: p_data => x_summary,
2129: p_msg_index_out => l_tmp_out);
2130:
2131: FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE,
2132: p_msg_index => 1,
2133: p_data => l_tmp_buffer,
2134: p_msg_index_out => l_tmp_out);
2135:

Line 2140: FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE,

2136: x_details := l_tmp_buffer;
2137:
2138: FOR i IN 2..x_count-1 LOOP
2139:
2140: FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE,
2141: p_msg_index => i,
2142: p_data => l_tmp_buffer,
2143: p_msg_index_out => l_tmp_out);
2144:

Line 2213: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_UNEXP_ERROR, p_module_name);

2209: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
2210: FND_MESSAGE.Set_Token('PACKAGE',p_routine_name);
2211: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
2212: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
2213: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_UNEXP_ERROR, p_module_name);
2214:
2215: --
2216: -- Debug Statements
2217: --

Line 2627: , p_init_msg_list => fnd_api.g_false

2623: );
2624:
2625: wms_container_grp.LPN_Purge_Actions (
2626: p_api_version => 1.0
2627: , p_init_msg_list => fnd_api.g_false
2628: , p_commit => fnd_api.g_false
2629: , x_return_status => l_return_status
2630: , x_msg_count => l_msg_count
2631: , x_msg_data => l_msg_data

Line 2628: , p_commit => fnd_api.g_false

2624:
2625: wms_container_grp.LPN_Purge_Actions (
2626: p_api_version => 1.0
2627: , p_init_msg_list => fnd_api.g_false
2628: , p_commit => fnd_api.g_false
2629: , x_return_status => l_return_status
2630: , x_msg_count => l_msg_count
2631: , x_msg_data => l_msg_data
2632: , p_caller => 'WSH_DELETE'

Line 2638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2634: , p_lpn_purge_rec => l_lpn_ids
2635:
2636: );
2637: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2639: END IF;
2640: IF l_lpn_ids.lpn_ids.COUNT > 0 THEN
2641:
2642: FORALL i IN l_lpn_ids.lpn_ids.FIRST..l_lpn_ids.lpn_ids.LAST

Line 2879: , p_init_msg_list => fnd_api.g_false

2875:
2876: IF l_purged_lpns.lpn_ids.COUNT > 0 THEN
2877: wms_container_grp.LPN_Purge_Actions (
2878: p_api_version => 1.0
2879: , p_init_msg_list => fnd_api.g_false
2880: , p_commit => fnd_api.g_false
2881: , x_return_status => l_return_status
2882: , x_msg_count => l_msg_count
2883: , x_msg_data => l_msg_data

Line 2880: , p_commit => fnd_api.g_false

2876: IF l_purged_lpns.lpn_ids.COUNT > 0 THEN
2877: wms_container_grp.LPN_Purge_Actions (
2878: p_api_version => 1.0
2879: , p_init_msg_list => fnd_api.g_false
2880: , p_commit => fnd_api.g_false
2881: , x_return_status => l_return_status
2882: , x_msg_count => l_msg_count
2883: , x_msg_data => l_msg_data
2884: , p_caller => 'WSH_DELETE'

Line 2890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2886: , p_lpn_purge_rec => l_purged_lpns
2887:
2888: );
2889: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2891: END IF;
2892: END IF;
2893: END IF; --}
2894: END IF;

Line 3004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
3001: END IF;
3002: -- LPN CONV. rv
3003: --
3004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3005: ROLLBACK TO s_delete_savepoint;
3006: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3007:
3008: IF l_debug_on THEN

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

3007:
3008: IF l_debug_on THEN
3009: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle
3010: error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3011: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3012: END IF;
3013: WHEN OTHERS THEN
3014: ROLLBACK TO s_delete_savepoint;
3015: wsh_util_core.default_handler('WSH_UTIL_CORE.DELETE');

Line 3825: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3821: END IF;
3822: --
3823: --
3824: IF p_return_status IS NULL THEN
3825: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3826: ELSIF p_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3827: x_num_errors := nvl(x_num_errors,0) + 1;
3828: IF p_raise_error_flag THEN
3829: raise FND_API.G_EXC_ERROR;

Line 3829: raise FND_API.G_EXC_ERROR;

3825: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3826: ELSIF p_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3827: x_num_errors := nvl(x_num_errors,0) + 1;
3828: IF p_raise_error_flag THEN
3829: raise FND_API.G_EXC_ERROR;
3830: END IF;
3831: ELSIF p_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3832: x_num_errors := nvl(x_num_errors,0) + 1;
3833: IF p_raise_error_flag THEN

Line 3834: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3830: END IF;
3831: ELSIF p_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3832: x_num_errors := nvl(x_num_errors,0) + 1;
3833: IF p_raise_error_flag THEN
3834: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3835: END IF;
3836: ELSIF p_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3837: x_num_warnings := nvl(x_num_warnings,0) + 1;
3838: END IF;

Line 3854: WHEN FND_API.G_EXC_ERROR THEN

3850: --
3851: EXCEPTION
3852: --
3853: --
3854: WHEN FND_API.G_EXC_ERROR THEN
3855: --
3856: raise FND_API.G_EXC_ERROR;
3857: --
3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3856: raise FND_API.G_EXC_ERROR;

3852: --
3853: --
3854: WHEN FND_API.G_EXC_ERROR THEN
3855: --
3856: raise FND_API.G_EXC_ERROR;
3857: --
3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3859: --
3860: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3854: WHEN FND_API.G_EXC_ERROR THEN
3855: --
3856: raise FND_API.G_EXC_ERROR;
3857: --
3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3859: --
3860: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3861: --
3862: WHEN OTHERS THEN

Line 3860: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3856: raise FND_API.G_EXC_ERROR;
3857: --
3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3859: --
3860: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3861: --
3862: WHEN OTHERS THEN
3863: --
3864: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3864: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3860: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3861: --
3862: WHEN OTHERS THEN
3863: --
3864: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3865: --
3866: /*
3867: IF l_debug_on THEN
3868: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3950: WHEN FND_API.G_EXC_ERROR THEN

3946: p_msg_data => NULL,
3947: p_raise_error_flag => p_raise_error_flag);
3948:
3949: EXCEPTION
3950: WHEN FND_API.G_EXC_ERROR THEN
3951: raise FND_API.G_EXC_ERROR;
3952:
3953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3954: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3951: raise FND_API.G_EXC_ERROR;

3947: p_raise_error_flag => p_raise_error_flag);
3948:
3949: EXCEPTION
3950: WHEN FND_API.G_EXC_ERROR THEN
3951: raise FND_API.G_EXC_ERROR;
3952:
3953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3954: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3955:

Line 3953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3949: EXCEPTION
3950: WHEN FND_API.G_EXC_ERROR THEN
3951: raise FND_API.G_EXC_ERROR;
3952:
3953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3954: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3955:
3956: WHEN OTHERS THEN
3957: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3954: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3950: WHEN FND_API.G_EXC_ERROR THEN
3951: raise FND_API.G_EXC_ERROR;
3952:
3953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3954: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3955:
3956: WHEN OTHERS THEN
3957: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3958: END api_post_call;

Line 3957: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3954: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3955:
3956: WHEN OTHERS THEN
3957: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3958: END api_post_call;
3959: --Harmonization Project I **heali
3960:
3961: FUNCTION get_operatingUnit_id ( p_delivery_id IN NUMBER )

Line 4016: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4012: l_module_name);
4013: IF l_debug_on THEN
4014: WSH_DEBUG_SV.pop(l_module_name);
4015: END IF;
4016: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4017: END get_operatingUnit_id;
4018:
4019: --
4020: -- Name Store_Msg_In_Table

Line 4179: RAISE FND_API.G_EXC_ERROR ;

4175: IF p_key IS NULL THEN
4176: IF l_debug_on THEN
4177: WSH_DEBUG_SV.log(l_module_name, 'p_key cannot be null', p_key);
4178: END IF;
4179: RAISE FND_API.G_EXC_ERROR ;
4180: END IF;
4181: IF p_key < C_INDEX_LIMIT THEN
4182: p_cache_tbl(p_key).value := p_value;
4183: p_cache_tbl(p_key).key := p_key;

Line 4235: WHEN FND_API.G_EXC_ERROR THEN

4231: WSH_DEBUG_SV.pop(l_module_name);
4232: END IF;
4233: --
4234:
4235: WHEN FND_API.G_EXC_ERROR THEN
4236: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4237: --
4238: IF l_debug_on THEN
4239: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

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

4235: WHEN FND_API.G_EXC_ERROR THEN
4236: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4237: --
4238: IF l_debug_on THEN
4239: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4240: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4241: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4242: END IF;
4243: --

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

4237: --
4238: IF l_debug_on THEN
4239: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4240: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4241: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4242: END IF;
4243: --
4244: WHEN OTHERS THEN
4245: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 4253: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4250: 'Oracle error message is '||
4251: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4252: WSH_DEBUG_SV.pop(l_module_name,
4253: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4254: END IF;
4255:
4256: END get_cached_value;
4257:

Line 4330: RAISE FND_API.G_EXC_ERROR ;

4326: IF p_key IS NULL THEN
4327: IF l_debug_on THEN
4328: WSH_DEBUG_SV.log(l_module_name, 'p_key cannot be null', p_key);
4329: END IF;
4330: RAISE FND_API.G_EXC_ERROR ;
4331: END IF;
4332: IF p_key < C_INDEX_LIMIT THEN
4333: p_cache_tbl(p_key).value := p_value;
4334: p_cache_tbl(p_key).key := p_key;

Line 4387: WHEN FND_API.G_EXC_ERROR THEN

4383: WSH_DEBUG_SV.pop(l_module_name);
4384: END IF;
4385: --
4386:
4387: WHEN FND_API.G_EXC_ERROR THEN
4388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4389: --
4390: IF l_debug_on THEN
4391: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

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

4387: WHEN FND_API.G_EXC_ERROR THEN
4388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4389: --
4390: IF l_debug_on THEN
4391: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4392: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4394: END IF;
4395: --

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

4389: --
4390: IF l_debug_on THEN
4391: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4392: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4394: END IF;
4395: --
4396: WHEN OTHERS THEN
4397: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 4405: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4401: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4402: 'Oracle error message is '||
4403: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4404: WSH_DEBUG_SV.pop(l_module_name,
4405: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4406: END IF;
4407:
4408: END get_cached_value;
4409:

Line 4480: RAISE FND_API.G_EXC_ERROR ;

4476: IF p_key IS NULL THEN
4477: IF l_debug_on THEN
4478: WSH_DEBUG_SV.log(l_module_name, 'p_key cannot be null', p_key);
4479: END IF;
4480: RAISE FND_API.G_EXC_ERROR ;
4481: END IF;
4482: IF p_key < C_INDEX_LIMIT THEN
4483: p_cache_tbl(p_key).value := p_value;
4484: p_cache_tbl(p_key).key := p_key;

Line 4537: WHEN FND_API.G_EXC_ERROR THEN

4533: WSH_DEBUG_SV.pop(l_module_name);
4534: END IF;
4535: --
4536:
4537: WHEN FND_API.G_EXC_ERROR THEN
4538: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4539: --
4540: IF l_debug_on THEN
4541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

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

4537: WHEN FND_API.G_EXC_ERROR THEN
4538: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4539: --
4540: IF l_debug_on THEN
4541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4542: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4543: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4544: END IF;
4545: --

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

4539: --
4540: IF l_debug_on THEN
4541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4542: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4543: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4544: END IF;
4545: --
4546: WHEN OTHERS THEN
4547: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 4555: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4551: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4552: 'Oracle error message is '||
4553: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4554: WSH_DEBUG_SV.pop(l_module_name,
4555: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4556: END IF;
4557:
4558: END get_cached_value;
4559:

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

6602: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6603: --
6604: IF l_debug_on THEN
6605: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6606: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6607: END IF;
6608: --
6609: END get_idtab_from_string;
6610:

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

6660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6661: --
6662: IF l_debug_on THEN
6663: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6665: END IF;
6666: --
6667: END get_string_from_idtab;
6668:

Line 6945: WHEN FND_API.G_EXC_ERROR THEN

6941: END IF;
6942:
6943:
6944: EXCEPTION
6945: WHEN FND_API.G_EXC_ERROR THEN
6946: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6947: --
6948: -- Debug Statements
6949: --

Line 6951: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

6947: --
6948: -- Debug Statements
6949: --
6950: IF l_debug_on THEN
6951: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6952: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6953: END IF;
6954: --
6955: --call to reset the global cache tables

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

6960: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6961: END IF;
6962: --
6963: IF l_debug_on THEN
6964: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6965: END IF;
6966:
6967:
6968: WHEN others THEN

Line 7356: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7352: x_id_tab => l_customer_id_tab,
7353: x_return_status => l_return_status);
7354:
7355: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7356: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7357: END IF;
7358:
7359: itr := l_customer_id_tab.FIRST;
7360:

Line 7410: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7406: WSH_DEBUG_SV.logmsg(l_module_name,'Org String '||l_cust_string);
7407: END IF;
7408:
7409: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7410: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7411: END IF;
7412:
7413: END IF;
7414:

Line 7449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7445: END IF;
7446: --
7447:
7448: EXCEPTION
7449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7450: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7451: --
7452: IF l_debug_on THEN
7453: WSH_DEBUG_SV.pop(l_module_name,'FND_API.EXCEPTION:G_EXC_UNEXPECTED_ERROR');

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

7449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7450: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7451: --
7452: IF l_debug_on THEN
7453: WSH_DEBUG_SV.pop(l_module_name,'FND_API.EXCEPTION:G_EXC_UNEXPECTED_ERROR');
7454: END IF;
7455: WHEN others THEN
7456: IF c_get_customer%ISOPEN THEN
7457: CLOSE c_get_customer;

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

7460: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7461: --
7462: IF l_debug_on THEN
7463: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7464: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7465: END IF;
7466: --
7467: END get_customer_from_loc;
7468:

Line 7522: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7518: x_id_tab => l_organization_tab,
7519: x_return_status => l_return_status);
7520:
7521: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7522: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7523: END IF;
7524:
7525: itr := l_organization_tab.FIRST;
7526:

Line 7564: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7560: WSH_DEBUG_SV.logmsg(l_module_name,'Org String '||l_org_string);
7561: END IF;
7562:
7563: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7564: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7565: END IF;
7566:
7567: END IF;
7568:

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

7607:
7608: --
7609: IF l_debug_on THEN
7610: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7611: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7612: END IF;
7613: --
7614: END get_org_from_location;
7615:

Line 8089: RAISE FND_API.G_EXC_ERROR;

8085:
8086: IF ( (l_return_status = 'E')
8087: OR (l_return_status = 'U') )
8088: THEN
8089: RAISE FND_API.G_EXC_ERROR;
8090: END IF;
8091:
8092: SELECT shipments_type_flag INTO l_typeflag
8093: FROM WSH_TRIPS

Line 8165: WHEN FND_API.G_EXC_ERROR THEN

8161:
8162: --}
8163: EXCEPTION
8164: --{
8165: WHEN FND_API.G_EXC_ERROR THEN
8166: IF l_debug_on THEN
8167: WSH_DEBUG_SV.pop(l_module_name);
8168: END IF;
8169: return null;

Line 8171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8167: WSH_DEBUG_SV.pop(l_module_name);
8168: END IF;
8169: return null;
8170:
8171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8172: IF l_debug_on THEN
8173: WSH_DEBUG_SV.pop(l_module_name);
8174: END IF;
8175: return null;

Line 8341: WHEN FND_API.G_EXC_ERROR THEN

8337:
8338: --}
8339: EXCEPTION
8340: --{
8341: WHEN FND_API.G_EXC_ERROR THEN
8342: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8343: IF l_debug_on THEN
8344: WSH_DEBUG_SV.pop(l_module_name);
8345: END IF;

Line 8347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8343: IF l_debug_on THEN
8344: WSH_DEBUG_SV.pop(l_module_name);
8345: END IF;
8346:
8347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8349: IF l_debug_on THEN
8350: WSH_DEBUG_SV.pop(l_module_name);
8351: END IF;

Line 8348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8344: WSH_DEBUG_SV.pop(l_module_name);
8345: END IF;
8346:
8347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8349: IF l_debug_on THEN
8350: WSH_DEBUG_SV.pop(l_module_name);
8351: END IF;
8352: WHEN OTHERS THEN