DBA Data[Home] [Help]

APPS.PAY_USER_COLUMNS_PKG dependencies on FND_MESSAGE

Line 178: fnd_message.set_name('FND','FORM_RECORD_CHANGED');

174: is null ))
175: then
176: return ;
177: else
178: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
179: app_exception.raise_exception ;
180: end if;
181:
182: --_TL table lock

Line 196: fnd_message.set_name( 'FND' , 'FORM_RECORD_CHANGED' ) ;

192: is null ))
193: then
194: return ;
195: else
196: fnd_message.set_name( 'FND' , 'FORM_RECORD_CHANGED' ) ;
197: app_exception.raise_exception ;
198: end if;
199:
200: end lock_row;

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

222: open c1 ;
223: fetch c1 into l_dummy ;
224: if c1%found
225: then close c1 ;
226: fnd_message.set_name( 'PAY' , 'PAY_7885_USER_TABLE_UNIQUE' ) ;
227: fnd_message.raise_error ;
228: end if ;
229: close c1 ;
230: end check_unique ;

Line 227: fnd_message.raise_error ;

223: fetch c1 into l_dummy ;
224: if c1%found
225: then close c1 ;
226: fnd_message.set_name( 'PAY' , 'PAY_7885_USER_TABLE_UNIQUE' ) ;
227: fnd_message.raise_error ;
228: end if ;
229: close c1 ;
230: end check_unique ;
231: --

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

272: open c1 ;
273: fetch c1 into l_dummy ;
274: if c1%found
275: then close c1 ;
276: fnd_message.set_name( 'PAY' , 'PAY_7885_USER_TABLE_UNIQUE' ) ;
277: fnd_message.raise_error ;
278: end if ;
279: close c1 ;
280:

Line 277: fnd_message.raise_error ;

273: fetch c1 into l_dummy ;
274: if c1%found
275: then close c1 ;
276: fnd_message.set_name( 'PAY' , 'PAY_7885_USER_TABLE_UNIQUE' ) ;
277: fnd_message.raise_error ;
278: end if ;
279: close c1 ;
280:
281: --check _TL uniqeness

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

282: open c2 ;
283: fetch c2 into l_dummy ;
284: if c2%found
285: then close c2 ;
286: fnd_message.set_name( 'PAY' , 'PAY_7885_USER_TABLE_UNIQUE' ) ;
287: fnd_message.raise_error ;
288: end if ;
289: close c2 ;
290: --

Line 287: fnd_message.raise_error ;

283: fetch c2 into l_dummy ;
284: if c2%found
285: then close c2 ;
286: fnd_message.set_name( 'PAY' , 'PAY_7885_USER_TABLE_UNIQUE' ) ;
287: fnd_message.raise_error ;
288: end if ;
289: close c2 ;
290: --
291:

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

305: open c1 ;
306: fetch c1 into l_dummy ;
307: if c1%found then
308: close c1 ;
309: fnd_message.set_name ( 'PAY' , 'HR_6980_USERTAB_VALUES_FIRST' ) ;
310: fnd_message.set_token ( 'ROWCOL' , 'column' ) ;
311: fnd_message.raise_error ;
312: end if ;
313: close c1 ;

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

306: fetch c1 into l_dummy ;
307: if c1%found then
308: close c1 ;
309: fnd_message.set_name ( 'PAY' , 'HR_6980_USERTAB_VALUES_FIRST' ) ;
310: fnd_message.set_token ( 'ROWCOL' , 'column' ) ;
311: fnd_message.raise_error ;
312: end if ;
313: close c1 ;
314: --

Line 311: fnd_message.raise_error ;

307: if c1%found then
308: close c1 ;
309: fnd_message.set_name ( 'PAY' , 'HR_6980_USERTAB_VALUES_FIRST' ) ;
310: fnd_message.set_token ( 'ROWCOL' , 'column' ) ;
311: fnd_message.raise_error ;
312: end if ;
313: close c1 ;
314: --
315: end check_delete ;

Line 330: fnd_message.set_name ('PER','PER_52480_SSM_NON_UPD_FIELD'); -- checkformat failure

326: from pay_user_columns_vl
327: where row_id = p_rowid;
328: if(p_base_user_column_name <> original_user_column_name) then
329: hr_utility.set_location (l_package_name,1);
330: fnd_message.set_name ('PER','PER_52480_SSM_NON_UPD_FIELD'); -- checkformat failure
331: fnd_message.raise_error;
332: end if;
333: --
334: end check_base_update;

Line 331: fnd_message.raise_error;

327: where row_id = p_rowid;
328: if(p_base_user_column_name <> original_user_column_name) then
329: hr_utility.set_location (l_package_name,1);
330: fnd_message.set_name ('PER','PER_52480_SSM_NON_UPD_FIELD'); -- checkformat failure
331: fnd_message.raise_error;
332: end if;
333: --
334: end check_base_update;
335: --

Line 484: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');

480: CLOSE c_translation;
481: ELSE
482: hr_utility.set_location (l_package_name,70);
483: CLOSE c_translation;
484: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
485: fnd_message.raise_error;
486: END IF;
487: hr_utility.set_location ('Leaving:'||l_package_name,80);
488: END validate_translation;

Line 485: fnd_message.raise_error;

481: ELSE
482: hr_utility.set_location (l_package_name,70);
483: CLOSE c_translation;
484: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
485: fnd_message.raise_error;
486: END IF;
487: hr_utility.set_location ('Leaving:'||l_package_name,80);
488: END validate_translation;
489: --