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_KR_YEA_PDF_PKG dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: c_package constant varchar2(30) := 'pay_kr_yea_pdf_pkg.';
5: c_legislation_code varchar2(2) := 'KR';
6: --
7: g_debug boolean := hr_utility.debug_enabled;
8: g_upload boolean := true;
9: --
10: g_msg fnd_new_messages.message_text%type;
11: --

Line 417: hr_utility.set_location(l_proc,0);

413: --
414: begin
415: --
416: if g_debug then
417: hr_utility.set_location(l_proc,0);
418: end if;
419: --
420: if g_load_type is null then
421: g_load_type := 'L';

Line 466: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));

462: insert_session(g_target_eoy);
463: end if;
464: --
465: if g_debug then
466: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
467: hr_utility.trace('g_target_yyyy : '||to_char(g_target_yyyy));
468: hr_utility.trace('g_business_place_id : '||to_char(g_business_place_id));
469: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
470: hr_utility.trace('g_remove_pdf : '||g_remove_pdf);

Line 467: hr_utility.trace('g_target_yyyy : '||to_char(g_target_yyyy));

463: end if;
464: --
465: if g_debug then
466: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
467: hr_utility.trace('g_target_yyyy : '||to_char(g_target_yyyy));
468: hr_utility.trace('g_business_place_id : '||to_char(g_business_place_id));
469: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
470: hr_utility.trace('g_remove_pdf : '||g_remove_pdf);
471: hr_utility.trace('g_map_key : '||g_map_key);

Line 468: hr_utility.trace('g_business_place_id : '||to_char(g_business_place_id));

464: --
465: if g_debug then
466: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
467: hr_utility.trace('g_target_yyyy : '||to_char(g_target_yyyy));
468: hr_utility.trace('g_business_place_id : '||to_char(g_business_place_id));
469: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
470: hr_utility.trace('g_remove_pdf : '||g_remove_pdf);
471: hr_utility.trace('g_map_key : '||g_map_key);
472: hr_utility.trace('g_force_load : '||g_force_load);

Line 469: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));

465: if g_debug then
466: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
467: hr_utility.trace('g_target_yyyy : '||to_char(g_target_yyyy));
468: hr_utility.trace('g_business_place_id : '||to_char(g_business_place_id));
469: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
470: hr_utility.trace('g_remove_pdf : '||g_remove_pdf);
471: hr_utility.trace('g_map_key : '||g_map_key);
472: hr_utility.trace('g_force_load : '||g_force_load);
473: hr_utility.trace('g_skip_validate : '||g_skip_validate);

Line 470: hr_utility.trace('g_remove_pdf : '||g_remove_pdf);

466: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
467: hr_utility.trace('g_target_yyyy : '||to_char(g_target_yyyy));
468: hr_utility.trace('g_business_place_id : '||to_char(g_business_place_id));
469: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
470: hr_utility.trace('g_remove_pdf : '||g_remove_pdf);
471: hr_utility.trace('g_map_key : '||g_map_key);
472: hr_utility.trace('g_force_load : '||g_force_load);
473: hr_utility.trace('g_skip_validate : '||g_skip_validate);
474: hr_utility.trace('p_import_path : '||g_import_path);

Line 471: hr_utility.trace('g_map_key : '||g_map_key);

467: hr_utility.trace('g_target_yyyy : '||to_char(g_target_yyyy));
468: hr_utility.trace('g_business_place_id : '||to_char(g_business_place_id));
469: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
470: hr_utility.trace('g_remove_pdf : '||g_remove_pdf);
471: hr_utility.trace('g_map_key : '||g_map_key);
472: hr_utility.trace('g_force_load : '||g_force_load);
473: hr_utility.trace('g_skip_validate : '||g_skip_validate);
474: hr_utility.trace('p_import_path : '||g_import_path);
475: hr_utility.trace('p_nts_certs_path : '||p_nts_certs_path);

Line 472: hr_utility.trace('g_force_load : '||g_force_load);

468: hr_utility.trace('g_business_place_id : '||to_char(g_business_place_id));
469: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
470: hr_utility.trace('g_remove_pdf : '||g_remove_pdf);
471: hr_utility.trace('g_map_key : '||g_map_key);
472: hr_utility.trace('g_force_load : '||g_force_load);
473: hr_utility.trace('g_skip_validate : '||g_skip_validate);
474: hr_utility.trace('p_import_path : '||g_import_path);
475: hr_utility.trace('p_nts_certs_path : '||p_nts_certs_path);
476: end if;

Line 473: hr_utility.trace('g_skip_validate : '||g_skip_validate);

469: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
470: hr_utility.trace('g_remove_pdf : '||g_remove_pdf);
471: hr_utility.trace('g_map_key : '||g_map_key);
472: hr_utility.trace('g_force_load : '||g_force_load);
473: hr_utility.trace('g_skip_validate : '||g_skip_validate);
474: hr_utility.trace('p_import_path : '||g_import_path);
475: hr_utility.trace('p_nts_certs_path : '||p_nts_certs_path);
476: end if;
477: --

Line 474: hr_utility.trace('p_import_path : '||g_import_path);

470: hr_utility.trace('g_remove_pdf : '||g_remove_pdf);
471: hr_utility.trace('g_map_key : '||g_map_key);
472: hr_utility.trace('g_force_load : '||g_force_load);
473: hr_utility.trace('g_skip_validate : '||g_skip_validate);
474: hr_utility.trace('p_import_path : '||g_import_path);
475: hr_utility.trace('p_nts_certs_path : '||p_nts_certs_path);
476: end if;
477: --
478: if g_debug then

Line 475: hr_utility.trace('p_nts_certs_path : '||p_nts_certs_path);

471: hr_utility.trace('g_map_key : '||g_map_key);
472: hr_utility.trace('g_force_load : '||g_force_load);
473: hr_utility.trace('g_skip_validate : '||g_skip_validate);
474: hr_utility.trace('p_import_path : '||g_import_path);
475: hr_utility.trace('p_nts_certs_path : '||p_nts_certs_path);
476: end if;
477: --
478: if g_debug then
479: hr_utility.set_location(l_proc,1000);

Line 479: hr_utility.set_location(l_proc,1000);

475: hr_utility.trace('p_nts_certs_path : '||p_nts_certs_path);
476: end if;
477: --
478: if g_debug then
479: hr_utility.set_location(l_proc,1000);
480: end if;
481: --
482: end load_init;
483: --

Line 505: hr_utility.set_location(l_proc,0);

501: --
502: begin
503: --
504: if g_debug then
505: hr_utility.set_location(l_proc,0);
506: end if;
507: --
508: g_load_type := 'I';
509: --

Line 522: hr_utility.set_location(l_proc,1000);

518: p_import_path => p_import_path,
519: p_nts_certs_path => l_nts_certs_path);
520: --
521: if g_debug then
522: hr_utility.set_location(l_proc,1000);
523: end if;
524: --
525: end import_init;
526: --

Line 543: hr_utility.set_location(l_proc,0);

539: --
540: begin
541: --
542: if g_debug then
543: hr_utility.set_location(l_proc,0);
544: end if;
545: --
546: g_pdf_ind := 0;
547: g_pdf_tbl.delete;

Line 561: hr_utility.trace('g_pdf_tbl.count : '||to_char(g_pdf_tbl.count));

557: --
558: --fnd_file.put_line(fnd_file.log,'g_pdf_tbl.count : '||to_char(g_pdf_tbl.count));
559: --
560: if g_debug then
561: hr_utility.trace('g_pdf_tbl.count : '||to_char(g_pdf_tbl.count));
562: end if;
563: --
564: -- bulk collect start from 1
565: g_pdf_ind := g_pdf_tbl.next(0);

Line 568: hr_utility.set_location(l_proc,1000);

564: -- bulk collect start from 1
565: g_pdf_ind := g_pdf_tbl.next(0);
566: --
567: if g_debug then
568: hr_utility.set_location(l_proc,1000);
569: end if;
570: --
571: end set_pdf_tbl;
572: --

Line 595: hr_utility.set_location(l_proc,0);

591: --
592: begin
593: --
594: if g_debug then
595: hr_utility.set_location(l_proc,0);
596: end if;
597: --
598: if g_pdf_tbl.count > 0 then
599: --

Line 637: hr_utility.set_location(l_proc,1000);

633: --
634: end if;
635: --
636: if g_debug then
637: hr_utility.set_location(l_proc,1000);
638: end if;
639: --
640: end proc_set;
641: --

Line 667: hr_utility.set_location(l_proc,0);

663: --
664: begin
665: --
666: if g_debug then
667: hr_utility.set_location(l_proc,0);
668: end if;
669: --
670: g_load_type := 'U';
671: --

Line 696: hr_utility.set_location(l_proc,1000);

692: --
693: proc_set;
694: --
695: if g_debug then
696: hr_utility.set_location(l_proc,1000);
697: end if;
698: --
699: end upload_init;
700: --

Line 742: hr_utility.set_location(l_proc,0);

738: --
739: begin
740: --
741: if g_debug then
742: hr_utility.set_location(l_proc,0);
743: end if;
744: --
745: begin
746: --

Line 754: hr_utility.set_location(l_proc,10);

750: --
751: if l_csr_kr_ass_yea.assignment_yea_info_id is not null then
752: --
753: if g_debug then
754: hr_utility.set_location(l_proc,10);
755: end if;
756: --
757: l_assignment_yea_info_id := l_csr_kr_ass_yea.assignment_yea_info_id;
758: l_object_version_number := l_csr_kr_ass_yea.object_version_number + 1;

Line 780: hr_utility.set_location(l_proc,20);

776: --
777: fnd_gfm.delete_lob(l_csr_file.file_id);
778: --
779: if g_debug then
780: hr_utility.set_location(l_proc,20);
781: end if;
782: --
783: end if;
784: --

Line 828: hr_utility.trace('skipped because p_assignment_id : '||to_char(p_assignment_id)||' entry status was locked.');

824: --
825: fnd_file.put_line(fnd_file.log,g_msg);
826: --
827: if g_debug then
828: hr_utility.trace('skipped because p_assignment_id : '||to_char(p_assignment_id)||' entry status was locked.');
829: end if;
830: --
831: end;
832: --

Line 836: hr_utility.set_location(l_proc,1000);

832: --
833: p_assignment_yea_info_id := l_assignment_yea_info_id;
834: --
835: if g_debug then
836: hr_utility.set_location(l_proc,1000);
837: end if;
838: --
839: end import_kr_ass_yea;
840: --

Line 860: hr_utility.set_location(l_proc,10);

856: --
857: begin
858: --
859: if g_debug then
860: hr_utility.set_location(l_proc,10);
861: end if;
862: --
863: g_ass_yea_tbl.delete;
864: g_ass_yea_ind := 0;

Line 872: hr_utility.trace('file name : '||l_file_name);

868: l_file_name := substrb(l_file_name,instrb(l_file_name,g_path_delimiter,'-1'));
869: end if;
870: --
871: if g_debug then
872: hr_utility.trace('file name : '||l_file_name);
873: end if;
874: --
875: open csr_map_name(l_file_name);
876: loop

Line 884: hr_utility.set_location(l_proc,20);

880: --
881: l_ass_yea_info_id := null;
882: --
883: if g_debug then
884: hr_utility.set_location(l_proc,20);
885: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
886: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);
887: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
888: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));

Line 885: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);

881: l_ass_yea_info_id := null;
882: --
883: if g_debug then
884: hr_utility.set_location(l_proc,20);
885: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
886: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);
887: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
888: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
889: --

Line 886: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);

882: --
883: if g_debug then
884: hr_utility.set_location(l_proc,20);
885: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
886: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);
887: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
888: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
889: --
890: --fnd_file.put_line(fnd_file.log,'emp num : '||l_csr_map_name.emp_num);

Line 887: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);

883: if g_debug then
884: hr_utility.set_location(l_proc,20);
885: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
886: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);
887: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
888: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
889: --
890: --fnd_file.put_line(fnd_file.log,'emp num : '||l_csr_map_name.emp_num);
891: --fnd_file.put_line(fnd_file.log,'ass id : '||to_char(l_csr_map_name.assignment_id));

Line 888: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));

884: hr_utility.set_location(l_proc,20);
885: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
886: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);
887: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
888: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
889: --
890: --fnd_file.put_line(fnd_file.log,'emp num : '||l_csr_map_name.emp_num);
891: --fnd_file.put_line(fnd_file.log,'ass id : '||to_char(l_csr_map_name.assignment_id));
892: end if;

Line 906: hr_utility.trace('file id : '||to_char(l_file_id));

902: --
903: l_file_id := fnd_gfm.file_close(l_file_id);
904: --
905: if g_debug then
906: hr_utility.trace('file id : '||to_char(l_file_id));
907: hr_utility.set_location(l_proc,30);
908: end if;
909: --
910: end if;

Line 907: hr_utility.set_location(l_proc,30);

903: l_file_id := fnd_gfm.file_close(l_file_id);
904: --
905: if g_debug then
906: hr_utility.trace('file id : '||to_char(l_file_id));
907: hr_utility.set_location(l_proc,30);
908: end if;
909: --
910: end if;
911: --

Line 931: hr_utility.trace('l_file_id : '||to_char(l_file_id)||' has been cancelled because invalid map.');

927: else
928: --
929: if g_debug then
930: --
931: hr_utility.trace('l_file_id : '||to_char(l_file_id)||' has been cancelled because invalid map.');
932: --
933: end if;
934: --
935: if nvl(g_remove_pdf,'N') = 'Y' then

Line 953: hr_utility.trace('g_ass_yea_tbl.count : '||to_char(g_ass_yea_tbl.count));

949: --
950: --fnd_file.put_line(fnd_file.log,'g_ass_yea_tbl.count : '||to_char(g_ass_yea_tbl.count));
951: if g_debug then
952: --
953: hr_utility.trace('g_ass_yea_tbl.count : '||to_char(g_ass_yea_tbl.count));
954: hr_utility.trace('g_ass_yea_ind : '||to_char(g_ass_yea_ind));
955: hr_utility.trace('l_file_id : '||to_char(l_file_id));
956: hr_utility.set_location(l_proc,1000);
957: --

Line 954: hr_utility.trace('g_ass_yea_ind : '||to_char(g_ass_yea_ind));

950: --fnd_file.put_line(fnd_file.log,'g_ass_yea_tbl.count : '||to_char(g_ass_yea_tbl.count));
951: if g_debug then
952: --
953: hr_utility.trace('g_ass_yea_tbl.count : '||to_char(g_ass_yea_tbl.count));
954: hr_utility.trace('g_ass_yea_ind : '||to_char(g_ass_yea_ind));
955: hr_utility.trace('l_file_id : '||to_char(l_file_id));
956: hr_utility.set_location(l_proc,1000);
957: --
958: end if;

Line 955: hr_utility.trace('l_file_id : '||to_char(l_file_id));

951: if g_debug then
952: --
953: hr_utility.trace('g_ass_yea_tbl.count : '||to_char(g_ass_yea_tbl.count));
954: hr_utility.trace('g_ass_yea_ind : '||to_char(g_ass_yea_ind));
955: hr_utility.trace('l_file_id : '||to_char(l_file_id));
956: hr_utility.set_location(l_proc,1000);
957: --
958: end if;
959: --

Line 956: hr_utility.set_location(l_proc,1000);

952: --
953: hr_utility.trace('g_ass_yea_tbl.count : '||to_char(g_ass_yea_tbl.count));
954: hr_utility.trace('g_ass_yea_ind : '||to_char(g_ass_yea_ind));
955: hr_utility.trace('l_file_id : '||to_char(l_file_id));
956: hr_utility.set_location(l_proc,1000);
957: --
958: end if;
959: --
960: return l_file_id;

Line 976: hr_utility.set_location(l_proc,0);

972: --
973: begin
974: --
975: if g_debug then
976: hr_utility.set_location(l_proc,0);
977: end if;
978: --
979: if g_ass_yea_tbl.count > 0 then
980: --

Line 1026: hr_utility.trace('l_ass_cnt : '||to_char(l_ass_cnt));

1022: --
1023: g_file_ind := g_file_ind + 1;
1024: --
1025: if g_debug then
1026: hr_utility.trace('l_ass_cnt : '||to_char(l_ass_cnt));
1027: hr_utility.set_location(l_proc,1000);
1028: end if;
1029: --
1030: end import_post;

Line 1027: hr_utility.set_location(l_proc,1000);

1023: g_file_ind := g_file_ind + 1;
1024: --
1025: if g_debug then
1026: hr_utility.trace('l_ass_cnt : '||to_char(l_ass_cnt));
1027: hr_utility.set_location(l_proc,1000);
1028: end if;
1029: --
1030: end import_post;
1031: --

Line 1043: hr_utility.set_location(l_proc,0);

1039: --
1040: begin
1041: --
1042: if g_debug then
1043: hr_utility.set_location(l_proc,0);
1044: end if;
1045: --
1046: if g_ass_yea_tbl.count > 0 then
1047: --

Line 1069: hr_utility.set_location(l_proc,1000);

1065: --
1066: end if;
1067: --
1068: if g_debug then
1069: hr_utility.set_location(l_proc,1000);
1070: end if;
1071: --
1072: end import_error;
1073: --

Line 1090: hr_utility.set_location(l_proc,0);

1086: --
1087: begin
1088: --
1089: if g_debug then
1090: hr_utility.set_location(l_proc,0);
1091: end if;
1092: --
1093: -- blob will be null if g_pdf_ind is null (reached end)
1094: if g_pdf_ind is not null then

Line 1105: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').assignment_id : '||to_char(g_pdf_tbl(g_pdf_ind).assignment_id));

1101: p_blob := g_pdf_tbl(g_pdf_ind).pdf_file;
1102: --
1103: --fnd_file.put_line(fnd_file.log,'come get_pdf_blob : '||to_char(g_pdf_tbl(g_pdf_ind).assignment_id)||','||g_pdf_tbl(g_pdf_ind).emp_num);
1104: if g_debug then
1105: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').assignment_id : '||to_char(g_pdf_tbl(g_pdf_ind).assignment_id));
1106: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').ni_num : '||g_pdf_tbl(g_pdf_ind).ni_num);
1107: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').emp_num : '||g_pdf_tbl(g_pdf_ind).emp_num);
1108: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').emp_name : '||g_pdf_tbl(g_pdf_ind).emp_name);
1109: end if;

Line 1106: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').ni_num : '||g_pdf_tbl(g_pdf_ind).ni_num);

1102: --
1103: --fnd_file.put_line(fnd_file.log,'come get_pdf_blob : '||to_char(g_pdf_tbl(g_pdf_ind).assignment_id)||','||g_pdf_tbl(g_pdf_ind).emp_num);
1104: if g_debug then
1105: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').assignment_id : '||to_char(g_pdf_tbl(g_pdf_ind).assignment_id));
1106: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').ni_num : '||g_pdf_tbl(g_pdf_ind).ni_num);
1107: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').emp_num : '||g_pdf_tbl(g_pdf_ind).emp_num);
1108: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').emp_name : '||g_pdf_tbl(g_pdf_ind).emp_name);
1109: end if;
1110: --

Line 1107: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').emp_num : '||g_pdf_tbl(g_pdf_ind).emp_num);

1103: --fnd_file.put_line(fnd_file.log,'come get_pdf_blob : '||to_char(g_pdf_tbl(g_pdf_ind).assignment_id)||','||g_pdf_tbl(g_pdf_ind).emp_num);
1104: if g_debug then
1105: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').assignment_id : '||to_char(g_pdf_tbl(g_pdf_ind).assignment_id));
1106: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').ni_num : '||g_pdf_tbl(g_pdf_ind).ni_num);
1107: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').emp_num : '||g_pdf_tbl(g_pdf_ind).emp_num);
1108: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').emp_name : '||g_pdf_tbl(g_pdf_ind).emp_name);
1109: end if;
1110: --
1111: end if;

Line 1108: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').emp_name : '||g_pdf_tbl(g_pdf_ind).emp_name);

1104: if g_debug then
1105: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').assignment_id : '||to_char(g_pdf_tbl(g_pdf_ind).assignment_id));
1106: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').ni_num : '||g_pdf_tbl(g_pdf_ind).ni_num);
1107: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').emp_num : '||g_pdf_tbl(g_pdf_ind).emp_num);
1108: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').emp_name : '||g_pdf_tbl(g_pdf_ind).emp_name);
1109: end if;
1110: --
1111: end if;
1112: --

Line 1116: hr_utility.set_location(l_proc,1000);

1112: --
1113: end if;
1114: --
1115: if g_debug then
1116: hr_utility.set_location(l_proc,1000);
1117: end if;
1118: --
1119: end get_pdf_blob;
1120: --

Line 1145: hr_utility.set_location(l_proc,0);

1141: --
1142: begin
1143: --
1144: if g_debug then
1145: hr_utility.set_location(l_proc,0);
1146: hr_utility.trace('p_assignment_yea_info_id: '||p_assignment_yea_info_id);
1147: hr_utility.trace('p_force_upload: '||p_force_upload);
1148:
1149: end if;

Line 1146: hr_utility.trace('p_assignment_yea_info_id: '||p_assignment_yea_info_id);

1142: begin
1143: --
1144: if g_debug then
1145: hr_utility.set_location(l_proc,0);
1146: hr_utility.trace('p_assignment_yea_info_id: '||p_assignment_yea_info_id);
1147: hr_utility.trace('p_force_upload: '||p_force_upload);
1148:
1149: end if;
1150: --

Line 1147: hr_utility.trace('p_force_upload: '||p_force_upload);

1143: --
1144: if g_debug then
1145: hr_utility.set_location(l_proc,0);
1146: hr_utility.trace('p_assignment_yea_info_id: '||p_assignment_yea_info_id);
1147: hr_utility.trace('p_force_upload: '||p_force_upload);
1148:
1149: end if;
1150: --
1151: g_ss_call := 'Y';

Line 1170: hr_utility.trace('p_emp_num: '||p_emp_num);

1166: --
1167: g_ss_call := null;
1168: --
1169: if g_debug then
1170: hr_utility.trace('p_emp_num: '||p_emp_num);
1171: hr_utility.trace('p_emp_name: '||p_emp_name);
1172: hr_utility.trace('p_pdf_pwd: '||p_pdf_pwd);
1173: hr_utility.trace('p_nts_certs_path : '||p_pdf_pwd);
1174: hr_utility.set_location(l_proc,1000);

Line 1171: hr_utility.trace('p_emp_name: '||p_emp_name);

1167: g_ss_call := null;
1168: --
1169: if g_debug then
1170: hr_utility.trace('p_emp_num: '||p_emp_num);
1171: hr_utility.trace('p_emp_name: '||p_emp_name);
1172: hr_utility.trace('p_pdf_pwd: '||p_pdf_pwd);
1173: hr_utility.trace('p_nts_certs_path : '||p_pdf_pwd);
1174: hr_utility.set_location(l_proc,1000);
1175: end if;

Line 1172: hr_utility.trace('p_pdf_pwd: '||p_pdf_pwd);

1168: --
1169: if g_debug then
1170: hr_utility.trace('p_emp_num: '||p_emp_num);
1171: hr_utility.trace('p_emp_name: '||p_emp_name);
1172: hr_utility.trace('p_pdf_pwd: '||p_pdf_pwd);
1173: hr_utility.trace('p_nts_certs_path : '||p_pdf_pwd);
1174: hr_utility.set_location(l_proc,1000);
1175: end if;
1176: --

Line 1173: hr_utility.trace('p_nts_certs_path : '||p_pdf_pwd);

1169: if g_debug then
1170: hr_utility.trace('p_emp_num: '||p_emp_num);
1171: hr_utility.trace('p_emp_name: '||p_emp_name);
1172: hr_utility.trace('p_pdf_pwd: '||p_pdf_pwd);
1173: hr_utility.trace('p_nts_certs_path : '||p_pdf_pwd);
1174: hr_utility.set_location(l_proc,1000);
1175: end if;
1176: --
1177: end get_pdf_blob_ss;

Line 1174: hr_utility.set_location(l_proc,1000);

1170: hr_utility.trace('p_emp_num: '||p_emp_num);
1171: hr_utility.trace('p_emp_name: '||p_emp_name);
1172: hr_utility.trace('p_pdf_pwd: '||p_pdf_pwd);
1173: hr_utility.trace('p_nts_certs_path : '||p_pdf_pwd);
1174: hr_utility.set_location(l_proc,1000);
1175: end if;
1176: --
1177: end get_pdf_blob_ss;
1178: --

Line 1200: hr_utility.set_location(l_proc,10);

1196: --
1197: begin
1198: --
1199: if g_debug then
1200: hr_utility.set_location(l_proc,10);
1201: end if;
1202: --
1203: l_file_name := p_file_name;
1204: if instrb(p_file_name,g_path_delimiter,'-1') > 0 then

Line 1209: hr_utility.trace('file name : '||l_file_name);

1205: l_file_name := substrb(l_file_name,instrb(l_file_name,g_path_delimiter,'-1'));
1206: end if;
1207: --
1208: if g_debug then
1209: hr_utility.trace('file name : '||l_file_name);
1210: end if;
1211: --
1212: open csr_map_name(l_file_name);
1213: loop

Line 1219: hr_utility.set_location(l_proc,20);

1215: fetch csr_map_name into l_csr_map_name;
1216: exit when csr_map_name%notfound;
1217: --
1218: if g_debug then
1219: hr_utility.set_location(l_proc,20);
1220: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
1221: hr_utility.trace('ni num : '||l_csr_map_name.ni_num);
1222: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
1223: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));

Line 1220: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);

1216: exit when csr_map_name%notfound;
1217: --
1218: if g_debug then
1219: hr_utility.set_location(l_proc,20);
1220: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
1221: hr_utility.trace('ni num : '||l_csr_map_name.ni_num);
1222: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
1223: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
1224: end if;

Line 1221: hr_utility.trace('ni num : '||l_csr_map_name.ni_num);

1217: --
1218: if g_debug then
1219: hr_utility.set_location(l_proc,20);
1220: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
1221: hr_utility.trace('ni num : '||l_csr_map_name.ni_num);
1222: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
1223: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
1224: end if;
1225: --

Line 1222: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);

1218: if g_debug then
1219: hr_utility.set_location(l_proc,20);
1220: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
1221: hr_utility.trace('ni num : '||l_csr_map_name.ni_num);
1222: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
1223: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
1224: end if;
1225: --
1226: /* skip for multiple assignment */

Line 1223: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));

1219: hr_utility.set_location(l_proc,20);
1220: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
1221: hr_utility.trace('ni num : '||l_csr_map_name.ni_num);
1222: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
1223: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
1224: end if;
1225: --
1226: /* skip for multiple assignment */
1227: if p_file_map is null then

Line 1249: hr_utility.trace('p_file_map : '||p_file_map);

1245: end if;
1246: --
1247: if g_debug then
1248: --
1249: hr_utility.trace('p_file_map : '||p_file_map);
1250: hr_utility.trace('p_emp_num : '||p_emp_num);
1251: hr_utility.trace('p_ni_num : '||p_ni_num);
1252: hr_utility.trace('p_emp_name : '||p_emp_name);
1253: hr_utility.trace('p_pdf_pwd : '||p_pdf_pwd);

Line 1250: hr_utility.trace('p_emp_num : '||p_emp_num);

1246: --
1247: if g_debug then
1248: --
1249: hr_utility.trace('p_file_map : '||p_file_map);
1250: hr_utility.trace('p_emp_num : '||p_emp_num);
1251: hr_utility.trace('p_ni_num : '||p_ni_num);
1252: hr_utility.trace('p_emp_name : '||p_emp_name);
1253: hr_utility.trace('p_pdf_pwd : '||p_pdf_pwd);
1254: hr_utility.set_location(l_proc,1000);

Line 1251: hr_utility.trace('p_ni_num : '||p_ni_num);

1247: if g_debug then
1248: --
1249: hr_utility.trace('p_file_map : '||p_file_map);
1250: hr_utility.trace('p_emp_num : '||p_emp_num);
1251: hr_utility.trace('p_ni_num : '||p_ni_num);
1252: hr_utility.trace('p_emp_name : '||p_emp_name);
1253: hr_utility.trace('p_pdf_pwd : '||p_pdf_pwd);
1254: hr_utility.set_location(l_proc,1000);
1255: --

Line 1252: hr_utility.trace('p_emp_name : '||p_emp_name);

1248: --
1249: hr_utility.trace('p_file_map : '||p_file_map);
1250: hr_utility.trace('p_emp_num : '||p_emp_num);
1251: hr_utility.trace('p_ni_num : '||p_ni_num);
1252: hr_utility.trace('p_emp_name : '||p_emp_name);
1253: hr_utility.trace('p_pdf_pwd : '||p_pdf_pwd);
1254: hr_utility.set_location(l_proc,1000);
1255: --
1256: end if;

Line 1253: hr_utility.trace('p_pdf_pwd : '||p_pdf_pwd);

1249: hr_utility.trace('p_file_map : '||p_file_map);
1250: hr_utility.trace('p_emp_num : '||p_emp_num);
1251: hr_utility.trace('p_ni_num : '||p_ni_num);
1252: hr_utility.trace('p_emp_name : '||p_emp_name);
1253: hr_utility.trace('p_pdf_pwd : '||p_pdf_pwd);
1254: hr_utility.set_location(l_proc,1000);
1255: --
1256: end if;
1257: --

Line 1254: hr_utility.set_location(l_proc,1000);

1250: hr_utility.trace('p_emp_num : '||p_emp_num);
1251: hr_utility.trace('p_ni_num : '||p_ni_num);
1252: hr_utility.trace('p_emp_name : '||p_emp_name);
1253: hr_utility.trace('p_pdf_pwd : '||p_pdf_pwd);
1254: hr_utility.set_location(l_proc,1000);
1255: --
1256: end if;
1257: --
1258: end load_map_file;

Line 1315: hr_utility.set_location(l_proc,0);

1311: --
1312: begin
1313: --
1314: if g_debug then
1315: hr_utility.set_location(l_proc,0);
1316: end if;
1317: --
1318: if nvl(g_skip_validate,'N') = 'N' then
1319: --

Line 1346: hr_utility.trace('l_year : '||l_year||' <> g_target_year : '||to_char(g_target_yyyy));

1342: --
1343: l_ora_code := 202; /* Invalid Year */
1344: --
1345: if g_debug then
1346: hr_utility.trace('l_year : '||l_year||' <> g_target_year : '||to_char(g_target_yyyy));
1347: end if;
1348: --
1349: end if;
1350: --

Line 1402: hr_utility.trace('l_ni_num : '||l_ni_num||' <> p_ni_num : '||cnv_ni(p_ni_num));

1398: --
1399: l_ora_code := 203; /* Incorrect NI */
1400: --
1401: if g_debug then
1402: hr_utility.trace('l_ni_num : '||l_ni_num||' <> p_ni_num : '||cnv_ni(p_ni_num));
1403: end if;
1404: --
1405: end if;
1406: --

Line 1416: hr_utility.trace('l_emp_name : '||l_emp_name||' <> p_emp_name : '||p_emp_name);

1412: --
1413: l_ora_code := 204; /* Incorrect Emp Name */
1414: --
1415: if g_debug then
1416: hr_utility.trace('l_emp_name : '||l_emp_name||' <> p_emp_name : '||p_emp_name);
1417: end if;
1418: --
1419: end if;
1420: --

Line 1434: hr_utility.trace('l_ora_code : '||to_char(l_ora_code));

1430: --
1431: end if;
1432: --
1433: if g_debug then
1434: hr_utility.trace('l_ora_code : '||to_char(l_ora_code));
1435: hr_utility.set_location(l_proc,1000);
1436: end if;
1437: --
1438: return l_ora_code;

Line 1435: hr_utility.set_location(l_proc,1000);

1431: end if;
1432: --
1433: if g_debug then
1434: hr_utility.trace('l_ora_code : '||to_char(l_ora_code));
1435: hr_utility.set_location(l_proc,1000);
1436: end if;
1437: --
1438: return l_ora_code;
1439: end load_validate;

Line 1456: hr_utility.set_location(l_proc,0);

1452: --
1453: begin
1454: --
1455: if g_debug then
1456: hr_utility.set_location(l_proc,0);
1457: end if;
1458: --
1459: l_ora_code := load_validate(
1460: p_emp_num => g_pdf_tbl(g_pdf_ind).emp_num,

Line 1466: hr_utility.trace('l_ora_code : '||to_char(l_ora_code));

1462: p_emp_name => g_pdf_tbl(g_pdf_ind).emp_name,
1463: p_xml => p_xml);
1464: --
1465: if g_debug then
1466: hr_utility.trace('l_ora_code : '||to_char(l_ora_code));
1467: hr_utility.set_location(l_proc,1000);
1468: end if;
1469: --
1470: return l_ora_code;

Line 1467: hr_utility.set_location(l_proc,1000);

1463: p_xml => p_xml);
1464: --
1465: if g_debug then
1466: hr_utility.trace('l_ora_code : '||to_char(l_ora_code));
1467: hr_utility.set_location(l_proc,1000);
1468: end if;
1469: --
1470: return l_ora_code;
1471: end upload_validate;

Line 1503: hr_utility.set_location(l_proc,0);

1499: --
1500: begin
1501: --
1502: if g_debug then
1503: hr_utility.set_location(l_proc,0);
1504: end if;
1505: --
1506: if dbms_xmldom.getattribute(dbms_xmldom.makeelement(p_form_node),'form_cd') = p_form_type then
1507: --

Line 1556: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));

1552: --
1553: end if;
1554: --
1555: if g_debug then
1556: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
1557: hr_utility.trace('l_value_ind : l_value_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_value_tbl.count));
1558: hr_utility.set_location(l_proc,1000);
1559: end if;
1560: --

Line 1557: hr_utility.trace('l_value_ind : l_value_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_value_tbl.count));

1553: end if;
1554: --
1555: if g_debug then
1556: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
1557: hr_utility.trace('l_value_ind : l_value_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_value_tbl.count));
1558: hr_utility.set_location(l_proc,1000);
1559: end if;
1560: --
1561: return l_value_tbl;

Line 1558: hr_utility.set_location(l_proc,1000);

1554: --
1555: if g_debug then
1556: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
1557: hr_utility.trace('l_value_ind : l_value_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_value_tbl.count));
1558: hr_utility.set_location(l_proc,1000);
1559: end if;
1560: --
1561: return l_value_tbl;
1562: --

Line 1598: hr_utility.set_location(l_proc,0);

1594: --
1595: begin
1596: --
1597: if g_debug then
1598: hr_utility.set_location(l_proc,0);
1599: end if;
1600: --
1601: if dbms_xmldom.getattribute(dbms_xmldom.makeelement(p_form_node),'form_cd') = p_form_type then
1602: --

Line 1654: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));

1650: --
1651: end if;
1652: --
1653: if g_debug then
1654: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
1655: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
1656: hr_utility.set_location(l_proc,1000);
1657: end if;
1658: --

Line 1655: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));

1651: end if;
1652: --
1653: if g_debug then
1654: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
1655: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
1656: hr_utility.set_location(l_proc,1000);
1657: end if;
1658: --
1659: return l_values_tbl;

Line 1656: hr_utility.set_location(l_proc,1000);

1652: --
1653: if g_debug then
1654: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
1655: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
1656: hr_utility.set_location(l_proc,1000);
1657: end if;
1658: --
1659: return l_values_tbl;
1660: --

Line 1699: hr_utility.set_location(l_proc,0);

1695: --
1696: begin
1697: --
1698: if g_debug then
1699: hr_utility.set_location(l_proc,0);
1700: end if;
1701: --
1702: if dbms_xmldom.getattribute(dbms_xmldom.makeelement(p_form_node),'form_cd') = p_form_type then
1703: --

Line 1767: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_key_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_key_cnt)||' : '||to_char(l_item_cnt));

1763: --
1764: end if;
1765: --
1766: if g_debug then
1767: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_key_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_key_cnt)||' : '||to_char(l_item_cnt));
1768: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
1769: hr_utility.set_location(l_proc,1000);
1770: end if;
1771: --

Line 1768: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));

1764: end if;
1765: --
1766: if g_debug then
1767: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_key_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_key_cnt)||' : '||to_char(l_item_cnt));
1768: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
1769: hr_utility.set_location(l_proc,1000);
1770: end if;
1771: --
1772: return l_values_tbl;

Line 1769: hr_utility.set_location(l_proc,1000);

1765: --
1766: if g_debug then
1767: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_key_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_key_cnt)||' : '||to_char(l_item_cnt));
1768: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
1769: hr_utility.set_location(l_proc,1000);
1770: end if;
1771: --
1772: return l_values_tbl;
1773: --

Line 1815: hr_utility.set_location(l_proc,0);

1811: --
1812: begin
1813: --
1814: if g_debug then
1815: hr_utility.set_location(l_proc,0);
1816: end if;
1817: --
1818: if dbms_xmldom.getattribute(dbms_xmldom.makeelement(p_form_node),'form_cd') = 'L101Y' then
1819: --

Line 1916: hr_utility.trace('l_man_cnt : l_data_cnt : l_sum_cnt : l_amt_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_sum_cnt)||' : '||to_char(l_amt_cnt));

1912: --
1913: end if;
1914: --
1915: if g_debug then
1916: hr_utility.trace('l_man_cnt : l_data_cnt : l_sum_cnt : l_amt_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_sum_cnt)||' : '||to_char(l_amt_cnt));
1917: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
1918: hr_utility.set_location(l_proc,1000);
1919: end if;
1920: --

Line 1917: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));

1913: end if;
1914: --
1915: if g_debug then
1916: hr_utility.trace('l_man_cnt : l_data_cnt : l_sum_cnt : l_amt_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_sum_cnt)||' : '||to_char(l_amt_cnt));
1917: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
1918: hr_utility.set_location(l_proc,1000);
1919: end if;
1920: --
1921: return l_values_tbl;

Line 1918: hr_utility.set_location(l_proc,1000);

1914: --
1915: if g_debug then
1916: hr_utility.trace('l_man_cnt : l_data_cnt : l_sum_cnt : l_amt_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_sum_cnt)||' : '||to_char(l_amt_cnt));
1917: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
1918: hr_utility.set_location(l_proc,1000);
1919: end if;
1920: --
1921: return l_values_tbl;
1922: --

Line 1958: hr_utility.set_location(l_proc,0);

1954: --
1955: begin
1956: --
1957: if g_debug then
1958: hr_utility.set_location(l_proc,0);
1959: end if;
1960: --
1961: if dbms_xmldom.getattribute(dbms_xmldom.makeelement(p_form_node),'form_cd') = 'C101Y' then
1962: --

Line 2039: hr_utility.trace('l_man_cnt : l_data_cnt : l_sum_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_sum_cnt));

2035: --
2036: end if;
2037: --
2038: if g_debug then
2039: hr_utility.trace('l_man_cnt : l_data_cnt : l_sum_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_sum_cnt));
2040: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2041: hr_utility.set_location(l_proc,1000);
2042: end if;
2043: --

Line 2040: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));

2036: end if;
2037: --
2038: if g_debug then
2039: hr_utility.trace('l_man_cnt : l_data_cnt : l_sum_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_sum_cnt));
2040: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2041: hr_utility.set_location(l_proc,1000);
2042: end if;
2043: --
2044: return l_values_tbl;

Line 2041: hr_utility.set_location(l_proc,1000);

2037: --
2038: if g_debug then
2039: hr_utility.trace('l_man_cnt : l_data_cnt : l_sum_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_sum_cnt));
2040: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2041: hr_utility.set_location(l_proc,1000);
2042: end if;
2043: --
2044: return l_values_tbl;
2045: --

Line 2087: hr_utility.set_location(l_proc,0);

2083: --
2084: begin
2085: --
2086: if g_debug then
2087: hr_utility.set_location(l_proc,0);
2088: end if;
2089: --
2090: if dbms_xmldom.getattribute(dbms_xmldom.makeelement(p_form_node),'form_cd') = p_form_type then
2091: --

Line 2183: hr_utility.trace('l_man_cnt : l_data_cnt : l_type_cnt : l_sum_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_type_cnt)||' : '||to_char(l_sum_cnt));

2179: --
2180: end if;
2181: --
2182: if g_debug then
2183: hr_utility.trace('l_man_cnt : l_data_cnt : l_type_cnt : l_sum_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_type_cnt)||' : '||to_char(l_sum_cnt));
2184: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2185: hr_utility.set_location(l_proc,1000);
2186: end if;
2187: --

Line 2184: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));

2180: end if;
2181: --
2182: if g_debug then
2183: hr_utility.trace('l_man_cnt : l_data_cnt : l_type_cnt : l_sum_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_type_cnt)||' : '||to_char(l_sum_cnt));
2184: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2185: hr_utility.set_location(l_proc,1000);
2186: end if;
2187: --
2188: return l_values_tbl;

Line 2185: hr_utility.set_location(l_proc,1000);

2181: --
2182: if g_debug then
2183: hr_utility.trace('l_man_cnt : l_data_cnt : l_type_cnt : l_sum_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_type_cnt)||' : '||to_char(l_sum_cnt));
2184: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2185: hr_utility.set_location(l_proc,1000);
2186: end if;
2187: --
2188: return l_values_tbl;
2189: --

Line 2225: hr_utility.set_location(l_proc,0);

2221: --
2222: begin
2223: --
2224: if g_debug then
2225: hr_utility.set_location(l_proc,0);
2226: end if;
2227: --
2228: if dbms_xmldom.getattribute(dbms_xmldom.makeelement(p_form_node),'form_cd') = p_form_type then
2229: --

Line 2282: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));

2278: --
2279: end if;
2280: --
2281: if g_debug then
2282: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
2283: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2284: hr_utility.set_location(l_proc,1000);
2285: end if;
2286: --

Line 2283: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));

2279: end if;
2280: --
2281: if g_debug then
2282: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
2283: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2284: hr_utility.set_location(l_proc,1000);
2285: end if;
2286: --
2287: return l_values_tbl;

Line 2284: hr_utility.set_location(l_proc,1000);

2280: --
2281: if g_debug then
2282: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
2283: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2284: hr_utility.set_location(l_proc,1000);
2285: end if;
2286: --
2287: return l_values_tbl;
2288: --

Line 2324: hr_utility.set_location(l_proc,0);

2320: --
2321: begin
2322: --
2323: if g_debug then
2324: hr_utility.set_location(l_proc,0);
2325: end if;
2326: --
2327: if dbms_xmldom.getattribute(dbms_xmldom.makeelement(p_form_node),'form_cd') = p_form_type then
2328: --

Line 2381: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));

2377: --
2378: end if;
2379: --
2380: if g_debug then
2381: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
2382: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2383: hr_utility.set_location(l_proc,1000);
2384: end if;
2385: --

Line 2382: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));

2378: end if;
2379: --
2380: if g_debug then
2381: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
2382: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2383: hr_utility.set_location(l_proc,1000);
2384: end if;
2385: --
2386: return l_values_tbl;

Line 2383: hr_utility.set_location(l_proc,1000);

2379: --
2380: if g_debug then
2381: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
2382: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2383: hr_utility.set_location(l_proc,1000);
2384: end if;
2385: --
2386: return l_values_tbl;
2387: --

Line 2450: hr_utility.set_location(l_proc,0);

2446: --
2447: begin
2448: --
2449: if g_debug then
2450: hr_utility.set_location(l_proc,0);
2451: end if;
2452: --
2453: if dbms_xmldom.getattribute(dbms_xmldom.makeelement(p_form_node),'form_cd') = p_form_type then
2454: --

Line 2583: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_key_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_key_cnt)||' : '||to_char(l_item_cnt));

2579: --
2580: end if;
2581: --
2582: if g_debug then
2583: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_key_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_key_cnt)||' : '||to_char(l_item_cnt));
2584: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2585: hr_utility.set_location(l_proc,1000);
2586: end if;
2587: --

Line 2584: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));

2580: end if;
2581: --
2582: if g_debug then
2583: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_key_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_key_cnt)||' : '||to_char(l_item_cnt));
2584: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2585: hr_utility.set_location(l_proc,1000);
2586: end if;
2587: --
2588: return l_values_tbl;

Line 2585: hr_utility.set_location(l_proc,1000);

2581: --
2582: if g_debug then
2583: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_key_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_key_cnt)||' : '||to_char(l_item_cnt));
2584: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2585: hr_utility.set_location(l_proc,1000);
2586: end if;
2587: --
2588: return l_values_tbl;
2589: --

Line 2626: hr_utility.set_location(l_proc,0);

2622: --
2623: begin
2624: --
2625: if g_debug then
2626: hr_utility.set_location(l_proc,0);
2627: end if;
2628: --
2629: if dbms_xmldom.getattribute(dbms_xmldom.makeelement(p_form_node),'form_cd') = p_form_type then
2630: --

Line 2682: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));

2678: --
2679: end if;
2680: --
2681: if g_debug then
2682: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
2683: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2684: hr_utility.set_location(l_proc,1000);
2685: end if;
2686: --

Line 2683: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));

2679: end if;
2680: --
2681: if g_debug then
2682: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
2683: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2684: hr_utility.set_location(l_proc,1000);
2685: end if;
2686: --
2687: return l_values_tbl;

Line 2684: hr_utility.set_location(l_proc,1000);

2680: --
2681: if g_debug then
2682: hr_utility.trace('l_man_cnt : l_data_cnt : l_item_cnt : '||to_char(l_man_cnt)||' : '||to_char(l_data_cnt)||' : '||to_char(l_item_cnt));
2683: hr_utility.trace('l_value_ind : l_values_tbl.count : '||to_char(l_value_ind)||' : '||to_char(l_values_tbl.count));
2684: hr_utility.set_location(l_proc,1000);
2685: end if;
2686: --
2687: return l_values_tbl;
2688: --

Line 3085: hr_utility.set_location(l_proc,0);

3081: --
3082: begin
3083: --
3084: if g_debug then
3085: hr_utility.set_location(l_proc,0);
3086: end if;
3087: --
3088: -- sync with PerKrAssignmentYeaInfoEOImpl.java for only relevant info type
3089: --if p_information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO' then

Line 3105: hr_utility.set_message(801,'PAY_KR_YEA_DET_DON_INV_DATE');

3101: --
3102: if p_information2 is not null
3103: and to_char(fnd_date.canonical_to_date(p_information2),'YYYY') <> g_target_yyyy then
3104: --
3105: hr_utility.set_message(801,'PAY_KR_YEA_DET_DON_INV_DATE');
3106: hr_utility.set_message_token('DATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_information2)));
3107: hr_utility.raise_error;
3108: --
3109: end if;

Line 3106: hr_utility.set_message_token('DATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_information2)));

3102: if p_information2 is not null
3103: and to_char(fnd_date.canonical_to_date(p_information2),'YYYY') <> g_target_yyyy then
3104: --
3105: hr_utility.set_message(801,'PAY_KR_YEA_DET_DON_INV_DATE');
3106: hr_utility.set_message_token('DATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_information2)));
3107: hr_utility.raise_error;
3108: --
3109: end if;
3110: --

Line 3107: hr_utility.raise_error;

3103: and to_char(fnd_date.canonical_to_date(p_information2),'YYYY') <> g_target_yyyy then
3104: --
3105: hr_utility.set_message(801,'PAY_KR_YEA_DET_DON_INV_DATE');
3106: hr_utility.set_message_token('DATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_information2)));
3107: hr_utility.raise_error;
3108: --
3109: end if;
3110: --
3111: -- PAY_KR_YEA_INV_DON_REGNO

Line 3123: hr_utility.set_message(801,'PAY_KR_YEA_INV_DON_NAME_MSG');

3119: close csr_don_recipient;
3120: --
3121: if l_csr_don_recipient.assignment_yea_info_id is not null then
3122: --
3123: hr_utility.set_message(801,'PAY_KR_YEA_INV_DON_NAME_MSG');
3124: hr_utility.set_message_token('RRN',p_information7);
3125: hr_utility.raise_error;
3126: --
3127: end if;

Line 3124: hr_utility.set_message_token('RRN',p_information7);

3120: --
3121: if l_csr_don_recipient.assignment_yea_info_id is not null then
3122: --
3123: hr_utility.set_message(801,'PAY_KR_YEA_INV_DON_NAME_MSG');
3124: hr_utility.set_message_token('RRN',p_information7);
3125: hr_utility.raise_error;
3126: --
3127: end if;
3128: --

Line 3125: hr_utility.raise_error;

3121: if l_csr_don_recipient.assignment_yea_info_id is not null then
3122: --
3123: hr_utility.set_message(801,'PAY_KR_YEA_INV_DON_NAME_MSG');
3124: hr_utility.set_message_token('RRN',p_information7);
3125: hr_utility.raise_error;
3126: --
3127: end if;
3128: --
3129: end if;

Line 3156: hr_utility.set_message(801,'PAY_KR_MAX_HOU_SUB_SAVING');

3152: p_result => l_limit);
3153: --
3154: if fnd_number.canonical_to_number(p_information5) > to_number(l_limit) then
3155: --
3156: hr_utility.set_message(801,'PAY_KR_MAX_HOU_SUB_SAVING');
3157: hr_utility.set_message_token('LIMIT',l_limit);
3158: hr_utility.raise_error;
3159: --
3160: end if;

Line 3157: hr_utility.set_message_token('LIMIT',l_limit);

3153: --
3154: if fnd_number.canonical_to_number(p_information5) > to_number(l_limit) then
3155: --
3156: hr_utility.set_message(801,'PAY_KR_MAX_HOU_SUB_SAVING');
3157: hr_utility.set_message_token('LIMIT',l_limit);
3158: hr_utility.raise_error;
3159: --
3160: end if;
3161: --

Line 3158: hr_utility.raise_error;

3154: if fnd_number.canonical_to_number(p_information5) > to_number(l_limit) then
3155: --
3156: hr_utility.set_message(801,'PAY_KR_MAX_HOU_SUB_SAVING');
3157: hr_utility.set_message_token('LIMIT',l_limit);
3158: hr_utility.raise_error;
3159: --
3160: end if;
3161: --
3162: end if;

Line 3171: hr_utility.set_location(l_proc,1000);

3167: ----
3168: end if;
3169: --
3170: if g_debug then
3171: hr_utility.set_location(l_proc,1000);
3172: end if;
3173: --
3174: end validate_kr_ass_yea_info;
3175: --

Line 3272: hr_utility.set_location(l_proc,0);

3268: --
3269: begin
3270: --
3271: if g_debug then
3272: hr_utility.set_location(l_proc,0);
3273: end if;
3274: --
3275: begin
3276: --

Line 3286: hr_utility.set_location(l_proc,10);

3282: --
3283: if l_csr_kr_ass_yea.assignment_yea_info_id is not null then
3284: --
3285: if g_debug then
3286: hr_utility.set_location(l_proc,10);
3287: end if;
3288: --
3289: delete from
3290: per_kr_assignment_yea_info

Line 3308: hr_utility.trace('skipped because p_assignment_id : '||to_char(p_assignment_id)||' entry status was locked.');

3304: --
3305: fnd_file.put_line(fnd_file.log,g_msg);
3306: --
3307: if g_debug then
3308: hr_utility.trace('skipped because p_assignment_id : '||to_char(p_assignment_id)||' entry status was locked.');
3309: end if;
3310: --
3311: end;
3312: --

Line 3314: hr_utility.set_location(l_proc,1000);

3310: --
3311: end;
3312: --
3313: if g_debug then
3314: hr_utility.set_location(l_proc,1000);
3315: end if;
3316: --
3317: end delete_kr_ass_yea_info;
3318: --

Line 3372: hr_utility.set_location(l_proc,0);

3368: --
3369: begin
3370: --
3371: if g_debug then
3372: hr_utility.set_location(l_proc,0);
3373: end if;
3374: --
3375: select per_kr_assignment_yea_info_s.nextval
3376: into l_assignment_yea_info_id

Line 3467: hr_utility.set_location(l_proc,1000);

3463: --
3464: p_assignment_yea_info_id := l_assignment_yea_info_id;
3465: --
3466: if g_debug then
3467: hr_utility.set_location(l_proc,1000);
3468: end if;
3469: --
3470: end insert_kr_ass_yea_info;
3471: --

Line 3539: hr_utility.set_location(l_proc,0);

3535: --
3536: begin
3537: --
3538: if g_debug then
3539: hr_utility.set_location(l_proc,0);
3540: end if;
3541: --
3542: begin
3543: --

Line 3551: hr_utility.set_location(l_proc,10);

3547: --
3548: if l_csr_kr_ass_yea.assignment_yea_info_id is not null then
3549: --
3550: if g_debug then
3551: hr_utility.set_location(l_proc,10);
3552: end if;
3553: --
3554: l_assignment_yea_info_id := l_csr_kr_ass_yea.assignment_yea_info_id;
3555: l_object_version_number := l_csr_kr_ass_yea.object_version_number + 1;

Line 3651: hr_utility.trace('skipped because p_assignment_id : '||to_char(p_assignment_id)||' entry status was locked.');

3647: --
3648: fnd_file.put_line(fnd_file.log,g_msg);
3649: --
3650: if g_debug then
3651: hr_utility.trace('skipped because p_assignment_id : '||to_char(p_assignment_id)||' entry status was locked.');
3652: end if;
3653: --
3654: end;
3655: --

Line 3659: hr_utility.set_location(l_proc,1000);

3655: --
3656: p_assignment_yea_info_id := l_assignment_yea_info_id;
3657: --
3658: if g_debug then
3659: hr_utility.set_location(l_proc,1000);
3660: end if;
3661: --
3662: end load_kr_ass_yea_info;
3663: --

Line 3826: hr_utility.set_location(l_proc,0);

3822: --
3823: begin
3824: --
3825: if g_debug then
3826: hr_utility.set_location(l_proc,0);
3827: end if;
3828: --
3829: open csr_pcr_dpnt;
3830: fetch csr_pcr_dpnt into l_csr_pcr_dpnt;

Line 3836: hr_utility.set_location(l_proc,10);

3832: --
3833: if l_csr_pcr_dpnt.contact_relationship_id is not null then
3834: --
3835: if g_debug then
3836: hr_utility.set_location(l_proc,10);
3837: end if;
3838: --
3839: open csr_cei_dpnt_info(l_csr_pcr_dpnt.contact_relationship_id);
3840: fetch csr_cei_dpnt_info into l_csr_cei_dpnt_info;

Line 3846: hr_utility.set_location(l_proc,20);

3842: --
3843: if l_csr_cei_dpnt_info.contact_extra_info_id is not null then
3844: --
3845: if g_debug then
3846: hr_utility.set_location(l_proc,20);
3847: end if;
3848: --
3849: l_contact_extra_info_id := l_csr_cei_dpnt_info.contact_extra_info_id;
3850: l_object_version_number := l_csr_cei_dpnt_info.object_version_number;

Line 3900: hr_utility.set_location(l_proc,30);

3896: --
3897: else
3898: --
3899: if g_debug then
3900: hr_utility.set_location(l_proc,30);
3901: end if;
3902: --
3903: hr_contact_extra_info_api.create_contact_extra_info(
3904: p_validate => false,

Line 3949: hr_utility.set_location(l_proc,40);

3945: --
3946: else
3947: --
3948: if g_debug then
3949: hr_utility.set_location(l_proc,40);
3950: end if;
3951: --
3952: --warning
3953: fnd_message.set_name('PAY','PAY_KR_YEA_PDF_NO_CON_REL');

Line 3967: hr_utility.set_location(l_proc,1000);

3963: --
3964: p_contact_extra_info_id := l_contact_extra_info_id;
3965: --
3966: if g_debug then
3967: hr_utility.set_location(l_proc,1000);
3968: end if;
3969: --
3970: end load_cei_dpnt_info;
3971: --

Line 3990: hr_utility.set_location(l_proc,0);

3986: --
3987: begin
3988: --
3989: if g_debug then
3990: hr_utility.set_location(l_proc,0);
3991: end if;
3992: --
3993: l_xml_len := dbms_lob.getlength(p_xml);
3994: --

Line 4019: hr_utility.trace('l_xml_len : '||to_char(l_xml_len));

4015: --
4016: end loop;
4017: --
4018: if g_debug then
4019: hr_utility.trace('l_xml_len : '||to_char(l_xml_len));
4020: hr_utility.set_location(l_proc,1000);
4021: end if;
4022: --
4023: end show_xml;

Line 4020: hr_utility.set_location(l_proc,1000);

4016: end loop;
4017: --
4018: if g_debug then
4019: hr_utility.trace('l_xml_len : '||to_char(l_xml_len));
4020: hr_utility.set_location(l_proc,1000);
4021: end if;
4022: --
4023: end show_xml;
4024: --

Line 4388: hr_utility.set_location(l_proc,0);

4384: --
4385: begin
4386: --
4387: if g_debug then
4388: hr_utility.set_location(l_proc,0);
4389: end if;
4390: --
4391: if nvl(g_show_xml,'N') = 'Y' then
4392: --

Line 6691: hr_utility.set_location(l_proc,1000);

6687: --
6688: end if;
6689: --
6690: if g_debug then
6691: hr_utility.set_location(l_proc,1000);
6692: end if;
6693: --
6694: return l_status;
6695: --

Line 6715: hr_utility.set_location(l_proc,0);

6711: --
6712: begin
6713: --
6714: if g_debug then
6715: hr_utility.set_location(l_proc,0);
6716: end if;
6717: --
6718: if g_ass_yea_tbl.count > 0 then
6719: --

Line 6742: hr_utility.set_location(l_proc,1000);

6738: --
6739: end if;
6740: --
6741: if g_debug then
6742: hr_utility.set_location(l_proc,1000);
6743: end if;
6744: --
6745: end load_xml;
6746: --

Line 6762: hr_utility.set_location(l_proc,0);

6758: --
6759: begin
6760: --
6761: if g_debug then
6762: hr_utility.set_location(l_proc,0);
6763: end if;
6764: --
6765: l_status := main_xml(
6766: p_assignment_id => g_pdf_tbl(g_pdf_ind).assignment_id,

Line 6774: hr_utility.set_location(l_proc,1000);

6770: p_file_id => g_pdf_tbl(g_pdf_ind).file_id,
6771: p_xml => p_xml);
6772: --
6773: if g_debug then
6774: hr_utility.set_location(l_proc,1000);
6775: end if;
6776: --
6777: return l_status;
6778: --

Line 6798: hr_utility.set_location(l_proc,0);

6794: --
6795: begin
6796: --
6797: if g_debug then
6798: hr_utility.set_location(l_proc,0);
6799: end if;
6800: --
6801: update per_kr_assignment_yea_info
6802: set ayi_information14 = decode(nvl(p_error_code,'X'),'X',decode(nvl(p_status,'X'),'C',c_upload_status,ayi_information14),c_error_status),

Line 6837: hr_utility.set_location(l_proc,1000);

6833: --
6834: end if;
6835: --
6836: if g_debug then
6837: hr_utility.set_location(l_proc,1000);
6838: end if;
6839: --
6840: end main_post;
6841: --

Line 6857: hr_utility.set_location(l_proc,0);

6853: --
6854: begin
6855: --
6856: if g_debug then
6857: hr_utility.set_location(l_proc,0);
6858: end if;
6859: --
6860: if g_ass_yea_tbl.count > 0 then
6861: --

Line 6884: hr_utility.set_location(l_proc,1000);

6880: --
6881: end if;
6882: --
6883: if g_debug then
6884: hr_utility.set_location(l_proc,1000);
6885: end if;
6886: --
6887: return l_suc_cnt;
6888: --

Line 6905: hr_utility.set_location(l_proc,0);

6901: --
6902: begin
6903: --
6904: if g_debug then
6905: hr_utility.set_location(l_proc,0);
6906: end if;
6907: --
6908: if g_pdf_ind is not null then
6909: --

Line 6941: hr_utility.set_location(l_proc,1000);

6937: --
6938: end if;
6939: --
6940: if g_debug then
6941: hr_utility.set_location(l_proc,1000);
6942: end if;
6943: --
6944: end upload_post;
6945: --

Line 6957: hr_utility.set_location(l_proc,0);

6953: --
6954: begin
6955: --
6956: if g_debug then
6957: hr_utility.set_location(l_proc,0);
6958: end if;
6959: --
6960: if nvl(g_load_type,'L') <> 'I'
6961: and nvl(g_ss_call,'N') <> 'Y' then

Line 6966: hr_utility.set_location(l_proc,1000);

6962: delete_session;
6963: end if;
6964: --
6965: if g_debug then
6966: hr_utility.set_location(l_proc,1000);
6967: end if;
6968: --
6969: end load_deinit;
6970: --

Line 7048: hr_utility.set_location(l_proc,0);

7044: --
7045: begin
7046: --
7047: if g_debug then
7048: hr_utility.set_location(l_proc,0);
7049: end if;
7050: --
7051: if g_target_yyyy is null then
7052: --

Line 7079: hr_utility.trace('file name : '||l_file_name);

7075: l_file_name := substrb(l_file_name,instrb(l_file_name,g_path_delimiter,'-1'));
7076: end if;
7077: --
7078: if g_debug then
7079: hr_utility.trace('file name : '||l_file_name);
7080: hr_utility.set_location(l_proc,10);
7081: end if;
7082: --
7083: /* allocate same file to both prev ass and rehired ass in same year */

Line 7080: hr_utility.set_location(l_proc,10);

7076: end if;
7077: --
7078: if g_debug then
7079: hr_utility.trace('file name : '||l_file_name);
7080: hr_utility.set_location(l_proc,10);
7081: end if;
7082: --
7083: /* allocate same file to both prev ass and rehired ass in same year */
7084: open csr_map_name(l_file_name);

Line 7093: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);

7089: --
7090: l_ass_yea_info_id := null;
7091: --
7092: if g_debug then
7093: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
7094: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);
7095: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
7096: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
7097: end if;

Line 7094: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);

7090: l_ass_yea_info_id := null;
7091: --
7092: if g_debug then
7093: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
7094: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);
7095: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
7096: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
7097: end if;
7098: --

Line 7095: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);

7091: --
7092: if g_debug then
7093: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
7094: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);
7095: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
7096: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
7097: end if;
7098: --
7099: if l_csr_map_name.assignment_id is not null then

Line 7096: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));

7092: if g_debug then
7093: hr_utility.trace('emp name : '||l_csr_map_name.emp_name);
7094: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);
7095: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
7096: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
7097: end if;
7098: --
7099: if l_csr_map_name.assignment_id is not null then
7100: --

Line 7104: hr_utility.trace('ass yea info id : '||to_char(l_ass_yea_info_id));

7100: --
7101: import_kr_ass_yea(l_csr_map_name.assignment_id,g_target_yyyy,l_csr_file.file_id,null,l_ass_yea_info_id);
7102: --
7103: if g_debug then
7104: hr_utility.trace('ass yea info id : '||to_char(l_ass_yea_info_id));
7105: end if;
7106: --
7107: if l_ass_yea_info_id is not null then
7108: --

Line 7109: hr_utility.trace('valid map : '||l_csr_file.file_name);

7105: end if;
7106: --
7107: if l_ass_yea_info_id is not null then
7108: --
7109: hr_utility.trace('valid map : '||l_csr_file.file_name);
7110: --
7111: l_valid := true;
7112: --
7113: end if;

Line 7128: hr_utility.trace('invalid map : '||l_csr_file.file_name);

7124: fnd_gfm.delete_lob(l_csr_file.file_id);
7125: --
7126: end if;
7127: --
7128: hr_utility.trace('invalid map : '||l_csr_file.file_name);
7129: --
7130: end if;
7131: --
7132: else

Line 7136: hr_utility.trace('no lob : '||to_char(p_file_id));

7132: else
7133: --
7134: if g_debug then
7135: --
7136: hr_utility.trace('no lob : '||to_char(p_file_id));
7137: --
7138: end if;
7139: --
7140: end if;

Line 7143: hr_utility.set_location(l_proc,1000);

7139: --
7140: end if;
7141: --
7142: if g_debug then
7143: hr_utility.set_location(l_proc,1000);
7144: end if;
7145: --
7146: end map_yea_assignment;
7147: --

Line 7187: hr_utility.set_location(l_proc,0);

7183: --
7184: begin
7185: --
7186: if g_debug then
7187: hr_utility.set_location(l_proc,0);
7188: end if;
7189: --
7190: import_init(
7191: p_business_group_id => p_business_group_id,

Line 7201: hr_utility.set_location(l_proc,10);

7197: p_force_import => p_force_import,
7198: p_import_path => l_import_path);
7199: --
7200: if g_debug then
7201: hr_utility.set_location(l_proc,10);
7202: end if;
7203: --
7204: open csr_mass_new_file;
7205: loop

Line 7212: hr_utility.trace('new file id : '||to_char(l_csr_mass_new_file.file_id));

7208: exit when csr_mass_new_file%notfound;
7209: --
7210: if g_debug then
7211: --
7212: hr_utility.trace('new file id : '||to_char(l_csr_mass_new_file.file_id));
7213: --
7214: end if;
7215: --
7216: map_yea_assignment(

Line 7225: hr_utility.trace('map cnt : '||to_char(l_map_cnt));

7221: end loop;
7222: close csr_mass_new_file;
7223: --
7224: if g_debug then
7225: hr_utility.trace('map cnt : '||to_char(l_map_cnt));
7226: hr_utility.set_location(l_proc,1000);
7227: end if;
7228: --
7229: end mass_map_yea_assignment;

Line 7226: hr_utility.set_location(l_proc,1000);

7222: close csr_mass_new_file;
7223: --
7224: if g_debug then
7225: hr_utility.trace('map cnt : '||to_char(l_map_cnt));
7226: hr_utility.set_location(l_proc,1000);
7227: end if;
7228: --
7229: end mass_map_yea_assignment;
7230: --

Line 7253: hr_utility.set_location(l_proc,0);

7249: --
7250: begin
7251: --
7252: if g_debug then
7253: hr_utility.set_location(l_proc,0);
7254: end if;
7255: --
7256: open csr_file;
7257: fetch csr_file into l_csr_file;

Line 7278: hr_utility.set_location(l_proc,1000);

7274: --
7275: end if;
7276: --
7277: if g_debug then
7278: hr_utility.set_location(l_proc,1000);
7279: end if;
7280: --
7281: end delete_pdf;
7282: --

Line 7309: hr_utility.set_location(l_proc,0);

7305: --
7306: begin
7307: --
7308: if g_debug then
7309: hr_utility.set_location(l_proc,0);
7310: end if;
7311: --
7312: open csr_mass_file;
7313: loop

Line 7324: hr_utility.set_location(l_proc,1000);

7320: end loop;
7321: close csr_mass_file;
7322: --
7323: if g_debug then
7324: hr_utility.set_location(l_proc,1000);
7325: end if;
7326: --
7327: end mass_delete_pdf;
7328: --

Line 7341: hr_utility.set_location(l_proc,0);

7337: p_asg_set_id number ;
7338: l_proc varchar2(80) := c_package||'submit_yea_pdf_upload';
7339: begin
7340: if g_debug then
7341: hr_utility.set_location(l_proc,0);
7342: hr_utility.trace('p_asg_id: '||p_asg_id);
7343: end if;
7344:
7345: l_request_id := fnd_request.submit_request(

Line 7342: hr_utility.trace('p_asg_id: '||p_asg_id);

7338: l_proc varchar2(80) := c_package||'submit_yea_pdf_upload';
7339: begin
7340: if g_debug then
7341: hr_utility.set_location(l_proc,0);
7342: hr_utility.trace('p_asg_id: '||p_asg_id);
7343: end if;
7344:
7345: l_request_id := fnd_request.submit_request(
7346: application => 'PAY',

Line 7360: hr_utility.trace('leaving submit_yea_pdf_upload:l_request_id: '||l_request_id);

7356: commit;
7357: end if;
7358: --
7359: if g_debug then
7360: hr_utility.trace('leaving submit_yea_pdf_upload:l_request_id: '||l_request_id);
7361: hr_utility.set_location(l_proc,1000);
7362: end if;
7363: return l_request_id;
7364: end submit_yea_pdf_upload ;

Line 7361: hr_utility.set_location(l_proc,1000);

7357: end if;
7358: --
7359: if g_debug then
7360: hr_utility.trace('leaving submit_yea_pdf_upload:l_request_id: '||l_request_id);
7361: hr_utility.set_location(l_proc,1000);
7362: end if;
7363: return l_request_id;
7364: end submit_yea_pdf_upload ;
7365: end pay_kr_yea_pdf_pkg;