[Home] [Help]
1473: p_payroll_id NUMBER,
1474: p_user_entity_id NUMBER,
1475: p_value VARCHAR2) IS
1476: BEGIN
1477: ff_archive_api.create_archive_item
1478: (p_archive_item_id => l_archive_item_id,
1479: p_user_entity_id => p_user_entity_id,
1480: p_archive_value => p_value,
1481: p_archive_type => 'PA',
1630: --
1631: WHEN test_indicator_error THEN
1632: l_payroll_action_message :=
1633: 'You must provide a Unique Test ID if the EDI Test Indicator is Yes.';
1634: ff_archive_api.create_archive_item
1635: (p_archive_item_id => l_archive_item_id,
1636: p_user_entity_id => l_payroll_action_message_eid,
1637: p_archive_value => l_payroll_action_message,
1638: p_archive_type => 'PA',
1647:
1648: WHEN live_submission_error THEN
1649: l_payroll_action_message :=
1650: 'Unique Id cannot begin with TEST for a live Submission.';
1651: ff_archive_api.create_archive_item
1652: (p_archive_item_id => l_archive_item_id,
1653: p_user_entity_id => l_payroll_action_message_eid,
1654: p_archive_value => l_payroll_action_message,
1655: p_archive_type => 'PA',
1663: --
1664: WHEN tax_dist_ref_error THEN
1665: l_payroll_action_message :=
1666: 'Invalid Format for Tax District Reference: Must be three numerics';
1667: ff_archive_api.create_archive_item
1668: (p_archive_item_id => l_archive_item_id,
1669: p_user_entity_id => l_payroll_action_message_eid,
1670: p_archive_value => l_payroll_action_message,
1671: p_archive_type => 'PA',
1678: WHEN inconsis_ref_error THEN
1679: l_payroll_action_message :=
1680: 'More than one PAYE Ref found on payroll '||l_payroll_name||
1681: ' in the tax year.';
1682: ff_archive_api.create_archive_item
1683: (p_archive_item_id => l_archive_item_id,
1684: p_user_entity_id => l_payroll_action_message_eid,
1685: p_archive_value => l_payroll_action_message,
1686: p_archive_type => 'PA',
1700: -- Write to the conc logfile, and try to archive err msg.
1701: fnd_file.put_line(fnd_file.log, substr(sqlerrm(sqlcode),1,80));
1702: l_payroll_action_message := substr('Payroll Extract failed with: '||
1703: sqlerrm(sqlcode),1,240);
1704: ff_archive_api.create_archive_item
1705: (p_archive_item_id => l_archive_item_id,
1706: p_user_entity_id => l_payroll_action_message_eid,
1707: p_archive_value => l_payroll_action_message,
1708: p_archive_type => 'PA',
2152: -- the last action created to indicate that it was the last asg
2153: -- for that person/tax ref group.
2154: -- first row will not come here due to null trap with
2155: -- rec_prev_asg.multiple_asg_flag
2156: ff_archive_api.create_archive_item
2157: (p_archive_item_id => l_archive_item_id,
2158: p_user_entity_id => g_last_multi_asg_eid,
2159: p_archive_value => 'Y',
2160: p_archive_type => 'AAC',
2185: --
2186: hr_nonrun_asact.insact(l_actid,rec_assignment.assignment_id,
2187: pactid,chunk,NULL);
2188: -- archive the effective end date
2189: ff_archive_api.create_archive_item
2190: (p_archive_item_id => l_archive_item_id,
2191: p_user_entity_id => g_effective_end_date_eid,
2192: p_archive_value => fnd_date.date_to_canonical
2193: (rec_assignment.effective_end_date),
2197: p_object_version_number => l_ovn,
2198: p_some_warning => l_some_warning);
2199: -- If tax_ref_xfer is Y, archive the X_TAX_REF_TRANSFER DBI
2200: IF rec_assignment.tax_ref_xfer = 'Y' THEN
2201: ff_archive_api.create_archive_item
2202: (p_archive_item_id => l_archive_item_id,
2203: p_user_entity_id => g_tax_ref_transfer_eid,
2204: p_archive_value => 'Y',
2205: p_archive_type => 'AAC',
2210: END IF;
2211: -- If multiple assignments aggregated then archive first and last active
2212: -- or suspended status start and end dates amongst aggregated asgs
2213: IF rec_assignment.multiple_asg_flag = 'Y' THEN
2214: ff_archive_api.create_archive_item
2215: (p_archive_item_id => l_archive_item_id,
2216: p_user_entity_id => g_agg_active_start_eid,
2217: p_archive_value => fnd_date.date_to_canonical(rec_assignment.agg_active_start),
2218: p_archive_type => 'AAC',
2220: p_legislation_code => 'GB',
2221: p_object_version_number => l_ovn,
2222: p_some_warning => l_some_warning);
2223: --
2224: ff_archive_api.create_archive_item
2225: (p_archive_item_id => l_archive_item_id,
2226: p_user_entity_id => g_agg_active_end_eid,
2227: p_archive_value => fnd_date.date_to_canonical(rec_assignment.agg_active_end),
2228: p_archive_type => 'AAC',
3933: l_proc CONSTANT VARCHAR2(40):= g_package||'archive_asg_info';
3934: BEGIN
3935: IF p_value IS NOT NULL THEN
3936: hr_utility.set_location(l_proc||' '||p_user_entity_id,10);
3937: ff_archive_api.create_archive_item
3938: (p_archive_item_id => l_archive_item_id,
3939: p_user_entity_id => p_user_entity_id,
3940: p_archive_value => p_value,
3941: p_action_id => nvl(p_actid,p_assactid),
3987: hr_utility.trace('p_actid='||p_actid);
3988: hr_utility.trace('p_assactid='||p_assactid);
3989: IF p_value IS NOT NULL THEN
3990: IF p_scon IS NOT NULL THEN
3991: ff_archive_api.create_archive_item
3992: (p_archive_item_id => l_archive_item_id,
3993: p_user_entity_id => p_user_entity_id,
3994: p_archive_value => p_value,
3995: p_action_id => nvl(p_actid,p_assactid),
4002: p_context_name3 => 'SOURCE_TEXT',
4003: p_context3 => p_scon,
4004: p_some_warning => l_some_warning);
4005: ELSE
4006: ff_archive_api.create_archive_item
4007: (p_archive_item_id => l_archive_item_id,
4008: p_user_entity_id => p_user_entity_id,
4009: p_archive_value => p_value,
4010: p_action_id => nvl(p_actid,p_assactid),
6056: THEN
6057: -- This is the last asg for the person in this tax ref
6058: -- archive the primary assignment flag against the primary action
6059: hr_utility.set_location(l_proc,170);
6060: ff_archive_api.create_archive_item
6061: (p_archive_item_id => l_archive_item_id,
6062: p_user_entity_id => g_eoy_primary_flag_eid,
6063: p_archive_value => 'Y',
6064: p_action_id => g_primary_action,