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.BEN_EPE_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 36: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

32: --
33: Begin
34: --
35: If (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT1') Then
36: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('STEP','10');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT2') Then

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

33: Begin
34: --
35: If (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT1') Then
36: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('STEP','10');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT2') Then
41: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

34: --
35: If (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT1') Then
36: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('STEP','10');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT2') Then
41: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 39: hr_utility.raise_error;

35: If (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT1') Then
36: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('STEP','10');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT2') Then
41: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: hr_utility.set_message_token('PROCEDURE', l_proc);
43: hr_utility.set_message_token('STEP','');

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

37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('STEP','10');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT2') Then
41: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: hr_utility.set_message_token('PROCEDURE', l_proc);
43: hr_utility.set_message_token('STEP','');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT3') Then

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

38: hr_utility.set_message_token('STEP','10');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT2') Then
41: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: hr_utility.set_message_token('PROCEDURE', l_proc);
43: hr_utility.set_message_token('STEP','');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT3') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 43: hr_utility.set_message_token('STEP','');

39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT2') Then
41: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: hr_utility.set_message_token('PROCEDURE', l_proc);
43: hr_utility.set_message_token('STEP','');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT3') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 44: hr_utility.raise_error;

40: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT2') Then
41: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: hr_utility.set_message_token('PROCEDURE', l_proc);
43: hr_utility.set_message_token('STEP','');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT3') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('STEP','');

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

42: hr_utility.set_message_token('PROCEDURE', l_proc);
43: hr_utility.set_message_token('STEP','');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT3') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('STEP','');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT4') Then

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

43: hr_utility.set_message_token('STEP','');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT3') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('STEP','');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT4') Then
51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 48: hr_utility.set_message_token('STEP','');

44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT3') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('STEP','');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT4') Then
51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 49: hr_utility.raise_error;

45: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT3') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('STEP','');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT4') Then
51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE', l_proc);
53: hr_utility.set_message_token('STEP','');

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

47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('STEP','');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT4') Then
51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE', l_proc);
53: hr_utility.set_message_token('STEP','');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT5') Then

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

48: hr_utility.set_message_token('STEP','');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT4') Then
51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE', l_proc);
53: hr_utility.set_message_token('STEP','');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT5') Then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 53: hr_utility.set_message_token('STEP','');

49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT4') Then
51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE', l_proc);
53: hr_utility.set_message_token('STEP','');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT5') Then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 54: hr_utility.raise_error;

50: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT4') Then
51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE', l_proc);
53: hr_utility.set_message_token('STEP','');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT5') Then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','');

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

52: hr_utility.set_message_token('PROCEDURE', l_proc);
53: hr_utility.set_message_token('STEP','');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT5') Then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT6') Then

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

53: hr_utility.set_message_token('STEP','');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT5') Then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT6') Then
61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 58: hr_utility.set_message_token('STEP','');

54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT5') Then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT6') Then
61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
62: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 59: hr_utility.raise_error;

55: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT5') Then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT6') Then
61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP','');

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

57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT6') Then
61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP','');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT7') Then

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

58: hr_utility.set_message_token('STEP','');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT6') Then
61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP','');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT7') Then
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 63: hr_utility.set_message_token('STEP','');

59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT6') Then
61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP','');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT7') Then
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 64: hr_utility.raise_error;

60: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT6') Then
61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP','');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT7') Then
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP','');

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

62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP','');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT7') Then
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP','');
69: hr_utility.raise_error;
70: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT8') Then

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

63: hr_utility.set_message_token('STEP','');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT7') Then
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP','');
69: hr_utility.raise_error;
70: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT8') Then
71: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 68: hr_utility.set_message_token('STEP','');

64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT7') Then
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP','');
69: hr_utility.raise_error;
70: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT8') Then
71: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 69: hr_utility.raise_error;

65: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT7') Then
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP','');
69: hr_utility.raise_error;
70: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT8') Then
71: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE', l_proc);
73: hr_utility.set_message_token('STEP','');

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

67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP','');
69: hr_utility.raise_error;
70: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT8') Then
71: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE', l_proc);
73: hr_utility.set_message_token('STEP','');
74: hr_utility.raise_error;
75: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT9') Then

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

68: hr_utility.set_message_token('STEP','');
69: hr_utility.raise_error;
70: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT8') Then
71: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE', l_proc);
73: hr_utility.set_message_token('STEP','');
74: hr_utility.raise_error;
75: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT9') Then
76: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 73: hr_utility.set_message_token('STEP','');

69: hr_utility.raise_error;
70: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT8') Then
71: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE', l_proc);
73: hr_utility.set_message_token('STEP','');
74: hr_utility.raise_error;
75: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT9') Then
76: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
77: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 74: hr_utility.raise_error;

70: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT8') Then
71: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE', l_proc);
73: hr_utility.set_message_token('STEP','');
74: hr_utility.raise_error;
75: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT9') Then
76: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
77: hr_utility.set_message_token('PROCEDURE', l_proc);
78: hr_utility.set_message_token('STEP','');

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

72: hr_utility.set_message_token('PROCEDURE', l_proc);
73: hr_utility.set_message_token('STEP','');
74: hr_utility.raise_error;
75: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT9') Then
76: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
77: hr_utility.set_message_token('PROCEDURE', l_proc);
78: hr_utility.set_message_token('STEP','');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT10') Then

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

73: hr_utility.set_message_token('STEP','');
74: hr_utility.raise_error;
75: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT9') Then
76: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
77: hr_utility.set_message_token('PROCEDURE', l_proc);
78: hr_utility.set_message_token('STEP','');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT10') Then
81: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 78: hr_utility.set_message_token('STEP','');

74: hr_utility.raise_error;
75: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT9') Then
76: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
77: hr_utility.set_message_token('PROCEDURE', l_proc);
78: hr_utility.set_message_token('STEP','');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT10') Then
81: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
82: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 79: hr_utility.raise_error;

75: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT9') Then
76: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
77: hr_utility.set_message_token('PROCEDURE', l_proc);
78: hr_utility.set_message_token('STEP','');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT10') Then
81: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
82: hr_utility.set_message_token('PROCEDURE', l_proc);
83: hr_utility.set_message_token('STEP','');

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

77: hr_utility.set_message_token('PROCEDURE', l_proc);
78: hr_utility.set_message_token('STEP','');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT10') Then
81: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
82: hr_utility.set_message_token('PROCEDURE', l_proc);
83: hr_utility.set_message_token('STEP','');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT11') Then

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

78: hr_utility.set_message_token('STEP','');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT10') Then
81: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
82: hr_utility.set_message_token('PROCEDURE', l_proc);
83: hr_utility.set_message_token('STEP','');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT11') Then
86: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 83: hr_utility.set_message_token('STEP','');

79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT10') Then
81: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
82: hr_utility.set_message_token('PROCEDURE', l_proc);
83: hr_utility.set_message_token('STEP','');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT11') Then
86: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
87: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 84: hr_utility.raise_error;

80: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT10') Then
81: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
82: hr_utility.set_message_token('PROCEDURE', l_proc);
83: hr_utility.set_message_token('STEP','');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT11') Then
86: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
87: hr_utility.set_message_token('PROCEDURE', l_proc);
88: hr_utility.set_message_token('STEP','');

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

82: hr_utility.set_message_token('PROCEDURE', l_proc);
83: hr_utility.set_message_token('STEP','');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT11') Then
86: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
87: hr_utility.set_message_token('PROCEDURE', l_proc);
88: hr_utility.set_message_token('STEP','');
89: hr_utility.raise_error;
90: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT12') Then

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

83: hr_utility.set_message_token('STEP','');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT11') Then
86: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
87: hr_utility.set_message_token('PROCEDURE', l_proc);
88: hr_utility.set_message_token('STEP','');
89: hr_utility.raise_error;
90: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT12') Then
91: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 88: hr_utility.set_message_token('STEP','');

84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT11') Then
86: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
87: hr_utility.set_message_token('PROCEDURE', l_proc);
88: hr_utility.set_message_token('STEP','');
89: hr_utility.raise_error;
90: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT12') Then
91: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
92: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 89: hr_utility.raise_error;

85: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT11') Then
86: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
87: hr_utility.set_message_token('PROCEDURE', l_proc);
88: hr_utility.set_message_token('STEP','');
89: hr_utility.raise_error;
90: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT12') Then
91: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
92: hr_utility.set_message_token('PROCEDURE', l_proc);
93: hr_utility.set_message_token('STEP','');

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

87: hr_utility.set_message_token('PROCEDURE', l_proc);
88: hr_utility.set_message_token('STEP','');
89: hr_utility.raise_error;
90: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT12') Then
91: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
92: hr_utility.set_message_token('PROCEDURE', l_proc);
93: hr_utility.set_message_token('STEP','');
94: hr_utility.raise_error;
95: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT13') Then

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

88: hr_utility.set_message_token('STEP','');
89: hr_utility.raise_error;
90: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT12') Then
91: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
92: hr_utility.set_message_token('PROCEDURE', l_proc);
93: hr_utility.set_message_token('STEP','');
94: hr_utility.raise_error;
95: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT13') Then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 93: hr_utility.set_message_token('STEP','');

89: hr_utility.raise_error;
90: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT12') Then
91: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
92: hr_utility.set_message_token('PROCEDURE', l_proc);
93: hr_utility.set_message_token('STEP','');
94: hr_utility.raise_error;
95: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT13') Then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 94: hr_utility.raise_error;

90: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT12') Then
91: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
92: hr_utility.set_message_token('PROCEDURE', l_proc);
93: hr_utility.set_message_token('STEP','');
94: hr_utility.raise_error;
95: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT13') Then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE', l_proc);
98: hr_utility.set_message_token('STEP','');

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

92: hr_utility.set_message_token('PROCEDURE', l_proc);
93: hr_utility.set_message_token('STEP','');
94: hr_utility.raise_error;
95: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT13') Then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE', l_proc);
98: hr_utility.set_message_token('STEP','');
99: hr_utility.raise_error;
100: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT14') Then

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

93: hr_utility.set_message_token('STEP','');
94: hr_utility.raise_error;
95: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT13') Then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE', l_proc);
98: hr_utility.set_message_token('STEP','');
99: hr_utility.raise_error;
100: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT14') Then
101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 98: hr_utility.set_message_token('STEP','');

94: hr_utility.raise_error;
95: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT13') Then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE', l_proc);
98: hr_utility.set_message_token('STEP','');
99: hr_utility.raise_error;
100: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT14') Then
101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
102: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 99: hr_utility.raise_error;

95: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT13') Then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE', l_proc);
98: hr_utility.set_message_token('STEP','');
99: hr_utility.raise_error;
100: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT14') Then
101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
102: hr_utility.set_message_token('PROCEDURE', l_proc);
103: hr_utility.set_message_token('STEP','');

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

97: hr_utility.set_message_token('PROCEDURE', l_proc);
98: hr_utility.set_message_token('STEP','');
99: hr_utility.raise_error;
100: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT14') Then
101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
102: hr_utility.set_message_token('PROCEDURE', l_proc);
103: hr_utility.set_message_token('STEP','');
104: hr_utility.raise_error;
105: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT15') Then

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

98: hr_utility.set_message_token('STEP','');
99: hr_utility.raise_error;
100: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT14') Then
101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
102: hr_utility.set_message_token('PROCEDURE', l_proc);
103: hr_utility.set_message_token('STEP','');
104: hr_utility.raise_error;
105: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT15') Then
106: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 103: hr_utility.set_message_token('STEP','');

99: hr_utility.raise_error;
100: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT14') Then
101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
102: hr_utility.set_message_token('PROCEDURE', l_proc);
103: hr_utility.set_message_token('STEP','');
104: hr_utility.raise_error;
105: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT15') Then
106: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
107: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 104: hr_utility.raise_error;

100: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT14') Then
101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
102: hr_utility.set_message_token('PROCEDURE', l_proc);
103: hr_utility.set_message_token('STEP','');
104: hr_utility.raise_error;
105: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT15') Then
106: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
107: hr_utility.set_message_token('PROCEDURE', l_proc);
108: hr_utility.set_message_token('STEP','');

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

102: hr_utility.set_message_token('PROCEDURE', l_proc);
103: hr_utility.set_message_token('STEP','');
104: hr_utility.raise_error;
105: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT15') Then
106: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
107: hr_utility.set_message_token('PROCEDURE', l_proc);
108: hr_utility.set_message_token('STEP','');
109: hr_utility.raise_error;
110: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT16') Then

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

103: hr_utility.set_message_token('STEP','');
104: hr_utility.raise_error;
105: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT15') Then
106: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
107: hr_utility.set_message_token('PROCEDURE', l_proc);
108: hr_utility.set_message_token('STEP','');
109: hr_utility.raise_error;
110: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT16') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 108: hr_utility.set_message_token('STEP','');

104: hr_utility.raise_error;
105: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT15') Then
106: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
107: hr_utility.set_message_token('PROCEDURE', l_proc);
108: hr_utility.set_message_token('STEP','');
109: hr_utility.raise_error;
110: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT16') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 109: hr_utility.raise_error;

105: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT15') Then
106: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
107: hr_utility.set_message_token('PROCEDURE', l_proc);
108: hr_utility.set_message_token('STEP','');
109: hr_utility.raise_error;
110: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT16') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','');

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

107: hr_utility.set_message_token('PROCEDURE', l_proc);
108: hr_utility.set_message_token('STEP','');
109: hr_utility.raise_error;
110: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT16') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK15') Then

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

108: hr_utility.set_message_token('STEP','');
109: hr_utility.raise_error;
110: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT16') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK15') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 113: hr_utility.set_message_token('STEP','');

109: hr_utility.raise_error;
110: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT16') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK15') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 114: hr_utility.raise_error;

110: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT16') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK15') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','');

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

112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK15') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','');
119: hr_utility.raise_error;
120: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK18') Then

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

113: hr_utility.set_message_token('STEP','');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK15') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','');
119: hr_utility.raise_error;
120: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK18') Then
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 118: hr_utility.set_message_token('STEP','');

114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK15') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','');
119: hr_utility.raise_error;
120: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK18') Then
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 119: hr_utility.raise_error;

115: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK15') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','');
119: hr_utility.raise_error;
120: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK18') Then
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','');

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

117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','');
119: hr_utility.raise_error;
120: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK18') Then
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','');
124: hr_utility.raise_error;
125: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_PK') Then

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

118: hr_utility.set_message_token('STEP','');
119: hr_utility.raise_error;
120: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK18') Then
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','');
124: hr_utility.raise_error;
125: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_PK') Then
126: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 123: hr_utility.set_message_token('STEP','');

119: hr_utility.raise_error;
120: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK18') Then
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','');
124: hr_utility.raise_error;
125: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_PK') Then
126: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
127: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 124: hr_utility.raise_error;

120: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK18') Then
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','');
124: hr_utility.raise_error;
125: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_PK') Then
126: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
127: hr_utility.set_message_token('PROCEDURE', l_proc);
128: hr_utility.set_message_token('STEP','5');

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

122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','');
124: hr_utility.raise_error;
125: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_PK') Then
126: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
127: hr_utility.set_message_token('PROCEDURE', l_proc);
128: hr_utility.set_message_token('STEP','5');
129: hr_utility.raise_error;
130: Else

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

123: hr_utility.set_message_token('STEP','');
124: hr_utility.raise_error;
125: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_PK') Then
126: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
127: hr_utility.set_message_token('PROCEDURE', l_proc);
128: hr_utility.set_message_token('STEP','5');
129: hr_utility.raise_error;
130: Else
131: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

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

124: hr_utility.raise_error;
125: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_PK') Then
126: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
127: hr_utility.set_message_token('PROCEDURE', l_proc);
128: hr_utility.set_message_token('STEP','5');
129: hr_utility.raise_error;
130: Else
131: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
132: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 129: hr_utility.raise_error;

125: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_PK') Then
126: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
127: hr_utility.set_message_token('PROCEDURE', l_proc);
128: hr_utility.set_message_token('STEP','5');
129: hr_utility.raise_error;
130: Else
131: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
132: hr_utility.set_message_token('PROCEDURE', l_proc);
133: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

127: hr_utility.set_message_token('PROCEDURE', l_proc);
128: hr_utility.set_message_token('STEP','5');
129: hr_utility.raise_error;
130: Else
131: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
132: hr_utility.set_message_token('PROCEDURE', l_proc);
133: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
134: hr_utility.raise_error;
135: End If;

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

128: hr_utility.set_message_token('STEP','5');
129: hr_utility.raise_error;
130: Else
131: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
132: hr_utility.set_message_token('PROCEDURE', l_proc);
133: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
134: hr_utility.raise_error;
135: End If;
136: --

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

129: hr_utility.raise_error;
130: Else
131: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
132: hr_utility.set_message_token('PROCEDURE', l_proc);
133: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
134: hr_utility.raise_error;
135: End If;
136: --
137: End constraint_error;

Line 134: hr_utility.raise_error;

130: Else
131: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
132: hr_utility.set_message_token('PROCEDURE', l_proc);
133: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
134: hr_utility.raise_error;
135: End If;
136: --
137: End constraint_error;
138: --

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

258: l_fct_ret boolean;
259: --
260: Begin
261: /*
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: */
264: --
265: If (
266: p_elig_per_elctbl_chc_id is null and

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

276: p_elig_per_elctbl_chc_id = g_old_rec.elig_per_elctbl_chc_id and
277: p_object_version_number = g_old_rec.object_version_number
278: ) Then
279: /*
280: hr_utility.set_location(l_proc, 10);
281: */
282: --
283: -- The g_old_rec is current therefore we must
284: -- set the returning function to true

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

294: Close C_Sel1;
295: --
296: -- The primary key is invalid therefore we must error
297: --
298: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
299: hr_utility.raise_error;
300: End If;
301: Close C_Sel1;
302: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 299: hr_utility.raise_error;

295: --
296: -- The primary key is invalid therefore we must error
297: --
298: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
299: hr_utility.raise_error;
300: End If;
301: Close C_Sel1;
302: If (p_object_version_number <> g_old_rec.object_version_number) Then
303: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

299: hr_utility.raise_error;
300: End If;
301: Close C_Sel1;
302: If (p_object_version_number <> g_old_rec.object_version_number) Then
303: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
304: hr_utility.raise_error;
305: End If;
306: /*
307: hr_utility.set_location(l_proc, 15);

Line 304: hr_utility.raise_error;

300: End If;
301: Close C_Sel1;
302: If (p_object_version_number <> g_old_rec.object_version_number) Then
303: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
304: hr_utility.raise_error;
305: End If;
306: /*
307: hr_utility.set_location(l_proc, 15);
308: */

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

303: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
304: hr_utility.raise_error;
305: End If;
306: /*
307: hr_utility.set_location(l_proc, 15);
308: */
309: l_fct_ret := true;
310: End If;
311: End If;

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

309: l_fct_ret := true;
310: End If;
311: End If;
312: /*
313: hr_utility.set_location(' Leaving:'||l_proc, 20);
314: */
315: Return (l_fct_ret);
316: --
317: End api_updating;

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

435: --
436: l_proc varchar2(72) := g_package||'lck';
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);
440: --
441: -- Add any mandatory argument checking here:
442: -- Example:
443: -- hr_api.mandatory_arg_error

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

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

Line 456: hr_utility.raise_error;

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

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

456: hr_utility.raise_error;
457: End If;
458: Close C_Sel1;
459: If (p_object_version_number <> g_old_rec.object_version_number) Then
460: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
461: hr_utility.raise_error;
462: End If;
463: --
464: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 461: hr_utility.raise_error;

457: End If;
458: Close C_Sel1;
459: If (p_object_version_number <> g_old_rec.object_version_number) Then
460: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
461: hr_utility.raise_error;
462: End If;
463: --
464: hr_utility.set_location(' Leaving:'||l_proc, 10);
465: --

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

460: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
461: hr_utility.raise_error;
462: End If;
463: --
464: hr_utility.set_location(' Leaving:'||l_proc, 10);
465: --
466: -- We need to trap the ORA LOCK exception
467: --
468: Exception

Line 474: hr_utility.set_message(805, 'BEN_93618_EPE_OBJECT_LOCKED'); -- Bug 3140549

470: --
471: -- The object is locked therefore we need to supply a meaningful
472: -- error message.
473: --
474: hr_utility.set_message(805, 'BEN_93618_EPE_OBJECT_LOCKED'); -- Bug 3140549
475: --hr_utility.set_message_token('TABLE_NAME', 'ben_elig_per_elctbl_chc');
476: hr_utility.raise_error;
477: End lck;
478: --

Line 475: --hr_utility.set_message_token('TABLE_NAME', 'ben_elig_per_elctbl_chc');

471: -- The object is locked therefore we need to supply a meaningful
472: -- error message.
473: --
474: hr_utility.set_message(805, 'BEN_93618_EPE_OBJECT_LOCKED'); -- Bug 3140549
475: --hr_utility.set_message_token('TABLE_NAME', 'ben_elig_per_elctbl_chc');
476: hr_utility.raise_error;
477: End lck;
478: --
479: -- ----------------------------------------------------------------------------

Line 476: hr_utility.raise_error;

472: -- error message.
473: --
474: hr_utility.set_message(805, 'BEN_93618_EPE_OBJECT_LOCKED'); -- Bug 3140549
475: --hr_utility.set_message_token('TABLE_NAME', 'ben_elig_per_elctbl_chc');
476: hr_utility.raise_error;
477: End lck;
478: --
479: -- ----------------------------------------------------------------------------
480: -- |-----------------------------< convert_args >-----------------------------|

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

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

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

697: l_rec.object_version_number := p_object_version_number;
698: --
699: -- Return the plsql record structure.
700: --
701: hr_utility.set_location(' Leaving:'||l_proc, 10);
702: Return(l_rec);
703: --
704: End convert_args;
705: --