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.PQH_STS_BUS dependencies on HR_API

Line 54: hr_api.mandatory_arg_error

50:
51: --
52: -- Ensure that all the mandatory parameter are not null
53: --
54: hr_api.mandatory_arg_error
55: (p_api_name => l_proc
56: ,p_argument => 'statutory_situation_id'
57: ,p_argument_value => p_statutory_situation_id
58: );

Line 81: hr_api.set_security_group_id

77: close csr_sec_grp;
78: --
79: -- Set the security_group_id in CLIENT_INFO
80: --
81: hr_api.set_security_group_id
82: (p_security_group_id => l_security_group_id
83: );
84: --
85: -- Set the sessions legislation context in HR_SESSION_DATA

Line 87: hr_api.set_legislation_context(l_legislation_code);

83: );
84: --
85: -- Set the sessions legislation context in HR_SESSION_DATA
86: --
87: hr_api.set_legislation_context(l_legislation_code);
88: end if;
89: --
90: if g_debug then
91: --

Line 131: hr_api.mandatory_arg_error

127: end if;
128: --
129: -- Ensure that all the mandatory parameter are not null
130: --
131: hr_api.mandatory_arg_error
132: (p_api_name => l_proc
133: ,p_argument => 'statutory_situation_id'
134: ,p_argument_value => p_statutory_situation_id
135: );

Line 137: if ( nvl(pqh_sts_bus.g_statutory_situation_id, hr_api.g_number)

133: ,p_argument => 'statutory_situation_id'
134: ,p_argument_value => p_statutory_situation_id
135: );
136: --
137: if ( nvl(pqh_sts_bus.g_statutory_situation_id, hr_api.g_number)
138: = p_statutory_situation_id) then
139: --
140: -- The legislation code has already been found with a previous
141: -- call to this function. Just return the value in the global

Line 241: if nvl(p_rec.business_group_id, hr_api.g_number) <>

237: fnd_message.set_token('STEP ', '5');
238: fnd_message.raise_error;
239: END IF;
240:
241: if nvl(p_rec.business_group_id, hr_api.g_number) <>
242: nvl(pqh_sts_shd.g_old_rec.business_group_id
243: ,hr_api.g_number
244: ) then
245: hr_api.argument_changed_error

Line 243: ,hr_api.g_number

239: END IF;
240:
241: if nvl(p_rec.business_group_id, hr_api.g_number) <>
242: nvl(pqh_sts_shd.g_old_rec.business_group_id
243: ,hr_api.g_number
244: ) then
245: hr_api.argument_changed_error
246: (p_api_name => l_proc
247: ,p_argument => 'BUSINESS_GROUP_ID'

Line 245: hr_api.argument_changed_error

241: if nvl(p_rec.business_group_id, hr_api.g_number) <>
242: nvl(pqh_sts_shd.g_old_rec.business_group_id
243: ,hr_api.g_number
244: ) then
245: hr_api.argument_changed_error
246: (p_api_name => l_proc
247: ,p_argument => 'BUSINESS_GROUP_ID'
248: ,p_base_table => pqh_sts_shd.g_tab_nam
249: );

Line 254: if nvl(p_rec.type_of_ps, hr_api.g_varchar2) <>

250: end if;
251:
252: -- Type_Of_PS
253:
254: if nvl(p_rec.type_of_ps, hr_api.g_varchar2) <>
255: nvl(pqh_sts_shd.g_old_rec.type_of_ps
256: ,hr_api.g_varchar2
257: ) then
258: hr_api.argument_changed_error

Line 256: ,hr_api.g_varchar2

252: -- Type_Of_PS
253:
254: if nvl(p_rec.type_of_ps, hr_api.g_varchar2) <>
255: nvl(pqh_sts_shd.g_old_rec.type_of_ps
256: ,hr_api.g_varchar2
257: ) then
258: hr_api.argument_changed_error
259: (p_api_name => l_proc
260: ,p_argument => 'TYPE_OF_PS'

Line 258: hr_api.argument_changed_error

254: if nvl(p_rec.type_of_ps, hr_api.g_varchar2) <>
255: nvl(pqh_sts_shd.g_old_rec.type_of_ps
256: ,hr_api.g_varchar2
257: ) then
258: hr_api.argument_changed_error
259: (p_api_name => l_proc
260: ,p_argument => 'TYPE_OF_PS'
261: ,p_base_table => pqh_sts_shd.g_tab_nam
262: );

Line 267: if nvl(p_rec.situation_type, hr_api.g_varchar2) <>

263: end if;
264:
265: -- Situation Type
266:
267: if nvl(p_rec.situation_type, hr_api.g_varchar2) <>
268: nvl(pqh_sts_shd.g_old_rec.situation_type
269: ,hr_api.g_varchar2
270: ) then
271: hr_api.argument_changed_error

Line 269: ,hr_api.g_varchar2

265: -- Situation Type
266:
267: if nvl(p_rec.situation_type, hr_api.g_varchar2) <>
268: nvl(pqh_sts_shd.g_old_rec.situation_type
269: ,hr_api.g_varchar2
270: ) then
271: hr_api.argument_changed_error
272: (p_api_name => l_proc
273: ,p_argument => 'SITUATION_TYPE'

Line 271: hr_api.argument_changed_error

267: if nvl(p_rec.situation_type, hr_api.g_varchar2) <>
268: nvl(pqh_sts_shd.g_old_rec.situation_type
269: ,hr_api.g_varchar2
270: ) then
271: hr_api.argument_changed_error
272: (p_api_name => l_proc
273: ,p_argument => 'SITUATION_TYPE'
274: ,p_base_table => pqh_sts_shd.g_tab_nam
275: );

Line 279: if nvl(p_rec.sub_type, hr_api.g_varchar2) <>

275: );
276: end if;
277:
278: -- Sub Type
279: if nvl(p_rec.sub_type, hr_api.g_varchar2) <>
280: nvl(pqh_sts_shd.g_old_rec.sub_type
281: ,hr_api.g_varchar2
282: ) then
283: hr_api.argument_changed_error

Line 281: ,hr_api.g_varchar2

277:
278: -- Sub Type
279: if nvl(p_rec.sub_type, hr_api.g_varchar2) <>
280: nvl(pqh_sts_shd.g_old_rec.sub_type
281: ,hr_api.g_varchar2
282: ) then
283: hr_api.argument_changed_error
284: (p_api_name => l_proc
285: ,p_argument => 'SUB_TYPE'

Line 283: hr_api.argument_changed_error

279: if nvl(p_rec.sub_type, hr_api.g_varchar2) <>
280: nvl(pqh_sts_shd.g_old_rec.sub_type
281: ,hr_api.g_varchar2
282: ) then
283: hr_api.argument_changed_error
284: (p_api_name => l_proc
285: ,p_argument => 'SUB_TYPE'
286: ,p_base_table => pqh_sts_shd.g_tab_nam
287: );

Line 291: if nvl(p_rec.source, hr_api.g_varchar2) <>

287: );
288: end if;
289:
290: -- Source
291: if nvl(p_rec.source, hr_api.g_varchar2) <>
292: nvl(pqh_sts_shd.g_old_rec.source
293: ,hr_api.g_varchar2
294: ) then
295: hr_api.argument_changed_error

Line 293: ,hr_api.g_varchar2

289:
290: -- Source
291: if nvl(p_rec.source, hr_api.g_varchar2) <>
292: nvl(pqh_sts_shd.g_old_rec.source
293: ,hr_api.g_varchar2
294: ) then
295: hr_api.argument_changed_error
296: (p_api_name => l_proc
297: ,p_argument => 'SOURCE'

Line 295: hr_api.argument_changed_error

291: if nvl(p_rec.source, hr_api.g_varchar2) <>
292: nvl(pqh_sts_shd.g_old_rec.source
293: ,hr_api.g_varchar2
294: ) then
295: hr_api.argument_changed_error
296: (p_api_name => l_proc
297: ,p_argument => 'SOURCE'
298: ,p_base_table => pqh_sts_shd.g_tab_nam
299: );

Line 303: if nvl(p_rec.location, hr_api.g_varchar2) <>

299: );
300: end if;
301:
302: -- Location
303: if nvl(p_rec.location, hr_api.g_varchar2) <>
304: nvl(pqh_sts_shd.g_old_rec.location
305: ,hr_api.g_varchar2
306: ) then
307: hr_api.argument_changed_error

Line 305: ,hr_api.g_varchar2

301:
302: -- Location
303: if nvl(p_rec.location, hr_api.g_varchar2) <>
304: nvl(pqh_sts_shd.g_old_rec.location
305: ,hr_api.g_varchar2
306: ) then
307: hr_api.argument_changed_error
308: (p_api_name => l_proc
309: ,p_argument => 'LOCATION'

Line 307: hr_api.argument_changed_error

303: if nvl(p_rec.location, hr_api.g_varchar2) <>
304: nvl(pqh_sts_shd.g_old_rec.location
305: ,hr_api.g_varchar2
306: ) then
307: hr_api.argument_changed_error
308: (p_api_name => l_proc
309: ,p_argument => 'LOCATION'
310: ,p_base_table => pqh_sts_shd.g_tab_nam
311: );

Line 315: if nvl(p_rec.reason, hr_api.g_varchar2) <>

311: );
312: end if;
313:
314: -- Reason
315: if nvl(p_rec.reason, hr_api.g_varchar2) <>
316: nvl(pqh_sts_shd.g_old_rec.reason
317: ,hr_api.g_varchar2
318: ) then
319: hr_api.argument_changed_error

Line 317: ,hr_api.g_varchar2

313:
314: -- Reason
315: if nvl(p_rec.reason, hr_api.g_varchar2) <>
316: nvl(pqh_sts_shd.g_old_rec.reason
317: ,hr_api.g_varchar2
318: ) then
319: hr_api.argument_changed_error
320: (p_api_name => l_proc
321: ,p_argument => 'REASON'

Line 319: hr_api.argument_changed_error

315: if nvl(p_rec.reason, hr_api.g_varchar2) <>
316: nvl(pqh_sts_shd.g_old_rec.reason
317: ,hr_api.g_varchar2
318: ) then
319: hr_api.argument_changed_error
320: (p_api_name => l_proc
321: ,p_argument => 'REASON'
322: ,p_base_table => pqh_sts_shd.g_tab_nam
323: );

Line 1140: hr_api.validate_bus_grp_id

1136: End if;
1137: --
1138: -- Call all supporting business operations
1139: --
1140: hr_api.validate_bus_grp_id
1141: (p_business_group_id => p_rec.business_group_id
1142: ,p_associated_column1 => pqh_sts_shd.g_tab_nam
1143: || '.BUSINESS_GROUP_ID');
1144: --

Line 1237: hr_api.validate_bus_grp_id

1233: End if;
1234: --
1235: -- Call all supporting business operations
1236: --
1237: hr_api.validate_bus_grp_id
1238: (p_business_group_id => p_rec.business_group_id
1239: ,p_associated_column1 => pqh_sts_shd.g_tab_nam
1240: || '.BUSINESS_GROUP_ID');
1241: hr_multi_message.end_validation_set;