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 HR_UTILITY

Line 311: -- hr_utility.trace_on(null,'paye');

307: END check_future_changes;
308:
309: BEGIN
310:
311: -- hr_utility.trace_on(null,'paye');
312:
313: -- Store the BG id, Tax Ref and Effective date in local variable
314: l_tax_ref := p_tax_ref;
315: l_effective_date := fnd_date.canonical_to_date(p_eff_date);

Line 327: hr_utility.set_location('Effective Date is between tax start year and Current date',6);

323: /* Check whether Effective date is between 06-Apr-2009 and sysdate (Current Date) */
324:
325: IF l_effective_date BETWEEN to_date('06/04/2009','dd/mm/yyyy') AND sysdate
326: THEN
327: hr_utility.set_location('Effective Date is between tax start year and Current date',6);
328: ELSE
329: hr_utility.set_location('The Effective Date must be between 06-Apr-2009 and Current Date.',8);
330: RAISE paye_sync_eff_date;
331: END IF;

Line 329: hr_utility.set_location('The Effective Date must be between 06-Apr-2009 and Current Date.',8);

325: IF l_effective_date BETWEEN to_date('06/04/2009','dd/mm/yyyy') AND sysdate
326: THEN
327: hr_utility.set_location('Effective Date is between tax start year and Current date',6);
328: ELSE
329: hr_utility.set_location('The Effective Date must be between 06-Apr-2009 and Current Date.',8);
330: RAISE paye_sync_eff_date;
331: END IF;
332:
333:

Line 334: hr_utility.set_location('step1 l_effective_date '|| to_char(l_effective_date,'DD-MON-YYYY') ,10);

330: RAISE paye_sync_eff_date;
331: END IF;
332:
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);

Line 349: hr_utility.set_location('step2',20);

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: -------------------------------------------------
352: /* Get the Soft coding id for the tax reference */
353: -------------------------------------------------

Line 388: hr_utility.set_location('Step3 l_sft_coding_id :' || l_sft_coding_id ,15);

384: ------------------------------------------------------------
385: /* Collect All Aggregated assignments for the given Tax Ref*/
386: ------------------------------------------------------------
387:
388: hr_utility.set_location('Step3 l_sft_coding_id :' || l_sft_coding_id ,15);
389:
390: FOR i in c_get_agg_person(L_BUSINESS_GROUP_ID,
391: l_effective_date
392: )

Line 395: hr_utility.set_location('Step4 l_ele_type_id :' || l_ele_type_id ,20);

391: l_effective_date
392: )
393: LOOP
394:
395: hr_utility.set_location('Step4 l_ele_type_id :' || l_ele_type_id ,20);
396:
397: l_person_id := i.person_id;
398:
399: /* BEGIN -- call the below procedure to check if any future dated changes exists */

Line 405: hr_utility.set_location('Step5',25);

401: check_future_changes(l_person_id,l_effective_date,l_ele_type_id,l_tax_ref);
402:
403: /* END -- call the below procedure to check if any future dated changes exists */
404:
405: hr_utility.set_location('Step5',25);
406:
407: FOR i IN c_get_count(l_person_id)
408: LOOP
409:

Line 415: hr_utility.set_location('Step6 count: ' || i.cnt ,25);

411: THEN
412:
413: l_curr_cpe_start_date := i.cpe_date;
414:
415: hr_utility.set_location('Step6 count: ' || i.cnt ,25);
416: hr_utility.set_location('Step6 l_curr_cpe_start_date ' || l_curr_cpe_start_date ,25);
417:
418: IF j_count = 0
419: THEN

Line 416: hr_utility.set_location('Step6 l_curr_cpe_start_date ' || l_curr_cpe_start_date ,25);

412:
413: l_curr_cpe_start_date := i.cpe_date;
414:
415: hr_utility.set_location('Step6 count: ' || i.cnt ,25);
416: hr_utility.set_location('Step6 l_curr_cpe_start_date ' || l_curr_cpe_start_date ,25);
417:
418: IF j_count = 0
419: THEN
420:

Line 455: hr_utility.set_location('Step7 l_tax_ref' || l_tax_ref,10);

451: j_count := 1;
452:
453: END IF;
454:
455: hr_utility.set_location('Step7 l_tax_ref' || l_tax_ref,10);
456: hr_utility.set_location('Step7 l_person_id' || l_person_id,10);
457: hr_utility.set_location('Step7 l_ele_type_id' || l_ele_type_id,10);
458: hr_utility.set_location('Step7 l_sft_coding_id' || l_sft_coding_id,10);
459: hr_utility.set_location('Step7 l_effective_date' || l_effective_date,10);

Line 456: hr_utility.set_location('Step7 l_person_id' || l_person_id,10);

452:
453: END IF;
454:
455: hr_utility.set_location('Step7 l_tax_ref' || l_tax_ref,10);
456: hr_utility.set_location('Step7 l_person_id' || l_person_id,10);
457: hr_utility.set_location('Step7 l_ele_type_id' || l_ele_type_id,10);
458: hr_utility.set_location('Step7 l_sft_coding_id' || l_sft_coding_id,10);
459: hr_utility.set_location('Step7 l_effective_date' || l_effective_date,10);
460:

Line 457: hr_utility.set_location('Step7 l_ele_type_id' || l_ele_type_id,10);

453: END IF;
454:
455: hr_utility.set_location('Step7 l_tax_ref' || l_tax_ref,10);
456: hr_utility.set_location('Step7 l_person_id' || l_person_id,10);
457: hr_utility.set_location('Step7 l_ele_type_id' || l_ele_type_id,10);
458: hr_utility.set_location('Step7 l_sft_coding_id' || l_sft_coding_id,10);
459: hr_utility.set_location('Step7 l_effective_date' || l_effective_date,10);
460:
461: --Loop throught the result set and write the details to the Output File.

Line 458: hr_utility.set_location('Step7 l_sft_coding_id' || l_sft_coding_id,10);

454:
455: hr_utility.set_location('Step7 l_tax_ref' || l_tax_ref,10);
456: hr_utility.set_location('Step7 l_person_id' || l_person_id,10);
457: hr_utility.set_location('Step7 l_ele_type_id' || l_ele_type_id,10);
458: hr_utility.set_location('Step7 l_sft_coding_id' || l_sft_coding_id,10);
459: hr_utility.set_location('Step7 l_effective_date' || l_effective_date,10);
460:
461: --Loop throught the result set and write the details to the Output File.
462: FOR required_info in c_get_details(l_person_id,

Line 459: hr_utility.set_location('Step7 l_effective_date' || l_effective_date,10);

455: hr_utility.set_location('Step7 l_tax_ref' || l_tax_ref,10);
456: hr_utility.set_location('Step7 l_person_id' || l_person_id,10);
457: hr_utility.set_location('Step7 l_ele_type_id' || l_ele_type_id,10);
458: hr_utility.set_location('Step7 l_sft_coding_id' || l_sft_coding_id,10);
459: hr_utility.set_location('Step7 l_effective_date' || l_effective_date,10);
460:
461: --Loop throught the result set and write the details to the Output File.
462: FOR required_info in c_get_details(l_person_id,
463: l_ele_type_id,

Line 471: hr_utility.set_location('Step8',10);

467: l_curr_cpe_start_date
468: )
469: LOOP
470:
471: hr_utility.set_location('Step8',10);
472:
473: IF (l_last_person_id <> required_info.pid)
474: THEN
475:

Line 505: hr_utility.set_location('Step9 l_last_cpe_st_date '|| l_last_cpe_st_date,10);

501: END IF;
502:
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

Line 819: hr_utility.trace( l_pkg ||'Parameters: l_count :'||l_count);

815: l_refundable varchar2(100);
816:
817: BEGIN
818: /* Debug Information */
819: hr_utility.trace( l_pkg ||'Parameters: l_count :'||l_count);
820: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).person_id||'::DB-'||db_rec.person_id);
821: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_id||'::DB-'||db_rec.assignment_id);
822: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_number||'::DB-'||db_rec.assignment_number);
823: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).last_name||'::DB-'||db_rec.last_name);

Line 820: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).person_id||'::DB-'||db_rec.person_id);

816:
817: BEGIN
818: /* Debug Information */
819: hr_utility.trace( l_pkg ||'Parameters: l_count :'||l_count);
820: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).person_id||'::DB-'||db_rec.person_id);
821: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_id||'::DB-'||db_rec.assignment_id);
822: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_number||'::DB-'||db_rec.assignment_number);
823: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).last_name||'::DB-'||db_rec.last_name);
824: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_start_date||'::DB-'||db_rec.effective_start_date);

Line 821: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_id||'::DB-'||db_rec.assignment_id);

817: BEGIN
818: /* Debug Information */
819: hr_utility.trace( l_pkg ||'Parameters: l_count :'||l_count);
820: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).person_id||'::DB-'||db_rec.person_id);
821: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_id||'::DB-'||db_rec.assignment_id);
822: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_number||'::DB-'||db_rec.assignment_number);
823: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).last_name||'::DB-'||db_rec.last_name);
824: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_start_date||'::DB-'||db_rec.effective_start_date);
825: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_end_date||'::DB-'||db_rec.effective_end_date);

Line 822: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_number||'::DB-'||db_rec.assignment_number);

818: /* Debug Information */
819: hr_utility.trace( l_pkg ||'Parameters: l_count :'||l_count);
820: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).person_id||'::DB-'||db_rec.person_id);
821: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_id||'::DB-'||db_rec.assignment_id);
822: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_number||'::DB-'||db_rec.assignment_number);
823: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).last_name||'::DB-'||db_rec.last_name);
824: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_start_date||'::DB-'||db_rec.effective_start_date);
825: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_end_date||'::DB-'||db_rec.effective_end_date);
826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);

Line 823: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).last_name||'::DB-'||db_rec.last_name);

819: hr_utility.trace( l_pkg ||'Parameters: l_count :'||l_count);
820: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).person_id||'::DB-'||db_rec.person_id);
821: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_id||'::DB-'||db_rec.assignment_id);
822: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_number||'::DB-'||db_rec.assignment_number);
823: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).last_name||'::DB-'||db_rec.last_name);
824: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_start_date||'::DB-'||db_rec.effective_start_date);
825: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_end_date||'::DB-'||db_rec.effective_end_date);
826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);
827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);

Line 824: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_start_date||'::DB-'||db_rec.effective_start_date);

820: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).person_id||'::DB-'||db_rec.person_id);
821: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_id||'::DB-'||db_rec.assignment_id);
822: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_number||'::DB-'||db_rec.assignment_number);
823: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).last_name||'::DB-'||db_rec.last_name);
824: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_start_date||'::DB-'||db_rec.effective_start_date);
825: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_end_date||'::DB-'||db_rec.effective_end_date);
826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);
827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);
828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);

Line 825: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_end_date||'::DB-'||db_rec.effective_end_date);

821: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_id||'::DB-'||db_rec.assignment_id);
822: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_number||'::DB-'||db_rec.assignment_number);
823: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).last_name||'::DB-'||db_rec.last_name);
824: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_start_date||'::DB-'||db_rec.effective_start_date);
825: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_end_date||'::DB-'||db_rec.effective_end_date);
826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);
827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);
828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);
829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));

Line 826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);

822: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).assignment_number||'::DB-'||db_rec.assignment_number);
823: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).last_name||'::DB-'||db_rec.last_name);
824: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_start_date||'::DB-'||db_rec.effective_start_date);
825: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_end_date||'::DB-'||db_rec.effective_end_date);
826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);
827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);
828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);
829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));
830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));

Line 827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);

823: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).last_name||'::DB-'||db_rec.last_name);
824: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_start_date||'::DB-'||db_rec.effective_start_date);
825: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_end_date||'::DB-'||db_rec.effective_end_date);
826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);
827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);
828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);
829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));
830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));
831: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_pay||'::DB-'||nvl(db_rec.pay_previous,0));

Line 828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);

824: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_start_date||'::DB-'||db_rec.effective_start_date);
825: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_end_date||'::DB-'||db_rec.effective_end_date);
826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);
827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);
828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);
829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));
830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));
831: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_pay||'::DB-'||nvl(db_rec.pay_previous,0));
832: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_tax||'::DB-'||nvl(db_rec.tax_previous,0));

Line 829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));

825: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_end_date||'::DB-'||db_rec.effective_end_date);
826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);
827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);
828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);
829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));
830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));
831: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_pay||'::DB-'||nvl(db_rec.pay_previous,0));
832: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_tax||'::DB-'||nvl(db_rec.tax_previous,0));
833: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).authority||'::DB-'||db_rec.authority);

Line 830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));

826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);
827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);
828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);
829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));
830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));
831: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_pay||'::DB-'||nvl(db_rec.pay_previous,0));
832: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_tax||'::DB-'||nvl(db_rec.tax_previous,0));
833: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).authority||'::DB-'||db_rec.authority);
834: /* End Debug information */

Line 831: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_pay||'::DB-'||nvl(db_rec.pay_previous,0));

827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);
828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);
829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));
830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));
831: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_pay||'::DB-'||nvl(db_rec.pay_previous,0));
832: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_tax||'::DB-'||nvl(db_rec.tax_previous,0));
833: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).authority||'::DB-'||db_rec.authority);
834: /* End Debug information */
835:

Line 832: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_tax||'::DB-'||nvl(db_rec.tax_previous,0));

828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);
829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));
830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));
831: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_pay||'::DB-'||nvl(db_rec.pay_previous,0));
832: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_tax||'::DB-'||nvl(db_rec.tax_previous,0));
833: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).authority||'::DB-'||db_rec.authority);
834: /* End Debug information */
835:
836: IF((nvl(tab_paye_file(l_count).person_id, -1) = db_rec.person_id) and

Line 833: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).authority||'::DB-'||db_rec.authority);

829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));
830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));
831: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_pay||'::DB-'||nvl(db_rec.pay_previous,0));
832: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_tax||'::DB-'||nvl(db_rec.tax_previous,0));
833: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).authority||'::DB-'||db_rec.authority);
834: /* End Debug information */
835:
836: IF((nvl(tab_paye_file(l_count).person_id, -1) = db_rec.person_id) and
837: (nvl(tab_paye_file(l_count).assignment_id, -1) = db_rec.assignment_id) and

Line 891: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_START_INDEX :'||P_PERSON_START_INDEX);

887:
888: v_person_start_index number;
889:
890: BEGIN
891: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_START_INDEX :'||P_PERSON_START_INDEX);
892: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_ID :'||P_PERSON_ID);
893: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_CPE Start :'||P_PERSON_CPE);
894: hr_utility.trace( l_pkg ||'Parameters: P_ERR_MSG :'||P_ERR_MSG);
895:

Line 892: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_ID :'||P_PERSON_ID);

888: v_person_start_index number;
889:
890: BEGIN
891: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_START_INDEX :'||P_PERSON_START_INDEX);
892: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_ID :'||P_PERSON_ID);
893: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_CPE Start :'||P_PERSON_CPE);
894: hr_utility.trace( l_pkg ||'Parameters: P_ERR_MSG :'||P_ERR_MSG);
895:
896: v_person_start_index := P_PERSON_START_INDEX;

Line 893: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_CPE Start :'||P_PERSON_CPE);

889:
890: BEGIN
891: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_START_INDEX :'||P_PERSON_START_INDEX);
892: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_ID :'||P_PERSON_ID);
893: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_CPE Start :'||P_PERSON_CPE);
894: hr_utility.trace( l_pkg ||'Parameters: P_ERR_MSG :'||P_ERR_MSG);
895:
896: v_person_start_index := P_PERSON_START_INDEX;
897:

Line 894: hr_utility.trace( l_pkg ||'Parameters: P_ERR_MSG :'||P_ERR_MSG);

890: BEGIN
891: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_START_INDEX :'||P_PERSON_START_INDEX);
892: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_ID :'||P_PERSON_ID);
893: hr_utility.trace( l_pkg ||'Parameters: P_PERSON_CPE Start :'||P_PERSON_CPE);
894: hr_utility.trace( l_pkg ||'Parameters: P_ERR_MSG :'||P_ERR_MSG);
895:
896: v_person_start_index := P_PERSON_START_INDEX;
897:
898: IF (tab_paye_file(v_person_start_index).person_id = P_PERSON_ID and

Line 907: hr_utility.trace( l_pkg ||'Error message Set. '||tab_paye_file(v_person_start_index).err_message);

903: IF (tab_paye_file(v_person_start_index).person_id = P_PERSON_ID and
904: tab_paye_file(v_person_start_index).cpe_start_date = P_PERSON_CPE)
905: THEN
906: tab_paye_file(v_person_start_index).err_message := P_ERR_MSG;
907: hr_utility.trace( l_pkg ||'Error message Set. '||tab_paye_file(v_person_start_index).err_message);
908: hr_utility.trace( l_pkg ||'v_person_start_index: '||v_person_start_index);
909: v_person_start_index := v_person_start_index + 1;
910: if (tab_paye_file.count = v_person_start_index) then
911: exit; -- reached the last record.

Line 908: hr_utility.trace( l_pkg ||'v_person_start_index: '||v_person_start_index);

904: tab_paye_file(v_person_start_index).cpe_start_date = P_PERSON_CPE)
905: THEN
906: tab_paye_file(v_person_start_index).err_message := P_ERR_MSG;
907: hr_utility.trace( l_pkg ||'Error message Set. '||tab_paye_file(v_person_start_index).err_message);
908: hr_utility.trace( l_pkg ||'v_person_start_index: '||v_person_start_index);
909: v_person_start_index := v_person_start_index + 1;
910: if (tab_paye_file.count = v_person_start_index) then
911: exit; -- reached the last record.
912: end if;

Line 992: hr_utility.set_location( l_pkg ||'PAYE Upload',5);

988:
989: ------------
990: BEGIN --main Begin
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);

Line 1004: hr_utility.trace( l_pkg ||'Input directory not defined in PER_DATA_EXCHANGE_DIR profile.');

1000: THEN
1001: -- error : I/O directory not defined
1002: retcode := 2;
1003: errbuf := 'Input directory not defined. Set PER_DATA_EXCHANGE_DIR profile (HR: Data Exchange directory).';
1004: hr_utility.trace( l_pkg ||'Input directory not defined in PER_DATA_EXCHANGE_DIR profile.');
1005: raise e_fatal_error;
1006:
1007: END IF;
1008:

Line 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');

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:
1062: /* Validate the given Download Req ID in Database and fetch the Tax Reference

Line 1078: hr_utility.trace( l_pkg ||'download_cp_tax_ref :'||download_cp_tax_ref);

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);
1082: raise invalid_file_format;

Line 1079: hr_utility.trace( l_pkg ||'Download Request tax ref Argument :'||l_arg1);

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);
1082: raise invalid_file_format;
1083: end if;

Line 1080: hr_utility.trace( l_pkg ||'download_cp_eff_date :'||download_cp_eff_date);

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);
1082: raise invalid_file_format;
1083: end if;
1084:

Line 1081: hr_utility.trace( l_pkg ||'Download Request eff date Argument :'||l_arg2);

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);
1082: raise invalid_file_format;
1083: end if;
1084:
1085: exception

Line 1101: hr_utility.trace( l_pkg ||'Beginning line is :'||l_present_line);

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:
1105: /* Read each line from file to get the Records to be updated

Line 1159: hr_utility.trace( l_pkg ||'Inside loop, reading line:'||l_present_line);

1155: LOOP
1156: IF (trim(l_present_line) is not null)
1157: THEN
1158:
1159: hr_utility.trace( l_pkg ||'Inside loop, reading line:'||l_present_line);
1160:
1161: if (count_tokens(l_present_line) <> 19) then
1162: retcode := 2;
1163: errbuf := 'Record Format altered.';

Line 1193: hr_utility.trace( l_pkg ||'last_name:'||tab_paye_file(l_record_no).last_name);

1189:
1190: tab_paye_file(l_record_no).tax_basis := HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',tab_paye_file(l_record_no).tax_basis);
1191: tab_paye_file(l_record_no).sug_tax_basis := HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',tab_paye_file(l_record_no).sug_tax_basis);
1192:
1193: hr_utility.trace( l_pkg ||'last_name:'||tab_paye_file(l_record_no).last_name);
1194: hr_utility.trace( l_pkg ||'person_id:'||tab_paye_file(l_record_no).person_id);
1195: hr_utility.trace( l_pkg ||'assignment_id:'||tab_paye_file(l_record_no).assignment_id);
1196: hr_utility.trace( l_pkg ||'assignment_number:'||tab_paye_file(l_record_no).assignment_number);
1197: hr_utility.trace( l_pkg ||'effective_start_date:'||tab_paye_file(l_record_no).effective_start_date);

Line 1194: hr_utility.trace( l_pkg ||'person_id:'||tab_paye_file(l_record_no).person_id);

1190: tab_paye_file(l_record_no).tax_basis := HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',tab_paye_file(l_record_no).tax_basis);
1191: tab_paye_file(l_record_no).sug_tax_basis := HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',tab_paye_file(l_record_no).sug_tax_basis);
1192:
1193: hr_utility.trace( l_pkg ||'last_name:'||tab_paye_file(l_record_no).last_name);
1194: hr_utility.trace( l_pkg ||'person_id:'||tab_paye_file(l_record_no).person_id);
1195: hr_utility.trace( l_pkg ||'assignment_id:'||tab_paye_file(l_record_no).assignment_id);
1196: hr_utility.trace( l_pkg ||'assignment_number:'||tab_paye_file(l_record_no).assignment_number);
1197: hr_utility.trace( l_pkg ||'effective_start_date:'||tab_paye_file(l_record_no).effective_start_date);
1198: hr_utility.trace( l_pkg ||'effective_end_date:'||tab_paye_file(l_record_no).effective_end_date);

Line 1195: hr_utility.trace( l_pkg ||'assignment_id:'||tab_paye_file(l_record_no).assignment_id);

1191: tab_paye_file(l_record_no).sug_tax_basis := HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',tab_paye_file(l_record_no).sug_tax_basis);
1192:
1193: hr_utility.trace( l_pkg ||'last_name:'||tab_paye_file(l_record_no).last_name);
1194: hr_utility.trace( l_pkg ||'person_id:'||tab_paye_file(l_record_no).person_id);
1195: hr_utility.trace( l_pkg ||'assignment_id:'||tab_paye_file(l_record_no).assignment_id);
1196: hr_utility.trace( l_pkg ||'assignment_number:'||tab_paye_file(l_record_no).assignment_number);
1197: hr_utility.trace( l_pkg ||'effective_start_date:'||tab_paye_file(l_record_no).effective_start_date);
1198: hr_utility.trace( l_pkg ||'effective_end_date:'||tab_paye_file(l_record_no).effective_end_date);
1199: hr_utility.trace( l_pkg ||'cpe_start_date:'||tab_paye_file(l_record_no).cpe_start_date);

Line 1196: hr_utility.trace( l_pkg ||'assignment_number:'||tab_paye_file(l_record_no).assignment_number);

1192:
1193: hr_utility.trace( l_pkg ||'last_name:'||tab_paye_file(l_record_no).last_name);
1194: hr_utility.trace( l_pkg ||'person_id:'||tab_paye_file(l_record_no).person_id);
1195: hr_utility.trace( l_pkg ||'assignment_id:'||tab_paye_file(l_record_no).assignment_id);
1196: hr_utility.trace( l_pkg ||'assignment_number:'||tab_paye_file(l_record_no).assignment_number);
1197: hr_utility.trace( l_pkg ||'effective_start_date:'||tab_paye_file(l_record_no).effective_start_date);
1198: hr_utility.trace( l_pkg ||'effective_end_date:'||tab_paye_file(l_record_no).effective_end_date);
1199: hr_utility.trace( l_pkg ||'cpe_start_date:'||tab_paye_file(l_record_no).cpe_start_date);
1200: hr_utility.trace( l_pkg ||'peef_ovn:'||tab_paye_file(l_record_no).peef_ovn);

Line 1197: hr_utility.trace( l_pkg ||'effective_start_date:'||tab_paye_file(l_record_no).effective_start_date);

1193: hr_utility.trace( l_pkg ||'last_name:'||tab_paye_file(l_record_no).last_name);
1194: hr_utility.trace( l_pkg ||'person_id:'||tab_paye_file(l_record_no).person_id);
1195: hr_utility.trace( l_pkg ||'assignment_id:'||tab_paye_file(l_record_no).assignment_id);
1196: hr_utility.trace( l_pkg ||'assignment_number:'||tab_paye_file(l_record_no).assignment_number);
1197: hr_utility.trace( l_pkg ||'effective_start_date:'||tab_paye_file(l_record_no).effective_start_date);
1198: hr_utility.trace( l_pkg ||'effective_end_date:'||tab_paye_file(l_record_no).effective_end_date);
1199: hr_utility.trace( l_pkg ||'cpe_start_date:'||tab_paye_file(l_record_no).cpe_start_date);
1200: hr_utility.trace( l_pkg ||'peef_ovn:'||tab_paye_file(l_record_no).peef_ovn);
1201: hr_utility.trace( l_pkg ||'tax_code:'||tab_paye_file(l_record_no).tax_code);

Line 1198: hr_utility.trace( l_pkg ||'effective_end_date:'||tab_paye_file(l_record_no).effective_end_date);

1194: hr_utility.trace( l_pkg ||'person_id:'||tab_paye_file(l_record_no).person_id);
1195: hr_utility.trace( l_pkg ||'assignment_id:'||tab_paye_file(l_record_no).assignment_id);
1196: hr_utility.trace( l_pkg ||'assignment_number:'||tab_paye_file(l_record_no).assignment_number);
1197: hr_utility.trace( l_pkg ||'effective_start_date:'||tab_paye_file(l_record_no).effective_start_date);
1198: hr_utility.trace( l_pkg ||'effective_end_date:'||tab_paye_file(l_record_no).effective_end_date);
1199: hr_utility.trace( l_pkg ||'cpe_start_date:'||tab_paye_file(l_record_no).cpe_start_date);
1200: hr_utility.trace( l_pkg ||'peef_ovn:'||tab_paye_file(l_record_no).peef_ovn);
1201: hr_utility.trace( l_pkg ||'tax_code:'||tab_paye_file(l_record_no).tax_code);
1202: hr_utility.trace( l_pkg ||'tax_basis:'||tab_paye_file(l_record_no).tax_basis);

Line 1199: hr_utility.trace( l_pkg ||'cpe_start_date:'||tab_paye_file(l_record_no).cpe_start_date);

1195: hr_utility.trace( l_pkg ||'assignment_id:'||tab_paye_file(l_record_no).assignment_id);
1196: hr_utility.trace( l_pkg ||'assignment_number:'||tab_paye_file(l_record_no).assignment_number);
1197: hr_utility.trace( l_pkg ||'effective_start_date:'||tab_paye_file(l_record_no).effective_start_date);
1198: hr_utility.trace( l_pkg ||'effective_end_date:'||tab_paye_file(l_record_no).effective_end_date);
1199: hr_utility.trace( l_pkg ||'cpe_start_date:'||tab_paye_file(l_record_no).cpe_start_date);
1200: hr_utility.trace( l_pkg ||'peef_ovn:'||tab_paye_file(l_record_no).peef_ovn);
1201: hr_utility.trace( l_pkg ||'tax_code:'||tab_paye_file(l_record_no).tax_code);
1202: hr_utility.trace( l_pkg ||'tax_basis:'||tab_paye_file(l_record_no).tax_basis);
1203: hr_utility.trace( l_pkg ||'refundable:'||tab_paye_file(l_record_no).refundable);

Line 1200: hr_utility.trace( l_pkg ||'peef_ovn:'||tab_paye_file(l_record_no).peef_ovn);

1196: hr_utility.trace( l_pkg ||'assignment_number:'||tab_paye_file(l_record_no).assignment_number);
1197: hr_utility.trace( l_pkg ||'effective_start_date:'||tab_paye_file(l_record_no).effective_start_date);
1198: hr_utility.trace( l_pkg ||'effective_end_date:'||tab_paye_file(l_record_no).effective_end_date);
1199: hr_utility.trace( l_pkg ||'cpe_start_date:'||tab_paye_file(l_record_no).cpe_start_date);
1200: hr_utility.trace( l_pkg ||'peef_ovn:'||tab_paye_file(l_record_no).peef_ovn);
1201: hr_utility.trace( l_pkg ||'tax_code:'||tab_paye_file(l_record_no).tax_code);
1202: hr_utility.trace( l_pkg ||'tax_basis:'||tab_paye_file(l_record_no).tax_basis);
1203: hr_utility.trace( l_pkg ||'refundable:'||tab_paye_file(l_record_no).refundable);
1204: hr_utility.trace( l_pkg ||'previous_pay:'||tab_paye_file(l_record_no).previous_pay);

Line 1201: hr_utility.trace( l_pkg ||'tax_code:'||tab_paye_file(l_record_no).tax_code);

1197: hr_utility.trace( l_pkg ||'effective_start_date:'||tab_paye_file(l_record_no).effective_start_date);
1198: hr_utility.trace( l_pkg ||'effective_end_date:'||tab_paye_file(l_record_no).effective_end_date);
1199: hr_utility.trace( l_pkg ||'cpe_start_date:'||tab_paye_file(l_record_no).cpe_start_date);
1200: hr_utility.trace( l_pkg ||'peef_ovn:'||tab_paye_file(l_record_no).peef_ovn);
1201: hr_utility.trace( l_pkg ||'tax_code:'||tab_paye_file(l_record_no).tax_code);
1202: hr_utility.trace( l_pkg ||'tax_basis:'||tab_paye_file(l_record_no).tax_basis);
1203: hr_utility.trace( l_pkg ||'refundable:'||tab_paye_file(l_record_no).refundable);
1204: hr_utility.trace( l_pkg ||'previous_pay:'||tab_paye_file(l_record_no).previous_pay);
1205: hr_utility.trace( l_pkg ||'previous_tax:'||tab_paye_file(l_record_no).previous_tax);

Line 1202: hr_utility.trace( l_pkg ||'tax_basis:'||tab_paye_file(l_record_no).tax_basis);

1198: hr_utility.trace( l_pkg ||'effective_end_date:'||tab_paye_file(l_record_no).effective_end_date);
1199: hr_utility.trace( l_pkg ||'cpe_start_date:'||tab_paye_file(l_record_no).cpe_start_date);
1200: hr_utility.trace( l_pkg ||'peef_ovn:'||tab_paye_file(l_record_no).peef_ovn);
1201: hr_utility.trace( l_pkg ||'tax_code:'||tab_paye_file(l_record_no).tax_code);
1202: hr_utility.trace( l_pkg ||'tax_basis:'||tab_paye_file(l_record_no).tax_basis);
1203: hr_utility.trace( l_pkg ||'refundable:'||tab_paye_file(l_record_no).refundable);
1204: hr_utility.trace( l_pkg ||'previous_pay:'||tab_paye_file(l_record_no).previous_pay);
1205: hr_utility.trace( l_pkg ||'previous_tax:'||tab_paye_file(l_record_no).previous_tax);
1206:

Line 1203: hr_utility.trace( l_pkg ||'refundable:'||tab_paye_file(l_record_no).refundable);

1199: hr_utility.trace( l_pkg ||'cpe_start_date:'||tab_paye_file(l_record_no).cpe_start_date);
1200: hr_utility.trace( l_pkg ||'peef_ovn:'||tab_paye_file(l_record_no).peef_ovn);
1201: hr_utility.trace( l_pkg ||'tax_code:'||tab_paye_file(l_record_no).tax_code);
1202: hr_utility.trace( l_pkg ||'tax_basis:'||tab_paye_file(l_record_no).tax_basis);
1203: hr_utility.trace( l_pkg ||'refundable:'||tab_paye_file(l_record_no).refundable);
1204: hr_utility.trace( l_pkg ||'previous_pay:'||tab_paye_file(l_record_no).previous_pay);
1205: hr_utility.trace( l_pkg ||'previous_tax:'||tab_paye_file(l_record_no).previous_tax);
1206:
1207: l_curr_person_id := tab_paye_file(l_record_no).person_id;

Line 1204: hr_utility.trace( l_pkg ||'previous_pay:'||tab_paye_file(l_record_no).previous_pay);

1200: hr_utility.trace( l_pkg ||'peef_ovn:'||tab_paye_file(l_record_no).peef_ovn);
1201: hr_utility.trace( l_pkg ||'tax_code:'||tab_paye_file(l_record_no).tax_code);
1202: hr_utility.trace( l_pkg ||'tax_basis:'||tab_paye_file(l_record_no).tax_basis);
1203: hr_utility.trace( l_pkg ||'refundable:'||tab_paye_file(l_record_no).refundable);
1204: hr_utility.trace( l_pkg ||'previous_pay:'||tab_paye_file(l_record_no).previous_pay);
1205: hr_utility.trace( l_pkg ||'previous_tax:'||tab_paye_file(l_record_no).previous_tax);
1206:
1207: l_curr_person_id := tab_paye_file(l_record_no).person_id;
1208: l_curr_person_cpe := tab_paye_file(l_record_no).cpe_start_date;

Line 1205: hr_utility.trace( l_pkg ||'previous_tax:'||tab_paye_file(l_record_no).previous_tax);

1201: hr_utility.trace( l_pkg ||'tax_code:'||tab_paye_file(l_record_no).tax_code);
1202: hr_utility.trace( l_pkg ||'tax_basis:'||tab_paye_file(l_record_no).tax_basis);
1203: hr_utility.trace( l_pkg ||'refundable:'||tab_paye_file(l_record_no).refundable);
1204: hr_utility.trace( l_pkg ||'previous_pay:'||tab_paye_file(l_record_no).previous_pay);
1205: hr_utility.trace( l_pkg ||'previous_tax:'||tab_paye_file(l_record_no).previous_tax);
1206:
1207: l_curr_person_id := tab_paye_file(l_record_no).person_id;
1208: l_curr_person_cpe := tab_paye_file(l_record_no).cpe_start_date;
1209: IF( l_curr_person_id <> l_prev_person_id or

Line 1232: hr_utility.set_location( l_pkg ||'PAYE Upload',50);

1228: THEN
1229: exit;
1230: END IF;
1231: --
1232: hr_utility.set_location( l_pkg ||'PAYE Upload',50);
1233: hr_utility.trace( l_pkg ||'line: '|| l_present_line);
1234: --
1235: EXCEPTION
1236: WHEN no_data_found

Line 1233: hr_utility.trace( l_pkg ||'line: '|| l_present_line);

1229: exit;
1230: END IF;
1231: --
1232: hr_utility.set_location( l_pkg ||'PAYE Upload',50);
1233: hr_utility.trace( l_pkg ||'line: '|| l_present_line);
1234: --
1235: EXCEPTION
1236: WHEN no_data_found
1237: THEN

Line 1254: hr_utility.trace( l_pkg ||'Inside validating loop :'||l_count);

1250: */
1251: FOR l_count in 0..(l_record_no-1)
1252: LOOP
1253:
1254: hr_utility.trace( l_pkg ||'Inside validating loop :'||l_count);
1255:
1256: IF(tab_paye_file(l_count).new_person_cpe_flag = 'Y')
1257: THEN
1258: l_person_index := l_count;

Line 1266: hr_utility.trace( l_pkg ||'Before checking against DB for '||tab_paye_file(l_count).assignment_id||' and '||download_cp_tax_ref||' and '||P_PAYE_ELE_ID);

1262: download_cp_tax_ref,
1263: to_number(P_PAYE_ELE_ID),
1264: download_cp_eff_date );
1265:
1266: hr_utility.trace( l_pkg ||'Before checking against DB for '||tab_paye_file(l_count).assignment_id||' and '||download_cp_tax_ref||' and '||P_PAYE_ELE_ID);
1267:
1268: FETCH csr_db_paye_det
1269: INTO db_paye_details.last_name,
1270: db_paye_details.person_id,

Line 1301: hr_utility.trace( l_pkg ||'Cursor Count:'||csr_db_paye_det%rowcount);

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:
1301: hr_utility.trace( l_pkg ||'Cursor Count:'||csr_db_paye_det%rowcount);
1302: CLOSE csr_db_paye_det;
1303: hr_utility.trace( l_pkg ||'DB last_name:'||db_paye_details.last_name);
1304: hr_utility.trace( l_pkg ||'DB person_id:'||db_paye_details.person_id);
1305: hr_utility.trace( l_pkg ||'DB assignment_id:'||db_paye_details.assignment_id);

Line 1303: hr_utility.trace( l_pkg ||'DB last_name:'||db_paye_details.last_name);

1299: END IF;
1300:
1301: hr_utility.trace( l_pkg ||'Cursor Count:'||csr_db_paye_det%rowcount);
1302: CLOSE csr_db_paye_det;
1303: hr_utility.trace( l_pkg ||'DB last_name:'||db_paye_details.last_name);
1304: hr_utility.trace( l_pkg ||'DB person_id:'||db_paye_details.person_id);
1305: hr_utility.trace( l_pkg ||'DB assignment_id:'||db_paye_details.assignment_id);
1306: hr_utility.trace( l_pkg ||'After fetching data from DB');
1307:

Line 1304: hr_utility.trace( l_pkg ||'DB person_id:'||db_paye_details.person_id);

1300:
1301: hr_utility.trace( l_pkg ||'Cursor Count:'||csr_db_paye_det%rowcount);
1302: CLOSE csr_db_paye_det;
1303: hr_utility.trace( l_pkg ||'DB last_name:'||db_paye_details.last_name);
1304: hr_utility.trace( l_pkg ||'DB person_id:'||db_paye_details.person_id);
1305: hr_utility.trace( l_pkg ||'DB assignment_id:'||db_paye_details.assignment_id);
1306: hr_utility.trace( l_pkg ||'After fetching data from DB');
1307:
1308:

Line 1305: hr_utility.trace( l_pkg ||'DB assignment_id:'||db_paye_details.assignment_id);

1301: hr_utility.trace( l_pkg ||'Cursor Count:'||csr_db_paye_det%rowcount);
1302: CLOSE csr_db_paye_det;
1303: hr_utility.trace( l_pkg ||'DB last_name:'||db_paye_details.last_name);
1304: hr_utility.trace( l_pkg ||'DB person_id:'||db_paye_details.person_id);
1305: hr_utility.trace( l_pkg ||'DB assignment_id:'||db_paye_details.assignment_id);
1306: hr_utility.trace( l_pkg ||'After fetching data from DB');
1307:
1308:
1309: /* Check if the person level suggested values are same and set err message appropriately */

Line 1306: hr_utility.trace( l_pkg ||'After fetching data from DB');

1302: CLOSE csr_db_paye_det;
1303: hr_utility.trace( l_pkg ||'DB last_name:'||db_paye_details.last_name);
1304: hr_utility.trace( l_pkg ||'DB person_id:'||db_paye_details.person_id);
1305: hr_utility.trace( l_pkg ||'DB assignment_id:'||db_paye_details.assignment_id);
1306: hr_utility.trace( l_pkg ||'After fetching data from DB');
1307:
1308:
1309: /* Check if the person level suggested values are same and set err message appropriately */
1310: IF NOT(nvl(tab_paye_file(l_count).sug_tax_code,'NULL') = nvl(tab_paye_file(l_person_index).sug_tax_code,'NULL') AND

Line 1401: hr_utility.trace( l_pkg ||'Arguments to hr_entry_api call');

1397:
1398: ELSIF (nvl(tab_paye_file(l_count).record_changed,'Y') = 'Y')
1399: THEN
1400:
1401: hr_utility.trace( l_pkg ||'Arguments to hr_entry_api call');
1402: hr_utility.trace( l_pkg ||'SessionDate:'||download_cp_eff_date);
1403: hr_utility.trace( l_pkg ||'p_element_entry_id:'||tab_paye_file(l_count).element_entry_id);
1404: hr_utility.trace( l_pkg ||'p_input_value_id1:'||tab_paye_file(l_count).tax_code_iv_id);
1405: hr_utility.trace( l_pkg ||'p_input_value_id2:'||tab_paye_file(l_count).tax_basis_iv_id);

Line 1402: hr_utility.trace( l_pkg ||'SessionDate:'||download_cp_eff_date);

1398: ELSIF (nvl(tab_paye_file(l_count).record_changed,'Y') = 'Y')
1399: THEN
1400:
1401: hr_utility.trace( l_pkg ||'Arguments to hr_entry_api call');
1402: hr_utility.trace( l_pkg ||'SessionDate:'||download_cp_eff_date);
1403: hr_utility.trace( l_pkg ||'p_element_entry_id:'||tab_paye_file(l_count).element_entry_id);
1404: hr_utility.trace( l_pkg ||'p_input_value_id1:'||tab_paye_file(l_count).tax_code_iv_id);
1405: hr_utility.trace( l_pkg ||'p_input_value_id2:'||tab_paye_file(l_count).tax_basis_iv_id);
1406: hr_utility.trace( l_pkg ||'p_input_value_id3:'||tab_paye_file(l_count).pay_previous_iv_id);

Line 1403: hr_utility.trace( l_pkg ||'p_element_entry_id:'||tab_paye_file(l_count).element_entry_id);

1399: THEN
1400:
1401: hr_utility.trace( l_pkg ||'Arguments to hr_entry_api call');
1402: hr_utility.trace( l_pkg ||'SessionDate:'||download_cp_eff_date);
1403: hr_utility.trace( l_pkg ||'p_element_entry_id:'||tab_paye_file(l_count).element_entry_id);
1404: hr_utility.trace( l_pkg ||'p_input_value_id1:'||tab_paye_file(l_count).tax_code_iv_id);
1405: hr_utility.trace( l_pkg ||'p_input_value_id2:'||tab_paye_file(l_count).tax_basis_iv_id);
1406: hr_utility.trace( l_pkg ||'p_input_value_id3:'||tab_paye_file(l_count).pay_previous_iv_id);
1407: hr_utility.trace( l_pkg ||'p_input_value_id4:'||tab_paye_file(l_count).tax_previous_iv_id);

Line 1404: hr_utility.trace( l_pkg ||'p_input_value_id1:'||tab_paye_file(l_count).tax_code_iv_id);

1400:
1401: hr_utility.trace( l_pkg ||'Arguments to hr_entry_api call');
1402: hr_utility.trace( l_pkg ||'SessionDate:'||download_cp_eff_date);
1403: hr_utility.trace( l_pkg ||'p_element_entry_id:'||tab_paye_file(l_count).element_entry_id);
1404: hr_utility.trace( l_pkg ||'p_input_value_id1:'||tab_paye_file(l_count).tax_code_iv_id);
1405: hr_utility.trace( l_pkg ||'p_input_value_id2:'||tab_paye_file(l_count).tax_basis_iv_id);
1406: hr_utility.trace( l_pkg ||'p_input_value_id3:'||tab_paye_file(l_count).pay_previous_iv_id);
1407: hr_utility.trace( l_pkg ||'p_input_value_id4:'||tab_paye_file(l_count).tax_previous_iv_id);
1408: hr_utility.trace( l_pkg ||'p_input_value_id5:'||tab_paye_file(l_count).refundable_iv_id);

Line 1405: hr_utility.trace( l_pkg ||'p_input_value_id2:'||tab_paye_file(l_count).tax_basis_iv_id);

1401: hr_utility.trace( l_pkg ||'Arguments to hr_entry_api call');
1402: hr_utility.trace( l_pkg ||'SessionDate:'||download_cp_eff_date);
1403: hr_utility.trace( l_pkg ||'p_element_entry_id:'||tab_paye_file(l_count).element_entry_id);
1404: hr_utility.trace( l_pkg ||'p_input_value_id1:'||tab_paye_file(l_count).tax_code_iv_id);
1405: hr_utility.trace( l_pkg ||'p_input_value_id2:'||tab_paye_file(l_count).tax_basis_iv_id);
1406: hr_utility.trace( l_pkg ||'p_input_value_id3:'||tab_paye_file(l_count).pay_previous_iv_id);
1407: hr_utility.trace( l_pkg ||'p_input_value_id4:'||tab_paye_file(l_count).tax_previous_iv_id);
1408: hr_utility.trace( l_pkg ||'p_input_value_id5:'||tab_paye_file(l_count).refundable_iv_id);
1409: hr_utility.trace( l_pkg ||'p_input_value_id6:'||tab_paye_file(l_count).authority_iv_id);

Line 1406: hr_utility.trace( l_pkg ||'p_input_value_id3:'||tab_paye_file(l_count).pay_previous_iv_id);

1402: hr_utility.trace( l_pkg ||'SessionDate:'||download_cp_eff_date);
1403: hr_utility.trace( l_pkg ||'p_element_entry_id:'||tab_paye_file(l_count).element_entry_id);
1404: hr_utility.trace( l_pkg ||'p_input_value_id1:'||tab_paye_file(l_count).tax_code_iv_id);
1405: hr_utility.trace( l_pkg ||'p_input_value_id2:'||tab_paye_file(l_count).tax_basis_iv_id);
1406: hr_utility.trace( l_pkg ||'p_input_value_id3:'||tab_paye_file(l_count).pay_previous_iv_id);
1407: hr_utility.trace( l_pkg ||'p_input_value_id4:'||tab_paye_file(l_count).tax_previous_iv_id);
1408: hr_utility.trace( l_pkg ||'p_input_value_id5:'||tab_paye_file(l_count).refundable_iv_id);
1409: hr_utility.trace( l_pkg ||'p_input_value_id6:'||tab_paye_file(l_count).authority_iv_id);
1410: hr_utility.trace( l_pkg ||'p_entry_value1:'||tab_paye_file(l_count).sug_tax_code);

Line 1407: hr_utility.trace( l_pkg ||'p_input_value_id4:'||tab_paye_file(l_count).tax_previous_iv_id);

1403: hr_utility.trace( l_pkg ||'p_element_entry_id:'||tab_paye_file(l_count).element_entry_id);
1404: hr_utility.trace( l_pkg ||'p_input_value_id1:'||tab_paye_file(l_count).tax_code_iv_id);
1405: hr_utility.trace( l_pkg ||'p_input_value_id2:'||tab_paye_file(l_count).tax_basis_iv_id);
1406: hr_utility.trace( l_pkg ||'p_input_value_id3:'||tab_paye_file(l_count).pay_previous_iv_id);
1407: hr_utility.trace( l_pkg ||'p_input_value_id4:'||tab_paye_file(l_count).tax_previous_iv_id);
1408: hr_utility.trace( l_pkg ||'p_input_value_id5:'||tab_paye_file(l_count).refundable_iv_id);
1409: hr_utility.trace( l_pkg ||'p_input_value_id6:'||tab_paye_file(l_count).authority_iv_id);
1410: hr_utility.trace( l_pkg ||'p_entry_value1:'||tab_paye_file(l_count).sug_tax_code);
1411: hr_utility.trace( l_pkg ||'p_entry_value2:'||tab_paye_file(l_count).sug_tax_basis);

Line 1408: hr_utility.trace( l_pkg ||'p_input_value_id5:'||tab_paye_file(l_count).refundable_iv_id);

1404: hr_utility.trace( l_pkg ||'p_input_value_id1:'||tab_paye_file(l_count).tax_code_iv_id);
1405: hr_utility.trace( l_pkg ||'p_input_value_id2:'||tab_paye_file(l_count).tax_basis_iv_id);
1406: hr_utility.trace( l_pkg ||'p_input_value_id3:'||tab_paye_file(l_count).pay_previous_iv_id);
1407: hr_utility.trace( l_pkg ||'p_input_value_id4:'||tab_paye_file(l_count).tax_previous_iv_id);
1408: hr_utility.trace( l_pkg ||'p_input_value_id5:'||tab_paye_file(l_count).refundable_iv_id);
1409: hr_utility.trace( l_pkg ||'p_input_value_id6:'||tab_paye_file(l_count).authority_iv_id);
1410: hr_utility.trace( l_pkg ||'p_entry_value1:'||tab_paye_file(l_count).sug_tax_code);
1411: hr_utility.trace( l_pkg ||'p_entry_value2:'||tab_paye_file(l_count).sug_tax_basis);
1412: hr_utility.trace( l_pkg ||'p_entry_value3:'||tab_paye_file(l_count).sug_previous_pay);

Line 1409: hr_utility.trace( l_pkg ||'p_input_value_id6:'||tab_paye_file(l_count).authority_iv_id);

1405: hr_utility.trace( l_pkg ||'p_input_value_id2:'||tab_paye_file(l_count).tax_basis_iv_id);
1406: hr_utility.trace( l_pkg ||'p_input_value_id3:'||tab_paye_file(l_count).pay_previous_iv_id);
1407: hr_utility.trace( l_pkg ||'p_input_value_id4:'||tab_paye_file(l_count).tax_previous_iv_id);
1408: hr_utility.trace( l_pkg ||'p_input_value_id5:'||tab_paye_file(l_count).refundable_iv_id);
1409: hr_utility.trace( l_pkg ||'p_input_value_id6:'||tab_paye_file(l_count).authority_iv_id);
1410: hr_utility.trace( l_pkg ||'p_entry_value1:'||tab_paye_file(l_count).sug_tax_code);
1411: hr_utility.trace( l_pkg ||'p_entry_value2:'||tab_paye_file(l_count).sug_tax_basis);
1412: hr_utility.trace( l_pkg ||'p_entry_value3:'||tab_paye_file(l_count).sug_previous_pay);
1413: hr_utility.trace( l_pkg ||'p_entry_value4:'||tab_paye_file(l_count).sug_previous_tax);

Line 1410: hr_utility.trace( l_pkg ||'p_entry_value1:'||tab_paye_file(l_count).sug_tax_code);

1406: hr_utility.trace( l_pkg ||'p_input_value_id3:'||tab_paye_file(l_count).pay_previous_iv_id);
1407: hr_utility.trace( l_pkg ||'p_input_value_id4:'||tab_paye_file(l_count).tax_previous_iv_id);
1408: hr_utility.trace( l_pkg ||'p_input_value_id5:'||tab_paye_file(l_count).refundable_iv_id);
1409: hr_utility.trace( l_pkg ||'p_input_value_id6:'||tab_paye_file(l_count).authority_iv_id);
1410: hr_utility.trace( l_pkg ||'p_entry_value1:'||tab_paye_file(l_count).sug_tax_code);
1411: hr_utility.trace( l_pkg ||'p_entry_value2:'||tab_paye_file(l_count).sug_tax_basis);
1412: hr_utility.trace( l_pkg ||'p_entry_value3:'||tab_paye_file(l_count).sug_previous_pay);
1413: hr_utility.trace( l_pkg ||'p_entry_value4:'||tab_paye_file(l_count).sug_previous_tax);
1414: hr_utility.trace( l_pkg ||'p_entry_value5:'||tab_paye_file(l_count).sug_refundable);

Line 1411: hr_utility.trace( l_pkg ||'p_entry_value2:'||tab_paye_file(l_count).sug_tax_basis);

1407: hr_utility.trace( l_pkg ||'p_input_value_id4:'||tab_paye_file(l_count).tax_previous_iv_id);
1408: hr_utility.trace( l_pkg ||'p_input_value_id5:'||tab_paye_file(l_count).refundable_iv_id);
1409: hr_utility.trace( l_pkg ||'p_input_value_id6:'||tab_paye_file(l_count).authority_iv_id);
1410: hr_utility.trace( l_pkg ||'p_entry_value1:'||tab_paye_file(l_count).sug_tax_code);
1411: hr_utility.trace( l_pkg ||'p_entry_value2:'||tab_paye_file(l_count).sug_tax_basis);
1412: hr_utility.trace( l_pkg ||'p_entry_value3:'||tab_paye_file(l_count).sug_previous_pay);
1413: hr_utility.trace( l_pkg ||'p_entry_value4:'||tab_paye_file(l_count).sug_previous_tax);
1414: hr_utility.trace( l_pkg ||'p_entry_value5:'||tab_paye_file(l_count).sug_refundable);
1415: hr_utility.trace( l_pkg ||'p_entry_value6:'||tab_paye_file(l_count).sug_authority);

Line 1412: hr_utility.trace( l_pkg ||'p_entry_value3:'||tab_paye_file(l_count).sug_previous_pay);

1408: hr_utility.trace( l_pkg ||'p_input_value_id5:'||tab_paye_file(l_count).refundable_iv_id);
1409: hr_utility.trace( l_pkg ||'p_input_value_id6:'||tab_paye_file(l_count).authority_iv_id);
1410: hr_utility.trace( l_pkg ||'p_entry_value1:'||tab_paye_file(l_count).sug_tax_code);
1411: hr_utility.trace( l_pkg ||'p_entry_value2:'||tab_paye_file(l_count).sug_tax_basis);
1412: hr_utility.trace( l_pkg ||'p_entry_value3:'||tab_paye_file(l_count).sug_previous_pay);
1413: hr_utility.trace( l_pkg ||'p_entry_value4:'||tab_paye_file(l_count).sug_previous_tax);
1414: hr_utility.trace( l_pkg ||'p_entry_value5:'||tab_paye_file(l_count).sug_refundable);
1415: hr_utility.trace( l_pkg ||'p_entry_value6:'||tab_paye_file(l_count).sug_authority);
1416:

Line 1413: hr_utility.trace( l_pkg ||'p_entry_value4:'||tab_paye_file(l_count).sug_previous_tax);

1409: hr_utility.trace( l_pkg ||'p_input_value_id6:'||tab_paye_file(l_count).authority_iv_id);
1410: hr_utility.trace( l_pkg ||'p_entry_value1:'||tab_paye_file(l_count).sug_tax_code);
1411: hr_utility.trace( l_pkg ||'p_entry_value2:'||tab_paye_file(l_count).sug_tax_basis);
1412: hr_utility.trace( l_pkg ||'p_entry_value3:'||tab_paye_file(l_count).sug_previous_pay);
1413: hr_utility.trace( l_pkg ||'p_entry_value4:'||tab_paye_file(l_count).sug_previous_tax);
1414: hr_utility.trace( l_pkg ||'p_entry_value5:'||tab_paye_file(l_count).sug_refundable);
1415: hr_utility.trace( l_pkg ||'p_entry_value6:'||tab_paye_file(l_count).sug_authority);
1416:
1417: BEGIN

Line 1414: hr_utility.trace( l_pkg ||'p_entry_value5:'||tab_paye_file(l_count).sug_refundable);

1410: hr_utility.trace( l_pkg ||'p_entry_value1:'||tab_paye_file(l_count).sug_tax_code);
1411: hr_utility.trace( l_pkg ||'p_entry_value2:'||tab_paye_file(l_count).sug_tax_basis);
1412: hr_utility.trace( l_pkg ||'p_entry_value3:'||tab_paye_file(l_count).sug_previous_pay);
1413: hr_utility.trace( l_pkg ||'p_entry_value4:'||tab_paye_file(l_count).sug_previous_tax);
1414: hr_utility.trace( l_pkg ||'p_entry_value5:'||tab_paye_file(l_count).sug_refundable);
1415: hr_utility.trace( l_pkg ||'p_entry_value6:'||tab_paye_file(l_count).sug_authority);
1416:
1417: BEGIN
1418: -- For bug 8485686

Line 1415: hr_utility.trace( l_pkg ||'p_entry_value6:'||tab_paye_file(l_count).sug_authority);

1411: hr_utility.trace( l_pkg ||'p_entry_value2:'||tab_paye_file(l_count).sug_tax_basis);
1412: hr_utility.trace( l_pkg ||'p_entry_value3:'||tab_paye_file(l_count).sug_previous_pay);
1413: hr_utility.trace( l_pkg ||'p_entry_value4:'||tab_paye_file(l_count).sug_previous_tax);
1414: hr_utility.trace( l_pkg ||'p_entry_value5:'||tab_paye_file(l_count).sug_refundable);
1415: hr_utility.trace( l_pkg ||'p_entry_value6:'||tab_paye_file(l_count).sug_authority);
1416:
1417: BEGIN
1418: -- For bug 8485686
1419: pqp_gb_ad_ee.g_global_paye_validation := 'N';

Line 1493: hr_utility.set_location( l_pkg ||'PAYE Upload',80);

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
1497: hr_utility.set_location( l_pkg ||'PAYE Upload',100);

Line 1497: hr_utility.set_location( l_pkg ||'PAYE Upload',100);

1493: hr_utility.set_location( l_pkg ||'PAYE Upload',80);
1494: EXCEPTION
1495: WHEN e_fatal_error
1496: THEN
1497: hr_utility.set_location( l_pkg ||'PAYE Upload',100);
1498:
1499: WHEN UTL_FILE.INVALID_OPERATION
1500: THEN
1501:

Line 1503: hr_utility.set_location( l_pkg ||'PAYE Upload',110);

1499: WHEN UTL_FILE.INVALID_OPERATION
1500: THEN
1501:
1502: UTL_FILE.FCLOSE(l_file_handle);
1503: hr_utility.set_location( l_pkg ||'PAYE Upload',110);
1504: retcode:=2;
1505: errbuf := 'Reading Flat File - Invalid Operation (file not found).';
1506:
1507: WHEN UTL_FILE.INTERNAL_ERROR

Line 1511: hr_utility.set_location( l_pkg ||'PAYE Upload',120);

1507: WHEN UTL_FILE.INTERNAL_ERROR
1508: THEN
1509:
1510: UTL_FILE.FCLOSE(l_file_handle);
1511: hr_utility.set_location( l_pkg ||'PAYE Upload',120);
1512: retcode:=2;
1513: errbuf := 'Reading Flat File - Internal Error.';
1514: WHEN UTL_FILE.INVALID_MODE
1515: THEN

Line 1518: hr_utility.set_location( l_pkg ||'PAYE Upload',130);

1514: WHEN UTL_FILE.INVALID_MODE
1515: THEN
1516:
1517: UTL_FILE.FCLOSE(l_file_handle);
1518: hr_utility.set_location( l_pkg ||'PAYE Upload',130);
1519: retcode:=2;
1520: errbuf := 'Reading Flat File - Invalid Mode.';
1521:
1522: WHEN UTL_FILE.INVALID_PATH

Line 1526: hr_utility.set_location( l_pkg ||'PAYE Upload',140);

1522: WHEN UTL_FILE.INVALID_PATH
1523: THEN
1524:
1525: UTL_FILE.FCLOSE(l_file_handle);
1526: hr_utility.set_location( l_pkg ||'PAYE Upload',140);
1527: retcode:=2;
1528: errbuf := 'Reading Flat File - Invalid Path.';
1529:
1530: WHEN UTL_FILE.INVALID_FILEHANDLE

Line 1534: hr_utility.set_location( l_pkg ||'PAYE Upload',150);

1530: WHEN UTL_FILE.INVALID_FILEHANDLE
1531: THEN
1532:
1533: UTL_FILE.FCLOSE(l_file_handle);
1534: hr_utility.set_location( l_pkg ||'PAYE Upload',150);
1535: retcode:=2;
1536: errbuf := 'Reading Flat File - Invalid File Handle.';
1537:
1538: WHEN UTL_FILE.READ_ERROR

Line 1542: hr_utility.set_location( l_pkg ||'PAYE Upload',160);

1538: WHEN UTL_FILE.READ_ERROR
1539: THEN
1540:
1541: UTL_FILE.FCLOSE(l_file_handle);
1542: hr_utility.set_location( l_pkg ||'PAYE Upload',160);
1543: retcode:=2;
1544: errbuf := 'Reading Flat File - Read Error.';
1545:
1546: WHEN NO_DATA_FOUND

Line 1549: hr_utility.set_location( l_pkg ||'PAYE Upload',170);

1545:
1546: WHEN NO_DATA_FOUND
1547: THEN
1548: UTL_FILE.FCLOSE(l_file_handle);
1549: hr_utility.set_location( l_pkg ||'PAYE Upload',170);
1550: retcode:=2;
1551: errbuf := 'No Data Found.';
1552:
1553: WHEN INVALID_FILE_FORMAT

Line 1556: hr_utility.set_location( l_pkg ||'PAYE Upload',180);

1552:
1553: WHEN INVALID_FILE_FORMAT
1554: THEN
1555: UTL_FILE.FCLOSE(l_file_handle);
1556: hr_utility.set_location( l_pkg ||'PAYE Upload',180);
1557:
1558: WHEN NO_REC_FOUND_IN_FILE
1559: THEN
1560: UTL_FILE.FCLOSE(l_file_handle);

Line 1561: hr_utility.set_location( l_pkg ||'PAYE Upload',190);

1557:
1558: WHEN NO_REC_FOUND_IN_FILE
1559: THEN
1560: UTL_FILE.FCLOSE(l_file_handle);
1561: hr_utility.set_location( l_pkg ||'PAYE Upload',190);
1562:
1563: WHEN others
1564: THEN
1565: retcode:=2;

Line 1567: hr_utility.set_location( l_pkg ||'PAYE Upload',200);

1563: WHEN others
1564: THEN
1565: retcode:=2;
1566: errbuf := 'Exception occured :'||sqlerrm;
1567: hr_utility.set_location( l_pkg ||'PAYE Upload',200);
1568: END read_util_file;
1569:
1570:
1571: END pay_gb_paye_sync;