DBA Data[Home] [Help]

APPS.PQH_RTL_SHD dependencies on HR_UTILITY

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

16: --
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --

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

19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;

Line 25: hr_utility.raise_error;

21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;
29: --

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

23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;
29: --
30: -- ----------------------------------------------------------------------------
31: -- |-----------------------------< api_updating >-----------------------------|

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

53: l_proc varchar2(72) := g_package||'api_updating';
54: l_fct_ret boolean;
55: --
56: Begin
57: hr_utility.set_location('Entering:'||l_proc, 5);
58: --
59: If (
60: p_rule_set_id is null or
61: p_language is null

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

69: If (
70: p_rule_set_id = g_old_rec.rule_set_id and
71: p_language = g_old_rec.language
72: ) Then
73: hr_utility.set_location(l_proc, 10);
74: --
75: -- The g_old_rec is current therefore we must
76: -- set the returning function to true
77: --

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

86: Close C_Sel1;
87: --
88: -- The primary key is invalid therefore we must error
89: --
90: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
91: hr_utility.raise_error;
92: End If;
93: Close C_Sel1;
94: --

Line 91: hr_utility.raise_error;

87: --
88: -- The primary key is invalid therefore we must error
89: --
90: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
91: hr_utility.raise_error;
92: End If;
93: Close C_Sel1;
94: --
95: hr_utility.set_location(l_proc, 15);

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

91: hr_utility.raise_error;
92: End If;
93: Close C_Sel1;
94: --
95: hr_utility.set_location(l_proc, 15);
96: l_fct_ret := true;
97: End If;
98: End If;
99: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

95: hr_utility.set_location(l_proc, 15);
96: l_fct_ret := true;
97: End If;
98: End If;
99: hr_utility.set_location(' Leaving:'||l_proc, 20);
100: Return (l_fct_ret);
101: --
102: End api_updating;
103: --

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

125: --
126: l_proc varchar2(72) := g_package||'lck';
127: --
128: Begin
129: hr_utility.set_location('Entering:'||l_proc, 5);
130: --
131: -- Add any mandatory argument checking here:
132: -- Example:
133: -- hr_api.mandatory_arg_error

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

141: Close C_Sel1;
142: --
143: -- The primary key is invalid therefore we must error
144: --
145: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
146: hr_utility.raise_error;
147: End If;
148: Close C_Sel1;
149: --

Line 146: hr_utility.raise_error;

142: --
143: -- The primary key is invalid therefore we must error
144: --
145: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
146: hr_utility.raise_error;
147: End If;
148: Close C_Sel1;
149: --
150: --

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

147: End If;
148: Close C_Sel1;
149: --
150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 10);
152: --
153: -- We need to trap the ORA LOCK exception
154: --
155: Exception

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

157: --
158: -- The object is locked therefore we need to supply a meaningful
159: -- error message.
160: --
161: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
162: hr_utility.set_message_token('TABLE_NAME', 'pqh_rule_sets_tl');
163: hr_utility.raise_error;
164: End lck;
165: --

Line 162: hr_utility.set_message_token('TABLE_NAME', 'pqh_rule_sets_tl');

158: -- The object is locked therefore we need to supply a meaningful
159: -- error message.
160: --
161: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
162: hr_utility.set_message_token('TABLE_NAME', 'pqh_rule_sets_tl');
163: hr_utility.raise_error;
164: End lck;
165: --
166: -- ------------------------------------------------------------------------

Line 163: hr_utility.raise_error;

159: -- error message.
160: --
161: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
162: hr_utility.set_message_token('TABLE_NAME', 'pqh_rule_sets_tl');
163: hr_utility.raise_error;
164: End lck;
165: --
166: -- ------------------------------------------------------------------------
167: -- |--------------------------< add_language >----------------------------|

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

269: l_proc varchar2(72) := g_package||'convert_args';
270: --
271: Begin
272: --
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: -- Convert arguments into local l_rec structure.
276: --
277: l_rec.rule_set_id := p_rule_set_id;

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

281: l_rec.source_lang := p_source_lang;
282: --
283: -- Return the plsql record structure.
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 10);
286: Return(l_rec);
287: --
288: End convert_args;
289: --