DBA Data[Home] [Help]

APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on FND_API

Line 254: WHEN FND_API.G_EXC_ERROR THEN

250: END IF;
251: --}
252: EXCEPTION
253: --
254: WHEN FND_API.G_EXC_ERROR THEN
255: --
256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
257: --
258: IF l_debug_on THEN

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

257: --
258: IF l_debug_on THEN
259: --
260: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
261: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
262: --
263: END IF;
264: --
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

261: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
262: --
263: END IF;
264: --
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: --
267: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
268: --
269: IF l_debug_on THEN

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

268: --
269: IF l_debug_on THEN
270: --
271: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
272: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
273: --
274: END IF;
275: --
276: WHEN OTHERS THEN

Line 820: WHEN FND_API.G_EXC_ERROR THEN

816: END IF;
817: --
818: EXCEPTION
819: --
820: WHEN FND_API.G_EXC_ERROR THEN
821: --
822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
823: --
824: IF l_debug_on THEN

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

822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
823: --
824: IF l_debug_on THEN
825: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
827: END IF;
828: --
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: --

Line 829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

825: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
827: END IF;
828: --
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: --
831: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
832: --
833: IF l_debug_on THEN

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

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

Line 1042: WHEN FND_API.G_EXC_ERROR THEN

1038: END IF;
1039:
1040: EXCEPTION
1041: --
1042: WHEN FND_API.G_EXC_ERROR THEN
1043: --
1044: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1045: --
1046: IF l_debug_on THEN

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

1045: --
1046: IF l_debug_on THEN
1047: --
1048: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
1049: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1050: --
1051: END IF;
1052: --
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1049: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1050: --
1051: END IF;
1052: --
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: --
1055: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1056: --
1057: IF l_debug_on THEN

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

1056: --
1057: IF l_debug_on THEN
1058: --
1059: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1060: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1061: --
1062: END IF;
1063: --
1064: WHEN OTHERS THEN

Line 1440: WHEN FND_API.G_EXC_ERROR THEN

1436: END IF;
1437: --
1438: EXCEPTION
1439: --
1440: WHEN FND_API.G_EXC_ERROR THEN
1441: --
1442: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1443: --
1444: IF l_debug_on THEN

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

1443: --
1444: IF l_debug_on THEN
1445: --
1446: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
1447: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1448: --
1449: END IF;
1450: --
1451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1447: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1448: --
1449: END IF;
1450: --
1451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1452: --
1453: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1454: --
1455: IF l_debug_on THEN

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

1454: --
1455: IF l_debug_on THEN
1456: --
1457: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1458: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1459: --
1460: END IF;
1461: --
1462: WHEN OTHERS THEN

Line 2486: p_init_msg_list => FND_API.G_FALSE,

2482: IF l_dlvy_rr_tbl.COUNT > 0 THEN
2483: --{
2484: WSH_DELIVERIES_GRP.delivery_action(
2485: p_api_version_number => 1.0,
2486: p_init_msg_list => FND_API.G_FALSE,
2487: p_commit => FND_API.G_FALSE,
2488: p_action_prms => l_action_prms,
2489: p_rec_attr_tab => l_dlvy_rr_tbl,
2490: x_delivery_out_rec => l_delivery_out_rec,

Line 2487: p_commit => FND_API.G_FALSE,

2483: --{
2484: WSH_DELIVERIES_GRP.delivery_action(
2485: p_api_version_number => 1.0,
2486: p_init_msg_list => FND_API.G_FALSE,
2487: p_commit => FND_API.G_FALSE,
2488: p_action_prms => l_action_prms,
2489: p_rec_attr_tab => l_dlvy_rr_tbl,
2490: x_delivery_out_rec => l_delivery_out_rec,
2491: x_defaults_rec => l_defaults_rec,

Line 2619: WHEN FND_API.G_EXC_ERROR THEN

2615: END IF;
2616:
2617: EXCEPTION
2618: --
2619: WHEN FND_API.G_EXC_ERROR THEN
2620: --
2621: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2622: ROLLBACK TO WSH_Vendor_Merge;
2623: --

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

2623: --
2624: IF l_debug_on THEN
2625: --
2626: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
2627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2628: --
2629: END IF;
2630: --
2631: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

Line 2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 2834: p_encoded => FND_API.G_FALSE

2830: FND_MSG_PUB.Count_And_Get
2831: (
2832: p_count => x_msg_count,
2833: p_data => x_msg_data,
2834: p_encoded => FND_API.G_FALSE
2835: );
2836: --
2837: IF l_debug_on THEN
2838: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

Line 2844: WHEN FND_API.G_EXC_ERROR THEN

2840: END IF;
2841: --}
2842: EXCEPTION
2843: --
2844: WHEN FND_API.G_EXC_ERROR THEN
2845: --
2846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2847: --
2848: IF l_debug_on THEN

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

2846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2847: --
2848: IF l_debug_on THEN
2849: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
2850: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2851: END IF;
2852: --
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: --

Line 2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2849: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
2850: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2851: END IF;
2852: --
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: --
2855: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2856: --
2857: IF l_debug_on THEN

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

2855: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2856: --
2857: IF l_debug_on THEN
2858: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2859: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2860: END IF;
2861: --
2862: WHEN OTHERS THEN
2863: --