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.PER_CEL_SHD dependencies on HR_UTILITY

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

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

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

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

Line 35: Hr_utility.set_location('Entering:'||l_proc, 5);

31: --
32: l_proc varchar2(72) := g_package||'constraint_error';
33: --
34: Begin
35: Hr_utility.set_location('Entering:'||l_proc, 5);
36: --
37: If (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK1') Then
38: hr_utility.set_message(800, 'HR_52251_CEL_COMP_ID_INVL');
39: hr_utility.set_location(l_proc,10);

Line 38: hr_utility.set_message(800, 'HR_52251_CEL_COMP_ID_INVL');

34: Begin
35: Hr_utility.set_location('Entering:'||l_proc, 5);
36: --
37: If (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK1') Then
38: hr_utility.set_message(800, 'HR_52251_CEL_COMP_ID_INVL');
39: hr_utility.set_location(l_proc,10);
40: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID');
41: hr_utility.raise_error;
42:

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

35: Hr_utility.set_location('Entering:'||l_proc, 5);
36: --
37: If (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK1') Then
38: hr_utility.set_message(800, 'HR_52251_CEL_COMP_ID_INVL');
39: hr_utility.set_location(l_proc,10);
40: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID');
41: hr_utility.raise_error;
42:
43: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK2') Then

Line 41: hr_utility.raise_error;

37: If (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK1') Then
38: hr_utility.set_message(800, 'HR_52251_CEL_COMP_ID_INVL');
39: hr_utility.set_location(l_proc,10);
40: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID');
41: hr_utility.raise_error;
42:
43: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK2') Then
44: hr_utility.set_message(801, 'HR_51612_CEL_BUS_GROUP_ID_INVL');
45: hr_utility.set_location(l_proc,15);

Line 44: hr_utility.set_message(801, 'HR_51612_CEL_BUS_GROUP_ID_INVL');

40: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID');
41: hr_utility.raise_error;
42:
43: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK2') Then
44: hr_utility.set_message(801, 'HR_51612_CEL_BUS_GROUP_ID_INVL');
45: hr_utility.set_location(l_proc,15);
46: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.BUSINESS_GROUP_ID');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK5') Then

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

41: hr_utility.raise_error;
42:
43: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK2') Then
44: hr_utility.set_message(801, 'HR_51612_CEL_BUS_GROUP_ID_INVL');
45: hr_utility.set_location(l_proc,15);
46: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.BUSINESS_GROUP_ID');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK5') Then
49:

Line 47: hr_utility.raise_error;

43: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK2') Then
44: hr_utility.set_message(801, 'HR_51612_CEL_BUS_GROUP_ID_INVL');
45: hr_utility.set_location(l_proc,15);
46: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.BUSINESS_GROUP_ID');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK5') Then
49:
50: hr_utility.set_message(801, 'HR_51615_CEL_PROF_ID_INVL');
51: hr_utility.set_location(l_proc,30);

Line 50: hr_utility.set_message(801, 'HR_51615_CEL_PROF_ID_INVL');

46: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.BUSINESS_GROUP_ID');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK5') Then
49:
50: hr_utility.set_message(801, 'HR_51615_CEL_PROF_ID_INVL');
51: hr_utility.set_location(l_proc,30);
52: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK6') Then

Line 51: hr_utility.set_location(l_proc,30);

47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK5') Then
49:
50: hr_utility.set_message(801, 'HR_51615_CEL_PROF_ID_INVL');
51: hr_utility.set_location(l_proc,30);
52: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK6') Then
55: hr_utility.set_message(801, 'HR_51616_CEL_HG_PROF_ID_INVL');

Line 53: hr_utility.raise_error;

49:
50: hr_utility.set_message(801, 'HR_51615_CEL_PROF_ID_INVL');
51: hr_utility.set_location(l_proc,30);
52: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK6') Then
55: hr_utility.set_message(801, 'HR_51616_CEL_HG_PROF_ID_INVL');
56: hr_utility.set_location(l_proc,35);
57: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID');

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

51: hr_utility.set_location(l_proc,30);
52: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK6') Then
55: hr_utility.set_message(801, 'HR_51616_CEL_HG_PROF_ID_INVL');
56: hr_utility.set_location(l_proc,35);
57: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK7') Then

Line 56: hr_utility.set_location(l_proc,35);

52: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK6') Then
55: hr_utility.set_message(801, 'HR_51616_CEL_HG_PROF_ID_INVL');
56: hr_utility.set_location(l_proc,35);
57: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK7') Then
60: hr_utility.set_message(801, 'HR_51621_CEL_PERSON_ID_INVL');

Line 58: hr_utility.raise_error;

54: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK6') Then
55: hr_utility.set_message(801, 'HR_51616_CEL_HG_PROF_ID_INVL');
56: hr_utility.set_location(l_proc,35);
57: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK7') Then
60: hr_utility.set_message(801, 'HR_51621_CEL_PERSON_ID_INVL');
61: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PERSON_ID');
62: hr_utility.set_location(l_proc,40);

Line 60: hr_utility.set_message(801, 'HR_51621_CEL_PERSON_ID_INVL');

56: hr_utility.set_location(l_proc,35);
57: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK7') Then
60: hr_utility.set_message(801, 'HR_51621_CEL_PERSON_ID_INVL');
61: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PERSON_ID');
62: hr_utility.set_location(l_proc,40);
63: hr_utility.raise_error;
64: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK8') Then

Line 62: hr_utility.set_location(l_proc,40);

58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK7') Then
60: hr_utility.set_message(801, 'HR_51621_CEL_PERSON_ID_INVL');
61: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PERSON_ID');
62: hr_utility.set_location(l_proc,40);
63: hr_utility.raise_error;
64: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK8') Then
65: hr_utility.set_message(801, 'HR_51620_CEL_JOB_ID_INVL');
66: hr_utility.set_location(l_proc,45);

Line 63: hr_utility.raise_error;

59: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK7') Then
60: hr_utility.set_message(801, 'HR_51621_CEL_PERSON_ID_INVL');
61: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PERSON_ID');
62: hr_utility.set_location(l_proc,40);
63: hr_utility.raise_error;
64: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK8') Then
65: hr_utility.set_message(801, 'HR_51620_CEL_JOB_ID_INVL');
66: hr_utility.set_location(l_proc,45);
67: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.JOB_ID');

Line 65: hr_utility.set_message(801, 'HR_51620_CEL_JOB_ID_INVL');

61: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PERSON_ID');
62: hr_utility.set_location(l_proc,40);
63: hr_utility.raise_error;
64: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK8') Then
65: hr_utility.set_message(801, 'HR_51620_CEL_JOB_ID_INVL');
66: hr_utility.set_location(l_proc,45);
67: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.JOB_ID');
68: hr_utility.raise_error;
69: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK9') Then

Line 66: hr_utility.set_location(l_proc,45);

62: hr_utility.set_location(l_proc,40);
63: hr_utility.raise_error;
64: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK8') Then
65: hr_utility.set_message(801, 'HR_51620_CEL_JOB_ID_INVL');
66: hr_utility.set_location(l_proc,45);
67: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.JOB_ID');
68: hr_utility.raise_error;
69: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK9') Then
70: hr_utility.set_message(801, 'HR_51622_CEL_POSITION_ID_INVL');

Line 68: hr_utility.raise_error;

64: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK8') Then
65: hr_utility.set_message(801, 'HR_51620_CEL_JOB_ID_INVL');
66: hr_utility.set_location(l_proc,45);
67: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.JOB_ID');
68: hr_utility.raise_error;
69: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK9') Then
70: hr_utility.set_message(801, 'HR_51622_CEL_POSITION_ID_INVL');
71: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.POSITION_ID');
72: hr_utility.set_location(l_proc,50);

Line 70: hr_utility.set_message(801, 'HR_51622_CEL_POSITION_ID_INVL');

66: hr_utility.set_location(l_proc,45);
67: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.JOB_ID');
68: hr_utility.raise_error;
69: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK9') Then
70: hr_utility.set_message(801, 'HR_51622_CEL_POSITION_ID_INVL');
71: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.POSITION_ID');
72: hr_utility.set_location(l_proc,50);
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK10') Then

Line 72: hr_utility.set_location(l_proc,50);

68: hr_utility.raise_error;
69: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK9') Then
70: hr_utility.set_message(801, 'HR_51622_CEL_POSITION_ID_INVL');
71: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.POSITION_ID');
72: hr_utility.set_location(l_proc,50);
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK10') Then
75: hr_utility.set_message(801, 'HR_51623_CEL_ORG_ID_INVL');
76: hr_utility.set_location(l_proc,55);

Line 73: hr_utility.raise_error;

69: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK9') Then
70: hr_utility.set_message(801, 'HR_51622_CEL_POSITION_ID_INVL');
71: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.POSITION_ID');
72: hr_utility.set_location(l_proc,50);
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK10') Then
75: hr_utility.set_message(801, 'HR_51623_CEL_ORG_ID_INVL');
76: hr_utility.set_location(l_proc,55);
77: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ORGANIZATION_ID');

Line 75: hr_utility.set_message(801, 'HR_51623_CEL_ORG_ID_INVL');

71: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.POSITION_ID');
72: hr_utility.set_location(l_proc,50);
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK10') Then
75: hr_utility.set_message(801, 'HR_51623_CEL_ORG_ID_INVL');
76: hr_utility.set_location(l_proc,55);
77: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ORGANIZATION_ID');
78: hr_utility.raise_error;
79:

Line 76: hr_utility.set_location(l_proc,55);

72: hr_utility.set_location(l_proc,50);
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK10') Then
75: hr_utility.set_message(801, 'HR_51623_CEL_ORG_ID_INVL');
76: hr_utility.set_location(l_proc,55);
77: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ORGANIZATION_ID');
78: hr_utility.raise_error;
79:
80: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK14') Then

Line 78: hr_utility.raise_error;

74: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK10') Then
75: hr_utility.set_message(801, 'HR_51623_CEL_ORG_ID_INVL');
76: hr_utility.set_location(l_proc,55);
77: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ORGANIZATION_ID');
78: hr_utility.raise_error;
79:
80: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK14') Then
81: hr_utility.set_message(801, 'HR_51628_CEL_ASS_ID_INVL');
82: hr_utility.set_location(l_proc,70);

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

77: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ORGANIZATION_ID');
78: hr_utility.raise_error;
79:
80: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK14') Then
81: hr_utility.set_message(801, 'HR_51628_CEL_ASS_ID_INVL');
82: hr_utility.set_location(l_proc,70);
83: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK15') Then

Line 82: hr_utility.set_location(l_proc,70);

78: hr_utility.raise_error;
79:
80: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK14') Then
81: hr_utility.set_message(801, 'HR_51628_CEL_ASS_ID_INVL');
82: hr_utility.set_location(l_proc,70);
83: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK15') Then
86: hr_utility.set_message(801, 'HR_51748_CEL_ASS_TYPE_ID_INVL');

Line 84: hr_utility.raise_error;

80: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK14') Then
81: hr_utility.set_message(801, 'HR_51628_CEL_ASS_ID_INVL');
82: hr_utility.set_location(l_proc,70);
83: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK15') Then
86: hr_utility.set_message(801, 'HR_51748_CEL_ASS_TYPE_ID_INVL');
87: hr_utility.set_location(l_proc,75);
88: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_TYPE_ID');

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

82: hr_utility.set_location(l_proc,70);
83: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK15') Then
86: hr_utility.set_message(801, 'HR_51748_CEL_ASS_TYPE_ID_INVL');
87: hr_utility.set_location(l_proc,75);
88: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_TYPE_ID');
89: hr_utility.raise_error;
90:

Line 87: hr_utility.set_location(l_proc,75);

83: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK15') Then
86: hr_utility.set_message(801, 'HR_51748_CEL_ASS_TYPE_ID_INVL');
87: hr_utility.set_location(l_proc,75);
88: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_TYPE_ID');
89: hr_utility.raise_error;
90:
91: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK16') Then

Line 89: hr_utility.raise_error;

85: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK15') Then
86: hr_utility.set_message(801, 'HR_51748_CEL_ASS_TYPE_ID_INVL');
87: hr_utility.set_location(l_proc,75);
88: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_TYPE_ID');
89: hr_utility.raise_error;
90:
91: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK16') Then
92: hr_utility.set_message(801, 'HR_51631_CEL_RATE_ID_INVL');
93: hr_utility.set_location(l_proc,80);

Line 92: hr_utility.set_message(801, 'HR_51631_CEL_RATE_ID_INVL');

88: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_TYPE_ID');
89: hr_utility.raise_error;
90:
91: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK16') Then
92: hr_utility.set_message(801, 'HR_51631_CEL_RATE_ID_INVL');
93: hr_utility.set_location(l_proc,80);
94: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID');
95: hr_utility.raise_error;
96: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK17') Then

Line 93: hr_utility.set_location(l_proc,80);

89: hr_utility.raise_error;
90:
91: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK16') Then
92: hr_utility.set_message(801, 'HR_51631_CEL_RATE_ID_INVL');
93: hr_utility.set_location(l_proc,80);
94: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID');
95: hr_utility.raise_error;
96: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK17') Then
97: hr_utility.set_message(801, 'HR_51632_CEL_WEG_ID_INVL');

Line 95: hr_utility.raise_error;

91: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK16') Then
92: hr_utility.set_message(801, 'HR_51631_CEL_RATE_ID_INVL');
93: hr_utility.set_location(l_proc,80);
94: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID');
95: hr_utility.raise_error;
96: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK17') Then
97: hr_utility.set_message(801, 'HR_51632_CEL_WEG_ID_INVL');
98: hr_utility.set_location(l_proc,85);
99: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.WEIGHTING_LEVEL_ID');

Line 97: hr_utility.set_message(801, 'HR_51632_CEL_WEG_ID_INVL');

93: hr_utility.set_location(l_proc,80);
94: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID');
95: hr_utility.raise_error;
96: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK17') Then
97: hr_utility.set_message(801, 'HR_51632_CEL_WEG_ID_INVL');
98: hr_utility.set_location(l_proc,85);
99: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.WEIGHTING_LEVEL_ID');
100: hr_utility.raise_error;
101: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK18') Then

Line 98: hr_utility.set_location(l_proc,85);

94: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID');
95: hr_utility.raise_error;
96: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK17') Then
97: hr_utility.set_message(801, 'HR_51632_CEL_WEG_ID_INVL');
98: hr_utility.set_location(l_proc,85);
99: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.WEIGHTING_LEVEL_ID');
100: hr_utility.raise_error;
101: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK18') Then
102: hr_utility.set_message(801, 'HR_51633_CEL_PARENT_ID_INVL');

Line 100: hr_utility.raise_error;

96: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK17') Then
97: hr_utility.set_message(801, 'HR_51632_CEL_WEG_ID_INVL');
98: hr_utility.set_location(l_proc,85);
99: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.WEIGHTING_LEVEL_ID');
100: hr_utility.raise_error;
101: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK18') Then
102: hr_utility.set_message(801, 'HR_51633_CEL_PARENT_ID_INVL');
103: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID');
104: hr_utility.set_location(l_proc,90);

Line 102: hr_utility.set_message(801, 'HR_51633_CEL_PARENT_ID_INVL');

98: hr_utility.set_location(l_proc,85);
99: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.WEIGHTING_LEVEL_ID');
100: hr_utility.raise_error;
101: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK18') Then
102: hr_utility.set_message(801, 'HR_51633_CEL_PARENT_ID_INVL');
103: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID');
104: hr_utility.set_location(l_proc,90);
105: hr_utility.raise_error;
106: Elsif (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK19') Then

Line 104: hr_utility.set_location(l_proc,90);

100: hr_utility.raise_error;
101: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK18') Then
102: hr_utility.set_message(801, 'HR_51633_CEL_PARENT_ID_INVL');
103: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID');
104: hr_utility.set_location(l_proc,90);
105: hr_utility.raise_error;
106: Elsif (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK19') Then
107: hr_utility.set_message(800, 'HR_52341_PER_DATE_INVL');
108: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');

Line 105: hr_utility.raise_error;

101: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK18') Then
102: hr_utility.set_message(801, 'HR_51633_CEL_PARENT_ID_INVL');
103: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID');
104: hr_utility.set_location(l_proc,90);
105: hr_utility.raise_error;
106: Elsif (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK19') Then
107: hr_utility.set_message(800, 'HR_52341_PER_DATE_INVL');
108: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
109: hr_utility.set_location(l_proc,90);

Line 107: hr_utility.set_message(800, 'HR_52341_PER_DATE_INVL');

103: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID');
104: hr_utility.set_location(l_proc,90);
105: hr_utility.raise_error;
106: Elsif (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK19') Then
107: hr_utility.set_message(800, 'HR_52341_PER_DATE_INVL');
108: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
109: hr_utility.set_location(l_proc,90);
110: hr_utility.raise_error;
111: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK20') Then

Line 109: hr_utility.set_location(l_proc,90);

105: hr_utility.raise_error;
106: Elsif (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK19') Then
107: hr_utility.set_message(800, 'HR_52341_PER_DATE_INVL');
108: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
109: hr_utility.set_location(l_proc,90);
110: hr_utility.raise_error;
111: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK20') Then
112: hr_utility.set_message(800, 'HR_52338_COMP_DATE_INVL');
113: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ENTERPRISE_ID');

Line 110: hr_utility.raise_error;

106: Elsif (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK19') Then
107: hr_utility.set_message(800, 'HR_52341_PER_DATE_INVL');
108: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
109: hr_utility.set_location(l_proc,90);
110: hr_utility.raise_error;
111: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK20') Then
112: hr_utility.set_message(800, 'HR_52338_COMP_DATE_INVL');
113: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ENTERPRISE_ID');
114: hr_utility.set_location(l_proc,90);

Line 112: hr_utility.set_message(800, 'HR_52338_COMP_DATE_INVL');

108: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
109: hr_utility.set_location(l_proc,90);
110: hr_utility.raise_error;
111: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK20') Then
112: hr_utility.set_message(800, 'HR_52338_COMP_DATE_INVL');
113: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ENTERPRISE_ID');
114: hr_utility.set_location(l_proc,90);
115: hr_utility.raise_error;
116: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK21') Then

Line 114: hr_utility.set_location(l_proc,90);

110: hr_utility.raise_error;
111: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK20') Then
112: hr_utility.set_message(800, 'HR_52338_COMP_DATE_INVL');
113: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ENTERPRISE_ID');
114: hr_utility.set_location(l_proc,90);
115: hr_utility.raise_error;
116: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK21') Then
117: hr_utility.set_message(800, 'HR_52339_COMP_ELMT_DATE_INVL');
118: hr_multi_message.add(

Line 115: hr_utility.raise_error;

111: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK20') Then
112: hr_utility.set_message(800, 'HR_52338_COMP_DATE_INVL');
113: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ENTERPRISE_ID');
114: hr_utility.set_location(l_proc,90);
115: hr_utility.raise_error;
116: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK21') Then
117: hr_utility.set_message(800, 'HR_52339_COMP_ELMT_DATE_INVL');
118: hr_multi_message.add(
119: p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'

Line 117: hr_utility.set_message(800, 'HR_52339_COMP_ELMT_DATE_INVL');

113: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ENTERPRISE_ID');
114: hr_utility.set_location(l_proc,90);
115: hr_utility.raise_error;
116: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK21') Then
117: hr_utility.set_message(800, 'HR_52339_COMP_ELMT_DATE_INVL');
118: hr_multi_message.add(
119: p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'
120: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_TO'
121: );

Line 122: hr_utility.set_location(l_proc,90);

118: hr_multi_message.add(
119: p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'
120: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_TO'
121: );
122: hr_utility.set_location(l_proc,90);
123: hr_utility.raise_error;
124: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK22') Then
125: hr_utility.set_message(800, 'HR_52342_GRD_DATE_INVL');
126: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');

Line 123: hr_utility.raise_error;

119: p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'
120: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_TO'
121: );
122: hr_utility.set_location(l_proc,90);
123: hr_utility.raise_error;
124: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK22') Then
125: hr_utility.set_message(800, 'HR_52342_GRD_DATE_INVL');
126: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
127: hr_utility.set_location(l_proc,90);

Line 125: hr_utility.set_message(800, 'HR_52342_GRD_DATE_INVL');

121: );
122: hr_utility.set_location(l_proc,90);
123: hr_utility.raise_error;
124: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK22') Then
125: hr_utility.set_message(800, 'HR_52342_GRD_DATE_INVL');
126: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
127: hr_utility.set_location(l_proc,90);
128: hr_utility.raise_error;
129: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_PK') Then

Line 127: hr_utility.set_location(l_proc,90);

123: hr_utility.raise_error;
124: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK22') Then
125: hr_utility.set_message(800, 'HR_52342_GRD_DATE_INVL');
126: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
127: hr_utility.set_location(l_proc,90);
128: hr_utility.raise_error;
129: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_PK') Then
130:
131: hr_utility.set_message(801, 'HR_51634_CEL_PRI_KEY_ID_INVL');

Line 128: hr_utility.raise_error;

124: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK22') Then
125: hr_utility.set_message(800, 'HR_52342_GRD_DATE_INVL');
126: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
127: hr_utility.set_location(l_proc,90);
128: hr_utility.raise_error;
129: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_PK') Then
130:
131: hr_utility.set_message(801, 'HR_51634_CEL_PRI_KEY_ID_INVL');
132: hr_utility.set_location(l_proc,95);

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

127: hr_utility.set_location(l_proc,90);
128: hr_utility.raise_error;
129: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_PK') Then
130:
131: hr_utility.set_message(801, 'HR_51634_CEL_PRI_KEY_ID_INVL');
132: hr_utility.set_location(l_proc,95);
133: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ELEMENT_ID');
134: hr_utility.raise_error;
135: Else

Line 132: hr_utility.set_location(l_proc,95);

128: hr_utility.raise_error;
129: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_PK') Then
130:
131: hr_utility.set_message(801, 'HR_51634_CEL_PRI_KEY_ID_INVL');
132: hr_utility.set_location(l_proc,95);
133: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ELEMENT_ID');
134: hr_utility.raise_error;
135: Else
136: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 134: hr_utility.raise_error;

130:
131: hr_utility.set_message(801, 'HR_51634_CEL_PRI_KEY_ID_INVL');
132: hr_utility.set_location(l_proc,95);
133: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ELEMENT_ID');
134: hr_utility.raise_error;
135: Else
136: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
137: hr_utility.set_message_token('PROCEDURE', l_proc);
138: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

132: hr_utility.set_location(l_proc,95);
133: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ELEMENT_ID');
134: hr_utility.raise_error;
135: Else
136: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
137: hr_utility.set_message_token('PROCEDURE', l_proc);
138: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
139: hr_utility.raise_error;
140: End If;

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

133: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ELEMENT_ID');
134: hr_utility.raise_error;
135: Else
136: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
137: hr_utility.set_message_token('PROCEDURE', l_proc);
138: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
139: hr_utility.raise_error;
140: End If;
141: --

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

134: hr_utility.raise_error;
135: Else
136: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
137: hr_utility.set_message_token('PROCEDURE', l_proc);
138: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
139: hr_utility.raise_error;
140: End If;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 100);

Line 139: hr_utility.raise_error;

135: Else
136: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
137: hr_utility.set_message_token('PROCEDURE', l_proc);
138: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
139: hr_utility.raise_error;
140: End If;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 100);
143: End constraint_error;

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

138: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
139: hr_utility.raise_error;
140: End If;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 100);
143: End constraint_error;
144:
145: --
146:

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

252: l_fct_ret boolean;
253: --
254:
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: If (
259: p_competence_element_id is null and
260: p_object_version_number is null

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

269: If (
270: p_competence_element_id = g_old_rec.competence_element_id and
271: p_object_version_number = g_old_rec.object_version_number
272: ) Then
273: hr_utility.set_location(l_proc, 10);
274: --
275: -- The g_old_rec is current therefore we must
276: -- set the returning function to true
277: --

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

287: Close C_Sel1;
288: --
289: -- The primary key is invalid therefore we must error
290: --
291: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
292: hr_utility.raise_error;
293: End If;
294: Close C_Sel1;
295: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 292: hr_utility.raise_error;

288: --
289: -- The primary key is invalid therefore we must error
290: --
291: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
292: hr_utility.raise_error;
293: End If;
294: Close C_Sel1;
295: If (p_object_version_number <> g_old_rec.object_version_number) Then
296:

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

293: End If;
294: Close C_Sel1;
295: If (p_object_version_number <> g_old_rec.object_version_number) Then
296:
297: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
298: hr_utility.raise_error;
299: End If;
300: hr_utility.set_location(l_proc, 15);
301: l_fct_ret := true;

Line 298: hr_utility.raise_error;

294: Close C_Sel1;
295: If (p_object_version_number <> g_old_rec.object_version_number) Then
296:
297: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
298: hr_utility.raise_error;
299: End If;
300: hr_utility.set_location(l_proc, 15);
301: l_fct_ret := true;
302: End If;

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

296:
297: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
298: hr_utility.raise_error;
299: End If;
300: hr_utility.set_location(l_proc, 15);
301: l_fct_ret := true;
302: End If;
303: End If;
304: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

300: hr_utility.set_location(l_proc, 15);
301: l_fct_ret := true;
302: End If;
303: End If;
304: hr_utility.set_location(' Leaving:'||l_proc, 20);
305: Return (l_fct_ret);
306: --
307: End api_updating;
308: --

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

410: --
411: l_proc varchar2(72) := g_package||'lck';
412: --
413: Begin
414: hr_utility.set_location('Entering:'||l_proc, 5);
415: --
416:
417: -- Add any mandatory argument checking here:
418: -- Example:

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

428: --
429: -- The primary key is invalid therefore we must error
430:
431: --
432: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
433: hr_utility.raise_error;
434: End If;
435: Close C_Sel1;
436: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 433: hr_utility.raise_error;

429: -- The primary key is invalid therefore we must error
430:
431: --
432: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
433: hr_utility.raise_error;
434: End If;
435: Close C_Sel1;
436: If (p_object_version_number <> g_old_rec.object_version_number) Then
437: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

433: hr_utility.raise_error;
434: End If;
435: Close C_Sel1;
436: If (p_object_version_number <> g_old_rec.object_version_number) Then
437: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
438: hr_utility.raise_error;
439: End If;
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 438: hr_utility.raise_error;

434: End If;
435: Close C_Sel1;
436: If (p_object_version_number <> g_old_rec.object_version_number) Then
437: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
438: hr_utility.raise_error;
439: End If;
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 10);
442: --

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

437: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
438: hr_utility.raise_error;
439: End If;
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 10);
442: --
443: -- We need to trap the ORA LOCK exception
444:
445: --

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

448: --
449: -- The object is locked therefore we need to supply a meaningful
450: -- error message.
451: --
452: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
453: hr_utility.set_message_token('TABLE_NAME', 'per_competence_elements');
454: hr_utility.raise_error;
455: End lck;
456: --

Line 453: hr_utility.set_message_token('TABLE_NAME', 'per_competence_elements');

449: -- The object is locked therefore we need to supply a meaningful
450: -- error message.
451: --
452: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
453: hr_utility.set_message_token('TABLE_NAME', 'per_competence_elements');
454: hr_utility.raise_error;
455: End lck;
456: --
457: -- ----------------------------------------------------------------------------

Line 454: hr_utility.raise_error;

450: -- error message.
451: --
452: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
453: hr_utility.set_message_token('TABLE_NAME', 'per_competence_elements');
454: hr_utility.raise_error;
455: End lck;
456: --
457: -- ----------------------------------------------------------------------------
458:

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

552: l_proc varchar2(72) := g_package||'convert_args';
553: --
554: Begin
555: --
556: hr_utility.set_location('Entering:'||l_proc, 5);
557: --
558: -- Convert arguments into local l_rec structure.
559: --
560: l_rec.competence_element_id := p_competence_element_id;

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

644:
645: -- ngundura added object_id and object_name
646: -- Return the plsql record structure.
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 10);
649: Return(l_rec);
650: --
651: End convert_args;
652: --