DBA Data[Home] [Help]

APPS.PAY_BALANCE_FEEDS_F_PKG dependencies on HR_UTILITY

Line 135: hr_utility.set_message(801, 'HR_7444_BAL_FEED_READ_ONLY');

131: then
132: --
133: if ( hr_balance_feeds.bal_classifications_exist(X_Balance_Type_Id))
134: then
135: hr_utility.set_message(801, 'HR_7444_BAL_FEED_READ_ONLY');
136: hr_utility.raise_error;
137: end if;
138: --
139: else

Line 136: hr_utility.raise_error;

132: --
133: if ( hr_balance_feeds.bal_classifications_exist(X_Balance_Type_Id))
134: then
135: hr_utility.set_message(801, 'HR_7444_BAL_FEED_READ_ONLY');
136: hr_utility.raise_error;
137: end if;
138: --
139: else
140: --

Line 149: hr_utility.set_message(801,'HR_7875_BAL_FEED_HAS_INIT_FEED');

145: FETCH C3 into l_found_initial_balance_feed ;
146: CLOSE C3 ;
147: --
148: if ( l_found_initial_balance_feed = 'Y' ) then
149: hr_utility.set_message(801,'HR_7875_BAL_FEED_HAS_INIT_FEED');
150: hr_utility.raise_error;
151: end if;
152: --
153: --

Line 150: hr_utility.raise_error;

146: CLOSE C3 ;
147: --
148: if ( l_found_initial_balance_feed = 'Y' ) then
149: hr_utility.set_message(801,'HR_7875_BAL_FEED_HAS_INIT_FEED');
150: hr_utility.raise_error;
151: end if;
152: --
153: --
154: -- Make sure that there are no processed run results for this input

Line 193: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

189: OPEN C;
190: FETCH C INTO X_Rowid;
191: if (C%NOTFOUND) then
192: CLOSE C;
193: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
194: hr_utility.set_message_token('PROCEDURE',
195: 'pay_balance_feeds_f_pkg.insert_row');
196: hr_utility.set_message_token('STEP','1');
197: hr_utility.raise_error;

Line 194: hr_utility.set_message_token('PROCEDURE',

190: FETCH C INTO X_Rowid;
191: if (C%NOTFOUND) then
192: CLOSE C;
193: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
194: hr_utility.set_message_token('PROCEDURE',
195: 'pay_balance_feeds_f_pkg.insert_row');
196: hr_utility.set_message_token('STEP','1');
197: hr_utility.raise_error;
198: end if;

Line 196: hr_utility.set_message_token('STEP','1');

192: CLOSE C;
193: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
194: hr_utility.set_message_token('PROCEDURE',
195: 'pay_balance_feeds_f_pkg.insert_row');
196: hr_utility.set_message_token('STEP','1');
197: hr_utility.raise_error;
198: end if;
199: CLOSE C;
200: X_Balance_Feed_Id := l_balance_feed_id;

Line 197: hr_utility.raise_error;

193: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
194: hr_utility.set_message_token('PROCEDURE',
195: 'pay_balance_feeds_f_pkg.insert_row');
196: hr_utility.set_message_token('STEP','1');
197: hr_utility.raise_error;
198: end if;
199: CLOSE C;
200: X_Balance_Feed_Id := l_balance_feed_id;
201: --

Line 238: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

234: OPEN C;
235: FETCH C INTO Recinfo;
236: if (C%NOTFOUND) then
237: CLOSE C;
238: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
239: hr_utility.set_message_token('PROCEDURE',
240: 'pay_balance_feeds_f_pkg.lock_row');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;

Line 239: hr_utility.set_message_token('PROCEDURE',

235: FETCH C INTO Recinfo;
236: if (C%NOTFOUND) then
237: CLOSE C;
238: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
239: hr_utility.set_message_token('PROCEDURE',
240: 'pay_balance_feeds_f_pkg.lock_row');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;

Line 241: hr_utility.set_message_token('STEP','1');

237: CLOSE C;
238: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
239: hr_utility.set_message_token('PROCEDURE',
240: 'pay_balance_feeds_f_pkg.lock_row');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
244: CLOSE C;
245: --

Line 242: hr_utility.raise_error;

238: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
239: hr_utility.set_message_token('PROCEDURE',
240: 'pay_balance_feeds_f_pkg.lock_row');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
244: CLOSE C;
245: --
246: -- Remove trailing spaces.

Line 346: hr_utility.set_message(801, 'HR_7444_BAL_FEED_READ_ONLY');

342: then
343: --
344: if ( hr_balance_feeds.bal_classifications_exist(X_Balance_Type_Id))
345: then
346: hr_utility.set_message(801, 'HR_7444_BAL_FEED_READ_ONLY');
347: hr_utility.raise_error;
348: end if;
349: --
350: else

Line 347: hr_utility.raise_error;

343: --
344: if ( hr_balance_feeds.bal_classifications_exist(X_Balance_Type_Id))
345: then
346: hr_utility.set_message(801, 'HR_7444_BAL_FEED_READ_ONLY');
347: hr_utility.raise_error;
348: end if;
349: --
350: else
351: --

Line 372: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

368: legislation_subgroup = X_Legislation_Subgroup
369: WHERE rowid = X_rowid;
370: --
371: if (SQL%NOTFOUND) then
372: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE',
374: 'pay_balance_feeds_f_pkg.update_row');
375: hr_utility.set_message_token('STEP','1');
376: hr_utility.raise_error;

Line 373: hr_utility.set_message_token('PROCEDURE',

369: WHERE rowid = X_rowid;
370: --
371: if (SQL%NOTFOUND) then
372: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE',
374: 'pay_balance_feeds_f_pkg.update_row');
375: hr_utility.set_message_token('STEP','1');
376: hr_utility.raise_error;
377: end if;

Line 375: hr_utility.set_message_token('STEP','1');

371: if (SQL%NOTFOUND) then
372: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE',
374: 'pay_balance_feeds_f_pkg.update_row');
375: hr_utility.set_message_token('STEP','1');
376: hr_utility.raise_error;
377: end if;
378: --
379: END Update_Row;

Line 376: hr_utility.raise_error;

372: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE',
374: 'pay_balance_feeds_f_pkg.update_row');
375: hr_utility.set_message_token('STEP','1');
376: hr_utility.raise_error;
377: end if;
378: --
379: END Update_Row;
380: --

Line 419: hr_utility.set_message(801, 'HR_7444_BAL_FEED_READ_ONLY');

415: --
416: if ( NOT X_Initial_Balance_Feed ) then
417: --
418: if hr_balance_feeds.bal_classifications_exist(X_Balance_Type_Id) then
419: hr_utility.set_message(801, 'HR_7444_BAL_FEED_READ_ONLY');
420: hr_utility.raise_error;
421: end if;
422: --
423: else

Line 420: hr_utility.raise_error;

416: if ( NOT X_Initial_Balance_Feed ) then
417: --
418: if hr_balance_feeds.bal_classifications_exist(X_Balance_Type_Id) then
419: hr_utility.set_message(801, 'HR_7444_BAL_FEED_READ_ONLY');
420: hr_utility.raise_error;
421: end if;
422: --
423: else
424: --

Line 436: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

432: DELETE FROM pay_balance_feeds_f
433: WHERE rowid = X_Rowid;
434: --
435: if (SQL%NOTFOUND) then
436: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
437: hr_utility.set_message_token('PROCEDURE',
438: 'pay_balance_feeds_f_pkg.delete_row');
439: hr_utility.set_message_token('STEP','1');
440: hr_utility.raise_error;

Line 437: hr_utility.set_message_token('PROCEDURE',

433: WHERE rowid = X_Rowid;
434: --
435: if (SQL%NOTFOUND) then
436: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
437: hr_utility.set_message_token('PROCEDURE',
438: 'pay_balance_feeds_f_pkg.delete_row');
439: hr_utility.set_message_token('STEP','1');
440: hr_utility.raise_error;
441: end if;

Line 439: hr_utility.set_message_token('STEP','1');

435: if (SQL%NOTFOUND) then
436: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
437: hr_utility.set_message_token('PROCEDURE',
438: 'pay_balance_feeds_f_pkg.delete_row');
439: hr_utility.set_message_token('STEP','1');
440: hr_utility.raise_error;
441: end if;
442: --
443: END Delete_Row;

Line 440: hr_utility.raise_error;

436: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
437: hr_utility.set_message_token('PROCEDURE',
438: 'pay_balance_feeds_f_pkg.delete_row');
439: hr_utility.set_message_token('STEP','1');
440: hr_utility.raise_error;
441: end if;
442: --
443: END Delete_Row;
444: --

Line 457: hr_utility.set_message(801,'HR_7876_BAL_FEED_RESULTS_EXIST');

453: --
454: OPEN C1 ;
455: FETCH C1 INTO l_dummy ;
456: IF C1%FOUND THEN
457: hr_utility.set_message(801,'HR_7876_BAL_FEED_RESULTS_EXIST');
458: l_return_value := FALSE ;
459: ELSE
460: l_return_value := TRUE ;
461: END IF;

Line 472: hr_utility.raise_error ;

468: PROCEDURE check_run_result_usage ( X_Input_Value_Id IN NUMBER ) IS
469: BEGIN
470: --
471: IF ( NOT check_run_result_usage ( X_Input_Value_Id ) ) THEN
472: hr_utility.raise_error ;
473: END IF;
474: --
475: END check_run_result_usage ;
476: --