DBA Data[Home] [Help]

APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PAY_CORE_UTILS

Line 791: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');

787: to_date('06-04-' ||to_char(to_number(l_rep_run)-1),'dd-mm-yyyy') or
788: fnd_date.canonical_to_date(l_benefit_start_date) >
789: to_date('05-04-' ||l_rep_run,'dd-mm-yyyy')
790: Then
791: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
792: pay_core_utils.push_token('NAME', 'Benefit Start Date');
793: pay_core_utils.push_token('VAl1','06-04-' ||to_char(to_number(l_rep_run)-1));
794: pay_core_utils.push_token('VAl2', '05-04-' ||l_rep_run);
795:

Line 792: pay_core_utils.push_token('NAME', 'Benefit Start Date');

788: fnd_date.canonical_to_date(l_benefit_start_date) >
789: to_date('05-04-' ||l_rep_run,'dd-mm-yyyy')
790: Then
791: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
792: pay_core_utils.push_token('NAME', 'Benefit Start Date');
793: pay_core_utils.push_token('VAl1','06-04-' ||to_char(to_number(l_rep_run)-1));
794: pay_core_utils.push_token('VAl2', '05-04-' ||l_rep_run);
795:
796: fnd_message.set_name('PER', 'HR_78076_P11D_DATE_PARAM_ERR');

Line 793: pay_core_utils.push_token('VAl1','06-04-' ||to_char(to_number(l_rep_run)-1));

789: to_date('05-04-' ||l_rep_run,'dd-mm-yyyy')
790: Then
791: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
792: pay_core_utils.push_token('NAME', 'Benefit Start Date');
793: pay_core_utils.push_token('VAl1','06-04-' ||to_char(to_number(l_rep_run)-1));
794: pay_core_utils.push_token('VAl2', '05-04-' ||l_rep_run);
795:
796: fnd_message.set_name('PER', 'HR_78076_P11D_DATE_PARAM_ERR');
797: fnd_message.set_token('NAME', 'Benefit Start Date');

Line 794: pay_core_utils.push_token('VAl2', '05-04-' ||l_rep_run);

790: Then
791: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
792: pay_core_utils.push_token('NAME', 'Benefit Start Date');
793: pay_core_utils.push_token('VAl1','06-04-' ||to_char(to_number(l_rep_run)-1));
794: pay_core_utils.push_token('VAl2', '05-04-' ||l_rep_run);
795:
796: fnd_message.set_name('PER', 'HR_78076_P11D_DATE_PARAM_ERR');
797: fnd_message.set_token('NAME', 'Benefit Start Date');
798: fnd_message.set_token('VAL1', '06-04-' ||to_char(to_number(l_rep_run)-1));

Line 809: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');

805: to_date('06-04-' ||to_char(to_number(l_rep_run)-1),'dd-mm-yyyy') or
806: fnd_date.canonical_to_date(l_benefit_end_date) >
807: to_date('05-04-' ||l_rep_run,'dd-mm-yyyy')
808: then
809: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
810: pay_core_utils.push_token('NAME', 'Benefit End Date');
811: pay_core_utils.push_token('VAl1','06-04-' ||to_char(to_number(l_rep_run)-1));
812: pay_core_utils.push_token('VAl2', '05-04-' ||l_rep_run);
813:

Line 810: pay_core_utils.push_token('NAME', 'Benefit End Date');

806: fnd_date.canonical_to_date(l_benefit_end_date) >
807: to_date('05-04-' ||l_rep_run,'dd-mm-yyyy')
808: then
809: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
810: pay_core_utils.push_token('NAME', 'Benefit End Date');
811: pay_core_utils.push_token('VAl1','06-04-' ||to_char(to_number(l_rep_run)-1));
812: pay_core_utils.push_token('VAl2', '05-04-' ||l_rep_run);
813:
814: fnd_message.set_name('PER', 'HR_78076_P11D_DATE_PARAM_ERR');

Line 811: pay_core_utils.push_token('VAl1','06-04-' ||to_char(to_number(l_rep_run)-1));

807: to_date('05-04-' ||l_rep_run,'dd-mm-yyyy')
808: then
809: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
810: pay_core_utils.push_token('NAME', 'Benefit End Date');
811: pay_core_utils.push_token('VAl1','06-04-' ||to_char(to_number(l_rep_run)-1));
812: pay_core_utils.push_token('VAl2', '05-04-' ||l_rep_run);
813:
814: fnd_message.set_name('PER', 'HR_78076_P11D_DATE_PARAM_ERR');
815: fnd_message.set_token('NAME', 'Benefit End Date');

Line 812: pay_core_utils.push_token('VAl2', '05-04-' ||l_rep_run);

808: then
809: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
810: pay_core_utils.push_token('NAME', 'Benefit End Date');
811: pay_core_utils.push_token('VAl1','06-04-' ||to_char(to_number(l_rep_run)-1));
812: pay_core_utils.push_token('VAl2', '05-04-' ||l_rep_run);
813:
814: fnd_message.set_name('PER', 'HR_78076_P11D_DATE_PARAM_ERR');
815: fnd_message.set_token('NAME', 'Benefit End Date');
816: fnd_message.set_token('VAL1', '06-04-' ||to_char(to_number(l_rep_run)-1));

Line 2440: pay_core_utils.push_message(800, 'HR_GB_78059_INCONSISTENT_VAL', 'F');

2436: if to_number(g_param_rep_run) < 2005
2437: then
2438: IF p_var_name = 'M_SHARES'
2439: THEN
2440: pay_core_utils.push_message(800, 'HR_GB_78059_INCONSISTENT_VAL', 'F');
2441: fnd_message.set_name('PER', 'HR_GB_78059_INCONSISTENT_VAL');
2442: l_val_error_count := l_val_error_count + 1;
2443: l_val_errors(l_val_error_count).error_text := fnd_message.get;
2444: l_val_errors(l_val_error_count).error_assignment_name := l_assignment_name;

Line 2451: pay_core_utils.push_message(800, 'HR_GB_78060_TOI_INCONSISTENT', 'F');

2447: END IF;
2448:
2449: IF p_var_name = 'O_TOI'
2450: THEN
2451: pay_core_utils.push_message(800, 'HR_GB_78060_TOI_INCONSISTENT', 'F');
2452: fnd_message.set_name('PER', 'HR_GB_78060_TOI_INCONSISTENT');
2453: l_val_error_count := l_val_error_count + 1;
2454: l_val_errors(l_val_error_count).error_text := fnd_message.get;
2455: l_val_errors(l_val_error_count).error_assignment_name := l_assignment_name;

Line 2464: pay_core_utils.push_message(800, 'HR_GB_78060_TOI_INCONSISTENT', 'F');

2460: l_error_assignment := TRUE;
2461: else /* code for year 04/05 onwards */
2462: IF p_var_name = 'N_TOI'
2463: THEN
2464: pay_core_utils.push_message(800, 'HR_GB_78060_TOI_INCONSISTENT', 'F');
2465: END IF;
2466: l_error := '1';
2467: l_error_assignment := TRUE;
2468: end if;

Line 2481: pay_core_utils.push_message(800, 'HR_GB_78061_CAR_NUM_ERROR', 'F');

2477: IF p_var_name = 'F_COUNT'
2478: THEN
2479: IF l_var_value > 50
2480: THEN
2481: pay_core_utils.push_message(800, 'HR_GB_78061_CAR_NUM_ERROR', 'F');
2482: l_error := '1';
2483: l_error_assignment := TRUE;
2484: END IF;
2485: IF l_var_value > 2

Line 2487: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');

2483: l_error_assignment := TRUE;
2484: END IF;
2485: IF l_var_value > 2
2486: THEN
2487: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');
2488: pay_core_utils.push_token('TEXT', 'Car and Car Fuel 2003_04: This employee has more than 2 cars');
2489: l_warn := '1';
2490: END IF;
2491: END IF;

Line 2488: pay_core_utils.push_token('TEXT', 'Car and Car Fuel 2003_04: This employee has more than 2 cars');

2484: END IF;
2485: IF l_var_value > 2
2486: THEN
2487: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');
2488: pay_core_utils.push_token('TEXT', 'Car and Car Fuel 2003_04: This employee has more than 2 cars');
2489: l_warn := '1';
2490: END IF;
2491: END IF;
2492: IF p_var_name = 'MARORS_COUNT'

Line 2496: pay_core_utils.push_message(800, 'HR_GB_78081_MARORS_NUM_ERROR', 'F');

