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

Line 100: hr_utility.set_location('Entering ' || g_package_name || l_proc_name, 10);

96: l_tab_count NUMBER;
97: l_proc_name VARCHAR2(50) := 'return_new_element_name';
98: l_pay_basis VARCHAR2(10) :='NULL';
99: BEGIN
100: hr_utility.set_location('Entering ' || g_package_name || l_proc_name, 10);
101:
102: -- is_script_run function will return TRUE, if GHR and Payroll were already
103: -- installed. Because this is the only way pqp_configuration_values table
104: -- will have any row of cv_information_category = 'PQP_FEDHR_ELEMENT'

Line 130: hr_utility.trace('In If - cache ');

126:
127: -- This portion will be executed second time and onwards employee re-runs the
128: -- RPA process.
129:
130: hr_utility.trace('In If - cache ');
131: FOR l_counter IN 1..l_tab_count LOOP
132: -- To make this search faster a Binary Search can be used, instead of liner
133: -- search. But linear search should be okay, as there will not be more than
134: -- 35 rows.

Line 136: hr_utility.trace(t_element_cross(l_counter).element_old_name);

132: -- To make this search faster a Binary Search can be used, instead of liner
133: -- search. But linear search should be okay, as there will not be more than
134: -- 35 rows.
135:
136: hr_utility.trace(t_element_cross(l_counter).element_old_name);
137: IF (t_element_cross(l_counter).element_old_name =
138: p_fedhr_element_name AND
139: t_element_cross(l_counter).pay_basis =
140: NVL(l_pay_basis, 'NULL'))

Line 142: hr_utility.trace('Element Name Hit');

138: p_fedhr_element_name AND
139: t_element_cross(l_counter).pay_basis =
140: NVL(l_pay_basis, 'NULL'))
141: THEN
142: hr_utility.trace('Element Name Hit');
143:
144: -- Fill in the variables with the details present in PL/SQL
145: -- table.
146:

Line 167: hr_utility.trace('In Else - Cursor');

163: --{
164: -- This portion will be executed for the first time when employee
165: -- runs the RPA process to fill in the cache.
166:
167: hr_utility.trace('In Else - Cursor');
168: -- modified the cursor to pick the elements (BSR esp) based on
169: -- Sal_Basis
170:
171: FOR c_pqp_config IN chk_pqp_config_tab (p_business_group_id =>

Line 195: hr_utility.trace (t_element_cross(l_counter).element_old_name);

191: t_element_cross(l_counter).element_new_name :=
192: c_pet.element_new_name ;
193: END LOOP;
194:
195: hr_utility.trace (t_element_cross(l_counter).element_old_name);
196:
197: IF(t_element_cross(l_counter).element_old_name =
198: p_fedhr_element_name AND
199: t_element_cross(l_counter).pay_basis =

Line 202: hr_utility.trace ('Element name found');

198: p_fedhr_element_name AND
199: t_element_cross(l_counter).pay_basis =
200: NVL(l_pay_basis, 'NULL'))
201: THEN
202: hr_utility.trace ('Element name found');
203: l_element_id :=t_element_cross(l_counter).element_type_id;
204: l_element_name:=t_element_cross(l_counter).element_new_name;
205: hr_utility.set_location('Element name is :'||l_element_name,15);
206: END IF;

Line 205: hr_utility.set_location('Element name is :'||l_element_name,15);

201: THEN
202: hr_utility.trace ('Element name found');
203: l_element_id :=t_element_cross(l_counter).element_type_id;
204: l_element_name:=t_element_cross(l_counter).element_new_name;
205: hr_utility.set_location('Element name is :'||l_element_name,15);
206: END IF;
207: END LOOP;
208: --}
209: END IF;

Line 212: hr_utility.set_message(800, 'HR_7465_PLK_NOT_ELGBLE_ELE_NME');

208: --}
209: END IF;
210: IF l_element_name IS NULL
211: THEN
212: hr_utility.set_message(800, 'HR_7465_PLK_NOT_ELGBLE_ELE_NME');
213: hr_utility.set_message_token('ELEMENT_NAME', p_fedhr_element_name);
214: hr_utility.raise_error;
215: -- RETURN(p_fedhr_element_name);
216: ELSE

Line 213: hr_utility.set_message_token('ELEMENT_NAME', p_fedhr_element_name);

209: END IF;
210: IF l_element_name IS NULL
211: THEN
212: hr_utility.set_message(800, 'HR_7465_PLK_NOT_ELGBLE_ELE_NME');
213: hr_utility.set_message_token('ELEMENT_NAME', p_fedhr_element_name);
214: hr_utility.raise_error;
215: -- RETURN(p_fedhr_element_name);
216: ELSE
217: RETURN l_element_name;

Line 214: hr_utility.raise_error;

210: IF l_element_name IS NULL
211: THEN
212: hr_utility.set_message(800, 'HR_7465_PLK_NOT_ELGBLE_ELE_NME');
213: hr_utility.set_message_token('ELEMENT_NAME', p_fedhr_element_name);
214: hr_utility.raise_error;
215: -- RETURN(p_fedhr_element_name);
216: ELSE
217: RETURN l_element_name;
218: END IF;

Line 225: hr_utility.set_location ('Leaving ' || g_package_name || l_proc_name, 100);

221: -- {
222: RETURN p_fedhr_element_name;
223: -- }
224: END IF;
225: hr_utility.set_location ('Leaving ' || g_package_name || l_proc_name, 100);
226: END;
227: -- ***************************************************************************
228: --
229: -- ----------------------------------------------------------------------------

Line 285: hr_utility.set_location('Entering ' || g_package_name || l_proc_name, 10);

281:
282: l_element_name pay_element_types_f.element_name%TYPE;
283: l_proc_name VARCHAR2(50) := 'return_new_element_name';
284: BEGIN
285: hr_utility.set_location('Entering ' || g_package_name || l_proc_name, 10);
286:
287: IF (pqp_fedhr_uspay_int_utils.is_script_run
288: (p_business_group_id => p_business_group_id,
289: p_fedhr_element_name => 'Basic Salary Rate') = TRUE)

Line 306: hr_utility.set_location ('Leaving ' || g_package_name || l_proc_name, 100);

302: -- {
303: RETURN NULL;
304: -- }
305: END IF;
306: hr_utility.set_location ('Leaving ' || g_package_name || l_proc_name, 100);
307: END;
308: -- ***************************************************************************
309: --
310: -- ----------------------------------------------------------------------------

Line 377: hr_utility.set_location('Entering ' || g_package_name || l_proc_name, 10);

373: l_element_name pay_element_types_f.element_name%TYPE;
374: l_proc_name VARCHAR2(50) := 'return_new_element_name';
375: l_sal_basis_id NUMBER;
376: BEGIN
377: hr_utility.set_location('Entering ' || g_package_name || l_proc_name, 10);
378:
379: IF (pqp_fedhr_uspay_int_utils.is_script_run
380: (p_business_group_id => p_business_group_id,
381: p_fedhr_element_name => 'Basic Salary Rate') = TRUE)

Line 405: hr_utility.set_location ('Leaving ' || g_package_name || l_proc_name, 100);

401: -- {
402: RETURN NULL;
403: -- }
404: END IF;
405: hr_utility.set_location ('Leaving ' || g_package_name || l_proc_name, 100);
406: END;
407: -- ***************************************************************************
408: --
409: -- ----------------------------------------------------------------------------

Line 454: hr_utility.set_location ('Entering ' || g_package_name || l_proc_name, 10);

450: l_info_category pqp_configuration_values.pcv_information_category%TYPE;
451: l_proc_name VARCHAR2(50) := 'is_script_run';
452:
453: BEGIN
454: hr_utility.set_location ('Entering ' || g_package_name || l_proc_name, 10);
455:
456: -- The following loop gets the count of rows present in pqp_configuration_values
457: -- table.
458: l_info_category := NULL;

Line 462: hr_utility.trace('In cursor loop');

458: l_info_category := NULL;
459: FOR c_pqp_config IN chk_pqp_config_tab
460: LOOP
461: l_info_category := c_pqp_config.pcv_information_category;
462: hr_utility.trace('In cursor loop');
463: END LOOP;
464:
465: -- If count > 0, that means some rows were present in pqp_configuration_Values
466: -- table. Therefore this function returns TRUE.

Line 470: hr_utility.trace('True');

466: -- table. Therefore this function returns TRUE.
467:
468: IF l_info_category IS NOT NULL
469: THEN
470: hr_utility.trace('True');
471: RETURN TRUE;
472: ELSE
473: hr_utility.trace('False');
474: RETURN FALSE;

Line 473: hr_utility.trace('False');

469: THEN
470: hr_utility.trace('True');
471: RETURN TRUE;
472: ELSE
473: hr_utility.trace('False');
474: RETURN FALSE;
475: END IF;
476: hr_utility.set_location ('Leaving ' || g_package_name || l_proc_name, 100);
477: END;

Line 476: hr_utility.set_location ('Leaving ' || g_package_name || l_proc_name, 100);

472: ELSE
473: hr_utility.trace('False');
474: RETURN FALSE;
475: END IF;
476: hr_utility.set_location ('Leaving ' || g_package_name || l_proc_name, 100);
477: END;
478:
479: -- ***************************************************************************
480: --

Line 722: hr_utility.set_location('Entering ' || g_package_name || l_proc_name, 10);

718: l_tab_count NUMBER;
719: l_proc_name VARCHAR2(50) := 'return_old_element_name';
720: l_pay_basis VARCHAR2(10) := 'NULL';
721: BEGIN
722: hr_utility.set_location('Entering ' || g_package_name || l_proc_name, 10);
723:
724: FOR chk_element_type_rec IN chk_element_type_id
725: LOOP
726: l_element_type_id := chk_element_type_rec.element_type_id;

Line 752: hr_utility.trace('In If - cache ');

748:
749: -- This portion will be executed second time and onwards employee re-runs the
750: -- RPA process.
751:
752: hr_utility.trace('In If - cache ');
753: FOR l_counter IN 1..l_tab_count LOOP
754: -- To make this search faster a Binary Search can be used, instead of liner
755: -- search. But linear search should be okay, as there will not be more than
756: -- 35 rows.

Line 758: hr_utility.trace(t_element_cross(l_counter).element_new_name);

754: -- To make this search faster a Binary Search can be used, instead of liner
755: -- search. But linear search should be okay, as there will not be more than
756: -- 35 rows.
757:
758: hr_utility.trace(t_element_cross(l_counter).element_new_name);
759: IF (t_element_cross(l_counter).element_new_name =
760: p_agency_element_name )
761: THEN
762: hr_utility.trace('New Element Name Hit');

Line 762: hr_utility.trace('New Element Name Hit');

758: hr_utility.trace(t_element_cross(l_counter).element_new_name);
759: IF (t_element_cross(l_counter).element_new_name =
760: p_agency_element_name )
761: THEN
762: hr_utility.trace('New Element Name Hit');
763:
764: -- Fill in the variables with the details present in PL/SQL
765: -- table.
766:

Line 787: hr_utility.trace('In Else - Cursor');

783: --{
784: -- This portion will be executed for the first time when employee
785: -- runs the RPA process to fill in the cache.
786:
787: hr_utility.trace('In Else - Cursor');
788: -- modified the cursor to pick the elements (BSR esp) based on
789: -- Sal_Basis
790:
791: FOR c_pqp_config IN chk_pqp_config_tab (p_business_group_id => p_business_group_id )

Line 805: hr_utility.trace (t_element_cross(l_counter).element_old_name);

801: -- Filling the pl/sql table.
802: t_element_cross(l_counter).element_new_name :=
803: p_agency_element_name ;
804:
805: hr_utility.trace (t_element_cross(l_counter).element_old_name);
806:
807: IF (t_element_cross(l_counter).element_new_name =
808: p_agency_element_name )
809: THEN

Line 810: hr_utility.trace ('Element name found');

806:
807: IF (t_element_cross(l_counter).element_new_name =
808: p_agency_element_name )
809: THEN
810: hr_utility.trace ('Element name found');
811: l_element_id :=t_element_cross(l_counter).element_type_id;
812: l_element_name:=t_element_cross(l_counter).element_old_name;
813: hr_utility.set_location('Element name is :'||l_element_name,15);
814: END IF;

Line 813: hr_utility.set_location('Element name is :'||l_element_name,15);

809: THEN
810: hr_utility.trace ('Element name found');
811: l_element_id :=t_element_cross(l_counter).element_type_id;
812: l_element_name:=t_element_cross(l_counter).element_old_name;
813: hr_utility.set_location('Element name is :'||l_element_name,15);
814: END IF;
815: END LOOP;
816: --}
817: END IF;

Line 830: hr_utility.set_location ('Leaving ' || g_package_name || l_proc_name, 100);

826: -- {
827: RETURN p_agency_element_name;
828: -- }
829: END IF;
830: hr_utility.set_location ('Leaving ' || g_package_name || l_proc_name, 100);
831: END return_old_element_name;
832: END pqp_fedhr_uspay_int_utils;