[Home] [Help]
40: l_legislation_code varchar2(150);
41: --
42: begin
43: --
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
80: --
81: hr_api.set_legislation_context(l_legislation_code);
82: end if;
83: --
84: hr_utility.set_location(' Leaving:'|| l_proc, 20);
85: --
86: end set_security_group_id;
87: --
88: -- ---------------------------------------------------------------------------
111: l_proc varchar2(72) := g_package||'return_legislation_code';
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'|| l_proc, 10);
116: --
117: -- Ensure that all the mandatory parameter are not null
118: --
119: hr_api.mandatory_arg_error
129: -- call to this function. Just return the value in the global
130: -- variable.
131: --
132: l_legislation_code := pqh_psu_bus.g_legislation_code;
133: hr_utility.set_location(l_proc, 20);
134: else
135: --
136: -- The ID is different to the last call to this function
137: -- or this is the first call to this function.
146: close csr_leg_code;
147: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
148: fnd_message.raise_error;
149: end if;
150: hr_utility.set_location(l_proc,30);
151: --
152: -- Set the global variables so the values are
153: -- available for the next call to this function.
154: --
155: close csr_leg_code;
156: pqh_psu_bus.g_emp_stat_situation_id := p_emp_stat_situation_id;
157: pqh_psu_bus.g_legislation_code := l_legislation_code;
158: end if;
159: hr_utility.set_location(' Leaving:'|| l_proc, 40);
160: return l_legislation_code;
161: end return_legislation_code;
162: --
163: -- ----------------------------------------------------------------------------
194: --
195: l_proc varchar2(72) := g_package || 'chk_df';
196: --
197: begin
198: hr_utility.set_location('Entering:'||l_proc,10);
199: --
200: if ((p_rec.emp_stat_situation_id is not null) and (
201: nvl(pqh_psu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
333: ,p_attribute30_value => p_rec.attribute30
334: );
335: end if;
336: --
337: hr_utility.set_location(' Leaving:'||l_proc,20);
338: end chk_df;
339: --
340: -- ----------------------------------------------------------------------------
341: -- |-----------------------< chk_non_updateable_args >------------------------|
928: l_total_duration_days NUMBER;
929: --
930: BEGIN
931: --
932: HR_UTILITY.set_location ('Entering:' || l_proc, 5);
933: --
934: OPEN csr_emp_stat_situation;
935: FETCH csr_emp_stat_situation INTO lr_previous_exist;
936: CLOSE csr_emp_stat_situation;
998: FND_MESSAGE.set_name ('PQH', 'FR_PQH_DURATION_LIMIT_EXCEEDS');
999: HR_MULTI_MESSAGE.add;
1000: END IF;
1001: --
1002: HR_UTILITY.set_location ('Leaving: '||l_proc,5);
1003: --
1004: END chk_duration_date;
1005: */
1006: --
1053: l_min_dpr DATE;
1054: --
1055: BEGIN
1056: --
1057: HR_UTILITY.set_location ('Entering:' || l_proc, 5);
1058: --
1059: OPEN csr_emp_stat_situation;
1060: FETCH csr_emp_stat_situation INTO l_previous_exist;
1061: CLOSE csr_emp_stat_situation;
1208: FND_MESSAGE.set_name ('PQH','FR_PQH_DURATION_LIMIT_EXCEEDS');
1209: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
1210: END IF;
1211: --
1212: HR_UTILITY.set_location ('Leaving: '||l_proc,5);
1213: --
1214: END chk_duration_date;
1215: --
1216: -- ----------------------------------------------------------------------------
1223: l_proc varchar2(72) := g_package||'insert_validate';
1224: --
1225: BEGIN
1226: --
1227: hr_utility.set_location('Entering:'||l_proc,5);
1228: --
1229: --Call all supporting business operations
1230: chk_person_id(p_rec.person_id);
1231: chk_statutory_situation(p_rec.statutory_situation_id);
1240: --
1241: --Validate Dependent Attributes
1242: pqh_psu_bus.chk_df(p_rec);
1243: --
1244: hr_utility.set_location('Leaving:'||l_proc,10);
1245: --
1246: END insert_validate;
1247: --
1248: -- ----------------------------------------------------------------------------
1255: l_proc varchar2(72) := g_package||'update_validate';
1256: --
1257: BEGIN
1258: --
1259: hr_utility.set_location('Entering:'||l_proc, 5);
1260: --
1261: --Call all supporting business operations
1262: chk_person_id(p_rec.person_id);
1263: chk_statutory_situation(p_rec.statutory_situation_id);
1275: ,p_rec => p_rec);
1276: --
1277: pqh_psu_bus.chk_df(p_rec);
1278: --
1279: hr_utility.set_location(' Leaving:'||l_proc, 10);
1280: --
1281: END update_validate;
1282: --
1283: -- ----------------------------------------------------------------------------
1289: l_proc varchar2(72) := g_package||'delete_validate';
1290: --
1291: BEGIN
1292: --
1293: hr_utility.set_location('Entering:'||l_proc, 5);
1294: --
1295: --Call all supporting business operations
1296: hr_utility.set_location(' Leaving:'||l_proc, 10);
1297: --
1292: --
1293: hr_utility.set_location('Entering:'||l_proc, 5);
1294: --
1295: --Call all supporting business operations
1296: hr_utility.set_location(' Leaving:'||l_proc, 10);
1297: --
1298: END delete_validate;
1299: --
1300: end pqh_psu_bus;