DBA Data[Home] [Help]

APPS.BEN_COPY_EXTRACT dependencies on HR_UTILITY

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

44: -- ----------------------------------------------------------------------------
45: PROCEDURE add_formula_id(p_formula_id IN NUMBER) IS
46: l_proc VARCHAR2(72) := g_package||'add_formula_id';
47: BEGIN
48: hr_utility.set_location('Entering:'|| l_proc, 10);
49: IF t_Formulas IS NULL THEN
50: t_Formulas(1) := p_formula_id;
51: ELSE
52: t_Formulas(t_Formulas.COUNT+1) := p_formula_id;

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

50: t_Formulas(1) := p_formula_id;
51: ELSE
52: t_Formulas(t_Formulas.COUNT+1) := p_formula_id;
53: END IF;
54: hr_utility.set_location('Leaving:'|| l_proc, 20);
55: END; -- add_formula_id
56:
57: -- ----------------------------------------------------------------------------
58: -- |------------------------< ADD_DinR_ID >-------------------------------|

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

63: l_proc VARCHAR2(72) := g_package||'add_DinR_id';
64: r_DinR IdTyp;
65:
66: BEGIN
67: hr_utility.set_location('Entering:'|| l_proc, 10);
68:
69: -- Assign values into record variable
70: r_DinR.curr_Id := p_curr_DinR_id;
71: r_DinR.new_Id := p_new_DinR_id;

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

76: t_DinRId.EXTEND;
77: t_DinRId(t_DinRId.COUNT) := r_DinR;
78: END IF;
79:
80: hr_utility.set_location('Leaving:'|| l_proc, 20);
81: END; -- add_DinR_id
82:
83: -- ----------------------------------------------------------------------------
84: -- |------------------------< add_RinF_Id >----------------------------------|

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

89: l_proc VARCHAR2(72) := g_package||'add_RinF_Id';
90: r_RinF IdTyp;
91:
92: BEGIN
93: hr_utility.set_location('Entering:'|| l_proc, 10);
94:
95: -- Assign values into record variable
96: r_RinF.curr_Id := p_curr_RinF_id;
97: r_RinF.new_Id := p_new_RinF_id;

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

102: t_RinFId.EXTEND;
103: t_RinFId(t_RinFId.COUNT) := r_RinF;
104: END IF;
105:
106: hr_utility.set_location('Leaving:'|| l_proc, 20);
107: END; -- add_DinR_id
108:
109: -- ----------------------------------------------------------------------------
110: -- |------------------------< GET_NEW_DATA_ELMT_ID >--------------------------|

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

138: l_msg_app VARCHAR2(50);
139: l_proc VARCHAR2(72) := g_package||'get_msg_name';
140:
141: BEGIN
142: hr_utility.set_location('Entering:'|| l_proc, 10);
143:
144: l_encoded_msg := fnd_message.get_encoded();
145: fnd_message.parse_encoded(
146: encoded_message => l_encoded_msg

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

149: );
150:
151: g_msg_app := l_msg_app ; -- bug 2459050
152:
153: hr_utility.set_location('Leaving:'|| l_proc, 20);
154:
155: RETURN l_msg_name;
156:
157: END; -- get_msg_name

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

178: l_proc VARCHAR2(72) := g_package||'get_new_data_elmt_id';
179:
180: BEGIN
181:
182: hr_utility.set_location('Entering:'|| l_proc, 10);
183:
184: OPEN c_new_data_elmt_id;
185: FETCH c_new_data_elmt_id into l_new_data_elmt_id;
186: CLOSE c_new_data_elmt_id;

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

184: OPEN c_new_data_elmt_id;
185: FETCH c_new_data_elmt_id into l_new_data_elmt_id;
186: CLOSE c_new_data_elmt_id;
187:
188: hr_utility.set_location('Leaving:'|| l_proc, 20);
189:
190: RETURN l_new_data_elmt_id;
191:
192: END; -- get_new_data_elmt_id

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

221: l_proc VARCHAR2(72) := g_package||'get_new_WCDInR_DInR_id';
222:
223: BEGIN
224:
225: hr_utility.set_location('Entering:'|| l_proc, 10);
226:
227: OPEN c_new_data_elmt_in_rcd_id;
228: FETCH c_new_data_elmt_in_rcd_id INTO l_new_data_elmt_in_rcd_id;
229: CLOSE c_new_data_elmt_in_rcd_id;

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

227: OPEN c_new_data_elmt_in_rcd_id;
228: FETCH c_new_data_elmt_in_rcd_id INTO l_new_data_elmt_in_rcd_id;
229: CLOSE c_new_data_elmt_in_rcd_id;
230:
231: hr_utility.set_location('Leaving:'|| l_proc, 20);
232:
233: RETURN l_new_data_elmt_in_rcd_id;
234:
235:

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

266: l_proc VARCHAR2(72) := g_package||'get_new_WCRInF_DInR_id';
267:
268: BEGIN
269:
270: hr_utility.set_location('Entering:'|| l_proc, 10);
271:
272: OPEN c_new_data_elmt_in_rcd_id;
273: FETCH c_new_data_elmt_in_rcd_id INTO l_new_data_elmt_in_rcd_id;
274: CLOSE c_new_data_elmt_in_rcd_id;

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

272: OPEN c_new_data_elmt_in_rcd_id;
273: FETCH c_new_data_elmt_in_rcd_id INTO l_new_data_elmt_in_rcd_id;
274: CLOSE c_new_data_elmt_in_rcd_id;
275:
276: hr_utility.set_location('Leaving:'|| l_proc, 20);
277:
278: RETURN l_new_data_elmt_in_rcd_id;
279:
280:

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

302: l_proc VARCHAR2(72) := g_package||'get_new_rcd_id';
303:
304: BEGIN
305:
306: hr_utility.set_location('Entering:'|| l_proc, 10);
307:
308: OPEN c_new_rcd_id;
309: FETCH c_new_rcd_id into l_new_rcd_id;
310: CLOSE c_new_rcd_id;

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

308: OPEN c_new_rcd_id;
309: FETCH c_new_rcd_id into l_new_rcd_id;
310: CLOSE c_new_rcd_id;
311:
312: hr_utility.set_location('Leaving:'|| l_proc, 20);
313: RETURN l_new_rcd_id;
314:
315: END; -- get_new_rcd_id
316:

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

332: l_proc VARCHAR2(72) := g_package||'get_new_formula_id';
333:
334: BEGIN
335:
336: hr_utility.set_location('Entering:'|| l_proc, 10);
337:
338: OPEN c_formula_id;
339: FETCH c_formula_id INTO l_formula_id;
340: CLOSE c_formula_id;

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

338: OPEN c_formula_id;
339: FETCH c_formula_id INTO l_formula_id;
340: CLOSE c_formula_id;
341:
342: hr_utility.set_location('Leaving:'|| l_proc, 20);
343:
344: RETURN l_formula_id;
345:
346: END; -- get_new_formula_id

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

379: l_FF93_FORMULA_txt varchar2(80);
380:
381: BEGIN
382:
383: hr_utility.set_location('Entering:'|| l_proc, 10);
384:
385: OPEN c_formula;
386: FETCH c_formula INTO r_curr_formula;
387: CLOSE c_formula;

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

445: END IF; -- get_msg_name() <> 'FF52_NAME_ALREADY_USED'
446:
447: END; -- Insert into FF_FORMULAS_F using Row Handler
448:
449: hr_utility.set_location('Leaving:'|| l_proc, 20);
450:
451: RETURN l_new_formula_id;
452:
453: END; -- copy_formula

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

527: l_proc VARCHAR2(72) := g_package||'copy_criteria_definition';
528:
529: BEGIN
530:
531: hr_utility.set_location('Entering:'|| l_proc, 10);
532:
533: FOR r_curr_ext_crit_prfl IN c_ext_crit_prfl
534: LOOP -- 2 Get Criteria Profile data for current EXT_DFN_ID
535:

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

656:
657: -- Assign the New Extract Criteria Profile Id to return variable
658: p_new_ext_crit_prfl_id := l_new_ext_crit_prfl_id;
659:
660: hr_utility.set_location('Leaving:'|| l_proc, 20);
661:
662: END copy_criteria_definition; -- copy_criteria_definition
663:
664:

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

840: l_proc VARCHAR2(72) := g_package||'copy_file_layout';
841:
842: BEGIN
843:
844: hr_utility.set_location('Entering:'|| l_proc, 10);
845:
846: FOR r_curr_ext_file IN c_ext_file
847: LOOP -- 6 Get File Layout data for current EXT_DFN_ID
848:

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

1377: p_new_ext_file_id := l_new_ext_file_id;
1378:
1379: END LOOP; -- 6
1380:
1381: hr_utility.set_location('Leaving:'|| l_proc, 20);
1382:
1383: END copy_file_layout; -- copy_file_layout
1384:
1385: -- ----------------------------------------------------------------------------

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

1416: l_proc VARCHAR2(72) := g_package||'copy_extract';
1417:
1418: BEGIN
1419:
1420: hr_utility.set_location('Entering:'|| l_proc, 10);
1421:
1422: IF p_new_extract_name IS NULL THEN
1423: fnd_message.set_name('PQP', 'PQP_230541_EXTRACT_PREFIX_NULL');
1424: fnd_message.raise_error;

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

1539:
1540: -- Assign collection of formula ids to return variable
1541: p_formulas := t_Formulas;
1542:
1543: hr_utility.set_location('Leaving:'|| l_proc, 20);
1544:
1545: END copy_extract;
1546:
1547: END ben_copy_extract;