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 2008/03/24 08:10:51 pdoki 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 88: AHL_DEBUG_PUB.debug('MR_HEADER_ID is null to validate_api_inputs' );

84: FND_MSG_PUB.add;
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: RETURN;
87: IF G_DEBUG = 'Y' THEN
88: AHL_DEBUG_PUB.debug('MR_HEADER_ID is null to validate_api_inputs' );
89: END IF;
90: END IF;
91: -- Check Profile value
92:

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

94: THEN
95: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
96: FND_MSG_PUB.ADD;
97: IF G_DEBUG = 'Y' THEN
98: AHL_DEBUG_PUB.debug('APPLN USAGE CODE IS NULL IN VALIDATE_API_INPUTS' );
99: END IF;
100: END IF;
101:
102: IF ( G_APPLN_USAGE = 'PM' ) THEN

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

136: );
137: END IF;
138:
139: IF l_error_code is not null THEN
140: AHL_DEBUG_PUB.debug('Error here.....'||L_ERROR_CODE);
141: FND_MESSAGE.set_name( 'AHL', l_error_code );
142: FND_MSG_PUB.add;
143: RETURN;
144: END IF;

Line 1289: AHL_DEBUG_PUB.enable_debug;

1285: END IF;
1286:
1287: -- Enable Debug (optional)
1288: IF ( G_DEBUG = 'Y' ) THEN
1289: AHL_DEBUG_PUB.enable_debug;
1290: END IF;
1291:
1292: IF G_DEBUG = 'Y' THEN
1293: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Begin API' );

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

1289: AHL_DEBUG_PUB.enable_debug;
1290: END IF;
1291:
1292: IF G_DEBUG = 'Y' THEN
1293: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Begin API' );
1294: END IF;
1295:
1296: -- Get the Application Code
1297:

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

1296: -- Get the Application Code
1297:
1298:
1299: IF G_DEBUG = 'Y' THEN
1300: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_appln_usage );
1301: END IF;
1302:
1303: -- Validate all the inputs of the API
1304: AHL_DEBUG_PUB.debug('Before Validate inputs ' );

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

1300: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_appln_usage );
1301: END IF;
1302:
1303: -- Validate all the inputs of the API
1304: AHL_DEBUG_PUB.debug('Before Validate inputs ' );
1305: validate_api_inputs
1306: (
1307: p_x_effectivity_tbl, -- IN
1308: p_mr_header_id, -- IN

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

1311: p_super_user
1312: );
1313: l_msg_count := FND_MSG_PUB.count_msg;
1314: IF l_msg_count > 0 THEN
1315: AHL_DEBUG_PUB.debug('After validate with error ' );
1316: x_msg_count := l_msg_count;
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319:

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

1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319:
1320:
1321: AHL_DEBUG_PUB.debug('After validate with no error ' );
1322:
1323: -- If any severe error occurs, then, abort API.
1324:
1325: IF G_DEBUG = 'Y' THEN

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

1322:
1323: -- If any severe error occurs, then, abort API.
1324:
1325: IF G_DEBUG = 'Y' THEN
1326: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_api_inputs' );
1327: END IF;
1328:
1329: -- If the module type is JSP, then default values for ID columns of LOV attributes
1330: IF ( p_module_type = 'JSP' ) THEN

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

1358: END LOOP;
1359: END IF;
1360:
1361: IF G_DEBUG = 'Y' THEN
1362: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after convert_values_to_ids' );
1363: END IF;
1364:
1365: -- Default effectivity attributes.
1366: FOR i IN 1..p_x_effectivity_tbl.count LOOP

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

1372: END IF;
1373: END LOOP;
1374:
1375: IF G_DEBUG = 'Y' THEN
1376: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_attributes' );
1377: END IF;
1378:
1379: -- Validate all attributes (Item level validation)
1380: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

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

1394: END LOOP;
1395: END IF;
1396:
1397: IF G_DEBUG = 'Y' THEN
1398: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_attributes' );
1399: END IF;
1400:
1401: -- Default missing and unchanged attributes.
1402: FOR i IN 1..p_x_effectivity_tbl.count LOOP

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

1413: END IF;
1414: END LOOP;
1415:
1416: IF G_DEBUG = 'Y' THEN
1417: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_unchanged_attributes / default_missing_attributes' );
1418: END IF;
1419:
1420: -- Perform cross attribute validation and missing attribute checks (Record level validation)
1421: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

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

1441: END LOOP;
1442: END IF;
1443:
1444: IF G_DEBUG = 'Y' THEN
1445: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_record' );
1446: END IF;
1447:
1448: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1449: l_msg_count := FND_MSG_PUB.count_msg;

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

1627: END LOOP;
1628:
1629:
1630: IF G_DEBUG = 'Y' THEN
1631: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML operation' );
1632: END IF;
1633:
1634: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1635: l_msg_count := FND_MSG_PUB.count_msg;

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

1640:
1641: -- Perform cross records validations and duplicate records check
1642:
1643: IF G_DEBUG = 'Y' THEN
1644: AHL_DEBUG_PUB.debug( 'Before Validate Records ' );
1645: END IF;
1646:
1647: validate_records
1648: (

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

1652: );
1653:
1654:
1655: IF G_DEBUG = 'Y' THEN
1656: AHL_DEBUG_PUB.debug( 'After Validate Records ' );
1657: END IF;
1658:
1659:
1660: -- If any severe error occurs, then, abort API.

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

1664: RAISE FND_API.G_EXC_ERROR;
1665: END IF;
1666:
1667: IF G_DEBUG = 'Y' THEN
1668: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records' );
1669: END IF;
1670:
1671: -- Perform the Commit (if requested)
1672: IF FND_API.to_boolean( p_commit ) THEN

Line 1686: AHL_DEBUG_PUB.disable_debug;

1682: );
1683:
1684: -- Disable debug (if enabled)
1685: IF ( G_DEBUG = 'Y' ) THEN
1686: AHL_DEBUG_PUB.disable_debug;
1687: END IF;
1688:
1689: EXCEPTION
1690:

Line 1703: AHL_DEBUG_PUB.disable_debug;

1699: );
1700:
1701: -- Disable debug (if enabled)
1702: IF ( G_DEBUG = 'Y' ) THEN
1703: AHL_DEBUG_PUB.disable_debug;
1704: END IF;
1705:
1706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1707: ROLLBACK TO process_effectivity_PVT;

Line 1718: AHL_DEBUG_PUB.disable_debug;

1714: );
1715:
1716: -- Disable debug (if enabled)
1717: IF ( G_DEBUG = 'Y' ) THEN
1718: AHL_DEBUG_PUB.disable_debug;
1719: END IF;
1720:
1721: WHEN OTHERS THEN
1722: ROLLBACK TO process_effectivity_PVT;

Line 1741: AHL_DEBUG_PUB.disable_debug;

1737: p_data => x_msg_data
1738: );
1739: -- Disable debug (if enabled)
1740: IF ( G_DEBUG = 'Y' ) THEN
1741: AHL_DEBUG_PUB.disable_debug;
1742: END IF;
1743:
1744: END process_effectivity;
1745: