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_FED_SHD dependencies on HR_UTILITY

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

14: --
15: l_proc varchar2(72) := g_package||'return_api_dml_status';
16: --
17: Begin
18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);
23: End return_api_dml_status;
24: --
25: -- ----------------------------------------------------------------------------
26: -- |---------------------------< constraint_error >---------------------------|

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

30: --
31: l_proc varchar2(72) := g_package||'constraint_error';
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PAY_USFTR_CUMULATIVE_FLAG_CHK') Then
37: hr_utility.set_message(801, 'PAY_72783_FED_CUMUL_Y_OR_N');
38: hr_utility.raise_error;

Line 37: hr_utility.set_message(801, 'PAY_72783_FED_CUMUL_Y_OR_N');

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PAY_USFTR_CUMULATIVE_FLAG_CHK') Then
37: hr_utility.set_message(801, 'PAY_72783_FED_CUMUL_Y_OR_N');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PAY_USFTR_EIC_FILING_STATU_CHK') Then
40: hr_utility.set_message(801,'PAY_72784_FED_EIC_STAT_INVALID');
41: hr_utility.raise_error;

Line 38: hr_utility.raise_error;

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PAY_USFTR_CUMULATIVE_FLAG_CHK') Then
37: hr_utility.set_message(801, 'PAY_72783_FED_CUMUL_Y_OR_N');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PAY_USFTR_EIC_FILING_STATU_CHK') Then
40: hr_utility.set_message(801,'PAY_72784_FED_EIC_STAT_INVALID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PAY_USFTR_FILING_STATUS_CO_CHK') Then

Line 40: hr_utility.set_message(801,'PAY_72784_FED_EIC_STAT_INVALID');

36: If (p_constraint_name = 'PAY_USFTR_CUMULATIVE_FLAG_CHK') Then
37: hr_utility.set_message(801, 'PAY_72783_FED_CUMUL_Y_OR_N');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PAY_USFTR_EIC_FILING_STATU_CHK') Then
40: hr_utility.set_message(801,'PAY_72784_FED_EIC_STAT_INVALID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PAY_USFTR_FILING_STATUS_CO_CHK') Then
43: hr_utility.set_message(801,'PAY_72785_FED_FIL_STAT_INVALID');
44: hr_utility.raise_error;

Line 41: hr_utility.raise_error;

37: hr_utility.set_message(801, 'PAY_72783_FED_CUMUL_Y_OR_N');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PAY_USFTR_EIC_FILING_STATU_CHK') Then
40: hr_utility.set_message(801,'PAY_72784_FED_EIC_STAT_INVALID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PAY_USFTR_FILING_STATUS_CO_CHK') Then
43: hr_utility.set_message(801,'PAY_72785_FED_FIL_STAT_INVALID');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'PAY_USFTR_FIT_EXEMPT_CHK') Then

Line 43: hr_utility.set_message(801,'PAY_72785_FED_FIL_STAT_INVALID');

39: ElsIf (p_constraint_name = 'PAY_USFTR_EIC_FILING_STATU_CHK') Then
40: hr_utility.set_message(801,'PAY_72784_FED_EIC_STAT_INVALID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PAY_USFTR_FILING_STATUS_CO_CHK') Then
43: hr_utility.set_message(801,'PAY_72785_FED_FIL_STAT_INVALID');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'PAY_USFTR_FIT_EXEMPT_CHK') Then
46: hr_utility.set_message(801, 'PAY_72787_FED_FIT_Y_OR_N');
47: hr_utility.raise_error;

Line 44: hr_utility.raise_error;

40: hr_utility.set_message(801,'PAY_72784_FED_EIC_STAT_INVALID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PAY_USFTR_FILING_STATUS_CO_CHK') Then
43: hr_utility.set_message(801,'PAY_72785_FED_FIL_STAT_INVALID');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'PAY_USFTR_FIT_EXEMPT_CHK') Then
46: hr_utility.set_message(801, 'PAY_72787_FED_FIT_Y_OR_N');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PAY_USFTR_FUTA_TAX_EXEMPT_CHK') Then

Line 46: hr_utility.set_message(801, 'PAY_72787_FED_FIT_Y_OR_N');

42: ElsIf (p_constraint_name = 'PAY_USFTR_FILING_STATUS_CO_CHK') Then
43: hr_utility.set_message(801,'PAY_72785_FED_FIL_STAT_INVALID');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'PAY_USFTR_FIT_EXEMPT_CHK') Then
46: hr_utility.set_message(801, 'PAY_72787_FED_FIT_Y_OR_N');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PAY_USFTR_FUTA_TAX_EXEMPT_CHK') Then
49: hr_utility.set_message(801, 'PAY_72788_FED_FUTA_Y_OR_N');
50: hr_utility.raise_error;

Line 47: hr_utility.raise_error;

43: hr_utility.set_message(801,'PAY_72785_FED_FIL_STAT_INVALID');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'PAY_USFTR_FIT_EXEMPT_CHK') Then
46: hr_utility.set_message(801, 'PAY_72787_FED_FIT_Y_OR_N');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PAY_USFTR_FUTA_TAX_EXEMPT_CHK') Then
49: hr_utility.set_message(801, 'PAY_72788_FED_FUTA_Y_OR_N');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_USFTR_MEDICARE_TAX_EXE_CHK') Then

Line 49: hr_utility.set_message(801, 'PAY_72788_FED_FUTA_Y_OR_N');

45: ElsIf (p_constraint_name = 'PAY_USFTR_FIT_EXEMPT_CHK') Then
46: hr_utility.set_message(801, 'PAY_72787_FED_FIT_Y_OR_N');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PAY_USFTR_FUTA_TAX_EXEMPT_CHK') Then
49: hr_utility.set_message(801, 'PAY_72788_FED_FUTA_Y_OR_N');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_USFTR_MEDICARE_TAX_EXE_CHK') Then
52: hr_utility.set_message(801, 'PAY_72789_FED_MED_Y_OR_N');
53: hr_utility.raise_error;

Line 50: hr_utility.raise_error;

46: hr_utility.set_message(801, 'PAY_72787_FED_FIT_Y_OR_N');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PAY_USFTR_FUTA_TAX_EXEMPT_CHK') Then
49: hr_utility.set_message(801, 'PAY_72788_FED_FUTA_Y_OR_N');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_USFTR_MEDICARE_TAX_EXE_CHK') Then
52: hr_utility.set_message(801, 'PAY_72789_FED_MED_Y_OR_N');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PAY_USFTR_SS_TAX_EXEMPT_CHK') Then

Line 52: hr_utility.set_message(801, 'PAY_72789_FED_MED_Y_OR_N');

48: ElsIf (p_constraint_name = 'PAY_USFTR_FUTA_TAX_EXEMPT_CHK') Then
49: hr_utility.set_message(801, 'PAY_72788_FED_FUTA_Y_OR_N');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_USFTR_MEDICARE_TAX_EXE_CHK') Then
52: hr_utility.set_message(801, 'PAY_72789_FED_MED_Y_OR_N');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PAY_USFTR_SS_TAX_EXEMPT_CHK') Then
55: hr_utility.set_message(801, 'PAY_72794_FED_SS_Y_OR_N');
56: hr_utility.raise_error;

Line 53: hr_utility.raise_error;

49: hr_utility.set_message(801, 'PAY_72788_FED_FUTA_Y_OR_N');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_USFTR_MEDICARE_TAX_EXE_CHK') Then
52: hr_utility.set_message(801, 'PAY_72789_FED_MED_Y_OR_N');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PAY_USFTR_SS_TAX_EXEMPT_CHK') Then
55: hr_utility.set_message(801, 'PAY_72794_FED_SS_Y_OR_N');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PAY_USFTR_STATUTORY_EMPLOY_CHK') Then

Line 55: hr_utility.set_message(801, 'PAY_72794_FED_SS_Y_OR_N');

51: ElsIf (p_constraint_name = 'PAY_USFTR_MEDICARE_TAX_EXE_CHK') Then
52: hr_utility.set_message(801, 'PAY_72789_FED_MED_Y_OR_N');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PAY_USFTR_SS_TAX_EXEMPT_CHK') Then
55: hr_utility.set_message(801, 'PAY_72794_FED_SS_Y_OR_N');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PAY_USFTR_STATUTORY_EMPLOY_CHK') Then
58: hr_utility.set_message(801, 'PAY_72795_FED_STAT_EMP_Y_OR_N');
59: hr_utility.raise_error;

Line 56: hr_utility.raise_error;

52: hr_utility.set_message(801, 'PAY_72789_FED_MED_Y_OR_N');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PAY_USFTR_SS_TAX_EXEMPT_CHK') Then
55: hr_utility.set_message(801, 'PAY_72794_FED_SS_Y_OR_N');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PAY_USFTR_STATUTORY_EMPLOY_CHK') Then
58: hr_utility.set_message(801, 'PAY_72795_FED_STAT_EMP_Y_OR_N');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'PAY_US_EMP_FED_TAX_RULES_FK1') Then

Line 58: hr_utility.set_message(801, 'PAY_72795_FED_STAT_EMP_Y_OR_N');

54: ElsIf (p_constraint_name = 'PAY_USFTR_SS_TAX_EXEMPT_CHK') Then
55: hr_utility.set_message(801, 'PAY_72794_FED_SS_Y_OR_N');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PAY_USFTR_STATUTORY_EMPLOY_CHK') Then
58: hr_utility.set_message(801, 'PAY_72795_FED_STAT_EMP_Y_OR_N');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'PAY_US_EMP_FED_TAX_RULES_FK1') Then
61: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
62: hr_utility.raise_error;

Line 59: hr_utility.raise_error;

55: hr_utility.set_message(801, 'PAY_72794_FED_SS_Y_OR_N');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PAY_USFTR_STATUTORY_EMPLOY_CHK') Then
58: hr_utility.set_message(801, 'PAY_72795_FED_STAT_EMP_Y_OR_N');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'PAY_US_EMP_FED_TAX_RULES_FK1') Then
61: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
62: hr_utility.raise_error;
63: Else

Line 61: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');

57: ElsIf (p_constraint_name = 'PAY_USFTR_STATUTORY_EMPLOY_CHK') Then
58: hr_utility.set_message(801, 'PAY_72795_FED_STAT_EMP_Y_OR_N');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'PAY_US_EMP_FED_TAX_RULES_FK1') Then
61: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
62: hr_utility.raise_error;
63: Else
64: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 62: hr_utility.raise_error;

58: hr_utility.set_message(801, 'PAY_72795_FED_STAT_EMP_Y_OR_N');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'PAY_US_EMP_FED_TAX_RULES_FK1') Then
61: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
62: hr_utility.raise_error;
63: Else
64: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token('PROCEDURE', l_proc);
66: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

Line 64: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

60: ElsIf (p_constraint_name = 'PAY_US_EMP_FED_TAX_RULES_FK1') Then
61: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
62: hr_utility.raise_error;
63: Else
64: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token('PROCEDURE', l_proc);
66: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
67: hr_utility.raise_error;
68: End If;

Line 65: hr_utility.set_message_token('PROCEDURE', l_proc);

61: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
62: hr_utility.raise_error;
63: Else
64: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token('PROCEDURE', l_proc);
66: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
67: hr_utility.raise_error;
68: End If;
69: --

Line 66: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

62: hr_utility.raise_error;
63: Else
64: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token('PROCEDURE', l_proc);
66: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
67: hr_utility.raise_error;
68: End If;
69: --
70: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 67: hr_utility.raise_error;

63: Else
64: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token('PROCEDURE', l_proc);
66: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
67: hr_utility.raise_error;
68: End If;
69: --
70: hr_utility.set_location(' Leaving:'||l_proc, 10);
71: End constraint_error;

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

66: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
67: hr_utility.raise_error;
68: End If;
69: --
70: hr_utility.set_location(' Leaving:'||l_proc, 10);
71: End constraint_error;
72: --
73: -- ----------------------------------------------------------------------------
74: -- |-----------------------------< api_updating >-----------------------------|

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

179: l_proc varchar2(72) := g_package||'api_updating';
180: l_fct_ret boolean;
181: --
182: Begin
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: If (p_effective_date is null or
186: p_emp_fed_tax_rule_id is null or
187: p_object_version_number is null) Then

Line 196: hr_utility.set_location(l_proc, 10);

192: l_fct_ret := false;
193: Else
194: If (p_emp_fed_tax_rule_id = g_old_rec.emp_fed_tax_rule_id and
195: p_object_version_number = g_old_rec.object_version_number) Then
196: hr_utility.set_location(l_proc, 10);
197: --
198: -- The g_old_rec is current therefore we must
199: -- set the returning function to true
200: --

Line 213: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

209: Close C_Sel1;
210: --
211: -- The primary key is invalid therefore we must error
212: --
213: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
214: hr_utility.raise_error;
215: End If;
216: Close C_Sel1;
217: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 214: hr_utility.raise_error;

210: --
211: -- The primary key is invalid therefore we must error
212: --
213: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
214: hr_utility.raise_error;
215: End If;
216: Close C_Sel1;
217: If (p_object_version_number <> g_old_rec.object_version_number) Then
218: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 218: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

214: hr_utility.raise_error;
215: End If;
216: Close C_Sel1;
217: If (p_object_version_number <> g_old_rec.object_version_number) Then
218: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
219: hr_utility.raise_error;
220: End If;
221: hr_utility.set_location(l_proc, 15);
222: l_fct_ret := true;

Line 219: hr_utility.raise_error;

215: End If;
216: Close C_Sel1;
217: If (p_object_version_number <> g_old_rec.object_version_number) Then
218: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
219: hr_utility.raise_error;
220: End If;
221: hr_utility.set_location(l_proc, 15);
222: l_fct_ret := true;
223: End If;

Line 221: hr_utility.set_location(l_proc, 15);

217: If (p_object_version_number <> g_old_rec.object_version_number) Then
218: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
219: hr_utility.raise_error;
220: End If;
221: hr_utility.set_location(l_proc, 15);
222: l_fct_ret := true;
223: End If;
224: End If;
225: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 225: hr_utility.set_location(' Leaving:'||l_proc, 20);

221: hr_utility.set_location(l_proc, 15);
222: l_fct_ret := true;
223: End If;
224: End If;
225: hr_utility.set_location(' Leaving:'||l_proc, 20);
226: Return (l_fct_ret);
227: --
228: End api_updating;
229: --

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

241: l_proc varchar2(72) := g_package||'find_dt_del_modes';
242: --
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: -- Call the corresponding datetrack api
248: --
249: dt_api.find_dt_del_modes

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

260: p_future_change := false;
261: p_delete_next_change := false;
262: --
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 10);
265: End find_dt_del_modes;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |--------------------------< find_dt_upd_modes >---------------------------|

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

277: --
278: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: -- Call the corresponding datetrack api
284: --
285: dt_api.find_dt_upd_modes

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

291: p_update => p_update,
292: p_update_override => p_update_override,
293: p_update_change_insert => p_update_change_insert);
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End find_dt_upd_modes;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |------------------------< upd_effective_end_date >------------------------|

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

309: l_proc varchar2(72) := g_package||'upd_effective_end_date';
310: l_object_version_number number;
311: --
312: Begin
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: -- Because we are updating a row we must get the next object
316: -- version number.
317: --

Line 324: hr_utility.set_location(l_proc, 10);

320: (p_base_table_name => 'pay_us_emp_fed_tax_rules_f',
321: p_base_key_column => 'emp_fed_tax_rule_id',
322: p_base_key_value => p_base_key_value);
323: --
324: hr_utility.set_location(l_proc, 10);
325: pay_fed_shd.g_api_dml := true; -- Set the api dml status
326: --
327: -- Update the specified datetrack row setting the effective
328: -- end date to the specified new effective end date.

Line 339: hr_utility.set_location(' Leaving:'||l_proc, 15);

335: between t.effective_start_date and t.effective_end_date;
336: --
337: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
338: p_object_version_number := l_object_version_number;
339: hr_utility.set_location(' Leaving:'||l_proc, 15);
340: --
341: Exception
342: When Others Then
343: pay_fed_shd.g_api_dml := false; -- Unset the api dml status

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

461: --
462: --
463: --
464: Begin
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: -- Ensure that all the mandatory arguments are not null
468: --
469: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 498: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

494: Close C_Sel1;
495: --
496: -- The primary key is invalid therefore we must error
497: --
498: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
499: hr_utility.raise_error;
500: End If;
501: Close C_Sel1;
502: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 499: hr_utility.raise_error;

495: --
496: -- The primary key is invalid therefore we must error
497: --
498: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
499: hr_utility.raise_error;
500: End If;
501: Close C_Sel1;
502: If (p_object_version_number <> g_old_rec.object_version_number) Then
503: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 503: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

499: hr_utility.raise_error;
500: End If;
501: Close C_Sel1;
502: If (p_object_version_number <> g_old_rec.object_version_number) Then
503: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
504: hr_utility.raise_error;
505: End If;
506: hr_utility.set_location(l_proc, 15);
507: --

Line 504: hr_utility.raise_error;

500: End If;
501: Close C_Sel1;
502: If (p_object_version_number <> g_old_rec.object_version_number) Then
503: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
504: hr_utility.raise_error;
505: End If;
506: hr_utility.set_location(l_proc, 15);
507: --
508: --

Line 506: hr_utility.set_location(l_proc, 15);

502: If (p_object_version_number <> g_old_rec.object_version_number) Then
503: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
504: hr_utility.raise_error;
505: End If;
506: hr_utility.set_location(l_proc, 15);
507: --
508: --
509: -- Validate the datetrack mode mode getting the validation start
510: -- and end dates for the specified datetrack operation.

Line 527: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

523: -- We are doing a datetrack 'INSERT' which is illegal within this
524: -- procedure therefore we must error (note: to lck on insert the
525: -- private procedure ins_lck should be called).
526: --
527: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
528: hr_utility.set_message_token('PROCEDURE', l_proc);
529: hr_utility.set_message_token('STEP','20');
530: hr_utility.raise_error;
531: End If;

Line 528: hr_utility.set_message_token('PROCEDURE', l_proc);

524: -- procedure therefore we must error (note: to lck on insert the
525: -- private procedure ins_lck should be called).
526: --
527: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
528: hr_utility.set_message_token('PROCEDURE', l_proc);
529: hr_utility.set_message_token('STEP','20');
530: hr_utility.raise_error;
531: End If;
532: --

Line 529: hr_utility.set_message_token('STEP','20');

525: -- private procedure ins_lck should be called).
526: --
527: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
528: hr_utility.set_message_token('PROCEDURE', l_proc);
529: hr_utility.set_message_token('STEP','20');
530: hr_utility.raise_error;
531: End If;
532: --
533: -- Set the validation start and end date OUT arguments

Line 530: hr_utility.raise_error;

526: --
527: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
528: hr_utility.set_message_token('PROCEDURE', l_proc);
529: hr_utility.set_message_token('STEP','20');
530: hr_utility.raise_error;
531: End If;
532: --
533: -- Set the validation start and end date OUT arguments
534: --

Line 538: hr_utility.set_location(' Leaving:'||l_proc, 30);

534: --
535: p_validation_start_date := l_validation_start_date;
536: p_validation_end_date := l_validation_end_date;
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 30);
539: --
540: -- We need to trap the ORA LOCK exception
541: --
542: Exception

Line 548: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

544: --
545: -- The object is locked therefore we need to supply a meaningful
546: -- error message.
547: --
548: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
549: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');
550: hr_utility.raise_error;
551: When l_object_invalid then
552: --

Line 549: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');

545: -- The object is locked therefore we need to supply a meaningful
546: -- error message.
547: --
548: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
549: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');
550: hr_utility.raise_error;
551: When l_object_invalid then
552: --
553: -- The object doesn't exist or is invalid

Line 550: hr_utility.raise_error;

546: -- error message.
547: --
548: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
549: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');
550: hr_utility.raise_error;
551: When l_object_invalid then
552: --
553: -- The object doesn't exist or is invalid
554: --

Line 555: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

551: When l_object_invalid then
552: --
553: -- The object doesn't exist or is invalid
554: --
555: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
556: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');
557: hr_utility.raise_error;
558: End lck;
559: --

Line 556: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');

552: --
553: -- The object doesn't exist or is invalid
554: --
555: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
556: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');
557: hr_utility.raise_error;
558: End lck;
559: --
560: -- ----------------------------------------------------------------------------

Line 557: hr_utility.raise_error;

553: -- The object doesn't exist or is invalid
554: --
555: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
556: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');
557: hr_utility.raise_error;
558: End lck;
559: --
560: -- ----------------------------------------------------------------------------
561: -- |-----------------------------< convert_args >-----------------------------|

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

656: l_proc varchar2(72) := g_package||'convert_args';
657: --
658: Begin
659: --
660: hr_utility.set_location('Entering:'||l_proc, 5);
661: --
662: -- Convert arguments into local l_rec structure.
663: --
664: l_rec.emp_fed_tax_rule_id := p_emp_fed_tax_rule_id;

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

751:
752: --
753: -- Return the plsql record structure.
754: --
755: hr_utility.set_location(' Leaving:'||l_proc, 10);
756: Return(l_rec);
757: End convert_args;
758: --
759: end pay_fed_shd;