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

Line 129: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

125: WSH_DEBUG_SV.push(l_module_name);
126: WSH_DEBUG_SV.log(l_module_name,'p_index',p_index);
127: END IF;
128:
129: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
130:
131: p_address.supplier_name(p_index):= NULL;
132: p_address.ship_from_address1(p_index):= NULL;
133: p_address.ship_from_address2(p_index):= NULL;

Line 154: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

150: WSH_DEBUG_SV.pop(l_module_name);
151: END IF;
152: EXCEPTION
153: WHEN OTHERS THEN
154: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
157: Oracle error message is '||
158:

Line 198: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

194: WSH_DEBUG_SV.push(l_module_name);
195: WSH_DEBUG_SV.log(l_module_name,'p_index',p_index);
196: END IF;
197:
198: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
199:
200: p_line.Delivery_line_number(p_index):= NULL;
201: p_line.po_header_number(p_index):= NULL;
202: p_line.Po_Release_number(p_index):= NULL;

Line 221: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

217: WSH_DEBUG_SV.pop(l_module_name);
218: END IF;
219: EXCEPTION
220: WHEN OTHERS THEN
221: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
222: IF l_debug_on THEN
223: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
224: Oracle error message is '||
225:

Line 265: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

261: WSH_DEBUG_SV.push(l_module_name);
262: WSH_DEBUG_SV.log(l_module_name,'p_index',p_index);
263: END IF;
264:
265: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
266: p_Delivery.Header_line_number(p_index):= NULL;
267: p_Delivery.ship_from_address1(p_index):= NULL;
268: p_Delivery.ship_from_address2(p_index):= NULL;
269: p_Delivery.ship_from_address3(p_index):= NULL;

Line 294: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

290: WSH_DEBUG_SV.pop(l_module_name);
291: END IF;
292: EXCEPTION
293: WHEN OTHERS THEN
294: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
295: IF l_debug_on THEN
296: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
297: Oracle error message is '||
298:

Line 339: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

335: WSH_DEBUG_SV.push(l_module_name);
336: WSH_DEBUG_SV.log(l_module_name,'p_index',p_index);
337: END IF;
338:
339: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
340:
341: p_header.Supplier_name(p_index):= NULL;
342: p_header.Request_date(p_index):= NULL;
343: p_header.Request_Number(p_index):= NULL;

Line 352: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

348: WSH_DEBUG_SV.pop(l_module_name);
349: END IF;
350: EXCEPTION
351: WHEN OTHERS THEN
352: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
355: Oracle error message is '||
356:

Line 403: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

399: WSH_DEBUG_SV.push(l_module_name);
400: WSH_DEBUG_SV.log(l_module_name,'p_error_tbl.count',p_error_tbl.count);
401: END IF;
402:
403: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
404:
405:
406: l_count := p_error_tbl.count;
407:

Line 421: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

417: END LOOP;
418:
419: IF (l_error_count >= l_count) THEN
420: --If all the lines are Error.
421: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
422: ELSIF ( l_error_count > 0 and l_error_count < l_count) THEN
423: --If more then one line and less then total line count are Error.
424: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
425: END IF;

Line 424: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

420: --If all the lines are Error.
421: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
422: ELSIF ( l_error_count > 0 and l_error_count < l_count) THEN
423: --If more then one line and less then total line count are Error.
424: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
425: END IF;
426:
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.log(l_module_name,'l_count',l_count);

Line 436: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

432:
433:
434: EXCEPTION
435: WHEN OTHERS THEN
436: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
437: IF l_debug_on THEN
438: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
439: Oracle error message is '||
440:

Line 1321: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1317: IF l_debug_on THEN
1318: WSH_DEBUG_SV.push(l_module_name);
1319: END IF;
1320:
1321: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1322:
1323: IF (p_col_name = g_field.name(cs_supplier_name) ) THEN
1324: IF (Is_field_valid(cs_supplier_name,p_col_value))THEN
1325: p_address.supplier_name(p_index):= p_col_value;

Line 1452: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1448: END IF;
1449: END IF;
1450:
1451: IF (l_error) THEN
1452: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1453: END IF;
1454:
1455: IF l_debug_on THEN
1456: WSH_DEBUG_SV.pop(l_module_name);

Line 1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1456: WSH_DEBUG_SV.pop(l_module_name);
1457: END IF;
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1461:
1462: IF l_debug_on THEN
1463: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
1464: Oracle error message is '||

Line 1536: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1532:
1533: WSH_DEBUG_SV.log(l_module_name,'p_file_fields.level_number.count',p_file_fields.level_number.count);
1534: END IF;
1535:
1536: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1537:
1538: --Initilized message and validation meta data.
1539: x_message_tbl := WSH_FILE_MSG_TABLE();
1540: g_error_tbl.delete;

Line 1552: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1548: Create_Address_Record(p_address =>l_address,
1549: p_index =>l_prev_line_number,
1550: x_return_status =>l_return_status);
1551:
1552: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1553: raise FND_API.G_EXC_ERROR;
1554: END IF;
1555:
1556: WHILE (l_index IS NOT NULL ) LOOP --{

Line 1566: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1562: Create_Address_Record(p_address =>l_address,
1563: p_index =>g_file_line_number,
1564: x_return_status =>l_return_status);
1565:
1566: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1567: raise FND_API.G_EXC_ERROR;
1568: END IF;
1569:
1570: --Find the mandatory missing columns.

Line 1589: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1585: WSH_DEBUG_SV.log(l_module_name,'Process_Address
1586: l_return_status',l_return_status);
1587: END IF;
1588:
1589: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1590: l_address.error_flag(g_file_line_number):='Y';
1591: END IF;
1592:
1593:

Line 1660: IF (x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

1656: WSH_DEBUG_SV.log(l_module_name,'Is_All_Line_Error
1657: x_return_status',x_return_status);
1658: END IF;
1659:
1660: IF (x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1661: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) ) THEN
1662: --Process the Supplier address book information.
1663: WSH_SUPPLIER_PARTY.Process_Address(
1664: p_in_param => p_in_param,

Line 1661: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) ) THEN

1657: x_return_status',x_return_status);
1658: END IF;
1659:
1660: IF (x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1661: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) ) THEN
1662: --Process the Supplier address book information.
1663: WSH_SUPPLIER_PARTY.Process_Address(
1664: p_in_param => p_in_param,
1665: p_Address => l_Address,

Line 1709: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

1705: WSH_DEBUG_SV.pop(l_module_name);
1706: END IF;
1707: EXCEPTION
1708: WHEN FND_API.G_EXC_ERROR THEN
1709: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1710:
1711: IF l_debug_on THEN
1712: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
1713: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1718: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1714: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1715: END IF;
1716:
1717: WHEN OTHERS THEN
1718: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1719:
1720: IF l_debug_on THEN
1721: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
1722: Oracle error message is '||

Line 1777: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1773: WSH_DEBUG_SV.push(l_module_name);
1774: WSH_DEBUG_SV.log(l_module_name,'p_col_name',p_col_name);
1775: END IF;
1776:
1777: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1778:
1779: IF (p_col_name = g_field.name(c_po_header_number) ) THEN
1780: IF (Is_field_valid(c_po_header_number,p_col_value)) THEN
1781: p_line.po_header_number(p_index):= p_col_value;

Line 1888: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1884: END IF;
1885: END IF;
1886:
1887: IF (l_error) THEN
1888: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1889: END IF;
1890:
1891: IF l_debug_on THEN
1892: WSH_DEBUG_SV.pop(l_module_name);

Line 1896: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1892: WSH_DEBUG_SV.pop(l_module_name);
1893: END IF;
1894: EXCEPTION
1895: WHEN OTHERS THEN
1896: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1897:
1898: IF l_debug_on THEN
1899: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
1900: Oracle error message is '||

Line 1958: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1954: IF l_debug_on THEN
1955: WSH_DEBUG_SV.push(l_module_name);
1956: END IF;
1957:
1958: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1959:
1960: IF (p_col_name = g_field.name(c_ship_from_add1) ) THEN
1961: IF (Is_field_valid(c_ship_from_add1,p_col_value))THEN
1962: p_Delivery.ship_from_address1(p_index):= p_col_value;

Line 2122: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2118: END IF;
2119: END IF;
2120:
2121: IF (l_error) THEN
2122: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2123: END IF;
2124:
2125: IF l_debug_on THEN
2126: WSH_DEBUG_SV.pop(l_module_name);

Line 2130: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2126: WSH_DEBUG_SV.pop(l_module_name);
2127: END IF;
2128: EXCEPTION
2129: WHEN OTHERS THEN
2130: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2131:
2132: IF l_debug_on THEN
2133: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
2134: Oracle error message is '||

Line 2191: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2187: IF l_debug_on THEN
2188: WSH_DEBUG_SV.push(l_module_name);
2189: END IF;
2190:
2191: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2192:
2193: IF (p_col_name = g_field.name(c_Supplier_name)) THEN
2194: IF (Is_field_valid(c_Supplier_name,p_col_value)) THEN
2195: p_header.Supplier_name(p_index):= p_col_value;

Line 2227: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2223: END IF;
2224:
2225:
2226: IF (l_error) THEN
2227: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2228: END IF;
2229:
2230:
2231: IF l_debug_on THEN

Line 2236: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2232: WSH_DEBUG_SV.pop(l_module_name);
2233: END IF;
2234: EXCEPTION
2235: WHEN OTHERS THEN
2236: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2237:
2238: IF l_debug_on THEN
2239: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
2240: Oracle error message is '||

Line 2315: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2311: WSH_DEBUG_SV.log(l_module_name,'p_rr_uom_code',p_rr_uom_code);
2312: WSH_DEBUG_SV.log(l_module_name,'p_rr_qty',p_rr_qty);
2313: END IF;
2314:
2315: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2316:
2317: l_rr_uom_code:= p_rr_uom_code;
2318: x_convert_qty := p_rr_qty;
2319:

Line 2340: wsh_util_core.api_post_call(

2336: IF l_debug_on THEN
2337: WSH_DEBUG_SV.log(l_module_name,'wsh_util_validate.validate_uom
2338: l_return_status',l_return_status);
2339: END IF;
2340: wsh_util_core.api_post_call(
2341: p_return_status => l_return_status,
2342: x_num_warnings => l_num_warnings,
2343: x_num_errors => l_num_errors);
2344:

Line 2366: wsh_util_core.api_post_call(

2362: WSH_DEBUG_SV.log(l_module_name,'convert_quantity l_return_status',l_return_status);
2363: WSH_DEBUG_SV.log(l_module_name,'x_convert_qty',x_convert_qty);
2364: END IF;
2365:
2366: wsh_util_core.api_post_call(
2367: p_return_status => l_return_status,
2368: x_num_warnings => l_num_warnings,
2369: x_num_errors => l_num_errors);
2370: END IF;

Line 2374: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2370: END IF;
2371: END IF;
2372:
2373: IF l_num_errors > 0 THEN
2374: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2375: ELSIF l_num_warnings > 0 THEN
2376: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2377: END IF;
2378:

Line 2376: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2372:
2373: IF l_num_errors > 0 THEN
2374: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2375: ELSIF l_num_warnings > 0 THEN
2376: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2377: END IF;
2378:
2379: IF l_debug_on THEN
2380: WSH_DEBUG_SV.pop(l_module_name);

Line 2384: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

2380: WSH_DEBUG_SV.pop(l_module_name);
2381: END IF;
2382: EXCEPTION
2383: WHEN FND_API.G_EXC_ERROR THEN
2384: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2385:
2386: IF l_debug_on THEN
2387: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
2388: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2393: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2390: END IF;
2391:
2392: WHEN OTHERS THEN
2393: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2394:
2395: IF l_debug_on THEN
2396: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
2397: Oracle error message is '||

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

2511:
2512: IF (p_vendor_id IS NULL) THEN
2513: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2514: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_vendor_id');
2515: wsh_util_core.add_message(x_return_status,l_module_name);
2516: raise fnd_api.g_exc_error;
2517: END IF;
2518:
2519: IF (P_location_code IS NULL) THEN

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

2518:
2519: IF (P_location_code IS NULL) THEN
2520: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2521: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_location_code');
2522: wsh_util_core.add_message(x_return_status,l_module_name);
2523: raise fnd_api.g_exc_error;
2524: END IF;
2525:
2526: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2526: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2522: wsh_util_core.add_message(x_return_status,l_module_name);
2523: raise fnd_api.g_exc_error;
2524: END IF;
2525:
2526: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2527:
2528: OPEN check_location_csr(p_party_id,p_location_code||'|'||p_party_id);
2529: FETCH check_location_csr INTO x_location_id,l_party_site_id,l_party_id,l_party_site_status; -- IB-phase-2
2530: --

Line 2568: wsh_util_core.api_post_call(

2564: WSH_DEBUG_SV.log(l_module_name,'x_location_id',x_location_id);
2565: WSH_DEBUG_SV.log(l_module_name,'l_party_site_id',l_party_site_id);
2566: END IF;
2567:
2568: wsh_util_core.api_post_call(
2569: p_return_status => l_return_status,
2570: x_num_warnings => l_num_warnings,
2571: x_num_errors => l_num_errors);
2572:

Line 2611: wsh_util_core.api_post_call(

2607: IF l_debug_on THEN
2608: WSH_DEBUG_SV.log(l_module_name,'Update_Address l_return_status',l_return_status);
2609: END IF;
2610:
2611: wsh_util_core.api_post_call(
2612: p_return_status => l_return_status,
2613: x_num_warnings => l_num_warnings,
2614: x_num_errors => l_num_errors);
2615: END IF; --}

Line 2620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2616: CLOSE check_location_csr;
2617:
2618:
2619: IF l_num_errors > 0 THEN
2620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2621: ELSIF l_num_warnings > 0 THEN
2622: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2623: END IF;
2624:

Line 2622: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2618:
2619: IF l_num_errors > 0 THEN
2620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2621: ELSIF l_num_warnings > 0 THEN
2622: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2623: END IF;
2624:
2625: IF l_debug_on THEN
2626: WSH_DEBUG_SV.pop(l_module_name);

Line 2630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

2626: WSH_DEBUG_SV.pop(l_module_name);
2627: END IF;
2628: EXCEPTION
2629: WHEN FND_API.G_EXC_ERROR THEN
2630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2631:
2632: IF (check_location_csr%ISOPEN) THEN
2633: CLOSE check_location_csr;
2634: END IF;

Line 2643: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2640: END IF;
2641:
2642: WHEN OTHERS THEN
2643: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2644:
2645: IF (check_location_csr%ISOPEN) THEN
2646: CLOSE check_location_csr;
2647: END IF;

Line 2709: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2705:
2706: WSH_DEBUG_SV.log(l_module_name,'p_po_line_location_id',p_po_line_location_id);
2707: END IF;
2708:
2709: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2710:
2711:
2712: --Get the attributes of PO line from Purchase Order
2713: WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes(

Line 2724: wsh_util_core.api_post_call(

2720: WSH_DEBUG_SV.log(l_module_name,'WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes
2721: l_return_status',l_return_status);
2722: END IF;
2723:
2724: wsh_util_core.api_post_call(
2725: p_return_status => l_return_status,
2726: x_num_warnings => l_num_warnings,
2727: x_num_errors => l_num_errors);
2728:

Line 2749: wsh_util_core.api_post_call(

2745: IF l_debug_on THEN
2746: WSH_DEBUG_SV.log(l_module_name,'WSH_PO_CMG_PVT.populate_additional_line_info l_return_status',l_return_status);
2747: WSH_DEBUG_SV.log(l_module_name,'l_additional_line_info_rec.service_level.count',l_additional_line_info_rec.service_level.count);
2748: END IF;
2749: wsh_util_core.api_post_call(
2750: p_return_status => l_return_status,
2751: x_num_warnings => l_num_warnings,
2752: x_num_errors => l_num_errors,
2753: p_module_name => l_module_name,

Line 2783: wsh_util_core.api_post_call(

2779: IF l_debug_on THEN
2780: WSH_DEBUG_SV.log(l_module_name,'WSH_BULK_PROCESS_PVT.bulk_insert_details
2781: l_return_status',l_return_status);
2782: END IF;
2783: wsh_util_core.api_post_call(
2784: p_return_status => l_return_status,
2785: x_num_warnings => l_num_warnings,
2786: x_num_errors => l_num_errors,
2787: p_module_name => l_module_name,

Line 2794: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2790: x_delivery_detail_id :=
2791: l_line_rec.delivery_detail_id(l_line_rec.delivery_detail_id.first);
2792:
2793: IF l_num_errors > 0 THEN
2794: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2795: ELSIF l_num_warnings > 0 THEN
2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2797: END IF;
2798:

Line 2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2792:
2793: IF l_num_errors > 0 THEN
2794: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2795: ELSIF l_num_warnings > 0 THEN
2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2797: END IF;
2798:
2799: IF l_debug_on THEN
2800:

Line 2807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

2803: END IF;
2804:
2805: EXCEPTION
2806: WHEN FND_API.G_EXC_ERROR THEN
2807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2808:
2809: IF l_debug_on THEN
2810: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
2811: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2816: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2812: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2813: END IF;
2814:
2815: WHEN OTHERS THEN
2816: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2817:
2818: IF l_debug_on THEN
2819: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
2820: Oracle error message is '||

Line 2891: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2887: WSH_DEBUG_SV.log(l_module_name,'Current_Release',PO_CODE_RELEASE_GRP.Current_Release);
2888: WSH_DEBUG_SV.log(l_module_name,'PRC_11i_Family_Pack_J',PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J);
2889: END IF;
2890:
2891: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2892:
2893: --Validate status only if code release is PRC_11i_Family_Pack_J or later.
2894: IF (PO_CODE_RELEASE_GRP.Current_Release >=PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J) THEN
2895: IF l_debug_on THEN

Line 2913: wsh_util_core.api_post_call(

2909: IF l_debug_on THEN
2910: WSH_DEBUG_SV.log(l_module_name,'PO_FTE_INTEGRATION_GRP.po_status_check l_return_status',l_return_status);
2911: END IF;
2912:
2913: wsh_util_core.api_post_call(
2914: p_return_status => l_return_status,
2915: x_num_warnings => l_num_warnings,
2916: x_num_errors => l_num_errors,
2917: p_module_name => l_module_name,

Line 2972: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2968: raise fnd_api.g_exc_error;
2969: END IF;
2970:
2971: IF l_num_errors > 0 THEN
2972: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2973: ELSIF l_num_warnings > 0 THEN
2974: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2975: END IF;
2976:

Line 2974: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2970:
2971: IF l_num_errors > 0 THEN
2972: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2973: ELSIF l_num_warnings > 0 THEN
2974: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2975: END IF;
2976:
2977: IF l_debug_on THEN
2978: WSH_DEBUG_SV.pop(l_module_name);

Line 2982: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

2978: WSH_DEBUG_SV.pop(l_module_name);
2979: END IF;
2980: EXCEPTION
2981: WHEN FND_API.G_EXC_ERROR THEN
2982: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2983:
2984: IF l_debug_on THEN
2985: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
2986: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2991: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2988: END IF;
2989:
2990: WHEN OTHERS THEN
2991: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2992:
2993: IF l_debug_on THEN
2994: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
2995: Oracle error message is '||

Line 3089: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3085: WSH_DEBUG_SV.log(l_module_name,'volume',p_line.volume(p_line_index));
3086: WSH_DEBUG_SV.log(l_module_name,'volume_uom',p_line.volume_uom(p_line_index));
3087: END IF;
3088:
3089: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3090:
3091:
3092: --Either latest_pickup_date or earliest_pickup_date is requried.
3093: --If both date are specified than earlies pickup date should not be grater than latest pickup date.

Line 3217: wsh_util_core.api_post_call(

3213: WSH_DEBUG_SV.log(l_module_name,'convert_quantity l_return_status',l_return_status);
3214: WSH_DEBUG_SV.log(l_module_name,'x_convert_qty',l_item_qty);
3215: END IF;
3216:
3217: wsh_util_core.api_post_call(
3218: p_return_status => l_return_status,
3219: x_num_warnings => l_num_warnings,
3220: x_num_errors => l_num_errors);
3221: END IF;

Line 3240: wsh_util_core.api_post_call(

3236: WSH_DEBUG_SV.log(l_module_name,'validate_uom l_return_status',l_return_status);
3237: WSH_DEBUG_SV.log(l_module_name,'l_item_qty',l_item_qty);
3238: END IF;
3239:
3240: wsh_util_core.api_post_call(
3241: p_return_status => l_return_status,
3242: x_num_warnings => l_num_warnings,
3243: x_num_errors => l_num_errors);
3244:

Line 3264: wsh_util_core.api_post_call(

3260: IF l_debug_on THEN
3261: WSH_DEBUG_SV.log(l_module_name,'WSH_DETAILS_VALIDATIONS.check_decimal_quantity l_return_status',l_return_status);
3262: WSH_DEBUG_SV.log(l_module_name,'x_detail_item_qty',x_detail_item_qty);
3263: END IF;
3264: wsh_util_core.api_post_call(
3265: p_return_status => l_return_status,
3266: x_num_warnings => l_num_warnings,
3267: x_num_errors => l_num_errors);
3268:

Line 3286: wsh_util_core.api_post_call(

3282: IF l_debug_on THEN
3283: WSH_DEBUG_SV.log(l_module_name,'validate_uom l_return_status',l_return_status);
3284: END IF;
3285:
3286: wsh_util_core.api_post_call(
3287: p_return_status => l_return_status,
3288: x_num_warnings => l_num_warnings,
3289: x_num_errors => l_num_errors);
3290: END IF;

Line 3303: wsh_util_core.api_post_call(

3299:
3300: IF l_debug_on THEN
3301: WSH_DEBUG_SV.log(l_module_name,'validate_uom l_return_status',l_return_status);
3302: END IF;
3303: wsh_util_core.api_post_call(
3304: p_return_status => l_return_status,
3305: x_num_warnings => l_num_warnings,
3306: x_num_errors => l_num_errors);
3307: END IF;

Line 3310: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3306: x_num_errors => l_num_errors);
3307: END IF;
3308:
3309: IF l_num_errors > 0 THEN
3310: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3311: ELSIF l_num_warnings > 0 THEN
3312: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3313: END IF;
3314:

Line 3312: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3308:
3309: IF l_num_errors > 0 THEN
3310: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3311: ELSIF l_num_warnings > 0 THEN
3312: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3313: END IF;
3314:
3315: IF l_debug_on THEN
3316: WSH_DEBUG_SV.pop(l_module_name);

Line 3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

3316: WSH_DEBUG_SV.pop(l_module_name);
3317: END IF;
3318: EXCEPTION
3319: WHEN FND_API.G_EXC_ERROR THEN
3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
3321:
3322: IF l_debug_on THEN
3323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
3324: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3329: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3325: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3326: END IF;
3327:
3328: WHEN OTHERS THEN
3329: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3330:
3331: IF l_debug_on THEN
3332: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
3333: Oracle error message is '||

Line 3391: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3387: WSH_DEBUG_SV.log(l_module_name,'p_delivery_index',p_delivery_index);
3388: WSH_DEBUG_SV.log(l_module_name,'p_delivery.Ship_From_Address1.count',p_delivery.Ship_From_Address1.count);
3389: END IF;
3390:
3391: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3392:
3393:
3394: IF (nvl(p_delivery.Number_of_containers(p_delivery_index),1) < 0 ) THEN
3395: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_NEG_NUM');

Line 3484: wsh_util_core.api_post_call(

3480: WSH_DEBUG_SV.log(l_module_name,'Process_Address l_return_status',l_return_status);
3481: WSH_DEBUG_SV.log(l_module_name,'ship_from_location_id',p_detail_att.ship_from_location_id);
3482: WSH_DEBUG_SV.log(l_module_name,'party_site_id',p_detail_att.party_site_id);
3483: END IF;
3484: wsh_util_core.api_post_call(
3485: p_return_status => l_return_status,
3486: x_num_warnings => l_num_warnings,
3487: x_num_errors => l_num_errors);
3488:

Line 3490: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3486: x_num_warnings => l_num_warnings,
3487: x_num_errors => l_num_errors);
3488:
3489: IF l_num_errors > 0 THEN
3490: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3491: ELSIF l_num_warnings > 0 THEN
3492: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3493: END IF;
3494:

Line 3492: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3488:
3489: IF l_num_errors > 0 THEN
3490: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3491: ELSIF l_num_warnings > 0 THEN
3492: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3493: END IF;
3494:
3495: IF l_debug_on THEN
3496: WSH_DEBUG_SV.pop(l_module_name);

Line 3500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

3496: WSH_DEBUG_SV.pop(l_module_name);
3497: END IF;
3498: EXCEPTION
3499: WHEN FND_API.G_EXC_ERROR THEN
3500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
3501:
3502: p_delivery.error_flag(p_delivery_index):= 'Y';
3503:
3504:

Line 3512: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3508: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3509: END IF;
3510:
3511: WHEN OTHERS THEN
3512: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3513:
3514: p_delivery.error_flag(p_delivery_index):= 'Y';
3515:
3516: IF l_debug_on THEN

Line 3570: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3566: WSH_DEBUG_SV.log(l_module_name,'p_delivery_index',p_delivery_index);
3567: WSH_DEBUG_SV.log(l_module_name,'p_delivery.Ship_From_Address1.count',p_delivery.Ship_From_Address1.count);
3568: END IF;
3569:
3570: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3571:
3572:
3573: IF (p_delivery.weight_uom(p_delivery_index) IS NOT NULL) THEN
3574: --Call wrapper api for final validation.

Line 3586: wsh_util_core.api_post_call(

3582: IF l_debug_on THEN
3583: WSH_DEBUG_SV.log(l_module_name,'validate_uom l_return_status',l_return_status);
3584: END IF;
3585:
3586: wsh_util_core.api_post_call(
3587: p_return_status => l_return_status,
3588: x_num_warnings => l_num_warnings,
3589: x_num_errors => l_num_errors);
3590: END IF;

Line 3604: wsh_util_core.api_post_call(

3600:
3601: IF l_debug_on THEN
3602: WSH_DEBUG_SV.log(l_module_name,'validate_uom l_return_status',l_return_status);
3603: END IF;
3604: wsh_util_core.api_post_call(
3605: p_return_status => l_return_status,
3606: x_num_warnings => l_num_warnings,
3607: x_num_errors => l_num_errors);
3608: END IF;

Line 3612: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3608: END IF;
3609:
3610:
3611: IF l_num_errors > 0 THEN
3612: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3613: ELSIF l_num_warnings > 0 THEN
3614: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3615: END IF;
3616:

Line 3614: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3610:
3611: IF l_num_errors > 0 THEN
3612: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3613: ELSIF l_num_warnings > 0 THEN
3614: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3615: END IF;
3616:
3617: IF l_debug_on THEN
3618: WSH_DEBUG_SV.pop(l_module_name);

Line 3622: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

3618: WSH_DEBUG_SV.pop(l_module_name);
3619: END IF;
3620: EXCEPTION
3621: WHEN FND_API.G_EXC_ERROR THEN
3622: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
3623:
3624: p_delivery.error_flag(p_delivery_index):= 'Y';
3625:
3626:

Line 3634: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3631: END IF;
3632:
3633: WHEN OTHERS THEN
3634: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3635:
3636: p_delivery.error_flag(p_delivery_index):= 'Y';
3637:
3638: IF l_debug_on THEN

Line 3682: p_detail_ids IN wsh_util_core.id_tab_type,

3678: -- x_new_detail_ids OUT NOCOPY New delivery detail id's created result of split.
3679: -- x_return_status OUT NOCOPY Standard to output api status.
3680: -- End of comments
3681: PROCEDURE Update_Split_Details(
3682: p_detail_ids IN wsh_util_core.id_tab_type,
3683: p_detail_att IN detail_att_rec_type,
3684: x_new_detail_ids OUT NOCOPY wsh_util_core.id_tab_type,
3685: x_return_status OUT NOCOPY varchar2) IS
3686:

Line 3684: x_new_detail_ids OUT NOCOPY wsh_util_core.id_tab_type,

3680: -- End of comments
3681: PROCEDURE Update_Split_Details(
3682: p_detail_ids IN wsh_util_core.id_tab_type,
3683: p_detail_att IN detail_att_rec_type,
3684: x_new_detail_ids OUT NOCOPY wsh_util_core.id_tab_type,
3685: x_return_status OUT NOCOPY varchar2) IS
3686:
3687: l_debug_on BOOLEAN;
3688: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Update_Split_Details';

Line 3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3718: WSH_DEBUG_SV.push(l_module_name);
3719: WSH_DEBUG_SV.log(l_module_name,'p_detail_ids.count',p_detail_ids.count);
3720: END IF;
3721:
3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3723:
3724:
3725: l_index := p_detail_ids.first;
3726: l_first_detail_id:=p_detail_ids(l_index);

Line 3759: WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV);

3755: --Calculate the Secondary qty.
3756: IF (p_detail_att.requested_quantity2 <> 0 ) THEN
3757: -- HW OPMCONV - No need to use OPM precision. Use current INV which is 5
3758: l_picked_quantity2 := ROUND(l_ratio * l_picked_quantity,
3759: WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV);
3760: ELSE
3761: l_picked_quantity2:= NULL;
3762: END IF;
3763:

Line 3837: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3833: IF l_debug_on THEN
3834: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3835: END IF;
3836: -- Only Handle Unexpected error
3837: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3838: --
3839: x_return_status := l_dbi_rs;
3840: IF l_debug_on THEN
3841: WSH_DEBUG_SV.pop(l_module_name);

Line 3861: l_item_quantity2 := ROUND(l_ratio * l_item_quantity,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV);

3857:
3858: --Calculate the secondary split qty.
3859: IF (p_detail_att.requested_quantity2 <> 0) THEN
3860: -- HW OPMCONV - No need to use OPM precision. Use current INV which is 5
3861: l_item_quantity2 := ROUND(l_ratio * l_item_quantity,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV);
3862: ELSE
3863: l_item_quantity2 := NULL;
3864: END IF;
3865:

Line 3887: wsh_util_core.api_post_call(

3883: WSH_DEBUG_SV.log(l_module_name,'Split_Delivery_Details l_return_status',l_return_status);
3884: WSH_DEBUG_SV.log(l_module_name,'l_split_delivery_detail_id',l_split_delivery_detail_id);
3885: WSH_DEBUG_SV.log(l_module_name,'l_item_quantity',l_item_quantity);
3886: END IF;
3887: wsh_util_core.api_post_call(
3888: p_return_status => l_return_status,
3889: x_num_warnings => l_num_warnings,
3890: x_num_errors => l_num_errors);
3891:

Line 3939: wsh_util_core.api_post_call(

3935:
3936: IF l_debug_on THEN
3937: WSH_DEBUG_SV.log(l_module_name,'Delete_Delivery_Details l_return_status',l_return_status);
3938: END IF;
3939: wsh_util_core.api_post_call(
3940: p_return_status => l_return_status,
3941: x_num_warnings => l_num_warnings,
3942: x_num_errors => l_num_errors);
3943:

Line 3952: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3948:
3949: END IF; --}
3950:
3951: IF l_num_errors > 0 THEN
3952: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3953: ELSIF l_num_warnings > 0 THEN
3954: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3955: END IF;
3956:

Line 3954: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3950:
3951: IF l_num_errors > 0 THEN
3952: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3953: ELSIF l_num_warnings > 0 THEN
3954: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3955: END IF;
3956:
3957: IF l_debug_on THEN
3958:

Line 3964: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

3960: WSH_DEBUG_SV.pop(l_module_name);
3961: END IF;
3962: EXCEPTION
3963: WHEN FND_API.G_EXC_ERROR THEN
3964: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
3965:
3966: IF l_debug_on THEN
3967: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
3968: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3973: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3969: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3970: END IF;
3971:
3972: WHEN OTHERS THEN
3973: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3974:
3975: IF l_debug_on THEN
3976: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
3977: Oracle error message is '||

Line 4024: l_detail_ids wsh_util_core.id_tab_type;

4020: AND wdd.delivery_detail_id = wda.delivery_detail_id
4021: ORDER BY wda.delivery_id;
4022:
4023: l_msg_count number;
4024: l_detail_ids wsh_util_core.id_tab_type;
4025: l_action_prms wsh_glbl_var_strct_grp.dd_action_parameters_rec_type;
4026: l_dlvy_ids wsh_util_core.id_tab_type;
4027: l_prev_delivery_id number;
4028: l_num_warnings number;

Line 4026: l_dlvy_ids wsh_util_core.id_tab_type;

4022:
4023: l_msg_count number;
4024: l_detail_ids wsh_util_core.id_tab_type;
4025: l_action_prms wsh_glbl_var_strct_grp.dd_action_parameters_rec_type;
4026: l_dlvy_ids wsh_util_core.id_tab_type;
4027: l_prev_delivery_id number;
4028: l_num_warnings number;
4029: l_num_errors number;
4030: BEGIN

Line 4041: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4037: WSH_DEBUG_SV.push(l_module_name);
4038: WSH_DEBUG_SV.log(l_module_name,'p_routing_req_id',p_routing_req_id);
4039: END IF;
4040:
4041: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4042:
4043:
4044: FOR del_rec IN unassign_del_csr LOOP
4045: IF l_debug_on THEN

Line 4079: wsh_util_core.api_post_call(

4075: IF l_debug_on THEN
4076: WSH_DEBUG_SV.log(l_module_name,'WSH_NEW_DELIVERY_ACTIONS.plan l_return_status',l_return_status);
4077: END IF;
4078:
4079: wsh_util_core.api_post_call(
4080: p_return_status => l_return_status,
4081: x_num_warnings => l_num_warnings,
4082: x_num_errors => l_num_errors);
4083:

Line 4102: wsh_util_core.api_post_call(

4098: WSH_DEBUG_SV.log(l_module_name,'Unassign_Multiple_Details
4099: l_return_status',l_return_status);
4100: END IF;
4101:
4102: wsh_util_core.api_post_call(
4103: p_return_status => l_return_status,
4104: x_num_warnings => l_num_warnings,
4105: x_num_errors => l_num_errors);
4106: END IF;

Line 4109: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4105: x_num_errors => l_num_errors);
4106: END IF;
4107:
4108: IF l_num_errors > 0 THEN
4109: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4110: ELSIF l_num_warnings > 0 THEN
4111: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4112: END IF;
4113:

Line 4111: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4107:
4108: IF l_num_errors > 0 THEN
4109: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4110: ELSIF l_num_warnings > 0 THEN
4111: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4112: END IF;
4113:
4114: IF l_debug_on THEN
4115: WSH_DEBUG_SV.pop(l_module_name);

Line 4119: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

4115: WSH_DEBUG_SV.pop(l_module_name);
4116: END IF;
4117: EXCEPTION
4118: WHEN FND_API.G_EXC_ERROR THEN
4119: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
4120:
4121: IF l_debug_on THEN
4122: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
4123: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 4128: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4124: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4125: END IF;
4126:
4127: WHEN OTHERS THEN
4128: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4129:
4130: IF l_debug_on THEN
4131: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
4132: Oracle error message is '||

Line 4168: p_detail_ids IN wsh_util_core.id_tab_type,

4164: -- x_new_deliveries OUT NOCOPY Id of new delivery created.
4165: -- x_return_status OUT NOCOPY Standard to output api status.
4166: -- End of comments
4167: PROCEDURE Create_Delivery(
4168: p_detail_ids IN wsh_util_core.id_tab_type,
4169: p_delivery_index IN NUMBER,
4170: p_delivery IN OUT NOCOPY Delivery_Rec_Type,
4171: x_new_deliveries OUT NOCOPY wsh_util_core.id_tab_type,
4172: x_return_status OUT NOCOPY VARCHAR2) IS

Line 4171: x_new_deliveries OUT NOCOPY wsh_util_core.id_tab_type,

4167: PROCEDURE Create_Delivery(
4168: p_detail_ids IN wsh_util_core.id_tab_type,
4169: p_delivery_index IN NUMBER,
4170: p_delivery IN OUT NOCOPY Delivery_Rec_Type,
4171: x_new_deliveries OUT NOCOPY wsh_util_core.id_tab_type,
4172: x_return_status OUT NOCOPY VARCHAR2) IS
4173:
4174: l_debug_on BOOLEAN;
4175: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Delivery';

Line 4180: l_dummy_rows wsh_util_core.id_tab_type;

4176: l_return_status varchar2(1);
4177: l_ship_from_location_id number;
4178: l_party_id number;
4179: l_party_site_id number;
4180: l_dummy_rows wsh_util_core.id_tab_type;
4181: l_new_deliveries wsh_util_core.id_tab_type;
4182: l_new_detail_ids wsh_util_core.id_tab_type;
4183:
4184: --Proration

Line 4181: l_new_deliveries wsh_util_core.id_tab_type;

4177: l_ship_from_location_id number;
4178: l_party_id number;
4179: l_party_site_id number;
4180: l_dummy_rows wsh_util_core.id_tab_type;
4181: l_new_deliveries wsh_util_core.id_tab_type;
4182: l_new_detail_ids wsh_util_core.id_tab_type;
4183:
4184: --Proration
4185: l_old_net_weight NUMBER :=0;

Line 4182: l_new_detail_ids wsh_util_core.id_tab_type;

4178: l_party_id number;
4179: l_party_site_id number;
4180: l_dummy_rows wsh_util_core.id_tab_type;
4181: l_new_deliveries wsh_util_core.id_tab_type;
4182: l_new_detail_ids wsh_util_core.id_tab_type;
4183:
4184: --Proration
4185: l_old_net_weight NUMBER :=0;
4186: l_old_gross_weight NUMBER :=0;

Line 4238: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4234: WSH_DEBUG_SV.log(l_module_name,'p_delivery_index',p_delivery_index);
4235: WSH_DEBUG_SV.log(l_module_name,'p_delivery.Ship_From_Address1.count',p_delivery.Ship_From_Address1.count);
4236: END IF;
4237:
4238: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4239:
4240: --Auto create delivery
4241: IF (p_detail_ids.count > 0 ) THEN
4242:

Line 4263: wsh_util_core.api_post_call(

4259: WSH_DEBUG_SV.log(l_module_name,'wsh_util_validate.validate_uom l_return_status',l_return_status);
4260: WSH_DEBUG_SV.log(l_module_name,'l_dd_action_out_rec.count',l_dd_action_out_rec.delivery_id_tab.count);
4261: END IF;
4262:
4263: wsh_util_core.api_post_call(
4264: p_return_status => l_return_status,
4265: x_num_warnings => l_num_warnings,
4266: x_num_errors => l_num_errors);
4267:

Line 4360: wsh_util_core.api_post_call(

4356: IF l_debug_on THEN
4357: WSH_DEBUG_SV.log(l_module_name,'WSH_NEW_DELIVERY_ACTIONS.plan l_return_status',l_return_status);
4358: END IF;
4359:
4360: wsh_util_core.api_post_call(
4361: p_return_status => l_return_status,
4362: x_num_warnings => l_num_warnings,
4363: x_num_errors => l_num_errors);
4364: END IF;

Line 4420: wsh_util_core.api_post_call(

4416: IF l_debug_on THEN
4417: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4418: END IF;
4419:
4420: wsh_util_core.api_post_call(
4421: p_return_status => l_return_status,
4422: x_num_warnings => l_num_warnings,
4423: x_num_errors => l_num_errors);
4424: END IF;

Line 4440: wsh_util_core.api_post_call(

4436: p_override_flag => 'Y',
4437: p_calc_wv_if_frozen => 'N',
4438: x_return_status => l_return_status);
4439:
4440: wsh_util_core.api_post_call(
4441: p_return_status => l_return_status,
4442: x_num_warnings => l_num_warnings,
4443: x_num_errors => l_num_errors);
4444: END IF;

Line 4454: wsh_util_core.api_post_call(

4450: p_update_flag => 'Y',
4451: p_calc_wv_if_frozen => 'N',
4452: x_return_status => l_return_status);
4453:
4454: wsh_util_core.api_post_call(
4455: p_return_status => l_return_status,
4456: x_num_warnings => l_num_warnings,
4457: x_num_errors => l_num_errors);
4458: END IF;

Line 4462: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4458: END IF;
4459: END IF;
4460:
4461: IF l_num_errors > 0 THEN
4462: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4463: ELSIF l_num_warnings > 0 THEN
4464: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4465: END IF;
4466:

Line 4464: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4460:
4461: IF l_num_errors > 0 THEN
4462: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4463: ELSIF l_num_warnings > 0 THEN
4464: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4465: END IF;
4466:
4467: IF l_debug_on THEN
4468: WSH_DEBUG_SV.pop(l_module_name);

Line 4472: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

4468: WSH_DEBUG_SV.pop(l_module_name);
4469: END IF;
4470: EXCEPTION
4471: WHEN FND_API.G_EXC_ERROR THEN
4472: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
4473:
4474: p_delivery.error_flag(p_delivery_index):= 'Y';
4475:
4476: IF l_debug_on THEN

Line 4483: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4479: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4480: END IF;
4481:
4482: WHEN OTHERS THEN
4483: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4484:
4485: p_delivery.error_flag(p_delivery_index):= 'Y';
4486:
4487: IF l_debug_on THEN

Line 4564: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4560: WSH_DEBUG_SV.log(l_module_name,'p_request_revision',p_request_revision);
4561: WSH_DEBUG_SV.log(l_module_name,'p_supplier_name',p_supplier_name);
4562: END IF;
4563:
4564: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4565:
4566: --Negative revision is not allowed.
4567: IF (p_request_revision < 0 ) THEN
4568: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_NEG_NUM');

Line 4589: wsh_util_core.api_post_call(

4585: WSH_DEBUG_SV.log(l_module_name,'Validate_Supplier l_return_status',l_return_status);
4586: WSH_DEBUG_SV.log(l_module_name,'vendor_id',p_detail_att.vendor_id);
4587: WSH_DEBUG_SV.log(l_module_name,'party_id',p_detail_att.party_id);
4588: END IF;
4589: wsh_util_core.api_post_call(
4590: p_return_status => l_return_status,
4591: x_num_warnings => l_num_warnings,
4592: x_num_errors => l_num_errors);
4593:

Line 4625: wsh_util_core.api_post_call(

4621: IF l_debug_on THEN
4622: WSH_DEBUG_SV.log(l_module_name,'Unassign_Details l_return_status',l_return_status);
4623: END IF;
4624:
4625: wsh_util_core.api_post_call(
4626: p_return_status => l_return_status,
4627: x_num_warnings => l_num_warnings,
4628: x_num_errors => l_num_errors);
4629: END IF;

Line 4654: wsh_util_core.api_post_call(

4650: IF l_debug_on THEN
4651: WSH_DEBUG_SV.log(l_module_name,'WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history
4652: l_return_status',l_return_status);
4653: END IF;
4654: wsh_util_core.api_post_call(
4655: p_return_status => l_return_status,
4656: x_num_warnings => l_num_warnings,
4657: x_num_errors => l_num_errors);
4658:

Line 4660: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4656: x_num_warnings => l_num_warnings,
4657: x_num_errors => l_num_errors);
4658:
4659: IF l_num_errors > 0 THEN
4660: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4661: ELSIF l_num_warnings > 0 THEN
4662: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4663: END IF;
4664:

Line 4662: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4658:
4659: IF l_num_errors > 0 THEN
4660: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4661: ELSIF l_num_warnings > 0 THEN
4662: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4663: END IF;
4664:
4665: IF l_debug_on THEN
4666: WSH_DEBUG_SV.pop(l_module_name);

Line 4670: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

4666: WSH_DEBUG_SV.pop(l_module_name);
4667: END IF;
4668: EXCEPTION
4669: WHEN FND_API.G_EXC_ERROR THEN
4670: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
4671:
4672: IF l_debug_on THEN
4673: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
4674: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 4683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4679: CLOSE get_revision_number_csr;
4680: END IF;
4681:
4682: WHEN OTHERS THEN
4683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4684:
4685: IF l_debug_on THEN
4686: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
4687: Oracle error message is '||

Line 4743: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4739: WSH_DEBUG_SV.push(l_module_name);
4740: WSH_DEBUG_SV.log(l_module_name,'p_org_name',p_org_name);
4741: END IF;
4742:
4743: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4744:
4745: --Validate operating Unit name against HR_ORGANIZATION_UNITS table.
4746: OPEN get_org_csr(p_org_name);
4747: FETCH get_org_csr INTO x_org_id;

Line 4763: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

4759: WSH_DEBUG_SV.pop(l_module_name);
4760: END IF;
4761: EXCEPTION
4762: WHEN FND_API.G_EXC_ERROR THEN
4763: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
4764:
4765: IF l_debug_on THEN
4766: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
4767: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 4775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4771: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ORG');
4772: fnd_msg_pub.add;
4773:
4774: WHEN OTHERS THEN
4775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4776:
4777: IF l_debug_on THEN
4778: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
4779: Oracle error message is '||

Line 4930: l_del_ids wsh_util_core.id_tab_type;

4926: PRAGMA EXCEPTION_INIT(e_wdd_locked,-54);
4927: --halock
4928:
4929: l_detail_att detail_att_rec_type;
4930: l_del_ids wsh_util_core.id_tab_type;
4931: l_new_detail_ids wsh_util_core.id_tab_type;
4932: l_sum_new_detail_ids wsh_util_core.id_tab_type;
4933:
4934: e_delivery_invalid exception;

Line 4931: l_new_detail_ids wsh_util_core.id_tab_type;

4927: --halock
4928:
4929: l_detail_att detail_att_rec_type;
4930: l_del_ids wsh_util_core.id_tab_type;
4931: l_new_detail_ids wsh_util_core.id_tab_type;
4932: l_sum_new_detail_ids wsh_util_core.id_tab_type;
4933:
4934: e_delivery_invalid exception;
4935: e_ignore_line exception;

Line 4932: l_sum_new_detail_ids wsh_util_core.id_tab_type;

4928:
4929: l_detail_att detail_att_rec_type;
4930: l_del_ids wsh_util_core.id_tab_type;
4931: l_new_detail_ids wsh_util_core.id_tab_type;
4932: l_sum_new_detail_ids wsh_util_core.id_tab_type;
4933:
4934: e_delivery_invalid exception;
4935: e_ignore_line exception;
4936:

Line 4957: l_detail_ids wsh_util_core.id_tab_type;

4953: l_tmp varchar2(2000);
4954: l_header_error number:=0;
4955:
4956: l_po_rec_found boolean:= false;
4957: l_detail_ids wsh_util_core.id_tab_type;
4958: l_new_deliveries wsh_util_core.id_tab_type;
4959: l_total_req_qty number:= 0;
4960: l_total_req_qty2 number:= 0;
4961: l_item_qty number;

Line 4958: l_new_deliveries wsh_util_core.id_tab_type;

4954: l_header_error number:=0;
4955:
4956: l_po_rec_found boolean:= false;
4957: l_detail_ids wsh_util_core.id_tab_type;
4958: l_new_deliveries wsh_util_core.id_tab_type;
4959: l_total_req_qty number:= 0;
4960: l_total_req_qty2 number:= 0;
4961: l_item_qty number;
4962:

Line 4985: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;

4981: WSH_DEBUG_SV.log(l_module_name,'p_delivery.count',p_delivery.ship_from_address1.count);
4982: WSH_DEBUG_SV.log(l_module_name,'p_line.count',p_line.po_header_number.count);
4983: END IF;
4984:
4985: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
4986:
4987: --Error if any one of header,delivery or line record has no data.
4988: IF (p_header.supplier_name.count <> 1 OR p_delivery.ship_from_address1.count < 1 OR p_line.po_header_number.count < 1) THEN
4989: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_FILE_FORMAT');

Line 5023: wsh_util_core.api_post_call(

5019:
5020: IF l_debug_on THEN
5021: WSH_DEBUG_SV.log(l_module_name,'Validate_Header l_return_status',l_return_status);
5022: END IF;
5023: wsh_util_core.api_post_call(
5024: p_return_status => l_return_status,
5025: x_num_warnings => l_num_warnings,
5026: x_num_errors => l_num_errors);
5027:

Line 5076: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5072: WSH_DEBUG_SV.log(l_module_name,'Create_Delivery l_return_status',l_return_status);
5073: WSH_DEBUG_SV.log(l_module_name,'l_new_deliveries.count',l_new_deliveries.count);
5074: END IF;
5075:
5076: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5077: l_del_new_index:=l_new_deliveries.first;
5078: WHILE (l_del_new_index IS NOT NULL) LOOP
5079: IF (p_in_param.caller='ISP') THEN
5080: --If caller ic ISP than do not displayed the delivery name.

Line 5081: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

5077: l_del_new_index:=l_new_deliveries.first;
5078: WHILE (l_del_new_index IS NOT NULL) LOOP
5079: IF (p_in_param.caller='ISP') THEN
5080: --If caller ic ISP than do not displayed the delivery name.
5081: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
5082: l_warn_count:=l_warn_count + 1;
5083: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_WARN');
5084: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);
5085: fnd_msg_pub.add;

Line 5091: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

5087: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_SUCCESS');
5088: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);
5089: END IF;
5090: ELSE
5091: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
5092: l_warn_count:=l_warn_count + 1;
5093: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_WARN');
5094: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));
5095: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);

Line 5104: IF (l_return_status=WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

5100: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);
5101: END IF;
5102: END IF;
5103:
5104: IF (l_return_status=WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5105: l_msg_count:= l_msg_count + 1;
5106: x_success_tbl.extend;
5107: x_success_tbl(l_msg_count):= FND_MESSAGE.GET;
5108: END IF;

Line 5168: wsh_util_core.api_post_call(

5164: IF l_debug_on THEN
5165: WSH_DEBUG_SV.log(l_module_name,'Validate_Delivery l_return_status',l_return_status);
5166: END IF;
5167:
5168: wsh_util_core.api_post_call(
5169: p_return_status => l_return_status,
5170: x_num_warnings => l_num_warnings,
5171: x_num_errors => l_num_errors);
5172:

Line 5198: wsh_util_core.api_post_call(

5194: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Org l_return_status',l_return_status);
5195: WSH_DEBUG_SV.log(l_module_name,'l_org_id',l_detail_att.org_id);
5196: END IF;
5197:
5198: wsh_util_core.api_post_call(
5199: p_return_status => l_return_status,
5200: x_num_warnings => l_num_warnings,
5201: x_num_errors => l_num_errors);
5202:

Line 5263: wsh_util_core.api_post_call(

5259: IF l_debug_on THEN
5260: WSH_DEBUG_SV.log(l_module_name,'Validate_PO l_return_status',l_return_status);
5261: END IF;
5262:
5263: wsh_util_core.api_post_call(
5264: p_return_status => l_return_status,
5265: x_num_warnings => l_num_warnings,
5266: x_num_errors => l_num_errors);
5267:

Line 5362: wsh_util_core.api_post_call(

5358: IF l_debug_on THEN
5359: WSH_DEBUG_SV.log(l_module_name,'Validate_PO l_return_status',l_return_status);
5360: END IF;
5361:
5362: wsh_util_core.api_post_call(
5363: p_return_status => l_return_status,
5364: x_num_warnings => l_num_warnings,
5365: x_num_errors => l_num_errors);
5366:

Line 5391: wsh_util_core.api_post_call(

5387:
5388: IF l_debug_on THEN
5389: WSH_DEBUG_SV.log(l_module_name,'Create_PO l_return_status',l_return_status);
5390: END IF;
5391: wsh_util_core.api_post_call(
5392: p_return_status => l_return_status,
5393: x_num_warnings => l_num_warnings,
5394: x_num_errors => l_num_errors);
5395:

Line 5432: wsh_util_core.api_post_call(

5428: IF l_debug_on THEN
5429: WSH_DEBUG_SV.log(l_module_name,'Validate_Delivery_uom l_return_status',l_return_status);
5430: END IF;
5431:
5432: wsh_util_core.api_post_call(
5433: p_return_status => l_return_status,
5434: x_num_warnings => l_num_warnings,
5435: x_num_errors => l_num_errors);
5436:

Line 5459: wsh_util_core.api_post_call(

5455: IF l_debug_on THEN
5456: WSH_DEBUG_SV.log(l_module_name,'Validate_line l_return_status',l_return_status);
5457: WSH_DEBUG_SV.log(l_module_name,'l_item_qty',l_item_qty);
5458: END IF;
5459: wsh_util_core.api_post_call(
5460: p_return_status => l_return_status,
5461: x_num_warnings => l_num_warnings,
5462: x_num_errors => l_num_errors);
5463:

Line 5491: wsh_util_core.api_post_call(

5487:
5488: IF l_debug_on THEN
5489: WSH_DEBUG_SV.log(l_module_name,'Update_Split_Details l_return_status',l_return_status);
5490: END IF;
5491: wsh_util_core.api_post_call(
5492: p_return_status => l_return_status,
5493: x_num_warnings => l_num_warnings,
5494: x_num_errors => l_num_errors);
5495:

Line 5610: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5606: WSH_DEBUG_SV.log(l_module_name,'Create_Delivery l_return_status',l_return_status);
5607: WSH_DEBUG_SV.log(l_module_name,'l_new_deliveries.count',l_new_deliveries.count);
5608: END IF;
5609:
5610: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5611: l_del_new_index:=l_new_deliveries.first;
5612: WHILE (l_del_new_index IS NOT NULL) LOOP
5613: IF (p_in_param.caller='ISP') THEN
5614: --If caller ic ISP than do not displayed the delivery name.

Line 5615: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

5611: l_del_new_index:=l_new_deliveries.first;
5612: WHILE (l_del_new_index IS NOT NULL) LOOP
5613: IF (p_in_param.caller='ISP') THEN
5614: --If caller ic ISP than do not displayed the delivery name.
5615: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
5616: l_warn_count:=l_warn_count + 1;
5617: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_WARN');
5618: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5619: fnd_msg_pub.add;

Line 5625: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

5621: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_SUCCESS');
5622: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5623: END IF;
5624: ELSE
5625: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
5626: l_warn_count:=l_warn_count + 1;
5627: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_WARN');
5628: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));
5629: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);

Line 5638: IF (l_return_status=WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

5634: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5635: END IF;
5636: END IF;
5637:
5638: IF (l_return_status=WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5639: l_msg_count:= l_msg_count + 1;
5640: x_success_tbl.extend;
5641: x_success_tbl(l_msg_count):= FND_MESSAGE.GET;
5642: END IF;

Line 5712: raise wsh_util_core.g_exc_warning;

5708: IF l_debug_on THEN
5709: WSH_DEBUG_SV.log(l_module_name,'l_warn_count',l_warn_count);
5710: END IF;
5711: IF (l_warn_count > 0 ) THEN
5712: raise wsh_util_core.g_exc_warning;
5713: END IF;
5714:
5715:
5716: IF l_debug_on THEN

Line 5725: raise wsh_util_core.g_exc_warning;

5721: --All header records are error.
5722: raise FND_API.G_EXC_ERROR;
5723: ELSIF (l_header_error < p_header.supplier_name.count and l_header_error > 0 ) THEN
5724: --Error header record is grater than one and less the total header records.
5725: raise wsh_util_core.g_exc_warning;
5726: END IF;
5727:
5728: --If all the deliveries are error than error out.
5729: Is_All_Line_Error(p_error_tbl => p_delivery.error_flag,

Line 5741: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

5737: END IF;
5738:
5739: EXCEPTION
5740: WHEN FND_API.G_EXC_ERROR THEN
5741: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
5742:
5743: IF l_debug_on THEN
5744: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
5745: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 5749: WHEN wsh_util_core.g_exc_warning THEN

5745: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5746: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5747: END IF;
5748:
5749: WHEN wsh_util_core.g_exc_warning THEN
5750: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
5751:
5752: IF l_debug_on THEN
5753: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.g_exc_warning

Line 5750: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;

5746: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5747: END IF;
5748:
5749: WHEN wsh_util_core.g_exc_warning THEN
5750: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
5751:
5752: IF l_debug_on THEN
5753: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.g_exc_warning
5754: exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 5753: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.g_exc_warning

5749: WHEN wsh_util_core.g_exc_warning THEN
5750: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
5751:
5752: IF l_debug_on THEN
5753: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.g_exc_warning
5754: exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5755: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5756: END IF;
5757:

Line 5760: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5756: END IF;
5757:
5758:
5759: WHEN OTHERS THEN
5760: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5761:
5762: IF l_debug_on THEN
5763: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
5764: Oracle error message is '||

Line 5834: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN

5830:
5831: --Bugfix 4070732
5832: l_num_warnings := 0;
5833: l_num_errors := 0;
5834: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
5835: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
5836: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
5837: END IF;
5838:

Line 5835: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;

5831: --Bugfix 4070732
5832: l_num_warnings := 0;
5833: l_num_errors := 0;
5834: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
5835: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
5836: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
5837: END IF;
5838:
5839: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 5836: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;

5832: l_num_warnings := 0;
5833: l_num_errors := 0;
5834: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
5835: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
5836: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
5837: END IF;
5838:
5839: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5840: IF l_debug_on IS NULL THEN

Line 5849: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5845: WSH_DEBUG_SV.push(l_module_name);
5846: WSH_DEBUG_SV.log(l_module_name,'p_file_fields.level_number.count',p_file_fields.level_number.count);
5847: END IF;
5848:
5849: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5850:
5851: --Initialized message and validation meta data.
5852: x_message_tbl := WSH_FILE_MSG_TABLE();
5853: g_error_tbl.delete;

Line 5876: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

5872: x_return_status =>l_return_status);
5873: END IF;
5874:
5875:
5876: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
5877: raise FND_API.G_EXC_ERROR;
5878: END IF;
5879:
5880: WHILE (l_index IS NOT NULL ) LOOP --{

Line 5955: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

5951:
5952: IF l_debug_on THEN
5953: WSH_DEBUG_SV.log(l_module_name,'Process_header l_return_status',l_return_status);
5954: END IF;
5955: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
5956: l_header.error_flag(g_file_line_number):='Y';
5957: END IF;
5958:
5959: ELSIF (p_file_fields.level_number(l_index) = 2 ) THEN

Line 5973: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

5969:
5970: IF l_debug_on THEN
5971: WSH_DEBUG_SV.log(l_module_name,'Process_Delivery l_return_status',l_return_status);
5972: END IF;
5973: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
5974: l_delivery.error_flag(g_file_line_number):='Y';
5975: END IF;
5976:
5977: ELSIF (p_file_fields.level_number(l_index) = 3 ) THEN

Line 5991: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

5987:
5988: IF l_debug_on THEN
5989: WSH_DEBUG_SV.log(l_module_name,'Process_Line l_return_status',l_return_status);
5990: END IF;
5991: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
5992: l_Line.error_flag(g_file_line_number):='Y';
5993: l_delivery.error_flag(p_file_fields.Level_Ref_Number(l_index)):='Y';
5994: END IF;
5995: END IF;

Line 6137: IF (x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

6133: WSH_DEBUG_SV.log(l_module_name,'Is_All_Line_Error for Headers
6134: x_return_status',x_return_status);
6135: END IF;
6136:
6137: IF (x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
6138: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) ) THEN
6139:
6140: --If all the deliveries failed format level validation then error.
6141: Is_All_Line_Error(p_error_tbl => l_delivery.error_flag,

Line 6138: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) ) THEN

6134: x_return_status',x_return_status);
6135: END IF;
6136:
6137: IF (x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
6138: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) ) THEN
6139:
6140: --If all the deliveries failed format level validation then error.
6141: Is_All_Line_Error(p_error_tbl => l_delivery.error_flag,
6142: x_return_status => x_return_status);

Line 6149: IF (x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) ) THEN

6145: WSH_DEBUG_SV.log(l_module_name,'Is_All_Line_Error x_return_status',x_return_status);
6146: END IF;
6147: get_message;
6148:
6149: IF (x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) ) THEN
6150: --Process the Routing Request information.
6151: Process_Routing_request(
6152: p_in_param => p_in_param,
6153: p_header => l_header,

Line 6185: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

6181:
6182: --
6183: -- Start code for Bugfix 4070732
6184: --
6185: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
6186: AND UPPER(WSH_UTIL_CORE.G_START_OF_SESSION_API) = UPPER(l_api_session_name) THEN
6187: --{
6188: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6189: --{

Line 6186: AND UPPER(WSH_UTIL_CORE.G_START_OF_SESSION_API) = UPPER(l_api_session_name) THEN

6182: --
6183: -- Start code for Bugfix 4070732
6184: --
6185: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
6186: AND UPPER(WSH_UTIL_CORE.G_START_OF_SESSION_API) = UPPER(l_api_session_name) THEN
6187: --{
6188: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6189: --{
6190: IF l_debug_on THEN

Line 6188: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

6184: --
6185: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
6186: AND UPPER(WSH_UTIL_CORE.G_START_OF_SESSION_API) = UPPER(l_api_session_name) THEN
6187: --{
6188: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6189: --{
6190: IF l_debug_on THEN
6191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6192: END IF;

Line 6191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

6187: --{
6188: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6189: --{
6190: IF l_debug_on THEN
6191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6192: END IF;
6193:
6194: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
6195: x_return_status => l_return_status);

Line 6194: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

6190: IF l_debug_on THEN
6191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6192: END IF;
6193:
6194: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
6195: x_return_status => l_return_status);
6196:
6197:
6198: IF l_debug_on THEN

Line 6202: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

6198: IF l_debug_on THEN
6199: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
6200: END IF;
6201:
6202: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
6203: x_return_status := l_return_status;
6204: END IF;
6205: --}
6206: END IF;

Line 6208: ELSIF UPPER(WSH_UTIL_CORE.G_START_OF_SESSION_API) = UPPER(l_api_session_name) THEN

6204: END IF;
6205: --}
6206: END IF;
6207: --}
6208: ELSIF UPPER(WSH_UTIL_CORE.G_START_OF_SESSION_API) = UPPER(l_api_session_name) THEN
6209: --{
6210: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6211: --{
6212: l_reset_flags := TRUE;

Line 6210: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

6206: END IF;
6207: --}
6208: ELSIF UPPER(WSH_UTIL_CORE.G_START_OF_SESSION_API) = UPPER(l_api_session_name) THEN
6209: --{
6210: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6211: --{
6212: l_reset_flags := TRUE;
6213:
6214: IF l_debug_on THEN

Line 6215: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

6211: --{
6212: l_reset_flags := TRUE;
6213:
6214: IF l_debug_on THEN
6215: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6216: END IF;
6217:
6218: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
6219: x_return_status => l_return_status);

Line 6218: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,

6214: IF l_debug_on THEN
6215: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6216: END IF;
6217:
6218: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
6219: x_return_status => l_return_status);
6220:
6221: IF l_debug_on THEN
6222: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 6225: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

6221: IF l_debug_on THEN
6222: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
6223: END IF;
6224:
6225: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
6226: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
6227: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
6228: x_return_status := l_return_status;
6229: END IF;

Line 6226: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,

6222: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
6223: END IF;
6224:
6225: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
6226: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
6227: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
6228: x_return_status := l_return_status;
6229: END IF;
6230: --}

Line 6227: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

6223: END IF;
6224:
6225: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
6226: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
6227: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
6228: x_return_status := l_return_status;
6229: END IF;
6230: --}
6231: END IF;

Line 6258: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

6254: END IF;
6255:
6256: EXCEPTION
6257: WHEN FND_API.G_EXC_ERROR THEN
6258: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
6259: --
6260: -- Start code for Bugfix 4070732
6261: --
6262: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

Line 6262: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

6258: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
6259: --
6260: -- Start code for Bugfix 4070732
6261: --
6262: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
6263: --{
6264: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6265: --{
6266: IF l_debug_on THEN

Line 6264: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

6260: -- Start code for Bugfix 4070732
6261: --
6262: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
6263: --{
6264: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6265: --{
6266: IF l_debug_on THEN
6267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6268: END IF;

Line 6267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

6263: --{
6264: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6265: --{
6266: IF l_debug_on THEN
6267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6268: END IF;
6269:
6270: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
6271: x_return_status => l_return_status);

Line 6270: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

6266: IF l_debug_on THEN
6267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6268: END IF;
6269:
6270: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
6271: x_return_status => l_return_status);
6272:
6273:
6274: IF l_debug_on THEN

Line 6278: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

6274: IF l_debug_on THEN
6275: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
6276: END IF;
6277:
6278: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
6279: x_return_status := l_return_status;
6280: END IF;
6281: --}
6282: END IF;

Line 6295: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6291: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6292: END IF;
6293:
6294: WHEN OTHERS THEN
6295: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6296: --
6297: -- Start code for Bugfix 4070732
6298: --
6299: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

Line 6299: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

6295: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6296: --
6297: -- Start code for Bugfix 4070732
6298: --
6299: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
6300: --{
6301: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6302: --{
6303: IF l_debug_on THEN

Line 6301: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

6297: -- Start code for Bugfix 4070732
6298: --
6299: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
6300: --{
6301: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6302: --{
6303: IF l_debug_on THEN
6304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6305: END IF;

Line 6304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

6300: --{
6301: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
6302: --{
6303: IF l_debug_on THEN
6304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6305: END IF;
6306:
6307: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
6308: x_return_status => l_return_status);

Line 6307: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

6303: IF l_debug_on THEN
6304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6305: END IF;
6306:
6307: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
6308: x_return_status => l_return_status);
6309:
6310:
6311: IF l_debug_on THEN

Line 6315: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

6311: IF l_debug_on THEN
6312: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
6313: END IF;
6314:
6315: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
6316: x_return_status := l_return_status;
6317: END IF;
6318: --}
6319: END IF;

Line 6442: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6438: WSH_DEBUG_SV.pop(l_module_name);
6439: END IF;
6440: EXCEPTION
6441: WHEN OTHERS THEN
6442: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6443:
6444: IF l_debug_on THEN
6445: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occurred.
6446: Oracle error message is '||