DBA Data[Home] [Help]

APPS.PAY_ETP_BUS dependencies on STANDARD

Line 1760: -- |-----------------------< chk_standard_link_flag >-------------------------|

1756: hr_utility.set_location('Leaving:'||l_proc, 10);
1757: End;
1758: --
1759: -- ----------------------------------------------------------------------------
1760: -- |-----------------------< chk_standard_link_flag >-------------------------|
1761: -- ----------------------------------------------------------------------------
1762: -- {Start Of Comments}
1763: --
1764: -- Description:

Line 1767: -- a) Standard_link_flag cannot be 'Y' when the Processing_type is 'N'

1763: --
1764: -- Description:
1765: -- This procedure is used to validate the following business rules:
1766: --
1767: -- a) Standard_link_flag cannot be 'Y' when the Processing_type is 'N'
1768: -- or Multiple_entries_allowed_flag is 'Y'.
1769: --
1770: -- Prerequisites:
1771: -- This procedure is called from insert_validate and update_validate.

Line 1774: -- p_standard_link_flag

1770: -- Prerequisites:
1771: -- This procedure is called from insert_validate and update_validate.
1772: --
1773: -- In Parameters:
1774: -- p_standard_link_flag
1775: -- p_processing_type
1776: -- p_multiple_entries_allowed_flg
1777: --
1778: -- Post Success:

Line 1789: Procedure chk_standard_link_flag

1785: -- Internal Row Handler Use Only.
1786: --
1787: -- {End Of Comments}
1788: -- ----------------------------------------------------------------------------
1789: Procedure chk_standard_link_flag
1790: (p_effective_date in date
1791: ,p_standard_link_flag in varchar2
1792: ,p_processing_type in varchar2
1793: ,p_multiple_entries_allowed_flg in varchar2

Line 1791: ,p_standard_link_flag in varchar2

1787: -- {End Of Comments}
1788: -- ----------------------------------------------------------------------------
1789: Procedure chk_standard_link_flag
1790: (p_effective_date in date
1791: ,p_standard_link_flag in varchar2
1792: ,p_processing_type in varchar2
1793: ,p_multiple_entries_allowed_flg in varchar2
1794: ) is
1795: --

Line 1796: l_proc varchar2(72) := g_package||'chk_standard_link';

1792: ,p_processing_type in varchar2
1793: ,p_multiple_entries_allowed_flg in varchar2
1794: ) is
1795: --
1796: l_proc varchar2(72) := g_package||'chk_standard_link';
1797: --
1798: Begin
1799: hr_utility.set_location('Entering:'||l_proc, 5);
1800: --

Line 1804: ,p_standard_link_flag) Then

1800: --
1801: If hr_api.not_exists_in_hr_lookups
1802: (p_effective_date
1803: ,'YES_NO'
1804: ,p_standard_link_flag) Then
1805: --
1806: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1807: fnd_message.set_token('COLUMN','STANDARD_LINK_FLAG');
1808: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

Line 1807: fnd_message.set_token('COLUMN','STANDARD_LINK_FLAG');

1803: ,'YES_NO'
1804: ,p_standard_link_flag) Then
1805: --
1806: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1807: fnd_message.set_token('COLUMN','STANDARD_LINK_FLAG');
1808: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1809: fnd_message.raise_error;
1810: --
1811: End If;

Line 1813: If (p_standard_link_flag = 'Y' and p_processing_type = 'N') Then

1809: fnd_message.raise_error;
1810: --
1811: End If;
1812: --
1813: If (p_standard_link_flag = 'Y' and p_processing_type = 'N') Then
1814: --
1815: fnd_message.set_name('PAY','PAY_6140_ELEMENT_NO_STANDARD');
1816: fnd_message.raise_error;
1817: --

Line 1815: fnd_message.set_name('PAY','PAY_6140_ELEMENT_NO_STANDARD');

1811: End If;
1812: --
1813: If (p_standard_link_flag = 'Y' and p_processing_type = 'N') Then
1814: --
1815: fnd_message.set_name('PAY','PAY_6140_ELEMENT_NO_STANDARD');
1816: fnd_message.raise_error;
1817: --
1818: End If;
1819: If (p_standard_link_flag = 'Y' and p_multiple_entries_allowed_flg = 'Y') Then

Line 1819: If (p_standard_link_flag = 'Y' and p_multiple_entries_allowed_flg = 'Y') Then

