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

Line 15: hr_utility.trace('enable_startup_mode');

11: BEGIN
12: --
13: hr_startup_data_api_support.g_startup_mode := p_mode;
14: hr_startup_data_api_support.g_startup_session_id := p_startup_session_id;
15: hr_utility.trace('enable_startup_mode');
16: hr_utility.trace('mode is: ' || hr_startup_data_api_support.g_startup_mode);
17: hr_utility.trace('sessionid is: '||to_char(hr_startup_data_api_support.g_startup_session_id));
18: --
19: END enable_startup_mode;

Line 16: hr_utility.trace('mode is: ' || hr_startup_data_api_support.g_startup_mode);

12: --
13: hr_startup_data_api_support.g_startup_mode := p_mode;
14: hr_startup_data_api_support.g_startup_session_id := p_startup_session_id;
15: hr_utility.trace('enable_startup_mode');
16: hr_utility.trace('mode is: ' || hr_startup_data_api_support.g_startup_mode);
17: hr_utility.trace('sessionid is: '||to_char(hr_startup_data_api_support.g_startup_session_id));
18: --
19: END enable_startup_mode;
20: --

Line 17: hr_utility.trace('sessionid is: '||to_char(hr_startup_data_api_support.g_startup_session_id));

13: hr_startup_data_api_support.g_startup_mode := p_mode;
14: hr_startup_data_api_support.g_startup_session_id := p_startup_session_id;
15: hr_utility.trace('enable_startup_mode');
16: hr_utility.trace('mode is: ' || hr_startup_data_api_support.g_startup_mode);
17: hr_utility.trace('sessionid is: '||to_char(hr_startup_data_api_support.g_startup_session_id));
18: --
19: END enable_startup_mode;
20: --
21: -- ----------------------------------------------------------------------------

Line 27: hr_utility.trace('entering return_startup_mode');

23: -- ----------------------------------------------------------------------------
24: FUNCTION return_startup_mode RETURN varchar2 IS
25: --
26: BEGIN
27: hr_utility.trace('entering return_startup_mode');
28: hr_utility.trace('return val : ' || hr_startup_data_api_support.g_startup_mode);
29: RETURN (hr_startup_data_api_support.g_startup_mode);
30: END return_startup_mode;
31: --

Line 28: hr_utility.trace('return val : ' || hr_startup_data_api_support.g_startup_mode);

24: FUNCTION return_startup_mode RETURN varchar2 IS
25: --
26: BEGIN
27: hr_utility.trace('entering return_startup_mode');
28: hr_utility.trace('return val : ' || hr_startup_data_api_support.g_startup_mode);
29: RETURN (hr_startup_data_api_support.g_startup_mode);
30: END return_startup_mode;
31: --
32: -- ----------------------------------------------------------------------------

Line 59: hr_utility.trace('create_owner_definition');

55: hr_startup_data_api_support.g_startup_session_id;
56: end if;
57: END IF;
58: --
59: hr_utility.trace('create_owner_definition');
60: hr_utility.trace('session id: ' || to_char(hr_startup_data_api_support.g_session_id));
61: hr_utility.trace('product_short_name: ' || p_product_shortname);
62: INSERT INTO hr_owner_definitions
63: (session_id

Line 60: hr_utility.trace('session id: ' || to_char(hr_startup_data_api_support.g_session_id));

56: end if;
57: END IF;
58: --
59: hr_utility.trace('create_owner_definition');
60: hr_utility.trace('session id: ' || to_char(hr_startup_data_api_support.g_session_id));
61: hr_utility.trace('product_short_name: ' || p_product_shortname);
62: INSERT INTO hr_owner_definitions
63: (session_id
64: ,product_short_name)

Line 61: hr_utility.trace('product_short_name: ' || p_product_shortname);

57: END IF;
58: --
59: hr_utility.trace('create_owner_definition');
60: hr_utility.trace('session id: ' || to_char(hr_startup_data_api_support.g_session_id));
61: hr_utility.trace('product_short_name: ' || p_product_shortname);
62: INSERT INTO hr_owner_definitions
63: (session_id
64: ,product_short_name)
65: VALUES

Line 71: hr_utility.trace('p_validate is TRUE');

67: ,p_product_shortname);
68: --
69: -- When in validation mode, raise validation enabled exception
70: IF p_validate THEN
71: hr_utility.trace('p_validate is TRUE');
72: raise hr_api.validate_enabled;
73: END IF;
74: --
75: EXCEPTION

Line 78: hr_utility.trace('raising hr_api.validate_enabled');

74: --
75: EXCEPTION
76: WHEN hr_api.validate_enabled THEN
77: -- As validate_enabled exception raised, roll back to savepoint
78: hr_utility.trace('raising hr_api.validate_enabled');
79: ROLLBACK TO ins_owner_def;
80: WHEN others THEN
81: -- Unexpected error
82: hr_utility.trace('raising unknown error');

Line 82: hr_utility.trace('raising unknown error');

78: hr_utility.trace('raising hr_api.validate_enabled');
79: ROLLBACK TO ins_owner_def;
80: WHEN others THEN
81: -- Unexpected error
82: hr_utility.trace('raising unknown error');
83: ROLLBACK TO ins_owner_def;
84: raise;
85: END create_owner_definition;
86: --

Line 98: hr_utility.trace('delete_owner_definitions');

94: FROM dual;
95: --
96: BEGIN
97: --
98: hr_utility.trace('delete_owner_definitions');
99: -- Issue savepoint
100: SAVEPOINT del_owner_defs;
101: --
102: -- Delete rows for current session

Line 108: hr_utility.trace('p_validate is TRUE');

104: WHERE session_id = userenv('sessionid');
105: --
106: -- When in validation mode, raise validation enabled exception
107: IF p_validate THEN
108: hr_utility.trace('p_validate is TRUE');
109: RAISE hr_api.validate_enabled;
110: END IF;
111: --
112: EXCEPTION

Line 116: hr_utility.trace('raising hr_api.validate_enabled');

112: EXCEPTION
113: WHEN hr_api.validate_enabled THEN
114: --
115: -- Rollback to savepoint, as validate_enabled trigger has been raised
116: hr_utility.trace('raising hr_api.validate_enabled');
117: ROLLBACK TO del_owner_defs;
118: --
119: WHEN OTHERS THEN
120: -- Unexpected error

Line 121: hr_utility.trace('raising unknown error');

117: ROLLBACK TO del_owner_defs;
118: --
119: WHEN OTHERS THEN
120: -- Unexpected error
121: hr_utility.trace('raising unknown error');
122: ROLLBACK TO del_owner_defs;
123: RAISE;
124: END delete_owner_definitions;
125: --

Line 137: hr_utility.trace('mode_allowed');

133: BEGIN
134: hr_startup_data_api_support.g_generic_allowed := p_generic;
135: hr_startup_data_api_support.g_startup_allowed := p_startup;
136: hr_startup_data_api_support.g_user_allowed := p_user;
137: hr_utility.trace('mode_allowed');
138: if p_generic then hr_utility.trace('p_generic : TRUE'); else hr_utility.trace('p_generic : FALSE'); end if;
139: if p_startup then hr_utility.trace('p_startup : TRUE'); else hr_utility.trace('p_startup : FALSE'); end if;
140: if p_user then hr_utility.trace('p_user : TRUE'); else hr_utility.trace('p_user : FALSE'); end if;
141: END mode_allowed;

Line 138: if p_generic then hr_utility.trace('p_generic : TRUE'); else hr_utility.trace('p_generic : FALSE'); end if;

134: hr_startup_data_api_support.g_generic_allowed := p_generic;
135: hr_startup_data_api_support.g_startup_allowed := p_startup;
136: hr_startup_data_api_support.g_user_allowed := p_user;
137: hr_utility.trace('mode_allowed');
138: if p_generic then hr_utility.trace('p_generic : TRUE'); else hr_utility.trace('p_generic : FALSE'); end if;
139: if p_startup then hr_utility.trace('p_startup : TRUE'); else hr_utility.trace('p_startup : FALSE'); end if;
140: if p_user then hr_utility.trace('p_user : TRUE'); else hr_utility.trace('p_user : FALSE'); end if;
141: END mode_allowed;
142: --

Line 139: if p_startup then hr_utility.trace('p_startup : TRUE'); else hr_utility.trace('p_startup : FALSE'); end if;

