APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_CORE_UTILS

Line 1285: pay_core_utils.push_message(801,

1281: l_period_start,l_period_end);
1282: fetch c_get_asg_act_id into l_max_aaid;
1283:
1284: if c_get_asg_act_id%NOTFOUND then
1285: pay_core_utils.push_message(801,
1286: 'PAY_74038_EOY_EXCP_NO_PAYROLL','A');
1287: pay_core_utils.push_token('person','Person id: '
1288: ||to_char(l_person_id));
1289: pay_core_utils.push_token('reporting_year','Reporting Year: '

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

1283:
1284: if c_get_asg_act_id%NOTFOUND then
1285: pay_core_utils.push_message(801,
1286: 'PAY_74038_EOY_EXCP_NO_PAYROLL','A');
1287: pay_core_utils.push_token('person','Person id: '
1288: ||to_char(l_person_id));
1289: pay_core_utils.push_token('reporting_year','Reporting Year: '
1290: ||to_char(l_effective_date,'YYYY'));
1291:

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

1285: pay_core_utils.push_message(801,
1286: 'PAY_74038_EOY_EXCP_NO_PAYROLL','A');
1287: pay_core_utils.push_token('person','Person id: '
1288: ||to_char(l_person_id));
1289: pay_core_utils.push_token('reporting_year','Reporting Year: '
1290: ||to_char(l_effective_date,'YYYY'));
1291:
1292: l_max_aaid := -9999;
1293: end if;

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

1346: fetch c_get_asg_id into l_primary_asg;
1347:
1348: if c_get_asg_id%NOTFOUND then
1349: close c_get_asg_id;
1350: pay_core_utils.push_message(800,'HR_74004_ASSIGNMENT_ABSENT','A');
1351: raise hr_utility.hr_error;
1352: else
1353: close c_get_asg_id;
1354: end if;

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

1643:
1644: hr_utility.trace('eoy_archive_gre_data 2');
1645: close employer_info;
1646:
1647: pay_core_utils.push_message(801,'PAY_74014_NO_TRANSMITTER_ORG','A');
1648: pay_core_utils.push_token('orgind','Prov Reporting Est: '
1649: ||p_pre_org_id);
1650: hr_utility.raise_error;
1651: end if; /* end if for employer_info%FOUND */

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

1644: hr_utility.trace('eoy_archive_gre_data 2');
1645: close employer_info;
1646:
1647: pay_core_utils.push_message(801,'PAY_74014_NO_TRANSMITTER_ORG','A');
1648: pay_core_utils.push_token('orgind','Prov Reporting Est: '
1649: ||p_pre_org_id);
1650: hr_utility.raise_error;
1651: end if; /* end if for employer_info%FOUND */
1652:

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

1818: g_archive_flag := 'N';
1819: hr_utility.trace('Error in eoy_archive_gre_data at step :' ||
1820: to_char(l_arch_gre_step) || 'sqlcode : ' || to_char(sqlcode));
1821: if l_arch_gre_step = 40 then
1822: pay_core_utils.push_message(801,'PAY_74014_NO_TRANSMITTER_ORG','A');
1823: pay_core_utils.push_token('orgind','Prov Reporting Est: '
1824: ||p_pre_org_id);
1825: end if;
1826: hr_utility.raise_error;

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

1819: hr_utility.trace('Error in eoy_archive_gre_data at step :' ||
1820: to_char(l_arch_gre_step) || 'sqlcode : ' || to_char(sqlcode));
1821: if l_arch_gre_step = 40 then
1822: pay_core_utils.push_message(801,'PAY_74014_NO_TRANSMITTER_ORG','A');
1823: pay_core_utils.push_token('orgind','Prov Reporting Est: '
1824: ||p_pre_org_id);
1825: end if;
1826: hr_utility.raise_error;
1827:

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

3861: ,l_province_code
3862: ,l_postal_code
3863: ,l_country_code;
3864: if c_get_sec_addr%NOTFOUND then
3865: pay_core_utils.push_message(800,'HR_74010_NO_RES_ADDRESS','A');
3866:
3867: l_address_line1 := null;
3868: l_address_line2 := null;
3869: l_address_line3 := null;