DBA Data[Home] [Help]

APPS.CSI_HZ_LOCATIONS_PVT dependencies on FND_MESSAGE

Line 129: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');

125: INTO l_dummy
126: FROM hz_locations
127: WHERE clli_code = l_location_rec.clli_code;
128:
129: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
130: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
131: fnd_msg_pub.add;
132: RAISE fnd_api.g_exc_error;
133: EXCEPTION

Line 130: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);

126: FROM hz_locations
127: WHERE clli_code = l_location_rec.clli_code;
128:
129: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
130: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
131: fnd_msg_pub.add;
132: RAISE fnd_api.g_exc_error;
133: EXCEPTION
134: WHEN TOO_MANY_ROWS THEN

Line 135: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');

131: fnd_msg_pub.add;
132: RAISE fnd_api.g_exc_error;
133: EXCEPTION
134: WHEN TOO_MANY_ROWS THEN
135: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
136: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
137: fnd_msg_pub.add;
138: RAISE fnd_api.g_exc_error;
139: WHEN NO_DATA_FOUND THEN

Line 136: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);

132: RAISE fnd_api.g_exc_error;
133: EXCEPTION
134: WHEN TOO_MANY_ROWS THEN
135: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
136: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
137: fnd_msg_pub.add;
138: RAISE fnd_api.g_exc_error;
139: WHEN NO_DATA_FOUND THEN
140: NULL;

Line 286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

282:
283:
284: IF p_location_id IS NULL OR
285: p_location_id = FND_API.G_MISS_NUM THEN
286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
287: FND_MESSAGE.SET_TOKEN('COLUMN', 'location id');
288: FND_MSG_PUB.ADD;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;

Line 287: FND_MESSAGE.SET_TOKEN('COLUMN', 'location id');

283:
284: IF p_location_id IS NULL OR
285: p_location_id = FND_API.G_MISS_NUM THEN
286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
287: FND_MESSAGE.SET_TOKEN('COLUMN', 'location id');
288: FND_MSG_PUB.ADD;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:

Line 299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

295: FROM hz_locations
296: WHERE location_id = l_location_rec.location_id;
297: EXCEPTION
298: WHEN NO_DATA_FOUND THEN
299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
300: FND_MESSAGE.SET_TOKEN('RECORD', 'location');
301: FND_MESSAGE.SET_TOKEN('VALUE', to_char(l_location_rec.location_id));
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;

Line 300: FND_MESSAGE.SET_TOKEN('RECORD', 'location');

296: WHERE location_id = l_location_rec.location_id;
297: EXCEPTION
298: WHEN NO_DATA_FOUND THEN
299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
300: FND_MESSAGE.SET_TOKEN('RECORD', 'location');
301: FND_MESSAGE.SET_TOKEN('VALUE', to_char(l_location_rec.location_id));
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: END;

Line 301: FND_MESSAGE.SET_TOKEN('VALUE', to_char(l_location_rec.location_id));

297: EXCEPTION
298: WHEN NO_DATA_FOUND THEN
299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
300: FND_MESSAGE.SET_TOKEN('RECORD', 'location');
301: FND_MESSAGE.SET_TOKEN('VALUE', to_char(l_location_rec.location_id));
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: END;
305:

Line 314: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');

310: INTO l_dummy
311: FROM hz_locations
312: WHERE clli_code = l_location_rec.clli_code
313: AND location_id <> l_location_rec.location_id;
314: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
315: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
316: fnd_msg_pub.add;
317: RAISE fnd_api.g_exc_error;
318: EXCEPTION

Line 315: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);

311: FROM hz_locations
312: WHERE clli_code = l_location_rec.clli_code
313: AND location_id <> l_location_rec.location_id;
314: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
315: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
316: fnd_msg_pub.add;
317: RAISE fnd_api.g_exc_error;
318: EXCEPTION
319: WHEN TOO_MANY_ROWS THEN

Line 320: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');

316: fnd_msg_pub.add;
317: RAISE fnd_api.g_exc_error;
318: EXCEPTION
319: WHEN TOO_MANY_ROWS THEN
320: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
321: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
322: fnd_msg_pub.add;
323: RAISE fnd_api.g_exc_error;
324: WHEN NO_DATA_FOUND THEN

Line 321: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);

317: RAISE fnd_api.g_exc_error;
318: EXCEPTION
319: WHEN TOO_MANY_ROWS THEN
320: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
321: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
322: fnd_msg_pub.add;
323: RAISE fnd_api.g_exc_error;
324: WHEN NO_DATA_FOUND THEN
325: NULL;

Line 398: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

394: OPEN C;
395: FETCH C INTO Recinfo;
396: If (C%NOTFOUND) then
397: CLOSE C;
398: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
399: APP_EXCEPTION.RAISE_EXCEPTION;
400: End If;
401: CLOSE C;
402:

Line 461: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

457: AND ( p_created_by_module IS NULL )))
458: ) THEN
459: RETURN;
460: ELSE
461: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
462: APP_EXCEPTION.RAISE_EXCEPTION;
463: END IF;
464: END Lock_location;
465: