DBA Data[Home] [Help]

APPS.AME_ACT_BUS dependencies on FND_MESSAGE

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

64: ,p_action_type_id => p_rec.action_type_id
65: ,p_effective_date => p_effective_date
66: ,p_object_version_number => p_rec.object_version_number
67: ) THEN
68: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE ', l_proc);
70: fnd_message.set_token('STEP ', '5');
71: fnd_message.raise_error;
72: END IF;

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

65: ,p_effective_date => p_effective_date
66: ,p_object_version_number => p_rec.object_version_number
67: ) THEN
68: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE ', l_proc);
70: fnd_message.set_token('STEP ', '5');
71: fnd_message.raise_error;
72: END IF;
73: --

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

66: ,p_object_version_number => p_rec.object_version_number
67: ) THEN
68: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE ', l_proc);
70: fnd_message.set_token('STEP ', '5');
71: fnd_message.raise_error;
72: END IF;
73: --
74: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 71: fnd_message.raise_error;

67: ) THEN
68: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE ', l_proc);
70: fnd_message.set_token('STEP ', '5');
71: fnd_message.raise_error;
72: END IF;
73: --
74: -- EDIT_HERE: Add checks to ensure non-updateable args have
75: -- not been updated.

Line 179: fnd_message.set_name('PER','AME_400575_ACT_TYP_NOT_EXIST');

175: open c_sel1;
176: fetch c_sel1 into l_exists;
177: if c_sel1%notfound then
178: close c_sel1;
179: fnd_message.set_name('PER','AME_400575_ACT_TYP_NOT_EXIST');
180: -- Need message here
181: fnd_message.raise_error;
182: end if;
183: close c_sel1;

Line 181: fnd_message.raise_error;

177: if c_sel1%notfound then
178: close c_sel1;
179: fnd_message.set_name('PER','AME_400575_ACT_TYP_NOT_EXIST');
180: -- Need message here
181: fnd_message.raise_error;
182: end if;
183: close c_sel1;
184: exception
185: when app_exception.application_exception then

Line 208: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

204: l_number := to_number(p_string);
205: l_integer := l_number;
206: if(l_integer <> l_number
207: or l_number <=0 ) then
208: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
209: fnd_message.raise_error;
210: end if;
211: exception
212: when others then

Line 209: fnd_message.raise_error;

205: l_integer := l_number;
206: if(l_integer <> l_number
207: or l_number <=0 ) then
208: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
209: fnd_message.raise_error;
210: end if;
211: exception
212: when others then
213: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

Line 213: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

209: fnd_message.raise_error;
210: end if;
211: exception
212: when others then
213: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
214: fnd_message.raise_error;
215: end chk_positive_integer;
216: --
217: -- ---------------------------------------------------------------------------

Line 214: fnd_message.raise_error;

210: end if;
211: exception
212: when others then
213: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
214: fnd_message.raise_error;
215: end chk_positive_integer;
216: --
217: -- ---------------------------------------------------------------------------
218: -- |----------------------< chk_parameter >----------------------|

Line 279: fnd_message.set_name('PER','AME_400775_ACT_PARAM_NO_SC');

275: ,p_argument => 'parameter'
276: ,p_argument_value => p_parameter
277: );
278: if(p_parameter like '%;%') THEN
279: fnd_message.set_name('PER','AME_400775_ACT_PARAM_NO_SC');
280: -- Message needed
281: fnd_message.raise_error;
282: end if;
283: select count(action_id)

Line 281: fnd_message.raise_error;

277: );
278: if(p_parameter like '%;%') THEN
279: fnd_message.set_name('PER','AME_400775_ACT_PARAM_NO_SC');
280: -- Message needed
281: fnd_message.raise_error;
282: end if;
283: select count(action_id)
284: into l_par_count
285: from ame_actions

Line 294: fnd_message.set_name('PER','AME_400604_DUP_ACTION_PARAM');

290: nvl(end_date - ame_util.oneSecond, p_effective_date) and
291: (p_action_id is null or
292: action_id <> p_action_id);
293: if(l_par_count <> 0) then
294: fnd_message.set_name('PER','AME_400604_DUP_ACTION_PARAM');
295: fnd_message.raise_error;
296: end if;
297: select name
298: into l_action_type_name

Line 295: fnd_message.raise_error;

291: (p_action_id is null or
292: action_id <> p_action_id);
293: if(l_par_count <> 0) then
294: fnd_message.set_name('PER','AME_400604_DUP_ACTION_PARAM');
295: fnd_message.raise_error;
296: end if;
297: select name
298: into l_action_type_name
299: from ame_action_types

Line 311: fnd_message.set_name('PER','AME_400605_INV_LM_ACTION_PARAM');

307: if c_sel1%notfound then
308: close c_sel1;
309: -- AT MESSAGE
310: -- The name is not valid (doesn't exist in wf_roles.name).
311: fnd_message.set_name('PER','AME_400605_INV_LM_ACTION_PARAM');
312: fnd_message.raise_error;
313: end if;
314: close c_sel1;
315: elsif (l_action_type_name in (

Line 312: fnd_message.raise_error;

308: close c_sel1;
309: -- AT MESSAGE
310: -- The name is not valid (doesn't exist in wf_roles.name).
311: fnd_message.set_name('PER','AME_400605_INV_LM_ACTION_PARAM');
312: fnd_message.raise_error;
313: end if;
314: close c_sel1;
315: elsif (l_action_type_name in (
316: 'absolute job level'

Line 325: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

321: ) then
322: --parameter should be of the form n{+,-}
323: if(substr(p_parameter, length(p_parameter), 1) <> '+'
324: and substr(p_parameter, length(p_parameter), 1) <> '-') then
325: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
326: fnd_message.raise_error;
327: end if;
328: --check if the other part of parameter excluding +,- is a valid
329: --number

Line 326: fnd_message.raise_error;

322: --parameter should be of the form n{+,-}
323: if(substr(p_parameter, length(p_parameter), 1) <> '+'
324: and substr(p_parameter, length(p_parameter), 1) <> '-') then
325: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
326: fnd_message.raise_error;
327: end if;
328: --check if the other part of parameter excluding +,- is a valid
329: --number
330: chk_positive_integer(substr(p_parameter, 1, length(p_parameter)-1));

Line 340: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

336: --parameter should be in the form {A, R}n{+,-}
337: if(substr(p_parameter,1,1) <> 'A'
338: and substr(p_parameter,1,1) <> 'R'
339: ) then
340: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
341: fnd_message.raise_error;
342: end if;
343: if(substr(p_parameter, length(p_parameter), 1) <> '+'
344: and substr(p_parameter, length(p_parameter), 1) <> '-') then

Line 341: fnd_message.raise_error;

337: if(substr(p_parameter,1,1) <> 'A'
338: and substr(p_parameter,1,1) <> 'R'
339: ) then
340: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
341: fnd_message.raise_error;
342: end if;
343: if(substr(p_parameter, length(p_parameter), 1) <> '+'
344: and substr(p_parameter, length(p_parameter), 1) <> '-') then
345: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

Line 345: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

341: fnd_message.raise_error;
342: end if;
343: if(substr(p_parameter, length(p_parameter), 1) <> '+'
344: and substr(p_parameter, length(p_parameter), 1) <> '-') then
345: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
346: fnd_message.raise_error;
347: end if;
348: --check if the string between {A,R} and {+,-} is a valid number
349: chk_positive_integer(substr(p_parameter, 2, length(p_parameter)-2));

Line 346: fnd_message.raise_error;

342: end if;
343: if(substr(p_parameter, length(p_parameter), 1) <> '+'
344: and substr(p_parameter, length(p_parameter), 1) <> '-') then
345: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
346: fnd_message.raise_error;
347: end if;
348: --check if the string between {A,R} and {+,-} is a valid number
349: chk_positive_integer(substr(p_parameter, 2, length(p_parameter)-2));
350: elsif (l_action_type_name = 'dual chains of authority') then

Line 354: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

350: elsif (l_action_type_name = 'dual chains of authority') then
351: --parameter should be in the form {1,2}{A, R}n{+,-}
352: if(substr(p_parameter,1,1) <> '1'
353: and substr(p_parameter,1,1) <> '2') then
354: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
355: fnd_message.raise_error;
356: end if;
357: if(substr(p_parameter,2,1) <> 'A'
358: and substr(p_parameter,2,1) <> 'R'

Line 355: fnd_message.raise_error;

351: --parameter should be in the form {1,2}{A, R}n{+,-}
352: if(substr(p_parameter,1,1) <> '1'
353: and substr(p_parameter,1,1) <> '2') then
354: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
355: fnd_message.raise_error;
356: end if;
357: if(substr(p_parameter,2,1) <> 'A'
358: and substr(p_parameter,2,1) <> 'R'
359: ) then

Line 360: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

356: end if;
357: if(substr(p_parameter,2,1) <> 'A'
358: and substr(p_parameter,2,1) <> 'R'
359: ) then
360: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
361: fnd_message.raise_error;
362: end if;
363: if(substr(p_parameter, length(p_parameter), 1) <> '+'
364: and substr(p_parameter, length(p_parameter), 1) <> '-') then

Line 361: fnd_message.raise_error;

357: if(substr(p_parameter,2,1) <> 'A'
358: and substr(p_parameter,2,1) <> 'R'
359: ) then
360: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
361: fnd_message.raise_error;
362: end if;
363: if(substr(p_parameter, length(p_parameter), 1) <> '+'
364: and substr(p_parameter, length(p_parameter), 1) <> '-') then
365: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

Line 365: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

361: fnd_message.raise_error;
362: end if;
363: if(substr(p_parameter, length(p_parameter), 1) <> '+'
364: and substr(p_parameter, length(p_parameter), 1) <> '-') then
365: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
366: fnd_message.raise_error;
367: end if;
368: --check if the string between {1,2}{A,R} and {+,-} is a valid number
369: chk_positive_integer(substr(p_parameter, 3, length(p_parameter)-3));

Line 366: fnd_message.raise_error;

362: end if;
363: if(substr(p_parameter, length(p_parameter), 1) <> '+'
364: and substr(p_parameter, length(p_parameter), 1) <> '-') then
365: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
366: fnd_message.raise_error;
367: end if;
368: --check if the string between {1,2}{A,R} and {+,-} is a valid number
369: chk_positive_integer(substr(p_parameter, 3, length(p_parameter)-3));
370: elsif (l_action_type_name = 'supervisory level') then

Line 379: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

375: chk_positive_integer(p_parameter);
376: end if;
377: elsif(l_action_type_name = 'hr position level') then
378: if(substr(p_parameter, length(p_parameter), 1) <> '+') then
379: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
380: fnd_message.raise_error;
381: end if;
382: chk_positive_integer(substr(p_parameter, 1, length(p_parameter)-1) );
383: elsif (l_action_type_name = 'final authority') then

Line 380: fnd_message.raise_error;

376: end if;
377: elsif(l_action_type_name = 'hr position level') then
378: if(substr(p_parameter, length(p_parameter), 1) <> '+') then
379: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
380: fnd_message.raise_error;
381: end if;
382: chk_positive_integer(substr(p_parameter, 1, length(p_parameter)-1) );
383: elsif (l_action_type_name = 'final authority') then
384: --cannot create actions for final authority

Line 385: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');

381: end if;
382: chk_positive_integer(substr(p_parameter, 1, length(p_parameter)-1) );
383: elsif (l_action_type_name = 'final authority') then
384: --cannot create actions for final authority
385: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
386: fnd_message.raise_error;
387: end if;
388: exception
389: when app_exception.application_exception then

Line 386: fnd_message.raise_error;

382: chk_positive_integer(substr(p_parameter, 1, length(p_parameter)-1) );
383: elsif (l_action_type_name = 'final authority') then
384: --cannot create actions for final authority
385: fnd_message.set_name('PER','AME_400603_INVALID_ACT_PARAM');
386: fnd_message.raise_error;
387: end if;
388: exception
389: when app_exception.application_exception then
390: if hr_multi_message.exception_add

Line 447: fnd_message.set_name('PER','AME_400606_DYN_ACT_TYP_ACT_DES');

443: p_effective_date between start_date and
444: nvl(end_date - ame_util.oneSecond, p_effective_date);
445: IF dynamicDescription = ame_util.booleanFalse THEN
446: IF p_description is null THEN
447: fnd_message.set_name('PER','AME_400606_DYN_ACT_TYP_ACT_DES');
448: -- Message needed
449: fnd_message.raise_error;
450: END IF;
451: ELSif p_description is not null THEN

Line 449: fnd_message.raise_error;

445: IF dynamicDescription = ame_util.booleanFalse THEN
446: IF p_description is null THEN
447: fnd_message.set_name('PER','AME_400606_DYN_ACT_TYP_ACT_DES');
448: -- Message needed
449: fnd_message.raise_error;
450: END IF;
451: ELSif p_description is not null THEN
452: fnd_message.set_name('PER','AME_400606_DYN_ACT_TYP_ACT_DES');
453: -- Message needed

Line 452: fnd_message.set_name('PER','AME_400606_DYN_ACT_TYP_ACT_DES');

448: -- Message needed
449: fnd_message.raise_error;
450: END IF;
451: ELSif p_description is not null THEN
452: fnd_message.set_name('PER','AME_400606_DYN_ACT_TYP_ACT_DES');
453: -- Message needed
454: fnd_message.raise_error;
455: END IF;
456: exception

Line 454: fnd_message.raise_error;

450: END IF;
451: ELSif p_description is not null THEN
452: fnd_message.set_name('PER','AME_400606_DYN_ACT_TYP_ACT_DES');
453: -- Message needed
454: fnd_message.raise_error;
455: END IF;
456: exception
457: when app_exception.application_exception then
458: if hr_multi_message.exception_add

Line 519: fnd_message.set_name('PER','AME_400477_CANNOT_DEL_SEEDED');

515: fetch c_sel1 into l_exists;
516: if c_sel1%found then
517: close c_sel1;
518: --
519: fnd_message.set_name('PER','AME_400477_CANNOT_DEL_SEEDED');
520: -- Message needed
521: fnd_message.set_token('OBJECT','AME_ACTIONS.DELETE');
522: fnd_message.raise_error;
523: end if;

Line 521: fnd_message.set_token('OBJECT','AME_ACTIONS.DELETE');

517: close c_sel1;
518: --
519: fnd_message.set_name('PER','AME_400477_CANNOT_DEL_SEEDED');
520: -- Message needed
521: fnd_message.set_token('OBJECT','AME_ACTIONS.DELETE');
522: fnd_message.raise_error;
523: end if;
524: close c_sel1;
525: exception

Line 522: fnd_message.raise_error;

518: --
519: fnd_message.set_name('PER','AME_400477_CANNOT_DEL_SEEDED');
520: -- Message needed
521: fnd_message.set_token('OBJECT','AME_ACTIONS.DELETE');
522: fnd_message.raise_error;
523: end if;
524: close c_sel1;
525: exception
526: when app_exception.application_exception then

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

600: --
601: -- An unhandled or unexpected error has occurred which
602: -- we must report
603: --
604: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
605: fnd_message.set_token('PROCEDURE', l_proc);
606: fnd_message.set_token('STEP','15');
607: fnd_message.raise_error;
608: End dt_update_validate;

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

601: -- An unhandled or unexpected error has occurred which
602: -- we must report
603: --
604: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
605: fnd_message.set_token('PROCEDURE', l_proc);
606: fnd_message.set_token('STEP','15');
607: fnd_message.raise_error;
608: End dt_update_validate;
609: --

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

602: -- we must report
603: --
604: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
605: fnd_message.set_token('PROCEDURE', l_proc);
606: fnd_message.set_token('STEP','15');
607: fnd_message.raise_error;
608: End dt_update_validate;
609: --
610: -- ----------------------------------------------------------------------------

Line 607: fnd_message.raise_error;

603: --
604: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
605: fnd_message.set_token('PROCEDURE', l_proc);
606: fnd_message.set_token('STEP','15');
607: fnd_message.raise_error;
608: End dt_update_validate;
609: --
610: -- ----------------------------------------------------------------------------
611: -- |--------------------------< dt_delete_validate >--------------------------|

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

702: --
703: -- An unhandled or unexpected error has occurred which
704: -- we must report
705: --
706: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
707: fnd_message.set_token('PROCEDURE', l_proc);
708: fnd_message.set_token('STEP','15');
709: fnd_message.raise_error;
710: --

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

703: -- An unhandled or unexpected error has occurred which
704: -- we must report
705: --
706: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
707: fnd_message.set_token('PROCEDURE', l_proc);
708: fnd_message.set_token('STEP','15');
709: fnd_message.raise_error;
710: --
711: End dt_delete_validate;

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

704: -- we must report
705: --
706: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
707: fnd_message.set_token('PROCEDURE', l_proc);
708: fnd_message.set_token('STEP','15');
709: fnd_message.raise_error;
710: --
711: End dt_delete_validate;
712: --

Line 709: fnd_message.raise_error;

705: --
706: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
707: fnd_message.set_token('PROCEDURE', l_proc);
708: fnd_message.set_token('STEP','15');
709: fnd_message.raise_error;
710: --
711: End dt_delete_validate;
712: --
713: -- ----------------------------------------------------------------------------