eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_EXA_INS dependencies on HR_API

Line 78: if ( nvl(p_rec.territory_code, hr_api.g_varchar2) <>

74: p_rec.object_version_number);
75: --
76: -- only do U if values have changed
77: --
78: if ( nvl(p_rec.territory_code, hr_api.g_varchar2) <>
79: nvl(pay_exa_shd.g_old_rec.territory_code, hr_api.g_varchar2) )
80: or
81: ( nvl(p_rec.prenote_date, hr_api.g_date) <>
82: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then

Line 79: nvl(pay_exa_shd.g_old_rec.territory_code, hr_api.g_varchar2) )

75: --
76: -- only do U if values have changed
77: --
78: if ( nvl(p_rec.territory_code, hr_api.g_varchar2) <>
79: nvl(pay_exa_shd.g_old_rec.territory_code, hr_api.g_varchar2) )
80: or
81: ( nvl(p_rec.prenote_date, hr_api.g_date) <>
82: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then
83: hr_utility.trace('| doing update on combination table');

Line 81: ( nvl(p_rec.prenote_date, hr_api.g_date) <>

77: --
78: if ( nvl(p_rec.territory_code, hr_api.g_varchar2) <>
79: nvl(pay_exa_shd.g_old_rec.territory_code, hr_api.g_varchar2) )
80: or
81: ( nvl(p_rec.prenote_date, hr_api.g_date) <>
82: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then
83: hr_utility.trace('| doing update on combination table');
84: --
85: -- fresh combination record

Line 82: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then

78: if ( nvl(p_rec.territory_code, hr_api.g_varchar2) <>
79: nvl(pay_exa_shd.g_old_rec.territory_code, hr_api.g_varchar2) )
80: or
81: ( nvl(p_rec.prenote_date, hr_api.g_date) <>
82: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then
83: hr_utility.trace('| doing update on combination table');
84: --
85: -- fresh combination record
86: --

Line 101: if p_rec.prenote_date = hr_api.g_date then

97: ------------------------------------------------------------------------
98: --
99: -- Check for defaulted prenote_date.
100: --
101: if p_rec.prenote_date = hr_api.g_date then
102: hr_utility.trace('| not updating prenote_date (default passed in)');
103: --
104: -- No change to be made: existing combination's date is not updated,
105: -- and fresh combination must have date clear (for prenotification to

Line 109: elsif ( nvl(p_rec.prenote_date, hr_api.g_date) <>

105: -- and fresh combination must have date clear (for prenotification to
106: -- take place).
107: --
108: null;
109: elsif ( nvl(p_rec.prenote_date, hr_api.g_date) <>
110: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then
111: hr_utility.trace('| updating prenote_date');
112: --
113: UPDATE PAY_EXTERNAL_ACCOUNTS

Line 110: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then

106: -- take place).
107: --
108: null;
109: elsif ( nvl(p_rec.prenote_date, hr_api.g_date) <>
110: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then
111: hr_utility.trace('| updating prenote_date');
112: --
113: UPDATE PAY_EXTERNAL_ACCOUNTS
114: SET prenote_date = p_rec.prenote_date

Line 131: When hr_api.check_integrity_violated Then

127: pay_exa_shd.g_api_dml := false; -- unset the api dml status
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
134: pay_exa_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
134: pay_exa_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
139: pay_exa_shd.constraint_error

Line 136: When hr_api.parent_integrity_violated Then

132: -- A check constraint has been violated
133: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
134: pay_exa_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
139: pay_exa_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
139: pay_exa_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
144: pay_exa_shd.constraint_error

Line 141: When hr_api.unique_integrity_violated Then

137: -- Parent integrity has been violated
138: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
139: pay_exa_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
144: pay_exa_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
144: pay_exa_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
148: Raise;
149: end insert_dml;

Line 292: Raise HR_Api.Validate_Enabled;

288: --
289: -- if we are validating then raise the Validate_Enabled exception
290: --
291: If p_validate then
292: Raise HR_Api.Validate_Enabled;
293: End If;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: Exception

Line 297: When HR_Api.Validate_Enabled Then

293: End If;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: Exception
297: When HR_Api.Validate_Enabled Then
298: --
299: -- As the Validate_Enabled exception has been raised
300: -- we must rollback to the savepoint
301: --

Line 490: hr_api.mandatory_arg_error(

486: --
487: -- territory_code code must be specified as its value may be
488: -- placed on a fresh combination record
489: --
490: hr_api.mandatory_arg_error(
491: p_api_name => l_proc,
492: p_argument => 'territory_code',
493: p_argument_value => p_territory_code
494: );