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

Line 98: pay_emp_action_arch.set_error_message(lv_error_message);

94:
95: hr_utility.trace(lv_error_message || '-' || SQLERRM);
96:
97: lv_error_message :=
98: pay_emp_action_arch.set_error_message(lv_error_message);
99:
100: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
101: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
102: hr_utility.raise_error;

Line 222: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN

218: ||to_char(p_hours_balance_id));
219: hr_utility.trace('p_days_balance_id '
220: ||to_char(p_days_balance_id));
221:
222: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
223: pay_emp_action_arch.gv_multi_leg_rule
224: := pay_emp_action_arch.get_multi_legislative_rule(
225: p_legislation_code);
226: END IF;

Line 223: pay_emp_action_arch.gv_multi_leg_rule

219: hr_utility.trace('p_days_balance_id '
220: ||to_char(p_days_balance_id));
221:
222: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
223: pay_emp_action_arch.gv_multi_leg_rule
224: := pay_emp_action_arch.get_multi_legislative_rule(
225: p_legislation_code);
226: END IF;
227:

Line 224: := pay_emp_action_arch.get_multi_legislative_rule(

220: ||to_char(p_days_balance_id));
221:
222: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
223: pay_emp_action_arch.gv_multi_leg_rule
224: := pay_emp_action_arch.get_multi_legislative_rule(
225: p_legislation_code);
226: END IF;
227:
228: ln_step := 2;

Line 244: := pay_emp_action_arch.get_defined_balance_id(

240: ** Get the defined balance_id for YTD call as it will be
241: ** same for all classification types.
242: *********************************************************/
243: ln_ytd_defined_balance_id
244: := pay_emp_action_arch.get_defined_balance_id(
245: p_primary_balance_id,
246: gv_ytd_balance_dimension,
247: p_legislation_code);
248:

Line 256: := pay_emp_action_arch.get_defined_balance_id(

252: ln_step := 4;
253: IF p_hours_balance_id IS NOT NULL THEN
254: hr_utility.set_location(gv_package || lv_procedure_name, 20);
255: ln_ytd_hours_balance_id
256: := pay_emp_action_arch.get_defined_balance_id(
257: p_hours_balance_id,
258: gv_ytd_balance_dimension,
259: p_legislation_code);
260:

Line 269: := pay_emp_action_arch.get_defined_balance_id(

265:
266: IF p_days_balance_id IS NOT NULL THEN
267: hr_utility.set_location(gv_package || lv_procedure_name, 20);
268: ln_ytd_days_balance_id
269: := pay_emp_action_arch.get_defined_balance_id(
270: p_days_balance_id,
271: gv_ytd_balance_dimension,
272: p_legislation_code);
273:

Line 336: := pay_emp_action_arch.get_defined_balance_id(

332: IF p_pymt_balcall_aaid IS NOT NULL THEN
333: ln_step := 10;
334: IF p_action_type IN ('B','V') THEN
335: ln_pymt_defined_balance_id
336: := pay_emp_action_arch.get_defined_balance_id(
337: p_primary_balance_id,
338: '_ASG_GRE_RUN',
339: p_legislation_code);
340: ELSE

Line 341: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN

337: p_primary_balance_id,
338: '_ASG_GRE_RUN',
339: p_legislation_code);
340: ELSE
341: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN
342: ln_pymt_defined_balance_id
343: := pay_emp_action_arch.get_defined_balance_id(
344: p_primary_balance_id,
345: '_ASG_PAYMENTS',

Line 343: := pay_emp_action_arch.get_defined_balance_id(

339: p_legislation_code);
340: ELSE
341: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN
342: ln_pymt_defined_balance_id
343: := pay_emp_action_arch.get_defined_balance_id(
344: p_primary_balance_id,
345: '_ASG_PAYMENTS',
346: p_legislation_code);
347: ELSE

Line 349: := pay_emp_action_arch.get_defined_balance_id(

345: '_ASG_PAYMENTS',
346: p_legislation_code);
347: ELSE
348: ln_pymt_defined_balance_id
349: := pay_emp_action_arch.get_defined_balance_id(
350: p_primary_balance_id,
351: '_PAYMENTS',
352: p_legislation_code);
353: END IF;

Line 368: := pay_emp_action_arch.get_defined_balance_id(

364:
365: IF p_hours_balance_id IS NOT NULL THEN
366: IF p_action_type IN ('B','V') THEN
367: ln_pymt_hours_balance_id
368: := pay_emp_action_arch.get_defined_balance_id(
369: p_hours_balance_id
370: ,'_ASG_GRE_RUN'
371: ,p_legislation_code);
372: ELSE

Line 373: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN

369: p_hours_balance_id
370: ,'_ASG_GRE_RUN'
371: ,p_legislation_code);
372: ELSE
373: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN
374: ln_pymt_hours_balance_id
375: := pay_emp_action_arch.get_defined_balance_id(
376: p_hours_balance_id
377: ,'_ASG_PAYMENTS'

Line 375: := pay_emp_action_arch.get_defined_balance_id(

371: ,p_legislation_code);
372: ELSE
373: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN
374: ln_pymt_hours_balance_id
375: := pay_emp_action_arch.get_defined_balance_id(
376: p_hours_balance_id
377: ,'_ASG_PAYMENTS'
378: ,p_legislation_code);
379: ELSE

Line 381: := pay_emp_action_arch.get_defined_balance_id(

377: ,'_ASG_PAYMENTS'
378: ,p_legislation_code);
379: ELSE
380: ln_pymt_hours_balance_id
381: := pay_emp_action_arch.get_defined_balance_id(
382: p_hours_balance_id
383: ,'_PAYMENTS'
384: ,p_legislation_code);
385: END IF;

Line 401: := pay_emp_action_arch.get_defined_balance_id(

397:
398: IF p_days_balance_id IS NOT NULL THEN
399: IF p_action_type IN ('B','V') THEN
400: ln_pymt_days_balance_id
401: := pay_emp_action_arch.get_defined_balance_id(
402: p_days_balance_id
403: ,'_ASG_GRE_RUN'
404: ,p_legislation_code);
405: ELSE

Line 406: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN

402: p_days_balance_id
403: ,'_ASG_GRE_RUN'
404: ,p_legislation_code);
405: ELSE
406: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN
407: ln_pymt_days_balance_id
408: := pay_emp_action_arch.get_defined_balance_id(
409: p_days_balance_id
410: ,'_ASG_PAYMENTS'

Line 408: := pay_emp_action_arch.get_defined_balance_id(

404: ,p_legislation_code);
405: ELSE
406: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN
407: ln_pymt_days_balance_id
408: := pay_emp_action_arch.get_defined_balance_id(
409: p_days_balance_id
410: ,'_ASG_PAYMENTS'
411: ,p_legislation_code);
412: ELSE

Line 414: := pay_emp_action_arch.get_defined_balance_id(

410: ,'_ASG_PAYMENTS'
411: ,p_legislation_code);
412: ELSE
413: ln_pymt_days_balance_id
414: := pay_emp_action_arch.get_defined_balance_id(
415: p_days_balance_id
416: ,'_PAYMENTS'
417: ,p_legislation_code);
418: END IF;

Line 489: pay_emp_action_arch.set_error_message(lv_error_message);

485:
486: hr_utility.trace(lv_error_message || '-' || SQLERRM);
487:
488: lv_error_message :=
489: pay_emp_action_arch.set_error_message(lv_error_message);
490:
491: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
492: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
493: hr_utility.raise_error;

Line 798: pay_emp_action_arch.get_defined_balance_id

794: END IF;
795:
796: ln_step := 15;
797: ln_ytd_defined_balance_id :=
798: pay_emp_action_arch.get_defined_balance_id
799: (ln_primary_balance_id,
800: gv_ytd_balance_dimension,
801: p_legislation_code);
802: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 811: pay_emp_action_arch.get_defined_balance_id

807: hr_utility.set_location(gv_package || lv_procedure_name, 70);
808: END IF;
809: IF ln_hours_balance_id IS NOT NULL THEN
810: ln_ytd_hours_balance_id :=
811: pay_emp_action_arch.get_defined_balance_id
812: (ln_hours_balance_id,
813: gv_ytd_balance_dimension,
814: p_legislation_code);
815: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 826: pay_emp_action_arch.get_defined_balance_id

822: END IF; -- Hours
823:
824: IF ln_days_balance_id IS NOT NULL THEN
825: ln_ytd_days_balance_id :=
826: pay_emp_action_arch.get_defined_balance_id
827: (ln_days_balance_id,
828: gv_ytd_balance_dimension,
829: p_legislation_code);
830: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 906: pay_emp_action_arch.set_error_message(lv_error_message);

902:
903: hr_utility.trace(lv_error_message || '-' || SQLERRM);
904:
905: lv_error_message :=
906: pay_emp_action_arch.set_error_message(lv_error_message);
907:
908: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
909: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
910: hr_utility.raise_error;

Line 1065: pay_emp_action_arch.gv_multi_payroll_pymt);

1061: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1062: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1063: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1064: hr_utility.trace('gv_multi_payroll_pymt = '||
1065: pay_emp_action_arch.gv_multi_payroll_pymt);
1066: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
1067:
1068: cn_last_xfr_action_id := p_last_xfr_action_id;
1069:

Line 1070: IF pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' AND

1066: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
1067:
1068: cn_last_xfr_action_id := p_last_xfr_action_id;
1069:
1070: IF pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' AND
1071: p_sepchk_flag = 'Y' THEN
1072:
1073: OPEN c_last_per_xfr_run;
1074: FETCH c_last_per_xfr_run INTO ln_last_per_xfr_action_id;

Line 1121: IF ((pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' ) AND

1117:
1118: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
1119: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
1120:
1121: IF ((pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' ) AND
1122: (p_sepchk_flag = 'Y') AND
1123: (ln_assignment_id <> p_assignment_id)) THEN
1124:
1125: hr_utility.trace('action_info_category = ' ||lv_act_info_category);

Line 1224: := pay_emp_action_arch.get_defined_balance_id

1220: END IF;
1221:
1222: ln_step := 15;
1223: ln_ytd_defined_balance_id
1224: := pay_emp_action_arch.get_defined_balance_id
1225: (ln_primary_balance_id,
1226: gv_ytd_balance_dimension,
1227: p_legislation_code);
1228: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 1237: := pay_emp_action_arch.get_defined_balance_id

1233: END IF;
1234: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1235: IF ln_hours_balance_id IS NOT NULL THEN
1236: ln_ytd_hours_balance_id
1237: := pay_emp_action_arch.get_defined_balance_id
1238: (ln_hours_balance_id,
1239: gv_ytd_balance_dimension,
1240: p_legislation_code);
1241: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 1252: := pay_emp_action_arch.get_defined_balance_id

1248: END IF;
1249:
1250: IF ln_days_balance_id IS NOT NULL THEN
1251: ln_ytd_days_balance_id
1252: := pay_emp_action_arch.get_defined_balance_id
1253: (ln_days_balance_id,
1254: gv_ytd_balance_dimension,
1255: p_legislation_code);
1256: hr_utility.set_location(gv_package || lv_procedure_name, 93);

Line 1332: pay_emp_action_arch.set_error_message(lv_error_message);

1328:
1329: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1330:
1331: lv_error_message :=
1332: pay_emp_action_arch.set_error_message(lv_error_message);
1333:
1334: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1335: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1336: hr_utility.raise_error;

Line 1810: pay_emp_action_arch.set_error_message(lv_error_message);

1806:
1807: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1808:
1809: lv_error_message :=
1810: pay_emp_action_arch.set_error_message(lv_error_message);
1811:
1812: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1813: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1814: hr_utility.raise_error;

Line 2196: pay_emp_action_arch.set_error_message(lv_error_message);

2192:
2193: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2194:
2195: lv_error_message :=
2196: pay_emp_action_arch.set_error_message(lv_error_message);
2197:
2198: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2199: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2200: hr_utility.raise_error;

Line 2441: pay_emp_action_arch.gv_error_message := NULL;

2437: ld_effective_date := fnd_date.canonical_to_date('1900/12/31');
2438: lv_procedure_name := '.assignment_action_code';
2439:
2440: ln_step := 1;
2441: pay_emp_action_arch.gv_error_message := NULL;
2442: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2443:
2444: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
2445: ,p_start_date => ld_start_date

Line 2595: pay_emp_action_arch.set_error_message(lv_error_message);

2591:
2592: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2593:
2594: lv_error_message :=
2595: pay_emp_action_arch.set_error_message(lv_error_message);
2596:
2597: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2598: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2599: hr_utility.raise_error;

Line 2679: pay_emp_action_arch.gv_error_message := NULL;

2675:
2676: BEGIN
2677: lv_procedure_name := '.initialization_code';
2678: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2679: pay_emp_action_arch.gv_error_message := NULL;
2680: lv_reporting_level := Null;
2681: i := 0;
2682: j := 0;
2683:

Line 2691: -- NVL(pay_emp_action_arch.get_defined_balance_id(

2687: FETCH cur_bal_type INTO lv_balance_name, ln_run_bal_type_id;
2688: EXIT WHEN cur_bal_type%NOTFOUND;
2689: -- IF lv_balance_name = 'Total Pay' THEN
2690: -- gn_payments_def_bal_id :=
2691: -- NVL(pay_emp_action_arch.get_defined_balance_id(
2692: -- ln_run_bal_type_id,
2693: -- '_ASG_GRE_RUN',
2694: -- 'MX'),-1);
2695: -- ELSE

Line 2697: NVL(pay_emp_action_arch.get_defined_balance_id(

2693: -- '_ASG_GRE_RUN',
2694: -- 'MX'),-1);
2695: -- ELSE
2696: gn_gross_earn_def_bal_id :=
2697: NVL(pay_emp_action_arch.get_defined_balance_id(
2698: ln_run_bal_type_id,
2699: '_ASG_GRE_RUN',
2700: 'MX'),-1);
2701: -- END IF;

Line 2721: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN

2717: END IF;
2718: END LOOP;
2719:
2720: ln_step := 20;
2721: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
2722: pay_emp_action_arch.gv_multi_leg_rule
2723: := pay_emp_action_arch.get_multi_legislative_rule('MX');
2724: END IF;
2725:

Line 2722: pay_emp_action_arch.gv_multi_leg_rule

2718: END LOOP;
2719:
2720: ln_step := 20;
2721: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
2722: pay_emp_action_arch.gv_multi_leg_rule
2723: := pay_emp_action_arch.get_multi_legislative_rule('MX');
2724: END IF;
2725:
2726: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);

Line 2723: := pay_emp_action_arch.get_multi_legislative_rule('MX');

2719:
2720: ln_step := 20;
2721: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
2722: pay_emp_action_arch.gv_multi_leg_rule
2723: := pay_emp_action_arch.get_multi_legislative_rule('MX');
2724: END IF;
2725:
2726: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
2727: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);

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

2723: := pay_emp_action_arch.get_multi_legislative_rule('MX');
2724: END IF;
2725:
2726: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
2727: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
2728: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2729:
2730: ln_step := 30;
2731: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN

Line 2731: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN

2727: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
2728: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2729:
2730: ln_step := 30;
2731: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN
2732: lv_pymt_dimension := '_ASG_PAYMENTS';
2733: -- lv_jd_pymt_dimension := '_ASG_PAYMENTS_JD';
2734: ELSE
2735: lv_pymt_dimension := '_PAYMENTS';

Line 2753: pay_emp_action_arch.get_defined_balance_id(

2749:
2750:
2751: ln_step := 60;
2752: ln_pymt_def_bal_id :=
2753: pay_emp_action_arch.get_defined_balance_id(
2754: c_dbt.balance_type_id,
2755: lv_pymt_dimension,
2756: 'MX');
2757:

Line 2760: pay_emp_action_arch.get_defined_balance_id(

2756: 'MX');
2757:
2758: ln_step := 70;
2759: ln_gre_ytd_def_bal_id :=
2760: pay_emp_action_arch.get_defined_balance_id(
2761: c_dbt.balance_type_id,
2762: '_ASG_GRE_YTD',
2763: 'MX');
2764:

Line 2767: pay_emp_action_arch.get_defined_balance_id(

2763: 'MX');
2764:
2765: ln_step := 80;
2766: ln_run_def_bal_id :=
2767: pay_emp_action_arch.get_defined_balance_id(
2768: c_dbt.balance_type_id,
2769: '_ASG_GRE_RUN',
2770: 'MX');
2771:

Line 2823: pay_emp_action_arch.set_error_message(lv_error_message);

2819: ' IN ' || gv_package || lv_procedure_name;
2820: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2821:
2822: lv_error_message :=
2823: pay_emp_action_arch.set_error_message(lv_error_message);
2824:
2825: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2826: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2827: hr_utility.raise_error;

Line 3044: pay_emp_action_arch.set_error_message(lv_error_message);

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

Line 3169: pay_emp_action_arch.set_error_message(lv_error_message);

3165:
3166: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3167:
3168: lv_error_message :=
3169: pay_emp_action_arch.set_error_message(lv_error_message);
3170:
3171: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3172: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3173: hr_utility.raise_error;

Line 3179: ** pay_emp_action_arch.lrr_act_tab with the following

3175: END update_employee_information;
3176:
3177: /**********************************************************************
3178: ** Procedure get_mx_personal_information populates
3179: ** pay_emp_action_arch.lrr_act_tab with the following
3180: ** action_information_contexts :
3181: **
3182: ** MX EMPLOYEE DETAILS
3183: **

Line 3276: pay_emp_action_arch.initialization_process;

3272: lv_exists := 'N';
3273:
3274: hr_utility.trace('Entered get_mx_personal_information');
3275: ln_step := 1;
3276: pay_emp_action_arch.initialization_process;
3277:
3278: hr_utility.trace('p_assactid = ' || p_assactid);--
3279: hr_utility.trace('p_assignment_id = ' || p_assignment_id);--
3280: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);

Line 3311: ln_index := pay_emp_action_arch.lrr_act_tab.count;

3307: ln_fixed_idw,
3308: ln_variable_idw);
3309:
3310: --
3311: ln_index := pay_emp_action_arch.lrr_act_tab.count;
3312:
3313: hr_utility.trace('ln_index IN get_mx_personal_information proc IS '
3314: || pay_emp_action_arch.lrr_act_tab.count);
3315:

Line 3314: || pay_emp_action_arch.lrr_act_tab.count);

3310: --
3311: ln_index := pay_emp_action_arch.lrr_act_tab.count;
3312:
3313: hr_utility.trace('ln_index IN get_mx_personal_information proc IS '
3314: || pay_emp_action_arch.lrr_act_tab.count);
3315:
3316: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
3317: := 'MX EMPLOYEE DETAILS';
3318: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1

Line 3316: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category

3312:
3313: hr_utility.trace('ln_index IN get_mx_personal_information proc IS '
3314: || pay_emp_action_arch.lrr_act_tab.count);
3315:
3316: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
3317: := 'MX EMPLOYEE DETAILS';
3318: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
3319: := lv_ee_ss_id;
3320: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2

Line 3318: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1

3314: || pay_emp_action_arch.lrr_act_tab.count);
3315:
3316: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
3317: := 'MX EMPLOYEE DETAILS';
3318: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
3319: := lv_ee_ss_id;
3320: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3321: := lv_ee_rfc_id;
3322: pay_emp_action_arch.lrr_act_tab(ln_index).act_info3

Line 3320: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2

3316: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
3317: := 'MX EMPLOYEE DETAILS';
3318: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
3319: := lv_ee_ss_id;
3320: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3321: := lv_ee_rfc_id;
3322: pay_emp_action_arch.lrr_act_tab(ln_index).act_info3
3323: := ln_total_idw;
3324:

Line 3322: pay_emp_action_arch.lrr_act_tab(ln_index).act_info3

3318: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
3319: := lv_ee_ss_id;
3320: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3321: := lv_ee_rfc_id;
3322: pay_emp_action_arch.lrr_act_tab(ln_index).act_info3
3323: := ln_total_idw;
3324:
3325:
3326: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN

Line 3326: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN

3322: pay_emp_action_arch.lrr_act_tab(ln_index).act_info3
3323: := ln_total_idw;
3324:
3325:
3326: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN
3327: ln_step := 4;
3328: pay_emp_action_arch.insert_rows_thro_api_process(
3329: p_action_context_id => p_assactid
3330: ,p_action_context_type => 'AAP'

Line 3328: pay_emp_action_arch.insert_rows_thro_api_process(

3324:
3325:
3326: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN
3327: ln_step := 4;
3328: pay_emp_action_arch.insert_rows_thro_api_process(
3329: p_action_context_id => p_assactid
3330: ,p_action_context_type => 'AAP'
3331: ,p_assignment_id => p_assignment_id
3332: ,p_tax_unit_id => p_tax_unit_id

Line 3334: ,p_tab_rec_data => pay_emp_action_arch.lrr_act_tab

3330: ,p_action_context_type => 'AAP'
3331: ,p_assignment_id => p_assignment_id
3332: ,p_tax_unit_id => p_tax_unit_id
3333: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
3334: ,p_tab_rec_data => pay_emp_action_arch.lrr_act_tab
3335: );
3336: END IF;
3337:
3338: EXCEPTION

Line 3346: pay_emp_action_arch.set_error_message(lv_error_message);

3342:
3343: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3344:
3345: lv_error_message :=
3346: pay_emp_action_arch.set_error_message(lv_error_message);
3347:
3348: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3349: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3350: hr_utility.raise_error;

Line 3511: pay_emp_action_arch.set_error_message(lv_error_message);

3507:
3508: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3509:
3510: lv_error_message :=
3511: pay_emp_action_arch.set_error_message(lv_error_message);
3512:
3513: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3514: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3515: hr_utility.raise_error;

Line 3781: pay_emp_action_arch.get_personal_information(

3777: END IF; /* p_archive_balance_info = 'Y' */
3778:
3779: hr_utility.set_location(gv_package || lv_procedure_name, 150);
3780: ln_step := 14;
3781: pay_emp_action_arch.get_personal_information(
3782: p_payroll_action_id => p_xfr_payroll_action_id
3783: ,p_assactid => p_xfr_action_id
3784: ,p_assignment_id => p_assignment_id
3785: ,p_curr_pymt_ass_act_id => p_pre_pay_action_id

Line 3814: pay_emp_action_arch.insert_rows_thro_api_process(

3810: );
3811:
3812: hr_utility.set_location(gv_package || lv_procedure_name, 210);
3813: ln_step := 16;
3814: pay_emp_action_arch.insert_rows_thro_api_process(
3815: p_action_context_id => p_xfr_action_id
3816: ,p_action_context_type=> 'AAP'
3817: ,p_assignment_id => p_assignment_id
3818: ,p_tax_unit_id => p_tax_unit_id

Line 3839: pay_emp_action_arch.set_error_message(lv_error_message);

3835:
3836: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3837:
3838: lv_error_message :=
3839: pay_emp_action_arch.set_error_message(lv_error_message);
3840:
3841: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3842: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3843: hr_utility.raise_error;

Line 3932: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;

3928: hr_utility.trace('lv_legal_employer_name: ' || lv_legal_employer_name);
3929: hr_utility.trace('lv_er_rfc_id ' || lv_er_rfc_id);
3930: hr_utility.trace('lv_er_ss_id ' || lv_er_ss_id);
3931:
3932: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3933: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3934: := 'MX EMPLOYER DETAILS';
3935: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3936: := NULL;

Line 3933: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category

3929: hr_utility.trace('lv_er_rfc_id ' || lv_er_rfc_id);
3930: hr_utility.trace('lv_er_ss_id ' || lv_er_ss_id);
3931:
3932: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3933: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3934: := 'MX EMPLOYER DETAILS';
3935: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3936: := NULL;
3937: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

Line 3935: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code

3931:
3932: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3933: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3934: := 'MX EMPLOYER DETAILS';
3935: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3936: := NULL;
3937: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3938: := p_legal_er_id;
3939: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

Line 3937: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

3933: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3934: := 'MX EMPLOYER DETAILS';
3935: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3936: := NULL;
3937: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3938: := p_legal_er_id;
3939: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3940: := lv_legal_employer_name;
3941: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info3

Line 3939: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

3935: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3936: := NULL;
3937: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3938: := p_legal_er_id;
3939: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3940: := lv_legal_employer_name;
3941: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info3
3942: := lv_er_ss_id;
3943: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

Line 3941: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info3

3937: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3938: := p_legal_er_id;
3939: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3940: := lv_legal_employer_name;
3941: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info3
3942: := lv_er_ss_id;
3943: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3944: := lv_er_rfc_id ;
3945:

Line 3943: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

3939: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3940: := lv_legal_employer_name;
3941: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info3
3942: := lv_er_ss_id;
3943: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3944: := lv_er_rfc_id ;
3945:
3946: END get_legal_er_details;
3947:

Line 3974: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;

3970: CLOSE c_get_gre_details;
3971:
3972: hr_utility.trace('lv_er_ss_id ' || lv_er_ss_id);
3973:
3974: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3975: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3976: := 'MX EMPLOYER DETAILS';
3977: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3978: := NULL;

Line 3975: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category

3971:
3972: hr_utility.trace('lv_er_ss_id ' || lv_er_ss_id);
3973:
3974: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3975: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3976: := 'MX EMPLOYER DETAILS';
3977: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3978: := NULL;
3979: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

Line 3977: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code

3973:
3974: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3975: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3976: := 'MX EMPLOYER DETAILS';
3977: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3978: := NULL;
3979: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3980: := p_gre_id;
3981: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info3

Line 3979: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

3975: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3976: := 'MX EMPLOYER DETAILS';
3977: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3978: := NULL;
3979: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3980: := p_gre_id;
3981: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info3
3982: := lv_er_ss_id;
3983:

Line 3981: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info3

3977: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3978: := NULL;
3979: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3980: := p_gre_id;
3981: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info3
3982: := lv_er_ss_id;
3983:
3984: END get_gre_details;
3985:

Line 4033: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;

4029:
4030:
4031: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4032:
4033: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4034: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4035: := 'EMPLOYEE OTHER INFORMATION';
4036: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4037: := NULL;

Line 4034: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category

4030:
4031: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4032:
4033: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4034: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4035: := 'EMPLOYEE OTHER INFORMATION';
4036: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4037: := NULL;
4038: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

Line 4036: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code

4032:
4033: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4034: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4035: := 'EMPLOYEE OTHER INFORMATION';
4036: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4037: := NULL;
4038: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4039: := p_organization_id;
4040: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

Line 4038: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

4034: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4035: := 'EMPLOYEE OTHER INFORMATION';
4036: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4037: := NULL;
4038: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4039: := p_organization_id;
4040: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
4041: := 'MESG';
4042: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

Line 4040: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

4036: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4037: := NULL;
4038: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4039: := p_organization_id;
4040: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
4041: := 'MESG';
4042: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
4043: := NVL(lv_org_information7,lv_org_information4) ;
4044: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

Line 4042: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

4038: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4039: := p_organization_id;
4040: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
4041: := 'MESG';
4042: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
4043: := NVL(lv_org_information7,lv_org_information4) ;
4044: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
4045: := lv_org_information5 ;
4046: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

Line 4044: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

4040: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
4041: := 'MESG';
4042: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
4043: := NVL(lv_org_information7,lv_org_information4) ;
4044: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
4045: := lv_org_information5 ;
4046: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
4047: := lv_org_information6;
4048: END LOOP ;

Line 4046: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

4042: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
4043: := NVL(lv_org_information7,lv_org_information4) ;
4044: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
4045: := lv_org_information5 ;
4046: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
4047: := lv_org_information6;
4048: END LOOP ;
4049: CLOSE c_get_other_info;
4050:

Line 4069: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;

4065: EXIT;
4066: END IF;
4067:
4068: hr_utility.set_location(gv_package || lv_procedure_name, 130);
4069: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4070: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4071: := 'EMPLOYEE OTHER INFORMATION';
4072: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4073: := NULL;

Line 4070: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category

4066: END IF;
4067:
4068: hr_utility.set_location(gv_package || lv_procedure_name, 130);
4069: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4070: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4071: := 'EMPLOYEE OTHER INFORMATION';
4072: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4073: := NULL;
4074: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

Line 4072: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code

4068: hr_utility.set_location(gv_package || lv_procedure_name, 130);
4069: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4070: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4071: := 'EMPLOYEE OTHER INFORMATION';
4072: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4073: := NULL;
4074: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4075: := p_business_group_id;
4076: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

Line 4074: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

4070: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4071: := 'EMPLOYEE OTHER INFORMATION';
4072: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4073: := NULL;
4074: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4075: := p_business_group_id;
4076: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
4077: := 'MESG';
4078: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

Line 4076: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

4072: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4073: := NULL;
4074: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4075: := p_business_group_id;
4076: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
4077: := 'MESG';
4078: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
4079: := NVL(lv_org_information7,lv_org_information4) ;
4080: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

Line 4078: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

4074: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4075: := p_business_group_id;
4076: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
4077: := 'MESG';
4078: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
4079: := NVL(lv_org_information7,lv_org_information4) ;
4080: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
4081: := lv_org_information5 ;
4082: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

Line 4080: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

4076: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
4077: := 'MESG';
4078: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
4079: := NVL(lv_org_information7,lv_org_information4) ;
4080: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
4081: := lv_org_information5 ;
4082: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
4083: := lv_org_information6;
4084: END LOOP ;

Line 4082: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

4078: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
4079: := NVL(lv_org_information7,lv_org_information4) ;
4080: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
4081: := lv_org_information5 ;
4082: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
4083: := lv_org_information6;
4084: END LOOP ;
4085: CLOSE c_get_other_info;
4086: hr_utility.set_location(gv_package || lv_procedure_name, 140);

Line 4141: IF pay_emp_action_arch.ltr_ppa_arch_data.count > 0 THEN

4137: ,lv_er_telephone;
4138: CLOSE c_addr_line;
4139: hr_utility.set_location(gv_package || lv_procedure_name, 250);
4140:
4141: IF pay_emp_action_arch.ltr_ppa_arch_data.count > 0 THEN
4142: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..
4143: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP
4144: IF pay_emp_action_arch.ltr_ppa_arch_data(i).act_info1
4145: = ln_organization_id AND

Line 4142: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..

4138: CLOSE c_addr_line;
4139: hr_utility.set_location(gv_package || lv_procedure_name, 250);
4140:
4141: IF pay_emp_action_arch.ltr_ppa_arch_data.count > 0 THEN
4142: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..
4143: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP
4144: IF pay_emp_action_arch.ltr_ppa_arch_data(i).act_info1
4145: = ln_organization_id AND
4146: pay_emp_action_arch.ltr_ppa_arch_data(i).act_info14

Line 4143: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP

4139: hr_utility.set_location(gv_package || lv_procedure_name, 250);
4140:
4141: IF pay_emp_action_arch.ltr_ppa_arch_data.count > 0 THEN
4142: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..
4143: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP
4144: IF pay_emp_action_arch.ltr_ppa_arch_data(i).act_info1
4145: = ln_organization_id AND
4146: pay_emp_action_arch.ltr_ppa_arch_data(i).act_info14
4147: = 'Employer Address' THEN

Line 4144: IF pay_emp_action_arch.ltr_ppa_arch_data(i).act_info1

4140:
4141: IF pay_emp_action_arch.ltr_ppa_arch_data.count > 0 THEN
4142: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..
4143: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP
4144: IF pay_emp_action_arch.ltr_ppa_arch_data(i).act_info1
4145: = ln_organization_id AND
4146: pay_emp_action_arch.ltr_ppa_arch_data(i).act_info14
4147: = 'Employer Address' THEN
4148: lv_exists := 'Y';

Line 4146: pay_emp_action_arch.ltr_ppa_arch_data(i).act_info14

4142: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..
4143: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP
4144: IF pay_emp_action_arch.ltr_ppa_arch_data(i).act_info1
4145: = ln_organization_id AND
4146: pay_emp_action_arch.ltr_ppa_arch_data(i).act_info14
4147: = 'Employer Address' THEN
4148: lv_exists := 'Y';
4149: EXIT;
4150: END IF;

Line 4156: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;

4152: END IF;
4153:
4154: IF lv_exists = 'N' THEN
4155: hr_utility.set_location(gv_package || lv_procedure_name, 260);
4156: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4157:
4158: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4159: := 'ADDRESS DETAILS';
4160: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code

Line 4158: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category

4154: IF lv_exists = 'N' THEN
4155: hr_utility.set_location(gv_package || lv_procedure_name, 260);
4156: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4157:
4158: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4159: := 'ADDRESS DETAILS';
4160: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4161: := NULL;
4162: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

Line 4160: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code

4156: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4157:
4158: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4159: := 'ADDRESS DETAILS';
4160: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4161: := NULL;
4162: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4163: := ln_organization_id;
4164: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

Line 4162: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

4158: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4159: := 'ADDRESS DETAILS';
4160: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4161: := NULL;
4162: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4163: := ln_organization_id;
4164: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
4165: := lv_er_address_line_1 ;
4166: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

Line 4164: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

4160: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4161: := NULL;
4162: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4163: := ln_organization_id;
4164: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
4165: := lv_er_address_line_1 ;
4166: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
4167: := lv_er_address_line_2;
4168: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7

Line 4166: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

4162: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
4163: := ln_organization_id;
4164: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
4165: := lv_er_address_line_1 ;
4166: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
4167: := lv_er_address_line_2;
4168: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
4169: := lv_er_address_line_3;
4170: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8

Line 4168: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7

4164: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
4165: := lv_er_address_line_1 ;
4166: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
4167: := lv_er_address_line_2;
4168: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
4169: := lv_er_address_line_3;
4170: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
4171: := lv_er_town_or_city;
4172: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9

Line 4170: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8

4166: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
4167: := lv_er_address_line_2;
4168: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
4169: := lv_er_address_line_3;
4170: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
4171: := lv_er_town_or_city;
4172: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
4173: := lv_er_region_1;
4174: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10

Line 4172: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9

4168: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
4169: := lv_er_address_line_3;
4170: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
4171: := lv_er_town_or_city;
4172: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
4173: := lv_er_region_1;
4174: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
4175: := lv_er_region_2;
4176: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11

Line 4174: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10

4170: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
4171: := lv_er_town_or_city;
4172: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
4173: := lv_er_region_1;
4174: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
4175: := lv_er_region_2;
4176: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
4177: := lv_er_region_3 ;
4178: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12

Line 4176: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11

4172: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
4173: := lv_er_region_1;
4174: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
4175: := lv_er_region_2;
4176: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
4177: := lv_er_region_3 ;
4178: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
4179: := lv_er_postal_code;
4180: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13

Line 4178: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12

4174: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
4175: := lv_er_region_2;
4176: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
4177: := lv_er_region_3 ;
4178: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
4179: := lv_er_postal_code;
4180: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
4181: := lv_er_country;
4182: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info14

Line 4180: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13

4176: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
4177: := lv_er_region_3 ;
4178: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
4179: := lv_er_postal_code;
4180: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
4181: := lv_er_country;
4182: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info14
4183: := lv_ee_or_er;
4184: END IF;

Line 4182: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info14

4178: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
4179: := lv_er_postal_code;
4180: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
4181: := lv_er_country;
4182: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info14
4183: := lv_ee_or_er;
4184: END IF;
4185:
4186: END get_legal_ER_address;

Line 4252: IF pay_emp_action_arch.ltr_ppa_arch.count > 0 THEN

4248:
4249: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4250:
4251: -- insert rows in pay_action_information table
4252: IF pay_emp_action_arch.ltr_ppa_arch.count > 0 THEN
4253: pay_emp_action_arch.insert_rows_thro_api_process(
4254: p_action_context_id => p_payroll_action_id
4255: ,p_action_context_type => 'PA'
4256: ,p_assignment_id => NULL

Line 4253: pay_emp_action_arch.insert_rows_thro_api_process(

4249: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4250:
4251: -- insert rows in pay_action_information table
4252: IF pay_emp_action_arch.ltr_ppa_arch.count > 0 THEN
4253: pay_emp_action_arch.insert_rows_thro_api_process(
4254: p_action_context_id => p_payroll_action_id
4255: ,p_action_context_type => 'PA'
4256: ,p_assignment_id => NULL
4257: ,p_tax_unit_id => NULL

Line 4259: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch

4255: ,p_action_context_type => 'PA'
4256: ,p_assignment_id => NULL
4257: ,p_tax_unit_id => NULL
4258: ,p_curr_pymt_eff_date => p_effective_date
4259: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch
4260: );
4261: END IF;
4262: EXCEPTION
4263: WHEN OTHERS THEN

Line 4554: := pay_emp_action_arch.get_defined_balance_id(

4550: IF ln_hours_balance_id IS NOT NULL THEN
4551: ln_step := 40;
4552: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4553: ln_ytd_hours_balance_id
4554: := pay_emp_action_arch.get_defined_balance_id(
4555: ln_hours_balance_id,
4556: gv_ytd_balance_dimension,
4557: p_legislation_code);
4558: hr_utility.trace('ln_ytd_hours_balance_id = '||

Line 4578: := pay_emp_action_arch.get_defined_balance_id(

4574: IF ln_days_balance_id IS NOT NULL THEN
4575: ln_step := 60;
4576: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4577: ln_ytd_days_balance_id
4578: := pay_emp_action_arch.get_defined_balance_id(
4579: ln_days_balance_id,
4580: gv_ytd_balance_dimension,
4581: p_legislation_code);
4582: hr_utility.trace('ln_ytd_days_balance_id = '||

Line 4600: := pay_emp_action_arch.get_defined_balance_id

4596:
4597:
4598: ln_step := 80;
4599: ln_ytd_defined_balance_id
4600: := pay_emp_action_arch.get_defined_balance_id
4601: (ln_primary_balance_id,
4602: gv_ytd_balance_dimension,
4603: p_legislation_code);
4604: hr_utility.trace('ln_ytd_defined_balance_id = '||

Line 4720: pay_emp_action_arch.set_error_message(lv_error_message);

4716:
4717: hr_utility.trace(lv_error_message || '-' || SQLERRM);
4718:
4719: lv_error_message :=
4720: pay_emp_action_arch.set_error_message(lv_error_message);
4721:
4722: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4723: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4724: hr_utility.raise_error;

Line 4935: pay_emp_action_arch.gv_error_message := NULL;

4931: ln_old_term_asg_id := '-1';
4932: lv_archive_balance_info := 'Y';
4933:
4934:
4935: pay_emp_action_arch.gv_error_message := NULL;
4936: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4937: ln_step := 1;
4938: OPEN c_xfr_info (p_xfr_action_id);
4939: FETCH c_xfr_info INTO ln_xfr_payroll_action_id,

Line 4958: pay_emp_action_arch.gv_multi_payroll_pymt

4954:
4955: hr_utility.set_location(gv_package || lv_procedure_name, 15);
4956:
4957: ln_step := 205;
4958: pay_emp_action_arch.gv_multi_payroll_pymt
4959: := pay_emp_action_arch.get_multi_assignment_flag(
4960: p_payroll_id => ln_payroll_id
4961: ,p_effective_date => ld_end_date);
4962:

Line 4959: := pay_emp_action_arch.get_multi_assignment_flag(

4955: hr_utility.set_location(gv_package || lv_procedure_name, 15);
4956:
4957: ln_step := 205;
4958: pay_emp_action_arch.gv_multi_payroll_pymt
4959: := pay_emp_action_arch.get_multi_assignment_flag(
4960: p_payroll_id => ln_payroll_id
4961: ,p_effective_date => ld_end_date);
4962:
4963: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||

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

4959: := pay_emp_action_arch.get_multi_assignment_flag(
4960: p_payroll_id => ln_payroll_id
4961: ,p_effective_date => ld_end_date);
4962:
4963: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
4964: pay_emp_action_arch.gv_multi_payroll_pymt);
4965:
4966: ln_step := 3;
4967: OPEN c_legislation (ln_business_group_id);

Line 4964: pay_emp_action_arch.gv_multi_payroll_pymt);

4960: p_payroll_id => ln_payroll_id
4961: ,p_effective_date => ld_end_date);
4962:
4963: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
4964: pay_emp_action_arch.gv_multi_payroll_pymt);
4965:
4966: ln_step := 3;
4967: OPEN c_legislation (ln_business_group_id);
4968: FETCH c_legislation INTO lv_legislation_code ;

Line 5205: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' THEN

5201:
5202: ln_step := 21;
5203: IF ln_earnings = 0 AND
5204: ln_xfr_assignment_id = ln_assignment_id AND
5205: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' THEN
5206: ln_earnings := 1;
5207: lv_archive_balance_info := 'N';
5208: ELSE
5209: lv_archive_balance_info := 'Y';

Line 5293: pay_emp_action_arch.insert_rows_thro_api_process(

5289: ,p_action_type => lv_master_action_type);
5290:
5291: hr_utility.trace('Done Populating Tax Balances FOR Reversals');
5292: ln_step := 28;
5293: pay_emp_action_arch.insert_rows_thro_api_process(
5294: p_action_context_id => p_xfr_action_id
5295: ,p_action_context_type=> 'AAP'
5296: ,p_assignment_id => ln_assignment_id
5297: ,p_tax_unit_id => ln_tax_unit_id

Line 5352: pay_emp_action_arch.insert_rows_thro_api_process(

5348: END LOOP;
5349: CLOSE c_get_emp_adjbal;
5350:
5351: ln_step := 32;
5352: pay_emp_action_arch.insert_rows_thro_api_process(
5353: p_action_context_id => p_xfr_action_id
5354: ,p_action_context_type=> 'AAP'
5355: ,p_assignment_id => ln_assignment_id
5356: ,p_tax_unit_id => ln_tax_unit_id

Line 5395: pay_emp_action_arch.set_error_message(lv_error_message);

5391:
5392: hr_utility.trace(lv_error_message || '-' || SQLERRM);
5393:
5394: lv_error_message :=
5395: pay_emp_action_arch.set_error_message(lv_error_message);
5396:
5397: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5398: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5399: hr_utility.raise_error;