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 1742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1738: IF l_debug_on THEN
1739: WSH_DEBUG_SV.log(l_module_name,'Error negative p_stops_per_batch',
1740: p_stops_per_batch );
1741: END IF;
1742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1743: ELSE
1744: l_stops_per_batch := p_stops_per_batch;
1745: END IF;
1746:

Line 2838: raise fnd_api.g_exc_error;

2834: WSH_DEBUG_SV.log(l_module_name,'WSH_TRX_HANDLER.INSERT_ROW_BULK l_return_status',l_return_status);
2835: END IF;
2836:
2837: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) then
2838: raise fnd_api.g_exc_error;
2839: END IF;
2840: END IF;
2841:
2842:

Line 2854: raise fnd_api.g_exc_error;

2850: WSH_DEBUG_SV.log(l_module_name,'WSH_TRXSN_HANDLER.INSERT_ROW_BULK l_return_status',l_return_status);
2851: END IF;
2852:
2853: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) then
2854: raise fnd_api.g_exc_error;
2855: END IF;
2856:
2857: p_mtl_ser_txn_if_rec.source_code.delete;
2858: p_mtl_ser_txn_if_rec.source_line_id.delete;

Line 2878: raise fnd_api.g_exc_error;

2874: WSH_DEBUG_SV.log(l_module_name,'WSH_TRXLOT_HANDLER.INSERT_ROW_BULK l_return_status',l_return_status);
2875: END IF;
2876:
2877: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) then
2878: raise fnd_api.g_exc_error;
2879: END IF;
2880:
2881: p_mtl_lot_txn_if_rec.source_code.delete;
2882: p_mtl_lot_txn_if_rec.source_line_id.delete;

Line 2902: WHEN FND_API.G_EXC_ERROR THEN

2898: WSH_DEBUG_SV.pop(l_module_name);
2899: END IF;
2900:
2901: EXCEPTION
2902: WHEN FND_API.G_EXC_ERROR THEN
2903: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2904:
2905: IF l_debug_on THEN
2906: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

2902: WHEN FND_API.G_EXC_ERROR THEN
2903: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2904:
2905: IF l_debug_on THEN
2906: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2907: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2908: END IF;
2909:
2910: ROLLBACK TO SAVEPOINT sp_insert_inv_records;

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

2903: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2904:
2905: IF l_debug_on THEN
2906: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2907: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2908: END IF;
2909:
2910: ROLLBACK TO SAVEPOINT sp_insert_inv_records;
2911:

Line 3557: l_cache_trip_sm := FND_API.G_MISS_CHAR;

3553:
3554: l_start_index := l_index;
3555:
3556: -- FP bug 4166635: reset the cache for default freight code
3557: l_cache_trip_sm := FND_API.G_MISS_CHAR;
3558: l_cache_trip_org_id := FND_API.G_MISS_NUM;
3559: l_cache_trip_fc := NULL;
3560: l_cache_del_id := FND_API.G_MISS_NUM;
3561: l_cache_del_fc := NULL;

Line 3558: l_cache_trip_org_id := FND_API.G_MISS_NUM;

3554: l_start_index := l_index;
3555:
3556: -- FP bug 4166635: reset the cache for default freight code
3557: l_cache_trip_sm := FND_API.G_MISS_CHAR;
3558: l_cache_trip_org_id := FND_API.G_MISS_NUM;
3559: l_cache_trip_fc := NULL;
3560: l_cache_del_id := FND_API.G_MISS_NUM;
3561: l_cache_del_fc := NULL;
3562:

Line 3560: l_cache_del_id := FND_API.G_MISS_NUM;

3556: -- FP bug 4166635: reset the cache for default freight code
3557: l_cache_trip_sm := FND_API.G_MISS_CHAR;
3558: l_cache_trip_org_id := FND_API.G_MISS_NUM;
3559: l_cache_trip_fc := NULL;
3560: l_cache_del_id := FND_API.G_MISS_NUM;
3561: l_cache_del_fc := NULL;
3562:
3563:
3564: WHILE l_index is not null LOOP -- {

Line 3943: -- FND_API.G_RET_STS_SUCCESS - on success

3939: p_session_id => l_session_id, -- A Unique Session ID
3940: x_ship_method => l_mtl_txn_if_rec.ship_method_code(l_index), -- Ship Method to Use
3941: x_intransit_time => l_intransit_time, -- The calculated in-transit Lead time
3942: x_return_status => l_return_status -- A return status variable
3943: -- FND_API.G_RET_STS_SUCCESS - on success
3944: -- FND_API.G_RET_STS_ERROR - on expected error
3945: -- FND_API.G_RET_STS_UNEXP_ERROR - on unexpected error
3946: );
3947:

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

3940: x_ship_method => l_mtl_txn_if_rec.ship_method_code(l_index), -- Ship Method to Use
3941: x_intransit_time => l_intransit_time, -- The calculated in-transit Lead time
3942: x_return_status => l_return_status -- A return status variable
3943: -- FND_API.G_RET_STS_SUCCESS - on success
3944: -- FND_API.G_RET_STS_ERROR - on expected error
3945: -- FND_API.G_RET_STS_UNEXP_ERROR - on unexpected error
3946: );
3947:
3948: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

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

3941: x_intransit_time => l_intransit_time, -- The calculated in-transit Lead time
3942: x_return_status => l_return_status -- A return status variable
3943: -- FND_API.G_RET_STS_SUCCESS - on success
3944: -- FND_API.G_RET_STS_ERROR - on expected error
3945: -- FND_API.G_RET_STS_UNEXP_ERROR - on unexpected error
3946: );
3947:
3948: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3949: --Handle Return Status

Line 4815: raise fnd_api.g_exc_error;

4811: --For OPM Lines
4812: -- HW OPMCONV. Removed OPM sepecific code
4813:
4814: IF (l_insert_inv_not_success >= l_insert_inv_calls) THEN
4815: raise fnd_api.g_exc_error;
4816: ELSIF (l_insert_inv_not_success > 0 and l_insert_inv_not_success < l_insert_inv_calls) THEN
4817: RAISE wsh_util_core.g_exc_warning;
4818: END IF;
4819:

Line 4823: raise fnd_api.g_exc_error;

4819:
4820:
4821:
4822: IF (l_error_count >= l_mtl_txn_if_rec.picking_line_id.count) THEN
4823: raise fnd_api.g_exc_error;
4824: ELSIF ((l_error_count > 0 and l_error_count 4825: OR l_warning_count > 0) THEN
4826: RAISE wsh_util_core.g_exc_warning;
4827: END IF;

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

4839: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4840:
4841: IF l_debug_on THEN
4842: wsh_debug_sv.logmsg(l_module_name, 'wsh_util_core.g_exc_warning exception has occured.', wsh_debug_sv.c_excep_level);
4843: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
4844: END IF;
4845:
4846: WHEN fnd_api.g_exc_error THEN
4847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4846: WHEN fnd_api.g_exc_error THEN

4842: wsh_debug_sv.logmsg(l_module_name, 'wsh_util_core.g_exc_warning exception has occured.', wsh_debug_sv.c_excep_level);
4843: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
4844: END IF;
4845:
4846: WHEN fnd_api.g_exc_error THEN
4847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4848:
4849: IF l_debug_on THEN
4850: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

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

4846: WHEN fnd_api.g_exc_error THEN
4847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4848:
4849: IF l_debug_on THEN
4850: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
4851: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
4852: END IF;
4853:
4854:

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

4847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4848:
4849: IF l_debug_on THEN
4850: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
4851: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
4852: END IF;
4853:
4854:
4855: WHEN others THEN

Line 5842: l_uom2_order_fulfilled VARCHAR2(1) :=FND_API.G_FALSE;

5838: ( wdd.released_status = 'C' AND wdd.oe_interfaced_flag <> 'Y' ) OR
5839: ( wnd.status_code IN ('SR','SC')));
5840:
5841: --9437761
5842: l_uom2_order_fulfilled VARCHAR2(1) :=FND_API.G_FALSE;
5843: -- muom
5844: l_fulfill_base varchar2(1);
5845: l_tot_dd_req_qty2 number;
5846: l_tot_dd_shp_qty2 number;

Line 5864: l_process_flag := FND_API.G_FALSE;

5860: WSH_DEBUG_SV.push(l_module_name);
5861: END IF;
5862:
5863: IF NOT INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => p_oe_interface_rec.organization_id) THEN
5864: l_process_flag := FND_API.G_FALSE;
5865: ELSE
5866: l_process_flag := FND_API.G_TRUE;
5867: END IF;
5868:

Line 5866: l_process_flag := FND_API.G_TRUE;

5862:
5863: IF NOT INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => p_oe_interface_rec.organization_id) THEN
5864: l_process_flag := FND_API.G_FALSE;
5865: ELSE
5866: l_process_flag := FND_API.G_TRUE;
5867: END IF;
5868:
5869: -- muom
5870: l_fulfill_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base('OE', p_oe_interface_rec.source_line_id);

Line 5883: l_uom2_order_fulfilled := FND_API.G_TRUE ;

5879: p_oe_interface_rec.order_quantity_uom = p_oe_interface_rec.ordered_quantity_uom2 AND
5880: p_oe_interface_rec.total_shipped_quantity2 >= p_oe_interface_rec.ordered_quantity2 AND
5881: -- muom
5882: l_fulfill_base = 'P' THEN
5883: l_uom2_order_fulfilled := FND_API.G_TRUE ;
5884: END IF ;
5885:
5886:
5887: IF ((nvl(p_oe_interface_rec.ship_tolerance_above,0) > 0) OR -- {

Line 5889: OR (l_uom2_order_fulfilled = FND_API.G_TRUE ) THEN

5885:
5886:
5887: IF ((nvl(p_oe_interface_rec.ship_tolerance_above,0) > 0) OR -- {
5888: (nvl(p_oe_interface_rec.ship_tolerance_below,0) > 0))
5889: OR (l_uom2_order_fulfilled = FND_API.G_TRUE ) THEN
5890:
5891: -- IF ((NVL(p_oe_interface_rec.ship_tolerance_above,0) > 0) OR (NVL(p_oe_interface_rec.ship_tolerance_below,0) > 0))THEN
5892:
5893: IF (p_oe_interface_rec.source_line_set_id IS NOT NULL) THEN

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

6069: --Bug 7131800 : Default Return from the Cancel_Unpicked_Details_At_ITS function is Yes (Y) --Old Behaviour
6070: --
6071: l_cancel_unpicked_details := NULL;
6072: --
6073: IF (l_process_flag = FND_API.G_FALSE ) THEN
6074: --{
6075: IF l_debug_on THEN
6076: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CUSTOM_PUB.Cancel_Unpicked_Details_At_ITS', WSH_DEBUG_SV.C_PROC_LEVEL);
6077: END IF;

Line 6089: RAISE FND_API.G_EXC_ERROR;

6085: IF ( l_cancel_unpicked_details NOT IN ('Y','N') ) THEN
6086: IF l_debug_on THEN
6087: WSH_DEBUG_SV.logmsg(l_module_name, ' Error in Routine wsh_custom_pub.Cancel_Unpicked_Details_At_ITS ');
6088: END IF;
6089: RAISE FND_API.G_EXC_ERROR;
6090: END IF;
6091: --}
6092: ELSE -- If it is an OPM Org, which is the current/default behaviour
6093: l_cancel_unpicked_details := 'Y';

Line 6189: WHEN fnd_api.g_exc_error THEN

6185: END IF;
6186:
6187: EXCEPTION
6188:
6189: WHEN fnd_api.g_exc_error THEN
6190: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6191: WSH_UTIL_CORE.Get_Messages('N',l_summary, l_details, l_get_msg_count);
6192:
6193: IF c_remain_detail_id%ISOPEN THEN

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

6203: END IF;
6204:
6205: IF l_debug_on THEN
6206: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN Handle_Tolerances ' );
6207: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
6208: END IF;
6209:
6210:
6211: WHEN others THEN

Line 7105: raise FND_API.G_EXC_ERROR;

7101: WSH_DEBUG_SV.log(l_module_name,'x_interface_status',
7102: l_setsmc_output_rec.x_interface_status);
7103: END IF;
7104: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
7105: raise FND_API.G_EXC_ERROR;
7106: END IF;
7107:
7108: IF l_setsmc_output_rec.x_interface_status = 'Y' THEN --{
7109:

Line 7134: raise FND_API.G_EXC_ERROR;

7130: p_action => 'PUT',
7131: x_return_status => l_return_status) ;
7132:
7133: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
7134: raise FND_API.G_EXC_ERROR;
7135: END IF;
7136:
7137: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN --}{
7138: raise FND_API.G_EXC_ERROR;

Line 7138: raise FND_API.G_EXC_ERROR;

7134: raise FND_API.G_EXC_ERROR;
7135: END IF;
7136:
7137: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN --}{
7138: raise FND_API.G_EXC_ERROR;
7139: END IF; --}
7140: END IF;
7141: -- Processing Model Line
7142:

Line 7179: raise FND_API.G_EXC_ERROR;

7175: l_setsmc_output_rec.x_interface_status);
7176: END IF;
7177:
7178: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
7179: raise FND_API.G_EXC_ERROR;
7180: END IF;
7181: IF l_setsmc_output_rec.x_interface_status = 'Y' THEN --{
7182: OPEN ship_set_line_csr(p_batch_id,p_setsmc_input_rec.ship_set_id, p_source_header_id);
7183: FETCH ship_set_line_csr INTO l_temp;

Line 7205: raise FND_API.G_EXC_ERROR;

7201: p_action => 'PUT',
7202: x_return_status => l_return_status) ;
7203:
7204: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
7205: raise FND_API.G_EXC_ERROR;
7206: END IF;
7207: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
7208: raise FND_API.G_EXC_ERROR;
7209: END IF;

Line 7208: raise FND_API.G_EXC_ERROR;

7204: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
7205: raise FND_API.G_EXC_ERROR;
7206: END IF;
7207: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
7208: raise FND_API.G_EXC_ERROR;
7209: END IF;
7210: END IF;
7211: -- Processing Ship Set Line
7212:

Line 7252: raise FND_API.G_EXC_ERROR;

7248: p_action => 'PUT',
7249: x_return_status => l_return_status) ;
7250:
7251: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
7252: raise FND_API.G_EXC_ERROR;
7253: END IF;
7254: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
7255: raise FND_API.G_EXC_ERROR;
7256: END IF;

Line 7255: raise FND_API.G_EXC_ERROR;

7251: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
7252: raise FND_API.G_EXC_ERROR;
7253: END IF;
7254: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
7255: raise FND_API.G_EXC_ERROR;
7256: END IF;
7257: END IF;
7258: --Standard item
7259:

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

8466: --After Merge
8467:
8468: -- HW OPMCONV. Removed local variables
8469: --bug 7131800
8470: l_process_flag VARCHAR2(1) :=FND_API.G_FALSE;
8471: l_tot_shp_qty number;
8472: l_tot_shp_qty2 number; -- OPM KYH 12/SEP/00
8473: -- muom
8474: l_tot_om_shp_qty number;

Line 8988: l_process_flag := FND_API.G_FALSE;

8984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_GMI_RSV_BRANCH.PROCESS_BRANCH',WSH_DEBUG_SV.C_PROC_LEVEL);
8985: END IF;
8986: -- bug 7131800
8987: IF NOT INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => oe_interface_rec.organization_id) THEN
8988: l_process_flag := FND_API.G_FALSE;
8989: ELSE
8990: l_process_flag := FND_API.G_TRUE;
8991: END IF;
8992: --

Line 8990: l_process_flag := FND_API.G_TRUE;

8986: -- bug 7131800
8987: IF NOT INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => oe_interface_rec.organization_id) THEN
8988: l_process_flag := FND_API.G_FALSE;
8989: ELSE
8990: l_process_flag := FND_API.G_TRUE;
8991: END IF;
8992: --
8993: -- HW OPMCONV. Removed checking for OPM orgs
8994:

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

9216: --Bug 8975388: initialize the value of variable l_cancel_unpicked_details.
9217: --
9218: l_cancel_unpicked_details := NULL;
9219: --
9220: IF (l_process_flag = FND_API.G_FALSE ) THEN
9221: --{
9222: IF l_debug_on THEN
9223: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CUSTOM_PUB.Cancel_Unpicked_Details_At_ITS', WSH_DEBUG_SV.C_PROC_LEVEL);
9224: END IF;

Line 9236: RAISE FND_API.G_EXC_ERROR;

9232: IF ( l_cancel_unpicked_details NOT IN ('Y','N') ) THEN
9233: IF l_debug_on THEN
9234: WSH_DEBUG_SV.logmsg(l_module_name, ' Error in Routine wsh_custom_pub.Cancel_Unpicked_Details_At_ITS ');
9235: END IF;
9236: RAISE FND_API.G_EXC_ERROR;
9237: END IF;
9238: --}
9239: ELSE -- If it is an OPM Org, which is the current/default behaviour
9240: l_cancel_unpicked_details := 'Y';

Line 9400: WHEN fnd_api.g_exc_error THEN

9396: END IF; -- }
9397:
9398:
9399: EXCEPTION
9400: WHEN fnd_api.g_exc_error THEN
9401: IF l_debug_on THEN
9402: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_error at source_line_id',
9403: oe_interface_rec.source_line_id);
9404: END IF;

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

9398:
9399: EXCEPTION
9400: WHEN fnd_api.g_exc_error THEN
9401: IF l_debug_on THEN
9402: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_error at source_line_id',
9403: oe_interface_rec.source_line_id);
9404: END IF;
9405:
9406: WHEN fnd_api.g_exc_unexpected_error THEN

Line 9406: WHEN fnd_api.g_exc_unexpected_error THEN

9402: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_error at source_line_id',
9403: oe_interface_rec.source_line_id);
9404: END IF;
9405:
9406: WHEN fnd_api.g_exc_unexpected_error THEN
9407: IF l_debug_on THEN
9408: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_unexpected_error at source_line_id', oe_interface_rec.source_line_id);
9409: END IF;
9410:

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

9404: END IF;
9405:
9406: WHEN fnd_api.g_exc_unexpected_error THEN
9407: IF l_debug_on THEN
9408: WSH_DEBUG_SV.log(l_module_name, 'fnd_api.g_exc_unexpected_error at source_line_id', oe_interface_rec.source_line_id);
9409: END IF;
9410:
9411:
9412: WHEN line_locked THEN

Line 9423: raise FND_API.G_EXC_UNEXPECTED_ERROR;

9419: WHEN others THEN
9420: IF l_debug_on THEN
9421: WSH_DEBUG_SV.log(l_module_name, 'Errmsg: ',sqlerrm);
9422: END IF;
9423: raise FND_API.G_EXC_UNEXPECTED_ERROR;
9424: END; --}
9425:
9426:
9427: -- Cache the Source header Number

Line 9468: raise fnd_api.g_exc_error;

9464:
9465: END IF;
9466:
9467: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
9468: raise fnd_api.g_exc_error;
9469: END IF;
9470:
9471:
9472: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

Line 9498: raise fnd_api.g_exc_error;

9494: IF l_debug_on THEN
9495: WSH_DEBUG_SV.log(l_module_name, 'Process_Stop_To_OM l_return_status',l_return_status);
9496: END IF;
9497: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
9498: raise fnd_api.g_exc_error;
9499: END IF;
9500:
9501: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
9502: x_num_warnings =>l_num_om_warnings,

Line 9518: raise fnd_api.g_exc_error;

9514: WSH_DEBUG_SV.log(l_module_name, 'l_num_warnings',l_num_warnings);
9515: END IF;
9516:
9517: 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
9518: raise fnd_api.g_exc_error;
9519: ELSIF ( (l_num_errors > 0 ) OR (l_num_om_errors > 0 and l_num_om_api_call > 0) ) THEN
9520: raise wsh_util_core.g_exc_warning;
9521: ELSIF ( (l_num_warnings > 0 ) OR (l_num_om_warnings > 0 and l_num_om_api_call > 0) ) THEN
9522: raise wsh_util_core.g_exc_warning;

Line 9535: WHEN fnd_api.g_exc_error THEN

9531: END IF;
9532:
9533: EXCEPTION
9534:
9535: WHEN fnd_api.g_exc_error THEN
9536: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9537: WSH_UTIL_CORE.Get_Messages('N',l_summary, l_details, l_get_msg_count);
9538: IF c_oe_interface%ISOPEN THEN
9539: close c_oe_interface;

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

9557: close c_picked_dd;
9558: END IF;
9559:
9560: IF l_debug_on THEN
9561: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
9563: END IF;
9564: --
9565:

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

9558: END IF;
9559:
9560: IF l_debug_on THEN
9561: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
9563: END IF;
9564: --
9565:
9566: WHEN wsh_util_core.g_exc_warning THEN

Line 9596: WHEN fnd_api.g_exc_unexpected_error THEN

9592: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.g_exc_warning exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9593: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.g_exc_warning');
9594: END IF;
9595:
9596: WHEN fnd_api.g_exc_unexpected_error THEN
9597: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
9598: WSH_UTIL_CORE.Get_Messages('N',l_summary, l_details, l_get_msg_count);
9599: IF c_oe_interface%ISOPEN THEN
9600: close c_oe_interface;

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

9618: close c_picked_dd;
9619: END IF;
9620:
9621: IF l_debug_on THEN
9622: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_unexpected exception has occured: '||SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
9623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.g_exc_warning');
9624: END IF;
9625:
9626: