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

Line 39: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_NOT_FOUND');

35: OPEN c1(p_msite_id);
36: FETCH c1 INTO l_tmp_id;
37: IF (c1%NOTFOUND) THEN
38: CLOSE c1;
39: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_NOT_FOUND');
40: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
41: FND_MSG_PUB.Add;
42: RAISE FND_API.G_EXC_ERROR;
43: END IF;

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

36: FETCH c1 INTO l_tmp_id;
37: IF (c1%NOTFOUND) THEN
38: CLOSE c1;
39: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_NOT_FOUND');
40: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
41: FND_MSG_PUB.Add;
42: RAISE FND_API.G_EXC_ERROR;
43: END IF;
44: CLOSE c1;

Line 101: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PARTY_NOT_FOUND');

97: OPEN c1(p_party_id);
98: FETCH c1 INTO l_tmp_id;
99: IF (c1%NOTFOUND) THEN
100: CLOSE c1;
101: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PARTY_NOT_FOUND');
102: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;

Line 102: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);

98: FETCH c1 INTO l_tmp_id;
99: IF (c1%NOTFOUND) THEN
100: CLOSE c1;
101: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PARTY_NOT_FOUND');
102: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106: CLOSE c1;

Line 175: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_NOT_FOUND');

171: OPEN c1(p_msite_prty_accss_id);
172: FETCH c1 INTO l_tmp_id;
173: IF (c1%NOTFOUND) THEN
174: CLOSE c1;
175: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_NOT_FOUND');
176: FND_MESSAGE.Set_Token('MSITE_PRTY_ACCSS_ID', p_msite_prty_accss_id);
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179: CLOSE c1;

Line 176: FND_MESSAGE.Set_Token('MSITE_PRTY_ACCSS_ID', p_msite_prty_accss_id);

172: FETCH c1 INTO l_tmp_id;
173: IF (c1%NOTFOUND) THEN
174: CLOSE c1;
175: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_NOT_FOUND');
176: FND_MESSAGE.Set_Token('MSITE_PRTY_ACCSS_ID', p_msite_prty_accss_id);
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179: CLOSE c1;
180:

Line 191: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');

187: OPEN c2(p_msite_id, p_party_id);
188: FETCH c2 INTO l_tmp_id;
189: IF (c2%NOTFOUND) THEN
190: CLOSE c2;
191: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');
192: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
193: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;

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

188: FETCH c2 INTO l_tmp_id;
189: IF (c2%NOTFOUND) THEN
190: CLOSE c2;
191: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');
192: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
193: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;
196: CLOSE c2;

Line 193: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);

189: IF (c2%NOTFOUND) THEN
190: CLOSE c2;
191: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');
192: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
193: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;
196: CLOSE c2;
197:

Line 201: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MP_IDS_SPEC');

197:
198: ELSE
199: -- neither msite_prty_accss_id nor combination of
200: -- msite_id and party_id is specified
201: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MP_IDS_SPEC');
202: FND_MSG_PUB.Add;
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205:

Line 272: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_MSITE_ID');

268: -- p_msite_id
269: IF ((p_msite_id IS NULL) OR
270: (p_msite_id = FND_API.G_MISS_NUM))
271: THEN
272: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_MSITE_ID');
273: FND_MSG_PUB.Add;
274: RAISE FND_API.G_EXC_ERROR;
275: END IF;
276:

Line 281: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INVALID_PRTY_ID');

277: -- p_party_id
278: IF ((p_party_id IS NULL) OR
279: (p_party_id = FND_API.G_MISS_NUM))
280: THEN
281: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INVALID_PRTY_ID');
282: FND_MSG_PUB.Add;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:

Line 290: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');

286: -- start_date_active
287: IF ((p_start_date_active IS NULL) OR
288: (p_start_date_active = FND_API.G_MISS_DATE))
289: THEN
290: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
291: FND_MSG_PUB.Add;
292: RAISE FND_API.G_EXC_ERROR;
293: END IF;
294:

Line 313: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_VLD_FAIL');

309: x_msg_data => x_msg_data
310: );
311:
312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
313: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_VLD_FAIL');
314: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
315: FND_MSG_PUB.Add;
316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

310: );
311:
312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
313: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_VLD_FAIL');
314: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
315: FND_MSG_PUB.Add;
316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
318: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_VLD_FAIL');

Line 318: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_VLD_FAIL');

314: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
315: FND_MSG_PUB.Add;
316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
318: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_VLD_FAIL');
319: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
320: RAISE FND_API.G_EXC_ERROR; -- invalid msite_id
321: END IF;
322:

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

315: FND_MSG_PUB.Add;
316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
318: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_VLD_FAIL');
319: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
320: RAISE FND_API.G_EXC_ERROR; -- invalid msite_id
321: END IF;
322:
323: -- party_id

Line 333: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ID_VLD_FAIL');

329: x_msg_data => x_msg_data
330: );
331:
332: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
333: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ID_VLD_FAIL');
334: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
335: FND_MSG_PUB.Add;
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 334: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);

330: );
331:
332: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
333: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ID_VLD_FAIL');
334: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
335: FND_MSG_PUB.Add;
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
338: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ID_VLD_FAIL');

Line 338: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ID_VLD_FAIL');

334: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
335: FND_MSG_PUB.Add;
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
338: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ID_VLD_FAIL');
339: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:

Line 339: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);

335: FND_MSG_PUB.Add;
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
338: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ID_VLD_FAIL');
339: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:
343: -- p_msite_id, p_party_id (check for duplicate)

Line 357: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_VLD_FAIL');

353:
354: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
355: x_return_status := FND_API.G_RET_STS_SUCCESS;
356: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
357: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_VLD_FAIL');
358: FND_MSG_PUB.Add;
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- duplicate exists
361: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_DUP_EXISTS');

Line 361: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_DUP_EXISTS');

357: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_VLD_FAIL');
358: FND_MSG_PUB.Add;
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- duplicate exists
361: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_DUP_EXISTS');
362: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
363: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
364: FND_MSG_PUB.Add;
365: RAISE FND_API.G_EXC_ERROR;

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

358: FND_MSG_PUB.Add;
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- duplicate exists
361: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_DUP_EXISTS');
362: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
363: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
364: FND_MSG_PUB.Add;
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;

Line 363: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);

359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- duplicate exists
361: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_DUP_EXISTS');
362: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
363: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
364: FND_MSG_PUB.Add;
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367:

Line 432: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_IS_NULL');

428: --
429:
430: -- msite_prty_accss_id
431: IF (p_msite_prty_accss_id IS NULL) THEN
432: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_IS_NULL');
433: FND_MSG_PUB.Add;
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436:

Line 440: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_OVN_IS_NULL');

436:
437: -- object_version_number
438: IF (p_object_version_number IS NULL)
439: THEN
440: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_OVN_IS_NULL');
441: FND_MSG_PUB.Add;
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:

Line 447: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');

443: END IF;
444:
445: -- start_date_active
446: IF (p_start_date_active IS NULL) THEN
447: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
448: FND_MSG_PUB.Add;
449: RAISE FND_API.G_EXC_ERROR;
450: END IF;
451:

Line 468: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_VLD_FAIL');

464: x_msg_data => x_msg_data
465: );
466:
467: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
468: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_VLD_FAIL');
469: FND_MSG_PUB.Add;
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
472: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_VLD_FAIL');

Line 472: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_VLD_FAIL');

468: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_VLD_FAIL');
469: FND_MSG_PUB.Add;
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
472: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSPRT_ID_VLD_FAIL');
473: FND_MSG_PUB.Add;
474: RAISE FND_API.G_EXC_ERROR;
475: END IF;
476:

Line 574: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_CREATE');

570: x_msg_data => x_msg_data
571: );
572:
573: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
574: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_CREATE');
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
578: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_CREATE');

Line 578: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_CREATE');

574: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_CREATE');
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
578: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_CREATE');
579: FND_MSG_PUB.Add;
580: RAISE FND_API.G_EXC_ERROR; -- invalid
581: END IF;
582:

Line 606: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_INSERT_FL');

602: );
603:
604: EXCEPTION
605: WHEN NO_DATA_FOUND THEN
606: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_INSERT_FL');
607: FND_MSG_PUB.Add;
608: RAISE FND_API.G_EXC_ERROR;
609: WHEN OTHERS THEN
610: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_INSERT_FL');

Line 610: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_INSERT_FL');

606: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_INSERT_FL');
607: FND_MSG_PUB.Add;
608: RAISE FND_API.G_EXC_ERROR;
609: WHEN OTHERS THEN
610: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_INSERT_FL');
611: FND_MSG_PUB.Add;
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END;
614:

Line 732: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');

728: OPEN c1(p_msite_id, p_party_id);
729: FETCH c1 INTO l_msite_prty_accss_id;
730: IF (c1%NOTFOUND) THEN
731: CLOSE c1;
732: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');
733: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
734: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;

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

729: FETCH c1 INTO l_msite_prty_accss_id;
730: IF (c1%NOTFOUND) THEN
731: CLOSE c1;
732: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');
733: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
734: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;
737: CLOSE c1;

Line 734: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);

730: IF (c1%NOTFOUND) THEN
731: CLOSE c1;
732: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');
733: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
734: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;
737: CLOSE c1;
738:

Line 742: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MP_IDS_SPEC');

738:
739: ELSE
740: -- neither msite_prty_accss_id nor combination of
741: -- msite_id and party_id is specified
742: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MP_IDS_SPEC');
743: FND_MSG_PUB.Add;
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746:

Line 764: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_UPDATE');

760: x_msg_data => x_msg_data
761: );
762:
763: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
764: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_UPDATE');
765: FND_MSG_PUB.Add;
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
768: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_UPDATE');

Line 768: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_UPDATE');

764: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_UPDATE');
765: FND_MSG_PUB.Add;
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
768: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MP_INVALID_UPDATE');
769: FND_MSG_PUB.Add;
770: RAISE FND_API.G_EXC_ERROR; -- invalid
771: END IF;
772:

Line 788: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_UPDATE_FL');

784: );
785:
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN
788: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_UPDATE_FL');
789: FND_MSG_PUB.ADD;
790: RAISE FND_API.G_EXC_ERROR;
791: WHEN OTHERS THEN
792: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_UPDATE_FL');

Line 792: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_UPDATE_FL');

788: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_UPDATE_FL');
789: FND_MSG_PUB.ADD;
790: RAISE FND_API.G_EXC_ERROR;
791: WHEN OTHERS THEN
792: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_UPDATE_FL');
793: FND_MSG_PUB.ADD;
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END;
796:

Line 908: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');

904: OPEN c1(p_msite_id, p_party_id);
905: FETCH c1 INTO l_msite_prty_accss_id;
906: IF (c1%NOTFOUND) THEN
907: CLOSE c1;
908: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');
909: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
910: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;

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

905: FETCH c1 INTO l_msite_prty_accss_id;
906: IF (c1%NOTFOUND) THEN
907: CLOSE c1;
908: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');
909: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
910: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: CLOSE c1;

Line 910: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);

906: IF (c1%NOTFOUND) THEN
907: CLOSE c1;
908: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITEPRTY_NOT_FOUND');
909: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
910: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: CLOSE c1;
914:

Line 918: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MP_IDS_SPEC');

914:
915: ELSE
916: -- neither msite_prty_accss_id nor combination of
917: -- msite_id and party_id is specified
918: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MP_IDS_SPEC');
919: FND_MSG_PUB.Add;
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922:

Line 928: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_DELETE_FL');

924: BEGIN
925: Ibe_Msite_Prty_Accss_Pkg.delete_row(l_msite_prty_accss_id);
926: EXCEPTION
927: WHEN NO_DATA_FOUND THEN
928: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_DELETE_FL');
929: FND_MSG_PUB.Add;
930: RAISE FND_API.G_EXC_ERROR;
931: WHEN OTHERS THEN
932: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_DELETE_FL');

Line 932: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_DELETE_FL');

928: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_DELETE_FL');
929: FND_MSG_PUB.Add;
930: RAISE FND_API.G_EXC_ERROR;
931: WHEN OTHERS THEN
932: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_DELETE_FL');
933: FND_MSG_PUB.Add;
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END;
936: