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

Line 102: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

98: BEGIN
99:
100: -- Set for logging
101: IF G_CONC_REQ = FND_API.G_TRUE THEN
102: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
103: END IF;
104:
105: -- Debug Statements
106: --

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

160: IF l_debug_on THEN
161: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
162: END IF;
163:
164: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
165: IF G_CONC_REQ = FND_API.G_TRUE THEN
166: errbuf := 'Error occurred in WSH_PURGE.GET_PURGE_SET';
167: retcode := '2';
168: END IF;

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

206: IF l_debug_on THEN
207: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
208: END IF;
209:
210: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
211: IF G_CONC_REQ = FND_API.G_TRUE THEN
212: errbuf := 'Error occurred in WSH_PURGE.GENERATE_PURGE_REPORT';
213: retcode := '2';
214: END IF;

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

237: IF l_debug_on THEN
238: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
239: END IF;
240:
241: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
242: IF G_CONC_REQ = FND_API.G_TRUE THEN
243: errbuf := 'Error occurred in WSH_PURGE.PURGE_ENTITIES';
244: retcode := '2';
245: END IF;

Line 302: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

298: x_tbl_del_details_purge_set - pl/sql table of delivery detail id's eligible for purge
299: x_tbl_del_legs_purge_set - pl/sql table of delivery leg id's eligible for purge
300: x_tbl_trip_stops_purge_set - pl/sql table of trip stop id's eligible for purge
301: x_tbl_containers_purge_set - pl/sql table of container id's eligible for purge
302: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
303:
304: Description: This API gets all the Shipping Data from the view WSH_PURGE_SET_V
305: and puts it into the plsql tables for respective entities after validating it
306: with the user given parameters

Line 501: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

497: WSH_DEBUG_SV.log(l_module_name,'P_CREATE_DATE_TO',p_create_date_to);
498: WSH_DEBUG_SV.log(l_module_name,'P_DEL_BEYOND_CREATION_DAYS',p_del_beyond_creation_days);
499: END IF;
500:
501: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
502:
503: --construct trip_sql
504: trip_sql := 'SELECT
505: trip_id,trip_name,''NON_EMPTY'' purge_set_type

Line 513: IF (wsh_util_core.fte_is_installed='Y') THEN

509: HAVING count(outer.dd_id) = (SELECT count(inner.dd_id)
510: FROM
511: wsh_purge_set_v inner ';
512: --check whether FTE is installed
513: IF (wsh_util_core.fte_is_installed='Y') THEN
514: trip_sql := trip_sql || ',fte_invoice_headers fih ' ;
515: END IF;
516:
517: trip_sql := trip_sql || '

Line 589: IF (wsh_util_core.fte_is_installed='Y') THEN

585: ''WSH'', ''FALSE'',
586: ''TRUE'') = ''FALSE''
587: ';
588: --check whether FTE is installed
589: IF (wsh_util_core.fte_is_installed='Y') THEN
590: trip_sql := trip_sql ||
591: 'AND fih.bol(+) = inner.bol
592: AND DECODE(fih.bill_status,
593: ''PAID'', ''Y'',

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

721: IF l_debug_on THEN
722: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
723: END IF;
724:
725: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
726: x_return_status := l_return_status;
727: IF l_debug_on THEN
728: WSH_DEBUG_SV.pop(l_module_name);
729: END IF;

Line 856: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

852: END IF;
853:
854: EXCEPTION
855: WHEN OTHERS THEN
856: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
857: IF l_debug_on THEN
858: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
859: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
860: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 875: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

871: p_tbl_del_details_purge_set - pl/sql table of delivery detail id's eligible for purge
872: p_tbl_del_legs_purge_set - pl/sql table of delivery leg id's eligible for purge
873: p_tbl_trip_stops_purge_set - pl/sql table of trip stop id's eligible for purge
874: p_tbl_containers_purge_set pl/sql - table of container id's eligible for purge
875: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
876:
877: Description: This API calls the individual APIs to delete the data in
878: Shipping and Transportation tables
879: =============================================================================

Line 917: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

913: IF l_debug_on THEN
914: WSH_DEBUG_SV.push(l_module_name);
915: END IF;
916:
917: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
918:
919: IF p_tbl_del_details_purge_set.COUNT > 0 THEN
920: IF l_debug_on THEN
921: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PURGE.PURGE_DELIVERY_DETAILS', WSH_DEBUG_SV.C_PROC_LEVEL);

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

927: IF l_debug_on THEN
928: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
929: END IF;
930:
931: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
932: x_return_status := l_return_status;
933: IF l_debug_on THEN
934: WSH_DEBUG_SV.pop(l_module_name);
935: END IF;

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

948: IF l_debug_on THEN
949: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
950: END IF;
951:
952: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
953: x_return_status := l_return_status;
954: IF l_debug_on THEN
955: WSH_DEBUG_SV.pop(l_module_name);
956: END IF;

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

969: IF l_debug_on THEN
970: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
971: END IF;
972:
973: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
974: x_return_status := l_return_status;
975: IF l_debug_on THEN
976: WSH_DEBUG_SV.pop(l_module_name);
977: END IF;

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

990: IF l_debug_on THEN
991: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
992: END IF;
993:
994: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
995: x_return_status := l_return_status;
996: IF l_debug_on THEN
997: WSH_DEBUG_SV.pop(l_module_name);
998: END IF;

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

1009: Purge_Workflow( p_tbl_trip_purge_set => p_tbl_trip_purge_set,
1010: p_tbl_delivery_purge_set=> p_tbl_delivery_purge_set,
1011: x_return_status => l_return_status);
1012:
1013: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1014: x_return_status := l_return_status;
1015: IF l_debug_on THEN
1016: WSH_DEBUG_SV.pop(l_module_name);
1017: END IF;

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

1030: IF l_debug_on THEN
1031: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
1032: END IF;
1033:
1034: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1035: x_return_status := l_return_status;
1036: IF l_debug_on THEN
1037: WSH_DEBUG_SV.pop(l_module_name);
1038: END IF;

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

1051: IF l_debug_on THEN
1052: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
1053: END IF;
1054:
1055: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1056: x_return_status := l_return_status;
1057: IF l_debug_on THEN
1058: WSH_DEBUG_SV.pop(l_module_name);
1059: END IF;

Line 1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1067:
1068:
1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1072: IF l_debug_on THEN
1073: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1074: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1075: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1085: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

1081:
1082: /*-----------------------------------------------------------------------------
1083: Procedure: Purge_Trips
1084: Parameters: p_tbl_trip_purge_set pl/sql table of trip id's eligible for purge
1085: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1086:
1087: Description: This API delete the data in Shipping and Transportation
1088: related to trip
1089: ==============================================================================

Line 1120: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1116: IF l_debug_on THEN
1117: WSH_DEBUG_SV.push(l_module_name);
1118: END IF;
1119:
1120: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1121:
1122: FOR l_loop_index in p_tbl_trip_purge_set.FIRST .. p_tbl_trip_purge_set.LAST
1123: LOOP
1124: l_trip_id := p_tbl_trip_purge_set(l_loop_index).trip_id;

Line 1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1171: END IF;
1172:
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1176: IF l_debug_on THEN
1177: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1178: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1188: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

1184:
1185: /*-----------------------------------------------------------------------------
1186: Procedure: Purge_Deliveries
1187: Parameters: p_tbl_delivery_purge_set pl/sql table of delivery id's eligible for purge
1188: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1189:
1190: Description: This API delete the data in Shipping and Transportation
1191: related to delivery
1192: =============================================================================+

Line 1233: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1229: IF l_debug_on THEN
1230: WSH_DEBUG_SV.push(l_module_name);
1231: END IF;
1232:
1233: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1234:
1235: FOR l_loop_index in p_tbl_delivery_purge_set.FIRST .. p_tbl_delivery_purge_set.LAST
1236: LOOP
1237:

Line 1282: IF (wsh_util_core.fte_is_installed='Y') THEN

1278: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1279: END IF;
1280: END IF;
1281:
1282: IF (wsh_util_core.fte_is_installed='Y') THEN
1283:
1284: DELETE
1285: FROM fte_shipment_status_details
1286: WHERE transaction_id IN (SELECT transaction_id

Line 1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1447: END IF;
1448:
1449: EXCEPTION
1450: WHEN OTHERS THEN
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1452: IF l_debug_on THEN
1453: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1454: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1455: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1465: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

1461: /*-----------------------------------------------------------------------------
1462: Procedure: Purge_Trip_Stops
1463: Parameters: p_tbl_trip_stop_purge_set pl/sql table of trip stop id's
1464: eligible for purge
1465: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1466:
1467: Description: This API delete the data in Shipping and Transportation
1468: related to trip stop
1469: ==============================================================================

Line 1499: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1495: IF l_debug_on THEN
1496: WSH_DEBUG_SV.push(l_module_name);
1497: END IF;
1498:
1499: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1500:
1501: FOR l_loop_index in p_tbl_trip_stop_purge_set.FIRST .. p_tbl_trip_stop_purge_set.LAST
1502: LOOP
1503: l_stop_id := p_tbl_trip_stop_purge_set(l_loop_index).stop_id;

Line 1543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1539: END IF;
1540:
1541: EXCEPTION
1542: WHEN OTHERS THEN
1543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1544: IF l_debug_on THEN
1545: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1546: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1547: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1556: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

1552:
1553: /*-----------------------------------------------------------------------------
1554: Procedure: Purge_Delivery_Legs
1555: Parameters: p_tbl_del_leg_purge_set pl/sql table of delivery leg id's eligible for purge
1556: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1557:
1558: Description: This API delete the data in Shipping and Transportation
1559: related to delivery leg
1560: ==============================================================================

Line 1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1590: IF l_debug_on THEN
1591: WSH_DEBUG_SV.push(l_module_name);
1592: END IF;
1593:
1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1595:
1596: FOR l_loop_index in p_tbl_del_leg_purge_set.FIRST .. p_tbl_del_leg_purge_set.LAST
1597: LOOP
1598: l_leg_id := p_tbl_del_leg_purge_set(l_loop_index).delivery_leg_id;

Line 1610: IF (wsh_util_core.fte_is_installed='Y') THEN

1606: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1607: END IF;
1608: END IF;
1609:
1610: IF (wsh_util_core.fte_is_installed='Y') THEN
1611:
1612: DELETE
1613: FROM fte_invoice_lines
1614: WHERE invoice_header_id IN ( SELECT fih.invoice_header_id

Line 1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

Line 1731: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

1727: /*-----------------------------------------------------------------------------
1728: Procedure: Purge_Delivery_Details
1729: Parameters: p_tbl_del_detail_purge_set pl/sql table of delivery detail id's
1730: eligible for purge
1731: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1732:
1733: Description: This API delete the data in Shipping and Transportation
1734: related to delivery detail
1735: =============================================================================

Line 1764: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1760: IF l_debug_on THEN
1761: WSH_DEBUG_SV.push(l_module_name);
1762: END IF;
1763:
1764: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1765:
1766: FOR l_loop_index in p_tbl_del_detail_purge_set.FIRST .. p_tbl_del_detail_purge_set.LAST
1767: LOOP
1768: l_detail_id := p_tbl_del_detail_purge_set(l_loop_index).delivery_detail_id;

Line 1827: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1823: END IF;
1824:
1825: EXCEPTION
1826: WHEN OTHERS THEN
1827: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1828: IF l_debug_on THEN
1829: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1830: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1831: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1840: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

1836:
1837: /*-----------------------------------------------------------------------------
1838: Procedure: Purge_Containers
1839: Parameters: p_tbl_containers_purge_set pl/sql table of container id's eligible for purge
1840: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1841:
1842: Description: This API calls the WMS API to delete the data in WMS
1843: related to Containers
1844: ==============================================================================

Line 1879: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1875: IF l_debug_on THEN
1876: WSH_DEBUG_SV.push(l_module_name);
1877: END IF;
1878:
1879: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1880:
1881: FOR l_loop_index in p_tbl_containers_purge_set.FIRST .. p_tbl_containers_purge_set.LAST
1882: LOOP
1883: l_container_id := p_tbl_containers_purge_set(l_loop_index).container_id;

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

1949: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
1950: WSH_DEBUG_SV.log(l_module_name,'L_MSG_DATA',l_msg_data);
1951: END IF;
1952:
1953: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1954: x_return_status := l_return_status;
1955: IF l_debug_on THEN
1956: WSH_DEBUG_SV.pop(l_module_name);
1957: END IF;

Line 1967: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

Line 2019: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

2015: -- p_count_legs count of delivery legs to be purged/eligible to be purged
2016: -- p_count_stops count of trip stops to be purged/eligible to be purged
2017: -- p_count_details count of delivery details to be purged/eligible to be purged
2018: -- p_count_containers count of containers to be purged/eligible to be purged
2019: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
2020:
2021: -- Description: This API generates the XML and writes it in output file
2022: -- of the concurrent program to be used by the XML Publisher
2023: -- to generate the XML report

Line 2175: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2171: IF l_debug_on THEN
2172: WSH_DEBUG_SV.push(l_module_name);
2173: END IF;
2174:
2175: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2176:
2177: l_nonempty_count := 0;
2178: l_lpn_count := 0;
2179: l_empty_trip_count := 0;

Line 2229: WSH_UTIL_CORE.GET_ORG_NAME(p_organization_id => to_number(p_ship_from_org)) ||

2225: END IF;
2226:
2227: IF p_ship_from_org IS NOT NULL THEN
2228: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' ||
2229: WSH_UTIL_CORE.GET_ORG_NAME(p_organization_id => to_number(p_ship_from_org)) ||
2230: '');
2231: ELSE
2232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2233: END IF;

Line 2474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2470: END IF;
2471:
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2475: l_err := SQLERRM;
2476:
2477: IF l_debug_on THEN
2478: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 2491: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

2487: --
2488: -- Procedure: Purge_Workflow
2489: -- Parameters: p_tbl_trip_purge_set pl/sql table of trip id's eligible for purge
2490: -- p_tbl_delivery_purge_set pl/sql table of delivery id's eligible for purge
2491: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
2492:
2493: -- Description: This API deletes the workflows for Trip and Delivery.
2494: -----------------------------------------------------------------------------
2495:

Line 2503: l_delivery_ids_tab WSH_UTIL_CORE.column_tab_type;

2499:
2500: l_debug_on BOOLEAN;
2501: l_return_status VARCHAR2(1);
2502:
2503: l_delivery_ids_tab WSH_UTIL_CORE.column_tab_type;
2504: l_trip_ids_tab WSH_UTIL_CORE.column_tab_type;
2505:
2506: l_success_count NUMBER;
2507:

Line 2504: l_trip_ids_tab WSH_UTIL_CORE.column_tab_type;

2500: l_debug_on BOOLEAN;
2501: l_return_status VARCHAR2(1);
2502:
2503: l_delivery_ids_tab WSH_UTIL_CORE.column_tab_type;
2504: l_trip_ids_tab WSH_UTIL_CORE.column_tab_type;
2505:
2506: l_success_count NUMBER;
2507:
2508: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PURGE_WORKFLOW';

Line 2524: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2520: IF l_debug_on THEN
2521: WSH_DEBUG_SV.push(l_module_name);
2522: END IF;
2523:
2524: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2525:
2526: --Check for number of ids in delivery table
2527: IF p_tbl_delivery_purge_set.COUNT > 0 THEN
2528: FOR l_delivery_index in p_tbl_delivery_purge_set.FIRST .. p_tbl_delivery_purge_set.LAST

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

2547: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
2548: WSH_DEBUG_SV.log(l_module_name,'L_SUCCESS_COUNT',l_success_count);
2549: END IF;
2550:
2551: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2552: x_return_status := l_return_status;
2553: IF l_debug_on THEN
2554: WSH_DEBUG_SV.pop(l_module_name);
2555: END IF;

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

2580: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
2581: WSH_DEBUG_SV.log(l_module_name,'L_SUCCESS_COUNT',l_success_count);
2582: END IF;
2583:
2584: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2585: x_return_status := l_return_status;
2586: IF l_debug_on THEN
2587: WSH_DEBUG_SV.pop(l_module_name);
2588: END IF;

Line 2606: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

2602: -- Procedure: Validate_Trips
2603: -- Parameters: p_tbl_trip_purge_set pl/sql table of trip id's eligible for purge
2604: -- x_tbl_trip_purge_set pl/sql table of trip id's eligible for purge
2605: -- after validating all the LPNs belonging to the trip with WMS API
2606: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
2607:
2608: -- Description: This API call the WMS_Container_Grp API for checking the validity of
2609: -- each LPN belonging to a particular trip.
2610: -- The WMS LPN Purge API returns the list of LPN Ids that are eligible to

Line 2665: l_tbl_trip_mdc WSH_UTIL_CORE.ID_TAB_TYPE;

2661: TYPE PurgeCurType IS REF CURSOR;
2662: c_trip_moves PurgeCurType; --The cursor gets all the moves their trips
2663: --wherever the move has more than 1 trip
2664: l_tbl_trip_moves Trip_moves_Tbl_Type;
2665: l_tbl_trip_mdc WSH_UTIL_CORE.ID_TAB_TYPE;
2666:
2667: CURSOR c_lpns_for_trip(p_tripid NUMBER) IS
2668: SELECT wdd.lpn_id
2669: FROM wsh_trips wt,

Line 2778: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2774: IF l_debug_on THEN
2775: WSH_DEBUG_SV.push(l_module_name);
2776: END IF;
2777:
2778: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2779: l_lpn_valid := TRUE;
2780:
2781: IF (wsh_util_core.fte_is_installed='Y') THEN
2782: sql_tripmove := 'SELECT move_id, trip_id

Line 2781: IF (wsh_util_core.fte_is_installed='Y') THEN

2777:
2778: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2779: l_lpn_valid := TRUE;
2780:
2781: IF (wsh_util_core.fte_is_installed='Y') THEN
2782: sql_tripmove := 'SELECT move_id, trip_id
2783: FROM fte_trip_moves
2784: WHERE move_id IN
2785: (SELECT move_id

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

2824: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
2825: WSH_DEBUG_SV.log(l_module_name,'L_MSG_DATA',l_msg_data);
2826: END IF;
2827:
2828: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2829: x_return_status := l_return_status;
2830: IF l_debug_on THEN
2831: WSH_DEBUG_SV.pop(l_module_name);
2832: END IF;

Line 2919: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2915: END IF;
2916:
2917: EXCEPTION
2918: WHEN OTHERS THEN
2919: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2920: l_err := SQLERRM;
2921:
2922: IF l_debug_on THEN
2923: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||