DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_EMP_ACTION_ARCH

Line 295: of pay_emp_action_arch from all

291: 02-DEC-2002 ahanda 115.62 Changed package to fix GSCC warnings
292: 25-NOV-2002 ahanda 115.61 2658611 Changed update_employee_information
293: to pass assignment_id.
294: 19-NOV-2002 vpandya 115.60 Calling set_error_message function
295: of pay_emp_action_arch from all
296: exceptions to get error message
297: Remote Procedure Calls(RPC or Sub
298: program)
299: 17-NOV-2002 ahanda 115.59 Added function get_balance_value

Line 532: pay_emp_action_arch.set_error_message(lv_error_message);

528:
529: hr_utility.trace(lv_error_message || '-' || sqlerrm);
530:
531: lv_error_message :=
532: pay_emp_action_arch.set_error_message(lv_error_message);
533:
534: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
535: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
536: hr_utility.raise_error;

Line 840: pay_emp_action_arch.gv_error_message := NULL;

836: lb_range_person BOOLEAN;
837:
838: begin
839: ln_step := 1;
840: pay_emp_action_arch.gv_error_message := NULL;
841: hr_utility.set_location(gv_package || lv_procedure_name, 10);
842:
843: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
844: ,p_start_date => ld_start_date

Line 994: pay_emp_action_arch.set_error_message(lv_error_message);

990:
991: hr_utility.trace(lv_error_message || '-' || sqlerrm);
992:
993: lv_error_message :=
994: pay_emp_action_arch.set_error_message(lv_error_message);
995:
996: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
997: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
998: hr_utility.raise_error;

Line 1143: pay_emp_action_arch.gv_error_message := NULL;

1139: /* Bug 8768738 Fix */
1140: BEGIN
1141: ln_step := 1;
1142: hr_utility.set_location(gv_package || lv_procedure_name, 1);
1143: pay_emp_action_arch.gv_error_message := NULL;
1144:
1145: hr_utility.set_location(gv_package || lv_procedure_name, 2);
1146: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1147: ,p_start_date => ld_start_date

Line 1197: if pay_emp_action_arch.gv_multi_leg_rule is null then

1193: close c_get_act_param;
1194:
1195: ln_step := 2;
1196:
1197: if pay_emp_action_arch.gv_multi_leg_rule is null then
1198: pay_emp_action_arch.gv_multi_leg_rule
1199: := pay_emp_action_arch.get_multi_legislative_rule('US');
1200: end if;
1201:

Line 1198: pay_emp_action_arch.gv_multi_leg_rule

1194:
1195: ln_step := 2;
1196:
1197: if pay_emp_action_arch.gv_multi_leg_rule is null then
1198: pay_emp_action_arch.gv_multi_leg_rule
1199: := pay_emp_action_arch.get_multi_legislative_rule('US');
1200: end if;
1201:
1202: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then

Line 1199: := pay_emp_action_arch.get_multi_legislative_rule('US');

1195: ln_step := 2;
1196:
1197: if pay_emp_action_arch.gv_multi_leg_rule is null then
1198: pay_emp_action_arch.gv_multi_leg_rule
1199: := pay_emp_action_arch.get_multi_legislative_rule('US');
1200: end if;
1201:
1202: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
1203: lv_pymt_dimension := '_ASG_PAYMENTS';

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

1198: pay_emp_action_arch.gv_multi_leg_rule
1199: := pay_emp_action_arch.get_multi_legislative_rule('US');
1200: end if;
1201:
1202: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
1203: lv_pymt_dimension := '_ASG_PAYMENTS';
1204: lv_jd_pymt_dimension := '_ASG_PAYMENTS_JD';
1205: lv_subj_pymt_dimension := '_SUBJECT_TO_TAX_ASG_PAYMENTS';
1206: else

Line 1211: hr_utility.trace('pay_emp_action_arch.gv_multi_leg_rule = ' ||

1207: lv_pymt_dimension := '_PAYMENTS';
1208: lv_jd_pymt_dimension := '_PAYMENTS_JD';
1209: lv_subj_pymt_dimension := '_SUBJECT_TO_TAX_PAYMENTS';
1210: end if;
1211: hr_utility.trace('pay_emp_action_arch.gv_multi_leg_rule = ' ||
1212: pay_emp_action_arch.gv_multi_leg_rule);
1213: hr_utility.trace('lv_pymt_dimension = ' || lv_pymt_dimension);
1214: hr_utility.trace('lv_jd_pymt_dimension = ' || lv_jd_pymt_dimension);
1215: hr_utility.trace('lv_subj_pymt_dimension = ' || lv_subj_pymt_dimension);

Line 1212: pay_emp_action_arch.gv_multi_leg_rule);

1208: lv_jd_pymt_dimension := '_PAYMENTS_JD';
1209: lv_subj_pymt_dimension := '_SUBJECT_TO_TAX_PAYMENTS';
1210: end if;
1211: hr_utility.trace('pay_emp_action_arch.gv_multi_leg_rule = ' ||
1212: pay_emp_action_arch.gv_multi_leg_rule);
1213: hr_utility.trace('lv_pymt_dimension = ' || lv_pymt_dimension);
1214: hr_utility.trace('lv_jd_pymt_dimension = ' || lv_jd_pymt_dimension);
1215: hr_utility.trace('lv_subj_pymt_dimension = ' || lv_subj_pymt_dimension);
1216:

Line 1799: pay_emp_action_arch.set_error_message(lv_error_message);

1795: ' in ' || gv_package || lv_procedure_name;
1796: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1797:
1798: lv_error_message :=
1799: pay_emp_action_arch.set_error_message(lv_error_message);
1800:
1801: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1802: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1803: hr_utility.raise_error;

Line 1836: pay_emp_action_arch.arch_pay_action_level_data

1832: hr_utility.raise_error;
1833: end if;
1834: close c_effective_date;
1835:
1836: pay_emp_action_arch.arch_pay_action_level_data
1837: (p_payroll_action_id => p_payroll_action_id
1838: ,p_effective_date => l_effective_date);
1839:
1840: exception

Line 1848: pay_emp_action_arch.set_error_message(lv_error_message);

1844:
1845: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1846:
1847: lv_error_message :=
1848: pay_emp_action_arch.set_error_message(lv_error_message);
1849:
1850: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1851: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1852: hr_utility.raise_error;

Line 2128: pay_emp_action_arch.set_error_message(lv_error_message);

2124:
2125: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2126:
2127: lv_error_message :=
2128: pay_emp_action_arch.set_error_message(lv_error_message);
2129:
2130: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2131: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2132: hr_utility.raise_error;

Line 2285: pay_emp_action_arch.set_error_message(lv_error_message);

2281:
2282: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2283:
2284: lv_error_message :=
2285: pay_emp_action_arch.set_error_message(lv_error_message);
2286:
2287: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2288: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2289: hr_utility.raise_error;

Line 2347: pay_emp_action_arch.set_error_message(lv_error_message);

2343:
2344: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2345:
2346: lv_error_message :=
2347: pay_emp_action_arch.set_error_message(lv_error_message);
2348:
2349: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2350: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2351: hr_utility.raise_error;

Line 2409: pay_emp_action_arch.set_error_message(lv_error_message);

2405:
2406: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2407:
2408: lv_error_message :=
2409: pay_emp_action_arch.set_error_message(lv_error_message);
2410:
2411: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2412: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2413: hr_utility.raise_error;

Line 2473: pay_emp_action_arch.set_error_message(lv_error_message);

2469:
2470: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2471:
2472: lv_error_message :=
2473: pay_emp_action_arch.set_error_message(lv_error_message);
2474:
2475: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2476: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2477: hr_utility.raise_error;

Line 2534: pay_emp_action_arch.set_error_message(lv_error_message);

2530:
2531: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2532:
2533: lv_error_message :=
2534: pay_emp_action_arch.set_error_message(lv_error_message);
2535:
2536: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2537: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2538: hr_utility.raise_error;

Line 2601: pay_emp_action_arch.set_error_message(lv_error_message);

2597:
2598: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2599:
2600: lv_error_message :=
2601: pay_emp_action_arch.set_error_message(lv_error_message);
2602:
2603: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2604: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2605: hr_utility.raise_error;

Line 2666: pay_emp_action_arch.set_error_message(lv_error_message);

2662:
2663: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2664:
2665: lv_error_message :=
2666: pay_emp_action_arch.set_error_message(lv_error_message);
2667:
2668: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2669: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2670: hr_utility.raise_error;

Line 2728: pay_emp_action_arch.set_error_message(lv_error_message);

2724:
2725: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2726:
2727: lv_error_message :=
2728: pay_emp_action_arch.set_error_message(lv_error_message);
2729:
2730: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2731: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2732: hr_utility.raise_error;

Line 2785: pay_emp_action_arch.set_error_message(lv_error_message);

2781:
2782: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2783:
2784: lv_error_message :=
2785: pay_emp_action_arch.set_error_message(lv_error_message);
2786:
2787: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2788: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2789: hr_utility.raise_error;

Line 2831: pay_emp_action_arch.set_error_message(lv_error_message);

2827:
2828: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2829:
2830: lv_error_message :=
2831: pay_emp_action_arch.set_error_message(lv_error_message);
2832:
2833: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2834: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2835: hr_utility.raise_error;

Line 2892: pay_emp_action_arch.set_error_message(lv_error_message);

2888:
2889: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2890:
2891: lv_error_message :=
2892: pay_emp_action_arch.set_error_message(lv_error_message);
2893:
2894: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2895: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2896: hr_utility.raise_error;

Line 2941: pay_emp_action_arch.set_error_message(lv_error_message);

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

2998:
2999: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3000:
3001: lv_error_message :=
3002: pay_emp_action_arch.set_error_message(lv_error_message);
3003:
3004: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3005: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3006: hr_utility.raise_error;

Line 3051: pay_emp_action_arch.set_error_message(lv_error_message);

3047:
3048: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3049:
3050: lv_error_message :=
3051: pay_emp_action_arch.set_error_message(lv_error_message);
3052:
3053: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3054: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3055: hr_utility.raise_error;

Line 3133: pay_emp_action_arch.set_error_message(lv_error_message);

3129:
3130: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3131:
3132: lv_error_message :=
3133: pay_emp_action_arch.set_error_message(lv_error_message);
3134:
3135: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3136: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3137: hr_utility.raise_error;

Line 3195: pay_emp_action_arch.set_error_message(lv_error_message);

3191:
3192: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3193:
3194: lv_error_message :=
3195: pay_emp_action_arch.set_error_message(lv_error_message);
3196:
3197: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3198: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3199: hr_utility.raise_error;

Line 3245: pay_emp_action_arch.set_error_message(lv_error_message);

3241:
3242: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3243:
3244: lv_error_message :=
3245: pay_emp_action_arch.set_error_message(lv_error_message);
3246:
3247: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3248: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3249: hr_utility.raise_error;

Line 3317: pay_emp_action_arch.set_error_message(lv_error_message);

3313:
3314: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3315:
3316: lv_error_message :=
3317: pay_emp_action_arch.set_error_message(lv_error_message);
3318:
3319: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3320: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3321: hr_utility.raise_error;

Line 3414: pay_emp_action_arch.set_error_message(lv_error_message);

3410:
3411: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3412:
3413: lv_error_message :=
3414: pay_emp_action_arch.set_error_message(lv_error_message);
3415:
3416: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3417: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3418: hr_utility.raise_error;

Line 3533: pay_emp_action_arch.set_error_message(lv_error_message);

3529:
3530: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3531:
3532: lv_error_message :=
3533: pay_emp_action_arch.set_error_message(lv_error_message);
3534:
3535: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3536: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3537: hr_utility.raise_error;

Line 3848: pay_emp_action_arch.set_error_message(lv_error_message);

3844:
3845: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3846:
3847: lv_error_message :=
3848: pay_emp_action_arch.set_error_message(lv_error_message);
3849:
3850: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3851: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3852: hr_utility.raise_error;

Line 4431: pay_emp_action_arch.set_error_message(lv_error_message);

4427:
4428: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4429:
4430: lv_error_message :=
4431: pay_emp_action_arch.set_error_message(lv_error_message);
4432:
4433: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4434: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4435: hr_utility.raise_error;

Line 4633: pay_emp_action_arch.set_error_message(lv_error_message);

4629:
4630: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4631:
4632: lv_error_message :=
4633: pay_emp_action_arch.set_error_message(lv_error_message);
4634:
4635: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4636: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4637: hr_utility.raise_error;

