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_UTILITY

Line 61: hr_utility.set_location('Entering:'||l_proc, 5);

57: --
58: l_proc varchar2(72) := g_package||'insert_dml';
59: --
60: begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: pay_exa_shd.g_api_dml := true; -- set the api dml status
64:
65: --

Line 83: hr_utility.trace('| doing update on combination table');

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: --
87: if ( pay_exa_shd.g_old_rec.territory_code is null ) then

Line 88: hr_utility.trace('| updating territory_code');

84: --
85: -- fresh combination record
86: --
87: if ( pay_exa_shd.g_old_rec.territory_code is null ) then
88: hr_utility.trace('| updating territory_code');
89: --
90: UPDATE PAY_EXTERNAL_ACCOUNTS
91: SET territory_code = p_rec.territory_code
92: WHERE external_account_id = p_rec.external_account_id

Line 102: hr_utility.trace('| not updating prenote_date (default passed in)');

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
106: -- take place).

Line 111: hr_utility.trace('| updating prenote_date');

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
115: WHERE external_account_id = p_rec.external_account_id

Line 129: hr_utility.set_location(' Leaving:'||l_proc, 10);

125: end if;
126: --
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

Line 196: hr_utility.set_location('Entering:'||l_proc, 5);

192: --
193: l_proc varchar2(72) := g_package||'pre_insert';
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: End pre_insert;
199: --
200: -- ----------------------------------------------------------------------------

Line 197: hr_utility.set_location(' Leaving:'||l_proc, 10);

193: l_proc varchar2(72) := g_package||'pre_insert';
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: End pre_insert;
199: --
200: -- ----------------------------------------------------------------------------
201: -- |-----------------------------< post_insert >------------------------------|

Line 240: hr_utility.set_location('Entering:'||l_proc, 5);

236: --
237: l_proc varchar2(72) := g_package||'post_insert';
238: --
239: begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: end post_insert;
244: --

Line 242: hr_utility.set_location(' Leaving:'||l_proc, 10);

238: --
239: begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: end post_insert;
244: --
245: -- ----------------------------------------------------------------------------
246: -- |---------------------------------< ins >----------------------------------|

Line 257: hr_utility.set_location('Entering:'||l_proc, 5);

253: --
254: l_proc varchar2(72) := g_package||'ins';
255: --
256: begin
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: -- determine if the business process is to be validated
260: --
261: If p_validate then

Line 295: hr_utility.set_location(' Leaving:'||l_proc, 10);

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
297: When HR_Api.Validate_Enabled Then
298: --
299: -- As the Validate_Enabled exception has been raised

Line 357: hr_utility.set_location('Entering:'||l_proc, 5);

353: WHERE pea.external_account_id = p_external_account_id
354: ;
355: --
356: begin
357: hr_utility.set_location('Entering:'||l_proc, 5);
358: --
359: -- call conversion function to turn arguments into the p_rec structure
360: --
361: l_rec :=

Line 427: hr_utility.set_location(' Leaving:'||l_proc, 10);

423: open csr_ovn(l_rec.external_account_id);
424: fetch csr_ovn into p_object_version_number;
425: close csr_ovn;
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: end ins;
429: --
430: -- ----------------------------------------------------------------------------
431: -- |-------------------------------< ins_or_sel >-----------------------------|

Line 482: hr_utility.set_location('* Entering:' || l_proc || ' *', 5);

478: --
479: l_concat_segments_out varchar2(4600);
480: --
481: begin
482: hr_utility.set_location('***** Entering:' || l_proc || ' *****', 5);
483: --
484: -- stub - do we need to validate prenote_date,
485: -- could be null ?
486: --

Line 600: hr_utility.set_location('* Leaving:' || l_proc || ' *', 100);

596: p_external_account_id := null;
597: p_object_version_number := null;
598: end if;
599: --
600: hr_utility.set_location('***** Leaving:' || l_proc || ' *****', 100);
601: end ins_or_sel;
602: --
603: END pay_exa_ins;