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

Line 35: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_NOT_FOUND');

31: OPEN c1(p_msite_id);
32: FETCH c1 INTO l_tmp_id;
33: IF (c1%NOTFOUND) THEN
34: CLOSE c1;
35: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_NOT_FOUND');
36: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
37: FND_MSG_PUB.Add;
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;

Line 36: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

32: FETCH c1 INTO l_tmp_id;
33: IF (c1%NOTFOUND) THEN
34: CLOSE c1;
35: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_NOT_FOUND');
36: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
37: FND_MSG_PUB.Add;
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;
40: CLOSE c1;

Line 100: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_APPL_NOT_FOUND');

96: OPEN c1(p_responsibility_id, p_application_id);
97: FETCH c1 INTO l_tmp_id;
98: IF (c1%NOTFOUND) THEN
99: CLOSE c1;
100: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_APPL_NOT_FOUND');
101: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
102: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_ERROR;

Line 101: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);

97: FETCH c1 INTO l_tmp_id;
98: IF (c1%NOTFOUND) THEN
99: CLOSE c1;
100: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_APPL_NOT_FOUND');
101: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
102: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;

Line 102: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);

98: IF (c1%NOTFOUND) THEN
99: CLOSE c1;
100: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_APPL_NOT_FOUND');
101: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
102: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106: CLOSE c1;

Line 178: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_NOT_FOUND');

174: OPEN c1(p_msite_resp_id);
175: FETCH c1 INTO l_tmp_id;
176: IF (c1%NOTFOUND) THEN
177: CLOSE c1;
178: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_NOT_FOUND');
179: FND_MESSAGE.Set_Token('MSITE_RESP_ID', p_msite_resp_id);
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
182: CLOSE c1;

Line 179: FND_MESSAGE.Set_Token('MSITE_RESP_ID', p_msite_resp_id);

175: FETCH c1 INTO l_tmp_id;
176: IF (c1%NOTFOUND) THEN
177: CLOSE c1;
178: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_NOT_FOUND');
179: FND_MESSAGE.Set_Token('MSITE_RESP_ID', p_msite_resp_id);
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
182: CLOSE c1;
183:

Line 196: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');

192: OPEN c2(p_msite_id, p_responsibility_id, p_application_id);
193: FETCH c2 INTO l_tmp_id;
194: IF (c2%NOTFOUND) THEN
195: CLOSE c2;
196: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
197: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
198: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
199: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
200: RAISE FND_API.G_EXC_ERROR;

Line 197: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

193: FETCH c2 INTO l_tmp_id;
194: IF (c2%NOTFOUND) THEN
195: CLOSE c2;
196: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
197: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
198: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
199: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;

Line 198: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);

194: IF (c2%NOTFOUND) THEN
195: CLOSE c2;
196: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
197: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
198: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
199: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202: CLOSE c2;

Line 199: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);

195: CLOSE c2;
196: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
197: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
198: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
199: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202: CLOSE c2;
203:

Line 207: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_MR_IDS_SPEC');

203:
204: ELSE
205: -- neither msite_resp_id nor combination of
206: -- msite_id, responsibility_id and application_id is specified
207: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_MR_IDS_SPEC');
208: FND_MSG_PUB.Add;
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211:

Line 282: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_MSITE_ID');

278: -- p_msite_id
279: IF ((p_msite_id IS NULL) OR
280: (p_msite_id = FND_API.G_MISS_NUM))
281: THEN
282: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_MSITE_ID');
283: FND_MSG_PUB.Add;
284: RAISE FND_API.G_EXC_ERROR;
285: END IF;
286:

Line 291: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVALID_RESP_ID');

287: -- p_responsibility_id
288: IF ((p_responsibility_id IS NULL) OR
289: (p_responsibility_id = FND_API.G_MISS_NUM))
290: THEN
291: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVALID_RESP_ID');
292: FND_MSG_PUB.Add;
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;
295:

Line 300: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVALID_APPL_ID');

296: -- application_id
297: IF ((p_application_id IS NULL) OR
298: (p_application_id = FND_API.G_MISS_NUM))
299: THEN
300: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVALID_APPL_ID');
301: FND_MSG_PUB.Add;
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304:

Line 309: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');

305: -- start_date_active
306: IF ((p_start_date_active IS NULL) OR
307: (p_start_date_active = FND_API.G_MISS_DATE))
308: THEN
309: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
310: FND_MSG_PUB.Add;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313:

Line 318: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_MSRSP_DSP_NAME');

314: -- display_name
315: IF ((p_display_name IS NULL) OR
316: (p_display_name = FND_API.G_MISS_CHAR))
317: THEN
318: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_MSRSP_DSP_NAME');
319: FND_MSG_PUB.Add;
320: RAISE FND_API.G_EXC_ERROR;
321: END IF;
322:

Line 332: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_SORT_ORDER');

328: IF ((p_sort_order IS NOT NULL) AND
329: (p_sort_order <> FND_API.G_MISS_NUM))
330: THEN
331: IF(p_sort_order < 0) THEN
332: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_SORT_ORDER');
333: FND_MSG_PUB.Add;
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;
336: END IF;

Line 352: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_VLD_FAIL');

348: x_msg_data => x_msg_data
349: );
350:
351: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
352: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_VLD_FAIL');
353: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
354: FND_MSG_PUB.Add;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 353: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

349: );
350:
351: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
352: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_VLD_FAIL');
353: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
354: FND_MSG_PUB.Add;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
357: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_VLD_FAIL');

Line 357: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_VLD_FAIL');

353: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
354: FND_MSG_PUB.Add;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
357: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_VLD_FAIL');
358: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
359: RAISE FND_API.G_EXC_ERROR; -- invalid msite_id
360: END IF;
361:

Line 358: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

354: FND_MSG_PUB.Add;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
357: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_VLD_FAIL');
358: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
359: RAISE FND_API.G_EXC_ERROR; -- invalid msite_id
360: END IF;
361:
362: -- responsibility_id and application_id

Line 373: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_ID_VLD_FAIL');

369: x_msg_data => x_msg_data
370: );
371:
372: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
373: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_ID_VLD_FAIL');
374: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
375: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
376: FND_MSG_PUB.Add;
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 374: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);

370: );
371:
372: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
373: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_ID_VLD_FAIL');
374: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
375: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
376: FND_MSG_PUB.Add;
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 375: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);

371:
372: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
373: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_ID_VLD_FAIL');
374: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
375: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
376: FND_MSG_PUB.Add;
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
379: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_ID_VLD_FAIL');

Line 379: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_ID_VLD_FAIL');

375: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
376: FND_MSG_PUB.Add;
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
379: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_ID_VLD_FAIL');
380: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
381: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;

Line 380: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);

376: FND_MSG_PUB.Add;
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
379: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_ID_VLD_FAIL');
380: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
381: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384:

Line 381: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);

377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
379: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_RESP_ID_VLD_FAIL');
380: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
381: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384:
385: -- p_msite_id, p_responsibility_id, p_application_id (check for duplicate)

Line 400: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_VLD_FAIL');

396:
397: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
400: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_VLD_FAIL');
401: FND_MSG_PUB.Add;
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- duplicate exists
404: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_DUP_EXISTS');

Line 404: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_DUP_EXISTS');

400: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_VLD_FAIL');
401: FND_MSG_PUB.Add;
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- duplicate exists
404: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_DUP_EXISTS');
405: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
406: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
407: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
408: FND_MSG_PUB.Add;

Line 405: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

401: FND_MSG_PUB.Add;
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- duplicate exists
404: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_DUP_EXISTS');
405: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
406: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
407: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
408: FND_MSG_PUB.Add;
409: RAISE FND_API.G_EXC_ERROR;

Line 406: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);

