DBA Data[Home] [Help]

APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_DEBUG_PUB

Line 6: G_DEBUG VARCHAR2(30) :=AHL_DEBUG_PUB.is_log_enabled;

2: /* $Header: AHLVMREB.pls 120.3.12020000.2 2012/12/14 09:31:47 shnatu ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) :='AHL_FMP_MR_EFFECTIVITY_PVT';
5: G_API_NAME VARCHAR2(30) :='PROCESS_EFFECTIVITY';
6: G_DEBUG VARCHAR2(30) :=AHL_DEBUG_PUB.is_log_enabled;
7: G_APPLN_USAGE VARCHAR2(30) :=ltrim(rtrim(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
8:
9: -- Function to get the Record Identifier for Error Messages
10: FUNCTION get_record_identifier

Line 96: AHL_DEBUG_PUB.debug('MR_HEADER_ID is null to validate_api_inputs' );

92: FND_MSG_PUB.add;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: RETURN;
95: IF G_DEBUG = 'Y' THEN
96: AHL_DEBUG_PUB.debug('MR_HEADER_ID is null to validate_api_inputs' );
97: END IF;
98: END IF;
99: -- Check Profile value
100:

Line 106: AHL_DEBUG_PUB.debug('APPLN USAGE CODE IS NULL IN VALIDATE_API_INPUTS' );

102: THEN
103: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
104: FND_MSG_PUB.ADD;
105: IF G_DEBUG = 'Y' THEN
106: AHL_DEBUG_PUB.debug('APPLN USAGE CODE IS NULL IN VALIDATE_API_INPUTS' );
107: END IF;
108: END IF;
109:
110: IF ( G_APPLN_USAGE = 'PM' ) THEN

Line 148: AHL_DEBUG_PUB.debug('Error here.....'||L_ERROR_CODE);

144: );
145: END IF;
146:
147: IF l_error_code is not null THEN
148: AHL_DEBUG_PUB.debug('Error here.....'||L_ERROR_CODE);
149: FND_MESSAGE.set_name( 'AHL', l_error_code );
150: FND_MSG_PUB.add;
151: RETURN;
152: END IF;

Line 1374: AHL_DEBUG_PUB.enable_debug;

1370: END IF;
1371:
1372: -- Enable Debug (optional)
1373: IF ( G_DEBUG = 'Y' ) THEN
1374: AHL_DEBUG_PUB.enable_debug;
1375: END IF;
1376:
1377: IF G_DEBUG = 'Y' THEN
1378: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Begin API' );

Line 1378: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Begin API' );

1374: AHL_DEBUG_PUB.enable_debug;
1375: END IF;
1376:
1377: IF G_DEBUG = 'Y' THEN
1378: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Begin API' );
1379: END IF;
1380:
1381: -- Get the Application Code
1382:

Line 1385: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_appln_usage );

1381: -- Get the Application Code
1382:
1383:
1384: IF G_DEBUG = 'Y' THEN
1385: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_appln_usage );
1386: END IF;
1387:
1388: -- Validate all the inputs of the API
1389: AHL_DEBUG_PUB.debug('Before Validate inputs ' );

Line 1389: AHL_DEBUG_PUB.debug('Before Validate inputs ' );

1385: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_appln_usage );
1386: END IF;
1387:
1388: -- Validate all the inputs of the API
1389: AHL_DEBUG_PUB.debug('Before Validate inputs ' );
1390: validate_api_inputs
1391: (
1392: p_x_effectivity_tbl, -- IN
1393: p_mr_header_id, -- IN

Line 1400: AHL_DEBUG_PUB.debug('After validate with error ' );

1396: p_super_user
1397: );
1398: l_msg_count := FND_MSG_PUB.count_msg;
1399: IF l_msg_count > 0 THEN
1400: AHL_DEBUG_PUB.debug('After validate with error ' );
1401: x_msg_count := l_msg_count;
1402: RAISE FND_API.G_EXC_ERROR;
1403: END IF;
1404:

Line 1406: AHL_DEBUG_PUB.debug('After validate with no error ' );

1402: RAISE FND_API.G_EXC_ERROR;
1403: END IF;
1404:
1405:
1406: AHL_DEBUG_PUB.debug('After validate with no error ' );
1407:
1408: -- If any severe error occurs, then, abort API.
1409:
1410: IF G_DEBUG = 'Y' THEN

Line 1411: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_api_inputs' );

1407:
1408: -- If any severe error occurs, then, abort API.
1409:
1410: IF G_DEBUG = 'Y' THEN
1411: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_api_inputs' );
1412: END IF;
1413:
1414: -- If the module type is JSP, then default values for ID columns of LOV attributes
1415: IF ( p_module_type = 'JSP' ) THEN

Line 1447: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after convert_values_to_ids' );

1443: END LOOP;
1444: END IF;
1445:
1446: IF G_DEBUG = 'Y' THEN
1447: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after convert_values_to_ids' );
1448: END IF;
1449:
1450: -- Default effectivity attributes.
1451: FOR i IN 1..p_x_effectivity_tbl.count LOOP

Line 1461: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_attributes' );

1457: END IF;
1458: END LOOP;
1459:
1460: IF G_DEBUG = 'Y' THEN
1461: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_attributes' );
1462: END IF;
1463:
1464: -- Validate all attributes (Item level validation)
1465: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

Line 1483: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_attributes' );

1479: END LOOP;
1480: END IF;
1481:
1482: IF G_DEBUG = 'Y' THEN
1483: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_attributes' );
1484: END IF;
1485:
1486: -- Default missing and unchanged attributes.
1487: FOR i IN 1..p_x_effectivity_tbl.count LOOP

Line 1502: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_unchanged_attributes / default_missing_attributes' );

1498: END IF;
1499: END LOOP;
1500:
1501: IF G_DEBUG = 'Y' THEN
1502: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_unchanged_attributes / default_missing_attributes' );
1503: END IF;
1504:
1505: -- Perform cross attribute validation and missing attribute checks (Record level validation)
1506: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

Line 1530: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_record' );

1526: END LOOP;
1527: END IF;
1528:
1529: IF G_DEBUG = 'Y' THEN
1530: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_record' );
1531: END IF;
1532:
1533: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1534: l_msg_count := FND_MSG_PUB.count_msg;

Line 1544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : dml operation is - ' || p_x_effectivity_tbl(i).dml_operation );

1540: -- Perform the DML statement directly.
1541: FOR i IN 1..p_x_effectivity_tbl.count LOOP
1542:
1543: IF G_DEBUG = 'Y' THEN
1544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : dml operation is - ' || p_x_effectivity_tbl(i).dml_operation );
1545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : fleet header id is - ' || p_x_effectivity_tbl(i).fleet_header_id );
1546: end if;
1547:
1548: IF ( p_x_effectivity_tbl(i).dml_operation = 'C' ) THEN

Line 1545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : fleet header id is - ' || p_x_effectivity_tbl(i).fleet_header_id );

1541: FOR i IN 1..p_x_effectivity_tbl.count LOOP
1542:
1543: IF G_DEBUG = 'Y' THEN
1544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : dml operation is - ' || p_x_effectivity_tbl(i).dml_operation );
1545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : fleet header id is - ' || p_x_effectivity_tbl(i).fleet_header_id );
1546: end if;
1547:
1548: IF ( p_x_effectivity_tbl(i).dml_operation = 'C' ) THEN
1549:

Line 1725: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML operation' );

1721: END LOOP;
1722:
1723:
1724: IF G_DEBUG = 'Y' THEN
1725: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML operation' );
1726: END IF;
1727:
1728: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1729: l_msg_count := FND_MSG_PUB.count_msg;

Line 1738: AHL_DEBUG_PUB.debug( 'Before Validate Records ' );

1734:
1735: -- Perform cross records validations and duplicate records check
1736:
1737: IF G_DEBUG = 'Y' THEN
1738: AHL_DEBUG_PUB.debug( 'Before Validate Records ' );
1739: END IF;
1740:
1741: validate_records
1742: (

Line 1750: AHL_DEBUG_PUB.debug( 'After Validate Records ' );

1746: );
1747:
1748:
1749: IF G_DEBUG = 'Y' THEN
1750: AHL_DEBUG_PUB.debug( 'After Validate Records ' );
1751: END IF;
1752:
1753:
1754: -- If any severe error occurs, then, abort API.

Line 1762: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records' );

1758: RAISE FND_API.G_EXC_ERROR;
1759: END IF;
1760:
1761: IF G_DEBUG = 'Y' THEN
1762: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records' );
1763: END IF;
1764:
1765: -- Perform the Commit (if requested)
1766: IF FND_API.to_boolean( p_commit ) THEN

Line 1780: AHL_DEBUG_PUB.disable_debug;

1776: );
1777:
1778: -- Disable debug (if enabled)
1779: IF ( G_DEBUG = 'Y' ) THEN
1780: AHL_DEBUG_PUB.disable_debug;
1781: END IF;
1782:
1783: EXCEPTION
1784:

Line 1797: AHL_DEBUG_PUB.disable_debug;

1793: );
1794:
1795: -- Disable debug (if enabled)
1796: IF ( G_DEBUG = 'Y' ) THEN
1797: AHL_DEBUG_PUB.disable_debug;
1798: END IF;
1799:
1800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1801: ROLLBACK TO process_effectivity_PVT;

Line 1812: AHL_DEBUG_PUB.disable_debug;

1808: );
1809:
1810: -- Disable debug (if enabled)
1811: IF ( G_DEBUG = 'Y' ) THEN
1812: AHL_DEBUG_PUB.disable_debug;
1813: END IF;
1814:
1815: WHEN OTHERS THEN
1816: ROLLBACK TO process_effectivity_PVT;

Line 1835: AHL_DEBUG_PUB.disable_debug;

1831: p_data => x_msg_data
1832: );
1833: -- Disable debug (if enabled)
1834: IF ( G_DEBUG = 'Y' ) THEN
1835: AHL_DEBUG_PUB.disable_debug;
1836: END IF;
1837:
1838: END process_effectivity;
1839: