91: m_request_id NUMBER;
92:
93: BEGIN
94:
95: l_options_ok := FND_REQUEST.SET_OPTIONS (
96: implicit => 'NO'
97: , protected => 'YES'
98: , language => p_nls_lang
99: , territory => p_nls_territory);
99: , territory => p_nls_territory);
100: IF (l_options_ok)
101: THEN
102:
103: m_request_id := FND_REQUEST.SUBMIT_REQUEST(
104: application => 'AR'
105: , program => 'ARBPIPCP'
106: , description => p_description
107: , start_time => ''
366: fnd_file.put_line( fnd_file.log, 'userenv_lang: ' || userenv_lang);
367: --fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);/*Bug8486880*/
368:
369: /* Read in Parameter Values supplied by user */
370: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Operating Unit',parm_number);
371: IF retval = -1 THEN
372: p_org_id := NULL;
373: ELSE
374: p_org_id:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
370: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Operating Unit',parm_number);
371: IF retval = -1 THEN
372: p_org_id := NULL;
373: ELSE
374: p_org_id:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
375: END IF;
376: fnd_file.put_line( fnd_file.log, 'p_org_id: ' || p_org_id);
377:
378: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Job Size',parm_number);
374: p_org_id:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
375: END IF;
376: fnd_file.put_line( fnd_file.log, 'p_org_id: ' || p_org_id);
377:
378: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Job Size',parm_number);
379: IF retval = -1 THEN
380: p_job_size:= NULL;
381: ELSE
382: p_job_size:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
378: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Job Size',parm_number);
379: IF retval = -1 THEN
380: p_job_size:= NULL;
381: ELSE
382: p_job_size:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
383: END IF;
384: fnd_file.put_line( fnd_file.log, 'p_job_size: ' || p_job_size);
385:
386: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Number Low',parm_number);
382: p_job_size:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
383: END IF;
384: fnd_file.put_line( fnd_file.log, 'p_job_size: ' || p_job_size);
385:
386: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Number Low',parm_number);
387: IF retval = -1 THEN
388: p_cust_num_low:= NULL;
389: ELSE
390: p_cust_num_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
386: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Number Low',parm_number);
387: IF retval = -1 THEN
388: p_cust_num_low:= NULL;
389: ELSE
390: p_cust_num_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
391: END IF;
392: fnd_file.put_line( fnd_file.log, 'p_cust_num_low: ' || p_cust_num_low);
393:
394: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Number High',parm_number);
390: p_cust_num_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
391: END IF;
392: fnd_file.put_line( fnd_file.log, 'p_cust_num_low: ' || p_cust_num_low);
393:
394: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Number High',parm_number);
395: IF retval = -1 THEN
396: p_cust_num_high:= NULL;
397: ELSE
398: p_cust_num_high:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
394: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Number High',parm_number);
395: IF retval = -1 THEN
396: p_cust_num_high:= NULL;
397: ELSE
398: p_cust_num_high:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
399: END IF;
400: fnd_file.put_line( fnd_file.log, 'p_cust_num_high: ' || p_cust_num_high);
401:
402: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Location Low',parm_number);
398: p_cust_num_high:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
399: END IF;
400: fnd_file.put_line( fnd_file.log, 'p_cust_num_high: ' || p_cust_num_high);
401:
402: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Location Low',parm_number);
403: IF retval = -1 THEN
404: p_bill_site_low:= NULL;
405: ELSE
406: p_bill_site_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
402: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Location Low',parm_number);
403: IF retval = -1 THEN
404: p_bill_site_low:= NULL;
405: ELSE
406: p_bill_site_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
407: END IF;
408: fnd_file.put_line( fnd_file.log, 'p_bill_site_low: ' || p_bill_site_low);
409:
410: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Location High',parm_number);
406: p_bill_site_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
407: END IF;
408: fnd_file.put_line( fnd_file.log, 'p_bill_site_low: ' || p_bill_site_low);
409:
410: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Location High',parm_number);
411: IF retval = -1 THEN
412: p_bill_site_high:= NULL;
413: ELSE
414: p_bill_site_high:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
410: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Location High',parm_number);
411: IF retval = -1 THEN
412: p_bill_site_high:= NULL;
413: ELSE
414: p_bill_site_high:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
415: END IF;
416: fnd_file.put_line( fnd_file.log, 'p_bill_site_high: ' || p_bill_site_high);
417:
418: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Date Low',parm_number);
414: p_bill_site_high:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
415: END IF;
416: fnd_file.put_line( fnd_file.log, 'p_bill_site_high: ' || p_bill_site_high);
417:
418: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Date Low',parm_number);
419: IF retval = -1 THEN
420: p_bill_date_low:= NULL;
421: ELSE
422: p_bill_date_low:= fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
418: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Date Low',parm_number);
419: IF retval = -1 THEN
420: p_bill_date_low:= NULL;
421: ELSE
422: p_bill_date_low:= fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
423: END IF;
424: fnd_file.put_line( fnd_file.log, 'p_bill_date_low: ' || p_bill_date_low);
425:
426: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Date High',parm_number);
422: p_bill_date_low:= fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
423: END IF;
424: fnd_file.put_line( fnd_file.log, 'p_bill_date_low: ' || p_bill_date_low);
425:
426: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Date High',parm_number);
427: IF retval = -1 THEN
428: p_bill_date_high:= NULL;
429: ELSE
430: p_bill_date_high:= fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
426: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Date High',parm_number);
427: IF retval = -1 THEN
428: p_bill_date_high:= NULL;
429: ELSE
430: p_bill_date_high:= fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
431: END IF;
432: fnd_file.put_line( fnd_file.log, 'p_bill_date_high: ' || p_bill_date_high);
433:
434: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Number Low',parm_number);
430: p_bill_date_high:= fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
431: END IF;
432: fnd_file.put_line( fnd_file.log, 'p_bill_date_high: ' || p_bill_date_high);
433:
434: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Number Low',parm_number);
435: IF retval = -1 THEN
436: p_bill_num_low:= NULL;
437: ELSE
438: p_bill_num_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
434: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Number Low',parm_number);
435: IF retval = -1 THEN
436: p_bill_num_low:= NULL;
437: ELSE
438: p_bill_num_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
439: END IF;
440: fnd_file.put_line( fnd_file.log, 'p_bill_num_low: ' || p_bill_num_low);
441:
442: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Number High',parm_number);
438: p_bill_num_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
439: END IF;
440: fnd_file.put_line( fnd_file.log, 'p_bill_num_low: ' || p_bill_num_low);
441:
442: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Number High',parm_number);
443: IF retval = -1 THEN
444: p_bill_num_high:= NULL;
445: ELSE
446: p_bill_num_high:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
442: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Billing Number High',parm_number);
443: IF retval = -1 THEN
444: p_bill_num_high:= NULL;
445: ELSE
446: p_bill_num_high:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
447: END IF;
448: fnd_file.put_line( fnd_file.log, 'p_bill_num_high: ' || p_bill_num_high);
449:
450: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Concurrent Request ID',parm_number);
446: p_bill_num_high:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
447: END IF;
448: fnd_file.put_line( fnd_file.log, 'p_bill_num_high: ' || p_bill_num_high);
449:
450: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Concurrent Request ID',parm_number);
451: IF retval = -1 THEN
452: p_request_id:= NULL;
453: ELSE
454: p_request_id:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
450: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Concurrent Request ID',parm_number);
451: IF retval = -1 THEN
452: p_request_id:= NULL;
453: ELSE
454: p_request_id:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
455: END IF;
456: fnd_file.put_line( fnd_file.log, 'p_request_id: ' || p_request_id);
457:
458: /*Bug8486880*/