402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- duplicate exists
404: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_DUP_EXISTS');
405: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
406: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
407: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
408: FND_MSG_PUB.Add;
409: RAISE FND_API.G_EXC_ERROR;
410: END IF;

Line 407: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);

403: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- duplicate exists
404: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_DUP_EXISTS');
405: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
406: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
407: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
408: FND_MSG_PUB.Add;
409: RAISE FND_API.G_EXC_ERROR;
410: END IF;
411:

Line 479: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_IS_NULL');

475: --
476:
477: -- msite_resp_id
478: IF (p_msite_resp_id IS NULL) THEN
479: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_IS_NULL');
480: FND_MSG_PUB.Add;
481: RAISE FND_API.G_EXC_ERROR;
482: END IF;
483:

Line 487: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_OVN_IS_NULL');

483:
484: -- object_version_number
485: IF (p_object_version_number IS NULL)
486: THEN
487: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_OVN_IS_NULL');
488: FND_MSG_PUB.Add;
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491:

Line 494: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');

490: END IF;
491:
492: -- start_date_active
493: IF (p_start_date_active IS NULL) THEN
494: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:

Line 501: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_MSRSP_DSP_NAME');

497: END IF;
498:
499: -- display_name
500: IF (p_display_name IS NULL) THEN
501: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_MSRSP_DSP_NAME');
502: FND_MSG_PUB.Add;
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:

Line 515: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_SORT_ORDER');

511: IF ((p_sort_order IS NOT NULL) AND
512: (p_sort_order <> FND_API.G_MISS_NUM))
513: THEN
514: IF(p_sort_order < 0) THEN
515: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_SORT_ORDER');
516: FND_MSG_PUB.Add;
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519: END IF;

Line 534: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_VLD_FAIL');

530: x_msg_data => x_msg_data
531: );
532:
533: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
534: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_VLD_FAIL');
535: FND_MSG_PUB.Add;
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
538: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_VLD_FAIL');

Line 538: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_VLD_FAIL');

534: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_VLD_FAIL');
535: FND_MSG_PUB.Add;
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
538: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSRSP_ID_VLD_FAIL');
539: FND_MSG_PUB.Add;
540: RAISE FND_API.G_EXC_ERROR;
541: END IF;
542:

Line 646: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_CREATE');

642: x_msg_data => x_msg_data
643: );
644:
645: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
646: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_CREATE');
647: FND_MSG_PUB.Add;
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
650: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_CREATE');

Line 650: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_CREATE');

646: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_CREATE');
647: FND_MSG_PUB.Add;
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
650: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_CREATE');
651: FND_MSG_PUB.Add;
652: RAISE FND_API.G_EXC_ERROR; -- invalid
653: END IF;
654:

Line 682: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_INSERT_FL');

678: );
679:
680: EXCEPTION
681: WHEN NO_DATA_FOUND THEN
682: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_INSERT_FL');
683: FND_MSG_PUB.Add;
684: RAISE FND_API.G_EXC_ERROR;
685: WHEN OTHERS THEN
686: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_INSERT_FL');

Line 686: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_INSERT_FL');

682: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_INSERT_FL');
683: FND_MSG_PUB.Add;
684: RAISE FND_API.G_EXC_ERROR;
685: WHEN OTHERS THEN
686: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_INSERT_FL');
687: FND_MSG_PUB.Add;
688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
689: END;
690:

Line 815: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');

811: OPEN c1(p_msite_id, p_responsibility_id, p_application_id);
812: FETCH c1 INTO l_msite_resp_id;
813: IF (c1%NOTFOUND) THEN
814: CLOSE c1;
815: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
816: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
817: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
818: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
819: RAISE FND_API.G_EXC_ERROR;

Line 816: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

812: FETCH c1 INTO l_msite_resp_id;
813: IF (c1%NOTFOUND) THEN
814: CLOSE c1;
815: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
816: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
817: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
818: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;

Line 817: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);

813: IF (c1%NOTFOUND) THEN
814: CLOSE c1;
815: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
816: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
817: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
818: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821: CLOSE c1;

Line 818: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);

814: CLOSE c1;
815: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
816: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
817: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
818: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821: CLOSE c1;
822:

Line 826: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_MR_IDS_SPEC');

822:
823: ELSE
824: -- neither msite_resp_id nor combination of
825: -- msite_id, responsibility_id and application_id is specified
826: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_MR_IDS_SPEC');
827: FND_MSG_PUB.Add;
828: RAISE FND_API.G_EXC_ERROR;
829: END IF;
830:

Line 850: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_UPDATE');

846: x_msg_data => x_msg_data
847: );
848:
849: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
850: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_UPDATE');
851: FND_MSG_PUB.Add;
852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
854: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_UPDATE');

Line 854: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_UPDATE');

850: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_UPDATE');
851: FND_MSG_PUB.Add;
852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
854: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_UPDATE');
855: FND_MSG_PUB.Add;
856: RAISE FND_API.G_EXC_ERROR; -- invalid
857: END IF;
858:

Line 877: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_UPDATE_FL');

873: );
874:
875: EXCEPTION
876: WHEN NO_DATA_FOUND THEN
877: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_UPDATE_FL');
878: FND_MSG_PUB.ADD;
879: RAISE FND_API.G_EXC_ERROR;
880: WHEN OTHERS THEN
881: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_UPDATE_FL');

Line 881: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_UPDATE_FL');

877: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_UPDATE_FL');
878: FND_MSG_PUB.ADD;
879: RAISE FND_API.G_EXC_ERROR;
880: WHEN OTHERS THEN
881: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_UPDATE_FL');
882: FND_MSG_PUB.ADD;
883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
884: END;
885:

Line 1002: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');

998: OPEN c1(p_msite_id, p_responsibility_id, p_application_id);
999: FETCH c1 INTO l_msite_resp_id;
1000: IF (c1%NOTFOUND) THEN
1001: CLOSE c1;
1002: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
1003: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
1004: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
1005: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
1006: RAISE FND_API.G_EXC_ERROR;

Line 1003: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

999: FETCH c1 INTO l_msite_resp_id;
1000: IF (c1%NOTFOUND) THEN
1001: CLOSE c1;
1002: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
1003: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
1004: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
1005: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;

Line 1004: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);

1000: IF (c1%NOTFOUND) THEN
1001: CLOSE c1;
1002: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
1003: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
1004: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
1005: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;
1008: CLOSE c1;

Line 1005: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);

1001: CLOSE c1;
1002: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITERESP_NOT_FOUND');
1003: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
1004: FND_MESSAGE.Set_Token('RESP_ID', p_responsibility_id);
1005: FND_MESSAGE.Set_Token('APPL_ID', p_application_id);
1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;
1008: CLOSE c1;
1009:

Line 1013: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_MR_IDS_SPEC');

1009:
1010: ELSE
1011: -- neither msite_resp_id nor combination of
1012: -- msite_id, responsibility_id and application_id is specified
1013: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_MR_IDS_SPEC');
1014: FND_MSG_PUB.Add;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017:

Line 1023: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_DELETE_FL');

1019: BEGIN
1020: Jtf_Msite_Resp_Pkg.delete_row(l_msite_resp_id);
1021: EXCEPTION
1022: WHEN NO_DATA_FOUND THEN
1023: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_DELETE_FL');
1024: FND_MSG_PUB.Add;
1025: RAISE FND_API.G_EXC_ERROR;
1026: WHEN OTHERS THEN
1027: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_DELETE_FL');

Line 1027: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_DELETE_FL');

1023: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_DELETE_FL');
1024: FND_MSG_PUB.Add;
1025: RAISE FND_API.G_EXC_ERROR;
1026: WHEN OTHERS THEN
1027: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_DELETE_FL');
1028: FND_MSG_PUB.Add;
1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1030: END;
1031: