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 244: RAISE FND_API.G_EXC_ERROR;

240: l_module_name);
241: IF l_debug_on THEN
242: WSH_DEBUG_SV.pop(l_module_name);
243: END IF;
244: RAISE FND_API.G_EXC_ERROR;
245: /*
246: l_loc_string := 'WRONG'|| g_loc_desc_Tab(l_counter).location_code;
247: */
248: END IF;

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

489: IF l_debug_on THEN
490: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
491: END IF;
492:
493: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
494: OR (l_loc_rec.WSH_LOCATION_ID IS NULL) THEN
495: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
496: END IF;
497: g_org_Id_Tab(l_source_id_mod) := l_loc_rec.WSH_LOCATION_ID; --bug 8514165 replaced p_source_id with l_source_id_mod

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

546: IF l_debug_on THEN
547: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
548: END IF;
549:
550: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS )
551: OR (l_loc_rec.WSH_LOCATION_ID IS NULL) THEN
552: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
553: END IF;
554: g_cust_Id_Tab(l_source_id_mod) := l_loc_rec.WSH_LOCATION_ID; --bug 8514165 replaced p_source_id with l_source_id_mod

Line 594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

590: IF l_debug_on THEN
591: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');
592: END IF;
593: --
594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
595: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
596: --
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_EXC_UNEXPECTED_ERROR');

Line 601: WHEN FND_API.G_EXC_ERROR THEN

597: IF l_debug_on THEN
598: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_EXC_UNEXPECTED_ERROR');
599: END IF;
600: --
601: WHEN FND_API.G_EXC_ERROR THEN
602: IF (NOT p_transfer_location)
603: AND (l_loc_rec.WSH_LOCATION_ID IS NULL) THEN
604: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
605: ELSE

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

708: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
709: --
710: IF l_debug_on THEN
711: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
712: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
713: END IF;
714: --
715:
716: END get_master_from_org;

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

2130: END IF;
2131: --
2132: x_count := FND_MSG_PUB.count_msg;
2133:
2134: FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE,
2135: p_msg_index => x_count,
2136: p_data => x_summary,
2137: p_msg_index_out => l_tmp_out);
2138:

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

2135: p_msg_index => x_count,
2136: p_data => x_summary,
2137: p_msg_index_out => l_tmp_out);
2138:
2139: FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE,
2140: p_msg_index => 1,
2141: p_data => l_tmp_buffer,
2142: p_msg_index_out => l_tmp_out);
2143:

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

2144: x_details := l_tmp_buffer;
2145:
2146: FOR i IN 2..x_count-1 LOOP
2147:
2148: FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE,
2149: p_msg_index => i,
2150: p_data => l_tmp_buffer,
2151: p_msg_index_out => l_tmp_out);
2152:

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

2217: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
2218: FND_MESSAGE.Set_Token('PACKAGE',p_routine_name);
2219: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
2220: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
2221: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_UNEXP_ERROR, p_module_name);
2222:
2223: --
2224: -- Debug Statements
2225: --

Line 2663: , p_init_msg_list => fnd_api.g_false

2659: );
2660:
2661: wms_container_grp.LPN_Purge_Actions (
2662: p_api_version => 1.0
2663: , p_init_msg_list => fnd_api.g_false
2664: , p_commit => fnd_api.g_false
2665: , x_return_status => l_return_status
2666: , x_msg_count => l_msg_count
2667: , x_msg_data => l_msg_data

Line 2664: , p_commit => fnd_api.g_false

2660:
2661: wms_container_grp.LPN_Purge_Actions (
2662: p_api_version => 1.0
2663: , p_init_msg_list => fnd_api.g_false
2664: , p_commit => fnd_api.g_false
2665: , x_return_status => l_return_status
2666: , x_msg_count => l_msg_count
2667: , x_msg_data => l_msg_data
2668: , p_caller => 'WSH_DELETE'

Line 2674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2670: , p_lpn_purge_rec => l_lpn_ids
2671:
2672: );
2673: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2675: END IF;
2676: IF l_lpn_ids.lpn_ids.COUNT > 0 THEN
2677:
2678: FORALL i IN l_lpn_ids.lpn_ids.FIRST..l_lpn_ids.lpn_ids.LAST

Line 2915: , p_init_msg_list => fnd_api.g_false

2911:
2912: IF l_purged_lpns.lpn_ids.COUNT > 0 THEN
2913: wms_container_grp.LPN_Purge_Actions (
2914: p_api_version => 1.0
2915: , p_init_msg_list => fnd_api.g_false
2916: , p_commit => fnd_api.g_false
2917: , x_return_status => l_return_status
2918: , x_msg_count => l_msg_count
2919: , x_msg_data => l_msg_data

Line 2916: , p_commit => fnd_api.g_false

2912: IF l_purged_lpns.lpn_ids.COUNT > 0 THEN
2913: wms_container_grp.LPN_Purge_Actions (
2914: p_api_version => 1.0
2915: , p_init_msg_list => fnd_api.g_false
2916: , p_commit => fnd_api.g_false
2917: , x_return_status => l_return_status
2918: , x_msg_count => l_msg_count
2919: , x_msg_data => l_msg_data
2920: , p_caller => 'WSH_DELETE'

Line 2926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2922: , p_lpn_purge_rec => l_purged_lpns
2923:
2924: );
2925: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2927: END IF;
2928: END IF;
2929: END IF; --}
2930: END IF;

Line 3040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3036: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
3037: END IF;
3038: -- LPN CONV. rv
3039: --
3040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3041: ROLLBACK TO s_delete_savepoint;
3042: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3043:
3044: IF l_debug_on THEN

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

3043:
3044: IF l_debug_on THEN
3045: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle
3046: error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3047: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3048: END IF;
3049: WHEN OTHERS THEN
3050: ROLLBACK TO s_delete_savepoint;
3051: wsh_util_core.default_handler('WSH_UTIL_CORE.DELETE');

Line 3861: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3857: END IF;
3858: --
3859: --
3860: IF p_return_status IS NULL THEN
3861: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3862: ELSIF p_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3863: x_num_errors := nvl(x_num_errors,0) + 1;
3864: IF p_raise_error_flag THEN
3865: raise FND_API.G_EXC_ERROR;

Line 3865: raise FND_API.G_EXC_ERROR;

3861: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3862: ELSIF p_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3863: x_num_errors := nvl(x_num_errors,0) + 1;
3864: IF p_raise_error_flag THEN
3865: raise FND_API.G_EXC_ERROR;
3866: END IF;
3867: ELSIF p_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3868: x_num_errors := nvl(x_num_errors,0) + 1;
3869: IF p_raise_error_flag THEN

Line 3870: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3866: END IF;
3867: ELSIF p_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3868: x_num_errors := nvl(x_num_errors,0) + 1;
3869: IF p_raise_error_flag THEN
3870: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3871: END IF;
3872: ELSIF p_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3873: x_num_warnings := nvl(x_num_warnings,0) + 1;
3874: END IF;

Line 3890: WHEN FND_API.G_EXC_ERROR THEN

3886: --
3887: EXCEPTION
3888: --
3889: --
3890: WHEN FND_API.G_EXC_ERROR THEN
3891: --
3892: raise FND_API.G_EXC_ERROR;
3893: --
3894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3892: raise FND_API.G_EXC_ERROR;

3888: --
3889: --
3890: WHEN FND_API.G_EXC_ERROR THEN
3891: --
3892: raise FND_API.G_EXC_ERROR;
3893: --
3894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3895: --
3896: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3890: WHEN FND_API.G_EXC_ERROR THEN
3891: --
3892: raise FND_API.G_EXC_ERROR;
3893: --
3894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3895: --
3896: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3897: --
3898: WHEN OTHERS THEN

Line 3896: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3892: raise FND_API.G_EXC_ERROR;
3893: --
3894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3895: --
3896: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3897: --
3898: WHEN OTHERS THEN
3899: --
3900: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3900: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3896: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3897: --
3898: WHEN OTHERS THEN
3899: --
3900: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3901: --
3902: /*
3903: IF l_debug_on THEN
3904: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3986: WHEN FND_API.G_EXC_ERROR THEN

3982: p_msg_data => NULL,
3983: p_raise_error_flag => p_raise_error_flag);
3984:
3985: EXCEPTION
3986: WHEN FND_API.G_EXC_ERROR THEN
3987: raise FND_API.G_EXC_ERROR;
3988:
3989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3990: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3987: raise FND_API.G_EXC_ERROR;

3983: p_raise_error_flag => p_raise_error_flag);
3984:
3985: EXCEPTION
3986: WHEN FND_API.G_EXC_ERROR THEN
3987: raise FND_API.G_EXC_ERROR;
3988:
3989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3990: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3991:

Line 3989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3985: EXCEPTION
3986: WHEN FND_API.G_EXC_ERROR THEN
3987: raise FND_API.G_EXC_ERROR;
3988:
3989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3990: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3991:
3992: WHEN OTHERS THEN
3993: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3990: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3986: WHEN FND_API.G_EXC_ERROR THEN
3987: raise FND_API.G_EXC_ERROR;
3988:
3989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3990: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3991:
3992: WHEN OTHERS THEN
3993: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3994: END api_post_call;

Line 3993: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3990: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3991:
3992: WHEN OTHERS THEN
3993: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3994: END api_post_call;
3995: --Harmonization Project I **heali
3996:
3997: FUNCTION get_operatingUnit_id ( p_delivery_id IN NUMBER )

Line 4052: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4048: l_module_name);
4049: IF l_debug_on THEN
4050: WSH_DEBUG_SV.pop(l_module_name);
4051: END IF;
4052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4053: END get_operatingUnit_id;
4054:
4055: --
4056: -- Name Store_Msg_In_Table

Line 4215: RAISE FND_API.G_EXC_ERROR ;

4211: IF p_key IS NULL THEN
4212: IF l_debug_on THEN
4213: WSH_DEBUG_SV.log(l_module_name, 'p_key cannot be null', p_key);
4214: END IF;
4215: RAISE FND_API.G_EXC_ERROR ;
4216: END IF;
4217: IF p_key < C_INDEX_LIMIT THEN
4218: p_cache_tbl(p_key).value := p_value;
4219: p_cache_tbl(p_key).key := p_key;

Line 4271: WHEN FND_API.G_EXC_ERROR THEN

4267: WSH_DEBUG_SV.pop(l_module_name);
4268: END IF;
4269: --
4270:
4271: WHEN FND_API.G_EXC_ERROR THEN
4272: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4273: --
4274: IF l_debug_on THEN
4275: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

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

4271: WHEN FND_API.G_EXC_ERROR THEN
4272: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4273: --
4274: IF l_debug_on THEN
4275: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4276: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4277: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4278: END IF;
4279: --

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

4273: --
4274: IF l_debug_on THEN
4275: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4276: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4277: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4278: END IF;
4279: --
4280: WHEN OTHERS THEN
4281: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

4285: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4286: 'Oracle error message is '||
4287: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4288: WSH_DEBUG_SV.pop(l_module_name,
4289: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4290: END IF;
4291:
4292: END get_cached_value;
4293:

Line 4366: RAISE FND_API.G_EXC_ERROR ;

4362: IF p_key IS NULL THEN
4363: IF l_debug_on THEN
4364: WSH_DEBUG_SV.log(l_module_name, 'p_key cannot be null', p_key);
4365: END IF;
4366: RAISE FND_API.G_EXC_ERROR ;
4367: END IF;
4368: IF p_key < C_INDEX_LIMIT THEN
4369: p_cache_tbl(p_key).value := p_value;
4370: p_cache_tbl(p_key).key := p_key;

Line 4423: WHEN FND_API.G_EXC_ERROR THEN

4419: WSH_DEBUG_SV.pop(l_module_name);
4420: END IF;
4421: --
4422:
4423: WHEN FND_API.G_EXC_ERROR THEN
4424: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4425: --
4426: IF l_debug_on THEN
4427: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

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

4423: WHEN FND_API.G_EXC_ERROR THEN
4424: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4425: --
4426: IF l_debug_on THEN
4427: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4428: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4429: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4430: END IF;
4431: --

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

4425: --
4426: IF l_debug_on THEN
4427: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4428: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4429: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4430: END IF;
4431: --
4432: WHEN OTHERS THEN
4433: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

4437: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4438: 'Oracle error message is '||
4439: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4440: WSH_DEBUG_SV.pop(l_module_name,
4441: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4442: END IF;
4443:
4444: END get_cached_value;
4445:

Line 4516: RAISE FND_API.G_EXC_ERROR ;

4512: IF p_key IS NULL THEN
4513: IF l_debug_on THEN
4514: WSH_DEBUG_SV.log(l_module_name, 'p_key cannot be null', p_key);
4515: END IF;
4516: RAISE FND_API.G_EXC_ERROR ;
4517: END IF;
4518: IF p_key < C_INDEX_LIMIT THEN
4519: p_cache_tbl(p_key).value := p_value;
4520: p_cache_tbl(p_key).key := p_key;

Line 4573: WHEN FND_API.G_EXC_ERROR THEN

4569: WSH_DEBUG_SV.pop(l_module_name);
4570: END IF;
4571: --
4572:
4573: WHEN FND_API.G_EXC_ERROR THEN
4574: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4575: --
4576: IF l_debug_on THEN
4577: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

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

4573: WHEN FND_API.G_EXC_ERROR THEN
4574: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4575: --
4576: IF l_debug_on THEN
4577: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4578: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4580: END IF;
4581: --

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

4575: --
4576: IF l_debug_on THEN
4577: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4578: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4580: END IF;
4581: --
4582: WHEN OTHERS THEN
4583: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

4587: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4588: 'Oracle error message is '||
4589: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4590: WSH_DEBUG_SV.pop(l_module_name,
4591: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4592: END IF;
4593:
4594: END get_cached_value;
4595:

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

6638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6639: --
6640: IF l_debug_on THEN
6641: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6642: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6643: END IF;
6644: --
6645: END get_idtab_from_string;
6646:

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

6696: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6697: --
6698: IF l_debug_on THEN
6699: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6700: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6701: END IF;
6702: --
6703: END get_string_from_idtab;
6704:

Line 6981: WHEN FND_API.G_EXC_ERROR THEN

6977: END IF;
6978:
6979:
6980: EXCEPTION
6981: WHEN FND_API.G_EXC_ERROR THEN
6982: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6983: --
6984: -- Debug Statements
6985: --

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

6983: --
6984: -- Debug Statements
6985: --
6986: IF l_debug_on THEN
6987: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6988: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6989: END IF;
6990: --
6991: --call to reset the global cache tables

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

6996: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6997: END IF;
6998: --
6999: IF l_debug_on THEN
7000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7001: END IF;
7002:
7003:
7004: WHEN others THEN

Line 7392: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7388: x_id_tab => l_customer_id_tab,
7389: x_return_status => l_return_status);
7390:
7391: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7392: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7393: END IF;
7394:
7395: itr := l_customer_id_tab.FIRST;
7396:

Line 7446: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7442: WSH_DEBUG_SV.logmsg(l_module_name,'Org String '||l_cust_string);
7443: END IF;
7444:
7445: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7446: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7447: END IF;
7448:
7449: END IF;
7450:

Line 7485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7481: END IF;
7482: --
7483:
7484: EXCEPTION
7485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7486: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7487: --
7488: IF l_debug_on THEN
7489: WSH_DEBUG_SV.pop(l_module_name,'FND_API.EXCEPTION:G_EXC_UNEXPECTED_ERROR');

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

7485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7486: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7487: --
7488: IF l_debug_on THEN
7489: WSH_DEBUG_SV.pop(l_module_name,'FND_API.EXCEPTION:G_EXC_UNEXPECTED_ERROR');
7490: END IF;
7491: WHEN others THEN
7492: IF c_get_customer%ISOPEN THEN
7493: CLOSE c_get_customer;

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

7496: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7497: --
7498: IF l_debug_on THEN
7499: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7501: END IF;
7502: --
7503: END get_customer_from_loc;
7504:

Line 7558: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7554: x_id_tab => l_organization_tab,
7555: x_return_status => l_return_status);
7556:
7557: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7558: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7559: END IF;
7560:
7561: itr := l_organization_tab.FIRST;
7562:

Line 7600: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7596: WSH_DEBUG_SV.logmsg(l_module_name,'Org String '||l_org_string);
7597: END IF;
7598:
7599: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7600: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7601: END IF;
7602:
7603: END IF;
7604:

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

7643:
7644: --
7645: IF l_debug_on THEN
7646: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7648: END IF;
7649: --
7650: END get_org_from_location;
7651:

Line 8125: RAISE FND_API.G_EXC_ERROR;

8121:
8122: IF ( (l_return_status = 'E')
8123: OR (l_return_status = 'U') )
8124: THEN
8125: RAISE FND_API.G_EXC_ERROR;
8126: END IF;
8127:
8128: SELECT shipments_type_flag INTO l_typeflag
8129: FROM WSH_TRIPS

Line 8201: WHEN FND_API.G_EXC_ERROR THEN

8197:
8198: --}
8199: EXCEPTION
8200: --{
8201: WHEN FND_API.G_EXC_ERROR THEN
8202: IF l_debug_on THEN
8203: WSH_DEBUG_SV.pop(l_module_name);
8204: END IF;
8205: return null;

Line 8207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8203: WSH_DEBUG_SV.pop(l_module_name);
8204: END IF;
8205: return null;
8206:
8207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8208: IF l_debug_on THEN
8209: WSH_DEBUG_SV.pop(l_module_name);
8210: END IF;
8211: return null;

Line 8377: WHEN FND_API.G_EXC_ERROR THEN

8373:
8374: --}
8375: EXCEPTION
8376: --{
8377: WHEN FND_API.G_EXC_ERROR THEN
8378: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8379: IF l_debug_on THEN
8380: WSH_DEBUG_SV.pop(l_module_name);
8381: END IF;

Line 8383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8379: IF l_debug_on THEN
8380: WSH_DEBUG_SV.pop(l_module_name);
8381: END IF;
8382:
8383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8385: IF l_debug_on THEN
8386: WSH_DEBUG_SV.pop(l_module_name);
8387: END IF;

Line 8384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8380: WSH_DEBUG_SV.pop(l_module_name);
8381: END IF;
8382:
8383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8385: IF l_debug_on THEN
8386: WSH_DEBUG_SV.pop(l_module_name);
8387: END IF;
8388: WHEN OTHERS THEN

Line 8499: -- Oracle Forms.From plsql we can call the FND API FND_PROFILE.PUT directly to set

8495: -- PARAMATERS: p_name - Name of the profile to be set.
8496: -- p_value - Value for the profile to be set.
8497: -- MODIFIED :
8498: -- DESC : This will set the FND_PROFILE for the DB cache.This API will only be called from
8499: -- Oracle Forms.From plsql we can call the FND API FND_PROFILE.PUT directly to set
8500: -- the same profile.
8501: --========================================================================
8502:
8503: PROCEDURE SET_FND_PROFILE(