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_PRTY_ACCSS_PVT dependencies on FND_MSG_PUB

Line 37: FND_MSG_PUB.Add;

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

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

42: EXCEPTION
43:
44: WHEN FND_API.G_EXC_ERROR THEN
45: x_return_status := FND_API.G_RET_STS_ERROR;
46: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
47: p_data => x_msg_data,
48: p_encoded => 'F');
49:
50: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

48: p_encoded => 'F');
49:
50: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
51: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
52: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
53: p_data => x_msg_data,
54: p_encoded => 'F');
55:
56: WHEN OTHERS THEN

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

55:
56: WHEN OTHERS THEN
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
58:
59: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
60: THEN
61: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
62: END IF;
63:

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

57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
58:
59: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
60: THEN
61: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
62: END IF;
63:
64: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
65: p_data => x_msg_data,

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

60: THEN
61: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
62: END IF;
63:
64: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
65: p_data => x_msg_data,
66: p_encoded => 'F');
67:
68: END Validate_Msite_Id_Exists;

Line 99: FND_MSG_PUB.Add;

95: IF (c1%NOTFOUND) THEN
96: CLOSE c1;
97: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_PARTY_NOT_FOUND');
98: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
102: CLOSE c1;
103:

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

104: EXCEPTION
105:
106: WHEN FND_API.G_EXC_ERROR THEN
107: x_return_status := FND_API.G_RET_STS_ERROR;
108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
109: p_data => x_msg_data,
110: p_encoded => 'F');
111:
112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

110: p_encoded => 'F');
111:
112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
115: p_data => x_msg_data,
116: p_encoded => 'F');
117:
118: WHEN OTHERS THEN

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

117:
118: WHEN OTHERS THEN
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120:
121: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
122: THEN
123: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
124: END IF;
125:

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

119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120:
121: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
122: THEN
123: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
124: END IF;
125:
126: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
127: p_data => x_msg_data,

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

122: THEN
123: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
124: END IF;
125:
126: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
127: p_data => x_msg_data,
128: p_encoded => 'F');
129:
130: END Validate_Prty_Id_Exists;

Line 198: FND_MSG_PUB.Add;

194: ELSE
195: -- neither msite_prty_accss_id nor combination of
196: -- msite_id and party_id is specified
197: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_MP_IDS_SPEC');
198: FND_MSG_PUB.Add;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:
202: EXCEPTION

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

202: EXCEPTION
203:
204: WHEN FND_API.G_EXC_ERROR THEN
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
207: p_data => x_msg_data,
208: p_encoded => 'F');
209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

208: p_encoded => 'F');
209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
213: p_data => x_msg_data,
214: p_encoded => 'F');
215:
216: WHEN OTHERS THEN

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

215:
216: WHEN OTHERS THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218:
219: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
220: THEN
221: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
222: END IF;
223:

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

217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218:
219: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
220: THEN
221: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
222: END IF;
223:
224: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
225: p_data => x_msg_data,

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

220: THEN
221: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
222: END IF;
223:
224: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
225: p_data => x_msg_data,
226: p_encoded => 'F');
227:
228: END Validate_Msite_Prty_Id_Exists;

Line 254: FND_MSG_PUB.initialize;

250: BEGIN
251:
252: -- Initialize message list if p_init_msg_list is set to TRUE.
253: IF FND_API.to_Boolean(p_init_msg_list) THEN
254: FND_MSG_PUB.initialize;
255: END IF;
256:
257: -- Initialize API return status to success
258: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 269: FND_MSG_PUB.Add;

265: IF ((p_msite_id IS NULL) OR
266: (p_msite_id = FND_API.G_MISS_NUM))
267: THEN
268: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_MSITE_ID');
269: FND_MSG_PUB.Add;
270: RAISE FND_API.G_EXC_ERROR;
271: END IF;
272:
273: -- p_party_id

Line 278: FND_MSG_PUB.Add;

274: IF ((p_party_id IS NULL) OR
275: (p_party_id = FND_API.G_MISS_NUM))
276: THEN
277: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVALID_PRTY_ID');
278: FND_MSG_PUB.Add;
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:
282: -- start_date_active

Line 287: FND_MSG_PUB.Add;

283: IF ((p_start_date_active IS NULL) OR
284: (p_start_date_active = FND_API.G_MISS_DATE))
285: THEN
286: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
287: FND_MSG_PUB.Add;
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290:
291: --

Line 311: FND_MSG_PUB.Add;

307:
308: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
309: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_VLD_FAIL');
310: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
311: FND_MSG_PUB.Add;
312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
313: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
314: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_ID_VLD_FAIL');
315: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

Line 331: FND_MSG_PUB.Add;

327:
328: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
329: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_PRTY_ID_VLD_FAIL');
330: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
331: FND_MSG_PUB.Add;
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
334: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_PRTY_ID_VLD_FAIL');
335: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);

Line 354: FND_MSG_PUB.Add;

350: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
353: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSPRT_ID_VLD_FAIL');
354: FND_MSG_PUB.Add;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- duplicate exists
357: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSPRT_ID_DUP_EXISTS');
358: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

Line 360: FND_MSG_PUB.Add;

356: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- duplicate exists
357: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSPRT_ID_DUP_EXISTS');
358: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
359: FND_MESSAGE.Set_Token('PARTY_ID', p_party_id);
360: FND_MSG_PUB.Add;
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;
363:
364: EXCEPTION

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

364: EXCEPTION
365:
366: WHEN FND_API.G_EXC_ERROR THEN
367: x_return_status := FND_API.G_RET_STS_ERROR;
368: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
369: p_data => x_msg_data,
370: p_encoded => 'F');
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

370: p_encoded => 'F');
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
375: p_data => x_msg_data,
376: p_encoded => 'F');
377:
378: WHEN OTHERS THEN

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

377:
378: WHEN OTHERS THEN
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380:
381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
382: THEN
383: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
384: END IF;
385:

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

379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380:
381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
382: THEN
383: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
384: END IF;
385:
386: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
387: p_data => x_msg_data,

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

382: THEN
383: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
384: END IF;
385:
386: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
387: p_data => x_msg_data,
388: p_encoded => 'F');
389:
390: END Validate_Create;

Line 416: FND_MSG_PUB.initialize;

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

Line 429: FND_MSG_PUB.Add;

425:
426: -- msite_prty_accss_id
427: IF (p_msite_prty_accss_id IS NULL) THEN
428: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSPRT_ID_IS_NULL');
429: FND_MSG_PUB.Add;
430: RAISE FND_API.G_EXC_ERROR;
431: END IF;
432:
433: -- object_version_number

Line 437: FND_MSG_PUB.Add;

433: -- object_version_number
434: IF (p_object_version_number IS NULL)
435: THEN
436: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_OVN_IS_NULL');
437: FND_MSG_PUB.Add;
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440:
441: -- start_date_active

Line 444: FND_MSG_PUB.Add;

440:
441: -- start_date_active
442: IF (p_start_date_active IS NULL) THEN
443: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
444: FND_MSG_PUB.Add;
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447:
448: --

Line 465: FND_MSG_PUB.Add;

461: );
462:
463: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
464: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSPRT_ID_VLD_FAIL');
465: FND_MSG_PUB.Add;
466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
467: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
468: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSPRT_ID_VLD_FAIL');
469: FND_MSG_PUB.Add;

Line 469: FND_MSG_PUB.Add;

465: FND_MSG_PUB.Add;
466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
467: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
468: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSPRT_ID_VLD_FAIL');
469: FND_MSG_PUB.Add;
470: RAISE FND_API.G_EXC_ERROR;
471: END IF;
472:
473:

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

474: EXCEPTION
475:
476: WHEN FND_API.G_EXC_ERROR THEN
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
479: p_data => x_msg_data,
480: p_encoded => 'F');
481:
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

480: p_encoded => 'F');
481:
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
485: p_data => x_msg_data,
486: p_encoded => 'F');
487:
488: WHEN OTHERS THEN

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

487:
488: WHEN OTHERS THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490:
491: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
492: THEN
493: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
494: END IF;
495:

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

489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490:
491: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
492: THEN
493: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
494: END IF;
495:
496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
497: p_data => x_msg_data,

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

492: THEN
493: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
494: END IF;
495:
496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
497: p_data => x_msg_data,
498: p_encoded => 'F');
499:
500: END Validate_Update;

Line 541: FND_MSG_PUB.initialize;

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

Line 571: FND_MSG_PUB.Add;

567: );
568:
569: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
570: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MP_INVALID_CREATE');
571: FND_MSG_PUB.Add;
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
574: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MP_INVALID_CREATE');
575: FND_MSG_PUB.Add;

Line 575: FND_MSG_PUB.Add;

571: FND_MSG_PUB.Add;
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
574: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MP_INVALID_CREATE');
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR; -- invalid
577: END IF;
578:
579: --

Line 604: FND_MSG_PUB.Add;

600:
601: EXCEPTION
602: WHEN NO_DATA_FOUND THEN
603: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_PRTY_INSERT_FL');
604: FND_MSG_PUB.Add;
605: RAISE FND_API.G_EXC_ERROR;
606: WHEN OTHERS THEN
607: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_PRTY_INSERT_FL');
608: FND_MSG_PUB.Add;

Line 608: FND_MSG_PUB.Add;

604: FND_MSG_PUB.Add;
605: RAISE FND_API.G_EXC_ERROR;
606: WHEN OTHERS THEN
607: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_PRTY_INSERT_FL');
608: FND_MSG_PUB.Add;
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END;
611:
612: --

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

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

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

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

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

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

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

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

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

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

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

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

Line 699: FND_MSG_PUB.initialize;

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

Line 740: FND_MSG_PUB.Add;

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

Line 762: FND_MSG_PUB.Add;

758: );
759:
760: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
761: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MP_INVALID_UPDATE');
762: FND_MSG_PUB.Add;
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
765: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MP_INVALID_UPDATE');
766: FND_MSG_PUB.Add;

Line 766: FND_MSG_PUB.Add;

762: FND_MSG_PUB.Add;
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
765: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MP_INVALID_UPDATE');
766: FND_MSG_PUB.Add;
767: RAISE FND_API.G_EXC_ERROR; -- invalid
768: END IF;
769:
770: -- 2. update row with section data into section table

Line 787: FND_MSG_PUB.ADD;

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

Line 791: FND_MSG_PUB.ADD;

787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_ERROR;
789: WHEN OTHERS THEN
790: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_PRTY_UPDATE_FL');
791: FND_MSG_PUB.ADD;
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END;
794:
795: --

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

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

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

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

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

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

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

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

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

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

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

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

Line 879: FND_MSG_PUB.initialize;

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

Line 917: FND_MSG_PUB.Add;

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

Line 927: FND_MSG_PUB.Add;

923: Jtf_Msite_Prty_Accss_Pkg.delete_row(l_msite_prty_accss_id);
924: EXCEPTION
925: WHEN NO_DATA_FOUND THEN
926: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_PRTY_DELETE_FL');
927: FND_MSG_PUB.Add;
928: RAISE FND_API.G_EXC_ERROR;
929: WHEN OTHERS THEN
930: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_PRTY_DELETE_FL');
931: FND_MSG_PUB.Add;

Line 931: FND_MSG_PUB.Add;

927: FND_MSG_PUB.Add;
928: RAISE FND_API.G_EXC_ERROR;
929: WHEN OTHERS THEN
930: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_PRTY_DELETE_FL');
931: FND_MSG_PUB.Add;
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END;
934:
935: EXCEPTION

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

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

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

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

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

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

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

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

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

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