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_QSN_BUS dependencies on HR_API

Line 48: hr_api.mandatory_arg_error(p_api_name => l_proc,

44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error(p_api_name => l_proc,
49: p_argument => 'questionnaire_template_id',
50: p_argument_value => p_questionnaire_template_id);
51: --
52: open csr_sec_grp;

Line 57: hr_api.set_security_group_id

53: fetch csr_sec_grp into l_security_group_id;
54: close csr_sec_grp;
55: -- Set the security_group_id in CLIENT_INFO
56: --
57: hr_api.set_security_group_id
58: (p_security_group_id => l_security_group_id
59: );
60:
61: --

Line 91: if nvl(p_rec.name,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.name then

87: fnd_message.raise_error;
88: end if;
89: hr_utility.set_location(l_proc,30);
90: --
91: if nvl(p_rec.name,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.name then
92: hr_api.argument_changed_error
93: (p_api_name => l_proc
94: ,p_argument => 'NAME'
95: ,p_base_table => hr_qsn_shd.g_tab_nam

Line 92: hr_api.argument_changed_error

88: end if;
89: hr_utility.set_location(l_proc,30);
90: --
91: if nvl(p_rec.name,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.name then
92: hr_api.argument_changed_error
93: (p_api_name => l_proc
94: ,p_argument => 'NAME'
95: ,p_base_table => hr_qsn_shd.g_tab_nam
96: );

Line 101: if nvl(p_rec.text,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.text then

97: end if;
98: hr_utility.set_location(l_proc,40);
99: --
100: /**
101: if nvl(p_rec.text,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.text then
102: hr_api.argument_changed_error
103: (p_api_name => l_proc
104: ,p_argument => 'TEXT'
105: ,p_base_table => hr_qsn_shd.g_tab_nam

Line 102: hr_api.argument_changed_error

98: hr_utility.set_location(l_proc,40);
99: --
100: /**
101: if nvl(p_rec.text,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.text then
102: hr_api.argument_changed_error
103: (p_api_name => l_proc
104: ,p_argument => 'TEXT'
105: ,p_base_table => hr_qsn_shd.g_tab_nam
106: );

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

106: );
107: end if;
108: hr_utility.set_location(l_proc,50);
109: --
110: if nvl(p_rec.business_group_id, hr_api.g_number) <>
111: hr_qsn_shd.g_old_rec.business_group_id then
112: hr_api.argument_changed_error
113: (p_api_name => l_proc
114: ,p_argument => 'BUSINESS_GROUP_ID'

Line 112: hr_api.argument_changed_error

108: hr_utility.set_location(l_proc,50);
109: --
110: if nvl(p_rec.business_group_id, hr_api.g_number) <>
111: hr_qsn_shd.g_old_rec.business_group_id then
112: hr_api.argument_changed_error
113: (p_api_name => l_proc
114: ,p_argument => 'BUSINESS_GROUP_ID'
115: ,p_base_table => hr_qsn_shd.g_tab_nam
116: );

Line 244: <> nvl(p_available_flag,hr_api.g_varchar2)) then

240: hr_utility.set_location(l_proc,20);
241: --
242: if l_api_updating AND
243: (hr_qsn_shd.g_old_rec.available_flag
244: <> nvl(p_available_flag,hr_api.g_varchar2)) then
245: -- During update, and available_flag has changed
246: --
247: if hr_api.not_exists_in_hr_lookups
248: (p_effective_date => p_effective_date

Line 247: if hr_api.not_exists_in_hr_lookups

243: (hr_qsn_shd.g_old_rec.available_flag
244: <> nvl(p_available_flag,hr_api.g_varchar2)) then
245: -- During update, and available_flag has changed
246: --
247: if hr_api.not_exists_in_hr_lookups
248: (p_effective_date => p_effective_date
249: ,p_lookup_type => 'YES_NO'
250: ,p_lookup_code => p_available_flag
251: ) then

Line 259: if nvl(p_available_flag,hr_api.g_varchar2) <> 'N' then

255: -- We are allowing users in V4 SSHR to publish the questionnaire
256: -- during the process of creation itself. hence foll. check is not required
257: /* elsif not l_api_updating then
258: -- INSERT - validate that flag is 'N'
259: if nvl(p_available_flag,hr_api.g_varchar2) <> 'N' then
260: fnd_message.set_name('PER','PER_52415_QSN_INVAL_FLG_ON_INS');
261: fnd_message.raise_error;
262: end if; */
263: else

Line 301: hr_api.mandatory_arg_error

297: begin
298: --
299: hr_utility.set_location('Entering: '||l_proc,10);
300: --
301: hr_api.mandatory_arg_error
302: (p_api_name => l_proc
303: ,p_argument => 'questionnaire_template_id'
304: ,p_argument_value => p_questionnaire_template_id
305: );

Line 343: hr_api.validate_bus_grp_id

339: --
340: -- Validate Important Attributes
341: --
342: if p_rec.business_group_id is not null then
343: hr_api.validate_bus_grp_id
344: (p_rec.business_group_id
345: ,p_associated_column1 => hr_qsn_shd.g_tab_nam
346: || '.BUSINESS_GROUP_ID');
347: end if;

Line 382: hr_api.validate_bus_grp_id

378: --
379: -- Call all supporting business operations
380: --
381: if p_rec.business_group_id is not null then
382: hr_api.validate_bus_grp_id
383: (p_business_group_id => p_rec.business_group_id
384: ,p_associated_column1 => hr_qsn_shd.g_tab_nam
385: || '.BUSINESS_GROUP_ID');
386: end if;

Line 438: hr_api.mandatory_arg_error(p_api_name => l_proc

434: l_legislation_code varchar2(150);
435: l_proc varchar2(72) := 'return_legislation_code';
436: begin
437: hr_utility.set_location('Entering: '||l_proc, 10);
438: hr_api.mandatory_arg_error(p_api_name => l_proc
439: ,p_argument => 'questionnaire_template_id'
440: ,p_argument_value => p_questionnaire_template_id
441: );
442: if nvl(g_questionnaire_template_id, hr_api.g_number)

Line 442: if nvl(g_questionnaire_template_id, hr_api.g_number)

438: hr_api.mandatory_arg_error(p_api_name => l_proc
439: ,p_argument => 'questionnaire_template_id'
440: ,p_argument_value => p_questionnaire_template_id
441: );
442: if nvl(g_questionnaire_template_id, hr_api.g_number)
443: = p_questionnaire_template_id then
444: --
445: -- The legislation code has already been found with a previous
446: -- call to this function. Just return the value in the global