DBA Data[Home] [Help]

APPS.PAY_PUC_BUS dependencies on FND_MESSAGE

Line 65: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

61: close csr_sec_grp;
62: --
63: -- The primary key is invalid therefore we must error
64: --
65: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
66: hr_multi_message.add
67: (p_associated_column1
68: => nvl(p_associated_column1,'USER_COLUMN_ID')
69: );

Line 142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

138: --
139: -- The primary key is invalid therefore we must error
140: --
141: close csr_leg_code;
142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: end if;
145: hr_utility.set_location(l_proc,30);
146: --

Line 143: fnd_message.raise_error;

139: -- The primary key is invalid therefore we must error
140: --
141: close csr_leg_code;
142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: end if;
145: hr_utility.set_location(l_proc,30);
146: --
147: -- Set the global variables so the values are

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

196: IF NOT pay_puc_shd.api_updating
197: (p_user_column_id => p_rec.user_column_id
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;

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

197: (p_user_column_id => p_rec.user_column_id
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --

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

198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --
206: if nvl(p_rec.business_group_id, hr_api.g_number) <>

Line 203: fnd_message.raise_error;

199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --
206: if nvl(p_rec.business_group_id, hr_api.g_number) <>
207: nvl(pay_puc_shd.g_old_rec.business_group_id, hr_api.g_number) then

Line 257: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');

253: fetch csr_legislation_code into l_exists ;
254:
255: if csr_legislation_code%notfound then
256: close csr_legislation_code;
257: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');
258: fnd_message.raise_error;
259: end if;
260: close csr_legislation_code;
261:

Line 258: fnd_message.raise_error;

254:
255: if csr_legislation_code%notfound then
256: close csr_legislation_code;
257: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');
258: fnd_message.raise_error;
259: end if;
260: close csr_legislation_code;
261:
262: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 314: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');

310: , l_busgrpid
311: ;
312: if csr_user_table_id%notfound then
313: close csr_user_table_id;
314: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
315: fnd_message.set_token('PARENT' , 'User Table Id' );
316: fnd_message.raise_error;
317: end if;
318: close csr_user_table_id;

Line 315: fnd_message.set_token('PARENT' , 'User Table Id' );

311: ;
312: if csr_user_table_id%notfound then
313: close csr_user_table_id;
314: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
315: fnd_message.set_token('PARENT' , 'User Table Id' );
316: fnd_message.raise_error;
317: end if;
318: close csr_user_table_id;
319: --

Line 316: fnd_message.raise_error;

312: if csr_user_table_id%notfound then
313: close csr_user_table_id;
314: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
315: fnd_message.set_token('PARENT' , 'User Table Id' );
316: fnd_message.raise_error;
317: end if;
318: close csr_user_table_id;
319: --
320: -- Confirm that the parent USER_TABLE's startup mode is compatible

Line 329: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');

325: ,p_parent_legcode => l_legcode
326: ,p_child_bgid => p_business_group_id
327: ,p_child_legcode => p_legislation_code
328: ) then
329: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
330: fnd_message.set_token('CHILD', 'User Column');
331: fnd_message.set_token('PARENT' , 'User Table');
332: fnd_message.raise_error;
333: end if;

Line 330: fnd_message.set_token('CHILD', 'User Column');

326: ,p_child_bgid => p_business_group_id
327: ,p_child_legcode => p_legislation_code
328: ) then
329: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
330: fnd_message.set_token('CHILD', 'User Column');
331: fnd_message.set_token('PARENT' , 'User Table');
332: fnd_message.raise_error;
333: end if;
334: exception

Line 331: fnd_message.set_token('PARENT' , 'User Table');

327: ,p_child_legcode => p_legislation_code
328: ) then
329: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
330: fnd_message.set_token('CHILD', 'User Column');
331: fnd_message.set_token('PARENT' , 'User Table');
332: fnd_message.raise_error;
333: end if;
334: exception
335: when app_exception.application_exception then

Line 332: fnd_message.raise_error;

328: ) then
329: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
330: fnd_message.set_token('CHILD', 'User Column');
331: fnd_message.set_token('PARENT' , 'User Table');
332: fnd_message.raise_error;
333: end if;
334: exception
335: when app_exception.application_exception then
336: if hr_multi_message.exception_add

Line 411: fnd_message.set_name('PAY','PAY_7885_USER_TABLE_UNIQUE');

407: fetch csr_name_exists
408: into l_exists;
409: if csr_name_exists%found then
410: close csr_name_exists;
411: fnd_message.set_name('PAY','PAY_7885_USER_TABLE_UNIQUE');
412: fnd_message.raise_error;
413: end if;
414: close csr_name_exists;
415: end if;

Line 412: fnd_message.raise_error;

408: into l_exists;
409: if csr_name_exists%found then
410: close csr_name_exists;
411: fnd_message.set_name('PAY','PAY_7885_USER_TABLE_UNIQUE');
412: fnd_message.raise_error;
413: end if;
414: close csr_name_exists;
415: end if;
416: exception

Line 500: fnd_message.set_name('PAY', 'PAY_33176_UCOL_FF_NOT_FOUND');

496: ;
497: if csr_formula_exists%notfound then
498: close csr_formula_exists;
499: --
500: fnd_message.set_name('PAY', 'PAY_33176_UCOL_FF_NOT_FOUND');
501: fnd_message.set_token('FORMULA_TYPE', pay_puc_bus.g_formula_type_name);
502: fnd_message.raise_error;
503: end if;
504: close csr_formula_exists;

Line 501: fnd_message.set_token('FORMULA_TYPE', pay_puc_bus.g_formula_type_name);

497: if csr_formula_exists%notfound then
498: close csr_formula_exists;
499: --
500: fnd_message.set_name('PAY', 'PAY_33176_UCOL_FF_NOT_FOUND');
501: fnd_message.set_token('FORMULA_TYPE', pay_puc_bus.g_formula_type_name);
502: fnd_message.raise_error;
503: end if;
504: close csr_formula_exists;
505: --

Line 502: fnd_message.raise_error;

498: close csr_formula_exists;
499: --
500: fnd_message.set_name('PAY', 'PAY_33176_UCOL_FF_NOT_FOUND');
501: fnd_message.set_token('FORMULA_TYPE', pay_puc_bus.g_formula_type_name);
502: fnd_message.raise_error;
503: end if;
504: close csr_formula_exists;
505: --
506: -- Confirm that formula's startup mode is compatible with this

Line 515: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');

511: ,p_parent_legcode => l_legcode
512: ,p_child_bgid => p_business_group_id
513: ,p_child_legcode => p_legislation_code
514: ) then
515: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
516: fnd_message.set_token('CHILD', 'User Column');
517: fnd_message.set_token('PARENT' , 'Formula');
518: fnd_message.raise_error;
519: end if;

Line 516: fnd_message.set_token('CHILD', 'User Column');

512: ,p_child_bgid => p_business_group_id
513: ,p_child_legcode => p_legislation_code
514: ) then
515: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
516: fnd_message.set_token('CHILD', 'User Column');
517: fnd_message.set_token('PARENT' , 'Formula');
518: fnd_message.raise_error;
519: end if;
520: end if;

Line 517: fnd_message.set_token('PARENT' , 'Formula');

513: ,p_child_legcode => p_legislation_code
514: ) then
515: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
516: fnd_message.set_token('CHILD', 'User Column');
517: fnd_message.set_token('PARENT' , 'Formula');
518: fnd_message.raise_error;
519: end if;
520: end if;
521: exception

Line 518: fnd_message.raise_error;

514: ) then
515: fnd_message.set_name('PAY', 'PAY_33175_BGLEG_MISMATCH');
516: fnd_message.set_token('CHILD', 'User Column');
517: fnd_message.set_token('PARENT' , 'Formula');
518: fnd_message.raise_error;
519: end if;
520: end if;
521: exception
522: when app_exception.application_exception then

Line 559: fnd_message.set_name('PAY', 'HR_6980_USERTAB_VALUES_FIRST');

555: fetch csr_values_exist
556: into l_ret;
557: if csr_values_exist%found then
558: close csr_values_exist;
559: fnd_message.set_name('PAY', 'HR_6980_USERTAB_VALUES_FIRST');
560: fnd_message.set_token( 'ROWCOL' , 'column' ) ;
561: fnd_message.raise_error;
562: end if;
563: close csr_values_exist;

Line 560: fnd_message.set_token( 'ROWCOL' , 'column' ) ;

556: into l_ret;
557: if csr_values_exist%found then
558: close csr_values_exist;
559: fnd_message.set_name('PAY', 'HR_6980_USERTAB_VALUES_FIRST');
560: fnd_message.set_token( 'ROWCOL' , 'column' ) ;
561: fnd_message.raise_error;
562: end if;
563: close csr_values_exist;
564: exception

Line 561: fnd_message.raise_error;

557: if csr_values_exist%found then
558: close csr_values_exist;
559: fnd_message.set_name('PAY', 'HR_6980_USERTAB_VALUES_FIRST');
560: fnd_message.set_token( 'ROWCOL' , 'column' ) ;
561: fnd_message.raise_error;
562: end if;
563: close csr_values_exist;
564: exception
565: when app_exception.application_exception then

Line 600: fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');

596:
597: IF (p_insert) THEN
598:
599: if p_business_group_id is not null and p_legislation_code is not null then
600: fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');
601: fnd_message.raise_error;
602: end if;
603:
604: hr_startup_data_api_support.chk_startup_action

Line 601: fnd_message.raise_error;

597: IF (p_insert) THEN
598:
599: if p_business_group_id is not null and p_legislation_code is not null then
600: fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');
601: fnd_message.raise_error;
602: end if;
603:
604: hr_startup_data_api_support.chk_startup_action
605: (p_generic_allowed => TRUE