62: close csr_sec_grp;
63: --
64: -- The primary key is invalid therefore we must error
65: --
66: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
67: hr_multi_message.add
68: (p_associated_column1
69: => nvl(p_associated_column1,'TASK_IN_CHECKLIST_ID')
70: );
146: --
147: -- The primary key is invalid therefore we must error
148: --
149: close csr_leg_code;
150: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
151: fnd_message.raise_error;
152: end if;
153: hr_utility.set_location(l_proc,30);
154: --
147: -- The primary key is invalid therefore we must error
148: --
149: close csr_leg_code;
150: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
151: fnd_message.raise_error;
152: end if;
153: hr_utility.set_location(l_proc,30);
154: --
155: -- Set the global variables so the values are
200: fetch csr_ckl_id into l_dummy;
201: if csr_ckl_id%notfound then
202: close csr_ckl_id;
203: --
204: fnd_message.set_name('PER', 'PER_449665_CKL_INV_CKL_ID');
205: fnd_message.raise_error;
206: --
207: end if;
208: close csr_ckl_id;
201: if csr_ckl_id%notfound then
202: close csr_ckl_id;
203: --
204: fnd_message.set_name('PER', 'PER_449665_CKL_INV_CKL_ID');
205: fnd_message.raise_error;
206: --
207: end if;
208: close csr_ckl_id;
209: --
275: fetch csr_ckltsk into l_tsk_exists;
276: if csr_ckltsk%found then
277: close csr_ckltsk;
278: --
279: fnd_message.set_name('PER', 'PER_449670_CKL_TSK_NAME_UNQ');
280: fnd_message.set_token('TASK_NAME', p_checklist_task_name);
281: fnd_message.raise_error;
282: --
283: end if;
276: if csr_ckltsk%found then
277: close csr_ckltsk;
278: --
279: fnd_message.set_name('PER', 'PER_449670_CKL_TSK_NAME_UNQ');
280: fnd_message.set_token('TASK_NAME', p_checklist_task_name);
281: fnd_message.raise_error;
282: --
283: end if;
284: close csr_ckltsk;
277: close csr_ckltsk;
278: --
279: fnd_message.set_name('PER', 'PER_449670_CKL_TSK_NAME_UNQ');
280: fnd_message.set_token('TASK_NAME', p_checklist_task_name);
281: fnd_message.raise_error;
282: --
283: end if;
284: close csr_ckltsk;
285: else
285: else
286: --
287: -- Since task_name is mandatory need to error
288: --
289: fnd_message.set_name('PER','PER_449679_CKL_TASK_NAME_REQD');
290: fnd_message.raise_error;
291: end if;
292: --
293: if g_debug then hr_utility.set_location(l_proc, 5); end if;
286: --
287: -- Since task_name is mandatory need to error
288: --
289: fnd_message.set_name('PER','PER_449679_CKL_TASK_NAME_REQD');
290: fnd_message.raise_error;
291: end if;
292: --
293: if g_debug then hr_utility.set_location(l_proc, 5); end if;
294: --
355: ,p_lookup_type => 'QUALIFYING_UNITS'
356: ,p_lookup_code => p_target_duration_uom
357: ) then
358: -- Error: Invalid Group
359: fnd_message.set_name('PER', 'PER_449680_CKL_UNITS_UOM_INV');
360: fnd_message.raise_error;
361: --
362: ELSE
363: --
356: ,p_lookup_code => p_target_duration_uom
357: ) then
358: -- Error: Invalid Group
359: fnd_message.set_name('PER', 'PER_449680_CKL_UNITS_UOM_INV');
360: fnd_message.raise_error;
361: --
362: ELSE
363: --
364: -- Checks that the target_duration_uom is valid for Checklists
366: IF (p_target_duration_uom <> 'D' and
367: p_target_duration_uom <> 'W' and
368: p_target_duration_uom <> 'M')
369: THEN
370: fnd_message.set_name('PER', 'PER_449680_CKL_UNITS_UOM_INV');
371: fnd_message.raise_error;
372: END IF;
373: --
374: END IF;
367: p_target_duration_uom <> 'W' and
368: p_target_duration_uom <> 'M')
369: THEN
370: fnd_message.set_name('PER', 'PER_449680_CKL_UNITS_UOM_INV');
371: fnd_message.raise_error;
372: END IF;
373: --
374: END IF;
375: --
380: IF ( nvl(p_target_duration,-1) <> -1 AND
381: nvl(p_target_duration_uom,'ZZ') ='ZZ'
382: )
383: THEN
384: fnd_message.set_name('PER', 'PER_449680_CKL_UNITS_UOM_INV');
385: fnd_message.raise_error;
386: END IF;
387: --
388: IF g_debug then hr_utility.set_location(l_proc, 5); END IF;
381: nvl(p_target_duration_uom,'ZZ') ='ZZ'
382: )
383: THEN
384: fnd_message.set_name('PER', 'PER_449680_CKL_UNITS_UOM_INV');
385: fnd_message.raise_error;
386: END IF;
387: --
388: IF g_debug then hr_utility.set_location(l_proc, 5); END IF;
389: --
846: IF NOT per_ctk_shd.api_updating
847: (p_task_in_checklist_id => p_rec.task_in_checklist_id
848: ,p_object_version_number => p_rec.object_version_number
849: ) THEN
850: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
851: fnd_message.set_token('PROCEDURE ', l_proc);
852: fnd_message.set_token('STEP ', '5');
853: fnd_message.raise_error;
854: END IF;
847: (p_task_in_checklist_id => p_rec.task_in_checklist_id
848: ,p_object_version_number => p_rec.object_version_number
849: ) THEN
850: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
851: fnd_message.set_token('PROCEDURE ', l_proc);
852: fnd_message.set_token('STEP ', '5');
853: fnd_message.raise_error;
854: END IF;
855: --
848: ,p_object_version_number => p_rec.object_version_number
849: ) THEN
850: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
851: fnd_message.set_token('PROCEDURE ', l_proc);
852: fnd_message.set_token('STEP ', '5');
853: fnd_message.raise_error;
854: END IF;
855: --
856:
849: ) THEN
850: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
851: fnd_message.set_token('PROCEDURE ', l_proc);
852: fnd_message.set_token('STEP ', '5');
853: fnd_message.raise_error;
854: END IF;
855: --
856:
857: End chk_non_updateable_args;