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_PPR_BUS dependencies on FND_MESSAGE

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

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

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

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

Line 145: fnd_message.raise_error;

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

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

203: (p_status_processing_rule_id => p_rec.status_processing_rule_id
204: ,p_effective_date => p_effective_date
205: ,p_object_version_number => p_rec.object_version_number
206: ) THEN
207: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
208: fnd_message.set_token('PROCEDURE ', l_proc);
209: fnd_message.set_token('STEP ', '5');
210: fnd_message.raise_error;
211: END IF;

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

204: ,p_effective_date => p_effective_date
205: ,p_object_version_number => p_rec.object_version_number
206: ) THEN
207: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
208: fnd_message.set_token('PROCEDURE ', l_proc);
209: fnd_message.set_token('STEP ', '5');
210: fnd_message.raise_error;
211: END IF;
212: --

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

205: ,p_object_version_number => p_rec.object_version_number
206: ) THEN
207: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
208: fnd_message.set_token('PROCEDURE ', l_proc);
209: fnd_message.set_token('STEP ', '5');
210: fnd_message.raise_error;
211: END IF;
212: --
213: hr_utility.set_location('Entering:'||l_proc, 10);

Line 210: fnd_message.raise_error;

206: ) THEN
207: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
208: fnd_message.set_token('PROCEDURE ', l_proc);
209: fnd_message.set_token('STEP ', '5');
210: fnd_message.raise_error;
211: END IF;
212: --
213: hr_utility.set_location('Entering:'||l_proc, 10);
214: --

Line 356: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

352: --
353: -- An unhandled or unexpected error has occurred which
354: -- we must report
355: --
356: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
357: fnd_message.set_token('PROCEDURE', l_proc);
358: fnd_message.set_token('STEP','15');
359: fnd_message.raise_error;
360: End dt_update_validate;

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

353: -- An unhandled or unexpected error has occurred which
354: -- we must report
355: --
356: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
357: fnd_message.set_token('PROCEDURE', l_proc);
358: fnd_message.set_token('STEP','15');
359: fnd_message.raise_error;
360: End dt_update_validate;
361: --

Line 358: fnd_message.set_token('STEP','15');

354: -- we must report
355: --
356: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
357: fnd_message.set_token('PROCEDURE', l_proc);
358: fnd_message.set_token('STEP','15');
359: fnd_message.raise_error;
360: End dt_update_validate;
361: --
362: -- ----------------------------------------------------------------------------

Line 359: fnd_message.raise_error;

355: --
356: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
357: fnd_message.set_token('PROCEDURE', l_proc);
358: fnd_message.set_token('STEP','15');
359: fnd_message.raise_error;
360: End dt_update_validate;
361: --
362: -- ----------------------------------------------------------------------------
363: -- |--------------------------< dt_delete_validate >--------------------------|

Line 453: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

449: --
450: -- An unhandled or unexpected error has occurred which
451: -- we must report
452: --
453: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
454: fnd_message.set_token('PROCEDURE', l_proc);
455: fnd_message.set_token('STEP','15');
456: fnd_message.raise_error;
457: --

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

450: -- An unhandled or unexpected error has occurred which
451: -- we must report
452: --
453: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
454: fnd_message.set_token('PROCEDURE', l_proc);
455: fnd_message.set_token('STEP','15');
456: fnd_message.raise_error;
457: --
458: End dt_delete_validate;

Line 455: fnd_message.set_token('STEP','15');

451: -- we must report
452: --
453: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
454: fnd_message.set_token('PROCEDURE', l_proc);
455: fnd_message.set_token('STEP','15');
456: fnd_message.raise_error;
457: --
458: End dt_delete_validate;
459:

Line 456: fnd_message.raise_error;

452: --
453: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
454: fnd_message.set_token('PROCEDURE', l_proc);
455: fnd_message.set_token('STEP','15');
456: fnd_message.raise_error;
457: --
458: End dt_delete_validate;
459:
460: --

Line 504: fnd_message.raise_error;

500: If c_chk_assign_status_type%notfound Then
501: --
502: Close c_chk_assign_status_type;
503: pay_ppr_shd.constraint_error('PAY_STATUS_PROCESSING_RULE_FK2');
504: fnd_message.raise_error;
505: --
506: End If;
507: Close c_chk_assign_status_type;
508: End If;

Line 586: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

582: Fetch c_chk_formula_id into l_formula_type, p_processing_rule;
583: If c_chk_formula_id%notfound Then
584: --
585: Close c_chk_formula_id;
586: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
587: fnd_message.set_token('COLUMN_NAME', 'FORMULA_ID');
588: fnd_message.raise_error;
589: --
590: elsif NOT ((upper(l_formula_type) = 'ORACLE PAYROLL'

Line 587: fnd_message.set_token('COLUMN_NAME', 'FORMULA_ID');

583: If c_chk_formula_id%notfound Then
584: --
585: Close c_chk_formula_id;
586: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
587: fnd_message.set_token('COLUMN_NAME', 'FORMULA_ID');
588: fnd_message.raise_error;
589: --
590: elsif NOT ((upper(l_formula_type) = 'ORACLE PAYROLL'
591: or

Line 588: fnd_message.raise_error;

584: --
585: Close c_chk_formula_id;
586: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
587: fnd_message.set_token('COLUMN_NAME', 'FORMULA_ID');
588: fnd_message.raise_error;
589: --
590: elsif NOT ((upper(l_formula_type) = 'ORACLE PAYROLL'
591: or
592: upper(l_formula_type)='BALANCE ADJUSTMENT')) then

Line 595: fnd_message.set_name('PAY','PAY_33196_SPR_INVALID_FOR_TYPE');

591: or
592: upper(l_formula_type)='BALANCE ADJUSTMENT')) then
593: --
594: Close c_chk_formula_id;
595: fnd_message.set_name('PAY','PAY_33196_SPR_INVALID_FOR_TYPE');
596: fnd_message.set_token('FORMULA','FORMULA_NAME');
597: fnd_message.raise_error;
598: --
599: elsif (p_assignment_status_type_id is not null

Line 596: fnd_message.set_token('FORMULA','FORMULA_NAME');

592: upper(l_formula_type)='BALANCE ADJUSTMENT')) then
593: --
594: Close c_chk_formula_id;
595: fnd_message.set_name('PAY','PAY_33196_SPR_INVALID_FOR_TYPE');
596: fnd_message.set_token('FORMULA','FORMULA_NAME');
597: fnd_message.raise_error;
598: --
599: elsif (p_assignment_status_type_id is not null
600: and NVL(UPPER(l_formula_type),'-1') <> 'ORACLE PAYROLL') then

Line 597: fnd_message.raise_error;

593: --
594: Close c_chk_formula_id;
595: fnd_message.set_name('PAY','PAY_33196_SPR_INVALID_FOR_TYPE');
596: fnd_message.set_token('FORMULA','FORMULA_NAME');
597: fnd_message.raise_error;
598: --
599: elsif (p_assignment_status_type_id is not null
600: and NVL(UPPER(l_formula_type),'-1') <> 'ORACLE PAYROLL') then
601: open c_assignment_status;

Line 607: fnd_message.set_name('PAY', 'PAY_33197_SPR_INVALID_ASSIGN');

603: close c_assignment_status;
604:
605: Close c_chk_formula_id;
606:
607: fnd_message.set_name('PAY', 'PAY_33197_SPR_INVALID_ASSIGN');
608: fnd_message.set_token('ASSIGNMENT_STATUS', l_assignment_status);
609: fnd_message.set_token('FORMULA_TYPE', 'Oracle Payroll');
610: fnd_message.raise_error;
611: end if;

Line 608: fnd_message.set_token('ASSIGNMENT_STATUS', l_assignment_status);

604:
605: Close c_chk_formula_id;
606:
607: fnd_message.set_name('PAY', 'PAY_33197_SPR_INVALID_ASSIGN');
608: fnd_message.set_token('ASSIGNMENT_STATUS', l_assignment_status);
609: fnd_message.set_token('FORMULA_TYPE', 'Oracle Payroll');
610: fnd_message.raise_error;
611: end if;
612: Close c_chk_formula_id;

Line 609: fnd_message.set_token('FORMULA_TYPE', 'Oracle Payroll');

605: Close c_chk_formula_id;
606:
607: fnd_message.set_name('PAY', 'PAY_33197_SPR_INVALID_ASSIGN');
608: fnd_message.set_token('ASSIGNMENT_STATUS', l_assignment_status);
609: fnd_message.set_token('FORMULA_TYPE', 'Oracle Payroll');
610: fnd_message.raise_error;
611: end if;
612: Close c_chk_formula_id;
613:

Line 610: fnd_message.raise_error;

606:
607: fnd_message.set_name('PAY', 'PAY_33197_SPR_INVALID_ASSIGN');
608: fnd_message.set_token('ASSIGNMENT_STATUS', l_assignment_status);
609: fnd_message.set_token('FORMULA_TYPE', 'Oracle Payroll');
610: fnd_message.raise_error;
611: end if;
612: Close c_chk_formula_id;
613:
614:

Line 626: fnd_message.set_name('PAY','HR_7135_SPR_FORMULA_NO_UPDATE');

622: --
623: if (p_formula_id <> nvl(pay_ppr_shd.g_old_rec.formula_id,p_formula_id)) and
624: (pay_status_rules_pkg.result_rules_exist(p_status_processing_rule_id,
625: p_start_date, p_end_date)) then
626: fnd_message.set_name('PAY','HR_7135_SPR_FORMULA_NO_UPDATE');
627: fnd_message.raise_error;
628: end if;
629: --
630: hr_utility.set_location('Entering:'||l_proc, 15);

Line 627: fnd_message.raise_error;

623: if (p_formula_id <> nvl(pay_ppr_shd.g_old_rec.formula_id,p_formula_id)) and
624: (pay_status_rules_pkg.result_rules_exist(p_status_processing_rule_id,
625: p_start_date, p_end_date)) then
626: fnd_message.set_name('PAY','HR_7135_SPR_FORMULA_NO_UPDATE');
627: fnd_message.raise_error;
628: end if;
629: --
630: hr_utility.set_location('Entering:'||l_proc, 15);
631: --

Line 706: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

702: open c_chk_element_type;
703: fetch c_chk_element_type into l_exists;
704: if c_chk_element_type%notfound then
705: close c_chk_element_type;
706: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
707: fnd_message.set_token('COLUMN_NAME', 'ELEMENT_TYPE_ID');
708: fnd_message.raise_error;
709: end if;
710: close c_chk_element_type;

Line 707: fnd_message.set_token('COLUMN_NAME', 'ELEMENT_TYPE_ID');

703: fetch c_chk_element_type into l_exists;
704: if c_chk_element_type%notfound then
705: close c_chk_element_type;
706: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
707: fnd_message.set_token('COLUMN_NAME', 'ELEMENT_TYPE_ID');
708: fnd_message.raise_error;
709: end if;
710: close c_chk_element_type;
711: --

Line 708: fnd_message.raise_error;

704: if c_chk_element_type%notfound then
705: close c_chk_element_type;
706: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
707: fnd_message.set_token('COLUMN_NAME', 'ELEMENT_TYPE_ID');
708: fnd_message.raise_error;
709: end if;
710: close c_chk_element_type;
711: --
712: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 747: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

743: Fetch c_chk_leg_code into l_exists;
744: If c_chk_leg_code%notfound Then
745: --
746: Close c_chk_leg_code;
747: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
748: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
749: fnd_message.set_token('TABLE','FND_TERRITORIES');
750: fnd_message.raise_error;
751: --

Line 748: fnd_message.set_token('COLUMN','LEGISLATION_CODE');

744: If c_chk_leg_code%notfound Then
745: --
746: Close c_chk_leg_code;
747: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
748: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
749: fnd_message.set_token('TABLE','FND_TERRITORIES');
750: fnd_message.raise_error;
751: --
752: End If;

Line 749: fnd_message.set_token('TABLE','FND_TERRITORIES');

745: --
746: Close c_chk_leg_code;
747: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
748: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
749: fnd_message.set_token('TABLE','FND_TERRITORIES');
750: fnd_message.raise_error;
751: --
752: End If;
753: Close c_chk_leg_code;

Line 750: fnd_message.raise_error;

746: Close c_chk_leg_code;
747: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
748: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
749: fnd_message.set_token('TABLE','FND_TERRITORIES');
750: fnd_message.raise_error;
751: --
752: End If;
753: Close c_chk_leg_code;
754:

Line 802: fnd_message.set_name('PAY', 'PAY_33195_SPR_NOT_UNIQUE');

798: fetch c_duplicate_rule into l_exists;
799: if c_duplicate_rule%found then
800: --
801: close c_duplicate_rule;
802: fnd_message.set_name('PAY', 'PAY_33195_SPR_NOT_UNIQUE');
803: fnd_message.raise_error;
804: --
805: End If;
806: --

Line 803: fnd_message.raise_error;

799: if c_duplicate_rule%found then
800: --
801: close c_duplicate_rule;
802: fnd_message.set_name('PAY', 'PAY_33195_SPR_NOT_UNIQUE');
803: fnd_message.raise_error;
804: --
805: End If;
806: --
807: close c_duplicate_rule;