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_DEFINED_BALANCES_PKG dependencies on HR_UTILITY

Line 44: hr_utility.set_message(801, 'HR_6117_BAL_UNI_DIMENSION');

40: open csr_unique_defined_balance;
41: fetch csr_unique_defined_balance into v_defined_balance_id;
42: if csr_unique_defined_balance%found then
43: close csr_unique_defined_balance;
44: hr_utility.set_message(801, 'HR_6117_BAL_UNI_DIMENSION');
45: hr_utility.raise_error;
46: else
47: close csr_unique_defined_balance;
48: end if;

Line 45: hr_utility.raise_error;

41: fetch csr_unique_defined_balance into v_defined_balance_id;
42: if csr_unique_defined_balance%found then
43: close csr_unique_defined_balance;
44: hr_utility.set_message(801, 'HR_6117_BAL_UNI_DIMENSION');
45: hr_utility.raise_error;
46: else
47: close csr_unique_defined_balance;
48: end if;
49: --

Line 93: hr_utility.set_message(801, 'HR_6958_PAY_ORG_PAY_MTHD_EXIST');

89: open csr_org_pay_meth;
90: fetch csr_org_pay_meth into v_org_pay_meth_id;
91: if csr_org_pay_meth%found then
92: close csr_org_pay_meth;
93: hr_utility.set_message(801, 'HR_6958_PAY_ORG_PAY_MTHD_EXIST');
94: hr_utility.raise_error;
95: else
96: close csr_org_pay_meth;
97: end if;

Line 94: hr_utility.raise_error;

90: fetch csr_org_pay_meth into v_org_pay_meth_id;
91: if csr_org_pay_meth%found then
92: close csr_org_pay_meth;
93: hr_utility.set_message(801, 'HR_6958_PAY_ORG_PAY_MTHD_EXIST');
94: hr_utility.raise_error;
95: else
96: close csr_org_pay_meth;
97: end if;
98: --

Line 104: hr_utility.set_message(801, 'HR_7046_BACK_PAY_EXIST');

100: open csr_backpay_set;
101: fetch csr_backpay_set into v_backpay_set_id;
102: if csr_backpay_set%found then
103: close csr_backpay_set;
104: hr_utility.set_message(801, 'HR_7046_BACK_PAY_EXIST');
105: hr_utility.raise_error;
106: else
107: close csr_backpay_set;
108: end if;

Line 105: hr_utility.raise_error;

101: fetch csr_backpay_set into v_backpay_set_id;
102: if csr_backpay_set%found then
103: close csr_backpay_set;
104: hr_utility.set_message(801, 'HR_7046_BACK_PAY_EXIST');
105: hr_utility.raise_error;
106: else
107: close csr_backpay_set;
108: end if;
109: --

Line 425: hr_utility.set_location('Entering pay_defined_balances_pkg.insert_row', 5);

421: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
422: l_eff_date date;
423: --
424: BEGIN
425: hr_utility.set_location('Entering pay_defined_balances_pkg.insert_row', 5);
426: --
427: -- Make sure that defined balance is unique.
428: chk_defined_balance
429: (X_Rowid,

Line 434: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 10);

430: X_Business_Group_Id,
431: X_Legislation_Code,
432: X_Balance_Type_Id,
433: X_Balance_Dimension_Id);
434: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 10);
435: --
436: if (X_Defined_Balance_Id is NULL) then
437: OPEN C2;
438: FETCH C2 INTO X_Defined_Balance_Id;

Line 447: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 15);

443: FETCH C3 INTO l_exists;
444: if ( (l_exists = 0 and X_Grossup_Allowed_Flag = 'Y')
445: or (X_Grossup_Allowed_Flag = 'N') ) then
446: --
447: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 15);
448: --
449: -- check whether save_run_balance can be automatically derived
450: -- from the category and dimension flags.
451: --

Line 456: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 20);

452: if x_balance_category_id is null then -- could be called from serverside
453: --
454: -- get bal cat id for the balance type, if there is one
455: --
456: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 20);
457: --
458: open get_bal_cat_id(x_balance_type_id);
459: fetch get_bal_cat_id into l_bal_cat_id;
460: if get_bal_cat_id%notfound then

Line 470: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 25);

466: --
467: -- row returned, so if the effective date is null, default it.
468: --
469: if x_effective_date is null then
470: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 25);
471: open get_eff_date;
472: fetch get_eff_date into l_eff_date;
473: if get_eff_date%notfound then
474: l_eff_date := trunc(sysdate);

Line 477: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 30);

473: if get_eff_date%notfound then
474: l_eff_date := trunc(sysdate);
475: end if;
476: else
477: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 30);
478: l_eff_date := x_effective_date;
479: end if;
480: end if;
481: else -- x_balance_category is not null

Line 482: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 35);

478: l_eff_date := x_effective_date;
479: end if;
480: end if;
481: else -- x_balance_category is not null
482: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 35);
483: l_bal_cat_id := x_balance_category_id;
484: --
485: if x_effective_date is null then
486: hr_utility.set_message(801, 'PAY_34262_CAT_EFF_DATE_NULL');

Line 486: hr_utility.set_message(801, 'PAY_34262_CAT_EFF_DATE_NULL');

482: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 35);
483: l_bal_cat_id := x_balance_category_id;
484: --
485: if x_effective_date is null then
486: hr_utility.set_message(801, 'PAY_34262_CAT_EFF_DATE_NULL');
487: hr_utility.raise_error;
488: else
489: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 40);
490: l_eff_date := x_effective_date;

Line 487: hr_utility.raise_error;

483: l_bal_cat_id := x_balance_category_id;
484: --
485: if x_effective_date is null then
486: hr_utility.set_message(801, 'PAY_34262_CAT_EFF_DATE_NULL');
487: hr_utility.raise_error;
488: else
489: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 40);
490: l_eff_date := x_effective_date;
491: end if;

Line 489: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 40);

485: if x_effective_date is null then
486: hr_utility.set_message(801, 'PAY_34262_CAT_EFF_DATE_NULL');
487: hr_utility.raise_error;
488: else
489: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 40);
490: l_eff_date := x_effective_date;
491: end if;
492: end if;
493: --

Line 498: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 45);

494: l_save_run_bal_flag := set_save_run_bals_flag(l_bal_cat_id
495: ,l_eff_date
496: ,x_balance_dimension_id);
497: --
498: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 45);
499: --
500: INSERT INTO pay_defined_balances
501: (defined_balance_id,
502: business_group_id,

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

517: X_Legislation_Subgroup,
518: X_Grossup_Allowed_Flag,
519: l_save_run_bal_flag);
520: --
521: hr_utility.trace('here');
522: OPEN C;
523: FETCH C INTO X_Rowid;
524: if (C%NOTFOUND) then
525: CLOSE C;

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

522: OPEN C;
523: FETCH C INTO X_Rowid;
524: if (C%NOTFOUND) then
525: CLOSE C;
526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
527: hr_utility.set_message_token('PROCEDURE',
528: 'pay_defined_balances_pkg.insert_row');
529: hr_utility.set_message_token('STEP','1');
530: hr_utility.raise_error;

Line 527: hr_utility.set_message_token('PROCEDURE',

523: FETCH C INTO X_Rowid;
524: if (C%NOTFOUND) then
525: CLOSE C;
526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
527: hr_utility.set_message_token('PROCEDURE',
528: 'pay_defined_balances_pkg.insert_row');
529: hr_utility.set_message_token('STEP','1');
530: hr_utility.raise_error;
531: end if;

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

525: CLOSE C;
526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
527: hr_utility.set_message_token('PROCEDURE',
528: 'pay_defined_balances_pkg.insert_row');
529: hr_utility.set_message_token('STEP','1');
530: hr_utility.raise_error;
531: end if;
532: CLOSE C;
533: --

Line 530: hr_utility.raise_error;

526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
527: hr_utility.set_message_token('PROCEDURE',
528: 'pay_defined_balances_pkg.insert_row');
529: hr_utility.set_message_token('STEP','1');
530: hr_utility.raise_error;
531: end if;
532: CLOSE C;
533: --
534: -- insert balance attributes after defined balance created. Check the

Line 539: hr_utility.trace('x_mode: '||x_mode);

535: -- pay_bal_attribute_defaults table. If a row exists for the category_id
536: -- of the balance_type of the defined balance just inserted, and the dimension
537: -- just inserted, then create the associated attribute.
538: --
539: hr_utility.trace('x_mode: '||x_mode);
540: --
541: if x_mode is null or x_mode <> 'FORM' then
542: --
543: -- if the variable l_bal_cat_id is null, then no need to try and insert

Line 546: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 50);

542: --
543: -- if the variable l_bal_cat_id is null, then no need to try and insert
544: -- attribute_defaults
545: --
546: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 50);
547: if l_bal_cat_id is not null then
548: --
549: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 55);
550: insert_default_attrib_wrapper

Line 549: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 55);

545: --
546: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 50);
547: if l_bal_cat_id is not null then
548: --
549: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 55);
550: insert_default_attrib_wrapper
551: (p_balance_dimension_id => x_balance_dimension_id
552: ,p_balance_category_id => l_bal_cat_id
553: ,p_def_bal_bg_id => x_business_group_id

Line 558: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 60);

554: ,p_def_bal_leg_code => x_legislation_code
555: ,p_defined_balance_id => x_defined_balance_id
556: ,p_effective_date => l_eff_date
557: );
558: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 60);
559: end if;
560: end if;
561: else
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

558: hr_utility.set_location('pay_defined_balances_pkg.insert_row', 60);
559: end if;
560: end if;
561: else
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE',
564: 'pay_defined_balances_pkg.insert_row');
565: hr_utility.set_message_token('STEP','1');
566: hr_utility.raise_error;

Line 563: hr_utility.set_message_token('PROCEDURE',

559: end if;
560: end if;
561: else
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE',
564: 'pay_defined_balances_pkg.insert_row');
565: hr_utility.set_message_token('STEP','1');
566: hr_utility.raise_error;
567: end if;

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

561: else
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE',
564: 'pay_defined_balances_pkg.insert_row');
565: hr_utility.set_message_token('STEP','1');
566: hr_utility.raise_error;
567: end if;
568: END Insert_Row;
569: --

Line 566: hr_utility.raise_error;

562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE',
564: 'pay_defined_balances_pkg.insert_row');
565: hr_utility.set_message_token('STEP','1');
566: hr_utility.raise_error;
567: end if;
568: END Insert_Row;
569: --
570: -----------------------------------------------------------------------------

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

600: OPEN C;
601: FETCH C INTO Recinfo;
602: if (C%NOTFOUND) then
603: CLOSE C;
604: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
605: hr_utility.set_message_token('PROCEDURE',
606: 'pay_defined_balances_pkg.lock_row');
607: hr_utility.set_message_token('STEP','1');
608: hr_utility.raise_error;

Line 605: hr_utility.set_message_token('PROCEDURE',

601: FETCH C INTO Recinfo;
602: if (C%NOTFOUND) then
603: CLOSE C;
604: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
605: hr_utility.set_message_token('PROCEDURE',
606: 'pay_defined_balances_pkg.lock_row');
607: hr_utility.set_message_token('STEP','1');
608: hr_utility.raise_error;
609: end if;

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

603: CLOSE C;
604: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
605: hr_utility.set_message_token('PROCEDURE',
606: 'pay_defined_balances_pkg.lock_row');
607: hr_utility.set_message_token('STEP','1');
608: hr_utility.raise_error;
609: end if;
610: CLOSE C;
611: --

Line 608: hr_utility.raise_error;

604: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
605: hr_utility.set_message_token('PROCEDURE',
606: 'pay_defined_balances_pkg.lock_row');
607: hr_utility.set_message_token('STEP','1');
608: hr_utility.raise_error;
609: end if;
610: CLOSE C;
611: --
612: -- Removed trailing spaces.

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

694: grossup_allowed_flag = X_Grossup_Allowed_Flag
695: WHERE rowid = X_rowid;
696: --
697: if (SQL%NOTFOUND) then
698: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
699: hr_utility.set_message_token('PROCEDURE',
700: 'pay_defined_balances_pkg.update_row');
701: hr_utility.set_message_token('STEP','1');
702: hr_utility.raise_error;

Line 699: hr_utility.set_message_token('PROCEDURE',

695: WHERE rowid = X_rowid;
696: --
697: if (SQL%NOTFOUND) then
698: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
699: hr_utility.set_message_token('PROCEDURE',
700: 'pay_defined_balances_pkg.update_row');
701: hr_utility.set_message_token('STEP','1');
702: hr_utility.raise_error;
703: end if;

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

697: if (SQL%NOTFOUND) then
698: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
699: hr_utility.set_message_token('PROCEDURE',
700: 'pay_defined_balances_pkg.update_row');
701: hr_utility.set_message_token('STEP','1');
702: hr_utility.raise_error;
703: end if;
704: --
705: else

Line 702: hr_utility.raise_error;

698: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
699: hr_utility.set_message_token('PROCEDURE',
700: 'pay_defined_balances_pkg.update_row');
701: hr_utility.set_message_token('STEP','1');
702: hr_utility.raise_error;
703: end if;
704: --
705: else
706: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

702: hr_utility.raise_error;
703: end if;
704: --
705: else
706: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
707: hr_utility.set_message_token('PROCEDURE',
708: 'pay_defined_balances_pkg.update_row');
709: hr_utility.set_message_token('STEP','1');
710: hr_utility.raise_error;

Line 707: hr_utility.set_message_token('PROCEDURE',

703: end if;
704: --
705: else
706: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
707: hr_utility.set_message_token('PROCEDURE',
708: 'pay_defined_balances_pkg.update_row');
709: hr_utility.set_message_token('STEP','1');
710: hr_utility.raise_error;
711: end if;

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

705: else
706: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
707: hr_utility.set_message_token('PROCEDURE',
708: 'pay_defined_balances_pkg.update_row');
709: hr_utility.set_message_token('STEP','1');
710: hr_utility.raise_error;
711: end if;
712: --
713: END Update_Row;

Line 710: hr_utility.raise_error;

706: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
707: hr_utility.set_message_token('PROCEDURE',
708: 'pay_defined_balances_pkg.update_row');
709: hr_utility.set_message_token('STEP','1');
710: hr_utility.raise_error;
711: end if;
712: --
713: END Update_Row;
714: --

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

739: DELETE FROM pay_defined_balances
740: WHERE rowid = X_Rowid;
741: --
742: if (SQL%NOTFOUND) then
743: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
744: hr_utility.set_message_token('PROCEDURE',
745: 'pay_defined_balances_pkg.delete_row');
746: hr_utility.set_message_token('STEP','1');
747: hr_utility.raise_error;

Line 744: hr_utility.set_message_token('PROCEDURE',

740: WHERE rowid = X_Rowid;
741: --
742: if (SQL%NOTFOUND) then
743: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
744: hr_utility.set_message_token('PROCEDURE',
745: 'pay_defined_balances_pkg.delete_row');
746: hr_utility.set_message_token('STEP','1');
747: hr_utility.raise_error;
748: end if;

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

742: if (SQL%NOTFOUND) then
743: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
744: hr_utility.set_message_token('PROCEDURE',
745: 'pay_defined_balances_pkg.delete_row');
746: hr_utility.set_message_token('STEP','1');
747: hr_utility.raise_error;
748: end if;
749: --
750: END Delete_Row;

Line 747: hr_utility.raise_error;

743: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
744: hr_utility.set_message_token('PROCEDURE',
745: 'pay_defined_balances_pkg.delete_row');
746: hr_utility.set_message_token('STEP','1');
747: hr_utility.raise_error;
748: end if;
749: --
750: END Delete_Row;
751: --

Line 781: hr_utility.set_location('Entering: pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 5);

777: l_exists number;
778: --
779: BEGIN
780: --
781: hr_utility.set_location('Entering: pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 5);
782: --
783: if p_old_save_run_bal_flag = 'Y' then
784: --
785: if p_new_save_run_bal_flag is null

Line 795: hr_utility.set_location('pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 10);

791: --
792: -- raise error
793: --
794: close check_runbals;
795: hr_utility.set_location('pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 10);
796: --
797: hr_utility.set_message(801, 'PAY_33528_SAVERUNBAL_INV_UPD');
798: hr_utility.raise_error;
799: --

Line 797: hr_utility.set_message(801, 'PAY_33528_SAVERUNBAL_INV_UPD');

793: --
794: close check_runbals;
795: hr_utility.set_location('pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 10);
796: --
797: hr_utility.set_message(801, 'PAY_33528_SAVERUNBAL_INV_UPD');
798: hr_utility.raise_error;
799: --
800: else
801: close check_runbals;

Line 798: hr_utility.raise_error;

794: close check_runbals;
795: hr_utility.set_location('pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 10);
796: --
797: hr_utility.set_message(801, 'PAY_33528_SAVERUNBAL_INV_UPD');
798: hr_utility.raise_error;
799: --
800: else
801: close check_runbals;
802: hr_utility.set_location('pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 20);

Line 802: hr_utility.set_location('pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 20);

798: hr_utility.raise_error;
799: --
800: else
801: close check_runbals;
802: hr_utility.set_location('pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 20);
803: end if;
804: end if;
805: end if;
806: hr_utility.set_location('Leaving: pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 30);

Line 806: hr_utility.set_location('Leaving: pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 30);

802: hr_utility.set_location('pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 20);
803: end if;
804: end if;
805: end if;
806: hr_utility.set_location('Leaving: pay_defined_balance_pkg.verify_save_run_bal_flag_upd', 30);
807: --
808: END verify_save_run_bal_flag_upd;
809: -----------------------------------------------------------------------------
810: END PAY_DEFINED_BALANCES_PKG;