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_PAYROLL_ARCH dependencies on PAY_EMP_ACTION_ARCH

Line 78: pay_emp_action_arch.

74: py_action_creation. Calling
75: get_multi_assignment_flag of
76: pay_ac_action_arch and
77: arch_pay_action_level_data of
78: pay_emp_action_arch.
79: 19-FEB-2002 vpandya 115.7 Changed global variable name for
80: Multiple Assignment Payments.
81: 12-Jun-2002 vpandya 115.8 Added
82: - procedure populate_fed_prov_bal

Line 106: of pay_emp_action_arch from all

102: gn_taxgrp_gre_id(static variable).
103: 23-Jul-2002 vpandya 115.12 2476693 Setting context Tax Unit Id
104: for Non-Payroll Payment element.
105: 20-NOV-2002 vpandya 115.14 Calling set_error_message function
106: of pay_emp_action_arch from all
107: exceptions to get error message
108: Remote Procedure Calls(RPC or Sub
109: program). Added exceptions in
110: all procedures and functions.

Line 165: pay_emp_action_arch.gv_correspondence_language

161: category 'AC DEDUCTIONS' will be
162: archived in canonical format.
163: 26-Apr-2004 rsethupa 115.28 3559626 In procedure process_actions,
164: assigned lv_person_lang to variable
165: pay_emp_action_arch.gv_correspondence_language
166: also.(For fetching Accrual Information
167: in the corresponding language)
168: 02-Aug-2004 SSattini 115.29 3498653 Added functionality to archive
169: Balance adjustments and Reversals

Line 265: pay_emp_action_arch.set_error_message(lv_error_message);

261: ' in ' || gv_package || lv_procedure_name;
262: hr_utility.trace(lv_error_message || '-' || sqlerrm);
263:
264: lv_error_message :=
265: pay_emp_action_arch.set_error_message(lv_error_message);
266:
267: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
268: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
269: hr_utility.raise_error;

Line 398: pay_emp_action_arch.set_error_message(lv_error_message);

394: ' in ' || gv_package || lv_procedure_name;
395: hr_utility.trace(lv_error_message || '-' || sqlerrm);
396:
397: lv_error_message :=
398: pay_emp_action_arch.set_error_message(lv_error_message);
399:
400: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
401: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
402: hr_utility.raise_error;

Line 582: pay_emp_action_arch.set_error_message(lv_error_message);

578: ' in ' || gv_package || lv_procedure_name;
579: hr_utility.trace(lv_error_message || '-' || sqlerrm);
580:
581: lv_error_message :=
582: pay_emp_action_arch.set_error_message(lv_error_message);
583:
584: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
585: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
586: hr_utility.raise_error;

Line 660: pay_emp_action_arch.set_error_message(lv_error_message);

656: ' in ' || gv_package || lv_procedure_name;
657: hr_utility.trace(lv_error_message || '-' || sqlerrm);
658:
659: lv_error_message :=
660: pay_emp_action_arch.set_error_message(lv_error_message);
661:
662: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
663: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
664: hr_utility.raise_error;

Line 903: pay_emp_action_arch.gv_error_message := NULL;

899: hr_utility.trace('p_ppp_source_action_id = ' || p_ppp_source_action_id);
900: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
901: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
902:
903: pay_emp_action_arch.gv_error_message := NULL;
904: hr_utility.set_location(gv_package || lv_procedure_name, 10);
905: ln_step := 1;
906: k:=0;
907:

Line 909: if pay_emp_action_arch.gv_multi_payroll_pymt is null then

905: ln_step := 1;
906: k:=0;
907:
908: -- Check if Multi assignment payment is enabled
909: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
910: pay_emp_action_arch.gv_multi_payroll_pymt
911: := pay_emp_action_arch.get_multi_assignment_flag(
912: p_payroll_id => p_payroll_id
913: ,p_effective_date => p_curr_pymt_eff_date);

Line 910: pay_emp_action_arch.gv_multi_payroll_pymt

906: k:=0;
907:
908: -- Check if Multi assignment payment is enabled
909: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
910: pay_emp_action_arch.gv_multi_payroll_pymt
911: := pay_emp_action_arch.get_multi_assignment_flag(
912: p_payroll_id => p_payroll_id
913: ,p_effective_date => p_curr_pymt_eff_date);
914: end if;

Line 911: := pay_emp_action_arch.get_multi_assignment_flag(

907:
908: -- Check if Multi assignment payment is enabled
909: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
910: pay_emp_action_arch.gv_multi_payroll_pymt
911: := pay_emp_action_arch.get_multi_assignment_flag(
912: p_payroll_id => p_payroll_id
913: ,p_effective_date => p_curr_pymt_eff_date);
914: end if;
915: hr_utility.set_location(gv_package || lv_procedure_name,20);

Line 918: if nvl(pay_emp_action_arch.gv_multi_payroll_pymt, 'N') = 'Y' then

914: end if;
915: hr_utility.set_location(gv_package || lv_procedure_name,20);
916: ln_step := 2;
917:
918: if nvl(pay_emp_action_arch.gv_multi_payroll_pymt, 'N') = 'Y' then
919: -- If Multi Assignment Payment is enabled, get the child prepayment
920: -- actions as payment information is stored against child.
921: -- Insert this data in pl/sql table.
922: for cval in c_child_action(p_pre_pay_action_id, p_assignment_id) loop

Line 1112: pay_emp_action_arch.set_error_message(lv_error_message);

1108:
1109: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1110:
1111: lv_error_message :=
1112: pay_emp_action_arch.set_error_message(lv_error_message);
1113:
1114: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1115: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1116: hr_utility.raise_error;

Line 1355: pay_emp_action_arch.gv_correspondence_language := lv_person_lang;

1351: end if;
1352:
1353: pay_ac_action_arch.gv_person_lang := lv_person_lang;
1354: /* Bug 3559626 */
1355: pay_emp_action_arch.gv_correspondence_language := lv_person_lang;
1356:
1357: hr_utility.trace('Correspondance Lang: '|| pay_ac_action_arch.gv_person_lang);
1358: hr_utility.trace('ln_ytd_balcall_aaid: '|| ln_ytd_balcall_aaid);
1359:

Line 1527: pay_emp_action_arch.get_personal_information(

1523:
1524: end if;
1525:
1526:
1527: pay_emp_action_arch.get_personal_information(
1528: p_payroll_action_id => p_xfr_payroll_action_id
1529: ,p_assactid => p_xfr_action_id
1530: ,p_assignment_id => p_assignment_id
1531: ,p_curr_pymt_ass_act_id => p_pre_pay_action_id

Line 1562: pay_emp_action_arch.insert_rows_thro_api_process(

1558: );
1559:
1560: hr_utility.set_location(gv_package || lv_procedure_name, 170);
1561:
1562: pay_emp_action_arch.insert_rows_thro_api_process(
1563: p_action_context_id => p_xfr_action_id
1564: ,p_action_context_type=> 'AAP'
1565: ,p_assignment_id => p_assignment_id
1566: ,p_tax_unit_id => p_tax_unit_id

Line 1579: pay_emp_action_arch.set_error_message(lv_error_message);

1575: ' in ' || gv_package || lv_procedure_name;
1576: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1577:
1578: lv_error_message :=
1579: pay_emp_action_arch.set_error_message(lv_error_message);
1580:
1581: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1582: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1583: hr_utility.raise_error;

Line 1918: pay_emp_action_arch.set_error_message(lv_error_message);

1914: ' in ' || gv_package || lv_procedure_name;
1915: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1916:
1917: lv_error_message :=
1918: pay_emp_action_arch.set_error_message(lv_error_message);
1919:
1920: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1921: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1922: hr_utility.raise_error;

Line 2093: if (pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or

2089: *****************************************************/
2090:
2091: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
2092:
2093: if (pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2094: pay_emp_action_arch.gv_multi_payroll_pymt is null) then
2095:
2096: open c_get_pp_actid_of_multigre(p_master_prepay_action_id
2097: ,ln_assignment_id

Line 2094: pay_emp_action_arch.gv_multi_payroll_pymt is null) then

2090:
2091: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
2092:
2093: if (pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2094: pay_emp_action_arch.gv_multi_payroll_pymt is null) then
2095:
2096: open c_get_pp_actid_of_multigre(p_master_prepay_action_id
2097: ,ln_assignment_id
2098: ,ln_tax_unit_id);

Line 2265: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and

2261:
2262: /* Bug 3960157 */
2263: if ln_gross_earn_bal = 0 and
2264: p_assignment_id = ln_assignment_id and
2265: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and
2266: ln_tax_unit_id is not null then /*Bug 14122654*/
2267: ln_gross_earn_bal := 1;
2268: lv_archive_balance_info := 'N';
2269: else

Line 2404: pay_emp_action_arch.set_error_message(lv_error_message);

2400: ' in ' || gv_package || lv_procedure_name;
2401: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2402:
2403: lv_error_message :=
2404: pay_emp_action_arch.set_error_message(lv_error_message);
2405:
2406: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2407: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2408: hr_utility.raise_error;

Line 2654: pay_emp_action_arch.set_error_message(lv_error_message);

2650: ' in ' || gv_package || lv_procedure_name;
2651: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2652:
2653: lv_error_message :=
2654: pay_emp_action_arch.set_error_message(lv_error_message);
2655:
2656: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2657: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2658: hr_utility.raise_error;

Line 2794: pay_emp_action_arch.gv_multi_payroll_pymt

2790: ,p_payroll_id => ln_payroll_id);
2791: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2792:
2793: ln_step := 2;
2794: pay_emp_action_arch.gv_multi_payroll_pymt
2795: := pay_emp_action_arch.get_multi_assignment_flag(
2796: p_payroll_id => ln_payroll_id
2797: ,p_effective_date => ld_end_date);
2798:

Line 2795: := pay_emp_action_arch.get_multi_assignment_flag(

2791: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2792:
2793: ln_step := 2;
2794: pay_emp_action_arch.gv_multi_payroll_pymt
2795: := pay_emp_action_arch.get_multi_assignment_flag(
2796: p_payroll_id => ln_payroll_id
2797: ,p_effective_date => ld_end_date);
2798:
2799: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||

Line 2799: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||

2795: := pay_emp_action_arch.get_multi_assignment_flag(
2796: p_payroll_id => ln_payroll_id
2797: ,p_effective_date => ld_end_date);
2798:
2799: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2800: pay_emp_action_arch.gv_multi_payroll_pymt);
2801: ln_step := 3;
2802: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2803: pay_emp_action_arch.gv_multi_payroll_pymt is null) and

Line 2800: pay_emp_action_arch.gv_multi_payroll_pymt);

2796: p_payroll_id => ln_payroll_id
2797: ,p_effective_date => ld_end_date);
2798:
2799: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2800: pay_emp_action_arch.gv_multi_payroll_pymt);
2801: ln_step := 3;
2802: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2803: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2804: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then

Line 2802: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or

2798:
2799: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2800: pay_emp_action_arch.gv_multi_payroll_pymt);
2801: ln_step := 3;
2802: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2803: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2804: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2805:
2806: hr_utility.set_location(gv_package || lv_procedure_name, 30);

Line 2803: pay_emp_action_arch.gv_multi_payroll_pymt is null) and

2799: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2800: pay_emp_action_arch.gv_multi_payroll_pymt);
2801: ln_step := 3;
2802: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2803: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2804: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2805:
2806: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2807: hr_utility.trace('ln_master_prepay_action_id ' ||

Line 2828: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or

2824: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2825:
2826: ln_step := 6;
2827: loop
2828: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2829: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2830: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2831:
2832: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 2829: pay_emp_action_arch.gv_multi_payroll_pymt is null) and

2825:
2826: ln_step := 6;
2827: loop
2828: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2829: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2830: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2831:
2832: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2833: ln_step := 7;

Line 2924: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or

2920: end loop;
2921: hr_utility.set_location(gv_package || lv_procedure_name, 120);
2922:
2923: ln_step := 14;
2924: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2925: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2926: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2927: close c_asg_child_action;
2928: else

Line 2925: pay_emp_action_arch.gv_multi_payroll_pymt is null) and

2921: hr_utility.set_location(gv_package || lv_procedure_name, 120);
2922:
2923: ln_step := 14;
2924: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2925: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2926: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2927: close c_asg_child_action;
2928: else
2929: close c_multi_asg_child_action;

Line 2941: pay_emp_action_arch.set_error_message(lv_error_message);

2937: ' in ' || gv_package || lv_procedure_name;
2938: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2939:
2940: lv_error_message :=
2941: pay_emp_action_arch.set_error_message(lv_error_message);
2942:
2943: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2944: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2945: hr_utility.raise_error;

Line 3094: pay_emp_action_arch.gv_error_message := NULL;

3090:
3091: BEGIN
3092:
3093: lv_procedure_name := '.action_archive_data';
3094: pay_emp_action_arch.gv_error_message := NULL;
3095: hr_utility.trace('Entered py_archive_data');
3096: hr_utility.trace('p_xfr_action_id '||to_char(p_xfr_action_id));
3097: hr_utility.trace('Cursor c_xfr_info');
3098:

Line 3118: pay_emp_action_arch.gv_multi_payroll_pymt

3114: ,p_cons_set_id => ln_cons_set_id
3115: ,p_payroll_id => ln_payroll_id);
3116:
3117: ln_step := 200;
3118: pay_emp_action_arch.gv_multi_payroll_pymt
3119: := pay_emp_action_arch.get_multi_assignment_flag(
3120: p_payroll_id => ln_payroll_id
3121: ,p_effective_date => ld_end_date);
3122:

Line 3119: := pay_emp_action_arch.get_multi_assignment_flag(

3115: ,p_payroll_id => ln_payroll_id);
3116:
3117: ln_step := 200;
3118: pay_emp_action_arch.gv_multi_payroll_pymt
3119: := pay_emp_action_arch.get_multi_assignment_flag(
3120: p_payroll_id => ln_payroll_id
3121: ,p_effective_date => ld_end_date);
3122:
3123: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||

Line 3123: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||

3119: := pay_emp_action_arch.get_multi_assignment_flag(
3120: p_payroll_id => ln_payroll_id
3121: ,p_effective_date => ld_end_date);
3122:
3123: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
3124: pay_emp_action_arch.gv_multi_payroll_pymt);
3125:
3126: ln_step := 3;
3127: open c_legislation (ln_business_group_id);

Line 3124: pay_emp_action_arch.gv_multi_payroll_pymt);

3120: p_payroll_id => ln_payroll_id
3121: ,p_effective_date => ld_end_date);
3122:
3123: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
3124: pay_emp_action_arch.gv_multi_payroll_pymt);
3125:
3126: ln_step := 3;
3127: open c_legislation (ln_business_group_id);
3128: fetch c_legislation into lv_legislation_code ;

Line 3238: -- ( pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or

3234:
3235: end if; -- gv_reporting_level = 'TAXGRP'
3236:
3237: -- if ( ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) and
3238: -- ( pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
3239: -- pay_emp_action_arch.gv_multi_payroll_pymt is null ) ) then
3240:
3241: -- create_chld_act_for_multi_gre(
3242: -- p_xfr_payroll_action_id => ln_xfr_payroll_action_id

Line 3239: -- pay_emp_action_arch.gv_multi_payroll_pymt is null ) ) then

3235: end if; -- gv_reporting_level = 'TAXGRP'
3236:
3237: -- if ( ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) and
3238: -- ( pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
3239: -- pay_emp_action_arch.gv_multi_payroll_pymt is null ) ) then
3240:
3241: -- create_chld_act_for_multi_gre(
3242: -- p_xfr_payroll_action_id => ln_xfr_payroll_action_id
3243: -- ,p_master_xfr_action_id => p_xfr_action_id

Line 3412: pay_emp_action_arch.insert_rows_thro_api_process(

3408: ,p_action_type => lv_master_action_type);
3409:
3410: hr_utility.trace('Done Populating Tax Balances for Reversals');
3411: ln_step := 17;
3412: pay_emp_action_arch.insert_rows_thro_api_process(
3413: p_action_context_id => p_xfr_action_id
3414: ,p_action_context_type=> 'AAP'
3415: ,p_assignment_id => ln_assignment_id
3416: ,p_tax_unit_id => ln_tax_unit_id

Line 3513: pay_emp_action_arch.insert_rows_thro_api_process(

3509: end loop;
3510: close c_get_emp_adjbal;
3511:
3512: ln_step := 20;
3513: pay_emp_action_arch.insert_rows_thro_api_process(
3514: p_action_context_id => p_xfr_action_id
3515: ,p_action_context_type=> 'AAP'
3516: ,p_assignment_id => ln_assignment_id
3517: ,p_tax_unit_id => ln_tax_unit_id

Line 3539: pay_emp_action_arch.arch_pay_action_level_data(

3535: if ln_pay_action_count = 0 then
3536: hr_utility.set_location(gv_package || lv_procedure_name,215);
3537: ln_step := 22;
3538: if ln_chunk_number = 1 then
3539: pay_emp_action_arch.arch_pay_action_level_data(
3540: p_payroll_action_id => ln_xfr_payroll_action_id
3541: ,p_payroll_id => ln_payroll_id
3542: ,p_effective_Date => ld_end_date
3543: );

Line 3556: pay_emp_action_arch.set_error_message(lv_error_message);

3552: ' in ' || gv_package || lv_procedure_name;
3553: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3554:
3555: lv_error_message :=
3556: pay_emp_action_arch.set_error_message(lv_error_message);
3557:
3558: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3559: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3560: hr_utility.raise_error;

Line 3591: pay_emp_action_arch.gv_error_message := NULL;

3587: begin
3588:
3589: lv_procedure_name := '.py_range_cursor';
3590: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3591: pay_emp_action_arch.gv_error_message := NULL;
3592:
3593: ln_step := 1;
3594: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
3595: ,p_start_date => ld_start_date

Line 3650: pay_emp_action_arch.set_error_message(lv_error_message);

3646: ' in ' || gv_package || lv_procedure_name;
3647: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3648:
3649: lv_error_message :=
3650: pay_emp_action_arch.set_error_message(lv_error_message);
3651:
3652: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3653: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3654: hr_utility.raise_error;

Line 3772: pay_emp_action_arch.gv_error_message := NULL;

3768: --- hr_utility.trace_on(null, 'PYARCH');
3769:
3770: lv_procedure_name := '.py_action_creation';
3771: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3772: pay_emp_action_arch.gv_error_message := NULL;
3773:
3774: ln_step := 1;
3775: /* Initialising local variables to avoid GSCC warnings */
3776: ln_assignment_id := 0;

Line 3930: pay_emp_action_arch.set_error_message(lv_error_message);

3926: ' in ' || gv_package || lv_procedure_name;
3927: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3928:
3929: lv_error_message :=
3930: pay_emp_action_arch.set_error_message(lv_error_message);
3931:
3932: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3933: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3934: hr_utility.raise_error;

Line 4017: pay_emp_action_arch.gv_error_message := NULL;

4013:
4014: BEGIN
4015: lv_procedure_name := '.py_archinit';
4016: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4017: pay_emp_action_arch.gv_error_message := NULL;
4018: lv_reporting_level := Null;
4019: i := 0;
4020: j := 0;
4021:

Line 4037: nvl(pay_emp_action_arch.get_defined_balance_id(

4033: fetch cur_bal_type into lv_balance_name, ln_run_bal_type_id;
4034: exit when cur_bal_type%notfound;
4035: if lv_balance_name = 'Payments' then
4036: gn_payments_def_bal_id :=
4037: nvl(pay_emp_action_arch.get_defined_balance_id(
4038: ln_run_bal_type_id,
4039: '_ASG_RUN',
4040: 'CA'),-1);
4041: else

Line 4043: nvl(pay_emp_action_arch.get_defined_balance_id(

4039: '_ASG_RUN',
4040: 'CA'),-1);
4041: else
4042: gn_gross_earn_def_bal_id :=
4043: nvl(pay_emp_action_arch.get_defined_balance_id(
4044: ln_run_bal_type_id,
4045: '_ASG_RUN',
4046: 'CA'),-1);
4047: end if;

Line 4063: if pay_emp_action_arch.gv_multi_leg_rule is null then

4059:
4060: pay_ac_action_arch.gv_reporting_level := lv_reporting_level;
4061:
4062: ln_step := 20;
4063: if pay_emp_action_arch.gv_multi_leg_rule is null then
4064: pay_emp_action_arch.gv_multi_leg_rule
4065: := pay_emp_action_arch.get_multi_legislative_rule('CA');
4066: end if;
4067:

Line 4064: pay_emp_action_arch.gv_multi_leg_rule

4060: pay_ac_action_arch.gv_reporting_level := lv_reporting_level;
4061:
4062: ln_step := 20;
4063: if pay_emp_action_arch.gv_multi_leg_rule is null then
4064: pay_emp_action_arch.gv_multi_leg_rule
4065: := pay_emp_action_arch.get_multi_legislative_rule('CA');
4066: end if;
4067:
4068: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);

Line 4065: := pay_emp_action_arch.get_multi_legislative_rule('CA');

4061:
4062: ln_step := 20;
4063: if pay_emp_action_arch.gv_multi_leg_rule is null then
4064: pay_emp_action_arch.gv_multi_leg_rule
4065: := pay_emp_action_arch.get_multi_legislative_rule('CA');
4066: end if;
4067:
4068: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
4069: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);

Line 4069: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);

4065: := pay_emp_action_arch.get_multi_legislative_rule('CA');
4066: end if;
4067:
4068: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
4069: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
4070: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4071:
4072: ln_step := 30;
4073: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then

Line 4073: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then

4069: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
4070: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4071:
4072: ln_step := 30;
4073: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
4074: lv_pymt_dimension := '_ASG_PAYMENTS';
4075: lv_jd_pymt_dimension := '_ASG_PAYMENTS_JD';
4076: else
4077: lv_pymt_dimension := '_PAYMENTS';

Line 4100: pay_emp_action_arch.get_defined_balance_id(

4096: then
4097:
4098: ln_step := 60;
4099: ln_pymt_def_bal_id :=
4100: pay_emp_action_arch.get_defined_balance_id(
4101: c_dbt.balance_type_id,
4102: lv_jd_pymt_dimension,
4103: 'CA');
4104:

Line 4107: pay_emp_action_arch.get_defined_balance_id(

4103: 'CA');
4104:
4105: ln_step := 70;
4106: ln_gre_ytd_def_bal_id :=
4107: pay_emp_action_arch.get_defined_balance_id(
4108: c_dbt.balance_type_id,
4109: '_ASG_JD_GRE_YTD',
4110: 'CA');
4111:

Line 4114: pay_emp_action_arch.get_defined_balance_id(

4110: 'CA');
4111:
4112: ln_step := 80;
4113: ln_tg_ytd_def_bal_id :=
4114: pay_emp_action_arch.get_defined_balance_id(
4115: c_dbt.balance_type_id,
4116: '_ASG_JD_TG_YTD',
4117: 'CA');
4118:

Line 4121: pay_emp_action_arch.get_defined_balance_id(

4117: 'CA');
4118:
4119: /* Modifying to check for reversals for Canada. Bug#3498653 */
4120: ln_run_def_bal_id :=
4121: pay_emp_action_arch.get_defined_balance_id(
4122: c_dbt.balance_type_id,
4123: '_ASG_JD_GRE_RUN',
4124: 'CA');
4125:

Line 4129: pay_emp_action_arch.get_defined_balance_id(

4125:
4126: else
4127: ln_step := 90;
4128: ln_pymt_def_bal_id :=
4129: pay_emp_action_arch.get_defined_balance_id(
4130: c_dbt.balance_type_id,
4131: lv_pymt_dimension,
4132: 'CA');
4133:

Line 4136: pay_emp_action_arch.get_defined_balance_id(

4132: 'CA');
4133:
4134: ln_step := 100;
4135: ln_gre_ytd_def_bal_id :=
4136: pay_emp_action_arch.get_defined_balance_id(
4137: c_dbt.balance_type_id,
4138: '_ASG_GRE_YTD',
4139: 'CA');
4140:

Line 4143: pay_emp_action_arch.get_defined_balance_id(

4139: 'CA');
4140:
4141: ln_step := 110;
4142: ln_tg_ytd_def_bal_id :=
4143: pay_emp_action_arch.get_defined_balance_id(
4144: c_dbt.balance_type_id,
4145: '_ASG_TG_YTD',
4146: 'CA');
4147:

Line 4150: pay_emp_action_arch.get_defined_balance_id(

4146: 'CA');
4147:
4148: /* Modifying to check for reversals for Canada. Bug#3498653 */
4149: ln_run_def_bal_id :=
4150: pay_emp_action_arch.get_defined_balance_id(
4151: c_dbt.balance_type_id,
4152: '_ASG_GRE_RUN',
4153: 'CA');
4154:

Line 4262: pay_emp_action_arch.set_error_message(lv_error_message);

4258: ' in ' || gv_package || lv_procedure_name;
4259: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4260:
4261: lv_error_message :=
4262: pay_emp_action_arch.set_error_message(lv_error_message);
4263:
4264: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4265: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4266: hr_utility.raise_error;