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

Line 100: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);

96: BEGIN
97: --
98: -- Get the route id. Create a route if necessary.
99: --
100: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
101: hr_utility.trace ('p_name: ' || p_name);
102: hr_utility.trace ('Legislation_code: ' || p_legislation_code);
103: hr_utility.trace ('p_description: ' || p_description);
104: hr_utility.trace ('p_data_type: ' || p_data_type);

Line 101: hr_utility.trace ('p_name: ' || p_name);

97: --
98: -- Get the route id. Create a route if necessary.
99: --
100: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
101: hr_utility.trace ('p_name: ' || p_name);
102: hr_utility.trace ('Legislation_code: ' || p_legislation_code);
103: hr_utility.trace ('p_description: ' || p_description);
104: hr_utility.trace ('p_data_type: ' || p_data_type);
105: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);

Line 102: hr_utility.trace ('Legislation_code: ' || p_legislation_code);

98: -- Get the route id. Create a route if necessary.
99: --
100: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
101: hr_utility.trace ('p_name: ' || p_name);
102: hr_utility.trace ('Legislation_code: ' || p_legislation_code);
103: hr_utility.trace ('p_description: ' || p_description);
104: hr_utility.trace ('p_data_type: ' || p_data_type);
105: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
106: hr_utility.trace ('p_definition_text: ' || p_definition_text);

Line 103: hr_utility.trace ('p_description: ' || p_description);

99: --
100: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
101: hr_utility.trace ('p_name: ' || p_name);
102: hr_utility.trace ('Legislation_code: ' || p_legislation_code);
103: hr_utility.trace ('p_description: ' || p_description);
104: hr_utility.trace ('p_data_type: ' || p_data_type);
105: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
106: hr_utility.trace ('p_definition_text: ' || p_definition_text);
107: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);

Line 104: hr_utility.trace ('p_data_type: ' || p_data_type);

100: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
101: hr_utility.trace ('p_name: ' || p_name);
102: hr_utility.trace ('Legislation_code: ' || p_legislation_code);
103: hr_utility.trace ('p_description: ' || p_description);
104: hr_utility.trace ('p_data_type: ' || p_data_type);
105: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
106: hr_utility.trace ('p_definition_text: ' || p_definition_text);
107: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
108: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);

Line 105: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);

101: hr_utility.trace ('p_name: ' || p_name);
102: hr_utility.trace ('Legislation_code: ' || p_legislation_code);
103: hr_utility.trace ('p_description: ' || p_description);
104: hr_utility.trace ('p_data_type: ' || p_data_type);
105: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
106: hr_utility.trace ('p_definition_text: ' || p_definition_text);
107: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
108: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
109: hr_utility.trace ('p_route_name: ' || p_route_name);

Line 106: hr_utility.trace ('p_definition_text: ' || p_definition_text);

102: hr_utility.trace ('Legislation_code: ' || p_legislation_code);
103: hr_utility.trace ('p_description: ' || p_description);
104: hr_utility.trace ('p_data_type: ' || p_data_type);
105: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
106: hr_utility.trace ('p_definition_text: ' || p_definition_text);
107: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
108: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
109: hr_utility.trace ('p_route_name: ' || p_route_name);
110: hr_utility.trace ('p_route_description: ' || p_route_description);

Line 107: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);

103: hr_utility.trace ('p_description: ' || p_description);
104: hr_utility.trace ('p_data_type: ' || p_data_type);
105: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
106: hr_utility.trace ('p_definition_text: ' || p_definition_text);
107: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
108: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
109: hr_utility.trace ('p_route_name: ' || p_route_name);
110: hr_utility.trace ('p_route_description: ' || p_route_description);
111: hr_utility.trace ('p_route_text: ' || p_route_text);

Line 108: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);

104: hr_utility.trace ('p_data_type: ' || p_data_type);
105: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
106: hr_utility.trace ('p_definition_text: ' || p_definition_text);
107: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
108: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
109: hr_utility.trace ('p_route_name: ' || p_route_name);
110: hr_utility.trace ('p_route_description: ' || p_route_description);
111: hr_utility.trace ('p_route_text: ' || p_route_text);
112: hr_utility.trace ('p_context_name1: ' || p_context_name1);

Line 109: hr_utility.trace ('p_route_name: ' || p_route_name);

105: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
106: hr_utility.trace ('p_definition_text: ' || p_definition_text);
107: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
108: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
109: hr_utility.trace ('p_route_name: ' || p_route_name);
110: hr_utility.trace ('p_route_description: ' || p_route_description);
111: hr_utility.trace ('p_route_text: ' || p_route_text);
112: hr_utility.trace ('p_context_name1: ' || p_context_name1);
113: hr_utility.trace ('p_context_name2: ' || p_context_name2);

Line 110: hr_utility.trace ('p_route_description: ' || p_route_description);

106: hr_utility.trace ('p_definition_text: ' || p_definition_text);
107: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
108: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
109: hr_utility.trace ('p_route_name: ' || p_route_name);
110: hr_utility.trace ('p_route_description: ' || p_route_description);
111: hr_utility.trace ('p_route_text: ' || p_route_text);
112: hr_utility.trace ('p_context_name1: ' || p_context_name1);
113: hr_utility.trace ('p_context_name2: ' || p_context_name2);
114: --

Line 111: hr_utility.trace ('p_route_text: ' || p_route_text);

107: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
108: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
109: hr_utility.trace ('p_route_name: ' || p_route_name);
110: hr_utility.trace ('p_route_description: ' || p_route_description);
111: hr_utility.trace ('p_route_text: ' || p_route_text);
112: hr_utility.trace ('p_context_name1: ' || p_context_name1);
113: hr_utility.trace ('p_context_name2: ' || p_context_name2);
114: --
115: BEGIN

Line 112: hr_utility.trace ('p_context_name1: ' || p_context_name1);

108: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
109: hr_utility.trace ('p_route_name: ' || p_route_name);
110: hr_utility.trace ('p_route_description: ' || p_route_description);
111: hr_utility.trace ('p_route_text: ' || p_route_text);
112: hr_utility.trace ('p_context_name1: ' || p_context_name1);
113: hr_utility.trace ('p_context_name2: ' || p_context_name2);
114: --
115: BEGIN
116: --

Line 113: hr_utility.trace ('p_context_name2: ' || p_context_name2);

109: hr_utility.trace ('p_route_name: ' || p_route_name);
110: hr_utility.trace ('p_route_description: ' || p_route_description);
111: hr_utility.trace ('p_route_text: ' || p_route_text);
112: hr_utility.trace ('p_context_name1: ' || p_context_name1);
113: hr_utility.trace ('p_context_name2: ' || p_context_name2);
114: --
115: BEGIN
116: --
117: SELECT route_id

Line 122: hr_utility.trace(' selected route..');

118: INTO l_route_id
119: FROM ff_routes
120: WHERE route_name = upper(p_route_name);
121: --
122: hr_utility.trace(' selected route..');
123: EXCEPTION WHEN NO_DATA_FOUND THEN
124: --
125: -- Create the route, context usages, and parameters
126: --

Line 150: hr_utility.trace('after insert of route');

146: 0,
147: 0,
148: sysdate);
149:
150: hr_utility.trace('after insert of route');
151:
152: --
153: SELECT ff_routes_s.currval
154: INTO l_route_id

Line 171: hr_utility.trace('after insert of context');

167: 1
168: from ff_contexts FFC
169: where context_name = p_context_name1;
170:
171: hr_utility.trace('after insert of context');
172:
173: --
174: END IF;
175: --

Line 235: hr_utility.trace('after insert of param');

231: 1,
232: p_param_name1,
233: p_param_type1);
234:
235: hr_utility.trace('after insert of param');
236:
237: --
238: END IF;
239: --

Line 269: hr_utility.trace('selected entity id'||to_char(l_user_entity_id));

265: FROM ff_user_entities
266: WHERE user_entity_name = upper(p_user_entity_name)
267: and legislation_code = p_legislation_code ;
268:
269: hr_utility.trace('selected entity id'||to_char(l_user_entity_id));
270:
271: --
272: EXCEPTION WHEN NO_DATA_FOUND THEN
273: --

Line 290: hr_utility.trace('p_user_entity_name: ' || p_user_entity_name);

286: p_legislation_code => p_legislation_code,
287: p_created_by => 0,
288: p_last_login => 0
289: );
290: hr_utility.trace('p_user_entity_name: ' || p_user_entity_name);
291: hr_utility.trace('Legislation_code: ' || p_legislation_code);
292: END;
293:
294: hr_utility.trace('insereted user entity'||p_user_entity_name);

Line 291: hr_utility.trace('Legislation_code: ' || p_legislation_code);

287: p_created_by => 0,
288: p_last_login => 0
289: );
290: hr_utility.trace('p_user_entity_name: ' || p_user_entity_name);
291: hr_utility.trace('Legislation_code: ' || p_legislation_code);
292: END;
293:
294: hr_utility.trace('insereted user entity'||p_user_entity_name);
295:

Line 294: hr_utility.trace('insereted user entity'||p_user_entity_name);

290: hr_utility.trace('p_user_entity_name: ' || p_user_entity_name);
291: hr_utility.trace('Legislation_code: ' || p_legislation_code);
292: END;
293:
294: hr_utility.trace('insereted user entity'||p_user_entity_name);
295:
296: --
297: BEGIN
298: SELECT user_entity_id

Line 305: hr_utility.trace('user entity is not found');

301: WHERE user_entity_name = p_user_entity_name
302: and legislation_code = p_legislation_code;
303: EXCEPTION
304: when no_data_found then
305: hr_utility.trace('user entity is not found');
306: when others then
307: hr_utility.trace('error in others of select of entity');
308: raise;
309: END ;

Line 307: hr_utility.trace('error in others of select of entity');

303: EXCEPTION
304: when no_data_found then
305: hr_utility.trace('user entity is not found');
306: when others then
307: hr_utility.trace('error in others of select of entity');
308: raise;
309: END ;
310: -- Add any route parameter values
311: --

Line 344: hr_utility.trace('Alls well am going to create dbi');

340: END IF;
341: --
342: --END;
343: --
344: hr_utility.trace('Alls well am going to create dbi');
345:
346: -- Now build db item
347: --
348: