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

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

65: close csr_sec_grp;
66: --
67: -- The primary key is invalid therefore we must error
68: --
69: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
70: hr_multi_message.add
71: (p_associated_column1
72: => nvl(p_associated_column1,'SALARY_CAP_OVERRIDE_ID')
73: );

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

152: --
153: -- The primary key is invalid therefore we must error
154: --
155: close csr_leg_code;
156: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
157: fnd_message.raise_error;
158: end if;
159: hr_utility.set_location(l_proc,30);
160: --

Line 157: fnd_message.raise_error;

153: -- The primary key is invalid therefore we must error
154: --
155: close csr_leg_code;
156: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
157: fnd_message.raise_error;
158: end if;
159: hr_utility.set_location(l_proc,30);
160: --
161: -- Set the global variables so the values are

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

210: IF NOT psp_pso_shd.api_updating
211: (p_salary_cap_override_id => p_rec.salary_cap_override_id
212: ,p_object_version_number => p_rec.object_version_number
213: ) THEN
214: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
215: fnd_message.set_token('PROCEDURE ', l_proc);
216: fnd_message.set_token('STEP ', '5');
217: fnd_message.raise_error;
218: END IF;

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

211: (p_salary_cap_override_id => p_rec.salary_cap_override_id
212: ,p_object_version_number => p_rec.object_version_number
213: ) THEN
214: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
215: fnd_message.set_token('PROCEDURE ', l_proc);
216: fnd_message.set_token('STEP ', '5');
217: fnd_message.raise_error;
218: END IF;
219: --

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

212: ,p_object_version_number => p_rec.object_version_number
213: ) THEN
214: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
215: fnd_message.set_token('PROCEDURE ', l_proc);
216: fnd_message.set_token('STEP ', '5');
217: fnd_message.raise_error;
218: END IF;
219: --
220: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 217: fnd_message.raise_error;

213: ) THEN
214: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
215: fnd_message.set_token('PROCEDURE ', l_proc);
216: fnd_message.set_token('STEP ', '5');
217: fnd_message.raise_error;
218: END IF;
219: --
220: -- EDIT_HERE: Add checks to ensure non-updateable args have
221: -- not been updated.

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

267: l_end_flag BOOLEAN := false;
268:
269: BEGIN
270: IF p_end_date < p_start_date THEN
271: fnd_message.set_name ('PSP', 'PSP_ED_GREATERTHAN_BD');
272: fnd_message.raise_error;
273: END IF;
274:
275: OPEN salary_cap_date_selection_csr;

Line 272: fnd_message.raise_error;

268:
269: BEGIN
270: IF p_end_date < p_start_date THEN
271: fnd_message.set_name ('PSP', 'PSP_ED_GREATERTHAN_BD');
272: fnd_message.raise_error;
273: END IF;
274:
275: OPEN salary_cap_date_selection_csr;
276: LOOP

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

284: END IF;
285: END LOOP;
286:
287: IF (l_start_flag = false) OR (l_end_flag = FALSE) THEN
288: fnd_message.set_name ('PSP', 'PSP_SC_NOT_DEFINED');
289: fnd_message.raise_error;
290: END IF;
291:
292: OPEN date_selection_csr;

Line 289: fnd_message.raise_error;

285: END LOOP;
286:
287: IF (l_start_flag = false) OR (l_end_flag = FALSE) THEN
288: fnd_message.set_name ('PSP', 'PSP_SC_NOT_DEFINED');
289: fnd_message.raise_error;
290: END IF;
291:
292: OPEN date_selection_csr;
293: LOOP

Line 301: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_PRJ');

297: OPEN project_number_csr;
298: FETCH project_number_csr INTO l_project_number;
299: CLOSE project_number_csr;
300:
301: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_PRJ');
302: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
303: fnd_message.set_token('END_DATE', l_end_date);
304: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
305: fnd_message.raise_error;

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

298: FETCH project_number_csr INTO l_project_number;
299: CLOSE project_number_csr;
300:
301: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_PRJ');
302: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
303: fnd_message.set_token('END_DATE', l_end_date);
304: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
305: fnd_message.raise_error;
306: END IF;

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

299: CLOSE project_number_csr;
300:
301: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_PRJ');
302: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
303: fnd_message.set_token('END_DATE', l_end_date);
304: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
305: fnd_message.raise_error;
306: END IF;
307: END LOOP;

Line 304: fnd_message.set_token('PROJECT_NUMBER', l_project_number);

300:
301: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_PRJ');
302: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
303: fnd_message.set_token('END_DATE', l_end_date);
304: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
305: fnd_message.raise_error;
306: END IF;
307: END LOOP;
308: CLOSE date_selection_csr;

Line 305: fnd_message.raise_error;

301: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_PRJ');
302: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
303: fnd_message.set_token('END_DATE', l_end_date);
304: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
305: fnd_message.raise_error;
306: END IF;
307: END LOOP;
308: CLOSE date_selection_csr;
309:

Line 320: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');

316: OPEN project_number_csr;
317: FETCH project_number_csr INTO l_project_number;
318: CLOSE project_number_csr;
319:
320: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');
321: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date ));
322: fnd_message.set_token('END_DATE', l_end_date);
323: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
324: fnd_message.raise_error;

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

317: FETCH project_number_csr INTO l_project_number;
318: CLOSE project_number_csr;
319:
320: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');
321: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date ));
322: fnd_message.set_token('END_DATE', l_end_date);
323: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
324: fnd_message.raise_error;
325: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN

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

318: CLOSE project_number_csr;
319:
320: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');
321: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date ));
322: fnd_message.set_token('END_DATE', l_end_date);
323: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
324: fnd_message.raise_error;
325: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN
326: OPEN project_number_csr;

Line 323: fnd_message.set_token('PROJECT_NUMBER', l_project_number);

319:
320: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');
321: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date ));
322: fnd_message.set_token('END_DATE', l_end_date);
323: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
324: fnd_message.raise_error;
325: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN
326: OPEN project_number_csr;
327: FETCH project_number_csr INTO l_project_number;

Line 324: fnd_message.raise_error;

320: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');
321: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date ));
322: fnd_message.set_token('END_DATE', l_end_date);
323: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
324: fnd_message.raise_error;
325: ELSIF p_start_date < l_start_date AND p_end_date > l_end_date THEN
326: OPEN project_number_csr;
327: FETCH project_number_csr INTO l_project_number;
328: CLOSE project_number_csr;

Line 330: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');

326: OPEN project_number_csr;
327: FETCH project_number_csr INTO l_project_number;
328: CLOSE project_number_csr;
329:
330: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');
331: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
332: fnd_message.set_token('END_DATE', l_end_date);
333: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
334: fnd_message.raise_error;

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

327: FETCH project_number_csr INTO l_project_number;
328: CLOSE project_number_csr;
329:
330: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');
331: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
332: fnd_message.set_token('END_DATE', l_end_date);
333: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
334: fnd_message.raise_error;
335: END IF;

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

328: CLOSE project_number_csr;
329:
330: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');
331: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
332: fnd_message.set_token('END_DATE', l_end_date);
333: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
334: fnd_message.raise_error;
335: END IF;
336: END LOOP;

Line 333: fnd_message.set_token('PROJECT_NUMBER', l_project_number);

329:
330: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');
331: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
332: fnd_message.set_token('END_DATE', l_end_date);
333: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
334: fnd_message.raise_error;
335: END IF;
336: END LOOP;
337: CLOSE date_selection_csr;

Line 334: fnd_message.raise_error;

330: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_PRJ');
331: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date));
332: fnd_message.set_token('END_DATE', l_end_date);
333: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
334: fnd_message.raise_error;
335: END IF;
336: END LOOP;
337: CLOSE date_selection_csr;
338: END validate_dates;