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.PSP_PSC_BUS dependencies on FND_MESSAGE

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

69: close csr_sec_grp;
70: --
71: -- The primary key is invalid therefore we must error
72: --
73: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
74: hr_multi_message.add
75: (p_associated_column1
76: => nvl(p_associated_column1,'SALARY_CAP_ID')
77: );

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

159: --
160: -- The primary key is invalid therefore we must error
161: --
162: close csr_leg_code;
163: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
164: fnd_message.raise_error;
165: end if;
166: hr_utility.set_location(l_proc,30);
167: --

Line 164: fnd_message.raise_error;

160: -- The primary key is invalid therefore we must error
161: --
162: close csr_leg_code;
163: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
164: fnd_message.raise_error;
165: end if;
166: hr_utility.set_location(l_proc,30);
167: --
168: -- Set the global variables so the values are

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

218: IF NOT psp_psc_shd.api_updating
219: (p_salary_cap_id => p_rec.salary_cap_id
220: ,p_object_version_number => p_rec.object_version_number
221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;

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

219: (p_salary_cap_id => p_rec.salary_cap_id
220: ,p_object_version_number => p_rec.object_version_number
221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;
227: --

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

220: ,p_object_version_number => p_rec.object_version_number
221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;
227: --
228: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 225: fnd_message.raise_error;

221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;
227: --
228: -- EDIT_HERE: Add checks to ensure non-updateable args have
229: -- not been updated.

Line 265: fnd_message.set_name ('PSP', 'PSP_ED_GREATERTHAN_BD');

261: l_start_date DATE;
262: l_end_date DATE;
263: BEGIN
264: IF p_end_date < p_start_date THEN
265: fnd_message.set_name ('PSP', 'PSP_ED_GREATERTHAN_BD');
266: fnd_message.raise_error;
267: END IF;
268:
269: OPEN date_selection_csr;

Line 266: fnd_message.raise_error;

262: l_end_date DATE;
263: BEGIN
264: IF p_end_date < p_start_date THEN
265: fnd_message.set_name ('PSP', 'PSP_ED_GREATERTHAN_BD');
266: fnd_message.raise_error;
267: END IF;
268:
269: OPEN date_selection_csr;
270: LOOP

Line 274: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_SPONS');

270: LOOP
271: fetch date_selection_csr INTO l_start_date, l_end_date;
272: EXIT WHEN date_selection_csr%NOTFOUND;
273: IF p_start_date BETWEEN l_start_date AND l_end_date THEN
274: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_SPONS');
275: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
276: fnd_message.set_token('END_DATE', l_end_date);
277: fnd_message.raise_error;
278: END IF;

Line 275: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));

271: fetch date_selection_csr INTO l_start_date, l_end_date;
272: EXIT WHEN date_selection_csr%NOTFOUND;
273: IF p_start_date BETWEEN l_start_date AND l_end_date THEN
274: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_SPONS');
275: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
276: fnd_message.set_token('END_DATE', l_end_date);
277: fnd_message.raise_error;
278: END IF;
279: END LOOP;

Line 276: fnd_message.set_token('END_DATE', l_end_date);

272: EXIT WHEN date_selection_csr%NOTFOUND;
273: IF p_start_date BETWEEN l_start_date AND l_end_date THEN
274: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_SPONS');
275: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
276: fnd_message.set_token('END_DATE', l_end_date);
277: fnd_message.raise_error;
278: END IF;
279: END LOOP;
280: CLOSE date_selection_csr;

Line 277: fnd_message.raise_error;

273: IF p_start_date BETWEEN l_start_date AND l_end_date THEN
274: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_SPONS');
275: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
276: fnd_message.set_token('END_DATE', l_end_date);
277: fnd_message.raise_error;
278: END IF;
279: END LOOP;
280: CLOSE date_selection_csr;
281:

Line 288: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');

284: LOOP
285: fetch date_selection_csr INTO l_start_date , l_end_date ;
286: EXIT WHEN date_selection_csr%NOTFOUND ;
287: IF p_end_date BETWEEN l_start_date AND l_end_date THEN
288: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');
289: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date ));
290: fnd_message.set_token('END_DATE', l_end_date);
291: fnd_message.raise_error;
292: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN

Line 289: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date ));

285: fetch date_selection_csr INTO l_start_date , l_end_date ;
286: EXIT WHEN date_selection_csr%NOTFOUND ;
287: IF p_end_date BETWEEN l_start_date AND l_end_date THEN
288: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');
289: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date ));
290: fnd_message.set_token('END_DATE', l_end_date);
291: fnd_message.raise_error;
292: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN
293: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');

Line 290: fnd_message.set_token('END_DATE', l_end_date);

286: EXIT WHEN date_selection_csr%NOTFOUND ;
287: IF p_end_date BETWEEN l_start_date AND l_end_date THEN
288: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');
289: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date ));
290: fnd_message.set_token('END_DATE', l_end_date);
291: fnd_message.raise_error;
292: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN
293: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');
294: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));

Line 291: fnd_message.raise_error;

287: IF p_end_date BETWEEN l_start_date AND l_end_date THEN
288: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');
289: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date ));
290: fnd_message.set_token('END_DATE', l_end_date);
291: fnd_message.raise_error;
292: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN
293: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');
294: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
295: fnd_message.set_token('END_DATE', l_end_date);

Line 293: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');

289: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date ));
290: fnd_message.set_token('END_DATE', l_end_date);
291: fnd_message.raise_error;
292: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN
293: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');
294: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
295: fnd_message.set_token('END_DATE', l_end_date);
296: fnd_message.raise_error;
297: END IF;

Line 294: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));

290: fnd_message.set_token('END_DATE', l_end_date);
291: fnd_message.raise_error;
292: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN
293: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');
294: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
295: fnd_message.set_token('END_DATE', l_end_date);
296: fnd_message.raise_error;
297: END IF;
298: END LOOP;

Line 295: fnd_message.set_token('END_DATE', l_end_date);

291: fnd_message.raise_error;
292: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN
293: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');
294: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
295: fnd_message.set_token('END_DATE', l_end_date);
296: fnd_message.raise_error;
297: END IF;
298: END LOOP;
299: CLOSE date_selection_csr;

Line 296: fnd_message.raise_error;

292: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN
293: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_SPONS');
294: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
295: fnd_message.set_token('END_DATE', l_end_date);
296: fnd_message.raise_error;
297: END IF;
298: END LOOP;
299: CLOSE date_selection_csr;
300: END validate_dates;