1432: x_operation_id => p_x_operation_rec.operation_id,
1433: x_return_status => x_return_status
1434: );
1435: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1436: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1437: fnd_log.string
1438: (
1439: fnd_log.level_error,
1440: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1433: x_return_status => x_return_status
1434: );
1435: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1436: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1437: fnd_log.string
1438: (
1439: fnd_log.level_error,
1440: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1441: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1435: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1436: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1437: fnd_log.string
1438: (
1439: fnd_log.level_error,
1440: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1441: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1442: );
1443: END IF;
1703: IF ( SQLCODE = -1 ) THEN
1704: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
1705: FND_MSG_PUB.add;
1706: ELSE
1707: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1708: THEN
1709: fnd_log.string
1710: (
1711: fnd_log.level_unexpected,
1705: FND_MSG_PUB.add;
1706: ELSE
1707: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1708: THEN
1709: fnd_log.string
1710: (
1711: fnd_log.level_unexpected,
1712: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
1713: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1707: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1708: THEN
1709: fnd_log.string
1710: (
1711: fnd_log.level_unexpected,
1712: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
1713: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1714: );
1715: END IF;
1797: IF ( SQLCODE = -1 ) THEN
1798: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
1799: FND_MSG_PUB.add;
1800: ELSE
1801: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1802: THEN
1803: fnd_log.string
1804: (
1805: fnd_log.level_unexpected,
1799: FND_MSG_PUB.add;
1800: ELSE
1801: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1802: THEN
1803: fnd_log.string
1804: (
1805: fnd_log.level_unexpected,
1806: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
1807: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1801: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1802: THEN
1803: fnd_log.string
1804: (
1805: fnd_log.level_unexpected,
1806: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
1807: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1808: );
1809: END IF;
2462: IF ( SQLCODE = -1 ) THEN
2463: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
2464: FND_MSG_PUB.add;
2465: ELSE
2466: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2467: THEN
2468: fnd_log.string
2469: (
2470: fnd_log.level_unexpected,
2464: FND_MSG_PUB.add;
2465: ELSE
2466: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2467: THEN
2468: fnd_log.string
2469: (
2470: fnd_log.level_unexpected,
2471: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
2472: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
2466: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2467: THEN
2468: fnd_log.string
2469: (
2470: fnd_log.level_unexpected,
2471: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
2472: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
2473: );
2474: END IF;