Line 4835: pay_emp_action_arch.set_error_message(lv_error_message);

4831:
4832: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4833:
4834: lv_error_message :=
4835: pay_emp_action_arch.set_error_message(lv_error_message);
4836:
4837: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4838: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4839: hr_utility.raise_error;

Line 5003: pay_emp_action_arch.set_error_message(lv_error_message);

4999:
5000: hr_utility.trace(lv_error_message || '-' || sqlerrm);
5001:
5002: lv_error_message :=
5003: pay_emp_action_arch.set_error_message(lv_error_message);
5004:
5005: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5006: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5007: hr_utility.raise_error;

Line 5139: pay_emp_action_arch.set_error_message(lv_error_message);

5135:
5136: hr_utility.trace(lv_error_message || '-' || sqlerrm);
5137:
5138: lv_error_message :=
5139: pay_emp_action_arch.set_error_message(lv_error_message);
5140:
5141: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5142: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5143: hr_utility.raise_error;

Line 5326: pay_emp_action_arch.set_error_message(lv_error_message);

5322:
5323: hr_utility.trace(lv_error_message || '-' || sqlerrm);
5324:
5325: lv_error_message :=
5326: pay_emp_action_arch.set_error_message(lv_error_message);
5327:
5328: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5329: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5330: hr_utility.raise_error;

Line 5585: pay_emp_action_arch.set_error_message(lv_error_message);

5581:
5582: hr_utility.trace(lv_error_message || '-' || sqlerrm);
5583:
5584: lv_error_message :=
5585: pay_emp_action_arch.set_error_message(lv_error_message);
5586:
5587: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5588: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5589: hr_utility.raise_error;

Line 5827: pay_emp_action_arch.set_error_message(lv_error_message);

5823:
5824: hr_utility.trace(lv_error_message || '-' || sqlerrm);
5825:
5826: lv_error_message :=
5827: pay_emp_action_arch.set_error_message(lv_error_message);
5828:
5829: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5830: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5831: hr_utility.raise_error;

Line 5926: pay_emp_action_arch.set_error_message(lv_error_message);

5922:
5923: hr_utility.trace(lv_error_message || '-' || sqlerrm);
5924:
5925: lv_error_message :=
5926: pay_emp_action_arch.set_error_message(lv_error_message);
5927:
5928: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5929: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5930: hr_utility.raise_error;

Line 6190: pay_emp_action_arch.set_error_message(lv_error_message);

6186:
6187: hr_utility.trace(lv_error_message || '-' || sqlerrm);
6188:
6189: lv_error_message :=
6190: pay_emp_action_arch.set_error_message(lv_error_message);
6191:
6192: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
6193: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
6194: hr_utility.raise_error;

Line 6749: pay_emp_action_arch.set_error_message(lv_error_message);

6745:
6746: hr_utility.trace(lv_error_message || '-' || sqlerrm);
6747:
6748: lv_error_message :=
6749: pay_emp_action_arch.set_error_message(lv_error_message);
6750:
6751: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
6752: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
6753: hr_utility.raise_error;

Line 6947: pay_emp_action_arch.gv_error_message := NULL;

6943: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
6944: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
6945: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
6946:
6947: pay_emp_action_arch.gv_error_message := NULL;
6948: hr_utility.set_location(gv_package || lv_procedure_name, 10);
6949: ln_step := 1;
6950: k:=0;
6951:

Line 6953: if pay_emp_action_arch.gv_multi_payroll_pymt is null then

6949: ln_step := 1;
6950: k:=0;
6951:
6952: -- Check if Multi assignment payment is enabled
6953: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
6954: pay_emp_action_arch.gv_multi_payroll_pymt
6955: := pay_emp_action_arch.get_multi_assignment_flag(
6956: p_payroll_id => p_payroll_id
6957: ,p_effective_date => p_curr_pymt_eff_date);

Line 6954: pay_emp_action_arch.gv_multi_payroll_pymt

6950: k:=0;
6951:
6952: -- Check if Multi assignment payment is enabled
6953: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
6954: pay_emp_action_arch.gv_multi_payroll_pymt
6955: := pay_emp_action_arch.get_multi_assignment_flag(
6956: p_payroll_id => p_payroll_id
6957: ,p_effective_date => p_curr_pymt_eff_date);
6958: end if;

