52: open csr_fnd_application_id;
53: fetch csr_fnd_application_id into l_key;
54: if(csr_fnd_application_id%notfound) then
55: close csr_fnd_application_id;
56: fnd_message.set_name('AME', 'INVALID_FND_APPLICATION_ID');
57: fnd_message.raise_error;
58: else
59: close csr_fnd_application_id;
60: end if;
53: fetch csr_fnd_application_id into l_key;
54: if(csr_fnd_application_id%notfound) then
55: close csr_fnd_application_id;
56: fnd_message.set_name('AME', 'INVALID_FND_APPLICATION_ID');
57: fnd_message.raise_error;
58: else
59: close csr_fnd_application_id;
60: end if;
61: hr_utility.set_location(' Leaving:'||l_proc,30);
121: open csr_application_name;
122: fetch csr_application_name into l_key;
123: if(csr_application_name%found) then
124: close csr_application_name;
125: fnd_message.set_name('AME', 'AME_400748_TTY_NAME_IN_USE');
126: fnd_message.raise_error;
127: end if;
128: close csr_application_name;
129: hr_utility.set_location(' Leaving:'||l_proc,30);
122: fetch csr_application_name into l_key;
123: if(csr_application_name%found) then
124: close csr_application_name;
125: fnd_message.set_name('AME', 'AME_400748_TTY_NAME_IN_USE');
126: fnd_message.raise_error;
127: end if;
128: close csr_application_name;
129: hr_utility.set_location(' Leaving:'||l_proc,30);
130: exception
190: open csr_fnd_app_tx_type;
191: fetch csr_fnd_app_tx_type into l_key;
192: if(csr_fnd_app_tx_type%found) then
193: close csr_fnd_app_tx_type;
194: fnd_message.set_name('AME', 'AME_400763_TTID_IN_USE');
195: fnd_message.raise_error;
196: end if;
197: close csr_fnd_app_tx_type;
198: end if;
191: fetch csr_fnd_app_tx_type into l_key;
192: if(csr_fnd_app_tx_type%found) then
193: close csr_fnd_app_tx_type;
194: fnd_message.set_name('AME', 'AME_400763_TTID_IN_USE');
195: fnd_message.raise_error;
196: end if;
197: close csr_fnd_app_tx_type;
198: end if;
199: hr_utility.set_location(' Leaving:'||l_proc,30);
237: l_proc varchar2(72) := g_package || 'CHK_IS_TTY_ID_NULL';
238: begin
239: hr_utility.set_location('Entering:'||l_proc,10);
240: if p_transaction_type_id is null then
241: fnd_message.set_name('PER', 'AME_400780_NULL_TTY_ID');
242: fnd_message.raise_error;
243: end if;
244: end chk_is_tty_id_null;
245: -- ----------------------------------------------------------------------------
238: begin
239: hr_utility.set_location('Entering:'||l_proc,10);
240: if p_transaction_type_id is null then
241: fnd_message.set_name('PER', 'AME_400780_NULL_TTY_ID');
242: fnd_message.raise_error;
243: end if;
244: end chk_is_tty_id_null;
245: -- ----------------------------------------------------------------------------
246: -- |-----------------------------< CHK_DELETE >-------------------------------|
290: open csr_isSeeded;
291: fetch csr_isSeeded into l_key;
292: if(csr_isSeeded%notfound) then
293: close csr_isSeeded;
294: fnd_message.set_name('AME', 'INVALID_TRANSACTION_TYPE');
295: fnd_message.raise_error;
296: else
297: close csr_isSeeded;
298: end if;
291: fetch csr_isSeeded into l_key;
292: if(csr_isSeeded%notfound) then
293: close csr_isSeeded;
294: fnd_message.set_name('AME', 'INVALID_TRANSACTION_TYPE');
295: fnd_message.raise_error;
296: else
297: close csr_isSeeded;
298: end if;
299: hr_utility.set_location(' Leaving:'||l_proc,30);
351: (p_application_id => p_rec.application_id
352: ,p_effective_date => p_effective_date
353: ,p_object_version_number => p_rec.object_version_number
354: ) THEN
355: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
356: fnd_message.set_token('PROCEDURE ', l_proc);
357: fnd_message.set_token('STEP ', '5');
358: fnd_message.raise_error;
359: END IF;
352: ,p_effective_date => p_effective_date
353: ,p_object_version_number => p_rec.object_version_number
354: ) THEN
355: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
356: fnd_message.set_token('PROCEDURE ', l_proc);
357: fnd_message.set_token('STEP ', '5');
358: fnd_message.raise_error;
359: END IF;
360: --
353: ,p_object_version_number => p_rec.object_version_number
354: ) THEN
355: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
356: fnd_message.set_token('PROCEDURE ', l_proc);
357: fnd_message.set_token('STEP ', '5');
358: fnd_message.raise_error;
359: END IF;
360: --
361: -- EDIT_HERE: Add checks to ensure non-updateable args have
354: ) THEN
355: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
356: fnd_message.set_token('PROCEDURE ', l_proc);
357: fnd_message.set_token('STEP ', '5');
358: fnd_message.raise_error;
359: END IF;
360: --
361: -- EDIT_HERE: Add checks to ensure non-updateable args have
362: -- not been updated.
464: --
465: -- An unhandled or unexpected error has occurred which
466: -- we must report
467: --
468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
469: fnd_message.set_token('PROCEDURE', l_proc);
470: fnd_message.set_token('STEP','15');
471: fnd_message.raise_error;
472: End dt_update_validate;
465: -- An unhandled or unexpected error has occurred which
466: -- we must report
467: --
468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
469: fnd_message.set_token('PROCEDURE', l_proc);
470: fnd_message.set_token('STEP','15');
471: fnd_message.raise_error;
472: End dt_update_validate;
473: --
466: -- we must report
467: --
468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
469: fnd_message.set_token('PROCEDURE', l_proc);
470: fnd_message.set_token('STEP','15');
471: fnd_message.raise_error;
472: End dt_update_validate;
473: --
474: -- ----------------------------------------------------------------------------
467: --
468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
469: fnd_message.set_token('PROCEDURE', l_proc);
470: fnd_message.set_token('STEP','15');
471: fnd_message.raise_error;
472: End dt_update_validate;
473: --
474: -- ----------------------------------------------------------------------------
475: -- |--------------------------< dt_delete_validate >--------------------------|
561: --
562: -- An unhandled or unexpected error has occurred which
563: -- we must report
564: --
565: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
566: fnd_message.set_token('PROCEDURE', l_proc);
567: fnd_message.set_token('STEP','15');
568: fnd_message.raise_error;
569: --
562: -- An unhandled or unexpected error has occurred which
563: -- we must report
564: --
565: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
566: fnd_message.set_token('PROCEDURE', l_proc);
567: fnd_message.set_token('STEP','15');
568: fnd_message.raise_error;
569: --
570: End dt_delete_validate;
563: -- we must report
564: --
565: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
566: fnd_message.set_token('PROCEDURE', l_proc);
567: fnd_message.set_token('STEP','15');
568: fnd_message.raise_error;
569: --
570: End dt_delete_validate;
571: --
564: --
565: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
566: fnd_message.set_token('PROCEDURE', l_proc);
567: fnd_message.set_token('STEP','15');
568: fnd_message.raise_error;
569: --
570: End dt_delete_validate;
571: --
572: -- ----------------------------------------------------------------------------