DBA Data[Home] [Help]

APPS.AME_ATY_BUS dependencies on FND_MESSAGE

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

59: (p_action_type_id => p_rec.action_type_id
60: ,p_effective_date => p_effective_date
61: ,p_object_version_number => p_rec.object_version_number
62: ) THEN
63: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE ', l_proc);
65: fnd_message.set_token('STEP ', '5');
66: fnd_message.raise_error;
67: END IF;

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

60: ,p_effective_date => p_effective_date
61: ,p_object_version_number => p_rec.object_version_number
62: ) THEN
63: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE ', l_proc);
65: fnd_message.set_token('STEP ', '5');
66: fnd_message.raise_error;
67: END IF;
68: -- EDIT_HERE: Add checks to ensure non-updateable args have

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

61: ,p_object_version_number => p_rec.object_version_number
62: ) THEN
63: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE ', l_proc);
65: fnd_message.set_token('STEP ', '5');
66: fnd_message.raise_error;
67: END IF;
68: -- EDIT_HERE: Add checks to ensure non-updateable args have
69: -- not been updated.

Line 66: fnd_message.raise_error;

62: ) THEN
63: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE ', l_proc);
65: fnd_message.set_token('STEP ', '5');
66: fnd_message.raise_error;
67: END IF;
68: -- EDIT_HERE: Add checks to ensure non-updateable args have
69: -- not been updated.
70: select ame_utility_pkg.is_seed_user(created_by)

Line 173: fnd_message.set_name('PER','AME_400610_ACT_TYP_NAME_EXISTS');

169: if c_sel1%found then
170: close c_sel1;
171: -- AT MESSAGE
172: -- The action type name specified is already exists
173: fnd_message.set_name('PER','AME_400610_ACT_TYP_NAME_EXISTS');
174: fnd_message.raise_error;
175: end if;
176: close c_sel1;
177: exception

Line 174: fnd_message.raise_error;

170: close c_sel1;
171: -- AT MESSAGE
172: -- The action type name specified is already exists
173: fnd_message.set_name('PER','AME_400610_ACT_TYP_NAME_EXISTS');
174: fnd_message.raise_error;
175: end if;
176: close c_sel1;
177: exception
178: when app_exception.application_exception then

Line 291: fnd_message.set_name('PER','AME_400611_ACT_TYP_HAND_EXISTS');

287: if c_sel1%found then
288: close c_sel1;
289: -- AT MESSAGE
290: -- The procedure name specified already exists
291: fnd_message.set_name('PER','AME_400611_ACT_TYP_HAND_EXISTS');
292: fnd_message.raise_error;
293: end if;
294: close c_sel1;
295: */

Line 292: fnd_message.raise_error;

288: close c_sel1;
289: -- AT MESSAGE
290: -- The procedure name specified already exists
291: fnd_message.set_name('PER','AME_400611_ACT_TYP_HAND_EXISTS');
292: fnd_message.raise_error;
293: end if;
294: close c_sel1;
295: */
296: exception

Line 345: fnd_message.set_name('PAY','HR_7777_INVALID_PRIMARY_KEY');

341: if p_dynamic_description not in (ame_util.booleanTrue,
342: ame_util.booleanFalse) then
343: -- AT MESSAGE
344: -- The dynamic description specified is invalid
345: fnd_message.set_name('PAY','HR_7777_INVALID_PRIMARY_KEY');
346: fnd_message.raise_error;
347: end if;
348: exception
349: when app_exception.application_exception then

Line 346: fnd_message.raise_error;

342: ame_util.booleanFalse) then
343: -- AT MESSAGE
344: -- The dynamic description specified is invalid
345: fnd_message.set_name('PAY','HR_7777_INVALID_PRIMARY_KEY');
346: fnd_message.raise_error;
347: end if;
348: exception
349: when app_exception.application_exception then
350: if hr_multi_message.exception_add

Line 405: fnd_message.set_name('PER','AME_400372_ACT_DYNAMIC_DESC2');

401: IF(instrb(p_description_query, ';', 1, 1) > 0) or
402: (instrb(p_description_query, '--', 1, 1) > 0) or
403: (instrb(p_description_query, '/*', 1, 1) > 0) or
404: (instrb(p_description_query, '*/', 1, 1) > 0) then
405: fnd_message.set_name('PER','AME_400372_ACT_DYNAMIC_DESC2');
406: fnd_message.raise_error;
407: END IF;
408: /* Verify that the description query includes at least one of the bind variables */
409: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then

Line 406: fnd_message.raise_error;

402: (instrb(p_description_query, '--', 1, 1) > 0) or
403: (instrb(p_description_query, '/*', 1, 1) > 0) or
404: (instrb(p_description_query, '*/', 1, 1) > 0) then
405: fnd_message.set_name('PER','AME_400372_ACT_DYNAMIC_DESC2');
406: fnd_message.raise_error;
407: END IF;
408: /* Verify that the description query includes at least one of the bind variables */
409: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then
410: IF(instrb(p_description_query, ame_util.actionParameterTwo, 1, 1) = 0) then

Line 411: fnd_message.set_name('PER', 'AME_400370_ACT_DYNAMIC_DESC');

407: END IF;
408: /* Verify that the description query includes at least one of the bind variables */
409: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then
410: IF(instrb(p_description_query, ame_util.actionParameterTwo, 1, 1) = 0) then
411: fnd_message.set_name('PER', 'AME_400370_ACT_DYNAMIC_DESC');
412: fnd_message.raise_error;
413: END IF;
414: END IF;
415: IF(instrb(p_description_query, ':', 1, 1) > 0) then

Line 412: fnd_message.raise_error;

408: /* Verify that the description query includes at least one of the bind variables */
409: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then
410: IF(instrb(p_description_query, ame_util.actionParameterTwo, 1, 1) = 0) then
411: fnd_message.set_name('PER', 'AME_400370_ACT_DYNAMIC_DESC');
412: fnd_message.raise_error;
413: END IF;
414: END IF;
415: IF(instrb(p_description_query, ':', 1, 1) > 0) then
416: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then

Line 418: fnd_message.set_name('PER', 'AME_400371_ACT_INV_BIND_VAR');

414: END IF;
415: IF(instrb(p_description_query, ':', 1, 1) > 0) then
416: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then
417: IF(instrb(p_description_query, ame_util.actionParameterTwo, 1, 1) = 0) then
418: fnd_message.set_name('PER', 'AME_400371_ACT_INV_BIND_VAR');
419: fnd_message.raise_error;
420: END IF;
421: END IF;
422: END IF;

Line 419: fnd_message.raise_error;

415: IF(instrb(p_description_query, ':', 1, 1) > 0) then
416: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then
417: IF(instrb(p_description_query, ame_util.actionParameterTwo, 1, 1) = 0) then
418: fnd_message.set_name('PER', 'AME_400371_ACT_INV_BIND_VAR');
419: fnd_message.raise_error;
420: END IF;
421: END IF;
422: END IF;
423: ame_util.checkForSqlInjection(queryStringIn => upper(p_description_query));

Line 429: fnd_message.raise_error;

425: ,p_columns => 1
426: ,p_object => ame_util2.actionTypeObject
427: );
428: if l_valid <> 'Y' then
429: fnd_message.raise_error;
430: end if;
431: ELSE
432: if(p_description_query is not null) then
433: fnd_message.set_name('PER', 'AME_400721_ACT_DYN_DESC_NULL');

Line 433: fnd_message.set_name('PER', 'AME_400721_ACT_DYN_DESC_NULL');

429: fnd_message.raise_error;
430: end if;
431: ELSE
432: if(p_description_query is not null) then
433: fnd_message.set_name('PER', 'AME_400721_ACT_DYN_DESC_NULL');
434: fnd_message.raise_error;
435: end if;
436: END IF;
437: exception

Line 434: fnd_message.raise_error;

430: end if;
431: ELSE
432: if(p_description_query is not null) then
433: fnd_message.set_name('PER', 'AME_400721_ACT_DYN_DESC_NULL');
434: fnd_message.raise_error;
435: end if;
436: END IF;
437: exception
438: when app_exception.application_exception then

Line 538: fnd_message.set_name('PER','AME_400597_ACT_TYPE_USG_EXIST');

534: close c_sel1;
535: -- AT MESSAGE
536: -- An action type usage(s) still exists. You must first delete the action type usage(s)
537: -- before deleting the action type
538: fnd_message.set_name('PER','AME_400597_ACT_TYPE_USG_EXIST');
539: fnd_message.raise_error;
540: end if;
541: close c_sel1;
542: open c_sel2;

Line 539: fnd_message.raise_error;

535: -- AT MESSAGE
536: -- An action type usage(s) still exists. You must first delete the action type usage(s)
537: -- before deleting the action type
538: fnd_message.set_name('PER','AME_400597_ACT_TYPE_USG_EXIST');
539: fnd_message.raise_error;
540: end if;
541: close c_sel1;
542: open c_sel2;
543: fetch c_sel2 into l_exists;

Line 549: fnd_message.set_name('PER','AME_400608_ACT_TYP_CONF_EXISTS');

545: close c_sel2;
546: -- AT MESSAGE
547: -- An action type config(s) still exists. You must first delete the action type config(s)
548: -- before deleting the action type
549: fnd_message.set_name('PER','AME_400608_ACT_TYP_CONF_EXISTS');
550: fnd_message.raise_error;
551: end if;
552: close c_sel2;
553: open c_sel3;

Line 550: fnd_message.raise_error;

546: -- AT MESSAGE
547: -- An action type config(s) still exists. You must first delete the action type config(s)
548: -- before deleting the action type
549: fnd_message.set_name('PER','AME_400608_ACT_TYP_CONF_EXISTS');
550: fnd_message.raise_error;
551: end if;
552: close c_sel2;
553: open c_sel3;
554: fetch c_sel3 into l_exists;

Line 560: fnd_message.set_name('PER','AME_400612_APPR_USG_EXISTS');

556: close c_sel3;
557: -- AT MESSAGE
558: -- An apporver type usage(s) still exists. You must first delete the approver type usage(s)
559: -- before deleting the action type
560: fnd_message.set_name('PER','AME_400612_APPR_USG_EXISTS');
561: fnd_message.raise_error;
562: end if;
563: close c_sel3;
564: open c_sel4;

Line 561: fnd_message.raise_error;

557: -- AT MESSAGE
558: -- An apporver type usage(s) still exists. You must first delete the approver type usage(s)
559: -- before deleting the action type
560: fnd_message.set_name('PER','AME_400612_APPR_USG_EXISTS');
561: fnd_message.raise_error;
562: end if;
563: close c_sel3;
564: open c_sel4;
565: fetch c_sel4 into l_exists;

Line 571: fnd_message.set_name('PER','AME_400613_REQ_ATTR_EXISTS');

567: close c_sel4;
568: -- AT MESSAGE
569: -- Required attribute(s) still exists. You must first delete the required attribute(s)
570: -- before deleting the action type
571: fnd_message.set_name('PER','AME_400613_REQ_ATTR_EXISTS');
572: fnd_message.raise_error;
573: end if;
574: close c_sel4;
575: -- Seeded action types cannot be deleted

Line 572: fnd_message.raise_error;

568: -- AT MESSAGE
569: -- Required attribute(s) still exists. You must first delete the required attribute(s)
570: -- before deleting the action type
571: fnd_message.set_name('PER','AME_400613_REQ_ATTR_EXISTS');
572: fnd_message.raise_error;
573: end if;
574: close c_sel4;
575: -- Seeded action types cannot be deleted
576: open c_sel5;

Line 582: fnd_message.set_name('PER','AME_400601_SD_ACT_TYP_CN_DEL');

578: if c_sel5%found then
579: close c_sel5;
580: -- AT MESSAGE
581: -- Seeded action types cannot be deleted
582: fnd_message.set_name('PER','AME_400601_SD_ACT_TYP_CN_DEL');
583: fnd_message.set_token('TABLE_NAME','ame_action_types');
584: fnd_message.raise_error;
585: end if;
586: close c_sel5;

Line 583: fnd_message.set_token('TABLE_NAME','ame_action_types');

579: close c_sel5;
580: -- AT MESSAGE
581: -- Seeded action types cannot be deleted
582: fnd_message.set_name('PER','AME_400601_SD_ACT_TYP_CN_DEL');
583: fnd_message.set_token('TABLE_NAME','ame_action_types');
584: fnd_message.raise_error;
585: end if;
586: close c_sel5;
587: -- Action types with existing actions cannot be deleted.

Line 584: fnd_message.raise_error;

580: -- AT MESSAGE
581: -- Seeded action types cannot be deleted
582: fnd_message.set_name('PER','AME_400601_SD_ACT_TYP_CN_DEL');
583: fnd_message.set_token('TABLE_NAME','ame_action_types');
584: fnd_message.raise_error;
585: end if;
586: close c_sel5;
587: -- Action types with existing actions cannot be deleted.
588: open c_sel6;

Line 594: fnd_message.set_name('PER','AME_400602_ACT_EXT_ATYP_CN_DEL');

590: if c_sel6%found then
591: close c_sel6;
592: -- AT MESSAGE
593: -- Action types with existing actions cannot be deleted
594: fnd_message.set_name('PER','AME_400602_ACT_EXT_ATYP_CN_DEL');
595: fnd_message.set_token('TABLE_NAME','ame_action_types');
596: fnd_message.raise_error;
597: end if;
598: close c_sel6;

Line 595: fnd_message.set_token('TABLE_NAME','ame_action_types');

591: close c_sel6;
592: -- AT MESSAGE
593: -- Action types with existing actions cannot be deleted
594: fnd_message.set_name('PER','AME_400602_ACT_EXT_ATYP_CN_DEL');
595: fnd_message.set_token('TABLE_NAME','ame_action_types');
596: fnd_message.raise_error;
597: end if;
598: close c_sel6;
599: exception

Line 596: fnd_message.raise_error;

592: -- AT MESSAGE
593: -- Action types with existing actions cannot be deleted
594: fnd_message.set_name('PER','AME_400602_ACT_EXT_ATYP_CN_DEL');
595: fnd_message.set_token('TABLE_NAME','ame_action_types');
596: fnd_message.raise_error;
597: end if;
598: close c_sel6;
599: exception
600: when app_exception.application_exception then

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

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

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

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

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

675: -- we must report
676: --
677: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
678: fnd_message.set_token('PROCEDURE', l_proc);
679: fnd_message.set_token('STEP','15');
680: fnd_message.raise_error;
681: End dt_update_validate;
682: --
683: -- ----------------------------------------------------------------------------

Line 680: fnd_message.raise_error;

676: --
677: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
678: fnd_message.set_token('PROCEDURE', l_proc);
679: fnd_message.set_token('STEP','15');
680: fnd_message.raise_error;
681: End dt_update_validate;
682: --
683: -- ----------------------------------------------------------------------------
684: -- |--------------------------< dt_delete_validate >--------------------------|

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

774: --
775: -- An unhandled or unexpected error has occurred which
776: -- we must report
777: --
778: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
779: fnd_message.set_token('PROCEDURE', l_proc);
780: fnd_message.set_token('STEP','15');
781: fnd_message.raise_error;
782: --

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

775: -- An unhandled or unexpected error has occurred which
776: -- we must report
777: --
778: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
779: fnd_message.set_token('PROCEDURE', l_proc);
780: fnd_message.set_token('STEP','15');
781: fnd_message.raise_error;
782: --
783: End dt_delete_validate;

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

776: -- we must report
777: --
778: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
779: fnd_message.set_token('PROCEDURE', l_proc);
780: fnd_message.set_token('STEP','15');
781: fnd_message.raise_error;
782: --
783: End dt_delete_validate;
784: --

Line 781: fnd_message.raise_error;

777: --
778: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
779: fnd_message.set_token('PROCEDURE', l_proc);
780: fnd_message.set_token('STEP','15');
781: fnd_message.raise_error;
782: --
783: End dt_delete_validate;
784: --
785: -- ----------------------------------------------------------------------------