eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PBC_BUS dependencies on HR_UTILITY

Line 41: hr_utility.set_location('Entering:'|| l_proc, 10);

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error

Line 76: hr_utility.set_location(' Leaving:'|| l_proc, 20);

72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------

Line 105: hr_utility.set_location('Entering:'|| l_proc, 10);

101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error

Line 123: hr_utility.set_location(l_proc, 20);

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := pay_pbc_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

Line 140: hr_utility.set_location(l_proc,30);

136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --

Line 149: hr_utility.set_location(' Leaving:'|| l_proc, 40);

145: close csr_leg_code;
146: pay_pbc_bus.g_balance_category_id := p_balance_category_id;
147: pay_pbc_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ----------------------------------------------------------------------------

Line 214: hr_utility.set_location('Entering: '||l_proc,5);

210: from pay_balance_categories_f pbc
211: where pbc.category_name = p_category_name;
212: Begin
213: --
214: hr_utility.set_location('Entering: '||l_proc,5);
215: --
216: -- Only execute the cursor if absolutely necessary.
217: -- a) During update, the run_type_name has actually changed to another not
218: -- null value, i,e, the value passed to this procedure is different to the

Line 231: hr_utility.set_location(l_proc, 10);

227: nvl(p_category_name, hr_api.g_varchar2))
228: or
229: (p_balance_category_id is null)) then
230: --
231: hr_utility.set_location(l_proc, 10);
232: --
233: -- Only need to open the cursor if category_name is not null
234: --
235: if p_category_name is not null then

Line 245: hr_utility.trace('insert row');

241: ,l_leg_code
242: ,l_bg_id;
243: IF csr_category_name%NOTFOUND THEN
244: --
245: hr_utility.trace('insert row');
246: CLOSE csr_category_name;
247: ELSE
248: --
249: if l_mode = 'GENERIC' then

Line 250: hr_utility.set_location(l_proc, 15);

246: CLOSE csr_category_name;
247: ELSE
248: --
249: if l_mode = 'GENERIC' then
250: hr_utility.set_location(l_proc, 15);
251: if (l_leg_code is null and l_bg_id is null) then
252: hr_utility.set_message(801,'PAY_34223_CAT_DUP_GEN');
253: hr_utility.raise_error;
254: elsif

Line 252: hr_utility.set_message(801,'PAY_34223_CAT_DUP_GEN');

248: --
249: if l_mode = 'GENERIC' then
250: hr_utility.set_location(l_proc, 15);
251: if (l_leg_code is null and l_bg_id is null) then
252: hr_utility.set_message(801,'PAY_34223_CAT_DUP_GEN');
253: hr_utility.raise_error;
254: elsif
255: l_leg_code is not null
256: or l_bg_id is not null then

Line 253: hr_utility.raise_error;

249: if l_mode = 'GENERIC' then
250: hr_utility.set_location(l_proc, 15);
251: if (l_leg_code is null and l_bg_id is null) then
252: hr_utility.set_message(801,'PAY_34223_CAT_DUP_GEN');
253: hr_utility.raise_error;
254: elsif
255: l_leg_code is not null
256: or l_bg_id is not null then
257: -- name exists at lower level, existing row must be deleted

Line 259: hr_utility.set_message(801,'PAY_34224_S_CAT_LOW_LVL_DEL');

255: l_leg_code is not null
256: or l_bg_id is not null then
257: -- name exists at lower level, existing row must be deleted
258: -- so new seeded row can be inserted.
259: hr_utility.set_message(801,'PAY_34224_S_CAT_LOW_LVL_DEL');
260: hr_utility.raise_error;
261: end if;
262: elsif l_mode = 'STARTUP' THEN
263: hr_utility.set_location(l_proc, 20);

Line 260: hr_utility.raise_error;

256: or l_bg_id is not null then
257: -- name exists at lower level, existing row must be deleted
258: -- so new seeded row can be inserted.
259: hr_utility.set_message(801,'PAY_34224_S_CAT_LOW_LVL_DEL');
260: hr_utility.raise_error;
261: end if;
262: elsif l_mode = 'STARTUP' THEN
263: hr_utility.set_location(l_proc, 20);
264: if (l_leg_code = p_legislation_code) then

Line 263: hr_utility.set_location(l_proc, 20);

259: hr_utility.set_message(801,'PAY_34224_S_CAT_LOW_LVL_DEL');
260: hr_utility.raise_error;
261: end if;
262: elsif l_mode = 'STARTUP' THEN
263: hr_utility.set_location(l_proc, 20);
264: if (l_leg_code = p_legislation_code) then
265: hr_utility.set_message(801,'PAY_34225_CAT_DUP_S');
266: hr_utility.raise_error;
267: elsif

Line 265: hr_utility.set_message(801,'PAY_34225_CAT_DUP_S');

261: end if;
262: elsif l_mode = 'STARTUP' THEN
263: hr_utility.set_location(l_proc, 20);
264: if (l_leg_code = p_legislation_code) then
265: hr_utility.set_message(801,'PAY_34225_CAT_DUP_S');
266: hr_utility.raise_error;
267: elsif
268: l_leg_code is null then
269: if l_bg_id is not null then

Line 266: hr_utility.raise_error;

262: elsif l_mode = 'STARTUP' THEN
263: hr_utility.set_location(l_proc, 20);
264: if (l_leg_code = p_legislation_code) then
265: hr_utility.set_message(801,'PAY_34225_CAT_DUP_S');
266: hr_utility.raise_error;
267: elsif
268: l_leg_code is null then
269: if l_bg_id is not null then
270: hr_utility.trace('here');

Line 270: hr_utility.trace('here');

266: hr_utility.raise_error;
267: elsif
268: l_leg_code is null then
269: if l_bg_id is not null then
270: hr_utility.trace('here');
271: hr_utility.set_message(801,'PAY_34226_U_CAT_LOW_LVL_DEL');
272: hr_utility.raise_error;
273: else -- l_bg_id is null then
274: hr_utility.trace('here2');

Line 271: hr_utility.set_message(801,'PAY_34226_U_CAT_LOW_LVL_DEL');

267: elsif
268: l_leg_code is null then
269: if l_bg_id is not null then
270: hr_utility.trace('here');
271: hr_utility.set_message(801,'PAY_34226_U_CAT_LOW_LVL_DEL');
272: hr_utility.raise_error;
273: else -- l_bg_id is null then
274: hr_utility.trace('here2');
275: hr_utility.set_message(801,'PAY_34227_G_CAT_HI_LVL');

Line 272: hr_utility.raise_error;

268: l_leg_code is null then
269: if l_bg_id is not null then
270: hr_utility.trace('here');
271: hr_utility.set_message(801,'PAY_34226_U_CAT_LOW_LVL_DEL');
272: hr_utility.raise_error;
273: else -- l_bg_id is null then
274: hr_utility.trace('here2');
275: hr_utility.set_message(801,'PAY_34227_G_CAT_HI_LVL');
276: hr_utility.raise_error;

Line 274: hr_utility.trace('here2');

270: hr_utility.trace('here');
271: hr_utility.set_message(801,'PAY_34226_U_CAT_LOW_LVL_DEL');
272: hr_utility.raise_error;
273: else -- l_bg_id is null then
274: hr_utility.trace('here2');
275: hr_utility.set_message(801,'PAY_34227_G_CAT_HI_LVL');
276: hr_utility.raise_error;
277: end if;
278: end if;

Line 275: hr_utility.set_message(801,'PAY_34227_G_CAT_HI_LVL');

271: hr_utility.set_message(801,'PAY_34226_U_CAT_LOW_LVL_DEL');
272: hr_utility.raise_error;
273: else -- l_bg_id is null then
274: hr_utility.trace('here2');
275: hr_utility.set_message(801,'PAY_34227_G_CAT_HI_LVL');
276: hr_utility.raise_error;
277: end if;
278: end if;
279: end if; -- what mode

Line 276: hr_utility.raise_error;

272: hr_utility.raise_error;
273: else -- l_bg_id is null then
274: hr_utility.trace('here2');
275: hr_utility.set_message(801,'PAY_34227_G_CAT_HI_LVL');
276: hr_utility.raise_error;
277: end if;
278: end if;
279: end if; -- what mode
280: close csr_category_name;

Line 285: hr_utility.set_location('Leaving: '||l_proc, 20);

281: --
282: END IF;
283: end if;
284: end if;
285: hr_utility.set_location('Leaving: '||l_proc, 20);
286: --
287: END chk_category_name;
288: -- ----------------------------------------------------------------------------
289: -- |-----------------------< chk_user_category_name >-------------------------|

Line 347: hr_utility.set_location('Entering: '||l_proc,5);

343: from pay_balance_categories_f pbc
344: where pbc.user_category_name = p_user_category_name;
345: Begin
346: --
347: hr_utility.set_location('Entering: '||l_proc,5);
348: --
349: -- Only execute the cursor if absolutely necessary.
350: -- a) During update, the user_category_name has actually changed to another not
351: -- null value, i,e, the value passed to this procedure is different to the

Line 364: hr_utility.set_location(l_proc, 10);

360: nvl(p_user_category_name, hr_api.g_varchar2))
361: or
362: (p_balance_category_id is null)) then
363: --
364: hr_utility.set_location(l_proc, 10);
365: --
366: -- Only need to open the cursor if user_category_name is not null
367: --
368: if p_user_category_name is not null then

Line 378: hr_utility.trace('insert row');

374: ,l_leg_code
375: ,l_bg_id;
376: IF csr_user_category_name%NOTFOUND THEN
377: --
378: hr_utility.trace('insert row');
379: CLOSE csr_user_category_name;
380: ELSE
381: --
382: if l_mode = 'GENERIC' then

Line 383: hr_utility.set_location(l_proc, 15);

379: CLOSE csr_user_category_name;
380: ELSE
381: --
382: if l_mode = 'GENERIC' then
383: hr_utility.set_location(l_proc, 15);
384: if (l_leg_code is null and l_bg_id is null) then
385: hr_utility.set_message(801,'PAY_34272_USR_CAT_DUP_GEN');
386: hr_utility.raise_error;
387: elsif

Line 385: hr_utility.set_message(801,'PAY_34272_USR_CAT_DUP_GEN');

381: --
382: if l_mode = 'GENERIC' then
383: hr_utility.set_location(l_proc, 15);
384: if (l_leg_code is null and l_bg_id is null) then
385: hr_utility.set_message(801,'PAY_34272_USR_CAT_DUP_GEN');
386: hr_utility.raise_error;
387: elsif
388: l_leg_code is not null
389: or l_bg_id is not null then

Line 386: hr_utility.raise_error;

382: if l_mode = 'GENERIC' then
383: hr_utility.set_location(l_proc, 15);
384: if (l_leg_code is null and l_bg_id is null) then
385: hr_utility.set_message(801,'PAY_34272_USR_CAT_DUP_GEN');
386: hr_utility.raise_error;
387: elsif
388: l_leg_code is not null
389: or l_bg_id is not null then
390: -- name exists at lower level, existing row must be deleted

Line 392: hr_utility.set_message(801,'PAY_34273_S_USRCAT_LOWLVL_DEL');

388: l_leg_code is not null
389: or l_bg_id is not null then
390: -- name exists at lower level, existing row must be deleted
391: -- so new seeded row can be inserted.
392: hr_utility.set_message(801,'PAY_34273_S_USRCAT_LOWLVL_DEL');
393: hr_utility.raise_error;
394: end if;
395: elsif l_mode = 'STARTUP' THEN
396: hr_utility.set_location(l_proc, 20);

Line 393: hr_utility.raise_error;

389: or l_bg_id is not null then
390: -- name exists at lower level, existing row must be deleted
391: -- so new seeded row can be inserted.
392: hr_utility.set_message(801,'PAY_34273_S_USRCAT_LOWLVL_DEL');
393: hr_utility.raise_error;
394: end if;
395: elsif l_mode = 'STARTUP' THEN
396: hr_utility.set_location(l_proc, 20);
397: if (l_leg_code = p_legislation_code) then

Line 396: hr_utility.set_location(l_proc, 20);

392: hr_utility.set_message(801,'PAY_34273_S_USRCAT_LOWLVL_DEL');
393: hr_utility.raise_error;
394: end if;
395: elsif l_mode = 'STARTUP' THEN
396: hr_utility.set_location(l_proc, 20);
397: if (l_leg_code = p_legislation_code) then
398: hr_utility.set_message(801,'PAY_34274_USRCAT_DUP_S');
399: hr_utility.raise_error;
400: elsif

Line 398: hr_utility.set_message(801,'PAY_34274_USRCAT_DUP_S');

394: end if;
395: elsif l_mode = 'STARTUP' THEN
396: hr_utility.set_location(l_proc, 20);
397: if (l_leg_code = p_legislation_code) then
398: hr_utility.set_message(801,'PAY_34274_USRCAT_DUP_S');
399: hr_utility.raise_error;
400: elsif
401: l_leg_code is null then
402: if l_bg_id is not null then

Line 399: hr_utility.raise_error;

395: elsif l_mode = 'STARTUP' THEN
396: hr_utility.set_location(l_proc, 20);
397: if (l_leg_code = p_legislation_code) then
398: hr_utility.set_message(801,'PAY_34274_USRCAT_DUP_S');
399: hr_utility.raise_error;
400: elsif
401: l_leg_code is null then
402: if l_bg_id is not null then
403: hr_utility.trace('here');

Line 403: hr_utility.trace('here');

399: hr_utility.raise_error;
400: elsif
401: l_leg_code is null then
402: if l_bg_id is not null then
403: hr_utility.trace('here');
404: hr_utility.set_message(801,'PAY_34275_U_USRCAT_LOWLVL_DEL');
405: hr_utility.raise_error;
406: else -- l_bg_id is null then
407: hr_utility.trace('here2');

Line 404: hr_utility.set_message(801,'PAY_34275_U_USRCAT_LOWLVL_DEL');

400: elsif
401: l_leg_code is null then
402: if l_bg_id is not null then
403: hr_utility.trace('here');
404: hr_utility.set_message(801,'PAY_34275_U_USRCAT_LOWLVL_DEL');
405: hr_utility.raise_error;
406: else -- l_bg_id is null then
407: hr_utility.trace('here2');
408: hr_utility.set_message(801,'PAY_34276_G_USRCAT_HI_LVL');

Line 405: hr_utility.raise_error;

401: l_leg_code is null then
402: if l_bg_id is not null then
403: hr_utility.trace('here');
404: hr_utility.set_message(801,'PAY_34275_U_USRCAT_LOWLVL_DEL');
405: hr_utility.raise_error;
406: else -- l_bg_id is null then
407: hr_utility.trace('here2');
408: hr_utility.set_message(801,'PAY_34276_G_USRCAT_HI_LVL');
409: hr_utility.raise_error;

Line 407: hr_utility.trace('here2');

403: hr_utility.trace('here');
404: hr_utility.set_message(801,'PAY_34275_U_USRCAT_LOWLVL_DEL');
405: hr_utility.raise_error;
406: else -- l_bg_id is null then
407: hr_utility.trace('here2');
408: hr_utility.set_message(801,'PAY_34276_G_USRCAT_HI_LVL');
409: hr_utility.raise_error;
410: end if;
411: end if;

Line 408: hr_utility.set_message(801,'PAY_34276_G_USRCAT_HI_LVL');

404: hr_utility.set_message(801,'PAY_34275_U_USRCAT_LOWLVL_DEL');
405: hr_utility.raise_error;
406: else -- l_bg_id is null then
407: hr_utility.trace('here2');
408: hr_utility.set_message(801,'PAY_34276_G_USRCAT_HI_LVL');
409: hr_utility.raise_error;
410: end if;
411: end if;
412: end if; -- what mode

Line 409: hr_utility.raise_error;

405: hr_utility.raise_error;
406: else -- l_bg_id is null then
407: hr_utility.trace('here2');
408: hr_utility.set_message(801,'PAY_34276_G_USRCAT_HI_LVL');
409: hr_utility.raise_error;
410: end if;
411: end if;
412: end if; -- what mode
413: close csr_user_category_name;

Line 418: hr_utility.set_location('Leaving: '||l_proc, 20);

414: --
415: END IF;
416: end if;
417: end if;
418: hr_utility.set_location('Leaving: '||l_proc, 20);
419: --
420: END chk_user_category_name;
421: -- ----------------------------------------------------------------------------
422: -- |----------------------< chk_save_run_bal_enabled >------------------------|

Line 461: hr_utility.set_location('Entering: '||l_proc,5);

457: l_argument varchar2(30);
458: --
459: Begin
460: --
461: hr_utility.set_location('Entering: '||l_proc,5);
462: --
463: -- YES_NO is a system level lookup, so only need to validate against
464: -- hr_standar_lookups, even though the table has a business_group_id and
465: -- would expect to need to validate against hr_lookups.

Line 483: hr_utility.set_location(l_proc,10);

479: --
480: fnd_message.set_name('PAY', 'PAY_34228_PBC_INV_LOOKUP');
481: fnd_message.raise_error;
482: --
483: hr_utility.set_location(l_proc,10);
484: END IF;
485: end if;
486: --
487: hr_utility.set_location('Leaving: '||l_proc,15);

Line 487: hr_utility.set_location('Leaving: '||l_proc,15);

483: hr_utility.set_location(l_proc,10);
484: END IF;
485: end if;
486: --
487: hr_utility.set_location('Leaving: '||l_proc,15);
488: --
489: End chk_save_run_bal_enabled;
490: --
491: -- ----------------------------------------------------------------------------

Line 526: hr_utility.set_location('Entering:'||l_proc,10);

522: --
523: l_proc varchar2(72) := g_package || 'chk_ddf';
524: --
525: begin
526: hr_utility.set_location('Entering:'||l_proc,10);
527: --
528: if ((p_rec.balance_category_id is not null) and (
529: nvl(pay_pbc_shd.g_old_rec.pbc_information_category, hr_api.g_varchar2) <>
530: nvl(p_rec.pbc_information_category, hr_api.g_varchar2) or

Line 666: hr_utility.set_location(' Leaving:'||l_proc,20);

662: ,p_attribute30_value => p_rec.pbc_information30
663: );
664: end if;
665: --
666: hr_utility.set_location(' Leaving:'||l_proc,20);
667: end chk_ddf;
668: --
669: -- ----------------------------------------------------------------------------
670: -- |-------------------------< chk_for_child_rows >---------------------------|

Line 731: hr_utility.set_location('Entering: '||l_proc,5);

727: l_argument varchar2(30);
728: l_exists number(1);
729: --
730: BEGIN
731: hr_utility.set_location('Entering: '||l_proc,5);
732: --
733: if p_legislation_code is not null then -- startup category
734: --
735: for each_bg in get_bg_id loop

Line 740: hr_utility.set_message(801,'PAY_34230_PBC_CHILD_BAL');

736: open csr_child_balance(p_balance_category_id, each_bg.business_group_id);
737: fetch csr_child_balance into l_exists;
738: if csr_child_balance%FOUND then
739: close csr_child_balance;
740: hr_utility.set_message(801,'PAY_34230_PBC_CHILD_BAL');
741: hr_utility.raise_error;
742: hr_utility.set_location(l_proc, 10);
743: else
744: close csr_child_balance;

Line 741: hr_utility.raise_error;

737: fetch csr_child_balance into l_exists;
738: if csr_child_balance%FOUND then
739: close csr_child_balance;
740: hr_utility.set_message(801,'PAY_34230_PBC_CHILD_BAL');
741: hr_utility.raise_error;
742: hr_utility.set_location(l_proc, 10);
743: else
744: close csr_child_balance;
745: end if;

Line 742: hr_utility.set_location(l_proc, 10);

738: if csr_child_balance%FOUND then
739: close csr_child_balance;
740: hr_utility.set_message(801,'PAY_34230_PBC_CHILD_BAL');
741: hr_utility.raise_error;
742: hr_utility.set_location(l_proc, 10);
743: else
744: close csr_child_balance;
745: end if;
746: --

Line 753: hr_utility.set_message(801,'PAY_34229_PBC_CHLD_ATT_DEFAULT');

749: open csr_child_defaults(p_balance_category_id, each_bg.business_group_id);
750: fetch csr_child_defaults into l_exists;
751: if csr_child_defaults%FOUND then
752: close csr_child_defaults;
753: hr_utility.set_message(801,'PAY_34229_PBC_CHLD_ATT_DEFAULT');
754: hr_utility.raise_error;
755: hr_utility.set_location(l_proc, 15);
756: else
757: close csr_child_defaults;

Line 754: hr_utility.raise_error;

750: fetch csr_child_defaults into l_exists;
751: if csr_child_defaults%FOUND then
752: close csr_child_defaults;
753: hr_utility.set_message(801,'PAY_34229_PBC_CHLD_ATT_DEFAULT');
754: hr_utility.raise_error;
755: hr_utility.set_location(l_proc, 15);
756: else
757: close csr_child_defaults;
758: end if;

Line 755: hr_utility.set_location(l_proc, 15);

751: if csr_child_defaults%FOUND then
752: close csr_child_defaults;
753: hr_utility.set_message(801,'PAY_34229_PBC_CHLD_ATT_DEFAULT');
754: hr_utility.raise_error;
755: hr_utility.set_location(l_proc, 15);
756: else
757: close csr_child_defaults;
758: end if;
759: end loop;

Line 766: hr_utility.set_message(801,'PAY_34230_PBC_CHILD_BAL');

762: open csr_child_balance(p_balance_category_id, p_business_group_id);
763: fetch csr_child_balance into l_exists;
764: if csr_child_balance%FOUND then
765: close csr_child_balance;
766: hr_utility.set_message(801,'PAY_34230_PBC_CHILD_BAL');
767: hr_utility.raise_error;
768: hr_utility.set_location(l_proc, 20);
769: else
770: close csr_child_balance;

Line 767: hr_utility.raise_error;

763: fetch csr_child_balance into l_exists;
764: if csr_child_balance%FOUND then
765: close csr_child_balance;
766: hr_utility.set_message(801,'PAY_34230_PBC_CHILD_BAL');
767: hr_utility.raise_error;
768: hr_utility.set_location(l_proc, 20);
769: else
770: close csr_child_balance;
771: end if;

Line 768: hr_utility.set_location(l_proc, 20);

764: if csr_child_balance%FOUND then
765: close csr_child_balance;
766: hr_utility.set_message(801,'PAY_34230_PBC_CHILD_BAL');
767: hr_utility.raise_error;
768: hr_utility.set_location(l_proc, 20);
769: else
770: close csr_child_balance;
771: end if;
772: --

Line 779: hr_utility.set_message(801,'PAY_34229_PBC_CHLD_ATT_DEFAULT');

775: open csr_child_defaults(p_balance_category_id, p_business_group_id);
776: fetch csr_child_defaults into l_exists;
777: if csr_child_defaults%FOUND then
778: close csr_child_defaults;
779: hr_utility.set_message(801,'PAY_34229_PBC_CHLD_ATT_DEFAULT');
780: hr_utility.raise_error;
781: hr_utility.set_location(l_proc, 25);
782: else
783: close csr_child_defaults;

Line 780: hr_utility.raise_error;

776: fetch csr_child_defaults into l_exists;
777: if csr_child_defaults%FOUND then
778: close csr_child_defaults;
779: hr_utility.set_message(801,'PAY_34229_PBC_CHLD_ATT_DEFAULT');
780: hr_utility.raise_error;
781: hr_utility.set_location(l_proc, 25);
782: else
783: close csr_child_defaults;
784: end if;

Line 781: hr_utility.set_location(l_proc, 25);

777: if csr_child_defaults%FOUND then
778: close csr_child_defaults;
779: hr_utility.set_message(801,'PAY_34229_PBC_CHLD_ATT_DEFAULT');
780: hr_utility.raise_error;
781: hr_utility.set_location(l_proc, 25);
782: else
783: close csr_child_defaults;
784: end if;
785: END IF;

Line 786: hr_utility.set_location(' Leaving:'|| l_proc, 40);

782: else
783: close csr_child_defaults;
784: end if;
785: END IF;
786: hr_utility.set_location(' Leaving:'|| l_proc, 40);
787: --
788: End chk_for_child_rows;
789: -- ----------------------------------------------------------------------------
790: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 841: hr_utility.set_location(l_proc, 10);

837: fnd_message.set_token('STEP ', '5');
838: fnd_message.raise_error;
839: END IF;
840: --
841: hr_utility.set_location(l_proc, 10);
842: --
843: if nvl(p_rec.business_group_id, hr_api.g_number) <>
844: nvl(pay_pbc_shd.g_old_rec.business_group_id, hr_api.g_number) then
845: l_argument := 'business_group_id';

Line 848: hr_utility.set_location(l_proc, 15);

844: nvl(pay_pbc_shd.g_old_rec.business_group_id, hr_api.g_number) then
845: l_argument := 'business_group_id';
846: raise l_error;
847: end if;
848: hr_utility.set_location(l_proc, 15);
849: --
850: if p_rec.balance_category_id <> pay_pbc_shd.g_old_rec.balance_category_id then
851: l_argument := 'balance_category_id';
852: raise l_error;

Line 854: hr_utility.set_location(l_proc, 20);

850: if p_rec.balance_category_id <> pay_pbc_shd.g_old_rec.balance_category_id then
851: l_argument := 'balance_category_id';
852: raise l_error;
853: end if;
854: hr_utility.set_location(l_proc, 20);
855: --
856: if p_rec.legislation_code <> pay_pbc_shd.g_old_rec.legislation_code then
857: l_argument := 'legislation_code';
858: raise l_error;

Line 860: hr_utility.set_location(l_proc, 25);

856: if p_rec.legislation_code <> pay_pbc_shd.g_old_rec.legislation_code then
857: l_argument := 'legislation_code';
858: raise l_error;
859: end if;
860: hr_utility.set_location(l_proc, 25);
861: --
862: if p_rec.category_name <> pay_pbc_shd.g_old_rec.category_name then
863: l_argument := 'category_name';
864: raise l_error;

Line 866: hr_utility.set_location(l_proc, 30);

862: if p_rec.category_name <> pay_pbc_shd.g_old_rec.category_name then
863: l_argument := 'category_name';
864: raise l_error;
865: end if;
866: hr_utility.set_location(l_proc, 30);
867: --
868: EXCEPTION
869: WHEN l_error THEN
870: hr_api.argument_changed_error

Line 875: hr_utility.set_location(' Leaving:'|| l_proc, 40);

871: (p_api_name => l_proc
872: ,p_argument => l_argument);
873: WHEN OTHERS THEN
874: RAISE;
875: hr_utility.set_location(' Leaving:'|| l_proc, 40);
876: --
877: End chk_non_updateable_args;
878: --
879: -- ----------------------------------------------------------------------------

Line 1110: hr_utility.set_location('Entering:'||l_proc, 5);

1106: --
1107: l_proc varchar2(72) := g_package||'insert_validate';
1108: --
1109: Begin
1110: hr_utility.set_location('Entering:'||l_proc, 5);
1111: --
1112: -- Call all supporting business operations
1113: --
1114: --

Line 1162: hr_utility.set_location(' Leaving:'||l_proc, 10);

1158: );
1159: --
1160: pay_pbc_bus.chk_ddf(p_rec);
1161: --
1162: hr_utility.set_location(' Leaving:'||l_proc, 10);
1163: End insert_validate;
1164: --
1165: -- ----------------------------------------------------------------------------
1166: -- |---------------------------< update_validate >----------------------------|

Line 1179: hr_utility.set_location('Entering:'||l_proc, 5);

1175: --
1176: l_proc varchar2(72) := g_package||'update_validate';
1177: --
1178: Begin
1179: hr_utility.set_location('Entering:'||l_proc, 5);
1180: --
1181: -- Call all supporting business operations
1182: --
1183: --

Line 1246: hr_utility.set_location(' Leaving:'||l_proc, 10);

1242: --
1243: --
1244: pay_pbc_bus.chk_ddf(p_rec);
1245: --
1246: hr_utility.set_location(' Leaving:'||l_proc, 10);
1247: End update_validate;
1248: --
1249: -- ----------------------------------------------------------------------------
1250: -- |---------------------------< delete_validate >----------------------------|

Line 1263: hr_utility.set_location('Entering:'||l_proc, 5);

1259: --
1260: l_proc varchar2(72) := g_package||'delete_validate';
1261: --
1262: Begin
1263: hr_utility.set_location('Entering:'||l_proc, 5);
1264: --
1265: -- NB. need to use g_old_rec, as p_rec is not pupulated with all the columns
1266: -- for delete mode.
1267: --

Line 1288: hr_utility.set_location(' Leaving:'||l_proc, 10);

1284: ,p_validation_end_date => p_validation_end_date
1285: ,p_balance_category_id => p_rec.balance_category_id
1286: );
1287: --
1288: hr_utility.set_location(' Leaving:'||l_proc, 10);
1289: End delete_validate;
1290: --
1291: end pay_pbc_bus;