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

Line 94: pay_emp_action_arch.set_error_message(lv_error_message);

90: lv_error_message := 'Error at step ' || ln_step ||' IN '||gv_package || lv_procedure_name;
91: hr_utility.trace(lv_error_message || '-' || SQLERRM);
92:
93: lv_error_message :=
94: pay_emp_action_arch.set_error_message(lv_error_message);
95:
96: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
97: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
98: hr_utility.raise_error;

Line 193: pay_emp_action_arch.set_error_message(lv_error_message);

189:
190: hr_utility.trace(lv_error_message || '-' || SQLERRM);
191:
192: lv_error_message :=
193: pay_emp_action_arch.set_error_message(lv_error_message);
194: hr_utility.raise_error;
195: END get_element_payment_hours;
196:
197:

Line 280: pay_emp_action_arch.initialization_process;

276: ln_step := 2;
277:
278: hr_utility.set_location(gv_package || lv_procedure_name, 20);
279:
280: pay_emp_action_arch.initialization_process;
281: hr_utility.trace('Initialized PL/SQL table');
282:
283: ln_index := pay_emp_action_arch.lrr_act_tab.count;
284:

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

279:
280: pay_emp_action_arch.initialization_process;
281: hr_utility.trace('Initialized PL/SQL table');
282:
283: ln_index := pay_emp_action_arch.lrr_act_tab.count;
284:
285: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
286: := lv_action_category;
287: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1

Line 285: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category

281: hr_utility.trace('Initialized PL/SQL table');
282:
283: ln_index := pay_emp_action_arch.lrr_act_tab.count;
284:
285: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
286: := lv_action_category;
287: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
288: := lv_first_name;
289: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2

Line 287: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1

283: ln_index := pay_emp_action_arch.lrr_act_tab.count;
284:
285: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
286: := lv_action_category;
287: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
288: := lv_first_name;
289: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
290: := lv_last_name;
291: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4

Line 289: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2

285: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
286: := lv_action_category;
287: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
288: := lv_first_name;
289: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
290: := lv_last_name;
291: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
292: := lv_prefix;
293: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5

Line 291: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4

287: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
288: := lv_first_name;
289: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
290: := lv_last_name;
291: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
292: := lv_prefix;
293: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
294: := lv_suffix;
295: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6

Line 293: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5

289: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
290: := lv_last_name;
291: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
292: := lv_prefix;
293: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
294: := lv_suffix;
295: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
296: := lv_middle_name;
297: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7

Line 295: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6

291: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
292: := lv_prefix;
293: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
294: := lv_suffix;
295: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
296: := lv_middle_name;
297: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
298: := lv_known_as;
299: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8

Line 297: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7

293: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
294: := lv_suffix;
295: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
296: := lv_middle_name;
297: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
298: := lv_known_as;
299: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
300: := lv_title;
301: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9

Line 299: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8

295: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
296: := lv_middle_name;
297: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
298: := lv_known_as;
299: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
300: := lv_title;
301: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
302: := lv_sex;
303: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10

Line 301: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9

297: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
298: := lv_known_as;
299: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
300: := lv_title;
301: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
302: := lv_sex;
303: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
304: := lv_marital_status;
305: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11

Line 303: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10

299: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
300: := lv_title;
301: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
302: := lv_sex;
303: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
304: := lv_marital_status;
305: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
306: := lv_nationality;
307: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12

Line 305: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11

301: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
302: := lv_sex;
303: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
304: := lv_marital_status;
305: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
306: := lv_nationality;
307: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
308: := lv_work_at_home;
309:

Line 307: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12

303: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
304: := lv_marital_status;
305: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
306: := lv_nationality;
307: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
308: := lv_work_at_home;
309:
310: ln_step := 3;
311:

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

312: /* api call to insert the data into pay_action_information table with
313: information category as 'IP EMPLOYEE ADDITIONAL DETAILS' */
314:
315: hr_utility.set_location(gv_package || lv_procedure_name, 30);
316: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN
317: pay_emp_action_arch.insert_rows_thro_api_process(
318: p_action_context_id => p_assactid
319: ,p_action_context_type=> 'AAP'
320: ,p_assignment_id => p_assignment_id

Line 317: pay_emp_action_arch.insert_rows_thro_api_process(

313: information category as 'IP EMPLOYEE ADDITIONAL DETAILS' */
314:
315: hr_utility.set_location(gv_package || lv_procedure_name, 30);
316: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN
317: pay_emp_action_arch.insert_rows_thro_api_process(
318: p_action_context_id => p_assactid
319: ,p_action_context_type=> 'AAP'
320: ,p_assignment_id => p_assignment_id
321: ,p_tax_unit_id => p_tax_unit_id

Line 323: ,p_tab_rec_data => pay_emp_action_arch.lrr_act_tab

319: ,p_action_context_type=> 'AAP'
320: ,p_assignment_id => p_assignment_id
321: ,p_tax_unit_id => p_tax_unit_id
322: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
323: ,p_tab_rec_data => pay_emp_action_arch.lrr_act_tab
324: );
325: END IF;
326: ln_step := 4;
327: hr_utility.set_location(gv_package || lv_procedure_name, 40);

Line 336: pay_emp_action_arch.set_error_message(lv_error_message);

332: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
333: hr_utility.trace(lv_error_message || '-' || SQLERRM);
334:
335: lv_error_message :=
336: pay_emp_action_arch.set_error_message(lv_error_message);
337: hr_utility.raise_error;
338: END get_employee_information;
339:
340: /******************************************************************

Line 448: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN

444: ||to_char(p_sepchk_flag));
445: hr_utility.trace('p_action_type '
446: ||to_char(p_action_type));
447:
448: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
449: pay_emp_action_arch.gv_multi_leg_rule
450: := pay_emp_action_arch.get_multi_legislative_rule(
451: p_legislation_code);
452: END IF;

Line 449: pay_emp_action_arch.gv_multi_leg_rule

445: hr_utility.trace('p_action_type '
446: ||to_char(p_action_type));
447:
448: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
449: pay_emp_action_arch.gv_multi_leg_rule
450: := pay_emp_action_arch.get_multi_legislative_rule(
451: p_legislation_code);
452: END IF;
453:

Line 450: := pay_emp_action_arch.get_multi_legislative_rule(

446: ||to_char(p_action_type));
447:
448: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
449: pay_emp_action_arch.gv_multi_leg_rule
450: := pay_emp_action_arch.get_multi_legislative_rule(
451: p_legislation_code);
452: END IF;
453:
454: ln_step := 2;

Line 460: := pay_emp_action_arch.get_defined_balance_id(

456: ** Get the defined balance_id for YTD call as it will be
457: ** same for all classification types.
458: *********************************************************/
459: ln_ytd_defined_balance_id
460: := pay_emp_action_arch.get_defined_balance_id(
461: p_primary_balance_id,
462: gv_ytd_balance_dimension,
463: p_legislation_code);
464:

Line 471: := pay_emp_action_arch.get_defined_balance_id(

467: ln_step := 3;
468: IF p_hours_balance_id IS NOT NULL THEN
469: hr_utility.set_location(gv_package || lv_procedure_name, 20);
470: ln_ytd_hours_def_balance_id
471: := pay_emp_action_arch.get_defined_balance_id(
472: p_hours_balance_id,
473: gv_ytd_balance_dimension,
474: p_legislation_code);
475:

Line 514: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

510: lv_balance_name := pay_ip_utility.get_balance_name(p_primary_balance_id);
511: lv_error_message := 'Defined Balance for the combination "'
512: || lv_balance_name ||'" and "'
513: ||gv_ytd_balance_dimension||'" not exist';
514: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
515: hr_utility.trace('YTD Dimension is not set for Primary balance');
516: hr_utility.trace('Primary balance ID '||p_primary_balance_id);
517: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);
518: hr_utility.raise_error;

Line 533: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

529: lv_balance_name := pay_ip_utility.get_balance_name(p_hours_balance_id);
530: lv_error_message := 'Defined Balance for the combination "'
531: || lv_balance_name ||'" and "'
532: ||gv_ytd_balance_dimension||'" not exist';
533: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
534: hr_utility.trace('YTD Dimension is not set for Primary Hours balance '||p_reporting_name);
535: hr_utility.raise_error;
536: END IF; -- if 4
537: END IF; --Hours -- if 3

Line 546: := pay_emp_action_arch.get_defined_balance_id(

542: IF p_action_type ='B' THEN /*This condition always false for IP. The range cursor doesn't pick the
543: Balance Adjustment actions because of future_process_mode check */
544: -- if 6
545: ln_pymt_defined_balance_id
546: := pay_emp_action_arch.get_defined_balance_id(
547: p_primary_balance_id,
548: '_ASG_RUN',
549: p_legislation_code);
550: ELSE

Line 551: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN --if 7

547: p_primary_balance_id,
548: '_ASG_RUN',
549: p_legislation_code);
550: ELSE
551: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN --if 7
552: ln_pymt_defined_balance_id
553: := pay_emp_action_arch.get_defined_balance_id(
554: p_primary_balance_id,
555: '_ASG_PAYMENTS',

Line 553: := pay_emp_action_arch.get_defined_balance_id(

549: p_legislation_code);
550: ELSE
551: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN --if 7
552: ln_pymt_defined_balance_id
553: := pay_emp_action_arch.get_defined_balance_id(
554: p_primary_balance_id,
555: '_ASG_PAYMENTS',
556: p_legislation_code);
557: ELSE

Line 559: := pay_emp_action_arch.get_defined_balance_id(

555: '_ASG_PAYMENTS',
556: p_legislation_code);
557: ELSE
558: ln_pymt_defined_balance_id
559: := pay_emp_action_arch.get_defined_balance_id(
560: p_primary_balance_id,
561: '_PAYMENTS',
562: p_legislation_code);
563: END IF; --if 7

Line 586: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

582:
583: lv_balance_name := pay_ip_utility.get_balance_name(p_primary_balance_id);
584: lv_error_message := 'Defined Balance for the combination "'
585: || lv_balance_name ||'" and "_PAYMENTS" not exist';
586: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
587:
588: hr_utility.set_location(gv_package || lv_procedure_name, 90);
589: hr_utility.trace('Dimension is not set for Primary balance '||p_primary_balance_id);
590: hr_utility.raise_error;

Line 597: := pay_emp_action_arch.get_defined_balance_id(

593: ln_step := 10;
594: IF p_hours_balance_id IS NOT NULL THEN --if 9
595: IF p_action_type IN ('B') THEN -- if 10
596: ln_pymt_hours_balance_id
597: := pay_emp_action_arch.get_defined_balance_id(
598: p_hours_balance_id
599: ,'_ASG_RUN'
600: ,p_legislation_code);
601: ELSE

Line 602: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN --if 11

598: p_hours_balance_id
599: ,'_ASG_RUN'
600: ,p_legislation_code);
601: ELSE
602: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN --if 11
603: ln_pymt_hours_balance_id
604: := pay_emp_action_arch.get_defined_balance_id(
605: p_hours_balance_id
606: ,'_ASG_PAYMENTS'

Line 604: := pay_emp_action_arch.get_defined_balance_id(

600: ,p_legislation_code);
601: ELSE
602: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN --if 11
603: ln_pymt_hours_balance_id
604: := pay_emp_action_arch.get_defined_balance_id(
605: p_hours_balance_id
606: ,'_ASG_PAYMENTS'
607: ,p_legislation_code);
608: ELSE

Line 610: := pay_emp_action_arch.get_defined_balance_id(

606: ,'_ASG_PAYMENTS'
607: ,p_legislation_code);
608: ELSE
609: ln_pymt_hours_balance_id
610: := pay_emp_action_arch.get_defined_balance_id(
611: p_hours_balance_id
612: ,'_PAYMENTS'
613: ,p_legislation_code);
614: END IF; --if 11

Line 629: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

625:
626: lv_balance_name := pay_ip_utility.get_balance_name(p_hours_balance_id);
627: lv_error_message := 'Defined Balance for the combination "'
628: || lv_balance_name ||'" and "_PAYMENTS" not exist';
629: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
630: hr_utility.set_location(gv_package || lv_procedure_name, 110);
631: hr_utility.trace('Dimension is not set for Primary Hours balance '||p_hours_balance_id);
632: hr_utility.raise_error;
633: END IF; --if 12

Line 693: pay_emp_action_arch.set_error_message(lv_error_message);

689: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
690: hr_utility.trace(lv_error_message || '-' || SQLERRM);
691:
692: lv_error_message :=
693: pay_emp_action_arch.set_error_message(lv_error_message);
694:
695: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
696: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
697: hr_utility.raise_error;

Line 842: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

838: IF ln_primary_balance_id IS NULL THEN
839: lv_error_message := 'Primary Balance not exist for the Element "'
840: || lv_reporting_name ||'"';
841:
842: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
843: hr_utility.raise_error;
844: END IF;
845:
846: IF lv_element_classification_name IN ('Voluntary Deductions'

Line 891: pay_emp_action_arch.get_defined_balance_id

887: := lv_jurisdiction_code;
888:
889: ln_step := 7;
890: ln_ytd_defined_balance_id :=
891: pay_emp_action_arch.get_defined_balance_id
892: (ln_primary_balance_id,
893: gv_ytd_balance_dimension,
894: p_legislation_code);
895: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 911: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

907: lv_balance_name := pay_ip_utility.get_balance_name(ln_primary_balance_id);
908: lv_error_message := 'Defined Balance for the combination "'
909: || lv_balance_name ||'" and "'
910: ||gv_ytd_balance_dimension||'" not exist';
911: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
912: hr_utility.raise_error;
913: END IF;
914:
915: ln_step := 8;

Line 918: pay_emp_action_arch.get_defined_balance_id

914:
915: ln_step := 8;
916: IF ln_hours_balance_id IS NOT NULL THEN
917: ln_ytd_hours_balance_id :=
918: pay_emp_action_arch.get_defined_balance_id
919: (ln_hours_balance_id,
920: gv_ytd_balance_dimension,
921: p_legislation_code);
922: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 934: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

930: lv_balance_name := pay_ip_utility.get_balance_name(ln_hours_balance_id);
931: lv_error_message := 'Defined Balance for the combination "'
932: || lv_balance_name ||'" and "'
933: ||gv_ytd_balance_dimension||'" not exist';
934: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
935: hr_utility.trace('YTD Dimension is not set for Primary Hours balance');
936: hr_utility.raise_error;
937: END IF;
938: END IF; -- Hours

Line 1006: pay_emp_action_arch.set_error_message(lv_error_message);

1002: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
1003: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1004:
1005: lv_error_message :=
1006: pay_emp_action_arch.set_error_message(lv_error_message);
1007:
1008: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1009: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1010: hr_utility.raise_error;

Line 1152: pay_emp_action_arch.gv_multi_payroll_pymt);

1148: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1149: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1150: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1151: hr_utility.trace('gv_multi_payroll_pymt = '||
1152: pay_emp_action_arch.gv_multi_payroll_pymt);
1153: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
1154:
1155: cn_last_xfr_action_id := p_last_xfr_action_id;
1156: ln_payments_amount := 0;

Line 1190: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

1186: IF ln_t_primary_balance_id IS NULL THEN
1187: hr_utility.trace('Primary balance is not present for element '||lv_reporting_name);
1188: lv_error_message := 'Primary Balance does not exist for the Element "'
1189: || lv_reporting_name ||'"';
1190: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
1191: hr_utility.raise_error;
1192: END IF;
1193: END IF;
1194:

Line 1267: := pay_emp_action_arch.get_defined_balance_id

1263: := ln_element_type_id;
1264:
1265: ln_step := 8;
1266: ln_ytd_defined_balance_id
1267: := pay_emp_action_arch.get_defined_balance_id
1268: (ln_primary_balance_id,
1269: gv_ytd_balance_dimension,
1270: p_legislation_code);
1271: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 1285: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

1281: lv_balance_name := pay_ip_utility.get_balance_name(ln_primary_balance_id);
1282: lv_error_message := 'Defined Balance for the combination "'
1283: || lv_balance_name ||'" and "'
1284: ||gv_ytd_balance_dimension||'" not exist';
1285: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
1286: hr_utility.raise_error;
1287: END IF;
1288: ln_step := 9;
1289: hr_utility.set_location(gv_package || lv_procedure_name, 70);

Line 1292: := pay_emp_action_arch.get_defined_balance_id

1288: ln_step := 9;
1289: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1290: IF ln_hours_balance_id IS NOT NULL THEN
1291: ln_ytd_hours_balance_id
1292: := pay_emp_action_arch.get_defined_balance_id
1293: (ln_hours_balance_id,
1294: gv_ytd_balance_dimension,
1295: p_legislation_code);
1296: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 1308: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

1304: lv_balance_name := pay_ip_utility.get_balance_name(ln_hours_balance_id);
1305: lv_error_message := 'Defined Balance for the combination "'
1306: || lv_balance_name ||'" and "'
1307: ||gv_ytd_balance_dimension||'" not exist';
1308: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
1309: hr_utility.raise_error;
1310: END IF;
1311: END IF;
1312:

Line 1386: pay_emp_action_arch.set_error_message(lv_error_message);

1382: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
1383: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1384:
1385: lv_error_message :=
1386: pay_emp_action_arch.set_error_message(lv_error_message);
1387:
1388: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1389: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1390: hr_utility.raise_error;

Line 1611: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

1607: hr_utility.trace('Primary balance is not present for element '||lv_reporting_name);
1608: lv_error_message := 'Primary Balance not exist for the Element "'
1609: || lv_reporting_name ||'"';
1610:
1611: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
1612: hr_utility.raise_error;
1613: END IF;
1614:
1615: hr_utility.set_location(gv_package || lv_procedure_name, 40);

Line 1668: pay_emp_action_arch.set_error_message(lv_error_message);

1664: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
1665: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1666:
1667: lv_error_message :=
1668: pay_emp_action_arch.set_error_message(lv_error_message);
1669:
1670: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1671: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1672: hr_utility.raise_error;

Line 1998: pay_emp_action_arch.set_error_message(lv_error_message);

1994: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
1995: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1996:
1997: lv_error_message :=
1998: pay_emp_action_arch.set_error_message(lv_error_message);
1999: hr_utility.raise_error;
2000:
2001: END; -- archive_elements
2002:

Line 2153: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

2149: IF ln_primary_balance_id IS NULL THEN
2150: hr_utility.trace('Primary balance is not present for element '||lv_reporting_name);
2151: lv_error_message := 'Primary Balance not exist for the Element "'
2152: || lv_reporting_name ||'"';
2153: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
2154: hr_utility.raise_error;
2155: END IF;
2156:
2157: hr_utility.set_location(gv_package || lv_procedure_name, 50);

Line 2255: pay_emp_action_arch.set_error_message(lv_error_message);

2251: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
2252: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2253:
2254: lv_error_message :=
2255: pay_emp_action_arch.set_error_message(lv_error_message);
2256:
2257: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2258: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2259: hr_utility.raise_error;

Line 2503: pay_emp_action_arch.gv_error_message := NULL;

2499: ld_effective_date := fnd_date.canonical_to_date('1900/12/31');
2500: lv_procedure_name := '.assignment_action_code';
2501:
2502: ln_step := 1;
2503: pay_emp_action_arch.gv_error_message := NULL;
2504: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2505:
2506: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
2507: ,p_start_date => ld_start_date

Line 2674: pay_emp_action_arch.set_error_message(lv_error_message);

2670: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
2671: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2672:
2673: lv_error_message :=
2674: pay_emp_action_arch.set_error_message(lv_error_message);
2675:
2676: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2677: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2678: hr_utility.raise_error;

Line 2765: pay_emp_action_arch.gv_error_message := NULL;

2761:
2762: BEGIN
2763: lv_procedure_name := '.initialization_code';
2764: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2765: pay_emp_action_arch.gv_error_message := NULL;
2766: lv_reporting_level := Null;
2767: i := 0;
2768: j := 0;
2769: ln_step := 1;

Line 2807: NVL(pay_emp_action_arch.get_defined_balance_id(

2803: OPEN c_balance_type_id;
2804: FETCH c_balance_type_id INTO ln_run_bal_type_id;
2805: hr_utility.trace('--Inside loop cur_bal_type--');
2806: gn_payments_def_bal_id :=
2807: NVL(pay_emp_action_arch.get_defined_balance_id(
2808: ln_run_bal_type_id,
2809: '_PAYMENTS',
2810: gv_legislation_code),-1); --Changed _ASG_RUN to _PAYMENTS
2811: CLOSE c_balance_type_id;

Line 2832: /*pay_emp_action_arch.get_multi_legislative_rule checks for MULTI_ASSIGNMENTS_FLAG in the table pay_legislative_field_info

2828: END LOOP;
2829:
2830: ln_step := 5;
2831:
2832: /*pay_emp_action_arch.get_multi_legislative_rule checks for MULTI_ASSIGNMENTS_FLAG in the table pay_legislative_field_info
2833: for International HR/Payroll this legislation rule is not enabled */
2834:
2835: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
2836: pay_emp_action_arch.gv_multi_leg_rule

Line 2835: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN

2831:
2832: /*pay_emp_action_arch.get_multi_legislative_rule checks for MULTI_ASSIGNMENTS_FLAG in the table pay_legislative_field_info
2833: for International HR/Payroll this legislation rule is not enabled */
2834:
2835: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
2836: pay_emp_action_arch.gv_multi_leg_rule
2837: := pay_emp_action_arch.get_multi_legislative_rule(gv_legislation_code);
2838: END IF;
2839:

Line 2836: pay_emp_action_arch.gv_multi_leg_rule

2832: /*pay_emp_action_arch.get_multi_legislative_rule checks for MULTI_ASSIGNMENTS_FLAG in the table pay_legislative_field_info
2833: for International HR/Payroll this legislation rule is not enabled */
2834:
2835: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
2836: pay_emp_action_arch.gv_multi_leg_rule
2837: := pay_emp_action_arch.get_multi_legislative_rule(gv_legislation_code);
2838: END IF;
2839:
2840: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);

Line 2837: := pay_emp_action_arch.get_multi_legislative_rule(gv_legislation_code);

2833: for International HR/Payroll this legislation rule is not enabled */
2834:
2835: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
2836: pay_emp_action_arch.gv_multi_leg_rule
2837: := pay_emp_action_arch.get_multi_legislative_rule(gv_legislation_code);
2838: END IF;
2839:
2840: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
2841: hr_utility.set_location(gv_package || lv_procedure_name, 20);

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

2836: pay_emp_action_arch.gv_multi_leg_rule
2837: := pay_emp_action_arch.get_multi_legislative_rule(gv_legislation_code);
2838: END IF;
2839:
2840: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
2841: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2842:
2843: ln_step := 6;
2844: dbt.delete;

Line 2881: pay_emp_action_arch.set_error_message(lv_error_message);

2877: lv_error_message := 'Error at step ' || ln_step ||' IN '|| gv_package || lv_procedure_name;
2878: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2879:
2880: lv_error_message :=
2881: pay_emp_action_arch.set_error_message(lv_error_message);
2882:
2883: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2884: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2885: hr_utility.raise_error;

Line 3042: pay_emp_action_arch.set_error_message(lv_error_message);

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

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

3134: ,lv_er_telephone;
3135: CLOSE c_addr_line;
3136: hr_utility.set_location(gv_package || lv_procedure_name, 220);
3137:
3138: IF pay_emp_action_arch.ltr_ppa_arch_data.count > 0 THEN
3139: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..
3140: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP
3141: IF pay_emp_action_arch.ltr_ppa_arch_data(i).act_info1
3142: = ln_organization_id THEN

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

3135: CLOSE c_addr_line;
3136: hr_utility.set_location(gv_package || lv_procedure_name, 220);
3137:
3138: IF pay_emp_action_arch.ltr_ppa_arch_data.count > 0 THEN
3139: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..
3140: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP
3141: IF pay_emp_action_arch.ltr_ppa_arch_data(i).act_info1
3142: = ln_organization_id THEN
3143: lv_is_er_exists := 'Y';

Line 3140: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP

3136: hr_utility.set_location(gv_package || lv_procedure_name, 220);
3137:
3138: IF pay_emp_action_arch.ltr_ppa_arch_data.count > 0 THEN
3139: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..
3140: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP
3141: IF pay_emp_action_arch.ltr_ppa_arch_data(i).act_info1
3142: = ln_organization_id THEN
3143: lv_is_er_exists := 'Y';
3144: EXIT;

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

3137:
3138: IF pay_emp_action_arch.ltr_ppa_arch_data.count > 0 THEN
3139: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..
3140: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP
3141: IF pay_emp_action_arch.ltr_ppa_arch_data(i).act_info1
3142: = ln_organization_id THEN
3143: lv_is_er_exists := 'Y';
3144: EXIT;
3145: END IF;

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

3147: END IF;
3148:
3149: IF lv_is_er_exists = 'N' THEN
3150: hr_utility.set_location(gv_package || lv_procedure_name, 230);
3151: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3152:
3153: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3154: := 'IP EMPLOYER DETAILS';
3155: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code

Line 3153: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category

3149: IF lv_is_er_exists = 'N' THEN
3150: hr_utility.set_location(gv_package || lv_procedure_name, 230);
3151: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3152:
3153: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3154: := 'IP EMPLOYER DETAILS';
3155: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3156: := NULL;
3157: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

Line 3155: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code

3151: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3152:
3153: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3154: := 'IP EMPLOYER DETAILS';
3155: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3156: := NULL;
3157: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3158: := ln_organization_id;
3159: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

Line 3157: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

3153: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3154: := 'IP EMPLOYER DETAILS';
3155: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3156: := NULL;
3157: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3158: := ln_organization_id;
3159: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3160: := lv_er_name;
3161: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

Line 3159: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

3155: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3156: := NULL;
3157: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3158: := ln_organization_id;
3159: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3160: := lv_er_name;
3161: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3162: := p_org_or_gre;
3163: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

Line 3161: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

3157: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3158: := ln_organization_id;
3159: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3160: := lv_er_name;
3161: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3162: := p_org_or_gre;
3163: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
3164: := lv_er_address_line_1 ;
3165: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

Line 3163: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

3159: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3160: := lv_er_name;
3161: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3162: := p_org_or_gre;
3163: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
3164: := lv_er_address_line_1 ;
3165: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
3166: := lv_er_address_line_2;
3167: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7

Line 3165: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

3161: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3162: := p_org_or_gre;
3163: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
3164: := lv_er_address_line_1 ;
3165: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
3166: := lv_er_address_line_2;
3167: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
3168: := lv_er_address_line_3;
3169: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8

Line 3167: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7

3163: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
3164: := lv_er_address_line_1 ;
3165: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
3166: := lv_er_address_line_2;
3167: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
3168: := lv_er_address_line_3;
3169: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
3170: := lv_er_town_or_city;
3171: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9

Line 3169: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8

3165: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
3166: := lv_er_address_line_2;
3167: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
3168: := lv_er_address_line_3;
3169: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
3170: := lv_er_town_or_city;
3171: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
3172: := lv_er_region_1;
3173: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10

Line 3171: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9

3167: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
3168: := lv_er_address_line_3;
3169: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
3170: := lv_er_town_or_city;
3171: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
3172: := lv_er_region_1;
3173: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
3174: := lv_er_region_2;
3175: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11

Line 3173: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10

3169: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
3170: := lv_er_town_or_city;
3171: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
3172: := lv_er_region_1;
3173: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
3174: := lv_er_region_2;
3175: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
3176: := lv_er_region_3 ;
3177: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12

Line 3175: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11

3171: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
3172: := lv_er_region_1;
3173: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
3174: := lv_er_region_2;
3175: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
3176: := lv_er_region_3 ;
3177: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
3178: := lv_er_postal_code;
3179: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13

Line 3177: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12

3173: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
3174: := lv_er_region_2;
3175: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
3176: := lv_er_region_3 ;
3177: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
3178: := lv_er_postal_code;
3179: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
3180: := lv_er_country;
3181: END IF;

Line 3179: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13

3175: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
3176: := lv_er_region_3 ;
3177: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
3178: := lv_er_postal_code;
3179: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
3180: := lv_er_country;
3181: END IF;
3182:
3183: END get_ER_address;

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

3228:
3229:
3230: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3231:
3232: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3233: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3234: := 'EMPLOYEE OTHER INFORMATION';
3235: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3236: := NULL;

Line 3233: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category

3229:
3230: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3231:
3232: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3233: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3234: := 'EMPLOYEE OTHER INFORMATION';
3235: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3236: := NULL;
3237: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

Line 3235: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code

3231:
3232: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3233: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3234: := 'EMPLOYEE OTHER INFORMATION';
3235: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3236: := NULL;
3237: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3238: := p_organization_id;
3239: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

Line 3237: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

3233: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3234: := 'EMPLOYEE OTHER INFORMATION';
3235: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3236: := NULL;
3237: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3238: := p_organization_id;
3239: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3240: := 'MESG';
3241: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

Line 3239: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

3235: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3236: := NULL;
3237: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3238: := p_organization_id;
3239: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3240: := 'MESG';
3241: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3242: := NVL(lv_org_information7,lv_org_information4) ;
3243: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

Line 3241: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

3237: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3238: := p_organization_id;
3239: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3240: := 'MESG';
3241: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3242: := NVL(lv_org_information7,lv_org_information4) ;
3243: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
3244: := lv_org_information5 ;
3245: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

Line 3243: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

3239: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3240: := 'MESG';
3241: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3242: := NVL(lv_org_information7,lv_org_information4) ;
3243: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
3244: := lv_org_information5 ;
3245: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
3246: := lv_org_information6;
3247: END LOOP ;

Line 3245: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

3241: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3242: := NVL(lv_org_information7,lv_org_information4) ;
3243: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
3244: := lv_org_information5 ;
3245: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
3246: := lv_org_information6;
3247: END LOOP ;
3248: CLOSE c_get_other_info;
3249:

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

3264: EXIT;
3265: END IF;
3266:
3267: hr_utility.set_location(gv_package || lv_procedure_name, 130);
3268: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3269: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3270: := 'EMPLOYEE OTHER INFORMATION';
3271: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3272: := NULL;

Line 3269: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category

3265: END IF;
3266:
3267: hr_utility.set_location(gv_package || lv_procedure_name, 130);
3268: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3269: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3270: := 'EMPLOYEE OTHER INFORMATION';
3271: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3272: := NULL;
3273: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

Line 3271: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code

3267: hr_utility.set_location(gv_package || lv_procedure_name, 130);
3268: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3269: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3270: := 'EMPLOYEE OTHER INFORMATION';
3271: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3272: := NULL;
3273: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3274: := p_business_group_id;
3275: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

Line 3273: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1

3269: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3270: := 'EMPLOYEE OTHER INFORMATION';
3271: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3272: := NULL;
3273: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3274: := p_business_group_id;
3275: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3276: := 'MESG';
3277: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

Line 3275: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2

3271: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
3272: := NULL;
3273: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3274: := p_business_group_id;
3275: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3276: := 'MESG';
3277: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3278: := NVL(lv_org_information7,lv_org_information4) ;
3279: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

Line 3277: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4

3273: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
3274: := p_business_group_id;
3275: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3276: := 'MESG';
3277: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3278: := NVL(lv_org_information7,lv_org_information4) ;
3279: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
3280: := lv_org_information5 ;
3281: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

Line 3279: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5

3275: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
3276: := 'MESG';
3277: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3278: := NVL(lv_org_information7,lv_org_information4) ;
3279: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
3280: := lv_org_information5 ;
3281: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
3282: := lv_org_information6;
3283: END LOOP ;

Line 3281: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6

3277: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
3278: := NVL(lv_org_information7,lv_org_information4) ;
3279: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
3280: := lv_org_information5 ;
3281: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
3282: := lv_org_information6;
3283: END LOOP ;
3284: CLOSE c_get_other_info;
3285: hr_utility.set_location(gv_package || lv_procedure_name, 140);

Line 3293: pay_emp_action_arch.initialization_process;

3289: BEGIN
3290: lv_procedure_name := '.arch_pay_action_level_data';
3291: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3292:
3293: pay_emp_action_arch.initialization_process;
3294:
3295: OPEN c_get_organization(p_payroll_id, p_effective_date);
3296: LOOP
3297: FETCH c_get_organization INTO ln_organization_id,

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

3326:
3327: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3328:
3329: -- insert rows in pay_action_information table
3330: IF pay_emp_action_arch.ltr_ppa_arch.count > 0 THEN
3331: pay_emp_action_arch.insert_rows_thro_api_process(
3332: p_action_context_id => p_payroll_action_id
3333: ,p_action_context_type => 'PA'
3334: ,p_assignment_id => NULL

Line 3331: pay_emp_action_arch.insert_rows_thro_api_process(

3327: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3328:
3329: -- insert rows in pay_action_information table
3330: IF pay_emp_action_arch.ltr_ppa_arch.count > 0 THEN
3331: pay_emp_action_arch.insert_rows_thro_api_process(
3332: p_action_context_id => p_payroll_action_id
3333: ,p_action_context_type => 'PA'
3334: ,p_assignment_id => NULL
3335: ,p_tax_unit_id => NULL

Line 3337: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch

3333: ,p_action_context_type => 'PA'
3334: ,p_assignment_id => NULL
3335: ,p_tax_unit_id => NULL
3336: ,p_curr_pymt_eff_date => p_effective_date
3337: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch
3338: );
3339: END IF;
3340: EXCEPTION
3341: WHEN OTHERS THEN

Line 4019: pay_emp_action_arch.get_personal_information(

4015: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4016: ln_step := 14;
4017: /*Archiving Employee's personal information*/
4018: hr_utility.set_location(gv_package || lv_procedure_name, 152);
4019: pay_emp_action_arch.get_personal_information(
4020: p_payroll_action_id => p_xfr_payroll_action_id
4021: ,p_assactid => p_xfr_action_id
4022: ,p_assignment_id => p_assignment_id
4023: ,p_curr_pymt_ass_act_id => p_pre_pay_action_id

Line 4067: pay_emp_action_arch.insert_rows_thro_api_process(

4063:
4064:
4065: hr_utility.set_location(gv_package || lv_procedure_name, 210);
4066: ln_step := 16;
4067: pay_emp_action_arch.insert_rows_thro_api_process(
4068: p_action_context_id => p_xfr_action_id
4069: ,p_action_context_type=> 'AAP'
4070: ,p_assignment_id => p_assignment_id
4071: ,p_tax_unit_id => p_tax_unit_id

Line 4100: pay_emp_action_arch.set_error_message(lv_error_message);

4096:
4097: hr_utility.trace(lv_error_message || '-' || SQLERRM);
4098:
4099: lv_error_message :=
4100: pay_emp_action_arch.set_error_message(lv_error_message);
4101:
4102: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4103: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4104: hr_utility.raise_error;

Line 4322: pay_emp_action_arch.gv_error_message := NULL;

4318: ln_old_term_asg_id := '-1';
4319: lv_archive_balance_info := 'Y';
4320:
4321:
4322: pay_emp_action_arch.gv_error_message := NULL;
4323: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4324: ln_step := 1;
4325: /*Get the information belongs to archiver assignment action id */
4326:

Line 4347: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

4343: /*Added check to identify whether Tax Unit is specified when it is enabled for a Localization*/
4344: IF (gv_is_tax_unit_enabled = 'Y' AND ln_tax_unit_id IS NULL) THEN
4345: hr_utility.trace('Tax Unit is enabled but is not specified');
4346: lv_error_message := 'Tax Unit is enabled for localization but is not specified';
4347: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
4348: hr_utility.raise_error;
4349: END IF;
4350:
4351: ln_step := 2;

Line 4363: pay_emp_action_arch.gv_multi_payroll_pymt

4359:
4360: hr_utility.set_location(gv_package || lv_procedure_name, 15);
4361:
4362: ln_step := 3;
4363: pay_emp_action_arch.gv_multi_payroll_pymt
4364: := pay_emp_action_arch.get_multi_assignment_flag(
4365: p_payroll_id => ln_payroll_id
4366: ,p_effective_date => ld_end_date);
4367:

Line 4364: := pay_emp_action_arch.get_multi_assignment_flag(

4360: hr_utility.set_location(gv_package || lv_procedure_name, 15);
4361:
4362: ln_step := 3;
4363: pay_emp_action_arch.gv_multi_payroll_pymt
4364: := pay_emp_action_arch.get_multi_assignment_flag(
4365: p_payroll_id => ln_payroll_id
4366: ,p_effective_date => ld_end_date);
4367:
4368: /*International Payroll product is not supporting Mulit assignment feature

Line 4369: pay_emp_action_arch.gv_multi_payroll_pymt always returns 'N' */

4365: p_payroll_id => ln_payroll_id
4366: ,p_effective_date => ld_end_date);
4367:
4368: /*International Payroll product is not supporting Mulit assignment feature
4369: pay_emp_action_arch.gv_multi_payroll_pymt always returns 'N' */
4370:
4371: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
4372: pay_emp_action_arch.gv_multi_payroll_pymt);
4373:

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

4367:
4368: /*International Payroll product is not supporting Mulit assignment feature
4369: pay_emp_action_arch.gv_multi_payroll_pymt always returns 'N' */
4370:
4371: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
4372: pay_emp_action_arch.gv_multi_payroll_pymt);
4373:
4374: ln_step := 4;
4375: hr_utility.set_location(gv_package || lv_procedure_name, 20);

Line 4372: pay_emp_action_arch.gv_multi_payroll_pymt);

4368: /*International Payroll product is not supporting Mulit assignment feature
4369: pay_emp_action_arch.gv_multi_payroll_pymt always returns 'N' */
4370:
4371: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
4372: pay_emp_action_arch.gv_multi_payroll_pymt);
4373:
4374: ln_step := 4;
4375: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4376:

Line 4597: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' THEN

4593: hr_utility.trace('ln_earnings = ' ||ln_earnings);
4594: ln_step := 21;
4595: IF ln_earnings = 0 AND
4596: ln_xfr_assignment_id = ln_assignment_id AND
4597: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' THEN
4598: ln_earnings := 1;
4599: lv_archive_balance_info := 'N';
4600: ELSE
4601: lv_archive_balance_info := 'Y';

Line 4691: pay_emp_action_arch.insert_rows_thro_api_process(

4687: END LOOP;
4688: CLOSE c_get_emp_adjbal;
4689:
4690: ln_step := 27;
4691: pay_emp_action_arch.insert_rows_thro_api_process(
4692: p_action_context_id => p_xfr_action_id
4693: ,p_action_context_type=> 'AAP'
4694: ,p_assignment_id => ln_assignment_id
4695: ,p_tax_unit_id => ln_tax_unit_id

Line 4735: pay_emp_action_arch.set_error_message(lv_error_message);

4731:
4732: hr_utility.trace(lv_error_message || '-' || SQLERRM);
4733:
4734: lv_error_message :=
4735: pay_emp_action_arch.set_error_message(lv_error_message);
4736:
4737: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4738: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4739: hr_utility.raise_error;