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

Line 309: hr_utility.set_location('Entering create_overide_hol element procedure',501);

305: l_object_version_number NUMBER;
306: l_create_warning BOOLEAN := FALSE;
307: BEGIN
308:
309: hr_utility.set_location('Entering create_overide_hol element procedure',501);
310: --
311: -- Get Element information
312: --
313: OPEN element_csr;

Line 359: hr_utility.set_location('leaving procedure create_timestamp_entry ',501);

355: p_element_entry_id => l_element_entry_id,
356: p_object_version_number => l_object_version_number,
357: p_create_warning => l_create_warning
358: );
359: hr_utility.set_location('leaving procedure create_timestamp_entry ',501);
360: END create_timestamp_entry;
361:
362: PROCEDURE create_override_hol ( p_effective_date IN DATE
363: , p_assignment_id IN NUMBER

Line 429: hr_utility.set_location('Entering create_overide_hol element procedure',501);

425: l_object_version_number NUMBER;
426: l_create_warning BOOLEAN := FALSE;
427: BEGIN
428:
429: hr_utility.set_location('Entering create_overide_hol element procedure',501);
430: --
431: -- Get Element information
432: --
433: OPEN element_csr;

Line 496: hr_utility.set_location('leaving create_overide_hol element procedure',501);

492: p_element_entry_id => l_element_entry_id,
493: p_object_version_number => l_object_version_number,
494: p_create_warning => l_create_warning
495: );
496: hr_utility.set_location('leaving create_overide_hol element procedure',501);
497: END create_override_hol;
498:
499: PROCEDURE get_end_date(p_start_date date,
500: p_duration number,

Line 584: hr_utility.set_location(' Entering Procedure create_absence',10);

580: l_abs_attendance_id per_absence_attendance_types.absence_attendance_type_id%type;
581: --l_assignment_id number;
582:
583: BEGIN
584: hr_utility.set_location(' Entering Procedure create_absence',10);
585: l_start_date := p_start_date;
586: l_end_date := p_end_date;
587: l_effective_date := p_effective_date;
588: l_person_id := p_person_id ;

Line 597: hr_utility.set_location('l_person_id: '||l_person_id,301);

593: close get_absence_type_id; */
594:
595: l_abs_attendance_id := g_absence_attendance_type_id ;
596:
597: hr_utility.set_location('l_person_id: '||l_person_id,301);
598: hr_utility.set_location('l_abs_attendance_id: '||l_abs_attendance_id,302);
599: hr_utility.set_location('entering create_person_absence',302);
600:
601: hr_person_absence_api.create_person_absence

Line 598: hr_utility.set_location('l_abs_attendance_id: '||l_abs_attendance_id,302);

594:
595: l_abs_attendance_id := g_absence_attendance_type_id ;
596:
597: hr_utility.set_location('l_person_id: '||l_person_id,301);
598: hr_utility.set_location('l_abs_attendance_id: '||l_abs_attendance_id,302);
599: hr_utility.set_location('entering create_person_absence',302);
600:
601: hr_person_absence_api.create_person_absence
602: ( p_effective_date => l_effective_date

Line 599: hr_utility.set_location('entering create_person_absence',302);

595: l_abs_attendance_id := g_absence_attendance_type_id ;
596:
597: hr_utility.set_location('l_person_id: '||l_person_id,301);
598: hr_utility.set_location('l_abs_attendance_id: '||l_abs_attendance_id,302);
599: hr_utility.set_location('entering create_person_absence',302);
600:
601: hr_person_absence_api.create_person_absence
602: ( p_effective_date => l_effective_date
603: ,p_person_id => l_person_id

Line 623: hr_utility.set_location('leaving create_person_absence',302);

619: ,p_abs_day_after_warning =>l_abs_day_after_warning
620: ,p_dur_overwritten_warning =>l_dur_overwritten_warning
621: , p_create_element_entry => TRUE
622: ) ;
623: hr_utility.set_location('leaving create_person_absence',302);
624:
625:
626: END create_absence;
627:

Line 810: hr_utility.set_location('Entering procedure validate_E Holiday card',100);

806: abs_term_date EXCEPTION;
807:
808: BEGIN
809:
810: hr_utility.set_location('Entering procedure validate_E Holiday card',100);
811: hr_utility.set_location('SE Number of the receving company = ' ||g_se_no,101);
812: hr_utility.set_location('CVR Number of the receving company = ' ||g_cvr_no,102);
813:
814: OPEN csr_Legal_Emp_Details(g_se_no,g_cvr_no);

Line 811: hr_utility.set_location('SE Number of the receving company = ' ||g_se_no,101);

807:
808: BEGIN
809:
810: hr_utility.set_location('Entering procedure validate_E Holiday card',100);
811: hr_utility.set_location('SE Number of the receving company = ' ||g_se_no,101);
812: hr_utility.set_location('CVR Number of the receving company = ' ||g_cvr_no,102);
813:
814: OPEN csr_Legal_Emp_Details(g_se_no,g_cvr_no);
815: FETCH csr_Legal_Emp_Details into rg_Legal_Emp_Details;

Line 812: hr_utility.set_location('CVR Number of the receving company = ' ||g_cvr_no,102);

808: BEGIN
809:
810: hr_utility.set_location('Entering procedure validate_E Holiday card',100);
811: hr_utility.set_location('SE Number of the receving company = ' ||g_se_no,101);
812: hr_utility.set_location('CVR Number of the receving company = ' ||g_cvr_no,102);
813:
814: OPEN csr_Legal_Emp_Details(g_se_no,g_cvr_no);
815: FETCH csr_Legal_Emp_Details into rg_Legal_Emp_Details;
816: CLOSE csr_Legal_Emp_Details;

Line 828: hr_utility.set_location('organization id = ' ||g_legal_employer_id,102);

824: g_legal_employer_id := sp.org_id ;
825:
826: END IF ;
827:
828: hr_utility.set_location('organization id = ' ||g_legal_employer_id,102);
829: IF g_legal_employer_id IS NULL THEN
830: hr_utility.set_message(801, 'PAY_377024_DK_LEGAL_EMPLOYER_E');
831: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
832: hr_utility.raise_error;

Line 830: hr_utility.set_message(801, 'PAY_377024_DK_LEGAL_EMPLOYER_E');

826: END IF ;
827:
828: hr_utility.set_location('organization id = ' ||g_legal_employer_id,102);
829: IF g_legal_employer_id IS NULL THEN
830: hr_utility.set_message(801, 'PAY_377024_DK_LEGAL_EMPLOYER_E');
831: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
832: hr_utility.raise_error;
833: END IF;
834:

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

827:
828: hr_utility.set_location('organization id = ' ||g_legal_employer_id,102);
829: IF g_legal_employer_id IS NULL THEN
830: hr_utility.set_message(801, 'PAY_377024_DK_LEGAL_EMPLOYER_E');
831: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
832: hr_utility.raise_error;
833: END IF;
834:
835: OPEN csr_get_hol_entity(g_legal_employer_id,g_effective_date,g_business_group_id);

Line 832: hr_utility.raise_error;

828: hr_utility.set_location('organization id = ' ||g_legal_employer_id,102);
829: IF g_legal_employer_id IS NULL THEN
830: hr_utility.set_message(801, 'PAY_377024_DK_LEGAL_EMPLOYER_E');
831: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
832: hr_utility.raise_error;
833: END IF;
834:
835: OPEN csr_get_hol_entity(g_legal_employer_id,g_effective_date,g_business_group_id);
836: FETCH csr_get_hol_entity into l_work_pattern,l_use_holiday_card;

Line 839: hr_utility.set_location('le_name = ' ||rg_Legal_Emp_Details.le_name,103);

835: OPEN csr_get_hol_entity(g_legal_employer_id,g_effective_date,g_business_group_id);
836: FETCH csr_get_hol_entity into l_work_pattern,l_use_holiday_card;
837: CLOSE csr_get_hol_entity;
838:
839: hr_utility.set_location('le_name = ' ||rg_Legal_Emp_Details.le_name,103);
840: hr_utility.set_location('run id = ' ||g_run_id,105);
841: hr_utility.set_location('total employee on xml = ' ||g_count_employee,106);
842:
843: IF (l_use_holiday_card ='N' ) THEN

Line 840: hr_utility.set_location('run id = ' ||g_run_id,105);

836: FETCH csr_get_hol_entity into l_work_pattern,l_use_holiday_card;
837: CLOSE csr_get_hol_entity;
838:
839: hr_utility.set_location('le_name = ' ||rg_Legal_Emp_Details.le_name,103);
840: hr_utility.set_location('run id = ' ||g_run_id,105);
841: hr_utility.set_location('total employee on xml = ' ||g_count_employee,106);
842:
843: IF (l_use_holiday_card ='N' ) THEN
844: hr_utility.set_message(801, 'PAY_DK_USE_HOLIDAY_CARD');

Line 841: hr_utility.set_location('total employee on xml = ' ||g_count_employee,106);

837: CLOSE csr_get_hol_entity;
838:
839: hr_utility.set_location('le_name = ' ||rg_Legal_Emp_Details.le_name,103);
840: hr_utility.set_location('run id = ' ||g_run_id,105);
841: hr_utility.set_location('total employee on xml = ' ||g_count_employee,106);
842:
843: IF (l_use_holiday_card ='N' ) THEN
844: hr_utility.set_message(801, 'PAY_DK_USE_HOLIDAY_CARD');
845: hr_utility.raise_error;

Line 844: hr_utility.set_message(801, 'PAY_DK_USE_HOLIDAY_CARD');

840: hr_utility.set_location('run id = ' ||g_run_id,105);
841: hr_utility.set_location('total employee on xml = ' ||g_count_employee,106);
842:
843: IF (l_use_holiday_card ='N' ) THEN
844: hr_utility.set_message(801, 'PAY_DK_USE_HOLIDAY_CARD');
845: hr_utility.raise_error;
846: END IF ;
847:
848:

Line 845: hr_utility.raise_error;

841: hr_utility.set_location('total employee on xml = ' ||g_count_employee,106);
842:
843: IF (l_use_holiday_card ='N' ) THEN
844: hr_utility.set_message(801, 'PAY_DK_USE_HOLIDAY_CARD');
845: hr_utility.raise_error;
846: END IF ;
847:
848:
849: FOR i IN 1..g_count_employee LOOP

Line 863: hr_utility.set_location ( 'Mandatory parameter is missing', 50);

859: l_holidays := to_number(replace(g_hol_card_emp(i).no_of_hol,',','.'));
860:
861: IF l_name is null THEN
862: l_param := 'Navn';
863: hr_utility.set_location ( 'Mandatory parameter is missing', 50);
864: RAISE name_is_null;
865: END IF;
866:
867: IF (length(l_name) > 100) THEN

Line 869: hr_utility.set_location ( ' Record too long', 50);

865: END IF;
866:
867: IF (length(l_name) > 100) THEN
868: l_param := 'Navn';
869: hr_utility.set_location ( ' Record too long', 50);
870: RAISE e_record_too_long;
871: END IF;
872:
873: IF l_holidays is null THEN

Line 875: hr_utility.set_location ( 'Mandatory parameter is missing', 50);

871: END IF;
872:
873: IF l_holidays is null THEN
874: l_param := 'Antal_dage';
875: hr_utility.set_location ( 'Mandatory parameter is missing', 50);
876: RAISE name_is_null;
877: END IF;
878:
879: IF (length(l_year) > 4) THEN

Line 881: hr_utility.set_location ( ' Record too long', 50);

877: END IF;
878:
879: IF (length(l_year) > 4) THEN
880: l_param := 'Optjeningsaar';
881: hr_utility.set_location ( ' Record too long', 50);
882: RAISE e_record_too_long;
883: END IF;
884:
885: IF l_year is null THEN

Line 887: hr_utility.set_location ( 'Mandatory parameter is missing', 50);

883: END IF;
884:
885: IF l_year is null THEN
886: l_param := 'Optjeningsaar';
887: hr_utility.set_location ( 'Mandatory parameter is missing', 50);
888: RAISE name_is_null;
889: END IF;
890:
891: IF l_start_date is null THEN

Line 893: hr_utility.set_location ( 'Mandatory parameter is missing', 50);

889: END IF;
890:
891: IF l_start_date is null THEN
892: l_param := 'Ferie_start';
893: hr_utility.set_location ( 'Mandatory parameter is missing', 50);
894: RAISE name_is_null;
895: END IF;
896:
897: IF l_ass_no is null THEN

Line 899: hr_utility.set_location ( 'Mandatory parameter is missing', 50);

895: END IF;
896:
897: IF l_ass_no is null THEN
898: l_param := 'Medarbejdernummer';
899: hr_utility.set_location ( 'Mandatory parameter is missing', 50);
900: RAISE name_is_null;
901: END IF;
902:
903: IF (length(l_cvr_no) > 11) THEN

Line 905: hr_utility.set_location ( ' Record too long', 50);

901: END IF;
902:
903: IF (length(l_cvr_no) > 11) THEN
904: l_param := 'CPR_nummer';
905: hr_utility.set_location ( ' Record too long', 50);
906: RAISE e_record_too_long;
907: END IF;
908:
909:

Line 945: hr_utility.raise_error;

941: FETCH csr_ele_link INTO l_ele_link_id ;
942: IF csr_ele_link%NOTFOUND THEN
943: CLOSE csr_ele_link;
944: FND_FILE.PUT_LINE(fnd_file.log, 'No element links for Override Holiday Duration ');
945: hr_utility.raise_error;
946: END IF;
947: CLOSE csr_ele_link;
948:
949: OPEN csr_ele_link('Absent Holiday Card Request',l_payroll_id);

Line 954: hr_utility.raise_error;

950: FETCH csr_ele_link INTO l_ele_link_id;
951: IF csr_ele_link%NOTFOUND THEN
952: CLOSE csr_ele_link;
953: FND_FILE.PUT_LINE(fnd_file.log, 'No element links for Absent Holiday Card Request ');
954: hr_utility.raise_error;
955: END IF;
956: CLOSE csr_ele_link;
957:
958: OPEN csr_ele_link('Holiday Card Payment Request',l_payroll_id);

Line 963: hr_utility.raise_error;

959: FETCH csr_ele_link INTO l_ele_link_id;
960: IF csr_ele_link%NOTFOUND THEN
961: CLOSE csr_ele_link;
962: FND_FILE.PUT_LINE(fnd_file.log, 'No element links for Holiday Card Payment Request ');
963: hr_utility.raise_error;
964: END IF;
965: CLOSE csr_ele_link;
966: l_last_yr := to_char(TRUNC(l_start_date,'YEAR') - 1, 'RRRR');
967:

Line 974: hr_utility.set_location('l_curr_entit_yr = ' ||l_curr_entit_yr,208);

970: IF to_char(l_start_date,'MM') <='04' THEN
971:
972: l_curr_entit_yr := to_char(to_number(l_last_yr)- 1);
973: END IF;
974: hr_utility.set_location('l_curr_entit_yr = ' ||l_curr_entit_yr,208);
975: IF l_year <> l_curr_entit_yr THEN
976: hr_utility.set_location('l_year = ' ||l_year,209);
977: RAISE wrong_entit_year;
978: END IF;

Line 976: hr_utility.set_location('l_year = ' ||l_year,209);

972: l_curr_entit_yr := to_char(to_number(l_last_yr)- 1);
973: END IF;
974: hr_utility.set_location('l_curr_entit_yr = ' ||l_curr_entit_yr,208);
975: IF l_year <> l_curr_entit_yr THEN
976: hr_utility.set_location('l_year = ' ||l_year,209);
977: RAISE wrong_entit_year;
978: END IF;
979:
980: l_assg_id := rg_le_people.assg_id;

Line 983: hr_utility.set_location('l_start_date = ' ||l_start_date,201);

979:
980: l_assg_id := rg_le_people.assg_id;
981: l_5d_6d := rg_le_people.def_wrk_patt;
982: l_5d_6d := NVL(l_5d_6d,l_work_pattern);
983: hr_utility.set_location('l_start_date = ' ||l_start_date,201);
984: hr_utility.set_location('l_holidays = ' ||l_holidays,202);
985: hr_utility.set_location('l_5d_6d = ' ||l_5d_6d,203);
986:
987: get_end_date(l_start_date,l_holidays,l_assg_id,l_5d_6d,l_end_date);

Line 984: hr_utility.set_location('l_holidays = ' ||l_holidays,202);

980: l_assg_id := rg_le_people.assg_id;
981: l_5d_6d := rg_le_people.def_wrk_patt;
982: l_5d_6d := NVL(l_5d_6d,l_work_pattern);
983: hr_utility.set_location('l_start_date = ' ||l_start_date,201);
984: hr_utility.set_location('l_holidays = ' ||l_holidays,202);
985: hr_utility.set_location('l_5d_6d = ' ||l_5d_6d,203);
986:
987: get_end_date(l_start_date,l_holidays,l_assg_id,l_5d_6d,l_end_date);
988: hr_utility.set_location('l_end_date = ' ||l_end_date,204);

Line 985: hr_utility.set_location('l_5d_6d = ' ||l_5d_6d,203);

981: l_5d_6d := rg_le_people.def_wrk_patt;
982: l_5d_6d := NVL(l_5d_6d,l_work_pattern);
983: hr_utility.set_location('l_start_date = ' ||l_start_date,201);
984: hr_utility.set_location('l_holidays = ' ||l_holidays,202);
985: hr_utility.set_location('l_5d_6d = ' ||l_5d_6d,203);
986:
987: get_end_date(l_start_date,l_holidays,l_assg_id,l_5d_6d,l_end_date);
988: hr_utility.set_location('l_end_date = ' ||l_end_date,204);
989:

Line 988: hr_utility.set_location('l_end_date = ' ||l_end_date,204);

984: hr_utility.set_location('l_holidays = ' ||l_holidays,202);
985: hr_utility.set_location('l_5d_6d = ' ||l_5d_6d,203);
986:
987: get_end_date(l_start_date,l_holidays,l_assg_id,l_5d_6d,l_end_date);
988: hr_utility.set_location('l_end_date = ' ||l_end_date,204);
989:
990: IF NOT per_abs_bus.per_valid_for_absence
991: (p_person_id => rg_le_people.person_id
992: ,p_business_group_id => g_business_group_id

Line 1164: hr_utility.set_location(' leaving validate_ecard_details',10);

1160:
1161: END;
1162:
1163: END LOOP;
1164: hr_utility.set_location(' leaving validate_ecard_details',10);
1165: log_dk_ehol_card_header;
1166: log_dk_ehol_card_body;
1167:
1168: END validate_ecard_details;

Line 1196: hr_utility.set_location(' Entering Procedure PrintElements',10);

1192: e_record_too_long EXCEPTION;
1193:
1194: BEGIN
1195:
1196: hr_utility.set_location(' Entering Procedure PrintElements',10);
1197:
1198: -- k:= 0;
1199:
1200: -- get all elements

Line 1264: hr_utility.set_location ( ' Record too long', 50);

1260: END IF;
1261:
1262: IF (length(g_run_id) > 50) THEN
1263: l_param := 'RUN_ID';
1264: hr_utility.set_location ( ' Record too long', 50);
1265: RAISE e_record_too_long;
1266: END IF;
1267:
1268: IF g_se_no IS NULL THEN

Line 1276: hr_utility.set_location ( ' Record too long', 50);

1272: END IF;
1273:
1274: IF (length(g_se_no) > 20) THEN
1275: l_param := 'Virksomheds_SEnr';
1276: hr_utility.set_location ( ' Record too long', 50);
1277: RAISE e_record_too_long;
1278: END IF;
1279:
1280: IF g_cvr_no IS NULL THEN

Line 1287: hr_utility.set_location ( ' Record too long', 50);

1283: END IF;
1284:
1285: IF (length(g_cvr_no) > 20) THEN
1286: l_param := 'Virksomheds_CVRnr';
1287: hr_utility.set_location ( ' Record too long', 50);
1288: RAISE e_record_too_long;
1289: END IF;
1290:
1291: IF g_company_name IS NULL THEN

Line 1298: hr_utility.set_location ( ' Record too long', 50);

1294: END IF;
1295:
1296: IF (length(g_company_name) > 255) THEN
1297: l_param := 'Virksomheds_Navn';
1298: hr_utility.set_location ( ' Record too long', 50);
1299: RAISE e_record_too_long;
1300: END IF;
1301:
1302: g_count_employee := 0;

Line 1325: hr_utility.set_location ('Total employees requesting E-Holiday absence = ' ||g_count_employee,400);

1321:
1322:
1323: END LOOP;
1324: fnd_file.put_line(fnd_file.log,'Total employees requesting E-Holiday absence = ' ||g_count_employee);
1325: hr_utility.set_location ('Total employees requesting E-Holiday absence = ' ||g_count_employee,400);
1326: hr_utility.set_location(' leaving Procedure printelements',10);
1327:
1328: EXCEPTION
1329: WHEN record_value_is_null THEN

Line 1326: hr_utility.set_location(' leaving Procedure printelements',10);

1322:
1323: END LOOP;
1324: fnd_file.put_line(fnd_file.log,'Total employees requesting E-Holiday absence = ' ||g_count_employee);
1325: hr_utility.set_location ('Total employees requesting E-Holiday absence = ' ||g_count_employee,400);
1326: hr_utility.set_location(' leaving Procedure printelements',10);
1327:
1328: EXCEPTION
1329: WHEN record_value_is_null THEN
1330:

Line 1370: hr_utility.set_location(' Entering Procedure READ_HOL_CARD',10);

1366: e_fatal_error exception;
1367:
1368: BEGIN
1369:
1370: hr_utility.set_location(' Entering Procedure READ_HOL_CARD',10);
1371:
1372:
1373: OPEN csr_leg (p_business_group_id);
1374: FETCH csr_leg INTO p_legislation_code;

Line 1382: hr_utility.set_location ( 'Legislation = ' || p_legislation_code, 20);

1378: g_business_group_id := p_business_group_id;
1379: g_absence_attendance_type_id := p_absence_type_id;
1380: g_test_submission := test_submission;
1381:
1382: hr_utility.set_location ( 'Legislation = ' || p_legislation_code, 20);
1383: hr_utility.set_location ( 'p_absence_type_id = ' || p_absence_type_id, 21);
1384: hr_utility.set_location ( 'business group id = ' || g_business_group_id, 22);
1385: hr_utility.set_location ( 'effective date = ' || g_effective_date, 23);
1386: hr_utility.set_location ( 'g_test_submission = ' || g_test_submission, 24);

Line 1383: hr_utility.set_location ( 'p_absence_type_id = ' || p_absence_type_id, 21);

1379: g_absence_attendance_type_id := p_absence_type_id;
1380: g_test_submission := test_submission;
1381:
1382: hr_utility.set_location ( 'Legislation = ' || p_legislation_code, 20);
1383: hr_utility.set_location ( 'p_absence_type_id = ' || p_absence_type_id, 21);
1384: hr_utility.set_location ( 'business group id = ' || g_business_group_id, 22);
1385: hr_utility.set_location ( 'effective date = ' || g_effective_date, 23);
1386: hr_utility.set_location ( 'g_test_submission = ' || g_test_submission, 24);
1387:

Line 1384: hr_utility.set_location ( 'business group id = ' || g_business_group_id, 22);

1380: g_test_submission := test_submission;
1381:
1382: hr_utility.set_location ( 'Legislation = ' || p_legislation_code, 20);
1383: hr_utility.set_location ( 'p_absence_type_id = ' || p_absence_type_id, 21);
1384: hr_utility.set_location ( 'business group id = ' || g_business_group_id, 22);
1385: hr_utility.set_location ( 'effective date = ' || g_effective_date, 23);
1386: hr_utility.set_location ( 'g_test_submission = ' || g_test_submission, 24);
1387:
1388: -- p := xmlparser.newParser;

Line 1385: hr_utility.set_location ( 'effective date = ' || g_effective_date, 23);

1381:
1382: hr_utility.set_location ( 'Legislation = ' || p_legislation_code, 20);
1383: hr_utility.set_location ( 'p_absence_type_id = ' || p_absence_type_id, 21);
1384: hr_utility.set_location ( 'business group id = ' || g_business_group_id, 22);
1385: hr_utility.set_location ( 'effective date = ' || g_effective_date, 23);
1386: hr_utility.set_location ( 'g_test_submission = ' || g_test_submission, 24);
1387:
1388: -- p := xmlparser.newParser;
1389: -- xmlparser.setValidationMode(p, FALSE);

Line 1386: hr_utility.set_location ( 'g_test_submission = ' || g_test_submission, 24);

1382: hr_utility.set_location ( 'Legislation = ' || p_legislation_code, 20);
1383: hr_utility.set_location ( 'p_absence_type_id = ' || p_absence_type_id, 21);
1384: hr_utility.set_location ( 'business group id = ' || g_business_group_id, 22);
1385: hr_utility.set_location ( 'effective date = ' || g_effective_date, 23);
1386: hr_utility.set_location ( 'g_test_submission = ' || g_test_submission, 24);
1387:
1388: -- p := xmlparser.newParser;
1389: -- xmlparser.setValidationMode(p, FALSE);
1390:

Line 1399: hr_utility.set_location ( 'location: '||l_location,30);

1395: RAISE e_fatal_error;
1396: END IF;
1397: l_location := l_location||'/'||p_filename;
1398:
1399: hr_utility.set_location ( 'location: '||l_location,30);
1400: p := xmlparser.newParser;
1401: xmlparser.setValidationMode(p, FALSE);
1402:
1403: xmlparser.parse(p, l_location);

Line 1407: hr_utility.set_location(' leaving Procedure READ_HOL_CARD',10);

1403: xmlparser.parse(p, l_location);
1404: doc := xmlparser.getDocument(p);
1405: printElements(doc);
1406: validate_ecard_details(g_business_group_id,g_effective_date,retcode);
1407: hr_utility.set_location(' leaving Procedure READ_HOL_CARD',10);
1408:
1409: EXCEPTION
1410: WHEN e_fatal_error
1411: -- No directory specified

Line 1416: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');

1412: THEN
1413: -- Set retcode to 2, indicating an ERROR to the ConcMgr
1414: retcode := g_error;
1415: -- Set the application error
1416: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');
1417: -- Return the message to the ConcMgr (This msg will appear in the log file)
1418: errbuf := hr_utility.get_message;
1419:
1420: when xmldom.INDEX_SIZE_ERR then

Line 1418: errbuf := hr_utility.get_message;

1414: retcode := g_error;
1415: -- Set the application error
1416: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');
1417: -- Return the message to the ConcMgr (This msg will appear in the log file)
1418: errbuf := hr_utility.get_message;
1419:
1420: when xmldom.INDEX_SIZE_ERR then
1421: raise_application_error(-20120, 'Index Size error');
1422:

Line 1453: hr_utility.raise_error;

1449:
1450: WHEN others then
1451: fnd_file.put_line(fnd_file.log,'exception: '||SQLERRM);
1452: fnd_file.put_line(fnd_file.log,'exception: '||SQLCODE);
1453: hr_utility.raise_error;
1454:
1455: END read_hol_card;
1456:
1457: