APPS.CSI_HZ_LOCATIONS_PVT dependencies on FND_MSG_PUB

Line 71: fnd_msg_pub.initialize;

67:
68: -- initialize message list if p_init_msg_list is set to true.
69: IF fnd_api.to_boolean( p_init_msg_list )
70: THEN
71: fnd_msg_pub.initialize;
72: END IF;
73:
74: -- initialize api return status to success
75: x_return_status := fnd_api.g_ret_sts_success;

Line 131: fnd_msg_pub.add;

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
135: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');

Line 137: fnd_msg_pub.add;

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;
141: END;

Line 157: fnd_msg_pub.count_and_get

153: COMMIT WORK;
154: END IF;
155:
156: -- standard call to get message count and if count is 1, get message info.
157: fnd_msg_pub.count_and_get
158: ( p_count => x_msg_count,
159: p_data => x_msg_data
160: );
161:

Line 166: fnd_msg_pub.count_and_get

162: EXCEPTION
163: WHEN fnd_api.g_exc_error THEN
164: ROLLBACK TO create_location_pvt;
165: x_return_status := fnd_api.g_ret_sts_error ;
166: fnd_msg_pub.count_and_get
167: (p_count => x_msg_count ,
168: p_data => x_msg_data
169: );
170: END create_location;

Line 230: fnd_msg_pub.initialize;

226:
227: -- initialize message list IF p_init_msg_list IS set TO true.
228: IF fnd_api.to_boolean( p_init_msg_list )
229: THEN
230: fnd_msg_pub.initialize;
231: END IF;
232:
233: -- initialize api return status to success
234: x_return_status := fnd_api.g_ret_sts_success;

Line 288: FND_MSG_PUB.ADD;

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:
292: BEGIN

Line 302: FND_MSG_PUB.ADD;

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:
306: IF l_location_rec.clli_code IS NOT NULL AND

Line 316: fnd_msg_pub.add;

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
320: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');

Line 322: fnd_msg_pub.add;

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;
326: END;

Line 347: fnd_msg_pub.count_and_get

343: COMMIT WORK;
344: END IF;
345:
346: -- standard call to get message count and if count is 1, get message info.
347: fnd_msg_pub.count_and_get
348: ( p_count => x_msg_count,
349: p_data => x_msg_data
350: );
351:

Line 356: fnd_msg_pub.count_and_get

352: EXCEPTION
353: WHEN fnd_api.g_exc_error THEN
354: ROLLBACK TO update_location_pvt;
355: x_return_status := fnd_api.g_ret_sts_error ;
356: fnd_msg_pub.count_and_get
357: (p_count => x_msg_count ,
358: p_data => x_msg_data
359: );
360: END update_location;