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_CPT_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_CA_EMP_PROVIN_TAX_RULES_PK') Then
37: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 37: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PAY_CA_EMP_PROVIN_TAX_RULES_PK') Then
37: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else

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

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PAY_CA_EMP_PROVIN_TAX_RULES_PK') Then
37: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');

Line 39: hr_utility.set_message_token('STEP','5');

35: --
36: If (p_constraint_name = 'PAY_CA_EMP_PROVIN_TAX_RULES_PK') Then
37: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 40: hr_utility.raise_error;

36: If (p_constraint_name = 'PAY_CA_EMP_PROVIN_TAX_RULES_PK') Then
37: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

Line 42: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');

38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
45: hr_utility.raise_error;
46: End If;

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

39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
45: hr_utility.raise_error;
46: End If;
47: --

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

40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
45: hr_utility.raise_error;
46: End If;
47: --
48: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 45: hr_utility.raise_error;

41: Else
42: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
45: hr_utility.raise_error;
46: End If;
47: --
48: hr_utility.set_location(' Leaving:'||l_proc, 10);
49: End constraint_error;

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

44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
45: hr_utility.raise_error;
46: End If;
47: --
48: hr_utility.set_location(' Leaving:'||l_proc, 10);
49: End constraint_error;
50: --
51: -- ----------------------------------------------------------------------------
52: -- |-----------------------------< api_updating >-----------------------------|

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

134: l_proc varchar2(72) := g_package||'api_updating';
135: l_fct_ret boolean;
136: --
137: Begin
138: hr_utility.set_location('Entering:'||l_proc, 5);
139: --
140: If (p_effective_date is null or
141: p_emp_province_tax_inf_id is null or
142: p_object_version_number is null) Then

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

147: l_fct_ret := false;
148: Else
149: If (p_emp_province_tax_inf_id = g_old_rec.emp_province_tax_inf_id and
150: p_object_version_number = g_old_rec.object_version_number) Then
151: hr_utility.set_location(l_proc, 10);
152: --
153: -- The g_old_rec is current therefore we must
154: -- set the returning function to true
155: --

Line 168: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');

164: Close C_Sel1;
165: --
166: -- The primary key is invalid therefore we must error
167: --
168: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
169: hr_utility.raise_error;
170: End If;
171: Close C_Sel1;
172: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 169: hr_utility.raise_error;

165: --
166: -- The primary key is invalid therefore we must error
167: --
168: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
169: hr_utility.raise_error;
170: End If;
171: Close C_Sel1;
172: If (p_object_version_number <> g_old_rec.object_version_number) Then
173: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

Line 173: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

169: hr_utility.raise_error;
170: End If;
171: Close C_Sel1;
172: If (p_object_version_number <> g_old_rec.object_version_number) Then
173: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
174: hr_utility.raise_error;
175: End If;
176: hr_utility.set_location(l_proc, 15);
177: l_fct_ret := true;

Line 174: hr_utility.raise_error;

170: End If;
171: Close C_Sel1;
172: If (p_object_version_number <> g_old_rec.object_version_number) Then
173: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
174: hr_utility.raise_error;
175: End If;
176: hr_utility.set_location(l_proc, 15);
177: l_fct_ret := true;
178: End If;

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

172: If (p_object_version_number <> g_old_rec.object_version_number) Then
173: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
174: hr_utility.raise_error;
175: End If;
176: hr_utility.set_location(l_proc, 15);
177: l_fct_ret := true;
178: End If;
179: End If;
180: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

176: hr_utility.set_location(l_proc, 15);
177: l_fct_ret := true;
178: End If;
179: End If;
180: hr_utility.set_location(' Leaving:'||l_proc, 20);
181: Return (l_fct_ret);
182: --
183: End api_updating;
184: --

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

204: and p_effective_date
205: between t.effective_start_date and t.effective_end_date;
206: --
207: Begin
208: hr_utility.set_location('Entering:'||l_proc, 5);
209: Open C_Sel1;
210: Fetch C_Sel1 Into l_parent_key_value1;
211: If C_Sel1%notfound then
212: Close C_Sel1;

Line 213: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

209: Open C_Sel1;
210: Fetch C_Sel1 Into l_parent_key_value1;
211: If C_Sel1%notfound then
212: Close C_Sel1;
213: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
214: hr_utility.set_message_token('PROCEDURE', l_proc);
215: hr_utility.set_message_token('STEP','10');
216: hr_utility.raise_error;
217: End If;

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

210: Fetch C_Sel1 Into l_parent_key_value1;
211: If C_Sel1%notfound then
212: Close C_Sel1;
213: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
214: hr_utility.set_message_token('PROCEDURE', l_proc);
215: hr_utility.set_message_token('STEP','10');
216: hr_utility.raise_error;
217: End If;
218: Close C_Sel1;

Line 215: hr_utility.set_message_token('STEP','10');

211: If C_Sel1%notfound then
212: Close C_Sel1;
213: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
214: hr_utility.set_message_token('PROCEDURE', l_proc);
215: hr_utility.set_message_token('STEP','10');
216: hr_utility.raise_error;
217: End If;
218: Close C_Sel1;
219: --

Line 216: hr_utility.raise_error;

212: Close C_Sel1;
213: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
214: hr_utility.set_message_token('PROCEDURE', l_proc);
215: hr_utility.set_message_token('STEP','10');
216: hr_utility.raise_error;
217: End If;
218: Close C_Sel1;
219: --
220: -- Call the corresponding datetrack api

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

237: p_delete := false;
238: p_future_change := false;
239: p_delete_next_change := false;
240:
241: hr_utility.set_location(' Leaving:'||l_proc, 10);
242: End find_dt_del_modes;
243: --
244: -- ----------------------------------------------------------------------------
245: -- |--------------------------< find_dt_upd_modes >---------------------------|

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

254: --
255: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: -- Call the corresponding datetrack api
261: --
262: dt_api.find_dt_upd_modes

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

268: p_update => p_update,
269: p_update_override => p_update_override,
270: p_update_change_insert => p_update_change_insert);
271: --
272: hr_utility.set_location(' Leaving:'||l_proc, 10);
273: End find_dt_upd_modes;
274: --
275: -- ----------------------------------------------------------------------------
276: -- |------------------------< upd_effective_end_date >------------------------|

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

286: l_proc varchar2(72) := g_package||'upd_effective_end_date';
287: l_object_version_number number;
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: -- Because we are updating a row we must get the next object
293: -- version number.
294: --

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

297: (p_base_table_name => 'pay_ca_emp_prov_tax_info_f',
298: p_base_key_column => 'emp_province_tax_inf_id',
299: p_base_key_value => p_base_key_value);
300: --
301: hr_utility.set_location(l_proc, 10);
302: g_api_dml := true; -- Set the api dml status
303: --
304: -- Update the specified datetrack row setting the effective
305: -- end date to the specified new effective end date.

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

312: between t.effective_start_date and t.effective_end_date;
313: --
314: g_api_dml := false; -- Unset the api dml status
315: p_object_version_number := l_object_version_number;
316: hr_utility.set_location(' Leaving:'||l_proc, 15);
317: --
318: Exception
319: When Others Then
320: g_api_dml := false; -- Unset the api dml status

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

415: --
416: --
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Ensure that all the mandatory arguments are not null
422: --
423: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 452: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');

448: Close C_Sel1;
449: --
450: -- The primary key is invalid therefore we must error
451: --
452: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
453: hr_utility.raise_error;
454: End If;
455: Close C_Sel1;
456: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 453: hr_utility.raise_error;

449: --
450: -- The primary key is invalid therefore we must error
451: --
452: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
453: hr_utility.raise_error;
454: End If;
455: Close C_Sel1;
456: If (p_object_version_number <> g_old_rec.object_version_number) Then
457: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

Line 457: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

453: hr_utility.raise_error;
454: End If;
455: Close C_Sel1;
456: If (p_object_version_number <> g_old_rec.object_version_number) Then
457: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
458: hr_utility.raise_error;
459: End If;
460: hr_utility.set_location(l_proc, 15);
461: --

Line 458: hr_utility.raise_error;

454: End If;
455: Close C_Sel1;
456: If (p_object_version_number <> g_old_rec.object_version_number) Then
457: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
458: hr_utility.raise_error;
459: End If;
460: hr_utility.set_location(l_proc, 15);
461: --
462: --

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

456: If (p_object_version_number <> g_old_rec.object_version_number) Then
457: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
458: hr_utility.raise_error;
459: End If;
460: hr_utility.set_location(l_proc, 15);
461: --
462: --
463: -- Validate the datetrack mode mode getting the validation start
464: -- and end dates for the specified datetrack operation.

Line 484: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

480: -- We are doing a datetrack 'INSERT' which is illegal within this
481: -- procedure therefore we must error (note: to lck on insert the
482: -- private procedure ins_lck should be called).
483: --
484: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE', l_proc);
486: hr_utility.set_message_token('STEP','20');
487: hr_utility.raise_error;
488: End If;

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

481: -- procedure therefore we must error (note: to lck on insert the
482: -- private procedure ins_lck should be called).
483: --
484: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE', l_proc);
486: hr_utility.set_message_token('STEP','20');
487: hr_utility.raise_error;
488: End If;
489: --

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

482: -- private procedure ins_lck should be called).
483: --
484: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE', l_proc);
486: hr_utility.set_message_token('STEP','20');
487: hr_utility.raise_error;
488: End If;
489: --
490: -- Set the validation start and end date OUT arguments

Line 487: hr_utility.raise_error;

483: --
484: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE', l_proc);
486: hr_utility.set_message_token('STEP','20');
487: hr_utility.raise_error;
488: End If;
489: --
490: -- Set the validation start and end date OUT arguments
491: --

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

491: --
492: p_validation_start_date := l_validation_start_date;
493: p_validation_end_date := l_validation_end_date;
494: --
495: hr_utility.set_location(' Leaving:'||l_proc, 30);
496: --
497: -- We need to trap the ORA LOCK exception
498: --
499: Exception

Line 505: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');

501: --
502: -- The object is locked therefore we need to supply a meaningful
503: -- error message.
504: --
505: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
506: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_prov_tax_info_f');
507: hr_utility.raise_error;
508: When l_object_invalid then
509: --

Line 506: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_prov_tax_info_f');

502: -- The object is locked therefore we need to supply a meaningful
503: -- error message.
504: --
505: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
506: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_prov_tax_info_f');
507: hr_utility.raise_error;
508: When l_object_invalid then
509: --
510: -- The object doesn't exist or is invalid

Line 507: hr_utility.raise_error;

503: -- error message.
504: --
505: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
506: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_prov_tax_info_f');
507: hr_utility.raise_error;
508: When l_object_invalid then
509: --
510: -- The object doesn't exist or is invalid
511: --

Line 512: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

508: When l_object_invalid then
509: --
510: -- The object doesn't exist or is invalid
511: --
512: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
513: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_prov_tax_info_f');
514: hr_utility.raise_error;
515: End lck;
516: --

Line 513: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_prov_tax_info_f');

509: --
510: -- The object doesn't exist or is invalid
511: --
512: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
513: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_prov_tax_info_f');
514: hr_utility.raise_error;
515: End lck;
516: --
517: -- ----------------------------------------------------------------------------

Line 514: hr_utility.raise_error;

510: -- The object doesn't exist or is invalid
511: --
512: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
513: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_prov_tax_info_f');
514: hr_utility.raise_error;
515: End lck;
516: --
517: -- ----------------------------------------------------------------------------
518: -- |-----------------------------< convert_args >-----------------------------|

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

590: l_proc varchar2(72) := g_package||'convert_args';
591: --
592: Begin
593: --
594: hr_utility.set_location('Entering:'||l_proc, 5);
595: --
596: -- Convert arguments into local l_rec structure.
597: --
598: l_rec.emp_province_tax_inf_id := p_emp_province_tax_inf_id;

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

661: l_rec.ppip_exempt_flag := p_ppip_exempt_flag;
662: --
663: -- Return the plsql record structure.
664: --
665: hr_utility.set_location(' Leaving:'||l_proc, 10);
666: Return(l_rec);
667: --
668: End convert_args;
669: --