1815: fnd_message.set_name('PAY','PAY_6140_ELEMENT_NO_STANDARD');
1816: fnd_message.raise_error;
1817: --
1818: End If;
1819: If (p_standard_link_flag = 'Y' and p_multiple_entries_allowed_flg = 'Y') Then
1820: --
1821: fnd_message.set_name('PAY','HR_6952_PAY_ELE_NO_STD_MULTI');
1822: fnd_message.raise_error;
1823: --

Line 2580: -- a) Indirect_Only_Flag, Additional_Entry_Allowed_Flag, Standard_Link_Flag,

2576: --
2577: -- Description:
2578: -- This procedure is used to validate the following business rules:
2579: --
2580: -- a) Indirect_Only_Flag, Additional_Entry_Allowed_Flag, Standard_Link_Flag,
2581: -- Adjustment_Only_Flag, Post_Termination_Rule, Process_In_Run_Flag and
2582: -- Once_Each_Period_Flag can only be updated if:
2583: --
2584: -- i. There are no element links for the element.

Line 2605: -- p_Standard_Link_Flag

2601: -- In Parameters:
2602: -- p_element_type_id
2603: -- p_Indirect_Only_Flag
2604: -- p_Additional_Entry_Allowed_Flg
2605: -- p_Standard_Link_Flag
2606: -- p_Adjustment_Only_Flag
2607: -- p_Post_Termination_Rule
2608: -- p_Process_In_Run_Flag
2609: -- p_validation_start_date

Line 2628: ,p_standard_link_flag in varchar2

2624: Procedure chk_update_allowed
2625: (p_element_type_id in number
2626: ,p_indirect_only_flag in varchar2
2627: ,p_additional_entry_allowed_flg in varchar2
2628: ,p_standard_link_flag in varchar2
2629: ,p_adjustment_only_flag in varchar2
2630: ,p_post_termination_rule in varchar2
2631: ,p_process_in_run_flag in varchar2
2632: ,p_validation_start_date in date

Line 2651: (p_standard_link_flag <> pay_etp_shd.g_old_rec.standard_link_flag)

2647: or
2648: (p_additional_entry_allowed_flg <>
2649: pay_etp_shd.g_old_rec.additional_entry_allowed_flag)
2650: or
2651: (p_standard_link_flag <> pay_etp_shd.g_old_rec.standard_link_flag)
2652: or
2653: (p_adjustment_only_flag <> pay_etp_shd.g_old_rec.adjustment_only_flag)
2654: or
2655: (p_post_termination_rule <> pay_etp_shd.g_old_rec.post_termination_rule)

Line 3077: chk_standard_link_flag

3073: (p_effective_date
3074: ,p_rec.processing_type
3075: ,p_rec.benefit_classification_id);
3076: --
3077: chk_standard_link_flag
3078: (p_effective_date
3079: ,p_rec.standard_link_flag
3080: ,p_rec.processing_type
3081: ,p_rec.multiple_entries_allowed_flag);

Line 3079: ,p_rec.standard_link_flag

3075: ,p_rec.benefit_classification_id);
3076: --
3077: chk_standard_link_flag
3078: (p_effective_date
3079: ,p_rec.standard_link_flag
3080: ,p_rec.processing_type
3081: ,p_rec.multiple_entries_allowed_flag);
3082: --
3083: chk_qualifying_factors

Line 3252: chk_standard_link_flag

3248: (p_effective_date
3249: ,p_rec.processing_type
3250: ,p_rec.benefit_classification_id);
3251: --
3252: chk_standard_link_flag
3253: (p_effective_date
3254: ,p_rec.standard_link_flag
3255: ,p_rec.processing_type
3256: ,p_rec.multiple_entries_allowed_flag);

Line 3254: ,p_rec.standard_link_flag

3250: ,p_rec.benefit_classification_id);
3251: --
3252: chk_standard_link_flag
3253: (p_effective_date
3254: ,p_rec.standard_link_flag
3255: ,p_rec.processing_type
3256: ,p_rec.multiple_entries_allowed_flag);
3257: --
3258: chk_qualifying_factors

Line 3312: ,p_rec.standard_link_flag

3308: chk_update_allowed
3309: (p_rec.element_type_id
3310: ,p_rec.indirect_only_flag
3311: ,p_rec.additional_entry_allowed_flag
3312: ,p_rec.standard_link_flag
3313: ,p_rec.adjustment_only_flag
3314: ,p_rec.post_termination_rule
3315: ,p_rec.process_in_run_flag
3316: ,p_validation_start_date