129: IS
130: l_Message Varchar2(2000);
131:
132: BEGIN
133: FND_MESSAGE.Set_Name(pOwner,pName);
134: l_Message := FND_MESSAGE.get;
135: Return l_Message;
136: END getMessage;
137:
130: l_Message Varchar2(2000);
131:
132: BEGIN
133: FND_MESSAGE.Set_Name(pOwner,pName);
134: l_Message := FND_MESSAGE.get;
135: Return l_Message;
136: END getMessage;
137:
138: FUNCTION getMessage(pOwner IN Varchar2,pName IN Varchar2,ptokenValue IN Varchar2) Return Varchar2
141:
142: l_Message Varchar2(2000);
143:
144: BEGIN
145: FND_MESSAGE.Set_Name(pOwner,pName);
146: FND_MESSAGE.Set_Token('NAME',ptokenValue);
147: l_Message := FND_MESSAGE.get;
148: Return l_Message;
149: END getMessage;
142: l_Message Varchar2(2000);
143:
144: BEGIN
145: FND_MESSAGE.Set_Name(pOwner,pName);
146: FND_MESSAGE.Set_Token('NAME',ptokenValue);
147: l_Message := FND_MESSAGE.get;
148: Return l_Message;
149: END getMessage;
150:
143:
144: BEGIN
145: FND_MESSAGE.Set_Name(pOwner,pName);
146: FND_MESSAGE.Set_Token('NAME',ptokenValue);
147: l_Message := FND_MESSAGE.get;
148: Return l_Message;
149: END getMessage;
150:
151:
610: End If;
611:
612:
613: If (pStartDate is null and pEndDate is null) Then
614: FND_MESSAGE.Set_Name('IBE','IBE_ECR_CALENDER_ERROR');
615: FND_MESSAGE.Set_Token('NAME',InitCap(pFrequency));
616: FND_MESSAGE.Set_Token('PERIODSETNAME',nvl(pPeriodSetName,'???'));
617: FND_MESSAGE.Set_Token('DATE',to_char(pdate));
618: Raise_application_error(-20201, FND_MESSAGE.get);
611:
612:
613: If (pStartDate is null and pEndDate is null) Then
614: FND_MESSAGE.Set_Name('IBE','IBE_ECR_CALENDER_ERROR');
615: FND_MESSAGE.Set_Token('NAME',InitCap(pFrequency));
616: FND_MESSAGE.Set_Token('PERIODSETNAME',nvl(pPeriodSetName,'???'));
617: FND_MESSAGE.Set_Token('DATE',to_char(pdate));
618: Raise_application_error(-20201, FND_MESSAGE.get);
619: End If;
612:
613: If (pStartDate is null and pEndDate is null) Then
614: FND_MESSAGE.Set_Name('IBE','IBE_ECR_CALENDER_ERROR');
615: FND_MESSAGE.Set_Token('NAME',InitCap(pFrequency));
616: FND_MESSAGE.Set_Token('PERIODSETNAME',nvl(pPeriodSetName,'???'));
617: FND_MESSAGE.Set_Token('DATE',to_char(pdate));
618: Raise_application_error(-20201, FND_MESSAGE.get);
619: End If;
620:
613: If (pStartDate is null and pEndDate is null) Then
614: FND_MESSAGE.Set_Name('IBE','IBE_ECR_CALENDER_ERROR');
615: FND_MESSAGE.Set_Token('NAME',InitCap(pFrequency));
616: FND_MESSAGE.Set_Token('PERIODSETNAME',nvl(pPeriodSetName,'???'));
617: FND_MESSAGE.Set_Token('DATE',to_char(pdate));
618: Raise_application_error(-20201, FND_MESSAGE.get);
619: End If;
620:
621: End getFrequencyDate;
614: FND_MESSAGE.Set_Name('IBE','IBE_ECR_CALENDER_ERROR');
615: FND_MESSAGE.Set_Token('NAME',InitCap(pFrequency));
616: FND_MESSAGE.Set_Token('PERIODSETNAME',nvl(pPeriodSetName,'???'));
617: FND_MESSAGE.Set_Token('DATE',to_char(pdate));
618: Raise_application_error(-20201, FND_MESSAGE.get);
619: End If;
620:
621: End getFrequencyDate;
622: