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_API

Line 24: RAISE FND_API.G_EXC_ERROR;

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 ;
28: END ;

Line 60: RAISE FND_API.G_EXC_ERROR;

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
64: IF NVL(p_rec.end_date, L_NULL_END_DATE) < l_max_end_date

Line 68: RAISE FND_API.G_EXC_ERROR;

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;
72: END Verify_Date;

Line 88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

84: -- End of comments
85:
86: PROCEDURE Create_Job_Role
87: (p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: p_rec IN job_role_rec_type,
92: x_return_status OUT NOCOPY VARCHAR2,

Line 89: p_commit IN VARCHAR2 := FND_API.G_FALSE,

85:
86: PROCEDURE Create_Job_Role
87: (p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: p_rec IN job_role_rec_type,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,

Line 90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

86: PROCEDURE Create_Job_Role
87: (p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: p_rec IN job_role_rec_type,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,

Line 108: IF NOT FND_API.Compatible_API_Call

104: -- Standard Start of API savepoint
105: SAVEPOINT Create_Job_Role;
106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call
109: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112:

Line 110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call
109: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 114: IF FND_API.to_Boolean( p_init_msg_list ) THEN

110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 119: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
120:
121: -- make sure job_title_id and role_id are valid
122: -- if default, make sure it doesn't overlap with another default
123:

Line 129: RAISE FND_API.G_EXC_ERROR;

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

Line 147: RAISE FND_API.G_EXC_ERROR;

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
151: from cn_job_roles

Line 163: RAISE FND_API.G_EXC_ERROR;

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
167: from cn_job_roles

Line 176: RAISE FND_API.G_EXC_ERROR;

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);
180:

Line 182: IF FND_API.To_Boolean( p_commit ) THEN

178:
179: cn_job_title_pkg.insert_row(l_newrec);
180:
181: -- Standard check of p_commit.
182: IF FND_API.To_Boolean( p_commit ) THEN
183: COMMIT WORK;
184: END IF;
185:
186: FND_MSG_PUB.Count_And_Get

Line 189: p_encoded => FND_API.G_FALSE);

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:
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: ROLLBACK TO Create_Job_Role;

Line 192: WHEN FND_API.G_EXC_ERROR THEN

188: p_data => x_msg_data,
189: p_encoded => FND_API.G_FALSE);
190:
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,

Line 194: x_return_status := FND_API.G_RET_STS_ERROR;

190:
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);

Line 198: p_encoded => FND_API.G_FALSE);

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
200: ROLLBACK TO Create_Job_Role;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: FND_MSG_PUB.Count_And_Get

Line 199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

197: p_data => x_msg_data,
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);

Line 205: p_encoded => FND_API.G_FALSE);

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

Line 208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

204: p_data => x_msg_data,
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

Line 215: p_encoded => FND_API.G_FALSE);

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;
217:
218: -- Start of comments
219: -- API name : Update_Job_Role - Private.

Line 230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

226: -- End of comments
227:
228: PROCEDURE Update_Job_Role
229: (p_api_version IN NUMBER, -- required
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: p_rec IN job_role_rec_type,
234: x_return_status OUT NOCOPY VARCHAR2,

Line 231: p_commit IN VARCHAR2 := FND_API.G_FALSE,

227:
228: PROCEDURE Update_Job_Role
229: (p_api_version IN NUMBER, -- required
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: p_rec IN job_role_rec_type,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,

Line 232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

228: PROCEDURE Update_Job_Role
229: (p_api_version IN NUMBER, -- required
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: p_rec IN job_role_rec_type,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 251: IF NOT FND_API.Compatible_API_Call

247: -- Standard Start of API savepoint
248: SAVEPOINT Update_Job_Role;
249:
250: -- Standard call to check for call compatibility.
251: IF NOT FND_API.Compatible_API_Call
252: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:

Line 253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

249:
250: -- Standard call to check for call compatibility.
251: IF NOT FND_API.Compatible_API_Call
252: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 257: IF FND_API.to_Boolean( p_init_msg_list ) THEN

253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 262: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
263:
264:
265: -- checks validity of start_date
266: if l_newrec.start_date is null then

Line 269: RAISE FND_API.G_EXC_ERROR;

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:
273: -- make sure job_title_id and role_id are valid

Line 284: RAISE FND_API.G_EXC_ERROR;

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
288: if l_newrec.end_date is not null and

Line 292: RAISE FND_API.G_EXC_ERROR;

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
296: -- the assignment interval

Line 320: RAISE FND_API.G_EXC_ERROR;

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
324: from cn_job_roles

Line 337: RAISE FND_API.G_EXC_ERROR;

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
341: cn_job_title_pkg.lock_row(l_newrec.job_role_id,

Line 347: IF FND_API.To_Boolean( p_commit ) THEN

343:
344: cn_job_title_pkg.update_row(l_newrec);
345:
346: -- Standard check of p_commit.
347: IF FND_API.To_Boolean( p_commit ) THEN
348: COMMIT WORK;
349: END IF;
350:
351: FND_MSG_PUB.Count_And_Get

Line 354: p_encoded => FND_API.G_FALSE);

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
356: WHEN FND_API.G_EXC_ERROR THEN
357: ROLLBACK TO Update_Job_Role;
358: x_return_status := FND_API.G_RET_STS_ERROR;

Line 356: WHEN FND_API.G_EXC_ERROR THEN

352: (p_count => x_msg_count,
353: p_data => x_msg_data,
354: p_encoded => FND_API.G_FALSE);
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,

Line 358: x_return_status := FND_API.G_RET_STS_ERROR;

354: p_encoded => FND_API.G_FALSE);
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);

Line 362: p_encoded => FND_API.G_FALSE);

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
364: ROLLBACK TO Update_Job_Role;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: FND_MSG_PUB.Count_And_Get

Line 363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

361: p_data => x_msg_data,
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);

Line 369: p_encoded => FND_API.G_FALSE);

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

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

368: p_data => x_msg_data,
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

Line 379: p_encoded => FND_API.G_FALSE);

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;
381:
382: -- Start of comments
383: -- API name : Delete_Job_Role - Private.

Line 394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

390: -- End of comments
391:
392: PROCEDURE Delete_Job_Role
393: (p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
397: p_job_role_id IN cn_job_roles.job_role_id%type,
398: p_object_version_number IN cn_job_roles.object_version_number%type,

Line 395: p_commit IN VARCHAR2 := FND_API.G_FALSE,

391:
392: PROCEDURE Delete_Job_Role
393: (p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
397: p_job_role_id IN cn_job_roles.job_role_id%type,
398: p_object_version_number IN cn_job_roles.object_version_number%type,
399: x_return_status OUT NOCOPY VARCHAR2,

Line 396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

392: PROCEDURE Delete_Job_Role
393: (p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
397: p_job_role_id IN cn_job_roles.job_role_id%type,
398: p_object_version_number IN cn_job_roles.object_version_number%type,
399: x_return_status OUT NOCOPY VARCHAR2,
400: x_msg_count OUT NOCOPY NUMBER,

Line 412: IF NOT FND_API.Compatible_API_Call

408: -- Standard Start of API savepoint
409: SAVEPOINT Delete_Job_Role;
410:
411: -- Standard call to check for call compatibility.
412: IF NOT FND_API.Compatible_API_Call
413: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END IF;
416:

Line 414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

410:
411: -- Standard call to check for call compatibility.
412: IF NOT FND_API.Compatible_API_Call
413: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 418: IF FND_API.to_Boolean( p_init_msg_list ) THEN

414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 423: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
424:
425: -- make sure record to be deleted exists.
426: select count(*) into l_count
427: from cn_job_roles

Line 433: RAISE FND_API.G_EXC_ERROR;

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
437: valid_no_srp(p_job_role_id);

Line 442: IF FND_API.To_Boolean( p_commit ) THEN

438:
439: cn_job_title_pkg.delete_row(p_job_role_id);
440:
441: -- Standard check of p_commit.
442: IF FND_API.To_Boolean( p_commit ) THEN
443: COMMIT WORK;
444: END IF;
445:
446: FND_MSG_PUB.Count_And_Get

Line 449: p_encoded => FND_API.G_FALSE);

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
451: WHEN FND_API.G_EXC_ERROR THEN
452: ROLLBACK TO Delete_Job_Role;
453: x_return_status := FND_API.G_RET_STS_ERROR;

Line 451: WHEN FND_API.G_EXC_ERROR THEN

447: (p_count => x_msg_count,
448: p_data => x_msg_data,
449: p_encoded => FND_API.G_FALSE);
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,

Line 453: x_return_status := FND_API.G_RET_STS_ERROR;

449: p_encoded => FND_API.G_FALSE);
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);

Line 457: p_encoded => FND_API.G_FALSE);

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
459: ROLLBACK TO Delete_Job_Role;
460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
461: FND_MSG_PUB.Count_And_Get

Line 458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

456: p_data => x_msg_data,
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);

Line 464: p_encoded => FND_API.G_FALSE);

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

Line 467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

463: p_data => x_msg_data,
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

Line 474: p_encoded => FND_API.G_FALSE);

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;
476:
477: -- Start of comments
478: -- API name : Get_Job_Details - Private