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.EAM_REBUILD_GENEALOGY dependencies on FND_API

Line 8: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_REBUILD_GENEALOGY';
5:
6: PROCEDURE create_rebuild_genealogy(
7: p_api_version IN NUMBER
8: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
9: , p_commit IN VARCHAR2 := FND_API.G_FALSE
10: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11: , p_subinventory IN VARCHAR2 := NULL
12: , p_locator_id IN NUMBER := NULL

Line 9: , p_commit IN VARCHAR2 := FND_API.G_FALSE

5:
6: PROCEDURE create_rebuild_genealogy(
7: p_api_version IN NUMBER
8: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
9: , p_commit IN VARCHAR2 := FND_API.G_FALSE
10: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11: , p_subinventory IN VARCHAR2 := NULL
12: , p_locator_id IN NUMBER := NULL
13: , p_object_id IN number := null

Line 10: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

6: PROCEDURE create_rebuild_genealogy(
7: p_api_version IN NUMBER
8: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
9: , p_commit IN VARCHAR2 := FND_API.G_FALSE
10: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11: , p_subinventory IN VARCHAR2 := NULL
12: , p_locator_id IN NUMBER := NULL
13: , p_object_id IN number := null
14: , p_serial_number IN VARCHAR2 := NULL

Line 49: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

45: begin
46:
47: savepoint eam_rebuild_genealogy;
48:
49: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
50: p_api_version,
51: l_api_name,
52: g_pkg_name)
53: THEN

Line 54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

50: p_api_version,
51: l_api_name,
52: g_pkg_name)
53: THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: IF FND_API.TO_BOOLEAN(p_init_msg_list)
58: THEN

Line 57: IF FND_API.TO_BOOLEAN(p_init_msg_list)

53: THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: IF FND_API.TO_BOOLEAN(p_init_msg_list)
58: THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:

Line 63: x_return_status := FND_API.G_RET_STS_SUCCESS;

59: FND_MSG_PUB.initialize;
60: END IF;
61:
62: -- Initialize API return status to success
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64:
65: -- obtain rebuildable information
66: if p_object_id is null then
67: if p_serial_number is null

Line 74: RAISE FND_API.G_EXC_ERROR;

70: FND_MESSAGE.SET_NAME('INV', 'INV_FIELD_INVALID');
71: FND_MESSAGE.SET_TOKEN('ENTITY1', 'p_serial_number');
72: FND_MSG_PUB.ADD;
73: l_return_status := 'E';
74: RAISE FND_API.G_EXC_ERROR;
75: else
76: l_serial_number := p_serial_number;
77: l_inventory_item_id := p_inventory_item_id;
78: l_organization_id := p_organization_id;

Line 106: RAISE FND_API.G_EXC_ERROR;

102: FND_MESSAGE.SET_NAME('INV', 'INV_FIELD_INVALID');
103: FND_MESSAGE.SET_TOKEN('ENTITY1', 'p_serial_number');
104: FND_MSG_PUB.ADD;
105: l_return_status := 'E';
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: select gen_object_id into l_parent_object_id
109: from mtl_serial_numbers where
110: serial_number = p_parent_serial_number

Line 136: RAISE FND_API.G_EXC_ERROR;

132: if l_charge_object_id <> l_parent_object_id then
133: FND_MESSAGE.SET_NAME('EAM', 'EAM_CURRENT_WO_WITH_CHARGE_ASSET');
134: FND_MSG_PUB.ADD;
135: l_return_status := 'E';
136: RAISE FND_API.G_EXC_ERROR;
137: end if;
138: exception
139: when others then
140: null;

Line 155: RAISE FND_API.G_EXC_ERROR;

151: when no_data_found then
152: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_CURRENT_STATUS');
153: FND_MSG_PUB.ADD;
154: l_return_status := 'E';
155: RAISE FND_API.G_EXC_ERROR;
156: end;
157:
158: -- if current_status = 3 then carry out transaction
159:

Line 197: RAISE FND_API.G_EXC_ERROR;

193: and p_end_date_active > sysdate) then
194: l_return_status := 'E';
195: FND_MESSAGE.SET_NAME('EAM', 'EAM_REBUILD_FUTURE_TXN');
196: FND_MSG_PUB.ADD;
197: RAISE FND_API.G_EXC_ERROR;
198: elsif (p_start_date_active < sysdate and
199: (p_end_date_active is not null and p_end_date_active < sysdate)) then
200: l_txn_id := null;
201: l_return_status := 'S';

Line 214: RAISE FND_API.G_EXC_ERROR;

210: exception
211: when others then
212: FND_MESSAGE.SET_NAME('EAM', 'EAM_NO_OFFSET_ACCOUNT');
213: FND_MSG_PUB.ADD;
214: RAISE FND_API.G_EXC_ERROR;
215: end;
216:
217: -- Transaction processing API is called
218: -- If the transaction is processed successfully then

Line 245: RAISE FND_API.G_EXC_ERROR;

241: from mtl_serial_numbers
242: where serial_number = l_serial_number;
243: exception
244: when others then
245: RAISE FND_API.G_EXC_ERROR;
246: end;
247: end if;
248:
249: elsif l_current_status = 4 then

Line 256: RAISE FND_API.G_EXC_ERROR;

252: else
253: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_CURRENT_STATUS');
254: FND_MSG_PUB.ADD;
255: l_return_status := 'E';
256: RAISE FND_API.G_EXC_ERROR;
257: end if;
258:
259: if l_return_status = 'S' then
260:

Line 283: raise FND_API.G_EXC_ERROR;

279: , x_msg_count => l_msg_count
280: , x_msg_data => l_msg_data);
281:
282: if (l_return_status = 'E') or (l_return_status = 'U') then
283: raise FND_API.G_EXC_ERROR;
284: end if;
285:
286: else
287: raise FND_API.G_EXC_ERROR;

Line 287: raise FND_API.G_EXC_ERROR;

283: raise FND_API.G_EXC_ERROR;
284: end if;
285:
286: else
287: raise FND_API.G_EXC_ERROR;
288: end if;
289:
290: if p_commit = FND_API.G_TRUE then
291: commit;

Line 290: if p_commit = FND_API.G_TRUE then

286: else
287: raise FND_API.G_EXC_ERROR;
288: end if;
289:
290: if p_commit = FND_API.G_TRUE then
291: commit;
292: end if;
293:
294: exception

Line 295: WHEN FND_API.G_EXC_ERROR THEN

291: commit;
292: end if;
293:
294: exception
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO eam_rebuild_genealogy;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_And_Get
299: ( p_encoded => FND_API.G_FALSE,

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

293:
294: exception
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO eam_rebuild_genealogy;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_And_Get
299: ( p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count ,
301: p_data => x_msg_data

Line 299: ( p_encoded => FND_API.G_FALSE,

295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO eam_rebuild_genealogy;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_And_Get
299: ( p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count ,
301: p_data => x_msg_data
302: );
303:

Line 306: x_return_status := FND_API.G_RET_STS_ERROR;

302: );
303:
304: WHEN OTHERS THEN
305: ROLLBACK TO eam_rebuild_genealogy;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: FND_MSG_PUB.Count_And_Get
308: ( p_encoded => FND_API.G_FALSE,
309: p_count => x_msg_count ,
310: p_data => x_msg_data

Line 308: ( p_encoded => FND_API.G_FALSE,

304: WHEN OTHERS THEN
305: ROLLBACK TO eam_rebuild_genealogy;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: FND_MSG_PUB.Count_And_Get
308: ( p_encoded => FND_API.G_FALSE,
309: p_count => x_msg_count ,
310: p_data => x_msg_data
311: );
312:

Line 318: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

314:
315:
316: PROCEDURE update_rebuild_genealogy(
317: p_api_version IN NUMBER
318: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
319: , p_commit IN VARCHAR2 := FND_API.G_FALSE
320: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
321: , p_object_type IN NUMBER
322: , p_object_id IN NUMBER := NULL

Line 319: , p_commit IN VARCHAR2 := FND_API.G_FALSE

315:
316: PROCEDURE update_rebuild_genealogy(
317: p_api_version IN NUMBER
318: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
319: , p_commit IN VARCHAR2 := FND_API.G_FALSE
320: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
321: , p_object_type IN NUMBER
322: , p_object_id IN NUMBER := NULL
323: , p_serial_number IN VARCHAR2 := NULL

Line 320: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

316: PROCEDURE update_rebuild_genealogy(
317: p_api_version IN NUMBER
318: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
319: , p_commit IN VARCHAR2 := FND_API.G_FALSE
320: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
321: , p_object_type IN NUMBER
322: , p_object_id IN NUMBER := NULL
323: , p_serial_number IN VARCHAR2 := NULL
324: , p_inventory_item_id IN NUMBER := NULL

Line 361: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

357: begin
358:
359: savepoint eam_rebuild_genealogy;
360:
361: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
362: p_api_version,
363: l_api_name,
364: g_pkg_name)
365: THEN

Line 366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

362: p_api_version,
363: l_api_name,
364: g_pkg_name)
365: THEN
366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: END IF;
368:
369: IF FND_API.TO_BOOLEAN(p_init_msg_list)
370: THEN

Line 369: IF FND_API.TO_BOOLEAN(p_init_msg_list)

365: THEN
366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: END IF;
368:
369: IF FND_API.TO_BOOLEAN(p_init_msg_list)
370: THEN
371: FND_MSG_PUB.initialize;
372: END IF;
373:

Line 375: x_return_status := FND_API.G_RET_STS_SUCCESS;

371: FND_MSG_PUB.initialize;
372: END IF;
373:
374: -- Initialize API return status to success
375: x_return_status := FND_API.G_RET_STS_SUCCESS;
376:
377:
378: -- obtain rebuildable information
379: if p_object_id is null then

Line 387: RAISE FND_API.G_EXC_ERROR;

383: FND_MESSAGE.SET_NAME('INV', 'INV_FIELD_INVALID');
384: FND_MESSAGE.SET_TOKEN('ENTITY1', 'p_serial_number');
385: FND_MSG_PUB.ADD;
386: l_return_status := 'E';
387: RAISE FND_API.G_EXC_ERROR;
388: else
389: l_serial_number := p_serial_number;
390: l_inventory_item_id := p_inventory_item_id;
391: l_organization_id := p_organization_id;

Line 404: RAISE FND_API.G_EXC_ERROR;

400: when others then
401: FND_MESSAGE.SET_NAME('INV', 'INV_EAM_GEN_INVALID_OBJECT');
402: FND_MSG_PUB.ADD;
403: l_return_status := 'E';
404: RAISE FND_API.G_EXC_ERROR;
405: end;
406: end if;
407: else
408:

Line 424: RAISE FND_API.G_EXC_ERROR;

420: when others then
421: FND_MESSAGE.SET_NAME('INV', 'INV_EAM_GEN_INVALID_OBJECT');
422: FND_MSG_PUB.ADD;
423: l_return_status := 'E';
424: RAISE FND_API.G_EXC_ERROR;
425: end;
426: else
427: l_serial_number := p_serial_number;
428: l_inventory_item_id := p_inventory_item_id;

Line 449: RAISE FND_API.G_EXC_ERROR;

445: when others then
446: l_return_status := 'E';
447: FND_MESSAGE.SET_NAME('EAM', 'EAM_NO_SUBINV_SPECIFIED');
448: FND_MSG_PUB.ADD;
449: RAISE FND_API.G_EXC_ERROR;
450: end;
451: else
452: l_subinventory := p_subinventory;
453: end if;

Line 480: RAISE FND_API.G_EXC_ERROR;

476: if p_end_date_active is not null and p_end_date_active > sysdate then
477: l_return_status := 'E';
478: FND_MESSAGE.SET_NAME('EAM', 'EAM_REBUILD_FUTURE_TXN');
479: FND_MSG_PUB.ADD;
480: RAISE FND_API.G_EXC_ERROR;
481: else
482:
483: -- obtain the offset account id from user-defined EAM parameters
484: begin

Line 493: RAISE FND_API.G_EXC_ERROR;

489: exception
490: when others then
491: FND_MESSAGE.SET_NAME('EAM', 'EAM_NO_OFFSET_ACCOUNT');
492: FND_MSG_PUB.ADD;
493: RAISE FND_API.G_EXC_ERROR;
494: end;
495:
496: -- call the Transaction processing API
497: -- if API returns success, call the inventory genealogy API

Line 522: RAISE FND_API.G_EXC_ERROR;

518: where serial_number = l_serial_number;
519: -- dbms_output.put_line('got here 3');
520: exception
521: when others then
522: RAISE FND_API.G_EXC_ERROR;
523: end;
524: end if;
525:
526: if l_return_status = 'S' then

Line 544: raise FND_API.G_EXC_ERROR;

540: , x_msg_count => l_msg_count
541: , x_msg_data => l_msg_data);
542:
543: if (l_return_status = 'E') or (l_return_status = 'U') then
544: raise FND_API.G_EXC_ERROR;
545: end if;
546:
547: else
548: raise FND_API.G_EXC_ERROR;

Line 548: raise FND_API.G_EXC_ERROR;

544: raise FND_API.G_EXC_ERROR;
545: end if;
546:
547: else
548: raise FND_API.G_EXC_ERROR;
549: end if;
550:
551: if p_commit = FND_API.G_TRUE then
552: commit;

Line 551: if p_commit = FND_API.G_TRUE then

547: else
548: raise FND_API.G_EXC_ERROR;
549: end if;
550:
551: if p_commit = FND_API.G_TRUE then
552: commit;
553: end if;
554:
555: exception

Line 556: WHEN FND_API.G_EXC_ERROR THEN

552: commit;
553: end if;
554:
555: exception
556: WHEN FND_API.G_EXC_ERROR THEN
557: ROLLBACK TO eam_rebuild_genealogy;
558: x_return_status := l_RETURN_STATUS;
559: FND_MSG_PUB.Count_And_Get
560: ( p_encoded => FND_API.G_FALSE,

Line 560: ( p_encoded => FND_API.G_FALSE,

556: WHEN FND_API.G_EXC_ERROR THEN
557: ROLLBACK TO eam_rebuild_genealogy;
558: x_return_status := l_RETURN_STATUS;
559: FND_MSG_PUB.Count_And_Get
560: ( p_encoded => FND_API.G_FALSE,
561: p_count => x_msg_count ,
562: p_data => x_msg_data
563: );
564: WHEN OTHERS THEN

Line 566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

562: p_data => x_msg_data
563: );
564: WHEN OTHERS THEN
565: ROLLBACK TO eam_rebuild_genealogy;
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: FND_MSG_PUB.Count_And_Get
568: ( p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count ,
570: p_data => x_msg_data

Line 568: ( p_encoded => FND_API.G_FALSE,

564: WHEN OTHERS THEN
565: ROLLBACK TO eam_rebuild_genealogy;
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: FND_MSG_PUB.Count_And_Get
568: ( p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count ,
570: p_data => x_msg_data
571: );
572: