APPS.FF_LOAD_FTYPES_PKG dependencies on HR_UTILITY

Line 71: hr_utility.set_location('Entering:'|| l_proc, 10);

67: where fft.formula_type_name = p_formula_type_name;
68:
69: BEGIN
70:
71: hr_utility.set_location('Entering:'|| l_proc, 10);
72: -- Set the WHO Columns
73: l_created_by := fnd_global.user_id;
74: l_creation_date := l_sysdate;
75: l_last_update_date := l_sysdate;

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

105: end if;
106: --
107: -- do not pass back any out parameters from the API calls
108: --
109: hr_utility.set_location('Leaving:'|| l_proc, 20);
110: end load_row;
111:
112: --
113: -- -------------------------------------------------------------------------------------------

Line 137: hr_utility.set_location('Entering:'|| l_proc, 10);

133: AND fco.context_name = p_context_name;
134:
135: BEGIN
136: --
137: hr_utility.set_location('Entering:'|| l_proc, 10);
138:
139: open csr_existing;
140: fetch csr_existing into l_exist_form_con_id;
141: if csr_existing%NOTFOUND

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

150: end if;
151: --
152: -- do not pass back any out parameters from the API calls
153: --
154: hr_utility.set_location('Leaving:'|| l_proc, 20);
155:
156: end load_row_context_usages;
157:
158: --

Line 175: hr_utility.set_location('Entering:'|| l_proc, 10);

171: l_proc varchar2(100) := g_package || 'insert_formula_types';
172: Begin
173:
174: --
175: hr_utility.set_location('Entering:'|| l_proc, 10);
176: --Insert into ff_formula_types table
177: Insert Into FF_FORMULA_TYPES(
178: FORMULA_TYPE_ID
179: ,FORMULA_TYPE_NAME

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

191: ,p_last_update_login
192: ,p_created_by
193: ,p_creation_date);
194: --
195: hr_utility.set_location('Leaving:'|| l_proc, 20);
196: End insert_formula_types;
197: --
198: -- Called from load row and will update existing rows in ff_formula_types table
199: Procedure update_formula_types(

Line 209: hr_utility.set_location('Entering:'|| l_proc, 10);

205: --
206: l_proc varchar2(100) := g_package || 'update_formula_types';
207:
208: Begin
209: hr_utility.set_location('Entering:'|| l_proc, 10);
210: --
211: Update ff_formula_types
212: set type_description = p_type_description
213: ,last_update_date = p_last_update_date

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

214: ,last_updated_by = p_last_updated_by
215: ,last_update_login = p_last_update_login
216: Where formula_type_name = p_formula_type_name;
217: --
218: hr_utility.set_location('Leaving:'|| l_proc, 20);
219: End update_formula_types;
220: --
221:
222: --

Line 233: hr_utility.set_location('Entering:'|| l_proc, 10);

229:
230: l_formula_type_id FF_FORMULA_TYPES.formula_type_id%TYPE := 0;
231: l_context_id FF_CONTEXTS.context_name%TYPE := 0;
232: Begin
233: hr_utility.set_location('Entering:'|| l_proc, 10);
234: --Check if the formula type id is valid one......
235: l_formula_type_id := chk_formula_type_name(p_formula_type_name => p_formula_type_name);
236:
237: --Check if the context is valid one......

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

244: Values (l_formula_type_id
245: ,l_context_id);
246: End If;
247: --
248: hr_utility.set_location('Leaving:'|| l_proc, 20);
249:
250: End insert_fcontext_usages;
251: --
252:

Line 270: hr_utility.set_location('Entering:'|| l_proc, 10);

266: l_proc varchar2(100) := g_package || 'chk_fomula_type_id';
267: --
268: BEGIN
269: --
270: hr_utility.set_location('Entering:'|| l_proc, 10);
271:
272: OPEN csr_ftype_id;
273: FETCH csr_ftype_id into l_formula_type_id;
274: If csr_ftype_id%notfound Then

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

279: return 0;
280: End if;
281: CLOSE csr_ftype_id;
282:
283: hr_utility.set_location(' Leaving:'|| l_proc, 20);
284: return l_formula_type_id;
285: --
286: End chk_formula_type_name;
287:

Line 305: hr_utility.set_location('Entering:'|| l_proc, 10);

301: l_proc varchar2(100) := g_package || 'chk_context_name';
302: --
303: BEGIN
304: --
305: hr_utility.set_location('Entering:'|| l_proc, 10);
306:
307: OPEN csr_fcon_id;
308: FETCH csr_fcon_id into l_context_id;
309: If csr_fcon_id%notfound Then

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

314: return 0;
315: End if;
316: CLOSE csr_fcon_id;
317:
318: hr_utility.set_location(' Leaving:'|| l_proc, 20);
319: return l_context_id;
320: --
321: End chk_context_name;
322: