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.AHL_RM_OPERATION_PVT dependencies on AHL_DEBUG_PUB

Line 5: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');

1: PACKAGE BODY AHL_RM_OPERATION_PVT AS
2: /* $Header: AHLVOPEB.pls 120.14.12020000.2 2012/12/07 01:17:46 sareepar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_RM_OPERATION_PVT';
5: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
6: G_API_NAME VARCHAR2(30) := 'PROCESS_OPERATION';
7: -- constants for WHO Columns
8: -- Added by Prithwi as a part of Public API cleanup
9:

Line 599: AHL_DEBUG_PUB.debug( G_PKG_NAME || '. : in get record:enigmadocid : ' ||x_operation_rec.enigma_doc_id);

595: x_operation_rec.attribute14,
596: x_operation_rec.attribute15;
597:
598: IF G_DEBUG = 'Y' THEN
599: AHL_DEBUG_PUB.debug( G_PKG_NAME || '. : in get record:enigmadocid : ' ||x_operation_rec.enigma_doc_id);
600: AHL_DEBUG_PUB.debug( G_PKG_NAME || '. : in get record:ENIGMATYPE_CODE : ' ||x_operation_rec.ENIGMATYPE_CODE);
601: END IF;
602:
603: IF ( get_old_rec%NOTFOUND ) THEN

Line 600: AHL_DEBUG_PUB.debug( G_PKG_NAME || '. : in get record:ENIGMATYPE_CODE : ' ||x_operation_rec.ENIGMATYPE_CODE);

596: x_operation_rec.attribute15;
597:
598: IF G_DEBUG = 'Y' THEN
599: AHL_DEBUG_PUB.debug( G_PKG_NAME || '. : in get record:enigmadocid : ' ||x_operation_rec.enigma_doc_id);
600: AHL_DEBUG_PUB.debug( G_PKG_NAME || '. : in get record:ENIGMATYPE_CODE : ' ||x_operation_rec.ENIGMATYPE_CODE);
601: END IF;
602:
603: IF ( get_old_rec%NOTFOUND ) THEN
604: x_msg_data := 'AHL_RM_INVALID_OPERATION';

Line 804: AHL_DEBUG_PUB.debug( G_PKG_NAME || ': in default procedure before set :enigmadocid : ' ||p_x_operation_rec.enigma_doc_id);

800: --bachandr Enigma Phase I changes -- end
801: --pekambar Enigma Phase II changes -- start
802:
803: IF G_DEBUG = 'Y' THEN
804: AHL_DEBUG_PUB.debug( G_PKG_NAME || ': in default procedure before set :enigmadocid : ' ||p_x_operation_rec.enigma_doc_id);
805: AHL_DEBUG_PUB.debug( G_PKG_NAME || ': in default procedure before set :ENIGMATYPE_CODE : ' ||p_x_operation_rec.ENIGMATYPE_CODE);
806: END IF;
807:
808:

Line 805: AHL_DEBUG_PUB.debug( G_PKG_NAME || ': in default procedure before set :ENIGMATYPE_CODE : ' ||p_x_operation_rec.ENIGMATYPE_CODE);

801: --pekambar Enigma Phase II changes -- start
802:
803: IF G_DEBUG = 'Y' THEN
804: AHL_DEBUG_PUB.debug( G_PKG_NAME || ': in default procedure before set :enigmadocid : ' ||p_x_operation_rec.enigma_doc_id);
805: AHL_DEBUG_PUB.debug( G_PKG_NAME || ': in default procedure before set :ENIGMATYPE_CODE : ' ||p_x_operation_rec.ENIGMATYPE_CODE);
806: END IF;
807:
808:
809: IF ( p_x_operation_rec.enigmatype_code IS NULL) THEN

Line 828: AHL_DEBUG_PUB.debug( G_PKG_NAME || ' : in default procedure after set :enigmadocid : ' ||p_x_operation_rec.enigma_doc_id);

824: p_x_operation_rec.enigma_doc_id := null;
825: END IF;
826:
827: IF G_DEBUG = 'Y' THEN
828: AHL_DEBUG_PUB.debug( G_PKG_NAME || ' : in default procedure after set :enigmadocid : ' ||p_x_operation_rec.enigma_doc_id);
829: AHL_DEBUG_PUB.debug( G_PKG_NAME || ' : in default procedure after set :ENIGMATYPE_CODE : ' ||p_x_operation_rec.ENIGMATYPE_CODE);
830: END IF;
831:
832: --pekambar Enigma Phase II changes -- end

Line 829: AHL_DEBUG_PUB.debug( G_PKG_NAME || ' : in default procedure after set :ENIGMATYPE_CODE : ' ||p_x_operation_rec.ENIGMATYPE_CODE);

825: END IF;
826:
827: IF G_DEBUG = 'Y' THEN
828: AHL_DEBUG_PUB.debug( G_PKG_NAME || ' : in default procedure after set :enigmadocid : ' ||p_x_operation_rec.enigma_doc_id);
829: AHL_DEBUG_PUB.debug( G_PKG_NAME || ' : in default procedure after set :ENIGMATYPE_CODE : ' ||p_x_operation_rec.ENIGMATYPE_CODE);
830: END IF;
831:
832: --pekambar Enigma Phase II changes -- end
833: IF ( p_x_operation_rec.remarks IS NULL ) THEN

Line 1419: AHL_DEBUG_PUB.enable_debug;

1415: FND_MSG_PUB.initialize;
1416: END IF;
1417:
1418: IF G_DEBUG = 'Y' THEN
1419: AHL_DEBUG_PUB.enable_debug;
1420: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
1421: END IF;
1422:
1423: -- If Id is null derive Operation id from Operation Number and revision

Line 1420: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

1416: END IF;
1417:
1418: IF G_DEBUG = 'Y' THEN
1419: AHL_DEBUG_PUB.enable_debug;
1420: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
1421: END IF;
1422:
1423: -- If Id is null derive Operation id from Operation Number and revision
1424: IF (p_x_operation_rec.dml_operation <> 'C' AND p_x_operation_rec.dml_operation <> 'c') AND

Line 1488: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after convert_values_to_ids' );

1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485: END IF;
1486:
1487: IF G_DEBUG = 'Y' THEN
1488: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after convert_values_to_ids' );
1489: END IF;
1490: IF ( p_x_operation_rec.dml_operation = 'C' ) THEN
1491:
1492: p_x_operation_rec.object_version_number := 1;

Line 1498: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before default_unchanged_attributes:enigmadocid' ||p_x_operation_rec.enigma_doc_id);

1494: p_x_operation_rec.revision_status_code := 'DRAFT';
1495: END IF;
1496:
1497: IF G_DEBUG = 'Y' THEN
1498: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before default_unchanged_attributes:enigmadocid' ||p_x_operation_rec.enigma_doc_id);
1499: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before default_unchanged_attributes sourcecode:ENIGMATYPE_CODE' ||p_x_operation_rec.ENIGMATYPE_CODE);
1500: END IF;
1501:
1502: -- pekambar added for bug # 9957794

Line 1499: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before default_unchanged_attributes sourcecode:ENIGMATYPE_CODE' ||p_x_operation_rec.ENIGMATYPE_CODE);

1495: END IF;
1496:
1497: IF G_DEBUG = 'Y' THEN
1498: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before default_unchanged_attributes:enigmadocid' ||p_x_operation_rec.enigma_doc_id);
1499: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before default_unchanged_attributes sourcecode:ENIGMATYPE_CODE' ||p_x_operation_rec.ENIGMATYPE_CODE);
1500: END IF;
1501:
1502: -- pekambar added for bug # 9957794
1503: -- enigma_route_id attribute is used to differentiate the Routes created through Enigma revision report

Line 1557: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_unchanged_attributes / default_missing_attributes' );

1553: );
1554: END IF;
1555:
1556: IF G_DEBUG = 'Y' THEN
1557: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_unchanged_attributes / default_missing_attributes' );
1558: END IF;
1559:
1560: IF G_DEBUG = 'Y' THEN
1561: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before setting sourcecode:enigmadocid' ||p_x_operation_rec.enigma_doc_id);

Line 1561: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before setting sourcecode:enigmadocid' ||p_x_operation_rec.enigma_doc_id);

1557: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_unchanged_attributes / default_missing_attributes' );
1558: END IF;
1559:
1560: IF G_DEBUG = 'Y' THEN
1561: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before setting sourcecode:enigmadocid' ||p_x_operation_rec.enigma_doc_id);
1562: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before setting sourcecode:ENIGMATYPE_CODE' ||p_x_operation_rec.ENIGMATYPE_CODE);
1563: END IF;
1564:
1565:

Line 1562: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before setting sourcecode:ENIGMATYPE_CODE' ||p_x_operation_rec.ENIGMATYPE_CODE);

1558: END IF;
1559:
1560: IF G_DEBUG = 'Y' THEN
1561: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before setting sourcecode:enigmadocid' ||p_x_operation_rec.enigma_doc_id);
1562: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before setting sourcecode:ENIGMATYPE_CODE' ||p_x_operation_rec.ENIGMATYPE_CODE);
1563: END IF;
1564:
1565:
1566: --pekambar Enigma Phase II changes -- Start

Line 1593: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_attributes' );

1589: END IF;
1590:
1591:
1592: IF G_DEBUG = 'Y' THEN
1593: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_attributes' );
1594: END IF;
1595:
1596: -- Perform cross attribute validation and missing attribute checks (Record level validation)
1597:

Line 1613: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_record' );

1609: END IF;
1610:
1611:
1612: IF G_DEBUG = 'Y' THEN
1613: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_record' );
1614: END IF;
1615:
1616: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1617: l_msg_count := FND_MSG_PUB.count_msg;

Line 1723: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before update table row:enigmadocid' ||p_x_operation_rec.enigma_doc_id);

1719:
1720: ELSIF ( p_x_operation_rec.dml_operation = 'U' ) THEN
1721:
1722: IF G_DEBUG = 'Y' THEN
1723: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before update table row:enigmadocid' ||p_x_operation_rec.enigma_doc_id);
1724: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before update table row :ENIGMATYPE_CODE' ||p_x_operation_rec.ENIGMATYPE_CODE);
1725: END IF;
1726:
1727: BEGIN

Line 1724: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before update table row :ENIGMATYPE_CODE' ||p_x_operation_rec.ENIGMATYPE_CODE);

1720: ELSIF ( p_x_operation_rec.dml_operation = 'U' ) THEN
1721:
1722: IF G_DEBUG = 'Y' THEN
1723: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before update table row:enigmadocid' ||p_x_operation_rec.enigma_doc_id);
1724: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before update table row :ENIGMATYPE_CODE' ||p_x_operation_rec.ENIGMATYPE_CODE);
1725: END IF;
1726:
1727: BEGIN
1728: -- Update the record

Line 1816: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after DML operation' );

1812:
1813: END IF;
1814:
1815: IF G_DEBUG = 'Y' THEN
1816: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after DML operation' );
1817: END IF;
1818:
1819: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1820: l_msg_count := FND_MSG_PUB.count_msg;

Line 1841: AHL_DEBUG_PUB.disable_debug;

1837: );
1838:
1839: -- Disable debug (if enabled)
1840: IF G_DEBUG = 'Y' THEN
1841: AHL_DEBUG_PUB.disable_debug;
1842: END IF;
1843:
1844: EXCEPTION
1845:

Line 1858: AHL_DEBUG_PUB.disable_debug;

1854: );
1855:
1856: -- Disable debug (if enabled)
1857: IF G_DEBUG = 'Y' THEN
1858: AHL_DEBUG_PUB.disable_debug;
1859: END IF;
1860:
1861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1862: ROLLBACK TO process_OPERATION_PVT;

Line 1873: AHL_DEBUG_PUB.disable_debug;

1869: );
1870:
1871: -- Disable debug (if enabled)
1872: IF G_DEBUG = 'Y' THEN
1873: AHL_DEBUG_PUB.disable_debug;
1874: END IF;
1875: WHEN OTHERS THEN
1876: ROLLBACK TO process_OPERATION_PVT;
1877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1896: AHL_DEBUG_PUB.disable_debug;

1892: );
1893:
1894: -- Disable debug (if enabled)
1895: IF G_DEBUG = 'Y' THEN
1896: AHL_DEBUG_PUB.disable_debug;
1897: END IF;
1898: END process_operation;
1899:
1900: PROCEDURE delete_operation

Line 1965: AHL_DEBUG_PUB.enable_debug;

1961: FND_MSG_PUB.initialize;
1962: END IF;
1963:
1964: IF G_DEBUG = 'Y' THEN
1965: AHL_DEBUG_PUB.enable_debug;
1966: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
1967: END IF;
1968:
1969: IF ( p_operation_id IS NULL OR

Line 1966: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

1962: END IF;
1963:
1964: IF G_DEBUG = 'Y' THEN
1965: AHL_DEBUG_PUB.enable_debug;
1966: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
1967: END IF;
1968:
1969: IF ( p_operation_id IS NULL OR
1970: p_operation_id = FND_API.G_MISS_NUM OR

Line 2039: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting AHL_OPERATIONS_B and AHL_OPERATIONS_TL' );

2035: RAISE;
2036: END;
2037:
2038: IF G_DEBUG = 'Y' THEN
2039: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting AHL_OPERATIONS_B and AHL_OPERATIONS_TL' );
2040: END IF;
2041:
2042: -- Delete all the associations
2043:

Line 2056: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Material Requirements' );

2052: NULL;
2053: END IF;
2054:
2055: IF G_DEBUG = 'Y' THEN
2056: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Material Requirements' );
2057: END IF;
2058:
2059: -- 2.Delete Resource Requirements
2060: DELETE AHL_RT_OPER_RESOURCES

Line 2071: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Resource Requirements' );

2067: NULL;
2068: END IF;
2069:
2070: IF G_DEBUG = 'Y' THEN
2071: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Resource Requirements' );
2072: END IF;
2073:
2074: -- 3.Delete Reference Documents
2075: FOR I in get_doc_associations( p_operation_id ) LOOP

Line 2083: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Reference Documents' );

2079: );
2080: END LOOP;
2081:
2082: IF G_DEBUG = 'Y' THEN
2083: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Reference Documents' );
2084: END IF;
2085:
2086: -- 4.Delete Associated Operations
2087: DELETE AHL_ROUTE_OPERATIONS

Line 2097: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Associated Operations' );

2093: NULL;
2094: END IF;
2095:
2096: IF G_DEBUG = 'Y' THEN
2097: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Associated Operations' );
2098: END IF;
2099:
2100: -- 5.Delete Access Panels associated
2101: DELETE AHL_RT_OPER_ACCESS_PANELS

Line 2112: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Access Panels' );

2108: NULL;
2109: END IF;
2110:
2111: IF G_DEBUG = 'Y' THEN
2112: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Access Panels' );
2113: END IF;
2114:
2115: -- Perform the Commit (if requested)
2116: IF FND_API.to_boolean( p_commit ) THEN

Line 2130: AHL_DEBUG_PUB.disable_debug;

2126: );
2127:
2128: -- Disable debug (if enabled)
2129: IF G_DEBUG = 'Y' THEN
2130: AHL_DEBUG_PUB.disable_debug;
2131: END IF;
2132: EXCEPTION
2133:
2134: WHEN FND_API.G_EXC_ERROR THEN

Line 2146: AHL_DEBUG_PUB.disable_debug;

2142: );
2143:
2144: -- Disable debug (if enabled)
2145: IF G_DEBUG = 'Y' THEN
2146: AHL_DEBUG_PUB.disable_debug;
2147: END IF;
2148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2149: ROLLBACK TO delete_OPERATION_PVT;
2150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2160: AHL_DEBUG_PUB.disable_debug;

2156: );
2157:
2158: -- Disable debug (if enabled)
2159: IF G_DEBUG = 'Y' THEN
2160: AHL_DEBUG_PUB.disable_debug;
2161: END IF;
2162: WHEN OTHERS THEN
2163: ROLLBACK TO delete_OPERATION_PVT;
2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2183: AHL_DEBUG_PUB.disable_debug;

2179: );
2180:
2181: -- Disable debug (if enabled)
2182: IF G_DEBUG = 'Y' THEN
2183: AHL_DEBUG_PUB.disable_debug;
2184: END IF;
2185: END delete_operation;
2186:
2187: PROCEDURE create_oper_revision

Line 2317: AHL_DEBUG_PUB.enable_debug;

2313: FND_MSG_PUB.initialize;
2314: END IF;
2315:
2316: IF G_DEBUG = 'Y' THEN
2317: AHL_DEBUG_PUB.enable_debug;
2318: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
2319: END IF;
2320:
2321: IF ( p_operation_id IS NULL OR

Line 2318: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

2314: END IF;
2315:
2316: IF G_DEBUG = 'Y' THEN
2317: AHL_DEBUG_PUB.enable_debug;
2318: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
2319: END IF;
2320:
2321: IF ( p_operation_id IS NULL OR
2322: p_operation_id = FND_API.G_MISS_NUM OR

Line 2894: AHL_DEBUG_PUB.disable_debug;

2890: );
2891:
2892: -- Disable debug (if enabled)
2893: IF G_DEBUG = 'Y' THEN
2894: AHL_DEBUG_PUB.disable_debug;
2895: END IF;
2896: EXCEPTION
2897:
2898: WHEN FND_API.G_EXC_ERROR THEN

Line 2910: AHL_DEBUG_PUB.disable_debug;

2906: );
2907:
2908: -- Disable debug (if enabled)
2909: IF G_DEBUG = 'Y' THEN
2910: AHL_DEBUG_PUB.disable_debug;
2911: END IF;
2912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2913: ROLLBACK TO create_oper_revision_PVT;
2914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2924: AHL_DEBUG_PUB.disable_debug;

2920: );
2921:
2922: -- Disable debug (if enabled)
2923: IF G_DEBUG = 'Y' THEN
2924: AHL_DEBUG_PUB.disable_debug;
2925: END IF;
2926: WHEN OTHERS THEN
2927: ROLLBACK TO create_oper_revision_PVT;
2928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2947: AHL_DEBUG_PUB.disable_debug;

2943: );
2944:
2945: -- Disable debug (if enabled)
2946: IF G_DEBUG = 'Y' THEN
2947: AHL_DEBUG_PUB.disable_debug;
2948: END IF;
2949: END create_oper_revision;
2950:
2951: END AHL_RM_OPERATION_PVT;