77: open c;
78: fetch c into recinfo;
79: if (c%notfound) then
80: close c;
81: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
82: app_exception.raise_exception;
83: end if;
84: close c;
85: if ( (recinfo.STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE)
87: AND (recinfo.TERRITORY_CODE = X_TERRITORY_CODE)
88: ) then
89: null;
90: else
91: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
92: app_exception.raise_exception;
93: end if;
94:
95: return;
151: WHERE STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID ;
152:
153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN
155: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
156: FND_MESSAGE.SET_TOKEN( 'RECORD', 'style_fmt_locale_rec');
157: FND_MESSAGE.SET_TOKEN( 'VALUE', 'STYLE_FMT_LOCALE_ID' );
158: FND_MSG_PUB.ADD;
159: RAISE FND_API.G_EXC_ERROR;
152:
153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN
155: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
156: FND_MESSAGE.SET_TOKEN( 'RECORD', 'style_fmt_locale_rec');
157: FND_MESSAGE.SET_TOKEN( 'VALUE', 'STYLE_FMT_LOCALE_ID' );
158: FND_MSG_PUB.ADD;
159: RAISE FND_API.G_EXC_ERROR;
160:
153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN
155: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
156: FND_MESSAGE.SET_TOKEN( 'RECORD', 'style_fmt_locale_rec');
157: FND_MESSAGE.SET_TOKEN( 'VALUE', 'STYLE_FMT_LOCALE_ID' );
158: FND_MSG_PUB.ADD;
159: RAISE FND_API.G_EXC_ERROR;
160:
161: END SELECT_ROW;