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.

[Home] [Help]

APPS.HR_ENTRY_API dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Record defined to hold information about a entry element that is being
5: -- updated.
6: --
7: g_debug boolean := hr_utility.debug_enabled;
8: g_counter number;
9: --
10: type t_update_entry_rec is record
11: (cost_allocation_keyflex_id number,

Line 244: hr_utility.set_location(l_proc_func_name, 5);

240: -- table then we don't need to check against a change to the
241: -- PAY_ELEMENT_ENTRY_VALUES_F table.
242: --
243: if g_debug then
244: hr_utility.set_location(l_proc_func_name, 5);
245: end if;
246: begin
247: select 'Y'
248: into l_check_entry_values

Line 467: hr_utility.set_location(l_proc_func_name, 10);

463: open select_entry_value;
464: while (NOT l_entry_changed) loop
465: --
466: if g_debug then
467: hr_utility.set_location(l_proc_func_name, 10);
468: end if;
469: --
470: -- fetch a row from the select_entry_value cursor returning the
471: -- input_value_id and screen_entry_value

Line 536: g_debug := hr_utility.debug_enabled;

532: p_assignment_id number,
533: p_effective_date date
534: ) is
535: begin
536: g_debug := hr_utility.debug_enabled;
537: -- Check whether the business_group_id has been set and
538: -- re-fetch if necessary.
539: if(g_asg_info.business_group_id is null or
540: g_asg_info.assignment_id is null or

Line 544: hr_utility.trace('Cache assignment info');

540: g_asg_info.assignment_id is null or
541: p_assignment_id <> g_asg_info.assignment_id)
542: then
543: if g_debug then
544: hr_utility.trace('Cache assignment info');
545: end if;
546:
547: g_asg_info.assignment_id := p_assignment_id;
548:

Line 574: hr_utility.trace('ADJUSTMENT_EE_SOURCE ' || g_asg_info.adj_ee_source);

570: when no_data_found then g_asg_info.adj_ee_source := 'A';
571: end;
572:
573: if g_debug then
574: hr_utility.trace('ADJUSTMENT_EE_SOURCE ' || g_asg_info.adj_ee_source);
575: end if;
576: end if;
577:
578: end if;

Line 612: hr_utility.trace('Inputs / contexts : ' || v_inputs.count);

608: -- Rather than fail, we check the input count before
609: -- attempting to set the input and context values.
610: if(v_inputs.count >= 1) then
611: if g_debug then
612: hr_utility.trace('Inputs / contexts : ' || v_inputs.count);
613: end if;
614: --
615: -- Set up the inputs and contexts to formula.
616: for i in v_inputs.first..v_inputs.last loop

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

628: -- Note - need to pass database format to formula.
629: v_inputs(i).value := p_entry_value;
630: else
631: -- No context recognised.
632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PROCEDURE',
634: 'hr_entry_api.run_validation_formula');
635: hr_utility.set_message_token('STEP','10');
636: hr_utility.raise_error;

Line 633: hr_utility.set_message_token('PROCEDURE',

629: v_inputs(i).value := p_entry_value;
630: else
631: -- No context recognised.
632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PROCEDURE',
634: 'hr_entry_api.run_validation_formula');
635: hr_utility.set_message_token('STEP','10');
636: hr_utility.raise_error;
637: end if;

Line 635: hr_utility.set_message_token('STEP','10');

631: -- No context recognised.
632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PROCEDURE',
634: 'hr_entry_api.run_validation_formula');
635: hr_utility.set_message_token('STEP','10');
636: hr_utility.raise_error;
637: end if;
638: end loop;
639: end if;

Line 636: hr_utility.raise_error;

632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PROCEDURE',
634: 'hr_entry_api.run_validation_formula');
635: hr_utility.set_message_token('STEP','10');
636: hr_utility.raise_error;
637: end if;
638: end loop;
639: end if;
640: --

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

642: --
643: -- Now obtain the return values. There should be
644: -- exactly two outputs.
645: if v_outputs.count <> 2 then
646: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
647: hr_utility.set_message_token('PROCEDURE',
648: 'hr_entry_api.run_validation_formula');
649: hr_utility.set_message_token('STEP','20');
650: hr_utility.raise_error;

Line 647: hr_utility.set_message_token('PROCEDURE',

643: -- Now obtain the return values. There should be
644: -- exactly two outputs.
645: if v_outputs.count <> 2 then
646: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
647: hr_utility.set_message_token('PROCEDURE',
648: 'hr_entry_api.run_validation_formula');
649: hr_utility.set_message_token('STEP','20');
650: hr_utility.raise_error;
651: end if;

Line 649: hr_utility.set_message_token('STEP','20');

645: if v_outputs.count <> 2 then
646: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
647: hr_utility.set_message_token('PROCEDURE',
648: 'hr_entry_api.run_validation_formula');
649: hr_utility.set_message_token('STEP','20');
650: hr_utility.raise_error;
651: end if;
652: --
653: for i in v_outputs.first..v_outputs.last loop

Line 650: hr_utility.raise_error;

646: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
647: hr_utility.set_message_token('PROCEDURE',
648: 'hr_entry_api.run_validation_formula');
649: hr_utility.set_message_token('STEP','20');
650: hr_utility.raise_error;
651: end if;
652: --
653: for i in v_outputs.first..v_outputs.last loop
654: if v_outputs(i).name = 'FORMULA_MESSAGE' then

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

657: elsif v_outputs(i).name = 'FORMULA_STATUS' then
658: --
659: v_formula_status := upper(v_outputs(i).value);
660: else
661: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
662: hr_utility.set_message_token('PROCEDURE',
663: 'hr_entry_api.run_validation_formula');
664: hr_utility.set_message_token('STEP','30');
665: hr_utility.raise_error;

Line 662: hr_utility.set_message_token('PROCEDURE',

658: --
659: v_formula_status := upper(v_outputs(i).value);
660: else
661: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
662: hr_utility.set_message_token('PROCEDURE',
663: 'hr_entry_api.run_validation_formula');
664: hr_utility.set_message_token('STEP','30');
665: hr_utility.raise_error;
666: end if;

Line 664: hr_utility.set_message_token('STEP','30');

660: else
661: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
662: hr_utility.set_message_token('PROCEDURE',
663: 'hr_entry_api.run_validation_formula');
664: hr_utility.set_message_token('STEP','30');
665: hr_utility.raise_error;
666: end if;
667: end loop;
668: --

Line 665: hr_utility.raise_error;

661: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
662: hr_utility.set_message_token('PROCEDURE',
663: 'hr_entry_api.run_validation_formula');
664: hr_utility.set_message_token('STEP','30');
665: hr_utility.raise_error;
666: end if;
667: end loop;
668: --
669: -- Check whether we have raised an error and act appropriately.

Line 675: hr_utility.raise_error;

671: -- I.e. the formula validation failed and we need to raise an error.
672: if v_formula_message is null then
673: -- User not defined an error message.
674: fnd_message.set_name ('PAY', 'HR_6648_ELE_ENTRY_FORMULA_ERR');
675: hr_utility.raise_error;
676: else
677: -- User has defined message and so we can raise it.
678: fnd_message.set_name ('PAY','HR_ELE_ENTRY_FORMULA_HINT');
679: fnd_message.set_token ('FORMULA_TEXT', v_formula_message, false);

Line 680: hr_utility.raise_error;

676: else
677: -- User has defined message and so we can raise it.
678: fnd_message.set_name ('PAY','HR_ELE_ENTRY_FORMULA_HINT');
679: fnd_message.set_token ('FORMULA_TEXT', v_formula_message, false);
680: hr_utility.raise_error;
681: end if;
682: elsif v_formula_status <> 'S' and p_warning_or_error = 'W' then
683: -- We have failed validation, but only want to warn.
684: if v_formula_message is null then

Line 687: hr_utility.set_warning;

683: -- We have failed validation, but only want to warn.
684: if v_formula_message is null then
685: -- User not defined an error message.
686: fnd_message.set_name ('PAY', 'HR_6648_ELE_ENTRY_FORMULA_ERR');
687: hr_utility.set_warning;
688: else
689: -- User has defined message and so we can raise it.
690: fnd_message.set_name ('PAY','HR_ELE_ENTRY_FORMULA_HINT');
691: fnd_message.set_token ('FORMULA_TEXT', v_formula_message, false);

Line 692: hr_utility.set_warning;

688: else
689: -- User has defined message and so we can raise it.
690: fnd_message.set_name ('PAY','HR_ELE_ENTRY_FORMULA_HINT');
691: fnd_message.set_token ('FORMULA_TEXT', v_formula_message, false);
692: hr_utility.set_warning;
693: end if;
694: end if;
695: end run_validation_formula;
696: --

Line 803: g_debug := hr_utility.debug_enabled;

799: v_formula_id number;
800: v_formula_profile varchar2(30); -- User profile value.
801: --
802: begin
803: g_debug := hr_utility.debug_enabled;
804: --
805: -- Need to determine the defaulted value of the entry value.
806: --
807: hr_entry.derive_default_value

Line 849: hr_utility.set_message(801, 'PAY_6303_INPUT_VALUE_OUT_RANGE');

845: -- if the warning_or_error flag has been set to 'Error' then Error
846: -- and stop procesing
847: --
848: if v_min_max_failure = 'F' and v_warning_or_error = 'E' then
849: hr_utility.set_message(801, 'PAY_6303_INPUT_VALUE_OUT_RANGE');
850: hr_utility.raise_error;
851: end if;
852: --
853: -- ******* Added this to fix bug 421842 **********

Line 850: hr_utility.raise_error;

846: -- and stop procesing
847: --
848: if v_min_max_failure = 'F' and v_warning_or_error = 'E' then
849: hr_utility.set_message(801, 'PAY_6303_INPUT_VALUE_OUT_RANGE');
850: hr_utility.raise_error;
851: end if;
852: --
853: -- ******* Added this to fix bug 421842 **********
854: -- if the warning_or_error flag has been set to 'Error' then only Warn

Line 858: hr_utility.set_message(801, 'PAY_6303_INPUT_VALUE_OUT_RANGE');

854: -- if the warning_or_error flag has been set to 'Error' then only Warn
855: -- but let the processing continue
856: --
857: if v_min_max_failure = 'F' and v_warning_or_error = 'W' then
858: hr_utility.set_message(801, 'PAY_6303_INPUT_VALUE_OUT_RANGE');
859: hr_utility.set_warning;
860: end if;
861: --
862: -- Check whether we need to perform formula validation.

Line 859: hr_utility.set_warning;

855: -- but let the processing continue
856: --
857: if v_min_max_failure = 'F' and v_warning_or_error = 'W' then
858: hr_utility.set_message(801, 'PAY_6303_INPUT_VALUE_OUT_RANGE');
859: hr_utility.set_warning;
860: end if;
861: --
862: -- Check whether we need to perform formula validation.
863: open csr_val_fmla;

Line 889: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');

885: open csr_valid_lookup(p_lookup_type,p_screen_format);
886: fetch csr_valid_lookup into v_lookup_code;
887: if csr_valid_lookup%notfound then
888: close csr_valid_lookup;
889: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');
890: hr_utility.set_message_token('LOOKUP_TYPE',p_lookup_type);
891: hr_utility.raise_error;
892: end if;
893: close csr_valid_lookup;

Line 890: hr_utility.set_message_token('LOOKUP_TYPE',p_lookup_type);

886: fetch csr_valid_lookup into v_lookup_code;
887: if csr_valid_lookup%notfound then
888: close csr_valid_lookup;
889: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');
890: hr_utility.set_message_token('LOOKUP_TYPE',p_lookup_type);
891: hr_utility.raise_error;
892: end if;
893: close csr_valid_lookup;
894: --

Line 891: hr_utility.raise_error;

887: if csr_valid_lookup%notfound then
888: close csr_valid_lookup;
889: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');
890: hr_utility.set_message_token('LOOKUP_TYPE',p_lookup_type);
891: hr_utility.raise_error;
892: end if;
893: close csr_valid_lookup;
894: --
895: -- If the element entry is used for benefit processing and the input

Line 910: hr_utility.trace('p_lookup_code: ' || v_lookup_code);

906: --
907: -- bug 372339, 604543 and 651458
908: --
909: if g_debug then
910: hr_utility.trace('p_lookup_code: ' || v_lookup_code);
911: end if;
912:
913: v_session_date := p_session_date;
914:

Line 924: hr_utility.trace('v_session_date: ' || fnd_date.date_to_canonical(v_session_date));

920: close csr_session_date;
921: end if;
922:
923: if g_debug then
924: hr_utility.trace('v_session_date: ' || fnd_date.date_to_canonical(v_session_date));
925: end if;
926:
927: -- bugfix 1273798
928: --if v_session_date = null then

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

928: --if v_session_date = null then
929: if v_session_date is null then
930:
931: close csr_benefit_entry;
932: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
933: hr_utility.set_message_token('PROCEDURE','hr_entry_api.validate_entry_value');
934: hr_utility.set_message_token('STEP','10');
935: hr_utility.raise_error;
936:

Line 933: hr_utility.set_message_token('PROCEDURE','hr_entry_api.validate_entry_value');

929: if v_session_date is null then
930:
931: close csr_benefit_entry;
932: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
933: hr_utility.set_message_token('PROCEDURE','hr_entry_api.validate_entry_value');
934: hr_utility.set_message_token('STEP','10');
935: hr_utility.raise_error;
936:
937: end if;

Line 934: hr_utility.set_message_token('STEP','10');

930:
931: close csr_benefit_entry;
932: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
933: hr_utility.set_message_token('PROCEDURE','hr_entry_api.validate_entry_value');
934: hr_utility.set_message_token('STEP','10');
935: hr_utility.raise_error;
936:
937: end if;
938:

Line 935: hr_utility.raise_error;

931: close csr_benefit_entry;
932: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
933: hr_utility.set_message_token('PROCEDURE','hr_entry_api.validate_entry_value');
934: hr_utility.set_message_token('STEP','10');
935: hr_utility.raise_error;
936:
937: end if;
938:
939: open csr_valid_coverage_level(p_input_value_id,v_lookup_code,TRUNC(v_session_date));

Line 943: hr_utility.set_message(801, 'HR_7437_BEN_COVERAGE_INVLD');

939: open csr_valid_coverage_level(p_input_value_id,v_lookup_code,TRUNC(v_session_date));
940: fetch csr_valid_coverage_level into v_dummy;
941: if csr_valid_coverage_level%found then
942: close csr_valid_coverage_level;
943: hr_utility.set_message(801, 'HR_7437_BEN_COVERAGE_INVLD');
944: hr_utility.raise_error;
945: end if;
946: if g_debug then
947: hr_utility.trace('valid_coverage_level_found ' || v_dummy);

Line 944: hr_utility.raise_error;

940: fetch csr_valid_coverage_level into v_dummy;
941: if csr_valid_coverage_level%found then
942: close csr_valid_coverage_level;
943: hr_utility.set_message(801, 'HR_7437_BEN_COVERAGE_INVLD');
944: hr_utility.raise_error;
945: end if;
946: if g_debug then
947: hr_utility.trace('valid_coverage_level_found ' || v_dummy);
948: end if;

Line 947: hr_utility.trace('valid_coverage_level_found ' || v_dummy);

943: hr_utility.set_message(801, 'HR_7437_BEN_COVERAGE_INVLD');
944: hr_utility.raise_error;
945: end if;
946: if g_debug then
947: hr_utility.trace('valid_coverage_level_found ' || v_dummy);
948: end if;
949: close csr_valid_coverage_level;
950:
951: end if;

Line 971: hr_utility.set_message(800, 'HR_34927_ELE_ENTRY_VSET_INVLD');

967: if v_value_set_value is null then
968: --
969: -- The screen format was invalid, raise an error
970: --
971: hr_utility.set_message(800, 'HR_34927_ELE_ENTRY_VSET_INVLD');
972: hr_utility.raise_error;
973: --
974: end if;
975: --

Line 972: hr_utility.raise_error;

968: --
969: -- The screen format was invalid, raise an error
970: --
971: hr_utility.set_message(800, 'HR_34927_ELE_ENTRY_VSET_INVLD');
972: hr_utility.raise_error;
973: --
974: end if;
975: --
976: p_db_format := v_value_set_value;

Line 1016: hr_utility.trace('> hr_entry_api.chk_user_enterable');

1012: --
1013: --
1014: BEGIN
1015: if g_debug then
1016: hr_utility.trace('> hr_entry_api.chk_user_enterable');
1017: hr_utility.trace('| p_el_id>' || p_el_id || '<');
1018: hr_utility.trace('| p_lookup_type>' || p_lookup_type || '<');
1019: hr_utility.trace('| p_value_set_id>' || p_value_set_id || '<');
1020: hr_utility.trace('| p_default_value>' || p_default_value || '<');

Line 1017: hr_utility.trace('| p_el_id>' || p_el_id || '<');

1013: --
1014: BEGIN
1015: if g_debug then
1016: hr_utility.trace('> hr_entry_api.chk_user_enterable');
1017: hr_utility.trace('| p_el_id>' || p_el_id || '<');
1018: hr_utility.trace('| p_lookup_type>' || p_lookup_type || '<');
1019: hr_utility.trace('| p_value_set_id>' || p_value_set_id || '<');
1020: hr_utility.trace('| p_default_value>' || p_default_value || '<');
1021: hr_utility.trace('| p_input_currency_code>' || p_input_currency_code || '<');

Line 1018: hr_utility.trace('| p_lookup_type>' || p_lookup_type || '<');

1014: BEGIN
1015: if g_debug then
1016: hr_utility.trace('> hr_entry_api.chk_user_enterable');
1017: hr_utility.trace('| p_el_id>' || p_el_id || '<');
1018: hr_utility.trace('| p_lookup_type>' || p_lookup_type || '<');
1019: hr_utility.trace('| p_value_set_id>' || p_value_set_id || '<');
1020: hr_utility.trace('| p_default_value>' || p_default_value || '<');
1021: hr_utility.trace('| p_input_currency_code>' || p_input_currency_code || '<');
1022: hr_utility.trace('| p_session_date>' || p_session_date || '<');

Line 1019: hr_utility.trace('| p_value_set_id>' || p_value_set_id || '<');

1015: if g_debug then
1016: hr_utility.trace('> hr_entry_api.chk_user_enterable');
1017: hr_utility.trace('| p_el_id>' || p_el_id || '<');
1018: hr_utility.trace('| p_lookup_type>' || p_lookup_type || '<');
1019: hr_utility.trace('| p_value_set_id>' || p_value_set_id || '<');
1020: hr_utility.trace('| p_default_value>' || p_default_value || '<');
1021: hr_utility.trace('| p_input_currency_code>' || p_input_currency_code || '<');
1022: hr_utility.trace('| p_session_date>' || p_session_date || '<');
1023: hr_utility.trace('| p_iv_id>' || p_iv_id || '<');

Line 1020: hr_utility.trace('| p_default_value>' || p_default_value || '<');

1016: hr_utility.trace('> hr_entry_api.chk_user_enterable');
1017: hr_utility.trace('| p_el_id>' || p_el_id || '<');
1018: hr_utility.trace('| p_lookup_type>' || p_lookup_type || '<');
1019: hr_utility.trace('| p_value_set_id>' || p_value_set_id || '<');
1020: hr_utility.trace('| p_default_value>' || p_default_value || '<');
1021: hr_utility.trace('| p_input_currency_code>' || p_input_currency_code || '<');
1022: hr_utility.trace('| p_session_date>' || p_session_date || '<');
1023: hr_utility.trace('| p_iv_id>' || p_iv_id || '<');
1024: hr_utility.trace('| p_ev>' || p_ev || '<');

Line 1021: hr_utility.trace('| p_input_currency_code>' || p_input_currency_code || '<');

1017: hr_utility.trace('| p_el_id>' || p_el_id || '<');
1018: hr_utility.trace('| p_lookup_type>' || p_lookup_type || '<');
1019: hr_utility.trace('| p_value_set_id>' || p_value_set_id || '<');
1020: hr_utility.trace('| p_default_value>' || p_default_value || '<');
1021: hr_utility.trace('| p_input_currency_code>' || p_input_currency_code || '<');
1022: hr_utility.trace('| p_session_date>' || p_session_date || '<');
1023: hr_utility.trace('| p_iv_id>' || p_iv_id || '<');
1024: hr_utility.trace('| p_ev>' || p_ev || '<');
1025: end if;

Line 1022: hr_utility.trace('| p_session_date>' || p_session_date || '<');

1018: hr_utility.trace('| p_lookup_type>' || p_lookup_type || '<');
1019: hr_utility.trace('| p_value_set_id>' || p_value_set_id || '<');
1020: hr_utility.trace('| p_default_value>' || p_default_value || '<');
1021: hr_utility.trace('| p_input_currency_code>' || p_input_currency_code || '<');
1022: hr_utility.trace('| p_session_date>' || p_session_date || '<');
1023: hr_utility.trace('| p_iv_id>' || p_iv_id || '<');
1024: hr_utility.trace('| p_ev>' || p_ev || '<');
1025: end if;
1026: --

Line 1023: hr_utility.trace('| p_iv_id>' || p_iv_id || '<');

1019: hr_utility.trace('| p_value_set_id>' || p_value_set_id || '<');
1020: hr_utility.trace('| p_default_value>' || p_default_value || '<');
1021: hr_utility.trace('| p_input_currency_code>' || p_input_currency_code || '<');
1022: hr_utility.trace('| p_session_date>' || p_session_date || '<');
1023: hr_utility.trace('| p_iv_id>' || p_iv_id || '<');
1024: hr_utility.trace('| p_ev>' || p_ev || '<');
1025: end if;
1026: --
1027: -- Only convert the format if it is an Insert call.

Line 1024: hr_utility.trace('| p_ev>' || p_ev || '<');

1020: hr_utility.trace('| p_default_value>' || p_default_value || '<');
1021: hr_utility.trace('| p_input_currency_code>' || p_input_currency_code || '<');
1022: hr_utility.trace('| p_session_date>' || p_session_date || '<');
1023: hr_utility.trace('| p_iv_id>' || p_iv_id || '<');
1024: hr_utility.trace('| p_ev>' || p_ev || '<');
1025: end if;
1026: --
1027: -- Only convert the format if it is an Insert call.
1028: --

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

1045: and h.lookup_code = p_default_value
1046: ;
1047: EXCEPTION
1048: WHEN NO_DATA_FOUND THEN
1049: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1050: hr_utility.set_message_token('PROCEDURE',
1051: 'hr_entry_api.chk_user_enterable');
1052: hr_utility.set_message_token('STEP','1');
1053: hr_utility.raise_error;

Line 1050: hr_utility.set_message_token('PROCEDURE',

1046: ;
1047: EXCEPTION
1048: WHEN NO_DATA_FOUND THEN
1049: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1050: hr_utility.set_message_token('PROCEDURE',
1051: 'hr_entry_api.chk_user_enterable');
1052: hr_utility.set_message_token('STEP','1');
1053: hr_utility.raise_error;
1054: END;

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

1048: WHEN NO_DATA_FOUND THEN
1049: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1050: hr_utility.set_message_token('PROCEDURE',
1051: 'hr_entry_api.chk_user_enterable');
1052: hr_utility.set_message_token('STEP','1');
1053: hr_utility.raise_error;
1054: END;
1055: --
1056: ELSE

Line 1053: hr_utility.raise_error;

1049: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1050: hr_utility.set_message_token('PROCEDURE',
1051: 'hr_entry_api.chk_user_enterable');
1052: hr_utility.set_message_token('STEP','1');
1053: hr_utility.raise_error;
1054: END;
1055: --
1056: ELSE
1057: --

Line 1073: hr_utility.trace('| l_screen_fmt_value>' || l_screen_fmt_value || '<');

1069: v_database_format_value => l_db_fmt_value);
1070: --
1071: --
1072: if g_debug then
1073: hr_utility.trace('| l_screen_fmt_value>' || l_screen_fmt_value || '<');
1074: hr_utility.trace('| l_db_fmt_value>' || l_db_fmt_value || '<');
1075: end if;
1076: --
1077: l_default := l_screen_fmt_value;

Line 1074: hr_utility.trace('| l_db_fmt_value>' || l_db_fmt_value || '<');

1070: --
1071: --
1072: if g_debug then
1073: hr_utility.trace('| l_screen_fmt_value>' || l_screen_fmt_value || '<');
1074: hr_utility.trace('| l_db_fmt_value>' || l_db_fmt_value || '<');
1075: end if;
1076: --
1077: l_default := l_screen_fmt_value;
1078: END IF;

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

1097: where h.lookup_type = p_lookup_type
1098: and h.lookup_code = p_default_value;
1099: exception
1100: when NO_DATA_FOUND then
1101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1102: hr_utility.set_message_token('PROCEDURE',
1103: 'hr_entry_api.chk_user_enterable');
1104: hr_utility.set_message_token('STEP','2');
1105: hr_utility.raise_error;

Line 1102: hr_utility.set_message_token('PROCEDURE',

1098: and h.lookup_code = p_default_value;
1099: exception
1100: when NO_DATA_FOUND then
1101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1102: hr_utility.set_message_token('PROCEDURE',
1103: 'hr_entry_api.chk_user_enterable');
1104: hr_utility.set_message_token('STEP','2');
1105: hr_utility.raise_error;
1106: end;

Line 1104: hr_utility.set_message_token('STEP','2');

1100: when NO_DATA_FOUND then
1101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1102: hr_utility.set_message_token('PROCEDURE',
1103: 'hr_entry_api.chk_user_enterable');
1104: hr_utility.set_message_token('STEP','2');
1105: hr_utility.raise_error;
1106: end;
1107: --
1108: -- Bugfix 5555289

Line 1105: hr_utility.raise_error;

1101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1102: hr_utility.set_message_token('PROCEDURE',
1103: 'hr_entry_api.chk_user_enterable');
1104: hr_utility.set_message_token('STEP','2');
1105: hr_utility.raise_error;
1106: end;
1107: --
1108: -- Bugfix 5555289
1109: -- If the input value uses a value set for validation then derive the

Line 1121: hr_utility.set_message(800, 'HR_34927_ELE_ENTRY_VSET_INVLD');

1117: if l_default is null then
1118: --
1119: -- The p_default_value was invalid, raise an error
1120: --
1121: hr_utility.set_message(800, 'HR_34927_ELE_ENTRY_VSET_INVLD');
1122: hr_utility.raise_error;
1123: --
1124: end if;
1125: --

Line 1122: hr_utility.raise_error;

1118: --
1119: -- The p_default_value was invalid, raise an error
1120: --
1121: hr_utility.set_message(800, 'HR_34927_ELE_ENTRY_VSET_INVLD');
1122: hr_utility.raise_error;
1123: --
1124: end if;
1125: --
1126: else

Line 1134: hr_utility.trace('| l_default>' || l_default || '<');

1130: --
1131: END IF;
1132:
1133: if g_debug then
1134: hr_utility.trace('| l_default>' || l_default || '<');
1135: end if;
1136: --
1137: /* Commented the below block as no longer we raise error and there is no use for following code
1138: IF g_override_user_ent_chk = 'Y' THEN

Line 1150: hr_utility.trace('| EV specified matches value on EL, ok');

1146:
1147: IF (l_default IS NOT NULL AND p_ev IS NOT NULL AND p_ev = l_default) OR (l_default IS NULL AND p_ev IS NULL) THEN
1148: p_ev := l_default;
1149: if g_debug then
1150: hr_utility.trace('| EV specified matches value on EL, ok');
1151: end if;
1152:
1153: ELSIF l_default IS NOT NULL AND p_ev IS NOT NULL AND p_ev <> l_default THEN
1154: --

Line 1159: hr_utility.trace('| EV does not match the default value stored on PLIV');

1155: -- API can 'update' a default as specified on EL,
1156: -- therefore default is not null, forms cannot do this
1157: --
1158: if g_debug then
1159: hr_utility.trace('| EV does not match the default value stored on PLIV');
1160: end if;
1161: -- hr_utility.set_message (800, 'PAY_50380_INPVAL_NOT_UPDATABLE');
1162: -- hr_utility.raise_error;
1163:

Line 1161: -- hr_utility.set_message (800, 'PAY_50380_INPVAL_NOT_UPDATABLE');

1157: --
1158: if g_debug then
1159: hr_utility.trace('| EV does not match the default value stored on PLIV');
1160: end if;
1161: -- hr_utility.set_message (800, 'PAY_50380_INPVAL_NOT_UPDATABLE');
1162: -- hr_utility.raise_error;
1163:
1164: ELSE
1165: --

Line 1162: -- hr_utility.raise_error;

1158: if g_debug then
1159: hr_utility.trace('| EV does not match the default value stored on PLIV');
1160: end if;
1161: -- hr_utility.set_message (800, 'PAY_50380_INPVAL_NOT_UPDATABLE');
1162: -- hr_utility.raise_error;
1163:
1164: ELSE
1165: --
1166: -- if there is no default value to compare against (an EV

Line 1172: hr_utility.trace('| EV specified');

1168: -- for the API to 'set' a value for a non User Enterable IV,
1169: -- forms cannot do this
1170: --
1171: if g_debug then
1172: hr_utility.trace('| EV specified');
1173: end if;
1174: -- hr_utility.set_message (800, 'PAY_50381_INPVAL_NOT_ENTERABLE');
1175: -- hr_utility.raise_error;
1176: END IF;

Line 1174: -- hr_utility.set_message (800, 'PAY_50381_INPVAL_NOT_ENTERABLE');

1170: --
1171: if g_debug then
1172: hr_utility.trace('| EV specified');
1173: end if;
1174: -- hr_utility.set_message (800, 'PAY_50381_INPVAL_NOT_ENTERABLE');
1175: -- hr_utility.raise_error;
1176: END IF;
1177:
1178: --

Line 1175: -- hr_utility.raise_error;

1171: if g_debug then
1172: hr_utility.trace('| EV specified');
1173: end if;
1174: -- hr_utility.set_message (800, 'PAY_50381_INPVAL_NOT_ENTERABLE');
1175: -- hr_utility.raise_error;
1176: END IF;
1177:
1178: --
1179: --

Line 1183: hr_utility.trace('< hr_entry_api.chk_user_enterable');

1179: --
1180: END IF; */
1181: --
1182: if g_debug then
1183: hr_utility.trace('< hr_entry_api.chk_user_enterable');
1184: end if;
1185: END chk_user_enterable;
1186: --
1187: ------------------------------------------------------------------------------

Line 1414: g_debug := hr_utility.debug_enabled;

1410: --
1411: v_creator_type varchar2(30);
1412: --
1413: begin
1414: g_debug := hr_utility.debug_enabled;
1415: --
1416: if g_debug then
1417: hr_utility.set_location('hr_entry.conv_entry_values_to_table',5);
1418: end if;

Line 1417: hr_utility.set_location('hr_entry.conv_entry_values_to_table',5);

1413: begin
1414: g_debug := hr_utility.debug_enabled;
1415: --
1416: if g_debug then
1417: hr_utility.set_location('hr_entry.conv_entry_values_to_table',5);
1418: end if;
1419: --
1420: if p_creator_type = hr_api.g_varchar2 then
1421: open csr_creator_type(p_element_entry_id,p_session_date);

Line 1429: hr_utility.trace('p_entry_value1: ' || p_entry_value1);

1425: v_creator_type := p_creator_type;
1426: end if;
1427: --
1428: if g_debug then
1429: hr_utility.trace('p_entry_value1: ' || p_entry_value1);
1430: end if;
1431: --
1432: -- User is inserting a new element entry.
1433: --

Line 1437: hr_utility.set_location('hr_entry.conv_entry_values_to_table',10);

1433: --
1434: if p_element_link_id is not null then
1435: --
1436: if g_debug then
1437: hr_utility.set_location('hr_entry.conv_entry_values_to_table',10);
1438: end if;
1439: --
1440: -- Find all the entry values for the specified element entry NB. it is a
1441: -- new element entry so have to get the details of the entry values from

Line 1448: hr_utility.set_location('hr_entry.conv_entry_values_to_table',15);

1444: for v_link_value in csr_link_input_value(p_element_link_id,
1445: p_session_date) loop
1446: --
1447: if g_debug then
1448: hr_utility.set_location('hr_entry.conv_entry_values_to_table',15);
1449: end if;
1450: --
1451: -- Keep a count of the number of entry values and put input_value_id of
1452: -- entry value into table.

Line 1462: hr_utility.trace('| Begin conv_entry_values_to_table()');

1458: -- cobert it to DB format.
1459: --
1460: if p_iv_format = 'SCREEN' and v_link_value.entry_specified = 'SET' then
1461: if g_debug then
1462: hr_utility.trace('| Begin conv_entry_values_to_table()');
1463: end if;
1464: --
1465: -- v_link_value.entry_specified really indicates that the IV_ID
1466: -- has been specified

Line 1484: hr_utility.trace('| p_entry_type>' || p_entry_type || '<');

1480: -- S Override
1481: -- R Replacement Adjustment
1482: --
1483: if g_debug then
1484: hr_utility.trace('| p_entry_type>' || p_entry_type || '<');
1485: end if;
1486: --
1487: -- Bugfix 3187829
1488: -- Do not call chk_user_enterable for entry type 'R' (replacement

Line 1495: hr_utility.trace('| creator type in F or H and not A EE');

1491: -- type 'A' (additive adjustment) behaviour.
1492: --
1493: IF v_creator_type IN ('F','H') AND p_entry_type NOT IN ('A','R') THEN
1494: if g_debug then
1495: hr_utility.trace('| creator type in F or H and not A EE');
1496: end if;
1497: --
1498: IF v_link_value.mandatory_flag = 'X'
1499: -- Following commented out because user can entre null value too.

Line 1503: hr_utility.trace('| flag set to X and EV specified');

1499: -- Following commented out because user can entre null value too.
1500: -- AND v_link_value.entry_value IS NOT NULL
1501: THEN
1502: if g_debug then
1503: hr_utility.trace('| flag set to X and EV specified');
1504: end if;
1505: --
1506: -- only raise the error if the EV does not match the
1507: -- default value stored on PLIV

Line 1526: hr_utility.trace('| End conv_entry_values_to_table()');

1522: --
1523: END IF;
1524: --
1525: if g_debug then
1526: hr_utility.trace('| End conv_entry_values_to_table()');
1527: end if;
1528: --
1529: --
1530: v_screen_format := v_link_value.entry_value;

Line 1568: hr_utility.trace('v_db_format: ' || v_db_format);

1564: -- Put entry value into table.
1565: --
1566: v_entry_value_tbl(v_count) := v_db_format;
1567: if g_debug then
1568: hr_utility.trace('v_db_format: ' || v_db_format);
1569: end if;
1570: --
1571: else
1572: --

Line 1577: hr_utility.trace('v_link_value.entry_value: ' ||

1573: -- Put entry value into table.
1574: --
1575: v_entry_value_tbl(v_count) := v_link_value.entry_value;
1576: if g_debug then
1577: hr_utility.trace('v_link_value.entry_value: ' ||
1578: v_link_value.entry_value);
1579: end if;
1580: --
1581: end if;

Line 1590: hr_utility.set_location('hr_entry.conv_entry_values_to_table',20);

1586: --
1587: elsif p_element_entry_id is not null then
1588: --
1589: if g_debug then
1590: hr_utility.set_location('hr_entry.conv_entry_values_to_table',20);
1591: end if;
1592: --
1593: -- Find all the entry values for the specified element entry.
1594: --

Line 1599: hr_utility.set_location('hr_entry.conv_entry_values_to_table',25);

1595: for v_entry_value in csr_entry_input_value(p_element_entry_id,
1596: p_session_date) loop
1597: --
1598: if g_debug then
1599: hr_utility.set_location('hr_entry.conv_entry_values_to_table',25);
1600: hr_utility.trace('v_entry_value.element_link_id: '||to_char(v_entry_value.element_link_id) );
1601: hr_utility.trace('v_entry_value.input_value_id: '||to_char(v_entry_value.input_value_id) );
1602: hr_utility.trace('v_entry_value.lookup_type: '||v_entry_value.lookup_type) ;
1603: hr_utility.trace('v_entry_value.value_set_id: '||to_char(v_entry_value.value_set_id) );

Line 1600: hr_utility.trace('v_entry_value.element_link_id: '||to_char(v_entry_value.element_link_id) );

1596: p_session_date) loop
1597: --
1598: if g_debug then
1599: hr_utility.set_location('hr_entry.conv_entry_values_to_table',25);
1600: hr_utility.trace('v_entry_value.element_link_id: '||to_char(v_entry_value.element_link_id) );
1601: hr_utility.trace('v_entry_value.input_value_id: '||to_char(v_entry_value.input_value_id) );
1602: hr_utility.trace('v_entry_value.lookup_type: '||v_entry_value.lookup_type) ;
1603: hr_utility.trace('v_entry_value.value_set_id: '||to_char(v_entry_value.value_set_id) );
1604: hr_utility.trace('v_entry_value.uom: '||v_entry_value.uom) ;

Line 1601: hr_utility.trace('v_entry_value.input_value_id: '||to_char(v_entry_value.input_value_id) );

1597: --
1598: if g_debug then
1599: hr_utility.set_location('hr_entry.conv_entry_values_to_table',25);
1600: hr_utility.trace('v_entry_value.element_link_id: '||to_char(v_entry_value.element_link_id) );
1601: hr_utility.trace('v_entry_value.input_value_id: '||to_char(v_entry_value.input_value_id) );
1602: hr_utility.trace('v_entry_value.lookup_type: '||v_entry_value.lookup_type) ;
1603: hr_utility.trace('v_entry_value.value_set_id: '||to_char(v_entry_value.value_set_id) );
1604: hr_utility.trace('v_entry_value.uom: '||v_entry_value.uom) ;
1605: hr_utility.trace('v_entry_value.hot_default_flag: '||v_entry_value.hot_default_flag) ;

Line 1602: hr_utility.trace('v_entry_value.lookup_type: '||v_entry_value.lookup_type) ;

1598: if g_debug then
1599: hr_utility.set_location('hr_entry.conv_entry_values_to_table',25);
1600: hr_utility.trace('v_entry_value.element_link_id: '||to_char(v_entry_value.element_link_id) );
1601: hr_utility.trace('v_entry_value.input_value_id: '||to_char(v_entry_value.input_value_id) );
1602: hr_utility.trace('v_entry_value.lookup_type: '||v_entry_value.lookup_type) ;
1603: hr_utility.trace('v_entry_value.value_set_id: '||to_char(v_entry_value.value_set_id) );
1604: hr_utility.trace('v_entry_value.uom: '||v_entry_value.uom) ;
1605: hr_utility.trace('v_entry_value.hot_default_flag: '||v_entry_value.hot_default_flag) ;
1606: hr_utility.trace('v_entry_value.input_currency_code: '||v_entry_value.input_currency_code) ;

Line 1603: hr_utility.trace('v_entry_value.value_set_id: '||to_char(v_entry_value.value_set_id) );

1599: hr_utility.set_location('hr_entry.conv_entry_values_to_table',25);
1600: hr_utility.trace('v_entry_value.element_link_id: '||to_char(v_entry_value.element_link_id) );
1601: hr_utility.trace('v_entry_value.input_value_id: '||to_char(v_entry_value.input_value_id) );
1602: hr_utility.trace('v_entry_value.lookup_type: '||v_entry_value.lookup_type) ;
1603: hr_utility.trace('v_entry_value.value_set_id: '||to_char(v_entry_value.value_set_id) );
1604: hr_utility.trace('v_entry_value.uom: '||v_entry_value.uom) ;
1605: hr_utility.trace('v_entry_value.hot_default_flag: '||v_entry_value.hot_default_flag) ;
1606: hr_utility.trace('v_entry_value.input_currency_code: '||v_entry_value.input_currency_code) ;
1607: hr_utility.trace('v_entry_value.mandatory_flag: '||v_entry_value.mandatory_flag) ;

Line 1604: hr_utility.trace('v_entry_value.uom: '||v_entry_value.uom) ;

1600: hr_utility.trace('v_entry_value.element_link_id: '||to_char(v_entry_value.element_link_id) );
1601: hr_utility.trace('v_entry_value.input_value_id: '||to_char(v_entry_value.input_value_id) );
1602: hr_utility.trace('v_entry_value.lookup_type: '||v_entry_value.lookup_type) ;
1603: hr_utility.trace('v_entry_value.value_set_id: '||to_char(v_entry_value.value_set_id) );
1604: hr_utility.trace('v_entry_value.uom: '||v_entry_value.uom) ;
1605: hr_utility.trace('v_entry_value.hot_default_flag: '||v_entry_value.hot_default_flag) ;
1606: hr_utility.trace('v_entry_value.input_currency_code: '||v_entry_value.input_currency_code) ;
1607: hr_utility.trace('v_entry_value.mandatory_flag: '||v_entry_value.mandatory_flag) ;
1608: hr_utility.trace('v_entry_value.peev_default_value: '||v_entry_value.peev_default_value) ;

Line 1605: hr_utility.trace('v_entry_value.hot_default_flag: '||v_entry_value.hot_default_flag) ;

1601: hr_utility.trace('v_entry_value.input_value_id: '||to_char(v_entry_value.input_value_id) );
1602: hr_utility.trace('v_entry_value.lookup_type: '||v_entry_value.lookup_type) ;
1603: hr_utility.trace('v_entry_value.value_set_id: '||to_char(v_entry_value.value_set_id) );
1604: hr_utility.trace('v_entry_value.uom: '||v_entry_value.uom) ;
1605: hr_utility.trace('v_entry_value.hot_default_flag: '||v_entry_value.hot_default_flag) ;
1606: hr_utility.trace('v_entry_value.input_currency_code: '||v_entry_value.input_currency_code) ;
1607: hr_utility.trace('v_entry_value.mandatory_flag: '||v_entry_value.mandatory_flag) ;
1608: hr_utility.trace('v_entry_value.peev_default_value: '||v_entry_value.peev_default_value) ;
1609: hr_utility.trace('v_entry_value.entry_value: '|| v_entry_value.entry_value) ;

Line 1606: hr_utility.trace('v_entry_value.input_currency_code: '||v_entry_value.input_currency_code) ;

1602: hr_utility.trace('v_entry_value.lookup_type: '||v_entry_value.lookup_type) ;
1603: hr_utility.trace('v_entry_value.value_set_id: '||to_char(v_entry_value.value_set_id) );
1604: hr_utility.trace('v_entry_value.uom: '||v_entry_value.uom) ;
1605: hr_utility.trace('v_entry_value.hot_default_flag: '||v_entry_value.hot_default_flag) ;
1606: hr_utility.trace('v_entry_value.input_currency_code: '||v_entry_value.input_currency_code) ;
1607: hr_utility.trace('v_entry_value.mandatory_flag: '||v_entry_value.mandatory_flag) ;
1608: hr_utility.trace('v_entry_value.peev_default_value: '||v_entry_value.peev_default_value) ;
1609: hr_utility.trace('v_entry_value.entry_value: '|| v_entry_value.entry_value) ;
1610: hr_utility.trace('v_entry_value.entry_specified: '||v_entry_value.entry_specified) ;

Line 1607: hr_utility.trace('v_entry_value.mandatory_flag: '||v_entry_value.mandatory_flag) ;

1603: hr_utility.trace('v_entry_value.value_set_id: '||to_char(v_entry_value.value_set_id) );
1604: hr_utility.trace('v_entry_value.uom: '||v_entry_value.uom) ;
1605: hr_utility.trace('v_entry_value.hot_default_flag: '||v_entry_value.hot_default_flag) ;
1606: hr_utility.trace('v_entry_value.input_currency_code: '||v_entry_value.input_currency_code) ;
1607: hr_utility.trace('v_entry_value.mandatory_flag: '||v_entry_value.mandatory_flag) ;
1608: hr_utility.trace('v_entry_value.peev_default_value: '||v_entry_value.peev_default_value) ;
1609: hr_utility.trace('v_entry_value.entry_value: '|| v_entry_value.entry_value) ;
1610: hr_utility.trace('v_entry_value.entry_specified: '||v_entry_value.entry_specified) ;
1611: end if;

Line 1608: hr_utility.trace('v_entry_value.peev_default_value: '||v_entry_value.peev_default_value) ;

1604: hr_utility.trace('v_entry_value.uom: '||v_entry_value.uom) ;
1605: hr_utility.trace('v_entry_value.hot_default_flag: '||v_entry_value.hot_default_flag) ;
1606: hr_utility.trace('v_entry_value.input_currency_code: '||v_entry_value.input_currency_code) ;
1607: hr_utility.trace('v_entry_value.mandatory_flag: '||v_entry_value.mandatory_flag) ;
1608: hr_utility.trace('v_entry_value.peev_default_value: '||v_entry_value.peev_default_value) ;
1609: hr_utility.trace('v_entry_value.entry_value: '|| v_entry_value.entry_value) ;
1610: hr_utility.trace('v_entry_value.entry_specified: '||v_entry_value.entry_specified) ;
1611: end if;
1612: --

Line 1609: hr_utility.trace('v_entry_value.entry_value: '|| v_entry_value.entry_value) ;

1605: hr_utility.trace('v_entry_value.hot_default_flag: '||v_entry_value.hot_default_flag) ;
1606: hr_utility.trace('v_entry_value.input_currency_code: '||v_entry_value.input_currency_code) ;
1607: hr_utility.trace('v_entry_value.mandatory_flag: '||v_entry_value.mandatory_flag) ;
1608: hr_utility.trace('v_entry_value.peev_default_value: '||v_entry_value.peev_default_value) ;
1609: hr_utility.trace('v_entry_value.entry_value: '|| v_entry_value.entry_value) ;
1610: hr_utility.trace('v_entry_value.entry_specified: '||v_entry_value.entry_specified) ;
1611: end if;
1612: --
1613: -- Keep a count of the number of entry values and put input_value_id of

Line 1610: hr_utility.trace('v_entry_value.entry_specified: '||v_entry_value.entry_specified) ;

1606: hr_utility.trace('v_entry_value.input_currency_code: '||v_entry_value.input_currency_code) ;
1607: hr_utility.trace('v_entry_value.mandatory_flag: '||v_entry_value.mandatory_flag) ;
1608: hr_utility.trace('v_entry_value.peev_default_value: '||v_entry_value.peev_default_value) ;
1609: hr_utility.trace('v_entry_value.entry_value: '|| v_entry_value.entry_value) ;
1610: hr_utility.trace('v_entry_value.entry_specified: '||v_entry_value.entry_specified) ;
1611: end if;
1612: --
1613: -- Keep a count of the number of entry values and put input_value_id of
1614: -- entry value into table.

Line 1626: hr_utility.trace('| creator type in F or H and not A EE');

1622: if p_iv_format = 'SCREEN' and v_entry_value.entry_specified = 'SET' then
1623: --
1624: IF v_creator_type IN ('F', 'H') AND p_entry_type <> 'A' THEN
1625: if g_debug then
1626: hr_utility.trace('| creator type in F or H and not A EE');
1627: end if;
1628: --
1629: IF v_entry_value.mandatory_flag = 'X'
1630: -- Following commented out because user can entre null value too.

Line 1634: hr_utility.trace('| flag set to X and EV specified');

1630: -- Following commented out because user can entre null value too.
1631: -- AND v_entry_value.entry_value IS NOT NULL
1632: THEN
1633: if g_debug then
1634: hr_utility.trace('| flag set to X and EV specified');
1635: end if;
1636: --
1637: -- only raise the error if the EV does not match the
1638: -- existing value.

Line 1662: hr_utility.set_location('hr_entry.conv_entry_values_to_table',27);

1658: v_screen_format := v_entry_value.entry_value;
1659: v_db_format := v_screen_format;
1660: --
1661: if g_debug then
1662: hr_utility.set_location('hr_entry.conv_entry_values_to_table',27);
1663: end if;
1664: --
1665: hr_entry_api.validate_entry_value
1666: (v_entry_value.element_link_id,

Line 1693: hr_utility.set_location('hr_entry.conv_entry_values_to_table',30);

1689: --
1690: end if;
1691: --
1692: if g_debug then
1693: hr_utility.set_location('hr_entry.conv_entry_values_to_table',30);
1694: end if;
1695: --
1696: -- Return tables containing the entry values in DB format.
1697: --

Line 1820: g_debug := hr_utility.debug_enabled;

1816: v_element_link_id number;
1817: v_entry_value_found boolean := false;
1818: --
1819: begin
1820: g_debug := hr_utility.debug_enabled;
1821: --
1822: if g_debug then
1823: hr_utility.set_location('hr_entry.conv_to_table',5);
1824: end if;

Line 1823: hr_utility.set_location('hr_entry.conv_to_table',5);

1819: begin
1820: g_debug := hr_utility.debug_enabled;
1821: --
1822: if g_debug then
1823: hr_utility.set_location('hr_entry.conv_to_table',5);
1824: end if;
1825: --
1826: --
1827: if p_creator_type = hr_api.g_varchar2 then

Line 1870: hr_utility.trace('| Begin conv_table_to_table()');

1866: -- convert it to DB format.
1867: --
1868: if p_iv_format = 'SCREEN' then
1869: if g_debug then
1870: hr_utility.trace('| Begin conv_table_to_table()');
1871: end if;
1872: --
1873: -- match found,
1874: -- one of the IV_IDs passed in matches the current IV_ID

Line 1884: hr_utility.trace('| p_entry_type>' || p_entry_type || '<');

1880: -- bug 546670, repeat validation as exists in
1881: -- conv_entry_values_to_table(),
1882: --
1883: if g_debug then
1884: hr_utility.trace('| p_entry_type>' || p_entry_type || '<');
1885: end if;
1886: --
1887: IF v_creator_type IN ('F', 'H') AND p_entry_type <> 'A' THEN
1888: if g_debug then

Line 1889: hr_utility.trace('| creator type in F or H and not A EE');

1885: end if;
1886: --
1887: IF v_creator_type IN ('F', 'H') AND p_entry_type <> 'A' THEN
1888: if g_debug then
1889: hr_utility.trace('| creator type in F or H and not A EE');
1890: end if;
1891:
1892: IF v_link_value.mandatory_flag = 'X'
1893: -- Following commented out because user can entre null value too.

Line 1897: hr_utility.trace('| flag set to X and EV specified');

1893: -- Following commented out because user can entre null value too.
1894: -- AND p_entry_value_tbl(v_loop) IS NOT NULL
1895: THEN
1896: if g_debug then
1897: hr_utility.trace('| flag set to X and EV specified');
1898: end if;
1899: --
1900: -- only raise the error if the EV does not match the
1901: -- default value stored on PLIV

Line 1920: hr_utility.trace('| End conv_table_to_table()');

1916:
1917: END IF;
1918: --
1919: if g_debug then
1920: hr_utility.trace('| End conv_table_to_table()');
1921: end if;
1922: --
1923: --
1924: v_screen_format := p_entry_value_tbl(v_loop);

Line 2038: hr_utility.trace('| creator type in F or H and not A EE');

2034: if p_iv_format = 'SCREEN' then
2035: --
2036: IF v_creator_type IN ('F', 'H') AND p_entry_type <> 'A' THEN
2037: if g_debug then
2038: hr_utility.trace('| creator type in F or H and not A EE');
2039: end if;
2040: --
2041: IF v_entry_value.mandatory_flag = 'X'
2042: -- Following commented out because user can entre null value too.

Line 2046: hr_utility.trace('| flag set to X and EV specified');

2042: -- Following commented out because user can entre null value too.
2043: -- AND p_entry_value_tbl(v_loop) IS NOT NULL
2044: THEN
2045: if g_debug then
2046: hr_utility.trace('| flag set to X and EV specified');
2047: end if;
2048: --
2049: -- only raise the error if the EV does not match the
2050: -- existing value.

Line 2126: hr_utility.set_location('hr_entry.conv_table_to_table',10);

2122: --
2123: end if;
2124: --
2125: if g_debug then
2126: hr_utility.set_location('hr_entry.conv_table_to_table',10);
2127: end if;
2128: --
2129: -- Return tables containing the entry values in DB format.
2130: --

Line 2158: g_debug := hr_utility.debug_enabled;

2154: --
2155: v_element_link_id number;
2156: --
2157: begin
2158: g_debug := hr_utility.debug_enabled;
2159: --
2160: begin
2161: select el.element_link_id
2162: into v_element_link_id

Line 2262: hr_utility.set_message (801, 'HR_7796_ENTRY_INVALID_PPM');

2258: --
2259: -- Special case exclusion for the Balance Adjustment entries.
2260: --
2261: if (p_entry_type <> 'B') then
2262: hr_utility.set_message (801, 'HR_7796_ENTRY_INVALID_PPM');
2263: hr_utility.raise_error;
2264: end if;
2265: --
2266: --

Line 2263: hr_utility.raise_error;

2259: -- Special case exclusion for the Balance Adjustment entries.
2260: --
2261: if (p_entry_type <> 'B') then
2262: hr_utility.set_message (801, 'HR_7796_ENTRY_INVALID_PPM');
2263: hr_utility.raise_error;
2264: end if;
2265: --
2266: --
2267: else

Line 2279: hr_utility.set_message (801, 'HR_7795_ENTRY_NOT_3RD_PARTY');

2275: fetch third_party_element into l_dummy;
2276: if third_party_element%notfound then
2277: --
2278: close third_party_element;
2279: hr_utility.set_message (801, 'HR_7795_ENTRY_NOT_3RD_PARTY');
2280: hr_utility.raise_error;
2281: --
2282: end if;
2283: --

Line 2280: hr_utility.raise_error;

2276: if third_party_element%notfound then
2277: --
2278: close third_party_element;
2279: hr_utility.set_message (801, 'HR_7795_ENTRY_NOT_3RD_PARTY');
2280: hr_utility.raise_error;
2281: --
2282: end if;
2283: --
2284: close third_party_element;

Line 2293: hr_utility.set_message (801, 'HR_7796_ENTRY_INVALID_PPM');

2289: --
2290: -- There was no personal_payment_method for the ID passed in
2291: --
2292: close personal_payment_method;
2293: hr_utility.set_message (801, 'HR_7796_ENTRY_INVALID_PPM');
2294: hr_utility.raise_error;
2295: --
2296: else
2297: --

Line 2294: hr_utility.raise_error;

2290: -- There was no personal_payment_method for the ID passed in
2291: --
2292: close personal_payment_method;
2293: hr_utility.set_message (801, 'HR_7796_ENTRY_INVALID_PPM');
2294: hr_utility.raise_error;
2295: --
2296: else
2297: --
2298: close personal_payment_method;

Line 2307: hr_utility.set_message (801, 'HR_7797_ENTRY_PPM_DATES');

2303: or (p_effective_end_date > l_ppm_end) then
2304: --
2305: -- The payment method does not exist for the whole life of the entry
2306: --
2307: hr_utility.set_message (801, 'HR_7797_ENTRY_PPM_DATES');
2308: hr_utility.raise_error;
2309: --
2310: end if;
2311: --

Line 2308: hr_utility.raise_error;

2304: --
2305: -- The payment method does not exist for the whole life of the entry
2306: --
2307: hr_utility.set_message (801, 'HR_7797_ENTRY_PPM_DATES');
2308: hr_utility.raise_error;
2309: --
2310: end if;
2311: --
2312: end if;

Line 2350: hr_utility.trace ('p_date_earned = '||p_date_earned);

2346: --
2347: begin
2348: --
2349: if g_debug then
2350: hr_utility.trace ('p_date_earned = '||p_date_earned);
2351: hr_utility.trace ('p_effective_start_date = '||p_effective_start_date);
2352: hr_utility.trace ('p_effective_end_date = '||p_effective_end_date);
2353: hr_utility.trace ('p_element_link_id = '||p_element_link_id);
2354: hr_utility.trace ('p_entry_type = '||p_entry_type);

Line 2351: hr_utility.trace ('p_effective_start_date = '||p_effective_start_date);

2347: begin
2348: --
2349: if g_debug then
2350: hr_utility.trace ('p_date_earned = '||p_date_earned);
2351: hr_utility.trace ('p_effective_start_date = '||p_effective_start_date);
2352: hr_utility.trace ('p_effective_end_date = '||p_effective_end_date);
2353: hr_utility.trace ('p_element_link_id = '||p_element_link_id);
2354: hr_utility.trace ('p_entry_type = '||p_entry_type);
2355: end if;

Line 2352: hr_utility.trace ('p_effective_end_date = '||p_effective_end_date);

2348: --
2349: if g_debug then
2350: hr_utility.trace ('p_date_earned = '||p_date_earned);
2351: hr_utility.trace ('p_effective_start_date = '||p_effective_start_date);
2352: hr_utility.trace ('p_effective_end_date = '||p_effective_end_date);
2353: hr_utility.trace ('p_element_link_id = '||p_element_link_id);
2354: hr_utility.trace ('p_entry_type = '||p_entry_type);
2355: end if;
2356: --

Line 2353: hr_utility.trace ('p_element_link_id = '||p_element_link_id);

2349: if g_debug then
2350: hr_utility.trace ('p_date_earned = '||p_date_earned);
2351: hr_utility.trace ('p_effective_start_date = '||p_effective_start_date);
2352: hr_utility.trace ('p_effective_end_date = '||p_effective_end_date);
2353: hr_utility.trace ('p_element_link_id = '||p_element_link_id);
2354: hr_utility.trace ('p_entry_type = '||p_entry_type);
2355: end if;
2356: --
2357: if p_date_earned is null then

Line 2354: hr_utility.trace ('p_entry_type = '||p_entry_type);

2350: hr_utility.trace ('p_date_earned = '||p_date_earned);
2351: hr_utility.trace ('p_effective_start_date = '||p_effective_start_date);
2352: hr_utility.trace ('p_effective_end_date = '||p_effective_end_date);
2353: hr_utility.trace ('p_element_link_id = '||p_element_link_id);
2354: hr_utility.trace ('p_entry_type = '||p_entry_type);
2355: end if;
2356: --
2357: if p_date_earned is null then
2358: return; -- Abort check.

Line 2366: hr_utility.set_message (801,'HR_7793_ENTRY_DATE_EARNED');

2362: and p_effective_end_date then
2363: --
2364: -- The date_earned must lie within the effective dates
2365: --
2366: hr_utility.set_message (801,'HR_7793_ENTRY_DATE_EARNED');
2367: hr_utility.raise_error;
2368: --
2369: else
2370: --

Line 2367: hr_utility.raise_error;

2363: --
2364: -- The date_earned must lie within the effective dates
2365: --
2366: hr_utility.set_message (801,'HR_7793_ENTRY_DATE_EARNED');
2367: hr_utility.raise_error;
2368: --
2369: else
2370: --
2371: -- Only nonrecurring entries may have date earned

Line 2381: hr_utility.set_message (801, 'HR_7794_ENTRY_DATE_EARNED_NULL');

2377: --
2378: if processing_type%notfound then
2379: --
2380: close processing_type;
2381: hr_utility.set_message (801, 'HR_7794_ENTRY_DATE_EARNED_NULL');
2382: hr_utility.raise_error;
2383: --
2384: end if;
2385: --

Line 2382: hr_utility.raise_error;

2378: if processing_type%notfound then
2379: --
2380: close processing_type;
2381: hr_utility.set_message (801, 'HR_7794_ENTRY_DATE_EARNED_NULL');
2382: hr_utility.raise_error;
2383: --
2384: end if;
2385: --
2386: close processing_type;

Line 2424: hr_utility.set_message(801, 'HR_7026_ELE_ENTRY_ASS_NOT_EXST');

2420: and asg.effective_end_date;
2421: --
2422: exception
2423: when no_data_found then
2424: hr_utility.set_message(801, 'HR_7026_ELE_ENTRY_ASS_NOT_EXST');
2425: hr_utility.set_message_token('DATE',fnd_date.date_to_canonical(p_validation_start_date));
2426: hr_utility.raise_error;
2427: end;
2428: --

Line 2425: hr_utility.set_message_token('DATE',fnd_date.date_to_canonical(p_validation_start_date));

2421: --
2422: exception
2423: when no_data_found then
2424: hr_utility.set_message(801, 'HR_7026_ELE_ENTRY_ASS_NOT_EXST');
2425: hr_utility.set_message_token('DATE',fnd_date.date_to_canonical(p_validation_start_date));
2426: hr_utility.raise_error;
2427: end;
2428: --
2429: end val_assignment;

Line 2426: hr_utility.raise_error;

2422: exception
2423: when no_data_found then
2424: hr_utility.set_message(801, 'HR_7026_ELE_ENTRY_ASS_NOT_EXST');
2425: hr_utility.set_message_token('DATE',fnd_date.date_to_canonical(p_validation_start_date));
2426: hr_utility.raise_error;
2427: end;
2428: --
2429: end val_assignment;
2430: --

Line 2462: hr_utility.set_message(801, 'HR_7027_ELE_ENTRY_EL_NOT_EXST');

2458: and el.effective_end_date;
2459: --
2460: exception
2461: when no_data_found then
2462: hr_utility.set_message(801, 'HR_7027_ELE_ENTRY_EL_NOT_EXST');
2463: hr_utility.set_message_token('DATE',fnd_date.date_to_canonical(p_validation_start_date));
2464: hr_utility.raise_error;
2465: end;
2466: --

Line 2463: hr_utility.set_message_token('DATE',fnd_date.date_to_canonical(p_validation_start_date));

2459: --
2460: exception
2461: when no_data_found then
2462: hr_utility.set_message(801, 'HR_7027_ELE_ENTRY_EL_NOT_EXST');
2463: hr_utility.set_message_token('DATE',fnd_date.date_to_canonical(p_validation_start_date));
2464: hr_utility.raise_error;
2465: end;
2466: --
2467: end val_element_link;

Line 2464: hr_utility.raise_error;

2460: exception
2461: when no_data_found then
2462: hr_utility.set_message(801, 'HR_7027_ELE_ENTRY_EL_NOT_EXST');
2463: hr_utility.set_message_token('DATE',fnd_date.date_to_canonical(p_validation_start_date));
2464: hr_utility.raise_error;
2465: end;
2466: --
2467: end val_element_link;
2468: --

Line 2512: hr_utility.set_message(801, 'HR_7028_ELE_ENTRY_CA_NOT_EXST');

2508: where cst.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
2509: --
2510: exception
2511: when no_data_found then
2512: hr_utility.set_message(801, 'HR_7028_ELE_ENTRY_CA_NOT_EXST');
2513: hr_utility.raise_error;
2514: end;
2515: --
2516: -- Bugfix 2667184

Line 2513: hr_utility.raise_error;

2509: --
2510: exception
2511: when no_data_found then
2512: hr_utility.set_message(801, 'HR_7028_ELE_ENTRY_CA_NOT_EXST');
2513: hr_utility.raise_error;
2514: end;
2515: --
2516: -- Bugfix 2667184
2517: -- Ensure p_cost_allocation_keyflex_id belongs to cost_allocation_structure

Line 2525: hr_utility.set_message(801,'HR_33130_INV_COST_ALLOC_KF');

2521: , g_asg_info.business_group_id);
2522: fetch csr_valid_id_flex_num into v_exists;
2523: if csr_valid_id_flex_num%notfound then
2524: close csr_valid_id_flex_num;
2525: hr_utility.set_message(801,'HR_33130_INV_COST_ALLOC_KF');
2526: hr_utility.raise_error;
2527: else
2528: close csr_valid_id_flex_num;
2529: end if;

Line 2526: hr_utility.raise_error;

2522: fetch csr_valid_id_flex_num into v_exists;
2523: if csr_valid_id_flex_num%notfound then
2524: close csr_valid_id_flex_num;
2525: hr_utility.set_message(801,'HR_33130_INV_COST_ALLOC_KF');
2526: hr_utility.raise_error;
2527: else
2528: close csr_valid_id_flex_num;
2529: end if;
2530: --

Line 2560: hr_utility.set_message(801, 'HR_7029_ELE_ENTRY_CMT_NOT_EXST');

2556: where com.comment_id = p_comment_id;
2557: --
2558: exception
2559: when no_data_found then
2560: hr_utility.set_message(801, 'HR_7029_ELE_ENTRY_CMT_NOT_EXST');
2561: hr_utility.raise_error;
2562: end;
2563: --
2564: end val_comment;

Line 2561: hr_utility.raise_error;

2557: --
2558: exception
2559: when no_data_found then
2560: hr_utility.set_message(801, 'HR_7029_ELE_ENTRY_CMT_NOT_EXST');
2561: hr_utility.raise_error;
2562: end;
2563: --
2564: end val_comment;
2565: --

Line 2610: hr_utility.set_message(801, 'HR_7030_ELE_ENTRY_INV_ADJ');

2606: and ee.effective_end_date;
2607: --
2608: exception
2609: when no_data_found then
2610: hr_utility.set_message(801, 'HR_7030_ELE_ENTRY_INV_ADJ');
2611: hr_utility.raise_error;
2612: end;
2613: --
2614: end val_adjustment;

Line 2611: hr_utility.raise_error;

2607: --
2608: exception
2609: when no_data_found then
2610: hr_utility.set_message(801, 'HR_7030_ELE_ENTRY_INV_ADJ');
2611: hr_utility.raise_error;
2612: end;
2613: --
2614: end val_adjustment;
2615: --

Line 2679: hr_utility.set_location('Entering: '||l_proc, 5);

2675: --
2676: begin
2677: --
2678: if g_debug then
2679: hr_utility.set_location('Entering: '||l_proc, 5);
2680: end if;
2681:
2682: begin
2683: --

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

2689:
2690: elsif p_entry_type = 'E' then
2691:
2692: if g_debug then
2693: hr_utility.set_location(l_proc, 20);
2694: end if;
2695:
2696: select 1
2697: into v_number_variable

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

2715:
2716: elsif p_entry_type = 'B' then
2717:
2718: if g_debug then
2719: hr_utility.set_location(l_proc, 30);
2720: end if;
2721:
2722: open csr_adj_orig_entry;
2723: fetch csr_adj_orig_entry into v_number_variable;

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

2728: close csr_adj_orig_entry;
2729:
2730: else
2731: if g_debug then
2732: hr_utility.set_location(l_proc, 40);
2733: end if;
2734:
2735: raise no_data_found;
2736: end if;

Line 2741: hr_utility.set_message(801, 'HR_7031_ELE_ENTRY_OE_INVLD');

2737:
2738: --
2739: exception
2740: when no_data_found then
2741: hr_utility.set_message(801, 'HR_7031_ELE_ENTRY_OE_INVLD');
2742: hr_utility.raise_error;
2743: end;
2744:
2745: if g_debug then

Line 2742: hr_utility.raise_error;

2738: --
2739: exception
2740: when no_data_found then
2741: hr_utility.set_message(801, 'HR_7031_ELE_ENTRY_OE_INVLD');
2742: hr_utility.raise_error;
2743: end;
2744:
2745: if g_debug then
2746: hr_utility.set_location('Leaving: '||l_proc, 80);

Line 2746: hr_utility.set_location('Leaving: '||l_proc, 80);

2742: hr_utility.raise_error;
2743: end;
2744:
2745: if g_debug then
2746: hr_utility.set_location('Leaving: '||l_proc, 80);
2747: end if;
2748: --
2749: end val_original_entry;
2750: --

Line 2783: hr_utility.set_message(801, 'HR_7032_ELE_ENTRY_INV_REASON');

2779: nvl(hl.start_date_active,p_effective_date) and nvl(hl.end_date_active,p_effective_date);
2780: --
2781: exception
2782: when no_data_found then
2783: hr_utility.set_message(801, 'HR_7032_ELE_ENTRY_INV_REASON');
2784: hr_utility.raise_error;
2785: end;
2786: --
2787: end val_reason;

Line 2784: hr_utility.raise_error;

2780: --
2781: exception
2782: when no_data_found then
2783: hr_utility.set_message(801, 'HR_7032_ELE_ENTRY_INV_REASON');
2784: hr_utility.raise_error;
2785: end;
2786: --
2787: end val_reason;
2788: --

Line 2837: g_debug := hr_utility.debug_enabled;

2833: l_counter number;
2834: --
2835: BEGIN
2836: --
2837: g_debug := hr_utility.debug_enabled;
2838: --
2839: if g_debug then
2840: hr_utility.set_location(
2841: 'Entering hr_entry_api.derive_all_entry_values_null', 5

Line 2840: hr_utility.set_location(

2836: --
2837: g_debug := hr_utility.debug_enabled;
2838: --
2839: if g_debug then
2840: hr_utility.set_location(
2841: 'Entering hr_entry_api.derive_all_entry_values_null', 5
2842: );
2843: end if;
2844: --

Line 2850: hr_utility.set_location('derive_all_entry_values_null', 10);

2846: --
2847: if p_entry_value_tbl.COUNT > 0 then
2848: --
2849: if g_debug then
2850: hr_utility.set_location('derive_all_entry_values_null', 10);
2851: end if;
2852: --
2853: l_counter := 1;
2854: --

Line 2867: hr_utility.set_location('derive_all_entry_values_null', 15);

2863: --
2864: exit when p_entry_value_tbl(l_counter) is not null;
2865: --
2866: if g_debug then
2867: hr_utility.set_location('derive_all_entry_values_null', 15);
2868: hr_utility.trace('| Entry value '||to_char(l_counter)||' is null.');
2869: end if;
2870: --
2871: if l_counter = p_entry_value_tbl.COUNT then

Line 2868: hr_utility.trace('| Entry value '||to_char(l_counter)||' is null.');

2864: exit when p_entry_value_tbl(l_counter) is not null;
2865: --
2866: if g_debug then
2867: hr_utility.set_location('derive_all_entry_values_null', 15);
2868: hr_utility.trace('| Entry value '||to_char(l_counter)||' is null.');
2869: end if;
2870: --
2871: if l_counter = p_entry_value_tbl.COUNT then
2872: --

Line 2878: hr_utility.set_location('derive_all_entry_values_null', 20);

2874: -- Therefore all the previous entry values must be
2875: -- null too (otherwise we would have exited the loop).
2876: --
2877: if g_debug then
2878: hr_utility.set_location('derive_all_entry_values_null', 20);
2879: hr_utility.trace('| All entry values are null');
2880: end if;
2881: --
2882: l_all_entry_values_null := 'Y';

Line 2879: hr_utility.trace('| All entry values are null');

2875: -- null too (otherwise we would have exited the loop).
2876: --
2877: if g_debug then
2878: hr_utility.set_location('derive_all_entry_values_null', 20);
2879: hr_utility.trace('| All entry values are null');
2880: end if;
2881: --
2882: l_all_entry_values_null := 'Y';
2883: --

Line 2895: hr_utility.set_location('derive_all_entry_values_null', 25);

2891: --
2892: -- There are no entry values for this element entry.
2893: --
2894: if g_debug then
2895: hr_utility.set_location('derive_all_entry_values_null', 25);
2896: hr_utility.trace('| No entry values exist');
2897: end if;
2898: --
2899: l_all_entry_values_null := null;

Line 2896: hr_utility.trace('| No entry values exist');

2892: -- There are no entry values for this element entry.
2893: --
2894: if g_debug then
2895: hr_utility.set_location('derive_all_entry_values_null', 25);
2896: hr_utility.trace('| No entry values exist');
2897: end if;
2898: --
2899: l_all_entry_values_null := null;
2900: --

Line 2904: hr_utility.set_location('Leaving: derive_all_entry_values_null', 900);

2900: --
2901: end if;
2902: --
2903: if g_debug then
2904: hr_utility.set_location('Leaving: derive_all_entry_values_null', 900);
2905: hr_utility.trace('| Returning l_all_entry_values_null: '||nvl(l_all_entry_values_null,'NULL'));
2906: end if;
2907: --
2908: return l_all_entry_values_null;

Line 2905: hr_utility.trace('| Returning l_all_entry_values_null: '||nvl(l_all_entry_values_null,'NULL'));

2901: end if;
2902: --
2903: if g_debug then
2904: hr_utility.set_location('Leaving: derive_all_entry_values_null', 900);
2905: hr_utility.trace('| Returning l_all_entry_values_null: '||nvl(l_all_entry_values_null,'NULL'));
2906: end if;
2907: --
2908: return l_all_entry_values_null;
2909: --

Line 3798: hr_utility.trace('| element entry DDFF defined');

3794: appl_short_name => 'PAY',
3795: flexfield_name => 'Element Entry Developer DF') then
3796:
3797: if g_debug then
3798: hr_utility.trace('| element entry DDFF defined');
3799: hr_utility.trace('| p_entry_information_category' ||
3800: p_entry_information_category || '<');
3801: end if;
3802:

Line 3799: hr_utility.trace('| p_entry_information_category' ||

3795: flexfield_name => 'Element Entry Developer DF') then
3796:
3797: if g_debug then
3798: hr_utility.trace('| element entry DDFF defined');
3799: hr_utility.trace('| p_entry_information_category' ||
3800: p_entry_information_category || '<');
3801: end if;
3802:
3803: --

Line 3814: hr_utility.trace('| element entry context in use, do validation');

3810: p_flexfield_name => 'Element Entry Developer DF',
3811: p_context_code => p_entry_information_category) then
3812:
3813: if g_debug then
3814: hr_utility.trace('| element entry context in use, do validation');
3815: end if;
3816:
3817: hr_entry_api.ddf_insert_validate(
3818: p_entry_information_category,

Line 4182: hr_utility.trace(' Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_insert');

4178: for new_vals in pay_ele_shd.csr_get_eevals(p_element_entry_id,l_effective_date) loop
4179: begin
4180: --
4181: if g_debug then
4182: hr_utility.trace(' Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_insert');
4183: hr_utility.trace(' Ele ent Val ID: '||new_vals.element_entry_value_id);
4184: hr_utility.trace(' New Screen Val: '||new_vals.screen_entry_value);
4185: end if;
4186:

Line 4183: hr_utility.trace(' Ele ent Val ID: '||new_vals.element_entry_value_id);

4179: begin
4180: --
4181: if g_debug then
4182: hr_utility.trace(' Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_insert');
4183: hr_utility.trace(' Ele ent Val ID: '||new_vals.element_entry_value_id);
4184: hr_utility.trace(' New Screen Val: '||new_vals.screen_entry_value);
4185: end if;
4186:
4187: -- Reason Insert has seemingly irregular parameters is that as

Line 4184: hr_utility.trace(' New Screen Val: '||new_vals.screen_entry_value);

4180: --
4181: if g_debug then
4182: hr_utility.trace(' Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_insert');
4183: hr_utility.trace(' Ele ent Val ID: '||new_vals.element_entry_value_id);
4184: hr_utility.trace(' New Screen Val: '||new_vals.screen_entry_value);
4185: end if;
4186:
4187: -- Reason Insert has seemingly irregular parameters is that as
4188: -- element entry values has no hook packages, the generator util of the called

Line 4310: g_debug := hr_utility.debug_enabled;

4306: v_input_value_id_tbl hr_entry.number_table;
4307: v_entry_value_tbl hr_entry.varchar2_table;
4308: --
4309: begin
4310: g_debug := hr_utility.debug_enabled;
4311:
4312: --
4313: -- Initialise variables
4314: --

Line 4526: g_debug := hr_utility.debug_enabled;

4522: v_input_value_id_tbl hr_entry.number_table;
4523: v_entry_value_tbl hr_entry.varchar2_table;
4524: --
4525: begin
4526: g_debug := hr_utility.debug_enabled;
4527: --
4528: -- Call code to set up values that may be used in
4529: -- Formula validation of Input Values.
4530: --

Line 4775: g_debug := hr_utility.debug_enabled;

4771: v_input_value_id_tbl hr_entry.number_table;
4772: v_entry_value_tbl hr_entry.varchar2_table;
4773: --
4774: begin
4775: g_debug := hr_utility.debug_enabled;
4776: --
4777: -- Initialise variables
4778: --
4779: g_override_user_ent_chk := p_override_user_ent_chk;

Line 5025: g_debug := hr_utility.debug_enabled;

5021: v_input_value_id_tbl hr_entry.number_table;
5022: v_entry_value_tbl hr_entry.varchar2_table;
5023: --
5024: begin
5025: g_debug := hr_utility.debug_enabled;
5026: --
5027: -- Call code to set up values that may be used in
5028: -- Formula validation of Input Values.
5029: --

Line 5197: hr_utility.trace('check_salary_admin_updates');

5193: procedure check_parameters is
5194: --
5195: begin
5196: --
5197: hr_utility.trace('check_salary_admin_updates');
5198: hr_api.mandatory_arg_error (
5199: p_api_name => l_proc,
5200: p_argument => 'p_dt_update_mode',
5201: p_argument_value=> p_dt_update_mode);

Line 5306: hr_utility.set_message (801,'HR_51182_SAL_DT_MODE');

5302: --
5303: -- The entry attributes for salary admin entries may be updated only
5304: -- in UPDATE_CHANGE_INSERT and CORRECTION datetrack modes.
5305: --
5306: hr_utility.set_message (801,'HR_51182_SAL_DT_MODE');
5307: hr_utility.raise_error;
5308: --
5309: when invalid_element_entry_id then
5310: --

Line 5307: hr_utility.raise_error;

5303: -- The entry attributes for salary admin entries may be updated only
5304: -- in UPDATE_CHANGE_INSERT and CORRECTION datetrack modes.
5305: --
5306: hr_utility.set_message (801,'HR_51182_SAL_DT_MODE');
5307: hr_utility.raise_error;
5308: --
5309: when invalid_element_entry_id then
5310: --
5311: -- The update is for a non-existent element entry

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

5309: when invalid_element_entry_id then
5310: --
5311: -- The update is for a non-existent element entry
5312: --
5313: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
5314: hr_utility.set_message_token ('PROCEDURE', l_proc);
5315: hr_utility.set_message_token ('STEP','1');
5316: hr_utility.raise_error;
5317: --

Line 5314: hr_utility.set_message_token ('PROCEDURE', l_proc);

5310: --
5311: -- The update is for a non-existent element entry
5312: --
5313: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
5314: hr_utility.set_message_token ('PROCEDURE', l_proc);
5315: hr_utility.set_message_token ('STEP','1');
5316: hr_utility.raise_error;
5317: --
5318: end check_salary_admin_updates;

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

5311: -- The update is for a non-existent element entry
5312: --
5313: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
5314: hr_utility.set_message_token ('PROCEDURE', l_proc);
5315: hr_utility.set_message_token ('STEP','1');
5316: hr_utility.raise_error;
5317: --
5318: end check_salary_admin_updates;
5319: ------------------------------------------------------------------------------

Line 5316: hr_utility.raise_error;

5312: --
5313: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
5314: hr_utility.set_message_token ('PROCEDURE', l_proc);
5315: hr_utility.set_message_token ('STEP','1');
5316: hr_utility.raise_error;
5317: --
5318: end check_salary_admin_updates;
5319: ------------------------------------------------------------------------------
5320: -- NAME --

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

5512: and p_session_date between et.effective_start_date
5513: and et.effective_end_date;
5514: exception
5515: when no_data_found then
5516: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
5517: hr_utility.set_message_token('PROCEDURE',
5518: 'hr_entry_api.upd_ele_entry_param_val');
5519: hr_utility.set_message_token('STEP','1');
5520: hr_utility.raise_error;

Line 5517: hr_utility.set_message_token('PROCEDURE',

5513: and et.effective_end_date;
5514: exception
5515: when no_data_found then
5516: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
5517: hr_utility.set_message_token('PROCEDURE',
5518: 'hr_entry_api.upd_ele_entry_param_val');
5519: hr_utility.set_message_token('STEP','1');
5520: hr_utility.raise_error;
5521: end;

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

5515: when no_data_found then
5516: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
5517: hr_utility.set_message_token('PROCEDURE',
5518: 'hr_entry_api.upd_ele_entry_param_val');
5519: hr_utility.set_message_token('STEP','1');
5520: hr_utility.raise_error;
5521: end;
5522: --
5523: -- If specified make sure cost allocation exists

Line 5520: hr_utility.raise_error;

5516: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
5517: hr_utility.set_message_token('PROCEDURE',
5518: 'hr_entry_api.upd_ele_entry_param_val');
5519: hr_utility.set_message_token('STEP','1');
5520: hr_utility.raise_error;
5521: end;
5522: --
5523: -- If specified make sure cost allocation exists
5524: --

Line 5914: g_debug := hr_utility.debug_enabled;

5910: --
5911:
5912: begin
5913: --
5914: g_debug := hr_utility.debug_enabled;
5915: --
5916: -- bug 666197, retrieve and store old values for the entry row
5917: --
5918: begin

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

5995: ,l_all_entry_values_null_o;
5996: close csr_old_entry_values;
5997: exception
5998: when no_data_found then
5999: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
6000: hr_utility.set_message_token('PROCEDURE','hr_entry_api.upd_element_entry');
6001: hr_utility.set_message_token('STEP','10');
6002: hr_utility.raise_error;
6003: end;

Line 6000: hr_utility.set_message_token('PROCEDURE','hr_entry_api.upd_element_entry');

5996: close csr_old_entry_values;
5997: exception
5998: when no_data_found then
5999: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
6000: hr_utility.set_message_token('PROCEDURE','hr_entry_api.upd_element_entry');
6001: hr_utility.set_message_token('STEP','10');
6002: hr_utility.raise_error;
6003: end;
6004: -- If the entry row is to be checked for a changed attribute then

Line 6001: hr_utility.set_message_token('STEP','10');

5997: exception
5998: when no_data_found then
5999: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
6000: hr_utility.set_message_token('PROCEDURE','hr_entry_api.upd_element_entry');
6001: hr_utility.set_message_token('STEP','10');
6002: hr_utility.raise_error;
6003: end;
6004: -- If the entry row is to be checked for a changed attribute then
6005: -- check to see if the entry row is being changed.

Line 6002: hr_utility.raise_error;

5998: when no_data_found then
5999: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
6000: hr_utility.set_message_token('PROCEDURE','hr_entry_api.upd_element_entry');
6001: hr_utility.set_message_token('STEP','10');
6002: hr_utility.raise_error;
6003: end;
6004: -- If the entry row is to be checked for a changed attribute then
6005: -- check to see if the entry row is being changed.
6006: --

Line 6240: hr_utility.trace('| element entry DDFF defined');

6236: appl_short_name => 'PAY',
6237: flexfield_name => 'Element Entry Developer DF') then
6238:
6239: if g_debug then
6240: hr_utility.trace('| element entry DDFF defined');
6241: hr_utility.trace('| p_entry_information_category' ||
6242: p_entry_information_category || '<');
6243: end if;
6244:

Line 6241: hr_utility.trace('| p_entry_information_category' ||

6237: flexfield_name => 'Element Entry Developer DF') then
6238:
6239: if g_debug then
6240: hr_utility.trace('| element entry DDFF defined');
6241: hr_utility.trace('| p_entry_information_category' ||
6242: p_entry_information_category || '<');
6243: end if;
6244:
6245: --

Line 6254: hr_utility.trace('| element entry context in use, do validation');

6250: p_flexfield_name => 'Element Entry Developer DF',
6251: p_context_code => p_entry_information_category) then
6252:
6253: if g_debug then
6254: hr_utility.trace('| element entry context in use, do validation');
6255: end if;
6256:
6257: hr_entry_api.ddf_update_validate(
6258: p_entry_information_category => p_entry_information_category

Line 6887: hr_utility.trace(' Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_update');

6883: begin
6884: g_counter := g_counter + 1;
6885: --
6886: if g_debug then
6887: hr_utility.trace(' Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_update');
6888: hr_utility.trace(' Ele ent Val ID: '||new_vals.element_entry_value_id);
6889: hr_utility.trace(' New Screen Val: '||new_vals.screen_entry_value);
6890: hr_utility.trace(' Old Screen Val: '||l_old_val_tab(g_counter).screen_entry_value);
6891: end if;

Line 6888: hr_utility.trace(' Ele ent Val ID: '||new_vals.element_entry_value_id);

6884: g_counter := g_counter + 1;
6885: --
6886: if g_debug then
6887: hr_utility.trace(' Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_update');
6888: hr_utility.trace(' Ele ent Val ID: '||new_vals.element_entry_value_id);
6889: hr_utility.trace(' New Screen Val: '||new_vals.screen_entry_value);
6890: hr_utility.trace(' Old Screen Val: '||l_old_val_tab(g_counter).screen_entry_value);
6891: end if;
6892:

Line 6889: hr_utility.trace(' New Screen Val: '||new_vals.screen_entry_value);

6885: --
6886: if g_debug then
6887: hr_utility.trace(' Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_update');
6888: hr_utility.trace(' Ele ent Val ID: '||new_vals.element_entry_value_id);
6889: hr_utility.trace(' New Screen Val: '||new_vals.screen_entry_value);
6890: hr_utility.trace(' Old Screen Val: '||l_old_val_tab(g_counter).screen_entry_value);
6891: end if;
6892:
6893: PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_update

Line 6890: hr_utility.trace(' Old Screen Val: '||l_old_val_tab(g_counter).screen_entry_value);

6886: if g_debug then
6887: hr_utility.trace(' Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_update');
6888: hr_utility.trace(' Ele ent Val ID: '||new_vals.element_entry_value_id);
6889: hr_utility.trace(' New Screen Val: '||new_vals.screen_entry_value);
6890: hr_utility.trace(' Old Screen Val: '||l_old_val_tab(g_counter).screen_entry_value);
6891: end if;
6892:
6893: PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_update
6894: (

Line 6920: hr_utility.set_location('Leaving: upd_element_entry', 900);

6916: end;
6917: --
6918: end loop;
6919: end if;
6920: hr_utility.set_location('Leaving: upd_element_entry', 900);
6921:
6922: end upd_element_entry;
6923: --
6924:

Line 7026: g_debug := hr_utility.debug_enabled;

7022: pee.effective_start_date and pee.effective_end_date
7023: ;
7024: --
7025: begin
7026: g_debug := hr_utility.debug_enabled;
7027: --
7028: g_override_user_ent_chk := p_override_user_ent_chk;
7029: v_num_entry_values := p_num_entry_values;
7030: v_input_value_id_tbl := p_input_value_id_tbl;

Line 7254: g_debug := hr_utility.debug_enabled;

7250: pee.effective_start_date and pee.effective_end_date
7251: ;
7252: --
7253: begin
7254: g_debug := hr_utility.debug_enabled;
7255: --
7256: OPEN csr_entry_type(p_element_entry_id, p_session_date);
7257: FETCH csr_entry_type INTO l_entry_type, v_assignment_id;
7258: CLOSE csr_entry_type;

Line 7518: g_debug := hr_utility.debug_enabled;

7514: pee.effective_start_date and pee.effective_end_date
7515: ;
7516: --
7517: begin
7518: g_debug := hr_utility.debug_enabled;
7519: --
7520: g_override_user_ent_chk := p_override_user_ent_chk;
7521: v_num_entry_values := p_num_entry_values;
7522: v_input_value_id_tbl := p_input_value_id_tbl;

Line 7778: g_debug := hr_utility.debug_enabled;

7774: pee.effective_start_date and pee.effective_end_date
7775: ;
7776: --
7777: begin
7778: g_debug := hr_utility.debug_enabled;
7779: --
7780: OPEN csr_entry_type(p_element_entry_id, p_session_date);
7781: FETCH csr_entry_type INTO l_entry_type, v_assignment_id;
7782: CLOSE csr_entry_type;

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

8002: and p_session_date between et.effective_start_date
8003: and et.effective_end_date;
8004: exception
8005: when no_data_found then
8006: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8007: hr_utility.set_message_token('PROCEDURE',
8008: 'hr_entry_api.delete_element_entry');
8009: hr_utility.set_message_token('STEP','1');
8010: hr_utility.raise_error;

Line 8007: hr_utility.set_message_token('PROCEDURE',

8003: and et.effective_end_date;
8004: exception
8005: when no_data_found then
8006: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8007: hr_utility.set_message_token('PROCEDURE',
8008: 'hr_entry_api.delete_element_entry');
8009: hr_utility.set_message_token('STEP','1');
8010: hr_utility.raise_error;
8011: when too_many_rows then

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

8005: when no_data_found then
8006: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8007: hr_utility.set_message_token('PROCEDURE',
8008: 'hr_entry_api.delete_element_entry');
8009: hr_utility.set_message_token('STEP','1');
8010: hr_utility.raise_error;
8011: when too_many_rows then
8012: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8013: hr_utility.set_message_token('PROCEDURE',

Line 8010: hr_utility.raise_error;

8006: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8007: hr_utility.set_message_token('PROCEDURE',
8008: 'hr_entry_api.delete_element_entry');
8009: hr_utility.set_message_token('STEP','1');
8010: hr_utility.raise_error;
8011: when too_many_rows then
8012: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8013: hr_utility.set_message_token('PROCEDURE',
8014: 'hr_entry_api.delete_element_entry');

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

8008: 'hr_entry_api.delete_element_entry');
8009: hr_utility.set_message_token('STEP','1');
8010: hr_utility.raise_error;
8011: when too_many_rows then
8012: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8013: hr_utility.set_message_token('PROCEDURE',
8014: 'hr_entry_api.delete_element_entry');
8015: hr_utility.set_message_token('STEP','2');
8016: hr_utility.raise_error;

Line 8013: hr_utility.set_message_token('PROCEDURE',

8009: hr_utility.set_message_token('STEP','1');
8010: hr_utility.raise_error;
8011: when too_many_rows then
8012: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8013: hr_utility.set_message_token('PROCEDURE',
8014: 'hr_entry_api.delete_element_entry');
8015: hr_utility.set_message_token('STEP','2');
8016: hr_utility.raise_error;
8017: end;

Line 8015: hr_utility.set_message_token('STEP','2');

8011: when too_many_rows then
8012: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8013: hr_utility.set_message_token('PROCEDURE',
8014: 'hr_entry_api.delete_element_entry');
8015: hr_utility.set_message_token('STEP','2');
8016: hr_utility.raise_error;
8017: end;
8018: --
8019: p_entry_rec := v_entry_rec;

Line 8016: hr_utility.raise_error;

8012: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8013: hr_utility.set_message_token('PROCEDURE',
8014: 'hr_entry_api.delete_element_entry');
8015: hr_utility.set_message_token('STEP','2');
8016: hr_utility.raise_error;
8017: end;
8018: --
8019: p_entry_rec := v_entry_rec;
8020: --

Line 8439: g_debug := hr_utility.debug_enabled;

8435: --
8436: end processed;
8437: --
8438: begin
8439: g_debug := hr_utility.debug_enabled;
8440: --
8441: if g_debug then
8442: hr_utility.set_location('hr_entry_api.delete_element_entry', 5);
8443: end if;

Line 8442: hr_utility.set_location('hr_entry_api.delete_element_entry', 5);

8438: begin
8439: g_debug := hr_utility.debug_enabled;
8440: --
8441: if g_debug then
8442: hr_utility.set_location('hr_entry_api.delete_element_entry', 5);
8443: end if;
8444: --
8445: -- bug 666197, retrieve and store old values for the entry row
8446: --

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

8493: ,l_all_entry_values_null_o;
8494: close csr_old_entry_values;
8495: exception
8496: when no_data_found then
8497: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8498: hr_utility.set_message_token('PROCEDURE','hr_entry_api.upd_element_entry');
8499: hr_utility.set_message_token('STEP','10');
8500: hr_utility.raise_error;
8501: end;

Line 8498: hr_utility.set_message_token('PROCEDURE','hr_entry_api.upd_element_entry');

8494: close csr_old_entry_values;
8495: exception
8496: when no_data_found then
8497: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8498: hr_utility.set_message_token('PROCEDURE','hr_entry_api.upd_element_entry');
8499: hr_utility.set_message_token('STEP','10');
8500: hr_utility.raise_error;
8501: end;
8502: --

Line 8499: hr_utility.set_message_token('STEP','10');

8495: exception
8496: when no_data_found then
8497: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8498: hr_utility.set_message_token('PROCEDURE','hr_entry_api.upd_element_entry');
8499: hr_utility.set_message_token('STEP','10');
8500: hr_utility.raise_error;
8501: end;
8502: --
8503: --

Line 8500: hr_utility.raise_error;

8496: when no_data_found then
8497: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
8498: hr_utility.set_message_token('PROCEDURE','hr_entry_api.upd_element_entry');
8499: hr_utility.set_message_token('STEP','10');
8500: hr_utility.raise_error;
8501: end;
8502: --
8503: --
8504: -- Validate the parameter and return element entry details.

Line 8521: hr_utility.set_location('hr_entry_api.delete_element_entry', 15);

8517: --
8518: if v_dt_delete_mode = 'DELETE_NEXT_CHANGE' then
8519: --
8520: if g_debug then
8521: hr_utility.set_location('hr_entry_api.delete_element_entry', 15);
8522: end if;
8523: --
8524: begin
8525: select min(ee.effective_end_date)

Line 8560: hr_utility.set_location('hr_entry_api.delete_element_entry', 18);

8556: -- for purge. We check this here because the v_dt_delete_mode
8557: -- can be changed by the previous call.
8558: --
8559: if g_debug then
8560: hr_utility.set_location('hr_entry_api.delete_element_entry', 18);
8561: end if;
8562: -- Start by reading the value.
8563: fnd_profile.get('HR_ELE_ENTRY_PURGE_CONTROL', l_prof_value);
8564: --

Line 8572: hr_utility.set_message (800,'HR_33000_ENTRY_CANT_PURGE');

8568: (l_prof_value = 'N' or
8569: (l_prof_value = 'I' and v_entry_rec.non_payments_flag = 'N'))
8570: then
8571: -- We need to raise error that are attempting to purge.
8572: hr_utility.set_message (800,'HR_33000_ENTRY_CANT_PURGE');
8573: hr_utility.raise_error;
8574: end if;
8575: --
8576: -- Choose the extend of the entry to supply

Line 8573: hr_utility.raise_error;

8569: (l_prof_value = 'I' and v_entry_rec.non_payments_flag = 'N'))
8570: then
8571: -- We need to raise error that are attempting to purge.
8572: hr_utility.set_message (800,'HR_33000_ENTRY_CANT_PURGE');
8573: hr_utility.raise_error;
8574: end if;
8575: --
8576: -- Choose the extend of the entry to supply
8577: -- the validation start and end dates.

Line 8591: hr_utility.set_location('hr_entry_api.delete_element_entry', 20);

8587: --
8588: end if;
8589: --
8590: if g_debug then
8591: hr_utility.set_location('hr_entry_api.delete_element_entry', 20);
8592: end if;
8593: --
8594: -- Make sure the delete is valid.
8595: --

Line 8607: hr_utility.set_message (801,'HR_7798_ENTRY_PPM_RUN_RESULT');

8603: v_validation_start_date,
8604: v_entry_rec.assignment_id)
8605: --
8606: then
8607: hr_utility.set_message (801,'HR_7798_ENTRY_PPM_RUN_RESULT');
8608: hr_utility.raise_error;
8609: --
8610: end if;
8611: --

Line 8608: hr_utility.raise_error;

8604: v_entry_rec.assignment_id)
8605: --
8606: then
8607: hr_utility.set_message (801,'HR_7798_ENTRY_PPM_RUN_RESULT');
8608: hr_utility.raise_error;
8609: --
8610: end if;
8611: --
8612: hr_entry.chk_element_entry_main

Line 8638: hr_utility.set_location('hr_entry_api.delete_element_entry', 25);

8634: open csr_accepted_pay_proposals(p_element_entry_id,
8635: v_entry_rec.assignment_id);
8636: --
8637: if g_debug then
8638: hr_utility.set_location('hr_entry_api.delete_element_entry', 25);
8639: end if;
8640: --
8641: -- Trigger workload shifting if change to element entry overlaps with the
8642: -- latest payroll run for the assignment and workload shifting is enabled.

Line 8659: hr_utility.set_location('hr_entry_api.delete_element_entry', 30);

8655: --
8656: if v_dt_delete_mode = 'DELETE' or p_dt_delete_mode = 'ZAP' then
8657: --
8658: if g_debug then
8659: hr_utility.set_location('hr_entry_api.delete_element_entry', 30);
8660: end if;
8661: --
8662: -- Enhancement 3368211
8663: --

Line 8699: hr_utility.set_location('hr_entry_api.delete_element_entry', 40);

8695: --
8696: if v_dt_delete_mode = 'DELETE_NEXT_CHANGE' then
8697: --
8698: if g_debug then
8699: hr_utility.set_location('hr_entry_api.delete_element_entry', 40);
8700: end if;
8701: --
8702: delete from pay_element_entries_f ee
8703: where ee.element_entry_id = p_element_entry_id

Line 8720: hr_utility.set_location('hr_entry_api.delete_element_entry', 45);

8716: --
8717: elsif v_dt_delete_mode = 'FUTURE_CHANGE' then
8718: --
8719: if g_debug then
8720: hr_utility.set_location('hr_entry_api.delete_element_entry', 45);
8721: end if;
8722: --
8723: delete from pay_element_entries_f ee
8724: where ee.element_entry_id = p_element_entry_id

Line 8738: hr_utility.set_location('hr_entry_api.delete_element_entry', 50);

8734: --
8735: elsif v_dt_delete_mode = 'DELETE' then
8736: --
8737: if g_debug then
8738: hr_utility.set_location('hr_entry_api.delete_element_entry', 50);
8739: end if;
8740: --
8741: delete from pay_element_entries_f ee
8742: where ee.element_entry_id = p_element_entry_id

Line 8756: hr_utility.set_location('hr_entry_api.delete_element_entry', 55);

8752: --
8753: elsif v_dt_delete_mode = 'ZAP' then
8754: --
8755: if g_debug then
8756: hr_utility.set_location('hr_entry_api.delete_element_entry', 55);
8757: end if;
8758: --
8759: -- For Zap mode, delete any balance exclusions rows for the entry
8760: --

Line 8771: hr_utility.set_location('hr_entry_api.delete_element_entry', 60);

8767: --
8768: end if;
8769: --
8770: if g_debug then
8771: hr_utility.set_location('hr_entry_api.delete_element_entry', 60);
8772: end if;
8773: --
8774: -- Delete element entry values
8775: --

Line 8791: hr_utility.set_location('hr_entry_api.delete_element_entry', 65);

8787: v_validation_start_date,
8788: v_validation_end_date);
8789: --
8790: if g_debug then
8791: hr_utility.set_location('hr_entry_api.delete_element_entry', 65);
8792: end if;
8793: --
8794: -- Go through list of accepted pay proposals for the assignment /
8795: -- element entry to see if any of the pay proosals have lost the element

Line 8824: hr_utility.set_location('hr_entry_api.delete_element_entry', 67);

8820: --v_dt_delete_mode in ('DELETE_NEXT_CHANGE','FUTURE_CHANGE') then
8821: v_dt_delete_mode in ('DELETE_NEXT_CHANGE','FUTURE_CHANGE','DELETE') then
8822: --
8823: if g_debug then
8824: hr_utility.set_location('hr_entry_api.delete_element_entry', 67);
8825: end if;
8826: --
8827: -- We do not wish to continue processing
8828: --

Line 8952: hr_utility.set_location('hr_entry_api.delete_element_entry', 70);

8948: end;
8949: --
8950: --
8951: if g_debug then
8952: hr_utility.set_location('hr_entry_api.delete_element_entry', 70);
8953: end if;
8954: --
8955:
8956: --

Line 8968: hr_utility.trace(' NO Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_delete');

8964: -- 2) Now make a call to PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_delete
8965: -- -use current values if end dated or nulls if row has been blown away
8966: --
8967: if g_debug then
8968: hr_utility.trace(' NO Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_delete');
8969: hr_utility.set_location('Leaving: delete_element_entry', 900);
8970: end if;
8971:
8972: end delete_element_entry;

Line 8969: hr_utility.set_location('Leaving: delete_element_entry', 900);

8965: -- -use current values if end dated or nulls if row has been blown away
8966: --
8967: if g_debug then
8968: hr_utility.trace(' NO Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_delete');
8969: hr_utility.set_location('Leaving: delete_element_entry', 900);
8970: end if;
8971:
8972: end delete_element_entry;
8973: --