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 FND_FILE

Line 2206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

2202: WSH_DEBUG_SV.log(l_module_name,'P_COUNT_DETAILS',p_count_details);
2203: WSH_DEBUG_SV.log(l_module_name,'P_COUNT_ContainerS',p_count_containers);
2204: END IF;
2205:
2206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2208: IF p_execution_mode = 'V' THEN
2209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');

Line 2207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

2203: WSH_DEBUG_SV.log(l_module_name,'P_COUNT_ContainerS',p_count_containers);
2204: END IF;
2205:
2206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2208: IF p_execution_mode = 'V' THEN
2209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');
2211: ELSE

Line 2209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');

2205:
2206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2208: IF p_execution_mode = 'V' THEN
2209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');
2211: ELSE
2212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purge');
2213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Purged)');

Line 2210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');

2206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2208: IF p_execution_mode = 'V' THEN
2209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');
2211: ELSE
2212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purge');
2213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Purged)');
2214: END IF;

Line 2212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purge');

2208: IF p_execution_mode = 'V' THEN
2209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');
2211: ELSE
2212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purge');
2213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Purged)');
2214: END IF;
2215: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| SYSDATE ||'');
2216:

Line 2213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Purged)');

2209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');
2211: ELSE
2212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purge');
2213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Purged)');
2214: END IF;
2215: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| SYSDATE ||'');
2216:
2217: IF (p_source_system = 'ALL') THEN

Line 2215: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| SYSDATE ||'');

2211: ELSE
2212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purge');
2213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Purged)');
2214: END IF;
2215: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| SYSDATE ||'');
2216:
2217: IF (p_source_system = 'ALL') THEN
2218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'All');
2219: ELSIF (p_source_system = 'OE') THEN

Line 2218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'All');

2214: END IF;
2215: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| SYSDATE ||'');
2216:
2217: IF (p_source_system = 'ALL') THEN
2218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'All');
2219: ELSIF (p_source_system = 'OE') THEN
2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order Management');
2221: ELSIF (p_source_system = 'PO') THEN
2222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purchasing');

Line 2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order Management');

2216:
2217: IF (p_source_system = 'ALL') THEN
2218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'All');
2219: ELSIF (p_source_system = 'OE') THEN
2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order Management');
2221: ELSIF (p_source_system = 'PO') THEN
2222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purchasing');
2223: ELSIF (p_source_system = 'WSH') THEN
2224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Shipping');

Line 2222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purchasing');

2218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'All');
2219: ELSIF (p_source_system = 'OE') THEN
2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order Management');
2221: ELSIF (p_source_system = 'PO') THEN
2222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purchasing');
2223: ELSIF (p_source_system = 'WSH') THEN
2224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Shipping');
2225: END IF;
2226:

Line 2224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Shipping');

2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order Management');
2221: ELSIF (p_source_system = 'PO') THEN
2222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purchasing');
2223: ELSIF (p_source_system = 'WSH') THEN
2224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Shipping');
2225: END IF;
2226:
2227: IF p_ship_from_org IS NOT NULL THEN
2228: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' ||

Line 2228: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' ||

2224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Shipping');
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, '');

Line 2232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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;
2234:
2235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');

Line 2235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');

2231: ELSE
2232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2233: END IF;
2234:
2235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');

Line 2236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');

2232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2233: END IF;
2234:
2235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');

Line 2237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');

2233: END IF;
2234:
2235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2241:

Line 2238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');

2234:
2235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2241:
2242: IF p_purge_intransit_trips = 'Y' THEN

Line 2239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');

2235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2241:
2242: IF p_purge_intransit_trips = 'Y' THEN
2243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');

Line 2240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');

2236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2241:
2242: IF p_purge_intransit_trips = 'Y' THEN
2243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');
2244: ELSE

Line 2243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');

2239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2241:
2242: IF p_purge_intransit_trips = 'Y' THEN
2243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');
2244: ELSE
2245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2246: END IF;
2247:

Line 2245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');

2241:
2242: IF p_purge_intransit_trips = 'Y' THEN
2243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');
2244: ELSE
2245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2246: END IF;
2247:
2248: IF p_delete_empty_records = 'Y' THEN
2249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');