2492: IF p_var_name = 'MARORS_COUNT'
2493: THEN
2494: IF l_var_value > 1
2495: THEN
2496: pay_core_utils.push_message(800, 'HR_GB_78081_MARORS_NUM_ERROR', 'F');
2497: l_error := '1';
2498: l_error_assignment := TRUE;
2499: END IF;
2500: END IF;

Line 2512: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'F');

2508: l_var_value NUMBER;
2509: BEGIN
2510: l_var_value := per_formula_functions.get_number(p_var_name);
2511: If l_var_value < p_min_value then
2512: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'F');
2513: pay_core_utils.push_token('ELEMENT_NAME', p_element_name);
2514: pay_core_utils.push_token('VALUE', p_min_value);
2515: l_error := '1';
2516: l_error_assignment := TRUE;

Line 2513: pay_core_utils.push_token('ELEMENT_NAME', p_element_name);

2509: BEGIN
2510: l_var_value := per_formula_functions.get_number(p_var_name);
2511: If l_var_value < p_min_value then
2512: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'F');
2513: pay_core_utils.push_token('ELEMENT_NAME', p_element_name);
2514: pay_core_utils.push_token('VALUE', p_min_value);
2515: l_error := '1';
2516: l_error_assignment := TRUE;
2517: elsif l_var_value > p_max_value then

Line 2514: pay_core_utils.push_token('VALUE', p_min_value);

2510: l_var_value := per_formula_functions.get_number(p_var_name);
2511: If l_var_value < p_min_value then
2512: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'F');
2513: pay_core_utils.push_token('ELEMENT_NAME', p_element_name);
2514: pay_core_utils.push_token('VALUE', p_min_value);
2515: l_error := '1';
2516: l_error_assignment := TRUE;
2517: elsif l_var_value > p_max_value then
2518: pay_core_utils.push_message(800, 'HR_GB_78082_MAX_VALUE_ERROR', 'F');

Line 2518: pay_core_utils.push_message(800, 'HR_GB_78082_MAX_VALUE_ERROR', 'F');

2514: pay_core_utils.push_token('VALUE', p_min_value);
2515: l_error := '1';
2516: l_error_assignment := TRUE;
2517: elsif l_var_value > p_max_value then
2518: pay_core_utils.push_message(800, 'HR_GB_78082_MAX_VALUE_ERROR', 'F');
2519: pay_core_utils.push_token('ELEMENT_NAME', p_element_name);
2520: pay_core_utils.push_token('VALUE', p_max_value);
2521: l_error := '1';
2522: l_error_assignment := TRUE;

Line 2519: pay_core_utils.push_token('ELEMENT_NAME', p_element_name);

2515: l_error := '1';
2516: l_error_assignment := TRUE;
2517: elsif l_var_value > p_max_value then
2518: pay_core_utils.push_message(800, 'HR_GB_78082_MAX_VALUE_ERROR', 'F');
2519: pay_core_utils.push_token('ELEMENT_NAME', p_element_name);
2520: pay_core_utils.push_token('VALUE', p_max_value);
2521: l_error := '1';
2522: l_error_assignment := TRUE;
2523: end if;

Line 2520: pay_core_utils.push_token('VALUE', p_max_value);

2516: l_error_assignment := TRUE;
2517: elsif l_var_value > p_max_value then
2518: pay_core_utils.push_message(800, 'HR_GB_78082_MAX_VALUE_ERROR', 'F');
2519: pay_core_utils.push_token('ELEMENT_NAME', p_element_name);
2520: pay_core_utils.push_token('VALUE', p_max_value);
2521: l_error := '1';
2522: l_error_assignment := TRUE;
2523: end if;
2524: END;

Line 2640: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'W');

2636: read_validate_min_max('MILEAGE_ALLOWANCE_RELIEF',-999999.99,0,'MARORS');
2637: -- checking max amount outstanding for Int free and low int loans
2638: -- will rasie just a warning for this
2639: If per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING') < l_loan_threshold then
2640: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'W');
2641: pay_core_utils.push_token('ELEMENT_NAME', 'Int Free and Low Int Loans');
2642: pay_core_utils.push_token('VALUE', l_loan_threshold);
2643: l_warn := '1';
2644: End if;

Line 2641: pay_core_utils.push_token('ELEMENT_NAME', 'Int Free and Low Int Loans');

2637: -- checking max amount outstanding for Int free and low int loans
2638: -- will rasie just a warning for this
2639: If per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING') < l_loan_threshold then
2640: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'W');
2641: pay_core_utils.push_token('ELEMENT_NAME', 'Int Free and Low Int Loans');
2642: pay_core_utils.push_token('VALUE', l_loan_threshold);
2643: l_warn := '1';
2644: End if;
2645: END;

Line 2642: pay_core_utils.push_token('VALUE', l_loan_threshold);

2638: -- will rasie just a warning for this
2639: If per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING') < l_loan_threshold then
2640: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'W');
2641: pay_core_utils.push_token('ELEMENT_NAME', 'Int Free and Low Int Loans');
2642: pay_core_utils.push_token('VALUE', l_loan_threshold);
2643: l_warn := '1';
2644: End if;
2645: END;
2646: procedure validate_ni(p_assactid NUMBER,

Line 2678: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');

2674:
2675: if l_var_value <> 0 then
2676: -- Setup warning message
2677: l_warn:=1;
2678: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');
2679: pay_core_utils.push_token('TEXT', ': Invalid NI number ' || l_nat_number);
2680:
2681: -- Update the NI Number field to NULL
2682: update pay_action_information

Line 2679: pay_core_utils.push_token('TEXT', ': Invalid NI number ' || l_nat_number);

2675: if l_var_value <> 0 then
2676: -- Setup warning message
2677: l_warn:=1;
2678: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');
2679: pay_core_utils.push_token('TEXT', ': Invalid NI number ' || l_nat_number);
2680:
2681: -- Update the NI Number field to NULL
2682: update pay_action_information
2683: set action_information4 = null

Line 2726: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

2722: close get_address;
2723: if pay_gb_eoy_magtape.validate_input(l_addr1,'P11D_EDI') > 0 then
2724: l_error_assignment := TRUE;
2725: l_error := '1';
2726: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2727: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 1 value ' || l_addr1);
2728: end if;
2729: if pay_gb_eoy_magtape.validate_input(l_addr2,'P11D_EDI') > 0 then
2730: l_error_assignment := TRUE;

Line 2727: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 1 value ' || l_addr1);

2723: if pay_gb_eoy_magtape.validate_input(l_addr1,'P11D_EDI') > 0 then
2724: l_error_assignment := TRUE;
2725: l_error := '1';
2726: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2727: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 1 value ' || l_addr1);
2728: end if;
2729: if pay_gb_eoy_magtape.validate_input(l_addr2,'P11D_EDI') > 0 then
2730: l_error_assignment := TRUE;
2731: l_error := '1';

Line 2732: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

2728: end if;
2729: if pay_gb_eoy_magtape.validate_input(l_addr2,'P11D_EDI') > 0 then
2730: l_error_assignment := TRUE;
2731: l_error := '1';
2732: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2733: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 2 value ' || l_addr2);
2734: end if;
2735: if pay_gb_eoy_magtape.validate_input(l_addr3,'P11D_EDI') > 0 then
2736: l_error_assignment := TRUE;

Line 2733: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 2 value ' || l_addr2);

2729: if pay_gb_eoy_magtape.validate_input(l_addr2,'P11D_EDI') > 0 then
2730: l_error_assignment := TRUE;
2731: l_error := '1';
2732: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2733: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 2 value ' || l_addr2);
2734: end if;
2735: if pay_gb_eoy_magtape.validate_input(l_addr3,'P11D_EDI') > 0 then
2736: l_error_assignment := TRUE;
2737: l_error := '1';

Line 2738: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

2734: end if;
2735: if pay_gb_eoy_magtape.validate_input(l_addr3,'P11D_EDI') > 0 then
2736: l_error_assignment := TRUE;
2737: l_error := '1';
2738: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2739: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 3 value ' || l_addr3);
2740: end if;
2741: if pay_gb_eoy_magtape.validate_input(l_addr4,'P11D_EDI') > 0 then
2742: l_error_assignment := TRUE;

Line 2739: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 3 value ' || l_addr3);

2735: if pay_gb_eoy_magtape.validate_input(l_addr3,'P11D_EDI') > 0 then
2736: l_error_assignment := TRUE;
2737: l_error := '1';
2738: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2739: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 3 value ' || l_addr3);
2740: end if;
2741: if pay_gb_eoy_magtape.validate_input(l_addr4,'P11D_EDI') > 0 then
2742: l_error_assignment := TRUE;
2743: l_error := '1';

Line 2744: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

2740: end if;
2741: if pay_gb_eoy_magtape.validate_input(l_addr4,'P11D_EDI') > 0 then
2742: l_error_assignment := TRUE;
2743: l_error := '1';
2744: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2745: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 4 value ' || l_addr4);
2746: end if;
2747: if pay_gb_eoy_magtape.validate_input(l_addr5,'P11D_EDI') > 0 then
2748: l_error_assignment := TRUE;

Line 2745: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 4 value ' || l_addr4);

2741: if pay_gb_eoy_magtape.validate_input(l_addr4,'P11D_EDI') > 0 then
2742: l_error_assignment := TRUE;
2743: l_error := '1';
2744: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2745: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 4 value ' || l_addr4);
2746: end if;
2747: if pay_gb_eoy_magtape.validate_input(l_addr5,'P11D_EDI') > 0 then
2748: l_error_assignment := TRUE;
2749: l_error := '1';

Line 2750: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

2746: end if;
2747: if pay_gb_eoy_magtape.validate_input(l_addr5,'P11D_EDI') > 0 then
2748: l_error_assignment := TRUE;
2749: l_error := '1';
2750: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2751: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 5 value ' || l_addr5);
2752: end if;
2753: end;
2754:

Line 2751: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 5 value ' || l_addr5);

2747: if pay_gb_eoy_magtape.validate_input(l_addr5,'P11D_EDI') > 0 then
2748: l_error_assignment := TRUE;
2749: l_error := '1';
2750: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2751: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 5 value ' || l_addr5);
2752: end if;
2753: end;
2754:
2755: procedure check_assignment_latest_info(p_assignment_id number,

Line 3019: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3015: EXCEPTION
3016: WHEN payroll_not_found
3017: THEN
3018: l_error_assignment := TRUE;
3019: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3020: pay_core_utils.push_token('TEXT',
3021: ': Oracle HRMS cannot locate any information for ' || l_payroll_id || '. Please check that the Payroll Name is correct.');
3022: l_error := '1';
3023: WHEN tax_office_name_error

Line 3020: pay_core_utils.push_token('TEXT',

3016: WHEN payroll_not_found
3017: THEN
3018: l_error_assignment := TRUE;
3019: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3020: pay_core_utils.push_token('TEXT',
3021: ': Oracle HRMS cannot locate any information for ' || l_payroll_id || '. Please check that the Payroll Name is correct.');
3022: l_error := '1';
3023: WHEN tax_office_name_error
3024: THEN

Line 3027: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3023: WHEN tax_office_name_error
3024: THEN
3025: l_error_assignment := TRUE;
3026: l_error := '1';
3027: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3028: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Tax Office Name value '
3029: || l_pay_info_tab(l_payroll_id).l_tax_office_name);
3030: WHEN employer_address_error
3031: THEN

Line 3028: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Tax Office Name value '

3024: THEN
3025: l_error_assignment := TRUE;
3026: l_error := '1';
3027: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3028: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Tax Office Name value '
3029: || l_pay_info_tab(l_payroll_id).l_tax_office_name);
3030: WHEN employer_address_error
3031: THEN
3032: l_error_assignment := TRUE;

Line 3034: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3030: WHEN employer_address_error
3031: THEN
3032: l_error_assignment := TRUE;
3033: l_error := '1';
3034: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3035: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Employers Address value '
3036: || l_pay_info_tab(l_payroll_id).l_employer_address);
3037: WHEN employers_ref_no_error
3038: THEN

Line 3035: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Employers Address value '

3031: THEN
3032: l_error_assignment := TRUE;
3033: l_error := '1';
3034: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3035: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Employers Address value '
3036: || l_pay_info_tab(l_payroll_id).l_employer_address);
3037: WHEN employers_ref_no_error
3038: THEN
3039: l_error_assignment := TRUE;

Line 3041: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3037: WHEN employers_ref_no_error
3038: THEN
3039: l_error_assignment := TRUE;
3040: l_error := '1';
3041: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3042: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Employers Reference Number value '
3043: || l_pay_info_tab(l_payroll_id).l_employers_ref_no);
3044: WHEN employer_name_error
3045: THEN

Line 3042: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Employers Reference Number value '

3038: THEN
3039: l_error_assignment := TRUE;
3040: l_error := '1';
3041: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3042: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Employers Reference Number value '
3043: || l_pay_info_tab(l_payroll_id).l_employers_ref_no);
3044: WHEN employer_name_error
3045: THEN
3046: l_error_assignment := TRUE;

Line 3048: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3044: WHEN employer_name_error
3045: THEN
3046: l_error_assignment := TRUE;
3047: l_error := '1';
3048: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3049: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Employers Name value '
3050: || l_pay_info_tab(l_payroll_id).l_employer_name);
3051: END; -- end for payroll info setup
3052:

Line 3049: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Employers Name value '

3045: THEN
3046: l_error_assignment := TRUE;
3047: l_error := '1';
3048: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3049: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Employers Name value '
3050: || l_pay_info_tab(l_payroll_id).l_employer_name);
3051: END; -- end for payroll info setup
3052:
3053: IF l_error <> '1'

Line 3080: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3076: IF pay_gb_eoy_magtape.validate_input(UPPER(l_first_name), 'P11D_EDI') > 0
3077: THEN
3078: l_error_assignment := TRUE;
3079: l_error := '1';
3080: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3081: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for First Name value ' || l_first_name);
3082: END IF;
3083:
3084: IF pay_gb_eoy_magtape.validate_input(UPPER(l_middle_name), 'P11D_EDI') > 0

Line 3081: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for First Name value ' || l_first_name);

3077: THEN
3078: l_error_assignment := TRUE;
3079: l_error := '1';
3080: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3081: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for First Name value ' || l_first_name);
3082: END IF;
3083:
3084: IF pay_gb_eoy_magtape.validate_input(UPPER(l_middle_name), 'P11D_EDI') > 0
3085: THEN

Line 3088: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3084: IF pay_gb_eoy_magtape.validate_input(UPPER(l_middle_name), 'P11D_EDI') > 0
3085: THEN
3086: l_error_assignment := TRUE;
3087: l_error := '1';
3088: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3089: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Middle Name value ' || l_middle_name);
3090: END IF;
3091:
3092: IF pay_gb_eoy_magtape.validate_input(UPPER(l_last_name), 'P11D_EDI') > 0

Line 3089: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Middle Name value ' || l_middle_name);

3085: THEN
3086: l_error_assignment := TRUE;
3087: l_error := '1';
3088: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3089: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Middle Name value ' || l_middle_name);
3090: END IF;
3091:
3092: IF pay_gb_eoy_magtape.validate_input(UPPER(l_last_name), 'P11D_EDI') > 0
3093: THEN

Line 3096: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3092: IF pay_gb_eoy_magtape.validate_input(UPPER(l_last_name), 'P11D_EDI') > 0
3093: THEN
3094: l_error_assignment := TRUE;
3095: l_error := '1';
3096: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3097: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Last Name value ' || l_last_name);
3098: END IF;
3099:
3100:

Line 3097: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Last Name value ' || l_last_name);

3093: THEN
3094: l_error_assignment := TRUE;
3095: l_error := '1';
3096: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3097: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Last Name value ' || l_last_name);
3098: END IF;
3099:
3100:
3101: -- EOY 2008

Line 3107: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3103: IF l_ni_number is null THEN
3104: IF l_sex is null THEN
3105: l_error_assignment := TRUE;
3106: l_error := '1';
3107: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3108: pay_core_utils.push_token('TEXT', ': Magtape Validation has failed for missing gender value ' );
3109: END IF ;
3110:
3111: IF l_date_of_birth is not null THEN

Line 3108: pay_core_utils.push_token('TEXT', ': Magtape Validation has failed for missing gender value ' );

3104: IF l_sex is null THEN
3105: l_error_assignment := TRUE;
3106: l_error := '1';
3107: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3108: pay_core_utils.push_token('TEXT', ': Magtape Validation has failed for missing gender value ' );
3109: END IF ;
3110:
3111: IF l_date_of_birth is not null THEN
3112: IF l_date_of_birth > sysdate THEN

Line 3115: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3111: IF l_date_of_birth is not null THEN
3112: IF l_date_of_birth > sysdate THEN
3113: l_error_assignment := TRUE;
3114: l_error := '1';
3115: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3116: pay_core_utils.push_token('TEXT', ': Magtape Validation has failed for date of birth. The value must be the current date or an earlier date. ' );
3117: END IF;
3118: ELSE
3119: l_date_of_birth := to_date('19010101','YYYYMMDD') ;

Line 3116: pay_core_utils.push_token('TEXT', ': Magtape Validation has failed for date of birth. The value must be the current date or an earlier date. ' );

3112: IF l_date_of_birth > sysdate THEN
3113: l_error_assignment := TRUE;
3114: l_error := '1';
3115: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3116: pay_core_utils.push_token('TEXT', ': Magtape Validation has failed for date of birth. The value must be the current date or an earlier date. ' );
3117: END IF;
3118: ELSE
3119: l_date_of_birth := to_date('19010101','YYYYMMDD') ;
3120: END IF ;

Line 3214: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');

3210: to_date('05-04-' ||g_param_rep_run,'dd-mm-yyyy')
3211: Then
3212: l_error_assignment := TRUE;
3213: l_error := '1';
3214: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
3215: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);
3216: pay_core_utils.push_token('NAME', 'Benefit Start Date in ' || l_element_name);
3217: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3218: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);

Line 3215: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);

3211: Then
3212: l_error_assignment := TRUE;
3213: l_error := '1';
3214: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
3215: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);
3216: pay_core_utils.push_token('NAME', 'Benefit Start Date in ' || l_element_name);
3217: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3218: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3219: End if;

Line 3216: pay_core_utils.push_token('NAME', 'Benefit Start Date in ' || l_element_name);

3212: l_error_assignment := TRUE;
3213: l_error := '1';
3214: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
3215: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);
3216: pay_core_utils.push_token('NAME', 'Benefit Start Date in ' || l_element_name);
3217: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3218: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3219: End if;
3220:

Line 3217: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));

3213: l_error := '1';
3214: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
3215: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);
3216: pay_core_utils.push_token('NAME', 'Benefit Start Date in ' || l_element_name);
3217: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3218: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3219: End if;
3220:
3221: If fnd_date.canonical_to_date(l_benefit_end_date) <

Line 3218: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);

3214: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
3215: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);
3216: pay_core_utils.push_token('NAME', 'Benefit Start Date in ' || l_element_name);
3217: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3218: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3219: End if;
3220:
3221: If fnd_date.canonical_to_date(l_benefit_end_date) <
3222: to_date('06-04-' ||to_char(to_number(g_param_rep_run)-1),'dd-mm-yyyy') or

Line 3229: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');

3225: then
3226: l_error_assignment := TRUE;
3227: l_error := '1';
3228:
3229: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
3230: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);
3231: pay_core_utils.push_token('NAME', 'Benefit End Date in ' || l_element_name);
3232: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3233: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);

Line 3230: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);

3226: l_error_assignment := TRUE;
3227: l_error := '1';
3228:
3229: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
3230: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);
3231: pay_core_utils.push_token('NAME', 'Benefit End Date in ' || l_element_name);
3232: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3233: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3234: End if;

Line 3231: pay_core_utils.push_token('NAME', 'Benefit End Date in ' || l_element_name);

3227: l_error := '1';
3228:
3229: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
3230: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);
3231: pay_core_utils.push_token('NAME', 'Benefit End Date in ' || l_element_name);
3232: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3233: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3234: End if;
3235: -- Setting the array l_user_inputs with the input values from

Line 3232: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));

3228:
3229: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
3230: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);
3231: pay_core_utils.push_token('NAME', 'Benefit End Date in ' || l_element_name);
3232: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3233: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3234: End if;
3235: -- Setting the array l_user_inputs with the input values from
3236: -- element entry flexfield

Line 3233: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);

3229: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
3230: pay_core_utils.push_token('ELEMENT_NAME',l_element_name);
3231: pay_core_utils.push_token('NAME', 'Benefit End Date in ' || l_element_name);
3232: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3233: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3234: End if;
3235: -- Setting the array l_user_inputs with the input values from
3236: -- element entry flexfield
3237: hr_utility.trace(' classification_name ' ||g_tab_ben_detail(l_index).classification_name);

Line 3300: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');

3296: Exception
3297: when OTHERS then
3298: l_error_assignment := TRUE;
3299: l_error := '1';
3300: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');
3301: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3302: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3303: -- Remove ALL GLOBALS
3304: l_ret := per_formula_functions.remove_globals;

Line 3301: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);

3297: when OTHERS then
3298: l_error_assignment := TRUE;
3299: l_error := '1';
3300: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');
3301: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3302: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3303: -- Remove ALL GLOBALS
3304: l_ret := per_formula_functions.remove_globals;
3305: RAISE error_found;

Line 3355: --pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'A');

3351: AND INSTR(UPPER(l_outputs(l_counter).NAME), 'L_ERROR') = 0) )
3352: AND (l_outputs(l_counter).VALUE <> '' OR l_outputs(l_counter).VALUE IS NOT NULL)
3353: THEN
3354: -- this bit needs to be looked for proper error msgs
3355: --pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'A');
3356: -- if the message is a warning
3357: if ( instr(upper(l_outputs(l_counter).NAME), 'WARN') > 0 ) then
3358: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');
3359: pay_core_utils.push_token('TEXT', SUBSTR(l_outputs(l_counter).VALUE, 1, 200) );

Line 3358: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');

3354: -- this bit needs to be looked for proper error msgs
3355: --pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'A');
3356: -- if the message is a warning
3357: if ( instr(upper(l_outputs(l_counter).NAME), 'WARN') > 0 ) then
3358: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');
3359: pay_core_utils.push_token('TEXT', SUBSTR(l_outputs(l_counter).VALUE, 1, 200) );
3360: else
3361: l_error := '1';
3362: end if;

Line 3359: pay_core_utils.push_token('TEXT', SUBSTR(l_outputs(l_counter).VALUE, 1, 200) );

3355: --pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'A');
3356: -- if the message is a warning
3357: if ( instr(upper(l_outputs(l_counter).NAME), 'WARN') > 0 ) then
3358: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');
3359: pay_core_utils.push_token('TEXT', SUBSTR(l_outputs(l_counter).VALUE, 1, 200) );
3360: else
3361: l_error := '1';
3362: end if;
3363: /*

Line 3365: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3361: l_error := '1';
3362: end if;
3363: /*
3364: else
3365: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3366: pay_core_utils.push_token('TEXT', l_element_name ||': ' || SUBSTR(l_outputs(l_counter).VALUE, 2, 100) );
3367: end if;
3368: */
3369: hr_utility.TRACE('Error'|| l_outputs(l_counter).VALUE);

Line 3366: pay_core_utils.push_token('TEXT', l_element_name ||': ' || SUBSTR(l_outputs(l_counter).VALUE, 2, 100) );

3362: end if;
3363: /*
3364: else
3365: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3366: pay_core_utils.push_token('TEXT', l_element_name ||': ' || SUBSTR(l_outputs(l_counter).VALUE, 2, 100) );
3367: end if;
3368: */
3369: hr_utility.TRACE('Error'|| l_outputs(l_counter).VALUE);
3370: END IF;

Line 3433: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

3429: ELSE
3430: hr_utility.set_location('Magtape Validation failure', 35);
3431: l_error_assignment := TRUE;
3432: l_error := '1';
3433: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3434: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for '
3435: ||l_user_inputs(l_inner).NAME || ' value ' || l_user_inputs(l_inner).VALUE);
3436: END IF; -- checking exceptions for mag tape validations
3437: END IF; -- end if for magtape validation error

Line 3434: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for '

3430: hr_utility.set_location('Magtape Validation failure', 35);
3431: l_error_assignment := TRUE;
3432: l_error := '1';
3433: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3434: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for '
3435: ||l_user_inputs(l_inner).NAME || ' value ' || l_user_inputs(l_inner).VALUE);
3436: END IF; -- checking exceptions for mag tape validations
3437: END IF; -- end if for magtape validation error
3438: END LOOP; -- loop which runs thru inpout values

Line 3679: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');

3675: END IF;
3676: ELSE -- formual id is null
3677: l_error_assignment := TRUE;
3678: l_error := '1';
3679: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');
3680: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3681: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3682: END IF;
3683:

Line 3680: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);

3676: ELSE -- formual id is null
3677: l_error_assignment := TRUE;
3678: l_error := '1';
3679: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');
3680: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3681: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3682: END IF;
3683:
3684: hr_utility.trace('Looking at Next value!');