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_MSG_PUB

Line 23: FND_MSG_PUB.ADD;

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
27: NULL ;

Line 59: FND_MSG_PUB.ADD;

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:
63: IF l_max_end_date IS NOT NULL THEN

Line 67: FND_MSG_PUB.ADD;

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 ;
71: END IF;

Line 115: FND_MSG_PUB.initialize;

111: END IF;
112:
113: -- Initialize message list if p_init_msg_list is set to TRUE.
114: IF FND_API.to_Boolean( p_init_msg_list ) THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:
118: -- Initialize API return status to success
119: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 128: FND_MSG_PUB.ADD;

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:
132:

Line 146: FND_MSG_PUB.ADD;

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:
150: select count(job_role_id) into l_count

Line 162: FND_MSG_PUB.ADD;

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:
166: select count(1) into l_count

Line 175: FND_MSG_PUB.ADD;

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:
179: cn_job_title_pkg.insert_row(l_newrec);

Line 186: FND_MSG_PUB.Count_And_Get

182: IF FND_API.To_Boolean( p_commit ) THEN
183: COMMIT WORK;
184: END IF;
185:
186: FND_MSG_PUB.Count_And_Get
187: (p_count => x_msg_count,
188: p_data => x_msg_data,
189: p_encoded => FND_API.G_FALSE);
190:

Line 195: FND_MSG_PUB.Count_And_Get

191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: ROLLBACK TO Create_Job_Role;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: FND_MSG_PUB.Count_And_Get
196: (p_count => x_msg_count,
197: p_data => x_msg_data,
198: p_encoded => FND_API.G_FALSE);
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 202: FND_MSG_PUB.Count_And_Get

198: p_encoded => FND_API.G_FALSE);
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: ROLLBACK TO Create_Job_Role;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: FND_MSG_PUB.Count_And_Get
203: (p_count => x_msg_count,
204: p_data => x_msg_data,
205: p_encoded => FND_API.G_FALSE);
206: WHEN OTHERS THEN

Line 209: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

