1304: x_operation_id => p_x_operation_rec.operation_id,
1305: x_return_status => x_return_status
1306: );
1307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1308: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1309: fnd_log.string
1310: (
1311: fnd_log.level_error,
1312: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1305: x_return_status => x_return_status
1306: );
1307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1308: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1309: fnd_log.string
1310: (
1311: fnd_log.level_error,
1312: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1313: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1308: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1309: fnd_log.string
1310: (
1311: fnd_log.level_error,
1312: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1313: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1314: );
1315: END IF;
1510: IF ( SQLCODE = -1 ) THEN
1511: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
1512: FND_MSG_PUB.add;
1513: ELSE
1514: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1515: THEN
1516: fnd_log.string
1517: (
1518: fnd_log.level_unexpected,
1512: FND_MSG_PUB.add;
1513: ELSE
1514: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1515: THEN
1516: fnd_log.string
1517: (
1518: fnd_log.level_unexpected,
1519: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
1520: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1514: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1515: THEN
1516: fnd_log.string
1517: (
1518: fnd_log.level_unexpected,
1519: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
1520: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1521: );
1522: END IF;
1595: IF ( SQLCODE = -1 ) THEN
1596: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
1597: FND_MSG_PUB.add;
1598: ELSE
1599: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1600: THEN
1601: fnd_log.string
1602: (
1603: fnd_log.level_unexpected,
1597: FND_MSG_PUB.add;
1598: ELSE
1599: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1600: THEN
1601: fnd_log.string
1602: (
1603: fnd_log.level_unexpected,
1604: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
1605: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1599: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1600: THEN
1601: fnd_log.string
1602: (
1603: fnd_log.level_unexpected,
1604: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
1605: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1606: );
1607: END IF;
2254: IF ( SQLCODE = -1 ) THEN
2255: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
2256: FND_MSG_PUB.add;
2257: ELSE
2258: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2259: THEN
2260: fnd_log.string
2261: (
2262: fnd_log.level_unexpected,
2256: FND_MSG_PUB.add;
2257: ELSE
2258: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2259: THEN
2260: fnd_log.string
2261: (
2262: fnd_log.level_unexpected,
2263: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
2264: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
2258: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2259: THEN
2260: fnd_log.string
2261: (
2262: fnd_log.level_unexpected,
2263: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
2264: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
2265: );
2266: END IF;