133: open c2;
134: fetch c2 into n1;
135: close c2;
136: if (n1>1) then
137: FND_MESSAGE.SET_NAME(application => G_APP_NAME,
138: name => G_TOO_MANY_SOURCES);
139: FND_MESSAGE.SET_TOKEN(token => 'DATE',
140: value => fnd_date.date_to_chardate(d1));
141: FND_MESSAGE.SET_TOKEN(token => 'SOURCE',
135: close c2;
136: if (n1>1) then
137: FND_MESSAGE.SET_NAME(application => G_APP_NAME,
138: name => G_TOO_MANY_SOURCES);
139: FND_MESSAGE.SET_TOKEN(token => 'DATE',
140: value => fnd_date.date_to_chardate(d1));
141: FND_MESSAGE.SET_TOKEN(token => 'SOURCE',
142: value => 'OKC_ROLE_SOURCES',
143: translate => TRUE);
137: FND_MESSAGE.SET_NAME(application => G_APP_NAME,
138: name => G_TOO_MANY_SOURCES);
139: FND_MESSAGE.SET_TOKEN(token => 'DATE',
140: value => fnd_date.date_to_chardate(d1));
141: FND_MESSAGE.SET_TOKEN(token => 'SOURCE',
142: value => 'OKC_ROLE_SOURCES',
143: translate => TRUE);
144: FND_MSG_PUB.add;
145: x_return_status := OKC_API.G_RET_STS_ERROR;
203: open c2;
204: fetch c2 into n1;
205: close c2;
206: if (n1>1) then
207: FND_MESSAGE.SET_NAME(application => G_APP_NAME,
208: name => G_TOO_MANY_SOURCES);
209: FND_MESSAGE.SET_TOKEN(token => 'DATE',
210: value => fnd_date.date_to_chardate(d1));
211: FND_MESSAGE.SET_TOKEN(token => 'SOURCE',
205: close c2;
206: if (n1>1) then
207: FND_MESSAGE.SET_NAME(application => G_APP_NAME,
208: name => G_TOO_MANY_SOURCES);
209: FND_MESSAGE.SET_TOKEN(token => 'DATE',
210: value => fnd_date.date_to_chardate(d1));
211: FND_MESSAGE.SET_TOKEN(token => 'SOURCE',
212: value => 'OKC_CONTACT_SOURCES',
213: translate => TRUE);
207: FND_MESSAGE.SET_NAME(application => G_APP_NAME,
208: name => G_TOO_MANY_SOURCES);
209: FND_MESSAGE.SET_TOKEN(token => 'DATE',
210: value => fnd_date.date_to_chardate(d1));
211: FND_MESSAGE.SET_TOKEN(token => 'SOURCE',
212: value => 'OKC_CONTACT_SOURCES',
213: translate => TRUE);
214: FND_MSG_PUB.add;
215: x_return_status := OKC_API.G_RET_STS_ERROR;