135: hr_startup_data_api_support.g_startup_allowed := p_startup;
136: hr_startup_data_api_support.g_user_allowed := p_user;
137: hr_utility.trace('mode_allowed');
138: if p_generic then hr_utility.trace('p_generic : TRUE'); else hr_utility.trace('p_generic : FALSE'); end if;
139: if p_startup then hr_utility.trace('p_startup : TRUE'); else hr_utility.trace('p_startup : FALSE'); end if;
140: if p_user then hr_utility.trace('p_user : TRUE'); else hr_utility.trace('p_user : FALSE'); end if;
141: END mode_allowed;
142: --
143: -- ----------------------------------------------------------------------------

Line 140: if p_user then hr_utility.trace('p_user : TRUE'); else hr_utility.trace('p_user : FALSE'); end if;

136: hr_startup_data_api_support.g_user_allowed := p_user;
137: hr_utility.trace('mode_allowed');
138: if p_generic then hr_utility.trace('p_generic : TRUE'); else hr_utility.trace('p_generic : FALSE'); end if;
139: if p_startup then hr_utility.trace('p_startup : TRUE'); else hr_utility.trace('p_startup : FALSE'); end if;
140: if p_user then hr_utility.trace('p_user : TRUE'); else hr_utility.trace('p_user : FALSE'); end if;
141: END mode_allowed;
142: --
143: -- ----------------------------------------------------------------------------
144: -- |-----------------------< chk_startup_action >-----------------------------|

Line 177: hr_utility.trace('chk_startup_action');

173: l_mode := hr_startup_data_api_support.return_startup_mode;
174: l_session_id := nvl(hr_startup_data_api_support.g_startup_session_id
175: , userenv('sessionid'));
176: --
177: hr_utility.trace('chk_startup_action');
178: hr_utility.trace('l_session_id : ' || to_char(l_session_id));
179: hr_utility.trace('hr_startup_data_api_support.g_startup_session_id : ' || to_char(hr_startup_data_api_support.g_startup_session_id));
180: hr_utility.trace('l_mode : ' || l_mode);
181: hr_utility.trace('p_business_group_id : ' || nvl(to_char(p_business_group_id), 'NULL'));

Line 178: hr_utility.trace('l_session_id : ' || to_char(l_session_id));

174: l_session_id := nvl(hr_startup_data_api_support.g_startup_session_id
175: , userenv('sessionid'));
176: --
177: hr_utility.trace('chk_startup_action');
178: hr_utility.trace('l_session_id : ' || to_char(l_session_id));
179: hr_utility.trace('hr_startup_data_api_support.g_startup_session_id : ' || to_char(hr_startup_data_api_support.g_startup_session_id));
180: hr_utility.trace('l_mode : ' || l_mode);
181: hr_utility.trace('p_business_group_id : ' || nvl(to_char(p_business_group_id), 'NULL'));
182: hr_utility.trace('p_legislation_code : ' || nvl(p_legislation_code, 'NULL'));

Line 179: hr_utility.trace('hr_startup_data_api_support.g_startup_session_id : ' || to_char(hr_startup_data_api_support.g_startup_session_id));

175: , userenv('sessionid'));
176: --
177: hr_utility.trace('chk_startup_action');
178: hr_utility.trace('l_session_id : ' || to_char(l_session_id));
179: hr_utility.trace('hr_startup_data_api_support.g_startup_session_id : ' || to_char(hr_startup_data_api_support.g_startup_session_id));
180: hr_utility.trace('l_mode : ' || l_mode);
181: hr_utility.trace('p_business_group_id : ' || nvl(to_char(p_business_group_id), 'NULL'));
182: hr_utility.trace('p_legislation_code : ' || nvl(p_legislation_code, 'NULL'));
183: hr_utility.trace('p_legislation_subgroup : ' || nvl(p_legislation_subgroup, 'NULL'));

Line 180: hr_utility.trace('l_mode : ' || l_mode);

176: --
177: hr_utility.trace('chk_startup_action');
178: hr_utility.trace('l_session_id : ' || to_char(l_session_id));
179: hr_utility.trace('hr_startup_data_api_support.g_startup_session_id : ' || to_char(hr_startup_data_api_support.g_startup_session_id));
180: hr_utility.trace('l_mode : ' || l_mode);
181: hr_utility.trace('p_business_group_id : ' || nvl(to_char(p_business_group_id), 'NULL'));
182: hr_utility.trace('p_legislation_code : ' || nvl(p_legislation_code, 'NULL'));
183: hr_utility.trace('p_legislation_subgroup : ' || nvl(p_legislation_subgroup, 'NULL'));
184:

Line 181: hr_utility.trace('p_business_group_id : ' || nvl(to_char(p_business_group_id), 'NULL'));

177: hr_utility.trace('chk_startup_action');
178: hr_utility.trace('l_session_id : ' || to_char(l_session_id));
179: hr_utility.trace('hr_startup_data_api_support.g_startup_session_id : ' || to_char(hr_startup_data_api_support.g_startup_session_id));
180: hr_utility.trace('l_mode : ' || l_mode);
181: hr_utility.trace('p_business_group_id : ' || nvl(to_char(p_business_group_id), 'NULL'));
182: hr_utility.trace('p_legislation_code : ' || nvl(p_legislation_code, 'NULL'));
183: hr_utility.trace('p_legislation_subgroup : ' || nvl(p_legislation_subgroup, 'NULL'));
184:
185: -- Only perform checks is API is not being called by SDM

Line 182: hr_utility.trace('p_legislation_code : ' || nvl(p_legislation_code, 'NULL'));

178: hr_utility.trace('l_session_id : ' || to_char(l_session_id));
179: hr_utility.trace('hr_startup_data_api_support.g_startup_session_id : ' || to_char(hr_startup_data_api_support.g_startup_session_id));
180: hr_utility.trace('l_mode : ' || l_mode);
181: hr_utility.trace('p_business_group_id : ' || nvl(to_char(p_business_group_id), 'NULL'));
182: hr_utility.trace('p_legislation_code : ' || nvl(p_legislation_code, 'NULL'));
183: hr_utility.trace('p_legislation_subgroup : ' || nvl(p_legislation_subgroup, 'NULL'));
184:
185: -- Only perform checks is API is not being called by SDM
186: IF (l_mode <> 'DELIVERY') THEN

Line 183: hr_utility.trace('p_legislation_subgroup : ' || nvl(p_legislation_subgroup, 'NULL'));

179: hr_utility.trace('hr_startup_data_api_support.g_startup_session_id : ' || to_char(hr_startup_data_api_support.g_startup_session_id));
180: hr_utility.trace('l_mode : ' || l_mode);
181: hr_utility.trace('p_business_group_id : ' || nvl(to_char(p_business_group_id), 'NULL'));
182: hr_utility.trace('p_legislation_code : ' || nvl(p_legislation_code, 'NULL'));
183: hr_utility.trace('p_legislation_subgroup : ' || nvl(p_legislation_subgroup, 'NULL'));
184:
185: -- Only perform checks is API is not being called by SDM
186: IF (l_mode <> 'DELIVERY') THEN
187: IF ((p_business_group_id IS NULL) AND

Line 195: hr_utility.trace('Entering PER_289141_STARTUP_OWN_DEF_ERR else stmt');

191: -- Generic rows being inserted, yet shouldnt be
192: fnd_message.set_name('PER', 'PER_289140_STARTUP_GEN_MOD_ERR');
193: fnd_message.raise_error;
194: ELSE
195: hr_utility.trace('Entering PER_289141_STARTUP_OWN_DEF_ERR else stmt');
196: hr_utility.trace('l_session_id : ' || to_char(l_session_id));
197: OPEN csr_check_exists(l_session_id);
198: FETCH csr_check_exists INTO l_exists;
199: IF csr_check_exists%NOTFOUND THEN

Line 196: hr_utility.trace('l_session_id : ' || to_char(l_session_id));

192: fnd_message.set_name('PER', 'PER_289140_STARTUP_GEN_MOD_ERR');
193: fnd_message.raise_error;
194: ELSE
195: hr_utility.trace('Entering PER_289141_STARTUP_OWN_DEF_ERR else stmt');
196: hr_utility.trace('l_session_id : ' || to_char(l_session_id));
197: OPEN csr_check_exists(l_session_id);
198: FETCH csr_check_exists INTO l_exists;
199: IF csr_check_exists%NOTFOUND THEN
200: hr_utility.trace('didnt find the id');

Line 200: hr_utility.trace('didnt find the id');

196: hr_utility.trace('l_session_id : ' || to_char(l_session_id));
197: OPEN csr_check_exists(l_session_id);
198: FETCH csr_check_exists INTO l_exists;
199: IF csr_check_exists%NOTFOUND THEN
200: hr_utility.trace('didnt find the id');
201: CLOSE csr_check_exists;
202: fnd_message.set_name('PER', 'PER_289141_STARTUP_OWN_DEF_ERR');
203: fnd_message.raise_error;
204: END IF;