205: p_encoded => FND_API.G_FALSE);
206: WHEN OTHERS THEN
207: ROLLBACK TO Create_Job_Role;
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
210: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
211: END IF;
212: FND_MSG_PUB.Count_And_Get
213: (p_count => x_msg_count,

Line 210: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

206: WHEN OTHERS THEN
207: ROLLBACK TO Create_Job_Role;
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
210: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
211: END IF;
212: FND_MSG_PUB.Count_And_Get
213: (p_count => x_msg_count,
214: p_data => x_msg_data,

Line 212: FND_MSG_PUB.Count_And_Get

208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
210: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
211: END IF;
212: FND_MSG_PUB.Count_And_Get
213: (p_count => x_msg_count,
214: p_data => x_msg_data,
215: p_encoded => FND_API.G_FALSE);
216: END Create_Job_Role;

Line 258: FND_MSG_PUB.initialize;

254: END IF;
255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: IF FND_API.to_Boolean( p_init_msg_list ) THEN
258: FND_MSG_PUB.initialize;
259: END IF;
260:
261: -- Initialize API return status to success
262: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 268: FND_MSG_PUB.ADD;

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:
272:

Line 283: FND_MSG_PUB.ADD;

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:
287: -- checks validity of date range

Line 291: FND_MSG_PUB.ADD;

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:
295: -- make sure it is not being used by any salesrep if we are narrowing

Line 319: FND_MSG_PUB.ADD;

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:
323: select count(job_role_id) into l_count

Line 336: FND_MSG_PUB.ADD;

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:
340: -- make sure the object version number hasn't changed in the meantime

Line 351: FND_MSG_PUB.Count_And_Get

347: IF FND_API.To_Boolean( p_commit ) THEN
348: COMMIT WORK;
349: END IF;
350:
351: FND_MSG_PUB.Count_And_Get
352: (p_count => x_msg_count,
353: p_data => x_msg_data,
354: p_encoded => FND_API.G_FALSE);
355: EXCEPTION

Line 359: FND_MSG_PUB.Count_And_Get

355: EXCEPTION
356: WHEN FND_API.G_EXC_ERROR THEN
357: ROLLBACK TO Update_Job_Role;
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: FND_MSG_PUB.Count_And_Get
360: (p_count => x_msg_count,
361: p_data => x_msg_data,
362: p_encoded => FND_API.G_FALSE);
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 366: FND_MSG_PUB.Count_And_Get

362: p_encoded => FND_API.G_FALSE);
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
364: ROLLBACK TO Update_Job_Role;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: FND_MSG_PUB.Count_And_Get
367: (p_count => x_msg_count,
368: p_data => x_msg_data,
369: p_encoded => FND_API.G_FALSE);
370: WHEN OTHERS THEN

Line 373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

369: p_encoded => FND_API.G_FALSE);
370: WHEN OTHERS THEN
371: ROLLBACK TO Update_Job_Role;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
374: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
375: END IF;
376: FND_MSG_PUB.Count_And_Get
377: (p_count => x_msg_count,

Line 374: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

370: WHEN OTHERS THEN
371: ROLLBACK TO Update_Job_Role;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
374: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
375: END IF;
376: FND_MSG_PUB.Count_And_Get
377: (p_count => x_msg_count,
378: p_data => x_msg_data,

Line 376: FND_MSG_PUB.Count_And_Get

372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
374: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
375: END IF;
376: FND_MSG_PUB.Count_And_Get
377: (p_count => x_msg_count,
378: p_data => x_msg_data,
379: p_encoded => FND_API.G_FALSE);
380: END Update_Job_Role;

Line 419: FND_MSG_PUB.initialize;

415: END IF;
416:
417: -- Initialize message list if p_init_msg_list is set to TRUE.
418: IF FND_API.to_Boolean( p_init_msg_list ) THEN
419: FND_MSG_PUB.initialize;
420: END IF;
421:
422: -- Initialize API return status to success
423: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 432: FND_MSG_PUB.ADD;

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:
436: -- make sure it is not being used by any salesrep

Line 446: FND_MSG_PUB.Count_And_Get

442: IF FND_API.To_Boolean( p_commit ) THEN
443: COMMIT WORK;
444: END IF;
445:
446: FND_MSG_PUB.Count_And_Get
447: (p_count => x_msg_count,
448: p_data => x_msg_data,
449: p_encoded => FND_API.G_FALSE);
450: EXCEPTION

Line 454: FND_MSG_PUB.Count_And_Get

450: EXCEPTION
451: WHEN FND_API.G_EXC_ERROR THEN
452: ROLLBACK TO Delete_Job_Role;
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: FND_MSG_PUB.Count_And_Get
455: (p_count => x_msg_count,
456: p_data => x_msg_data,
457: p_encoded => FND_API.G_FALSE);
458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 461: FND_MSG_PUB.Count_And_Get

457: p_encoded => FND_API.G_FALSE);
458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
459: ROLLBACK TO Delete_Job_Role;
460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
461: FND_MSG_PUB.Count_And_Get
462: (p_count => x_msg_count,
463: p_data => x_msg_data,
464: p_encoded => FND_API.G_FALSE);
465: WHEN OTHERS THEN

Line 468: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

464: p_encoded => FND_API.G_FALSE);
465: WHEN OTHERS THEN
466: ROLLBACK TO Delete_Job_Role;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
469: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
470: END IF;
471: FND_MSG_PUB.Count_And_Get
472: (p_count => x_msg_count,

Line 469: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

465: WHEN OTHERS THEN
466: ROLLBACK TO Delete_Job_Role;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
469: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
470: END IF;
471: FND_MSG_PUB.Count_And_Get
472: (p_count => x_msg_count,
473: p_data => x_msg_data,

Line 471: FND_MSG_PUB.Count_And_Get

467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
469: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
470: END IF;
471: FND_MSG_PUB.Count_And_Get
472: (p_count => x_msg_count,
473: p_data => x_msg_data,
474: p_encoded => FND_API.G_FALSE);
475: END Delete_Job_Role;