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

Line 36: fnd_message.set_name('PAY','HR_IE_ABSENCE_EXISTS');

32: open c_absence_dates;
33: fetch c_absence_dates into l_social_benefit_id;
34: if c_absence_dates%found then
35: close c_absence_dates;
36: fnd_message.set_name('PAY','HR_IE_ABSENCE_EXISTS');
37: fnd_message.raise_error;
38: end if;
39: if c_absence_dates%isopen then
40: close c_absence_dates;

Line 37: fnd_message.raise_error;

33: fetch c_absence_dates into l_social_benefit_id;
34: if c_absence_dates%found then
35: close c_absence_dates;
36: fnd_message.set_name('PAY','HR_IE_ABSENCE_EXISTS');
37: fnd_message.raise_error;
38: end if;
39: if c_absence_dates%isopen then
40: close c_absence_dates;
41: end if;

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

59: open c_calculation_option;
60: fetch c_calculation_option into l_calculation_option_count;
61: if nvl(l_calculation_option_count,0) = 0 then
62: close c_calculation_option;
63: fnd_message.set_name('PAY','HR_IE_NO_VALID_CALC_OPTION');
64: fnd_message.raise_error;
65: end if;
66: if c_calculation_option%isopen then
67: close c_calculation_option;

Line 64: fnd_message.raise_error;

60: fetch c_calculation_option into l_calculation_option_count;
61: if nvl(l_calculation_option_count,0) = 0 then
62: close c_calculation_option;
63: fnd_message.set_name('PAY','HR_IE_NO_VALID_CALC_OPTION');
64: fnd_message.raise_error;
65: end if;
66: if c_calculation_option%isopen then
67: close c_calculation_option;
68: end if;

Line 91: fnd_message.set_name('PAY','HR_IE_NO_VALID_BENEFIT_TYPE');

87: fetch c_benefit_type into l_benefit_type_count;
88: if p_benefit_type is not null then
89: if nvl(l_benefit_type_count,0) = 0 then
90: close c_benefit_type;
91: fnd_message.set_name('PAY','HR_IE_NO_VALID_BENEFIT_TYPE');
92: fnd_message.raise_error;
93: end if;
94: end if;
95: if c_benefit_type%isopen then

Line 92: fnd_message.raise_error;

88: if p_benefit_type is not null then
89: if nvl(l_benefit_type_count,0) = 0 then
90: close c_benefit_type;
91: fnd_message.set_name('PAY','HR_IE_NO_VALID_BENEFIT_TYPE');
92: fnd_message.raise_error;
93: end if;
94: end if;
95: if c_benefit_type%isopen then
96: close c_benefit_type;

Line 118: fnd_message.set_name('PAY','HR_IE_NO_VALID_INCIDENT_ID');

114: fetch c_incident_id into l_incident_id;
115: if p_incident_id is not null then
116: if c_incident_id%notfound then
117: close c_incident_id;
118: fnd_message.set_name('PAY','HR_IE_NO_VALID_INCIDENT_ID');
119: fnd_message.raise_error;
120: end if;
121: end if;
122: if c_incident_id%isopen then

Line 119: fnd_message.raise_error;

115: if p_incident_id is not null then
116: if c_incident_id%notfound then
117: close c_incident_id;
118: fnd_message.set_name('PAY','HR_IE_NO_VALID_INCIDENT_ID');
119: fnd_message.raise_error;
120: end if;
121: end if;
122: if c_incident_id%isopen then
123: close c_incident_id;

Line 148: fnd_message.set_name('PAY','HR_IE_PAYE_DETAILS_NULL');

144: open c_paye_details;
145: fetch c_paye_details into l_paye_details;
146: if c_paye_details%notfound then
147: close c_paye_details;
148: fnd_message.set_name('PAY','HR_IE_PAYE_DETAILS_NULL');
149: fnd_message.raise_error;
150: end if;
151: if c_paye_details%isopen then
152: close c_paye_details;

Line 149: fnd_message.raise_error;

145: fetch c_paye_details into l_paye_details;
146: if c_paye_details%notfound then
147: close c_paye_details;
148: fnd_message.set_name('PAY','HR_IE_PAYE_DETAILS_NULL');
149: fnd_message.raise_error;
150: end if;
151: if c_paye_details%isopen then
152: close c_paye_details;
153: end if;

Line 167: fnd_message.set_name('PAY','HR_IE_START_END_DATES');

163: procedure chk_valid_absence_dates( p_absence_start_date date,
164: p_absence_end_date date) is
165: begin
166: if p_absence_start_date > nvl(p_absence_end_date, p_absence_start_date+1) then
167: fnd_message.set_name('PAY','HR_IE_START_END_DATES');
168: fnd_message.set_token('START',TO_CHAR(p_absence_start_date),TRUE);
169: fnd_message.set_token('END',TO_CHAR(p_absence_end_date),TRUE);
170: fnd_message.raise_error;
171: END IF;

Line 168: fnd_message.set_token('START',TO_CHAR(p_absence_start_date),TRUE);

164: p_absence_end_date date) is
165: begin
166: if p_absence_start_date > nvl(p_absence_end_date, p_absence_start_date+1) then
167: fnd_message.set_name('PAY','HR_IE_START_END_DATES');
168: fnd_message.set_token('START',TO_CHAR(p_absence_start_date),TRUE);
169: fnd_message.set_token('END',TO_CHAR(p_absence_end_date),TRUE);
170: fnd_message.raise_error;
171: END IF;
172: end chk_valid_absence_dates;

Line 169: fnd_message.set_token('END',TO_CHAR(p_absence_end_date),TRUE);

165: begin
166: if p_absence_start_date > nvl(p_absence_end_date, p_absence_start_date+1) then
167: fnd_message.set_name('PAY','HR_IE_START_END_DATES');
168: fnd_message.set_token('START',TO_CHAR(p_absence_start_date),TRUE);
169: fnd_message.set_token('END',TO_CHAR(p_absence_end_date),TRUE);
170: fnd_message.raise_error;
171: END IF;
172: end chk_valid_absence_dates;
173: --

Line 170: fnd_message.raise_error;

166: if p_absence_start_date > nvl(p_absence_end_date, p_absence_start_date+1) then
167: fnd_message.set_name('PAY','HR_IE_START_END_DATES');
168: fnd_message.set_token('START',TO_CHAR(p_absence_start_date),TRUE);
169: fnd_message.set_token('END',TO_CHAR(p_absence_end_date),TRUE);
170: fnd_message.raise_error;
171: END IF;
172: end chk_valid_absence_dates;
173: --
174: -- ----------------------------------------------------------------------------

Line 180: fnd_message.set_name('PAY','HR_IE_CALC_OPTION_REQUIRED');

176: -- ----------------------------------------------------------------------------
177: procedure chk_calc_option_required(p_rec in pay_isb_shd.g_rec_type) is
178: begin
179: if nvl(p_rec.benefit_amount,0) > 0 and p_rec.calculation_option is null then
180: fnd_message.set_name('PAY','HR_IE_CALC_OPTION_REQUIRED');
181: fnd_message.raise_error;
182: end if;
183: end chk_calc_option_required;
184: --

Line 181: fnd_message.raise_error;

177: procedure chk_calc_option_required(p_rec in pay_isb_shd.g_rec_type) is
178: begin
179: if nvl(p_rec.benefit_amount,0) > 0 and p_rec.calculation_option is null then
180: fnd_message.set_name('PAY','HR_IE_CALC_OPTION_REQUIRED');
181: fnd_message.raise_error;
182: end if;
183: end chk_calc_option_required;
184: --
185: -- ----------------------------------------------------------------------------

Line 196: fnd_message.set_name('PAY','HR_IE_BENEFIT_TYPE_REQUIRED');

192: p_rec.calculation_option = 'IE_OPTION2' or
193: p_rec.calculation_option = 'IE_OPTION3' or
194: p_rec.calculation_option = 'IE_OPTION4')
195: and p_rec.benefit_type is null then
196: fnd_message.set_name('PAY','HR_IE_BENEFIT_TYPE_REQUIRED');
197: fnd_message.raise_error;
198: end if;
199: end;
200: --

Line 197: fnd_message.raise_error;

193: p_rec.calculation_option = 'IE_OPTION3' or
194: p_rec.calculation_option = 'IE_OPTION4')
195: and p_rec.benefit_type is null then
196: fnd_message.set_name('PAY','HR_IE_BENEFIT_TYPE_REQUIRED');
197: fnd_message.raise_error;
198: end if;
199: end;
200: --
201: -- ----------------------------------------------------------------------------

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

266: close csr_sec_grp;
267: --
268: -- The primary key is invalid therefore we must error
269: --
270: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
271: fnd_message.raise_error;
272: --
273: end if;
274: close csr_sec_grp;

Line 271: fnd_message.raise_error;

267: --
268: -- The primary key is invalid therefore we must error
269: --
270: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
271: fnd_message.raise_error;
272: --
273: end if;
274: close csr_sec_grp;
275: --

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

341: --
342: -- The primary key is invalid therefore we must error
343: --
344: close csr_leg_code;
345: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
346: fnd_message.raise_error;
347: end if;
348: hr_utility.set_location(l_proc,30);
349: --

Line 346: fnd_message.raise_error;

342: -- The primary key is invalid therefore we must error
343: --
344: close csr_leg_code;
345: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
346: fnd_message.raise_error;
347: end if;
348: hr_utility.set_location(l_proc,30);
349: --
350: -- Set the global variables so the values are

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

403: (p_social_benefit_id => p_rec.social_benefit_id
404: ,p_effective_date => p_effective_date
405: ,p_object_version_number => p_rec.object_version_number
406: ) THEN
407: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE ', l_proc);
409: fnd_message.set_token('STEP ', '5');
410: fnd_message.raise_error;
411: END IF;

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

404: ,p_effective_date => p_effective_date
405: ,p_object_version_number => p_rec.object_version_number
406: ) THEN
407: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE ', l_proc);
409: fnd_message.set_token('STEP ', '5');
410: fnd_message.raise_error;
411: END IF;
412: --

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

405: ,p_object_version_number => p_rec.object_version_number
406: ) THEN
407: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE ', l_proc);
409: fnd_message.set_token('STEP ', '5');
410: fnd_message.raise_error;
411: END IF;
412: --
413: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 410: fnd_message.raise_error;

406: ) THEN
407: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE ', l_proc);
409: fnd_message.set_token('STEP ', '5');
410: fnd_message.raise_error;
411: END IF;
412: --
413: -- EDIT_HERE: Add checks to ensure non-updateable args have
414: -- not been updated.

Line 508: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

504: --
505: -- A referential integrity check was violated therefore
506: -- we must error
507: --
508: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
509: fnd_message.set_token('TABLE_NAME', l_table_name);
510: fnd_message.raise_error;
511: When Others Then
512: --

Line 509: fnd_message.set_token('TABLE_NAME', l_table_name);

505: -- A referential integrity check was violated therefore
506: -- we must error
507: --
508: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
509: fnd_message.set_token('TABLE_NAME', l_table_name);
510: fnd_message.raise_error;
511: When Others Then
512: --
513: -- An unhandled or unexpected error has occurred which

Line 510: fnd_message.raise_error;

506: -- we must error
507: --
508: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
509: fnd_message.set_token('TABLE_NAME', l_table_name);
510: fnd_message.raise_error;
511: When Others Then
512: --
513: -- An unhandled or unexpected error has occurred which
514: -- we must report

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

512: --
513: -- An unhandled or unexpected error has occurred which
514: -- we must report
515: --
516: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
517: fnd_message.set_token('PROCEDURE', l_proc);
518: fnd_message.set_token('STEP','15');
519: fnd_message.raise_error;
520: End dt_update_validate;

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

513: -- An unhandled or unexpected error has occurred which
514: -- we must report
515: --
516: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
517: fnd_message.set_token('PROCEDURE', l_proc);
518: fnd_message.set_token('STEP','15');
519: fnd_message.raise_error;
520: End dt_update_validate;
521: --

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

514: -- we must report
515: --
516: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
517: fnd_message.set_token('PROCEDURE', l_proc);
518: fnd_message.set_token('STEP','15');
519: fnd_message.raise_error;
520: End dt_update_validate;
521: --
522: -- ----------------------------------------------------------------------------

Line 519: fnd_message.raise_error;

515: --
516: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
517: fnd_message.set_token('PROCEDURE', l_proc);
518: fnd_message.set_token('STEP','15');
519: fnd_message.raise_error;
520: End dt_update_validate;
521: --
522: -- ----------------------------------------------------------------------------
523: -- |--------------------------< dt_delete_validate >--------------------------|

Line 615: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

611: --
612: -- A referential integrity check was violated therefore
613: -- we must error
614: --
615: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
616: fnd_message.set_token('TABLE_NAME', l_table_name);
617: fnd_message.raise_error;
618: When Others Then
619: --

Line 616: fnd_message.set_token('TABLE_NAME', l_table_name);

612: -- A referential integrity check was violated therefore
613: -- we must error
614: --
615: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
616: fnd_message.set_token('TABLE_NAME', l_table_name);
617: fnd_message.raise_error;
618: When Others Then
619: --
620: -- An unhandled or unexpected error has occurred which

Line 617: fnd_message.raise_error;

613: -- we must error
614: --
615: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
616: fnd_message.set_token('TABLE_NAME', l_table_name);
617: fnd_message.raise_error;
618: When Others Then
619: --
620: -- An unhandled or unexpected error has occurred which
621: -- we must report

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

619: --
620: -- An unhandled or unexpected error has occurred which
621: -- we must report
622: --
623: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
624: fnd_message.set_token('PROCEDURE', l_proc);
625: fnd_message.set_token('STEP','15');
626: fnd_message.raise_error;
627: --

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

620: -- An unhandled or unexpected error has occurred which
621: -- we must report
622: --
623: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
624: fnd_message.set_token('PROCEDURE', l_proc);
625: fnd_message.set_token('STEP','15');
626: fnd_message.raise_error;
627: --
628: End dt_delete_validate;

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

621: -- we must report
622: --
623: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
624: fnd_message.set_token('PROCEDURE', l_proc);
625: fnd_message.set_token('STEP','15');
626: fnd_message.raise_error;
627: --
628: End dt_delete_validate;
629: --

Line 626: fnd_message.raise_error;

622: --
623: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
624: fnd_message.set_token('PROCEDURE', l_proc);
625: fnd_message.set_token('STEP','15');
626: fnd_message.raise_error;
627: --
628: End dt_delete_validate;
629: --
630: -- ----------------------------------------------------------------------------