Line 6955: := pay_emp_action_arch.get_multi_assignment_flag(

6951:
6952: -- Check if Multi assignment payment is enabled
6953: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
6954: pay_emp_action_arch.gv_multi_payroll_pymt
6955: := pay_emp_action_arch.get_multi_assignment_flag(
6956: p_payroll_id => p_payroll_id
6957: ,p_effective_date => p_curr_pymt_eff_date);
6958: end if;
6959: hr_utility.set_location(gv_package || lv_procedure_name,20);

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

6957: ,p_effective_date => p_curr_pymt_eff_date);
6958: end if;
6959: hr_utility.set_location(gv_package || lv_procedure_name,20);
6960:
6961: if nvl(pay_emp_action_arch.gv_multi_payroll_pymt, 'N') = 'Y' then
6962: -- If Multi Assignment Payment is enabled, get the child prepayment
6963: -- actions as payment information is stored against child.
6964: -- Insert this data in pl/sql table.
6965: for cval in c_child_action(p_pre_pay_action_id, p_assignment_id) loop

Line 7143: pay_emp_action_arch.set_error_message(lv_error_message);

7139:
7140: hr_utility.trace(lv_error_message || '-' || sqlerrm);
7141:
7142: lv_error_message :=
7143: pay_emp_action_arch.set_error_message(lv_error_message);
7144:
7145: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
7146: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
7147: hr_utility.raise_error;

Line 7474: pay_emp_action_arch.get_personal_information(

7470: end if;
7471:
7472:
7473: hr_utility.set_location(gv_package || lv_procedure_name, 155);
7474: pay_emp_action_arch.get_personal_information(
7475: p_payroll_action_id => p_xfr_payroll_action_id
7476: ,p_assactid => p_xfr_action_id
7477: ,p_assignment_id => p_assignment_id
7478: ,p_curr_pymt_ass_act_id => p_pre_pay_action_id

Line 7593: pay_emp_action_arch.insert_rows_thro_api_process(

7589: );
7590:
7591: hr_utility.set_location(gv_package || lv_procedure_name, 215);
7592:
7593: pay_emp_action_arch.insert_rows_thro_api_process(
7594: p_action_context_id => p_xfr_action_id
7595: ,p_action_context_type=> 'AAP'
7596: ,p_assignment_id => p_assignment_id
7597: ,p_tax_unit_id => p_tax_unit_id

Line 7618: pay_emp_action_arch.set_error_message(lv_error_message);

7614:
7615: hr_utility.trace(lv_error_message || '-' || sqlerrm);
7616:
7617: lv_error_message :=
7618: pay_emp_action_arch.set_error_message(lv_error_message);
7619:
7620: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
7621: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
7622: hr_utility.raise_error;

Line 7881: pay_emp_action_arch.gv_error_message := NULL;

7877: ld_last_xfr_eff_date DATE;
7878: ln_last_xfr_action_id NUMBER;
7879:
7880: BEGIN
7881: pay_emp_action_arch.gv_error_message := NULL;
7882: hr_utility.set_location(gv_package || lv_procedure_name, 10);
7883: ln_step := 1;
7884: open c_xfr_info (p_xfr_action_id);
7885: fetch c_xfr_info into ln_xfr_payroll_action_id,

Line 7904: pay_emp_action_arch.gv_multi_payroll_pymt

7900:
7901: hr_utility.set_location(gv_package || lv_procedure_name, 15);
7902:
7903: ln_step := 205;
7904: pay_emp_action_arch.gv_multi_payroll_pymt
7905: := pay_emp_action_arch.get_multi_assignment_flag(
7906: p_payroll_id => ln_payroll_id
7907: ,p_effective_date => ld_end_date);
7908:

Line 7905: := pay_emp_action_arch.get_multi_assignment_flag(

7901: hr_utility.set_location(gv_package || lv_procedure_name, 15);
7902:
7903: ln_step := 205;
7904: pay_emp_action_arch.gv_multi_payroll_pymt
7905: := pay_emp_action_arch.get_multi_assignment_flag(
7906: p_payroll_id => ln_payroll_id
7907: ,p_effective_date => ld_end_date);
7908:
7909: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||

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

7905: := pay_emp_action_arch.get_multi_assignment_flag(
7906: p_payroll_id => ln_payroll_id
7907: ,p_effective_date => ld_end_date);
7908:
7909: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
7910: pay_emp_action_arch.gv_multi_payroll_pymt);
7911:
7912: ln_step := 3;
7913: open c_legislation (ln_business_group_id);

Line 7910: pay_emp_action_arch.gv_multi_payroll_pymt);

7906: p_payroll_id => ln_payroll_id
7907: ,p_effective_date => ld_end_date);
7908:
7909: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
7910: pay_emp_action_arch.gv_multi_payroll_pymt);
7911:
7912: ln_step := 3;
7913: open c_legislation (ln_business_group_id);
7914: fetch c_legislation into lv_legislation_code ;

Line 8143: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' then

8139:
8140: ln_step := 21;
8141: /* Bug 3452149 */
8142: if ln_earnings = 0 and
8143: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' then
8144: ln_earnings := 1;
8145: lv_archive_balance_info := 'N';
8146: else
8147: lv_archive_balance_info := 'Y';

Line 8178: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and

8174: ,p_last_xfr_eff_date => ld_last_xfr_eff_date
8175: ,p_last_xfr_action_id => ln_last_xfr_action_id
8176: );
8177:
8178: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and
8179: nvl(lv_master_sepcheck_flag, 'N') = 'N' and
8180: ld_last_xfr_eff_date is not null then
8181: hr_utility.trace('---------Check for un-processed asignments --------');
8182: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);

Line 8252: pay_emp_action_arch.insert_rows_thro_api_process(

8248:
8249: pay_ac_action_arch.populate_summary(
8250: p_xfr_action_id => p_xfr_action_id);
8251:
8252: pay_emp_action_arch.insert_rows_thro_api_process(
8253: p_action_context_id => ln_child_xfr_action_id
8254: ,p_action_context_type=> 'AAP'
8255: ,p_assignment_id => ln_np_asg_id
8256: ,p_tax_unit_id => ln_tax_unit_id

Line 8301: pay_emp_action_arch.insert_rows_thro_api_process(

8297: );
8298:
8299: ln_step := 14;
8300: change_processing_priority;
8301: pay_emp_action_arch.insert_rows_thro_api_process(
8302: p_action_context_id => p_xfr_action_id
8303: ,p_action_context_type=> 'AAP'
8304: ,p_assignment_id => ln_xfr_assignment_id
8305: ,p_tax_unit_id => ln_tax_unit_id

Line 8330: pay_emp_action_arch.insert_rows_thro_api_process(

8326: );
8327:
8328: ln_step := 17;
8329: change_processing_priority;
8330: pay_emp_action_arch.insert_rows_thro_api_process(
8331: p_action_context_id => p_xfr_action_id
8332: ,p_action_context_type=> 'AAP'
8333: ,p_assignment_id => ln_xfr_assignment_id
8334: ,p_tax_unit_id => ln_tax_unit_id

Line 8355: pay_emp_action_arch.arch_pay_action_level_data(

8351: if ln_pay_action_count = 0 then
8352: hr_utility.set_location(gv_package || lv_procedure_name,210);
8353: if ln_chunk_number = 1 then
8354: ln_step := 25;
8355: pay_emp_action_arch.arch_pay_action_level_data(
8356: p_payroll_action_id => ln_xfr_payroll_action_id
8357: ,p_payroll_id => ln_payroll_id
8358: ,p_effective_Date => ld_end_date
8359: );

Line 8372: pay_emp_action_arch.set_error_message(lv_error_message);

8368:
8369: hr_utility.trace(lv_error_message || '-' || sqlerrm);
8370:
8371: lv_error_message :=
8372: pay_emp_action_arch.set_error_message(lv_error_message);
8373:
8374: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
8375: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
8376: hr_utility.raise_error;

Line 8423: pay_emp_action_arch.set_error_message(lv_error_message);

8419:
8420: hr_utility.trace(lv_error_message || '-' || sqlerrm);
8421:
8422: lv_error_message :=
8423: pay_emp_action_arch.set_error_message(lv_error_message);
8424:
8425: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
8426: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
8427: hr_utility.raise_error;