eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_USER_INIT_EARN dependencies on HR_UTILITY

Line 352: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',1);

348: l_template_name VARCHAR2(80);
349:
350: BEGIN
351: --
352: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',1);
353: --
354: if p_calc_rule_code = 'FLT' then
355: l_template_name := 'Flat Amount Earning';
356: --l_template_name := 'Test Flat Amount Earnings';

Line 365: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',2);

361: l_template_name := 'Percent of Earnings Earning';
362: elsif p_calc_rule_code = 'NTG FLT' then
363: l_template_name := 'Net To Gross Earning';
364: else
365: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',2);
366: hr_utility.set_message(801,'HR_XXXXX_INVALID_CALC_RULE_EARN');
367: hr_utility.raise_error;
368: end if;
369: --

Line 366: hr_utility.set_message(801,'HR_XXXXX_INVALID_CALC_RULE_EARN');

362: elsif p_calc_rule_code = 'NTG FLT' then
363: l_template_name := 'Net To Gross Earning';
364: else
365: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',2);
366: hr_utility.set_message(801,'HR_XXXXX_INVALID_CALC_RULE_EARN');
367: hr_utility.raise_error;
368: end if;
369: --
370: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',3);

Line 367: hr_utility.raise_error;

363: l_template_name := 'Net To Gross Earning';
364: else
365: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',2);
366: hr_utility.set_message(801,'HR_XXXXX_INVALID_CALC_RULE_EARN');
367: hr_utility.raise_error;
368: end if;
369: --
370: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',3);
371: hr_utility.trace('Template Name is :'||l_template_name||'****'||

Line 370: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',3);

366: hr_utility.set_message(801,'HR_XXXXX_INVALID_CALC_RULE_EARN');
367: hr_utility.raise_error;
368: end if;
369: --
370: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',3);
371: hr_utility.trace('Template Name is :'||l_template_name||'****'||
372: 'Legislation is :'||p_legislation_code);
373: --
374: select template_id

Line 371: hr_utility.trace('Template Name is :'||l_template_name||'****'||

367: hr_utility.raise_error;
368: end if;
369: --
370: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',3);
371: hr_utility.trace('Template Name is :'||l_template_name||'****'||
372: 'Legislation is :'||p_legislation_code);
373: --
374: select template_id
375: into l_template_id

Line 382: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',4);

378: and legislation_code = p_legislation_code
379: and business_group_id is NULL
380: and template_type = 'T';
381: --
382: hr_utility.set_location('pay_ca_user_init_earn.get_template_id',4);
383: --
384: RETURN l_template_id;
385: --
386: END get_template_id;

Line 399: hr_utility.set_location('pay_ca_user_init_earn.chk_ca_pay_installed',1);

395: l_installed VARCHAR2(1) := 'N';
396:
397: BEGIN
398: --
399: hr_utility.set_location('pay_ca_user_init_earn.chk_ca_pay_installed',1);
400: --
401: BEGIN
402: select 'Y'
403: into l_installed

Line 413: hr_utility.set_location('pay_ca_user_init_earn.chk_ca_pay_installed',2);

409: l_installed := 'N';
410:
411: END;
412: --
413: hr_utility.set_location('pay_ca_user_init_earn.chk_ca_pay_installed',2);
414: --
415: RETURN (l_installed);
416: --
417: END chk_ca_pay_installed;

Line 428: --hr_utility.trace_on('y','ORACLE');

424:
425: BEGIN
426: --
427: --
428: --hr_utility.trace_on('y','ORACLE');
429:
430: --
431: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',1);
432: --

Line 431: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',1);

427: --
428: --hr_utility.trace_on('y','ORACLE');
429:
430: --
431: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',1);
432: --
433: -- Set session date
434: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
435: --

Line 439: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',2);

435: --
436: g_eff_start_date := NVL(p_ele_eff_start_date, sysdate);
437: g_eff_end_date := NVL(p_ele_eff_end_date, c_end_of_time);
438: --
439: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',2);
440: --
441: ---------------------------- Check Element Name ---------------------------
442: --
443: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',25);

Line 443: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',25);

439: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',2);
440: --
441: ---------------------------- Check Element Name ---------------------------
442: --
443: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',25);
444: --
445: BEGIN
446: select 'Y'
447: into l_reserved

Line 459: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',26);

455:
456: END;
457: --
458: if l_reserved = 'Y' then
459: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',26);
460: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
461: hr_utility.raise_error;
462: end if;
463: --

Line 460: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');

456: END;
457: --
458: if l_reserved = 'Y' then
459: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',26);
460: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
461: hr_utility.raise_error;
462: end if;
463: --
464: ---------------------------- Get Source Template ID -----------------------

Line 461: hr_utility.raise_error;

457: --
458: if l_reserved = 'Y' then
459: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',26);
460: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
461: hr_utility.raise_error;
462: end if;
463: --
464: ---------------------------- Get Source Template ID -----------------------
465: --

Line 466: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',3);

462: end if;
463: --
464: ---------------------------- Get Source Template ID -----------------------
465: --
466: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',3);
467: --
468: l_source_template_id := get_template_id(
469: p_legislation_code => g_template_leg_code,
470: p_calc_rule_code => p_ele_calc_rule_code);

Line 474: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',4);

470: p_calc_rule_code => p_ele_calc_rule_code);
471: --
472: --------------------- Set Separate Check Creation -------------------------
473: --
474: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',4);
475: --
476: if p_ele_classification = 'Supplemental Earnings' then
477: l_sep_check_create := 'Y';
478: l_skip_formula := 'SUPP_EARNINGS_SKIP';

Line 486: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',5);

482: end if;
483: --
484: ---------------------------- Create User Structure ------------------------
485: --
486: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',5);
487: --
488: -- The Configuration Flex segments are as follows:
489: -- Config 1 - exclusion rule - create Separate Check input value if 'Y'
490: -- Config 2 - input value default - update default value for Sep Check IV

Line 522: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',6);

518: ,p_object_version_number => l_object_version_number);
519: --
520: ---------------------- Get Element Type ID of new Template -----------------
521: --
522: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',6);
523: --
524: select element_type_id, object_version_number
525: into l_element_type_id, l_ele_obj_ver_number
526: from pay_shadow_element_types

Line 551: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',7);

547: end if;
548: --
549: ---------------------------- Update Shadow Structure ----------------------
550: --
551: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',7);
552: --
553: SELECT
554: DECODE(p_ele_classification,'Earnings','DE',
555: 'Supplemental Earnings','DE','Taxable Benefits','DE','')

Line 605: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',8);

601: --
602: -- Update user-specified Classification on Special Features Element.
603: -- Only for Non NTG elements.
604: --
605: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',8);
606: --
607: if p_ele_calc_rule_code <> 'NTG FLT' then
608: pay_shadow_element_api.update_shadow_element
609: (p_validate => false

Line 625: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',9);

621: --
622: -- Update user-specified Classification Special Inputs if it exists.
623: -- Only for Non NTG elements.
624: --
625: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',9);
626: --
627: if (p_ele_processing_type = 'R') and (p_ele_calc_rule_code <> 'NTG FLT') then
628: pay_shadow_element_api.update_shadow_element
629: (p_validate => false

Line 640: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',10);

636: end if;
637: --
638: ---------------------------- Generate Core Objects ------------------------
639: --
640: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',10);
641: --
642: if chk_ca_pay_installed = 'Y' then
643: l_hr_only := FALSE;
644: else

Line 648: hr_utility.trace('HR ONLY is :'||chk_ca_pay_installed);

644: else
645: l_hr_only := TRUE;
646: end if;
647: --
648: hr_utility.trace('HR ONLY is :'||chk_ca_pay_installed);
649: --
650: pay_element_template_api.generate_part1
651: (p_validate => false
652: ,p_effective_date => p_ele_eff_start_date

Line 657: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',11);

653: ,p_hr_only => l_hr_only
654: ,p_hr_to_payroll => false
655: ,p_template_id => l_template_id);
656: --
657: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',11);
658: --
659: if l_hr_only = FALSE then
660: pay_element_template_api.generate_part2
661: (p_validate => false

Line 665: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',12);

661: (p_validate => false
662: ,p_effective_date => p_ele_eff_start_date
663: ,p_template_id => l_template_id);
664: --
665: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',12);
666: --
667: end if;
668: --
669: -------------------- Get Element Type ID of Base Element ------------------

Line 671: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',13);

667: end if;
668: --
669: -------------------- Get Element Type ID of Base Element ------------------
670: --
671: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',13);
672: --
673: select element_type_id
674: into l_base_element_type_id
675: from pay_element_types_f

Line 689: hr_utility.trace('Processing rule: '||p_ele_name|| ' does not exist');

685: fetch cur_processing_rule_exists INTO lv_proc_rule_id;
686: if cur_processing_rule_exists%found then
687: close cur_processing_rule_exists;
688: else
689: hr_utility.trace('Processing rule: '||p_ele_name|| ' does not exist');
690: end if;
691:
692: open cur_element_type_id(lv_element_name);
693: fetch cur_element_type_id into lv_element_type_id;

Line 702: hr_utility.trace(to_char(lv_element_type_id)||' '||to_char(lv_input_value_id));

698: open cur_input_id(lv_element_name, lv_input_value_name);
699: fetch cur_input_id into lv_input_value_id;
700: close cur_input_id;
701:
702: hr_utility.trace(to_char(lv_element_type_id)||' '||to_char(lv_input_value_id));
703:
704: lv_formula_result_rule_id :=
705: pay_formula_results.ins_form_res_rule(
706: p_business_group_id => p_bg_id,

Line 720: hr_utility.trace('Creating Result Rule: '|| lv_result_name);

716: p_result_rule_type => 'I',
717: p_severity_level => NULL,
718: p_element_type_id => lv_element_type_id);
719:
720: hr_utility.trace('Creating Result Rule: '|| lv_result_name);
721:
722: lv_input_value_name := 'Hours';
723: lv_result_name := 'HOURS_PASSED';
724: open cur_input_id(lv_element_name, lv_input_value_name);

Line 744: hr_utility.trace('Creating Result Rule: '|| lv_result_name);

740: p_result_rule_type => 'I',
741: p_severity_level => NULL,
742: p_element_type_id => lv_element_type_id);
743:
744: hr_utility.trace('Creating Result Rule: '|| lv_result_name);
745:
746: lv_input_value_name := 'Rate';
747: lv_result_name := 'RATE_PASSED';
748: open cur_input_id(lv_element_name, lv_input_value_name);

Line 768: hr_utility.trace('Creating Result Rule: '|| lv_result_name);

764: p_result_rule_type => 'I',
765: p_severity_level => NULL,
766: p_element_type_id => lv_element_type_id);
767:
768: hr_utility.trace('Creating Result Rule: '|| lv_result_name);
769:
770: lv_input_value_name := 'Multiple';
771: lv_result_name := 'MULTIPLE_PASSED';
772: open cur_input_id(lv_element_name, lv_input_value_name);

Line 814: hr_utility.trace('Creating Result Rule: '|| lv_result_name);

810: p_result_rule_type => 'I',
811: p_severity_level => NULL,
812: p_element_type_id => lv_element_type_id);
813:
814: hr_utility.trace('Creating Result Rule: '|| lv_result_name);
815:
816: end if;
817: --
818: ------------------ Get Balance Type IDs to update Flex Info ---------------

Line 820: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',14);

816: end if;
817: --
818: ------------------ Get Balance Type IDs to update Flex Info ---------------
819: --
820: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',14);
821: --
822: BEGIN
823: select ptco.core_object_id
824: into l_pri_bal_id

Line 848: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',15);

844: NULL;
845: END IF;
846: END;
847: --
848: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',15);
849: --
850: BEGIN
851: select ptco.core_object_id
852: into l_hrs_bal_id

Line 860: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',16);

856: and psbt.balance_name = p_ele_name||' Hours'
857: and ptco.template_id = psbt.template_id
858: and ptco.shadow_object_id = psbt.balance_type_id;
859: --
860: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',16);
861: --
862: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
863: END;
864: --

Line 865: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',17);

861: --
862: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
863: END;
864: --
865: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',17);
866: --
867: if (p_sep_check_option = 'N' and p_ele_calc_rule_code <> 'NTG FLT') then
868: update pay_element_types_f
869: set element_information10 = l_pri_bal_id,

Line 984: --hr_utility.trace_on(null,'ELEMENT');

980: -- Creating element type usages for exclusion
981: --
982:
983: begin
984: --hr_utility.trace_on(null,'ELEMENT');
985: for etu in c_ele_tp_usg(p_bg_id, p_ele_name)
986: loop
987:
988: hr_utility.trace('etu.element_name : '||etu.element_name);

Line 988: hr_utility.trace('etu.element_name : '||etu.element_name);

984: --hr_utility.trace_on(null,'ELEMENT');
985: for etu in c_ele_tp_usg(p_bg_id, p_ele_name)
986: loop
987:
988: hr_utility.trace('etu.element_name : '||etu.element_name);
989: hr_utility.trace('p_ele_name : '||p_ele_name);
990: hr_utility.trace('etu.element_information2 : '||etu.element_information2);
991: hr_utility.trace('etu.element_information4 : '||etu.element_information4);
992:

Line 989: hr_utility.trace('p_ele_name : '||p_ele_name);

985: for etu in c_ele_tp_usg(p_bg_id, p_ele_name)
986: loop
987:
988: hr_utility.trace('etu.element_name : '||etu.element_name);
989: hr_utility.trace('p_ele_name : '||p_ele_name);
990: hr_utility.trace('etu.element_information2 : '||etu.element_information2);
991: hr_utility.trace('etu.element_information4 : '||etu.element_information4);
992:
993: if etu.element_name = p_ele_name then

Line 990: hr_utility.trace('etu.element_information2 : '||etu.element_information2);

986: loop
987:
988: hr_utility.trace('etu.element_name : '||etu.element_name);
989: hr_utility.trace('p_ele_name : '||p_ele_name);
990: hr_utility.trace('etu.element_information2 : '||etu.element_information2);
991: hr_utility.trace('etu.element_information4 : '||etu.element_information4);
992:
993: if etu.element_name = p_ele_name then
994:

Line 991: hr_utility.trace('etu.element_information4 : '||etu.element_information4);

987:
988: hr_utility.trace('etu.element_name : '||etu.element_name);
989: hr_utility.trace('p_ele_name : '||p_ele_name);
990: hr_utility.trace('etu.element_information2 : '||etu.element_information2);
991: hr_utility.trace('etu.element_information4 : '||etu.element_information4);
992:
993: if etu.element_name = p_ele_name then
994:
995: if p_ele_classification = 'Non-payroll Payments' then

Line 1014: hr_utility.trace('ln_run_type_id : '||ln_run_type_id);

1010: from dual;
1011: end if;
1012:
1013: end if;
1014: hr_utility.trace('ln_run_type_id : '||ln_run_type_id);
1015:
1016: for prt in c_run_tp
1017: loop
1018:

Line 1054: hr_utility.trace('1 element type id is '||to_char(l_element_type_id));

1050: begin
1051: /* Bugfix : 2851568. Feed Taxable Benefits for Quebec for all Taxable
1052: Benefits Element with Category PHSP */
1053:
1054: hr_utility.trace('1 element type id is '||to_char(l_element_type_id));
1055:
1056: select element_type_id
1057: into l_element_type_id
1058: from pay_element_types_f

Line 1067: hr_utility.trace('2');

1063: open cur_input_id2(l_base_element_type_id, lv_input_value_name);
1064: fetch cur_input_id2 into l_pay_value_iv_id;
1065: close cur_input_id2;
1066:
1067: hr_utility.trace('2');
1068: -- if p_ele_category = 'Private Health Services Plan' then
1069: if p_ele_category = 'PHSP' then
1070: hr_utility.trace('3 input value id ' || to_char(l_pay_value_iv_id));
1071:

Line 1070: hr_utility.trace('3 input value id ' || to_char(l_pay_value_iv_id));

1066:
1067: hr_utility.trace('2');
1068: -- if p_ele_category = 'Private Health Services Plan' then
1069: if p_ele_category = 'PHSP' then
1070: hr_utility.trace('3 input value id ' || to_char(l_pay_value_iv_id));
1071:
1072:
1073: select balance_type_id
1074: into l_balance_type_id

Line 1089: hr_utility.trace('4 input value id ' || to_char(l_balance_feed_id));

1085: l_pay_value_iv_id,
1086: '1',
1087: NULL);
1088:
1089: hr_utility.trace('4 input value id ' || to_char(l_balance_feed_id));
1090: end if;
1091: exception
1092: when others then
1093: hr_utility.trace('5');

Line 1093: hr_utility.trace('5');

1089: hr_utility.trace('4 input value id ' || to_char(l_balance_feed_id));
1090: end if;
1091: exception
1092: when others then
1093: hr_utility.trace('5');
1094: null;
1095: end;
1096: hr_utility.trace_off;
1097: --

Line 1096: hr_utility.trace_off;

1092: when others then
1093: hr_utility.trace('5');
1094: null;
1095: end;
1096: hr_utility.trace_off;
1097: --
1098: --
1099:
1100: ------------------ Conclude Create_User_Init_Earning Main -----------------

Line 1102: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',18);

1098: --
1099:
1100: ------------------ Conclude Create_User_Init_Earning Main -----------------
1101: --
1102: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',18);
1103: --
1104: RETURN l_base_element_type_id;
1105: --
1106: END create_user_init_earning;

Line 1134: hr_utility.set_location('pay_ca_user_init_earn.delete_user_init_earning',1);

1130: l_del_val_end := nvl(p_del_val_end_date, c_end_of_time);
1131: l_del_val_start := nvl(p_del_val_start_date, sysdate);
1132: l_del_sess_date := nvl(p_del_sess_date, sysdate);
1133: --
1134: hr_utility.set_location('pay_ca_user_init_earn.delete_user_init_earning',1);
1135: --
1136: select template_id
1137: into l_template_id
1138: from pay_element_templates

Line 1143: hr_utility.set_location('pay_ca_user_init_earn.delete_user_init_earning',2);

1139: where base_name = p_ele_name
1140: and business_group_id = p_business_group_id
1141: and template_type = 'U';
1142: --
1143: hr_utility.set_location('pay_ca_user_init_earn.delete_user_init_earning',2);
1144: --
1145: begin
1146: delete from pay_element_type_usages_f
1147: where element_type_id in ( select element_type_id

Line 1154: hr_utility.set_location('pay_ca_user_init_earn.delete_user_init_earning',3);

1150: element_name =
1151: p_ele_name ||' Special Inputs' )
1152: and business_group_id = p_business_group_id );
1153: --
1154: hr_utility.set_location('pay_ca_user_init_earn.delete_user_init_earning',3);
1155: --
1156: exception
1157: when others then
1158: null;

Line 1166: hr_utility.set_location('pay_ca_user_init_earn.delete_user_init_earning',4);

1162: (p_validate => false
1163: ,p_drop_formula_packages => true
1164: ,p_template_id => l_template_id);
1165: --
1166: hr_utility.set_location('pay_ca_user_init_earn.delete_user_init_earning',4);
1167: --
1168: END delete_user_init_earning;
1169: ------------------------------------------------------------------------
1170: -- PROCEDURE UPDATE_JD_LEVEL_ON_BALANCE

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

1243: --
1244: OPEN c_iter_formula_id;
1245: FETCH c_iter_formula_id into l_iter_formula_id;
1246: IF c_iter_formula_id%NOTFOUND then
1247: hr_utility.set_location(l_proc,10);
1248: hr_utility.set_message(800,'ITERATIVE FORMULA NOT FOUND');
1249: hr_utility.raise_error;
1250: END IF;
1251: CLOSE c_iter_formula_id;

Line 1248: hr_utility.set_message(800,'ITERATIVE FORMULA NOT FOUND');

1244: OPEN c_iter_formula_id;
1245: FETCH c_iter_formula_id into l_iter_formula_id;
1246: IF c_iter_formula_id%NOTFOUND then
1247: hr_utility.set_location(l_proc,10);
1248: hr_utility.set_message(800,'ITERATIVE FORMULA NOT FOUND');
1249: hr_utility.raise_error;
1250: END IF;
1251: CLOSE c_iter_formula_id;
1252: -------------------------

Line 1249: hr_utility.raise_error;

1245: FETCH c_iter_formula_id into l_iter_formula_id;
1246: IF c_iter_formula_id%NOTFOUND then
1247: hr_utility.set_location(l_proc,10);
1248: hr_utility.set_message(800,'ITERATIVE FORMULA NOT FOUND');
1249: hr_utility.raise_error;
1250: END IF;
1251: CLOSE c_iter_formula_id;
1252: -------------------------
1253: -- Set iterative formula.

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

1258: grossup_flag = 'Y'
1259: WHERE element_type_id = p_base_element_type_id
1260: AND business_group_id + 0 = p_bg_id;
1261: --
1262: hr_utility.set_location(l_proc,20);
1263: --
1264: ---------------------------------
1265: -- Set iterative processing rules
1266: ---------------------------------

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

1296: l_iv_id := NULL;
1297: l_insert := 'Y';
1298: END IF;
1299: IF l_insert = 'Y' THEN
1300: hr_utility.set_location(l_proc,30);
1301: pay_iterative_rules_api.create_iterative_rule
1302: (
1303: p_effective_date => p_ele_eff_start_date
1304: ,p_element_type_id => p_base_element_type_id

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

1321: -- FED_GROSSUP_ADJUSTMENT input value of Amount.
1322: -- Thus need to get the element_type_id of the seeded element
1323: -- and input_value_id of the Amount from the seeded element.
1324: ------------------------------------------------------------------
1325: hr_utility.set_location(l_proc,40);
1326: --
1327: OPEN c_seeded_elmt_id;
1328: FETCH c_seeded_elmt_id into l_seeded_ele_type_id;
1329: IF c_seeded_elmt_id%NOTFOUND then

Line 1330: hr_utility.set_location(l_proc,45);

1326: --
1327: OPEN c_seeded_elmt_id;
1328: FETCH c_seeded_elmt_id into l_seeded_ele_type_id;
1329: IF c_seeded_elmt_id%NOTFOUND then
1330: hr_utility.set_location(l_proc,45);
1331: hr_utility.set_message(800,'FED_GROSSUP_ADJUSTMENT NOT FOUND');
1332: hr_utility.raise_error;
1333: END IF;
1334: CLOSE c_seeded_elmt_id;

Line 1331: hr_utility.set_message(800,'FED_GROSSUP_ADJUSTMENT NOT FOUND');

1327: OPEN c_seeded_elmt_id;
1328: FETCH c_seeded_elmt_id into l_seeded_ele_type_id;
1329: IF c_seeded_elmt_id%NOTFOUND then
1330: hr_utility.set_location(l_proc,45);
1331: hr_utility.set_message(800,'FED_GROSSUP_ADJUSTMENT NOT FOUND');
1332: hr_utility.raise_error;
1333: END IF;
1334: CLOSE c_seeded_elmt_id;
1335: --

Line 1332: hr_utility.raise_error;

1328: FETCH c_seeded_elmt_id into l_seeded_ele_type_id;
1329: IF c_seeded_elmt_id%NOTFOUND then
1330: hr_utility.set_location(l_proc,45);
1331: hr_utility.set_message(800,'FED_GROSSUP_ADJUSTMENT NOT FOUND');
1332: hr_utility.raise_error;
1333: END IF;
1334: CLOSE c_seeded_elmt_id;
1335: --
1336: hr_utility.set_location(l_proc,41);

Line 1336: hr_utility.set_location(l_proc,41);

1332: hr_utility.raise_error;
1333: END IF;
1334: CLOSE c_seeded_elmt_id;
1335: --
1336: hr_utility.set_location(l_proc,41);
1337: --
1338: OPEN c_seeded_elmt_iv_id(l_seeded_ele_type_id);
1339: FETCH c_seeded_elmt_iv_id into l_seeded_input_val_id;
1340: IF c_seeded_elmt_iv_id%NOTFOUND then

Line 1341: hr_utility.set_location(l_proc,47);

1337: --
1338: OPEN c_seeded_elmt_iv_id(l_seeded_ele_type_id);
1339: FETCH c_seeded_elmt_iv_id into l_seeded_input_val_id;
1340: IF c_seeded_elmt_iv_id%NOTFOUND then
1341: hr_utility.set_location(l_proc,47);
1342: hr_utility.set_message(800,'INPUT VALUE NOT FOUND');
1343: hr_utility.raise_error;
1344: END IF;
1345: CLOSE c_seeded_elmt_iv_id;

Line 1342: hr_utility.set_message(800,'INPUT VALUE NOT FOUND');

1338: OPEN c_seeded_elmt_iv_id(l_seeded_ele_type_id);
1339: FETCH c_seeded_elmt_iv_id into l_seeded_input_val_id;
1340: IF c_seeded_elmt_iv_id%NOTFOUND then
1341: hr_utility.set_location(l_proc,47);
1342: hr_utility.set_message(800,'INPUT VALUE NOT FOUND');
1343: hr_utility.raise_error;
1344: END IF;
1345: CLOSE c_seeded_elmt_iv_id;
1346: --

Line 1343: hr_utility.raise_error;

1339: FETCH c_seeded_elmt_iv_id into l_seeded_input_val_id;
1340: IF c_seeded_elmt_iv_id%NOTFOUND then
1341: hr_utility.set_location(l_proc,47);
1342: hr_utility.set_message(800,'INPUT VALUE NOT FOUND');
1343: hr_utility.raise_error;
1344: END IF;
1345: CLOSE c_seeded_elmt_iv_id;
1346: --
1347: hr_utility.set_location(l_proc,42);

Line 1347: hr_utility.set_location(l_proc,42);

1343: hr_utility.raise_error;
1344: END IF;
1345: CLOSE c_seeded_elmt_iv_id;
1346: --
1347: hr_utility.set_location(l_proc,42);
1348: --
1349: SELECT pay_formula_result_rules_s.nextval
1350: INTO l_nextval
1351: FROM dual;

Line 1353: hr_utility.set_location(l_proc,43);

1349: SELECT pay_formula_result_rules_s.nextval
1350: INTO l_nextval
1351: FROM dual;
1352: --
1353: hr_utility.set_location(l_proc,43);
1354: --
1355: OPEN c_base_elmt_spr_id;
1356: FETCH c_base_elmt_spr_id into l_status_pro_rule_id;
1357: IF c_base_elmt_spr_id%NOTFOUND then

Line 1358: hr_utility.set_location(l_proc,49);

1354: --
1355: OPEN c_base_elmt_spr_id;
1356: FETCH c_base_elmt_spr_id into l_status_pro_rule_id;
1357: IF c_base_elmt_spr_id%NOTFOUND then
1358: hr_utility.set_location(l_proc,49);
1359: hr_utility.set_message(800,'STATUS PROC RULE NOT FOUND');
1360: hr_utility.raise_error;
1361: END IF;
1362: CLOSE c_base_elmt_spr_id;

Line 1359: hr_utility.set_message(800,'STATUS PROC RULE NOT FOUND');

1355: OPEN c_base_elmt_spr_id;
1356: FETCH c_base_elmt_spr_id into l_status_pro_rule_id;
1357: IF c_base_elmt_spr_id%NOTFOUND then
1358: hr_utility.set_location(l_proc,49);
1359: hr_utility.set_message(800,'STATUS PROC RULE NOT FOUND');
1360: hr_utility.raise_error;
1361: END IF;
1362: CLOSE c_base_elmt_spr_id;
1363: --

Line 1360: hr_utility.raise_error;

1356: FETCH c_base_elmt_spr_id into l_status_pro_rule_id;
1357: IF c_base_elmt_spr_id%NOTFOUND then
1358: hr_utility.set_location(l_proc,49);
1359: hr_utility.set_message(800,'STATUS PROC RULE NOT FOUND');
1360: hr_utility.raise_error;
1361: END IF;
1362: CLOSE c_base_elmt_spr_id;
1363: --
1364: hr_utility.set_location(l_proc,50);

Line 1364: hr_utility.set_location(l_proc,50);

1360: hr_utility.raise_error;
1361: END IF;
1362: CLOSE c_base_elmt_spr_id;
1363: --
1364: hr_utility.set_location(l_proc,50);
1365: --
1366: INSERT INTO PAY_FORMULA_RESULT_RULES_F
1367: (formula_result_rule_id,
1368: effective_start_date,