DBA Data[Home] [Help]

APPS.IEX_FILTER_PUB dependencies on FND_MSG_PUB

Line 153: FND_MSG_PUB.initialize;

149: L_API_NAME := 'Validate_Filter';
150: l_filter_rec := p_filter_rec;
151: IF FND_API.to_Boolean( p_init_msg_list )
152: THEN
153: FND_MSG_PUB.initialize;
154: END IF;
155:
156: -- Initialize API return status to SUCCESS
157: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 285: FND_MSG_PUB.Count_And_Get

281:
282:
283: x_return_status := l_return_status;
284: -- Standard call to get message count and IF count is 1, get message info.
285: FND_MSG_PUB.Count_And_Get
286: ( p_count => x_msg_count,
287: p_data => x_msg_data
288: );
289:

Line 295: FND_MSG_PUB.Count_And_Get

291: WHEN FND_API.G_EXC_ERROR THEN
292: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:EXC ERROR');
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
295: FND_MSG_PUB.Count_And_Get
296: ( p_count => x_msg_count,
297: p_data => x_msg_data
298: );
299:

Line 304: FND_MSG_PUB.Count_And_Get

300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:UNEXC ERROR');
303: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
304: FND_MSG_PUB.Count_And_Get
305: ( p_count => x_msg_count,
306: p_data => x_msg_data
307: );
308:

Line 313: FND_MSG_PUB.Count_And_Get

309: WHEN OTHERS THEN
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:OTHERS ERROR');
312: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
313: FND_MSG_PUB.Count_And_Get
314: ( p_count => x_msg_count,
315: p_data => x_msg_data
316: );
317:

Line 361: FND_MSG_PUB.initialize;

357:
358: -- Initialize message list IF p_init_msg_list is set to TRUE.
359: IF FND_API.to_Boolean( p_init_msg_list )
360: THEN
361: FND_MSG_PUB.initialize;
362: END IF;
363:
364: -- Debug Message
365: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:Start');

Line 426: FND_MSG_PUB.Count_And_Get

422: -- Debug Message
423: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:end');
424:
425: -- Standard call to get message count and IF count is 1, get message info.
426: FND_MSG_PUB.Count_And_Get
427: ( p_count => x_msg_count,
428: p_data => x_msg_data
429: );
430:

Line 438: FND_MSG_PUB.Count_And_Get

434: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:EXC ERROR');
437: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
438: FND_MSG_PUB.Count_And_Get
439: ( p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442:

Line 448: FND_MSG_PUB.Count_And_Get

444: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:UNEXC ERROR');
447: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
448: FND_MSG_PUB.Count_And_Get
449: ( p_count => x_msg_count,
450: p_data => x_msg_data
451: );
452:

Line 458: FND_MSG_PUB.Count_And_Get

454: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:OTHER ERROR');
457: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
458: FND_MSG_PUB.Count_And_Get
459: ( p_count => x_msg_count,
460: p_data => x_msg_data
461: );
462:

Line 529: FND_MSG_PUB.initialize;

525:
526: -- Initialize message list IF p_init_msg_list is set to TRUE.
527: IF FND_API.to_Boolean( p_init_msg_list )
528: THEN
529: FND_MSG_PUB.initialize;
530: END IF;
531:
532: -- Debug Message
533: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:start');

Line 545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

541: Open C_chk_filter_name(l_FILTER_REC.OBJECT_FILTER_ID,
542: l_FILTER_REC.OBJECT_FILTER_NAME);
543: Fetch C_chk_filter_name into l_NAME_CNT;
544: if (l_name_cnt > 0) then
545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
546: THEN
547: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
548: FND_MESSAGE.Set_Token ('COLUMN', 'OBJECT_FILTER_NAME', FALSE);
549: FND_MESSAGE.Set_Token ('VALUE', l_Filter_rec.object_filter_name, FALSE);

Line 550: FND_MSG_PUB.Add;

546: THEN
547: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
548: FND_MESSAGE.Set_Token ('COLUMN', 'OBJECT_FILTER_NAME', FALSE);
549: FND_MESSAGE.Set_Token ('VALUE', l_Filter_rec.object_filter_name, FALSE);
550: FND_MSG_PUB.Add;
551: END IF;
552: x_dup_status := IEX_SCORE_PVT.IEX_DUPLICATE_NAME;
553: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:dup object_filter_name');
554: RAISE FND_API.G_EXC_ERROR;

Line 579: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

575: ,l_filter_ref_rec.LAST_UPDATED_BY
576: ,l_filter_ref_rec.LAST_UPDATE_LOGIN;
577:
578: IF (C_get_filter_Rec%NOTFOUND) THEN
579: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
580: THEN
581: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
582: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
583: FND_MSG_PUB.Add;

Line 583: FND_MSG_PUB.Add;

579: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
580: THEN
581: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
582: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
583: FND_MSG_PUB.Add;
584: END IF;
585: RAISE FND_API.G_EXC_ERROR;
586: END IF;
587:

Line 594: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

590:
591: IF (l_filter_ref_rec.last_update_date is NULL or
592: l_filter_ref_rec.last_update_date = FND_API.G_MISS_Date)
593: THEN
594: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
595: THEN
596: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
597: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
598: FND_MSG_PUB.ADD;

Line 598: FND_MSG_PUB.ADD;

594: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
595: THEN
596: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
597: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
598: FND_MSG_PUB.ADD;
599: END IF;
600: RAISE FND_API.G_EXC_ERROR;
601: End IF;
602:

Line 667: FND_MSG_PUB.Count_And_Get

663: -- Debug Message
664: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:end');
665:
666: -- Standard call to get message count and IF count is 1, get message info.
667: FND_MSG_PUB.Count_And_Get
668: ( p_count => x_msg_count,
669: p_data => x_msg_data
670: );
671:

Line 679: FND_MSG_PUB.Count_And_Get

675: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:EXC ERROR');
678: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
679: FND_MSG_PUB.Count_And_Get
680: ( p_count => x_msg_count,
681: p_data => x_msg_data
682: );
683:

Line 689: FND_MSG_PUB.Count_And_Get

685: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:UNEXC ERROR');
688: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
689: FND_MSG_PUB.Count_And_Get
690: ( p_count => x_msg_count,
691: p_data => x_msg_data
692: );
693:

Line 699: FND_MSG_PUB.Count_And_Get

695: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:OTHER ERROR');
698: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
699: FND_MSG_PUB.Count_And_Get
700: ( p_count => x_msg_count,
701: p_data => x_msg_data
702: );
703:

Line 745: FND_MSG_PUB.initialize;

741:
742: -- Initialize message list IF p_init_msg_list is set to TRUE.
743: IF FND_API.to_Boolean( p_init_msg_list )
744: THEN
745: FND_MSG_PUB.initialize;
746: END IF;
747:
748: -- Debug Message
749: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:Start');

Line 763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

759: Fetch C_GET_FILTER into
760: l_rowid;
761:
762: IF ( C_GET_FILTER%NOTFOUND) THEN
763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
764: THEN
765: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
766: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
767: FND_MSG_PUB.Add;

Line 767: FND_MSG_PUB.Add;

763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
764: THEN
765: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
766: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
767: FND_MSG_PUB.Add;
768: END IF;
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771:

Line 795: FND_MSG_PUB.Count_And_Get

791: -- Debug Message
792: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:End');
793:
794: -- Standard call to get message count and IF count is 1, get message info.
795: FND_MSG_PUB.Count_And_Get
796: ( p_count => x_msg_count,
797: p_data => x_msg_data
798: );
799:

Line 807: FND_MSG_PUB.Count_And_Get

803: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
804: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:EXP ERROR');
805: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
806: x_return_status := FND_API.G_RET_STS_ERROR;
807: FND_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count,
809: p_data => x_msg_data
810: );
811:

Line 817: FND_MSG_PUB.Count_And_Get

813: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:UNEXP ERROR');
816: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
817: FND_MSG_PUB.Count_And_Get
818: ( p_count => x_msg_count,
819: p_data => x_msg_data
820: );
821:

Line 827: FND_MSG_PUB.Count_And_Get

823: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:OTHER ERROR');
826: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
827: FND_MSG_PUB.Count_And_Get
828: ( p_count => x_msg_count,
829: p_data => x_msg_data
830: );
831: