DBA Data[Home] [Help]

APPS.AME_ITU_BUS dependencies on FND_MESSAGE

Line 61: fnd_message.set_name('PER','AME_400732_INV_APPLICATION_ID');

57: open csr_application_id;
58: fetch csr_application_id into l_dummy;
59: if(csr_application_id%notfound) then
60: close csr_application_id;
61: fnd_message.set_name('PER','AME_400732_INV_APPLICATION_ID');
62: fnd_message.raise_error;
63: end if;
64: close csr_application_id;
65: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 62: fnd_message.raise_error;

58: fetch csr_application_id into l_dummy;
59: if(csr_application_id%notfound) then
60: close csr_application_id;
61: fnd_message.set_name('PER','AME_400732_INV_APPLICATION_ID');
62: fnd_message.raise_error;
63: end if;
64: close csr_application_id;
65: hr_utility.set_location(' Leaving:'||l_proc,30);
66: exception

Line 128: fnd_message.set_name('PER','AME_400740_INV_ITEM_CLASS_ID');

124: open csr_item_class_id;
125: fetch csr_item_class_id into l_dummy;
126: if(csr_item_class_id%notfound) then
127: close csr_item_class_id;
128: fnd_message.set_name('PER','AME_400740_INV_ITEM_CLASS_ID');
129: fnd_message.raise_error;
130: end if;
131: close csr_item_class_id;
132: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 129: fnd_message.raise_error;

125: fetch csr_item_class_id into l_dummy;
126: if(csr_item_class_id%notfound) then
127: close csr_item_class_id;
128: fnd_message.set_name('PER','AME_400740_INV_ITEM_CLASS_ID');
129: fnd_message.raise_error;
130: end if;
131: close csr_item_class_id;
132: hr_utility.set_location(' Leaving:'||l_proc,30);
133: exception

Line 193: fnd_message.set_name('PER','AME_400745_ITC_NAME_NOT_UNQ');

189: open csr_item_class_usage;
190: fetch csr_item_class_usage into l_dummy;
191: if(csr_item_class_usage%found) then
192: close csr_item_class_usage;
193: fnd_message.set_name('PER','AME_400745_ITC_NAME_NOT_UNQ');
194: fnd_message.raise_error;
195: end if;
196: close csr_item_class_usage;
197: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 194: fnd_message.raise_error;

190: fetch csr_item_class_usage into l_dummy;
191: if(csr_item_class_usage%found) then
192: close csr_item_class_usage;
193: fnd_message.set_name('PER','AME_400745_ITC_NAME_NOT_UNQ');
194: fnd_message.raise_error;
195: end if;
196: close csr_item_class_usage;
197: hr_utility.set_location(' Leaving:'||l_proc,30);
198: exception

Line 316: fnd_message.set_name('PER','QUERY_CONTAINS_SPL_CHARS');

312: if(instrb(p_item_id_query, ';', 1, 1) > 0) or
313: (instrb(p_item_id_query, '--', 1, 1) > 0) or
314: (instrb(p_item_id_query, '/*', 1, 1) > 0) or
315: (instrb(p_item_id_query, '*/', 1, 1) > 0) then
316: fnd_message.set_name('PER','QUERY_CONTAINS_SPL_CHARS');
317: fnd_message.raise_error;
318: end if;
319: -- Check for any other place holder columns other than place holder
320: -- column for transaction ID

Line 317: fnd_message.raise_error;

313: (instrb(p_item_id_query, '--', 1, 1) > 0) or
314: (instrb(p_item_id_query, '/*', 1, 1) > 0) or
315: (instrb(p_item_id_query, '*/', 1, 1) > 0) then
316: fnd_message.set_name('PER','QUERY_CONTAINS_SPL_CHARS');
317: fnd_message.raise_error;
318: end if;
319: -- Check for any other place holder columns other than place holder
320: -- column for transaction ID
321: l_temp_count := 1;

Line 333: fnd_message.set_name('PER','AME_400377_ADM_IC_QUERY2');

329: end if;
330: l_trans_id_placeholder_pos2 :=
331: instrb(p_item_id_query, ame_util.transactionIdPlaceholder, 1, l_temp_count);
332: if(l_trans_id_placeholder_pos <> l_trans_id_placeholder_pos2) then
333: fnd_message.set_name('PER','AME_400377_ADM_IC_QUERY2');
334: fnd_message.raise_error;
335: end if;
336: l_temp_count := l_temp_count + 1;
337: end loop;

Line 334: fnd_message.raise_error;

330: l_trans_id_placeholder_pos2 :=
331: instrb(p_item_id_query, ame_util.transactionIdPlaceholder, 1, l_temp_count);
332: if(l_trans_id_placeholder_pos <> l_trans_id_placeholder_pos2) then
333: fnd_message.set_name('PER','AME_400377_ADM_IC_QUERY2');
334: fnd_message.raise_error;
335: end if;
336: l_temp_count := l_temp_count + 1;
337: end loop;
338: select ame_utility_pkg.validate_query(p_item_id_query,'1',ame_util2.itemClassObject)

Line 342: fnd_message.raise_error;

338: select ame_utility_pkg.validate_query(p_item_id_query,'1',ame_util2.itemClassObject)
339: into l_query_validation
340: from dual;
341: if l_query_validation <> 'Y' then
342: fnd_message.raise_error;
343: end if;
344: end if;
345: end if;
346: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 399: fnd_message.set_name('PER','AME_400766_INV_PARAM_MODE');

395: if nvl(p_item_class_par_mode, hr_api.g_varchar2) <> hr_api.g_varchar2 and
396: p_item_class_par_mode not in (ame_util.serialItems,
397: ame_util.parallelItems
398: ) then
399: fnd_message.set_name('PER','AME_400766_INV_PARAM_MODE');
400: fnd_message.raise_error;
401: end if;
402: end if;
403: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 400: fnd_message.raise_error;

396: p_item_class_par_mode not in (ame_util.serialItems,
397: ame_util.parallelItems
398: ) then
399: fnd_message.set_name('PER','AME_400766_INV_PARAM_MODE');
400: fnd_message.raise_error;
401: end if;
402: end if;
403: hr_utility.set_location(' Leaving:'||l_proc,30);
404: exception

Line 459: fnd_message.set_name('PER','AME_400767_INV_SUBLIST_MODE');

455: ,ame_util.parallelSublists
456: ,ame_util.preFirst
457: ,ame_util.preAndAuthorityFirst
458: ) then
459: fnd_message.set_name('PER','AME_400767_INV_SUBLIST_MODE');
460: fnd_message.raise_error;
461: end if;
462: end if;
463: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 460: fnd_message.raise_error;

456: ,ame_util.preFirst
457: ,ame_util.preAndAuthorityFirst
458: ) then
459: fnd_message.set_name('PER','AME_400767_INV_SUBLIST_MODE');
460: fnd_message.raise_error;
461: end if;
462: end if;
463: hr_utility.set_location(' Leaving:'||l_proc,30);
464: exception

Line 513: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');

509: );
510: -- check if order_number is negative
511: --
512: if p_order_number <=0 then
513: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');
514: fnd_message.raise_error;
515: end if;
516: hr_utility.set_location(' Leaving:'||l_proc,30);
517: exception

Line 514: fnd_message.raise_error;

510: -- check if order_number is negative
511: --
512: if p_order_number <=0 then
513: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');
514: fnd_message.raise_error;
515: end if;
516: hr_utility.set_location(' Leaving:'||l_proc,30);
517: exception
518: when app_exception.application_exception then

Line 573: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

569: ,p_application_id => p_rec.application_id
570: ,p_effective_date => p_effective_date
571: ,p_object_version_number => p_rec.object_version_number
572: ) THEN
573: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE ', l_proc);
575: fnd_message.set_token('STEP ', '5');
576: fnd_message.raise_error;
577: END IF;

Line 574: fnd_message.set_token('PROCEDURE ', l_proc);

570: ,p_effective_date => p_effective_date
571: ,p_object_version_number => p_rec.object_version_number
572: ) THEN
573: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE ', l_proc);
575: fnd_message.set_token('STEP ', '5');
576: fnd_message.raise_error;
577: END IF;
578: --

Line 575: fnd_message.set_token('STEP ', '5');

571: ,p_object_version_number => p_rec.object_version_number
572: ) THEN
573: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE ', l_proc);
575: fnd_message.set_token('STEP ', '5');
576: fnd_message.raise_error;
577: END IF;
578: --
579: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 576: fnd_message.raise_error;

572: ) THEN
573: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE ', l_proc);
575: fnd_message.set_token('STEP ', '5');
576: fnd_message.raise_error;
577: END IF;
578: --
579: -- EDIT_HERE: Add checks to ensure non-updateable args have
580: -- not been updated.

Line 681: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

677: --
678: -- An unhandled or unexpected error has occurred which
679: -- we must report
680: --
681: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
682: fnd_message.set_token('PROCEDURE', l_proc);
683: fnd_message.set_token('STEP','15');
684: fnd_message.raise_error;
685: End dt_update_validate;

Line 682: fnd_message.set_token('PROCEDURE', l_proc);

678: -- An unhandled or unexpected error has occurred which
679: -- we must report
680: --
681: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
682: fnd_message.set_token('PROCEDURE', l_proc);
683: fnd_message.set_token('STEP','15');
684: fnd_message.raise_error;
685: End dt_update_validate;
686: --

Line 683: fnd_message.set_token('STEP','15');

679: -- we must report
680: --
681: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
682: fnd_message.set_token('PROCEDURE', l_proc);
683: fnd_message.set_token('STEP','15');
684: fnd_message.raise_error;
685: End dt_update_validate;
686: --
687: -- ----------------------------------------------------------------------------

Line 684: fnd_message.raise_error;

680: --
681: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
682: fnd_message.set_token('PROCEDURE', l_proc);
683: fnd_message.set_token('STEP','15');
684: fnd_message.raise_error;
685: End dt_update_validate;
686: --
687: -- ----------------------------------------------------------------------------
688: -- |--------------------------< dt_delete_validate >--------------------------|

Line 792: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

788: --
789: -- An unhandled or unexpected error has occurred which
790: -- we must report
791: --
792: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
793: fnd_message.set_token('PROCEDURE', l_proc);
794: fnd_message.set_token('STEP','15');
795: fnd_message.raise_error;
796: --

Line 793: fnd_message.set_token('PROCEDURE', l_proc);

789: -- An unhandled or unexpected error has occurred which
790: -- we must report
791: --
792: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
793: fnd_message.set_token('PROCEDURE', l_proc);
794: fnd_message.set_token('STEP','15');
795: fnd_message.raise_error;
796: --
797: End dt_delete_validate;

Line 794: fnd_message.set_token('STEP','15');

790: -- we must report
791: --
792: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
793: fnd_message.set_token('PROCEDURE', l_proc);
794: fnd_message.set_token('STEP','15');
795: fnd_message.raise_error;
796: --
797: End dt_delete_validate;
798: --

Line 795: fnd_message.raise_error;

791: --
792: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
793: fnd_message.set_token('PROCEDURE', l_proc);
794: fnd_message.set_token('STEP','15');
795: fnd_message.raise_error;
796: --
797: End dt_delete_validate;
798: --
799: -- ----------------------------------------------------------------------------