eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_OG_UTIL_PKG dependencies on FND_API

Line 20: x_return_status := FND_API.G_RET_STS_SUCCESS;

16: , x_msg_count OUT NOCOPY NUMBER
17: ) IS
18: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
19: BEGIN
20: x_return_status := FND_API.G_RET_STS_SUCCESS;
21: /* Bug 2456261: Added Object_Type = 2 in the Query */
22: SELECT object_id, object_type
23: INTO x_object_id, x_object_type
24: FROM mtl_object_numbers_v

Line 32: x_return_status := FND_API.G_RET_STS_ERROR;

28: AND organization_id = NVL(p_organization_id, organization_id);
29:
30: EXCEPTION
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);

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 38: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
41:
42: /*

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 81: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

77: /*
78: * First get Obj. ID and Type of Object and its parent
79: */
80: get_objid(p_object_num, p_item_id, p_org_id, l_obj_id,l_obj_type,l_return_status,l_msg_data,l_msg_count);
81: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
82: RAISE NO_DATA_FOUND;
83: END IF;
84: get_objid(p_parent_object_num, p_parent_item_id, p_org_id, l_parent_obj_id,l_parent_obj_type,l_return_status,l_msg_data,l_msg_count);
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

81: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
82: RAISE NO_DATA_FOUND;
83: END IF;
84: get_objid(p_parent_object_num, p_parent_item_id, p_org_id, l_parent_obj_id,l_parent_obj_type,l_return_status,l_msg_data,l_msg_count);
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE NO_DATA_FOUND;
87: END IF;
88: l_genealogy_type := 1;
89: l_genealogy_origin := 1;

Line 163: x_return_status := FND_API.G_RET_STS_SUCCESS;

159: WHERE object_id = l_obj_id
160: AND parent_object_id = l_parent_obj_id;
161: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
162: BEGIN
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: /* Checking whether Parent Item is Serial Controlled */
166: BEGIN
167: SELECT serial_number_control_code INTO l_parent_ser_ctrl

Line 182: RAISE FND_API.G_EXC_ERROR;

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 */
186: get_objid(p_object_num, p_item_id, p_org_id, l_obj_id, l_obj_type, x_return_status, x_msg_data, x_msg_count);

Line 187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

183: END;
184:
185: /* Getting Object ID of the Child Object */
186: get_objid(p_object_num, p_item_id, p_org_id, l_obj_id, l_obj_type, x_return_status, x_msg_data, x_msg_count);
187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
188: RAISE FND_API.G_EXC_ERROR;
189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;

Line 188: RAISE FND_API.G_EXC_ERROR;

184:
185: /* Getting Object ID of the Child Object */
186: get_objid(p_object_num, p_item_id, p_org_id, l_obj_id, l_obj_type, x_return_status, x_msg_data, x_msg_count);
187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
188: RAISE FND_API.G_EXC_ERROR;
189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:

Line 189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

185: /* Getting Object ID of the Child Object */
186: get_objid(p_object_num, p_item_id, p_org_id, l_obj_id, l_obj_type, x_return_status, x_msg_data, x_msg_count);
187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
188: RAISE FND_API.G_EXC_ERROR;
189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193: /* Getting Object ID of the Parent Object */

Line 190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

186: get_objid(p_object_num, p_item_id, p_org_id, l_obj_id, l_obj_type, x_return_status, x_msg_data, x_msg_count);
187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
188: RAISE FND_API.G_EXC_ERROR;
189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193: /* Getting Object ID of the Parent Object */
194: get_objid(p_parent_object_num, p_parent_item_id, p_org_id, l_parent_obj_id, l_parent_obj_type, x_return_status, x_msg_data, x_msg_count);

Line 195: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

191: END IF;
192:
193: /* Getting Object ID of the Parent Object */
194: get_objid(p_parent_object_num, p_parent_item_id, p_org_id, l_parent_obj_id, l_parent_obj_type, x_return_status, x_msg_data, x_msg_count);
195: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
196: RAISE FND_API.G_EXC_ERROR;
197: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;

Line 196: RAISE FND_API.G_EXC_ERROR;

192:
193: /* Getting Object ID of the Parent Object */
194: get_objid(p_parent_object_num, p_parent_item_id, p_org_id, l_parent_obj_id, l_parent_obj_type, x_return_status, x_msg_data, x_msg_count);
195: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
196: RAISE FND_API.G_EXC_ERROR;
197: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:

Line 197: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

193: /* Getting Object ID of the Parent Object */
194: get_objid(p_parent_object_num, p_parent_item_id, p_org_id, l_parent_obj_id, l_parent_obj_type, x_return_status, x_msg_data, x_msg_count);
195: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
196: RAISE FND_API.G_EXC_ERROR;
197: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:
201: l_genealogy_type := 1;

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194: get_objid(p_parent_object_num, p_parent_item_id, p_org_id, l_parent_obj_id, l_parent_obj_type, x_return_status, x_msg_data, x_msg_count);
195: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
196: RAISE FND_API.G_EXC_ERROR;
197: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:
201: l_genealogy_type := 1;
202: l_genealogy_origin := 1;

Line 243: RAISE FND_API.G_EXC_ERROR;

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;
247: EXCEPTION

Line 248: WHEN FND_API.G_EXC_ERROR THEN

244: END IF;
245:
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;

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245:
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);

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 251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
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);

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 255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
258:
259: /** added the procedure gen_update for the 'Serial Tracking in WIP Project.

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

Line 276: x_return_status := FND_API.G_RET_STS_SUCCESS;

272: ) IS
273: l_object_id NUMBER;
274: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
275: BEGIN
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:
278: BEGIN
279: if( p_parent_sernum is not null ) then
280: SELECT gen_object_id INTO l_object_id

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: WHEN NO_DATA_FOUND THEN
296: IF (l_debug = 1) THEN
297: inv_trx_util_pub.trace(' no data found in gen_update','MTL_OG_UTIL_PKG');
298: END IF;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: WHEN OTHERS THEN
301: IF (l_debug = 1) THEN
302: inv_trx_util_pub.trace(' exception in gen_update','MTL_OG_UTIL_PKG');
303: END IF;

Line 304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

300: WHEN OTHERS THEN
301: IF (l_debug = 1) THEN
302: inv_trx_util_pub.trace(' exception in gen_update','MTL_OG_UTIL_PKG');
303: END IF;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: END;
306: BEGIN
307: UPDATE mtl_object_genealogy
308: SET end_date_active = SYSDATE

Line 327: x_return_status := FND_API.G_RET_STS_ERROR;

323: WHEN no_data_found THEN
324: IF (l_debug = 1) THEN
325: inv_trx_util_pub.trace(' no data found while trying to update in gen_update','MTL_OG_UTIL_PKG');
326: END IF;
327: x_return_status := FND_API.G_RET_STS_ERROR;
328: WHEN OTHERS THEN
329: IF (l_debug = 1) THEN
330: inv_trx_util_pub.trace(' exception in gen_update when trying to update','MTL_OG_UTIL_PKG');
331: END IF;

Line 332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

328: WHEN OTHERS THEN
329: IF (l_debug = 1) THEN
330: inv_trx_util_pub.trace(' exception in gen_update when trying to update','MTL_OG_UTIL_PKG');
331: END IF;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: END;
334: END gen_update;
335:
336: /** Insert a record corresponding to an event into the MTL_OBJECT_EVENTS table

Line 368: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

364: /*
365: * Determine the type of transaction from the transaction source and action
366: */
367: get_objid(p_object_number, p_item_id, p_org_id, l_object_id, l_object_type, l_return_status, l_msg_data, l_msg_count);
368: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
369: RAISE NO_DATA_FOUND;
370: END IF;
371:
372: /*