DBA Data[Home] [Help]

APPS.MTL_OG_UTIL_PKG dependencies on FND_MSG_PUB

Line 35: fnd_msg_pub.ADD;

31: WHEN NO_DATA_FOUND THEN
32: x_return_status := FND_API.G_RET_STS_ERROR;
33: fnd_message.set_name('INV','INV_NO_OBJECT_ID');
34: fnd_message.set_token('OBJECT_NAME',p_object_number,FALSE);
35: fnd_msg_pub.ADD;
36: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
37: WHEN OTHERS THEN
38: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
39: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);

Line 36: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);

32: x_return_status := FND_API.G_RET_STS_ERROR;
33: fnd_message.set_name('INV','INV_NO_OBJECT_ID');
34: fnd_message.set_token('OBJECT_NAME',p_object_number,FALSE);
35: fnd_msg_pub.ADD;
36: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
37: WHEN OTHERS THEN
38: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
39: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
40: END get_objid;

Line 39: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);

35: fnd_msg_pub.ADD;
36: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
37: WHEN OTHERS THEN
38: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
39: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
40: END get_objid;
41:
42: /*
43: * Insert a new Genealogy record connecting a child and it's parent

Line 181: fnd_msg_pub.ADD;

177: END IF;
178: EXCEPTION
179: WHEN NO_DATA_FOUND THEN
180: fnd_message.set_name(application=> 'INV',NAME => 'INV_INVALID_ITEM_ORG');
181: fnd_msg_pub.ADD;
182: RAISE FND_API.G_EXC_ERROR;
183: END;
184:
185: /* Getting Object ID of the Child Object */

Line 242: fnd_msg_pub.ADD;

238: IF (c%NOTFOUND) THEN
239: CLOSE c;
240: fnd_message.set_name(application=> 'INV',NAME => 'INV_INSERT_ERROR');
241: fnd_message.set_token(token => 'ENTITY1',VALUE => 'Genealogy',TRANSLATE=> FALSE);
242: fnd_msg_pub.ADD;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245:
246: CLOSE c;

Line 250: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);

246: CLOSE c;
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
254: WHEN OTHERS THEN

Line 253: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);

249: x_return_status := FND_API.G_RET_STS_ERROR;
250: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
254: WHEN OTHERS THEN
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
257: END gen_insert;

Line 256: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);

252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
254: WHEN OTHERS THEN
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
257: END gen_insert;
258:
259: /** added the procedure gen_update for the 'Serial Tracking in WIP Project.
260: This updates the mtl_object_genealogy and mtl_serial_numbers tables