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_MSG_PUB

Line 41: FND_MSG_PUB.Add;

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;
45:

Line 50: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

46: EXCEPTION
47:
48: WHEN FND_API.G_EXC_ERROR THEN
49: x_return_status := FND_API.G_RET_STS_ERROR;
50: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
51: p_data => x_msg_data,
52: p_encoded => 'F');
53:
54: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 56: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

52: p_encoded => 'F');
53:
54: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
55: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
56: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
57: p_data => x_msg_data,
58: p_encoded => 'F');
59:
60: WHEN OTHERS THEN

Line 63: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

59:
60: WHEN OTHERS THEN
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
62:
63: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
64: THEN
65: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
66: END IF;
67:

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

61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
62:
63: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
64: THEN
65: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
66: END IF;
67:
68: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
69: p_data => x_msg_data,

Line 68: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

64: THEN
65: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
66: END IF;
67:
68: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
69: p_data => x_msg_data,
70: p_encoded => 'F');
71:
72: END Validate_Msite_Id_Exists;

Line 103: FND_MSG_PUB.Add;

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;
107:

Line 112: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

108: EXCEPTION
109:
110: WHEN FND_API.G_EXC_ERROR THEN
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
113: p_data => x_msg_data,
114: p_encoded => 'F');
115:
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 118: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

114: p_encoded => 'F');
115:
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
119: p_data => x_msg_data,
120: p_encoded => 'F');
121:
122: WHEN OTHERS THEN

Line 125: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

121:
122: WHEN OTHERS THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124:
125: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
126: THEN
127: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
128: END IF;
129:

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

123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124:
125: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
126: THEN
127: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
128: END IF;
129:
130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
131: p_data => x_msg_data,

Line 130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

126: THEN
127: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
128: END IF;
129:
130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
131: p_data => x_msg_data,
132: p_encoded => 'F');
133:
134: END Validate_Prty_Id_Exists;

Line 202: FND_MSG_PUB.Add;

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:
206: EXCEPTION

Line 210: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

206: EXCEPTION
207:
208: WHEN FND_API.G_EXC_ERROR THEN
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
211: p_data => x_msg_data,
212: p_encoded => 'F');
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

212: p_encoded => 'F');
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
217: p_data => x_msg_data,
218: p_encoded => 'F');
219:
220: WHEN OTHERS THEN

Line 223: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

219:
220: WHEN OTHERS THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222:
223: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
224: THEN
225: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
226: END IF;
227:

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

221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222:
223: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
224: THEN
225: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
226: END IF;
227:
228: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
229: p_data => x_msg_data,

Line 228: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

224: THEN
225: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
226: END IF;
227:
228: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
229: p_data => x_msg_data,
230: p_encoded => 'F');
231:
232: END Validate_Msite_Prty_Id_Exists;

Line 258: FND_MSG_PUB.initialize;

254: BEGIN
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 273: FND_MSG_PUB.Add;

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:
277: -- p_party_id

Line 282: FND_MSG_PUB.Add;

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:
286: -- start_date_active

Line 291: FND_MSG_PUB.Add;

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

Line 315: FND_MSG_PUB.Add;

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');
319: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

Line 335: FND_MSG_PUB.Add;

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');
339: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);

Line 358: FND_MSG_PUB.Add;

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');
362: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

Line 364: FND_MSG_PUB.Add;

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:
368: EXCEPTION

Line 372: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

368: EXCEPTION
369:
370: WHEN FND_API.G_EXC_ERROR THEN
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
373: p_data => x_msg_data,
374: p_encoded => 'F');
375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 378: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

374: p_encoded => 'F');
375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
379: p_data => x_msg_data,
380: p_encoded => 'F');
381:
382: WHEN OTHERS THEN

Line 385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

381:
382: WHEN OTHERS THEN
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384:
385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
388: END IF;
389:

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

383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384:
385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
388: END IF;
389:
390: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
391: p_data => x_msg_data,

Line 390: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

386: THEN
387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
388: END IF;
389:
390: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
391: p_data => x_msg_data,
392: p_encoded => 'F');
393:
394: END Validate_Create;

Line 420: FND_MSG_PUB.initialize;

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

Line 433: FND_MSG_PUB.Add;

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:
437: -- object_version_number

Line 441: FND_MSG_PUB.Add;

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:
445: -- start_date_active

Line 448: FND_MSG_PUB.Add;

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

Line 469: FND_MSG_PUB.Add;

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');
473: FND_MSG_PUB.Add;

Line 473: FND_MSG_PUB.Add;

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

Line 482: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

478: EXCEPTION
479:
480: WHEN FND_API.G_EXC_ERROR THEN
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
483: p_data => x_msg_data,
484: p_encoded => 'F');
485:
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 488: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

484: p_encoded => 'F');
485:
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
489: p_data => x_msg_data,
490: p_encoded => 'F');
491:
492: WHEN OTHERS THEN

Line 495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

491:
492: WHEN OTHERS THEN
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494:
495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
498: END IF;
499:

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

493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494:
495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
498: END IF;
499:
500: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
501: p_data => x_msg_data,

Line 500: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

496: THEN
497: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
498: END IF;
499:
500: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
501: p_data => x_msg_data,
502: p_encoded => 'F');
503:
504: END Validate_Update;

Line 545: FND_MSG_PUB.initialize;

541: END IF;
542:
543: -- Initialize message list if p_init_msg_list is set to TRUE.
544: IF FND_API.to_Boolean(p_init_msg_list) THEN
545: FND_MSG_PUB.initialize;
546: END IF;
547:
548: -- Initialize API return status to success
549: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 575: FND_MSG_PUB.Add;

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');
579: FND_MSG_PUB.Add;

Line 579: FND_MSG_PUB.Add;

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

Line 607: FND_MSG_PUB.Add;

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');
611: FND_MSG_PUB.Add;

Line 611: FND_MSG_PUB.Add;

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

Line 624: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

620: COMMIT WORK;
621: END IF;
622:
623: -- Standard call to get message count and if count is 1, get message info.
624: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
625: p_data => x_msg_data,
626: p_encoded => 'F');
627:
628: EXCEPTION

Line 633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

629:
630: WHEN FND_API.G_EXC_ERROR THEN
631: ROLLBACK TO create_msite_prty_accss_pvt;
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
634: p_data => x_msg_data,
635: p_encoded => 'F');
636:
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 640: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

636:
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638: ROLLBACK TO create_msite_prty_accss_pvt;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
641: p_data => x_msg_data,
642: p_encoded => 'F');
643:
644: WHEN OTHERS THEN

Line 648: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

644: WHEN OTHERS THEN
645: ROLLBACK TO create_msite_prty_accss_pvt;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647:
648: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
649: THEN
650: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
651: END IF;
652:

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

646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647:
648: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
649: THEN
650: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
651: END IF;
652:
653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
654: p_data => x_msg_data,

Line 653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

649: THEN
650: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
651: END IF;
652:
653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
654: p_data => x_msg_data,
655: p_encoded => 'F');
656:
657: END Create_Msite_Prty_Accss;

Line 702: FND_MSG_PUB.initialize;

698: END IF;
699:
700: -- Initialize message list if p_init_msg_list is set to TRUE.
701: IF FND_API.to_Boolean(p_init_msg_list) THEN
702: FND_MSG_PUB.initialize;
703: END IF;
704:
705: -- Initialize API return status to success
706: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 743: FND_MSG_PUB.Add;

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

Line 765: FND_MSG_PUB.Add;

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');
769: FND_MSG_PUB.Add;

Line 769: FND_MSG_PUB.Add;

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:
773: -- 2. update row with section data into section table

Line 789: FND_MSG_PUB.ADD;

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');
793: FND_MSG_PUB.ADD;

Line 793: FND_MSG_PUB.ADD;

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

Line 806: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

802: COMMIT WORK;
803: END IF;
804:
805: -- standard call to get message count and if count is 1, get message info.
806: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
807: p_data => x_msg_data,
808: p_encoded => 'F');
809:
810: EXCEPTION

Line 815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

811:
812: WHEN FND_API.G_EXC_ERROR THEN
813: ROLLBACK TO update_msite_prty_accss_pvt;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
816: p_data => x_msg_data,
817: p_encoded => 'F');
818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: ROLLBACK TO update_msite_prty_accss_pvt;
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
823: p_data => x_msg_data,
824: p_encoded => 'F');
825:
826: WHEN OTHERS THEN

Line 830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

826: WHEN OTHERS THEN
827: ROLLBACK TO update_msite_prty_accss_pvt;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829:
830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
831: THEN
832: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
833: END IF;
834:

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

828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829:
830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
831: THEN
832: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
833: END IF;
834:
835: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
836: p_data => x_msg_data,

Line 835: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

831: THEN
832: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
833: END IF;
834:
835: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
836: p_data => x_msg_data,
837: p_encoded => 'F');
838:
839: END Update_Msite_Prty_Accss;

Line 881: FND_MSG_PUB.initialize;

877: END IF;
878:
879: -- Initialize message list if p_init_msg_list is set to TRUE.
880: IF FND_API.to_Boolean(p_init_msg_list) THEN
881: FND_MSG_PUB.initialize;
882: END IF;
883:
884: -- Initialize API return status to success
885: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 919: FND_MSG_PUB.Add;

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:
923: -- delete for ibe_msite_prty_accss

Line 929: FND_MSG_PUB.Add;

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');
933: FND_MSG_PUB.Add;

Line 933: FND_MSG_PUB.Add;

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:
937: EXCEPTION

Line 942: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

938:
939: WHEN FND_API.G_EXC_ERROR THEN
940: ROLLBACK TO delete_msite_prty_accss_pvt;
941: x_return_status := FND_API.G_RET_STS_ERROR;
942: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
943: p_data => x_msg_data,
944: p_encoded => 'F');
945:
946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 949: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

945:
946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
947: ROLLBACK TO delete_msite_prty_accss_pvt;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
950: p_data => x_msg_data,
951: p_encoded => 'F');
952:
953: WHEN OTHERS THEN

Line 957: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

953: WHEN OTHERS THEN
954: ROLLBACK TO delete_msite_prty_accss_pvt;
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956:
957: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
958: THEN
959: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
960: END IF;
961:

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

955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956:
957: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
958: THEN
959: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
960: END IF;
961:
962: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
963: p_data => x_msg_data,

Line 962: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

958: THEN
959: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
960: END IF;
961:
962: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
963: p_data => x_msg_data,
964: p_encoded => 'F');
965:
966: END Delete_Msite_Prty_Accss;