DBA Data[Home] [Help]

APPS.AME_APG_BUS dependencies on FND_MESSAGE

Line 134: fnd_message.set_name('PER','AME_400561_APG_NAME_NOT_UNQ');

130: open C_Sel1;
131: fetch C_Sel1 into l_count;
132: close C_Sel1;
133: if l_count <> 0 then
134: fnd_message.set_name('PER','AME_400561_APG_NAME_NOT_UNQ');
135: fnd_message.raise_error;
136: end if;
137: hr_utility.set_location(' Leaving:'||l_proc,30);
138: exception

Line 135: fnd_message.raise_error;

131: fetch C_Sel1 into l_count;
132: close C_Sel1;
133: if l_count <> 0 then
134: fnd_message.set_name('PER','AME_400561_APG_NAME_NOT_UNQ');
135: fnd_message.raise_error;
136: end if;
137: hr_utility.set_location(' Leaving:'||l_proc,30);
138: exception
139: when app_exception.application_exception then

Line 187: fnd_message.set_name('PER','AME_400562_APG_INVALID_USG_TYP');

183: ,p_argument => 'IS_STATIC'
184: ,p_argument_value => p_is_static
185: );
186: if p_is_static not in('Y','N') then
187: fnd_message.set_name('PER','AME_400562_APG_INVALID_USG_TYP');
188: fnd_message.raise_error;
189: end if;
190: hr_utility.set_location(' Leaving:'||l_proc,30);
191: exception

Line 188: fnd_message.raise_error;

184: ,p_argument_value => p_is_static
185: );
186: if p_is_static not in('Y','N') then
187: fnd_message.set_name('PER','AME_400562_APG_INVALID_USG_TYP');
188: fnd_message.raise_error;
189: end if;
190: hr_utility.set_location(' Leaving:'||l_proc,30);
191: exception
192: when app_exception.application_exception then

Line 246: fnd_message.set_name('PER','AME_400563_APG_INV_USG_QRY_CMB');

242:
243: Begin
244: hr_utility.set_location('Entering:'||l_proc,10);
245: if (p_is_static = 'Y' and p_query_string is not null) then
246: fnd_message.set_name('PER','AME_400563_APG_INV_USG_QRY_CMB');
247: fnd_message.raise_error;
248: end if;
249: if (p_is_static = 'N' and p_query_string is null) then
250: fnd_message.set_name('PER','AME_400556_APG_EMPTY_QUERY');

Line 247: fnd_message.raise_error;

243: Begin
244: hr_utility.set_location('Entering:'||l_proc,10);
245: if (p_is_static = 'Y' and p_query_string is not null) then
246: fnd_message.set_name('PER','AME_400563_APG_INV_USG_QRY_CMB');
247: fnd_message.raise_error;
248: end if;
249: if (p_is_static = 'N' and p_query_string is null) then
250: fnd_message.set_name('PER','AME_400556_APG_EMPTY_QUERY');
251: fnd_message.raise_error;

Line 250: fnd_message.set_name('PER','AME_400556_APG_EMPTY_QUERY');

246: fnd_message.set_name('PER','AME_400563_APG_INV_USG_QRY_CMB');
247: fnd_message.raise_error;
248: end if;
249: if (p_is_static = 'N' and p_query_string is null) then
250: fnd_message.set_name('PER','AME_400556_APG_EMPTY_QUERY');
251: fnd_message.raise_error;
252: end if;
253: if(p_is_static = 'N') then
254: if(instrb(p_query_string, ';', 1, 1) > 0) or

Line 251: fnd_message.raise_error;

247: fnd_message.raise_error;
248: end if;
249: if (p_is_static = 'N' and p_query_string is null) then
250: fnd_message.set_name('PER','AME_400556_APG_EMPTY_QUERY');
251: fnd_message.raise_error;
252: end if;
253: if(p_is_static = 'N') then
254: if(instrb(p_query_string, ';', 1, 1) > 0) or
255: (instrb(p_query_string, '--', 1, 1) > 0) or

Line 258: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');

254: if(instrb(p_query_string, ';', 1, 1) > 0) or
255: (instrb(p_query_string, '--', 1, 1) > 0) or
256: (instrb(p_query_string, '/*', 1, 1) > 0) or
257: (instrb(p_query_string, '*/', 1, 1) > 0) then
258: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
259: fnd_message.raise_error;
260: end if;
261: tempInt := 1;
262: queryString := upper(p_query_string);

Line 259: fnd_message.raise_error;

255: (instrb(p_query_string, '--', 1, 1) > 0) or
256: (instrb(p_query_string, '/*', 1, 1) > 0) or
257: (instrb(p_query_string, '*/', 1, 1) > 0) then
258: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
259: fnd_message.raise_error;
260: end if;
261: tempInt := 1;
262: queryString := upper(p_query_string);
263: upperTransIdPlaceholder := upper(ame_util.transactionIdPlaceholder);

Line 273: fnd_message.set_name('PER','AME_400635_APG_QRY_STR_BND_VAR');

269: end if;
270: transIdPlaceholderPosition2 :=
271: instrb(p_query_string, ame_util.transactionIdPlaceholder, 1, tempInt);
272: if(transIdPlaceholderPosition <> transIdPlaceholderPosition2) then
273: fnd_message.set_name('PER','AME_400635_APG_QRY_STR_BND_VAR');
274: fnd_message.raise_error;
275: end if;
276: tempInt := tempInt + 1;
277: end loop;

