DBA Data[Home] [Help]

APPS.PAY_US_PSD_XML dependencies on PAY_CORE_UTILS

Line 1012: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1008: else
1009: hr_utility.trace('Pre process rules: WARNING');
1010: message_preprocess := 'PSD Periodic Wage Listing Report - One or more Employer PSD codes are missing in PSD Reporting Rules for a GRE. ';
1011: message_text := 'Please define the PSD Reporting rules for the PSD Code '||l_psd_code || ' for the GRE '||l_gre_name||' GRE ID: '||l_tax_unit_id;
1012: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1013: pay_core_utils.push_token('record_name',message_preprocess);
1014: pay_core_utils.push_token('description',message_text);
1015: end if; --l_psd_code = l_prev_psd_code
1016: l_prev_psd_code := l_psd_code;

Line 1013: pay_core_utils.push_token('record_name',message_preprocess);

1009: hr_utility.trace('Pre process rules: WARNING');
1010: message_preprocess := 'PSD Periodic Wage Listing Report - One or more Employer PSD codes are missing in PSD Reporting Rules for a GRE. ';
1011: message_text := 'Please define the PSD Reporting rules for the PSD Code '||l_psd_code || ' for the GRE '||l_gre_name||' GRE ID: '||l_tax_unit_id;
1012: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1013: pay_core_utils.push_token('record_name',message_preprocess);
1014: pay_core_utils.push_token('description',message_text);
1015: end if; --l_psd_code = l_prev_psd_code
1016: l_prev_psd_code := l_psd_code;
1017: end if; --PSD code exists or not

Line 1014: pay_core_utils.push_token('description',message_text);

1010: message_preprocess := 'PSD Periodic Wage Listing Report - One or more Employer PSD codes are missing in PSD Reporting Rules for a GRE. ';
1011: message_text := 'Please define the PSD Reporting rules for the PSD Code '||l_psd_code || ' for the GRE '||l_gre_name||' GRE ID: '||l_tax_unit_id;
1012: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1013: pay_core_utils.push_token('record_name',message_preprocess);
1014: pay_core_utils.push_token('description',message_text);
1015: end if; --l_psd_code = l_prev_psd_code
1016: l_prev_psd_code := l_psd_code;
1017: end if; --PSD code exists or not
1018: l_psd_code_exsists :='N';

Line 1030: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');

1026: --
1027: hr_utility.trace('Pre process rules returned false');
1028: message_preprocess := 'PSD Periodic Wage Listing Report - PSD Reporting Rules are missing for at least one GRE. ';
1029: message_text := 'Please define the PSD Reporting Rules for the GRE '||l_gre_name||' GRE ID: '||l_tax_unit_id;
1030: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
1031: pay_core_utils.push_token('record_name',message_preprocess);
1032: pay_core_utils.push_token('description',message_text);
1033:
1034: end if; --PSD Reporting Rules exist or not

Line 1031: pay_core_utils.push_token('record_name',message_preprocess);

1027: hr_utility.trace('Pre process rules returned false');
1028: message_preprocess := 'PSD Periodic Wage Listing Report - PSD Reporting Rules are missing for at least one GRE. ';
1029: message_text := 'Please define the PSD Reporting Rules for the GRE '||l_gre_name||' GRE ID: '||l_tax_unit_id;
1030: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
1031: pay_core_utils.push_token('record_name',message_preprocess);
1032: pay_core_utils.push_token('description',message_text);
1033:
1034: end if; --PSD Reporting Rules exist or not
1035: close c_check_psd_rules_for_gre;

Line 1032: pay_core_utils.push_token('description',message_text);

1028: message_preprocess := 'PSD Periodic Wage Listing Report - PSD Reporting Rules are missing for at least one GRE. ';
1029: message_text := 'Please define the PSD Reporting Rules for the GRE '||l_gre_name||' GRE ID: '||l_tax_unit_id;
1030: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
1031: pay_core_utils.push_token('record_name',message_preprocess);
1032: pay_core_utils.push_token('description',message_text);
1033:
1034: end if; --PSD Reporting Rules exist or not
1035: close c_check_psd_rules_for_gre;
1036: end loop; -- Ending the loop for list of all GREs under pay_us_asg_reporting which have assignments with PSD Tax deductions.

Line 1055: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1051: /* message to user -- Transmitter has not been archived */
1052: message_preprocess := 'PSD Periodic Wage Listing Report - ';
1053: message_text := 'Transmitter not Archived';
1054: hr_utility.trace('Transmitter has not been archived');
1055: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1056: pay_core_utils.push_token('record_name',message_preprocess);
1057: pay_core_utils.push_token('description',message_text);
1058: -- hr_utility.raise_error;
1059: END IF;

Line 1056: pay_core_utils.push_token('record_name',message_preprocess);

1052: message_preprocess := 'PSD Periodic Wage Listing Report - ';
1053: message_text := 'Transmitter not Archived';
1054: hr_utility.trace('Transmitter has not been archived');
1055: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1056: pay_core_utils.push_token('record_name',message_preprocess);
1057: pay_core_utils.push_token('description',message_text);
1058: -- hr_utility.raise_error;
1059: END IF;
1060: CLOSE c_gre_payroll_action;

Line 1057: pay_core_utils.push_token('description',message_text);

1053: message_text := 'Transmitter not Archived';
1054: hr_utility.trace('Transmitter has not been archived');
1055: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1056: pay_core_utils.push_token('record_name',message_preprocess);
1057: pay_core_utils.push_token('description',message_text);
1058: -- hr_utility.raise_error;
1059: END IF;
1060: CLOSE c_gre_payroll_action;
1061:

Line 1098: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');

1094: --
1095: --hr_utility.trace('Pre process rules returned false');
1096: message_preprocess := 'PSD Periodic Wage Listing Report - PSD Reporting Rules are missing for at least one GRE. ';
1097: message_text := 'Please define the PSD Reporting Rules for the GRE '||l_gre_name||' GRE ID: '||l_tax_unit_id;
1098: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
1099: pay_core_utils.push_token('record_name',message_preprocess);
1100: pay_core_utils.push_token('description',message_text);
1101: end if; --PSD Reporting Rules exist or not
1102: close c_check_psd_rules_for_gre;

Line 1099: pay_core_utils.push_token('record_name',message_preprocess);

1095: --hr_utility.trace('Pre process rules returned false');
1096: message_preprocess := 'PSD Periodic Wage Listing Report - PSD Reporting Rules are missing for at least one GRE. ';
1097: message_text := 'Please define the PSD Reporting Rules for the GRE '||l_gre_name||' GRE ID: '||l_tax_unit_id;
1098: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
1099: pay_core_utils.push_token('record_name',message_preprocess);
1100: pay_core_utils.push_token('description',message_text);
1101: end if; --PSD Reporting Rules exist or not
1102: close c_check_psd_rules_for_gre;
1103:

Line 1100: pay_core_utils.push_token('description',message_text);

1096: message_preprocess := 'PSD Periodic Wage Listing Report - PSD Reporting Rules are missing for at least one GRE. ';
1097: message_text := 'Please define the PSD Reporting Rules for the GRE '||l_gre_name||' GRE ID: '||l_tax_unit_id;
1098: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
1099: pay_core_utils.push_token('record_name',message_preprocess);
1100: pay_core_utils.push_token('description',message_text);
1101: end if; --PSD Reporting Rules exist or not
1102: close c_check_psd_rules_for_gre;
1103:
1104: ELSE

Line 1109: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');

1105: /* A warning is logged if GRE is not archived */
1106: l_package_error_status := 'N';
1107: message_preprocess := 'PSD Periodic Wage Listing Report - ';
1108: message_text := 'Please Archive GRE With ID := ' || to_char(l_tax_unit_id) ;
1109: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
1110: pay_core_utils.push_token('record_name',message_preprocess);
1111: pay_core_utils.push_token('description',message_text);
1112:
1113: END IF;

Line 1110: pay_core_utils.push_token('record_name',message_preprocess);

1106: l_package_error_status := 'N';
1107: message_preprocess := 'PSD Periodic Wage Listing Report - ';
1108: message_text := 'Please Archive GRE With ID := ' || to_char(l_tax_unit_id) ;
1109: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
1110: pay_core_utils.push_token('record_name',message_preprocess);
1111: pay_core_utils.push_token('description',message_text);
1112:
1113: END IF;
1114:

Line 1111: pay_core_utils.push_token('description',message_text);

1107: message_preprocess := 'PSD Periodic Wage Listing Report - ';
1108: message_text := 'Please Archive GRE With ID := ' || to_char(l_tax_unit_id) ;
1109: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
1110: pay_core_utils.push_token('record_name',message_preprocess);
1111: pay_core_utils.push_token('description',message_text);
1112:
1113: END IF;
1114:
1115: CLOSE c_gre_payroll_action;

Line 1124: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1120: IF l_package_error_status = 'Y' THEN
1121:
1122: hr_utility.trace('Error Condition Found');
1123: message_text := 'Error Condition detected ' ;
1124: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1125: pay_core_utils.push_token('record_name',message_preprocess);
1126: pay_core_utils.push_token('description',message_text);
1127:
1128: message_text := 'Pay Message line and log have more Details' ;

Line 1125: pay_core_utils.push_token('record_name',message_preprocess);

1121:
1122: hr_utility.trace('Error Condition Found');
1123: message_text := 'Error Condition detected ' ;
1124: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1125: pay_core_utils.push_token('record_name',message_preprocess);
1126: pay_core_utils.push_token('description',message_text);
1127:
1128: message_text := 'Pay Message line and log have more Details' ;
1129: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

Line 1126: pay_core_utils.push_token('description',message_text);

1122: hr_utility.trace('Error Condition Found');
1123: message_text := 'Error Condition detected ' ;
1124: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1125: pay_core_utils.push_token('record_name',message_preprocess);
1126: pay_core_utils.push_token('description',message_text);
1127:
1128: message_text := 'Pay Message line and log have more Details' ;
1129: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1130: pay_core_utils.push_token('record_name',message_preprocess);

Line 1129: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1125: pay_core_utils.push_token('record_name',message_preprocess);
1126: pay_core_utils.push_token('description',message_text);
1127:
1128: message_text := 'Pay Message line and log have more Details' ;
1129: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1130: pay_core_utils.push_token('record_name',message_preprocess);
1131: pay_core_utils.push_token('description',message_text);
1132: hr_utility.raise_error;
1133: END IF;

Line 1130: pay_core_utils.push_token('record_name',message_preprocess);

1126: pay_core_utils.push_token('description',message_text);
1127:
1128: message_text := 'Pay Message line and log have more Details' ;
1129: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1130: pay_core_utils.push_token('record_name',message_preprocess);
1131: pay_core_utils.push_token('description',message_text);
1132: hr_utility.raise_error;
1133: END IF;
1134:

Line 1131: pay_core_utils.push_token('description',message_text);

1127:
1128: message_text := 'Pay Message line and log have more Details' ;
1129: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1130: pay_core_utils.push_token('record_name',message_preprocess);
1131: pay_core_utils.push_token('description',message_text);
1132: hr_utility.raise_error;
1133: END IF;
1134:
1135: IF l_no_of_gres_picked = 0 THEN

Line 1140: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1136: --It means that no archived GRE was
1137: --found for the Organization. This is an error.
1138:
1139: message_text := 'No GRE was picked for Magnetic Tape';
1140: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1141: pay_core_utils.push_token('record_name',message_preprocess);
1142: pay_core_utils.push_token('description',message_text);
1143: hr_utility.raise_error;
1144: END IF;

Line 1141: pay_core_utils.push_token('record_name',message_preprocess);

1137: --found for the Organization. This is an error.
1138:
1139: message_text := 'No GRE was picked for Magnetic Tape';
1140: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1141: pay_core_utils.push_token('record_name',message_preprocess);
1142: pay_core_utils.push_token('description',message_text);
1143: hr_utility.raise_error;
1144: END IF;
1145:

Line 1142: pay_core_utils.push_token('description',message_text);

1138:
1139: message_text := 'No GRE was picked for Magnetic Tape';
1140: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1141: pay_core_utils.push_token('record_name',message_preprocess);
1142: pay_core_utils.push_token('description',message_text);
1143: hr_utility.raise_error;
1144: END IF;
1145:
1146: END IF;

Line 1307: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1303: NULL;
1304: /* hr_utility.trace('Pre process rules returned false');
1305: message_preprocess := 'PSD Periodic Wage Listing Report - PSD Reporting Rules Missing for at least one GRE.';
1306: message_text := 'Please define the PSD Reporting Rules for the GRE '||l_gre_name||' GRE ID: '||l_trans_legal_co_id;
1307: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1308: pay_core_utils.push_token('record_name',message_preprocess);
1309: pay_core_utils.push_token('description',message_text);*/
1310: end if; -- End of pre process rules check
1311:

Line 1308: pay_core_utils.push_token('record_name',message_preprocess);

1304: /* hr_utility.trace('Pre process rules returned false');
1305: message_preprocess := 'PSD Periodic Wage Listing Report - PSD Reporting Rules Missing for at least one GRE.';
1306: message_text := 'Please define the PSD Reporting Rules for the GRE '||l_gre_name||' GRE ID: '||l_trans_legal_co_id;
1307: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1308: pay_core_utils.push_token('record_name',message_preprocess);
1309: pay_core_utils.push_token('description',message_text);*/
1310: end if; -- End of pre process rules check
1311:
1312: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 40);

Line 1309: pay_core_utils.push_token('description',message_text);*/

1305: message_preprocess := 'PSD Periodic Wage Listing Report - PSD Reporting Rules Missing for at least one GRE.';
1306: message_text := 'Please define the PSD Reporting Rules for the GRE '||l_gre_name||' GRE ID: '||l_trans_legal_co_id;
1307: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1308: pay_core_utils.push_token('record_name',message_preprocess);
1309: pay_core_utils.push_token('description',message_text);*/
1310: end if; -- End of pre process rules check
1311:
1312: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 40);
1313: hr_utility.trace( 'Value of the l_period_type is: '||l_period_type);

Line 1396: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1392:
1393:
1394: hr_utility.trace('W2 Reporting rules have not been setup');
1395:
1396: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1397: pay_core_utils.push_token('record_name',message_preprocess);
1398: pay_core_utils.push_token('description',message_text);
1399:
1400: end if;

Line 1397: pay_core_utils.push_token('record_name',message_preprocess);

1393:
1394: hr_utility.trace('W2 Reporting rules have not been setup');
1395:
1396: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1397: pay_core_utils.push_token('record_name',message_preprocess);
1398: pay_core_utils.push_token('description',message_text);
1399:
1400: end if;
1401: close c_w2_reporting_rules;

Line 1398: pay_core_utils.push_token('description',message_text);

1394: hr_utility.trace('W2 Reporting rules have not been setup');
1395:
1396: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1397: pay_core_utils.push_token('record_name',message_preprocess);
1398: pay_core_utils.push_token('description',message_text);
1399:
1400: end if;
1401: close c_w2_reporting_rules;
1402:

Line 1418: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1414:
1415:
1416: hr_utility.trace('PSD Reporting rules have not been setup');
1417:
1418: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1419: pay_core_utils.push_token('record_name',message_preprocess);
1420: pay_core_utils.push_token('description',message_text);
1421:
1422: end if;

Line 1419: pay_core_utils.push_token('record_name',message_preprocess);

1415:
1416: hr_utility.trace('PSD Reporting rules have not been setup');
1417:
1418: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1419: pay_core_utils.push_token('record_name',message_preprocess);
1420: pay_core_utils.push_token('description',message_text);
1421:
1422: end if;
1423: close c_psd_reporting_rules;

Line 1420: pay_core_utils.push_token('description',message_text);

1416: hr_utility.trace('PSD Reporting rules have not been setup');
1417:
1418: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1419: pay_core_utils.push_token('record_name',message_preprocess);
1420: pay_core_utils.push_token('description',message_text);
1421:
1422: end if;
1423: close c_psd_reporting_rules;
1424: