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

Line 118: hr_utility.trace('User Entity table count > 0 '||ltr_user_entity_table.COUNT);

114: lv_return_value := NULL;
115:
116: IF ltr_user_entity_table.COUNT > 0
117: THEN
118: hr_utility.trace('User Entity table count > 0 '||ltr_user_entity_table.COUNT);
119: FOR j IN ltr_user_entity_table.FIRST .. ltr_user_entity_table.LAST
120: LOOP
121: IF ltr_user_entity_table (j).user_entity_name =
122: p_user_entity_name

Line 134: hr_utility.trace('User Entity table count '|| ltr_user_entity_table.COUNT);

130: ELSIF ltr_user_entity_table.COUNT = 0 OR lv_user_entity_id = NULL
131: */
132: END IF;
133:
134: hr_utility.trace('User Entity table count '|| ltr_user_entity_table.COUNT);
135: hr_utility.trace(' lv_user_entity_id '|| lv_user_entity_id);
136:
137: IF ltr_user_entity_table.COUNT = 0 OR lv_user_entity_id IS NULL THEN
138: OPEN c_get_user_entity_name (p_user_entity_name);

Line 135: hr_utility.trace(' lv_user_entity_id '|| lv_user_entity_id);

131: */
132: END IF;
133:
134: hr_utility.trace('User Entity table count '|| ltr_user_entity_table.COUNT);
135: hr_utility.trace(' lv_user_entity_id '|| lv_user_entity_id);
136:
137: IF ltr_user_entity_table.COUNT = 0 OR lv_user_entity_id IS NULL THEN
138: OPEN c_get_user_entity_name (p_user_entity_name);
139:

Line 152: hr_utility.trace(' lv_user_entity_id '|| lv_user_entity_id);

148: ltr_user_entity_table (lv_table_count).user_entity_id :=
149: lv_user_entity_id;
150: END IF;
151:
152: hr_utility.trace(' lv_user_entity_id '|| lv_user_entity_id);
153: hr_utility.trace(' p_action_id '|| p_action_id);
154: hr_utility.trace(' p_tax_unit_id '|| p_tax_unit_id);
155: hr_utility.trace(' lv_tax_context_id '|| lv_tax_context_id);
156:

Line 153: hr_utility.trace(' p_action_id '|| p_action_id);

149: lv_user_entity_id;
150: END IF;
151:
152: hr_utility.trace(' lv_user_entity_id '|| lv_user_entity_id);
153: hr_utility.trace(' p_action_id '|| p_action_id);
154: hr_utility.trace(' p_tax_unit_id '|| p_tax_unit_id);
155: hr_utility.trace(' lv_tax_context_id '|| lv_tax_context_id);
156:
157: IF p_jurisdiction_code IS NULL

Line 154: hr_utility.trace(' p_tax_unit_id '|| p_tax_unit_id);

150: END IF;
151:
152: hr_utility.trace(' lv_user_entity_id '|| lv_user_entity_id);
153: hr_utility.trace(' p_action_id '|| p_action_id);
154: hr_utility.trace(' p_tax_unit_id '|| p_tax_unit_id);
155: hr_utility.trace(' lv_tax_context_id '|| lv_tax_context_id);
156:
157: IF p_jurisdiction_code IS NULL
158: THEN

Line 155: hr_utility.trace(' lv_tax_context_id '|| lv_tax_context_id);

151:
152: hr_utility.trace(' lv_user_entity_id '|| lv_user_entity_id);
153: hr_utility.trace(' p_action_id '|| p_action_id);
154: hr_utility.trace(' p_tax_unit_id '|| p_tax_unit_id);
155: hr_utility.trace(' lv_tax_context_id '|| lv_tax_context_id);
156:
157: IF p_jurisdiction_code IS NULL
158: THEN
159: hr_utility.trace(' Jurisdiction is NULL');

Line 159: hr_utility.trace(' Jurisdiction is NULL');

155: hr_utility.trace(' lv_tax_context_id '|| lv_tax_context_id);
156:
157: IF p_jurisdiction_code IS NULL
158: THEN
159: hr_utility.trace(' Jurisdiction is NULL');
160: hr_utility.trace(' Jurisdiction is NULL, lv_user_entity_id '|| lv_user_entity_id);
161:
162: OPEN c_get_value (lv_user_entity_id,
163: p_action_id,

Line 160: hr_utility.trace(' Jurisdiction is NULL, lv_user_entity_id '|| lv_user_entity_id);

156:
157: IF p_jurisdiction_code IS NULL
158: THEN
159: hr_utility.trace(' Jurisdiction is NULL');
160: hr_utility.trace(' Jurisdiction is NULL, lv_user_entity_id '|| lv_user_entity_id);
161:
162: OPEN c_get_value (lv_user_entity_id,
163: p_action_id,
164: p_tax_unit_id,

Line 171: hr_utility.trace(' lv_return_value '|| lv_return_value);

167:
168: FETCH c_get_value
169: INTO lv_return_value;
170:
171: hr_utility.trace(' lv_return_value '|| lv_return_value);
172:
173: CLOSE c_get_value;
174: ELSE
175: hr_utility.trace(' Jurisdiction is Not NULL, p_jurisdiction_code '||p_jurisdiction_code);

Line 175: hr_utility.trace(' Jurisdiction is Not NULL, p_jurisdiction_code '||p_jurisdiction_code);

171: hr_utility.trace(' lv_return_value '|| lv_return_value);
172:
173: CLOSE c_get_value;
174: ELSE
175: hr_utility.trace(' Jurisdiction is Not NULL, p_jurisdiction_code '||p_jurisdiction_code);
176: OPEN c_get_value_with_jc (lv_user_entity_id,
177: p_action_id,
178: p_tax_unit_id,
179: p_jurisdiction_code