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

2328: WSH_DEBUG_SV.log(l_module_name,'P_COUNT_DETAILS',p_count_details);
2329: WSH_DEBUG_SV.log(l_module_name,'P_COUNT_ContainerS',p_count_containers);
2330: END IF;
2331:
2332: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2333: --bug 12605679: Added encoding to UTF-8
2334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2335: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2336: IF p_execution_mode = 'V' THEN

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

2330: END IF;
2331:
2332: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2333: --bug 12605679: Added encoding to UTF-8
2334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2335: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2336: IF p_execution_mode = 'V' THEN
2337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');

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

2331:
2332: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2333: --bug 12605679: Added encoding to UTF-8
2334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2335: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2336: IF p_execution_mode = 'V' THEN
2337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');
2339: ELSE

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

2333: --bug 12605679: Added encoding to UTF-8
2334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2335: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2336: IF p_execution_mode = 'V' THEN
2337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');
2339: ELSE
2340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purge');
2341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Purged)');

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

2334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2335: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2336: IF p_execution_mode = 'V' THEN
2337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');
2339: ELSE
2340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purge');
2341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Purged)');
2342: END IF;

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

2336: IF p_execution_mode = 'V' THEN
2337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');
2339: ELSE
2340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purge');
2341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Purged)');
2342: END IF;
2343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| SYSDATE ||'');
2344:

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

2337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'View Purge Selection');
2338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Eligible to Purge');
2339: ELSE
2340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purge');
2341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Purged)');
2342: END IF;
2343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| SYSDATE ||'');
2344:
2345: --RTV changes

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

2339: ELSE
2340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purge');
2341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Purged)');
2342: END IF;
2343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| SYSDATE ||'');
2344:
2345: --RTV changes
2346: /*
2347: IF (p_source_system = 'ALL') THEN

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

2344:
2345: --RTV changes
2346: /*
2347: IF (p_source_system = 'ALL') THEN
2348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'All');
2349: ELSIF (p_source_system = 'OE') THEN
2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order Management');
2351: ELSIF (p_source_system = 'PO') THEN
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purchasing');

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

2346: /*
2347: IF (p_source_system = 'ALL') THEN
2348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'All');
2349: ELSIF (p_source_system = 'OE') THEN
2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order Management');
2351: ELSIF (p_source_system = 'PO') THEN
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purchasing');
2353: ELSIF (p_source_system = 'WSH') THEN
2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Shipping');

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

2348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'All');
2349: ELSIF (p_source_system = 'OE') THEN
2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order Management');
2351: ELSIF (p_source_system = 'PO') THEN
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purchasing');
2353: ELSIF (p_source_system = 'WSH') THEN
2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Shipping');
2355: END IF;
2356: */

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

2350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order Management');
2351: ELSIF (p_source_system = 'PO') THEN
2352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Purchasing');
2353: ELSIF (p_source_system = 'WSH') THEN
2354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Shipping');
2355: END IF;
2356: */
2357:
2358: SELECT meaning

Line 2369: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||l_src_meaning||'');

2365: AND Trunc(SYSDATE) BETWEEN Nvl(start_date_active, Trunc(SYSDATE)) AND Nvl
2366: (
2367: end_date_active, Trunc(SYSDATE))
2368: AND ROWNUM < 2;
2369: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||l_src_meaning||'');
2370: --RTV changes
2371:
2372:
2373: IF p_ship_from_org IS NOT NULL THEN

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

2370: --RTV changes
2371:
2372:
2373: IF p_ship_from_org IS NOT NULL THEN
2374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' ||
2375: WSH_UTIL_CORE.GET_ORG_NAME(p_organization_id => to_number(p_ship_from_org)) ||
2376: '');
2377: ELSE
2378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

2374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' ||
2375: WSH_UTIL_CORE.GET_ORG_NAME(p_organization_id => to_number(p_ship_from_org)) ||
2376: '');
2377: ELSE
2378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2379: END IF;
2380:
2381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');

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

2377: ELSE
2378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2379: END IF;
2380:
2381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');

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

2378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2379: END IF;
2380:
2381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');

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

2379: END IF;
2380:
2381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2387:

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

2380:
2381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2387:
2388: IF p_purge_intransit_trips = 'Y' THEN

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

2381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2387:
2388: IF p_purge_intransit_trips = 'Y' THEN
2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');

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

2382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2387:
2388: IF p_purge_intransit_trips = 'Y' THEN
2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');
2390: ELSE

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

2385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2387:
2388: IF p_purge_intransit_trips = 'Y' THEN
2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');
2390: ELSE
2391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2392: END IF;
2393:

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

2387:
2388: IF p_purge_intransit_trips = 'Y' THEN
2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');
2390: ELSE
2391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2392: END IF;
2393:
2394: IF p_delete_empty_records = 'Y' THEN
2395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');

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

2391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2392: END IF;
2393:
2394: IF p_delete_empty_records = 'Y' THEN
2395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');
2396: ELSE
2397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2398: END IF;
2399:

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

2393:
2394: IF p_delete_empty_records = 'Y' THEN
2395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');
2396: ELSE
2397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2398: END IF;
2399:
2400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');

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

2396: ELSE
2397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2398: END IF;
2399:
2400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2403:
2404: IF p_sort_per_criteria = 'T' THEN

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

2397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2398: END IF;
2399:
2400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2403:
2404: IF p_sort_per_criteria = 'T' THEN
2405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');

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

2398: END IF;
2399:
2400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2403:
2404: IF p_sort_per_criteria = 'T' THEN
2405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');
2406: ELSIF p_sort_per_criteria = 'D' THEN

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

2401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2403:
2404: IF p_sort_per_criteria = 'T' THEN
2405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');
2406: ELSIF p_sort_per_criteria = 'D' THEN
2407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Delivery');
2408: ELSIF p_sort_per_criteria = 'O' THEN
2409: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order');

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

2403:
2404: IF p_sort_per_criteria = 'T' THEN
2405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');
2406: ELSIF p_sort_per_criteria = 'D' THEN
2407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Delivery');
2408: ELSIF p_sort_per_criteria = 'O' THEN
2409: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order');
2410: END IF;
2411:

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

2405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');
2406: ELSIF p_sort_per_criteria = 'D' THEN
2407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Delivery');
2408: ELSIF p_sort_per_criteria = 'O' THEN
2409: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order');
2410: END IF;
2411:
2412: IF p_print_detail='L' THEN
2413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail with LPN');

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

2409: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Order');
2410: END IF;
2411:
2412: IF p_print_detail='L' THEN
2413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail with LPN');
2414: ELSIF p_print_detail='D' THEN
2415: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail');
2416: ELSIF p_print_detail='S' THEN
2417: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Summary');

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

2411:
2412: IF p_print_detail='L' THEN
2413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail with LPN');
2414: ELSIF p_print_detail='D' THEN
2415: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail');
2416: ELSIF p_print_detail='S' THEN
2417: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Summary');
2418: END IF;
2419:

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

2413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail with LPN');
2414: ELSIF p_print_detail='D' THEN
2415: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Detail');
2416: ELSIF p_print_detail='S' THEN
2417: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Summary');
2418: END IF;
2419:
2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');

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

2416: ELSIF p_print_detail='S' THEN
2417: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Summary');
2418: END IF;
2419:
2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2423: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');

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

2417: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Summary');
2418: END IF;
2419:
2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2423: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_details || '');

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

2418: END IF;
2419:
2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2423: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_details || '');
2426:

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

2419:
2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2423: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_details || '');
2426:
2427: IF p_print_detail <> 'S' THEN --check for print detail

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

2420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_GLOBAL.USER_NAME ||'');
2421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2423: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_details || '');
2426:
2427: IF p_print_detail <> 'S' THEN --check for print detail
2428: IF p_tbl_trip_purge_set.COUNT > 0 THEN

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

2421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||FND_GLOBAL.CONC_REQUEST_ID ||'');
2422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_trip_purge_set.COUNT || '');
2423: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_stops || '');
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_tbl_delivery_purge_set.COUNT || '');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_count_details || '');
2426:
2427: IF p_print_detail <> 'S' THEN --check for print detail
2428: IF p_tbl_trip_purge_set.COUNT > 0 THEN
2429: FOR l_trip_index in p_tbl_trip_purge_set.FIRST .. p_tbl_trip_purge_set.LAST

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

2430: LOOP
2431: l_trip_id := p_tbl_trip_purge_set(l_trip_index).trip_id;
2432: l_trip_name := p_tbl_trip_purge_set(l_trip_index).trip_name;
2433: IF (p_tbl_trip_purge_set(l_trip_index).purge_set_type = 'NON_EMPTY') THEN
2434: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2435: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2436: l_nonempty_count := l_nonempty_count +1;
2437: OPEN c_dels_for_trip(l_trip_id);
2438: LOOP

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

2431: l_trip_id := p_tbl_trip_purge_set(l_trip_index).trip_id;
2432: l_trip_name := p_tbl_trip_purge_set(l_trip_index).trip_name;
2433: IF (p_tbl_trip_purge_set(l_trip_index).purge_set_type = 'NON_EMPTY') THEN
2434: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2435: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2436: l_nonempty_count := l_nonempty_count +1;
2437: OPEN c_dels_for_trip(l_trip_id);
2438: LOOP
2439: FETCH c_dels_for_trip into l_delivery_id,l_delivery_name,l_waybill,l_gross_weight,

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

2440: l_ship_to,l_customer_name,l_pickup_date,l_dropoff_date,l_ship_date,l_bol_number ;
2441: EXIT WHEN c_dels_for_trip%NOTFOUND;
2442:
2443: IF p_sort_per_criteria <> 'O' THEN --check for sort by order
2444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2445: IF P_SORT_PER_CRITERIA = 'T' THEN
2446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2447: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');

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

2442:
2443: IF p_sort_per_criteria <> 'O' THEN --check for sort by order
2444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2445: IF P_SORT_PER_CRITERIA = 'T' THEN
2446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2447: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');
2449: END IF ;
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');

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

2444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2445: IF P_SORT_PER_CRITERIA = 'T' THEN
2446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2447: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');
2449: END IF ;
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');

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

2446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2447: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');
2449: END IF ;
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');

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

2447: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');
2449: END IF ;
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');

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

2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_delivery_name || '');
2449: END IF ;
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

2449: END IF ;
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');

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

2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');

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

2451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');

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

2452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2460: END IF;--check for sort by order

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

2453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2460: END IF;--check for sort by order
2461:

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

2454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2460: END IF;--check for sort by order
2461:
2462: OPEN c_so_for_delivery(l_delivery_id);

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

2455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2460: END IF;--check for sort by order
2461:
2462: OPEN c_so_for_delivery(l_delivery_id);
2463: LOOP

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

2462: OPEN c_so_for_delivery(l_delivery_id);
2463: LOOP
2464: FETCH c_so_for_delivery into l_sales_order,l_order_type;
2465: EXIT WHEN c_so_for_delivery%NOTFOUND;
2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_sales_order || '');
2468: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_order_type || '');
2469: IF p_print_detail = 'L' THEN --check whether to print container details
2470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

2463: LOOP
2464: FETCH c_so_for_delivery into l_sales_order,l_order_type;
2465: EXIT WHEN c_so_for_delivery%NOTFOUND;
2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_sales_order || '');
2468: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_order_type || '');
2469: IF p_print_detail = 'L' THEN --check whether to print container details
2470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2471: OPEN c_containers_for_so(l_sales_order);

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

2464: FETCH c_so_for_delivery into l_sales_order,l_order_type;
2465: EXIT WHEN c_so_for_delivery%NOTFOUND;
2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_sales_order || '');
2468: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_order_type || '');
2469: IF p_print_detail = 'L' THEN --check whether to print container details
2470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2471: OPEN c_containers_for_so(l_sales_order);
2472: LOOP

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

2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_sales_order || '');
2468: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_order_type || '');
2469: IF p_print_detail = 'L' THEN --check whether to print container details
2470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2471: OPEN c_containers_for_so(l_sales_order);
2472: LOOP
2473: l_lpn_count := l_lpn_count+1;
2474: FETCH c_containers_for_so into l_container_id;

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

2473: l_lpn_count := l_lpn_count+1;
2474: FETCH c_containers_for_so into l_container_id;
2475: EXIT WHEN c_containers_for_so%NOTFOUND;
2476: IF l_lpn_count = 1 THEN
2477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_container_id);
2478: ELSE
2479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ,' || l_container_id);
2480: END IF;
2481: END LOOP;

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

2475: EXIT WHEN c_containers_for_so%NOTFOUND;
2476: IF l_lpn_count = 1 THEN
2477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_container_id);
2478: ELSE
2479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ,' || l_container_id);
2480: END IF;
2481: END LOOP;
2482: CLOSE c_containers_for_so;
2483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

2479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ,' || l_container_id);
2480: END IF;
2481: END LOOP;
2482: CLOSE c_containers_for_so;
2483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2484: END IF; -- end check to print container details
2485:
2486: IF p_sort_per_criteria = 'O' THEN --check for sort by order
2487: OPEN c_dels_trips_for_order(l_sales_order);

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

2489: FETCH c_dels_trips_for_order into l_trip_id,l_trip_name,l_delivery_id,
2490: l_delivery_name,l_waybill,l_gross_weight,l_ship_to,l_customer_name,
2491: l_pickup_date,l_dropoff_date,l_ship_date,l_bol_number ;
2492: EXIT WHEN c_dels_trips_for_order%NOTFOUND;
2493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2496: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2497: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');

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

2490: l_delivery_name,l_waybill,l_gross_weight,l_ship_to,l_customer_name,
2491: l_pickup_date,l_dropoff_date,l_ship_date,l_bol_number ;
2492: EXIT WHEN c_dels_trips_for_order%NOTFOUND;
2493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2496: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2497: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');

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

2491: l_pickup_date,l_dropoff_date,l_ship_date,l_bol_number ;
2492: EXIT WHEN c_dels_trips_for_order%NOTFOUND;
2493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2496: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2497: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');

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

2492: EXIT WHEN c_dels_trips_for_order%NOTFOUND;
2493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2496: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2497: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

2493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2496: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2497: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');

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

2494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_name || '');
2495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2496: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2497: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');

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

2495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_name || '');
2496: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2497: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');

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

2496: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_waybill || '');
2497: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

2497: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_bol_number || '');
2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2505: END LOOP;

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

2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_gross_weight || '');
2499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2505: END LOOP;
2506: CLOSE c_dels_trips_for_order;

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

2499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_to || '');
2500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2505: END LOOP;
2506: CLOSE c_dels_trips_for_order;
2507: END IF; --check for sort by order

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

2500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_pickup_date || '');
2502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_dropoff_date || '');
2503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_ship_date || '');
2504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2505: END LOOP;
2506: CLOSE c_dels_trips_for_order;
2507: END IF; --check for sort by order
2508:

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

2505: END LOOP;
2506: CLOSE c_dels_trips_for_order;
2507: END IF; --check for sort by order
2508:
2509: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2510: END LOOP;
2511: CLOSE c_so_for_delivery;
2512: IF p_sort_per_criteria <> 'O' THEN --check for sort by order
2513: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

2509: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2510: END LOOP;
2511: CLOSE c_so_for_delivery;
2512: IF p_sort_per_criteria <> 'O' THEN --check for sort by order
2513: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2514: END IF; --check for sort by order
2515: END LOOP;
2516: CLOSE c_dels_for_trip;
2517: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

2513: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2514: END IF; --check for sort by order
2515: END LOOP;
2516: CLOSE c_dels_for_trip;
2517: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2518: END IF;
2519: END LOOP;
2520: END IF; --check for number of records in plsql table
2521:

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

2520: END IF; --check for number of records in plsql table
2521:
2522: -- print empty trips
2523: IF p_tbl_trip_purge_set.COUNT > 0 THEN --check for number of records in plsql table
2524: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2525: l_buff_size := 0 ; -- Reset the buffer size to zero
2526: FOR l_trip_index in p_tbl_trip_purge_set.FIRST .. p_tbl_trip_purge_set.LAST
2527: LOOP
2528: l_trip_id := p_tbl_trip_purge_set(l_trip_index).trip_id;

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

2528: l_trip_id := p_tbl_trip_purge_set(l_trip_index).trip_id;
2529: l_trip_name := p_tbl_trip_purge_set(l_trip_index).trip_name;
2530: IF (p_tbl_trip_purge_set(l_trip_index).purge_set_type = 'EMPTYTRIPS') THEN
2531: l_empty_trip_count := l_empty_trip_count+1;
2532: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2533: IF P_SORT_PER_CRITERIA = 'T' THEN
2534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_trip_id,10,'0') || '');
2535: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');

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

2530: IF (p_tbl_trip_purge_set(l_trip_index).purge_set_type = 'EMPTYTRIPS') THEN
2531: l_empty_trip_count := l_empty_trip_count+1;
2532: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2533: IF P_SORT_PER_CRITERIA = 'T' THEN
2534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_trip_id,10,'0') || '');
2535: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2537: END IF ;
2538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');

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

2532: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2533: IF P_SORT_PER_CRITERIA = 'T' THEN
2534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_trip_id,10,'0') || '');
2535: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2537: END IF ;
2538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/

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

2534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_trip_id,10,'0') || '');
2535: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2537: END IF ;
2538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2541:
2542: --Bug 8204644

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

2535: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2537: END IF ;
2538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2541:
2542: --Bug 8204644
2543: IF ( l_buff_size = 0 AND l_empty_trip_count=1 ) THEN

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

2536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2537: END IF ;
2538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_trip_id || '');
2539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2541:
2542: --Bug 8204644
2543: IF ( l_buff_size = 0 AND l_empty_trip_count=1 ) THEN
2544: l_buff_size := lengthb(l_trip_name);

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

2541:
2542: --Bug 8204644
2543: IF ( l_buff_size = 0 AND l_empty_trip_count=1 ) THEN
2544: l_buff_size := lengthb(l_trip_name);
2545: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);
2546: ELSIF ( l_buff_size = 0 AND l_empty_trip_count<>1 ) THEN
2547: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,',');
2548: l_buff_size := lengthb(l_trip_name);
2549: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);

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

2543: IF ( l_buff_size = 0 AND l_empty_trip_count=1 ) THEN
2544: l_buff_size := lengthb(l_trip_name);
2545: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);
2546: ELSIF ( l_buff_size = 0 AND l_empty_trip_count<>1 ) THEN
2547: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,',');
2548: l_buff_size := lengthb(l_trip_name);
2549: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);
2550: ELSIF l_buff_size < 30000 THEN
2551: l_buff_size := l_buff_size + lengthb(l_trip_name) + 2;

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

2545: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);
2546: ELSIF ( l_buff_size = 0 AND l_empty_trip_count<>1 ) THEN
2547: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,',');
2548: l_buff_size := lengthb(l_trip_name);
2549: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);
2550: ELSIF l_buff_size < 30000 THEN
2551: l_buff_size := l_buff_size + lengthb(l_trip_name) + 2;
2552: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_trip_name);
2553: ELSIF l_buff_size >= 30000 THEN

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

2548: l_buff_size := lengthb(l_trip_name);
2549: FND_FILE.PUT(FND_FILE.OUTPUT,l_trip_name);
2550: ELSIF l_buff_size < 30000 THEN
2551: l_buff_size := l_buff_size + lengthb(l_trip_name) + 2;
2552: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_trip_name);
2553: ELSIF l_buff_size >= 30000 THEN
2554: l_buff_size := 0;
2555: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_trip_name );
2556: END IF;

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

2551: l_buff_size := l_buff_size + lengthb(l_trip_name) + 2;
2552: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_trip_name);
2553: ELSIF l_buff_size >= 30000 THEN
2554: l_buff_size := 0;
2555: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_trip_name );
2556: END IF;
2557: --Bug 8204644
2558: END IF;
2559: END LOOP;

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

2556: END IF;
2557: --Bug 8204644
2558: END IF;
2559: END LOOP;
2560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2561: END IF; --check for number of records in plsql table
2562:
2563: -- print empty deliveries
2564: IF p_tbl_delivery_purge_set.COUNT > 0 THEN --check for number of records in plsql table

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

2561: END IF; --check for number of records in plsql table
2562:
2563: -- print empty deliveries
2564: IF p_tbl_delivery_purge_set.COUNT > 0 THEN --check for number of records in plsql table
2565: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2566: l_buff_size := 0 ; -- Reset the buffer size to zero
2567: FOR l_delivery_index in p_tbl_delivery_purge_set.FIRST .. p_tbl_delivery_purge_set.LAST
2568: LOOP
2569: l_delivery_id := p_tbl_delivery_purge_set(l_delivery_index).delivery_id;

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

2573:
2574: --Bug 8204644
2575: IF ( l_buff_size = 0 AND l_empty_del_count=1 ) THEN
2576: l_buff_size := lengthb(l_delivery_name);
2577: FND_FILE.PUT(FND_FILE.OUTPUT,l_delivery_name);
2578: ELSIF ( l_buff_size = 0 AND l_empty_del_count<>1 ) THEN
2579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,',');
2580: l_buff_size := lengthb(l_delivery_name);
2581: FND_FILE.PUT(FND_FILE.OUTPUT,l_delivery_name);

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

2575: IF ( l_buff_size = 0 AND l_empty_del_count=1 ) THEN
2576: l_buff_size := lengthb(l_delivery_name);
2577: FND_FILE.PUT(FND_FILE.OUTPUT,l_delivery_name);
2578: ELSIF ( l_buff_size = 0 AND l_empty_del_count<>1 ) THEN
2579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,',');
2580: l_buff_size := lengthb(l_delivery_name);
2581: FND_FILE.PUT(FND_FILE.OUTPUT,l_delivery_name);
2582: ELSIF l_buff_size < 30000 THEN
2583: l_buff_size := l_buff_size + lengthb(l_delivery_name) + 2;

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

2577: FND_FILE.PUT(FND_FILE.OUTPUT,l_delivery_name);
2578: ELSIF ( l_buff_size = 0 AND l_empty_del_count<>1 ) THEN
2579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,',');
2580: l_buff_size := lengthb(l_delivery_name);
2581: FND_FILE.PUT(FND_FILE.OUTPUT,l_delivery_name);
2582: ELSIF l_buff_size < 30000 THEN
2583: l_buff_size := l_buff_size + lengthb(l_delivery_name) + 2;
2584: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_delivery_name);
2585: ELSIF l_buff_size >= 30000 THEN

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

2580: l_buff_size := lengthb(l_delivery_name);
2581: FND_FILE.PUT(FND_FILE.OUTPUT,l_delivery_name);
2582: ELSIF l_buff_size < 30000 THEN
2583: l_buff_size := l_buff_size + lengthb(l_delivery_name) + 2;
2584: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_delivery_name);
2585: ELSIF l_buff_size >= 30000 THEN
2586: l_buff_size := 0;
2587: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_delivery_name );
2588: END IF;

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

2583: l_buff_size := l_buff_size + lengthb(l_delivery_name) + 2;
2584: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_delivery_name);
2585: ELSIF l_buff_size >= 30000 THEN
2586: l_buff_size := 0;
2587: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_delivery_name );
2588: END IF;
2589: --Bug 8204644
2590:
2591: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

2587: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_delivery_name );
2588: END IF;
2589: --Bug 8204644
2590:
2591: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2592: IF P_SORT_PER_CRITERIA = 'T' THEN
2593: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2594: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');

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

2589: --Bug 8204644
2590:
2591: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2592: IF P_SORT_PER_CRITERIA = 'T' THEN
2593: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2594: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2596: END IF ;
2597: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

2591: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2592: IF P_SORT_PER_CRITERIA = 'T' THEN
2593: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2594: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2596: END IF ;
2597: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/

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

2593: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2594: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2596: END IF ;
2597: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2600:
2601: END IF;

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

2594: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2596: END IF ;
2597: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2600:
2601: END IF;
2602: END LOOP;

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

2595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2596: END IF ;
2597: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2600:
2601: END IF;
2602: END LOOP;
2603: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

2599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2600:
2601: END IF;
2602: END LOOP;
2603: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2604: END IF; --check for number of records in plsql table
2605:
2606: -- print empty containers
2607: IF p_tbl_container_purge_set.COUNT > 0 THEN --check for number of records in plsql table

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

2604: END IF; --check for number of records in plsql table
2605:
2606: -- print empty containers
2607: IF p_tbl_container_purge_set.COUNT > 0 THEN --check for number of records in plsql table
2608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2609: l_buff_size := 0 ; -- Reset the buffer size to zero
2610: FOR l_container_index in p_tbl_container_purge_set.FIRST .. p_tbl_container_purge_set.LAST
2611: LOOP
2612: l_container_id := p_tbl_container_purge_set(l_container_index).container_id;

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

2615:
2616: --Bug 8204644
2617: IF ( l_buff_size = 0 AND l_empty_lpn_count=1 ) THEN
2618: l_buff_size := lengthb(l_container_id);
2619: FND_FILE.PUT(FND_FILE.OUTPUT,l_container_id);
2620: ELSIF ( l_buff_size = 0 AND l_empty_lpn_count<>1 ) THEN
2621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,',');
2622: l_buff_size := lengthb(l_container_id);
2623: FND_FILE.PUT(FND_FILE.OUTPUT,l_container_id);

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

