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.INV_OBJECT_GENEALOGY dependencies on FND_PROFILE

Line 6: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2: /* $Header: INVOGENB.pls 120.10 2008/02/06 12:10:55 rkatoori ship $ */
3: FUNCTION getobjecttype(p_object_id IN NUMBER)
4: RETURN NUMBER IS
5: l_retval NUMBER;
6: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7: BEGIN
8: BEGIN
9: SELECT 1
10: INTO l_retval

Line 59: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

55: , p_material_status OUT NOCOPY VARCHAR2
56: , p_unit_number OUT NOCOPY VARCHAR2
57: ) IS
58: l_status_id NUMBER;
59: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
60: BEGIN
61: IF (l_debug = 1) THEN
62: inv_trx_util_pub.TRACE('in the procedure getObjectInfo', 'INV_OBJECT_GENEALOGY', 9);
63: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);

Line 228: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

224: , x_intraoperation_step_type OUT NOCOPY NUMBER
225: , x_current_lot_number OUT NOCOPY VARCHAR2 -- R12 Lot serial Genealogy Project : added new parameter x_current_lot_number
226: ) IS
227: l_status_id NUMBER;
228: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
229: BEGIN
230: IF (l_debug = 1) THEN
231: inv_trx_util_pub.TRACE('in the procedure getObjectInfo', 'INV_OBJECT_GENEALOGY', 9);
232: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);

Line 529: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

525: l_orgn_id NUMBER;
526: l_item_id NUMBER;
527: l_job_name VARCHAR2(240);
528: l_con_seg VARCHAR2(240);
529: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
530: l_genealogy_prefix_suffix NUMBER := fnd_profile.VALUE('GENEALOGY_PREFIX_SUFFIX');
531: l_genealogy_delimitter VARCHAR2(1) := NVL(fnd_profile.VALUE('GENEALOGY_DELIMITER'), '.');
532: l_lot_number VARCHAR2(80) := NULL;
533: BEGIN

Line 530: l_genealogy_prefix_suffix NUMBER := fnd_profile.VALUE('GENEALOGY_PREFIX_SUFFIX');

526: l_item_id NUMBER;
527: l_job_name VARCHAR2(240);
528: l_con_seg VARCHAR2(240);
529: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
530: l_genealogy_prefix_suffix NUMBER := fnd_profile.VALUE('GENEALOGY_PREFIX_SUFFIX');
531: l_genealogy_delimitter VARCHAR2(1) := NVL(fnd_profile.VALUE('GENEALOGY_DELIMITER'), '.');
532: l_lot_number VARCHAR2(80) := NULL;
533: BEGIN
534: IF p_object_type = 1 THEN /* object_type = 1 means lot control */

Line 531: l_genealogy_delimitter VARCHAR2(1) := NVL(fnd_profile.VALUE('GENEALOGY_DELIMITER'), '.');

527: l_job_name VARCHAR2(240);
528: l_con_seg VARCHAR2(240);
529: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
530: l_genealogy_prefix_suffix NUMBER := fnd_profile.VALUE('GENEALOGY_PREFIX_SUFFIX');
531: l_genealogy_delimitter VARCHAR2(1) := NVL(fnd_profile.VALUE('GENEALOGY_DELIMITER'), '.');
532: l_lot_number VARCHAR2(80) := NULL;
533: BEGIN
534: IF p_object_type = 1 THEN /* object_type = 1 means lot control */
535: -- Lot Genealogy is available even if WMS is not installed

Line 648: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

644: FUNCTION getsource(p_org_id IN NUMBER, p_trx_src_type IN NUMBER, p_trx_src_id IN NUMBER)
645: RETURN VARCHAR2 IS
646: l_trx_src VARCHAR2(30);
647: row_count NUMBER := 0;
648: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
649: BEGIN
650: IF p_trx_src_type = 1 THEN -- PO
651: SELECT segment1
652: INTO l_trx_src

Line 740: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

736: , p_transfer_org_id IN NUMBER
737: )
738: RETURN VARCHAR2 IS
739: l_trading_partner VARCHAR2(240) := NULL;
740: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
741: BEGIN
742: /* For Bug#3420761: Changed the code p_trx_src_type = 2 to
743: p_trx_src_type in (2,12) to handle RMA transactions */
744: IF p_trx_src_type = 1 THEN -- PO

Line 835: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

831: WHERE parent_object_id = p_object_id
832: AND (p_object_id2 IS NULL OR parent_object_id2 = p_object_id2)
833: AND (end_date_active IS NULL OR end_date_active > SYSDATE);
834:
835: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
836:
837:
838: BEGIN
839: -- First condition

Line 1119: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1115: START WITH (parent_object_id=p_object_id and (end_date_active is null or end_date_active > SYSDATE))
1116: CONNECT BY PRIOR object_id = parent_object_id
1117: AND (end_date_active IS NULL OR end_date_active > SYSDATE);
1118:
1119: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1120: /*End of R12 Genealogy Lot serial Project*/
1121:
1122: BEGIN
1123: IF (l_debug = 1) THEN

Line 1289: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1285: AND DEPTH < g_depth
1286: ORDER BY ind DESC;
1287:
1288:
1289: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1290: BEGIN
1291: -- First condition
1292: -- ===============
1293: -- Check if the p_object_id is the first node of the tree

Line 1541: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1537: AND (end_date_active IS NULL OR end_date_active > SYSDATE);
1538:
1539:
1540: /* End of R12 Lot Serial Genealogy Project */
1541: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1542:
1543:
1544:
1545: BEGIN