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

Line 20: hr_utility.set_location('gbstrdbi.insert_route_context_usages', 1);

16: p_context_id in number,
17: p_sequence_no in number
18: ) is
19: begin -- [
20: hr_utility.set_location('gbstrdbi.insert_route_context_usages', 1);
21: insert into ff_route_context_usages
22: (route_id,
23: context_id,
24: sequence_no)

Line 39: hr_utility.set_location('gbstrdbi.insert_user_entity', 1);

35: p_user_entity_name in varchar2,
36: p_description in varchar2
37: ) is
38: begin -- [
39: hr_utility.set_location('gbstrdbi.insert_user_entity', 1);
40: insert into ff_user_entities
41: (user_entity_id,
42: business_group_id,
43: legislation_code,

Line 83: hr_utility.set_location('gbstrdbi.insert_curr_database_item', 1);

79: p_data_type in varchar2,
80: p_null_allowed_flag in varchar2
81: ) is
82: begin -- [
83: hr_utility.set_location('gbstrdbi.insert_curr_database_item', 1);
84: hr_utility.trace ('creating : ' || p_user_name);
85: insert into ff_database_items (
86: user_name,
87: user_entity_id,

Line 84: hr_utility.trace ('creating : ' || p_user_name);

80: p_null_allowed_flag in varchar2
81: ) is
82: begin -- [
83: hr_utility.set_location('gbstrdbi.insert_curr_database_item', 1);
84: hr_utility.trace ('creating : ' || p_user_name);
85: insert into ff_database_items (
86: user_name,
87: user_entity_id,
88: data_type,

Line 124: hr_utility.set_location('gbstrdbi.insert_database_item', 1);

120: p_data_type in varchar2,
121: p_null_allowed_flag in varchar2
122: ) is
123: begin -- [
124: hr_utility.set_location('gbstrdbi.insert_database_item', 1);
125: hr_utility.trace ('creating : ' || p_user_name);
126: insert into ff_database_items (
127: user_name,
128: user_entity_id,

Line 125: hr_utility.trace ('creating : ' || p_user_name);

121: p_null_allowed_flag in varchar2
122: ) is
123: begin -- [
124: hr_utility.set_location('gbstrdbi.insert_database_item', 1);
125: hr_utility.trace ('creating : ' || p_user_name);
126: insert into ff_database_items (
127: user_name,
128: user_entity_id,
129: data_type,

Line 162: hr_utility.trace ('creating route : ' || p_route_name);

158: p_description in varchar2,
159: p_text in varchar2
160: ) is
161: begin -- [
162: hr_utility.trace ('creating route : ' || p_route_name);
163: hr_utility.set_location('gbstrdbi.insert_route', 1);
164: insert into ff_routes
165: (route_id,
166: route_name,

Line 163: hr_utility.set_location('gbstrdbi.insert_route', 1);

159: p_text in varchar2
160: ) is
161: begin -- [
162: hr_utility.trace ('creating route : ' || p_route_name);
163: hr_utility.set_location('gbstrdbi.insert_route', 1);
164: insert into ff_routes
165: (route_id,
166: route_name,
167: user_defined_flag,

Line 408: hr_utility.trace('setting the route text for EMPLOYER_ARCHIVE');

404: where context_name = 'JURISDICTION_CODE';
405:
406: BEGIN
407:
408: hr_utility.trace('setting the route text for EMPLOYER_ARCHIVE');
409:
410: -- define the employer archive route
411: l_text :=
412: 'ff_archive_item_contexts con2,

Line 424: hr_utility.trace('selecting the route_id for EMPLOYER_ARCHIVE');

420: and con2.context_id = fc2.context_id
421: and ltrim(rtrim(con2.context)) = to_char(&B2)
422: /* 2nd context of tax_unit_id */';
423:
424: hr_utility.trace('selecting the route_id for EMPLOYER_ARCHIVE');
425:
426: select route_id into l_route_id
427: from ff_routes where route_name = 'EMPLOYER_ARCHIVE';
428:

Line 429: hr_utility.trace('updating the route text for EMPLOYER_ARCHIVE');

425:
426: select route_id into l_route_id
427: from ff_routes where route_name = 'EMPLOYER_ARCHIVE';
428:
429: hr_utility.trace('updating the route text for EMPLOYER_ARCHIVE');
430:
431: update ff_routes
432: set text = l_text
433: where route_id = l_route_id;

Line 435: hr_utility.trace('deleting ff_route_context_usages for EMPLOYER_ARCHIVE');

431: update ff_routes
432: set text = l_text
433: where route_id = l_route_id;
434:
435: hr_utility.trace('deleting ff_route_context_usages for EMPLOYER_ARCHIVE');
436:
437: /* delete ff_route_context_usages
438: where route_id = l_route_id; */
439:

Line 444: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_ARCHIVE');

440: open c_check_context(l_route_id,l_tax_unit_context_id);
441: fetch c_check_context into l_exists;
442: if c_check_context%NOTFOUND then
443:
444: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_ARCHIVE');
445:
446: insert into ff_route_context_usages
447: (route_id,
448: context_id,

Line 454: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_ARCHIVE');

450: values (l_route_id,
451: l_payroll_action_context_id,
452: 1);
453:
454: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_ARCHIVE');
455:
456: insert into ff_route_context_usages
457: (route_id,
458: context_id,

Line 468: hr_utility.trace('inserting ff_routes for EMPLOYER_ARCHIVE');

464: end if;
465: close c_check_context;
466:
467: EXCEPTION WHEN NO_DATA_FOUND THEN
468: hr_utility.trace('inserting ff_routes for EMPLOYER_ARCHIVE');
469:
470: insert into ff_routes
471: (route_id,
472: route_name,

Line 493: hr_utility.trace('inserting ff_route_parameters for EMPLOYER_ARCHIVE');

489: 0,
490: sysdate);
491:
492: -- define the route_parameter
493: hr_utility.trace('inserting ff_route_parameters for EMPLOYER_ARCHIVE');
494:
495: insert into ff_route_parameters
496: (ROUTE_PARAMETER_ID,
497: ROUTE_ID,

Line 509: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_ARCHIVE');

505: 1 from dual;
506:
507: -- define the route_context usage
508:
509: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_ARCHIVE');
510:
511: insert into ff_route_context_usages
512: (route_id,
513: context_id,

Line 520: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_ARCHIVE');

516: l_payroll_action_context_id,
517: 1
518: from dual;
519:
520: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_ARCHIVE');
521:
522: insert into ff_route_context_usages
523: (route_id,
524: context_id,

Line 764: hr_utility.trace('setting route text for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');

760: -- mag reports will be setting up the assignment_action_id
761: -- context as that of year end pre-process but the payroll_
762: -- action_id that of the mag report.
763:
764: hr_utility.trace('setting route text for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');
765:
766: l_text :=
767: 'ff_archive_item_contexts con2,
768: ff_contexts fc2,

Line 779: hr_utility.trace('selecting route id for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');

775: and con2.context_id = fc2.context_id
776: and ltrim(rtrim(con2.context)) = to_char(&B2)
777: /* 2nd context of tax_unit_id */';
778:
779: hr_utility.trace('selecting route id for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');
780:
781: select route_id into l_route_id
782: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE';
783:

Line 784: hr_utility.trace('updating ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');

780:
781: select route_id into l_route_id
782: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE';
783:
784: hr_utility.trace('updating ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');
785:
786: update ff_routes
787: set text = l_text
788: where route_id = l_route_id;

Line 790: hr_utility.trace('deleting ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');

786: update ff_routes
787: set text = l_text
788: where route_id = l_route_id;
789:
790: hr_utility.trace('deleting ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');
791:
792: /* delete ff_route_context_usages
793: where route_id = l_route_id; */
794:

Line 887: hr_utility.trace('setting route text for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');

883: -- mag reports will be setting up the assignment_action_id
884: -- context as that of year end pre-process but the payroll_
885: -- action_id that of the mag report.
886:
887: hr_utility.trace('setting route text for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
888:
889: l_text :=
890: 'ff_archive_item_contexts con2,
891: ff_contexts fc2,

Line 902: hr_utility.trace('selecting route_id for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');

898: and con2.context_id = fc2.context_id
899: and ltrim(rtrim(con2.context)) = to_char(&B2)
900: /* 2nd context of tax_unit_id */';
901:
902: hr_utility.trace('selecting route_id for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
903:
904: select route_id into l_route_id
905: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER';
906:

Line 907: hr_utility.trace('updating route_text for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');

903:
904: select route_id into l_route_id
905: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER';
906:
907: hr_utility.trace('updating route_text for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
908:
909:
910: update ff_routes
911: set text = l_text

Line 914: hr_utility.trace('deleting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');

910: update ff_routes
911: set text = l_text
912: where route_id = l_route_id;
913:
914: hr_utility.trace('deleting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
915:
916: /* delete ff_route_context_usages
917: where route_id = l_route_id; */
918:

Line 924: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');

920: fetch c_check_context into l_exists;
921: if c_check_context%NOTFOUND then
922:
923:
924: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
925:
926: insert into ff_route_context_usages
927: (route_id,
928: context_id,

Line 934: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');

930: values (l_route_id,
931: l_payroll_action_context_id,
932: 1);
933:
934: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
935:
936: insert into ff_route_context_usages
937: (route_id,
938: context_id,

Line 948: hr_utility.trace('inserting ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');

944: close c_check_context;
945:
946:
947: EXCEPTION WHEN NO_DATA_FOUND THEN
948: hr_utility.trace('inserting ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
949:
950: insert into ff_routes
951: (route_id,
952: route_name,

Line 1018: hr_utility.trace('setting route text for EMPLOYER_TAX_UNIT_ARCHIVE');

1014: -- mag reports will be setting up the assignment_action_id
1015: -- context as that of year end pre-process but the payroll_
1016: -- action_id that of the mag report.
1017:
1018: hr_utility.trace('setting route text for EMPLOYER_TAX_UNIT_ARCHIVE');
1019:
1020: l_text :=
1021: 'ff_archive_item_contexts con2,
1022: ff_contexts fc2,

Line 1033: hr_utility.trace('selecting route_id for EMPLOYER_TAX_UNIT_ARCHIVE');

1029: and con2.context_id = fc2.context_id
1030: and ltrim(rtrim(con2.context)) = to_char(&B2)
1031: /* 2nd context of tax_unit_id */';
1032:
1033: hr_utility.trace('selecting route_id for EMPLOYER_TAX_UNIT_ARCHIVE');
1034:
1035: select route_id into l_route_id
1036: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE';
1037:

Line 1038: hr_utility.trace('updating route_text for EMPLOYER_TAX_UNIT_ARCHIVE');

1034:
1035: select route_id into l_route_id
1036: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE';
1037:
1038: hr_utility.trace('updating route_text for EMPLOYER_TAX_UNIT_ARCHIVE');
1039:
1040: update ff_routes
1041: set text = l_text
1042: where route_id = l_route_id;

Line 1044: hr_utility.trace('deleting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE');

1040: update ff_routes
1041: set text = l_text
1042: where route_id = l_route_id;
1043:
1044: hr_utility.trace('deleting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE');
1045:
1046: /* delete ff_route_context_usages
1047: where route_id = l_route_id; */
1048:

Line 1049: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE');

1045:
1046: /* delete ff_route_context_usages
1047: where route_id = l_route_id; */
1048:
1049: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE');
1050: open c_check_context(l_route_id,l_tax_unit_context_id);
1051: fetch c_check_context into l_exists;
1052: if c_check_context%NOTFOUND then
1053:

Line 1063: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE');

1059: values (l_route_id,
1060: l_payroll_action_context_id,
1061: 1);
1062:
1063: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE');
1064:
1065: insert into ff_route_context_usages
1066: (route_id,
1067: context_id,

Line 2707: -- hr_utility.trace_on(null,'ORACLE');

2703: and pdb.defined_balance_id = p_defined_balance_id;
2704:
2705: begin
2706:
2707: -- hr_utility.trace_on(null,'ORACLE');
2708:
2709: hr_utility.trace('getting route ids');
2710:
2711: select route_id into l_er_archive_route_id

Line 2709: hr_utility.trace('getting route ids');

2705: begin
2706:
2707: -- hr_utility.trace_on(null,'ORACLE');
2708:
2709: hr_utility.trace('getting route ids');
2710:
2711: select route_id into l_er_archive_route_id
2712: from ff_routes where
2713: route_name = 'EMPLOYER_ARCHIVE';

Line 2794: hr_utility.trace('got route');

2790: from ff_routes where
2791: route_name = 'ASSIGNMENT_GRE_PSD_JD_ARCHIVE';
2792: /* Changes for bug 11712075 - End*/
2793:
2794: hr_utility.trace('got route');
2795:
2796: open get_live_db_details;
2797: fetch get_live_db_details into
2798: l_ue_notfound_allowed_flag,

Line 2809: hr_utility.trace('Live database item does not exist : ' ||

2805:
2806: if get_live_db_details%NOTFOUND then
2807:
2808: close get_live_db_details;
2809: hr_utility.trace('Live database item does not exist : ' ||
2810: SUBSTR(p_item_name,3,LENGTH(p_item_name)-2));
2811: raise_application_error(-20008,'Live database item does not exist : '
2812: ||SUBSTR(p_item_name,3,LENGTH(p_item_name)-2));
2813:

Line 2815: hr_utility.trace('processing database item : ' || p_item_name);

2811: raise_application_error(-20008,'Live database item does not exist : '
2812: ||SUBSTR(p_item_name,3,LENGTH(p_item_name)-2));
2813:
2814: else
2815: hr_utility.trace('processing database item : ' || p_item_name);
2816:
2817: open get_context;
2818: loop
2819: fetch get_context into l_context_name,

Line 2826: hr_utility.trace ('Assignment action id context found');

2822:
2823: exit when get_context%NOTFOUND;
2824: if l_context_name = 'ASSIGNMENT_ACTION_ID' or
2825: l_context_name = 'ASSIGNMENT_ID' then
2826: hr_utility.trace ('Assignment action id context found');
2827: l_found_asg_action := TRUE;
2828: elsif l_context_name = 'TAX_UNIT_ID' then
2829: hr_utility.trace ('Tax Unit id context found');
2830: l_found_tax_unit := TRUE;

Line 2829: hr_utility.trace ('Tax Unit id context found');

2825: l_context_name = 'ASSIGNMENT_ID' then
2826: hr_utility.trace ('Assignment action id context found');
2827: l_found_asg_action := TRUE;
2828: elsif l_context_name = 'TAX_UNIT_ID' then
2829: hr_utility.trace ('Tax Unit id context found');
2830: l_found_tax_unit := TRUE;
2831: elsif l_context_name = 'JURISDICTION_CODE' then
2832: hr_utility.trace ('Jurisdiction code context found');
2833: l_found_jursd := TRUE;

Line 2832: hr_utility.trace ('Jurisdiction code context found');

2828: elsif l_context_name = 'TAX_UNIT_ID' then
2829: hr_utility.trace ('Tax Unit id context found');
2830: l_found_tax_unit := TRUE;
2831: elsif l_context_name = 'JURISDICTION_CODE' then
2832: hr_utility.trace ('Jurisdiction code context found');
2833: l_found_jursd := TRUE;
2834: end if;
2835: /*
2836: l_count := l_count + 1;

Line 2955: hr_utility.trace('getting route parameter id for ' || to_char(l_route_id));

2951:
2952: end if;
2953:
2954:
2955: hr_utility.trace('getting route parameter id for ' || to_char(l_route_id));
2956:
2957: select ROUTE_PARAMETER_ID into l_route_parameter_id
2958: from ff_route_parameters
2959: where parameter_name = 'User Entity ID'

Line 2962: hr_utility.trace('got route parameter id');

2958: from ff_route_parameters
2959: where parameter_name = 'User Entity ID'
2960: and route_id = l_route_id;
2961:
2962: hr_utility.trace('got route parameter id');
2963:
2964:
2965: open get_user_entity;
2966: fetch get_user_entity into l_user_entity_id,

Line 2973: hr_utility.trace ('Existing Route id : '||

2969:
2970: /* Update the route id if required */
2971: if l_route_id <> l_exist_route_id then
2972:
2973: hr_utility.trace ('Existing Route id : '||
2974: to_char(l_exist_route_id));
2975: hr_utility.trace ('New Route id : '||
2976: to_char(l_route_id));
2977: hr_utility.trace ('User Entity id : '||

Line 2975: hr_utility.trace ('New Route id : '||

2971: if l_route_id <> l_exist_route_id then
2972:
2973: hr_utility.trace ('Existing Route id : '||
2974: to_char(l_exist_route_id));
2975: hr_utility.trace ('New Route id : '||
2976: to_char(l_route_id));
2977: hr_utility.trace ('User Entity id : '||
2978: to_char(l_user_entity_id));
2979: update ff_user_entities

Line 2977: hr_utility.trace ('User Entity id : '||

2973: hr_utility.trace ('Existing Route id : '||
2974: to_char(l_exist_route_id));
2975: hr_utility.trace ('New Route id : '||
2976: to_char(l_route_id));
2977: hr_utility.trace ('User Entity id : '||
2978: to_char(l_user_entity_id));
2979: update ff_user_entities
2980: set route_id = l_route_id
2981: where user_entity_id = l_user_entity_id;