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.

[Home] [Help]

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.18.12020000.3 2013/03/21 06:06:57 gausriva 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 583: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

579: l_orgn_id NUMBER;
580: l_item_id NUMBER;
581: l_job_name VARCHAR2(240);
582: l_con_seg VARCHAR2(240);
583: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
584: l_genealogy_prefix_suffix NUMBER := fnd_profile.VALUE('GENEALOGY_PREFIX_SUFFIX');
585: l_genealogy_delimitter VARCHAR2(1) := NVL(fnd_profile.VALUE('GENEALOGY_DELIMITER'), '.');
586: l_lot_number VARCHAR2(80) := NULL;
587: BEGIN

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

580: l_item_id NUMBER;
581: l_job_name VARCHAR2(240);
582: l_con_seg VARCHAR2(240);
583: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
584: l_genealogy_prefix_suffix NUMBER := fnd_profile.VALUE('GENEALOGY_PREFIX_SUFFIX');
585: l_genealogy_delimitter VARCHAR2(1) := NVL(fnd_profile.VALUE('GENEALOGY_DELIMITER'), '.');
586: l_lot_number VARCHAR2(80) := NULL;
587: BEGIN
588: IF p_object_type = 1 THEN /* object_type = 1 means lot control */

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

581: l_job_name VARCHAR2(240);
582: l_con_seg VARCHAR2(240);
583: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
584: l_genealogy_prefix_suffix NUMBER := fnd_profile.VALUE('GENEALOGY_PREFIX_SUFFIX');
585: l_genealogy_delimitter VARCHAR2(1) := NVL(fnd_profile.VALUE('GENEALOGY_DELIMITER'), '.');
586: l_lot_number VARCHAR2(80) := NULL;
587: BEGIN
588: IF p_object_type = 1 THEN /* object_type = 1 means lot control */
589: -- Lot Genealogy is available even if WMS is not installed

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

698: FUNCTION getsource(p_org_id IN NUMBER, p_trx_src_type IN NUMBER, p_trx_src_id IN NUMBER)
699: RETURN VARCHAR2 IS
700: l_trx_src VARCHAR2(30);
701: row_count NUMBER := 0;
702: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
703: BEGIN
704: IF p_trx_src_type = 1 THEN -- PO
705: SELECT segment1
706: INTO l_trx_src

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

790: , p_transfer_org_id IN NUMBER
791: )
792: RETURN VARCHAR2 IS
793: l_trading_partner VARCHAR2(240) := NULL;
794: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
795: BEGIN
796: /* For Bug#3420761: Changed the code p_trx_src_type = 2 to
797: p_trx_src_type in (2,12) to handle RMA transactions */
798: IF p_trx_src_type = 1 THEN -- PO

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

920: AND (p_object_id2 IS NULL OR parent_object_id2 = p_object_id2)
921: And (End_Date_Active Is Null Or End_Date_Active > Sysdate)
922: order by creation_date asc;
923:
924: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
925:
926:
927: BEGIN
928: -- First condition

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

1240: CONNECT BY nocycle PRIOR object_id = parent_object_id --12701288
1241: AND (end_date_active IS NULL OR end_date_active > SYSDATE)
1242: AND LEVEL < v_level_num;
1243:
1244: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1245: /*End of R12 Genealogy Lot serial Project*/
1246:
1247: BEGIN
1248: IF (l_debug = 1) THEN

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

1453: AND DEPTH < g_depth
1454: ORDER BY ind DESC;
1455:
1456:
1457: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1458: BEGIN
1459: -- First condition
1460: -- ===============
1461: -- Check if the p_object_id is the first node of the tree

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

1709: AND LEVEL < v_level_num;
1710:
1711:
1712: /* End of R12 Lot Serial Genealogy Project */
1713: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1714:
1715:
1716:
1717: BEGIN

Line 1833: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'), 0);

1829:
1830: -- Bug 8467584
1831: PROCEDURE set_rowlimit(p_numrows IN NUMBER)
1832: IS
1833: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'), 0);
1834: BEGIN
1835: IF g_rowlimit <> p_numrows THEN
1836: g_rowlimit := p_numrows;
1837: END IF;