Line 274: fnd_message.raise_error;

270: transIdPlaceholderPosition2 :=
271: instrb(p_query_string, ame_util.transactionIdPlaceholder, 1, tempInt);
272: if(transIdPlaceholderPosition <> transIdPlaceholderPosition2) then
273: fnd_message.set_name('PER','AME_400635_APG_QRY_STR_BND_VAR');
274: fnd_message.raise_error;
275: end if;
276: tempInt := tempInt + 1;
277: end loop;
278: /*if(ame_util.isArgumentTooLong(tableNameIn => 'ame_approval_groups',

Line 281: fnd_message.set_name('PER','AME_400163_ATT_USAGE_LONG');

277: end loop;
278: /*if(ame_util.isArgumentTooLong(tableNameIn => 'ame_approval_groups',
279: columnNameIn => 'query_string',
280: argumentIn => p_query_string)) then
281: fnd_message.set_name('PER','AME_400163_ATT_USAGE_LONG');
282: fnd_message.raise_error;
283: end if;*/
284: /* The following utility handles the error. So nothing needs to be done here */
285: ame_util.checkForSqlInjection(queryStringIn => queryString);

Line 282: fnd_message.raise_error;

278: /*if(ame_util.isArgumentTooLong(tableNameIn => 'ame_approval_groups',
279: columnNameIn => 'query_string',
280: argumentIn => p_query_string)) then
281: fnd_message.set_name('PER','AME_400163_ATT_USAGE_LONG');
282: fnd_message.raise_error;
283: end if;*/
284: /* The following utility handles the error. So nothing needs to be done here */
285: ame_util.checkForSqlInjection(queryStringIn => queryString);
286: l_valid := ame_utility_pkg.validate_query(p_query_string => p_query_string

Line 291: fnd_message.raise_error;

287: ,p_columns => 1
288: ,p_object => ame_util2.approverGroupObject
289: );
290: if l_valid <> 'Y' then
291: fnd_message.raise_error;
292: end if;
293: end if;
294: hr_utility.set_location(' Leaving:'||l_proc,30);
295: exception

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

356: (p_approval_group_id => p_rec.approval_group_id
357: ,p_effective_date => p_effective_date
358: ,p_object_version_number => p_rec.object_version_number
359: ) THEN
360: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
361: fnd_message.set_token('PROCEDURE ', l_proc);
362: fnd_message.set_token('STEP ', '5');
363: fnd_message.raise_error;
364: END IF;

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

357: ,p_effective_date => p_effective_date
358: ,p_object_version_number => p_rec.object_version_number
359: ) THEN
360: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
361: fnd_message.set_token('PROCEDURE ', l_proc);
362: fnd_message.set_token('STEP ', '5');
363: fnd_message.raise_error;
364: END IF;
365: --

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

358: ,p_object_version_number => p_rec.object_version_number
359: ) THEN
360: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
361: fnd_message.set_token('PROCEDURE ', l_proc);
362: fnd_message.set_token('STEP ', '5');
363: fnd_message.raise_error;
364: END IF;
365: --
366: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 363: fnd_message.raise_error;

359: ) THEN
360: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
361: fnd_message.set_token('PROCEDURE ', l_proc);
362: fnd_message.set_token('STEP ', '5');
363: fnd_message.raise_error;
364: END IF;
365: --
366: -- EDIT_HERE: Add checks to ensure non-updateable args have
367: -- not been updated.

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

490: --
491: -- An unhandled or unexpected error has occurred which
492: -- we must report
493: --
494: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.set_token('STEP','15');
497: fnd_message.raise_error;
498: End dt_update_validate;

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

491: -- An unhandled or unexpected error has occurred which
492: -- we must report
493: --
494: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.set_token('STEP','15');
497: fnd_message.raise_error;
498: End dt_update_validate;
499: --

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

492: -- we must report
493: --
494: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.set_token('STEP','15');
497: fnd_message.raise_error;
498: End dt_update_validate;
499: --
500: -- ----------------------------------------------------------------------------

Line 497: fnd_message.raise_error;

493: --
494: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.set_token('STEP','15');
497: fnd_message.raise_error;
498: End dt_update_validate;
499: --
500: -- ----------------------------------------------------------------------------
501: -- |--------------------------< dt_delete_validate >--------------------------|

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

591: --
592: -- An unhandled or unexpected error has occurred which
593: -- we must report
594: --
595: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
596: fnd_message.set_token('PROCEDURE', l_proc);
597: fnd_message.set_token('STEP','15');
598: fnd_message.raise_error;
599: --

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

592: -- An unhandled or unexpected error has occurred which
593: -- we must report
594: --
595: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
596: fnd_message.set_token('PROCEDURE', l_proc);
597: fnd_message.set_token('STEP','15');
598: fnd_message.raise_error;
599: --
600: End dt_delete_validate;

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

593: -- we must report
594: --
595: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
596: fnd_message.set_token('PROCEDURE', l_proc);
597: fnd_message.set_token('STEP','15');
598: fnd_message.raise_error;
599: --
600: End dt_delete_validate;
601: --

Line 598: fnd_message.raise_error;

594: --
595: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
596: fnd_message.set_token('PROCEDURE', l_proc);
597: fnd_message.set_token('STEP','15');
598: fnd_message.raise_error;
599: --
600: End dt_delete_validate;
601: --
602: -- ----------------------------------------------------------------------------