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.PAY_GB_PAYE_SYNC dependencies on FND_FILE

Line 337: fnd_file.put(FND_FILE.OUTPUT,'---------------- Download Parameters --------------------');

333:
334: hr_utility.set_location('step1 l_effective_date '|| to_char(l_effective_date,'DD-MON-YYYY') ,10);
335:
336:
337: fnd_file.put(FND_FILE.OUTPUT,'---------------- Download Parameters --------------------');
338: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
339: fnd_file.put(FND_FILE.OUTPUT,'* Run Date : '|| to_char(sysdate,'DD-MON-YYYY'));
340: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
341: fnd_file.put(FND_FILE.OUTPUT,'* Effective Date : '|| to_char(l_effective_date,'DD-MON-YYYY'));

Line 338: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

334: hr_utility.set_location('step1 l_effective_date '|| to_char(l_effective_date,'DD-MON-YYYY') ,10);
335:
336:
337: fnd_file.put(FND_FILE.OUTPUT,'---------------- Download Parameters --------------------');
338: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
339: fnd_file.put(FND_FILE.OUTPUT,'* Run Date : '|| to_char(sysdate,'DD-MON-YYYY'));
340: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
341: fnd_file.put(FND_FILE.OUTPUT,'* Effective Date : '|| to_char(l_effective_date,'DD-MON-YYYY'));
342: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 339: fnd_file.put(FND_FILE.OUTPUT,'* Run Date : '|| to_char(sysdate,'DD-MON-YYYY'));

335:
336:
337: fnd_file.put(FND_FILE.OUTPUT,'---------------- Download Parameters --------------------');
338: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
339: fnd_file.put(FND_FILE.OUTPUT,'* Run Date : '|| to_char(sysdate,'DD-MON-YYYY'));
340: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
341: fnd_file.put(FND_FILE.OUTPUT,'* Effective Date : '|| to_char(l_effective_date,'DD-MON-YYYY'));
342: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
343: fnd_file.put(FND_FILE.OUTPUT,'* Tax Reference : '|| l_tax_ref);

Line 340: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

336:
337: fnd_file.put(FND_FILE.OUTPUT,'---------------- Download Parameters --------------------');
338: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
339: fnd_file.put(FND_FILE.OUTPUT,'* Run Date : '|| to_char(sysdate,'DD-MON-YYYY'));
340: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
341: fnd_file.put(FND_FILE.OUTPUT,'* Effective Date : '|| to_char(l_effective_date,'DD-MON-YYYY'));
342: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
343: fnd_file.put(FND_FILE.OUTPUT,'* Tax Reference : '|| l_tax_ref);
344: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 341: fnd_file.put(FND_FILE.OUTPUT,'* Effective Date : '|| to_char(l_effective_date,'DD-MON-YYYY'));

337: fnd_file.put(FND_FILE.OUTPUT,'---------------- Download Parameters --------------------');
338: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
339: fnd_file.put(FND_FILE.OUTPUT,'* Run Date : '|| to_char(sysdate,'DD-MON-YYYY'));
340: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
341: fnd_file.put(FND_FILE.OUTPUT,'* Effective Date : '|| to_char(l_effective_date,'DD-MON-YYYY'));
342: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
343: fnd_file.put(FND_FILE.OUTPUT,'* Tax Reference : '|| l_tax_ref);
344: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
345: fnd_file.put(FND_FILE.OUTPUT,'* Download Request Id : '|| FND_GLOBAL.CONC_REQUEST_ID);

Line 342: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

338: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
339: fnd_file.put(FND_FILE.OUTPUT,'* Run Date : '|| to_char(sysdate,'DD-MON-YYYY'));
340: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
341: fnd_file.put(FND_FILE.OUTPUT,'* Effective Date : '|| to_char(l_effective_date,'DD-MON-YYYY'));
342: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
343: fnd_file.put(FND_FILE.OUTPUT,'* Tax Reference : '|| l_tax_ref);
344: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
345: fnd_file.put(FND_FILE.OUTPUT,'* Download Request Id : '|| FND_GLOBAL.CONC_REQUEST_ID);
346: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 343: fnd_file.put(FND_FILE.OUTPUT,'* Tax Reference : '|| l_tax_ref);

339: fnd_file.put(FND_FILE.OUTPUT,'* Run Date : '|| to_char(sysdate,'DD-MON-YYYY'));
340: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
341: fnd_file.put(FND_FILE.OUTPUT,'* Effective Date : '|| to_char(l_effective_date,'DD-MON-YYYY'));
342: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
343: fnd_file.put(FND_FILE.OUTPUT,'* Tax Reference : '|| l_tax_ref);
344: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
345: fnd_file.put(FND_FILE.OUTPUT,'* Download Request Id : '|| FND_GLOBAL.CONC_REQUEST_ID);
346: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
347: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 344: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

340: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
341: fnd_file.put(FND_FILE.OUTPUT,'* Effective Date : '|| to_char(l_effective_date,'DD-MON-YYYY'));
342: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
343: fnd_file.put(FND_FILE.OUTPUT,'* Tax Reference : '|| l_tax_ref);
344: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
345: fnd_file.put(FND_FILE.OUTPUT,'* Download Request Id : '|| FND_GLOBAL.CONC_REQUEST_ID);
346: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
347: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
348:

Line 345: fnd_file.put(FND_FILE.OUTPUT,'* Download Request Id : '|| FND_GLOBAL.CONC_REQUEST_ID);

341: fnd_file.put(FND_FILE.OUTPUT,'* Effective Date : '|| to_char(l_effective_date,'DD-MON-YYYY'));
342: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
343: fnd_file.put(FND_FILE.OUTPUT,'* Tax Reference : '|| l_tax_ref);
344: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
345: fnd_file.put(FND_FILE.OUTPUT,'* Download Request Id : '|| FND_GLOBAL.CONC_REQUEST_ID);
346: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
347: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
348:
349: hr_utility.set_location('step2',20);

Line 346: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

342: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
343: fnd_file.put(FND_FILE.OUTPUT,'* Tax Reference : '|| l_tax_ref);
344: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
345: fnd_file.put(FND_FILE.OUTPUT,'* Download Request Id : '|| FND_GLOBAL.CONC_REQUEST_ID);
346: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
347: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
348:
349: hr_utility.set_location('step2',20);
350:

Line 347: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

343: fnd_file.put(FND_FILE.OUTPUT,'* Tax Reference : '|| l_tax_ref);
344: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
345: fnd_file.put(FND_FILE.OUTPUT,'* Download Request Id : '|| FND_GLOBAL.CONC_REQUEST_ID);
346: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
347: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
348:
349: hr_utility.set_location('step2',20);
350:
351: -------------------------------------------------

Line 421: fnd_file.put(FND_FILE.OUTPUT,rpad('Last Name',15,' ') ||'~'||

417:
418: IF j_count = 0
419: THEN
420:
421: fnd_file.put(FND_FILE.OUTPUT,rpad('Last Name',15,' ') ||'~'||
422: rpad('Assignment Num',15,' ') ||'~'||
423: rpad('T_Code',8,' ') ||'~'||
424: rpad('T_Basis',8,' ')||'~'||
425: rpad('Refund',13,' ')||'~'||

Line 443: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

439: rpad('Eff_E_Date',12,' ') ||'~'||
440: rpad('OVN',10,' ')
441:
442: );
443: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
444:
445: fnd_file.put(FND_FILE.OUTPUT,'--------- -------------- ------ ------- ------ ------ ');
446: fnd_file.put(FND_FILE.OUTPUT,'------ --------- ------ ------- -------- -------- -------- ');
447: fnd_file.put(FND_FILE.OUTPUT,'---------- --------- --------- ---------- ---------- ---------- ----');

Line 445: fnd_file.put(FND_FILE.OUTPUT,'--------- -------------- ------ ------- ------ ------ ');

441:
442: );
443: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
444:
445: fnd_file.put(FND_FILE.OUTPUT,'--------- -------------- ------ ------- ------ ------ ');
446: fnd_file.put(FND_FILE.OUTPUT,'------ --------- ------ ------- -------- -------- -------- ');
447: fnd_file.put(FND_FILE.OUTPUT,'---------- --------- --------- ---------- ---------- ---------- ----');
448:
449: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 446: fnd_file.put(FND_FILE.OUTPUT,'------ --------- ------ ------- -------- -------- -------- ');

442: );
443: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
444:
445: fnd_file.put(FND_FILE.OUTPUT,'--------- -------------- ------ ------- ------ ------ ');
446: fnd_file.put(FND_FILE.OUTPUT,'------ --------- ------ ------- -------- -------- -------- ');
447: fnd_file.put(FND_FILE.OUTPUT,'---------- --------- --------- ---------- ---------- ---------- ----');
448:
449: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
450:

Line 447: fnd_file.put(FND_FILE.OUTPUT,'---------- --------- --------- ---------- ---------- ---------- ----');

443: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
444:
445: fnd_file.put(FND_FILE.OUTPUT,'--------- -------------- ------ ------- ------ ------ ');
446: fnd_file.put(FND_FILE.OUTPUT,'------ --------- ------ ------- -------- -------- -------- ');
447: fnd_file.put(FND_FILE.OUTPUT,'---------- --------- --------- ---------- ---------- ---------- ----');
448:
449: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
450:
451: j_count := 1;

Line 449: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

445: fnd_file.put(FND_FILE.OUTPUT,'--------- -------------- ------ ------- ------ ------ ');
446: fnd_file.put(FND_FILE.OUTPUT,'------ --------- ------ ------- -------- -------- -------- ');
447: fnd_file.put(FND_FILE.OUTPUT,'---------- --------- --------- ---------- ---------- ---------- ----');
448:
449: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
450:
451: j_count := 1;
452:
453: END IF;

Line 476: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

472:
473: IF (l_last_person_id <> required_info.pid)
474: THEN
475:
476: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
477: l_last_person_id := required_info.pid;
478:
479: l_last_cpe_st_date := required_info.cpe_start;
480:

Line 507: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.lname,15,' ')||'~'); --last_name

503: END IF;
504:
505: hr_utility.set_location('Step9 l_last_cpe_st_date '|| l_last_cpe_st_date,10);
506:
507: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.lname,15,' ')||'~'); --last_name
508: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.anum,15,' ')||'~'); --Assg_Num
509: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_code,8,' ')||'~'); --Tax_code
510: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_basis,8,' ')||'~'); --Tax_basis
511: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Refundable,13,' ')||'~'); --Refuns

Line 508: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.anum,15,' ')||'~'); --Assg_Num

504:
505: hr_utility.set_location('Step9 l_last_cpe_st_date '|| l_last_cpe_st_date,10);
506:
507: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.lname,15,' ')||'~'); --last_name
508: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.anum,15,' ')||'~'); --Assg_Num
509: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_code,8,' ')||'~'); --Tax_code
510: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_basis,8,' ')||'~'); --Tax_basis
511: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Refundable,13,' ')||'~'); --Refuns
512: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Tax_Previous,12,' ')||'~'); --Tax_Prev

Line 509: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_code,8,' ')||'~'); --Tax_code

505: hr_utility.set_location('Step9 l_last_cpe_st_date '|| l_last_cpe_st_date,10);
506:
507: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.lname,15,' ')||'~'); --last_name
508: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.anum,15,' ')||'~'); --Assg_Num
509: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_code,8,' ')||'~'); --Tax_code
510: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_basis,8,' ')||'~'); --Tax_basis
511: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Refundable,13,' ')||'~'); --Refuns
512: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Tax_Previous,12,' ')||'~'); --Tax_Prev
513: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Pay_Previous,12,' ')||'~'); --Pay_Prev

Line 510: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_basis,8,' ')||'~'); --Tax_basis

506:
507: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.lname,15,' ')||'~'); --last_name
508: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.anum,15,' ')||'~'); --Assg_Num
509: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_code,8,' ')||'~'); --Tax_code
510: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_basis,8,' ')||'~'); --Tax_basis
511: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Refundable,13,' ')||'~'); --Refuns
512: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Tax_Previous,12,' ')||'~'); --Tax_Prev
513: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Pay_Previous,12,' ')||'~'); --Pay_Prev
514: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(required_info.Authority,' '),10,' ')||'~'); --Authority

Line 511: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Refundable,13,' ')||'~'); --Refuns

507: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.lname,15,' ')||'~'); --last_name
508: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.anum,15,' ')||'~'); --Assg_Num
509: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_code,8,' ')||'~'); --Tax_code
510: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_basis,8,' ')||'~'); --Tax_basis
511: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Refundable,13,' ')||'~'); --Refuns
512: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Tax_Previous,12,' ')||'~'); --Tax_Prev
513: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Pay_Previous,12,' ')||'~'); --Pay_Prev
514: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(required_info.Authority,' '),10,' ')||'~'); --Authority
515: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_code,8,' ')||'~'); --S_tax_code

Line 512: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Tax_Previous,12,' ')||'~'); --Tax_Prev

508: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.anum,15,' ')||'~'); --Assg_Num
509: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_code,8,' ')||'~'); --Tax_code
510: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_basis,8,' ')||'~'); --Tax_basis
511: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Refundable,13,' ')||'~'); --Refuns
512: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Tax_Previous,12,' ')||'~'); --Tax_Prev
513: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Pay_Previous,12,' ')||'~'); --Pay_Prev
514: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(required_info.Authority,' '),10,' ')||'~'); --Authority
515: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_code,8,' ')||'~'); --S_tax_code
516: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_basis,8,' ')||'~'); --S_tax_basis

Line 513: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Pay_Previous,12,' ')||'~'); --Pay_Prev

509: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_code,8,' ')||'~'); --Tax_code
510: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_basis,8,' ')||'~'); --Tax_basis
511: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Refundable,13,' ')||'~'); --Refuns
512: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Tax_Previous,12,' ')||'~'); --Tax_Prev
513: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Pay_Previous,12,' ')||'~'); --Pay_Prev
514: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(required_info.Authority,' '),10,' ')||'~'); --Authority
515: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_code,8,' ')||'~'); --S_tax_code
516: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_basis,8,' ')||'~'); --S_tax_basis
517: fnd_file.put(FND_FILE.OUTPUT, rpad(j_refundable,13,' ')||'~'); --S_refundable

Line 514: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(required_info.Authority,' '),10,' ')||'~'); --Authority

510: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.tax_basis,8,' ')||'~'); --Tax_basis
511: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Refundable,13,' ')||'~'); --Refuns
512: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Tax_Previous,12,' ')||'~'); --Tax_Prev
513: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Pay_Previous,12,' ')||'~'); --Pay_Prev
514: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(required_info.Authority,' '),10,' ')||'~'); --Authority
515: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_code,8,' ')||'~'); --S_tax_code
516: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_basis,8,' ')||'~'); --S_tax_basis
517: fnd_file.put(FND_FILE.OUTPUT, rpad(j_refundable,13,' ')||'~'); --S_refundable
518: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_previous,12,' ')||'~'); --S_Tax_prev

Line 515: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_code,8,' ')||'~'); --S_tax_code

511: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Refundable,13,' ')||'~'); --Refuns
512: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Tax_Previous,12,' ')||'~'); --Tax_Prev
513: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Pay_Previous,12,' ')||'~'); --Pay_Prev
514: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(required_info.Authority,' '),10,' ')||'~'); --Authority
515: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_code,8,' ')||'~'); --S_tax_code
516: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_basis,8,' ')||'~'); --S_tax_basis
517: fnd_file.put(FND_FILE.OUTPUT, rpad(j_refundable,13,' ')||'~'); --S_refundable
518: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_previous,12,' ')||'~'); --S_Tax_prev
519: fnd_file.put(FND_FILE.OUTPUT, rpad(j_pay_previous,12,' ')||'~'); --S_Pay_prev

Line 516: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_basis,8,' ')||'~'); --S_tax_basis

512: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Tax_Previous,12,' ')||'~'); --Tax_Prev
513: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Pay_Previous,12,' ')||'~'); --Pay_Prev
514: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(required_info.Authority,' '),10,' ')||'~'); --Authority
515: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_code,8,' ')||'~'); --S_tax_code
516: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_basis,8,' ')||'~'); --S_tax_basis
517: fnd_file.put(FND_FILE.OUTPUT, rpad(j_refundable,13,' ')||'~'); --S_refundable
518: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_previous,12,' ')||'~'); --S_Tax_prev
519: fnd_file.put(FND_FILE.OUTPUT, rpad(j_pay_previous,12,' ')||'~'); --S_Pay_prev
520: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(j_authority,' '),10,' ')||'~'); --S_Authority

Line 517: fnd_file.put(FND_FILE.OUTPUT, rpad(j_refundable,13,' ')||'~'); --S_refundable

513: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.Pay_Previous,12,' ')||'~'); --Pay_Prev
514: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(required_info.Authority,' '),10,' ')||'~'); --Authority
515: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_code,8,' ')||'~'); --S_tax_code
516: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_basis,8,' ')||'~'); --S_tax_basis
517: fnd_file.put(FND_FILE.OUTPUT, rpad(j_refundable,13,' ')||'~'); --S_refundable
518: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_previous,12,' ')||'~'); --S_Tax_prev
519: fnd_file.put(FND_FILE.OUTPUT, rpad(j_pay_previous,12,' ')||'~'); --S_Pay_prev
520: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(j_authority,' '),10,' ')||'~'); --S_Authority
521: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.pid,10,' ')||'~'); --Pers_Id

Line 518: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_previous,12,' ')||'~'); --S_Tax_prev

514: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(required_info.Authority,' '),10,' ')||'~'); --Authority
515: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_code,8,' ')||'~'); --S_tax_code
516: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_basis,8,' ')||'~'); --S_tax_basis
517: fnd_file.put(FND_FILE.OUTPUT, rpad(j_refundable,13,' ')||'~'); --S_refundable
518: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_previous,12,' ')||'~'); --S_Tax_prev
519: fnd_file.put(FND_FILE.OUTPUT, rpad(j_pay_previous,12,' ')||'~'); --S_Pay_prev
520: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(j_authority,' '),10,' ')||'~'); --S_Authority
521: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.pid,10,' ')||'~'); --Pers_Id
522: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.aid,10,' ')||'~'); --Asg_Id

Line 519: fnd_file.put(FND_FILE.OUTPUT, rpad(j_pay_previous,12,' ')||'~'); --S_Pay_prev

515: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_code,8,' ')||'~'); --S_tax_code
516: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_basis,8,' ')||'~'); --S_tax_basis
517: fnd_file.put(FND_FILE.OUTPUT, rpad(j_refundable,13,' ')||'~'); --S_refundable
518: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_previous,12,' ')||'~'); --S_Tax_prev
519: fnd_file.put(FND_FILE.OUTPUT, rpad(j_pay_previous,12,' ')||'~'); --S_Pay_prev
520: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(j_authority,' '),10,' ')||'~'); --S_Authority
521: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.pid,10,' ')||'~'); --Pers_Id
522: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.aid,10,' ')||'~'); --Asg_Id
523: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.cpe_start,'DD-MON-YYYY'),12,' ')||'~'); --CPE_St_Date

Line 520: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(j_authority,' '),10,' ')||'~'); --S_Authority

516: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_basis,8,' ')||'~'); --S_tax_basis
517: fnd_file.put(FND_FILE.OUTPUT, rpad(j_refundable,13,' ')||'~'); --S_refundable
518: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_previous,12,' ')||'~'); --S_Tax_prev
519: fnd_file.put(FND_FILE.OUTPUT, rpad(j_pay_previous,12,' ')||'~'); --S_Pay_prev
520: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(j_authority,' '),10,' ')||'~'); --S_Authority
521: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.pid,10,' ')||'~'); --Pers_Id
522: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.aid,10,' ')||'~'); --Asg_Id
523: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.cpe_start,'DD-MON-YYYY'),12,' ')||'~'); --CPE_St_Date
524: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effst,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent St Date

Line 521: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.pid,10,' ')||'~'); --Pers_Id

517: fnd_file.put(FND_FILE.OUTPUT, rpad(j_refundable,13,' ')||'~'); --S_refundable
518: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_previous,12,' ')||'~'); --S_Tax_prev
519: fnd_file.put(FND_FILE.OUTPUT, rpad(j_pay_previous,12,' ')||'~'); --S_Pay_prev
520: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(j_authority,' '),10,' ')||'~'); --S_Authority
521: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.pid,10,' ')||'~'); --Pers_Id
522: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.aid,10,' ')||'~'); --Asg_Id
523: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.cpe_start,'DD-MON-YYYY'),12,' ')||'~'); --CPE_St_Date
524: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effst,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent St Date
525: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effend,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent Ed Date

Line 522: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.aid,10,' ')||'~'); --Asg_Id

518: fnd_file.put(FND_FILE.OUTPUT, rpad(j_tax_previous,12,' ')||'~'); --S_Tax_prev
519: fnd_file.put(FND_FILE.OUTPUT, rpad(j_pay_previous,12,' ')||'~'); --S_Pay_prev
520: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(j_authority,' '),10,' ')||'~'); --S_Authority
521: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.pid,10,' ')||'~'); --Pers_Id
522: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.aid,10,' ')||'~'); --Asg_Id
523: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.cpe_start,'DD-MON-YYYY'),12,' ')||'~'); --CPE_St_Date
524: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effst,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent St Date
525: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effend,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent Ed Date
526: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.ovn,10,' ')); --Ele OVN

Line 523: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.cpe_start,'DD-MON-YYYY'),12,' ')||'~'); --CPE_St_Date

519: fnd_file.put(FND_FILE.OUTPUT, rpad(j_pay_previous,12,' ')||'~'); --S_Pay_prev
520: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(j_authority,' '),10,' ')||'~'); --S_Authority
521: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.pid,10,' ')||'~'); --Pers_Id
522: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.aid,10,' ')||'~'); --Asg_Id
523: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.cpe_start,'DD-MON-YYYY'),12,' ')||'~'); --CPE_St_Date
524: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effst,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent St Date
525: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effend,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent Ed Date
526: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.ovn,10,' ')); --Ele OVN
527:

Line 524: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effst,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent St Date

520: fnd_file.put(FND_FILE.OUTPUT, rpad(nvl(j_authority,' '),10,' ')||'~'); --S_Authority
521: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.pid,10,' ')||'~'); --Pers_Id
522: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.aid,10,' ')||'~'); --Asg_Id
523: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.cpe_start,'DD-MON-YYYY'),12,' ')||'~'); --CPE_St_Date
524: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effst,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent St Date
525: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effend,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent Ed Date
526: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.ovn,10,' ')); --Ele OVN
527:
528: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 525: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effend,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent Ed Date

521: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.pid,10,' ')||'~'); --Pers_Id
522: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.aid,10,' ')||'~'); --Asg_Id
523: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.cpe_start,'DD-MON-YYYY'),12,' ')||'~'); --CPE_St_Date
524: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effst,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent St Date
525: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effend,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent Ed Date
526: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.ovn,10,' ')); --Ele OVN
527:
528: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
529:

Line 526: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.ovn,10,' ')); --Ele OVN

522: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.aid,10,' ')||'~'); --Asg_Id
523: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.cpe_start,'DD-MON-YYYY'),12,' ')||'~'); --CPE_St_Date
524: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effst,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent St Date
525: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effend,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent Ed Date
526: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.ovn,10,' ')); --Ele OVN
527:
528: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
529:
530: END LOOP;

Line 528: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

524: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effst,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent St Date
525: fnd_file.put(FND_FILE.OUTPUT, rpad(to_char(required_info.effend,'DD-MON-YYYY'),12,' ')||'~'); --Ele Ent Ed Date
526: fnd_file.put(FND_FILE.OUTPUT, rpad(required_info.ovn,10,' ')); --Ele OVN
527:
528: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
529:
530: END LOOP;
531:
532: END IF;

Line 541: fnd_file.put(FND_FILE.OUTPUT,'No Records Found. All the Aggregated Assignments for the given Tax Districts shares the same Tax details');

537:
538: IF (j_count = 0)
539: THEN
540:
541: fnd_file.put(FND_FILE.OUTPUT,'No Records Found. All the Aggregated Assignments for the given Tax Districts shares the same Tax details');
542: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
543:
544: ELSE
545: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 542: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

538: IF (j_count = 0)
539: THEN
540:
541: fnd_file.put(FND_FILE.OUTPUT,'No Records Found. All the Aggregated Assignments for the given Tax Districts shares the same Tax details');
542: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
543:
544: ELSE
545: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
546: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 545: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

541: fnd_file.put(FND_FILE.OUTPUT,'No Records Found. All the Aggregated Assignments for the given Tax Districts shares the same Tax details');
542: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
543:
544: ELSE
545: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
546: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
547: fnd_file.put(FND_FILE.OUTPUT,'Keys :');
548: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
549: fnd_file.put(FND_FILE.OUTPUT,'------');

Line 546: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

542: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
543:
544: ELSE
545: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
546: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
547: fnd_file.put(FND_FILE.OUTPUT,'Keys :');
548: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
549: fnd_file.put(FND_FILE.OUTPUT,'------');
550: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 547: fnd_file.put(FND_FILE.OUTPUT,'Keys :');

543:
544: ELSE
545: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
546: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
547: fnd_file.put(FND_FILE.OUTPUT,'Keys :');
548: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
549: fnd_file.put(FND_FILE.OUTPUT,'------');
550: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
551: fnd_file.put(FND_FILE.OUTPUT,'T_Code : Tax Code S_Code : Suggested Tax Code OVN : Element Entry Object Version Number');

Line 548: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

544: ELSE
545: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
546: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
547: fnd_file.put(FND_FILE.OUTPUT,'Keys :');
548: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
549: fnd_file.put(FND_FILE.OUTPUT,'------');
550: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
551: fnd_file.put(FND_FILE.OUTPUT,'T_Code : Tax Code S_Code : Suggested Tax Code OVN : Element Entry Object Version Number');
552: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 549: fnd_file.put(FND_FILE.OUTPUT,'------');

545: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
546: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
547: fnd_file.put(FND_FILE.OUTPUT,'Keys :');
548: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
549: fnd_file.put(FND_FILE.OUTPUT,'------');
550: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
551: fnd_file.put(FND_FILE.OUTPUT,'T_Code : Tax Code S_Code : Suggested Tax Code OVN : Element Entry Object Version Number');
552: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
553: fnd_file.put(FND_FILE.OUTPUT,'T_Basis : Tax Basis S_Basis : Suggested Tax Basis Eff_E_Date : Element Entry Effective End Date');

Line 550: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

546: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
547: fnd_file.put(FND_FILE.OUTPUT,'Keys :');
548: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
549: fnd_file.put(FND_FILE.OUTPUT,'------');
550: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
551: fnd_file.put(FND_FILE.OUTPUT,'T_Code : Tax Code S_Code : Suggested Tax Code OVN : Element Entry Object Version Number');
552: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
553: fnd_file.put(FND_FILE.OUTPUT,'T_Basis : Tax Basis S_Basis : Suggested Tax Basis Eff_E_Date : Element Entry Effective End Date');
554: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 551: fnd_file.put(FND_FILE.OUTPUT,'T_Code : Tax Code S_Code : Suggested Tax Code OVN : Element Entry Object Version Number');

547: fnd_file.put(FND_FILE.OUTPUT,'Keys :');
548: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
549: fnd_file.put(FND_FILE.OUTPUT,'------');
550: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
551: fnd_file.put(FND_FILE.OUTPUT,'T_Code : Tax Code S_Code : Suggested Tax Code OVN : Element Entry Object Version Number');
552: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
553: fnd_file.put(FND_FILE.OUTPUT,'T_Basis : Tax Basis S_Basis : Suggested Tax Basis Eff_E_Date : Element Entry Effective End Date');
554: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
555: fnd_file.put(FND_FILE.OUTPUT,'T_Prev : Tax Previous S_Prev : Suggested Tax Previous Eff_S_Date : Element Entry Effective Start Date');

Line 552: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

548: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
549: fnd_file.put(FND_FILE.OUTPUT,'------');
550: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
551: fnd_file.put(FND_FILE.OUTPUT,'T_Code : Tax Code S_Code : Suggested Tax Code OVN : Element Entry Object Version Number');
552: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
553: fnd_file.put(FND_FILE.OUTPUT,'T_Basis : Tax Basis S_Basis : Suggested Tax Basis Eff_E_Date : Element Entry Effective End Date');
554: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
555: fnd_file.put(FND_FILE.OUTPUT,'T_Prev : Tax Previous S_Prev : Suggested Tax Previous Eff_S_Date : Element Entry Effective Start Date');
556: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 553: fnd_file.put(FND_FILE.OUTPUT,'T_Basis : Tax Basis S_Basis : Suggested Tax Basis Eff_E_Date : Element Entry Effective End Date');

549: fnd_file.put(FND_FILE.OUTPUT,'------');
550: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
551: fnd_file.put(FND_FILE.OUTPUT,'T_Code : Tax Code S_Code : Suggested Tax Code OVN : Element Entry Object Version Number');
552: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
553: fnd_file.put(FND_FILE.OUTPUT,'T_Basis : Tax Basis S_Basis : Suggested Tax Basis Eff_E_Date : Element Entry Effective End Date');
554: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
555: fnd_file.put(FND_FILE.OUTPUT,'T_Prev : Tax Previous S_Prev : Suggested Tax Previous Eff_S_Date : Element Entry Effective Start Date');
556: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
557: fnd_file.put(FND_FILE.OUTPUT,'P_Prev : Pay Previous S_Prev : Suggested Pay Previous Cpe_S_Date : Start Date of the Continous period of employment');

Line 554: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

550: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
551: fnd_file.put(FND_FILE.OUTPUT,'T_Code : Tax Code S_Code : Suggested Tax Code OVN : Element Entry Object Version Number');
552: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
553: fnd_file.put(FND_FILE.OUTPUT,'T_Basis : Tax Basis S_Basis : Suggested Tax Basis Eff_E_Date : Element Entry Effective End Date');
554: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
555: fnd_file.put(FND_FILE.OUTPUT,'T_Prev : Tax Previous S_Prev : Suggested Tax Previous Eff_S_Date : Element Entry Effective Start Date');
556: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
557: fnd_file.put(FND_FILE.OUTPUT,'P_Prev : Pay Previous S_Prev : Suggested Pay Previous Cpe_S_Date : Start Date of the Continous period of employment');
558: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 555: fnd_file.put(FND_FILE.OUTPUT,'T_Prev : Tax Previous S_Prev : Suggested Tax Previous Eff_S_Date : Element Entry Effective Start Date');

551: fnd_file.put(FND_FILE.OUTPUT,'T_Code : Tax Code S_Code : Suggested Tax Code OVN : Element Entry Object Version Number');
552: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
553: fnd_file.put(FND_FILE.OUTPUT,'T_Basis : Tax Basis S_Basis : Suggested Tax Basis Eff_E_Date : Element Entry Effective End Date');
554: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
555: fnd_file.put(FND_FILE.OUTPUT,'T_Prev : Tax Previous S_Prev : Suggested Tax Previous Eff_S_Date : Element Entry Effective Start Date');
556: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
557: fnd_file.put(FND_FILE.OUTPUT,'P_Prev : Pay Previous S_Prev : Suggested Pay Previous Cpe_S_Date : Start Date of the Continous period of employment');
558: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
559: fnd_file.put(FND_FILE.OUTPUT,'Refund : Refundable Flag S_Refund : Suggested Refundable Flag');

Line 556: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

552: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
553: fnd_file.put(FND_FILE.OUTPUT,'T_Basis : Tax Basis S_Basis : Suggested Tax Basis Eff_E_Date : Element Entry Effective End Date');
554: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
555: fnd_file.put(FND_FILE.OUTPUT,'T_Prev : Tax Previous S_Prev : Suggested Tax Previous Eff_S_Date : Element Entry Effective Start Date');
556: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
557: fnd_file.put(FND_FILE.OUTPUT,'P_Prev : Pay Previous S_Prev : Suggested Pay Previous Cpe_S_Date : Start Date of the Continous period of employment');
558: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
559: fnd_file.put(FND_FILE.OUTPUT,'Refund : Refundable Flag S_Refund : Suggested Refundable Flag');
560: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 557: fnd_file.put(FND_FILE.OUTPUT,'P_Prev : Pay Previous S_Prev : Suggested Pay Previous Cpe_S_Date : Start Date of the Continous period of employment');

553: fnd_file.put(FND_FILE.OUTPUT,'T_Basis : Tax Basis S_Basis : Suggested Tax Basis Eff_E_Date : Element Entry Effective End Date');
554: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
555: fnd_file.put(FND_FILE.OUTPUT,'T_Prev : Tax Previous S_Prev : Suggested Tax Previous Eff_S_Date : Element Entry Effective Start Date');
556: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
557: fnd_file.put(FND_FILE.OUTPUT,'P_Prev : Pay Previous S_Prev : Suggested Pay Previous Cpe_S_Date : Start Date of the Continous period of employment');
558: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
559: fnd_file.put(FND_FILE.OUTPUT,'Refund : Refundable Flag S_Refund : Suggested Refundable Flag');
560: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
561: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 558: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

554: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
555: fnd_file.put(FND_FILE.OUTPUT,'T_Prev : Tax Previous S_Prev : Suggested Tax Previous Eff_S_Date : Element Entry Effective Start Date');
556: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
557: fnd_file.put(FND_FILE.OUTPUT,'P_Prev : Pay Previous S_Prev : Suggested Pay Previous Cpe_S_Date : Start Date of the Continous period of employment');
558: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
559: fnd_file.put(FND_FILE.OUTPUT,'Refund : Refundable Flag S_Refund : Suggested Refundable Flag');
560: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
561: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
562: fnd_file.put(FND_FILE.OUTPUT,'Legends : C --> Cummulative');

Line 559: fnd_file.put(FND_FILE.OUTPUT,'Refund : Refundable Flag S_Refund : Suggested Refundable Flag');

555: fnd_file.put(FND_FILE.OUTPUT,'T_Prev : Tax Previous S_Prev : Suggested Tax Previous Eff_S_Date : Element Entry Effective Start Date');
556: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
557: fnd_file.put(FND_FILE.OUTPUT,'P_Prev : Pay Previous S_Prev : Suggested Pay Previous Cpe_S_Date : Start Date of the Continous period of employment');
558: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
559: fnd_file.put(FND_FILE.OUTPUT,'Refund : Refundable Flag S_Refund : Suggested Refundable Flag');
560: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
561: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
562: fnd_file.put(FND_FILE.OUTPUT,'Legends : C --> Cummulative');
563: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 560: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

556: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
557: fnd_file.put(FND_FILE.OUTPUT,'P_Prev : Pay Previous S_Prev : Suggested Pay Previous Cpe_S_Date : Start Date of the Continous period of employment');
558: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
559: fnd_file.put(FND_FILE.OUTPUT,'Refund : Refundable Flag S_Refund : Suggested Refundable Flag');
560: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
561: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
562: fnd_file.put(FND_FILE.OUTPUT,'Legends : C --> Cummulative');
563: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
564: fnd_file.put(FND_FILE.OUTPUT,'------- N --> Non-Cummulative');

Line 561: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

557: fnd_file.put(FND_FILE.OUTPUT,'P_Prev : Pay Previous S_Prev : Suggested Pay Previous Cpe_S_Date : Start Date of the Continous period of employment');
558: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
559: fnd_file.put(FND_FILE.OUTPUT,'Refund : Refundable Flag S_Refund : Suggested Refundable Flag');
560: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
561: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
562: fnd_file.put(FND_FILE.OUTPUT,'Legends : C --> Cummulative');
563: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
564: fnd_file.put(FND_FILE.OUTPUT,'------- N --> Non-Cummulative');
565: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

Line 562: fnd_file.put(FND_FILE.OUTPUT,'Legends : C --> Cummulative');

558: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
559: fnd_file.put(FND_FILE.OUTPUT,'Refund : Refundable Flag S_Refund : Suggested Refundable Flag');
560: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
561: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
562: fnd_file.put(FND_FILE.OUTPUT,'Legends : C --> Cummulative');
563: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
564: fnd_file.put(FND_FILE.OUTPUT,'------- N --> Non-Cummulative');
565: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
566: fnd_file.put(FND_FILE.OUTPUT,' ~ --> De-limiter');

Line 563: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

559: fnd_file.put(FND_FILE.OUTPUT,'Refund : Refundable Flag S_Refund : Suggested Refundable Flag');
560: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
561: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
562: fnd_file.put(FND_FILE.OUTPUT,'Legends : C --> Cummulative');
563: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
564: fnd_file.put(FND_FILE.OUTPUT,'------- N --> Non-Cummulative');
565: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
566: fnd_file.put(FND_FILE.OUTPUT,' ~ --> De-limiter');
567:

Line 564: fnd_file.put(FND_FILE.OUTPUT,'------- N --> Non-Cummulative');

560: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
561: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
562: fnd_file.put(FND_FILE.OUTPUT,'Legends : C --> Cummulative');
563: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
564: fnd_file.put(FND_FILE.OUTPUT,'------- N --> Non-Cummulative');
565: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
566: fnd_file.put(FND_FILE.OUTPUT,' ~ --> De-limiter');
567:
568:

Line 565: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

561: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
562: fnd_file.put(FND_FILE.OUTPUT,'Legends : C --> Cummulative');
563: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
564: fnd_file.put(FND_FILE.OUTPUT,'------- N --> Non-Cummulative');
565: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
566: fnd_file.put(FND_FILE.OUTPUT,' ~ --> De-limiter');
567:
568:
569: END IF;

Line 566: fnd_file.put(FND_FILE.OUTPUT,' ~ --> De-limiter');

562: fnd_file.put(FND_FILE.OUTPUT,'Legends : C --> Cummulative');
563: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
564: fnd_file.put(FND_FILE.OUTPUT,'------- N --> Non-Cummulative');
565: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
566: fnd_file.put(FND_FILE.OUTPUT,' ~ --> De-limiter');
567:
568:
569: END IF;
570:

Line 573: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

569: END IF;
570:
571: IF paye_future_file.count > 1
572: then
573: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
574: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
575: fnd_file.put(FND_FILE.OUTPUT,'* Please review the log files for any warnings messages.');
576: fnd_file.NEW_LINE(FND_FILE.LOG);
577: fnd_file.NEW_LINE(FND_FILE.LOG);

Line 574: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

570:
571: IF paye_future_file.count > 1
572: then
573: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
574: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
575: fnd_file.put(FND_FILE.OUTPUT,'* Please review the log files for any warnings messages.');
576: fnd_file.NEW_LINE(FND_FILE.LOG);
577: fnd_file.NEW_LINE(FND_FILE.LOG);
578: fnd_file.NEW_LINE(FND_FILE.LOG);

Line 575: fnd_file.put(FND_FILE.OUTPUT,'* Please review the log files for any warnings messages.');

571: IF paye_future_file.count > 1
572: then
573: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
574: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
575: fnd_file.put(FND_FILE.OUTPUT,'* Please review the log files for any warnings messages.');
576: fnd_file.NEW_LINE(FND_FILE.LOG);
577: fnd_file.NEW_LINE(FND_FILE.LOG);
578: fnd_file.NEW_LINE(FND_FILE.LOG);
579: fnd_file.put(FND_FILE.LOG,'The below listed assignments has future dated changes to PAYE Details elements.');

Line 576: fnd_file.NEW_LINE(FND_FILE.LOG);

572: then
573: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
574: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
575: fnd_file.put(FND_FILE.OUTPUT,'* Please review the log files for any warnings messages.');
576: fnd_file.NEW_LINE(FND_FILE.LOG);
577: fnd_file.NEW_LINE(FND_FILE.LOG);
578: fnd_file.NEW_LINE(FND_FILE.LOG);
579: fnd_file.put(FND_FILE.LOG,'The below listed assignments has future dated changes to PAYE Details elements.');
580: fnd_file.NEW_LINE(FND_FILE.LOG);

Line 577: fnd_file.NEW_LINE(FND_FILE.LOG);

573: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
574: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
575: fnd_file.put(FND_FILE.OUTPUT,'* Please review the log files for any warnings messages.');
576: fnd_file.NEW_LINE(FND_FILE.LOG);
577: fnd_file.NEW_LINE(FND_FILE.LOG);
578: fnd_file.NEW_LINE(FND_FILE.LOG);
579: fnd_file.put(FND_FILE.LOG,'The below listed assignments has future dated changes to PAYE Details elements.');
580: fnd_file.NEW_LINE(FND_FILE.LOG);
581: fnd_file.put(FND_FILE.LOG,'Manual update may be required for this records.');

Line 578: fnd_file.NEW_LINE(FND_FILE.LOG);

574: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
575: fnd_file.put(FND_FILE.OUTPUT,'* Please review the log files for any warnings messages.');
576: fnd_file.NEW_LINE(FND_FILE.LOG);
577: fnd_file.NEW_LINE(FND_FILE.LOG);
578: fnd_file.NEW_LINE(FND_FILE.LOG);
579: fnd_file.put(FND_FILE.LOG,'The below listed assignments has future dated changes to PAYE Details elements.');
580: fnd_file.NEW_LINE(FND_FILE.LOG);
581: fnd_file.put(FND_FILE.LOG,'Manual update may be required for this records.');
582: fnd_file.NEW_LINE(FND_FILE.LOG);

Line 579: fnd_file.put(FND_FILE.LOG,'The below listed assignments has future dated changes to PAYE Details elements.');

575: fnd_file.put(FND_FILE.OUTPUT,'* Please review the log files for any warnings messages.');
576: fnd_file.NEW_LINE(FND_FILE.LOG);
577: fnd_file.NEW_LINE(FND_FILE.LOG);
578: fnd_file.NEW_LINE(FND_FILE.LOG);
579: fnd_file.put(FND_FILE.LOG,'The below listed assignments has future dated changes to PAYE Details elements.');
580: fnd_file.NEW_LINE(FND_FILE.LOG);
581: fnd_file.put(FND_FILE.LOG,'Manual update may be required for this records.');
582: fnd_file.NEW_LINE(FND_FILE.LOG);
583: fnd_file.NEW_LINE(FND_FILE.LOG);

Line 580: fnd_file.NEW_LINE(FND_FILE.LOG);

576: fnd_file.NEW_LINE(FND_FILE.LOG);
577: fnd_file.NEW_LINE(FND_FILE.LOG);
578: fnd_file.NEW_LINE(FND_FILE.LOG);
579: fnd_file.put(FND_FILE.LOG,'The below listed assignments has future dated changes to PAYE Details elements.');
580: fnd_file.NEW_LINE(FND_FILE.LOG);
581: fnd_file.put(FND_FILE.LOG,'Manual update may be required for this records.');
582: fnd_file.NEW_LINE(FND_FILE.LOG);
583: fnd_file.NEW_LINE(FND_FILE.LOG);
584: fnd_file.put(FND_FILE.LOG,'Last_Name Assignment_Number Effective_Date');

Line 581: fnd_file.put(FND_FILE.LOG,'Manual update may be required for this records.');

577: fnd_file.NEW_LINE(FND_FILE.LOG);
578: fnd_file.NEW_LINE(FND_FILE.LOG);
579: fnd_file.put(FND_FILE.LOG,'The below listed assignments has future dated changes to PAYE Details elements.');
580: fnd_file.NEW_LINE(FND_FILE.LOG);
581: fnd_file.put(FND_FILE.LOG,'Manual update may be required for this records.');
582: fnd_file.NEW_LINE(FND_FILE.LOG);
583: fnd_file.NEW_LINE(FND_FILE.LOG);
584: fnd_file.put(FND_FILE.LOG,'Last_Name Assignment_Number Effective_Date');
585: fnd_file.NEW_LINE(FND_FILE.LOG);

Line 582: fnd_file.NEW_LINE(FND_FILE.LOG);

578: fnd_file.NEW_LINE(FND_FILE.LOG);
579: fnd_file.put(FND_FILE.LOG,'The below listed assignments has future dated changes to PAYE Details elements.');
580: fnd_file.NEW_LINE(FND_FILE.LOG);
581: fnd_file.put(FND_FILE.LOG,'Manual update may be required for this records.');
582: fnd_file.NEW_LINE(FND_FILE.LOG);
583: fnd_file.NEW_LINE(FND_FILE.LOG);
584: fnd_file.put(FND_FILE.LOG,'Last_Name Assignment_Number Effective_Date');
585: fnd_file.NEW_LINE(FND_FILE.LOG);
586: fnd_file.put(FND_FILE.LOG,'--------- ----------------- ---------------');

Line 583: fnd_file.NEW_LINE(FND_FILE.LOG);

579: fnd_file.put(FND_FILE.LOG,'The below listed assignments has future dated changes to PAYE Details elements.');
580: fnd_file.NEW_LINE(FND_FILE.LOG);
581: fnd_file.put(FND_FILE.LOG,'Manual update may be required for this records.');
582: fnd_file.NEW_LINE(FND_FILE.LOG);
583: fnd_file.NEW_LINE(FND_FILE.LOG);
584: fnd_file.put(FND_FILE.LOG,'Last_Name Assignment_Number Effective_Date');
585: fnd_file.NEW_LINE(FND_FILE.LOG);
586: fnd_file.put(FND_FILE.LOG,'--------- ----------------- ---------------');
587:

Line 584: fnd_file.put(FND_FILE.LOG,'Last_Name Assignment_Number Effective_Date');

580: fnd_file.NEW_LINE(FND_FILE.LOG);
581: fnd_file.put(FND_FILE.LOG,'Manual update may be required for this records.');
582: fnd_file.NEW_LINE(FND_FILE.LOG);
583: fnd_file.NEW_LINE(FND_FILE.LOG);
584: fnd_file.put(FND_FILE.LOG,'Last_Name Assignment_Number Effective_Date');
585: fnd_file.NEW_LINE(FND_FILE.LOG);
586: fnd_file.put(FND_FILE.LOG,'--------- ----------------- ---------------');
587:
588: For i in 1..paye_future_file.last

Line 585: fnd_file.NEW_LINE(FND_FILE.LOG);

581: fnd_file.put(FND_FILE.LOG,'Manual update may be required for this records.');
582: fnd_file.NEW_LINE(FND_FILE.LOG);
583: fnd_file.NEW_LINE(FND_FILE.LOG);
584: fnd_file.put(FND_FILE.LOG,'Last_Name Assignment_Number Effective_Date');
585: fnd_file.NEW_LINE(FND_FILE.LOG);
586: fnd_file.put(FND_FILE.LOG,'--------- ----------------- ---------------');
587:
588: For i in 1..paye_future_file.last
589: LOOP

Line 586: fnd_file.put(FND_FILE.LOG,'--------- ----------------- ---------------');

582: fnd_file.NEW_LINE(FND_FILE.LOG);
583: fnd_file.NEW_LINE(FND_FILE.LOG);
584: fnd_file.put(FND_FILE.LOG,'Last_Name Assignment_Number Effective_Date');
585: fnd_file.NEW_LINE(FND_FILE.LOG);
586: fnd_file.put(FND_FILE.LOG,'--------- ----------------- ---------------');
587:
588: For i in 1..paye_future_file.last
589: LOOP
590:

Line 591: fnd_file.NEW_LINE(FND_FILE.LOG);

587:
588: For i in 1..paye_future_file.last
589: LOOP
590:
591: fnd_file.NEW_LINE(FND_FILE.LOG);
592: fnd_file.put(FND_FILE.LOG,rpad(paye_future_file(i).l_name,27,' ')||rpad(paye_future_file(i).assignment_num,28,' ')||to_char(paye_future_file(i).effective_date,'dd-MON-YYY'));
593:
594: END LOOP;
595:

Line 592: fnd_file.put(FND_FILE.LOG,rpad(paye_future_file(i).l_name,27,' ')||rpad(paye_future_file(i).assignment_num,28,' ')||to_char(paye_future_file(i).effective_date,'dd-MON-YYY'));

588: For i in 1..paye_future_file.last
589: LOOP
590:
591: fnd_file.NEW_LINE(FND_FILE.LOG);
592: fnd_file.put(FND_FILE.LOG,rpad(paye_future_file(i).l_name,27,' ')||rpad(paye_future_file(i).assignment_num,28,' ')||to_char(paye_future_file(i).effective_date,'dd-MON-YYY'));
593:
594: END LOOP;
595:
596: fnd_file.NEW_LINE(FND_FILE.LOG);

Line 596: fnd_file.NEW_LINE(FND_FILE.LOG);

592: fnd_file.put(FND_FILE.LOG,rpad(paye_future_file(i).l_name,27,' ')||rpad(paye_future_file(i).assignment_num,28,' ')||to_char(paye_future_file(i).effective_date,'dd-MON-YYY'));
593:
594: END LOOP;
595:
596: fnd_file.NEW_LINE(FND_FILE.LOG);
597: fnd_file.NEW_LINE(FND_FILE.LOG);
598: fnd_file.NEW_LINE(FND_FILE.LOG);
599: fnd_file.NEW_LINE(FND_FILE.LOG);
600: paye_future_file.delete;

Line 597: fnd_file.NEW_LINE(FND_FILE.LOG);

593:
594: END LOOP;
595:
596: fnd_file.NEW_LINE(FND_FILE.LOG);
597: fnd_file.NEW_LINE(FND_FILE.LOG);
598: fnd_file.NEW_LINE(FND_FILE.LOG);
599: fnd_file.NEW_LINE(FND_FILE.LOG);
600: paye_future_file.delete;
601:

Line 598: fnd_file.NEW_LINE(FND_FILE.LOG);

594: END LOOP;
595:
596: fnd_file.NEW_LINE(FND_FILE.LOG);
597: fnd_file.NEW_LINE(FND_FILE.LOG);
598: fnd_file.NEW_LINE(FND_FILE.LOG);
599: fnd_file.NEW_LINE(FND_FILE.LOG);
600: paye_future_file.delete;
601:
602: END IF;

Line 599: fnd_file.NEW_LINE(FND_FILE.LOG);

595:
596: fnd_file.NEW_LINE(FND_FILE.LOG);
597: fnd_file.NEW_LINE(FND_FILE.LOG);
598: fnd_file.NEW_LINE(FND_FILE.LOG);
599: fnd_file.NEW_LINE(FND_FILE.LOG);
600: paye_future_file.delete;
601:
602: END IF;
603:

Line 995: fnd_file.PUT_LINE(FND_FILE.LOG, 'Directory:'|| l_location);

991:
992: hr_utility.set_location( l_pkg ||'PAYE Upload',5);
993: l_filename := p_filename;
994: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
995: fnd_file.PUT_LINE(FND_FILE.LOG, 'Directory:'|| l_location);
996: fnd_file.PUT_LINE(FND_FILE.LOG, 'File Name:'|| l_filename);
997: fnd_file.PUT_LINE(FND_FILE.LOG, 'Run Mode:'||P_RUN_MODE);
998:
999: IF l_location IS NULL

Line 996: fnd_file.PUT_LINE(FND_FILE.LOG, 'File Name:'|| l_filename);

992: hr_utility.set_location( l_pkg ||'PAYE Upload',5);
993: l_filename := p_filename;
994: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
995: fnd_file.PUT_LINE(FND_FILE.LOG, 'Directory:'|| l_location);
996: fnd_file.PUT_LINE(FND_FILE.LOG, 'File Name:'|| l_filename);
997: fnd_file.PUT_LINE(FND_FILE.LOG, 'Run Mode:'||P_RUN_MODE);
998:
999: IF l_location IS NULL
1000: THEN

Line 997: fnd_file.PUT_LINE(FND_FILE.LOG, 'Run Mode:'||P_RUN_MODE);

993: l_filename := p_filename;
994: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
995: fnd_file.PUT_LINE(FND_FILE.LOG, 'Directory:'|| l_location);
996: fnd_file.PUT_LINE(FND_FILE.LOG, 'File Name:'|| l_filename);
997: fnd_file.PUT_LINE(FND_FILE.LOG, 'Run Mode:'||P_RUN_MODE);
998:
999: IF l_location IS NULL
1000: THEN
1001: -- error : I/O directory not defined

Line 1020: fnd_file.PUT_LINE(FND_FILE.LOG, 'P_PAYE_ELE_ID:'||P_PAYE_ELE_ID);

1016: errbuf := 'PAYE Details element not found in the system.';
1017: raise e_fatal_error;
1018: END IF;
1019:
1020: fnd_file.PUT_LINE(FND_FILE.LOG, 'P_PAYE_ELE_ID:'||P_PAYE_ELE_ID);
1021: l_file_handle := utl_file.fopen(l_location,l_filename,'r');
1022: utl_file.get_line(l_file_handle,l_present_line);
1023:
1024: BEGIN

Line 1057: fnd_file.PUT_LINE(FND_FILE.LOG,'Download Parameters section altered.');

1053: IF ((download_cp_eff_date is null) or (download_cp_tax_ref is null) or (download_cp_req_id is null))
1054: THEN
1055: retcode := 2;
1056: errbuf := 'Invalid file format.';
1057: fnd_file.PUT_LINE(FND_FILE.LOG,'Download Parameters section altered.');
1058: hr_utility.trace( l_pkg ||'download_cp_eff_date is null or download_cp_tax_ref is null or download_cp_req_id is null');
1059: raise invalid_file_format;
1060: END IF;
1061:

Line 1077: fnd_file.PUT_LINE(FND_FILE.LOG,'Download Parameters section altered.');

1073: if ((l_arg1 <> download_cp_tax_ref) or
1074: (l_arg2 <> download_cp_eff_date)) then
1075: retcode := 2;
1076: errbuf := 'Download Parameters section altered.';
1077: fnd_file.PUT_LINE(FND_FILE.LOG,'Download Parameters section altered.');
1078: hr_utility.trace( l_pkg ||'download_cp_tax_ref :'||download_cp_tax_ref);
1079: hr_utility.trace( l_pkg ||'Download Request tax ref Argument :'||l_arg1);
1080: hr_utility.trace( l_pkg ||'download_cp_eff_date :'||download_cp_eff_date);
1081: hr_utility.trace( l_pkg ||'Download Request eff date Argument :'||l_arg2);

Line 1089: fnd_file.PUT_LINE(FND_FILE.LOG,'Download Parameters Request ID '||download_cp_req_id||' does not exist in the system');

1085: exception
1086: when no_data_found then
1087: retcode := 2;
1088: errbuf := 'Download Parameters Request ID '||download_cp_req_id||' does not exist in the system';
1089: fnd_file.PUT_LINE(FND_FILE.LOG,'Download Parameters Request ID '||download_cp_req_id||' does not exist in the system');
1090: raise invalid_file_format;
1091: end;
1092:
1093: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp req_id :'||download_cp_req_id);

Line 1093: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp req_id :'||download_cp_req_id);

1089: fnd_file.PUT_LINE(FND_FILE.LOG,'Download Parameters Request ID '||download_cp_req_id||' does not exist in the system');
1090: raise invalid_file_format;
1091: end;
1092:
1093: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp req_id :'||download_cp_req_id);
1094: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp tax_ref :'||download_cp_tax_ref);
1095: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp eff_date :'||download_cp_eff_date);
1096:
1097: ELSE --Beginning line is not 'Download Parameters'

Line 1094: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp tax_ref :'||download_cp_tax_ref);

1090: raise invalid_file_format;
1091: end;
1092:
1093: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp req_id :'||download_cp_req_id);
1094: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp tax_ref :'||download_cp_tax_ref);
1095: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp eff_date :'||download_cp_eff_date);
1096:
1097: ELSE --Beginning line is not 'Download Parameters'
1098: retcode := 2;

Line 1095: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp eff_date :'||download_cp_eff_date);

1091: end;
1092:
1093: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp req_id :'||download_cp_req_id);
1094: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp tax_ref :'||download_cp_tax_ref);
1095: fnd_file.PUT_LINE(FND_FILE.LOG,'Download cp eff_date :'||download_cp_eff_date);
1096:
1097: ELSE --Beginning line is not 'Download Parameters'
1098: retcode := 2;
1099: errbuf := 'Invalid file format.';

Line 1100: fnd_file.PUT_LINE(FND_FILE.LOG,'File not started with Download Parameters section.');

1096:
1097: ELSE --Beginning line is not 'Download Parameters'
1098: retcode := 2;
1099: errbuf := 'Invalid file format.';
1100: fnd_file.PUT_LINE(FND_FILE.LOG,'File not started with Download Parameters section.');
1101: hr_utility.trace( l_pkg ||'Beginning line is :'||l_present_line);
1102: raise invalid_file_format;
1103: END IF;
1104:

Line 1122: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'No Records Found in the file mentioned. ('||l_filename||')');

1118: ELSIF (substr(l_present_line,1,16)='No Records Found')
1119: THEN
1120: retcode := 0;
1121: errbuf := 'No Records found in the file mentioned.';
1122: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'No Records Found in the file mentioned. ('||l_filename||')');
1123: raise no_rec_found_in_file;
1124:
1125: ELSIF (l_present_line is null)
1126: THEN

Line 1147: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Could not find any records to be updated or the No Records Found message in the mentioned file.');

1143: WHEN NO_DATA_FOUND
1144: THEN
1145: retcode := 2;
1146: errbuf := 'Invalid file format.';
1147: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Could not find any records to be updated or the No Records Found message in the mentioned file.');
1148: raise invalid_file_format;
1149: END;
1150:
1151: /* Records found for processing. Loop through the records, identify the columns,

Line 1164: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Delimiter count is not as expected. Record Format altered.');

1160:
1161: if (count_tokens(l_present_line) <> 19) then
1162: retcode := 2;
1163: errbuf := 'Record Format altered.';
1164: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Delimiter count is not as expected. Record Format altered.');
1165: raise invalid_file_format;
1166: end if;
1167:
1168: tab_paye_file(l_record_no).last_name := get_token(l_present_line,1);

Line 1244: fnd_file.PUT_LINE(FND_FILE.LOG, 'Reading File complete. Total Records present :'||l_record_no);

1240: END;
1241:
1242: END LOOP;
1243:
1244: fnd_file.PUT_LINE(FND_FILE.LOG, 'Reading File complete. Total Records present :'||l_record_no);
1245: utl_file.fclose(l_file_handle);
1246:
1247: /* Loop through the assignments and validate them. Below are the list of validations:
1248: 1. Check if the assignment details are not changed after download program.

Line 1296: fnd_file.PUT_LINE(FND_FILE.LOG, 'No records found on the mentioned date for assignment '||tab_paye_file(l_count).assignment_number);

1292:
1293: IF (csr_db_paye_det%notfound)
1294: THEN
1295:
1296: fnd_file.PUT_LINE(FND_FILE.LOG, 'No records found on the mentioned date for assignment '||tab_paye_file(l_count).assignment_number);
1297: set_person_level_error_mesg(l_person_index, tab_paye_file(l_count).person_id, tab_paye_file(l_count).cpe_start_date,'PAYE Details for assignment(s) of this person, changed in the database.');
1298:
1299: END IF;
1300:

Line 1329: fnd_file.PUT_LINE(FND_FILE.LOG, 'Compare with DB Failed for assignment'||tab_paye_file(l_count).assignment_number);

1325: IF (tab_paye_file(l_count).err_message is null) then
1326: IF NOT(compare_file_db_details(l_count, db_paye_details))
1327: THEN
1328:
1329: fnd_file.PUT_LINE(FND_FILE.LOG, 'Compare with DB Failed for assignment'||tab_paye_file(l_count).assignment_number);
1330: set_person_level_error_mesg(l_person_index, tab_paye_file(l_count).person_id, tab_paye_file(l_count).cpe_start_date, 'PAYE Details for assignment(s) of this person, changed in the database.');
1331:
1332: END IF;
1333: end if;

Line 1383: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'List of Assignments Successfully Uploaded:');

1379: */
1380: BEGIN
1381: --SAVEPOINT PRE_STATE;
1382:
1383: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'List of Assignments Successfully Uploaded:');
1384: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad('Person Name',20,' ')||rpad('Assignment Num',20,' ')||rpad('Comments',30,' '));
1385: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad('-----------',20,' ')||rpad('--------------',20,' ')||rpad('--------',30,' '));
1386:
1387: FOR l_count in 0..(l_record_no-1)

Line 1384: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad('Person Name',20,' ')||rpad('Assignment Num',20,' ')||rpad('Comments',30,' '));

1380: BEGIN
1381: --SAVEPOINT PRE_STATE;
1382:
1383: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'List of Assignments Successfully Uploaded:');
1384: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad('Person Name',20,' ')||rpad('Assignment Num',20,' ')||rpad('Comments',30,' '));
1385: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad('-----------',20,' ')||rpad('--------------',20,' ')||rpad('--------',30,' '));
1386:
1387: FOR l_count in 0..(l_record_no-1)
1388: LOOP

Line 1385: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad('-----------',20,' ')||rpad('--------------',20,' ')||rpad('--------',30,' '));

1381: --SAVEPOINT PRE_STATE;
1382:
1383: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'List of Assignments Successfully Uploaded:');
1384: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad('Person Name',20,' ')||rpad('Assignment Num',20,' ')||rpad('Comments',30,' '));
1385: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad('-----------',20,' ')||rpad('--------------',20,' ')||rpad('--------',30,' '));
1386:
1387: FOR l_count in 0..(l_record_no-1)
1388: LOOP
1389:

Line 1392: fnd_file.PUT_LINE(FND_FILE.LOG,'Processing assignment '||tab_paye_file(l_count).assignment_number||' record.');

1388: LOOP
1389:
1390: IF (tab_paye_file(l_count).err_message is null)
1391: THEN
1392: fnd_file.PUT_LINE(FND_FILE.LOG,'Processing assignment '||tab_paye_file(l_count).assignment_number||' record.');
1393: IF (tab_paye_file(l_count).record_changed = 'N')
1394: THEN
1395:
1396: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad(tab_paye_file(l_count).last_name,20,' ')||rpad(tab_paye_file(l_count).assignment_number,20,' ')||'No Change');

Line 1396: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad(tab_paye_file(l_count).last_name,20,' ')||rpad(tab_paye_file(l_count).assignment_number,20,' ')||'No Change');

1392: fnd_file.PUT_LINE(FND_FILE.LOG,'Processing assignment '||tab_paye_file(l_count).assignment_number||' record.');
1393: IF (tab_paye_file(l_count).record_changed = 'N')
1394: THEN
1395:
1396: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad(tab_paye_file(l_count).last_name,20,' ')||rpad(tab_paye_file(l_count).assignment_number,20,' ')||'No Change');
1397:
1398: ELSIF (nvl(tab_paye_file(l_count).record_changed,'Y') = 'Y')
1399: THEN
1400:

Line 1441: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad(tab_paye_file(l_count).last_name,20,' ')||rpad(tab_paye_file(l_count).assignment_number,20,' ')||'Record Updated');

1437:
1438: -- For bug 8485686
1439: pqp_gb_ad_ee.g_global_paye_validation := 'Y';
1440:
1441: fnd_file.PUT_LINE(FND_FILE.OUTPUT,rpad(tab_paye_file(l_count).last_name,20,' ')||rpad(tab_paye_file(l_count).assignment_number,20,' ')||'Record Updated');
1442:
1443: EXCEPTION
1444: WHEN OTHERS
1445: THEN

Line 1446: fnd_file.NEW_LINE(FND_FILE.OUTPUT);

1442:
1443: EXCEPTION
1444: WHEN OTHERS
1445: THEN
1446: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
1447: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Errored for Assignment Number : '||tab_paye_file(l_count).assignment_number);
1448: --ROLLBACK TO PRE_STATE;
1449: raise;
1450: END;

Line 1447: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Errored for Assignment Number : '||tab_paye_file(l_count).assignment_number);

1443: EXCEPTION
1444: WHEN OTHERS
1445: THEN
1446: fnd_file.NEW_LINE(FND_FILE.OUTPUT);
1447: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Errored for Assignment Number : '||tab_paye_file(l_count).assignment_number);
1448: --ROLLBACK TO PRE_STATE;
1449: raise;
1450: END;
1451:

Line 1469: fnd_file.PUT_LINE(FND_FILE.OUTPUT,sqlerrm);

1465:
1466: EXCEPTION
1467: WHEN OTHERS
1468: THEN
1469: fnd_file.PUT_LINE(FND_FILE.OUTPUT,sqlerrm);
1470: --ROLLBACK TO PRE_STATE;
1471: raise;
1472:
1473: END;

Line 1476: fnd_file.PUT_LINE(FND_FILE.OUTPUT,' ');

1472:
1473: END;
1474:
1475: /* Report the errored assignments in the output file and clear the plsql table */
1476: fnd_file.PUT_LINE(FND_FILE.OUTPUT,' ');
1477: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'List of Failed Assignments:');
1478: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD('Person Name',20,' ')||RPAD('Assignment Number',20,' ')||RPAD('Error Message',200,' '));
1479: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD('-----------',20,' ')||RPAD('-----------------',20,' ')||RPAD('-------------',200,' '));
1480:

Line 1477: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'List of Failed Assignments:');

1473: END;
1474:
1475: /* Report the errored assignments in the output file and clear the plsql table */
1476: fnd_file.PUT_LINE(FND_FILE.OUTPUT,' ');
1477: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'List of Failed Assignments:');
1478: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD('Person Name',20,' ')||RPAD('Assignment Number',20,' ')||RPAD('Error Message',200,' '));
1479: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD('-----------',20,' ')||RPAD('-----------------',20,' ')||RPAD('-------------',200,' '));
1480:
1481: FOR l_count in 0..(l_record_no-1)

Line 1478: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD('Person Name',20,' ')||RPAD('Assignment Number',20,' ')||RPAD('Error Message',200,' '));

1474:
1475: /* Report the errored assignments in the output file and clear the plsql table */
1476: fnd_file.PUT_LINE(FND_FILE.OUTPUT,' ');
1477: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'List of Failed Assignments:');
1478: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD('Person Name',20,' ')||RPAD('Assignment Number',20,' ')||RPAD('Error Message',200,' '));
1479: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD('-----------',20,' ')||RPAD('-----------------',20,' ')||RPAD('-------------',200,' '));
1480:
1481: FOR l_count in 0..(l_record_no-1)
1482: LOOP

Line 1479: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD('-----------',20,' ')||RPAD('-----------------',20,' ')||RPAD('-------------',200,' '));

1475: /* Report the errored assignments in the output file and clear the plsql table */
1476: fnd_file.PUT_LINE(FND_FILE.OUTPUT,' ');
1477: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'List of Failed Assignments:');
1478: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD('Person Name',20,' ')||RPAD('Assignment Number',20,' ')||RPAD('Error Message',200,' '));
1479: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD('-----------',20,' ')||RPAD('-----------------',20,' ')||RPAD('-------------',200,' '));
1480:
1481: FOR l_count in 0..(l_record_no-1)
1482: LOOP
1483:

Line 1486: fnd_file.PUT_LINE(FND_FILE.OUTPUT, RPAD(tab_paye_file(l_count).last_name,20,' ')||RPAD(tab_paye_file(l_count).assignment_number,20,' ')||RPAD(tab_paye_file(l_count).err_message,200,' '));

1482: LOOP
1483:
1484: IF (tab_paye_file(l_count).err_message is not null)
1485: THEN
1486: fnd_file.PUT_LINE(FND_FILE.OUTPUT, RPAD(tab_paye_file(l_count).last_name,20,' ')||RPAD(tab_paye_file(l_count).assignment_number,20,' ')||RPAD(tab_paye_file(l_count).err_message,200,' '));
1487: END IF ;
1488:
1489: tab_paye_file.delete(l_count);
1490:

Line 1492: fnd_file.PUT_LINE(FND_FILE.LOG, 'Program Completed Sucessfully.');

1488:
1489: tab_paye_file.delete(l_count);
1490:
1491: END LOOP;
1492: fnd_file.PUT_LINE(FND_FILE.LOG, 'Program Completed Sucessfully.');
1493: hr_utility.set_location( l_pkg ||'PAYE Upload',80);
1494: EXCEPTION
1495: WHEN e_fatal_error
1496: THEN