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_DATABASE_ITEMS_PKG dependencies on HR_UTILITY

Line 162: l_debug boolean := hr_utility.debug_enabled;

158: ,x_language in varchar2
159: ,x_translated_user_name in varchar2
160: ,x_replaced_names out nocopy dbms_sql.varchar2s
161: ) is
162: l_debug boolean := hr_utility.debug_enabled;
163: l_found varchar2(1);
164: i binary_integer;
165: --
166: -- Cursor to fetch affected language rows.

Line 201: hr_utility.set_location('in_use_replaced_names', 10);

197: and source_lang <> x_language
198: ;
199: begin
200: if l_debug then
201: hr_utility.set_location('in_use_replaced_names', 10);
202: end if;
203:
204: --
205: -- Verify that the existing names aren't used in any formulas.

Line 238: hr_utility.trace

234: ,p_language => null
235: ) then
236:
237: if l_debug then
238: hr_utility.trace
239: ('Replaced name ' || crec.translated_user_name ||
240: ' is still referenced by a Formula.'
241: );
242: end if;

Line 287: l_debug boolean := hr_utility.debug_enabled;

283: l_bus_group_ids dbms_sql.number_table;
284: l_leg_codes dbms_sql.varchar2s;
285: l_encoded_message varchar2(2000);
286: l_rowid varchar2(2000);
287: l_debug boolean := hr_utility.debug_enabled;
288: begin
289:
290: if l_debug then
291: hr_utility.set_location('handle_referencing_formulas', 10);

Line 291: hr_utility.set_location('handle_referencing_formulas', 10);

287: l_debug boolean := hr_utility.debug_enabled;
288: begin
289:
290: if l_debug then
291: hr_utility.set_location('handle_referencing_formulas', 10);
292: end if;
293:
294:
295: --

Line 313: hr_utility.set_location('handle_referencing_formulas', 20);

309: ,p_leg_codes => l_leg_codes
310: );
311:
312: if l_debug then
313: hr_utility.set_location('handle_referencing_formulas', 20);
314: end if;
315:
316: if l_formula_ids.count = 0 then
317:

Line 319: hr_utility.set_location('handle_referencing_formulas', 30);

315:
316: if l_formula_ids.count = 0 then
317:
318: if l_debug then
319: hr_utility.set_location('handle_referencing_formulas', 30);
320: end if;
321:
322: return;
323: end if;

Line 332: hr_utility.set_location('handle_referencing_formulas', 40);

328: --
329: if l_bus_group_ids(i) is null then
330:
331: if l_debug then
332: hr_utility.set_location('handle_referencing_formulas', 40);
333: end if;
334:
335: --
336: -- Cannot allow seeded Formulas to become invalid.

Line 343: hr_utility.set_location('handle_referencing_formulas', 50);

339:
340: if x_old_tl_name is not null then
341:
342: if l_debug then
343: hr_utility.set_location('handle_referencing_formulas', 50);
344: end if;
345:
346: fnd_message.set_name ('FF','FF_33438_OLDDBINAME_IN_SEED_FF');
347: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);

Line 356: hr_utility.set_location('handle_referencing_formulas', 60);

352: l_encoded_message := fnd_message.get_encoded;
353: else
354:
355: if l_debug then
356: hr_utility.set_location('handle_referencing_formulas', 60);
357: end if;
358:
359: fnd_message.set_name ('FF','FF_33440_NEWDBINAME_IN_SEED_FF');
360: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);

Line 373: hr_utility.set_location('handle_referencing_formulas', 70);

369: --
370: else
371:
372: if l_debug then
373: hr_utility.set_location('handle_referencing_formulas', 70);
374: end if;
375:
376: if x_old_tl_name is not null then
377:

Line 379: hr_utility.set_location('handle_referencing_formulas', 80);

375:
376: if x_old_tl_name is not null then
377:
378: if l_debug then
379: hr_utility.set_location('handle_referencing_formulas', 80);
380: end if;
381:
382: fnd_message.set_name ('FF','FF_33437_OLDDBINAME_IN_CUST_FF');
383: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);

Line 393: hr_utility.set_location('handle_referencing_formulas', 90);

389: l_encoded_message := fnd_message.get_encoded;
390: else
391:
392: if l_debug then
393: hr_utility.set_location('handle_referencing_formulas', 90);
394: end if;
395:
396: fnd_message.set_name ('FF','FF_33439_NEWDBINAME_IN_CUST_FF');
397: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);

Line 407: hr_utility.set_location('handle_referencing_formulas', 100);

403: end if;
404: end if;
405:
406: if l_debug then
407: hr_utility.set_location('handle_referencing_formulas', 100);
408: end if;
409:
410:
411: --

Line 429: hr_utility.set_location('handle_referencing_formulas', 110);

425: --
426: if l_bus_group_ids(i) is not null then
427:
428: if l_debug then
429: hr_utility.set_location('handle_referencing_formulas', 110);
430: end if;
431:
432: x_message_rowids(x_message_rowids.count + 1) := l_rowid;
433:

Line 450: hr_utility.set_location('handle_referencing_formulas', 200);

446: end if;
447: end loop;
448:
449: if l_debug then
450: hr_utility.set_location('handle_referencing_formulas', 200);
451: end if;
452:
453: end handle_referencing_formulas;
454:

Line 495: l_debug := hr_utility.debug_enabled;

491: l_debug boolean;
492: l_raise_errors boolean;
493: l_dont_update boolean;
494: begin
495: l_debug := hr_utility.debug_enabled;
496:
497: if l_debug then
498: hr_utility.set_location('ffdict.core_update_tl_rows',10);
499: end if;

Line 498: hr_utility.set_location('ffdict.core_update_tl_rows',10);

494: begin
495: l_debug := hr_utility.debug_enabled;
496:
497: if l_debug then
498: hr_utility.set_location('ffdict.core_update_tl_rows',10);
499: end if;
500:
501: --
502: -- Always raise errors for non-seeded update.

Line 507: hr_utility.trace('RAISE (instead of LOG) errors.');

503: --
504: l_raise_errors := (x_raise_errors or not x_seed_update);
505: if l_debug then
506: if l_raise_errors then
507: hr_utility.trace('RAISE (instead of LOG) errors.');
508: else
509: hr_utility.trace('LOG (instead of RAISE) errors.');
510: end if;
511: end if;

Line 509: hr_utility.trace('LOG (instead of RAISE) errors.');

505: if l_debug then
506: if l_raise_errors then
507: hr_utility.trace('RAISE (instead of LOG) errors.');
508: else
509: hr_utility.trace('LOG (instead of RAISE) errors.');
510: end if;
511: end if;
512:
513: l_user_name := upper(x_user_name);

Line 521: hr_utility.set_location('ffdict.core_update_tl_rows',20);

517: -- Validate the proposed translated database item name. --
518: ----------------------------------------------------------
519: if l_raise_errors then
520: if l_debug then
521: hr_utility.set_location('ffdict.core_update_tl_rows',20);
522: end if;
523:
524: ffdict.validate_tl_dbi
525: (p_user_name => l_user_name

Line 531: hr_utility.set_location('ffdict.core_update_tl_rows',30);

527: ,p_tl_user_name => l_tl_user_name
528: );
529: else
530: if l_debug then
531: hr_utility.set_location('ffdict.core_update_tl_rows',30);
532: end if;
533:
534: ffdict.core_validate_tl_dbitem
535: (p_user_name => l_user_name

Line 559: hr_utility.set_location('ffdict.core_update_tl_rows',35);

555: ,p_message_text => l_encoded_message
556: );
557:
558: if l_debug then
559: hr_utility.set_location('ffdict.core_update_tl_rows',35);
560: end if;
561:
562: x_got_error := true;
563: return;

Line 567: hr_utility.set_location('ffdict.core_update_tl_rows',40);

563: return;
564: end if;
565:
566: if l_debug then
567: hr_utility.set_location('ffdict.core_update_tl_rows',40);
568: end if;
569:
570: --
571: -- New DB item name cannot be same as existing context name.

Line 587: hr_utility.set_location('ffdict.core_update_tl_rows',45);

583: ,p_message_text => l_encoded_message
584: );
585:
586: if l_debug then
587: hr_utility.set_location('ffdict.core_update_tl_rows',45);
588: end if;
589:
590: x_got_error := true;
591: return;

Line 595: hr_utility.set_location('ffdict.core_update_tl_rows',50);

591: return;
592: end if;
593:
594: if l_debug then
595: hr_utility.set_location('ffdict.core_update_tl_rows',50);
596: end if;
597:
598: --
599: -- New DB item name cannot be same as existing item in any verified

Line 626: hr_utility.set_location('ffdict.core_update_tl_rows',55);

622: (p_rowids => l_message_rowids
623: );
624:
625: if l_debug then
626: hr_utility.set_location('ffdict.core_update_tl_rows',55);
627: end if;
628:
629: x_got_error := true;
630: return;

Line 635: hr_utility.set_location('ffdict.core_update_tl_rows',60);

631: end if;
632: end if;
633:
634: if l_debug then
635: hr_utility.set_location('ffdict.core_update_tl_rows',60);
636: end if;
637: end if;
638:
639: -----------------------------------------------------------------------

Line 648: hr_utility.set_location('ffdict.core_update_tl_rows',70);

644: --
645: -- This test always needs to be performed.
646: --
647: if l_debug then
648: hr_utility.set_location('ffdict.core_update_tl_rows',70);
649: end if;
650:
651: --
652: -- Verify that the existing names aren't used in any formulas.

Line 665: hr_utility.set_location('ffdict.core_update_tl_rows',75);

661:
662: if l_replaced_names.count <> 0 then
663: if l_raise_errors then
664: if l_debug then
665: hr_utility.set_location('ffdict.core_update_tl_rows',75);
666: end if;
667:
668: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
669: hr_utility.set_message_token('1', l_replaced_names(1));

Line 668: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');

664: if l_debug then
665: hr_utility.set_location('ffdict.core_update_tl_rows',75);
666: end if;
667:
668: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
669: hr_utility.set_message_token('1', l_replaced_names(1));
670: hr_utility.raise_error;
671: else
672: l_dont_update := false;

Line 669: hr_utility.set_message_token('1', l_replaced_names(1));

665: hr_utility.set_location('ffdict.core_update_tl_rows',75);
666: end if;
667:
668: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
669: hr_utility.set_message_token('1', l_replaced_names(1));
670: hr_utility.raise_error;
671: else
672: l_dont_update := false;
673: --

Line 670: hr_utility.raise_error;

666: end if;
667:
668: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
669: hr_utility.set_message_token('1', l_replaced_names(1));
670: hr_utility.raise_error;
671: else
672: l_dont_update := false;
673: --
674: -- Note: not reinitialising l_message_rowids here because all

Line 700: hr_utility.set_location('ffdict.core_update_tl_rows',85);

696: (p_rowids => l_message_rowids
697: );
698:
699: if l_debug then
700: hr_utility.set_location('ffdict.core_update_tl_rows',85);
701: end if;
702:
703: x_got_error := true;
704: return;

Line 710: hr_utility.set_location('ffdict.core_update_tl_rows',90);

706: end if;
707: end if;
708:
709: if l_debug then
710: hr_utility.set_location('ffdict.core_update_tl_rows',90);
711: end if;
712:
713: ----------------------------------
714: -- Update the translated value. --

Line 742: hr_utility.set_location('ffdict.core_update_tl_rows',200);

738: --
739: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
740:
741: if l_debug then
742: hr_utility.set_location('ffdict.core_update_tl_rows',200);
743: end if;
744:
745: exception
746: when others then

Line 749: hr_utility.set_location('ffdict.core_update_tl_rows',500);

745: exception
746: when others then
747:
748: if l_debug then
749: hr_utility.set_location('ffdict.core_update_tl_rows',500);
750: end if;
751:
752: --
753: -- Reset the trigger code.

Line 921: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');

917: ,p_user_name => l_user_name
918: ,p_user_entity_id => x_user_entity_id
919: ,p_language => x_language
920: ) then
921: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
922: hr_utility.set_message_token('1', l_old_tl_name);
923: hr_utility.raise_error;
924: end if;
925: end if;

Line 922: hr_utility.set_message_token('1', l_old_tl_name);

918: ,p_user_entity_id => x_user_entity_id
919: ,p_language => x_language
920: ) then
921: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
922: hr_utility.set_message_token('1', l_old_tl_name);
923: hr_utility.raise_error;
924: end if;
925: end if;
926:

Line 923: hr_utility.raise_error;

919: ,p_language => x_language
920: ) then
921: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
922: hr_utility.set_message_token('1', l_old_tl_name);
923: hr_utility.raise_error;
924: end if;
925: end if;
926:
927: update ff_database_items_tl set

Line 1011: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');

1007: close csr_update_base;
1008:
1009: if l_update = 'Y' then
1010: if ffdict.dbi_used_in_formula(l_user_name, x_user_entity_id) then
1011: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
1012: hr_utility.set_message_token('1',x_user_name);
1013: hr_utility.raise_error;
1014: end if;
1015:

Line 1012: hr_utility.set_message_token('1',x_user_name);

1008:
1009: if l_update = 'Y' then
1010: if ffdict.dbi_used_in_formula(l_user_name, x_user_entity_id) then
1011: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
1012: hr_utility.set_message_token('1',x_user_name);
1013: hr_utility.raise_error;
1014: end if;
1015:
1016: update ff_database_items set

Line 1013: hr_utility.raise_error;

1009: if l_update = 'Y' then
1010: if ffdict.dbi_used_in_formula(l_user_name, x_user_entity_id) then
1011: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
1012: hr_utility.set_message_token('1',x_user_name);
1013: hr_utility.raise_error;
1014: end if;
1015:
1016: update ff_database_items set
1017: data_type = upper(x_data_type),

Line 1176: l_debug := hr_utility.debug_enabled;

1172: into l_userenv_lang
1173: from dual
1174: ;
1175:
1176: l_debug := hr_utility.debug_enabled;
1177:
1178: --
1179: -- Disable trigger code by setting ff_database_items_pkg.g_disable_triggers.
1180: --

Line 1185: hr_utility.trace('add_language:delete');

1181: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
1182: ff_database_items_pkg.g_disable_triggers := 'Y';
1183:
1184: if l_debug then
1185: hr_utility.trace('add_language:delete');
1186: end if;
1187:
1188: delete from ff_database_items_tl t
1189: where (t.user_name, t.user_entity_id) not in

Line 1205: hr_utility.trace('add_language:update');

1201: loop
1202: fetch csr_user_entity_ids bulk collect into ueids limit l_limit;
1203:
1204: if l_debug then
1205: hr_utility.trace('add_language:update');
1206: end if;
1207:
1208: forall i in ueids.first .. ueids.last
1209: update ff_database_items_tl t set (

Line 1242: hr_utility.trace('add_language:insert');

1238:
1239: commit;
1240:
1241: if l_debug then
1242: hr_utility.trace('add_language:insert');
1243: end if;
1244:
1245: forall i in ueids.first .. ueids.last
1246: insert into ff_database_items_tl (

Line 1349: l_debug := hr_utility.debug_enabled;

1345: ;
1346: --
1347: l_got_error boolean := false;
1348: begin
1349: l_debug := hr_utility.debug_enabled;
1350:
1351: --
1352: -- Set the language.
1353: --

Line 1361: hr_utility.trace('LANGUAGE: ' || l_language);

1357: l_language := x_language;
1358: end if;
1359:
1360: if l_debug then
1361: hr_utility.trace('LANGUAGE: ' || l_language);
1362: end if;
1363:
1364: --
1365: -- Find the database item.

Line 1383: hr_utility.trace

1379: -- The database item was not found so there is nothing to translate.
1380: --
1381: if not l_found then
1382: if l_debug then
1383: hr_utility.trace
1384: ('Could not find ' || l_user_name || ':' || x_legislation_code
1385: );
1386: end if;
1387: return;

Line 1418: hr_utility.trace('No update with name ' || l_translated_user_name);

1414: );
1415:
1416: if l_debug then
1417: if l_got_error then
1418: hr_utility.trace('No update with name ' || l_translated_user_name);
1419: else
1420: hr_utility.trace('Update with name ' || l_translated_user_name);
1421: end if;
1422: end if;

Line 1420: hr_utility.trace('Update with name ' || l_translated_user_name);

1416: if l_debug then
1417: if l_got_error then
1418: hr_utility.trace('No update with name ' || l_translated_user_name);
1419: else
1420: hr_utility.trace('Update with name ' || l_translated_user_name);
1421: end if;
1422: end if;
1423:
1424: exception