68: close c;
69:
70: EXCEPTION
71: WHEN OTHERS THEN
72: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_PROGRAM_ADDRESSES_TBH'
73: ,p_procedure_name => 'INSERT_ROW' );
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
75: RAISE;
76: end INSERT_ROW;
135: AND RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER;
136:
137: if (sql%notfound) then
138: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
139: FND_MSG_PUB.Add;
140: X_RETURN_STATUS := 'E';
141: end if;
142:
143: EXCEPTION
141: end if;
142:
143: EXCEPTION
144: WHEN OTHERS THEN
145: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_MAILING_INFO_TBH'
146: ,p_procedure_name => 'UPDATE_ROW' );
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148: RAISE;
149: end UPDATE_ROW;
181:
182:
183: if (sql%notfound) then
184: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
185: FND_MSG_PUB.Add;
186: X_RETURN_STATUS := 'E';
187: end if;
188:
189: EXCEPTION
187: end if;
188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_PROGRAM_ADDRESSES_TBH'
192: ,p_procedure_name => 'DELETE_ROW' );
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
194: RAISE;
195: end DELETE_ROW;