2617: IF ( l_buff_size = 0 AND l_empty_lpn_count=1 ) THEN
2618: l_buff_size := lengthb(l_container_id);
2619: FND_FILE.PUT(FND_FILE.OUTPUT,l_container_id);
2620: ELSIF ( l_buff_size = 0 AND l_empty_lpn_count<>1 ) THEN
2621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,',');
2622: l_buff_size := lengthb(l_container_id);
2623: FND_FILE.PUT(FND_FILE.OUTPUT,l_container_id);
2624: ELSIF l_buff_size < 30000 THEN
2625: l_buff_size := l_buff_size + lengthb(l_container_id) + 2;

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

2619: FND_FILE.PUT(FND_FILE.OUTPUT,l_container_id);
2620: ELSIF ( l_buff_size = 0 AND l_empty_lpn_count<>1 ) THEN
2621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,',');
2622: l_buff_size := lengthb(l_container_id);
2623: FND_FILE.PUT(FND_FILE.OUTPUT,l_container_id);
2624: ELSIF l_buff_size < 30000 THEN
2625: l_buff_size := l_buff_size + lengthb(l_container_id) + 2;
2626: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_container_id);
2627: ELSIF l_buff_size >= 30000 THEN

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

2622: l_buff_size := lengthb(l_container_id);
2623: FND_FILE.PUT(FND_FILE.OUTPUT,l_container_id);
2624: ELSIF l_buff_size < 30000 THEN
2625: l_buff_size := l_buff_size + lengthb(l_container_id) + 2;
2626: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_container_id);
2627: ELSIF l_buff_size >= 30000 THEN
2628: l_buff_size := 0;
2629: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_container_id );
2630: END IF;

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

2625: l_buff_size := l_buff_size + lengthb(l_container_id) + 2;
2626: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_container_id);
2627: ELSIF l_buff_size >= 30000 THEN
2628: l_buff_size := 0;
2629: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_container_id );
2630: END IF;
2631: --Bug 8204644
2632:
2633: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

2629: FND_FILE.PUT(FND_FILE.OUTPUT, ', ' || l_container_id );
2630: END IF;
2631: --Bug 8204644
2632:
2633: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2634: IF P_SORT_PER_CRITERIA = 'T' THEN
2635: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2636: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');

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

2631: --Bug 8204644
2632:
2633: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2634: IF P_SORT_PER_CRITERIA = 'T' THEN
2635: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2636: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2638: END IF ;
2639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

2633: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2634: IF P_SORT_PER_CRITERIA = 'T' THEN
2635: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2636: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2638: END IF ;
2639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2641: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/

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

2635: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '999999999');
2636: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2638: END IF ;
2639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2641: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2642:
2643: END IF;

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

2636: ELSIF P_SORT_PER_CRITERIA = 'D' THEN
2637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2638: END IF ;
2639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2641: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2642:
2643: END IF;
2644: END LOOP;

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

2637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || lpad(l_delivery_id,10,'0') || '');
2638: END IF ;
2639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_delivery_id || '');
2641: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2642:
2643: END IF;
2644: END LOOP;
2645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

2641: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');*/
2642:
2643: END IF;
2644: END LOOP;
2645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2646: END IF; --check for number of records in plsql table
2647:
2648: END IF; --check for print detail
2649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');

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

2645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2646: END IF; --check for number of records in plsql table
2647:
2648: END IF; --check for print detail
2649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');
2650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_trip_count || '');
2651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_del_count || '');
2652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_lpn_count || '');
2653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

2646: END IF; --check for number of records in plsql table
2647:
2648: END IF; --check for print detail
2649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');
2650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_trip_count || '');
2651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_del_count || '');
2652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_lpn_count || '');
2653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2654:

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

2647:
2648: END IF; --check for print detail
2649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');
2650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_trip_count || '');
2651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_del_count || '');
2652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_lpn_count || '');
2653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2654:
2655: IF l_debug_on THEN

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

2648: END IF; --check for print detail
2649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');
2650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_trip_count || '');
2651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_del_count || '');
2652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_lpn_count || '');
2653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2654:
2655: IF l_debug_on THEN
2656: WSH_DEBUG_SV.pop(l_module_name);

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

2649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_nonempty_count || '');
2650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_trip_count || '');
2651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_del_count || '');
2652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' || l_empty_lpn_count || '');
2653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2654:
2655: IF l_debug_on THEN
2656: WSH_DEBUG_SV.pop(l_module_name);
2657: END IF;