DBA Data[Home] [Help]

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.4.12010000.3 2008/12/29 14:19:58 bachandr 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 1291: AHL_DEBUG_PUB.enable_debug;

1287: FND_MSG_PUB.initialize;
1288: END IF;
1289:
1290: IF G_DEBUG = 'Y' THEN
1291: AHL_DEBUG_PUB.enable_debug;
1292: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
1293: END IF;
1294:
1295: -- If Id is null derive Operation id from Operation Number and revision

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

1288: END IF;
1289:
1290: IF G_DEBUG = 'Y' THEN
1291: AHL_DEBUG_PUB.enable_debug;
1292: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
1293: END IF;
1294:
1295: -- If Id is null derive Operation id from Operation Number and revision
1296: IF (p_x_operation_rec.dml_operation <> 'C' AND p_x_operation_rec.dml_operation <> 'c') AND

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

1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: END IF;
1358:
1359: IF G_DEBUG = 'Y' THEN
1360: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after convert_values_to_ids' );
1361: END IF;
1362: IF ( p_x_operation_rec.dml_operation = 'C' ) THEN
1363:
1364: p_x_operation_rec.object_version_number := 1;

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

1380: );
1381: END IF;
1382:
1383: IF G_DEBUG = 'Y' THEN
1384: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_unchanged_attributes / default_missing_attributes' );
1385: END IF;
1386:
1387: -- Validate all attributes (Item level validation)
1388:

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

1400: END IF;
1401:
1402:
1403: IF G_DEBUG = 'Y' THEN
1404: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_attributes' );
1405: END IF;
1406:
1407: -- Perform cross attribute validation and missing attribute checks (Record level validation)
1408:

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

1420: END IF;
1421:
1422:
1423: IF G_DEBUG = 'Y' THEN
1424: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_record' );
1425: END IF;
1426:
1427: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1428: l_msg_count := FND_MSG_PUB.count_msg;

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

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

Line 1639: AHL_DEBUG_PUB.disable_debug;

1635: );
1636:
1637: -- Disable debug (if enabled)
1638: IF G_DEBUG = 'Y' THEN
1639: AHL_DEBUG_PUB.disable_debug;
1640: END IF;
1641:
1642: EXCEPTION
1643:

Line 1656: AHL_DEBUG_PUB.disable_debug;

1652: );
1653:
1654: -- Disable debug (if enabled)
1655: IF G_DEBUG = 'Y' THEN
1656: AHL_DEBUG_PUB.disable_debug;
1657: END IF;
1658:
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660: ROLLBACK TO process_OPERATION_PVT;

Line 1671: AHL_DEBUG_PUB.disable_debug;

1667: );
1668:
1669: -- Disable debug (if enabled)
1670: IF G_DEBUG = 'Y' THEN
1671: AHL_DEBUG_PUB.disable_debug;
1672: END IF;
1673: WHEN OTHERS THEN
1674: ROLLBACK TO process_OPERATION_PVT;
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1694: AHL_DEBUG_PUB.disable_debug;

1690: );
1691:
1692: -- Disable debug (if enabled)
1693: IF G_DEBUG = 'Y' THEN
1694: AHL_DEBUG_PUB.disable_debug;
1695: END IF;
1696: END process_operation;
1697:
1698: PROCEDURE delete_operation

Line 1763: AHL_DEBUG_PUB.enable_debug;

1759: FND_MSG_PUB.initialize;
1760: END IF;
1761:
1762: IF G_DEBUG = 'Y' THEN
1763: AHL_DEBUG_PUB.enable_debug;
1764: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
1765: END IF;
1766:
1767: IF ( p_operation_id IS NULL OR

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

1760: END IF;
1761:
1762: IF G_DEBUG = 'Y' THEN
1763: AHL_DEBUG_PUB.enable_debug;
1764: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
1765: END IF;
1766:
1767: IF ( p_operation_id IS NULL OR
1768: p_operation_id = FND_API.G_MISS_NUM OR

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

1831: RAISE;
1832: END;
1833:
1834: IF G_DEBUG = 'Y' THEN
1835: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting AHL_OPERATIONS_B and AHL_OPERATIONS_TL' );
1836: END IF;
1837:
1838: -- Delete all the associations
1839:

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

1848: NULL;
1849: END IF;
1850:
1851: IF G_DEBUG = 'Y' THEN
1852: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Material Requirements' );
1853: END IF;
1854:
1855: -- 2.Delete Resource Requirements
1856: DELETE AHL_RT_OPER_RESOURCES

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

1863: NULL;
1864: END IF;
1865:
1866: IF G_DEBUG = 'Y' THEN
1867: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Resource Requirements' );
1868: END IF;
1869:
1870: -- 3.Delete Reference Documents
1871: FOR I in get_doc_associations( p_operation_id ) LOOP

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

1875: );
1876: END LOOP;
1877:
1878: IF G_DEBUG = 'Y' THEN
1879: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Reference Documents' );
1880: END IF;
1881:
1882: -- 4.Delete Associated Operations
1883: DELETE AHL_ROUTE_OPERATIONS

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

1889: NULL;
1890: END IF;
1891:
1892: IF G_DEBUG = 'Y' THEN
1893: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Associated Operations' );
1894: END IF;
1895:
1896: -- 5.Delete Access Panels associated
1897: DELETE AHL_RT_OPER_ACCESS_PANELS

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

1904: NULL;
1905: END IF;
1906:
1907: IF G_DEBUG = 'Y' THEN
1908: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Access Panels' );
1909: END IF;
1910:
1911: -- Perform the Commit (if requested)
1912: IF FND_API.to_boolean( p_commit ) THEN

Line 1926: AHL_DEBUG_PUB.disable_debug;

1922: );
1923:
1924: -- Disable debug (if enabled)
1925: IF G_DEBUG = 'Y' THEN
1926: AHL_DEBUG_PUB.disable_debug;
1927: END IF;
1928: EXCEPTION
1929:
1930: WHEN FND_API.G_EXC_ERROR THEN

Line 1942: AHL_DEBUG_PUB.disable_debug;

1938: );
1939:
1940: -- Disable debug (if enabled)
1941: IF G_DEBUG = 'Y' THEN
1942: AHL_DEBUG_PUB.disable_debug;
1943: END IF;
1944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1945: ROLLBACK TO delete_OPERATION_PVT;
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1956: AHL_DEBUG_PUB.disable_debug;

1952: );
1953:
1954: -- Disable debug (if enabled)
1955: IF G_DEBUG = 'Y' THEN
1956: AHL_DEBUG_PUB.disable_debug;
1957: END IF;
1958: WHEN OTHERS THEN
1959: ROLLBACK TO delete_OPERATION_PVT;
1960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1979: AHL_DEBUG_PUB.disable_debug;

1975: );
1976:
1977: -- Disable debug (if enabled)
1978: IF G_DEBUG = 'Y' THEN
1979: AHL_DEBUG_PUB.disable_debug;
1980: END IF;
1981: END delete_operation;
1982:
1983: PROCEDURE create_oper_revision

Line 2113: AHL_DEBUG_PUB.enable_debug;

2109: FND_MSG_PUB.initialize;
2110: END IF;
2111:
2112: IF G_DEBUG = 'Y' THEN
2113: AHL_DEBUG_PUB.enable_debug;
2114: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
2115: END IF;
2116:
2117: IF ( p_operation_id IS NULL OR

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

2110: END IF;
2111:
2112: IF G_DEBUG = 'Y' THEN
2113: AHL_DEBUG_PUB.enable_debug;
2114: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
2115: END IF;
2116:
2117: IF ( p_operation_id IS NULL OR
2118: p_operation_id = FND_API.G_MISS_NUM OR

Line 2678: AHL_DEBUG_PUB.disable_debug;

2674: );
2675:
2676: -- Disable debug (if enabled)
2677: IF G_DEBUG = 'Y' THEN
2678: AHL_DEBUG_PUB.disable_debug;
2679: END IF;
2680: EXCEPTION
2681:
2682: WHEN FND_API.G_EXC_ERROR THEN

Line 2694: AHL_DEBUG_PUB.disable_debug;

2690: );
2691:
2692: -- Disable debug (if enabled)
2693: IF G_DEBUG = 'Y' THEN
2694: AHL_DEBUG_PUB.disable_debug;
2695: END IF;
2696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2697: ROLLBACK TO create_oper_revision_PVT;
2698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2708: AHL_DEBUG_PUB.disable_debug;

2704: );
2705:
2706: -- Disable debug (if enabled)
2707: IF G_DEBUG = 'Y' THEN
2708: AHL_DEBUG_PUB.disable_debug;
2709: END IF;
2710: WHEN OTHERS THEN
2711: ROLLBACK TO create_oper_revision_PVT;
2712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2731: AHL_DEBUG_PUB.disable_debug;

2727: );
2728:
2729: -- Disable debug (if enabled)
2730: IF G_DEBUG = 'Y' THEN
2731: AHL_DEBUG_PUB.disable_debug;
2732: END IF;
2733: END create_oper_revision;
2734:
2735: END AHL_RM_OPERATION_PVT;