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

Line 268: WHEN FND_API.G_EXC_ERROR THEN

264: END IF;
265:
266:
267: EXCEPTION
268: WHEN FND_API.G_EXC_ERROR THEN
269: ROLLBACK TO Reapprove_PO_PVT;
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
271: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
272:

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

273: --
274: -- Debug Statements
275: --
276: IF l_debug_on THEN
277: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
279: END IF;
280: --
281: WHEN OTHERS THEN

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

274: -- Debug Statements
275: --
276: IF l_debug_on THEN
277: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
279: END IF;
280: --
281: WHEN OTHERS THEN
282: ROLLBACK TO Reapprove_PO_PVT;

Line 508: WHEN FND_API.G_EXC_ERROR THEN

504: END IF;
505:
506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO Update_Attributes_PVT;
510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
511: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
512:

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

513: --
514: -- Debug Statements
515: --
516: IF l_debug_on THEN
517: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
518: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
519: END IF;
520: --
521: WHEN OTHERS THEN

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

514: -- Debug Statements
515: --
516: IF l_debug_on THEN
517: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
518: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
519: END IF;
520: --
521: WHEN OTHERS THEN
522: ROLLBACK TO Update_Attributes_PVT;

Line 1036: RAISE FND_API.G_EXC_ERROR;

1032: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
1033: END IF;
1034: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
1035: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1036: RAISE FND_API.G_EXC_ERROR;
1037: END IF;
1038:
1039: END IF;
1040: ELSE

Line 1069: RAISE FND_API.G_EXC_ERROR;

1065: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
1066: END IF;
1067: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
1068: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1069: RAISE FND_API.G_EXC_ERROR;
1070: END IF;
1071:
1072: --}
1073: END IF;

Line 1373: nvl(l_dd_info.date_requested,FND_API.G_MISS_DATE) <>

1369: nvl(l_dd_info.ship_tolerance_below,-99) <>
1370: nvl(p_line_rec.ship_tolerance_below(p_line_rec_index),-99) OR
1371: nvl(l_dd_info.revision,'!!!') <>
1372: nvl(p_line_rec.revision(p_line_rec_index),'!!!') OR
1373: nvl(l_dd_info.date_requested,FND_API.G_MISS_DATE) <>
1374: nvl(nvl(p_line_rec.request_date(p_line_rec_index),p_line_rec.schedule_ship_date(p_line_rec_index)),FND_API.G_MISS_DATE) OR
1375: nvl(l_dd_info.date_scheduled,FND_API.G_MISS_DATE) <>
1376: nvl(p_line_rec.schedule_ship_date(p_line_rec_index),FND_API.G_MISS_DATE) OR
1377: nvl(l_dd_info.ship_method_code,'!!!') <>

Line 1374: nvl(nvl(p_line_rec.request_date(p_line_rec_index),p_line_rec.schedule_ship_date(p_line_rec_index)),FND_API.G_MISS_DATE) OR

1370: nvl(p_line_rec.ship_tolerance_below(p_line_rec_index),-99) OR
1371: nvl(l_dd_info.revision,'!!!') <>
1372: nvl(p_line_rec.revision(p_line_rec_index),'!!!') OR
1373: nvl(l_dd_info.date_requested,FND_API.G_MISS_DATE) <>
1374: nvl(nvl(p_line_rec.request_date(p_line_rec_index),p_line_rec.schedule_ship_date(p_line_rec_index)),FND_API.G_MISS_DATE) OR
1375: nvl(l_dd_info.date_scheduled,FND_API.G_MISS_DATE) <>
1376: nvl(p_line_rec.schedule_ship_date(p_line_rec_index),FND_API.G_MISS_DATE) OR
1377: nvl(l_dd_info.ship_method_code,'!!!') <>
1378: nvl(p_line_rec.shipping_method_code(p_line_rec_index),'!!!') OR

Line 1375: nvl(l_dd_info.date_scheduled,FND_API.G_MISS_DATE) <>

1371: nvl(l_dd_info.revision,'!!!') <>
1372: nvl(p_line_rec.revision(p_line_rec_index),'!!!') OR
1373: nvl(l_dd_info.date_requested,FND_API.G_MISS_DATE) <>
1374: nvl(nvl(p_line_rec.request_date(p_line_rec_index),p_line_rec.schedule_ship_date(p_line_rec_index)),FND_API.G_MISS_DATE) OR
1375: nvl(l_dd_info.date_scheduled,FND_API.G_MISS_DATE) <>
1376: nvl(p_line_rec.schedule_ship_date(p_line_rec_index),FND_API.G_MISS_DATE) OR
1377: nvl(l_dd_info.ship_method_code,'!!!') <>
1378: nvl(p_line_rec.shipping_method_code(p_line_rec_index),'!!!') OR
1379: nvl(l_dd_info.carrier_id,-99) <>

Line 1376: nvl(p_line_rec.schedule_ship_date(p_line_rec_index),FND_API.G_MISS_DATE) OR

1372: nvl(p_line_rec.revision(p_line_rec_index),'!!!') OR
1373: nvl(l_dd_info.date_requested,FND_API.G_MISS_DATE) <>
1374: nvl(nvl(p_line_rec.request_date(p_line_rec_index),p_line_rec.schedule_ship_date(p_line_rec_index)),FND_API.G_MISS_DATE) OR
1375: nvl(l_dd_info.date_scheduled,FND_API.G_MISS_DATE) <>
1376: nvl(p_line_rec.schedule_ship_date(p_line_rec_index),FND_API.G_MISS_DATE) OR
1377: nvl(l_dd_info.ship_method_code,'!!!') <>
1378: nvl(p_line_rec.shipping_method_code(p_line_rec_index),'!!!') OR
1379: nvl(l_dd_info.carrier_id,-99) <>
1380: nvl(p_line_rec.carrier_id(p_line_rec_index),-99) OR

Line 1667: WHEN FND_API.G_EXC_ERROR THEN

1663: IF l_debug_on THEN
1664: WSH_DEBUG_SV.logmsg(l_module_name,'e_Wdd_locked exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_Wdd_locked');
1666: END IF;
1667: WHEN FND_API.G_EXC_ERROR THEN
1668: ROLLBACK TO Update_dd_Attributes_PVT;
1669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1670: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1671:

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

1672: --
1673: -- Debug Statements
1674: --
1675: IF l_debug_on THEN
1676: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1677: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1678: END IF;
1679: --
1680: WHEN OTHERS THEN

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

1673: -- Debug Statements
1674: --
1675: IF l_debug_on THEN
1676: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1677: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1678: END IF;
1679: --
1680: WHEN OTHERS THEN
1681: ROLLBACK TO Update_dd_Attributes_PVT;

Line 2364: RAISE FND_API.G_EXC_ERROR;

2360:
2361: IF SQL%ROWCOUNT <> 1 THEN
2362: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
2363: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2364: RAISE FND_API.G_EXC_ERROR;
2365: END IF;
2366:
2367: --
2368: -- DBI Project

Line 2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2382: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
2383: END IF;
2384: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2385: -- just pass this return status to caller API
2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2387: END IF;
2388: -- End of Code for DBI Project
2389: --
2390:

Line 2674: RAISE FND_API.G_EXC_ERROR;

2670: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
2671: END IF;
2672: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
2673: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2674: RAISE FND_API.G_EXC_ERROR;
2675: END IF;
2676:
2677: --
2678: -- DBI Project

Line 2696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2692: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
2693: END IF;
2694: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2695: -- just pass this return status to caller API
2696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2697: END IF;
2698: -- End of Code for DBI Project
2699: --
2700:

Line 2911: RAISE FND_API.G_EXC_ERROR;

2907: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
2908: END IF;
2909: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
2910: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2911: RAISE FND_API.G_EXC_ERROR;
2912: END IF;
2913: l_update_flag := TRUE;
2914:
2915: --

Line 2934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2930: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
2931: END IF;
2932: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2933: -- just pass this return status to caller API
2934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2935: END IF;
2936: -- End of Code for DBI Project
2937: --
2938:

Line 3178: RAISE FND_API.G_EXC_ERROR;

3174: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
3175: END IF;
3176: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
3177: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3178: RAISE FND_API.G_EXC_ERROR;
3179: END IF;
3180: --
3181: -- DBI Project
3182: -- Update of wsh_delivery_details where requested_quantity/released_status

Line 3199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3195: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3196: END IF;
3197: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3198: -- just pass this return status to caller API
3199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3200: END IF;
3201: -- End of Code for DBI Project
3202: --
3203:

Line 3318: WHEN FND_API.G_EXC_ERROR THEN

3314: IF l_debug_on THEN
3315: WSH_DEBUG_SV.logmsg(l_module_name,'e_Wdd_locked exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3316: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_Wdd_locked');
3317: END IF;
3318: WHEN FND_API.G_EXC_ERROR THEN
3319: ROLLBACK TO Update_quantity_PVT;
3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3321: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3322: --

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

3322: --
3323: -- Debug Statements
3324: --
3325: IF l_debug_on THEN
3326: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3327: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3328: END IF;
3329: --
3330: -- Added for DBI Project to handle Unexpected error

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

3323: -- Debug Statements
3324: --
3325: IF l_debug_on THEN
3326: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3327: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3328: END IF;
3329: --
3330: -- Added for DBI Project to handle Unexpected error
3331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3327: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3328: END IF;
3329: --
3330: -- Added for DBI Project to handle Unexpected error
3331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3332: ROLLBACK TO Update_quantity_PVT;
3333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3334: --
3335: IF l_debug_on THEN

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

3333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3334: --
3335: IF l_debug_on THEN
3336: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3337: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3338: END IF;
3339: --
3340: -- End of Code Added for DBI Project to handle Unexpected error
3341: WHEN OTHERS THEN

Line 3641: WHEN FND_API.G_EXC_ERROR THEN

3637: IF l_debug_on THEN
3638: WSH_DEBUG_SV.logmsg(l_module_name,'e_Wdd_locked exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_Wdd_locked');
3640: END IF;
3641: WHEN FND_API.G_EXC_ERROR THEN
3642: ROLLBACK TO cancel_close_PO_PVT;
3643: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3644: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3645:

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

3646: --
3647: -- Debug Statements
3648: --
3649: IF l_debug_on THEN
3650: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3651: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3652: END IF;
3653: --
3654: WHEN OTHERS THEN

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

3647: -- Debug Statements
3648: --
3649: IF l_debug_on THEN
3650: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3651: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3652: END IF;
3653: --
3654: WHEN OTHERS THEN
3655: ROLLBACK TO cancel_close_PO_PVT;

Line 3846: l_init_msg_list VARCHAR2(100):= FND_API.G_FALSE;

3842: l_return_status VARCHAR2(30);
3843: l_exception_msg_count NUMBER;
3844: l_dummy_exception_id NUMBER;
3845: l_exception_msg_data VARCHAR2(2000);
3846: l_init_msg_list VARCHAR2(100):= FND_API.G_FALSE;
3847: l_exceptions_tab WSH_EXCEPTIONS_PUB.XC_TAB_TYPE;
3848: l_msg VARCHAR2(2000):= NULL;
3849: l_exception_error_message VARCHAR2(2000) := NULL;
3850: l_logged_at_location_id NUMBER := FND_API.G_MISS_NUM;

Line 3850: l_logged_at_location_id NUMBER := FND_API.G_MISS_NUM;

3846: l_init_msg_list VARCHAR2(100):= FND_API.G_FALSE;
3847: l_exceptions_tab WSH_EXCEPTIONS_PUB.XC_TAB_TYPE;
3848: l_msg VARCHAR2(2000):= NULL;
3849: l_exception_error_message VARCHAR2(2000) := NULL;
3850: l_logged_at_location_id NUMBER := FND_API.G_MISS_NUM;
3851: l_exception_location_id NUMBER := FND_API.G_MISS_NUM;
3852: l_num_warnings NUMBER := 0;
3853: l_num_errors NUMBER := 0;
3854:

Line 3851: l_exception_location_id NUMBER := FND_API.G_MISS_NUM;

3847: l_exceptions_tab WSH_EXCEPTIONS_PUB.XC_TAB_TYPE;
3848: l_msg VARCHAR2(2000):= NULL;
3849: l_exception_error_message VARCHAR2(2000) := NULL;
3850: l_logged_at_location_id NUMBER := FND_API.G_MISS_NUM;
3851: l_exception_location_id NUMBER := FND_API.G_MISS_NUM;
3852: l_num_warnings NUMBER := 0;
3853: l_num_errors NUMBER := 0;
3854:
3855: --

Line 4082: WHEN FND_API.G_EXC_ERROR THEN

4078: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4079: END IF;
4080:
4081: EXCEPTION
4082: WHEN FND_API.G_EXC_ERROR THEN
4083: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4084: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4085:
4086: --

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

4086: --
4087: -- Debug Statements
4088: --
4089: IF l_debug_on THEN
4090: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4091: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4092: END IF;
4093: --
4094: WHEN OTHERS THEN

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

4087: -- Debug Statements
4088: --
4089: IF l_debug_on THEN
4090: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4091: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4092: END IF;
4093: --
4094: WHEN OTHERS THEN
4095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 4460: raise fnd_api.g_exc_error;

4456: --If party not exists, throw an error message and return.
4457: IF l_debug_on THEN
4458: WSH_DEBUG_SV.log(l_module_name,'Party does not Exist for the Vendor ');
4459: END IF;
4460: raise fnd_api.g_exc_error;
4461: -- } IB-Phase-2
4462: END IF;
4463:
4464: IF p_line_rec.drop_ship_flag(p_index) = 'Y' AND p_line_rec.shipping_method_code(p_index) is NOT NULL THEN

Line 4566: WHEN FND_API.G_EXC_ERROR THEN

4562: END IF;
4563:
4564:
4565: EXCEPTION
4566: WHEN FND_API.G_EXC_ERROR THEN
4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4568: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4569: --
4570: -- Debug Statements

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

4569: --
4570: -- Debug Statements
4571: --
4572: IF l_debug_on THEN
4573: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4574: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4575: END IF;
4576: --
4577: WHEN OTHERS THEN

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

4570: -- Debug Statements
4571: --
4572: IF l_debug_on THEN
4573: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4574: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4575: END IF;
4576: --
4577: WHEN OTHERS THEN
4578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 4693: WHEN FND_API.G_EXC_ERROR THEN

4689: END IF;--}
4690: END IF;--}
4691:
4692: EXCEPTION
4693: WHEN FND_API.G_EXC_ERROR THEN
4694: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4695: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4696:
4697: --

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

4697: --
4698: -- Debug Statements
4699: --
4700: IF l_debug_on THEN
4701: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4703: END IF;
4704: --
4705: WHEN OTHERS THEN

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

4698: -- Debug Statements
4699: --
4700: IF l_debug_on THEN
4701: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4703: END IF;
4704: --
4705: WHEN OTHERS THEN
4706: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;