[Home] [Help]
1447: p_payroll_id NUMBER,
1448: p_user_entity_id NUMBER,
1449: p_value VARCHAR2) IS
1450: BEGIN
1451: ff_archive_api.create_archive_item
1452: (p_archive_item_id => l_archive_item_id,
1453: p_user_entity_id => p_user_entity_id,
1454: p_archive_value => p_value,
1455: p_archive_type => 'PA',
1600: --
1601: WHEN test_indicator_error THEN
1602: l_payroll_action_message :=
1603: 'You must provide a Unique Test ID if the EDI Test Indicator is Yes.';
1604: ff_archive_api.create_archive_item
1605: (p_archive_item_id => l_archive_item_id,
1606: p_user_entity_id => l_payroll_action_message_eid,
1607: p_archive_value => l_payroll_action_message,
1608: p_archive_type => 'PA',
1616: --
1617: WHEN tax_dist_ref_error THEN
1618: l_payroll_action_message :=
1619: 'Invalid Format for Tax District Reference: Must be three numerics';
1620: ff_archive_api.create_archive_item
1621: (p_archive_item_id => l_archive_item_id,
1622: p_user_entity_id => l_payroll_action_message_eid,
1623: p_archive_value => l_payroll_action_message,
1624: p_archive_type => 'PA',
1631: WHEN inconsis_ref_error THEN
1632: l_payroll_action_message :=
1633: 'More than one PAYE Ref found on payroll '||l_payroll_name||
1634: ' in the tax year.';
1635: ff_archive_api.create_archive_item
1636: (p_archive_item_id => l_archive_item_id,
1637: p_user_entity_id => l_payroll_action_message_eid,
1638: p_archive_value => l_payroll_action_message,
1639: p_archive_type => 'PA',
1653: -- Write to the conc logfile, and try to archive err msg.
1654: fnd_file.put_line(fnd_file.log, substr(sqlerrm(sqlcode),1,80));
1655: l_payroll_action_message := substr('Payroll Extract failed with: '||
1656: sqlerrm(sqlcode),1,240);
1657: ff_archive_api.create_archive_item
1658: (p_archive_item_id => l_archive_item_id,
1659: p_user_entity_id => l_payroll_action_message_eid,
1660: p_archive_value => l_payroll_action_message,
1661: p_archive_type => 'PA',
2103: -- the last action created to indicate that it was the last asg
2104: -- for that person/tax ref group.
2105: -- first row will not come here due to null trap with
2106: -- rec_prev_asg.multiple_asg_flag
2107: ff_archive_api.create_archive_item
2108: (p_archive_item_id => l_archive_item_id,
2109: p_user_entity_id => g_last_multi_asg_eid,
2110: p_archive_value => 'Y',
2111: p_archive_type => 'AAC',
2136: --
2137: hr_nonrun_asact.insact(l_actid,rec_assignment.assignment_id,
2138: pactid,chunk,NULL);
2139: -- archive the effective end date
2140: ff_archive_api.create_archive_item
2141: (p_archive_item_id => l_archive_item_id,
2142: p_user_entity_id => g_effective_end_date_eid,
2143: p_archive_value => fnd_date.date_to_canonical
2144: (rec_assignment.effective_end_date),
2148: p_object_version_number => l_ovn,
2149: p_some_warning => l_some_warning);
2150: -- If tax_ref_xfer is Y, archive the X_TAX_REF_TRANSFER DBI
2151: IF rec_assignment.tax_ref_xfer = 'Y' THEN
2152: ff_archive_api.create_archive_item
2153: (p_archive_item_id => l_archive_item_id,
2154: p_user_entity_id => g_tax_ref_transfer_eid,
2155: p_archive_value => 'Y',
2156: p_archive_type => 'AAC',
2161: END IF;
2162: -- If multiple assignments aggregated then archive first and last active
2163: -- or suspended status start and end dates amongst aggregated asgs
2164: IF rec_assignment.multiple_asg_flag = 'Y' THEN
2165: ff_archive_api.create_archive_item
2166: (p_archive_item_id => l_archive_item_id,
2167: p_user_entity_id => g_agg_active_start_eid,
2168: p_archive_value => fnd_date.date_to_canonical(rec_assignment.agg_active_start),
2169: p_archive_type => 'AAC',
2171: p_legislation_code => 'GB',
2172: p_object_version_number => l_ovn,
2173: p_some_warning => l_some_warning);
2174: --
2175: ff_archive_api.create_archive_item
2176: (p_archive_item_id => l_archive_item_id,
2177: p_user_entity_id => g_agg_active_end_eid,
2178: p_archive_value => fnd_date.date_to_canonical(rec_assignment.agg_active_end),
2179: p_archive_type => 'AAC',
3771: l_proc CONSTANT VARCHAR2(40):= g_package||'archive_asg_info';
3772: BEGIN
3773: IF p_value IS NOT NULL THEN
3774: hr_utility.set_location(l_proc||' '||p_user_entity_id,10);
3775: ff_archive_api.create_archive_item
3776: (p_archive_item_id => l_archive_item_id,
3777: p_user_entity_id => p_user_entity_id,
3778: p_archive_value => p_value,
3779: p_action_id => nvl(p_actid,p_assactid),
3825: hr_utility.trace('p_actid='||p_actid);
3826: hr_utility.trace('p_assactid='||p_assactid);
3827: IF p_value IS NOT NULL THEN
3828: IF p_scon IS NOT NULL THEN
3829: ff_archive_api.create_archive_item
3830: (p_archive_item_id => l_archive_item_id,
3831: p_user_entity_id => p_user_entity_id,
3832: p_archive_value => p_value,
3833: p_action_id => nvl(p_actid,p_assactid),
3840: p_context_name3 => 'SOURCE_TEXT',
3841: p_context3 => p_scon,
3842: p_some_warning => l_some_warning);
3843: ELSE
3844: ff_archive_api.create_archive_item
3845: (p_archive_item_id => l_archive_item_id,
3846: p_user_entity_id => p_user_entity_id,
3847: p_archive_value => p_value,
3848: p_action_id => nvl(p_actid,p_assactid),
5799: THEN
5800: -- This is the last asg for the person in this tax ref
5801: -- archive the primary assignment flag against the primary action
5802: hr_utility.set_location(l_proc,170);
5803: ff_archive_api.create_archive_item
5804: (p_archive_item_id => l_archive_item_id,
5805: p_user_entity_id => g_eoy_primary_flag_eid,
5806: p_archive_value => 'Y',
5807: p_action_id => g_primary_action,