Line 2249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');

2245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2246: END IF;
2247:
2248: IF p_delete_empty_records = 'Y' THEN
2249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');
2250: ELSE
2251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2252: END IF;
2253:

Line 2251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');

2247:
2248: IF p_delete_empty_records = 'Y' THEN
2249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');
2250: ELSE
2251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2252: END IF;
2253:
2254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');

Line 2254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');

2250: ELSE
2251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2252: END IF;
2253:
2254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2257:
2258: IF p_sort_per_criteria = 'T' THEN

Line 2255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');

2251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2252: END IF;
2253:
2254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2257:
2258: IF p_sort_per_criteria = 'T' THEN
2259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');

Line 2256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');

2252: END IF;
2253:
2254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2257:
2258: IF p_sort_per_criteria = 'T' THEN
2259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');
2260: ELSIF p_sort_per_criteria = 'D' THEN

Line 2259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');

2255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2257:
2258: IF p_sort_per_criteria = 'T' THEN
2259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');
2260: ELSIF p_sort_per_criteria = 'D' THEN
2261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Delivery');
2262: ELSIF p_sort_per_criteria = 'O' THEN
2263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order');

Line 2261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Delivery');

2257:
2258: IF p_sort_per_criteria = 'T' THEN
2259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');
2260: ELSIF p_sort_per_criteria = 'D' THEN
2261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Delivery');
2262: ELSIF p_sort_per_criteria = 'O' THEN
2263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order');
2264: END IF;
2265:

Line 2263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order');

2259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');
2260: ELSIF p_sort_per_criteria = 'D' THEN
2261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Delivery');
2262: ELSIF p_sort_per_criteria = 'O' THEN
2263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order');
2264: END IF;
2265:
2266: IF p_print_detail='L' THEN
2267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail with LPN');

Line 2267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail with LPN');

2263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order');
2264: END IF;
2265:
2266: IF p_print_detail='L' THEN
2267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail with LPN');
2268: ELSIF p_print_detail='D' THEN
2269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail');
2270: ELSIF p_print_detail='S' THEN
2271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Summary');

Line 2269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail');

2265:
2266: IF p_print_detail='L' THEN
2267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail with LPN');
2268: ELSIF p_print_detail='D' THEN
2269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail');
2270: ELSIF p_print_detail='S' THEN
2271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Summary');
2272: END IF;
2273:

Line 2271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Summary');

2267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail with LPN');
2268: ELSIF p_print_detail='D' THEN
2269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail');
2270: ELSIF p_print_detail='S' THEN
2271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Summary');
2272: END IF;
2273:
2274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');

Line 2274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');

2270: ELSIF p_print_detail='S' THEN
2271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Summary');
2272: END IF;
2273:
2274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');

Line 2275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');

2271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Summary');
2272: END IF;
2273:
2274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');
2279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_details || '');

Line 2276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');

2272: END IF;
2273:
2274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');
2279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_details || '');
2280:

Line 2277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');

2273:
2274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');
2279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_details || '');
2280:
2281: IF p_print_detail <> 'S' THEN --check for print detail

Line 2278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');

2274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');
2279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_details || '');
2280:
2281: IF p_print_detail <> 'S' THEN --check for print detail
2282: IF p_tbl_trip_purge_set.COUNT > 0 THEN

Line 2279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_details || '');

2275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');
2279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_details || '');
2280:
2281: IF p_print_detail <> 'S' THEN --check for print detail
2282: IF p_tbl_trip_purge_set.COUNT > 0 THEN
2283: FOR l_trip_index in p_tbl_trip_purge_set.FIRST .. p_tbl_trip_purge_set.LAST

Line 2288: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

2284: LOOP
2285: l_trip_id := p_tbl_trip_purge_set(l_trip_index).trip_id;
2286: l_trip_name := p_tbl_trip_purge_set(l_trip_index).trip_name;
2287: IF (p_tbl_trip_purge_set(l_trip_index).purge_set_type = 'NON_EMPTY') THEN
2288: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2289: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2290: l_nonempty_count := l_nonempty_count +1;
2291: OPEN c_dels_for_trip(l_trip_id);
2292: LOOP

Line 2289: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');

2285: l_trip_id := p_tbl_trip_purge_set(l_trip_index).trip_id;
2286: l_trip_name := p_tbl_trip_purge_set(l_trip_index).trip_name;
2287: IF (p_tbl_trip_purge_set(l_trip_index).purge_set_type = 'NON_EMPTY') THEN
2288: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2289: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2290: l_nonempty_count := l_nonempty_count +1;
2291: OPEN c_dels_for_trip(l_trip_id);
2292: LOOP
2293: FETCH c_dels_for_trip into l_delivery_id,l_delivery_name,l_waybill,l_gross_weight,

Line 2298: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2294: l_ship_to,l_customer_name,l_pickup_date,l_dropoff_date,l_ship_date,l_bol_number ;
2295: EXIT WHEN c_dels_for_trip%NOTFOUND;
2296:
2297: IF p_sort_per_criteria <> 'O' THEN --check for sort by order
2298: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2299: IF P_SORT_PER_CRITERIA = 'T' THEN
2300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2301: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');

Line 2300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');

2296:
2297: IF p_sort_per_criteria <> 'O' THEN --check for sort by order
2298: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2299: IF P_SORT_PER_CRITERIA = 'T' THEN
2300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2301: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');
2303: END IF ;
2304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');

Line 2302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');

2298: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2299: IF P_SORT_PER_CRITERIA = 'T' THEN
2300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2301: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');
2303: END IF ;
2304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');

Line 2304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');

2300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2301: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');
2303: END IF ;
2304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');

Line 2305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');

2301: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');
2303: END IF ;
2304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');

Line 2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');

2302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');
2303: END IF ;
2304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');

2303: END IF ;
2304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');

Line 2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');

2304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');

Line 2309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');

2305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');

Line 2310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2314: END IF;--check for sort by order

Line 2311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');

2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2314: END IF;--check for sort by order
2315:

Line 2312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');

2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2314: END IF;--check for sort by order
2315:
2316: OPEN c_so_for_delivery(l_delivery_id);

Line 2313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');

2309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2314: END IF;--check for sort by order
2315:
2316: OPEN c_so_for_delivery(l_delivery_id);
2317: LOOP

Line 2320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2316: OPEN c_so_for_delivery(l_delivery_id);
2317: LOOP
2318: FETCH c_so_for_delivery into l_sales_order,l_order_type;
2319: EXIT WHEN c_so_for_delivery%NOTFOUND;
2320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_sales_order || '');
2322: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_order_type || '');
2323: IF p_print_detail = 'L' THEN --check whether to print container details
2324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_sales_order || '');

2317: LOOP
2318: FETCH c_so_for_delivery into l_sales_order,l_order_type;
2319: EXIT WHEN c_so_for_delivery%NOTFOUND;
2320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_sales_order || '');
2322: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_order_type || '');
2323: IF p_print_detail = 'L' THEN --check whether to print container details
2324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2325: OPEN c_containers_for_so(l_sales_order);

Line 2322: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_order_type || '');

2318: FETCH c_so_for_delivery into l_sales_order,l_order_type;
2319: EXIT WHEN c_so_for_delivery%NOTFOUND;
2320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_sales_order || '');
2322: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_order_type || '');
2323: IF p_print_detail = 'L' THEN --check whether to print container details
2324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2325: OPEN c_containers_for_so(l_sales_order);
2326: LOOP

Line 2324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_sales_order || '');
2322: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_order_type || '');
2323: IF p_print_detail = 'L' THEN --check whether to print container details
2324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2325: OPEN c_containers_for_so(l_sales_order);
2326: LOOP
2327: l_lpn_count := l_lpn_count+1;
2328: FETCH c_containers_for_so into l_container_id;

Line 2331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_container_id);

2327: l_lpn_count := l_lpn_count+1;
2328: FETCH c_containers_for_so into l_container_id;
2329: EXIT WHEN c_containers_for_so%NOTFOUND;
2330: IF l_lpn_count = 1 THEN
2331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_container_id);
2332: ELSE
2333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ,' || l_container_id);
2334: END IF;
2335: END LOOP;

Line 2333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ,' || l_container_id);

2329: EXIT WHEN c_containers_for_so%NOTFOUND;
2330: IF l_lpn_count = 1 THEN
2331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_container_id);
2332: ELSE
2333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ,' || l_container_id);
2334: END IF;
2335: END LOOP;
2336: CLOSE c_containers_for_so;
2337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ,' || l_container_id);
2334: END IF;
2335: END LOOP;
2336: CLOSE c_containers_for_so;
2337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2338: END IF; -- end check to print container details
2339:
2340: IF p_sort_per_criteria = 'O' THEN --check for sort by order
2341: OPEN c_dels_trips_for_order(l_sales_order);

Line 2347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2343: FETCH c_dels_trips_for_order into l_trip_id,l_trip_name,l_delivery_id,
2344: l_delivery_name,l_waybill,l_gross_weight,l_ship_to,l_customer_name,
2345: l_pickup_date,l_dropoff_date,l_ship_date,l_bol_number ;
2346: EXIT WHEN c_dels_trips_for_order%NOTFOUND;
2347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');

Line 2348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');

2344: l_delivery_name,l_waybill,l_gross_weight,l_ship_to,l_customer_name,
2345: l_pickup_date,l_dropoff_date,l_ship_date,l_bol_number ;
2346: EXIT WHEN c_dels_trips_for_order%NOTFOUND;
2347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');

Line 2349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');

2345: l_pickup_date,l_dropoff_date,l_ship_date,l_bol_number ;
2346: EXIT WHEN c_dels_trips_for_order%NOTFOUND;
2347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');

Line 2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');

2346: EXIT WHEN c_dels_trips_for_order%NOTFOUND;
2347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');

2347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');

Line 2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');

2348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');

Line 2353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');

2349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');

Line 2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');

2351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2359: END LOOP;

Line 2356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');

2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2359: END LOOP;
2360: CLOSE c_dels_trips_for_order;

Line 2357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');

2353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2359: END LOOP;
2360: CLOSE c_dels_trips_for_order;
2361: END IF; --check for sort by order

Line 2358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2359: END LOOP;
2360: CLOSE c_dels_trips_for_order;
2361: END IF; --check for sort by order
2362:

Line 2363: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2359: END LOOP;
2360: CLOSE c_dels_trips_for_order;
2361: END IF; --check for sort by order
2362:
2363: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2364: END LOOP;
2365: CLOSE c_so_for_delivery;
2366: IF p_sort_per_criteria <> 'O' THEN --check for sort by order
2367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2363: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2364: END LOOP;
2365: CLOSE c_so_for_delivery;
2366: IF p_sort_per_criteria <> 'O' THEN --check for sort by order
2367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2368: END IF; --check for sort by order
2369: END LOOP;
2370: CLOSE c_dels_for_trip;
2371: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2371: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2368: END IF; --check for sort by order
2369: END LOOP;
2370: CLOSE c_dels_for_trip;
2371: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2372: END IF;
2373: END LOOP;
2374: END IF; --check for number of records in plsql table
2375:

Line 2378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2374: END IF; --check for number of records in plsql table
2375:
2376: -- print empty trips
2377: IF p_tbl_trip_purge_set.COUNT > 0 THEN --check for number of records in plsql table
2378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2379: FOR l_trip_index in p_tbl_trip_purge_set.FIRST .. p_tbl_trip_purge_set.LAST
2380: LOOP
2381: l_trip_id := p_tbl_trip_purge_set(l_trip_index).trip_id;
2382: l_trip_name := p_tbl_trip_purge_set(l_trip_index).trip_name;

Line 2385: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2381: l_trip_id := p_tbl_trip_purge_set(l_trip_index).trip_id;
2382: l_trip_name := p_tbl_trip_purge_set(l_trip_index).trip_name;
2383: IF (p_tbl_trip_purge_set(l_trip_index).purge_set_type = 'EMPTYTRIPS') THEN
2384: l_empty_trip_count := l_empty_trip_count+1;
2385: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2386: IF P_SORT_PER_CRITERIA = 'T' THEN
2387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_trip_id,10,'0') || '');
2388: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');

Line 2387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_trip_id,10,'0') || '');

2383: IF (p_tbl_trip_purge_set(l_trip_index).purge_set_type = 'EMPTYTRIPS') THEN
2384: l_empty_trip_count := l_empty_trip_count+1;
2385: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2386: IF P_SORT_PER_CRITERIA = 'T' THEN
2387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_trip_id,10,'0') || '');
2388: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2390: END IF ;
2391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');

Line 2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');

2385: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2386: IF P_SORT_PER_CRITERIA = 'T' THEN
2387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_trip_id,10,'0') || '');
2388: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2390: END IF ;
2391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/

Line 2391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');

2387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_trip_id,10,'0') || '');
2388: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2390: END IF ;
2391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2394: IF l_empty_trip_count = 1 THEN
2395: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);

Line 2392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2388: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2390: END IF ;
2391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2394: IF l_empty_trip_count = 1 THEN
2395: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);
2396: ELSE

Line 2393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/

2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2390: END IF ;
2391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2394: IF l_empty_trip_count = 1 THEN
2395: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);
2396: ELSE
2397: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_trip_name);

Line 2395: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);

2391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2394: IF l_empty_trip_count = 1 THEN
2395: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);
2396: ELSE
2397: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_trip_name);
2398: END IF;
2399: END IF;

Line 2397: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_trip_name);

2393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2394: IF l_empty_trip_count = 1 THEN
2395: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);
2396: ELSE
2397: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_trip_name);
2398: END IF;
2399: END IF;
2400: END LOOP;
2401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2397: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_trip_name);
2398: END IF;
2399: END IF;
2400: END LOOP;
2401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2402: END IF; --check for number of records in plsql table
2403:
2404: -- print empty deliveries
2405: IF p_tbl_delivery_purge_set.COUNT > 0 THEN --check for number of records in plsql table

Line 2406: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2402: END IF; --check for number of records in plsql table
2403:
2404: -- print empty deliveries
2405: IF p_tbl_delivery_purge_set.COUNT > 0 THEN --check for number of records in plsql table
2406: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2407: FOR l_delivery_index in p_tbl_delivery_purge_set.FIRST .. p_tbl_delivery_purge_set.LAST
2408: LOOP
2409: l_delivery_id := p_tbl_delivery_purge_set(l_delivery_index).delivery_id;
2410: l_delivery_name := p_tbl_delivery_purge_set(l_delivery_index).delivery_name;

Line 2414: FND_FILE.PUT(FND_FILE.OUTPUT,l_delivery_name);

2410: l_delivery_name := p_tbl_delivery_purge_set(l_delivery_index).delivery_name;
2411: IF (p_tbl_delivery_purge_set(l_delivery_index).purge_set_type = 'EMPTYDELS') THEN
2412: l_empty_del_count := l_empty_del_count+1 ;
2413: IF l_empty_del_count = 1 THEN
2414: FND_FILE.PUT(FND_FILE.OUTPUT,l_delivery_name);
2415: ELSE
2416: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_delivery_name);
2417: END IF;
2418: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2416: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_delivery_name);

2412: l_empty_del_count := l_empty_del_count+1 ;
2413: IF l_empty_del_count = 1 THEN
2414: FND_FILE.PUT(FND_FILE.OUTPUT,l_delivery_name);
2415: ELSE
2416: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_delivery_name);
2417: END IF;
2418: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2419: IF P_SORT_PER_CRITERIA = 'T' THEN
2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');

Line 2418: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2414: FND_FILE.PUT(FND_FILE.OUTPUT,l_delivery_name);
2415: ELSE
2416: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_delivery_name);
2417: END IF;
2418: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2419: IF P_SORT_PER_CRITERIA = 'T' THEN
2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2421: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');

Line 2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');

2416: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_delivery_name);
2417: END IF;
2418: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2419: IF P_SORT_PER_CRITERIA = 'T' THEN
2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2421: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2423: END IF ;
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');

2418: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2419: IF P_SORT_PER_CRITERIA = 'T' THEN
2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2421: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2423: END IF ;
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/

Line 2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2421: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2423: END IF ;
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2427:
2428: END IF;

Line 2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');

2421: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2423: END IF ;
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2427:
2428: END IF;
2429: END LOOP;

Line 2426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/

2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2423: END IF ;
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2427:
2428: END IF;
2429: END LOOP;
2430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2427:
2428: END IF;
2429: END LOOP;
2430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2431: END IF; --check for number of records in plsql table
2432:
2433: -- print empty containers
2434: IF p_tbl_container_purge_set.COUNT > 0 THEN --check for number of records in plsql table

Line 2435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2431: END IF; --check for number of records in plsql table
2432:
2433: -- print empty containers
2434: IF p_tbl_container_purge_set.COUNT > 0 THEN --check for number of records in plsql table
2435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2436: FOR l_container_index in p_tbl_container_purge_set.FIRST .. p_tbl_container_purge_set.LAST
2437: LOOP
2438: l_container_id := p_tbl_container_purge_set(l_container_index).container_id;
2439: IF (p_tbl_container_purge_set(l_container_index).purge_set_type = 'EMPTYLPNS') THEN

Line 2442: FND_FILE.PUT(FND_FILE.OUTPUT,l_container_id);

2438: l_container_id := p_tbl_container_purge_set(l_container_index).container_id;
2439: IF (p_tbl_container_purge_set(l_container_index).purge_set_type = 'EMPTYLPNS') THEN
2440: l_empty_lpn_count := l_empty_lpn_count+1 ;
2441: IF l_empty_lpn_count = 1 THEN
2442: FND_FILE.PUT(FND_FILE.OUTPUT,l_container_id);
2443: ELSE
2444: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_container_id);
2445: END IF;
2446: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2444: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_container_id);

2440: l_empty_lpn_count := l_empty_lpn_count+1 ;
2441: IF l_empty_lpn_count = 1 THEN
2442: FND_FILE.PUT(FND_FILE.OUTPUT,l_container_id);
2443: ELSE
2444: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_container_id);
2445: END IF;
2446: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2447: IF P_SORT_PER_CRITERIA = 'T' THEN
2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');

Line 2446: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2442: FND_FILE.PUT(FND_FILE.OUTPUT,l_container_id);
2443: ELSE
2444: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_container_id);
2445: END IF;
2446: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2447: IF P_SORT_PER_CRITERIA = 'T' THEN
2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2449: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');

Line 2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');

2444: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_container_id);
2445: END IF;
2446: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2447: IF P_SORT_PER_CRITERIA = 'T' THEN
2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2449: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2451: END IF ;
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');

2446: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2447: IF P_SORT_PER_CRITERIA = 'T' THEN
2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2449: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2451: END IF ;
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/

Line 2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2449: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2451: END IF ;
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2455:
2456: END IF;

Line 2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');

2449: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2451: END IF ;
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2455:
2456: END IF;
2457: END LOOP;

Line 2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/

2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2451: END IF ;
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2455:
2456: END IF;
2457: END LOOP;
2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2455:
2456: END IF;
2457: END LOOP;
2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2459: END IF; --check for number of records in plsql table
2460:
2461: END IF; --check for print detail
2462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');

Line 2462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');

2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2459: END IF; --check for number of records in plsql table
2460:
2461: END IF; --check for print detail
2462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');
2463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_trip_count || '');
2464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_del_count || '');
2465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_lpn_count || '');
2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 2463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_trip_count || '');

2459: END IF; --check for number of records in plsql table
2460:
2461: END IF; --check for print detail
2462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');
2463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_trip_count || '');
2464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_del_count || '');
2465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_lpn_count || '');
2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2467:

Line 2464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_del_count || '');

2460:
2461: END IF; --check for print detail
2462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');
2463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_trip_count || '');
2464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_del_count || '');
2465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_lpn_count || '');
2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2467:
2468: IF l_debug_on THEN

Line 2465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_lpn_count || '');

2461: END IF; --check for print detail
2462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');
2463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_trip_count || '');
2464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_del_count || '');
2465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_lpn_count || '');
2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2467:
2468: IF l_debug_on THEN
2469: WSH_DEBUG_SV.pop(l_module_name);

Line 2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

2462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');
2463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_trip_count || '');
2464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_del_count || '');
2465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_lpn_count || '');
2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2467:
2468: IF l_debug_on THEN
2469: WSH_DEBUG_SV.pop(l_module_name);
2470: END IF;