309: IF l_debug_on THEN
310: WSH_DEBUG_SV.push(l_module_name);
311: END IF;
312: --
313: FND_REQUEST_INFO.GET_PROGRAM(l_prog_name, l_prog_app_name);
314:
315: -- TRIP ID
316: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Trip Name', l_parm_num);
317: IF (ret_val = -1) THEN
312: --
313: FND_REQUEST_INFO.GET_PROGRAM(l_prog_name, l_prog_app_name);
314:
315: -- TRIP ID
316: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Trip Name', l_parm_num);
317: IF (ret_val = -1) THEN
318: l_doc_param_info.p_trip_id := NULL;
319: ELSE
320: l_doc_param_info.p_trip_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
316: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Trip Name', l_parm_num);
317: IF (ret_val = -1) THEN
318: l_doc_param_info.p_trip_id := NULL;
319: ELSE
320: l_doc_param_info.p_trip_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
321: END IF;
322:
323: -- STOP ID
324: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Trip Stop', l_parm_num);
320: l_doc_param_info.p_trip_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
321: END IF;
322:
323: -- STOP ID
324: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Trip Stop', l_parm_num);
325: IF (ret_val = -1) THEN
326: l_doc_param_info.p_trip_stop_id := NULL;
327: ELSE
328: l_doc_param_info.p_trip_stop_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
324: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Trip Stop', l_parm_num);
325: IF (ret_val = -1) THEN
326: l_doc_param_info.p_trip_stop_id := NULL;
327: ELSE
328: l_doc_param_info.p_trip_stop_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
329: END IF;
330:
331: -- DEPARTURE DATE LOW
332: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Departure Date (Low)', l_parm_num);
328: l_doc_param_info.p_trip_stop_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
329: END IF;
330:
331: -- DEPARTURE DATE LOW
332: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Departure Date (Low)', l_parm_num);
333: IF (ret_val = -1) THEN
334: l_doc_param_info.p_departure_date_low := NULL;
335: ELSE
336: l_doc_param_info.p_departure_date_low := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
332: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Departure Date (Low)', l_parm_num);
333: IF (ret_val = -1) THEN
334: l_doc_param_info.p_departure_date_low := NULL;
335: ELSE
336: l_doc_param_info.p_departure_date_low := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
337: END IF;
338:
339: -- DEPARTURE DATE HIGH
340: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Departure Date (High)', l_parm_num);
336: l_doc_param_info.p_departure_date_low := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
337: END IF;
338:
339: -- DEPARTURE DATE HIGH
340: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Departure Date (High)', l_parm_num);
341: IF (ret_val = -1) THEN
342: l_doc_param_info.p_departure_date_high := NULL;
343: ELSE
344: l_doc_param_info.p_departure_date_high := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
340: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Departure Date (High)', l_parm_num);
341: IF (ret_val = -1) THEN
342: l_doc_param_info.p_departure_date_high := NULL;
343: ELSE
344: l_doc_param_info.p_departure_date_high := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
345: END IF;
346:
347: -- DELIVERY DATE LOW
348: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Delivery Date (Low)', l_parm_num);
344: l_doc_param_info.p_departure_date_high := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
345: END IF;
346:
347: -- DELIVERY DATE LOW
348: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Delivery Date (Low)', l_parm_num);
349: IF (ret_val = -1) THEN
350: l_doc_param_info.p_delivery_date_low := NULL;
351: ELSE
352: l_doc_param_info.p_delivery_date_low := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num)); END IF;
348: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Delivery Date (Low)', l_parm_num);
349: IF (ret_val = -1) THEN
350: l_doc_param_info.p_delivery_date_low := NULL;
351: ELSE
352: l_doc_param_info.p_delivery_date_low := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num)); END IF;
353:
354: -- DELIVERY DATE HIGH
355: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Delivery Date (High)', l_parm_num);
356: IF (ret_val = -1) THEN
351: ELSE
352: l_doc_param_info.p_delivery_date_low := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num)); END IF;
353:
354: -- DELIVERY DATE HIGH
355: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Delivery Date (High)', l_parm_num);
356: IF (ret_val = -1) THEN
357: l_doc_param_info.p_delivery_date_high := NULL;
358: ELSE
359: l_doc_param_info.p_delivery_date_high := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
355: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Delivery Date (High)', l_parm_num);
356: IF (ret_val = -1) THEN
357: l_doc_param_info.p_delivery_date_high := NULL;
358: ELSE
359: l_doc_param_info.p_delivery_date_high := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
360: END IF;
361:
362: -- FREIGHT CARRIER
363: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Freight Carrier', l_parm_num);
359: l_doc_param_info.p_delivery_date_high := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
360: END IF;
361:
362: -- FREIGHT CARRIER
363: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Freight Carrier', l_parm_num);
364: IF (ret_val = -1) THEN
365: l_doc_param_info.p_freight_carrier := NULL;
366: ELSE
367: l_doc_param_info.p_freight_carrier := FND_REQUEST_INFO.GET_PARAMETER(l_parm_num);
363: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Freight Carrier', l_parm_num);
364: IF (ret_val = -1) THEN
365: l_doc_param_info.p_freight_carrier := NULL;
366: ELSE
367: l_doc_param_info.p_freight_carrier := FND_REQUEST_INFO.GET_PARAMETER(l_parm_num);
368: END IF;
369:
370: -- DELIVERY
371: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Delivery Name', l_parm_num);
367: l_doc_param_info.p_freight_carrier := FND_REQUEST_INFO.GET_PARAMETER(l_parm_num);
368: END IF;
369:
370: -- DELIVERY
371: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Delivery Name', l_parm_num);
372: IF (ret_val = -1) THEN
373: l_doc_param_info.p_delivery_id := NULL;
374: ELSE
375: l_doc_param_info.p_delivery_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
371: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Delivery Name', l_parm_num);
372: IF (ret_val = -1) THEN
373: l_doc_param_info.p_delivery_id := NULL;
374: ELSE
375: l_doc_param_info.p_delivery_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
376: END IF;
377:
378: -- ORGANIZATION
379: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Warehouse', l_parm_num);
375: l_doc_param_info.p_delivery_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
376: END IF;
377:
378: -- ORGANIZATION
379: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Warehouse', l_parm_num);
380: IF (ret_val = -1) THEN
381: l_doc_param_info.p_organization_id := NULL;
382: ELSE
383: l_doc_param_info.p_organization_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
379: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Warehouse', l_parm_num);
380: IF (ret_val = -1) THEN
381: l_doc_param_info.p_organization_id := NULL;
382: ELSE
383: l_doc_param_info.p_organization_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
384: END IF;
385:
386: -- DELIVERY LEG ID Bug: 1520197
387: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Bill of Lading Number', l_parm_num);
383: l_doc_param_info.p_organization_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
384: END IF;
385:
386: -- DELIVERY LEG ID Bug: 1520197
387: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Bill of Lading Number', l_parm_num);
388: IF (ret_val = -1) THEN
389: l_doc_param_info.p_delivery_leg_id := NULL;
390: ELSE
391: l_doc_param_info.p_delivery_leg_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
387: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Bill of Lading Number', l_parm_num);
388: IF (ret_val = -1) THEN
389: l_doc_param_info.p_delivery_leg_id := NULL;
390: ELSE
391: l_doc_param_info.p_delivery_leg_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(l_parm_num));
392: END IF;
393:
394: -- Calling Get_Lang_String
395: IF l_debug_on THEN
545: END IF;
546: raise ;
547: end;
548:
549: x_nls_lang(i).nls_territory := fnd_request_info.get_territory;
550:
551: end if;
552: end loop;
553: