APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_CORE_UTILS

Line 1124: pay_core_utils.push_message(801,

1120: l_period_start,l_period_end);
1121: fetch c_get_asg_act_id into l_max_aaid;
1122:
1123: if c_get_asg_act_id%NOTFOUND then
1124: pay_core_utils.push_message(801,
1125: 'PAY_74038_EOY_EXCP_NO_PAYROLL','A');
1126: pay_core_utils.push_token('person','Person id: '
1127: ||to_char(l_person_id));
1128: pay_core_utils.push_token('reporting_year','Reporting Year: '

Line 1126: pay_core_utils.push_token('person','Person id: '

1122:
1123: if c_get_asg_act_id%NOTFOUND then
1124: pay_core_utils.push_message(801,
1125: 'PAY_74038_EOY_EXCP_NO_PAYROLL','A');
1126: pay_core_utils.push_token('person','Person id: '
1127: ||to_char(l_person_id));
1128: pay_core_utils.push_token('reporting_year','Reporting Year: '
1129: ||to_char(l_effective_date,'YYYY'));
1130:

Line 1128: pay_core_utils.push_token('reporting_year','Reporting Year: '

1124: pay_core_utils.push_message(801,
1125: 'PAY_74038_EOY_EXCP_NO_PAYROLL','A');
1126: pay_core_utils.push_token('person','Person id: '
1127: ||to_char(l_person_id));
1128: pay_core_utils.push_token('reporting_year','Reporting Year: '
1129: ||to_char(l_effective_date,'YYYY'));
1130:
1131: l_max_aaid := -9999;
1132: end if;

Line 1189: pay_core_utils.push_message(800,'HR_74004_ASSIGNMENT_ABSENT','A');

1185: fetch c_get_asg_id into l_primary_asg;
1186:
1187: if c_get_asg_id%NOTFOUND then
1188: close c_get_asg_id;
1189: pay_core_utils.push_message(800,'HR_74004_ASSIGNMENT_ABSENT','A');
1190: raise hr_utility.hr_error;
1191: else
1192: close c_get_asg_id;
1193: end if;

Line 1477: pay_core_utils.push_message(801,'PAY_74014_NO_TRANSMITTER_ORG','A');

1473:
1474: hr_utility.trace('eoy_archive_gre_data 2');
1475: close employer_info;
1476:
1477: pay_core_utils.push_message(801,'PAY_74014_NO_TRANSMITTER_ORG','A');
1478: pay_core_utils.push_token('orgind','Prov Reporting Est: '
1479: ||p_pre_org_id);
1480: hr_utility.raise_error;
1481: end if; /* end if for employer_info%FOUND */

Line 1478: pay_core_utils.push_token('orgind','Prov Reporting Est: '

1474: hr_utility.trace('eoy_archive_gre_data 2');
1475: close employer_info;
1476:
1477: pay_core_utils.push_message(801,'PAY_74014_NO_TRANSMITTER_ORG','A');
1478: pay_core_utils.push_token('orgind','Prov Reporting Est: '
1479: ||p_pre_org_id);
1480: hr_utility.raise_error;
1481: end if; /* end if for employer_info%FOUND */
1482:

Line 1652: pay_core_utils.push_message(801,'PAY_74014_NO_TRANSMITTER_ORG','A');

1648: g_archive_flag := 'N';
1649: hr_utility.trace('Error in eoy_archive_gre_data at step :' ||
1650: to_char(l_arch_gre_step) || 'sqlcode : ' || to_char(sqlcode));
1651: if l_arch_gre_step = 40 then
1652: pay_core_utils.push_message(801,'PAY_74014_NO_TRANSMITTER_ORG','A');
1653: pay_core_utils.push_token('orgind','Prov Reporting Est: '
1654: ||p_pre_org_id);
1655: end if;
1656: hr_utility.raise_error;

Line 1653: pay_core_utils.push_token('orgind','Prov Reporting Est: '

1649: hr_utility.trace('Error in eoy_archive_gre_data at step :' ||
1650: to_char(l_arch_gre_step) || 'sqlcode : ' || to_char(sqlcode));
1651: if l_arch_gre_step = 40 then
1652: pay_core_utils.push_message(801,'PAY_74014_NO_TRANSMITTER_ORG','A');
1653: pay_core_utils.push_token('orgind','Prov Reporting Est: '
1654: ||p_pre_org_id);
1655: end if;
1656: hr_utility.raise_error;
1657:

Line 3056: pay_core_utils.push_message(800,'HR_74010_NO_RES_ADDRESS','A');

3052: ,l_province_code
3053: ,l_postal_code
3054: ,l_country_code;
3055: if c_get_sec_addr%NOTFOUND then
3056: pay_core_utils.push_message(800,'HR_74010_NO_RES_ADDRESS','A');
3057:
3058: l_address_line1 := null;
3059: l_address_line2 := null;
3060: l_address_line3 := null;