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

Line 1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1295: IF l_debug_on THEN
1296: WSH_DEBUG_SV.log(l_module_name,'Error negative p_stops_per_batch',
1297: p_stops_per_batch );
1298: END IF;
1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1300: ELSE
1301: l_stops_per_batch := p_stops_per_batch;
1302: END IF;
1303:

Line 2349: raise fnd_api.g_exc_error;

2345: WSH_DEBUG_SV.log(l_module_name,'WSH_TRX_HANDLER.INSERT_ROW_BULK l_return_status',l_return_status);
2346: END IF;
2347:
2348: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) then
2349: raise fnd_api.g_exc_error;
2350: END IF;
2351: END IF;
2352:
2353:

Line 2365: raise fnd_api.g_exc_error;

2361: WSH_DEBUG_SV.log(l_module_name,'WSH_TRXSN_HANDLER.INSERT_ROW_BULK l_return_status',l_return_status);
2362: END IF;
2363:
2364: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) then
2365: raise fnd_api.g_exc_error;
2366: END IF;
2367:
2368: p_mtl_ser_txn_if_rec.source_code.delete;
2369: p_mtl_ser_txn_if_rec.source_line_id.delete;

Line 2389: raise fnd_api.g_exc_error;

2385: WSH_DEBUG_SV.log(l_module_name,'WSH_TRXLOT_HANDLER.INSERT_ROW_BULK l_return_status',l_return_status);
2386: END IF;
2387:
2388: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) then
2389: raise fnd_api.g_exc_error;
2390: END IF;
2391:
2392: p_mtl_lot_txn_if_rec.source_code.delete;
2393: p_mtl_lot_txn_if_rec.source_line_id.delete;

Line 2413: WHEN FND_API.G_EXC_ERROR THEN

2409: WSH_DEBUG_SV.pop(l_module_name);
2410: END IF;
2411:
2412: EXCEPTION
2413: WHEN FND_API.G_EXC_ERROR THEN
2414: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2415:
2416: IF l_debug_on THEN
2417: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

2413: WHEN FND_API.G_EXC_ERROR THEN
2414: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2415:
2416: IF l_debug_on THEN
2417: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2419: END IF;
2420:
2421: ROLLBACK TO SAVEPOINT sp_insert_inv_records;

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

2414: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2415:
2416: IF l_debug_on THEN
2417: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2419: END IF;
2420:
2421: ROLLBACK TO SAVEPOINT sp_insert_inv_records;
2422:

Line 2948: l_cache_trip_sm := FND_API.G_MISS_CHAR;

2944:
2945: l_start_index := l_index;
2946:
2947: -- FP bug 4166635: reset the cache for default freight code
2948: l_cache_trip_sm := FND_API.G_MISS_CHAR;
2949: l_cache_trip_org_id := FND_API.G_MISS_NUM;
2950: l_cache_trip_fc := NULL;
2951: l_cache_del_id := FND_API.G_MISS_NUM;
2952: l_cache_del_fc := NULL;

Line 2949: l_cache_trip_org_id := FND_API.G_MISS_NUM;

2945: l_start_index := l_index;
2946:
2947: -- FP bug 4166635: reset the cache for default freight code
2948: l_cache_trip_sm := FND_API.G_MISS_CHAR;
2949: l_cache_trip_org_id := FND_API.G_MISS_NUM;
2950: l_cache_trip_fc := NULL;
2951: l_cache_del_id := FND_API.G_MISS_NUM;
2952: l_cache_del_fc := NULL;
2953:

Line 2951: l_cache_del_id := FND_API.G_MISS_NUM;

2947: -- FP bug 4166635: reset the cache for default freight code
2948: l_cache_trip_sm := FND_API.G_MISS_CHAR;
2949: l_cache_trip_org_id := FND_API.G_MISS_NUM;
2950: l_cache_trip_fc := NULL;
2951: l_cache_del_id := FND_API.G_MISS_NUM;
2952: l_cache_del_fc := NULL;
2953:
2954:
2955: WHILE l_index is not null LOOP -- {

Line 3324: -- FND_API.G_RET_STS_SUCCESS - on success

3320: p_session_id => l_session_id, -- A Unique Session ID
3321: x_ship_method => l_mtl_txn_if_rec.ship_method_code(l_index), -- Ship Method to Use
3322: x_intransit_time => l_intransit_time, -- The calculated in-transit Lead time
3323: x_return_status => l_return_status -- A return status variable
3324: -- FND_API.G_RET_STS_SUCCESS - on success
3325: -- FND_API.G_RET_STS_ERROR - on expected error
3326: -- FND_API.G_RET_STS_UNEXP_ERROR - on unexpected error
3327: );
3328:

Line 3325: -- FND_API.G_RET_STS_ERROR - on expected error

3321: x_ship_method => l_mtl_txn_if_rec.ship_method_code(l_index), -- Ship Method to Use
3322: x_intransit_time => l_intransit_time, -- The calculated in-transit Lead time
3323: x_return_status => l_return_status -- A return status variable
3324: -- FND_API.G_RET_STS_SUCCESS - on success
3325: -- FND_API.G_RET_STS_ERROR - on expected error
3326: -- FND_API.G_RET_STS_UNEXP_ERROR - on unexpected error
3327: );
3328:
3329: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

Line 3326: -- FND_API.G_RET_STS_UNEXP_ERROR - on unexpected error

3322: x_intransit_time => l_intransit_time, -- The calculated in-transit Lead time
3323: x_return_status => l_return_status -- A return status variable
3324: -- FND_API.G_RET_STS_SUCCESS - on success
3325: -- FND_API.G_RET_STS_ERROR - on expected error
3326: -- FND_API.G_RET_STS_UNEXP_ERROR - on unexpected error
3327: );
3328:
3329: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3330: --Handle Return Status

Line 3903: raise fnd_api.g_exc_error;

3899: --For OPM Lines
3900: -- HW OPMCONV. Removed OPM sepecific code
3901:
3902: IF (l_insert_inv_not_success >= l_insert_inv_calls) THEN
3903: raise fnd_api.g_exc_error;
3904: ELSIF (l_insert_inv_not_success > 0 and l_insert_inv_not_success < l_insert_inv_calls) THEN
3905: RAISE wsh_util_core.g_exc_warning;
3906: END IF;
3907:

Line 3911: raise fnd_api.g_exc_error;

3907:
3908:
3909:
3910: IF (l_error_count >= l_mtl_txn_if_rec.picking_line_id.count) THEN
3911: raise fnd_api.g_exc_error;
3912: ELSIF ((l_error_count > 0 and l_error_count 3913: OR l_warning_count > 0) THEN
3914: RAISE wsh_util_core.g_exc_warning;
3915: END IF;

Line 3931: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

3927: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3928:
3929: IF l_debug_on THEN
3930: wsh_debug_sv.logmsg(l_module_name, 'wsh_util_core.g_exc_warning exception has occured.', wsh_debug_sv.c_excep_level);
3931: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
3932: END IF;
3933:
3934: WHEN fnd_api.g_exc_error THEN
3935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3934: WHEN fnd_api.g_exc_error THEN

3930: wsh_debug_sv.logmsg(l_module_name, 'wsh_util_core.g_exc_warning exception has occured.', wsh_debug_sv.c_excep_level);
3931: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
3932: END IF;
3933:
3934: WHEN fnd_api.g_exc_error THEN
3935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3936:
3937: IF l_debug_on THEN
3938: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

Line 3938: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

3934: WHEN fnd_api.g_exc_error THEN
3935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3936:
3937: IF l_debug_on THEN
3938: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
3939: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
3940: END IF;
3941:
3942:

Line 3939: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

3935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3936:
3937: IF l_debug_on THEN
3938: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
3939: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
3940: END IF;
3941:
3942:
3943: WHEN others THEN

Line 5580: raise FND_API.G_EXC_ERROR;

5576: WSH_DEBUG_SV.log(l_module_name,'x_interface_status',
5577: l_setsmc_output_rec.x_interface_status);
5578: END IF;
5579: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5580: raise FND_API.G_EXC_ERROR;
5581: END IF;
5582:
5583: IF l_setsmc_output_rec.x_interface_status = 'Y' THEN --{
5584:

Line 5609: raise FND_API.G_EXC_ERROR;

5605: p_action => 'PUT',
5606: x_return_status => l_return_status) ;
5607:
5608: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5609: raise FND_API.G_EXC_ERROR;
5610: END IF;
5611:
5612: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN --}{
5613: raise FND_API.G_EXC_ERROR;

Line 5613: raise FND_API.G_EXC_ERROR;

5609: raise FND_API.G_EXC_ERROR;
5610: END IF;
5611:
5612: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN --}{
5613: raise FND_API.G_EXC_ERROR;
5614: END IF; --}
5615: END IF;
5616: -- Processing Model Line
5617:

Line 5654: raise FND_API.G_EXC_ERROR;

5650: l_setsmc_output_rec.x_interface_status);
5651: END IF;
5652:
5653: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5654: raise FND_API.G_EXC_ERROR;
5655: END IF;
5656: IF l_setsmc_output_rec.x_interface_status = 'Y' THEN --{
5657: OPEN ship_set_line_csr(p_batch_id,p_setsmc_input_rec.ship_set_id, p_source_header_id);
5658: FETCH ship_set_line_csr INTO l_temp;

Line 5680: raise FND_API.G_EXC_ERROR;

5676: p_action => 'PUT',
5677: x_return_status => l_return_status) ;
5678:
5679: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5680: raise FND_API.G_EXC_ERROR;
5681: END IF;
5682: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5683: raise FND_API.G_EXC_ERROR;
5684: END IF;

Line 5683: raise FND_API.G_EXC_ERROR;

5679: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5680: raise FND_API.G_EXC_ERROR;
5681: END IF;
5682: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5683: raise FND_API.G_EXC_ERROR;
5684: END IF;
5685: END IF;
5686: -- Processing Ship Set Line
5687:

Line 5727: raise FND_API.G_EXC_ERROR;

5723: p_action => 'PUT',
5724: x_return_status => l_return_status) ;
5725:
5726: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5727: raise FND_API.G_EXC_ERROR;
5728: END IF;
5729: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5730: raise FND_API.G_EXC_ERROR;
5731: END IF;

Line 5730: raise FND_API.G_EXC_ERROR;

5726: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5727: raise FND_API.G_EXC_ERROR;
5728: END IF;
5729: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5730: raise FND_API.G_EXC_ERROR;
5731: END IF;
5732: END IF;
5733: --Standard item
5734:

Line 6919: l_process_flag VARCHAR2(1) :=FND_API.G_FALSE;

6915: --After Merge
6916:
6917: -- HW OPMCONV. Removed local variables
6918: --bug 7131800
6919: l_process_flag VARCHAR2(1) :=FND_API.G_FALSE;
6920: l_tot_shp_qty number;
6921: l_tot_shp_qty2 number; -- OPM KYH 12/SEP/00
6922: x_msg_data varchar2(2000);
6923: x_msg_count number;

Line 7405: l_process_flag := FND_API.G_FALSE;

7401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_GMI_RSV_BRANCH.PROCESS_BRANCH',WSH_DEBUG_SV.C_PROC_LEVEL);
7402: END IF;
7403: -- bug 7131800
7404: IF NOT INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => oe_interface_rec.organization_id) THEN
7405: l_process_flag := FND_API.G_FALSE;
7406: ELSE
7407: l_process_flag := FND_API.G_TRUE;
7408: END IF;
7409: --

Line 7407: l_process_flag := FND_API.G_TRUE;

7403: -- bug 7131800
7404: IF NOT INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => oe_interface_rec.organization_id) THEN
7405: l_process_flag := FND_API.G_FALSE;
7406: ELSE
7407: l_process_flag := FND_API.G_TRUE;
7408: END IF;
7409: --
7410: -- HW OPMCONV. Removed checking for OPM orgs
7411:

Line 7757: IF (l_process_flag = FND_API.G_FALSE ) THEN

7753: --Bug 7131800 : Default Return from the Cancel_Unpicked_Details_At_ITS function is Yes (Y) --Old Behaviour
7754: --
7755: l_cancel_unpicked_details := NULL;
7756: --
7757: IF (l_process_flag = FND_API.G_FALSE ) THEN
7758: IF l_debug_on THEN
7759: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CUSTOM_PUB.Cancel_Unpicked_Details_At_ITS',
7760: WSH_DEBUG_SV.C_PROC_LEVEL);
7761: END IF;

Line 7774: RAISE FND_API.G_EXC_ERROR;

7770: IF ( l_cancel_unpicked_details NOT IN ('Y', 'N') ) THEN
7771: IF l_debug_on THEN
7772: WSH_DEBUG_SV.logmsg(l_module_name, ' Error in Routine wsh_custom_pub.Cancel_Unpicked_Details_At_ITS ');
7773: END IF;
7774: RAISE FND_API.G_EXC_ERROR;
7775: END IF;
7776: ELSE -- If it is an OPM Org, which is the current/default behaviour
7777: l_cancel_unpicked_details := 'Y';
7778: END IF;

Line 8022: WHEN fnd_api.g_exc_error THEN

8018: END IF; -- }
8019:
8020:
8021: EXCEPTION
8022: WHEN fnd_api.g_exc_error THEN
8023: IF l_debug_on THEN
8024: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_error at source_line_id',
8025: oe_interface_rec.source_line_id);
8026: END IF;

Line 8024: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_error at source_line_id',

8020:
8021: EXCEPTION
8022: WHEN fnd_api.g_exc_error THEN
8023: IF l_debug_on THEN
8024: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_error at source_line_id',
8025: oe_interface_rec.source_line_id);
8026: END IF;
8027:
8028: WHEN fnd_api.g_exc_unexpected_error THEN

Line 8028: WHEN fnd_api.g_exc_unexpected_error THEN

8024: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_error at source_line_id',
8025: oe_interface_rec.source_line_id);
8026: END IF;
8027:
8028: WHEN fnd_api.g_exc_unexpected_error THEN
8029: IF l_debug_on THEN
8030: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_unexpected_error at source_line_id', oe_interface_rec.source_line_id);
8031: END IF;
8032:

Line 8030: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_unexpected_error at source_line_id', oe_interface_rec.source_line_id);

8026: END IF;
8027:
8028: WHEN fnd_api.g_exc_unexpected_error THEN
8029: IF l_debug_on THEN
8030: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_unexpected_error at source_line_id', oe_interface_rec.source_line_id);
8031: END IF;
8032:
8033:
8034: WHEN line_locked THEN

Line 8045: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8041: WHEN others THEN
8042: IF l_debug_on THEN
8043: WSH_DEBUG_SV.log(l_module_name, 'Errmsg: ',sqlerrm);
8044: END IF;
8045: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8046: END; --}
8047:
8048:
8049: -- Cache the Source header Number

Line 8090: raise fnd_api.g_exc_error;

8086:
8087: END IF;
8088:
8089: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
8090: raise fnd_api.g_exc_error;
8091: END IF;
8092:
8093:
8094: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

Line 8120: raise fnd_api.g_exc_error;

8116: IF l_debug_on THEN
8117: WSH_DEBUG_SV.log(l_module_name, 'Process_Stop_To_OM l_return_status',l_return_status);
8118: END IF;
8119: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
8120: raise fnd_api.g_exc_error;
8121: END IF;
8122:
8123: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
8124: x_num_warnings =>l_num_om_warnings,

Line 8140: raise fnd_api.g_exc_error;

8136: WSH_DEBUG_SV.log(l_module_name, 'l_num_warnings',l_num_warnings);
8137: END IF;
8138:
8139: IF ( (l_num_errors >= l_non_bulk_count and l_non_bulk_count > 0 ) OR (l_num_om_errors >= l_num_om_api_call and l_num_om_api_call > 0) ) THEN
8140: raise fnd_api.g_exc_error;
8141: ELSIF ( (l_num_errors > 0 ) OR (l_num_om_errors > 0 and l_num_om_api_call > 0) ) THEN
8142: raise wsh_util_core.g_exc_warning;
8143: ELSIF ( (l_num_warnings > 0 ) OR (l_num_om_warnings > 0 and l_num_om_api_call > 0) ) THEN
8144: raise wsh_util_core.g_exc_warning;

Line 8157: WHEN fnd_api.g_exc_error THEN

8153: END IF;
8154:
8155: EXCEPTION
8156:
8157: WHEN fnd_api.g_exc_error THEN
8158: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8159: WSH_UTIL_CORE.Get_Messages('N',l_summary, l_details, l_get_msg_count);
8160: IF c_oe_interface%ISOPEN THEN
8161: close c_oe_interface;

Line 8183: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

8179: close c_picked_dd;
8180: END IF;
8181:
8182: IF l_debug_on THEN
8183: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8184: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
8185: END IF;
8186: --
8187:

Line 8184: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');

8180: END IF;
8181:
8182: IF l_debug_on THEN
8183: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8184: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
8185: END IF;
8186: --
8187:
8188: WHEN wsh_util_core.g_exc_warning THEN

Line 8218: WHEN fnd_api.g_exc_unexpected_error THEN

8214: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.g_exc_warning exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8215: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.g_exc_warning');
8216: END IF;
8217:
8218: WHEN fnd_api.g_exc_unexpected_error THEN
8219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8220: WSH_UTIL_CORE.Get_Messages('N',l_summary, l_details, l_get_msg_count);
8221: IF c_oe_interface%ISOPEN THEN
8222: close c_oe_interface;

Line 8244: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_unexpected exception has occured: '||SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

8240: close c_picked_dd;
8241: END IF;
8242:
8243: IF l_debug_on THEN
8244: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_unexpected exception has occured: '||SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
8245: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.g_exc_warning');
8246: END IF;
8247:
8248: