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 251: pay_emp_action_arch.set_error_message(lv_error_message);

247: ' in ' || gv_package || lv_procedure_name;
248: hr_utility.trace(lv_error_message || '-' || sqlerrm);
249:
250: lv_error_message :=
251: pay_emp_action_arch.set_error_message(lv_error_message);
252:
253: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
254: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
255: hr_utility.raise_error;

Line 384: pay_emp_action_arch.set_error_message(lv_error_message);

380: ' in ' || gv_package || lv_procedure_name;
381: hr_utility.trace(lv_error_message || '-' || sqlerrm);
382:
383: lv_error_message :=
384: pay_emp_action_arch.set_error_message(lv_error_message);
385:
386: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
387: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
388: hr_utility.raise_error;

Line 568: pay_emp_action_arch.set_error_message(lv_error_message);

564: ' in ' || gv_package || lv_procedure_name;
565: hr_utility.trace(lv_error_message || '-' || sqlerrm);
566:
567: lv_error_message :=
568: pay_emp_action_arch.set_error_message(lv_error_message);
569:
570: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
571: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
572: hr_utility.raise_error;

Line 646: pay_emp_action_arch.set_error_message(lv_error_message);

642: ' in ' || gv_package || lv_procedure_name;
643: hr_utility.trace(lv_error_message || '-' || sqlerrm);
644:
645: lv_error_message :=
646: pay_emp_action_arch.set_error_message(lv_error_message);
647:
648: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
649: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
650: hr_utility.raise_error;

Line 875: pay_emp_action_arch.gv_correspondence_language := lv_person_lang;

871: end if;
872:
873: pay_ac_action_arch.gv_person_lang := lv_person_lang;
874: /* Bug 3559626 */
875: pay_emp_action_arch.gv_correspondence_language := lv_person_lang;
876:
877: hr_utility.trace('Correspondance Lang: '|| pay_ac_action_arch.gv_person_lang);
878: hr_utility.trace('ln_ytd_balcall_aaid: '|| ln_ytd_balcall_aaid);
879:

Line 1047: pay_emp_action_arch.get_personal_information(

1043:
1044: end if;
1045:
1046:
1047: pay_emp_action_arch.get_personal_information(
1048: p_payroll_action_id => p_xfr_payroll_action_id
1049: ,p_assactid => p_xfr_action_id
1050: ,p_assignment_id => p_assignment_id
1051: ,p_curr_pymt_ass_act_id => p_pre_pay_action_id

Line 1065: pay_emp_action_arch.insert_rows_thro_api_process(

1061:
1062:
1063: hr_utility.set_location(gv_package || lv_procedure_name, 160);
1064:
1065: pay_emp_action_arch.insert_rows_thro_api_process(
1066: p_action_context_id => p_xfr_action_id
1067: ,p_action_context_type=> 'AAP'
1068: ,p_assignment_id => p_assignment_id
1069: ,p_tax_unit_id => p_tax_unit_id

Line 1082: pay_emp_action_arch.set_error_message(lv_error_message);

1078: ' in ' || gv_package || lv_procedure_name;
1079: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1080:
1081: lv_error_message :=
1082: pay_emp_action_arch.set_error_message(lv_error_message);
1083:
1084: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1085: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1086: hr_utility.raise_error;

Line 1416: pay_emp_action_arch.set_error_message(lv_error_message);

1412: ' in ' || gv_package || lv_procedure_name;
1413: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1414:
1415: lv_error_message :=
1416: pay_emp_action_arch.set_error_message(lv_error_message);
1417:
1418: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1419: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1420: hr_utility.raise_error;

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

1584: *****************************************************/
1585:
1586: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
1587:
1588: if (pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
1589: pay_emp_action_arch.gv_multi_payroll_pymt is null) then
1590:
1591: open c_get_pp_actid_of_multigre(p_master_prepay_action_id
1592: ,ln_assignment_id

Line 1589: pay_emp_action_arch.gv_multi_payroll_pymt is null) then

1585:
1586: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
1587:
1588: if (pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
1589: pay_emp_action_arch.gv_multi_payroll_pymt is null) then
1590:
1591: open c_get_pp_actid_of_multigre(p_master_prepay_action_id
1592: ,ln_assignment_id
1593: ,ln_tax_unit_id);

Line 1755: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' then

1751:
1752: /* Bug 3960157 */
1753: if ln_gross_earn_bal = 0 and
1754: p_assignment_id = ln_assignment_id and
1755: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' then
1756: ln_gross_earn_bal := 1;
1757: lv_archive_balance_info := 'N';
1758: else
1759: lv_archive_balance_info := 'Y';

Line 1893: pay_emp_action_arch.set_error_message(lv_error_message);

1889: ' in ' || gv_package || lv_procedure_name;
1890: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1891:
1892: lv_error_message :=
1893: pay_emp_action_arch.set_error_message(lv_error_message);
1894:
1895: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1896: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1897: hr_utility.raise_error;

Line 2143: pay_emp_action_arch.set_error_message(lv_error_message);

2139: ' in ' || gv_package || lv_procedure_name;
2140: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2141:
2142: lv_error_message :=
2143: pay_emp_action_arch.set_error_message(lv_error_message);
2144:
2145: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2146: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2147: hr_utility.raise_error;

Line 2283: pay_emp_action_arch.gv_multi_payroll_pymt

2279: ,p_payroll_id => ln_payroll_id);
2280: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2281:
2282: ln_step := 2;
2283: pay_emp_action_arch.gv_multi_payroll_pymt
2284: := pay_emp_action_arch.get_multi_assignment_flag(
2285: p_payroll_id => ln_payroll_id
2286: ,p_effective_date => ld_end_date);
2287:

Line 2284: := pay_emp_action_arch.get_multi_assignment_flag(

2280: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2281:
2282: ln_step := 2;
2283: pay_emp_action_arch.gv_multi_payroll_pymt
2284: := pay_emp_action_arch.get_multi_assignment_flag(
2285: p_payroll_id => ln_payroll_id
2286: ,p_effective_date => ld_end_date);
2287:
2288: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||

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

2284: := pay_emp_action_arch.get_multi_assignment_flag(
2285: p_payroll_id => ln_payroll_id
2286: ,p_effective_date => ld_end_date);
2287:
2288: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2289: pay_emp_action_arch.gv_multi_payroll_pymt);
2290: ln_step := 3;
2291: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2292: pay_emp_action_arch.gv_multi_payroll_pymt is null) and

Line 2289: pay_emp_action_arch.gv_multi_payroll_pymt);

2285: p_payroll_id => ln_payroll_id
2286: ,p_effective_date => ld_end_date);
2287:
2288: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2289: pay_emp_action_arch.gv_multi_payroll_pymt);
2290: ln_step := 3;
2291: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2292: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2293: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then

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

2287:
2288: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2289: pay_emp_action_arch.gv_multi_payroll_pymt);
2290: ln_step := 3;
2291: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2292: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2293: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2294:
2295: hr_utility.set_location(gv_package || lv_procedure_name, 30);

Line 2292: pay_emp_action_arch.gv_multi_payroll_pymt is null) and

2288: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2289: pay_emp_action_arch.gv_multi_payroll_pymt);
2290: ln_step := 3;
2291: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2292: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2293: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2294:
2295: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2296: hr_utility.trace('ln_master_prepay_action_id ' ||

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

2313: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2314:
2315: ln_step := 6;
2316: loop
2317: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2318: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2319: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2320:
2321: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 2318: pay_emp_action_arch.gv_multi_payroll_pymt is null) and

2314:
2315: ln_step := 6;
2316: loop
2317: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2318: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2319: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2320:
2321: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2322: ln_step := 7;

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

2409: end loop;
2410: hr_utility.set_location(gv_package || lv_procedure_name, 120);
2411:
2412: ln_step := 14;
2413: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2414: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2415: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2416: close c_asg_child_action;
2417: else

Line 2414: pay_emp_action_arch.gv_multi_payroll_pymt is null) and

2410: hr_utility.set_location(gv_package || lv_procedure_name, 120);
2411:
2412: ln_step := 14;
2413: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2414: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2415: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2416: close c_asg_child_action;
2417: else
2418: close c_multi_asg_child_action;

Line 2430: pay_emp_action_arch.set_error_message(lv_error_message);

2426: ' in ' || gv_package || lv_procedure_name;
2427: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2428:
2429: lv_error_message :=
2430: pay_emp_action_arch.set_error_message(lv_error_message);
2431:
2432: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2433: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2434: hr_utility.raise_error;

Line 2583: pay_emp_action_arch.gv_error_message := NULL;

2579:
2580: BEGIN
2581:
2582: lv_procedure_name := '.action_archive_data';
2583: pay_emp_action_arch.gv_error_message := NULL;
2584: hr_utility.trace('Entered py_archive_data');
2585: hr_utility.trace('p_xfr_action_id '||to_char(p_xfr_action_id));
2586: hr_utility.trace('Cursor c_xfr_info');
2587:

Line 2607: pay_emp_action_arch.gv_multi_payroll_pymt

2603: ,p_cons_set_id => ln_cons_set_id
2604: ,p_payroll_id => ln_payroll_id);
2605:
2606: ln_step := 200;
2607: pay_emp_action_arch.gv_multi_payroll_pymt
2608: := pay_emp_action_arch.get_multi_assignment_flag(
2609: p_payroll_id => ln_payroll_id
2610: ,p_effective_date => ld_end_date);
2611:

Line 2608: := pay_emp_action_arch.get_multi_assignment_flag(

2604: ,p_payroll_id => ln_payroll_id);
2605:
2606: ln_step := 200;
2607: pay_emp_action_arch.gv_multi_payroll_pymt
2608: := pay_emp_action_arch.get_multi_assignment_flag(
2609: p_payroll_id => ln_payroll_id
2610: ,p_effective_date => ld_end_date);
2611:
2612: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||

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

2608: := pay_emp_action_arch.get_multi_assignment_flag(
2609: p_payroll_id => ln_payroll_id
2610: ,p_effective_date => ld_end_date);
2611:
2612: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2613: pay_emp_action_arch.gv_multi_payroll_pymt);
2614:
2615: ln_step := 3;
2616: open c_legislation (ln_business_group_id);

Line 2613: pay_emp_action_arch.gv_multi_payroll_pymt);

2609: p_payroll_id => ln_payroll_id
2610: ,p_effective_date => ld_end_date);
2611:
2612: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2613: pay_emp_action_arch.gv_multi_payroll_pymt);
2614:
2615: ln_step := 3;
2616: open c_legislation (ln_business_group_id);
2617: fetch c_legislation into lv_legislation_code ;

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

2723:
2724: end if; -- gv_reporting_level = 'TAXGRP'
2725:
2726: -- if ( ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) and
2727: -- ( pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2728: -- pay_emp_action_arch.gv_multi_payroll_pymt is null ) ) then
2729:
2730: -- create_chld_act_for_multi_gre(
2731: -- p_xfr_payroll_action_id => ln_xfr_payroll_action_id

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

2724: end if; -- gv_reporting_level = 'TAXGRP'
2725:
2726: -- if ( ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) and
2727: -- ( pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2728: -- pay_emp_action_arch.gv_multi_payroll_pymt is null ) ) then
2729:
2730: -- create_chld_act_for_multi_gre(
2731: -- p_xfr_payroll_action_id => ln_xfr_payroll_action_id
2732: -- ,p_master_xfr_action_id => p_xfr_action_id

Line 2901: pay_emp_action_arch.insert_rows_thro_api_process(

2897: ,p_action_type => lv_master_action_type);
2898:
2899: hr_utility.trace('Done Populating Tax Balances for Reversals');
2900: ln_step := 17;
2901: pay_emp_action_arch.insert_rows_thro_api_process(
2902: p_action_context_id => p_xfr_action_id
2903: ,p_action_context_type=> 'AAP'
2904: ,p_assignment_id => ln_assignment_id
2905: ,p_tax_unit_id => ln_tax_unit_id

Line 3002: pay_emp_action_arch.insert_rows_thro_api_process(

2998: end loop;
2999: close c_get_emp_adjbal;
3000:
3001: ln_step := 20;
3002: pay_emp_action_arch.insert_rows_thro_api_process(
3003: p_action_context_id => p_xfr_action_id
3004: ,p_action_context_type=> 'AAP'
3005: ,p_assignment_id => ln_assignment_id
3006: ,p_tax_unit_id => ln_tax_unit_id

Line 3028: pay_emp_action_arch.arch_pay_action_level_data(

3024: if ln_pay_action_count = 0 then
3025: hr_utility.set_location(gv_package || lv_procedure_name,215);
3026: ln_step := 22;
3027: if ln_chunk_number = 1 then
3028: pay_emp_action_arch.arch_pay_action_level_data(
3029: p_payroll_action_id => ln_xfr_payroll_action_id
3030: ,p_payroll_id => ln_payroll_id
3031: ,p_effective_Date => ld_end_date
3032: );

Line 3045: pay_emp_action_arch.set_error_message(lv_error_message);

3041: ' in ' || gv_package || lv_procedure_name;
3042: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3043:
3044: lv_error_message :=
3045: pay_emp_action_arch.set_error_message(lv_error_message);
3046:
3047: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3048: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3049: hr_utility.raise_error;

Line 3080: pay_emp_action_arch.gv_error_message := NULL;

3076: begin
3077:
3078: lv_procedure_name := '.py_range_cursor';
3079: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3080: pay_emp_action_arch.gv_error_message := NULL;
3081:
3082: ln_step := 1;
3083: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
3084: ,p_start_date => ld_start_date

Line 3139: pay_emp_action_arch.set_error_message(lv_error_message);

3135: ' in ' || gv_package || lv_procedure_name;
3136: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3137:
3138: lv_error_message :=
3139: pay_emp_action_arch.set_error_message(lv_error_message);
3140:
3141: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3142: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3143: hr_utility.raise_error;

Line 3261: pay_emp_action_arch.gv_error_message := NULL;

3257: --- hr_utility.trace_on(null, 'PYARCH');
3258:
3259: lv_procedure_name := '.py_action_creation';
3260: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3261: pay_emp_action_arch.gv_error_message := NULL;
3262:
3263: ln_step := 1;
3264: /* Initialising local variables to avoid GSCC warnings */
3265: ln_assignment_id := 0;

Line 3419: pay_emp_action_arch.set_error_message(lv_error_message);

3415: ' in ' || gv_package || lv_procedure_name;
3416: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3417:
3418: lv_error_message :=
3419: pay_emp_action_arch.set_error_message(lv_error_message);
3420:
3421: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3422: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3423: hr_utility.raise_error;

Line 3506: pay_emp_action_arch.gv_error_message := NULL;

3502:
3503: BEGIN
3504: lv_procedure_name := '.py_archinit';
3505: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3506: pay_emp_action_arch.gv_error_message := NULL;
3507: lv_reporting_level := Null;
3508: i := 0;
3509: j := 0;
3510:

Line 3526: nvl(pay_emp_action_arch.get_defined_balance_id(

3522: fetch cur_bal_type into lv_balance_name, ln_run_bal_type_id;
3523: exit when cur_bal_type%notfound;
3524: if lv_balance_name = 'Payments' then
3525: gn_payments_def_bal_id :=
3526: nvl(pay_emp_action_arch.get_defined_balance_id(
3527: ln_run_bal_type_id,
3528: '_ASG_RUN',
3529: 'CA'),-1);
3530: else

Line 3532: nvl(pay_emp_action_arch.get_defined_balance_id(

3528: '_ASG_RUN',
3529: 'CA'),-1);
3530: else
3531: gn_gross_earn_def_bal_id :=
3532: nvl(pay_emp_action_arch.get_defined_balance_id(
3533: ln_run_bal_type_id,
3534: '_ASG_RUN',
3535: 'CA'),-1);
3536: end if;

Line 3552: if pay_emp_action_arch.gv_multi_leg_rule is null then

3548:
3549: pay_ac_action_arch.gv_reporting_level := lv_reporting_level;
3550:
3551: ln_step := 20;
3552: if pay_emp_action_arch.gv_multi_leg_rule is null then
3553: pay_emp_action_arch.gv_multi_leg_rule
3554: := pay_emp_action_arch.get_multi_legislative_rule('CA');
3555: end if;
3556:

Line 3553: pay_emp_action_arch.gv_multi_leg_rule

3549: pay_ac_action_arch.gv_reporting_level := lv_reporting_level;
3550:
3551: ln_step := 20;
3552: if pay_emp_action_arch.gv_multi_leg_rule is null then
3553: pay_emp_action_arch.gv_multi_leg_rule
3554: := pay_emp_action_arch.get_multi_legislative_rule('CA');
3555: end if;
3556:
3557: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);

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

3550:
3551: ln_step := 20;
3552: if pay_emp_action_arch.gv_multi_leg_rule is null then
3553: pay_emp_action_arch.gv_multi_leg_rule
3554: := pay_emp_action_arch.get_multi_legislative_rule('CA');
3555: end if;
3556:
3557: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
3558: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);

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

3554: := pay_emp_action_arch.get_multi_legislative_rule('CA');
3555: end if;
3556:
3557: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
3558: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
3559: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3560:
3561: ln_step := 30;
3562: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then

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

3558: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
3559: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3560:
3561: ln_step := 30;
3562: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
3563: lv_pymt_dimension := '_ASG_PAYMENTS';
3564: lv_jd_pymt_dimension := '_ASG_PAYMENTS_JD';
3565: else
3566: lv_pymt_dimension := '_PAYMENTS';

Line 3589: pay_emp_action_arch.get_defined_balance_id(

3585: then
3586:
3587: ln_step := 60;
3588: ln_pymt_def_bal_id :=
3589: pay_emp_action_arch.get_defined_balance_id(
3590: c_dbt.balance_type_id,
3591: lv_jd_pymt_dimension,
3592: 'CA');
3593:

Line 3596: pay_emp_action_arch.get_defined_balance_id(

3592: 'CA');
3593:
3594: ln_step := 70;
3595: ln_gre_ytd_def_bal_id :=
3596: pay_emp_action_arch.get_defined_balance_id(
3597: c_dbt.balance_type_id,
3598: '_ASG_JD_GRE_YTD',
3599: 'CA');
3600:

Line 3603: pay_emp_action_arch.get_defined_balance_id(

3599: 'CA');
3600:
3601: ln_step := 80;
3602: ln_tg_ytd_def_bal_id :=
3603: pay_emp_action_arch.get_defined_balance_id(
3604: c_dbt.balance_type_id,
3605: '_ASG_JD_TG_YTD',
3606: 'CA');
3607:

Line 3610: pay_emp_action_arch.get_defined_balance_id(

3606: 'CA');
3607:
3608: /* Modifying to check for reversals for Canada. Bug#3498653 */
3609: ln_run_def_bal_id :=
3610: pay_emp_action_arch.get_defined_balance_id(
3611: c_dbt.balance_type_id,
3612: '_ASG_JD_GRE_RUN',
3613: 'CA');
3614:

Line 3618: pay_emp_action_arch.get_defined_balance_id(

3614:
3615: else
3616: ln_step := 90;
3617: ln_pymt_def_bal_id :=
3618: pay_emp_action_arch.get_defined_balance_id(
3619: c_dbt.balance_type_id,
3620: lv_pymt_dimension,
3621: 'CA');
3622:

Line 3625: pay_emp_action_arch.get_defined_balance_id(

3621: 'CA');
3622:
3623: ln_step := 100;
3624: ln_gre_ytd_def_bal_id :=
3625: pay_emp_action_arch.get_defined_balance_id(
3626: c_dbt.balance_type_id,
3627: '_ASG_GRE_YTD',
3628: 'CA');
3629:

Line 3632: pay_emp_action_arch.get_defined_balance_id(

3628: 'CA');
3629:
3630: ln_step := 110;
3631: ln_tg_ytd_def_bal_id :=
3632: pay_emp_action_arch.get_defined_balance_id(
3633: c_dbt.balance_type_id,
3634: '_ASG_TG_YTD',
3635: 'CA');
3636:

Line 3639: pay_emp_action_arch.get_defined_balance_id(

3635: 'CA');
3636:
3637: /* Modifying to check for reversals for Canada. Bug#3498653 */
3638: ln_run_def_bal_id :=
3639: pay_emp_action_arch.get_defined_balance_id(
3640: c_dbt.balance_type_id,
3641: '_ASG_GRE_RUN',
3642: 'CA');
3643:

Line 3751: pay_emp_action_arch.set_error_message(lv_error_message);

3747: ' in ' || gv_package || lv_procedure_name;
3748: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3749:
3750: lv_error_message :=
3751: pay_emp_action_arch.set_error_message(lv_error_message);
3752:
3753: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3754: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3755: hr_utility.raise_error;