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

Line 22: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_USED');

18: FROM cn_srp_role_dtls_v sr
19: WHERE sr.job_title_id = jr.job_title_id
20: AND jr.role_id = sr.role_id );
21:
22: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_USED');
23: FND_MSG_PUB.ADD;
24: RAISE FND_API.G_EXC_ERROR;
25: EXCEPTION
26: WHEN NO_DATA_FOUND THEN

Line 58: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_USED');

54: ;
55:
56: IF L_COUNT > 0 THEN
57: IF l_min_start_date < p_rec.start_date THEN
58: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_USED');
59: FND_MSG_PUB.ADD;
60: RAISE FND_API.G_EXC_ERROR;
61: END IF ;
62:

Line 66: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_USED');

62:
63: IF l_max_end_date IS NOT NULL THEN
64: IF NVL(p_rec.end_date, L_NULL_END_DATE) < l_max_end_date
65: THEN
66: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_USED');
67: FND_MSG_PUB.ADD;
68: RAISE FND_API.G_EXC_ERROR;
69: END IF ;
70: END IF ;

Line 127: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');

123:
124: -- checks validity of job_title_id, role_id, date range
125: if l_newrec.end_date is not null and
126: l_newrec.end_date < l_newrec.start_date then
127: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');
128: FND_MSG_PUB.ADD;
129: RAISE FND_API.G_EXC_ERROR;
130: end if;
131:

Line 145: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_OVERLAP');

141: (start_date >= l_newrec.start_date and
142: start_date <= nvl(l_newrec.end_date, l_null_date)));
143:
144: if l_count > 0 and l_newrec.default_flag = 'Y' then
145: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_OVERLAP');
146: FND_MSG_PUB.ADD;
147: RAISE FND_API.G_EXC_ERROR;
148: end if;
149:

Line 161: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_OVERLAP');

157: (start_date >= l_newrec.start_date and
158: start_date <= nvl(l_newrec.end_date, l_null_date)));
159:
160: if l_count > 0 then
161: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_OVERLAP');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: end if;
165:

Line 174: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_OVERLAP');

170: and trunc(start_date) = trunc(l_newrec.start_date)
171: ;
172:
173: if l_count > 0 then
174: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_OVERLAP');
175: FND_MSG_PUB.ADD;
176: RAISE FND_API.G_EXC_ERROR;
177: end if;
178:

Line 267: FND_MESSAGE.SET_NAME('PA', 'PA_START_DATE_INVALID');

263:
264:
265: -- checks validity of start_date
266: if l_newrec.start_date is null then
267: FND_MESSAGE.SET_NAME('PA', 'PA_START_DATE_INVALID');
268: FND_MSG_PUB.ADD;
269: RAISE FND_API.G_EXC_ERROR;
270: end if;
271:

Line 282: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_UPDATE_REC');

278: from cn_job_roles
279: where job_role_id = l_newrec.job_role_id;
280:
281: if l_count = 0 then
282: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_UPDATE_REC');
283: FND_MSG_PUB.ADD;
284: RAISE FND_API.G_EXC_ERROR;
285: end if;
286:

Line 290: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');

286:
287: -- checks validity of date range
288: if l_newrec.end_date is not null and
289: l_newrec.end_date < l_newrec.start_date then
290: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');
291: FND_MSG_PUB.ADD;
292: RAISE FND_API.G_EXC_ERROR;
293: end if;
294:

Line 318: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_OVERLAP');

314: nvl(end_date, l_null_date) >= l_newrec.start_date) OR
315: (start_date >= l_newrec.start_date and
316: start_date <= nvl(l_newrec.end_date, l_null_date)));
317: if l_count > 0 and l_newrec.default_flag = 'Y' then
318: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_OVERLAP');
319: FND_MSG_PUB.ADD;
320: RAISE FND_API.G_EXC_ERROR;
321: end if;
322:

Line 335: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_OVERLAP');

331: (start_date >= l_newrec.start_date and
332: start_date <= nvl(l_newrec.end_date, l_null_date)));
333:
334: if l_count > 0 then
335: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_OVERLAP');
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;
338: end if;
339:

Line 431: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_DEL_REC');

427: from cn_job_roles
428: where job_role_id = p_job_role_id;
429:
430: if l_count = 0 then
431: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_DEL_REC');
432: FND_MSG_PUB.ADD;
433: RAISE FND_API.G_EXC_ERROR;
434: end if;
435: