DBA Data[Home] [Help]

APPS.PAY_MAINTAIN_BANK_ACCT dependencies on FND_MESSAGE

Line 101: fnd_message.set_name('PAY', 'PAY_34070_PAY_CE_MAP_ERR');

97: close csr_chk_payroll_bank_acct;
98: -- Raising error, if the requested updation is going to break the one-to-one relationship
99: if (nvl(l_payroll_bank_account_id, -1) <> p_external_account_id) THEN
100: hr_utility.set_location(l_proc||'Raising an error ....',60);
101: fnd_message.set_name('PAY', 'PAY_34070_PAY_CE_MAP_ERR');
102: fnd_message.raise_error;
103: end if;
104: END if;
105: ELSE

Line 102: fnd_message.raise_error;

98: -- Raising error, if the requested updation is going to break the one-to-one relationship
99: if (nvl(l_payroll_bank_account_id, -1) <> p_external_account_id) THEN
100: hr_utility.set_location(l_proc||'Raising an error ....',60);
101: fnd_message.set_name('PAY', 'PAY_34070_PAY_CE_MAP_ERR');
102: fnd_message.raise_error;
103: end if;
104: END if;
105: ELSE
106: OPEN csr_chk_pre_payments_exists;

Line 113: fnd_message.set_name('PAY', 'HR_6226_PAYM_PPS_EXIST');

109: update ce_bank_acct_uses_all
110: set payroll_bank_account_id = null
111: where payroll_bank_account_id = p_external_account_id;
112: ELSE
113: fnd_message.set_name('PAY', 'HR_6226_PAYM_PPS_EXIST');
114: fnd_message.raise_error;
115: END IF;
116: CLOSE csr_chk_pre_payments_exists;
117: end if;

Line 114: fnd_message.raise_error;

110: set payroll_bank_account_id = null
111: where payroll_bank_account_id = p_external_account_id;
112: ELSE
113: fnd_message.set_name('PAY', 'HR_6226_PAYM_PPS_EXIST');
114: fnd_message.raise_error;
115: END IF;
116: CLOSE csr_chk_pre_payments_exists;
117: end if;
118: