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_MAPPING_DATA dependencies on WSH_UTIL_CORE

Line 211: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

207: wsh_debug_sv.log (l_module_name, 'delivery id' , p_delivery_id);
208: wsh_debug_sv.log (l_module_name, 'document type' , p_document_type);
209: END IF;
210:
211: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
212:
213: OPEN l_del_info_cur;
214: FETCH l_del_info_cur INTO x_name, l_customer_id, l_org_id,l_ship_to_location_id;--bug 3920178
215: IF ( l_del_info_cur % NOTFOUND) THEN

Line 253: l_operating_unit := WSH_UTIL_CORE.Get_OperatingUnit_Id(p_delivery_id);

249: END IF;
250:
251: IF l_ship_to_loc_code IS NULL THEN
252: --{
253: l_operating_unit := WSH_UTIL_CORE.Get_OperatingUnit_Id(p_delivery_id);
254:
255: IF l_debug_on THEN
256: WSH_DEBUG_SV.log(l_module_name, 'l_operating_unit' , l_operating_unit);
257: END IF;

Line 300: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

296: l_per_ph_number,
297: l_contact_person_name,
298: l_return_status
299: );
300: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303:
304: x_cnsgn_cont_per_name := l_contact_person_name;

Line 376: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

372: END IF;
373: EXCEPTION
374: --bug 3920178
375: WHEN fnd_api.g_exc_error THEN
376: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
380: END IF;

Line 382: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

378: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
380: END IF;
381: WHEN wsh_invalid_delivery_id THEN
382: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
386: END IF;

Line 389: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
386: END IF;
387:
388: WHEN OTHERS THEN
389: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
392: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 528: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_UTIL_CORE.GET_OPERATINGUNIT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);

524: FETCH loc_ids_cur INTO l_organization_id, l_init_loc_id, l_ult_loc_id, l_intmed_loc_id, l_pooled_loc_id, x_currency;
525: CLOSE loc_ids_cur;
526:
527: IF l_debug_on THEN
528: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_UTIL_CORE.GET_OPERATINGUNIT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
529: END IF;
530:
531: /* Patchset I: Locations Project. Get the OperatingUnit Id */
532: l_opUnit_id := wsh_util_core.get_OperatingUnit_id(p_delivery_id);

Line 532: l_opUnit_id := wsh_util_core.get_OperatingUnit_id(p_delivery_id);

528: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_UTIL_CORE.GET_OPERATINGUNIT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
529: END IF;
530:
531: /* Patchset I: Locations Project. Get the OperatingUnit Id */
532: l_opUnit_id := wsh_util_core.get_OperatingUnit_id(p_delivery_id);
533:
534:
535: IF l_debug_on THEN
536: wsh_debug_sv.log(l_module_name, 'Operating Unit Id', l_opUnit_id);

Line 639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

635: wsh_debug_sv.pop(l_module_name);
636: END IF;
637: EXCEPTION
638: WHEN OTHERS THEN
639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
640:
641: IF l_debug_on THEN
642: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
643: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 703: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

699: END IF;
700:
701: EXCEPTION
702: WHEN OTHERS THEN
703: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
704: IF l_debug_on THEN
705: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
706: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
707: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 786: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

782: --}
783: END IF;
784: -- bug 3857041
785:
786: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
787: IF l_debug_on THEN
788: wsh_debug_sv.pop(l_module_name);
789: END IF;
790:

Line 793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

789: END IF;
790:
791: EXCEPTION
792: WHEN OTHERS THEN
793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
794: IF l_debug_on THEN
795: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
796: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
797: END IF;

Line 967: l_delivery_detail_tab wsh_util_core.id_tab_type;

963: l_per_email_addr VARCHAR2(2000);
964:
965: l_uniq_ship_to_contact_id NUMBER;
966: l_curr_ship_to_contact_id NUMBER;
967: l_delivery_detail_tab wsh_util_core.id_tab_type;
968: l_ship_to_contact_id_tab wsh_util_core.id_tab_type;
969: l_return_status VARCHAR2(2);
970:
971:

Line 968: l_ship_to_contact_id_tab wsh_util_core.id_tab_type;

964:
965: l_uniq_ship_to_contact_id NUMBER;
966: l_curr_ship_to_contact_id NUMBER;
967: l_delivery_detail_tab wsh_util_core.id_tab_type;
968: l_ship_to_contact_id_tab wsh_util_core.id_tab_type;
969: l_return_status VARCHAR2(2);
970:
971:
972: l_debug_on BOOLEAN;

Line 985: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

981: THEN
982: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
983: END IF;
984: --
985: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
986:
987: IF l_debug_on THEN
988: wsh_debug_sv.push(l_module_name);
989: wsh_debug_sv.log (l_module_name, 'Location Id', p_location_id);

Line 1150: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1146: l_per_ph_number,
1147: l_contact_person_name,
1148: l_return_status
1149: );
1150: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1151: RAISE FND_API.G_EXC_ERROR;
1152: END IF;
1153:
1154: x_cnsgn_cont_per_name := l_contact_person_name;

Line 1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1166: END IF;
1167:
1168: EXCEPTION
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1171: wsh_util_core.add_message(x_return_status, l_module_name);
1172: --
1173: IF l_debug_on THEN
1174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1171: wsh_util_core.add_message(x_return_status, l_module_name);

1167:
1168: EXCEPTION
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1171: wsh_util_core.add_message(x_return_status, l_module_name);
1172: --
1173: IF l_debug_on THEN
1174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 1178: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1176: END IF;
1177: WHEN OTHERS THEN
1178: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1181: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1182: END IF;

Line 1245: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1241: THEN
1242: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1243: END IF;
1244: --
1245: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1246: IF l_debug_on THEN
1247: wsh_debug_sv.push(l_module_name);
1248: wsh_debug_sv.log (l_module_name, 'p_ship_to_site_contact_id', p_ship_to_site_contact_id);
1249: END IF;

Line 1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1300:
1301: EXCEPTION
1302:
1303: WHEN OTHERS THEN
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1305: IF l_debug_on THEN
1306: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1308: END IF;

Line 1472: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

1468: wsh_debug_sv.push(l_module_name);
1469: wsh_debug_sv.log (l_module_name, 'delivery id' , p_delivery_id);
1470: END IF;
1471: --
1472: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
1473:
1474: OPEN l_del_info_cur;
1475: FETCH l_del_info_cur INTO x_name, l_customer_id, l_org_id,l_ship_to_location_id;
1476: --

Line 1489: l_operating_unit := WSH_UTIL_CORE.Get_OperatingUnit_Id(p_delivery_id);

1485: END IF;
1486: --
1487: CLOSE l_del_info_cur;
1488:
1489: l_operating_unit := WSH_UTIL_CORE.Get_OperatingUnit_Id(p_delivery_id);
1490: x_org_id := l_operating_unit;
1491:
1492: -- Distributed - TPW Changes
1493: open c_cust_name_cur (l_customer_id);

Line 1629: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

1625: END IF;
1626: --
1627: EXCEPTION
1628: WHEN fnd_api.g_exc_error THEN
1629: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1633: END IF;

Line 1635: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

1631: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1633: END IF;
1634: WHEN wsh_invalid_delivery_id THEN
1635: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1636: IF l_debug_on THEN
1637: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
1639: END IF;

Line 1642: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

1638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
1639: END IF;
1640:
1641: WHEN OTHERS THEN
1642: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1643: IF l_debug_on THEN
1644: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1645: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1646: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1725: l_delivery_detail_tab wsh_util_core.id_tab_type;

1721: l_wsn_sum_qty NUMBER;
1722:
1723: l_uniq_ship_to_contact_id NUMBER;
1724: l_curr_ship_to_contact_id NUMBER;
1725: l_delivery_detail_tab wsh_util_core.id_tab_type;
1726: l_ship_to_contact_id_tab wsh_util_core.id_tab_type;
1727: l_return_status VARCHAR2(2);
1728: l_temp1 BOOLEAN;
1729: l_temp2 BOOLEAN;

Line 1726: l_ship_to_contact_id_tab wsh_util_core.id_tab_type;

1722:
1723: l_uniq_ship_to_contact_id NUMBER;
1724: l_curr_ship_to_contact_id NUMBER;
1725: l_delivery_detail_tab wsh_util_core.id_tab_type;
1726: l_ship_to_contact_id_tab wsh_util_core.id_tab_type;
1727: l_return_status VARCHAR2(2);
1728: l_temp1 BOOLEAN;
1729: l_temp2 BOOLEAN;
1730: -- Distributed - TPW Changes

Line 1748: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1744: THEN
1745: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1746: END IF;
1747: --
1748: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1749:
1750: IF l_debug_on THEN
1751: wsh_debug_sv.push(l_module_name);
1752: wsh_debug_sv.log(l_module_name, 'p_src_line_id',p_src_line_id);

Line 1893: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1889: x_shipto_cont_per_ph,
1890: x_shipto_cont_per_name,
1891: l_return_status
1892: );
1893: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1894: RAISE FND_API.G_EXC_ERROR;
1895: END IF;
1896: x_shipto_cont_per_id := l_uniq_ship_to_contact_id;
1897:

Line 1960: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1956: END IF;
1957:
1958: EXCEPTION
1959: WHEN FND_API.G_EXC_ERROR THEN
1960: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1961: wsh_util_core.add_message(x_return_status, l_module_name);
1962: --
1963: IF l_debug_on THEN
1964: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1961: wsh_util_core.add_message(x_return_status, l_module_name);

1957:
1958: EXCEPTION
1959: WHEN FND_API.G_EXC_ERROR THEN
1960: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1961: wsh_util_core.add_message(x_return_status, l_module_name);
1962: --
1963: IF l_debug_on THEN
1964: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1964: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1966: END IF;
1967: WHEN OTHERS THEN
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1969: IF l_debug_on THEN
1970: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1971: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1972: END IF;

Line 2043: l_delivery_detail_tab wsh_util_core.id_tab_type;

2039: l_uniq_deliver_to_site_id NUMBER;
2040: l_curr_deliver_to_site_id NUMBER;
2041: l_uniq_deliver_to_contact_id NUMBER;
2042: l_curr_deliver_to_contact_id NUMBER;
2043: l_delivery_detail_tab wsh_util_core.id_tab_type;
2044: l_return_status VARCHAR2(2);
2045: l_temp1 BOOLEAN;
2046: l_temp2 BOOLEAN;
2047: l_temp3 BOOLEAN;

Line 2065: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2061: THEN
2062: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2063: END IF;
2064: --
2065: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2066:
2067: IF l_debug_on THEN
2068: wsh_debug_sv.push(l_module_name);
2069: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);

Line 2185: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2181: END IF;
2182:
2183: EXCEPTION
2184: WHEN FND_API.G_EXC_ERROR THEN
2185: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2186: wsh_util_core.add_message(x_return_status, l_module_name);
2187: --
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2186: wsh_util_core.add_message(x_return_status, l_module_name);

2182:
2183: EXCEPTION
2184: WHEN FND_API.G_EXC_ERROR THEN
2185: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2186: wsh_util_core.add_message(x_return_status, l_module_name);
2187: --
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2189: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2191: END IF;
2192: WHEN OTHERS THEN
2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2194: IF l_debug_on THEN
2195: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2197: END IF;

Line 2309: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2305: x_contact_telephone,
2306: x_contact_name,
2307: l_return_status
2308: );
2309: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2310: RAISE FND_API.G_EXC_ERROR;
2311: END IF;
2312: END IF;
2313:

Line 2337: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2333: END IF;
2334:
2335: EXCEPTION
2336: WHEN OTHERS THEN
2337: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2338:
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2341: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2623: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2619: x_telephone,
2620: x_contact_name,
2621: l_return_status
2622: );
2623: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2624: RAISE FND_API.G_EXC_ERROR;
2625: END IF;
2626: END IF;
2627:

Line 2683: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2679: x_telephone,
2680: x_contact_name,
2681: l_return_status
2682: );
2683: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2684: RAISE FND_API.G_EXC_ERROR;
2685: END IF;
2686: END IF; --}
2687:

Line 2701: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2697: END IF;
2698:
2699: EXCEPTION
2700: WHEN OTHERS THEN
2701: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2702:
2703: IF l_debug_on THEN
2704: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2705: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2769: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2765: THEN
2766: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2767: END IF;
2768: --
2769: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2770: IF l_debug_on THEN
2771: wsh_debug_sv.push(l_module_name);
2772: wsh_debug_sv.log (l_module_name, 'p_contact_id', p_contact_id);
2773: END IF;

Line 2826: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2822: END IF;
2823:
2824: EXCEPTION
2825: WHEN OTHERS THEN
2826: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2827: IF l_debug_on THEN
2828: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2829: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2830: END IF;

Line 2858: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2854: WSH_DEBUG_SV.push(l_module_name);
2855: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code', p_ship_method_code);
2856: END IF;
2857: --
2858: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2859:
2860: select wc.freight_code, wcs.service_level, wcs.mode_of_transport
2861: into x_carrier_code, x_service_level, x_mode_of_transport
2862: from wsh_carrier_services wcs,

Line 2875: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2871: END IF;
2872: --
2873: EXCEPTION
2874: WHEN others THEN
2875: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2876: --
2877: IF l_debug_on THEN
2878: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2879: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2981: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2977: WSH_DEBUG_SV.log(l_module_name, 'p_partner_type', p_partner_type);
2978: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
2979: END IF;
2980: --
2981: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2982:
2983: select organization_id, ship_from_location_id, customer_id,
2984: ship_to_site_use_id, ship_to_contact_id,
2985: invoice_to_site_use_id, invoice_to_contact_id,

Line 3042: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3038: x_per_ph_number => x_telephone,
3039: x_contact_person_name => x_contact_name,
3040: x_return_status => l_return_status );
3041:
3042: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;
3045: END IF;
3046: ELSIF p_partner_type = 'BillTo' THEN

Line 3072: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3068: x_per_ph_number => x_telephone,
3069: x_contact_person_name => x_contact_name,
3070: x_return_status => l_return_status );
3071:
3072: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3073: RAISE FND_API.G_EXC_ERROR;
3074: END IF;
3075: END IF;
3076: ELSIF p_partner_type = 'DeliverTo' THEN

Line 3102: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3098: x_per_ph_number => x_telephone,
3099: x_contact_person_name => x_contact_name,
3100: x_return_status => l_return_status );
3101:
3102: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3103: RAISE FND_API.G_EXC_ERROR;
3104: END IF;
3105: END IF;
3106: END IF;

Line 3116: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3112: END IF;
3113: --
3114: EXCEPTION
3115: WHEN FND_API.G_EXC_ERROR THEN
3116: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3117: --
3118: IF l_debug_on THEN
3119: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3120: END IF;

Line 3123: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3119: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3120: END IF;
3121: --
3122: WHEN others THEN
3123: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3124: --
3125: IF l_debug_on THEN
3126: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3127: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3174: WSH_DEBUG_SV.push(l_module_name);
3175: WSH_DEBUG_SV.log(l_module_name, 'p_reference_line_id', p_reference_line_id);
3176: END IF;
3177: --
3178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3179:
3180: select order_quantity_uom,
3181: ol.line_number,
3182: msik.concatenated_segments,

Line 3257: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3253: END IF;
3254: --
3255: EXCEPTION
3256: WHEN FND_API.G_EXC_ERROR THEN
3257: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3258: --
3259: IF l_debug_on THEN
3260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3261: END IF;

Line 3264: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3261: END IF;
3262: --
3263: WHEN others THEN
3264: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3265: --
3266: IF l_debug_on THEN
3267: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3268: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');