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

Line 261: WHEN FND_API.G_EXC_ERROR THEN

257: END IF;
258: --}
259: EXCEPTION
260: --
261: WHEN FND_API.G_EXC_ERROR THEN
262: --
263: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
264: --
265: IF l_debug_on THEN

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

264: --
265: IF l_debug_on THEN
266: --
267: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
268: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
269: --
270: END IF;
271: --
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

268: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
269: --
270: END IF;
271: --
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: --
274: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
275: --
276: IF l_debug_on THEN

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

275: --
276: IF l_debug_on THEN
277: --
278: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
279: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
280: --
281: END IF;
282: --
283: WHEN OTHERS THEN

Line 827: WHEN FND_API.G_EXC_ERROR THEN

823: END IF;
824: --
825: EXCEPTION
826: --
827: WHEN FND_API.G_EXC_ERROR THEN
828: --
829: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
830: --
831: IF l_debug_on THEN

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

829: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
830: --
831: IF l_debug_on THEN
832: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
834: END IF;
835: --
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: --

Line 836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

832: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
834: END IF;
835: --
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: --
838: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
839: --
840: IF l_debug_on THEN

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

838: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
839: --
840: IF l_debug_on THEN
841: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
842: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
843: END IF;
844: --
845: WHEN OTHERS THEN
846: --

Line 1049: WHEN FND_API.G_EXC_ERROR THEN

1045: END IF;
1046:
1047: EXCEPTION
1048: --
1049: WHEN FND_API.G_EXC_ERROR THEN
1050: --
1051: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1052: --
1053: IF l_debug_on THEN

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

1052: --
1053: IF l_debug_on THEN
1054: --
1055: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
1056: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1057: --
1058: END IF;
1059: --
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1056: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1057: --
1058: END IF;
1059: --
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: --
1062: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1063: --
1064: IF l_debug_on THEN

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

1063: --
1064: IF l_debug_on THEN
1065: --
1066: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1067: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1068: --
1069: END IF;
1070: --
1071: WHEN OTHERS THEN

Line 1447: WHEN FND_API.G_EXC_ERROR THEN

1443: END IF;
1444: --
1445: EXCEPTION
1446: --
1447: WHEN FND_API.G_EXC_ERROR THEN
1448: --
1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1450: --
1451: IF l_debug_on THEN

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

1450: --
1451: IF l_debug_on THEN
1452: --
1453: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
1454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1455: --
1456: END IF;
1457: --
1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1455: --
1456: END IF;
1457: --
1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1459: --
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1461: --
1462: IF l_debug_on THEN

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

1461: --
1462: IF l_debug_on THEN
1463: --
1464: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1465: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1466: --
1467: END IF;
1468: --
1469: WHEN OTHERS THEN

Line 2493: p_init_msg_list => FND_API.G_FALSE,

2489: IF l_dlvy_rr_tbl.COUNT > 0 THEN
2490: --{
2491: WSH_DELIVERIES_GRP.delivery_action(
2492: p_api_version_number => 1.0,
2493: p_init_msg_list => FND_API.G_FALSE,
2494: p_commit => FND_API.G_FALSE,
2495: p_action_prms => l_action_prms,
2496: p_rec_attr_tab => l_dlvy_rr_tbl,
2497: x_delivery_out_rec => l_delivery_out_rec,

Line 2494: p_commit => FND_API.G_FALSE,

2490: --{
2491: WSH_DELIVERIES_GRP.delivery_action(
2492: p_api_version_number => 1.0,
2493: p_init_msg_list => FND_API.G_FALSE,
2494: p_commit => FND_API.G_FALSE,
2495: p_action_prms => l_action_prms,
2496: p_rec_attr_tab => l_dlvy_rr_tbl,
2497: x_delivery_out_rec => l_delivery_out_rec,
2498: x_defaults_rec => l_defaults_rec,

Line 2643: WHEN FND_API.G_EXC_ERROR THEN

2639: END IF;
2640:
2641: EXCEPTION
2642: --
2643: WHEN FND_API.G_EXC_ERROR THEN
2644: --
2645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2646: ROLLBACK TO WSH_Vendor_Merge;
2647: --

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

2647: --
2648: IF l_debug_on THEN
2649: --
2650: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
2651: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2652: --
2653: END IF;
2654: --
2655: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

Line 2667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2663: END IF;
2664: --
2665: END IF;
2666: --
2667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2668: --
2669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2670: ROLLBACK TO WSH_Vendor_Merge;
2671: --

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

2671: --
2672: IF l_debug_on THEN
2673: --
2674: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2675: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2676: --
2677: END IF;
2678: --
2679: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

Line 2866: p_encoded => FND_API.G_FALSE

2862: FND_MSG_PUB.Count_And_Get
2863: (
2864: p_count => x_msg_count,
2865: p_data => x_msg_data,
2866: p_encoded => FND_API.G_FALSE
2867: );
2868: --
2869: IF l_debug_on THEN
2870: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

Line 2886: WHEN FND_API.G_EXC_ERROR THEN

2882: RAISE;
2883: --
2884: --}
2885: --
2886: WHEN FND_API.G_EXC_ERROR THEN
2887: --
2888: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2889: --
2890: IF l_debug_on THEN

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

2888: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2889: --
2890: IF l_debug_on THEN
2891: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
2892: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2893: END IF;
2894: --
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: --

Line 2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2891: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
2892: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2893: END IF;
2894: --
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: --
2897: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2898: --
2899: IF l_debug_on THEN

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

2897: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2898: --
2899: IF l_debug_on THEN
2900: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2901: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2902: END IF;
2903: --
2904: WHEN OTHERS THEN
2905: --

Line 3082: x_return_status := FND_API.G_RET_STS_SUCCESS;

3078: l_debug_on BOOLEAN;
3079: --
3080: BEGIN
3081:
3082: x_return_status := FND_API.G_RET_STS_SUCCESS;
3083: --
3084: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3085: --
3086: IF l_debug_on IS NULL THEN

Line 3187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3183: END IF;
3184: --
3185:
3186: WHEN OTHERS THEN
3187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3188: --
3189: IF ( l_debug_on ) THEN
3190: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_VENDOR_PARTY_MERGE_PKG.Adjust_Weight_Volume()+ Others - ' || getTimeStamp);
3191: WSH_DEBUG_SV.logmsg(l_module_name,'Error Mesg : ' || sqlerrm );

Line 3236: x_return_status := FND_API.G_RET_STS_SUCCESS;

3232: l_debug_on BOOLEAN;
3233: --
3234: BEGIN
3235:
3236: x_return_status := FND_API.G_RET_STS_SUCCESS;
3237: --
3238: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3239: --
3240: IF l_debug_on IS NULL

Line 3341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3337: END IF;
3338: --
3339:
3340: WHEN OTHERS THEN
3341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3342: --
3343: IF ( l_debug_on ) THEN
3344: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_VENDOR_PARTY_MERGE_PKG.Adjust_Parent_WV()+ Others - ' || getTimeStamp );
3345: WSH_DEBUG_SV.logmsg(l_module_name,'Error Mesg : ' || sqlerrm );

Line 3616: raise FND_API.G_EXC_ERROR;

3612: IF get_loc_for_site%NOTFOUND THEN
3613: IF l_debug_on THEN
3614: WSH_DEBUG_SV.log(l_module_name, 'From vendor details not found' );
3615: CLOSE get_loc_for_site;
3616: raise FND_API.G_EXC_ERROR;
3617: END IF;
3618: END IF;
3619: --
3620: CLOSE get_loc_for_site;

Line 3774: RAISE FND_API.G_EXC_ERROR;

3770: --
3771: IF ( l_debug_on ) THEN
3772: WSH_DEBUG_SV.logmsg(l_module_name,'Error returned from API Adjust_Weight_Volume');
3773: END IF;
3774: RAISE FND_API.G_EXC_ERROR;
3775: --
3776: END IF;
3777:
3778: FORALL I IN l_wda_rowid.first..l_wda_rowid.last

Line 3814: RAISE FND_API.G_EXC_ERROR;

3810: --
3811: IF ( l_debug_on ) THEN
3812: WSH_DEBUG_SV.logmsg(l_module_name,'Error returned from API Adjust_Parent_WV');
3813: END IF;
3814: RAISE FND_API.G_EXC_ERROR;
3815: --
3816: END IF;
3817:
3818: FOR I IN l_parent_delivery_detail_id.first..l_parent_delivery_detail_id.last LOOP

Line 3870: RAISE FND_API.G_EXC_ERROR;

3866: --
3867: IF ( l_debug_on ) THEN
3868: WSH_DEBUG_SV.log(l_module_name,'Error returned from API WSH_XC_UTIL.Log_Exception');
3869: END IF;
3870: RAISE FND_API.G_EXC_ERROR;
3871: --
3872: END IF;
3873: END IF;
3874: END LOOP;

Line 3968: RAISE FND_API.G_EXC_ERROR;

3964: --
3965: IF ( l_debug_on ) THEN
3966: WSH_DEBUG_SV.logmsg(l_module_name,'Error returned from API Adjust_Weight_Volume');
3967: END IF;
3968: RAISE FND_API.G_EXC_ERROR;
3969: --
3970: END IF;
3971:
3972: IF l_debug_on THEN

Line 4009: RAISE FND_API.G_EXC_ERROR;

4005: --
4006: IF ( l_debug_on ) THEN
4007: WSH_DEBUG_SV.log(l_module_name, 'Error returned from API Adjust_Parent_WV');
4008: END IF;
4009: RAISE FND_API.G_EXC_ERROR;
4010: --
4011: END IF;
4012: IF l_debug_on THEN
4013: WSH_DEBUG_SV.log(l_module_name, 'Clearing the deliveries from temp table');

Line 4076: RAISE FND_API.G_EXC_ERROR;

4072: --
4073: IF ( l_debug_on ) THEN
4074: WSH_DEBUG_SV.log(l_module_name,'Error returned from API WSH_XC_UTIL.Log_Exception');
4075: END IF;
4076: RAISE FND_API.G_EXC_ERROR;
4077: --
4078: END IF;
4079: END IF;
4080: IF l_debug_on THEN

Line 4123: RAISE FND_API.G_EXC_ERROR;

4119: IF ( l_debug_on ) THEN
4120: WSH_DEBUG_SV.log(l_module_name,'Error returned from API WSH_XC_UTIL.Log_Exception');
4121: END IF;
4122: --
4123: RAISE FND_API.G_EXC_ERROR;
4124: END IF;
4125: END LOOP;
4126: EXIT WHEN l_wda_rowid.count < G_LIMIT;
4127: END LOOP;

Line 4409: RAISE FND_API.G_EXC_ERROR;

4405: THEN
4406: --
4407: IF ( l_debug_on ) THEN
4408: WSH_DEBUG_SV.log(l_module_name,'Error returned from API WSH_DELIVERY_AUTOCREATE.Create_Hash');
4409: RAISE FND_API.G_EXC_ERROR;
4410: END IF;
4411: --
4412: END IF;
4413:

Line 4464: WHEN FND_API.G_EXC_ERROR THEN

4460: WSH_DEBUG_SV.pop(l_module_name);
4461:
4462: EXCEPTION
4463: --
4464: WHEN FND_API.G_EXC_ERROR THEN
4465:
4466: IF get_loc_for_site%ISOPEN THEN
4467: CLOSE get_loc_for_site;
4468: END IF;

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

4496: --
4497: IF l_debug_on THEN
4498: --
4499: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
4500: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
4501: --
4502: END IF;
4503: --
4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4500: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
4501: --
4502: END IF;
4503: --
4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4505: IF get_loc_for_site%ISOPEN THEN
4506: CLOSE get_loc_for_site;
4507: END IF;
4508: IF c_check_vendor_wdd%ISOPEN THEN

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

4534: --
4535: IF l_debug_on THEN
4536: --
4537: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4538: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4539: --
4540: END IF;
4541: --
4542: WHEN OTHERS THEN