APPS.PAY_TEMPLATE_IVS dependencies on PAY_TEMPLATE_IVS

Line 1: PACKAGE BODY pay_template_ivs AS

1: PACKAGE BODY pay_template_ivs AS
2: /* $Header: pyaddivs.pkb 115.2 2003/04/03 17:55:28 ekim ship $ */
3: /*
4: Copyright 1996
5: Oracle Corporation

Line 22: package name pay_template_ivs rather

18: 05-Aug-1996 hparicha 40.0 Created.
19: 06-Jun-1997 sxshah 40.3 Moved Whenever SQLERROR to top.
20: This script did not compile.!!
21: 03-Apr-2003 ekim 115.2 2886771 Changed hr_utility message to reflect
22: package name pay_template_ivs rather
23: than hr_input_values.
24: Added gscc fix.
25: ======================================================================
26:

Line 528: hr_utility.set_location('pay_template_ivs.ins_3p_input_values', 1);

524: --
525: --
526: begin
527: --
528: hr_utility.set_location('pay_template_ivs.ins_3p_input_values', 1);
529: /*
530: --
531: -- Obtain Pay value name from translation table.
532: l_pay_value_name :=

Line 625: hr_utility.set_location('pay_template_ivs.chk_input_value', 1);

621: v_num_input_values number;
622: l_pay_value_name varchar2(80);
623: --
624: begin
625: hr_utility.set_location('pay_template_ivs.chk_input_value', 1);
626: --
627: -- get pay value name
628: l_pay_value_name := hr_input_values.get_pay_value_name
629: (p_legislation_code);

Line 642: hr_utility.set_location('pay_template_ivs.chk_input_value', 10);

638: hr_utility.raise_error;
639: --
640: end if;
641:
642: hr_utility.set_location('pay_template_ivs.chk_input_value', 10);
643: --
644: if p_insert_update_flag = 'INSERT' then
645: -- Make sure that a maximum of 6 input values can be created
646: begin

Line 698: hr_utility.set_location('pay_template_ivs.chk_input_value', 20);

694: hr_utility.raise_error;
695: --
696: end if;
697: --
698: hr_utility.set_location('pay_template_ivs.chk_input_value', 20);
699: --
700: */
701:
702: end if;-- In INSERT mode

Line 721: hr_utility.set_location('pay_template_ivs.chk_input_value', 40);

717: exception
718: when NO_DATA_FOUND then NULL;
719: end;
720:
721: hr_utility.set_location('pay_template_ivs.chk_input_value', 40);
722: --
723: if v_validation_check = 'N' then
724: --
725: hr_utility.set_message(801,'PAY_6168_INPVAL_DUP_NAME');

Line 781: hr_utility.set_location('pay_template_ivs.chk_input_value', 50);

777: hr_utility.raise_error;
778: --
779: end if;
780: --
781: hr_utility.set_location('pay_template_ivs.chk_input_value', 50);
782: --
783: elsif p_lookup_type is not NULL then
784: --
785: if (p_min_value is not NULL or

Line 794: hr_utility.set_location('pay_template_ivs.chk_input_value', 60);

790: hr_utility.set_message(801,'PAY_6906_INPVAL_LOOKUP_VAL');
791: hr_utility.raise_error;
792: --
793: end if;
794: hr_utility.set_location('pay_template_ivs.chk_input_value', 60);
795: --
796: --
797: elsif (p_min_value is not NULL or p_max_value is not NULL) then
798: --

Line 823: hr_utility.set_location('pay_template_ivs.chk_input_value', 70);

819: hr_utility.set_message(801,'PAY_6908_INPVAL_ERROR_VAL');
820: hr_utility.raise_error;
821: --
822: end if;
823: hr_utility.set_location('pay_template_ivs.chk_input_value', 70);
824: --
825: -- Mkae sure that when lookup validation is being used that the default when
826: -- specified is valid for the lookup type
827: --

Line 830: hr_utility.set_location('pay_template_ivs.chk_input_value', 80);

826: -- specified is valid for the lookup type
827: --
828: --
829: if (p_lookup_type is not NULL and p_default_value is not NULL) then
830: hr_utility.set_location('pay_template_ivs.chk_input_value', 80);
831: --
832: begin
833: --
834: v_validation_check := 'Y';

Line 848: hr_utility.set_location('pay_template_ivs.chk_input_value', 90);

844: exception
845: when NO_DATA_FOUND then NULL;
846: end;
847: --
848: hr_utility.set_location('pay_template_ivs.chk_input_value', 90);
849: --
850: if v_validation_check = 'N' then
851: --
852: hr_utility.set_message(801,'PAY_6171_INPVAL_NO_LOOKUP');

Line 887: END pay_template_ivs;

883: end chk_input_value;
884: --
885:
886:
887: END pay_template_ivs;