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

Line 229: FND_MSG_PUB.initialize;

225: BEGIN
226:
227: -- Initialize message list if p_init_msg_list is set to TRUE.
228: IF FND_API.to_Boolean(p_init_msg_list) THEN
229: FND_MSG_PUB.initialize;
230: END IF;
231:
232: -- Initialize API return status to error, i.e, its not duplicate
233: x_return_status := FND_API.G_RET_STS_ERROR;

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

260: EXCEPTION
261:
262: WHEN FND_API.G_EXC_ERROR THEN
263: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
264: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
265: p_data => x_msg_data,
266: p_encoded => 'F');
267:
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

266: p_encoded => 'F');
267:
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
271: p_data => x_msg_data,
272: p_encoded => 'F');
273:
274: WHEN OTHERS THEN

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

273:
274: WHEN OTHERS THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276:
277: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
278: THEN
279: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
280: END IF;
281:

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

275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276:
277: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
278: THEN
279: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
280: END IF;
281:
282: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
283: p_data => x_msg_data,

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

278: THEN
279: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
280: END IF;
281:
282: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
283: p_data => x_msg_data,
284: p_encoded => 'F');
285:
286: END Check_Duplicate_Entry;

Line 321: FND_MSG_PUB.initialize;

317: BEGIN
318:
319: -- Initialize message list if p_init_msg_list is set to TRUE.
320: IF FND_API.to_Boolean(p_init_msg_list) THEN
321: FND_MSG_PUB.initialize;
322: END IF;
323:
324: -- Initialize API return status to success
325: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 336: FND_MSG_PUB.Add;

332: IF ((p_mini_site_id IS NULL) OR
333: (p_mini_site_id = FND_API.G_MISS_NUM))
334: THEN
335: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_MSITE_ID');
336: FND_MSG_PUB.Add;
337: RAISE FND_API.G_EXC_ERROR;
338: END IF;
339:
340: -- section item id

Line 345: FND_MSG_PUB.Add;

341: IF ((p_section_item_id IS NULL) OR
342: (p_section_item_id = FND_API.G_MISS_NUM))
343: THEN
344: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SI_ID');
345: FND_MSG_PUB.Add;
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;
348:
349: -- start_date_active

Line 354: FND_MSG_PUB.Add;

350: IF ((p_start_date_active IS NULL) OR
351: (p_start_date_active = FND_API.G_MISS_DATE))
352: THEN
353: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
354: FND_MSG_PUB.Add;
355: RAISE FND_API.G_EXC_ERROR;
356: END IF;
357:
358: --

Line 371: FND_MSG_PUB.Add;

367: EXCEPTION
368: WHEN NO_DATA_FOUND THEN
369: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_MSITE_ID');
370: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
371: FND_MSG_PUB.Add;
372: RAISE FND_API.G_EXC_ERROR;
373: WHEN OTHERS THEN
374: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');
375: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

Line 376: FND_MSG_PUB.Add;

372: RAISE FND_API.G_EXC_ERROR;
373: WHEN OTHERS THEN
374: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');
375: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
376: FND_MSG_PUB.Add;
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END;
379:
380: -- section item id

Line 389: FND_MSG_PUB.Add;

385: EXCEPTION
386: WHEN NO_DATA_FOUND THEN
387: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SI_ID');
388: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
389: FND_MSG_PUB.Add;
390: RAISE FND_API.G_EXC_ERROR;
391: WHEN OTHERS THEN
392: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SI_ID');
393: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);

Line 394: FND_MSG_PUB.Add;

390: RAISE FND_API.G_EXC_ERROR;
391: WHEN OTHERS THEN
392: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SI_ID');
393: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
394: FND_MSG_PUB.Add;
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END;
397:
398: -- Validate if the entry is duplicate

Line 410: FND_MSG_PUB.Add;

406: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
408: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
409: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
410: FND_MSG_PUB.Add;
411: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
412: END IF;
413:
414: EXCEPTION

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

414: EXCEPTION
415:
416: WHEN FND_API.G_EXC_ERROR THEN
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
419: p_data => x_msg_data,
420: p_encoded => 'F');
421:
422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

420: p_encoded => 'F');
421:
422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
425: p_data => x_msg_data,
426: p_encoded => 'F');
427:
428: WHEN OTHERS THEN

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

427:
428: WHEN OTHERS THEN
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
430:
431: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
432: THEN
433: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
434: END IF;
435:

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

429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
430:
431: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
432: THEN
433: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
434: END IF;
435:
436: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
437: p_data => x_msg_data,

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

432: THEN
433: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
434: END IF;
435:
436: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
437: p_data => x_msg_data,
438: p_encoded => 'F');
439:
440: END Validate_Create;

Line 476: FND_MSG_PUB.initialize;

472: BEGIN
473:
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean(p_init_msg_list) THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478:
479: -- Initialize API return status to success
480: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 489: FND_MSG_PUB.Add;

485:
486: -- mini_site_section_item_id
487: IF (p_mini_site_section_item_id IS NULL) THEN
488: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NULL_PRIMARY_KEY');
489: FND_MSG_PUB.Add;
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492:
493: -- start_date_active

Line 496: FND_MSG_PUB.Add;

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

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

501: EXCEPTION
502:
503: WHEN FND_API.G_EXC_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
506: p_data => x_msg_data,
507: p_encoded => 'F');
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

507: p_encoded => 'F');
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
512: p_data => x_msg_data,
513: p_encoded => 'F');
514:
515: WHEN OTHERS THEN

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

514:
515: WHEN OTHERS THEN
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517:
518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
521: END IF;
522:

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

516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517:
518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
521: END IF;
522:
523: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
524: p_data => x_msg_data,

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

519: THEN
520: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
521: END IF;
522:
523: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
524: p_data => x_msg_data,
525: p_encoded => 'F');
526:
527: END Validate_Update;

Line 575: FND_MSG_PUB.initialize;

571: END IF;
572:
573: -- Initialize message list if p_init_msg_list is set to TRUE.
574: IF FND_API.to_Boolean(p_init_msg_list) THEN
575: FND_MSG_PUB.initialize;
576: END IF;
577:
578: -- Initialize API return status to success
579: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 607: FND_MSG_PUB.Add;

603: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
606: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INVALID_CREATE');
607: FND_MSG_PUB.Add;
608: RAISE FND_API.G_EXC_ERROR; -- invalid
609: END IF;
610:
611: --

Line 634: FND_MSG_PUB.Add;

630: );
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
633: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INSERT_FAIL');
634: FND_MSG_PUB.Add;
635: RAISE FND_API.G_EXC_ERROR;
636: WHEN OTHERS THEN
637: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INSERT_FAIL');
638: FND_MSG_PUB.Add;

Line 638: FND_MSG_PUB.Add;

634: FND_MSG_PUB.Add;
635: RAISE FND_API.G_EXC_ERROR;
636: WHEN OTHERS THEN
637: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INSERT_FAIL');
638: FND_MSG_PUB.Add;
639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
640: END;
641:
642: --

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

647: COMMIT WORK;
648: END IF;
649:
650: -- Standard call to get message count and if count is 1, get message info.
651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
652: p_data => x_msg_data,
653: p_encoded => 'F');
654:
655: EXCEPTION

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

656:
657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO CREATE_MSITE_SCT_ITEM_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
661: p_data => x_msg_data,
662: p_encoded => 'F');
663:
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 670: FND_MSG_PUB.Add;

666: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
667: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || 'xxx');
668: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
669: FND_MESSAGE.Set_Token('REASON', p_mini_site_id || ':' || p_section_item_id);
670: FND_MSG_PUB.Add;
671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
674: p_data => x_msg_data,

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

669: FND_MESSAGE.Set_Token('REASON', p_mini_site_id || ':' || p_section_item_id);
670: FND_MSG_PUB.Add;
671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
674: p_data => x_msg_data,
675: p_encoded => 'F');
676:
677: WHEN OTHERS THEN

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

677: WHEN OTHERS THEN
678: ROLLBACK TO CREATE_MSITE_SCT_ITEM_PVT;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680:
681: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
682: THEN
683: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
684: END IF;
685:

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

679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680:
681: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
682: THEN
683: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
684: END IF;
685:
686: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
687: p_data => x_msg_data,

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

682: THEN
683: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
684: END IF;
685:
686: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
687: p_data => x_msg_data,
688: p_encoded => 'F');
689:
690: END Create_MSite_Section_Item;

Line 733: FND_MSG_PUB.initialize;

729: END IF;
730:
731: -- Initialize message list if p_init_msg_list is set to TRUE.
732: IF FND_API.to_Boolean(p_init_msg_list) THEN
733: FND_MSG_PUB.initialize;
734: END IF;
735:
736: -- Initialize API return status to success
737: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 772: FND_MSG_PUB.Add;

768: WHEN NO_DATA_FOUND THEN
769: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
770: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
771: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
772: FND_MSG_PUB.Add;
773: RAISE FND_API.G_EXC_ERROR;
774: WHEN OTHERS THEN
775: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
776: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

Line 778: FND_MSG_PUB.Add;

774: WHEN OTHERS THEN
775: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
776: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
777: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
778: FND_MSG_PUB.Add;
779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
780: END;
781: ELSE
782: -- neither mini_site_section_item_id nor combination of

Line 785: FND_MSG_PUB.Add;

781: ELSE
782: -- neither mini_site_section_item_id nor combination of
783: -- mini_site_id and section_item_id is specified
784: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_IDS_SPEC');
785: FND_MSG_PUB.Add;
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788:
789: --

Line 809: FND_MSG_PUB.Add;

805: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
808: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INVALID_UPDATE');
809: FND_MSG_PUB.Add;
810: RAISE FND_API.G_EXC_ERROR; -- invalid
811: END IF;
812:
813: -- 2. update row

Line 828: FND_MSG_PUB.Add;

824: );
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN
827: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_UPDATE_FAIL');
828: FND_MSG_PUB.Add;
829: RAISE FND_API.G_EXC_ERROR;
830: WHEN OTHERS THEN
831: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_UPDATE_FAIL');
832: FND_MSG_PUB.Add;

Line 832: FND_MSG_PUB.Add;

828: FND_MSG_PUB.Add;
829: RAISE FND_API.G_EXC_ERROR;
830: WHEN OTHERS THEN
831: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_UPDATE_FAIL');
832: FND_MSG_PUB.Add;
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END;
835:
836: --

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

841: COMMIT WORK;
842: END IF;
843:
844: -- Standard call to get message count and if count is 1, get message info.
845: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
846: p_data => x_msg_data,
847: p_encoded => 'F');
848:
849: EXCEPTION

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

850:
851: WHEN FND_API.G_EXC_ERROR THEN
852: ROLLBACK TO UPDATE_MSITE_SCT_ITEM_PVT;
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
855: p_data => x_msg_data,
856: p_encoded => 'F');
857:
858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

857:
858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
859: ROLLBACK TO UPDATE_MSITE_SCT_ITEM_PVT;
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
862: p_data => x_msg_data,
863: p_encoded => 'F');
864:
865: WHEN OTHERS THEN

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

865: WHEN OTHERS THEN
866: ROLLBACK TO UPDATE_MSITE_SCT_ITEM_PVT;
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
868:
869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
870: THEN
871: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
872: END IF;
873:

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

867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
868:
869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
870: THEN
871: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
872: END IF;
873:
874: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
875: p_data => x_msg_data,

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

870: THEN
871: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
872: END IF;
873:
874: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
875: p_data => x_msg_data,
876: p_encoded => 'F');
877:
878: END Update_MSite_Section_Item;

Line 918: FND_MSG_PUB.initialize;

914: END IF;
915:
916: -- Initialize message list if p_init_msg_list is set to TRUE.
917: IF FND_API.to_Boolean(p_init_msg_list) THEN
918: FND_MSG_PUB.initialize;
919: END IF;
920:
921: -- Initialize API return status to success
922: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 954: FND_MSG_PUB.Add;

950: WHEN NO_DATA_FOUND THEN
951: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
952: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
953: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
954: FND_MSG_PUB.Add;
955: RAISE FND_API.G_EXC_ERROR;
956: WHEN OTHERS THEN
957: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
958: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

Line 960: FND_MSG_PUB.Add;

956: WHEN OTHERS THEN
957: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
958: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
959: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
960: FND_MSG_PUB.Add;
961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
962: END;
963:
964: ELSE

Line 968: FND_MSG_PUB.Add;

964: ELSE
965: -- neither mini_site_section_item_id nor combination of
966: -- mini_site_id and section_item_id is specified
967: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_IDS_SPEC');
968: FND_MSG_PUB.Add;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:
972: -- delete row

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

978: IF (p_call_from_trigger = FALSE) THEN
979: ROLLBACK TO DELETE_MSITE_SCT_ITEM_PVT;
980: END IF;
981: x_return_status := FND_API.G_RET_STS_ERROR;
982: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
983: p_data => x_msg_data,
984: p_encoded => 'F');
985:
986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

987: IF (p_call_from_trigger = FALSE) THEN
988: ROLLBACK TO DELETE_MSITE_SCT_ITEM_PVT;
989: END IF;
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
992: p_data => x_msg_data,
993: p_encoded => 'F');
994:
995: WHEN OTHERS THEN

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

997: ROLLBACK TO DELETE_MSITE_SCT_ITEM_PVT;
998: END IF;
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1000:
1001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1002: THEN
1003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1004: END IF;
1005:

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

999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1000:
1001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1002: THEN
1003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1004: END IF;
1005:
1006: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1007: p_data => x_msg_data,

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

1002: THEN
1003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1004: END IF;
1005:
1006: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1007: p_data => x_msg_data,
1008: p_encoded => 'F');
1009:
1010: END Delete_MSite_Section_Item;