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.HR_ES_UTILITY dependencies on HR_UTILITY

Line 168: hr_utility.set_message(800, 'HR_ES_INVALID_DNI');

164: BEGIN
165: IF (p_identifier_type='DNI') THEN
166: l_value := check_DNI(p_identifier_value);
167: IF l_value <> 'Y' THEN
168: hr_utility.set_message(800, 'HR_ES_INVALID_DNI');
169: hr_utility.raise_error;
170: END IF;
171: ELSIF(p_identifier_type='NIE') THEN
172: l_value := check_NIE(p_identifier_value);

Line 169: hr_utility.raise_error;

165: IF (p_identifier_type='DNI') THEN
166: l_value := check_DNI(p_identifier_value);
167: IF l_value <> 'Y' THEN
168: hr_utility.set_message(800, 'HR_ES_INVALID_DNI');
169: hr_utility.raise_error;
170: END IF;
171: ELSIF(p_identifier_type='NIE') THEN
172: l_value := check_NIE(p_identifier_value);
173: IF l_value <> 'Y' THEN

Line 174: hr_utility.set_message(800, 'HR_ES_INVALID_NIE');

170: END IF;
171: ELSIF(p_identifier_type='NIE') THEN
172: l_value := check_NIE(p_identifier_value);
173: IF l_value <> 'Y' THEN
174: hr_utility.set_message(800, 'HR_ES_INVALID_NIE');
175: hr_utility.raise_error;
176: END IF;
177: ELSIF(p_identifier_type NOT IN('DNI','NIE')
178: AND p_identifier_value IS NOT NULL) THEN

Line 175: hr_utility.raise_error;

171: ELSIF(p_identifier_type='NIE') THEN
172: l_value := check_NIE(p_identifier_value);
173: IF l_value <> 'Y' THEN
174: hr_utility.set_message(800, 'HR_ES_INVALID_NIE');
175: hr_utility.raise_error;
176: END IF;
177: ELSIF(p_identifier_type NOT IN('DNI','NIE')
178: AND p_identifier_value IS NOT NULL) THEN
179: l_value := 'Y';

Line 239: hr_utility.set_location(' inside first if',1);

235: --------------------------------------------------------------------------------
236:
237: IF p_acc_type = 'C' and (p_account_number is not null
238: or p_iban_acc is not null) then
239: hr_utility.set_location(' inside first if',1);
240: return l_ret;
241: end if;
242: l_ret := 3;
243: return l_ret;

Line 369: hr_utility.set_message(801,'HR_ES_NI_UNIQUE_WARNING');

365: AND p_identifier_value = pp.per_information3
366: AND p_identifier_type = pp.per_information2
367: AND pp.business_group_id = p_business_group_id);
368: --
369: hr_utility.set_message(801,'HR_ES_NI_UNIQUE_WARNING');
370: hr_utility.set_message_token('NI_NUMBER',hr_general.decode_lookup('ES_FORM_LABELS','IDENTIFIER_VALUE'));
371: RAISE local_warning;
372: --
373: EXCEPTION

Line 370: hr_utility.set_message_token('NI_NUMBER',hr_general.decode_lookup('ES_FORM_LABELS','IDENTIFIER_VALUE'));

366: AND p_identifier_type = pp.per_information2
367: AND pp.business_group_id = p_business_group_id);
368: --
369: hr_utility.set_message(801,'HR_ES_NI_UNIQUE_WARNING');
370: hr_utility.set_message_token('NI_NUMBER',hr_general.decode_lookup('ES_FORM_LABELS','IDENTIFIER_VALUE'));
371: RAISE local_warning;
372: --
373: EXCEPTION
374: WHEN NO_DATA_FOUND THEN NULL;

Line 376: hr_utility.set_warning;

372: --
373: EXCEPTION
374: WHEN NO_DATA_FOUND THEN NULL;
375: WHEN local_warning THEN
376: hr_utility.set_warning;
377: END;
378: EXCEPTION
379: WHEN NO_DATA_FOUND THEN
380: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 380: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

376: hr_utility.set_warning;
377: END;
378: EXCEPTION
379: WHEN NO_DATA_FOUND THEN
380: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
381: hr_utility.set_message_token('PROCEDURE','CHECK_IDENTIFIER_UNIQUE');
382: hr_utility.set_message_token('STEP','1');
383: hr_utility.raise_error;
384: WHEN local_warning THEN

Line 381: hr_utility.set_message_token('PROCEDURE','CHECK_IDENTIFIER_UNIQUE');

377: END;
378: EXCEPTION
379: WHEN NO_DATA_FOUND THEN
380: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
381: hr_utility.set_message_token('PROCEDURE','CHECK_IDENTIFIER_UNIQUE');
382: hr_utility.set_message_token('STEP','1');
383: hr_utility.raise_error;
384: WHEN local_warning THEN
385: hr_utility.set_warning;

Line 382: hr_utility.set_message_token('STEP','1');

378: EXCEPTION
379: WHEN NO_DATA_FOUND THEN
380: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
381: hr_utility.set_message_token('PROCEDURE','CHECK_IDENTIFIER_UNIQUE');
382: hr_utility.set_message_token('STEP','1');
383: hr_utility.raise_error;
384: WHEN local_warning THEN
385: hr_utility.set_warning;
386: END check_identifier_unique;

Line 383: hr_utility.raise_error;

379: WHEN NO_DATA_FOUND THEN
380: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
381: hr_utility.set_message_token('PROCEDURE','CHECK_IDENTIFIER_UNIQUE');
382: hr_utility.set_message_token('STEP','1');
383: hr_utility.raise_error;
384: WHEN local_warning THEN
385: hr_utility.set_warning;
386: END check_identifier_unique;
387:

Line 385: hr_utility.set_warning;

381: hr_utility.set_message_token('PROCEDURE','CHECK_IDENTIFIER_UNIQUE');
382: hr_utility.set_message_token('STEP','1');
383: hr_utility.raise_error;
384: WHEN local_warning THEN
385: hr_utility.set_warning;
386: END check_identifier_unique;
387:
388: --------------------------------------------------------------------------------
389: -- PROCEDURE validate_cif

Line 428: hr_utility.set_message(800,'HR_ES_INVALID_CIF');

424: END IF;
425: END LOOP;
426:
427: IF l_formula_mesg = 'INVALID_ID' THEN
428: hr_utility.set_message(800,'HR_ES_INVALID_CIF');
429: hr_utility.raise_error;
430: END IF;
431: END validate_cif;
432: --------------------------------------------------------------------------------

Line 429: hr_utility.raise_error;

425: END LOOP;
426:
427: IF l_formula_mesg = 'INVALID_ID' THEN
428: hr_utility.set_message(800,'HR_ES_INVALID_CIF');
429: hr_utility.raise_error;
430: END IF;
431: END validate_cif;
432: --------------------------------------------------------------------------------
433: -- FUNCTION validate_cac_lookup

Line 494: hr_utility.set_message(800,'HR_ES_INVALID_CAC');

490: END IF;
491: END LOOP;
492:
493: IF l_formula_mesg = 'INVALID_ID' THEN
494: hr_utility.set_message(800,'HR_ES_INVALID_CAC');
495: hr_utility.raise_error;
496: END IF;
497: END validate_cac;
498: --------------------------------------------------------------------------------

Line 495: hr_utility.raise_error;

491: END LOOP;
492:
493: IF l_formula_mesg = 'INVALID_ID' THEN
494: hr_utility.set_message(800,'HR_ES_INVALID_CAC');
495: hr_utility.raise_error;
496: END IF;
497: END validate_cac;
498: --------------------------------------------------------------------------------
499: -- PROCEDURE unique_cac

Line 560: hr_utility.set_message(800,'HR_ES_CAC_UNIQUE_ERROR');

556: CLOSE get_cac_statutory;
557: END IF;
558:
559: IF l_check_cac = 'x' or l_check_cac1 = 'x' THEN
560: hr_utility.set_message(800,'HR_ES_CAC_UNIQUE_ERROR');
561: hr_utility.raise_error;
562: END IF;
563: */
564:

Line 561: hr_utility.raise_error;

557: END IF;
558:
559: IF l_check_cac = 'x' or l_check_cac1 = 'x' THEN
560: hr_utility.set_message(800,'HR_ES_CAC_UNIQUE_ERROR');
561: hr_utility.raise_error;
562: END IF;
563: */
564:
565: IF p_context in('ES_STATUTORY_INFO') THEN

Line 572: hr_utility.set_message(800,'HR_ES_CAC_UNIQUE_ERROR');

568: CLOSE get_cac_statutory;
569: END IF;
570:
571: IF l_check_cac1 = 'x' THEN
572: hr_utility.set_message(800,'HR_ES_CAC_UNIQUE_ERROR');
573: hr_utility.raise_error;
574: END IF;
575:
576: --

Line 573: hr_utility.raise_error;

569: END IF;
570:
571: IF l_check_cac1 = 'x' THEN
572: hr_utility.set_message(800,'HR_ES_CAC_UNIQUE_ERROR');
573: hr_utility.raise_error;
574: END IF;
575:
576: --
577: END unique_cac;

Line 614: hr_utility.set_message(800,'HR_ES_SS_UNIQUE_ERROR');

610: CLOSE get_ss_code;
611: END IF;
612:
613: IF l_check_ss = 'x' THEN
614: hr_utility.set_message(800,'HR_ES_SS_UNIQUE_ERROR');
615: hr_utility.raise_error;
616: END IF;
617:
618: END unique_ss;

Line 615: hr_utility.raise_error;

611: END IF;
612:
613: IF l_check_ss = 'x' THEN
614: hr_utility.set_message(800,'HR_ES_SS_UNIQUE_ERROR');
615: hr_utility.raise_error;
616: END IF;
617:
618: END unique_ss;
619: --------------------------------------------------------------------------------

Line 647: hr_utility.set_message(800,'HR_ES_CIF_UNIQUE_ERROR');

643: OPEN get_cif;
644: FETCH get_cif INTO l_check_cif;
645: CLOSE get_cif;
646: IF l_check_cif = 'x' THEN
647: hr_utility.set_message(800,'HR_ES_CIF_UNIQUE_ERROR');
648: hr_utility.raise_error;
649: END IF;
650: END unique_cif;
651: --------------------------------------------------------------------------------

Line 648: hr_utility.raise_error;

644: FETCH get_cif INTO l_check_cif;
645: CLOSE get_cif;
646: IF l_check_cif = 'x' THEN
647: hr_utility.set_message(800,'HR_ES_CIF_UNIQUE_ERROR');
648: hr_utility.raise_error;
649: END IF;
650: END unique_cif;
651: --------------------------------------------------------------------------------
652: -- PROCEDURE validate_wc_sec_ref

Line 681: hr_utility.set_message(800,'HR_ES_INVALID_REFERENCE');

677: CLOSE csr_chk_wc_sec_ref;
678:
679: IF l_check_ref = 'x' THEN
680: IF p_context = 'ES_WORK_CENTER_REF' THEN
681: hr_utility.set_message(800,'HR_ES_INVALID_REFERENCE');
682: hr_utility.set_message_token(800,'VALUE'
683: ,hr_general.decode_lookup('ES_FORM_LABELS','WORK_CENTER'));
684: hr_utility.raise_error;
685: ELSIF p_context = 'ES_SECTION_REF' THEN

Line 682: hr_utility.set_message_token(800,'VALUE'

678:
679: IF l_check_ref = 'x' THEN
680: IF p_context = 'ES_WORK_CENTER_REF' THEN
681: hr_utility.set_message(800,'HR_ES_INVALID_REFERENCE');
682: hr_utility.set_message_token(800,'VALUE'
683: ,hr_general.decode_lookup('ES_FORM_LABELS','WORK_CENTER'));
684: hr_utility.raise_error;
685: ELSIF p_context = 'ES_SECTION_REF' THEN
686: hr_utility.set_message(800,'HR_ES_INVALID_REFERENCE');

Line 684: hr_utility.raise_error;

680: IF p_context = 'ES_WORK_CENTER_REF' THEN
681: hr_utility.set_message(800,'HR_ES_INVALID_REFERENCE');
682: hr_utility.set_message_token(800,'VALUE'
683: ,hr_general.decode_lookup('ES_FORM_LABELS','WORK_CENTER'));
684: hr_utility.raise_error;
685: ELSIF p_context = 'ES_SECTION_REF' THEN
686: hr_utility.set_message(800,'HR_ES_INVALID_REFERENCE');
687: hr_utility.set_message_token(800,'VALUE'
688: ,hr_general.decode_lookup('ES_FORM_LABELS','SECTION'));

Line 686: hr_utility.set_message(800,'HR_ES_INVALID_REFERENCE');

682: hr_utility.set_message_token(800,'VALUE'
683: ,hr_general.decode_lookup('ES_FORM_LABELS','WORK_CENTER'));
684: hr_utility.raise_error;
685: ELSIF p_context = 'ES_SECTION_REF' THEN
686: hr_utility.set_message(800,'HR_ES_INVALID_REFERENCE');
687: hr_utility.set_message_token(800,'VALUE'
688: ,hr_general.decode_lookup('ES_FORM_LABELS','SECTION'));
689: hr_utility.raise_error;
690: END IF;

Line 687: hr_utility.set_message_token(800,'VALUE'

683: ,hr_general.decode_lookup('ES_FORM_LABELS','WORK_CENTER'));
684: hr_utility.raise_error;
685: ELSIF p_context = 'ES_SECTION_REF' THEN
686: hr_utility.set_message(800,'HR_ES_INVALID_REFERENCE');
687: hr_utility.set_message_token(800,'VALUE'
688: ,hr_general.decode_lookup('ES_FORM_LABELS','SECTION'));
689: hr_utility.raise_error;
690: END IF;
691: END IF;

Line 689: hr_utility.raise_error;

685: ELSIF p_context = 'ES_SECTION_REF' THEN
686: hr_utility.set_message(800,'HR_ES_INVALID_REFERENCE');
687: hr_utility.set_message_token(800,'VALUE'
688: ,hr_general.decode_lookup('ES_FORM_LABELS','SECTION'));
689: hr_utility.raise_error;
690: END IF;
691: END IF;
692:
693: END validate_wc_sec_ref;

Line 716: hr_utility.set_message(800,'HR_ES_STAT_TERM_REASON_MISSING');

712: AND information1 IS NOT NULL);
713: --
714: EXCEPTION
715: WHEN NO_DATA_FOUND THEN
716: hr_utility.set_message(800,'HR_ES_STAT_TERM_REASON_MISSING');
717: hr_utility.set_warning;
718: END;
719: END check_leaving_reason;
720: --------------------------------------------------------------------------------

Line 717: hr_utility.set_warning;

713: --
714: EXCEPTION
715: WHEN NO_DATA_FOUND THEN
716: hr_utility.set_message(800,'HR_ES_STAT_TERM_REASON_MISSING');
717: hr_utility.set_warning;
718: END;
719: END check_leaving_reason;
720: --------------------------------------------------------------------------------
721: -- FUNCTION check_SSI

Line 895: hr_utility.set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);

891: l_colon_position := INSTR(p_token1,':');
892: l_token_name := SUBSTR(p_token1,1,l_colon_position-1);
893: l_token_value := SUBSTR(p_token1,l_colon_position+1,LENGTH(p_token1));
894: fnd_message.set_token(l_token_name, l_token_value);
895: hr_utility.set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);
896: END IF;
897:
898: IF p_token2 is not null then
899: /* Obtain token 2 name and value */

Line 904: hr_utility.set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);

900: l_colon_position := INSTR(p_token2,':');
901: l_token_name := SUBSTR(p_token2,1,l_colon_position-1);
902: l_token_value := SUBSTR(p_token2,l_colon_position+1,LENGTH(p_token2));
903: fnd_message.set_token(l_token_name, l_token_value);
904: hr_utility.set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);
905: END IF;
906:
907: IF p_token3 is not null then
908: /* Obtain token 3 name and value */

Line 913: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);

909: l_colon_position := INSTR(p_token3,':');
910: l_token_name := SUBSTR(p_token3,1,l_colon_position-1);
911: l_token_value := SUBSTR(p_token3,l_colon_position+1,LENGTH(p_token3));
912: fnd_message.set_token(l_token_name, l_token_value);
913: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
914: END IF;
915:
916: l_message := SUBSTRb(fnd_message.get,1,254);
917:

Line 936: hr_utility.trace('Inside get_table_value'||bus_group_id||' '||ptab_name||' '||pcol_name||' '||prow_value||' '||peffective_date);

932: BEGIN
933: --
934: BEGIN
935: --
936: hr_utility.trace('Inside get_table_value'||bus_group_id||' '||ptab_name||' '||pcol_name||' '||prow_value||' '||peffective_date);
937: l_ret:= hruserdt.get_table_value(bus_group_id
938: ,ptab_name
939: ,pcol_name
940: ,prow_value

Line 948: hr_utility.trace('l_ret '||l_ret);

944: WHEN NO_DATA_FOUND THEN
945: l_ret:='0';
946: END;
947: --
948: hr_utility.trace('l_ret '||l_ret);
949: RETURN to_number(l_ret);
950: --
951: END get_table_value;
952: --

Line 968: hr_utility.trace('Inside get_table_value'||bus_group_id||' '||ptab_name||' '||pcol_name||' '||prow_value||' '||peffective_date);

964: BEGIN
965: --
966: BEGIN
967: --
968: hr_utility.trace('Inside get_table_value'||bus_group_id||' '||ptab_name||' '||pcol_name||' '||prow_value||' '||peffective_date);
969: l_ret:= hruserdt.get_table_value(bus_group_id
970: ,ptab_name
971: ,pcol_name
972: ,prow_value

Line 980: hr_utility.trace('l_ret '||l_ret);

976: WHEN NO_DATA_FOUND THEN
977: l_ret:='0';
978: END;
979: --
980: hr_utility.trace('l_ret '||l_ret);
981: RETURN to_number(l_ret);
982: --
983: END get_table_value_date;
984: --

Line 1000: hr_utility.trace('Inside get_table_value_char'||bus_group_id||' '||ptab_name||' '||pcol_name||' '||prow_value||' '||peffective_date);

996: BEGIN
997: --
998: BEGIN
999: --
1000: hr_utility.trace('Inside get_table_value_char'||bus_group_id||' '||ptab_name||' '||pcol_name||' '||prow_value||' '||peffective_date);
1001: l_ret:= hruserdt.get_table_value(bus_group_id
1002: ,ptab_name
1003: ,pcol_name
1004: ,prow_value

Line 1007: hr_utility.trace('l_ret '||l_ret);

1003: ,pcol_name
1004: ,prow_value
1005: ,peffective_date);
1006: --
1007: hr_utility.trace('l_ret '||l_ret);
1008: EXCEPTION
1009: WHEN NO_DATA_FOUND THEN
1010: l_ret:='-1';
1011: END;

Line 1057: hr_utility.set_location('IBAN_VALIDATION_PKG.validate_iban_acc(p_account_no) ' || l_iban_ret_val,99);

1053:
1054: l_iban_ret_val NUMBER;
1055: BEGIN
1056: l_iban_ret_val := IBAN_VALIDATION_PKG.validate_iban_acc(p_account_no);
1057: hr_utility.set_location('IBAN_VALIDATION_PKG.validate_iban_acc(p_account_no) ' || l_iban_ret_val,99);
1058: return l_iban_ret_val;
1059: END validate_iban_acc;
1060:
1061: END hr_es_utility;