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

Line 238: hr_utility.set_message(801, 'PAY_34031_FORMULA_DEL_TMPL');

234: open csr_element_template;
235: fetch csr_element_template into v_dummy;
236: if csr_element_template%found then
237: close csr_element_template;
238: hr_utility.set_message(801, 'PAY_34031_FORMULA_DEL_TMPL');
239: hr_utility.raise_error;
240: else
241: close csr_element_template;
242: end if;

Line 239: hr_utility.raise_error;

235: fetch csr_element_template into v_dummy;
236: if csr_element_template%found then
237: close csr_element_template;
238: hr_utility.set_message(801, 'PAY_34031_FORMULA_DEL_TMPL');
239: hr_utility.raise_error;
240: else
241: close csr_element_template;
242: end if;
243:

Line 250: hr_utility.set_message(801, 'PAY_34032_FORMULA_DEL_AU_MOD');

246: open csr_au_modules;
247: fetch csr_au_modules into v_dummy;
248: if csr_au_modules%found then
249: close csr_au_modules;
250: hr_utility.set_message(801, 'PAY_34032_FORMULA_DEL_AU_MOD');
251: hr_utility.raise_error;
252: else
253: close csr_au_modules;
254: end if;

Line 251: hr_utility.raise_error;

247: fetch csr_au_modules into v_dummy;
248: if csr_au_modules%found then
249: close csr_au_modules;
250: hr_utility.set_message(801, 'PAY_34032_FORMULA_DEL_AU_MOD');
251: hr_utility.raise_error;
252: else
253: close csr_au_modules;
254: end if;
255:

Line 262: hr_utility.set_message(801, 'PAY_34033_FORMULA_DEL_ACCRUAL');

258: open csr_accrual_plans;
259: fetch csr_accrual_plans into v_dummy;
260: if csr_accrual_plans%found then
261: close csr_accrual_plans;
262: hr_utility.set_message(801, 'PAY_34033_FORMULA_DEL_ACCRUAL');
263: hr_utility.raise_error;
264: else
265: close csr_accrual_plans;
266: end if;

Line 263: hr_utility.raise_error;

259: fetch csr_accrual_plans into v_dummy;
260: if csr_accrual_plans%found then
261: close csr_accrual_plans;
262: hr_utility.set_message(801, 'PAY_34033_FORMULA_DEL_ACCRUAL');
263: hr_utility.raise_error;
264: else
265: close csr_accrual_plans;
266: end if;
267:

Line 273: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');

269: open csr_per_cagr_entitle_items;
270: fetch csr_per_cagr_entitle_items into v_dummy;
271: if csr_per_cagr_entitle_items%found then
272: close csr_per_cagr_entitle_items;
273: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
274: hr_utility.raise_error;
275: else
276: close csr_per_cagr_entitle_items;
277: end if;

Line 274: hr_utility.raise_error;

270: fetch csr_per_cagr_entitle_items into v_dummy;
271: if csr_per_cagr_entitle_items%found then
272: close csr_per_cagr_entitle_items;
273: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
274: hr_utility.raise_error;
275: else
276: close csr_per_cagr_entitle_items;
277: end if;
278:

Line 284: hr_utility.set_message(801, 'HR_6871_FORMULA_DEL_QP_I');

280: open csr_qp_report;
281: fetch csr_qp_report into v_dummy;
282: if csr_qp_report%found then
283: close csr_qp_report;
284: hr_utility.set_message(801, 'HR_6871_FORMULA_DEL_QP_I');
285: hr_utility.raise_error;
286: else
287: close csr_qp_report;
288: end if;

Line 285: hr_utility.raise_error;

281: fetch csr_qp_report into v_dummy;
282: if csr_qp_report%found then
283: close csr_qp_report;
284: hr_utility.set_message(801, 'HR_6871_FORMULA_DEL_QP_I');
285: hr_utility.raise_error;
286: else
287: close csr_qp_report;
288: end if;
289: --

Line 294: hr_utility.set_message(801, 'HR_6872_FORMULA_DEL_ASS_SET');

290: open csr_assignment_set;
291: fetch csr_assignment_set into v_dummy;
292: if csr_assignment_set%found then
293: close csr_assignment_set;
294: hr_utility.set_message(801, 'HR_6872_FORMULA_DEL_ASS_SET');
295: hr_utility.raise_error;
296: else
297: close csr_assignment_set;
298: end if;

Line 295: hr_utility.raise_error;

291: fetch csr_assignment_set into v_dummy;
292: if csr_assignment_set%found then
293: close csr_assignment_set;
294: hr_utility.set_message(801, 'HR_6872_FORMULA_DEL_ASS_SET');
295: hr_utility.raise_error;
296: else
297: close csr_assignment_set;
298: end if;
299: --

Line 304: hr_utility.set_message(801, 'HR_6879_FORMULA_DEL_USER_COL');

300: open csr_user_column;
301: fetch csr_user_column into v_dummy;
302: if csr_user_column%found then
303: close csr_user_column;
304: hr_utility.set_message(801, 'HR_6879_FORMULA_DEL_USER_COL');
305: hr_utility.raise_error;
306: else
307: close csr_user_column;
308: end if;

Line 305: hr_utility.raise_error;

301: fetch csr_user_column into v_dummy;
302: if csr_user_column%found then
303: close csr_user_column;
304: hr_utility.set_message(801, 'HR_6879_FORMULA_DEL_USER_COL');
305: hr_utility.raise_error;
306: else
307: close csr_user_column;
308: end if;
309: --

Line 314: hr_utility.set_message(801, 'HR_7341_FORMULA_DEL_MAG_REC');

310: open csr_magnetic_record;
311: fetch csr_magnetic_record into v_dummy;
312: if csr_magnetic_record%found then
313: close csr_magnetic_record;
314: hr_utility.set_message(801, 'HR_7341_FORMULA_DEL_MAG_REC');
315: hr_utility.raise_error;
316: else
317: close csr_magnetic_record;
318: end if;

Line 315: hr_utility.raise_error;

311: fetch csr_magnetic_record into v_dummy;
312: if csr_magnetic_record%found then
313: close csr_magnetic_record;
314: hr_utility.set_message(801, 'HR_7341_FORMULA_DEL_MAG_REC');
315: hr_utility.raise_error;
316: else
317: close csr_magnetic_record;
318: end if;
319: --

Line 333: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');

329: open csr_cagr_retained_rights;
330: fetch csr_cagr_retained_rights into v_dummy;
331: if csr_cagr_retained_rights%found then
332: close csr_cagr_retained_rights;
333: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
334: hr_utility.raise_error;
335: else
336: close csr_cagr_retained_rights;
337: end if;

Line 334: hr_utility.raise_error;

330: fetch csr_cagr_retained_rights into v_dummy;
331: if csr_cagr_retained_rights%found then
332: close csr_cagr_retained_rights;
333: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
334: hr_utility.raise_error;
335: else
336: close csr_cagr_retained_rights;
337: end if;
338:

Line 344: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');

340: open csr_per_cagr_entitle_results;
341: fetch csr_per_cagr_entitle_results into v_dummy;
342: if csr_per_cagr_entitle_results%found then
343: close csr_per_cagr_entitle_results;
344: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
345: hr_utility.raise_error;
346: else
347: close csr_per_cagr_entitle_results;
348: end if;

Line 345: hr_utility.raise_error;

341: fetch csr_per_cagr_entitle_results into v_dummy;
342: if csr_per_cagr_entitle_results%found then
343: close csr_per_cagr_entitle_results;
344: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
345: hr_utility.raise_error;
346: else
347: close csr_per_cagr_entitle_results;
348: end if;
349:

Line 355: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');

351: open csr_per_cagr_entitlements;
352: fetch csr_per_cagr_entitlements into v_dummy;
353: if csr_per_cagr_entitlements%found then
354: close csr_per_cagr_entitlements;
355: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
356: hr_utility.raise_error;
357: else
358: close csr_per_cagr_entitlements;
359: end if;

Line 356: hr_utility.raise_error;

352: fetch csr_per_cagr_entitlements into v_dummy;
353: if csr_per_cagr_entitlements%found then
354: close csr_per_cagr_entitlements;
355: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
356: hr_utility.raise_error;
357: else
358: close csr_per_cagr_entitlements;
359: end if;
360: --

Line 365: hr_utility.set_message(801, 'HR_6873_FORMULA_DEL_INP_VAL');

361: open csr_input_value;
362: fetch csr_input_value into v_dummy;
363: if csr_input_value%found then
364: close csr_input_value;
365: hr_utility.set_message(801, 'HR_6873_FORMULA_DEL_INP_VAL');
366: hr_utility.raise_error;
367: else
368: close csr_input_value;
369: end if;

Line 366: hr_utility.raise_error;

362: fetch csr_input_value into v_dummy;
363: if csr_input_value%found then
364: close csr_input_value;
365: hr_utility.set_message(801, 'HR_6873_FORMULA_DEL_INP_VAL');
366: hr_utility.raise_error;
367: else
368: close csr_input_value;
369: end if;
370: --

Line 375: hr_utility.set_message(801, 'HR_6878_FORMULA_DEL_PRO_RULE');

371: open csr_stat_proc_rule;
372: fetch csr_stat_proc_rule into v_dummy;
373: if csr_stat_proc_rule%found then
374: close csr_stat_proc_rule;
375: hr_utility.set_message(801, 'HR_6878_FORMULA_DEL_PRO_RULE');
376: hr_utility.raise_error;
377: else
378: close csr_stat_proc_rule;
379: end if;

Line 376: hr_utility.raise_error;

372: fetch csr_stat_proc_rule into v_dummy;
373: if csr_stat_proc_rule%found then
374: close csr_stat_proc_rule;
375: hr_utility.set_message(801, 'HR_6878_FORMULA_DEL_PRO_RULE');
376: hr_utility.raise_error;
377: else
378: close csr_stat_proc_rule;
379: end if;
380: --

Line 390: hr_utility.set_message(801, 'PAY_33160_FORMULA_DEL_ELE_PRO');

386: -- Raise appropirate error message depending on the type of formula.
387: --
388: if l_formula_type_name = 'PAYROLL RUN PRORATION' then
389:
390: hr_utility.set_message(801, 'PAY_33160_FORMULA_DEL_ELE_PRO');
391: hr_utility.raise_error;
392:
393: elsif l_formula_type_name = 'NET TO GROSS' then
394:

Line 391: hr_utility.raise_error;

387: --
388: if l_formula_type_name = 'PAYROLL RUN PRORATION' then
389:
390: hr_utility.set_message(801, 'PAY_33160_FORMULA_DEL_ELE_PRO');
391: hr_utility.raise_error;
392:
393: elsif l_formula_type_name = 'NET TO GROSS' then
394:
395: hr_utility.set_message(801, 'PAY_34035_FORMULA_DEL_ELE_NTG');

Line 395: hr_utility.set_message(801, 'PAY_34035_FORMULA_DEL_ELE_NTG');

391: hr_utility.raise_error;
392:
393: elsif l_formula_type_name = 'NET TO GROSS' then
394:
395: hr_utility.set_message(801, 'PAY_34035_FORMULA_DEL_ELE_NTG');
396: hr_utility.raise_error;
397:
398: else
399: hr_utility.set_message(801, 'HR_6955_PAY_FORMULA_DEL_ELE');

Line 396: hr_utility.raise_error;

392:
393: elsif l_formula_type_name = 'NET TO GROSS' then
394:
395: hr_utility.set_message(801, 'PAY_34035_FORMULA_DEL_ELE_NTG');
396: hr_utility.raise_error;
397:
398: else
399: hr_utility.set_message(801, 'HR_6955_PAY_FORMULA_DEL_ELE');
400: hr_utility.raise_error;

Line 399: hr_utility.set_message(801, 'HR_6955_PAY_FORMULA_DEL_ELE');

395: hr_utility.set_message(801, 'PAY_34035_FORMULA_DEL_ELE_NTG');
396: hr_utility.raise_error;
397:
398: else
399: hr_utility.set_message(801, 'HR_6955_PAY_FORMULA_DEL_ELE');
400: hr_utility.raise_error;
401:
402: end if;
403: else

Line 400: hr_utility.raise_error;

396: hr_utility.raise_error;
397:
398: else
399: hr_utility.set_message(801, 'HR_6955_PAY_FORMULA_DEL_ELE');
400: hr_utility.raise_error;
401:
402: end if;
403: else
404: close csr_element_type;

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

573: OPEN C;
574: FETCH C INTO ReturnInfo;
575: if (C%NOTFOUND) then
576: CLOSE C;
577: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
578: hr_utility.set_message_token('PROCEDURE',
579: 'ff_formulas_f_pkg.insert_row');
580: hr_utility.set_message_token('STEP','1');
581: hr_utility.raise_error;

Line 578: hr_utility.set_message_token('PROCEDURE',

574: FETCH C INTO ReturnInfo;
575: if (C%NOTFOUND) then
576: CLOSE C;
577: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
578: hr_utility.set_message_token('PROCEDURE',
579: 'ff_formulas_f_pkg.insert_row');
580: hr_utility.set_message_token('STEP','1');
581: hr_utility.raise_error;
582: end if;

Line 580: hr_utility.set_message_token('STEP','1');

576: CLOSE C;
577: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
578: hr_utility.set_message_token('PROCEDURE',
579: 'ff_formulas_f_pkg.insert_row');
580: hr_utility.set_message_token('STEP','1');
581: hr_utility.raise_error;
582: end if;
583: CLOSE C;
584: --

Line 581: hr_utility.raise_error;

577: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
578: hr_utility.set_message_token('PROCEDURE',
579: 'ff_formulas_f_pkg.insert_row');
580: hr_utility.set_message_token('STEP','1');
581: hr_utility.raise_error;
582: end if;
583: CLOSE C;
584: --
585: X_Rowid := ReturnInfo.row_id;

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

628: OPEN C;
629: FETCH C INTO Recinfo;
630: if (C%NOTFOUND) then
631: CLOSE C;
632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PROCEDURE',
634: 'ff_formulas_f_pkg.lock_row');
635: hr_utility.set_message_token('STEP','1');
636: hr_utility.raise_error;

Line 633: hr_utility.set_message_token('PROCEDURE',

629: FETCH C INTO Recinfo;
630: if (C%NOTFOUND) then
631: CLOSE C;
632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PROCEDURE',
634: 'ff_formulas_f_pkg.lock_row');
635: hr_utility.set_message_token('STEP','1');
636: hr_utility.raise_error;
637: end if;

Line 635: hr_utility.set_message_token('STEP','1');

631: CLOSE C;
632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PROCEDURE',
634: 'ff_formulas_f_pkg.lock_row');
635: hr_utility.set_message_token('STEP','1');
636: hr_utility.raise_error;
637: end if;
638: CLOSE C;
639: --

Line 636: hr_utility.raise_error;

632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PROCEDURE',
634: 'ff_formulas_f_pkg.lock_row');
635: hr_utility.set_message_token('STEP','1');
636: hr_utility.raise_error;
637: end if;
638: CLOSE C;
639: --
640: -- Remove trailing spaces.

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

710: OPEN C;
711: FETCH C INTO v_current_update_date;
712: if (C%NOTFOUND) then
713: CLOSE C;
714: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
715: hr_utility.set_message_token('PROCEDURE',
716: 'ff_formulas_f_pkg.lock_row');
717: hr_utility.set_message_token('STEP','1');
718: hr_utility.raise_error;

Line 715: hr_utility.set_message_token('PROCEDURE',

711: FETCH C INTO v_current_update_date;
712: if (C%NOTFOUND) then
713: CLOSE C;
714: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
715: hr_utility.set_message_token('PROCEDURE',
716: 'ff_formulas_f_pkg.lock_row');
717: hr_utility.set_message_token('STEP','1');
718: hr_utility.raise_error;
719: end if;

Line 717: hr_utility.set_message_token('STEP','1');

713: CLOSE C;
714: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
715: hr_utility.set_message_token('PROCEDURE',
716: 'ff_formulas_f_pkg.lock_row');
717: hr_utility.set_message_token('STEP','1');
718: hr_utility.raise_error;
719: end if;
720: CLOSE C;
721: --

Line 718: hr_utility.raise_error;

714: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
715: hr_utility.set_message_token('PROCEDURE',
716: 'ff_formulas_f_pkg.lock_row');
717: hr_utility.set_message_token('STEP','1');
718: hr_utility.raise_error;
719: end if;
720: CLOSE C;
721: --
722: -- Compare the last_update_date from the client against that held on the

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

805: --------------------------------------------------------------------------------
806:
807: ---
808: if (SQL%NOTFOUND) then
809: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
810: hr_utility.set_message_token('PROCEDURE',
811: 'ff_formulas_f_pkg.update_row');
812: hr_utility.set_message_token('STEP','1');
813: hr_utility.raise_error;

Line 810: hr_utility.set_message_token('PROCEDURE',

806:
807: ---
808: if (SQL%NOTFOUND) then
809: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
810: hr_utility.set_message_token('PROCEDURE',
811: 'ff_formulas_f_pkg.update_row');
812: hr_utility.set_message_token('STEP','1');
813: hr_utility.raise_error;
814: end if;

Line 812: hr_utility.set_message_token('STEP','1');

808: if (SQL%NOTFOUND) then
809: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
810: hr_utility.set_message_token('PROCEDURE',
811: 'ff_formulas_f_pkg.update_row');
812: hr_utility.set_message_token('STEP','1');
813: hr_utility.raise_error;
814: end if;
815: --
816: OPEN C;

Line 813: hr_utility.raise_error;

809: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
810: hr_utility.set_message_token('PROCEDURE',
811: 'ff_formulas_f_pkg.update_row');
812: hr_utility.set_message_token('STEP','1');
813: hr_utility.raise_error;
814: end if;
815: --
816: OPEN C;
817: FETCH C INTO v_current_update_date;

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

816: OPEN C;
817: FETCH C INTO v_current_update_date;
818: if (C%NOTFOUND) then
819: CLOSE C;
820: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
821: hr_utility.set_message_token('PROCEDURE',
822: 'ff_formulas_f_pkg.update_row');
823: hr_utility.set_message_token('STEP','2');
824: hr_utility.raise_error;

Line 821: hr_utility.set_message_token('PROCEDURE',

817: FETCH C INTO v_current_update_date;
818: if (C%NOTFOUND) then
819: CLOSE C;
820: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
821: hr_utility.set_message_token('PROCEDURE',
822: 'ff_formulas_f_pkg.update_row');
823: hr_utility.set_message_token('STEP','2');
824: hr_utility.raise_error;
825: end if;

Line 823: hr_utility.set_message_token('STEP','2');

819: CLOSE C;
820: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
821: hr_utility.set_message_token('PROCEDURE',
822: 'ff_formulas_f_pkg.update_row');
823: hr_utility.set_message_token('STEP','2');
824: hr_utility.raise_error;
825: end if;
826: CLOSE C;
827: --

Line 824: hr_utility.raise_error;

820: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
821: hr_utility.set_message_token('PROCEDURE',
822: 'ff_formulas_f_pkg.update_row');
823: hr_utility.set_message_token('STEP','2');
824: hr_utility.raise_error;
825: end if;
826: CLOSE C;
827: --
828: X_Last_Update_Date := v_current_update_date;

Line 968: hr_utility.set_message(801, 'PAY_34036_FORMULA_DEL_OAB');

964: p_legislation_cd => Formula_Details.legislation_code
965: );
966:
967: if l_formula_in_oab = true then
968: hr_utility.set_message(801, 'PAY_34036_FORMULA_DEL_OAB');
969: hr_utility.raise_error;
970: end if;
971:
972:

Line 969: hr_utility.raise_error;

965: );
966:
967: if l_formula_in_oab = true then
968: hr_utility.set_message(801, 'PAY_34036_FORMULA_DEL_OAB');
969: hr_utility.raise_error;
970: end if;
971:
972:
973: end if;

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

989: DELETE FROM ff_formulas_f
990: WHERE rowid = X_Rowid;
991: --
992: if (SQL%NOTFOUND) then
993: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
994: hr_utility.set_message_token('PROCEDURE',
995: 'ff_formulas_f_pkg.delete_row');
996: hr_utility.set_message_token('STEP','1');
997: hr_utility.raise_error;

Line 994: hr_utility.set_message_token('PROCEDURE',

990: WHERE rowid = X_Rowid;
991: --
992: if (SQL%NOTFOUND) then
993: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
994: hr_utility.set_message_token('PROCEDURE',
995: 'ff_formulas_f_pkg.delete_row');
996: hr_utility.set_message_token('STEP','1');
997: hr_utility.raise_error;
998: end if;

Line 996: hr_utility.set_message_token('STEP','1');

992: if (SQL%NOTFOUND) then
993: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
994: hr_utility.set_message_token('PROCEDURE',
995: 'ff_formulas_f_pkg.delete_row');
996: hr_utility.set_message_token('STEP','1');
997: hr_utility.raise_error;
998: end if;
999: --
1000: END Delete_Row;

Line 997: hr_utility.raise_error;

993: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
994: hr_utility.set_message_token('PROCEDURE',
995: 'ff_formulas_f_pkg.delete_row');
996: hr_utility.set_message_token('STEP','1');
997: hr_utility.raise_error;
998: end if;
999: --
1000: END Delete_Row;
1001: --

Line 1148: hr_utility.set_location (l_package_name,10);

1144: BEGIN
1145: l_package_name := 'FF_FORMULAS_F_PKG.VALIDATE_TRANSLATION';
1146: l_business_group_id := p_business_group_id;
1147: l_legislation_code := p_legislation_code;
1148: hr_utility.set_location (l_package_name,10);
1149: OPEN c_translation(language, formula_name,formula_id,
1150: l_business_group_id,l_legislation_code);
1151: hr_utility.set_location (l_package_name,50);
1152: FETCH c_translation INTO g_dummy;

Line 1151: hr_utility.set_location (l_package_name,50);

1147: l_legislation_code := p_legislation_code;
1148: hr_utility.set_location (l_package_name,10);
1149: OPEN c_translation(language, formula_name,formula_id,
1150: l_business_group_id,l_legislation_code);
1151: hr_utility.set_location (l_package_name,50);
1152: FETCH c_translation INTO g_dummy;
1153:
1154: IF c_translation%NOTFOUND THEN
1155: hr_utility.set_location (l_package_name,60);

Line 1155: hr_utility.set_location (l_package_name,60);

1151: hr_utility.set_location (l_package_name,50);
1152: FETCH c_translation INTO g_dummy;
1153:
1154: IF c_translation%NOTFOUND THEN
1155: hr_utility.set_location (l_package_name,60);
1156: CLOSE c_translation;
1157: ELSE
1158: hr_utility.set_location (l_package_name,70);
1159: CLOSE c_translation;

Line 1158: hr_utility.set_location (l_package_name,70);

1154: IF c_translation%NOTFOUND THEN
1155: hr_utility.set_location (l_package_name,60);
1156: CLOSE c_translation;
1157: ELSE
1158: hr_utility.set_location (l_package_name,70);
1159: CLOSE c_translation;
1160: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
1161: fnd_message.raise_error;
1162: END IF;

Line 1163: hr_utility.set_location ('Leaving:'||l_package_name,80);

1159: CLOSE c_translation;
1160: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
1161: fnd_message.raise_error;
1162: END IF;
1163: hr_utility.set_location ('Leaving:'||l_package_name,80);
1164: END validate_translation;
1165: --
1166: function return_dml_status
1167: return boolean