DBA Data[Home] [Help]

APPS.IEX_FILTER_PUB dependencies on FND_MSG_PUB

Line 231: FND_MSG_PUB.initialize;

227: L_API_NAME := 'Validate_Filter';
228: l_filter_rec := p_filter_rec;
229: IF FND_API.to_Boolean( p_init_msg_list )
230: THEN
231: FND_MSG_PUB.initialize;
232: END IF;
233:
234: -- Initialize API return status to SUCCESS
235: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 363: FND_MSG_PUB.Count_And_Get

359:
360:
361: x_return_status := l_return_status;
362: -- Standard call to get message count and IF count is 1, get message info.
363: FND_MSG_PUB.Count_And_Get
364: ( p_count => x_msg_count,
365: p_data => x_msg_data
366: );
367:

Line 373: FND_MSG_PUB.Count_And_Get

369: WHEN FND_API.G_EXC_ERROR THEN
370: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:EXC ERROR');
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
373: FND_MSG_PUB.Count_And_Get
374: ( p_count => x_msg_count,
375: p_data => x_msg_data
376: );
377:

Line 382: FND_MSG_PUB.Count_And_Get

378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:UNEXC ERROR');
381: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
382: FND_MSG_PUB.Count_And_Get
383: ( p_count => x_msg_count,
384: p_data => x_msg_data
385: );
386:

Line 391: FND_MSG_PUB.Count_And_Get

387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:OTHERS ERROR');
390: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
391: FND_MSG_PUB.Count_And_Get
392: ( p_count => x_msg_count,
393: p_data => x_msg_data
394: );
395:

Line 439: FND_MSG_PUB.initialize;

435:
436: -- Initialize message list IF p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean( p_init_msg_list )
438: THEN
439: FND_MSG_PUB.initialize;
440: END IF;
441:
442: -- Debug Message
443: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:Start');

Line 504: FND_MSG_PUB.Count_And_Get

500: -- Debug Message
501: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:end');
502:
503: -- Standard call to get message count and IF count is 1, get message info.
504: FND_MSG_PUB.Count_And_Get
505: ( p_count => x_msg_count,
506: p_data => x_msg_data
507: );
508:

Line 516: FND_MSG_PUB.Count_And_Get

512: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:EXC ERROR');
515: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
516: FND_MSG_PUB.Count_And_Get
517: ( p_count => x_msg_count,
518: p_data => x_msg_data
519: );
520:

Line 526: FND_MSG_PUB.Count_And_Get

522: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:UNEXC ERROR');
525: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
526: FND_MSG_PUB.Count_And_Get
527: ( p_count => x_msg_count,
528: p_data => x_msg_data
529: );
530:

Line 536: FND_MSG_PUB.Count_And_Get

532: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
534: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:OTHER ERROR');
535: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
536: FND_MSG_PUB.Count_And_Get
537: ( p_count => x_msg_count,
538: p_data => x_msg_data
539: );
540:

Line 607: FND_MSG_PUB.initialize;

603:
604: -- Initialize message list IF p_init_msg_list is set to TRUE.
605: IF FND_API.to_Boolean( p_init_msg_list )
606: THEN
607: FND_MSG_PUB.initialize;
608: END IF;
609:
610: -- Debug Message
611: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:start');

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

619: Open C_chk_filter_name(l_FILTER_REC.OBJECT_FILTER_ID,
620: l_FILTER_REC.OBJECT_FILTER_NAME);
621: Fetch C_chk_filter_name into l_NAME_CNT;
622: if (l_name_cnt > 0) then
623: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
624: THEN
625: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
626: FND_MESSAGE.Set_Token ('COLUMN', 'OBJECT_FILTER_NAME', FALSE);
627: FND_MESSAGE.Set_Token ('VALUE', l_Filter_rec.object_filter_name, FALSE);

Line 628: FND_MSG_PUB.Add;

624: THEN
625: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
626: FND_MESSAGE.Set_Token ('COLUMN', 'OBJECT_FILTER_NAME', FALSE);
627: FND_MESSAGE.Set_Token ('VALUE', l_Filter_rec.object_filter_name, FALSE);
628: FND_MSG_PUB.Add;
629: END IF;
630: x_dup_status := IEX_SCORE_PVT.IEX_DUPLICATE_NAME;
631: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:dup object_filter_name');
632: RAISE FND_API.G_EXC_ERROR;

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

653: ,l_filter_ref_rec.LAST_UPDATED_BY
654: ,l_filter_ref_rec.LAST_UPDATE_LOGIN;
655:
656: IF (C_get_filter_Rec%NOTFOUND) THEN
657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
658: THEN
659: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
660: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
661: FND_MSG_PUB.Add;

Line 661: FND_MSG_PUB.Add;

657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
658: THEN
659: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
660: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
661: FND_MSG_PUB.Add;
662: END IF;
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665:

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

668:
669: IF (l_filter_ref_rec.last_update_date is NULL or
670: l_filter_ref_rec.last_update_date = FND_API.G_MISS_Date)
671: THEN
672: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
673: THEN
674: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
675: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
676: FND_MSG_PUB.ADD;

Line 676: FND_MSG_PUB.ADD;

672: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
673: THEN
674: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
675: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
676: FND_MSG_PUB.ADD;
677: END IF;
678: RAISE FND_API.G_EXC_ERROR;
679: End IF;
680:

Line 745: FND_MSG_PUB.Count_And_Get

741: -- Debug Message
742: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:end');
743:
744: -- Standard call to get message count and IF count is 1, get message info.
745: FND_MSG_PUB.Count_And_Get
746: ( p_count => x_msg_count,
747: p_data => x_msg_data
748: );
749:

Line 757: FND_MSG_PUB.Count_And_Get

753: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:EXC ERROR');
756: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
757: FND_MSG_PUB.Count_And_Get
758: ( p_count => x_msg_count,
759: p_data => x_msg_data
760: );
761:

Line 767: FND_MSG_PUB.Count_And_Get

763: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:UNEXC ERROR');
766: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
767: FND_MSG_PUB.Count_And_Get
768: ( p_count => x_msg_count,
769: p_data => x_msg_data
770: );
771:

Line 777: FND_MSG_PUB.Count_And_Get

773: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:OTHER ERROR');
776: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
777: FND_MSG_PUB.Count_And_Get
778: ( p_count => x_msg_count,
779: p_data => x_msg_data
780: );
781:

Line 823: FND_MSG_PUB.initialize;

819:
820: -- Initialize message list IF p_init_msg_list is set to TRUE.
821: IF FND_API.to_Boolean( p_init_msg_list )
822: THEN
823: FND_MSG_PUB.initialize;
824: END IF;
825:
826: -- Debug Message
827: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:Start');

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

837: Fetch C_GET_FILTER into
838: l_rowid;
839:
840: IF ( C_GET_FILTER%NOTFOUND) THEN
841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
842: THEN
843: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
844: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
845: FND_MSG_PUB.Add;

Line 845: FND_MSG_PUB.Add;

841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
842: THEN
843: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
844: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
845: FND_MSG_PUB.Add;
846: END IF;
847: RAISE FND_API.G_EXC_ERROR;
848: END IF;
849:

Line 873: FND_MSG_PUB.Count_And_Get

869: -- Debug Message
870: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:End');
871:
872: -- Standard call to get message count and IF count is 1, get message info.
873: FND_MSG_PUB.Count_And_Get
874: ( p_count => x_msg_count,
875: p_data => x_msg_data
876: );
877:

Line 885: FND_MSG_PUB.Count_And_Get

881: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
882: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:EXP ERROR');
883: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: FND_MSG_PUB.Count_And_Get
886: ( p_count => x_msg_count,
887: p_data => x_msg_data
888: );
889:

Line 895: FND_MSG_PUB.Count_And_Get

891: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
893: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:UNEXP ERROR');
894: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
895: FND_MSG_PUB.Count_And_Get
896: ( p_count => x_msg_count,
897: p_data => x_msg_data
898: );
899:

Line 905: FND_MSG_PUB.Count_And_Get

901: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:OTHER ERROR');
904: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
905: FND_MSG_PUB.Count_And_Get
906: ( p_count => x_msg_count,
907: p_data => x_msg_data
908: );
909: