DBA Data[Home] [Help]

APPS.PAY_DK_TC_DP_UPLOAD dependencies on FND_FILE

Line 242: -- fnd_file.put_line (fnd_file.LOG,'l_le_id :'||l_le_id||' l_se_num : '||l_se_num);

238: LOOP
239: fetch csr_get_legal_employer into rg_csr_get_legal_employer;
240: l_le_id := rg_csr_get_legal_employer.org_information1;
241: l_se_num := rg_csr_get_legal_employer.org_information5;
242: -- fnd_file.put_line (fnd_file.LOG,'l_le_id :'||l_le_id||' l_se_num : '||l_se_num);
243: EXIT WHEN csr_get_legal_employer%NOTFOUND;
244: IF l_le_id = substr(l_line_read,75,8) OR l_se_num = substr(l_line_read,75,8) then -- included validation for SE num
245: l_flag := 'Y';
246: END IF;

Line 272: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

268: retcode := c_error;
269: -- Set the application error
270: hr_utility.set_message (801, 'PAY_377021_DK_INVALID_FILE_FMT');
271: hr_utility.set_location (l_proc, 120);
272: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
273: end;
274:
275: end if;
276: END LOOP file_format_check;

Line 285: fnd_file.put_line (fnd_file.LOG,'end record error');

281:
282: UTL_FILE.fclose (l_file_type);
283:
284: if l_end_rec_flag = 'N' then
285: fnd_file.put_line (fnd_file.LOG,'end record error');
286: raise e_file_format_err;
287: end if;
288:
289: -- END OF FILE FORMAT CHECK

Line 363: -- fnd_file.put_line (fnd_file.LOG,'Line - before parsing it : '||l_line_read);

359:
360: BEGIN
361: -- setting defualt value for element link found flag
362: l_element_link_found := 'FOUND';
363: -- fnd_file.put_line (fnd_file.LOG,'Line - before parsing it : '||l_line_read);
364: if substr(l_line_read,1,4) = '0608' then -- tax record
365: read_record
366: (
367: p_line => l_line_read

Line 390: --fnd_file.put_line (fnd_file.LOG,'Read the record 0608');

386:
387: hr_utility.set_location ( ' CPR Number = ' || l_cpr, 60);
388: hr_utility.set_location ( ' Employer Organization Number = ' || l_employer_org_no, 60);
389:
390: --fnd_file.put_line (fnd_file.LOG,'Read the record 0608');
391:
392: if l_entry_value2 NOT IN ('H','B','F','NTC') then
393: raise e_invalid_tax_card_type;
394: end if;

Line 408: -- fnd_file.put_line (fnd_file.LOG,'CPR number : '||l_cpr);

404: raise e_tax_percentage_err;
405: end if;
406: end if;
407:
408: -- fnd_file.put_line (fnd_file.LOG,'CPR number : '||l_cpr);
409: -- fnd_file.put_line (fnd_file.LOG,'p_effective_date : '||p_effective_date);
410:
411: OPEN csr_get_prim_assg
412: ( p_business_group_id => p_business_group_id

Line 409: -- fnd_file.put_line (fnd_file.LOG,'p_effective_date : '||p_effective_date);

405: end if;
406: end if;
407:
408: -- fnd_file.put_line (fnd_file.LOG,'CPR number : '||l_cpr);
409: -- fnd_file.put_line (fnd_file.LOG,'p_effective_date : '||p_effective_date);
410:
411: OPEN csr_get_prim_assg
412: ( p_business_group_id => p_business_group_id
413: ,p_cpr => l_cpr

Line 422: -- fnd_file.put_line(fnd_file.LOG,'Debug 1');

418: RAISE e_prim_assg_error;
419: END IF;
420: CLOSE csr_get_prim_assg;
421:
422: -- fnd_file.put_line(fnd_file.LOG,'Debug 1');
423:
424: /* Initialize values for input value names of the seeded element */
425: l_input_value_name1 := 'Method of Receipt';
426: l_input_value_name2 := 'Tax Card Type';

Line 451: --fnd_file.put_line(fnd_file.LOG,'Debug14_1');

447: and t.legislation_code ='DK'
448: and t.name = l_input_value_name1
449: and tl.language ='US';
450:
451: --fnd_file.put_line(fnd_file.LOG,'Debug14_1');
452:
453: select tl.name
454: into l_input_value_name2
455: from pay_input_values_f_tl tl, pay_input_values_f t

Line 461: --fnd_file.put_line(fnd_file.LOG,'Debug14_2');

457: and t.legislation_code ='DK'
458: and t.name = l_input_value_name2
459: and tl.language ='US';
460:
461: --fnd_file.put_line(fnd_file.LOG,'Debug14_2');
462:
463: select tl.name
464: into l_input_value_name3
465: from pay_input_values_f_tl tl, pay_input_values_f t

Line 471: --fnd_file.put_line(fnd_file.LOG,'Debug14_3');

467: and t.legislation_code ='DK'
468: and t.name = l_input_value_name3
469: and tl.language ='US';
470:
471: --fnd_file.put_line(fnd_file.LOG,'Debug14_3');
472: select tl.name
473: into l_input_value_name4
474: from pay_input_values_f_tl tl, pay_input_values_f t
475: where t.input_value_id = tl.input_value_id

Line 480: --fnd_file.put_line(fnd_file.LOG,'Debug14_4');

476: and t.legislation_code ='DK'
477: and t.name = l_input_value_name4
478: and tl.language ='US';
479:
480: --fnd_file.put_line(fnd_file.LOG,'Debug14_4');
481: select tl.name
482: into l_input_value_name5
483: from pay_input_values_f_tl tl, pay_input_values_f t
484: where t.input_value_id = tl.input_value_id

Line 489: --fnd_file.put_line(fnd_file.LOG,'Debug14_5');

485: and t.legislation_code ='DK'
486: and t.name = l_input_value_name5
487: and tl.language ='US';
488:
489: --fnd_file.put_line(fnd_file.LOG,'Debug14_5');
490: select tl.name
491: into l_input_value_name6
492: from pay_input_values_f_tl tl, pay_input_values_f t
493: where t.input_value_id = tl.input_value_id

Line 498: --fnd_file.put_line(fnd_file.LOG,'Debug14_6');

494: and t.legislation_code ='DK'
495: and t.name = l_input_value_name6
496: and tl.language ='US';
497:
498: --fnd_file.put_line(fnd_file.LOG,'Debug14_6');
499: select tl.name
500: into l_input_value_name7
501: from pay_input_values_f_tl tl, pay_input_values_f t
502: where t.input_value_id = tl.input_value_id

Line 516: -- fnd_file.put_line(fnd_file.LOG,' l_assignment_id : '||l_assignment_id);

512: and t.name = l_input_value_name8
513: and tl.language ='US';
514: /* Fix for Flugger - ends*/
515:
516: -- fnd_file.put_line(fnd_file.LOG,' l_assignment_id : '||l_assignment_id);
517:
518: --fnd_file.put_line(fnd_file.LOG,'bfore getting element details...');
519:
520: OPEN csr_get_element_details(l_assignment_id, to_date(l_effective_date,'yyyymmdd'));

Line 518: --fnd_file.put_line(fnd_file.LOG,'bfore getting element details...');

514: /* Fix for Flugger - ends*/
515:
516: -- fnd_file.put_line(fnd_file.LOG,' l_assignment_id : '||l_assignment_id);
517:
518: --fnd_file.put_line(fnd_file.LOG,'bfore getting element details...');
519:
520: OPEN csr_get_element_details(l_assignment_id, to_date(l_effective_date,'yyyymmdd'));
521: FETCH csr_get_element_details
522: INTO l_element_entry_id,l_element_name,l_effective_start_date,l_effective_end_date;

Line 545: --fnd_file.put_line(fnd_file.LOG,'l_effective_date : '||l_effective_date);

541: and ELEMENT.LEGISLATION_CODE ='DK'
542: and ELEMENT.ELEMENT_NAME = 'Tax Card'
543: AND ELEMENTTL.LANGUAGE = 'US';
544:
545: --fnd_file.put_line(fnd_file.LOG,'l_effective_date : '||l_effective_date);
546: --fnd_file.put_line(fnd_file.LOG,'Before calling get_element_link_id');
547: -- Modified for Flugger fix
548: l_element_link_id := get_element_link_id(l_assignment_id, p_business_group_id, to_date(l_effective_date,'yyyymmdd'), l_element_name_tl);
549: hr_utility.set_location ( ' The Element Staus = '||l_element_link_found , 70);

Line 546: --fnd_file.put_line(fnd_file.LOG,'Before calling get_element_link_id');

542: and ELEMENT.ELEMENT_NAME = 'Tax Card'
543: AND ELEMENTTL.LANGUAGE = 'US';
544:
545: --fnd_file.put_line(fnd_file.LOG,'l_effective_date : '||l_effective_date);
546: --fnd_file.put_line(fnd_file.LOG,'Before calling get_element_link_id');
547: -- Modified for Flugger fix
548: l_element_link_id := get_element_link_id(l_assignment_id, p_business_group_id, to_date(l_effective_date,'yyyymmdd'), l_element_name_tl);
549: hr_utility.set_location ( ' The Element Staus = '||l_element_link_found , 70);
550: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 70);

Line 561: -- fnd_file.put_line(fnd_file.LOG,'l_element_link_id : '||l_element_link_id);

557: l_ee_user_key:=NULL;
558: L_ASSIGNMENT_USER_KEY:=NULL;
559: L_ELEMENT_LINK_USER_KEY:=NULL;
560:
561: -- fnd_file.put_line(fnd_file.LOG,'l_element_link_id : '||l_element_link_id);
562: IF l_element_link_found = 'FOUND' THEN
563: l_ee_user_key := to_char(l_assignment_id )||to_char(L_ELEMENT_LINK_ID) ||' : ELEMENT ENTRY USER KEY';
564: OPEN csr_get_user_key(l_ee_user_key);
565: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;

Line 592: --fnd_file.put_line(fnd_file.LOG,'l_datetrack_update_mode : '||l_datetrack_update_mode);

588: ELSE
589: l_datetrack_update_mode := 'UPDATE';
590: END IF;
591:
592: --fnd_file.put_line(fnd_file.LOG,'l_datetrack_update_mode : '||l_datetrack_update_mode);
593:
594: hr_utility.set_location ( ' Datetrack Update Mode:' || l_datetrack_update_mode, 90);
595: -- Data Pump procedure called to create batch lines to update element entries
596: -- Bug fix 4215700

Line 636: -- fnd_file.put_line (fnd_file.LOG,'After hrdpp_update_element_entry.insert_batch_lines 1');

632: ,P_INPUT_VALUE_NAME13 =>l_input_value_name13
633: ,P_INPUT_VALUE_NAME14 =>l_input_value_name14
634: ,P_INPUT_VALUE_NAME15 =>l_input_value_name15);
635:
636: -- fnd_file.put_line (fnd_file.LOG,'After hrdpp_update_element_entry.insert_batch_lines 1');
637: -- End Bug fix 4215700
638: hr_utility.set_location ( ' Batch Lines created for Element Updation: ' , 100);
639: ELSE
640:

Line 641: -- fnd_file.put_line(fnd_file.LOG,'debug else1 ');

637: -- End Bug fix 4215700
638: hr_utility.set_location ( ' Batch Lines created for Element Updation: ' , 100);
639: ELSE
640:
641: -- fnd_file.put_line(fnd_file.LOG,'debug else1 ');
642:
643: l_ee_user_key :=to_char(l_assignment_id )||to_char(L_ELEMENT_LINK_ID) ||' : ELEMENT ENTRY USER KEY';
644: L_ASSIGNMENT_USER_KEY :=to_char(l_assignment_id )||' : ASG USER KEY';
645: L_ELEMENT_LINK_USER_KEY :=to_char(L_ELEMENT_LINK_ID) ||' : ELEM LINK USER KEY';

Line 657: --fnd_file.put_line(fnd_file.LOG,'debug else2 ');

653: end;
654: END IF;
655: CLOSE csr_get_user_key;
656:
657: --fnd_file.put_line(fnd_file.LOG,'debug else2 ');
658: OPEN csr_get_user_key(L_ASSIGNMENT_USER_KEY);
659: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
660: -- Add user key only if it does not exist previously
661: IF csr_get_user_key%NOTFOUND THEN

Line 666: --fnd_file.put_line(fnd_file.LOG,'debug else3 ');

662: hr_pump_utils.add_user_key(L_ASSIGNMENT_USER_KEY,l_assignment_id);
663: END IF;
664: CLOSE csr_get_user_key;
665:
666: --fnd_file.put_line(fnd_file.LOG,'debug else3 ');
667: OPEN csr_get_user_key(L_ELEMENT_LINK_USER_KEY);
668: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
669: -- Add user key only if it does not exist previously
670: IF csr_get_user_key%NOTFOUND THEN

Line 675: --fnd_file.put_line(fnd_file.LOG,'debug else4 ');

671: hr_pump_utils.add_user_key(L_ELEMENT_LINK_USER_KEY,L_ELEMENT_LINK_ID);
672: END IF;
673: CLOSE csr_get_user_key;
674:
675: --fnd_file.put_line(fnd_file.LOG,'debug else4 ');
676: -- Bug fix 4215700
677: hrdpp_create_element_entry.insert_batch_lines
678: (p_batch_id => l_batch_id
679: ,p_data_pump_business_grp_name => l_bg_name

Line 721: -- fnd_file.put_line (fnd_file.LOG,'After hrdpp_update_element_entry.insert_batch_lines 2');

717: ,P_INPUT_VALUE_NAME15 =>l_input_value_name15);
718: -- End Bug fix 4215700
719: hr_utility.set_location ( ' Batch Lines created for Element Creation: ' , 100);
720:
721: -- fnd_file.put_line (fnd_file.LOG,'After hrdpp_update_element_entry.insert_batch_lines 2');
722: END IF;
723: hr_utility.set_location ( ' Batch Lines created ' , 100);
724: -- commit the records uppon reaching the commit point
725: IF MOD (l_batch_seq, c_commit_point) = 0 THEN

Line 748: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

744: hr_utility.set_message_token (801, 'LINE', l_line_read);
745: hr_utility.set_location (l_proc, 110);
746: -- Write the message to log file, do not raise an application error but continue
747: -- (with next line)
748: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
749:
750: WHEN e_prim_assg_error THEN
751: -- No primary assignment found for given CPR Number and CVR Number
752: -- Close the cursor

Line 763: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

759: hr_utility.set_message (801, 'PAY_377016_DK_ASSG_NOT_FOUND');
760: hr_utility.set_message_token (801, 'LINE_N0', l_batch_seq);
761: hr_utility.set_message_token (801, 'LINE', l_line_read);
762: hr_utility.set_location (l_proc, 120);
763: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
764:
765: WHEN e_record_length_err THEN
766: --Record is too long
767: -- Set retcode to 1, indicating a WARNING to the ConcMgr

Line 777: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

773: hr_utility.set_message_token (801, 'RECLEN', l_record_length);
774: hr_utility.set_location (l_proc, 150);
775: -- Write the message to log file, do not raise an application error but continue
776: -- (with next line)
777: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
778:
779: WHEN e_no_tax_link THEN
780: -- Wrong CSR routine
781: -- Set retcode to 1, indicating a WARNING to the ConcMgr

Line 791: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

787: hr_utility.set_message_token (801, 'LINE', l_line_read);
788: hr_utility.set_location (l_proc, 320);
789: -- Write the message to log file, do not raise an application error but continue
790: -- (with next line)
791: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
792:
793: -- Bug fixes 4216001 and 4216029
794: WHEN e_invalid_tax_card_type THEN
795: -- Wrong CSR routine

Line 805: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

801: hr_utility.set_message_token (801, 'LINE', l_line_read);
802: hr_utility.set_location (l_proc, 320);
803: -- Write the message to log file, do not raise an application error but continue
804: -- (with next line)
805: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
806:
807: WHEN e_tax_percentage_err THEN
808: -- Wrong CSR routine
809: -- Set retcode to 1, indicating a WARNING to the ConcMgr

Line 818: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

814: hr_utility.set_message_token (801, 'LINE', l_line_read);
815: hr_utility.set_location (l_proc, 320);
816: -- Write the message to log file, do not raise an application error but continue
817: -- (with next line)
818: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
819:
820:
821: WHEN others THEN
822: -- Set retcode to 1, indicating a WARNING to the ConcMgr

Line 825: fnd_file.put_line (fnd_file.LOG, SQLERRM);

821: WHEN others THEN
822: -- Set retcode to 1, indicating a WARNING to the ConcMgr
823: retcode := c_warning;
824: -- Set the application error
825: fnd_file.put_line (fnd_file.LOG, SQLERRM);
826: hr_utility.set_message (801, 'PAY_377025_DK_INVALID_LINE');
827: hr_utility.set_message_token (801, 'LINE_N0', l_batch_seq);
828: hr_utility.set_message_token (801, 'LINE', l_line_read);
829: hr_utility.set_location (l_proc, 120);

Line 830: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

826: hr_utility.set_message (801, 'PAY_377025_DK_INVALID_LINE');
827: hr_utility.set_message_token (801, 'LINE_N0', l_batch_seq);
828: hr_utility.set_message_token (801, 'LINE', l_line_read);
829: hr_utility.set_location (l_proc, 120);
830: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
831:
832: -- end of Bug fixes 4216001 and 4216029
833:
834: END;

Line 960: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

956: retcode := c_error;
957: -- Set the application error
958: hr_utility.set_message (801, 'PAY_377024_DK_LEGAL_EMPLOYER_E');
959: hr_utility.set_location (l_proc, 120);
960: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
961:
962: WHEN e_file_format_err THEN
963: -- Set retcode to 1, indicating a WARNING to the ConcMgr
964: retcode := c_error;

Line 968: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

964: retcode := c_error;
965: -- Set the application error
966: hr_utility.set_message (801, 'PAY_377021_DK_INVALID_FILE_FMT');
967: hr_utility.set_location (l_proc, 120);
968: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
969: END upload;
970:
971:
972: PROCEDURE read_record

Line 1081: -- fnd_file.put_line (fnd_file.LOG,'Line read : '||p_line);

1077: hr_utility.set_location ('Wrong Tax Record', 40);
1078: RAISE e_wrong_indvnr;
1079: END IF;
1080:
1081: -- fnd_file.put_line (fnd_file.LOG,'Line read : '||p_line);
1082: -- fnd_file.put_line (fnd_file.LOG,'Line Length : '||length(p_line));
1083:
1084: --9543947
1085: IF ASCII(substr( p_line ,160,1)) = '13' THEN

Line 1082: -- fnd_file.put_line (fnd_file.LOG,'Line Length : '||length(p_line));

1078: RAISE e_wrong_indvnr;
1079: END IF;
1080:
1081: -- fnd_file.put_line (fnd_file.LOG,'Line read : '||p_line);
1082: -- fnd_file.put_line (fnd_file.LOG,'Line Length : '||length(p_line));
1083:
1084: --9543947
1085: IF ASCII(substr( p_line ,160,1)) = '13' THEN
1086: l_line := substr(p_line,1,159);

Line 1106: fnd_file.put_line (fnd_file.LOG,'Tax card type : '||p_entry_value2);

1102: hr_utility.set_location ( ' Tax Percentage:'|| p_entry_value5, 68);
1103: hr_utility.set_location ( ' Tax Card Type:'|| p_entry_value6, 69);
1104:
1105:
1106: fnd_file.put_line (fnd_file.LOG,'Tax card type : '||p_entry_value2);
1107: fnd_file.put_line (fnd_file.LOG,'Tax % : '||p_entry_value3);
1108: fnd_file.put_line (fnd_file.LOG,'tax limit : '||p_entry_value4);
1109: fnd_file.put_line (fnd_file.LOG,'monthly tax : '||p_entry_value5);
1110: fnd_file.put_line (fnd_file.LOG,'bi weekly tax : '||p_entry_value6);

Line 1107: fnd_file.put_line (fnd_file.LOG,'Tax % : '||p_entry_value3);

1103: hr_utility.set_location ( ' Tax Card Type:'|| p_entry_value6, 69);
1104:
1105:
1106: fnd_file.put_line (fnd_file.LOG,'Tax card type : '||p_entry_value2);
1107: fnd_file.put_line (fnd_file.LOG,'Tax % : '||p_entry_value3);
1108: fnd_file.put_line (fnd_file.LOG,'tax limit : '||p_entry_value4);
1109: fnd_file.put_line (fnd_file.LOG,'monthly tax : '||p_entry_value5);
1110: fnd_file.put_line (fnd_file.LOG,'bi weekly tax : '||p_entry_value6);
1111: fnd_file.put_line (fnd_file.LOG,'weekly tax : '||p_entry_value7);

Line 1108: fnd_file.put_line (fnd_file.LOG,'tax limit : '||p_entry_value4);

1104:
1105:
1106: fnd_file.put_line (fnd_file.LOG,'Tax card type : '||p_entry_value2);
1107: fnd_file.put_line (fnd_file.LOG,'Tax % : '||p_entry_value3);
1108: fnd_file.put_line (fnd_file.LOG,'tax limit : '||p_entry_value4);
1109: fnd_file.put_line (fnd_file.LOG,'monthly tax : '||p_entry_value5);
1110: fnd_file.put_line (fnd_file.LOG,'bi weekly tax : '||p_entry_value6);
1111: fnd_file.put_line (fnd_file.LOG,'weekly tax : '||p_entry_value7);
1112: fnd_file.put_line (fnd_file.LOG,'daily tax : '||p_entry_value8);

Line 1109: fnd_file.put_line (fnd_file.LOG,'monthly tax : '||p_entry_value5);

1105:
1106: fnd_file.put_line (fnd_file.LOG,'Tax card type : '||p_entry_value2);
1107: fnd_file.put_line (fnd_file.LOG,'Tax % : '||p_entry_value3);
1108: fnd_file.put_line (fnd_file.LOG,'tax limit : '||p_entry_value4);
1109: fnd_file.put_line (fnd_file.LOG,'monthly tax : '||p_entry_value5);
1110: fnd_file.put_line (fnd_file.LOG,'bi weekly tax : '||p_entry_value6);
1111: fnd_file.put_line (fnd_file.LOG,'weekly tax : '||p_entry_value7);
1112: fnd_file.put_line (fnd_file.LOG,'daily tax : '||p_entry_value8);
1113: fnd_file.put_line (fnd_file.LOG,'start date : '||p_return_value3);

Line 1110: fnd_file.put_line (fnd_file.LOG,'bi weekly tax : '||p_entry_value6);

1106: fnd_file.put_line (fnd_file.LOG,'Tax card type : '||p_entry_value2);
1107: fnd_file.put_line (fnd_file.LOG,'Tax % : '||p_entry_value3);
1108: fnd_file.put_line (fnd_file.LOG,'tax limit : '||p_entry_value4);
1109: fnd_file.put_line (fnd_file.LOG,'monthly tax : '||p_entry_value5);
1110: fnd_file.put_line (fnd_file.LOG,'bi weekly tax : '||p_entry_value6);
1111: fnd_file.put_line (fnd_file.LOG,'weekly tax : '||p_entry_value7);
1112: fnd_file.put_line (fnd_file.LOG,'daily tax : '||p_entry_value8);
1113: fnd_file.put_line (fnd_file.LOG,'start date : '||p_return_value3);
1114: */

Line 1111: fnd_file.put_line (fnd_file.LOG,'weekly tax : '||p_entry_value7);

1107: fnd_file.put_line (fnd_file.LOG,'Tax % : '||p_entry_value3);
1108: fnd_file.put_line (fnd_file.LOG,'tax limit : '||p_entry_value4);
1109: fnd_file.put_line (fnd_file.LOG,'monthly tax : '||p_entry_value5);
1110: fnd_file.put_line (fnd_file.LOG,'bi weekly tax : '||p_entry_value6);
1111: fnd_file.put_line (fnd_file.LOG,'weekly tax : '||p_entry_value7);
1112: fnd_file.put_line (fnd_file.LOG,'daily tax : '||p_entry_value8);
1113: fnd_file.put_line (fnd_file.LOG,'start date : '||p_return_value3);
1114: */
1115: hr_utility.set_location ( 'Leaving:'|| l_proc, 100);

Line 1112: fnd_file.put_line (fnd_file.LOG,'daily tax : '||p_entry_value8);

1108: fnd_file.put_line (fnd_file.LOG,'tax limit : '||p_entry_value4);
1109: fnd_file.put_line (fnd_file.LOG,'monthly tax : '||p_entry_value5);
1110: fnd_file.put_line (fnd_file.LOG,'bi weekly tax : '||p_entry_value6);
1111: fnd_file.put_line (fnd_file.LOG,'weekly tax : '||p_entry_value7);
1112: fnd_file.put_line (fnd_file.LOG,'daily tax : '||p_entry_value8);
1113: fnd_file.put_line (fnd_file.LOG,'start date : '||p_return_value3);
1114: */
1115: hr_utility.set_location ( 'Leaving:'|| l_proc, 100);
1116: END read_record;

Line 1113: fnd_file.put_line (fnd_file.LOG,'start date : '||p_return_value3);

1109: fnd_file.put_line (fnd_file.LOG,'monthly tax : '||p_entry_value5);
1110: fnd_file.put_line (fnd_file.LOG,'bi weekly tax : '||p_entry_value6);
1111: fnd_file.put_line (fnd_file.LOG,'weekly tax : '||p_entry_value7);
1112: fnd_file.put_line (fnd_file.LOG,'daily tax : '||p_entry_value8);
1113: fnd_file.put_line (fnd_file.LOG,'start date : '||p_return_value3);
1114: */
1115: hr_utility.set_location ( 'Leaving:'|| l_proc, 100);
1116: END read_record;
1117: /* Function to get the element link ID */