DBA Data[Home] [Help]

APPS.AME_CFV_BUS dependencies on FND_MESSAGE

Line 69: fnd_message.set_name('PER', 'AME_400653_CFV_NONUPD_VAL_YN');

65: fetch csr_variable_value into l_oldVal;
66: end if;
67: close csr_variable_value;
68: if(l_oldVal = 'yes' and (p_variable_value is null or p_variable_value <> 'yes')) then
69: fnd_message.set_name('PER', 'AME_400653_CFV_NONUPD_VAL_YN');
70: fnd_message.set_token('VARNAME',p_variable_name);
71: fnd_message.raise_error;
72: end if;
73: elsif(p_variable_name = 'productionFunctionality') then

Line 70: fnd_message.set_token('VARNAME',p_variable_name);

66: end if;
67: close csr_variable_value;
68: if(l_oldVal = 'yes' and (p_variable_value is null or p_variable_value <> 'yes')) then
69: fnd_message.set_name('PER', 'AME_400653_CFV_NONUPD_VAL_YN');
70: fnd_message.set_token('VARNAME',p_variable_name);
71: fnd_message.raise_error;
72: end if;
73: elsif(p_variable_name = 'productionFunctionality') then
74: open csr_variable_value(p_application_id,p_variable_name);

Line 71: fnd_message.raise_error;

67: close csr_variable_value;
68: if(l_oldVal = 'yes' and (p_variable_value is null or p_variable_value <> 'yes')) then
69: fnd_message.set_name('PER', 'AME_400653_CFV_NONUPD_VAL_YN');
70: fnd_message.set_token('VARNAME',p_variable_name);
71: fnd_message.raise_error;
72: end if;
73: elsif(p_variable_name = 'productionFunctionality') then
74: open csr_variable_value(p_application_id,p_variable_name);
75: fetch csr_variable_value into l_oldVal;

Line 83: fnd_message.set_name('PER', 'AME_400654_CFV_NONUPD_VAL_PF');

79: fetch csr_variable_value into l_oldVal;
80: end if;
81: close csr_variable_value;
82: if(l_oldVal = 'all' and (p_variable_value is null or p_variable_value <> 'all')) then
83: fnd_message.set_name('PER', 'AME_400654_CFV_NONUPD_VAL_PF');
84: fnd_message.set_token('VARNAME',p_variable_name);
85: fnd_message.raise_error;
86: end if;
87: end if;

Line 84: fnd_message.set_token('VARNAME',p_variable_name);

80: end if;
81: close csr_variable_value;
82: if(l_oldVal = 'all' and (p_variable_value is null or p_variable_value <> 'all')) then
83: fnd_message.set_name('PER', 'AME_400654_CFV_NONUPD_VAL_PF');
84: fnd_message.set_token('VARNAME',p_variable_name);
85: fnd_message.raise_error;
86: end if;
87: end if;
88: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 85: fnd_message.raise_error;

81: close csr_variable_value;
82: if(l_oldVal = 'all' and (p_variable_value is null or p_variable_value <> 'all')) then
83: fnd_message.set_name('PER', 'AME_400654_CFV_NONUPD_VAL_PF');
84: fnd_message.set_token('VARNAME',p_variable_name);
85: fnd_message.raise_error;
86: end if;
87: end if;
88: hr_utility.set_location(' Leaving:'||l_proc,30);
89: exception

Line 150: fnd_message.set_name('PER', 'AME_400474_INV_APPLICATION_ID');

146: if(p_application_id <> ame_utility_pkg.defaultAmeAppId) then
147: open csr_application;
148: fetch csr_application into l_key;
149: if(csr_application%notfound) then
150: fnd_message.set_name('PER', 'AME_400474_INV_APPLICATION_ID');
151: fnd_message.raise_error;
152: end if;
153: close csr_application;
154: end if;

Line 151: fnd_message.raise_error;

147: open csr_application;
148: fetch csr_application into l_key;
149: if(csr_application%notfound) then
150: fnd_message.set_name('PER', 'AME_400474_INV_APPLICATION_ID');
151: fnd_message.raise_error;
152: end if;
153: close csr_application;
154: end if;
155: hr_utility.set_location(' Leaving:'||l_proc,30);

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

204: Begin
205: hr_utility.set_location('Entering:'||l_proc,10);
206: --
207: if p_application_id = 0 then
208: fnd_message.set_name('PER', 'AME_400773_DEF_CONFIG_DEL');
209: fnd_message.raise_error;
210: end if;
211: exception
212: when app_exception.application_exception then

Line 209: fnd_message.raise_error;

205: hr_utility.set_location('Entering:'||l_proc,10);
206: --
207: if p_application_id = 0 then
208: fnd_message.set_name('PER', 'AME_400773_DEF_CONFIG_DEL');
209: fnd_message.raise_error;
210: end if;
211: exception
212: when app_exception.application_exception then
213: if hr_multi_message.exception_add

Line 272: fnd_message.set_name('PER', 'AME_400657_CFV_INV_VAR_NAME');

268: open csr_var_name(p_variable_name);
269: fetch csr_var_name into l_key;
270: if(csr_var_name%notfound) then
271: close csr_var_name;
272: fnd_message.set_name('PER', 'AME_400657_CFV_INV_VAR_NAME');
273: fnd_message.raise_error;
274: else
275: close csr_var_name;
276: end if;

Line 273: fnd_message.raise_error;

269: fetch csr_var_name into l_key;
270: if(csr_var_name%notfound) then
271: close csr_var_name;
272: fnd_message.set_name('PER', 'AME_400657_CFV_INV_VAR_NAME');
273: fnd_message.raise_error;
274: else
275: close csr_var_name;
276: end if;
277: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 376: fnd_message.set_name('PER', 'AME_400658_CFV_INV_NUM_PRM');

372: --
373: -- If total parameter count is not 8, then error has occurred.
374: --
375: if(l_count <> 8) then
376: fnd_message.set_name('PER', 'AME_400658_CFV_INV_NUM_PRM');
377: fnd_message.raise_error;
378: end if;
379: --
380: -- Check for the values in respective profile value tables.

Line 377: fnd_message.raise_error;

373: -- If total parameter count is not 8, then error has occurred.
374: --
375: if(l_count <> 8) then
376: fnd_message.set_name('PER', 'AME_400658_CFV_INV_NUM_PRM');
377: fnd_message.raise_error;
378: end if;
379: --
380: -- Check for the values in respective profile value tables.
381: --

Line 383: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

379: --
380: -- Check for the values in respective profile value tables.
381: --
382: if not isExist(AME_BEHAVIOUR_VALUES(1),AME_FWD_PRV_SAME_CHAIN) then
383: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
384: fnd_message.set_token('PARAMNUM',1);
385: fnd_message.raise_error;
386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then

Line 384: fnd_message.set_token('PARAMNUM',1);

380: -- Check for the values in respective profile value tables.
381: --
382: if not isExist(AME_BEHAVIOUR_VALUES(1),AME_FWD_PRV_SAME_CHAIN) then
383: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
384: fnd_message.set_token('PARAMNUM',1);
385: fnd_message.raise_error;
386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then
388: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

Line 385: fnd_message.raise_error;

381: --
382: if not isExist(AME_BEHAVIOUR_VALUES(1),AME_FWD_PRV_SAME_CHAIN) then
383: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
384: fnd_message.set_token('PARAMNUM',1);
385: fnd_message.raise_error;
386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then
388: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
389: fnd_message.set_token('PARAMNUM',2);

Line 388: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

384: fnd_message.set_token('PARAMNUM',1);
385: fnd_message.raise_error;
386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then
388: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
389: fnd_message.set_token('PARAMNUM',2);
390: fnd_message.raise_error;
391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then

Line 389: fnd_message.set_token('PARAMNUM',2);

385: fnd_message.raise_error;
386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then
388: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
389: fnd_message.set_token('PARAMNUM',2);
390: fnd_message.raise_error;
391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then
393: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

Line 390: fnd_message.raise_error;

386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then
388: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
389: fnd_message.set_token('PARAMNUM',2);
390: fnd_message.raise_error;
391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then
393: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
394: fnd_message.set_token('PARAMNUM',3);

Line 393: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

389: fnd_message.set_token('PARAMNUM',2);
390: fnd_message.raise_error;
391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then
393: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
394: fnd_message.set_token('PARAMNUM',3);
395: fnd_message.raise_error;
396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then

Line 394: fnd_message.set_token('PARAMNUM',3);

390: fnd_message.raise_error;
391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then
393: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
394: fnd_message.set_token('PARAMNUM',3);
395: fnd_message.raise_error;
396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then
398: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

Line 395: fnd_message.raise_error;

391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then
393: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
394: fnd_message.set_token('PARAMNUM',3);
395: fnd_message.raise_error;
396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then
398: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
399: fnd_message.set_token('PARAMNUM',4);

Line 398: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

394: fnd_message.set_token('PARAMNUM',3);
395: fnd_message.raise_error;
396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then
398: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
399: fnd_message.set_token('PARAMNUM',4);
400: fnd_message.raise_error;
401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then

Line 399: fnd_message.set_token('PARAMNUM',4);

395: fnd_message.raise_error;
396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then
398: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
399: fnd_message.set_token('PARAMNUM',4);
400: fnd_message.raise_error;
401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then
403: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

Line 400: fnd_message.raise_error;

396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then
398: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
399: fnd_message.set_token('PARAMNUM',4);
400: fnd_message.raise_error;
401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then
403: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
404: fnd_message.set_token('PARAMNUM',5);

Line 403: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

399: fnd_message.set_token('PARAMNUM',4);
400: fnd_message.raise_error;
401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then
403: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
404: fnd_message.set_token('PARAMNUM',5);
405: fnd_message.raise_error;
406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then

Line 404: fnd_message.set_token('PARAMNUM',5);

400: fnd_message.raise_error;
401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then
403: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
404: fnd_message.set_token('PARAMNUM',5);
405: fnd_message.raise_error;
406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then
408: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

Line 405: fnd_message.raise_error;

401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then
403: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
404: fnd_message.set_token('PARAMNUM',5);
405: fnd_message.raise_error;
406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then
408: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
409: fnd_message.set_token('PARAMNUM',6);

Line 408: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

404: fnd_message.set_token('PARAMNUM',5);
405: fnd_message.raise_error;
406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then
408: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
409: fnd_message.set_token('PARAMNUM',6);
410: fnd_message.raise_error;
411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then

Line 409: fnd_message.set_token('PARAMNUM',6);

405: fnd_message.raise_error;
406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then
408: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
409: fnd_message.set_token('PARAMNUM',6);
410: fnd_message.raise_error;
411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then
413: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

Line 410: fnd_message.raise_error;

406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then
408: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
409: fnd_message.set_token('PARAMNUM',6);
410: fnd_message.raise_error;
411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then
413: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
414: fnd_message.set_token('PARAMNUM',7);

Line 413: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

409: fnd_message.set_token('PARAMNUM',6);
410: fnd_message.raise_error;
411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then
413: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
414: fnd_message.set_token('PARAMNUM',7);
415: fnd_message.raise_error;
416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then

Line 414: fnd_message.set_token('PARAMNUM',7);

410: fnd_message.raise_error;
411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then
413: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
414: fnd_message.set_token('PARAMNUM',7);
415: fnd_message.raise_error;
416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then
418: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

Line 415: fnd_message.raise_error;

411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then
413: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
414: fnd_message.set_token('PARAMNUM',7);
415: fnd_message.raise_error;
416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then
418: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
419: fnd_message.set_token('PARAMNUM',8);

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

414: fnd_message.set_token('PARAMNUM',7);
415: fnd_message.raise_error;
416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then
418: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
419: fnd_message.set_token('PARAMNUM',8);
420: fnd_message.raise_error;
421: end if;
422: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 419: fnd_message.set_token('PARAMNUM',8);

415: fnd_message.raise_error;
416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then
418: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
419: fnd_message.set_token('PARAMNUM',8);
420: fnd_message.raise_error;
421: end if;
422: hr_utility.set_location(' Leaving:'||l_proc,30);
423: return true;

Line 420: fnd_message.raise_error;

416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then
418: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
419: fnd_message.set_token('PARAMNUM',8);
420: fnd_message.raise_error;
421: end if;
422: hr_utility.set_location(' Leaving:'||l_proc,30);
423: return true;
424: exception

Line 485: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

481: l_count := l_count+1;
482: l_priority := substr(p_value,l_location,l_index-l_location);
483: if (l_priority is null or l_priority = '' or (l_priority <> 'disabled' and
484: substr(l_priority,1,instr(l_priority,'_')) not in ('absolute_','relative_'))) then
485: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
486: fnd_message.set_token('PARAMNUM',l_count);
487: fnd_message.raise_error;
488: end if;
489: if not((l_priority = 'disabled')

Line 486: fnd_message.set_token('PARAMNUM',l_count);

482: l_priority := substr(p_value,l_location,l_index-l_location);
483: if (l_priority is null or l_priority = '' or (l_priority <> 'disabled' and
484: substr(l_priority,1,instr(l_priority,'_')) not in ('absolute_','relative_'))) then
485: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
486: fnd_message.set_token('PARAMNUM',l_count);
487: fnd_message.raise_error;
488: end if;
489: if not((l_priority = 'disabled')
490: or (

Line 487: fnd_message.raise_error;

483: if (l_priority is null or l_priority = '' or (l_priority <> 'disabled' and
484: substr(l_priority,1,instr(l_priority,'_')) not in ('absolute_','relative_'))) then
485: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
486: fnd_message.set_token('PARAMNUM',l_count);
487: fnd_message.raise_error;
488: end if;
489: if not((l_priority = 'disabled')
490: or (
491: (substr(l_priority,1,instr(l_priority,'_')) in ('absolute_'

Line 499: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

495: (ame_util.isANonNegativeInteger(substr(l_priority,instr(l_priority,'_')+1)))
496: and
497: (substr(l_priority,instr(l_priority,'_')+1)<>'0')
498: ))then
499: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
500: fnd_message.set_token('PARAMNUM',l_count);
501: fnd_message.raise_error;
502: end if;
503: l_location:=l_index+1;

Line 500: fnd_message.set_token('PARAMNUM',l_count);

496: and
497: (substr(l_priority,instr(l_priority,'_')+1)<>'0')
498: ))then
499: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
500: fnd_message.set_token('PARAMNUM',l_count);
501: fnd_message.raise_error;
502: end if;
503: l_location:=l_index+1;
504: end loop;

Line 501: fnd_message.raise_error;

497: (substr(l_priority,instr(l_priority,'_')+1)<>'0')
498: ))then
499: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
500: fnd_message.set_token('PARAMNUM',l_count);
501: fnd_message.raise_error;
502: end if;
503: l_location:=l_index+1;
504: end loop;
505: --

Line 509: fnd_message.set_name('PER', 'AME_400660_CFV_INV_PRIORITY');

505: --
506: -- If total parameter count is not 8, then error has occurred.
507: --
508: if(l_count <> 8) then
509: fnd_message.set_name('PER', 'AME_400660_CFV_INV_PRIORITY');
510: fnd_message.raise_error;
511: end if;
512: hr_utility.set_location(' Leaving:'||l_proc,30);
513: return true;

Line 510: fnd_message.raise_error;

506: -- If total parameter count is not 8, then error has occurred.
507: --
508: if(l_count <> 8) then
509: fnd_message.set_name('PER', 'AME_400660_CFV_INV_PRIORITY');
510: fnd_message.raise_error;
511: end if;
512: hr_utility.set_location(' Leaving:'||l_proc,30);
513: return true;
514: exception

Line 583: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');

579: open csr_role;
580: fetch csr_role into l_key;
581: if(csr_role%notfound) then
582: close csr_role;
583: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
584: fnd_message.set_token('VARNAME',p_variable_name);
585: fnd_message.raise_error;
586: else
587: close csr_role;

Line 584: fnd_message.set_token('VARNAME',p_variable_name);

580: fetch csr_role into l_key;
581: if(csr_role%notfound) then
582: close csr_role;
583: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
584: fnd_message.set_token('VARNAME',p_variable_name);
585: fnd_message.raise_error;
586: else
587: close csr_role;
588: end if;

Line 585: fnd_message.raise_error;

581: if(csr_role%notfound) then
582: close csr_role;
583: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
584: fnd_message.set_token('VARNAME',p_variable_name);
585: fnd_message.raise_error;
586: else
587: close csr_role;
588: end if;
589:

Line 596: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');

592: or p_variable_name = 'allowFyiNotifications'
593: or p_variable_name = 'distributedEnvironment'
594: ) then
595: if(p_variable_value) not in ('yes','no') then
596: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
597: fnd_message.set_token('VARNAME',p_variable_name);
598: fnd_message.raise_error;
599: end if;
600:

Line 597: fnd_message.set_token('VARNAME',p_variable_name);

593: or p_variable_name = 'distributedEnvironment'
594: ) then
595: if(p_variable_value) not in ('yes','no') then
596: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
597: fnd_message.set_token('VARNAME',p_variable_name);
598: fnd_message.raise_error;
599: end if;
600:
601: elsif(p_variable_name = 'currencyConversionWindow'

Line 598: fnd_message.raise_error;

594: ) then
595: if(p_variable_value) not in ('yes','no') then
596: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
597: fnd_message.set_token('VARNAME',p_variable_name);
598: fnd_message.raise_error;
599: end if;
600:
601: elsif(p_variable_name = 'currencyConversionWindow'
602: or p_variable_name = 'purgeFrequency'

Line 607: fnd_message.set_name('PER', 'AME_400662_CFV_NEG_VAL');

603: ) then
604: if (trim(p_variable_value)='0')
605: or not (ame_util.isANonNegativeInteger(p_variable_value))
606: then
607: fnd_message.set_name('PER', 'AME_400662_CFV_NEG_VAL');
608: fnd_message.set_token('VARNAME',p_variable_name);
609: fnd_message.raise_error;
610: end if;
611:

Line 608: fnd_message.set_token('VARNAME',p_variable_name);

604: if (trim(p_variable_value)='0')
605: or not (ame_util.isANonNegativeInteger(p_variable_value))
606: then
607: fnd_message.set_name('PER', 'AME_400662_CFV_NEG_VAL');
608: fnd_message.set_token('VARNAME',p_variable_name);
609: fnd_message.raise_error;
610: end if;
611:
612: elsif(p_variable_name = 'forwardingBehaviors') then

Line 609: fnd_message.raise_error;

605: or not (ame_util.isANonNegativeInteger(p_variable_value))
606: then
607: fnd_message.set_name('PER', 'AME_400662_CFV_NEG_VAL');
608: fnd_message.set_token('VARNAME',p_variable_name);
609: fnd_message.raise_error;
610: end if;
611:
612: elsif(p_variable_name = 'forwardingBehaviors') then
613: if not isValid_Forwarding_Behaviour(p_variable_value) then

Line 614: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');

610: end if;
611:
612: elsif(p_variable_name = 'forwardingBehaviors') then
613: if not isValid_Forwarding_Behaviour(p_variable_value) then
614: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
615: fnd_message.set_token('VARNAME',p_variable_name);
616: fnd_message.raise_error;
617: end if;
618:

Line 615: fnd_message.set_token('VARNAME',p_variable_name);

611:
612: elsif(p_variable_name = 'forwardingBehaviors') then
613: if not isValid_Forwarding_Behaviour(p_variable_value) then
614: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
615: fnd_message.set_token('VARNAME',p_variable_name);
616: fnd_message.raise_error;
617: end if;
618:
619: /*elsif(p_variable_name = 'helpPath'

Line 616: fnd_message.raise_error;

612: elsif(p_variable_name = 'forwardingBehaviors') then
613: if not isValid_Forwarding_Behaviour(p_variable_value) then
614: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
615: fnd_message.set_token('VARNAME',p_variable_name);
616: fnd_message.raise_error;
617: end if;
618:
619: /*elsif(p_variable_name = 'helpPath'
620: or p_variable_name = 'htmlPath'

Line 631: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');

627: ,'approver'
628: ,'transaction'
629: ,'all'
630: ) then
631: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
632: fnd_message.set_token('VARNAME',p_variable_name);
633: fnd_message.raise_error;
634: end if;
635:

Line 632: fnd_message.set_token('VARNAME',p_variable_name);

628: ,'transaction'
629: ,'all'
630: ) then
631: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
632: fnd_message.set_token('VARNAME',p_variable_name);
633: fnd_message.raise_error;
634: end if;
635:
636: elsif(p_variable_name = 'repeatedApprovers') then

Line 633: fnd_message.raise_error;

629: ,'all'
630: ) then
631: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
632: fnd_message.set_token('VARNAME',p_variable_name);
633: fnd_message.raise_error;
634: end if;
635:
636: elsif(p_variable_name = 'repeatedApprovers') then
637: if p_variable_value not in ('ONCE_PER_TRANSACTION'

Line 645: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');

641: ,'ONCE_PER_ACTION_TYPE'
642: ,'ONCE_PER_GROUP_OR_CHAIN'
643: ,'EACH_OCCURRENCE'
644: ) then
645: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
646: fnd_message.set_token('VARNAME',p_variable_name);
647: fnd_message.raise_error;
648: end if;
649:

Line 646: fnd_message.set_token('VARNAME',p_variable_name);

642: ,'ONCE_PER_GROUP_OR_CHAIN'
643: ,'EACH_OCCURRENCE'
644: ) then
645: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
646: fnd_message.set_token('VARNAME',p_variable_name);
647: fnd_message.raise_error;
648: end if;
649:
650: elsif(p_variable_name = 'rulePriorityModes') then

Line 647: fnd_message.raise_error;

643: ,'EACH_OCCURRENCE'
644: ) then
645: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
646: fnd_message.set_token('VARNAME',p_variable_name);
647: fnd_message.raise_error;
648: end if;
649:
650: elsif(p_variable_name = 'rulePriorityModes') then
651: if not isValid_Rule_Priority_Mode(p_variable_value) then

Line 652: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');

648: end if;
649:
650: elsif(p_variable_name = 'rulePriorityModes') then
651: if not isValid_Rule_Priority_Mode(p_variable_value) then
652: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
653: fnd_message.set_token('VARNAME',p_variable_name);
654: fnd_message.raise_error;
655: end if;
656: end if;

Line 653: fnd_message.set_token('VARNAME',p_variable_name);

649:
650: elsif(p_variable_name = 'rulePriorityModes') then
651: if not isValid_Rule_Priority_Mode(p_variable_value) then
652: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
653: fnd_message.set_token('VARNAME',p_variable_name);
654: fnd_message.raise_error;
655: end if;
656: end if;
657: end if;

Line 654: fnd_message.raise_error;

650: elsif(p_variable_name = 'rulePriorityModes') then
651: if not isValid_Rule_Priority_Mode(p_variable_value) then
652: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
653: fnd_message.set_token('VARNAME',p_variable_name);
654: fnd_message.raise_error;
655: end if;
656: end if;
657: end if;
658: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 735: fnd_message.set_name('PER', 'AME_400655_INV_NO_TT_VAL');

731: ,'htmlPath'
732: ,'imagePath'
733: ,' portalUrl'
734: ) then
735: fnd_message.set_name('PER', 'AME_400655_INV_NO_TT_VAL');
736: fnd_message.raise_error;
737: end if;
738: open csr_var_name;
739: fetch csr_var_name into l_key;

Line 736: fnd_message.raise_error;

732: ,'imagePath'
733: ,' portalUrl'
734: ) then
735: fnd_message.set_name('PER', 'AME_400655_INV_NO_TT_VAL');
736: fnd_message.raise_error;
737: end if;
738: open csr_var_name;
739: fetch csr_var_name into l_key;
740: if(csr_var_name%found) then

Line 742: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');

738: open csr_var_name;
739: fetch csr_var_name into l_key;
740: if(csr_var_name%found) then
741: close csr_var_name;
742: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
743: fnd_message.set_token('VARNAME',p_variable_name);
744: fnd_message.raise_error;
745: else
746: close csr_var_name;

Line 743: fnd_message.set_token('VARNAME',p_variable_name);

739: fetch csr_var_name into l_key;
740: if(csr_var_name%found) then
741: close csr_var_name;
742: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
743: fnd_message.set_token('VARNAME',p_variable_name);
744: fnd_message.raise_error;
745: else
746: close csr_var_name;
747: end if;

Line 744: fnd_message.raise_error;

740: if(csr_var_name%found) then
741: close csr_var_name;
742: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
743: fnd_message.set_token('VARNAME',p_variable_name);
744: fnd_message.raise_error;
745: else
746: close csr_var_name;
747: end if;
748: else

Line 753: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');

749: open csr_var_name;
750: fetch csr_var_name into l_key;
751: if(csr_var_name%found) then
752: close csr_var_name;
753: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
754: fnd_message.set_token('VARNAME',p_variable_name);
755: fnd_message.raise_error;
756: else
757: close csr_var_name;

Line 754: fnd_message.set_token('VARNAME',p_variable_name);

750: fetch csr_var_name into l_key;
751: if(csr_var_name%found) then
752: close csr_var_name;
753: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
754: fnd_message.set_token('VARNAME',p_variable_name);
755: fnd_message.raise_error;
756: else
757: close csr_var_name;
758: end if;

Line 755: fnd_message.raise_error;

751: if(csr_var_name%found) then
752: close csr_var_name;
753: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
754: fnd_message.set_token('VARNAME',p_variable_name);
755: fnd_message.raise_error;
756: else
757: close csr_var_name;
758: end if;
759: end if;

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

814: ,p_variable_name => p_rec.variable_name
815: ,p_effective_date => p_effective_date
816: ,p_object_version_number => p_rec.object_version_number
817: ) THEN
818: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
819: fnd_message.set_token('PROCEDURE ', l_proc);
820: fnd_message.set_token('STEP ', '5');
821: fnd_message.raise_error;
822: END IF;

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

815: ,p_effective_date => p_effective_date
816: ,p_object_version_number => p_rec.object_version_number
817: ) THEN
818: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
819: fnd_message.set_token('PROCEDURE ', l_proc);
820: fnd_message.set_token('STEP ', '5');
821: fnd_message.raise_error;
822: END IF;
823: --

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

816: ,p_object_version_number => p_rec.object_version_number
817: ) THEN
818: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
819: fnd_message.set_token('PROCEDURE ', l_proc);
820: fnd_message.set_token('STEP ', '5');
821: fnd_message.raise_error;
822: END IF;
823: --
824: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 821: fnd_message.raise_error;

817: ) THEN
818: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
819: fnd_message.set_token('PROCEDURE ', l_proc);
820: fnd_message.set_token('STEP ', '5');
821: fnd_message.raise_error;
822: END IF;
823: --
824: -- EDIT_HERE: Add checks to ensure non-updateable args have
825: -- not been updated.

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

894: --
895: -- An unhandled or unexpected error has occurred which
896: -- we must report
897: --
898: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
899: fnd_message.set_token('PROCEDURE', l_proc);
900: fnd_message.set_token('STEP','15');
901: fnd_message.raise_error;
902: End dt_update_validate;

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

895: -- An unhandled or unexpected error has occurred which
896: -- we must report
897: --
898: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
899: fnd_message.set_token('PROCEDURE', l_proc);
900: fnd_message.set_token('STEP','15');
901: fnd_message.raise_error;
902: End dt_update_validate;
903: --

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

896: -- we must report
897: --
898: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
899: fnd_message.set_token('PROCEDURE', l_proc);
900: fnd_message.set_token('STEP','15');
901: fnd_message.raise_error;
902: End dt_update_validate;
903: --
904: -- ----------------------------------------------------------------------------

Line 901: fnd_message.raise_error;

897: --
898: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
899: fnd_message.set_token('PROCEDURE', l_proc);
900: fnd_message.set_token('STEP','15');
901: fnd_message.raise_error;
902: End dt_update_validate;
903: --
904: -- ----------------------------------------------------------------------------
905: -- |--------------------------< dt_delete_validate >--------------------------|

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

992: --
993: -- An unhandled or unexpected error has occurred which
994: -- we must report
995: --
996: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
997: fnd_message.set_token('PROCEDURE', l_proc);
998: fnd_message.set_token('STEP','15');
999: fnd_message.raise_error;
1000: --

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

993: -- An unhandled or unexpected error has occurred which
994: -- we must report
995: --
996: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
997: fnd_message.set_token('PROCEDURE', l_proc);
998: fnd_message.set_token('STEP','15');
999: fnd_message.raise_error;
1000: --
1001: End dt_delete_validate;

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

994: -- we must report
995: --
996: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
997: fnd_message.set_token('PROCEDURE', l_proc);
998: fnd_message.set_token('STEP','15');
999: fnd_message.raise_error;
1000: --
1001: End dt_delete_validate;
1002: --

Line 999: fnd_message.raise_error;

995: --
996: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
997: fnd_message.set_token('PROCEDURE', l_proc);
998: fnd_message.set_token('STEP','15');
999: fnd_message.raise_error;
1000: --
1001: End dt_delete_validate;
1002: --
1003: -- ----------------------------------------------------------------------------